nykek5i 发表于 2024-10-2 14:19:38

这么实用的功能，居然非常多表哥表妹都不曾运用过！Excel 2007跨工作表透视案例教程！

<span style="color: black;"><span style="color: black;">点击excel小课堂</span><img src="http://mmbiz.qpic.cn/mmbiz/xT7yN7TENODUPIKsMKdoQwbqBNWQUywCOkrPoF2lDgPERNak9vmYvMCW1VzjZSdtakKbZChnIvW5lqwibOOmnUA/640?tp=webp&amp;wxfrom=5&amp;wx_lazy=1&amp;wx_co=1" style="width: 50%; margin-bottom: 20px;"><span style="color: black;">关注我哟</span></span>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">☀</span>学好excel，<span style="color: black;"><span style="color: black;">加强</span>职业素养</span>，<span style="color: black;"><span style="color: black;">提高</span>职场竞争力</span>，<span style="color: black;">让老板喊着为你涨工资</span>！</p><span style="color: black;">Excel 2007跨工作表透视案例教程</span>
    <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>了吗？可是数据这么多，得复制到啥时候呢，况且excel单个数据工作表的数据<span style="color: black;">是由于</span>行数限制的哦。<span style="color: black;">并不</span>用这么麻烦，一个跨工作表数据透视<span style="color: black;">容易</span>搞定！</span></p><span style="color: black;"><span style="color: black;"><strong style="color: blue;"><span style="color: black;"><span style="color: black;">案例</span></span></strong></span></span><span style="color: black;">数据表格如图中所示，<span style="color: black;">营销</span>明细数据分别放在10月、11月和12月对应的工作表中，今天<span style="color: black;">咱们</span>要做的是<span style="color: black;">怎样</span>跨工作表数据透视出第四季度<span style="color: black;">营销</span><span style="color: black;">状况</span>。</span><span style="color: black;"><img src="http://mmbiz.qpic.cn/mmbiz/GCEv3IwJAIHMOMkZoxJzjLRMycMjZCzQCMKH8JsSD9AqWrvpsvVuTdBhmh9tzx0xxYB3HJK9pNUEt4zqf8y47g/640?wx_fmt=jpeg&amp;tp=webp&amp;wxfrom=5&amp;wx_lazy=1&amp;wx_co=1" style="width: 50%; margin-bottom: 20px;"></span><strong style="color: blue;"><span style="color: black;"><span style="color: black;">StepA</span></span></strong><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>默认的选项中Excel只能<span style="color: black;">选取</span>一个表或数据区域，该怎么办呢？</span><span style="color: black;"><img src="http://mmbiz.qpic.cn/mmbiz/GCEv3IwJAIHMOMkZoxJzjLRMycMjZCzQ9cdvK5icSIhhN1v8NOy27HX2IE2Kicc0Zmjt8CNbY4xFRic8IQZLexYrA/640?wx_fmt=jpeg&amp;tp=webp&amp;wxfrom=5&amp;wx_lazy=1&amp;wx_co=1" style="width: 50%; margin-bottom: 20px;"></span><span style="color: black;"><strong style="color: blue;"><span style="color: black;"><span style="color: black;">StepB</span></span></strong><span style="color: black;">其实2007中还有一个数据透视表和数据透视图向导功能未启用，打开Excel选项设置对话框，切换至自定义选项卡，<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></span><img src="http://mmbiz.qpic.cn/mmbiz/GCEv3IwJAIHMOMkZoxJzjLRMycMjZCzQ6PAoRwaVRQa88HO0adEbKvNG2mDZXVK71s543pRvB8nKbMjpbT0B8A/640?wx_fmt=jpeg&amp;tp=webp&amp;wxfrom=5&amp;wx_lazy=1&amp;wx_co=1" style="width: 50%; margin-bottom: 20px;"><strong style="color: blue;"><span style="color: black;"><span style="color: black;">StepC</span></span></strong><span style="color: black;"><span style="color: black;">能够</span>看到自定义快速工具栏新增了一个数据透视表和数据透视图向导功能，单击该功能。</span><span style="color: black;"><img src="http://mmbiz.qpic.cn/mmbiz/GCEv3IwJAIHMOMkZoxJzjLRMycMjZCzQqmVdMUH59bQam127kBvrRnz6Nyd3bF3IkcFWsdNtuh4G8GzZjwz5ibg/640?wx_fmt=jpeg&amp;tp=webp&amp;wxfrom=5&amp;wx_lazy=1&amp;wx_co=1" style="width: 50%; margin-bottom: 20px;"></span><strong style="color: blue;"><span style="color: black;"><span style="color: black;">StepD</span></span></strong><span style="color: black;"><span style="color: black;">选取</span>多重合并计算数据区域，点击下一步。</span><span style="color: black;"><img src="http://mmbiz.qpic.cn/mmbiz/GCEv3IwJAIHMOMkZoxJzjLRMycMjZCzQY0lkNkGzGkEjHc0vwE80W2Q3uXRpr5obvShVWX5QFd72nZabZeauvA/640?wx_fmt=jpeg&amp;tp=webp&amp;wxfrom=5&amp;wx_lazy=1&amp;wx_co=1" style="width: 50%; margin-bottom: 20px;"></span><span style="color: black;"><strong style="color: blue;"><span style="color: black;"><span style="color: black;">StepE</span></span></strong><span style="color: black;">依次添加各个工作表中相应的数据区域，如图中所示，点击下一步。</span></span><span style="color: black;"><span style="color: black;"><img src="http://mmbiz.qpic.cn/mmbiz/GCEv3IwJAIHMOMkZoxJzjLRMycMjZCzQbmB7wVSTnWZlmOrksbxuY72T1yZWoOE856YmRRjzuUETyokYBrSMYg/640?wx_fmt=jpeg&amp;tp=webp&amp;wxfrom=5&amp;wx_lazy=1&amp;wx_co=1" style="width: 50%; margin-bottom: 20px;"></span></span><span style="color: black;"><span style="color: black;"><strong style="color: blue;"><span style="color: black;"><span style="color: black;">StepE</span></span></strong><span style="color: black;"><span style="color: black;">就可</span>创建如图中所示的各个<span style="color: black;">制品</span>的年度销量汇总了。</span></span></span><span style="color: black;"><span style="color: black;"><img src="http://mmbiz.qpic.cn/mmbiz/GCEv3IwJAIHMOMkZoxJzjLRMycMjZCzQIJypsPMK0hanFtUCCek6clK1DDVjPtOdxe8zRHEiaZHicz2MfXPdMMNg/640?wx_fmt=jpeg&amp;tp=webp&amp;wxfrom=5&amp;wx_lazy=1&amp;wx_co=1" style="width: 50%; margin-bottom: 20px;"></span></span><span style="color: black;"><span style="color: black;">先顶后看年薪百万，<span style="color: black;">倘若</span>帮到了你，帮忙给个好评，这对<span style="color: black;">博主</span>很重要，万分感谢。</span></span><span style="color: black;"><span style="color: black;"><span style="color: black;">关注</span><span style="color: black;">excel小课堂(ID：excel-xiaoketang 长按复制)</span><span style="color: black;"><span style="color: black;">微X</span>号，</span><span style="color: black;">学好excel，<span style="color: black;">加强</span>职业素养，<span style="color: black;">提高</span>职场竞争力，升职加薪<span style="color: black;">再也不</span>是梦！</span></span></span><img src="http://mmbiz.qpic.cn/mmbiz/iaGswicCbWm69Z6SNia7MWIAVvMkvMlMO4TLQ4klf25y4M63aGdCNwSazxPH37vmB7R1cCUa9GDCdlCH49MhHLxsQ/640?wx_fmt=jpeg&amp;tp=webp&amp;wxfrom=5&amp;wx_lazy=1&amp;wx_co=1" style="width: 50%; margin-bottom: 20px;"><img src="http://mmbiz.qpic.cn/mmbiz/GCEv3IwJAIFr8Yr5dbZC0S1I1n6HkuOKuR82opuWxoLRuDqKyG1P82CA3VDCoGYucBPricJJMeCqelb1rUC8o6Q/640?wx_fmt=jpeg&amp;tp=webp&amp;wxfrom=5&amp;wx_lazy=1&amp;wx_co=1" style="width: 50%; margin-bottom: 20px;">




4zhvml8 发表于 7 天前

期待你更多的精彩评论，一起交流学习。
页: [1]
查看完整版本: 这么实用的功能，居然非常多表哥表妹都不曾运用过！Excel 2007跨工作表透视案例教程！