Excel Tips

A Very Useful Online Tool for Budgeting and Tax Returns

Income 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

Income 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

Income 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

Income 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

Spell Check in Excel –How to Use it?

Income Tax - 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
Sorry No Post Found
Sorry No Post Found
Sorry No Post Found

Recent Posts in "Excel Tips"

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
Posted Under: Finance |

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
Posted Under: Finance | ,

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
Posted Under: Finance | ,

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
Posted Under: Finance |

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
Posted Under: Finance |

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
Posted Under: Finance |

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
Posted Under: Finance |

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
Posted Under: Finance |

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
Posted Under: Finance |

How to subtract date from date without using excel or any other programming

Common sense way of subtracting 2 dates. At many places students are required to compute number of days, months and years between 2 dates. For example in computing exemption of gratuity duration of service is required. I have seen student calculating duration of service in fingers....

Read More
Posted Under: Finance |
Page 1 of 41234

Browse All Categories

CA, CS, CMA (3,522)
Company Law (3,466)
Custom Duty (6,671)
DGFT (3,499)
Excise Duty (4,051)
Fema / RBI (3,292)
Finance (3,496)
Income Tax (25,325)
SEBI (2,758)
Service Tax (3,288)

Search Posts by Date

November 2017
M T W T F S S
« Oct    
 12345
6789101112
13141516171819
20212223242526
27282930