Home Page Icon
Home Page
Table of Contents for
About the Author
Close
About the Author
by Abbott Katz
Beginning Microsoft Excel 2010
Copyright
About the Author
About the Technical Reviewer
Acknowledgments
Introduction
1. Introduction to Excel
1.1. Making the Acquaintance
1.2. Unlocking Your Inner Worksheet
1.3. The Pep Talk
1.4. Interacting with the Interface
1.5. Tab Talk
1.6. Something New, Something Old
1.7. Keeping Tabs...on a New One
1.8. Cool QAT
1.9. Understood in Context
1.10. Alt-ered Consciousness
2. Getting Started and Getting Around the Worksheet
2.1. More Addresses Than the Phone Book—Cells, and How to Get There
2.2. Getting Around
2.3. Key Points
2.4. Ranges: A Select Tool
2.5. Data Entry: Getting Started
2.5.1. Entering Text: Trespassing Allowed
2.6. Numbers are (a little) Different
2.7. Relocating the Data: Copying and Moving
2.8. Having Your Fill
2.9. There'll Be Some Changes Made—Editing Cells
3. From Data Entry to Data Creation: Formula Basics and Beyond
3.1.
3.1.1. Cell references explained
3.2. Ordering Up Your Results
3.2.1. Not Just Your Average Function
3.2.2. Making Range Values COUNT
3.2.3. MAX and MIN—Recording Highs and Lows
3.2.4. Absolute References: Absolutely Important
3.3. More of the Same
3.3.1. You Could Look It Up
3.3.2. If: Worth Knowing—No Ifs, Ands, or Buts
3.3.3. In Conclusion...
3.4.
4. Keeping Up Appearances—Formatting the Worksheet
4.1. You've Got Designs on Your Worksheet
4.1.1. The Font Button Group: A Closer Look
4.2. Borderline Command
4.3. Getting Oriented
4.4. Excel Has Got Your Number(s)
4.5. Dates—The Long and the Short of It
4.6. Time Is On Your Side—Yes It Is
4.7. A New Kind of Copy—and Paste
4.8. Style Setter
4.9. Formatting—With Conditions
4.10. Just a Bit More...
4.11. P. S.
4.12. IN CONCLUSION...
5. The Stuff Of Legend—Charting in Excel
5.1. Starting Charting
5.1.1. Making a Chart of Our Own
5.1.1.1. Excluding Data
5.1.1.2. Evaluating the Chart
5.1.1.3. Resizing the Chart
5.1.1.4. Flipping the Data Series
5.1.2. Changing The Chart—It's Your Call
5.1.2.1. The Column Chart
5.1.2.2. The Line Chart
5.1.2.3. The Pie Chart
5.1.2.4. The Bar Chart
5.1.2.5. The Area Chart
5.1.2.6. The Scatter Chart
5.2. The Design Tab—A Closer Look
5.2.1. Change Chart Type
5.2.2. Save As Template
5.2.3. Switch Row/Column
5.2.4. Select Data
5.2.5. Chart Layouts
5.2.6. Chart Styles
5.2.7. Move Chart
5.3. Changing the Chart Default—and the 2-Second Chart
5.4. The Layout Tab
5.5. Working with Chart Labels
5.6. Axes to Grind
5.7. The Format Tab—Getting Your Objects in Shape
5.8. Sparklines: Mini-Charts with Big Impact
5.9. You Win Some, You Lose Some
5.10. In Conclusion...
6. Setting the Table: Database Features of Excel 2010
6.1. Sorting—Sort Of Easy
6.1.1. Using Header Rows
6.1.2. Sorting by More than One Field
6.2. The AutoFilter: Picking and Choosing Your Data
6.3. Playing—or Plying—the Numbers
6.4. The Advanced Filter—Setting Your Data Aside
6.5. Table Talk
6.5.1. Creating a Table
6.5.2. Using Table Styles
6.5.3. Adding a Total Row
6.5.4. Examining the other Table Style Options
6.6. At the Risk of Repeating Yourself: The Remove Duplicates Option
6.7. Data Validation: Improving Your Entrée to Data Entry
6.7.1. Using Data Validation
6.7.2. Adding Data Entry Rules
6.7.3. Adding an Input Message
6.7.4. Using the Error Alert Option
6.7.5. Adding a Validation Rule to Existing Data
6.8. In Conclusion...
7. Working With Multiple Sheets
7.1. Adding To Sheets—Inserting Rows, Columns and Cells
7.1.1. Inserting a Column
7.1.2. Inserting a Row
7.1.3. Deleting Rows and Columns
7.1.4. Inserting and Deleting Cells
7.1.5. Hiding Rows and Columns—and Getting them Back
7.2. Multiple Worksheet Basics
7.2.1. Inserting a New Worksheet
7.2.2. Busting a (Sheet) Move
7.2.3. Hiding Worksheets
7.2.4. Grouping Worksheets
7.3. Far-Flung Formulas: Working with Multi-Sheet Cell References
7.3.1. Doing a Multi-sheet Calculation
7.3.2. Extending Your Reach: Referring to Cells in Different Workbooks
7.4. The Watch Window—Spying On Your Own Data
7.5. Protect Your Cells From Unwanted Intruders—Even Yourself
7.5.1. Protecting a Sheet
7.5.1.1. Locking Cells
7.5.1.2. Unlocking Cells
7.5.2. Protecting a Whole Workbook
7.6. Consolidating Your Data—Getting It All Together
7.7. In Conclusion...
8. PivotTables and Pivot Charts
8.1. Starting Out with PivotTables
8.2. What's in a Name?
8.3. Constructing a PivotTable: Let's Go
8.3.1. Inserting the Table
8.3.2. Setting Up the PivotTable
8.3.3. Updating the Pivot Report
8.3.3.1. Changing the Calculation
8.3.3.2. Comparing the Data
8.3.3.3. Moving and Removing Fields
8.3.3.4. Adding Data Fields
8.3.3.5. Changing Field Settings
8.3.3.6. Pivoting the Table
8.3.3.7. Counting Totals
8.3.3.8. Using the Same Field Twice
8.4. Filters Again-PivotTable Style
8.5. Your Very Own Top 10 List
8.6. The Report Filter—Getting on Top of the PivotTable
8.7. The Slicer—Filter Deluxe
8.8. Grouping the Data
8.9. Formatting the Pivot Report—Values and All
8.10. Pivot Charts
8.11. In Conclusion...
9. Getting It On Paper—Printing in Excel 2010
9.1. Hard Copy? Pretty Easy
9.2. The Print Area Option
9.3. Margin-al Utility
9.4. Printing As You See Fit
9.5. Headers and Footers—Getting to the Bottom (and the Top) of Your Printout
9.6. Title Search
9.7. There's More Than One Way to View A Worksheet
9.7.1. Gimme a (Page) Break—Another View
9.8. Customize Your View, Too
9.9. In Conclusion...
10. Taking it to the Cloud: Sharing and Collaborating on the Internet
10.1. Getting There
10.2. Permission Granted: Sharing Your Workbooks
10.3. Hey—You! Get Onto My Cloud !
10.4. In Conclusion...
A. Working With Range Names
A.1. What's in a Name? Plenty, if it's a Range
A.2. Naming Many Ranges – at the Same Time
A.3. The Name Manager – Tracking Your Ranges
A.4. In Conclusion...
B. Keyboard Shortcuts
B.1. Control Key Combinations
B.2. Function keys
B.3. Other shortcut keys
C. Error Messages
C.1. Nobody's Perfect
Search in book...
Toggle Font Controls
Playlists
Add To
Create new playlist
Name your new playlist
Playlist description (optional)
Cancel
Create playlist
Sign In
Email address
Password
Forgot Password?
Create account
Login
or
Continue with Facebook
Continue with Google
Sign Up
Full Name
Email address
Confirm Email Address
Password
Login
Create account
or
Continue with Facebook
Continue with Google
Prev
Previous Chapter
Copyright
Next
Next Chapter
About the Technical Reviewer
About the Author
Add Highlight
No Comment
..................Content has been hidden....................
You can't read the all page of ebook, please click
here
login for view all page.
Day Mode
Cloud Mode
Night Mode
Reset