Description

About this course

This course is part of the Microsoft Professional Program Certificate in IT Support.

In this training course, you will learn basic Word, Excel, and Outlook skills.

You will learn how to create and manage Word documents, organize information in tables, perform calculations on data, create graphs and charts, organize your email Inbox, and manage email automatically.

Today, employers across many industries and fields expect candidates to have Microsoft Office skills, as it is the most universally utilized software in business. Having these skills, even at a basic level, will help with your job prospects and increase your chances to be considered for most roles.

What you’ll learn

• Create and edit Word documents
• Create and perform data calculations with Excel spreadsheets.
• Manage your email and calendar in Outlook.

Prerequisites

There is no prerequisites for this course.

Estimate Time : 8-16 hours

Module 1 Word Fundamentals

• Word 2016 Basics
• Create and Manage Documents
• Enter and Edit Text
• Modify the structure and appearance of text
• Create custom document elements
• Lab

Module 2 Advance Skills in Word

• Organize Information in columns and tables
• Add simple graphic elements
• Finalize and Distribute documents
• Merge data with documents and labels
• Lab

Module 3 Excel Fundamentals

• Setup a workbook
• Work with data and excel tables
• Preform calculations on data
• Lab

Module 4 Advance Skills in Excel

• Change workbook appearance
• Create Charts and Graphics
• Print worksheets and charts
• Create dynamic worksheets using Pivot table
• Lab

Module 5 Outlook Fundamentals

• Introducing Outlook
• Organize your Inbox
• Managing Calendar and Tasks
• Lab

Module 6 Advance Skills in Outlook

• Manage Windows Elements
• Customized Outlook
• Manage email automatically
• Lab

Robert Deupree Jr.
Senior Content Developer Microsoft

Robert Deupree Jr. is a Senior Content Developer with the Microsoft Learning eXperiences team. After a first career as a marine biologist, Robert joined Microsoft as a biology writer for Encarta Encyclopedia and has continued creating Microsoft training content for over 20 years.

Doug Thomas
Senior Content Developer Microsoft

Doug Thomas used to review movies and rent you — or your parents — VHS tapes. After 8 years at Amazon — doing much of the same thing — he came to Microsoft Office to get away from all of that. While being a site manager, he had an idea to get other people to create videos about Office. That idea turned into a new job of creating videos and training content for Support.Office.com including the Office 15-Minute Webinars and his current series, Doug from Office. However, none of his videos are on VHS.

Additional information

Certificate