home menu courses menu schedule menu register  menu contact menu extras menu

Microsoft Excel Course

1-800-716-4324

Sacramento Area


Class Info for:

$350 for one full day, 9am-4pm
Held at AcademyX
180 Promenade Circle Suite 110 (map)
Sacramento Area
Sign up for:  
May 30 | Jun 26 | Jul 11

Microsoft Excel Advanced - Sacramento

This Excel training course continues where the Excel Intermediate class left off and delves into the use of pivot tables, vlookup/hlookup, macros and more.

Working with Advanced Functions

  • Working with Functions
  • Using the IF Function
  • Nesting Functions
  • Using Multiple Conditions with the IF Function
  • Using Table Lookup Functions
  • Using Text Functions
  • Using One-Input Data Tables
  • Using Two-Input Data Tables

Analyzing Data

  • Using Automatic
  • Outlining Consolidating Information by Position or Category
  • Inserting Subtotals
  • Creating an Advanced Filter
  • Using Database Functions

Using PivotTables

  • Understanding PivotTables
  • Using the PivotTable and PivotChart Wizard
  • Laying out a PivotTable on a Worksheet
  • Modifying PivotTable Fields
  • Working with Page Fields
  • Refreshing a PivotTable

Enhancing PivotTables

  • Formatting a PivotTable
  • Working with Summary Functions
  • Sorting Items in a PivotTable
  • Grouping Data
  • Using AutoShow in a PivotTable
  • Creating a Calculated Field
  • Creating a Calculated Item
  • Creating Charts from PivotTables

Working with Data Analysis Tools

  • Creating Scenarios
  • Working with Scenarios
  • Using Goal Seek
  • Understanding Solver
  • Defining a Problem
  • Solving a Problem
  • Generating a Report of Results and Alternate Solutions

Working with Macros

  • Recording a Macro
  • Executing a Macro
  • Creating a Macro Button
  • Working with Macro Buttons

Using Special Features

  • Importing and Exporting Data
  • Working with Hypertext Links

Prerequisites:

  • A solid understanding of Windows’ file management, the concepts of right-clicking and selecting object properties
  • Successful completion of Excel Intermediate class or equivalent experience providing a basic understanding of worksheets, cell formatting, and formulas.

Related MS Office Classes in Sacramento:

Newsletter subscribers can win $100 credit!

academyX
180 Promenade Circle Suite 110
Sacramento, CA 95834
916-333-5710 tel
415-392-0743 fax

Home | Course Catalog | Schedule | About Us | Contact Us | Extras | Sitemap | Package Rates | Shopcart