Microsoft-Excel

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

Beauty of Goal Seek feature in Excel to Find the Answer

Goal Seek feature in Excel is an important part of What-If-Analysis. it is an important feature of Excel which allows you how to one value in the formula impacts to other cell value. Goal Seek is the best tool used to find the result by adjusting an input value. There are lot of situation in which you can use Goal Seek feature during preparing different kind of reports. If you have more than one variable values and you want to change the final result value but want to apply effect only for one cell. Read More

Latest 7 Excel Tricks which makes you an Excel Expert

Excel plays an important role during daily working on different worksheets. If you have a big data than you must have to use given latest 7 Excel tricks which makes you an Excel expert. Most of the novice Excel users don’t about these tricks. But after using these tricks your working speed is faster than others. You can also gain lot of knowledge about the Excel. If you want to become an expert on Excel then you must know about the different Excel tips and tricks.  Read More

How to use Excel FV – Future Value Function

Hi, today we are talking on The Excel FV – Future Value Function allows you to return the future value of an investment which is based on a periodic, constant interest rate, constant payments. Future value is an important and popular function which is located in the financial category. You can check this function from Formula tab then Financial functions library.

Read More