One of the hardest Excel features to master is charts and graphs, which aren't always so user-friendly.That "Select Data Source" dialogue box is so sensitive that it could drive you crazy!Select Data …
News from the Excel Galaxy
Lots of fun Excel news coming out the last couple of weeks, just in time for the holidays. And why shouldn't it be timed that way? I love being part of this community -- what a wonderful, welcoming, …
New! Check out the Quote Gallery
I've compiled the best image quotes I have made for the blog. Topics range from business analytics to entrepreneurship. All are meant to inspire the savvy analyst.Check out the collection here. …
Grouping Dates in PivotTables: Excel 2016 Improvements
Excel 2016 has some awesome improvements over prior versions, but maybe the best is the ability to group dates within PivotTables.Learn how to analyze data across multiple date ranges effortlessly in …
Continue Reading about Grouping Dates in PivotTables: Excel 2016 Improvements →
Setting a “workbook homepage” in Excel — 2 Ways
We all have that one untameable workbook. You need to get back to a "home worksheet" each time but can never find it. Here are a couple of ways to set a homepage in your Excel workbook.Download the …
Continue Reading about Setting a “workbook homepage” in Excel — 2 Ways →
Convert from FNAME LNAME to LNAME, FNAME in Excel
As an analyst you will frequently receive data in FNAME LNAME format. This is poor data design -- it does not allow you to sort the data A-Z by last name. In this video I will show you how to convert …
Continue Reading about Convert from FNAME LNAME to LNAME, FNAME in Excel →