Tom Urtis

SUMPRODUCT instead of VLOOKUP, XLOOKUP or INDEX MATCH.

Populating a text box and a worksheet cell with a single delimited string of several selected checkbox items.

Automating your SpinButton to revert to its next valid value within a min and max numerical range.

This macro moves a worksheet’s embedded charts to their own chart sheet.

Thanks Ken, and congratulations to you as well!

I am honored to share that today I was re-awarded by Microsoft as an Excel MVP for my 16th year!

Showing Excel VBA's UNION method to simultaneously select (or operate upon without selecting) non-contiguous ranges.

Charts and Chart Sheets – Tom Urtis

Tom’s Tutorials For Excel: Move Embedded Charts to Their Own Chart Sheet www.atlaspm.com/tag/charts-a...

Our June newsletter is here, with a look on what's new this month in #Excel and #PowerBI, as well as info on my courses, conferences, and other events and specials. 📧

If you're not on our newsletter list, you can join at xlguru.ca/newsletter. We'll also send you our free 'DIY BI' eBook series!

Tom’s Tutorials For Excel: Entering New Lines and Bullets in a Cell – Tom Urtis

Tom’s Tutorials For Excel: Entering New Lines and Bullets in a Cell. www.atlaspm.com/toms-tutoria...

Tom’s Tutorials For Excel: Using SUMPRODUCT on Multiple Columns www.atlaspm.com/toms-tutoria...

Tom’s Tutorials For Excel: Customizing the Status Bar – Tom Urtis

Tom’s Tutorials For Excel: Customizing the Status Bar
www.atlaspm.com/toms-tutoria...

Showing the INDIRECT function maintaining a formula's intended range reference when inserting new rows inside the calculation range.

Showing the keyboard shortcut Ctrl+Shift+F that opens the Format Cells dialog box with the Font tab selected.

Tom’s Tutorials For Excel: Showing how Excel’s FILTER function extracts different combinations of “and” and “or” criteria records within a single formula. – Tom Urtis

Tom’s Tutorials For Excel: Showing how Excel’s FILTER function extracts different combinations of "and" and "or" criteria records within a single formula.

www.atlaspm.com/toms-tutoria...

A free, safe, downloadable interactive workbook is included!

Tom’s Tutorials For Excel: Showing how Excel’s FILTER function extracts different combinations of “and” and “or” criteria records within a single formula. – Tom Urtis

Tom’s Tutorials For Excel: Explaining Excel’s FILTER function to extract multiple "or" criteria records, by using the plus + operator. A free, safe, downloadable interactive workbook is included!
www.atlaspm.com/toms-tutoria...

Tom’s Tutorials For Excel: Using XLOOKUP with the question mark “?” wildcard character for reverse (right-to-left) and forward (left-to-right) lookups. – Tom Urtis

Tom’s Tutorials For Excel: Using XLOOKUP with the question mark "?" wildcard character for reverse (right-to-left) and forward (left-to-right) lookups.
A free, safe, downloadable interactive workbook is included!
www.atlaspm.com/toms-tutoria...

Tom’s Tutorials For Excel: Understanding the XLOOKUP function’s match_mode optional fifth argument for exact and inexact matches. – Tom Urtis

Tom’s Tutorials For Excel: Understanding the XLOOKUP function’s match_mode optional fifth argument for exact and inexact matches. A free, safe, downloadable interactive workbook is included! www.atlaspm.com/toms-tutoria...

Tom’s Tutorials For Excel: Explaining the XLOOKUP basics: reverse (right-to-left) and forward (left-to-right) lookups. – Tom Urtis

Tom’s Tutorials For Excel: Explaining the XLOOKUP basics: reverse (right-to-left) and forward (left-to-right) lookups.
www.atlaspm.com/toms-tutoria...

Showing examples to list random unique numbers between a low and high range, using formulas without VBA.

Calculating a date for Easter. #MSExcel #ExcelTips #ExcelTipsAndTricks

Calculating the maximum difference between two lists of numbers, and finding its row.

5th Anniversary of Monkey Tools Save 20% on an Annual or Lifetime Pro License Use code: MONKEY5 Valid March 24-28, 2025 monkeytools.ca

5th Anniversary of Monkey Tools Your chance to win! All Lifetime Pro Licenses = Entry for 1 year of Self Service BI Academy (a $995 value) All Annual Pro Licenses = Entry for 1 year of Power Query Academy ($350 value) Anyone with an active Lifetime or Annual license on March 28, 2025 will be automatically entered into the draw.

Today is the last day of our #MonkeyTools 5th anniversary special! 🥳
Until midnight tonight, save 20% on an Annual or Lifetime Pro license, just go to mkyt.ca/5years and use code MONKEY5
Plus, anyone with a Lifetime or Annual license has a chance to win access a @skillwave.training course!

5th Anniversary of Monkey tools Save 20% on an Annual or Lifetime Pro License! Use code: MONKEY5 Valid March 24-28, 2025 monkeytools.ca

5th Anniversary of Monkey Tools Your chance to win! All Lifetime Pro Licenses = Entry for 1 year of Self Service BI Academy (a $995 US value) All Annual Pro Licenses = entry for 1 year of Power Query Academy (a $350 US value) Anyone with an active Lifetime or Annual license on March 28, 2025 will automatically be entered into the draws.

Today marks 5 years since our #MonkeyTools #Excel add-in was officially launched! 🥳To celebrate, we're offering a 20% discount on Annual or Lifetime licenses. From now until March 28, use code MONKEY5 at checkout - go to mkyt.ca/5years

Plus, you get a chance to win a @skillwave.training course.🐵

Showing a double XLOOKUP (XLOOKUP with nested XLOOKUP) for an intersecting horizontal with vertical lookup.
#MSExcel #ExcelTips

Using XLOOKUP with the asterisk "*" wildcard character for reverse (right-to-left) and forward (left-to-right) lookups. #MSExcel #ExcelTips #MSExcelMVP

Getting the height of a single row, or a sum of the combined heights of many rows.

Conditionally operating on numbers within minimum and maximum boundaries. #ExcelTips #MSExcel

Showing the WEEKNUM function to return the week number of all dates in the year 2026. #Excel #MSExcel #ExcelTips

Understanding the XLOOKUP function's match_mode optional fifth argument for exact and inexact matches. #MSExcel #ExcelTips