ILNews

Start Page: ‘Excel-erate’ your practice by learning Microsoft Excel

Back to TopCommentsE-mailPrintBookmark and Share

WilsonMany attorneys I know are reluctant to use Microsoft Excel. But, most of those attorneys have ideas of how they want to view and sort data. This article (and maybe some YouTube searching) will give you a starting point to help turn your dreams of organized and easy-to-understand data into reality using Microsoft Excel.

What is Excel?

Excel is a spreadsheet program. A blank spreadsheet looks like an empty Battleship game board. There is a grid containing columns and rows. Spreadsheets contain cells that are organized in horizontal rows (labeled with numbers) and vertical columns (labeled with letters). The cells in the grid can contain text, numbers, formulas and so on.

Another way to think of Excel is as a visual calculator. You enter a list of numbers and Excel can add, subtract, multiply, divide, sort and summarize those numbers based on the formula used. Excel includes many formulas and an extensive “Help” menu for users to find the right formula for the task at hand.

Excel also handles time and dates. You can use Excel to calculate the time between two dates, useful for keeping track of case and project deadlines. Excel has powerful charting and graphing features, allowing for a visual representation of data.

How to input information to Excel

To type information into a cell, click on the desired cell with your mouse and start typing. When you are done typing, press Enter (or Tab). That will move your cursor out of the cell and to another cell. Later, if you want to edit the information in that same cell (and not just type over it), you will need to double click on the cell to be able to edit the text.

You can also edit the text in the formula bar (the white space in the middle of the screen just after the “fx”) after clicking on the cell and placing your cursor where you would like to edit.

Example: hours worked calculator

That said, the best way to learn Excel is to use it. Open a blank spreadsheet. Take the following steps to build a spreadsheet to calculate how many hours you worked this week.

Click under the first column (A), in row number 1 (A1) type the word “Monday.” Press the tab key. Pressing the tab key should have moved your cursor one cell to the right. Now, in column B, row 1 (B1) and type the word “Tuesday.” Repeat this process to input the remaining days of the week in C1, D1, and E1.

Now, in F1, enter the word “Total.” Press the Enter key.

Click in cell A2. Now, enter the number of hours you worked Monday (in A2), Tuesday (in B2), and so on through Friday as a number (e.g., 1 for 1 hour, 2 for 2 hours).

Once you have put numbers in each cell under the days of the week, you are ready to create the “Total” cell (F2). In cell F2, you want Excel to add all the numbers you put in the cells for Monday-Friday (A2-E2) and provide you the total number of hours worked.

First, tell Excel that cell F2 will contain a formula. Simply type “=” (equal sign) to start the formula. Don’t press or click anything else, as you are not done building the formula. Next, tell Excel that you want the total of all the hours you worked this week (Monday through Friday) to appear in this cell. In Excel language, you want to create a formula that adds cells A2 through E2.

Type the “=” sign in cell F2 (unless it is already there), click on cell A2, then type “+” (the plus sign), click cell B2, then type “+” and so on until you have added all the cells that contain the number of hours worked during the day (i.e., A2, B2, C2, D2 and E2).

After you click E2, stop. Don’t press any other key or click your mouse. Look at the cells you just added to your formula. Excel highlighted them for you so you can quickly see what is being added (or was missed). Now that you have visually checked your calculation, you can press enter to place the formula in cell F2. Now if you click on F2, you will see your formula (=A2+B2+C2+D2+E2). Translation? Monday’s time is being added to Tuesday’s time, all the way through Friday. Grab a calculator and check.

Hopefully, working through this example helps reveal the power and possibilities of Excel. Excel can easily calculate medical bills, hours worked, dates and time, and so on. Excel can also create charts and graphs. Excel’s built-in formulas can handle everything from routine to highly complex calculations. Lawyers should learn and use Excel.•

__________

Seth Wilson is a partner at Hume Smith Geddes Green & Simmons LLP in Indianapolis. In addition to practicing law, he helps manage the day-to-day technology operations of the firm, and frequently speaks and advises on legal technology issues. The opinions expressed are those of the author.

ADVERTISEMENT

Post a comment to this story

COMMENTS POLICY
We reserve the right to remove any post that we feel is obscene, profane, vulgar, racist, sexually explicit, abusive, or hateful.
 
