Tuesday, September 30, 2025

 TallyPrime | Practical GST | Basic To Advance Excel | SAP - ERP| Power BI & MIS courses in Chandigarh - 9988113578

 Call: +91-7888919083


  • \  

    ✅ Fundamentals of Accounting

    🔹 Introduction to Accounting

    • Meaning and Purpose of Accounting
    • Key Terminologies Used in Accounting
    • Concepts and Principles of Accounting

    🔹 Double Entry System

    • Uses of Debit and Credit
    • Rules of Debit and Credit
    • ✅ Golden Rules of Accounting

    🔹 Recording Business Transactions

    • Journalizing Transactions
    • ✅ Trial Balance Preparation
    • ✅ Financial Statements
      • Trading Account
      • Profit & Loss Account
      • Balance Sheet

    🔹 Subsidiary Books & Control Accounts

    • Cash Book, Petty Cash Book
    • Purchase & Purchase Return Books
    • Sales & Sales Return Books
    • Journal Proper
    • ✅ Control Accounts

    🔹 Depreciation

    • Methods of Depreciation
    • Preparation of Depreciation Schedule

    🔹 Computerized Accounting

    • Advantages of Computerized Systems
    • Accounting Structure in Digital Format

    ✅ Introduction to TallyPrime

    • Features of TallyPrime
    • Downloading & Installation
    • Types of Licenses
    • License Activation & Reactivation
    • Multiuser Environment Setup
    • Educational Mode Usage
    • ✅ Company Creation & Configuration
    • Navigation Techniques
    • F12 Configuration
    • Altering & Shutting Company

    ✅ Maintaining Chart of Accounts in TallyPrime

    • Chart of Accounts Overview
    • ✅ Creation of Masters
      • Accounting Masters
      • Inventory Masters
    • Alteration & Deletion of Masters
    • ✅ Multi-Master Creation
      • Multi Groups, Ledgers, Stock Groups, Stock Items

    ✅ Recording & Maintaining Accounting Transactions

    • Voucher Entry in TallyPrime
      • Receipt (F6), Contra (F4), Payment (F5)
      • Purchase (F9), Sales (F8)
      • Debit Note (Alt+F5), Credit Note (Alt+F6)
      • Journal Voucher (F7)

    ✅ Banking in TallyPrime

    • Cheque Printing (Single & Multi)
    • Deposit Slip (Cheque & Cash)
    • Payment Advice
    • Manual & Auto Bank Setup

    ✅ Financial Statements & MIS Reports

    🔹 Final Accounts Reports

    • Trial Balance
    • Profit & Loss Account
    • Balance Sheet
    • Cash Flow & Fund Flow Analysis
    • Receipts & Payments

    🔹 MIS Reports

    • Stock Summary
    • DayBook
    • Cash & Bank Book
    • Purchase & Sales Registers
    • Journal Register

    ✅ Data Security in TallyPrime

    • Security Control Activation
    • User Role Creation
    • Password Setup for Company

    ✅ Company Data Management

    • Backup & Restore
    • Company Data Repair

    ✅ GST in TallyPrime

    🔹 GST Fundamentals

    • Why GST, Tax Structure, Registration
    • HSN/SAC Management
    • GST Rate Structure
    • Invoicing & Input Tax Credit
    • E-Way Bill

    🔹 GST Setup in Tally

    • Company Creation & GST Activation
    • Capital Introduction
    • Master Creation

    🔹 Recording GST Transactions

    • Intrastate & Interstate Supply
    • Input Tax Credit Set-Off
    • GST Payment & Challan Reconciliation

    🔹 GST Returns

    • GSTR-1, GSTR-3B, GSTR-9

    ✅ Inventory Management in TallyPrime

    🔹 Storage & Classification

    • Supply Chain & Supplier Types
    • Inventory Terminologies

    🔹 Inventory Masters

    • Company Creation
    • Capital Introduction
    • Master Creation

    🔹 Batch/Lot Tracking

    • Activation & Reporting

    🔹 Price Levels & Lists

    • Price List Creation & Usage
    • Sales Voucher Integration
    • Price Revision

    ✅ Accounts Receivable & Payable Management

    • Bill-wise Entry Activation
    • Usage in Purchase, Sales, Payment, Receipt Vouchers
    • Credit Limit Setup (Individual & Multiple Ledgers)
    • Sales Voucher Restrictions
    • Splitting Credit Sales
    • Debtor Payment Performance

    🔹 Reports

    • Bills Receivable & Payable
    • Ageing Analysis
    • Reminder Letters
    • Confirmation of Accounts
    • Bill Settlement

    ✅ Purchase & Sales Order Management

    🔹 Purchase Order Cycle

    • Purchase Order, Receipt Note
    • Rejections Out, Purchase Voucher
    • Debit Note, Payment Voucher

    🔹 Sales Order Cycle

    • Sales Order, Delivery Note
    • Rejections In, Sales Voucher
    • Receipt Voucher

    🔹 Order Tracking

    • Sales & Purchase Order Outstanding
    • Pre-Closure of Orders
    • Reorder Level Display

    🔹 Godown Transfer

    ✅ Tracking Additional Costs of Purchase

    • Configuration of Additional Costs
    • Voucher & Item Invoice Mode
    • Debit Note with Additional Cost

    ✅ Cost/Profit Centres Management

    • Activation of Cost Centres
    • Expense Allocation
    • Cost Centre Classes
    • Multiple Cost Centre Allocation

    🔹 Reports

    • Category Summary
    • Cost Centre Break-up
    • Ledger & Group Break-up

    ✅ Budgets & Scenarios

    • Budget Creation & Transaction Recording
    • Variance Reports
    • Scenario Management
      • Reversing Journal Inclusion

    ✅ Generating & Printing Reports

    🔹 On-the-Fly Reporting

    • Bird’s Eye View
    • Drill Down Display
    • Date/Period Comparison

    🔹 Inventory Reports

    • Stock Summary
    • Godown-wise Availability
    • Movement Analysis
    • Stock Query

    🔹 Financial Reports

    • Balance Sheet
    • Profit & Loss Account

    🔹 Books & Registers

    • Invoice & Report Printing

    "The Advanced Excel Institute " - Excel | Power BI | Tableau & SQL Training in Chandigarh

     ✅ Excel Foundations & Data Handling

    🔹 Getting Started with Excel

    • Navigating ribbons, tabs & quick access toolbar
    • Workbooks vs. Worksheets
    • Opening, saving & managing files efficiently
    • Customizing the Excel environment for productivity

    🔹 Working with Data Entry

    • Accurate data entry & editing
    • Keyboard shortcuts for speed
    • Understanding data types: numbers, text, dates, currency
    • Preventing common entry mistakes

    🔹 Formatting for Clarity

    • Number, date & custom formats
    • Adjusting column widths, row heights, alignment
    • Cell styles for consistency
    • Borders, shading & themes for professional sheets

    🔹 Formulas & Basic Functions

    • Understanding the formula bar
    • Arithmetic formulas: +, –, *, /
    • Common functions: SUM, AVERAGE, MIN, MAX, COUNT
    • Cell references: relative, absolute, mixed

    🔹 Organizing & Structuring Data

    • Sorting alphabetically, numerically, custom order
    • Filtering for precision
    • Freezing panes & splitting windows
    • Grouping & outlining rows/columns

    🔹 Data Cleaning Essentials

    • Removing duplicates & fixing blanks
    • Trimming spaces & correcting text
    • Handling errors: #DIV/0!, #N/A
    • Converting text to numbers/dates

    🔹 Introduction to Data Validation

    • Drop-down lists for consistency
    • Input rules & restrictions
    • Custom messages for invalid entries

    ✅ Advanced Excel for Data Analysis

    🔹 Logical Functions

    • IF function for decisions
    • AND, OR for multiple conditions
    • Nested IFs for layered logic
    • Real-world uses: pass/fail, commissions, project status

    🔹 Lookup Functions

    • VLOOKUP & HLOOKUP
    • XLOOKUP for flexible searches
    • IFERROR for clean results
    • Examples: product prices, employee IDs, customer details

    🔹 Text Functions

    • LEFT, RIGHT, MID for extraction
    • FIND, SEARCH for positions
    • CONCATENATE, TEXTJOIN for combining
    • TRIM, PROPER, UPPER, LOWER for cleaning

    🔹 Date & Time Functions

    • Excel’s date/time system
    • DATEDIF, NETWORKDAYS for calculations
    • Extracting day, month, year
    • TODAY, NOW for dynamic reports

    🔹 Named Ranges & Dynamic Formulas

    • Creating & managing named ranges
    • OFFSET, INDEX for dynamic logic
    • Structured references in tables
    • Auto-updating reports

    🔹 Conditional Formatting

    • Color scales, data bars, icon sets
    • Custom rules for highlights
    • Formula-based formatting
    • Examples: top performers, overdue tasks, low sales

    🔹 Working with Tables

    • Converting data into Excel tables
    • Auto-fill & structured references
    • Sorting, filtering, slicers
    • Automation & Power Query integration

    ✅ Data Analysis Tools in Excel

    🔹 PivotTables

    • What they are & why they matter
    • Creating from raw data
    • Rearranging fields for insights
    • Summarizing with counts, sums, averages
    • Grouping by dates, numbers, categories
    • Examples: sales summaries, performance reports

    🔹 PivotCharts

    • Converting PivotTables into charts
    • Choosing the right chart type
    • Formatting for clarity
    • Auto-updating with PivotTable changes

    🔹 Grouping, Filtering & Slicers

    • Grouping by months, quarters, categories
    • Filters for focus
    • Slicers for visual filtering
    • Examples: region-wise sales, HR reports

    🔹 Data Validation & Drop-Downs

    • Drop-down menus for consistency
    • Input restrictions
    • Custom error messages
    • Examples: product lists, employee roles

    🔹 What-If Analysis

    • Goal Seek for target values
    • Scenario Manager for possibilities
    • Data Tables for quick testing
    • Examples: pricing, budgeting, planning

    🔹 Quick Analysis Tools

    • Instant formatting, charts, totals
    • Spotting trends in clicks
    • When to use Quick Analysis

    ✅ Power Query in Excel

    🔹 Introduction to Power Query

    • What it is & why it matters
    • Excel vs. Power BI
    • Power Query Editor interface
    • Query steps & transformations

    🔹 Connecting to Data Sources

    • Excel, CSV, text, XML
    • SQL Server, Access, MySQL
    • Online sources & web pages
    • Combining files from folders

    🔹 Basic Data Cleaning

    • Removing unwanted rows/columns
    • Renaming for clarity
    • Changing data types
    • Sorting & filtering

    🔹 Advanced Transformations

    • Splitting columns by delimiter
    • Merging columns
    • Extracting text portions
    • Trimming & fixing inconsistencies
    • Replacing values

    🔹 Combining & Merging Data

    • Appending queries (vertical stacking)
    • Merging queries (horizontal joins)
    • Join types: inner, left, right, full outer
    • Examples: monthly sales, customer + transaction merge

    🔹 Calculated Columns & Logic

    • Custom columns with formulas
    • Conditional columns for categorization
    • Examples: discounts, spend-level grouping

    🔹 Automating Refresh & Load

    • One-click data refresh
    • Load options: table, PivotTable, connection only
    • Best practices for clean workflows






