Explore, Learn and Share

Admit it, Microsoft Excel is one of Awesome application ever build. Still sometime like out of nothing it can give you surprises which will leave with a sour taste.. The other day I opened excel, worked on Expense details, Right Click and What!!! The CUT option is Disable or Grey out. Like you kidding me.. After a little discomforting moments and little google..... Voilla!! Here is the solution.. Go to following path.  C:\Users\vipin\appdata\Roaming\Microsoft\Excel Note: Replace vipin in above with with your Here you will find file Excel15.xlb or Excel14.xlb or Excel12.xlb or similar to this depending upon your Excel version. For me it was Excel15.xlb. I just renamed this file Excel151.xlb. Just rename it to anything, close any open instance of Excel.. Reopen... and that's it. DONE. You now have CUT option back in your life.   

Hi, Previously I wrote about Pivot table , this time lets explore VLookup as this is also one of the very powerful and handy feature of Excel. First lets understand why we make VLookup. A lot of people use Excel as a database, may be due to reasons like business requirement or unknown to the power RDBMS. Although excel can work as a database, some of the tasks that would be very easy in a database program are fairly complex in Excel. One of these tasks is matching two lists based on a common field; this can be easily accomplished using Excel VLOOKUP. In RDBMS, this concept is more like Primary key that is used to establish relation between two tables. You will find the function VLOOKUP to be extremely useful. Click here for the fully described example.

Pivot Table is a summary table of your original spreadsheet. Based on your field selections and how the data should be displayed, a pivot table can aggregate and show a different view of your data. All your comments, suggestions and corrections are welcome on this articles. Feel free to add on this article and help me and others learn more of this powerful tool. This is specially for my wife. For example, create a pivot table for Canada and USA sales report per quarter and year. Create a Table as data source (see the screenshot below) Create a PivotTable . • Click the first left data , in A1 cell, Year field (see black-rectangle in the screenshot above). • Click Data menu, select PivotTable and PivotChart Report submenu. In PivotTable and PivotChart Wizard window, "Where is the data that you want to analyze?" , click Microsoft Office Excel list or database option (see yellow-rectangle in the screenshot above). "What kind of report do you want to create?" , c...