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.40 (4219 reviews)
Udemy
platform
English
language
Microsoft
category
instructor
The Ultimate Microsoft Office 2016 Training Bundle
19,850
students
74 hours
content
Mar 2023
last update
$129.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

Why take this course?

** We've crammed 9 courses into this amazing Microsoft Office bundle. Unlock the secrets of Office 2016 or 365 with this 60+ hour mega-course. Practice exercises included**


Master the Ins and Outs of Microsoft Office and Boost Your Productivity   


This 10 COURSE BUNDLE includes:

  • Microsoft Excel 2016 (beginners) - learn the basics of spreadsheets

  • Microsoft Excel 2016 (intermediate) - take those spreadsheet skills to the next level

  • Microsoft Excel 2016 (advanced) - master spreadsheets 

  • Microsoft Word 2016 - master documents

  • Microsoft PowerPoint 2016 - master presentations 

  • Microsoft Access 2016 - master databases 

  • Visual Basic for Applications (VBA)  for Microsoft Excel - master spreadsheet automation

  • Microsoft Outlook 2016 - Master e-mail and calendar management

  • Macros and VBA for Beginners (added March 2021)

  • OneNote Desktop and Windows 10 (added March 2021)


Over 500, 5 Star Reviews:


"Undoubtedly, this course covers a wide range of topics done in an extremely professional manner. This is worthy of every second and penny I invested in it. It helped me understand various contours of Microsoft Office." - Muhammad Bashir

"Very clear and thorough. Super for beginners." - Anna Wyk

"This is what I needed and what I was looking for. Excellent course."  - Roberto Regalado

"My experience with this course was absolutely beneficial to me. The lecturers are so good at explaining the course and not forgetting the exercises they set up for you is amazing it really helps and it gives you experience as you go along with them." - Jennade Ramruthen


Improve Efficiency with Microsoft’s Premier Office Management Software   

Designed to help you accomplish office tasks easily and with greater efficiency, Microsoft Office is the choice of many office professionals. If you're working in an office, you'll likely need to use the Microsoft Office suite and it's likely you're working for it, rather than having it work for you. Turn that around today and finally learn all the deep, dark secrets of Microsoft Office from these 8 courses in one bundle.

Master Microsoft Excel, start at the beginning if you're brand new to spreadsheets or pick up at Intermediate or Advanced level. For those looking to go beyond normal data analysis, you'll learn how to handle databases using Microsoft Access or automate mundane tasks in Excel using VBA.

If that wasn't enough this bundle will teach you how to utilize PowerPoint to create stunning presentations, use Microsoft Word to create documents that inspire and make administration a breeze through learning about mail merge.


** Recently added - unlock the power of Microsoft Outlook 2016 and dramatically improve your productivity and sanity through a clear inbox.**


Bundle Overview   


This course is designed for individuals and office professionals who need to master the capabilities of the 2016 or 365 editions of Microsoft Office. With more than 60 hours of video lectures across 8 courses, this course will help you master MS Office 2016, reduce your MS Office frustration and help you claw back the precious time you spend getting lost in these powerful business applications.


  • Excel 2016 Beginning/Intermediate: Create basic spreadsheets and use formulas for tracking expenses. 

  • Excel 2016 Intermediate: Use complex formulas and perform data analysis on your organization’s revenue and expense patterns. 

  • Excel 2016 Advanced: Take your Excel skills to the ultimate level with advanced charts, graphs, formulas, and data analysis.

  • Word 2016: Create documents, embed videos, and set up online collaboration on joint projects for school or work. 

  • PowerPoint      2016: Make impactful presentations for your next business meeting using animation, audio/video, and collaborative tools. 

  • Access 2016 for Beginners: Become a master of data management, customer tracking, and buying patterns. 

  • Microsoft Essential VBA for Excel: Learn how to automate repetitive and time-consuming Excel procedures and operations for maximum efficiency. 

  • Master Microsoft Outlook 2016 the Easy Way: Introductory course on email efficiencies to help clear the email clutter and gain control of your inbox.

  • Macros and VBA for Beginners (added March 2021): Learn to create your first Macro and perform basic VBA in Excel

  • OneNote Desktop and Windows 10 (added March 2021): Learn all about using OneNote to store your notes and organize your life!

