Tom’s Tutorials For Excel: Using VLOOKUP With MIN, MAX, and AVERAGE – Tom Urtis

Tom’s Tutorials For Excel: Using VLOOKUP With MIN, MAX, and AVERAGE
www.atlaspm.com/toms-tutoria...

Counting a specified month in a list of dates, and unique dates in a specified month.

Formatting a cell's positive, negative, and zero numbers to appear as custom-colored text.

Tom’s Tutorials For Excel: Copying Only a PivotTable’s PivotField to Another Worksheet – Tom Urtis

Tom’s Tutorials For Excel: Copying Only a PivotTable’s PivotField to Another Worksheet. www.atlaspm.com/toms-tutoria...

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

Tom’s Tutorials For Excel: Using XLOOKUP with the asterisk “*” wildcard character for reverse (right-to-left) and forward (left-to-right) lookups. Download this free, safe, interactive workbook. www.atlaspm.com/toms-tutoria...

Showing the INDIRECT function to use cell values that refer to worksheet tab names.

Showing 3 variations of coloring only the selected cell, or its row and column across the entire spreadsheet, or just inside the cell's current region.

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

Tom’s Tutorials For Excel: Using XLOOKUP with the asterisk “*” wildcard character for reverse (right-to-left) and forward (left-to-right) lookups. www.atlaspm.com/toms-tutoria... Download this free, safe, interactive workbook.

Tom’s Tutorials For Excel: Using XLOOKUP’s match_mode argument for lookups with mathematical operations for one formula. – Tom Urtis

Tom’s Tutorials For Excel: Using XLOOKUP’s match_mode argument for lookups with mathematical operations for one formula. Download this free, safe, interactive workbook. www.atlaspm.com/toms-tutoria...

Tom’s Tutorials For Excel: Using XLOOKUP’s match_mode argument for lookups with mathematical operations for one formula. – Tom Urtis

Tom’s Tutorials For Excel: Using XLOOKUP’s match_mode argument for lookups with mathematical operations for one formula. Download this free, safe, interactive workbook. www.atlaspm.com/toms-tutoria...

Tom’s Tutorials For Excel: Showing a double XLOOKUP (XLOOKUP with nested XLOOKUP) for an intersecting horizontal with vertical lookup. Download this free, safe, interactive workbook.

SUMPRODUCT instead of VLOOKUP, XLOOKUP or INDEX MATCH

Creating new worksheets from a list of names, and hyperlinking the text items in that list to their respective new worksheets.

Formulas to create a unique, and a unique sorted list.

Case-sensitive Lookup.

Lookup at intersect of row and column.

Selecting all worksheets as a group that have (optionally case-insensitive) "budget" in their tab names.

Using a formula to transpose a horizontal range vertically.

Tom’s Tutorials For Excel: Using Undo For Several Actions at Once – Tom Urtis

Tom’s Tutorials For Excel: Using Undo For Several Actions at Once. www.atlaspm.com/toms-tutoria...

Tired of wasting 80% of reporting time on #DataCleaning? 😩 In this quick video, Ken Puls explains why you need to learn #PowerQuery to automate you #DataPreapration processes and get HOURS of your life back! 😎

Learn how in our Power Query Academy through @skillwave.training - go to skw-t.com/pqa

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

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

Disabling the pop-up menu when right-clicking onto a worksheet tab.

Showing how to stop seeing those annoying menu floaties!

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.