The Ultimate Microsoft Office 2016 Training Bundle
The Most Convenient Way to Boost Your Confidence And Learn MS Office 2016 Inside And Out—Quickly, No Travel or Classes.
4.41 (4262 reviews)
19,967
students
74 hours
content
Mar 2023
last update
$139.99
regular price
What you will learn
Discover new and improved features in Excel 2016.
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
Discover new features in PowerPoint 2016
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
Setting up email accounts
Using Outlook on a touch device
Creating and sending email messages
Organizing email
Calendar appointments and attachments
Create and manage meetings
Adding email signatures
How to archive email
Spam and junk mail removal
Creating and managing tasks and reminders
Using the mail merge feature to import contact information to Microsoft Word
Adding, managing and searching contacts in the address book
Creating filters to automate incoming messages
Practice what you learned with included exercise files
Screenshots
Related Topics
973394
udemy ID
10/2/2016
course created date
5/5/2019
course indexed date
Bot
course submited by