While many courses offer "tips and tricks" or promise “zero-to-60” in Excel proficiency, their value is limited due to the lack of context and real-world application. Data Wrangling in Excel provides robust exercises that are challenging but achievable, with a clear goal of understanding, organizing, handling, and preparing data for analysis and/or further operations.

Plenty of courses focus on "becoming a data analyst." This course focuses entirely on the simple fact of the corporate world that o courses miss—the daunting task of data preparation before any analysis work can even begin. Without good preparation, analysis is difficult, not repeatable, unreliable, and inaccurate. 

Many courses focus on the analytical tip of the iceberg. This course focuses on the deep foundations of preparation in an accessible but robust hands-on approach with real-world, messy, challenging data exercises to train you how to handle even the most challenging datasets. 

You will quickly develop an impressive ability to navigate, structure, and refine previously-unknown datasets. You’ll learn basic data modeling techniques, formulas, principles, and even keyboard shortcuts. These early wins will become visible in your first several exercises, and with discipline and focus, you’ll see how these foundational skills will help you tackle bigger and more complex problems as you progress through the course. You’ll be excited by your newfound skill and proficiency, and especially by what you can achieve with your abilities.

This isn’t another conventional data analysis course—it's a foundational pre-analytics course that turns analysts into data professionals.

Data Wrangling in Excel is for professionals from any industry who aim to improve their data handling skills and increase their career growth. If you’re in college looking to land a job, an early-career analyst, or any analyst struggling with messy data, this course is for you. The skills and principles taught here are essential for every kind of analyst, across industries and departments.

Business leaders often ask questions about business performance and expect quick answers without realizing that

1) data is messy,
2) data preparation is time-consuming and difficult, and
3) analysts have to gather data from a variety of internal and external sources.

In most cases, analysts have never seen the required data. This makes for a frustrating trial and error routine, with small breakthroughs and incremental progress, leaving data professionals feeling overwhelmed and under tremendous pressure to deliver what appears to be a simple report, analysis, or dashboard. The course teaches you how to discover and understand new datasets. This provides your leaders quick and accurate answers, and makes you a reliable and valuable star.

There are many powerful tools like Alteryx, Trifacta, Power Query, Talend, or even SQL scripts and Visual Studio.

But Excel is available to analysts at every level of expertise and in every business size. What’s more, the core skills and principles in this course build expertise in handling data regardless of the platform. Finally, while each of those tools offer robust process automation, analysts still need to know how to extract and wrangle exceptions that are inevitably missed by the automations before passing them back into the automation process. The foundations built here can be applied to every platform and tool as your skills and company grow. That said, courses in Power Query, SQL, and Visual Studio are planned for data extraction, wrangling and transformation, and loading (ETL).

By the end of the course, you’ll feel confident in your ability to navigate uncharted data, gather information, investigate unfamiliar data sources, compile data in a robust, repeatable, reliable, and accurate manner, and to be proficient in data handling techniques. Those techniques will increase your confidence and efficiency in developing datasets you can then use for analysis and reporting. This course does not focus on the final step of analysis and reporting at this time, but it may in the future.

4 hours of step-by-step video lessons, delivered in manageable phases and modules. Enrolled students will have lifetime access to the course and its resources.

This course is for serious or aspiring professionals. It's not for "tire kickers" or folks who are just poking around. This course is for people who are ready to put in the work necessary to see the results. If you're committed to the process and want to learn everything that I've learned over the last 8 years, there's zero chance you'll be disappointed. Thank you for understanding.