-
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
Monthly Archives: January 2012
Tom’s Tutorials For Excel: SUMIF formula examples
Tom’s Tutorials For Excel: SUMIF formula examples Here are examples of formula constructions with the SUMIF function. When you want to refer to a cell in the formula, enclose the mathematical operators in quotes. In the pictured Example 1, the … 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, 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: Listing Your Worksheets
Tom’s Tutorials For Excel: Listing Your Worksheets Here are a few ways to list the names of the worksheets in your workbook. For starters, you can right-click on the sheet navigation buttons to the left of your sheet tabs, and … Continue reading
Tagged @TomUrtis/Atlas on Twitter, 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: Listing and Verifying Fonts
Tom’s Tutorials For Excel: Listing and Verifying Fonts While you can press Alt+O+E to call the Format Cells dialog box and see what fonts are available, with the below macro named ListFonts you can see your fonts on a worksheet … 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
The Twelve Phases of Project Development
The Twelve Phases of Project Development Taken and jerry-rigged from this famous image sequence.
Tom’s Tutorials For Excel: Printing Some Sheets, Not Printing Others
Tom’s Tutorials For Excel: Printing Some Sheets, Not Printing Others In some cases you want an easy way to print only certain sheets from your workbook. There are two approaches — identifying which sheets to include, or which sheets 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: Filtering Columns
Tom’s Tutorials For Excel: Filtering Columns Free and safe downloadable workbook to filter by columns As you know, Excel only provides a built-in method of filtering for rows by individual columns. If you want to filter columns by their row … 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: Showing or Hiding Specific AutoFilter DropDowns
Tom’s Tutorials For Excel: Showing or Hiding Specific AutoFilter DropDowns You might want to AutoFilter a range of data, but only have the AutoFilter drop-downs be visible in the header row for some columns and not for others. This is … Continue reading
Tom’s Tutorials For Excel: Showing And AutoClosing a UserForm
Tom’s Tutorials For Excel: Showing And AutoClosing a UserForm Sometimes you might want to only show a UserForm for a brief time, say 5 seconds. For example, you might want to show a quick message that’s custom-formatted beyond what 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 Tutorials For Excel: Force an Entry Into an InputBox
Force an Entry Into an InputBox Previously, I posted this example for capturing Cancel with InputBoxes. In some development situations, you may need to force the user to make an entry to an InputBox. The below example is one way … Continue reading
Tagged 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: Updating Links (or Not)
Tom’s Tutorials For Excel: Updating Links (or Not) You’ve no doubt seen this pop-up message upon opening a workbook: To automatically update links sans VBA, if the work being done is always on your computer… …In versions 2003 or before: … 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
2 Comments
