Booking options
£9.99
£9.99
On-Demand course
5 weeks
All levels
At work, are you required to use the Microsoft Office 2016 suite, including Word, Excel, PowerPoint, Access, and Outlook? If so, then why not master both the basic and advanced features of these in order to fully benefit your career. Whether you’re a Microsoft Office 2016 beginner or otherwise, taking our popular Microsoft Office 2016 Complete Course will help you to learn new skills.
Packed into logical sections and bite-sized modules taught by experts in their field, the course teaches you everything you need to know to use each of the programmes in the Microsoft Office 2016 suite.
Working logically through all programmes, the course shows learners how to take full advantage of the Microsoft Office 2016 suite and improve productivity. On completion of the course, you’ll be able to create, edit and effectively maintain Word documents, workbooks and spreadsheets, presentations, desktop databases and emails. Students will also receive an internationally respected certification.
If you wish to show your employer that your Microsoft Office 2016 skills are outstanding, then this course is for you.
Why choose this course
Earn a free e-certificate upon successful completion.
Accessible, informative modules taught by expert instructors
Study in your own time, at your own pace, through your computer tablet or mobile device
Benefit from instant feedback through mock exams and multiple-choice assessments
Get 24/7 help or advice from our email and live chat teams
Full Tutor Support on Weekdays
Course Design
The course is delivered through our online learning platform, accessible through any internet-connected device. There are no formal deadlines or teaching schedules, meaning you are free to study the course at your own pace.
You are taught through a combination of
Video lessons
Online study materials
Mock exams
Multiple-choice assessment
Certification
After the successful completion of the final assessment, you will receive a CPD-accredited certificate of achievement. The PDF certificate is for £9.99, and it will be sent to you immediately after through e-mail. You can get the hard copy for £15.99, which will reach your doorsteps by post.
Who is this course for?
This course is ideal for anyone looking to gain Microsoft Office Specialist (MOS) certification. It is aimed at those who wish to develop their skills using Microsoft Office applications, or those in or seeking any office role, including that of PA, Secretary, Admin Assistant, and Administrator, Office Manager, and so on. No experience or previous qualifications are required, so it is available to all students, of all academic backgrounds.
Career Path
Administrative Assistant – £18K–£30K
Data Analyst – £25K–£45K
Office Manager – £24K–£40K
Executive Assistant – £25K–£50K
Financial Analyst – £30K–£60K
Project Coordinator – £22K–£38K
Course Contents
Microsoft Word 2016
Microsoft Excel 2016
Microsoft PowerPoint 2016
Microsoft Outlook 2016
Microsoft Access 2016
Microsoft Excel is a spreadsheet that is used for organising, analysing and visualising data. Through various features like data entry, data manipulation, charting and calculation, this makes it an ideal tool for project management, data handling and reporting, financial analysis, budgeting and so much more.
Simply put, Microsoft Excel is not entirely free. If you want full access then you will require a subscription or purchase. Otherwise, you can get it’s versions for free online and you can run it directly in your web browser. The free version is sufficient for most Excel users.
First you will need to sign in to your Microsoft account and find out the Microsoft 365 portal and select the option to install Microsoft Excel. Use the instructions provided to download and install it to your device. To activate the software, you will need to sign in to your Microsoft account again.
There are over hundreds of Excel functions that perform certain calculations or operations on data. The exact number depends on the version of Excel one is using but there is way more than enough to make sure a person takes years after years to master them.
There are many uses of Microsoft Excel. Any function you want to perform on a data, you can do it on Excel. However, the most common are data entry, data management, accounting, data analysis, financial analysis, charting and graphing, task management, time management, presentations and CRM.
Microsoft is considered to be one of the easiest tools to use out there. Mainly due to its user-friendly interface with hundreds of features. Another reason why it is easier for beginners boils down to the fact that it’s been there for years hence the thousands tutorials and courses available online. However, mastering the advanced features and functions will require a lot of practice, time and effort.
Yes certainly. In fact, Microsoft Excel is considered as one of the most valuable skills no matter what job you are applying for. Being proficient in Excel will instantly enhance your productivity and efficiency. Many employers look for candidates with strong Excel skills when hiring for certain positions.
While it not a true database management system, it can be used to store and organize data like a database. However, it lacks some of the advanced features of database softwares.
To password protect an Excel document, open the file and click on "File" > "Info" > "Protect Workbook" > "Encrypt with Password." Then enter a password, confirm it and save the document. The next time you open the file, you will have to enter the password to access it.