Leila, May I suggest, when you are talking about features, please mention version of Excel you are using. My version of Excel 365 enterprise does not have half of mentioned in this video
Hey Leila - Thank you for keep us all aware of coming features! Can you tell us - 1.) Which Excel version are these new feature active in now? 2.)Is there a trickle down schedule to all releases?
Thank you for this video. Very usefull. I would like to see a feature where ppl could center across selection vertically. I can't stand those merged cells.
Navigation is my favorite. I just learned about it from this video. I have a workbook with 26 sheets so navigation is going to make my life so much better!
Thanks Leila, always my go-to for Excel etc. I never even noticed some of these, like automate and navigate, using it already 😊 Anyone remember Quatro Pro years ago? I loved it, ahead of the pack back then I thought, had a quick record, once off or saveable, used it often, seems automate is similar.
The navigation pane one is a game changer for me, and the search will be game changing for when I'm training other Excel users (mostly because I've customised my Excel ribbon and can never remember where the default menu options are!)
Thanks Leila for sharing. They are such useful features, I followed with you step by step, regarding the first tip, for some reason the list came out with duplicate values. I would like to know what cause that problem. I do have the 365 version but I could not see the Navigation pane anywhere. 😓
Office 365 has impressed me more than I expected. These new features are amazing and especially good for those who cannot remember keyboard shortcuts. Thanks Leila for sharing :)
Hi Leila, I discovered your site accidentally and love it, including your style of educating as it is helping me get better at using Excel. I have seen in your videos and others that the use of merged columns is discouraged and wanted to know how to handle this when I need to group a series of rows that collectively form a unit of transaction. e.g., if I am tracking expenses across multiple events across multiple sites, I am using a sheet where individual expenses are grouped under a single event id, which along with other event-level details are shown as a merged row (e.g., event id, event location, total expenses etc).
The best 9 minutes and 19 seconds of my day! ... and so good that I will likely watch several times ... a cornucopia of ideas. Thank you ... thank you ... thank you ... 😍😍😍
I am watching many of your videos and sometimes jealous that Microsoft Office has so amazing teacher 😁 I would want that Libre Office would have so amazing teacher like Leila😉
This is always exciting to try new features and thank you for introducing them to us. What is frustrating for me is some are available on my home computer and not at work and sometimes the opposite. Some very useful tips as always, thank you.
After mastering the fundamental literacy in computer, I am a bit slow in learning. But I will practice, until I reach my goal, I must express my thank you.
I like the use of spill ranges into power query! To copy and paste removing formula, I select the range, right the any edge or border, drag away and return to the same location. A popup appears with selections and select copy here as values only!
I don’t use power queries but navigation and office scripts are going to help me do much. Thank you! I wish Microsoft had a better way of notifying users about new features. That’s why I love your channel ❤.
Thanks Leila. I did not use the "search menu" yet. Just tried it. You can type "Form" to use this (hidden in the menu) . That's nice. But this does not work for "Camera" (also not in the menu).
The search box was there is the windows version of office (excel, powerpoint and word) at the top of the tool bar for some time now. Works the same way as the search box shown here
Hi Leila, never realized all these features are already ready in my Excel version. Thank you for making this video :) Do you know why I am not seeing Automate Menu in my Excel version? I have Microsoft 365 Family Subscription - Microsoft® Excel® for Microsoft 365 MSO (Version 2307 Build 16.0.16626.20028) 64-bit Is my version isn't suported?
The search and tool tip preview for sure but inly at home. The problem at work is we are still using 2010 or 2011. I doubt that version will get any love.
Leila, thanks for sharing your favorite new features. After watching, I cannot choose a favorite, I love them all! The navigation is way cool, and the office scripts is going to be a lot of fun!!!🦊
Looking forward to seeing what Automate can do, once it comes out for Excel 365 for MacOS. I have a workbook with a VBA script built around a power query. I also share this with a team that only uses the Web interface. It would/will be nice to open up the workbook to more people.
Thanks, Leila! As usual, you're right here with good information just when I need it most. I've been working on a large project estimate for a client, and, of course, it's been quite some time since I was seriously busy in Excel. I will be putting video's search, navigation and debugging tips to good use.
I'm using Excel 365 Enterprise. Most of the tips are not available in my version. =( Nonetheless, great tips. Thanks for spending the time to create these useful videos for us.