Excel Classes

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
  • 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
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
© Copyright Computer Training Center
© Copyright excel classes
 
 

For class dates, pricing or to register for a class please call

(310) 358-9648
 
 
   
 
  Hands-on In-person Classes at Our Location
   
  Microsoft Office Classes:
       
    Microsoft Excel Microsoft Word
       
    Microsoft PowerPoint Microsoft Outlook
       
    Microsoft Windows Microsoft Access
       
    Office Packages Office Certification
   
  Accounting Classes:
       
    QuickBooks  
       
    Accounting Packages and Diploma
       
  Graphic Design Classes:
       
    Adobe Photoshop Adobe Illustrator
       
    Adobe InDesign Packages
       
  Website Design Classes:
       
    WordPress HTML, Javascript
       
    Adobe Dreamweaver E-commerce, PHP
       
    Website Packages Adobe Flash
       
  Computer Repair Classes:
   
A+ Certification (Computer Repair Tech.) 
   
  Video Classes:
       
    After Effects Premiere
       
    Maya 3D Animation  
       
  Basic Classes:
   
Microsoft Windows Internet & Email
   
Typing Classes Apple Mac
   
Typing Test & Certificate
   
   
like us

 

  To register please call (310) 358-9648
     
  In-Person Classes Our Location
     
  Online Live Classes About Us
     
  Private Training Reviews
   
  On-Site Training
   
  Computer (Testing) Lab for Rent