How to generate random numbers in Excel

Random numbers are automated generated numbers that are displayed without an order. When working on a worksheet, the user may need to generate random numbers to perform various tasks. This…

Comments Off on How to generate random numbers in Excel

How to prevent Excel from rounding off numbers

Microsoft has designed excel in a way that will be efficient and easy to use for its users. However, some of the features of Excel can be counterproductive and thus…

Comments Off on How to prevent Excel from rounding off numbers

How to combine data from 3 cells into one

At times we work with large worksheets in an Excel workbook. It becomes a dreaded issue when you want to combine all your data, as most people automatically think it…

Comments Off on How to combine data from 3 cells into one

How to count cells that contain only N character

Excel is a powerful and very helpful Microsoft program for data analysis and documentation. OK is a spreadsheet program with many columns and rows, and sometimes we need to know…

Comments Off on How to count cells that contain only N character

How to Remove Characters in Excel Cells

Formulas are key in getting things done in excel. One can apply formulas to manipulate texts, work with dates and time, count and sum with criteria, create dynamic ranges, and…

Comments Off on How to Remove Characters in Excel Cells

Excel formula for percentage

Anyone who constantly works with numbers probably also works with percentages. Calculating percentages apply in many areas of our day-to-day and everyday lives. Some of the areas we apply percentages…

Comments Off on Excel formula for percentage

How to add odd numbers only in range

If you have a worksheet full of odd numbers and you want to add them, you can use this formula to get their sum. The formula {=SUM(Range*(MOD(Range,2)=1))} Do not type…

Comments Off on How to add odd numbers only in range

How to use date formula in Excel

Sometimes excel interprets date formats as a text string. Microsoft Excel has an inbuilt date formula that any frequent user of excel is aware of. It is the primary function…

Comments Off on How to use date formula in Excel

How Do I Auto fill my Formula in Excel?

Excel Formula is an expression that calculates values in a cell or a range of cells. Formulas help you design good spreadsheets. The use of formulas in excel drastically minimizes…

Comments Off on How Do I Auto fill my Formula in Excel?

How to lookup frequently appearing text in Excel

The maximum number in which a text is repeated in a string is normally referred to as the frequently occurring text. There are many ways you can find them, and…

Comments Off on How to lookup frequently appearing text in Excel