{"id":7795,"date":"2025-11-21T15:07:20","date_gmt":"2025-11-21T15:07:20","guid":{"rendered":"https:\/\/www.stl-training.co.uk\/b\/?p=7795"},"modified":"2026-01-28T23:44:40","modified_gmt":"2026-01-28T23:44:40","slug":"5-new-excel-features-in-office-365-you-might-have-missed","status":"publish","type":"post","link":"https:\/\/www.stl-training.co.uk\/b\/5-new-excel-features-in-office-365-you-might-have-missed\/","title":{"rendered":"5 New Excel Features in Office 365 You Might Have Missed"},"content":{"rendered":"<p>Excel isn\u2019t the same spreadsheet program you used a few years ago \u2013 Microsoft 365 subscribers get a constant stream of updates that make Excel more powerful and user-friendly. Yet many people haven\u2019t fully explored these enhancements. In our <a href=\"\/microsoft\/excel-training-london.php\"><strong>Excel training courses<\/strong> <strong>at STL<\/strong><\/a>, we often meet experienced users who are surprised by what modern Excel can do.<\/p>\n<p>Below, we highlight <strong>five new Excel features<\/strong> (from recent 365 updates) that you might have missed, and why they\u2019re worth knowing. These range from nifty navigation aids to brand-new functions and AI tools. Mastering them can save you time, reduce errors, and supercharge your data work. Let\u2019s dive in!<\/p>\n<p><img decoding=\"async\" class=\"alignnone size-full wp-image-7800\" src=\"https:\/\/www.stl-training.co.uk\/b\/wp-content\/uploads\/2025\/11\/5_new_Excel_features.png\" alt=\"5_new_Excel_features\" width=\"602\" height=\"361\" srcset=\"https:\/\/www.stl-training.co.uk\/b\/wp-content\/uploads\/2025\/11\/5_new_Excel_features.png 602w, https:\/\/www.stl-training.co.uk\/b\/wp-content\/uploads\/2025\/11\/5_new_Excel_features-300x180.png 300w\" sizes=\"(max-width: 602px) 100vw, 602px\" \/><\/p>\n<p>Now, let\u2019s look at each of these features in detail and share a quick tip for using them:<\/p>\n<p><strong style=\"font-size: 48px; letter-spacing: -0.0415625em;\">1. Focus Cell \u2013 <em>Never Lose Track in Large Spreadsheets<\/em><\/strong><\/p>\n<p>Have you ever scrolled across a giant Excel sheet and lost track of which row or column you were in? <strong>Focus Cell<\/strong> is a solution to that problem, introduced in Microsoft 365 Excel in late 2024. When activated, it <strong>highlights the active cell\u2019s entire row and column<\/strong>, plus the corresponding headers. The active cell itself gets a thicker border. This makes it super easy to see where you are at a glance \u2013 no more squinting or manually shading rows.<\/p>\n<ul>\n<li><strong>How to Use it:<\/strong> Go to the <strong>View<\/strong> tab and click the <strong>Focus Cell<\/strong> button (it\u2019s a toggle). Instantly, your current cell\u2019s row and column light up. You can even pick your highlight colour: click the dropdown next to the Focus Cell button and choose \u201cFocus Cell Color\u201d to select a shade that suits you. For example, choose a soft yellow highlight if your sheet has lots of dark colours, so the active row stands out clearly.<\/li>\n<\/ul>\n<p><img decoding=\"async\" class=\"alignnone wp-image-7799 size-full\" src=\"https:\/\/www.stl-training.co.uk\/b\/wp-content\/uploads\/2025\/11\/Focus-Cell-\u2013-Never-Lose-Track-in-Large-Spreadsheets.png\" alt=\"\" width=\"577\" height=\"221\" srcset=\"https:\/\/www.stl-training.co.uk\/b\/wp-content\/uploads\/2025\/11\/Focus-Cell-\u2013-Never-Lose-Track-in-Large-Spreadsheets.png 577w, https:\/\/www.stl-training.co.uk\/b\/wp-content\/uploads\/2025\/11\/Focus-Cell-\u2013-Never-Lose-Track-in-Large-Spreadsheets-300x115.png 300w\" sizes=\"(max-width: 577px) 100vw, 577px\" \/><\/p>\n<ul>\n<li><strong>Why it Helps:<\/strong> In wide datasets or forms, this visual aid prevents entering data in the wrong row by mistake. It\u2019s like having a ruler across your screen \u2013 keeping your eyes aligned with the data. Users on our advanced Excel courses love how it reduces errors during data entry or auditing. It\u2019s especially handy if you\u2019re working with frozen panes or split windows, as the highlight stays within each pane to show your position.<\/li>\n<li><strong>Quick Tip:<\/strong> Use the keyboard shortcut <strong>Alt + W + E + F<\/strong> to toggle Focus Cell on and off in Windows. Once it\u2019s on, try using Excel\u2019s Find (Ctrl+F) \u2013 each time you jump to a result, that cell\u2019s row &amp; column will be auto-highlighted (Excel auto-activates Focus Cell during Find &amp; Replace by default). This makes scanning search hits much faster in large sheets. And if you love it, add the Focus Cell toggle to your Quick Access Toolbar for one-click access.<\/li>\n<\/ul>\n<p><em>Bottom line:<\/em> Focus Cell is a small tweak that yields a big productivity boost. If you frequently work on big spreadsheets, turning this on can feel like putting highlighter tape on your screen \u2013 simple but game-changing for your focus.<\/p>\n<p><strong style=\"font-size: 48px; letter-spacing: -0.0415625em;\">2. XLOOKUP \u2013 <em>The Better VLOOKUP<\/em><\/strong><\/p>\n<p>For decades, <strong>VLOOKUP<\/strong> was the go-to function to search for a value in a table. But it had notorious limitations: you had to count column index numbers, it couldn\u2019t look left, and it defaulted to approximate matches which caused errors. Enter <strong>XLOOKUP<\/strong> \u2013 a newer lookup function available only in Excel 365 that fixes virtually all those issues.<\/p>\n<p><strong>What it Does:<\/strong> XLOOKUP finds things in a table by column <em>or<\/em> row, in one function. For example, with XLOOKUP you can search for a product code in column A and return the price from column F <em>without<\/em> needing those columns to be in any specific order. It\u2019s as simple as:<br \/>\n=XLOOKUP( lookup_value, lookup_array, return_array, &#8220;Not found&#8221;)<\/p>\n<p>No more cryptic \u201ccolumn_index_num\u201d \u2013 you specify the exact ranges. It can look to the left (VLOOKUP couldn\u2019t), and by default it looks for exact matches (reducing errors). It also can return a whole row or column of results (when combined with dynamic arrays \u2013 more on that soon). In short, it\u2019s a <strong>one-stop replacement<\/strong> for VLOOKUP, HLOOKUP, and even a lot of INDEX\/MATCH uses.<\/p>\n<ul>\n<li><strong>Why it\u2019s Useful:<\/strong> Fewer headaches and mistakes! If you\u2019ve ever had a VLOOKUP break because someone inserted a new column, or you got the dreaded <strong>#N\/A<\/strong> due to the function not finding an approximate match, XLOOKUP is a relief. It\u2019s more intuitive: you tell Excel \u201chere\u2019s what to find\u201d and \u201chere\u2019s where to look\u201d and \u201chere\u2019s the result to give me\u201d \u2013 that\u2019s it. For example, on our courses we show how an XLOOKUP can fetch a customer\u2019s entire record in one go, whereas VLOOKUP would need multiple formulas.<br \/>\nAlso, XLOOKUP can search from bottom up (useful for finding the last occurrence of something) and can perform 2-way lookups (find value at intersection of a given row and column) with a single formula.<\/li>\n<\/ul>\n<p><strong>Quick Tip:<\/strong> <em>Replace your old VLOOKUPs<\/em> with XLOOKUP when you can. The syntax is straightforward:<\/p>\n<p>XLOOKUP(value, lookup_range, return_range, [if_not_found], [match_mode], [search_mode])<\/p>\n<p>The handy <strong>[if_not_found]<\/strong> argument lets you return a custom message like \u201cNot in list\u201d instead of an #N\/A error if the value isn\u2019t found. This makes your spreadsheets more user-friendly. Also, remember XLOOKUP isn\u2019t available in Excel 2016 or 2019 \u2013 it\u2019s a Microsoft 365 feature.<br \/>\nSo if you share your file with colleagues on older versions, consider that (or suggest they upgrade!).<br \/>\nBut if you have Excel 365, embrace XLOOKUP; it will simplify your lookup formulas greatly. In our <strong>Excel Advanced training<\/strong>, learning XLOOKUP is often an \u201caha\u201d moment for folks who have wrestled with VLOOKUP\u2019s quirks for years.<br \/>\n<img decoding=\"async\" class=\"alignnone size-full wp-image-7798\" src=\"https:\/\/www.stl-training.co.uk\/b\/wp-content\/uploads\/2025\/11\/XLOOKUP-\u2013-The-Better-VLOOKUP.png\" alt=\"\" width=\"577\" height=\"192\" srcset=\"https:\/\/www.stl-training.co.uk\/b\/wp-content\/uploads\/2025\/11\/XLOOKUP-\u2013-The-Better-VLOOKUP.png 577w, https:\/\/www.stl-training.co.uk\/b\/wp-content\/uploads\/2025\/11\/XLOOKUP-\u2013-The-Better-VLOOKUP-300x100.png 300w\" sizes=\"(max-width: 577px) 100vw, 577px\" \/><\/p>\n<h2><strong>3. Dynamic Arrays \u2013 <em>Formulas That Spill (FILTER, UNIQUE, SEQUENCE and More)<\/em><\/strong><\/h2>\n<p>This one\u2019s a bit more advanced, but massively powerful: <strong>Dynamic Arrays<\/strong>. Traditional Excel formulas return a single value per cell. Dynamic array formulas, introduced around 2020 for Office 365, can return <strong>multiple<\/strong> results that spill into adjacent cells automatically. Microsoft also introduced a suite of new functions to leverage this: notable ones include <strong>FILTER<\/strong>, <strong>UNIQUE<\/strong>, <strong>SORT<\/strong>, <strong>SEQUENCE<\/strong>, and more. If you haven\u2019t heard of these, you\u2019re in for a treat.<\/p>\n<ul>\n<li><strong>What it Means:<\/strong> With dynamic arrays, you can, for example, write one formula to extract all customers from London from a data table, and Excel will <em>spill<\/em> the list of names into as many cells as needed. The formula might be:=FILTER(Table1[Customer], Table1[City]=&#8221;London&#8221;)If 25 customers match, you\u2019ll see 25 results populate downward automatically. If you then change the city to \u201cParis\u201d, the array resizes. No need to copy formulas down or worry about ranges \u2013 Excel adjusts the output dynamically.<\/li>\n<\/ul>\n<p>The new <strong>UNIQUE<\/strong> function works similarly:<br \/>\n=UNIQUE(range) will output a de-duplicated list of all unique values from the range. <strong>SEQUENCE<\/strong> can generate a list of numbers (e.g., 1 to 100) across cells with one formula. These are tasks that previously required manual work or complex tricks. Dynamic arrays have essentially changed how formulas work under the hood, allowing this fluid spilling behavior.<\/p>\n<ul>\n<li><strong>Why it\u2019s Useful:<\/strong> It <strong>simplifies complex tasks<\/strong>. Consider making a summary table of data that meets certain criteria \u2013 before, you might use pivot tables or complicated array formulas with Ctrl+Shift+Enter. Now, a single FILTER or UNIQUE formula can do it intuitively. It\u2019s also volatile in a good way: when your source data changes, the results update live. If your unique list grows, Excel will automatically extend into empty cells below; if it shrinks, it clears the now-unneeded cells.This dynamic nature turns Excel into more of a responsive canvas. Our trainers often demonstrate dynamic arrays by showing how to build interactive drop-downs: you can point Data Validation to a dynamic array range, so the list of options updates itself based on data \u2013 no manual range resizing.Beyond new functions, even traditional functions can spill: try typing =A1:A5 in a cell and pressing Enter in Excel 365 \u2013 you\u2019ll see it spills the 5 cells\u2019 values horizontally (a nifty surprise!).<\/li>\n<li><strong>Quick Tip:<\/strong> If you experiment with a dynamic array formula and see #SPILL! error, it means something is blocking the cells where the results want to spill. Simply clear any data below\/next to that cell, and the array will flow out.To visually grasp dynamic arrays, use the new \u201cspill range\u201d highlighting: when you click the top cell of a spilled range, Excel puts a blue border around the entire range of results. And if you click any other cell in that range, the formula in the formula bar appears <strong>ghosted<\/strong> (because the actual formula lives in the first cell).This is Excel\u2019s way of saying \u201cthese cells are outputs of a single formula\u201d. One more tip: dynamic array functions are available on Excel for web and mobile too \u2013 so your spreadsheets with these will work consistently across devices.<\/li>\n<\/ul>\n<p><em>In short:<\/em> dynamic arrays let Excel do more heavy lifting for you. They\u2019re a bit advanced, but we include an introduction to functions like FILTER and UNIQUE in our <strong>Excel Advanced courses<\/strong> now, because they enable elegant solutions that were impossible or very tedious with older Excel. If you love efficiency, they\u2019re worth learning.<br \/>\n<img decoding=\"async\" class=\"alignnone size-full wp-image-7797\" src=\"https:\/\/www.stl-training.co.uk\/b\/wp-content\/uploads\/2025\/11\/Dynamic-Arrays-\u2013-Formulas-That-Spill.png\" alt=\"\" width=\"601\" height=\"162\" srcset=\"https:\/\/www.stl-training.co.uk\/b\/wp-content\/uploads\/2025\/11\/Dynamic-Arrays-\u2013-Formulas-That-Spill.png 601w, https:\/\/www.stl-training.co.uk\/b\/wp-content\/uploads\/2025\/11\/Dynamic-Arrays-\u2013-Formulas-That-Spill-300x81.png 300w\" sizes=\"(max-width: 601px) 100vw, 601px\" \/><\/p>\n<p><strong>FILTER Function Example<\/strong><\/p>\n<p>Using Excel\u2019s new =FILTER function, you can produce a permanent dynamic filtered result from a data set. First, you need to convert your data set to a Formatted Table:<\/p>\n<p><img decoding=\"async\" class=\"alignnone size-full wp-image-7803\" src=\"https:\/\/www.stl-training.co.uk\/b\/wp-content\/uploads\/2025\/11\/format_as_table.jpg\" alt=\"format as table\" width=\"273\" height=\"148\" \/><\/p>\n<p>This is found in Excel\u2019s Home ribbon.<\/p>\n<p>Here is an example of an =FILTER result from a formatted table:<br \/>\n<img decoding=\"async\" class=\"alignnone size-full wp-image-7796\" src=\"https:\/\/www.stl-training.co.uk\/b\/wp-content\/uploads\/2025\/11\/FILTER-Function-Example.jpg\" alt=\"FILTER-Function-Example\" width=\"813\" height=\"236\" srcset=\"https:\/\/www.stl-training.co.uk\/b\/wp-content\/uploads\/2025\/11\/FILTER-Function-Example.jpg 813w, https:\/\/www.stl-training.co.uk\/b\/wp-content\/uploads\/2025\/11\/FILTER-Function-Example-300x87.jpg 300w, https:\/\/www.stl-training.co.uk\/b\/wp-content\/uploads\/2025\/11\/FILTER-Function-Example-768x223.jpg 768w\" sizes=\"(max-width: 813px) 100vw, 813px\" \/><\/p>\n<p>The data set has been renamed as \u2018Budget\u2019. Because the data set dynamically grows with new entries, the =FILTER result will automatically update and show any new rows which match the filter criteria. The =FILTER Function is a Spill type function, which means you type it into one cell and it automatically \u2018spills\u2019 into more cells to show the result.<\/p>\n<h2><strong>4. LET Function \u2013 <em>Simplify (and Speed Up) Complex Formulas<\/em><\/strong><\/h2>\n<p>If you\u2019ve ever written a mega-formula in Excel, you know it can get hard to read and maintain. The <strong>LET function<\/strong> (new in Microsoft 365) is here to help with that. It allows you to <strong>assign names to sub-expressions within a formula<\/strong>, similar to how you might use variables in programming. This makes formulas easier to understand and can improve performance by avoiding repetitive calculations.<\/p>\n<ul>\n<li><strong>How LET Works:<\/strong> The syntax is LET(name1, value1, name2, value2, &#8230;, calculation_using_those_names). You define one or more names and their corresponding values, then specify a final expression that can use those names.For example:<br \/>\n=LET(total, SUM(A1:A100), count, COUNTA(A1:A100), total \/ count)This computes the SUM and the COUNT once each, names them, and then the last part total \/ count gives the average. In a normal formula, you might write SUM(A1:A100)\/COUNTA(A1:A100).That works, but it calculates the sum and count separately. With LET, you calculated each only once, then reused the results. For large ranges, that can speed things up. More importantly, if you look at the LET version, it\u2019s clearer what\u2019s happening: you see \u201ctotal\u201d and \u201ccount\u201d which are meaningful, rather than repeating A1:A100 and having to mentally parse it.<br \/>\n<img decoding=\"async\" class=\"alignnone size-full wp-image-7801\" src=\"https:\/\/www.stl-training.co.uk\/b\/wp-content\/uploads\/2025\/11\/LET-Function-\u2013-Simplify-and-Speed-Up-Complex-Formulas.png\" alt=\"\" width=\"529\" height=\"375\" srcset=\"https:\/\/www.stl-training.co.uk\/b\/wp-content\/uploads\/2025\/11\/LET-Function-\u2013-Simplify-and-Speed-Up-Complex-Formulas.png 529w, https:\/\/www.stl-training.co.uk\/b\/wp-content\/uploads\/2025\/11\/LET-Function-\u2013-Simplify-and-Speed-Up-Complex-Formulas-300x213.png 300w\" sizes=\"(max-width: 529px) 100vw, 529px\" \/><\/li>\n<li><strong>Why it\u2019s Useful:<\/strong> <strong>Clarity and efficiency.<\/strong> It\u2019s like giving your formula some breathing room by breaking it into parts. When you or a colleague come back to that formula later, those intermediate names make it far more readable.<br \/>\nPerformance-wise, Microsoft noted that LET can make big worksheet models faster because it reduces duplicate calculations.Imagine a complex nested IF or a heavy array formula; using LET to calculate a sub-term once (like a complex criteria or a long reference) and reuse it means Excel does less work. For example, if you have an index formula that uses the same SEARCH() calculation twice, wrapping it in LET to do SEARCH once and store it can cut calculation time roughly in half (this is a common trick in financial models now).Another real scenario: we helped a client rewrite a monstrous formula for commission calculations using LET \u2013 it went from an unreadable 4-line formula to a cleaner one with named steps like basePay, bonusRate, etc., and it recalculated noticeably faster across thousands of rows.<\/li>\n<li><strong>Quick Tip:<\/strong> Don\u2019t be intimidated by the syntax. Start by using LET in formulas where you notice repetition. A good pattern is to use it to avoid writing the same <strong>VLOOKUP\/XLOOKUP or calculation twice<\/strong>.For instance:<br \/>\n=LET(x, XLOOKUP($A2, ClientIDs, PlanType), IF(x=&#8221;Premium&#8221;, 0.1, 0.05) * Revenue)Here we XLOOKUP the client\u2019s plan type once, name it x, then use x twice in the IF. Without LET, you might have had to either do two XLOOKUPs or pull that value into a helper column. LET saves you from that.<br \/>\nRemember that names in LET are only valid <em>inside<\/em> that formula \u2013 they don\u2019t conflict with named ranges or anything globally. Also, you can nest LETs inside each other if needed (though that might get a bit hard to follow).In summary, use LET to tame your monster formulas; your future self will thank you. It\u2019s a great example of Excel adopting programming concepts to make advanced users\u2019 lives easier.<\/li>\n<\/ul>\n<h2><strong>5. \u201cAnalyze Data\u201d \u2013 <em>Excel\u2019s AI Helper for Insights<\/em><\/strong><\/h2>\n<p>Excel isn\u2019t just about manual formulas anymore \u2013 it also has built-in AI to assist you. The feature <strong>Analyze Data<\/strong> (formerly known as \u201cIdeas\u201d) lives in the Home tab and leverages Microsoft\u2019s AI to <strong>analyze your dataset and suggest insights, trends, and even generate visualizations or formulas<\/strong>. It\u2019s like having a little data analyst inside Excel.<\/p>\n<ul>\n<li><strong>What it Does:<\/strong> When you click the Analyze Data button, Excel looks at the data in your worksheet and comes up with useful nuggets: summaries, outliers, patterns. For example, it might tell you \u201cJuly had the highest sales overall\u201d or \u201cRegion South is an outlier in Q4\u201d.It often suggests charts or PivotTables \u2013 and you can insert those with one click if you like the insight. What\u2019s more, there\u2019s a <strong>Q&amp;A box<\/strong> where you can type a question in plain English (or other supported languages) about your data.For instance, you could ask: \u201cTotal sales by product category for 2023\u201d \u2013 the AI will generate a PivotTable or chart answering that if it can interpret the data. It uses natural language processing, so you don\u2019t have to write a formula or code; you just ask, and Excel will try to figure it out.<br \/>\nThink of it as an AI-powered analyst that can do some of the thinking for you, within limits.<\/li>\n<li><strong>Why it\u2019s Useful:<\/strong> Not everyone is an Excel guru, and sometimes you don\u2019t even know what you\u2019re looking for in a big dataset. Analyze Data can quickly point you to interesting insights or at least give you a starting point.It\u2019s great for sanity-checking your data: if the AI highlights a trend (\u201csales have been increasing month-over-month\u201d) that you weren\u2019t aware of, that\u2019s valuable.<br \/>\nOr if you\u2019re not fluent in PivotTables, the fact that it can generate one for your question is a big time-saver. Even advanced users appreciate it for rapid exploration \u2013 it\u2019s like getting a second pair of eyes on the data.From a training perspective, we find that showing newcomers the Analyse Data feature early on helps demystify data analysis; they see that Excel can do some heavy lifting. It\u2019s also a glimpse of where Excel has been heading with AI.Today, that vision is here: Microsoft Copilot is now fully integrated into Excel, making it easier than ever to work with data. You can simply ask Excel in natural language to build formulas, create dashboards, summarise trends, or even generate insights \u2013 all without needing to know complex syntax.And if you\u2019re curious about what\u2019s next, check out <em>Excel Labs<\/em>. It\u2019s an experimental space where Microsoft tests innovative features before they go mainstream. Excel Labs gives you early access to cutting-edge tools and ideas, so you can explore what\u2019s coming and help shape the future of Excel.Copilot and Excel Labs together make Excel not just a spreadsheet tool, but a smart, evolving platform for data analysis and decision-making. It\u2019s no longer just on the horizon \u2013 it\u2019s here, and it\u2019s transforming how we work with data.<\/li>\n<\/ul>\n<ul>\n<li><strong>Quick Tip:<\/strong> To use Analyze Data, put your data in a <strong>proper table<\/strong> (Insert &gt; Table) or at least have it well-organized with headers \u2013 the AI works best when it can clearly identify your dataset\u2019s structure.<br \/>\nClick anywhere in the data and hit <strong>Analyze Data<\/strong> on the Home ribbon. If you have a specific question, type it where it says <em>\u201cAsk a question about your data\u201d<\/em>.For example, type \u201caverage score by category\u201d or \u201ctotal expenses by month as line chart\u201d \u2013 be relatively concise and use your column names in the question for best results.If Excel can\u2019t figure it out, try rephrasing (it\u2019s a bit like talking to a search engine). Also note, if your data range is too large or complex, Excel might say it can\u2019t analyse (there are some limitations \u2013 e.g. it usually won\u2019t work on over a million cells, or if your workbook is very messy).Start with a clean dataset. And remember, any charts or summaries it creates are inserted into your workbook so you can tweak them further. It\u2019s not perfect \u2013 think of it as a helpful assistant that might not catch everything, but often produces useful results.Many of our <strong>Excel training<\/strong> attendees are surprised to see Excel can do this \u2013 it\u2019s a hint that learning Excel now isn\u2019t just about manual formulas, but also about leveraging AI tools to work smarter.<\/li>\n<\/ul>\n<p><img decoding=\"async\" class=\"alignnone size-full wp-image-7804\" src=\"https:\/\/www.stl-training.co.uk\/b\/wp-content\/uploads\/2025\/11\/Analyze-Data-\u2013-Excels-AI-Helper-for-Insights.png\" alt=\"Analyze-Data\" width=\"601\" height=\"290\" srcset=\"https:\/\/www.stl-training.co.uk\/b\/wp-content\/uploads\/2025\/11\/Analyze-Data-\u2013-Excels-AI-Helper-for-Insights.png 601w, https:\/\/www.stl-training.co.uk\/b\/wp-content\/uploads\/2025\/11\/Analyze-Data-\u2013-Excels-AI-Helper-for-Insights-300x145.png 300w\" sizes=\"(max-width: 601px) 100vw, 601px\" \/><\/p>\n<p><strong>Wrap-Up:<\/strong> These five features \u2013 Focus Cell, XLOOKUP, Dynamic Arrays, LET, and Analyze Data \u2013 showcase how Excel (especially the Microsoft 365 version) is evolving.<br \/>\nIf you hadn\u2019t heard of some of them, it\u2019s a great time to explore. They can make everyday tasks easier and open up new possibilities in what you can do with Excel.<\/p>\n<p>The best part is that <strong>our Excel courses at STL<\/strong> are continually updated to include these new capabilities. We don\u2019t just teach you Excel as it was \u2013 we teach it as it is <em>now<\/em>.<br \/>\nThat means when you attend, say, an Advanced Excel training, you\u2019ll learn about XLOOKUP and FILTER, not just VLOOKUP and AutoFilter.<br \/>\nWe ensure you walk away with knowledge that\u2019s relevant to the current version of Excel, so you\u2019re not missing out on tools that could save you hours.<\/p>\n<p>Excel is a bit like a Swiss army knife that keeps getting new attachments. It\u2019s worth keeping up with what\u2019s new, because you might find a feature that addresses a pain point you\u2019ve had for years.<\/p>\n<p>Hopefully, at least one of the tips above made you go \u201cI didn\u2019t know Excel could do that!\u201d \u2013 in which case, go try it out. And if you want a deeper dive into mastering these and many other Excel tricks, you know where to find us (shameless plug: our <strong>Excel training workshops face to face or online<\/strong>\u00a0will get you hands-on with all this good stuff).<\/p>\n<p>Happy Excelling \u2013 may your spreadsheets be ever efficient!<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Excel isn\u2019t the same spreadsheet program you used a few years ago \u2013 Microsoft 365 subscribers get a constant stream of updates that make Excel more powerful and user-friendly. Yet many people haven\u2019t fully explored these enhancements. In our Excel training courses at STL, we often meet experienced users who are surprised by what modern [&hellip;]<\/p>\n","protected":false},"author":5,"featured_media":7874,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"singular-low-link.php","format":"standard","meta":{"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[4,9],"tags":[],"class_list":["post-7795","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel-training","category-microsoft-office"],"jetpack_featured_media_url":"https:\/\/www.stl-training.co.uk\/b\/wp-content\/uploads\/2025\/11\/Excel-Features-in-Office-365-You-Might-Have-Missed.png","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/posts\/7795","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/users\/5"}],"replies":[{"embeddable":true,"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/comments?post=7795"}],"version-history":[{"count":8,"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/posts\/7795\/revisions"}],"predecessor-version":[{"id":7875,"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/posts\/7795\/revisions\/7875"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/media\/7874"}],"wp:attachment":[{"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/media?parent=7795"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/categories?post=7795"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/tags?post=7795"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}