Office 2010 Class #35: Excel Sort and Filter (Data Analysis)
HTML-код
- Опубликовано: 11 сен 2024
- Excel Start File: people.highlin...
Excel Finished File: people.highlin...
Free Excel 2010 book: people.highlin...
The Excel 2010 Basics Series shows a systematic description of what Excel can do from beginning to end.
Topics Covered In Video:
1. Sort with Buttons
2. Sort with Dialog box
3. Sort two columns
4. Sort by Color
5. Turn On Filter keyboard = Ctrl + Shift + L
6. Filter
7. Filter By Color
8. Filter and Extract Data
9. Number Filter
10. Date Filter
11. Between Criteria Filter
12. Text Filter
Hands down, the best instructor. I am an instructor myself, and I appreciate your delivering techniques.
Greetings from Cairo, Egypt.
Thank you for the kind words!
Hello Mike, hope you are good.
Is there a way I can reach you and discuss a very minor issue?
For the heads up, I am passing everything I know about excel (using your videos mainly and some of others as well) to other people as a pay-it-forward kind of deed.
To know where they stand I keep on giving them excel practice sheets that I created for their needs.
They require a test to evaluate their final efforts.
Things is that they are 997 people. I'm only 1 person :D.
As a teacher and a great excel instructor, can you suggest something for me? To test 994 people in the shortest time, the easiest way :)?
I'd appreciate if you answer. I'd understand if you didn't :).
I do not have a good answer for testing 1000 students. Sorry.
I am glad that you liked it!
You are welcome! Thanks for clicking the "Like" button on all the videos!
It makes a difference later when you are recording Macros. Ctrl + * highlights the "current range", Ctrl + A highlights everything.
You are welcome!
brilliant video, I am very poor on excel, and yet work with computers on a daily basis, so this is helping me to learn.
I know this is an old video, but you are SUCH are great teacher. I love your enthusiasm and you have a very good voice, that is pleasant to listen. YOU ARE THE BEST I'VE SEEN. Excel is like trigonometry to me. But now I found your channel; and maybe thanks to you, I might get over the learning curve. THANK YOU!!!
I am glad that you like them! Thanks for cool comment, Lisa : )
Yes, instead of using the search, use Text Filter, Contains, then do two with an OR criteria.
Yes, sometimes I do. The keyboard for "Select Visible Cells Only" is Alt + ; Then you can copy.
Glad you like the videos!
Love you ExcellsFun! You're the best teacher ever!
Thank you for so much great lessons, tricks and tips!
You're great!!
I am glad that they help!!!
AWESOME
AWESOME
AWESOME
Appreciate for educating the community.
Thanks a lot
What version of Excel do you have? If you don't have Excel 2010. they will do show up.
You are a legend for these
Really well explained! It seems easy, but explaining well these concepts requires lots of knowledge. Thanks a lot :)
@jewnaaa , Ctrl + * (* on Number Pad) highlights whole table.
Your R really Super Star.The way u explain and Present are Truly amazing & Awesome ......Thank You, Sir,
Thanks dude, you saved me.... we will have a quiz about this..... :) thank you so much......
Dude, this is amazing!!! Thank you do much!!
Great Tutorial! Thank you so much ! I am way more confident now...
You are welcome! Thanks for the Thumbs Up!
ExcelIsFun
I have a small problem on my sheet ... when sorting it does sort the header as well
to make it more clear when I try to sort the Region it sorts the Region header as well
can you please help to prevent the A - z to include the headers to be sorted
many thanks
How do u undo a expanded sort? When I want to sort something else, the selection is expanded and I only want to sort one column...
Sometime when I used the filter in my tables and tried to copy and paste only the filtered data and paste them into another sheet, it would not work. My computer pasted the whole table ignoring the filter. To overcome this problem I had to select the table and then use "Go to", "Special", "Visible cells only", "copy" and then "paste". Did you ever have this problem? Thank you for your help. I love your channel.
Very good!
Thank you :)
Thank you.
Ctrl + Shift + *
is that same Ctrl + A?
Really amazing, Unfor could't understand command at 06:23, plz write down in reply, thanks
what's the difference between using Ctrl+A and Ctrl + *. It seems they are doing the same job
Thanks
At the end of the video you filtered LLP. Is there any way to filter LLP and INC? I jus want to know if you can filter more than one item at a time.
Hello and Thank you so much for your videos, they are really helpful and inspiring to search for new ways of making our work easier!
I have just one question about a problem I'm experiencing lately - how can I copy a filterted table into another filtered table without losing the data between the lines of the 2 filtered table? What am I doing wrong , so that I lose my data between the lines? Or, another question - whenever I want to color several cells into a filtered table, the hidden cells get colored as well? Why is that?
Thank you for your answer!
I do not know how to change this default behavior. You can try THE best Excel question site:
mrexcel.com/forum
Weekday post get much fast responses than do weekend posts, however.
After I paste Luke's sales data into the new sheet, the smart tag button (at 10:20) doesn't show up and I am not able to keep the source column widths. Am I doing something incorrect?
more usefull.. thanks
For anyone who would like to know the copying of a book (holding CTRL and click) works as CMD + OPTION and click on Mac :)
thank u
I can't do somethings because my workbook is shared. how do I unshare the workbook
Hello! i really need help about this. I have data that contains numbers like this "1111-01-04-11". But i only want to sort datas(numbers) that shows only 5th or 6th numbers. For my example it would be "01". Is it possible?
Was this done in a table?
Where can we see the next video #36?
I don't find the workbook on your site. Please guive me the link.
Office 2010 section, Excel link.
In IT class :D
When I do this to sort by date, it keeps everything the same (does not sort other columns) except the date column changes which means that the dates changed are not the correct dates to the other column.. help?
On the data set provided, when you click in a single cell? That should not be happening, at all. The only way that can happen with a proper data set, is if you highlight the date column and then force your way through the warning dailog box (Excel 202 or later). If this ever does happen, click undo immediately when this happens, then try clicking in a single in the date column, then click Sort Button.
I click a single cell ("date") and for some reason it's not keeping the row information consistent with the dates. For the "address" cells I have =proper() because the other address columns were all capitalized so I used the proper formula to automatically do the proper capitalizations. Is this what you meant by proper data set?
The sort feature is not made for formulas. I am sure your problem is real, I just can't think of what is causing it. You might post here for back and forth dialog to get Excel solutions:
mrexcel.com/forum