Course Information
Schedules
- 10 Nov 2024 (Sun) 2:00 PM - 5:00 PM
Registration period
4 Oct 2024 (Fri) - 9 Nov 2024 (Sat)
Price
HKD 980
Course Level
Study Mode
Duration
3 Hour(s)
Language
Cantonese
Location
旺角上海街638號 旺角海景中心
6 views
Course Overview
Excel 初級商務課程由淺入深，無需任何相關經驗。我們的導師由基礎開始解釋Excel究竟是一套什麼軟件，如何在日常工作中結合 MS Office 其他軟件 Word、PowerPoint及Access等，完成數據處理以及製作各種不同的商務報表。所有學員完成課程後將會能夠熟練地運用所有基本操作。
本課程融合了多年的實戰經驗，令各位學員能夠充分利用及了解 MS Office 各版本的特點。由1997年的紮實基礎到 Office 365 版本的最新技術，都能夠靈活運用。
歡迎到本電腦中心的網上報名系統報讀以上課程，網站連結： https://www.ExcelProEdu.com.hk
如有任何課程查詢或預約報名歡迎致電 3702-0208 或電郵 info@excelproedu.com.hk 與我們聯絡！
What You’ll Learn
課程內容：
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
歡迎到本電腦中心的網上報名系統報讀以上課程，網站連結： https://www.ExcelProEdu.com.hk
如有任何課程查詢或預約報名歡迎致電 3702-0208 或電郵 info@excelproedu.com.hk 與我們聯絡！
