Blog

Learn all the formulas and functions you need to master Microsoft Excel and report on your data faster than ever before.

Modifying the Microsoft Excel quick access toolbar
August 7, 2020
Modifying the Microsoft Excel quick access toolbar
Paul Silverman

In our short Microsoft Excel tutorial below you'll learn how to quickly add frequently used icons to the quick access toolbar. It's a great time saver; by placing your high-usage icons in this always-visible area, you'll no longer have to hunt through ribbon tabs to find the tools you need.

Read more
How to use Excel Text functions to separate first and last names in single columns
August 7, 2020
How to use Excel Text functions to separate first and last names in single columns
Paul Silverman

We were working with a client in Melbourne recently, and a question came up (yet again) about how to manage some text that had been imported into Excel from an external database. This is becoming more common, as the number of people increases who use Excel to manipulate data originating from outside databases.

Read more
How to Modify the Ribbon in Excel 2013
August 7, 2020
How to Modify the Ribbon in Excel 2013
Paul Silverman

As Microsoft Excel has grown from its early versions, large numbers of functions have been added with each successive version. By the 2003 version of Excel, there were so many additional tools that the number of toolbars needed to hold them had started to become unworkable.

Read more
Five factors to ensure your onsite training experience is a success
August 7, 2020
Five factors to ensure your onsite training experience is a success
Paul Silverman

An on-site Excel course provides a great opportunity for participants to jump ahead in their knowledge and understanding of the most popular electronic spreadsheet program in the world. When training on-site, consider . the difference between a standard software course and one which will really boost a participant’s ability to use Excel effectively.

Read more
Office 365 versus Office 2013 – What’s the difference?
August 7, 2020
Office 365 versus Office 2013 – What’s the difference?
Paul Silverman

Among Excel users there’s a degree of uncertainty about the difference between Office 365 and Office 2013 . It’s a relatively new area, and while most of us are clear about what Excel 2013 is, it’s Office 365 that’s causing the confusion. Some consider that Office 365 is just another name for Excel 2013 (which isn’t the case)...

Read more
Microsoft Excel’s history - from 1982 until today
August 7, 2020
Microsoft Excel’s history - from 1982 until today
Paul Silverman

The electronic spreadsheet has been in existence since 1978, but it was 1982 that Microsoft became involved. The first major leap occurred in 1978 when VisiCalc was created by Dan Bricklin, a student at Harvard Business School. It was basic software, capable of producing a spreadsheet of only 5 columns by 20 rows.

Read more
Microsoft Excel 3 training - use it or lose it!
August 7, 2020
Microsoft Excel 3 training - use it or lose it!
Paul Silverman

Participants in any work-related training course are never more excited than when they learn a technique or tool that has an immediate application in the work they’re doing. If we, as participants, recognise that a newly-learned tool will increase our productivity we’ll leap on it, especially in today’s work environment

Read more