Functions

Learn Excel functions to streamline calculations, analyze data, and boost productivity with guides on formulas like VLOOKUP, SUM, INDEX-MATCH, and more.

Functions Text

RIGHT Function

Learn how to use the RIGHT function in Excel with Inside Excel’s step-by-step guide, examples, and best practices for text extraction.

Read More RIGHT Function
Functions Text

LEFT Function

Learn how to use the LEFT function in Excel with Inside Excel’s step-by-step guide, examples, and best practices for text extraction.

Read More LEFT Function
Functions Logical

OR Function

Learn how to use the OR function in Excel with Inside Excel’s step-by-step guide, examples, and best practices.

Read More OR Function
Functions Logical

AND Function

Learn how to use the AND function in Excel with Inside Excel’s step-by-step guide, examples, and best practices.

Read More AND Function
Functions Text

TRIM Function

Learn how to use the TRIM function in Excel with Inside Excel’s step-by-step guide, examples, and best practices for text cleaning.

Read More TRIM Function
Date and Time Functions

NOW Function

Learn how to use the NOW function in Excel with Inside Excel’s step-by-step guide, examples, and best practices.

Read More NOW Function
Functions Text

CONCATENATE Function

Learn how to use the CONCATENATE function in Excel with Inside Excel’s step-by-step guide, examples, and practice exercises.

Read More CONCATENATE Function
Functions Lookup and Reference

HLOOKUP Function

Learn how to use the HLOOKUP function in Excel with Inside Excel’s step-by-step guide, examples, and practice exercises.

Read More HLOOKUP Function
Functions Logical

IF Function

Learn how to use the IF Function in Excel with Inside Excel’s step-by-step guide, examples and practice exercises.

Read More IF Function