1 / 12

ppt.1

PowerPoint presentation

Vidhi22
Download Presentation

ppt.1

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. OFFICE TOOLS • MS-Word • MS-Excel • MS-PowerPoint • MS-Outlook

  2. ADVANCED EXCEL • Excel Essentials • Working with Multiple Worksheet • Cell Referencing • Working with Data Lists • Conditional Formatting • Data Validation • What-If Analysis • Formula Auditing • Protection • G Suite-Excel

  3. FORMULAS AND FUNCTIONS • Conditional Function • Text Function • Statistical Function • Financial Function • Creating HLOOLUP and VLOOKUP Functions • Advanced Conditional Formatting • Advanced Lookup and Reference Functions • Advanced Functions in Excel

  4. DASHBOARD DESIGNING • Creating Dashboard • Graphical Representation of data using charts and sparklines • Use of Power Pivots for Data Analysis • Use of Power Queries • Power map • Pivot table Dashboard with SLICERS

  5. AUTOMATION\ • Working with External Data • Exporting Data to Excel ,Access ,PPT ,TXT ,CSV • Updating Charts ,Table in PowerPoint • Importing data from Excel , Access ,PPT , TXT , CSV • Converting Reports into PDF • Exporting Charts , TABLES TO PowerPoint

  6. MANNYAL ACCOUNTING • Basic of Accounting • Accounting Concepts • Journal entries • Concept of Accounting Standards • Bank Reconciliation Statement • Capital and revenue Expenditure • Depreciation • Provisions and reserves • Final accounts • Account documents

  7. Advanced accounting • Cash flow statement • Debtors and creditors reconciliation stat • Accounting for digital transactions • Final accounts • Profit screening

  8. Direct tax • Income tax • Computation for salary • Computation for house property • Computation for Business n professions • Computation for other sources • Other exemptions • Clubbing of income • Interest calculation

  9. TDS • TDS fundamentals • Important forms ,due dates ,penalties • TAN N PAN NO • TDS Computation • Complete TDS Non salary sec 194 • TDS N TCS Book in system • Form 15G ,15H , Form 26AS

  10. INDIRECT TAX-GST • GST Concept n Overview • Time n place of supply • Value of supply • Reverse charge mechanism • Normal vs composition scheme • Input tax credit • Registration • Return filing • E-way bill

  11. Tally prime • Download tally prime set up file • Tally prime installation , company creation ,alteration ,deletion • Tally prime ledgers creation • Tally prime inventory creation

More Related