论坛 › 西藏 › Excel教程：牛x！给老板看的报表就用动态图表！

f9yx0du 发表于 2024-10-1 17:02:03

Excel教程：牛x！给老板看的报表就用动态图表！

    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><img src="https://mmbiz.qpic.cn/mmbiz_jpg/k6kCsib3eJMy46PTZPG4BGLVZJmia20gUXsFwPf9sDbvQoMSXv1g5eib8qB0yGmzXrF32mbySZyVnwPVdUXJUFkQA/640?wx_fmt=jpeg&amp;tp=webp&amp;wxfrom=5&amp;wx_lazy=1&amp;wx_co=1" style="width: 50%; margin-bottom: 20px;"></p><span style="color: black;"><strong style="color: blue;"><span style="color: black;"><strong style="color: blue;"><strong style="color: blue;"><span style="color: black;">↑</span></strong></strong><strong style="color: blue;"><span style="color: black;">入群，免费领取500个Excel函数学习↑&nbsp;</span></strong></span></strong></span>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><strong style="color: blue;"><span style="color: black;">每日</span>一点小技能</strong></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><strong style="color: blue;">职场打怪不得怂</strong></p><img src="https://mmbiz.qpic.cn/mmbiz_gif/k6kCsib3eJMwY0OFSrNT3ia8icQZ7PfJGEujYl6Y6002J6gxSU0S4nfqrNPib5ciciaHb5yxeKr3eBTzkp91cYwss0XA/640?wx_fmt=gif&amp;tp=webp&amp;wxfrom=5&amp;wx_lazy=1" style="width: 50%; margin-bottom: 20px;">
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">下图中是一份很<span style="color: black;">平常</span>的报表，老板觉得看数据很麻烦，就让助理按这个数据做一个图表出</span><span style="color: black;">来，<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>出达成率的变化趋势。</span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"><img src="https://mmbiz.qpic.cn/mmbiz_png/k6kCsib3eJMwfZM9Qr29ZElE6untJAnUajS3wsxrgqdvtJTPUvQnZDiaKJib9LH5OsuYnnrpjlOaB7w5icRX8Jp20Q/640?tp=webp&amp;wxfrom=5&amp;wx_lazy=1&amp;wx_co=1" style="width: 50%; margin-bottom: 20px;"></span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"><span style="color: black;">倘若</span>是你接到这个指令的话，会做出一份什么样的图表呢？</span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"><img src="https://mmbiz.qpic.cn/mmbiz_png/k6kCsib3eJMwfZM9Qr29ZElE6untJAnUaxKwIPEMOLhCdd1T0ZeF9AibA4MAcmb3sExZmBa3v7aHnQBYjOuBP6jw/640?tp=webp&amp;wxfrom=5&amp;wx_lazy=1&amp;wx_co=1" style="width: 50%; margin-bottom: 20px;"></span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"><span style="color: black;">倘若</span>你做出<span style="color: black;">这般</span>的效果，密密麻麻的，自己都看不清是什么内容，敢交给老板看吗？</span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><img src="https://mmbiz.qpic.cn/mmbiz_gif/k6kCsib3eJMwfZM9Qr29ZElE6untJAnUamfQynS6BOr9qne1ibB0unjSH7uzgCpUWe45YaDt8XiaAZYeaHyJTZXpw/640?tp=webp&amp;wxfrom=5&amp;wx_lazy=1" style="width: 50%; margin-bottom: 20px;"></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">但<span style="color: black;">倘若</span>你做出了<span style="color: black;">这般</span>的效果，又是什么心情呢？</span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">今天就和<span style="color: black;">大众</span>分享<span style="color: black;">怎样</span>制作<span style="color: black;">这般</span>的动态图表，<span style="color: black;">运用</span>Excel2016版进行演示（2013版的操作<span style="color: black;">办法</span>类似，<span style="color: black;">然则</span>WPS和Excel2010就不<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>2013<span style="color: black;">或</span>2016进行练习）。</span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">制作动态图表<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>看动画演示：</span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><img src="https://mmbiz.qpic.cn/mmbiz_gif/k6kCsib3eJMwfZM9Qr29ZElE6untJAnUaZTjgJIvggGFTKT89neEY9LW6jwGicNum0d3C1FtIYwBh5gEHN04UkNA/640?tp=webp&amp;wxfrom=5&amp;wx_lazy=1" style="width: 50%; margin-bottom: 20px;"></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><strong style="color: blue;">QQ群：459675543下载练习课件</strong></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">今天这个图表要用到的是组合框控件，表单控件<span style="color: black;">第1</span>行的第二个：</span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"><img src="https://mmbiz.qpic.cn/mmbiz_png/k6kCsib3eJMwfZM9Qr29ZElE6untJAnUa4SrDfsYAWRdkdc4E43iaib8H8YOq8ia3FTd3In4wx0y0CIOIubYXJdKAA/640?tp=webp&amp;wxfrom=5&amp;wx_lazy=1&amp;wx_co=1" style="width: 50%; margin-bottom: 20px;"></span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">点一下这个控件，<span style="color: black;">而后</span>在表格里拖出<span style="color: black;">体积</span>合适的矩形框就完<span style="color: black;">成为了</span>添加：</span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"><img src="https://mmbiz.qpic.cn/mmbiz_png/k6kCsib3eJMwfZM9Qr29ZElE6untJAnUaa0yrh5XNIPMBnEA2yvSD7ONW0uFOL11UGiczJ2SRqmhyL3COaBZ3GzQ/640?tp=webp&amp;wxfrom=5&amp;wx_lazy=1&amp;wx_co=1" style="width: 50%; margin-bottom: 20px;"></span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">点击右键设置控件格式，参考动画演示进行设置：</span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><img src="https://mmbiz.qpic.cn/mmbiz_gif/k6kCsib3eJMwfZM9Qr29ZElE6untJAnUaglYoJDicoL4lXHpU0kibiapujTWnujWBiaQyQvvOy7uD7muEIicJY8GghwA/640?tp=webp&amp;wxfrom=5&amp;wx_lazy=1" style="width: 50%; margin-bottom: 20px;"></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">设置完成后，<span style="color: black;">咱们</span><span style="color: black;">能够</span><span style="color: black;">经过</span>控件来选择月份，<span style="color: black;">同期</span>在A17单元格会<span style="color: black;">表示</span>出一个数字：</span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"><img src="https://mmbiz.qpic.cn/mmbiz_png/k6kCsib3eJMwfZM9Qr29ZElE6untJAnUalGlpWNFBZJPOddats7Nh5X5USCic4PmCSVtzDT3rsJjiast4kDJTBZfQ/640?tp=webp&amp;wxfrom=5&amp;wx_lazy=1&amp;wx_co=1" style="width: 50%; margin-bottom: 20px;"></span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">这个数字<span style="color: black;">表率</span><span style="color: black;">咱们</span><span style="color: black;">选取</span>的数据是列表中第几月的数据。</span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">为了做出图表，还需要制作一个图表用的数据源，<span style="color: black;">首要</span>完成以下内容：</span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"><img src="https://mmbiz.qpic.cn/mmbiz_png/k6kCsib3eJMwfZM9Qr29ZElE6untJAnUadzicjj4xCKXvkpp2vfubWb0VAJ9ey9K3tcibAV1BSXuC4QzPgCrMxaAA/640?tp=webp&amp;wxfrom=5&amp;wx_lazy=1&amp;wx_co=1" style="width: 50%; margin-bottom: 20px;"></span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">这些内容需要手工完成，<span style="color: black;">而后</span><span style="color: black;">运用</span>公式对<span style="color: black;">详细</span>数据进行引用。</span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">将B17到D17这几个单元格合并，<span style="color: black;">运用</span>公式：</span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">=INDEX(A3:A14,A17)&amp;"数据展示"，得到标题：</span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"><img src="https://mmbiz.qpic.cn/mmbiz_png/k6kCsib3eJMwfZM9Qr29ZElE6untJAnUaafQtniaUz0kWeSoVL6D3GC5sGUhDcibMyiccB5DmjJbYToVoTptyPsb0w/640?tp=webp&amp;wxfrom=5&amp;wx_lazy=1&amp;wx_co=1" style="width: 50%; margin-bottom: 20px;"></span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">公式解析：index函数的格式为index（数据区域，区域的第几个值），在<span style="color: black;">这儿</span>数据区域<span style="color: black;">便是</span>A3:A14（月份），<span style="color: black;">经过</span>A17单元格的数字来确定返回第几个值，后面用&amp;把"数据展示"连起来<span style="color: black;">做为</span>标题用。</span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"><span style="color: black;">详细</span>数据<span style="color: black;">运用</span>公式：</span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">=OFFSET($A$2,$A$17,ROW(A1)*3+COLUMN(A1)-3)</span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><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;"><img src="https://mmbiz.qpic.cn/mmbiz_png/k6kCsib3eJMwfZM9Qr29ZElE6untJAnUa95MU4LedaxTo73fenQcU47d1VTXUkt3tMFjVvW18y9vev8wxBlj4zA/640?tp=webp&amp;wxfrom=5&amp;wx_lazy=1&amp;wx_co=1" style="width: 50%; margin-bottom: 20px;"></span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">公式解析：offset函数的格式为offset（基点，行偏移量，列偏移量，高度，宽度），在<span style="color: black;">这儿</span><span style="color: black;">咱们</span><span style="color: black;">运用</span>A2单元格<span style="color: black;">做为</span>基点，行偏移量用A17单元格的数字，比较有难度的是列偏移量，需要借助行号（row函数）和列号（column函数）来实现。</span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">ROW(A1)*3+COLUMN(A1)-3这部分得到的结果是：</span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"><img src="https://mmbiz.qpic.cn/mmbiz_png/k6kCsib3eJMwfZM9Qr29ZElE6untJAnUaem1icOF2kuTGVVB7IicRWQic1KzECbI9ibe3kayNuyAZZicOMxBxvB4Wnkg/640?tp=webp&amp;wxfrom=5&amp;wx_lazy=1&amp;wx_co=1" style="width: 50%; margin-bottom: 20px;"></span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">利用这个公式，就把同一行的数据变<span style="color: black;">成为了</span>六行<span style="color: black;">掰开</span><span style="color: black;">表示</span>。</span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">数据的构造完成以后，<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>来确定，<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><span style="color: black;">显现</span>柱形图和折线图，<span style="color: black;">运用</span>2016<span style="color: black;">或</span>2013是非常方便的，看下<span style="color: black;">详细</span><span style="color: black;">过程</span>：</span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><img src="https://mmbiz.qpic.cn/mmbiz_gif/k6kCsib3eJMwfZM9Qr29ZElE6untJAnUaZfwQiapsgVyJquicCVOEIl6JicFvlYq59BJL2TJsfRszkyQjk9kubefvA/640?tp=webp&amp;wxfrom=5&amp;wx_lazy=1" style="width: 50%; margin-bottom: 20px;"></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">当然，仅仅<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>为：</span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"><span style="color: black;">选取</span>图表，在图表工具中找到图表样式，<span style="color: black;">选取</span>一个适合的样式，以黑色背景这个为例：</span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"><img src="https://mmbiz.qpic.cn/mmbiz_png/k6kCsib3eJMwfZM9Qr29ZElE6untJAnUaw1u7sAQrrEUdAZOtTKtpTBGRGaG3HqXLnBPz89Yxduib6HqoyKm4U5w/640?tp=webp&amp;wxfrom=5&amp;wx_lazy=1&amp;wx_co=1" style="width: 50%; margin-bottom: 20px;"></span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">接下来<span style="color: black;">选取</span>一个系列，单击右键，设置数据系列格式：</span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"><img src="https://mmbiz.qpic.cn/mmbiz_png/k6kCsib3eJMwfZM9Qr29ZElE6untJAnUa2VNuY7KriayhZEy2a7yd2AvRh1sBDicGOibu7icuC4jR36xnKVnOia07NFA/640?tp=webp&amp;wxfrom=5&amp;wx_lazy=1&amp;wx_co=1" style="width: 50%; margin-bottom: 20px;"></span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">设置填充色，在方向设置中<span style="color: black;">选取</span>线性向左：</span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"><img src="https://mmbiz.qpic.cn/mmbiz_png/k6kCsib3eJMwfZM9Qr29ZElE6untJAnUatWmdn0PbbLWP07IaveWHW10eNaFBMZdib9LednXUpbiawGXqcB9pJibOA/640?tp=webp&amp;wxfrom=5&amp;wx_lazy=1&amp;wx_co=1" style="width: 50%; margin-bottom: 20px;"></span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><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;"><img src="https://mmbiz.qpic.cn/mmbiz_png/k6kCsib3eJMwfZM9Qr29ZElE6untJAnUaGicsn9Bib0rY5xZmTMxtmLjEWHYPFrfjEUicxUyn5G1X9NxpmXZoLiaKNQ/640?tp=webp&amp;wxfrom=5&amp;wx_lazy=1&amp;wx_co=1" style="width: 50%; margin-bottom: 20px;"></span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"><span style="color: black;">最少</span>需要四个颜色点，最左边和最右边的都<span style="color: black;">选取</span>深色，中间的一个<span style="color: black;">选取</span>浅色，靠右的<span style="color: black;">选取</span>白色，完成后的效果为：&nbsp;</span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"><img src="https://mmbiz.qpic.cn/mmbiz_png/k6kCsib3eJMwfZM9Qr29ZElE6untJAnUajXOdbmAmbfDWyvqy6jX0W1m2BPgfHH3Gy8E7QIibajjlv3roSYQ8pRg/640?tp=webp&amp;wxfrom=5&amp;wx_lazy=1&amp;wx_co=1" style="width: 50%; margin-bottom: 20px;"></span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">计划值这个系列<span style="color: black;">已然</span>有了立体效果，用<span style="color: black;">一样</span>的<span style="color: black;">办法</span>，对<span style="color: black;">实质</span>值这个系列进行设置：</span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"><img src="https://mmbiz.qpic.cn/mmbiz_png/k6kCsib3eJMwfZM9Qr29ZElE6untJAnUaUmg0MDsuPqicuRKRekicceY4A86nHTbo1lcoudtj5FCiaAerwm1DyJeow/640?tp=webp&amp;wxfrom=5&amp;wx_lazy=1&amp;wx_co=1" style="width: 50%; margin-bottom: 20px;"></span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">接下来<span style="color: black;">咱们</span>还需要设置一个动态变化的图表标题，这个设置<span style="color: black;">办法</span>看一下动画演示吧：</span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><img src="data:image/svg+xml,%3C%3Fxml version=1.0 encoding=UTF-8%3F%3E%3Csvg width=1px height=1px viewBox=0 0 1 1 version=1.1 xmlns=http://www.w3.org/2000/svg xmlns:xlink=http://www.w3.org/1999/xlink%3E%3Ctitle%3E%3C/title%3E%3Cg stroke=none stroke-width=1 fill=none fill-rule=evenodd fill-opacity=0%3E%3Cg transform=translate(-249.000000, -126.000000) fill=%23FFFFFF%3E%3Crect x=249 y=126 width=1 height=1%3E%3C/rect%3E%3C/g%3E%3C/g%3E%3C/svg%3E" style="width: 50%; margin-bottom: 20px;"></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">到这一步图表基本就完<span style="color: black;">成为了</span>，最后把控件选项设置为置顶<span style="color: black;">表示</span>：</span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"><img src="data:image/svg+xml,%3C%3Fxml version=1.0 encoding=UTF-8%3F%3E%3Csvg width=1px height=1px viewBox=0 0 1 1 version=1.1 xmlns=http://www.w3.org/2000/svg xmlns:xlink=http://www.w3.org/1999/xlink%3E%3Ctitle%3E%3C/title%3E%3Cg stroke=none stroke-width=1 fill=none fill-rule=evenodd fill-opacity=0%3E%3Cg transform=translate(-249.000000, -126.000000) fill=%23FFFFFF%3E%3Crect x=249 y=126 width=1 height=1%3E%3C/rect%3E%3C/g%3E%3C/g%3E%3C/svg%3E" style="width: 50%; margin-bottom: 20px;"></span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">再拖放到合适的位置就完<span style="color: black;">成为了</span>图表的<span style="color: black;">最后</span>效果。</span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><img src="data:image/svg+xml,%3C%3Fxml version=1.0 encoding=UTF-8%3F%3E%3Csvg width=1px height=1px viewBox=0 0 1 1 version=1.1 xmlns=http://www.w3.org/2000/svg xmlns:xlink=http://www.w3.org/1999/xlink%3E%3Ctitle%3E%3C/title%3E%3Cg stroke=none stroke-width=1 fill=none fill-rule=evenodd fill-opacity=0%3E%3Cg transform=translate(-249.000000, -126.000000) fill=%23FFFFFF%3E%3Crect x=249 y=126 width=1 height=1%3E%3C/rect%3E%3C/g%3E%3C/g%3E%3C/svg%3E" style="width: 50%; margin-bottom: 20px;"></p>扫一扫添加老师<span style="color: black;">微X</span>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><img src="data:image/svg+xml,%3C%3Fxml version=1.0 encoding=UTF-8%3F%3E%3Csvg width=1px height=1px viewBox=0 0 1 1 version=1.1 xmlns=http://www.w3.org/2000/svg xmlns:xlink=http://www.w3.org/1999/xlink%3E%3Ctitle%3E%3C/title%3E%3Cg stroke=none stroke-width=1 fill=none fill-rule=evenodd fill-opacity=0%3E%3Cg transform=translate(-249.000000, -126.000000) fill=%23FFFFFF%3E%3Crect x=249 y=126 width=1 height=1%3E%3C/rect%3E%3C/g%3E%3C/g%3E%3C/svg%3E" style="width: 50%; margin-bottom: 20px;"></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">在线咨询Excel课程</span></p><img src="data:image/svg+xml,%3C%3Fxml version=1.0 encoding=UTF-8%3F%3E%3Csvg width=1px height=1px viewBox=0 0 1 1 version=1.1 xmlns=http://www.w3.org/2000/svg xmlns:xlink=http://www.w3.org/1999/xlink%3E%3Ctitle%3E%3C/title%3E%3Cg stroke=none stroke-width=1 fill=none fill-rule=evenodd fill-opacity=0%3E%3Cg transform=translate(-249.000000, -126.000000) fill=%23FFFFFF%3E%3Crect x=249 y=126 width=1 height=1%3E%3C/rect%3E%3C/g%3E%3C/g%3E%3C/svg%3E" style="width: 50%; margin-bottom: 20px;">
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><strong style="color: blue;">Excel教程<span style="color: black;">关联</span><span style="color: black;">举荐</span></strong></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"><a style="color: black;">拒绝千篇一律！让老板看一眼就心动的Excel图表~</a></span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><a style="color: black;"><span style="color: black;"><span style="color: black;">为何</span><span style="color: black;">意见</span>你用数据透视图制作走势图表？这是我见过最好</span></a>的答案！</p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><a style="color: black;"><span style="color: black;">Excel教程：想做动态<span style="color: black;">查找</span><span style="color: black;">名单</span>？这个<span style="color: black;">办法</span>最简便！</span></a></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><a style="color: black;"><span style="color: black;">2021年最新个税计算公式出炉！一秒完成上万条数据的整理输出！</span></a></p><strong style="color: blue;"><span style="color: black;">想要全面系统学习Excel，不妨关注部落窝教育的《<span style="color: black;">1星期</span>Excel直通车》视频课<span style="color: black;">或</span>《Excel极速贯通班》。</span></strong>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"><strong style="color: blue;">《<span style="color: black;">1星期</span>Excel直通车》</strong></span>视频课</p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"><span style="color: black;">包括</span>Excel技巧、函数公式、</span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><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></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">最实用接地气的Excel视频课</span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"><strong style="color: blue;"><span style="color: black;">《<span style="color: black;">1星期</span>Excel直通车》</span></strong></span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"><strong style="color: blue;"><span style="color: black;">风趣易懂，快速<span style="color: black;">有效</span>，</span></strong></span><span style="color: black;"><strong style="color: blue;"><span style="color: black;">带您7天学会Excel</span></strong></span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"><strong style="color: blue;">38&nbsp;</strong></span><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;"><strong style="color: blue;"><span style="color: black;"><strong style="color: blue;"><span style="color: black;"><strong style="color: blue;"><span style="color: black;"><strong style="color: blue;"><span style="color: black;"><strong style="color: blue;"><span style="color: black;">（已更新完毕，可永久学习）</span></strong></span></strong></span></strong></span></strong></span></strong></span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><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;"><strong style="color: blue;"><span style="color: black;">主讲老师：&nbsp;滴答</span></strong></span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><img src="data:image/svg+xml,%3C%3Fxml version=1.0 encoding=UTF-8%3F%3E%3Csvg width=1px height=1px viewBox=0 0 1 1 version=1.1 xmlns=http://www.w3.org/2000/svg xmlns:xlink=http://www.w3.org/1999/xlink%3E%3Ctitle%3E%3C/title%3E%3Cg stroke=none stroke-width=1 fill=none fill-rule=evenodd fill-opacity=0%3E%3Cg transform=translate(-249.000000, -126.000000) fill=%23FFFFFF%3E%3Crect x=249 y=126 width=1 height=1%3E%3C/rect%3E%3C/g%3E%3C/g%3E%3C/svg%3E" style="width: 50%; margin-bottom: 20px;"></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">Excel技术大神，资深培训师；</span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">课程粉丝100万+；</span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"><span style="color: black;">研发</span>有《Excel小白脱白系列课》</span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">《Excel极速贯通班》。</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;">299元</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 style="color: black;"><strong style="color: blue;"><span style="color: black;"><strong style="color: blue;"><span style="color: black;"><strong style="color: blue;"><span style="color: black;">9</span></strong></span></strong><strong style="color: blue;"><span style="color: black;">9</span></strong></span></strong></span></span><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></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">就能习得受用<span style="color: black;">一辈子</span>的Excel职场技能！</span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"><strong style="color: blue;"><span style="color: black;">&nbsp; 长按下面二维码立即购买学习</span></strong></span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><img src="data:image/svg+xml,%3C%3Fxml version=1.0 encoding=UTF-8%3F%3E%3Csvg width=1px height=1px viewBox=0 0 1 1 version=1.1 xmlns=http://www.w3.org/2000/svg xmlns:xlink=http://www.w3.org/1999/xlink%3E%3Ctitle%3E%3C/title%3E%3Cg stroke=none stroke-width=1 fill=none fill-rule=evenodd fill-opacity=0%3E%3Cg transform=translate(-249.000000, -126.000000) fill=%23FFFFFF%3E%3Crect x=249 y=126 width=1 height=1%3E%3C/rect%3E%3C/g%3E%3C/g%3E%3C/svg%3E" style="width: 50%; margin-bottom: 20px;"></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">购课后，加客服<span style="color: black;">微X</span>：blwjymx2领取练习课件</span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><strong style="color: blue;"><span style="color: black;"><img src="data:image/svg+xml,%3C%3Fxml version=1.0 encoding=UTF-8%3F%3E%3Csvg width=1px height=1px viewBox=0 0 1 1 version=1.1 xmlns=http://www.w3.org/2000/svg xmlns:xlink=http://www.w3.org/1999/xlink%3E%3Ctitle%3E%3C/title%3E%3Cg stroke=none stroke-width=1 fill=none fill-rule=evenodd fill-opacity=0%3E%3Cg transform=translate(-249.000000, -126.000000) fill=%23FFFFFF%3E%3Crect x=249 y=126 width=1 height=1%3E%3C/rect%3E%3C/g%3E%3C/g%3E%3C/svg%3E" style="width: 50%; margin-bottom: 20px;"></span></strong></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">让工作提速百倍的「Excel极速贯通班」</span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">↓&nbsp;点击<span style="color: black;"><strong style="color: blue;"><span style="color: black;">阅读原文</span></strong></span>，可免费试听。</span></p>

4zhvml8 发表于 2024-10-31 03:43:50

外链论坛的成功举办，是与各位领导、同仁们的关怀和支持分不开的。在此，我谨代表公司向关心和支持论坛的各界人士表示最衷心的感谢！

查看完整版本: Excel教程：牛x！给老板看的报表就用动态图表！