Former mental health professional who pulled the biggest career 180 in recent history. Currently crunches numbers using a very particular set of skills...namely creating data fires using digital twigs
Former mental health professional who pulled the biggest career 180 in recent history. Currently crunches numbers using a very particular set of skills...namely creating data fires using digital twigs
Analyzing ginormous files with Microsoft PowerPivot.
Working with large flat files in PowerPivot.
Dipping into Microsoft's PowerPivot add-on for Excel.
Roll On Through: This isn't standard programming... THIS IS EXCEL! We get creative in Excel by making FOR loops without using VBA.
Dynamically load data in smart pivot tables.
Entering the Dataverse.
Excel offers the ability to name a particular range (or collection of cells). Learn Named Ranges and the Active Xs who Love Them.
Becoming well-versed in pivot tables to the point where it’s a problem.
Slicing your Excel data to be presentable for the less tech-savvy.
A deep dive into Excel’s implementation of IF statements and their significance.