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...
Getting a root of a number is the same as raising that number to the power of 1/root. Example: The square root of x is x^(1/2). The square root of A1 is: =A1^(1/2). You can also use the built-in worksheet function SQRT: =SQRT(A1)
To calculate the difference in days, use the DATEDIF function as shown in the following formula: =DATEDIF(A2,B2,”d”) To calculate the difference in weeks, use the INT function as shown in the following formula: =INT((B2-A2)/7) To calculate the difference in months, use the DATEDIF function as shown in the following formula: =DATEDIF(A2,B2,”m”)
The VLookup formula returns data from any column you choose in the data table, simply change the number of the column in the third argument. Although it sounds simple, there is a catch. How can you determine the number of a column in a data table that contains numerous columns? How can you easily change the number of the column in the third argument of the VLookup formula? How can you easily change the column number in multiple formulas in a worksheet from which complex reports are prepared or in a sheet that contains multiple VLookup formulas?
To round a number to thousands with the hundreds shown as a decimal: 1. Press Ctrl+1 to open the Format Cells dialog box. 2. Select the Number tab, and from Category, select Custom. 3. In the Type box, enter the following Custom Formatting syntax: #,##0.0, ;[Red](#,##0.0,);- ;
Excel’s VLOOKUP function, which stands for vertical lookup, is used to find specific information that has been stored in a spreadsheet table. This tutorial includes step by step instructions of how to use Excel’s VLOOKUP function.
Find duplicates items in combine columns in Microsoft Excel – Enter the formula : =A1&B1 to cell C1 and copy / paste the formula to cells C2:C12 – Enter the formula : =IF(COUNTIF($C$1:C1,C1)>1,”Duplicate”,”Unique”) – to cell E1 and copy / paste the formula to cells E2:E12
Data in cell A1:B2 A B 1 End Date/Time 05/11/2003 15:33 <– =NOW() 2 Start Date/Time 10/01/2002 9:33 <– =NOW()-222.25 Formula in cell E2: =(B1-B2)*1440 ( 24 hours*60 minutes=1440 ) Format in cell E2: regular number format Result: 320,040 minutes Screenshot // Calculate number of minutes between dates – time in Microsoft […]
Formulas that calculate loan payments, principal, interest and more are found in the financial category in the Paste Function dialog box. In the screen shot is a list of functions and necessary syntax for loan calculations. See the formulas in the gray cells, and the syntax in rows 12-16.
This formula evaluates to 200. This ‘200’ is the value of Cell B3. To copy and paste this Value i.e. 200, to the adjoining cell C3, go to cell B3, hit [CTRL + C], or right your mouse and select
Display or Hide the ribbon? – Press CTRL+ F1.. Go to the last used cell in a sheet? Press CTRL + End. Select cells from any cell to the last cell in the sheet’s used range?