Excel Power Tools for Data Analysis

О курсе

Unlock the full potential of Excel for advanced data analysis with this four-week course. Designed for aspiring data analysts and business professionals, you'll master Microsoft's powerful tools: Power Query, Power Pivot, and Power BI. This program will transform your ability to handle, analyze, and visualize large datasets, moving beyond traditional spreadsheet limitations. By the end of this course, you will be able to: * Automate data import and transformation using Power Query. * Perform advanced data modeling and analytics with Power Pivot and DAX. * Create dynamic, interactive reports and dashboards in Power BI. * Efficiently manage and analyze millions of rows of data within Excel. To succeed, we recommend prior experience with Excel fundamentals and data visualization, ideally from our 'Data Analytics and Visualization' Specialization. This course is designed for Excel 2016 and later, with Office 365 recommended for optimal experience. Please note: Power Query, Power Pivot, and Power BI Desktop are Windows-only.

Навыки, которые вы освоите

Учитесь у экспертов

Nicky Bull

Lecturer and Lead Content Designer

Assoc Prof Prashan S. M. Karunaratne

Associate Professor - Teaching & Leadership | SFHEA