Have you ever wanted to highlight information or make notes in a received email? Or make the email contents easier to recognise or find in the future? Or perhaps […]
How to import public holidays into Microsoft Project 2010 calendar
Microsoft Project 2010 comes installed with three global calendars, and these calendars have only Saturdays and Sundays marked as non-working days. You will have to add public holidays manually […]
How to create a custom theme in Office 2013
Themes in the Microsoft Office suite are used to format a whole document quickly and uniformly. In this blog post, I’ll go through some ways of creating a custom theme […]
Enhance your presentations with PowerPoint’s Slide Zoom
One of the more useful features that has been introduced with Microsoft PowerPoint 2013 is the new Slide Zoom feature available in Presenter View.
If you are trying to show […]
How to convert text to columns in Microsoft Excel
Have you ever needed to sort or filter data in Microsoft Excel but couldn’t because the data have been combined into a single column rather than multiple columns? A […]
Creating a drop-down list in Microsoft Excel
Nothing looks more clever than a drop-down list of options for people to choose from in your Microsoft Excel spreadsheet. Drop-down lists also makes data entry easier, more accurate […]
How to create a PivotTable using Excel VBA
PivotTables are a powerful Microsoft Excel tool for analysing large quantities of data. When the process of creating a PivotTable needs to be automated, it can be done quite […]
Enhancing the IF function with nested IF functions in Microsoft Excel
Out of all the Microsoft Excel’s worksheet functions, the IF function is one of the most useful and versatile functions. Its purpose is to decide, based on a condition, whether […]
Where did my Acrobat tab go in Microsoft Word?
I recently upgraded my computer with Microsoft Office 2013 and Acrobat XI. I was all excited about the new improvements in both software packages. When I decided to create a PDF […]
Using custom fields to calculate GST in Microsoft Project
Microsoft Project allows you to customise fields for several purposes including; to save time, avoid typing errors, meet stakeholders’ expectations and needs, warn you that a task is due in […]
