MARS Excel 2010 Expert - Analysing Data


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

Pivot Tables

  • understanding Pivot Tables
  • creating A Pivot Table Shell
  • dropping fields into a Pivot Table
  • filtering  Pivot Table report
  • clearing a report filter
  • switching Pivot Table labels
  • formatting a Pivot Table report
  • understanding slicers
  • creating slicers.

PivotTable Techniques

  • using compound fields
  • counting in a Pivot Table report
  • formatting Pivot Table report values
  • working with Pivot Table grand totals
  • working with Pivot Table subtotals
  • finding the percentage of total
  • finding the difference from
  • grouping in Pivot Table reports
  • creating running totals
  • creating calculated fields
  • providing custom names
  • creating calculated items
  • Pivot Table options
  • sorting in a Pivot 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
  • creating relative names for sub-totals
  • using relative names for subtotals.

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

Perfect. It doesn't get any better (Rating based on 1 reviews)

of respondents recommend this course to a friend.

Click here to Read Reviews

Course Info

Next Step

Enquire Now
Tell a Friend
Email Course Outline