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 arediscussed, 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.\nFEATURES: 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.

Excel 2019 Project Book: Spreadsheets • Databases • Case Studies

Computers & Technology

Bronson PhD, Gary

Hsu PhD, Jeffrey

Software

Mercury Learning and Information

Product Description Created as a book for a first-time or beginning Excel user, it is designed to be a comprehensive, yet accessible and easy to understand introduction to using and mastering Microsoft Excel 2019 and previous versions. Starting with the basics of what spreadsheets are, and progressing through the foundational concepts and features of Excel, the book provides a thorough, yet user-friendly introduction to the main capabilities of Excel. The book covers the most fundamental and important aspects of Excel, which form the basis for a solid foundation in the use of this critical software application. Suitable for professional reference, self-study, or for use in an instructor-led or online course, this book will help readers to become effective and knowledgeable in using one of the most useful tools for enhancing one’s business and personal productivity.FEATURES:Starts with the elements, layout, and structure of Excel, followed by formulas, functions, applications, and formatting in depth Provides both presentations, such as charts/graphs, PivotTables and also spreadsheet features including sorting, filtering, subtotals, and database functionsFeatures Application Notes,Common Excel Errors, and Chapter Appendices to reinforce readers’ grasp of Excel nuances and conceptsIncludes instructor resources with four tutorial videos, PowerPoint slides for each chapter, sample syllabi, tests, and quizzes. About the Author 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.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.

Excel Basics: Foundations • Formulas • Graphs

See the best price to sell, buy, or rent books by Hsu PhD, Jeffrey. BookScouter helps to compare book prices from 25+ online bookstores and 30+ buyback vendors with a single search.

Books by Hsu PhD, Jeffrey

See the best price to sell, buy, or rent books by Hsu PhD, Jeffrey. BookScouter helps to compare book prices from 25+ online bookstores and 30+ buyback vendors with a single search.

Excel 2019 Project Book: Spreadsheets • Databases • Case Studies

Excel Basics: Foundations • Formulas • Graphs