Its All About Knowledge
When producing working papers or financial statements it difficult to put long statements in Excel as Excel doesn’t give the option to word wrap or justification or other features that are available in Ms-Word , different solutions such as Excel’s Justify command, and pasting from Word is available but all these are not enough.
Lot of data base work done by accountant is done by using Excel , in last decade Excel in one of the most powerful tools used by accountant it helps them analyzing the huge data with single clicks or few basic formulas. Today I am going to tell you how to remove duplicates while analyzing,
Here is a summary in a tabulated form. Check this out. Copy on to a excel sheet for better readability. Good luck. Key Alone Shift Ctrl Alt Shift Ctrl F1 Help What’s This Help Insert Chart Sheet F2 Edit Mode Edit Comment Save As F3 Paste Name Formula Paste Function Define Name Names From Labels …
There are different method of adding zero in front of number in excel but all methods has different uses below here I am defining uses of different methods a) Whether you use the TEXT formula or the format cell option – the functionality is exactly the same. The second part of the text formula is …
While we are doing the calculations it sometime requirement to convert amount written in numeric can be converted to word in excel, as we all know there is no such formula exist to solve this problem , but it can be solved with micro very easily by following simple steps
In Excel Vlookup function is used to search the value in array and then bring back the value form indexed column Vlookup consist of four parts and each part is separated by comma
Some time it is required to add Zero’s before any number to make it of constant length e.g. How it can be done in excel
I have added all the Excel shortcuts on this site hope fully it will increase the speed of your work and reduce liability of mouse during the work
