The Ultimate Microsoft Office 2016 Training Bundle

The Ultimate Microsoft Office 2016 Training Bundle, available at $129.99, has an average rating of 4.39, with 620 lectures, 17 quizzes, based on 4244 reviews, and has 19927 subscribers.

You will learn about 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 This course is ideal for individuals who are Those new to using Microsoft Excel, Outlook, Access, PowerPoint, and Word 2016 or This course is created for absolute beginners. or If you want to refresh your memory and understanding of Excel, Outlook, Access, Word and PowerPoint or Users of earlier versions of Access, Excel, Outlook, Word and PowerPoint It is particularly useful for Those new to using Microsoft Excel, Outlook, Access, PowerPoint, and Word 2016 or This course is created for absolute beginners. or If you want to refresh your memory and understanding of Excel, Outlook, Access, Word and PowerPoint or Users of earlier versions of Access, Excel, Outlook, Word and PowerPoint.

Enroll now: The Ultimate Microsoft Office 2016 Training Bundle

Summary

Title: The Ultimate Microsoft Office 2016 Training Bundle

Price: $129.99

Average Rating: 4.39

Number of Lectures: 620

Number of Quizzes: 17

Number of Published Lectures: 620

Number of Published Quizzes: 17

Number of Curriculum Items: 637

Number of Published Curriculum Objects: 637

Original Price: $199.99

Quality Status: approved

Status: Live

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

Who Should Attend

Those new to using Microsoft Excel, Outlook, Access, PowerPoint, and Word 2016
This course is created for absolute beginners.
If you want to refresh your memory and understanding of Excel, Outlook, Access, Word and PowerPoint
Users of earlier versions of Access, Excel, Outlook, Word and PowerPoint

Target Audiences

Those new to using Microsoft Excel, Outlook, Access, PowerPoint, and Word 2016
This course is created for absolute beginners.
If you want to refresh your memory and understanding of Excel, Outlook, Access, Word and PowerPoint
Users of earlier versions of Access, Excel, Outlook, Word and PowerPoint

** 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**

Course Curriculum

Chapter 1: Excel 2016: Introduction to Excel 2016 Beginner Course

Lecture 1: Acquiring Excel 2016 and Information on Installation and Upgrade

Lecture 2: WATCH ME: Essential Information for a Successful Training Experience

Lecture 3: Excel 2016 Course Exercise Files

Lecture 4: Excel 2016 Course Demo Files

Lecture 5: Downloadable Course Transcript

Lecture 6: Exercise Files

Chapter 2: Excel 2016: What's New

Lecture 1: New and Improved Features in Excel 2016

Chapter 3: Excel 2016: Using Touch

Lecture 1: Overview of Principles of Using Touchscreen

Chapter 4: Excel 2016: Getting Started

Lecture 1: Creating and Saving a Workbook

Lecture 2: Opening a Workbook

Chapter 5: Excel 2016: Using Help

Lecture 1: Online Help and Contextual Help

Chapter 6: Excel 2016: Excel Options

Lecture 1: Personalizing your use of Excel

Chapter 7: Excel 2016: The Ribbon and Toolbars

Lecture 1: Basics of using the Ribbon

Lecture 2: Quick Access Toolbar

Lecture 3: Tell Me Feature

Lecture 4: Mini Toolbars and Contextual Menus

Lecture 5: Status Bar

Chapter 8: Excel 2016: Entering and Editing Data

Lecture 1: Basics of Entering and Editing Data in a Workbook

Lecture 2: Exercise 01

Lecture 3: Formatting Dates

Lecture 4: Formatting Numbers

Lecture 5: Exercise 02

Chapter 9: Excel 2016: Backup and Recovery

Lecture 1: AutoSave, Recover Unsaved Workbook, and Create a Backup Copy

Chapter 10: Excel 2016: Fill and Series

Lecture 1: Working with Fill and Series

Lecture 2: Flash Fill

Chapter 11: Excel 2016: Viewing and Printing

Lecture 1: Workbook Views, Zoom, and Freeze

Lecture 2: Printing

Lecture 3: Exercise 03

Chapter 12: Excel 2016: Cut, Copy, and Paste

Lecture 1: Methods of Cutting, Copying, and Pasting

Chapter 13: Excel 2016: Formatting a Worksheet

Lecture 1: Delete and Clear

Lecture 2: Insert, Hide, Column Width and Row Height, and Merge

Lecture 3: Alignment

Lecture 4: Themes and Styles

Lecture 5: Exercise 04

Chapter 14: Excel 2016: Formulas and Functions

Lecture 1: Course review

Lecture 2: Basics of Fomulas and Functions

Lecture 3: Complex Examples of Formulas

Lecture 4: Exercise 05

Chapter 15: Excel 2016: Managing Worksheets

Lecture 1: Managing Worksheets

Chapter 16: Excel 2016: Working with Multiple Workbooks

Lecture 1: Working with Multiple Workbooks

Chapter 17: Excel 2016: Saving Workbooks

Lecture 1: Saving in Different File Types

Chapter 18: Excel 2016: Proofing

Lecture 1: The Spell Checker

Chapter 19: Excel 2016: Inserting Comments

Lecture 1: Inserting Comments

Lecture 2: Exercise 06

Chapter 20: Excel 2016: Basic Functions in Excel

Lecture 1: The VLOOKUP Function

Lecture 2: Text Functions

Lecture 3: Date and Time Functions

Lecture 4: Logical Functions

Chapter 21: Excel 2016: Graphs and Charts

Lecture 1: Creating Graphs and Charts

Lecture 2: Customizing a Cluster Column Chart

Lecture 3: Customizing a Pie Chart

Lecture 4: New Chart Types in Excel 2016

Lecture 5: Exercise 07

Chapter 22: Excel 2016: Sorting and Filtering Data

Lecture 1: Managing Data by Sorting

Lecture 2: Managing Data by Filtering

Lecture 3: Customizing Tables

Chapter 23: Excel 2016: Shapes and Pictures

Lecture 1: Inserting Shapes and Pictures

Lecture 2: Exercise 08

Chapter 24: Excel 2016: Formatting Cells Based on Content

Lecture 1: Conditional Formatting

Chapter 25: Excel 2016: Protection and Security

Lecture 1: Protecting Worksheets

Lecture 2: Protecting Workbooks

Chapter 26: Excel 2016: Naming Items

Lecture 1: Giving Items Names

Lecture 2: Exercise 09

Chapter 27: Excel 2016: Finding and Replacing Words

Lecture 1: Find and Replace

Chapter 28: Excel 2016: Borders

Lecture 1: Adding Borders

Chapter 29: Excel 2016: Workbook Inspection

Lecture 1: Inspecting a Workbook

Chapter 30: Excel 2016: Privacy Options

Lecture 1: Trust Center Privacy Options

Chapter 31: Excel 2016: Sharing Options

Lecture 1: Sharing a Workbook

Chapter 32: Excel 2016: Wrap Up

Instructors

Simon Sez IT
870,000+ Students, 260+ Courses, Learners in 180+ Countries

Rating Distribution

1 stars: 59 votes
2 stars: 76 votes
3 stars: 545 votes
4 stars: 1441 votes
5 stars: 2123 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!

Menu