Best Free Excel Macros Courses

Find the best online Free Excel Macros Courses for you. The courses are sorted based on popularity and user ratings. We do not allow paid placements in any of our rankings.

Useful Excel for Beginners

Learn the basics of Microsoft Excel and become an effective user

Created by Dinesh Natarajan Mohan - Sharing simple but effective solutions

"]

Students: 367180, Price: Free

      Welcome to the Useful Excel for Beginners course. 

     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. 

     The course covers the topics that you would need to know, to become a functional user. You can download the Table of Contents document from Chapter 1, to see all the topics the course will address. The course has 89 videos and runs for 9.5 hours. 

Since this is a free course, Udemy does not offer certificates anymore.

Microsoft Excel Pivot Tables – The Beginner Course

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

Created by Matt Jackman - Digital Analytics and SEO Professional

"]

Students: 145431, Price: Free

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!

Excel Dashboards in an Hour

Learn how to create interactive Excel Dashboards in one hour. No special add-ins or tools required, just Excel.

Created by Mynda Treacy - Microsoft Excel MVP, Teaching 25,000+ Students

"]

Students: 129832, Price: Free

Excel Dashboards are a powerful tool to communicate and summarize complex Excel data. They can be created to summarize important information and are excellent for sharing a “snapshot" view among teams.

In this mini-course I’m going to teach you a handful of the most powerful techniques so you can get some fast results. I’ve taught this course in various forms and the feedback has been incredible. Here are just a few:

"10 minutes in and I feel like I can save hours" - Alex

"I consider myself quite good at Excel, but your mastery of it leaves me in the ashes. The dashboard presentation was dazzling." - Ben

"Wow! I am so excited to try this myself! Thank you so much for sharing your skills." - Lyn

Very dense information that in just one hour you represented what I have spent days reading books about this subject. - Khalid

"I've been using Excel for over 10 years and I'd like to take the time to say thank you. That was definitely one of the best courses I've ever taken.

It was
incredibly informative, insightful and taught me a few tips and tricks
that will surely aid me in producing automated dashboards. Thank you for
sharing the course materials.

Nothing short of excellent! " - Amanta

You too can master the creation of Interactive Excel Dashboards and learn to build Dashboard Reports from the ground up.

  • Design and Display Principles
  • Interactive Controls
  • Automating your Dashboard so it updates in seconds

Impressive Content that Will Provide Insight, Analysis and Alerts Dashboards are fully interactive and dynamic and can help with project management, customer service, retail management, financial forecasting and much more.

Excel Dashboard students should have access to the PC version of Excel 2010 or later. Students should also be familiar with putting together any type of report in Excel to be able to apply the time saving and visualization techniques taught here. Students should be able to build and apply basic formulas in Excel. Pivot Table and Chart knowledge is helpful, but expertise is not necessary to take this course.

Contents and Overview This course includes 9 lectures and just over 1 hour of content in order to give students a working knowledge of utilizing Excel to create interactive Excel Dashboards to communicate their data.

Included are the Excel Dashboard workbook and PowerPoint presentation from the course which contain notes on where you can find more resources. You can use the workbook to practice what you learn and as a quick reference guide later on.

The course covers advanced features of Excel Dashboards, such as display and visualization principles for clear dashboard creation, using interactive controls to keep the report informative and relevant. Analyzing and automating information for a fully functional and complete dashboard. 

Upon completion, students will have a variety of techniques and examples that can be applied to their own datasets, among a host of other tips that can be used in day to day Excel work.

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!

Created by Jeff Knowlton - Senior Executive. Data Scientist. Teacher.

"]

Students: 117385, Price: Free

Here's what some students are saying about the course in the Reviews!

"Really concise quick summary and foundation in Excel" - Clare B.

"Instruction was very easy to follow. It was like having a friend show you what to do." - Patrick M.

"Very clear and easy to understand" - Fiona M

 "Great introduction to pivot tables and good examples too."  - John P. 

"Needed this to get ready for a new job, feeling more confident already!" - Daniel H.

"I have been using Excel for years but only in very specific ways. This course gave a good overview of major functions I have never used and didn't know existed. Will be making some accounting pivot charts right away." - Kyrie

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.

Only 36 minutes! How is this possible? I work through two business case studies on sales reporting and analysis, showing you how to use Excel to analyze data and answer questions, highlighting each step, and clearly explaining what I’m doing and why. You’ll learn how the functions work, and you’ll learn when, and why, to use them in business analytics. Full disclosure: plan for another 45 minutes or so to work through the case studies yourself. I provide all of the files. 

And it’s free! Even though free, it includes all of the features of the standard course: downloadable files, closed captions and quizzes, to help you learn and make it stick. 

This course is designed for people who are preparing for an interview. Starting a new office job. Looking to jump-start their career. And even for those people who are thinking about a longer Excel course, but who aren't sure that Excel is right for them. 

