Microsoft Excel, Outlook and Word 2016 for Beginners

Udemy

Learn about the fundamentals of Microsoft Office, as well as the features and functionality of Excel, Word, and Outlook.

Beginner

Online

₹ 499 3099

particular

details

                                    Medium of instructions
                                    English

                                    Mode of learning
                                    Self study

                                    Mode of Delivery
                                    Video and Text Based

Learn Microsoft 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
Section 1 - Quiz

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

Additional Training

READ ME: This Additional Training Is Optional
Ten Excel Tips and Tricks - Part 1
Ten Excel Tips and Tricks - Part 2
Ten Excel Tips and Tricks - Part 3

Popular Courses

Popular Platforms

Popular Searches