Microsoft Excel Level 3

Microsoft Excel Level 3 – Course Outline

​

About This Course

This one-day course is designed to build on the skills gained from attending Excel Level 2.

 

Delegates will learn to manage and summarise data files, perform multi-sheet and cross-book calculations and automate their workbooks.

 

Target Audience

Delegates should have previously attended the Level 2 course or have relevant knowledge of the software.

 

At Course Completion

After completing this course, students will be able to:

 

• Work with PivotTables

• Adding/removing passwords to open

• Adding/removing passwords to modify

• Protecting cells and worksheets

• Use Data Validation

• Use What-If Analysis: Goal Seek, Scenarios, Solver

• Trace errors in formulae

• Use Trace Dependents/Precedents

• Create macros and attaching to the Ribbon or a command button

 

Course Content

​

Unit 1 – Pivot Table Reports

• Create and manipulate a PivotTable

• PivotCharts

• Using Slicers

• PivotTable Timelines

• Add a Calculated Field

 

Unit 2 – File Handling

• Apply/remove a password to open

• Apply/remove a password to modify

• Protecting cells within a workbook

• Finding files

 

Unit 3 – Using Consolidation

• Combining data across several sheets

• Combining data across several workbooks

​

Unit 4 – Templates

• Create a template

• Use a template

• Edit a template

• Insert a template as a worksheet

 

Unit 5 – What-If Analysis

• What-If Tables

• Use Goal Seek

• Scenario Manager

• Solver overview

• Use the solver feature

​

Unit 6 – Conditional Formatting

• Validation Examples

• Creating Multi-Level Examples

• Validation Errors

 

Unit 7 – Macros and Custom Controls

• Record a macro

• Assign a macro to a shortcut key

• Run a macro using the tools macro command

• Attach macro to a button

• Format the text inside a button

 

Unit 8 – Auditing Worksheets

• Trace errors in formulae

• Using Trace Precedents and Dependents

 

Lesson 9 - Using the Watch Window

• Adding a Watch to a cell

• Adding a Watch to all the cells with Formulas

• Displaying a cell in the Watch Window

• Deleting a Watch

• Hiding the Watch Window

 

Unit 10 – Importing Data

• Import text into a worksheet

• Import data from a database

 

 

Course duration: one day