100
Office Tips - 97 to 2007
Recently
updated to cover all versions of Office from Office 97 to Office 2007
For
accountants and other professionals
£100
Office Tips - PDF version - 100 ways to save time with Microsoft
Office brings together some of the best ideas for making your use of Microsoft
Office more effective. We have used our years of experience of working with
accountants and other professionals to compile this 140 page plus document. Some
of the tips are very simple, others more involved, but we have chosen all of
them to provide real, practical benefits and save you hours of time. After all,
how many hours do we need to save you for you to recover the £30 cost?
The PDF includes a series of
animations to help show how many of the hints and tips work.
With
£100 guarantee
If,
having read through the tips in the book, you really don’t believe they will
save you or your colleagues at least £100 worth of
chargeable time in the coming year, then let us know by email within 3 months of
the date of your order and we will be happy to send you a voucher for £100
towards any combination of our eservices or eproducts.
Just a few of the things you’ll discover in £100 Office Tips:
Excel:
- How
to use ‘paste special’ to preserve comparative figures, turn pluses to
minuses and swap columns for rows, and how to do some of these things much
more quickly
- Secrets
of the fill handle – how to generate month end and year end dates, and the
double click that makes hardened professionals grin uncontrollably
- The
function that lets you change the formulae in every cell
- Keyboard
shortcuts to move and select
- How
to avoid rounding errors and balance profit shares automatically
- How
to round to thousands and display £'000
- How
Excel custom number formats work and how to deal with brackets
- How
to create a graph using stacks of pictures
Word:
- The quickest way to select
different blocks of text – including avoiding the 'runaway selection'
problem
- Dozens of keyboard shortcuts to
speed up your use of Word
- 5 key table techniques to
perfect the presentation of schedules of figures and automate the entire
process
- How global templates can help
you share AutoText and custom toolbars
- How to combine landscape and
portrait pages in a single document
- How to create a single page
template that copes with letterhead and continuation sheets
- How conquering styles can save
you wasting hours
- How to enter custom fractions
- How to link to an individual
Excel cell and preserve the formatting
Outlook:
- How Outlook can work out when
'next Wednesday' is for you
- The dangers of 'To' and 'Cc'
- How to conquer email –
organise your messages automatically
- How to take control of your
Outlook screen displays to show exactly what you want, how you want it
- How to use Outlook contacts to
create a Word or email mail merge
- How to insert an Outlook
contact address into a Word document with a couple of clicks
- How to add shortcuts to Outlook
to access favourite folders
- How to set up a public folder
and make it available for offline use
- How to work with other users'
folders
Access:
- Why referential integrity keeps
your data safe and how best to enforce it
- How to use 'Filter by Form' and
'Filter by Selection' to quickly find the information you need
- How to link tables of data to
get the results you need
- How to use field expressions to
automate your calculations
- How 'cross tab' queries can
display your data as a compact table
- A special type of query that
can sort your debits from your credits
- How to create and work with
forms efficiently
- How to work with running totals
- How to minimise the number of
reports you have to create
PowerPoint:
- How to animate multiple
pictures in one go
- The importance of slide masters
and how to work with them
- How to include slides from
other presentations
- How to introduce bits of your
PowerPoint charts one element at a time
- How to start from the middle of
your presentation
- How to click to go forwards and
right-click to go backwards
Windows:
- How to add locations to the
'send to' list
- How to link content between
applications
- How to manage the task bar to
give you instant access
- Make your screen bigger by
putting the taskbar where you want it
- How to use the Startup folder
to automate program activation
- How to use a value from the
Windows calculator