Articles written by: Magdalena Todor

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 [...]

top
Back to top