This course forms part of the Microsoft Power BI Analyst Professional Certificate. This Professional Certificate consists of a series of courses that offers a good starting point for a career in data analysis using Microsoft Power BI. No prior skills are needed to be successful in this course. In this course, you鈥檒l learn how to make use of Excel in business scenarios for data analysis. You鈥檒l 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 Microsoft Power BI Analyst.鈥� After completing this course, you鈥檒l 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.鈥�
Day in the life
Skills You'll Learn
Data Analysis, formulas and functions, Preparing Data, power bi, Microsoft Excel
Reviews
4.7 (4,313 ratings)
- 5 stars79.43%
- 4 stars16.57%
- 3 stars2.34%
- 2 stars0.64%
- 1 star0.99%
ZL
Sep 1, 2024
This course highlight the technical skills as well as non-technical that need to be a data analyst and introduce the Microsoft Excel as the very first tools for a data analyst.
SE
Aug 29, 2024
if you have experience with basic function with Excel you may find this for beginners, but this is good foundation for people who don't have a solid ground with Excel Function
From the lesson
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.
Taught By
Microsoft