Data for Business Analysts Using Microsoft Excel

Overview

Save Big on Coursera Plus. 7,000+ courses at $160 off. Limited Time Only!

Grab it

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.

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.

Formula and functions

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.

Preparing data for analysis using functions

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

Working with Pivots

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.