Microsoft Office Legacy

E-Learning

Description

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

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.

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

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

Self-Paced

Free

This course includes: :

Full lifetime access

Microsoft Office Legacy

E-Learning

Description

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

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.

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

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

Microsoft Office Legacy

Description

Course Overview

Course Objective

Who Should Attend

Course Agenda

Free

Microsoft Office Legacy

E-Learning

Description

Course Overview

Course Objective

Who Should Attend

Course Agenda

Free