Microsoft - Preparing Data for Analysis with Microsoft Excel
- Offered byCoursera
- Public/Government Institute
Preparing Data for Analysis with Microsoft Excel at Coursera Overview
Duration | 4 hours |
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
Other courses offered by Coursera
Student Forum
Anything you would want to ask experts?