verified
Verified Information • Last Updated Mar 2026
Preparing Data for Analysis with Microsoft Excel
This course forms part of the Microsoft Power BI Analyst Professional Certificate. This Professional Certificate consists of a series of courses that offers a good starting point for a career in data analysis using Microsoft Power BI.
No prior skills are needed to be successful in this course.
In this course, you’ll learn how to make use of Excel in business scenarios for data analysis. You’ll also learn how to utilize formulas and functions for data analysis.
Specifically, this course will help you gain knowledge and skills for preparing data for analysis using Microsoft Excel and take you one step closer to becoming a Microsoft Power BI Analyst.
After completing this course, you’ll be able to:
• Create data in Microsoft Excel and prepare it for data analysis.
• Make use of common formulas and functions in a worksheet.
• Prepare Excel data for analysis in Power BI using functions.
Duration
7 Months
Institution
Microsoft
Format
Online
Eligibility Criteria
school
Academic Foundation
A recognized Bachelor’s degree or high school equivalent required for admission into Microsoft.
language
Language Proficiency
English proficiency required. IELTS, TOEFL, or standard medium-of-instruction certificates accepted.
Detailed Fees Breakdown
Base Tuition Fee
$154
Total Est. Investment
$154
Scholarships and early-bird waivers may apply. Contact admissions for exact institutional fees.
Academic Trajectory
Program Outcome
Graduates of the Preparing Data for Analysis with Microsoft Excel program at Microsoft are equipped with global perspectives, ready to excel in international markets and top-tier career opportunities.