01609 882408
07774 816859
(£0.00) 0

No products in the cart.

Return To Shop
Shopping cart (0)
Subtotal: £0.00

Checkout

  • Home
  • Course Calendar
  • Courses
    • Environmental and Technical Skills
      • Chainsaws
      • Brushcutter/Strimmer
      • Wood Chippers
      • Pesticide Application
        • PA1 Safe Use of Pesticides
        • PA2 Vehicle Mounted / Trailed or Self-propelled Boom Sprayer
        • PA6 Handheld / Knapsack applicator
        • PA1 / PA6 Safe Use of Pesticides and Handheld Applicator
        • PA9 Fogging and misting
        • PA11 Seed Treatment
        • PA4 Granular Application
        • PA4S Slug Pelleter
        • PA12 Continuous Batch Process
      • Health and Safety
        • Fumigation and Fogging For Covid
        • Fire Safety Awareness Course
        • Asbestos awareness
        • Emergency First Aid
        • Emergency First Aid + Forestry
        • Manual Handling
        • Rolo health, safety and Environmental awareness
    • Safe use of Vehicles, Plant and Machinery
      • Telescopic handlers
      • Forklift
      • Skid Steer Tracked or Wheeled
      • Sit Astride ATV (Quad)
      • Trailer Towing (B+E)
      • Tractor Driving
      • Ride on Mowers
      • Workshop Equipment
    • Animal Transport
      • Short Journeys Certificate of competence
      • Animal Transport E Learning
    • Vermin Control
      • Rodent Control on Farms E-learning
    • Business Skills
      • Book Keeping, Accounts & Finance
      • Data Protection
      • ICT Skills
    • Online Training
    • ESF Bespoke Skills Service Funded Courses
  • Training Info
  • Useful Resources
  • Training Room
  • Business Support
  • About us
  • Newsletters
  • Blog
  • Contact
(£0.00) 0
0 Shopping Cart

No products in the cart.

Return To Shop
Shopping cart (0)
Subtotal: £0.00

Checkout

  • Home
  • Course Calendar
  • Courses
    • Environmental and Technical Skills
      • Chainsaws
      • Brushcutter/Strimmer
      • Wood Chippers
      • Pesticide Application
        • PA1 Safe Use of Pesticides
        • PA2 Vehicle Mounted / Trailed or Self-propelled Boom Sprayer
        • PA6 Handheld / Knapsack applicator
        • PA1 / PA6 Safe Use of Pesticides and Handheld Applicator
        • PA9 Fogging and misting
        • PA11 Seed Treatment
        • PA4 Granular Application
        • PA4S Slug Pelleter
        • PA12 Continuous Batch Process
      • Health and Safety
        • Fumigation and Fogging For Covid
        • Fire Safety Awareness Course
        • Asbestos awareness
        • Emergency First Aid
        • Emergency First Aid + Forestry
        • Manual Handling
        • Rolo health, safety and Environmental awareness
    • Safe use of Vehicles, Plant and Machinery
      • Telescopic handlers
      • Forklift
      • Skid Steer Tracked or Wheeled
      • Sit Astride ATV (Quad)
      • Trailer Towing (B+E)
      • Tractor Driving
      • Ride on Mowers
      • Workshop Equipment
    • Animal Transport
      • Short Journeys Certificate of competence
      • Animal Transport E Learning
    • Vermin Control
      • Rodent Control on Farms E-learning
    • Business Skills
      • Book Keeping, Accounts & Finance
      • Data Protection
      • ICT Skills
    • Online Training
    • ESF Bespoke Skills Service Funded Courses
  • Training Info
  • Useful Resources
  • Training Room
  • Business Support
  • About us
  • Newsletters
  • Blog
  • Contact
Facebook Twitter Instagram
Return to previous page
Home Courses Business Skills

ICT Skills

Excel Training

Excel Training

Brief Description

This one-day training course aims to give basic users of Excel knowledge of commands and functions which will make them more proficient in spreadsheet design and development. How to apply these tools to solving their own business problems and good spreadsheet practice will also be covered.

Accreditation: Certificate of attendance

Course Duration: 1 Day

Maximum number participants: 6

Prerequisites: None

Price: £120+VAT

What Will be covered?

Functions

  • Date function
  • Time function
  • Round function
  • IF function
  • Integer function

Cell Addressing

  • Absolute cell addresses
  • Relative cell addresses

Conditional Formatting

  • Applying conditional formats to text
  • Applying conditional formats to numerical values
  • Clearing rules

Database Features

  • Using a spreadsheet as a database
  • Sorting data
  • Basic subtotals
  • Filtering data with Filter
  • Custom Filter
  • Define a range as a table
  • Find Feature

Working with Multiple Sheets

  • Selecting sheets
  • Inserting & deleting sheets
  • Copying sheets
  • Copy and paste between sheets
  • Naming sheets
  • 3D calculations
  • Group edit facility
  • Using Hyperlinks to link worksheets

Working with Multiple Workbooks

  • Opening multiple workbooks
  • Arranging windows
  • Linking workbooks
  • Hyperlinks to worksheets and workbooks

Additional Features

  • Inserting comments
  • Charting
  • Revision of basic charts
  • Chart types
  • Sizing and moving a chart
  • Editing a chart
  • Changing chart data
  • Formatting chart elements
  • Drawing features
  • Printing a chart

Cancellation Policy

The full cost of the course is to be paid before the start of the course.

If you cancel your place you will be liable for 100% of the cost. Unless a cancellation is received in writing 14 days prior to the commencement

 

Upcoming Courses

Newsletter sign up

Beech Hill Farm, Ellerbeck, Northallerton, North Yorkshire. DL6 2TD
E: enquiries@va-training.co.uk   T: 01609 882408   M: 07774 816859  

Facebook Twitter Instagram

Newsletter sign up

Ⓒ Web design Yorkshire by Feel Design
  • Privacy Policy
  • T&Cs
We use cookies to ensure that we give you the best experience on our website. If you continue to use this site we will assume that you are happy with it.OkNo