Category: Certificate Courses

The Excel formulas for office work that cover most daily tasks are SUM, ROUND, IF, COUNTIF and COUNTIFS, SUMIF and SUMIFS, a lookup (VLOOKUP, XLOOKUP or INDEX with MATCH), date functions such as EOMONTH and NETWORKDAYS.INTL, TEXT, TRIM and SUBTOTAL. Learn their exact syntax, lock ranges with $ when copying, and test each formula on a few rows you can check by hand. Below is the most used formulas list with examples from Indian offices: GST, attendance, marksheets and invoices.

Excel formulas for office work: the core list with examples

1. SUM and AutoSum. =SUM(E2:E31) adds a range. Press Alt+= under a column to insert it.

2. ROUND. =ROUND(B2*C2,2) gives GST to the paisa; =ROUND(x,0) gives whole rupees. If a salary sheet pays whole rupees, round in the formula, so the column total matches the bank transfer.

3. Percentages. GST on a taxable value: =ROUND(B2*$H$1,2) with the rate in H1. Taxable value from a GST-inclusive price: =ROUND(B2/(1+C2),2). For ₹590 inclusive of 18%, that gives ₹500, not ₹483.80.

4. IF, AND, OR. =IF(C2="","",IF(C2>=33,"Pass","Fail")) handles blanks first. =IF(AND(F2<TODAY(),G2<>"Paid"),"Overdue","") flags unpaid bills past their due date. Text goes in quotes; numbers do not.

5. IFS (Excel 2019 and later, Microsoft 365): =IFS(C2>=90,"A",C2>=75,"B",C2>=60,"C",TRUE,"D"). Put the highest band first and end with TRUE as the catch-all.

6. COUNTIF and COUNTIFS. Days present in an attendance row: =COUNTIF(C5:AG5,"P"). Half days as half: =COUNTIF(C5:AG5,"P")+0.5*COUNTIF(C5:AG5,"HD"). Lucknow invoices of ₹10,000 or more: =COUNTIFS(D2:D500,"Lucknow",E2:E500,">=10000").

7. SUMIF and SUMIFS. Unpaid amount of one customer: =SUMIFS(E2:E500,C2:C500,"Gupta Stores",F2:F500,"Unpaid"). In SUMIF the sum range comes last; in SUMIFS it comes first. Using SUMIFS always avoids the mix-up.

Lookups, dates and cleaning formulas

8. VLOOKUP. =VLOOKUP(A2,Products!$A$2:$D$200,4,FALSE). Always type FALSE: without it VLOOKUP uses approximate match and can return a wrong rate with no error.

9. XLOOKUP (Microsoft 365, Excel 2021, Excel 2024, Excel for the web, Google Sheets): =XLOOKUP(A2,Products!$A$2:$A$200,Products!$D$2:$D$200,"Not found"). Exact match by default, and it can look left.

10. INDEX and MATCH (every version): =INDEX(Products!$D$2:$D$200,MATCH(A2,Products!$A$2:$A$200,0)). The 0 means exact match.

11. Dates. Month-end: =EOMONTH(A2,0). Days in that month: =DAY(EOMONTH(A2,0)). Probation end after six months: =EDATE(A2,6). Age in completed years: =DATEDIF(B2,TODAY(),"y").

12. Working days. =NETWORKDAYS(start,end,holidays) treats Saturday and Sunday as off. For a six-day office, =NETWORKDAYS.INTL(start,end,11,holidays) treats only Sunday as off. For October 2026 with 2 October as a holiday, the six-day count is 26.

13. TEXT. ="Salary for "&TEXT(A2,"mmmm yyyy") gives “Salary for October 2026”. The result is text, so keep the real date in its own column.

14. TRIM and PROPER. =PROPER(TRIM(A2)) removes extra spaces and fixes capitals, so “sharma traders ” and “Sharma Traders” stop counting as two customers.

15. IFNA and IFERROR. =IFNA(VLOOKUP(...),"Not found") catches only missing lookups. IFERROR hides every error, including real mistakes, so use it sparingly.

The one idea that fixes most broken formulas: $ references