ChandigarhQB – QuickBooks Training in Chandigarh / Intuit QuickBooks Training & Certification Centre in Chandigarh 









  •  ✅ Installing QuickBooks

  • 🔹 Getting Started


    • System Requirements

    • Installation Process

    • Upgrading from Older Versions

    • Converting Data from Other Intuit Products

    • Registering QuickBooks

    • Checking for Software Updates

    • ✅ What’s New in This Version

    ✅ Setting Up Your Company File

    🔹 Step-by-Step Setup

    • Choose a Start Date

    • Gather Business Information

    • Create Your Company File

    • Set Up Company Lists

    • Enter Opening Balances

    • Set Up Payroll (Optional)

    • Enter Adjustments

    • Customize Preferences

    ✅ Entering Historical Transactions

    • Sales & Accounts Receivable (A/R)

    • Accounts Payable (A/P)

    • Payroll Transactions

    • Bank & Other Transactions

    • Changing the Start Date

    ✅ Managing Lists in QuickBooks

    🔹 List Operations

    • Types of Lists

    • Editing & Deleting Items

    • Speeding Up Data Entry

    • Adding Custom Fields

    • Organizing Lists

    • Printing, Saving, Emailing Lists

    ✅ Chart of Accounts

    • Overview & Structure

    • Adding New Accounts

    • Entering & Editing Opening Balances

    • Using Account Numbers

    • Organizing & Merging Accounts

    • Printing Chart of Accounts

    ✅ Items – Products & Services

    • Creating Items & Subitems

    • Invoicing Tips for Cost-Based Businesses

    • Editing & Deleting Items

    • Changing Prices

    • Item Reports

    ✅ Tracking Sales

    🔹 Sales Operations

    • Types of Sales Forms

    • Entering & Managing Sales Transactions

    • Customizing Sales Forms

    • Printing, Saving, Emailing Sales

    • Charging for Time & Costs

    • Daily Sales Summary

    • Finance Charges & Billing Statements

    • Using Estimates

    ✅ Receiving & Depositing Payments

    • Recording Payments (Invoice/Statement)

    • Handling Overpayments, Retainers, Prepayments

    • Correcting Payment Applications

    • Depositing Payments

    • Recording Returns & Bounced Checks

    ✅ Inventory Management

    • Viewing Items on Order

    • Receiving Inventory

    • Inventory Register & Average Cost

    • Adjusting Quantity & Value

    • Returning Items to Vendor

    • Inventory Reports

    ✅ Sales Tax – Tracking & Payment

    • Turning On Sales Tax

    • Creating Tax Items & Groups

    • Assigning Taxes to Customers

    • Marking Items as Taxable

    • Applying Tax to Sales

    • Handling Non-Taxable & Unusual Cases

    • Tracking & Paying Sales Tax

    ✅ Accounts Receivable Management

    • A/R Register & Customer Register

    • Editing Transactions & Opening Balances

    • Transaction History & QuickReports

    • A/R Reports & Graphs

    ✅ Bills & Accounts Payable

    🔹 Bills

    • Entering, Paying, Viewing Bills

    • Editing & Deleting Bills

    • Vendor Credits

    • Payment Reminders

    🔹 Accounts Payable

    • A/P Register & Transaction History

    • Vendor Reports & Graphs

    ✅ Managing Your Checkbook

    • Entering, Editing, Voiding, Deleting Checks

    • Printing, Saving, Emailing Checks

    • Depositing Funds

    ✅ Credit Card Transactions

    • Entering & Editing Transactions

    • Reconciling & Paying Credit Card Statements

    ✅ Purchase Order Management

    • Turning On & Customizing PO Feature

    • Entering & Viewing Purchase Orders

    • Receiving Items

    • Editing & Closing POs

    • Printing Purchase Orders

    ✅ Account Registers

    • Opening & Using Registers

    • Entering & Editing Transactions

    • Finding & Printing Transactions

    ✅ Assets, Liabilities & Equity

    🔹 Assets

    • Adding Fixed Assets & Depreciation

    • Selling, Recording Losses, Purchasing Assets

    🔹 Liabilities

    • Borrowing & Loan Tracking

    🔹 Equity

    • Profit Distribution

    • Owner’s Draw & Capital Investment

    ✅ Account Reconciliation

    • Reconciling Accounts & Statements

    • Marking Cleared Transactions

    • Completing Reconciliation

    • Printing Reconciliation Reports

    ✅ Time Tracking

    • Weekly Timesheets & Single Activities

    • Invoicing for Time

    • Time Reports

    ✅ Reports, Graphs & Budgets

    • Setting Preferences

    • Creating, Customizing, Filtering Reports

    • QuickZoom & Export to Excel

    • Memorizing Reports

    • QuickReports, Graphs, Budgets

    ✅ Customizing Preferences

    • View, Data Entry, Reminder Preferences

    • Backup & Company Info Settings

    • Transaction, Inventory, PO, Estimate Preferences

    • Sales, Statement, Check Preferences

    • Finance Charge, Reporting, Sales Tax Preferences

    • Time Tracking, Job, Password, 1099, Toolbar Preferences

    ✅ Maintaining Your Data

    • Changing Company Info & Files

    • Audit Trail & Backup

    • Restoring & Transferring Data

    • Mail Merge & Data Condensation

    • Periodic Tasks

    ✅ Accounting Basics

    • Balance Sheets

    • Chart of Accounts

    • Payment Terms

    • Aging Reports

    • Cash vs. Accrual Tax Basis

    • Glossary of Terms

    ✅ QuickBooks for Windows & Quicken Users

    • File Conversion (Mac ↔ Windows)

    • Quicken to QuickBooks Migration

    • Data Differences

    ✅ Contacting Intuit

    • Error Messages

    • Support Channels

    • QuickBooks Contact Info

     

      

     



  • Chandigarh SAP ERP Course Academy


  • SAP FICO | SAP SD | SAP MM | SAP HCM | SAP APAB | SAP WM | SAP HANA | SAP s4-HANA |SAP -PP | SAP-SCM | CRM

    SAP – SD – SAP Sales & Distribution Training Academy in Chandigarh

    ✅ Overview of Business Functional Modules in SAP

    • FI/CO, MM, PP, WM, HCM, and their integration with SD
      ✅ Sales and Distribution Process Cycles with WM
    • From Inquiry → Quotation → Order → Delivery → Billing → Payment
      ✅ Roles and Responsibilities of SAP Consultant
    • End-user support, configuration, testing, documentation
      ✅ Customization in Sales & Distribution Module
    • Basic settings and configurations for SD processes

    🔹 Enterprise Structure with a Business Case
    ✅ Definition and Assignment of Organizational Entities

    • Sales Organization, Distribution Channel, Division, Plant, Storage Location
      ✅ Financial Accounting Integration
      ✅ Sales & Distribution Setup
      ✅ Logistics General Settings
      ✅ Materials Management Link
      ✅ Logistics Execution
      ✅ Consistency Check for S&D Module

    🔹 Master Data

    ✅ Customer Master Data (S&D)

    • Customer Account Groups and Number Ranges
    • Marketing-related Master Data
    • Sales – Customer Groups
    • Shipping – Shipping Schedules

    ✅ Partner Determination for Customer Master

    • Partner Functions
    • Partner Determination Procedure
    • Partner Function & Account Group Assignment
    • Creating a Customer Master – Centrally & Sales
    • Multiple Customer Network Scenarios

    ✅ Material Master (MM Integration)

    • Material Types (Finished Goods, Raw Materials, etc.)
    • Basic Settings for MM
    • Material Groups
    • MRP Groups, MRP Controller, MRP Types
    • Inventory Management Basics
    • Material Master with Warehouse Management

    ✅ Inventory Management

    • Stock Posting for Materials
    • Stock Report Generation

    🔹 Sales Document Management

    ✅ Sales Document Header

    • Sales Document Types
    • Header Level Controls
    • Header Data in Sales Documents
    • Order Reasons & Number Ranges

    ✅ Sales Document Item

    • Item Categories and Item Level Controls
    • Item Data in Sales Documents
    • Define Item Category Groups
    • Assign Item Categories

    ✅ Schedule Line Category for Sales Document

    • Schedule Categories and Assignments

    ✅ Business Process for Sales & Distribution

    • Inquiry → Quotation → Sales Order Processing

    ✅ Copy Controls for Sales Documents

    • Header Level
    • Item Level
    • Schedule Line Level

    🔹 Shipping Process in SD
    ✅ Cross-Selling Determination Process

    • Maintain Field Catalog
    • Maintain Access Sequences
    • Define Condition Types
    • Maintain Procedures
    • Create Condition Tables
    • Assign Document & Customer Procedures

    ✅ Pricing Concepts in Sales

    • Condition Technique Concept
    • Condition Tables, Access Sequences & Condition Types
    • Pricing Procedure Determination
    • Condition Records (Price, Discounts, Surcharges)
    • Condition Exclusion Rules
    • Free Goods (Exclusive & Inclusive)
    • Pricing Analysis in Sales Documents

    🔹 Availability Check & Transfer of Requirements
    ✅ Transfer of Requirements

    • Requirement Classes & Types
    • Requirement Type Determination

    ✅ Availability Check with ATP

    • Checking Groups & Material Block
    • Checking Rules for Availability
    • Procedure for Schedule Line Category

    🔹 Business Processes of Special Sales Cycles
    ✅ Cash Sales Process
    ✅ Rush Order Process
    ✅ Handling Complaints in Sales

    • Credit Memo
    • Debit Memo
    • Free of Charge Deliveries

    ✅ Credit Management Process

    • Types of Credit Controls
    • Risk Categories & Credit Representative Groups
    • Simple & Automatic Credit Check
    • Credit Master Data for Customers
    • Release of Credit Block Documents

    🔹 Material Listing and Exclusion (Condition Technique)
    ✅ Customer Material Info Record
    ✅ Material Determination Process
    ✅ Product Proposal Procedure

    🔹 Consignment Stock Processing
    ✅ Consignment Fill-up
    ✅ Consignment Issue
    ✅ Consignment Pickup
    ✅ Consignment Returns

    🔹 Basic Shipping Functions
    ✅ Shipping Point Determination Process
    ✅ Delivery and Transportation Scheduling

    ✅ Delivery Document

    • Delivery Types & Header Level Controls
    • Delivery Item & Item Level Controls

    ✅ Copy Controls in Delivery Documents

    • Initial Goods Receipt with Warehouse Management
    • Maintain Storage Bins
    • WM Stock Receipt Process
    • Storage Bin Level Stock Report

    ✅ Picking Process at Delivery Level

    • Picking with Warehouse Management

    ✅ Post Goods Issue (PGI) Process

    • FI/MM Settings for PGI
    • Impact Analysis of PGI

    🔹 Billing Process in SD
    ✅ Maintaining Billing Types & Controls
    ✅ Revenue Account Determination (SD-FI Integration)

    • Account Assignment Master Data
    • Revenue Account Determination Procedure
    • Account Keys & Pricing Procedure Assignment

    SAP FICO -SAP Financial & Controlling Training Academy in Chandigarh

    Course Content

    🔹 Financial Accounting (FI)

    ✅ General Topics
     ▫ Introduction of ERP
     ▫ Introduction of SAP
     ▫ Organization Structure
     ▫ Introduction of R/3 Architecture

    ✅ General Settings
     ▫ Countries
     ▫ Regions
     ▫ Currencies
     ▫ Field Display Characteristics

    ✅ Enterprise Structure
     ▫ Company
     ▫ Company Codes
     ▫ Credit Control Area
     ▫ Business Area
     ▫ Consolidation Business Area
     ▫ Functional Area
     ▫ Financial Management Area

    ✅ Financial Accounting Global Settings
     ▫ Fiscal Year
     ▫ Posting Periods
      • Define Variants for Open Posting Periods
      • Open & Close Posting Periods
      • Assign Variants to Company Code
     ▫ Document Types
     ▫ Document Number Ranges
     ▫ Posting Keys
     ▫ Field Status Variant
     ▫ Tolerance Groups for Employees
     ▫ Global Parameters
     ▫ Multiple Currencies

    ✅ General Ledger Accounting (G/L)
     ▫ Chart of Accounts
      • Operating Chart of Accounts
      • Group Chart of Accounts
      • Country-Specific Chart of Accounts
     ▫ Account Groups
     ▫ Retained Earnings Account
     ▫ Tolerance Groups for General Ledger
     ▫ G/L Master Record Management
      • Create / Change / Block / Unblock / Delete
     ▫ G/L Postings & Document Processing
      • Held, Parked, Recurring, Sample Documents
      • Account Assignment Model
      • Individual & Mass Reversals
      • Accruals & Deferrals
     ▫ Foreign Currency Valuations
     ▫ Open Item Management
     ▫ Interest Calculations
     ▫ General Ledger Reports
     ▫ New G/L Accounting
      • Ledger Definition
      • Document Splitting
      • Integration & Periodic Processing
      • Parallel Accounting
      • Reporting & Migration

    ✅ Accounts Payable (AP) & Accounts Receivable (AR)
     ▫ Vendor Master Data & Groups
     ▫ Number Ranges & Tolerances for Vendors
     ▫ Vendor Document Postings (Purchase Invoice)
     ▫ Down Payment Processing
     ▫ Automatic Payment Program
     ▫ Vendor Statements & AP Reports
     ▫ Customer Master Data & Groups
     ▫ Number Ranges & Tolerances for Customers
     ▫ Customer Document Postings (Sales Invoice)
     ▫ Down Payment Received
     ▫ Dunning Program
     ▫ Payment Terms & Installment Payments
     ▫ Credit Memos
     ▫ Customer Statements & AR Reports
     ▫ Interest Calculations

    ✅ Bank Accounting
     ▫ Define House Banks
     ▫ Check Management
     ▫ Cash Journal

    ✅ GST / Tax Settings
     ▫ Tax Calculation on Sales & Purchases

    ✅ Asset Accounting
     ▫ Chart of Depreciation & Depreciation Areas
     ▫ Asset Classes & Number Ranges
     ▫ Account Determinations & Screen Layout Rules
     ▫ Depreciation Methods (Base, Declining, Multi-Level, Maximum Amount)
     ▫ Period Control Methods & Depreciation Keys
     ▫ Asset Master Data Management
     ▫ Asset Transactions (Acquisition, Retirement, Transfer, Scrapping)
     ▫ Depreciation Run & Reports

    ✅ Financial Statements & Integration
     ▫ Balance Sheet & Profit & Loss Preparation
     ▫ Financial Statement Versions
     ▫ Integration with SD & MM

    🔹 Controlling (CO)

    ✅ General Controlling
     ▫ Introduction to CO
     ▫ Maintain Controlling Area
     ▫ Versions & Number Ranges

    ✅ Cost Element Accounting
     ▫ Manual Creation of Primary & Secondary Cost Elements
     ▫ Automatic Cost Element Creation
     ▫ Cost Element Groups

    ✅ Cost Center Accounting
     ▫ Creation of Cost Centers & Groups
     ▫ Manual Cost Reposting & Repost Line Items
     ▫ Cost Planning & Budgets
     ▫ Assessment & Distribution
     ▫ Cost Center Reports

    ✅ Internal Orders
     ▫ Define Order Types
     ▫ Create Internal Orders
     ▫ Planning & Budgeting
     ▫ Manual Cost Reposting & Repost Line Items
     ▫ Internal Order Reports

    ✅ Profit Center Accounting
     ▫ Maintain Controlling Area Settings
     ▫ Create Dummy & Actual Profit Centers
     ▫ Profit Center Groups & Number Ranges
     ▫ Automatic Assignment of Revenue Elements
     ▫ Planning Profit Center Wise
     ▫ Profit Center Reports

    SAP ABAP – SAP Advance Business Application Programming Training Academy in Chandigarh

    COURSE CONTENT

    1. ABAP Basics & Data Elements
      ✅ Introduction to SAP & ABAP programming overview
      ✅ ABAP Workbench Tools: SE80, SE38, SE11, SE37
      ✅ Data Types: Elementary, Complex, Reference types
      ✅ Character & string operations
      ✅ Inline declarations and best practices
      ✅ Control Statements: IF, CASE, LOOP, DO, WHILE
      ✅ System fields (SY-Variables)
      ✅ Exercise: Print system date, time, and username
    2. Database Tables & Data Dictionary
      ✅ Custom tables in ABAP Dictionary
      ✅ Table types: Transparent, Pooled, Cluster
      ✅ Table Maintenance Generator (SM30)
      ✅ Domains, Data Elements, Type Groups
      ✅ Structures, Views, Search Helps, Lock Objects
      ✅ Transport Management
      ✅ Exercise: Create a Z-table with F4 help
    3. Internal Tables & Work Areas
      ✅ Standard, Sorted, Hashed internal tables
      ✅ Operations: APPEND, INSERT, MODIFY, DELETE, READ
      ✅ LOOP with WHERE clause, SY-TABIX
      ✅ DESCRIBE TABLE
      ✅ Performance tips
      ✅ Exercise: Read & print sales orders
    4. Open SQL in ABAP
      ✅ SELECT, INSERT, UPDATE, DELETE
      ✅ Joins: INNER, LEFT, RIGHT OUTER
      ✅ Subqueries, Dynamic SQL
      ✅ FOR ALL ENTRIES, Performance tuning
      ✅ Exercise: Fetch customers & orders using JOIN
    5. Modularization Techniques
      ✅ Subroutines, Includes, Function Modules
      ✅ Parameters, Exceptions, Reusability
      ✅ Intro to ABAP Objects (Classes & Methods)
      ✅ Exercise: Reusable FM for customer validation
    6. Debugging & Testing
      ✅ Classic vs New Debugger
      ✅ Breakpoints & Watchpoints
      ✅ Dumps (ST22), Logs (SM21), Traces (ST05, SAT)
      ✅ Exercise: Debug missing SELECT result
    7. ABAP Events & Messages
      ✅ Report Events: INIT, SELECTION-SCREEN, START-OF-SELECTION
      ✅ Interactive Reports & Drill-down
      ✅ Message Classes (SE91)
      ✅ Exercise: Create interactive report
    8. BDC (Batch Data Communication)
      ✅ Recording (SHDB)
      ✅ Session vs Call Transaction
      ✅ Error handling (BDCMSGCOLL)
      ✅ Exercise: Upload vendor master
    9. BAPI (Business Application Programming Interface)
      ✅ Using Standard BAPIs (Customer, Sales Order)
      ✅ Creating Custom BAPIs
      ✅ RFC-enabled Function Modules
      ✅ Exercise: Create sales order using BAPI
    10. Module Pool Programming (Dialog Programming)
      ✅ Screen Programming (SE51)
      ✅ Flow logic: PBO, PAI
      ✅ Navigation: Subscreens, Tabstrips
      ✅ Input Validations
      ✅ Exercise: Employee entry screen
    11. Enhancement Techniques
      ✅ User Exits, Customer Exits, Screen Exits
      ✅ Implicit & Explicit Enhancements
      ✅ Exercise: Add custom check in VA01
    12. BADI (Business Add-Ins)
      ✅ Classic & New BADIs
      ✅ SE18/SE19 Implementation
      ✅ Filter-dependent BADIs
      ✅ Exercise: PO Release BADI
    13. ALE & IDOC
      ✅ ALE Basics & IDOC Structure
      ✅ Ports, Partner Profiles (WE20)
      ✅ Processing & Error Handling (WE02, BD87)
      ✅ Exercise: Outbound IDOC for Material Master
    14. LSMW (Legacy System Migration Workbench)
      ✅ Steps: Project, Subproject, Object
      ✅ Methods: Direct Input, BAPI, IDOC
      ✅ Mapping, Transformation Rules
      ✅ Exercise: Upload customer master with LSMW

    SAP MM – SAP Material Management Training Academy in Chandigarh

    COURSE CONTENT

    🔹 SAP Getting Started
    ✅ Overview of SAP
    ✅ SAP R/3 Architecture & Landscape
    ✅ ASAP Methodology

    🔹 Enterprise Structure
    ✅ Define Organizational Units
    ✅ Assign Organizational Units

    🔹 Material Master
    ✅ Material Types
    ✅ Number Range Configuration
    ✅ Create / Change / Display Material Master
    ✅ Shipping Instructions & Purchase Value Key

    🔹 Vendor Master
    ✅ Vendor Account Groups
    ✅ Number Range Assignment
    ✅ Create / Change / Display Vendor Master

    🔹 Purchasing Info Records (PIR)
    ✅ Number Range Setup for PIR
    ✅ Create / Change / Display PIR

    🔹 Source List (SL)
    ✅ Source List Configuration
    ✅ Create / Change / Display Source List

    🔹 Purchase Requisition (PR)
    ✅ Document Types & Number Ranges
    ✅ Create / Change / Display PR

    🔹 Request for Quotation (RFQ)

    ✅ Number Range Assignment
    ✅ Create RFQ with reference to PR
    ✅ Maintain / Compare Quotations

    🔹 Outline Agreements

    Contracts
    ✅ Types: Quantity & Value
    ✅ Number Range Setup
    ✅ Create / Change / Display Contracts

    Scheduling Agreements
    ✅ Number Range Setup
    ✅ Create / Change / Display Agreements
    ✅ Enter Delivery Schedules

    🔹 Purchase Order (PO)

    ✅ PO Document Types
    ✅ Price Tolerance Settings
    ✅ Manual PO Creation (PR, RFQ, Contract, Old PO)
    ✅ Change / Display PO

    🔹 Optimization of Purchasing

    ✅ Automatic PO Creation from PR
    ✅ System Settings for Automation

    🔹 Pricing Procedures

    ✅ Access Sequences
    ✅ Condition Types
    ✅ Calculation Schema
    ✅ Schema Group Assignmen

    🔹 Release Procedure
    ✅ Types: With & Without Classification
    ✅ Define Characteristics, Classes, Release Codes
    ✅ Setup Release Strategies

    🔹 Output Determination
    ✅ Message Types & Schema Configuration

    🔹 Valuation & Account Assignment (MM-FI Integration)
    ✅ Valuation Control & Classes
    ✅ Account Grouping for Movement Types
    ✅ Automatic Posting Configuration

    🔹 Inventory Management
    ✅ Goods Movements & Document Flow
    ✅ Movement Types & Stock Status
    ✅ Plant Parameters & Tolerance Limits
    Goods Receipt / Issue
    ✅ GR for Materials
    ✅ GI to Cost Center
    Stock Transfer & Transfer Posting
    ✅ Intra-Company Transfers (One/Two Step)
    ✅ Quality ↔ Unrestricted ↔ Blocked Stock
    Physical Inventory
    ✅ Inventory Procedures
    ✅ Create / Count / Post Inventory Documents

    🔹 Logistics Invoice Verification (LIV)
    ✅ Number Assignment for Accounting Docs
    ✅ Vendor Tolerance Limits
    ✅ Duplicate Invoice Checks
    Invoice Verification Types
    ✅ Online & Background
    ✅ Document Parking & Release
    ✅ ERS, Consignment, Pipeline Settlement

    🔹 Tax Settings
    ✅ Calculation Procedure & Country Assignment
    ✅ Define Tax Codes for Sales & Purchases

    🔹 Split Valuation
    ✅ Configure Valuation Types
    ✅ PO Creation with Multiple Valuations
    ✅ GR & Stock Status by Valuation

    🔹 Special Procurement Scenarios
    ✅ Subcontracting
    ✅ Vendor Consignment
    ✅ Third Party (MM-SD Integration)
    ✅ Inter-Company STO
    ✅ Scheduling Agreement

    🔹 External Service Management
    ✅ Service Master Creation
    ✅ PO for Services
    ✅ Service Entry Sheet
    ✅ Service Payment Settlement🔹

    Consumption-Based Planning (CBP)
    ✅ Reorder Point Planning

    🔧 LSMW (Legacy System Migration Workbench)
    ✅ Steps: Project, Subproject, Object
    ✅ Mapping & Transformation Rules
    ✅ Exercise: Upload Customer Master with LSMW

    SAP PP – SAP Production Planning Training Academy in Chandigarh

    🔹 SAP Overview

    ✅ Introduction to SAP
    ✅ Navigation
    ✅ Enterprise Structure
    ✅ SAP Implementation Road Map

    🔹 Supply Chain Management Overview

    ✅ Order Controlled Production
     ▫ With Production Order
     ▫ With Process Order
    ✅ Repetitive Manufacturing

    🔹 Planning Strategies

    ✅ Make-to-Stock Production
    ✅ Make-to-Order Production

    🔹 Master Data

    ✅ Material Master
    ✅ BOM Management
    ✅ Work Center
    ✅ Routing
    ✅ Production Version
    ✅ Backflushing
    ✅ Task List

    🔹 Capacity Planning

    ✅ Available Capacity
    ✅ Capacity Requirement
    ✅ Capacity Evaluations
    ✅ Capacity Leveling

    🔹 Production Planning

    ✅ Overview
    ✅ Demand Management
    ✅ MRP Run
    ✅ Processing MRP Results
    ✅ Planned Orders

    🔹 Integration with MM / SD / QM / FICO

    ✅ Overview
    ✅ Material Transfers
    ✅ Movement Types
    ✅ Purchase Indents
    ✅ Goods Issue
    ✅ Product Cost Calculation
    ✅ Inspections

    🔹 Production Orders

    ✅ Overview
    ✅ Order Structure & Processing
    ✅ Order Creation / Change
    ✅ Order Release
    ✅ Material Staging
    ✅ Order Control
    ✅ Confirmation
    ✅ Goods Receipt
    ✅ Order Archiving & Deletion
    ✅ Technical Confirmation
    ✅ Order Settlement
    ✅ Rework Orders
    ✅ User Status
    ✅ Subcontracting

    🔹 Costing (Order Wise Costing)

    ✅ Activity Costs
    ✅ Material Costs
    ✅ Overheads Costs

    🔹 Batch Management

    ✅ Classification
    ✅ Batch Creation
    ✅ Batch Determination
    ✅ Goods Movement
    ✅ Goods Receipt
    ✅ Automatic / Manual Batch Creation

    🔹 Important Configurations

    ✅ MRP Plant Parameters
    ✅ Number Ranges
    ✅ Order Types & Dependent Parameters
    ✅ Scheduling Parameters
    ✅ Availability Checking
    ✅ Confirmation Parameters
    ✅ Material Master, BOM
    ✅ Work Center, Routing
    ✅ Units of Measure
    ✅ Shelf Life Expiry
    ✅ Sales & Operational Planning
    ✅ Lot Sizes in MRP


  •   Call: +91-7888919083


 Call: +91-7888919083



