Excel Formulas and Functions
Excel UPPER Function
“Learn how to use the Microsoft Excel UPPER Function to effortlessly convert text to uppercase, enhancing your spreadsheets’ readability and consistency.”
April 23, 2024
All Excel Guides
Every tutorial, formula reference, and how-to guide on the site, newest first.
Page 6 of 111
Excel Formulas and Functions
Excel VALUE Function
Learn how to use the Microsoft Excel VALUE Function to convert text to numbers, simplifying data analysis and calculations in your spreadsheets.
April 23, 2024
Excel Formulas and Functions
Excel VAR.P Function
Learn how to use the Microsoft Excel VAR.P function for calculating population variance, a key tool for statistical analysis in your spreadsheets.
April 23, 2024
Excel Formulas and Functions
Excel VAR.S Function
Discover how to master the Microsoft Excel VAR.S function, the key to calculating sample variance efficiently in your spreadsheets.
April 23, 2024
Excel Formulas and Functions
Excel ABS Function
Learn how to use the Microsoft Excel ABS function to easily convert negative numbers to positive values and streamline your data analysis.
April 11, 2024
Excel Formulas and Functions
Excel ADDRESS Function
Learn how to master the Microsoft Excel ADDRESS Function to dynamically reference cells in your spreadsheets, enhancing efficiency and accuracy.
April 11, 2024
Excel Formulas and Functions
Excel CEILING Function
Discover how to master the Microsoft Excel CEILING function for rounding numbers up to the nearest multiple, simplifying data analysis and calculations.
April 11, 2024
Excel Formulas and Functions
Excel COLUMN Function
Discover how the Microsoft Excel COLUMN function can simplify your spreadsheet tasks by returning the column number of a reference cell.
April 11, 2024
Excel Formulas and Functions
Excel FLOOR Function
Discover how to master the Microsoft Excel FLOOR function, simplifying rounding numbers down to the nearest specified factor in your spreadsheets.
April 11, 2024
Excel Formulas and Functions
Excel FORMULATEXT Function
Discover how to use the Microsoft Excel FORMULATEXT Function to display formulas in cells, enhancing your spreadsheet’s transparency and efficiency.
April 11, 2024
Excel Formulas and Functions
Excel GCD Function
Discover the essentials of the Microsoft Excel GCD function, the key to simplifying fractions and solving math problems efficiently in your spreadsheets.
April 11, 2024
Excel Formulas and Functions
Excel HLOOKUP Function
Discover how the Microsoft Excel HLOOKUP function can streamline your data search across rows, enhancing efficiency and accuracy in your spreadsheets.
April 11, 2024
Excel Formulas and Functions
Excel HYPERLINK Function
“Master the Microsoft Excel HYPERLINK function to easily link documents and webpages directly in your spreadsheets for quick access and organization.”
April 11, 2024
Excel Formulas and Functions
Excel INDEX Function
Discover how the Microsoft Excel INDEX function can transform your data analysis and reporting, making it easier to manage and interpret your data.
April 11, 2024
Excel Formulas and Functions
Excel INDIRECT Function
Learn how to master the Microsoft Excel INDIRECT Function to dynamically refer to other cells, sheets, and workbooks, enhancing your spreadsheets.
April 11, 2024