Introduction to Excel

(इंट्रोडक्शन टू एक्सेल )

Understanding the most widely used business software in the world

20 Modules

Practice Excel Sheets

Certificate

1999

1790

WHY LABOUR LAW ADVISOR ACADEMY?​

  • Start your own consultancy
  • Certificate by labour law academy
  • Learn at your convenience
  • Career Growth
  • Hands on training, excel worksheets
  • 1st Practical course on payroll

1st Practical course on payroll

Taught by leading payroll consultant

Video lectures, Notes & Practice Sheet

Bilingual Hindi + English

24×7 access for your convenience

Complete calculation of 10+ acts

PF, ESI, TDS, PT, LWF, Arrear

Bonus, Gratuity, Over Time, Leave

Fill this form to get a call back from our representative

Why Learn Payroll Processing

Example for this course “ As long as there will be companies, there will be employees and salaries.” So payroll processing is a must. Payroll processing in india, is a fast-growing field. Indian payroll and it’s calculation is quite complex. In India Labour laws & rules change from state to state. 100s allowances are given. So if someone has a good command on concepts, they have a great career. 

At present, there are no practical and concise courses available that teach Payroll Processing in a simple manner. Hence we have designed the first of its kind practical certificate course “A to Z of payroll processing”. This course starts from concepts, then teaches calculation of 10+ acts and finally helps you in processing full payroll with practical examples and practice sheets. Click on enroll now and start learning wherever you are.

Instructor

Sambhav Jain

Mr. Sambhav Jain

Co-Founder of YouTube Channels Labour Law Advisor

  • Management Consultant worked with fortune 500 companies
  • Investment Consultant
  • Management Consultant
  • IIT Bombay (Btech+Mtech)

Course Structure

  • Build your Spread sheet from scratch
  • All Basic Ms-Excel formulas which can be helpful
  • Creating and maintaining your database systematically
  • Learning how to use Ms-Excel and increase your work efficency
Topic # Sub Topic What will be covered

Intro

1
Introduction
Why Excel

Formatting

2
Text Formatting
Font, alignment, table making, spell check, line removal
3
Sheet Formatting
Insert, delete rows column, cell format
4
Conditional formatting
High to low, low to high, threshold, 3 split
5
Sort filter and find
Sort method - range, equal to color

Computation

6
Basic arithmetic functions
What is formula ,addition, substantiation, multiplication, division, count
7
Cell referencing, dragging
Floating, fixed, row/column floating, across sheets
8
Logical statement
IF, and, or, nested ifs
9
Advance arithmetic functions
Sumif and countif
10
Special functions
Round, days related functions

Data presentation

11
Charts 1
Bar chart, line chart
12
Charts 2
Pie chart, scatter chart
13
Pivot table 1
Why do we need pivot table
14
Pivot table 2
How to make pivot table

Data consolidation

15
Advance copy pasting
Format, formula, column width, value
16
Data tools 1
Duplicate removal
17
Data tools 2
Text to column
18
Vlookup
Why do we need Vlookup, how to use it?

Popular Courses

लक्ष्य UPSC EPFO 2020 Mock Tests

33% OFF
  • 599
  • 399

1st Comprehensive Sectional Mock Test Series On Labour Laws, IR & Social Security

  • 300 Questions
  • Multilingual - Hindi & English
  • Certificate

A to Z of Payroll Processing

50% OFF
  • 12990
  • 11690

Practical course on payroll, inclusive of calculation of 10+ acts such as PF, ES, TDS

  • 30 Modules
  • Practice Excel Sheets
  • Certificate

Introduction to Excel

50% OFF
  • 1790
  • 990

Understanding the most widely used business software in the world

  • 18 Modules + Extra
  • Practice Excel Sheets
  • Certificate

Professional Tax Maharashtra

50% OFF
  • 1999
  • 1799

Practical course on Professional Tax Maharashtra, inclusive of calculations

  • 20 Modules
  • Practice Excel Sheets
  • Certificate

Who should take this course?

  • This course is ideal for everyone who wants to learn Ms-Excel
  • Increase your chances of promotion, or a better paying job 
1
Course
+
Videos
+
Active Users

FAQ

Anyone can do this course to brush up Excel skills, this is the level one of Excel Training.
HR. Accountant, students, consultants. With this course, you can create a base for starting your payroll consultancy.

Basic of Excel will be taught in this course. This is the level 1 for your excel learning.

No Ms-Excel software will not be provided by us. We will only teach you have to arrange your own Ms-Excel software.

The course will be of around 20 lectures. 

The course can be watched at anytime till 1 year on your mobile at the time of convenience.

No due to security purpose downloading option is not available.

Due to Corona, we are running this course at 50% off. If you need more discount please contact support.

Sambhav Jain, co-founder of labour law advisor and Management consultant who has worked with fortune 500 companies will teach and share is experiences in this course.

LPTI Vision and Mission

LLA Profession Training Institute or LPTI is started with a vision to impart practical skill based training among indian professionals. The current education system does not provide in-depth practical training in skills needed in a job.With LLA course professionals can get hands-on practical training as well as required conceptual knowledge. That too in a concise and simple manner. Founders of LPTI have consulted 1000+ companies and have gained one million+ following online, Four point mantra of LPTI is:-

      • Practical Skill based training 
      • Industry expert trainers 
      • Affordable Pricing 
      • Trust and Transparency

Our Popular Courses

Processing Section

10 Modules - Here we combine learning from the first 2 sections to process actual payrolls. Also we will discuss various reports in brief.

Processing Section

10 Modules - Here we combine learning from the first 2 sections to process actual payrolls. Also we will discuss various reports in brief.

About Course

Why Labour Law Advisor Academy?

  • Build your Spread sheet from scratch
  • All Basic Ms-Excel formulas which can be helpful
  • Creating and maintaining your database systematically
  • Learning how to use Ms-Excel and increase your work efficency