Home Article index Newsletter

Excel Headlines

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

This site

Updated various tools
I have updated GitHubVBAExporter, the form is now sizable.
Wed, 28 Apr 2021 11:00:00 GMT
Update: Name Manager
Name Manager has just been updated to build 681 with some bugfixes
Thu, 15 Apr 2021 13:10: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)
Name Manager updated
Do you use Range names in Excel? Today I have updated my 100% free Excel Name Manager add-in with two new features: – Edit the name’s comment – Filter Lambda names https://jkp-ads.com/officemarketplacenm-en.asp Here’s a screen-shot: Regards, Jan Karel Pieterse jkp-ads.com
Mon, 14 Dec 2020 14:02:55 +0000

The Ken Puls Blog

By Ken Puls
Building a SelectQuery Function

For a while now, I have been wanting to have the capability in Power Query to select a query by name PROGRAMMATICALLY.  Why?  Building a SelectQuery Function would allow me to execute one of multiple “Transform” queries depending on a … Continue reading

The post Building a SelectQuery Function appeared first on The Excelguru Blog.

Wed, 14 Apr 2021 17:15:59 +0000

PTS Blog

By Jon Peltier
Slope Chart with Data Labels

This tutorial shows how to construct a slope chart in Excel and provides a simple VBA procedure to apply and format data labels quickly.

The post Slope Chart with Data Labels appeared first on Peltier Tech.

Thu, 06 May 2021 17:37:08 +0000

Contextures Blog

By Debrah Dalgleish
Excel MATCH Function Error Troubleshooting Examples
Sometimes, a MATCH formula returns an #N/A error, even if the value you're looking for is in the lookup table. The reason for that could be numbers that Excel sees as text, and here are a couple of ways to fix that problem. And if numbers aren't the problem, I've got a couple of other … Continue reading "Excel MATCH Function Error Troubleshooting Examples"
Thu, 29 Apr 2021 04:01:00 +0000

Microsoft Excel blog on TechCommunity

By various Authors
Our journey to make Excel work well for everyone

Accessibility is about making our products accessible and inclusive to everyone, including the 1 billion+ people with disabilities around the world. It is a core Excel and Microsoft priority, and an area where we continuously strive to improve. For more information about Microsoft’s commitment to accessibility, visit microsoft.com/accessibility.



Excel’s approach

Making Excel more accessible is a journey, and we will always have room for improvement as we strive to make spreadsheets work for everyone. We have three overarching objectives to guide us:

  1. Work seamlessly with assistive technology. Our partners around the globe and within Microsoft create amazing technology to support people with disabilities. A few examples of assistive technology include screen readers, dictation software, magnifiers, and physical devices. Our priority is to collaborate with these partners so that everyone can use Excel in the way that works best for them, with tools that are already familiar.
  2. Build inclusive and delightful experiences inspired by people with disabilities. Beyond “just working,” Excel should be efficient and delightful to use. We are always looking for opportunities to simplify your workflow, summarize your content, or suggest information. By learning from and being inspired by the experiences of people with disabilities, we can make Excel better for all.
  3. Support authors to create accessible content. Making Excel as an application accessible is only half the battle; the other half is making sure workbooks created in Excel are accessible. For that, we rely heavily on you, the author…but that doesn’t mean we can’t help! We look for opportunities to automatically create accessible content on your behalf, support you while you create accessible content, let you know when something is inaccessible, and help you fix accessibility issues before sharing your workbook with others.


Feature Spotlight: Accessibility ribbon

As a part of our goal to help you create accessible content, there is a new contextual ribbon called “Accessibility” coming to Excel. The Accessibility ribbon will be available when you open the Check Accessibility pane on the Review tab. On the Accessibility ribbon you will find a collection of the most common tools you need to make your workbook accessible. The ribbon is available today to those in the Office Insiders program.


Contextual Accessibility ribbon in Excel shows when the Check Accessibility pane is open.Contextual Accessibility ribbon in Excel shows when the Check Accessibility pane is open.



To learn more about the Accessibility ribbon, view our announcement on the Office Insiders blog. If you are interested in learning more about how to create accessible workbooks, check out our support article Make your Excel documents accessible to people with disabilities.


Next steps

Please let us know what you think! Your feedback and suggestions shape our approach to accessibility and inclusive design. To get in touch, contact the Disability Answer Desk or use Help > Feedback. We look forward to hearing from you!


This is the first in a series of blogs about our accessibility work in Excel. We hope you will join us over the next several months as we discuss exciting new improvements to Excel through an inclusive lens.


Subscribe to our Excel Blog and join our Excel Community to stay connected with us and other Excel fans around the world.


Wed, 5 May 2021 10:30:00 PDT