Skip to content
QBO Videos

Excel in 3 Hours Flat Course


Course
Alicia Pollock

Learn Excel, Microsoft Office’s spreadsheet software. In this Excel tutorial for beginners we’ll create formulas & functions, add charts, formatting, and print.

Course Description

Crunching numbers in a spreadsheet is only daunting until you know what you’re doing. Our class teaches you the essentials of not just beginning-level Excel, but some of the more advanced features that are essential to working with your numbers.

 

If you’re self-taught, you’re guaranteed to fill in your gaps with cool tips and tricks.

Instructional Level

Beginner through Intermediate

Course Length

3 hours

Prerequisites

None.

Who should take this class?

  • Business owners and employees looking to analyze data for business decisions
  • Students and job-seekers looking to boost their employment marketability.
  • Beginners who want to start from scratch
  • Advanced students looking to fill in gaps in their knowledge. Since we specialize in what you “don’t know that you don’t know,” even seasoned users are guaranteed to glean essential nuggets of information to make using Excel easier than before.

What should you bring?

A laptop computer with Excel loaded (any version is fine).

What You’ll Learn

  • Moving around in a spreadsheet
  • Entering data
  • AutoFill Handle
  • Formulas and Functions
  • Relative and Absolute Cell References
  • Formatting
  • Charts
  • Sparklines
  • Printing
  • Conditional Formatting
  • Plus, you’ll learn valuable tips and tricks to shave time off your daily tasks.

Here is the course outline:

1. Download the Course Files

Download the handouts and files that go with the videos.

Download the agenda
Answer Key
Data List

2. Watch the Video: How Can I Learn Excel in 3 Hours Flat?

We’re going to learn Excel in 3 Hours Flat. You didn’t think that’s possible? Well, it is, and here’s how!

Intro Video

3. Watch the Videos: Entering Data

Start from scratch to build your first spreadsheet.

Exploring the Interface
Building Your First Spreadsheet

4. Watch the Videos: Performing Calculations

Now you are ready to add in formulas and functions!

Formulas and Functions
Absolute Cell References

5. Watch the Videos: Formatting: Making it Look Good

After you have all your data in place, use colors and borders to help the user understand your information at a glance.

Cell and Text Formatting
Conditional Formatting

6. Watch the Videos: Charts

Because a picture is worth a thousand data points.

Sparklines
Column and Pie Charts

7. Watch the Videos: Data and Pivot Tables

Lists of info can be sorted, filtered, and turned into Pivot tables to tell different stories about your data.

Data Tables
Pivot Tables
Tracing Dependencies

8. Watch the Video: Printing

Take control of what your spreadsheet looks like on paper.

Printing Your Handiwork

9. Take the Quizzes

Take this quiz to demonstrate your mastery of the material. Pass the quiz with an 80% or higher to complete earn a Certificate to show your boss!

Did You Learn Excel in 3 Hours Flat? Completion requirement
Submit your finished Excel files for approval. Completion requirement

Completion

The following certificates are awarded when the course is completed:

Royalwise Credit Certificate
Back to top