This master MS Excel course is for anyone who needs to take their Excel skills to the next level. We assume learners will already be familiar with using a keyboard, mouse, computer and assistive technology. By the end of this course you will be able to use
Financial functions such as PMT, FV, PV and Rate
Lookup and Reference Functions such as Match, Index, Offset, Filter and Sort
Pivot Tables and Charts
Documenting and Auditing and manipulating Data including Sorting, Compare and Merge and Flash Fill. Lastly automating repetitive tasks with Macros.
This course also covers the desktop and web versions.
Estimated Course duration is 3 - 4 hours. Each lesson take on average 3-5 minutes to complete
Course Content
string(4) "3363"
Financial Functions
PMT Function
FV and PV Functions
Rate Function
Lookup and Reference Functions
Combining MATCH with INDEX
Combining LOOKUP and MATCH
Using Lookup Functions with Named Ranges
OFFSET Function
FILTER Function
SORT Function
Pivot Tables and Pivot Charts
Working with Pivot Tables
Rearranging Pivot Tables
Slicers
Formatting Pivot Tables
Pivot Charts
Using GETPIVOTDATA with Pivot Tables
Documenting and Auditing
Formula Errors
Evaluating Formulas
Using the Watch Window
Using Comments
Data Validation
Workbook Co-Authoring
Displaying and Printing Formulas
Manipulating Data
Sorting by Values
Sorting by Formatting
Advanced Sorting Features
Converting Text to Columns
Compare and Merge Data
Flash Fill
Automating Repetitive Tasks NEW
Explaining Macros
Macros Security levels
Recording Macros
Running Macros
Assigning Macros to the QAT
Introduction to Power Query NEW
Analytical Options
Goal Seek
Solver
Quick Analysis Tool
Scenarios
Data Tables
One Input variable
Two Input Variable
Use the X inside a lesson to save your progress. Then click Continue
