Excel classes in San Diego near me

San Diego Excel Training Classes

Computers Etc Software Training Center, Inc.

Here are course descriptions of our most popular Excel classes.

Beginning Excel

This Beginning Excel class covers the basics.

Intermediate Excel

This Intermediate Excel Class takes your skills to the next level.

Advanced Excel

This Advanced Excel class helps you become an Excel Ninja.

What is Microsoft Excel?


Microsoft Excel is a spreadsheet program first introduced in 1987, and it's the most popular course we teach. We break it down into Beginning, Intermediate, and Advanced levels. Each course is a full-day class which meets from 9AM to 4PM. We also offer half-day Excel classes, focusing on formulas, charts, and Pivot Tables. You’re sure to find a class that meets your needs.

Excel is best known for “crunching” numbers, but it can also be used for text-based data. Our classes emphasize the numeric side of Excel, but we also cover text management, which includes sorting, filtering, and separating and combining text data.

Excel Course Descriptions (Detailed)


Excel Beginning Class (Full-Day) Click for Details
Create basic formulas and functions. Create a variety of spreadsheets and charts. Work with large spreadsheets and add headers/footers. Lots of tips and shortcuts. Hands-on!
 
Excel Intermediate Class (Full-Day) Click for Details
Create more complex formulas, apply multiple filters and sorts, limit user input, make values stand out, and use Pivot Tables. Hands-on!
 
Excel Advanced Class (Full-Day) Click for Details
Learn how to use 30 of the most popular Excel Functions. Use What If Tools such as Scenarios, Data Tables, Goal Seek and Solver. Create simple macros. Hands-on!
 

Beginning Excel Class


In our Beginning Excel class, we cover the basics: setting up a spreadsheet, formatting it, adding basic formulas and functions, creating charts, managing large spreadsheets, and printing the results. Learn “best practices” for laying out and organizing your data. The right start makes a big difference. Next, we’ll show you how to use formatting effectively, to get your point across.

We spend a great deal of time on formulas, the calculations that form the backbone of Microsoft Excel. We’ teach you how to add, subtract, multiply, divide, and calculate percentages. You’ll also learn how to save time by filling – or copying – formulas and functions.

Managing large spreadsheets can be challenging, so we like to include that in our Beginning Excel class. Learn a few handy tips and tricks for navigating and spreadsheet and selecting – or highlighting – content. Headers and Footers will also be covered in class.

Finally, we show you how to get the best printed results by centering your spreadsheet, making fill out the page, and adding headers and footers. By the end of this course, you’ll have the necessary skills to create a wide variety of spreadsheets and charts. If that isn’t enough, we also offer Intermediate and Advanced Excel training.

 

Intermediate Excel Class


In our Intermediate class, we take you to the next level, showing you how to create more complex formulas, using the Order of Operations, 3D formulas, Linking, Consolidation, and other intermediate-level Excel skills. Then, we explain how to use the Formula Auditing feature, which allows you to view, evaluate, and troubleshoot formulas.

We cover Conditional Formatting, which uses color to highlight important values in a spreadsheet. If you’ve seen a spreadsheet where the negative numbers automatically turn red, then you know how valuable this feature can be.

Learn how to do multiple sorts, filters, and sub-totals. Group and outline data to reduce the clutter in a spreasheet. Add Validation Rules to limit what users can enter into your spreadsheet. We also cover Pivot Tables and Pivot Charts, which allow you to summarize and analyze large spreadsheets. We go in depth so you'll come away with a solid foundation in Pivot Tables.

 

Advanced Excel Class


In our Advanced Excel class, we cover many of the most important functions, including IF, Ifs, VLookup, HLookup, XLookup, SumIf, and Concatenate. In all, we explore 30+ essential functions every Excel user should know.

We also cover simple Recorded Macros (no VBA), What If Tools like Scenarios, Goal Seek, and Solver, along with Worksheet Controls such as Spin Buttons, Scroll Bars, and Check Boxes.