TallyPrime + Micosoft Excel Training

TallyPrime + Micosoft Excel Training, available at $54.99, has an average rating of 4.29, with 105 lectures, based on 7 reviews, and has 58 subscribers.

You will learn about How to Create Company in TallyPrime Accounting basics like debits and credits that will help you understand and post entries with confidence Learn to transfer account information (Bookkeeping) from physical to TallyPrime Software Learn to create ledger and alter ledger as well Voucher Entry – Learn to do voucher entry and checking Balance sheet and Profit and Loss Account on that basis Stock & Inventory Management in TallyPrime – Set up details of Inventory and reports like availability of certain stock in particular warehouse and its cost. Learn how sales Bill is generated in TallyPrime in POS (Point of Sales) Bill of Materials (BOM) – Learn in how many ways Bill of material can be generated Learn the procedure of TDS and TCS in general and implementing it in Tally. GST in TallyPrime – Learn GST topics like GST Taxation, Reverse Charge Mechanism, GST on Services, GST on Fixed Assets Mutiple GST rates etc Payroll in TallyPrime – Learn complete Corporate Payroll set up that complies with Govt. prescribed deduction rates Cost Center and Cost Categories Budget in Tally Bank Reconciliation Good understanding of Excel at MIS level Expertise in Text Function Expertise in Logical Function Expertise in Math Function Expertise in Lookup and Reference Function Expertise in Date and Time Function Mastery in Pivot Table and Chart Preparation Mastery in 'What if Analysis' tools Print Option in Excel Data Validation, Filter and Conditional Formatting Mastery in Data organizing Tools in Excel Mastery in Data creation and Data Manipulation in Excel Managing data protection and data sharing in Excel Work with Macro Recording This course is ideal for individuals who are Anyone wants to learn TallyPrime along With Advance Excel It is particularly useful for Anyone wants to learn TallyPrime along With Advance Excel.

Enroll now: TallyPrime + Micosoft Excel Training

Summary

Title: TallyPrime + Micosoft Excel Training

Price: $54.99

Average Rating: 4.29

Number of Lectures: 105

Number of Published Lectures: 105

Number of Curriculum Items: 105

Number of Published Curriculum Objects: 105

Original Price: ₹6,900

Quality Status: approved

Status: Live

What You Will Learn

How to Create Company in TallyPrime
Accounting basics like debits and credits that will help you understand and post entries with confidence
Learn to transfer account information (Bookkeeping) from physical to TallyPrime Software
Learn to create ledger and alter ledger as well
Voucher Entry – Learn to do voucher entry and checking Balance sheet and Profit and Loss Account on that basis
Stock & Inventory Management in TallyPrime – Set up details of Inventory and reports like availability of certain stock in particular warehouse and its cost.
Learn how sales Bill is generated in TallyPrime in POS (Point of Sales)
Bill of Materials (BOM) – Learn in how many ways Bill of material can be generated
Learn the procedure of TDS and TCS in general and implementing it in Tally.
GST in TallyPrime – Learn GST topics like GST Taxation, Reverse Charge Mechanism, GST on Services, GST on Fixed Assets Mutiple GST rates etc
Payroll in TallyPrime – Learn complete Corporate Payroll set up that complies with Govt. prescribed deduction rates
Cost Center and Cost Categories
Budget in Tally
Bank Reconciliation
Good understanding of Excel at MIS level
Expertise in Text Function
Expertise in Logical Function
Expertise in Math Function
Expertise in Lookup and Reference Function
Expertise in Date and Time Function
Mastery in Pivot Table and Chart Preparation
Mastery in 'What if Analysis' tools
Print Option in Excel
Data Validation, Filter and Conditional Formatting
Mastery in Data organizing Tools in Excel
Mastery in Data creation and Data Manipulation in Excel
Managing data protection and data sharing in Excel
Work with Macro Recording

Who Should Attend

Anyone wants to learn TallyPrime along With Advance Excel

Target Audiences

Anyone wants to learn TallyPrime along With Advance Excel

TallyPrime is simple and designed to be used by people from non-IT and non-accounts background as well. Ease of discovering information, consistent options, navigating without the need to remembering the paths and much more makes you start using TallyPrimeright away. The course content is going to teach students in detail on how to manage accounting, Inventory, orders and payroll in Tally.

If you are going to learn TallyPrime you must get well acquainted with MS Excel.
Microsoft Excel is a spreadsheet application developed by Microsoft Inc for Microsoft Windows and MAC OS X. Its use is to do advanced calculation, graphing tools, pivot tables, and a macro programming language referred to as Visual Basic for Applications. The course curriculumis one of the most comprehensive and most advanced. In this 7 hours of training with 74 lectures videos, you will be taken through the fundamentals of Excel till the Expertise level.

Course Curriculum

Chapter 1: TallyPrime Course

Lecture 1: How to Install TallyPrime

Lecture 2: Create Company in TallyPrime

Lecture 3: Create Ledger in TallyPrime

Lecture 4: Voucher Entry Understanding

