• No products in the cart.

Course Curriculum

  • Protection of workbook ā€“ Assignment 4 in Hindi 1 week, 5 days
  • Assignment 2 in Hindi 1 week, 5 days
  • Assignment 3 in Hindi 2 weeks, 1 day
  • Lookup function ā€“ Assignment 1 in Hindi 1 week, 5 days
  • EXCEL FROM BASIC
    Introduction of Excel 00:00:00
    Entering Data & Saving Workbook 00:00:00
    Formula Application 00:00:00
    Worksheet’s Structure 00:00:00
    Using Find, Replace & Spell Check Options 00:00:00
    Application of Fonts, background colors, and borders 00:00:00
    Numbers and Dates Formatting 00:00:00
    Using Headers & Footers and Repeating Rows 00:00:00
    Handling Large Workbooks 00:00:00
    FORMULAS APPLICATION IN EXCEL
    Writing Formula(VERY IMPORTANT) 00:00:00
    EXCEL FUNCTIONS
    Sumif & Sumifs 00:00:00
    Count Function 00:00:00
    Averageif & AverageIfs 00:00:00
    TEXT FUNCTIONS
    Change Case (Upper, Lower, Proper) 00:00:00
    Separating Text on Symmetrical Data 00:00:00
    Separating Text on Non-Symmetrical Data 00:00:00
    LOGICAL FUNCTIONS
    If Functionality 00:00:00
    If with AND 00:00:00
    If with OR 00:00:00
    If with AND & OR 00:00:00
    Nested If 00:00:00
    LOOKUP FUNCTION
    Vlookup 00:00:00
    Vlookup -Type of References 00:00:00
    Vlookup Exact Match 00:00:00
    Double Vlookup 00:00:00
    Vlookup on Duplicate Values 00:00:00
    Vlookup Approximate Match 00:00:00
    Vlookup with If Condition Vlookup 00:00:00
    Hlookup 00:00:00
    Vlookup and Match 00:00:00
    Match 00:00:00
    Index & Match 00:00:00
    AVODHA Official Hindi YouTube Channel 00:00:00
    DATE & TIME FUNCTION
    How Excel Records Date & Timer 00:00:00
    Now, Today & Autofill 00:00:00
    DateValue & TimeValue 00:00:00
    Calculate Working Days 00:00:00
    Dated If 00:00:00
    FINANCIAL FUNCTIONS
    Loan Calculation (PMT, PPMT, IPMT etc.) 00:00:00
    Creating a Loan Table 00:00:00
    Calculate Depreciation 00:00:00
    SORT & FILTER
    Basic Sorting & Shortcut keys 00:00:00
    Sorting Using Custom List 00:00:00
    Horizontal Sorting 00:00:00
    Basic Filter & Shortcut Keys 00:00:00
    Filter Problem 00:00:00
    Advanced Filter 00:00:00
    Advanced Filter Example 00:00:00
    PIVOT TABLE
    Understanding pivot Table 00:00:00
    Using Pivot Table 00:00:00
    EXCEL CHARTS
    Excel Charts Introduction 00:00:00
    Types of Charts-1 00:00:00
    Types of Chart-2 00:00:00
    Chart Design Tab Options 00:00:00
    . PIVOT TABLE ADVANCE
    Grouping in Pivot Table 00:00:00
    Using Slicers 00:00:00
    DATA CONSOLIDATION
    Consolidate Data using Excel Inbuilt Function 00:00:00
    DATA VALIDATION
    Applying Data Validation 00:00:00
    Dependent Dropdown List 00:00:00
    Using Data Validation with Vlookup & Match 00:00:00
    Other Data Validation Examples 00:00:00
    PROTECTION OF WORKBOOK
    Worksheet Level Protection 00:00:00
    Cell Level Protection 00:00:00
    Hiding Formulas from Formula Bar 00:00:00
    Protecting Workbook Structure 00:00:00
    Workbook Level Protection 00:00:00
    AUTOMATION IN EXCEL
    Record your first Macro 00:00:00
    Record Another Macro 00:00:00
    Assigning Macros to a Shape, Button, Picture 00:00:00
    Editing or Deleting a Macro 00:00:00
    Security Settings of a Macro 00:00:00
    Introduction to Tally Prime
    Introduction 00:00:00
    Create Company
    How to Create a Company 00:00:00
    Ledger Creation
    How to Create and Alter Ledger 00:00:00
    Vouchers
    Types Of Vouchers 00:00:00
    Contra, Receipt and Payment Voucher Entry 00:00:00
    Journal, Sales and Purchase Voucher Entry 00:00:00
    Voucher Mode 00:00:00
    Order
    Purchase Order Processing with GST 00:00:00
    Sales Order Processing with GST 00:00:00
    Purchase Entry with GST Rate 00:00:00
    Sales Entry with GST Rate 00:00:00
    Automatic Round Off Invoice value 00:00:00
    Bill Wise Accounting in Tally 00:00:00
    Outstanding Reports
    Bills Payable & Receivable Reports 00:00:00
    Outstanding Checking 00:00:00
    All Bank Transaction Entries
    Banking Transactions 00:00:00
    Backup of Tally Data
    Backup of Data 00:00:00
    Inventory
    Accounting with Inventory 00:00:00
    Stock Summary Report 00:00:00
    Stock Category in Detail 00:00:00
    How to Create Stock Group, Stock Item and Stock Unit 00:00:00
    Alternate Unit Creation in Tally Prime 00:00:00
    Compound Unit in Tally Prime 00:00:00
    Godown Management in Tally Prime 00:00:00
    Price Level and Price List in Tally Prime_1 00:00:00
    Price Level and Price List in Tally Prime_2 00:00:00
    Price Level and Price List in Tally Prime_3 00:00:00
    Bill of Material in Tally Prime_1 00:00:00
    Bill of Material in Tally Prime_2 00:00:00
    GST Entries
    Business Started Entry with Cash 00:00:00
    Inter-State Purchase with GST 00:00:00
    Central Purchase with GST 00:00:00
    Discount Received Entry with GST 00:00:00
    Purchase Entry of Exempted Item_1 00:00:00
    Purchase Entry of Exempted Item _1 00:00:00
    Purchase Entry of Exempted Item_2 00:00:00
    Purchase Return(Debit Note) Entry with GST 00:00:00
    How to Check GST Purchase Report in Tally 00:00:00
    Outstanding Report of Bills Payable 00:00:00
    Intra-State Sale with GST 00:00:00
    Central Sale with GST 00:00:00
    Discount Allowed Entry with GST 00:00:00
    Sale Entry of Exempted Item 00:00:00
    Sales Return(Credit Note) Entry with GST 00:00:00
    How to Check GST Sale Report in Tally 00:00:00
    Outstanding Report of Bills Receivable 00:00:00
    Cash Sales Entry With GST 00:00:00
    Bank Reconcilation Statement 00:00:00
    E-Way Bill 00:00:00
    Freight Charges Accounting in Purchase Invoice 00:00:00
    Freight Charges Accounting in Sale Invoice 00:00:00
    Bank Charges Entry with GST 00:00:00
    Point of Sales Invoice 00:00:00
    Stock Items with Services Accounting in Single Invoice 00:00:00
    Inclusive of Tax Accounting 00:00:00
    Expenses Payable Entry in Tally Prime 00:00:00
    Nil-Rated, Exempted, Non GST Supply Entry 00:00:00
    Multi Slab Tax Rates in Stock Item 00:00:00
    Ineligible Input Tax Credit Entry 00:00:00
    Fixed Assets Purchase Entry 00:00:00
    Audit Fees Accounting Entry 00:00:00
    Capital Goods Entry with GST 00:00:00
    Import Goods Under GST 00:00:00
    NEFT,RTGS Payment Entry 00:00:00
    Customer Turnover in Tally Prime 00:00:00
    How to Maintain Multiple GSTIN and Address 00:00:00
    Goods Sold on Finance Accounting 00:00:00
    Delivery Note Accounting Entry 00:00:00
    Depreciation Accounting Entry 00:00:00
    Bad-Debts and Provision for Doubtful Debts Entry 00:00:00
    Double Discount Entry 00:00:00
    Cost Category and Cost Centre 00:00:00
    Cost Centre Class 00:00:00
    Budget Management for Businesses 00:00:00
    Backup, Restore and Split of Tally Data 00:00:00
    Avoid mistake while making entries 00:00:00
    Basic Excel Internet Research Quiz in Hindi 00:03:00
    Ledger Groups in Tally
    Ledger Group 00:00:00
    Reports
    Exception Report 00:00:00
    Other Topics
    How to use Filter Range Option 00:00:00
    Post-Dated Cheque Entry 00:00:00
    Discount Entries 00:00:00
    How to Export-Import Tally Data 00:00:00
    QUIZ SECTION
    BONUS SECTION
    FINAL TEST Unlimited
    Congrats! Submit the course completion form 00:00:00
    top