The Ultimate Workbook Pack Is Finally Here — My Biggest Workbook Collection Ever!

550+ Excel Templates, Applications & VBA Trainings — Now with the NEW Workbook Library App.

The Ultimate Workbook Pack Is Finally Here — My Biggest Workbook Collection Ever!

The Excel Productivity Suite ribbon tab inside Microsoft Excel

New Product8 Tools · 1 Ribbon Tab

The Excel Productivity Suite is here.

Get This Add-In Now

How To Master 8 If/Then Excel Macros

Bronze, Silver, Gold and Platinum Elite Membership badges

Like this free workbook?

Get the updated member versions of the trainings & workbooks.

Elite members get the improved versions of what Randy shares for free on YouTube, plus everything below:

230+ updated trainings & workbooks
30 business tools & counting
GPT workbooks & VBA codebooks
Full training archive + videos
Platinum coaching with Randy
Early access & member discounts

See Elite Plans →Plans from $5/month · Instant access · Cancel anytime

Sorting through data, applying conditions, and automating decisions in Excel can quickly become overwhelming. Instead of relying on repetitive actions or complex formulas, If/Then statements in VBA allow you to create structured, efficient macros that respond instantly to specific conditions. When used correctly, they help streamline workflows, reduce errors, and make your automation more reliable.

In this training, I’ll walk you through eight essential ways to use If/Then statements, showing you how to write clean, structured, and effective macros. You’ll get a detailed explanation of each technique, see macros built in real-time, and receive a free template download to apply what you’ve learned immediately.

Watch the full training now and download your free template to get started!

RELATED TRAININGS

WhatsApp Automation for Business: Can ChatGPT Take Your Orders in Excel?

A customer messages you on WhatsApp asking for five smartwatches. You only have two. Normally...

Why I Stopped Teaching VBA: Excel in the Age of AI

If you follow Excel For Freelancers, you may have noticed the VBA tutorials slowing down....

Stop Clicking Around: Build a Smart Automated Tab Order System in Excel VBA

Manually navigating through Excel forms is frustrating and inefficient. In this training, we solve that...

From Spreadsheet to Slides: Build a One-Click PowerPoint Generator With Excel VBA

Creating PowerPoint presentations manually is slow, repetitive, and inefficient. In this training, we solved that...

New To VBA? Check Out My Brand-New Tutorial & Series For Beginners

Getting started with VBA can feel overwhelming, especially if you’re unsure where to begin. From...

Learn The VBA Basics With Automated Sorting Today

Imagine being able to sort and organize your data with just a click, no matter...

VBA For Beginners: Mastering Variables Like A Pro

Writing efficient VBA code starts with understanding variables. Without them, your code becomes cluttered, harder...

VBA For Beginners: Mastering The Message Box

Communicating with users inside an Excel workbook is essential, whether you’re providing alerts, gathering responses,...

Use the search bar below or explore the Related Trainings above for more content tailored to your interests!

Expand Your Knowledge

Excel AI Toolpack Add-In

Combines 12 incredible AI tools into one seamless package. Revolutionize your productivity by effortlessly fixing formula errors, extracting data, analyzing dashboards in a single click, and receiving instant AI responses. No API required—just the untapped potential of AI enhancing Excel.

The Ultimate Excel
Resource Guide

Consists of 1000 resources, ensuring it's the only Excel reference you'll ever need. The guide is organized into 10 tabs, each containing 100 resources that are easily sortable and filterable, making it effortless to find the tools you're looking for.

ULTIMATE FREELANCERS
RESOURCE GUIDE

Packed with essential tools and templates, this comprehensive guide is your one-stop-shop for all things freelancing. With 1,000 live links and a single click-to-update feature, you'll always have access to the latest freelancing resources.

THE FREELANCER'S ACADEMY MASTERCLASS

Master the art of negotiation for higher rates, elevate your portfolio, and achieve financial independence through monetizing your expertise. Acquire the essential strategies and tools to launch and grow your freelance business successfully.

200 UPDATED WORKBOOKS

An exclusive collection of refined Excel workbooks, each enhanced with advanced tools and features, and designed to streamline your workflow.

EXCEL FOR FREELANCERS MENTORSHIP PROGRAM

Unlock your path to financial freedom with our Mentorship Program. Gain the skills and confidence to create your own Excel-based applications, paving the way for a sustainable passive income stream. Join us and transform your aspirations into reality.

YOUR 24/7 PERSONAL CRM EXPERT

The Ultimate CRM Application gives you a powerful, organized system inside Excel to track leads, manage follow-ups, monitor your pipeline, and stay on top of every opportunity — all in one place. No more scattered notes or missed deals. You’ll save hours each week, gain total clarity over your sales process, and operate with the confidence of a true professional while moving prospects smoothly from first contact to closed deal.

Randy Austin

Randy Austin is a 7x MVP and a Global Excel Awards Winner, with 30 years of experience in Excel solutions. His YouTube videos have garnered over 40+ million views, with over 500 trainings and templates, empowering users with practical Excel development techniques and templates.

