This is a past event. Registration is closed. View other AustCham Shanghai events.

Professional Microsoft Office Trainer Nadine Yu will be providing a half day interactive Microsoft Excel intermediate training course. Aimed at financial, sales, marketing, HR, and operations professionals, attendees will learn how to manipulate data, calculate a variety of outcomes smartly, and analyze data to produce results that various professionals may need. This course will introduce the intermediate to advanced Excel techniques empowering participants to further utilize Excel's powerful features to handle different statements.

This course will be taught in English by a bilingual trainer and is part two of a two part series.

What You Will Learn:

单元 4: 数据库管理 数据库函数,财务函数,数据导入和导出,创建数据透视表和图表报告

Module 4: Data Analysis Database Functions, Financial Functions, Import and Export Data, Create a PivotTable/ PivotChart Report

单元 5: 工作表管理 链接工作表,链接工作簿,合并计算工作表,设定密码,保护储存格和对象,群组及大纲

Module 5: Worksheet Management Link Worksheets, Link Workbooks, Consolidate Worksheets, Assign a Password, Protect Cells and Objects, Outline a Worksheet

单元 6: IF 逻辑块 趋势分析,单变量求解,规划求解,频率分布,方案管理器,审核工作表,数据有效性, 使用 IF 函数, 嵌套 IF 函数,合并逻辑函数

Module 6: Using IF Logic Employ Trend Analysis, Use Goal Seek, Using Solver, Determine Frequency Distribution, Use Scenario Manager, Audit a Worksheet, Use Data Validation, Use the IF Function, Nest IF Functions, Combine Logical Functions

单元 7: 高级数据管理 使用 HLOOKUP,使用 VLOOKUP,创建单变量数据模拟运算表,创建双变量数据模拟运算表

Module 7: Advanced Data Management Use HLOOKUP, Use VLOOKUP, Create a One-Variable Table, Create a Two-Variable Table

At Course Completion:

After completing this course, students will be able to:

  • Sort and filter financial figures
  • Manage and audit spreadsheets
  • Visualise data
  • Use database functions, information functions, lookup functions, logical functions to handle large amount of data stored in Excel
  • Use automating tools to create dashboards and better analyse data

Please bring your own laptop!

Sponsors and Partners




Discover and connect with other attendees.

View community profiles and add attendees into your favorites list.