While working in Excel, sometimes, you need to think out of the box. It happens to me sometimes… …when I share my dashboards and templates with other users and they made changes
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
Written by Puneet Gogia in Advanced ExcelIn 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
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