Home       Apps: Functions | Shortcuts | VBA     

UT 11/29/2018 Excel Training Materials

1. Download the file below.
Note: It's highly recommended that you review this file prior to the training session! The more you review the materials in advance, the more useful the training will be to you.

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

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