Top FREE Microsoft Excel Courses by Udemy!!

Share With 🧡

Microsoft Excel Course provides a variety of applications, like Word, Excel, PowerPoint, Slack, Teams, etc. that are helpful for businesses. And most popular application is Microsoft Excel because it helps create spreadsheets and datasheets for various data of a firm, especially for analyzing the financial data.

Useful Excel for Beginners

Learn the basics of Microsoft Excel and become an effective user

Rating: 4.5 (32,169 ratings)305,391 students

9hr 38min of on-demand video

Created by  ind zara

  In this course, you will learn the fundamentals of Excel and become an effective user. The target audience for the course are those who have never used Excel before and those who are beginner level users. You would need a copy of Microsoft Excel for Windows since you will be practicing along with the course. I use Excel 2010 for Windows in the videos but any version with Excel 2007 for Windows or later would work. Excel Versions prior to 2007 have a different user interface but concepts will apply. 

     As the course is targeting beginners, it has been developed to be very easy to follow. We will be working with data related to a book store in the exercises. The files are available for download and you can follow along the videos while practicing. 

FREE TO ENROLL!!

Excel Quick Start Tutorial: 36 Minutes to Learn the Basics

Spark your skills in Excel! Go from a blank worksheet to pivot tables in 36 minutes. Great for interview prep!

Free tutorial Rating: 4.5 (15,285 ratings)100,720 students

36min of on-demand video

Created by  Jeff Knowlton

The course is just 36 minutes – you can finish it over a lunch break! That’s how long it takes to complete the videos in this course, and come away with a strong understanding of the use of Excel in business. You’ll learn many of the important Excel functions: IF, VLOOKUP, pivot tables and charts, including line charts, column charts and 3D column charts. You’ll learn how to enter and edit data and formulas. How to format text and numbers. How to filter and sort large tables of data and calculate totals.

FREE TO ENROLL!!

MS Excel – From 0 to Working Professional in 1 hour

Learn Excel as fast as possible

Free tutorial Rating: 4.4 (4,700 ratings)54,064 students

43min of on-demand video

Created by  Jason Zhang

This course covers Excel basics in the way that’s very short and concise. You may use Excel before but this course shows you a better way of using these functions in real work environment. If you are going back to workforce, or looking for jobs, this is the fastest way to refresh your skill or Jump Start your skills. Within 1 hour, you can use Excel the way a working professional would use.

FREE TO ENROLL!!

Excel for Accountants: Mapping Tables

Automate reporting tasks with a mapping table

Free tutorial Rating: 4.3 (5,488 ratings)76,290 students

31min of on-demand video

Created by Jeff Lenning

In this course, author and award-winning instructor Jeff Lenning CPA demonstrates the technique featured in his Journal of Accountancy article The Power of Mapping Tables. If you use Microsoft Excel to generate reports, this course is for you. We discuss the benefits of storing source data in tables, how to use the SUMIFS function to conditionally sum transactions, and how to translate labels with a mapping table.

Microsoft introduced tables in Excel 2007, and this feature is a game-changer. If you do not store your data in tables, you are missing out on a simple way to improve the reliability of your workbooks. Converting an ordinary range into a table provides many special benefits, and we’ll discuss these special properties in the course.

FREE TO ENROLL!!

Ten Excel Features Every Analyst Should Know

A collections of tools that should be in every analysts toolbox

Rating: 4.4 (6,442 ratings)56,788 students

30min of on-demand video

Created by John MacDougall

In this course we will learn about some awesome Excel features and how to use them with some examples commonly encountered by every analyst. 

  1. Text to Column
  2. Flash Fill
  3. Recording a Macro
  4. Grouping Sheet
  5. Deleting Blank Rows
  6. Remove Duplicate Data
  7. Auto Sum
  8. Filling a Range with Ctrl + Enter
  9. 3D Sums
  10. Advanced Filters

Bonus: Conditional Formatting

These tools should be in every analysts toolbox and will save you a lot of time and effort if you know how to use them should the need arise.

FREE TO ENROLL!!

Excel Pivot Table Basics

Start analyzing data with Excel’s most powerful data analysis tool, Pivot Tables. They’re easier than you think!

Rating: 4.5 (11,163 ratings)107,284 students

50min of on-demand video

Created by Matt Jackman

What’s this course about

