Excel Training Courses Seattle - Beginner to Advanced

Excel Training Course Material

Excel 2010 Training Level 1

Outline for Excel 2010 Beginner / Fundamentals

Introduction with Excel

• Excel UserInterface
• Navigation of Cells in Worksheets
• Customize the Excel Interface

 Data Calculations

• Create Formulas
• Using Functions
• Edit a Worksheet
• Managing Data
• Find and Replace Data

Formatting Options

• Apply Font Properties
• Borders and Colors
• Align Content in a Cell
• Apply Number Formatting
• Apply Cell Styles

Manage Worksheets

• View Worksheets and Workbooks
• Printing Workbooks
• Define the Page Layout

Excel 2010 Training Level 2

Outline for Excel 2010 Intermediate

Advanced Formulas

• Range Names
• Multiple Worksheet Calculations
• Specialized Functions
• Logical and Lookup Functions

Tables and Database features

• Create Structured Tables
• Advanced Filter Data Options
• Sorting and Auto Filters
• Functions to Calculate Data

Charts

• Create and Format Charts

PivotTables and PivotCharts

• Designing a PivotTable Report
• Slicers to Filter Data
• Data Analysis with PivotCharts

Using Graphic Objects

• Pictures, ClipArt, Shapes
• SmartArt to Illustrate Workflow

Excel 2010 Training Level 3

Streamlining Workflow

• Workbook Properties
• Record a Macro
• Edit a Macro
• Conditional Formatting
• Data Validation

Collaborating with Other Users

• Protect Files
• Share a Workbook
• Set Revision Tracking

Troubleshoot Data Errors

• Trace and Evaluate Formulas

Analyzing Data

• Trendlines, Sparklines
• Building Scenarios
• What-If Analysis
• Statistical Analysis

Using Multiple Workbooks

• Creating a Workspace
• Consolidate Data
• Link Different Workbooks

Importing and Exporting Data

• Export Excel Data
• Import Text Files
• Publishing a Worksheet to the Web
• Import Data from the Web
• Create a Web Query

See What People Say About Our Trainers

Testimonials