[UDEMY] Microsoft Office 2016 Essential Training: 9 Course Bundle

[grr]

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


66.5 hours on-demand video
24 Articles
15 Supplemental Resources

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

Contents and Overview

In this 9-in-1 course collection, we'll show you important yet often over-looked or unknown features that will help skyrocket your productivity.

Microsoft Excel 2016 - Beginners: Spreadsheets for data analysis and formulas for tracking expenses.
Microsoft Excel 2016 - Advanced: apply functions, filter data, and create advanced spreadsheet visuals.
Microsoft Word 2016: Introductory courses on creating documents and brochures, embedding videos, and set up for online collaboration.
Microsoft OneNote 2013: Introductory courses on efficiencies to help clear note clutter and gain control of your virtual junk drawer.
Microsoft PowerPoint 2016: Introductory courses on how to create dazzling presentations using animation, audio/video, and collaborative tools with minimal time and effort.
Microsoft Access 2016 – Beginners: creating and using databases to become a master of data management, tracking customer information and buying patterns.
Microsoft Access 2016 – Advanced: improve your database reporting and information security.
Microsoft Essential VBA for Excel: learn how to automate repetitive and time-consuming Excel procedures and operations for maximum efficiency.
VBA Intermediate Training: Discover Excel Automation Secrets: learn advanced methods for automating tedious Excel jobs, the next step for anyone who has completed basic VBA.

https://www.udemy.com/microsoft-office-2...se-bundle/

[ashwin]

Thanks.

All these should work for Office Online too, which is free to use from web browsers.

[hakah]

Nice material!