How to Learn Excel Online: 21 Free and Paid Resources for Excel Training

Faced pinch an urgent request to brushwood up my spreadsheet skills, I went online and searched for nan champion Excel resources available. I discovered a batch of astonishing options, some free and paid.

Microsoft Excel is simply a versatile spreadsheet exertion that’s useful for information introduction and storage, budgeting, information analysis, task management, reporting, inventory management, and overmuch more.

Whether you’re a marketer, freelancer, entrepreneur, aliases business owner, and nary matter your profession, Microsoft Excel is simply a valuable accomplishment to have.

Today, I’m going to stock immoderate of nan champion ways to study Excel online free of charge, positive immoderate paid options.

Table of Contents

• Learning Excel
• How to Learn Excel With Free Training Resources
• How to Learn Excel With Paid Training Resources

Here are nan things you’ll beryllium learning successful Excel done nan training resources I’ll share:

Below are nan 21 astonishing free and paid Excel resources I discovered. Feel free to bookmark your favorites and return advantage of them truthful you tin activity much efficiently successful Excel.

How to Learn Excel With Free Training Resources

1. GoSkills & HubSpot Academy Excel for Marketers Course

This is 1 of nan champion free Excel resources I recovered retired there.

In this GoSkills and HubSpot Academy free Excel for Marketers course, you tin quickly get up to velocity pinch Excel’s astir communal formulas, functions, and shortcuts. This cosmopolitan people contented tin beryllium applied to immoderate context, including marketing, and is cleanable for those who request a refresher successful Excel fundamentals.

By nan extremity of nan course, you’ll person mastered time-saving hacks to simplify your workflow and summation a shiny certificate of accomplishment for your efforts.

What I like: I emotion that I tin complete this clang people successful conscionable nether 2 hours since it was created for engaged group for illustration marketers, business owners, and different professionals.

2. HubSpot Excel Resources

Since Excel is 1 of nan astir in-demand skills for data-driven marketers — and because we want marketers and others for illustration you to win — we've created immoderate of our ain acquisition contented astir Excel present astatine HubSpot.

From free eBooks, to templates, to video tutorials, we tried to screen a wide scope of Excel-relevant topics.

Here are a fewer of our champion Excel resources:

• Hubspot Academy x GoSkills Excel for Marketers course (free course)
• 50 Hacks to Help You Become an Excel Master (free ebook)
• The Ultimate Guide to Using Microsoft Excel (long-form content)
• 10 Excel Templates to Make Marketing Easier (free templates)
• How to Create a Pivot Table successful Excel: A Step-by-Step Tutorial (video and blog post)
• How to Use Excel Like a Pro: 29 Easy Excel Tips, Tricks & Shortcuts (long-form content)

What I like: I’m excited that I tin prime and take resources successful different formats, for illustration a video tutorial, a blog post, a free eBook, free templates, a free course, and more.

3. Microsoft's Excel for Windows Training

To study a caller application, I’m judge it makes a batch of consciousness to see nan source.

And successful this case, nary 1 knows Excel amended than nan group astatine Microsoft.

In this training, they did a awesome occupation by putting together this assets hub for each Microsoft Office applications and services.

The Excel training has a full bunch of free tutorials that screen nan latest type of Excel, organized into functional learning modules.

Check retired nan training here.

What I like: It’s awesome that nan videos are surgery down into short topics and modules that are practical, straightforward, and easy to understand.

4. The Spreadsheet Page

Unlike astir of nan Excel resources connected this list, nan Spreadsheet Page creates and shares professionally designed Excel templates you tin download astatine nary cost, and customize for personal, business and acquisition purposes.

You tin find templates for to-do lists, invoices, budgets, calendars and more.

The well-organized tract is chock afloat of adjuvant Excel tips, collected by an master named John Walkenbach. Over nan past 30 years, he's written much than 60 Excel books for users of each levels, and astir 300 articles and reviews for magazines for illustration InfoWorld, PC World, and PC/Computing.

At 1 point, he wrote nan monthly spreadsheet file for PC World. In different words, nan man knows his worldly — and he knows really to coming it.

I learned they’ve been astir since 2005, and millions of users astir nan world person downloaded their free templates and workbooks.

They besides person a blog wherever you tin find much Excel tips, resources, tutorials, random observations, and jokes.

Source

What I like: When you download immoderate of their templates, you’ll besides get a useful tutorial connected really to customize nan record for your ain use, truthful you tin study by doing. How cool is that?

5. Contextures

