Home       Apps: Functions | Shortcuts | VBA       Blog

Excel Practice Tests & Tutorials
- Interactive
- 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.

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."