学会Excel财务建模理念,迎接大数据,对数据进行精准记录,汇总和分析,掌握更多Excel 高级应用,同时增强创建财务建模能力,提高工作效率。课程中提供大量实用Excel模型,丰富的Excel技巧和操作实例,无需修改即可实际应用。

  • protect & unprotect workbook or worksheet, save as and protect
  • 隐藏公式,不让别人选择某些单元格
  • 设置文件密码,open, modify或者都选

Function and formula

  • 用countif添加辅助列实现vlookup的一对多查找
  • count, countif,countifs,row,rows, column,columns函数
  • index + match
  • sumproduct, product
  • offset

Power Query

  • 做data combination和data clean
  • 如何用conditional column功能复制if
  • 如何创建mapping query并merge去主表里,如何用merge取代if
  • slicer和pivot chart

Excel Visualisation

  • 图表的各个要素和基本图表类型
  • 动态图表
  • 图表中使用自定义图片
  • 子弹图

Macro 入门

  • 介绍,显示developer tab,录制简单Macro,查看录制的Macro
  • 如何在其他工作簿引用录制的Macro
  • 把录制的Macro加入到quick access toolbar
  • 自定义函数 Mlookup


  • indirect 制作二级下拉菜单
  • goal seek
  • senario manager
  • data table

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!