Tithi Ghosh
Course: Certified Industrial Accountant (CIA)
Certificate in Tally, Power BI, Advance Excel
The Certificate in Tally, Power BI & Advanced Excel is a comprehensive, job-oriented program designed to equip students with essential accounting, data analysis, and reporting skills required in today’s business environment. This course combines practical training in Tally accounting software, Advanced Excel, and Microsoft Power BI, enabling learners to manage financial data, perform analysis, and create insightful business reports and dashboards.
The program emphasizes hands-on learning, real-time projects, and industry-relevant case studies, making it ideal for students, working professionals, and entrepreneurs aiming to build or upgrade their skills in accounting and business intelligence.
How This Course Can Help Students?
- Build a Career in Accounting & Data Analytics- This course prepares learners for roles such as Accountant, Accounts Executive, MIS Executive, Financial Analyst, and Business Reporting Analyst across multiple industries.
- Master Accounting & Financial Management-Gain practical expertise in maintaining accounts, preparing financial statements, and managing compliance using Tally.
- Develop Advanced Data & Reporting Skills- Learn Advanced Excel and Power BI to analyze financial data, automate reports, and create dynamic dashboards for better decision-making.
- Support Business & Self-Employment- Entrepreneurs and business owners can use these tools to manage accounts, track performance, and generate accurate financial and operational reports.
Overall, the Certificate in Tally, Power BI & Advanced Excel empowers learners with industry-relevant skills that bridge accounting and data analytics, making them job-ready and future-focused.
Why Should You Learn Tally, Power BI & Advanced Excel Online?
Industry-Focused Professional Training-
Learn from experts with real-world experience in accounting, finance, and data analytics.
Enhance Your Resume with In-Demand Skills-
Proficiency in Tally, Power BI, and Advanced Excel significantly increases employability in accounting and analytics roles.
90% Practical & 10% Theory-
Our curriculum emphasizes practical learning through hands-on exercises, real business datasets, and live projects.
Learn from Anywhere, Anytime-
Flexible online learning allows you to study at your convenience from the comfort of your home.
Career Guidance & Placement Support
Receive expert counseling and access to job opportunities to help you choose and grow in the right career path.
1000+ Vacancies Weekly
Get exposure to regular job openings and connect with recruiters actively seeking skilled professionals.
How Will Your Tally, Power BI & Advanced Excel Training Work?
Get Hands-on Practical Experience-
Work on live projects designed by industry experts and academicians using real accounting and business data.
Live Videos, Case Studies & Self-Paced Learning-
Learn through interactive live and recorded sessions supported by real-life case studies.
Test Your Knowledge-
Evaluate your learning through assignments, quizzes, and practice tests using the Learnersmall App to strengthen your concepts and practical skills.
Get Doubts Cleared Instantly-
Our trainers and academic support team are always available to help you with concept clarity.
Appear for the Final Examination-
Complete your training by appearing for the final assessment that validates your skills.
Earn an Industry-Recognized Certification-
Receive a Certificate in Tally, Power BI & Advanced Excel from ICA Edu Skills, showcasing your expertise in accounting and data analytics.
Eligibility Criteria
-
Pre-Requisites for Joining this Course:
- Education:
- Completed Higher Secondary (Class 12)
- Pursuing Graduation to Complete or Completed
- Devices: Access to desktop or laptop with stable internet connection (as classes are practically oriented)
- CET: Must clear common entry test conducted by ICA
For more details - please connect with Career Coach at ICA Online
- Education:
- Tally
- Power BI
- Advance Excel
- AI in Accounting
- TallyPrime 51 Hours
- 1. Company creation
- 2. Cost Centre & Cost Category
- 3. Accounting
- 4. Inventory
- 5. Bill of Materials (BOM)
- 6. Basic concepts of GST
- 7. GST using Tally
- 8. Generation of Returns
- 9. TDS
- 10. PF
- 11. Backup and Restore
- 12. ESI
- 13. Payroll
- 14. Security Control
- 15. Reports
- 16. TallyPrime Intro
- 17. Download & Install
- 18. Process Flow
- 19. GoTo/SwitchTo
- 20. Charts of Accounts
- 21. Group & Subgroup
- 22. Ledgers (Creation, Alteration and Deletion)
- 23. Backup & Restore
- 24. Bill Allocation
- 25. Voucher Entry
- 26. BRS
- 27. Asset Purchase
- 28. Sale of Assets with Depreciation
- 29. Stock Group
- 30. Category
- 31. Godown
- 32. Stock Item
- 33. Stock Transfer
- 34. Purchase (Order , Receipt Note, Rejection Out, Invoice , Debit Note)
- 35. UOM
- 36. Purchase & Sale Cycle
- 37. Sales ( order , Delivery Note, Rejection In , Invoice , Credit Note )
- 38. Batch
- 39. Zero Values Entries
- 40. Actual Billed Quantity
- 41. Standard Price
- 42. Credit Limit
- 43. Appropriation of Expenses with Inventory
- 44. Reorder Level
- 45. Voucher Class
- 46. Interest Calculation
- 47. Non- Accounting Vouchers
- 48. Scenario Management
- 49. Budgeting & Control
- 50. Post Dated Cheque Management
- 51. Account Confirmation
- 52. Export & Import Data
- 53. Export B/s Reports in Excel and Other Formats
- 54. Security Control
- 55. Tally Audit
- 56. Split Company
- 57. Merge Company
- 58. Activating GST
- 59. Master Creation
- 60. Inward Supply of Goods – Local
- 61. Outward Supply of Goods - Local
- 62. Invoice Printing
- 63. Inward Supply of Goods – Interstate
- 64. Outward Supply of Goods – Interstate
- 65. Debit & Credit Notes
- 66. Different Rate - One Invoice
- 67. Input Tax Credit
- 68. Payment of Tax
- 69. Generate Return
- 70. Reconcile Status
- 71. Purchase Capital Goods
- 72. Goods & Services in same invoice
- 73. Discount on Sales Invoice
- 74. RCM
- 75. GST Reports
- 76. Deducting TDS on Expenses
- 77. TDS Payment & Challan
- 78. Challan Reconciliation
- 79. Form 26Q
- 80. Exporting Form 26Q
- 81. Rent (TDS & GST)
- 82. TDS Payment with Interest
- 83. No Deduction (15G & 15H)
- 84. Deduction at Lower Rate (Form 13)
- 85. Project on TallyPrime
- Advanced MS Excel 18 Hours
- 1. Advance Number Formatting
- 2. Advanced Conditional Formatting
- 3. Match & Index
- 4. Financial Functions
- 5. Power Query
- 6. Macro
- 7. Project
- 8. Array Formulas
- 9. PowerPivot & Power Map
- 10. Dashboard
- 11. G-suite
- Power BI 14 Hours
- 1. Introduction
- 2. Prepare Data in Power BI
- 3. Publish Power BI
- 4. Service Power BI
- 5. Desktop Tooltip Reports & Slicers in Power BI
- 6. Buttons & Bookmarks in Power BI
- AI in Accounting (Recorded Classes Only) 15 hours
- 1. Introduction to Artificial Intelligence (AI)
- 2. Artificial Intelligence (AI) in Taxation
- 3. Artificial Intelligence (AI) for Excel Integration
- 4. Artificial Intelligence (AI) in Tally ERP
- 5. Artificial Intelligence (AI) in Accounts and Finance
Get The Best E-learning Experience with ICA!
Our Testimonials
What’s Our Students Says
About Us
We take pride in the success of our students. Hear directly from them as they share their experiences, growth, and how our programs have helped shape their journey.
Mitu Dey
Course: Certified Industrial Accountant (CIA)
This CIA course from ICA is practical and career-focused. It's the right step for anyone aiming for success in accounts and finance. It provides excellent hands-on training for real-world job readiness.
Soumik Roy
Course: Certified Industrial Accountant (CIA)
ICA’s CIA Online course is a game-changer. I recommend it to everyone serious about learning accounting practically and securing a future-proof career.
Monali Mahanty
Course: MIS Analytics
ICA offers the best practical training in MIS & finance. I highly recommend it to anyone aiming for a strong, skill-based, and rewarding career path.
Hemlata
Course: MIS Analytics
I strongly recommend ICA for its live, practical MIS and finance courses. It equips you with real job skills and sets the foundation for a brighter, more successful career.
Still Thinking? Seats Are Filling Fast!
You’ve seen the opportunity, now grab it! Get job-ready skills with ICA’s expert-led, practical training — anytime, anywhere..
The CIA course is excellent. Its hands-on approach with seven simulation software and 100% job assurance is a smart choice for anyone seeking a successful career in accounting..