-
Tom Urtis – Microsoft Excel Consulting, Training, and Testing
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 knowle...
-
About | Microsoft Excel Consulting and Tutorials
Consulting
Atlas Programming Management is a business solutions consultancy specializing in Microsoft Office, particularly Excel. Atlas designs, develops, programs, installs and supports customized, a...
-
Blog – Tom Urtis
Here is how you can run a PowerPoint presentation from Excel, with the below macro named “PowerPointSlideshow”. This macro is also in the downloadable workbook named “RunPowerPointExample” through a l...
-
Tom’s Tutorials For Excel: Using VLOOKUP With MIN, MAX, and AVERAGE – Tom Urtis
Hi Dianne – –
I think the formula is correct the way VLOOKUP works. I looked at the data and I see that, dissecting the VLOOKUP AVERAGE formula, first, the average number for range A4:A22 is 5218. Not...
-
Tom’s Tutorials For Excel: Adding and Subtracting Time in Hours Minutes and Seconds | Atlas
Times are entered as hours, minutes, and seconds. In your question, there are no hours involved, but to get the answer, you’d want to enter the times in a cell whereby Excel is comfortable working wit...
-
Tom’s Tutorials For Excel: Name your sheet tab same as cell value. – Tom Urtis
Congratulations about above code. it’s very useful.
with a small addition, (adding “&” after MsgBox “You used a character that violates sheet naming rules.” ) i could run it.
But, i have a bug when i ...