×
Excel 2019 Project Book
Spreadsheets • Databases • Case Studies
Paperback
October 2021
9781683927693
More details
- Publisher
Mercury Learning and Information - Published
22nd October 2021 - ISBN 9781683927693
- Language English
- Pages 175 pp.
- Size 8.5" x 11"
- Request Exam Copy
$49.95
E-Book
E-books are now distributed via VitalSource
VitalSource offer a more seamless way to access the ebook, and add some great new features including text-to-voice. You own your ebook for life, it is simply hosted on the vendor website, working much like Kindle and Nook. Click here to see more detailed information on this process.
September 2021
9781683927679
More details
- Publisher
Mercury Learning and Information - Published
29th September 2021 - ISBN 9781683927679
- Language English
- Pages 175 pp.
- Size 8.5" x 11"
- Request E-Exam Copy
$49.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 2021 - 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