Enquiry Now

WELCOME TO ICAT

Home > Courses > Cat Pro

CAT PRO

4.7/5
4.7 Rating
  • Windows
  • File & Folder Management

Ms Office 2021

  1. Microsoft Word
  2. Microsoft Excel
  3. Excel MIS Beginner to Advance
  • Windows
  • File & Folder Management

Ms Office 2021

  1. Microsoft Word
  2. Microsoft Excel
  3. Excel MIS Beginner to Advance
  1. Microsoft Word
  2. Introduction to Microsoft Word
  3. Use Clipboard Group Of Home Tab
  4. Text Formatting In Microsoft Word
  5. Line and Paragraph Spacing
  6. Sort Paragraph, Bullet and Number Lists
  7. Page Setup And printing
  8. How to Create Custom Cover pages
  9. Hyperlink, Bookmark and Cross Reference
  10. Creating And Formatting Tables 
  11. Insert Pictures in Word
  12. Insert Clip Art & Online Image
  13. Using Word Text Boxes
  14. Create or Run a Macro
  15.  Create Or Run a Macro
  16. Create Filllable Form
  17. Use Autocorrect in Word
  18. How to Insert Watermaks
  19. Set default Hindi Font And Font Size
  20. Check Spelling and Grammar
  21. Perfect Text Alignment using Tabs
  22. Add Footnote And Endnote
  23. Insert Caption In Word
  24. Insert Table of Contents
  25. Create a Bibliography,  Citation, and Referencess son
  26. Microsoft Word Best Keyboard Shortcuts
  27. Letter Format Example and writing Tips
  28. How to create a Resume in word
  29. Using Mail Merge In Ms Word
  30. Create Certificate In Ms Word
  31. How To Make Visiting Card
  1. Microsoft Excel Introduction
  2. How to Work in Excel and Use Basic Formulas
  3. Use Clipboard Like pro Full Explain
  4. Organize Row Column And Worksheet
  5. Date Entry Like Pro
  6. Create Your Own Custom List
  7. How Make password Your Excel File
  8. How To Use Sum Sum Formula
  9. How to Use Skip Blanks
  10. Subtract, Multiple, Divide And Percentage
  11. Use Conditional Formatting 
  12. How to sort & Filter Data
  13. Using Find and Replace And Using Go to
  14. How to use Status Bar
  15. Freeze Panes Option
  16. Split Window 
  17. Fill Option 
  18. Flesh Fill
  19. Pivot Table
  20. All Table Option
  21. Pictures Option
  22. Use shape
  23. Use 3D Modal
  24. Smart Art
  25. Advanced Charts & Graph
  26. People Graph 
  27. Create Hyperlinks
  28. Header And Footer
  29. Write, Insert or Change an Equation
  30. Using the Draw Tab
  31. How to Use Themes
  32. Complete Page Setup
  33. Scale to Fit Setup
  34. If Formula
  35.  If Formula With Multiple Conditions
  36. Change Case And Round Figure Formula
  37. Vlookup Formula
  38. Vlookup Formula Examples
  39. Hlookup Formula 
  40. And Formula
  41. Convert Number Into word formula
  42. Use Macros With Example
  43. Subtotal Formula
  44. Link Date in Excel Spreadsheets Formula
  45. Date Consolidate Formula
  46. Calculate  Age With Date, Date if Formula
  47. E- Date and Eo- Month Formula
  48. Calculating Percent Formula
  49. Superscript and Subscript Formula
  50. Group Ungroup subtotal Formula
  51. Goal Seek Formula
  52. PMT Formula
  53. Goal With PMT Formula
  54. Concat Formula
  55. INDIRECT Formula
  56. Match Formula
  57. Count, Counta, Countblank Formula
  58. Exact Formula
  59. Sumif Formula
  60. Round, Roundup, RoundDown, MRound dormula
  61. Array Formula
  62. Left, Right, Mid, Len & Find Formula
  63. Split Name using Left, Right Mid, Len Formula
  64. Mod Formula 
  65. Quotient Formula
  66. Replace Formula
  67. Substitute Formula
  68. Excel Formula Error Type 
  69. SUMPRODUCT Formula
  70. Text Formula
  71. Double Vlookup Formula
  72. Simple Interest Formula
  73. Compound Interest Formula
  74. Celling And Floor Formula
  75. Index Formula
  76. INDEX + MATCH Formula
  77. Forecast Fomula
  78. Value Formula
  79. Most Important keyboard shortcut
  80. Employees Payroll and Salary Slip
  81. Daily Stock Register 
  82. Dynamic Unit Converter
  83. Dynamic Dropdown List
  84. School Marksheet with Grade
  85. Make Checkilist & To Do List
  86. Make Attendance Sheet 
  87. Student Database With mail Merge
  1. Pivot Table Introduction
  2. Pivot Table and Pivot Chart
  3. Design Tab of Pivot chart
  4. Slicer in Pivot Table & Slicer settings
  5. Time Line In Pivot Table 
  6. Get Pivot Date in Excel
  7. Pareto Chart in Excel
  8. INFORGRAPHIC chart in Excel
  9. Trend Chart using Sumifs Formula
  10. Map Chart using xy Scatter chart 
  11. Key performance Indicator in Excel
  12. Chart with Hyperlink
  13. Chart with Conditional Formatting 
  14. Create Bar Charts with Pictures Mis Series
  15. Speedometer chart In Excel
  16. See Saw Comparison Chart
  17. Mis – Hyperlink with Column and pie-  chart
  18. Mis- Male, Female Comparison Chart
  19. Excel MIS – Create Dynamic Month Dasboard using offset formula
  20. Excel Mis – reate Dashboard on Day Wise Report
  21. Excel MIS – sales Ranking Dashboard
  22. Excel Mis- Create Weekly sales Dasboard using Listbok
  23. Mis In Excel – Daily Task Reminder Dashboard
  24. Mis In Excel – Create Year Wise report using Vlookup, Match, Index
  25. Mis In Excel- Create Dasboard Using Vlookup,Match , Index, Conntif
  26. Mis – Amazing Dasboard
  27. Mis – Time Dashboard
  28. Mis- Gantt chart With Conditional Formatting
  1.  
  1. Power Query- Introduction and Installation
  2. Power Query- Create Connections with Excel Table
  3. Power Query – Create Connection With Text fill and Access Database
  4. Power Query – Reconnect Date in power Query
  5. Power Query – Create pivot tbale on Text file data
  6. Power Query- Merge Multiple Sheets using M Language
  7. Power Query – Create Pivot table on Multiple Sheets
  8. Power Query – Close and Load to Explain – Home Tab- Query group
  9. Power Query – Home Tab – Manage Column and Rows Group
  10. Power Query- Home Tab – Split Column into rows and columns 
  11. Power Query – Home Tab – Group by suing Basic and Advance Option
  12. Power Query – Home Tab Date type & Replace Values
  13. Power Query – Transform data Dynamically
  14. Power Query – Combine 1000+ Tables with 1 Function
  15. Power Query – Alternate Options of Vlookup inside Power query
  16. Power Query – Multiple Columns Lookup
  17. Power Query – Remove weekends and Holidays
  18. Power Query – Calculate Age with simple Method
  19. Power Query –  Calculate Task Timings
  20. Power Query – Add Column Date Options in Detail
  21. Power Query – Time and Duration Options in Detail
  22. Power Query – Transform Rew Date – Real Job Query 
  23. Power Query – Few clicks to get Trim, Propercase and Merge Data
  24. Power Query – Merge Workbooks and Create Pivot
  25. Power Query – Merge Workbooks with File Name as Column
  26. Power Query – Rew Data To Pivot
  27. Power Query – Merge Vs Append
  28.  
  1. Power Point intro
  2. Make New Slideshow in Power point
  3. Add Transition to Power Point
  4. Text Animation In power Point
  5. Caeate Custom Animation 
  6. Record Silde Show as a Video
  1. Ms Access Part 1
  2. MS Access Part 2
  3. MS Access Part 3
  4. MS Access Part 4

