- 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
About the Author
Tracy Syrstad is a Microsoft Excel developer and author of eight Excel books. She has been helping people with Microsoft Office issues since 1997 when she discovered free online forums where anyone could ask and answer questions. Tracy discovered she enjoyed teaching others new skills, and when she began working as a developer, she was able to integrate the fun of teaching with one-on-one online desktop sharing sessions. Tracy lives on an acreage in eastern South Dakota with her husband, one dog, two cats, one horse (two soon), and a variety of wild foxes, squirrels, and rabbits.
-
No Comment
..................Content has been hidden....................
You can't read the all page of ebook, please click here login for view all page.