Tag: excel illustration

Excelling with Microsoft Excel 5: Excel 2010 (Sparklines and Tables)

I am almost through with the Alison online Excel 2010 course with four modules left to complete. Remaining modules are on macros, if functions, Microsoft Office security, working with dates in Excel and planning payments and savings in Excel. If you have missed my earlier posts on tips I have come across in my Excel

Continue reading

Excelling with Microsoft Excel: VLOOKUP Illustration

As promised in the previous post, I worked up a simple illustration on VLOOKUP (takes less than 3 minutes). Take a quick look at the post before watching this video especially if you are new to this functionality. I hope this clarifies all that was outlined in the post. Cheers!!!