Learning Center

Excel Tutorials and Practice Tests

Welcome to Automate Excel! Here you will find the best free Excel & VBA resources anywhere on the web. This page will direct you to all of our best content.

Scroll down the page to find detailed descriptions of our 100% FREE interactive tutorials, but you can use this top section to easily jump to our cornerstone resources.

Our VBA Tutorial and our VBA Code Generator as well as over 100 free VBA Code Examples.

Our Excel ShortCut Training App, our popular ShortCut Coach Excel add-in and over 200 free Shortcuts.

steve

Automate Excel and Steve Rynearson

Hi I’m Steve, The Chief Excel Officer at AutomateExcel. I'm here to help you "Excel" at Excel.

gears
Courses and Examples

Get Started with Excel

To start, we recommend going through our one-of-a-kind, completely free interactive Excel Tutorials.  These tutorials cover: Excel Formulas & Functions, VBA, and Keyboard Shortcuts. You will be asked to create a formula, use a shortcut, or type a line of VBA code directly into our web apps, receiving immediate feedback.

The tutorials cover at least 80% of what most Excel users would ever need to know.  Beginners love our tutorials because they’re the fastest (and easiest) way to learn Excel or VBA. We also receive many emails from experienced Excel users who report learning new tricks and brushing up on knowledge.

Our tutorials are completely free, but you will need to create an account to save your progress.

Our interactive tutorials also contain practice tests that allow you to test what you've learned. The practice tests also let you define a custom set of questions in which to test yourself.

Testimonials

100% Free and Interactive

Excel Practice Tests and Tutorials

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

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

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

Learn VBA Tutorial

Free Help!

Excel Automation Examples

Have a specific need? We have hundreds of pages with specific tutorials, walk-throughs, and examples. All of our examples are listed in easy to search lists:

Get Excel Help!

Do you have a problem you can’t solve?  Do you need an Excel Automation expert?  Learn more about our Excel / VBA consulting services:

Excel and VBA Consulting

More Free Help!

Free Spreadsheets, Tutorials and Add-Ins

Pro Help

Premium Excel & VBA Tools and Tutorials