When you complete this course, you’ll be well on your way to becoming a master of workplace efficiency with the tools available in Microsoft Office 2016.

   

Why Take This Course   

  • Optimize your productivity at work or in your own business.

  • Get noticed by your boss and earn the respect of your colleagues. Become the office superstar by being the go-to expert on everything related to MS Office 2016.   

  • Amazing value 9-courses in one bundle. You get professional quality training at a fraction of the normal price.


Why Simon Sez IT for Microsoft Office?

  • We know Microsoft Office. We've been teaching it for over 10 years and your expert instructors have taught thousands of people to learn Microsoft products.

  • We don't rush through content. We take the time to ensure you understand important principles before moving on.

  • Follow along. We provide downloadable practice files so you can practice as you learn.


** Updated May 2018: Outlook 2016 course added**

** Updated March 2021: OneNote and Macros and VBA for Beginners added**

Content

Excel 2016: Introduction to Excel 2016 Beginner Course

Acquiring Excel 2016 and Information on Installation and Upgrade
Essential Information for a Successful Training Experience
Excel 2016 Course Exercise Files
Excel 2016 Course Demo Files
Exercise Files
Downloadable Course Transcripts

Excel 2016: What's New

New and Improved Features in Excel 2016

Excel 2016: Using Touch

Overview of Principles of Using Touchscreen

Excel 2016: Getting Started

Creating and Saving a Workbook
Opening a Workbook

Excel 2016: Using Help

Online Help and Contextual Help

Excel 2016: Excel Options

Personalizing your use of Excel

Excel 2016: The Ribbon and Toolbars

Basics of using the Ribbon
Quick Access Toolbar
Tell Me Feature
Mini Toolbars and Contextual Menus
Status Bar

Excel 2016: Entering and Editing Data

Basics of Entering and Editing Data in a Workbook
Exercise 01
Formatting Dates
Formatting Numbers
Exercise 02

Excel 2016: Backup and Recovery

AutoSave, Recover Unsaved Workbook, and Create a Backup Copy

Excel 2016: Fill and Series

Working with Fill and Series
Flash Fill

Excel 2016: Viewing and Printing

Workbook Views, Zoom, and Freeze
Printing
Exercise 03

Excel 2016: Cut, Copy, and Paste

Methods of Cutting, Copying, and Pasting

Excel 2016: Formatting a Worksheet

Delete and Clear
Insert, Hide, Column Width and Row Height, and Merge
Alignment
Themes and Styles
Exercise 04

Excel 2016: Formulas and Functions

Course review
Basics of Fomulas and Functions
Complex Examples of Formulas
Exercise 05

Excel 2016: Managing Worksheets

Managing Worksheets

Excel 2016: Working with Multiple Workbooks

Working with Multiple Workbooks

Excel 2016: Saving Workbooks

Saving in Different File Types

Excel 2016: Proofing

The Spell Checker

Excel 2016: Inserting Comments

Inserting Comments
Exercise 06

Excel 2016: Basic Functions in Excel

The VLOOKUP Function
Text Functions
Date and Time Functions
Logical Functions

Excel 2016: Graphs and Charts

Creating Graphs and Charts
Customizing a Cluster Column Chart
Customizing a Pie Chart
New Chart Types in Excel 2016
Exercise 07

Excel 2016: Sorting and Filtering Data

Managing Data by Sorting
Managing Date by Filtering
Customizing Tables

Excel 2016: Shapes and Pictures

Inserting Shapes and Pictures
Exercise 08

Excel 2016: Formatting Cells Based on Content

Conditional Formatting

