Tom Urtis

45.5K posts

Tom Urtis

@TomUrtis

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

San Francisco, CA Katılım Mart 2011

13.8K Takip Edilen51.3K Takipçiler

Tom Urtis@TomUrtis·1h

Formatting positive numbers with a plus sign, and negative numbers with a minus sign.

English

124

Tom Urtis@TomUrtis·1d

Tom’s Tutorials For Excel: Transposing a Dynamic List From Horizontal to Vertical atlaspm.com/toms-tutorials…

English

330

Tom Urtis@TomUrtis·1d

Using a keyboard shortcut to quickly paste special for values a range of formulas into a range of static constants.

English

369

Tom Urtis@TomUrtis·2d

Tom’s Tutorials For Excel: Conditionally Format Five Highest or Lowest Numbers in a List.atlaspm.com/toms-tutorials…

English

333

Tom Urtis@TomUrtis·3d

Tom’s Tutorials For Excel: Validating an Entry as a Real Date. atlaspm.com/toms-tutorials…

English

682

Tom Urtis@TomUrtis·4d

Tom’s Tutorials For Excel: Adding and Subtracting Time in Hours Minutes and Seconds. atlaspm.com/toms-tutorials…

English

835

Tom Urtis@TomUrtis·5d

Showing your active window's named ranges by setting its Zoom property to 39% or less.

English

606

Tom Urtis@TomUrtis·6d

Tom’s Tutorials For Excel: Returning a Value From Every Nth Cell. atlaspm.com/toms-tutorials…

English

768

Tom Urtis@TomUrtis·22 Nis

Showing elapsed times with custom formats for hours, minutes, and decimalized sums.

English

1.1K

Tom Urtis@TomUrtis·21 Nis

Showing Conditional Formatting for dates that are equal to, greater than, and less than a specified date.

English

649

Tom Urtis@TomUrtis·21 Nis

Showing the AGGREGATE function to subtotal a list with hidden rows for the median of visible cells.

English

1.3K

Tom Urtis@TomUrtis·20 Nis

Tom’s Tutorials For Excel: Finding the Number Closest to Zero.atlaspm.com/toms-tutorials…

English

376

Tom Urtis@TomUrtis·19 Nis

Formatting to color and bold a specified word in all cells' constant strings.

English

616

Tom Urtis@TomUrtis·18 Nis

Tom’s Tutorials For Excel: Finding the Position of the First Integer in an Alphanumeric String. atlaspm.com/toms-tutorials…

English

451

Tom Urtis@TomUrtis·16 Nis

Tom’s Tutorials For Excel: Putting a Date on One Line and Time on Another Line in the Same Cell. atlaspm.com/toms-tutorials…

English

440

Tom Urtis@TomUrtis·16 Nis

Installing a control tip message when mousing over a disabled ActiveX control.

English

530

Tom Urtis@TomUrtis·15 Nis

Tom’s Tutorials For Excel: Using XLOOKUP for horizontal lookups. atlaspm.com/toms-tutorials… Download this free, safe, interactive workbook.

English

Tom Urtis@TomUrtis·13 Nis

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

English

101

3.9K

Tom Urtis@TomUrtis·11 Nis

Tom’s Tutorials For Excel: Evaluating Numbers as Being Whole or Decimal.atlaspm.com/toms-tutorials…

English

550

Tom Urtis@TomUrtis·10 Nis

Formatting a comment shape's individual lines of text with a different color.

English

430

Keşfet

@elonmusk @BarackObama @taylorswift13 @cristiano @BillGates @NASA @nikifrancismediavine @katyperry