Excel 2019 Project Book: Spreadsheets • Databases • Case Studies

by: Gary Bronson (author) & Jeffrey Hsu (author) (Author)

Publisher: Mercury Leaing and Information

Publication Date: 30 Dec. 2021

Language: English

Print Length: 175 pages

ISBN-10: 1683927699

ISBN-13: 9781683927693

Book Description

Designed as a project and case-oriented approach to leaing Excel, the emphasis of this book is on leaing 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.FEATURESProvides 30 projects, several How-to Guides, and Application Types to lea Excel skills using problems, applications, and case studies featuring practical business problemsExplores 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 moreCompanion files with four Excel video tutorials and images from the text. Instructor resources available.
About the Author Bronson Gary : 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.Hsu Jeffrey : 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.