Excel 2016: Protection and Security

Protecting Worksheets
Protecting Workbooks

Excel 2016: Naming Items

Giving Items Names
Exercise 09

Excel 2016: Finding and Replacing Words

Find and Replace

Excel 2016: Borders

Adding Borders

Excel 2016: Workbook Inspection

Inspecting a Workbook

Excel 2016: Privacy Options

Trust Center Privacy Options

Excel 2016: Sharing Options

Sharing a Workbook

Excel 2016: Wrap Up

Closing

PowerPoint 2016: Course Introduction

Welcome and Overview
Essential Information for a Successful Training Experience
Course exercise files
Downloadable Course Transcripts
New Features in PowerPoint 2016
New features in PowerPoint 2016 for MAC

PowerPoint 2016: Overview

Navigate a PowerPoint Presentation
Overview of the Desktop Screen and Views
Exercise 01

PowerPoint 2016: Getting Started

Presentation Tips and Guidelines
Creating a New Presentation
Working with Slides
Saving a Presentation
Exercise 02

PowerPoint 2016: Text and Bullet Editing Options

Formatting Text
Working with Bullets
Exercise 03

PowerPoint 2016: Adding Graphics to Your Presentation

Inserting Shapes
Inserting Graphics
Inserting Pictures
Exercise 04

PowerPoint 2016: Working with Objects

Selecting Objects
Editing Objects
Formatting Objects - Part 1
Formatting Objects - Part 2
Arranging Objects
Grouping Objects
Exercise 05

PowerPoint 2016: Working with Pictures

Picture Options
Cropping Pictures
Formatting Pictures
Things You Can Do with Pictures
Exercise 06

PowerPoint 2016: Working with SmartArt

Creating SmartArt
Modifying SmartArt
Creating a Flowchart Using SmartArt
Exercise 07

PowerPoint 2016: Working with Tables

Creating Tables
Formatting Tables
Inserting Tables
Exercise 08

PowerPoint 2016: Working with Charts

Adding Charts
Formatting Charts
Inserting Charts from MS Excel
Exercise 09

PowerPoint 2016: Masters

Using Masters
Changing Master Slides
Creating a New Master Design Template
Exercise 10

PowerPoint 2016: Working with Media

Adding Video to a Presentation
Adding Video to a Presentation
Exercise 11

PowerPoint 2016: Transitions

Applying Transitions
Transition Options
Exercise 12

PowerPoint 2016: Animation

Animating an Object
Effect Options
Working with the Animation Pane
Motion Paths
Triggers
Exercise 13

PowerPoint 2016: Hyperlinks and Action Buttons

Working with Action Buttons
Working with Hyperlinks
Exercise 14

PowerPoint 2016: Slideshow Options

Onscreen Presentation Options
Hiding Slides
Changing the order of slides
Copying slides
Slideshow Options
Exercise 15

PowerPoint 2016: Preparing a Presentation for Delivery

Rehearse Timings
Recording a Presentation
Slide Show Settings
Creating a Custom Slide Show
Exercise 16

PowerPoint 2016: Other PowerPoint Features

Exporting options
Working with the Backstage View & Customization Options
Customizing the Ribbon
Printing a presentation
Exercise 17

PowerPoint 2016: Conclusion

Conclusion

Word 2016: Introduction

Welcome and Overview
Essential Information for a Successful Training Experience
Course exercise files
Downloadable Course Transcripts
What's New in Word 2016
Overview of MS Word Screen
Backstage View

Word 2016: Getting Started with Word

Creating a New Blank Document
Working with Non-Printing Characters and Line Spacing Basics
Saving a Document
Opening a Document
Navigating in a Document
Go To, Find, and Replace
Editing a Document
Section 2 Practice Exercise

Word 2016: Character Formatting

AutoCorrect Options
Selecting text
Cut, Copy & Paste
Character Formatting Options
Format Painter
Working with numbers
Working with bullets
Creating an Outline
Section 3 Practice Exercise

