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…
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…
Tables are often used to layout and summarize data. But have you been in a situation where the table got so big that it is not easy to read? The table is so big that it is hard to tell which rows and columns a certain cells belong. For example, in the table below, it…
For some reason, after Excel 2003, you just can’t change the textbox name on a chart tab anymore. (It still works in a normal worksheet tab.) And it’s actually a crucial feature since it is how textbox are referenced in VBA. In Excel 2003, you can read the textbox name by clicking on it, and…
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…
How to plus or minus exactly one month in Excel? The best way is to use a built in function in the analysis toolpack, edate. =edate([date], [months]) Date is the date you are calculating from. Months is how many months you want to add. If you want to go backwards, then months is a negative…
I made a simple calendar for any given month in Excel. It works straight out of the box, just copy the calendar and paste to the desired location. To edit the month being displayed, simply change the date in top left cell of the calendar No VBA required, the entire calendar is made from formulas Download…
Most users are familiar with hiding rows or columns, but may not have ventured into grouping rows or columns. What is the Group Function and How to Activate it? The group function basically “ties a range (columns or rows, can’t be both) together, and allows you to collapse them (and expand them later), showing only the last…
Doing good work means accurate and on time. While most of the tips on this website is about doing things faster and smarter, this article is dedicated to how to catch mistakes in Exce: Sum check. Do the sum of the numbers on excel equal to sum of the tables you were entering? The check…
Those dealing with a large number of spreadsheets with 3rd party Excel API software is likely to deal with the duplicate name range nightmare. Occasionally when 1 worksheet is copied or moved to another workbook, more than 50 of these “duplicate name range” message pops up. Something like this: The easy workaround is just…