Excel: Organize for Efficiency

Course 3: Organize for Efficiency teaches frameworks for data and formula setup. This eliminates downstream mistakes and makes future updates plug and play. Spend the time doing it right once rather than having to redo it time and time again.

Buy $269.00

Course curriculum

1. Course interaction
2. Introduction
3. Orientation
1. Pre-course survey
1. Supplemental slides
2. Supplemental files
1. Chapter preview
2. 01 - Data types
3. 02 - Data type conversion
4. 03 - Operators
5. 04 - Exercise 1
1. Chapter preview
2. 05 - Formulas and arrays
3. 06 - Spill behavior and spill operator
4. 07 - Arrays - evaluate
5. 08 - Arrays - myth buster
6. 09 - Arrays - implicit intersection
7. 10 - Spilling scalars
8. 11 - SEQUENCE
9. 12 - Lambda introduction
10. 13 - Lambda basics
11. 14 - Replicating lambdas
12. 15 - Lambda helper functions
13. 16 - UNIQUE
14. 17 - FILTER
15. 18 - Arrays and operators (orientation)
16. 19 - Arrays and operators (behaviors)
17. 20 - FILTER revisited
18. 21 - Exercise 2
1. Chapter preview
2. 23 - Keep source data intact
3. 24 - Structure source as a database table
4. 25 - Sort table data
5. 26 - Sort functions
6. 27 - Filter table data
7. 28 - Pivot table (Part 1)
8. 29 - Pivot table (Part 2)
9. 30 - Pivot table (Part 3)
10. 31 - Keep data self-contained
11. 32 - Data hierarchy
12. 33 - Remove duplicates
13. 34 - Import data
14. 35 - Dynamic tables - introduction (Part 1)
15. 36 - Dynamic tables - advantages (Part 2)
16. 37 - Dynamic tables - from static to dynamic (Part 3)
17. 38 - Dynamic tables - how tables expand/collapse (Part 4)
18. 39 - Slicers
19. 40 - Exercise 3
1. Chapter preview
2. 41 - Relative absolute referencing - general (Part 1)
3. 42 - Relative absolute referencing - dynamic tables (Part 2)
4. 43 - Dynamic table - formula considerations
5. 44 - Formula best practices
6. 45 - Formula arguments - dynamic (Part 1)
7. 46 - Formula arguments - cell references (Part 2)
8. 47 - Formula checks - please do this!
9. 48 - Introduction to binary patterns - the basics (Part 1)
10. 49 - Introduction to binary patterns - base 10 and 2 (Part 2)
11. 50 - Introduction to binary patterns - bitwise operators (Part 3)
12. 51 - Applying binary patterns - update FILTER (Part 1)
13. 52 - Applying binary patterns - math and flags (Part 2)
14. 53 - Exercise 4
1. Chapter preview
2. 54 - Basics of formula auditing - overview of tools (Part 1)
3. 55 - Basics of formula auditing - better design (Part 2)
4. 56 - Why formula auditing matters when building formulas
5. 57 - Error checking
6. 58 - Calculation
7. 59 - Exercise 5
1. Chapter preview
2. 61 - Formatting values
3. 62 - Formatting cell colors
4. 63 - Formatting tables – presentation ready table
5. 64 - Formatting borders
6. 65 - Formatting center across selection
7. 66 - Formatting group cells
8. 67 - Formatting color palette
9. 68 - Formatting worksheet settings (Part 1)
10. 69 - Formatting worksheet settings (Part 2)
11. 70 - Formatting dynamic tables
12. 71 - Formatting pivot table
13. 72 - Formatting slicer
14. 73 - Exercise 6
1. Chapter preview
2. 74 - Excel options (Part 1)
3. 75 - Excel options (Part 2)
1. Post-course survey

About this course

87 lessons
6.0+ hours of high-quality video
Supplemental files and slides

Excel: Organize for Efficiency

Course curriculum

Introduction

Pre-course Survey

Materials

Data Types and Operators

Dynamic Arrays & LAMBDA

Data and Tables

Dynamic Patterns

Formula Auditing

Formatting

Excel Options

Post-course Survey

About this course