Excel Training

Event Information

Share this event

Date and Time

Location

Location

Executive Hotel

7311 Westminster Hwy

Richmond, BC V6X 1A3

Canada

View Map

Refund Policy

Refund Policy

Refunds up to 7 days before event

Eventbrite's fee is nonrefundable.

Event description

Description

The CCPAA BC chapter is inviting you to join a Excel traing at Executive Hotel 7311 Westminster Hwy, Richmond BC V6X 1A3.

Event registration is open for Canadian Chinese Professional Accountant Association BC chapter members only. event details as follows:

Teacher: James Wu, CPA, CGA, FCCA

Time: November 16th, 2019 (Saturday) 9:00 am -12:00 pm seminar

Where: Executive Hotel 7311 Westminster Hwy, Richmond BC V6X 1A3

Note: This eventis limited to CCPAA BC chapter members only!

PD Hours: Seminar qualifies for 3.0 verifiable PD hour

Course outline is for November 16th,2019:

Excel 运用技巧 (二)
Excel分析报表:数据统计、条件格式化和图表

4. 数据格式与显示、数据表统计功能(50)
- 日期与时间公式:Weekday(), year(), month(), day(), date(), eomonth(), today(), now() 等
的运用
- 计算日期之间的年月日数量
- 举例 1:如何巧用时间日期公式修改表格题头
- 数据表的自动分组 (Data\Outline\Subtotal)
- 统计功能sumif(), Countif(), sumproduct(), product(), subtotal(),
- 在工作表中显示公式、备注;表格文件名、工作表名、文件位置等 Cell()
- 数据格式自定义,将千位变成个位。时间、日期自定义。
- 将数据转换为整倍数 Floor, Floor.math, Celling, Celling.math
5. 条件格式化Conditional formatting (30)
- Shading the every other line: =MOD(ROW(), 2)=0
- 用Conditional format 显示 需要关注、解释的项
- Highlighted when certain condition matches
- Data Bars/Color Scale
- 箭头或红绿灯
6. 图表 – Middle to High Level(50)
- 2nd Y Axis
- 复杂饼图,Pie of Pie, Donut
- 特殊图形:Waterfall, Radar, Bubble
- 截断柱状图:Broken Y Axis Chart
- 动态图表
7. Excel 公式错误的追踪、检查(30)
- 显示公式、显示并打印公式
- 自动检查单元格错误(单元格左上角有个“绿三角”)
- 如何解决错误信息“N/A”, “#Value!”,“#Name?”等
- 纠错公式Iferror(), Iserror(), True(), False(), Aggregate的使用
- 循环错误、公式验证
- 追踪数据来源与去向
- Comment备注的使用
- 不同文件之间数据及公式的链接

Date and Time

Location

Executive Hotel

7311 Westminster Hwy

Richmond, BC V6X 1A3

Canada

View Map

Refund Policy

Refunds up to 7 days before event

Eventbrite's fee is nonrefundable.

Save This Event

Event Saved