The Blessing of a Quiet Week

Things have been quiet at the Wyatt household this past week. I count that as a blessing, given all the events and activities of the past few months. My wife (who broke her shoulder in January) continues to heal, and her physical therapy is going well. According to the doctors, she just needs to keep doing what she is doing and, over time, continue to work on mobility and strength.

I hope that you are enjoying your Spring and that you also enjoy the tips in this week's newsletter.

—Allen
     

ExcelTips (menu) for 20 April 2024

Date formulas
Every Second Tuesday

Need a way to enter dates from every second Tuesday (or some other regular interval)? Excel makes it easy, providing several different methods of entering the information.

Read this tip »

 
Data Validation
Specifying a Data Validation Error Message

Data validation is a great tool for limiting what can be input into a cell. Excel allows you to specify what should appear on the dialog box displayed whenever data validation detects a problem with what is input.

Read this tip »

 
PivotTables Make You Feel Faint?

Do you get weak in the knees when asked to deal with huge amounts of data? Forget feeling faint ever again when you are asked to deal with PivotTables. Learn much more than the basics with PivotTables for the Faint of Heart, now available in three great versions.

 
Workbooks
Updating Links in Copied Files

When you copy workbooks that contain links, you may be at a loss as to how to update those links. There are a couple of ways you can approach the task, as discussed in this tip.

Read this tip »

 
Cell formatting
Creating 3-D Formatting for a Cell

The formatting capabilities provided by Excel are quite diverse. This tip examines how you can use those capabilities to make the contents of a particular cell "pop" off the page.

Read this tip »

ExcelTips is a free service of Sharon Parq Associates. You can find thousands of tips at our website and a whole lot more. ExcelTips is part of the Tips.Net network.
Sharon Parq Associates, Inc.  •  PO Box 1187  •  Mountain View, WY  82939  •  307-200-0450