- About This eBook
- Title Page
- Copyright Page
- Contents at a Glance
- Table of Contents
- About the Author
- Dedication
- Acknowledgments
- We Want to Hear from You!
- Reader Services
- Introduction
- 1. Understanding the Microsoft Excel Interface
- 2. Working with Workbooks and Templates
- 3. Working with Sheets
- 4. Getting Data onto a Sheet
- Entering Different Types of Data into a Cell
- Using Lists to Quickly Fill a Range
- Using Paste Special
- Using Text to Columns to Separate Data in a Single Column
- Using Data Validation to Limit Data Entry in a Cell
- Using Web Queries to Get Data onto a Sheet
- Editing Data
- Clearing the Contents of a Cell
- Clearing an Entire Sheet
- Working with Tables
- Fixing Numbers Stored as Text
- Spell Checking a Sheet
- Finding Data on a Sheet
- 5. Selecting and Moving Data on a Sheet
- 6. Formatting Sheets and Cells
- Changing the Font Settings of a Cell
- Adjusting the Row Height
- Adjusting the Column Width
- Aligning Text in a Cell
- Merging Two or More Cells
- Centering Text Across Multiple Cells
- Wrapping Text in a Cell to the Next Line
- Reflowing Text in a Paragraph
- Indenting Cell Contents
- Applying Number Formats
- Adding a Border Around a Range
- Coloring the Inside of a Cell
- 7. Advanced Formatting
- 8. Using Formulas
- 9. Using Functions
- 10. Sorting Data
- 11. Filtering and Consolidating Data
- 12. Distributing and Printing a Workbook
- Using Cell Comments to Add Notes to Cells
- Allowing Multiple Users to Edit a Workbook at the Same Time
- Hiding and Unhiding Sheets
- Using Freeze Panes
- Configuring the Page Setup
- Creating a Custom Header or Footer
- Printing Sheets
- Protecting a Workbook from Unwanted Changes
- Protecting the Data on a Sheet
- Preventing Changes by Marking a File as Final
- Sharing Files Between Excel Versions
- Recovering Lost Changes
- Sending an Excel File as an Attachment
- Sharing a File Online
- 13. Inserting Subtotals and Grouping Data
- 14. Creating Charts and Sparklines
- 15. Summarizing Data with PivotTables
- Creating a PivotTable
- Changing the PivotTable Layout
- PivotTable Sorting
- Expanding and Collapsing Fields
- Grouping Dates
- Filtering Data in a PivotTable
- Creating a Calculated Field
- Hiding Totals
- Viewing the Records Used to Calculate a Value
- Unlinking PivotTables
- Refreshing the PivotTable
- Working with Slicers
- 16. Inserting SmartArt, WordArt, and Pictures
- 17. Introducing the Excel Web App
- Index
Acknowledgments
I’ve always wanted to do a full-color, step-by-step help book, and thanks to Michelle Newcomb, I finally got my chance. Zack Barresse has written the book on Excel Tables, and if I had a print copy, it would be rather dog-eared. Last but not least, thank you to my husband, John, who reminded me to eat and get outside when I was obsessing over deadlines.
-
No Comment
..................Content has been hidden....................
You can't read the all page of ebook, please click here login for view all page.