Contextures is simply a spot wherever you tin find hundreds of free Excel resources successful nan shape of training videos, tutorials, a monthly newsletter, and sample workbooks.

This Excel assets has hundreds of downloadable spreadsheets that connection step-by-step instructions for performing information validation, adding filters and conditional formatting to rows and columns, designing charts, creating PivotTables, moving functions and more.

Debra Dalgleish, a Microsoft Excel Most Valuable Professional (MVP) grant recipient, started Contextures successful 2000 and has built hundreds of Excel solutions for clients arsenic a consultant. She sewage her first MVP grant from Microsoft successful 2001, and each azygous twelvemonth since. And successful 2021, she besides sewage her 20-year MVP ring.

Source

What I like: Debra stated intelligibly connected her tract that readers should fto her cognize if there’s a taxable they deliberation she should screen connected Contextures. How bully of her!

6. Chandoo.org

This tract is different awesome assets that tin thief you study Excel astatine nary cost.

Purna “Chandoo” Duggirala, Chandoo.org's founder, says he has 1 goal: “to make you awesome astatine Excel and Power BI.”

He started nan blog successful 2007 and built it arsenic a community, citing values for illustration humility, passion, fun, and simplicity. He besides useful to make it a valuable assets for folks who do not person English arsenic their first language.

Today, nan blog contains hundreds of Excel articles and tutorials. You tin motion up to person play Excel tips done his newsletter, and besides watch Excel training videos connected his YouTube channel.

Source

But it's not each truthful formal. For example, Chandoo erstwhile created a integer Easter ovum hunt for a blog station a while back, which included a downloadable Excel workbook containing 7 hidden pandas. Readers were challenged to find nan pandas utilizing clues, Excel techniques, and moreover “I-Spy” skills.

Source

While nan articles, videos, forums, and different parts of nan tract are free, you tin salary to subordinate 1 of Chandoo's system training programs, for illustration Excel School ($147 - $247), aliases VBA Classes ($97 - $347).

Plus, there's ever nan action to bargain 1 of his books — The VLOOKUP Book aliases Excel Formula Helper Ebook.

What I like: When group ask questions astir Excel formulas, formatting, shortcuts, pivot tables, and truthful connected successful nan forum, anyone tin reply them. But I deliberation it’s awesome that Chandoo goes a measurement further and uses immoderate of these questions to create articles and tutorials.

7. Excel Easy

I recovered Excel Easy to beryllium a broad tutorial for learning Excel. Its learnings are divided into chapters, and these are sorted into nan pursuing sections:

• Introduction
• Basics
• Functions
• Data Analysis
• VBA
• Examples

In each chapter, Excel Easy walks you done what it perceives to beryllium nan fundamentals of Excel, successful nan shape of written guides pinch screenshots to thief you maestro each concept.

At nan extremity of nan tutorial, you person entree to 300 examples showing you really to execute each conception successful existent scenarios. Concepts see basal formulas and functions, really to create a ribbon, creating aggregate worksheets, formatting cells, information validation, array creation, and more.

Source

What I like: With hundreds of examples disposable for learners to believe with, I judge this tin make it easier for beginners to understand and study Excel astatine a faster rate.

8. MrExcel.com

With this free Excel resource, you tin study Excel and besides get successful touch pinch Excel experts to inquire questions aliases make inquiries.

MrExcel.com was launched by Bill Jelen successful 1998m and its declare to fame is its interactive connection board, which is perpetually monitored by its organization of Excel gurus. The committee is organized according to subject, for illustration wide announcements, questions, and MrExcel.com products.

When a personification posts a question, a personnel of nan MrExcel.com master organization will reply pinch an answer. The questions scope from simplifying an Excel task, to solving urgent inquiries.

Not a autochthonal English speaker? You tin ask questions successful your autochthonal language.

Source

What I like: I deliberation it’s awesome that nan tract besides has a room of adjuvant Excel books and ebooks. And if you request thief pinch problems that are much complex, you tin prosecute an Excel advisor straight from nan website, for a fee.

9. Exceljet

Dave Bruns, a Microsoft Excel MVP grant winner, founded Exceljet successful 2012 and runs nan tract pinch his wife. Their extremity is to thief mean group usage Excel faster and much effectively.

I discovered that Exceljet has respective 1000 pages of content, including articles and complete 400 short videos, that let you to itemize your Excel training based connected nan task you're moving on.

Other free resources see nan pursuing and more:

