Excel Named Ranges
-
Speaker : BOB UMLAS
-
When : Friday, September 13, 2024
-
Time : 01 : 00 PM EST
-
Add To Calendar
Refer a Friend
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 (Mr. Excel) 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.
A Named Range is a feature that allows you to assign a meaningful name to a specific cell, range of cells, formula, or constant value in a worksheet. Instead of referring to cells by their standard cell references (like A1, B2, etc.), you can use a custom name that makes it easier to understand and manage your data and formulas.
Areas Covered
- Readability and Clarity: Named Ranges provide descriptive names for cells or ranges of cells, making formulas and references more understandable at a glance.
- Ease of Formula Writing: Using Named Ranges simplifies formula creation and maintenance by replacing complex cell references with meaningful names.
- Reduced Errors: Named Ranges reduce the risk of errors in formulas caused by mistyped or incorrect cell references.
- Flexibility and Scalability: If your data range expands or contracts, you can update the Named Range definition once, and all formulas using that name automatically adjust.
- Improved Data Validation and Formatting: Named Ranges can be used in data validation rules and conditional formatting, allowing for consistent and efficient data management.
- Easier Navigation: Named Ranges simplify navigation within large worksheets, allowing you to quickly jump to specific sections or elements by name.
- Enhanced Documentation: Using Named Ranges provides self-documenting features in your spreadsheet, helping others (and yourself) understand the purpose and context of data.
- Better Auditability: Named Ranges improve auditability by clearly identifying the purpose and scope of data elements used in formulas, reducing the time required to review and understand spreadsheet logic.
Who Should Attend
Anyone using Excel.
Why Should You Attend
Enhance your Excel skills; Make use of named ranges to self-document a formula.
(Example: =F3+SUM(Sheet2!C4:C15) vs =ThisYear+LastYear)
Topic Background
The instructor has been using Excel since 1986 and has gathered so many tricks and ways to think outside the box.
-
$160.00
-
