Excel Training in Los Angeles

Learn Excel formulas, functions, charts and more. We offer different levels of basic Excel training and advanced Excel training in topics such as Pivot Tables and VBA. Excel classes can be taken in-person at our Los Angeles facility, or online with a live instructor. The curriculums focus on practical application of Excel in a business context, sprinkled with useful tips & tricks and best practices.




 

Excel Intro

Learn Excel basics: navigating the interface, creating spreadsheets, working with formulas and functions, presenting data with charts and graphs.

  • Spreadsheet basic concepts
  • Navigating the Excel interface
  • Creating new files and opening existing ones
  • Entering and editing data
  • Modifying rows and columns within worksheets
  • Defining formulas referencing specific cells
  • Absolute vs. relative references
  • Using common functions
  • Changing the look of the text, cells, and layout
  • How to print and share the Excel workbook
  • Basic charts
  • Using templates and other settings
Price:  $350 for 6.5 hours.
Dates:
        Mar 4          9am - 4:30pm  day - register
        Mar 25         9am - 4:30pm  day - register
        Apr 13         9am - 4:30pm  day - register
        Apr 28         9am - 4:30pm  day - register


 

Excel Intermediate

In this Excel course, you will be working with the features most commonly used in business. Before taking this class you should be comfortable creating spreadsheets with formulas using cell references, such as those used in expense reports, financial statements, or sales data.

  • Defining formulas that link between workbooks
  • Sorting and filtering data
  • Using the conditional formatting functions
  • Grouping and subtotaling data in a table
  • Using conditional formatting to highlight certan cells
  • Inserting graphics into your spreadsheet
  • Creating advanced charts and modifying their look and feel
  • PivotTables and PivotCharts and how to maximize their use
  • Sharing your workbook with other users for simultaneous editing
  • Web features
Price:  $350 for 6.5 hours.
Dates:
        Mar 5          9am - 4:30pm  day - register
        Mar 26         9am - 4:30pm  day - register
        Apr 19         9am - 4:30pm  day - register
        Apr 29         9am - 4:30pm  day - register

 

Excel Lookups, Functions and Macros

This training highlights the most-often used advanced Excel features found in sophisticated spreadsheets with multiple dependencies, conditional logic, and user interactivity.

  • Using IF, SUMIF, and COUNTIF to process data based on rules
  • Using the VLOOKUP, INDEX and MATCH functions to find data in related worksheets
  • Auditing: how to find errors using tracing, IFERROR, and other functions
  • Defining arrays and using array functions to work with groups of data
  • Advanced functions for manipulating dates, times, text
  • Statistical and financial functions
  • Importing external data from the web
  • Scenarios using goal seek, scenario manager and input data tables
  • Using the Analysis Toolpack for correlations and histograms
  • Recording and replaying macros and basic VBA code
  • Creating a form with buttons to add interactivity to your spreadsheet
Price:  $350 for 6.5 hours.
Dates:
        Mar 9          9am - 4:30pm  day - register
        Mar 31         9am - 4:30pm  day - register
        Apr 15         9am - 4:30pm  day - register
        Apr 30         9am - 4:30pm  day - register




Microsoft Excel Training Reviews:

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

It was very well organized and very well presented. I enjoyed the instructor's personality. He brought along additional knowledge and experience to the class as well.
- Kathy Chase, Ohio State University, Los Angeles

Instructor offered many extra tips that were very helpful. Nice guy, polite, knows his subject. He also handed out extra material with shortcuts, etc that I can use as a quick reference.
- Student, Pasadena

I feel it was pretty comprehensive.
- Student, Burbank

Excellent! Learned a lot.
- Stacy Padilla, KMG Chemicals, Hollister

The class moved quickly, at times hard to keep up with. Instructor was very good at going back to explain.
- Leslie, KMG, Hollister

Great! learned a lot of information and new ways to work with excel.
- Lia Bahena, TELACU, Los Angeles

Very helpful and detailed. I liked how the book went over even small steps.
- Isamar Martinez, TELACU, Los Angeles

The training was very educational and useful. It gave me a better understanding of how to use a program I was already using. I learned how to use a lot of tools I did not know how to use before.
- Student, Los Angeles

► More reviews...