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.
应用的学习项目
Throughout this program, you will complete 12 hands-on guided projects using Microsoft Excel. You will create your first spreadsheet and learn navigation, keyboard shortcuts, and basic formulas. You will write SUM, SUMIF, and AVERAGE functions to analyze sales data, and apply Find, Sort, and Filter tools to reorganize datasets for decision-making. You will use IF and VLOOKUP functions to create new data and relate information across tables, and build PivotTables to summarize and compare datasets. You will create line, bar, and pie charts, apply conditional formatting with color scales and icons to identify trends, and assemble charts into a complete sales dashboard. You will build a project management tracker with dropdown lists and conditional formatting, and use ChatGPT to standardize data, extract text from URLs, and conduct sentiment analysis within Excel. Each project produces a functional, real-world Excel artifact.
