TALLY PRIME- VOLUME 01

Chapter 1: Introduction

• Introduction to Tally Prime
• Salient Features of Tally Prime
• Installation of Tally Prime
• Getting Started with Tally Prime
• Creation / Alteration / Deletion of a Company
• Gateway of Tally Prime
• Accounting Masters Creation
• Accounting of a simple trading accounting without GST
• Transaction Recording (without GST)
• Introduction to Goods and Service Tax (GST)

Chapter 2: Masters and Ledgers

• Ledger Creation
• Ledger Alteration / Deletion
• Single Ledger Creation
• Multiple Ledger Creation
• Group Creation
• Group Alteration / Deletion

Chapter 3: Voucher Entries

• Journal Voucher (F7)
• Payment Voucher (F5) – Double Entry Mode
• Receipt Voucher (F6) – Double Entry Mode
• Purchase Voucher (F9) – Single Entry Mode
• Sales Voucher (F8) – Single Entry Mode

Chapter 4: Statements and Reports

• Trial Balance in Tally
• Printing Trial Balance
• Balance Sheet
• Printing Balance Sheet
• Vertical Trading, Profit and Loss A/c
• Printing Trading, Profit and Loss A/c – Columnar
• Tally Prime – Volume 01
• Printing Trading, Profit and Loss A/c – Vertical

Chapter 5: GST and Taxation

• Self-Assessment Test – GST
• Assignment – All Prime with GST
• Enabling Company Features – Enabling GST
• Ledger Creation for GST
• Ledger Creation for Taxes related to GST
• Passing Sales Entry with GST
• Passing Purchase Entry with GST
• Passing Debit Note Entry
• Passing Credit Note Entry
• Printing GST Invoices

Chapter 6: Financial Statements

• Profit & Loss A/c
• Balance Sheet
• Financial Statements Printing Reports

Chapter 7: Books of Accounts

• Cash Book
• Bank Book
• Ledger
• Day Book
• Journal Register
• Purchase Register
• Sales Register
• Debit Note Register
• Credit Note Register

Chapter 8: Statement of Accounts

• Outstanding Report
• Bills Receivable
• Bills Payable
• E-mail from Tally
• Statement of Accounts

Chapter 9: GST Reports

• GSTR-1
• GSTR-2
• GSTR-3B

Chapter 10: Assignments & Self Tests

• Self-Assessment Test – 2
• Assignment – 2
• Self-Assessment Test – 3
• Assignment – 3
• Self-Assessment Test – 4
• Assignment – 4
• Do it Yourself and Generate Reports
• Tally Prime Menu at a Glance
• Tally Prime Gateway of Tally, Right Hand Button Bar of
• Vouchers & Reports

Chapter 11: Company Features & Banking

• Company Features
• Configuration
• Creating Company with Opening Balances (Already Existing
• Company)
• Automatic Cheque Management
• Bank Reconciliation
• Petty Cash Book Transactions in Tally
• Viewing Different Books and Generating Monthly Reports

Chapter 12: Final Assessment

• Do it Yourself
• Self-Assessment Test – 5

Tally Prime – Volume II

Chapter 1: Inventory Management

• Inventory (Stock of Goods)
• Inventory Reports / Assets with GST
• Managing Inventory
• Stock Groups
• Stock Categories
• Units of Measure
• Ledger Creation – Purchases, Sales and GST

Chapter 2: Voucher Entries with Inventory

• Purchase Voucher
• Sales Voucher
• Purchase Return (Debit Note)
• Sales Return (Credit Note)
• Purchase Order
• Sales Order
• Debit Note for Return Outward
• Credit Note for Return Inward

Chapter 3: Advanced Voucher Features

• Create Voucher Type – Retail Sales
• Create Voucher Type – Purchase Memo
• Create Voucher Type – Sales Memo
• Create Voucher Type – Debit Note with Company Logo
• Invoicing with Multiple Address

