Home Page Icon
Home Page
Table of Contents for
Title Page
Close
Title Page
by Abbott Katz
Excel 2010 Made Simple
Title Page
Contents at a Glance
Contents
About the Author
About the Technical Reviewer
Acknowledgments
Quick Start Guide
The Excel Worksheet: What You're Looking At
Key Tips: Accessing Buttons with the Keyboard
Contextual Tabs
A Visit Backstage
Customizing the Quick Access Toolbar
Where to Learn More
Excel Keyboard Equivalents
Chapter 1: Introducing Excel 2010
The Advantages of Learning More
Spreadsheets Defined
Excel Can Be Fun
Summary
Chapter 2: Getting Around the Worksheet and Data Entry
The Journey Starts Here
Looking Around
Getting Around a Worksheet
Selecting Multiple Cells
Entering Text and Data
Aligning Your Data—Where It Appears in the Cell
Widening and Narrowing Columns
Entering Numerical Data—How it's Different
Entering Data into a Selected Range
Using Auto Fill to Speed Up Data Entry
Data Validation: Bringing Quality Control to the Worksheet
Adding Data Entry Instructions with Input Messages
Summary
Chapter 3: EditingData
Changing Your Data
Copying and Moving: Duplicating and Relocating Your Data
The Clipboard: The Storage Area for Copied and Cut Data
Summary
Chapter 4: Number Crunching 101: Functions, Formulas, and Ranges
Automatic Calculations with Functions
Customizing the Worksheet with Formulas
Clarifying Cell References by Naming a Range
Summary
Chapter 5: For Appearance's Sake: Formatting Your Data
What Formatting Does (and Doesn't Do)
Basic Formatting
Aligning (and Realigning) Your Data
Inserting, Deleting, and Hiding Columns and Rows
Formatting Values: Making the Numbers Look Good
Customizing Number Formats
Copying Formats (Not Data) with the Format Painter
Applying Ready-Made Formats with Styles
Applying Styles Quickly: Another Way to Access Formatting Options
Conditional Formatting
Summary
Chapter 6: Charting Your Data
Defining Chart Elements
Choosing a Chart Type
Creating a Column Chart
Creating a Chart in 2 Seconds
Changing a Chart
Switching Rows with Columns: A Different Kind of Change
Formatting Charts
Introducing Sparklines: Mini-Charts Placed in Cells
Summary
Chapter 7: Sorting and Filtering Your Data: Excel's Database Features
Sorting Data: Instilling Order in Your Data
Finding What You Want with Filters
Tables: Adding User-Friendliness to Your Database
Summary
Chapter 8: PivotTables: Data Aggregation Without the Aggravation
Looking at Some PivotTables
Creating a PivotTable
Grouping Related Items Using Two Fields
Viewing Which Records Are Filtered: Using the Slicer
Formatting the PivotTable
Styling Your Report
Creating Charts from PivotTables Using PivotCharts
Summary
Chapter 9: Managing Your Workbook
Adding Worksheets to Your Workbook
Grouping Sheets: Changing Multiple Sheets at the Same Time
Using the View Context Tab to Show and Hide Basic Screen Elements
Protecting the Worksheet and the Workbook
Summary
Chapter 10: Printing Your Worksheets: Hard Copies Made Easy
Deciding What You Want to Print
Surveying Printing Options: The Print Backstage
Setting the Print Area
Customizing Your Printing
Adding Headers and Footers
Printing the Gridlines and Headings
Summary
Chapter 11: Automating Your Work with Macros
The Two Kinds of Macros
Composing a Macro
About Saving a Workbook with a Macro
Saving a Macro to the Personal Macro Workbook
Deleting a Macro
Editing a Macro by Tweaking It in VBA
Activating a Macro with a Keyboard Shortcut
A Note on Macro Security
Summary
Index
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
Next
Next Chapter
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