Microsoft Excel Courses
Excel is the market leader in spreadsheets. It can track your expenses, create fantastic charts and help with complex analysis of data. We have three levels of Excel.
All levels can be customised or combined to suit your requirements or we can write a course specifically for you! (Standard course outlines are for a one-day course.)
PDF versions of the Course Outlines are available – contact us.
Excel Level 1
Lesson 1: Getting Started with Excel
- Identify the Elements of the Excel Interface
- Navigate and Select Cells in Worksheets
- Customise the Excel Interface
- Create a Basic Worksheet
Lesson 2: Performing Calculations in an Excel Worksheet
- Create Formulas in a Worksheet
- Insert Functions in a Worksheet
- Reuse Formulas
Lesson 3: Modifying a Worksheet
- Edit Worksheet Data
- Find and Replace Data
- Manipulate Worksheet Elements
Lesson 4: Modifying the Appearance of a Worksheet
- Apply Font Properties
- Add Borders and Colours to Cells
- Align Content in a Cell
- Apply Number Formatting
- Apply Cell Styles
Lesson 5: Managing an Excel Workbook
- Manage Worksheets
- View Worksheets and Workbooks
Lesson 6: Printing Excel Workbooks
- Define the Page Layout
- Print a Workbook
Excel Level 2
Lesson 1: Calculating Data with Advanced Formulas
- Apply Cell and Range Names
- Calculate Data Across Worksheets
- Use Specialised Functions
- Analyse Data with Logical and Lookup Functions
Lesson 2: Organizing Worksheet and Table Data
- Create and Modify Tables
- Format Tables
- Sort or Filter Data
- Use Functions to Calculate Data
Lesson 3: Presenting Data Using Charts
- Create a Chart
- Modify Charts
- Format Charts
Lesson 4: Analyzing Data Using PivotTables, Slicers, and PivotCharts
- Create a PivotTable Report
- Filter Data Using Slicers
- Analyse Data Using PivotCharts
Lesson 5: Inserting Graphic Objects
- Insert and Modify Pictures and ClipArt
- Draw and Modify Shapes
- Illustrate Workflow Using SmartArt Graphics
- Layer and Group Graphic Objects
Lesson 6: Customizing and Enhancing the Excel Environment
- Customise the Excel Environment
- Customise Workbooks
- Manage Themes
- Create and Use Templates
Excel Level 3
Lesson 1: Streamlining Workflow
- Create a Macro
- Edit a Macro
- Apply Conditional Formatting
- Add Data Validation Criteria
Lesson 2: Collaborating with Other Users
- Protect Files
- Password Protecting Workbooks
- Set Revision Tracking
- Review Tracked Revisions
Lesson 3: Auditing Worksheets
- Trace Cells
- Troubleshoot Invalid Data and Formula Errors
- Watch and Evaluate Formulas
- Create a Data List Outline
Lesson 4: Analysing Data
- Create a Trendline
- Create Sparklines
- Create Scenarios
- Perform a What-If Analysis
Lesson 5: Working with Multiple Workbooks
- Consolidate Data
- Link Cells in Different Workbooks
- Edit Links