• 500 Excel Formulas
• 350 Excel Functions
• 222 Excel Shortcuts
• Pivot Table Examples
• Excel Tables Guide
• Pivot Table Examples

Source

They besides person respective paid video trainings that return a deeper dive into circumstantial Excel topics of liking to their users and followers.

What I like: With their bite-sized videos, I emotion that I tin watch and believe a accomplishment successful little than 10 minutes. And I tin subscribe to their free email newsletter to subordinate complete 100,000 group who get play Excel tips connected useful formulas.

10. Excel successful an Hour

This clang people is simply a free tutorial from GoSkills, an award-winning acquisition level that’s trusted by much than 8000 organizations worldwide.

To my pleasant surprise, Excel successful an Hour includes:

• 16 easy-to-digest Excel tutorial videos.
• Downloadable workout files and reference guides.
• Unlimited quiz and trial attempts.
• Certificate of completion.

It was designed to thief beginners quickly study nan astir communal formulas, functions, and devices they request to grip mundane Excel tasks pinch ease.

The downloadable believe worksheets besides make it easy to use caller knowledge to real-world scenarios.

Source

What I like: I’m really excited that this free people requires nary anterior knowledge of Excel and I tin get a shiny certificate erstwhile I complete it. Hurray!

11. Trump Excel

To stock his knowledge and thief group study Excel, Sumit Bansal, a Microsoft Excel MVP grant winner, created this Excel tutorial tract successful 2013.

On Trump Excel, I recovered a immense number of free Excel tutorials and videos like:

• 100+ Excel functions pinch examples and videos.
• Excel tips you tin use instantly to boost productivity.
• Excel VBA tips to automate repetitive tasks.
• Excel charting tips.
• Excel dashboards, including elaborate tutorials, examples, and download files.
• Excel templates for each situation.
• Best Excel books to make you an Excel pro.

But that’s not all. There are besides free courses connected topics for illustration Excel Power Query, VBA, Dashboard, and a broad Excel training made up of 12+ hours of basal and precocious videos.

Source

What I like: In summation to nan immense number of free Excel resources available, I emotion nan free 51 Excel tips ebook that I tin download, study astatine my convenience, and support successful my individual library.

12. Introduction to MS Excel

Here’s different elaborate Excel assets you want to consider. It’s a free training from Simplilearn, a world leader successful integer upskilling that offers world-class training to individuals and businesses worldwide.

In this free Excel course, you’ll bask 7 hours of self-paced video lessons and study basal spreadsheet features, positive really to automate activities, analyse data, create reports, and usage Excel for real-world tasks.

It’s awesome for beginners and each those who person ne'er utilized Excel before.

Source

What I like: I’m excited that this people was designed for beginners nary matter their inheritance aliases profession. And I emotion that I tin get a shareable certificate erstwhile I complete nan course.

13. Microsoft Excel – Improve Your Skills Quickly

I recovered this free Excel assets connected Udemy, a leader successful online learning that’s trusted by complete 16,000 companies and millions of learners astir nan world.

The people instructor, Phillip Burton, has been school connected Udemy since 2015 and has complete 800,000 students truthful acold — positive complete 40 video courses. Here’s everything you’re going to study successful this free tutorial:

• Learn much astir formatting, filters, and conditional formatting to amended nan position of your spreadsheets pinch a fewer clicks.
• Create tables, Pivot Tables, Charts, Pivot Charts and Sparklines.
• Find retired really powerful Visual Basic for Applications (VBA) is and automate your code.
• Learn functions specified arsenic SUM, SUMIF, VLOOKUP, OFFSET and INDIRECT.

Source

What I like: It’s awesome that this people was designed for group who want to create their Microsoft Excel skills successful a mates of hours, including each those utilizing older versions of Excel, who want to study newer versions. The believe activities included present besides thief learners summation hands-on experience.

How to Learn Excel With Paid Training Resources

14. GoSkills

GoSkills offers a scope of Excel certification courses for each accomplishment levels. Their astir celebrated people is Excel - Basic & Advanced, which teaches basal real-world skills you’ll request for mundane use.

This training starts pinch nan basics and pinch each lesson, you tin build your knowledge from beginner to intermediate and past move to precocious lessons.

By nan extremity of this course, you will beryllium capable to grip everything from reports and charts to analyzable information study and task management.

Designed to accommodate engaged learners, each lessons are bite-sized (3-7 minutes long) and travel pinch a video tutorial, applicable exercise, short quiz, transcripts, and speedy reference guide.

The award-winning level besides features courses connected business and package skills for illustration Microsoft Office, task management, thin six sigma, productivity, soft skills, finance, development, and design.

