Course Library View the full range of courses
-
Accounting (92 courses)
- Xero Accounting and Bookkeeping Online
- Sage 50 Accounting & Payroll
- Project Finance
- Financial Modelling Training
- Tax Accounting
- Introduction to VAT
- Accounting and Finance Course for Managers
- Internal Compliance Auditor
- Financial Statement Analysis
- Payroll Administrator Level 3 Diploma
- View all Accounting courses
-
Language (58 courses)
- British Sign Language (BSL) Level 1 & 2
- Speech and Language Therapy Diploma
- TEFL (TESOL) Course
- English Spelling, Punctuation, and Grammar
- Child & Adult Speech & Language Disorders Training
- Teaching English as Foreign Language (TEFL) Certificate
- Mastering Spanish Language
- French Course for Beginners
- German Course for Beginners
- Body Language and Gesture Training
- View all Language courses
-
Teaching & Education (37 courses)
- Teaching Assistant Complete Course (TA, SEN, Autism, ADHD & Dyslexia) – CPD Certified
- EYFS Teaching Assistant Training Course
- Advanced Diploma in Coaching and Mentoring
- Level 3 Diploma in Teaching and Classroom Management
- Remote Teaching
- SENCO – Special Educational Needs Coordination
- Teaching English as Foreign Language (TEFL)
- Life Coaching
- Phonics Teaching Diploma
- View all Teaching & Education courses
-
Health and Social Care (137 courses)
- Health and Social Care Management
- Paediatric Nursing Assistant
- Mental Health Awareness Training
- Emergency Medicine – Paramedicine
- Level 3 Diploma in Adult Care
- Paediatric First Aid Training
- Safeguarding Children Level 3
- Level 3 Diploma in Anatomy and Physiology of Human Body
- Play Therapy
- The Care Certificate Preparation – Standards (1 to 15)
- View all Health and Social Care courses
-
Management (346 courses)
- Office Admin, Secretarial and PA Diploma
- Estate Agent and Property Management Training
- Diploma in Data Analysis Fundamentals
- Advanced Diploma in Stress & Anxiety Management
- Good Manufacturing Practice (GMP)
- Property Development and Management Course
- Diploma in Hotel Management
- Supply Chain Management
- Quality Assurance (QA) Manager
- Compliance and Risk Management
- View all Management courses
-
IT & Software (117 courses)
- Coding with Python 3
- Search Engine Optimisation (SEO) Training
- Cyber Security
- Motion Graphics with After Effects
- CompTIA A+ Core 1 (220-1101) Course
- Machine Learning for Aspiring Data Scientists
- Next.js Web Dev: Master this Powerful React Framework
- Learn 2D Animation with Adobe Animate
- GDPR Challenges in Education
- View all IT & Software courses
-
Employability (863 courses)
- Office Administrator Skills
- Presentation Skills
- Legal Secretary and Office Skills
- Hospitality Management
- Estate Agent Diploma
- Hairdressing and Barbering
- Diploma in UK Employment Law
- Diploma in Data Analysis Fundamentals
- Building Surveyor Training
- Emotional Intelligence Training
- View all Employability courses
-
Personal Development (1332 courses)
- Productivity Habits
- Minute Taking Course
- Presentation Skills
- Excel: Top 50 Microsoft Excel Formulas in 50 Minutes!
- Critical Thinking and Problem Solving Skills
- Time Management
- Self Esteem and Confidence Building Course
- Essential IT Skills
- Legal Secretary and Office Skills
- Personality Development
- View all Personal Development courses
Microsoft Office 2016 Complete Course
6273 Students (7 Reviews)
This course is All in one complete MS office training from beginner to expert level. If you are working in any field like engineering, auditing, data analyzing, data entry or any field where Microsoft Office products are used you can choose this course to gain the skill as per your requirement.
GET THIS COURSE AND 3000+ OTHERS FOR ONLY £49 PER YEAR. FIND OUT MORE
Learning how to use Microsoft Office is a job skill nowadays. However, most people are unaware of how to utilise or even begin using MS Office. This is why we created this Microsoft Office 2016 Complete Course.
In this Microsoft Office 2016 Complete Course, you will learn how to use Microsoft Office. Microsoft Office contains many tools, like Microsoft Word, Excel, PowerPoint, Outlook, Access, and others. Additionally, learning all of this at once might be challenging. This course has been divided into a number of manageable, compact sections.
At the end of this course, you will be able to use Microsoft Office to create realisable documents, PowerPoint presentations, spreadsheets, and so much more.
Sneak Peek
Learning Outcomes
- MS Word: Create, edit, save, and print documents to include documents with lists and tables using functions such as find and replace; cut, copy, replace.
- MS Excel: You will learn about basic Excel skills all the way to advanced tools and functions.
- MS Powerpoint: Create, edit, save, and print presentations that include text, graphics, animation, transitions and much more.
- MS Outlook: You will use Outlook to send, receive, and manage email messages, manage your contact information, schedule appointments, meetings etc.
- MS Access: Learn basic database management skills, expand your knowledge of relational database design, write advanced queries, structure existing data, validate data entered into a database, and customize reports.
Why choose this course
- Affordable, Accessible, informative and well-structured study materials
- Earn a globally recognised accredited qualification
- Study in your own time, at your own pace, through any device
- Benefit from feedback through mock exams and multiple-choice assessments
- Excellent career advancement/career switch opportunities
- Get 24/7 help or advice from our email and live chat teams
Who is this course for
Microsoft Office 2016 Complete Course is appropriate for anybody seeking substantial information, possible experience, and expert abilities in the associated profession. This is an excellent chance for students of various academic backgrounds to learn more about this topic.
Sneak Peek
Entry requirements
This course is available to learners of all academic backgrounds, but you must be 16 or above to undertake the qualification.
Apart from that, all you need is an internet connection, a good understanding of English and a passion for learning.
Sneak Peek
Certification
Endorsed Certificate of Achievement from the Quality Licence Scheme
Once the course has been completed and the assessment has been passed, all students are entitled to receive an endorsed certificate. This will provide proof that you have completed your training objectives, and each endorsed certificate can be ordered and delivered to your address for only £119. Please note that overseas students may be charged an additional £10 for postage.
CPD Accredited Certificate
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.
Method of Assessment
On successful completion of the Microsoft Office 2016 Complete Course, you will be required to sit an online multiple-choice assessment. You will need to score 60% or above to pass the course. After successfully passing the exam, you will be able to apply for Quality Licence Scheme endorsed certificate of achievement. The assessment will be evaluated automatically and the results will be given to you immediately.
Career path
People of all backgrounds can use Microsoft Office 2016 Complete Course to ensure their personal and expert development.
Course Curriculum
| Microsoft Word 2016 | |||
| Modify User Information | 00:15:00 | ||
| Share a Document | 00:30:00 | ||
| Work with Comments | 00:15:00 | ||
| Compare Document Changes | 00:15:00 | ||
| Review a Document | 00:15:00 | ||
| Merge Document Changes | 00:15:00 | ||
| Coauthor Documents | 00:15:00 | ||
| Add Captions | 00:15:00 | ||
| Add Cross-References | 00:15:00 | ||
| Add Bookmarks | 00:15:00 | ||
| Add Hyperlinks | 00:15:00 | ||
| Insert Footnotes and Endnotes | 00:15:00 | ||
| Add Citations | 00:30:00 | ||
| Insert a Bibliography | 00:15:00 | ||
| Insert Blank and Cover Pages | 00:15:00 | ||
| Insert an Index | 00:30:00 | ||
| Insert a Table of Contents | 00:30:00 | ||
| Insert an Ancillary Table | 00:15:00 | ||
| Manage Outlines | 00:30:00 | ||
| Create a Master Document | 00:30:00 | ||
| Suppress Information | 00:30:00 | ||
| Set Editing Restrictions | 00:30:00 | ||
| Add a Digital Signature to a Document | 00:15:00 | ||
| Restrict Document Access | 00:15:00 | ||
| Create Forms | 00:30:00 | ||
| Manipulate Forms | 00:15:00 | ||
| Form Data Conversion | 00:15:00 | ||
| Create a New Document Version | 00:30:00 | ||
| Compare Document Versions | 00:15:00 | ||
| Merge Document Versions | 00:15:00 | ||
| Activities – Microsoft Word 2016 Advanced | 00:00:00 | ||
| Microsoft Excel 2016 | |||
| Update Workbook Properties | 00:15:00 | ||
| Activity-Update Workbook Properties | 00:05:00 | ||
| Create and Edit a Macro | 00:15:00 | ||
| Activity-Create and Edit a Macro | 00:05:00 | ||
| Apply Conditional Formatting | 00:15:00 | ||
| Activity-Apply Conditional Formatting | 00:05:00 | ||
| Add Data Validation Criteria | 00:15:00 | ||
| Activity-Add Data Validation Criteriaty | 00:05:00 | ||
| Trace Cells | 00:15:00 | ||
| Activity-Trace Cells | 00:05:00 | ||
| Troubleshoot Invalid Data and Formula Errors | 00:15:00 | ||
| Activity-Troubleshoot Invalid Data and Formula Errors | 00:05:00 | ||
| Watch and Evaluate Formulas | 00:15:00 | ||
| Activity-Watch and Evaluate Formulas | 00:05:00 | ||
| Create a Data List Outline | 00:15:00 | ||
| Activity-Create a Data List Outline | 00:05:00 | ||
| Create Sparklines | 00:15:00 | ||
| Activity_Create Sparklines | 00:05:00 | ||
| Create Scenarios | 00:15:00 | ||
| Activity-Create Scenarios | 00:05:00 | ||
| Perform a What-If Analysis | 00:15:00 | ||
| Activity-Perform a What-If Analysis | 00:05:00 | ||
| Perform a Statistical Analysis with the Analysis ToolPak | 00:15:00 | ||
| Activity-Perform a Statistical Analysis with the Analysis ToolPak | 00:05:00 | ||
| Create Interactive Data with Power View | 00:15:00 | ||
| Activity-Create Interactive Data with Power View | 00:05:00 | ||
| Consolidate Data | 00:15:00 | ||
| Activity-Consolidate Data | 00:05:00 | ||
| Link Cells in Different Workbooks | 00:15:00 | ||
| Activity-Link Cells in Different Workbooks | 00:05:00 | ||
| Merge Workbooks | 00:15:00 | ||
| Activity-Merge Workbooks | 00:05:00 | ||
| Export Excel Data | 00:15:00 | ||
| Activity-Export Excel Data | 00:05:00 | ||
| Import a Delimited Text File | 00:14:00 | ||
| Activity- Import a Delimited Text File | 00:05:00 | ||
| Integrate Excel Data with the Web | 00:15:00 | ||
| Activity-Integrate Excel Data with the Web | 00:05:00 | ||
| Create a Web Query | 00:15:00 | ||
| Activity-Create a Web Query | 00:05:00 | ||
| Import and Export XML Data | 00:15:00 | ||
| Activity-Import and Export XML Data | 00:05:00 | ||
| Activities and Exercise Files – Microsoft Excel 2016 Advanced | 00:00:00 | ||
| Microsoft PowerPoint 2016 | |||
| Customize the User Interface | 01:30:00 | ||
| Set PowerPoint 2016 Options | 00:45:00 | ||
| Create and Manage Sections | 01:00:00 | ||
| Modify Slide Masters and Slide Layouts | 01:15:00 | ||
| Add Headers and Footers | 00:30:00 | ||
| Modify the Notes Master and the Handout Master | 00:45:00 | ||
| Create SmartArt | 00:45:00 | ||
| Modify SmartArt | 01:00:00 | ||
| Add Audio to a Presentation | 00:45:00 | ||
| Add Video to a Presentation | 01:00:00 | ||
| Customize Animations and Transitions | 01:00:00 | ||
| Add Comments to a Presentation | 00:45:00 | ||
| Review a Presentation | 00:45:00 | ||
| Store and Share Presentations on the Web | 01:30:00 | ||
| Annotate a Presentation | 00:45:00 | ||
| Set Up a Slide Show | 00:45:00 | ||
| Create a Custom Slide Show | 00:30:00 | ||
| Add Hyperlinks and Action Buttons | 00:45:00 | ||
| Record a Presentation | 00:15:00 | ||
| Secure a Presentation | 01:30:00 | ||
| Present a Slide Show Online | 01:00:00 | ||
| Create a Video or a CD | 00:45:00 | ||
| Activities – Microsoft PowerPoint 2016 Advanced | 00:00:00 | ||
| Microsoft Outlook 2016 | |||
| Insert Advanced Characters and Objects | 01:30:00 | ||
| Modify Message Settings, Properties, and Options | 01:30:00 | ||
| Use Automatic Replies | 01:30:00 | ||
| Sort Messages | 00:45:00 | ||
| Filter Messages | 01:00:00 | ||
| Organize Messages | 02:00:00 | ||
| Search Messages | 01:30:00 | ||
| Manage Junk Mail | 01:00:00 | ||
| Manage Your Mailbox | 02:00:00 | ||
| Manage Advanced Calendar Options | 00:45:00 | ||
| Manage Additional Calendars | 01:00:00 | ||
| Manage Meeting Responses | 00:45:00 | ||
| Assign and Manage Tasks | 01:00:00 | ||
| Edit an Electronic Business Card | 01:00:00 | ||
| Manage Advanced Contact Options | 01:30:00 | ||
| Forward Contacts | 00:30:00 | ||
| Export Contacts | 01:00:00 | ||
| Delegate Access to Mail Folders | 01:00:00 | ||
| Share Your Calendar | 00:30:00 | ||
| Share Your Contacts | 00:15:00 | ||
| Back Up Outlook Items | 00:45:00 | ||
| Change Data File Settings | 00:45:00 | ||
| Configure E-mail Message Security Settings | 00:30:00 | ||
| Activities – Microsoft Outlook 2016 Advanced | 00:00:00 | ||
| Microsoft Access 2016 | |||
| Add Controls to Forms | 01:00:00 | ||
| Set Form Controls | 01:00:00 | ||
| Create Subforms | 00:30:00 | ||
| Organize Information with Tab Pages | 00:30:00 | ||
| Enhance Navigation with Forms | 00:30:00 | ||
| Format a Form | 01:00:00 | ||
| Apply Conditional Formatting | 00:30:00 | ||
| Field Validation | 00:30:00 | ||
| Form and Record Validation | 00:30:00 | ||
| Create a Macro | 01:00:00 | ||
| Restrict Records Using a Condition | 00:30:00 | ||
| Validate Data Using a Macro | 00:30:00 | ||
| Automate Data Entry Using a Macro | 00:30:00 | ||
| Convert a Macro to VBA | 00:30:00 | ||
| Link Tables to External Data Sources | 00:30:00 | ||
| Manage a Database | 00:30:00 | ||
| Determine Object Dependency | 00:30:00 | ||
| Document a Database | 00:30:00 | ||
| Analyze the Performance of a Database | 00:30:00 | ||
| Split a Database for Multiple User Access | 00:30:00 | ||
| Implement Security | 00:30:00 | ||
| Set Passwords | 00:30:00 | ||
| Convert an Access Database to an ACCDE File | 00:30:00 | ||
| Package a Database with a Digital Signature | 00:30:00 | ||
| Create a Database Switchboard | 01:00:00 | ||
| Modify a Database Switchboard | 00:30:00 | ||
| Set Startup Options | 00:30:00 | ||
| Activities – Microsoft Access 2016 Advanced | 00:00:00 | ||
| Mock Exam | |||
| Mock Exam – Microsoft Office 2016 Complete Course | 00:30:00 | ||
| Final Exam | |||
| Final Exam – Microsoft Office 2016 Complete Course | 00:30:00 | ||
| Assignment | |||
| Assignment – Microsoft Office 2016 Complete Course | 1 week, 3 days | ||
| Recommended Materials | |||
| Workbook – Microsoft Office 2016 Complete Course | 2 weeks, 2 days | ||
| Order Your Certificate | |||
| Order your Certificate QLS | 00:00:00 | ||
Course Reviews
Original price was: £319.£25Current price is: £25. ex Vat
SAVE 92% - OFFER ENDS IN
ALL
COURSES FOR £49 
14-Day Money-Back Guarantee
-
-
-
Fully Online
Frequently asked questions
Can’t find the anwser you’re looking for ? Reach out to customer support team.
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.
What are the 5 basic functions of Excel?
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.
I was wary of trusting online courses as I falsely believed that the learning would be too impersonal. However, this course was the opposite of my fears and I am so glad I took it. The lessons were highly personal and I could use the filter to skip any parts that I already knew. I learnt how to customise Word, improve productivity with Outlook and even how useful SharePoint could be to businesses. Couldn’t recommend more!
Outstanding
As a secretary at a small primary school, Microsoft Office is something I use every day. I am always eager to maintain what I know and learn something new, so I took this course and I am over the moon that I did. For the price I paid, it was an amazing opportunity to soak up new skills using a variety of Microsoft programmes, including Word, Excel, PowerPoint and Outlook. I use these every day in my job, but now I will be able to show off my new knowledge and get more work done than ever before
Karen Mitchell
I got so many activities learnt from this course that I was unaware of earlier. Thanks to all the members for designing this course.
Kieran Bailey
Great course! I’ve learnt how to use Microsoft to create professional looking documents, PowerPoint presentations, spreadsheets and so much more.
Dennis Fox
Thanks a lot for this informative and practically applicable session. I’ve learnt a lot!
Patrick Hooper
Really excellent course.I’ve learnt the basic concepts of Microsoft Office.Thanks to the instructor and the team!
Scott Morton
I learned a great deal about various microsoft office tools. The learning session was awesome, and I really appreciate it!