Skip to content
University of Essex homepage Events Functions and short-cuts in Excel
Event

Functions and short-cuts in Excel

  • Tue 11 Feb 20

    12:00 - 14:00

  • Colchester Campus

    Library Training Room

  • Event type

    Workshops, training and support
    Maths, Stats, and Digital Skills Workshops

  • Event organiser

    Student Development Department

  • Contact details

Need help with Microsoft Excel?

Learn how to construct functions, manipulate data and format outputs. In this training session, you’ll work through a series of exercises using the following:

o          Paste special
o          Naming cell ranges
o          Relative vs absolute referencing
o          Basic functions eg SUM, MAX, MIN, DATE eg TODAY()
o          IF functions eg IF, SUMIF, COUNTIF, AVERAGEIF
o          Strings eg LEFT, MID, RIGHT
o          VLOOKUP
o          Concatenate / text to tables
 

 

Click here to book onto this workshop through CareerHub or visit the Student Services Hub in the Silberrad Student Centre.

For more information

Skills for Success are here to help you succeed in your studies and achieve your potential.  We offer support and resources to help improve your writing, maths, research, study skills and English language, no matter what your discipline or level of study. All Skills for Success workshops can be booked via CareerHub.

Visit our webpages or go to the Student Services Hub in the Silberrad Student Centre to find out more about our services, and how we can help.

Need help finding your way?

Download Pocket Essex to access 'find your way' - our online campus map and navigation guide, or take a look at our campus map.

WE ARE
ESSEX ARE YOU?
Sign up for a prospectus Find a course
STUDY
Find a course
LIFE
RESEARCH
EXPLORE
CONTACT US
Contact


  • +44 (0) 1206 873333
  • University of Essex
  • Wivenhoe Park
  • Colchester CO4 3SQ

 

 

CONNECT WITH US
© 2026 University of Essex. All rights reserved