Excel Pivot Tables Explained

Aspose.Cells is a .NET component for spreadsheet reporting without using Microsoft Excel. It supports robust formula calculation engine, pivot tables, VBA, workbook encryption, named ranges, spreadsheet formatting, drawing objects like images, OLE objects and importing or creating charts. You can...

Aspose.Cells is a Java component for spreadsheet reporting without using Microsoft Excel. Other features include creating spreadsheets, opening encrypted excel files, macros, VBA, unicode, formula settings, pivot tables, importing data from JDBC ResultSet and support of CSV, SpreadsheetML, PDF...

Pivot Table AutoFormat XL allows you to save pivot table formatting and to use it as a format template for your future pivot tables. Pivot Table AutoFormat XL remembers formatting of each pivot table area: - Page fields area - Row fields area, including subtotals, blank lines and first rows...


Platforms: Windows

Tables Transformer for Excel 2000-2007 will allow you to fast and easy transform current tables to construct pivot ones; to divide one table into several ones or to unite two tables in one. Data transformations for the construction of pivot tables: Microsoft Excel has a powerful and convenient...


Platforms: Windows

This free add-in for Microsoft Excel makes your work with pivot tables comfortable and fast. Pivot Table Helper adds its own toolbar to Excel that allows you to select pivot table areas, set pivot field formatting, add / remove grand totals, clear pivot table formatting and more.Pivot Table...


Platforms: Windows

AutoFormat for Microsoft Excel PivotTables allows you to save pivot table formatting and to use it as a format template for your other pivot tables.AutoFormat for PivotTables remembers formatting of each pivot table area:- Page fields area- Row fields area, including subtotals, blank lines and...


Platforms: Windows

Pivot Table Helper makes working with pivot tables comfortable and fast. Pivot Table Helper adds its own toolbar to Excel with the following buttons: - Select page fields area of the current pivot table - Select header of the current pivot table - Select blank area of the current pivot table...


Platforms: Windows

Synkronizer is a powerful and user friendly Excel tool which compares, updates and merges Excel files/tables. Synkronizer performs the following functions: 1. update Excel files 2. highlight differences 3. create difference report 4. show/hide differences Synkronizer recognizes the...


Platforms: Windows, Windows 8, Windows 7

Merge / combine two Excel lists into one based on a common column of data from each list. A wizard makes the "match and join" process fast and easy. No complicated options. Append rows from two unequal tables without tedious copying and pasting.


Platforms: Windows

Business Analysis Tool Desktop is a Business Intelligence software for data visualization and OLAP reporting. You can analyze your data by building pivot tables, charts, treemaps, scatter diagrams, filtering/sorting/searching for patterns, etc. Product features: - Reports are generated...


Platforms: Windows

Aspose.Grid is a set of two different GUI based .NET components to support desktop and web applications. It enables you to import from and export to Excel spreadsheets, DataTable and DataView. Worksheet processing features like worksheet pagination, add/remove worksheets, add/insert/remove rows...


Platforms: Windows

Pivot Table AutoFormat XL allows you to save pivot table formatting and to use it as a format template for your future pivot tables. Pivot Table AutoFormat XL remembers formatting of each pivot table area:- Page fields area- Row fields area, including subtotals, blank lines and first rows- Column...


Platforms: Windows

Java API for reports and crosstab reports ( pivot tables ) with groupings, subtotals, data aggregation. Programatically construct reports and export them in various formats (HTML, XML, Excel, PDF) with minimum effort.


Platforms: Windows, Mac, Linux

OLAP Statistics & Reporting for SharePoint enables you to connect to a SharePoint list, task or calendar and explore data in a multi-dimensional grid, pivot tables, filters, and graph or chart view. You can run this OLAP analysis tool on on each SharePoint list, with its own unique set of fields....


Platforms: Windows

OLAP Statistics & Reporting for Microsoft SharePoint is a powerful and reliable solution designed to enable you to connect to a SharePoint list, task or calendar and explore data in a multi-dimensional grid, pivot tables, filters, graph or chart view. With the capability of complex...


Platforms: Windows

Tools for Excel Tables is a set of tools that will strengthen your Microsoft Excel to manage data bases and huge tables in your spreadsheets. Tools for Excel Tables is an addin that combines the functionalities of Microsoft Excel in order to create more robust functionalities which let you...


Platforms: Windows

NeoNeuro Pivot Table. Free. Automatic Pivot Table shows trends and charts, reveals leaders and outsiders in all parameters like region, product or in any others in one click! Only one mouse click is enough to get trends or pie charts, reveal leaders and outsiders in all parameters like region,...


Platforms: Windows, Windows 8, Windows 7, Windows Server

BASIC COURSE OUTLINE: Advanced Formulas, Advanced Filters, Text To Columns, Importing Text Files Pivot Tables 1, Pivot Tables 2, Pivot Tables 3, Scenarios, Goal Seek, Data Tables and Consolidation, Excel on the WeB, Macros 1, Macros 2 WHY USE US FOR EXCEL TRAINING? Like all our products...


Platforms: Windows, Windows CE

Users, who are looking for an efficient Microsoft Excel File Repair tool to restore data from corrupt or damaged Excel files, can get best Excel file recovery help with SysTools Excel Recovery. MS Excel file repair software is a unique and decent Microsoft Excel file reader tool to reads...


Platforms: Windows

BASIC COURSE OUTLINE: The Fundamentals of Excel, Cut, Copy, Insert, Delete, Paste Special, Custom Formatting, Undo, Redo, Excel Formulas - The least you should know, Useful functions and Paste Function, Calc, Comments, Drawing toolbar, Edit Replace, Delete Clear, Essential Printing, Data...


Platforms: Windows, Windows CE