Legal Tech TIPS
BY NATALIE R. KELLY AND MIKE MONAHAN
1 MacRumors Buyer’s Guide https://buyersguide.macrumors.com
Use this online service to check out a product summary and recommendation for each newly-released Apple product. Even though there are no guarantees if the information is 100 percent accurate, the reviews can be very helpful to Apple product purchasers.
2 Exceljet www.exceljet.net
Want to learn how to better utilize Microsoft Excel? This service offers free resources, including short training videos and lists of functions, formulas and shortcuts, in addition to a blog covering a variety of topics. Paid training services are also available.
3 Flipping Data in Excel
Speaking of Excel, did you know you can flip your data? With the Paste Special/Transpose command, you can make your rows columns and your columns rows. Give it a try: Highlight and copy the Excel spreadsheet. Select “Paste Special.” Check “Transpose.” Click “OK.” Done!
4 Excel’s NETWORKDAYS
Here’s a quick tip for calculating available work days for projects or other uses. The Excel NETWORKDAYS function calculates the number of working days between two dates. The command automatically excludes weekends (Saturday and Sunday) and can optionally exclude a list of holidays supplied as dates. For the holidays argument, supply a range that contains holiday dates. These are also treated as non-working days and will not be included in the result. To use this command, just open a new Excel sheet and click on “Formulas” at the top. Click in any cell and select “Insert Function.” Type “Networkdays” in the search box and click on the result. Now enter your start and end dates, and enter the number of holidays in that period, if any. Press Enter, and you’ll know how many work days you have available.
5 Office Cheat Sheets https://bit.ly/380PZtC
Microsoft wants its users to get good help quickly and has developed a comprehensive set of cheat sheets covering Microsoft Office programs on both Windows and Mac platforms. Get downloadable PDF cheat sheets via the link above.
6 Speaker Clearinghouse
If you are responsible for a program agenda and would like to feature a minority or woman lawyer speaker, use the State Bar’s Committee to Promote Inclusion in the Profession’s Speaker Clearinghouse. Minority and women lawyers can also sign up on the...