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.
4.56 (906 reviews)
7,138
students
68 hours
content
Sep 2022
last update
$89.99
regular price
What you will 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
Related Topics
1352400
udemy ID
9/16/2017
course created date
11/7/2019
course indexed date
Bot
course submited by