Digital Services        F A Q


Advanced Excel for Data Processing

University Library (February 16, 2022)

SEMINAR SERIES : Research Data Tool Series Workshop

LENGTH : 128 min.
ACCESS : Open to all
SUMMARY : Many organizations nowadays require their staff to operate Microsoft Excel beyond its basics to help gain understanding or formulate strategies from datasets. This hands-on workshop introduces advanced features in Excel for effectively processing and analyzing data. Learning outcome includes: Perform data processing and analysis using advanced functions (TRIM, CONCATENATE, VLookup, HLookup, SumIFS, CountIFS...); View data using tables, filters, database and criteria; Perform data automation using VBA programming.  [Go to the full record in the library's catalogue]

  ●  Persistent link:
  ●  XML Dublin Core code for metadata harvesting

Recommended for You

This video is presented here with the permission of the speakers. Any downloading, storage, reproduction, and redistribution are strictly prohibited without the prior permission of the respective speakers. Go to Full Disclaimer.

  For enquiries, please contact Digital and Multimedia Services Section

© 2009-2023 All rights reserved