WHAT'S NEW?

FINANCIAL MARKET COURSES

Building Blocks In Excel

Courses In This Course

This course makes use of video-based training and interactive spreadsheet exercises to show the value of Microsoft Excel when it comes to performing calculations associated with fundamental mathematical and statistical concepts as used in financial markets.

 

Each “drill” includes a video that focuses on a specific practical and job-related task, such as estimating volatility, measuring correlation, or performing a regression analysis. Learners then practice the Excel functions and calculations themselves within an attached Excel worksheet, applying their newly-acquired knowledge and skills via questions and exercises.

  •    EXCEL INTERACTIVE - LOGS

    Overview

    "Excel Interactive – Logs" uses video and interactive exercises to describe how log returns can be calculated using Microsoft Excel.

    Course Duration

    10 mins

    Prerequisite Knowledge

    Indices, Exponents, Logarithms, & Geometric Series

    FIND OUT MORE

  •    EXCEL INTERACTIVE - MEASURES OF CENTRAL

       TENDENCY

    Overview

    “Excel Interactive – Measures of Central Tendency" uses video and interactive exercises to describe how measures of central tendency (mean, mode, and median) can be calculated using Microsoft Excel.

    Course Duration

    15 mins

    Prerequisite Knowledge

    Distributions & & Hypothesis Testing

    FIND OUT MORE

  •    EXCEL INTERACTIVE – VOLATILITY

    Overview

    “Excel Interactive – Volatility" uses video and interactive exercises to describe the calculation of variance and standard deviation using Microsoft Excel.

    Course Duration

    20 mins

    Prerequisite Knowledge

    Estimating Volatility

    FIND OUT MORE

  •    EXCEL INTERACTIVE - NORMAL DISTRIBUTION

    Overview

    “Excel Interactive − Normal Distribution" uses video and interactive exercises to explore the normal distribution using Microsoft Excel, examining in particular how Excel can be used to estimate z-scores, the standard normal distribution, and the inverse of the standard normal distribution.

    Course Duration

    20 mins

    Prerequisite Knowledge

    Distributions & Hypothesis Testing

    FIND OUT MORE

  •    EXCEL INTERACTIVE - SKEWNESS & KURTOSIS

    Overview

    "Excel Interactive − Skewness & Kurtosis" uses video and interactive exercises to describe how a distribution's skewness and kurtosis can estimated using Microsoft Excel.

    Course Duration

    15 mins

    Prerequisite Knowledge

    Distributions & Hypothesis Testing

    FIND OUT MORE

  •    EXCEL INTERACTIVE - COVARIANCE &

       CORRELATION

    Overview

    “Excel Interactive − Covariance & Correlation" uses video and interactive exercises to show the calculation of covariance and correlation using Microsoft Excel.

    Course Duration

    20 mins

    Prerequisite Knowledge

    Correlation & Regression Analysis

    FIND OUT MORE

  •    EXCEL INTERACTIVE - REGRESSION ANALYSIS

    Overview

    “Excel Interactive – Regression Analysis" uses video and interactive exercises to show how a regression analysis can be undertaken using Microsoft Excel.

    Course Duration

    30 mins

    Prerequisite Knowledge

    Correlation & Regression Analysis

    FIND OUT MORE

Support

Accreditations

General: info@intuition.com

Accounts: ar@intuition.com

http://support.intuition.com

Intuition engages with over 30 accreditation bodies to ensure Know-How can be used for CPE credits. If your organization needs CPE from a body not listed below, contact us and we will endeavour to have them included.

© Copyright 2016 by Intuition. All Rights Reserved.