Microsoft
Data for Business Analysts Using Microsoft Excel
Microsoft

Data for Business Analysts Using Microsoft Excel

 Microsoft

Instructor: Microsoft

2,281 already enrolled

Included withCoursera Plus

Course

Gain insight into a topic and learn the fundamentals

4.6

(25 reviews)

Beginner level

Recommended experience

23 hours (approximately)
Flexible schedule
Learn at your own pace

What you'll learn

  • Gain insight into the steps involved in preparing data for analysis using Excel functions.

  • Learn to use formulas and functions in Excel for data analysis purposes.

  • Understand how Excel is applied in business scenarios for data analysis and apply these skills to real-world tasks.

Details to know

Earn a career certificate

Add to your LinkedIn profile

Recently updated!

May 2024

Assessments

28 assignments

Taught in English

Course

Gain insight into a topic and learn the fundamentals

4.6

(25 reviews)

Beginner level

Recommended experience

23 hours (approximately)
Flexible schedule
Learn at your own pace

See how employees at top companies are mastering in-demand skills

Placeholder

Build your Business Strategy expertise

This course is part of the Microsoft Business Analyst Professional Certificate
When you enroll in this course, you'll also be enrolled in this Professional Certificate.
  • Learn new concepts from industry experts
  • Gain a foundational understanding of a subject or tool
  • Develop job-relevant skills with hands-on projects
  • Earn a shareable career certificate from Microsoft
Placeholder
Placeholder

Earn a career certificate

Add this credential to your LinkedIn profile, resume, or CV

Share it on social media and in your performance review

Placeholder

There are 5 modules in this course

This module introduces essential Excel elements and techniques begininning with the creation and formatting of worksheets. It explores the Excel features that are useful when viewing large data blocks and explains how to create accurate calculations.

What's included

7 videos17 readings6 assignments2 discussion prompts

This module introduces formulas and functions in Excel. It explores how these are important to data analysis and how these are used in business scenarios.

What's included

6 videos9 readings5 assignments1 discussion prompt

The module introduces common functions that help prepare Excel data for analysis in tools such as PowerBI.

What's included

6 videos13 readings7 assignments1 discussion prompt

In this module, you will learn essential skills in Microsoft Excel to enhance data manipulation and reporting capabilities. You’ll discover how to create dynamic data blocks using tables, allowing for flexible data organization and analysis. Additionally, you’ll learn how to create PivotTables, a powerful feature for summarizing and analyzing large datasets efficiently. Furthermore, you'll explore how to leverage PivotTables and slicers to create dynamic reports, providing insights and visualizations that adapt to changing data inputs. These techniques will empower you to efficiently manage and analyze data, enhancing your productivity and decision-making abilities in Excel.

What's included

10 videos5 readings8 assignments1 discussion prompt

In this module, you will be assessed on the key skills covered in the Course.

What's included

2 videos4 readings2 assignments1 discussion prompt

Instructor

Instructor ratings
4.8 (5 ratings)
 Microsoft
Microsoft
116 Courses780,186 learners

Offered by

Microsoft

Recommended if you're interested in Business Strategy

Why people choose Coursera for their career

Felipe M.
Learner since 2018
"To be able to take courses at my own pace and rhythm has been an amazing experience. I can learn whenever it fits my schedule and mood."
Jennifer J.
Learner since 2020
"I directly applied the concepts and skills I learned from my courses to an exciting new project at work."
Larry W.
Learner since 2021
"When I need courses on topics that my university doesn't offer, Coursera is one of the best places to go."
Chaitanya A.
"Learning isn't just about being better at your job: it's so much more than that. Coursera allows me to learn without limits."

Learner reviews

Showing 3 of 25

4.6

25 reviews

  • 5 stars

    76.92%

  • 4 stars

    15.38%

  • 3 stars

    3.84%

  • 2 stars

    0%

  • 1 star

    3.84%

CA
4

Reviewed on Jul 3, 2024

MM
5

Reviewed on Jun 27, 2024

New to Business Strategy? Start here.

Placeholder

Open new doors with Coursera Plus

Unlimited access to 7,000+ world-class courses, hands-on projects, and job-ready certificate programs - all included in your subscription

Advance your career with an online degree

Earn a degree from world-class universities - 100% online

Join over 3,400 global companies that choose Coursera for Business

Upskill your employees to excel in the digital economy

Frequently asked questions