Cookies help us deliver our services. By using our services, you agree to our use of cookies. Learn more
Just Published
Cover of Data Analytics Using Excel® Microsoft® 365: With Accounting and Finance Datasets (with SmartGrader for Excel) v3.0
Published
December 2024
Page Count
558
ISBN (Digital)
979-8-88794-617-7

Data Analytics Using Excel® Microsoft® 365: With Accounting and Finance Datasets (with SmartGrader for Excel)

Version 3.0
By Joseph M. Manzo

Included Supplements

Homework icon Homework

Key Features

  • This version aligns 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.

Educators

Request Examination Copy Read Online Adopt This Book Customize This Book

Students

Online Access Price
$49.95 ($45.66 CAD)
Color Printed Textbook with Online Access Price
$76.95 ($77.41 CAD)
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. 

This book includes SmartGrader for Excel, which allows students to complete Excel homework assignments using the standard online or desktop versions of Excel. Students then upload their workbook to SmartGrader for grading and feedback on their solutions. SmartGrader for Excel is integrated into FlatWorld Homework system so all normal homework features are available including LMS and gradebook integration.

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. 

New in This Version

  • SmartGrader ensures students stay focused and aligned with real Excel spreadsheets, offering an authentic experience that they’ll use in the professional world
  • SmartGrader integrates seamlessly with actual Excel files and with popular Learning Management Systems
  • Students learn practical skills with the full range of current Excel functionality, functions, and workflows, avoiding the limitations of look-alike platforms
  • With SmartGrader, students gain hands-on experience, with current software, truly preparing them for real-world tasks

In Progress

  • All instructor supplements will be available by January 6, 2025.
  • Homework system for this title will be live by January 6, 2025.

FlatWorld Homework icon

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.

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. 

Confirmation

Are you sure?