Information Technology

Microsoft Office

Instructor-Led 79 Agenda

Description

In this course, students will create, edit, and enhance standard business documents using Microsoft Office and Windows 10.

Course Overview

In this course, students will create, edit, and enhance standard business documents using Microsoft Office and Windows 10.

Course Objective

Upon successful completion of this course, students will be able to create, edit and enhance documents, spreadsheets, emails, presentations and files in Office and Windows 10.

Who Should Attend

This course is intended for individuals who want to gain basic knowledge of working in Windows and Office products.

Accessing Windows 10 Lesson Id 1

Accessing Windows 10

Using Windows Apps and Desktop Applications Lesson Id 2

Using Windows Apps and Desktop Applications

Working with Files and Folders Lesson Id 3

Working with Files and Folders

Accessing the Internet using Microsoft Edge Lesson Id 4

Accessing the Internet using Microsoft Edge

Customizing the Windows 10 Environment Lesson Id 5

Customizing the Windows 10 Environment

Installing and Removing Devices Lesson Id 6

Installing and Removing Devices

Using Windows 10 Security Features Lesson Id 7

Using Windows 10 Security Features

Getting Started with Word Lesson Id 8

Getting Started with Word

Editing a Document Lesson Id 9

Editing a Document

Formatting Text and Paragraphs Lesson Id 10

Formatting Text and Paragraphs

Adding Tables Lesson Id 11

Adding Tables

Managing Lists Lesson Id 12

Managing Lists

Inserting Graphic Objects Lesson Id 13

Inserting Graphic Objects

Controlling Page Appearance Lesson Id 14

Controlling Page Appearance

Proofing a Document Lesson Id 15

Proofing a Document

Customizing the Word Environment Lesson Id 16

Customizing the Word Environment

Working with Tables and Charts Lesson Id 17

Working with Tables and Charts

Customizing Formats Using Styles and Themes Lesson Id 18

Customizing Formats Using Styles and Themes

Using Images in a Document Lesson Id 19

Using Images in a Document

Creating Custom Graphic Elements Lesson Id 20

Creating Custom Graphic Elements

Inserting Content Using Quick Parts Lesson Id 21

Inserting Content Using Quick Parts

Controlling Text Flow Lesson Id 22

Controlling Text Flow

Using Templates Lesson Id 23

Using Templates

Using Mail Merge Lesson Id 24

Using Mail Merge

Using Macros Lesson Id 25

Using Macros

Collaborating on Documents Lesson Id 26

Collaborating on Documents

Adding Reference Marks and Notes Lesson Id 27

Adding Reference Marks and Notes

Simplifying and Managing Long Documents Lesson Id 28

Simplifying and Managing Long Documents

Securing a Document Lesson Id 29

Securing a Document

Forms Lesson Id 30

Forms

Getting Started with Outlook 2016 Lesson Id 31

Getting Started with Outlook 2016

Composing Messages Lesson Id 32

Composing Messages

Reading and Responding to Messages Lesson Id 33

Reading and Responding to Messages

Managing Your Messages Lesson Id 34

Managing Your Messages

Managing Your Calendar Lesson Id 35

Managing Your Calendar

Managing Your Contacts Lesson Id 36

Managing Your Contacts

Working with Tasks and Notes Lesson Id 37

Working with Tasks and Notes

Customizing the Outlook Environment Lesson Id 38

Customizing the Outlook Environment

Configure Advanced Message Options Lesson Id 39

Configure Advanced Message Options

Advanced Message Management Lesson Id 40

Advanced Message Management

Advanced Calendar Management Lesson Id 41

Advanced Calendar Management

Advanced Contact Management Lesson Id 42

Advanced Contact Management

Managing Activities by Using Tasks and Journal Entries Lesson Id 43

Managing Activities by Using Tasks and Journal Entries

Sharing Workspaces with Others Lesson Id 44

Sharing Workspaces with Others

Managing Outlook Data Files Lesson Id 45

Managing Outlook Data Files

Getting Started with Microsoft Office Excel 2013 Lesson Id 46

Getting Started with Microsoft Office Excel 2013

Performing Calculations Lesson Id 47

Performing Calculations

Modifying a Worksheet Lesson Id 48

Modifying a Worksheet

Formatting a Worksheet Lesson Id 49

Formatting a Worksheet

Printing Workbooks Lesson Id 50

Printing Workbooks

Managing Workbooks Lesson Id 51

Managing Workbooks

Customizing the Excel Environment Lesson Id 52

Customizing the Excel Environment