SAP – HR /HCM -SAP Human Capital Management Training Academy in Chandigarh

COURSE CONTENT

🔹 Introduction to SAP
✅ Introduction to ERP

  • Concept of Enterprise Resource Planning
  • Benefits of ERP in business processes
  • Role of ERP in Human Resource Management

✅ Overview of SAP

  • What is SAP?
  • Importance of SAP in industries
  • Basic navigation and user interface

✅ SAP Modules at a Glance

  • FI/CO (Finance & Controlling)
  • MM (Materials Management)
  • SD (Sales & Distribution)
  • PP (Production Planning)
  • HCM (Human Capital Management)

🔹 Enterprise Structures
✅ Enterprise Structure

  • Define Company & Company Code
  • Create Personnel Area & Subarea
  • Role of Enterprise Structure in HCM

✅ Personnel Structure

  • Define Employee Groups
  • Define Employee Subgroups
  • Control features in Payroll & Time Management

✅ Organizational Structure

  • Create Organizational Units
  • Define Jobs & Positions
  • Maintain Reporting Hierarchies

✅ Pay Scale Structure

  • Configure Pay Scale Type & Area
  • Assign Pay Scale Group & Levels
  • Link Pay Scale to Wage Types & Payroll

✅ Packed Decimals

  • SAP Data Types introduction
  • Usage of Packed Decimals in Payroll
  • Importance in Time & Salary Calculations

