Navigation and Data

• Navigation, Arrow Keys, SHIFT & CTRL
• Inserting & Editing Cells, Rows and Columns
• Deleting Cells & Commenting
• Freezing Rows & Splitting the Screen
• Special Paste: Your New Best Friend
• Sorting
• Filtering

Formatting and Style

• Introduction to Formatting & Style
• Formatting Walkthrough
• The Five Rules for Financial Modeling
• Cell Dimensions
• Styling Fundamentals
• Styling Practice
• Special Paste Review
• Applying Special Paste to the Model
• Best Practices for Number Formatting
• Forward Multiples
• Negative Numbers & Percentages
• Go To Special
• Grouping Data

Formulas and Conditionals

• Introduction to Formulas & Conditionals
• Best Practices for Formulas and Conditionals
• Relative and Absolute Values Part 1
• Relative and Absolute Values Part 2
• Sum, Max, Min, Average
• Median, Rank, Percentile, Bonus
• Concatenation Part 1
• Concatenation Part 2
• IF
• Asking IF Twice
• Formula Error
• AND
• OR
• SMALL
• SUMIF
• SUMPRODUCT
• COUNT, COUNTA, COUNTIF
• COUNTIFS
• INDIRECT
• INDEX
• MATCH
• INDEX and MATCH
• Cell Color
• Custom Formulas
• Hidden Values
• Test

Charts

• Introduction to Charts
• Best Practices for Charts
• The Basics
• Selecting Data In Column Cahrts
• Customize Your Chart Part 1
• Customize Your Chart Part 2
• Line
• Columns

Time Value of Money

• Understand and be able to apply the concepts of the time value of money.
• Recognize the sensitivity of financial payoffs to changes in interest rates and other conditions that business managers must cope with.
• Tailor a series of future cash inflows or outflows necessary to satisfy present or future business objectives.
• Use Excel’s financial commands to convert future values to their equivalent present values, and vice versa.
• Use Excel’s financial commands to determine the net present value of a series of future cash flows.
• Calculate periodic payments for mortgages and other loans to identify how much of each payment goes to paying off the principal and how much goes to paying interest.
• Use Excel’s Goal Seek and Solver tools to achieve an objective.
• Create one- and two-variable input tables to do sensitivity analysis.

Financial Statement Analysis

• Create spreadsheets for financial statements
• Identify the three key financial statements of corporations (i.e., the income statement, balancesheet, and statement of cash flows) and describe their contents and purposes.
• Follow the standard formats for organizing items on financial statements.
• Interpret the items on financial statements and recognize how they’re related.
• Recognize when errors have been made in financial statements.

Forecasting

• Use Excel’s Chart Wizard to create a scatter plot of a set of data values.
• Select noncontiguous cell ranges for plotting.
• Insert different types of trend lines on a scatter plot to see which best fits a set of data values.
• Use Excel commands (e.g., INTERCEPT, SLOPE, and CORREL) and tools (e.g., LINESTand LOGEST) to create a statistical model that follows the trend of historical data for annual revenues.