29 articles Excel 2003

How to Create a Three Variable Data Table in Excel?

Click here to download the Three Variable Data Table Example. Introduction The key to making a three-variable data-table (or any higher number of variables, such as 4, 5, etc.) is to use the offset function to populate a set of values into the base calculation. (The data-table’s constraint of only having two variables remain unchanged.) Setting Up…

How to calculate start & end dates, quarters, headings and days in period in a monthly Excel model?

Click here to download the Monthly Model Template with all the necessary start & end dates, month, quarter, and “days in period” calculations. This model is the perfect template to help you set up a monthly model for financial or operational data. You can easily extend this template by copying the column into empty cells…

How to fix the vlookup function? Help! It doesn’t work and give me errors!

VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup]) The VLookup function can be very handy, but a few common errors throw a lot of users off. Here’s the top 5 sources of errors that I have frequently encountered over the years. Trust me, quite a few users spend hours trying to find out why the vlookup value does not…

Download and modify the clustered stacked column bar chart template

In a previous article, I created a step-by-step guide on how to create a clustered stacked column bar chart from scratch. For the sake convenience, click here to download the Cluster Stack Chart Template. The template will come in handy. This tutorial also shows you how to customize to fit your exact needs. Terminology Here’s a few…

Waterfall chart template download with instructions (supports negative values)

This tutorial shows you how to use the waterfall chart template file Excel that supports negative values and columns representing no change. Download here to download: Waterfall Chart Template How to use the template? The template is ready to use right out of the box. All you need to do is change the input cells Enter…

Step-by-step tutorial on creating clustered stacked column bar charts (for free)

This tutorial will show you how to create a clustered stacked column bar chart – step-by-step, so there is no way you will get confused. If you like this tutorial and find it useful, have questions or comments, please feel free to leave me a comment! I would love to hear your feedback! Download here…

How to fix rounding errors in Excel? These errors are messing up calculation checks.

Sometimes Excel does not calculate numbers correctly and gives an “incorrect” result. Avoiding technical jargon, its basically because Excel rounds of the results of its calculation. This typically isn’t a problem because most users will not need the 10th decimal place, and would never notice the problem. However, the problem is quite noticeable for those who are doing…