These tutorial has made for the student who is a beginner in Advance excel training in Chandigarh. Microsoft Excel is one of the simplest and powerful software applications available out there. It lets users do statistical , quantitative analysis with an intuitive interface for data manipulation, so much so that its use extends across professional requirements and different domains.

which is often asked in interviews, we will examine some of the advanced formulas and analyze a candidate's Excel skills. Advanced Excel differs completely from Basic Excel, the user's focus is more on DSUM, DCOUNT, Pivot Table, Pivot Chart, Formulas, Functions and Macros.

while working on Advanced Excel Some of the other important concepts to explore are :

• If Statements

• VLOOKUP

• Sum Products

• Concatenate

• SumIfs

IF Statements

It helps to find out how a given data reacts differently to different instances. To put it simply, the best-selling product last month where, according to him, all phones that have sold more than 250 units are in high demand and everything below it is in low demand.

The Syntax for the Statement would be:

=IF(D2>250, “High in Demand”, “Not High in Demand”)

Sum Products

The Sum-Product Formula is important when it comes to excelling calculations. The formula is that it takes an array of numbers and gets the sum of the products of corresponding numbers.

The Syntax is as follows:

=SUMPRODUCT (C2: C6, D2: D6)

C2 and C6 refer to the Price and D2/D6 refer to the number of units sold; the column names change as per the data.

This will fetch a total profit of $ 5,448,800.

VLOOKUP

The VLOOKUP function is used to the value from any cell on the same row of range and searches the first column of a range of cells. He must find out the name of the product with product ID '56'.

Then he uses the following syntax:

=VLOOKUP(56, A2: B6, 2, FALSE)

Here, the formula looks for product ID '56' in the range A2 to B6 and retrieves the value from column 2.

Concatenate

It’s a big word yes, but not to worry. Concatenate is a formula for combining data in two or more different cells into one cell. here we use Syntax:

=Concatenate(A1, “&”, B1)

It also depends on the cell you want to merge.

Excel is as simple as that. It's about understanding the concept, utilizing the syntax and getting the correct results for analysis.

Published by Advance excel training in Chandigarh