Finance : With UPI Apps becoming mainstream nowadays, cash is garnering the status of a rare and exclusive commodity. Right from a small car...
CA, CS, CMA : Learn how to draft an accurate Balance Sheet in Excel within 2 minutes using formulas like VLOOKUP, HLOOKUP, and XLOOKUP for error...
Finance : Learn how to automate filling blank cells in Excel using VBA. Save time and reduce errors with our step-by-step guide for efficien...
Finance : Convert Excel data to PDF effortlessly for a polished look. Enhance presentation, maintain formatting, and ensure compatibility wi...
CA, CS, CMA : Discover essential Google Sheets keyboard shortcuts to boost productivity. Learn time-saving tips and tricks for efficient spreads...
Goods and Services Tax : Join Certification Course on GST Compliances, Excel For professionals, Income Tax and Customs, Import & Export by TaxGuru Edu at ...
Finance : Test anxiety can affect not just the result of your certification exam but also your wellbeing. It may lead to exam failure, or wo...
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 with complex data.
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 not clearly visible in excel.
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: =DATEDIF(A1,TODAY(),”m”)/12 . The result: 23.25 Years
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 effort.
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 — you […]
