Pivot Table Data Crunching

Сборник

За особеностите на екземпляра

Състояние:: Отлично
Забележка:: Неупотребяван екземпляр.
Език:: Английски
Наличност:: 1 бр.

За изданието

Издателство:: MrExcel Products Index and Michael Alexander
Град на издаване:: Indianapolis
Година:: 2006 г.
Език:: Английски
Страници:: 274
Корици:: Меки
Поредици и библиотеки:: Business Solutions
Категория:: Компютри, софтуер, интернет

"Summarize 60,000 rows of data in seconds! " The functionality behind pivot tables was actually invented by folks at the Lotus Advanced Technology Group in the late 1980s. Originally available only for Steve Job's NeXT computer, the technology became widely available in 1992 with the release of Improv. During Microsoft's bitter battle with Lotus for spreadsheet supremacy, the concept was added to Excel's data menu. Not many people understand how to actually make use of pivot tables. As a data analyst in 1992, Bill Jelen quickly discovered the power behind pivot tables. "It was possible to create summary reports before Pivot Tables, but you had to build complicated DSUM formulas and weave them into an obscure feature called / Data Table 2. It would take an hour and make your head spin. If I ever tried to explain the process to a spreadsheet novice, their eyes would glaze over. It was something that was simply impossible to learn. Once Pivot Tables were added to Excel, anyone who can drag a mouse can create stunning summary reports in seconds.

Ключови думи: Pivot Table Data Crunching, MrExcel Products Index, Business Solutions