-
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,273
Monthly Archives: November 2011
Tom’s Tutorials For Excel: Finding and Deleting Phantom Links
Tom’s Tutorials For Excel: Finding and Deleting Phantom Links If you’ve ever wondered why this message pops up after you are sure you’ve deleted all your workbook’s links, well, join the club. It’s a common problem because some links can … Continue reading
Tagged @TomUrtis/Atlas on Twitter, atlas, Atlas Program Management, Atlas programing management, Atlas Programming on Facebook, Excel, excel how to, Finding and Deleting Phantom Links, 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: Enter Zip Codes and Social Security Numbers With Leading Zeros
Tom’s Tutorials For Excel: Enter Zip Codes and Social Security Numbers With Leading Zeros When you enter numbers that start with a leading zero such as Social Security Numbers or United States zip codes, you must stop Excel from automatically … Continue reading
Tagged @TomUrtis/Atlas on Twitter, atlas, Atlas Program Management, Atlas programing management, Atlas Programming on Facebook, Enter Zip Codes and Social Security Numbers With Leading Zeros, Excel, excel how to, frequently asked questions about Excel, Microsoft Excel, Microsoft MVP, Microsoft Office, Tom Urtis, Tom Urtis/ Atlas on facebook, Tom's Tips for excel, Tom's Tutorials for Excel
Leave a comment
Tom’s Tutorials For Excel: Make Dates look Familiar When Combined With Words In A Formula
Tom’s Tutorials For Excel: Make Your Dates Readable When Combined With Text When combining dates with words in a formula, dates don’t always look like dates in the result. For example, the above picture shows a date in cell A1. … 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
Leave a comment
Tom’s Tutorials For Excel: Organize Your Mailing List With Excel’s Text-To-Columns Feature
Tom’s Tutorials For Excel: Organize Your Mailing List With Excel’s Text-To-Columns Feature If you are faced with a mailing list where each line of information was entered into a single cell, here’s how you can organize the list by separating … 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, Organize Your Mailing List With Excel’s Text-To-Columns Feature, Tom Urtis, Tom Urtis/ Atlas on facebook, Tom's Tutorials for Excel
Leave a comment
Toms Tutorials For Excel: Summing Time
Toms Tutorials For Excel: Summing Time In the pictures, the formula in cell B3 is =B2-B1 which returns the elapsed time in hours and minutes between the Start time and the End time. You want the visual value 6:45 (meaning … 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, Summing Time, Tom Urtis, Tom Urtis/ Atlas on facebook, Tom's Tutorials for Excel
Leave a comment
Tom’s Tutorials For Excel: Fill Formula to Last Used Row
Tom’s Tutorials For Excel: Fill Formula to Last Used Row The picture on the left shows a list of numbers in column A starting in cell A2. You have a formula in cell B2 which you want to quickly copy … Continue reading
Tagged @TomUrtis/Atlas on Twitter, Atlas Program Management, Atlas programing management, Atlas Programming on Facebook, Excel, excel how to, Fill Formula to Last Used Row, 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: Workbook Creation Date
Tom’s Tutorials For Excel: Workbook Creation Date If you want to know the creation date and time of the active workbook: Sub MyCreationDate() Dim myDate As Date myDate = ActiveWorkbook.BuiltinDocumentProperties(“Creation date”).Value MsgBox Format(myDate, “mmmm d, yyyy at h:mm:ss AM/PM”), , … 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, Workbook Creation Date
Leave a comment
Tom’s Tutorials For Excel: Open, Modify, and Close All Workbooks in a Folder
Tom’s Tutorials For Excel: Open, Modify, and Close All Workbooks in a Folder This topic touches on a surprise we all got when Microsoft released version 2007, which stopped supporting the VBA FileSearch method. When you need to open all … 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
Leave a comment
