Browsing Category
Microsoft Excel
48 posts
Microsoft Excel is the industry leading spreadsheet software program, a powerful data visualization and analysis tool.
How to Create a Waterfall Chart in Excel
I remember trying to explain a company’s profit and loss statement to a room full of non-finance people…
How to Create a Box and Whisker Plot in Excel
I picked up box and whisker plots during a statistics course, and honestly, I didn’t appreciate how useful…
How to Create a Histogram in Excel
One of the first things I learned when analyzing survey response data was that a bar chart of…
How to Create a Data Table in Excel
I discovered Excel’s Data Table feature while trying to figure out how a loan payment would change under…
How to Create a Sparkline in Excel
If you’ve ever stared at a massive spreadsheet full of numbers and wished you could just see the…
How to Create a Conditional Formatting in Excel
I still remember the moment conditional formatting clicked for me. I was reviewing a budget spreadsheet with hundreds…
How to Create a Solver in Excel
The first time I used Solver, I was trying to figure out the ideal product mix for a…
How to Create a Scenario Manager in Excel
A few years ago, I was building a budget forecast for a small business, and the owner kept…
How to Create a Goal Seek in Excel
I first used Goal Seek when I was trying to figure out how many units I’d need to…
How to Create a MACRO in Excel
I’ll never forget the week I spent manually formatting the same weekly report — same column widths, same…