🔹 Organizational Management (OM)
✅ Organization & Staffing

  • Create & maintain organizational units
  • Assign employees to positions

✅ General Structure

  • Define relationships between objects
  • Maintain reporting lines

✅ Matrix

  • Set up matrix structures for dual reporting
  • Manage flexible team structures

✅ Expert Mode

  • Advanced maintenance of OM data
  • Overview of transaction codes

✅ Simple Maintenance

  • Quick creation of org units & jobs
  • Easy navigation for beginners

✅ Organizational Plan

  • Design a full organizational hierarchy
  • Practical case studies

✅ Object Types and Explanations

  • Organizational Unit, Job, Position, Person
  • Relationships among objects

🔹 Recruitment
✅ Maintain Advertisements

  • Job posting creation in SAP
  • Advertisement validity period

✅ Maintain Applicant Structures

  • Define applicant groups & ranges
  • Maintain applicant status

✅ Maintain Applicant Data

  • Enter candidate details
  • Manage applicant documents

✅ Selection Process

  • Screening and shortlisting
  • Interview scheduling and results entry

✅ Personnel Actions in Recruitment

  • Hiring process steps
  • Applicant data transfer

✅ Hire / Reject a Person

  • Hire selected candidates
  • Reject unsuitable applicants

🔹 Personnel Administration (PA)
✅ Personnel Actions in Administration

  • Hire, transfer, promotion, termination
  • Record keeping in SAP

