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 →
Documenting your Excel Workbook — 3 Ways
Excel gets a bad rap for poor documentation of work. In this video I will show three ways to document and trace work in a spreadsheet. This will help you and your coworkers make better sense of …
Continue Reading about Documenting your Excel Workbook — 3 Ways →
No Learner an Island
"This is good," a fellow doctoral student told me at our meeting the other day. "You are asking people for help. I should have done that." One suggestion this older student gave to me was not to be …