Chapter 4: GST with Inventory

• E-Way Bill Services
• Batch Wise Details
• Different Actual & Billed Quantities
• Additional Cost of Purchases
• User Discount Column in Invoices
• Multiple Price Levels & Price Lists

Chapter 5: Bills, Interest and Cost Centers

• Bills Receivable
• Bills Payable
• Interest Calculation
• Voucher Class for Automatic Interest Figures – Pickup in
• Credit/Debit Note
• Cost Center
• Cheque Printing

Chapter 6: Insurance and Orders

• Payment of Insurance Premium with GST (Claiming ITC)
• Order Processing
• Purchase Order
• Sales Order

Chapter 7: Pending Bills Reports

• Rejection Inward
• Rejection Outward
• Viewing Reports of Purchase Bills Pending
• Viewing Reports of Sales Bills Pending

Chapter 8: GST Reports & Statements

• GST Reports – GSTR-3B, GSTR-1 and GSTR-2
• Generating & Printing Reports
• General Statements
• Trial Balance
• Profit & Loss A/c
• Balance Sheet

Chapter 9: Books & Registers

• Bank Book
• Cash Book
• Group Summary
• Ratio Analysis
• Journal Register
• Sales Register
• Purchase Register
• Debit Note Register
• Credit Note Register

Chapter 10: Statement of Accounts

• Day Book
• Outstanding Feature
• Bills Payable
• Bills Receivable
• Ageing Analysis
• Cost Centre Report
• List of Accounts

Chapter 11: Inventory Books & Registers

• Stock Item
• Stock Group
• Stock Category Summary
• Stock Summary
• Stock Transfer (Stock Journal)
• Purchase Order Book
• Sales Order Book
• Debit Note Register
• Credit Note Register
• Rejections In Register
• Rejections Out Register
• Stock Transfer Journal Register
• Physical Stock Register

Chapter 12: Exporting, Security & Tally Vault

• Export and Import of Data
• Export of Excel
• Export of Word
• Export of PDF
• E-mail Reports
• Printing Reports
• Cash Flow Statement
• Fund Flow Statement

Chapter 13: Tally Vault & Control

• Tally Vault
• Security Control
• Users and Password
• Security Levels (User Roles)

Chapter 14: Manufacturing and Stock Management

• Bill of Material (BOM)
• Creation of BOM for Purchases, Sales, GST, Parties and
• Expenses
• Creation of Godowns
• Creation of Stock Items
• Create Unit of Measure (UOM)
• Create Multiple UOM
• Create Stock Group
• Create Stock Category

Chapter 15: Advanced Stock & Voucher Classes

• Voucher Class for Material Transfer
• Manufacturing Journal Voucher
• Altering Stock Journal Voucher
• Entering Stock Journal Voucher
• Sales Voucher with Voucher Class
• Entering Sales Voucher with Voucher Class
• Cost Estimation

Chapter 16: Tax Deduction & Tally Services

• Tax Deducted at Source (TDS)
• TDS Reports
• Printing TDS Challan
• form 26Q
• Form 27Q
• Tally software services ( TSS ) , Renew TSS

TALLY PRIME - VOLUME III

Chapter 1: Payroll and Employee Management

• Enable Payroll and its Features
• Employee Master
• Employees Group
• Payroll Masters
• Pay Heads – Earning Type
• Pay Heads – Deduction Type
• Attendance / Production Type

Chapter 2: Payroll Vouchers

• Payroll Voucher
• Attendance Voucher
• Salary Details
• Generating & Viewing Payroll Reports

Chapter 3: GST Advanced Features

• GST in Tally Prime
• Goods and Services Tax
• GST at Company Level
• Defining GST at Stock Group Level
• Defining GST at Stock Item Level

Chapter 4: GST Advanced Transactions

• B2C (Large) Intra-State Sales
• B2C (Small)
• B2B (Large) Inter-State Sales

