Share via


Powerful New Excel Capabilities Make both Engineers and Auditors Happy

Almost every technical and business professional will agree—Excel is their favorite tool.

Its ease of use combined with its ever-increasing robust calculation capabilities makes it a powerful tool for developing fast, accurate technical applications, and for managing and analyzing huge volumes of data.

Professional people love Excel. However, at an enterprise level, corporate management and auditors have had a few issues with it—namely accountability and auditing.

While managers and auditors fully appreciate Excel’s capabilities and understand why it is so widely used, they can’t really go to a regulatory organization or their shareholders and say, “Our reserve estimates—or production profiles or well plan or EOR projections—are based on a spreadsheet that ‘John Q. Professional’ maintains on his desktop.”

SharePoint Excel Services helps address these enterprise challenges by allowing the application of revision controls to manage the changes of a spreadsheet in a controlled, auditable manner. The “official” version of the spreadsheet is hosted in the SharePoint environment, but can be used by people across the enterprise.

With SharePoint 2010, Excel 2010 and PowerPivot—a new add-in that delivers unmatched computational power within Excel 2010—both auditors and engineers will have more to be happy about.

SharePoint 2010 offers a Web-based central administration interface that offers improved productivity and greater control with more flexible deployments.

PowerPivot takes advantage of familiar Excel tools and features and lets users process massive amounts of data in seconds, load even the largest data sets from virtually any source, and delivers powerful new analytical capabilities.

It also lets you make the most of that multi-core processor and those gigabytes of memory.

For more information on PowerPivot, check out the videos at https://www.powerpivot.com/videos.aspx.