8. Microsoft Outlook

9. Microsoft Publisher

10. Google Sheets Full Course

  1. Introduction
  2. Accounting Concepts
  3. Capital & Revenue Transaction
  4. Accounts Documents 
  5. Journal Enteries
  6. Depreciation
  7. Stock Valuation
  8. Year – End Adjustmetns 
  9. Final Accounts
  10. Rectification of Errors
  11. BRS
  12. Projects on the preparation of Book.
  1. Introduction
  2. Accounting Concepts
  3. Capital & Revenue Transaction
  4. Accounts Documents 
  5. Journal Enteries
  6. Depreciation
  7. Stock Valuation
  8. Year – End Adjustmetns 
  9. Final Accounts
  10. Rectification of Errors
  11. BRS
  12. Projects on the preparation of Book.
    1. Account Reconciliatio
    2. Advanced Journal Entries
    3. Accounting for Digital Trransaction
    4. Company Final Accounts
    Analysis of Financial Statements.
  1. Introduction  to Banking
  2. Deposits
  3. Loan and Advances
  4. Payment mechanism
  5. Banking Instruments

Auditing

  1. Introduction to Auditing
  2. Conducting an Audit
  3. Audit Report & Audit Project
  1.  
  1. Introduction Income Tax
  2. Income From Salaries
  3. Income from House property
  4. Profits and Gains of Business or Profession 
  5. Income from capital Gains & Other Sources
  6. Deductions Under chapter VI –A
  7. Computation Of Taxable Income 
  8. Income Tax Return

