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 Functions

Home / Excel Functions - Page 2
EXCEL FUNCTION – COLUMNS
Excel Formula Tips

EXCEL FUNCTION – COLUMNS

ByPradeep Kumar

COLUMNS function is used to get the total count of columns in an array or in cells range for excel worksheet.

Read More EXCEL FUNCTION – COLUMNSContinue

EXCEL FUNCTION – COLUMN
Excel Formula Tips

EXCEL FUNCTION – COLUMN

ByPradeep Kumar

COLUMN function is used to get the column reference number of the excel worksheet. COLUMN Function has only one argument.

Read More EXCEL FUNCTION – COLUMNContinue

EXCEL FUNCTION – TRIM
Excel Formula Tips

EXCEL FUNCTION – TRIM

ByPradeep Kumar

TRIM function is used to remove the additional spaces (i.e. spaces before/after/between the words) except for single space between words.

Read More EXCEL FUNCTION – TRIMContinue

EXCEL FUNCTION – TEXT
Excel Formula Tips

EXCEL FUNCTION – TEXT

ByPradeep Kumar

TEXT function is used to change the formatting or appearances of the text. There are various types of formatting available.

Read More EXCEL FUNCTION – TEXTContinue

EXCEL FUNCTION – REPT
Excel Formula Tips

EXCEL FUNCTION – REPT

ByPradeep Kumar

REPT function is used to repeat the text or cell reference to multiple times

Read More EXCEL FUNCTION – REPTContinue

EXCEL FUNCTION – SUBSTITUTE
Excel Formula Tips

EXCEL FUNCTION – SUBSTITUTE

ByPradeep Kumar

SUBSTITUTE function is used to substitute the existing old text to new text.

Read More EXCEL FUNCTION – SUBSTITUTEContinue

EXCEL FUNCTION – SEARCH
Excel Formula Tips

EXCEL FUNCTION – SEARCH

ByPradeep Kumar

SEARCH function is used to find “position of character or text” in an available cell and this function is NOT case sensitive.

Read More EXCEL FUNCTION – SEARCHContinue

EXCEL FUNCTION – FIND
Excel Formula Tips

EXCEL FUNCTION – FIND

ByPradeep Kumar

FIND function is used to find the position of text, or character in an available string.

Read More EXCEL FUNCTION – FINDContinue

EXCEL FUNCTION – LOWER
Excel Formula Tips

EXCEL FUNCTION – LOWER

ByPradeep Kumar

LOWER function is used for changing the format of any text or string to LOWER case.

Read More EXCEL FUNCTION – LOWERContinue

EXCEL FUNCTION – PROPER
Excel Formula Tips

EXCEL FUNCTION – PROPER

ByPradeep Kumar
How to use “PROPER” function in Excel PROPER function is used for changing the format of any text or string to PROPER or SENTENCE Case. PROPER Function has argument only one argument i.e. text, which...

Read More EXCEL FUNCTION – PROPERContinue

EXCEL FUNCTION – UPPER
Excel Formula Tips

EXCEL FUNCTION – UPPER

ByPradeep Kumar

UPPER function is used for changing the text/string to UPPER case in Microsoft Excel. The output of the function returns value in new cell.

Read More EXCEL FUNCTION – UPPERContinue

EXCEL FUNCTION – LEN
Excel Formula Tips

EXCEL FUNCTION – LEN

ByPradeep Kumar

LEN function is used for counting number of characters in available string. The output of the function returns the count in new cell.

Read More EXCEL FUNCTION – LENContinue

EXCEL FUNCTION – RIGHT
Excel Formula Tips

EXCEL FUNCTION – RIGHT

ByPradeep Kumar

RIGHT function is used for extracting the “Right Most” characters from the available string in Microsoft excel. Function returns value to new string.

Read More EXCEL FUNCTION – RIGHTContinue

EXCEL FUNCTION – MID
Excel Formula Tips

EXCEL FUNCTION – MID

ByPradeep Kumar

MID function is used for extracting the mid characters from the available string. The output of the function returns the extracted characters in new cell.

Read More EXCEL FUNCTION – MIDContinue

EXCEL FUNCTION – LEFT
Excel Formula Tips

EXCEL FUNCTION – LEFT

ByPradeep Kumar

LEFT function is used for extracting the “Left Most” characters from the available string. The output of the function returns the extracted characters in new cell

Read More EXCEL FUNCTION – LEFTContinue

EXCEL FUNCTION – TODAY
Excel Formula Tips

EXCEL FUNCTION – TODAY

ByPradeep Kumar

Microsoft Excel “TODAY” function is used to get the current Date. It is very useful function and can be used in many ways. “TODAY Function” does not have any argument that makes this easy to apply and implement.

Read More EXCEL FUNCTION – TODAYContinue

EXCEL FUNCTION – WEEKDAY
Excel Formula Tips

EXCEL FUNCTION – WEEKDAY

ByPradeep Kumar

WEEKDAY function applies to a Date and returns the output for Day of the week. The output of the function varies from 0 to 7

Read More EXCEL FUNCTION – WEEKDAYContinue

EXCEL FUNCTION – DATEVALUE
Excel Formula Tips

EXCEL FUNCTION – DATEVALUE

ByPradeep Kumar
How to Change TEXT into DATE Format Microsoft Excel “DATEVALUE” is the very useful where dates are available as TEXT and need to convert them to proper DATE format. DATEVALUE function helps to convert the...

Read More EXCEL FUNCTION – DATEVALUEContinue

EXCEL FUNCTION – AND, OR, NOT
Excel Formula Tips

EXCEL FUNCTION – AND, OR, NOT

ByPradeep Kumar

AND, OR, NOT Functions” provide result in “TRUE” or “FALSE”. If the logical condition is correct and matching the parameters provided, then result would be “TRUE” or if logical condition is not correct and not matching the parameters provided then result would be “FALSE”

Read More EXCEL FUNCTION – AND, OR, NOTContinue

EXCEL FUNCTION – ISERROR
Excel Formula Tips

EXCEL FUNCTION – ISERROR

ByPradeep Kumar
Microsoft Excel “ISERROR Function” is a Logical Function and it is used to check if cell contains any “ERROR”. “ISERROR Function” is used as a test to validate if cell contains any Error or not....

Read More EXCEL FUNCTION – ISERRORContinue

Excel Function – WORKDAY
Excel Formula Tips

Excel Function – WORKDAY

ByPradeep Kumar
Watch Excel Tutorial Video - Excel Function - Workday Are you working today? or Do you have Work Off or holiday today? I am asking this question because I am gonna tell you the most...

Read More Excel Function – WORKDAYContinue

Page navigation

Previous PagePrevious 1 2 3 Next PageNext
  • 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