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 formula

Home / excel formula
Excel Function – WORKDAY.INTL
Excel Formula Tips

Excel Function – WORKDAY.INTL

ByPradeep Kumar

WORKDAY.INTL function is an advanced version of WORKDAY function with additional advantage of “Custom weekend options” For Example, with WORKDAY function weekends are treated as “Saturday and Sundays” however if you need the weekend to…

Read More Excel Function – WORKDAY.INTLContinue

EXCEL FUNCTION – COUNTIF
Excel Formula Tips

EXCEL FUNCTION – COUNTIF

Byexcelsirji

COUNTIF Excel Function is also one of the most used function in excel. This helps the user to calculate the number of counts based on single logic given by the user. You can use this…

Read More EXCEL FUNCTION – COUNTIFContinue

VBA Code to Count Cells by Color
Excel VBA Codes/Macros

VBA Code to Count Cells by Color

Byexcelsirji

Have you ever felt that Microsoft should have added a formula in Excel which can count the cells based on specific color? I have seen many code requests to share a VBA code that can count the cells by its color. To help our subscribers and developers, we are sharing 2 codes that be used to count the cells with specific color and returns the count of the matching color cells.

Read More VBA Code to Count Cells by ColorContinue

How to Use RAND and RANDBETWEEN Functions in Excel
Excel Formula Tips

How to Use RAND and RANDBETWEEN Functions in Excel

ByPradeep Kumar

RAND Function We have got many instances where we needed to generate a random database or values. “RAND function” is very useful for users who creates random database for various types of working and analysis….

Read More How to Use RAND and RANDBETWEEN Functions in ExcelContinue

VBA Code to Sum Cells by Color
Excel VBA Codes/Macros

VBA Code to Sum Cells by Color

Byexcelsirji

VBA code that will sum cells by its color through excel function. This code will really help in making the analysis and presentation better.

Read More VBA Code to Sum Cells by ColorContinue

TRIM Excel Formula – How to remove extra spaces or leading spaces in Excel?
Excel Formula Tips | Excel Data Tips

TRIM Excel Formula – How to remove extra spaces or leading spaces in Excel?

Byexcelsirji

You must have faced a condition when your data cells contain extra spaces, leading spaces or trailing spaces and you wanted to remove these extra spaces to standardize the data. So here you may use…

Read More TRIM Excel Formula – How to remove extra spaces or leading spaces in Excel?Continue

  • 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