Word 2016: Paragraph Formatting

Alignment Options
Line Spacing Options
Working with Indents
Working with Tabs
Section 4 Practice Exercise

Word 2016: Managing Lists

Sorting a List

Word 2016: Tables

Working with Tables
Creating a Table
Adding Rows and Columns to a Table
Formatting Table Data
Borders & Shading
Sorting in a Table
Drawing a Table
Converting Existing Data to a Table
Quick Tables
Using Formula in Tables
Section 6 Practice Exercise

Word 2016: Styles

Working with Styles
Creating Styles
Editing Styles
Section 7 Practice Exercise

Word 2016: Controlling Page Appearance

Working with Page Breaks
Working with Columns
Adding a Watermark
Applying Page Borders
Headers & Footers
Section 8 Practice Exercise

Word 2016: Sectioning

What is Sectioning?
Sectioning a Document
Odd and Even Sections
Section 9 Practice Exercise

Word 2016: Graphics

Inserting Pictures
Inserting Pictures into Existing Documents
Picture Options
Working with Shapes
Other Graphic Options
Section 10 Practice Exercise

Word 2016: Envelopes & Labels

Working with Envelopes
Working with Labels

Word 2016: Mail Merges

What is Mail Merge?
Creating a Mail Merge Document - Part 1
Creating a Mail Merge Document - Part 2
Merging a Document with an Existing Data Source
Sorting and Filtering Images
Merging Envelopes and Labels
Merging a Directory
Section 12 Practice Exercise

Word 2016: Quick Parts

Building Blocks
Creating and Editing Building Blocks
Auto Text
Section 13 Practice Exercise

Word 2016: Indexing and Table of Contents

Creating an Index
Creating a Table of Contents
Section 14 Practice Exercise

Word 2016: Review and Printing

Using the Thesaurus
Spell Check
Comments
Margins
Page Setup Options
Printing
Section 15 Practice Exercise

Word 2016: Other Word Features

Word Options
Protecting a Document
Macros

Word 2016: Wrap Up

Closing

Excel 2016 Intermediate: Introduction

Course Introduction
Essential Information for a Successful Training Experience
Course Exercise Files
Course Support Files
Reviewing Excel Terminology
Tips and Tricks in the Ribbon
Escaping the "Mouse"-Trap
Common Hotkeys
Special Hotkey Commands
Defining Your Excel View

Excel 2016 Intermediate: Indexing and Lookups

Defining Lookups and Arrays
Using VLOOKUP and HLOOKUP
Using MATCH
Using INDEX
Mixing LOOKUPS, INDEX, and MATCH

Excel 2016 Intermediate: Named Ranges

What is Important to You?
Simple and Quick Name Definitions
Accessing and Using the Name Manager
What can Names do?

Excel 2016 Intermediate: Dynamic Formula

What is a Reference?
Using Indirect
Using Offset
Using Row, Column, and Cell
Creating Dynamic Named Ranges
Best Practices Regarding Dynamic Functions

Excel 2016 Intermediate: Charts and Graphs

Charts and Graphs Terminology
Line, Scatter, and Bar Charts
Radar and Surface Plots
Waterfall, Pie, and Sunburst Charts
The Box and Whisper Plot and Histograms (Statistical)
Chart Formatting In Detail
Mixing Chart Types
The Bing Maps App

Excel 2016 Intermediate: Working with Data

How Do You Know If You're Working With Data?
Introducing Data Tables
Excel Data Model Relationships
Data Slicers
Pivot Tables
Power Query / Get And Transform
Pivot Charts
The GETPIVOTDATA Function
Course Conclusion

Essential VBA Training for Excel: Introduction

Introduction to the VBA Course
Essential Information for a Successful Training Experience
Course exercise files

Essential VBA Training for Excel: The Environment

Getting Started
The VBA Editor
First Coding Manipulations

