Excel Headlines

My very own list of news on Excel, gathered from various sources!

This site

New article: Lambda function examples
I have added a new article to my website today, in which I demonstrate a couple of LAMBDA functions: SheetName and JustifyText
Fri, 17 May 2024 16:45:00 GMT
Update: Name Manager
Name Manager has just been updated to build 708. If you open the Add Name box, the current selection is already entered in the refersto formula
Fri, 17 May 2024 14:10:00 GMT

Excel Experts Nederland

Excel Expert Nederland Blog
Bereiknamen beheren in Excel online
Gebruik je bereiknamen, maar ben je soms gedwongen om in Excel on-line te werken? Dan heb ik goed nieuws, je kunt nu mijn Name Manager downloaden en in Excel on-line bereiknamen beheren, maken en bewerken! Zie https://jkp-ads.com/excel-name-manager-js.asp
Tue, 02 Jan 2024 13:14:18 +0000

Daily Dose Of Excel

By Dick Kusleika (et al)
Navigating Outlook Favorites
I have these four favorites defined in Outlook: From the inbox, I could hit Shift+F6 to get into the Favorites area but sometimes I would end up in no man’s land and couldn’t figure out how to get back into the inbox. So, god forbid, I had to use my mouse. I wrote this macro: […]
Thu, 23 Mar 2023 20:41:08 +0000

The Ken Puls Blog

By Ken Puls
Monkey Shorts

In case you missed it, I've been posting free video content over on our Skillwave Training YouTube channel.  In addition to a new series of monthly "Ask Skillwave" sessions that I'm hosting with my good friend Matt Allington of Excelerator … Continue reading

The post Monkey Shorts appeared first on The Excelguru Blog.


Thu, 24 Feb 2022 19:42:55 +0000

PTS Blog

By Jon Peltier

An error has occured while trying to process http://feeds.feedburner.com/peltiertech/EsrO
Please contact web-master.


Contextures Blog

By Debrah Dalgleish
Excel File Auto Backup When Workbook Saved
Do you hit the Save button frequently, while you work in Excel? And do you make backup copies of your Excel files, especially before making major changes? Or, do you only think about saving, right after Excel crashes? Save, Save, Save After many painful experiences, I learned to save my work in Excel, every 5 … Continue reading "Excel File Auto Backup When Workbook Saved"
Thu, 16 May 2024 05:02:00 +0000

Microsoft Excel blog on TechCommunity

By various Authors
What's New in Excel (April 2024)

Welcome to the April 2024 update.


Generating multiple formula columns, creating complex formula columns that span across multiple tables, and new ways to engage with Copilot in Excel are now available to Excel users on web and Windows. Copying and pasting improvements and sharing links to sheet views are also available in Excel for the web, and the ink to text pen is rolling out to Insiders running Excel for Windows.

Excel for Web:

  1. Generating multiple formula columns with Copilot in Excel
  2. Creating complex formula columns that span multiple tables with Copilot in Excel
  3. Copying and pasting Improvements #FIA
  4. Sharing link to sheet views #FIA

Excel for Windows:

  1. Generating multiple formula columns with Copilot in Excel
  2. Creating complex formula columns that span multiple tables with Copilot in Excel
  3. New ways to engage with Copilot in Excel
  4. Ink to text pen (Insiders)

Excel for Web

 

1. Generating multiple formula columns with Copilot in Excel

Copilot in Excel now supports generating multiple formula columns from a single prompt. Ask one question, and Copilot can return two formula columns simultaneously. For instance, you can extract both the first name and last name from a single prompt, neatly separating the information into distinct columns. Read more here.

 

2. Creating complex formula columns that span multiple tables with Copilot in Excel
Additionally, now you can use Copilot to create complex formula columns that span across multiple tables, utilizing functions like XLOOKUP and SUMIF. This capability streamlines data processing and empowers you to handle more complex data analysis tasks efficiently, even when using multiple tables. Read more here.
Generating Complex Formula Columns from Multiple Tables with Excel CopilotGenerating Complex Formula Columns from Multiple Tables with Excel Copilot

 

#FIA

3. Copying and pasting improvements

Based on feedback we’ve received from many of you, we’ve made the following improvements to the copying and pasting experience:

  • Drag and Drop Enhancements: Provides a more seamless and intuitive way to manipulate data.
  • Autofill: Enables you to drag data to fill series, copy cells, and split data.
  • Paste options improvements: Allows you to choose the right paste option for your needs by right-clicking or accessing the auto-recovery paste options.

Read more here >

Copying and Pasting Web ImprovementsCopying and Pasting Web Improvements

 

#FIA

4. Sharing link to sheet views
You can now share a link to a Sheet view that captures a subset of a workbook’s contents. This new capability can help you more efficiently collaborate on large, complex workbooks and more easily gather feedback and input from others. Read more here >
Share links to Sheet views in Excel for the webShare links to Sheet views in Excel for the web

 

Excel for Windows

 

1. Generating multiple formula columns with Copilot in Excel

Copilot in Excel now supports generating multiple formula columns from a single prompt. Ask one question, and Copilot can return two formula columns simultaneously. For instance, you can extract both the first name and last name from a single prompt, neatly separating the information into distinct columns. Read more here.

 

2. Creating complex formula columns that span multiple tables with Copilot in Excel
Additionally, now you can use Copilot to create complex formula columns that span across multiple tables, utilizing functions like XLOOKUP and SUMIF. This capability streamlines data processing and empowers you to handle more complex data analysis tasks efficiently, even when using multiple tables. Read more here.
Generating Complex Formula Columns from Multiple Tables with Excel CopilotGenerating Complex Formula Columns from Multiple Tables with Excel Copilot

 

3. New ways to engage with Copilot in Excel
We’ve enhanced Copilot in Excel to make the experience even more seamless and efficient. Now, with Copilot in Excel, you can use the Microphone feature to prompt Copilot verbally, eliminating the need for manual typing. In addition, for fresh prompt ideas tailored to your specific data, now you can select the View Prompts icon to explore the Prompt Guide in the chat pane.. This feature is currently rolling out to Windows users. Read more here.

 

(Note: Copilot in Excel is currently in preview. Learn more about Copilot in Excel here.)


An image showing the prompt guide button selected with prompt options displayed.An image showing the prompt guide button selected with prompt options displayed.
4. Ink to text pen (Insiders)

The Ink to Text Pen lets you use your digital pen (or stylus) to automatically convert your handwriting into text as you go, helping you quickly enter content into cells. Additionally, you can use pen gestures to select and delete cell content.

NOTE: The Ink to Text Pen replaces the functionality of the Action Pen in Excel.
Read more here >Ink to Text Pen selectorInk to Text Pen selector

 

 

Check if a specific feature is in your version of Excel

Click here to open in a new browser tab

 

 

 

Your feedback helps shape the future of Excel. Please let us know how you like a particular feature and what we can improve upon—"Give a compliment" or "Make a suggestion"..  You can also submit new ideas or vote for other ideas via Microsoft Feedback.

 

Subscribe to our Excel Blog and the Insiders Blog to get the latest updates. Stay connected with us and other Excel fans around the world – join our Excel Community and follow us on X, formerly Twitter.

 

Special thanks to our Excel MVPs David Benaim and Bill Jelen for their contribution to this month's What's New in Excel article. David publishes weekly YouTube videos and regular LinkedIn posts about the latest innovations in Excel and more. Bill is the founder and host of MrExcel.com and the author of several books about Excel.

 


Tue, 30 Apr 2024 18:44:28 PDT