Skip to main content

Free Excel Tutorial | Learn Excel in an Hour

Excel in an Hour

Taught by Claudia Buckley

Get a comprehensive overview of Excel features, functions, and data tools — fast. No prior knowledge needed. Learn Excel essentials after completing this structured 1-hour tutorial.

Get started
  • Get an accredited certificate

Learn Excel in an Hour

The GoSkills Excel in an Hour course is a free online tutorial designed to help complete beginners crush everyday Excel tasks with ease.

This crash course for beginners covers the most common formulas, functions, and tools to boost your Excel skills and confidence.

The downloadable practice worksheets make it easy to learn Excel fast and apply new knowledge to real-world scenarios. Each step comes with a short quiz, so you can be confident you’ve mastered the skills you’ve learned.

This is one of the few free online Excel courses with a certificate included after completion!

What’s included:

  • 16 easy-to-digest Excel tutorial videos
  • Basic Excel formulas, charts, and shortcuts
  • Downloadable exercise files and reference guides
  • Unlimited quiz and test attempts
  • Certificate of completion 

Learn how to:

  • Understand the difference between formulas and functions.
  • Calculate and simplify data with functions like AVERAGE, SUM, COUNTIF and TODAY.
  • Apply cell formatting that makes data visually appealing.
  • Use dynamic conditional formatting to make critical information stand out. 
  • Manage workbooks, including how to rename, add, delete, move, and copy sheets.
  • Group, sort, and filter to quickly organize your data.
  • Easily transform numerical data into visual charts and graphs. 

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 Excel course.

Once you've mastered these foundational skills, continue your journey with our most popular Excel course for professionals.

Syllabus

6 sections · 16 lessons · 1h 14m total

Download syllabus

Getting Started 2 lessons · 4m

  1. 1. Get Ready to Excel Understand why you need to know how to use Excel. 1m View lesson
  2. 2. The Basics Introduction to the Ribbon, worksheets, and understanding cell contents and cell referencing. 3m View lesson

  1. 1. Formulas vs Functions What is the difference between a formula and a function? What's the structure of each? 7m View lesson
  2. 2. Formulas & Functions in Action Determining when it's best to use formulas vs. functions. Learn how to copy and paste formulas and functions. 3m View lesson
  3. 3. Using Functions to Simplify Data Solve common problems using essential functions. 6m View lesson

  1. 1. Cell Formatting Resize rows/columns, adjusting fonts, colors & alignment. 4m View lesson
  2. 2. Number Formats Change number formats to/from: date, currency/general. 3m View lesson
  3. 3. Conditional Formatting Format cells dynamically based on criteria which you define. 4m View lesson

  1. 1. Worksheet Management Edit worksheet by adding and removing rows and columns. 3m View lesson
  2. 2. Workbook Management Renaming, adding, deleting, moving and copying sheets. 3m View lesson
  3. 3. Sorting & Filtering Organize your data using sorts and filters. 4m View lesson

  1. 1. Creating Charts Make data more visually appealing by choosing from a variety of chart types. 4m View lesson
  2. 2. Formatting Charts Learn how to create title and various options for your chart, adjust data source and change chart type. 7m View lesson

  1. 1. Putting it all Together Change the way your worksheet appears onscreen. Customize the way data appears when printed. 5m View lesson
  2. 2. Excel Hacks & Tricks Useful shortcuts and tips for working with Excel sheets 6m View lesson
  3. 3. Excel Hacks & Tricks Part 2 Useful shortcuts and tips for working with Excel sheets 3m View lesson

Time to humblebrag

Complete the course and pass the final test to get a verifiable CPD-accredited certificate

Share on LinkedIn

Add your certificate to your profile in one click, and let recruiters and managers see your new skills.

  • CPD accredited
  • Verifiable online
Sample GoSkills certificate of completion

Taught by Claudia Buckley

Claudia Buckley is a corporate trainer who has spent over 20 years professionally training others. 

She is a Subject Matter Expert in the aviation industry,  specializing in technical and soft skills areas such as Microsoft Office, workforce management, customer service, sales, as well as industry-specific courses. She is a certified Microsoft Excel Expert.

Read more

The reviews are in

See what other learners think of our courses

4.7
Based on 4,516 learner reviews
See all reviews
  • “I never had a use for excel until now that I see what it is utilized for. I hope I will be able to use this program a lot more in the future. ”
  • “The course is a great way to learn how to use Excel!”
  • “Course was easy to follow and information was retained by taking the short quizzes after each category!”
Chris Sanchez, GoSkills learner
I got the promotion largely because of the skills I could develop, thanks to the GoSkills courses I took. I set aside at least 30 minutes daily to invest in myself and my professional growth.
Chris Sanchez GoSkills learner

Your questions, answered

Frequently asked questions

We’ve compiled the most important information to help you get the most out of your experience. Can’t find what you’re looking for? Contact us.

Does my membership include other courses?

Yes. A GoSkills plan gives access to the full course library, not just this course.

You sure can. As a learner, you can sign up for a 7-day free trial here. If you’re training your organization, you can also start with a free plan here.

Your dashboard shows which lessons you’ve completed and how far you are through each course, so you always know where to pick up next.

Yep! With a business account, you can access the full course library along with the GoSkills LMS where you can assign courses, track team progress and report on results from one dashboard. Learn more about GoSkills for teams here.

Our support team is available at support@goskills.com for questions about your account or the platform. Reach out anytime!