This is the final post of my Excel 2010 journey with Alison. Finally! Although I missed my target timeline of completion but the important thing is that I have completed and passed my test. You can check out the previous post on the “if” function. Dates and formulas This is useful when the task involves finding the
Category: Excel tips
Just in case, you missed out on my earlier posts, you can check them out here: Excelling with Microsoft Excel: Self-learning series 1 (Shortcuts and sparklines) Excelling with Microsoft Excel: Self-learning series 2 (Accessibility options) Excelling with Microsoft Excel 3: Excel 2010 (Shortcuts and tips) Excelling with Microsoft Excel 4: Excel 2010 (Vlookup and formatting)
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
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!!!
This post is evident that we are making progress with the self-learning series on Microsoft Excel. I appreciate the positive feedback that I have been receiving so far. Currently I have completed 41% of the course so I presume we still have more new tips to learn together. I hope that at least the previous