excel数据处理与分析-数据透视表高级筛选
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-qvj2lq49k0/69f6e869f9bd445a8a50e57ba7f6d6ba~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727959841&x-signature=i%2BALEcJQGE63tWs69LtXw73SuHM%3D" style="width: 50%; margin-bottom: 20px;"></div>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><a style="color: black;">视频讲解通道</a></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>用示例来依次讲解这四个筛选功能。</p>
<h1 style="color: black; text-align: left; margin-bottom: 10px;">标签筛选</h1>
<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;"><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://p3-sign.toutiaoimg.com/tos-cn-i-qvj2lq49k0/fc7b1698b72d4480bff707ae27a0fbdf~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727959841&x-signature=X57Vj5ndBmMGHsi3lgR2ADhAr%2FM%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>设置对话框。</p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-qvj2lq49k0/dee387474d1043b58c22835982be609b~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727959841&x-signature=Bb2NPrL%2FGOODt4UBD9PaBScs9kk%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>有一个提示：</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>筛选的结果是两个字，就输入两个问号；</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>的数据都筛选出来。</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>。Excel就会将“洗”开头的三个字的数据筛选出来。</p>
<h1 style="color: black; text-align: left; margin-bottom: 10px;">值筛选</h1>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">值筛选针对的是值字段里的数据筛选，无论是行标签还列标签旁的筛选按钮都有值筛选选项。</p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-qvj2lq49k0/fd869a9415ba41e3af2fb1ce8155bd42~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727959841&x-signature=RgjIq8OnVGOv8NavOYKzYl8ImXM%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>输入1000，<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-qvj2lq49k0/ddc621270d6a4255b01d4a12daf9157a~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727959841&x-signature=16BOkcvhH3zFbcOXVaw5l6CWOD0%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>excel进行的<span style="color: black;">便是</span>月付款字段汇总数据的筛选。</p>
<h1 style="color: black; text-align: left; margin-bottom: 10px;">日期筛选</h1>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">日期筛选针对的是日期数据的筛选。</p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-qvj2lq49k0/5cc54a9b1f774fc680f5cad4d782be3c~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727959841&x-signature=2%2FLjax22T9FAuqtxfTXs76XxGA4%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>看到针对日期类型的数据，excel内置了许多筛选<span style="color: black;">要求</span>，<span style="color: black;">选取</span>你要判断的<span style="color: black;">要求</span>，excel就会完成筛选。</p>
<h1 style="color: black; text-align: left; margin-bottom: 10px;">自定义筛选</h1>
<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>。</p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-qvj2lq49k0/06fe78bd56064585a05222c56e32ac60~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727959841&x-signature=5aDPks9u6BXtEffV4%2BELKCbigXg%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>直接按住CTRL键<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-qvj2lq49k0/b00351d81a90444484c93e4a331e1253~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727959841&x-signature=VXfR4m%2B29KDv%2BT3IPlNH7UpCLuE%3D" style="width: 50%; margin-bottom: 20px;"></div>
可以发布外链的网站 http://www.fok120.com/
页:
[1]