Tally ERP 9 + TallyPrime + GST + Microsoft Excel Training (Basic to Advanced)

You must enroll in this course to access course content.
You must enroll in this course to access course content.

📘 Course Overview

This all-in-one practical training course is your gateway to mastering the most in-demand skills in accounting, taxation, and business analytics — Tally ERP 9, TallyPrime with GST, and Microsoft Excel (Basic to Advanced).

Whether you are a student, fresher, job seeker, or a business professional, this course is structured to teach you step-by-step how to handle real-world accounting tasks, manage inventory and payroll, and create professional Excel reports.

This course is based on current industry practices to help you gain job-ready skills and prepare for roles in Accounting, Finance, GST, Taxation, and MIS.

✅ Course Highlights:

🎥 18.5 hours of on-demand video
📄 7 articles + 20 downloadable resources
🧾 Covers Tally ERP 9, TallyPrime, GST & Microsoft Excel 2016, 2019, and Excel 365
🏅 Certificate of Completion included

💼 What You’ll Learn

📊 Tally ERP 9 & TallyPrime with GST

Complete setup & configuration
Manual & GST-based accounting
Inventory, payroll & tax compliance
Practical scenarios for daily accounting needs
Updated training on TallyPrime 3.0 (latest version)

📈 Microsoft Excel – Beginner to Advanced

Data entry, formatting & formulas
Functions like VLOOKUP, IF, INDEX-MATCH, etc.
PivotTables, Charts & Conditional Formatting
Excel for accounting & financial analysis
Designed for Excel 2016, 2019 & Office 365

🎯 Who Should Take This Course

Commerce & Management Students
Aspiring Accountants & GST Practitioners
Freelancers and Entrepreneurs
Entry-Level Finance & MIS Professionals
Anyone who wants to upskill in Accounting + Excel

🚀 Why You Should Enroll

📌 Job-Ready Training: Learn real-life skills used in companies across India
💼 Career Boost: Ideal for roles in accounting, tax, GST filing, Excel analysis, and reporting
🎓 Industry-Relevant Tools: Tally + Excel are must-haves in every accountant’s skillset
🧠 Hands-On Projects: Learn by doing with practical case studies & exercises

🎓 Certificate of Completion

Receive a recognized certificate after completing the course — showcase your skills on your resume or LinkedIn and increase your job prospects.

🔥 Enroll Now and Learn:

Complete Accounting in Tally ERP 9 & TallyPrime
All About GST Filing, Taxation & Compliance
Excel from Basics to Power User Level
Real-Time Projects + Downloadable Resources

Enroll Now!

Trusted by these brands & influencers to get results!

Gear up. Level up. Excel up.

Let’s begin your transformation. Victory awaits inside the grid.

Hear from our past students…

★ ★ ★ ★ ★

“I was so glad I found the course and it sure worked for me. I had major objections in the beginning but decided to take a risk, and it ended up paying off big time!”
Avik Hore

★ ★ ★ ★ ★

“Before the course I was in a tight spot with my problem. I was ready to make a change and am so glad I found this course. I got the result in 8 weeks and life is so much better.”
Rahul Gaur

★ ★ ★ ★ ★

“I am a completely different person now after this course. I came for some tips and tactics, but this course ended up transforming who I was from the inside out.”
Barun

The Course Combines 3 Core Pillars to Unlock Your Excel + Tally Mastery

Knowledge Foundation

We start by building strong fundamentals — from Excel basics, navigation, and formatting to essential formulas.

Practical Application

Real-world projects, resources, quizzes & scenario-based learning, you’ll apply what you learn instantly.

Advanced Productivity

Learn advanced formulas, data analysis, PivotTables, macros, and productivity hacks that save hours and get you noticed.

How It Works

Here’s what you get when you join the [course name] course.

✔ Lessons

Multimedia lessons so you can learn the key ideas, strategies and tactics fast

✔ Coaching

World class coaching to support you and challenge you on the path

✔ Doubt Session

A dedicated trainer that totally “get” you and can support you on the way

Course Curriculum

Tally ERP 9 – From Setup to Vouchers

Tally Introduction

How to Install Tally

Create Company in Tally

Create Ledger in Tally

Voucher Setting

Voucher Entry Understanding

Types of Voucher

Voucher Entry in Tally

Inventory and Order Processing in Tally ERP 9

Inventory Info Understanding

Inventory Management in Tally

Inventory Info – Task & Solution

Sales and Purchase Order Understanding

Purchase Order in Tally

Sales Order in Tally

VAT, TDS, TCS & CST Handling in Tally

VAT Understanding

VAT in Tally

VAT on fixed Assets – Understanding

VAT on Fixed Assets on Tally

Understanding TDS

TDS on Tally

Understanding TCS

TCS on Tally

Understanding CST

CST in Tally

Tally ERP 9 GST, BOM, Costing & Payroll

Understanding GST

GST Practical in Tally

Bill of Material (BOM) Understanding

Bill of Material -BOM in Tally

Cost Center and Cost Category Understanding

Cost Center and Cost Category in Tally

Service Tax in Tally

Budget in Tally

POS in Tally

RCM – Reverse Charge Mechanism in Tally

Payroll in Tally

TallyPrime Essentials for Beginners

How to Install TallyPrime

Create Company in TallyPrime

Create Ledger in TallyPrime

Voucher Entry Understanding

Types of Voucher

Voucher Entry in TallyPrime

TallyPrime: Complete Inventory and Order Processing

Inventory Info Understanding

Inventory Info in TallyPrime

Purchase Procedure in TallyPrime

Purchase Order in TallyPrime

Receipt Note in TallyPrime

Rejection Out in TallyPrime

