职场超能力：遇上AI告别手工，开启智能数据分析新时代 Intelligent Data Analysis with AI Tools
Event language(s)
Chinese/中文
Introduction / 培训简介
In today's data-driven business environment, the ability to analyze data effectively has become an essential core competency for professionals. Yet many still find themselves trapped in tedious data organization, complex formula writing, and inefficient analytical workflows—tasks that consume hours but add limited strategic value. The real challenge lies not in the volume of data, but in the gap between raw information and actionable insight.
在当今数据驱动的商业环境中，数据分析已成为职场人士不可或缺的核心能力。然而，许多人依然受困于繁琐的数据整理、复杂的公式编写和低效的分析流程——这些工作耗费大量时间，却难以产生战略价值。真正的挑战不在于数据量的大小，而在于从原始信息到可执行洞察之间的鸿沟。
By combining cutting-edge AI technologies with practical Excel applications, this course transforms the way professionals handle data. Participants will learn to leverage AI for data cleansing, formula generation, complex calculations, and dynamic visualization—turning repetitive manual work into intelligent, automated processes. Through real-world case studies and hands-on exercises, the course equips learners with a systematic methodology for AI-assisted data analysis, enabling them to solve complex business problems with speed and precision.
本课程将前沿AI技术与Excel实战应用深度融合，系统性地重塑职场人士处理数据的方式。学员将学习借助AI实现数据清洗、公式生成、复杂计算和动态可视化——将重复性手工工作转化为智能自动化流程。通过真实案例演示和实操指导，课程帮助学员掌握AI辅助数据分析的系统方法论，快速精准地解决复杂业务问题。
Objectives / 培训目标
- Mindset Transformation: Evolve from a "manual operator" to an "AI commander," rethinking how data work gets done
- 思维转型 : 从"手工操作者"升级为"AI指挥家"，重新定义数据工作方式
- Expertise Mastery: Gain proficiency in AI-driven, full-chain data analysis skills including cleaning, calculation, and visualization
- 技能精通 : 掌握AI驱动下的全链路数据分析硬核技能，涵盖清洗、计算与可视化
- Prompt Engineering: Develop the ability to craft effective prompts that guide AI to deliver accurate, optimal solutions
- 方法掌握 : 练就与AI高效协同的"提示词工程学"，获取精准最优解
- Practical Application: Build comprehensive capability to tackle complex business challenges with AI-powered tools
- 实战应用 : 具备解决复杂业务问题的综合能力，将AI工具转化为业务价值
Course Agenda / 课程安排
Guide: AI Technology Transforming Data Analysis
Three stages & nine processes, daily pain points, AI's role in data analysis
用AI技术改变数据分析困局 —三个阶段九个过程、日常痛点、AI可为数据分析做什么
Part 1: Efficient Organization – Excel Table Mastery
AI cleaning techniques (symbols, prefixes/suffixes, formula checking), AI reconstruction (batch sheet creation, merging, splitting), AI organization (knowledge base queries, grouping, summaries)
高效整理，纵横职场表格秘技 (2 hrs) - AI清洗技巧（符号、前后缀、公式检查）、AI重构（批量建表、合并、拆分）、AI整理（知识库查询、分组汇总）
Part 2: Quick Solutions – Simplifying Calculation Work
DeepSeek for calculations, logical symbols ($, &, 9E307), IF/AND logic, SUMIFS/SUMPRODUCT, XLOOKUP, AI-assisted fuzzy matching /
难题秒解，让计算工作变轻松 (2 hrs) — DeepSeek计算应用、逻辑符号、IF/AND多条件判断、SUMIFS/SUMPRODUCT汇总、XLOOKUP查找、AI辅助模糊匹配
Part 3: Automatic Analysis – Enhancing Data Insights
AI-generated charts (basic & advanced), dashboard creation with interactive elements, AI Agent for full-cycle analysis (cleaning, analysis, visualization reports)
自动分析，提升洞察数据能力 (2 hrs) — AI生成图表（基础与高阶）、仪表盘创建与交互展示、AI Agent全流程分析（清洗报告、分析报告、可视化报告）
SPEAKER :
Liu Yanbin / 刘燕彬
Senior Corporate Trainer & Microsoft Certified Trainer (MCT)
资深企业培训师 & 微软认证讲师（MCT）
Eddic 易迪思
With over 15 years of corporate training experience and 8 years specializing in thinking and logic courses, Liu Yanbin is a highly respected trainer in the fields of office productivity, data analysis, and structured thinking. She holds multiple prestigious certifications, including Microsoft Certified Trainer (MCT), Microsoft Most Valuable Professional (MVP), Certified Instructor of Structured Thinking, and UK Official Mind Mapping Trainer (TLI). She has also served as an invited lecturer for Beijing Television's educational programs for many consecutive years and is recognized as a star lecturer for office series courses on China Lecturer Network.
刘燕彬老师拥有15年以上企业培训经验及8年思维类课程授课经验，是办公效能、数据分析和结构化思维领域备受推崇的资深讲师。她持有微软认证讲师（MCT）、微软护航技术专家（MVP）、结构性思维版权课程认证讲师、英国官方思维导图认证讲师（TLI）等多项权威资质，并连续多年担任北京电视台教育节目特邀讲师，更获评中国讲师网办公系列课程明星讲师。
Training Details / 培训详情
To register scan the QR Code or Click Here
请扫描二维码或
Online / 线上
Date / 日期 :
Wednesday, July 29, 2026
2026年7月29日，星期三
Time / 时间 :
Full day
9:00 AM - 12:00 PM / 1:00 PM - 4:00 PM
全天
上午9:00–12:00 / 下午1:00–4:00
Language / 语言 :
Chinese / 中文
Price / 价格 :
1080 RMB* for Members
会员1080人民币/人
1280 RMB* for Non - Members
非会员1280人民币/人
*Price including 6,72% Tax