Thanks for joining my Advanced Excel masterclass.
Please use below links to download Excel workbooks or learn more about the chapters.
| Chapter | Excel Files | Learn more |
|---|---|---|
| Introduction to Excel Tables | Learn more | |
| Introduction to Excel SUMIFS Formula | Learn more | |
| Introduction to VLOOKUP formula | Excel files | Learn more |
| INDEX + MATCH formulas | Excel files | Learn more |
| Introduction to Conditional Formatting | Excel files | Learn more |
| How to select right chart for your data? | Learn more | |
| Introduction to Form Controls | Excel files | Learn more |
| Thermo-meter chart with Marker for Last Year Value | Excel files | Learn more |
| Waterfall charts using Excel | Excel files | Learn more |
| Highlighting Excel chart data conditionally | Excel files | Learn more |
| Making an interactive chart in Excel – Example #1 | Excel files | Learn more |
| More examples on interactive charts | ||
| Introduction to Pivot tables | Excel files | Learn more |
