|
SUMIF
|
Compile and extract information based on your criteria
|
Calculating your inventory value.
|
|
CountIF
|
Extract Totals depending on your criteria
|
How to extract information from your sales list which may
help you get a discount from your supplier.
|
|
Web Stats #1 of 3
|
Analysing and Presenting Web Stats
|
Pasting your website statistics into Working Data's
free downloadable
spreadsheet tool
|
|
Web
Stats #2 of 3
|
Analysing and Presenting Web Stats, Referring sites
|
Using the Working Data free
downloadable spreadsheet tool to examine how
your referring sites are performing.
|
|
Web
Stats #3 of 3
|
Analysing and Presenting Web Stats, Keywords.
|
Using the Working Data free
downloadable spreadsheet tool to examine how
your referring sites are performing.
|
|
Concatenate & Trim
|
Manipulate and Tidy Entries.
|
Preparing data for a mailshot.
|
|
Vlookup
|
Cross-References data.
|
Pulling data together from different files for a
presentation
|
|
AND
|
Search data by multiple criteria.
|
Target your prospects.
|
|
SUMIF
|
Compiles data depending on your criteria.
|
Compiling sales data for a presentation.
|
|
IF
|
Interrogates data.
|
Interrogating sales figures.
|
|
VLookup
|
Cross-References data.
|
Pulling data together from different sources.
|
|
PivotTable
|
Compiles and Analyses data.
|
Compiling year-end sales figures.
|
|
Concatenate, Find, Length & Mid
|
Manipulate and Tidy entries.
|
Automate data entry and save time.
|