·         Basic Excel Functions

o        Cells

o        Simple formulas

o        Range formulas

·         Data Entry

o        Moving around

o        Totals

o        Percentages

o        Copying formulas

o        Relative and absolute formulas

o        Moving the data

o        Copying the page

·         Projecting Profit and Loss

o        Revenues

o        Expenses

o        Profit (Loss)

o        Periods

o        Formulas for dependent variables

·         What-If Analysis

o        Specifications

o        Formulas

o        Copy and saving versions

·         Graphing & Design

o        Arranging data

o        Selecting data

o        Graphing Lizard

o        Graph design improvements

o        Page design

·         Links to External Data

o        Cells

o        Lookups

o        Advanced Solutions

o        One-variable analysis

o        Two-variable analysis

o        Scenario management

  [ Top ] [ Back ] [ Next ]

home | lectures | assignments
notices | discussion | resources
search | site map | help
feedback