E-Books →EXCEL 2019 PROJECT BOOK Spreadsheets Databases Case Studies

English | 2021 | ISBN: 1683927699 | 180 pages | PDF | 21.76 MB
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.