Microsoft Excel is the most widely used business software in the world and one of the most in-demand skills across virtually every industry and job role. Whether you are a student, a small business owner, a career starter, or a professional looking to formalize your skills, this program gives you the practical Excel competency that employers consistently look for.
Microsoft Excel: Learn with Projects is a beginner-friendly program that teaches Excel entirely through hands-on, project-based learning. Across 12 guided projects, you will build real skills by doing, not just watching. You will start from the very basics of creating and navigating a spreadsheet, then progressively develop competency in formulas and functions, data sorting and filtering, PivotTables and charts, conditional formatting, dashboard creation, and data analysis. You will also learn how to use ChatGPT alongside Excel to automate data tasks including standardizing datasets, classifying data, and conducting sentiment analysis — skills that reflect how professionals actually work today.
Every project is completed using the free online version of Microsoft Excel through Microsoft Office 365, so no software purchase is required to get started.
By the end of the program, you will be able to build functional spreadsheets, analyze data confidently, create visual dashboards, and apply AI tools to real Excel workflows.
Overview
Syllabus
- Course 1: Getting Started with Microsoft Excel
- Course 2: Introduction to Microsoft Excel
- Course 3: Using Basic Formulas and Functions in Microsoft Excel
- Course 4: Excel for Beginners: Advanced Functions
- Course 5: Introduction to Data Analysis using Microsoft Excel
- Course 6: Create Charts and Dashboards Using Microsoft Excel
- Course 7: Create a Project Management Tracker using Microsoft Excel
- Course 8: ChatGPT for Beginners: Save time with Microsoft Excel
Courses
-
Have you started using spreadsheets like Excel and want to learn how to write formulas and functions to perform simple data analysis? In this project, you will learn about the general format for writing formulas and functions in Excel to perform analysis on the sales data from a sample company. In this analysis, you will calculate total sums of profits, you will learn how to use functions to analyze the popularity of the items sold and you will also learn how to calculate averages and percentages of monthly profits. Throughout the project, you will work through some examples that will show you how to apply the formulas and functions you have learned.
-
At the end of this project, you will be able to start a simple spreadsheet in Microsoft Excel. Being able to use Microsoft Excel will allow you to simplify many of your daily tasks at work but also at home. There is no limit to what you can use Microsoft Excel for, you can use it to plan the annual budget of your business, you can use it to track business expenses but you can also use it simply to keep inventory of all the books you own.
-
In this project, you will learn the foundation of data analysis with Microsoft Excel using sales data from a sample company. You will learn how to use sorting and filtering tools to reorganize your data and access specific information about your data. You will also learn about the use of functions like IF and VLOOKUP functions to create new data and relate data from different tables. Finally, you will learn how to create PivotTables to summarize and look at comparisons within your data. These skills will help you efficiently perform data analysis on many different types of data and give you the foundation to expand your toolbox as you explore other strategies for data analysis.
-
In this project, you will learn how to create charts in Microsoft Excel to analyze sales data of a sample company. You will learn how to create PivotTables to assess different aspects of the sales information, and represent the information from the tables as line, bar, and pie charts. When creating the charts, you will learn how to format them so they are easily interpreted and you will then assemble the charts in a dashboard to provide a global picture of the sales data.
-
As a small business owner, budgets are often tight for the "extras." Often times, this means that some of those high-value marketing tools cannot be offered. Small business owners should turn to free or low-cost alternatives. An easy-to-use and manageable alternative is a free online version of Microsoft Excel from Microsoft Office 365. In this project, you will learn how to create a simple project management tracking sheet. At the end of this project, you will have the Excel project management tracking template for the next presentation of your development project.
-
By the end of this project, you will learn how to create an Excel Spreadsheet by using a free version of Microsoft Office Excel. Excel is a spreadsheet that works like a database. It consists of individual cells that can be used to build functions, formulas, tables, and graphs that easily organize and analyze large amounts of information and data. Excel is organized into rows (represented by numbers) and columns (represented by letters) that contain your information. This format allows you to present large amounts of information and data in a concise and easy to follow format. Microsoft Excel is the most widely used software within the business community. Whether it is bankers or accountants or business analysts or marketing professionals or scientists or entrepreneurs, almost all professionals use Excel on a consistent basis. You will learn what an Excel Spreadsheet is, why we use it and the most important keyboard shortcuts, functions, and basic formulas.
-
This 1-hour, project-based course introduces learners to more-advanced spreadsheet functions. We’ll be using Excel on the Web in this project, which is the free spreadsheet program offered by Microsoft. However, all of the concepts that you will learn in this project will be applicable to other spreadsheet programs, such as LibreOffice Calc and Google Sheets. We will cover the following concepts in a hands-on manner: - Advanced conditional functions: countif, sumif, averageif - Easy searching and matching of data with reference functions: vlookup, xlookup, index & match Please Note: If you don't have a free Microsoft account, you will need to create one to be able to complete the content.
-
Take your Excel productivity to the next level by learning how to leverage the capabilities of ChatGPT, regardless of whether you are an Excel amateur or seasoned power-user. Over the span of this course, you will learn how to effectively standardize, extract, classify, and generate data through the combined power of Excel and ChatGPT. Through hands-on projects and real-world scenarios, you will gain practical experience in creating standardized datasets, writing formulas for data cleaning and classification, extracting text from URLs, conducting sentiment analysis, and generating dummy data for surveys. This course offers a unique opportunity to explore the potential of combining AI capabilities with common business challenges faced within Excel. Basic knowledge of Excel is recommended to make the most of this course.
Taught by
Edward Falzon , Jan Demiralp, Kim Webb, Paula Del Rey and Summer Scaggs
Related Courses
Related Articles
-
11 Best Power BI Courses for 2026 (Free + Paid)
-
7 Best Microsoft Access Courses for 2026
-
8 Best Tableau Courses for 2026
-
14 Best Excel Courses 2026: Picked from 2,000+ (Free & Paid)
-
15 Best R Programming Courses and Books for 2026 (Free & Paid)
-
10 Best MATLAB Courses for 2026: Algorithms and Applications
