{"id":9555,"date":"2022-03-03T09:00:12","date_gmt":"2022-03-03T17:00:12","guid":{"rendered":"https:\/\/www.microsoft.com\/garage-en-us\/?p=9555"},"modified":"2022-03-03T09:00:12","modified_gmt":"2022-03-03T17:00:12","slug":"a-new-way-to-author-and-share-excel-named-formulas-advanced-formula-environment-a-microsoft-garage-project","status":"publish","type":"post","link":"http://approjects.co.za/?big=en-us/garage\/blog\/2022\/03\/a-new-way-to-author-and-share-excel-named-formulas-advanced-formula-environment-a-microsoft-garage-project\/","title":{"rendered":"A new way to author and share Excel named formulas: advanced formula environment, a Microsoft Garage project"},"content":{"rendered":"<p>Advanced formula environment, a Microsoft Garage project, enables Excel users to write complex formulas efficiently and then share them in an Office Add-In for Excel.<\/p>\n<p>With the recent addition of the<a href=\"https:\/\/techcommunity.microsoft.com\/t5\/excel-blog\/announcing-lambda-turn-excel-formulas-into-custom-functions\/ba-p\/1925546\" target=\"_blank\" rel=\"noopener\"> LAMBDA<\/a> function to Excel, it is now possible to author your own custom functions using the same formula language that powers millions of spreadsheets today. Excel LAMBDA significantly expands the raw capability of spreadsheets and provides a new horizon in which to explore how to write and share named formulas.<\/p>\n<h3>The start of a journey<\/h3>\n<p>The advanced formula environment, a new Excel add-in, makes authoring named formulas easier.<\/p>\n<p>Drawing inspiration from popular code editors\u2014including Visual Studio Code\u2014the advanced formula environment add-in provides you with features such as intellisense, code folding, inline error detection, formatting, and namespaces.<\/p>\n<p>The advanced formula environment team designed this add-in to help you amplify what you can achieve using LAMBDA, and the team views this as their first step to understanding what you can do by programming in formulas.<\/p>\n<h3>New capabilities for writing Excel named formulas<\/h3>\n<p>With the add-in you can write\u2014and share\u2014named formulas using new capabilities including:<\/p>\n<ul>\n<li><strong>Enhanced formula editor<\/strong> allows you to add comments to your code, undo and redo your edits, define named formulas, and easily create multi-line formulas<\/li>\n<li><strong>Share your work with others<\/strong> through <a href=\"https:\/\/gist.github.com\/discover\" target=\"_blank\" rel=\"noopener\">GitHub Gists<\/a>\u00a0to reap the benefits of repositories and more easily migrate your logic between spreadsheets<\/li>\n<li><strong>Filter and find your formulas<\/strong> with intelligent filter functionality to easily locate the formula you need<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-9597\" src=\"\/wp-content\/uploads\/2022\/02\/AFE_Panes-scaled.jpg\" alt=\"Screenshot advanced formula environment panes scaled\" width=\"2560\" height=\"824\" \/><\/p>\n<p>All the new capabilities for writing Excel named formulas are available at Excel for the web, Windows, and Mac platforms\u2014get it now in the <a href=\"https:\/\/appsource.microsoft.com\/en-us\/product\/office\/WA200003696\" target=\"_blank\" rel=\"noopener\">Office Store<\/a>.<\/p>\n<h3>Connect\u00a0with the advanced formula environment team<\/h3>\n<p>This project was born as a collaboration between the Excel and <a href=\"https:\/\/www.microsoft.com\/en-us\/research\/project\/calc-intelligence\/\" target=\"_blank\" rel=\"noopener\">Microsoft Research<\/a> Cambridge teams. The team fundamentally believes in empowering Excel formula authors to do more, and felt it was necessary to create a suite of new tools that allows for experimentation and transformation of what is possible in Excel.<\/p>\n<p>The advanced formula environment team is actively seeking feedback on this Microsoft Garage project. They want to know what works, and what doesn\u2019t. This is an exciting advancement for Excel and a great opportunity for the team to learn. Please share your feedback via the <a href=\"https:\/\/github.com\/microsoft\/advanced-formula-environment\" target=\"_blank\" rel=\"noopener\">GitHub page<\/a> or in the <a href=\"https:\/\/techcommunity.microsoft.com\/t5\/microsoft-excel\/ct-p\/Excel_Cat\" target=\"_blank\" rel=\"noopener\">Microsoft Excel community hub<\/a>.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Advanced formula environment, a Microsoft Garage project, enables Excel users to write complex formulas efficiently and then share them in an Office Add-In for Excel. With the recent addition of the LAMBDA function to Excel, it is now possible to author your own custom functions using the same formula language that powers millions of spreadsheets today. Excel LAMBDA significantly expands<span class=\"read-more-ellipsis\">&#8230;.<\/span><\/p>\n <p class=\"c-paragraph-3 read-more-link\"><a class=\"c-call-to-action c-glyph f-lightweight\" href=\"http://approjects.co.za/?big=en-us/garage\/blog\/2022\/03\/a-new-way-to-author-and-share-excel-named-formulas-advanced-formula-environment-a-microsoft-garage-project\/\">CONTINUE READING <span class=\"x-screen-reader\">\"A new way to author and share Excel named formulas: advanced formula environment, a Microsoft Garage project\"<\/span><\/a><\/p>","protected":false},"author":18,"featured_media":9618,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[5,4],"tags":[136,29,2,44,137,81],"class_list":["post-9555","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-garage-general","category-garage-projects","tag-excel","tag-garage","tag-garage-project","tag-garage-projects","tag-lambda","tag-office"],"acf":[],"yoast_head":"<title>A new way to author and share Excel named formulas: advanced formula environment, a Microsoft Garage project | Microsoft Garage<\/title>\n<meta name=\"description\" content=\"Advanced formula environment, a Microsoft Garage project, enables Excel users to write complex formulas efficiently and then share them in an Office Add-In for Excel.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"http://approjects.co.za/?big=en-us/garage\/blog\/2022\/03\/a-new-way-to-author-and-share-excel-named-formulas-advanced-formula-environment-a-microsoft-garage-project\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"A new way to author and share Excel named formulas: advanced formula environment, a Microsoft Garage project | Microsoft Garage\" \/>\n<meta property=\"og:description\" content=\"Advanced formula environment, a Microsoft Garage project, enables Excel users to write complex formulas efficiently and then share them in an Office Add-In for Excel.\" \/>\n<meta property=\"og:url\" content=\"http://approjects.co.za/?big=en-us/garage\/blog\/2022\/03\/a-new-way-to-author-and-share-excel-named-formulas-advanced-formula-environment-a-microsoft-garage-project\/\" \/>\n<meta property=\"og:site_name\" content=\"Microsoft Garage\" \/>\n<meta property=\"article:published_time\" content=\"2022-03-03T17:00:12+00:00\" \/>\n<meta property=\"og:image\" content=\"http://approjects.co.za/?big=en-us/garage\/wp-content\/uploads\/2022\/03\/tweetImage.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1200\" \/>\n\t<meta property=\"og:image:height\" content=\"675\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Renee Malone\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@MSFTGarage\" \/>\n<meta name=\"twitter:site\" content=\"@MSFTGarage\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Renee Malone\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"http://approjects.co.za/?big=en-us/garage\/blog\/2022\/03\/a-new-way-to-author-and-share-excel-named-formulas-advanced-formula-environment-a-microsoft-garage-project\/\",\"url\":\"http://approjects.co.za/?big=en-us/garage\/blog\/2022\/03\/a-new-way-to-author-and-share-excel-named-formulas-advanced-formula-environment-a-microsoft-garage-project\/\",\"name\":\"A new way to author and share Excel named formulas: advanced formula environment, a Microsoft Garage project | Microsoft Garage\",\"isPartOf\":{\"@id\":\"http://approjects.co.za/?big=en-us/garage\/#website\"},\"primaryImageOfPage\":{\"@id\":\"http://approjects.co.za/?big=en-us/garage\/blog\/2022\/03\/a-new-way-to-author-and-share-excel-named-formulas-advanced-formula-environment-a-microsoft-garage-project\/#primaryimage\"},\"image\":{\"@id\":\"http://approjects.co.za/?big=en-us/garage\/blog\/2022\/03\/a-new-way-to-author-and-share-excel-named-formulas-advanced-formula-environment-a-microsoft-garage-project\/#primaryimage\"},\"thumbnailUrl\":\"\/wp-content\/uploads\/2022\/03\/tweetImage.jpg\",\"datePublished\":\"2022-03-03T17:00:12+00:00\",\"dateModified\":\"2022-03-03T17:00:12+00:00\",\"author\":{\"@id\":\"http://approjects.co.za/?big=en-us/garage\/#\/schema\/person\/3af1b0424a3fb9caf4151356fcc9f203\"},\"description\":\"Advanced formula environment, a Microsoft Garage project, enables Excel users to write complex formulas efficiently and then share them in an Office Add-In for Excel.\",\"breadcrumb\":{\"@id\":\"http://approjects.co.za/?big=en-us/garage\/blog\/2022\/03\/a-new-way-to-author-and-share-excel-named-formulas-advanced-formula-environment-a-microsoft-garage-project\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"http://approjects.co.za/?big=en-us/garage\/blog\/2022\/03\/a-new-way-to-author-and-share-excel-named-formulas-advanced-formula-environment-a-microsoft-garage-project\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"http://approjects.co.za/?big=en-us/garage\/blog\/2022\/03\/a-new-way-to-author-and-share-excel-named-formulas-advanced-formula-environment-a-microsoft-garage-project\/#primaryimage\",\"url\":\"\/wp-content\/uploads\/2022\/03\/tweetImage.jpg\",\"contentUrl\":\"\/wp-content\/uploads\/2022\/03\/tweetImage.jpg\",\"width\":1200,\"height\":675,\"caption\":\"screenshot advanced formula environment\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"http://approjects.co.za/?big=en-us/garage\/blog\/2022\/03\/a-new-way-to-author-and-share-excel-named-formulas-advanced-formula-environment-a-microsoft-garage-project\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"http://approjects.co.za/?big=en-us/garage\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"A new way to author and share Excel named formulas: advanced formula environment, a Microsoft Garage project\"}]},{\"@type\":\"WebSite\",\"@id\":\"http://approjects.co.za/?big=en-us/garage\/#website\",\"url\":\"http://approjects.co.za/?big=en-us/garage\/\",\"name\":\"Microsoft Garage\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"http://approjects.co.za/?big=en-us/garage\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"http://approjects.co.za/?big=en-us/garage\/#\/schema\/person\/3af1b0424a3fb9caf4151356fcc9f203\",\"name\":\"Renee Malone\",\"url\":\"http://approjects.co.za/?big=en-us/garage\/blog\/author\/rmalone\/\"}]}<\/script>","yoast_head_json":{"title":"A new way to author and share Excel named formulas: advanced formula environment, a Microsoft Garage project | Microsoft Garage","description":"Advanced formula environment, a Microsoft Garage project, enables Excel users to write complex formulas efficiently and then share them in an Office Add-In for Excel.","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":"http://approjects.co.za/?big=en-us/garage\/blog\/2022\/03\/a-new-way-to-author-and-share-excel-named-formulas-advanced-formula-environment-a-microsoft-garage-project\/","og_locale":"en_US","og_type":"article","og_title":"A new way to author and share Excel named formulas: advanced formula environment, a Microsoft Garage project | Microsoft Garage","og_description":"Advanced formula environment, a Microsoft Garage project, enables Excel users to write complex formulas efficiently and then share them in an Office Add-In for Excel.","og_url":"http://approjects.co.za/?big=en-us/garage\/blog\/2022\/03\/a-new-way-to-author-and-share-excel-named-formulas-advanced-formula-environment-a-microsoft-garage-project\/","og_site_name":"Microsoft Garage","article_published_time":"2022-03-03T17:00:12+00:00","og_image":[{"width":1200,"height":675,"url":"http://approjects.co.za/?big=en-us/garage\/wp-content\/uploads\/2022\/03\/tweetImage.jpg","type":"image\/jpeg"}],"author":"Renee Malone","twitter_card":"summary_large_image","twitter_creator":"@MSFTGarage","twitter_site":"@MSFTGarage","twitter_misc":{"Written by":"Renee Malone","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"http://approjects.co.za/?big=en-us/garage\/blog\/2022\/03\/a-new-way-to-author-and-share-excel-named-formulas-advanced-formula-environment-a-microsoft-garage-project\/","url":"http://approjects.co.za/?big=en-us/garage\/blog\/2022\/03\/a-new-way-to-author-and-share-excel-named-formulas-advanced-formula-environment-a-microsoft-garage-project\/","name":"A new way to author and share Excel named formulas: advanced formula environment, a Microsoft Garage project | Microsoft Garage","isPartOf":{"@id":"http://approjects.co.za/?big=en-us/garage\/#website"},"primaryImageOfPage":{"@id":"http://approjects.co.za/?big=en-us/garage\/blog\/2022\/03\/a-new-way-to-author-and-share-excel-named-formulas-advanced-formula-environment-a-microsoft-garage-project\/#primaryimage"},"image":{"@id":"http://approjects.co.za/?big=en-us/garage\/blog\/2022\/03\/a-new-way-to-author-and-share-excel-named-formulas-advanced-formula-environment-a-microsoft-garage-project\/#primaryimage"},"thumbnailUrl":"\/wp-content\/uploads\/2022\/03\/tweetImage.jpg","datePublished":"2022-03-03T17:00:12+00:00","dateModified":"2022-03-03T17:00:12+00:00","author":{"@id":"http://approjects.co.za/?big=en-us/garage\/#\/schema\/person\/3af1b0424a3fb9caf4151356fcc9f203"},"description":"Advanced formula environment, a Microsoft Garage project, enables Excel users to write complex formulas efficiently and then share them in an Office Add-In for Excel.","breadcrumb":{"@id":"http://approjects.co.za/?big=en-us/garage\/blog\/2022\/03\/a-new-way-to-author-and-share-excel-named-formulas-advanced-formula-environment-a-microsoft-garage-project\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["http://approjects.co.za/?big=en-us/garage\/blog\/2022\/03\/a-new-way-to-author-and-share-excel-named-formulas-advanced-formula-environment-a-microsoft-garage-project\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"http://approjects.co.za/?big=en-us/garage\/blog\/2022\/03\/a-new-way-to-author-and-share-excel-named-formulas-advanced-formula-environment-a-microsoft-garage-project\/#primaryimage","url":"\/wp-content\/uploads\/2022\/03\/tweetImage.jpg","contentUrl":"\/wp-content\/uploads\/2022\/03\/tweetImage.jpg","width":1200,"height":675,"caption":"screenshot advanced formula environment"},{"@type":"BreadcrumbList","@id":"http://approjects.co.za/?big=en-us/garage\/blog\/2022\/03\/a-new-way-to-author-and-share-excel-named-formulas-advanced-formula-environment-a-microsoft-garage-project\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"http://approjects.co.za/?big=en-us/garage\/"},{"@type":"ListItem","position":2,"name":"A new way to author and share Excel named formulas: advanced formula environment, a Microsoft Garage project"}]},{"@type":"WebSite","@id":"http://approjects.co.za/?big=en-us/garage\/#website","url":"http://approjects.co.za/?big=en-us/garage\/","name":"Microsoft Garage","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"http://approjects.co.za/?big=en-us/garage\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"http://approjects.co.za/?big=en-us/garage\/#\/schema\/person\/3af1b0424a3fb9caf4151356fcc9f203","name":"Renee Malone","url":"http://approjects.co.za/?big=en-us/garage\/blog\/author\/rmalone\/"}]}},"_links":{"self":[{"href":"http://approjects.co.za/?big=en-us/garage\/wp-json\/wp\/v2\/posts\/9555"}],"collection":[{"href":"http://approjects.co.za/?big=en-us/garage\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http://approjects.co.za/?big=en-us/garage\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http://approjects.co.za/?big=en-us/garage\/wp-json\/wp\/v2\/users\/18"}],"replies":[{"embeddable":true,"href":"http://approjects.co.za/?big=en-us/garage\/wp-json\/wp\/v2\/comments?post=9555"}],"version-history":[{"count":0,"href":"http://approjects.co.za/?big=en-us/garage\/wp-json\/wp\/v2\/posts\/9555\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"http://approjects.co.za/?big=en-us/garage\/wp-json\/wp\/v2\/media\/9618"}],"wp:attachment":[{"href":"http://approjects.co.za/?big=en-us/garage\/wp-json\/wp\/v2\/media?parent=9555"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http://approjects.co.za/?big=en-us/garage\/wp-json\/wp\/v2\/categories?post=9555"},{"taxonomy":"post_tag","embeddable":true,"href":"http://approjects.co.za/?big=en-us/garage\/wp-json\/wp\/v2\/tags?post=9555"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}