IT Tools with Advance Excel + Tally Prime (6 months)
Course : Short Term Courses
I.T. Tools: 2 Months
Introduction: Introduction of Computer, Types of Computer, Operating Software, Trouble Shooting, Internet.
MS Word: Formatting Text, Editing Images, Shapes & Charts, Hyperlink, Cross Reference, WordArt, Page Setup, Watermark, Mail Merge, Compare, Protection.
MS PowerPoint: Slide Preparation, Insert, Smart-Art, Charts, Design, Transitions, Animations, Slide Show, Review.
MS Excel: Preparing Salary Sheet, Mark Sheet using Sum, Average, Maximum, Minimum, Count, Counta, Logical Functions, Financial Functions, Date & Time Functions, Math & Trig. Functions, Text Functions etc.
Advance Excel: 1 Month
Lookup & References: HLOOKUP, VLOOKUP, VLOOKUP with LARGE MAX, VLOOKUP with SUBTOTAL, Multiple VLOOKUP, Approximate VLOOKUP, VLOOKUP with MATCH, INDEX with MATCH Function etc., Absolute/Fixed, Relative & Mixed References.
Others: Advance Filter, Pivot Table & Charts, Hyperlink, Data Validation, Scenario Manager, Goal Seek, What-if-Analysis, COUNTIFS, SUMIFS, SUMPRODUCT, Loan Sheet, Attendance Sheet, Calendar, Advance Conditional Formatting, More than 100 Shortcut keys
Advantage: To achieve excellence in office work using MS Office. An e-Accountant gets lot of work in MS Excel, hence expertise in Advance Excel is essential to succeed as an e-Accountant.
Tally Prime: 3 Months
Part-I: Installation, Company Creation, Configuration & Features, Groups, Ledgers, Stock Items, Godown, Voucher Entries, Manufacturing Process (BOM), Job Costing, Interest Calculation, Multi Currency, Forex Gains/Loss, Cost Centre & Class, Budget, Price List & Level, POS, Backup, Restore, Export & Import of Data, Splitting Company, Control Centre & Support Centre
Part-II: Transactions having GST [CGST, SGST & IGST] and TDS/TCS.
Part-III: Reports, Balance Sheet, Profit & Loss A/c, Ratio Analysis, Trial Balance, Day Book, Cash Book, Purchase & Sales Register, Inventory Books, Cash Flow & Fund Flow Statement.
Part-IV: Payroll: Employees & Pay Heads Creation, Income Tax, EPF & ESI Compliance, Payroll Vouchers, Increment & Arrears, Pay Slips & Statutory Reports.
Advantage: Tally is the most popular accounting software in the world. In India, Accounting is done using Tally in most of the Government Departments and Corporate world. Expertise in Tally is the guarantee of success.