Excel Headlines

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

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

AutoHotKey in VBA
In response to https://nolongerset.com/all-about-indenting/ [crayon-641c69f1271d4240492170/]
Wed, 11 Jan 2023 23:18:21 +0000

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

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

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

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.

 

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

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.

 

For convenience, the card can be dragged and moved 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.

 

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.

 

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