|
Pivot4U Add-in enhances Microsoft Excel with a new useful feature - editable pivot tables. A pivot table is a data summarization tool that, among other functions, can automatically sort, count, and total the flat data stored in one table or spreadsheet and create a second table displaying the summarized data. For all its advantages, Excel has some limitations. One of them is the missing ability to change the data directly in the data area of a pivot table. The pivot table is linked to the source data, and what you see in the cells of the table are read-only values. But with Pivot4U in place, you can go beyond this limitation and make your pivot table editable.
Let's say, for example, you have a spreadsheet with the plan of sales for some products. The spreadsheet is named "SourceData" and it has the following fields: Region, Color, Month, Sales. You want to change some values in the pivot table generated from the data in this sheet. With Pivot4U, this operation is a breeze to do. Create a pivot table from the data in the "SourceData" sheet, go to the "Add-Ins" tab of Microsoft Excel, select "Pivot4U On" and set the cursor on any cell in the pivot table. Now you can change the value in the cells directly from, say "650" to "830". When the value is changed, all totals are recalculated automatically.
With Pivot4U Add-in in place, all the power of calculations and planning "FROM ABOVE-DOWNWARD" becomes accessible without complex and costly software.

Keywords: Excel, pivot, table, Edit, data, editable, pivottable, tables, addin, add in
|

Click to enlarge
|
Related programs in Business - Office Suites & Tools |
|
FlexSite
Well organized, feature rich HTML authoring tool. Uses split screen to view.
|
|
Mihov ASCII Master
Show ASCII value of any key pressed in decimal or hex!
|
|
Clix-FX XML Flash Menus
Clix-FX Flash XML Menu Templates the easiest way imaginable to create web menus
|
|
CacheBoost Server Edition
Boost performance with system and cache management of Windows.
|
|
CacheBoost Professional Edition
Boost system performance and cache-management of Windows XP, NT, 2000.
|
|
TCS
Trends management program for Data Base data and servers internal data
|
|
Acc Compact
Utility for Microsoft Access database developers and administrators.
|
|
Web Site Robot
Easy to use web site builder with blog, shopping cart, online photo album
|
|
InternetNotePad!
Notepad program that edits directly on your web server!
|
|
Acoustica MP3 Audio Mixer
Mix and record sounds to make your own custom audio creations!
|