But let’s make something clear: you won’t be an expert. This course is a starting point, the first step on your journey to learn business analytics. It may be as far as you need to go. Let’s find out! Click the button “TAKE THIS COURSE” and get started. 

Excel for Accountants: Mapping Tables

Automate reporting tasks with a mapping table

Created by Jeff Lenning - Microsoft Certified Trainer

"]

Students: 85081, Price: Free

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.

Also with the roll-out of Excel 2007, Microsoft introduced a new worksheet function: SUMIFS. This too is a game-changer. Performing multiple-condition summing in earlier versions of Excel was challenging, and required clever functions such as SUMPRODUCT or array formulas. For many workbooks, these can be replaced with the SUMIFS function. We'll discuss the function's arguments and demonstrate several practical applications.

Excel reports often aggregate data. Frequently, the data labels are different than the report labels. For example, the accounting system may export account names, such as Cash or Savings, but the corresponding report labels are financial statement items, such as Cash and Cash Equivalents. When the labels are different, we are prevented from using lookup functions such as VLOOKUP to retrieve values. In this course, we'll demonstrate the mapping table technique which enables our reports to retrieve values from data tables, even when the labels are different.

The course includes practice Excel files, corresponding answers files, and a solutions video. The course is structured by topic, and within each topic, there is a PowerPoint discussion, a lecture video that works through the item in Microsoft Excel 2013 for Windows, and sample exercises for you to work hands-on. If you use Excel to create reports, this course will help you prepare them more quickly.

Excel Formulas and Functions with Excel Formulas Cheat Sheet

Learn Excel formulas and functions from scratch. Download Excel formulas and functions cheat sheet for your daily use.

Created by Kawser Ahmed - Founder ExcelDemy.com | Data Analyst

"]

Students: 83165, Price: Free

Teaching 11 Courses on Excel and Data Analysis!

OVER 25,000 visitors visit my blog ExcelDemy dot com every month!!

OVER 15,000 successful students have already taken my online courses since November, 2015 with 375 total Reviews!!!

Course Updated:  Nov 01. 2016

Formulas and worksheet functions are the heart of Microsoft Excel spreadsheet. They are essential to manipulating and obtaining useful information and insight from your data.

Without formulas and functions, Excel spreadsheet is simply a fancy word-processing document. Welcome to my Excel Formulas and Functions for Beginners course!

I designed this course for beginner level Excel users. But are you an intermediate level Excel user? Want to have a broader, deeper and in-depth knowledge in building Excel formulas and functions? This course is also for you!

I am Kawser Ahmed, your instructor with this course. I am a full time Excel, Excel VBA and Data Analytics blogger. And I am a corporate Excel trainer in my own country. Monthly more than 15,000 Excel users visit my Excel blog ExcelDemy and read my Excel and data related articles and tutorials.

Let’s discuss now what you will learn from this course.

  1. Operators and Precedence of Operators: I will start from zero and if you don’t know about the operators and precedence of operators that Excel uses in its formulas, then it will be tough for you to decode complex Excel formulas. So I have covered them very details.
  2. How to use built-in Excel functions: Then you will learn how to use built-in excel functions into the formulas using Insert Function and Function Arguments dialog box.
  3. Subtotal Function: You will find many uses of Subtotal function if you are using Excel with your Finance related jobs. So this function is covered in details at the start of the course.
  4. Relative, Absolute and Mixed Cell References: You will work with these three concepts time to time when you will build excel formulas. So, they have got a good time in the course.
  5. Formulas with Tables: Understanding how formulas work with Excel tables is very important. I have used two lectures to cover formulas with tables. In the second lecture, structured referencing with Excel tables has been discussed.  
  6. Circular Referencing: Then you will learn how to handle circular references with Excel formulas, how named cells and ranges work with formulas, and so on.
  7. DATEDIF() and Date related Excel Functions: And I will finish this course with DATEDIF () and other Date related Excel functions!

I am assuring you that what you will learn in this crash course is priceless. I designed this course keeping in mind, to give you a solid base in Excel formulas and function. Thanks for watching. Enjoy the course!

Best Online Excel Training | Best Shortcuts in 30 mins.

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

Created by Yoda Learning - Data Analyst |MS Office Expert & PMP | Instructor/Programmer

"]

Students: 68801, Price: Free

The list of 1000s of Excel shortcut keys are NOT to be memorized. It will torture your grey cells! So we have used industry practices and our Ninja Instructor's experience to handpick those shortcut keys which will meet your work requirements, make you look like an accomplished Excel Ninja.

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.

Ten Excel Features Every Analyst Should Know

A collections of tools that should be in every analysts toolbox

Created by John MacDougall - Microsoft Excel MVP

"]

Students: 67060, Price: Free

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.

MS Excel – From 0 to Working Professional in 1 hour

Learn Excel as fast as possible

Created by Jason Zhang - Financial Analyst

"]

Students: 63492, Price: Free

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.  

This course IS NOT for everyone because of 2 things