Creating Advanced Formulas Lesson Id 53

Creating Advanced Formulas

Analyzing Data with Functions and Conditional Formatting Lesson Id 54

Analyzing Data with Functions and Conditional Formatting

Organizing and Analyzing Datasets and Tables Lesson Id 55

Organizing and Analyzing Datasets and Tables

Visualizing Data with Basic Charts Lesson Id 56

Visualizing Data with Basic Charts

Analyzing Data With Pivotables, Slicers, and Pivotcharts Lesson Id 57

Analyzing Data With Pivotables, Slicers, and Pivotcharts

Working with Multiple Worksheets and Workbooks Simultaneously Lesson Id 58

Working with Multiple Worksheets and Workbooks Simultaneously

Sharing and Protecting Workbooks Lesson Id 59

Sharing and Protecting Workbooks

Automating Wrokbook Functionality Lesson Id 60

Automating Wrokbook Functionality

Applying Conditional Logic Lesson Id 61

Applying Conditional Logic

Auditing Worksheets Lesson Id 62

Auditing Worksheets

Using Automated Analysis Tools Lesson Id 63

Using Automated Analysis Tools

Presenting Your Data Visually Lesson Id 64

Presenting Your Data Visually

Getting Started with PowerPoint Lesson Id 65

Getting Started with PowerPoint

Developing a PowerPoint Presentation Lesson Id 66

Developing a PowerPoint Presentation

Performing Advance Text Editing Lesson Id 67

Performing Advance Text Editing

Adding Graphical Elements to your Presentation Lesson Id 68

Adding Graphical Elements to your Presentation

Modifying Objects in your Presentation Lesson Id 69

Modifying Objects in your Presentation

Adding Tables to your Presentation Lesson Id 70

Adding Tables to your Presentation

Adding Charts to your Presentation Lesson Id 71

Adding Charts to your Presentation

Preparing to Deliver Your Presentation Lesson Id 72

Preparing to Deliver Your Presentation

Modifying the PowerPoint Environment Lesson Id 73

Modifying the PowerPoint Environment

Customizing Design Templates Lesson Id 74

Customizing Design Templates

Adding Smartart to a Presentation Lesson Id 75

Adding Smartart to a Presentation

Working with Media and Animations Lesson Id 76

Working with Media and Animations

Collaborating on a Presentation Lesson Id 77

Collaborating on a Presentation

Customizing a Slide Show Lesson Id 78

Customizing a Slide Show

Securing and Distributing a Presentation Lesson Id 79

Securing and Distributing a Presentation

