Data Tools (Reference Guide)
Data Tools: Data Validation Part 1
Data Tools: Data Validation Part 2
Data Tools: Text to Columns
Data Tools: Autofill Text
Practice Assignment: Data Tools
Data Tools Quiz
Manage Data (Reference Guide)
Manage Data: Group Columns and Rows
Manage Data: Freeze/Split Columns and Rows
Manage Data: Search, Find, Replace
Manage Data: Sorting Data
Manage Data: Filter Data
Practice Assignment: Manage Data
Manage Data Quiz
Excel Formulas (Reference Guide)
Excel Formulas: Formula and Cell Reference Options
Excel Formulas: Cell Reference Types
Excel Formulas: Autosum
Excle Formulas: Addition
Excel Formulas: Substraction
Excel Formulas: Multiplication
Excel Formulas: Division
Excel Formulas: Recap 1
Excel Formulas: Recap 2
Practice Assignment: Excel Formulas
Excel Formulas Quiz
Date and Time (Reference Guide)
Date/Time Functions: Introduction to Date/Time Functions in Excel
Date/Time Functions: Date Series
Date/Time Functions: Time Series
Date/Time Functions: DATEDIF
Date/Time Functions: Days
Date/Time Functions: EDate
Date/Time Functions: EOMonth
Date/Time Functions: NetworkDays/NetworkDays.INTL
Date/Time Functions: DateValue and TimeValue
Practice Assignment: Date and Time
Date and Time Formula Quiz
Logical Functions (Reference Guides)
Logical: Logical Operators
Conditional Statement: Intro to IF
Conditional Statement:: Intro to And/OR
Conditional Statement:: IF (with) AND/OR
Conditional Statement: Function Library (Automate) IF/AND/OR
Conditional Statement: IF (DateValue)
Conditional Statement: IF (TODAY)
Conditional Statement: Function Library (Automate): IF (AND, OR, Today, DateValue)
Practice Assignment: Logical
Logical Operators/Formulas Quiz