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.

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