Feva Works IT Education Centre

Certificate in Microsoft Excel 365

Enquire Now

Course Information

Schedules
  • 12 Nov 2024 (Tue) - 19 Nov 2024 (Tue) 7:00 PM - 10:00 PM
Registration period
16 Oct 2024 (Wed) - 12 Nov 2024 (Tue)
Price
HKD 1,500
Study Mode
Duration
6 Hour(s)
Language
Cantonese
Location
-
3 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



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