Experience learning made easy-and quickly teach yourself how to organize, analyze, and present data with Excel 2010. With STEP BY STEP, you set the pace-building and practicing the skills you need, just when you need them! Topics include creating formulas, calculating values, and analyzing data; presenting information visually with graphics, charts, and diagrams; building PivotTable dynamic views; using the new Excel Web App; reusing information from databases and other documents; creating macros to automate repetitive tasks and simplify your work; and other core topics.
Chapter 1 Setting Up a Workbook
Creating Workbooks
Modifying Workbooks
Modifying Worksheets
Customizing the Excel 2010 Program Window
Key Points
Chapter 2 Working with Data and Excel Tables
Entering and Revising Data
Moving Data Within a Workbook
Finding and Replacing Data
Correcting and Expanding Upon Worksheet Data
Defining Excel Tables
Key Points
Chapter 3 Performing Calculations on Data
Naming Groups of Data
Creating Formulas to Calculate Values
Summarizing Data That Meets Specific Conditions
Finding and Correcting Errors in Calculations
Key Points
Chapter 4 Changing Workbook Appearance
Formatting Cells
Defining Styles
Applying Workbook Themes and Excel Table Styles
Making Numbers Easier to Read
Changing the Appearance of Data Based on Its Value
Adding Images to Worksheets
Key Points
Chapter 5 Focusing on Specific Data by Using Filters
Limiting Data That Appears on Your Screen
Manipulating Worksheet Data
Defining Valid Sets of Values for Ranges of Cells
Key Points
Chapter 6 Reordering and Summarizing Data
Sorting Worksheet Data
Organizing Data into Levels
Looking Up Information in a Worksheet
Key Points
Chapter 7 Combining Data from Multiple Sources
Using Workbooks as Templates for Other Workbooks
Linking to Data in Other Worksheets and Workbooks
Consolidating Multiple Sets of Data into a Single Workbook
Grouping Multiple Sets of Data
Key Points
Chapter 8 Analyzing Alternative Data Sets
Defining an Alternative Data Set
Defining Multiple Alternative Data Sets
Varying Your Data to Get a Desired Result by Using Goal Seek
Finding Optimal Solutions by Using Solver
Analyzing Data by Using Descriptive Statistics
Key Points
Chapter 9 Creating Dynamic Worksheets by Using PivotTables
Analyzing Data Dynamically by Using PivotTables
Filtering, Showing, and Hiding PivotTable Data
Editing PivotTables
Formatting PivotTables
Creating PivotTables from External Data
Key Points
Chapter 10 Creating Charts and Graphics
Creating Charts
Customizing the Appearance of Charts
Finding Trends in Your Data
Summarizing Your Data by Using Sparklines
Creating Dynamic Charts by Using PivotCharts
Creating Diagrams by Using SmartArt
Creating Shapes and Mathematical Equations
Key Points
Chapter 11 Printing
Adding Headers and Footers to Printed Pages
Preparing Worksheets for Printing
Printing Worksheets
Printing Parts of Worksheets
Printing Charts
Key Points
Chapter 12 Automating Repetitive Tasks by Using Macros
Enabling and Examining Macros
Creating and Modifying Macros
Running Macros When a Button Is Clicked
Running Macros When a Workbook Is Opened
Key Points
Chapter 13 Working with Other Microsoft Office Programs
Including Office Documents in Workbooks
Storing Workbooks as Parts of Other Office Documents
Curtis D. Frye is the author of several books on Microsoft® Access® and Excel®, including Microsoft® Office Excel® 2007 Step by Step and Microsoft® Office Excel® 2003 Step by Step, along with numerous online training courses.
Comments about oreilly Microsoft® Excel® 2010 Step by Step:
excellent
12/14/2011
1.0
A Digital Copy
By Chet
from Carson City, NV
Pros
Correct Links
Cons
Best Uses
Comments about oreilly Microsoft® Excel® 2010 Step by Step:
The link that you provided in the Text Version of this book does not work for me.
What's UP???
9/9/2011
4.0
Practice Files web addr poorly specified
By Deb Druid
from Denver, Co
Comments about oreilly Microsoft® Excel® 2010 Step by Step:
Right off the bat, the practice files download web address is published such that it could be easily misread. The linkId looks like Linkld (which could be interpreted as an L or a 1 - BUT it is neither it is an I). Lots of folks are getting frustrated with it.
5/3/2011
4.0
Link for Practice Files
By The ole LT
from Greenville, South Carolina
About Me Business User
Pros
Easy to understand
Cons
Best Uses
Intermediate
Comments about oreilly Microsoft® Excel® 2010 Step by Step:
Regarding the link to practice files listed on page xxxiii: go.microsoft.com/fwlink/?LinkId=191751 (make sure you use capital "I")
11/17/2010
(0 of 1 customers found this review helpful)
2.0
Can't find practice files to download
By Keith
from Baltimore, MD
About Me Sys Admin
Pros
Accurate
Concise
Cons
Too many errors
Best Uses
Intermediate
Comments about oreilly Microsoft® Excel® 2010 Step by Step:
I cannot find the practice files online at [@] which is in the book and the learning links in the back do not work either. Google can't even find the files on a site that looks lagitimate.
Merchant response: I'm sorry for the confusion. You can download the practice files from http://go.microsoft.com/fwlink/?Linkid=191751 or http://examples.oreilly.com/9780735626942-files/ or by clicking the Practice Files link in the Essential Links section of this page.