Microsoft Office 2016 Essentials: 5 Course Bundle

BY
Udemy

Develop a detailed understanding of the principle and strategies involved with Microsoft Office 2016 applications including Word, Excel Powerpoint, and Outlook.

Mode

Online

Fees

₹ 2899

Quick Facts

particular details
Medium of instructions English
Mode of learning Self study
Mode of Delivery Video and Text Based

Course overview

Simon Sez IT designed the Microsoft Office 2016 Essentials: 5 Course Bundle online certification, which is made available by Udemy and is aimed to teach a practical understanding of all basic, intermediate, and advanced level skills throughout these MS Office 2016 editions. Microsoft Office 2016 Essentials: 5 Course Bundle online classes by Udemy are designed to help applicants gain a thorough understanding of the principles connected with MS Office applications such as Excel, Word, Powerpoint, and Outlook.

Microsoft Office 2016 Essentials: 5 Course Bundle online training is a self-paced video-based training program with over 41.5 hours of comprehensive learning resources, 17 articles, and 16 downloadable study materials covering topics such as data entry, cell formatting, dynamic formulas, graphs, charts, mail merge, calendar management, document protection, and more.

The highlights

  • Certificate of completion
  • Self-paced course
  • 41.5 hours of pre-recorded video content
  • 17 articles
  • 16 downloadable resources

Program offerings

  • Online course
  • Learning resources. 30-day money-back guarantee
  • Unlimited access
  • Accessible on mobile devices and tv

Course and certificate fees

Fees information
₹ 2,899
certificate availability

Yes

certificate providing authority

Udemy

What you will learn

After completing the Microsoft Office 2016 Essentials: 5 Course Bundle online training, applicants will gather a thorough comprehension of the basic as well as complex topics associated with Microsft office applications including Outlook, Powerpoint, Word, and Excel. Applicants will gain knowledge of a variety of tools, including a quick access toolbar, a ribbon interface, graphs, charts, a lookup function, and a dynamic formula. Applicants will also learn about calendar management, document security, mail merge, and cell formatting strategies.

The syllabus

Excel 2016: Introduction

  • Acquiring Excel 2016 and Information on Installation and Upgrade
  • WATCH ME: Essential Information for a Successful Training Experience
  • Course Exercise Files
  • Course Demo Files
  • Downloadable Course Transcripts
  • Exercise Files
  • Excel Quiz 1

Excel 2016: What's New

  • New and Improved Features in Excel 2016

Excel 2016: Using Touch

  • Overview of Principles of Using Touchscreen

Excel 2016: Getting Started

  • Creating and Saving a Workbook
  • Opening a Workbook

Excel 2016: Using Help

  • Online Help and Contextual Help
  • Excel Quiz 2

Excel 2016: Excel Options

  • Personalizing your use of Excel
  • Excel Quiz 3

Excel 2016: The Ribbon and Toolbars

  • Basics of using the Ribbon
  • Quick Access Toolbar
  • Tell Me Feature
  • Mini Toolbars and Contextual Menus
  • Status Bar
  • Excel Quiz 4

Excel 2016: Entering and Editing Data

  • Basics of Entering and Editing Data in a Workbook
  • Exercise 01
  • Formatting Dates
  • Formatting Numbers
  • Exercise 02
  • Excel Quiz 5

Excel 2016: Backup and Recovery

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

Excel 2016: Fill and Series

  • Working with Fill and Series
  • Flash Fill
  • Excel Quiz 7

Excel 2016: Viewing and Printing

  • Workbook Views, Zoom, and Freeze
  • Printing
  • Exercise 03
  • Excel Quiz 8

Excel 2016: Cut, Copy, and Paste

  • Methods of Cutting, Copying, and Pasting
  • Excel Quiz 9

Excel 2016: Formatting a Worksheet

  • Delete and Clear
  • Insert, Hide, Column Width and Row Height, and Merge
  • Alignment
  • Themes and Styles
  • Exercise 04
  • Excel Quiz 10

Excel 2016: Formulas and Functions

  • Basics of Formulas and Functions
  • Complex Examples of Formulas
  • Exercise 05
  • Excel Quiz 11

