fbpx

22 Best Free Online Excel Courses

Our Favorite Free Online Excel Course

Excel Skills for Business Specialization

Excel Skills for Business Specialization

This course is a beginner level in English and has subtitles in 9 different languages. Excel is one of he most fundamental and essential skills in business person should master as if is applicable anywhere and everywhere throughout the world. If you add this skill to your portfolio you will powerfully boost your employability. In the US alone millions of job ads require this skill. It has been shown that digital skills lead to higher income and better employment opportunity at a time when digital is almost everything. Completing this specialization will give you a head start above others. In this specialization you will be taken from elementary to advanced excel skills for business. You will learn to design sophisticated spreadsheets including dashboards, and performance of complex calculations using advanced excel features and techniques. You will also learn to manage and extract information from data sets as well as present the data and further, you will acquire the skills to validate data and prevent errors, create automation and apply advanced formulas and conditional logic for decision 

making. Lastly, you will assemble spreadsheets that will help with forecasting and modelling of data.

This is an applied learning project where you will solve business problems as you apply excel skills and techniques learnt. You will use excel workbooks and data sets with examples and practical challenges, so giving learners opportunity to practice new excel skills and new ways to apply new found knowledge. Skills Acquired: Data Validation, Microsoft Excel, Microsoft Excel Macro, Pivot Table, Graphs, Spreadsheet, Chart, Concatenation, Consolization, Pivot Chart, Lockup Table, Microsoft Excel Vba. Duration: Approx 6 months, 5 hours per week - 4 courses. Rating: 4.9

What are the Top Free Online Excel Courses

After much research on all online Business Courses on offer, we have found the top 22 Excel courses to make it easier for you to choose

22 Interweaving Tables, References, and Links in Excel

Interweaving Tables, References, and Links in Excel 

This course is in English and is intermediate level. The course is conducted on a split-screen video. Excel is highly versatile and has application across most industries, but it is very precise on how formulas need to be written to reference images, cells, sheets, and other files. Here you will learn navigating all the connections that excel is capable of. Your instructor will teach you step-step how to set up a spreadsheet, create links within a sheet, connect multiple sheets, reference different files and then put it all together. Skills Acquired: Connect Sources with Excel, Links, and Connect Sheets, 

Duration: 1 hour

21 Charts, Pictures, Themes and Styles in Microsoft Excel

Charts, Pictures, Themes, and Styles in Microsoft Excel

The course is a beginner in English, it is taught by means of a split-screen video and no download is required. By the end of the project you will create a workbook with charts, pictures, themes and styles which will help you manage your spreadsheet information. You will learn step-by-step through your instructor how to create a free Microsoft 365 account for your excel, add a table, choose cell style, select a theme, create charts, and insert pictures. Skills Acquired: Create Charts, Create Tables, Themes, and insert Pictures. Duration: 1.5 hours

20 How to Use Lookup Reference Math and Text Functions in Excel

How to Use Lookup reference Math and Test Functions in Excel

The course is in English and is an intermediate level. It is taught through split-screen video, no download is required. This course will teach you how to use lookup reference, math and text functions in a spreadsheet using Microsoft Excel. Your instructor will teach you to use lookup references like VLookup and then HLookup formulas, how to use the lookup references to match and choose formulas. You will also learn how to use math function Sum and Average in excel as well as CountA and CountF and text functions. Skills Acquired: VLookup, HLookup, Match, Sum, Average, CountA, and CountF. Duration: 1.5 hours. Rating: 4.1

19 Getting started with Microsoft Excel

Getting started with Microsoft excel

The course is in English and has a split-screen video instruction. You will learn to use Microsoft Excel and all the essential tools. You will be completing different tasks to help you understand the use of his tool. You will explore the many non-visible tools and get to know several formula options as well as how to accommodate these froms to your wishes with visibility. You will learn different ways to organize content, create worksheets and calendars of organization, inventories, daily, weekly and monthly expenses and more. Skills Acquired: Table Design, Microsoft Excel, Formulas at Excel, Fill Tables in Microsoft Excel, and Create a Table. Duration: 1 hour. Rating:4.3

18 Creating a Budget with Microsoft Excel

