Learn, build and reinforce your Excel skills with this hands-on project that guides you through the creation of a dynamic and multifaceted retirement planner spreadsheet-based tool!
Become a Data Professional. You'll learn to master Excel's built-in power tools, including Power Query, Power Pivot Tables, Data Modeling, the DAX formula language, and so much more.
Become a data wizard in Excel. Learn Excel Formulas and Functions, Data Visualization, Pivot Tables, VBA Macros, and much more. Start or supplement your career with data analysis & science skills & get hired in 2024.
Become a data analytics pro by using VBA (Visual Basic for Applications) Programming in Excel. Learn VBA Macros, Variables, Userforms, Loops, Arrays, and Pivot Tables. Build your career in data analysis & get hired.
Go from absolute beginner in Power BI to getting hired as a confident and effective Analyst. Learn Power BI (+ much more) by analyzing real-world datasets and building enterprise-level projects.
Learn, build and reinforce your Excel skills with this hands-on project that guides you through the creation of a dynamic and multifaceted retirement planner spreadsheet-based tool!
Official ZTM Power BI Cheat Sheet to help all those that want to learn and remember Power BI best practices. Learn and remember key components, visualizations, and shortcuts for Power BI.
Official ZTM Excel Cheat Sheet to help all those that want to learn and remember Excel fundamentals.
Official ZTM VBA Cheat Sheet to help all those that want to learn and remember VBA fundamentals.
With 95,000+ jobs available and $80,000+ salaries, it's the perfect time to get started in the field of Data Analysis. Become a Data Analyst this year!
With 300,000+ jobs available and $120,000+ / year salaries, now is the perfect time to become a Data Engineer. Here's your step-by-step guide - with resources!
Will a discount increase sales or lower them? Find out answers to these questions (and more), before you implement them by using what-if parameters in Power BI.
Do you want to transform your raw data into actionable insights? Learn the basics of how to use Power Query, in this step-by-step guide (with examples!).
DATEADD is great for period-over-period analysis (right inside Pivot Tables). And it's easier to use than you think... here's how (with setup, code, examples)!
Want to get better at Excel? Then you need to build real-world projects. These 8 project ideas will push your limits! If you can build these, you're a pro.
From my 10+ years of architecting and coding data solutions, these are my recommended best practices for your Dashboard, Data Model, and Workspace in Power BI.
Why use measures? How about portable, reusable functions, that auto-update in each pivot table, when you update the single source? Learn how in this guide!
Want to create custom functions (UDFs) in VBA that you can also export as Add-ins for anyone to use? Well, let me walk you through exactly how (with examples).
Want to merge large datasets across multiple sheets - without using VLOOKUP or Power BI? Learn how, with Excel + Power Query in this step-by-step tutorial.
With the ability to process millions of rows of data, the Excel Data Model is one of the most powerful tools in the beginner BI toolbox. Here's how to use it.
If you enjoy numbers, problem-solving, and finding out WHY things happen, then becoming a Business Intelligence Analyst might be the perfect new role for you!
Is VBA programming difficult to learn? Which is better for data analysts: Python or VBA with Excel? Travis Cuzick answers these questions & more in this developer AMA.
Still not even sure if you should learn VBA for Excel? We break down our top 5 reasons why you should start learning VBA and how you can get started today.
This VBA tutorial will teach you 3 VBA loops that you can use in VBA for Excel to automate repetitive tasks. You'll learn For Next, Nested, and For Each Loops.
Spoiler: It doesn’t matter. If you want to be a great programmer, you need to change your mindset and stop thinking in terms of what is best to use. What wins? What will get you the highest salary? What is the best for the situation at hand?