The sheer variety of options and range of tasks that can be performed by MS Office can seem bewildering and potentially limitless. A typical comment about MS Offices that “nobody uses even 10% of MS Office!”
Nowadays, for the vast majority of organizations, Ms Office is the essential tool, to keep business functioning and moving forward.
The suite of MS Office core applications, Excel, Word, PowerPoint and Outlook are all apparently intuitive to use but end-users know that there is a lot more ‘under the hood’that could be utilized. If only there was more time during the busy work day to explore the potential of MS Office.
Training is therefore often seen as the way of improving the efficiency and skills of the workforce through delivering a deeper understanding of how these core applications work.
But what type of training? At what level? To whom? And when should it be delivered?
Most organizations have different types of training, IT, soft skills, Health & Safety and more. Whoever has to organize the training, needs to have a good understanding of what potential delegates might need, what their current level of knowledge is and what topics within the application would be useful – so the person organizing the training needs to have an excellent knowledge of Outlook, Excel, Word and PowerPoint or be able quiz an expert who can then tailor training to provide focus to the training courses in order to deliver targeted training towards the needs of the delegates as well as the needs of the business as a whole.
So what aspects should one look for in the different applications that the delegates and the business need to be trained?
MS Outlook – The application for dealing with E-mails and more. Unless you have never used it before the training is often focused on the many tools and utilities available for creating content and/or dealing with the multitude ofe-mails received, making delegates more efficient and effective using Outlook. Also how to effectively manage calendaring – sending and receiving invitations for meeting and viewing other peoples’ calendars.
MS Excel – The numbering crunching application. A lot of people are a little bit intimidated by MS Excel. By understanding the basics such as operator precedence and formatting, then learning how to input and then how to wrangle data, doing lots of clever stuff with formulas and Functions, analyzing data and then displaying the data using Tables and Pivot Tables or visual tools like Conditional Formatting and Charts.
MS Word – Undoubtedly the most misunderstood application. It is far, far too easy to use this application in completely the wrong way. Ever had paragraphs moving around by themselves? Are you typing in complex numbering schema or Table of Contents? You might need a course on building blocks, templates and the ins and outs of styles to really ‘nail’ that formatting.
MS PowerPoint – The application to present your message. Easy-ish to use, but does your company use templates to standardize the way presentations look? Be aware of the security pitfalls of copying charts from Excel, applying transitions and animations effects to slides and objects and know the many useful shortcuts available to you while actually presenting including how to annotate on the ‘live’ presentation.
Nowadays, for the vast majority of organizations, Ms Office is the essential tool, to keep business functioning and moving forward.
The suite of MS Office core applications, Excel, Word, PowerPoint and Outlook are all apparently intuitive to use but end-users know that there is a lot more ‘under the hood’that could be utilized. If only there was more time during the busy work day to explore the potential of MS Office.
Training is therefore often seen as the way of improving the efficiency and skills of the workforce through delivering a deeper understanding of how these core applications work.
But what type of training? At what level? To whom? And when should it be delivered?
Most organizations have different types of training, IT, soft skills, Health & Safety and more. Whoever has to organize the training, needs to have a good understanding of what potential delegates might need, what their current level of knowledge is and what topics within the application would be useful – so the person organizing the training needs to have an excellent knowledge of Outlook, Excel, Word and PowerPoint or be able quiz an expert who can then tailor training to provide focus to the training courses in order to deliver targeted training towards the needs of the delegates as well as the needs of the business as a whole.
So what aspects should one look for in the different applications that the delegates and the business need to be trained?
MS Outlook – The application for dealing with E-mails and more. Unless you have never used it before the training is often focused on the many tools and utilities available for creating content and/or dealing with the multitude ofe-mails received, making delegates more efficient and effective using Outlook. Also how to effectively manage calendaring – sending and receiving invitations for meeting and viewing other peoples’ calendars.
MS Excel – The numbering crunching application. A lot of people are a little bit intimidated by MS Excel. By understanding the basics such as operator precedence and formatting, then learning how to input and then how to wrangle data, doing lots of clever stuff with formulas and Functions, analyzing data and then displaying the data using Tables and Pivot Tables or visual tools like Conditional Formatting and Charts.
MS Word – Undoubtedly the most misunderstood application. It is far, far too easy to use this application in completely the wrong way. Ever had paragraphs moving around by themselves? Are you typing in complex numbering schema or Table of Contents? You might need a course on building blocks, templates and the ins and outs of styles to really ‘nail’ that formatting.
MS PowerPoint – The application to present your message. Easy-ish to use, but does your company use templates to standardize the way presentations look? Be aware of the security pitfalls of copying charts from Excel, applying transitions and animations effects to slides and objects and know the many useful shortcuts available to you while actually presenting including how to annotate on the ‘live’ presentation.
