Learn how to automate repetitive Excel data-cleaning tasks in the workplace using Power Query. Transform a “visually appealing table” filled with horizontally arranged dates and merged cells into a database-style structure suitable for analysis, and complete an interactive dashboard that updates with a single click.

This course completes the entire workflow of practical data analysis, from Excel data analysis to SQL, BigQuery, and Tableau dashboards, through hands-on projects. Rather than just teaching you how to use the tools, you will learn the data analysis structures and mindsets actually used in real-world analysis tasks.

An introductory course on easily organizing and analyzing marketing data with Excel! Learn through hands-on practice, including PivotTables, functions, and practical problem-solving, to acquire data analysis skills that can be immediately applied in real-world work.