Excel 2016: Managing Worksheets

  • Rename, Insert, Move, and Reference a Worksheet
  • Excel Quiz 12

Excel 2016: Working with Multiple Workbooks

  • Working with Multiple Workbooks
  • Excel Quiz 13

Excel 2016: Saving Workbooks

  • Saving in Different File Types
  • Excel Quiz 14

Excel 2016: Proofing

  • The Spell Checker

Excel 2016: Inserting Comments

  • Inserting Comments
  • Exercise 06

Excel 2016: Basic Functions in Excel

  • The VLOOKUP Function
  • Text Functions
  • Date and Time Functions
  • Logical Functions
  • Excel Quiz 15

Excel 2016: Graphs and Charts

  • Creating Graphs and Charts
  • Customizing a Cluster Column Chart
  • Customizing a Pie Chart
  • New Chart Types in Excel 2016
  • Exercise 7
  • Excel Quiz 16

Excel 2016: Sorting and Filtering Data

  • Managing Data by Sorting
  • Managing Date by Filtering
  • Customizing Tables
  • Excel Quiz 17

Excel 2016: Shapes and Pictures

  • Inserting Shapes and Pictures
  • Exercise 08
  • Excel Quiz 18

Excel 2016: Formatting Cells Based on Content

  • Conditional Formatting
  • Excel Quiz 19

Excel 2016: Protection and Security

  • Protecting Worksheets
  • Protecting Workbooks

Excel 2016: Naming Items

  • Giving Items Names
  • Exercise 09

Excel 2016: Finding and Replacing Words

  • Find and Replace
  • Excel Quiz 20

Excel 2016: Borders

  • Adding Borders
  • Excel Quiz 21

Excel 2016: Workbook Inspection

  • Inspecting a Workbook

Excel 2016: Privacy Options

  • Trust Center Privacy Options

Excel 2016: Sharing Options

  • Sharing a Workbook
  • Excel Quiz 22

Excel 2016: Conclusion

  • Conclusion and Close

Excel 2016 Advanced: Introduction to Excel 2016 Advanced Course

  • Prerequisites of the Course and Version of Excel
  • WATCH ME: Essential Information for a Successful Training Experience
  • Excel 2016 Advanced Exercise Files
  • Excel 2016 Advanced Course Files

Excel 2016 Advanced: Functions

  • Functions - Part 1
  • Functions - Part 2
  • Autosum
  • Excel Advanced Quiz 1

Excel 2016 Advanced: Date and Time Functions

  • How Date and Time Works
  • Basic Date and Time Functions
  • Complex Date and Time Functions
  • Excel Advanced Quiz 2

Excel 2016 Advanced: Text Functions

  • Using Text Functions - Part 1
  • Using Text Functions - Part 2
  • Excel Advanced Quiz 3

Excel 2016 Advanced: Logical Functions

  • Using Logical Functions
  • Exercise 01
  • Excel Advanced Quiz 4

Excel 2016 Advanced: Lookup Functions

  • HLOOKUP Function
  • VLOOKUP Function
  • Exercise 02
  • Excel Advanced Quiz 5

Excel 2016 Advanced: Financial Functions

  • Financial Functions and Terminology
  • Personal Financial Functions
  • Professional Financial Functions
  • Depreciation
  • Exercise 03
  • Excel Advanced Quiz 6

Excel 2016 Advanced: Statistical Functions

  • Statistical Functions for Description - Part 1
  • Statistical Functions for Description - Part 2
  • Statistical Functions for Forecasting - Part 1
  • Statistical Functions for Forecasting - Part 2
  • Exercise 04
  • One Click Forecasting
  • Statistical Functions for Inference
  • Excel Advanced Quiz 7

Excel 2016 Advanced: Connecting to External Data

  • Connecting to Other Workbooks
  • Connecting to Access Databases
  • Connecting to Web Data Sources
  • Get and Transform
  • Exercise 05
  • Excel Advanced Quiz 8

Excel 2016 Advanced: Tables

  • Introduction to Tables
  • Working with Tables
  • Table References
  • Table Styles
  • Exercise 06
  • Excel Advanced Quiz 9