Creating a Budget with Microsoft Excel

The course is in an intermediate level in English. The instruction is through a split-screen video with no downloads required. At the completion of this project you will have learnt to create a budget template in excel. You will learn to create a budget both automatically and manually in this step-by-step instruction video. By using excel the burden of budgeting will be reduced and you will enjoy an improvement in accuracy, while scaling budgeting and making record keeping and expenditure tracking easier. You need not have experience in excel as you will be shown how to use templates provided in excel and the use of simple formulas to create any type of budge. The course will cover creating a budget using pre-loaded templates, creating a budge in excel from a blank spreadsheet and creating a graph to present your budget and track categories of your expenditure. Lastly, you will learn how to expand the information to make a workbook for the entire year budget.

Skills Acquired: Microsoft Excel and Budget. Duration: 1.5 hours. Rating: 4.4

17 Data calculations in Microsoft Excel

Data calculations in Microsoft Excel

This course is in English and a beginner level course. In this course you will create a table with data that you will later utilize to calculate sums, averages, percentages and also calculate with specific criteria. These new skills will assist you to manipulate data and operate using formulas which will assist in making effective management decisions in the future. The course will teach you how to use the sum and average functions in Microsoft Excel and how to use the sum and average functions with a criteria input in Microsoft Excel. You will also use Networkdays and percentage functions in Microsoft Excel as well as perform calculations with criteria input in Microsoft Excel. Skills Acquired: Microsoft Excel and Calculations. Duration: 1.5 hours. Rating: 4.5

16 Create Charts and Dashboards Using Microsoft Excel

Create Charts and Dashboards Using Microsoft Excel

The course is in English and is an intermediate level. The instruction is via split-screen video and no download is required. You will learn how to create charts in Microsoft Excel to analysis to data of a sample company. You will learn the creation of Pivot Tables, to asses different aspects of the information and to represent the information as Line, Bar, and Pie Charts. While creating the charts you will be shown how to format them to make them easily read and then assemble them in a dashboard to provide a global picture of the data. Through the course you will be taught the creation of Pivot Tables in Microsoft Excel, create and format a Line Chart, create and format a Bar Chart and a Pie Chart and then to create a dashboard which comprising charts and tables. Skills Acquired: Line Chart, Data Analysis, Pie Chart, Pivot Table, and Bar Chart. Duration: Approx 2 hours. Rating: 4.5

15 Create a Simple Gantt Chart using Microsoft Excel

Create a Simple Gantt Chart using Microsoft Excel

This course is in English and a beginner level. The insturction is by means of split-screen video with no download necessary. This course will take you through step-by-step instruction to create a Gantt Chart to manage your upcoming project. THis Gantt Chart will give you a deeper understandinlg of how Bar Charts and Conditional Formatting work. This guide will use some excel functions to gujide you in using Condional Formatting to make our Chart and Data interactive. FInally, this Chart will enable you to track multiple taske that run conc;urrently and incorporates featlures like the Weekly View Bar to organize dates more effectively. By the end of the course you will know how to analysis Gantt Chart, how to set up yur project data, formatting a timeline, adding bars and highlighting today's date and incorporation of additional features. Skills Acquired: Gantt Chart, Microsoft Excel, Conditional Formatting, and Excel Functions. Duration: Approx 2 hours. Rating: 4.6

14 Introduction to Microsoft Excel

Introduction to Microsoft Excel

This is an intermediate course in English with a split-video instruction. This course will teach you how to create an excel spreadsheet and how to move around the spreadsheet for data entry. Excel consists of cells which can be used in the building of functions, formulas, tables and graphs to easily organize and analysis large quantities of data and information. Excel comprises of rows which are represented by numbers and columns which are represented by letters. Excel is widely used in the business community be it corporate, marketers, analysts, scientists and entrepreneurs . You will be shown step-by-step the layout, navigation, and ribbon and create a spreadsheet of information from which you will use formulas to analysis your data and format your data. Skills Acquired: Formatting Excel Spreadsheets, Creating Basic Formulas in Excel Spreadsheets, Creating Excel Spreadsheets, Manoeuvring around Excel Spreadsheets. Duration: Approx 1.5 hours. Rating: 4.6

