#Adventures in Excel

Adventures in Excel

Excel secrets and magic. The kind of industry knowledge that could put financial analysts out of business.

Excel Data Manipulation: a Guide For Everyone

1: Excel Data Manipulation: a Guide For Everyone

Introduction to Excel Data Manipulation using TEXTJOIN and Macros.
How I Stopped Worrying and Learned to Love the Formula

2: How I Stopped Worrying and Learned to Love the Formula

Learn to define and utilize Excel formulas.
Excel Showdown: Index Match vs. The Lookups

3: Excel Showdown: Index Match vs. The Lookups

Learn to hate V-Lookups and H-Lookups in favor of Index Match.
The One Excel Formula to Rule Them All

4: The One Excel Formula to Rule Them All

Unlock the secrets of Excel's Index Match.
The Art of Excel Pivot Tables

5: The Art of Excel Pivot Tables

Pivot complex Excel spreadsheets to summarize your data.
Adventures in Excel: Power to the Pivot

6: Adventures in Excel: Power to the Pivot

Power up your Excel Pivot Tables with these pro moves.
Doing the Excel Data Dance

7: Doing the Excel Data Dance

Taking a step back to reflect on the problems Excel intends to solve.
Dealing with Dirty Data in Excel

8: Dealing with Dirty Data in Excel

Cleaning data Excel in the absence of tools designed to do so.
Taking Out the Trash: Dirty Data in Excel

9: Taking Out the Trash: Dirty Data in Excel

Dealing With Dirty Data in Excel (continued).
Getting Iffy With it: Conditional Statements in Excel

10: Getting Iffy With it: Conditional Statements in Excel

Effectively utilize conditionals such as IF statements in your Excel workflow.
Yes...If(And)): Excel’s Mighty “IF” Statement

11: Yes...If(And)): Excel’s Mighty “IF” Statement

A deep dive into Excel’s implementation of IF statements and their significance.
Slicing Excel: The Way of The Knife

12: Slicing Excel: The Way of The Knife

Slicing your Excel data to be presentable for the less tech-savvy.
Your Invitation to the Excel Pivot Party

13: Your Invitation to the Excel Pivot Party

Becoming well-versed in pivot tables to the point where it’s a problem.
Active-X Gonna Give it to Ya

14: Active-X Gonna Give it to Ya

Excel offers the ability to name a particular range (or collection of cells). Learn Named Ranges and the Active Xs who Love Them.
Dynamic Tension! Creating and Using Dynamic Named Ranges in Excel

15: Dynamic Tension! Creating and Using Dynamic Named Ranges in Excel

Dynamically load data in smart pivot tables.
Roll On Through: Create an Iterative List in Excel Without Any Real Coding

16: Roll On Through: Create an Iterative List in Excel Without Any Real Coding

This isn't standard programming...THIS IS EXCEL!