Skip to content

Inside Excel

Spreadsheets, Data Analytics, and Expert Excel Techniques

  • Functions
  • Tutorials
Inside Excel
Spreadsheets, Data Analytics, and Expert Excel Techniques
Home / Functions

Functions

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

Excel RIGHT Function
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 FunctionContinue

Excel LEFT 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 FunctionContinue

Excel OR 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 FunctionContinue

Excel AND 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 FunctionContinue

Excel TRIM 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 FunctionContinue

Excel NOW 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 FunctionContinue

Excel CONCATENATE 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 FunctionContinue

Microsoft Excel HLOOKUP 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 FunctionContinue

Microsoft Excel IF 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 FunctionContinue

Microsoft Excel SUM Function
Functions Math

SUM Function

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

Read More SUM FunctionContinue

Page navigation

1 2 Next PageNext

© 2025 Inside Excel by Steven Cahill

More from Steven Cahill

Staffy care tips & dog training | Explore things to do in Geelong

Some of the links on this website are affiliate links. This means that if you click on a link and make a purchase, I may receive a small commission at no extra cost to you. I only recommend products and services that I genuinely believe in and have personally used or thoroughly researched. Your support helps keep this website running, and I sincerely appreciate it.

Scroll to top
  • Functions
  • Tutorials