Author's Acknowledgments
by Denise Etheridge
Excel® Data Analysis: Your visual blueprint™ for creating and analyzing data, charts, and PivotTables, 3rd Edition
- Copyright
- Credits
- About the Author
- Author's Acknowledgments
- How to Use This Visual Blueprint Book
- 1. GETTING STARTED
- 1.1. Introducing Data Analysis with Excel
- 1.2. Tour the Excel Window
- 1.3. Explore the Ribbon
- 1.4. Using the Mini Toolbar and Context Menu
- 1.5. Select Options on the Status Bar
- 1.6. Take a Look at Backstage View
- 1.7. Upload a File to Excel's Web-based Application
- 1.8. Create a File Using Excel's Web-based Application
- 1.9. Enter Data
- 1.10. Select Cells
- 2. FORMATTING A WORKSHEET
- 2.1. Using the Ribbon to Format Numbers
- 2.2. Using the Format Cells Dialog Box
- 2.3. Understanding Dates and Times
- 2.4. Format Percentages
- 2.5. Format Fractions
- 2.6. Format in Scientific Notation
- 2.7. Format as Text
- 2.8. Add a Border
- 2.9. Change the Font or Font Size
- 2.10. Add a Background Color
- 2.11. Change the Font Color
- 2.12. Bold, Underline, or Italicize
- 2.13. Align Data
- 2.14. Rotate Data
- 2.15. Wrap Text
- 2.16. Merge and Center
- 2.17. Apply a Style
- 2.18. Using Format Painter
- 2.19. Clear Formats
- 3. STRUCTURING YOUR WORKBOOK
- 3.1. Cut, Copy, and Paste Cells
- 3.2. Using Live Preview with Paste
- 3.3. Paste from the Office Clipboard
- 3.4. Insert or Delete
- 3.5. Find and Replace Information
- 3.6. Change the Name of a Worksheet
- 3.7. Change Column Widths or Row Heights
- 3.8. Hide Columns or Rows
- 3.9. Hide a Worksheet
- 3.10. Move or Copy a Worksheet
- 3.11. Freeze Worksheet Titles
- 3.12. Hide Gridlines, Headings, or the Formula Bar
- 4. CREATING FORMULAS
- 4.1. Understanding Formulas
- 4.2. Calculate with an Operator
- 4.3. Calculate Using a Function and Cell Addresses
- 4.4. Create an Array Formula
- 4.5. Using the Sum, Average, Count, Min, and Max Functions
- 4.6. Create a Formula that Refers to Another Worksheet
- 4.7. Understanding Relative and Absolute Cell Addresses
- 4.8. Edit Formulas
- 4.9. Name Cells and Ranges
- 4.10. Define and Display Constants
- 4.11. Create Formulas That Include Names
- 4.12. Check Formulas for Errors
- 4.13. Trace Precedents and Dependents
- 5. USING FUNCTIONS
- 5.1. Understanding the Function Wizard
- 5.2. Round a Number
- 5.3. Create a Conditional Formula
- 5.4. Calculate a Conditional Sum
- 5.5. Calculate a Conditional Count
- 5.6. Find the Square Root
- 5.7. Retrieve Column or Row Numbers
- 5.8. Using VLOOKUP
- 5.9. Determine the Location of a Value
- 5.10. Using INDEX
- 5.11. Perform Date and Time Calculations
- 6. USING FINANCIAL FUNCTIONS
- 6.1. Calculate Future Value
- 6.2. Calculate Present Value
- 6.3. Calculate Loan Payments
- 6.4. Calculate Principal or Interest
- 6.5. Calculate the Interest Rate
- 6.6. Calculate the Internal Rate of Return
- 6.7. Calculate Straight-Line Depreciation
- 6.8. Calculate Declining Balance Depreciation
- 6.9. Calculate Double-Declining Balance Depreciation
- 6.10. Calculate Sum-of-the-Years-Digits Depreciation
- 7. USING STATISTICAL FUNCTIONS AND TOOLS
- 7.1. Calculate an Average
- 7.2. Calculate a Conditional Average
- 7.3. Calculate the Median or the Mode
- 7.4. Calculate Rank
- 7.5. Determine the Nth Largest Value
- 7.6. Calculate Frequency
- 7.7. Calculate Variance and Standard Deviation
- 7.8. Find the Correlation
- 7.9. Install Excel Add-Ins
- 7.10. Calculate a Moving Average
- 7.11. Compare Variances
- 7.12. Using the Data Analysis Toolpak to Determine Rank and Percentile
- 7.13. Calculate Descriptive Statistics
- 8. ORGANIZING WORKSHEET DATA
- 8.1. Enter Data with a Form
- 8.2. Perform Simple Sorts and Filters
- 8.3. Perform Multilevel Sorts
- 8.4. Perform a Custom Sort
- 8.5. Sort by Cell Color, Font Color, or Cell Icon
- 8.6. Perform Complex Filters
- 8.7. Enter Criteria to Find Records
- 8.8. Using Advanced Filtering Techniques
- 8.9. Filter Duplicate Records
- 8.10. Count Filtered Records
- 8.11. Subtotal Records
- 8.12. Using Auto Outline
- 8.13. Define Data as a Table
- 8.14. Modify a Table Style
- 8.15. Using Database Functions with a Table
- 9. WORKING WITH PIVOTTABLES
- 9.1. Create a PivotTable
- 9.2. Modify a PivotTable Layout
- 9.3. Summarize PivotTable Values
- 9.4. Create a PivotTable Calculated Field
- 9.5. Group the Rows or Columns in a PivotTable
- 9.6. Apply a Style to a PivotTable
- 9.7. Filter a PivotTable
- 9.8. Sort a PivotTable
- 9.9. Retrieve Values from a PivotTable
- 9.10. Using Slicer
- 10. CHARTING DATA
- 10.1. Create a Chart
- 10.2. Add Chart Details
- 10.3. Create a Combination Chart
- 10.4. Change the Chart Type
- 10.5. Add or Remove Chart Data
- 10.6. Add Sparklines
- 10.7. Create a Trendline
- 10.8. Add Error Bars
- 10.9. Create a Histogram
- 10.10. Chart Filtered Data
- 10.11. Create a PivotChart
- 10.12. Filter a PivotChart
- 11. WORKING WITH EXTERNAL DATA
- 12. USING DATA ANALYSIS TOOLS AND TECHNIQUES
- 12.1. Perform What-If Analysis
- 12.2. Optimize a Result with Goal Seek
- 12.3. Using Solver
- 12.4. Solve a Formula with a Data Table
- 12.5. Extend a Series with Auto Fill
- 12.6. Join Text
- 12.7. Add a Calculator
- 12.8. Consolidate Worksheets
- 12.9. Highlight Cells that Meet Your Criteria
- 12.10. Find the Highest or Lowest Ranked Values
- 12.11. Add Data Bars to Your Worksheet
- 12.12. Add Icon Sets to Your Worksheet
- 12.13. Remove Conditional Formatting
- 12.14. Change Conditional Formatting Rules
- 12.15. Paste with Paste Special
- 13. SHARING YOUR WORKBOOK WITH OTHERS
- 13.1. Validate with a Validation List
- 13.2. Validate with Data Entry Rules
- 13.3. Add Comments to Your Worksheet
- 13.4. Track Changes
- 13.5. Protect Your Worksheet
- 13.6. Save Your Workbook as a Template
- 13.7. Choose a Format When Saving a Workbook
- 13.8. Print Your Workbook
- 13.9. Print Multiple Areas of Your Worksheet
- 14. AUTOMATING WITH MACROS
- 15. ILLUSTRATING YOUR WORKSHEETS
- 15.1. Place a Screenshot in Your Worksheet
- 15.2. Insert Clip Art into Your Worksheet
- 15.3. Crop a Clip Art Illustration or a Photograph
- 15.4. Insert a Picture into Your Worksheet
- 15.5. Recolor a Picture
- 15.6. Adjust the Sharpness, Brightness, and Contrast
- 15.7. Compress a Picture
- 15.8. Add a Border
- 15.9. Add a Picture Effect
- 15.10. Apply a Picture Style
- 15.11. Add an Artistic Effect
- 15.12. Remove a Background
- 16. ILLUSTRATING YOUR IDEAS
- 16.1. Insert a Text Box
- 16.2. Format a Text Box
- 16.3. Insert a Shape
- 16.4. Add Text to a Shape
- 16.5. Change the Size of an Object
- 16.6. Rotate an Object
- 16.7. Change the Stacking Order
- 16.8. Group Objects
- 16.9. Align Objects
- 16.10. Insert a Symbol
- 16.11. Using SmartArt Graphics
- 16.12. Modify a SmartArt Graphic
- 16.13. Apply a SmartArt Style
- 16.14. Apply a SmartArt Layout
- 17. CUSTOMIZING EXCEL
- A. USING EXCEL KEYBOARD SHORTCUTS
Writing this book was an absolute privilege. I would like to thank all of the people who assisted me. I give special thanks to Jody Lefevere, for allowing me this privilege; Jade Williams, for keeping things on track; Namir Shammas, for his technical review; and Lauren Kennedy, for her copy review.
-
No Comment
..................Content has been hidden....................
You can't read the all page of ebook, please click here login for view all page.