Excel中级技能速成

让你熟练掌握会计快捷键,事半功倍不加班。

   视频介绍

微信扫码参加最新线下课程

我们以实际应用为出发点,提供20多个Excel课件,上课同步操作,解决你会在工作中遇到的实际问题。让你熟练掌握会计快捷键,事半功倍不加班。

Introduction

  • 高级操作技巧和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

社区上市公司MA

香港上市公司澳洲分公司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!