Excel 2019 Project Book : : Spreadsheets • Databases • Case Studies / / Gary Bronson, Jeffrey Hsu.

• VerfasserIn: Bronson, Gary,; Hsu, Jeffrey,
• Place / Publishing House: Dulles, VA : : Mercury Learning and Information, , [2021]; ©2021
• Year of Publication: 2021
• Language: English
• Physical Description: 1 online resource (175 p.)

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. FEATURES: Provides 30 projects, several How-to Guides, and Application Types to learn 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 moreInstructor resources available with four Excel video tutorials and images from the text.

Table of Contents

Frontmatter -- Contents -- Preface -- About the Authors -- 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