Category: How-to's

SUM values using Check Boxes (check how?)

Formulas, How-to's, VBA, Applications

Hi there,



One of the Excel Lover tried summing a list using check box. This is something like thinking out of box. Are you eager to know how to do this. Here we go:

 

PRE WORK:

Set the raw data to do this. Here, I am using the Vegetables bought from the market today. Here, I have to disclose you how typically our villagers market their products.

In my village we will have market open on Wednesday, which means sellers from different place comes to our village to sell their goods. Goods interms of Vegetables, leafy vegetables, Stationary, Groceries and all kinds of petty shops for that matter. Every one comes to one village, Wednesday is in our village, and sells their goods and go back in the evenings. Next day will be the other village which is closer to our village. This is how the routine work of the sellers in the villages.

Full story »

FORECAST FORMULA

Formulas, How-to's

Hi there,

 

 

Do you know we have a formula in Excel by name FORECAST. If you are not aware or not used yet, no problem! that is why this space is obtained for. 

Learn how to FORECAST using Excel?

 

WHAT IS FORECAST?

 

How to use Forecast Formula?

This formula is basically used when a company requires to forecast their business for coming year or for future years from now. It is also called as prediction of company's growth or company's KAZANAAA...(wealth).

 

SYNTAX:

FORECAST(x,known y's, known x's)

in other words

Full story »

Turn On Conditional Formatting

How-to's, CF

Hi there,

 



Today's topic is really mind blowing for all the Excel Lovers. And, I also hope there will be lots of comments to this post too. The reason is ...

 

I am sorry, if you are thinking "Shit! come on man, tell me what is the topic for today, give the topic".

 

The topic for today is how to apply Conditional Formatting to the set of data just by clicking on the button.

 Turn On & OFF using Conditional Formatting technique
 

Full story »

How to Get Decimals using RANDBETWEEN

Formulas, How-to's

Hi there,

 


How are you doing today. Hope all is well. Today, I have learnt how to get decimal values using RANDBETWEEN. So, anxiety to share with you before I forget.

 

HOW RANDBETWEEN WORKS?

This function can be used when we require random numbers between the two numbers. This function has two arguments that is bottom and top. In the argument bottom keep the lowest value and in arugment top place the largest value which needs to display randomly.

Full story »

Formulas Cheat Voice (Revealed)

Formulas, How-to's

Hi there,

 Share on Facebook



Quite some time internet is running out of Excel Cheat Sheet's. So, my mind striked through yesterday stating why can't we start cheat - voice which means adding voice to the cheat sheet. So, here we are today. 

I am actually sharing my Formulas Cheat Sheet to the viewers, who subscribe to, our blog "exceltoxl", however from today onwards it will be revealed and kept in public for the usage of maximum Excel lovers. Also, download Cheat Voice and its working file from here.

Full story »

Waffle Chart

charts, How-to's

Hi there,

 Share on Facebook



Most of you all are back to your homes from the capital cities, Right?, to celebrate the biggest South Indian festival i.e., UGADI. This is also called as NEW YEAR. There are many reasons which supports why we celebrate UGADI as NEW YEAR, however, not to dig into those things now let's all celebrate our NEW YEAR's BASH this Monday! and enjoy the 3 day long weekend.


HAPPY UGADI and HAPPY NEW YEAR to you all. God bless to keep you up always.


ONE GOOD NEWS:

A special gift is awaiting for you this , Monday, UGADI so keep watching... :)


Now, the topic for the day is WAFFLE CHART. How to prepare it? What to use this chart? Let's discuss one by one here.

Full story »

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