Category: Formulas

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 »

INDEX / MATCH works well with Cell Reference

Formulas, Arrays

Hi there,


 


INDEX MATCH Function Explains Here
 

In this post, we will learn about how INDEX MATCH combination help us work with cell reference. Usually these combination helped us in giving the results (values) directly which means based on the values but here these functions are used in place of cell reference to achieve the results. That is the greatness of this post.


 

DUMMY CLIENT DATABASE:

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 »

Learn Formulas

Formulas

Hi there,

 Share on Facebook


To achieve our day to day reporting needs we require functions and formulas. I strongly believe this because I use much while reporting. How about you? Do you have any other features in mind, please do share it with us in the comments. The one who stands with me can proceed...

 
 

Here, I want to tell you a story before I end up this post. To start with, there was a family with two children. One boy by name IFERROR, he is very simple but strong in his activities the other one is his sister by name ISERROR. Both brother and sister are very friendly, very talented and very supportive to each other. The villagers are always very close to them. One day they had a small dispute and started comparing each other, IFERROR vs ISERROR,. This dispute spread across their village and notified to the king of their constituency.

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 »

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