What You Can Enter Into Excel
Combined What you can enter in a cell
Relative and Absolute Cell Referencing
Entering Formula
Order of Operations
Date Serial Numbers
Sheets, Rows and Columns
Copy and Drag
Working with rows and columns
Working with sheets
Functions, Ranges and Shortcuts
Functions
SUM Function
Copy and Drag Formula
more basic functions
Named Ranges
Names Constants and Formula
Shortcuts
More Shortcuts
Formatting and Conditional Formatting
Formatting Font
Formatting Alignment
Formatting Borders
Formatting Numbers
Conditional Formatting PreConfigured
Conditional Formatting with Formula
Conditional Formatting Dialogue Box Formula Trick
Printing
Icons Shapes and Formatting
Printing Page Layout
Printing Headers Footers
Managing Data
Data Sort
Filtering
Tables
Text to Columns
Text to Columns
Data Validation
Group and Outline
Freeze Panes
Managing Text and Working with Formulas and Functions
Relative and Absolute Referencing
VLOOKUP
Index Match
IF
Nested If
Countif Countifs
SUMIF SUMIFS
LEN
RIGHT LEFT MID
SEARCH
Common Error Types
IFERROR
Charts
Chart Basics
Chart Series and Column Charts
Bar Charts
Pie Charts
Composite Charts
Pivot tables, Power Query and Dashboards
Power Query Intro
Power Query Consolidation
Pivot Tables
Setting up a Pivot Table
Pivot Table Field Settings
Pivot Table Calculated Fields
Pivot Table Groupings
Pivot Table Slicers and Timelines
Dashboards Part 1
Dashboards Part 2
Macros
What is a macro.
Recording a Macro
Relative and Absolute Macros
Intro to VBE and VBA
Introduction to VBE
12.2 Object Model
Module Worksheets Classes
Variables and Constants
vba Formatting
a If Statement
b Select Case
a For Loop
b DoWhile DoUntil Loop
c ForEach Loop
a Errors
b Errors
Consolidate