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.
- 1 year
- Intermediate
- Course Certificate
- Number of Units122
- Number of Quizzes0
- 1 day, 10 hours Gift 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 Ratings
No Ratings found for this course.