How to use date formula in Excel
Sometimes excel interprets date formats as a text string. Microsoft Excel has an inbuilt date formula that any frequent user of excel is aware of. It is the primary function…
0 Comments
May 31, 2021
How Do I Auto fill my Formula in Excel?
Excel Formula is an expression that calculates values in a cell or a range of cells. Formulas help you design good spreadsheets. The use of formulas in excel drastically minimizes…
Comments Off on How Do I Auto fill my Formula in Excel?
May 24, 2021
How to lookup frequently appearing text in Excel
The maximum number in which a text is repeated in a string is normally referred to as the frequently occurring text. There are many ways you can find them, and…
Comments Off on How to lookup frequently appearing text in Excel
May 10, 2021
How to calculate the sum of filtered cells
When one wants to hide data from the view, excel has a filter option that filters data in the worksheet. This also data into the filtered and the visible. It…
Comments Off on How to calculate the sum of filtered cells
April 12, 2021
How to use true and false functions in Excel
Microsoft Excel is an excellent tool often used to keep track of data and other useful records. Among the various capabilities entailed in excel is the use of function and…
Comments Off on How to use true and false functions in Excel
March 21, 2021
How to calculate 7 day moving average in Excel
Moving Average is otherwise called running average or rolling average. There is something common about the three different names - moving, running, and rolling. Yes, this type of average has…
Comments Off on How to calculate 7 day moving average in Excel
March 14, 2021
How Vlookup to return the max value from multiple hits in Excel
We have several mathematical functions provided in or by the Microsoft Excel. Some of these functions are; v-lookup, min, max, mean, mode, and median. They all have their basic function…
Comments Off on How Vlookup to return the max value from multiple hits in Excel
October 4, 2020
How to find max value in range with criteria in Excel
Max, as used in the above statement, is the short form for the word maximum. Maximum is a mathematical function used when we are referring to the value with the…
Comments Off on How to find max value in range with criteria in Excel
September 26, 2020
Excel min and max in the same formula
Whenever we are handling numbers, values, ranges, and figures there is always the need to identify the minimum value of all the values and the maximum values of all the…
Comments Off on Excel min and max in the same formula
September 26, 2020
How to override conditional formatting in Excel
Formatting is a very crucial aspect of Word editing. You can bold, underline, italicize, set paragraphs, etc. using well-arranged commands and shortcuts. Formatting is also tenable on Excel. There are…
Comments Off on How to override conditional formatting in Excel
August 6, 2020