Microsoft-Excel

How to use the RANDBETWEEN Function in Excel

The Excel RANDBETWEEN function is very popular function which is located in Math & Trig category. Microsoft Excel RANDBETWEEN function is used to returns a random number between the number you specify. This function returns a random number which is between a bottom and top range. The RANDBETWEEN function in Excel returns a unique random number every time when your spreadsheet recalculates with the help of F9 key. Read More

How to use VLookup with Min Function to get lowest value

If you have a large worksheet data and want to get the lowest value in any column then you must have to use VLookup with Min Function to get lowest value in active worksheet. VLookup function with Min Function allows you to get the lowest value from the list of range. Most of the person have to face this kind of problem but after reading this guide you can easily get the proper solution of your query. Read More

How to sort data based on color in Excel

If you want to give decorative look of your active worksheet data then after fill different cells colors as per your need. After filling the color you can easily sort data based on color in Excel sheet. Excel allows you to quickly sorting by cells as per background color or conditional formatting. During filling the data you have to use different format of cell data. You can sorting text, numbers or any other format data as per your need. Read More

How to Get Classic PivotTable Layout in Excel

All we know that PivotTable plays an important role for creating different MIS reports in Excel. There are different classic PivotTable layout in Excel different versions. If you have latest version of Excel then you will get lot of different layouts and feature during creating the PivotTable in Excel. PivotTable in Excel provide different inbuilt formats and designs which gives a stylish look of your table. Read More

How to Create Group Worksheets in Excel

Group worksheets in Excel is an important utility which allows you to open, make editing in multiple worksheets at the same time. Sometime we need to type data, apply formatting, moving or copying the data and many more things. But when you do this job on a single sheet it could not be possible. But after creating the group worksheets in Excel you can easily do all these jobs which is applicable on all active worksheets. Read More

10 Important Microsoft Excel Tips and Tricks

Microsoft Excel Tips and tricks are too much popular around the world. If you want to become an Excel expert then you must have to no all given important commands. These command helps you to quickly solve your complex task which not only reduce the working time but increase your knowledge also. Excel has wide variety of functions and commands in different versions. If you have latest version of Excel then you can take benefit of different commands. Read More

How to convert standard date mm-dd-yyyy format into mm/dd/ format

Excel by default use MM-DD-YYYY format during filling the date in any cell. But most of the person use different format to fill the date of birth in Excel. Sometime we need to fill the date in different format as compared to standard format. In that situation it will take lot of time to do this job manually. In this guide we have to discuss how to quickly convert standard date mm-dd-yyyy format into mm/dd/ format using Find and Replace command. Read More

How to use Countif function with wildcards in Excel

Countif is an important function which is used to count number of cells which meet the given single condition or criteria. You can use Countif function to count number of cells which have any number, text or dates that match the given specific condition. But sometime we need to use wildcards for partial matching in the given range of cells in active worksheet. In that situation you must know how to use Countif function with wildcards in Excel Read More