When you copy =B2*H1 down, it becomes =B3*H2, pointing at an empty cell. Lock the fixed cell: =B2*$H$1. Click on the reference in the formula bar and press F4 to cycle between B2, $B$2, B$2 and $B2. Better still, convert your list to an Excel table (Ctrl+T) and use column names such as =SUM(Invoices[Invoice Total]), which keep working as rows are added.

Which Excel version do you have?

Open File, then Account, and look under Product Information. SUM, IF, COUNTIFS, SUMIFS, VLOOKUP, INDEX, MATCH, NETWORKDAYS and pivot tables work in all versions in use. IFS needs Excel 2019 or later. XLOOKUP, FILTER, SORT and UNIQUE need Microsoft 365, Excel 2021, Excel 2024 or Excel for the web. A function your version lacks shows #NAME?.

Common mistakes

• Amounts typed as “5000/-” or “Rs. 5,000”: they are text and are left out of sums.
• Percentages typed as 75 instead of 75%: =IF(G2<75,...) then flags everyone.
• Formatting to 0 decimals and assuming the value is rounded.
• Copying an AI-suggested formula without testing it on known rows.

Frequently asked questions

What are the most used Excel formulas for office work?

SUM, ROUND, IF, COUNTIF(S), SUMIF(S), VLOOKUP or XLOOKUP, INDEX with MATCH, EOMONTH, NETWORKDAYS.INTL, TEXT, TRIM and SUBTOTAL handle most registers, reports and salary sheets. Learning these with exact syntax covers most office tasks.

Which Excel formulas are asked in office job interviews?

Common tests include VLOOKUP with exact match, SUMIFS with two conditions, COUNT versus COUNTA, nested IF for grades, and absolute references. Be ready to explain why a formula works, not just type it.

What is the difference between COUNT and COUNTA?

COUNT counts only cells containing numbers or dates. COUNTA counts every non-empty cell, including text such as “AB” for absent.

Why does my formula give #N/A?

Usually a lookup could not find the value, often because of a hidden space or a number stored as text. Clean the data with TRIM or convert types, and check that VLOOKUP ends with FALSE.

Quick quiz

Sources

• Microsoft Support documentation: SUMIFS, COUNTIFS, VLOOKUP, XLOOKUP, INDEX, MATCH, NETWORKDAYS.INTL, EOMONTH, TEXT and ROUND functions
• Microsoft Support: availability of XLOOKUP and dynamic array functions by Excel version

Practise every formula with templates: Excel and AI for Office Work certificate course.

This page is for education and general information, not legal advice for a specific case. Law as on 29 October 2026.

To use ChatGPT for Excel formulas, tell it five things: your software and version (for example “Excel 2019” or “Microsoft 365”), the sheet layout (which column holds what and where data starts), the result you want with one expected answer, the awkward cases (blanks, half days, “AB”), and a request to explain the formula simply. Then test the formula on rows you can check by hand before copying it down. AI tools write and explain formulas well, but they can also give formulas that look right and are wrong, and they should never see your real salary or customer data.

How to use ChatGPT for Excel formulas: a prompt that works

Compare two prompts.

Weak: “Formula for attendance.”

Strong: “I use Excel 2019. Sheet ‘Attendance’ has employee IDs in A5:A60 and daily codes for October 2026 in C5:AG60. Codes: P present, A absent, HD half day, CL, SL, EL leave, H holiday, WO weekly off. In AH5 I want days present, counting HD as half a day. For a row with 20 P and 2 HD the answer should be 21. Give one formula I can copy down and explain each part.”

A correct answer is =COUNTIF(C5:AG5,"P")+0.5*COUNTIF(C5:AG5,"HD"). The expected answer you gave (21) lets you confirm it in seconds.

More prompts worth saving:

• Lookup: “Excel 2016. Product codes in Products!A2:A200, rates in D2:D200. Fetch the rate for the code in A2, show ‘Not found’ if missing, and do not use XLOOKUP.” Expected: an INDEX with MATCH or VLOOKUP with FALSE, wrapped in IFNA.
• Conditional total: “Microsoft 365. Column B city, C month, D amount, headers in row 1. Total for Lucknow in October.” Expected: =SUMIFS(D:D,B:B,"Lucknow",C:C,"October").
• Explain a formula: paste only the formula: “Explain step by step for a beginner: =IFNA(INDEX(Rates!$D$2:$D$200,MATCH(A2,Rates!$A$2:$A$200,0)),"Not found").”
• Fix an error: “This VLOOKUP returns #N/A for some rows though the codes look identical. The codes were pasted from a PDF.” A good answer suggests hidden spaces or numbers stored as text and proposes TRIM or VALUE.

