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...
• 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.
|
"If YOU will
change, everything will change for you”
-- Earl Shoaff |
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)
dd - will return the day as a number with a leading zero (e.g. 01)
ddd - will return the abbreviated weekday (e.g. Sun)
dddd - will return the full weekday (e.g. Sunday)
m - will
return the
month as a number without a leading zero (e.g. 1)
mm - will return the month as a number with a leading zero
(e.g. 01)
mmm - will return the abbreviated month (e.g. Jan)
mmmm - will return the full month (e.g. January)
yy - will
return the
year as a 2-digit number (e.g. 10)
yyyy - will return the year
as a 4-digit number (e.g. 2010)
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.
Try out the
secrets in my
ebook for two months. If
they If you're not
100%
satisfied... ...simply
request a full
refund from ClickBank.com There's
absolutely no risk
to you.
"I purchased your eBook
and so did my boss. Even though we are both experienced Excel
user in the field of engineering and construction surveying, we find
that your
tips are top-notch and to the point; well above the standard
fodder you find in the range of Excel books available on the market.
Thank you" -- Richard J., Las Vegas, NV
don't save you 10 times
the price of the book...
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.
| Subscription Information |
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...
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
Copyright Francis J. Hayes All Rights Reserved.
8 Lexington Place, Conception Bay South, Newfoundland, Canada, A1X 6A2 Phone: 709-834-4630