Pivot Tables are one of the most powerful features in Excel. Once you learn how to use Pivot Tables, they’ll change the way you use Excel.

If you’re not familiar with Pivot Tables, they’re a tool that allow you to summarize large sets of information quickly and easily. You can analyze thousands of rows in a matter of seconds that could otherwise take hours trying to figure out using complex formulas.

This is an introductory Pivot Table course and gives the information you’ll need to start using Pivot Tables.

Who will benefit from this course

If you’re somebody that uses Excel on a regular basis to track or maintain information, you will definitely benefit from learning Pivot Tables.

You don’t have to be a master of Excel formulas to take this course, but you should have a sound understanding of how to navigate around Excel before you take this course.

This would be considered an intermediate Excel course and students should understand basic mathematical calculations (e.g. addition, subtraction, multiplication and division) and formulas in Excel.

What you’ll learn in this course

  • How to create a Pivot Table
  • How to summarize information in different ways using Pivot Tables

By the end of this course, you’ll be able to take your own information and leverage Pivot Tables to answer questions with ease!

FREE TO ENROLL!!

Microsoft Excel – Improve your skills quickly

Pivot Tables, Charts, Sparklines, functions, formulas and more – in just a couple of hours

Rating: 4.4 (3,673 ratings)40,981 students

1hr 35min of on-demand video

Created by Phillip Burton

In this course, I take my favorite features and functions, and show you how you can make your Excel life easier by using them.

  • Learn more about formatting, filters and conditional formatting.
  • Create tables, PivotTables, Chart, PivotCharts and Sparklines.
  • Find out how powerful Visual Basic for Applications (VBA) is.
  • And learn functions such as SUM, SUMIF, VLOOKUP, OFFSET and iNDIRECT – translated into 15 different languages.

In just a couple of hours, you can see how much time and frustration you can save knowing a few additional features – and you’ll find out how much more you can learn.

FREE TO ENROLL!!

Introduction to Microsoft Excel 2010

Learn the basics of using Microsoft Excel 2010

Rating: 4.6 (3,132 ratings)28,869 students

1hr 11min of on-demand video

Created by Simon Sez IT

During this introductory course on using Microsoft Excel 2010, we’ll teach the basics of using Microsoft Excel 2010.Your professional instructor will talk you through Excel 2010’s features, starting with the basics, from creating files to editing existing documents. You’ll start with creating a new workbook and entering text and numbers, moving onto saving and printing your documents.


The course is designed for individuals and office professionals who need to learn the basics of Microsoft Excel 2010.

FREE TO ENROLL!!

Excel 2016 Pivot Tables: Create Basic Pivot Tables in Excel

Pivot Tables in Excel 2016. Learn to create basic Pivot Tables in Excel 2016 with real-life examples.

Rating: 4.2 (3,509 ratings)49,790 students

1hr 7min of on-demand video

Created by Kawser Ahmed

At the end of this course:

  1. You will be able to create and update basic pivot table reports using Excel 2016,
  2. You will be able to realize, why and when you can best use of Excel Pivot Table tool,
  3. You will be get used to with the features of an Excel Pivot Table Report
  4. And you will be able to handle the limitations and compatibility issues related Pivot tables.

Let me give you an idea what exact topics I am going to teach you in this course.

  1. I will show you the exact cases when you can use the Excel Pivot Table
  2. Then I will show you the anatomy of a pivot table report with a real life example.
  3. Then you will see the step by step by process of preparing a data source for Excel Pivot table
  4. Then you will learn how to create and update a basic pivot table report
  5. Then you will be introduced with the Slicer tool in Excel
  6. And at the end of the course, I will show you total three techniques that you can use to will save your time when you’re working with Excel Pivot tables.

FREE TO ENROLL!!

Best Online Excel Training | Best Shortcuts in 30 mins.

Quick useful guide to learn Excel Shortcuts (Save time & Money) [Excel 2007 – Excel -2019]

Rating: 4.4 (4,501 ratings)61,839 students

34min of on-demand video

Created by Yoda Learning

This course is best suited for MS Excel 2007-2019 (Windows PC).

Not suited for Mac.

The best part is you can learn them in 30 minutes and start showing off at your office. Join now for a Complete No-Nonsense Course on Excel Shortcuts.

FREE TO ENROLL!!


Share With 🧡

Leave a Comment

Join us on Telegram For latest Course Update FirstJoin us
+ +