Common AI formula mistakes to catch

• Wrong version: XLOOKUP, IFS, FILTER or TEXTSPLIT given to someone on an older Excel, which shows #NAME?.
• Argument order: SUMIF and SUMIFS mixed up (SUMIF puts the sum range last, SUMIFS first).
• Missing exact match: VLOOKUP without FALSE, or MATCH without 0, which can return plausible but wrong values.
• No $ signs where the formula will be copied, so ranges drift.
• Invented functions or options that do not exist.
• Made-up arithmetic: asking “what is the total of these rows?” invites wrong numbers. Let Excel calculate; let AI write the formula.

Example: Pooja, an accounts assistant in Surat, got =D2*C2/2 for CGST with no rounding and an unlocked rate cell. Her test rows showed the error in row 3. She asked again with “copy down, rate is per row in column C, round to 2 decimals” and got =ROUND(D2*C2/2,2), which passed her checks.

Copilot in Excel and Gemini in Google Sheets

Copilot in Excel is a pane inside Excel that can suggest formula columns, highlight data and summarise. Microsoft says it needs an eligible plan, such as certain Microsoft 365 personal plans with AI credits or a business Copilot licence, and it edits only when calculation is set to Automatic. A separate preview worksheet function, =COPILOT, was withdrawn in September 2026; old workbooks that used it show #NAME? when recalculated.

Gemini in Google Sheets offers a side panel and an AI function for eligible Google Workspace or Google AI plans. Google itself warns that output may be inaccurate.

Plans and features change often. Check what your organisation has approved before using any assistant on work files, and follow your employer’s AI policy even inside an approved tool.

The checking routine: every formula, every time

1. Read it. Identify each function and argument. Look up anything unfamiliar on Microsoft’s or Google’s help page.
2. Test known rows. Pick 3 to 5 rows you can work out by hand, including an awkward one: a blank, a zero, a half day, a missing code.
3. Check after copying. Open the formula in the last row: did the ranges shift correctly?
4. Cross-check the total another way: a pivot table, a SUMIFS or a filtered SUBTOTAL.
5. Check versions for everyone who will open the file.
6. Leave a note (Review, New Comment) saying what the formula does and when you checked it.

And the data rule: never paste salary sheets, Aadhaar or PAN numbers, bank details, student marks with names or customer lists into an AI tool your organisation has not approved for that data. Describe the columns, or paste five made-up rows with the same structure.

Frequently asked questions

Can I use ChatGPT for Excel formulas?

Yes. ChatGPT and similar tools are good at writing and explaining Excel and Google Sheets formulas if you state your version, describe the layout and give an expected answer. Always test the formula on rows you can verify before relying on it.

Is Copilot in Excel free?

No. Microsoft makes Copilot in Excel available with eligible paid plans, and the eligible plans change from time to time. Check Microsoft’s current plan page or your organisation’s IT team.

Why does the formula from ChatGPT show #NAME?

Usually the formula uses a function your Excel version does not have, such as XLOOKUP or IFS in Excel 2016, or the function name is misspelt. Tell the tool your exact version and ask for an alternative using INDEX and MATCH or nested IF.

Is it safe to upload my Excel file to ChatGPT?

Not if it contains personal, salary, customer or confidential data, unless your employer has approved that tool for such data. Uploaded files include hidden sheets and comments too. Describe the structure or use dummy rows instead.

Quick quiz

Sources

• Microsoft Support: Get started with Copilot in Excel (eligible plans and requirements)
• Microsoft 365 Message Center, MC1454373: retirement of the =COPILOT function in Excel
• Google Workspace Help: Gemini in Google Sheets
• Microsoft Support: COUNTIF, SUMIFS, VLOOKUP, INDEX and MATCH functions

Learn formulas well enough to check any AI answer: Excel and AI for Office Work certificate course.

This page is for education and general information, not legal advice for a specific case. Law as on 29 October 2026.

