Tips & Tricks 190
Quote For The Month
"Success consists of going from failure to failure without loss of enthusiasm" Winston Churchill
Paste Column Widths
Excel 2010 - 2013
Courtesy of Ben Kusmin at Excel Esquire 
 

Cutting and pasting data into a new worksheet can cause headaches because Excel defaults to the standard column widths even if the data being pasted doesn't fit into it.  Cells with text appear truncated, and those with numbers display ##### to indicate that the entire number can't be displayed properly.
 

Avoid this problem by clicking on the dropdown beneath the Paste button and selecting the icon for "Paste with Column Widths":

The KeyTips is Alt<H<V<W

Toggle Between Different Sessions of Outlook
Courtesy of Dan Bressler at Broad & Cassel 

Many people forget about this trick because it's a keyboard trick instead of a mouse trick. While in Outlook, you can quickly and easily switch between your email, calendar, contacts, tasks, and notes by using  CTRL + 1,  CTRL + 2, CTRL + 3, CTRL + 4, and CTRL + 5  respectively.

Removing Line Numbering

Word (2007 - 2013)


If you are working with a document that has line numbering and you need to remove the numbering, follow the steps below.
 

1. Click on the Page Layout tab.

2. Click on Line Numbers in the Page Setup group and then choose Line Numbering Options.

3. Click on Line Numbers.

4. Uncheck the Add line numbering check box.

5. Click on OK twice.

Get More out of your Employees with an Investment in a Learning Management System (SavvyAcademy LMS)
 

The economic crash of 2008 forever changed the way law firms conduct business. It is not enough for a firm to offer the best legal minds. Instead, they must possess both legal and technical expertise. Simply put, the firms that will succeed must effectively leverage technology to efficiently help clients achieve their goals.

 

Savvy Training & Consulting is helping its customers stay ahead of this efficiency wave. In 2014, we released a new, innovative learning management system (LMS) called "SavvyAcademy" and it is unlike any other LMS on the market today. Among many other benefits, SavvyAcademy offers:

  • Both a state-of-the-art, intuitive delivery system as well as rich, continuously updated content - at an affordable price. Prior to now, clients had to purchase an LMS and the content separately and usually they paid a very high cost for both.
  • Off-site hosting and 24/7/365 support provided by Savvy Training & Consulting.
  • Trackable, reportable data down to each individual user.
  • Access to a social network of subscribers who continuously discuss challenges, ideas and successes that they are facing in their firms.
  • Complete control and customization opportunities for trainers and administrators who need to tailor their continuing education to individual attorneys, from new hires to seasoned legal eagles.

We believe that SavvyAcademy is a glimpse into the future of what training will and should look like in the legal industry. Contact Doug Striker if you'd like more information about this innovative system.

Excel (2007 - 2013)

If you need to repeat text in a horizontal range of cells, follow the steps below.
 

1. Type the text that you want repeated in the first cell of the range.

2. Select the cells that you want to fill.

3. Click on the Home tab.

4. Click on the dialog box launcher in the lower-right corner of the Alignment group.

5. Select Fill from the Horizontal drop-down list.

6. Click on OK.

Need a Quote for User Training & Floor Support? Are you Upgrading or Rolling Out a New Software Solution? We Can Help!

Are you still on Office 2007 or 2010 with no plans to upgrade at the present time? That's great! We can help with specific training through our Savvy Booster Shot program to help boost user skills and productivity.
Complete our online Savvy Proposal Request to get an accurate, easy to understand proposal for your upcoming training project. Our proposals are modular, making them easy to adjust to your exact needs. Savvy also partners with and trains on a variety of legal-specific third party platforms (including iCreate and NetDocuments).

Printing Document Properties
 

Document properties are used to identify items such as the filename, the author, dates associated with the document and statistics such as word and character counts. If you would like to print this information, follow the steps below.
 

1. In Word 2007, click on the Office button and then click on Word Options. In Word 2010 and Word 2013, click on the File tab and then click on Options.

2. Click on Display at the left side of the dialog box.

3. Check the Print Document Properties check box.

4. Click on OK.

 
Savvy Training Public Webinars
At just $99 each, Savvy Training webinars are perfect for both individual and group instruction. All you need to join a Savvy Training Webinar is a PC (with a projector for larger groups), an internet connection, a telephone or VOIP, and notepad for taking notes.
If you would like a private webinar on any topic that is specific to your firm, please contact us to schedule!

Outlook (2010-2013)
Creating Quick Parts

 

There is an easy way to store frequently used text to insert quickly into an e-mail.
 

1. Click on New E-Mail in the New group on the Home ribbon.

2. Click in the body of the e-mail and type the text that you want to store and then select the text.

3. Click on the Insert tab.

4. Click on Quick Parts and then choose Save Selection to Quick Part Gallery.

5. Type a name for the text and then click on OK.

6. To insert the text, click on Quick Parts and click on the text that you want to insert.

7. You can also type the first few characters of the quick part and press F3 to insert.

Looking for a Content Library? Go with the SavvySMART Content Library!
Our SavvySMART Content Library provides a complete set of legal-specific learning tools for software migrations and ongoing training initiatives. SavvySMART is customizable and modular. Our suggested course catalog features hundreds of training modules for both self-directed and instructor-led classes. New software rollout kits are included in the SavvySMART Content Library, and it also includes: Trainer and User instruction manuals, workbooks, online Quick Reference Guides, eLearning videos with optional quizzes, and over 200 recorded webinars of live training events, many with PDF handouts.
Welcoming New and Renewing SavvyAcademy LMS and SavvySMART Content Library Subscribers
New Subscribers
Renewing Subscribers
Holland & Hart LLP
Texas Instruments Inc.

Kaufman & Canoles, P.C.

Robinson & Cole LLP
Morrison Mahoney LLP
Harrison, Moreland, Webber & Simplot, P.C.
Lloyd Gosselink Rochelle & Townsend, P.C.
Trainor Fairbrook
Huie, Fernambucq & Stewart, LLP
Foster Graham Milstein & Calisher, LLP
Foster, Swift, Collins & Smith PC
Pinnacle West Capital Corporation
Moye White LLP
Snell & Wilmer
Goodell DeVries Leech & Dann, LLPMasuda, Funai, Eifert & Mitchell, Ltd.
Nilan Johnson Lewis PA
Parsons Behle & Latimer
Mitchell, Williams, Selig, Gates & Woodyard, P.L.L. C
Whiteford Taylor & Preston, LLP.
White and Williams LLP
Engelman Berger, PC
Willcox & Savage, P.C.
Lourie & Cutler, P.C.

Going to ILTA? Visit Savvy Training and see what's new!

ILTACON is a four-day educational conference (August 30 - September 3, Las Vegas) that draws on the personal and collective strengths of professionals working in technology within law firms and legal departments. ILTACON will empower us to share what works, what doesn't and the tools to face challenges now and in the future.
Savvy is Growing!
Have a friend or colleague who would like to grow with us? Send us a resume to [email protected]. We will treat each inquiry in confidence.