Excel Headlines

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

This site

Update: RefTreeAnalyser
RefTreeAnalyser has just been updated to version 3.1, build 189. If your formula returns a range reference (like the XLOOKUP function does), RefTreeAnalyser will display to which cell(s) the formula points.
Wed, 02 Nov 2022 12:45:00 GMT
Video: Office Script And Power Automate Demo
I presented during the Excel Virtually Global conference October 17, 2022, Here's the recorded video: Office Script And Power Automate Demo
Mon, 17 Oct 2022 08:00:00 GMT

Excel Experts Nederland

Excel Expert Nederland Blog
Nieuw: ons Excel Forum
Wij kregen tamelijk veel Excel gerelateerde vragen in onze commentaren. Om deze vragen beter te kunnen kanaliseren zijn we daarom een Excel forum gestart. Heb je een vraag? Word lid van ons forum en stel hem hier: Excel Experts Nederland Forum
Mon, 30 Jan 2017 16:38:13 +0000

Daily Dose Of Excel

By Dick Kusleika (et al)
Macros with 32-bit API Calls
I have a fairly slow running macro (~20 seconds) that works fine on one computer, but never finishes on another. If finally decided to figure out why. (Big Daddy is the nickname of the guy who started this golf league way before my time. I am not Big Daddy, although maybe I should be.) First […]
Sun, 30 May 2021 22:59:20 +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
LAMBDA Function to Build Three-Tier Year-Quarter-Month Category Axis Labels

This tutorial presents a LAMBDA function that builds the source data for multi-tiered, grouped axis labels in an Excel chart.

The post LAMBDA Function to Build Three-Tier Year-Quarter-Month Category Axis Labels appeared first on Peltier Tech.


Tue, 29 Nov 2022 21:08:32 +0000

Contextures Blog

By Debrah Dalgleish
Excel Macros Create Monthly Workbooks Entire Year
Happy December! We’ve almost made it to the end of this year, and you’re probably getting reading for next year’s tasks and projects. If you need to set up monthly workbooks for next year, or automatically add sheets to existing workbooks, these Excel macros can help you! Create Monthly Workbooks At one company I’ve worked … Continue reading "Excel Macros Create Monthly Workbooks Entire Year"
Thu, 01 Dec 2022 05:01:00 +0000

Microsoft Excel blog on TechCommunity

By various Authors
What's New in Excel (November 2022)

Welcome to the November 2022 update. We are excited to announce the release of a couple features that are now generally available (GA) to all Excel users on Windows and Mac - Show Changes and insert Data from a Picture. For our web users, Chart Data Foils allows you to see a visual indicator highlighting the cell range used for charts. Lastly, iOS Insider users will experience a smoother and cleaner experience within the command and ribbon panes on their devices.

 

Curious to see how we at Excel utilize and act on your feedback? You can now see which features are a direct result of your feedback as they'll be marked with the new Feedback In Action tile #FIA.

 

Check out this Excel Feature Flyer to find if a specific feature is in your version of Excel

 

Excel for the web:

  • Chart Data Foils

Excel for Windows:

  • Show Changes #FIA
  • Data from Picture

Excel for Mac:

  • Show Changes #FIA
  • Data from Picture

iOS:

  • Get Fast and Fluent for Office on iPhone (Insiders)

Excel for the web

Chart Data Foils

Chart Data Foils provides a visual indicator directly on the spreadsheet highlighting the source range of cells for charts. Users can easily modify that range with the click and drag of a mouse. After a user has created a chart, they can now leverage Data Foils to modify which rows/columns of data are used for their chart including its series titles, series values, and category values.

 

Excel for Windows

#FIA

Show Changes

Show Changes in Excel lets you see exactly what edits were made to your workbooks, so you can confidently allow others to collaborate on your work. You can see details of who changed what, where, and when, along with the previous value of the cell for quick reversion.

Read more here >

Show ChangesShow Changes

 

Data from Picture

With the new Data from Picture feature in Excel for Windows & Mac, you can insert data from a picture on your clipboard or an image file from your computer. There’s no need to type all the data—Excel can do it for you! Read more >

Excel for Mac

#FIA

Show Changes

Show Changes in Excel lets you see exactly what edits were made to your workbooks, so you can confidently allow others to collaborate on your work. You can see details of who changed what, where, and when, along with the previous value of the cell for quick reversion.

Read more here >

Show ChangesShow Changes

 

Data from Picture

With the new Data from Picture feature in Excel for Windows & Mac, you can insert data from a picture on your clipboard or an image file from your computer. There’s no need to type all the data—Excel can do it for you! Read more >

 

 Excel for iOS

Get Fast and Fluent for Office on iPhone (Insiders)

These updates bring a modern look and feel to the contextual command bar and ribbon palette when working with documents, presentations, and worksheets on your iPhone. The new cleaner and simplified experience include: 

  • A visual update of both the contextual command bar and ribbon palette to align with Microsoft’s Fluent design, implemented using our open-source components.
  • More performant menus on the contextual command bar that open faster and are resizable

Read more >

Get Fast and Fluent with Office on iPhoneGet Fast and Fluent with Office on iPhone

 

 

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—send us a smile or frown.  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 Twitter.


Tue, 29 Nov 2022 13:41:49 PST