4.49 out of 5
4.49
505 reviews on Udemy

Microsoft Office 2016 Essential Training: 9 Course Bundle

Comprehensive, all-in-one training to get the most out of Microsoft Office 2016. 9-in-1 courses with 70 hours of video.
Instructor:
Simon Sez IT
5,450 students enrolled
English [Auto-generated] More
Discover new and improved features in Excel 2016, Word, PowerPoint, OneNote & Access.
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
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
Sorting information and running queries
Creating tables and relationships
Learn valuable new skills for complex data projects at work
Discover how to into import data from Excel
Learn Queries, use validations, how to create and print reports
Dive into options for packaging your application for distribution
Share notebooks and collaborate with others
Integrate OneNote with Microsoft Outlook
How to use the OneNote interface
Tag your notes and how to search them
Use handwriting in OneNote
How to protect your notes

Unlock the Power Of Microsoft Office 2016 and Watch Your Productivity Soar!

  • A KILLER TIME & MONEY SAVER! Equip yourself with in-depth knowledge of online Microsoft
    2016 training courses and save precious time on class attendance! Get the skills required to
    skyrocket your performance at the classroom or the office with a COMPLETE bundle of 9 online
    courses that will turn you into a pro computer user from the convenience of your own home!

  • THE PERFECT CHOICE FOR BEGINNERS OR ADVANCED USERS! Whether you already know
    enough on the most popular Microsoft programs or you are an absolute beginner, this is the
    product for you! Get hands-on experience in using Access, Excel, OneNote, PowerPoint, and
    Word 2016 and meet your full potential on the demanding work market!

  • WE ARE REVOLUTIONIZING ONLINE LEARNING! With our long expertise in STRESS-FREE e-
    learning, at Simon Sez IT we know how to help you make the most of your home learning! Get
    ALL practice you need with the EXERCISE FILES, find useful info in the comprehensive VIDEO
    TUTORIALS, keep TRACK OF YOUR PROGRESS and get the CERTIFICATES OF COMPLETION as
    reliable proof of your knowledge!

  • TURBOCHARGE YOUR SKILLS THE EASY WAY! Acquiring the MUST-HAVE skills for the modern
    market requirements has never been easier! Get ALL 9 online software courses in one GREAT
    VALUE FOR MONEY pack and plan your own training based on your specific time schedule!
    Flexible, easy to follow and eye-opening both for BEGINNERS and ADVANCED users, this
    Microsoft 2016 course bundle is made for smart e-learners!

  • A THOUGHTFUL GIFTING IDEA! If you are in search of a gift that will thrill every computer user,
    your quest is ending here! Offer your best friend, teenaged kid or office co-worker this stunning
    gift and help them open new horizons in their work! Equip their arsenal with the best Microsoft
    2016 software bundle on the market and have them thankful for your excellent choice!

Do you feel embarrassed every time you are asked to make a file in Word, Excel or Access?

Do you wish you could be a competent Microsoft Software user but are deterred by the COST and TIME
spent on classes?

Are you looking for an EASY, CONVENIENT way to conquer solid knowledge on the most sought-after
programs and skyrocket your work potential?

With a long expertise in the last advances in e-learning, Simon Sez IT is now offering you the ultimate e-
learning software training tool in a COMPLETE 9 in 1 bundle!

We Are Turning You Into A Software Savvy From The Convenience Of Your Home!

You don’t have to spend a fortune on classes anymore; you can save yourself the time spent on
commuting to training institutes!

We are making hands-on knowledge of 9 training courses a breeze, teaching you in your own SELF-
PACED learning environment:

  1. Microsoft Excel 2016 – Beginners

  2. Microsoft Excel 2016 – Advanced

  3. Microsoft Word 2016

  4. Microsoft OneNote 2013:

  5. Microsoft PowerPoint 2016:

  6. Microsoft Access 2016 – Beginners

  7. Microsoft Access 2016 – Advanced

  8. Microsoft Essential VBA for Excel

  9. VBA Intermediate Training- Discover Excel Automation Secrets

Why Take This Course

Most work today happens on a computer – optimize your effort by
learning useful software tips and tricks that you’ll apply for decades
to come! And that will save 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 becoming the go-to expert on
everything related to MS Office 2016!

Individual video training for these programs would easily cost hundreds of dollars, but this 9-in-1 package is available at one
unbelievably low price. Tremendous learning at tremendous savings.

