Data for Business Analysts Using Microsoft Excel

This course is part of Microsoft Business Analyst Professional Certificate

Instructor: Microsoft

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

Shareable certificate

Add to your LinkedIn profile

Assessments

28 assignments

Taught in English

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

Learn more about Coursera for Business

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

Earn a career certificate

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

Share it on social media and in your performance review

There are 5 modules 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 Business Analyst.  After completing this course, you’ll be able to:  • Identify and explain the steps involved in preparing data for analysis using Excel functions. • Use formula and functions for Data Analysis • Describe how Excel is used in business scenarios for Data Analysis • Apply Excel skills to real-world data preparation tasks.

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

7 videosTotal 39 minutes

Course Introduction3 minutesPreview module
Business Analysts and Microsoft Excel4 minutes
Introduction to Microsoft Excel6 minutes
Entering and formatting data6 minutes
Reading large data blocks6 minutes
Sorting and filtering data in Excel7 minutes
Module summary: Excel fundamentals3 minutes

17 readingsTotal 215 minutes

Course Syllabus: Data for Business Analysts Using Microsoft Excel10 minutes
How to be successful in this course10 minutes
Personalize your learning track10 minutes
How to open an image in a new tab10 minutes
How to locate your downloaded files10 minutes
Additional resources: Accessing Microsoft Excel5 minutes
Regional variations in Excel10 minutes
Working with rows and columns10 minutes
Working with worksheets10 minutes
Exercise: Adding data to a worksheet30 minutes
Exemplar: Adding data to a worksheet10 minutes
Additional resources: Creating workbook content5 minutes
Exercise: Sorting data30 minutes
Exemplar: Sorting data10 minutes
Exercise: Filtering data30 minutes
Exemplar: Filtering data10 minutes
Additional resources: Working with blocks of data in Excel5 minutes

6 assignmentsTotal 95 minutes

Module Quiz: Excel Fundamentals30 minutes
Self-Review: Adding data to a worksheet15 minutes
Knowledge Check: Creating Workbook Content15 minutes
Self-Review: Sorting Data10 minutes
Self-Review: Filtering Data10 minutes
Knowledge Check: Working with blocks of data in Excel15 minutes

2 discussion promptsTotal 20 minutes

Discussion prompt: Meet and Greet10 minutes
What features were new to you and which were most useful10 minutes

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

6 videosTotal 37 minutes

What is a formula?6 minutesPreview module
Controlling calculations6 minutes
Controlling calculations in action6 minutes
What is a function formula and how to write it7 minutes
Using the INSERT function5 minutes
Module summary: Formulas and functions6 minutes

9 readingsTotal 120 minutes

Order of precedence in calculations10 minutes
Useful percentage calculations10 minutes
Exercise: Calculating profit and margin30 minutes
Exemplar: Calculating profit and margin10 minutes
Additional resources: Formulas in Excel5 minutes
The AutoSum shortcut10 minutes
Exercise: Preparing a monthly sales report30 minutes
Exemplar: Preparing a monthly sales report10 minutes
Additional resources: Getting started with functions5 minutes

5 assignmentsTotal 80 minutes

Module Quiz: Formulas and Functions30 minutes
Self-Review: Calculating profit and margin10 minutes
Knowledge Check: Formulas in Excel15 minutes
Self-Review: Preparing a monthly sales report10 minutes
Knowledge Check: Getting started with functions15 minutes

1 discussion promptTotal 10 minutes

What features were new to you and which were most useful?10 minutes

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

6 videosTotal 40 minutes

How inconsistent data can affect data analysis6 minutesPreview module
Why understanding date calculations is important5 minutes
Dynamic date and time entries5 minutes
Using the IF function7 minutes
Using nested IF and IFS function8 minutes
Module summary: preparing data for analysis using functions7 minutes

13 readingsTotal 175 minutes

Functions which can be used to standardize text data10 minutes
Exercise: Standardizing text-based data30 minutes
Exemplar: Standardising text-based data10 minutes
Additional resources: Using functions to clean or standardize text5 minutes
Other useful date calculations10 minutes
Exercise: Calculating the number of working days remaining in the year30 minutes
Exemplar: Calculating the number of working days remaining in the year10 minutes
Additional resources: Date and time functions5 minutes
AND and OR functions10 minutes
IF functions10 minutes
Exercise: Adding a data column using the IFS function30 minutes
Exemplar: Adding a data column using the IFS function10 minutes
Additional resources: Logical functions5 minutes

7 assignmentsTotal 105 minutes

Module Quiz: Formulas and Functions30 minutes
Self-Review: Standardising text-based data10 minutes
Knowledge Check: Using functions to clean or standardise text15 minutes
Self-Review: Calculating the number of working days remaining in the year10 minutes
Knowledge Check: Date and Time Functions15 minutes
Self-Review: Adding a data column using the IFS function10 minutes
Knowledge Check: Logical Functions15 minutes

1 discussion promptTotal 10 minutes

What features were new to you and which were most useful10 minutes

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.