Udemy

The Ultimate Microsoft Office 2016 Training Bundle

Enroll Now
  • 19,984 Students
  • Updated 3/2023
  • Certificate Available
4.5
(4,270 Ratings)
CTgoodjobs selects quality courses to enhance professionals' competitiveness. By purchasing courses through links on our site, we may receive an affiliate commission.

Course Information

Registration period
Year-round Recruitment
Course Level
Study Mode
Duration
6 Hour(s) 9 Minute(s)
Language
English
Taught by
Simon Sez IT
Certificate
  • Available
  • *The delivery and distribution of the certificate are subject to the policies and arrangements of the course provider.
Rating
4.5
(4,270 Ratings)

Course Overview

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.

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

  • 160 section(s)
  • 620 lecture(s)
  • Section 1 Excel 2016: Introduction to Excel 2016 Beginner Course
  • Section 2 Excel 2016: What's New
  • Section 3 Excel 2016: Using Touch
  • Section 4 Excel 2016: Getting Started
  • Section 5 Excel 2016: Using Help
  • Section 6 Excel 2016: Excel Options
  • Section 7 Excel 2016: The Ribbon and Toolbars
  • Section 8 Excel 2016: Entering and Editing Data
  • Section 9 Excel 2016: Backup and Recovery
  • Section 10 Excel 2016: Fill and Series
  • Section 11 Excel 2016: Viewing and Printing
  • Section 12 Excel 2016: Cut, Copy, and Paste
  • Section 13 Excel 2016: Formatting a Worksheet
  • Section 14 Excel 2016: Formulas and Functions
  • Section 15 Excel 2016: Managing Worksheets
  • Section 16 Excel 2016: Working with Multiple Workbooks
  • Section 17 Excel 2016: Saving Workbooks
  • Section 18 Excel 2016: Proofing
  • Section 19 Excel 2016: Inserting Comments
  • Section 20 Excel 2016: Basic Functions in Excel
  • Section 21 Excel 2016: Graphs and Charts
  • Section 22 Excel 2016: Sorting and Filtering Data
  • Section 23 Excel 2016: Shapes and Pictures
  • Section 24 Excel 2016: Formatting Cells Based on Content
  • Section 25 Excel 2016: Protection and Security
  • Section 26 Excel 2016: Naming Items
  • Section 27 Excel 2016: Finding and Replacing Words
  • Section 28 Excel 2016: Borders
  • Section 29 Excel 2016: Workbook Inspection
  • Section 30 Excel 2016: Privacy Options
  • Section 31 Excel 2016: Sharing Options
  • Section 32 Excel 2016: Wrap Up
  • Section 33 PowerPoint 2016: Course Introduction
  • Section 34 PowerPoint 2016: Overview
  • Section 35 PowerPoint 2016: Getting Started
  • Section 36 PowerPoint 2016: Text and Bullet Editing Options
  • Section 37 PowerPoint 2016: Adding Graphics to Your Presentation
  • Section 38 PowerPoint 2016: Working with Objects
  • Section 39 PowerPoint 2016: Working with Pictures
  • Section 40 PowerPoint 2016: Working with SmartArt
  • Section 41 PowerPoint 2016: Working with Tables
  • Section 42 PowerPoint 2016: Working with Charts
  • Section 43 PowerPoint 2016: Masters
  • Section 44 PowerPoint 2016: Working with Media
  • Section 45 PowerPoint 2016: Transitions
  • Section 46 PowerPoint 2016: Animation
  • Section 47 PowerPoint 2016: Hyperlinks and Action Buttons
  • Section 48 PowerPoint 2016: Slideshow Options
  • Section 49 PowerPoint 2016: Preparing a Presentation for Delivery
  • Section 50 PowerPoint 2016: Other PowerPoint Features
  • Section 51 PowerPoint 2016: Conclusion
  • Section 52 Word 2016: Introduction
  • Section 53 Word 2016: Getting Started with Word
  • Section 54 Word 2016: Character Formatting
  • Section 55 Word 2016: Paragraph Formatting
  • Section 56 Word 2016: Managing Lists
  • Section 57 Word 2016: Tables
  • Section 58 Word 2016: Styles
  • Section 59 Word 2016: Controlling Page Appearance
  • Section 60 Word 2016: Sectioning
  • Section 61 Word 2016: Graphics
  • Section 62 Word 2016: Envelopes & Labels
  • Section 63 Word 2016: Mail Merges
  • Section 64 Word 2016: Quick Parts
  • Section 65 Word 2016: Indexing and Table of Contents
  • Section 66 Word 2016: Review and Printing
  • Section 67 Word 2016: Other Word Features
  • Section 68 Word 2016: Wrap Up
  • Section 69 Excel 2016 Intermediate: Introduction
  • Section 70 Excel 2016 Intermediate: Indexing and Lookups
  • Section 71 Excel 2016 Intermediate: Named Ranges
  • Section 72 Excel 2016 Intermediate: Dynamic Formula
  • Section 73 Excel 2016 Intermediate: Charts and Graphs
  • Section 74 Excel 2016 Intermediate: Working with Data
  • Section 75 Essential VBA Training for Excel: Introduction
  • Section 76 Essential VBA Training for Excel: The Environment
  • Section 77 Essential VBA Training for Excel: VBA as a Language
  • Section 78 Essential VBA Training for Excel: Introducing Macros
  • Section 79 Essential VBA Training for Excel: Introducing Functions
  • Section 80 Essential VBA Training for Excel: Common Keys to VBA
  • Section 81 Essential VBA Training for Excel: Conclusion
  • Section 82 Macros and VBA Course Introduction
  • Section 83 Macros and VBA: Creating Macros
  • Section 84 Editing Macros with VBA
  • Section 85 Macros and VBA: Custom Macro Ribbon
  • Section 86 Macro and VBA: Course Close
  • Section 87 Access 2016: Introduction
  • Section 88 Access 2016: Using Touch
  • Section 89 Access 2016: Getting Started
  • Section 90 Access 2016: Help
  • Section 91 Access 2016: The Ribbon and Toolbars
  • Section 92 Access 2016: Keyboard Shortcuts and Key Tips
  • Section 93 Access 2016: Access Options
  • Section 94 Access 2016: Tables
  • Section 95 Access 2016: Importing Data
  • Section 96 Access 2016: Backup, Restore, and Repair
  • Section 97 Access 2016: Datasheet View
  • Section 98 Access 2016: Relationships
  • Section 99 Access 2016: Forms
  • Section 100 Access 2016: Subforms
  • Section 101 Access 2016: Queries
  • Section 102 Access 2016: Expressions
  • Section 103 Access 2016: Reports
  • Section 104 Access 2016: Printing
  • Section 105 Access 2016: More Data Types
  • Section 106 Access 2016: More About Forms
  • Section 107 Access 2016: Modal, Dialogs, and Macros
  • Section 108 Access 2016: Web App Basics
  • Section 109 Access 2016: Exporting
  • Section 110 Access 2016: Application Parts
  • Section 111 Access 2016: More Access Options
  • Section 112 Access 2016: Info Tab
  • Section 113 Access 2016: Security
  • Section 114 Access 2016: Conclusion
  • Section 115 Excel 2016 Advanced: Introduction to Excel 2016 Advanced Course
  • Section 116 Excel 2016 Advanced: Functions
  • Section 117 Excel 2016 Advanced: Date and Time Functions
  • Section 118 Excel 2016 Advanced: Text Functions
  • Section 119 Excel 2016 Advanced: Logical Functions
  • Section 120 Excel 2016 Advanced: Lookup Functions
  • Section 121 Excel 2016 Advanced: Financial Functions
  • Section 122 Excel 2016 Advanced: Statistical Functions
  • Section 123 Excel 2016 Advanced: Connecting to External Data
  • Section 124 Excel 2016 Advanced: Tables
  • Section 125 Excel 2016 Advanced: Pivot Tables
  • Section 126 Excel 2016 Advanced: Data Analysis
  • Section 127 Excel 2016 Advanced: Graphs and Charts
  • Section 128 Excel 2016 Advanced: Excel Web App
  • Section 129 Excel 2016 Advanced: Conclusion
  • Section 130 Learn Microsoft Outlook 2016: Introduction
  • Section 131 Outlook 2016: Getting Started
  • Section 132 Outlook 2016: Basic Tasks
  • Section 133 Outlook 2016: Ribbon and Quick Access Toolbars
  • Section 134 Outlook 2016: Data Files and Account Management
  • Section 135 Outlook 2016: Contacts
  • Section 136 Outlook 2016: Email Management
  • Section 137 Outlook 2016: Archiving
  • Section 138 Outlook 2016: Calendar Management
  • Section 139 Outlook 2016: Categories
  • Section 140 Outlook 2016: Tasks Management
  • Section 141 Outlook 2016: Rules & Quick Steps
  • Section 142 Outlook 2016: Other Features
  • Section 143 Outlook 2016: Search Features
  • Section 144 Outlook 2016: Mail Merge
  • Section 145 Outlook 2016: Conclusion
  • Section 146 An Introduction to OneNote
  • Section 147 OneNote: Getting Started
  • Section 148 OneNote: Adding Content
  • Section 149 OneNote: Formatting Notes
  • Section 150 OneNote: Organizing Content
  • Section 151 OneNote: Formatting Pages
  • Section 152 OneNote: Working with Templates
  • Section 153 OneNote: Using Drawing Tools
  • Section 154 OneNote: Interacting with Outlook
  • Section 155 OneNote: Sharing a Notebook
  • Section 156 OneNote: Collaborating on a Notebook
  • Section 157 OneNote: Setting OneNote Options
  • Section 158 Other Versions of OneNote
  • Section 159 OneNote: Course Close
  • Section 160 Congratulations!

What You’ll 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


Reviews

  • C
    Cecilio Rivero
    5.0

    Excelentes explicaciones y material didáctico. Gracias

  • J
    Jude Almeida
    5.0

    This comprehensive 74-hour course takes you from beginner to advanced levels with ease. The examples are clear, practical, and highly relevant. It's an excellent investment for anyone looking to learn or sharpen their skills. A must-purchase!

  • Y
    Yugavaan raj
    1.0

    Please Don't buy this course and Waste your money it was out dated Course. this course was recorded in 2015 there is no update till now.

  • Z
    Zaidat
    5.0

    The course is explanatory, very easy to understand

Start FollowingSee all

We use cookies to enhance your experience on our website. Please read and confirm your agreement to our Privacy Policy and Terms and Conditions before continue to browse our website.

Read and Agreed