27 Apr 2021 (Tue) - 29 Apr 2021 (Thu)
10:00 AM - 5:00 PM
11 Apr 2021 (Sun) - 26 Apr 2021 (Mon)
Room 603 Dominion Centre, 43-59 Queen's Road East Wanchai, Hong Kong
Excel is a powerful tool used in most companies. Managements can formulate strategies and decisions on data after being processed and analyzed with Excel. It explains why most companies would like to recruit candidates with good knowledge in Excel. The course is packed with two hottest courses, Excel and Advanced Excel, that can match today's business needs.
What you'll learn
Excel ModuleUnderstanding Excel's elementsEditing techniquesWriting formulasFile operationsPrinting worksheetsUseful functionsTips in editing a worksheetsUnderstanding address notationsPolishing worksheetsNumber formatExchange files with other applicationsStylesManaging RecordsDrawingChartingUsing Layout tab
Advanced Excel ModuleNaming cells and rangesDatabaseAdvanced data sorting and subtotalUsing database functionsManaging multiple worksheetsConsolidation with several worksheetsData tableLookup tableDocument protectionFile linkingFilter and advanced filterBuilding A PivottableManipulating Your PivottableConditional formatData validationWhat-If AnalysisInserting a hyperlink to a workbookCreating and using Macros