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.
Free Excel Tutorial | Learn Excel in an Hour
Excel in an Hour
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.
- 4.7 4,516 reviews
- 1h 15m study time
- 1h 14m video
- 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
Formulas and Functions
- 1. Formulas vs Functions What is the difference between a formula and a function? What's the structure of each? 7m View lesson
- 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. Using Functions to Simplify Data Solve common problems using essential functions. 6m View lesson
Data Appearance & Formatting
- 1. Cell Formatting Resize rows/columns, adjusting fonts, colors & alignment. 4m View lesson
- 2. Number Formats Change number formats to/from: date, currency/general. 3m View lesson
- 3. Conditional Formatting Format cells dynamically based on criteria which you define. 4m View lesson
Organizing Data
- 1. Worksheet Management Edit worksheet by adding and removing rows and columns. 3m View lesson
- 2. Workbook Management Renaming, adding, deleting, moving and copying sheets. 3m View lesson
- 3. Sorting & Filtering Organize your data using sorts and filters. 4m View lesson
Presenting Data
- 1. Creating Charts Make data more visually appealing by choosing from a variety of chart types. 4m View lesson
- 2. Formatting Charts Learn how to create title and various options for your chart, adjust data source and change chart type. 7m View lesson
The Wrap Up
- 1. Putting it all Together Change the way your worksheet appears onscreen. Customize the way data appears when printed. 5m View lesson
- 2. Excel Hacks & Tricks Useful shortcuts and tips for working with Excel sheets 6m View lesson
- 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
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.
The reviews are in
See what other learners think of our courses
-
“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!”
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.
How do I track my progress?
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.
Can I use GoSkills for team training?
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.
What if I need help?
Our support team is available at support@goskills.com for questions about your account or the platform. Reach out anytime!