Stop Starting With a Blank Spreadsheet.

Get 450+ done-for-you Excel templates, plus 117+ VBA trainings, all organized in one searchable library. Every workbook includes tutorials, PDF codebooks, and built-in custom GPT support—so you can find, customize, and start using proven Excel solutions without rebuilding from scratch.

New Product

STOP LOSING WORK IN EXCEL. GET 8 TOOLS IN ONE RIBBON TAB.

Auto-save with real version history, team sync, per-person access control, a pop-up date and time picker, import manager, link finder and file manager. The Excel Productivity Suite installs into Excel itself, so every tool is right there in every workbook you open.

The Ultimate AI Resource Guide

1,000 verified AI resources — all in one Excel-based guide. Explore tools, courses, experts, and communities across 10 categories, all curated and organized so you can skip the noise and focus on what actually helps you grow. Sort, filter, and learn faster with a built-in Expert GPT assistant — your shortcut to mastering AI without wasting time searching.

Turn Your Excel Vision into Reality!

Need a custom Excel VBA solution? My expert developers build powerful automation—dashboards, data processing, reporting, and more. Save time and boost efficiency with a tailored solution!

Master the Web with Excel VBA

Tired of wasting time on repetitive online tasks? With Complete Web Automation with Excel VBA, you’ll discover how to turn tedious web browsing, form-filling, and data collection into fully automated processes—all directly from Excel. Imagine logging in, scraping data, filling forms, or even handling pop-ups in seconds instead of hours. This course equips you with the tools to work smarter, not harder—so you can save valuable time, boost your productivity, and gain confidence in automating tasks like a pro.

Stop creating videos no one is searching for.

The best video idea isn't always the one in your head. Sometimes the best idea is the one thousands of people are already searching for. VidIQ helps me find those opportunities before I spend hours making a video. Definitely one of the tools I use the most.

The Ultimate Workbook Pack Is Finally Here — My Biggest Workbook Collection Ever!

550+ Excel Templates, Applications & VBA Trainings — Now with the NEW Workbook Library App.

The Ultimate Workbook Pack Is Finally Here — My Biggest Workbook Collection Ever!

How To Master 8 If/Then Excel Macros

RELATED TRAININGS

Looking for more resources?

Use the search bar below or explore the Related Trainings above for more content tailored to your interests!

Expand Your Knowledge

Excel AI Toolpack Add-In

Combines 12 incredible AI tools into one seamless package. Revolutionize your productivity by effortlessly fixing formula errors, extracting data, analyzing dashboards in a single click, and receiving instant AI responses. No API required—just the untapped potential of AI enhancing Excel.

Consists of 1000 resources, ensuring it's the only Excel reference you'll ever need. The guide is organized into 10 tabs, each containing 100 resources that are easily sortable and filterable, making it effortless to find the tools you're looking for.

ULTIMATE FREELANCERS RESOURCE GUIDE

Packed with essential tools and templates, this comprehensive guide is your one-stop-shop for all things freelancing. With 1,000 live links and a single click-to-update feature, you'll always have access to the latest freelancing resources.

THE FREELANCER'S ACADEMY MASTERCLASS

Master the art of negotiation for higher rates, elevate your portfolio, and achieve financial independence through monetizing your expertise. Acquire the essential strategies and tools to launch and grow your freelance business successfully.

An exclusive collection of refined Excel workbooks, each enhanced with advanced tools and features, and designed to streamline your workflow.

EXCEL FOR FREELANCERS MENTORSHIP PROGRAM

Unlock your path to financial freedom with our Mentorship Program. Gain the skills and confidence to create your own Excel-based applications, paving the way for a sustainable passive income stream. Join us and transform your aspirations into reality.

Randy Austin

Get 450+ done-for-you Excel templates, plus 117+ VBA trainings, all organized in one searchable library. Every workbook includes tutorials, PDF codebooks, and built-in custom GPT support—so you can find, customize, and start using proven Excel solutions without rebuilding from scratch.

STOP LOSING WORK IN EXCEL. GET 8 TOOLS IN ONE RIBBON TAB.

Auto-save with real version history, team sync, per-person access control, a pop-up date and time picker, import manager, link finder and file manager. The Excel Productivity Suite installs into Excel itself, so every tool is right there in every workbook you open.

Turn Your Excel Vision into Reality!

Need a custom Excel VBA solution? My expert developers build powerful automation—dashboards, data processing, reporting, and more. Save time and boost efficiency with a tailored solution!

Master the Web with Excel VBA

Stop creating videos no one is searching for.

The best video idea isn't always the one in your head. Sometimes the best idea is the one thousands of people are already searching for. VidIQ helps me find those opportunities before I spend hours making a video. Definitely one of the tools I use the most.

DOWNLOAD YOUR FREE WORKBOOK

It's Great to see you!

ULTIMATE FREELANCERS
RESOURCE GUIDE