Course Summery

FORMATTING
FORMULAS
CELL REFERENCES
PAGE SETUP
FORMULA INPUTS AND CHARTS
BASIC EXCEL FUNCTIONS
PIVOT TABLES TO CREATE SUMMARY REPORTS
KEYBOARD SHORTCUTS
DATA ALIGNMENT
NUMBER FORMATTING
IF and IS FUNCTION
VLOOKUP & HLOOKUP FUNCTION AND RELATIONSHIPS
TABLES
MIXED CELL REFERENCES
STYLE FORMATTING
SORTING
FILTERING
FLASH FILLING DATA
CHARTS AND GRAPHS
POWER QUERY BASICS