285 подписчиков
76 видео
Quickest way to find out the maximum & minimum number under any condition || MAXIFS, MINIFS formula
Replace & Substitute formula in Excel || How to write & difference of Replace & Substitute function
Font case conversion in Excel || Upper, Lower, Proper formula in Microsoft Excel.
Advance example of IFS formula || Comparison of IF & IFS formula || Student grade system calculation
INDIRECT formula in Microsoft excel || Part 02 || Explanation with example.
Dynamic NAME Manager in Excel || Part 02 || How to create dynamic Name range in Excel
Math in Excel || SUMSQ ∑(x + y)², SUMX2PY2 ∑(x² + y²), SUMX2MY2 ∑(x² - y²), SUMXMY2() ∑(x - y)²
IFS formula in Excel (Replacement of Nested IF; RIP IF 😔) || Part-01, Basic discussion with example
M-tool Excel add-in installation | How to add an Excel add-in in trusted folder path.
CONCAT formula in excel with example || Part-02 || Join cells value together
QUOTIENT, MOD formula in excel
AND Formula in Excel || Nest of AND and OR formula || Discussion with 04 Example.
Advance example of IF formula of Excel || Student grade system calculation
Comparison of CONCATENATE, CONCAT and TEXTJOIN formula in excel || Part-04
How to change font to lower case by Excel VBA
How to add a text before and after every cell value of a selection by Excel VBA
How to change Font to Upper case by VBA
Filter Multiple values in one click in Excel | Multi-filter function | MTool
CONCATENATE formula in excel with example || Part-01 || Join cells value together
Product and Power formula in Microsoft Excel || Math calculation with Excel formula
Info Formula in Excel || Get different information about the Excel and operating environment.
LCM GCD Formula in Excel
How to convert a text into number with VALUE formula in Excel || Data correction in Excel.
TEXTJOIN formula in Excel with many example || Part-03 || Join cells value by space, comma etc.
OR Formula in Excel || Nest of OR and AND formula || Discussion with 04 Example.
How to remove some number of text or string from a selection by Excel VBA
Transpose Formula in Excel
NAME Manager in Excel || Part 01 || How to define and use names in Excel
IFS formula in Excel (Replacement of Nested IF; RIP IF 😔) || Part-02, Advance discussion
IFERROR Formula in Excel || How to handle error result
INDIRECT formula in Microsoft excel || Part 01 || Convert a text value into a cell reference.
Converts a text value to a number || NUMBERVALUE function in Excel || Data correction.
