#注意：本文包含大量实际操作的gif图片，请在网络通畅的环境下阅读。

#另：受限于gif大小，每个场景只能展示 20s 左右的录屏

#另另：本文盘点的所有场景均使用国产 AI 实现，请放心食用。

目录：运营场景 | 内容创作 | 品牌市场 | 数据分析 | 日常办公 | 个人提升

场景一：运营场景

我们在之前的推文中已经展示过太多 AI 在私域运营场景的应用，所以废话少数直接上实操录屏。

1. 量产朋友圈文案，一次一周×3 条/天

By：Kimi

2. 针对营销推送，量产水军文案

By：ChatGLM

3. 设计社群答题游戏

By：ChatGLM

场景二：内容创作

1. 写抖音探店文案

By 文心一言 4.0

2. 修改小红书标题为爆款风格

By ChatGLM

3. 一键总结公众号文章，生成转发文案

ByKimi

4. 针对选题生成观点和大纲

By ChatGLM

场景三：市场品牌

1. 快速搞定行业研究

By Kimi

2. 分析评价正负面情感给出安抚话术

By ChatGLM

场景四：数据分析

1. 自动提取网页内的数据形成表格

By Kimi

2. 根据表格提供数据分析的维度

By ChatGLM

3. 自动数据分析并提供可视化图表

By ChatGLM

场景五：日常办公

1. 自动审核合同

By 毕昇

这个图太大，所以录了视频，没有加速，不到 3 分钟审完一份合同……

2. 自动写提纲，秒做 PPT

By AIPPT

下张图超大耐心等待

3. 整理会议纪要

By Kimi

4. 批量汇总 Excel 表格

By 文心一言

复制下来放进 Excel 宏命令，运行，搞定。

场景六：个人提升

1. 优化简历、模拟面试

By Kimi

2. 辅助自学编程

By ChatGLM

篇幅和素材限制，只能展示部分能力。更多能力展示，可以关注 11 月 29 日的公开课，我来尽量多的给大家演示（扫码加好友预约+进群）

11月30日《AI 重塑职场竞争力行动营》开营，如果你不想被这个时代落下太多，务必尽快报名！

","gnid":"975c5462efb4a7943","img_data":[{"flag":2,"img":[{"desc":"","height":"420","title":"","url":"https://p0.ssl.img.360kuai.com/t01548a9b1c8f07b24d.jpg","width":"900"},{"desc":"","height":"676","s_url":"https://p0.ssl.img.360kuai.com/t019541815e74667d9f_1.gif","title":"","url":"https://p0.ssl.img.360kuai.com/t019541815e74667d9f.gif","width":"968"},{"desc":"","height":"776","s_url":"https://p0.ssl.img.360kuai.com/t013dcd5bb55ddd3611_1.gif","title":"","url":"https://p0.ssl.img.360kuai.com/t013dcd5bb55ddd3611.gif","width":"972"},{"desc":"","height":"776","s_url":"https://p0.ssl.img.360kuai.com/t01239f4a501d497aa6_1.gif","title":"","url":"https://p0.ssl.img.360kuai.com/t01239f4a501d497aa6.gif","width":"972"},{"desc":"","height":"842","s_url":"https://p0.ssl.img.360kuai.com/t01fc919750a170f8fb_1.gif","title":"","url":"https://p0.ssl.img.360kuai.com/t01fc919750a170f8fb.gif","width":"1046"},{"desc":"","height":"732","s_url":"https://p0.ssl.img.360kuai.com/t016e7883f797d3e986_1.gif","title":"","url":"https://p0.ssl.img.360kuai.com/t016e7883f797d3e986.gif","width":"988"},{"desc":"","height":"544","s_url":"https://p0.ssl.img.360kuai.com/t019f8d57cea04fc821_1.gif","title":"","url":"https://p0.ssl.img.360kuai.com/t019f8d57cea04fc821.gif","width":"940"},{"desc":"","height":"606","s_url":"https://p0.ssl.img.360kuai.com/t015da57c28010ce085_1.gif","title":"","url":"https://p0.ssl.img.360kuai.com/t015da57c28010ce085.gif","width":"946"},{"desc":"","height":"604","s_url":"https://p0.ssl.img.360kuai.com/t01b389b70ab6be8dad_1.gif","title":"","url":"https://p0.ssl.img.360kuai.com/t01b389b70ab6be8dad.gif","width":"974"},{"desc":"","height":"702","s_url":"https://p0.ssl.img.360kuai.com/t01a48459296635e1b7_1.gif","title":"","url":"https://p0.ssl.img.360kuai.com/t01a48459296635e1b7.gif","width":"954"},{"desc":"","height":"698","s_url":"https://p0.ssl.img.360kuai.com/t0129a49b05a92a80f6_1.gif","title":"","url":"https://p0.ssl.img.360kuai.com/t0129a49b05a92a80f6.gif","width":"946"},{"desc":"","height":"894","s_url":"https://p0.ssl.img.360kuai.com/t019b2454b2f8aeacf0_1.gif","title":"","url":"https://p0.ssl.img.360kuai.com/t019b2454b2f8aeacf0.gif","width":"908"},{"desc":"","height":"878","s_url":"https://p0.ssl.img.360kuai.com/t01042ef486811b383f_1.gif","title":"","url":"https://p0.ssl.img.360kuai.com/t01042ef486811b383f.gif","width":"990"},{"desc":"","height":"652","s_url":"https://p0.ssl.img.360kuai.com/t012b31bf0707154a10_1.gif","title":"","url":"https://p0.ssl.img.360kuai.com/t012b31bf0707154a10.gif","width":"984"},{"desc":"","height":"624","s_url":"https://p0.ssl.img.360kuai.com/t015da3f06350f7e577_1.gif","title":"","url":"https://p0.ssl.img.360kuai.com/t015da3f06350f7e577.gif","width":"1079"},{"desc":"","height":"612","s_url":"https://p0.ssl.img.360kuai.com/t01512e1846566ed476_1.gif","title":"","url":"https://p0.ssl.img.360kuai.com/t01512e1846566ed476.gif","width":"1052"},{"desc":"","height":"824","s_url":"https://p0.ssl.img.360kuai.com/t01e181f707309ab41c_1.gif","title":"","url":"https://p0.ssl.img.360kuai.com/t01e181f707309ab41c.gif","width":"902"},{"desc":"","height":"634","s_url":"https://p0.ssl.img.360kuai.com/t01c069b37ae1ce701d_1.gif","title":"","url":"https://p0.ssl.img.360kuai.com/t01c069b37ae1ce701d.gif","width":"1079"},{"desc":"","height":"780","s_url":"https://p0.ssl.img.360kuai.com/t01c37ab473f165cb81_1.gif","title":"","url":"https://p0.ssl.img.360kuai.com/t01c37ab473f165cb81.gif","width":"1032"},{"desc":"","height":"740","s_url":"https://p0.ssl.img.360kuai.com/t010c4c368131b29e89_1.gif","title":"","url":"https://p0.ssl.img.360kuai.com/t010c4c368131b29e89.gif","width":"942"},{"desc":"","height":"574","s_url":"https://p0.ssl.img.360kuai.com/t01963f7ab06ccd811b_1.gif","title":"","url":"https://p0.ssl.img.360kuai.com/t01963f7ab06ccd811b.gif","width":"906"},{"desc":"","height":"646","s_url":"https://p0.ssl.img.360kuai.com/t01860559b3863d3937_1.gif","title":"","url":"https://p0.ssl.img.360kuai.com/t01860559b3863d3937.gif","width":"876"}]}],"original":0,"pat":"pdc,art_src_3,fts0,sts0","powerby":"pika","pub_time":1701230160000,"pure":"","rawurl":"http://zm.news.so.com/0912c2f2dd93a74584f4b4dff56806d1","redirect":0,"rptid":"fed3e5aca59d27d3","rss_ext":[],"s":"t","src":"人人都是产品经理","tag":[{"clk":"ktechnology_1:excel","k":"excel","u":""},{"clk":"ktechnology_1:kimi","k":"kimi","u":""}],"title":"多图盘点：AI在实际工作中的表现到底行不行？

