- 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
Microsoft Office 2016 Essentials: 5 Course Bundle
Develop a detailed understanding of the principle and strategies involved with Microsoft Office 2016 applications including Word, Excel Powerpoint, and Outlook.
Online
₹ 455 3,499
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, 14 articles, and 13 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
- 14 articles
- 13 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
certificate availability
certificate providing authority
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.
Who it is for
The syllabus
Excel 2016: Introduction
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