From data to report in one minute or less. Ajelix BI is launched! 🚀 Get started for free.

Excel Formulas and Functions for Productive Spreadsheets

Ajelix library provides comprehensive resources for learning to use Excel formulas and functions. From basic arithmetic to complex financial analysis, you‘ll find detailed tutorials and explanations to help you master Excel quickly and easily. With our stepbystep guides and resources, you‘ll have the confidence to tackle any project with Excel.

Statistical Formulas and Functions

Logical Formulas and Functions

MAXIF Function in MS Excel

This function returns the maximum value of cells that meet a certain condition.

ABS Function in MS Excel

This function returns the absolute value of a number.

FIND Function in MS Excel

This function returns the starting position of a substring in a string.

Text Formulas and Functions

TODAY Function in MS Excel

Returns the current date.

=TODAY()

NOW Function in MS Excel

Returns the current date.

=NOW()

MID Function in MS Excel

Returns a specified number of characters from the middle of a text string.

SUBSTITUTE Function in MS Excel

Replaces a character or text string with another character or text string in a text string.

HLOOKUP Function in MS Excel

Looks for a value in the top row of a table, and returns a value in the same column from another row in the table.

Financial Formulas and Functions

PM Function in MS Excel

Formula calculates the payment for a loan.

FV Function in MS Excel

This formula calculates the future value of an investment.

PV Function in MS Excel

This formula calculates the present value of an investment.

NPV Function in MS Excel

This formula calculates the net present value of multiple cash flows.

IRR Function in MS Excel

Internal rate of return of multiple cash flows.

DDB Function in MS Excel

Depreciation amount for an asset using the double-declining balance method.

SLN Function in MS Excel

Depreciation amount for an asset using the straight-line method.

XNPV Function in MS Excel

Net present value of multiple cash flows with dates.

XIRR Function in MS Excel

Internal rate of return of multiple cash flows with dates.

CUMIPMT Function in MS Excel

Cumulative interest payments for a loan.

CUMPRINC Function in MS Excel

Cumulative principal payments for a loan.

PVIF Function in MS Excel

Present value interest factor.

FVIFA Function in MS Excel

This formula calculates the future value interest factor.

NPER Function in MS Excel

This formula calculates the number of periods for a loan.

RATE Function in MS Excel

This formula calculates the interest rate for a loan.

DB Function in MS Excel

This formula calculates the depreciation amount for an asset.

VDB Function in MS Excel

Depreciation amount for an asset using the variable declining balance method.

XIRR Function in MS Excel

Internal rate of return of multiple cash flows with dates.
More resources coming soon - Ajelix Resources page - Tutorials and Guides - Formulas and Functions

More formulas and functions coming soon!