Category Archives: Excel

How to Use Excel to Create Searchable Bates Numbers.

26 Saturday Sep 2015

Posted by in Adobe Acrobat, Bates Numbers, Excel, Legal Technology, Litigation, Microsoft Office

≈ Comments Off on How to Use Excel to Create Searchable Bates Numbers.

Tags

, , , ,

Fast Tip Friday, Convert Doc Number List to Searchable Bates Numbers, by Amy Bowser-Rollins, Litigation Support Guru

http://tinyurl.com/pdg3pnx

This is an adaptation of an article posted on the Excel Esquire site. This scenario happens often in the middle of a litigation matter. Attorneys will make a list of relevant document numbers and only include the part of the number that is different. But in order for a paralegal or litigation support professional to run a search for the documents in a database, we need to re-format the document numbers. . . .

Continue reading →

The Five Basic Excel Functions That Make Your Life Easier.

24 Monday Nov 2014

Posted by in Excel, Legal Technology, Microsoft Office

≈ Comments Off on The Five Basic Excel Functions That Make Your Life Easier.

Tags

, , , ,

5 Basic Excel Functions That Make Work Infinitely Easier, by Fatima Wahab, Addictive Tips Blog

http://tinyurl.com/ndql3ks

Excel is the illiterate man’s (and woman’s) favorite data manipulation tool. The literate i.e. those that can code, don’t need to worry themselves much about columns, rows, and the correct formula and its syntax because these wizards have their own devices. For everyone else, practically anyone in a management position, Excel is an essential work tool. Despite this, a lot of people, especially those just stepping into a job are often intimidated by it. In reality, if you learn Excel well enough, you can use it to keep time based records that update automatically, use it to store inventory, and even conduct surveys. That said, here are five very basic Excel functions that every beginner needs to know. . .

How To Make a Timeline Exhibit Using Microsoft Excel.

04 Friday Jul 2014

Posted by in Excel, Exhibits, Legal Technology, Microsoft Office, Trial Tips and Techniques

≈ Comments Off on How To Make a Timeline Exhibit Using Microsoft Excel.

Tags

, , , ,

Creating A Custom Timeline In Excel, by Deborah Savadra, Legal Office Guru Blog

http://legalofficeguru.com/custom-timeline-in-excel/

If you do not have special litigation software and need to create a timeline exhibit for your case, hang on to this post. It will come in handy, as will the Legal Office Guru Blog.  If you cannot find what you need there, try the Addictive Tips Blog – another good “how to” resource. -CCE

At Last! The Microsoft App For iPad, With Word, Excel, and PowerPoint.

29 Saturday Mar 2014

Posted by in Apple, Apps, Excel, Legal Technology, Mac, Microsoft Office, PowerPoint, Word

≈ Comments Off on At Last! The Microsoft App For iPad, With Word, Excel, and PowerPoint.

Tags

, , , , , , , , ,

Microsoft releases Word (and Excel and PowerPoint) for iPad, by Jeff Richardson, iPhone J.D. Blog

http://tinyurl.com/l44cvjy

I’m at ABA TECHSHOW in Chicago right now, and the big news on Thursday was that Microsoft released a version of Word (and Excel, and PowerPoint) for the iPad.  I have been kicking the tires on this app since it was released Thursday afternoon, and I am incredibly impressed.  Unlike Microsoft Office Mobile for iPhone released last year, the new Word app for the iPad has virtually every feature that lawyers want to use.  Every attorney who uses an iPad will want to get this app. . . .

How To Disable The Typing Animation Feature in Office 2013.

20 Monday Jan 2014

Posted by in Excel, Legal Technology, Microsoft Office, PowerPoint, Word

≈ Comments Off on How To Disable The Typing Animation Feature in Office 2013.

Tags

, , ,

Disable Typing Animation In All Office 2013 Applications [Tip], by Abdullah Saqib, Addictive Tips Blog

http://tinyurl.com/8thsnp7

Have you made the switch to Microsoft Office 2013? If you have, hopefully you are happy with all the changes that inevitably follow each new version. The Addictive Tips Blog is a useful tool, along with the always handy “F1,” if you find that things do not work in the way they did in older versions.

This post shows you how to disable the typing animation feature. It is not a permanent change to the software – you can get it back anytime you want it. -CCE

Craig Ball Revisits Gigabytes.

15 Wednesday Jan 2014

Posted by in Computer Forensics, Databases, Discovery, E-Discovery, Excel, Legal Technology, Microsoft Office, Word

≈ Comments Off on Craig Ball Revisits Gigabytes.

Tags

, , , , , , , ,

Revisiting ‘How Many Documents in a Gigabyte?’, by Craig Ball, Ball In Your Court Blog

http://tinyurl.com/npc3jn3

[I]’m happy to point you to some notable work by my friend, John Tredennick. I’ve known John since the emerging technology was fire and watched with awe and admiration as John transitioned from old-school trial lawyer to visionary forensic technology entrepreneur running e-discovery service provider, Catalyst. John is as close to a Renaissance man as anyone I know in e-discovery, and when John speaks, I listen.

Lately, John Tredennick shared some revealing metrics on the Catalyst blog looking at the relationship between data and document volumes, an update to his 2011 article called, How Many Documents in a Gigabyte?