Problem Solver
Sahil Soni
Areas Sahil Soni is Knowledgeable in:
Having good command in Accounting Software, Direct Taxes, Indirect Taxes, Microsoft Office, Medium expertise in Tally.ERP9 & MS-Excel and MS-Excel Data Extractor for MIS Reporting
Techniques Sahil Soni Uses:
Common Sense which is uncommon among all.
Sahil Soni's Problem Solving Skills:
- Service Tax
- Excise
- CST
- VAT
- Income Tax
- Transfer Pricing
- Auditing
- Accounting
- Medium Expertise in MS-Excel
- Microsoft Office
- Microsoft Excel - Data Extractor
- Direct Tax
- Indirect Tax
- MIS Reporting
- Accounting Software
- Tally
- Tally.ERP9
Sahil Soni's Problem Solving Experience:
- Most of the time, i used to develop formulas in Microsoft Excel to get ease use of extracting the data from raw data to make it useful for reporting purpose.
1. For Converting the Date into Financial Year: =IF(MONTH(A4)>3,YEAR(A4)&"-"&YEAR(A4)+1,YEAR(A4)-1&"-"&YEAR(A4))
2. For classifying the date as Quarters : =IF(MONTH(A4)<=3,"Q4_Jan-Mar",IF(MONTH(A4)<=6,"Q1_Apr-Jun",IF(MONTH(A4)<=9,"Q2_Jul-Sep","Q3_Oct-Dec")))