Share
Create bookmark
Microsoft® Excel® 2010 Plain & Simple
Do you like this document?
Notes
Please login to add notes
- Table of Contents
- Acknowledgments
- + Chapter 1. Introduction: About This Book
-
+
Chapter 2. What’s New and Improved in Excel 2010
- Managing Excel Files and Settings in Backstage View
- Previewing Data Using Paste Preview
- Customizing the Excel 2010 User Interface
- Summarizing Data Using More AccurateFunctions
- Summarizing Data Using Sparklines
- Visualizing Data Using Improved Conditional Formats
- Creating and Displaying Math Equations
- Editing Pictures Within Excel 2010
-
+
Chapter 3. Getting Started with Excel 2010
- Surveying the Excel Program Window
- Starting Excel
- Finding and Opening Existing Workbooks
- Using File Properties
- Creating a New Workbook
- Working with Multiple Workbooks
- Sizing and Viewing Windows
- Zooming In or Out on a Worksheet
- Viewing a Worksheet in Full-Screen Mode
- Saving and Closing an Excel Workbook
- Using the Excel Help System
-
+
Chapter 4. Building a Workbook
- Understanding How Excel Interprets Data Entry
- Navigating the Worksheet
- Selecting Cells
- Entering Text in Cells
- Entering Numbers in Cells
- Entering Dates and Times in Cells
- Entering Data Using Fills
- Entering Data with Other Shortcuts
- Creating an Excel Table
- Editing Cell Contents
- Inserting a Symbol in a Cell
- Creating Hyperlinks
- Cutting, Copying, and Pasting Cell Values
- Clearing Cell Contents
- Using the Office Clipboard
- Undoing or Redoing an Action
- Finding and Replacing Text
- Checking the Spelling of Your Worksheet
-
+
Chapter 5. Managing and Viewing Worksheets
- Viewing and Selecting Worksheets
- Renaming Worksheets
- Moving Worksheets
- Copying Worksheets
- Inserting and Deleting Worksheets
- Hiding or Showing a Worksheet
- Changing Worksheet Tab Colors
- Inserting, Moving, and Deleting Cells
- Inserting, Moving, and Deleting Columns and Rows
- Hiding and Unhiding Columns and Rows
- Entering Data and Formatting Many Worksheets at the Same Time
- Changing How You Look at Excel Workbooks
- Naming and Using Worksheet Views
-
+
Chapter 6. Using Formulas and Functions
- Understanding Formulas and Cell References in Excel
- Creating Simple Cell Formulas
- Assigning Names to Groups of Cells
- Using Names in Formulas
- Creating a Formula That References Values in an Excel Table
- Creating Formulas That Reference Cells in Other Workbooks
- Summing a Group of Cells Without Using a Formula
- Creating a Summary Formula
- Summing with Subtotals and Grand Totals
- Exploring the Excel Function Library
- Using the IF Function
- Checking Formula References
- Debugging Your Formulas
-
+
Chapter 7. Formatting the Cell
- Formatting Cell Contents
- Formatting Cells Containing Numbers
- Formatting Cells Containing Dates
- Adding Cell Backgrounds and Shading
- Formatting Cell Borders
- Defining Cell Styles
- Aligning and Orienting Cell Contents
- Changing How Conditional Formatting Rules Are Applied
- Stopping When a Condition Is Met
- Displaying Data Bars, Icon Sets, or Color Scales Based on Cell Values
- Deleting Conditional Formats
- Copying Formats with Format Painter
- Merging or Splitting Cells or Data
-
+
Chapter 8. Formatting the Worksheet
- Applying Workbook Themes
- Coloring Sheet Tabs
- Changing a Worksheet’s Gridlines
- Changing Row Heights and Column Widths
- Inserting Rows or Columns
- Moving Rows and Columns
- Deleting Rows and Columns
- Outlining to Hide and Show Rows and Columns
- Hiding Rows and Columns
- Protecting Worksheets from Changes
- Locking Cells to Prevent Changes
-
+
Chapter 9. Printing Worksheets
- Previewing Worksheets Before Printing
- Printing Worksheets with Current Options
- Choosing Whether to Print Gridlines and Headings
- Choosing Printers and Paper Options
- Printing Part of a Worksheet
- Printing Row and Column Headings on Each Page
- Setting and Changing Print Margins
- Setting Page Orientation and Scale
- Creating Headers and Footers
- Adding Graphics to a Header or a Footer
- Setting and Viewing Page Breaks
- + Chapter 10. Customizing Excel to the WayYou Work
- + Chapter 11. Sorting and Filtering Worksheet Data
- + Chapter 12. Summarizing Data Visually Using Charts
-
+
Chapter 13. Enhancing Your Worksheets with Graphics
- Working with Graphics in Your Worksheets
- Adding Graphics to Worksheets
- Adding Drawing Objects to a Worksheet
- Adding Fills to Drawing Objects
- Adding Effects to Drawing Objects
- Customizing Pictures and Objects
- Aligning and Grouping Drawing Objects
- Using WordArt to Create Text Effects in Excel
- Inserting Clip Art into a Worksheet
- Inserting and Changing a Diagram
- Creating an Organization Chart
- Adding an Equation to a Shape
- + Chapter 14. Sharing Excel Data with Other Programs
- + Chapter 15. Using Excel in a Group Environment
- + Index
- About the Author
Get the guide that makes learning Microsoft Excel 2010 plain and simple! This full color, no-nonsense book shows you the quickest ways to solve a problem or learn a skill, using easy-to-follow steps and concise, straightforward language. You'll analyze, manage, and share information in more ways than ever before.
Here's WHAT you'll learn:
Manage your financial data and personal expenses
Get started quickly with prebuilt templates
Create formulas and functions to do the hard work
Sort, filter, update, and copy your data
Use charts and graphics to bring data to life
Collaborate with colleagues by sharing spreadsheets online
Here's HOW you'll learn it:
Jump in whenever you need answers
Easy-to-follow STEPS and SCREENSHOTS show exactly what to do
Handy TIPS teach new techniques and shortcuts
Quick TRY THIS! exercises help apply what you learn right away
Your free to read time expires in minutes. After that you have to pause for an hour.
Book Details
Authors
Publishers
Publication year : 2010
License: All rights reserved ©
Times read: 295