Chapter 5: Letters and Currencies

• Reminder Letters
• Confirmation Letters
• Multiple Currencies
• Budget

Chapter 7: Inventory & Stock Valuation

• Scenario
• View Optional Voucher Register
• Stock Valuation
• Physical Stock
• Increase and Decrease in Stock Value

Chapter 8: Data Management

• Import Data
• Exporting Reports Data
• Migration of Data from Old Versions to Tally Prime

Chapter 9 : Final Section

• Self Assessment

Power BI

Chapter 1: Introduction to Power BI

• Overview of Business Intelligence
• Introduction to Power BI
• Power BI Components (Desktop, Service, Mobile)
• Power BI Architecture
• Installing and Setting up Power BI Desktop

Chapter 2: Getting Started

• Power BI Interface Overview
• Data Sources and Connections
• Importing Data (Excel, CSV, SQL, Web, APIs)
• DirectQuery vs Import Mode
• Power BI Dataflows

Chapter 3: Data Transformation with Power Query

• Introduction to Power Query Editor
• Data Cleaning and Transformation
• Merging and Appending Queries
• Creating Calculated Columns
• Handling Nulls and Errors
• Advanced Query Editor (M Language Basics)

Chapter 4: Data Modeling

• Understanding Data Models
• Relationships Between Tables
• Star Schema vs Snowflake Schema
• Creating Hierarchies
• Role-playing Dimensions
• Managing Model Performance

Chapter 5: DAX (Data Analysis Expressions)

• Introduction to DAX
• Calculated Columns vs Measures
• Common DAX Functions (SUM, AVERAGE, COUNT)
• Time Intelligence Functions (YTD, MTD, QTD)
• Filter Functions (CALCULATE, FILTER, ALL)
• Advanced DAX (Switch, Variables, Iterators)

Chapter 6: Visualizations

• Introduction to Visuals in Power BI
• Working with Tables and Matrices
• Charts: Bar, Column, Line, Area
• Advanced Visuals: Waterfall, Funnel, Gauge, KPI
• Maps and Geo-Spatial Visuals
• Custom Visuals from Marketplace
• Formatting Visuals and Themes

Chapter 7: Reports and Dashboards

• Building Interactive Reports
• Drill-Down and Drill-Through
• Bookmarks and Selections
• Report Navigation and Buttons
• Creating Dashboards in Power BI Service
• Q&A and Natural Language Queries

Chapter 8: Sharing and Collaboration

• Publishing Reports to Power BI Service
• Workspaces and Apps
• Sharing Dashboards with Users
• Row-Level Security (RLS)
• Collaboration with Teams and SharePoint

Chapter 9: Advanced Features

• Power BI and Excel Integration
• Power BI with SQL and Azure
• AI and Machine Learning Features in Power BI
• Paginated Reports
• Data Refresh and Gateway Setup
• Performance Optimization

Chapter 10: Administration and Governance

• Power BI Admin Portal
• User Roles and Permissions
• Data Security Best Practices
• Monitoring Usage and Auditing
• Power BI Premium vs Pro vs Free

Chapter 11: Real-World Projects

• Sales and Revenue Dashboard
• HR Analytics Dashboard
• Financial Reporting Dashboard
• Customer Insights Dashboard
• Operations & Supply Chain Dashboard

Chapter 12 : Final Section

• Tips and best practices
• Power BI Updates and Roadmap
• Self assessment and certification Prep

STRUCTURED SQL

Chapter 1: Introduction to Databases and SQL

• What is a Database?
• Types of Databases (Relational vs Non-Relational)
• Introduction to SQL
• SQL Syntax and Rules
• Setting up SQL Environment (MySQL, SQL Server, Oracle,
• PostgreSQL)

Chapter 2: Basic SQL Commands

• CREATE, ALTER, DROP Database
• CREATE, ALTER, DROP Table
• Data Types in SQL
• Inserting Data (INSERT INTO)
• Viewing Data (SELECT)
• Updating Data (UPDATE)
• Deleting Data (DELETE)