You are legally responsible for what you post and your anonymity is not guaranteed.
 
Posts that insult, defame, threaten, harass or abuse other readers or people mentioned in Indiana Lawyer editorial content are also subject to removal. Please respect the privacy of individuals and refrain from posting personal information.
 
No solicitations, spamming or advertisements are allowed. Readers may post links to other informational websites that are relevant to the topic at hand, but please do not link to objectionable material.
 
We may remove messages that are unrelated to the topic, encourage illegal activity, use all capital letters or are unreadable.
 

Messages that are flagged by readers as objectionable will be reviewed and may or may not be removed. Please do not flag a post simply because you disagree with it.

Sponsored by
ADVERTISEMENT
Subscribe to Indiana Lawyer
  1. One can only wonder whether Mr. Kimmel was paid for his work by Mr. Burgh ... or whether that bill fell to the citizens of Indiana, many of whom cannot afford attorneys for important matters. It really doesn't take a judge(s) to know that "pavement" can be considered a deadly weapon. It only takes a brain and some education or thought. I'm glad to see the conviction was upheld although sorry to see that the asphalt could even be considered "an issue".

  2. In response to bryanjbrown: thank you for your comment. I am familiar with Paul Ogden (and applaud his assistance to Shirley Justice) and have read of Gary Welsh's (strange) death (and have visited his blog on many occasions). I am not familiar with you (yet). I lived in Kosciusko county, where the sheriff was just removed after pleading in what seems a very "sweetheart" deal. Unfortunately, something NEEDS to change since the attorneys won't (en masse) stand up for ethics (rather making a show to please the "rules" and apparently the judges). I read that many attorneys are underemployed. Seems wisdom would be to cull the herd and get rid of the rotting apples in practice and on the bench, for everyone's sake as well as justice. I'd like to file an attorney complaint, but I have little faith in anything (other than the most flagrant and obvious) resulting in action. My own belief is that if this was medicine, there'd be maimed and injured all over and the carnage caused by "the profession" would be difficult to hide. One can dream ... meanwhile, back to figuring out to file a pro se "motion to dismiss" as well as another court required paper that Indiana is so fond of providing NO resources for (unlike many other states, who don't automatically assume that citizens involved in the court process are scumbags) so that maybe I can get the family law attorney - whose work left me with no settlement, no possessions and resulted in the death of two pets (etc ad nauseum) - to stop abusing the proceedings supplemental and small claims rules and using it as a vehicle for harassment and apparently, amusement.

  3. Been on social security sense sept 2011 2massive strokes open heart surgery and serious ovarian cancer and a blood clot in my lung all in 14 months. Got a letter in may saying that i didn't qualify and it was in form like i just applied ,called social security she said it don't make sense and you are still geting a check in june and i did ,now i get a check from my part D asking for payment for july because there will be no money for my membership, call my prescription coverage part D and confirmed no check will be there.went to social security they didn't want to answer whats going on just said i should of never been on it .no one knows where this letter came from was California im in virginia and been here sense my strokes and vcu filed for my disability i was in the hospital when they did it .It's like it was a error . My ,mothers social security was being handled in that office in California my sister was dealing with it and it had my social security number because she died last year and this letter came out of the same office and it came at the same time i got the letter for my mother benefits for death and they had the same date of being typed just one was on the mail Saturday and one on Monday. . I think it's a mistake and it should been fixed instead there just getting rid of me .i never got a formal letter saying when i was being tsken off.

  4. Employers should not have racially discriminating mind set. It has huge impact on the society what the big players do or don't do in the industry. Background check is conducted just to verify whether information provided by the prospective employee is correct or not. It doesn't have any direct combination with the rejection of the employees. If there is rejection, there should be something effective and full-proof things on the table that may keep the company or the people associated with it in jeopardy.

  5. Unlike the federal judge who refused to protect me, the Virginia State Bar gave me a hearing. After the hearing, the Virginia State Bar refused to discipline me. VSB said that attacking me with the court ADA coordinator had, " all the grace and charm of a drive-by shooting." One does wonder why the VSB was able to have a hearing and come to that conclusion, but the federal judge in Indiana slammed the door of the courthouse in my face.

ADVERTISEMENT