MBA's Guide to Microsoft Excel

Tip: To see what's in the MBA's Guide to Excel, first download and peruse the short introduction. Also, note that you need the starter workbooks zip file if you want to work with the models described in chapters 10 through 15.

• Chapter 1: Introduction
• Chapter 2: A Quick Primer on Using Excel
  • Workbook Basics
  • Using Formulas and Functions
  • Editing Workbook Data
  • Formatting Workbooks
  • Printing Workbooks
• Chapter 3: A Quick Primer on Charting
  • Understanding Excel’s Charting Terms
  • Presenting Data with Charts
  • Mapping Geographic Data
• Chapter 4: Statistical Analysis using Excel
  • EasyRefresher: Basic Business Statistics
  • Statistical Formulas
  • Data Analysis Tools
• Chapter 5: Financial Calculations using Excel
  • EasyRefresher: Applying Time Value of Money Concepts
  • Using the Standard Financial Functions
  • Using the Add-In Financial Functions
• Chapter 6: Excel-based Business Modeling
  • What-If Analysis with Data Tables
  • What-If Analysis with Scenario Manager
  • Simple Modeling with Goal Seek
  • Optimization Modeling with Solver
• Chapter 7: Sharing Excel Workbooks
  • Using OLE with Excel
  • Sharing Workbook Files
  • Sharing Excel Data Over the Web
  • Retrieving External Data with Excel
• Chapter 8: PivotTables and PivotCharts
  • Using the PivotTable Wizard
  • Editing PivotTables
  • Creating PivotCharts
• Chapter 9: Small Business Financial Manager
  • Installing and Starting the Small Business Financial Manager
  • Importing Financial Data
  • Working with the Report Wizard
  • Working with the Financial Analysis Tools
  • Refreshing Imported Data
  • Rearranging and Modifying Imported Data
• Chapter 10: Building a Business Planning Workbook
  • EasyRefresher: Financial Statements and Ratios
  • Using the Business Planning Starter Workbook
  • Understanding the Starter Workbook’s Calculations
  • Customizing the Starter Workbook
• Chapter 11: Building a Profit Volume and Break-even Analysis Workbook
  • EasyRefresher: Profit Volume and Break-Even Analysis
  • Using the Profit Volume and Break-Even Analysis Starter Workbook
  • Understanding the Starter Workbook’s Calculations
  • Customizing the Starter Workbook
  • Charting Profit Volume Analysis Data
• Chapter 12: Forecasting Sales and Cost of Sales
  • EasyRefresher: Sales and Cost of Sales Forecasting
  • Using the Sales Forecasting Starter Workbook
  • Understanding the Starter Workbook’s Calculations
  • Customizing the Starter Workbook
• Chapter 13: Building a Capital Budgeting Workbook
  • EasyRefresher: Cash Flow Forecasting and Analysis
  • Using the Cash Flow Forecast and Analysis Starter Workbook
  • Understanding the Starter Workbook’s Calculations
  • Customizing the Starter Workbook
• Chapter 14: Building Amortization Schedules
  • EasyRefresher: Amortizing Debt
  • Using the Debt Amortization Starter Workbooks
  • Understanding the Fixed Rate, Ordinary Annuity Amortization Starter Workbook
  • Understanding the Fixed Rate, Annuity Due Amortization Starter Workbook
  • Understanding the Variable Rate, Ordinary Annuity Amortization Starter Workbook
  • Understanding the Variable Rate, Annuity Due Amortization Starter Workbook
  • Customizing the Debt Amortization Starter Workbooks
• Chapter 15: Building Asset Depreciation Schedules
  • EasyRefresher: Asset Depreciation
  • Using the Asset Depreciation Starter Workbooks
  • Understanding the Straight-Line Depreciation Starter Workbook
  • Understanding the Declining Balance Depreciation Starter Workbook
  • Understanding the Sum-of-the-Years’-Digits Depreciation Starter Workbook
  • Understanding the Annuity or Sinking Fund Depreciation Starter Workbook
  • Understanding the Activity Depreciation Starter Workbook
  • Customizing the Asset Depreciation Starter Workbooks