Pivot table data crunching for Microsoft Office Excel 2007.0789736012 Pivot table See multidimensional views. data crunching for Microsoft Office Microsoft's primary desktop applications for Windows and Mac. Depending on the package, it includes some combination of Word, Excel, PowerPoint, Access and Outlook along with various Internet and other utilities. Excel 2007. Jelen, Bill and Michael Alexander Michael Charles Alexander, (November 20 1920 – December 19 2004), was a British Captain in the Special Boat Service, and a German Army Prisoner of War held captive at Oflag IV-C. . Que Publishing 2007 338 pages $29.99 Paperback HF5548 Focusing on day-to-day problems, this tutorial gets readers started on creating basic pivot tables within the first two chapters. The authors, who bring with them years of expertise as practitioners and developers, offer a range of recipes, summary report formats and such features as dynamic charts, with emphasis on decision-making support and ease of use by managers and other non-experts. They cover the fundamentals of using pivot tables to make decisions, creating and customizing pivot tables, controlling views, performing calculations within tables, using pivot charts and other visualizations, capturing and analyzing disparate data sources, sharing pivot tables, working with and analyzing OLAP (OnLine Analytical Processing) Decision support software that allows the user to quickly analyze information that has been summarized into multidimensional views and hierarchies. OLAP tools are used to perform trend analysis on sales and financial information. data, building macros, using VBA (Visual Basic for Applications) A subset of Visual Basic that provides a common language for customizing Microsoft applications. VBA supports COM, which allows a VBA script to invoke internal functions within Excel, Word and other COM-based programs or to make use of , and solving common pivot table issues and questions. The index is very helpful, especially when troubleshooting, and the authors provide a guide to finding pivot table commands on the new ribbon interface. Designed for intermediate Excel users. ([c]20072005 Book News, Inc., Portland, OR) |
|
||||||||||||||
Printer friendly
Cite/link
Email
Feedback
Reader Opinion