Automate Excel

Your Resource for Excel & VBA

vba coding made easy

Need Excel or VBA Help? Contact Us for a Free Consultation:

Scroll Down to see the best free and premium Excel resources!

  • Excel Boot Camp: Learn Excel Fast with our hands-on go-at-your-own pace tutorial!
  • AutoMacro: VBA Coding Made Easy! For beginners and experienced programmers.
  • Shortcut Coach: Easily learn keyboard shortcuts while you work!
  • 100% Free Interactive Excel Tutorials: Excel Functions, VBA, and Excel Shortcuts

Interactive Tutorials
- 100% Free

Formulas and Functions

  • Learn 30 of Excel's most powerful functions with 60 interactive exercises and many more examples:
  • Intro to Formulas
  • Logical & Comparison
  • Statistical
  • Lookup
  • Text
  • Date
  • Also learn about other formula essentials including:
  • Formula Shortcuts
  • Comparisons and Boolean Values
  • How to use Text in Excel


VBA for Excel

  • 100 interactive exercises and many more examples, covering everything you need to become a VBA expert:
  • VBA Basics
  • Variables
  • Conditional Logic
  • Loops
  • Adv Cell  References
  • Msg & Input Boxes
  • Events
  • Settings
  • Adv Procedures
  • Arrays

Keyboard Shortcuts

  • Learn 77 of Excel's most powerful shortcuts.
  • Basics
  • Formatting
  • Formulas
  • Navigation
  • Selecting Cells
  • Rows & Columns
  • Data & Other Tools
  • Viewing
  • Learn section teaches you shortcuts. Then you can develop shortcut "muscle memory" with the Practice section and test your knowledge with the Test section.

Premium Add-ins and Training
 - Boost Your Productivity!

AutoMacro - VBA Made Easy

  • Easily insert many commonly used code fragments with just a few clicks of the mouse (or better yet, a few keystrokes)
  • Save your own frequently used code fragments
  • Insert objects (ranges, sheets, or workbooks) and apply methods (ex: copy, paste, insert) or properties (value, formular1c1) directly into your modules. No more struggling to remember the syntax! Beginners can use this to create procedures from scratch with limited coding knowledge!
  • Keyboard Shortcuts! - Add & navigate to "bookmarks" in your code, comment/uncomment entire blocks of code, and more.

Shortcut Coach
-Coming Soon

  • Shortcut Coach teaches you to use Excel shortcuts as you work.
  • Simply work as you normally would and when you use the mouse instead of a keyboard shortcut, a small pop-up appears in the bottom corner of the screen. Keep working, and over time you'll learn keyboard shortcuts with no effort!

Spreadsheet Boot Camp

  • Learn Excel in our fully immersive Excel "Boot Camp".
  • Over 40 worksheets, 70 lessons, and 150 automatically graded exercises.
  • Master Excel without watching boring videos, instead go at your own pace with our hands-on tutorial.

About Me

Steve Rynearson

[email protected]

About Me

​Steve is the owner of AutomateExcel.com and a freelance Excel & VBA developer. He designs beautiful dashboards and powerful data processing tools for his clients. When he's not working with clients, he's developing resources to help you be more productive while working in Excel.

"Excel is the most common data tool around. Take the time to master it and get more done in less time, while impressing your coworkers."

signature