✅ Hire a Person

  • End-to-end hiring procedure
  • Assign employee number and master data

✅ User Group and Info Groups

  • Role of user groups in PA
  • Info groups for streamlined actions

✅ Info Types

  • Personal Data, Address, Payroll, Bank Details
  • Time-related info types

✅ Maintain Employee Master Data

  • Update employee records
  • View & change info types

🔹 Time Management (TM)
✅ Assign Working Timings to Employees

  • Define daily work schedules
  • Assign public holidays & weekly offs

✅ Break Schedules

  • Define meal breaks & rest periods
  • Assign break rules to work schedules

✅ Work Schedules

  • Daily, weekly & monthly schedules
  • Rotational shift planning

✅ Time Data Recording & Administration

  • Attendance & absence recording
  • Overtime management

✅ Time Management Info Types

  • Absences, Attendance, Substitutions
  • Time quotas & leave management

🔹 Payroll
✅ Payroll Components Overview

  • Structure of payroll system
  • Payroll area, control record

✅ SAP R/3 Payroll Basics

  • Payroll flow & steps
  • Key payroll concepts

✅ Wage Types

  • Basic salary, allowances, deductions
  • Custom wage type creation

✅ Valuation Methods

  • Processing wage types
  • Different valuation rules

✅ Payroll Run

  • Execute payroll for employees
  • Simulation vs live run

