Mr. Bob Umlas
Excel Trainer and ConsultantMr. 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. 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.
Bob 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 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. 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 is also the author of “This isn’t Excel, it’s Magic!”, “Excel Outside the Box”, “Excel Preschool: Finally Understanding what Excel is all About”.
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.
Recorded-webinar by: Mr. Bob Umlas
-
-
Excel: Advanced Formatting Techniques (365/2019)
-
Excel VBA 101: An Introduction to Automating Tasks and Enhancing Productivity
-
Maximizing Productivity with Excel: Unlock Incredible Time-Saving Shortcuts and Streamline Your Workflow
There are many shortcuts to doing 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 favorite comments which came from this course was, “This Isn’t Excel, it’s Magic!” It also became the title of one of my books!
You will become more efficient and save time once you’ve seen the amazing shortcuts and tips that are built into Excel. You will be wowed at the new ability you will have once these shortcuts are discovered.
-
Beyond VLOOKUP: Mastering Advanced Excel Formulas
-
Excel: Advanced Formatting Techniques (365/2019)
A complete session of formatting including numerous ways of formatting numbers, formatting cells (using borders, colors, and alignment), using Styles, and working with Objects. With this knowledge, you will make Excel more readable and even fun to look at!
This course not only shows how to make data more readable; it also shows ways to customize your work environment inside Excel to make it more pleasant to work in.
-
Excel VBA 101: An Introduction to Automating Tasks and Enhancing Productivity
VBA has been in Excel since around 1995. It has helped thousands of organizations improve their productivity since VBA can work several thousands of times faster than a person can. For example, VBA can loop 1 million times in under one second! Excel exists on millions of computers around the world and VBA is used by most organizations.
VBA is used in Microsoft Excel to create sophisticated tools that can be used in business, engineering, and science. VBA allows users a level of customization beyond what is typically available in Microsoft Office products, such as Excel, Word, and PowerPoint. Learning VBA programming can help Microsoft Office users access functions beyond what is directly available in the various Office applications.
VBA is fast. What may take a person hour to do, especially repeatedly, can be done via VBA in seconds, literally? Learning how to use VBA code can be an incredible time-saver.
-
Beyond VLOOKUP: Mastering Advanced Excel Formulas
You will learn functions that can work with your data in whatever format you want to complete a variety of tasks. You will also learn the limitations and pitfalls of each function so that you can determine which one is best for a particular application. This session will also cover the most recent additions to this area, such as XLOOKUP, XMATCH, and others.
-