Microsoft Office 2016 Advanced Training

Gain a comprehensive, expert understanding of industry-standard office administration software with this engaging online course. Through video tutorials and practical exercises you will develop your skills in Microsoft Office programs including Word, Excel and Powerpoint, with the versatility to turn your expertise to almost any office or business administration role, personal projects, or other PA, receptionist and secretarial careers.

Description

Microsoft Office is one of the most popular bundles of PC software in the world, with over 1 billion copies sold since its initial release. The programs have become the standard for businesses across all industries, of all sizes. This distance learning course will teach you how to advanced your skills and comprehension of the Microsoft Office programs. You will learn how to perform advanced functions in Microsoft Excel spreadsheets, master your Outlook inbox, produce dynamic presentations in PowerPoint, and manage complex databases using Access.

Benefits of studying course with Victoria Education include:

• Easy-to-understand course materials designed by industry experts, accessible through your smartphone, laptop, desktop or tablet device
• No hidden fees or costs - study a comprehensive course and earn a professional e-certificate upon successful completion
• Get instant feedback from automated assessments and mock exams to gauge your progress
• No formal deadlines or teaching schedule, meaning you can learn at your own pace
• 24/7 help and support from your online tutors, through email and via our live online chat
• Qualify for an NUS Extra card and gain access to over 200 fantastic deals from high street brands and one free year of ISIC unlocking over 42,000 international discounts

Who is this course for?

The course is aimed at anyone wishing to start working in such roles, or existing professionals wishing to boost their skills and employability.

Our courses are open to learners of all levels with no formal experience or qualifications required to enrol. However, learners should be aged 16 or over and have a good understanding of English language, numeracy and IT.

CPD

How is this qualification delivered?

Our courses are taught entirely online, meaning you can access the materials wherever, whenever, at a pace that suits you, without formal deadlines or teaching schedules.

The courses are delivered through

• Video lessons
• PDF handouts
• Mock exams
• Online assessment
• These can be accessed through any device with an internet connection. Our e-learning platform is optimised for use on mobile, tablet, laptops and desktop computers.

Course Curriculum

Section 1

• 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
• Activities - Microsoft Office 2016 Advanced Training

Section 2

• Customising the properties of your workbook
• Exercise: Customising the properties of your workbook
• Inserting and updating a macro
• Exercise: Inserting and updating a macro
• Understanding conditional formatting
• Exercise: Understanding conditional formatting
• Applying data validation to your worksheet
• Exercise: Applying data validation to your worksheet
• Using the trace cells function
• Exercise: Using the trace cells function
• Understanding common formula errors and invalid data
• Exercise: Understanding common formula errors and invalid data
• Using watch windows and evaluating data
• Exercise: Using watch windows and evaluating data
• Isolate data lists and create outlines
• Exercise: Isolate data lists and create outlines
• Using sparkline tools
• Exercise: Using sparkline tools
• Forecasting with the scenario manager tool
• Exercise: Forecasting with the scenario manager tool
• How to undertake a what-if analysis
• Exercise: How to undertake a what-if analysis
• Using the Data Analysis ToolPak
• Exercise: Using the Data Analysis ToolPak
• How to create a Power View
• Exercise: How to create a Power View
• Using Excel's consolidation functions
• Exercise: Using Excel's consolidation functions
• How to link cells across workbooks
• Exercise: How to link cells across workbooks
• Merging your workbooks
• Exercise: Merging your workbooks
• Exporting your data
• Exercise: Exporting your data
• Importing data into Excel
• Exercise: Importing data into Excel
• Integrate Excel Data with the Web
• Exercise: Publishing an Excel sheet online
• Making web queries
• Exercise: Making web queries
• How to import and export XML data
• Exercise: How to import and export XML data
• Exercises: Microsoft Excel Advanced

Section 3

• 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
• Activities - Microsoft Office 2016 Advanced Training

Section 4

• 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
• Activities - Microsoft Office 2016 Advanced Training

Section 5

• 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
• Activities - Microsoft Office 2016 Advanced Training

Mandatory units

The course consists of five mandatory modules

• Microsoft Word
• Microsoft Excel
• Microsoft PowerPoint
• Microsoft Outlook
• Microsoft Access

Assessment

The assessment at the end of each course is a multiple-choice exam taken through our online platform. The system is fully automated so you will receive your results instantly upon completion.

Certification

Upon successful completion you will qualify for the UK and internationally-recognised professional qualification. You can order a print copy sent by post for GBP12.

Victoria Education is a leading provider of online training, practical courses and professional accreditation.

Our mission is to make learning accessible, affordable, and available to all, regardless of experience or qualifications.