Essential VBA Training for Excel: VBA as a Language

VBA Syntax, Keywords, and Comments
Objects and VBA's Intellitext
Variables and Method Calling Rules
How to Define and Manage Variables
Constant Variable Types and Variables through Intellitext

Essential VBA Training for Excel: Introducing Macros

Subroutines
Logical Constructs: The Boolean Type
Logical Constructs: If and Switch Statements
Methods for Communicating to the User
Looping: The For and Do While Loops
Looping: Collections and the For Each Loop

Essential VBA Training for Excel: Introducing Functions

Functions
Returning Values from Functions
Sending Values to Functions
Determining Limitations
The Worksheet Function Object
Completing Exercise 5
The Range Object
Writing an Array Formula

Essential VBA Training for Excel: Common Keys to VBA

The Application Object
The Workbook and Worksheet Objects
Using Errors to Guide You
The Name and Names Objects
The PivotTable Object
The Chart and ChartObject Objects
The PageSetup Object and Print Ranges
One Approach To Completing Exercise 8

Essential VBA Training for Excel: Conclusion

Concluding Remarks

Access 2016: Introduction

Introduction to Access 2016 Course
Essential Information for a Successful Training Experience
Course Exercise Files
Course Demo Files
Acquiring Access 2016
Structure of the Course
What's New in Access 2016

Access 2016: Using Touch

Using Access in a Touch Device

Access 2016: Getting Started

Using Database Templates
The Access Workspace and Backstage
Creating, Saving, and Opening Databases

Access 2016: Help

Online Help and Tell Me

Access 2016: The Ribbon and Toolbars

The Ribbon
The Quick Access Toolbar
Contextual Menus
The Status Bar

Access 2016: Keyboard Shortcuts and Key Tips

Keyboard Shortcuts
Key Tips

Access 2016: Access Options

General, Current Databases, and Language Options

Access 2016: Tables

Creating a Table and Fields
Indexed Field
Lookup Wizard
Numeric Fields
Exercise 01

Access 2016: Importing Data

Importing Data from Excel
Exercise 02

Access 2016: Backup, Restore, and Repair

Backing up your Database
Compact and Repair

Access 2016: Datasheet View

Design in the Datasheet View
Sorting and Filtering in Datasheet View
Entering and Modifying Data in Datasheet View

Access 2016: Relationships

Creating a Link Table
Setting up Relationships
Exercise 03

Access 2016: Forms

Creating a Form
Modifying a Form
Exercise 04
Forms in Layout View
Forms in Design View
Form Design
Exercise 05

Access 2016: Subforms

Setting up Subforms - Part 1
Setting up Subforms - Part 2
Setting up Subforms - Part 3

Access 2016: Queries

Exercise 06
Creating a Query
Joins
Query Wizard
Exercise 07

Access 2016: Expressions

Setting up Validations
Calculation using Expressions

Access 2016: Reports

Basic Report
Report Design
Complex Report
Exercise 08

Access 2016: Printing

Printing and Print Properties

Access 2016: More Data Types

Yes/No, OLE Object, and Hyperlink Data Types

Access 2016: More About Forms

Form Controls
Form Themes
Navigation Form

Access 2016: Modal, Dialogs, and Macros

Introduction to Model Dialog and Macros
Model Dialog and Macros Continued
Form Validation
Adding a Command Button to a Form
Exercise 09

Access 2016: Web App Basics

Creating an Access Web App
Importing an Access Database to a Web App
Exercise 10

Access 2016: Exporting

Exporting an Access Database

Access 2016: Application Parts

Adding Application Parts to a Database

Access 2016: More Access Options

Additional Access 2016 Options

Access 2016: Info Tab

View and Edit Database Properties, and Encrypt with Password

Access 2016: Security

Trust Center Settings

Access 2016: Conclusion

Closing

Excel 2016 Advanced: Introduction to Excel 2016 Advanced Course

