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 … More Excelling with Microsoft Excel 7: Excel 2010 ( Date formulas and shortcuts)
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 … More Excelling with Microsoft Excel 4: Excel 2010 (Vlookup and formatting)
The key learning points I would be sharing with you today are on utilising the F4 as a shortcut function and other Excel worksheet tips. If you are interested in taking the online e-learning course administered by Alison independently, you can check out the link here >>>Microsoft Excel 2010 course. My previous post was on Excel 2010: … More Excelling with Microsoft Excel 3: Excel 2010 (Shortcuts and tips)
This is the 2nd of my self-learning series, the first one was on Shortcuts and sparklines. If you are interested in taking the online e-learning independently, you can check out the link here >>>Microsoft Excel 2010 course, it is administered by Alison. Key learning points for today Accessibility options The essence of this Excel functionality … More Excelling with Microsoft Excel: Self-learning series 2 (Accessibility options)