Microsoft Office 2016 Essential Training: 9 Course Bundle

Comprehensive, all-in-one training to get the most out of Microsoft Office 2016. 9-in-1 courses with 70 hours of video.

Created by: Simon Sez IT
990,000+ Students, 290+ Courses, Learners in 180+ Countries

What Will I Learn?

• Discover new and improved features in Excel 2016, Word, PowerPoint, OneNote & Access.
• How to effectively use Excel 2016 on a touchscreen device.
• How create, save, and open a workbook.
• Learn how to personalize your use of Excel using Excel Options.
• How to use and how to customize the Quick Access Toolbar.
• Complete data entry, cell formatting, working with multiple worksheets and the “Ribbon” interface.
• The basics of entering and editing data in a workbook.
• Learn practical methods in which you can backup and recover your Excel spreadsheets.
• Effectively use autofill and flashfill so you are more productive.
• Discover the essentials of using fomulas and functions.
• How to rename, insert, move, and reference an Excel 2016 worksheet.
• Discover how to create charts and graphs
• Learn practical methods to sort and filter your data
• How to protect and secure your Excel data
• Learn presentation tips for an effective presentation
• Discover how to format text on a PowerPoint slide
• Learn how to insert shapes, graphics and pictures to add some "zing" to your presentation
• Add charts, graphs and tables to present information in a non-text format
• Wow your audience by adding animations, audio and video
• Discover practical tips to present your presentation to your audience
• Learn time saving techniques including how to copy slides, and exporting your presentation
• Customize PowerPoint for greater productivity by customizing the Microsoft Office Ribbon
• Master the most common uses of Word
• How to controlling page appearance including using columns, indents, footers, borders and watermarks
• Learn to create many types of documents
• How to create a mail merge
• Printing envelopes and labels
• Discover different page setup options
• How to protect your document from changes
• Learn how to spell check your documents
• Insert pictures and graphics in your Word document
• Discover how to insert and edit tables
• Using "Go To, Find, and Replace"
• How to create, save and open documents
• Learn cool tips and tricks in the Ribbon
• Discover common Excel hotkeys
• How to use VLOOKUP and HLOOKUP
• Learn how to use popular functions
• Discover how to use named ranges
• Discover the power of Dynamic Formulas and how to use them
• Get advanced level tips for creating awesome charts and graphs
• How to work with and analyze your data using data slicers, PivotTables, Power Query and PivotCharts
• Sorting information and running queries
• Creating tables and relationships
• Learn valuable new skills for complex data projects at work
• Discover how to into import data from Excel
• Learn Queries, use validations, how to create and print reports
• Dive into options for packaging your application for distribution
• Share notebooks and collaborate with others
• Integrate OneNote with Microsoft Outlook
• How to use the OneNote interface
• Tag your notes and how to search them
• Use handwriting in OneNote
• How to protect your notes

Requirements

• Microsoft Office 2016 desktop version for Windows installed and ready to use on your computer.

Target audience

• Those new to using Microsoft Access, Excel, OneNote PowerPoint, and Word 2016
• This course is created for absolute beginners.
• If you want to refresh your memory and understanding of Access, Excel, OneNote, Word and PowerPoint