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.
1
Yes...If(And)): Excel’s Mighty “IF” Statement
A deep dive into Excel’s implementation of IF statements and their significance.
4 min read
2
Slicing Excel: The Way of The Knife
Slicing your Excel data to be presentable for the less tech-savvy.
5 min read
3
Your Invitation to the Excel Pivot Party
Becoming well-versed in pivot tables to the point where it’s a problem.
4 min read
4
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
5
Dynamic Tension! Creating and Using Dynamic Named Ranges in Excel
Dynamically load data in smart pivot tables.
7 min read
6
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
