Week 1: Introduction to Excel for Financial Analysis

1. Excel Basics

   • Interface and navigation
   • Data entry, formatting, and basic formulas
   • Keyboard shortcuts for efficiency

2. Essential Excel Functions

   • SUM, AVERAGE, COUNT, and COUNTA
   • Relative vs. absolute references
   • IF statements and logical operators

3. Data Formatting

   • Number formats (currency, percentage, etc.)
   • Conditional formatting for financial data

Week 2: Data Management and Organization

1. Data Sorting and Filtering

   • Custom sorting
   • Advanced filters

2. Data Validation

   • Setting rules for data input
   • Drop-down lists

3. Working with Tables

   • Converting ranges to tables
   • Table formatting and total rows

Week 3: Financial Functions and Formulas

1. Key Financial Formulas

   • NPV (Net Present Value)
   • IRR (Internal Rate of Return)
   • PMT (Loan Payments)

2. Time Value of Money (TVM)

   • Present value (PV) and future value (FV) calculations

3. Using Goal Seek

   • Scenario planning for financial goals

Week 4: Financial Modeling Essentials

1. Introduction to Financial Modeling

   • Importance of financial models
   • Building a basic financial model

2. Income Statement Analysis

   • Structuring a profit and loss statement
   • Calculating gross profit, operating profit, and net profit

3. Error Checking and Auditing

   • Using trace precedents/dependents
   • Fixing formula errors