1. Home
  2. Resources
  3. General Guides
  4. Excel finance functions

Excel finance functions

COUNT Excel formula

Guide
June 30, 2023
Learn how to use the COUNT Excel formula to quickly and accurately count cells with data in your spreadsheets.
Learn more
A spreadsheet with a highlighted cell containing the count formula

MIN Excel formula

Guide
June 30, 2023
Learn how to use the MIN Excel formula to find the smallest value in a range of cells.
Learn more
A spreadsheet with a highlighted cell containing a complex excel formula

MAX Excel formula

Guide
June 30, 2023
Learn how to use the powerful MAX Excel formula to find the highest value in a range of cells.
Learn more
A computer screen with a spreadsheet open

ROUND Excel formula

Guide
June 30, 2023
Learn how to use the ROUND Excel formula to round numbers to a specified number of decimal places.
Learn more
A spreadsheet with a highlighted cell containing a round formula

AVERAGE Excel formula

Guide
June 30, 2023
Learn how to use the AVERAGE Excel formula to quickly calculate the average of a range of numbers in your spreadsheets.
Learn more
A spreadsheet with a highlighted cell containing the average excel formula

SUM Excel formula

Guide
June 30, 2023
Learn how to use the SUM Excel formula to quickly and accurately calculate the total of a range of numbers in your spreadsheets.
Learn more
A spreadsheet with the sum formula highlighted

VLOOKUP Excel formula

Guide
June 30, 2023
Learn how to use the VLOOKUP Excel formula to quickly and accurately search for and retrieve data from large spreadsheets.
Learn more
A spreadsheet with the vlookup formula in action

IF Excel formula

Guide
June 30, 2023
Learn how to use the IF Excel formula to perform conditional calculations and make data analysis more efficient.
Learn more
A spreadsheet with a highlighted cell containing an if formula

AND Excel formula

Guide
June 30, 2023
Learn how to use the powerful AND Excel formula to streamline your data analysis and make more accurate calculations.
Learn more
A spreadsheet with a highlighted cell containing an and excel formula