Excel Courses online

Introduction to Excel

This course covers everything to get you started in Excel.
The course is about 3 hours in length. The course includes videos and exercises. The cost WAS $39 Now $29. You have 30 days to complete the course.
  • Explore the screen
  • Name box - how to move with the name box
  • Name ranges
  • Sheets - add sheets
  • Change order - rename sheets
  • Moving around the sheet
  • Fill handle - creating a series
  • Auto Sum
  • Create a basic formula
  • Absolute reference
  • Average
  • Max
  • Minimum
  • Inserting columns and rows
  • Copy the entire sheet
  • Linking data from two sheets
  • Select and move a group of cells
  • Wrap text
  • Insert function
  • Conditional formatting
  • Inserting tables
  • Creating charts

Click here to Access: Introduction to Excel course

 

Intermediate Excel - Learning More

This course will teach you to become more powerful in Excel
The course is about 4 hours in length. The course includes videos and exercises. The cost was $49.Now $39 You have 30 days to complete the course.

Organizing Data

  • Advanced filter
  • Sort by multiple columns
  • Subtotal function
  • Create an automatic form
  • Working with large sheets of data

Special Features

  • Custom Auto Fill
  • Data validation
  • Indirect function
  • Related drop down lists
  • Using the And Symbol

Manipulating Data

  • Vlookup
  • Vlookup with iferror
  • If functions, nested if's

More Manipulating Data

  • If with and
  • If with not and Or
  • Index/match
  • Create pivot table

Click here to Access: Intermediate Excel -Learning More course

We Can Help you with your Software Needs

Excel Consulting

We are here to help you with:
Macro creation, let's automate your sheets
Forms and templates
Difficult formulas and applications

Excel Training

We train from the to 2 students
From your location or online