Earn And Excel Courses

Module 2 Introduction

Module 2 Practice Workbook

1. Finding Information: Limit Formulas

2. Getting Advanced with Lookup formulas

Multiple Criteria Article

3. Finding Information: putting it all together

4. Rule building with IF

5. Advanced Logic Building

Module 3 Introduction

Module 3 Practice Workbook

1. Working with Text

2. Text Functions: PROPER, TRIM & CLEAN

3. Text Functions: LEN & SEARCH

4. Text Functions: LEFT, MID, RIGHT

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 Introduction

Module 4 Practice Workbook

1. Introduction to Summarising

2. Counting

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

Mastering 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