Sohan Singh Smriti Kaushal Vikas Kendra

Laghu Udyog Bharati

Course Catalog

Accounting & Finance

Develop financial expertise with courses on GST compliance , advanced Excel reporting, and bookkeeping for MSMEs.

LUB ACCOUNTANT COURSE

We are pleased to present this course for an Advanced Excel, PowerPoint and Tally Training Course. In today's fast-paced corporate enviroment, proficiency in Excel and Tally are essential for effective accounting,data management and analysis. Our Comprehensive training program aims to equip your team with advanced Excel,Tally and PPT techniques to enhance their productivity and efficiency.

Course Structure

Detailed Course Content

Basic of Accounting(40 Hours)
Excel Training (40 Hours)
Tally Accounting (140 Hours)
Word and PowerPoint Presentation (20 Hours)

Training Overview

Duration: 240Hours Or 3 Months Training
Frequency: Sessions(Daily Monday to Friday) 4hours each
Mode: On-Site
Batch Size: 30 Max No of Batches(2) Total 60 Students

Fee Structure

Registration Fee

One-time, Non-Refundable

INR 500

Course Fee

Refundable Course Fee

INR 1,100

Refundable Fee

Achieve a 90% DISCOUNT by maintaining:

Full Course Attendance
Completion of All Assignments

Download Brochure

Download Brouchure

Accounting

Microsoft Excel

Tally

Word & PowerPoint

Basic of Accounting and Taxation

Comprehensive Training Program with 5 Modules (40 Hours)

Module 1: Introduction to Accounting

▼

Section 01 :Overview of Accounting

Definition and importance
Users of accounting information

Section 02 :Types of Accounting

Financial,managerial and cost accounting

Section 03 :Accounting Terminology

Key Terms and concepts

3 Sections Estimated time: 5 hours

Module 02 : Accounting Principles and Concepts

▼

Section 01 : Fundamental Accounting Principles

The accounting equation
Double-entry System

Section 02 :Accounting Concepts

Accrual vs cash basis
Going concern, consistency and prudence

2 Sections Estimated time: 10 hours

Module 3 : Financial Statements

▼

Section 01 : Balance Sheet

Assets, liabilities and equity

Section 02 : Income Statement

Revenue, expenses and profit

Section 03 : Cash Flow Statement

Operating, investing and financing activities

3 Sections Estimated time: 10 hours

Module 4 : Recording Transactions

▼

Section 01 : Journals and Ledgers

Recording and Posting Transactions

Section 02 : Trial Balance

preparing and Understanding

Section 03 : Adjusting Entries

Accruals and deferrals

3 Sections Estimated time: 10 hours

Module 5 : Final Accounts Preparation

▼

Section 01 : Closing Entries

preparing for the new accounting period

Section 02 : Preparing Final Accounts

From trial Balance to financial statements

3 Sections Estimated time: 5 hours

Excel Course Content Basic Level

Comprehensive Training Program with 5 Modules (20 Hours)

Module 1: Introduction to Excel

▼

Section 01 : Introduction to Excel interface
Section 02 : Basic nvigation and data entry
Section 03 : Formatting cells and data
Section 04 : Managing worksheets and workbooks

4 Sections Estimated time: 4 hours

Module 02 : Data Management and Analysis

▼

Section 01 : Sorting and filtering data
Section 02 : Using AutoFill and Flash Fill
Section 03 : Subtotal and database functions
Section 04 : Introduction to Excel tables

4 Sections Estimated time: 4 hours

Module 3 : Conditionsl Formatting and Charts

▼

Section 01 : Applying conditional formatting rules
Section 02 : Creating and customizing charts
Section 03 : Sparklines and trendlines
Section 04 : Using slicers and timelines

4 Sections Estimated time: 4 hours

Module 4 : Advanced Data Analysis Tools

▼

Section 01 : Using Data Validation
Section 02 : Using Goal Seek and Solver
Section 03 : Performing What- If analysis
Section 04 : Using the Analysis ToolPak

4 Sections Estimated time: 4 hours

Module 5 : Collaboration and Sharing

▼

Section 01 : Protecting worksheets and workbooks
Section 02 : Sharing workbooks and Collaboration tools
Section 03 : Tracking changes and comments
Section 04 : Excel online and co-authoring features

4 Sections Estimated time: 4 hours

Excel Course Content Advanced Level

Comprehensive Training Program with 5 Modules (20 Hours)

Module 1: Advanced Functions and Formulas

▼

