Lesson#113: How to highlight cells with errors in it

I will show you how to highlight cells with errors among an array of values. Here I am having an array of values and among them I have some cells which contains errors. If you need to highlight those cells only which are having errors in it then follow these steps. 1st step: First You…

Lesson#111: Extract parts of text separated by special character

Here I will show you how to extract parts of text separated by a special character. In the above image I am having some structure id. Each text have four parts separated by “/”. Each parts has a different meaning. The first means short form of station name, second part is level, third part is…

Lesson#110: Separate characters from text where any word appears

Here I will show how to separate characters from text where any text appears. Here in the above picture I am having some text values which contains the word “made”. I will show you how to part out text value from where the word appears. So I will find out location of the word and…

Lesson#109: Tricks to make a dancing chart in excel

┬áHere I will show you funny trick to make a dancing chart in excel. For that you have to follow some steps. 1. Make a range of data names like A, B, C, D….. 2. Then put values against these names with RANDBETWEEN formula by putting any arbitrary lower and upper values.   3. Then…

Lesson#108: How to divert user to another cell in workbook when clicked

┬áHi friend. Here I will show a method to divert a user to anywhere in workbook when a link is clicked. For this some steps are required. Right click on the cell where the link has to be created. Then click on Hyperlink like it has shown in picture.   Click on Place in This…

Lesson#107: How did I add MS Project features in Excel project schedule

Here I will discuss a long topic about Excel gantt chart making. I will show how I made my excel chart work like ms project schedule by adding some basic features. Some basic features of ms project which I added are. Auto updating chart month wise. Easy calculation of working days by considering holidays, weekends….

Copyright 2017-2018@Excelabcd