培训 | EXCEL中数据的处理、统计与展示

百科   2024-11-04 10:01   江苏  

本期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



西交利物浦大学图书馆
图书馆服务台电话:8816 1290
 最新文章