MOOC List is learner-supported. When you buy through links on our site, we may earn an affiliate commission.
MOOC List is learner-supported. When you buy through links on our site, we may earn an affiliate commission.
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 Microsoft Power BI Analyst.
After completing this course, you’ll be able to:
• Create data in Microsoft Excel and prepare it for data analysis.
• Make use of common formulas and functions in a worksheet.
• Prepare Excel data for analysis in Power BI using functions.
This course is part of the Microsoft Power BI Data Analyst Professional Certificate.
Syllabus
Excel fundamentals
Module 1
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.
Formulas and functions
Module 2
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
Module 3
The module introduces common functions that help prepare Excel data for analysis in tools such as PowerBI.
Final project and assessment: Preparing data for analysis with Microsoft Excel
Module 4
In this module, you will be assessed on the key skills covered in the Course.
MOOC List is learner-supported. When you buy through links on our site, we may earn an affiliate commission.
MOOC List is learner-supported. When you buy through links on our site, we may earn an affiliate commission.