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

facebook - twitter on Facebook & Twitter

Indiana State Bar Association

Indianapolis Bar Association

Evansville Bar Association

Allen County Bar Association

Indiana Lawyer on Facebook

facebook
ADVERTISEMENT
Subscribe to Indiana Lawyer
  1. I don't agree that this is an extreme case. There are more of these people than you realize - people that are vindictive and/or with psychological issues have clogged the system with baseless suits that are costly to the defendant and to taxpayers. Restricting repeat offenders from further abusing the system is not akin to restricting their freedon, but to protecting their victims, and the court system, from allowing them unfettered access. From the Supreme Court opinion "he has burdened the opposing party and the courts of this state at every level with massive, confusing, disorganized, defective, repetitive, and often meritless filings."

  2. So, if you cry wolf one too many times courts may "restrict" your ability to pursue legal action? Also, why is document production equated with wealth? Anyone can "produce probably tens of thousands of pages of filings" if they have a public library card. I understand this is an extreme case, but our Supreme Court really got this one wrong.

  3. He called our nation a nation of cowards because we didn't want to talk about race. That was a cheap shot coming from the top cop. The man who decides who gets the federal government indicts. Wow. Not a gentleman if that is the measure. More importantly, this insult delivered as we all understand, to white people-- without him or anybody needing to explain that is precisely what he meant-- but this is an insult to timid white persons who fear the government and don't want to say anything about race for fear of being accused a racist. With all the legal heat that can come down on somebody if they say something which can be construed by a prosecutor like Mr Holder as racist, is it any wonder white people-- that's who he meant obviously-- is there any surprise that white people don't want to talk about race? And as lawyers we have even less freedom lest our remarks be considered violations of the rules. Mr Holder also demonstrated his bias by publically visiting with the family of the young man who was killed by a police offering in the line of duty, which was a very strong indicator of bias agains the offer who is under investigation, and was a failure to lead properly by letting his investigators do their job without him predetermining the proper outcome. He also has potentially biased the jury pool. All in all this worsens race relations by feeding into the perception shared by whites as well as blacks that justice will not be impartial. I will say this much, I do not blame Obama for all of HOlder's missteps. Obama has done a lot of things to stay above the fray and try and be a leader for all Americans. Maybe he should have reigned Holder in some but Obama's got his hands full with other problelms. Oh did I mention HOlder is a bank crony who will probably get a job in a silkstocking law firm working for millions of bucks a year defending bankers whom he didn't have the integrity or courage to hold to account for their acts of fraud on the United States, other financial institutions, and the people. His tenure will be regarded by history as a failure of leadership at one of the most important jobs in our nation. Finally and most importantly besides him insulting the public and letting off the big financial cheats, he has been at the forefront of over-prosecuting the secrecy laws to punish whistleblowers and chill free speech. What has Holder done to vindicate the rights of privacy of the American public against the illegal snooping of the NSA? He could have charged NSA personnel with violations of law for their warrantless wiretapping which has been done millions of times and instead he did not persecute a single soul. That is a defalcation of historical proportions and it signals to the public that the government DOJ under him was not willing to do a damn thing to protect the public against the rapid growth of the illegal surveillance state. Who else could have done this? Nobody. And for that omission Obama deserves the blame too. Here were are sliding into a police state and Eric Holder made it go all the faster.

  4. JOE CLAYPOOL candidate for Superior Court in Harrison County - Indiana This candidate is misleading voters to think he is a Judge by putting Elect Judge Joe Claypool on his campaign literature. paragraphs 2 and 9 below clearly indicate this injustice to voting public to gain employment. What can we do? Indiana Code - Section 35-43-5-3: Deception (a) A person who: (1) being an officer, manager, or other person participating in the direction of a credit institution, knowingly or intentionally receives or permits the receipt of a deposit or other investment, knowing that the institution is insolvent; (2) knowingly or intentionally makes a false or misleading written statement with intent to obtain property, employment, or an educational opportunity; (3) misapplies entrusted property, property of a governmental entity, or property of a credit institution in a manner that the person knows is unlawful or that the person knows involves substantial risk of loss or detriment to either the owner of the property or to a person for whose benefit the property was entrusted; (4) knowingly or intentionally, in the regular course of business, either: (A) uses or possesses for use a false weight or measure or other device for falsely determining or recording the quality or quantity of any commodity; or (B) sells, offers, or displays for sale or delivers less than the represented quality or quantity of any commodity; (5) with intent to defraud another person furnishing electricity, gas, water, telecommunication, or any other utility service, avoids a lawful charge for that service by scheme or device or by tampering with facilities or equipment of the person furnishing the service; (6) with intent to defraud, misrepresents the identity of the person or another person or the identity or quality of property; (7) with intent to defraud an owner of a coin machine, deposits a slug in that machine; (8) with intent to enable the person or another person to deposit a slug in a coin machine, makes, possesses, or disposes of a slug; (9) disseminates to the public an advertisement that the person knows is false, misleading, or deceptive, with intent to promote the purchase or sale of property or the acceptance of employment;

  5. The story that you have shared is quite interesting and also the information is very helpful. Thanks for sharing the article. For more info: http://www.treasurecoastbailbonds.com/

ADVERTISEMENT