Data Analysis with Excel
Reference : EV8 TECH-005Educational objectives
At the end of this course, participants should be able to:
- Work with functions.
- Work with lists.
- Analyze data.
- Visualize data with charts.
- Use pivot tables and pivot charts.
- Work with multiple worksheets and workbooks.
- Use lookup functions and formula auditing.
- Share and protect workbooks.
- Automate workbook functionality.
- Create sparklines and mapping data.
- Forecast data.
Course programme
This course equips participants with comprehensive skills in leveraging Microsoft Office Excel for effective data analysis. Beginning with foundational topics like performing calculations, modifying worksheets, and formatting, participants quickly progress to advanced functionalities tailored for robust data analysis and visualization.
Who is this course for?
Public
Data Analysis with Excel is beneficial for business analysts, financial analysts, entry-level data scientists, project managers, and marketing professionals, and marketing professionals providing a versatile platform for data-driven decision-making across various domains.
Prerequisites