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]
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.
This video is archived and disseminated for educational purposes only. It is presented here with the permission of the speakers, who have mandated the means of dissemination.
Statements of fact and opinions expressed are those of the inditextual participants. The HKBU and its Library assume no responsibility for the accuracy, validity, or completeness of the information presented.
Any downloading, storage, reproduction, and redistribution, in part or in whole, are strictly prohibited without the prior permission of the respective speakers. Please strictly observe the copyright law.