In-Person Classes
Location
Online 1-on-1 Classes
Reviews

Online 1-on-1 Live Excel Classes

Study in the comfort of your home or office.

This is a live instructor lead class. You can actually see the instructor on your screen and follow him/her as he/she teaches. You can hear him through your speakers or headphones. Then, you can practice on your computer and ask as many questions as you wish through the microphone.

What do I need for the online class?

High speed Internet access.
Please call to register for Online Live Interactive classes.
Course Level  
Introduction Microsoft Excel  
Intermediate Microsoft Excel  
Advanced Microsoft Excel  
 

Times:

9:00 am to 1:00 pm.

1:30 pm to 5:30 pm

6:00 pm to 10:00 pm

Breaks:

There is a 20 minute break afer every 2 hours

What do I learn in the class?

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
    and more. . . . .

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
  • and more . . . . .

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
  • and more . . . . . .
 
What people say about our classes:
     
"The outline of the course was easy to follow and fluid to make learning easy".
Stephanie M. 		  "Easy to understand. Great practice after each new skill".
Christine M.
     
"A friend referred them. Great class. Teacher has good knowledge & explained things well. I would definitely take another course".
Judy S.		   "The class was very helpful and easy to understand. The instructors are very knowledgeable and friendly. All around a great experience".
Christopher M.
     
"First time I finally "got" this program after years of trying (off and on) to learn on my own."
B. D. 		  "Very understandable, patient, and well taught, plus they give you practice tests that help you improve what you have been taught. Over all I learned what I had to learn from the class."
D.H.
     
"It was very helpful and liked the fact it was all hands-on."
M. R.		   "Very Thorough & detailed. I appreciate the level of detail with my questions & most importantly, the patience. Will definitely return. Thank you."
J. C.
 

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

(310) 729-1766
 
 
   
 
  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 Website Packages
       
  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 Our Desktop Website