Category Archives: Advanced Excel

Calculating Time with Excel Formulas

Default Image

How often have you looked at your watch and typed the current time into your worksheet? Or tried to convert from one time zone to another and produced an error? Or wondered why a time shows up looking like “0.9285”? Fortunately, these questions are easy to answer once you understand how Excel time formulas work….
Read More

3 Easy Formulas to Calculate the Range of Values in Excel

Default Image

An essential skill any Excel user should know is how to determine the range of values in Excel. Most businesses don’t have time to waste sorting through rows and rows in Excel in order to find the highest and lowest values of revenue, sales, or other information. The difference between the highest and lowest figures…
Read More

Visually Display Composite Data — How to Create an Excel Waterfall Chart

Default Image

Have you ever needed to present a chart that displays component data that roll up to a total? If all of the values are positive, Excel’s stacked column chart works beautifully; but it breaks down when your data includes both positive and negative values. The answer is an Excel waterfall chart! A waterfall chart solves…
Read More

Categories

Monthly Archives