• Business

    Data Interpretation using Excel

  • 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

Whats Involved

This course is suitable for those with a basic understanding of Excel.

This course will introduce a number of basic data interpretation using features on Excel. Our tutor will explore a range of data analysis functions that can be used to extrapolate meaningful information from a large data set.

The course will begin by introducing functions that are useful to clean data sets prior to manipulation. Our tutor will explore a range of text functions, logical functions, Date functions and basic statistical functions to ensure that participants are aware of tools that line within Excel to assist in the collection of meaningful information.

Course Content:

  • Cleaning the data
  • Conditional formatting
  • Text, date, logical and statistical functions
  • Summarising large data sets
  • Combining/splitting data
  • Filtering data

At the end of this course participants will be aware of some ways in which they can use analysis tools to better understand the key information contained within a data set. This will help inform decision making within the organisation.

Funding 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