Overview
Dive into Excel data tools and features like Power Query, Power Pivot, and advanced formulas, teaching you how to clean, transform, and model data for actionable insights. Understand the art of crafting data visualizations using Pivot Tables and Pivot Charts, and elevate your analytics game by learning how to create effective data models in Power Pivot. To turbocharge your productivity, we'll also explore how to integrate the generative Al capabilities of ChatGPT into your Excel workflow, assisting with formula development, troubleshooting, and creative data visualizations. Whether you're a data analyst, consultant, or any professional looking to sharpen your data analytics skills, this course is the jump start you've been waiting for.
Objectives
- Gained awareness in proper Excel data structure, advanced formulas, including dynamic arrays, and data validation techniques to manipulate and analyze data effectively.
- Learned how to extract, clean, transform, and model data using Power Query (Get and Transform). Understand the Power Pivot data model and apply DAX functions for advanced calculations, and create effective structured models for analysis.
- Become familiar with the skills necessary to design interactive dashboards using Pivot Tables, Pivot Charts, slicers, and timelines to represent data in a visually engaging manner.
- Recall how to leverage ChatGPT to accelerate their workflow in formula development, troubleshooting, and data visualization brainstorming to enhance productivity in Excel-based data analysis tasks.
Prerequisite
The participant should be comfortable using Excel, navigating the Excel interface, entering formulas, etc. This is an introductory course
delving into some of the intermediate data analysis tools and concepts of Excel.
