Finance : Learn Excel basic formulas, shortcut keys, and important functions. Get guides for bank reconciliation, loan EMI calculation, pivo...
CA, CS, CMA : Enhance client management for professionals like Chartered Accountants, Company Secretaries, and Cost Accountants using Excel-base...
Finance : Benford's law describes the relative frequency distribution for leading digits of numbers in datasets. In this article we are disc...
Finance : Microsoft Excel is extensively used across the globe to store and analyze. Despite various new data analytics tools in the market,...
Finance : Following the previous post, we are here with some unknown yet useful features of Pivot that can enhance our work quality on a day...
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...
Microsoft Excel is undoubtedly most user friendly tool and being extensively used all over the world. We might be using it daily or maybe casually, but probably always wished that we knew more about this dynamic program. Most of us don’t use even 5% of its capabilities. While most of us know use of VLOOKUP, […]
Working as a Chartered Accountant or an Article in any company or firm, it is always expected from us that we are perfect in numbers as far as financial numbers are concerned. The one tool which is very common and useful in every industry and in every country, is MS-Excel. So, in this article we […]
Test anxiety can affect not just the result of your certification exam but also your wellbeing. It may lead to exam failure, or worst, mental breakdown! And if you don’t want to pull a stressful all-nighter, there’s no better way than to have a game plan. For those who plan to take Microsoft exam 70-741, […]
Another week has passed by and it’s time to get the hang of another feature in Excel. ‘It takes time to save time’ and When we invest time to learn Excel, we are actually saving our time. ♦ Background: You need to borrow some money – – You know how much you want (the amount […]
Excel’s ‘Consolidate’ feature helps in consolidating data in worksheets (located in one workbook or multiple workbooks) into one worksheet. Even though this is predominantly used at the managerial level (say, for aggregating various financial figures from multiple branches), it can come handy to the Chartered Accountants as well.
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.