The New Histogram Tool in Excel 2016 is Handy-Dandy
Let’s face it. The old histogram tool in Excel – the one hidden in Data Analysis – is a pain to use. You need to prepare a ‘Bin range’ to start...
To build a frequency distribution chart, do NOT use Excel’s Histogram add-in tool
A histogram (also called a frequency distribution chart) shows how many times a specific value occurs within a certain range. It is super-useful if you want to know how a...
Flashfill in one of my favorite new feature in Excel
In Excel 2013 and later, there has been a significant push towards “intelligent computing”. Flashfill is one of the most significant new features under this push....
Excel Tutorial: How to Load Solver in Excel (Mac)
More and more people are using Excel as an optimization tool. Speaking of optimization, Excel Solver is at the center of it. However, many people seem to have problem finding...
How to calculate Time Difference in Excel
Microsoft Excel has a function to calculate the numbers of days between two dates (DATEDIF), but there is no specific function to compute the hours and minutes between two...
You Draw It: How Family Income Affects Children’s College Chances
New York Times has this super-interesting article, partly because of its interactive nature:...