Microsoft Excel tips and tricks for accountants

<!DOCTYPE html> <html prefix="og: http://ogp.me/ns# article: http://ogp.me/ns/article#" class="no-js"> <head> <title>Microsoft Excel tips and tricks for accountants - Journal of Accountancy</title> <script defer="defer" type="text/javascript" src="https://rum.hlx.page/.rum/@adobe/helix-rum-js@%5E2/dist/rum-standalone.js" data-routing="p00000-e000000"></script> <link rel="shortcut icon" href="/content/dam/jofa/favicons/favicon.ico"/> <link rel="apple-touch-icon-precomposed" sizes="57x57" href="/content/dam/jofa/favicons/apple-touch-icon-57x57.png"/> <link rel="apple-touch-icon-precomposed" sizes="114x114" href="/content/dam/jofa/favicons/apple-touch-icon-114x114.png"/> <link rel="apple-touch-icon-precomposed" sizes="72x72" href="/content/dam/jofa/favicons/apple-touch-icon-72x72.png"/> <link rel="apple-touch-icon-precomposed" sizes="144x144" href="/content/dam/jofa/favicons/apple-touch-icon-144x144.png"/> <link rel="apple-touch-icon-precomposed" sizes="60x60" href="/content/dam/jofa/favicons/apple-touch-icon-60x60.png"/> <link rel="apple-touch-icon-precomposed" sizes="120x120" href="/content/dam/jofa/favicons/apple-touch-icon-120x120.png"/> <link rel="apple-touch-icon-precomposed" sizes="76x76" href="/content/dam/jofa/favicons/apple-touch-icon-76x76.png"/> <link rel="apple-touch-icon-precomposed" sizes="152x152" href="/content/dam/jofa/favicons/apple-touch-icon-152x152.png"/> <link rel="icon" type="image/png" sizes="196x196" href="/content/dam/jofa/favicons/favicon-196x196.png"/> <link rel="icon" type="image/png" sizes="96x96" href="/content/dam/jofa/favicons/favicon-96x96.png"/> <link rel="icon" type="image/png" sizes="32x32" href="/content/dam/jofa/favicons/favicon-32x32.png"/> <link rel="icon" type="image/png" sizes="16x16" href="/content/dam/jofa/favicons/favicon-16x16.png"/> <link rel="icon" type="image/png" sizes="128x128" href="/content/dam/jofa/favicons/favicon-128.png"/> <meta name="msapplication-TileColor" content="#FFFFFF" /> <meta name="msapplication-TileImage" content="/content/dam/jofa/favicons/mstile-144x144.png" /> <meta name="msapplication-square70x70logo" content="/content/dam/jofa/favicons/mstile-70x70.png" /> <meta name="msapplication-square310x310logo" content="/content/dam/jofa/favicons/mstile-310x310.png" /> <link rel="canonical" href="https://www.journalofaccountancy.com/topics/technology/microsoft-excel-tips.html"/> <meta http-equiv="X-UA-Compatible" content="IE=edge"> <meta charset="utf-8"> <meta name="viewport" content="width=device-width, initial-scale=1"> <meta name="msapplication-tap-highlight" content="no"> <meta name="referrer" content="no-referrer-when-downgrade"> <meta property="og:title" content="Microsoft Excel tips and tricks for accountants - Journal of Accountancy"/> <meta property="og:type" content="website"/> <meta property="og:url" content="https://www.journalofaccountancy.com/topics/technology/microsoft-excel-tips.html"/> <meta name="description" content="Microsoft Excel tips, tricks, and ideas for accountants and CPAs."/> <meta property="og:site_name" content="Journal of Accountancy"/> <meta property="fb:app_id" content="613882402074338"/> <meta property="og:image" content="https://www.journalofaccountancy.com/content/dam/fmm/news/excel-models-720.jpg"/> <script src="https://ajax.googleapis.com/ajax/libs/jquery/3.5.1/jquery.min.js"></script> <script> window.jQuery || document.write("<script src='/etc/clientlibs/dot-org/assets/jquery.min.js'><\/script>"); </script>  <link rel="stylesheet" href="/etc/clientlibs/aicpa/assets/publish.min.css" type="text/css"> <link rel="stylesheet" href="/etc/clientlibs/aicpa/assets.min.css" type="text/css"> <link rel="stylesheet" href="/etc/clientlibs/aicpa/assets/components-footer.min.css" type="text/css"> <script type="text/javascript" src="/content/jofa-home/topics/technology/microsoft-excel-tips/_jcr_content.adproperties.js"></script> <script src="/etc/clientlibs/aicpa/assets/vendor/modernizr.min.js"></script> <script src="/etc/clientlibs/aicpa/assets/components-header.min.js"></script> <script type="text/javascript" src="/etc/cloudservices/doubleclick-ads/jofa/_jcr_content.js"></script>  <script>(function(w,d,s,l,i){w[l]=w[l]||[];w[l].push({'gtm.start': new Date().getTime(),event:'gtm.js'});var f=d.getElementsByTagName(s)[0], j=d.createElement(s),dl=l!='dataLayer'?'&l='+l:'';j.async=true;j.src= 'https://www.googletagmanager.com/gtm.js?id='+i+dl;f.parentNode.insertBefore(j,f); })(window,document,'script','dataLayer','GTM-ND9QBJ6');</script>  <script> !function(f,b,e,v,n,t,s){if(f.fbq)return;n=f.fbq=function(){n.callMethod? n.callMethod.apply(n,arguments):n.queue.push(arguments)};if(!f._fbq)f._fbq=n; n.push=n;n.loaded=!0;n.version='2.0';n.queue=[];t=b.createElement(e);t.async=!0; t.src=v;s=b.getElementsByTagName(e)[0];s.parentNode.insertBefore(t,s)}(window, document,'script','https://connect.facebook.net/en_US/fbevents.js'); fbq('init', '1572149056410857'); // Insert your pixel ID here. fbq('track', 'PageView'); </script> <noscript><img height="1" width="1" style="display:none" src="https://www.facebook.com/tr?id=1572149056410857&ev=PageView&noscript=1"/></noscript>  <script> var webData = [{ page: { pageName: "journal of accountancy:topics:technology:microsoft-excel-tips", siteProperty: "journal of accountancy", siteSection: "topics", siteSubSection: "technology", siteHierarchy: "journal of accountancy|topics|technology", contentType: "" } }]; </script> <script src="https://assets.adobedtm.com/launch-EN2c0e28c6709c4e27a936ae1de1381bd2.min.js" integrity="sha384-0oD5l4LMjgfnMWxxFyeyqSUFT3lS5cnne4UZi9a5CoVhGGctt4V3egBrlto3uzhH" crossorigin="anonymous"></script><link rel="stylesheet" href="/etc/clientlibs/jofa/assets/components-header.min.css" type="text/css"> <link rel="stylesheet" media="print" href="/etc/clientlibs/jofa/assets/print.css" type="text/css"> </head> <body class="generalPage">  <noscript><iframe src="https://www.googletagmanager.com/ns.html?id=GTM-ND9QBJ6" height="0" width="0" style="display:none;visibility:hidden"></iframe></noscript> <div class="header iparsys parsys"><div class="section"><div class="new"></div> </div><div class="iparys_inherited"><div class="header iparsys parsys"><div class="integratedheader section"><div class="cookieBanner"><div class="container hidden"> <div class="row"> <div class="cookie-banner" id=""> <a class="banner-close" href="#" title=""> <span class="icon-exit"></span> <span class="hidden-xs"></span> </a> <p>This site uses cookies to store information on your computer. Some are essential to make our site work; others help us improve the user experience. By using the site, you consent to the placement of these cookies. Read our <a href="https://www.aicpa-cima.com/help/privacy-policy" target="_blank">privacy policy</a> to learn more.</p> </div> </div> </div> </div> <nav class="navbar" role="navigation"> <div class="container navbar-container"> <div class="hidden-xs hidden-sm collapse navbar-collapse utility-collapse"> <div class="top-logo logo"><a class='navbar-brand' target="_blank" href="https://www.aicpa-cima.com"> <div data-picture data-alt='AICPA-CIMA'> <div data-src='/content/dam/jofa/info/aicpa-cima-new.png' data-media></div> <img src='/content/dam/jofa/info/aicpa-cima-new.png' alt='AICPA-CIMA'> </div> </a> </div> <div class="tagline"></div> <div class="top-navlinks links"><ul class="nav navbar-nav navbar-right" data-event=""> <li><p>AICPA & CIMA:</p></li> <li><a title="" href="https://www.aicpa-cima.com/home"><span>Home</span></a> <li><a title="" href="https://www.aicpa-cima.com/cpe-learning"><span>CPE & Learning</span></a> <li><a title="" href="https://www.aicpa-cima.com/login"><span>My Account</span></a> </ul> </div> </div> <div class="navbar-header"> <button type="button" class="navbar-toggle search-toggle collapsed" data-toggle="collapse" data-target="#search-collapse"> <span class="sr-only">Toggle search</span> <span class="icon-search"></span> </button> <button type="button" class="navbar-toggle navigation-toggle collapsed" data-toggle="collapse" data-target="#navigation-collapse"> <span class="sr-only">Toggle navigation</span> <span class="icon-bar"></span> <span class="icon-bar"></span> <span class="icon-bar"></span> </button> <div class="logo"><a class='navbar-brand' href="/"> <div data-picture data-alt='Journal of Accountancy'> <div data-src='/content/dam/jofa-test/header/logo.png' data-media></div> <img src='/content/dam/jofa-test/header/logo.png' alt='Journal of Accountancy'> </div> </a> </div> </div> <div class="collapse navbar-collapse search-collapse" id="search-collapse"> <div class="searchbar"><form action="/search.html" class="navbar-form navbar-right" role="search" accept-charset="UTF-8"> <input type="hidden" name="_charset_" value="utf-8"> <div class="form-group input-group"> <input type="text" name="q" class="form-control" value="" placeholder=""> <input type="hidden" name="language" value="en"> <div class="input-group-btn"> <button type="submit" class="btn btn-search" tabindex="-1"> <span class="icon-search"></span> </button> </div> </div> </form> </div> </div> <div class="collapse navbar-collapse navigation-collapse" id="navigation-collapse"> <div class="navbar-nav-container"> <ul class="nav navbar-nav"> <li class="dropdown"> <a href="/topics/technology.html" target="" class="dropdown-toggle active" data-toggle="dropdown"> Tech & AI</a> <div class="dropdown-menu" role="menu"> <ul> <li> <a href="/topics/technology.html" target=""> All articles</a> </li> <li> <a href="/topics/artificial-intelligence-ai.html" target=""> Artificial Intelligence (AI)</a> </li> <li> <a href="/topics/technology/microsoft-excel-tips.html" target="" class="active"> Microsoft Excel</a> </li> <li> <a href="/topics/technology/data-information-security.html" target=""> Information Security & Privacy</a> </li> </ul> <div class="dropdown-feature" id="beb3db1d-e86a-46fc-b822-b69676b7679d"> <h4>Latest Stories</h4> <ul class="main-nav-feature-list"> <script type="text/x-template" id="beb3db1d-e86a-46fc-b822-b69676b7679d-main-nav-template"> <li><a href="{page.path}.html">{articleTitle}</a></li> </script> </ul> </div> </div> <script> jQuery(document).ready(function () { jQuery('#beb3db1d-e86a-46fc-b822-b69676b7679d').mainnav({ componentPath: '/content/jofa-home/jcr:content/header/integratedheader/mainNav1', locale: "en" }); }); </script> </li> <li class="dropdown"> <a href="/topics/tax.html" target="" class="dropdown-toggle" data-toggle="dropdown"> TAX</a> <div class="dropdown-menu" role="menu"> <ul> <li> <a href="/topics/tax.html" target=""> All articles</a> </li> <li> <a href="/topics/tax/corporations.html" target=""> Corporations</a> </li> <li> <a href="/topics/tax/employee-benefits.html" target=""> Employee benefits</a> </li> <li> <a href="/topics/tax/individual-income-taxation.html" target=""> Individuals</a> </li> <li> <a href="/topics/tax/irs-practice-procedure.html" target=""> IRS procedure</a> </li> </ul> <div class="dropdown-feature" id="d6496f26-4c8d-471b-b5e6-2e94e848d22a"> <h4>Latest Stories</h4> <ul class="main-nav-feature-list"> <script type="text/x-template" id="d6496f26-4c8d-471b-b5e6-2e94e848d22a-main-nav-template"> <li><a href="{page.path}.html">{articleTitle}</a></li> </script> </ul> </div> </div> <script> jQuery(document).ready(function () { jQuery('#d6496f26-4c8d-471b-b5e6-2e94e848d22a').mainnav({ componentPath: '/content/jofa-home/jcr:content/header/integratedheader/mainNav2', locale: "en" }); }); </script> </li> <li class="dropdown"> <a href="/topics/practice-management.html" target="" class="dropdown-toggle" data-toggle="dropdown"> PRACTICE MANAGEMENT</a> <div class="dropdown-menu" role="menu"> <ul> <li> <a href="/topics/practice-management.html" target=""> All articles</a> </li> <li> <a href="/topics/practice-management/diversity-equity-inclusion.html" target=""> Diversity, equity & inclusion</a> </li> <li> <a href="/topics/practice-management/human-capital.html" target=""> Human capital</a> </li> <li> <a href="/topics/practice-management/financial-admin-operations.html" target=""> Firm operations</a> </li> <li> <a href="/topics/practice-management/practice-growth-client-service.html" target=""> Practice growth & client service</a> </li> </ul> <div class="dropdown-feature" id="8795f6a3-d2f0-476f-a69a-6abd5ece16b3"> <h4>Latest Stories</h4> <ul class="main-nav-feature-list"> <script type="text/x-template" id="8795f6a3-d2f0-476f-a69a-6abd5ece16b3-main-nav-template"> <li><a href="{page.path}.html">{articleTitle}</a></li> </script> </ul> </div> </div> <script> jQuery(document).ready(function () { jQuery('#8795f6a3-d2f0-476f-a69a-6abd5ece16b3').mainnav({ componentPath: '/content/jofa-home/jcr:content/header/integratedheader/mainNav3', locale: "en" }); }); </script> </li> <li class="dropdown"> <a href="/topics/financial-reporting.html" target="" class="dropdown-toggle" data-toggle="dropdown"> FINANCIAL REPORTING</a> <div class="dropdown-menu" role="menu"> <ul> <li> <a href="/topics/financial-reporting.html" target=""> All articles</a> </li> <li> <a href="/topics/financial-reporting/us-accounting-financial-reporting.html" target=""> FASB reporting</a> </li> <li> <a href="/topics/financial-reporting/ifrs-compliance-reporting.html" target=""> IFRS</a> </li> <li> <a href="/topics/financial-reporting/private-company-financial-reporting.html" target=""> Private company reporting</a> </li> <li> <a href="/topics/financial-reporting/sec-compliance-reporting.html" target=""> SEC compliance and reporting</a> </li> </ul> <div class="dropdown-feature" id="ce0e36a9-1fe0-47be-89df-b2e18c97a17c"> <h4>Latest Stories</h4> <ul class="main-nav-feature-list"> <script type="text/x-template" id="ce0e36a9-1fe0-47be-89df-b2e18c97a17c-main-nav-template"> <li><a href="{page.path}.html">{articleTitle}</a></li> </script> </ul> </div> </div> <script> jQuery(document).ready(function () { jQuery('#ce0e36a9-1fe0-47be-89df-b2e18c97a17c').mainnav({ componentPath: '/content/jofa-home/jcr:content/header/integratedheader/mainNav4', locale: "en" }); }); </script> </li> <li class="dropdown"> <a href="/topics/auditing.html" target="" class="dropdown-toggle" data-toggle="dropdown"> AUDIT</a> <div class="dropdown-menu" role="menu"> <ul> <li> <a href="/topics/auditing.html" target=""> All articles</a> </li> <li> <a href="/topics/auditing/performing-an-attest-engagement.html" target=""> Attestation</a> </li> <li> <a href="/topics/auditing/performing-an-audit.html" target=""> Audit</a> </li> <li> <a href="/topics/auditing/compilation-and-review.html" target=""> Compilation and review</a> </li> <li> <a href="/topics/auditing/peer-review.html" target=""> Peer review</a> </li> <li> <a href="/topics/auditing/quality-management.html" target=""> Quality Management</a> </li> </ul> <div class="dropdown-feature" id="a65ce79d-0237-4046-a8a7-a16fec6f385b"> <h4>Latest Stories</h4> <ul class="main-nav-feature-list"> <script type="text/x-template" id="a65ce79d-0237-4046-a8a7-a16fec6f385b-main-nav-template"> <li><a href="{page.path}.html">{articleTitle}</a></li> </script> </ul> </div> </div> <script> jQuery(document).ready(function () { jQuery('#a65ce79d-0237-4046-a8a7-a16fec6f385b').mainnav({ componentPath: '/content/jofa-home/jcr:content/header/integratedheader/mainNav5', locale: "en" }); }); </script> </li> <li class="dropdown"> <a href="/topics/management-accounting.html" target="" class="dropdown-toggle" data-toggle="dropdown"> MANAGEMENT ACCOUNTING</a> <div class="dropdown-menu" role="menu"> <ul> <li> <a href="/topics/management-accounting.html" target=""> All articles</a> </li> <li> <a href="/topics/management-accounting/planning-budgeting-forecasting.html" target=""> Business planning</a> </li> <li> <a href="/topics/management-accounting/hr-talent-management.html" target=""> Human resources</a> </li> <li> <a href="/topics/management-accounting/risk-management-internal-control.html" target=""> Risk management</a> </li> <li> <a href="/topics/management-accounting/strategy-governance.html" target=""> Strategy</a> </li> </ul> <div class="dropdown-feature" id="3e91de3a-3acc-464c-96ca-29b7e3858e4e"> <h4>Latest Stories</h4> <ul class="main-nav-feature-list"> <script type="text/x-template" id="3e91de3a-3acc-464c-96ca-29b7e3858e4e-main-nav-template"> <li><a href="{page.path}.html">{articleTitle}</a></li> </script> </ul> </div> </div> <script> jQuery(document).ready(function () { jQuery('#3e91de3a-3acc-464c-96ca-29b7e3858e4e').mainnav({ componentPath: '/content/jofa-home/jcr:content/header/integratedheader/mainNav6', locale: "en" }); }); </script> </li> </ul> </div> <ul class="nav navbar-nav navbar-right" data-event=""> <li><a title="" href="/news.html"><span>News</span></a> <li><a title="" href="/issues/2025/mar.html"><span>Magazine</span></a> <li><a title="" href="/podcast.html"><span>Podcast</span></a> <li><a title="" href="/videos.html"><span>Video</span></a> </ul> </div> </div> </nav> <script> jQuery(document).ready(function(){ methods.androidSearchbarCollapseHandler(); }); </script> </div> </div> </div> </div> <main role="main" class="container"> <div class="row"> <div class="col-sm-12"> <div class="hero-section parsys"> </div> </div> </div> <div class="row"> <div class="col-sm-12"> <div class="advertisement-section iparsys parsys"><div class="section"><div class="new"></div> </div><div class="iparys_inherited"><div class="advertisement-section iparsys parsys"><div class="doubleclickAds section"><div class="advertisement"> <div id="jofa-adslot-0"> <script type="text/javascript"> googletag.cmd.push(function () { googletag.display('jofa-adslot-0'); }); </script> </div> </div> <br> </div> <div class="breakingnews section"><div id="25adfc00-dcce-450b-b92e-c828d0c795c0" data-event="" class="breaking-news" style="display:none" > <div class="well clearfix"> <span class="section-header"> Breaking News</span> <div class="breaking-news-template-section"></div> </div> </div> <script type="text/x-template" id="breaking-news-template"> <div data-picture class='hidden-xs pull-left' data-alt='{featureImage.alt}'> {@ne key="{featureImage.renditions.default}" value=""} <div data-src='{featureImage.renditions.default}' data-media></div> <img src='{featureImage.renditions.default}' alt='{featureImage.alt}'> {/ne} {#featureImage.renditions.breakpoints} <div data-src="{path}" data-media="{media}"></div> {/featureImage.renditions.breakpoints} </div> <article> {@if cond="{isRecent}"} <div class="date-time recent-time"> {timeSince} </div> {:else} <div class="date-time"> {timeSince} </div> {/if} <h2> <a href="{page.path}.html"> {articleTitle} </a> </h2> <p> {articleAbstract} </p> </article> </script> <script> jQuery(document).ready(function () { jQuery('#25adfc00-dcce-450b-b92e-c828d0c795c0').breakingnews({componentPath: '/content/jofa-home/jcr:content/advertisement-section/breakingnews', locale: "en", currentPath: "/topics/technology/microsoft-excel-tips"}); }); </script> </div> </div> </div> </div> </div> </div> <div class="row clearfix content content-two-col"> <div id="mainbar-top" class="col-sm-8 mainbar mainbar-top"> <div> <div class="main-content-section parsys"><div class="topicslisting section"><div class="topics-listing" data-event=""> <ol class="breadcrumb"> <li> <a href="#">TOPICS</a> </li> </ol> <div class="row"> <div class="col-md-12 article-list"> <h1>Microsoft Excel</h1> <article id="topic-article"> <div class="date-time" data-time="2025-03-01T05:00:00.000-05:00"></div> <h1><a href="/issues/2025/mar/doing-accounts-receivable-aging-reports-in-excel.html">Doing accounts receivable aging reports in Excel</a></h1> <p>This article provides an example of building a dynamic AR aging schedule in Excel.</p> </article> <article id="topic-article"> <div class="date-time" data-time="2025-02-01T05:00:00.000-05:00"></div> <h1><a href="/issues/2025/feb/how-to-use-excels-unique-function.html">How to use Excel鈥檚 UNIQUE Function</a></h1> <p>Excel鈥檚 UNIQUE function allows users to extract unique values from a dataset, making it easier to identify and remove duplicates.</p> </article> <article id="topic-article"> <div class="date-time" data-time="2025-01-01T05:00:00.000-05:00"></div> <h1><a href="/issues/2025/jan/using-excels-what-if-analysis-with-data-table-for-data-analysis.html">Using Excel鈥檚 What-If Analysis with Data Table for data analysis</a></h1> <p>This column shows how to use the Data Table option in Excel鈥檚 What-If Analysis tool.</p> </article> <article id="topic-article"> <div class="date-time" data-time="2024-12-01T05:00:00.000-05:00"></div> <h1><a href="/issues/2024/dec/using-excels-goal-seek-for-data-analysis.html">Using Excel鈥檚 Goal Seek for data analysis</a></h1> <p>This month鈥檚 column shows how to use Excel鈥檚 Goal Seek for data analysis.</p> </article> <article id="topic-article"> <div class="date-time" data-time="2024-11-01T05:00:00.000-04:00"></div> <h1><a href="/issues/2024/nov/using-excels-scenario-manager-for-decision-making.html">Using Excel鈥檚 Scenario Manager for decision-making</a></h1> <p>This column shows how to quickly project financial possibilities with Excel Scenario Manager.</p> </article> <article id="topic-article"> <div class="date-time" data-time="2024-10-01T05:00:00.000-04:00"></div> <h1><a href="/issues/2024/oct/10-types-of-excel-charts-for-data-visualization.html">10 types of Excel charts for data visualization</a></h1> <p>This column tours of some of the most useful charts, starting with the basic ones and moving to the more advanced.</p> </article> <article id="topic-article"> <div class="date-time" data-time="2024-09-01T05:00:00.000-04:00"></div> <h1><a href="/issues/2024/sep/using-chatgpt-4o-with-excel.html">Using ChatGPT-4o with Excel</a></h1> <p>Learn how to use the new ChatGPT-4o (Omni) to interact with Microsoft Excel.</p> </article> <article id="topic-article"> <div class="date-time" data-time="2024-08-01T05:00:00.000-04:00"></div> <h1><a href="/issues/2024/aug/identify-and-delete-duplicates-in-excel.html">Identify and delete duplicates in Excel</a></h1> <p>This article looks at a few ways to identify duplicates in Excel.</p> </article> <article id="topic-article"> <div class="date-time" data-time="2024-07-01T05:00:00.000-04:00"></div> <h1><a href="/issues/2024/jul/how-to-create-a-watermark-in-excel.html">How to create a watermark in Excel</a></h1> <p>This column shows a couple of ways to create a watermark in Excel.</p> </article> <article id="topic-article"> <div class="date-time" data-time="2024-06-01T05:00:00.000-04:00"></div> <h1><a href="/issues/2024/jun/how-to-find-errors-in-excel-formulas.html">How to find errors in Excel formulas</a></h1> <p>This article looks at how to use Excel鈥檚 auditing tools to audit formulas and ensure the accuracy of data.</p> </article> <article id="topic-article"> <div class="date-time" data-time="2024-05-01T05:00:00.000-04:00"></div> <h1><a href="/issues/2024/may/change-text-to-sentence-case-in-excel.html">Change text to sentence case in Excel</a></h1> <p>In this month鈥檚 column, find out how to change text strings to sentence case in Excel.</p> </article> <article id="topic-article"> <div class="date-time" data-time="2024-04-01T05:00:00.000-04:00"></div> <h1><a href="/issues/2024/apr/move-quickly-with-excels-navigation-pane.html">Move quickly with Excel鈥檚 Navigation Pane</a></h1> <p>The Navigation Pane in Excel is a useful tool that allows users to easily move around and manage large workbooks.</p> </article> <article id="topic-article"> <div class="date-time" data-time="2024-02-01T05:00:00.000-05:00"></div> <h1><a href="/issues/2024/feb/resources-for-advancing-your-microsoft-skills.html">Resources for advancing your Microsoft skills</a></h1> <p>This column discusses the resources available to help sharpen your Microsoft skills.</p> </article> <article id="topic-article"> <div class="date-time" data-time="2024-01-01T05:00:00.000-05:00"></div> <h1><a href="/issues/2024/jan/exploring-excels-dynamic-filter-function.html">Exploring Excel鈥檚 dynamic FILTER function</a></h1> <p>The FILTER function has all the filtering power of the venerable filter feature but can perform more tasks, including setting up automated filters and showing results where the user wants them to be shown.</p> </article> <article id="topic-article"> <div class="date-time" data-time="2023-12-01T05:00:00.000-05:00"></div> <h1><a href="/issues/2023/dec/record-tasks-in-excel-with-automate.html">Record tasks in Excel with Automate</a></h1> <p>The Automate tab allows you to create and run Office Scripts, which allow users to automate tasks in Excel.</p> </article> </div> </div> <div class="text-center"> <ul class="pagination"> <li> <a href="/topics/technology/microsoft-excel-tips.2.html" id="next" class="btn btn-text"> <span>Next</span> <span class="icon-chevron-right"></span> </a> </li> </ul> </div> </div> </div> </div> </div> </div> <div id="sidebar-top" class="col-sm-4 pull-sm-right sidebar sidebar-top"> <div class="row clearfix"> <div class="sidebar-top iparsys parsys"><div class="section"><div class="new"></div> </div><div class="iparys_inherited"><div class="sidebar-top iparsys parsys"><div class="doubleclickAds section"><div class="advertisement"> <div id="jofa-adslot-2"> <script type="text/javascript"> googletag.cmd.push(function () { googletag.display('jofa-adslot-2'); }); </script> </div> </div> <br> </div> <div class="latestnews section"><div id="899e79af-48a0-49c3-9a59-18672394ce72" class="col-sm-8 col-md-12 latest-news no-column" data-event="topicspodcast"> <div class="section-header">PODCAST</div> </div> <script type="text/x-template" id="latest-news-template-899e79af-48a0-49c3-9a59-18672394ce72"> <article> {@if cond="{isRecent}"} <div class="date-time recent-time"> {timeSince} </div> {:else} <div class="date-time"> {timeSince} </div> {/if} <h2> <a target="" href="{page.path}.html">{articleTitle}</a> </h2> </article> </script> <script> $(document).ready(function () { $('#899e79af-48a0-49c3-9a59-18672394ce72').latestnews({componentPath: "/content/jofa-home/topics/jcr:content/sidebar-top/latestnews", columnCheck: false, viewUrl: "/", viewLabel: "View More", locale: "en", displayAbstract: false, displayViewMore: false, templateId: "#latest-news-template-899e79af-48a0-49c3-9a59-18672394ce72" }); }); </script> </div> <div class="doubleclickAds section"><div class="advertisement"> <div id="jofa-adslot-3"> <script type="text/javascript"> googletag.cmd.push(function () { googletag.display('jofa-adslot-3'); }); </script> </div> </div> <br> </div> </div> </div> </div> </div> </div> <div class="hidden-xs col-sm-12 col-md-8 feature-ribbon"> <div> <div class="feature-carousel iparsys parsys"><div class="section"><div class="new"></div> </div><div class="iparys_inherited"><div class="feature-carousel iparsys parsys"><div class="featurecarousel section"><div id="feature-ribbon" class="feature-ribbon" data-event="featurescarousel"> <div class="featureTitle">Features</div> <div class="swiper"> <a class="icon-prev" href="#"></a> <a class="icon-next" href="#"></a> <div class="swiper-container"> <div class="swiper-wrapper"></div> </div> </div> <hr> </div> <div id="0f4fb5c2-26b8-4776-8561-2c0275b7616e"></div> <script type="text/x-template" id="feature-carousel-template"> <div class="swiper-slide"> <figure> <a href="{page.path}.html"> <div data-picture data-alt='{featureImage.alt}'> {@ne key="{featureImage.renditions.default}" value=""} <div data-src='{featureImage.renditions.default}' data-media></div> <img src='{featureImage.renditions.default}' alt='{featureImage.alt}'> {/ne} {#featureImage.renditions.breakpoints} <div data-src="{path}" data-media="{media}"></div> {/featureImage.renditions.breakpoints} </div> </a> <figcaption> <a href="{page.path}.html">{articleTitle}</a> </figcaption> </figure> </div> </script> <script> jQuery(document).ready(function () { jQuery('#0f4fb5c2-26b8-4776-8561-2c0275b7616e').closest('.featurecarousel').featurecarousel({componentPath: '/content/jofa-home/jcr:content/feature-carousel/featurecarousel'}); }); </script> </div> </div> </div> </div> </div> </div> <div class="clearfix visible-md-block visible-lg-block"></div> <div id="sidebar-bottom" class="col-sm-4 pull-sm-right sidebar sidebar-bottom"> <div class="row"> <div> <div class="sidebar-bottom iparsys parsys"><div class="section"><div class="new"></div> </div><div class="iparys_inherited"><div class="sidebar-bottom iparsys parsys"><div class="doubleclickAds section"><div class="advertisement"> <div id="jofa-adslot-4"> <script type="text/javascript"> googletag.cmd.push(function () { googletag.display('jofa-adslot-4'); }); </script> </div> </div> <br> </div> </div> </div> </div> </div> </div> </div> <div id="mainbar-bottom" class="col-sm-8 mainbar mainbar-bottom"> <div class="row"> <div class="col-md-6 special-report"> <div> <div class="specialreport iparsys parsys"><div class="section"><div class="new"></div> </div><div class="iparys_inherited"><div class="specialreport iparsys parsys"><div class="htmlContainer section"><div id="ca90f0d0-28d3-4b3e-b712-302f45509d3b" class="htmlContainer section "> <p><span class="primary-section-heading-style"><b>SPONSORED REPORT</b></span></p> <h2><a href="https://www.journalofaccountancy.com/info/joa-2024-tax-season.html"><img class="pull-left" src="https://www.journalofaccountancy.com/content/dam/jofa/issues/2024/oct/getting-clients-ready-for-tax-season-128x128.jpg"></a><span class="primary-section-sub-heading-style"><a href="https://www.journalofaccountancy.com/info/joa-2024-tax-season.html">Be prepared for tax season early</a></span></h2> <p>Our expert tax report highlights the important issues that tax preparers and their clients need to address for the 2024 tax year. Stay informed and proactive with guidance on critical tax considerations before year-end.</p> <script> jQuery(document).ready(function () { jQuery('#ca90f0d0-28d3-4b3e-b712-302f45509d3b').htmlcontainer(); }); </script> </div> </div> </div> </div> </div> </div> </div> <div class="hidden-xs col-md-6 sister-publications"> <div> <div class="sisterPublications iparsys parsys"><div class="section"><div class="new"></div> </div><div class="iparys_inherited"><div class="sisterPublications iparsys parsys"><div class="latestnews section"><div id="22ef69ae-01a8-44b1-ac9a-82e1db3e0d5a" class="col-sm-8 col-md-12 latest-news no-column" data-event="ttafeed"> <div class="section-header">From <i>The Tax Adviser</i></div> </div> <script type="text/x-template" id="latest-news-template-22ef69ae-01a8-44b1-ac9a-82e1db3e0d5a"> <article> {@if cond="{isRecent}"} <div class="date-time recent-time"> {timeSince} </div> {:else} <div class="date-time"> {timeSince} </div> {/if} <h2> <a target="_blank" href="{externalizedPath}.html">{articleTitle}</a> </h2> </article> </script> <script> $(document).ready(function () { $('#22ef69ae-01a8-44b1-ac9a-82e1db3e0d5a').latestnews({componentPath: "/content/jofa-home/jcr:content/sisterPublications/latestnews", columnCheck: false, viewUrl: "https://www.thetaxadviser.com/", viewLabel: "View More", locale: "en", displayAbstract: false, displayViewMore: false, templateId: "#latest-news-template-22ef69ae-01a8-44b1-ac9a-82e1db3e0d5a" }); }); </script> </div> </div> </div> </div> </div> </div> </div> </div> <div class="hidden-xs col-sm-12 col-md-8 magazine-ribbon"> <div> <div class="magazine-carousel iparsys parsys"><div class="section"><div class="new"></div> </div><div class="iparys_inherited"><div class="magazine-carousel iparsys parsys"><div class="magazinecarousel section"><div id="magazine-ribbon" class="magazine-ribbon" data-event="printcarousel"> <div class="magazineTitle">Magazine</div> <div class="swiper"> <a class="icon-prev" href="#"></a> <a class="icon-next" href="#"></a> <div class="swiper-container"> <div class="swiper-wrapper"></div> </div> </div> <hr> </div> <div id="e117985d-9001-47cc-b1fd-93cbfe437ac8"></div> <script type="text/x-template" id="magazine-carousel-template"> <div class="swiper-slide"> <a href="{page.path}.html">{issueName}<br> <div data-picture data-alt='{issueCover.alt}'> {@ne key="{issueCover.renditions.default}" value=""} <div data-src='{issueCover.renditions.default}' data-media></div> <img src='{issueCover.renditions.default}' alt='{issueCover.alt}'> {/ne} {#issueCover.renditions.breakpoints} <div data-src="{path}" data-media="{media}"></div> {/issueCover.renditions.breakpoints} </div> </a> </div> </script> <script> jQuery(document).ready(function () { jQuery('#e117985d-9001-47cc-b1fd-93cbfe437ac8').closest('.magazinecarousel').magazinecarousel( { componentPath: '/content/jofa-home/jcr:content/magazine-carousel/magazinecarousel', viewAllPath: '/issues', defaultImage: '/content/dam/jofa-test/general/JofA_Default_Mag_cover_small_official_blue.png' } ); }); </script> </div> </div> </div> </div> </div> </div> </div> </main> <footer class="container"> <div class="row social-media-connect"> <div class="hidden-xs col-sm-4 col-md-5"> <div class="promo-section-one iparsys parsys"><div class="section"><div class="new"></div> </div><div class="iparys_inherited"><div class="promo-section-one iparsys parsys"></div> </div> </div> </div> <div class="hidden-xs col-sm-4"> <div class="promo-section-two iparsys parsys"><div class="section"><div class="new"></div> </div><div class="iparys_inherited"><div class="promo-section-two iparsys parsys"><div class="htmlContainer section"><div id="60e23a1c-ae2c-4e1a-b285-7b1437d026ae" class="htmlContainer section "> <p><span class="secondary-section-heading-style"><b>NEWS APP</b></span></p> <h2><a href="/info/add-journal-of-accountancy-to-apple-news.html"><img src="/content/dam/jofa/info/apple-news-icon.png" class="pull-left"><span class="secondary-section-sub-heading-style"></span></a><a href="/info/add-journal-of-accountancy-to-apple-news.html"><span class="secondary-section-sub-heading-style">How to add the <i>JofA</i> to your Apple News app</span></a></h2> <p>This quick guide walks you through the process of adding the <i>Journal of Accountancy</i> as a favorite news source in the News app from Apple.</p> <script> jQuery(document).ready(function () { jQuery('#60e23a1c-ae2c-4e1a-b285-7b1437d026ae').htmlcontainer(); }); </script> </div> </div> </div> </div> </div> </div> <div class="col-sm-4 col-md-3"> <div class="promo-section-three iparsys parsys"><div class="section"><div class="new"></div> </div><div class="iparys_inherited"><div class="promo-section-three iparsys parsys"><div class="socialconnect section"><h3>CONNECT</h3> <ul class="no-bullets social-list img-list"> <li><a href="http://www.twitter.com/AICPA_JofA" target="_blank"><img src="/content/dam/jofa-test/social/twitter.png"/>Twitter</a></li> <li><a href="http://www.facebook.com/JournalofAccountancy" target="_blank"><img src="/content/dam/jofa-test/social/facebook.png"/>Facebook</a></li> <li><a href="http://www.linkedin.com/groups?mostPopular=&gid=160517" target="_blank"><img src="/content/dam/jofa-test/social/linkedin.png"/>LinkedIn</a></li> </ul> </div> </div> </div> </div> </div> </div> <div class="row footer-navigation footer-navigation-container"> <div class="col-sm-3"> <div class="footer-links-section-one iparsys parsys"><div class="section"><div class="new"></div> </div><div class="iparys_inherited"><div class="footer-links-section-one iparsys parsys"><div class="links section"><div class="verticallink-title">HOME</div> <ul class="no-bullets" data-event=""> <li><a href="/news.html"><span>News</span></a> <li><a href="/issues/2025/mar.html"><span>Magazine</span></a> <li><a href="/issues.html"><span>Issue library</span></a> <li><a href="/videos.html"><span>Video</span></a> <li><a href="/podcast.html"><span>Podcast</span></a> <li><a href="/newsletters/academic-update.html"><span>Academic Update</span></a> <li><a href="/topics.html"><span>Topics</span></a> <li><a href="/sitemap.html"><span>Site map</span></a> </ul> </div> </div> </div> </div> </div> <div class="col-sm-3"> <div class="footer-links-section-two iparsys parsys"><div class="section"><div class="new"></div> </div><div class="iparys_inherited"><div class="footer-links-section-two iparsys parsys"><div class="links section"><div class="verticallink-title">SUBSCRIBE</div> <ul class="no-bullets" data-event=""> <li><a href="/podcast.html"><span>Podcast</span></a> <li><a href="https://aicpa.qualtrics.com/jfe/form/SV_a3pWGGGXnmTbzBs"><span>Academic Update</span></a> </ul> </div> </div> </div> </div> </div> <div class="col-sm-3"> <div class="footer-links-section-three iparsys parsys"><div class="section"><div class="new"></div> </div><div class="iparys_inherited"><div class="footer-links-section-three iparsys parsys"><div class="links section"><div class="verticallink-title">ABOUT</div> <ul class="no-bullets" data-event=""> <li><a href="/info/contact.html"><span>Contact us</span></a> <li><a href="/info/advertise.html"><span>Advertise</span></a> <li><a href="/info/premium-advertiser-directory.html"><span>Vendor directory</span></a> <li><a href="/info/author-guidelines.html"><span>Submit an article</span></a> <li><a href="/info/editorial-calendar.html"><span>Editorial calendar</span></a> <li><a href="/info/reprints-copyrights.html"><span>Reprints & copyrights</span></a> <li><a href="https://www.aicpa-cima.com/help/privacy-policy"><span>Privacy policy</span></a> <li><a href="https://www.aicpa-cima.com/help/terms-and-conditions"><span>Terms & conditions</span></a> </ul> </div> </div> </div> </div> </div> <div class="col-sm-3"> <div class="footer-links-section-four iparsys parsys"><div class="section"><div class="new"></div> </div><div class="iparys_inherited"><div class="footer-links-section-four iparsys parsys"><div class="links section"><div class="verticallink-title">AICPA & CIMA SITES</div> <ul class="no-bullets" data-event=""> <li><a href="https://www.aicpa-cima.com/home"><span>AICPA-CIMA.com</span></a> <li><a href="https://www.aicpa-cima.com/help"><span>Global Engagement Center</span></a> <li><a href="https://www.fm-magazine.com/"><span><i>Financial Management</i> magazine</span></a> <li><a href="https://www.thetaxadviser.com"><span><i>The Tax Adviser</i></span></a> <li><a href="https://www.aicpa-cima.com/blog"><span>AICPA Insights</span></a> <li><a href="https://mycareer.aicpa-cima.com/jobs/"><span>Global Career Hub</span></a> </ul> </div> </div> </div> </div> </div> </div> <div class="row copyright"> <div class="col-sm-6"> <div class="copyright-section iparsys parsys"><div class="section"><div class="new"></div> </div><div class="iparys_inherited"><div class="copyright-section iparsys parsys"><div class="image parbase section"><div class="" data-event=""><a target="_blank" href="https://www.aicpa-cima.com"><img src="/content/jofa-home/_jcr_content/copyright-section/image.img.png/1682342069759.png" alt="AICPA & CIMA" title="AICPA & CIMA" class="cq-dd-image"></a></div> </div> <div class="copyright section"><div class="copyright component"> <div> <p><img src="/content/dam/jofa/info/clear-sq.png" alt="clear-sq" title="clear-sq" class="cq-dd-image"> © <span class="copyrightyear"></span> Association of International Certified Professional Accountants. All rights reserved.</p> </div> </div> <script type="text/javascript"> jQuery(document).ready(function () { jQuery('#f8c8c773-8780-41c1-bf38-981ba4d4f84a').copyright({componentPath: '/content/jofa-home/jcr:content/copyright-section/copyright'}); }); </script></div> </div> </div> </div> </div> <div class="col-sm-6"> <div class="footer-message-section iparsys parsys"><div class="section"><div class="new"></div> </div><div class="iparys_inherited"><div class="footer-message-section iparsys parsys"><div class="text parbase section"> <p style="text-align: right;"> <b>Reliable. Resourceful. Respected.</b></p> </div> </div> </div> </div> </div> </div> </footer> <script src="/etc/clientlibs/aicpa/assets.min.js"></script> <script src="/etc/clientlibs/aicpa/assets/cookie-banner.min.js"></script> <script src="/etc/clientlibs/aicpa/assets/components-footer.min.js"></script> <div class="ie-modal-parsys iparsys parsys"><div class="section"><div class="new"></div> </div><div class="iparys_inherited"><div class="ie-modal-parsys iparsys parsys"></div> </div> </div> </body> </html>

CINXE.COM

Microsoft Excel tips and tricks for accountants - Journal of Accountancy