• Business

    Microsoft Excel - Intermediate

  • Attendance/Duration

    Delivery Method: Face to Face delivery

    Course Duration: 6 hours (1 day)

    Delivery Method: Online Delivery

    Course Duration: 4 hours total. 2 x 2 hours live interactive tutorial sessions.

  • Cost

    For further information on course dates and prices please email businessgrowth@ayrshire.ac.uk

What's Involved

This course is suitable for those with good knowledge of creating and formatting simple worksheets and using basic formulae.

Course Content:

  • Relative/ Absolute cell referencing
  • Excel functions – IF, LOOKUP, COUNTIF, SUMIF, ROUND/ ROUNDUP/ ROUNDDOWN
  • Introduction to linking between worksheets
  • Creating common charts
  • Conditional Formatting
  • Introduction to Data Validation
  • Introduction to PivotTables
  • Freezing panes/ splitting screen
  • Custom sorting
  • Filtering

By the end of this course participants will be able to use some common formulae and tools to extract relevant information from data. They will become more confident in using worksheets and organising data.

Funding and Fees

For further information please email businessgrowth@ayrshire.ac.uk

Enquiries

For further information please email businessgrowth@ayrshire.ac.uk

Course Search

Or

Browse all courses Advanced search