Sara Beattie College

Intermediate Microsoft Excel 2016 行政管理 / 會計及財務 / 電腦, 資訊科技及設計

Enquire Now

Course Information

  • 15 Dec 2021 (Wed) - 4 Feb 2022 (Fri) 12:00 PM
  • 12 Jan 2022 (Wed) - 4 Mar 2022 (Fri) 12:00 PM
Registration period
2 Sep 2021 (Thu) - 5 Jan 2022 (Wed)
HKD 2,700
($300 Cash rebate upon successful completion)
Course Level
Study Mode
6 Week(s)

Course Overview

Intermediate Microsoft Excel 2016 行政管理 / 會計及財務 / 電腦, 資訊科技及設計

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.

What You’ll Learn

• 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

Skills covered in this course

Start FollowingSee all

We use cookies to enhance your experience on our website. Please read and confirm your agreement to our Privacy Policy and Terms and Conditions before continue to browse our website.

Read and Agreed