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 functions Features Application Notes,Common Excel Errors, and Chapter Appendices to reinforce readers' grasp of Excel nuances and concepts Includes instructor resources with four tutorial videos, PowerPoint slides for each chapter, sample syllabi, tests, and quizzes.

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 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 Companion files with four Excel video tutorials and images from the text. Instructor resources available.