1. Excel is powerful. Microsoft tries to make Excel as relevant to anyone as possible. However, each occupation use Excel differently. I've no idea how scientists or engineers use Excel. But I know how working professionals, especially analysts use Excel. I've worked as Business Analyst, Market Analyst, and till this day a full time Financial Analyst. Excel changed my life, I get hired, get promoted because that. I hope more people can do the same and better.

2. The pace of the course is super fast. If you like things go slowly, this is NOT for you. This course covers basic Excel. Most of the things in this course should be learnt by doing. Therefore I have enclosed a downloadable workbook. You can see me demonstrating on the left side of the sheet, while you would be practicing on the right.  

Boost Your Excel Skills: Crash Course w/ Downloadable Files

Microsoft Excel: Hone Core Skills in Microsoft Excel in 1+ Hours (Downloadable Excel Files Included in Course)

Created by The ProductivityMe Company - Excel Tips, Tricks, & Tutorials, One Lesson at a Time.

"]

Students: 59750, Price: Free

Course Highlights:

  • 10 Individual, Bite-Sized Lessons
  • Downloadable Excel Files
  • Verifiable Certificate of Completion
  • Instant Access to Instructor and the ProductivityMe Community
  • 1080p HD Quality Video

In this Course:

Learning Excel takes time, particularly if you try to do it without any structure!

In this course, we'll walk you through the top ten skills you need to know in order to excel in Microsoft Excel!

Give us an hour, and we’ll help you to get to the next level of mastery in Microsoft Excel.

In this short, easy-to-follow training course...

We'll Cover:

  1. Autosum
  2. The Quick Access Toolbar
  3. The Shortcut Menu & The Mini-Toolbar
  4. The Quick Analysis Tool
  5. The Fill Handle
  6. Flash Fill
  7. Charts & Graphs
  8. Recommended Charts
  9. Sorting & Filters
  10. Tables

Our Approach:

At the end of each video, you have the chance to prove your mastery by completing a small practice exercise thus testing the core skill that you’ve just learned.

You can easily follow along in each lesson by using the downloadable course exercise files provided in Lecture 2.

If you have questions, comments, ideas, we’d love to hear from you. Email or message us any time.

Final Thoughts:

Alright, that’s it for now.

Look forward to having you in class!

Cheers,

Tolan & Ryan
ProductivityMe Co-Founders

Microsoft Excel – Improve your skills quickly

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

Created by Phillip Burton - Best Selling Instructor - over 340,000 students so far

"]

Students: 47848, Price: Free

Welcome to this course about Microsoft Excel.

A lot of people use some of the features in Excel and just muddle through - not many use all of the functions.

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.

Easy Excel Basics for Beginners – Get Started with Excel

Learn Microsoft Excel basics from the beginning. Spreadsheets, shortcuts and formulas. Good for Excel 2010, 2013 & 2016.

Created by Steve McDonald - Dedicated Instructor Will Help You Excel | 300K+ Students

"]

Students: 42632, Price: Free

Learn the basics of Excel quickly and easily.

This course is for you if you know that you need to get started learning Excel, but have just been too busy or felt too overwhelmed by the idea of studying.

This course will show you the basics of how to use Excel, how to create a basic spreadsheet, how to navigate quickly through a spreadsheet, how to create simple mathematical formulas and some shortcuts and keystrokes to save you lots of time.

You can go through this course in about 30 minutes. At the end you'll know how to create a sample spreadsheet that can calculate estimated kitchen remodeling costs automatically.

If you're ready to get your feet wet quickly and painlessly, take this easy introduction to Excel course and you'll see that using Excel can be easier than you think.

Excel: From beginner to intermediate

Learn the skills that Microsoft want you to know in Excel.

Created by Phillip Burton - Best Selling Instructor - over 340,000 students so far

"]

Students: 40022, Price: Free

What do others like you think of this course?

"Prior to doing this course Excel has always scared the heck out of me! I never expected to learn so much and am amazed by all the things that can be done using excel. It's so much more than just formulas! The course is really well presented and makes the whole learning experience comfortable and enjoyable. Thank you so much for putting together such a great course. I've already signed up to the intermediate to advanced excel course and I look forward to learning more about Microsoft Word in the future too... I imagine there are all orts of neat little tricks that I had no idea about!" -- Adam Shipley

"Phillip is a brilliant teacher of Excel . His explanations are clear , in-depth and very comprehensive" - xlongFx

"Awesome organization of course and well presented. I really loved the course. Of course as I am using excel for many years in work I was quite aware and using many features, but there are many details which helped me to polish my excel skills." - Manjunath Hirennavar

--------------------

In this 11 hour course, learn how to:

Create and manage worksheets and workbooks

  • Create and navigate in Excel worksheets and workbooks,

  • Format worksheets and workbooks,

  • Customize options and views, and

  • Configure Excel worksheets and workbooks for distribution.

