Excel 2019 Project Book: Spreadsheets • Databases • Case Studies
Bronson PhD, Gary, Hsu PhD, Jeffrey
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 [list]
[*]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
[*]Instructor resources available with four Excel video tutorials and images from the text
[/list]
Brief Table of Contents
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 is the author of several books.
Jeffrey Hsu, Ph.D. (Fairleigh Dickinson University, NJ) is a professor in information systems, has published research papers and books, and he has industry experience in the financial and IT sectors.
Features [list]
[*]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
[*]Instructor resources available with four Excel video tutorials and images from the text
[/list]
Brief Table of Contents
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 is the author of several books.
Jeffrey Hsu, Ph.D. (Fairleigh Dickinson University, NJ) is a professor in information systems, has published research papers and books, and he has industry experience in the financial and IT sectors.
Categories:
Year:
2021
Publisher:
Mercury Learning and Information
Language:
english
Pages:
180
ISBN 10:
1683927699
ISBN 13:
9781683927693
File:
PDF, 21.76 MB
IPFS:
,
english, 2021
Amazon 
Barnes & Noble 
Bookshop.org 
File converter
More search results
More benefits 
![Mejia, Henry E. [Mejia, Henry E.] — EXCEL PIVOT TABLES and PIVOT CHARTS NINJA: Step-by-Step Tutorial on How to Create Amazing Pivot Tables and Pivot Charts in Microsoft Excel!](https://s3proxy.cdn-zlib.se/covers200/collections/userbooks/d8da80f7e292df579ba75c0ae2c5f9999390b631c60f5f3fa2566d555172a911.jpg)
![Cindy Lewis & Carl Chatfield & Timothy Johnson [Lewis, Cindy] — Microsoft Project 2019 Step by Step (Step by Step (Microsoft))](https://s3proxy.cdn-zlib.se/covers200/collections/userbooks/bba1b5a2bf55cfbebe787a5fc90cd04959725e7140546a3fe346a3ba6ff26904.jpg)
Most frequently terms
Related Booklists
