All About Paste Special Feature in Excel
While working with Excel or any other Microsoft Utility, the most used function is copying the data and pasting it to some other location. But… Read Article
Add Macro to Quick Access Toolbar and Ribbon
In the previous blogs, we had learned how one can start automation in excel by recording a macro and then running it. We had also… Read Article
Unlocking SUBTOTAL Feature in Excel
To mathematically define the term SUBTOTAL, it is nothing but a summary total. It can be said to be a total before a grand total.… Read Article
Group and Ungroup Rows in Excel
In this blog, we would learn how to group and ungroup the rows in excel to organize our data table properly. This technique would allow… Read Article
Insert Line Break in Excel – Add More Line in Cell
What happens when you type something in a Microsoft Office Word document and press the ‘Enter’ key? The cursor would go on the next and… Read Article
Start Automation – Record A Macro in Excel
Many a time, while working with an Excel worksheet, you may do one or more tasks repeatedly each time you open a new worksheet. For… Read Article
VLOOKUP and HLOOKUP in Excel
The VLOOKUP and HLOOKUP formula in Excel is the two most important and widely used functions of Excel. These two functions are the lookup functions… Read Article
Convert Date To Quarter in Excel
Do you know how to convert a date or a month into the quarter in Excel? In this blog, unlock multiple ways to convert the… Read Article
How to Hide Formula in Locked Cells in Excel
In the previous blog, we learned how to lock the cells in Excel. In continuation, in this blog, we would unlock the technique to hide… Read Article
How to Lock and Protect the Cells in Excel
Sometimes you may want that data that you have entered into your excel worksheet should not be changed by anybody. To do the same, excel… Read Article
What-If Analysis – Data Table in Excel
In our previous blogs, we learned about two of the What-If Analysis features in Excel – Goal Seek and Scenario Manager. In this blog, we… Read Article
What-If Analysis – Scenario Manager in Excel
In our previous blog, we had learned about the Excel What-If Analysis Goal Seek tool. The Goal Seek feature helps us to find the value… Read Article