Excel Training
in San Diego or Online

Learn Excel formulas, functions, charts and more with hands-on training. We offer varied levels of fundamental Excel training as well as advanced Excel training and VBA. AcademyX's Excel classes can be taken in-person at our San Diego classroom facility, or online with a live instructor. Training focuses on practical application of Excel in a business environment, sprinkled with useful tips & tricks and best practices.

 

Excel Intro

Learn Excel basics: create, format, and edit spreadsheets, create charts and graphs, calculating with formulas and common functions, and more.

  • Applying formulas such as autosum
  • Formatting spreadsheets for visual effects and numeric formats
  • Sorting and filtering data
  • Inserting graphics and SmartArt diagrams
  • Working with large spreadsheets
  • Designating and controlling print areas
  • Basic functions such as average, max, min, sum
  • Extrapolating a pattern to autofill cells for dates or incremental counters
  • Transposing data (switching columns and rows)
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


 

Excel Intermediate

Learn Excel features that are most commonly used in business. Work with advanced formulas, linked workbooks, and Pivot Tables.

  • Applying proper formula syntax of special characters
  • Working with different types of math operators and understanding the Order of Operations
  • Using 3D formulasto combine data from different worksheets with the same workbook or file
  • Linking cells from different workbooks and getting the latest information with automtic updates
  • Consolidating data from different worksheets and workbooks
  • Using Validation to improve the speed and accuracy of data entry
  • Adding drop-down lists and pop-up explanantion boxes
  • Creating and working with Pivot Tables
  • Auditing formulas to discover and resolve errors
  • Creating and editing workbook wemplates
  • Using Conditional Formatting to make important numbers stand out
  • Password protecting all or part of a workbook
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


 

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




Microsoft Excel Training Reviews:

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

I didn't think I could learn that much from the intro class. Turned out I was wrong. A lot of stuff I didn't know about Excel, even in the intro class.
- Dean Scurries, Equinix

Very informative class and learned a lot about the basics of Excel. Pace wasn't too fast or slow so we were able to cover a lot of material but I was able to keep up. Learned a tremendous amount.
- Matthew Fields, Student

Amazing! The instructor was so helpful. Attentive to all the students different needs and learning styles. Really appreciate her detailed to attention and clear explanation and logic reasoning behind all the concepts.
- Sarah Horng, Carndinal Health

Excellent Class! Best trainer I've ever had, explained how to use excel which will help me at the office. Will recommend this class to my co-workers.
- Christopher Morales, State of California

Great. Really great teaching style. Very creative and free form, but thorough and detailed. I can't wait to turn in my first budget using the formulas and formatting I learned in this class. And this was only the Introduction!
- Aminta Steinbach, Be The Change Consulting

I thoroughly enjoyed the class. Trainer explained instructions in a way that everyone was able to follow along and understand. I really liked the idea of the hands on experience with access to a computer and being to actually work within the program. Also to be able to see exactly what the instructor was doing on her screen and not having to look up to the front of the class was very helpful and most efficient. Overall the class was educational and great.
- Jamie Kong

She was great. She taught us tips and tricks that I personally think that it will help my daily work easy since my new job requires a lot of Excel. She answers everyone's questions and very lively in class. In other words she was very entertaining that makes the learning experience easy.
- Nicole Pacheco, California Council of the Blind

I enjoyed it very much. Very informational and she kept things lively
- Angie Land, Marshall Medical

► More reviews...