Excel 2019 Project Book: Spreadsheets • Databases • Case Studies
- 1h 23m
- Gary Bronson PhD, Jeffrey Hsu PhD
- Mercury Learning
- 2021
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.
In this Book
-
Calculating a Grade Average
-
Calculating Net Pay
-
Calculating Charges for Service
-
An Amortization Schedule – Part I
-
The Future Value of Invested Funds
-
Useful Spreadsheet Functions
-
Using an Absolute Address
-
An Amortization Schedule – Part II
-
Calculating Weighted-Average Grades
-
Calculating Miles per Gallon (mpg)
-
Net Cash Inflows
-
A Cash Balance Spreadsheet
-
A Cash Flow Budget
-
A Cash Flow Budget with Loan Repayment
-
A Second Cash Flow Budget
-
Computing Pass/Fail Grades
-
Calculating Pay with Overtime
-
Payroll After Deductions
-
Cash Flow Budget with Conditional Loan Repayment
-
Determining a Letter Grade
-
Determining a Discount
-
Using Multiple Lookup Tables
-
Using One Lookup Table Multiple Times
-
Break-Even Analysis and Line Graphs
-
Economic Order Quantity and Line Graphs
-
Sorting a Database Spreadsheet
-
Searching a Database Spreadsheet
-
Database Functions
-
Creating Subtotal Groups
-
Creating Nested Subtotal Groups
-
Creating a Professional Spreadsheet Layout
-
Printing in Landscape and Fit-to-Page Modes
-
Highlighting Cells
-
Copying Cell Contents
-
Creating Line Graphs
-
Creating Scatter Diagrams and Trend Lines
-
Transferring Data Between Spreadsheets
-
Restricting Cell Access
SHOW MORE
FREE ACCESS
