1fy07h 发表于 2024-7-1 02:15:35

EXCEL自动生成的PPT


    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">由于</span>经常要做周报、月报PPT，每次重复的的操作效率很低，<span style="color: black;">这儿</span>整理了一套<span style="color: black;">能够</span>自动生成PPT的办法。</p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">首要</span>，大概思路是<span style="color: black;">这般</span>的。周报、月报这类经营分析类PPT<span style="color: black;">通常</span>都<span style="color: black;">是由于</span>表格、图表以及分析文字<span style="color: black;">构成</span>的，整体结构相对固定。</p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">先利用EXCEL的获取数据功能获取数据库、网页数据，<span style="color: black;">或</span>手工<span style="color: black;">创立</span>一个<span style="color: black;">基本</span>表（数据库）；<span style="color: black;">而后</span>用EXCEL生成表格，图表，并利用函数生<span style="color: black;">成份</span>析文字（可<span style="color: black;">按照</span>数据更新）；再<span style="color: black;">经过</span>PPT直接调用EXCEL内容<span style="color: black;">创立</span>PPT模板。</p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">做好了EXCEL<span style="color: black;">基本</span>表和PPT模板，每次<span style="color: black;">运用</span>的时候只要重新<span style="color: black;">拜访</span>数据库或修改<span style="color: black;">基本</span>表，PPT就能直接更新，自动生成。</p>
    <div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://pic4.zhimg.com/80/v2-97661413348a66064e1d669f30b46e0f_720w.webp" style="width: 50%; margin-bottom: 20px;"></div>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">第1</span>步：<span style="color: black;">创立</span>EXCEL<span style="color: black;">基本</span>表（数据库）</p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">例如</span>手工<span style="color: black;">创立</span>一张每月的<span style="color: black;">营销</span>报表，<span style="color: black;">做为</span><span style="color: black;">基本</span>表。</p>
    <div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://pic4.zhimg.com/80/v2-4a66b81d6d676cde7694bab42849b2f7_720w.webp" style="width: 50%; margin-bottom: 20px;"></div>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">亦</span><span style="color: black;">能够</span><span style="color: black;">经过</span>EXCEL的获取数据功能<span style="color: black;">经过</span>网页、文本、<span style="color: black;">或</span><span style="color: black;">拜访</span>数据库（如SQL等）获取数据</p>

    <div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://pic3.zhimg.com/80/v2-63284ba2768a55ead59354e21fa5e94e_720w.webp" style="width: 50%; margin-bottom: 20px;"></div>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">不懂的话看这篇</p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><a style="color: black;">Excel数据获取 - 可乐数据分析之路的<span style="color: black;">文案</span> - 知乎</a></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">关于<span style="color: black;">拜访</span>SQL数据库，<span style="color: black;">因为</span><span style="color: black;">日前</span><span style="color: black;">无</span>环境，还没试过。</p>
    <div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://pic1.zhimg.com/80/v2-c58da4642dab3852bae4c7a4e837b14c_720w.webp" style="width: 50%; margin-bottom: 20px;"></div>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">第二步：EXCEL生成PPT展示元素</p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">这部分其实<span style="color: black;">便是</span><span style="color: black;">经过</span>excel把你想在PPT上呈现的内容都做出来。</p>表格：这个就<span style="color: black;">不消</span>说了吧，<span style="color: black;">经过</span>EXCEL<span style="color: black;">各样</span>公式对<span style="color: black;">基本</span>表里的数据进行<span style="color: black;">各样</span>求和、环比、同比、排名等，<span style="color: black;">基本</span>表更新表格同步更新。<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://pic2.zhimg.com/80/v2-274d0ddf0c4c6c7ded229af14ea080a1_720w.webp" style="width: 50%; margin-bottom: 20px;"></div>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">图表：这<span style="color: black;">亦</span><span style="color: black;">不消</span>多说，<span style="color: black;">经过</span><span style="color: black;">基本</span>表生成<span style="color: black;">各样</span>图表</p>
    <div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://pic1.zhimg.com/80/v2-3d8030e2d8f307272b43841e7334283c_720w.webp" style="width: 50%; margin-bottom: 20px;"></div>
    <div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://pic1.zhimg.com/80/v2-364f9b5064faf2c1647edd80d97cef08_720w.webp" style="width: 50%; margin-bottom: 20px;"></div>分析文字：PPT页面中<span style="color: black;">常常</span>有对数据分析的总结性文字。这部分文字<span style="color: black;">怎样</span>自动生成并<span style="color: black;">按照</span>原始数据更新而变化呢？很简单<span style="color: black;">运用</span>TEXT函数+&amp;连接符<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://pic3.zhimg.com/80/v2-bc23d23886eb3d3c844221caf6515a0e_720w.webp" style="width: 50%; margin-bottom: 20px;"></div>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">最后把所有元素<span style="color: black;">根据</span><span style="color: black;">期盼</span>在PPT上呈现的效果进行排版</p>
    <div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://pic4.zhimg.com/80/v2-daf952782f5167ee83d334d96b593db7_720w.webp" style="width: 50%; margin-bottom: 20px;"></div>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">最后一步：PPT调用EXCEL</p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">这步很<span style="color: black;">要紧</span>，选中要在PPT中展示内容所在的“单元格”，复制</p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">打开PPT，粘贴-<span style="color: black;">选取</span>性粘贴-粘贴链接，<span style="color: black;">重视</span><span style="color: black;">不可</span>用ctrlV，这就把excel中的所有元素都调用过来了</p>
    <div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://pic2.zhimg.com/80/v2-68f917a0a6f4f492c5016b57ceec313d_720w.webp" style="width: 50%; margin-bottom: 20px;"></div>
    <div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://pic4.zhimg.com/80/v2-615e74db1061770e6b582c8552ca6edf_720w.webp" style="width: 50%; margin-bottom: 20px;"></div>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">根据</span><span style="color: black;">以上</span>的办法，精心编辑好<span style="color: black;">每一个</span>PPT页面，做成一个<span style="color: black;">能够</span><span style="color: black;">长时间</span><span style="color: black;">运用</span>的模板</p>
    <div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://pic2.zhimg.com/80/v2-8bc48cf5e4df025b73efba7c2d44f60d_720w.webp" style="width: 50%; margin-bottom: 20px;"></div>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">放大招：一键生成PPT</p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">每周或每月要做PPT的时候，只要更新EXCEL<span style="color: black;">基本</span>表的数据，<span style="color: black;">保留</span>后，打开PPT文件，点击“更新链接”，PPT就会自动<span style="color: black;">相关</span>EXCEL的数据，更新<span style="color: black;">关联</span>文字、表格、图表等内容，数十P的PPT瞬间生成，有<span style="color: black;">无</span>很香？！</p>

    <div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://pic1.zhimg.com/80/v2-9c9cfbc09a9a53b45385195a0bd28cd4_720w.webp" style="width: 50%; margin-bottom: 20px;"></div>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">最后几点说明：</p>PPT和EXCEL放在同一个目录下；PPT和EXCEL不要变更名<span style="color: black;">叫作</span>，变更会<span style="color: black;">引起</span>断链；断链<span style="color: black;">怎样</span>处理看<span style="color: black;">这儿</span>：<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"> <a style="color: black;"><span style="color: black;">https://</span><span style="color: black;">jingyan.baidu.com/artic</span><span style="color: black;">le/e2284b2b206daea3e7118d3b.html</span></a></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"> 3.<span style="color: black;">第1</span>次更新PPT链接的时候，先打开EXCEL，<span style="color: black;">这般</span>更新链接比较快；</p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">4.更新后的PPT，每次打开就<span style="color: black;">不消</span>更新链接，直接取消<span style="color: black;">就可</span>。<span style="color: black;">倘若</span>EXCEL数据有更新，PPT再更新<span style="color: black;">就可</span>。</p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">就说这么多了，不<span style="color: black;">必须</span>VBA，不<span style="color: black;">必须</span>函数，是不是很简单，<span style="color: black;">期盼</span>有帮到你。</p>




j8typz 发表于 2024-10-4 17:54:39

你的见解独到，让我受益匪浅，期待更多交流。

wrjc1hod 发表于 2024-10-18 03:39:58

我完全同意你的观点，说得太对了。
页: [1]
查看完整版本: EXCEL自动生成的PPT