Certificate in Excel Intermediate

Excel Pro Education
Certificate in Excel Intermediate
DATE & TIME
25 Sep 2021 (Sat)
10:00 AM - 1:00 PM
22 Oct 2021 (Fri)
7:00 PM - 10:00 PM
24 Oct 2021 (Sun)
10:00 AM - 1:00 PM
PRICE
HKD 790
(【 原價$890 】限時優惠!$790)
ORGANISER
Excel Pro Education
LOCATION
香港銅鑼灣軒尼詩道381-383號 華軒商業中心
Certificate in Excel Intermediate
DESCRIPTION

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

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

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

歡迎到本電腦中心的網上報名系統報讀以上課程,網站連結: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

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

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


Certificate in Excel Intermediate

For more details and registration, please click here.
DATE & TIME
25 Sep 2021 (Sat)
10:00 AM - 1:00 PM
22 Oct 2021 (Fri)
7:00 PM - 10:00 PM
24 Oct 2021 (Sun)
10:00 AM - 1:00 PM
PRICE
HKD 790
(【 原價$890 】限時優惠!$790)
ORGANISER
Excel Pro Education
LOCATION
香港銅鑼灣軒尼詩道381-383號 華軒商業中心