Brilliant Microsoft Excel 2007: formulas and functions
- ISBN-10
- 0273714066
- ISBN-13
- 9780273714064
- Series
- Brilliant Microsoft Excel 2007
- Category
- Business
- Pages
- 523
- Language
- English
- Published
- 2007-12
- Publisher
- Pearson Education
- Author
- Paul McFedries
Description
Pivot tables are the most powerful feature in Excel. A basic pivot table will allow you to summarize 500,000 rows of transactional data in 30 seconds with just a few mouse clicks. Business productivity would skyrocket if everyone knew how to use pivot tables. However, only 12% of people using Excel can create a basic pivot table. Of this group only a small percentage actually harness all the power that pivot tables afford them. By the end of the book, users will be pivot table gurus automating pivot tables using VBA, creating pivot tables with external data in OLAP cubes, and even creating dynamic reporting systems so that managers can answer their own queries with a few mouse clicks. Throughout the book there are no-nonsense, step-by-step tutorials and lots of practical examples aimed directly at business users.
Get the book
Other editions
Similar books
-
The Pearson Custom Program for Montgomery College CA 120 Introduction to Computer Applications
By Mary Anne Poatsy, Keith Mulbery, Cynthia KrebsThe Pearson Custom Program for Montgomery College CA 120 Introduction to Computer Applications
-
Business Dynamics
By Karen IversenClass Arrivals Mail Room Sorted for Distribution by Date ON THE JOB Eleanor and Lane Brooks 42 Camway Court Salinas , CA 92123 October 15 , 19xx Summarize the contents of this document : General Manager Class Arrivals 1453 Mission ...
-
All-in-one Business Contractbook, 1990: Key Contact Numbers for 10,000 Leading U.S. Businesses
By Karen HillAll-in-one Business Contractbook, 1990: Key Contact Numbers for 10,000 Leading U.S. Businesses
-
把握e时代: 商务, 信息, 技术
By 达文波特, Thomas H. Davenport, Laurence Prusak本书循序渐进地向读者描述了信息世界的方方面面,展示了如何发展一种全方面的信息化企业经营战略。
-
Test Critiques
By Daniel J. KeyserDaniel J. Keyser Richard C. Sweetland. DMI Mathematics Systems Instructional Objectives Inventory Delwyn L. Harnisch , Ph.D. 149 Doren Diagnostic Reading Test of Word Recognition Skills Kenneth J. Smith , Ph.D. and Darrell L. Sabers ...
-
Microsoft Office Excel 2003 - Illustrated Complete
By Elizabeth Eisner Reding, Lynn WermersFIGURE M - 5 : Imported Access table Microsoft Excel - Book1 | X File Edit View Insert Format Tools Data Window ... UT Priscilla Gomez 801-538-7789 839 1322 10 NationBuilder Bank Ogden UT Alex Hart 801-733-9877 534 1699 11 Earthwise ...
-
West Federal Taxation: Corporations, Partnerships, Estates and Trusts
By William A. Raabe, David M. Maloney, William H. HoffmanSome fringe benefits ( e.g. , accident and health plans , group term life insurance ) may be excluded from the employee's gross income and thus are not subject to the Federal income tax . Functional currency .
-
Introduction to Business: Opening Doors
By William F. Schoell, Gary Dessler, John A. ReineckeFocusing on building students' business vocabulary and skills, the new edition of this text provides coverage of such relevant issues as career choices, the global business environment, ethics, multicultural workforce management and small ...
-
Introduction to Business: A Contemporary View
By William F. Schoell, John A. ReineckeIntroduction to Business: A Contemporary View
-
Introduction to Business: A Contemporary View
By William F. Schoell, John A. ReineckeIntroduction to Business: A Contemporary View