Tech Tip in a Tenth: Excel Templates
By Adriana Linares
Transcript
Welcome to another Tech Tip in a 10th. I’m Adriana Linares, the San Diego County Bar Association’s Practice Management Advisor. If you’re a member of the bar, remember that you can make an appointment to meet with me and get a lot of your questions answered about technology and practice management.
Today’s tech tip is going to be about Excel files, templates, and formulas. What we’re going to talk about today is taking advantage of many of the templates that Excel has built into it or made available to you through their templates gallery. A lot of attorneys call me asking for something like an amortization table. Or they want to build a budget for a trial or something like a timeline.
Well, there are a lot of things that are better suited over in Word, like calendar. Maybe an org chart or a family tree — PowerPoint has specific tools for creating some of those things, like a work chart, but Excel is really quite wonderful for things that require formulas. So, budgets, calculators, and a couple of other things. How do you access these templates that I’m speaking of?
You’re going to open up Excel, going to click on File, going to go to New. When you click on new it takes you to an area where you can search online for specific types of templates, but you can also take a quick peek at some of the templates that they have available right out of this page. So, first of all, it’s always a good idea and never hurts to just watch a couple of the videos that Microsoft gives us on understanding the basics of Excel and getting started with formulas. And then, if you’re into pivot tables, it even has a basic tutorial for pivot tables. You can always find more online. But back to templates. You’ll see that they have some sample templates here. Probably the most frequently searched-for templates. You’ll see there’s one over here called Milestone Infographic, but that could certainly be used for something like a timeline for trial. There are project planners, invoices, calendars — which, as I said, you know, if you’re looking to just kick out a graphics calendar to just print and hang in the office for holidays or vacation time or, you might try these, but remember Excel might not always be the perfect tool for what you’re looking for. If you’re unsure, or looking for something specific, you can always reach out to me. I’m happy to help, but back to the templates that Excel gives us. It will break down the templates it has to offer by certain categories, so it has a business category, personal planners and tasks, lists, budgets, charts, and calendars.
Let’s say you’re doing a budget for trial and you’re just trying to get a basic idea. Maybe keep track of what something might cost you. I always like to start by showing you a wedding budget because you think a wedding budget is good for trial. Well, let’s go ahead and open it. And download it. And by the way these are safe. You can always download these, they are part of Microsoft’s template gallery.
So, when you find one of these templates, all you’re going to do really is get creative and reuse what is already built into it. Trying to learn how to build formulas is hard. Trying to figure out how to make one cell show you the total of a couple of other cells; while not hard, and formulas aren’t necessarily hard, why would you work so hard for something that might be made easy by something like a template? So, let’s change this from the word wedding to trial, and let’s say we’re trying to keep this trial under $25,000 by changing that main number here, it’s going to change all of the formulas underneath. So, my expense is not necessarily a reception, but maybe they’re going to be fees. Attire: I’m definitely going to look my finest, but I’m not going to make a budget for it. But maybe this is going to be for experts. Then, under expenses, maybe graphics, copies, and images. So, see you can really just take these categories and reallocate them to what suits your needs, and then you’ll see it’ll start doing all the math for you.
Let’s look at a couple of other quick examples of the types of templates that are in here, so again, you’re going to go back to New. And look through here. I wanted to show you under personal that you might find things like a personal monthly budget. Maybe you’re trying to budget for your office expenses. Maybe you’re just starting a law firm, and you’re trying to figure out what your expenses are going to have. So even though this is under personal, you might find the template that you’re looking for there. Of course, you’ve got some under business that you could certainly look at. One that I get asked for a lot is an amortization table, so why would I work so hard trying to figure out how to do the calculations? So here you can see there’s a simple loan calculator. There’s a loan amortization schedule that you just, again, plug in your own numbers. You change these to suit you the way you need.
I hope you have found this tip helpful, and don’t forget you can always reach back out to me at scba.org/tech appointment if I can be of any further assistance and especially if you need help with something as clever and helpful as these templates can be in your practice.
