Microsoft® Excel® 2010

Gary B. Shelly wrote and published his first computer education textbook in 1969. More than twenty million copies of Shelly Cashman Series' textbooks have been sold. Gary and a talented group of contributing authors have produced books on computer programming, computer concepts, and application software that are the leading textbooks in the computer technology market today. Gary has hosted the annual Shelly Cashman Institute, a week-long training event focusing on the latest topics in technology, for the past 34 years. Jeffrey J. Quasney has worked with the Shelly Cashman Series for more than 9 years in various capacities, including as a developer of teaching tools associated with the Series' textbooks. He has authored several textbooks, including Visual Basic .NET, Microsoft Office FrontPage 2003, several editions of Microsoft Office Excel, and is a contributing author for Discovering Computers and Discovering Computers: Fundamentals Edition.

1. Creating a Worksheet and an Embedded Chart.
2. Formulas, Functions, and Formatting.
3. What-If Analysis and Working with Large Worksheets.
4. More Charting, Web Apps, Excel Web Pages, Web Queries, and Collaboration.
5. Financial Functions, Data Tables, and Amortization Schedules.
6. Creating, Sorting, and Querying a Table.
7. Working with Multiple Worksheets and Workbooks.
8. Creating Templates and Importing Data and Working with SmartArt and Images.
9. PivotTables, PivotCharts, and Trendlines.
10. Formula Auditing, Data Validation, and Complex Problem Solving.
11. Using Macros and Visual Basic for Applications in Excel.
Appendices.
A: Project Planning Guidelines.
B: Publishing Office 2010 Web Pages Online.
C: Saving to the Web Using Windows Live SkyDrive.