Check out our Christmas deals

Microsoft Office for Admin - CPD Accredited

Microsoft Office for Admin Course Accredited by CPD | Full Tutor Support | Instant Result | No hidden fees

One Education


Save 96%
£17 inc VAT (was £425)
Offer ends 14 December 2019
Study method
Online, self-paced
76 Hours
Access to content
12 Months
40 CPD points / hours
Additional info
  • Exam(s) / assessment(s) is included in price
  • Tutor is available to students

5 students purchased this course

Add to basket or enquire


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 media


We’ve taken this comprehensive Microsoft Office for Admin course and broken it down into 149 manageable units which we believe will assist you to easily grasp each concept – from the fundamental to the most advanced aspects of the Office Admin Skills. It really is a sure pathway to success.

This Microsoft Office for Admin is designed with the following modules:

Microsoft Word 2016

  • Modify User Information
  • Share a Document
  • Work with Comments
  • Compare Document Changes
  • Review a Document
  • Merge Document Changes
  • Coauthor Documents
  • Add Captions
  • Add Cross-References
  • Add Bookmarks
  • Add Hyperlinks
  • Insert Footnotes and Endnotes
  • Add Citations
  • Insert a Bibliography
  • Insert Blank and Cover Pages
  • Insert an Index
  • Insert a Table of Contents
  • Insert an Ancillary Table
  • Manage Outlines
  • Create a Master Document
  • Suppress Information
  • Set Editing Restrictions
  • Add a Digital Signature to a Document
  • Restrict Document Access
  • Create Forms
  • Manipulate Forms
  • Form Data Conversion
  • Create a New Document Version
  • Compare Document Versions
  • Merge Document Versions

Microsoft Excel 2016

  • Update Workbook Properties
  • Activity-Update Workbook Properties
  • Create and Edit a Macro
  • Activity-Create and Edit a Macro
  • Apply Conditional Formatting
  • Activity-Apply Conditional Formatting
  • Add Data Validation Criteria
  • Activity-Add Data Validation Criteriaty
  • Trace Cells
  • Activity-Trace Cells
  • Troubleshoot Invalid Data and Formula Errors
  • Activity-Troubleshoot Invalid Data and Formula Errors
  • Watch and Evaluate Formulas
  • Activity-Watch and Evaluate Formulas
  • Create a Data List Outline
  • Activity-Create a Data List Outline
  • Create Sparklines
  • Activity_Create Sparklines
  • Create Scenarios
  • Activity-Create Scenarios
  • Perform a What-If Analysis
  • Activity-Perform a What-If Analysis
  • Perform a Statistical Analysis with the Analysis ToolPak
  • Activity-Perform a Statistical Analysis with the Analysis ToolPak
  • Create Interactive Data with Power View
  • Activity-Create Interactive Data with Power View
  • Consolidate Data
  • Activity-Consolidate Data
  • Link Cells in Different Workbooks
  • Activity-Link Cells in Different Workbooks
  • Merge Workbooks
  • Activity-Merge Workbooks
  • Export Excel Data
  • Activity-Export Excel Data
  • Import a Delimited Text File
  • Activity- Import a Delimited Text File
  • Integrate Excel Data with the Web
  • Activity-Integrate Excel Data with the Web
  • Create a Web Query
  • Activity-Create a Web Query
  • Import and Export XML Data
  • Activity-Import and Export XML Data

Microsoft PowerPoint 2016

  • Customize the User Interface
  • Set PowerPoint 2016 Options
  • Create and Manage Sections
  • Modify Slide Masters and Slide Layouts
  • Add Headers and Footers
  • Modify the Notes Master and the Handout Master
  • Create SmartArt
  • Modify SmartArt
  • Add Audio to a Presentation
  • Add Video to a Presentation
  • Customize Animations and Transitions
  • Add Comments to a Presentation
  • Review a Presentation
  • Store and Share Presentations on the Web
  • Annotate a Presentation
  • Set Up a Slide Show
  • Create a Custom Slide Show
  • Add Hyperlinks and Action Buttons
  • Record a Presentation
  • Secure a Presentation
  • Present a Slide Show Online
  • Create a Video or a CD

Microsoft Outlook 2016

  • Insert Advanced Characters and Objects
  • Modify Message Settings, Properties, and Options
  • Use Automatic Replies
  • Sort Messages
  • Filter Messages
  • Organize Messages
  • Search Messages
  • Manage Junk Mail
  • Manage Your Mailbox
  • Manage Advanced Calendar Options
  • Manage Additional Calendars
  • Manage Meeting Responses
  • Assign and Manage Tasks
  • Edit an Electronic Business Card
  • Manage Advanced Contact Options
  • Forward Contacts
  • Export Contacts
  • Delegate Access to Mail Folders
  • Share Your Calendar
  • Share Your Contacts
  • Back Up Outlook Items
  • Change Data File Settings
  • Configure E-mail Message Security Settings

Microsoft Access 2016

  • Add Controls to Forms
  • Set Form Controls
  • Create Subforms
  • Organize Information with Tab Pages
  • Enhance Navigation with Forms
  • Format a Form
  • Apply Conditional Formatting
  • Field Validation
  • Form and Record Validation
  • Create a Macro
  • Restrict Records Using a Condition
  • Validate Data Using a Macro
  • Automate Data Entry Using a Macro
  • Convert a Macro to VBA
  • Link Tables to External Data Sources
  • Manage a Database
  • Determine Object Dependency
  • Document a Database
  • Analyze the Performance of a Database
  • Split a Database for Multiple User Access
  • Implement Security
  • Set Passwords
  • Convert an Access Database to an ACCDE File
  • Package a Database with a Digital Signature
  • Create a Database Switchboard
  • Modify a Database Switchboard
  • Set Startup Options

How is the Microsoft Office for Admin course assessed?

To successfully complete the Microsoft Office for Admin 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 course completion, you will qualify for a CPD certificate from One Education as proof of your new skills. Certification is available in PDF format, at the cost of £9, or a hard copy can be sent to you via post, at the cost of £15.

Who is this course for?

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


This Microsoft Office for Admin is compatible with all kinds of devices and the age requirement for this Microsoft Office for Admin is 16. So, basically, everyone can take this course to acquire Microsoft Office for Admin skills that are necessary.

Questions and answers

Currently there are no Q&As for this course. Be the first to ask a question.

Provider reviews

Provider rating
Leave a review

{{ getTruncatedSinglePointScore(item.OverallCourseRating) }} Star Review by {{ item.ReviewerName }} for {{ item.Title }}

{{ getLongDate(item.CreatedOn) }}
{{ item.Title }}
Reviewed by {{ item.ReviewerName }}
|Purchased {{ getHumanisedPassageOftime(item.PurchasedOn) }}
{{ item.ProviderName }} responded to this review
{{ getLongDate(item.ProviderResponseDate) }}
{{ results.length }} out of {{ totalResultsCount }} reviews


Mobile Navigation