Excel Functions 4:

Maths & Statistical Functions
 Course Outline

DURATION 3 Hours
PREREQUISITES You need to have intermediate to advanced knowledge of Excel, including using If statements and VLookups, as well as know how to structure typical formulas.  Some Financial knowledge is require too, as this course does not teach finance theory.
DESCRIPTION Working with Math Functions and Statistical Functions within Excel.

Course can be either 2003 or 2007, and is 2003 by default.
COURSE DATES Click here to request an alternate date
Or call us on 020 313 73958 from 8:00 to 22:00 Monday to Sunday.
Weekend Sat, 18-Feb-12 13:30 - 16:30 £100.00 +VAT
Weekday Tue, 21-Feb-12 13:30 - 16:30 £100.00 +VAT
Weekday Tue, 20-Mar-12 13:30 - 16:30 £100.00 +VAT
Weekend Tue, 20-Mar-12 18:30 - 16:30 £100.00 +VAT
Weekday Fri, 20-Apr-12 13:30 - 16:30 £100.00 +VAT
Weekend Sat, 21-Apr-12 13:30 - 16:30 £100.00 +VAT
Weekday Tue, 15-May-12 13:30 - 16:30 £100.00 +VAT
Weekend Sat, 19-May-12 13:30 - 16:30 £100.00 +VAT
Weekend Tue, 19-Jun-12 18:30 - 16:30 £100.00 +VAT
Weekday Thu, 21-Jun-12 13:30 - 16:30 £100.00 +VAT
Weekday Thu, 19-Jul-12 13:30 - 16:30 £100.00 +VAT
Weekend Sat, 21-Jul-12 13:30 - 16:30 £100.00 +VAT
Weekday Wed, 15-Aug-12 13:30 - 16:30 £100.00 +VAT
Weekend Sat, 18-Aug-12 13:30 - 16:30 £100.00 +VAT
Weekend Tue, 18-Sep-12 18:30 - 16:30 £100.00 +VAT
Weekday Fri, 21-Sep-12 13:30 - 16:30 £100.00 +VAT
Weekday Mon, 15-Oct-12 13:30 - 16:30 £100.00 +VAT
Weekend Sat, 20-Oct-12 13:30 - 16:30 £100.00 +VAT
Weekend Tue, 13-Nov-12 18:30 - 16:30 £100.00 +VAT
Weekday Tue, 20-Nov-12 13:30 - 16:30 £100.00 +VAT
Weekend Thu, 20-Dec-12 18:30 - 16:30 £100.00 +VAT
Weekday Fri, 21-Dec-12 13:30 - 16:30 £100.00 +VAT
Any One-to-One Tuition
Any Date - Fully Customisable		 09:30 - 16:30 £200.00 +VAT

Alternatively, use our BOOKINGS FORM for an alternative payment method, or for multiple dates/courses.

 

 

WORKING WITH MATH FUNCTIONS

  • Understanding Excel's Rounding Functions

    • The ROUND() Function

    • The MROUND() Function

    • The ROUNDDOWN() and ROUNDUP() Functions

    • The CEILING() and FLOOR() Functions

    • Determining the Fiscal Quarter in Which a date Falls

    • Calculating Easter Dates

    • The EVEN() and ODD() Functions

    • The INT() and TRUNC() Functions

    • Using Rounding to Prevent Calculation Errors

    • Setting Price Points

  • Cast Study

    • Rounding Billable Time

  • Summing Values

    • The SUM() Function

    • Calculating Cumulative Totals

    • Summing Only the Positive or Negative Values in a Range

  • The MOD() Function

    • A Better Formula for Time Differences

    • Summing Every Nth Row

    • Determining Whether a Year is a Leap year

    • Creating Ledger Shading

  • Generating Random Numbers

    • The RAND() Function

    • The RANDBETWEEN() Function

WORKING WITH STATISTICAL FUNCTIONS

  • Understanding Descriptive Statistics
  • Counting Items with the COUNT() Function
  • Calculating Averages
    • The AVERAGE() Function
    • The MEDIAN() Function
    • The MODE() Function
    • Calculating the Weighted Mean
  • Calculating Extreme Values
    • The MAX() and MIN() Functions
    • Performing calculations on the Top x Values
    • Performing Calculations on teh Bottom x Values
  • Calculating Measures of Variation
    • Calculating the Range
    • Calculating the Variance with the VAR() Function
    • Calculating the Standard Deviation with the STDEVP() and STDEV() Functions
  • Working with Frequency Distributions
    • The FREQUENCY() Function
    • Understanding the Normal Distribution and the NORMDIST() Function
    • The Shape of the Curve I:  The SKEW() Function
    • The Shape of the Curve II:  The KURT() Function
  • Using Analysis TookPak Statistical Tool
  • Determining the Correlation Between Data
  • Working with Histograms
  • Using the Random Number Generation Tool
  • Working with Rank and Percentile