Teaching analytics with modern Excel
Power Query is possibly the most exciting new Excel feature of its generation... but you might never know it considering how hidden it is from the Excel interface! If you're looking to connect a data …
Continue Reading about A tour of the Power Query Editor in Excel →
This post accompanies my segment on MyExcelOnline's "Best Excel Tips of 2017 Podcast." The first commandment of data analysis: KNOW THY DATA! It's always smart to get a feel for your data's …
Continue Reading about Making Easy, Flexible Histograms with PivotTables →
Paying commissions in Excel can be tricky. Not only does the data have to be 100% correct, it is structured differently than most financial data.It's not based on subaccounts or the general ledger -- …
Continue Reading about Paying Commissions in Excel: Understand Your Data →
Did you know that you can use the same value field twice in a #PivotTable? Follow these steps to include a % total or running total on your report. …
You probably didn’t expect etymology in this book, but it here goes. When I probably should have been learning Excel in high school, I took a Greek class instead.I haven’t used my Greek a lot, but one …
Note: This is my first Excel post! I have improved since then, both in my blogging and Excel skills. I've made some modifications to the post, but the first paragraph remains for sentiment's …
Continue Reading about Filter Multiple Pivot Tables with One Slicer →
