offers Excel lesson videos made simple!

Sign up or log in to Magoosh Excel.

Author Archive | Shaun Ault

What You Should Know About Excel Sparklines

What are Excel sparklines and how can you use them to highlight trends in your data? Basically, sparklines are miniature (lightweight) versions of line or bar charts that are easy to create, adapt, and scale. In this article, we’ll find out how to create sparklines and see some typical uses of these useful gadgets! Excel […]

Continue Reading · 0

Using DCOUNT in Excel

DCOUNT in Excel is a handy formula that can count items based on a set of criteria. The criteria can be quite general, including matching words, specifying numerical bounds, and many other possibilities. DCOUNT is basically a more powerful version of the COUNTIF function. (Check out: How to Use the COUNTIF Function in Excel for […]

Continue Reading · 0

Understanding Time Series Forecasting in Excel

What is time series forecasting, and how does Excel make this task easy to do? Time series forecasting is all about using existing data to make predictions about future events. Just as meteorologists can predict the path of a hurricane by its current path, you can use forecasting to spot trends in the data and […]

Continue Reading · 2

How to Make a Gantt Chart in Excel

A Gantt chart in Excel is a specialized visual tool that shows the various stages of completion of multiple related tasks. This kind of chart helps to organize activities that may depend on the start or end times of other activities. For example, the editing of a book cannot begin until the author has submitted […]

Continue Reading · 0

How to Make a Combo Chart in Excel

A combo chart in Excel is a chart that displays multiple sets of data in different ways on the same chart. Many kinds of data can be combined into one chart. You could even represent the same data in various ways on a single chart. For example, you may want to combine a bar graph […]

Continue Reading · 0