Excel Headlines

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

This site

Updated: Flexfind allows search and replace in VBA code
Good news: As of now, Flexfind allows you to Search and replace in VBA too!
Mon, 13 Mar 2023 10:55:00 GMT
New: Flexfind JavaScript edition
Good news! Today my brand new Flexfind (JS edition) has been approved for the Microsoft Office Add-ins store!
Thu, 19 Jan 2023 16:45: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)
AutoHotKey in VBA
In response to https://nolongerset.com/all-about-indenting/ [crayon-641c69f1271d4240492170/]
Wed, 11 Jan 2023 23:18:21 +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
Index of Peltier Tech Blog

Finally an index of Peltier Tech blog posts. It's incomplete, but it should help you find the topics you're looking for.

The post Index of Peltier Tech Blog appeared first on Peltier Tech.


Tue, 07 Mar 2023 19:31:45 +0000

Contextures Blog

By Debrah Dalgleish
Unpivot Excel Data with Power Query Step by Step Video
This step-by-step video shows how to unpivot data in Excel, using Power Query. This creates better source data that you can use to build flexible pivot tables. And it doesn’t change your original data – you can leave that as is! Video: Unpivot Excel Data with Power Query Unpivot your Excel data, if needed, to … Continue reading "Unpivot Excel Data with Power Query Step by Step Video"
Thu, 23 Mar 2023 04:01:00 +0000

Microsoft Excel blog on TechCommunity

By various Authors
Formula Argument Assistance

We have added a Formula Argument Assistance card to Excel Web!

Formula Argument Assistance card accompanies you while writing a formula, and helps you insert or edit the arguments.

You no longer need to reach out to external sources for help when you are typing your formula! The Argument Assistance card will help you write formulas more efficiently and reduce errors.

 

About the feature

The Argument Assistance card provides descriptions of the function and the different arguments, as well as an example:

The card includes formula and arguments descriptions, and an example.The card includes formula and arguments descriptions, and an example.

 

For better orientation, the relevant argument is highlighted during formula editing:

The relevant argument is highlighted.The relevant argument is highlighted.

 

The card can be collapsed and expanded. You can collapse the card and display only the formula signature if you don't want to hide much of the grid:

The card can be collapsed or expanded.The card can be collapsed or expanded.

 

For convenience, the card can be dragged and moved around the screen:

The card can be dragged around the screen.The card can be dragged around the screen.

 

How does it work?

Start typing a formula in a cell or in the formula bar. After writing the formula name and the opening parenthesis, the card will appear.

For example:=VLOOKUP(

OR choose a function from the Insert Function dialog OR from the dropdown menus in the Formulas tab.

Card appears after opening parenthesis.Card appears after opening parenthesis.

 

Feedback

We hope you like this new addition to Excel Web and we’d love to hear what you think about it!

Please share your feedback with us by clicking the Give Feedback button that can be found at the bottom of the card.

Share your feedback.Share your feedback.

 

Availability

Currently, Argument Assistance is available in Excel for the Web. In the future, this feature will be added to Excel desktop versions as well.


Mon, 20 Mar 2023 10:02:34 PDT