Shopping Cart
Your shopping cart is empty
All material is Copyrighted to Epiphany Training Limited unless otherwise stated. Material is for the buyers use only and not for general distribution, or use in training. If you require bulk copies or bespoke material call us on +44 (0)208 133 6248 or email on Contact@KatherineDavison.co.uk.
Crib sheets are in PDF format and are locked to be viewable on the computer you download to. WordPress templates are compressed in zip format and can be imported into WordPress sites hosted outside of WordPress.com
Microsoft Excel 2003
Conditional Formatting Crib Sheet
This extreemly useful tool will change the format of cells depending on a value, for example change the background colour of all cells that are negative values or all cells that are above the average amount.
More Details
Pages: 1
Format: PDF
All downloads are restricted to the computer they are downloaded to. If you require a hardcopy order on www.EpiphanyTraining.co.uk or if you require bulk copies email orders@EpiphanyTraining.co.uk
Creating Chart Crib Sheet
Creating charts/graphs using the Chart wizard and shortcut key.
More Details
Pages: 1
Format: PDF
All downloads are restricted to the computer they are downloaded to. If you require a hardcopy order on www.EpiphanyTraining.co.uk or if you require bulk copies email orders@EpiphanyTraining.co.uk
Creating Spreadsheets Crib Sheet
Creating and testings Lists that can use all of Microsoft Excels functionality, and quick formatting.
More Details
Pages: 1
Format: PDF
All downloads are restricted to the computer they are downloaded to. If you require a hardcopy order on www.EpiphanyTraining.co.uk or if you require bulk copies email orders@EpiphanyTraining.co.uk
Custom Format and Styles Crib Sheet
You can create custom formats for specialised cell formatting, ie have the day of the week included within the date, as well as saving these formats.
More Details
Custom format can change the colour of text as well as the format. Styles allow formats to be saved and applied to cells to add continuity to spreadsheets.
Pages: 1
Format: PDF
All downloads are restricted to the computer they are downloaded to. If you require a hardcopy order on www.EpiphanyTraining.co.uk or if you require bulk copies email orders@EpiphanyTraining.co.uk
Excel 2003 Calculation Fundamentals Cheat Sheet
Shows key items to note when creating calculations and using Functions. Has the difference between a calculation and function as well as showing several simple functions and their syntax. Includes: – Adding – Averaging (mean and mode) – Counting – Highest and Lowest Values, and – Standard Deviation
More Details
Pages: 1
Format: PDF
All downloads are restricted to the computer they are downloaded to. If you require a hardcopy order on www.EpiphanyTraining.co.uk or if you require bulk copies email orders@EpiphanyTraining.co.uk
Excel 2003 Pivot Table Basics Cheat Sheet
Analyse large lists, grouping values together and calculating data. This tool is one that most people find useful.
More Details
Pages: 2
Format: PDF
All downloads are restricted to the computer they are downloaded to. If you require a hardcopy order on www.EpiphanyTraining.co.uk or if you require bulk copies email orders@EpiphanyTraining.co.uk
Excel 2003 Scenarios Cheat Sheet
Is forecasting difficult? This tool allows you to save several values for one cell then change which value is showing which can update the entire spreadsheet.
More Details
Pages: 1
Format: PDF
All downloads are restricted to the computer they are downloaded to. If you require a hardcopy order on www.EpiphanyTraining.co.uk or if you require bulk copies email orders@EpiphanyTraining.co.uk
Financial Functions Crib Sheet
This Crib Sheet shows how to create several financial function and examples for each, including Payament Function, Number of Payments and Present Value.
More Details
Pages: 1
Format: PDF
All downloads are restricted to the computer they are downloaded to. If you require a hardcopy order on www.EpiphanyTraining.co.uk or if you require bulk copies email orders@EpiphanyTraining.co.uk
How to add working days to a date
You have a date and you need to add 10 days, but it must be 10 working days and not include weekends or holidays. Learn how to do this.
Logical Functions Crib Sheet
Creating calculation that calculates one way if a statement evaluate as True and another way if the statement evaluates as False. Shows the parts of an IF Statement, nesting several IF Statements into one calculation. Using AND, OR, and ISERROR Functions.
More Details
Basic IF statement, nesting IF Statements and using other nested logical functions.
Pages: 1
Format: PDF
All downloads are restricted to the computer they are downloaded to. If you require a hardcopy order on www.EpiphanyTraining.co.uk or if you require bulk copies email orders@EpiphanyTraining.co.uk
Lookup Functions Crib Sheet
This quick reference card shows the syntax for 3 Lookup Functions, their arguments and examples of how they are used.
More Details
Pages: 1
Format: PDF
All downloads are restricted to the computer they are downloaded to. If you require a hardcopy order on www.EpiphanyTraining.co.uk or if you require bulk copies email orders@EpiphanyTraining.co.uk
Validation Crib Sheet
Restrict what type of data that can be entered into cells, circle data that does not conform to validation rules. Create error messages when data is not entered correctly.
More Details
Pages: 1
Format: PDF
All downloads are restricted to the computer they are downloaded to. If you require a hardcopy order on www.EpiphanyTraining.co.uk or if you require bulk copies email orders@EpiphanyTraining.co.uk