Month: August 2018
My Spreadsheet Lab shows you two methods for stacking rows of 3-digit area codes. This is an example of intuitive problem solving in Excel.
The Spreadsheet Guru highlights a strange Print Area problem, and shows how to correct it.
Excel Exposure shows several options for performing “What-If” analysis in Excel.
Automate Excel shares over 200 shortcuts, PLUS a tool that helps you learn them as you work normally!
If you are new to Excel’s Power tools, this great write-up by Chandoo will explain what each of them does.
Clearly and Simply shares a method for highlighting multiple selections in Excel Dashboards
Excel Off the Grid shows you a great hidden feature in Excel, which will read all of your cells to you!
Excel is Fun has a great workaround to compare multiple non-connected cells for a specific condition.
Analyst Cave shows you many different ways to count in Excel, and then shows you some VBA code to count all of the formulas you used