Microsoft Excel – Beginner, Intermediate & Advanced

The Microsoft Excel 2013 Beginner course is split into the following modules:

Introduction to Spreadsheets
Understanding Microsoft Excel
Excel Workbook Windows
Basic Spreadsheet Skills
Excel Help System
Opening and Closing Workbooks
Understanding Workbook File Formats
Creating New Workbooks
Selecting Cells
Auto Sum and Auto Fill Function
Cell Referencing and Request
Formatting Cells
Formatting Numbers
Placing Cell Alignment
Cell, Rows and Columns
Understanding Worksheets
Editing, Copying and Moving Cells
Page Layouts in Excel
Proofing Workbooks
Basic Options, Ribbons and Toolbar
Final Assessment

The Microsoft Excel 2013 Intermediate course is split into the following modules:

Introduction to Excel Spreadsheet Intermediate Level
Defining Names in Excel
Sorting Data
Using Excel Tables
Filtering Data in Excel
Understand Charts
Chart Design Options and Tools
Chart Format Tools
Combo Charts
Functions within Excel
Understanding Date Function
Information Functions
Logical Functions
Financial Functions
Find and Replace
Headers and Footers
Adding Comments
Conditional Formatting
Final Assessment

The Microsoft Excel 2013 Advanced course is split into the following modules:

Introduction to Excel Advanced
Using Text to Columns
The Paste Special Function
Data Validation
Subtotals and Grouping
Consolidating Data
Scenario Analysis
Data Tables in Scenario Analysis
What-if Analysis
Mats and Trig Functions
Text Functions in Excel
Using Lookup Functions
Vlookups
HLookups
Using Statistical Functions
Databse Functions
Formaula Auditing and Error Tracing
Hyperlinks in Excel
Linking Data
Understanding Pivot Tables
Using Pivot Charts
Workbook Properties
Protecting and Sharing Worksheets
Data Encrypting and Finalising Workbooks
Understanding to Macros
Custom Number Formats in Excel
Using Custom Lists
Working with Templates
Tracking Changes in Excel
Merging and Compare Excel Workbooks
Final Assessment