Microsoft Excel For Data Analytics

In this course, you will learn how to use Excel to organize and analyse data, create reports, design charts, and make data-driven decisions.

Dates

There are no dates currently scheduled for this course.

Interested in this course? Suggest a date/location

Description

Microsoft Excel is a powerful tool for data analysis that is widely used in many industries. In this course, you will learn how to use Excel to organize and analyse data, create reports, design charts, and make data-driven decisions. You will also learn how to use Excel's built-in features to manipulate data in Power Query.

Prerequisites

Learners should have a basic understanding of Excel and its functions or have completed an intermediate Excel course.

Access to a licensed version of Microsoft Excel is required for this course.

A stable internet is required.

A second monitor is recommended but not required.

Content

Attending this course will help you to:

Leverage the Power Query tool to connect with a wide range of data sources.
Use Excel's built-in functions and formulas to manipulate data.
Interact with a variety of table types (Simple, Table and PivotTable)
Use various excel tools such as Aggregate, filter, and sorting.
Create charts and graphs to visualize data.
Create live interactable dashboards.
Apply conditional formatting and data validation to improve data accuracy.
Perform statistical analysis and make data-driven decisions.

Certification

College certificate of attendance