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

Tagged | Leave a comment

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 , , , , , , , , , , , , , , , | 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 , , , , , , , , , , , , , , , | 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.

Tagged , , , | 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 , , , , , , , , , , , , , , , | 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 , , , , , , , , , , , , , , | 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 , , , , , , , , , , , , , , | 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 , , , , , , , , , , , , , , , , | 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 , , , , , , , , , , , , , , , | 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 , , , , , , , , , , , , , | Leave a comment