San Diego Excel Training Classes

What is Microsoft Excel?

Microsoft Excel is a spreadsheet program first introduced in 1987 and it's best known for “crunching” numbers, although it can also be used for working with 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.

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.

Detailed Course Description of Beginning Excel Class

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.

Detailed Course Description of Intermediate Excel Class

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.

Detailed Course Description of Intermediate Excel Class






Computer Training Classes in San Diego