Learn the top 30 advanced Microsoft Excel features you need to know to go from beginner to advanced Excel user.
Table of Contents:
1. Get Data from Folders 0:22
2. Text to Columns 5:34
3. Remove Duplicate Values 7:22
4. AutoFill & Fill Handle 8:28
5. Flash Fill 10:41
6. Custom Lists 12:55
7. Freeze Panes 14:36
8. New Window and Arrange 15:48
9. Tables 17:21
10. Ideas 21:37
11. Rich Data Types 23:00
12. Fuzzy Matching 24:53
13. Data Validation Dropdown List 29:28
14. Data Validation Cell Message 32:00
15. Create a Named Constant 33:26
16. IF Function 35:03
17. COUNTIFS Function 36:29
18. SUMIFS Function 37:34
19. VLOOKUP Function 38:54
20. INDEX & MATCH Functions 40:06
21. Dynamic Arrays Functions 42:59
22. Display Formulas 49:14
23. Filters 50:10
24. Advanced Filters 52:55
25. Tables Slicers 56:23
26. PivotTables 57:58
27. Pivot Table Slicers & Timelines 1:02:09
28. Show Values As Calculations 1:03:49
29. Data Model Relationships 1:05:17
30. Data Model Advanced DAX Formulas 1:08:48
Get the workbook used in the video to follow along: 👇
Check out my full courses and ebooks here
👉
DOWNLOAD the example workbook here
📖
SUBSCRIBE & get my 3 FREE eBooks
📧
CONNECT with me on social
Facebook:
Twitter:
LinkedIn:
Thanks for all your support!
Microsoft Excel, Excel, Microsoft, Tutorials, Tips and Tricks, Advanced, Functions, Dynamic Arrays, VLOOKUP, INDEX and MATCH, Flash Fill, AutoFill, COUNTIFS, SUMIFS, Power Query, Tables, Pivot Tables, DAX, Data Model, Filters, Slicers and Timelines, Ideas, Rich Data Types
See other Tips articles
:https://handmadebrigadeofoc.com/tips
Nguồn:https://handmadebrigadeofoc.com/
Check out my full courses and ebooks here
👉 https://www.howtoexcel.org/courses/
This could be enhanced with an index that could to select any tip
Excel lent ! Thank you; most helpful.
excellent material! thank you
Wow.. some great tips and explained well! I learned a lot. Super video.. thank you 🙂
Really nice tips. Thanks
Excellent tutorial! Definitely recommended for learning Advanced Excel.
Its fantastic learning. Way of teaching is outstanding
Sir ji Hindi me bhi video banaya karo
You are the best
for text to columns, if you don't close the current workbook and open a new spreadsheet – and try to paste something that has the delimiter, then it will automatically apply text to columns. Only way to stop this is to close all excel projects and re-open them and apply text to columns to your second project.
This always caused me issues in dealing with different daily banking reports.
Hi. I am trying to create a list with different scenarios. I wanted to use the dropdown list (for the scenarios) in combination with other functions so that if someone clicks on a scenario name it will give you a list of the assumptions in that scenario. Is there a way that i can do this?
Thank you so much for the video! Very well explained with crystal clear instructions. I would like to ask on Hide and Unhide feature in Excel. Do you know if there is any hotkey available or an easier way to Unhide all hidden columns and rows at the same time?
Long Video. '&' boring.
Expel
132
123
213
231
321
312
If I register a three digit number it is automatic
I need to change how I do this
Can you help
saiprabhu9944@gmail.com
Excel has many different versions. It will be a good practice to mention which Excel version is the video talking about. Maybe for most part, they are common for different versions and this is good, but there are issues which differ from one version to another and this confuses the user. In this particular video and first tip, I am using 2013 version and I don't have "from folder" option. Also different options in "From other sources" are very strange for me and I couldn't understand them. I should search in Internet for their meaning and usage.
Awesome👌
Amazingly presented. Very well explained.
Hands down the best excel video I've seen so far.
Nice video, but 50:00 is not a tilde. ~ is a tilde, ` is a grave accent (had to look that up).
Your classes are great! i love it. Is there a way to filter between times? Say for instance, I have a courier team who drives medical supplies back and forth all day. So we have 1st shift, 2nd shift, 3rd shift, overnight and weekend shift. I have 6 months worth of data and i was trying to see overnight shift only. So i wanted to filter it to where i only see routes picking up items from 10:30pm to 7:00am. Is this possible? do you have a tutorial on how to do that if it is possible? Please advise. 🙂
Thank you for this lesson, really useful tips! I am really interested in advanced filter, I used it some time ago, but the biggest problem is that you can't make it adjusted for end user, as you you have table with some parameters above the table, every time you changed the data you applied filter by yourself. Do you know is it possible to auto-filter cells based on filled in data?
Thank you for this lesson! Can you please tell me how to add my signature and graphics so that it appears automatically within my emails?
I've subscribed and downloaded all the other workbooks except for this one ?
First tip to get Data would be huge for me. Now how do you get the data from a folder with sub folders? I've tried to do so, and I get an error of [Expression.Error] The key didn't match any rows in the table.
If I pull from each individual folder, I don't get this error, is there a work around?
so fantastic
Awesome video and great tips summarized for every level of Excel users! Thank you!!
fabulous thanks
Good video
It's good to know. But ur presentation it's not that's smart. Small view n sleepy voice.. Goodluck
@2:55– and that's gonna open up power (inaudible) editor… What word did you say there? Thanks in advance.
Very amazing and updated tutorial which is easy to follow. Thank you very much.
Nice tutorial. It would be even more professional if you can get rid of the keyboard clicking noises. So distracting!
I have miscellaneous dates in my table. I created a PT and I am trying to add a timeline so I can see our agent's monthly sales. I keep getting an error message, "We can't greater a Timeline for this report because it doesn't have a field formatted as Date." What am I doing wrong?
Fabulous tutorial! Loved every bit of it. Thank you so much! Just a tiny question: How did you get the yellow circle around the curser? Again many thanks!!
These are great tips, but for the first tip: isn't it too complicated for adding a file in a sheet in a workbook? For what purpose would you use it this way? Thank you!
Excellent Video, however, I could not find a way to enable the Idea Button. I went in options and enabled it there but it did not work.
The same apllies to rich data!
Somene knows how to enable these buttons?
Great video. Useful tips. Thanks
thanks for the great video. i have one little problem though: i want to add columns to my queried table, but as soon as new data is added to the table, the data from the new columns loses its reference. is there a ways to keep the data in the right place when new data is added?
Nice demonstration, but I want to add that the new functions are also available on Microsoft's web based version of Excel, so there is no need for Office 365 if anyone wants to casually try these out.
Vielen Dank für ein riesige Information für Microsoft Excel, die Zusammenfassung ist voll gelungen. Ob es jede so korrekt schaffen wird, fraglich. Sehr Hilfreich! Respekt!
Excellent Video… Thank you.
The workbook isn't available. How do we get it
Very nice!
Great tips on excell
"FILTER" Formula not showing in Excel 2019, Pls help.
Thank you so much for doing these videos, you are a legend.
hello sir can i have the excel files please the link is no more avail