Learn how to use Microsoft Excel step by step in this beginner-friendly tutorial. If you're new to Excel or want to understand the basics, this video shows you how to get started using Excel right ...

Excel's AGGREGATE function lets you perform calculations whilst ignoring hidden rows, errors, or other functions that appear in the data. It's similar to the SUBTOTAL function but provides more ...

Learn how to calculate the net present value (NPV) of your investment projects using Excel's XNPV function.

Find out the best practices for most financial modeling to price a bond, calculate coupon payments, and calculate a bond's yield to maturity in Microsoft Excel.

How to Use Excel to Calculate a Bond's Yield to Call. Bonds are investment vehicles that make regular coupon payments until maturity, at which time the bond's face value is paid.

How to Use Excel to Calculate Incremental Cost & Incremental Revenue. Microsoft Excel can be a powerful tool for large and small businesses alike.

Follow along in this step-by-step guide to learn how to easily calculate hours worked in Microsoft Excel.

Excel’s BYCOL() and BYROW() functions evaluate data across columns and rows, returning an array result set allowing you to bypass a lot of work.

Key Points Use Excel to calculate daily returns and standard deviation to gauge stock volatility. Annualize volatility by multiplying daily standard deviation by the square root of 252.

The Excel ASIN function returns the arcsine or inverse of a number. In this tutorial, we will explain how to use the ASIN function in Excel.

Learn how to calculate Standard Deviationin Excel. The STDEV function can be used to estimate standard deviation based on sample in Excel.