MARS Excel 2007 Expert - Analysing Data


  • understanding scenarios
  • creating a default scenario
  • creating scenarios
  • using names in scenarios
  • displaying scenarios
  • creating a scenario summary report
  • merging scenarios.

Data Tables

  • data tables and what-if models
  • using a simple what-if model
  • creating a one-variable table
  • using one-variable data tables
  • creating a two-variable data table.

Statistical Functions

  • understanding statistical functions
  • status bar statistics
  • using COUNT and COUNTA
  • using COUNTBLANK
  • using COUNTIF
  • Using MODE
  • using MEDIAN
  • using LARGE And SMALL
  • using STDEV
  • using VAR.

Lookup Functions

  • understanding data lookup functions
  • using CHOOSE
  • using VLOOKUP
  • using VLOOKUP for exact matches
  • using HLOOKUP
  • using INDEX
  • using MATCH
  • understanding reference functions using ROW and ROWS
  • using COLUMN and COLUMNS
  • using ADDRESS
  • using INDIRECT
  • using OFFSET.

Financial Functions

  • understanding financial functions
  • using PMT
  • using FV
  • using NPV
  • using PV
  • using RATE
  • using EFFECT
  • using NOMINAL.

Date And Time Functions

  • understanding date and time functions
  • using NOW
  • using HOUR and MINUTE
  • using TODAY
  • calculating future dates
  • using DATE
  • using calendaring functions
  • using WEEKDAY
  • using WEEKNUM
  • using WORKDAY
  • using EOMONTH.

Summarising And Subtotalling

  • creating subtotals
  • using a sub-totalled worksheet
  • creating nested sub-totals
  • copying sub-totals
  • using sub-totals with AutoFilter
  • installing the conditional sum wizard
  • using the conditional sum wizard
  • creating relative names for sub-totals
  • using relative names for sub-totals.

On-Site Training

If you need training for three or more people, ask us about training at your site. You can enjoy the convenience of reduced travel cost and time, as well as a familiar environment for your staff. Additionally, we can customise the course for your business needs.

User Reviews

Not yet rated. You will need to follow this course before you can write a review.

Course Info

Next Step

Enquire Now
Tell a Friend
Email Course Outline