Book description
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
Table of contents
- Copyright
- Praise For Visual Books...
- Credits
- About the Author
- Author's Acknowledgments
- HOW TO USE THIS BOOK
-
1. GETTING STARTED
- 1.1. Introduction to Data Analysis with Excel
- 1.2. Understanding the Excel Window
- 1.3. Enter Data
- 1.4. Format Numbers
- 1.5. Format Cells
- 1.6. Select Data
- 1.7. Copy, Cut, and Paste Cells
- 1.8. Copy with the Office Clipboard
- 1.9. Insert and Delete Cells
- 1.10. Find and Replace
- 1.11. Find and Replace Formats
- 2. CREATING FORMULAS
-
3. CREATING AND USING FUNCTIONS
- 3.1. Understanding the Function Wizard
- 3.2. Round a Number
- 3.3. Determine the Nth Largest Value
- 3.4. Create a Conditional Formula
- 3.5. Calculate a Conditional Sum
- 3.6. Calculate Products and Square Roots
- 3.7. Look Up Information
- 3.8. Determine the Location of a Value
- 3.9. Perform Time Calculations
- 3.10. Perform Date Calculations
-
4. USING FINANCIAL FUNCTIONS
- 4.1. Calculate Future Value
- 4.2. Calculate Present Value
- 4.3. Calculate Loan Payments
- 4.4. Calculate Principal or Interest
- 4.5. Calculate the Interest Rate
- 4.6. Calculate the Internal Rate of Return
- 4.7. Calculate Straight-Line Depreciation
- 4.8. Calculate Declining Balance Depreciation
- 4.9. Calculate Double-Declining Balance Depreciation
- 4.10. Calculate Sum-of-the-Years-Digits Depreciation
-
5. USING STATISTICAL FUNCTIONS AND TOOLS
- 5.1. Calculate an Average
- 5.2. Calculate the Median or the Mode
- 5.3. Calculate Rank
- 5.4. Calculate Frequency
- 5.5. Calculate Variance and Standard Deviation
- 5.6. Find the Correlation
- 5.7. Install Excel Add-Ins
- 5.8. Calculate a Moving Average
- 5.9. Compare Variances
- 5.10. Using the Data Analysis Toolpak to Determine Rank and Percentile
- 5.11. Calculate Descriptive Statistics
-
6. ORGANIZING WORKSHEET DATA
- 6.1. Enter Data with a Form
- 6.2. Filter Duplicate Records
- 6.3. Perform Simple Sorts and Filters
- 6.4. Perform Complex Sorts
- 6.5. Sort by Cell Color, Font Color, or Icon
- 6.6. Perform Complex Filters
- 6.7. Enter Criteria to Find Records
- 6.8. Filter by Multiple Criteria
- 6.9. Subtotal Sorted Data
- 6.10. Count Filtered Records
- 6.11. Define Data as a Table
- 6.12. Modify a Table Style
- 7. WORKING WITH PIVOTTABLES
- 8. CHARTING DATA
- 9. WORKING WITH EXTERNAL DATA
-
10. USEFUL DATA ANALYSIS TOOLS AND TECHNIQUES
- 10.1. Perform What-If Analysis
- 10.2. Optimize a Result with Goal Seek
- 10.3. Solve a Formula with a Data Table
- 10.4. Extend a Series with AutoFill
- 10.5. Work with Multiple Windows
- 10.6. Let Excel Read Back Your Data
- 10.7. Add a Calculator
- 10.8. Change Text to Numbers
- 10.9. Convert a Row to a Column
- 10.10. Consolidate Worksheets
- 10.11. Conditionally Format Your Worksheet
- 10.12. Change Conditional Formatting Rules
- 10.13. Paste with Paste Special
- 10.14. Insert Photographs into Your Worksheet
-
11. SHARING YOUR WORKBOOK WITH OTHERS
- 11.1. Validate with a Validation List
- 11.2. Validate with Data Entry Rules
- 11.3. Add Comments to Your Worksheet
- 11.4. Track Changes
- 11.5. Protect Your Worksheet
- 11.6. Save Your Workbook as a Template
- 11.7. Choose a Format When Saving a Workbook
- 11.8. Print Your Workbook
- 11.9. Print Multiple Areas of Your Worksheet
- 11.10. Add a Form Control to a Worksheet
- 11.11. Assign Values to a Form Control
- 11.12. Add a Macro to a Form Control
- 12. AUTOMATING WITH MACROS
- A. EXCEL KEYBOARD SHORTCUTS
- B. EXCEL FUNCTION QUICK REFERENCE
- C. FORMULA BASICS
Product information
- Title: Microsoft Office Excel® 2007 Data Analysis: Your Visual Blueprint™ for Creating and Analyzing Data, Charts, and PivotTables
- Author(s):
- Release date: July 2007
- Publisher(s): Visual
- ISBN: 9780470132296
You might also like
book
Microsoft® Office Excel® 2007: Data Analysis and Business Modeling, Second Edition
Master the techniques that business analysts at leading companies use to transform data into bottom-line results. …
book
Excel Data Analysis: Your visual blueprint for analyzing data, charts, and PivotTables, 4th Edition
Professional-level coverage and techniques for Excel power users Aimed at Excel power users who appreciate logical, …
book
Business Solutions Formulas and Functions with Microsoft® Office Excel 2007
“If you’ve never quite grasped formulas and functions, Paul McFedries will radically expand your understanding and …
book
Microsoft® Office Excel 2003 Programming Inside Out
Take your Microsoft Office experience to the next level by programming custom business solutions with Excel …