Microsoft® Office Excel® 2010
Course content:
Level 1
Lesson 1: Getting Started with Excel
Identify the Elements of the Excel Interface
Navigate and Select Cells in Worksheets
Customize the Excel Interface
Create a Basic Worksheet
Lesson 2: Performing Calculations in an Excel Worksheet
Create Formulas in a Worksheet
Insert Functions in a Worksheet
Reuse Formulas
Lesson 3: Modifying a Worksheet
Edit Worksheet Data
Find and Replace Data
Manipulate Worksheet Elements
Lesson 4: Modifying the Appearance of a Worksheet
Apply Font Properties
Add Borders and Colors to Cells
Align Content in a Cell
Apply Number Formatting
Apply Cell Styles
Lesson 5: Managing an Excel Workbook
Manage Worksheets
View Worksheets and Workbooks
Lesson 6: Printing Excel Workbooks
Define the Page Layout
Print a Workbook
Level 2
Lesson 1: Calculating Data with Advanced Formulas
Apply Cell and Range Names
Calculate Data Across Worksheets
Use Specialized Functions
Analyze Data with Logical and Lookup Functions
Lesson 2: Organizing Worksheet and Table Data
Create and Modify Tables
Format Tables
Sort or Filter Data
Use Functions to Calculate Data
Lesson 3: Presenting Data Using Charts
Create a Chart
Modify Charts
Format Charts
Lesson 4: Analyzing Data Using PivotTables, Slicers, and Pivot Charts
Create a PivotTable Report
Filter Data Using Slicers
Analyze Data Using PivotCharts
Lesson 5: Inserting Graphic Objects
Insert and Modify Pictures and ClipArt
Draw and Modify Shapes
Illustrate Workflow Using SmartArt Graphics
Layer and Group Graphic Objects
Lesson 6: Customizing and Enhancing the Excel Environment
Customize the Excel Environment
Customize Workbooks
Manage Themes
Create and Use Templates
Level 3
Lesson 1: Streamlining Workflow
Update Workbook Properties
Create a Macro
Edit a Macro
Apply Conditional Formatting
Add Data Validation Criteria
Lesson 2: Collaborating with Other Users
Protect Files
Share a Workbook
Set Revision Tracking
Review Tracked Revisions
Merge Workbooks
Administer Digital Signatures
Restrict Document Access
Lesson 3: Auditing Worksheets
Trace Cells
Troubleshoot Invalid Data and Formula Errors
Watch and Evaluate Formulas
Create a Data List Outline
Lesson 4: Analyzing Data
Create a Trendline
Create Sparklines
Create Scenarios
Perform a What-If Analysis
Perform a Statistical Analysis with the Analysis ToolPak
Lesson 5: Working with Multiple Workbooks
Create a Workspace
Consolidate Data
Link Cells in Different Workbooks
Edit Links
Lesson 6: Importing and Exporting Data
Export Excel Data
Import a Delimited Text File
Lesson 7: Integrating Excel Data with the Web
Publish a Worksheet to the Web
Import Data from the Web
Create a Web Query
Lesson 8: Structuring Workbooks with XML
Develop XML Maps
Import and Export XML Data
Level 4
Lesson 1: Manipulating Data Using Statistical and Lookup Functions
Forecast GDP Using Statistical Functions
Evaluate Sales Data Using Statistical Functions
Analyze Stock Data Using Statistical Functions
Mine Data Using the Lookup and Reference Functions
Lesson 2: Analyzing Data Using Data Analysis Tools
Analyze Sales Data Using Descriptive Statistics
Analyze Time Series Data Using Exponential Smoothing
Analyze Data Using Regression
Identify the Beta Value of a Security
Analyze Sector Data Using Correlation and Covariance Matrices
Optimize a Stock Portfolio Using Solver
Lesson 3: Working with Data Using Financial Functions
Develop an Investment Schedule Using Financial Functions
Make Investment Decisions Using Financial Functions
Lesson 4: Examining Data Using Math Functions
Analyze Sales Data Using Math Functions
Calculate Stock Returns Using Math Functions
Aggregate GDP Data Using Math Functions
Lesson 5: Manipulating Data Using Text and Information Functions
Manipulate Data Using Text Functions
Validate Data Using Information Functions
Lesson 6: Working with Templates and Charts
Create Advanced Templates
Create Advanced Charts
Lesson 7: Managing Data in Workbooks
Retrieve and Paste Data
Clean Data in Workbooks