Fill handle tool of Excel helps in applying a formula of current cell to other cells just by dragging. Some time because of some grinch this fill handle doesn’t show up. The following steps will help you bring back the fill handle in Excel. Steps
Microsoft Excel provides a hand and powerful tool to sort data. The default Excel sorting options are setup to sort rows. Let’s say, you want to sort columns in Excel instead of rows i.e. you want to order columns based on data of particular row.
One of the best features of Ms Excel is Macros. In our earlier blog we have shown how to write excel macro to compute liner interpolation, and now we will see how to make a macro available in all workbook. Excel Macro is only available
Interpolation is a way to estimate values between two points of a data set. Most of the real-world data are available as discrete points. Interpolation comes handy if you want to estimate the data between two points. The most simple interpolation is a linear interpolation,