Get RTI Course for ₹1 Click Here>> >

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 rika nishimura, 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?
    Excel Course

    Popular Courses

    UPSC EPFO  min

    लक्ष्य 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
    Payroll Processing min

    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
    Thumbnail INTRO EXCEL

    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 min

    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

    conceptual idea

    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.

    conceptual idea

    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

    Thumbnail INTRO EXCEL

    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