• VLOOKUP and XLOOKUP 
• PivotTables and data analysis 
• Conditional formatting
• Useful shortcuts  
• Macros

2CV (Wilton), Abel & Cole (Andover), Absolute Partnership (Tunbridge Wells), Adkin (Wantage), ADP Dealer Services (Hungerford), ADP Dealer Services (Hungerford), Advanced Vehicle Alarms (Dartford), Aegon UK (Witham), AESTIMA (Wickford), Ageas UK Ltd (Eastleigh), Agena Group , Aggregate Industries (Merstham), Airflow (Cressex Business Park), ALDI Stores Ltd (Chelmsford), Alexander Fraser Group (Brentwood), Alliance Pharma plc and Alliance Pharmaceuticals Ltd (Chippenham), Alpha Laboratories Ltd (Eastleigh SO50 4NU), ALPI UK LIMITED (Basildon), Altadicta Design + Communication Ltd (Surbiton), AMARA Living Limited (Braintree), AMICULUM Ltd (Richmond), Ancaster Group Ltd (Thornton Heath), Anders Kloster (Old Windsor), Antler Homes Plc (Bagshot), Applied Kilovolts Ltd (Goring-by-Sea), APT (Amersham), Aqualisa Products Ltd (Westerham), Aquatrols Europe Ltd (Ashford), Arthur J. Gallagher Holdings (UK) Limited (Bournemouth), Ash Grange Children's Centre and School (Ash), Ashgate Publishing (Farnham), Aspin Group Ltd (Hemel Hempstead), Aster Group Ltd (Devizes), ATC Lasham Ltd (Lasham), ATC Lasham Ltd - Southend (Southend-on-Sea), Atlas Genetics Ltd , Aurient Management Ltd (Watford), Austin Contract Services Ltd (Bobbing Sittingbourne), Avios Group (AGL) Ltd (Crawley), AVK-SEG (UK) Ltd (Maidenhead), Barhale (Bescot Crescent Walsall), Barry Callebaut , Basildon & Thurrock University Hospital (Basildon), BCASEL Boeing Commercial Aviation Services Europe Ltd (Camberley), Beard (Swindon), Bel UK (Sevenoaks), Bell Plastics Ltd (Poole), Berkshire Healthcare NHS Foundation Trust (Theale), Bexley College (Belvedere), Biotecture Ltd (Bosham), Birchwood Price Tools (Nottingham), Blaze Maintenance Limited (Hildenborough), Blithfield , Bluestar Silicones (UK) Ltd (Bordon), BNP Paribas Commercial Finance (Tunbridge Wells), Bowles Rocks (Tunbridge Wells), Brands UnLimited (Hurst), Bridgethorne Ltd (Bracknell), British Bakels Ltd (Bicester), British Power International (Colchester), Broadplace (Leatherhead), Bromley Mind (Orpington), Brotham Forecourt Developments Ltd , Bruce Shaw LLP (London), Calthorpe Park School (Fleet), Cameron (Leeds), Candover Contracts Ltd (Stevenage), Cantel (UK) Limited (Shoeburyness), Canterbury City Council (Canterbury), Capstone Foster Care (Dartford), Carallon Limited (Chiswick), CAWSTON PRESS (London), CBS Business Furniture Ltd (Ascot Berkshire), Cellular Solutions and Services Ltd (Hove), Charlton Brewing Leadership Ltd (Bledlow), Cisilion (Leatherhead), Citrix Systems UK (Gerrards Cross), Clipper UK Ltd (Basildon), CloudXL (Stockenchurch), Cloverpoint Ltd (Berks), Cluttons LLP (London), Codilink UK Ltd (London), COH Baines Ltd (Tunbridge Wells Kent), Colart Fine Art & Graphics (London), Collins and Hayes Furniture Ltd (East Sussex), Compagnie Fruitiere UK Ltd (Dartford Kent), COMXO Ltd (Datchet Windsor), Connect Plus Services (London), Conneely Drylining Ltd (Stansted Essex), Constable & Robinson Ltd (London), Content Consultants (Brighton), CoolLED Limited (Andover), Cooperhomewood (Whiteley Fareham), Coral Racing Ltd (London), Cornelius Group plc (Bishops Stortford), Cosmur Construction (London) Ltd (London), Cranstoun (Portsmouth), Crawley Borough Council (Crawley), CROS NT LIMITED (UK), CROWN Technology (Wantage), Crowne Plaza London Docklands (London), CSL Behring Biotherapies for Life (Haywards Heath), Cubic Defence UK Ltd (Wrecclesham Surrey), Cubic Transport Systems Limited (Stockton on Tees), Datum Datacentres Limited (Farnborough), De Beers UK Ltd (Maidenhead Berkshire), Dean & Reddyhoff Ltd (Portland Dorset), Deep C (Guildford), Denne Joinery (Canterbury Kent), Dental Sky Wholesaler Ltd (Ashford Business Park Ashford Kent), Designplan Lighting (Sutton), DG Fruit UK Ltd (Whyteleafe Surrey), Digitalis Reputation (London), DKB Household UK Ltd (Farnborough Hampshire), DM Habens Ltd (Southsea Portsmouth Hants), Dobell (Eastbourne), Dorset HealthCare University NHS (Boscombe Bournemouth), Drakes Plumbing Services Ltd (Tunbridge Wells), Dreams PLC (Loudwater Buckinghamshire), Driscoll's Genetics Ltd (East Malling), DS Logistics Hersden Ltd (Lakes view Business Park Hersden), Duchy of Cornwall (London), East Sussex Fire & Rescue Service (Uckfield East Sussex), EBSCO (New Barnet EN5 1NZ), ECA, Excellence in Electrotechnical and Engineering Services (Sevenoaks Kent), ECMWF (Reading), Efret Limited (Christchurch), Elite Incident Management (Brighton), England and Wales Cricket Board (London), English Rural (London), EnQuest Britain Ltd (London), EPOCH making toys Ltd (Uxbridge MIDDX), Essex University (Colchester), ETI Ltd (Worthing), Euler Hermes (Canary Wharf), Europlacer Ltd (Poole), EUSA Pharma (Hemel Hempstead), Externiture Ltd (Thatcham), Family Building Society (Epsom Surrey), Fashion Retail Academy (London), Feedwater (Oxford), Fermod Limited (Iver Buckinghamshire), FireFly Resources , First Central (Haywards Heath West Sussex.), Fitch 7 City Learning (London), Fitness Marketing Agency (Haywards Heath), Fittleworth Medical Ltd (Littlehampton West Sussex), FLEET LUXURY PACKAGING (Rochester Kent), Forest Laboratories UK Ltd (Dartford), Freeman Clarke Ltd (Oxford), Fresh Egg Ltd (Worthing), Furuno (UK) Ltd (Havant Hampshire), Gallagher (Chichester West Sussex), Gearhouse Broadcast Ltd (Watford Herts), Gemini Data Loggers (UK) Ltd (Chichester West Sussex), Genco Construction Services (Maidstone Kent), Genomics PLC (Oxford OX1 1JD), GetFeedback (Henley-on-Thames), Gist Limited (Chineham Business Park Basingstoke), GN Resound Ltd (Oxon), Goldstar Metal Traders Ltd (March), Goodwood Road Racing Company Limited (Chichester), GPX Engineering Ltd (Beresford Avenue Wembley), Green Street Advisors (London), Greenfields Community Housing Ltd (Braintree Essex), Ground Control Ltd (Billericay Essex), GSK , Gunnebo Entrance Control Ltd (Ashdown Business Park Maresfield), HaesCooper (Cranbrook.), Hallite Seals International Ltd (Middlesex), Harbour Render Systems (Cheltenham), Harlands Services Ltd (Haywards Heath), Hass Group International (Crawley), Havant Borough Council (Civic Centre Road), HDA Associates Ltd (Christchurch), Health Education England (Wakefield), Health Management Ltd (Ringmer East Sussex), Healthwatch Essex (Feering), Helen and Douglas House (Oxford), Help for Heroes (Wiltshire), Helvar Ltd (Dartford), Henry Schein UK Holdings Ltd (Gillingham), Heylo Housing (London), Highcross Strategic Advisers Limited (Oxford Street Newbury), Hilton Worldwide Ltd (Watford Hertfordshire), HITEK Power Ltd (Littlehampton), HMD Sealless Pumps Ltd (Eastbourne), Hoburne (Christchurch Dorset), Honda Motor Europe Logistics NV (Swindon Wiltshire), Honda Motor Europe Ltd (Bracknell), Howard Tenens (Sunbury Surrey), HSBC Bank plc (London), Hughes & Associates Property Services Ltd (Grays Essex), Hunt & Palmer PLC (Crawley West Sussex), Ignite Energy Ltd (Oxfordshire.), iHasco (Bracknell), Incentive FM Ltd (London United Kingdom), Infineum UK Ltd (Abingdon Oxfordshire), Infrastructure Training Services Ltd (Stonebridge London), Inside Out Group (Bicester), Insurance Dialogue Limited (London), Integra NeuroSciences Limited (Andover), J P Kenny Ltd (Staines Middlesex), Jacobs Douwe Egberts OPS GB Ltd (Banbury), Janssen-Cilag Ltd (High Wycombe), JDP Building Services Engineering Consultants (Reading), Jee Ltd (Tonbridge Kent), Jerakano Limited (Woking), Johnson Controls (Aldershot), Johnsons Textiles Service Limited (Preston Brook), Just Flights Ltd (Hove), JW Froehlich UK Ltd (Laindon Essex), KAHRS (Havant), KDC Projects Ltd (Bournemouth), Kernow Coatings Ltd (Cornwall.), Kerry Ingredients (UK) Ltd (Abingdon Oxfordshire), Kevin Nash Group Plc (Burnham on Crouch), KGAL (Bourne Valley Road), Kimanda Property Services Limited (London), Kingston Landscape Group (Twickenham Middlesex), Kirkstone Learning Ltd (Poole Dorset), KLT Construction Limited (Hemel Hempstead), Kovara Projects (Wokingham Berkshire), Kronos Systems Ltd (Bracknell), Kudos Interiors (Worplesdon Surrey), KYOCERA AVX Components Ltd (Fromley Surrey), Laboratory Impex Systems Ltd (Poole), LanguageUK (Broadstairs Essex), Latika Yang (Banbury), Launch Diagnostics (Longfield Kent), Laurelle London Ltd , Le Creuset UK Ltd (Andover), Leadership and Management Ltd (t/a Opera) (London), LED Lamps & Electrical Direct (Hornchurch), Lefort UK Limited (Bracknell Berkshire), Lester Aldridge (Bournemouth), Levendi Ltd (Rochester Kent), Lift West Ltd (Somerset.), Limpsfield Grange School (Oxted Surrey), Littlewood Fencing Ltd (Battle East Sussex), Livekindly UK (Mixbury), LMB Loft Conversions Ltd (Croydon London), Logitech UK Ltd (Windsor), London Academy of Excellence (Stratford), Lowe and Oliver Ltd (Wootton Boars Hill Oxford), Lucy Maxwell Scott , MacConvilles Surveying (Hove), MACROART (St Neots), Mademoiselle Desserts Taunton Ltd (Taunton), Maguire Europe Sales Ltd (Tamworth Staffs), Mainspring Marketing LLP , Marlborough Communications Limited (Redhill), Marlborough Communications LTD (Redhill Surrey), Martin Mathew & Co Ltd (Hertford), Mary Gober International Ltd (Yateley Hampshire), MC2 Therapeutics Limited (Guildford), Medical Marketing Research Group (West Byfleet), Meech International (Witney Oxon), Menzies Distribution (London), Merlin Entertainments PLC (Poole Dorset), Metcalfe's skinny Ltd (London), Minton Young Ltd (Hove), MJ Ferguson Ltd (Billericay Essex), Monthind Clean LLP (Copford Colchester), Moose Toys (Cornwall), Motor Data Solutions (Haywards Heath), Mumford & Wood Limited (Tiptree Essex), Myles Semmens (Cosham Portsmouth), Nasmyth Technologies Ltd (Wimborne Dorset.), National Federation of Demolition Contractors Ltd (Hemel Hempstead), NaturalMotion Ltd (London.), Nautilus Yachting Ltd (Edenbridge Kent), Neal's Yard Remedies (Peacemarsh Gillingham Dorset.), NFU Mutual (Milford Surrey.), NHS South CSU (Phoenix House), NHS Trust Development Authority (Wakefield), NIIT (London), Nord Anglia Education Ltd (Oxford), Norwood (Crowthorne Berkshire), OCS Group UK Ltd (Manchester), OHES Environmental Ltd (Wokingham Berkshire), Olympus Technologies (Huddersfield), OMRON Healthcare Europe B.V (The Netherlands), On‑Line Partnership Group Limited (Horsham West Sussex), Oodle Car Finance, (Oxford Science Park Oxford), OPEN MIND Technologies UK Ltd (Bicester Oxfordshire), Osbourne Purdie Limited (Maidenhead Berkshire), Oventrop UK Ltd (Basingstoke), Oxford Capital (Oxford), Oxford Nanopore Technologies Ltd (Oxford Science Park Oxford), Oxfordshire Customer Services (Oxford), Oxsensis Ltd (Didcot), P.J. Carey (Contractors) LTD (Wembley Middlesex), Pareto Shipbrokers Ltd (Guildford Surrey.), PDT (Ware.), Perrin Myddelton (Harpenden Herts), Persimmon Homes Limited (Great Blakenham), Peter Fisk Associates (Whitstable), Petersfield Housing Association (Petersfield), Petrofac Facilities Mgmt Ltd (Aberdeen), Pharm@sea (Brighton), Pickering Interfaces Limited (Clacton-on-Sea), PJL Healthcare Ltd (Framfield East Sussex), Plan Limited (Woking Surrey), Platt’s Limited (Cheshire.), Polypipe Building Services (Aylesford), Portsmouth Naval Base Property Trust (Portsmouth), Posturite Ltd (Berwick), Potential Squared (Berkhamsted Hertfordshire), Precision Engineering Pieces Ltd (Tewkesbury), Premia UK Services Company Ltd (London), Premier Aviation (UK) Ltd (Crawley West Sussex), Prince Alice Hospice (Esher Surrey), Princeps Electronics Limited (Harlow Essex.), Principal (Horsham), Probation Service Yorkshire and the Humber Region (Hull), Project Centre, part of Marston Holdings (London), Prop Store Ltd (Chenies Rickmansworth), Proptech Aero Ltd (Lee on the Solent), Provincial Grand Lodge of Essex (Wickford Essex), PRS For Music (London), Pulse Structural Monitoring Ltd (Woking), QFI Consulting (Aldbury), Qualitas (Horsham), R. H. Amar & Co. Ltd (High Wycombe Bucks), R. T. Williams Insurance Brokers Ltd (Hove), Rapp Ltd (East Grinstead), RDT (Basingstoke), Remote Visual Inspections Ltd (Shoreham Airport West Sussex), Respironics UK, Philips Home Healthcare Solutions (Tangmere West Sussex), Retter Medical Services Ltd (East Leake Loughborough), Reverie Limited (Colchester), Rigby Taylor Ltd (Royston Herts), River Packaging Ltd (Sunbury on Thames), Riverside School , Roc Technologies (Newbury Berks), Rockhopper Exploration PLC (Salisbury), Roofing Contractors (Cambridge) Ltd (Milton Cambridge), Ros King (London), Royal Merchant Navy Education Foundation (Hungerford Berkshire), Royston Fox Associates (Mayfair London), Rustler Yachts Limited , S&B Herba Foods Limited (Orpington Kent), Scientific Management International Ltd (Andover Hampshire), Scofell Landscapes Ltd (Thatcham Berkshire), Sebia (UK) Ltd (CAMBERLEY Surrey), SEEVIC College (Benfleet SS7 1TW), Sensus UK (Basingstoke), Servicecare (Oldham Greater Manchester), Shepherd Neame Ltd (Faversham), SICO Europe Limited (Lympne Kent), Sidel Group - Sidel UK Ltd (Hatfield), Silixa Ltd (Elstree), Simon Lane (Kingston Upon Thames.), Site Sales (Loughton Essex), SLE Ltd (South Croydon Surrey), Smurfit Kappa (Norfolk), SNAAP (Herne Bay Kent.), Solent NHS Trust Headquarters (Southampton), Solent Pizza Delivery Ltd & Solent Pizza W Ltd (Tollbar Way), South East Coast Strategic Clinical Networks, NHS England (NHS England Phoenix House), South Western FPO Ltd (Ivybridge Devon), Southampton City Council , Southend-on-Sea Borough Council (Southend-on-Sea), Southern Communications (Hampshire), Sowga (Pulborough), Spellman High Voltage Electronics Ltd (Pulborough West Sussex), Spirent Communications plc (Crawley West Sussex), SsangYong Motor UK Ltd (Swindon Wiltshire), SSBV-SGS UK Ltd (Portmouth Hampshire), St Paul's Church of England Primary School (Addlestone), St Ronan's School (Hawkhurst), St. James's Place Wealth Management (Cirencester), Stainless Metalcraft (Chatteris) Ltd (Cambs), STH Group (Richmond), Swan Housing Association (Billericay Essex), Systech Instruments Ltd (Thame Oxfordshire), TAG Catering Equipment UK (Stevenage), Talent Career Development Team – People Directorate , Tamdown Group Ltd (Braintree), TasteConnection Limited (Alderley Gloucestershire), Tate & Lyle PLC (London), Taylor Made Golf Ltd (Basingstoke), TeamClipper (Northampton), Teledyne Ltd T/A Teledyne Cormon (Worthing), Tenon Engineering Ltd (Dorking Surrey), TFI Group , Thames Valley Police (Langford Lane), The Albatross Travel Group (Aylesford Kent), The Christie School of Oncology (Manchester), The Colleges' Partnership Ltd (Blandford Dorset), The Delta Group (London), The Ecology Practice (Herefordshire), The Excel Communications Group (Marlow Buckinghamshire), The Goodwood Estate Company Limited Group (Chichester West Sussex), The Kirkhouse Trust SCIO (Blenheim Office Park Long Hanborough Oxfordshire.), The Livemore Partnership LLP (Leigh on Sea Essex), The Oxford Group (Stanton Harcourt Road Eynsham), The Perfume Shop (Coronation Road Cressex Business Park), The Project Centre (London), The Ripple Pond (Louise Margaret Road Aldershot Hampshire), The Scotts Miracle-Gro Company (Catteshall Lane Godalming), The Share Centre Ltd (Aylesbury Buckinghamshire), The Ship's Photographer Ltd (St Helier Jersey), The Sunlight Service Group Ltd (London), The Training Room (Waterloo Rd Poole), The Wharf Nursery School and Children's Centre (Godalming), Theresa Sabin (Marlow Bucks), Thomas Sanderson (Waterlooville Hampshire), TitheGrove Ltd (Marshgate Swindon), TJX UK (Watford), TN UNITED KINGDOM, LTD. (West Sussex), Toolbank, Dormole Ltd (Crossways Business Park Dartford), Toshiba Electronics Europe GMBH (Dusseldorf Germany), Towergate Insurance (Sittingbourne Rd Maidstone), Towers Watson (Reigate), Travel Insurance Facilities (Kent), Trinity Construction Services Ltd (Blackmore Ingatestone), TTI Group (Letchworth), UKN Group Limited (Basingstoke Hampshire), United Airlines (Heathrow Airport), United Bible Societies (Swindon), University Hospital Southampton NHS Foundation Trust , Valeo Foods UK (WALLINGFORD Oxon), VansonBourne (Newbury Berkshire), Vector Aerospace International Ltd - UK (Fareham Rd Gosport), VELFAC LTD (Cambridge), Veolia (Four Ashes Wolverhampton), Vilicom (Dublin 12 Ireland), Vishay Measurements Group UK Ltd (Basingstoke Hampshire), Vogt Solar Ltd (Denton Island Newhaven), W.T Butler & Co Ltd , Wakefield and District Housing Limited (Castleford), Waldon Telecom Ltd (West Byfleet Surrey), Watts Farm (Dartford Kent), Wave (Old Amersham Buckinghamshire), Welcombe Communications Ltd (Market Harborough Leicestershire), Wellcombe Group Ltd (Hove East Sussex), West Somerset Community College , Wheelabrator Group (Altrincham), William Alexander Recruitment Ltd (Hove East Sussex), William Alexander Recruitment Ltd (Hove East Sussex), Windles (Long Crendon Buckinghamshire), Wokingham Borough Council (10 Targett Court Winnersh), WRG Ltd (Marlow Buckinghamshire), WTL Holdings (Billingshurst), Xylem Water Services Ltd (Hoddesdon Hertfordshire), Zenith Bank (UK) Limited (London), Zoetis UK Limited.

