Synopses & Reviews
In Microsoft Excel 2007: Comprehensive Concepts and Techniques you?ll find features that are specifically designed to improve retention, and prepare readers for future success. Our trademark step-by-step, screen-by-screen approach now encourages readers to expand their understanding of the Access 2007 software through experimentation, exploration, and planning ahead.
Microsoft Office Excel 2010: Comprehensive provides a project-based, step-by-step approach to successfully teach students Microsoft Excel 2010 skills.
About the Author
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.
Table of Contents
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.