Excel in an Hour

#1 Free Excel Tutorial | Learn Excel for Beginners

Testimonials (267 reviews)

Features

Premium video tutorials

Award-winning instructors

Personalized learning

Get certified

Learn at your own pace

Mobile (learn on-the-go)

Unlimited tests and quizzes

Regularly updated content


Overview

Learn Excel in an Hour (best free Excel tutorial)

The GoSkills Excel in an Hour course is a free Excel tutorial for beginners, designed to take you from a complete newbie to being able to crush your everyday Excel tasks with ease.

In this Excel crash course, you will quickly learn the most common formulas, functions, and tools needed to increase your overall knowledge and proficiency with Excel. 

If you’ve ever wanted to learn Excel fast, the downloadable practice worksheets make it easy for you to apply what you learn to real-world scenarios. You'll also test your knowledge at each step with a short quiz, so you can be confident you’ve mastered the skills you’ve learned.

This is one of the only free online Excel courses with certificate included after completion, so you can showcase your skills to your boss, coworkers, and friends.

What you get with this free course:

  • 16 easy to digest Excel tutorial videos
  • Downloadable exercise files and reference guides
  • Unlimited quiz and test attempts
  • Certificate of completion
  • Free access to the GoSkills Excel Office app

In this course, you will learn:

  • How to understand the difference between formulas and functions
  • How to calculate and simplify data with functions like AVERAGE, SUM, COUNTIF and TODAY
  • How to apply cell formatting that makes data visually appealing 
  • How to use dynamic conditional formatting to make critical information stand out 
  • How to manage workbooks, including how to rename, add, delete, move and copy sheets
  • How to group, sort, and filter to quickly organize your data
  • How to easily transform numerical data into visual charts and graphs 
  • How to gain the confidence and skills to go from zero to Excel hero!

Every concept in this course can be used in all versions of Microsoft Excel, and was recorded using Excel 2019/365. No prior knowledge is needed in order to successfully complete this free Excel course.

Excel in an Hour
Focus video player for keyboard shortcuts
Auto
  • 720p
  • 540p
  • 360p
1.00x
  • 0.50x
  • 0.75x
  • 1.00x
  • 1.25x
  • 1.50x
  • 1.75x
  • 2.00x
cc

FAQ

This free course is suitable for anyone who wants to learn Excel essentials. No prior knowledge of Excel is required to get started. If you are new to Excel or if you use Excel regularly but want to improve your skills with time-saving tips and hacks, then this course is for you. If you are already an experienced user, you may prefer our more advanced Excel courses.

Excel is a sought-after skill used in professions across virtually every industry, including accounting, administration, marketing, and sales. Improving your Excel skills will not only help you get your work done faster, but you’ll also get a competitive edge in the job market, with studies showing that proficiency in Excel can lead to better job opportunities and higher salaries.

With the right training, Excel is not hard to learn. Some Excel tutorials and courses are hard to follow, too long, and you don’t know how to practice or what step to take next. This can be frustrating and waste your time. GoSkills’ free Excel in an Hour course will guide you through an expertly-designed syllabus, making it easy to learn Excel. The bite-sized format is proven to increase learning retention, with short video tutorials, exercise files and quizzes for each lesson to cement your knowledge.

Trying to learn advanced Excel skills when you’re a beginner can cause confusion, which can lead to discouragement. While Excel has hundreds of different functions, it’s not difficult to learn if you start with the basics in GoSkills’ free Excel in an Hour course. Once you feel comfortable with the fundamentals, you can move on to more advanced training.

While Excel is too vast to be learned all in one day, it is possible to learn the basics in a relatively short amount of time, especially when you learn in a structured format like an online course. If you’re looking to learn Excel basics fast, GoSkills’ free Excel in an Hour course is one of the quickest ways to learn Excel.

Some free resources to learn Excel are hard to understand, time-consuming, and don’t provide practice materials. While other free courses do not offer much more than video tutorials, the GoSkills Excel in an Hour course is one of the only free courses that offers a certificate of completion, as well as exercise files, quizzes, and reference guides. The course is designed to test your knowledge at each step, so you can be confident you’ve mastered the skills you’ve learned.


Summary

Skill level: Beginner
Certificate: Yes (Excel certification)
Lessons: 16
Pre-requisites: None
Versions supported: 2016, 2019, 2021, 365
Video duration: 1h 15m
Estimated study time: 1h 15m


Syllabus

1

Get Ready to Excel

Understand why you need to know how to use Excel.

Video time: 01m 19s

2

The Basics

Introduction to the Ribbon, worksheets, and understanding cell contents and cell referencing.

Video time: 03m 43s

1

Formulas vs Functions

What is the difference between a formula and a function? What's the structure of each?

Video time: 07m 04s

2

Formulas & Functions in Action

Determining when it's best to use formulas vs. functions. Learn how to copy and paste formulas and functions.

Video time: 03m 36s

3

Using Functions to Simplify Data

Solve common problems using essential functions.

Video time: 06m 18s

1

Cell Formatting

Resize rows/columns, adjusting fonts, colors & alignment.

Video time: 04m 26s

2

Number Formats

Change number formats to/from: date, currency/general.

Video time: 03m 52s

3

Conditional Formatting

Format cells dynamically based on criteria which you define.

Video time: 04m 51s

1

Worksheet Management

Edit worksheet by adding and removing rows and columns. Spellcheck.

Video time: 04m 01s

2

Workbook Management

Renaming, adding, deleting, moving and copying sheets.

Video time: 03m 16s

3

Sorting & Filtering

Organize your data using sorts and filters.

Video time: 04m 53s

1

Creating Charts

Make data more visually appealing by choosing from a variety of chart types.

Video time: 04m 31s

2

Formatting Charts

Learn how to create title and various options for your chart, adjust data source and change chart type.

Video time: 08m 01s

1

Putting it all Together

Change the way your worksheet appears onscreen. Customize the way data appears when printed.

Video time: 05m 14s

2

Excel Hacks & Tricks

Useful shortcuts and tips for working with Excel sheets

Video time: 06m 09s

3

Excel Hacks & Tricks Part 2

Useful shortcuts and tips for working with Excel sheets

Video time: 03m 57s

Download syllabus