Excel Functions – Lookup & Reference in Excel
Lookup and reference functions in Excel are used to find and return values from a range of cells. These functions can be used to...
Excel Functions – Text Functions in Excel
Text Functions in Excel are a set of functions that allow you to manipulate text data in your worksheets. They can be used to...
Excel Functions – Date and Time in Excel
Date and time are important data types in Excel. You can use them to perform calculations, filter data, create charts, and more. Excel stores...
Excel Functions – Cell Reference in Excel
A cell reference in Excel is a combination of a column letter and a row number that identifies a cell on a worksheet. You can...
Excel Functions – Logical Functions in Excel
Logical functions are used in Excel to test whether a condition is true or false. Depending on the result of the test, you can...
Excel Functions – Count and Sum in Excel
The most used functions in Excel are the functions that count and sum. You can Count and Sum based on one criteria or multiple criteria.
Count and Sum
To count the number...