Section 01 : Logical functions (IF, AND, OR, NOT)
Section 02 : Lookup and reference functions (VLOOKUP, HLOOKUP, INDEX, MATCH)
Section 03 : Text functions (LEFT, RIGHT MID, CONCATENATE)
Section 04 : Date and Time functions (DATE, TOModule, MONTH, YEAR)
Section 05 : Array formulas and advanced formula techniques

5 Sections Estimated time: 4 hours

Module 02 : Pivot Tables and Power Query

▼

Section 01 : Creating Pivot Tables and Pivot Charts
Section 02 : Customizing Pivot Table fields and layouts
Section 03 : Advanced Pivot Table techniques
Section 04 : Introduction to Power Query
Section 05 : Importing, transformimg and combining data

5 Sections Estimated time: 4 hours

Module 3 : Data Analysis with Excel

▼

Section 01 : Advanced data analysis with Excel
Section 02 : What-If analysis and Goal Seek
Section 03 : Scenario Manager and Solver
Section 04 : Analyzing data with statistical functions
Section 05 : Using Excel for regression analysis and forecasting

5 Sections Estimated time: 4 hours

Module 4 : Macros and Automation

▼

Section 01 : Recording and editing macros
Section 02 : Introduction to VBA (Visual Basic for Applications)
Section 03 : Writing VBA code for Automation
Section 04 : Creating custome functions
Section 05 : Integrating macros and automation into Excel workflows

5 Sections Estimated time: 4 hours

Module 5 : Excel Tips and Tricks

▼

Section 01 : Advnaced formatting techniques
Section 02 : Keyboard shortcuts for efficiency
Section 03 : Troubleshooting common Excel issues
Section 04 : Optimizing Excel performance

4 Sections Estimated time: 4 hours

TALLY

Comprehensive Training Program with 6 Modules (140 Hours)

Module 1: Introduction to Tally

▼

Section 01 : Overview of Tally Software

Features and benefits

Section 02 : Installation and Setup

Configuring Tally for first use

2 Sections Estimated time: 10 hours

Module 02 : Creating and Managing Accounts

▼

Section 01 : Ledger Creation

Setting up and managing ledgers

Section 02 : Group Creation and Management

Organizing accounts into groups

2 Sections Estimated time: 30 hours

Module 3 : Voucher Entry and Transactions (40 Hours)

▼

Section 01 : Types of Vouchers

Sales, Purchase, Payment, Receipt

Section 02 : Recording Transactions

Day-to-Day transaction management

2 Sections Estimated time: 40 hours

Module 4 : Inventory management

▼

Section 01 : Stock Groups and Categories

Organizing Inventory

Section 02 : Inventory Vouchers

Managing Stock movements

2 Sections Estimated time: 20 hours

Module 5 : Payroll and taxation

▼

Section 01 : Payroll Setup

Employee recrods and Salary Processing

Section 02 : GST and other Tax Configurations

Setting up and managing Taxes

2 Sections Estimated time: 20 hours

Module 6 : Advanced Features and Reporting

▼

Section 01 : Generating Reports

Financial, Inventory, and statutory Reports

Section 02 : Data Security and Backup

Ensuring data integrity and safety

2 Sections Estimated time: 20 hours

WORD AND POWER POINT

Comprehensive Training Program with 2 Modules (20 Hours)

Module 1: Microsoft word basics

▼

Section 01 : Document Creation and Formatting

Creating, editing and formatting documents

Section 02 : Using Templates and styles

Applying and customizing styles

2 Sections Estimated time: 10 hours

Module 02 : Microsoft PowerPoint basics

▼

Section 01 : Creating Presentations

Slide Creation layout

Section 02 : Design and Animation Features

Applying themes and transitions
Section 03 : Delivering Presentations

Tips for effective Presentation delivery

2 Sections Estimated time: 30 hours

Requirements

Laptop or computer for each participant with access to Microsoft Excel
A positive learning attitude and active participation from all participants

We are keen to discuss this proposal further and address any questions.

Batch Starting

7th

April 2025

Mon-Fri, 11:00 AM - 1:00 PM

Book Your Seat Now

₹ 1100 /course

The Laghu Udyog Bharati Skill Development Centre is a multi-skilling centers. These Centre's have state of the art labs with spacious classrooms. Equipped with modern amenities, these centres are the destination of our innovation activities. New courses, processes, capabilities are piloted in these centres.

Get In Touch

Near Bombay Hospital, 200, Feet Mahal Road, Sitapura Industrial Area, Sitapura, Jaipur, Shri Kishanpura, Rajasthan 302022

+91-9829068865

+91-7425865190

info@skillhub.com

rajasthan.lubindia@gmail.com

Our Courses

Apparel & Fashion Account & Finance Digital Skill Artificial Intelligence Entrepreneurship Development Center Handicraft