Online Microsoft Office Training Courses

17 October 2018

Some businesses want their staff trained to use Microsoft applications but can’t afford to send them away for a few days due to added expense and time lost away from the organisation.

However, we have a series of online Microsoft training courses that will develop your employees’ understanding of the programs while keeping costs down, saving time.

They are also incredibly easy to access and can be viewed across all devices, including desktop and mobile.

The online Microsoft courses we have available are centred around Excel and Project, two of the most important applications for businesses.

Microsoft Excel

Microsoft Excel spreadsheets are integral to all businesses in every sector. It is very flexible, meaning users can structure information however they please.

Employees that can master using Excel will be able to produce high quality work but in order to get to grips with the more technical features, training is highly recommended.

We have the following Microsoft Excel online courses:

A Beginners Introduction To Excel
Fundamentals for Advanced Users
Advanced Formulas and Functions for Excel

All courses are taught by Richard Walters, a Microsoft Certified Trainer who has been training Microsoft Excel for the past 9 years throughout the UK.

A Beginners Introduction To Excel

Are you looking to build your skills in using Microsoft Excel?

This course gives you a deep understanding of how to use some of the most popular functions in Excel. We will build you from a base skill level and assume you have no prior knowledge in using Microsoft Excel or its functions.

In this course we will cover Excel Basics, Formatting and Manipulation, Creating Formulas and Cell Referencing, Automatic Functions, Creating and Formatting Charts, Managing and Linking Worksheets, Using AutoFill, Freeze Panes and Printing.

As an example of what we have to offer, here is a video on how to freeze panes in Excel:

Fundamentals for Advanced Users

Are you looking to improve your Excel skills to become an advanced level user?

This course gives you a deep understanding of how to use some of the advanced level features in Microsoft Excel. We will assume you have all the knowledge taught in our prerequisite course, Microsoft Excel – A Beginners Introduction To Excel.

In this course we will cover a variety of advanced level Functions, Advanced Charts, Paste Special, Scenario’s Formulas Auditing and Locking and Security.

It’s perfect for those that are looking to improve their Excel working knowledge.

Advanced Formulas and Functions for Excel

This course is most appropriate for students looking for a comprehensive, engaging, and interactive approach to Excel training

This course gives you a deep understanding of how to use some of the most popular formulas functions in Excel. We will build you from a base skill level but will assume you have a good working knowledge of Microsoft Excel before we go into more advanced features.

In this course we will cover some advanced Excel features, such as Nested functions, IF functions, VLOOKUP, HLOOKUP, Match and Index and many more! Upon completion, you will also receive a Verifiable Certificate of Completion.

Microsoft Project Training Courses

Microsoft Project is designed for managers to build and execute projects easily and effectively.

However, like Excel, to get the most out of the program, training is required so your managers can improve their understanding and use the information to deliver better results.

We have the following Microsoft Project online courses:

• Microsoft Project Fundamental Skills for Users
• Microsoft Project: 10 Steps To Using MS Project
• Programme Management Using Microsoft Project
• How To Use Automation Features In Microsoft Project

Your trainer for these courses will again be Richard Walters, who has been training Microsoft Project for just as long as developing Excel skills.

Microsoft Project Fundamental Skills for Users

Are you looking to build your skills in using Microsoft Project?

Microsoft Project is fast becoming the must have project management tool of choice. This course is designed to teach you the necessary skills every Microsoft Project user should be familiar with.

In this course we will cover Task Management, Constraints, Resources, Calendar Management, Managing A Project and Print Settings.

Microsoft Project: 10 Steps To Using MS Project

This 10-step approach, which has been developed and delivered to organisations throughout the UK over the past 10 years, teaches you the fundamental skills of controlling and implementing a project using Microsoft Project.

In this course we will start from the beginning and discuss the initial stage of any project – the Project Initiation Document (step 1).

Once complete, we will move onto utilising Microsoft Project and will learn how to Customise Microsoft Project, Set a Project Start or Finish Date, Enter Date into Microsoft Project, Modify Tasks and Enter Resources, Assign Resources To Tasks, Display Project Costs and Set a Project Baseline.

Programme Management Using Microsoft Project

This course is designed to teach you to utilise some of the more advanced features within Microsoft Project.

In this course we will cover Tables, Reports, Custom Fields and the Project Organiser. You will also learn how to use Sub Projects and Resource Pools for multiple projects.

The development course is perfect for project managers and project professionals.
data Analysts who use Microsoft Project.

How To Use Automation Features In Microsoft Project

This course is designed to help you understand and control some of the automated features within Microsoft Project.

In this course we will cover the automated management of Standard and Resource Calendars, Task Linking, Project Start and Finish Dates, Constraints, Lag and Lead and Resources.

Here is an example training video of linking tasks in Microsoft Project, so you know what to expect from our training:

Be sure to contact us if you would like further information about any of these courses or if you have any other queries.

We also have a variety of classroom classes to develop knowledge and understanding of other key areas of business.