Microsoft Excel For Data Analytics
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. Note: Our advanced Excel courses are regularly updated to include the latest AI releases and best practice.
Description
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.
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.