返回主页
Anne Teoh
  • ☛  Certified Microsoft Excel Expert
  • ☛  Certified Train The Trainer - PSMB
  • ☛  Certified as Microsoft Office Specialist Excel,Word,Powerpoint (2013/2016)
10月 1日-2日 2020年(四至五) 8小时 / 2天
09:00AM - 1:00PM RM250
中文



☛  Who is this course for?
   ⚬   This course is designed for Clerks, Officers, Executives, Supervisors, Administrators, Managers of all levels; and personnel who already know and understand and want to further enhance their knowledge and practical uses of Microsoft Excel.

☛  Prerequisites:
   ⚬   • Basic knowledge of Microsoft Excel is essential with the following pre-requisites:
   ⚬   • Have attended Microsoft Excel – Foundation Level; OR
   ⚬   • Able to switch between task applications
   ⚬   • Able to create a spreadsheet with simple formatting
   ⚬   • Able to create a basic chart
   ⚬   • Able to print a spreadsheet with headers and footers added
   ⚬   • Able to create basic formulas – Addition, Subtraction, Multiplication and Division
   ⚬   • Able to use basic functions – AutoSum, Count, Max, Min and Average functions.

☛  Methodology:
   ⚬   This program will be conducted with interactive lectures, PowerPoint presentation, discussions and practical exercise

☛  Course Objectives:
   ⚬   • Upon completion of this program, participants should be able to:
   ⚬   • Learn main key point of calculation
   ⚬   • Managing Data
   ⚬   • Sorting and filtering
   ⚬   • Visualizing in a Table
   ⚬   • Visualizing Data with Chart


Course Outline

Module 1: Performing Calculations
☛   Topic A: Reuse Formulas
   ⚬    • Relative References
   ⚬    • Absolute References
   ⚬    • Mixed References
   ⚬    • Understanding Mixed Cell References

Module 2: Working with Functions
☛   Topic A: Using Statistical Function
   ⚬    • COUNTIF Function
   ⚬    • AVERAGEIF Function
☛   Topic B: Using Mathematical Function
   ⚬    • SUMIF Function
☛   Topic C: Using Logical Function
   ⚬    • IFERROR Function
   ⚬    • IF Function

Module 3: Organizing Worksheet Data with Tables
☛   Topic A: Create and Modify Tables
   ⚬    • Tables
   ⚬    • Table Components
   ⚬    • The Create Table Dialog Box
   ⚬    • The Table Tools – Design Contextual Tab
   ⚬    • Styles and Quick Style Sets
   ⚬    • Customizing Row Display
   ⚬    • Table Modification Options
☛   Topic B: Sort and Filter Data
   ⚬    • The Difference Between Sorting and Filtering
   ⚬    • Sorting Data
   ⚬    • Advanced Filtering
   ⚬    • Removing Duplicate Values
☛   Topic C: Removing Duplicate Values
   ⚬    • SUBTOTAL Functions
   ⚬    • Summary Functions in Tables

Module 4: Visualizing Data with Chart
☛   Topic A: Create Charts
   ⚬    • Charts
   ⚬    • Chart Types
   ⚬    • Chart Insertion Methods
   ⚬    • Resizing and Moving the Chart
   ⚬    • Adding Additional Data
   ⚬    • Switching Between Rows and Columns



线上课程购票流程

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

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




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