|
|
|
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). |
|
|
|
What makes us #1 in Microsoft Excel training classes |
- Certificate for each level completed
- Serving the community since 1989
- 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.
- 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
|
|
Course Levels |
|
There are a total of 3 levels in Microsoft Excel course: Introduction, Intermediate and Advanced.
Each level can be taken in either 1 full day or 2 half days as shown below: |
Level 1:
Introduction - 8 Hours
Microsoft Excel
1 full day
(or 2 half days) |
Levels 1 & 2:
Introduction & Intermediate - 16 Hours
Microsoft Excel
2 full days (or 4 half days) |
Levels 1, 2 & 3:
Complete course - 24 Hours
Introduction, Intermediate & Advanced
Microsoft Excel
3 full days (or 6 half days) |
Level 2:
Intermediate - 8 Hours
Microsoft Excel
1 full day (or 2 half days) |
Level 3:
Advanced - 8 Hours
Microsoft Excel
1 full day (or 2 half days) |
Levels 2 & 3:
Intermediate & Advanced - 16 Hours
Microsoft Excel
2 full days (or 4 half days) |
|
Class Hours |
|
Classes available every week. |
Please call for availability of space. |
Choose from the following times: |
|
|
Full day (Mon, Wed and/or Sat) |
|
9:00 am to 5:30 pm |
|
|
Morning (Mon, Wed and/or Sat) |
|
9:00 am to 1:00 pm |
|
Afternoon (Mon, Wed and/or Sat) |
|
1:30 pm to 5:30 pm |
|
|
Evening (Tue) |
6:30 pm to 9:30 pm |
|
|
Saturday |
9:00 am to 1:00 pm |
|
|
Saturday |
1:30 pm to 5:30 pm |
|
Saturday |
9:00 am to 5:30 pm |
|
|
Call or click |
(310) 358-9648 |
for pricing or to register |
|
|
Syllabus |
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
|
|
|
|
|