- 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
- Section 1 - Quiz
Beginner
Online
₹ 529 3,499
Quick facts
particular | details | |
---|---|---|
Medium of instructions
English
|
Mode of learning
Self study
|
Mode of Delivery
Video and Text Based
|
Course overview
The Microsoft Excel, Outlook, and Word 2016 for Beginners online certification was created by Simon Sez IT, an educational platform with over 190 digital courses in information technology, and is offered by Udemy, which is aimed at individuals who want to master the functionalities and methodologies of programs like MS Word, MS Outlook, and MS Excel. Microsoft Excel, Outlook, and Word 2016 for Beginners online classes are designed for individuals and working professionals who want to learn the capabilities of Microsoft Office 2016 from the ground up.
Microsoft Excel, Outlook, and Word 2016 for Beginners online course incorporates over 29.5 hours of prerecorded learning as well as 10 downloadable study materials and 10 articles covering topics such as quick access toolbar, data entry, cell formatting, data editing, excel formulas, excel functions, ribbon interface, and more. Individuals will be awarded a certificate to certify their accomplishment and learning in excel, outlook, and word upon successful completion of this training.
The highlights
- Certificate of completion
- Self-paced course
- 29.5 hours of pre-recorded video content
- 10 articles
- 10 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 Excel, Outlook, and Word 2016 for Beginners certification course, individuals will develop a practical understanding of MS Word, MS Outlook, and MS Excel essentials. Individuals will look at the quick access toolbar, ribbon interface, pictures, charts, and graphics in presentations, documents, and emails to see how they work. Individuals will learn data entry, cell formatting, data editing, excel functions, excel formulae, and automation approaches.
Who it is for
The syllabus
Learn Microsoft 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
- Section 5 - Quiz
Excel 2016: Excel Options
- Personalizing your use of Excel
- Section 6 - Quiz
Excel 2016: The Ribbon and Toolbars
- Basics of using the Ribbon
- Quick Access Toolbar
- Tell Me Feature
- Mini Toolbars and Contextual Menus
- Status Bar
- Section 7 - Quiz
Excel 2016: Entering and Editing Data
- Basics of Entering and Editing Data in a Workbook
- Exercise 01
- Formatting Dates
- Formatting Numbers
- Exercise 02
- Section 8 - Quiz
Excel 2016: Backup and Recovery
- AutoSave, Recover Unsaved Workbook, and Create a Backup Copy
- Section 9 - Quiz
Excel 2016: Fill and Series
- Working with Fill and Series
- Flash Fill
- Section 10 - Quiz
Excel 2016: Viewing and Printing
- Workbook Views, Zoom, and Freeze
- Printing
- Exercise 03
- Section 11 - Quiz
Excel 2016: Cut, Copy, and Paste
- Methods of Cutting, Copying, and Pasting
- Section 12 - Quiz
Excel 2016: Formatting a Worksheet
- Delete and Clear
- Insert, Hide, Column Width and Row Height, and Merge
- Alignment
- Themes and Styles
- Exercise 04
- Section 13 - Quiz
Excel 2016: Formulas and Functions
- Basics of Fomulas and Functions
- Complex Examples of Formulas
- Exercise 05
- Section 14 - Quiz
Excel 2016: Managing Worksheets
- Rename, Insert, Move, and Reference a Worksheet
- Section 15 - Quiz
Excel 2016: Working with Multiple Workbooks
- Working with Multiple Workbooks
- Section 16 - Quiz
Excel 2016: Saving Workbooks
- Saving in Different File Types
- Section 17 - Quiz
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
- Section 20 - Quiz
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 07
- Section 21 - Quiz
Excel 2016: Sorting and Filtering Data
- Managing Data by Sorting
- Managing Date by Filtering
- Customizing Tables
- Section 22 Quiz
Excel 2016: Shapes and Pictures
- Inserting Shapes and Pictures
- Exercise 08
- Section 23 Quiz
Excel 2016: Formatting Cells Based on Content
- Conditional Formatting
- Section 24 Quiz
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
- Section 27- Quiz
Excel 2016: Borders
- Adding Borders
- Section 28 - Quiz
Excel 2016: Workbook Inspection
- Inspecting a Workbook
Excel 2016: Privacy Options
- Trust Center Privacy Options
Excel 2016: Sharing Options
- Sharing a Workbook
- Section 31 - Quiz
Excel 2016: Wrap Up
- Closing
Learn Microsoft Outlook 2016: Introduction
- Introduction to the Course
- Watch Me: Essential Information for a Successful Training Experience
- Course Exercise Files
- Course Demo Files
- Acquiring Outlook 2016
- What's New
- Section 35 - Quiz
Outlook 2016: Getting Started
- Starting Outlook 2016
- Using Touch
- Outlook 2016 Interface
- Getting Help
- Keyboards Shortcuts and Keytips
- Outlook Options
- Section 34 - Quiz
Outlook 2016: Basic Tasks
- Setting Up an Account
- Sending and Receiving Email
- Calendar Basics
- Exercise 01
- People
- Task Basics
- Notes
- Section 35 - Quiz
Outlook 2016: Ribbon and Quick Access Toolbars
- Customizing the Ribbon and Quick Access Toolbars
- Exercise 02
- Section 36 - Quiz
Outlook 2016: Data Files and Account Management
- Outlook Data Files and Their Properties
- Managing Accounts
- Managing Folders
- Exercise 03
- Backup and Restore a PST file
- Section 37 - Quiz
Outlook 2016: Contacts
- Contact Records
- Maintaning Contact Information
- Contact Views
- Using Contact Information
- Address Books
- Contact Groups
- Exercise 04
- Printing Contact Information
- Section 38 - Quiz
Outlook 2016: Email Management
- Sending Messages
- Receiving Messages
- Replying to Messages
- Touch Action Bar
- Organizing Folder Contents
- Junk Email
- Security & Trust Center
- Exercise 05
- Section 39 - Quiz
Outlook 2016: Archiving
- Archiving
- Section 40 - Quiz
Outlook 2016: Calendar Management
- Calendar Setup
- Viewing & Sharing Calendars
- Calendar Item Management
- Managing Meetings
- Calendar Events
- To-do Bar
- Printing Calendar Information
- Exercise 06
- Section 41 - Quiz
Outlook 2016: Categories
- Color Categories
- Section 42 - Quiz
Outlook 2016: Tasks Management
- Managing Tasks
- Viewing Tasks and Recording Progress
- Section 43 - Quiz
Outlook 2016: Rules & Quick Steps
- Creating & Managing Rules
- Quick Steps
- Exercise 07
- Section 44 - Quiz
Outlook 2016: Other Features
- Email Features
- Proofing Features
- Formatting Themes and Styles
- Signatures and Stationery
- Saving and Printing an Email
- Exercise 08
- Section 45 - Quiz
Outlook 2016: Search Features
- Searching Contacts and Other Items
- Section 46 - Quiz
Outlook 2016: Mail Merge
- Mail Merge
- Exercise 09
- Section 47 - Quiz
Outlook 2016: Conclusion
- Office Updates; Conclusion
Learn Microsoft Word 2016: Introduction
- Welcome and Overview
- Watch Me: Essential Information for a Successful Training Experience
- Course 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
- Practice Exercise
- Section 50: Quiz
Word 2016: Character Formatting
- AutoCorrect Options
- Selecting text
- Cut, Copy & Paste
- Character Formatting Options
- Format Painter
- Working with numbers
- Working with bullets
- Creating an Outline
- Practice Exercise
Word 2016: Paragraph Formatting
- Alignment Options
- Line Spacing Options
- Working with Indents
- Working with Tabs
- Practice Exercise
- Section 52 - Quiz
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
- Practice Exercise
- Section 54 - Quiz
Word 2016: Styles
- Working with Styles
- Creating Styles
- Editing Styles
- Practice Exercise
- Section 55 - Quiz
Word 2016: Controlling Page Appearance
- Working with Page Breaks
- Working with Columns
- Adding a Watermark
- Applying Page Borders
- Headers & Footers
- Practice Exercise
- Section 56 - Quiz
Word 2016: Sectioning
- What is Sectioning?
- Sectioning a Document
- Odd and Even Sections
- Practice Exercise
- Section 57 - Quiz
Word 2016: Graphics
- Inserting Pictures
- Inserting Pictures into Existing Documents
- Picture Options
- Working with Shapes
- Other Graphic Options
- Practice Exercise
- Section 58 - Quiz
Word 2016: Envelopes & Labels
- Working with Envelopes
- Working with Labels
- Section 59 - Quiz
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
- Practice Exercise
- Section 60 - Quiz
Word 2016: Quick Parts
- Building Blocks
- Creating and Editing Building Blocks
- Auto Text
- Practice Exercise
- Section 61 - Quiz
Word 2016: Indexing and Table of Contents
- Creating an Index
- Creating a Table of Contents
- Practice Exercise
- Section 62 - Quiz
Word 2016: Review and Printing
- Using the Thesaurus
- Spell Check
- Comments
- Margins
- Page Setup Options
- Printing
- Practice Exercise
- Section 63 - Quiz
Word 2016: Other Word Features
- Word Options
- Protecting a Document
- Macros
Word 2016: Wrap Up
- Closing
Extras
- Extra Resource: Designing Better Spreadsheets Webinar Recording
- Extra Resource: Data Cleaning in Excel Webinar Recording
- Extra Resource: Top Ten Excel Functions You HAVE to Know Webinar Recording
- Extra Resource: The Most Frequently Used Excel Shortcuts - Infographic
- Extra Resource: The Most Frequently Used Word Shortcuts - Infographic
- Extra Resource: The Most Frequently Used Outlook Shortcuts - Infographic
Articles
Popular Articles
Latest Articles
Similar Courses
Excel for Beginners
Great Learning
Microsoft Excel for Beginners
GreyCampus
Excel for Beginners
Davidson College, Davidson via Edx
Analyzing Data with Excel
IBM via Edx
Excel VBA for Creative Problem Solving Part 1
CU Boulder via Coursera
Everyday Excel Part 1
CU Boulder via Coursera
Courses of your interest
How to start Blogging
Great Learning
Smart English Basics for Professionals
Great Learning
Write a Book Creative Writing Skills For Beginner ...
Simpliv Learning
Learn How To Start Your Own Soap Making Business L...
Simpliv Learning
Revolutionize Your Career Competitive Edge
Simpliv Learning
Write A Feature Length Screenplay For Film Or Tele...
MSU East Lansing via Coursera
English Work Advanced Job Interview Skills
The Hong Kong Polytechnic Univer... via Edx
English Work Basic Job Interview Skills
The Hong Kong Polytechnic Univer... via Edx
How to Jumpstart Your Hidden Creative Genius
MSU East Lansing via Coursera
How to Write an Essay
UC Berkeley via Edx
More Courses by Udemy
Joomla for Beginners
Udemy