数据透视表仔细教育视频，一个视频教会你用数据透视表
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">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>介绍怎么在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 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>的数据表去做一个数据透视表。</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>对应的<span style="color: black;">营销</span>数据。看一下怎么样去做<span style="color: black;">这般</span>一张数据透视表。</p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-axegupay5k/dfb7505e351e4e51ac9bc8a52d784898~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727977014&x-signature=Ae4PwUaJaxiC59QjGZJTkwLWoWk%3D" 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>，找到<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;">·<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>遇到这种<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>数据透视的制作。</p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p26-sign.toutiaoimg.com/tos-cn-i-dtbei8xehn/cdb32758f9054a32a026917c4a786562~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727977014&x-signature=zvixuhaHaZuxtxdllSC5HVk0f0c%3D" 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>
<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>下，<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://p3-sign.toutiaoimg.com/tos-cn-i-dtbei8xehn/17c161eb94674b4db6c385f42496aad4~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727977014&x-signature=aos8Mi0XNlkBFO09A%2BKn7Ug6K0A%3D" 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><span style="color: black;">第1</span>个默认选项，<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;">·第二个<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>了。</p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-dtbei8xehn/51555ba70d3a4c318b1e73b2043030dc~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727977014&x-signature=yB0kRK5d4GnqX9m0q4zNBJag2gs%3D" 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>会<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://p3-sign.toutiaoimg.com/tos-cn-i-dtbei8xehn/c4a35940305845959c8fc8cbf22f2233~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727977014&x-signature=k%2BIH7%2BafhCnXcireaL95EyvUY2w%3D" 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><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>日期的加一个数据。</p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p26-sign.toutiaoimg.com/tos-cn-i-dtbei8xehn/5cf247da44f44aae83b51c5c01951f0d~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727977014&x-signature=ws93VmKhkI325oH1wUcZ7kSWbJk%3D" 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>了多少的金额，有多少收入，这个是在值<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>来。</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>点一下刷新，<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://p3-sign.toutiaoimg.com/tos-cn-i-dtbei8xehn/ade923bcc840427aa95241948f8de8ec~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727977014&x-signature=ngrKJATMKGLzI6seZPjUSKavAfs%3D" 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>，<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>月<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>数据透视表。</p>
页:
[1]