#Adventures in Excel

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

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

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

This isn't standard programming...THIS IS EXCEL!
Dynamic Tension! Creating and Using Dynamic Named Ranges in Excel

Dynamic Tension! Creating and Using Dynamic Named Ranges in Excel

Dynamically load data in smart pivot tables.
Active-X Gonna Give it to Ya

Active-X Gonna Give it to Ya

Excel Named Ranges and the Active Xs who Love Them.
Your Invitation to the Excel Pivot Party

Your Invitation to the Excel Pivot Party

Becoming well-versed in pivot tables to the point where it’s a problem.
Slicing Excel: The Way of The Knife

Slicing Excel: The Way of The Knife

Slicing your Excel data to be presentable for the less tech-savvy.
Yes...If(And)): Excel’s Mighty “IF” Statement

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

A deep dive into Excel’s implementation of IF statements and their significance.
Getting Iffy With it: Conditional Statements in Excel

Getting Iffy With it: Conditional Statements in Excel

Effectively utilize conditionals such as IF statements in your Excel workflow.
Taking Out the Trash: Dirty Data in Excel

Taking Out the Trash: Dirty Data in Excel

Dealing With Dirty Data in Excel (continued).