The Essex website uses cookies. By continuing to browse the site you are consenting to their use. Please visit our cookie policy to find out which cookies we use and why. View cookie policy.

University of Essex homepage Events Excel – Functions and Shortcuts
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.

WE ARE
ESSEX ARE YOU?
Get a prospectus Get to know Essex
STUDY
Find a course
LIFE
RESEARCH
EXPLORE
CONTACT US
Contact


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

 

 

University of Essex - Where change happens

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