返回主页
Anne Teoh
  • ☛  Certified Microsoft Excel Expert
  • ☛  Certified Train The Trainer - PSMB
  • ☛  Certified as Microsoft Office Specialist Excel,Word,Powerpoint (2013/2016)
11月 2日-3日 2020年(一至二) 7小时 / 2天
09:00AM - 12:30PM RM350
中文



☛  Who is this course for?
   ⚬   This program targets audience who would like to explore the possibilities of Excel formulas and functions. And if you are those who wish to gain the skills and understand the formulas and functions syntax. Learn how do they apply in a nested formulas environment?

☛  Prerequisites:
   ⚬   Knowledge of Microsoft Excel Intermediate is essential with the follow pre-requisites:
   ⚬   • Able to switch between task applications
   ⚬   • Able to “Create”, “Save”, “Open”, and “Print” spreadsheet
   ⚬   • Able to use the “Undo” function
   ⚬   • Insert and delete Row & Column
   ⚬   • Print a spreadsheet with headers and footers applied
   ⚬   • Insert, Delete and Rename a worksheet
   ⚬   • Able to create basic formulas like addition, subtraction, multiplication and division
   ⚬   • Able to use basic functions like Sum, Average, Count, Max and Min function

☛  Methodology:
   ⚬   This program will be conducted with interactive lectures and hands-on application for each participant. The Instructor will demonstrate all techniques using simple but realistic examples that enable participants apply what they learnt into their work. Sessions will include discussions, practical class work and Q & A session.

Course Outline

Module 1: Cell and Range References
   ⚬    • Creating an Absolute Reference

Module 2: Statistical Functions
   ⚬    • COUNTIF Function
   ⚬    • COUNTBLANK Function
   ⚬    • RANK Function

Module 3: Math and Trig Functions
   ⚬    • SUMIF To Add Data That Satisfy Condition
   ⚬    • ROUND Function
   ⚬    • ROUNDUP Function
   ⚬    • ROUNDDOWN Function

Module 4: The wonders of Text Functions
   ⚬    • Changing the Case of Text
   ⚬    • Combining Text from Multiple Columns
   ⚬    • Breaking Date Field into Individual Day, Month and Year
   ⚬    • Trimming Off Excess Spaces in A Cell
   ⚬    • Replacing existing data with new value in a cell using SUBSTITUTE Function
   ⚬    • Converts value to text with TEXT Function

Module 5: Logical Functions
   ⚬    • Hiding formula error with IFERROR function
   ⚬    • Using If Function to make decision
   ⚬    • AND function
   ⚬    • Create Multiple Conditions Using Nested If
   ⚬    • Nested IF & AND Function

Module 6 - Lookup & Reference Formulas
   ⚬    • Use VLOOKUP To Find Specific Data
   ⚬    • VLOOKUP Array Formula
   ⚬    • Use MATCH to Match Data
   ⚬    • Use INDEX to Retrieve Data
   ⚬    • Nested INDEX & MATCH

Module 7: Date & Time Formulas
   ⚬    • Date Calculation
   ⚬    • Add A Number to Current Date To Get New Dates
   ⚬    • Calculate a duration Between Two Dates



线上课程购票流程

1. 确认课程后, 点击购买
2. 请选择购票的数量
3. 请填写您的个人资料:(必须填写,我们将在购票后向您发送线上课程的链接)
      -   姓名
      -   联络电话
      -   电邮地址
      -   公司名字
      -   公司地址
4. 付款
5. 付款成功后您将收到电子邮件通知。
6. 我们会电邮线上课程Zoom的链接给您。

所有线上课程都将透过Zoom来进行。请在上课前把Zoom安装好。




联系我们 | 隐私条款 | 使用者条例 | 常见问题