Microsoft Excel Office Hour 67: Excel tips & tricks | Bob Umlas

Microsoft Excel Office Hour 67: Excel tips & tricks | Bob Umlas

Speaker: Bob Umlas

1. Excel tips & tricks
2. Plenty Q&A

Speaker profile:
Bob Umlas worked for a major tax and accounting firm, using Microsoft Excel® for 8 hours a day, writing custom applications for staff and clients from 1998 to 2018.
He has been using Excel since version 0.99 (on the Macintosh)! He was a contributing editor to Inside Microsoft Excel for many years, a magazine devoted exclusively to Microsoft Excel and published by The Cobb Group and later Ziff-Davis. At the time, most issues contain either an article by Mr. Umlas on using VBA (Visual Basic for Applications) or some tip or technique from him on using Excel. He has had more than 300 articles published on subjects ranging from beginner to advanced macros, and on tips, shortcuts, and general techniques using virtually all aspects of Excel.
Mr. Umlas was voted an “MVP” (Most Valuable Professional) by Microsoft each year from 1993-2018 (25 years!) for his contributions to the various online Forums about Excel and is known worldwide for his contributions in Excel. As an MVP, he met yearly with his fellow-MVPs at Microsoft’s headquarters in Redmond, where he had access to the product developers. He has been a beta tester for new versions of Excel since version 1.5, and was asked by Microsoft for his input for newer versions of Excel. In 1995 he led a session called “Maximizing Excel Development Using Array Formulas” at Microsoft’s Tech Ed Conference in New Orleans, and he led a session called Tips and Tricks at a Microsoft convention in New York City. He has also led two Excel sessions (Array Formulas, Tips & Tricks) at the Advisor’s Developer Conference in San Francisco in February 1998.
He has led 5 sessions at an Excel User Conference in Atlantic City on Tips & Tricks, Array formulas, VBA, Formulas, and Userforms. He has led at about 7-8 of these user conferences since 2005.
He is also the author of “This isn’t Excel, it’s Magic!” which is available from as well as from (There are 2 versions of this book: One for Excel 2003, and one for Excel 2007). Another book, “Excel Outside the Box” is available from and is for the very advanced Excel user. Another book, “More Excel Outside the Box” is also available from Lastly, published October 17 for Kindle, is “Excel Preschool: Finally Understanding what Excel is all About” – a book for the very beginner!
He has co-authored several chapters in many books on Excel and has done the technical editing for 4 new books for Excel 2019, as well as about 12 books for prior versions of Excel.
Mr. Umlas used to co-lead the New York PC User’s group on Excel every month for about 10 years. He started leading this group again in 2018. He has been teaching Excel to individuals and corporations for several years. Currently, Mr. Umlas leads a 12-hour class in Excel called Excel in Depth and a 6-hour class on VBA(see, click on “Virtual Classroom”, then click on Virtual Classroom Schedule, choose Microsoft® Excel in Depth, click “See your selection”, click “Course Outline”).
At the completion of the 2013 world Excel Modeloff competition on 12/8/13, this was noted (see the last sentence):
“The winners were announced at Microsoft’s Manhattan offices Sunday afternoon. Four teams of finalists competed in four rounds of Excel Golf, trying to get the shortest formula to solve four particular problems. The Australia/New Zealand team won this event, sharing a $4000 prize. I’ll note that Excel MVP Bob Umlas was in the audience and twice offered formulas that were shorter than the winning formula”

Learn more about Bob Umlas at

See you in the online live class session!

Join the Community:


Recording of past sessions are available at​​​​​​​

Leave a Reply

Close Menu