Microsoft Office Legacy

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
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 & 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 Enviroment	Topic A: Customize the Start Screen <br />Topic B: Customize the Desktop
6	Installing & 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 & 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 Document	Customize the Word Interface <br />Additional Save Options
17	Working with Tables & 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 & 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 & 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 2013	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 & 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 & Notes	Manage Tasks <br />Manage Notes
38	Customizing the Outlook Enviroment	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
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 Enviroment	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 & 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 Advanced Text Editing	Format Characters <br />Format Paragraphs <br />To Format 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 Enviroment	Customize the User Interface <br />Set PowerPoint 2013 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 & 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 & Distributing a Presentation	Secure a Presentation <br />Broadcast a Slide Show <br />Create a Video or a CD