Prerequisites of the Course and Version of Excel
Essential Information for a Successful Training Experience
Course exercise files
Course demo files
Downloadable Course Transcripts
Course Structure

Excel 2016 Advanced: Functions

Functions - Part 1
Functions - Part 2
Autosum

Excel 2016 Advanced: Date and Time Functions

How Date and Time Works
Basic Date and Time Functions
Complex Date and Time Functions

Excel 2016 Advanced: Text Functions

Using Text Functions - Part 1
Using Text Functions - Part 2

Excel 2016 Advanced: Logical Functions

Using Logical Functions
Exercise 01

Excel 2016 Advanced: Lookup Functions

HLOOKUP Function
VLOOKUP Function
Exercise 02

Excel 2016 Advanced: Financial Functions

Financial Functions and Terminology
Personal Financial Functions
Professional Financial Functions
Depreciation
Exercise 03

Excel 2016 Advanced: Statistical Functions

Statistical Functions for Description - Part 1
Statistical Functions for Description - Part 2
Statistical Functions for Forecasting - Part 1
Statistical Functions for Forecasting - Part 2
Exercise 04
One Click Forecasting
Statistical Functions for Inference

Excel 2016 Advanced: Connecting to External Data

Connecting to Other Workbooks
Connecting to Access Databases
Connecting to Web Data Sources
Get and Transform
Exercise 05

Excel 2016 Advanced: Tables

Introduction to Tables
Working with Tables
Table References
Table Styles
Exercise 06

Excel 2016 Advanced: Pivot Tables

Introduction to Pivot Tables
Working with Pivot Tables
Filters and Slicers
Pivot Charts
Exercise 07

Excel 2016 Advanced: Data Analysis

What If Analysis
Scenario Manager
Goal Seek
Solver
Exercise 08

Excel 2016 Advanced: Graphs and Charts

Area Charts
Surface Charts
Radar Charts
Bubble Charts
Sparklines
Stock Charts
Exercise 09

Excel 2016 Advanced: Excel Web App

Web App - Part 1
Web App - Part 2

Excel 2016 Advanced: Conclusion

Closing Message

Learn Microsoft Outlook 2016: Introduction

Information about Installation and Upgrade
Essential Information for a Successful Training Experience
Course Exercise Files
Course Demo Files
Acquring Outlook 2016
What's New

Outlook 2016: Getting Started

Starting Outlook 2016
Using Touch
Outlook 2016 Interface
Getting Help
Keyboards Shortcuts and Keytips
Outlook Options

Outlook 2016: Basic Tasks

Setting Up an Account
Sending and Receiving Email
Calendar Basics
Exercise 01
People
Task Basics
Notes

Outlook 2016: Ribbon and Quick Access Toolbars

Customizing the Ribbon and Quick Access Toolbars
Exercise 02

Outlook 2016: Data Files and Account Management

Outlook Data Files and Their Properties
Managing Accounts
Managing Folders
Exercise 03
Backup and Restore a PST file

Outlook 2016: Contacts

Contact Records
Maintaning Contact Information
Contact Views
Using Contact Information
Address Books
Contact Groups
Exercise 04
Printing Contact Information

Outlook 2016: Email Management

Sending Messages
Receiving Messages
Replying to Messages
Touch Action Bar
Organizing Folder Contents
Junk Email
Security & Trust Center
Exercise 05

Outlook 2016: Archiving

Archiving

Outlook 2016: Calendar Management

Calendar Setup
Viewing & Sharing Calendars
Calendar Item Management
Managing Meetings
Calendar Events
To-do Bar
Printing Calendar Information
Exercise 06

Outlook 2016: Categories

Color Categories

Outlook 2016: Tasks Management

Managing Tasks
Viewing Tasks and Recording Progress

Outlook 2016: Rules & Quick Steps

Creating & Managing Rules
Quick Steps
Exercise 07

Outlook 2016: Other Features

