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 […]
Author Archive | Shaun Ault
Shaun earned his Ph. D. in mathematics from The Ohio State University in 2008 (Go Bucks!!). He received his BA in Mathematics with a minor in computer science from Oberlin College in 2002. In addition, Shaun earned a B. Mus. from the Oberlin Conservatory in the same year, with a major in music composition. Shaun still loves music -- almost as much as math! -- and he (thinks he) can play piano, guitar, and bass. Shaun has taught and tutored students in mathematics for about a decade, and hopes his experience can help you to succeed!
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 […]
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 […]
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 […]
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 […]