I Didn’t Know Excel Could Do That!
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 been the host of the Excel Conference held in London for the past 3 years and is again hosting for 2024, as well as leading a session on tips and tricks. He is also leading a session at the Active Cell conference in Las Vegas in December 2023.
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.
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.
Areas Covered
- 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!
Course Level -Intermediate
Who Should Attend
Anyone using Excel. For example, Data Analysts, Financial Analysts, Business Analysts, Project Managers, Marketing Professionals, Sales Representatives, Human Resources Specialists, Operations Managers.
Why Should You Attend
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.
-
$200.00
-
