Hi everyone, welcome to another Tech Tip in a 10th. I’m Adriana Linares. I’m the San Diego County Bar Association’s Technology and Practice Management Advisor. As a reminder, if you have any questions about technology, practice management, your website, launching your law firm, running your successful law firm – from the technology and practice management side – if you have any questions like that and would like some help from me, appointments are free for members! You can always go to scba.org/techappointment to do that. Read More
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.Read More
For many attorneys and professionals, maintaining a separate office phone number without carrying an additional device is crucial. Softphones, commonly known as voice-over-ip phones, offer a viable and affordable solution. These services consist of a subscription and/or an app that uses your device’s microphone and speakers (and sometimes camera) and, of course, an internet connection. Devices such as laptops, smartphones, computers, smart TVs, and tablets can all be converted into softphones.Read More
Cutting and pasting is a simple task. Perhaps so simple and effective that most users never ask, “Could there be more?” With a few keystrokes, you can easily repurpose text from one place to another. It’s such a common and old function that it’s probably one of the few keyboard shortcuts known by the least proficient Word-users: CTRL + X cuts, CTRL + C copies, and CTRL + V pastes. But could there be more? I’m so glad you asked because, yes yes, there is so much more. You have OPTIONS, and they can work wonders in helping you insert text more efficiently and prevent you from getting into a formatting fight with Word.Read More
We will begin this two-part series on understanding the difference between OneDrive and SharePoint by exploring OneDrive. In part two, we will discuss SharePoint and the differences between them.Read More
In today’s security landscape, there’s no such thing as “too careful.” With so many of us still working from home, devices scattered around cities and states, and malicious actors on the rise seeking to take advantage of the situation, it’s more important than ever for lawyers and law firms to be on top of their security game. One simple and effective step to take? Implement multifactor authentication (MFA).Read More
A digital signature is almost imperative for working remotely and online these days. Electronic signatures are a convenient, legally binding way to apply your consent to an electronic form or document. Having a copy of your digital signature handy can save time and money as you skip printing and mailing paper or printing, signing, and scanning documents. Read More
In this series of tips, we will explore how Microsoft 365 can help law firms be more efficient, secure, and efficient. Your firm’s software and service subscriptions are a valuable business resource that you should understand, just like your firm’s operating and trust accounts. Be sure to read our previous posts about Microsoft365 to be sure you are using the best account type for your law practice and understand which Microsoft subscription you are using. In this post, we will discuss your options for using and subscribing to Microsoft Copilot. Read More
In this series of tips, we will explore how Microsoft 365 can help law firms be more efficient, secure, and efficient. Your firm’s software and service subscriptions are a valuable business resource that you should understand, just like your firm’s operating and trust accounts. To start, you need to know what kind of account you and/or your firm have; we covered that topic in a previous post. In this post, we will discuss your options for subscription plans to Microsoft 365. Read More
