• No products in the basket.

  • LOGIN

Login

  • 28 Students

  • Certified

Overview

Take your Microsoft office skills to the next level and master the Microsoft Office 2016 Suite with the Microsoft Office for Admin course. This intense masterclass will take you from a beginner to expert in no time, equipping you with fundamental skills for any official role.

This Microsoft course training program is the ultimate career booster to fast track your professional development in secretarial, administrative and PA work. You will learn the basics of business administration, document control and data management, covering key topics such as automating tasks in Word, collaborating on worksheets in Excel and creating killer slideshows in PowerPoint.

On successful completion, you will have the practical skills and knowledge to manage everyday office tasks with confidence and speed.

Highlights  of The Microsoft Office for Admin:

  • Learn how to ulitise leading Microsoft Office programs for everyday office tasks
  • Fast track your career as an administrative assistant, secretary or PA
  • Boost your competence in Word, Excel, PowerPoint, Outlook & Access
  • Master the beginner, intermediate, and advanced features of Microsoft Office 2016 Suite
  • Be able to create killer presentations, collaborate on worksheets and compose professional emails
  • Learn how to automate tasks to save valuable time & increase productivity at work
  • Discover tips, tricks & shortcuts to help you work faster and more efficiently
  • Earn an internationally recognised certificate of achievement & boost your professional development in any office environment.

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

  • Online study materials
  • Mock exams
  • Multiple-choice assessment

How is the course assessed?

To successfully complete the course you must pass an automated, multiple-choice assessment. The assessment is delivered through our online learning platform. You will receive the results of your assessment immediately upon completion.

Will I receive a certificate of completion?

Upon successful completion you will qualify for the UK and internationally-recognised certificate and you can choose to make your achievement formal by obtaining your PDF Certificate at a cost of £9 and Hardcopy Certificate for £15.

Why study this course

Whether you’re an existing practitioner or aspiring professional, this course will enhance your expertise and boost your CV with key skills and an accredited qualification attesting to your knowledge.

The Microsoft Office for Admin is open to all, with no formal entry requirements. All you need is a passion for learning, a good understanding of the English language, numeracy and IT, and to be over the age of 16.

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:15: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 – 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

Training 10 or more people?

Get your team access to 3,000+ top courses anytime, anywhere.

Try One Education Business
  • PRIVATE
  • 1 year
  • Number of Units149
  • Number of Quizzes0
  • 3 days, 4 hours

Certifications

Get accredited certificates

New skills

Add skills to your CV

Exams

Test your skills

Dedicated Support

For any questions

Set your own speed

Self-paced learning

Save your money

Monthly subscription

COPYRIGHT © 2022 One Education

0
Your Cart