Join 400,000+ professionals in our courses here https://link.xelplus.com/yt-d-all-courses

Here is my list of the best new features and improvements in Microsoft Excel that can really make a difference for you. This includes the new Search the menus feature, the new navigation pane for large workbooks, how to check your formula with the value preview tooltip, dynamic arrays and more.

⬇️ Get your copy of the Cheat Sheet for the best New Excel features here: https://pages.xelplus.com/new-features-cheat-sheet

Highlights of the Video:
- Discover Excel's right-click search feature for effortless command access.
- Explore the new Navigation pane, your key to managing complex spreadsheets.
- Learn about Excel's latest keyboard shortcuts, including one for Power Query and quick value pasting.
- Get introduced to the Automate tab for creating and running Office Scripts.
- See the Value Preview tooltip in action, simplifying formula debugging.
- Find out how to use Dynamic Arrays as a source in Power Query and in charts.

Takeaways:
- Leverage new features to simplify and enhance your Excel projects.
- Discover innovative ways to manage and analyze data.
- Stay current with the evolving landscape of Excel functionalities.

00:00 Best New Excel Features You Need to Know About
00:17 Easy Search in Excel
01:39 Navigation Pane in Excel
03:02 New Excel Keyboard Shortcuts
03:54 Automate Tab
05:56 Value Preview Tooltip
06:41 Dynamic Arrays in Power Query
08:23 Dynamic Arrays as Charts Source
08:51 Wrap Up

LINKS to related videos:
Introduction to Office Scripts ► https://youtu.be/fny4zUycp_w
Automatically Move Completed Tasks to an Archive ► https://youtu.be/Y7PoYlZUMgo
Do You Need to SWITCH from Excel VBA Macros to Office Scripts? ► https://youtu.be/DOvHqukAGTY

️ Join this channel to get access to perks: https://www.youtube.com/channel/UCJtUOos_MwJa_Ewii-R3cJA/join

Get the Official XelPlus MERCH: https://xelplus.creator-spring.com/

Not sure which of my Excel courses fits best for you? Take the quiz: https://www.xelplus.com/course-quiz/

RESOURCES I recommend: https://www.xelplus.com/resources/

Let’s connect on social:
Instagram: https://www.instagram.com/lgharani
LinkedIn: https://www.linkedin.com/company/xelplus

This description contains affiliate links, which means at no additional cost to you, we will receive a small commission if you make a purchase using the links. This helps support the channel and allows us to continue to make videos like this. Thank you for your support!

#Excel