• 高级操作技巧和Keyboard shortcut
  • Cell Reference
  • Financial modelling
Excel Visualisation
  • Chart
  • CF: highlight, data bar,colour scale,icon set
  • 图表转化成可变图片
Function and formula
  • sum if and sum ifs
  • if and nested if
  • vlookup
  • Text Function

Other Useful Process

  • Data Validation 创建一级动态菜单
  • Data Validation 限制输入
  • Smart Art 快速制作组织结构图
  • 如何处理重复值
  • 制作超链接目录

Your Instructor

Aaron Yue
Aaron Yue

澳洲最大Land Leasing


香港上市公司澳洲分公司Senior Accountant。近十年firm和commercial公司从业经验。

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.

Get started now!