Downloads
|
|
|
|
|
-- Remember to virus-scan all files you download from the internet --
|
|
|
Flagging Late Payments using Nested IF statements.
|
|
This spreadsheet contains the sample data and formula for using
nested IF statements to flag up late payments..
Click here to download the sample data.
Click here to go to the tip.
|
|
|
Sales Analysis using Pivot Tables
|
|
This spreadsheet contains the sample data and Pivot Table used in the
Spreadsheet Tip entitled Sales Analysis using Pivot Tables.
Click here to download the sample data.
Click here to go to the tip.
|
|
|
VAT Calculator
|
|
|
This spreadsheet contains two tabs. One for Adding VAT and
one for Removing VAT. The example used for Adding VAT, is to
show the difference in a trade price (business to business)
when the VAT rate changes from 15% to 17.5%. The example
used for Removing VAT is to see how the prices without VAT
change in a VAT rate change, when you want the same
final price. Click here to download the
VAT calculator.
|
|
|
Google Analytics Spreadsheet Tool
|
|
|
The spreadsheet is colour coded. Sheets which have green tabs
are where we paste in data from Google Analytics. The sheets
with blue tabs show the automatically produced charts displaying
the compiled information. The last five tabs in dark grey
contain some background information it is best to leave alone.
The tutorial below will take you through how to use each section.
(If you are using a version of Excel which does not support
coloured tabs, the first three tabs after the 'Welcome' page are
for data entry and are named 'visitor_data', 'keyword_data' and
'referrer_data').
|
|
There are a few macros contained within the spreadsheet which
support some of the automation. Within Excel, you can set
whether to enable or disable these macros. If the push buttons
on the data entry sheets are not working, the macro security level
is set to high. If you reset it to medium (Tools menu > Macro
> Security) and re-open the spreadsheet, you will then be given
the choice of whether to enable or disable the macros.
Click here
to download the Google Analytics Tool.
|
|
|
Mailing List Preparation
|
|
This spreadsheet contains the formula for removing full stops at the end of
email addresses, in the context of preparing an e-mailing list.
Click
here
to download the Mailing List Preparation Tool.
|
|
|
Emailing List Salutations
|
|
This spreadsheet contains the formula generating salutations whether
there is a first name or not. First names are used if possible,
otherwise the more formal salutation is used, e.g. Mr Smith.
Click here
to download the Emailing List Salutations Tool.
|
|
|
Timesheet
|
|
This spreadsheet contains a simple Excel timesheet which allows you
to calculate your weekly billings whether you use an hourly or daily
rate.
Click here
to download the Timesheet.
|
|
|
Discount Tool - Non-Cumulative
|
|
This spreadsheet contains an Excel discount tool which allows you to
quickly give your customer a price depending on their category.
Click here
to download the Discount Tool (Non-Cumulative).
|
|
|
Discount Tool - Cumulative
|
|
This spreadsheet contains an Excel discount tool which allows you to
quickly give your customer a price depending on their category. Discounts
are applied cumulatively across multiple bands of discount, e.g. Dealer and Distributor.
Click here
to download the Discount Tool (Cumulative).
|
