Skip to content
ExcelSirJi
  • Latest BlogsExpand
    • Excel Formula Tips
    • Excel Data Tips
    • Excel Utilities/Templates
    • Excel VBA Codes/Macros
    • Excel Dashboarding Tips
    • Excel Power Query
  • Excel Functions
  • Excel Shortcuts Keys
  • Productivity Tools
Courses
ExcelSirJi
EXCEL FUNCTION – SUMIFS
Excel Formula Tips

EXCEL FUNCTION – SUMIFS

ByPradeep Kumar

SUMIFS function is used to get the “total sum” of values for matching criteria across range. SUMIFS Function has required and optional arguments

Read More EXCEL FUNCTION – SUMIFSContinue

EXCEL FUNCTION – COUNTIFS
Excel Formula Tips

EXCEL FUNCTION – COUNTIFS

ByPradeep Kumar

COUNTIFS function is used to get the total count for number of times the various criteria across ranges are met.

Read More EXCEL FUNCTION – COUNTIFSContinue

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 – INDEX
Excel Formula Tips

EXCEL FUNCTION – INDEX

ByPradeep Kumar

INDEX function is used to get the value from a cell range or table, function returns the value from a table where row and column intersect with each other.

Read More EXCEL FUNCTION – INDEXContinue

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 TEXT FUNCTION
Excel Formula Tips

EXCEL TEXT FUNCTION

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 TEXT FUNCTIONContinue

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 Excel Function PROPER? 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 makes the function…

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 – CONCATENATE
Excel Formula Tips

EXCEL FUNCTION – CONCATENATE

ByPradeep Kumar

CONCATENATE function is used for combining two or more Microsoft Excel strings into one. The output of the function returns as a combined string in new cell.

Read More EXCEL FUNCTION – CONCATENATEContinue

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

Page navigation

Previous PagePrevious 1 2 3 4 5 … 8 Next PageNext
DMCA.com Protection Status
  • Sitemap
  • Privacy Policy
  • Terms of Use
Facebook Twitter Instagram YouTube

© 2023 ExcelSirJi

  • Latest Blogs
    • Excel Formula Tips
    • Excel Data Tips
    • Excel Utilities/Templates
    • Excel VBA Codes/Macros
    • Excel Dashboarding Tips
    • Excel Power Query
  • Excel Functions
  • Excel Shortcuts Keys
  • Productivity Tools
Search