Excel 100 Intro to Excel

Free Excel Course for Beginners

If you are just getting started on your Excel journey, this course is for you!

In this course, you'll learn practical skills you can use immediately as well as principles to keep in mind as you use Excel.

The course includes lesson videos and handouts. You can download the Excel files and work along.

 

Course Overview

In this short overview video, we discuss the learning objectives and get a preview of the lessons.

Learning Objectives

  • Overall structure and organization of Excel
  • Excel terminology
  • Practical hands-on skills
  • Principles and good habits
  • 3 keys unlock the door to Excel

Note: the video controls enable you to play in full-screen, adjust playback speed and quality, and turn captions on or off. 

Lesson 1

Lecture notes

This lesson covers the following items:

  • Key #1
  • Terms
  • Workbook & Worksheet
  • Range & Cells
  • Stored values
  • Displayed values

Lesson 2

Lecture Notes

This lesson covers the following items:

  • Key #2
  • Terms
  • Calculated values
  • Functions
  • Operators
  • References

Lesson 3

Lecture Notes

This lesson covers the following items:

  • Key #3
  • Ribbon
  • Tabs
  • Commands
  • AutoSum
  • Format Painter

Lesson 4

Lecture Notes

This lesson covers the following items:

  • Final project
  • Put it all together
  • Practical example
  • Restaurant check
  • Review of 3 Keys
  • What's next

What's Next?

The next step is to accumulate additional Excel skills.

There are many sources for learning Excel. Excel University offers formal paid training options and a bunch of free resources to help.

After completing Excel 100, you are prepared and ready to start our Undergraduate lessons ... which are available in our Courses and a Campus Pass.

Campus Pass

Subscription (Most Popular)

A Campus Pass provides access to our entire catalog of undergraduate and masters lessons. It includes live Office Hours with Q&A and full access to the Student Union. Extreme gamification ensures this is the most fun you can have learning Excel.

Courses

Continuing Education (CPE)

Courses provide an online, on-demand, interactive learning experience. Watch the lecture videos, complete the hands-on exercises, pass the exam, and earn certifications. Excel University is a NASBA CPE sponsor and our courses are offered for CPE credit.

Free Resources

Articles & More

We offer tons of free resources.

The Passport takes you on an Excel Highlights tour, can you track your progress as you go.

We also offer blog posts, articles, webinars, and more.