

Oct 10, 2020
Make multiple copies of a Microsoft Excel spreadsheet in seconds
Microsoft Excel is one of the most popular and widely used Microsoft applications in businesses worldwide. The capabilities of Excel are limitless if you know how to [...]


Sep 27, 2020
The importance of a break-even point in budgeting
Budgeting is important for individuals and for business as well. Simply put, a budget is a list of prospective income and expenditure for a given period. It helps you in [...]


Sep 16, 2020
Use conditional formatting to create a Gantt Chart in Excel
Efficient Project Management involves displaying the project plan in a visual format. The tool used to do this is called the Gantt Chart. The Gantt Chart is a list of [...]


Sep 15, 2020
How-to: Add public holidays to a Microsoft Project 2013/2016 calendar
Microsoft Project comes installed with 3 basic calendars: Standard 24 Hours Night Shift Most people are using the Standard Calendar. This calendar has [...]


Aug 29, 2020
How to use Excel range names efficiently in calculations
A Microsoft Excel user can use range names in calculations which will create meaningful reports to management. While names make calculations easier to understand, [...]


Jul 14, 2020
How to omit dates in an Excel chart axis
Let’s say you have the company’s performance information in an Excel spreadsheet. Your manager wants you to chart the data so it is easier to present it in the next [...]


May 10, 2021
Interesting facts about Project Management
Project management was not popular until the 19th century. Organisations started to apply formal project management principles and tools in the mid-1950s to complex [...]


Apr 11, 2021
How to create Microsoft Excel Scenarios Summary Report
I created three Scenarios using the Scenario Manager feature in my previous blog. I used the following spreadsheet data: The Scenarios I created are: Original [...]


Mar 31, 2021
How to create Scenarios with Microsoft Excel
Every management wants to increase the company’s profit over time. How can they do that? Well, by setting scenarios. Management can look at company’s Revenue and [...]


Jan 22, 2021
The importance of a break-even point in budgeting
Budgeting is important for individuals and for business as well. Simply put, a budget is a list of prospective income and expenditure for a given period. It helps you in [...]


Dec 02, 2020
Embedding Organisational Values into Performance Management
Respect, integrity, excellence in service, openness...do these words resonate with you and your organisation? These types of words often appear in organisational [...]


Dec 01, 2020
Using the Fluent API with Entity Framework
In a previous blog post we have seen how to use the code-first approach in the Entity Framework. In today's post, we will see how to map the entities to database [...]


Nov 30, 2020
Custom Data Validation Rules in Excel
Data Validation is a feature of Excel that can greatly improve the quality of data that is entered into cells by limiting what a user can type. You can create simple [...]


Nov 19, 2020
The best features of Excel 2013 - Part 1
NOTE: SkyDrive is now OneDrive, and SkyDrive Pro is now OneDrive for Business The first thing you will see when you open Excel is a brand new look. It is cleaner, but [...]


Oct 30, 2020
Power Map in Excel 2013
If you are using Office 365 Pro Plus or Excel 2013, you can take advantage of Power Map for Excel. Power Map is a three-dimensional (3-D) data visualisation tool that [...]


Oct 19, 2020
Create Scenarios in Excel using cell names
Analysing data in Microsoft Excel and creating different scenarios for management will allow them to choose the best case scenario, the one that will provide the company [...]


Sep 21, 2020
Use a slicer to make better business decisions
Being able to analyse all the data in your worksheet can help you make better business decisions. But sometimes it is hard to know where to start, especially when you [...]


Aug 14, 2020
Excel – Weighted Average Calculation
Calculating an average in Excel is really easy, but sometimes the business requirement calls for a more sophisticated weighted average. For example when analysing a [...]


Jul 06, 2020
Display the message "Tasks due shortly" in Project
In project management, it is very important to know that a task is due to start shortly because of the following reasons: You have to make sure that the necessary [...]


Jun 09, 2020
Recording screen action in PowerPoint 2013
PowerPoint 2013 now has a feature that enables you to take a full-motion screen capture. This could be very useful to demonstrate a process as part of the presentation [...]


Jun 05, 2021
A fantastic add-in for OneNote 2013
The ability to add and format tables in OneNote 2013 allows users to create sophisticated tables and store the information required in a very easy to read [...]


May 12, 2021
How to create an e-mail template in Outlook
An Outlook e-mail template is a very powerful feature, although often, it is underestimated. For instance, you may have specific forms you use when you send emails to [...]


Apr 10, 2021
How to contour the resources usage in Microsoft Project
The person responsible for updating a Microsoft Project plan file can contour the work using predefined settings. The Work Contour option provides choices for the [...]


Mar 24, 2021
Join text without using the Concatenate function in Excel 2013
Excel 2013 has a new feature called Flash Fill. This feature will allow you to join text strings from different cells very quickly without using the Concatenate [...]


Mar 17, 2021
Background images in OneNote 2013
OneNote allows you to insert online pictures or pictures from your computer hard drive into your notebook pages. Then you can set the picture as a background, so you can [...]


Feb 19, 2021
Creating custom task alerts in Microsoft Project 2010/13
Microsoft Project 2010 and 2013 have a built in functions which provides the user with powerful tools to monitor their project progress. One of the common issues in [...]


Dec 02, 2020
Using the 'Flash Fill' feature to apply the desired formatting in Excel 2013
Excel 2013 has the wonderful new feature called Flash Fill. This feature allows the user to split and combine text string as well as format the split or combined text [...]


Nov 10, 2020
How to create a template in Microsoft Outlook 2010 and 2013
Microsoft Outlook 2010 and 2013 have predefined templates you can use to maintain consistency in your emails to clients and people you interact with email messages. They [...]


Sep 15, 2020
Use conditional formatting to create a Gantt Chart
Efficient Project Management involves displaying the project plan in a visual format. The tool used to do this is called the Gantt Chart. The Gantt Chart is a list of [...]


Sep 12, 2020
How to import a Microsoft Access resources list into Microsoft Project file
In my previous blog post, I explained the settings you would need to change in Microsoft Project to ensure you’re able to import a Microsoft Access database. In this [...]


Jul 22, 2020
Access your Access files in Microsoft Project
As mentioned in my previous blog posts (3 settings that will increase your efficiency in Microsoft Project & Automatically reach your deadlines with scheduled tasks [...]


Jul 07, 2020
3 settings that will increase your efficiency in Microsoft Project
In my last blog post (Automatically reach your deadlines with scheduled tasks in Microsoft Project), I explained that there are a number of global settings in Microsoft [...]


Jun 23, 2020
Automatically reach your deadlines with scheduled tasks in Microsoft Project
In order to work more efficiently in Microsoft Project 2010 and 2013, there are a number of global settings you must change. If you don't change these global [...]


May 06, 2021
Calculate the Resources Standard Rate in Microsoft Project
In my previous blog post, I explained how to use custom fields to calculate GST in Microsoft Project. Now that we know how to do that, we can now use this custom field [...]


Apr 09, 2021
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 [...]


Mar 27, 2021
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 [...]


Mar 10, 2021
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 [...]


Jan 29, 2021
5 tips for successful project management
When it comes to project management, there are many challenges from beginning to end. There are several external and internal factors that may affect the original [...]


Jan 20, 2021
Earned Value Analysis with Microsoft Project
Why do project managers often fail in monitoring and controlling project plans? I've found the top reasons generally are inefficient ways to document and track the [...]


Dec 17, 2020
The impact of discounting and why you should not be offering it
What impact does discounting your products have on your profits? If you want to maintain the same amount of gross profit, how much more do you have to sell if you [...]