Excel Training
in San Jose or Online

Hands on training with Excel formulas, functions, charts and more. We offer incremental levels of basic Excel courses as well as advanced Excel training in topics such as Pivot Tables and VBA. Our custom Excel training can be in-person at our San Jose learning center, or online with a live instructor. Focusing on practical application of Excel in a business context, sprinkled with useful tips & tricks and best practices, these classes are ideal for working professionals as well as those who are looking to get started in their careers.

 

Excel Intro

Learn to quickly get around the user interface, create and edit spreadsheets, work with formulas and common functions, present data with beautifully formatted charts and graphs.

  • Navigate Excel's "ribbon" menu interface
  • Create a spreadsheet to organize data
  • Format fonts, colors, styles and themes
  • Perform basic calculations between cells
  • Correctly reference cells so formulas still work when you insert rows
  • Apply functions like AVERAGE(), MIN(), MAX(), and SUM()
  • Designate print areas, page breaks, headers and footers
  • Create and format bar and pie charts
  • Generate instances of built-in Excel templates
  • and much more! See the full outline for Excel Intro training.
REGISTER:
Price:  $290 for 6 hours.
In-Person Training:
        No classes scheduled. Get a quote for private training.
Online Live Training:
        Dec 19           9am - 4pm  day - register
        Jan 5            9am - 3pm  day - register
        Feb 23           9am - 3pm  day - register
        Apr 10           9am - 3pm  day - register
► More dates


 

Excel Intermediate

Analyze large amounts of data, extract actional information, validate data, create dynamic PivotTables and PivotCharts.

  • Managing Workbooks: Names, colors, and inter-linking between them
  • Customizing the Ribbon and Quick Access toolbar
  • Creating Meaningful "Named Ranges" and "Defined Names"
  • Sorting and Filtering Data Tables
  • Removing Duplicates
  • Structured References
  • Data Validation, including Dropdown Lists
  • Summarizing Data with Consolidation and Subtotals
  • PivotTables and PivotCharts
  • Conditional Formatting
  • Custom Formats
  • Adding Trendlines and Sparklines
  • Using Quick Analysis Gallery
  • Collaboration: Permissions, Sharing, and Protection
  • and much more! See full outline for Excel Intermediate training
REGISTER:
Price:  $290 for 6 hours.
In-Person Training:
        No classes scheduled. Get a quote for private training.
Online Live Training:
        Dec 22           9am - 4pm  day - register
        Jan 15           9am - 3pm  day - register
        Mar 4            9am - 3pm  day - register
        Apr 20           9am - 3pm  day - register
► More dates


 

Excel Advanced

Training focusing on the ecosystem of most-often used advanced Excel features typically found in complex spreadsheets with multiple dependencies, conditional logic and user interactivity.

  • Creating and Applying Names In A Worksheet
  • VLOOKUP and XLOOKUP Functions
  • ROUND and IFERROR Functions
  • Using the Formula Auditing Tools
  • Summary Functions: SUMIF(S), COUNTIF(S), AVERAGEIF(S)
  • Text Functions: LEFT, RIGHT, MID()
  • CONCAT and Text-To-Columns Feature
  • Data Consolidation and Goal Seek Tools
  • Using the Solver and Scenario Manager
  • Recording and Running Macros
  • Editing Macros with the Visual Basic Editor
  • Adding Buttons to Run Macros From the Ribbon
  • See full outline for Excel Advanced Course
REGISTER:
Price:  $290 for 6 hours.
In-Person Training:
        No classes scheduled. Get a quote for private training.
Online Live Training:
        Dec 29           9am - 4pm  day - register
        Jan 23           9am - 3pm  day - register
        Mar 10           9am - 3pm  day - register
        Apr 27           9am - 3pm  day - register
► More dates




Microsoft Excel Training Reviews:

stars icon
Rated 4.9/5 based on 18353 student reviews.

Extremely helpful in understanding how to navigate work sheets and create formulas.
- Allyson Landers, Serious Energy, Sunnyvale

EXCELLENT!! The instructor was easy going, patient and very good at teaching a class with varying levels of experience.
- Betsy Leff, Alpha Fund, Fremont/Granite Bay

Very Good. Good pace and enthusiasm.
- Brian Burk, Oxford X-Ray, Scotts Valley, CA

Very good. Instructor was very patient. I am deaf and at times confusing, she was kind and made sure I understood.
- Carol Cirigliano, Perceptimed, Palo Alto

This was very good and learned a lot more then I knew before!
- Christine Carson Seals, Santa Clara County Parks, San Jose

The instructor is great teacher and I have learned so much in this class.
- Corrina Somera, CBRE

The training was very good and the course well taught.
- Ed Hiheta, Autodesk, San Francisco

The training was very informative and useful.
- Eric Rynhard, United Site Services

► More reviews...