Excel Tips

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 […]...

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. ...

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 ...

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

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 ...

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...

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!...

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: ...

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...

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 &#...