Payroll 

  1. Joining Of Employees
  2. Salary Structuring
  3. Collection of Attendance Details and other Inputs
  4. Computation of Salary
  5. Deduction ( Statutory And Non – Statutory)
  6. Distribution of Salary
  7. Distribution of Pay Slip
  8. Submission of Statutory dues
  9. Generation of Various types of Reports
  10. Accounting of Paroll
  1.  
  1. Introduction to GST
  2. Overview of GST
  3. Supply under GST
  4. Charge of GST
  5. Composition Levy In GST
  6. RCM in GST
  7. RCM in GST Practical Aspect
  8. Exempt Supply in GST
  9. Time of Supply in GST
  10. Types of Supply in GST
  11. Place of Supply in GST
  12. Input Tax Credit in GST
  13. Registration In GST
  14. Tax Invoice, DN & CN in GST
  15. Refund in GST
  16. Interest on GST
  17. Assessment & Audit in GST
  18. Search and Seizure in GST
  19. Demand & Recovery in GST
  20. Appeal & Revision in GST
  21. Advance Ruling AAR in GST
  22. Returns In GST
  23.  

Who can register as MSME, MSME Turnover & Investment Calculation

  1. MSME Registration, NIC Code selection, Govt, Schemes for MSME’s etc.
  2. Udyam Registration and Print Certificate Process
  1. Company Creation
  2. Basic Accoutning
  3. Advanced Accounting
  4. Payroll
  5. Inventory
  6. GST
  7. TDS, TCS
  8. Banking
  9. Reports 
  10. Profit & Loss
  11. Balance Sheet
  12. Mis Reports
  1. Company Creation
  2. Basic Accoutning
  3. Advanced Accounting
  4. Payroll
  5. Inventory
  6. GST
  7. TDS, TCS
  8. Banking
  9. Mis Reports
  1. Introduction To ERP
  2. Introduction to SAP
  3. Introduction to SAP Modules
  4. Introduction to SAP FICO
  5. Enterprise Structure
  6. Financial Accounting Global Settings
  7. General Ledger 
  8. Accounts Payable
  9. Accounts Receivable
  10. Order to cash Process
  11. Financial statement Creation 
  12. Asset accounting Business Process
  13. Daily Posting and Period- end closing in management accounting 
  14. Accruals and Deferral
  15. Concept of consolidation with a chart of accounts
  16. Concept of multiple currencies
  17. Concept of trading partners
  18. Financial statement Versions 
  19. Opening and Closing period
  20. Fixed Assets 
  21. Inventory Valuation
  22. Hire to retire Process
  23. Finance organization Structure and master data
  24. Sap Controlling Organization
  1. Writing 
  2. Reading
  3. How to Spell Name
  4. Word
  5. Sentence 
  6. Functions Of Word
  7. Nouns
  8. Verbs
  9. Helping Verbs
  10. Adjectives
  11. Adverbs
  12. Prepositions of place
  13. Conjunction
  14. Interjection
  15. Articles
  16. Apostrophe
  1. Sentences and Their Types
  2. Imperative Sentences
  3. Declarative Sentences
  4. Interrogative Sentences
  5. Exclamatory Sentences
  6. Tenses
  7. Time Markers
  8. State Markers
  9. Present Tenses
  10. Past Tense
  11. Future Tense
  12. Conditional Sentences
  13. The Passive Voice
  14. Phrases
  15. Clauses
  16. Punctuation
  17. Capitalization

22. Spoken English

  1. Presentation Skills
  2. Interview Skills
  3. Sell Your Skills
  4. Cover letter, Resume
  5. People Skills
  6. E- mail etiquette 
  7. Goal Settting And Time Management
  1. Presentation Skills
  2. Interview Skills
  3. Sell Your Skills
  4. Cover letter, Resume
  5. People Skills
  6. E- mail etiquette 
  7. Goal Settting And Time Management

COURSE FEATURES

Duration
11 months
Discount
50%
Course Price
35000
ENROLL NOW
CONTACT US

OTHER COURSES

About US

ICAT is a leading institute in the field of computer accounting and taxation. We offer a wide range of courses to help students and professionals gain the skills and knowledge they need to succeed in today’s competitive job market.

Quick Links

Reach Us

Sco. 282/R, Basement Model Town Near – Maharana Pratap Chowk, opposite Yaduvanshi Hospital, Rewari, Haryana – 123401
+91-8930052320
icatrewari@gmail.com

Quick Contact

Stay updated with our latest courses and industry news. Sign up for our newsletter now.

Copyright © 2023 ICAT | All Rights Reserved

Facebook Twitter Youtube Instagram
Scroll to Top