Get Free Shipping on orders over $79
Excel 2019 Project Book : Spreadsheets • Databases • Case Studies - Gary Bronson

Excel 2019 Project Book

Spreadsheets • Databases • Case Studies

By: Gary Bronson, Jeffrey Hsu

Paperback | 22 October 2021

At a Glance

Paperback


RRP $82.42

$71.75

13%OFF

or 4 interest-free payments of $17.94 with

 or 

Ships in 5 to 7 business days

Designed as a project and case-oriented approach to learning Excel, the emphasis of this book is on learning by doing. The book presents a series of progressively reinforcing problem sets, which allow the exploration of real-life business problems. First, the background, theory, formulas, and calculations are discussed, followed by the design of Excel spreadsheets, which support the creation of effective spreadsheets for these applications. Finally, the proper solution and other related aspects are discussed, forming a cohesive set of practical application problems. Some of the topics explored include amortization tables, weighted averages, cash flows, payroll calculations, break even analysis, and spreadsheet databases. Excel techniques include formulas and functions, cell addressing, conditional and lookup functions, graphs, sorting, and filtering.

FEATURES
  • Provides 30 projects, several How-to Guides, and Application Types to learn Excel skills using problems, applications, and case studies featuring practical business problems
  • Explores formulas and functions, financial functions, cell addressing, conditional functions, lookup functions, graphs, sorting, and filtering, amortization tables, future values of an investment, weighted averages, cash flows, payroll calculations, break even analysis, economic order quantity, spreadsheet databases, and more
  • Companion files with four Excel video tutorials and images from the text. Instructor resources available.


About the Authors

Gary Bronson, Ph.D., is a professor at Fairleigh Dickinson University of information systems with industry and consulting experience and is the author of several books.

Jeffrey Hsu, Ph.D., (Fairleigh Dickinson University, NJ) is a professor of information systems, has published research papers and books, and he has industry experience in the financial and IT sectors.

More in Integrated Software Packages

Microsoft 365 Excel All-in-One For Dummies : Excel for Dummies - David H. Ringstrom
Microsoft 365 Excel For Dummies : For Dummies (Computer/Tech) - David H. Ringstrom
Microsoft 365 Word For Dummies : Word for Dummies - Dan Gookin

RRP $49.95

$38.75

22%
OFF
Microsoft 365 Access For Dummies : Access for Dummies - Laurie A. Ulrich
Microsoft Excel 365 Bible : Bible - Dick  Kusleika

RRP $90.95

$65.75

28%
OFF
Microsoft Power BI Dashboards Step by Step : Step by Step - Errin O'Connor
Microsoft 365 Outlook For Dummies : Outlook for Dummies - Faithe Wempen
Outlook 2016 For Dummies : Outlook for Dummies - Bill Dyszel

RRP $44.95

$35.75

20%
OFF
iWork '09 : The Missing Manual - Josh Clark

RRP $76.00

$39.75

48%
OFF
Switching To The Mac : The Missing Manual - David Pogue

RRP $57.00

$30.75

46%
OFF
Switching to the Mac : The Missing Manual Yosemite Edition - David Pogue
tmux 2 - Brian P. Hogan

Paperback

RRP $41.75

$20.75

50%
OFF
Switching to the Mac : The Missing Manual, Mavericks Edition - David Pogue
Microsoft 365 PowerPoint For Dummies : Powerpoint for Dummies - Doug Lowe
Microsoft Teams For Dummies : For Dummies (Computer/Tech) - Rosemarie Withee
Microsoft 365 Excel Formulas & Functions For Dummies : For Dummies - Ken Bluttman