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 … More Excelling with Microsoft Excel 5: Excel 2010 (Sparklines and Tables)

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 … More Excelling with Microsoft Excel 4: Excel 2010 (Vlookup and formatting)

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: … More Excelling with Microsoft Excel 3: Excel 2010 (Shortcuts and tips)

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 … More Excelling with Microsoft Excel: Self-learning series 2 (Accessibility options)

Excelling with Microsoft Excel: Self-learning series 1 (Shortcuts and sparklines)

Microsoft Excel is an important tool for most accounting and finance professionals. Knowledge of excel saves time and helps in financial analysis among other benefits. I realised most of us believe we have the knowledge but truthfully speaking, it is basic and limited. This useful resource in my opinion is currently being underutilised. Thanks to … More Excelling with Microsoft Excel: Self-learning series 1 (Shortcuts and sparklines)