Preparing Data for Analysis with Microsoft Excel

Instructor: Microsoft

Beginner Level • Approx. 19 hours • Flexible Schedule

What You'll Learn

  • NEW [optional] introduction to Generative AI

Skills You'll Gain

Data Cleansing
Excel Formulas
Microsoft Excel
Power BI
Spreadsheet Software
Data Management
Data analysis
Productivity Software
Data Manipulation

Shareable Certificate

Earn a shareable certificate to add to your LinkedIn profile

Outcomes

  • Learn new concepts from industry experts
  • Gain a foundational understanding of a subject or tool
  • Develop job-relevant skills with hands-on projects
  • Earn a shareable career certificate from Microsoft

There are 4 modules in this course

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.

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.

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

In this module, you will be assessed on the key skills covered in the Course.