Synopses & Reviews
Introduce your students to the new generation of Microsoft Office with the new generation of Shelly Cashman Series books! For the past three decades, the Shelly Cashman Series has effectively introduced computer skills to millions of students. With Excel 2007, we're continuing our history of innovation by enhancing our proven pedagogy to reflect the learning styles of today's students. In Microsoft Excel 2007: Comprehensive Concepts and Techniques you'll find features that are specifically designed to engage students, improve retention, and prepare them for future success. Our trademark step-by-step, screen-by-screen approach now encourages students to expand their understanding of the Excel 2007 software through experimentation, exploration, and planning ahead. Brand new end of chapter exercises prepare students to become more capable software users by requiring them to use critical thinking and problem-solving skills to create real-life documents.
Ideal for an overview of Microsoft Excel covering the new features of the Office 2007 software.
Microsoft Office Excel 2010: Comprehensive provides a project-based, step-by-step approach to successfully teach students Microsoft Excel 2010 skills.
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.
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. Thomas J. Cashman received his education at California State University, Los Angeles. He established one of the first business data processing programs in the U.S. at Long Beach City College in California, where he taught and served as department head. In 1969, he began collaborating with now best-selling author, Gary Shelly. 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
1. Creating a Worksheet and an Embedded Chart 2. Formulas, Functions, Formatting, and Web Queries 3. What-If Analysis, Charting, and Working with Large Worksheets Web Feature: Creating Web Pages Using Excel 4. Financial Functions, Data Tables, and Amortization Schedules 5. Creating, Sorting, and Querying a Table 6. Creating Templates and Working with Multiple Worksheets and Workbooks Graphics Feature: SmartArt and Images 7. Using Macros and Visual Basic for Applications (VBA) with Excel 8. Formula Auditing, Data Validation, and Complex Problem Solving 9. Importing Data, Working with PivotCharts, PivotTables, and Trendlines Collaboration Feature: Using SharePoint and Excel Services Appendices A: Project Planning Guidelines B: Introduction to Microsoft Office 2007 C: Microsoft Office Excel 2007 Help D: Publishing Office 2007 Web Pages to a Web Server E: Customizing Microsoft Office Excel 2007 F: Steps for the Windows XP User G: Microsoft Business Certification Program