Microsoft Excel Classes

100% Hands-on, Live, In-person, Computer Training Classes in Microsoft Excel at our location in Los Angeles, Southern California

Are you looking for a class that is 100% hands-on, small class, high quality of training and great prices, then you are in the right place.

Questions & Answers (Q&A)

What is Microsoft Excel?

It is an electronic spreadsheet program that is used for creating any kind of document where numbers and calculations are involved. You can use Microsoft Excel to create lists, budgets and financial statements.

Is the class hands-on?

Yes. The Microsoft Excel class is 100% hand-on. Classes are small with one teacher for every eight students.

Is there a teacher in class?

Yes. The teachers are in the same classroom as you. They explain the material and are available to answer all of your questions throughout the sessions.

Mac or PC?

Both. You can choose to learn Microsoft Excel on Apple Mac, MacBook or P.C. (Microsoft Windows).

• Certificate for each level completed

• Serving the community since 1989

• 100% Hands-on classes

• One computer per person

• Flexible Schedule

• Knowledgeable & Patient Instructors

• Discount on multiple classes

• Guaranteed Learning: We are so confident that you will love our classes that we offer a guarantee. If after 1 hour and before 1½ hours is up, you do not LOVE the class, you can cancel the class and get a full refund.

• Very good prices

• Small student to teacher ratio for maximum attention

• Day time, Evening and Saturday classes

• Professionally prepared workbook for use in class and for your future reference

Levels 1, 2 & 3:
Complete course
Introduction, Intermediate & Advanced
Microsoft Excel
3 full days  (or 6 half days)

Level 2:
Intermediate
Microsoft Excel
1 full day  (or 2 half days)

Levels 2 & 3:
Intermediate & Advanced
Microsoft Excel
2 full days  (or 4 half days)

Level 1 - Introduction

• Creating Worksheets
• Moving Around in a Worksheet using shortcut keys
• Aligning Data in the Worksheet
• Erase Part of Worksheet
• Entering Formulas in the Cells
• Addition, Subtraction, Multiplication And Division
• Automatic Summation
• Center Across Many Columns
• Borders And Shading
• Gridlines
• Making Changes In The Worksheet
• Changing Column Width
• Inserting & Deleting Rows & Columns
• Moving & Copying Ranges
• Copying Formulas
• Formatting numbers for commas, dollar sign, decimal places, etc.
• Fonts
• Headers and Footers
• Freezing And Un-Freezing Headings
• Margins
• Landscape and Portrait
• Multiple Worksheets

Level 2 - Intermediate

• Naming Worksheets
• Linking Worksheet Data
• Creating Different Types of Charts, Column, Line, Pie and so on.
• Labeling Charts, Adding Legends
• Formatting Charts
• Adding Arrows and Text to a Chart
• Embedding a Chart in A Worksheet
• Creating and Using Templates
• Creating a Database
• Sorting and Alphabetizing
• Searching a Database
• Automatic Record Numbering
• Finding Records in a Database
• Hiding and Un-Hiding Columns
• Create and Run Macros
• Edit Macros
• Create and Apply Filters

Level 3 - Advanced

• Transpose
• Autoformat, Page Break
• Add and Edit Comments
• Loan Payment Function
• If Statement
• Defined Names, Circular Reference
• Average function
• Absolute Cell Addresses
• Password Protect Files
• Symbols
• Create, Edit, Apply Style
• Pivot Tables
• Index, Match, Sumproduct Functions
• Vlookup and Lookup
• Protecting Cell Data
• Dropdown Menu
• Sumif Function
• .... and more