Publication Date: June 16, 2010
This newsletter is being sent to 16,000+ Excel 'addicts' around the world
using Aweber, the best solution for managing your email campaigns.
If you having trouble displaying graphics in this email, I have
posted an online HTML version of this week's newsletter here.
Hi fellow Excel Addict,
About 6 months ago I crossed paths with another Excel 'addict' on the Internet. He reminded me of myself because he is someone who is passionate about Excel and enjoys sharing his knowledge with others. His name is Purna Duggirala and he is the CEO (Chief Excel Officer) of Chandoo.org. In a short time Purna (most people still think his name is Chandoo) has become a force to be reckoned with in the online world of Excel (especially charting).
A few months ago, Purna made a life-changing decision and quit his 'real' job and turned his online passion into a full-time business. (I really admire him for that. I'm even a little jealous) And from what I have seen since, that was a very smart decision.
In those few months Purna has started an online-video Excel training program called Excel School. Already he has had one group of students go through the program (registration for the current session closes on June 21) and, if the comments are any indication, it has been very well received. I was given access to the program for my review.
I have viewed several of the Excel School videos and have found that Purna covers the topics in detail and his lessons very clear and easy to understand. Excel School includes more than 20 hours of videos in a structured program covering 11 topics over a period of 12 weeks. Each topic contains several videos and sample workbooks that you can download and practice on.
Is Excel School for you?
I don't know...but if you are someone who is willing to invest a little money for the much greater return of increased productivity (and all the benefits that come from it), I think it's worth checking out.
Click here if you want to find out more details about exactly what Excel School offers and if it's something that you could benefit from. And PLEASE, feel free to let me know what you think about his program.
(DISCLAIMER: if you register for Excel School through the links above, I will receive a small commission. If you've known me for a while, you know I wouldn't recommend anything I didn't fully support. If you don't know me well, don't listen to my recommendation - just check it out and decide for yourself).
To your SUCCESS !
Francis Hayes (The Excel Addict)
If you want to send me an email...
This week's tips..
1) Identify Your Input Cells (XL2000-XL2007)
2) Create Custom Default Worksheet And Workbook Templates (XL2003/XL2007)
3) How To Drag and Drop Files To Open Them
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) How To Input/Display Minutes That Exceed An Hour (XL2000-XL2007)
2) Sorting Data Using Absolute Values (XL2000-XL2007)
3) Limit Your Internet Search To A Specific Website
You can still find last week's newsletter here.
You can access even more tips on my website by going to my members' page.
CAUTION: 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.
Identify Your Input Cells (XL2000-XL2007)
If you create workbooks for other users (even the ones for yourself), to make it clear which cells in your worksheet are input cells (as opposed to formulas and static text) adopt a standard font (or fill) color so they are easily identifiable.
Eighteen years ago, I began using blue as the standard font color for input cells and almost everyone in our company has adopted this. Now, it's easy to identify input cells in most company worksheets.
Note that if you use a fill color for your cells rather than a font color, this may result in undesirable results with your printed reports.
Create Custom Default Worksheet
And Workbook Templates (XL2003/XL2007)
The location of the XLSTART folder may be
Make a note of this location.
2) Open a blank workbook.
3) Delete all sheet tabs except for one;
4) If you want to change the default formatting for worksheet cells, such as the font and number formats, in Excel 2007, click the Cell Styles command in the Styles group on the Home tab. Then right click the Normal style and choose Modify. To change the default worksheet cells formatting in Excel 2003, from the Format menu select Style and click the Modify button.
5) Next select your preferred print settings in PageSetup. In Excel 2007, click the Page Layout tab. In Excel 2003 and earlier, click File, Page Setup. Make all the changes you want your default worksheets to have (i.e. margins, headers/footers, etc...);
6) Click cell A1 to make it the active cell for each new sheet;
7) Now we need to save the template to the XLSTART folder. In Excel 2003, from the File menu select Save As. In the Save as Type dropdown on the bottom of the dialog box, select Template (*.xlt) and browse to the XLSTART folder you located in Step 1 above. Change the suggested name to SHEET.XLT. This will be the default sheet used when you Insert a worksheet into a workbook. In Excel 2007, click the Office Button, Save As, Excel Workbook. In the Save as Type dropdown on the bottom of the dialog box, select Excel Template (*.xltx) and browse to the XLSTART folder you located in Step 1 above. Change the suggested name to SHEET.XLTX. This will be the default sheet used when you Insert a worksheet into a workbook.
8) If you prefer your new workbooks to have more than one sheet, copy the current sheet by holding down the CTRL key and dragging the sheet tab to the right. Rename the new sheet tabs to Sheet 2, Sheet 3, etc...;
9) Now we will save this same
personalized workbook as our default workbook template just by saving
it with a different file name. To do this, simply repeat Step
7 but this time save the workbook with a filename of BOOK.XLTX if you are
using Excel 2007 and BOOK.XLT if you are using Excel 2003
2) On the Commands tab, select Insert from the Categories box;
3) On the right side in the Commands box you will see a Worksheet button;
4) Using the left mouse button, drag this Worksheet button and drop it next to the New workbook button on your toolbar;
5) Close the Customize dialog.
If you are using Excel 2007, you can
quickly insert a new sheet by clicking the Insert Worksheet command (to
the right of the sheet tabs). However, if you have many sheet tabs in
your workbook, the Insert Worksheet command may not be visible. So I
recommend that you add the Insert Worksheet command to your QAT. (Alternatively you
can use Shift+F11
to insert a new sheet.)
2) In the 'Choose commands from' dropdown, select All Commands;
3) Scroll down and select the Insert Worksheet command and click the Add>> button;
4) If you don't already have the New Workbook command on your QAT you can add that one also. Note that the command name in the list is New, not New Workbook.
Now that you have done all of that,
whenever you open a new workbook or insert a new worksheet it will
always contain your preferred settings.
Try out the secrets in my ebook
for two months. If
they don't save
you 10 times the price of the book... If you're not 100% satisfied... ...simply request a full refund
from ClickBank.com There's absolutely no risk to you.
Try out the secrets in my ebook
for two months. If
they don't save
you 10 times the price of the book...
If you're not 100% satisfied...
...simply request a full refund
There's absolutely no risk to you.
How To Drag and Drop Files To Open Them
Do you know that most Windows programs allow you to open files by dragging and dropping them into the program's window. This little trick comes in handy when you want to open a particular file in a program other than the default program. For example, I use Windows XP Picture and Fax Viewer (the default) to view my digital photos, but when I want to edit them I use the Irfanview (http://www.irfanview.com) program.
I first open the program (less than full screen) and then drag files (from Explorer, the Desktop, or wherever) and drop them into the program's window. If the program's window is hidden behind another window, simply drag the file to the program's button on the Taskbar, hold it there for a second or two until the program window pops on top of the other windows, then drop the file in this window.
You also can use this tip to choose which program you want to open a text file in (including Excel) or open a HTML file in a text editor rather than your browser. There are many uses for this trick as you'll soon discover.
This is one of those 'you've-got-to-do-it-to-appreciate-it' tips.
I hope you find it as useful as I have.
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