Understanding MS Excel - Advanced
- Home
- Understanding MS Excel - Advanced
2 day PRACTICAL course
Understanding MS Excel - Advanced
What is it about?
This programme will help you to unlock the full potential of one of the most powerful business tools at your disposal – helping you to stand out from your colleagues, improving the quality of your analysis and decisions and assisting in your own professional development.
MS Excel is a powerful business tool that should be used by every person in an organisation to store, analyse and present data in order to make better business and managerial decisions. Most people don’t even scratch the surface of the use of MS Excel. This course ensures you become more productive and self-reliant by mastering the world’s most popular productivity tool!
Content
Prepare and produce a Spreadsheet
- Work with Multiple Worksheets
- Multiple Sheets
- Renaming Sheets
- Insert and Delete Sheets
- Copy and Move Sheets
- Worksheet Groups
- Applying formulas across sheets
- Prepare and produce a spreadsheet
- Naming ranges
- Working with named ranges
- Deleting a named range
- Creating names from a selection
- Using the Clipboard Group
- Using Paste Special
- Working with Links
- Editing Links
- Worksheet Protection
Pivot Tables
- Understanding Pivot tables
- Creating a Pivot table
- Add, copy, rearrange, and remove fields
- Add a calculated field
- Using the Pivot table filters
- Changing Pivot table data
- Modifying the Pivot Table placement
- Change Active Field settings
- Change Pivot Table options
- Change the Pivot Table layout
- Change the Pivot Table design
- Change the Pivot Table Tools design style options
- Insert Slicers for your Pivot table
- Creating Pivot Charts
Data Commands
- Sorting and filtering data
- Validation
- Subtotals
- Grouping and Outlining
- Using the Consolidate command
- Working with Advanced Filters
- Working with External Data
- Importing data from a text file
- Converting Text to Columns
- Working with a data form
Working with Charts
- Why do we use charts/graphs
- Chart terminology
- Creating a chart
- Setting or changing the chart type
- Chart Titles
- Chart Location
- Moving, Resizing and Deleting charts as Objects
- Formatting a chart
- Printing charts
- Working with Sparklines
- Using the Drawing Tools and Pictures
Advanced Functions
- Database Functions
- Lookup Functions
- Logical Functions
- Text Functions
Macros
- Understanding Macros
- Developer Tab
- Macro Security levels
- Trusted locations
- Recording a macro
- Running Macros
- Assigning Macros to Objects
Customising Microsoft Excel
- Setting Excel Options
- Excel Add-ins
- Customising the Quick Access toolbar
