Excel 2019 Project Book: Spreadsheets, Databases, and Case Studies

Price: $29.99

(as of May 21,2023 02:54:46 UTC – Details)

Excel 2019 Project Book: Spreadsheets, Databases, and Case Studies offers a project and case-oriented approach to learn Excel. The book emphasizes the concept of learning by doing.

The book offers a series of problem sets progressively reinforced, allowing exploration of real-life business problems. It first discusses background, theory, formulas, and calculations, followed by the design of Excel spreadsheets, which supports the creation of effective spreadsheets for applications.

Excel techniques explored by the book include formulas and functions, cell addressing, conditional and lookup functions, graphs, sorting, and filtering. The book also provides 30 projects, step-by-step guides, and application types to learn Excel skills using problems, applications, and case studies with practical business problems.

Some topics explored by the book include amortization tables, weighted averages, cash flows, payroll calculations, break-even analysis, and spreadsheet databases.

Instructor resources are available with four Excel video tutorials and images from the text. A brief table of contents includes Project Set 1: Simple Spreadsheets Using Basic Excel Capabilities. Project Set 2: Absolute Addressing. Project Set 3: Cash Flow Projects. Project Set 4: Simple Decisions Using the IF( ) Function. Project Set 5: Making Multiple Choices Using VLOOKUP( ). Project Set 6: Applications and Graphing. Project Set 7: Database Projects. How-to Guides. Basic Application Types. Index.

About The Authors: Gary Bronson, Ph.D. (Fairleigh Dickinson University, NJ) is a professor in information systems with industry and consulting experience and has authored several books. Jeffrey Hsu, Ph.D. (Fairleigh Dickinson University, NJ) is a professor in information systems, has published research papers and books, and has industry experience in financial and IT sectors.

ASIN: B09GZ9DDHV

Publisher: Mercury Learning and Information (September 22, 2021)

Publication Date: September 22, 2021

Language: English

File Size: 22579 KB

Text-to-Speech: Enabled

Screen Reader: Supported

Enhanced Typesetting: Enabled

X-Ray: Not Enabled

Word Wise: Not Enabled

Print Length: 220 Pages