# Here is Another Example on Why Excel will Never Go Away – Julia Computing

Recently I had a conversation with a colleague who argues that Excel will die because he felt people are switching to other computing environments such as R. While I agree...

# Google Sheets is Catching up with Excel in Charting

Excel is still my number one choice when it comes to graphing and charting, or just first-cut exploring, but I have notice that Google Sheets is also becoming more and more...

# How Advance do People Make Rental Car Reservations? The Result May Surprise You!

Spring break is upon us. Many students of mine are heading to exotic location, and quite a few of them have reserved rental cars many weeks earlier. But here is the question:...

# How to Draw a Pareto Chart?

Pareto chart, put simply, is a sorted frequency chart. It is used mainly for identifying the most frequent occurrences in a collected sample. Some business-situation questions...

# Sparkline (aka chart-in-a cell) really sparkles!

In many cases, you need to generate a series of graphs using Excel, and yet do not want to put them into one single picture. For example, you would like to draw the price...

# Data Table is a Secret Weapon in Excel Modeling and Analysis

Scenario analysis (also called What-ifs) is an indispensable part of business decision models. What is demand is only half of predicted? What if conversion rate is 50% higher?...

# “That’s twice the size of Texas. They may never find us.”

Wait…what’s this? You might be wondering.  What does it have to do with Excel modeling?   Let me explain.   First of all, this is a quote from the move...

# 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...