Certificate in Excel Intermediate

Excel Pro Education
Certificate in Excel Intermediate
DATE & TIME
17 Oct 2022 (Mon)
7:00 PM - 10:00 PM
29 Oct 2022 (Sat)
10:00 AM - 1:00 PM
PRICE
HKD 890
ORGANISER
Excel Pro Education
LOCATION
香港銅鑼灣軒尼詩道423-425號 嘉年華商業大廈
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

  • Math Functions – Focus on mathematical data analysis
  • Sum function - Applying sum function to handle multiple subtractions
  • Sumif function – Applying for business case scenarios
  • Count function – Using the count function to handle items
  • Caution when using count function for text, values and empty cells
  • 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
  • Insert Bar Charts
  • Insert Line Charts
  • Insert Pie Charts/doughnut charts
  • Insert Bubble charts
  • Insert Tables for standard format data
  • Editing the data from a chart
  • Using the chart design templates
  • Moving charts to Word and PowerPoint
  • Using chart format templates
  • Setting chart, Axis titles and positions
  • Setting charts values display format
  • Setting charts grid, and box items
  • Setting Linear trend line for data fields
  • Setting Error bars – Standard Error, 5% Error, Standard Deviation
  • Setting Chart data forecasting analysis
  • Linear Forecast
  • Exponential Forecast
  • Moving Average Forecast
  • Insert shapes to the charts
  • Insert graphic design effects for the chart items
  • Insert custom background for the chart
  • 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 – Application of AND for multiple logics
  • OR  function – Application as opposite to AND
  • Mixture  of IF, AND, OR functions
  • Strategic approach to complex mixture logical functions
  • Vlookup function and Hlookup function
  • Vlookup function – Application of Vertical lookup to business data
  • Hlookup function – Application of Horizontal lookup to business data
  • Caution when handling repeated primary key data
  • Caution when locking data array
  • Caution when counting columns for large data set
  • More business application of VLOOKUP and HLOOKUP
  • Using copy and paste with transpose to hand HLOOKUP data
  • Keyboard Shortcut Keys
  • Application of keyboard shortcut keys to work faster
  • Common keyboard shortcut keys
  • Using Excel keyboard shortcut keys in PC/Mac

 

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

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

For more details and registration, please click here.
DATE & TIME
17 Oct 2022 (Mon)
7:00 PM - 10:00 PM
29 Oct 2022 (Sat)
10:00 AM - 1:00 PM
PRICE
HKD 890
ORGANISER
Excel Pro Education
LOCATION
香港銅鑼灣軒尼詩道423-425號 嘉年華商業大廈