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
🔹 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
- Alteration & Deletion of Masters
- ✅ Multi-Master Creation
✅ Recording & Maintaining Accounting Transactions
- Voucher Entry in TallyPrime
✅ 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
✅ 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
Call: +91-7888919083