Home       Apps: Functions | Shortcuts | VBA     

UT 10/15/2018 Excel Training Materials

1. Download these files:

2. Then explore the Apps below. Especially Shortcuts > 8. Essentials

U-Texas Acc

Subscribe to get our latest content by email.

We won't send you spam. Unsubscribe at any time. Powered by ConvertKit

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


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