Non-lawyers do not need a law degree, but most working adults in India now need some law for their job or their home. HR managers need POSH and the new Labour Codes, founders need data protection and contracts, teachers need POSH and basic rights, journalists need defamation and research skills, and every household needs everyday law on FIRs, consumer complaints, fraud and inheritance. A short, tested course in the one area you actually use is the most efficient route.

HR managers: POSH and the Labour Codes

If you work in HR, two areas will land on your desk sooner or later.

• POSH. The Sexual Harassment of Women at Workplace (Prevention, Prohibition and Redressal) Act, 2013 requires every workplace with 10 or more employees to constitute an Internal Committee (s.4), with a senior woman employee as Presiding Officer, at least half the members women, and one external member. A complaint can be made within 3 months (extendable by 3 months) under s.9, the inquiry must be completed within 90 days (s.11(4)), and the employer must act on the report within 60 days (s.13). Non-compliance can attract a penalty of up to ₹50,000 (s.26). In Aureliano Fernandes v. State of Goa (2023), the Supreme Court stressed proper constitution of committees and training.
• Labour Codes. The Code on Wages 2019, Industrial Relations Code 2020, Code on Social Security 2020 and OSH Code 2020 came into force on 21 November 2025, replacing 29 laws. Appointment letters, wage structures, gratuity (now under Chapter V of the Social Security Code) and full and final settlement within two working days of exit (s.17(2), Code on Wages) all need fresh attention.

Best fit: POSH Law (Internal Committee training), ₹499.

Startup founders and small businesses: DPDP and drafting

Ankit runs a 12-person D2C brand in Jaipur. He collects customer names, phone numbers and addresses every day. Under the Digital Personal Data Protection Act 2023, read with the DPDP Rules 2025, most substantive duties (notice, consent, security safeguards, breach intimation, data principal rights) apply from 13 May 2027. Penalties go up to ₹250 crore for failing to take reasonable security safeguards. The Act also covers data collected offline and later digitised.

Founders also sign vendor contracts, send and receive legal notices, and prepare affidavits for registrations. Knowing what a clean clause, a clear notice and a correct affidavit look like saves money on every lawyer interaction, because you brief better.

Best fit: Data Protection Law: DPDP Act 2023 and DPDP Rules 2025, ₹599, and Legal Drafting, ₹499.

Homemakers, senior citizens and tenants: everyday law

This group faces the most common legal problems and gets the least help. Typical questions:

• The landlord in Lucknow will not return the deposit. (UP’s 2021 tenancy law caps residential deposits at two months’ rent.)
• A son has stopped supporting his 70-year-old father. (The Senior Citizens Act 2007 allows maintenance up to ₹10,000 per month through the Maintenance Tribunal; Elderline 14567.)
• A wife and children are not being maintained. (s.144 BNSS, with no upper ceiling on the amount.)
• Money vanished through a UPI scam. (1930 and cybercrime.gov.in immediately, then the bank.)
• Who gets the house after father’s death without a will. (Hindu Succession Act 1956, s.8: son, daughter, widow and mother share equally as Class I heirs.)

Best fit: Everyday Law (English), ₹349 or Everyday Law (Hindi), ₹299.

Teachers, journalists and government job aspirants

Teachers. Schools are workplaces, so the POSH Act applies to staff. Teachers are also often the first adults children and parents turn to with a problem. Basic legal literacy (child helpline 1098, legal aid helpline 15100, how an FIR works) helps you guide them correctly. Best fit: Everyday Law, plus POSH Law for staff on the Internal Committee.

Journalists and content writers. Defamation is now an offence under s.356 of the Bharatiya Nyaya Sanhita 2023, and it remains a civil wrong too. Writers also need to read judgments, cite them correctly and avoid misreporting. Best fit: Legal Research and Research Paper Writing, ₹499, which covers finding, reading and citing legal sources.

Government job aspirants. Police, judiciary support, prosecution and many state-level exams now test BNS, BNSS and BSA, which replaced IPC, CrPC and the Evidence Act on 1 July 2024. Best fit: New Criminal Laws: BNS, BNSS and BSA, ₹499.

How to choose without wasting money