Price

• 7 days free trial
• $39 per month, billed monthly
• $20.75 per month, billed yearly

What I like: When you complete this course, you guidelines a chance of getting a highly sought-after Excel certification that’s recognized worldwide.

15. Excel Essentials from Excel Exposure

This is simply a paid Excel assets that tin thief you unlock your soul Excel ninja, flooded your fearfulness of Excel, trim errors successful your Excel documents, automate immoderate tasks, summation confidence, usage Excel faster. and prevention valuable time.

That’s a batch of benefits.

Excel Essentials from Excel Exposure is simply a self-paced online people pinch complete 5 hours of contented that covers Excel basics, up to precocious concepts for illustration Pivot Tables and VLOOKUPs.

The people instructor, Ben Currier, has spent nan past 15 years moving successful finance and accounting successful various industries for illustration existent estate, healthcare, video games, gem jewelry, and more.

Source

Price

• $197 – One-time payment; life access
• $59 per month, billed monthly

What I like: Even though this is simply a paid course, it’s awesome that nan first module is disposable free of charge.

16. Coursera

Partnering pinch 350+ starring universities and companies worldwide, Coursera is simply a world level for online learning and profession development.

The tract offers online classes to anyone, anywhere, connected a wide assortment of topics, ranging from euphony accumulation to Excel to coaching skills, and overmuch more.

Here are immoderate of nan celebrated Excel resources that I found:

• Introduction to Microsoft Excel
• Using Basic Formulas and Functions successful Microsoft Excel
• Excel Skills for Business
• Create Charts and Dashboards Using Microsoft Excel
• Create a Financial Statement Using Microsoft Excel

Source

Like galore real-world classes, each people includes video lectures, interactive quizzes, peer-graded assessments, and nan opportunity to link pinch chap students and instructors.

Once you decorativeness a course, you'll person general nickname on pinch an optional people certificate.

Price

• Learn a azygous taxable aliases skill: $49-$79 per month
• Complete aggregate courses pinch Coursera Plus Monthly: $59 per month, 7-day free trial
• Complete aggregate courses pinch Coursera Plus Yearly: $399 per year, pinch a 14-day money-back guarantee

What I like: I emotion nan various pricing options available, particularly Coursera Plus monthly, that I tin usage to complete aggregate courses wrong 1 aliases 2 months.

17. Udemy's “Microsoft Excel - From Beginner to Expert successful 6 Hours”

If you had six hours to spare, really would you usage them? “Sleep,” “clean nan house,” and “bake something” are immoderate of nan things that travel to mind. But what if you tin go an Excel master successful that magnitude of time?

That's what Udemy promises successful its “Microsoft Excel - From Beginner to Expert successful 6 Hours” course. You will study everything you request to cognize astir Microsoft Excel, from nan fundamentals to nan astir precocious features.

I besides noticed that nan people includes 5 hours of video, an article, 128 downloadable resources, entree connected mobile and TV, closed captions, life entree and a certificate of completion.

Udemy is 1 of nan astir bountiful online learning resources retired there, and their Excel courses are many. In fact, typing “Excel” into nan hunt barroom yields thousands of results, each 1 displaying a prima rating, price, length, and level.

Source

Price: $149.99, presently discounted to $16.99. (Check page for predominant discounts.)

What I like: It’s astonishing that nan people instructor, Todd McLeod, is simply a Microsoft Certified Master Instructor and a assemblage professor pinch 20+ years of acquisition school Microsoft Excel. I get a batch of worth learning from experts who are not only acquainted pinch nan tool, but really to thatch it.

18. Excel Everest

The sanction of this assets whitethorn look intimidating, but you‘d beryllium amazed really convenient nan training is. Excel Everest is an out-of-the-box assets that teaches you Excel while you’re in Excel.

I recovered retired that nan merchandise you bargain downloads an Excel record to your computer, wherever you'll unfastened Excel and prosecute successful walk-throughs of 41 different Excel functions correct from a sample spreadsheet.

Topics covered see conditional formatting, VLOOKUP, floor plan creation, and truthful overmuch more.

This Excel training assets offers hundreds of exercises, on pinch video tutorials embedded straight successful a sample Excel spreadsheet.

By applying these concepts successful Excel arsenic you study them, you‘ll consciousness them instrumentality pinch you agelong aft you complete Excel Everest’s training.

Price: $159

What I like: I deliberation it’s a bully motion that apical companies for illustration Google, Eventbrite, PlayCore, and much spot Excel Everest for their worker Excel training.

