Dummy Data Generator Tool
Table of Content How does testing help? How should I test my tool or application? How does Dummy Data Generator tool helps in testing? How do I use this tool? From many years I have…
Table of Content How does testing help? How should I test my tool or application? How does Dummy Data Generator tool helps in testing? How do I use this tool? From many years I have…
Employee Database is an MS Access based tool to manage employee details. The tool supports upto 78 demographics for each employee such as Name, Location, Phone, Email, Address etc. The tool also comes with inbuilt attendance tracker to track daily attendance of employees. Over and above this, you can also design your own trackers and start using it.
Excel Add-in helps you to extend the features of Excel application. Using Excel Add-in, you can perform custom actions in Excel such as formatting the data, doing complex calculations which are not possible through Excel formulas, Reading or Writing data in other Excel files and so many more actions.
Excel Function- WORKDAY.INTL 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…
Excel Function COUNTIF 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…
Generate Random Numbers in Excel Using RAND We have got many instances where we needed to generate a random database or values. Rand function is very useful for the users who creates random database for…
Here we are coming with one more exciting post which can help you to solve very basic but very important problems while writing VBA codes.
WORKDAY Function in Excel 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 commonly used function in Excel…
Excel Function SUBTOTAL Excel Function “Subtotal” is most commonly used formula in excel and it can make your work easy while performing simple mathematical calculations because of variety of features like: – You can use…
SUM Function in Excel Excel is a mathematical spreadsheet where you can perform multiple calculations with the help of Excel Formulas. These are automated formulas which refreshes automatically once you refresh your data in a…
While starting Excelsirji.Com, it is always been critical for me to find the best to amaze the viewer experience. So I spent many hours on web to read, explore amazing excel content which I really…
Random Rows Selector is an MS Excel based tool which can be used to pick random or stratified samples from a set of records available in the Excel. The tool is fully dynamic, it can support any data format in Excel.
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.
RAND AND RANDBETWEEN 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…
Calculations With Date In Excel Dates function also be used to subtract the Year, Month and Days from the existing dates. Sometimes we need to subtract specific period from the date. In case you are…
How to Create a Pivot Table? Pivot Tables in excel is backbone of data analysis in excel. If you want to perform various analysis in excel, then I would suggest, learn this amazing excel feature…
Excel Function DATE While using Microsoft Excel, you must have got the situation where you need to use the Date function. Date function is one of the common and most used function in Excel that…
What is Pareto Chart? Pareto principle was introduced by Italian Economist Vilfredo Pareto. He stated that 80% of the effects are caused by 20% of the causes. So if we closely monitor and solve 20% of…
VBA code that will sum cells by its color through excel function. This code will really help in making the analysis and presentation better.
How to Insert Symbol in Excel? Have you ever faced the challenge of using special character symbols in number formatting or customized number formatting? It is easy to insert any symbol in numbers i.e Delta…
Delta Symbol in Excel The Greek Capital Alphabet letter Delta (▲) and is commonly discussed topic in Excel. This is being used for various purposes i.e. changes in quantity, insert the symbol in excel etc….