Lecture 5: Types of Voucher

Lecture 6: Voucher Entry in TallyPrime

Lecture 7: Inventory Info Understanding

Lecture 8: Inventory Info in TallyPrime

Lecture 9: Purchase Procedure in TallyPrime

Lecture 10: Purchase Order in TallyPrime

Lecture 11: Receipt Note in TallyPrime

Lecture 12: Rejection Out in TallyPrime

Lecture 13: Purchase Bill in TallyPrime

Lecture 14: Debit Note (Purchase Return) in TallyPrime

Lecture 15: Sales Order, Delivery Note, Rejection In, Sales & Credit Note in TallyPrime

Lecture 16: Bank Reconciliation in TallyPrime

Lecture 17: Understanding GST (Goods and Services Tax)

Lecture 18: GST Practical in TallyPrime

Lecture 19: Multiple GST Rate In Single Invoice In TallyPrime

Lecture 20: GST on Services in TallyPrime

Lecture 21: GST on Fixed Assets and Recording Input Tax Credit in TallyPrime

Lecture 22: Reverse Charge Mechanism (RCM) in TallyPrime

Lecture 23: Bill of Materials (BOM) in TallyPrime

Lecture 24: Tax Deducted at Source (TDS) in TallyPrime

Lecture 25: Tax Collected at Source (TCS) in TallyPrime

Lecture 26: Point of Sale (POS) in TallyPrime

Lecture 27: Cost Centre and Cost Category in TallyPrime

Lecture 28: Budget in TallyPrime

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

Chapter 2: Microsoft Excel Course

Lecture 1: Excel Structure

Lecture 2: Cell Properties

Lecture 3: Autofill Value and Text

Lecture 4: Autofill Date

Lecture 5: Autofill Advance Tools

Lecture 6: Cell Reference

Lecture 7: Operators Based Equation

Lecture 8: Math Function

Lecture 9: Text Function – Upper, Lower, Proper, Trim

Lecture 10: Text Function – Right, Left

Lecture 11: Text Function – Find and Task

Lecture 12: Text Function – Solution and Nested Left

Lecture 13: Text Function – Find and Left Nesting

Lecture 14: Text Function – Mid Function

Lecture 15: Text Function – Mid Task and Solution

Lecture 16: Text Function – Concatenate

Lecture 17: Text Function – Concatenate Task and Solution

Lecture 18: Text Function – Replace

Lecture 19: Text Function – Replace Task and Solution

Lecture 20: Text Function – Substitute

Lecture 21: Text Function – Len, Rept, Excat, Search

Lecture 22: Text To Column

Lecture 23: Workbook Protect

Lecture 24: Protect Sheet

Lecture 25: Hide Formulas and Unlocked Cell

Lecture 26: Protect File With Password

Lecture 27: If Function – Logical Test

Lecture 28: If Function – With Equation and Task

Lecture 29: If Function – Nested If

Lecture 30: If Function – Advance

Lecture 31: If Function – Adv 2

Lecture 32: Ifs Function – Updated

Lecture 33: And , Or Function

Lecture 34: And, Or, If Nested

Lecture 35: And, Or Advance

Lecture 36: XOR Function – Updated

Lecture 37: Pivot Table – Intro

Lecture 38: Pivot Table – Manage Field Area

Lecture 39: Pivot Table – Value Field, Report and More

Lecture 40: Pivot Table – Slicer And Dublicate Pivot

Lecture 41: Pivot Table – Group To Mange Date and Values

Lecture 42: Pivot Table – Insert Calculated Field

Lecture 43: Goal Seek – What if Analysis

Lecture 44: Scenario Manager – What if Analysis

Lecture 45: Pmt Function – Emi Calculator

Lecture 46: Data Table – Create Loan Table

Lecture 47: Print Option In Excel – Part 1

Lecture 48: Print Option In Excel – Part 2

Lecture 49: Share Book

Lecture 50: Chart Preperation

Lecture 51: Chart Preperation – Advance

Lecture 52: Chart Preperation – Customize

Lecture 53: Conditional Formatting

Lecture 54: Conditional Formatting – Types Of Rules

Lecture 55: Conditional Formatting – Mange Rules

Lecture 56: Conditional Formatting – Create New Rules 1

Lecture 57: Conditional Formatting – Create New Rules 2

Lecture 58: Data Validation

Lecture 59: Data Validation – Input Message and Error Alert

Lecture 60: Advance Math Function

Lecture 61: Advance Math Function 2

Lecture 62: Using Of Wild Card In Math Function

Lecture 63: Vlookup Function

Lecture 64: Vlookup With Iferror

Lecture 65: Vlookup Nesting With If

Lecture 66: Hlookup Function

Lecture 67: Match Function

Lecture 68: Index and Match Nested

Lecture 69: Vlookup Array

Instructors

Himanshu Dhar
MIS Trainer

Rating Distribution

1 stars: 0 votes
2 stars: 0 votes
3 stars: 3 votes
4 stars: 0 votes
5 stars: 4 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!

Menu