13 Excel Modelling for Professionals:Best Practices & Pitfalls 

Excel Modelling for Professionals:Beat Practices & Pitfalls

The course is in English and is an intermediate level course. For those who already understand excel this course will elevate your models to improve clarity, lifespan, and transferability. It will help you to reduce mistakes and encourage consistency. The modules consist: of A Foundation for Better Spreadsheet, Good use of Formulas and Functions which is the life blood of excel, Spreadsheet structure and logical flow, and Finishing Touches. The means of instruction are by videos and readings. Skills Acquired: Financial Modelling, Microsoft Excel, Excel Modelling . Duration: Approx 17 hours over 4 weeks. Rating: 4.7

12 Conditional Formatting,Tables and Charts in Microsoft Excel

Conditional Formatting, Tables and Charts in Microsoft Excel

The course is in English and is an intermediate level course with instructions provided by split-screen video. You will be taught how to analyse data and identify trends using then tools in Microsoft Excel. Conditional formatting and charts are the 2 main tools in excel that highlight and represent data in a visual format. Conditional formatting defines rules, highlights cells using a colour scales and icons to assist with your data analysis to identify trends and outliers. Thereafter, Pivot Tables will create summaries of data that focuses on particular relationships that you will represent in the form of a Line Chart and Column Chart. Your instructor will take you through the course step-by-step: Converting data into a table, exploring table functions and tools, the use of conditional formatting to explore and analyse data, create :Pivot Tables and Line Charts to analyse sales trends and finally, to create Pivot Tables and Column Charts to asses sales persons progress. Skills Acquired: Graphs, Spreadsheet, and Data Analysis. Duration: Approx 2 hours. Rating: 4.7

11 Create a Project Management Tracker using Microsoft Excel

Create a Project Management Tracker using Microsoft Excel

This course is in English and is a beginner level. Taught by a split-screen video. Small businesses are often short of cash for their extras so alternative low cost options need to be found. This can be found in Microsoft Excel and in this course you can track your businesses progress by creating a simply Project Management Tracking sheet. You will learn step-by-step to share hour spreadsheet and organize the sections of the tracker, use Project Management skills to develop a Project Tracking Spreadsheet, how to add static content and drop-down menus and finally, how to conditionally format and hyperlink to the project tracker. Skills Acquired: Project Management, Spreadsheet, and Project Planning. Duration: Approx 2 hours. Rating: 4.7

10 Everyday Excel Specialization

Everyday Excel Specialization

In English this is a beginner level course. It has 8 subtitles in different languages. This specialization is for those who have a little knowledge or no knowledge in Microsoft Excel but would like to learn from beginner to expert level. The first 2 courses will teach you the basics of excel through screen casts and assignments and finally, in part 3 you will complete several open ended projects. This final part places huge importance on an array of new functions which are new to Office 365 and has revolutionized the way in which calculations are performed. The applied learning project in part 3, you will choose 3 introductory projects out of 5, 3 intermediate projects out of 6, and 3 main projects out of 5. Students will therefore tailor their experience through their chose of projects. Screencasts will show hints and previews for each project to guide you. Skills Acquired: Spreadsheets, Microsoft Excel, Problem Solving, Project, Computing, Data Management, Real World, and Real World Projects. Duration: Approx 4 months, 4 hours per week - 3 courses. Rating: 4.7

09 Introduction to Data Analysis Using Excel

Introduction to Data Analysis Using Excel

The course is in English and has subtitles in 9 different languages. This is an introductory course giving you a working knowledge of excel to get you familiar with it for more advanced topics. This course is ideal for those with very little functional knowledge or if you use excel regularly but at a surface level, and wish to improve your skills. The course takes you from basic actions to manipulating and organizing data to some of the more advanced capabilities. You will learn the functionality using easy to understand examples demonstrated in such a way that you will easily understand and apply them. Please note Windows version of Microsoft Excel should be 2010 or later. Skills Acquired: Lookup Table, Data Analysis, Microsoft excel, and Pivot Tables. Duration: Approx 20 hours over 4 weeks

Rating: 4.7/93%

08 Everyday Excel, Part 1

