Advanced Excel: Home

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:

• 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

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.