Speaker Profile
BOB UMLAS
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 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 http://www.iil.com/publishing as well as 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. One more, “Cool Excel Sh*t” is more tips & tricks. Lastly, published 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 books for Excel 2019, as well as about 12 books for prior versions of Excel and 4 books for Office 365’s Excel. He is also the technical editor of many of Bill Jelen’s books. 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 http://www.iil.com, 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”
Bob Umlas
February 24 2025
01 : 00 PM EST
90 Minutes
Using Conditional Formatting and Data Validation in Excel
This session on Excel's data validation and conditional formatting covers a comprehensive range of techniques designed to enhance data accuracy, consistency, and visualization. The training begins with an introduction to data validation, explaining its importance in ensuring that only correct and meaningful data is entered into a spreadsheet. Participants learn to set up basic validation rules, such as rest..
Bob Umlas
April 10 2025
01 : 00 PM EST
60 Minutes
Excel Essentials: Navigating and Customizing File Options
Excel's File/Options menu provides a wealth of customization and control features, organized into categories that allow users to tailor their Excel experience to their specific needs. The General category contains options for setting the default font, number of sheets in new workbooks, and user interface elements like the theme (e.g., light or dark mode). The Formulas category focuses on managing calculatio..
Bob Umlas
March 17 2025
01 : 00 PM EST
90 Minutes
Excel: Unleash the Power of Smart Formulas
A Webinar session on Excel's powerful formulas provides a structured and interactive learning experience designed to enhance participants' efficiency and confidence in working with data. The session begins with a brief introduction, where the instructor outlines the objectives, emphasizing the importance of mastering formulas for automating tasks, analyzing data, and solving real-world problems. The first p..
Bob Umlas
May 22 2025
01 : 00 PM EST
60 Minutes
Mastering the Fill Handle and Flash Fill in Excel
Microsoft Excel’s Fill Handle and Flash Fill are powerful tools that simplify data entry and manipulation, making them essential for anyone working with spreadsheets. These features are designed to save time, improve accuracy, and streamline workflows, particularly when dealing with large datasets or repetitive tasks. While they serve similar purposes of automating data entry, they work in different ways an..
Bob Umlas
June 18 2025
01 : 00 PM EST
60 Minutes
Excel Simplified: Mastering Filters for Data Clarity and Efficiency
This is designed to equip participants with practical skills to manage and analyze data effectively. This comprehensive course delves into the fundamentals of filtering, starting with an overview of Excel’s filter functions and their applications in various professional scenarios. Participants will learn how to apply basic filters to see data by specific criteria such as text, numbers, or dates, enabling qu..
Bob Umlas
July 23 2025
01 : 00 PM EST
60 Minutes
Excel Formatting Mastery: Transform Your Data for Maximum Impact
This webinar covers a comprehensive range of tools and techniques designed to enhance the appearance and functionality of your spreadsheets. It begins with the basics, such as applying fonts, colors, and borders to cells, ensuring that participants understand how to make their data visually appealing and easy to interpret. The session delves into alignment options, such as wrapping text, merging cells, and ..
Bob Umlas
August 19 2025
01 : 00 PM EST
60 Minutes
Excel Essentials: Pivot Tables in One Hour: Quickly Summarize and Analyze your Data
This webinar is an in-depth session aimed at equipping participants with the skills to transform raw data into meaningful insights using one of Excel’s most powerful features. The session begins with an introduction to PivotTables, explaining their purpose and the types of problems they solve. Participants learn how to create a basic PivotTable by selecting a dataset and choosing the fields to include. The ..
Bob Umlas
Recorded Webinar
60 Minutes
Excel Charts
Excel charts are visual representations of data created within Microsoft Excel. They allow users to present data in a graphical format, making it easier to analyze and interpret trends, patterns, and relationships. Excel offers a variety of chart types that can be customized to suit different data visualization needs. Some common types of Excel charts include: Column Chart, Bar Chart, Line Chart, Pie Chart,..
Bob Umlas
Recorded Webinar
90 Minutes
I Didn’t Know Excel Could Do That!
This Webinar describes, Keyboard Shortcuts: Learn and use keyboard shortcuts to perform common tasks quickly. For example, Ctrl+C for copy, Ctrl+V for paste, Ctrl+Z for undo, etc.Flash Fill: This feature helps you automatically fill values in a column based on patterns you establish. It's great for cleaning and formatting data quickly.AutoSum: Use the AutoSum function (Alt + =) to quickly sum a range o..
Bob Umlas
Recorded Webinar
60 Minutes
Using Excel Tables
This webinar describes,Structured Data Organization: Excel tables provide a structured way to organize and manage data. They automatically expand to include new data, making it easy to maintain and update your datasets without manually adjusting formulas or ranges.Dynamic Range Names: When you convert a range of data into an Excel table, it automatically assigns dynamic range names to each column. This make..