Category: How-to's

Pie Chart to show % Progress

charts, How-to's

Hi there,

 Share on Facebook

 

There is an important point to remember while using PIE chart. Pie Chart can be used only when the value or sum of values meets to 100%. 

I have been to an interview, there, the interviewer asked me a question on pie chart. He gave few numbers and asked me to show the rough diagram of pie. In this case, first thing we should do is sum the values (and see if the values are equal's to 100. or even if the values are more than 100 we should apply some mathematical operations to all the values which results to 100. The way I did for the below data set). For me, it was 110. So, directly I told him this is not possible and the reason is so and so... So, be aware not to get kicked by your interviewer but kick his butt with your answer(s).

Full story »

Excel Animation using In-cell Charts

Formulas, charts, How-to's, Excel Tips

Hi there,

  Share on Facebook




In today's generation people use more creativity to do things with existing one's when compared to discovering new things. The reason is very simple, most users use Excel in the way the features are but very few of them will experiment and create new methods using existing features. Do you agree?. thank you.


To proceed further,

Full story »

Change Gridline Colour - Quick Tip

excel_usage, How-to's, Excel Tips

Hi There,

  Share on Facebook




Have you fed up with gridline colour (black) in Excel. Did you ever cracked your head to know how to change gridline colour. Then, Not to worry, here is a quick tip for you to change the gridline colour from black to any other colour. 


Come-on Pick-up your colour as quick as you can otherwise it is difficult to change. ;)




Full story »

List File Names in a Webpage (no FUNCTIONS)

excel_usage, How-to's

Hi there,

  Share on Facebook




Today, I found a nice trick. We have seen how to List File Names in a Folder (No VBA) but we will try it in a different and a simple method with out using a single function.

 
 

Confused!!!


Worry not. Here we go:

Full story »

Sort Data Using Formulas

How-to's, Excel Tips

Hi there,

 Share on Facebook





After a long gap I am again connecting with you to share Excel tips. I was very busy in recording videos and preparing worksheets (templates) for Excel Master School. However, here is a short tip for you. Sorting range of data using formulas.

Full story »

Combine All Text Cells into One Cell (Quick Tip)

excel_usage, How-to's, Excel Tips

Hi there,

 Share on Facebook



Again, a great tip from one of our excel lovers is that ... wait! first we will see what is the question here. The question is that how to combine or concatenate different cells or cell ranges containing text into one single cell. Most users does this by using an inbuilt Excel function called CONCATENATE however it is a lengthy and tedious process. 

To overcome the tedious process here is how we can do to combine all text cells in to one cell.


 REQUIREMENT:

  • CONCATENATE
     
  • TRANSPOSE


PROCEDURE TO COMBINE MULTIPLE TEXT CELLS INTO ONE CELL: 

Full story »

Contact / Help. ©2019 by Abhilash VK. Design & icons by N.Design Studio. Skin by Tender Feelings / Skin Faktory.