1. Write down the one legal problem you face most at work or at home.
2. Pick the single course that covers it. Do not buy a bundle “just in case”.
3. Finish it, take the test and keep the certificate ID for your CV or LinkedIn.
4. Remember the limit: the certificate shows you learnt the subject. It does not let you practise law or give legal advice as a profession. For serious matters, consult an advocate.

All options are on the certificate courses page.

Frequently asked questions

Do I need a law background to take these courses?

No. Everyday Law, POSH Law and DPDP courses are written for non-lawyers, in plain language with examples.

Can an HR manager be a member of the Internal Committee without a law degree?

Yes. The POSH Act does not require IC members to be lawyers. It does require the right composition, and training is strongly advised.

Is a Hindi option available?

Yes. Everyday Law is available in Hindi for ₹299.

Will the certificate help in my job?

It helps most when it matches your role, for example POSH for HR or DPDP for a product or compliance role. It is a certificate of completion issued by Lexfolio, not a professional qualification.

When do the main DPDP obligations apply?

Most substantive obligations under the DPDP Rules 2025 apply from 13 May 2027, 18 months after notification.

Quick quiz

Not sure where to start? Begin with Everyday Law for Every Indian, ₹349.

Sources

• Sexual Harassment of Women at Workplace (Prevention, Prohibition and Redressal) Act 2013, ss.4, 9, 11, 13 and 26
• Aureliano Fernandes v. State of Goa (2023), Supreme Court
• Code on Wages 2019, s.17(2); Code on Social Security 2020, Chapter V
• Digital Personal Data Protection Act 2023 and DPDP Rules 2025
• Bharatiya Nyaya Sanhita 2023, s.356
• Bharatiya Nagarik Suraksha Sanhita 2023, s.144
• Maintenance and Welfare of Parents and Senior Citizens Act 2007, s.9
• Hindu Succession Act 1956, s.8
• Uttar Pradesh Regulation of Urban Premises Tenancy Act 2021
• Advocates Act 1961, ss.29 and 33

This page is for education and general information, not legal advice for a specific case. Law as on 29 October 2026.

Put certificate courses in a separate “Certifications” or “Courses and Certifications” section, below education and internships. List each one on a single line with the course name, the issuer, the month and year, and the certificate ID or verification link. Keep only the two to four that match the role, never call a course an internship, and be ready to explain in an interview what you learnt and how you used it.

Where certificate courses go on a law CV

A law CV is read top-down in under a minute. Recruiters look for education, internships, moots and publications first. Certificates support that story; they do not lead it.

A typical order for a law student:

1. Name and contact details
2. Education (with year and marks, if good)
3. Internships
4. Moot courts, publications, research papers
5. Courses and Certifications
6. Positions of responsibility, languages, interests

Exception: if you are a first-year student with no internships yet, the certifications section can move up, just below education. For a first-year CV, see how to write a law student CV with no experience.

How to word each entry

Keep each entry to one line, or two at most. Use this format:

Course name, Issuer, Month Year (Certificate ID: XXXX, verify at lexfolio.in/verify-certificate/)

Examples:

• Legal Drafting: Notices, Affidavits, Applications and Agreements, Lexfolio, August 2026 (Certificate ID: [your ID])
• New Criminal Laws: BNS, BNSS and BSA, Lexfolio, September 2026 (Certificate ID: [your ID])

If the role is directly related, add a short line on what the course covered: “Drafted legal notices, affidavits and a rent agreement as part of module assignments” only if that is true for the course you took. Do not add claims you cannot back up.

Use the exact course name shown on the certificate. A recruiter who checks the ID will compare it.

How to talk about certificates in an interview

Interviewers often pick one line from your CV and ask about it. If they pick a certificate, you need a short, specific answer. Use this pattern:

1. Why you took it. “During my internship in Allahabad I realised I could not draft an affidavit without help.”
2. One concrete thing you learnt. “I learnt the standard structure: deponent details, numbered paras, verification clause, and how the verification differs from the body.”
3. Where you used it. “In my next internship I prepared first drafts of two affidavits that my senior corrected and filed.”

If you cannot answer a basic question about a course on your CV, remove it. An unexplained certificate hurts more than a missing one.

Example: Rahul lists “New Criminal Laws: BNS, BNSS and BSA”. The interviewer asks which BNSS section deals with FIR. He answers s.173, adds that it allows a zero FIR and an e-FIR to be signed within three days. That one answer makes the certificate credible.

What not to do

• Do not call a course an internship. A self-paced course is not an internship, even if a seller labels it a “virtual internship”. BCI’s Legal Education Rules 2008 require actual internships, and interviewers know the difference.
• Do not list dozens. Fifteen one-day certificates suggest you collected paper rather than skills. Keep the strongest two to four.
• Do not inflate the status. A certificate of completion is not a diploma, a degree or a professional qualification. Do not describe it as one.
• Do not hide the issuer. Always name who issued it.
• Do not list courses you did not finish. If you have not passed the final test, it does not go on the CV.
• Do not use outdated titles. If a course taught only IPC and CrPC, consider whether it still helps you, since BNS, BNSS and BSA have been in force since 1 July 2024.

LinkedIn and verification

Add the same certificates to the “Licenses and certifications” section on LinkedIn. Enter the issuer, issue month, the credential ID and the verification URL. Keep CV and LinkedIn consistent: same names, same dates.

For Lexfolio certificates, anyone can confirm your certificate at lexfolio.in/verify-certificate/ using the ID printed on it. Keep the PDF saved on your phone so you can show it at an interview if asked.

Want something specific for the CV? Browse the certificate courses page.

Frequently asked questions

Should I put certificate courses above internships?

Usually no. Internships carry more weight. The exception is a first-year student with no internships yet.

Do I need to include the certificate ID?

Yes, if the issuer offers verification. It lets a recruiter check the certificate in seconds and shows you have nothing to hide.

Can I describe a recorded course as a “virtual internship”?

No. That is misleading. List it under certifications with its real name.

How many certificates should a law CV have?

Two to four relevant ones. More than that, and the section starts to look like padding.

Does a Lexfolio certificate count as a qualification?

No. It is a certificate of completion issued by Lexfolio after passing the final test. It shows you studied and were tested on a subject; it is not a degree or diploma.

Quick quiz

Add a practical skill to your CV: Legal Drafting certificate, ₹499.

Sources

• Bar Council of India Rules of Legal Education 2008 (internship requirement)
• Advocates Act 1961, ss.29 and 33
• Bharatiya Nagarik Suraksha Sanhita 2023, s.173

This page is for education and general information, not legal advice for a specific case. Law as on 29 October 2026.

The best certificate course for a law student depends on the year of study. First-year students gain most from foundations and legal research, second and third-year students from drafting and the new criminal laws, and final-year and LL.M. or NET aspirants from research writing and structured NET preparation. Students aiming at corporate roles should add a compliance area such as DPDP or POSH. Pick one or two that match your stage, finish them, and be able to talk about them.

First year: build the foundation

First year is when most students feel lost. You are told to read bare acts and judgments, write case comments and prepare for moots, often without anyone showing you how.

• Law School Starter. Built for law aspirants and students in the first months of a 3-year or 5-year LL.B., it gives you an orientation to the basic skills and vocabulary of legal study before the workload builds up.
• Legal Research and Research Paper Writing. Teaches you to find the right sources, structure an argument and cite cases correctly. Research skills pay off in every assignment, moot memorial and seminar paper for the rest of your degree.

Example: Aditi, in her first semester at a law college in Indore, uses the research course to write her first project properly cited, rather than learning by trial and error over three years.

Second and third year: become useful in a chamber

By the middle years, internships become serious. Seniors notice interns who can draft a basic document and who know the current law.

• Legal Drafting. Legal notices, affidavits, applications and agreements. These are the first drafts a senior will hand you. Knowing the standard structure lets you produce a usable first draft instead of a blank page.
• New Criminal Laws: BNS, BNSS and BSA. These replaced IPC, CrPC and the Evidence Act from 1 July 2024. Many older textbooks and notes still use old section numbers. An intern who can say “s.173 BNSS” for the FIR provision, not just “s.154 CrPC”, stands out in a criminal practice.

Final year, LL.M. and UGC NET aspirants

Final-year students face two decisions: litigation or corporate work, and whether to pursue an LL.M., UGC NET or an academic path.

• UGC NET Law (Paper 2) Complete Course. For students who plan to qualify NET for Assistant Professor eligibility or Ph.D. admission. Structured preparation across the syllabus beats scattered notes.
• Legal Research and Research Paper Writing. LL.M. dissertations and journal publications depend on research method. If you skipped it in first year, take it now.

Corporate track: compliance skills employers ask about

In-house legal and compliance teams increasingly ask about two areas.

• Data protection. The DPDP Act 2023 and DPDP Rules 2025 (notified November 2025) bring most substantive obligations into force from 13 May 2027. Companies are preparing now, and a student who understands notice, consent, breach intimation and penalties (up to ₹250 crore for failure of security safeguards) is useful to them.
• POSH. Every workplace with 10 or more employees must have an Internal Committee under s.4 of the POSH Act 2013. Law firms and companies need people who understand the inquiry process and timelines.

What makes a certificate course worth adding

Before you add any course, from any provider, check:

1. Relevance to your stage and goal. A first-year student does not need a niche compliance course yet.
2. Current law. Criminal law content must reflect BNS, BNSS and BSA; labour content must reflect the four Labour Codes in force from 21 November 2025.
3. A real test. Module quizzes and a final assessment with a pass mark.
4. Verification. A certificate ID that a recruiter can check online.
5. Honest labelling. A course is a course. It is not an internship and does not count towards BCI internship requirements.

Compare all Lexfolio options on the certificate courses page.

Frequently asked questions

Which certificate course should a first-year law student do?

Start with a foundation course such as Law School Starter and a legal research course. Both help with every subject and assignment that follows.

Do certificate courses count as internships?

No. BCI’s Legal Education Rules 2008 require internships with advocates, courts, legal aid bodies and similar placements. An online course is not one.

How many certificate courses should I list on my CV?

Two to four relevant ones are enough. A long list of unrelated certificates looks like padding.

Is the Lexfolio certificate a diploma?

No. It is a certificate of completion issued by Lexfolio after you pass the final test. It is verifiable online but it is not a degree, diploma or professional qualification.

Should a student aiming for litigation take DPDP or POSH?

It is optional. Drafting and the new criminal laws are more directly useful for litigation. Compliance courses suit students heading to corporate or in-house roles.

Quick quiz

First-year? Start with Law School Starter, ₹349.

Sources

• Bar Council of India Rules of Legal Education 2008 (internship requirement)
• Bharatiya Nyaya Sanhita 2023, Bharatiya Nagarik Suraksha Sanhita 2023 (s.173), Bharatiya Sakshya Adhiniyam 2023
• Digital Personal Data Protection Act 2023 and DPDP Rules 2025
• Sexual Harassment of Women at Workplace (Prevention, Prohibition and Redressal) Act 2013, s.4
• Code on Wages 2019, Industrial Relations Code 2020, Code on Social Security 2020, OSH Code 2020

This page is for education and general information, not legal advice for a specific case. Law as on 29 October 2026.

Online law certificate courses are worth it when they teach a usable skill, test you properly and give a certificate that anyone can verify. They are not degrees, they do not give anyone the right to practise law, and they do not replace the internships the Bar Council of India requires of LL.B. students. Treat a good certificate as proof of a specific skill, not as a qualification.

What an online law certificate is, and what it is not

A certificate course is a short, focused programme on one area: drafting, research, a new statute, a compliance law. At the end, the provider issues a certificate saying you completed it and, in better courses, that you passed an assessment.

What it is not:

• Not a degree. It does not count towards an LL.B., LL.M. or any university qualification.
• Not a licence. Under the Advocates Act 1961, only an advocate enrolled with a State Bar Council can practise law. A certificate in drafting does not let a non-lawyer draft for clients as a profession or appear in court.
• Not an internship. BCI’s Legal Education Rules 2008 require LL.B. students to complete internships with advocates, courts, chambers, legal aid bodies or similar placements. An online course, however good, is not one of these.
• Not a professional qualification like a company secretary or chartered accountant membership.

Once you accept these limits, the question becomes simple: does this course teach me something I will use, and can I prove I learnt it?

When a certificate course is genuinely worth it

Use this four-part test before you pay.