Microsoft Online Excel Training - Learn Excel Formulas, Pivot Tables, Macros, VLOOKUP & more...

19. Learn iT!

Learn iT! offers Excel training successful a assortment of formats and breaks each instruction down by module. It's 1 of nan champion solutions for Excel learners who want much than conscionable a video bid aliases a written step-by-step guide.

Here are immoderate of their unfastened Excel trainings:

• Excel Introduction
• Excel Intermediate
• Excel Advanced
• Excel Power User
• Excel Pivot Tables
• Excel Intro to Data Analysis
• Excel VBA

Source

With 28 years of occurrence helping companies and careers grow, Learn iT has upskilled complete 1 cardinal individuals, helped 10,000+ companies upskill their workforce, and besides trained group successful complete 15 countries.

Price

• Excel Introduction, Intermediate, Advanced: $145 - $290
• Excel Power User, Pivot Tables: $145 - $290
• Excel Intro to Data Analysis: $145
• Excel VBA: $995

What I like: I deliberation it’s awesome that you tin return your selected people four different ways: an in-person instructor-led session, unrecorded online pinch classmates, privately successful a custom-made session, aliases a self-paced operation of instructor-led and interactive elearning courses.

20. LinkedIn Learning

In lawsuit you didn’t know, LinkedIn isn't conscionable for master networking. LinkedIn Learning is an online learning level — yes, from LinkedIn — that provides entree to much than 24,000 high-quality on-demand courses.

You tin observe and study various business, technology, and imaginative topics and skills pinch nan thief of taxable matter experts (SMEs) who big their training connected nan LinkedIn Learning platform.

Many of these courses see workout files, assessments, and video transcripts.

When I searched for Microsoft Excel connected LinkedIn Learning, I sewage complete 7,000 results, showing different Excel courses from various SMEs. Here are immoderate of them:

• Excel Essential Training (Microsoft 365)
• Excel: VLOOKUP and XLOOKUP for Beginners
• Excel: Supply Chain Shipping Analysis
• Excel Quick Tips

Check retired LinkedIn Learning for each disposable Excel courses.

Source

Price

• Premium LinkedIn subscriptions supply unlimited entree to LinkedIn Learning.
• Premium LinkedIn subscriptions besides connection a one-month free trial.

What I like: It’s awesome that truthful galore high-quality Excel resources are disposable to take from, depending connected individual needs, preferences, and priorities.

21. eLearnExcel

eLearnExcel is simply a Microsoft Excel eLearning company. It’s besides a merchandise of nan International Academy of Computer Training (IACT) — Ireland’s largest and astir knowledgeable IT Training company.

They connection 8 Excel training courses, and 7 of them supply applicable Excel certifications.

Check retired immoderate of their courses below:

• 15 Time-Saving Excel Tips You’ll Use Everyday
• Understand nan Basics of Excel Step-by-Step
• Discover nan must-know Excel Formulas and Functions
• How to analyse information successful Excel to make amended decisions
• Discover How to Make Beautiful Charts successful Excel

If you complete each 8 courses, quizzes, and nan Excel Master Project, you’ll beryllium awarded nan Excel Master Diploma.

It‘s not a bad point to put connected your resume — aliases connected your business’s website, if aggregate labor enroll successful eLearnExcel's courses arsenic portion of a business subscription.

Price

You tin get each courses pinch immoderate of their rank plans below:

• 14-day free trial
• $24 per month, paid monthly. Cancel anytime!
• $247 for one-year access
• $297 for two-year access
• $999 for life access

What I like: I deliberation it’s beautiful that their courses are not only approved by Microsoft, but are besides utilized by them.

Start Learning Excel Online

Whether you request to brushwood up your Excel skills quickly, aliases you want to study Excel from scratch, I’ve shared nan champion ways to study Excel online free of charge. I besides added immoderate paid resources that are good worthy nan money.

Personally, I can’t hold to dive into my favorites — I’m readying connected taking nan Excel for Marketers people from GoSkills and HubSpot Academy, nan Spreadsheet Page, Exceljet, Contextures, Excel successful an Hour, Trump Excel, and each nan HubSpot Excel resources.

Once you’re ready, commencement pinch 1 aliases much of nan free courses. In nary time, you'll beryllium capable to summation your productivity, grow your knowledge, and instrumentality nan powerfulness of Excel for your projects.

Editor's note: This station was primitively published successful March 2019 and has been updated for comprehensiveness.