Become a savvy Microsoft Excel user. Pivot tables are a great feature in Excel that help you organize and analyze data, but not many Excel users know how to use pivot tables. Pivot Table Data Crunching offers a comprehensive review of all the functionalities of Pivot Tables from author Bill Jelen, otherwise known as Mr. Excel from www.mrexcel.com, and Michael Alexander, a Microsoft Certified Application Developer. The authors' practical scenarios and real-world advice demonstrate the benefits of Pivot Tables and how to avoid the common pitfalls of every day data crunching. Each solution presented in the book can be accomplished with resources available in the Excel interface, making Pivot Table Data Crunching a beneficial resource for all levels of Excel users.
Le informazioni nella sezione "Riassunto" possono far riferimento a edizioni diverse di questo titolo.
Descrizione libro Que Publishing, 2005. Condizione libro: New. Brand New, Unread Copy in Perfect Condition. A+ Customer Service! Summary: Introduction. 1. Pivot Table Fundamentals. What Is a Pivot Table? Why Should You Use a Pivot Table? When Should You Use a Pivot Table? The Anatomy of a Pivot Table Data Area Row Area Column Area Page Area Pivot Tables Behind the Scenes Limitations of Pivot Table Reports Next Steps 2. Creating a Basic Pivot Table. Preparing Your Data for Pivot Table Reporting Ensure Your Data Is in a Tabular Layout Use Unique Headings That Occupy Only a Single Row of Data Avoid Storing Data in Section Headings Avoid Repeating Groups as Columns Eliminate Gaps and Blank Cells in Your Data Source Apply Appropriate Type Formatting to Your Fields Summary of Good Data Source Design Cleaning Up Data for Pivot Table Analysis Creating a Basic Pivot Table Introduction to the PivotTable Wizard Drag Fields to the Report Adding Fields to the Pivot Table Rearranging the Pivot Table Revenue by Market and Model Watch the Mouse Pointer to Learn Where You Are Dropping a Field Redisplay the Pivot Table Field List Redisplay the Pivot Table Toolbar Activate the PivotTable Wizard Keeping Up with Changes in Your Data Source Changes Have Been Made to Your Existing Data Source Your Data Source's Range Has Been Expanded with the Addition of Rows or Columns Next Steps 3. Customizing Fields in a Pivot Table. The Need to Customize Displaying the PivotTable Field Dialog Box Customizing Field Names Applying Numeric Formats to Data Fields Changing Summary Calculations One Blank Cell Causes a Count Using Functions Other Than Count or Sum Adding and Removing Subtotals Suppress Subtotals When You Have Many Row Fields Adding Multiple Subtotals for One Field Using Running Total Options Display Change from Year to Year with Difference From How Much Does Each Line of Business Contribute to the Total? Seasonality Reports Revenue by Line of Business Report Next Steps 4. Formatting Your Pivot Table Report. Using AutoFormat Applying Your Own Style Setting Table Options Grand Totals for Columns Grand Totals for Rows AutoFormat Table Subtotal Hidden Page Items Merged Labels Preserve Formatting Repeat Item Labels on Each Printed Page Mark Totals with * Page Layout For Error Values Show For Empty Cells Show Set Print Titles Formatting a Pivot Table Next Steps 5. Controlling the Way You View Your Pivot Data. Showing and Hiding Options The Basics of Hiding an Item Showing All Items Again Showing or Hiding Most Items Hiding or Showing Items Without Data Hiding or Showing Items in a Page Field Showing or Hiding Items in a Data Field Sorting in a Pivot Table Sorting Using the Advanced Options Dialog Box Note the Effect of Layout Changes on AutoSort Sorting Using the Manual Method Sorting Using the Sorting Buttons on the Standard Toolbar Producing Top 10 Reports Grouping Pivot Fields Grouping Date Fields When Grouping by Months, Include Years Grouping Date Fields by Week Grouping Two Date Fields in One Report Order Lead-Time Report Grouping Numeric Fields Grouping Text Fields Grouping and Ungrouping Next Steps 6. Performing Calculations Within Your Pivot Tables. Introducing Calculated Fields and Calculated Items Method 1: Manually Add the Calculated Field to Your Data Source Method 2: Use a Formula Outside of Your Pivot Table to Create the Calculated Field Method 3. Codice libro della libreria ABE_book_new_0789734354
Descrizione libro Que Publishing, 2005. Paperback. Condizione libro: New. book. Codice libro della libreria 0789734354
Descrizione libro Que Publishing, 2005. Paperback. Condizione libro: New. 1. Codice libro della libreria DADAX0789734354
Descrizione libro Que Publishing, 2005. Paperback. Condizione libro: New. Codice libro della libreria P110789734354