Microsoft Excel for Beginners
Build Microsoft Excel skills for the workplace, from spreadsheet fundamentals to advanced data analysis. Designed for beginners with no prior Excel experience, this Microsoft Professional Certificate helps you organize, analyze, and communicate data in real-world business settings.
You’ll begin with Excel formulas, functions, tables, data validation, and conditional formatting. As you progress, you’ll use SUMIFS, COUNTIFS, AND, OR, VLOOKUP, and XLOOKUP to calculate, organize, and retrieve information. You’ll also create PivotTables, Pivot Charts, slicers, charts, and dashboards to identify trends and communicate insights.
Build advanced data skills with Power Query to import, clean, and combine data, and Power Pivot and DAX to create data models and perform sophisticated analysis. You’ll also learn how Copilot for Excel and ChatGPT can support analysis, formulas, and everyday Excel workflows.
Beyond technical skills, you’ll learn to collaborate and co-author workbooks, manage files, and apply practical governance practices. Hands-on, scenario-based projects give you opportunities to apply your skills to realistic business problems.
In your final project, you'll apply your Excel skills to a realistic business scenario and finish with a polished, portfolio-ready workbook that demonstrates your ability to turn business data into actionable insights.
Status: Exploratory Data Analysis
Exploratory Data AnalysisStatus: Strategic Decision-Making
Strategic Decision-MakingBeginner·Professional Certificate