Published:: February 2025
Page Count:: 584
ISBN (Digital):: 978-1-4533-4285-5

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

Version 4.0
By Joseph M. Manzo

Included Supplements

Homework
Manual
Slides
Tests

Key Features

Over 95 embedded streaming videos scripted and recorded by the author explain key operations step-by-step using real spreadsheets, reinforce skill development, and deepen understanding of Excel functions
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 a multidisciplinary business 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)
Exemplary figures, diagrams, and schematics ensure students always understand where they are in a process or sequence
Autogradable spreadsheet assignments are embedded throughout

Educators

Request Examination Copy Read Online Adopt This Book Customize this Book

Students

Online Access Price: $49.95 ($71.40 CAD) Color Printed Textbook with Online Access Price: $76.95 ($110.00 CAD)
Buy This Book Redeem My Code

OVERVIEW
TABLE OF CONTENTS
SUPPLEMENTS
AUTHORS
ADDITIONS & ERRATA

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. Using realistic scenarios, 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.

This book also 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.

New in This Version

New SmartGrader for Excel included in the FlatWorld Homework system:
- Facilitates native spreadsheet assignment grading
- Ensures students stay focused and aligned with real Excel spreadsheets, offering an authentic experience that they’ll use in the professional world
- Integrates seamlessly with actual Excel files and with popular Learning Management Systems
- Helps students learn practical skills with the full range of current Excel functionality, avoiding the limitations of look-alike platforms
- Provides students an opportunity for hands-on experience with current software—truly preparing them for real-world tasks
Updated images and videos fully reflect Excel 365
New coverage of the XLOOKUP function’s use and application
Covers using entire column capacity in functions
Introduces the concept of dynamic arrays for formulas and functions
Explains and models the use of dynamic array formulas
New End-of-Chapter cases and revised tests fully reflect all new material

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

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.

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

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.

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

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

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

Solutions manuals, sample exams, video learning segments, workbooks, cases and lab manuals are just some of the extras our books will offer depending on the needs of the course. Click here to see what this textbook offers.

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.

Already registered? Sign in here

Joseph M. Manzo Lehigh University

Joseph M. Manzo (CMA and MBA Lehigh University) is Full Teaching Professor in Accounting at Lehigh University’s College of Business. He developed and oversaw the Microsoft Excel Competency program for all first-year business students in addition to teaching Introduction to Financial Accounting and Introduction to Managerial Accounting. Joseph is the former director of the Rauch Center for Business Communications and former acting Associate Dean and Director of Undergraduate Programs for the College of Business. Prior to Lehigh, Joseph 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 also written several textbooks addressing practical applications for Microsoft Office that teach students how to use such applications for professional and personal needs.

Additions & Errata

3/6/25:

Section 9.5: Updated Chapter_9_DA_Exercise_2.xlsx.

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