36 Excel Tutorials To Help You Master Spreadsheets


Disclosure: Our content is reader-supported, which means we earn commissions from links on Digital. Commissions do not affect our editorial evaluations or opinions.

You can find a wide range of free Excel training tutorials online to master your skills with the widely-used spreadsheet software in the Microsoft Office Suite. Excel tutorials can teach how to control and manage your product information and optimize Excel features to help your e-commerce grow. Learn Excel at your speed with these Excel tutorials.

Key takeaways: 

  • Basic Microsoft Excel tutorials can get you started using this tool or offer advanced users a better understanding of how Excel works.
  • You can take your Excel skills to the next level with advanced Excel tutorials.

Microsoft Excel Basics Tutorials

Learning Microsoft Excel basics is essential if you want a firm foundation for advanced functionality. Here are some resources to get you started, even if you’ve never used Excel before:

Excel graphs shown on a phone screen and a desktop screen.
  1. The Excel Easy Website: This Excel tutorial gets you started with Microsoft Excel without going overboard with jargon and technical terms. It begins with formatting cells, using conditional formatting, locating ribbons and workbooks, and using keyboard shortcuts to speed up the editing process.
  2. The Motion Training YouTube channelThis tutorial-based YouTube channel provides a compelling place to start your research, as the first video is only nine minutes long, and you can easily follow along. The beginner’s course has four sections, so it allows you to break the Excel tutorial into chunks, and make notes as you skip around whenever you need to refer back.
  3. What is Excel? (from Microsoft): This is a three-part video course with essentials for data entry and editing spreadsheets. Color coding and data bars are also covered, along with information about generating charts and pivot tables.
  4. GCF: GCF is a free learning environment with a wonderful compilation of Microsoft Excel tutorials and videos. The online guide starts with an introduction and an explanation of OneDrive. Then it covers working with cells, sheets, data, formulas, and functions. It also includes information on how to buy Microsoft Excel, along with a list of the newest features in recent releases.
  5. Chandoo: Here, you can find intermediate information about using conditional formatting and creating reports quickly. The raw basics of free Excel training are outlined in this article, using text, images, and video. It also features links to other resources for you to read further.
  6. Excel Made Easy: A Beginner’s Guide: This Excel tutorial has a wonderful layout of the structure of a simple Excel worksheet. This way, you know exactly where to go while learning the Excel terms and shortcuts.
  7. Excel Exposure: This site has a free online training course with links to several video lessons. Conditional Excel formatting and error checking are just two of the topics covered in the earlier sections, and then it goes all the way to macros and more advanced information. Excel Exposure has a large community of followers with whom you can connect and get answers to questions you ask in the comments.
  8. Excel tutorials from Guru99: These Excel tutorials provide answers to questions about Excel functions, visualizing data charts, using Excel in the cloud, and the difference between CSV and Excel. It has some niche topics that you can’t find anywhere else, and it’s all free, with beautiful images and animations.
  9. The wikiHow for How to Use Excel: This might be one of your first stops if you’re a complete beginner with Microsoft Excel. Although it’s not all that comprehensive, the guide touches on the true basics, with screenshots that have areas zoomed-in and arrows to guide you. Everything from completing basic Excel functions to printing your Excel sheet is covered in an easy-to-read format.
  10. Basic Excel – Learn the Excel Basics on ExcelFunctions.net: Even advanced users need a refresher on simple Excel functions, and this is a solid resource to have handy. For instance, you might need to find out what the Find and Replace function is. A quick search through this article gets you the answer.

Advanced Microsoft Excel Mathematics Tutorials

Illustration of woman teaching excel function.
Source: Jotform.com

When working with numbers and formulas, it helps to have a grounding in advanced mathematics tofully understand what’s possible in Excel. These resources provide a refresher on mathematics with plenty of real-world use cases:

  1. Excel Advanced Formulas and Functions: This course has been viewed thousands of times, and it takes around six hours to complete, with videos, downloadable materials, and a transcript. The exercise files improve your learning since you can practice during the course.
  2. Excel Math Functions on ExcelFunctions.net: This list is a good starting point for anyone interested in learning even the most basic Excel functions, such as the AutoSum function. It goes deeper into more advanced usage, so you get a whole range of what to expect when making your own Excel formulas.
  3. Top 25 Excel Advanced Formulas: If you’d like to have most of the information you’ll need in one place, paying for a Udemy course may be sensible. These have had over 9,000 students enrolled, with instruction for mastering the top 25 most advanced math formulas in Excel. It includes true-life examples for the formulas so you can see how to use them in the future.
  4. Microsoft Excel – Advanced Excel Formulas & Functions: This is another impressive Udemy class with Excel tips and tricks for the real world. The course states that it’s best for analysts and covers over 75 of the most advanced formulas in the spreadsheet application. Dozens of PDF quizzes, practice files, and slides are available for download, and a beautifully structured course outline is there to walk you through some of the more complicated techniques.
  5. Excel as a Financial Calculator: This article is particularly useful since not everyone uses a real financial calculator. We like the chart that compares some of the more advanced Excel functions to keys on a financial calculator. This allows you to seamlessly transition from a calculator to an Excel spreadsheet for complex calculations.
  6. Advanced Excel Tutorial on Excel Exposure: This tutorial starts with an introduction to tables and a wide range of math and statistical functions. For example, you’ll learn about ROUNDUP, COUNTIF, ROUNDDOWN, COUNTBLANK, MEDIAN, and much more. Excel Exposure keeps its articles on the shorter side, which is good if you want to absorb the information in small helpings.
  7. How to Do advanced time & math calculations on WonderHowTo: These are helpful guides primarily delivered in video format. All of the calculations are made through Excel files, allowing you to see them work and then practice them on your own time. The videos are short as well, so you’re not intimidated when getting started.

