|
|
Many organizations nowadays require their staff to operate Microsoft Excel beyond its basics to help gain understanding or formulate strategies from datasets. This 2-hour hands-on workshop (conducted by Mr. Sun Chung, Feb 2022) introduces advanced features in Excel for effectively processing and analyzing data. Learning outcome includes:
Don't have time to view the 2-hour tutorial? Here are short video tutorials (廣東話) from Dex IT Flipped Classroom (Excel Series) on some of the advanced Excel functions that was demonstrated in the workshop.
SUM, COUNT, MIN, MAX, AVERAGE, SUMIF, COUNTIF, COUNTA, COUNTBLANK |
LEFT, MID, RIGHT, TRIM, FIND, UPPER, LOWER, PROPER, CONCAT, CONCATENATE |
PivotTable 樞紐分析表 |
VLookup |
Library Home |
Opening Hours |
Contact Information |
Location Map |
Privacy Policy |
Site Map |
Intranet |
Copyright © 2010-2019. Hong Kong Baptist University Library. All rights reserved. |