Confronted with an pressing have to brush up my spreadsheet abilities, I went on-line and looked for the very best Excel assets obtainable. I found a number of superb choices, each free and paid.
Microsoft Excel is a flexible spreadsheet utility that’s helpful for knowledge entry and storage, budgeting, knowledge evaluation, mission administration, reporting, stock administration, and rather more.
![Download Now: 50+ Excel Hacks [Free Guide]](https://no-cache.hubspot.com/cta/default/53/067360a3-cf50-4923-b737-86af07177c39.png)
Whether or not you’re a marketer, freelancer, entrepreneur, or enterprise proprietor, and irrespective of your occupation, Microsoft Excel is a helpful talent to have.
Right this moment, I’m going to share among the finest methods to study Excel on-line freed from cost, plus some paid choices.
Desk of Contents
Listed here are the belongings you’ll be studying in Excel via the coaching assets I’ll share:
Studying Excel
Create PivotTables to search out relationships between knowledge.
Enter formulation throughout cells, rows, and columns.
Conduct a VLOOKUP throughout a whole column.
Run accounting features to trace enterprise funds.
Group, ungroup, and reformat rows and columns.
Carry out knowledge validation to regulate the format of cell values.
Use keyboard shortcuts to make fast modifications to cell values.
Create charts out of your spreadsheet knowledge.
Develop histograms of information from the charts you create.
Create dashboards to handle a number of teams of efficiency knowledge.
Add conditional formatting to rows and columns that match sure standards.
Print your Excel spreadsheet for presenting to others.
Under are the 21 superb free and paid Excel assets I found. Be happy to bookmark your favorites and benefit from them so you may work extra effectively in Excel.
The right way to Be taught Excel With Free Coaching Assets
1. GoSkills & HubSpot Academy Excel for Entrepreneurs Course
This is likely one of the finest free Excel assets I discovered there.
On this GoSkills and HubSpot Academy free Excel for Entrepreneurs course, you may rapidly stand up to hurry with Excel’s most typical formulation, features, and shortcuts. This common course content material might be utilized to any context, together with advertising and marketing, and is ideal for individuals who want a refresher in Excel fundamentals.
By the tip of the course, you’ll have mastered time-saving hacks to simplify your workflow and achieve a shiny certificates of accomplishment in your efforts.
What I like: I really like that I can full this crash course in slightly below two hours because it was created for busy folks like entrepreneurs, enterprise house owners, and different professionals.
2. HubSpot Excel Assets
Since Excel is likely one of the most in-demand abilities for data-driven entrepreneurs — and since we would like entrepreneurs and others such as you to succeed — we have created a few of our personal instructional content material about Excel right here at HubSpot.
From free eBooks, to templates, to video tutorials, we tried to cowl a variety of Excel-relevant subjects.
Listed here are just a few of our greatest Excel assets:
What I like: I’m excited that I can decide and select assets in numerous codecs, like a video tutorial, a weblog put up, a free eBook, free templates, a free course, and extra.
3. Microsoft’s Excel for Home windows Coaching
To study a brand new utility, I’m certain it makes a number of sense to contemplate the supply.
And on this case, nobody is aware of Excel higher than the folks at Microsoft.
On this coaching, they did a fantastic job by placing collectively this useful resource hub for all Microsoft Workplace purposes and companies.
The Excel coaching has an entire bunch of free tutorials that cowl the most recent model of Excel, organized into purposeful studying modules.
Try the coaching right here.
What I like: It’s nice that the movies are damaged down into quick subjects and modules which can be sensible, easy, and simple to know.
4. The Spreadsheet Web page
In contrast to a lot of the Excel assets on this record, the Spreadsheet Web page creates and shares professionally designed Excel templates you may obtain for free of charge, and customise for private, enterprise and academic functions.
You will discover templates for to-do lists, invoices, budgets, calendars and extra.
The well-organized website is chock stuffed with useful Excel suggestions, collected by an knowledgeable named John Walkenbach. Over the previous 30 years, he is written greater than 60 Excel books for customers of all ranges, and round 300 articles and critiques for magazines like InfoWorld, PC World, and PC/Computing.
At one level, he wrote the month-to-month spreadsheet column for PC World. In different phrases, the person is aware of his stuff — and he is aware of tips on how to current it.
I realized they’ve been round since 2005, and hundreds of thousands of customers world wide have downloaded their free templates and workbooks.
Additionally they have a weblog the place you could find extra Excel suggestions, assets, tutorials, random observations, and jokes.
Supply
What I like: Whenever you obtain any of their templates, you’ll additionally get a helpful tutorial on tips on how to customise the file in your personal use, so you may study by doing. How cool is that?
5. Contextures
Contextures is a spot the place you could find tons of of free Excel assets within the type of coaching movies, tutorials, a month-to-month publication, and pattern workbooks.
This Excel useful resource has tons of of downloadable spreadsheets that supply step-by-step directions for performing knowledge validation, including filters and conditional formatting to rows and columns, designing charts, creating PivotTables, operating features and extra.
Debra Dalgleish, a Microsoft Excel Most Useful Skilled (MVP) award recipient, began Contextures in 2000 and has constructed tons of of Excel options for shoppers as a guide. She received her first MVP award from Microsoft in 2001, and each single yr since. And in 2021, she additionally received her 20-year MVP ring.
Supply
What I like: Debra acknowledged clearly on her website that readers ought to let her know if there’s a subject they assume she ought to cowl on Contextures. How good of her!
6. Chandoo.org
This website is one other improbable useful resource that may enable you to study Excel for free of charge.
Purna “Chandoo” Duggirala, Chandoo.org’s founder, says he has one objective: “to make you superior at Excel and Energy BI.”
He began the weblog in 2007 and constructed it as a neighborhood, citing values like humility, ardour, enjoyable, and ease. He additionally works to make it a helpful useful resource for people who do not need English as their first language.
Right this moment, the weblog accommodates tons of of Excel articles and tutorials. You’ll be able to signal as much as obtain weekly Excel suggestions via his publication, and likewise watch Excel coaching movies on his YouTube channel.
Supply
However it’s not all so formal. For instance, Chandoo as soon as created a digital Easter egg hunt for a weblog put up some time again, which included a downloadable Excel workbook containing seven hidden pandas. Readers have been challenged to find the pandas utilizing clues, Excel methods, and even “I-Spy” abilities.
Supply
Whereas the articles, movies, boards, and different elements of the positioning are free, you may pay to hitch one among Chandoo’s structured coaching packages, like Excel Faculty ($147 – $247), or VBA Courses ($97 – $347).
Plus, there’s all the time the choice to purchase one among his books — The VLOOKUP E-book or Excel Components Helper E-book.
What I like: When folks ask questions on Excel formulation, formatting, shortcuts, pivot tables, and so forth within the discussion board, anybody can reply them. However I feel it’s fantastic that Chandoo goes a step additional and makes use of a few of these inquiries to create articles and tutorials.
7. Excel Straightforward
I discovered Excel Straightforward to be a complete tutorial for studying Excel. Its learnings are divided into chapters, and these are sorted into the next sections:
Introduction
Fundamentals
Capabilities
Knowledge Evaluation
VBA
Examples
In every chapter, Excel Straightforward walks you thru what it perceives to be the basics of Excel, within the type of written guides with screenshots that will help you grasp every idea.
On the finish of the tutorial, you’ve gotten entry to 300 examples displaying you tips on how to carry out every idea in actual eventualities. Ideas embody fundamental formulation and features, tips on how to create a ribbon, creating a number of worksheets, formatting cells, knowledge validation, desk creation, and extra.
Supply
What I like: With tons of of examples obtainable for learners to follow with, I consider this may make it simpler for novices to know and study Excel at a quicker charge.
8. MrExcel.com
With this free Excel useful resource, you may study Excel and likewise get in contact with Excel specialists to ask questions or make inquiries.
MrExcel.com was launched by Invoice Jelen in 1998m and its declare to fame is its interactive message board, which is continually monitored by its neighborhood of Excel gurus. The board is organized in keeping with topic, like normal bulletins, questions, and MrExcel.com merchandise.
When a consumer posts a query, a member of the MrExcel.com knowledgeable neighborhood will reply with a solution. The questions vary from simplifying an Excel process, to fixing pressing inquiries.
Not a local English speaker? You’ll be able to ask questions in your native language.
Supply
What I like: I feel it’s nice that the positioning additionally has a library of useful Excel books and ebooks. And in case you need assistance with issues which can be extra complicated, you may rent an Excel guide instantly from the web site, for a price.
9. Exceljet
Dave Bruns, a Microsoft Excel MVP award winner, based Exceljet in 2012 and runs the positioning together with his spouse. Their objective is to assist atypical folks use Excel quicker and extra successfully.
I found that Exceljet has a number of thousand pages of content material, together with articles and over 400 quick movies, that let you itemize your Excel coaching primarily based on the mission you are engaged on.
Different free assets embody the next and extra:
500 Excel Formulation
350 Excel Capabilities
222 Excel Shortcuts
Pivot Desk Examples
Excel Tables Information
Pivot Desk Examples
Supply
Additionally they have a number of paid video trainings that take a deeper dive into particular Excel subjects of curiosity to their customers and followers.
What I like: With their bite-sized movies, I really like that I can watch and follow a talent in lower than 10 minutes. And I can subscribe to their free e mail publication to hitch over 100,000 individuals who get weekly Excel tips about helpful formulation.
10. Excel in an Hour
This crash course is a free tutorial from GoSkills, an award-winning training platform that’s trusted by greater than 8000 organizations worldwide.
To my nice shock, Excel in an Hour contains:
16 easy-to-digest Excel tutorial movies.
Downloadable train recordsdata and reference guides.
Limitless quiz and take a look at makes an attempt.
Certificates of completion.
It was designed to assist novices rapidly study the most typical formulation, features, and instruments they should deal with on a regular basis Excel duties with ease.
The downloadable follow worksheets additionally make it straightforward to use new data to real-world eventualities.
Supply
What I like: I’m actually excited that this free course requires no prior data of Excel and I can get a shiny certificates as soon as I full it. Hurray!
11. Trump Excel
To share his data and assist folks study Excel, Sumit Bansal, a Microsoft Excel MVP award winner, created this Excel tutorial website in 2013.
On Trump Excel, I discovered an enormous variety of free Excel tutorials and movies like:
100+ Excel features with examples and movies.
Excel suggestions you may apply immediately to spice up productiveness.
Excel VBA tricks to automate repetitive duties.
Excel charting suggestions.
Excel dashboards, together with detailed tutorials, examples, and obtain recordsdata.
Excel templates for each state of affairs.
Greatest Excel books to make you an Excel professional.
However that’s not all. There are additionally free programs on subjects like Excel Energy Question, VBA, Dashboard, and a complete Excel coaching made up of 12+ hours of fundamental and superior movies.
Supply
What I like: Along with the massive variety of free Excel assets obtainable, I really like the free 51 Excel suggestions e book that I can obtain, research at my comfort, and preserve in my private library.
12. Introduction to MS Excel
Right here’s one other detailed Excel useful resource you wish to contemplate. It’s a free coaching from Simplilearn, a world chief in digital upskilling that gives world-class coaching to people and companies worldwide.
On this free Excel course, you’ll get pleasure from seven hours of self-paced video classes and study important spreadsheet options, plus tips on how to automate actions, analyze knowledge, create reviews, and use Excel for real-world duties.
It’s nice for novices and all those that have by no means used Excel earlier than.
Supply
What I like: I’m excited that this course was designed for novices irrespective of their background or occupation. And I really like that I can get a shareable certificates as soon as I full the course.
13. Microsoft Excel – Enhance Your Abilities Shortly
I discovered this free Excel useful resource on Udemy, a pacesetter in on-line studying that’s trusted by over 16,000 firms and hundreds of thousands of learners world wide.
The course teacher, Phillip Burton, has been educating on Udemy since 2015 and has over 800,000 college students to date — plus over 40 video programs. Right here’s every little thing you’re going to study on this free tutorial:
Be taught extra about formatting, filters, and conditional formatting to enhance the presentation of your spreadsheets with just a few clicks.
Create tables, Pivot Tables, Charts, Pivot Charts and Sparklines.
Learn the way highly effective Visible Primary for Purposes (VBA) is and automate your code.
Be taught features resembling SUM, SUMIF, VLOOKUP, OFFSET and INDIRECT.
Supply
What I like: It’s nice that this course was designed for individuals who wish to develop their Microsoft Excel abilities in a few hours, together with all these utilizing older variations of Excel, who wish to study newer variations. The follow actions included right here additionally assist learners achieve hands-on expertise.
The right way to Be taught Excel With Paid Coaching Assets
14. GoSkills
GoSkills gives a spread of Excel certification programs for all talent ranges. Their hottest course is Excel – Primary & Superior, which teaches important real-world abilities you’ll want for on a regular basis use.
This coaching begins with the fundamentals and with every lesson, you may construct your data from newbie to intermediate after which transfer to superior classes.
By the tip of this course, it is possible for you to to deal with every little thing from reviews and charts to complicated knowledge evaluation and mission administration.
Designed to accommodate busy learners, all classes are bite-sized (3-7 minutes lengthy) and include a video tutorial, sensible train, quick quiz, transcripts, and fast reference information.
The award-winning platform additionally options programs on enterprise and software program abilities like Microsoft Workplace, mission administration, lean six sigma, productiveness, delicate abilities, finance, growth, and design.
Worth
7 days free trial
$39 monthly, billed month-to-month
$20.75 monthly, billed yearly
What I like: Whenever you full this course, you stand an opportunity of getting a extremely sought-after Excel certification that’s acknowledged worldwide.
15. Excel Necessities from Excel Publicity
This can be a paid Excel useful resource that may enable you to unlock your inside Excel ninja, overcome your concern of Excel, cut back errors in your Excel paperwork, automate some duties, achieve confidence, use Excel quicker. and save helpful time.
That’s a number of advantages.
Excel Necessities from Excel Publicity is a self-paced on-line course with over 5 hours of content material that covers Excel fundamentals, as much as superior ideas like Pivot Tables and VLOOKUPs.
The course teacher, Ben Currier, has spent the final 15 years working in finance and accounting in varied industries like actual property, healthcare, video video games, diamond jewellery, and extra.
Supply
Worth
$197 – One-time fee; lifetime entry
$59 monthly, billed month-to-month
What I like: Regardless that this can be a paid course, it’s superior that the primary module is obtainable freed from cost.
16. Coursera
Partnering with 350+ main universities and corporations worldwide, Coursera is a world platform for on-line studying and profession growth.
The location gives on-line courses to anybody, anyplace, on all kinds of subjects, starting from music manufacturing to Excel to teaching abilities, and rather more.
Listed here are among the standard Excel assets that I discovered:
Supply
Like many real-world courses, every course contains video lectures, interactive quizzes, peer-graded assessments, and the chance to attach with fellow college students and instructors.
When you end a course, you may obtain formal recognition together with an optionally available course certificates.
Worth
Be taught a single matter or talent: $49-$79 monthly
Full a number of programs with Coursera Plus Month-to-month: $59 monthly, 7-day free trial
Full a number of programs with Coursera Plus Yearly: $399 per yr, with a 14-day money-back assure
What I like: I really like the assorted pricing choices obtainable, particularly Coursera Plus month-to-month, that I can use to finish a number of programs inside one or two months.
17. Udemy’s “Microsoft Excel – From Newbie to Knowledgeable in 6 Hours”
When you had six hours to spare, how would you utilize them? “Sleep,” “clear the home,” and “bake one thing” are among the issues that come to thoughts. However what in case you can change into an Excel knowledgeable in that period of time?
That is what Udemy guarantees in its “Microsoft Excel – From Newbie to Knowledgeable in 6 Hours” course. You’ll study every little thing you want to learn about Microsoft Excel, from the basics to essentially the most superior options.
I additionally observed that the course contains 5 hours of video, an article, 128 downloadable assets, entry on cell and TV, closed captions, lifetime entry and a certificates of completion.
Udemy is likely one of the most bountiful on-line studying assets on the market, and their Excel programs are many. The truth is, typing “Excel” into the search bar yields 1000’s of outcomes, each displaying a star score, value, size, and stage.
Supply
Worth: $149.99, presently discounted to $16.99. (Test web page for frequent reductions.)
What I like: It’s superb that the course teacher, Todd McLeod, is a Microsoft Licensed Grasp Teacher and a college professor with 20+ years of expertise educating Microsoft Excel. I get a number of worth studying from specialists who are usually not solely acquainted with the software, however tips on how to educate it.
18. Excel Everest
The title of this useful resource could look intimidating, however you‘d be stunned how handy the coaching is. Excel Everest is an out-of-the-box useful resource that teaches you Excel whilst you’re in Excel.
I discovered that the product you purchase downloads an Excel file to your pc, the place you may open Excel and have interaction in walk-throughs of 41 completely different Excel features proper from a pattern spreadsheet.
Matters coated embody conditional formatting, VLOOKUP, chart creation, and a lot extra.
This Excel coaching useful resource gives tons of of workout routines, together with video tutorials embedded instantly in a pattern Excel spreadsheet.
By making use of these ideas in Excel as you study them, you‘ll really feel them persist with you lengthy after you full Excel Everest’s coaching.
Worth: $159
What I like: I feel it’s a superb signal that high firms like Google, Eventbrite, PlayCore, and extra belief Excel Everest for his or her worker Excel coaching.
Microsoft On-line Excel Coaching – Be taught Excel Formulation, Pivot Tables, Macros, VLOOKUP & extra…
19. Be taught iT!
Be taught iT! gives Excel coaching in quite a lot of codecs and breaks each lesson down by module. It is the most effective options for Excel learners who need greater than only a video sequence or a written step-by-step information.
Listed here are a few of their open Excel trainings:
Excel Introduction
Excel Intermediate
Excel Superior
Excel Energy Person
Excel Pivot Tables
Excel Intro to Knowledge Evaluation
Excel VBA
Supply
With 28 years of success serving to firms and careers develop, Be taught iT has upskilled over a million people, helped 10,000+ firms upskill their workforce, and likewise educated folks in over 15 nations.
Worth
Excel Introduction, Intermediate, Superior: $145 – $290
Excel Energy Person, Pivot Tables: $145 – $290
Excel Intro to Knowledge Evaluation: $145
Excel VBA: $995
What I like: I feel it’s superior you could take your chosen course 4 alternative ways: an in-person instructor-led session, dwell on-line with classmates, privately in a custom-made session, or a self-paced mixture of instructor-led and interactive elearning programs.
20. LinkedIn Studying
In case you didn’t know, LinkedIn is not only for skilled networking. LinkedIn Studying is a web-based studying platform — sure, from LinkedIn — that gives entry to greater than 24,000 high-quality on-demand programs.
You’ll be able to uncover and study varied enterprise, expertise, and artistic subjects and abilities with the assistance of subject material specialists (SMEs) who host their coaching on the LinkedIn Studying platform.
Many of those programs embody train recordsdata, assessments, and video transcripts.
Once I looked for Microsoft Excel on LinkedIn Studying, I received over 7,000 outcomes, displaying completely different Excel programs from varied SMEs. Listed here are a few of them:
Excel Important Coaching (Microsoft 365)
Excel: VLOOKUP and XLOOKUP for Newcomers
Excel: Provide Chain Transport Evaluation
Excel Fast Ideas
Try LinkedIn Studying for all obtainable Excel programs.
Supply
Worth
Premium LinkedIn subscriptions present limitless entry to LinkedIn Studying.
Premium LinkedIn subscriptions additionally provide a one-month free trial.
What I like: It’s fantastic that so many high-quality Excel assets can be found to select from, relying on particular person wants, preferences, and priorities.
21. eLearnExcel
eLearnExcel is a Microsoft Excel eLearning firm. It’s additionally a product of the Worldwide Academy of Laptop Coaching (IACT) — Eire’s largest and most skilled IT Coaching firm.
They provide eight Excel coaching programs, and 7 of them present related Excel certifications.
Try a few of their programs under:
15 Time-Saving Excel Ideas You’ll Use On a regular basis
Perceive the Fundamentals of Excel Step-by-Step
Uncover the must-know Excel Formulation and Capabilities
The right way to analyze knowledge in Excel to make higher selections
Uncover The right way to Make Lovely Charts in Excel
When you full all eight programs, quizzes, and the Excel Grasp Challenge, you’ll be awarded the Excel Grasp Diploma.
It‘s not a nasty merchandise to place in your resume — or on your enterprise’s web site, if a number of staff enroll in eLearnExcel’s programs as a part of a enterprise subscription.
Worth
You may get all programs with any of their membership plans under:
14-day free trial
$24 monthly, paid month-to-month. Cancel anytime!
$247 for one-year entry
$297 for two-year entry
$999 for lifetime entry
What I like: I feel it’s pretty that their programs are usually not solely accredited by Microsoft, however are additionally utilized by them.
Begin Studying Excel On-line
Whether or not you want to brush up your Excel abilities rapidly, otherwise you wish to study Excel from scratch, I’ve shared the very best methods to study Excel on-line freed from cost. I additionally added some paid assets which can be effectively well worth the cash.
Personally, I can’t wait to dive into my favorites — I’m planning on taking the Excel for Entrepreneurs course from GoSkills and HubSpot Academy, the Spreadsheet Web page, Exceljet, Contextures, Excel in an Hour, Trump Excel, and all of the HubSpot Excel assets.
When you’re prepared, begin with a number of of the free programs. Very quickly, you can improve your productiveness, broaden your data, and implement the facility of Excel in your initiatives.
Editor’s notice: This put up was initially revealed in March 2019 and has been up to date for comprehensiveness.