1. A specific skill. “Legal Drafting: notices, affidavits, applications and agreements” is a skill. “Complete Law Mastery” is a slogan. Good courses name what you will be able to do.
2. A real assessment. Quizzes after modules and a final test with a pass mark. If anyone who clicks through gets the certificate, it proves only attendance.
3. A verifiable certificate ID. An employer should be able to enter your certificate number on the provider’s website and see your name, the course and the date. Without this, any certificate can be faked in ten minutes.
4. Practical content. Formats, checklists, worked examples, current law. A course on criminal law that still teaches only IPC and CrPC, when BNS, BNSS and BSA have been in force since 1 July 2024, is out of date.

Example: Neha, a second-year LL.B. student in Bhopal, keeps struggling to draft a legal notice during her chamber internship. A focused drafting course with formats and a test fixes a real gap and gives her something concrete to show.

Red flags to watch for

• No test at all. A certificate for watching videos says little.
• No verification page. If there is no way to check the certificate online, it has weak value.
• “Internship” labels on self-paced content. Some sellers call a recorded course a “virtual internship”. It is not one, and putting it on your CV as an internship can hurt you in an interview.
• Promises of jobs, enrolment or “BCI approval”. Be cautious of any claim that a short online certificate is approved for enrolment or guarantees placement. Ask for the document.
• Outdated law. Check that the course reflects the new criminal laws, the four Labour Codes (in force from 21 November 2025) and the DPDP Rules 2025, where relevant.
• Dozens of certificates in a bundle. Ten certificates for one price usually means ten thin courses.

How employers and colleges view them

Recruiters at law firms, companies and NGOs look first at your degree, your internships, your writing and how you speak in the interview. A certificate is a secondary signal. It helps in three situations:

• It matches the role. A POSH certificate for an HR or compliance role, a DPDP certificate for a privacy or tech role, a research course for a research assistant post.
• You can talk about it. If you can explain what you learnt and apply it to a question, it adds weight. If you cannot, it subtracts.
• It fills a visible gap. A first-year student with no internships yet can show initiative.

Colleges generally do not give academic credit for external certificates unless their own rules say so. Do not expect a certificate to count towards attendance, marks or internship requirements.

Cost comparison: what you are really paying for

Short certificates are cheap compared with a degree or a university diploma, so the money risk is small. The real cost is your time. A course you finish and use is worth more than five you abandon. Compare:

• Price per useful skill. One focused course at a few hundred rupees that you apply is better value than a bundle you never open.
• What is included. Lessons, formats, quizzes, a final test and verification.
• Currency of content. Updated law is worth paying for.

Lexfolio’s courses range from ₹349 (Law School Starter, Everyday Law) to ₹499 (Legal Research and Research Paper Writing, POSH Law, New Criminal Laws), ₹599 (DPDP Data Protection) and ₹1,499 for the UGC NET Law (Paper 2) Complete Course. See all of them on the certificate courses page.

Frequently asked questions

Can an online law certificate replace my BCI internship?

No. BCI’s Legal Education Rules 2008 require internships for LL.B. students, and an online course does not satisfy that requirement.

Can a non-lawyer practise law after a certificate course?

No. Only an advocate enrolled with a State Bar Council can practise law under the Advocates Act 1961.

Are Lexfolio certificates verifiable?

Yes. Each certificate has an ID that can be checked at lexfolio.in/verify-certificate/. It is a certificate of completion issued by Lexfolio, not a degree or diploma.

How many certificates should I do?

Two or three that match your goals are enough. Depth beats volume.

Do certificates help in placements?

They help only as a supporting signal, mainly when the subject matches the role and you can discuss it confidently.

Quick quiz

Browse every course on one page: Lexfolio certificate courses.

Sources

• Advocates Act 1961, ss.29 and 33
• Bar Council of India Rules of Legal Education 2008 (internship requirement)
• Bharatiya Nyaya Sanhita 2023, Bharatiya Nagarik Suraksha Sanhita 2023, Bharatiya Sakshya Adhiniyam 2023 (in force 1 July 2024)
• Code on Wages 2019, Industrial Relations Code 2020, Code on Social Security 2020, OSH Code 2020 (in force 21 November 2025)
• Digital Personal Data Protection Act 2023 and DPDP Rules 2025

This page is for education and general information, not legal advice for a specific case. Law as on 29 October 2026.