Microsoft Office Excel is a powerful and easy-to-use spreadsheet application

Nearly everyone who works with numbers has likely used Excel or some other spreadsheet application. 

​

INCLUDES:

Step by Step Lessons and Exercise Files

​

These lessons cover all the essentials of Microsoft Excel. Topics covered include the Flash Fill feature, using formulas and functions, inserting PivotTables and PivotCharts, and customising the interface.

Material is also included on how to format text, data, and workbooks; insert art and objects; and chart data.

Module 1: The Basics
 

Module 2: Your First Workbook
 

Module 3: Working with Data
 

Module 4: Using Basic Excel Tools
 

Module 5: Using Timesaving Tools
 

Module 6: Formatting Text
 

Module 7: Formatting Data
 

Module 8: Formatting the Workbook
 

Module 9: Inserting Art and Objects
 

Module 10: Charting Data
 

Module 11: Viewing, Printing, and Sharing Your Workbook
 

Module 12: Customising the Interface
 

​

INCLUDES:

Step by Step Lessons and Exercise Files

​

Microsoft Excel has lots of time-saving tools 

Do you know how to make the most of them? The lessons in these modules will show you how!

This advanced lessons cover a wide range of topics, including advanced formula tasks, working with named ranges, using advanced functions, resolving formula errors, managing data, outlining and grouping data, working with scenarios, using Solver, the Analysis ToolPak, PivotTable features, using PowerPivot, and developing macros.  

​

Module 1: Advanced Formula Tasks
 

Module 2: Working with Named Ranges
 

Module 3: Using Advanced Functions
 

Module 4: Resolving Formula Errors
 

Module 5: Managing Data
 

Module 6: Outlining and Grouping Data
 

Module 7: Working with Scenarios
 

Module 8: Using Solver
 

Module 9: Analysing Data
 

Module 10: Advanced PivotTable Features
 

Module 11: Using PowerPivot
 

Module 12: Using Macros

INCLUDES:

Step by Step Lessons and Exercise Files

These Microsoft Excel lessons take you on a journey that highlights the upper-level skills

Over the course of 12 modules, you will get a look at conditional formatting, slicers, Power View, the Inquire Add-In, tables, records and fields, using Excel as a database, custom AutoFill lists, comments, tracking changes, and linking, consolidating, and combining data.

Module 1: Using Conditional Formatting
 

Module 2: Working with Slicers
 

Module 3: Using Power View, Part One
 

Module 4: Using Power View, Part Two
 

Module 5: Using the Inquire Add-In
 

Module 6: Working with Tables
 

Module 7: Working with Records and Fields
 

Module 8: Using Excel as a Database
 

Module 9: Using Custom AutoFill Lists
 

Module 10: Using Comments
 

Module 11: Tracking Changes
 

Module 12: Linking, Consolidating, and Combining Data

​