Tag: self-learner

Excelling with Microsoft Excel 7: Excel 2010 ( Date formulas and shortcuts)

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

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!!!

Excelling with Microsoft Excel 4: Excel 2010 (Vlookup and formatting)

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

Continue reading

Excelling with Microsoft Excel 3: Excel 2010 (Shortcuts and tips)

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:

Continue reading

Excelling with Microsoft Excel: Self-learning series 2 (Accessibility options)

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

Continue reading