4.4 out of 5
4.4
29 reviews on Udemy

Microsoft Office 2016 Essentials: 5 Course Bundle

Learn Microsoft Office 2016 the easy way with this comprehensive, 5-course bundle. Includes Excel (basic & advanced), Wo
Instructor:
Simon Sez IT
3,620 students enrolled
English [Auto-generated]
Discover new and improved features in Excel 2016, Word, PowerPoint & Outlook.
Excel: Learn to personalize Excel in Excel Options.
Excel: The Quick Access Toolbar.
Excel: Data entry, cell formatting, working with multiple worksheets and the Ribbon.
Excel: Backup and recover your Excel spreadsheets - never lose a file again.
Excel: AutoFill & Flash Fill.
Excel: How and when to use formulas and functions.
Excel: How to sort and filter your data
Excel: How to password protect and secure your data
Adv Excel: Discover common Excel hotkeys
Adv Excel: How to use VLOOKUP and HLOOKUP
Adv Excel: IF, COUNTIF, SUMIF and other logical functions
Adv Excel: Using named ranges
Adv Excel: The power of Dynamic Formulas and how to use them
Adv Excel: Advanced level charts and graphs
Adv Excel: Analyzing data using PivotTables, Slicers, Power Query and PivotCharts
PowerPoint: Presentation tips for an amazing presentation
PowerPoint: Format text like a pro
PowerPoint: Insert charts, graphics and pictures to add some "zing" to your presentation
PowerPoint: Wow your audience by adding animations, audio and video
PowerPoint: Time saving techniques including duplicating slides, and exporting your presentation
Word: How to control page appearance including using columns, indents, footers, borders and watermarks
Word: How to create a mail merge
Word: Printing, including on envelopes and labels
Word: How to protect your document
Word: To spell check
Word: Insert pictures and graphics in your Word document
Word: How to insert and edit tables
Outlook: To use Outlook on touchscreens
Outlook: Keyboard shortcuts to increase your productivity
Outlook: Calendar management and organization
Outlook: Maintaining contacts, address books and groups
Outlook: Messaging basics and inbox organisation
Outlook: Creating and managing tasks and rules
Outlook: How to Mail Merge

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

  • BUSINESSES RUN ON MICROSOFT OFFICE. Microsoft Office remains the go-to tool for millions of office workers. This bundle will help you master the basic 4 programmes that everyone should know.

  • PERFECT FOR BEGINNERS AND ADVANCED USERS ALIKE. This bundle covers basic, intermediate and advanced level skills across these MS Office products. Whether you’re brand new to MS Office or you’ve been using it for years, you’ll learn plenty from this comprehensive training bundle.

  • MAKING SOFTWARE SIMPLE. Our approach to teaching is all about making complex software simple to use. Our expert tutors don’t rush through content, instead they take the time to explain how things work in simple, plain English.

  • EVERYTHING IS INCLUDED. You don’t get just a how to video from Simon Sez IT. Modules include downloadable practice exercises so you can put into practice what you learn straight away. If that’s not enough you’ll also get Certificates of Completion – proof that you’ve learnt those valuable Microsoft Office skills.

  • A GREAT GIFT IDEA. Not shopping for you? No problem, give the gift of learning with Simon Sez IT and help the ones you love succeed.

Are you regularly asking coworkers for help in Excel, PowerPoint or Word?

Are you often left wondering how a piece of analysis was conducted, what a VLOOKUP is or just how your colleague made that presentation look so good?

If that’s you, it’s time to do something about it.

Learning Microsoft Office has never been easier. You don’t need to wait for you company to send you on a course or pay for expensive evening tuition. At Simon Sez IT we’re dedicated to making software simple and doing it a price to suit any budget. That’s why we put together this 5-course bundle covering the ESSENTIAL skills you need to impress in Microsoft Office.

Courses included:

  1. Microsoft Excel (Beginner) 2016

  2. Microsoft Excel (Advanced) 2016

  3. Microsoft Word 2016

  4. Microsoft PowerPoint 2016

  5. Microsoft Outlook 2016

This 5-in-1 bundle will have you performing complex Excel functions, crunching data in PivotTables, winning hearts and minds with your impressive presentations and wowing colleagues with you email and document management.

Learn at your own pace, as this bundle is yours to keep – forever.

Why Take This Course

Nearly every business uses Microsoft Office, it’s one of the most valuable and most transferable skills you can have. This course is aimed at either taking you from beginner to advanced or intermediate to advanced in 4 crucial Microsoft Office applications.

Why Simon Sez IT? We’re dedicated to making software simple and have done so for hundreds of thousands of users around the world. We make the complicated easy to understand.

Excel 2016: Introduction

1
Acquiring Excel 2016 and Information on Installation and Upgrade
2
Essential Information for a Successful Training Experience
3
Course Exercise Files
4
Course Demo Files
5
Downloadable Course Transcripts
6
Exercise Files
7
Excel Quiz 1

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
2
Excel Quiz 2

Excel 2016: Excel Options

1
Personalizing your use of Excel
2
Excel Quiz 3

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
6
Excel Quiz 4

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
6
Excel Quiz 5

Excel 2016: Backup and Recovery

1
AutoSave, Recover Unsaved Workbook, and Create a Backup Copy
2
Excel Quiz 6

Excel 2016: Fill and Series

1
Working with Fill and Series
2
Flash Fill
3
Excel Quiz 7

Excel 2016: Viewing and Printing

1
Workbook Views, Zoom, and Freeze
2
Printing
3
Exercise 03
4
Excel Quiz 8

Excel 2016: Cut, Copy, and Paste

1
Methods of Cutting, Copying, and Pasting
2
Excel Quiz 9

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
6
Excel Quiz 10

Excel 2016: Formulas and Functions

1
Basics of Formulas and Functions
2
Complex Examples of Formulas
3
Exercise 05
4
Excel Quiz 11

Excel 2016: Managing Worksheets

1
Rename, Insert, Move, and Reference a Worksheet
2
Excel Quiz 12

Excel 2016: Working with Multiple Workbooks

1
Working with Multiple Workbooks
2
Excel Quiz 13

Excel 2016: Saving Workbooks

1
Saving in Different File Types
2
Excel Quiz 14

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
5
Excel Quiz 15

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 7
6
Excel Quiz 16

Excel 2016: Sorting and Filtering Data

1
Managing Data by Sorting
2
Managing Date by Filtering
3
Customizing Tables
4
Excel Quiz 17

Excel 2016: Shapes and Pictures

1
Inserting Shapes and Pictures
2
Exercise 08
3
Excel Quiz 18

Excel 2016: Formatting Cells Based on Content

1
Conditional Formatting
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.4
4.4 out of 5
29 Ratings

Detailed Rating

Stars 5
12
Stars 4
9
Stars 3
6
Stars 2
0
Stars 1
2
b267ef2d419ffae021011b0d1f64ad14
30-Day Money-Back Guarantee

Includes

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