Objective : How to work smart and simply the work process through improve your Excel skills. It enables you to work smart and streamline the work in future.

You will learn how to use basic/ advanced functions of Excel to improve productivity.

• Excel Keyboard Shortcuts (Window / Mac)

• Apply formulas to a worksheet to display data in various formats. (Vlookup, IF, IFNA, Ranks, Pivot table, Data Consolidation, Goal Seeking Subtotals, Sumif, Sumifs, Countifs, Remove Duplicate, Data Sorting, Share Workbook, Reporting for data analysis....etc).

• Students will also learn how to automate common tasks, apply advanced analysis techniques to more complex data sets, collaborate on worksheets with others for simplify and streamline the day-to-day work.

Available date : Sunday/ Saturday/ Public Holiday

Time: 12:00pm to 6pm (pls select the time and advice the available time)

Langauge: Cantonese or English are available.

Fee: $400 for 2 hours / $500 for 3 hours (Learning materials will be provided).

After completed the course, it will have official receipt and training certification.

Should you have any question, pls send email to skylett.hk@gmail.com.