Skip to Main Content

Event box

Excel Basics: Practical Functions for Data Analysis

Date:
Tuesday, November 10, 2026
Time:
2:00pm - 3:00pm
Location:
D-2027
Campus:
Taicang Campus
Audience:
  Postgraduates     Staff     Undergraduates  
Categories:
  Smart Tools  

本期Excel基础课程将通过常用函数和实际数据分析练习带你入门 Excel 函数的使用,帮助你掌握数据排名、条件判断、条件统计和数据查找等基础技能。

This Excel basic training will introduce you to commonly used Excel functions through practical data analysis exercises, helping you develop essential skills in ranking, conditional analysis, conditional statistics, and data lookup.

 

Workshop Outline:

* 排名函数(RANK)

* 常用逻辑函数(IF)

* 条件统计函数(COUNTIF、SUMIF) 

* 查找与引用函数(VLOOKUP、XLOOKUP) 

* 其他常用统计函数概览 

 

* Ranking Function (RANK) 

* Common Logical Function (IF) 

* Conditional Statistical Functions (COUNTIF, SUMIF) 

* Lookup and Reference Functions (VLOOKUP, XLOOKUP) 

* Overview of Other Common Statistical Functions 

 

In-Person:

D-2027, XJTLU Entrepreneur College (Taicang)

 

Language:

Chinese

Registration is required. There are 41 seats available.

Event Organizer

Taicang Campus Library

Upcoming Workshops

Time Zone: China, Malaysia, Singapore (change)

Oct
15
3:00pm - 4:00pm, D-2027, Taicang Campus.