Free Power User's

Quick Guide

Discover The BEST Ways To Use Lookups And Conditional Calculations Quickly And Easily With This Reference Guide -- You Won’t Want This To Leave Your Side

With so many ways to use Excel, it can be difficult to memorize all of the key functions, calculations, and techniques you can employ to meet your goal: simply get the job done.

Welcome to the

Formula & Function reference section of Excel.TV

Welcome to the Excel formula and function reference section of Excel.tv, where you'll find a comprehensive guide to all of Excel's built-in formulas and functions. Whether you're new to Excel or an experienced user, understanding and mastering Excel's formulas and functions is essential to getting the most out of the program.

Excel is a powerful tool for organizing and analyzing data, and it's widely used in businesses, organizations, and even personal projects. With Excel, you can create and edit spreadsheets, perform calculations, create charts and graphs, and much more. And at the heart of Excel's powerful calculations and data analysis capabilities are its formulas and functions.

Our Excel formula and function reference guide is designed to help you understand and master Excel's formulas and functions. We'll provide an alphabetical list of formulas and functions, as well as explanations of what each one does and how to use it. We'll also provide examples of how to use the functions in real-world scenarios, so you can see how they can be applied to your own data.

Alphabetical List of Excel Functions & Formulas

Here you will find an A-Z list of all Excel's built-in functions and formulas, including explanations of what each one does and how to use it. A perfect reference guide for mastering Excel's powerful calculations and data analysis capabilities.

Commonly Used Formulas & Functions in Excel

Here you will find a list of the most frequently used Excel's built-in functions and formulas, including SUM, AVERAGE, COUNTIF, VLOOKUP and more, with explanations of their usage and examples of how to apply them in real-world scenarios. A perfect guide for mastering the most essential Excel's calculations and data analysis capabilities for your daily use.

Excel Functions and Formulas by Category

Here you will find a comprehensive list of Excel's built-in functions and formulas, categorized into groups such as text functions, logical functions, date and time functions, mathematical functions, lookup and reference functions, database functions and more. A perfect guide to understanding and mastering Excel's powerful calculations and data analysis capabilities by category.

Check out the Excel Function & Formula
Reference Sections


Excel formulas and functions are categorized into several groups such as:

  • Text functions:
    • These functions work with text strings, such as CONCATENATE, UPPER, and LOWER.
  • Logical functions:
    • These functions perform logical tests, such as IF, AND, and OR.
  • Date and time functions:
    • These functions work with dates and times, such as NOW, DATE, and YEAR.
  • Mathematical functions:
    • These functions perform mathematical calculations, such as SUM, AVERAGE, and COUNT.
  • Lookup and reference functions:
    • These functions help you look up and reference data, such as VLOOKUP, HLOOKUP, and INDEX.
  • Database functions:
    • These functions help you work with data in a database, such as DSUM and DAVERAGE.
  • Information functions:
    • These functions return information about the contents of a cell or a range of cells, such as ISNUMBER and ISTEXT.
  • Financial functions:
    • These functions perform financial calculations, such as PV, FV, and PMT.
  • Engineering functions:
    • These functions perform engineering calculations, such as BESSELI, BESSELJ, and BESSELK.
  • Statistical functions:
    • These functions perform statistical calculations, such as STDEV, VAR, and MIN.

We also provide a detailed explanation of each function, including the syntax, the arguments, and the return value. Additionally, we also provide examples of how to use the functions in real-world scenarios, so you can see how they can be applied to your own data.

In conclusion, Excel's formulas and functions are a powerful tool for performing calculations and analyzing data, and our Excel formula and function reference guide provides a comprehensive resource for understanding and mastering them. Whether you're new to Excel or an experienced user, our guide will help you become an Excel pro. If you have any questions or suggestions, please feel free to contact us.

FrePower User's Excel Guides

Discover The BEST Ways To Use Lookups And Conditional Calculations Quickly And Easily With This Reference Guide -- You Won’t Want This To Leave Your Side

With so many ways to use Excel, it can be difficult to memorize all of the key functions, calculations, and techniques you can employ to meet your goal: simply get the job done.

>