Advanced Excel for Automation

Course details

Take your Excel skills to new heights by learning how to automate workflows in Excel. Learn how to use Power Query and Power Pivot to automate data pipelines effortlessly and Macros to streamline repetitive tasks. Discover how to automate data transformations and modeling, enabling more efficient and insightful data analysis. Whether you're a data analyst, business professional, or Excel enthusiast, you can benefit from enhanced skills by improving your productivity and accuracy, saving time, and reducing errors in your work.

Concepts

Introduction

Instructor and course introductions

Power Query

Power Query introduction
Pulling in data from multiple sources
Merging and appending data
Automations using Power Query
Automating data transformations

Power Pivot

Power Pivot overview - Pivot Table vs. Power Pivot
Data modeling
Measures
KPIs

Project 1

Automated dashboard project

Macros and VBA

What is a macro and VBA
Creating your first macro
Making useful macros
VBAs

Project 2

Vehicle report automation

Congratulations

Congratulations