Preparing Data for Analysis with Microsoft Excel

Beginner Level
Approx. 19 hours
Flexible Schedule

Microsoft

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.

Develop Your Specialized Knowledge

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.