Bob Umlas

The Undisputed King of Excel Trickery

I have been using Excel since version 0.99 (on the Macintosh)! I was voted an “MVP” (Most Valuable
Professional) by Microsoft each year from 1993-2018. I’m the author of “This isn’t Excel, it’s Magic!” which is
available from Amazon.com. Another book, “Excel Outside the Box” is available from http://www.mrexcel.com
and is for the very advanced Excel user. Another book, “More Excel Outside the Box” is also available from
mrexcel.com. Also, there’s a kindle book, “Excel Preschool: Finally Understanding what Excel is all About” – a
book for the very beginner!
I lead the New York PC User’s group on Excel monthly.

My Sessions

The Best Excel Tips & Tricks

You will learn the best Excel Tips & Tricks such as: Moving Totals to a new row using the new dynamic arrays (no VBA) Things you probably never knew Excel could do before How to copy page setups from one sheet to another (or all sheets) Generating 3D formulas A potpourri of very cool tips

Data Modelling & Formulas