|
September, 2008 |
Meet the client - Richard Fitzpatrick, Independent Mortgage Adviser.
|
Using CountIF to extract key information from your sales list.
|
|
August, 2008 |
Google Analytics Website Statistics, Part 3 of 3.
Looking at Keywords and how people are finding or not
finding your website.
|
|
July, 2008 |
Google Analytics Website Statistics, Part 2 of 3.
Understanding which referring sites are bringing you
the right kind of business.
|
|
June, 2008 |
Google Analytics Website Statistics, Part 1 of 3. How to
compile, analyse and present simple statistics for your website.
Incorporates a free, downloadable spreadsheet tool.
|
|
May, 2008 |
Meet the client - High Score Productions Ltd.
|
Preparing data for a mailshot using the Concatenate Function to
tidy titles and names |
|
April, 2008 |
Focus on Service -
SRS
Spreadsheet Rescue Service. |
The Vlookup function. Cross-referencing data between different files. |
|
March, 2008
|
Meet the client - Puddleduck Parts Ltd.
|
The AND function. Target prospective clients for quick, effective marketing.
|
|
February, 2008
|
Meet the client - Phil Keane, IFA.
|
Compile information from lists and ledgers with the SUMIF function
|
|
January, 2008
|
Meet the client - Pink Connect
|
Ask questions of your data with the IF function.
|
|
December, 2007
|
Meet the client - Starlight Enterprise
|
How to cross-reference data and tables using the Vlookup function
|
|
November, 2007
|
Meet the client - Phil Smithers
|
How and when to use Pivot Tables - an introduction
|
|
October, 2007
|
Meet the client - Headway Music Audio Ltd
|
How to automate data entry using text functions
|
