Become Job-Ready Accountant in Just ₹999

Learn Advanced Excel + TallyPrime with GST, Payroll & Real Projects in Live Classes

🔥 Limited Offer – ₹999 (₹4999)

  • 00Hours
  • 00Minutes
  • 00Seconds
Enroll Now
✔ Live Interactive Classes
✔ Lifetime Recording
✔ Certificate
✔ Practical Training

Course Highlights

✔ Live Interactive Classes
✔ Beginner to Advanced Level
✔ Real Practical Projects
✔ Lifetime Recording Access
✔ Certificate Included
✔ Job-Oriented Training

Why Choose This Course

✔ 2 Courses in 1
✔ Practical + Real Business Examples
✔ Hindi + Easy Language
✔ Perfect for Job & Freelancing
✔ Suitable for Students & Business Owners

📊 Excel Course
  • Excel Fundamentals
  • Charts & Data Formatting
  • Pivot Tables & Data Analysis
  • VLOOKUP, INDEX MATCH
  • Conditional, Financial Functions
  • Dashboard Creation
💼 TallyPrime Course
  • Accounting Basics
  • TallyPrime Complete Working
  • GST, TDS, TCS
  • Purchase & Sales Cycle
  • Payroll & Banking
  • Real Business Entries

Complete Microsoft Excel Course (Fundamentals to Advanced Formulas)

Master Microsoft Excel from basics to advanced with this complete course. Learn worksheet management, data formatting, charts, printing, lists, and pivot tables. Dive into powerful formulas like VLOOKUP, Index & Match, conditional, statistical, text, and financial functions. Handle large datasets efficiently and build real-world data analysis skills for jobs, business, and productivity.

Microsoft Excel Fundamentals

Master Microsoft Excel from basics to advanced with practical lessons on worksheets, formatting, charts, printing, lists, pivot tables, large data handling, and text functions—ideal for building strong spreadsheet skills.

Excel Fundamentals
  1. Quick start
  2. Intro to Excel
  3. Customizing the Excel Quick Access Toolbar
  4. Rows & columns, Name Box & Formula Bar
  5. Cells
  6. Working with Cell References
  7. Formatting
  8. Saving an Excel Document
  9. Opening an Existing Excel Document
  10. Tables
  11. Marksheet
  12. Common Excel Shortcut Keys
  13. Charts
  14. Formulas & functions
  15. PivotTables
  16. Formulas & functions
  17. 5+ Projects
  18. Excel Fundamentals Quiz
Modifying an Excel Worksheet
  1. Moving and Copying Data in an Excel Worksheet
  2. Inserting and Deleting Rows and Columns
  3. Changing the Width and Height of Cells
  4. Hiding and Unhiding Excel Rows and Columns
  5. Renaming an Excel Worksheet
  6. Deleting an Excel Worksheet
  7. Moving and copying an Excel Worksheet
Formatting Data in an Excel Worksheet
  1. Working with Font Formatting Commands
  2. Changing the Background Color of a Cell
  3. Adding Borders to Cells
  4. Excel Cell Borders Continued
  5. Formatting Data as Currency Values
  6. Formatting Percentages
  7. Merging and Centering Cells
  8. Using Conditional Formatting
Inserting Images and Shapes into an Excel Worksheet
  1. Inserting Images
  2. Inserting Excel Shapes
  3. Formatting Excel Shapes
  4. Working with Excel SmartArt
Creating Basic Charts in Excel
  1. Creating an Excel Column Chart
  2. Adding and Modifying Data on an Excel Chart
  3. Formatting an Excel Chart
  4. Working with Excel Pie Charts
Printing an Excel Worksheet
  1. Viewing your Document in Print Preview
  2. Changing the Margins, Scaling and Orientation
  3. Excel Worksheet Margins
  4. Working with Page Layout View
  5. Adding Header and Footer Content
  6. Printing a Specific Range of Cells
Working with an Excel List
  1. Sorting a List Using Single Level Sort
  2. Sorting a List Using Multi-Level Sorts
  3. Using Custom Sorts in an Excel List
  4. Filter an Excel List
  5. Using Conditional Formatting to Find Duplicates
  6. Removing Duplicates
  7. Creating an Excel Data Validation List
Excel Pivot Tables
  1. Creating an Excel Pivot Table
  2. Modifying Excel PivotTable Calculations
  3. Formatting PivotTable Data
  4. Creating Pivot Charts
  5. Filtering PivotTable Data
  6. Filtering with the Slicer Tool