Excel 2016 Advanced: Pivot Tables

  • Introduction to Pivot Tables
  • Working with Pivot Tables
  • Filters and Slicers
  • Pivot Charts
  • Exercise 07
  • Excel Advanced Quiz 10

Excel 2016 Advanced: Data Analysis

  • What If Analysis
  • Scenario Manager
  • Goal Seek
  • Solver
  • Exercise 08
  • Excel Advanced Quiz 11

Excel 2016 Advanced: Graphs and Charts

  • Area Charts
  • Surface Charts
  • Radar Charts
  • Bubble Charts
  • Sparklines
  • Stock Charts
  • Exercise 09
  • Excel Advanced Quiz 12

Excel 2016 Advanced: Excel Web App

  • Introduction to Excel Web App
  • Using the Excel Web App
  • Excel Advanced Quiz 13

Excel 2016 Advanced: Course Conclusion

  • Closing Message

Word 2016: Introduction

  • Welcome and Overview
  • WATCH ME: Essential Information for a Successful Training Experience
  • Word 2016 Exercise Files
  • What's New in Word 2016
  • Overview of MS Word Screen
  • Backstage View

Word 2016: Getting Started with Word

  • Creating a New Blank Document
  • Working with Non-Printing Characters and Line Spacing Basics
  • Saving a Document
  • Opening a Document
  • Navigating in a Document
  • Go To, Find, and Replace
  • Editing a Document
  • Module 2 Practice Exercise
  • Word 2016 Quiz 1

Word 2016: Character Fomatting

  • AutoCorrect Options
  • Selecting Text
  • Cut, Copy & Paste
  • Character Formatting Options
  • Format Painter
  • Working with Numbers
  • Working with Bullets
  • Creating an Outline
  • Module 3 Practice Exercise

Word 2016: Paragraph Formatting

  • Alignment Options
  • Line Spacing Options
  • Working with Indents
  • Working with Tabs
  • Module 4 Practice Exercise
  • Word 2016 Quiz 2

Word 2016: Managing Lists

  • Sorting a List

Word 2016: Tables

  • Working with Tables
  • Creating a Table
  • Adding Rows and Columns to a Table
  • Formatting Table Data
  • Borders & Shading
  • Sorting in a Table
  • Drawing a Table
  • Converting Existing Data to a Table
  • Quick Tables
  • Using Formula in Tables
  • Module 6 Practice Exercise
  • Word 2016 Quiz 3

Word 2016: Styles

  • Working with Styles
  • Creating Styles
  • Editing Styles
  • Module 7 Practice Exercise
  • Word 2016 Quiz 4

Word 2016: Controlling Page Appearance

  • Working with Page Breaks
  • Working with Columns
  • Adding a Watermark
  • Applying Page Borders
  • Headers & Footers
  • Module 8 Practice Exercise
  • Word 2016 Quiz 5

Word 2016: Sectioning

  • What is Sectioning?
  • Sectioning a Document
  • Odd and Even Sections
  • Module 9 Practice Exercise
  • Word 2016 Quiz 6

Word 2016: Graphics

  • Inserting Pictures
  • Inserting Pictures into Existing Documents
  • Picture Options
  • Working with Shapes
  • Other Graphic Options
  • Module 10 Practice Exercise
  • Word 2016 Quiz 7

Word 2016: Envelopes & Labels

  • Working with Envelopes
  • Working with Labels
  • Word 2016 Quiz 8

Word 2016: Mail Merges

  • What is Mail Merge?
  • Creating a Mail Merge Document - Part 1
  • Creating a Mail Merge Document - Part 2
  • Merging a Document with an Existing Data Source
  • Sorting and Filtering Images
  • Merging Envelopes and Labels
  • Merging a Directory
  • Module 12 Practice Exercise
  • Word 2016 Quiz 9

Word 2016: Page Setup Options

  • Building Blocks
  • Creating and Editing Building Blocks
  • Auto Text
  • Module 13 Practice Exercise
  • Word 2016 Quiz 10

