Description: Develop the Microsoft® Excel 2013 skills you need for success in college and beyond with this latest edition from the popular New Perspectives Series. Updated with all-new case-based tutorials, NEW PERSPECTIVES MICROSOFT® EXCEL 2013, COMPREHENSIVE ENHANCED EDITION continues to apply MS Excel 2013 skills to real situations that fully demonstrate the relevance of concepts. A proven learning approach emphasizes critical thinking, problem-solving, and in-depth coverage. A new Troubleshoot case problem enhances analytical skills, while a new tutorial on Managing Your Files helps you navigate Windows 8. A wealth of resources, including MindTap and SAM, provides opportunities to practice skills. Discover success with MS Excel 2013 as NEW PERSPECTIVES MICROSOFT® EXCEL 2013 helps you fully understand the value and application of what you're learning. Product Benefits: - NEW STUDENT SUCCESS GUIDE PROVIDES HELPFUL INSIGHTS, TOOLS AND TECHNIQUES. This useful Guide offers content essential to your students' success in the classroom with a special focus on effective planning, time management, and study tools. The Guide emphasizes Microsoft® OneNote, in particular, to increase students' overall effectiveness.
- NEW SAM PROJECTS APPENDIX HIGHLIGHTS INSTRUCTIONS FOR NEW PROJECTS THAT CORRESPOND WITH THIS EDITION. You'll find printed instructions for a new instructor-authored SAM Project that corresponds to the new content in this edition.
- NEW CAPSTONE PROJECTS APPENDIX PROVIDES THREE NEW PROJECTS TO CHALLENGE STUDENTS. These thought-provoking projects encourage students to apply the Excel concepts and skills they've learned with three levels of content: Introductory (Tutorials 1-4), Intermediate (Tutorials 5-8), and Advanced (Tutorials 9-12).
- NEW MICROSOFT® OFFICE SPECIALIST CERTIFICATION APPENDIX PROVIDES AN INVALUABLE REFERENCE TOOL. This new appendix highlights key information about the certification program with a table that indicates where applicable certification skills are covered in this edition. This information is vital for students pursuing the Microsoft® Office Specialist Core and Expert Exams for Excel 2013.
- BUSINESS CASE SCENARIOS PROVIDE A REAL-WORLD CONTEXT FOR CONCEPTS. These intriguing scenarios keep students engaged throughout the tutorials as they provide a real-world context in which students can apply the Excel concepts and skills they are learning.
- TWO-PAGE VISUAL OVERVIEWS INTRODUCE KEY ELEMENTS OF EACH TUTORIAL. This dynamic two-page graphic spread at the beginning of each tutorial previews the Excel tasks and elements the tutorial will address. These Overviews can serve as a useful study guide before quizzes and tests.
- PROSKILLS BOXES DEMONSTRATE THE RELEVANCY OF EXCEL 2013 CONCEPTS TO CAREERS. These features provide guidance on how to most effectively use Excel software in professional situations.
- PROSKILLS EXERCISES INTEGRATE TECHNOLOGY SKILLS WITH PROFESSIONAL SKILLS. These exercises further ground concepts in today's business reality. ProSkills Exercises focus on relevant topics, such as teamwork, written communication, verbal communication, problem solving, and decision making.
- KEY STEPS HIGHLIGHT IMPORTANT POINTS IN COMPLETING WORK CORRECTLY. This helpful feature guides students in paying close attention in order to accomplish each step the right way and avoid any time-consuming re-work.
Table of Contents: Student Success Guide.
Managing Your Files.
Tutorial 1: Getting Started with Excel.
Tutorial 2: Formatting Workbook Text and Data.
Tutorial 3: Calculating Data with Formulas and Functions.
Tutorial 4: Analyzing and Charting Financial Data.
Tutorial 5: Working with Excel Tables, PivotTables, and PivotCharts.
Tutorial 6: Managing Multiple Worksheets and Workbooks.
Tutorial 7: Developing an Excel Application.
Tutorial 8: Working with Advanced Functions.
Tutorial 9: Exploring Financial Tools and Functions.
Tutorial 10: Performing What-If Analyses.
Tutorial 11: Connecting to External Data.
Tutorial 12: Collaborating on a Shared Workbook.
Additional Cases.
Appendix A: Working with Text Functions and Creating Custom Formats.
Appendix B: Advanced Filters, Database Functions, and Summary IFS Functions.
Appendix C: Enhancing Excel with Visual Basic for Applications.
Appendix D: Working with Enhanced Formatting Tools.
Appendix E: SAM Projects.
Appendix F: Capstone Projects.
Appendix G: Microsoft Office Specialist Certification. |
