Please note: In order to keep Hive up to date and provide users with the best features, we are no longer able to fully support Internet Explorer. The site is still available to you, however some sections of the site may appear broken. We would encourage you to move to a more modern browser like Firefox, Edge or Chrome in order to experience the site fully.

Excel 2019 Project Book : Spreadsheets • Databases • Case Studies, PDF eBook

Excel 2019 Project Book : Spreadsheets • Databases • Case Studies PDF

PDF

Please note: eBooks can only be purchased with a UK issued credit card and all our eBooks (ePub and PDF) are DRM protected.

Description

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.

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

  • Instructor resources available with four Excel video tutorials and images from the text.

Information

Other Formats

Information