Free Online Tutorials on Spreadsheets

Excel Formulas [Examples]

Average

Count

By using the COUNTIF function:

By using the COUNTBLANK function:

Date

Days in month

Restrict date to be entered and cell should only accept desired date (e.g Friday only)

Depreciation

Calculate depreciation for the first month

Min & Max

Larger of two values

Minimum value from a set of values.

nth largest value

Round

Round a number

SUM

by using SUM function:

By using SUMIFS function:

Logical

Return different values based on condition e.g. student’s result based on numbers obtained

Data Analysis

Prevent duplicate entries

Create a drop-down list 

Create dependent drop-down lists

Add input restrictions to validate data

Enter dates between two dates only




Copyright © 2016 - 2019 Explainry.com | All Rights Reserved