Cookies help us deliver our services. By using our services, you agree to our use of cookies. Learn more
Skip to content
Cover of Applying Data Analytics for Sustainable Business Using Excel 365 v3.0.1
Published: 
July 2021
Page Count: 
790
ISBN (Digital): 
978-1-4533-3979-4

Applying Data Analytics for Sustainable Business Using Excel 365

Custom Version 3.0.1
By Joseph M. Manzo
Adapted by Terila Johnson

Included Supplements

Key Features

  • This version is updated to align with Excel Microsoft 365.
  • Early chapters explain how to conceptualize, design, and maintain the integrity of data analytics projects in any context, not just finance or accounting. Compatible with general technology courses that are not content specific.  
  • Can be used stand alone or as a supplemental resource.
  • Datasets and projects are compatible with many accounting and finance courses, but can also support an interdisciplinary focus.
  • Clearly and simply walks students through core concepts. No prior accounting or finance coursework is required.
  • Encourages students to develop data visualization skills and to manipulate large datasets using keyboard commands only (rather than a mouse).
  • Spreadsheet-based assignments are linked to FlatWorld Homework to facilitate autograding. Students download spreadsheets from a link in the digital reader, complete them in Excel, and then match specific cells to correlated questions in FlatWorld Homework’s autograded environment. This allows for the use of authentic Excel-based assignments without the need for manual grading.

Students

Online Access Price:  $36.95 Color Printed Textbook with Online Access Price:  $88.95
Buy This Book Redeem My Code

This textbook is suitable as either a core text for using Excel Microsoft 365 in an introductory data analytics course or as a supplement to basic through intermediate accounting or finance courses. It may also be assigned to students who need exposure or a refresher on how to use the Excel Microsoft 365 application in general. 

Data Analytics Using Microsoft 365 Excel: With Accounting and Finance Datasets provides students with the opportunity to learn basic skills needed to execute many personal and professional activities using Excel Microsoft 365. This clear, easy-to-follow text explains how to analyze and make discoveries in datasets by treating data visualization skills as a vital component of the analytics process. It also prepares learners to master more advanced skills using Excel. Heavy emphasis is placed on how to efficiently navigate big datasets and use the keyboard to access commands during the design process. 

Extensive datasets included in the book are drawn from accounting and finance scenarios. They provide learners with a basis for conceptualizing and designing data analytics projects with the highest level of integrity. Author-narrated videos embedded throughout the digital reader explain concepts and operations, adding an engaging audio and visual richness to the written explanations and exercises. 

