Monthly Newsletter
Our newsletter is produced on a monthly basis for our subscribers. It's
objective is to provide an invaluable source of information and advice
on office automation through the use of Microsoft® Office software.
We hope you find the newsletter informative and useful. Please tell us
what you think via
Contact Us.
For our current
newsletter please click on the link below.
Excel To Do List Template
Excel Template
that will help you keep track of all those personal and business things
that need to get done. The "To Do List" template provides a method to
organise, prioritise and track the activities that are important in our
lives.
For past newsletters
access via the following links
Timesheets using Excel Templates
Keeping
track of time and effort for a business is a key aspect in determining
profitability. A system and process to record and report on employees
time is critical to that measurement. Excel provides some basic time
recording templates
Excel Templates can be great time savers !!
Did
you know that Microsoft Excel provides FREE Excel templates
pre-installed and available for your use. In this month's newsletter we
will demonstrate how useful these standard templates can be.
I
didn't know Excel could do that !!
In this months newsletter we describe some little known features of
Excel that could help you in developing more efficient and effective
spreadsheets...
July, 2009Free Mortgage Calculator
The
Mortgage Calculator will enable you to quickly determine the payments
and interest required on a mortgage or loan. You can specify standard
loan variables like loan amount and interest rate, as well as things
like one-off payments or increased payments. June, 2009Tracking and Billing Time
Does
your business perform work for clients or customers ? Do you keep an
accurate record of the time spent by your staff as they work for those
clients and customers ? Do you know which clients and projects are the
most profitable for your business ? May, 2009Create your own Macro's (Part 3)
This month we develop a
Macro that will extend that basic Data Sort functionality that is
provided by Excel 2003. Create your own Macro's (Part 2)
This
month we develop a Macro that will split a list of Names into two (2)
columns one for the First Name and one for the Last Name. This type of
Macro can be very useful when trying to create Mailing lists from
source data that is not in the right format.
March, 2009Create your own Macro's
Macro's
are a powerful tool within Excel that can allow you to perform complex
tasks with the click of button. A Macro is simply a series of commands
recorded into a script that is executed when required.
Discover "Named Ranges"
Named
Ranges are a powerful tool within Excel that allow you to specify
meaningful names for a cell or a range of cells within your Worksheet.
Extend Excel's Default Sort
For
many users of Excel the restricted default sort option can often not
provide the flexibility that is needed when performing complicated data
analysis tasks.
December, 2008What is a Pivot Table/Chart ?
Microsoft
Excel and Access offer a powerful data analysis tool that enables
interactive reporting on large amounts of data. The Pivot Table/Chart
tool is typically used to analyse transactional information allowing
the user to view the data in many different ways.
November, 2008You own Microsoft® Office - Why not use it ?
It's
amazing how many organisations have invested money in office software
such as Excel, Word, Powerpoint and Outlook, but are not using it
effectively. So much more can be achieved to further automate and
enhance your business using the software you already have ....... If
you know how!
