TDS OVERVIEW, SECTION COVERS UNDER THIS COURSE (SEC 192: TDS ON SALARY, SEC 194DA –PAYMENT – LIC POLICY, SEC 194E – NRI SPORTS, SEC 194H – TDS ON COMMISSION/BROKERAGE, SEC 194I – TDS ON RENT, SEC 194IB – RENT, SEC 194IA – RENT, SEC 194C – TDS ON CONTRACT,SEC 194J – TDS ON PROFESSIONAL OR TECHNICAL, DIRECTOR, ROYALITY, SEC 194M – PAYMENT BY INDIVIDUAL NOT COVERED UNDER SECTION 44AB, SEC 194B, SEC 194BB, TAN APPLICATION(PRACTICALLY COVER, FORM 49B) ONLINE, PAN APPLICATION (PRACTICALLY COVER, FORM 49A)ONLINE, ALL TRANSACTION/CASES OF TDS ENTRIES ON TALLY ERP 9, DEPOSIT TDS CHALLAN281,FORM (LIVE), TDS RETURN26Q PRACTICALLY: TDS RETURN FOR NON-SALARY ONLY, FORM 16A PRACTICALLY COVERED THROUGH TDSCPC WEBSITE), TDS CERTIFICATE FOR NON-SALARY ONLY, 26AS FORM VIEW TDS CREDIT, FORM 15G/15H, FORM 13 UNDERSTANDING, INTEREST & PENALTY CALCULATION, FAQ (QUESTION & ANSWER AS PER PRACTICAL EXPOSURE).
Terminology OF INCOME TAX, INCOME TAX COMPUTATION, INCOME TAX CHALLAN, DEDUCTION UNDER INCOME TAX, CALCULATION / COMPUTATION OF INCOME UNDER SALARY, CALCULATION /COMPUTATION OF INCOME UNDER HOUSE PROPERTY, CALCULATION / COMPUTATION OF INCOME UNDER PGBP, CALCULATION / COMPUTATION OF INCOME UNDER OTHER SOURCE, FILING OF INCOMETAX RETURN (ITR- 1 & ITR- 4 ONLY), FAQ.
Introduction to GST Structure, SUPPLY: MEANING & SCOPE , Time of Supply, Place of Supply, VALUATION, JOB WORK, COMPOSITION SCHEME, E–WAY BILL, RCM – REVERSE CHARGE MECHANISM,E– COMMERCE, EXEMPTION FROM GST, IMPORT/EXPORT UNDER GST, INPUT TAX CREDIT RULES (ITC), GST REGISTRATION (PRACTICALLY), TAX INVOICE, DEBIT, CREDIT NOTE, GST COMPUTATION, TALLY ERP 9 MAPING/ENTRIES, GST REFUND PROCESS, GST CHALLAN/PAYMENT(ONLINE), GST RETURNS PRACTICALLY (OFFLINE & ONLINE BOTH WAY)(GSTR-1, GSTR 2A, GSTR-3B, GSTR-4, CMP 08, GSTR 9, ANNUAL RETURN) ETC, FAQ (QUESTION & ANSWER AS PER PRACTICAL EXPOSURE). PRACTICE DATA WILL ALSO PROVIDE
Basic Understanding Menu and Toolbar, Introduction to different category of functions like Basics, Mathematical and Statistical, Date and Time, Logical, Lookup and References, Text and Information.
Sum, Sumif, Sumifs, Count, Counta, Countblank, Countif, Countifs, Average, Averagea, Averageif, Averageifs, Subtotal, Aggregate, Rand, Randbetween, Roundup, Rounddown, Round, Sumproduct
Date, Day, Month, Year, Edate, Eomonth, Networkdays, Workday, Weeknum, Weekday, Hour, Minute, Second, Now, Today, Time
Char, Clean, Code, Concatenate, Find, Search, Substitute, Replace, Len, Right, Left, Mid, Lower, Upper, Proper, Text,Trim, Value, Large, Small Filters (Basic, Advanced, Conditional), Sort (Ascending, Descending, Cell/ Font Color),Conditional Formatting, Data Validation, Group & Ungroup, Data split.
Isna, Isblank, Iserr, Iseven, Isodd, Islogical, Isytext, Max, Min, Len, Right, Left, Mid, ,Maxa, Maxifs, Median, Minifs, Mina, Vara, Correl, Geomen
And, Or, If, Iferror, Not, Nested If
VLookup, HLookup, XLookup, Index, Match, Offset, Indirect, Address, Column, Columns, Row, Rows, Choose, Arrays Concept In Lookup Formula’s, Past Special, Past link
And, Or, If, Iferror, Not, Nested If
Pivot Table, Power Pivot, What-if Analysis, Data Table –One Variable and Two Variables, Data Analysis Using Statistics, Descriptive Statistics, ANOVA, Moving Average, Testing Hypothesis, Measuring Covariance and Correlation, Distribution, Regression, Graphs & Charts, Analysis Tool Pack, Solver, Histogram, Pareto, Water Fall, Import and Export data, Protect/Unprotect sheets/workbooks, Worksheet formatting and Print Display
With Data Quality, Collaboration & Security Like Share Your Workbook On Share Drive With Quality
Like Three Dimensional (3D) Tables, Sensitive Analysis Like Data Table, Manual What-If Analysis, Threshold Values, Goal Seek, One-Variable Data Table, Two-Variable Data Table
Overview of Chart types, Chart Formatting, Active X Form Controls, Principle of great dashboard design, Selecting Correct Chart to display data, Interactive Charts with Form Controls, Combo box, Check Box, Scroll Bar and Radio Button, Interactive Dashboard with Form Controls, Form Controls for reports automation, Data Models using Power Pivot.