Working with Large Sets of Excel Data
  1. Using the Freeze Panes Tool
  2. Grouping Data (Columns and/or Rows)
  3. Print Options for Large Sets of Data
  4. Consolidating Data from Multiple Worksheets
Working with Excel's Text Based Functions
  1. Mastering Excel’s “What If?” Tools
  2. Working with Excel’s Goal Seek Tool
  3. Building Effective Data Tables in Excel
  4. Creating Scenarios in Excel

Advance Excel Formulas

Master advanced Excel formulas with hands-on learning of VLOOKUP, Index & Match, conditional, statistical, text, financial, and data functions—perfect for boosting productivity and data analysis skills.

Basic Excel Functions
  1. Sum
  2. Subtraction
  3. Multiplication Function
  4. Division Function
  5. Percentage Calculate
  6. Average
  7. Max
  8. Min
  9. Count
Working with Excel's Conditional Functions
  1. Using Excel’s IF () Function
  2. Nesting Functions with Excel
  3. Excels AND () Function
  4. Excels OR () Function
  5. Excel’s IF () Function with AND () Function
  6. Excel’s IF () Function with OR () Function
Cell referenced
  1. Relative
  2. Absolute Reference
  3. Mixed Reference
Lookup Function
  1. Microsoft Excel Lookup Function
  2. Microsoft Excel VLOOKUP Function
  3. Microsoft Excel Hookup Function
  4. Excel Index Function
  5. Excel Match Function
  6. Microsoft Excel INDEX () and MATCH () Function Combined
  7. Choose Function
Statistical Function in Excel
  1. Sum if In Excel
  2. Sumifs Function in Excel
  3. COUNTIF Function in Excel
  4. COUNTIFS Function in Excel
  5. Average if Function in Excel
  6. Averageifs In Excel
  7. Product Function
  8. Sumproduct Function in Excel
  9. Subtotal Function in Excel
Count functions
  1. Count Function
  2. Counta Function
  3. Count if Function
  4. Countifs Function
  5. Count blank Function
Text Functions
  1. Proper Function in Excel
  2. Upper Function in Excel
  3. Lower Function in Excel
  4. Left Function in Excel
  5. Right Function in Excel
  6. Mid Function in Excel
  7. Len Function in Excel
  8. Trim Function in Excel
  9. Concatenate Function in Excel
Financial Formula
  1. PMT (EMI Calculate)
  2. IPMT (Interest Calculate)
  3. PPMT (Principal Amount Calculator)
  4. PV (Present Value)
  5. FV (Future Value)
Other Excel Functions
  1. Frequency
  2. Product Function
  3. Sumproduct Function
  4. Subtotal Function
  5. REPT Function
  6. Substitute Function
  1. Sorting Data
  2. Data Validation
  3. Consolidation
  4. Pivot Table
  5. Dashboards
  6. Slicers
  7. Drop Down List
  8. Transpose
  9. Remove Duplicates
  10. Linking Sheets
  11. Macros
  12. Page Setup with Printing Options
  13. Data Security
  14. Password Protection

Complete Accounting & TallyPrime Course (Basic to Advanced)

Build a strong foundation in accounting and TallyPrime with practical training on vouchers, inventory, purchase and sales cycles, banking, payroll, and taxation (GST, TDS, TCS). Advance your skills with real-world applications and explore job opportunities in accounting and finance.

Fundamental of TallyPrime Course

Build a strong foundation in accounting and TallyPrime by learning basic concepts, software fundamentals, voucher entries, inventory management, and purchase cycle. Perfect for beginners to understand real-world accounting processes step by step.

Basic Concept of Accounting
  • What is Accounting
  • Golden rules of accounting
  • Business Transaction
  • Basic concepts of accounting
  • Journal entries
  • Single Made Entry
  • Double Made Entry
  • Book Keeping
Fundamentals of TallyPrime Software
  • What is tally prime?
  • Gateway of Tally Explained
  • Create Company in tally
  • Alter Company
  • Select Company / Change Company
  • Shut Company
  • Backup Company
  • Restore Company
  • Delete Company
