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 ...

Excel Statistical Functions

List of Excel Statistical Functions: AVERAGE Function MEDIAN Function MODE Function STDEV Function VAR Function COUNT Function ...

List of Complex Functions in Excel (10+ Functions)

A complex number is a combination of real numbers and imaginary numbers represented in x+iy format. Where x is the real part and y is the coefficient ...

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 ...

Excel Information Functions

Excel Information Functions: Knowledge Hub CELL Function IFERROR Function ISBLANK Function ISERROR Function ISEVEN Function ...

Excel TIME Functions

List of Excel TIME Functions TIME NOW HOUR MINUTE SECOND TIMEVALUE NETWORKDAYS EDATE EOMONTH << Go Back ...

Excel LOOKUP and Reference Functions

Excel LOOKUP and Reference Functions: VLOOKUP Advanced Excel Lookup Functions HLOOKUP XLOOKUP LOOKUP INDEX MATCH ADDRESS ...

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 ...

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo