课程受益
● 掌握Excel使用技巧,改善工作方式,提高工作效率;
● 设计令人赏心悦目的专业数据报表,通过三个以上的函数嵌套解决复杂工作问题;
● 创建"会说话"的专业图表,通过数据透视表随心所欲生成各种报表。
Course Benefits
● Let the trainees master excel skills, and improve the way of working and increase work efficiency;
● Help trainees design pleasing professional data reports and solve complex work problems through nesting of more than three functions;
● Create vivid and talkative professional charts and generate any kind of reports you want from pivot tables.
课程大纲
一、表格根基:高级操作技巧
- 分列与快速填充
- 条件格式
- 标记和删除重复值
- 数据一级和二级验证
- 单元格、工作簿和工作簿保护
- 排序和高级筛选
二、表格灵魂:常用函数解析
- 公式与基础函数
- 统计求和家族: Sum/Sumif Sumifs/Count/Countif/Countifs
- 逻辑查找帮你解难题: If/Vlookup/Match/Index/ Indirect等
三、表格利器:透视规划分析
- 单表和多表创建透视表
- 自动分组和手动分组
- 切片器联动
- 值汇总方式
- 动态数据透视表
四、表格印象:图表演示之道
- 各种图表简介
- 图表类型选择建议
- 制作美观专业的图表
- 创意折线图、柱形图和比例图
五、总结提高:学以致用,整体答疑
Outline
1. Form foundations: Advanced manipulation skills
- Columnar and Flash Fill
- Conditional Formatting
- Mark and remove duplicate values
- Data primary and secondary validation
- Cell, Workbook and Workbook protection
- Sorting and Advanced filtering
2. Form Soul: Analysis of Common Functions
- Formulas and Basic functions
- Statistical Sum family: Sum / Sumif/Sumifs / Count / Countif / Countifs
- Logical search to help you solve puzzles: If/Vlookup/Match/Index /Indirect etc.
3. Table tool: Perspective planning analysis
- Create pivot tables with single and multiple tables
- Automatic grouping and manual grouping
- Slicer linkage
- Value aggregation method
- Dynamic pivot table
4. Impressions of Tables: The Way of Graph Presentation
- Introduction to various charts
- Chart type selection suggestion
- Create beautiful and professional charts
- Creative line, column and ratio charts
Q&A
课程受众
适合希望通过EXCEL快速提高工作效率,掌握数据分析方法的企业员工。
Course Audience
Suitable for employees who want to improve their work efficiency and master data analysis methods.
Please use your own name and email when registering for a training session. Additional fees may apply if you fail to register under your own identity.
A prepayment is required for all full-day training sessions.
全天培训课程需要提前付款。