-
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: October 2011
Tom’s Tutorials For Excel: Delete Rows With Blank Cells
Tom’s Tutorials For Excel: Delete Rows With Blank Cells Sometimes you have a list for which you need to delete rows where a cell is blank in a particular column. If the list is small, you can eyeball each blank … Continue reading
Tagged @TomUrtis/Atlas on Twitter, atlas, Atlas Program Management, Atlas programing management, Atlas Programming on Facebook, Delete Rows With Blank 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 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 Tutorials For Excel: More Date Formulas
Tom’s Tutorials For Excel: More Date Formulas Following up on yesterday’s theme, here are more common scenarios involving date calculations. Referring to the picture… …The formula in cell B3 that is copied across to cell G3 for last day of … 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: Date Formulas
Tom’s Tutorials For Excel: Date Formulas Here are a few date formulas for common situations. Referring to the picture… …The formula for text and date in cell C1 is =”Today’s date is “&A2 The better formula in cell C2 is … Continue reading
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
Tom’s Tutorials For Excel: Match From List
Tom’s Tutorials For Excel: Match From List The below picture shows one way to see if any member of a collection of smaller strings (what I call “Key Codes”) are found in a much longer Product Code string. The formulas … 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's Tutorials for Excel
Leave a comment
Tom’s Tutorials For Excel: LOOKUP With Multiple Criteria
Tom’s Tutorials For Excel: LOOKUP With Multiple Criteria Sometimes you need to look up a value based on more than one criteria, a task for which VLOOKUP falls short. In the picture labeled Example 1, see how you you can … 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, LOOKUP With Multiple Criteria, Microsoft Excel, Microsoft MVP, Microsoft Office, Tom Urtis, Tom's Tutorials for Excel
3 Comments
Tom’s Tutorials For Excel: The HLOOKUP Function
Tom’s Tutorials For Excel: The HLOOKUP Function HLOOKUP is a function not as easily grasped nor widely used as its VLOOKUP counterpart, probably for good reason as most lists are vertical in nature. The picture shows an example of using … 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, The HLOOKUP Function, Tom Urtis, Tom's Tutorials for Excel
1 Comment
Tom’s Tutorials For Excel: Show Your Named Ranges
Tom’s Tutorials For Excel: Show Your Named Ranges If you actually want to see your named ranges labeled on your worksheet, you can set your window’s Zoom to 39% or less. Here’s an example. In this first picture is a … 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's Tutorials for Excel
Leave a comment
Tom’s Tutorials For Excel: The NPV (Net Present Value) Function
Tom’s Tutorials For Excel: The NPV (Net Present Value) Function Excel’s NPV (Net Present Value) function calculates the net present value of an investment by using a discount rate, and a series of future payments (regarded as negative values) and … 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, The NPV (Net Present Value) Function, Tom Urtis, Tom's Tutorials for Excel
Leave a comment
