Preparing Data for Analysis with Microsoft Excel

This course is part of Microsoft Power BI Data Analyst Professional Certificate

Instructor: Microsoft

What you'll learn

  •   NEW [optional] introduction to Generative AI
  • Skills you'll gain

  •   Productivity Software
  •   Data Manipulation
  •   Power BI
  •   Microsoft Excel
  •   Spreadsheet Software
  •   Data Management
  •   Excel Formulas
  •   Data Cleansing
  •   Data Analysis
  • There are 4 modules in this course

    No prior skills are needed to be successful in this course. 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 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.

    Formulas and functions

    Preparing data for analysis using functions

    Final project and assessment: Preparing data for analysis with Microsoft Excel

    Explore more from Data Analysis

    ©2025  ementorhub.com. All rights reserved