Manage data cells and ranges

  • Insert data into and format cells and ranges, and

  • Summarise and organize data in Excel .

Create tables

  • Create and manage tables,

  • Manage table styles and options, and

  • Filter and sort a table.

Perform operations with Excel formulas and functions

  • Summarize data,

  • Perform conditional operations, and

  • Format and modify text.

  • Excel Formulas such as COUNTIF, SUMIF, MIN etc. are translated into 15 different languages.

Create charts and objects

  • Create charts,

  • Format graphic elements, and

  • Insert and format objects in Excel .

The course will take about 10 hours to complete, plus will you need additional time to test yourselves to ensure that you have learned the necessary skills.

Free Basic Excel Course + Lookup Function

Excel made easy for everyone

Created by MKCL India - Creating a Knowledge Lit World

"]

Students: 39974, Price: Free

Microsoft Excel has the basic features of all spreadsheets,using a grid of cells arranged in numbered rows and letter-named columns to organize data manipulations like arithmetic operations. It has a battery of supplied functions to answer statistical, engineering and financial needs. In addition, it can display data as line graphs, histograms and charts, and with a very limited three-dimensional graphical display. It allows sectioning of data to view its dependencies on various factors for different perspectives using pivot tables.

In this course you will be learning the basics which is required when you start working with Microsoft Excel. In today's time Microsoft Excel is one of the most important tool used in any organization. This course will definately help you to learn the basics with the practical use of it.

Introduction to Microsoft Excel 2010

Learn the basics of using Microsoft Excel 2010

Created by Simon Sez IT - 490,000+ Students | Wordwide Use 180 Countries |150+ Courses

"]

Students: 33369, Price: Free

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.

Microsoft Excel – Basic Data Visualization in Excel

Learn how to make great data visualizations in Excel

Created by Sean J. Thompson - Analyst

"]

Students: 21361, Price: Free

Welcome and thanks for your interest in my course!

Learn and master the art of creating a well-designed data visualizations and basic data analysis in Excel in this wide-ranging course. Forget the same old default Excel graphs that are boring and without personality - you can do better than that! This course will help your to go beyond the basics of graphing and teach you how to design graphs with your intended audience in mind. Not only will you learn how to create great graphs in Excel, but you will also learn how to organize your data before graphing to make the process easier and more productive.

A few of the topics we will cover in this course include:

  • How to determine if your data is graph-worthy
  • How to organize your data prior to visualization
  • Using vlookups to enhance your datasets
  • Designing your graphs for your audience
  • Using your visualizations outside of Excel
  • and a few other surprises....

This course is mostly video based, but does include all of the Excel spreadsheets used throughout the course. Use these spreadsheets and documents as a resource after you complete the course. They are yours to keep and use as a reference in the future.

This course will allow you to use the Excel skills you already have and take them to the next level. This course was designed with you - the student in mind. My goal is for you to be able to implement the skills your learn in this course immediately once you have completed it.

I hope you enjoy the course and that your use the skills learned to enhance your skillset and wow your boss and coworkers!

- Sean

How to Record and Run a Macro in 4 Easy Steps

Harness the power of automation in Excel by recording a Macro in 4 easy steps!

Created by Matthew Bernath - Entrepreneur | Engineer | CFA® charterholder

"]

Students: 14833, Price: Free

Learn how to harness the power of automation in Excel by recording a Macro in 4 easy steps!

