Top 10 features of the latest version of Microsoft Excel:

Black Section Separator By Saurabh Pandey 27-04-2024

Co-authoring: Collaborate seamlessly with colleagues by working on the same Excel workbook simultaneously. Changes are visible in seconds, making teamwork efficient

[{"selector":"#anim-3b7e92a0-b9c9-4111-bd05-1e695622d7ad","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-932bc219-faa9-4120-b696-1ebb1438f8bb","keyframes":{"transform":["translate3d(0px, 120.00777%, 0)","translate3d(0px, 0px, 0)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-97a0a2a3-6a2c-42fb-a6e5-ad005a2b304e","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"both"}] [{"selector":"#anim-ccd0d59c-e446-44b0-a0c1-1f8c07806cb6","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"both"}] [{"selector":"#anim-1268b5cb-3933-4c02-83e2-453fedff039f","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"both"}] [{"selector":"#anim-56bc29d3-de9d-4a7e-8b48-9b93fc7c14f2 [data-leaf-element=\"true\"]","keyframes":{"transform":["translate3d(-31.248050821764835%, 0, 0) translate(-25%, 0%) scale(1.5)","translate3d(0%, 0, 0) translate(0%, 0%) scale(1)"]},"delay":0,"duration":2000,"fill":"forwards"}] Black Section Separator By Saurabh Pandey 27-04-2024

Modern Comments: Enjoy better collaboration with consistent commenting experiences across workbooks and other Office apps

[{"selector":"#anim-2081a4a5-6cde-4867-ba79-51ccf763910b","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-4bfa78c5-9a9c-41b6-89a0-67c7bf7cdcee","keyframes":{"transform":["translate3d(0px, 120.00777%, 0)","translate3d(0px, 0px, 0)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-bb7a5332-f8c1-4de1-a0d5-8188efc17d5d","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"both"}] [{"selector":"#anim-bd170608-59d9-4099-a2cf-a4db7fa087a4","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"both"}] [{"selector":"#anim-db21f613-7fce-457a-b695-3f5682504751","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"both"}] [{"selector":"#anim-5329bef4-1ebe-4942-b98c-497e556b611d [data-leaf-element=\"true\"]","keyframes":{"transform":["translate3d(-20.35933798113858%, 0, 0) translate(-25%, 0%) scale(1.5)","translate3d(0%, 0, 0) translate(0%, 0%) scale(1)"]},"delay":0,"duration":2000,"fill":"forwards"}] Black Section Separator By Saurabh Pandey 27-04-2024

Workbook Collaboration: Easily see who else is working on the same workbook and their location within it

[{"selector":"#anim-c21341d7-9137-4a92-8417-92fe9eae7a13","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-f2acb963-4325-4fac-946d-92436fe86eb3","keyframes":{"transform":["translate3d(0px, 120.00777%, 0)","translate3d(0px, 0px, 0)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-8db7acef-128a-49d2-9c64-34ca629c09b1","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"both"}] [{"selector":"#anim-e0002334-2573-48fc-9bbe-965aa73e2dcf","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"both"}] [{"selector":"#anim-23af9a1b-a402-4aa5-a8d2-4373c3e3b660","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"both"}] [{"selector":"#anim-3ee36015-301a-4eae-b7ff-908186083ca0 [data-leaf-element=\"true\"]","keyframes":{"transform":["translate3d(-28.90624987200394%, 0, 0) translate(-25%, 0%) scale(1.5)","translate3d(0%, 0, 0) translate(0%, 0%) scale(1)"]},"delay":0,"duration":2000,"fill":"forwards"}] Black Section Separator By Saurabh Pandey 27-04-2024

Visual Refresh: Experience a modernized Start screen and refreshed ribbon tabs with monoline iconography, neutral colors, and softer window corners

[{"selector":"#anim-a3f6aa56-4c87-420c-aa00-871070655b18","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-92668419-fec8-4b84-9920-3e172ad6ed5c","keyframes":{"transform":["translate3d(0px, 120.00777%, 0)","translate3d(0px, 0px, 0)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-cb38d2ad-af1d-44ea-8ebc-8b6bb2f8c4f8","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"both"}] [{"selector":"#anim-9eddc10b-cc89-4443-8981-b67559ca331a","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"both"}] [{"selector":"#anim-aae4a979-572a-436e-8cdb-0d49b9593521","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"both"}] [{"selector":"#anim-b9697eee-4863-40b7-a3ae-4bc6e0cb37d4 [data-leaf-element=\"true\"]","keyframes":{"transform":["translate3d(-7.812499744007886%, 0, 0) translate(-25%, 0%) scale(1.5)","translate3d(0%, 0, 0) translate(0%, 0%) scale(1)"]},"delay":0,"duration":2000,"fill":"forwards"}] Black Section Separator By Saurabh Pandey 27-04-2024

XLOOKUP Function: Row-by-row search for data in tables or ranges without needing to specify exact matches

[{"selector":"#anim-814cb5bd-3e3d-4182-b39d-8e997942490c","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-6dfb46f7-59f6-4962-8773-023f92613599","keyframes":{"transform":["translate3d(0px, 120.00777%, 0)","translate3d(0px, 0px, 0)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-4a4196f8-8e37-4381-a6b4-60a37f8798c7","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"both"}] [{"selector":"#anim-23236e53-4e73-4e90-a48a-3b8605c91e40","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"both"}] [{"selector":"#anim-9484be4d-22e4-4a64-b210-d8fe6f670733","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"both"}] [{"selector":"#anim-ff4eb8e3-4ec2-4c58-84eb-9d1b8e713702 [data-leaf-element=\"true\"]","keyframes":{"transform":["translate3d(-14.843749786673241%, 0, 0) translate(-25%, 0%) scale(1.5)","translate3d(0%, 0, 0) translate(0%, 0%) scale(1)"]},"delay":0,"duration":2000,"fill":"forwards"}] Black Section Separator By Saurabh Pandey 27-04-2024

LET Function: Assign names to calculation results, similar to variables in programming, enhancing formula readability and functionality

[{"selector":"#anim-cbf55bd9-5621-4c87-b1e8-25a11bd44ea0","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-6d21839a-5449-474f-8fda-0e278c4eb83a","keyframes":{"transform":["translate3d(0px, 120.00777%, 0)","translate3d(0px, 0px, 0)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-e64ed991-296e-4268-9524-615280a8dee5","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"both"}] [{"selector":"#anim-1ad34b14-8835-4963-a548-134997389c87","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"both"}] [{"selector":"#anim-eb9929d6-3d84-4f2e-90ce-e78f5f62cf27","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"both"}] [{"selector":"#anim-eb50a6cf-cb0f-4400-ba06-5c444d785bec [data-leaf-element=\"true\"]","keyframes":{"transform":["translate3d(-31.249999886225726%, 0, 0) translate(-25%, 0%) scale(1.5)","translate3d(0%, 0, 0) translate(0%, 0%) scale(1)"]},"delay":0,"duration":2000,"fill":"forwards"}] Black Section Separator By Saurabh Pandey 27-04-2024

Dynamic Arrays: Write one formula and return an array of values using functions like FILTER, SORT, SORTBY, UNIQUE, SEQUENCE, and RANDARRAY

[{"selector":"#anim-b88bb53d-8d6b-4073-a943-ae24ac14bbb0","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-1a58518b-a5ec-4643-bf3e-f30fd03f3146","keyframes":{"transform":["translate3d(0px, 120.00777%, 0)","translate3d(0px, 0px, 0)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-7cda0b21-908d-4ccd-b17d-2a0149f25b05","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"both"}] [{"selector":"#anim-fbb1a634-58f4-4186-8f15-2e29de560d94","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"both"}] [{"selector":"#anim-492b6ae0-7f3d-4475-9dc8-723249840448","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"both"}] [{"selector":"#anim-655e0e05-d868-4cd3-8ba4-9591c5d206b4 [data-leaf-element=\"true\"]","keyframes":{"transform":["translate3d(-31.249999886225726%, 0, 0) translate(-25%, 0%) scale(1.5)","translate3d(0%, 0, 0) translate(0%, 0%) scale(1)"]},"delay":0,"duration":2000,"fill":"forwards"}] Black Section Separator By Saurabh Pandey 27-04-2024

XMATCH Function: Search for items in an array or range and return their relative positions or values

[{"selector":"#anim-9b7ad0cf-9b3a-44d4-a706-d00b32d49e5f","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-d496a457-3062-4f24-8f48-309f19db907f","keyframes":{"transform":["translate3d(0px, 120.00777%, 0)","translate3d(0px, 0px, 0)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-af2e403a-efdb-4d61-8ba2-313f27ba709b","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"both"}] [{"selector":"#anim-42c06214-4fae-4408-ae65-c7ba83121805","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"both"}] [{"selector":"#anim-1c545841-fe6e-4f44-a461-5ca0c13bcd91","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"both"}] [{"selector":"#anim-53539b03-2df7-48aa-83a3-a05cdcd9caff [data-leaf-element=\"true\"]","keyframes":{"transform":["translate3d(-28.90624987200394%, 0, 0) translate(-25%, 0%) scale(1.5)","translate3d(0%, 0, 0) translate(0%, 0%) scale(1)"]},"delay":0,"duration":2000,"fill":"forwards"}] Black Section Separator By Saurabh Pandey 27-04-2024

Sheet Views: Create customized views within an Excel worksheet without affecting others

[{"selector":"#anim-b3fbd36e-ce54-4ba9-aa56-176fd13f75e1","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-08cf38e1-4f31-4873-b6c4-1a5dc626aa52","keyframes":{"transform":["translate3d(0px, 120.00777%, 0)","translate3d(0px, 0px, 0)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-f0ac47d8-5fa3-4cb7-a6d9-d687334192ca","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"both"}] [{"selector":"#anim-5325c94a-aad5-490d-9a7d-bf89dba73cf0","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"both"}] [{"selector":"#anim-c6088cac-8600-4af2-848a-6e988b583e0b","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"both"}] [{"selector":"#anim-1a7e8c95-5065-41fd-8426-45e8097c5007 [data-leaf-element=\"true\"]","keyframes":{"transform":["translate3d(-31.249999886225726%, 0, 0) translate(-25%, 0%) scale(1.5)","translate3d(0%, 0, 0) translate(0%, 0%) scale(1)"]},"delay":0,"duration":2000,"fill":"forwards"}] Black Section Separator By Saurabh Pandey 27-04-2024

Accessibility Tools: The Accessibility ribbon consolidates tools for creating accessible content in one place

[{"selector":"#anim-c79c620e-e70e-4bc8-945a-7c4975546e07","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-2888b67d-deba-43be-b80e-ddca77484e0d","keyframes":{"transform":["translate3d(0px, 120.00777%, 0)","translate3d(0px, 0px, 0)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-89e6a086-250b-4ff6-b50b-c9a628ad3c05","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"both"}] [{"selector":"#anim-65abe6e6-7ee2-4c82-87b3-63ada4af1b9f","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"both"}] [{"selector":"#anim-a2f7c8b5-cc9f-4c99-8cc6-d7d6142e780e","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"both"}] [{"selector":"#anim-23b93bd5-e5e3-446e-bc59-31e31555087e [data-leaf-element=\"true\"]","keyframes":{"transform":["translate3d(-7.807542923392689%, 0, 0) translate(-25%, 0%) scale(1.5)","translate3d(0%, 0, 0) translate(0%, 0%) scale(1)"]},"delay":0,"duration":2000,"fill":"forwards"}] Black Section Separator By Saurabh Pandey 27-04-2024