Chapter 3: Filtering and Sorting Data

• WHERE Clause
• Logical Operators (AND, OR, NOT)
• Comparison Operators (=, <>, >, <, etc.)
• BETWEEN, IN, LIKE, IS NULL
• ORDER BY (Sorting Data)
• LIMIT / TOP / FETCH

Chapter 4: Functions in SQL

• Aggregate Functions (COUNT, SUM, AVG, MIN, MAX)
• Scalar Functions (LEN, UPPER, LOWER, ROUND)
• Date and Time Functions
• String Functions (SUBSTRING, CONCAT, TRIM)
• Mathematical functions

Chapter 5: Joins and Relationships

• Introduction to Joins
• INNER JOIN
• LEFT JOIN (OUTER JOIN)
• RIGHT JOIN
• FULL OUTER JOIN
• CROSS JOIN
• Self Joins
• Using Joins with Aggregate Functions

Chapter 6: Subqueries and Set Operations

• Introduction to Subqueries
• Single-Row Subqueries
• Multi-Row Subqueries (ANY, ALL, IN)
• Correlated Subqueries
• UNION and UNION ALL
• INTERSECT and EXCEL

Chapter 7: Constraints and Keys

• Primary Key and Foreign Key
• Unique Constraint
• Not Null Constraint
• Default Constraint
• Check Constraint
• Referential Integrity

Chapter 8: Advanced SQL

• Views (CREATE, ALTER, DROP)
• Indexes (Clustered and Non-Clustered)
• Stored Procedures
• Functions (User Defined)
• Triggers
• Transactions (BEGIN, COMMIT, ROLLBACK)
• Error Handling in SQL

Chapter 9: Performance and Optimization

• Query Execution Plan
• Normalization (1NF, 2NF, 3NF, BCNF)
• Denormalization
• Index Optimization
• Best Practices for Writing Queries

Chapter 10: SQL with Data Analytics

• Case Statements
• Pivot and Unpivot Data
• Common Table Expressions (CTE)
• Window Functions (ROW_NUMBER, RANK, DENSE_RANK)
• Grouping Sets, Rollup, Cube
• Temporary Tables and Table Variables

Chapter 11: SQL with Big Data and BI

• SQL with Excel and Power BI
• SQL with Python/R Integration
• SQL in Data Warehousing
• SQL with Cloud (Azure SQL, AWS RDS, Google BigQuery)

Chapter 12: Projects and Practice

• HR Management Database
• Sales and Inventory Database
• Library Management System
• Banking and Finance Case Study
• E-commerce Data Analytics

Chapter 13: Final Section

• SQL Best Practices
• Common Interview Questions
• SQL Certifications (Oracle, Microsoft, IBM, etc.)
• Self-Assessment & Exercises

ADVANCE EXCEL

Chapter 1: Introduction to Advanced Excel

• Overview of Excel Interface
• Workbook and Worksheet Management
• Data Entry Tips and Shortcuts
• Formatting Cells, Rows, and Columns
• Conditional Formatting

Chapter 2: Working with Functions and Formulas

• Cell References (Relative, Absolute, Mixed)
• Text Functions (LEFT, RIGHT, MID, LEN, TRIM, CONCATENATE,
• TEXTJOIN)
• Logical Functions (IF, AND, OR, NOT, IFERROR)
• Lookup Functions (VLOOKUP, HLOOKUP, XLOOKUP, INDEX,
• MATCH)
• Date & Time Functions (TODAY, NOW, DATEDIF, EOMONTH)
• Math & Statistical Functions (ROUND, SUMIF, COUNTIF,

AVERAGEIF)

Chapter 3: Data Management Tools

• Data Validation (Drop-down Lists, Input Messages)
• Sorting and Filtering Data
• Advanced Filter Options
• Removing Duplicates
• Flash Fill and AutoFill
• Subtotals

