Microsoft® Office Excel® 2013
Course content:
Level 1 (1 day)
Getting Started with Excel 2013
Identify the Elements of the Excel Interface
Create a Basic Worksheet
Use the Help System
Performing Calculations
Create Formulas in a Worksheet
Insert Functions in a Worksheet
Reuse Formulas
Modifying a Worksheet
Manipulate Data
Insert, Manipulate, and Delete Cells, Columns, and Rows
Search for and Replace Data
Spell Check a Worksheet
Formatting a Worksheet
Modify Fonts
Add Borders and Color to Cells
Apply Number Formats
Align Cell Contents
Apply Cell Styles
Printing Workbook Contents
Define the Basic Page Layout for a Workbook
Refine the Page Layout and Apply Print Options
Managing Large Workbooks
Format Worksheet Tabs
Manage Worksheets
Manage the View of Worksheets and Workbooks
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
Level 2 (1 day)
Creating Advanced Formulas
Apply Range Names
Use Specialized Functions
Analyzing Data with Logical and Lookup Functions
Leverage Questions and Testing to Write Formulas
Use Logical and Lookup Functions to Find Answers to Questions
Organizing Worksheet Data with Tables
Create and Modify Tables
Sort and Filter Data
Use Summary and Database Functions to Calculate Data
Visualizing Data with Charts
Create Charts
Modify and Format Charts
Create a Trendline
Create Advanced Charts
Analyzing Data with PivotTables, Slicers, and PivotCharts
Create a PivotTable
Filter Data by Using Slicers
Analyze Data by Using PivotCharts
Inserting Graphics
Insert and Modify Graphic Objects
Layer and Group Graphic Objects
Incorporate SmartArt
Enhancing Workbooks
Customize Workbooks
Manage Themes
Create and Use Templates
Protect Files
Level 3 (1 day)
Automating Worksheet Functionality
Update Workbook Properties
Create and Edit a Macro
Apply Conditional Formatting
Add Data Validation Criteria
Auditing Worksheets
Trace Cells
Troubleshoot Invalid Data and Formula Errors
Watch and Evaluate Formulas
Create a Data List Outline
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
Working with Multiple Workbooks
Consolidate Data
Link Cells in Different Workbooks
Merge Workbooks
Exporting Excel Data
Export Excel Data
Import a Delimited Text File
Integrate Excel Data with the Web
Create a Web Query