Best Seller Icon Bestseller

Micro Course In Tally Prime and Excel- Advanced Excel(M-TPAEAE-3250)

  • Last updated Mar, 2026
  • Certified Course
₹6,000 ₹18,000
  • Duration90 Days
  • Enrolled2
  • Lectures90
  • Videos0
  • Notes0
  • CertificateYes

What you'll learn

Course Description

Tally Prime & Advanced Excel is a career-oriented course designed to build strong accounting and data management skills. This course combines practical accounting using Tally Prime with advanced Excel techniques used in businesses and offices.

Students will learn company accounts handling, GST billing, financial reports in Tally, along with advanced Excel skills like formulas, functions, data analysis, and reporting. This course is highly useful for students, job seekers, accountants, and business owners.

After completing the course, students will be able to manage accounts professionally and handle complex data efficiently using Excel.

Show More

Course Syllabus

Course Syllabus (Main Points)

Module 1: Basics of Accounting

• Introduction to Accounting

• Types of Accounts

• Golden Rules of Accounting

Module 2: Tally Prime

• Introduction to Tally

• Company Creation

• Ledger & Group Creation

• Voucher Entries (Sales, Purchase, Payment, Receipt)

Module 3: GST in Tally

• GST Basics

• GST Setup

• GST Billing

• GST Reports

Module 4: Reports in Tally

• Day Book

• Trial Balance

• Profit & Loss Account

• Balance Sheet

Module 5: Advanced Excel

• Advanced Formulas (IF, VLOOKUP, HLOOKUP, INDEX, MATCH)

• Data Sorting & Filtering

• Conditional Formatting

• Pivot Tables

• Charts & Dashboards

Module 6: Data Analysis & Reporting

• Data Validation

• MIS Reports

• Basic Financial Analysis

• Excel Shortcuts

Module 7: Practical Training

• Real-time Accounting Practice

• Excel Projects

• Business Case Studies

Course Fees

Course Fees
:
₹18000.00/-
Discounted Fees
:
₹ 6000.00/-
Course Duration
:
90 Days

Review

0.0
Course Rating (0 reviews)
0%
0%
0%
0%
0%


Programme

DITRP Self-Employment Courses Programme

DITRP Self-Employment Courses are created for individuals who want to develop practical, skill-based knowledge and generate independent earning opportunities through freelancing, home-based work, local services, professional services, or small business activities. These programs are designed to encourage self-reliance by helping learners build career-oriented skills beyond traditional employment options.

DITRP self-employment training programs offer exposure to a variety of practical and vocational sectors, including beauty and wellness services, tailoring, fashion designing, computer applications, typing, accounting fundamentals, digital marketing, online business promotion, vocational training, and local business support services.

These courses are beneficial for students, women learners, homemakers, rural and semi-urban youth, freelancers, job seekers, beginners, and small business owners who wish to gain practical expertise and explore skill-based earning opportunities through authorized training centres.


Programme

DITRP Job-Oriented Courses Programme

DITRP Job-Oriented Courses are developed to provide practical and career-focused training that helps learners enhance their employability, build confidence, and prepare for professional work environments. These programs emphasize skills that are widely required across offices, businesses, service organizations, educational institutions, digital workplaces, and local employment sectors.

DITRP job-oriented training programs offer practical learning opportunities in various fields, including computer applications, MS Office, Advanced Excel, accounting, Tally, GST, digital marketing, typing, communication skills, soft skills, interview preparation, vocational training, and self-employment-based learning.

These courses are suitable for students, graduates, job seekers, working professionals, women learners, and beginners who aim to strengthen their career prospects and develop industry-relevant skills. Institutions can also partner with DITRP as authorized training centres to provide job-oriented courses and skill development programs within their local regions.


Important: DITRP is an autonomous private skill development and certification organization. DITRP certifications are skill-oriented private certifications created to support career advancement, vocational education, self-employment opportunities, and professional development. As a private organization, DITRP provides Private certifications, and their recognition or eligibility may vary depending on the employer, institution, department, or intended purpose.

DITRP operates as an independent private skill development and certification body. Course structure, training methodology, and syllabus may also be customized according to the teaching approach of the institute or faculty members to ensure effective learning outcomes. The acceptance and applicability of DITRP certifications may differ according to the policies of various employers, institutions, or organizations.

Note: The Course Content & Syllabus provided is intended as a general guideline for the course. The curriculum has been designed considering institutional teaching methods, faculty expertise, learner demand, and industry requirements to ensure practical and effective training. The actual course duration, class schedule, training methodology, and mode of delivery may vary depending on the training institute or course provider. Course content may also be updated or modified from time to time according to learning requirements, industry standards, and regional needs.


Call
Text Message
Review
Email
CHAT