<h2 style="margin-top: 0px; margin-bottom: 10px;">What is included in Microsoft Excel 2019?</h2>
<p style="margin-top: 0px; margin-bottom: 0px;"><strong>New functions</strong> – CONCAT, IFS, SWITCH, TEXTJOIN, MAXIFS, and MINIFS.<br /> <strong>Map charts</strong> – Plot values across countries, states, or postcodes.<br /> <strong>Funnel charts</strong> – Show progressive values across pipeline stages.<br /> <strong>Get &amp; Transform</strong> – Import, clean, and reshape external data.<br /> <strong>SVG graphics</strong> – Insert scalable vectors without image pixelation.<br /> <strong>Important</strong> – Standalone Excel only; full Office suite excluded.</p>
<p style="margin-top: 15px; margin-bottom: 15px;"><a href="https://keys.express/EN/blog/post/office-comparison-2010-2024-editions-programs-at-a-glance" target="_blank"><strong>Compare included Office programs from 2010 to 2024</strong><br />Side-by-side overview of which programs each Office version from 2010 to 2024 contains, useful for confirming that Excel 2019 is a single application rather than the full suite.</a></p>
<h3 style="margin-top: 30px; margin-bottom: 10px;">What are the main benefits of Microsoft Excel 2019?</h3>
<p style="margin-top: 0px; margin-bottom: 0px;">Excel 2019 is the perpetual, one-time-purchase version of Microsoft's spreadsheet program, installed locally on a single Windows PC. It is a frozen release that received only security updates during its lifecycle and gained no new features after its 2018 launch.<br /><br /> <strong>One-time purchase</strong> – Pay once with no recurring fees.<br /> <strong>Offline ready</strong> – Full spreadsheet work without internet access.<br /> <strong>Faster formulas</strong> – IFS and SWITCH replace nested IF chains.<br /> <strong>Text joining</strong> – TEXTJOIN merges columns using chosen delimiters.<br /> <strong>Visual mapping</strong> – Map charts compare data by region.<br /> <strong>Stable release</strong> – No forced feature changes during use.</p>
<p style="margin-top: 15px; margin-bottom: 15px;"><a href="https://keys.express/EN/blog/post/office-without-subscription-versions-2010-to-2024-in-comparison" target="_blank"><strong>Compare Office versions from 2010 to 2024</strong><br />Buying guide comparing subscription-free Office versions from 2010 to 2024, helpful for deciding between Excel 2019 and a newer perpetual release before you commit.</a></p>
<h3 style="margin-top: 30px; margin-bottom: 10px;">What does Microsoft Excel 2019 do?</h3>
<p style="margin-top: 0px; margin-bottom: 0px;">Microsoft Excel 2019 is the perpetual, one-time-purchase spreadsheet application for Windows, used for calculations, data analysis, charting, and reporting. Compared with Excel 2016 it adds six functions – CONCAT, TEXTJOIN, IFS, SWITCH, MAXIFS, and MINIFS – plus two chart types, map charts and funnel charts. In everyday work, IFS and SWITCH remove long nested IF formulas, while TEXTJOIN concatenates an entire range with one delimiter instead of manual ampersand operators. It installs locally on a single PC and calculates fully offline, so workbooks open without any cloud connection.</p>
<h3 style="margin-top: 30px; margin-bottom: 10px;">Who is Microsoft Excel 2019 best suited for?</h3>
<p style="margin-top: 0px; margin-bottom: 0px;">It suits users who need a standalone, locally installed spreadsheet program and do not want a Microsoft 365 subscription or the rest of the Office suite. A typical fit is a single-PC or back-office user who only works in spreadsheets – budgeting, invoicing, list management – and has no need for Word, PowerPoint, or Outlook. Because Excel 2019 received no new features after 2018 and its support has now ended, it makes most sense for an existing, stable workflow rather than anyone who needs current lookup tools like XLOOKUP. Users who depend on dynamic arrays or real-time co-authoring should look at Excel 2021 or Microsoft 365 instead.</p>
<h3 style="margin-top: 30px; margin-bottom: 10px;">How does Excel 2019 compare to Excel 2021 and Microsoft 365?</h3>
<p style="margin-top: 0px; margin-bottom: 0px;">Excel 2019, Excel 2021, and the Excel in Microsoft 365 share the same core spreadsheet engine, but each newer version adds calculation features the previous one lacks. Excel 2021 introduced XLOOKUP, dynamic array functions (FILTER, SORT, UNIQUE, SEQUENCE), the LET function, and real-time co-authoring – none of which exist in Excel 2019. Microsoft 365 goes further with continuously updated tools such as LAMBDA that are not part of either perpetual version. The table below lists the verified differences.</p>
<table style="width: 100%; border-collapse: collapse; background-color: #efefef; margin-top: 15px; margin-bottom: 15px; font-size: 14px; line-height: 1.35;">
<tbody>
<tr><th style="border: 1px solid #ffffff; padding: 9px 8px; text-align: left; font-weight: bold; background-color: #dedede;">Feature / Function</th><th style="border: 1px solid #ffffff; padding: 9px 8px; text-align: center; font-weight: bold; background-color: #dedede;">Excel 2019</th><th style="border: 1px solid #ffffff; padding: 9px 8px; text-align: center; font-weight: bold; background-color: #dedede;">Excel 2021</th><th style="border: 1px solid #ffffff; padding: 9px 8px; text-align: center; font-weight: bold; background-color: #dedede;">Microsoft 365</th></tr>
<tr>
<td style="border: 1px solid #ffffff; padding: 8px; text-align: left; font-weight: bold; vertical-align: middle;">New 2019 functions (IFS, SWITCH, TEXTJOIN)</td>
<td style="border: 1px solid #ffffff; padding: 8px; text-align: center; vertical-align: middle;"><span style="color: #32a852; font-size: 24px; font-weight: 800; line-height: 1; display: inline-block; transform: translateY(1px);">✓</span></td>
<td style="border: 1px solid #ffffff; padding: 8px; text-align: center; vertical-align: middle;"><span style="color: #32a852; font-size: 24px; font-weight: 800; line-height: 1; display: inline-block; transform: translateY(1px);">✓</span></td>
<td style="border: 1px solid #ffffff; padding: 8px; text-align: center; vertical-align: middle;"><span style="color: #32a852; font-size: 24px; font-weight: 800; line-height: 1; display: inline-block; transform: translateY(1px);">✓</span></td>
</tr>
<tr>
<td style="border: 1px solid #ffffff; padding: 8px; text-align: left; font-weight: bold; vertical-align: middle;">Map &amp; funnel charts</td>
<td style="border: 1px solid #ffffff; padding: 8px; text-align: center; vertical-align: middle;"><span style="color: #32a852; font-size: 24px; font-weight: 800; line-height: 1; display: inline-block; transform: translateY(1px);">✓</span></td>
<td style="border: 1px solid #ffffff; padding: 8px; text-align: center; vertical-align: middle;"><span style="color: #32a852; font-size: 24px; font-weight: 800; line-height: 1; display: inline-block; transform: translateY(1px);">✓</span></td>
<td style="border: 1px solid #ffffff; padding: 8px; text-align: center; vertical-align: middle;"><span style="color: #32a852; font-size: 24px; font-weight: 800; line-height: 1; display: inline-block; transform: translateY(1px);">✓</span></td>
</tr>
<tr>
<td style="border: 1px solid #ffffff; padding: 8px; text-align: left; font-weight: bold; vertical-align: middle;">XLOOKUP</td>
<td style="border: 1px solid #ffffff; padding: 8px; text-align: center; vertical-align: middle;"><span style="color: #d9534f; font-size: 24px; font-weight: 800; line-height: 1; display: inline-block; transform: translateY(1px);">✕</span></td>
<td style="border: 1px solid #ffffff; padding: 8px; text-align: center; vertical-align: middle;"><span style="color: #32a852; font-size: 24px; font-weight: 800; line-height: 1; display: inline-block; transform: translateY(1px);">✓</span></td>
<td style="border: 1px solid #ffffff; padding: 8px; text-align: center; vertical-align: middle;"><span style="color: #32a852; font-size: 24px; font-weight: 800; line-height: 1; display: inline-block; transform: translateY(1px);">✓</span></td>
</tr>
<tr>
<td style="border: 1px solid #ffffff; padding: 8px; text-align: left; font-weight: bold; vertical-align: middle;">Dynamic arrays (FILTER, SORT, UNIQUE)</td>
<td style="border: 1px solid #ffffff; padding: 8px; text-align: center; vertical-align: middle;"><span style="color: #d9534f; font-size: 24px; font-weight: 800; line-height: 1; display: inline-block; transform: translateY(1px);">✕</span></td>
<td style="border: 1px solid #ffffff; padding: 8px; text-align: center; vertical-align: middle;"><span style="color: #32a852; font-size: 24px; font-weight: 800; line-height: 1; display: inline-block; transform: translateY(1px);">✓</span></td>
<td style="border: 1px solid #ffffff; padding: 8px; text-align: center; vertical-align: middle;"><span style="color: #32a852; font-size: 24px; font-weight: 800; line-height: 1; display: inline-block; transform: translateY(1px);">✓</span></td>
</tr>
<tr>
<td style="border: 1px solid #ffffff; padding: 8px; text-align: left; font-weight: bold; vertical-align: middle;">LET function</td>
<td style="border: 1px solid #ffffff; padding: 8px; text-align: center; vertical-align: middle;"><span style="color: #d9534f; font-size: 24px; font-weight: 800; line-height: 1; display: inline-block; transform: translateY(1px);">✕</span></td>
<td style="border: 1px solid #ffffff; padding: 8px; text-align: center; vertical-align: middle;"><span style="color: #32a852; font-size: 24px; font-weight: 800; line-height: 1; display: inline-block; transform: translateY(1px);">✓</span></td>
<td style="border: 1px solid #ffffff; padding: 8px; text-align: center; vertical-align: middle;"><span style="color: #32a852; font-size: 24px; font-weight: 800; line-height: 1; display: inline-block; transform: translateY(1px);">✓</span></td>
</tr>
<tr>
<td style="border: 1px solid #ffffff; padding: 8px; text-align: left; font-weight: bold; vertical-align: middle;">Real-time co-authoring</td>
<td style="border: 1px solid #ffffff; padding: 8px; text-align: center; vertical-align: middle;"><span style="color: #d9534f; font-size: 24px; font-weight: 800; line-height: 1; display: inline-block; transform: translateY(1px);">✕</span></td>
<td style="border: 1px solid #ffffff; padding: 8px; text-align: center; vertical-align: middle;"><span style="color: #32a852; font-size: 24px; font-weight: 800; line-height: 1; display: inline-block; transform: translateY(1px);">✓</span></td>
<td style="border: 1px solid #ffffff; padding: 8px; text-align: center; vertical-align: middle;"><span style="color: #32a852; font-size: 24px; font-weight: 800; line-height: 1; display: inline-block; transform: translateY(1px);">✓</span></td>
</tr>
<tr>
<td style="border: 1px solid #ffffff; padding: 8px; text-align: left; font-weight: bold; vertical-align: middle;">LAMBDA function</td>
<td style="border: 1px solid #ffffff; padding: 8px; text-align: center; vertical-align: middle;"><span style="color: #d9534f; font-size: 24px; font-weight: 800; line-height: 1; display: inline-block; transform: translateY(1px);">✕</span></td>
<td style="border: 1px solid #ffffff; padding: 8px; text-align: center; vertical-align: middle;"><span style="color: #d9534f; font-size: 24px; font-weight: 800; line-height: 1; display: inline-block; transform: translateY(1px);">✕</span></td>
<td style="border: 1px solid #ffffff; padding: 8px; text-align: center; vertical-align: middle;"><span style="color: #32a852; font-size: 24px; font-weight: 800; line-height: 1; display: inline-block; transform: translateY(1px);">✓</span></td>
</tr>
<tr>
<td style="border: 1px solid #ffffff; padding: 8px; text-align: left; font-weight: bold; vertical-align: middle;">New features added over time</td>
<td style="border: 1px solid #ffffff; padding: 8px; text-align: center; vertical-align: middle;"><span style="color: #d9534f; font-size: 24px; font-weight: 800; line-height: 1; display: inline-block; transform: translateY(1px);">✕</span></td>
<td style="border: 1px solid #ffffff; padding: 8px; text-align: center; vertical-align: middle;"><span style="color: #d9534f; font-size: 24px; font-weight: 800; line-height: 1; display: inline-block; transform: translateY(1px);">✕</span></td>
<td style="border: 1px solid #ffffff; padding: 8px; text-align: center; vertical-align: middle;"><span style="color: #32a852; font-size: 24px; font-weight: 800; line-height: 1; display: inline-block; transform: translateY(1px);">✓</span></td>
</tr>
<tr>
<td style="border: 1px solid #ffffff; padding: 8px; text-align: left; font-weight: bold; vertical-align: middle;">Security updates</td>
<td style="border: 1px solid #ffffff; padding: 8px; text-align: center; vertical-align: middle;">Ended Oct 2025</td>
<td style="border: 1px solid #ffffff; padding: 8px; text-align: center; vertical-align: middle;">Supported</td>
<td style="border: 1px solid #ffffff; padding: 8px; text-align: center; vertical-align: middle;">Supported</td>
</tr>
</tbody>
</table>
<h3 style="margin-top: 30px; margin-bottom: 10px;">Does Excel 2019 include XLOOKUP and dynamic array functions?</h3>
<p style="margin-top: 0px; margin-bottom: 0px;">No. XLOOKUP and the dynamic array functions (FILTER, SORT, SORTBY, UNIQUE, SEQUENCE, RANDARRAY) arrived in Excel 2021 and are not part of Excel 2019. The newest lookup and logic tools here are IFS, SWITCH, MAXIFS, and MINIFS, so lookups still rely on VLOOKUP, HLOOKUP, or INDEX/MATCH. If a workbook built in a newer version uses XLOOKUP, Excel 2019 opens the file but shows a _xlfn.XLOOKUP error in place of the result, because it cannot calculate the function. Buyers who specifically need XLOOKUP or spill formulas should choose Excel 2021 or Microsoft 365.</p>
<h3 style="margin-top: 30px; margin-bottom: 10px;">Does Microsoft Excel 2019 still receive security updates?</h3>
<p style="margin-top: 0px; margin-bottom: 0px;">No. Microsoft ended support for Office 2019, including Excel 2019, on October 14, 2025, and there is no Extended Security Updates (ESU) program for it. The application still opens and runs normally, but no further security patches, bug fixes, or technical support are issued, so newly found vulnerabilities remain unpatched. For an isolated or offline machine this can be acceptable; for internet-connected or regulated environments it is a real consideration. Users who need ongoing patches should move to Excel 2021 or Microsoft 365.</p>
<h3 style="margin-top: 30px; margin-bottom: 10px;">Can Excel 2019 open workbooks from newer Excel versions?</h3>
<p style="margin-top: 0px; margin-bottom: 0px;">Yes. Excel 2019 opens and saves the standard .xlsx and .xlsm formats, the legacy .xls format, .csv files, and OpenDocument Spreadsheet (.ods) files. It shares the 16.0 internal version number with Excel 2016, 2021, and Microsoft 365, so most VBA macros and COM add-ins built for those versions keep working with little or no rework. The limit is functions: cells that use XLOOKUP, dynamic arrays, or LET will open but return an _xlfn error, since Excel 2019 cannot evaluate them. For teams exchanging files with Microsoft 365 users, that formula gap is the main compatibility point to check.</p>
<h3 style="margin-top: 30px; margin-bottom: 10px;">What should users check before choosing Excel 2019?</h3>
<p style="margin-top: 0px; margin-bottom: 0px;">First, confirm the workflow does not depend on XLOOKUP, dynamic arrays, or real-time co-authoring, since none are available in this version. Second, weigh the October 14, 2025 end-of-support date, as Excel 2019 no longer receives security updates – a point that matters most on internet-connected PCs. Third, check Windows compatibility, because Excel 2019 is a Windows desktop application and a separate Excel 2019 for Mac exists for macOS users. Finally, confirm you only need Excel itself, as this standalone app does not include Word, PowerPoint, or Outlook.</p>
<p style="margin-top: 15px; margin-bottom: 15px;"><a href="https://keys.express/EN/blog/post/overview-microsoft-office-compatibility-supported-windows-and-windows-server-versions" target="_blank"><strong>Check Windows compatibility for Office versions</strong><br />Reference table of supported Windows and Windows Server versions for Office 2010 to 2024, useful for confirming Excel 2019 will run on your system before buying.</a></p>
<h3 style="margin-top: 30px; margin-bottom: 10px;">Frequently asked questions about Microsoft Excel 2019</h3>
<h3 style="margin-top: 30px; margin-bottom: 10px;">Does Microsoft Excel 2019 include Word, PowerPoint, or Outlook?</h3>
<p style="margin-top: 0px; margin-bottom: 0px;">No. Excel 2019 as a standalone product installs only Excel; Word, PowerPoint, Outlook, and the other Office apps are separate purchases. Anyone who needs the full set should choose an Office 2019 suite or a newer Office edition instead.</p>
<h3 style="margin-top: 30px; margin-bottom: 10px;">Does Excel 2019 need a Microsoft 365 subscription to run?</h3>
<p style="margin-top: 0px; margin-bottom: 0px;">No. Excel 2019 is a perpetual, one-time-purchase program that launches and runs without any Microsoft 365 subscription or ongoing sign-in. Cloud features such as co-authoring and OneDrive integration are not part of it, but all local spreadsheet work stays available offline.</p>
<h3 style="margin-top: 30px; margin-bottom: 10px;">Is there a separate Excel 2019 version for Mac?</h3>
<p style="margin-top: 0px; margin-bottom: 0px;">Yes. Alongside the Windows edition, Microsoft released Office 2019 for Mac, which includes a macOS build of Excel 2019. The Windows and Mac versions are distinct products, so buyers should pick the one that matches their operating system.</p>