Event Details

Do you still think that Excel is a tool that is used only by people in your company's finance department? If so, you are wrong. It does have fantastic financial modeling capability but it offers so much more than that.


Are you bothered by making work reports at the end of each month?

How can we quickly sort out valuable information when we faced a large amount of data?

How can the complex information and data present the most intuitive effect?


Come to our course, it will greatly improve your working efficiency and quality. Going beyond simple tables and charts, you will learn to use advanced excel functions and data analysis tools, such as what-if analysis, solver, etc. With these powerful tools, you'll be more productive than you've ever dreamed!


你是否仍然认为Excel是一种只供公司财务部门人员使用的工具?如果是的话,你错了。它确实拥有出色的财务建模能力,但它提供的远远不止这些。


还在对每个月底写工作报告感到烦恼吗?

面对海量数据,如何快速整理出有价值的信息?

如何将复杂的信息和数据用最直观的方式呈现?


来参加我们的课程,你将学会使用高级的excel函数和数据分析工具,以及制作各类报表和图标。这些强大的Excel工具,将会大大提高你的工作效率和质量,助你的工作更上一步!



Topic 1. Function application, statistics become more efficient

  • What is a relative/absolute reference 什么是相对/绝对引用
  • Summation under different conditions: SUM, SUMIFS 不同条件下的求和:SUM、SUMIFS
  • Statistics under different conditions: COUNTA, COUNTIFS 不同条件下的统计:COUNTA、COUNTIFS
  • Match the corresponding data with VLOOKUP 使用VLOOKUP匹配对应数据
  • VLOOKUP and Match function nesting, more flexible searching VLOOKUP与Match函数嵌套,查找更灵活
  • Calculation between multiple tables 多表之间的数据计算


Topic 2. Data analysis, making data analysis more efficient with PivotTable

  • Use the PivotTable to quickly count duplicate items 运用透视表快速统计重复项目
  • Different summary methods for the same field 同一字段不同汇总方式
  • Use the PivotTable to analyze the time dimension by year, quarter, month, etc. 利用数据透视表进行按年、季度、月等时间维度上的分析
  • Use PivotTable to analyze different regions, industries, etc. 利用数据透视表进行不同区域、行业等维度分析
  • Use the PivotTable for year-on-year and month-on-month analysis 利用数据透视表进行同比、环比分析
  • Generate a dynamic PivotTable 生成动态的数据透视图

Speakers

  • Yunyun Hu (Eddic)

    Yunyun Hu

    Eddic

    Microsoft Certified Trainer, Microsoft Office Specialist, Microsoft Certifications for IT Professionals.
    With 9 years’ training experiences in most top 500 enterprises and government administrations. With a high evaluation from trainees. With hundreds of lectures yearly.
    Training CEIBS EMBAs《EXCEL数据分析与决策》for 5 years.
    Contracted with SOCIETE GENERALE Beijing branch, international SOS, Roche etc.
    Make PPT for CIB Wuhan branch, prepare business strategy PPT for many well-known enterprises.

    view more

Tickets

Member Ticket
Member Price RMB 360
Member Company Employee
Standard Price RMB 550
Non-Member Ticket
Standard Price RMB 1,000
Buy 5 get 1 free
Standard Price RMB 2,750

Venue

Soho 3Q Area A, 4F, Sigma Plaza Sunny World Phase 2

168 Lushan Road, Jianye District
Nanjing, Jiangsu, China

If you have any questions please contact Katherine Zhao

Contact Organizer

Show on map