Email Features
Proofing Features
Formatting Themes and Styles
Signatures and Stationery
Saving and Printing an Email
Exercise 08

Outlook 2016: Search Features

Searching Contacts and Other Items

Outlook 2016: Mail Merge

Mail Merge
Exercise 09

Outlook 2016: Conclusion

Office Updates; Conclusion
Outlook 2016 Quiz

Screenshots

The Ultimate Microsoft Office 2016 Training Bundle - Screenshot_01The Ultimate Microsoft Office 2016 Training Bundle - Screenshot_02The Ultimate Microsoft Office 2016 Training Bundle - Screenshot_03The Ultimate Microsoft Office 2016 Training Bundle - Screenshot_04

Our review

--- **Course Rating:** 4.39/5 **Overview:** The course has received overwhelmingly positive feedback from learners, with many commending its thoroughness and the expertise of the instructors. The majority of reviews praise the comprehensive coverage of advanced Excel features and the practical knowledge gained from the course. Users appreciate the opportunity to learn at their own pace and the ability to revisit lessons to ensure understanding. **Pros:** - **Comprehensive Content:** Learners report that the course is very thorough, especially in its coverage of advanced Excel features. It's praised for being comprehensive enough to cover a wide range of functionalities within Microsoft Excel. - **Expert Instructors:** The instructors are described as excellent and knowledgeable, with some even calling them patient and lucid. - **Flexible Pacing:** The self-paced nature of the course allows learners to go through material at a speed that suits their learning style and schedule. - **Practical Application:** The course is highly recommended for its practical approach to teaching Excel, with users noting that it's "worth every penny." - **Improved Understanding:** Several users mentioned that the course helped them understand not just the basics but also the "why's and how's" behind Excel operations. - **Diverse Learning Material:** The course includes a mix of lectures, explanations, and exercises that cater to different learning preferences. **Cons:** - **Pacing for Beginners:** Some users found the course to be paced at a level that may expect too much from beginners, particularly in the VBA section where instructions were not always clear. - **Technical Language:** There are instances where instructors use technical or application-specific terminology that can make it difficult for learners who are new to Excel or its functions. - **Organization of Material:** A few users suggested improvements in the organization of workbooks and worksheets, recommending a more compact structure to save time and make navigation easier. - **Subtitle Clarity:** One user pointed out that the captions/subtitles in English language could be improved for better clarity. - **Complexity in VBA Lectures:** The VBA lecture was criticized for being complicated and not well explained, leading some learners to skip that part altogether. - **Too Many Workbooks:** Some users expressed a desire for fewer workbooks with more organized sheets, as opposed to the current setup of multiple workbooks scattered across the course. **Additional Feedback:** - **Content Relevance:** One user noted that the advanced Excel content was far beyond what they would use at work but found it very complex and educational nonetheless. - **Refresher for Experienced Users:** Another learner mentioned that the course refreshed their knowledge of Excel and introduced new concepts, highlighting its value even if one is already familiar with MS Office. **Recommendation:** This course appears to be an excellent resource for those looking to deepen their understanding of Excel and Microsoft Office applications. It's particularly beneficial for intermediate users who want to explore advanced features. For beginners, it might be helpful to complement this course with more foundational training to ensure a smoother learning experience. Additionally, instructors could consider incorporating clearer explanations when introducing new or complex terminology and potentially revising the VBA lecture for better clarity. Organizing the workbooks and worksheets into a more streamlined structure could also enhance user experience.

Coupons

DateDiscountStatus
11/12/202092% OFF
expired
6/22/202288% OFF
expired

Charts

Price

The Ultimate Microsoft Office 2016 Training Bundle - Price chart

Rating

The Ultimate Microsoft Office 2016 Training Bundle - Ratings chart

Enrollment distribution

The Ultimate Microsoft Office 2016 Training Bundle - Distribution chart
973394
udemy ID
10/2/2016
course created date
5/5/2019
course indexed date
Bot
course submited by