Digital Services        F A Q

SCHOLARLY TALKS

Advanced Excel for Data Processing

University Library (February 16, 2022)
1243









SEMINAR SERIES : Research Data Tool Series Workshop

MAJOR SPEAKER : CHUNG, Siu Sun
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: https://hkbutube.lib.hkbu.edu.hk/st/display.php?bibno=st1035
  ●  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