Introduction 课程简介
Bring huge work stress for those who store the incorrect version by mistake
Make those who spend long time in formatting waste lots of time
Make those who are unable to protect data suffer huge resource losses
Any place where the cursor is located on the work interface will be your starting point for success
Benefits: comprehensively master the usage skills of various functions and help you enhance the work efficiency via the EXCEL operation level
一个不慎存错版本的人带来的巨大工作压力
一个格式化需要很长时间的人带来的巨大时间浪费
一个不会保护数据的人带来的巨大资源流失
光标落在工作界面的任何地方,都是你成功的起点
收益:综合掌握各种功能的使用技巧,帮助大家在EXCEL操作水平上提升工作效率
Course Outline 课程大纲
Theme I: Practical Skills for Worksheet (2 hours)
- Three tips for the worksheet: batched job, quick positioning and modify the default setting
- Quickly create several worksheets
- How to input the same contents in several cells
- Quickly sum the trans-table data
- Three tips for cells make your statement more wonderful
- Flexible application of the panel in the functional zone and make the appropriate functional zone for you
- The former operation habit should be reserved after upgrading to the new version
- Quick access of the common function
- Take care of the version compatibility issue
- Formula bar and view scale with free zooming
- PDF Convert the table into PDF without installation
- Important panel that you have never referred to
- Pin up the frequently used files in recent days
主题一:工作表实用技巧篇(2小时)
- 工作表三件事:批量工作、快速定位、更改默认设置
-
快速创建多张工作表
-
如何在多个单元格输入相同内容
-
对跨表的数据快速求和
-
单元格三个小技巧让你的报表更精彩
-
功能区面板的灵活应用和制作适合自己的功能区
-
升级到新版本还要保留旧的操作习惯
-
常用功能的快速访问
-
小心版本的兼容性问题
-
缩放自如的编辑栏和视图比例
-
不需安装即可直接将表格转成
-
一个你从没涉及的重要面板
-
钉住最近经常使用的文件
Theme 2: Data Sorting Skills (2 hours)
- How to quickly input the current date and time
- How to quickly input the score
- How to quickly input the text and number exceeding 15 digits
- Data type conversion method set
- How to make the pull-down menu with data validity
- Circle and release the invalid data
- Add postils in batch
- Skill for adding the picture introduction for each product
- Picture trimming skill
- Quickly achieve the exchange of the line and row with the good paste special
- Quickly achieve the computed result accumulation with the good paste special
- Draw the header with oblique line
- Reserve the original data combination
主题二:数据整理技巧篇(2小时)
-
如何快速输入当前日期和时间
-
如何快速输入分数
-
如何快速输入文本和超过15位的数字
-
数据类型转换方法大集合
-
数据有效性制作下拉菜单
-
圈释无效的数据
-
批量添加批注
-
在每个产品上添加图片介绍的技巧
-
图片的瘦身术
-
用好选择性粘贴快速实现行列互换
-
用好选择性粘贴实现在计算结果上累加
-
绘制斜线表头
-
保留原数据的合并
Theme III: Worksheet Formatting Skills (1 hour)
- Quickly use the smart format
- Quickly achieve the data summary
- Quickly sort top 10 applications
- Data freezing method without setting freezing
- Mark the data exceeding the limit with color
- Highlight top 10 data
- Quickly classify the data with icon
- Simulate the bar chart with the data bar for data comparison
- Quickly create the column diagram with mini-picture
- Quickly create the broken line graph with mini-picture
主题三:工作表格式化技巧篇(1小时)
-
快速应用智能的格式
-
快速实现数据的汇总
-
快速筛选top10的应用
-
不需要设置冻结的冻结数据方法
-
用颜色标记超过限制的数据
-
突出显示前10名的数据
-
用图标给数据快速分类
-
用数据条模拟条形图比较数据
-
用迷你图快速创建柱形图
-
用迷你图快速创建折线图
Theme IV. Worksheet Output Skills (1 hour)
- The data sheet protection makes me work at ease
- Make the interactive questionnaire forms
- Data printing skills
主题四:工作表输出技巧篇(1小时)
-
数据表保护让我更放心的工作
-
制作带交互的调查表
-
数据的打印技巧
Agenda 课程安排(培训者请一定带电脑来参加)
08:45 - 09:00 Registration 签到
09:00 - 12:00 Morning Session 上午课程
12:00 - 13:00 Lunch 午餐
13:00 - 16:00 Afternoon Session 下午课程
For bank transfers, please use BJEVENT0119 as subject.
请转账付款的学员,在银行转帐凭证细节栏标注BJEVENT0119 。
Terms & Conditions
Trainings have very limited seating so to ensure your attendance we encourage advance online registration and payment. We cannot guarantee entry to anyone not registered in advance.
The training is held in English.
Cancellation Policy
If you cannot attend the training for which you have registered, please cancel your registration no later than one business day prior to the event. If you fail to notify us of your cancellation in a timely fashion, you will be charged for event costs.
To cancel you can: 1) email jli@europeanchamber.com.cn, or 2) cancel online if you registered for the event through the website.