Excel Intermediate to Advanced: Formulas, PivotTables, Power Query, Dashboards and VBA by excelisfun

About this course

Take your Excel skills from competent to confident and start working the way analysts, finance teams, and operations pros do every day. This free online course is built for people who already know the basics and now want speed, accuracy, and clearer insight from real-world data. You will learn how to structure datasets properly so your work stays reliable as rows are added, and how to create formulas that remain flexible when assumptions change.

Instead of getting stuck cleaning messy files by hand, you will practice transforming data efficiently with Power Query, combining information from multiple sources, and choosing the right loading options for large imports. You will also develop a strong command of references and advanced formula techniques, including conditional calculations, text and date logic, and smarter lookup patterns designed to keep large workbooks responsive.

As you progress, you will shift from simply reporting numbers to building interactive analysis. You will work with PivotTables and the Data Model to connect tables through relationships, reduce the need for helper columns, and create more scalable reports. You will explore techniques that help you visualize results with charts and conditional formatting, then bring it together in dashboards that can be refreshed as new files arrive.

The course also introduces automation and productivity boosters: data validation to reduce input errors, advanced filtering when it is the fastest tool for the job, and practical macro recording foundations that open the door to VBA-driven efficiency. By the end, you should be able to handle bigger datasets, deliver cleaner reporting, and build workflows that are easier to maintain—skills that translate directly to better performance in technology, programming-adjacent roles, and any Excel-heavy job.