Excel Function Categories

Excel ENGINEERING Functions; 50++ Functions: 8 Methods

Method 1 - Using the CONVERT Function to Convert Between Units of Measurement To convert a gram unit into a pound mass unit, follow the steps below: ...

How to Use Excel String Functions (Examples of 17 Functions)

  Function 1 – TEXT Function Syntax: =TEXT(value, format_text) Arguments Explanation: Argument Required/Optional ...

Excel Date Functions – A Complete Guide

This is an overview. . Download Practice Workbook Download the workbook here. Excel Date Functions.xlsx 1 - Insert ...

Top Financial Functions in Excel (15+ Functions)

1 - FV Function (Future Value) The FV function is an Excel financial function that is used to calculate the future value of an investment based on a ...

Logical Functions in Excel

Logical Functions in Excel IF AND OR NOT IFERROR IFNA XOR << Go Back to Excel Function Categories | Excel ...

51 Mostly Used Math and Trig Functions in Excel

The Math & Trig functions in Excel are used for basic arithmetic, conditional sum & product, exponent & logarithm, and trigonometric ...

How to Use Excel Database Functions DGET, DAVERAGE, & DMAX

There are twelve database functions available in Excel: DAVERAGE, DCOUNT, DCOUNTA, DGET, DMAX, DMIN, DPRODUCT, DSTDEV, DSTDEVP, DSUM, DVAR, and ...

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo