Simplifying Taxation in India
To Apply the New PAN Cardgo to https://tin.tin.nsdl.com/pan/ (Official Website) Two Passport size photographsProof of Identity (POI) click here for list of acceptable POIProof of Address (POA) click here for list of acceptable POAProof of Date Of Birth (POD) click here for list of acceptable PODNote:Proof of Identity (POI) and Proof of Address (POA) should … Read more
Very Useful All Excel Tricks Don’t miss What Is In The Dictionary ? This workbook contains 157 worksheets, each explaining the purpose and usage of particular Excel functions. There are also a number of sample worksheets which are simple models of common applications, such as Timesheet and Date Calculations. Formatting Each worksheet uses the same … Read more
Excel complete all formulas with examples (VERY USEFUL DONT MISS)ATOZ ALL FUNCTIONS / FORMULAS:SPLIT FORE NAME AND SUR NAMEPRECENTAGESHOW ALL FORMULASUM USING NAMESINSTANT CHATSBRACKET IN FORMULAAGE CALCULATIONAUTOSUM SHORTCUT KEYABSADDRESSANDAVERAGECEILINGCELLCHOOSECLEANCOMBINCONCATENATECONVERTCORRELCOUNTCOUNTACOUNTBLANKCOUNTIFDATEDATEDIFDATEVALUEDAYDAY360DELTAEASTEDATEEMONTHERROR.TYPEEVENEXACTFACTFINDFIXEDFLOORHLOOKUPHOURIFINDEXINDIRECTINFOINTISBLANKISERRISERRORISEVENISLOGICALISNAISNONTEXTISNUMBERISODDISREFISTEXT LARGELEFTLENLOOKUP (ARRY)LOOKUP (VECTOR)LOWERMATCHMAXMEDIANMIDMINMODMODEMONTHMROUNDNNANETWORKDAYSNORTHNOTNOWODDORPROPERQUARTILEQUOTIENTRANDRANKREPLACERIGHTROMANROUNDROUNDDOWNROUNDUPSECONDSIGNSMALLSOUTHSTDEVSTDEVPSUBSTITUTESUMSUM AS RUNNING TOTALSUMIFSUMPRODUCTITEXTTIMETIMEVALUETODAYTRANSPOSETRIMTRUNCUPPERVALUEVLOOKUPWEEKDAYWORKDAYYEAR SIMPLIFIED COLLECTION FROM SIMPLETAXINDIA.IN CLICK HERE TO DOWNLOAD ALL EXCEL FUNCTION IN EXCEL FILE
A Pivot Table Report is useful to summarize, analyse, explore, and present summary data. Itenables you to make informed decisions about critical data in your enterprise.Tip: You can find the PivotTable command on the Ribbon (Insert tab, Table group). What is a Pivot Table?A Pivot Table Report is an interactive way to quickly summarize large … Read more
Create a Chart:To create a chart, you must first enter the data for the chart on an Excel worksheet. Select that data, and then use the Chart Wizard to step through the process of selecting a chart type and the various chart options for your chart. To do this, follow these steps:Start Excel, and then … Read more