Excel Mastery Course

Formulas and Functions

• Creating simple formulas
• Creating a percentage-increase formula
• Working with relative, absolute, and mixed references
• Using other common functions
• Formulas and functions assignment
• Formulas and functions quiz

Database Features

• Sorting data
• Inserting subtotals in a sorted list
• Using filters
• Splitting data into multiple columns
• Removing duplicate records
• Database features assignment
• Database features quiz

Data Analysis

• Using Goal Seek
• Using Solver
• Using Scenario Manager
• Using Data Tables
• Data analysis assignment
• Data analysis quiz

IF, VLOOKUP and Power Functions

• Using IF functions and relational operators
• Getting table data with the VLOOKUP function
• Using the COUNTIF family of functions
• Power Functions assignment
• Power Functions quiz

Introduction to Macros

• What are Macros and what are they used for?
• Creating a Macro
• Running a Macro
• Macros assignment
• Macros quiz

PivotTables

• Creating PivotTables
• Manipulating PivotTable data
• Grouping PivotTable data
• Using PivotCharts
• PivotTables assignment
• PivotTables quiz

Excel Mastery Final Exam!