Certificate in Excel Beginning

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

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

歡迎到本電腦中心的網上報名系統報讀以上課程，網站連結： www.ExcelPro.hk

如有任何課程查詢或預約報名歡迎致電 3702-0208 或電郵到 info@ExcelPro.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

歡迎到本電腦中心的網上報名系統報讀以上課程，網站連結： www.ExcelPro.hk

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