2020 applicants
Event

Excel – Functions and Shortcuts

  • Fri 22 Nov 19

    11:00 - 13:00

  • Colchester Campus

    IT Training Room (6.327)

  • 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.

Related events