-
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: Tom Urtis
Tom’s Tutorials For Excel: Getting Unique Items From a List
Tom’s Tutorials For Excel: Getting Unique Items From a List In the following picture, you see a list of names, many of which are repeated 2, 3, or more times. Here’s how you can create a shorter list to show … 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, Tom's Tips for excel, Tom's Tutorials for Excel
2 Comments
Tom’s Tutorials For Excel: What time is it *Really*? Ask the US Navy With a Web Query
Tom’s Tutorials For Excel: What time is it *Really*? Ask the US Navy With a Web Query What is today’s date, and what is the current time of day? Here, you create a Web query to import a display 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: Locating Your PivotTable’s Occupied Range
Tom’s Tutorials For Excel: Locating Your PivotTable’s Occupied Range Here’s a macro to locate the first and last rows and columns, and the ranges being occupied by your pivottable. The (0, 0) notation after the Address property statements is 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, Tom's Tutorials for Excel
Leave a comment
Tom’s Tutorials For Excel Videos: Explaining Array Formulas
Tom’s Tutorials For Excel Videos: Explaining Array Formulas Here’s a video explaining what array formulas are, how to enter them, and a look behind the scenes to show how and why they work. Array formulas are a different animal, requiring … Continue reading
Tagged @TomUrtis/Atlas on Twitter, atlas, Atlas Program Management, Atlas programing management, Atlas Programming on Facebook, Excel, excel how to, Facebook, frequently asked questions about Excel, innovative use of Excel, Microsoft Excel, Microsoft MVP, Microsoft Office, Tom Urtis, Tom Urtis/ Atlas on facebook, Tom's Tips for excel, Tom's Tips for Excel Video, Tom's Tutorials for Excel, video, Youtube
2 Comments
Tom’s Tips For Excel: Using an InputBox and Looping Dates for Copy and Sum
Tom’s Tips For Excel: Using an InputBox and Looping Dates for Copy and Sum In January I posted this example for using AutoFilter for dates. AutoFilter is usually quicker and more efficient but I wanted to show how an example … 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, Tom's Tutorials for Excel
Leave a comment
Tom’s Tutorials For Excel: Toggling the GETPIVOTDATA Function On and Off
Tom’s Tutorials For Excel: Toggling the GETPIVOTDATA Function On and Off When you are doing calculations in cells outside of a pivot table that involve cells inside of (that is, belonging to) a pivot table, sometimes you want just the … 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, Tom's Tutorials for Excel
Leave a comment
Tom’s Tutorials For Excel: Event Code for Embedded Forms Controls
Tom’s Tutorials For Excel: Event Code for Embedded Forms Controls Commonly accepted wisdom has it that embedded controls from the Forms toolbar cannot be programmed for events, such as can be done for ActiveX controls. Here’s an example of 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 Urtis, Tom Urtis/ Atlas on facebook, Tom's Tutorials for Excel
Leave a comment
Tom’s Tips For Excel Videos: Filling Empty Cells With Value From Above
Tom’s Tips For Excel Videos: Filling Empty Cells With Value From Above Sometimes you get data in a column which has a lot of blank cells that represent whatever text was in the last filled cell above them. When you … 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 Tips for excel, Tom's Tips for Excel Video, Tom's Tutorials for Excel
3 Comments
Tom’s Tutorials For Excel: Filtering Automatically On Cell Entry
Tom’s Tutorials For Excel: Filtering Automatically On Cell Entry Here’s a developer’s approach to make things easy for your users who need to filter a range of data, based on a value they enter in a criteria cell. A Worksheet_Change … 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, Tom Urtis, Tom Urtis/ Atlas on facebook, Tom's Tutorials for Excel
Leave a comment
Tom’s Tutorials For Excel: Why Reset ScreenUpdating to True? Here’s Why!
Why Reset ScreenUpdating to True? Here’s Why! Occasionally a parroted claim will pop up in the Excel cybersphere that resetting ScreenUpdating from False back to True in a VBA procedure is pointless and unnecessary. Supporters of this claim mistakenly believe … 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
