CTHR - Intermediate Microsoft Excel 2016

Intermediate Microsoft Excel 2016

DATE & TIME (Expired)

12 May 2021 (Wed) - 2 Jul 2021 (Fri)
12:00 PM

16 Jun 2021 (Wed) - 6 Aug 2021 (Fri)
12:00 PM

14 Jul 2021 (Wed) - 3 Sep 2021 (Fri)
12:00 PM

18 Aug 2021 (Wed) - 8 Oct 2021 (Fri)
12:00 PM

15 Sep 2021 (Wed) - 5 Nov 2021 (Fri)
12:00 PM

PRICE

HKD 2,700
($300 Cash rebate upon successful completion)

ORGANISER

Sara Beattie College

LOCATION

DESCRIPTION

Harness the power of Excel and become an expert user of this powerful program. This hands-on course will provide skills to create informative, eye-catching charts and graphs, and master Excel's data analysis tools and AutoFilter commands.

In addition, you will find out how easy it is to create macros that let you manipulate data with the push of a button. You will also discover how to use Goal Seek and Solver and apply them to real-world problems.

Set yourself apart from the casual Excel user by adding VLOOKUP, INDEX & MATCH, and other time-saving functions to your repertoire.

• Excel Charts and Graphs
• More Excel Charts
• AutoFilter and Sorting
• Goal Seeking
• PivotTables
• Advanced PivotTables
• Solver
• Sparklines
• Macros
• Introduction to Functions
• Math/Trig Functions
• VLOOKUP, INDEX, and MATCH Functions

For more details and registration, please click here.