本期Excel课程内容包括数据的处理与统计方法、图表的制作与美化。用最短的时间,最轻松的方式,让你掌握相关的Excel基本功能与实用技巧,自如应对Excel中数据的存储、处理、统计与呈现。
This Excel course encompasses data manipulation and statistical methods, as well as the creation and enhancement of charts. It aims to equip you with essential Excel functions and practical skills in the most efficient and effortless manner, enabling you to adeptly handle data storage, processing, analysis, and presentation in Excel.
讲解版本: Microsoft Office Professional Plus 2016
Version: Microsoft Office Professional Plus 2016
课程介绍
INTRODUCTION
01
Excel数据处理与统计
Excel Data Processing and Statistics
1. 数据处理常用工具
Tools for data Processing
2. 分类汇总的应用
Application of Subtotal
3. 数据透视表的应用
Application of Pivot Table
授课语言:中文
Language: Chinese
时间:11月6日(周三) 15:30-16:30
Time: 15:30-16:30, 6 November (Wednesday)
线下地点:图书馆455机房,苏州园区校园
Location: Computer Room 455, Library, SIP Campus
报名方式:
How to Register:
扫描二维码报名注册
Scan QR Code to Register
02
Excel 图表之道
The Way of Excel Charts
1. 图表的常见类型
Common Types of Charts
2. 图表的制作及各要素
Creation and Components of a Chart
3. 图表的外观优化
Chart Appearance Optimization
授课语言:中文
Language: Chinese
时间:11月13日(周三) 15:30-16:30
Time: 15:30-16:30, 13 November (Wednesday)
线下地点:图书馆455机房,苏州园区校园
Location: Computer Room 455, Library, SIP Campus
报名方式:
How to Register:
扫描二维码报名注册
Scan QR Code to Register