Uncategorized

2 level Sorting

2 level Sorting

You can sort data by text (A to Z or Z to A), numbers (smallest to largest or largest to smallest), and dates and times (oldest to newest and newest to oldest) in one or more columns. You can also sort by a custom list (such as Large, Medium, and Small) or by format, including cell color, font color, or icon set. Most sort operations are column sorts, but you can also sort by rows.

Sort criteria are saved with the workbook so that you can reapply the sort each time that you open the workbook for an Excel table, but not for a range of cells. If you want to save sort criteria so that you can periodically reapply a sort when you open a workbook, then it’s a good idea to use a table. This is especially important for multicolumn sorts or for sorts that take a long time to create.

You can also learn more Advance Excel formula trick.

Or Visit Us. Excel Training in Gurgaon, Mumbai, Delhi

Advertisements
Uncategorized

Calculating Year on Year Percentage Growth

Calculating Percentage

Calculating Year on Year % Growth in Excel in Hindi

First: work out the difference (increase) between the two numbers you are comparing.

Increase = New Number – Original Number

Then: divide the increase by the original number and multiply the answer by 100.

% increase = Increase ÷ Original Number × 100.

If your answer is a negative number then this is a percentage decrease.

You can also learn more Advance Excel formula trick.

Or Visit Us. Excel Training in Gurgaon, Mumbai, Delhi

Uncategorized

SUMPRODUCT() in Excel in Hindi

SUMPRODUCT() in Excel in Hindi

Multiplies corresponding components in the given arrays, and returns the sum of those products.

The array arguments must have the same dimensions. If they do not, SUMPRODUCT returns the #VALUE! error value.

SUMPRODUCT treats array entries that are not numeric as if they were zeros.

You can also learn more Advance Excel Tips & Tricks.

Or Visit Us. Excel Training in Gurgaon, Mumbai, Delhi.

Online Courses · Tutorials

Learn Pivot Table in 10 minutes

Learn Pivot Table Basics in 10 Minutes in Hindi
Being able to quickly analyze data can help you make better business decisions.

But sometimes it’s hard to know where to start, especially when you have a lot of data.

PivotTables are a great way to summarize, analyze, explore, and present your data, and you can create them with just a few clicks.

PivotTables are highly flexible and can be quickly adjusted depending on how you need to display your results.

You can also create PivotCharts based on PivotTables that will automatically update when your PivotTables do.

Pivot Table are one of Excel’s most Powerful Features.

You can also learn more advanced excel formula trick.

Or Visit Us. Excel Training in Gurgaon, Mumbai, Delhi