Excel Pro Education

Certificate in Excel Intermediate

Enquire Now

Course Information

Schedules
  • 10 Jul 2022 (Sun) 10:00 AM - 1:00 PM
  • 21 Jul 2022 (Thu) 7:00 PM - 10:00 PM
Registration period
1 Jun 2022 (Wed) - 20 Jul 2022 (Wed)
Price
HKD 890
Course Level
Study Mode
Duration
3 Hour(s)
Language
Cantonese
Location
香港銅鑼灣軒尼詩道423-425號 嘉年華商業大廈
2074 views

Course Overview

Certificate in Excel Intermediate

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

What You’ll Learn

課程內容:

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



Start FollowingSee all

We use cookies to enhance your experience on our website. Please read and confirm your agreement to our Privacy Policy and Terms and Conditions before continue to browse our website.

Read and Agreed