February 21, 2019
Sort asc desc
Post 2
How I Stopped Worrying and Learned to Love the Formula
Learn to define and utilize Excel formulas.
Post 5
Adventures in Excel: Power to the Pivot
Power up your Excel Pivot Tables with these pro moves.
Post 6
Doing the Excel Data Dance
Taking a step back to reflect on the problems Excel intends to solve.
Post 7
Dealing with Dirty Data in Excel
Cleaning data Excel in the absence of tools designed to do so.
Post 9
Getting Iffy With it: Conditional Statements in Excel
Effectively utilize conditionals such as IF statements in your Excel workflow.
Post 10
Yes...If(And)): Excel’s Mighty “IF” Statement
A deep dive into Excel’s implementation of IF statements and their significance.
Post 11
Slicing Excel: The Way of The Knife
Slicing your Excel data to be presentable for the less tech-savvy.
Post 12
Your Invitation to the Excel Pivot Party
Becoming well-versed in pivot tables to the point where it’s a problem.
Post 14
Dynamic Tension! Creating and Using Dynamic Named Ranges in Excel
Dynamically load data in smart pivot tables.
Post 15
Roll On Through: Create an Iterative List in Excel Without Any Real Coding
This isn't standard programming...THIS IS EXCEL!
