Excel Pro Education

Certificate in Excel Beginning

Enquire Now

Course Information

  • 25 Jun 2021 (Fri) 7:00 PM - 10:00 PM
  • 8 Jul 2021 (Thu) 7:00 PM - 10:00 PM
  • 17 Jul 2021 (Sat) 10:00 AM - 1:00 PM
Registration period
1 Jun 2021 (Tue) - 16 Jul 2021 (Fri)
HKD 690
(【 原價$890 】限時優惠!$690)
Course Level
Study Mode
3 Hour(s)
香港銅鑼灣軒尼詩道381-383號 華軒商業中心

Course Overview

Certificate in Excel Beginning

Excel 初級商務課程由淺入深,無需任何相關經驗。我們的導師由基礎開始解釋Excel究竟是一套什麼軟件,如何在日常工作中結合MS Office其他軟件WORD, PowerPoint, Access等,完成數據處理以及製作各種不同的商務報表。所有學員完成課程後將會能夠熟練地運用所有基本操作。

本課程融合了多年的實戰經驗,令各位學員能夠充分利用及了解MS Office各版本的特點。由1997年的紮實基礎到2016年版本的最新技術,都能夠靈活運用。


如有任何課程查詢或預約報名歡迎致電 3702-0208 或電郵 info@excelproedu.com.hk 與我們聯絡!


Introduction to Microsoft Office

  • What is MS Office?
  • MS Office Software/Apps checklist
  • Why do we use MS Excel?
  • Is there a substitute for MS Excel?
  • Windows / Macintosh versions of Excel
  • Excel versions
  • Excel File and Layout
  • What is an Excel file and its extension
  • How to open an Excel file
  • Excel layout
  • Excel cells and operation
  • Rows and Columns
  • Ribbon layout and structure
  • Ribbon Tabs
  • The Excel button

Excel Basic operations

  • How to save and save as an Excel file?
  • How to save an Excel file to an older version
  • How to properly save the files to cloud and other servers
  • How to save for other file types?
  • Enter numeric and text data
  • Enter data by copy and paste and auto complete
  • Investing cell formatting
  • Cell formatting types
  • Number to Values
  • Values to Numbers
  • Copy cell formatting
  • AutoSum
  • Superscripting and Subscripting
  • Copy and paste with formulas, values and transpose
  • Inert Rows and Columns
  • Delete Rows and Columns
  • Adjust Rows and Columns
  • Setting constant height and width for rows and columns
  • Hide row and columns
  • Use format painter for copying formats
  • How to clear formats, data, hyperlinks and comments
  • Skills with find and replace
  • Merge and centre
  • Use wrap test to adjust text length
  • Accounting formats and currency formats
  • How to lock you workbook, worksheets

Introduction to Excel functions

  • What is Excel functions
  • What are the types of excel functions?
  • How to use Excel functions?
  • Introduction to Excel operators


如有任何課程查詢或預約報名歡迎致電 3702-0208 或電郵到 info@excelproedu.com.hk 與我們聯絡!

What you'll learn

Certificate in Excel Beginning

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