TallyPrime Basic Working
  • 28 Predefine Group in Tally
  • How to create Groups of Ledger?
  • What is Ledger & How to Create in Tally
  • How to Alter Ledger?
  • How to Delete Ledger?
  • Stock Group Create
  • Stock category create
  • Stock unit creation
  • Stock Item Create
  • How to Create Godowns / Location
  • Display Profit & Loss Statement
  • Display Balance Sheet
Accounting Vouchers
  • What are vouchers
  • What is narration?
  • Journal Voucher and Entries
  • Purchase Voucher – Bill
  • Sales Voucher – Bill
  • Payment Made Voucher Entries
  • Receipt Payment Voucher Entries
  • Contra Voucher – Banking Transaction 
  • Credit Note – Sales Return
  • Debit Note – Purchase Return
Stock Inventory Vouchers
  • Purchase Order
  • Sales Order
  • Rejection In (Sales Return / Inward Rejection)
  • Rejection Out (Purchase Return / Outward Rejection)
  • Stock Journal Transfer Stock Item
  • Goods Delivery Note
  • Goods Receipt Note
  • Manage Multiple Godowns
  • Stock Summary Reports
  • Stock Summary group wise
  • Stock Report Location/Godown wise
  • Stock Journal Class (Transfer & Consumption)
Purchase Cycle
  • Purchase Order
  • Receipt Note
  • Rejection Out (Purchase Return / Outward Rejection)
  • Purchase Voucher
  • Payment Voucher

Advance TallyPrime Course

Advance your skills with practical training in sales processes, banking transactions, payroll management, and taxation (GST, TDS, TCS). Learn advanced accounting techniques and prepare for real job opportunities in the finance and accounting field.

Sales Cycle / Process
  • Sales Order
  • Delivery Note
  • Rejection In (Sales Return / Inward Rejection)
  • Sale Voucher
  • Receipt Voucher
Banking Transactions
  • Bank Deposit, Withdrawal, Transfers 
  • Bank Ledger Create
  • Cheque Book Printing in Tally
  • Cancel Cheque Book in Tally
  • Pass Blank Cheque Book
  • Bank Reconciliation
  • Bank Interest Calculation
Payroll Master Vouchers
  • Employee Category (Head Office, Payroll)
  • Create Employee Group
  • Create Employee
  • Payroll Work Unit Creation
  • Payroll Attendance / Production Type
  • Payroll Pay Heads Creation
  • Payroll Voucher Creation
  • Attendance Sheet Voucher
  • Define Employee Salary
  • Make Employee Salary in Tally Prime
Advance TallyPrime and Accounting
  • Bill By Bill
  • Memorandum Vouchers
  • Optional Vouchers
  • Physical Stock Vouchers
  • Post Dated Vouchers
  • Round Off
  • Multi-Currency maintains
  • Multiple Price Level on Item (Whole Seller, Retailer, Customer)
  • Add Discount Column in Invoices (Discount on Purchase, Sales, Brokerage)
  • Use Actual Qty and Billed Qty in Tally Prime (Buy one Get one) Free Offers
  • Zero Value Entry (Sample Received, Placed, Blank Cheque)
  • Point Of Sales (shopping mall Bill Making)
  • Job Costing & Cost Centres
  • Interest Calculation in Tally Prime
  • Product Manufacturing in Tally Prime
  • Budget Control in Tally Prime
  • Tally Auditing in Tally Prime
  • Export/Import of Data
  • E-mail
  • Split A Company
  • Internal Backup Company
  • How to Restore Company
  • Printing All the Reports
Taxation GST - TDS - TCS
  • What Is GST?
  • Purchase Voucher (CGST – SGST)
  • Purchase Voucher (IGST)
  • Sales Voucher with GST (IGST)
  • Sales Voucher With (CGST – SGST)
  • GSTR1 Report
  • GSTR2 Report
  • Service In GST.
  • Multi GST.
  • B2C
  • URD Unregistered Dealer
  • Debit/Credit Note.
  • Manufactured With GST.
  • Capital Goods GST.
  • Composite With GST.
  • Registration Process.
  • Reports Printing.
  • Company Level Projects.
  • What is TDS?
  • TDS Deduction in Tally Prime
  • TCS on Purchase in Tally Prime
  • TCS on Sales in Tally Prime
Job Opportunity
  • Account Executive
  • Accountant
  • Account Manager
  • Audit Manage
adinserter block="1"
  • 00Hours
  • 00Minutes
  • 00Seconds
Enroll Now
Scroll to Top