Sara Beattie College

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

Enquire Now

Course Information

Schedules
  • 15 Dec 2021 (Wed) - 4 Feb 2022 (Fri) 12:00 PM
  • 12 Jan 2022 (Wed) - 4 Mar 2022 (Fri) 12:00 PM
Registration period
23 Aug 2021 (Mon) - 5 Jan 2022 (Wed)
Price
HKD 2,700
($300 Cash rebate upon successful completion)
Course Level
Study Mode
Duration
6 Week(s)
Language
English
Location
-
62 views

Course Overview

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

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.

What You’ll Learn

• 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



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