Bob Umlas
Bob Umlas has been using Excel since version 0.99 (on the Macintosh)! He was a contributing editor to Inside Microsoft Excel for many years. 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.
He 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 world-wide for his contributions in Excel. He is the author of “This isn’t Excel, it’s Magic!” which is available from http://www.iil.com/publishing as well as from Amazon.com. 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.
From 1998 to 2018 Bob worked for a major tax and accounting firm, using Microsoft Excel® 8 hours a day, writing custom applications for staff and clients.
Authored Articles
Excel? …in your dreams! (Well, they are in mine!)
By Bob Umlas
I think about Excel stuff probably over 8 hours a day! And there have actually been two times when I dreamed about an Excel trick I should try out! One of my dreams was in mid-2019, not long after Microsoft announced a new feature – “dynamic arrays”.
How to Hide and Show Rows and Columns in Microsoft Excel
By Bob Umlas, Excel MVP
In this article, we’ll explore the various ways to hide and show rows and columns. The bulk of the discussion will address columns, but it applies to rows as well (unless otherwise noted).
Microsoft Excel Grand Totals: You DON’T Need Long Formulas
By Bob Umlas, Excel MVP
Still using long formulas to create grand totals in Excel? There is a better way!
Microsoft Excel’s JUSTIFY Command
By Bob Umlas, Excel MVP
Have you heard of the Justify command in Microsoft Excel? Let’s take a look at it here.
Demystifying Microsoft Excel VLOOKUP
By Bob Umlas, Excel MVP
Using VLOOKUP in Microsoft Excel seems to be a mystery to many. But you do it all the time in real life. Well, it could be the same thing in Excel.
Microsoft Excel Basics: Separating First and Last Names in One Cell
By Bob Umlas, Excel MVP
We’ll show you how to separate first and last names in one cell using Microsoft Excel.
