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 create custom forms. We write VBA Macro's and when you are not able to do the required work in Excel, contact us and we would love to discuss your needs

Technical Writing

We can create online help, software manuals and documentation for your custom software.

Excel Training

We can train both online and in person.  We offer effective training.

Course Development

We can develop training courses for your custom software.

We Create Custom Videos

We can create custom videos for you Excel or Custom software needs. Why not create a training video and be able to use it whenever the need arises.


easyexcelanswers@gmail.com
Phone 780 499 6658