{"id":32161,"date":"2025-06-03T10:30:11","date_gmt":"2025-06-03T09:30:11","guid":{"rendered":"https:\/\/digilicenses.com\/?p=32161"},"modified":"2025-06-04T07:32:17","modified_gmt":"2025-06-04T06:32:17","slug":"how-to-create-dynamic-spreadsheets-in-excel-2024-using-smart-functions","status":"publish","type":"post","link":"https:\/\/digilicenses.com\/en\/blog\/how-to-create-dynamic-spreadsheets-in-excel-2024-using-smart-functions\/","title":{"rendered":"How to Create Dynamic Spreadsheets in Excel 2024 Using Smart Functions"},"content":{"rendered":"<p>Modern spreadsheet tasks demand more than just rows and columns. Today\u2019s users want automation, real-time insights, and seamless interactivity\u2014especially in Excel 2024. Whether you\u2019re handling financial data, project tracking, or performance metrics, using smart functions is key to creating dynamic spreadsheets that are both powerful and user-friendly.<\/p>\n<p>This blog will guide you through how to create dynamic spreadsheets in Excel 2024 using smart functions\u2014so you can save time, reduce errors, and impress your team.<\/p>\n<h2><span style=\"font-size: 24pt\"><b>What are smart functions in Excel 2024?<\/b><\/span><\/h2>\n<p><span style=\"font-weight: 400\">Excel 2024 builds on Microsoft's legacy of powerful data tools with a suite of <\/span><b>smart functions<\/b><span style=\"font-weight: 400\"> designed to streamline complex tasks. These functions use logic, data recognition, and even AI to simplify spreadsheet creation and enhance interactivity.<\/span><\/p>\n<h3><span style=\"font-size: 18pt\"><b>Examples of Smart Functions in Excel 2024<\/b><\/span><\/h3>\n<ul>\n<li style=\"font-weight: 400\"><b>XLOOKUP<\/b><span style=\"font-weight: 400\"> \u2013 Replaces VLOOKUP for more flexible data searching.<\/span><span style=\"font-weight: 400\">\n<p><\/span><\/li>\n<li style=\"font-weight: 400\"><b>LET Function<\/b><span style=\"font-weight: 400\"> \u2013 Assigns names to calculation results for better performance.<\/span><span style=\"font-weight: 400\">\n<p><\/span><\/li>\n<li style=\"font-weight: 400\"><b>TEXTSPLIT, TEXTBEFORE, TEXTAFTER<\/b><span style=\"font-weight: 400\"> \u2013 Break apart text easily.<\/span><span style=\"font-weight: 400\">\n<p><\/span><\/li>\n<li style=\"font-weight: 400\"><b>FILTER<\/b><span style=\"font-weight: 400\"> \u2013 Automatically extract data that meets certain criteria.<\/span><span style=\"font-weight: 400\">\n<p><\/span><\/li>\n<li style=\"font-weight: 400\"><b>SEQUENCE and RANDARRAY<\/b><span style=\"font-weight: 400\"> \u2013 Generate dynamic arrays.<\/span><span style=\"font-weight: 400\">\n<p><\/span><\/li>\n<li style=\"font-weight: 400\"><b>LAMBDA<\/b><span style=\"font-weight: 400\"> \u2013 Create custom, reusable functions within Excel.<\/span><span style=\"font-weight: 400\">\n<p><\/span><\/li>\n<\/ul>\n<h2><span style=\"font-size: 24pt\"><b>Why create dynamic spreadsheets?<\/b><\/span><\/h2>\n<p><span style=\"font-weight: 400\">Dynamic spreadsheets can:<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">Adapt automatically to changing data<\/span><span style=\"font-weight: 400\">\n<p><\/span><\/li>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">Eliminate manual errors<\/span><span style=\"font-weight: 400\">\n<p><\/span><\/li>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">Improve dashboard reporting<\/span><span style=\"font-weight: 400\">\n<p><\/span><\/li>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">Improve collaboration and decision-making<\/span><span style=\"font-weight: 400\">\n<p><\/span><\/li>\n<\/ul>\n<h2><span style=\"font-size: 24pt\"><b>Step-by-Step: How to Build a Dynamic Spreadsheet in Excel 2024<\/b><\/span><\/h2>\n<h3><span style=\"font-size: 18pt\"><b>1. Begin with Structured Data<\/b><\/span><\/h3>\n<p><span style=\"font-weight: 400\">Start by organizing your data into well-labeled tables. Use <\/span><b>Excel Tables (Ctrl + T)<\/b><span style=\"font-weight: 400\"> to auto-extend ranges and simplify formulas.<\/span><\/p>\n<h3><span style=\"font-size: 18pt\"><b>2. Use the FILTER function<\/b><\/span><\/h3>\n<p><span style=\"font-weight: 400\">To display only relevant information dynamically, use:<\/span><\/p>\n<p><span style=\"font-weight: 400\">=FILTER(A2:C100, B2:B100=\u201dPending\u201d)<\/span><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"font-weight: 400\">This pulls rows where column B equals \u201cPending\u201d.<\/span><\/p>\n<h3><span style=\"font-size: 18pt\"><b>3. Implement XLOOKUP for smarter searches<\/b><\/span><\/h3>\n<p><span style=\"font-weight: 400\">=XLOOKUP(\u201cEmployee A\u201d, A2:A100, C2:C100, \u201cNot Found\u201d)<\/span><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"font-weight: 400\">Unlike VLOOKUP, XLOOKUP can search in any direction and returns cleaner results.<\/span><\/p>\n<h3><span style=\"font-size: 18pt\"><b>4. Use the LET function for clean formulas<\/b><\/span><\/h3>\n<p><span style=\"font-weight: 400\">=LET(x, A1+A2, y, A3*A4, x+y)<\/span><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"font-weight: 400\">This boosts performance and readability in complex spreadsheets.<\/span><\/p>\n<h3><span style=\"font-size: 18pt\"><b>5. Automate Calculations with Dynamic Arrays<\/b><\/span><\/h3>\n<p><span style=\"font-weight: 400\">Use <\/span><b>SEQUENCE<\/b><span style=\"font-weight: 400\"> to create dynamic number patterns:<\/span><\/p>\n<p><span style=\"font-weight: 400\">=SEQUENCE(10, 1, 1, 2)\u00a0\u00a0<\/span><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"font-weight: 400\">Creates 10 values, starting from 1, increasing by 2.<\/span><\/p>\n<h3><span style=\"font-size: 18pt\"><b>6. Create custom functions using LAMBDA<\/b><\/span><\/h3>\n<p><span style=\"font-weight: 400\">=LAMBDA(x, x^2)(4)<\/span><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"font-weight: 400\">This returns 16. You can define and reuse these functions throughout the workbook.<\/span><\/p>\n<h2><span style=\"font-size: 18pt\"><b>Best Practices for Dynamic Excel Spreadsheets<\/b><\/span><\/h2>\n<ul>\n<li style=\"font-weight: 400\"><b>Avoid hardcoding<\/b><span style=\"font-weight: 400\"> values in formulas<\/span><span style=\"font-weight: 400\">\n<p><\/span><\/li>\n<li style=\"font-weight: 400\"><b>Use named ranges<\/b><span style=\"font-weight: 400\"> for clarity<\/span><span style=\"font-weight: 400\">\n<p><\/span><\/li>\n<li style=\"font-weight: 400\"><b>Combine IF, IFS, and SWITCH<\/b><span style=\"font-weight: 400\"> for logic-based automation<\/span><span style=\"font-weight: 400\">\n<p><\/span><\/li>\n<li style=\"font-weight: 400\"><b>Apply Conditional Formatting<\/b><span style=\"font-weight: 400\"> visualize changes<\/span><span style=\"font-weight: 400\">\n<p><\/span><\/li>\n<li style=\"font-weight: 400\"><b>Regularly audit formulas<\/b><span style=\"font-weight: 400\"> to catch logical errors<\/span><span style=\"font-weight: 400\">\n<p><\/span><\/li>\n<\/ul>\n<h2><span style=\"font-size: 24pt\"><b>Common Use Cases for Smart Functions<\/b><\/span><\/h2>\n<h3><span style=\"font-size: 18pt\"><b>Financial reporting<\/b><\/span><\/h3>\n<ul>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">Summarize expenses by category with <\/span><b>SUMIFS<\/b><b>\n<p><\/b><\/li>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">Filter live data for quarterly updates using <\/span><b>FILTER<\/b><b>\n<p><\/b><\/li>\n<\/ul>\n<h3><span style=\"font-size: 18pt\"><b>HR dashboards<\/b><\/span><\/h3>\n<ul>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">Use <\/span><b>XLOOKUP<\/b><span style=\"font-weight: 400\"> to retrieve employee data from master tables<\/span><span style=\"font-weight: 400\">\n<p><\/span><\/li>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">Build dropdown-driven views with <\/span><b>DATA VALIDATION + FILTER<\/b><b>\n<p><\/b><\/li>\n<\/ul>\n<h3><span style=\"font-size: 18pt\"><b>Project Management<\/b><\/span><\/h3>\n<ul>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">Track project status using dynamic <\/span><b>GANTT charts<\/b><b>\n<p><\/b><\/li>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">Calculate deadlines using <\/span><b>WORKDAY.INTL<\/b><b>\n<p><\/b><\/li>\n<\/ul>\n<h2><span style=\"font-size: 24pt\"><b>Conclusion<\/b><\/span><\/h2>\n<p>Creating dynamic spreadsheets in Excel 2024 using smart functions is no longer optional\u2014it\u2019s a necessity for efficiency and accuracy. From automating tasks to making data easier to interpret, smart functions are transforming the way professionals work with Excel.<\/p>\n<p><span style=\"font-weight: 400\">For more such insightful content and tools, visit<\/span><a href=\"https:\/\/digilicenses.com\/en\/\"> <span style=\"font-weight: 400\">Digital licenses<\/span><\/a><span style=\"font-weight: 400\"> and explore the latest Microsoft solutions that support your productivity.<\/span><\/p>\n<h2><b>Frequently Asked Questions<\/b><\/h2>\n<p><b>Q1. What makes a spreadsheet \u201cdynamic\u201d in Excel 2024?<\/b><b><br \/>\n<\/b><span style=\"font-weight: 400\"> A dynamic spreadsheet updates automatically based on data inputs, using functions like FILTER, XLOOKUP, and dynamic arrays.<\/span><\/p>\n<p><b>Q2. Can I still use older functions like VLOOKUP in Excel 2024?<\/b><b><br \/>\n<\/b><span style=\"font-weight: 400\"> Yes, but it is recommended to transition to XLOOKUP or INDEX-MATCH for better flexibility and performance.<\/span><\/p>\n<p><b>Q3. Are Excel 2024 smart functions available in all versions?<\/b><b><br \/>\n<\/b> Smart functions are available in Microsoft 365 and Excel 2024 standalone licenses. Some features may not work in older desktop versions.<\/p>","protected":false},"excerpt":{"rendered":"<p>Modern spreadsheet tasks demand more than just rows and columns. Today\u2019s users want automation, real-time insights, and seamless interactivity\u2014especially in Excel 2024. Whether you&#8217;re handling financial data, project tracking, or performance metrics, using smart functions is key to creating dynamic spreadsheets that are both powerful and user-friendly. This blog will guide you through how to [&hellip;]<\/p>\n","protected":false},"author":853,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-32161","post","type-post","status-publish","format-standard","hentry","category-all"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.7 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Create Dynamic Spreadsheets in Excel 2024<\/title>\n<meta name=\"description\" content=\"Master Excel 2024 smart functions to build dynamic spreadsheets with ease. Learn formulas, tips, and best practices.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/digilicenses.com\/en\/blog\/how-to-create-dynamic-spreadsheets-in-excel-2024-using-smart-functions\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Create Dynamic Spreadsheets in Excel 2024\" \/>\n<meta property=\"og:description\" content=\"Master Excel 2024 smart functions to build dynamic spreadsheets with ease. Learn formulas, tips, and best practices.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/digilicenses.com\/en\/blog\/how-to-create-dynamic-spreadsheets-in-excel-2024-using-smart-functions\/\" \/>\n<meta property=\"og:site_name\" content=\"digilicenses\" \/>\n<meta property=\"article:published_time\" content=\"2025-06-03T09:30:11+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-06-04T06:32:17+00:00\" \/>\n<meta name=\"author\" content=\"pushkar\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"pushkar\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/digilicenses.com\\\/blog\\\/how-to-create-dynamic-spreadsheets-in-excel-2024-using-smart-functions\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/digilicenses.com\\\/blog\\\/how-to-create-dynamic-spreadsheets-in-excel-2024-using-smart-functions\\\/\"},\"author\":{\"name\":\"pushkar\",\"@id\":\"https:\\\/\\\/digilicenses.com\\\/#\\\/schema\\\/person\\\/d8cfa9bd1637e9e15b71f3cfdc5f034d\"},\"headline\":\"How to Create Dynamic Spreadsheets in Excel 2024 Using Smart Functions\",\"datePublished\":\"2025-06-03T09:30:11+00:00\",\"dateModified\":\"2025-06-04T06:32:17+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/digilicenses.com\\\/blog\\\/how-to-create-dynamic-spreadsheets-in-excel-2024-using-smart-functions\\\/\"},\"wordCount\":585,\"publisher\":{\"@id\":\"https:\\\/\\\/digilicenses.com\\\/#organization\"},\"articleSection\":[\"All\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/digilicenses.com\\\/blog\\\/how-to-create-dynamic-spreadsheets-in-excel-2024-using-smart-functions\\\/\",\"url\":\"https:\\\/\\\/digilicenses.com\\\/blog\\\/how-to-create-dynamic-spreadsheets-in-excel-2024-using-smart-functions\\\/\",\"name\":\"Create Dynamic Spreadsheets in Excel 2024\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/digilicenses.com\\\/#website\"},\"datePublished\":\"2025-06-03T09:30:11+00:00\",\"dateModified\":\"2025-06-04T06:32:17+00:00\",\"description\":\"Master Excel 2024 smart functions to build dynamic spreadsheets with ease. Learn formulas, tips, and best practices.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/digilicenses.com\\\/blog\\\/how-to-create-dynamic-spreadsheets-in-excel-2024-using-smart-functions\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/digilicenses.com\\\/blog\\\/how-to-create-dynamic-spreadsheets-in-excel-2024-using-smart-functions\\\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/digilicenses.com\\\/blog\\\/how-to-create-dynamic-spreadsheets-in-excel-2024-using-smart-functions\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Start\",\"item\":\"https:\\\/\\\/digilicenses.com\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How to Create Dynamic Spreadsheets in Excel 2024 Using Smart Functions\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/digilicenses.com\\\/#website\",\"url\":\"https:\\\/\\\/digilicenses.com\\\/\",\"name\":\"digilicenses\",\"description\":\"Shop digilicenses\",\"publisher\":{\"@id\":\"https:\\\/\\\/digilicenses.com\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/digilicenses.com\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/digilicenses.com\\\/#organization\",\"name\":\"digilicenses\",\"url\":\"https:\\\/\\\/digilicenses.com\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/digilicenses.com\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/digilicenses.com\\\/wp-content\\\/uploads\\\/2022\\\/06\\\/cropped-Logotipo-1200x300-1-1.jpg\",\"contentUrl\":\"https:\\\/\\\/digilicenses.com\\\/wp-content\\\/uploads\\\/2022\\\/06\\\/cropped-Logotipo-1200x300-1-1.jpg\",\"width\":1044,\"height\":300,\"caption\":\"digilicenses\"},\"image\":{\"@id\":\"https:\\\/\\\/digilicenses.com\\\/#\\\/schema\\\/logo\\\/image\\\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/digilicenses.com\\\/#\\\/schema\\\/person\\\/d8cfa9bd1637e9e15b71f3cfdc5f034d\",\"name\":\"pushkar\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/b9c200a342a909cc91092dac06b219a5b7f384f014dc6fa7e1859dca7c984ba6?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/b9c200a342a909cc91092dac06b219a5b7f384f014dc6fa7e1859dca7c984ba6?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/b9c200a342a909cc91092dac06b219a5b7f384f014dc6fa7e1859dca7c984ba6?s=96&d=mm&r=g\",\"caption\":\"pushkar\"},\"url\":\"https:\\\/\\\/digilicenses.com\\\/en\\\/blog\\\/author\\\/pushkar\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Create Dynamic Spreadsheets in Excel 2024","description":"Master Excel 2024 smart functions to build dynamic spreadsheets with ease. Learn formulas, tips, and best practices.","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:\/\/digilicenses.com\/en\/blog\/how-to-create-dynamic-spreadsheets-in-excel-2024-using-smart-functions\/","og_locale":"en_US","og_type":"article","og_title":"Create Dynamic Spreadsheets in Excel 2024","og_description":"Master Excel 2024 smart functions to build dynamic spreadsheets with ease. Learn formulas, tips, and best practices.","og_url":"https:\/\/digilicenses.com\/en\/blog\/how-to-create-dynamic-spreadsheets-in-excel-2024-using-smart-functions\/","og_site_name":"digilicenses","article_published_time":"2025-06-03T09:30:11+00:00","article_modified_time":"2025-06-04T06:32:17+00:00","author":"pushkar","twitter_card":"summary_large_image","twitter_misc":{"Written by":"pushkar","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/digilicenses.com\/blog\/how-to-create-dynamic-spreadsheets-in-excel-2024-using-smart-functions\/#article","isPartOf":{"@id":"https:\/\/digilicenses.com\/blog\/how-to-create-dynamic-spreadsheets-in-excel-2024-using-smart-functions\/"},"author":{"name":"pushkar","@id":"https:\/\/digilicenses.com\/#\/schema\/person\/d8cfa9bd1637e9e15b71f3cfdc5f034d"},"headline":"How to Create Dynamic Spreadsheets in Excel 2024 Using Smart Functions","datePublished":"2025-06-03T09:30:11+00:00","dateModified":"2025-06-04T06:32:17+00:00","mainEntityOfPage":{"@id":"https:\/\/digilicenses.com\/blog\/how-to-create-dynamic-spreadsheets-in-excel-2024-using-smart-functions\/"},"wordCount":585,"publisher":{"@id":"https:\/\/digilicenses.com\/#organization"},"articleSection":["All"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/digilicenses.com\/blog\/how-to-create-dynamic-spreadsheets-in-excel-2024-using-smart-functions\/","url":"https:\/\/digilicenses.com\/blog\/how-to-create-dynamic-spreadsheets-in-excel-2024-using-smart-functions\/","name":"Create Dynamic Spreadsheets in Excel 2024","isPartOf":{"@id":"https:\/\/digilicenses.com\/#website"},"datePublished":"2025-06-03T09:30:11+00:00","dateModified":"2025-06-04T06:32:17+00:00","description":"Master Excel 2024 smart functions to build dynamic spreadsheets with ease. Learn formulas, tips, and best practices.","breadcrumb":{"@id":"https:\/\/digilicenses.com\/blog\/how-to-create-dynamic-spreadsheets-in-excel-2024-using-smart-functions\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/digilicenses.com\/blog\/how-to-create-dynamic-spreadsheets-in-excel-2024-using-smart-functions\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/digilicenses.com\/blog\/how-to-create-dynamic-spreadsheets-in-excel-2024-using-smart-functions\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Start","item":"https:\/\/digilicenses.com\/"},{"@type":"ListItem","position":2,"name":"How to Create Dynamic Spreadsheets in Excel 2024 Using Smart Functions"}]},{"@type":"WebSite","@id":"https:\/\/digilicenses.com\/#website","url":"https:\/\/digilicenses.com\/","name":"digital licenses","description":"Shop digilicenses","publisher":{"@id":"https:\/\/digilicenses.com\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/digilicenses.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/digilicenses.com\/#organization","name":"digital licenses","url":"https:\/\/digilicenses.com\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/digilicenses.com\/#\/schema\/logo\/image\/","url":"https:\/\/digilicenses.com\/wp-content\/uploads\/2022\/06\/cropped-Logotipo-1200x300-1-1.jpg","contentUrl":"https:\/\/digilicenses.com\/wp-content\/uploads\/2022\/06\/cropped-Logotipo-1200x300-1-1.jpg","width":1044,"height":300,"caption":"digilicenses"},"image":{"@id":"https:\/\/digilicenses.com\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/digilicenses.com\/#\/schema\/person\/d8cfa9bd1637e9e15b71f3cfdc5f034d","name":"pushkar","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/b9c200a342a909cc91092dac06b219a5b7f384f014dc6fa7e1859dca7c984ba6?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/b9c200a342a909cc91092dac06b219a5b7f384f014dc6fa7e1859dca7c984ba6?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/b9c200a342a909cc91092dac06b219a5b7f384f014dc6fa7e1859dca7c984ba6?s=96&d=mm&r=g","caption":"pushkar"},"url":"https:\/\/digilicenses.com\/en\/blog\/author\/pushkar\/"}]}},"_links":{"self":[{"href":"https:\/\/digilicenses.com\/en\/wp-json\/wp\/v2\/posts\/32161","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/digilicenses.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/digilicenses.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/digilicenses.com\/en\/wp-json\/wp\/v2\/users\/853"}],"replies":[{"embeddable":true,"href":"https:\/\/digilicenses.com\/en\/wp-json\/wp\/v2\/comments?post=32161"}],"version-history":[{"count":0,"href":"https:\/\/digilicenses.com\/en\/wp-json\/wp\/v2\/posts\/32161\/revisions"}],"wp:attachment":[{"href":"https:\/\/digilicenses.com\/en\/wp-json\/wp\/v2\/media?parent=32161"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/digilicenses.com\/en\/wp-json\/wp\/v2\/categories?post=32161"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/digilicenses.com\/en\/wp-json\/wp\/v2\/tags?post=32161"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}