We provide Excel training across West Sussex including the following locations: Arundel, Billingshurst, Bognor Regis, Burgess Hill, Chichester, Crawley, East Grinstead, Gatwick, Haywards Heath, Horsham, Lancing, Littlehampton, Midhurst, Petworth, Pulborough, Shoreham-by-Sea, Worthing.

We provide Excel training across East Sussex including the following locations: Battle, Bexhill-on-Sea, Brighton, Crowborough, Eastbourne, Hailsham, Hastings, Heathfield, Hove, Lewes, Newhaven, Peacehaven, Polegate, Portslade-by-Sea, Saltdean, Seaford, Rye & Uckfield.

We provide Excel training across Kent including the following locations: Ashford, Broadstairs, Canterbury, Chatham, Dartford, Ditton, Deal, Faversham, Gillingham, Gravesend, Herne Bay, Maidstone, Margate, Northfleet, Rochester, Sevenoaks, Sittingbourne, Swancombe, Tonbridge, Tunbridge Wells & Whitstable.

We provide Excel training across Surrey including the following locations: Addlestone, Ashstead, Bagshot, Banstead, Cranleigh, Camberley, Caterham, Chertsey, Cobham, Dorking, Egham, Epsom, Esher, Ewell, Farnham, Frimley, Godalming, Guildford, Haslemere, Horley, Leatherhead, Oxted, Redhill, Reigate, Staines, Walton on Thames, Weybridge & Woking.

