Excel Function – WEEKNUM Function
Watch Excel Tutorial Video - Excel Function – WEEKNUM Function WEEKNUM function helps to calculate the week number of the given date in a year. It considers 1st January as first week by default and...
Excel Function Replace
How to use “REPLACE” function in Excel REPLACE function is used to replace the existing text from a specific location in a cell to New Text. REPLACE Function has argument four arguments i.e. old_text, start_num,...
EXCEL FUNCTION – AVERAGE
AVERAGE function is used to get the average of numbers. Function applies formula i.e. average = Sum of all values / (Divided by) number of items.
EXCEL FUNCTION – INDIRECT
INDIRECT function is used to convert the text/string into cell reference. Function provides output as the value of that cell reference.
EXCEL FUNCTION – SUMIF
SUMIF function is used to get the “total sum” for number of times the criteria across range is met. SUMIF Function has two required arguments.
EXCEL FUNCTION – HOUR, MINUTE, SECOND
Microsoft Excel “HOUR, MINUTE, SECOND Functions” are time related functions helps to extract the Hour, Minute or Second from a complete Time.
EXCEL FUNCTION – DAY, MONTH, YEAR
Microsoft Excel “DAY, MONTH, YEAR Functions” are date related functions helps to extract the Day, Month or Year from a Date.