Learn MS Word and Excel the right way . Made just for lawyers and law students. Create clean, professional legal documents that impress recruiters and interviewers. Better documents mean better first impressions and better chances at jobs, placements, and scholarships.
Lawyered & Loaded: The Word & Excel Course to Make You a Legal Ninja is a practical, instructor-led program designed for lawyers, law students, advocates, legal consultants, and other legal professionals who want to improve their everyday digital skills.
The course focuses on the practical use of Microsoft Word and Microsoft Excel in legal work. Participants will learn how to draft and format professional legal documents, review contracts using Track Changes, navigate lengthy case files, organise client and case-related information, clean large datasets, perform calculations, and automate repetitive tasks.
The training uses law-focused examples so that every concept can be applied directly to legal drafting, research, compliance, case management, billing, reporting, and documentation.
By the end of the course, participants will be able to:
Create professionally formatted legal documents
Review and collaborate on agreements efficiently
Manage long contracts, petitions, reports, and case files
Organise client, case, billing, and compliance data
Use essential Excel formulas and functions
Clean and standardise large datasets
Reduce manual errors and repetitive work
Improve speed, accuracy, and productivity in legal practice
Understanding the Microsoft Word interface
Creating, saving, opening, and organising documents
Common Word applications in legal practice
Setting up a document for professional legal drafting
Using templates for agreements, notices, petitions, and reports
Using Track Changes
Adding, replying to, and resolving comments
Accepting and rejecting suggested changes
Comparing two versions of a legal document
Protecting documents during review
Collaborating with clients, colleagues, and senior lawyers
Using the Navigation Pane
Applying headings and subheadings
Searching within lengthy documents
Using bookmarks and hyperlinks
Working with Reading Mode and document views
Navigating contracts, case files, judgments, and reports efficiently
Font selection, size, and consistency
Paragraph spacing and alignment
Margins and page setup
Line spacing and indentation
Bullets and numbered lists
Headers, footers, and page numbers
Creating professional title and signature pages
Using Styles for consistent formatting
Creating an automatic Table of Contents
Working with page breaks and section breaks
Different headers and footers for different sections
Footnotes and endnotes
Cross-references and internal links
Formatting annexures, schedules, and exhibits
Creating reusable legal document templates
Creating and formatting tables
Managing columns and rows
Using tables for comparison, timelines, and case details
Converting text into tables
Repeating table headings across pages
Creating structured annexures and schedules
Proofreading tools
Spell check and grammar review
Removing comments and revision history
Restricting editing
Adding passwords and document protection
Converting Word files into PDF
Preparing final documents for printing and submission
Understanding workbooks, worksheets, rows, columns, and cells
Entering and editing data
Basic navigation and keyboard shortcuts
Common Excel applications in legal practice
Creating case trackers, client lists, compliance sheets, and billing records
Sorting data
Applying filters
Using Freeze Panes
Creating Excel Tables
Managing multiple worksheets
Searching and replacing data
Organising client, case, hearing, and compliance information
Formatting text, dates, numbers, and currency
Applying borders and alignment
Adjusting row heights and column widths
Using Wrap Text and Merge Cells appropriately
Creating clean and readable tables
Using conditional formatting to highlight deadlines and important records
Removing duplicate records
Using Find and Replace
Splitting data with Text to Columns
Using Flash Fill
Correcting inconsistent names, dates, and formats
Identifying blank or incorrect entries
Preparing data for reporting and analysis
SUM
AVERAGE
MIN and MAX
COUNT and COUNTA
Percentage calculations
Basic arithmetic formulas
Using absolute and relative cell references
Calculating fees, expenses, penalties, and professional charges
Using the IF function
Understanding multiple conditions
Using AND and OR
Creating status-based results
Marking deadlines as pending, completed, or overdue
Building simple compliance and case-status trackers
Entering and formatting dates
Calculating the difference between dates
Tracking limitation periods and deadlines
Calculating due dates
Identifying overdue matters
Creating hearing and compliance calendars
Introduction to lookup functions
Using VLOOKUP or XLOOKUP
Finding client and case information
Matching records across worksheets
Retrieving fees, dates, case numbers, and status information
Using AutoFill
Creating reusable spreadsheet templates
Applying data validation and dropdown lists
Reducing repetitive entries
Protecting formulas and worksheets
Preparing sheets for team use
Creating summaries from legal data
Preparing client and case reports
Using basic charts where required
Printing selected areas
Setting page orientation and print layout
Exporting Excel reports to PDF
Deepanshi Gupta
A Venture Capital Lawyer & Company Secretary at Inflection Point Ventures & Physis Capital. Working across M&A, PE, VC verticals, she also curates Insolvency Chronicle, a monthly newsletter that captures the evolving spirit of IBC.
She holds an academic pedigree from ICSI, Gargi College, and Campus Law Centre, University of Delhi. A recipient of the President’s Gold Medal for all-round excellence in academics and extracurriculars, she also has several publications to her credit.