Excel Power Pivot 简明教程

Excel Power Pivot Tutorial

Excel Power Pivot 是一款高效的强大工具，作为加载项附带于 Excel。借助 Power Pivot，您可以从外部源加载数亿行数据，并通过它功能强大的 xVelocity 引擎高效地管理数据，这是一种高度压缩的形式。这使得执行计算、分析数据并最终形成报表以得出结论和决策成为可能。

Excel Power Pivot is an efficient, powerful tool that comes with Excel as an Add-in. With Power Pivot, you can load hundreds of millions of rows of data from external sources and manage the data effectively with its powerful xVelocity engine in a highly compressed form. This makes it possible to perform the calculations, analyze the data, and arrive at a report to draw conclusions and decisions.

Audience

本指南针对具有 Excel 实践经验的专业人士，以便他们在几分钟内执行高端数据分析和决策制定。

This guide targets professionals with hands-on experience with Excel, to perform the highend data analysis and decision making in a matter of few minutes.

Prerequisites

在您继续本教程之前，我们假设您已经了解 Excel 的基础知识。如果您不了解这些概念，那么我们建议您阅读我们有关 Excel 图表和 MS Access 的简短教程。

Before you proceed with this tutorial, we are assuming that you are already aware about the basics of Excel. If you are not well aware of these concepts, then we will suggest you to go through our short tutorials on Excel charts and MS Access.