Everyday Excel, Part 1

This is a beginner level course in English. There are subtitles in 8 different languages. It is course 1 or 3 in the Everyday Excel Specialization. No experience is required and while the course is meant for beginners, advanced users will learn some new skills and tools. In this course you learn to navigate or work around within excel, learn how to edit and format worksheets, learn to implement functions including financial, logical and text functions, how to manage data sets, to filter, remove duplicates, consolidate data, sort data, and validate data, and finally, how to visualize data through Scatterplots =, Column Charts and Pie Charts. The course is organized into 5 weekly modules. Skills Acquired: Data Management, Spreadsheets, Microsoft Excel, Problem Solving, and Real World. Duration: Approx 25 hours over 5 weeks. Rating: 4.7/94%

07 Excel Basics for Data Analysis

Excel Basics for Data Analysis

This course is in English and is a beginner level. It has subtitles in 8 different languages. This course will give you basic knowledge for using excel to do data analysis. It covers some basic steps in working with excel and how to use them in processing and analyzing data. The course will instruct through medium of videos, demonstrations, and examples then followed by step-step instructions to apply and practise on your spreadsheet. If you are wanting to take up data analysis or data science as a career then this course is suitable for you. You will gain experience in cleansing and wrangling data using functions and the analyse using filtering, sorting and creating Pivot Tables. In this course the emphasis is placed on practicing and applied learning to give you hands on experience and to enable you to understand the importance of spreadsheets. You do not need any prior experience in excel or coding. No downloads are required. Skills Acquired: Data Science, Spreadsheet, Microsoft excel, Data Analysis, and Pivot Table. Duration: Approx 12 hours over 5 weeks. Rating: 4.7/97%

06 Finding, Sorting, & Filtering Data in Microsoft Excel

Finding, Sorting, & Filtering Data in Microsoft Excel

The course is an intermediate level in English.  Offered as a split-screen video instruction. This project teachers the use of searching, sorting, and filtering as applied in excel, which will make data more useful in making effective business decisions. You will learn to use isolated data required which can then be sorted into a sequence that can turn data into the information required for making decisions. You will be shown a step-by-step to use the find and select function to locate specific cell values and then replace it with another value, you will be shown how to use the sort feature to arrange rows in ascending and descending order. Further, you will shown the filter features to select only rows that meet the desired criteria. Finally, you will be shown how to calculate a new field and apply a filter to sort the result of the calculations. Skills Acquired: Regular Expression (REGEX), Filtering Data, Microsoft excel, Spreadsheet Software, and Sorting. Duration: Approx 1 hour. Rating: 4.8

05 Excel Skills for Data Analytics and Visualization Specialization

Excel Skills for Data Analytics and Visualization Specialization

This course is an intermediate level so you should be familiar with excel. The course has subtitles in 8 different languages. With the amount of data available and there being so many sources for it the ability to quickly and accurately analyse the data has become extremely important. For this reason data analytics and visualization have become the 2 most sort after skills with strong growth prospects. This course will develop your analytical and visualization skills so as to improve not only your work performance but to also enhance future job prospects. This course is for those in business and data analysis who would like to master advanced excel and beginner Power Bi. After completing this specialization you will bring data to life using advanced excel, visualizations, and powerful automation features. You will have the tools for transforming, linking, and analyzing data .Further, you will use a wide range of charts and create interactive dashboards and finally, you will explore Power Pivot, Get and Transform, and DAX. Applying the power of an underlying data base engine, the row limitation in excel will be removed to enable complete automation of data transformation, creating data models,, to link data, and open the gateway to Power Business Intelligence. There is an applied learning project where you will wrangling data into shape, create visualizations, and prepare dashboards as well as to create a data workflow to automate your analysis. The 3 courses are: Excel Fundamentals fro Data Analysis, Data Visualization in Excel, and Excel Power Tools for Data Analysis. Skills Acquired: Data Analysis, Microsoft Excel, Data Visualization (DataViz), Data Cleansing, Big Data, and Power Bi

Duration: Approx 4 months, 3 hours per week - 3 courses. Rating: 4.8

04 Excel Skills for Business: Intermediate II

Excel Skills for Business:Intermediate II

