Build Business Spreadsheets using Excel ^{2nd Ed.}

Part 1: The Basics

• For people who are new to spreadsheets and Excel. Get started right with a step-by-step guide that shows you how to:
• Enter, edit, and copy data
• Create and copy formulas
• Format and print spreadsheets

Part 2: Build Business Spreadsheets

• A series of problems covering:
• Percentages, markups, discounts, pricing, growth
• Date math and financial math
• Budget and financial statement projection
• Models vs. calculations
• The problems include:
• Excel features that help solve the problem and how to use them
• Problem analysis and assumption development
• Integrity checking
• Business presentation and formatting

Appendices

• The best business shortcuts
• Common business formulas and functions
• In-depth guide to formatting and printing
• Excel troubleshooter
• Useful features and commands
• Construction, proofing and checking techniques

Answers

• Answer section shows correct spreadsheet construction as well as the right answers to each problem

Features

• Shows you how to avoid the worst mistakes in business spreadsheet construction
• Offers checklists and tips to help you find errors and check for spreadsheet integrity
• Gives you valuable pointers on how to work efficiently and quickly
• Helps you choose appropriate formats for your work
• Shows you how to set up your spreadsheet for easier revision, editing, and troubleshooting
• Explains the importance of "what-if" scenarios in business and how to build "what-if" flexibility into every spreadsheet

Design

• Problem-based approach gives you practice in analyzing, building, and checking real-life spreadsheets
• Periodic tests show you how you're doing
• A workbook, not a list of features
• Demonstrate Excel commands in appropriate contexts: shows you when to use them, not just how to use them
• Learn by doing:

• Introduction
• Part 1. Foundation skills
1. Orientation
2. Enter, delete, edit data
• Test 1
3. Menu commands
• Test 2
4. Formulas
• Test 3
5. The COPY command
• Test 4
6. Moving things around
• Test 5
7. Presentation
• Final test, part 1
• Part 2: Problem sets
1. General business problems
• Set 1: Simple models
• Set 2: Data analysis
• Set 3: Date math
• Set 4: Growth calculations
2. Financial math problems
• Set 5: PV and FV
• Set 6: NPV and IRR
3. Financial projections
• Set 7: Secondary calculations and plug accounts
• Set 8: Financial statement projection, single sheet
• Set 9: Multiple sheets
• Set 10: Financial statement projection, multiple sheets
• Appendices
• Appendix A: Efficiency
• Appendix B: Common business formulas and functions
• Appendix C: Excel troubleshooting
• Appendix D: Guide to formatting
• Appendix E: Other useful commands and features
• Appendix F: Printing
• Appendix G: The A-B-C-D of spreadsheet design
• Appendix H: Standards and checking
• Answers
• Part 1
• Part 2
1. General business problems
2. Financial math
3. Financial projections

This is the book that you really need when studying to an MBA! Excellent tool for learning MS-Excel as well as all these pesky formulas and problem statements that you need all the time in Finance class. Recommended. Also part of Financial Business Box.