Chapter 4: Data Analysis in Excel

• What-If Analysis (Goal Seek, Scenario Manager)
• Data Tables (One-variable & Two-variable)
• PivotTables – Creating and Customizing
• PivotCharts – Linking with PivotTables
• Grouping and Summarizing Data in PivotTables
• Slicers and Timelines in PivotTables

Chapter 5: Charts and Visualization

• Creating Different Types of Charts (Bar, Line, Pie, Column)
• Combo Charts
• Sparklines
• Dynamic Charts
• Chart Formatting and Design

Chapter 6: Advanced Formula Techniques

• Nested IF Functions
• Array Formulas (Introduction)
• Using Named Ranges in Formulas
• Error Checking and Troubleshooting Formulas

Chapter 7: Productivity Features

• Working with Multiple Worksheets and Workbooks
• Linking Data Between Sheets
• Protecting Worksheets and Workbooks
• Tracking Changes and Comments
• Printing and Page Setup Options

Chapter 8: Data Tools and Reporting

• Consolidating Data
• Using Tables for Structured Data
• Creating Dynamic Reports
• Basic Dashboard Concepts in Excel

Chapter 9: Final Section

• Excel Tips and Shortcuts
• Best Practices in Excel Reporting
• Self-Assessment and Exercises

TABLEAU

Chapter 1: Introduction to Tableau

• Overview of Tableau and its Components
• Tableau Desktop vs Tableau Public
• Understanding Data Connections
• Live vs Extract Connections
• Importing Data from Different Sources

Chapter 2: Working with Data

• Data Types and Fields in Tableau
• Dimensions vs Measures
• Data Pane and Data Interpretation
• Sorting and Filtering Data
• Using Groups, Sets, and Hierarchies
• Data Joins and Blending (Basics)

Chapter 3: Visual Analytics Basics

• Understanding Marks and Shelves
• Creating Basic Charts (Bar, Line, Pie, Scatter)
• Cross Tabs and Highlight Tables
• Dual-Axis and Combined Charts
• Maps and Geographic Visualization (Basics)
• Trend Lines and Forecasts (Simple)

Chapter 4: Calculations in Tableau

• Basic Calculated Fields
• String, Date, and Number Functions
• Conditional Calculations (IF, CASE)
• Table Calculations (Running Total, Percent of Total, Rank)
• Quick Table Calculations

Chapter 5: Organizing and Summarizing Data

• Parameters and Their Uses
• Using Filters and Quick Filters
• Context Filters
• Using Sets and Combined Sets
• Sorting, Grouping, and Binning

Chapter 6: Dashboards and Stories

• Creating Dashboards
• Adding Charts and Objects to Dashboards
• Applying Filters in Dashboards
• Actions (Filter, Highlight, URL Actions)
• Creating Interactive Dashboards
• Building Stories in Tableau

Chapter 7: Formatting and Sharing

• Formatting Worksheets and Dashboards
• Exporting Dashboards (PDF, Image, PowerPoint)
• Publishing to Tableau Public/Server (Basic)
• Best Practices for Dashboard Design

Chapter 8: Productivity Features

• Using Tooltips Effectively
• Custom Colors and Shapes
• Creating Dynamic Titles and Labels
• Saving Custom Views
• Dashboard Performance Tips (Non-technical)

Chapter 9: Final Section

• Real-World Case Studies (Sales, HR, Finance)
• Tableau Tips and Shortcuts
• Self-Assessment and Exercises

AI FOR FINANCIAL ANALYST

• Introduction to AI in Finance (basic idea)
• Free AI Tools for Analysts (ChatGPT, Excel/Google Sheets AI,

Power BI free features)

• Using AI to Summarize Financial Reports
• Using AI for Simple Forecasts (sales, expenses, cash flow)
• Using AI for Market News & Sentiment Insights