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.
Class Deals by MOOC List - Click here and see Coursera's Active Discounts, Deals, and Promo Codes.
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 course is part of the Microsoft Business Analyst Professional Certificate.
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.
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.
Final project and assessment: Preparing data for analysis with MS Excel
In this module, you will be assessed on the key skills covered in the Course.
