Mr.Bob Umlas

Area Of Expertise : Microsoft Excel

25 Years Of Experience

Training Industry : Multi Industry

Bob Umlas worked for a major tax and accounting firm, using Microsoft Excel® 8 hours a day, writing custom applications for staff and clients from 1998 to 2018.

He has been using Excel since 1986 - 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 1994-2018 (25 years!) for his contributions to the various online Forums about Excel and is known world-wide 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 hosted London’s Global Excel Summit each year since 2021, and in person in 2024, as well as led a session on tips and tricks. He also led a session on tips and tricks at the Las Vegas’ Financial Modeling World Championship in December, 2023. He has led online sessions all over the world including Africa, India, England, Canada and of course, the USA.

9 results Found

Live Webinar

Pivot Tables

A pivot table in Excel is a powerful data summarization tool used to analyze, explore, and present large datasets in a flexible and interactive manner. It allows users to transform raw data into meaningful insights by organizing and aggregating data from a det ...

Basic & Intermediate
60 Mins
Sep 23, 2024

Live Webinar

Excel Tips & Tricks - Part 1

There are many shortcuts to do the work you do. This course shows many tips & tricks which many experts aren’t aware of and which save you lots of time. One of my favourite comments which came from this course was, “This Isn’t Excel, it’s Magic!” It also becam ...

Basic & Intermediate
90 Mins
Oct 16, 2024

Live Webinar

Excel Number Formatting (on Steroids)

A session on Excel formatting typically encompasses a range of techniques and tools designed to enhance the visual appeal and readability of spreadsheets. The session starts with basic formatting principles, such as adjusting cell styles, fonts, colors, and bo ...

Basic & Intermediate & Advanced
60 Mins
Oct 28, 2024

Live Webinar

Excel Tips & Tricks - Part 2

Basic & Intermediate
90 Mins
Nov 13, 2024

Live Webinar

Dynamic Arrays

Excel's dynamic arrays revolutionize how users handle and analyze data by allowing formulas to return multiple results that automatically spill into adjacent cells. Introduced with Excel 365, dynamic arrays simplify complex data tasks, making spreadsheets more ...

Basic & Intermediate & Advanced
60 Mins
Nov 21, 2024

Live Webinar

Excel Tips & Tricks - Part 3

Basic & Intermediate
90 Mins
Dec 09, 2024

Live Webinar

Excel Functions

Learning Excel's built-in functions offers significant benefits, enabling users to work more efficiently and make data-driven decisions with confidence. By mastering functions like VLOOKUP, IF, and SUMIF, users can automate repetitive tasks, reduce errors, and ...

Basic & Intermediate
90 Mins
Dec 19, 2024

Thank you for your interest in becoming a part of our faculty. ComplianceIQ is continuously looking for excellent individuals from diverse professions to add to our faculty records. Please complete the form below to be considered for our training arrangements in your area of expertise and then submit the form; we will get back as soon as possible.