Learn all the formulas and functions you need to master Microsoft Excel and report on your data faster than ever before.
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.
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.
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.
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.
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)...
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.
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