Best NEW Excel Features EVERYONE Needs

Best NEW Excel Features EVERYONE Needs - ID Card Make Microsoft's been rolling out feature after feature for Excel because there are so many it's easy to miss the good ones. That's why I made this video for you; to show you the best new features in Excel that will make a big difference for you. Let me know in the comments which one you like best. Number one: Right-click search to quickly find the command you need. Finding a specific feature in this menu is difficult. Don't worry about this anymore. Instead, what you're going to do.

Is right-mouse click, and you're going to see a new box pop up here called Search the Menus. Type in what you're looking for. Let's say you want to add a drop-down list. To start typing in "list," and you're going to see the validation feature pop up. Use the arrow keys to navigate, press spacebar to select it, and then you can go ahead and add your list. I'm just going to use Tab. Press the down arrow key to select list, press Tab. For Source, I'm going to go with Division. Enter,.

And now I have my drop-down list inserted. Let's say I decide to remove it. This time I'm going to bring up the menu items using my shortcut keys. Use Shift+F10. You might need to use Windows+Shift+F10 depending on your device. Go up and type in "clear." Use the arrow keys to navigate and select "Clear All." You can pretty much find any command using this feature. Let's say I want to add conditional formatting to this. I'm going to go ahead,.

Bring up the menu, press Tab, and type in "conditional formatting." Press the spacebar, navigate down, data bars, and go with this one. All the commands are now easily accessible. Number two: Navigation pane. Talking about finding stuff easier, what about if you're dealing with large spreadsheets with so many different sheets and lots of content? This is where you're going to need the Navigation pane. It's a must-use for everyday spreadsheet users. You're going.

To go to View and go to Navigation. On the side here, you're going to get an overview of all of your sheets, including any hidden ones. These are going to be in light gray. If you want to show it, just right-mouse click and select Show, and you've made that sheet visible. You can rename the sheet by right-mouse clicking and going to Rename, or Delete if you want to get rid of it. I'm going to go and hide this again. Now, as you've probably noticed,.

If I select a sheet, I immediately jumped to that specific sheet. Underneath the sheet name, I get to see the different objects and data that I have. So, Stacked Data, that's the data range. This is a chart. This is another data range. And here, I have two tables. If I realize, "Okay, no, I don't want to have Table 2 as a table name. That's a horrible name," I'm going to right-mouse click and Rename, and I can immediately rename it from this window. As you can see,.

The Navigation pane makes it easy to view and manage the content of your larger spreadsheets. Next up: New keyboard shortcuts. There is a shortcut to bring up Power Query. That shortcut is Alt+F12. This brings up the Power Query Editor window, and you can go ahead and view any existing queries or create new queries. Another shortcut is the ability to copy and paste cells as values. So currently, I have formulas behind.

These. If I want to copy these as values, I can do Ctrl+C, go to here, right-mouse click, and then go to Paste Special options or select Paste as Values from the menu. You can do it with a shortcut, and that shortcut is Ctrl+C and then Ctrl+Shift+V. This pastes your cells as values. Talking about shortcuts, a useful one that will help you stay on top of things at work is to subscribe to this channel..

Next up: Automate tab in Excel. So, you might have noticed that Excel for desktop has a new tab called Automate. Here, you can use Office Scripts to create scripts that run on desktop as well as on Excel for the web. For example, I want to create a chart based on this dataset. I have a script already created called Chart Script. I'm going to select that, click on Run, and my chart is automatically created. And I have many videos on how to.

Do this. I'll link them in the description of the video. But just to get you quickly started, you have the ability to record your actions. So, for example, let's say you want to create a timesheet that starts from today's date. You can go ahead, record your actions. Everything you do now is being recorded. Let's give our sheet a title called Time Sheet. I'm going to make it bold. Let's add a bottom border to this. Let's go to View and remove gridlines as well. Now,.

Here, I'm going to use the TODAY function to get today's date. Then, let's go and reference today's date and add 1 to it. Then I'm going to drag this down. So, all of my actions are being recorded. On the side, I'm going to now select everything, Ctrl+C, right-mouse click, and paste everything as special. Go to Home, change this to a long date, and let's just autofit cells as well. So here, we have autofit columns. Then, I want "Start" and "End." Okay,.

So every time I would run my script, I want this to happen. So, I'm going to stop the script. Let's give it a name. I'll call it Time Sheet. The good thing is that scripts can be used together with any workbook. So, I'm going to open up a blank workbook. Now, go to Automate. This is my Time Sheet script. Select it Run, and I have my Time Sheet starting from today's date. Number five: Value Preview tooltip. This is great for understanding your formula results..

For example, here, I have a nested IF function, and I want to understand why it's returning - ID Card Make

This is great for when it comes to debugging your larger and more complicated formulas. Next up: Use Dynamic array results as source data for Power Query. So, for example, here, I have my FILTER function. These are the results. I can send this to Power Query as source data. I just have to go to Data, From Table/Range, and this array is automatically sent to Power Query. Now, you don't have to use the FILTER function. You can use any other function that spills,.

And you're going to get FromArray in your Power Query Editor. Now, you can go ahead and rename these. So, this is basically the same array that I had sent to Power Query before. I've renamed it. I've also added a custom column to it, and I've even used it to merge the data from data that's coming from a CSV file to create the result that you see on this sheet right here. This result is based on a CSV data file as well as my dynamic array range. As this range updates,.

This result is going to update as well. And we can quickly check that out. I'm going to go here. So, this is the source data on which the FILTER function is based on, filtering for everyone that's in the Productivity department. Now, this range updated. This needs to update and add in these new people that I've added with the status "Ready" to it. So the moment I refresh this, we should see that happen. And it happened. So, Power Query.

Is now able to accept data from a table, from a named range, and also from dynamic array ranges. Now, support for dynamic array functions isn't just restricted to Power Query. It's also coming to charts. So soon, the charts that you create, which are based on dynamic array functions like FILTER or SORT, are automatically going to expand like you see here or shrink depending on the size of your dynamic array results. I covered this in more detail in a separate video..

DISCLAIMER: In this description contains affiliate links, which means that if you click on one of the product links, I'll receive a small commission. This helps support the channel and allows us to continuetomake videos like this. All Content Responsibility lies with the Channel Producer. For Download, see The Author's channel. The content of this Post was transcribed from the Channel: https://www.youtube.com/watch?v=UnU81ITTsHU

Best NEW Excel Features EVERYONE Needs - ID Card Make

For example, here, I have a nested IF function, and I want to understand why it's returning - ID Card Make

Contact Form