Of course, there's also 1e9, 1e7, 1e3...
*** ANY TAX ADVICE IN THIS COMMUNICATION IS NOT INTENDED
OR WRITTEN BY KPMG TO BE USED, AND CANNOT BE USED, BY A
CLIENT OR ANY OTHER PERSON OR ENTITY FOR THE PURPOSE OF (i)
AVOIDING PENALTIES THAT MAY BE IMPOSED ON ANY TAXPAYER OR
(ii) PROMOTING, MARKETING OR RECOMMENDING TO ANOTHER PARTY
ANY MATTERS ADDRESSED HEREIN. ***
Any advice in this communication is limited to the
conclusions specifically set forth herein and is based on
the completeness and accuracy of the stated facts,
assumptions and/or representations included. In rendering
our advice, we may consider tax authorities that are subject
to change, retroactively and/or prospectively, and any such
changes could affect the validity of our advice. We will not
update our advice for subsequent changes or modifications to
the law and regulations, or to the judicial and
administrative interpretations thereof.
The advice or other information in this document was
prepared for the sole benefit of KPMG's client and may not
be relied upon by any other person or organization. KPMG
accepts no responsibility or liability in respect of this
document to any person or organization other than KPMG's
client.
-----Original Message-----
From: MS Excel General Q & A List [mailto:EXCEL-G PEACH.EASE.LSOFT.COM]
On Behalf Of Strong, Pauline N.
Sent: Thursday, August 31, 2006 1:19 PM
To: EXCEL-GPEACH.EASE.LSOFT.COM
Subject: Favourite Tips
A couple that I had to work to train myself to use and am
really glad I
did
are shift-space bar to select a row and control-space bar to
select a
column. Then after using either of these there are control
plus and
control
minus to insert or delete a row or column. Also, using F4 to
repeat the
last
formatting action can save a lot of time, but it's a little
hard to
determine which actions this will repeat and which it
won't, so you do
have
to be careful with it. All the control-shift-numbers for
formatting
could be
useful. I am constantly using control-shift-1 to format
cells as number
with
commas and 2 decimal places, and I wish there was a shortcut
for the
same
format with no decimal places. Control-shift-$ for the
currency format
is
another one that I use often. Using a custom format with a
comma after
the
format to format numbers in thousands comes in handy. A lot
of people
new to
Excel don't know that you can autofit rows or columns by
double-clicking
on
the bottom or right border of the row or column.
Thanks for the 1e6 tip, Bob. That is REALLY cool!
- Pauline
[mailto:EXCEL-GPEACH.EASE.LSOFT.COM]On Behalf Of Bob
Phillips
Sent: Thursday, August 31, 2006 11:23 AM
I am compiling a list of some of the more useful, mostly
under-used,
tips
and tricks in Excel. I am not talking about some of the more
obscure
stuff
in Bob's book, but the stuff that we may take for granted,
but are
amazed
when other people don't know, that make us smile when they
see how
useful
they are.
As a couple of examples of the things I mean:
- the F9 key to evaluate a formula, or part of a formula, in
the
function
bar
- double-clicking the icon painter to allow dis-contiguous
formatting of
cells
- the black cross autofill feature.
There are other such tips, ones that you use frequently and
you find to
be
big labour savers, or just so useful. Best of all if they
ease
Excelfunctionality, such as charting, pivot tables.
For information, I am building it to throw into training
courses, not
specifically a tips session, but sprinkled throughout. I am
hoping to
find
which ones are really found useful, and also to learn some
that I don't
know/use now.
Thanks
Bob
------------------------------------------------------------
------------
--
The EXCEL-G list is hosted on a Windows NT(TM) machine
running L-Soft
international's LISTSERV(R) software. For
subscription/signoff info
and archives, see htt
p://peach.ease.lsoft.com/archives/excel-g.html .
COPYRIGHT INFO:
http://peach.ease.lsoft.com/scripts/wa
.exe?SHOWTPL=COPYRIGHT&L=EXCEL-G
************************************************************
*****************
The information in this email is confidential and may be
legally privileged. It is intended solely for the
addressee. Access to this email by anyone else is
unauthorized.
If you are not the intended recipient, any disclosure,
copying, distribution or any action taken or omitted to be
taken in reliance on it, is prohibited and may be unlawful.
When addressed to our clients any opinions or advice
contained in this email are subject to the terms and
conditions expressed in the governing KPMG client engagement
letter.
************************************************************
*****************
------------------------------------------------------------
--------------
The EXCEL-G list is hosted on a Windows NT(TM) machine
running L-Soft
international's LISTSERV(R) software. For
subscription/signoff info
and archives, see htt
p://peach.ease.lsoft.com/archives/excel-g.html .
COPYRIGHT INFO:
http://peach.ease.lsoft.com/scripts/wa
.exe?SHOWTPL=COPYRIGHT&L=EXCEL-G
|