Tom Urtis (@TomUrtis) header
Tom Urtis (@TomUrtis) profile picture

Microsoft Excel MVP, Excel skills testing, project developer, trainer, author. Stanford & Michigan State athletics.

San Francisco, CA
Joined March 2011
Photo by Tom Urtis (@TomUrtis)Photo by Tom Urtis (@TomUrtis)Photo by Tom Urtis (@TomUrtis)Photo by Tom Urtis (@TomUrtis)Photo by Tom Urtis (@TomUrtis)Photo by Tom Urtis (@TomUrtis)Photo by Tom Urtis (@TomUrtis)Photo by Tom Urtis (@TomUrtis)Photo by Tom Urtis (@TomUrtis)Photo by Tom Urtis (@TomUrtis)
Here is Microsoft’s What’s New in Excel blog for October 2026, for naming Tables at creation in XL for Windows, and Copilot can-do’s for data skills. techcommunity.microsoft.com/…
20
1,105
Showing formula syntaxes that return the count of days between today and a future date.
15
1,374
Using a keyboard shortcut to quickly paste special for values a range of formulas into a range of static constants.
5
920
Keyboard shortcut to select the next or previous worksheet.
19
1,182
Identifying the source row and listing a selected record's contents of a ListBox having vertical field dividers.
10
960
Showing a vertical divider between ListBox fields without affecting the worksheet or source data range.
6
712
Parsing a string at the position of the first numeric character.
7
801
Reordering field locations in a VBA array.
1
17
1,187
Selecting all worksheets as a group, or deselecting all but one worksheet.
9
835
Selecting more than one worksheet as a group.
1
16
999
Showing your active window's named ranges by setting its Zoom property to 39% or less.
5
704
Reordering field locations in a VBA array.
8
996
Operating with the last number in a dynamic list.
9
924
Showing elapsed times with custom formats for hours, minutes, and decimalized sums.
1
12
1,055
Extracting text between character sets of differing types, lengths, and instances.
1
7
865
Open a new Word document from Excel with this macro.
7
1,614
Listing incremental cell values into a contiguous range, using two function alternatives: OFFSET and INDEX.
1
15
1,103
Many will argue #Excel is NOT a database.🥊 But, at our Nov 5 Vancouver #PowerBI and Modern Excel meet-up, Richard Nero will show how in a few clicks you can turn Excel workbooks into cloud based #SQL databases that fuel #AIAgents. Sign up here to join us: meetup.com/vancouver-power-b…
1
1
400
Counting multiple criteria in more than one criteria range.
1
17
1,037
Looking up the max (or min or average) for each unique item in a list.
2
1
18
1,775