Excel Tips

Use of SUMIF function in excel

Goods and Services Tax - Writing an article to appraise readers, how they can use SUMIF in analyzing the financial data. Use of SUMIF in excel: ♠ SUMIF is used to sum up the values of a given range as per the specified criteria. ♠ For example: You are working on GST liability computation and analyzing your ITC register to […]...

Read More

A Very Useful Online Tool for Budgeting and Tax Returns

Goods and Services Tax - Managing your personal finances and tax returns can be quite tedious, but many people have turned to themselves in order to avoid spending unnecessary funds. The majority of documents needed for such tasks can be created using Microsoft’s Excel, because of its resourceful and versatile nature. ...

Read More

How to Get Latest Stock Price in Microsoft Excel

Goods and Services Tax - Have you ever wanted to have live stock up dates in Microsoft Excel? You might interested to watch Share Market to know current value of your portfolio ...

Read More

How to Use SUMIFS – Advance Excel

Goods and Services Tax - Article explains Excel SUMIFS function in 5 different scenario from basic to advance. SUMIFS formula extends abilities of SUMIF function ...

Read More

How to use Two Way Lookup In Microsoft Excel

Goods and Services Tax - Most of us aware that Microsoft Excel can add, subtract, multiply, and divide functions. But if we able to use its advance functions like VLOOKUP, HLOOKUP, INDEX+MATCH coupled with IF function, we can able to demeanor DATA MINING within few minutes which generally takes hours to complete the task and sometime impossible if we are dealing ...

Read More
Sorry No Post Found
Sorry No Post Found
Sorry No Post Found

Recent Posts in "Excel Tips"

Use of SUMIF function in excel

Writing an article to appraise readers, how they can use SUMIF in analyzing the financial data. Use of SUMIF in excel: ♠ SUMIF is used to sum up the values of a given range as per the specified criteria. ♠ For example: You are working on GST liability computation and analyzing your ITC register to […]...

Read More

A Very Useful Online Tool for Budgeting and Tax Returns

Managing your personal finances and tax returns can be quite tedious, but many people have turned to themselves in order to avoid spending unnecessary funds. The majority of documents needed for such tasks can be created using Microsoft’s Excel, because of its resourceful and versatile nature. ...

Read More

How to Get Latest Stock Price in Microsoft Excel

Have you ever wanted to have live stock up dates in Microsoft Excel? You might interested to watch Share Market to know current value of your portfolio ...

Read More

How to Use SUMIFS – Advance Excel

Article explains Excel SUMIFS function in 5 different scenario from basic to advance. SUMIFS formula extends abilities of SUMIF function ...

Read More

How to use Two Way Lookup In Microsoft Excel

Most of us aware that Microsoft Excel can add, subtract, multiply, and divide functions. But if we able to use its advance functions like VLOOKUP, HLOOKUP, INDEX+MATCH coupled with IF function, we can able to demeanor DATA MINING within few minutes which generally takes hours to complete the task and sometime impossible if we are dealing ...

Read More

Spell Check in Excel –How to Use it?

Excel is one of the common application used in our day to day office life and business like word, Power point, outlook etc. In the case of word or Power point any spell mistake is visible with a red underline below the word that is misspelled. However in the case of Excel we mainly deals with figures and such kind of misspelled word are n...

Read More

How to Plot excel data on a Map! [Power View]

With Excel 2010, Microsoft has introduced a cool feature called the Microsoft BI – Business Intelligence tools. One of the tools, PowerView, enables you make some amazing dashboard within a few minutes!...

Read More

Excel Tips – Calculate Years, Months, Days elapsed from a certain date in Microsoft Excel

In order to calculate the time elapsed from a certain date, we will use a birthdate as an example. Enter birthday date in cell A1: 01/01/1980. To calculate the number of years from the date, enter the following formula in cell B1: =YEAR(TODAY())-YEAR(A1) . The result (rounded): 23 Years. For a decimal solution, use the following formula: ...

Read More

How to suppress 0 values in an Excel chart

Charting 0 Values isn’t wrong, but you won’t always want to display them in you charts. Your data and the chart's purpose will guide you in this decision. When you don’t want to display these values, you have a few choices, and some work better than others. We’ll review a few that offer quick but limited results with minimum effor...

Read More

10 powerful ways to use Excel's paste features

Excel’s Paste and Paste Special commands harbor a multitude of useful options. Use them to do everything from transposing data to copying Validation rules. The Paste Special command is in most Office applications, but Excel users probably benefit from it the most. Using this basic feature — as well as assorted Paste options &#...

Read More

Browse All Categories

CA, CS, CMA (3,934)
Company Law (4,137)
Custom Duty (7,110)
DGFT (3,786)
Excise Duty (4,169)
Fema / RBI (3,547)
Finance (3,748)
Income Tax (28,342)
SEBI (2,981)
Service Tax (3,411)

Featured Posts

Search Posts by Date

December 2018
M T W T F S S
« Nov    
 12
3456789
10111213141516
17181920212223
24252627282930
31