#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
Post 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
Post 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
Post 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
Post 4

The One Excel Formula to Rule Them All

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

The Art of Excel Pivot Tables

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

Adventures in Excel: Power to the Pivot

Power up your Excel Pivot Tables with these pro moves.
Doing the Excel Data Dance
Post 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
Post 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
Post 9

Taking Out the Trash: Dirty Data in Excel

Dealing With Dirty Data in Excel (continued).
Getting Iffy With it: Conditional Statements in Excel
Post 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
Post 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
Post 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
Post 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
Post 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
Post 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
Post 16

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

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