Booking options
£10.99
£10.99
On-Demand course
16 hours 38 minutes
All levels
Gain full proficiency in Microsoft Office and add a brand new qualification to your CV!
The Microsoft Office course is the ultimate training bundle package for Microsoft Office, taking you from beginner to expert in no time. You will learn how to perform a wide range of administrative tasks which will equip you with the most in-demand skills needed to work in an office-based role.
This course is a step-by-step instructor-guided course, taking you through key procedures, best practices and shortcuts. Master Microsoft Office in only one week and take your career to the next level!
Learning Outcomes
Attain mastery in navigating and utilising Excel 2016 for computations, formatting, and workbook management.
Develop advanced word processing abilities in Word 2016, from basic formatting to publishing.
Craft engaging presentations in PowerPoint 2016, integrating various media and graphics.
Gain expertise in data management through Access 2016, including data modification and report generation.
Enhance overall productivity by understanding and implementing Microsoft Office's efficient features.
Unlimited access to the course for a lifetime.
Opportunity to earn a certificate accredited by the CPD Quality Standards after completing this course.
Structured lesson planning in line with industry standards.
Immerse yourself in innovative and captivating course materials and activities.
Assessments are designed to evaluate advanced cognitive abilities and skill proficiency.
Flexibility to complete the Microsoft Office course Course at your own pace, on your own schedule.
Receive full tutor support throughout the week, from Monday to Friday, to enhance your learning experience.
Individuals aiming to bolster their digital productivity skills.
Professionals looking to advance their documentation and presentation prowess.
Data enthusiasts wanting to harness Excel's computational capabilities.
Students seeking comprehensive knowledge in Microsoft tools.
Administrative staff aiming for streamlined data management.
Data Analyst: £25,000 - £40,000
Administrative Assistant: £18,000 - £28,000
Presentation Designer: £23,000 - £35,000
Document Controller: £22,000 - £38,000
Office Manager: £25,000 - £45,000
Database Administrator: £30,000 - £50,000
This Microsoft Office course does not require you to have any prior qualifications or experience. You can just enrol and start learning.This Microsoft Office course was made by professionals and it is compatible with all PC's, Mac's, tablets and smartphones. You will be able to access the course from anywhere at any time as long as you have a good enough internet connection.
After studying the course materials, there will be a written assignment test which you can take at the end of the course. After successfully passing the test you will be able to claim the pdf certificate for £4.99 Original Hard Copy certificates need to be ordered at an additional cost of £8.
Excel 2016 | |||
Getting Started with Microsoft Office Excel 2016 | |||
Navigate the Excel User Interfact | 00:28:00 | ||
Use Excel Commands | 00:10:00 | ||
Create and Save a Basic Workbook | 00:19:00 | ||
Enter Cell Data | 00:12:00 | ||
Use Excel Help | 00:05:00 | ||
Performing Calculations | |||
Create Worksheet Formulas | 00:15:00 | ||
Insert Functions | 00:17:00 | ||
Reuse Formulas and Functions | 00:17:00 | ||
Modifying a Worksheet | |||
Insert, Delete, and Adjust Cells, Columns, and Rows | 00:10:00 | ||
Search for and Replace Data | 00:09:00 | ||
Use Proofing and Research Tools | 00:07:00 | ||
Formatting a Worksheet | |||
Apply Text Formats | 00:16:00 | ||
Apply Number Format | 00:07:00 | ||
Align Cell Contents | 00:09:00 | ||
Apply Styles and Themes | 00:12:00 | ||
Apply Basic Conditional Formatting | 00:11:00 | ||
Create and Use Templates | 00:08:00 | ||
Printing Workbooks | |||
Preview and Print a Workbook | 00:10:00 | ||
Set Up the Page Layout | 00:09:00 | ||
Configure Headers and Footers | 00:07:00 | ||
Managing Workbooks | |||
Manage Worksheets | 00:05:00 | ||
Manage Workbook and Worksheet Views | 00:07:00 | ||
Manage Workbook Properties | 00:06:00 | ||
Word 2016 | |||
Getting Started with Word | |||
Navigate in Microsoft Word | 00:12:00 | ||
Create and Save Word Documents | 00:24:00 | ||
Manage Your Workspace | 00:06:00 | ||
Edit Documents | 00:16:00 | ||
Preview and Print Documents | 00:04:00 | ||
Customize the Word Environment | 00:08:00 | ||
Formatting Text and Paragraphs | |||
Apply Character Formatting | 00:17:00 | ||
Control Paragraph Layout | 00:19:00 | ||
Align Text Using Tabs | 00:07:00 | ||
Display Text in Bulleted or Numbered Lists | 00:03:00 | ||
Apply Borders and Shading | 00:05:00 | ||
Working More Efficiently | |||
Make Repetitive Edits | 00:06:00 | ||
Apply Repetitive Formatting | 00:10:00 | ||
Use Styles to Streamline Repetitive Formatting Tasks | 00:14:00 | ||
Managing Lists | |||
Sort a List | 00:05:00 | ||
Format a List | 00:06:00 | ||
Adding Tables | |||
Insert a Table | 00:07:00 | ||
Modify a Table | 00:06:00 | ||
Format a Table | 00:03:00 | ||
Convert Text to a Table | 00:04:00 | ||
Inserting Graphic Objects | |||
Insert Symbols and Special Characters | 00:04:00 | ||
Add Images to a Document | 00:11:00 | ||
Controlling Page Appearance | |||
Apply a Page Border and Color | 00:03:00 | ||
Add Headers and Footers | 00:06:00 | ||
Control Page Layout | 00:05:00 | ||
Add a Watermark | 00:04:00 | ||
Preparing to Publish a Document | |||
Check Spelling Grammar and Readability | 00:07:00 | ||
Use Research Tools | 00:06:00 | ||
Check Accessibility | 00:03:00 | ||
Save a Document to Other Formats | 00:04:00 | ||
Workbooks - Microsoft Word 2016 (Beginner) | |||
Workbooks - Microsoft Word 2016 (Beginner) | 00:00:00 | ||
PowerPoint 2016 | |||
PowerPoint Interface | |||
Navigate the PowerPoint Environment | 00:28:00 | ||
View and Navigate a Presentation | 00:15:00 | ||
Create and Save a PowerPoint Presentation | 00:13:00 | ||
Use PowerPoint Help | 00:10:00 | ||
Presentation Basics | |||
Select a Presentation Type | 00:08:00 | ||
Edit Text | 00:13:00 | ||
Build a Presentation | 00:27:00 | ||
Formatting | |||
Format Characters | 00:11:00 | ||
Format Paragraphs | 00:16:00 | ||
Format Text Boxes | 00:09:00 | ||
Inserting Options | |||
Insert Images | 00:10:00 | ||
Insert Shapes | 00:15:00 | ||
Working with Objects | |||
Edit Objects | 00:16:00 | ||
Format Objects | 00:06:00 | ||
Group Objects | 00:04:00 | ||
Arrange Objects | 00:07:00 | ||
Animate Objects | 00:07:00 | ||
Table | |||
Create a Table | 00:09:00 | ||
Create a Table | 00:09:00 | ||
Insert a Table from Other Microsoft Office Applications | 00:06:00 | ||
Charts | |||
Create a Chart | 00:10:00 | ||
Format a Chart | 00:10:00 | ||
Insert a Chart from Microsoft Excel | 00:05:00 | ||
Review and Presentatin | |||
Review Your Presentation | 00:11:00 | ||
Apply Transitions | 00:05:00 | ||
Print Your Presentation | 00:05:00 | ||
Deliver Your Presentation | 00:08:00 | ||
Access 2016 | |||
Introduction to Access | |||
Orientation to Microsoft Access1 | 00:39:00 | ||
Create a Simple Access Database | 00:10:00 | ||
Get Help and Configure Options in Microsoft Access | 00:06:00 | ||
Modify Data | |||
Modify Table Data | 00:17:00 | ||
Sort and Filter Records | 00:05:00 | ||
Working with Queries | |||
Create Basic Queries | 00:15:00 | ||
Sort and Filter Data in a Query | 00:14:00 | ||
Perform Calculations in a Query | 00:08:00 | ||
Access Forms | |||
Create Basic Access Forms | 00:07:00 | ||
Work with Data on Access Forms | 00:23:00 | ||
Working with Reports | |||
Create a Report | 00:23:00 | ||
Add Controls to a Report | 00:12:00 | ||
Enhance the Appearance of a Report | 00:05:00 | ||
Prepare a Report for Print | 00:03:00 | ||
Organize Report Information | 00:15:00 | ||
Format Reports | 00:12:00 |
Studyhub is a premier online learning platform which aims to help individuals worldwide to realise their educational dreams. For 5 years, we have been dedicated...