✅ Payroll Driver

  • Control payroll execution
  • Error handling in payroll

✅ Schemas Configuration (Overview)

  • Introduction to payroll schemas
  • Understanding rules & functions

🔹 Personnel Development (PD)
✅ Personnel Development Overview

  • Concept of employee growth in SAP
  • Benefits of PD for organizations

✅ Profile Match Up

  • Match employee qualifications to job needs
  • Gap analysis

✅ Applicant Comparison

  • Compare candidates for recruitment
  • Evaluate best fit

✅ Career & Succession Planning

  • Define career paths
  • Succession plans for key roles

✅ Qualifications

  • Create qualifications catalog
  • Assign qualifications to employees

🔹 Training & Event Management
✅ Overview of T&E Management

  • Importance of training in SAP
  • T&E module features

✅ Business Event Preparation

  • Define training requirements
  • Prepare training events

✅ Business Event Catalog

  • Create & maintain catalog of events
  • Categorize events by type

✅ Day-to-Day Activities

  • Assign employees to events
  • Manage attendance & results

✅ Recurring Activities

  • Plan repeated training sessions
  • Automate recurring events

🔹 ASAP Methodology
✅ ASAP Project Phases

  • Project Preparation
  • Business Blueprint
  • Realization
  • Final Preparation
  • Go-Live & Support

✅ Integration with Other Modules

  • HCM with FI/CO, MM, SD
  • Data flow between modules

✅ Business Scenarios

  • Real-time HR use cases
  • Hands-on practice exercises

 Call: +91-7888919083

Book My Demo

SCO – 85-86, 4th Floor, Sector 34-A Chandigarh -160022

204 , 2nd Floor , Devine World , Sector 115 , Behind Zudio Showroom ,Mohali 140307

at
Labels: , , , ,
Location: Chandigarh, India

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

Financial Modeling Training in Chandigarh -9988113578

   Financial Modeling & Valuation Analyst Course in Chandigarh, Mohali Duration: 3 Months Mode: Online/Offline (Chandigarh an...