This course is an intermediate level and is in English, it has subtitles in 8 different languages. This course will take you deep into the most powerful features in the excel portfolio,. When you have completed the course you will be able to check for and prevent errors in spreadsheets, create powerful automation, apply advanced formulas and conditional logic to enable you to make informed business decisions, and finally you will be able to create spreadsheets that help forecast and model data. The modules that you will cover in this course include: Data Validation, Conditional Logic, Automating Lookups, Formulating, and Protection, Data Modelling, Recording Macros then a final assessment. Skills Acquired: Lookup Table, Microsoft Excel Vba, Data Validation, and Microsoft Excel Macro. Duration: Approx 29 hours over 6 weeks. Rating: 4.8/97%

03 Excel Skills for Business: Intermediate; 

Excel Skills for Business: Intermediate I

This course is an intermediate level in English with subtitles in 9 different languages. Handling excel confidently is a very valuable assets in your employability Curriculum Vitae. With literally millions of employers seeking these digital skills. This is the second course of the excel specialization which will teach you a range of skills and techniques which will become part of your everyday use of excel. Your advanced skill set which you will acquire will assist you in managing large data sets and creating meaningful reports, which will add a layer of automation and efficiency to your everyday tasks in excel. The modules will cover: Working with Multiple Worksheets and Workbooks, Text and Date Functions, Named Ranges, Summarizing Data, Tables, Pivot Tables, Charts and Slicers and a final assessment. Skills Acquired: Concatenation, Microsoft Excel, Consolization, Pivot Table, and Pivot Chart. Duration: Approx 28 hours over 6 weeks. Rating: 4.9/97%

02 Excel Skills for Business: Essentials

Excel Skills for Business: Essentials

This course is in English and has subtitles in 9 different languages. It is a beginner course. You will learn the basics of Microsoft Excel and expertly navigate a spreadsheet and perform calculations with formulas and functions, be able to format spreadsheets and create visualization of data through charts and crafts. This course will give you a solid foundation thus giving you the confidence to be an excellent user and develop advanced skill in the other courses. Applied learning is the medium of instruction so you will solve a wide range of problems as you apply excel skills and techniques. The course utilizes downloadable excel workbooks and data sets, with examples and exercises. The modules cover: Critical Core of Excel, Performing Calculations, Formatting, Working with Data, and Printing and charts. Skills Acquired: Graphs, Spreadsheets, Microsoft Excel, and Chart. Duration: Approx 26 hours over 6 weeks. Rating: 4.9/98%

01 Excel Skills for Business Specialization

Excel Skills for Business Specialization

This course is a beginner level in English and has subtitles in 9 different languages. Excel is one of he most fundamental and essential skills in business person should master as if is applicable anywhere and everywhere throughout the world. If you add this skill to your portfolio you will powerfully boost your employability. In the US alone millions of job ads require this skill. It has been shown that digital skills lead to higher income and better employment opportunity at a time when digital is almost everything. Completing this specialization will give you a head start above others. In this specialization you will be taken from elementary to advanced excel skills for business. You will learn to design sophisticated spreadsheets including dashboards, and performance of complex calculations using advanced excel features and techniques. You will also learn to manage and extract information from data sets as well as present the data and further, you will acquire the skills to validate data and prevent errors, create automation and apply advanced formulas and conditional logic for decision 

making. Lastly, you will assemble spreadsheets that will help with forecasting and modelling of data.This is an applied learning project where you will solve business problems as you apply excel skills and techniques learnt. You will use excel workbooks and data sets with examples and practical challenges, so giving learners opportunity to practice new excel skills and new ways to apply new found knowledge. Skills Acquired: Data Validation, Microsoft Excel, Microsoft Excel Macro, Pivot Table, Graphs, Spreadsheet, Chart, Concatenation, Consolization, Pivot Chart, Lockup Table, Microsoft Excel Vba. Duration: Approx 6 months, 5 hours per week - 4 courses. Rating: 4.9

Subscribe
Notify of
0 Comments
Inline Feedbacks
View all comments
© Maximal Media FZE LLC • All Rights Reserved
0
Would love your thoughts, please comment.x
()
x