Microsoft via Coursera

Preparing Data for Analysis with Microsoft Excel

Name: Preparing Data for Analysis with Microsoft Excel
Rating: 4.7 (5710 reviews)

4.75,710 ratings at Coursera

Compare with others

Overview

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. 

Syllabus 4

Excel fundamentals 6 hours
In the first module, you’ll focus on Excel fundamentals. In the opening lesson, you’ll receive advice on how to succeed in this course, meet your peers, and review some useful resources available to help you in your learning journey. Lesson two focuses on creating workbook content. It introduces th…
Formulas and functions 4 hours
In the second module, you’ll explore formulas and functions and their importance to data analysis. You’ll begin the module with a lesson on using formulas in Excel to perform calculations. You’ll learn what the concept of a formula is, discover the syntax for different types of calculations, and co…
Preparing data for analysis using functions 5.5 hours
In the third module, you’ll learn how to prepare data for analysis using functions. You’ll begin with a lesson on using functions to clean or standardize text to prepare text data for effective analysis. You’ll then explore the use of date and time functions in Excel so that you can complete action…
Final project and assessment 3 hours
In the fourth week, you’ll undertake an assessment of the key skills that you covered in the course. You’ll begin with a course recap in which you’ll review the important lessons you learned. You’ll also be able to apply the knowledge you've gained in the previous weeks by completing a scenario-bas…

Skills you'll practise

Data Analysis Analysis Microsoft Excel

Advantages and disadvantages

Advantages

Structured courses with graded quizzes, assignments and deadlines you can reset.
A shareable certificate from the university or company when you pay.
Financial aid is often approved for students in India (apply 15 days before you need it).
From Microsoft, a well-regarded name.
Rated 4.7 out of 5 by 5,710 learners.
Self-paced: start any time.
A clear syllabus (4 parts) you can see before you start.
Hands-on: you build or practise, not just watch.

Disadvantages

Paid after a 7-day free trial (Coursera Plus or per course).
Some courses can be audited for free, but graded work and certificates need payment.

Some points apply to every course of this kind; see how we rank.

This course is paid. Here is how to take it for free

Free trials: You can start a 7-day free trial for many individual courses, Specializations, or a Coursera Plus subscription to test full course features. Cancel before the seventh day if you do not want to be charged.
Financial aid: If you cannot afford the fee for a certificate, you can apply for financial aid through the link on the course home page by filling out an application about your background and goals.