狐剂咏1675EXCEL如何用自动生成目录? -
能油旺17210098717 ______ 用超连接

狐剂咏1675怎么样批量生成excel的sheet名称目录链接 -
能油旺17210098717 ______ 使用VBA可完成操作目标.按照如下步骤操作:1. 在excel文件中打开vba编辑器(可利用快捷键alt+F11)2. 点击左侧sheet1,复制如下代码到右侧编辑框中(如下图所示)3. 运行该代码(点击播放按钮或者直接按F4)4. 回到sheet1中即可看到...

狐剂咏1675excel工作表太多怎样编辑目录 -
能油旺17210098717 ______ 1. 打开Excel 2007,右击第一张工作表标签选择“重命名”,把它重命名为“目录”工作表.选中B1单元格,切换到“公式”选项卡,单击“定义名称”,在弹出的“新建名称”窗口中输入名称 List,在引用位置中则输入=INDEX(GET....

狐剂咏1675office2010怎么自动生成目录 -
能油旺17210098717 ______ 工具原料:电脑+office2010 office2010自动生成目录方法如下:1,在插入目录之前,需要设置各级标题的样式,在“开始”选项卡界面的右边有样式设置选项,如下图所示.2,选中一级标题,点击样式里的“标题1”,依次将所有的一级标题进...

狐剂咏1675如何应用EXCEL建立电子文件目录? -
能油旺17210098717 ______ 实现的方法和详细的操作步骤如下: 1、第一步,在需要提取文件夹名称的文件夹中创建一个新的“文本文档”,如下图所示,然后进入下一步. 2、其次,完成上述步骤后,双击以打开文档并输入一组字符“dir> tp.txt”,并在输入后直接保...

狐剂咏1675如何用EXCEL制作文件目录 -
能油旺17210098717 ______ 插入代码 Dim Fso As New FileSystemObject Dim Fld As Folder Dim sRow As Single Sub FileSearchTools() Dim SrchDir As String, SrchString As String Dim fDialog As FileDialog sRow = 0 Set fDialog = Application.FileDialog( _ ...

狐剂咏1675如何快速为Excel工作簿创建工作表目录? -
能油旺17210098717 ______ 定义名称 打开Excel 2007, 右击第一张工作表标签选择“重命名”,把它重命名为“目录”工作表.选中B1单元格,切换到“公式”选项卡,单击“定义名称”,在弹出的“新建名称”窗口 中输入名称“工作表名”,在引用位置中则输入公式...

狐剂咏1675如何给Excel工作表创建目录以便能简单明了的管理工作表 -
能油旺17210098717 ______ 步骤 1、在工作簿中新建一个工作表,命名为“目录”. 2、单击B1单元格,切换到“公式”选项卡,单击“定义名称”,弹出【新建名称】对话框,在“名称”文本框中输入“目录”,在“引用位置”文本框输入以下公式: =INDEX(GET....

狐剂咏1675excel2007工作簿中有一个工作表,如何自动生成目录 -
能油旺17210098717 ______ 将这个工作表移动到首个工作表的位置在工作表标签上单击右键>>>查看代码粘贴如下宏代码,按F5执行.或回到工作表中按ALT+F8选择此宏执行sub test()for i =2 t...

狐剂咏1675Excel批量处理文件,提取文件名 -
能油旺17210098717 ______ 比如,这里如果想要把“7.21”这个文件夹里面的文件,要做个整理,把文件名称都汇总在一个excel表格了,常见的就是一个一个复制文件名称,然后新建excel表格,但这样效率很慢.快速提取文件名称方法一:使用,打开Chrome 浏览器——...