微信扫码参加最新线下课程
我们以实际应用为出发点，提供20多个Excel课件，上课同步操作，解决你会在工作中遇到的实际问题。让你熟练掌握会计快捷键，事半功倍不加班。
Introduction
- 高级操作技巧和Keyboard shortcut
- Cell Reference
- Financial modelling
- Chart
- CF: highlight, data bar,colour scale,icon set
- 图表转化成可变图片
- sum if and sum ifs
- if and nested if
- vlookup
- Text Function
Other Useful Process
- Data Validation 创建一级动态菜单
- Data Validation 限制输入
- Smart Art 快速制作组织结构图
- 如何处理重复值
- 制作超链接目录
Your Instructor
澳洲最大Land Leasing
社区上市公司MA
香港上市公司澳洲分公司Senior Accountant。近十年firm和commercial公司从业经验。
Course Curriculum
课程视频
Available in
days
days
after you enroll
课件
Available in
days
days
after you enroll
Frequently Asked Questions
When does the course start and finish?
The course starts now and never ends! It is a completely self-paced online course - you decide when you start and when you finish.
How long do I have access to the course?
How does lifetime access sound? After enrolling, you have unlimited access to this course for as long as you like - across any and all devices you own.
What if I am unhappy with the course?
We would never want you to be unhappy! If you are unsatisfied with your purchase, contact us in the first 30 days and we will give you a full refund.