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)

Udemy

platform

English

language

Microsoft

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

Course Gallery

The Ultimate Microsoft Office 2016 Training Bundle – Screenshot 1 — Screenshot 1 – The Ultimate Microsoft Office 2016 Training Bundle

The Ultimate Microsoft Office 2016 Training Bundle – Screenshot 2 — Screenshot 2 – The Ultimate Microsoft Office 2016 Training Bundle

The Ultimate Microsoft Office 2016 Training Bundle – Screenshot 3 — Screenshot 3 – The Ultimate Microsoft Office 2016 Training Bundle

The Ultimate Microsoft Office 2016 Training Bundle – Screenshot 4 — Screenshot 4 – The Ultimate Microsoft Office 2016 Training Bundle

Charts

Students

Price

Rating & Reviews

Enrollment Distribution

Comidoc Review

Our Verdict

This robust 8-course bundle is a great starting point for individuals wanting to master the essentials of Microsoft Office. Expect depth, up-to-date content, and real-world applications, but also prepare for inconsistencies in teaching quality throughout and a need to adapt study habits to fill potential gaps.

What We Liked

An all-in-one resource for mastering MS Office 2016, including Access & VBA, with 60+ hours of video spread across 8 courses
Comprehensive content targets learners of all levels (beginners to advanced), covering foundational features and diving into complex topics like data analysis and macros
Follow-along practice files provided for students to reinforce lessons; expert instructors explain concepts while engaging with the tools
Updated in 2023, incorporating OneNote & Macros and VBA for Beginners, ensuring its relevance in line with MS Office's continuous evolution

Potential Drawbacks

Certain instructors' teaching styles or pacing vary, leading to some lessons being difficult to follow; subtitles in English may contain errors
Workbook organization could be improved, as the current 60+ hour course is spread across multiple workbooks with many worksheets that lack distinct separation or consistent naming conventions
The advanced Excel VBA content was criticized for not being thorough and may leave some learners feeling underwhelmed; adjusting playback speed can help
A few learners find early segments too basic, especially those with prior MS Office experience