Microsoft - Preparing Data for Analysis with Microsoft Excel
- Offered byCoursera
Preparing Data for Analysis with Microsoft Excel at Coursera Overview
Duration | 4 hours |
Start from | Start Now |
Total fee | Free |
Mode of learning | Online |
Difficulty level | Beginner |
Official Website | Explore Free Course  |
Credential | Certificate |
Preparing Data for Analysis with Microsoft Excel at Coursera Highlights
- Flexible deadlines Reset deadlines in accordance to your schedule.
- Shareable Certificate Earn a Certificate upon completion
- 100% online Start instantly and learn at your own schedule.
- Coursera Labs Includes hands on learning projects. Learn more about Coursera Labs External Link
- Course 1 of 8 in the Microsoft Power BI Data Analyst Professional Certificate
- Beginner Level No prior experience is required to get started.
- Approx. 4 hours to complete
- English Subtitles: English
Preparing Data for Analysis with Microsoft Excel at Coursera Course details
- 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.
- 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.
Preparing Data for Analysis with Microsoft Excel at Coursera Curriculum
Excel Fundamentals
Course syllabus: Preparing data for analysis with Microsoft Excel
How to be successful in this course
Skills measured in the Microsoft Exam PL300
Additional resources: Key concepts
Working with rows and columns
Working with worksheets
Exercise: Adding data to a worksheet
Exemplar: Adding data to a worksheet
Additional resources: Creating workbook content
Exercise: Sorting data
Exemplar: Sorting data
Exercise: Filtering data
Exemplar: Filtering data
Additional resources: Working with blocks of data in Excel
Self-review: Adding data to a worksheet
Knowledge check: Creating workbook content
Self-review: Sorting data
Self-review: Filtering data
Knowledge check: Working with blocks of data in Excel
Preparing Data for Analysis with Microsoft Excel at Coursera Admission Process
Important Dates
Other courses offered by Coursera
Student Forum
Anything you would want to ask experts?