Word 2016: Indexing and Table of Contents

  • Creating an Index
  • Creating a Table of Contents
  • Module 14 Practice Exercise
  • Word 2016 Quiz 11

Word 2016: Review and Printing

  • Using the Thesaurus
  • Spell Check
  • Comments
  • Margins
  • Page Setup Options
  • Printing
  • Module 15 Practice Exercise
  • Word 2016 Quiz 12

Word 2016: Other Word Features

  • Word Options
  • Protecting a Document
  • Macros

Word 2016: Wrap Up

  • Closing Video

PowerPoint 2016: Course Introduction

  • Welcome and Overview
  • WATCH ME: Essential Information for a Successful Training Experience
  • PowerPoint 2016 Exercise Files
  • New Features in PowerPoint 2016
  • New features in PowerPoint 2016 for MAC

PowerPoint 2016: Overview

  • Navigate a PowerPoint Presentation
  • Overview of the Desktop Screen and Views
  • Exercise 01

PowerPoint 2016: Getting Started

  • Presentation Tips and Guidelines
  • Creating a New Presentation
  • Working with Slides
  • Saving a Presentation
  • Exercise 02
  • PowerPoint 2016 Quiz 1

PowerPoint 2016: Text and Bullet Editing Options

  • Formatting Text
  • Working with Bullets
  • Exercise 03
  • PowerPoint 2016 Quiz 2

PowerPoint 2016: Adding Graphics to Your Presentation

  • Inserting Shapes
  • Inserting Graphics
  • Inserting Pictures
  • Exercise 04
  • PowerPoint 2016 Quiz 3

PowerPoint 2016: Working with Objects

  • Selecting Objects
  • Editing Objects
  • Formatting Objects - Part 1
  • Formatting Objects - Part 2
  • Arranging Objects
  • Grouping Objects
  • Exercise 05
  • PowerPoint 2016 Quiz 4

PowerPoint 2016: Working with Pictures

  • Picture Options
  • Cropping Pictures
  • Formatting Pictures
  • Things You Can Do with Pictures
  • Exercise 06
  • PowerPoint 2016 Quiz 5

PowerPoint 2016: Working with SmartArt

  • Creating SmartArt
  • Modifying SmartArt
  • Creating a Flowchart Using SmartArt
  • Exercise 07
  • PowerPoint 2016 Quiz 6

PowerPoint 2016: Working with Tables

  • Creating Tables
  • Formatting Tables
  • Inserting Tables
  • Exercise 08
  • PowerPoint 2016 Quiz 7

PowerPoint 2016: Working with Charts

  • Adding Charts
  • Formatting Charts
  • Inserting Charts from MS Excel
  • Exercise 09
  • PowerPoint 2016 Quiz 8

PowerPoint 2016: Masters

  • Using Masters
  • Changing Master Slides
  • Creating a New Master Design Template
  • Exercise 10
  • PowerPoint 2016 Quiz 9

PowerPoint 2016: Working with Media

  • Adding Video to a Presentation
  • Adding Audio to a Presentation
  • Exercise 11
  • PowerPoint 2016 Quiz 10

PowerPoint 2016: Transitions

  • Applying Transitions
  • Transition Options
  • Exercise 12
  • PowerPoint 2016 Quiz 11

PowerPoint 2016: Animation

  • Animating an Object
  • Effect Options
  • Working with the Animation Pane
  • Motion Paths
  • Triggers
  • Exercise 13
  • PowerPoint 2016 Quiz 12

PowerPoint 2016: Hyperlinks and Action Buttons

  • Working with Action Buttons
  • Working with Hyperlinks
  • Exercise 14
  • PowerPoint 2016 Quiz 13

PowerPoint 2016: Slideshow Options

  • Onscreen Presentation Options
  • Hiding Slides
  • Changing the Order of Slides
  • Copying Slides
  • Slideshow Options
  • Exercise 15

PowerPoint 2016: Preparing a Presentation for Delivery

  • Rehearse Timings
  • Recording a Presentation
  • Slide Show Settings
  • Creating a Custom Slide Show
  • Exercise 16

