Lesson#117: How to split up characters of text in excel

Here I will show you a nice trick to split up characters of text in excel. You can see in the above picture I am having a merged cell to put a text in it. I will develop a formula which will split up all characters of the text vertically in a column. Now I have…

Lesson#87: How to make month wise auto updating program schedule

Previously I have discussed in a post Lesson#39: Cool tricks to make automatically updating gantt chart without using excel chart It was a day wise scheduling format. Here I will show how to make a month wise scheduling format. First I will make the date format above the gantt chart area by “mmm-yy” from Format…

Lesson#81: Making an automatic analog clock in excel with pie chart

Previously I had discussed about 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 pie chart Now I will add some simple VBA to make the clock auto refreshed every second. So I have taken these simple steps. 1. From…

Lesson#77: Scope breakup program schedule and explaining formula

Here I have got a case when my colleague was working with a project schedule. He had a schedule with start date, end date and scope and he had to breakup the scope month wise. With a long schedule this was very hectic work to break it manually so I developed a formula. In this…

Lesson#61: Making a semi analog clock with pie chart

OK friends! How is everyone. Now in this post we will learn an unusual trick to make a semi analog clock with Pie Chart. Let’s see. First I have made 3X3 table for hour, minute, second of current time.   Here in this Hour cell I have put this formula =MOD(HOUR(NOW()),12) to show the current hour…

Lesson#59: If A=1, Z=26 then calculate the value of your name

This sheet can calculate the value of your name or any word by summing every letter with alphabetical order. Here I have created a box to input a word. I have put this formula =LEN(B2) to calculate the length of the word. Now I have written A-Z in a column and in the next column I…

Copyright 2017-2018@Excelabcd