Purchase Bill in TallyPrime

Debit Note (Purchase Return) in TallyPrime

Sales Order, Delivery Note, Rejection In, Sales & Credit Note in TallyPrime

TallyPrime: Bank Reconciliation and GST Management

Bank Reconciliation in TallyPrime

Understanding GST (Goods and Services Tax)

GST Practical in TallyPrime

Multiple GST Rate In Single Invoice In TallyPrime

GST on Services in TallyPrime

GST on Fixed Assets and Recording Input Tax Credit in TallyPrime

Reverse Charge Mechanism (RCM) in TallyPrime

TallyPrime for Compliance, Costing and Payroll

Bill of Materials (BOM) in TallyPrime

Tax Deducted at Source (TDS) in TallyPrime

Tax Collected at Source (TCS) in TallyPrime

Point of Sale (POS) in TallyPrime

Cost Centre and Cost Category in TallyPrime

Budget in TallyPrime

Payroll in TallyPrime (Managing Attendance, Pay-heads, Overtime, Payslip etc )

Lets Start with Excel Fundamentals

Excel Intro – New File and Title Bar

Customize Ribbons and Quick Access Toolbar

Excel Structure and Worksheets

Data Entry and Formatting

Fill Series in Excel

Flash Fill in Excel

Cell Reference Understanding

Mastering Mathematical Functions

Math Operators in Excel

Math Functions in Excel

Advance Math Function in Excel

Database Math Function

Mastering Logical Functions Use

IF Function in Excel

Nesting IF Methodology

IF Related Project Solution

IF Project Task

IF Project Task Solution

IFS Function – Newly Introduced

AND & OR Function in Excel

XOR Function

Data Filter and Sorting in Excel

Filter in Excel

Date and Color Filter

Advanced Filter Option

Sort and Custom Sort

Conditional Formatting in Excel

Conditional Formatting – How to Apply

Types of Rules in Conditional Formatting

Manage Rules in Conditional Formatting

Mastering Text Functions and Tools

UPPER, LOWER, PROPER and TRIM Function

LEFT, RIGHT and FIND Function

Find Related Task Solution

Nesting LEFT, RIGHT and FIND Function

MID Function

CONCATENATE Function

CONCATENATE Project Task Solution

CONCAT and TEXTJOIN Function

REPLACE Function

REPLACE Function Project Solution

SUBSTITUTE Function

REPT, LEN Function and Project

Task Solution – Substitute and Len Nesting

NUMBERVALUE Function

Text to Column Option

Mastering Chart Presentation in Excel

Chart Preparation in Excel

Designing and Format Chart

Chart Customization – Part 1

Chart Customization – Part 2

Pie Chart in Excel

Quick Analysis and Chart Recommendation

Power Map in Excel

Mastering Pivot Table and Power Pivot

Pivot Table in Excel

Power Pivot in Excel – Most Powerful Analysis Tool

Financial Functions and What if Analysis Tools

PDURATION Function

PMT Function – EMI Calculator

Data Table in Excel

Goal Seek in Excel

Solver Plugin in Excel

Scenario Manager in Excel

Data Grouping and Linking

Define Name Feature in Excela

Hyperlink in Excel

Group and Subtotal in Excel

Draw Tab in Excel

How to Print Spreadsheet Efficiently

Print Options in Excel – Part 1

Print Options in Excel – Part 2

Protect your Data in Excel

Protect Workbook in Excel

Protect Sheet in Excel

Hide Formula and Unlocked Cell

Protect Excel File with Password

Date and Time Management

Date and Time Setting

Date and Time Format in Excel

Date and Time Functions

NETWORKDAYS Function

DATEDIF Function

Mastering Lookup and Reference Functions

VLOOKUP Function

IFERROR Function with VLOOKUP

Array VLOOKUP Function

HLOOKUP Function in Excel

MATCH and INDEX Functions

MATCH and INDEX Functions Nesting

VLOOKUP TRUE Feature

Amazing Trick in LOOKUP Functions

XLOOKUP Function

Mastering Macro Recording Feature

Macro Recording in Excel

Macro Recording Examples

Ways to Run Macros in Excel

Meet Your Instructor

Himanshu Dhar

I’m Himanshu Dhar, a passionate Excel trainer and digital educator with over 14 years of industry experience. With a mission to simplify data skills for everyone, I’ve trained 19,000+ students and professionals in mastering Microsoft Excel, Tally ERP, and Office tools — equipping them with the knowledge to excel in their careers.

I specialize in turning beginners into confident users and guiding working professionals toward advanced automation, analysis, and productivity with Excel 365 and beyond.

My teaching style is practical, real-world focused, and tailored to help learners apply concepts immediately in business, finance, HR, admin, and freelance work.

Whether you’re starting from scratch or aiming to sharpen your skills, my structured courses are designed to empower you with hands-on techniques, downloadable resources, quizzes, and full support.

Let’s unlock your potential — one formula, one function, and one transformation at a time.

Choose a Plan

Invest In Yourself Today

One Time

SALE ₹5,499.00 ₹499.00

Frequently Asked Questions

Will it work for me?

If you are serious, qualified, and ready to put some effort into it, then very likely yes!

When does the course start and finish?

This course is “evergreen” and self-paced, which means you can enroll and begin at any time.

What do I do if I need help?

Email us anytime and come with questions to the weekly office hours calls.

What if I want a refund?

No problem. We stand behind our training 100%. Send us an email with your request.

When will I get access to the course?

After checkout, you will get full, instant access immediately.

Can I pay with Online?

Yes! When you go to check out you can pay with any payment method.

100% No-Risk Guarantee

Your purchase is backed by our 30-day 100% money back “Love It or Leave It” guarantee