Feva Works IT Education Centre

Certificate in Microsoft Excel 2019

Enquire Now

Course Information

Schedules
  • 23 Jun 2021 (Wed) - 30 Jun 2021 (Wed) 7:00 PM - 10:00 PM
Registration period
25 Apr 2021 (Sun) - 22 Jun 2021 (Tue)
Price
HKD 1,500
Course Level
Study Mode
Duration
6 Hour(s)
Language
Cantonese
Location
北角英皇道335-341號恆生北角大廈 2 樓
28 views

Course Overview

不論是學生、在職人士、各行各業也好,都常會接觸到MicrosoftOffice的各種文件。一直以來MicrosoftOffice都擁有著強大的功能,例如可利用MicrosoftExcel去製作出功能強大的Excel試算表。

在2019年初,Microsoft推出了全新的Office2019。Office2019不但擁有強大的功能,更結合雲端應用,令你時刻與全世界接通。

為了讓大家快速掌握新版MicrosoftExcel的特色,誠意推出Excel2019應用課程。本課程會由淺入深,利用MicrosoftExcel的強大功能去製作出專業的Excel試算表。

完成課程後,學員更可獲發課程修畢證書



What you'll learn


Module 1 - Microsoft Excel – Core (3 Hrs)
1. Entering Data in Microsoft Excel Worksheets
Entering Text
Using AutoComplete
Entering Numbers and Dates
Using the Fill Handle
Quick Analysis
2. Using Formulas in Microsoft Excel
Math Operators and the Order of Operations
Entering Formulas
AutoSum (and Other Common Auto-Formulas)
Copying Formulas and Functions
Relative and Absolute Cell References
3. Working with Rows and Columns
Inserting Rows and Columns
Deleting Rows and Columns
Setting Row Height and Column Width
Hiding and Un-hiding Rows and Columns
Freezing Panes
4. Data / Time Functions
5. Text Functions
6. Finalizing Microsoft Excel Worksheets
Setting Margins
Setting Page Orientation
Setting the Print Area
Print Scaling (Fit Sheet on One Page)
Headers and Footers


Module 2 - Microsoft Excel - Advanced (3 Hrs)
1. Applying Conditional Formatting
Highlight Cell Rule
Top / Bottom Rule
Data Bar
Color Scale
Icon Sets
2. Using Pivot Tables
Creating Pivot Tables
Preparing Your Data
Inserting a Pivot Table
Inserting Pivot Charts
More Pivot Table Functionality
Automatic Time Grouping
Inserting Slicers
Multi-select Slicer
3. Data Tools
Data Validation
Flash Fill
4. Protecting Worksheets and Workbooks
Password Protecting a Workbook
Password Protecting a Worksheet
Password Protecting Ranges in a Worksheet
Tracking Changes
Accepting or Rejecting Changes
5. Summarize Functions
6. Lookup Functions
7. IF Functions


 




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