| Title | : | Building Business Spreadsheets using Excel |
| Author | : | |
| Rating | : | |
| ISBN | : | 189111252X |
| ISBN-10 | : | 9781891112522 |
| Language | : | English |
| Format Type | : | Paperback |
| Number of Pages | : | 233 |
| Publication | : | First published May 5, 1998 |
How to build business spreadsheets like a pro. Problem-based learning builds skills through real-life problems. Learn Excel's best features for working accurately and efficiently. Tips and checklists Check work for accuracy and integrity
Find and solve common errors
Give spreadsheets a professional look
Solve printing problems
Structure spreadsheets to answer business's common "what-if" questions CONTENTS Part 1: Learn Excel From the Ground UP Understand Excel's screen and how to use it most efficiently. Use Excel's fastest and most accurate procedures Enter, edit and copy data
Create and copy formulas
Format and print spreadsheets Part 2: Build Business Spreadsheets A problem-solving approach based on realistic business Calculation of percentages, markups, discounts, and prices
Financial Present and Future value, Net Present Value, Internal Rate of Return
Budget Forecasting
Projections of Financial Statements
Cash Flow Statement Construction
Includes the most-used business formulas and Growth Formulas
Percentage Derivation
SUM, AVERAGE, IF, MAS
FV, PV, IRR, NPV
Lists of checking protocols, Excel tips, and productivity enhancements.
Find and solve common errors
Give spreadsheets a professional look
Solve printing problems
Structure spreadsheets to answer business's common "what-if" questions CONTENTS Part 1: Learn Excel From the Ground UP Understand Excel's screen and how to use it most efficiently. Use Excel's fastest and most accurate procedures Enter, edit and copy data
Create and copy formulas
Format and print spreadsheets Part 2: Build Business Spreadsheets A problem-solving approach based on realistic business Calculation of percentages, markups, discounts, and prices
Financial Present and Future value, Net Present Value, Internal Rate of Return
Budget Forecasting
Projections of Financial Statements
Cash Flow Statement Construction
Includes the most-used business formulas and Growth Formulas
Percentage Derivation
SUM, AVERAGE, IF, MAS
FV, PV, IRR, NPV
Lists of checking protocols, Excel tips, and productivity enhancements.
