Certificate in Excel Intermediate

Course Overview

Excel 中級商務課程是Excel教學系列中的核心課程，課程涵蓋所有在工作中需要的重點函數 (Functions) 以及鍵盤捷徑 (Keyboard shortcut keys)。內容完全涵蓋金融，會計，建築，零售，餐飲，文員，生產等行業的日常Excel函數 (Functions) 應用。

我們的導師由基礎開始逐個函數 (Functions) 講解其中的結構及輸入方法，如何在日常工作中靈活地組合運用，完成數據處理以及製作各種不同的商務報表。所有學員完成課程後將能夠熟練地運用 Excel 在工作中所需要的重點函數 (Functions) 以及鍵盤捷徑 (Keyboard shortcut keys).

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

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

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

課程內容：

Excel Functions

• Sumif function – Applying for business case scenarios
• Countif function - Applying for business case scenarios
• Max function – Handling Max business value analysis
• Min function – Handling Min cost business value analysis
• Max and Min caution when handling local, Global Max and Min
• Average function – Applying arithmetic mean for analysis
• Averageif function - Applying for business case scenarios
• Round function – Rounding with all digits
• Roundup function – Up Rounding with all digits
• Rounddown function – Down Rounding with all digits

Text Functions

• & using this operator to combine cell content
• Left function – Handling ID, Invoice, SKU numbers
• Right function - Handling ID, Invoice, SKU numbers
• Middle function - Handling ID, Invoice, SKU numbers
• Trim function – Handling irregular spacing problems

Time & Date Functions

• Now function – To insert a current date and time to the excel
• Today function – To insert a current date to the excel
• Days function – To calculate the number of days between dates
• Weekdays function – To calculate the week number of a year
• Yearfrac function – To calculate the number of years between dates
• Year function – Extracting the year from a date
• Month  function – Extracting the Month from a date
• Day function – Extracting the Day from a date
• Hour  function – Extracting the hour from time
• Minute function – Extracting the Minute from time

Insert Tables and Charts

• Introduction to the standard format of data
• Preparing the standard format data for tables and charts
• Insert Tables for standard format data
• How to Insert Charts for standard format data
• Editing the data from a chart
• Using the chart design templates
• Moving charts to Word and PowerPoint
• Changing text colour and styles
• Adjusting the chart size in proportion

Logic Functions

• Logic Tests – The fundamental TRUE/FALSE analysis for Excel
• > Greater than
• < Less Than
• <> Not Equal to
• <= Less than or equal to
• >= Greater than to equal to
• = Equal to
• Logic functions
• If function – Application of IF to business data
• AND  function 
• OR  function
• Mixture  of IF, AND, OR functions
• Vlookup function and Hlookup function
• Vlookup function
• Hlookup function
• More business application of VLOOKUP and HLOOKUP