Here I will discuss a very useful feature Text to Columns. We can use this feature to split the data into cells throughout the column and split it into many columns very easily. In the above picture, we can see …
Lesson#84: Separate text in different columns easily Read more »
I always hear a common question from beginner Excel users “How to make a drop-down menu in Excel?”. I would like to ask them have used the feature Data Validation. Select all the cells on which you want to create …
Lesson#83: How to add a drop-down in an excel sheet Read more »
There is a nice feature in Excel by which we can type in multiple sheets at one time. Step 1: For that, you have to just press Ctrl and select all those sheets where you want to type. Step 2: …
Lesson#82: Type in multiple sheets at one time in Excel Read more »
Previously I had discussed how to make an analog clock with piechart in excel. I am sharing the post link below. Lesson#61: Making a semi-analog clock with a pie chart Now I will add some simple VBA to make the …
Lesson#81: Making an automatic analog clock in excel with a pie chart Read more »
We will learn how to make an automatically refreshing bar clock in excel. 1. First I made three merged cells by putting these formulas =HOUR(NOW()) =MINUTE(NOW()) =SECOND(NOW()) 2. Select those cells one by one and click on Conditional Formatting>Data …
Lesson#80: Make an automatically refreshing bar clock in Excel Read more »
Let me show you how to make a spreadsheet that changes its color every second automatically. to make this you have to follow some steps where I will apply a little VBA to make it really automatic. 1. Click the …
Lesson#79: Automatic changing Excel sheet color every second Read more »
Now I will show how to make a spreadsheet that changes its color every minute automatically. to make this you have to follow some steps. 1. Click the upper left corner of the sheet to select all of the spreadsheets. …
Lesson#78: Change the color of the whole sheet every minute in Excel Read more »
Here I have got a case where my colleague was working with a project schedule. He had a schedule with a start date, end date, and scope and he had to break up the scope month-wise. With a long schedule, …
Lesson#77: Scope the breakup program schedule and explain the formula Read more »
What is the function EDATE? UPDATE returns the serial number format date with the same day before or after a specified number of months of a specified date. Syntax of EDATE is EDATE(start_date, months) start_date: A date in a valid serial …
Hello friend. In this post, I will show how to get a new fresh formatted sheet every time when you click the button in the excel sheet. That thing is exactly needed for making invoices in a store, shop, or …
Lesson#75: Get a new fresh formatted sheet every time when you click the button Read more »