Back to Newsletter Archives
Back to The Software Pro Home
Smart & Easy Software Tips: Excel Tricks-November 2004, #1
Welcome to our many new subscribers who signed up through
http://www.SoftwarePro.com
(see bottom to leave "Smart & Easy Software Tips")
============================================================
Smart & Easy Software Tips, Tricks & Techniques
November 2004 - Issue 1
Publisher: Dawn Bjork Buzbee mailto:Dawn@SoftwarePro.com
The Software Pro (tm), Microsoft Certified Office Expert
http://www.SoftwarePro.com
============================================================
IN THIS ISSUE - Excel: Easy to Expert Tips
============================================================
1. Secret Workbook Navigation
2. Displaying Formulas
3. More Than AutoSum
4. Excel Macro Examples
5. Spreadsheet Jokes
6. Do You Need Content?
=====================================================
1. Secret Workbook Navigation
=====================================================
When you work with workbooks that contain multiple worksheets,
you can waste too much time moving between each worksheet. One
way to navigate between worksheets is to use each of the four
triangular buttons in the bottom left corner to move to a
specific worksheet tab (First, Previous, Next, Last).
There is a hidden trick that is even handier especially with a
large group of worksheets. First, point your mouse to any of the
navigation buttons in the bottom left corner. Next, right-click
for a shortcut menu of all of the available worksheets (look for
More Sheets... if you have a larger group of worksheets).
Finally, left-click on the name of the worksheet you want to
move to and it will appear. That's it! What a great timesaver!
=====================================================
2. Displaying Formulas
=====================================================
To easily review Excel formulas for troubleshooting, auditing,
or group analysis, temporarily display formulas in two different
ways: Tools > Options, choose View tab, check Formulas (under
Window Options) or press [Ctrl] + ~ (this character is the tilde
found above the [Tab] key). Repeat commands to change the
formula display again.
=====================================================
3. More than AutoSum
=====================================================
Most Excel users know about the AutoSum toolbar button on the
Standard toolbar. It looks like (take your pick) an Epsilon
character or a squashed letter E. AutoSum is a quick way to
create a Sum function for a range of values without typing the
function. Now, in Excel 2003 and 2002, the AutoSum button has a
bonus. Just click on the drop-down arrow to the right of the
button to see options for other functions including: Average,
Count, Min, Max.
=====================================================
4. Excel Macro Examples
=====================================================
Already comfortable recording and creating macros and looking
for some shortcuts? Here is a great source for solutions with
easy to understand examples:
http://www.contextures.com/excelfiles.html
I recently found a great example on this site that helped me
quickly filter a long list of data into separate worksheets for
each primary group.
=====================================================
5. Spreadsheet Jokes
=====================================================
Ready for an "interesting" sense of humor? Check out these
Excel jokes...if you dare. Website offered by John Walkenbach,
author of a number of great Excel books.
http://www.j-walk.com/ss/jokes/index.htm
=====================================================
Try these tips, tricks, and resources to become more productive
with Excel.
=====================================================
6. Do You Need Content?
=====================================================
Do you have a company website or newsletter? Would your
organization benefit by knowing effective ways to use their
software and technology?
You are welcome to download or reprint any of the articles on
The Software Pro (tm) website for your newsletters and website.
For terms and more information >>
http://www.softwarepro.com/articles.htm
------------------------------------------------------------
Please pass this along to others who may appreciate it!
------------------------------------------------------------
For the latest additions to The Software Pro (tm) website:
http://www.SoftwarePro.com/whatsnew.htm
Past newsletter issues are found at:
http://www.SoftwarePro.com/archives.htm
For Website or e-zine questions: mailto:Dawn@SoftwarePro.com
If you are receiving this issue as a forward, and want
your own subscription, visit
http://www.SoftwarePro.com/subscribe.htm
Privacy Policy - We hate receiving spam as much as
you do. Therefore, we never rent, trade, or sell
our email lists to anyone for any reason. You or
someone you know subscribed you to this e-zine list.
We never add names to our list until you voluntarily
subscribe.
(c) 2004 The Software Pro (tm)
All rights reserved.
http://www.SoftwarePro.com
To Subscribe go to:
http://www.SoftwarePro.com/subscribe.htm
============================================================
Geek Speak Becomes People Friendly (tm)
Dawn Bjork Buzbee
The Software Pro (tm)
(303) 699-6868, Fax (303) 766-0886
mailto:Dawn@SoftwarePro.com
http://www.SoftwarePro.com