{"id":305245,"date":"2026-07-25T00:51:27","date_gmt":"2026-07-25T00:51:27","guid":{"rendered":"https:\/\/www.newsbeep.com\/us-ny\/305245\/"},"modified":"2026-07-25T00:51:27","modified_gmt":"2026-07-25T00:51:27","slug":"using-excel-to-track-and-grow-business","status":"publish","type":"post","link":"https:\/\/www.newsbeep.com\/us-ny\/305245\/","title":{"rendered":"Using Excel to Track and Grow Business"},"content":{"rendered":"<p>\t\t\t\tUsing Excel to Track and Grow Business<\/p>\n<p class=\"sr-only\">7.24.2026<\/p>\n<p class=\"sr-only author\">By Jennifer Andrus <\/p>\n<p>\t\t\t\t<img fetchpriority=\"high\" decoding=\"async\" class=\"wpa-warning wpa-image-missing-alt alignnone wp-image-187295\" src=\"https:\/\/www.newsbeep.com\/us-ny\/wp-content\/uploads\/2026\/07\/shutterstock_1946220391-768x512.jpg\" alt=\"\" width=\"510\" height=\"340\" data-warning=\"Missing alt text\"  \/><\/p>\n<p>Lawyers may excel in learning case law, but a working knowledge of Excel spreadsheets and other bookkeeping tasks can be daunting. A recent program sponsored by the New York State Bar Association offered tips and tricks to better navigate spreadsheet programs.<\/p>\n<p>The <a href=\"https:\/\/nysba.org\/products\/microsoft-excel-tips-tricks-for-lawyers\/\" target=\"_blank\" rel=\"noopener nofollow\">webinar<\/a> was presented by Jordan Turk, a family law attorney in Texas and the director of education and attorney development at Smokeball. Turk says that understanding technology is more than just good business \u2013 it\u2019s an ethical consideration. Forty states including New York have adopted an ethical standard relating to technology. One has a duty, Turk said, to keep abreast of the benefits and risks of technology used in law practice management. The <a href=\"https:\/\/nysba.org\/products\/microsoft-excel-tips-tricks-for-lawyers\/\" target=\"_blank\" rel=\"noopener nofollow\">webinar<\/a> is free to view on-demand for members and available for purchase by non-members.<\/p>\n<p>\u201cI have seen some attorneys, especially in family law, outsource their Excel work, which to me is unacceptable,\u201d Turk said. \u201cWe have a duty to be competent in the tech we use, and Excel is vital to certain areas of law.\u201d<\/p>\n<p>For those still using pen, paper and a calculator as organizational tools, a basic knowledge of Microsoft Excel can help streamline the workflow, organize case data, support compliance and improve day-to-day practice management. Saving time on bookkeeping leaves more time for other more substantive work.<\/p>\n<p>Formatting and Customizing A Spreadsheet <\/p>\n<p>The hour-long demonstration is available to members as an on-demand video. Turk shows viewers how to customize the size, font, dates and toolbars. She also instructs viewers on how to freeze cells and protect worksheets with locking functions and password protection.<\/p>\n<p>\u201cYou can designate files as read only so that staff cannot save over or rewrite your work. This protection includes an option to add a password for an extra level of security,\u201d she said.<\/p>\n<p>Lastly, Turk demonstrates several SUM formulas to track work hours for lawyers and staff. This includes how to multiply an hourly rate and track projected revenue.<\/p>\n<p>Bottom Line: Get Comfortable With Data <\/p>\n<p>\u201cBecoming more comfortable with Excel means that you get more comfortable with your law firm data. You can start creating things like pivot tables and data forecasting,\u201d she said. \u201cFor instance, you can forecast what it would take to make 20% more next year based on this year\u2019s numbers.\u201d<\/p>\n<p>Turk closed the webinar by reminding attendees that NYSBA members have access to free trust accounts and billing software from Smokeball. Access to Smokeball is available on the member dashboard.<\/p>\n<p>The <a href=\"https:\/\/nysba.org\/products\/microsoft-excel-tips-tricks-for-lawyers\/\" target=\"_blank\" rel=\"noopener nofollow\">webinar<\/a> was sponsored by the NYSBA Committees on Law Practice Management, Technology and the Legal Profession and Continuing Legal Education.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"wpa-warning wpa-long-alt size-full wp-image-306492 aligncenter\" src=\"https:\/\/www.newsbeep.com\/us-ny\/wp-content\/uploads\/2026\/07\/Excel-Infographic-1.png\" alt=\"Infographic listing essential MS Excel shortcuts: Ctrl+Z undo, Ctrl+N new file, Ctrl+S save, Ctrl+A highlight all, Ctrl+C copy, Ctrl+V paste, F2 edit cell, F7 run spellcheck.\" width=\"300\" height=\"550\" data-warning=\"Long alt text\"\/><\/p>\n<p>\u00a0<\/p>\n<p>\u00a0<\/p>\n<p>\u00a0<\/p>\n<p>\u00a0<\/p>\n<p>\u00a0<\/p>\n","protected":false},"excerpt":{"rendered":"Using Excel to Track and Grow Business 7.24.2026 By Jennifer Andrus Lawyers may excel in learning case law,&hellip;\n","protected":false},"author":2,"featured_media":305246,"comment_status":"","ping_status":"","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[6],"tags":[9,11,10,49,51,50],"class_list":["post-305245","post","type-post","status-publish","format-standard","has-post-thumbnail","category-new-york","tag-new-york","tag-new-york-headlines","tag-new-york-news","tag-new-york-state","tag-new-york-state-headlines","tag-new-york-state-news"],"_links":{"self":[{"href":"https:\/\/www.newsbeep.com\/us-ny\/wp-json\/wp\/v2\/posts\/305245","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.newsbeep.com\/us-ny\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.newsbeep.com\/us-ny\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.newsbeep.com\/us-ny\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.newsbeep.com\/us-ny\/wp-json\/wp\/v2\/comments?post=305245"}],"version-history":[{"count":0,"href":"https:\/\/www.newsbeep.com\/us-ny\/wp-json\/wp\/v2\/posts\/305245\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.newsbeep.com\/us-ny\/wp-json\/wp\/v2\/media\/305246"}],"wp:attachment":[{"href":"https:\/\/www.newsbeep.com\/us-ny\/wp-json\/wp\/v2\/media?parent=305245"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.newsbeep.com\/us-ny\/wp-json\/wp\/v2\/categories?post=305245"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.newsbeep.com\/us-ny\/wp-json\/wp\/v2\/tags?post=305245"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}