Excel Basics #21: Data Analysis Filter &Dynamic Ranges

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

Category:

Science & Technology

Tags:

• Excel
• Filter
• Text
• Number
• Color
• Date
• Dynamic
• Range
• updates
• records
• added
• Mike
• Gel
• Girvin
• Highline
• Community
• College

[QQQQQman]

Hi I am having problems with creating table (2003). ctrl t ctrl l does not work. I go to Data, then Table then am asked for Row input cell and Column input cell. For the former I tried A1:A350 etc etc but "INPUT CELL REF IS NOT VALID" message keeps appearing for all I try:(.....

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

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

[ExcelIsFun]

I do not know. Try THE best Excel question site:

mrexcel[dot]com/forum

[santakgrg]

thank you soo much for keeping tutorial....it's helping me soo much ...thank you and god bless you...

[ExcelIsFun]

You are welcome!

[ExcelIsFun]

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

[tomasek262]

Hey! Where did you learn all that stuff? Amazing :) Thanks

[yasslimz]

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

[deshioccer1]

how do you create table on mac excel???