Often there are some cells in our worksheet… …where we have important formulas. And, those formulas help us to calculate some crucial values.In this situation, it’s really important to take an eye
In my starting days with Excel, I was really bad at consolidating data. If you asked me to capture sales data for four different zones, I would create four different worksheets
Everyone know that we can find and replace a text with find and replace option. But very few people know that you can use this option to an advance level.
A drop down list is an awesome tool. You can pre-define some values and user can enter data by selecting one of those values.One of its advanced features is a
One of the most demanding and fascinating things for an Excel user is to create interactive things in Excel. And a checkbox is a small but powerful tool… …that you can use
In high school… …I used to solve mathematical equations… …where I have the result of the equation… ..but don’t have the input value.So, if you think about to solve the same kind of