Excel Training Courses Seattle - Beginner to Advanced

Microsoft Excel Training Courses - Fundamental to Advanced

Spam Email Protection

Microsoft Excel 2010 training courses in Seattle for individuals and groups.  This is an instructor-led course on Excel 2010 at your office. 

We can help your team unlock the most practical ways to use Excel to be more effective in their daily tasks, guaranteed.  Make an investment in your people to gain additional skills and it will quickly pay off in increased corporate productivity.

Tailored courseware. We can customize the curriculum specifically for your business needs.  We have an experienced Excel expert trainer who can come directly to you and teach your employees anywhere in the greater Seattle area.  We are a local Seattle Excel training team focused on corporate training.


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