From the course: Excel for Legal Professionals

Unlock this course with a free trial

Join today to access over 25,300 courses taught by industry experts.

Introduction to basic formulas and functions

Introduction to basic formulas and functions - Microsoft Excel Tutorial

From the course: Excel for Legal Professionals

Start my 1-month free trial Buy for my team

Introduction to basic formulas and functions

“

- [Instructor] So let's talk about some formulas that you're most likely going to be using within your legal work, but most definitely in this course. And one of them you have already used already, that's the Excel LOOKUP, but there's a few here that I want to go through. So those are IF, FILTER, XLOOKUP and TEXTJOIN. So we're going to go through examples for each of those. I have a tab here called Data, this is just your starting data, it just has some data here for you to get familiar with, so take a few seconds and look at it and make sure you understand what's going on. And then when you're ready, go ahead and click on the IF tab. Now, you might also have noticed, actually, that my Excel version is newer, a little more updated, that's because I wanted to show you some functions in here that are available in the latest version of Excel. Now, if you don't have the latest version of Excel, most of what I talk about here today should be available. If it's not, there is one example I…

Contents