Training Microsoft Excel (Customized)

Lesson 1: Getting Started with Microsoft® Excel® 2013

• Identify the Elements of the Excel Interface
• Create a Basic Worksheet
• Use the Help System

Lesson 2: Performing Calculations

• Create Formulas in a Worksheet
• Insert Functions in a Worksheet
• Reuse Formulas

Lesson 3: Modifying a Worksheet

• Manipulate Data
• Insert, Manipulate, and Delete Cells, Columns, and Rows
• Search for and Replace Data
• Spell Check a Worksheet

Lesson 4: Formatting a Worksheet

• Modify Fonts
• Add Borders and Color to Cells
• Apply Number Formats
• Align Cell Contents
• Apply Cell Styles

Lesson 5: Printing Workbook Contents

• Define the Basic Page Layout for a Workbook
• Refine the Page Layout and Apply Print Options

Lesson 6: Managing Large Workbooks

• Format Worksheet Tabs
• Manage Worksheets
• Manage the View of Worksheets and Workbooks

Lesson 7: Customizing the Excel Environment

• Customize General and Language Options
• Customize Formula Options
• Customize Proofing and Save Options
• Customize the Ribbon and Quick Access Toolbar
• Customize the Functionality of Excel by
• Enabling Add-Ins
• Customize Advanced and Trust Center Options

Lesson 8: Creating Advanced Formulas

• Apply Range Names
• Use Specialized Functions

Lesson 9: Analyzing Data with Logical and Lookup Functions

• Leverage Questions and Testing to Write Formulas
• Use Logical and Lookup Functions to Find Answers to Questions

Lesson 10: Organizing Worksheet Data with Tables

• Create and Modify Tables
• Sort and Filter Data
• Use Summary and Database Functions to Calculate Data

Lesson 11: Visualizing Data with Charts

• Create Charts
• Modify and Format Charts
• Create a Trendline
• Create Advanced Charts

Lesson 12: Analyzing Data with PivotTables, Slicers, and PivotCharts

• Create a PivotTable
• Filter Data by Using Slicers
• Analyze Data by Using PivotCharts

Lesson 13: Inserting Graphics

• Insert and Modify Graphic Objects
• Layer and Group Graphic Objects
• Incorporate SmartArt

Lesson 14: Enhancing Workbooks

• Customize Workbooks
• Manage Themes
• Create and Use Templates
• Protect Files

Lesson 15: Automating Worksheet Functionality

• Update Workbook Properties
• Create and Edit a Macro
• Apply Conditional Formatting
• Add Data Validation Criteria

Lesson 16: Auditing Worksheets

• Trace Cells
• Troubleshoot Invalid Data and Formula Errors
• Watch and Evaluate Formulas
• Create a Data List Outline

Lesson 17: Analyzing and Presenting Data

• Create Sparklines
• Create Scenarios
• Perform a What-If Analysis
• Perform a Statistical Analysis with the Analysis ToolPak
• Create Interactive Data with Power View

Lesson 18: Working with Multiple Workbooks

• Consolidate Data
• Link Cells in Different Workbooks
• Merge Workbooks

Lesson 19: Exporting Excel Data

• Export Excel Data
• Import a Delimited Text File
• Integrate Excel Data with the Web
• Create a Web Query