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…
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…
This one’s a real time saver. While writing tutorials, I used to do a screenshot, and paste image into an image editor to get all the column and row headings into an image. This requires a lot of work, such as moving and cropping the image. Now, I can just copy from Excel and paste…
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…
In Powerpoint, you may want to align charts and objects on several different slides into the exact same position for consistency. For example, if you had a chart and with text on multiple slides, you would probably want the charts and textbox in the identical location on each slide. Basics of Moving Objects in Powerpoint…
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…
THE guide for anyone who wants a “Excel database”. Excel and Access are two very different tools: Excel is a spreadsheet program, while Access is a database program. However, it is not uncommon to see Excel used as a “patchwork” or temporary solution instead of Access, simply because Excel is easier to use. If only…
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…