### Understanding Excel IF formula

The IF function tests a Condition. If the Condition is met it is considered to be True & if it is not met it is […]

The IF function tests a Condition. If the Condition is met it is considered to be True & if it is not met it is […]

Excel provides 3 useful functions to change the Text to UPPER, lower or Proper Case. Upper(): It converts text to all Upper Case Lower(): It […]

The COUNT function counts the number of cells that contain numbers in a list. It will ignore blanks, Texts and Errors. Syntax: COUNT(value1, [value2], …) […]

Small( ) finds the Nth smallest number in a list. This function examines a list of values and picks the value at a user specified […]

We have got Sales for 3 products over period of 12 months & to understand the trend, we plotted a simple line chart. However, the […]

Many a times the data we have starts with small numbers and then it also has some large numbers. In such a scenario, it becomes […]

Many a times we need to show actual data and forecast as a single trending component. When we are showing the data together, we want […]

We can combine cells in Excel i.e we can join data from two different cells in a single cell. Combine Text from Multiple cells: To […]

As your know, Correlation is a measure of the relationship between two or more sets of data. For example, if we haveĀ monthly figures for […]

In order to find out factorial of a number, you can use Excel FACT () Function. The factorial of 6 is calculated as 1 x […]

Copyright © 2018 | WordPress Theme by MH Themes