Nicole会计培训

 找回密码
 立即注册
搜索
热搜: 活动 交友 discuz
查看: 146|回复: 0

[20/10]Excel Class Homework

[复制链接]

105

主题

171

帖子

799

积分

高级会员

Rank: 4

积分
799
发表于 2018-10-20 19:17:46 | 显示全部楼层 |阅读模式
Homework 1 - AR Analysis
-Calculate VCI Accounts Receivable Balance total by Agency/Direct Selling/Other/Policy Expired/Cr Bal/Instalment
-Use If formula to calculate AR Aging (within coverage) - column K to V.

Homework 2 - Sales Analysis
-Use named range and sumifs formulas

Homework 3-Fix Asset Register(IF excercise)
- calculate column G/H/J/K in <Homework 3 - fix asset register> using 30/6/2016 as year end date.

Homework 5- regional report
-Use sumif to summarize budget and actual totals for different regions

Homework 6 - Create dashboard report as per screenshot

Homework 7 - budget vs actual variance raw data
Create a pivot table as per screenshot

本帖子中包含更多资源

您需要 登录 才可以下载或查看,没有帐号?立即注册

x
您需要登录后才可以回帖 登录 | 立即注册

本版积分规则

QQ|Archiver|手机版|小黑屋|Nicole会计培训

GMT+10, 2018-12-14 09:35 , Processed in 0.091791 second(s), 22 queries .

Powered by Discuz! X3

© 2001-2013 Comsenz Inc.

快速回复 返回顶部 返回列表