MS Excel for Legal Operations
Practical tips on how to use Microsoft Excel to create spreadsheets to track law firm and client data. NOTICE: Please be informed that lifted.teachable.com will be discontinued from 1 November 2024. For enquiries, please email [email protected].
NOTICE: Please be informed that lifted.teachable.com will be discontinued from 1 November 2024. For enquiries, please email [email protected]
This course has been specifically designed with legal professionals in mind and will provide useful advice on how to use basic functions in Microsoft Excel such as formatting information in rows and columns to more complex functions such as creating tables, charts and pivot tables.
This online module is complemented by our optional Tech Tuesday sessions. Each session is an hour-long, face-to-face tutoring session on one of the three MS Office productivity tools to help you with any outstanding questions you may have about applying what you learnt in the online modules to your work.
Your Instructor
The Singapore Academy of Law (SAL) is a promotion and development agency for Singapore’s legal industry.
Our Legal Industry Framework for Training and Education (LIFTED) programme is designed to help members identify and develop core and specialist competencies in their particular areas of practice. We work with industry stakeholders to tailor programmes to encourage development, experimentation and innovative thinking.
Course Curriculum
Excel at Legal Productivity and Efficiency
Available in
days
days
after you enroll
Module 1: Spreadsheets 101
Available in
days
days
after you enroll
-
StartGeneral terms used in Excel.
-
StartLearn how to create, open, save and close a spreadsheet.
-
StartTry it! Create a new workbook.
-
StartTry it! Open a spreadsheet.
-
StartTry it! Save a spreadsheet.
-
StartTry it! Rename your file.
-
StartTry it! Close a spreadsheet
-
StartLearn how to add, delete and rename a sheet. (1:39)
-
StartTry it! Add a new sheet.
-
StartTry it! Delete a sheet.
-
StartTry it! Rename a worksheet tab.
-
StartLearn how to move or copy worksheets. (1:49)
-
StartTry it! Move a worksheet within a workbook.
-
StartTry it! Copy a worksheet in the same workbook.
-
StartTry it! Copy a worksheet to a new workbook.
-
StartChange the page orientation. (0:58)
-
StartTry it! Change the page orientation.
-
StartReview Module 1 and Quiz.
Module 2: Learn how to Enter and Manage Cell Data
Available in
days
days
after you enroll
-
StartCreate a client intake form.
-
StartDiscussion Board.
-
StartEnter data into your spreadsheet. (3:10)
-
StartTry it! Enter data in a cell.
-
StartTry it! Enter dates or time in a cell.
-
StartTry it! Today and Now functions.
-
StartEdit a cell. (1:16)
-
StartTry it! Delete characters in a cell.
-
StartMake changes in Edit mode.
-
StartTry it! Enable or disable Edit mode.
-
StartTry it! Enter Edit mode.
-
StartTry it! Exit Edit mode.
-
StartTry it! Insert, delete or replace cell contents in Edit mode.
-
StartTry it! Insert a cell.
-
StartAdjust the way cell contents are displayed. (1:38)
-
StartTry it! Adjust and change the cell size.
-
StartWrap text in a cell.
-
StartTry it! Wrap text in a cell.
-
StartResize and merge cells and align data. (3:18)
-
StartTry it! Align cell data.
-
StartTry it! Add a line break within a cell.
-
StartTry it! Make a cell taller or wider.
-
StartTry it! Merge cells.
-
StartAssignment: Create a client intake form.
-
StartReview Module 2 and Quiz.
Get started now!
Frequently Asked Questions
When does the course start and finish?
The course starts now and never ends! It is a completely self-paced online course - you decide when you start and when you finish.
How long do I have access to the course?
After enrolling, you have unlimited access to this course for as long as you like - across any and all devices you own.
Can I claim Private CPD Points?
Please note that claiming Private CPD Points is an honour-based, self assessment process on your part. All reference to specific CPD points is merely indicative and it is the responsibility of the individual lawyer to satisfy him/herself that the activity in question is a 'CPD Activity' as defined in the rules and guidelines.
You are advised to keep records relating to your undertaking of the activity, amongst other things, if you wish to rely on it to claim Private CPD Points.
Please refer to the SILE CPD Centre for more information on Claiming Private CPD Points (https://www.silecpdcentre.sg/Lawyer/CPD-Requirement/Private-CPD-Points/)