How to Count Cells with Text in Excel
Last week one of my readers asked me for a simple formula which he can use to count cells with text. Actually, he was trying to figure out which is the
Puneet
Top 100 Excel Functions with Examples – A Complete List Including Samples Files
I’m sure you agree with me that “Functions can make you great in Excel”. Well, once you master Excel basics this is the next thing you need to master. But the question
How to Create a Thermometer Chart in Excel
It happens sometimes that when you need to track a goal with its achievement. For this, it’s important to have the right chart. That chart should be able to present your data
How to Insert a Check Mark Symbol [Tickmark] in Excel
Last week while traveling… …I met a person who asked me a smart question. He was quietly working on his laptop… …and suddenly asked me this:“Hey, do you know how to insert a
How to Create Excel PERSONAL.XLSB MACRO Workbook for VBA Codes
If you use a lot of VBA codes like me……then you need to have a place where you can store all of them and use them whenever you need.But the
How to Merge [Combine] Multiple Excel FILES into ONE WORKBOOK
If you ask people who work with data, you will get to know that……combining Excel files or merging workbooks is a part of their daily work.Agree?A simple an example:Let’s say……you