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…
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…
You could use Excel VBA to move the mouse and click on things (left and right click). Below is an example of moving the mouse to the top left of the screen and then clicking. Just copy the code and paste it into macro window in Excel. The SingleClick() subroutine is a single click, while…