• Skip to main content
  • Skip to header right navigation
  • Skip to site footer

Excelypedia

The Excel Encyclopedia of The Internet

  • Tutorials
  • Functions
  • Formulas
  • Templates

Excel Formulas

Backtesting Var in Excel

Backtesting VaR in Excel

October 9, 2021 by Andrew Childress

In investment analysis, value-at-risk, called VaR, is a measure of investment risk. Let’s learn how to do backtesting VaR in Microsoft Excel.

RANDARRAY formula in Excel

RANDARRAY in Excel

October 6, 2021 by Andrew Childress

Ever needed to generate a full array of random values in Excel? This is a great way to test out formulas. Here's how to use RANDARRAY in Microsoft Excel.

Average true range in Excel

Calculate ATR in Excel

October 5, 2021 by Andrew Childress

True range is an indicator often used to measure volatility of investments such as stocks. Let’s learn how to calculate ATR in Microsoft Excel.

Calculate arrears in Excel

How to Calculate Arrears in Excel

October 4, 2021 by Andrew Childress

The concept of arrears refers to money owed that should have been paid in the past. Let’s learn how to calculate arrears in Microsoft Excel.

Akaikes information criterion Excel

How to Calculate AIC in Excel

October 3, 2021 by Andrew Childress

Akaike’s Information Criterion, or AIC for short, is a commonly-used statistical measurement. Let’s learn how to calculate AIC in Microsoft Excel.

Hide research in Excel

Disable Research in Excel

September 30, 2021 by Andrew Childress

Microsoft Excel’s Research tool is a useful feature designed as a reference aid. Let’s learn how to disable Research in Microsoft Excel.

  • Previous
  • Go to page 1
  • Go to page 2
  • Go to page 3
  • Go to page 4
  • Interim pages omitted …
  • Go to page 13
  • Next

Excelypedia

Master Excel to add a highly valuable asset to your employability portfolio. Learn how to analyze data in Excel.

    • Facebook
  • Twitter
  • Instagram
  • YouTube

Learn

  • Functions
  • Formulas
  • Shortcuts

Legal

  • Privacy Policy
  • Cookie Policy
  • Terms & Conditions

Help

  • FAQ
  • Contact Us

Copyright © 2023 · Excelypedia · All Rights Reserved

Back to top