There are two kinds of people in this world, those who are terrified of Microsoft Excel and those that possess magical spreadsheet powers, whom we call wizards or gurus.
You may be in the former group and need to polish your skills for a new job or school project, or in the latter and you’re just looking to learn new tricks.
You’re probably wondering: “How do I become an Excel wizard?”
Well today I’m going to make it easy for you.
All you need to do is dive into one of the resources listed below depending on your learning preference. These resources are the best of the best. Each has been handpicked for a specific learning method and skill level.
Let’s do this.
Excel Blogs are awesome for learning specific skills from tutorials and blog posts, keeping up with tricks and tips and understanding how to the make the most of Excel on a daily basis.
Chandoo.org is an excellent multi-faceted website that aims to “make its user awesome in Microsoft Excel.” The blog offers tips, tricks and tutorials for specific functions and guides for new or advanced users.
The Contextures blog created by Debra Dalgleish focuses on Excel tips and Excel tutorials. The posts consists of time-saving tips, shortcuts, and step-by-step instructions and videos.
This excel blog covers the basics of excel and beginner functions in a step-by-step manner. Deskbright is founded by Sam McIntire who wants to teach people the technical skills to succeed in business.
Excel Campus was created by Jon Acampora who has over 10 years of Excel experience. He created Excel Campus to share his passion for Excel. On his blog, he focuses on efficiency while sharing tips, tools, and techniques to help improve your Excel skills through articles, videos, and online courses.
Excel Easy is the self-proclaimed #1 Excel Tutorial on the net. It sure does an awesome job of teaching readers the basics, functions, data analysis and VBA quickly with an illustrated tutorial.
Excel Functions goes from the basics to tutorials for learning how to program their Excel function. There are examples of each of the Excel Built-In Functions and examples of how to perform popular tasks using Excel Formulas.
This site provides quick lessons and how tos that will help build your excel skill level. Each post is like a mini tutorial, which is done step-by-step and quite easy to follow.
John Michaloudis’ My Excel Online offers bite sized gifs with complimentary downloadable workbooks for you to practice your Excel skills. The posts are neatly arranged by topic and functionality you may want to learn.
The Peltier Tech blog is an advanced excel blog about Excel charting, with examples and tutorials, VBA samples and utilities, general graphics and visualization topics.
Ron de Bruin runs one of the most advanced Excel blogs on the internet. He offers tutorials and tips on Excel Automation like sending emails on Excel for Windows and for Mac.
Spreadsheeto was created by Kasper and Mikel, two friends in Denmark, who saw an opportunity in creating quality excel courses. They post high quality and well designed how tos.
Sumit Bansal’s Trump Excel covers the basics, provides excel and VBA tips, formula hacks, charting and free templates. The posts are detailed and easy to follow but we recommend having some familiarity before diving in.
Most of us have grown up learning from books and we believe Excel should be no different. These incredibly helpful Excel books are the cream of the crop for those who prefer a physical learning aid.
This book is very good for an Excel beginners. The learning curve is not steep, making it ideal for anyone’s first introduction to Microsoft Excel. It has full-color screen shots which show you exactly what to do, step-by-step.
This all-in-one excel book is a comprehensive guide is meant for those who are starting out or even excel wizards. This book covers templates, formulas, pivot tables, analyzing data, and much more.
Excel 2013 Data Analysis and Business Modeling is an advanced book that focuses on solving real business problems with Excel. There are numerous examples of problems at the end of each chapter that help to solidify your knowledge and practice of the given topic.
The Smart Method provides an entirely new and better way to learn Excel 2013. It’s very practical, you can learn an awful lot in a short time, and it comes with many sample files that you download that you can practice on, step-by-step.
This tutorial was designed for people who are beginners – those who will work using Excel for the very first time and are unfamiliar with the commands in Excel. The author has included some of the best tips, tricks and shortcuts that might come in handy.
The book is aranged roughly as 138 separate short chapters, one chapter per tip. Think of this book as a toolbox. This book is perfect when you are trying to solve a problem in Excel.
In Learn Excel 2010 Expert Skills with The Smart Method, advanced concepts are explained without needless technical jargon. Everything is concisely described in a simple, no-nonsense way.
This book reveals data visualization techniques that will allow you to create designer-quality charts and graphs. It is packed with simple, step-by-step instructions, real-world examples and case studies.
This is the best book to learn pivot tables from. It is a thorough description and analysis of Excel pivot tables and charts, and how to analyze data. Well written with plenty of practical examples.
The author does a good job organizing the book as a reference tool for Excel. If you need a reference to some of the more complex functions and tricks in Excel–this is the book for you!
This eBook explores the formula and functions that are useful for computing and managing data. You will learn about mathematical and statistical functions, conditional calculations and lookup tables.
Excel 2013: Formulas and Functions is a free eBook that formulas in Excel: performing calculations, creating advanced formulas and analyzing data with logical and look up functions.
This eBook is a hands on beginners guide that goes over some of the most fundamental functions. This is a good book for users entering the world of Excel for the first time.
MS Excel 2013 Basics is another introductory ebook that is loaded with step-by-step tutorials. This book covers the basics and answers frequent questions users may have.
Online courses have grown enormously in popularity over the past few years. These paid and free Excel courses are the perfect for those who want to learn at their own pace in a structured manner.
The Best Excel Tutorial is a free step-by-step course to learning basic and advanced functions, VBA, charts and some neat tricks that will get you well on your way to conquering excel.
Chandoo’s Excel School is a structured and comprehensive online training program for learning Microsoft Excel. It is full of goodies like formula cheat sheets, detailed lessons, workbooks, examples and much more.
Duke University’s Fuqua School of Business offers a free excel review intended for MBA students. They cover topics like excel tips, special tools, add ins and provide modeling practice. A great resource for someone looking to advance their skills.
Microsoft uses Elearn Excel to train its employees. You can access the comprehensive courses from any device, learn at your own pace and get certified in Excel. They offer many bundles and specializations.
Excel Exposure is a free online Excel training class designed to help you learn more about the features and functionality of Microsoft Excel 2010. The site includes video lessons, tutorials and information to help improve your Excel skills. The course covers beginner, intermediate and advanced lessons.
Exceljet videos are quick, to the point and come with its own practice worksheet.. Access to all courses is permanent (doesn’t expire). The site also offers free short excel tip videos.
GCF Learn Free provides self-paced tutorials are available on your schedule. You can learn by either clicking on a relevant topic or work your way through the entire course. This is a good option for beginners.
Home and Learn is the destination for complete beginners to Excel VBA. The course assumes you have no prior coding experience. In this course you’ll learn how to create your own macros.
This free Udemy Intermediate Excel crash course offers bite sized lessons and downloadable practice excel files. In this course, the instructor will walk you through the top ten skills you need to know in order to excel in Microsoft Excel!
In this course, you will learn how to create pivot tables from a range with rows and columns in Excel. You will see the power of Excel pivots in action and their ability to summarize data in flexible ways, enabling quick exploration of data and producing valuable insights from the accumulated data. You don’t need any previous knowledge of Excel to take this course.
During this free introductory course, you will learn the basics of using Microsoft Excel 2010. You’ll start with creating a new workbook and entering text and numbers, moving onto saving and printing your documents.
In this advanced course, you will learn how to create eye-catching charts and graphs (formatting axes and gridlines, showing basic trends, complex trends, even trends over time). Learn the differences between the various types of charts, relationships in data, and ways to show differences.
This course is perfect for anyone looking to learn Pivot Tables. It provides examples using some fairly straightforward data to develop a pivot table and a pivot chart. Then it moves on to more advanced pivot table functions.
Lynda (now owned by LinkedIn) has a vast library of videos and courses on many topics, including 30 Microsoft Excel beginner courses. The many beginner courses offered by Lynda are extensive, high quality and in-depth.
Lynda (now owned by LinkedIn) has a vast library of videos and courses on many topics, including over 2500 Microsoft Excel intermediate video. The courses offered by Lynda are compatible with all versions of Excel.
Lynda (now owned by LinkedIn) has a vast library of advanced Excel videos and courses. They cover a huge range of topics and functions and are constantly updating their content library.
This advanced excel course teaches the concepts and mathematical methods behind predictive models. You will also learn proper methodology to avoid common data-analytic pitfalls when forecasting – such as being “fooled by randomness” and over-fitting “noise” as if it were “signal.”
This course provides details of how Pivot Tables work and the structure that must be followed to create useful reports. This course is vital to gaining the most powerful feature of Excel.
The course provides a solid foundation in Excel VBA. This advanced course explains how and where Macros can be useful in Excel and how to use Excel for as much of the “heavy lifting” as possible.
You will learn through step-by-step instructions how to use logic functions within Excel. With Logic functions, you can set criteria which Excel must follow and will in turn make adjustments and calculations for you based on the criteria you set.
The instructor in this course will teach you basic navigation, window control, formatting and calculations all in about 30 minutes! It is a simple and to the point intro. The pace is a little quick.
OfficeTuts created these tutorials to teach you the basic and advanced features of Microsoft Excel. This course consists of richly illustrated lessons and examples. They also have a formulas and advanced vba tutorial.
Spreadsheeto’s free excel training is a blueprint for learning Excel in just 7 days. Their course, updated for 2016, will give you a strong foundation and understanding of Microsoft Excel in record time.
Trump Excel offers a 100% online video course that allows you to learn at your own comfortable pace (from anywhere and from any device). It’s a comprehensive Excel course that covers all the basic concepts in detail and then dives into advanced features.
This tutorial has been designed for computer users who are willing to learn Microsoft Excel in simple steps and they do not have much knowledge about computer usage and other Microsoft applications.
Learn the basics of Microsoft Excel and become an effective user. The target audience for this free excel course are those who have never used Excel before and those who are beginner level users.
Forums are an important tool in your journey to conquer Excel. These dedicated forums are communities where Excel experts can give you personalized assistance with questions.
The Chandoo Forum is a popular excel forum with nearly 30,000 members and 28,000 discussion threads. This is a great place to discuss anything related to Microsoft Excel.
Excel Forum is probably one of the most popular Excel forums on the Internet. The threads cover every excel topic you can think of. They have nearly 900,000 members and 800,000 threads.
Ozgrid, in addition to being an incredibly helpful forum, has a guide to Excel best practices and design tips. This forum has nearly 300,000 members and 115,000 threads.
These miscellaneous Excel resources are essential for those looking to go beyond the basics. They offer various Excel skins, templates, add-ins, tips and tricks.
Videos are ideal for visual learners who prefer to watch someone and learn. These videos cover a wide range of topics for different Excel skill levels.
Contextures, created by Debra Dalgleish, has a YouTube channel with free videos on excel tips and tutorials, a large collection of Excel sample workbooks and keyboard shortcuts.
Mike “excelisfun” Girvin’s YouTube channel has over 2600 Excel How To Videos from Beginner all the way to Advanced. Simply start watching a playlist of any topic you want to learn.
Another free YouTube channel where you can find Excel help and tutorial videos. Topics include: Graphs, Formatting, Worksheet Security, Macros Guides, Formulas, etc.
Learn about Microsoft Excel with LearnExcel’s professional tutorials and training. Their comprehensive playlist includes the basics, quick tips, functions and charting.
Audit Excel has a gigantic library of free excel videos. The best part is that each bite sized video is sorted by skill level. The site also features courses, tips, and add-ins.
Wrapping it up
There you have it folks.
An excellent (pun intended) list of resources that will surely transform you into an Excel Wizard quickly.
Share this with friends or coworkers who are struggling with excel and they will be grateful!
Found any of these resources helpful?
Are we missing any awesome websites?
Let us know in the comments section below