MARS Excel 2013 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 PivotTable Shell
  • dropping fields into a PivotTable
  • filtering a PivotTable report
  • clearing a report filter
  • switching PivotTable labels
  • formatting  PivotTable report
  • understanding slicers
  • creating slicers.

PivotTable Techniques

  • using compound fields
  • counting in a PivotTable report
  • formatting PivotTable report values
  • working With PivotTable grand totals
  • working With PivotTable subtotals
  • finding the percentage of total
  • finding the difference from
  • grouping In PivotTable reports
  • creating running totals
  • creating calculated fields
  • providing custom names
  • creating calculated items
  • PivotTable options
  • sorting in a PivotTable.

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 subtotalled worksheet
  • creating nested subtotals
  • copying subtotals
  • using subtotals with AutoFilter
  • creating relative names for subtotals
  • 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

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

Course Info

  • Code: MARS13EXCAD
  • Duration: 1/2 day
  • Price: Call for price

Next Step

Enquire Now
Tell a Friend