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.

 

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 4            9am - 4pm  day - register
        Dec 18           6am - 1pm  day - register


 

Excel Lookups, Functions and Macros

Learn the more advanced functions of Excel typically needed for complex spreadsheets with multiple dependences, conditional logic, and user interactivity.

  • Logical Functions: IF(), AND/OR() and NOT()
  • Decision-making Functions: COUNTIF() and SUMIF()
  • Looking up Values: INDEX() and MATCH() versus VLOOKUP()
  • Auditing, Tracing and Error-Trapping
  • Array Formulas for Processing Data Groups
  • Date and Time Functions
  • Text Manipulation Functions
  • Statistical and Forecast Functions
  • PowerPivot for Processing Data from External Connections
  • Cube Functions
  • What-If Analysis: Watches, Scnearios, Goal Seek, and the Analysis ToolPak
  • Macros And VBA
  • Designing Forms with Buttons for User Interactivity
  • Internationalization And Accessibility
  • and much more! See full outline for Excel Lookups, Functions, and Macros training
REGISTER:
Price:  $350 for 6 hours.
In-Person Training:
        No classes scheduled. Get a quote for private training.
Online Live Training:
        Dec 6            9am - 4pm  day - register
        Dec 20           6am - 1pm  day - register




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...