Excel 2016: Introduction to Excel 2016 Beginner Course

1
Introduction
2
Essential Information for a Successful Training Experience
3
Course exercise files
4
Course demo files
5
Exercise Files
6
Downloadable Course Transcripts for Excel 2016 Beginner Course

The transcription for this course is now available. It consists of all 9 hours of video transcribed, organized by chapter, and with a Table of Contents. This downloadable & printable transcript provides another learning option - if you prefer reading but don’t have time to take notes.

Click on the link to view and download the transcripts;:

https://www.dropbox.com/s/fr4ft1gs186luwa/Microsoft%20Excel%202016%20for%20Beginners.pdf?dl=0 

All the best with your training.

Best,

Simon

P.S. If you're enjoying the training, please take 1 minute to leave a 5 star review.

Excel 2016: What's New

1
New and Improved Features in Excel 2016

Excel 2016: Using Touch

1
Overview of Principles of Using Touchscreen

Excel 2016: Getting Started

1
Creating and Saving a Workbook
2
Opening a Workbook

Excel 2016: Using Help

1
Online Help and Contextual Help

Excel 2016: Excel Options

1
Personalizing your use of Excel

Excel 2016: The Ribbon and Toolbars

1
Basics of using the Ribbon
2
Quick Access Toolbar
3
Tell Me Feature
4
Mini Toolbars and Contextual Menus
5
Status Bar

Excel 2016: Entering and Editing Data

1
Basics of Entering and Editing Data in a Workbook
2
Exercise 01
3
Formatting Dates
4
Formatting Numbers
5
Exercise 02

Excel 2016: Backup and Recovery

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

Excel 2016: Fill and Series

1
Working with Fill and Series
2
Flash Fill

Excel 2016: Viewing and Printing

1
Workbook Views, Zoom, and Freeze
2
Printing
3
Exercise 03

Excel 2016: Cut, Copy, and Paste

1
Methods of Cutting, Copying, and Pasting

Excel 2016: Formatting a Worksheet

1
Delete and Clear
2
Insert, Hide, Column Width and Row Height, and Merge
3
Alignment
4
Themes and Styles
5
Exercise 04

Excel 2016: Formulas and Functions

1
Basics of Fomulas and Functions
2
Complex Examples of Formulas
3
Exercise 05

Excel 2016: Managing Worksheets

1
Managing Worksheets

Excel 2016: Working with Multiple Workbooks

1
Working with Multiple Workbooks

Excel 2016: Saving Workbooks

1
Saving in Different File Types

Excel 2016: Proofing

1
The Spell Checker

Excel 2016: Inserting Comments

1
Inserting Comments
2
Exercise 06

Excel 2016: Basic Functions in Excel

1
The VLOOKUP Function
2
Text Functions
3
Date and Time Functions
4
Logical Functions

Excel 2016: Graphs and Charts

1
Creating Graphs and Charts
2
Customizing a Cluster Column Chart
3
Customizing a Pie Chart
4
New Chart Types in Excel 2016
5
Exercise 07

Excel 2016: Sorting and Filtering Data

1
Managing Data by Sorting
2
Managing Date by Filtering
3
Customizing Tables

Excel 2016: Shapes and Pictures

1
Inserting Shapes and Pictures
2
Exercise 08

Excel 2016: Formatting Cells Based on Content

1
Conditional Formatting

Excel 2016: Protection and Security

1
Protecting Worksheets
2
Protecting Workbooks

Excel 2016: Naming Items

1
Giving Items Names
2
Exercise 09

Excel 2016: Finding and Replacing Words

1
Find and Replace

Excel 2016: Borders

1
Adding Borders

Excel 2016: Workbook Inspection

1
Inspecting a Workbook

Excel 2016: Privacy Options

1
Trust Center Privacy Options

Excel 2016: Sharing Options

1
Sharing a Workbook

Excel 2016: Wrap Up

1
Closing
You can view and review the lecture materials indefinitely, like an on-demand channel.
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!
4.5
4.5 out of 5
505 Ratings

Detailed Rating

Stars 5
287
Stars 4
132
Stars 3
69
Stars 2
10
Stars 1
6
b4bd70c20a7b2ac92b2109493a9b4c3b
30-Day Money-Back Guarantee

Includes

66 hours on-demand video
26 articles
Full lifetime access
Access on mobile and TV
Certificate of Completion