Category: Formulas

Difference Between - "Forecast" & "Trend"

Formulas, Arrays

Hi there,

 


What is your word on this topic?


Do you know the difference between Forecast & Trend functions? Please share your ideas in the below comments section. 


Let me explain the general meaning first:


Forecast: It is something which assumes for future. The expectations of future numbers in terms of company's growth can be called as Forecast.

 

Trend: It is something which represents for current day. Say the trend of the youth in today's generation is carrying Android Mobiles.

 

Similarly, in terms of Excel understanding: 

Full story »

VLOOKUP 2nd Version (Advanced)

Formulas, Tables, Arrays

Hi there,

 

As promissed, VLOOKUP 2nd version (advanced features) is out. 



Download working file here, VLOOKUP and HLOOKUP.xlsx


Alternative Link to the video VLOOKUP 2nd Version


WHAT YOU CAN LEARN FROM THIS VIDEO?

Full story »

VLOOKUP & HLOOKUP Basics

Formulas

Hi there,

 


Are you new to Excel? Do you want to Master Excel Functions, VLOOKUP & HLOOKUP?


Here is an opportunity. I have made this video to one of our viewer who wants to learn these functions from basics.


However, I am sharing to all of you if at all you are looking for the same. So, here you go:



You can also watch this video here VLOOKUP and HLOOKUP Basics

Full story »

Usage of Double Minus ( - - ) in Formulas

Formulas, Arrays

Hi there,

 

In this post, you will be learning why and when to use double minus -- in the formulas. Firstly, have you ever seen double minus symbol in formulas? If yes, have you ever thought why to use such minus symbols. If you know, please skip this post for now, and post your experience in the blow comments section. If you are new to it, then Here we go:

 

WHEN TO USE --?

Double minus ( -- ) will be used when the formula is delivering logical values rather than the numerical values. 


WHY TO USE --?

Full story »

Get Distinct Count with Formulas

Formulas

Hi there,

 deepshika.in is a retail shopping cart for who loves to shop and get their stuff to doorstep.

I have a simple formula which gives a sum of distinct names in a list. Which means, unique names in a list. To get into that formula let's take an example when this function is required or useful.

Recently, I have started an e-commerce website by name www.deepshika.in here I have few sales representatives who sell my products to the retail shops.

Now, the sales reps are countable.

Let's say the number of retailers has been increased to 50 or 100 times from now. Is it easy for me to maintain with the current sales representatives. 

No! right?

Full story »

EVALUATE "FUNCTION" Excel Knowledge

Formulas, How-to's, VBA

Hi there,

 

www.deepshika.in is an another e-commerce website for whom looking for genuine shopping cart

Today, I am forced to learn about a new function in excel. Basically, it is not new but very few will know/use this function. The function name is EVALUATE. This is basically a macro function which is available in Excel 4.0 version. You can also see an alternative functions like this in my previous posts, in List FileNames in a Folder and Count Worksheets in a Workbook

EVALUATE function have a flavour of INDEX function. Not exactly but just a flavour. This function works in macro enabled workbooks only. Let's see why we use and how to utilize this function on our requirements on day-to-day excel works.


evaluate-function-macro-enabled-function.mp4

 

Sometimes, when we write a formula and to display it to the audience to know which formula we have used we will add ' (single apostrophe) in the start of the formula. So that it will not show the results but display the complete formula. Say, we have few calculations mentioned in a cell without giving = (is equal to) symbol, like 

Full story »

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