Online 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?

1. The application that you are learning should be on your computer.

2. High speed Internet access.

3. Headphones or speakers, microphone, and a printer.

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