Chapter 1: Introduction to Data Analytics and Microsoft Excel 365

  • 1.1 A Working Model for Data Analytics
  • 1.2 A Review of Excel 365
  • 1.3 Chapter Assignments and Tests

    • Chapter 2: Essential Skills for Basic Data Analytics Projects

  • 2.1 Entering and Managing Data
  • 2.2 Formatting Worksheets
  • 2.3 Chapter Assignments and Tests

    • Chapter 3: Data Analytics Techniques for Basic Projects

  • 3.1 Introduction to Data Visualization
  • 3.2 Introduction to PivotTables and PivotCharts
  • 3.3 Chapter Assignments and Test

    • Chapter 4: Using Mathematical Outputs for Analytics

  • 4.1 Formulas
  • 4.2 Basic Statistics Functions
  • 4.3 Chapter Assignments and Test

    • Chapter 5: Scenario Analytics

  • 5.1 Loan and Lease Scenarios
  • 5.2 Investment Scenarios
  • 5.3 Chapter Assignments and Test

    • Chapter 6: Exception Analytics

  • 6.1 Logical Functions
  • 6.2 Lookup Functions
  • 6.3 Chapter Assignments and Test

    • Chapter 7: Summarizing Exception Analytics

  • 7.1 Statistical IF Functions
  • 7.2 Statistical IFS Functions
  • 7.3 Chapter Assignments and Test

    • Chapter 8: Working with Big Datasets Case: Investigating Fraud

  • 8.1 Using the DATA Analytics Framework
  • 8.2 Data Audit Using PivotTables
  • 8.3 Analyzing the Data
  • 8.4 Summarizing Big Datasets in Custom Reports
  • 8.5 Establishing Data Internal Controls
  • 8.6 Chapter Assignments and Test

    • Chapter 9: Charts for Presentations and Data Visualization

  • 9.1 Chart Types
  • 9.2 Formatting Enhancements for Charts
  • 9.3 Using Charts in PowerPoint and Word
  • 9.4 The Scatter Chart and Motion Data Visualization
  • 9.5 Chapter Assignments and Test

    • Chapter 10: Predictive Analytics Case: Can You Predict the Stock Market?

  • 10.1 Assessing the Case
  • 10.2 Preliminary Analysis: Examining Assumptions
  • 10.3 Solving the Case
  • 10.4 Case Wrap Up: Prediction versus Reality
  • 10.5 Chapter Assignments and Tests

    • Chapter 11: Introduction to Sustainable Business and Sustainable Business Core Concepts and Frameworks

  • 11.1 Introduction
  • 11.2 Overview of Sustainable Business
  • 11.3 What Does It Mean to Be a Sustainable Business?
  • 11.4 What Is Required for a Sustainability Perspective?
  • 11.5 The Business Case for Sustainability
  • 11.6 A Strategic Approach to Sustainable Business Practice

    • Chapter 12: Accountability for Sustainability

  • 12.1 Overview
  • 12.2 Sustainability Reporting
  • 12.3 Sustainability Reporting Process
  • 12.4 Sustainability Reporting Guidelines and Frameworks
  • 12.5 Certification
  • 12.6 Life Cycle Management and Sustainability
  • 12.7 Conclusion

    • Chapter 13: Entrepreneurship, Innovation, and Sustainable Business

  • 13.1 Introduction
  • 13.2 Overview of Entrepreneurship
  • 13.3 The Keys to Successful Sustainability Entrepreneurship
  • 13.4 Innovation and Sustainability
  • 13.5 Conclusion

    • Chapter 14: Case: Sustainable Business Entrepreneurship: Simply Green Biofuels

  • 14.1 Introduction to Simply Green
  • 14.2 Biodiesel
  • 14.3 The Challenges and Overcoming Them
  • 14.4 Getting the Business Off the Ground
  • 14.5 The Keys to Success
  • 14.6 Why No Profits?
  • 14.7 Limits of Always Focusing on Doing the Right Thing
  • 14.8 Conclusion
  • 14.9 Appendix: Simply Green Timeline

    • Chapter 15: Case: Oakhurst Dairy: Operations Management and Sustainability

  • 15.1 Overview
  • 15.2 Introduction
  • 15.3 Greenhouse Gases (GHGs) and the US Dairy Industry
  • 15.4 Oakhurst: Improving Business Value through Sustainable Practice
  • 15.5 Going Forward: Opportunities and Challenges

    • Chapter 16: Case: Brewing a Better World: Sustainable Supply Chain Management at Green Mountain Coffee Roasters, Inc.

  • 16.1 Introduction
  • 16.2 Green Mountain’s Sustainable Business Model
  • 16.3 The Coffee Industry’s Supply Chain
  • 16.4 Sustainability and Corporate Social Responsibility at Green Mountain Coffee Roasters, Inc.
  • 16.5 Going Forward

    • Chapter 17: Case: Marketing Sustainability: Seventh Generation Creating a Green Household Consumer Product

  • 17.1 Introduction
  • 17.2 Marketing Focus on the Triple Bottom Line: People, Planet, and Profit
  • 17.3 Taking Seventh Generation to the Next Level: The Challenge Ahead

    • Chapter 18: Case: Accounting for Sustainability: How Does Timberland Do It and Why?

  • 18.1 Introduction
  • 18.2 Sustainability Reporting at Timberland
  • 18.3 Business Value of Sustainability Reporting
  • 18.4 Looking Forward: New Corporate Parent and New Corporate Social Responsibility Leader

    • Chapter 19: Case: Sustainable Investing: Pax World Helping Investors Change the World

  • 19.1 For Tomorrow
  • 19.2 Introduction to Socially Responsible Investing (SRI)
  • 19.3 Pax World
  • 19.4 Pax World’s Approach to Investing
  • 19.5 Pax World Looking Forward

    • Chapter 20: Case: Strategic Mission–Driven Sustainable Business: Stonyfield Yogurt

  • 20.1 Introduction
  • 20.2 Stonyfield Farm: A Sustainability-Focused Start-Up
  • 20.3 Stonyfield’s Social Mission
  • 20.4 Organics and Natural Foods Industry
  • 20.5 Stonyfield’s Strategy and Execution
  • 20.6 Moving On
  • 20.7 Conclusion

    • Appendix A: Keyboard Only Commands from PC to Mac

    Appendix B: Visual Differences between PC and Mac

  • B.1 Visual Differences on the Ribbon
  • B.2 ToolTip and Dialog Box Differences

    • Appendix C: Command and Feature Differences on a Mac

  • C.1 Accessing Backstage Commands
  • C.2 The Right-Click Menu
  • C.3 Multi-Level Sorting
  • C.4 Sorting Data in a PivotTable
  • C.5 Charts: Assigning Data to X and Y Axes
  • C.6 Conditional Formatting: New Formatting Rule

    • Appendix D: Command and Feature Omissions on a Mac

    FlatWorld Homework System

    FlatWorld Homework

    FlatWorld Homework includes multi-format questions written specifically for your FlatWorld book, which you can access through our stand-alone interface or integrate with your learning management system.

    Request a demo

    In order to give you the best experience, it is important that we have accurate data about your correct school. If you are unable to find the correct school above, please enter the name and web address here so that we can add it to our system.



    Instructor’s Manual

    Instructor’s Manual

    The Instructor’s Manual guides you through the main concepts of each chapter and important elements such as learning objectives, key terms, and key takeaways. Can include answers to chapter exercises, group activity suggestions, and discussion questions.

    PowerPoint Lecture Notes

    PowerPoint Lecture Notes

    A PowerPoint presentation highlighting key learning objectives and the main concepts for each chapter are available for you to use in your classroom. You can either cut and paste sections or use the presentation as a whole.

    PowerPoint Lecture Notes

    Test Generator - powered by Cognero

    Test Generator - powered by Cognero

    FlatWorld has partnered with Cognero, a leading online assessment system, that allows you to create printable tests from FlatWorld provided content.

    Test Bank Files for Import to Learning Management Systems

    Test Bank Files for Import to Learning Management Systems

    For your convenience, we've packaged our test items for easy import into Learning Management Systems like Blackboard, Brightspace/D2L, Canvas, Moodle, or Respondus.

    Test Item File

    Test Item File

    Need assistance in supplementing your quizzes and tests? Our test-item files (in Word format) contain many multiple-choice, fill-in-the-blank, and short-answer questions.

    Other Supplements

    Other Supplements

    All of the End-of-Chapter exercises can be found and downloaded from the student book and they are also compiled in the Manzo_Excel_v3_0_End_of_Chapter_Exercise_Files.zip file. The solution files for the End-of-Chapter exercises are available to instructors only in the Manzo_Excel_v3_0_End_of_Chapter_Exercise_Solutions.zip file. Each project that is covered in the textbook has a follow along file which can be found in the “Manzo_Excel_v3_0_Text_Files.zip file. Follow along files that end with a zero after the decimal point are intended to be posted for students and these files are also available for download in the student book. Follow along files that have a 1 or higher after the decimal should NOT be posted for students unless you are skipping earlier topics for the project. These follow along files will have all of the work completed for the set of topics up to certain points in the project.

     

    At FlatWorld, we take pride in providing a range of high-quality supplements alongside our titles, to help instructors teach effectively. Supplements are available for instructors who have registered their adoption with us. If you need to review or preview something specific, please contact us.


    Sign up for FlatWorld

    Already registered? Sign in here

    Joseph M. Manzo Lehigh University

    Joseph M. Manzo (CMA and MBA Lehigh University) is Professor of Practice in Accounting at Lehigh University’s College of Business. He started teaching at Lehigh in fall 2002 where he developed and oversaw the Microsoft Excel Competency program for all first year business students. He went on to teach several courses in both the undergraduate and graduate programs in the College of Business and since 2010 has taught Introduction to Financial Accounting and Introduction to Managerial Accounting.  In addition to teaching, he is a former director of the Rauch Center for Business Communications and also former acting Associate Dean and Director of Undergraduate Programs for the College of Business. Prior to Lehigh, Professor Manzo worked in apparel manufacturing, retail, and wealth management industries. His industry practice had a heavy emphasis on data analytics and corporate strategic planning. He has written several textbooks addressing practical applications for Microsoft Office that teach students how to use such applications for professional and personal needs. 

    Back to top