We provide Excel training across Hampshire including the following locations: Aldershot, Alton, Andover, Basingstoke, Bishop’s Waltham, Blackfield, Blackwater, Bordon, Chandler’s Ford, Eastleigh, Emsworth, Fareham, Farnborough, Fleet, Gosport, Havant, Hedge End, Hook, Horndean, Hythe, Lymington, Lyndhurst, Portchester, Portsmouth, Petersfield, New Milton, Ringwood, Romsey, Southampton, Stubbington, Tadley, Totton, Winchester, Waterlooville & Yateley.

We provide Excel training across Essex including the following locations: Basildon, Billericay, Braintree, Brentwood, Chelmsford, Chigwell, Colchester, Epping, Grays, Halstead, Harlow, Loughton, Rayleigh, Rochford, Saffron Walden, South Benfleet, Southend-on-Sea, Stanford-le-Hope, Tilbury, Wickford, Witham.

We provide Excel training across Dorset including the following locations: Bournemouth, Christchurch, Dorchester, Ferndown, Poole, Shaftesbury, Wareham, Wimborne Minster & Verwood.

We provide Excel training across Berkshire including the following locations: Ascot, Bracknell, Crowthorne, Hungerford, Maidenhead, Newbury, Reading, Sandhurst, Slough, Thatcham, Twyford, Windsor, Wokingham & Woodley.