Lesson Id	Title	Description
1	Accessing Windows 10	Topic A: Navigate the Windows 10 Desktop <br />Topic B: Manage the Start Menu <br />Topic C: Sign In to Windows 10<br />
2	Using Windows Apps and Desktop Applications	Topic A: Navigate Desktop Applications <br />Topic B: Navigate Windows Apps Features <br />Topic C: Navigate the Cortana Virtual Assistant App
3	Working with Files and Folders	Topic A: Manage Files and Folders with File Explorer <br />Topic B: Store and Share Files with OneDrive <br />Topic C: Multitask with Open Apps
4	Accessing the Internet using Microsoft Edge	Topic A: Use Microsoft Edge <br />Topic B: Customize Microsoft Edge
5	Customizing the Windows 10 Environment	Topic A: Customize the Start Screen <br />Topic B: Customize the Desktop
6	Installing and Removing Devices	Topic A: Manage Printers <br />Topic B: Manage Peripheral Devices
7	Using Windows 10 Security Features	Topic A: Manage Passwords and Privacy Levels <br />Topic B: Use Windows Defender
8	Getting Started with Word	Identify the Components of the Word Interface <br />Create a Word Document <br />Help
9	Editing a Document	Navigate and Select Text <br />Modify Text <br />Find and Replace Text
10	Formatting Text and Paragraphs	Apply Character Formatting <br />Align Text Using Tabs <br />Display Text as List Items <br />Control Paragraph Layout <br />Apply Borders and Shading <br />Apply Styles <br />Manage Formatting
11	Adding Tables	Insert a Table <br />Modify a Table <br />Format a Table<br />Convert Text to a Table
12	Managing Lists	Sort a List <br />Renumber a List <br />Customize a List
13	Inserting Graphic Objects	Insert Symbols and Special Characters <br />Add Images to a Document
14	Controlling Page Appearance	Apply a Page Border and Color <br />Add a Watermark <br />Add Headers and Footers <br />Control Page Layout
15	Proofing a Document	Check Spelling and Grammar <br />Other Proofing Tools
16	Customizing the Word Environment	Customize the Word Interface <br />Additional Save Options
17	Working with Tables and Charts	Sort Table Data <br />Control Cell Layout <br />Perform Calculations in a Table <br />Create a Chart
18	Customizing Formats Using Styles and Themes	Create and Modify Text Styles <br />Create Custom List or Table Styles <br />Apply Document Themes
19	Using Images in a Document	Resize an Image <br />Adjust Image Appearance <br />Integrate Pictures and Text <br />Insert and Format Screenshots <br />Insert Video
20	Creating Custom Graphic Elements	Create Text Boxes and Pull Quotes <br />Draw Shapes <br />Add WordArt and Other Text Effects <br />Create Complex Illustrations with SmartArt
21	Inserting Content Using Quick Parts	Insert Building Blocks <br />Create and Modify Building Blocks <br />Insert Fields Using Quick Parts
22	Controlling Text Flow	Control Paragraph Flow <br />Insert Section Breaks <br />Insert Columns <br />Link Text Boxes to Control Text Flow
23	Using Templates	Create a Document Using a Template <br />Create a Template
24	Using Mail Merge	The Mail Merge Features <br />Merge Envelopes and Labels <br />Create a Data Source Using Word
25	Using Macros	Automate Tasks Using Macros <br />Create a Macro
26	Collaborating on Documents	Modify User Information <br />Share a Document <br />Compare Document Changes <br />Review a Document <br />Merge Document Changes <br />Review Tracked Changes <br />Coauthor Documents
27	Adding Reference Marks and Notes	Add Captions <br />Add Cross-References <br />Add Bookmarks <br />Add Hyperlinks <br />Insert Footnotes and Endnotes <br />Add Citations and a Bibliography
28	Simplifying and Managing Long Documents	Add Captions <br />Add Cross-References <br />Add Bookmarks <br />Add Hyperlinks <br />Insert Footnotes and Endnotes <br />Add Citations and a Bibliography
29	Securing a Document	Suppress Information <br />Set Formatting and Editing Restrictions <br />Add a Digital Signature to a Document <br />Restrict Document Access
30	Forms	Create Forms <br />Manipulate Forms
31	Getting Started with Outlook 2016	Navigate the Outlook Interface <br />Perform Basic Email Functions <br />Use Outlook Help
32	Composing Messages	Create an Email Message <br />Check Spelling and Grammar <br />Format Message Content <br />Attach Files and Items <br />Enhance an Email Message <br />Manage Automatic Message Content
33	Reading and Responding to Messages	Customize Reading Options <br />Work with Attachments <br />Manage Your Message Responses
34	Managing Your Messages	Manage Messages Using Tags, Flags, and Commands <br />Organize Messages Using Folders
35	Managing Your Calendar	View the Calendar <br />Manage Appointments <br />Manage Meetings <br />Print Your Calendar
36	Managing Your Contacts	Create and Update Contacts <br />View and Organize Contacts
37	Working with Tasks and Notes	Manage Tasks <br />Manage Notes
38	Customizing the Outlook Environment	Customize the Outlook Interface <br />Create and Manage Quick Steps
39	Configure Advanced Message Options	Insert Advanced Characters and Objects <br />Modify Message Settings, Properties, and Options <br />Use Automatic Replies
40	Advanced Message Management	Sort Messages <br />Filter Messages <br />Organize Messages <br />Search Messages <br />Manage Junk Mail <br />Manage Your Mailbox
41	Advanced Calendar Management	Manage Advanced Calendar Options <br />Create Calendar Groups <br />Manage Meeting Responses<br />
42	Advanced Contact Management	Edit an Electronic Business Card <br />Manage Advanced Contacts Options <br />Forward Contacts <br />Export Contacts
43	Managing Activities by Using Tasks and Journal Entries	Assign and Manage Tasks <br />Record and Modify Journal Entries
44	Sharing Workspaces with Others	Delegate Access to Mail Folders <br />Share Your Calendar <br />Share Your Contacts
45	Managing Outlook Data Files	Back Up Outlook Items <br />Change Data File Settings
46	Getting Started with Microsoft Office Excel 2013	Navigate the Excel User Interface<br />Use Excel Commands<br />Create and Save a Basic Workbook<br />Enter Cell Data<br />Use Excel Help
47	Performing Calculations	Create Worksheet Formulas <br />Insert Functions <br />Reuse Formulas
48	Modifying a Worksheet	Insert, Delete, and Adjust Cells, Columns, and Rows <br />Search for and Replace Data <br />Use Proofing and Research Tools
49	Formatting a Worksheet	Modify Fonts <br />Add Borders and Colors to Worksheets<br />Apply Number Formats<br />Align Cell Contents <br />Apply Styles and Themes<br />Apply Basic Conditional Formatting <br />Create and Use Templates
50	Printing Workbooks	Preview and Print a Workbook<br />Define the Page Layout
51	Managing Workbooks	Manage Worksheets <br />Manage Workbook and Worksheet Views<br />Manage Workbook Properties
52	Customizing the Excel Environment	Configure Excel Options <br />Customize the Ribbon and the Quick Access Toolbar <br />Enable Excel Add-Ins
53	Creating Advanced Formulas	Use Range Names in Formulas<br />Use Specialized Functions <br />Use Array Formulas
54	Analyzing Data with Functions and Conditional Formatting	Analyze Data by Using Text and Logical Functions <br />Apply Advanced Conditional Formatting
55	Organizing and Analyzing Datasets and Tables	Create and Modify Tables<br />Sort Data<br />Filter Data<br />Use SUBTOTAL and Database Functions
56	Visualizing Data with Basic Charts	Create Charts <br />Modify and Format Charts
57	Analyzing Data With Pivotables, Slicers, and Pivotcharts	Create a PivotTable <br />Analyze PivotTable Data <br />Present Data with PivotCharts <br />Filter Data by Using Slicers
58	Working with Multiple Worksheets and Workbooks Simultaneously	Use 3-D References<br />Use Links and External References<br />Consolidate Data
59	Sharing and Protecting Workbooks	Collaborate on a Workbook<br />Protect Worksheets and Workbooks
60	Automating Wrokbook Functionality	Apply Data Validation <br />Work with Forms and Controls <br />Work with Macros
61	Applying Conditional Logic	Use Lookup Functions<br />Combine Functions<br />Use Formulas and Functions to Apply Conditional Formatting
62	Auditing Worksheets	Trace Cells <br />Search for Invalid Data and Formulas with Errors Watch and Evaluate Formulas
63	Using Automated Analysis Tools	Determine Potential Outcomes Using Data Tables <br />Determine Potential Outcomes Using Scenarios <br />Use the Goal Seek Feature <br />Activate and Use the Solver Tool <br />Analyze Data with Analysis ToolPak Tools
64	Presenting Your Data Visually	Use Advanced Chart Features <br />Create Sparklines
65	Getting Started with PowerPoint	Navigate the PowerPoint Environment <br />Create and Save a PowerPoint Presentation <br />Use Help
66	Developing a PowerPoint Presentation	Select a Presentation Type <br />View and Navigate a Presentation <br />Edit Text <br />Build a Presentation
67	Performing Advance Text Editing	Format Characters <br />Format Paragraphs <br />ToFormat Text Boxes
68	Adding Graphical Elements to your Presentation	Insert Clip Art and Images <br />Insert Shapes
69	Modifying Objects in your Presentation	Edit Objects <br />Format Objects <br />Group Objects <br />Arrange Objects <br />Animate Objects
70	Adding Tables to your Presentation	Create a Table <br />Format a Table <br />Insert a Table from Other Microsoft Office Applications
71	Adding Charts to your Presentation	Create a Chart <br />Format a Chart <br />Insert a Chart from Microsoft Excel
72	Preparing to Deliver Your Presentation	Review Your Presentation <br />Apply Transitions <br />Print Your Presentation <br />Deliver Your Presentation
73	Modifying the PowerPoint Environment	Customize the User Interface <br />Set PowerPoint 2016 Options
74	Customizing Design Templates	Modify Slide Masters and Slide Layouts <br />Add Headers and Footers <br />Modify the Notes Master and the Handout Master
75	Adding Smartart to a Presentation	Create SmartArt <br />Modify SmartArt
76	Working with Media and Animations	Add Audio to a Presentation <br />Add Video to a Presentation <br />Customize Animations and Transitions
77	Collaborating on a Presentation	Review a Presentation <br />Store and Share Presentations on the Web
78	Customizing a Slide Show	Annotate a Presentation <br />Set Up a Slide Show <br />Create a Custom Slide Show <br />Add Hyperlinks and Action Buttons <br />Record a Presentation
79	Securing and Distributing a Presentation	Secure a Presentation <br />Broadcast a Slide Show <br />Create a Video or a CD