Community News

Pick and Mix Advanced Spreadsheet Sessions - cherry-pick your way and improve your skills

 
This forum has a limit to the number of forum postings you can make in a given time period - this is currently set at 10 posting(s) in 1 day
Picture of Kathryn Parker
Pick and Mix Advanced Spreadsheet Sessions - cherry-pick your way and improve your skills
by Kathryn Parker - Thursday, 19 January 2017, 10:33 AM
 

Advanced Spreadsheets  Functions Part 1
With Mersedes Farjad
 
Wednesday 25 January 2017  13:00 - 15:00
Venue: IT Training & Support Training Room (access via 24 hour computer room)

Topics covered in this session: 

  • Date and Time functions:
    TODAY
    NOW
    DAY
    MONTH
    YEAR
  • Mathematical functions:
    ROUND, ROUNDDOWN, ROUNDUP
    IF
    SUMIF
  • Statistical functions:
    COUNT, COUNTA, COUNTIF, COUNTBLANK
    RANK
  • Text functions:
    LEFT, RIGHT, MID
    TRIM
    CONCATENATE
  • Lookup functions:
    VLOOKUP
    HLOOKUP

Click here to book your session.  If you are unable to book for a session please contact IT Training & Support and we will try to resolve the issue.