Call now 310.358.9648 IN-PERSON Classes ONLINE 1-on-1 Classes Private Training Location Reviews
 

ONLINE 1-On-1 , Live, Interactive, 100% Hands-on Microsoft Excel Classes, at Your Home or Office

 

Learn in the comfort of your home or office

This is a live, interactive and instructor-led 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.

Throughout the course, the instructor gives you the opportunity to practice on your computer and ask as many questions as you wish through the microphone.

 

 

 
   
Course Level
Introduction Microsoft Excel - One Day
Intermediate Microsoft Excel - One Day
Advanced Microsoft Excel - One Day
For more information please click here  
 

Lunch break?

Yes, there is a one hour lunch break from 12:00 pm to 12:45 pm. (Pacific Time). There are also 10 minute breaks about every 1.5 hours.
Are these classes live and interactive?
Yes, Absolutely. We believe that iinteractive training is the most effective way of learning. These classes are online, with a live teacher who you can talk to and ask questions as you would do in an in-person classroom.

What do you need for the online class?

1. The application (for example Excel or QuickBooks) that you are learning has to be installed on your computer.

2. High speed Internet access.

3. Headphone or speaker and microphone.

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

For class dates, prices or to register for a class please call (310) 358-9648

         
  In-person Hands-on Classes (at our location) Our Location Microsoft Excel Classes  
  Online Hands-on Classes Classroom or Lab for Rent Intuit QuickBooks Classes  
  Private Training (Our Location, Yours or Online) Jobs Microsoft Word Classes  
  On-Site Training Typing Test Certificate Microsoft Outlook Classes  
      Microsoft PowerPoint Classes  
         
 

We serve the following areas:

Alhambra, Altadena, Anaheim, Arcadia, Artesia, Baldwin Park, Bell, Bell Gardens, Bellflower, Beverly Hills, Brandeis, Brea, Buena Park, Burbank, Calabasas, Canoga Park, Carson, Cerritos, Chatsworth, City Of Industry, Compton, Culver City, Cypress, Downey, Duarte, El Monte, El Segundo, Encino, Fountain Valley, Fullerton, Garden Grove, Gardena, Glendale, Granada Hills, Hacienda Heights, Harbor City, Hawaiian Gardens, Hawthorne, Hermosa Beach, Huntington Beach, Huntington Park, Inglewood, Irvine, La Canada Flintridge, La Crescenta, La Habra, La Mirada, La Palma, La Puente, Lakewood, Lawndale, Lomita, Long Beach, Los Alamitos, 822 S. Robertson Blvd., Los Angeles, CA 90035, Lynwood, Malibu, Manhattan Beach, Marina Del Rey, Maywood, Midway City, Mission Hills, Monrovia, Montebello, Monterey Park, Montrose, Mount Wilson, North Hills, North Hollywood, Northridge, Norwalk, Oak Park, Pacific Palisades, Pacoima, Palos Verdes Peninsula, Panorama City, Paramount, Pasadena, Pico Rivera, Playa Del Rey, Pomona, Porter Ranch, Rancho Palos Verdes, Redondo Beach, Reseda, Rosemead, Rowland Heights, San Fernando, San Gabriel, San Marino, San Pedro, Santa Fe Springs, Santa Monica, Seal Beach, Sherman Oaks, Sierra Madre, Signal Hill, South El Monte, South Gate, South Pasadena, Stanton, Studio City, Sun Valley, Sunland, Sunset Beach, Surfside, Sylmar, Tarzana, Temple City, Toluca Lake, Topanga, Torrance, Tujunga, Universal City, Valencia, Valley Village, Van Nuys, Venice, Verdugo City, West Covina, West Hills, West Hollywood, Westminster, Whittier, Wilmington, Winnetka, Woodland Hills