Top Menu

Tag Archives | PowerPivot

New PivotTables and PowerPivot Courses

We are happy to announce the addition of two new courses all about PowerPivot and PivotTables. These courses are specifically aimed at Microsoft Excel 2013 and 2010 users and are titled Using PivotTables & PowerPivot.

These are a new one-day courses written by Chris Page and they teach you how to get the best from Excel’s PivotTables. It also looks at how to use PowerPivot, which is the add-in now included with Microsoft Excel 2013 and the free-add-in for Excel 2010 that can be downloaded from Microsoft.  PowerPivot is a fantastic tool for working with large sets of data and helps you get the best business intelligence information to help you know what is happening in your business.

Read more about the Excel 2013 Using PivotTables & PowerPivot course here…

Read more about the Excel 2010 Using PivotTables & PowerPivot course here…

Create a memory-efficient Data Model using Excel 2013 and the PowerPivot add-in

In Excel 2013, you can create data models containing millions of rows, and then perform powerful data analysis against these models. Data models can be created with or without the PowerPivot add-in to support any number of Pivot Tables, Pivot Charts, and Power View visualizations in the same workbook.

The data models can contain a huge amount of data that can use up computer memory which in turn could affect other programs that use the same system resources. If you use any Office or Excel online cloud applications, files are limited to 10MB which can be reached very quickly.

There is a good article here to read at on Microsoft’s Office Support website that will explain what you can do in detail.

You could also download and run Microsoft’s Workbook Size Optimizer. It analyses your Excel workbook and if possible, compresses it further.