Microsoft Excel Database Tutorials

Person using a laptop with a spreadsheet shown.
Source: Lifewire.com

Excel isn’t just for spreadsheets. You can use it for databases and data analysis, too. Analyzing databases will help you understand some of the more complex functionality in Excel. Have a look here:

  1. Import Data into Excel and Create a Data Model: This tutorial expands on the essentials of data insertion and data analysis. It’s broken into several easy-to-understand links, so jumping around isn’t hard. For example, you could start with learning to import data using copy and paste, then go straight to creating a relationship between pieces of imported data.
  2. How to create a simple database in Excel with a list or table: This tutorial’s parent site, “Wonder How To” provides a few simple video tutorials for those interested in this topic. It’s just about the most basic you can get with Excel databases and spreadsheet applications, and the videos are short enough that you’re not overwhelmed with content from the start.
  3. Using Excel As Your Database: Another nice tutorial from Chandoo. It includes animated GIFs to complement the text. This speeds up the process of learning since the images are zoomed in for a more engaging guide. It explains the code module too, which provides an interesting take on the entire database process.
  4. How to Use Database Functions in Excel on Best Excel Tutorial: This explores the most common Excel functions you would use when constructing or mining a database. For example, some of the headers include functions like DMIN, DPRODUCT, DVARP, and DVAR.
  5. How to Create a Database in Excel: This tutorial begins with a database overview and moves on to more advanced topics in data analysis, such as filtering data and completing database formatting. The section on formatting is one of the most important, since it focuses on use in the real world, and that’s the goal, right?

Microsoft Excel Functions Tutorials

Illustration of a laptop with excel shown.
Source: Kerneldatarecovery.com

To really understand how to use Excel, you need to be able to write Excel functions. Once you learn how, you’ll be able to create powerful spreadsheets that unlock the true power of the tool. Check these out:

  1. 10 Most Used Functions MS Excel: This clip is a nice place to get the ball rolling since you don’t have to work through any problems or handle any worksheets. The tutorial is all shown in the video.
  2. GCF Excel Formulas: This is another beautiful guide with all of the Excel formulas you should know. This is a great resource to bookmark since the majority of Excel functions used in the real world are outlined here. You get free access to the tutorials and they’re all set up with videos and articles. Some of the topics include “Practice Reading Formulas,” “Percent-Off Sale,” and “Using the IF Function.”
  3. Formulas and Functions in Excel: A tutorial from Excel Easy that starts with copying and pasting and goes all the way to inserting a function. These are the true basics, so it might seem a little rudimentary to some.
  4. Excel Functions and Formulas (in Easy Steps): This isn’t technically a tutorial, but it’ll be invaluable as you work through some of the others on this list. It starts with COUNT and SUM functions, with a link you can click on to see the Excel formulas that relate. The website has plenty of other sections for statistics, financials, and more.
  5. Your Excel formulas cheat sheet: This is a page from PCWorld that serves as a quick reference for anyone who needs it.
  6. Excel VBA programming on Home and LearnThis site offers a full, free course filled with tutorials on mastering VBA programming through Excel. Strings, loops, and arrays are all covered here, along with variables and conditional logic.

Microsoft Excel Graphing Tutorials

Four different graphs shown in an excel spreadsheet.

Once you have your figures and formulas in Excel, you can automatically create graphs and charts with your data. Try these:

  1. Graphing with Excel from NCSU: This tutorial handles most graphic requirements, with links to topics on bar charts and histograms. For those just getting started, there is instruction for making basic graphs. Importing text files is also covered.
  2. How to Make a Chart or Graph in Excel: This is a tutorial on HubSpot, accompanied by a video. A collection of free Excel templates is provided,, to improve your usage of graphs — it displays them in their full form and prompts you to make them yourself.
  3. How to Create Charts in Excel (in Easy Steps): This Excel tutorial provides guidance to make a graph about wildlife populations, so you can see how a student or someone in the wildlife industry would do it.
  4. Create a chart from start to finish: This is one of the best Excel tutorials because it covers the complete process of creating a chart. Some of it is shown in a video, but the majority of the instruction is in a large article with pictures and hints on moving your chart, resizing, and making a legend.
  5. Advanced Excel Charts & Graphs: Guru99 is known for its advanced tutorials, and this is a fine example. The guide talks about the importance of advanced Excel charts while also touching on topics like making combinations and changing axis titles.

Excel Printing Tutorials

Pencil resting on a line graph.

Printing data from Excel can be difficult, particularly if you have a large sheet. These resources will help you to obtain the neat, orderly printout you need:

  1. How to Print Sheets in Excel (In Easy Steps): This article from Excel Easy delves into the most common types of printing in the Excel world.
  2. Printing Excel Workbooks: This topic might seem intimidating, but Chandoo has you covered with a five-minute video and some other related subjects like converting Excel to PDF and printing Excel cell comments.
  3. How to Print With Gridlines in Excel: This tutorial answers a question that many people have on their Excel journey. The gridlines come in handy for many professions, but this tool seems to be hidden in Excel. The good news is that it only takes around one minute to get the job done.
Akshat Biyani Avatar
Scroll to Top