Excel - Work with functions
Suitable for
- Students that have the skills covered in our Excel fundamentals and Understand formulas workshops
- Students who wish to use Excel to calculate and analyse data
Look through the workshop objectives to ensure that this workshop is appropriate for your needs and abilities.
Workshop objectives
By the end of the workshop you will be able to:
- Use the status bar statistics
- Copy a formula
- Use the following Statisical functions: AVERAGE, MIN, MAX, MODE, MEDIAN, STDEV, CORREL, FREQUENCY and COUNTIF
- Use the Logical function IF
- Use the Maths & Trig function COUNTIF
- Use the Lookup function VLOOKUP
How to book
Workshops are available on request from academic staff for their students. Students can also directly request workshops for a group of minimum 4, maximum 20 students.
To request a workshop, please email MOT@beds.ac.uk
Library on social media
