Excel Basics #21: Data Analysis Filter &Dynamic Ranges
HTML-код
- Опубликовано: 22 авг 2024
- Download file: excelisfun.net...
Download file: people.highlin...
The Excel Basics Series shows a systematic description of what Excel can do from beginning to end.
#21 Video topics:
1)Filter Text
2)Filter Number
3)Filter Date
4)Filter by color
5)Sort by color
6)Excel Table or List Sort Filter Dynamic Ranges
7)Function with Dynamic Range (Range updates when records added)
8)Excel Table Ctrl + T
9)Excel List Ctrl + L
You are welcome! If you watch all 23 Basic Videos and then move on to the 'Highline Excel Class' series, you can become really good with Excel!
Dear mykstrung,
I am glad that you like it. I have at least 30 other videos on Pivot Tables. Search for and watch this video to learn how to use the excelisfun channel and search for any video you want:
Search For Excel Videos Download Excel Files excelisfun
Let me know how your studied of Pivot Tables go after watch a few videos!
--excelisfun
Just wanna comment that your videos are so resourceful, great for excel rookies such as myself - thanks heaps!
I am glad that you like it!
Dude ur AAWESOME!!! I can't believe how many tips are revealed in ur vids. These tips are help when studying for the MOS Exams!!! Thanks for posting these vids...
Not so much as awesome, as just a guy having fun with Excel!!
I am glad that you like the channel!
You are welcome!
To have the SUM I showed show up when the Filter is used, put the SUM function in a row that is not a row in the table.
To add just Rhonda when the table is filtered, right-click the table, point to Table, then to Total Row. Then when you filter and just show Rhonda, the total will show just Rhonda's.
The SUMIF or SUMIFS functions will work also. Search my chnannel for SUMIF.
Thank you so much for uploading all these videos. I have covered first 21 vids and already feel so much more confident. Thanks.
Very nice videos, step-by-step intro and easy to understand. Good job! Highly recommended to everybody. Fantastic!!!
Dear d4greatmaster,
Search for and watch this video:
Search For Excel Videos Download Excel Files excelisfun
It will show you how to get the whole playlist.
--excelisfun
Dear d4greatmaster,
You are welcome!
--excelisfun
If the names are in the range A2:A1001, then I would add a new column that has the formulas:
=COUNTIF($A$2:$A$1001,A2)>1
in A2, then copy the formula down.
When the formula result is TRUE, then you keep that dup. record.
I'll make a video soon.
In 2003, it is not called a table, it is called a LIST. Ctrl + L does work in 2003. Look for "List" instead of "table" in the menu in 2003.
Thank you for making these videos. I'm having issues following your lessons, starting in the late teens. You seem to be giving more attention to 2003 than in prior videos and it's getting confusing with your bouncing between versions in your instructions. I find myself having to replay a lot now, whereas I was able to follow in the prior videos. It's more helpful if you could stick to one version in your lessons in the future. Again, thank you for taking the time to make these, but I figured some constructive criticism is in order as this has become frustrating to follow at this point.
@ExcelIsFun Thank you for you help finding an alternative site.
Dear MrAlbatros1,
I am sorry, but I do not know how to use a Mac. Someone did tell me that there is an option to use PC keyboard shortcuts on a Mac. If you can find it, post and let me know so that I can tell others!
--excelisfun
These are some of the shortcuts I already figured out:
F2=Control+U on mac.
F4=Command+T on mac.
Control + 1= Command +1. mostly the control in pc can be substituted with Command on Mac.
Thats all I have so far.
I still can't figure out anything for the table in this vid though.
Dear KaroBarca7 ,
I do not. I'll put it on my list of things to do.
--excelisfun
Dear MrAlbatros1,
Oh man, I wish that I could help! None of the instructors I know on campus use Mac / Excel so I have no one to ask.
So you are saying Command + T will add dollar signs to a cell reference in a formula?
Did you try a Google or RUclips search for Excel Mac videos?
--WishIKnewMacExcel
--excelisfun
Did you try this video title:
Highline Excel Class 16: Sort, Sorting 10 Examples
Otherwise, it is sometimes hard to ask questions at RUclips. The best place to ask Excel questions is this site:
mrexcel[dot]com/forum
If you post, then send me the link and i will help (although the 1000s of other Excelers at that site will help also)!
Sorry, but I don't have a video on that topic.
hey do you happen to have a list of all your amazing keyboard shortcuts that we can print out?
Hey,
Do you have video which covers using the exponential smoothing feature in the Excel Data Analysis toolpak?
Thanks
I do not know. Try THE best Excel question site:
mrexcel[dot]com/forum
I am sorry. I do not know how to use a Mac.
Hi Mr ExcelIsFun,
I use Excel 2008 for mac. I can't seem to create that table you create in the beginning of the video using shortcut keys or even the Table Under Data in Menu. Help please. Thanks
I wanted to make a 2011 calendar split into headings including 4 quarters for the year, 12 months, 4 weeks in each month and the days having daily responsibilities. Is this possible? how?, please as the company i work for would really appreciate this!!
Why did it not paste all the cells when you select the visible rows?
I'm wondering the same thing.
how do you create table on mac excel???
haha thanks
What exactly is the difference between filter and sort?
+Rob F. A 'filter'; essentially gives you a selection (or subset) of an entire data set whereas a 'sort' simply organizes your entire data set (Alphabetize/Reverse, or for numbers increasing/decreasing order).
You are welcome!
I am glad that you like it!
You are welcome!