- Introduction
- Part I: Getting Started with Excel
- Chapter 1: Introducing Excel
- Chapter 2: Entering and Editing Worksheet Data
- Chapter 3: Essential Worksheet Operations
- Chapter 4: Working with Cells and Ranges
- Chapter 5: Introducing Tables
- Chapter 6: Worksheet Formatting
- Chapter 7: Understanding Excel Files
- Chapter 8: Using and Creating Templates
- Chapter 9: Printing Your Work
- Part II: Working with Formulas and Functions
- Chapter 10: Introducing Formulas and Functions
- Chapter 11: Creating Formulas That Manipulate Text
- Chapter 12: Working with Dates and Times
- Chapter 13: Creating Formulas That Count and Sum
- Chapter 14: Creating Formulas That Look Up Values
- Chapter 15: Creating Formulas for Financial Applications
- Chapter 16: Miscellaneous Calculations
- Chapter 17: Introducing Array Formulas
- Chapter 18: Performing Magic with Array Formulas
- Part III: Creating Charts and Graphics
- Chapter 19: Getting Started Making Charts
- Chapter 20: Learning Advanced Charting
- Selecting Chart Elements
- User Interface Choices for Modifying Chart Elements
- Modifying the Chart Area
- Modifying the Plot Area
- Working with Titles in a Chart
- Working with a Legend
- Working with Gridlines
- Modifying the Axes
- Working with Data Series
- Creating Chart Templates
- Learning Some Chart-Making Tricks
- Chapter 21: Visualizing Data Using Conditional Formatting
- Chapter 22: Creating Sparkline Graphics
- Chapter 23: Enhancing Your Work with Pictures and Drawings
- Part IV: Using Advanced Excel Features
- Chapter 24: Customizing the Excel User Interface
- Chapter 25: Using Custom Number Formats
- Chapter 26: Using Data Validation
- Chapter 27: Creating and Using Worksheet Outlines
- Chapter 28: Linking and Consolidating Worksheets
- Chapter 29: Excel and the Internet
- Chapter 30: Protecting Your Work
- Chapter 31: Making Your Worksheets Error Free
- Part V: Analyzing Data with Excel
- Chapter 32: Importing and Cleaning Data
- Chapter 33: Introducing Pivot Tables
- Chapter 34: Analyzing Data with Pivot Tables
- Working with Nonnumeric Data
- Grouping Pivot Table Items
- Creating a Frequency Distribution
- Creating a Calculated Field or Calculated Item
- Filtering Pivot Tables with Slicers
- Filtering Pivot Tables with a Timeline
- Referencing Cells Within a Pivot Table
- Creating Pivot Charts
- Another Pivot Table Example
- Using the Data Model
- Learning More About Pivot Tables
- Chapter 35: Performing Spreadsheet What-If Analysis
- Chapter 36: Analyzing Data Using Goal Seeking and Solver
- Chapter 37: Analyzing Data with the Analysis ToolPak
- Chapter 38: Working with Get & Transform
- Get & Transform: An Overview
- Data Source for Get & Transform
- Example: A Simple Query
- How Your Actions Are Recorded
- Example: Returning Summarized Data
- Example: Transforming Data from a Web Query
- Example: Merging Two Web Queries
- Example: Getting a List of Files
- Example: Choosing a Random Sample
- Example: Unpivoting a Table
- Tips for Using Get & Transform
- Learning More
- Part VI: Programming Excel with VBA
- Part VII: Appendixes
Part VII
Appendixes
This part contains two very useful appendixes. Appendix A provides a complete reference of all the worksheet functions. Appendix B covers Excel's shortcut keys.
In This Part
- Appendix A
Worksheet Function Reference - Appendix B
Excel Shortcut Keys
-
No Comment
..................Content has been hidden....................
You can't read the all page of ebook, please click here login for view all page.