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. State Farm is sad and filled with woe Edward Rust is no longer CEO He had knowledge, but wasn’t in the know The Board said it was time for him to go All American Girl starred Margaret Cho The Miami Heat coach is nicknamed Spo I hate to paddle but don’t like to row Edward Rust is no longer CEO The Board said it was time for him to go The word souffler is French for blow I love the rain but dislike the snow Ten tosses for a nickel or a penny a throw State Farm is sad and filled with woe Edward Rust is no longer CEO Bambi’s mom was a fawn who became a doe You can’t line up if you don’t get in a row My car isn’t running, “Give me a tow” He had knowledge but wasn’t in the know The Board said it was time for him to go Plant a seed and water it to make it grow Phases of the tide are ebb and flow If you head isn’t hairy you don’t have a fro You can buff your bald head to make it glow State Farm is sad and filled with woe Edward Rust is no longer CEO I like Mike Tyson more than Riddick Bowe A mug of coffee is a cup of joe Call me brother, don’t call me bro When I sing scat I sound like Al Jarreau State Farm is sad and filled with woe The Board said it was time for him to go A former Tigers pitcher was Lerrin LaGrow Ursula Andress was a Bond girl in Dr. No Brian Benben is married to Madeline Stowe Betsy Ross couldn’t knit but she sure could sew He had knowledge but wasn’t in the know Edward Rust is no longer CEO Grand Funk toured with David Allan Coe I said to Shoeless Joe, “Say it ain’t so” Brandon Lee died during the filming of The Crow In 1992 I didn’t vote for Ross Perot State Farm is sad and filled with woe The Board said it was time for him to go A hare is fast and a tortoise is slow The overhead compartment is for luggage to stow Beware from above but look out below I’m gaining momentum, I’ve got big mo He had knowledge but wasn’t in the know Edward Rust is no longer CEO I’ve travelled far but have miles to go My insurance company thinks I’m their ho I’m not their friend but I am their foe Robin Hood had arrows, a quiver and a bow State Farm has a lame duck CEO He had knowledge, but wasn’t in the know The Board said it was time for him to go State Farm is sad and filled with woe

  2. The ADA acts as a tax upon all for the benefit of a few. And, most importantly, the many have no individual say in whether they pay the tax. Those with handicaps suffered in military service should get a pass, but those who are handicapped by accident or birth do NOT deserve that pass. The drivel about "equal access" is spurious because the handicapped HAVE equal access, they just can't effectively use it. That is their problem, not society's. The burden to remediate should be that of those who seek the benefit of some social, constructional, or dimensional change, NOT society generally. Everybody wants to socialize the costs and concentrate the benefits of government intrusion so that they benefit and largely avoid the costs. This simply maintains the constant push to the slop trough, and explains, in part, why the nation is 20 trillion dollars in the hole.

  3. Hey 2 psychs is never enough, since it is statistically unlikely that three will ever agree on anything! New study admits this pseudo science is about as scientifically valid as astrology ... done by via fortune cookie ....John Ioannidis, professor of health research and policy at Stanford University, said the study was impressive and that its results had been eagerly awaited by the scientific community. “Sadly, the picture it paints - a 64% failure rate even among papers published in the best journals in the field - is not very nice about the current status of psychological science in general, and for fields like social psychology it is just devastating,” he said. http://www.theguardian.com/science/2015/aug/27/study-delivers-bleak-verdict-on-validity-of-psychology-experiment-results

  4. Indianapolis Bar Association President John Trimble and I are on the same page, but it is a very large page with plenty of room for others to join us. As my final Res Gestae article will express in more detail in a few days, the Great Recession hastened a fundamental and permanent sea change for the global legal service profession. Every state bar is facing the same existential questions that thrust the medical profession into national healthcare reform debates. The bench, bar, and law schools must comprehensively reconsider how we define the practice of law and what it means to access justice. If the three principals of the legal service profession do not recast the vision of their roles and responsibilities soon, the marketplace will dictate those roles and responsibilities without regard for the public interests that the legal profession professes to serve.

  5. I have met some highly placed bureaucrats who vehemently disagree, Mr. Smith. This is not your father's time in America. Some ideas are just too politically incorrect too allow spoken, says those who watch over us for the good of their concept of order.

ADVERTISEMENT