The Ultimate Microsoft Office 2016 Training Bundle
4.4 (180 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
2,265 students enrolled
Wishlisted Wishlist

Please confirm that you want to add The Ultimate Microsoft Office 2016 Training Bundle to your Wishlist.

Add to Wishlist

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.
Best Seller
4.4 (180 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
2,265 students enrolled
Created by Simon Sez IT
Last updated 6/2017
English
Curiosity Sale
Current price: $10 Original price: $200 Discount: 95% off
30-Day Money-Back Guarantee
Includes:
  • 51 hours on-demand video
  • 22 Articles
  • 11 Supplemental Resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I 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
  • Practice what you learned with included exercise files
View Curriculum
Requirements
  • Microsoft Office 2013 or 2016 desktop version for Windows installed and ready to use on your computer.
Description

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

  • Spreadsheets with Excel 2016
  • Documents with Word 2016
  • Presentations with PowerPoint 2016
  • Databases with Access 2016
  • Excel Automation with Visual Basic for Applications (VBA)

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.  You'll likely find it in nearly every business around the globe, and this training will help ensure you stay on top of ever-changing improvements in office productivity.

Advance your MS Office skills and go beyond the basics of this powerful suite of programs.  Whether you need to create a spreadsheet for data analysis, a database of customer contacts or an engaging presentation to wow your clients and coworkers alike, you'll gain greater flexibility and opportunities for creativity by learning the more advanced capabilities of its programs.

Contents and Overview

This course is designed for individuals and office professionals who need to master the capabilities of the latest edition of Microsoft Office.

With more than 48 hours of video lectures in 7 courses, this course will help you master MS Office 2016 and give you the tools you need to make lasting improvements in your office efficiency.

  • 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.

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

Most work today happens on a computer. Optimize your effort by learning useful software tips and tricks that you can apply for decades to come, saving you valuable time, money and effort.

Want to get noticed by your boss or earn the respect of your colleagues? Become the office superstar by being the go-to expert on everything related to MS Office 2016.

Video training for these individual courses would easily cost thousands of dollars, but this package is available at one unbelievably low price. That's tremendous learning at tremendous savings.

** Updated June 2017. Course transcripts now available.

Who is the target audience?
  • Those new to using Microsoft Excel, PowerPoint, and Word 2016
  • This course is created for absolute beginners.
  • If you want to refresh your memory and understanding of Excel, Word and PowerPoint
  • Users of earlier versions of Excel, Word and PowerPoint
Students Who Viewed This Course Also Viewed
Curriculum For This Course
450 Lectures
51:23:49
+
Excel 2016: Introduction to Excel 2016 Beginner Course
6 Lectures 17:20

Essential Information for a Successful Training Experience
01:36

Excel 2016 Course Exercise Files
00:26

Excel 2016 Course Demo Files
00:26


Downloadable Course Transcripts
00:21
+
Excel 2016: What's New
1 Lecture 02:55
+
Excel 2016: Using Touch
1 Lecture 05:36
+
Excel 2016: Getting Started
2 Lectures 25:29
Creating and Saving a Workbook
15:16

Opening a Workbook
10:13
+
Excel 2016: Using Help
1 Lecture 06:27
Online Help and Contextual Help
06:27
+
Excel 2016: Excel Options
1 Lecture 10:50
Personalizing your use of Excel
10:50
+
Excel 2016: The Ribbon and Toolbars
5 Lectures 36:19

Quick Access Toolbar
05:45

Tell Me Feature
06:49

Mini Toolbars and Contextual Menus
03:47

Status Bar
05:02
+
Excel 2016: Entering and Editing Data
5 Lectures 43:26

Exercise 01
01:50

Formatting Dates
12:36

Formatting Numbers
13:48

Exercise 02
01:43
+
Excel 2016: Backup and Recovery
1 Lecture 07:35
AutoSave, Recover Unsaved Workbook, and Create a Backup Copy
07:35
+
Excel 2016: Fill and Series
2 Lectures 13:12
Working with Fill and Series
09:08

Flash Fill
04:04
114 More Sections
About the Instructor
Simon Sez IT
4.4 Average rating
11,582 Reviews
304,158 Students
117 Courses
300,000+ Students | Wordwide Use 180 Countries |120+ Courses

Since 2008, individuals, small businesses, and Fortune 500 companies with thousands of employees have benefited from the easy and hands-on software training offered by Simon Sez IT. With 80+ courses and 4,500+ video tutorials on a range of software programs, Simon Sez IT ensures stress-free eLearning and enhanced employee productivity - no matter whether you are implementing new software or a technological upgrade for your workplace. With over 300,000 Udemy students in over 180 countries, Simon Sez IT is the preferred eLearning choice for individuals and businesses everywhere.