CTHR - Introduction to Microsoft Excel 2016

Introduction to 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

Learn to quickly and efficiently use Microsoft Excel 2016 and discover dozens of shortcuts and tricks for setting up fully formatted worksheets. This course, taught by an experience Microsoft Excel instructor, provides in-depth knowledge for beginners that will have you using Excel like a pro!

If you work with numbers, you need to master Microsoft Excel 2016! This hands-on course will teach you dozens of shortcuts and tricks for setting up fully-formatted worksheets quickly and efficiently. You will also learn the secrets behind writing powerful mathematical formulas and discover how to use the function wizard to quickly and automatically calculate statistics, loan payments, future value, and more.

In addition, you will get tips on sorting and analyzing data, designing custom charts and graphs, creating three-dimensional workbooks, building links between files, endowing your worksheets with decision-making capabilities, and automating frequently-repeated tasks with macros and buttons. You will also learn Excel 2016 features, including Quick Analysis, Flash Fill, and new charting capabilities.

This is not a tutorial, but an in-depth class. By the time you're done, you will be using this vital Office 2016 application like a pro.

• Excel Basics
• Creating a Worksheet
• Time-Savers, Tips & Tricks
• Relative, Absolute, Mixed, and Circular References
• Three Dimensional Workbooks
• Sorting, Subtotaling, and Filtering
• Charting Basics
• Advanced Charting Techniques
• Intro to Excel's Statistical Functions
• Financial Functions
• Worksheet Automation
• Mastering Excel's IF Function

For more details and registration, please click here.