- This course will teach you level 3 Excel skills.
Course Outline
Lesson 1. Work with Multiple Worksheets
Multiple Sheets
Renaming Sheets
Using the Clipboard Group
Insert and Delete Sheets
Copy and Move Sheets
Worksheet Groups
Applying formulas across sheets
Lesson 2. Prepare and produce a spreadsheet
Name ranges
Working with named ranges
Deleting a named range
Creating names from a selection
Using Paste Special
Working with Links
Editing Links
Worksheet Protection
Lesson 3. 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
Lesson 4. Advanced Functions
Database Functions
Lookup Functions
Logical Functions
Text Functions
Lesson 5. Customising Microsoft Excel
Setting Excel Options
Excel Add-ins
Customising the Quick Access toolbar
Lesson 6. Working with charts
Why do we use charts/graphs?
Chart terminology
Creating a chart
Creating a chart using Insert
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
Lesson 7. PivotTables
Working with Excel Tables
Understanding a Pivot Table
Data for a Pivot table
Creating a Pivot table
Add, copy, rearrange, and remove fields
Add a calculated field
Using the Pivot table filters
Changing Pivot table filters
Modifying the Pivot Table placement
Change Active Field settings
Pivot Table options
Change the Pivot Table layout
Change the Pivot Table design
Change the Pivot Table Tools design style options
Crating Pivot Charts
Insert Slicers
Deleting a Pivot table report or chart
Lesson 8. Macros
Understanding Macros
Developer Tab
Macro Security levels
Trusted locations
Recording a macro
Running Macros
Assigning Macros to Objects
