Skip to content
ExcelSirJi
  • Home
  • Latest BlogsExpand
    • Excel Formula Tips
    • Excel Data Tips
    • Excel Utilities/Templates
    • Excel VBA Codes/Macros
    • Excel Dashboarding Tips
    • Excel Power Query
  • Courses
  • Excel Functions
  • Excel Shortcuts
  • Premium Downloads
ExcelSirJi

excel function

Home / excel function
Excel Function – WEEKNUM Function
Excel Formula Tips

Excel Function – WEEKNUM Function

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

Read More Excel Function – WEEKNUM FunctionContinue

Excel Function Replace
Excel Formula Tips

Excel Function Replace

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

Read More Excel Function ReplaceContinue

EXCEL FUNCTION – AVERAGE
Excel Formula Tips

EXCEL FUNCTION – AVERAGE

ByPradeep Kumar

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.

Read More EXCEL FUNCTION – AVERAGEContinue

EXCEL FUNCTION – INDIRECT
Excel Formula Tips

EXCEL FUNCTION – INDIRECT

ByPradeep Kumar

INDIRECT function is used to convert the text/string into cell reference. Function provides output as the value of that cell reference.

Read More EXCEL FUNCTION – INDIRECTContinue

EXCEL FUNCTION – SUMIF
Excel Formula Tips

EXCEL FUNCTION – SUMIF

ByPradeep Kumar

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.

Read More EXCEL FUNCTION – SUMIFContinue

EXCEL FUNCTION – HOUR, MINUTE, SECOND
Excel Formula Tips

EXCEL FUNCTION – HOUR, MINUTE, SECOND

ByPradeep Kumar

Microsoft Excel “HOUR, MINUTE, SECOND Functions” are time related functions helps to extract the Hour, Minute or Second from a complete Time.

Read More EXCEL FUNCTION – HOUR, MINUTE, SECONDContinue

EXCEL FUNCTION – DAY, MONTH, YEAR
Excel Formula Tips

EXCEL FUNCTION – DAY, MONTH, YEAR

ByPradeep Kumar

Microsoft Excel “DAY, MONTH, YEAR Functions” are date related functions helps to extract the Day, Month or Year from a Date.

Read More EXCEL FUNCTION – DAY, MONTH, YEARContinue

  • Sitemap
  • Privacy Policy
  • Terms of Use
Facebook Twitter Instagram YouTube

© 2022 ExcelSirJi

  • Home
  • Latest Blogs
    • Excel Formula Tips
    • Excel Data Tips
    • Excel Utilities/Templates
    • Excel VBA Codes/Macros
    • Excel Dashboarding Tips
    • Excel Power Query
  • Courses
  • Excel Functions
  • Excel Shortcuts
  • Premium Downloads
Search