4lqedz 发表于 2024-10-1 09:39:53

怎么样用Excel分析数据：数据透视表指南（附视频）


    <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;"><span style="color: black;"><strong style="color: blue;">用例简介</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>将创建一个数据透视表，对服装<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;"><strong style="color: blue;">创建格式化表格</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>从服装<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>表格-&gt;“首页”选项卡-&gt;“格式化为表格模板”。</span></p>
    <h1 style="color: black; text-align: left; margin-bottom: 10px;"><span style="color: black;"><strong style="color: blue;">创建透视表</strong></span></h1>
    <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>
    <h1 style="color: black; text-align: left; margin-bottom: 10px;"><span style="color: black;"><strong style="color: blue;">添加和扩展字段中的数据</strong></span></h1><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 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>在“列”区域。</span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">将“颜色”添加到“筛选”区域以按颜色筛选。</span></p><span style="color: black;">将“单价”放入“值”区域，并<span style="color: black;">选取</span>所需的计算<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 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></p>
    <h1 style="color: black; text-align: left; margin-bottom: 10px;"><span style="color: black;"><strong style="color: blue;">应用数值格式</strong></span></h1>
    <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;">在“数值”区域内右键单击任何单元格，<span style="color: black;">选取</span>“字段设置”</span></p><span style="color: black;"><span style="color: black;">选取</span>其中一种呈现的数值格式：</span>
    <h1 style="color: black; text-align: left; margin-bottom: 10px;"><span style="color: black;"><strong style="color: blue;">计算 - 更改值设置</strong></span></h1>
    <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></p>
    <h1 style="color: black; text-align: left; margin-bottom: 10px;"><span style="color: black;"><strong style="color: blue;">更改外观和布局</strong></span></h1>
    <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;">打开“报表布局”，在紧凑、大纲或表格布局之间进行<span style="color: black;">选取</span>。</span></p><span style="color: black;">禁用和自定义小计和总计的<span style="color: black;">表示</span>，以<span style="color: black;">供给</span>额外的背景信息或简化视图。</span>
    <h1 style="color: black; text-align: left; margin-bottom: 10px;"><span style="color: black;"><strong style="color: blue;">应用排序、过滤器和切片器</strong></span></h1><span style="color: black;">利用过滤和排序选项或切片器，能够分析数据透视表，从而<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 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></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;">在“筛选器”板块添加一个字段，用于<span style="color: black;">咱们</span>想要执行的附加过滤</span></p><span style="color: black;">打开“<span style="color: black;">插进</span>”选项卡，点击“切片器”选项，<span style="color: black;">选取</span><span style="color: black;">期盼</span>的字段数量。</span>
    <h1 style="color: black; text-align: left; margin-bottom: 10px;"><span style="color: black;"><strong style="color: blue;">添加或扩展数据源&nbsp;</strong></span></h1>
    <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;"><span style="color: black;"><strong style="color: blue;">参与培训课程</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>学会了<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><a style="color: black;"><span style="color: black;">培训课程</span></a><span style="color: black;">。扫码下方二维码，<span style="color: black;">选取</span>您想要学习的内容并发送请求：</span></p><span style="color: black;"><strong style="color: blue;"><span style="color: black;">获取培训课程</span></strong></span>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"><strong style="color: blue;">获取 ONLYOFFICE 协作空间 2.5</strong></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;">云端版 ONLYOFFICE 协作空间</span></a><span style="color: black;">已支持最新版本，立即登录尝试所有新功能。<span style="color: black;">倘若</span>您刚接触 ONLYOFFICE 协作空间，<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><a style="color: black;"><span style="color: black;">自托管 ONLYOFFICE 协作空间</span></a></p>
    <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;"><strong style="color: blue;"><span style="color: black;">关联</span>链接</strong></span></p><a style="color: black;"><span style="color: black;"><span style="color: black;">认识</span>培训课程</span></a><strong style="color: blue;"><span style="color: black;">获取&nbsp;ONLYOFFICE&nbsp;协作空间</span></strong><span style="color: black;">云端版：</span><span style="color: black;">https://www.onlyoffice.com/zh/docspace-registration.aspx</span><span style="color: black;">企业版：</span><span style="color: black;">https://www.onlyoffice.com/zh/docspace-enterprise.aspxONLYOFFICE</span><span style="color: black;"><span style="color: black;">认识</span>&nbsp;<span style="color: black;">ONLYOFFICE</span>协作空间：</span><a style="color: black;"><span style="color: black;">云端专业版</span></a><span style="color: black;">&nbsp;/&nbsp;</span><a style="color: black;"><span style="color: black;">本地<span style="color: black;">安排</span>企业版</span></a>&nbsp;/&nbsp;<a style="color: black;"><span style="color: black;">2.5 视频介绍与教程</span></a>




wrjc1hod 发表于 2024-10-12 23:31:19

感谢楼主分享，祝愿外链论坛越办越好！
页: [1]
查看完整版本: 怎么样用Excel分析数据：数据透视表指南（附视频）