PowerPoint 2016: Other PowerPoint Features

  • Exporting Options
  • Working with the Backstage View & Customization Options
  • Customizing the Ribbon
  • Printing a Presentation
  • Exercise 17

PowerPoint 2016: Conclusion

  • Conclusion

Outlook 2016: Introduction

  • Information about Installation and Upgrade
  • WATCH ME: Essential Information for a Successful Training Experience
  • Outlook 2016 Exercise Files
  • Outlook 2016 Course Files
  • Acquring Outlook 2016
  • What's New in Outlook 2016
  • Outlook Quiz Section 84

Outlook 2016: Getting Started

  • Starting Outlook 2016
  • Using Touch
  • Outlook 2016 Interface
  • Getting Help
  • Keyboards Shortcuts and Keytips
  • Outlook Options
  • Outlook Quiz Section 85

Outlook 2016: Basic Tasks in Outlook

  • Setting Up an Account
  • Sending and Receiving Email
  • Calendar Basics
  • Exercise 01
  • People
  • Task Basics
  • Notes
  • Outlook Quiz Section 86

Outlook 2016: Ribbon and Quick Access Toolbars

  • Customizing the Ribbon and Quick Access Toolbars
  • Exercise 02
  • Outlook Quiz Section 87

Outlook 2016: Outlook Data Files and Account Management

  • Outlook Data Files and Their Properties
  • Managing Accounts
  • Managing Folders
  • Exercise 03
  • Backup and Restore a PST file
  • Outlook Quiz Section 88

Outlook 2016: Contacts

  • Contact Records
  • Maintaning Contact Information
  • Contact Views
  • Using Contact Information
  • Address Books
  • Contact Groups
  • Exercise 04
  • Printing Contact Information
  • Outlook Quiz Section 89

Outlook 2016: Email Management

  • Sending Messages
  • Receiving Messages
  • Replying to Messages
  • Touch Action Bar
  • Organizing Folder Contents
  • Junk Email
  • Security & Trust Center
  • Exercise 05
  • Outlook Quiz Section 90

Outlook 2016: Archiving

  • Archiving
  • Outlook Quiz Section 91

Outlook 2016: Calendar Management

  • Calendar Setup
  • Viewing & Sharing Calendars
  • Calendar Item Management
  • Managing Meetings
  • Calendar Events
  • To-do Bar
  • Printing Calendar Information
  • Exercise 06
  • Outlook Quiz Section 92

Outlook 2016: Outlook Categories

  • Color Categories
  • Outlook Quiz Section 93

Outlook 2016: Tasks Management

  • Managing Tasks
  • Viewing Tasks and Recording Progress
  • Outlook Quiz Section 94

Outlook 2016: Rules & Quick Steps

  • Creating & Managing Rules
  • Quick Steps
  • Exercise 07
  • Outlook Quiz Section 95

Outlook 2016: Other Features

  • Email Features
  • Proofing Features
  • Formatting Themes and Styles
  • Signatures and Stationery
  • Saving and Printing an Email
  • Exercise 08
  • Outlook Quiz Section 96

Outlook 2016: Search Features

  • Searching Contacts and Other Items
  • Outlook Quiz Section 97

Outlook 2016: Mail Merge

  • Mail Merge
  • Exercise 09
  • Outlook Quiz Section 98

Outlook 2016: Conclusion

  • Office Updates; Conclusion

Bonus

  • EXTRA RESOURCE: The Most Frequently Used Excel Shortcuts - Infographic
  • EXTRA RESOURCE: The Most Frequently Used PowerPoint Shortcuts - Infographic
  • EXTRA RESOURCE: The Most Frequently Used Word Shortcuts - Infographic
  • EXTRA RESOURCE: The Most Frequently Used Access Shortcuts - Infographic
  • EXTRA RESOURCE: The Most Frequently Used Outlook Shortcuts - Infographic

Trending Courses

Popular Courses

Popular Platforms

Learn more about the Courses

Download the Careers360 App on your Android phone

Regular exam updates, QnA, Predictors, College Applications & E-books now on your Mobile

Careers360 App
150M+ Students
30,000+ Colleges
500+ Exams
1500+ E-books