Data for Business Analysts Using Microsoft Excel

Go to Course: https://www.coursera.org/learn/data-for-business-analysts-using-microsoft-excel

Introduction

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.

Syllabus

Excel Fundamentals

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.

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.

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

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.

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