Earn And Excel Courses

Module 2 Practice Workbook

3. Finding Information: putting it all together

5. Advanced Logic Building

Module 3 Practice Workbook

4. Text Functions: LEFT, MID, RIGHT

Flash Fill

5. Text functions: Advanced Text analysis by building formulas

6. Text functions: Creating email addresses with SUBSTITUTE and ‘&’

7. Text functions: Creating character and word count limits

8. Advanced Text, Logic and Lookups: Creating a resourcing model

Module 4 Practice Workbook

3. Summing

3a. Summing – Circular References explanation

4. SUBTOTAL function

5. Analysis walkthrough with Summing and Counting

6. What are Pivot tables and why they are overrated

7. Advanced List Analysis: Understanding Array Formulas

OPTIONAL: Array Formulas for Multiple Criteria

Mastering Multiple Occurrences

OPTIONAL: Array Formulas for Multiple Occurrences

7a. Array formulas rows vs Index range

8. Advanced Modelling with Array Formula Lookups

9. Dashboard and Reporting Practice for Professionals

10. Advanced Conditional Formatting: Using Formulas

11. Advanced Conditional Formatting: Beyond Highlighting

Module 5 Introduction

Module 5 Practice Workbook

1. Resource Analysis: Good practice for managing data

2. Dynamic Charts

3. Charting Actual vs Forecast

4. Segmenting for deeper MI

5. Meaningful Resource Analysis

Outro: Goodbye and Next Steps