Paperback
-
PICK UP IN STORECheck Availability at Nearby Stores
Available within 2 business hours
Related collections and offers
Overview
Product Details
ISBN-13: | 9780735626942 |
---|---|
Publisher: | Pearson Education |
Publication date: | 06/02/2010 |
Series: | Step by Step |
Pages: | 480 |
Product dimensions: | 7.40(w) x 9.00(h) x 1.20(d) |
About the Author
Table of Contents
Acknowledgments; Introducing Microsoft Excel 2010; Managing Excel Files and Settings in the Backstage View; Previewing Data by Using Paste Preview; Customizing the Excel 2010 User Interface; Summarizing Data by Using More Accurate Functions; Summarizing Data by Using Sparklines; Filtering PivotTable Data by Using Slicers; Filtering PivotTable Data by Using Search Filters; Visualizing Data by Using Improved Conditional Formats; Creating and Displaying Math Equations; Editing Pictures within Excel 2010; Managing Large Worksheets by Using the 64-bit Version of Excel 2010; Summarizing Large Data Sets by Using the PowerPivot (Project Gemini) Add-In; Accessing Your Data from Almost Anywhere by Using the Excel Web App and Excel Mobile 2010; Modifying the Display of the Ribbon; Dynamic Ribbon Elements; Changing the Width of the Ribbon; Adapting Exercise Steps; Features and Conventions of This Book; Using the Practice Files; Getting Help; Getting Help with This Book; Getting Help with Excel 2010; More Information; Chapter 1: Setting Up a Workbook; 1.1 Creating Workbooks; 1.2 Modifying Workbooks; 1.3 Modifying Worksheets; 1.4 Customizing the Excel 2010 Program Window; 1.5 Key Points; Chapter 2: Working with Data and Excel Tables; 2.1 Entering and Revising Data; 2.2 Moving Data Within a Workbook; 2.3 Finding and Replacing Data; 2.4 Correcting and Expanding Upon Worksheet Data; 2.5 Defining Excel Tables; 2.6 Key Points; Chapter 3: Performing Calculations on Data; 3.1 Naming Groups of Data; 3.2 Creating Formulas to Calculate Values; 3.3 Summarizing Data That Meets Specific Conditions; 3.4 Finding and Correcting Errors in Calculations; 3.5 Key Points; Chapter 4: Changing Workbook Appearance; 4.1 Formatting Cells; 4.2 Defining Styles; 4.3 Applying Workbook Themes and Excel Table Styles; 4.4 Making Numbers Easier to Read; 4.5 Changing the Appearance of Data Based on Its Value; 4.6 Adding Images to Worksheets; 4.7 Key Points; Chapter 5: Focusing on Specific Data by Using Filters; 5.1 Limiting Data That Appears on Your Screen; 5.2 Manipulating Worksheet Data; 5.3 Defining Valid Sets of Values for Ranges of Cells; 5.4 Key Points; Chapter 6: Reordering and Summarizing Data; 6.1 Sorting Worksheet Data; 6.2 Organizing Data into Levels; 6.3 Looking Up Information in a Worksheet; 6.4 Key Points; Chapter 7: Combining Data from Multiple Sources; 7.1 Using Workbooks as Templates for Other Workbooks; 7.2 Linking to Data in Other Worksheets and Workbooks; 7.3 Consolidating Multiple Sets of Data into a Single Workbook; 7.4 Grouping Multiple Sets of Data; 7.5 Key Points; Chapter 8: Analyzing Alternative Data Sets; 8.1 Defining an Alternative Data Set; 8.2 Defining Multiple Alternative Data Sets; 8.3 Varying Your Data to Get a Desired Result by Using Goal Seek; 8.4 Finding Optimal Solutions by Using Solver; 8.5 Analyzing Data by Using Descriptive Statistics; 8.6 Key Points; Chapter 9: Creating Dynamic Worksheets by Using PivotTables; 9.1 Analyzing Data Dynamically by Using PivotTables; 9.2 Filtering, Showing, and Hiding PivotTable Data; 9.3 Editing PivotTables; 9.4 Formatting PivotTables; 9.5 Creating PivotTables from External Data; 9.6 Key Points; Chapter 10: Creating Charts and Graphics; 10.1 Creating Charts; 10.2 Customizing the Appearance of Charts; 10.3 Finding Trends in Your Data; 10.4 Summarizing Your Data by Using Sparklines; 10.5 Creating Dynamic Charts by Using PivotCharts; 10.6 Creating Diagrams by Using SmartArt; 10.7 Creating Shapes and Mathematical Equations; 10.8 Key Points; Chapter 11: Printing; 11.1 Adding Headers and Footers to Printed Pages; 11.2 Preparing Worksheets for Printing; 11.3 Printing Worksheets; 11.4 Printing Parts of Worksheets; 11.5 Printing Charts; 11.6 Key Points; Chapter 12: Automating Repetitive Tasks by Using Macros; 12.1 Enabling and Examining Macros; 12.2 Creating and Modifying Macros; 12.3 Running Macros When a Button Is Clicked; 12.4 Running Macros When a Workbook Is Opened; 12.5 Key Points; Chapter 13: Working with Other Microsoft Office Programs; 13.1 Including Office Documents in Workbooks; 13.2 Storing Workbooks as Parts of Other Office Documents; 13.3 Creating Hyperlinks; 13.4 Pasting Charts into Other Documents; 13.5 Key Points; Chapter 14: Collaborating with Colleagues; 14.1 Sharing Workbooks; 14.2 Managing Comments; 14.3 Tracking and Managing Colleagues’ Changes; 14.4 Protecting Workbooks and Worksheets; 14.5 Authenticating Workbooks; 14.6 Saving Workbooks for the Web; 14.7 Key Points; Glossary; Keyboard Shortcuts; Ctrl Combination Shortcut Keys; Function Keys; Other Useful Shortcut Keys; About the Author;