Book description
Get the most out of Excel 2010 with Excel 2010 Made Simple—learn the key features, understand what's new, and utilize dozens of time-saving tips and tricks to get your job done. Over 500 screen visuals and clear-cut instructions guide you through the features of Excel 2010, from formulas and charts to navigating around a worksheet and understanding Visual Basic for Applications (VBA) and macros.
Excel 2010 Made Simple takes a practical and highly effective approach to using Excel 2010, showing you the best way to complete your most common spreadsheet tasks. You'll learn how to input, format, sort, and filter your data to find out what you want to know. You'll see how to place your data in tables and named ranges for easy access, all of which will get you working efficiently and productively.
Excel 2010 Made Simple also covers the new features introduced in Excel 2010. For instance, it shows you how to use Sparklines for data comparison and the Backstage view for printing and sharing your spreadsheets, so you can carry out your tasks with the minimum of fuss. The hands-on focus on tasks means you'll see how to actually use Excel 2010 to suit your needs.
What you'll learn
How to do efficient and complex data entry
How to format your data
How to write basic—and not so basic—formulas
How to use Excel's database capabilities, including PivotTables
How to create colorful, meaningful charts
How to create basic macros and how to use them
How to use new Excel 2010 features, such as Sparklines and the Backstage view
Who this book is for
Excel 2010 Made Simple is for newcomers to Excel.
Table of contents
- Title Page
- Contents at a Glance
- Contents
- About the Author
- About the Technical Reviewer
- Acknowledgments
- Quick Start Guide
- Chapter 1: Introducing Excel 2010
-
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
- Chapter 4: Number Crunching 101: Functions, Formulas, and Ranges
-
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
- Chapter 7: Sorting and Filtering Your Data: Excel's Database Features
- Chapter 8: PivotTables: Data Aggregation Without the Aggravation
- Chapter 9: Managing Your Workbook
- Chapter 10: Printing Your Worksheets: Hard Copies Made Easy
- Chapter 11: Automating Your Work with Macros
- Index
Product information
- Title: Excel 2010 Made Simple
- Author(s):
- Release date: June 2011
- Publisher(s): Apress
- ISBN: 9781430235453
You might also like
book
Easy Microsoft® Excel® 2010
This year, millions of beginner-to-intermediate-level users will be searching for the easiest possible way to master …
book
MS Excel, Second Edition, 2nd Edition
MS Excel is one of the most powerful tools available to a business manager. In this …
book
Excel® 2007: Top 100 Simplified® Tips & Tricks
You already know Excel 2007. Now you'd like to go beyond with shortcuts, tricks, and tips …
book
Beginning Microsoft Excel 2010
Beginning Microsoft Excel 2010 is a practical, step-by-step guide to getting started with the world's most …