-
Newest Blog Post
-
Recent Posts
- Tom’s Tutorials For Excel: Getting Unique Items From a List
- Tom’s Tutorials For Excel: What time is it *Really*? Ask the US Navy With a Web Query
- Tom’s Tutorials For Excel: Locating Your PivotTable’s Occupied Range
- Tom’s Tutorials For Excel Videos: Explaining Array Formulas
- Tom’s Tips For Excel: Using an InputBox and Looping Dates for Copy and Sum
Recent Comments
- Tom Urtis on Tom’s Tutorials For Excel Videos: Explaining Array Formulas
- Brady on Tom’s Tutorials For Excel Videos: Explaining Array Formulas
- Tom Urtis on Tom’s Tutorials For Excel: Sorting Birthdays, Excluding the Year
- Joseph on Tom’s Tutorials For Excel: Sorting Birthdays, Excluding the Year
- Tom Urtis on Tom’s Tutorials For Excel: Getting Unique Items From a List
Archives
Akismet Spam Counter
Total Spam Fought: 20,275
Author Archives: DanaH
Happy Hanukkah !
Happy Hanukkah! It’s a festive season everywhere! Tonight is the first night of Hanukkah for my Jewish friends. This canine pal & I say [or woof] L’Chaim! to all …Tom
Tom’s Tutorials For Excel: Automatically Show UPPER Case Text In Cells
Automatically Show UPPER Case Text In Cells If you want to make sure that text entries in lower case — even alphanumeric entries — will automatically be displayed in UPPER case as soon as the entry is made, here’s how … Continue reading
Tagged @TomUrtis/Atlas on Twitter, atlas, Atlas Program Management, Atlas programing management, Atlas Programming on Facebook, Automatically Show UPPER Case Text In Cells, Excel, excel how to, frequently asked questions about Excel, innovative use of Excel, Microsoft Excel, Microsoft MVP, Microsoft Office, Tom Urtis, Tom Urtis/ Atlas on facebook, Tom's Tutorials for Excel
Leave a comment
Tom’s Tutorials for Excel: Auto-Sort By Double-Clicking a Cell
Tom’s Tutorials for Excel: Auto-Sort By Double-Clicking a Cell This example toggles a sort in ascending and descending order for a table of data whose headers are in row 1. When you double-click any cell in the data range, the … Continue reading
Tagged @TomUrtis/Atlas on Twitter, atlas, Atlas Program Management, Atlas programing management, Atlas Programming on Facebook, Auto-Sort By Double_Clicking a Cell, Excel, excel how to, frequently asked questions about Excel, innovative use of Excel, Microsoft Excel, Microsoft MVP, Microsoft Office, Tom Urtis, Tom Urtis/ Atlas on facebook, Tom's Tutorials for Excel
Leave a comment
VETERAN’S DAY
VETERAN’S DAY I am proud of my Veteran Dad. Here, photos from the memorable time I took my parents to the World War II Memorial 7 years ago from today, the first Veteran’s Day it was open.
Tom’s Tips for Excel Quick Tips Review from October 10 to October 14, 2011
Tom’s Tips for Excel Quick Tips Review from October 10 to October 14, 2011 More new Quick Tips posted in the past week, first seen as “tweets” at Tom Urtis on Twitter. Follow me on Twitter to catch them, links … Continue reading
Tagged @TomUrtis/Atlas on Twitter, atlas, Atlas Program Management, Atlas programing management, Atlas Programming on Facebook, Excel, excel how to, frequently asked questions about Excel, innovative use of Excel, Microsoft Excel, Microsoft MVP, Microsoft Office, Quick Tips, Tom Urtis, Tom's Tips for excel, Tom's Tips for Excel Weekend Review: Quick Tips
Leave a comment
Tom’s Tips for Excel Quick Tips Review from October 3 to October 7, 2011
Tom’s Tips for Excel Quick Tips Review from October 3 to October 7, 2011 20 brand new Quick Tips posted last week, first seen as “tweets” at Tom Urtis on Twitter. Follow me on Twitter to catch them, links to … Continue reading
Tagged @TomUrtis/Atlas on Twitter, atlas, Atlas Program Management, Atlas programing management, Atlas Programming on Facebook, Excel, excel how to, Excel VBA 24-Hour Trainer, frequently asked questions about Excel, innovative use of Excel, Microsoft Excel, Microsoft MVP, Microsoft Office, Tom Urtis, Tom Urtis/ Atlas on facebook
Leave a comment
Sunday Shortcuts, September 11, 2011: Last Week’s Tutorials
Sunday Shortcuts, September 11, 2011: Last week’s Tutorials In deference to the 10th anniversary of 9/11, this week’s Sunday Shortcuts is brief and to the point. Here are all of Tom’s Tutorials for Excel from last week. Thank you for … Continue reading
Tagged @TomUrtis/Atlas on Twitter, atlas, Atlas Program Management, Atlas programing management, Atlas Programming on Facebook, Excel, excel how to, frequently asked questions about Excel, innovative use of Excel, last week's tutorials, Microsoft Excel, Microsoft Office, SUNDAY SHORTCUTS, Tom Urtis/ Atlas on facebook, Tom's Tutorials for Excel
Leave a comment
How to: Selecting a Dynamic Range
Tom’s Tutorials For Excel: Selecting a Dynamic Range Here is a contribution by Tom Urtis to the library of MSDN. Sometimes you need to locate and manipulate a range of data on the worksheet, but you will not know where … Continue reading
Tagged @TomUrtis/Atlas on Twitter, alphanumeric ascending order, atlas, Atlas Program Management, Atlas programing management, Atlas Programming on Facebook, Excel, excel how to, frequently asked questions about Excel, How to: Select a Range, innovative use of Excel, Microsoft Excel, Microsoft Office, MS Office 2010, Tom Urtis, Tom Urtis/ Atlas on facebook, Tom's Tutorials for Excel
Leave a comment
Sunday Shortcuts, September 4, 2011: The week’s Tutorials and a Tune
Sunday Shortcuts, September 4, 2011: The week’s Tutorials and a Tune It’s been that last of summer week, finishing projects before Fall, heatwaves or hurricanes, kids starting school and a few less folks on the internet. I hope everyone is … Continue reading
Tagged @TomUrtis/Atlas on Twitter, atlas, Atlas Program Management, Atlas programing management, Atlas Programming on Facebook, Excel, excel how to, frequently asked questions about Excel, innovative use of Excel, Microsoft Excel, Microsoft MVP, Microsoft Office, Tom Urtis, Tom Urtis/ Atlas on facebook, Tom's Tutorials for Excel, Weekend review
2 Comments
Tom’s Tutorials For Excel: SUMIF With Multiple Criteria
Tom’s Tutorial For Excel: SUMIF for Multiple Criteria The SUMIF function handles one criteria argument, which is great if you only need to sum for one criteria. But what if you want to sum for two or more criteria? In … Continue reading
Tagged @TomUrtis/Atlas on Twitter, atlas, Atlas Program Management, Atlas programing management, Atlas Programming on Facebook, Excel, frequently asked questions about Excel, innovative use of Excel, Microsoft Excel, Microsoft MVP, Microsoft Office, Tom Urtis, Tom Urtis/ Atlas on facebook, Tom's Tutorials for Excel
Leave a comment