8 New Features in Microsoft Excel | Summer 2023

📝 Table of Contents
0:00 Introduction
0:12 CTRL SHIFT V to paste values only
0:39 Assign a Task with @ mentions
1:38 Office Scripts automate tasks - Record worksheet actions using Office Scripts
4:18 A shortcut to open Power Query
4:30 Immersive Reader in Excel for web
6:28 Check your formula with value preview tooltips (Insiders)
7:13 Quickly find commands in Excel for Windows context menu
7:45 Easier Ribbon button navigation with keyboard

📺 Top 25 Excel tip and tricks: Top 25 Microsoft Excel Tips and Tricks for 2022 // NEW features, hidden gems and time-saving tips

*Connect with me on Social:

#Excel #Microsoft #microsoftexcel

[khaledal-sayyary]

Thanks to Microsoft for this wonderful update, and thanks to Mike for his excellent explanation.

[rory]

These updates are great - they are little feature enhancements that provide value to the customer way beyond what you would think i.e., showing the cell values. It's a small thing on the worksheet but I have a feeling there'll be a lot of foldks saying thanks for bringing that one to life :)

[bobygeorge]

Good one and informative video. Thank you very much

[RajeshAllem]

Really useful features to boost productivity of the users. Thanks for sharing the information.

[livinaskipp]

This is incredible, it could save nearly 5 minutes a day

[garydunken]

If anyone wondering what the shortcut key for value paste in current and some previous versions of Excel,
- value paste Alt+H V V
- formula only paste Alt+H V F
Of course, the new Ctrl+Shift+V will be a little quicker in the future. Thanks Mike for sharing.

[ksumar]

XL goes from strength to strength. 🙂
Nice work Microsoft!

[luiscosta]

What version are those fixtures in? I am on Version 2305 and don't have none ofthis.
Thanks

[alec]

Does that assign task hit your Outlook tasks?

[erikguzik]

What BUILD number does this come in. I have 16602.20000 Version 2307 and don't have most of these new features. Thanks much, Great video

[maciejkopczynski]

What programming language is used while recording/writing office scripts? I assume a special one developed for the scripts themselves, am I right?

[DaveSlavens]

What's the difference between Automate vs. Macros?

[sbatsia]

Thanks for sharing. I'm using MSFT Office 365, but can't find the automate tab. I'd appreciate help.

[carlrigefsky]

In Excel 365 I do not see an Automate tab. How do I locate it? Thanks

[arulkavi]

It is really wonderful advancement. The requested is to go the explanation little slowly. Only we'll versed Excel people could grasp in 5mts. People like me to get explanation has to be a slow teachers mode
. Thank you

[YusufMumtaz]

Any idea if office scripts are coming for MSA accounts?

[stupidfanboyph]

Finally Excel caught up with Ctrl + Shift + v shortcut Google Sheets has long been implemented.

[laggytim]

Ctrl+shift+v, cool but if you use it a lot alt e s v, is how you do it not the menus

[josephdaquila]

I have had this little project idea to go in and insert page breaks after the primary sort of a multi-level sort, but hadn't gotten around to it yet. The new office scripts script recorder feature should make this a breeze.

[seje]

Hi Mike, do you know if it is possible with the new "Assign task"-feature to assign a task to an individual using Microsoft Planner instead of Microsoft Tasks?