• Step-by-step, screen by screen approach presents students with explanatory and navigational information when they need to know it, and addresses all learning styles to help students retain and apply skills in their personal and professional lives.
• Proven pedagogy with an emphasis on project planning frames each chapter around a practical problem to be solved, and encourages critical thinking about how to proceed at various points in the chapter.
• Extensive end-of-chapter activities provide a variety of reinforcement opportunities for students to apply and expand their skills.
• Now, when students complete projects they are told WHY each step in the process is necessary, in addition to being told what they will be doing and how to accomplish each task.
• New mini-roadmaps are provided throughout each chapter, visually showing students where they are in the process of completing the chapter project.
• Critical thinking has been expanded throughout the text. Consider This boxes throughout each chapter provide thought-provoking questions and problem-solving activities. Chapter-ending Consider This: Plan Ahead boxes and Consider This: Your Turn assignments engage students in critical thinking and problem-solving skills to create their own solutions. Plus, every student assignment ends with a question that requires students' thoughts and opinions.
• New emphasis on personalization asks students to include a personal detail in their solutions to every chapter project and assignment, ensuring that each student solution will be unique.
• New lab on integrating Cloud and Web technologies with Microsoft Excel challenges students to use general guidelines to learn and investigate independently.
• New Analyze, Correct, Improve assignment requires students to analyze an Excel workbook, correct errors, and make improvements based on knowledge acquired from the chapter content.
• Chapter topic redistribution offers concise chapters that ensure complete skill coverage.

Office 2013 and Windows 8: Essential Concepts and Skills.

Office 365 Essentials.

1. Creating a Worksheet and a Chart.

2. Formulas, Functions, and Formatting.

3. Working with Large Worksheets, Charting, and What-If Analysis.

4. Working with Multiple Worksheets and Workbooks.

5. Financial Functions, Data Tables, and Amortization Schedules.

6. Creating, Sorting, and Querying a Table.

7. Creating Templates, Manipulating Data, and Adding Additional Enhancements to a Worksheet.

8. Working with Trendlines, Pivot Table Reports, PivotChart Reports, and Slicers.

9. Formula Auditing, Data Validation, and Complex Problem Solving.

10. Using Macros and Visual Basic for Applications (VBA) with Excel.

11. Collaboration Features for Workbooks.

Certification Appendix.

Index.

Quick Reference.

Important Notes for Windows 7 Users.

Steven M. Freund

Steven M. Freund attended the University of Central Florida and serves as a leader instructor of various Microsoft® Office, computer concepts, programming, and Internet technology courses throughout Central Florida. An integral author for the successful Shelly Cashman Series since 2001, he has presented at the annual customer conference, the Shelly Cashman Series Institute, as well as other customer events. Mr. Freund has co-authored multiple editions of DISCOVERING COMPUTERS, Mozilla Firefox, Windows® Internet Explorer, Windows®, Office, and Dreamweaver books. He has also written numerous successful instructor supplements.

Mali Jones

Mali B. Jones has more than 20 years of editorial, instructional and support experience in the field of computer and information technology. She has been associated with the Shelly Cashman Series for nearly 10 years, providing editorial, authoring, and product management services.

Joy L. Starks

Joy L. Starks is a Professor of Computer and Information Technology at Indiana University Purdue University Indianapolis. She has written chapters in several of the Shelly Cashman Series Office books and authored the Photoshop, Java Programming, and Microsoft Publisher series of books. As well as speaking engagements, she also hosts the nationally-renowned Tech Camp for Teachers on the IUPUI campus each summer.