{"id":253615,"date":"2026-06-16T19:00:08","date_gmt":"2026-06-16T17:00:08","guid":{"rendered":"https:\/\/www.itta.net\/?p=253615"},"modified":"2026-06-16T19:06:05","modified_gmt":"2026-06-16T17:06:05","slug":"advanced-excel-10-functions-ignored","status":"publish","type":"post","link":"https:\/\/www.itta.net\/en\/en\/blog\/advanced-excel-10-functions-ignored\/","title":{"rendered":"Advanced Excel: the 10 Functions 90% of Professionals Ignore"},"content":{"rendered":"<p><em><strong>90% of Excel users stick to SUM, AVERAGE, VLOOKUP and a few pivot tables.<\/strong> Yet, since 2020, Microsoft has deeply modernized Excel&#8217;s calculation engine with dynamic arrays, LAMBDA, LET and XLOOKUP. According to the Microsoft Tech Community for Excel, these new functions divide by 3 to 5 the time spent on classic manipulations. Here are 10 advanced Excel functions that will transform your daily work if you handle data regularly.<\/em><\/p>\n<!-- quiz_ia: invalid JSON in quiz_ia_data -->\n<h2 id=\"sommaire\">Table of Contents<\/h2>\n<ul>\n<li><a href=\"#fonctions-1-3\">XLOOKUP, FILTER, UNIQUE: the modern trinity<\/a><\/li>\n<li><a href=\"#fonctions-4-5\">LET and LAMBDA: programming inside Excel<\/a><\/li>\n<li><a href=\"#fonctions-6-7\">TEXTSPLIT and TEXTJOIN: mastering text strings<\/a><\/li>\n<li><a href=\"#fonctions-8-9\">SORT, SORTBY and SEQUENCE: sort and generate dynamically<\/a><\/li>\n<li><a href=\"#fonction-10\">SUMPRODUCT: the chameleon function<\/a><\/li>\n<li><a href=\"#certification\">Why aim for MOS Excel Expert certification?<\/a><\/li>\n<li><a href=\"#faq\">FAQ<\/a><\/li>\n<\/ul>\n<h2 id=\"introduction\">Why 90% of professionals miss what Excel does best<\/h2>\n<p>Excel has quietly lived through a revolution since 2020. The calculation engine was rebuilt to support <a href=\"https:\/\/support.microsoft.com\/en-us\/office\/dynamic-array-formulas-and-spilled-array-behavior-205c6b06-03ba-4151-89a1-87a7eb36e531\" target=\"_blank\" rel=\"noopener noreferrer\">dynamic arrays<\/a>, which propagate a result across multiple cells automatically without Ctrl+Shift+Enter. This evolution rendered dozens of tedious manipulations obsolete.<\/p>\n<p>Yet in everyday Swiss practice, most professionals still use Excel like it&#8217;s 2010. VLOOKUP instead of XLOOKUP, endless nested formulas instead of LAMBDA, manual text manipulation instead of TEXTSPLIT. The result: only a minority of users actually leverages dynamic array functions, even though they ship in every recent version of Excel.<\/p>\n<p>The direct consequence: an analyst who masters modern functions accomplishes in 30 minutes what takes an intermediate user 2 hours. Here are the 10 functions that make the difference, ranked by impact.<\/p>\n<h2 id=\"fonctions-1-3\">1, 2, 3 &#8211; XLOOKUP, FILTER, UNIQUE: the modern trinity<\/h2>\n<p><img decoding=\"async\" src=\"https:\/\/www.itta.net\/wp-content\/uploads\/2026\/06\/a38-excel-xlookup-filter.webp\" alt=\"excel user manipulating xlookup and filter on a complex spreadsheet\" loading=\"lazy\" style=\"width:100%;height:auto;border-radius:8px;margin:1.5rem 0\" \/><\/p>\n<h3>XLOOKUP: the end of VLOOKUP<\/h3>\n<p>VLOOKUP suffers from three historical limits: searches only to the right, breaks if the reference column isn&#8217;t the first one, doesn&#8217;t handle missing values natively. XLOOKUP fixes all three.<\/p>\n<pre style=\"background:#f5f5f5;padding:1rem;border-radius:6px\"><code>=XLOOKUP(lookup_value, lookup_array, return_array, \"Not found\")<\/code><\/pre>\n<p>You can search left, right, last-to-first, and handle &#8220;not found&#8221; without nesting IFERROR. In short, XLOOKUP should replace 100% of your VLOOKUPs in 2026.<\/p>\n<h3>FILTER: dynamically extract data<\/h3>\n<p>Instead of manually copy-pasting rows matching a criterion, FILTER returns a dynamic array:<\/p>\n<pre style=\"background:#f5f5f5;padding:1rem;border-radius:6px\"><code>=FILTER(Sales, Sales[Region]=\"Geneva\", \"No data\")<\/code><\/pre>\n<p>This function alone removes 50% of advanced filter manipulations and simple macros.<\/p>\n<h3>UNIQUE: extract distinct values<\/h3>\n<p>No need for a pivot table just to extract the list of customers or products:<\/p>\n<pre style=\"background:#f5f5f5;padding:1rem;border-radius:6px\"><code>=UNIQUE(Sales[Customer])<\/code><\/pre>\n<p>The result updates automatically when data is added. Combined with SORT, it&#8217;s unbeatable.<\/p>\n<h2 id=\"fonctions-4-5\">4, 5 &#8211; LET and LAMBDA: programming inside Excel<\/h2>\n<p><img decoding=\"async\" src=\"https:\/\/www.itta.net\/wp-content\/uploads\/2026\/06\/a38-excel-let-lambda.webp\" alt=\"excel analyst designing custom lambda functions\" loading=\"lazy\" style=\"width:100%;height:auto;border-radius:8px;margin:1.5rem 0\" \/><\/p>\n<h3>LET: stop recalculating the same thing 10 times<\/h3>\n<p>LET allows storing intermediate results inside a formula, like variables in programming:<\/p>\n<pre style=\"background:#f5f5f5;padding:1rem;border-radius:6px\"><code>=LET(\n  total, SUM(Sales[Amount]),\n  avg, total\/COUNTA(Sales[Customer]),\n  IF(avg&gt;1000, \"Good\", \"Weak\")\n)<\/code><\/pre>\n<p>This makes complex formulas <strong>10 times more readable<\/strong> and improves performance on large workbooks. It&#8217;s arguably the most underused function relative to its impact.<\/p>\n<h3>LAMBDA: build your own Excel functions<\/h3>\n<p>LAMBDA lets you define a custom formula, reusable like a native function, without VBA. Example: calculating Swiss VAT at 8.1%:<\/p>\n<pre style=\"background:#f5f5f5;padding:1rem;border-radius:6px\"><code>VAT_CH = LAMBDA(amount, amount * 0.081)<\/code><\/pre>\n<p>Once named through the Name Manager, you use it everywhere: <code>=VAT_CH(B2)<\/code>. For recurring financial models, this is a major productivity gain. Furthermore, the <a href=\"https:\/\/learn.microsoft.com\/en-us\/office\/dev\/scripts\/\" target=\"_blank\" rel=\"noopener noreferrer\">Office Scripts documentation<\/a> positions LAMBDA as the entry point into programming for business users.<\/p>\n<h2 id=\"fonctions-6-7\">6, 7 &#8211; TEXTSPLIT and TEXTJOIN: mastering text strings<\/h2>\n<p><img decoding=\"async\" src=\"https:\/\/www.itta.net\/wp-content\/uploads\/2026\/06\/a38-excel-textsplit-textjoin.webp\" alt=\"professional transforming text data in excel\" loading=\"lazy\" style=\"width:100%;height:auto;border-radius:8px;margin:1.5rem 0\" \/><\/p>\n<h3>TEXTSPLIT: split without macros<\/h3>\n<p>How many times have you used Data \u2192 Text to Columns? TEXTSPLIT replaces this with a dynamic formula:<\/p>\n<pre style=\"background:#f5f5f5;padding:1rem;border-radius:6px\"><code>=TEXTSPLIT(A2, \";\")<\/code><\/pre>\n<p>Perfect for handling raw CSV files or concatenated fields. Moreover, the result updates automatically when the source changes.<\/p>\n<h3>TEXTJOIN: concatenate with smart separator<\/h3>\n<p>The reverse of TEXTSPLIT. TEXTJOIN ignores empty cells, which solves one of CONCATENATE&#8217;s classic nightmares:<\/p>\n<pre style=\"background:#f5f5f5;padding:1rem;border-radius:6px\"><code>=TEXTJOIN(\", \", TRUE, A2:A20)<\/code><\/pre>\n<p>Especially for mailing lists or aggregated labels, the win is immediate.<\/p>\n<h2 id=\"fonctions-8-9\">8, 9 &#8211; SORT, SORTBY and SEQUENCE: sort and generate dynamically<\/h2>\n<h3>SORT and SORTBY: live sorts<\/h3>\n<p>No more re-sorting your table manually when you add data. SORT returns a sorted array and stays dynamic:<\/p>\n<pre style=\"background:#f5f5f5;padding:1rem;border-radius:6px\"><code>=SORT(FILTER(Sales, Sales[Region]=\"Lausanne\"), 4, -1)<\/code><\/pre>\n<p>This example combines FILTER and SORT to dynamically display Lausanne sales sorted by amount descending.<\/p>\n<h3>SEQUENCE: generate series<\/h3>\n<p>SEQUENCE creates a number series:<\/p>\n<pre style=\"background:#f5f5f5;padding:1rem;border-radius:6px\"><code>=SEQUENCE(12, 1, DATE(2026,1,1), 31)<\/code><\/pre>\n<p>Generates the first 12 days at monthly intervals throughout 2026. Especially useful for dynamically building parameter tables or simulation calendars.<\/p>\n<h2 id=\"fonction-10\">10 &#8211; SUMPRODUCT: the chameleon function<\/h2>\n<p>SUMPRODUCT isn&#8217;t new, but it&#8217;s probably Excel&#8217;s most versatile function. It alone replaces many SUMIF and COUNTIF combinations, and enables advanced conditional calculations:<\/p>\n<pre style=\"background:#f5f5f5;padding:1rem;border-radius:6px\"><code>=SUMPRODUCT((Sales[Region]=\"Geneva\")*(Sales[Year]=2026)*Sales[Amount])<\/code><\/pre>\n<p>This formula calculates the sum of 2026 Geneva sales. Its magic comes from the automatic conversion of boolean conditions into 0s and 1s. It&#8217;s the go-to tool for experienced controllers. However, since FILTER and XLOOKUP arrived, its use has shifted: SUMPRODUCT remains unbeatable on multi-condition aggregations.<\/p>\n<h2 id=\"certification\">Why aim for MOS Excel Expert certification?<\/h2>\n<p><img decoding=\"async\" src=\"https:\/\/www.itta.net\/wp-content\/uploads\/2026\/06\/a38-excel-mos-certification.webp\" alt=\"excel expert training class preparing the mos certification\" loading=\"lazy\" style=\"width:100%;height:auto;border-radius:8px;margin:1.5rem 0\" \/><\/p>\n<p>The <a href=\"https:\/\/learn.microsoft.com\/en-us\/credentials\/certifications\/exams\/mo-201\/\" target=\"_blank\" rel=\"noopener noreferrer\">Microsoft Office Specialist Excel Expert (MO-201) certification<\/a> officially recognizes mastery of advanced Excel functions. In Switzerland, this certification clearly stands out on your CV for finance, controlling, data analysis and reporting roles.<\/p>\n<p>On the Swiss job market, many roles in finance, controlling and data analysis value a recognized Excel certification. The exam content covers precisely the functions presented here, making it an excellent learning objective to structure your skill ramp-up.<\/p>\n<div style=\"background:linear-gradient(135deg,#f8fcfc 0%,#f0fafa 100%);border-radius:12px;padding:36px 40px;margin:40px 0;font-family:Montserrat,Arial,sans-serif;color:#111;border-left:6px solid #0078A0;position:relative\">\n<p style=\"font-size:1.1vw;font-weight:600;margin:0 0 6px;color:#0078A0;line-height:1.3;text-transform:uppercase;letter-spacing:1px\">Recommended training<\/p>\n<p style=\"font-size:1.6vw;font-weight:700;margin:0 0 4px;color:#1a1a2e;line-height:1.3\">Microsoft Office Specialist &#8211; MOS Excel Expert<\/p>\n<p style=\"font-size:0.9vw;font-weight:600;margin:0 0 14px;color:#888;line-height:1.3\">Ref. MOS-EE<\/p>\n<p style=\"font-size:1vw;margin:0 0 16px;color:#444;line-height:1.6\">Officially validate advanced Excel mastery with the MO-201 certification: advanced functions, pivot tables, macros, data analysis. 3-day intensive prep.<\/p>\n<div style=\"display:flex;flex-wrap:wrap;gap:8px 24px;margin:0 0 20px\">\n<span style=\"font-size:0.95vw;color:#444\"><strong style=\"color:#0078A0\">Duration:<\/strong> 3 days<\/span><br \/>\n<span style=\"font-size:0.95vw;color:#444\"><strong style=\"color:#0078A0\">Level:<\/strong> Expert<\/span><br \/>\n<span style=\"font-size:0.95vw;color:#444\"><strong style=\"color:#0078A0\">Location:<\/strong> Geneva \/ Lausanne \/ Remote<\/span>\n<\/div>\n<p><a href=\"https:\/\/www.itta.net\/en\/courses\/office-productivity\/office-certifications\/microsoft-office-specialist-mos-excel-expert\/\" target=\"_blank\" rel=\"noopener\" style=\"display:inline-block;background:#0078A0;color:#fff;padding:14px 32px;border-radius:8px;font-size:1.05vw;font-weight:700;text-decoration:none;font-family:Montserrat,Arial,sans-serif\">Discover the course \u2192<\/a>\n<\/div>\n<h2 id=\"power-query-patterns\">Bonus: 3 Power Query M patterns that change everything<\/h2>\n<p>Beyond cell-level functions, Excel integrates Power Query M, a data transformation language often ignored by advanced users. Yet three Power Query patterns alone can eliminate 80% of repetitive manual handling. Here are the three highest-impact ones.<\/p>\n<h3>Pattern 1: combine multiple Excel files from a folder<\/h3>\n<p>The classic case: your finance team receives 10 similar Excel files from subsidiaries each month. You stack them manually into a consolidated file. With Power Query, a single operation does it. In Excel, Data \u2192 Get Data \u2192 From File \u2192 From Folder. Point at the folder, Power Query auto-detects the shared structure and stacks the 10 files into a single query refreshed at every opening.<\/p>\n<p>Benefit: what took 30 manual minutes each month becomes a single &#8220;Refresh&#8221; click. And if an eleventh file arrives, it integrates automatically without modification.<\/p>\n<h3>Pattern 2: pivot and unpivot a matrix<\/h3>\n<p>Files received from partners often come in &#8220;crosstab&#8221; format: one column per month, one row per product. To analyze in Power BI or Power Query, you need to flatten them (&#8220;long&#8221; format, one row per month \u00d7 product). That&#8217;s the Unpivot function in Power Query.<\/p>\n<p>Select the monthly columns, do Transform \u2192 Unpivot Columns. Power Query instantly produces a flat, query-ready table. Conversely, Pivot reconstructs a matrix from a long table. Mastering both saves hours on every external data treatment.<\/p>\n<h3>Pattern 3: parameterize a query from an Excel cell<\/h3>\n<p>Want a Power Query query that automatically switches its source file based on an Excel cell? That&#8217;s the role of Power Query parameters. Create a named parameter (e.g. &#8220;Month&#8221;) and use Excel.CurrentWorkbook() to read a cell. Power Query dynamically reads the selected month and adapts source or filters.<\/p>\n<p>This pattern turns an Excel workbook into an interactive app without VBA. Particularly powerful for simulation models used by controllers or relationship managers.<\/p>\n<p>These three Power Query patterns, combined with the 10 modern functions above, form the technical foundation of a 2026 Expert-level Excel user. The MOS Excel Expert certification, in fact, validates precisely this skill combination.<\/p>\n<h3>Bonus pattern 4: auto-refresh with Power Query and Excel<\/h3>\n<p>Beyond the three patterns above, Power Query can drive a complete automation without any external script. Imagine: every morning, opening your workbook automatically triggers fresh data retrieval from an API or a shared folder, with no manual action. That is exactly what Power Query&#8217;s auto-refresh options enable, accessible via Data \u2192 Queries and Connections \u2192 Properties.<\/p>\n<p>Three key settings to know. First, refresh on file open guarantees data is always fresh. Then periodic refresh (every 30, 60 or 240 minutes) keeps data current during the day for users in continuous data entry. Finally, background refresh lets you keep working on the file while the query updates.<\/p>\n<p>Combined with the dynamic parameters from Pattern 3, you get a real mini-dashboard inside Excel that refreshes without intervention. For a controller or relationship manager, it&#8217;s the equivalent of a &#8220;Power BI Light&#8221; embedded directly in their daily tool, without requesting a new license.<\/p>\n<h2 id=\"aller-plus-loin\">Going further: Office Scripts to automate beyond Excel<\/h2>\n<p>For users who want to cross another threshold after MOS Excel Expert, Microsoft offers <strong>Office Scripts<\/strong>, a modern automation system based on TypeScript integrated into Excel Online. Concretely, you record your manipulations as a macro, then edit the generated TypeScript code to make it parametric, robust and shareable. Combined with Power Automate, Office Scripts orchestrates cross-application automations (Outlook \u2192 Excel \u2192 Teams) without any local installation.<\/p>\n<p>For intermediate controllers and data analysts, this is the natural entry point into the Microsoft Low-Code ecosystem, without having to learn Python or VBA. The learning curve is gentle, the integration with the rest of Microsoft 365 is immediate, and the ROI on recurring tasks shows up within the first month of use.<\/p>\n<h3>The integration with Power Automate<\/h3>\n<p>The real power of Office Scripts emerges when you combine it with Power Automate. A typical workflow: Power Automate detects a new email with an Excel attachment, then triggers an Office Script that opens the file, runs your transformation logic, saves the result on SharePoint, and notifies the team in Teams. This entire chain runs in the background without any human intervention, replacing several manual tasks that took 15-30 minutes per occurrence.<\/p>\n<p>For organizations producing recurring reports (monthly financial close, weekly sales follow-up, daily inventory reconciliation), Office Scripts can free up dozens of hours per month for an entire department. The skill curve to write your first useful Office Script is comparable to learning advanced Excel formulas: two or three days of dedicated practice are enough to be productive.<\/p>\n<h3>Practical entry points<\/h3>\n<p>To get started concretely with Office Scripts, the recommended approach is to take a simple Excel manipulation you already do every week, record it as an Office Script via Automate \u2192 Record Actions, then edit the TypeScript code to add a parameter (e.g. a date or a region). This first iteration takes one hour and immediately demonstrates the value. From there, you can gradually replace your recurring manual tasks with reusable scripts shared across the team.<\/p>\n<h3>Common pitfalls when adopting modern Excel functions<\/h3>\n<p>Adopting the modern functions also brings a few classic pitfalls worth flagging. First, file compatibility: a workbook using XLOOKUP, FILTER or LAMBDA will not open correctly in Excel 2019 or older. Always check what versions your stakeholders run before standardizing on dynamic arrays. Second, spilled arrays can collide with existing data: if a FILTER returns 50 rows into a column that already contains values, Excel raises a #SPILL! error. Plan your layout accordingly, ideally on dedicated sheets. Third, formula performance: LET and LAMBDA improve readability but very deep nested LAMBDAs can slow down recalculation on large workbooks. Test on a representative dataset before deploying widely.<\/p>\n<h3>Combining functions: a concrete dashboard example<\/h3>\n<p>The real power of modern Excel shows when you chain these functions together. Imagine a sales dashboard that must display, in real time, the top 5 customers for a given region. In a single formula, you filter the region&#8217;s sales with FILTER, sort them by amount descending with SORT, then keep only the first five rows. Everything recalculates automatically the moment a new sale is entered, with no macro and no manual handling.<\/p>\n<p>You can then wrap that logic in a named LAMBDA function, for example TopCustomers, to reuse it on every region without rewriting the formula. This exact way of thinking (reasoning in reusable building blocks rather than isolated cells) is what separates an intermediate user from a true Excel expert. The modular approach also reduces the risk of error, since a fix made inside the LAMBDA propagates everywhere it is used.<\/p>\n<h2 id=\"conclusion\">Conclusion<\/h2>\n<p>Modern Excel functions (XLOOKUP, FILTER, UNIQUE, LET, LAMBDA, TEXTSPLIT, SORT, SEQUENCE, SUMPRODUCT) are not reserved for technical profiles. They radically transform the productivity of any user who handles data regularly. Their learning ROI is measured in hours saved each week and in analysis quality.<\/p>\n<p>Concretely, start by adopting XLOOKUP instead of VLOOKUP for two weeks, then gradually integrate FILTER, LET and UNIQUE. You will be surprised never to want to go back.<\/p>\n<h2 id=\"faq\">FAQ<\/h2>\n<p><strong>Are these functions available in all Excel versions?<\/strong><br \/>\nDynamic array functions (XLOOKUP, FILTER, UNIQUE, SORT, SEQUENCE) are available in Microsoft 365 and Excel 2021+. LAMBDA and TEXTSPLIT arrived more recently and require an up-to-date M365 version.<\/p>\n<p><strong>Should I abandon VLOOKUP?<\/strong><br \/>\nYes, in new files. XLOOKUP is simpler, more robust and faster. Keep VLOOKUP only for backward compatibility with older Excel versions.<\/p>\n<p><strong>Can LAMBDA replace VBA?<\/strong><br \/>\nPartially. For reusable calculation functions, LAMBDA suffices. However, for full automation (loops, user interaction, APIs), VBA or Office Scripts remain necessary.<\/p>\n<p><strong>How hard is the MO-201 certification really?<\/strong><br \/>\nMoving from intermediate to Expert takes about 3 days of intensive training plus practice. The exam covers concrete cases, not theoretical questions, making it a highly operational certification.<\/p>\n<p><strong>How do I keep my Excel skills up to date?<\/strong><br \/>\nFollow the Microsoft Tech Community for Excel, which publishes new functions every month. Practice on real business use cases, not disconnected exercises.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>90% of Excel users stick to SUM, AVERAGE, VLOOKUP and a few pivot tables. Yet, since 2020, Microsoft has deeply modernized Excel&#8217;s calculation engine with dynamic arrays, LAMBDA, LET and XLOOKUP. According to the Microsoft Tech Community for Excel, these new functions divide by 3 to 5 the time spent on classic manipulations. Here are [&hellip;]<\/p>\n","protected":false},"author":112,"featured_media":253577,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"content-type":"","footnotes":""},"categories":[2915],"tags":[],"class_list":["post-253615","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-ms-office"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v27.5 (Yoast SEO v27.5) - https:\/\/yoast.com\/product\/yoast-seo-premium-wordpress\/ -->\n<title>Advanced Excel: 10 functions 90% ignore | ITTA<\/title>\n<meta name=\"description\" content=\"XLOOKUP, FILTER, LAMBDA, LET... master the 10 modern Excel functions that will transform your productivity.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.itta.net\/en\/en\/blog\/advanced-excel-10-functions-ignored\/\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Damien Crocq\" \/>\n\t<meta name=\"twitter:label2\" content=\"Estimated reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"13 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.itta.net\\\/en\\\/en\\\/blog\\\/advanced-excel-10-functions-ignored\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.itta.net\\\/en\\\/en\\\/blog\\\/advanced-excel-10-functions-ignored\\\/\"},\"author\":{\"name\":\"Damien Crocq\",\"@id\":\"https:\\\/\\\/www.itta.net\\\/en\\\/#\\\/schema\\\/person\\\/ca875e6c61a8f6f224901d4b48e1494f\"},\"headline\":\"Advanced Excel: the 10 Functions 90% of Professionals Ignore\",\"datePublished\":\"2026-06-16T17:00:08+00:00\",\"dateModified\":\"2026-06-16T17:06:05+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.itta.net\\\/en\\\/en\\\/blog\\\/advanced-excel-10-functions-ignored\\\/\"},\"wordCount\":2133,\"publisher\":{\"@id\":\"https:\\\/\\\/www.itta.net\\\/en\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/www.itta.net\\\/en\\\/en\\\/blog\\\/advanced-excel-10-functions-ignored\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.itta.net\\\/wp-content\\\/uploads\\\/2026\\\/06\\\/a38-excel-avance-featured.webp\",\"articleSection\":[\"MS Office\"],\"inLanguage\":\"en-GB\"},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.itta.net\\\/en\\\/en\\\/blog\\\/advanced-excel-10-functions-ignored\\\/\",\"url\":\"https:\\\/\\\/www.itta.net\\\/en\\\/en\\\/blog\\\/advanced-excel-10-functions-ignored\\\/\",\"name\":\"Advanced Excel: 10 functions 90% ignore | ITTA\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.itta.net\\\/en\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.itta.net\\\/en\\\/en\\\/blog\\\/advanced-excel-10-functions-ignored\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.itta.net\\\/en\\\/en\\\/blog\\\/advanced-excel-10-functions-ignored\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.itta.net\\\/wp-content\\\/uploads\\\/2026\\\/06\\\/a38-excel-avance-featured.webp\",\"datePublished\":\"2026-06-16T17:00:08+00:00\",\"dateModified\":\"2026-06-16T17:06:05+00:00\",\"description\":\"XLOOKUP, FILTER, LAMBDA, LET... master the 10 modern Excel functions that will transform your productivity.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.itta.net\\\/en\\\/en\\\/blog\\\/advanced-excel-10-functions-ignored\\\/#breadcrumb\"},\"inLanguage\":\"en-GB\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.itta.net\\\/en\\\/en\\\/blog\\\/advanced-excel-10-functions-ignored\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-GB\",\"@id\":\"https:\\\/\\\/www.itta.net\\\/en\\\/en\\\/blog\\\/advanced-excel-10-functions-ignored\\\/#primaryimage\",\"url\":\"https:\\\/\\\/www.itta.net\\\/wp-content\\\/uploads\\\/2026\\\/06\\\/a38-excel-avance-featured.webp\",\"contentUrl\":\"https:\\\/\\\/www.itta.net\\\/wp-content\\\/uploads\\\/2026\\\/06\\\/a38-excel-avance-featured.webp\",\"width\":1376,\"height\":768,\"caption\":\"experte excel revelant des fonctions avancees en glow cyan\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.itta.net\\\/en\\\/en\\\/blog\\\/advanced-excel-10-functions-ignored\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.itta.net\\\/en\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Advanced Excel: the 10 Functions 90% of Professionals Ignore\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.itta.net\\\/en\\\/#website\",\"url\":\"https:\\\/\\\/www.itta.net\\\/en\\\/\",\"name\":\"ITTA\",\"description\":\"Formations &amp; Certifications en Suisse Romande\",\"publisher\":{\"@id\":\"https:\\\/\\\/www.itta.net\\\/en\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.itta.net\\\/en\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-GB\"},{\"@type\":[\"Organization\",\"EducationalOrganization\"],\"@id\":\"https:\\\/\\\/www.itta.net\\\/en\\\/#organization\",\"name\":\"ITTA\",\"alternateName\":\"IT TRAINING ACADEMY SA\",\"url\":\"https:\\\/\\\/www.itta.net\\\/en\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-GB\",\"@id\":\"https:\\\/\\\/www.itta.net\\\/en\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/www.itta.net\\\/wp-content\\\/uploads\\\/2023\\\/02\\\/Logo-transparent.png\",\"contentUrl\":\"https:\\\/\\\/www.itta.net\\\/wp-content\\\/uploads\\\/2023\\\/02\\\/Logo-transparent.png\",\"width\":1500,\"height\":623,\"caption\":\"ITTA\"},\"image\":{\"@id\":\"https:\\\/\\\/www.itta.net\\\/en\\\/#\\\/schema\\\/logo\\\/image\\\/\"},\"sameAs\":[\"https:\\\/\\\/www.facebook.com\\\/people\\\/ITTA\\\/100063747262936\\\/\",\"https:\\\/\\\/www.linkedin.com\\\/company\\\/1001738\",\"https:\\\/\\\/www.instagram.com\\\/itta_suisse\\\/\"],\"contactPoint\":{\"@type\":\"ContactPoint\",\"telephone\":\"+41 58 307 73 00\",\"contactType\":\"customer service\",\"availableLanguage\":[\"French\",\"English\"],\"areaServed\":[{\"@type\":\"Country\",\"name\":\"Switzerland\"},{\"@type\":\"Country\",\"name\":\"France\"}]},\"location\":[{\"@type\":\"Place\",\"name\":\"ITTA Geneve\",\"address\":{\"@type\":\"PostalAddress\",\"streetAddress\":\"Route des Jeunes 35\",\"addressLocality\":\"Carouge\",\"postalCode\":\"1227\",\"addressRegion\":\"GE\",\"addressCountry\":\"CH\"},\"geo\":{\"@type\":\"GeoCoordinates\",\"latitude\":46.18274,\"longitude\":6.12922}},{\"@type\":\"Place\",\"name\":\"ITTA Lausanne\",\"address\":{\"@type\":\"PostalAddress\",\"streetAddress\":\"Rue des Cotes-de-Montbenon 16\",\"addressLocality\":\"Lausanne\",\"postalCode\":\"1003\",\"addressRegion\":\"VD\",\"addressCountry\":\"CH\"},\"geo\":{\"@type\":\"GeoCoordinates\",\"latitude\":46.52111,\"longitude\":6.62734}}]},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.itta.net\\\/en\\\/#\\\/schema\\\/person\\\/ca875e6c61a8f6f224901d4b48e1494f\",\"name\":\"Damien Crocq\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-GB\",\"@id\":\"https:\\\/\\\/www.itta.net\\\/wp-content\\\/uploads\\\/2024\\\/04\\\/damien-bio-1-100x100.jpg\",\"url\":\"https:\\\/\\\/www.itta.net\\\/wp-content\\\/uploads\\\/2024\\\/04\\\/damien-bio-1-100x100.jpg\",\"contentUrl\":\"https:\\\/\\\/www.itta.net\\\/wp-content\\\/uploads\\\/2024\\\/04\\\/damien-bio-1-100x100.jpg\",\"caption\":\"Damien Crocq\"},\"description\":\"Damien est un professionnel dynamique, passionn\u00e9 par le marketing digital et le r\u00e9f\u00e9rencement naturel. Dipl\u00f4m\u00e9 d'un master en Web Marketing, il a acquis une solide exp\u00e9rience en e-commerce et a enseign\u00e9 sur des th\u00e9matiques de marketing digital. Aujourd'hui, il occupe le poste de sp\u00e9cialiste en marketing digital chez ITTA. Toujours curieux et innovant, Damien reste avant tout un passionn\u00e9 des technologies \u00e9mergentes, de l'informatique, de l'IA et du r\u00e9f\u00e9rencement naturel.\",\"sameAs\":[\"https:\\\/\\\/www.itta.net\",\"https:\\\/\\\/www.linkedin.com\\\/in\\\/damien-crocq\\\/?originalSubdomain=fr\"]}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Advanced Excel: 10 functions 90% ignore | ITTA","description":"XLOOKUP, FILTER, LAMBDA, LET... master the 10 modern Excel functions that will transform your productivity.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.itta.net\/en\/en\/blog\/advanced-excel-10-functions-ignored\/","twitter_misc":{"Written by":"Damien Crocq","Estimated reading time":"13 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.itta.net\/en\/en\/blog\/advanced-excel-10-functions-ignored\/#article","isPartOf":{"@id":"https:\/\/www.itta.net\/en\/en\/blog\/advanced-excel-10-functions-ignored\/"},"author":{"name":"Damien Crocq","@id":"https:\/\/www.itta.net\/en\/#\/schema\/person\/ca875e6c61a8f6f224901d4b48e1494f"},"headline":"Advanced Excel: the 10 Functions 90% of Professionals Ignore","datePublished":"2026-06-16T17:00:08+00:00","dateModified":"2026-06-16T17:06:05+00:00","mainEntityOfPage":{"@id":"https:\/\/www.itta.net\/en\/en\/blog\/advanced-excel-10-functions-ignored\/"},"wordCount":2133,"publisher":{"@id":"https:\/\/www.itta.net\/en\/#organization"},"image":{"@id":"https:\/\/www.itta.net\/en\/en\/blog\/advanced-excel-10-functions-ignored\/#primaryimage"},"thumbnailUrl":"https:\/\/www.itta.net\/wp-content\/uploads\/2026\/06\/a38-excel-avance-featured.webp","articleSection":["MS Office"],"inLanguage":"en-GB"},{"@type":"WebPage","@id":"https:\/\/www.itta.net\/en\/en\/blog\/advanced-excel-10-functions-ignored\/","url":"https:\/\/www.itta.net\/en\/en\/blog\/advanced-excel-10-functions-ignored\/","name":"Advanced Excel: 10 functions 90% ignore | ITTA","isPartOf":{"@id":"https:\/\/www.itta.net\/en\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.itta.net\/en\/en\/blog\/advanced-excel-10-functions-ignored\/#primaryimage"},"image":{"@id":"https:\/\/www.itta.net\/en\/en\/blog\/advanced-excel-10-functions-ignored\/#primaryimage"},"thumbnailUrl":"https:\/\/www.itta.net\/wp-content\/uploads\/2026\/06\/a38-excel-avance-featured.webp","datePublished":"2026-06-16T17:00:08+00:00","dateModified":"2026-06-16T17:06:05+00:00","description":"XLOOKUP, FILTER, LAMBDA, LET... master the 10 modern Excel functions that will transform your productivity.","breadcrumb":{"@id":"https:\/\/www.itta.net\/en\/en\/blog\/advanced-excel-10-functions-ignored\/#breadcrumb"},"inLanguage":"en-GB","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.itta.net\/en\/en\/blog\/advanced-excel-10-functions-ignored\/"]}]},{"@type":"ImageObject","inLanguage":"en-GB","@id":"https:\/\/www.itta.net\/en\/en\/blog\/advanced-excel-10-functions-ignored\/#primaryimage","url":"https:\/\/www.itta.net\/wp-content\/uploads\/2026\/06\/a38-excel-avance-featured.webp","contentUrl":"https:\/\/www.itta.net\/wp-content\/uploads\/2026\/06\/a38-excel-avance-featured.webp","width":1376,"height":768,"caption":"experte excel revelant des fonctions avancees en glow cyan"},{"@type":"BreadcrumbList","@id":"https:\/\/www.itta.net\/en\/en\/blog\/advanced-excel-10-functions-ignored\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.itta.net\/en\/"},{"@type":"ListItem","position":2,"name":"Advanced Excel: the 10 Functions 90% of Professionals Ignore"}]},{"@type":"WebSite","@id":"https:\/\/www.itta.net\/en\/#website","url":"https:\/\/www.itta.net\/en\/","name":"ITTA","description":"Formations &amp; Certifications en Suisse Romande","publisher":{"@id":"https:\/\/www.itta.net\/en\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.itta.net\/en\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-GB"},{"@type":["Organization","EducationalOrganization"],"@id":"https:\/\/www.itta.net\/en\/#organization","name":"ITTA","alternateName":"IT TRAINING ACADEMY SA","url":"https:\/\/www.itta.net\/en\/","logo":{"@type":"ImageObject","inLanguage":"en-GB","@id":"https:\/\/www.itta.net\/en\/#\/schema\/logo\/image\/","url":"https:\/\/www.itta.net\/wp-content\/uploads\/2023\/02\/Logo-transparent.png","contentUrl":"https:\/\/www.itta.net\/wp-content\/uploads\/2023\/02\/Logo-transparent.png","width":1500,"height":623,"caption":"ITTA"},"image":{"@id":"https:\/\/www.itta.net\/en\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/people\/ITTA\/100063747262936\/","https:\/\/www.linkedin.com\/company\/1001738","https:\/\/www.instagram.com\/itta_suisse\/"],"contactPoint":{"@type":"ContactPoint","telephone":"+41 58 307 73 00","contactType":"customer service","availableLanguage":["French","English"],"areaServed":[{"@type":"Country","name":"Switzerland"},{"@type":"Country","name":"France"}]},"location":[{"@type":"Place","name":"ITTA Geneve","address":{"@type":"PostalAddress","streetAddress":"Route des Jeunes 35","addressLocality":"Carouge","postalCode":"1227","addressRegion":"GE","addressCountry":"CH"},"geo":{"@type":"GeoCoordinates","latitude":46.18274,"longitude":6.12922}},{"@type":"Place","name":"ITTA Lausanne","address":{"@type":"PostalAddress","streetAddress":"Rue des Cotes-de-Montbenon 16","addressLocality":"Lausanne","postalCode":"1003","addressRegion":"VD","addressCountry":"CH"},"geo":{"@type":"GeoCoordinates","latitude":46.52111,"longitude":6.62734}}]},{"@type":"Person","@id":"https:\/\/www.itta.net\/en\/#\/schema\/person\/ca875e6c61a8f6f224901d4b48e1494f","name":"Damien Crocq","image":{"@type":"ImageObject","inLanguage":"en-GB","@id":"https:\/\/www.itta.net\/wp-content\/uploads\/2024\/04\/damien-bio-1-100x100.jpg","url":"https:\/\/www.itta.net\/wp-content\/uploads\/2024\/04\/damien-bio-1-100x100.jpg","contentUrl":"https:\/\/www.itta.net\/wp-content\/uploads\/2024\/04\/damien-bio-1-100x100.jpg","caption":"Damien Crocq"},"description":"Damien est un professionnel dynamique, passionn\u00e9 par le marketing digital et le r\u00e9f\u00e9rencement naturel. Dipl\u00f4m\u00e9 d'un master en Web Marketing, il a acquis une solide exp\u00e9rience en e-commerce et a enseign\u00e9 sur des th\u00e9matiques de marketing digital. Aujourd'hui, il occupe le poste de sp\u00e9cialiste en marketing digital chez ITTA. Toujours curieux et innovant, Damien reste avant tout un passionn\u00e9 des technologies \u00e9mergentes, de l'informatique, de l'IA et du r\u00e9f\u00e9rencement naturel.","sameAs":["https:\/\/www.itta.net","https:\/\/www.linkedin.com\/in\/damien-crocq\/?originalSubdomain=fr"]}]}},"_links":{"self":[{"href":"https:\/\/www.itta.net\/en\/wp-json\/wp\/v2\/posts\/253615","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.itta.net\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.itta.net\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.itta.net\/en\/wp-json\/wp\/v2\/users\/112"}],"replies":[{"embeddable":true,"href":"https:\/\/www.itta.net\/en\/wp-json\/wp\/v2\/comments?post=253615"}],"version-history":[{"count":5,"href":"https:\/\/www.itta.net\/en\/wp-json\/wp\/v2\/posts\/253615\/revisions"}],"predecessor-version":[{"id":253729,"href":"https:\/\/www.itta.net\/en\/wp-json\/wp\/v2\/posts\/253615\/revisions\/253729"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.itta.net\/en\/wp-json\/wp\/v2\/media\/253577"}],"wp:attachment":[{"href":"https:\/\/www.itta.net\/en\/wp-json\/wp\/v2\/media?parent=253615"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.itta.net\/en\/wp-json\/wp\/v2\/categories?post=253615"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.itta.net\/en\/wp-json\/wp\/v2\/tags?post=253615"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}