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...
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 […]
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.
We many times receives excel files from various sources. Sheets of which are password protected by the author of the file. Sometimes we need to change the content of the file to suit our requirements but we will not be able to make the changes if the excel sheet is password protected. This document will […]
As we are all aware excel is widely used for accounting and financial purposes.In the past they were used only to perform basic moths, such as adding, multiplying, subtracting and dividing. Today’s spreadsheets can be significantly different and far more advanced. A CA office cannot work without excel. But do we CA’s utilize excel to its optimal? Sadly no! Most of us never realize the full potential of using Excel. EXCEL has numerous features which can reduce your time & your client’s time in day to day analysis and reporting.
Using keyboard shortcuts To move to the last (or first) cell in a range: • Vertically from top to bottom, press Ctrl+Down Arrow. • Vertically from bottom to top, press Ctrl+Up Arrow. • Horizontally from left to right, press Ctrl+Right Arrow. • Horizontally from right to left, press Ctrl+Left Arrow.
To format cells containing Formulas using the Conditional Formatting dialog box, add a VBA Function: Step 1: Add the following VBA Function to a regular Module: Function IsFormulaInCell (Cell) As Boolean IsFormulaInCell= Cell.HasFormula