Publication Date: February 24, 2010
This newsletter is being sent to 14,000+ Excel 'addicts' around the world
using Aweber, the best solution for managing your email campaigns.
Hi fellow Excel Addict,
My goal is to help you improve your Excel skills little by little, week by week by sharing these easy, fast and fun tips. Over time these will add up to save you a tremendous amount of time and frustration. And we can all use some extra time and less frustration.
My philosophy has always been that there's always an easier and better way to do just about anything -- if you're willing to look a little harder. Surprisingly, most people are happy with the way things are and put little or no effort into improving themselves. The fact that you're subscribed to my newsletter tells me that you are not one of those people standing still.
I hope you'll take something from this week's tips and I look forward to talking to you again next week.
Keep on Exccelling
Francis Hayes (The Excel Addict)
If your want to send me an email...
• Please type 'The Excel Addict' in the Subject field of your emails.
• If you reply to this email, please delete the newsletter content before sending.
• Remove background color in Outlook 2007 - Options, Page Color, No Color.
This week's tips..
1) Show Day Names With Your Dates (XL2000-XL2007)
2) Color Your Sheet Tabs (XL2002-XL2007)
3) Bring Order To Your Programs Menu (WinXP)
If you're having trouble displaying graphics in this email, I have posted an online HTML version of this week's newsletter here.
Last week's tips were...
1) Formula Troubleshooting Trick (XL2000-XL2007)
2) Insert Line Breaks To Make Complex Formulas Easier To Read (XL2000-XL2007)
3) Group Or Ungroup Your Taskbar Buttons? (WinXP)
You can still find last week's newsletter here.
You can access even more tips on my website by going to my members' page.
Make sure you save a copy of your spreadsheet before trying these tips, just in
case you make an error or the procedure doesn't produce the results you want.
Show Day Names With Your Dates (XL2000-XL2007)
If you ever need to show the name of the day in addition to the dates (e.g. Saturday, July 10) here are a couple of options.
Option 1: You can create a custom number format for the cells containing the dates
1) Press CTRL+1;
2) Select the Custom category;
3) In the Type field enter dddd, mmm y
Option 2: You can use the TEXT function to return a custom date based on a date in another cell.
Type =TEXT(A1,"dddd, mmm y") where A1 is a cell containing a date.
With both of these options, you have lots of flexibility for creating date formats by using any combination of the following codes.
d - will
return the day
as a number without a leading zero (e.g. 1)
m - will
month as a number without a leading zero (e.g. 1)
yy - will
year as a 2-digit number (e.g. 10)
You can also include commas, dashes, slashes, parentheses, within the format code. For example, the code (dddd) mmmm d, yyyy will return (Saturday) July 10, 2010.
Color Your Sheet Tabs (XL2002-XL2007)
An often overlooked feature in Excel (2002-2007) is the ability to apply color to your sheet tabs. This is useful for applying the same theme color to related sheets.
You simply right click on the sheet tab you want to apply a color to and select a color from the Tab Color option on the shortcut menu.
Bring Order To Your Programs Menu (WinXP)
As you install more and more programs on your computer, you'll notice that each new program gets added to the bottom of the Programs menu. When you go to run a program (Start, Programs), finding the right one can sometimes be a little difficult. Bring some order to this chaos by re-sorting these program shortcuts in alphabetical order.
Click Start, All Programs, right-click on either of the programs in the list and select 'Sort by Name' from the shortcut menu.
Spreadsheet Tips From An Excel Addict is available only to subscribers of my newsletter.
If this newsletter was forwarded to you and you would like to get your own copy, please visit TheExcelAddict.com or send a blank email to theexceladdict(AT)aweber(DOT)com
If you would like to share this newsletter with others...
1) Forward this newsletter by email, but first delete the unsubscribe link at the very bottom so you don't get accidentally unsubscribed
2) Ask your friend/colleague to visit TheExcelAddict.com or send a blank email to theexceladdict(AT)aweber(DOT)com
3) Post a link to TheExcelAddict.com in a company newsletter or website
|"Spreadsheets Tips From
An Excel Addict" is a weekly publication of TheExcelAddict.com.
Copyright Francis J. Hayes All Rights Reserved.
8 Lexington Place, Conception Bay South, Newfoundland, Canada, A1X 6A2 Phone: 709-834-4630