Generally, Microsoft Excel is used by law firms to create basic spreadsheets. But, because Excel deals predominantly with numbers, most lawyers associate Excel with accountants and spend very little time and energy learning how to use functions beyond reading spreadsheets and inputting simple numbers and text.

This course has been specifically designed with legal professionals in mind and will provide useful advice on how to use basic functions in Excel such as formatting information in rows and columns to more complex functions such as creating tables, charts and pivot tables. After completing this course, you will be able to calculate, sort, filter and chart data, which should help improve your efficiency and productivity at your place of work.

In order to contextualise the information being learned, participants will be asked to create several different types of spreadsheets such as billing and client databases to a PivotTable to help analyse a firms' key performance indicators.

While there are many different versions being used by legal professionals, this course will be based on the 2013 and 2016 version of Microsoft Excel. As such, some of the visuals and videos may slightly differ from your current version, but they should be similar enough that you can follow along.

We hope you enjoy taking this course on Excel and find the information helpful and useful in learning how to create impressive spreadsheets!