Certificate in Excel Beginning

課程內容：

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 與我們聯絡！