• LOGIN
  • No products in the basket.

Master Microsoft Office and take on any administrative task with confidence and proficiency, with step-by-step online training and guidance. The Complete Microsoft Office Bundle: Beginner to Advanced Course with Lifetime Access is designed for learners of all levels, taking you through the key features and functions of Microsoft Word, Excel, Outlook, Access and PowerPoint. Learn how to create winning work presentations, sort and filter data, create structured Word documents, and much more.

Discover how to insert graphics and format text, input tables, charts and graphs, create electronic spreadsheets and manage your contacts efficiently. Learn how to navigate the interface of each program and customise your work pages and presentations. Understand how to control page appearance and edit your documents, so they are ready for printing. You will be able to add valuable transferable skills to your resume that will open up new career opportunities in any office environment.

With step-by-step instruction and video guidance, you’ll soon develop complete proficiency in the world’s leading office software. Enrol today, and get certified in as little as 20/30 hours! There are no specific entry requirements for this course, which can be studied on a part-time or full-time basis from any device with an internet connection.

Learning Outcomes:

  • Learn how to perform calculations, modify worksheets, and manage workbooks in Excel
  • Understand how to format text and paragraphs, manage lists and add tables
  • Know how to insert graphics objects, control page appearance and publish a document
  • Work confidently and proficiently with tables, charts and graphs
  • Understand how to navigate the PowerPoint interface and customise presentation slides
  • Create electronic spreadsheets, manage contacts, work with notes, and much more
  • Improve your job prospects with a recognised qualification in Microsoft Office
  • Take your office-based role to the next level and improve your administrative skills

Assessment and Certification

At the end of the course, you will be required to sit an online multiple-choice test. Your test will be assessed automatically and immediately so that you will instantly know whether you have been successful. After you have successfully passed the final exam, you will be able to order an Accredited Certificate of Achievement at an additional cost of £19 for a PDF copy and £29 for an original print copy sent to you by post or for both £39.

Career Path

Go from beginner to expert in no time with this complete Microsoft Office training package, and receive a recognised certificate of achievement to add great value and credentials to your CV, which will help you to stand out to prospective employers. Gain the skills to create winning work presentations and master everyday administrative tasks with confidence.

Microsoft Office Bundle
$415.94 inc Vat TAKE THIS COURSE

Course Curriculum

Excel 2016
Getting Started with Microsoft Office Excel 2016
Navigate the Excel User Interface 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:17:00
Apply Number Formats 00:08: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:07:00
Printing Workbooks
Preview and Print a Workbook 00:10:00
Set Up the Page Layout 00:08: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:05: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:04: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
PowerPoint 2016
PowerPoint Interface
Navigate the PowerPoint Environment 00:30:00
View and Navigate a Presentation 00:15:00
Create and Save a PowerPoint Presentation 00:15:00
Use PowerPoint Help 00:10:00
Presentation Basics
Select a Presentation Type 00:15:00
Edit Text 00:15:00
Build a Presentation 00:15:00
Formatting
Format Characters 00:15:00
Format Paragraphs 00:30:00
Format Text Boxes 00:15:00
Inserting Options
Insert Images 00:30:00
Insert Shapes 00:15:00
Working with Objects
Edit Objects 00:30:00
Format Objects 00:15:00
Group Objects 00:15:00
Arrange Objects 00:15:00
Animate Objects 00:15:00
Table
Create a Table 00:15:00
Format a Table 00:15:00
Insert a Table from Other Microsoft Office Applications 00:15:00
Charts
Create a Chart 00:15:00
Format a Chart 00:15:00
Insert a Chart from Microsoft Excel 00:15:00
Review and Presentation
Review Your Presentation 00:30:00
Apply Transitions 00:15:00
Print Your Presentation 00:15:00
Deliver Your Presentation 01:00:00
Access 2016
Introduction to Access
Orientation to Microsoft Access 01:00:00
Create a Simple Access Database 01:00:00
Cover Your Assets And Your Customers 03:00:00
Modify Data
Modify Table Data 00:30:00
Sort and Filter Records 00:30:00
Working with Queries
Create Basic Queries 00:30:00
Sort and Filter Data in a Query 01:00:00
Perform Calculations in a Query 00:30:00
Access Forms
Basic Knowledge on Billings 00:30:00
Work with Data on Access Forms 00:23:00
Working with Reports
Create a Report 01:00:00
Add Controls to a Report 00:30:00
Enhance the Appearance of a Report 00:30:00
Prepare a Report for Print 00:30:00
Organize Report Information 00:30:00
Format Reports 00:30:00
Outlook 2016
Navigate the Outlook Interface 00:15:00
Perform Basic E-mail Functions 00:30:00
Use Outlook Help 00:15:00
Create an E-mail Message 00:15:00
Check Spelling and Grammar 00:30:00
Format Message Content 00:15:00
Attach Files and Items 00:15:00
Enhance an E-mail Message 00:30:00
Manage Automatic Message Content 00:09:00
Customize Reading Options 00:06:00
Work with Attachments 00:15:00
Manage Your Message Responses 00:09:00
Manage Messages Using Tags, Flags, and Other Commands 00:15:00
Organize Messages Using Folders 00:04:00
View the Calendar 00:15:00
Manage Appointments 00:07:00
Manage Meetings 00:12:00
Print Your Calendar 00:01:00
Create and Update Contacts 00:06:00
View and Organize Contacts 00:04:00
Create Tasks 00:15:00
Manage Tasks 00:06:00
Manage Notes 00:03:00
Customize the Outlook Interface 00:04:00
Create and Manage Quick Steps 00:06:00
Order your Certificate
Order your Certificate 00:00:00

Course Reviews

4.4

4.4
5 ratings
  • 5 stars0
  • 4 stars0
  • 3 stars0
  • 2 stars0
  • 1 stars0

No Reviews found for this course.

© Alpha Academy is a part of Adams Academy Inc. Ltd.