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 of cells. Excel will automatically suggest the range, and you can press Enter to accept.
VLOOKUP and HLOOKUP: These functions allow you to search for a value in a table and return a corresponding value. VLOOKUP searches vertically, while HLOOKUP searches horizontally.
Pivot Tables: Mastering pivot tables is a powerful skill. They allow you to analyze and summarize large datasets easily, providing insights through dynamic reports.
Conditional Formatting: Apply formatting rules to cells based on their values. This helps in visually highlighting important trends, outliers, or specific conditions in your data.
Data Validation: Control the type of data entered into a cell using data validation. This is useful for ensuring data accuracy and consistency.
IF Function: The IF function allows you to perform different actions based on a specified condition. It's handy for creating dynamic calculations and decision-making in your spreadsheets.
Named Ranges: Instead of using cell references, define named ranges for your data. This makes formulas more readable and helps in navigating large datasets.
Tables: Convert your data into Excel tables (Ctrl + T). Tables come with built-in features like filtering, sorting, and easy referencing, making data management more efficient.
Ctrl+Arrow Keys: Use Ctrl with arrow keys to quickly navigate through your data. Ctrl+Arrow Up/Down jumps to the beginning/end of a column, while Ctrl+Arrow Left/Right jumps to the beginning/end of a row.
Remove Duplicates: Easily remove duplicate values from your data using the "Remove Duplicates" feature. This is crucial for maintaining data accuracy.
Freeze Panes: Freeze rows or columns to keep headers visible while scrolling through large datasets. This is helpful when working with lengthy spreadsheets.

Webinar Oct 24 2025, Friday 01:00 PM EDT 90 Minutes Basic Level Code: GRC0000292

  • Named range trick you didn’t know
  • Some Excel oddities
  • Accessing the custom lists
  • Mailing Label trickery
  • Easy keyboard access to summarize data
  • Dynamic Array trickery
  • 5 different methods to do the same task
  • Amazing uses of the old Excel4 Macros!
  • Double space thousands of rows in seconds (faster than a macro!)
  • Merging cell trick and much more!

Anyone using Excel. For example, Data Analysts,  Financial Analysts,  Business Analysts,  Project Managers,  Marketing Professionals,  Sales Representatives,  Human Resources Specialists,  Operations Managers.

Learning about various tips and tricks will enhance your work, make it faster, and more fun, and wow your coworkers! These are fairly unknown in the industry even by many experts.

BOB UMLAS
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 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.

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: Understanding Microsoft Excel, finally!” – a book for the very beginner!

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 20 years. He started leading this group again in 2018. He has been teaching Excel to individuals and corporations for several years.

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”

  • 60 Mins | Oct 28, Tue , 01:00 PM EDT

This webinar is an in-depth session aimed at equipping participants with the skills to transform raw data into meaningfu...

BOB UMLAS By BOB UMLAS

  • 60 Mins | Oct 29, Wed , 01:00 PM EDT

During this webinar, we will review a definition of an unfair act or practice, and unfair and deceptive credit under UDA...

BOB UMLAS By BOB UMLAS

  • 90 Mins | Oct 31, Fri , 01:00 PM EDT

To work efficiently with formulas and functions you must start with clear understanding, good habits, and application of...

BOB UMLAS By BOB UMLAS

  • Oct 27, Monday | 01:00 PM EDT | 75 Mins

Tattoos were always associated with sailors, marines, and bikers. Not today. Over the past few decades, there has been r...

  • Oct 27, Monday | 01:00 PM EDT | 60 Mins

This webinar is for you if you ever find yourself in a difficult emotional situation where a cool head is necessary. Th...

  • Oct 27, Monday | 08:12 PM EDT | 90 Mins

Nisi earum est dicta ab perspiciatis expedita sint. Sint voluptatem deserunt autem rerum quia possimus ea asperiores. Fa...

By