Intro -- Excel 2007 Data Analysis: Your visual blueprint for creating and analyzing data, charts, and PivotTables -- Credits -- About the Author -- Author's Acknowledgments -- TABLE OF CONTENTS -- HOW TO USE THIS BOOK -- Chapter 1: Getting Started -- Introduction to Data Analysis with Excel -- Understanding the Excel Window -- Enter Data -- Format Numbers -- Format Cells -- Select Data -- Copy, Cut, and Paste Cells -- Copy with the Office Clipboard -- Insert and Delete Cells -- Find and Replace -- Find and Replace Formats -- Chapter 2: Creating Formulas -- Understanding Formulas -- Create Formulas -- Edit Formulas -- Name Cells and Ranges -- Define and Display Constants -- Create Formulas that Include Names -- Check Formulas for Errors -- Trace Precedents and Dependents -- Chapter 3: Creating and Using Functions -- Understanding the Function Wizard -- Round a Number -- Determine the Nth Largest Value -- Create a Conditional Formula -- Calculate a Conditional Sum -- Calculate Products and Square Roots -- Look Up Information -- Determine the Location of a Value -- Perform Time Calculations -- Perform Date Calculations -- Chapter 4: Using Financial Functions -- Calculate Future Value -- Calculate Present Value -- Calculate Loan Payments -- Calculate Principal or Interest -- Calculate the Interest Rate -- Calculate the Internal Rate of Return -- Calculate Straight-Line Depreciation -- Calculate Declining Balance Depreciation -- Calculate Double-Declining Balance Depreciation -- Calculate Sum-of-the-Years-Digits Depreciation -- Chapter 5: Using Statistical Functions and Tools -- Calculate an Average -- Calculate the Median or the Mode -- Calculate Rank -- Calculate Frequency -- Calculate Variance and Standard Deviation -- Find the Correlation -- Install Excel Add-Ins -- Calculate a Moving Average -- Compare Variances.

Using the Data Analysis Toolpak to Determine Rank and Percentile -- Calculate Descriptive Statistics -- Chapter 6: Organizing Worksheet Data -- Enter Data with a Form -- Filter Duplicate Records -- Perform Simple Sorts and Filters -- Perform Complex Sorts -- Sort by Cell Color, Font Color, or Icon -- Perform Complex Filters -- Enter Criteria to Find Records -- Filter by Multiple Criteria -- Subtotal Sorted Data -- Count Filtered Records -- Define Data as a Table -- Modify a Table Style -- Chapter 7: Working with PivotTables -- Create a PivotTable -- Modify PivotTable Data and Layout -- Compute Subtotals and Grand Totals -- Create a PivotTable Calculated Field -- Hide Rows or Columns in a PivotTable -- Sort a PivotTable -- Retrieve Values from a PivotTable -- Chapter 8: Charting Data -- Create a Chart -- Add Chart Details -- Change the Chart Type -- Add a Trendline -- Add and Remove Chart Data -- Add Error Bars -- Create a Histogram -- Chart Filtered Data -- Create a PivotChart -- Create a Combination Chart -- Chapter 9: Working with External Data -- Paste Link into Word -- Embed a Worksheet -- Hyperlink a Worksheet -- Query a Web Site -- Import a Text File -- Import an Access Database -- Query an Access Database -- Chapter 10: Useful Data Analysis Tools and Techniques -- Perform What-If Analysis -- Optimize a Result with Goal Seek -- Solve a Formula with a Data Table -- Extend a Series with AutoFill -- Work with Multiple Windows -- Let Excel Read Back Your Data -- Add a Calculator -- Change Text to Numbers -- Convert a Row to a Column -- Consolidate Worksheets -- Conditionally Format Your Worksheet -- Change Conditional Formatting Rules -- Paste with Paste Special -- Insert Photographs into Your Worksheet -- Chapter 11: Sharing Your Workbook with Others -- Validate with a Validation List -- Validate with Data Entry Rules.

Add Comments to Your Worksheet -- Track Changes -- Protect Your Worksheet -- Save Your Workbook as a Template -- Choose a Format When Saving a Workbook -- Print Your Workbook -- Print Multiple Areas of Your Worksheet -- Add a Form Control to a Worksheet -- Assign Values to a Form Control -- Add a Macro to a Form Control -- Chapter 12: Automating with Macros -- Introducing Macros -- Set Macro Security -- Create a Digital Signature -- Record a Macro -- Assign a Digital Signature to a Macro -- Run a Macro -- Create and Launch a Keyboard Shortcut -- Assign a Macro to the Quick Access Toolbar -- Delete a Macro -- Using Keyboard Shortcuts with the Ribbon -- Appendix A: Excel Keyboard Shortcuts -- Using Keyboard Shortcuts with the Ribbon -- Excel Keyboard Shortcuts -- Appendix B: Excel Function Quick Reference -- Excel Function Quick Reference -- Appendix C: Formula Basics -- Formula Basics -- INDEX.

Welcome to the only guidebook series that takes a visual approach to professional-level computer topics. Open the book and you'll discover step-by-step screen shots that demonstrate over 110 Excel data analysis techniques, including: * Identifying trends in your data * Sorting, filtering, and identifying lists * Creating, editing, and checking formulas * Calculating interest rates and depreciation * Performing simple sorts and filters * Hiding rows or columns in a PivotTable * Adding and removing chart data * Querying an Access database * Assigning digital signatures * Solving a formula with a data table "I was stuck on an Excel problem for two days. Finally, I opened one of your books, and there was a macro to accomplish exactly what I needed! You made me look good to the boss." -Rob L. Meerscheidt(The Woodlands, TX) * High-resolution screen shots demonstrate each task * Succinct explanations walk you through step by step * Two-page lessons break big topics into bite-sized modules * "Apply It" and "Extra" sidebars highlight useful tips.

Description based on publisher supplied metadata and other sources.

Electronic reproduction. Ann Arbor, Michigan : ProQuest Ebook Central, 2018. Available via World Wide Web. Access may be limited to ProQuest Ebook Central affiliated libraries.