What you'll learn
- excel的自定义下拉列表
- excel的合并计算
- excel的自定义快捷输入
- excel的文本替换
- excel的sumif、countifs、vlookup等高级函数用法
- 第三方插件
- 数据库处理-powerquery
- 宏处理
- vba基础入门
Requirements
- 基本的excel操作
- 安装office2010以上
Description
Excel作为当前主流的数据处理工具，具有高效、便捷、易上手等特点，但是在日常工作中，我们时常被一些简单的工作所困扰，例如，如何快速自定义下拉列表，如何进行分组统计、如何连接数据库、如何使用VBA实现小功能。通过本课程带你快速入手，了解那些实用小技巧。
Excel as the current mainstream data processing tool, has the characteristics of high efficiency, convenience, easy to use, but in our daily work, we are often troubled by some simple work, such as how to quickly customize the drop-down list, how to group statistics, how to connect the database, how to use VBA to achieve small functions. Through this course, you can quickly start to understand those practical tips
Who this course is for:
- 数据分析
- 数据加工处理
- 文秘人员
Course content
- Preview04:13
- Preview03:13
- Preview02:48
- 03:57分类汇总
- 03:06数据折叠显示
- 05:17自定义排序
- 03:14差异化单元格
- 06:40自定义快捷输入
- 03:50圈选特殊数据
- 06:07记录数据最后修改时间-if函数
- 06:15文本替换-substitute
- 05:37条件求和-sumif
- 06:34多条件求和-sumifs
- 05:09多条件计数-countifs
- 11:34神公式-vlookup
- 09:04第三方插件-方方格子
- 05:00第三方图标插件-easycharts
- 11:58第三方查询插件-powerquery
- 07:53VBA及宏处理
- 13:36vba编程
Instructor
![Jianxiawzx wang](data:image/svg+xml,%3Csvg xmlns="http://www.w3.org/2000/svg" viewBox="0 0 64 64"%3E%3C/svg%3E){kind=avatar}
- -- Instructor Rating
- -- Reviews
- 6 Students
- 7 Courses
Hello everyone, I am your lovely teacher Wang, majoring in IT technology, mastering a large number of front-end and back-end development resources and frameworks. I have been engaged in IT for 7 years. I have hired external IT technical lecturers for multiple units and have led the team to complete a number of large and medium-sized developments. Project, like technology sharing, hope to progress with like-minded people. I hope that through my technology sharing, you will lay a solid foundation for your advancement in IT technology so that you can achieve your goals as soon as possible.
大家好，我是你们可爱的王老师，IT技术专业，掌握大量前后端开发资源与框架，从事IT工作7年，为多个单位的外聘IT技术讲师，曾带领团队完成多项大中型开发项目，喜欢技术分享，希望与志同道合的人一起进步。希望通过我的技术分享为你们的IT技术进阶打下坚实的基础，从而早日实现自己的目标。