We provide Excel training across Buckinghamshire including the following locations: Amersham, Aylesbury, Buckingham, Chesham, Gerrards Cross, Great Missenden, High Wycombe, Marlow, Milton Keynes, Newport Pagnell, Princes Risborough & Witham.

We provide Excel training across Hertfordshire including the following locations: Bishop’s Stortford, Borehamwood, Broxbourne, Bushey, Cheshunt, Harpenden, Hatfield, Hemel Hempstead, Hertford, Hitchin, Hoddesdon, Letchworth Garden City, Rickmansworth, Potters Bar, St Albans, Stevenage, Watford & Welwyn Garden City.

We provide Excel training across Oxfordshire including the following locations: Abingdon, Banbury, Bicester, Didcot, Henley-on-Thames, Thame, Wallingford, Wantage

We provide Excel training across Wiltshire including the following locations: Amesbury, Marlborough, Pewsey, Swindon, and Tidworth.

We provide Excel training across London including the following locations: Barnet, Battersea, Bexley, Bromley, Canary Wharf, Coulsdon, Croydon, Ealing, Edgware, Hillingdon, Hounslow, Islington, Kensington & Chelsea, Kingston upon Thames, Orpington, Merton, Richmond-upon-Thames, Southwark, Stratford, Surbiton, Sutton, Thornton Heath and Vauxhall.