Excel secrets, tricks, and magic. Learn macros and formulas to supercharge your Excel workflow to make life easy enough to take the rest of the day off.
Adventures in Excel
1
Excel Data Manipulation: a Guide For Everyone
Introduction to Excel Data Manipulation using TEXTJOIN and Macros.
3 min read
2
How I Stopped Worrying and Learned to Love the Formula
Learn to define and utilize Excel formulas.
4 min read
3
Excel Showdown: Index Match vs. The Lookups
Learn to hate V-Lookups and H-Lookups in favor of Index Match.
1 min read
4
The One Excel Formula to Rule Them All
Unlock the secrets of Excel's Index Match.
4 min read
5
The Art of Excel Pivot Tables
Pivot complex Excel spreadsheets to summarize your data.
3 min read
6
Adventures in Excel: Power to the Pivot
Power up your Excel Pivot Tables with these pro moves.
6 min read
7
Doing the Excel Data Dance
Taking a step back to reflect on the problems Excel intends to solve.
3 min read
8
Dealing with Dirty Data in Excel
Cleaning data Excel in the absence of tools designed to do so.
7 min read
9
Taking Out the Trash: Dirty Data in Excel
Dealing With Dirty Data in Excel (continued).
4 min read
10
Getting Iffy With it: Conditional Statements in Excel
Effectively utilize conditionals such as IF statements in your Excel workflow.
4 min read
11
Yes...If(And)): Excel’s Mighty “IF” Statement
A deep dive into Excel’s implementation of IF statements and their significance.
4 min read
12
Slicing Excel: The Way of The Knife
Slicing your Excel data to be presentable for the less tech-savvy.
6 min read
13
Your Invitation to the Excel Pivot Party
Becoming well-versed in pivot tables to the point where it’s a problem.
4 min read
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.
6 min read
15
Dynamic Tension! Creating and Using Dynamic Named Ranges in Excel
Dynamically load data in smart pivot tables.
7 min read
16
Create an Iterative List in Excel Without Any Real Coding
Roll On Through: This isn't standard programming... THIS IS EXCEL! We get creative in Excel by making FOR loops without using VBA.
3 min read