How to use this course
Before we begin ... get your course notes and data!
Course Notes
1.1 Course Introduction
1.2 Fluency: Fluency Introduction
1.3.1 Fluency: Issuing Commands Efficiently
1.3.1 Quiz
1.3.2 Fluency: Issuing Commands Efficiently Practice
1.4.1 Structuring: Define Structured Rows and Columns
1.4.1 Quiz
1.4.2 Structuring: Define Structured Rows and Columns Practice
1.4.2 Quiz
1.5 Structuring: Making a Pivot Table
1.5 Quiz
1.6 Structuring: Structured Scenario Models
1.6 Quiz
2.1.1 Fluency: Navigating Within Workbooks
2.1.2 Fluency: Navigating Between Workbooks
2.2 Fluency: Navigating Dialog Boxes
2.3 Fluency: Selecting Data Efficiently
2.4 Curating: Curating Data and Models
2.4 Quiz
3.1.1 Commands: Introduction to Trainings on Excel Commands
3.1.1 Quiz
3.1.2 Commands: Introduction to Trainings on Excel Commands Practice
3.2.1 Commands: Filtering
3.2.2 Commands: Sorting
3.2 Quiz
3.3.1 Commands: Named Cells
3.3.1 Quiz
3.3.2 Commands: Named Cells Practice
3.4.1 Commands: Naming Ranges
3.4.1 Quiz
3.4.2 Commands: Naming Row and Column Ranges
4.1 Commands: Find and Replace
4.2 Aesthetics - UI: User Interface Design for Rows/Columns Tables
4.2 Quiz
4.3 Aesthetics - UI: Arranging Columns by Granularity
4.4 Aesthetics - UI: Column Outlines
4.3 and 4.4 Quiz
4.5 Aesthetics - UI: Freeze Panes
4.6.1 Aesthetics - UI: Using Conditional Formatting for Rows Part 1
4.5 and 4.6.1 Quiz
4.6.2 Aesthetics - UI: Using Conditional Formatting for Rows Part 2
4.6.2 Quiz
4.6.3 Aesthetics - UI: Using Conditional Formatting for Rows Part 3
4.7 Aesthetics - UI: Using Interface Design Wrap-up
5.1 Building Multi-table Models
5.1 Quiz
5.2 Legacy VLOOKUP/MATCH combo for Lookups
