Excel Basics #21: Data Analysis Filter &Dynamic Ranges

[@excelisfun]

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!

[@excelisfun]

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

[@excelisfun]

Not so much as awesome, as just a guy having fun with Excel!! I am glad that you like the channel!

[@excelisfun]

I am glad that you like it!

[@excelisfun]

You are welcome!

[@excelisfun]

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.

[@tempsfuit]

Just wanna comment that your videos are so resourceful, great for excel rookies such as myself - thanks heaps!

[@fantabulous008]

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...

[@romanaadd]

Thank you so much for uploading all these videos. I have covered first 21 vids and already feel so much more confident. Thanks.

[@RG-zq2dw]

Very nice videos, step-by-step intro and easy to understand. Good job! Highly recommended to everybody. Fantastic!!!

[@excelisfun]

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

[@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.

[@excelisfun]

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.

[@excelisfun]

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

[@excelisfun]

Dear d4greatmaster, You are welcome! --excelisfun

[@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 KZbin search for Excel Mac videos? --WishIKnewMacExcel --excelisfun

[@excelisfun]

Sorry, but I don't have a video on that topic.

[@KaroBarca7]

hey do you happen to have a list of all your amazing keyboard shortcuts that we can print out?

[@excelisfun]

Dear KaroBarca7 , I do not. I'll put it on my list of things to do. --excelisfun

[@excelisfun]

Did you try this video title: Highline Excel Class 16: Sort, Sorting 10 Examples Otherwise, it is sometimes hard to ask questions at KZbin. 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)!

[@excelisfun]

I am sorry. I do not know how to use a Mac.

[@TheMrBenjamin]

Hey, Do you have video which covers using the exponential smoothing feature in the Excel Data Analysis toolpak? Thanks

[@MrAlbatros1]

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

[@excelisfun]

I do not know. Try THE best Excel question site: mrexcel[dot]com/forum

[@yasslimz]

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!!

[@MrAlbatros1]

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.

[@deshioccer1]

how do you create table on mac excel???

[@yasslimz]

@ExcelIsFun Thank you for you help finding an alternative site.

[@monicajuarbe8972]

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.

[@mikecristancho]

Why did it not paste all the cells when you select the visible rows?

[@lloydevans1624]

I'm wondering the same thing.

[@KaroBarca7]

haha thanks

[@excelisfun]

You are welcome!

[@excelisfun]

I am glad that you like it!

[@excelisfun]

You are welcome!