Tom Urtis
Tom Urtis is a Microsoft Office developer and programmer with 35 years of business management experience. Tom has earned an outstanding reputation for his customer service, industry knowledge and ability to work with a diverse, international clientele. Microsoft has recognized Tom with their Most Valuable Professional award for Excel every year from 2008 to 2022. 
Tom's Tutorials for Excel
Tom’s Tutorials For Excel: Programming the Anatomy of a Pivot Table and Pivot Chart
Tom’s Tutorials For Excel: Programming the Anatomy of a Pivot Table and Pivot Chart Here is a step by step example of how to program a pivot table and pivot chart, including how to place those objects exactly where you want them on your worksheet.Read More »
Tom’s Tutorials For Excel: Conditional Formatting examples for repeated items in a list.
Tom’s Tutorials For Excel: Conditional Formatting examples for repeated items in a list. The Conditional formatting rule for unique entries in range A3:A14 is =COUNTIF($A$3:$A$14,A3)=1 The Conditional formatting rule for non-unique entries in range B3:B14 is =COUNTIF($B$3:$B$14,B3)1 The Conditional formatting rule for repeated entries in range C3:C14 is =COUNTIF($C$3:C3,C3)1Read More »
Tom’s Tutorials For Excel: Running a PowerPoint Presentation From Excel
Tom’s Tutorials For Excel: Running a PowerPoint Presentation From Excel Download this Excel workbook that runs a PowerPoint presentation. Download this accompanying PowerPoint presentation. Here is how you can run a PowerPoint presentation from Excel,Read More »
Tom’s Tutorials For Excel: Importing an Access database table into Excel — a Quick Shortcut
Tom’s Tutorials For Excel: Importing an Access database table into Excel — a Quick Shortcut Here’s a shortcut to manually import an Access database table into your spreadsheet. It’ll come with the alternating shaded rows and field header drop-down arrows,Read More »
Tom’s Tutorials For Excel: Showing Your Column Headers as Letters or Numbers
You can show your column headers as letters or numbers. Here’s how to change column headers depending on your preferred look.Read More »
