Author | Lightnews

Tom Urtis @tomurtis.bsky.social · 4d

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

www.atlaspm.com

Tom Urtis @tomurtis.bsky.social · 9d

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

www.atlaspm.com

Tom Urtis @tomurtis.bsky.social · 10d

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.

Tom Urtis @tomurtis.bsky.social · 16d

SUMPRODUCT instead of VLOOKUP, XLOOKUP or INDEX MATCH

Tom Urtis @tomurtis.bsky.social · 24d

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

Tom Urtis @tomurtis.bsky.social · Sep 25

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

1 2

Tom Urtis @tomurtis.bsky.social · Sep 17

Case-sensitive Lookup.

1

Tom Urtis @tomurtis.bsky.social · Sep 16

Lookup at intersect of row and column.

Tom Urtis @tomurtis.bsky.social · Sep 11

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

Tom Urtis @tomurtis.bsky.social · Sep 10

Using a formula to transpose a horizontal range vertically.

Tom Urtis @tomurtis.bsky.social · Sep 3

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

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

www.atlaspm.com

Reposted by Tom Urtis

Ken Puls, FCPA, MS MVP @excelguru.ca · Sep 2

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

1

Tom Urtis @tomurtis.bsky.social · Aug 25

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

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

atlaspm.com

Tom Urtis @tomurtis.bsky.social · Aug 14

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

Tom Urtis @tomurtis.bsky.social · Aug 13

Showing how to stop seeing those annoying menu floaties!

Tom Urtis @tomurtis.bsky.social · Jul 31

SUMPRODUCT instead of VLOOKUP, XLOOKUP or INDEX MATCH.

1

Tom Urtis @tomurtis.bsky.social · Jul 29

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

Tom Urtis @tomurtis.bsky.social · Jul 22

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

Tom Urtis @tomurtis.bsky.social · Jul 18

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

Tom Urtis @tomurtis.bsky.social · Jul 10

Thanks Ken, and congratulations to you as well!

1

Tom Urtis @tomurtis.bsky.social · Jul 10

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

1 3

Tom Urtis @tomurtis.bsky.social · Jul 9

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

Tom Urtis @tomurtis.bsky.social · Jul 2

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

Charts and Chart Sheets – Tom Urtis

www.atlaspm.com

Reposted by Tom Urtis

Ken Puls, FCPA, MS MVP @excelguru.ca · Jun 27

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!

1 1

Tom Urtis @tomurtis.bsky.social · Jun 27

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

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

www.atlaspm.com