Excel 2019 Project Book

Spreadsheets • Databases • Case Studies

Paperback
October 2021
9781683927693
More details
  • Publisher
    Mercury Learning and Information
  • Published
    22nd October
  • ISBN 9781683927693
  • Language English
  • Pages 175 pp.
  • Size 8.5" x 11"
  • Request Exam Copy
$49.95
E-Book (ePub)
September 2021
9781683927679
More details
  • Publisher
    Mercury Learning and Information
  • Published
    29th September
  • ISBN 9781683927679
  • Language English
  • Pages 175 pp.
  • Size 8.5" x 11"
  • Request E-Exam Copy
$39.95
Lib E-Book

Library E-Books

We are signed up with aggregators who resell networkable e-book editions of our titles to academic libraries. These editions, priced at par with simultaneous hardcover editions of our titles, are not available direct from Stylus.

These aggregators offer a variety of plans to libraries, such as simultaneous access by multiple library patrons, and access to portions of titles at a fraction of list price under what is commonly referred to as a "patron-driven demand" model.

September 2021
9781683927686
More details
  • Publisher
    Mercury Learning and Information
  • Published
    29th September
  • ISBN 9781683927686
  • Language English
  • Pages 175 pp.
  • Size 8.5" x 11"
$129.95

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 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.

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

Gary Bronson, PhD

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.

Jeffrey Hsu, PhD

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.

computer science; data analytics; Microsoft Office; Excel; financial functions; formulas; database; business