Learn:

  • How to record and run a macro
  • When and why macros don’t always work
  • Why macros can save time, reduce errors and automate basic tasks
  • Why macros can also be very dangerous and what to be careful of when using macros

    Microsoft Excel – Basic Excel Formulas and Functions

    Master Mathematical, Logical, Lookup, Textual and Date-time Excel formulas with hands-on examples and practice sheets

    Created by Start-Tech Academy - 3,000,000+ Enrollments | 4+ Rated | 160+ Countries

    "]

    Students: 14797, Price: Free

    Start using Excel to its full potential to become proficient at your Excel tasks today!

    Either you're new to Excel, or you've played around with it but want to get more comfortable with Excel's advanced features. Either way, this course will be great for you.

    A Verifiable Certificate of Completion is presented to all students who undertake this Excel course.

    Why should you choose this course?

    This is a complete and concise tutorial on MS Excel formulas which can be completed within 1 hours. We know that your time is important and hence we have created this fast paced course without wasting time on irrelevant Excel operations.

    What makes us qualified to teach you?

    The course is taught by Abhishek and Pukhraj. Instructors of the course have been using Excel for over a decade.

    We are also the creators of some of the most popular online courses - with over 150,000 enrollments and thousands of 5-star reviews like these ones:

    I had an awesome moment taking this course. It broaden my knowledge more on the power use of Excel as an analytical tools. Kudos to the instructor! - Sikiru

    Very insightful, learning very nifty tricks and enough detail to make it stick in your mind. - Armand

    Our Promise

    Teaching our students is our job and we are committed to it. If you have any questions about the course content, practice sheet or anything related to any topic, you can always post a question in the course or send us a direct message.

    Download Practice files, take Quizzes, and complete Assignments

    With each lecture, there is a practice sheet attached for you to follow along. You can also take quizzes to check your understanding of concepts. Each section contains a practice assignment for you to practically implement your learning. Solution to Assignment is also shared so that you can review your performance.

    What is covered in this course?

    This course covers everything you need to crack Excel in the professional work place.

    Below are the Excel course contents of this complete and concise course on Microsoft Excel:

    • Introduction - In this video, the structure and contents of the course are discussed.

    • Mathematical Functions - This lecture covers Mathematical formulas such as SUM, AVERAGE,RAND, MIN & MAX, SUMPRODUCT.

    • Textual Formulas - This Excel lecture covers Textual formulas such as TRIM, CONCATENATE, SUBSTITUTE, UPPER & LOWER, LENGTH, LEFT, RIGHT & MID

    • Logical Formulas - This lecture covers Logical formulas such as AND & OR, IF, COUNTIF, SUMIF

    • Date-time (Temporal) Formulas - This lecture covers Date-time related functions such as TODAY & NOW, DAY, MONTH & YEAR, DATEDIF & DAYS

    • Lookup Formulas - This Excel lecture covers Lookup formulas such as VLOOKUP, HLOOKUP, INDEX, MATCH

    Microsoft Excel 2016 Skills and Tools Free

    Learn about the ribbon, cells, text tools, colors, tables, shapes, filtering and basic formulas such as SUM and AVERAGE.

    Created by Jevon Pletschke - Microsoft Office Teacher and Graphic Designer

    "]

    Students: 11647, Price: Free

    Learn about using the ribbon.

    Learn how cells work and how to use sheets.

    Learn about text tools and colors.

    Learn how to create a shape and add effects and text to it.

    Learn how to insert a table and filter and sort the information.

    Learn how to use basic formulas such as SUM and AVERAGE.

    Thanks so much for trying this course.

    Excel in Microsoft Excel 2013: Part I

    A course comprising of six parts with over ninety two-to-four minute videos each focusing on a very specific skill.

    Created by Gurmeet Grewal - Engineer, Supply Chain Manager, Coach, and Instructor

    "]

    Students: 10879, Price: Free

    This course covers the basics of Excel 2013 with over 90 short videos spanning over 6 parts. Each video will focus on a very specific skill with attached resources which will require your participation as the lesson is played out. These 2-to-6 minute lessons will help you, the student, to zoom in on exactly what you want to master, quickly and with ease. In Part I, you will learn 20 unique skills in Excel 2013, for example, in Lecture 9 you will go through the activity of Adding and Removing Worksheets in 2 minutes and 33 seconds, in Lecture 17 you will touch on the power of The Fill Handle in 5 minutes and 32 seconds and in Lecture 19 Changing Column Widths and Row Heights in 2 minutes and 48 seconds. The whole purpose of this course is to get you up and running in the shortest time. The lessons are succinct and to the point, without unnecessary clutter. Resources in the form of pre-formatted Excel documents have been made available for you to download and work along with the lectures. Each part of the course will cover an additional 20 to 24 unique skills, and by the end of Part VI, you will be able to handle all the basic requirements in working with Excel as well as setting yourself up for moving forward to the Intermediate/Advanced level content.

    Microsoft Excel – 333 Microsoft Excel Keyboard Shortcuts

    Learn the must know Excel keyboard shortcut to save time in Excel 2010, Excel 2013, Excel 2016, Excel 2019 & Office 365

    Created by MyExcelOnline John Michaloudis - Chief Inspirational Officer at MyExcelOnline

    "]

    Students: 7604, Price: Free

    You’re Just Seconds Away From Leveraging Microsoft Excel That Will Make It Possible For YOU To:

    1. Increase your Microsoft Excel & Pivot Table SKILLS and KNOWLEDGE within HOURS which will GET YOU NOTICED by Top Management & prospective Employers!

    2. Become more PRODUCTIVE at using Excel which will SAVE YOU HOURS each Day & ELIMINATE STRESS at work!

    3. Use Excel Pivot Tables with CONFIDENCE that will lead to greater opportunities like a HIGHER SALARY and PROMOTIONS!

    ----------------------------------------

    If you want to get better at Excel and stand out from the crowd to get the promotions or pay-rises that you deserve, then you are in the right place!

    This is the most comprehensive Excel Keyboard Shortcuts course ever made which has 333 short and precise tutorials.

    No matter if you are a Beginner or an Advanced user of Excel, you are sure to benefit from this course which goes through every single Excel shortcut that is available inside Microsoft Excel.  The course is designed for Excel 2007, 2010, 2013, 2016, 2019 and Office 365.

    If you learn only 5 Excel keyboard shortcuts and apply them each day, you will SAVE HOURS each week, which means you can go home early for once!

    There are 15 different modules so you can work on your weaknesses and enhance your strengths as well as practice files, quizzes and a FREE PDF Cheat Sheet listing all 333 Excel Keyboard Shortcuts for Windows & Mac that you can print off and keep. 

    Here are the main keyboard shortcut topics that we will cover in this course:

    1. Cell Formatting

    2. Drag & Drop

    3. Formulas & Functions

    4. Frequent  shortcuts

    5. Function Key   

    6. Making selections

    7. Ribbon Tab

    8. Cell Navigation

    9. Inside Ribbon 

    10. Macros & VBA

    11. Pivot Tables 

    12. Power BI 

    13. Power Pivot

    14. Other Shortcuts   

    ----------

    Look, if you are really serious about GETTING BETTER at excel and ADVANCING your Microsoft Excel level & skills...

    …saving HOURS each day, DAYS each week and WEEKS each year…

    ...If you want to improve your PROFESSIONAL DEVELOPMENT to achieve greater opportunities like PROMOTIONS, a HIGHER salary and KNOWLEDGE that you can take to another job…

    ...All whilst impressing your boss and STANDING OUT from your colleagues and peers...

    ...THEN THIS COURSE IS FOR YOU!

    Now you have the opportunity to join your fellow professionals who are taking this course and enhancing their Microsoft Excel skills!

    To enroll, click the ENROLL NOW button  (risk-free for 30 days or your money back), because every hour you delay only delays your personal and professional progress...

    ----------

    >> Watch our PROMO VIDEO above and a few of our FREE VIDEO TUTORIALS to see for yourself just how beneficial this course is and how you too can become better at Excel ***

    Microsoft Excel VBA Fundamentals – Learn Basic Coding Skills

    Microsoft Excel Professional Date Picker Series - Part 1

    Created by Sihle Mhlanga - Instructor and Accountant at Pundit Excel

    "]

    Students: 6769, Price: Free

    Microsoft Excel VBA Fundamentals course is designed to teach relevant basics for VBA programming.

    It is for those who aspire to become a VBA programmer and don’t know where to start. It is also suitable for those who automate their spreadsheets by record macros but seek to learn how to write the code themselves.

    This course will provide you with adequate knowledge and help you to take your first steps in writing a clean, easy to read and maintain VBA code. I will teach you how to do this step-by-step, and you will learn with understanding.

    So, this short course seeks to accomplish the following three goals:

    1. To provide you with a clear perception of the VBA developer environment

    2. To give you a proper understanding of how to work with the VB Editor tools to design a professional UserForm.

    3. To teach you how to write the code that will drive or manipulate the properties of the UserForm.

    Get a good start, acquire basic VBA coding skills for Microsoft Excel 2010, 2013, 2016, Excel 2019 and Office 365

    How to Build a VBA App in Just 30 Minutes

    Quick Start guide introducing lots of the VBA concepts required to build great apps

    Created by Craig Barry - UK Based Engineer

    "]

    Students: 6331, Price: Free

    Ever wanted to impress work colleagues with a user interface for your Excel documents? This free course walks you through the simple steps to achieve this.

    Now is your chance to shortcut the long and tricky tutorials online, simply follow along with a basic worked example and learn how you can setup your own user interface form in Excel.

    This course does not require any prior coding skills, you will need access to a computer running Microsoft Excel. You will also need to actually follow along and try out what you learn in order to get maximum value from this fantastic free course!

    Craig has been working with Excel for well over a decade. He started out automating tasks for senior colleagues as a student using simple macro recorders, since that point he has never stopped using and learning what Excel can do to make his life easier.

    A word of warning, although the course is delivered in 30 minutes, beginners will need to go back and re-watch the lessons presented in this course, as well as ask questions to the instructor – Craig. Learning a new skill is never easy, you didn’t learn to speak your native tongue in 30 minutes, and neither will you learn to code in 30 minutes- no matter how good the course is!

    Learn Microsoft Excel Charts (Basic to Advanced)

    Create awesome charts in Microsoft Excel

    Created by Rahim Zulfiqar Ali - Chief Executive Officer at Excel Basement (Private) Limited

    "]

    Students: 5989, Price: Free

    Learn to create awesome charts in Microsoft Excel. In Microsoft Excel, a chart is often called a graph. It is a visual representation of data from a worksheet that can bring more understanding to the data than just looking at the numbers. A chart is a powerful tool that allows you to visually display data in a variety of different chart formats such as Bar, Column, Pie, Line, Area, Doughnut, Scatter, Surface, or Radar charts. With Excel, it is easy to create a chart.

    Bulk Emails | Outlook automation using Excel VBA

    Automated Emails using Excel macros and Outlook

    Created by Kamal Girdher - Professional Trainer and Automation Expert

    "]

    Students: 3649, Price: Free

    Learn how to send customized emails using Excel vba and outlook. You can switch email accounts in between, customize subjects, body, attach customized files, add tables, use template for body and attachments and lot of other things.

    If this sounds interesting to you. Go ahead and enroll for this course.

    Happy Learning!

    Dynamic Array Formulas in Microsoft Excel

    Dynamic Array Formulas in Microsoft Excel

    Created by Rahim Zulfiqar Ali - Chief Executive Officer at Excel Basement (Private) Limited

    "]

    Students: 2301, Price: Free

    Dynamic Arrays are the biggest change to Excel formulas in years. Maybe the biggest change ever. This is because Dynamic Arrays let you easily work with multiple values at the same time in a formula. For many users, it will be the first time they understand and use array formulas.

    This is a big upgrade and welcome change. Dynamic Arrays will solve some really hard problems in Excel, and fundamentally change the way worksheets are designed and constructed.

    Project Based Excel Course + Practice Tests

    Sharpen and test your Excel skills

    Created by Brandon Brown - Programmer

    "]

    Students: 2234, Price: Free

    This Excel course shows you just enough training and practice problems to get a feel for Excel, then supplies you with exercises, projects, and practice tests.

    I do not spend much time going over things like the menus, basic arithmetic, or charts.  My course is aimed at giving you the core skills needed to do analysis in Excel and projects to get you business ready.

    Microsoft Excel _ MS Excel Basics & Excel PivotTables (2021)

    Become the master of Excel Pivot Tables | MS Excel | 2021 course

    Created by Mozn Akhourshiedah - Engineer, trainer, Entrepreneur

    "]

    Students: 1965, Price: Free

    Hello!

    This part of My Microsoft Excel series of courses focuses on the PivotTable part. PivotTables are very powerful tools inside MS Excel allows us to analyse huge datasets in a very efficient and short time.

    This course will help the learners to improve their skills and be familiar with Microsoft Excel. Now a days, Microsoft Excel is one of the most important and used program world wide.

    What makes me qualified to teach you?

    My name is Mozn and I've been a professional instructor for over a decade. Plus I'm the founder of Mezan Institute and the Author of a published book. I break down complex topics into an easy understandable messages, and help learners to absorbe the study material in an easy and engaging way. My courses are continuously receiving 5-star reviews like these from Microsoft Excel from Zero to Hero, 2020:

    ***** I realise after this quick and easy course that I new few parts of the excel but I am realy greathfull that Iadd few more when soon as I finsh this course. - Diana

    ***** Simple quick into to excel. Please add some more lectures similar to this :). - Geraldine

    ***** Yes, a good match, I do this every day, however, manually, but now I understand formulas much better, and it is less time consuming. - Dianne

    What is this Excel course about?

    In this guide to Microsoft Excel course, you'll not only learn all of the principles of Microsoft Excel, but also how to understand and become a star in your field.

    This course will cover Beginners, Intermediate and Advanced levels of Excel, including:

    • The basics of MS Excel

    • The powerful tool of PivotTables

    • Creating and Managing PivotTables

      Learn from someone who is currently working in the industry, who knows the most current teaching techniques.

    By the end of this course, your confidence as Data analyst using Excel will soar. You'll have a thorough understanding of how to use Excel in a business or personal environment.

    Go ahead and click the enroll button, and I'll see you in lesson 1!

    I wish you an enjoyable journey with us.

    Shukran! Mozn

    Microsoft Excel – Learn Quickly (Hindi + English)

    A Guide for Beginners to Pro (Dual Language)

    Created by Pavan Lalwani - Freelancer Instructor

    "]

    Students: 1417, Price: Free

    Teach Excel to Do Your Work FOR YOU. . .

    Microsoft Office is everywhere, installed on over 750 million computers, but most users only know how to set up a basic table or maybe even do a few formulas here and there.

    In my course, I teach you how to take Excel by the horns and make it do whatever you want, whenever you want. It can go through loads of information and create a printable report for you. You can make custom forms so that you can access, analyze, edit, or add new information quickly to your data tables/ worksheets.

    I'll show you the easiest tricks to learn this basic language in a fun, progressive method. Learn at your own pace. With each of my short, info-packed lectures, you'll learn another essential skill that you can immediately use. You'll find yourself handling these Automation tools instantly and in any spreadsheet you already use every day. If there's one thing I'm good at - and my students are good at - it's AUTOMATION.

    My motto is, "If I'm not making everybody's job easier, quicker and more enjoyable, I don't deserve to have this job" - and that's what I live by.

    Take this course and access your true potential.

    Oh, and I want to be the first to hear about your New Raise you get once you're making Excel Programs and running everything on autopilot for your co-workers!

    Here's what some of the students are saying:

    “I love this course. Extremely easy to follow along. If you are looking to learn more about Excel this is it!” - Rajesh

    “Loving this course! The information is presented quite clear and concise, and it is a really great way of learning VB really fast, yesterday I was a total ignorant of the subject. Today I programmed my first macro and cannot wait to learn more.” - Monica

    “I had experimented with VBA previously, but I really feel like this course is exactly what I needed to take my Excel knowledge to the next level. In only 2 weeks I've improved my reporting exponentially and it's all thanks to this course!" - Nitin

    “You can't go wrong with Daniel Strong!” - John

    “Well explained, easy to understand lectures. Enjoyable and informative videos.” - Ajinkya

    “Very clear explanations broken down in short videos. Daniel goes at a slow pace that is easy to follow and understand, even for people with no programming experience.” - Ritu

    Best course on Excel ever taken. Thanks a lot!” - Rita

    “This is an excellent course!!! There's a lot of good, useful "stuff" here. The examples are practical and real-world!” - Sonali

    “Wow, I thought I knew a little bit about Excel but clearly I had only seen the tip of the iceberg. This course has opened my eyes to the true power  of Excel. Great course, fantastic instructor.” - Arpika

    “By large and far, one of the best step by step guide to VBA programming I have ever seen. I have been playing around with VBA for over a year now, have watched countless videos and have read numerous articles and "How-to" guides, but I have never seen something this complete, this throughout. I am amazed at how little I actually new about the Excel world. Thanks a million!” - Karthik

    “Everything I have been looking for, you would have to buy multiple books for this level of instruction!” - Sunny

    "Excellent VBA basic to advance tutorial." – Jeet

    “This course is good for beginners and for experienced programmers. Experienced programmers may want to skip through some sections on basics, but it is good to see how the basics work in the context of and excell worksheet. He goes over different events and triggers (like buttons) to execute code. This is a really good course if you plan to do some pretty complex vba code with forms and reports.” - Anubhav

    “Very helpful if you do any type of data analysis.” – Pankaj

    “I think this is an excellent gateway to the tools we need to use going forward. I like the
    hands on nature.”
    – Nancy

    “Much better than other classes and seminars. Great course.” – Manpreet

    “The instructor made Excel easy and straight forward to use.” – Rupali

    “Very thorough and practical.” – Tina

    Excel Pivot Tables | A Quick Start Guide

    Learn Excel Pivot Tables in a easy to understand course...

    Created by Dave McCubbin - Training Alchemist

    "]

    Students: 1138, Price: Free

    Pivot Tables are an extremely powerful tool in Excel and a skill that employers crave!  If you are brand new to Pivot Tables than this course is for you. And by chance you've been working with them for awhile you may benefit as well.  :)

    This course starts by giving you the fundamentals of pivot tables and presents the topics in short, fun, easy to follow videos. From there we move into working with calculations/ formulas, the ever cool slicer, charting and conclude the class with some fun miscellaneous topics.

    Please note: this course has been designed to provide as much information about Excel Pivot tables as the time constraints allow.  Granted many topics can be explained much more in-depth, yet that is not how this course was designed.  Rather the goal was to be as comprehensive, and to cover as much ground as possible.  :)

    By the way did you know that only 5% of excel users know how to make Pivot Tables?*  So you are about to join an exclusive club! :)


    Who will benefit from this course?

    If you use large lists of data and are interested in learning the story behind the data then Pivot Tables are the way to go! Excel Pivot Tables provide quick, accurate and intuitive insight into your data and can provide answers to the even the most complicated of analytics tasks.


    Do you need previous experience with Excel to take this course?

    Not really.  Even though Pivot Tables are often promoted as an intermediate/ advanced topic in Excel, the key is to recognize everything in the Excel curriculum is topical, not progressive- so the order in which you learn things is up to you. Therefore if you have experience great, if not as long as you...

    1. Can select cells on a spreadsheet

    2. Have a basic understanding of formulas in Excel

    3. Able to navigate between sheets

    4. Somewhat familiar with sorts and filters (if not, that's okay since we give a brief explanation)

    All things considered... you'll be just fine.  :)

    Technical Requirements

    • This course was created using Excel 2019. Yet can be used with Excel 2016/ 2019 or Office 365 (primarily for PC/Windows)

    • Mac users are welcome, but be aware your screen will be somewhat different

    Course Progression

    • Overview of source data and basic Pivot Table fundamentals

    • Learning simple then advanced formulas used within Pivot Tables

    • What are slicers and how to use them, including how to connect slicers to multiple Pivot Tables (yep... you read that right.)
      Pivot charts

    • Concluding with some miscellaneous topics including filter reports and the GETPIVOTDATA function


    Conclusion

    Let’s face it being able to read and analyze data in today’s word is a highly sought after skills and being competent with Pivot Tables will help move you to the front of the proverbial line.

    So if you're looking for a Pivot Table fundamental class, wanting to broaden your existing skills in Excel, or have a need to develop your analytical skills- this class has something for you because knowing Pivot Tables can give you the extra advantage in developing your career.

    * Source:  Power Pivot and Power BI: The Excel User's Guide to DAX, Power Query, Power BI & Power Pivot in Excel 2010-2016; Collie, Singh 2016