Office 2010 Class #35: Excel Sort and Filter (Data Analysis)

[RiimeZ]

In IT class :D

[jewnaaa]

Really amazing, Unfor could't understand command at 06:23, plz write down in reply, thanks

[ExcelIsFun]

@jewnaaa , Ctrl + * (* on Number Pad) highlights whole table.

[pahhhoul]

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?

[ExcelIsFun]

What version of Excel do you have? If you don't have Excel 2010. they will do show up.

[TheOongaboonga]

Hi.When I hit CTRL * to highlight table I'm getting a message "Cannot show outline symbols because no outline exists on the active worksheet. Create an outline?" I press OK and get "Cannot create an outline". What is the problem? Thanks. Love your channel.

[ExcelIsFun]

Ctrl + Shift + *

[EnerkaPower]

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.

[ExcelIsFun]

Yes, sometimes I do. The keyboard for "Select Visible Cells Only" is Alt + ; Then you can copy.

[NikonSanz]

brilliant video, I am very poor on excel, and yet work with computers on a daily basis, so this is helping me to learn.

[ExcelIsFun]

I am glad that they help!!!

[alyekhan]

very good instructions....thank you...found it very easy to understand....

[ExcelIsFun]

I am glad that you liked it!

[dualranger]

Thank you :)

[ExcelIsFun]

You are welcome!

[ges05]

Thank you for so much great lessons, tricks and tips!

You're great!!

[ExcelIsFun]

You are welcome! Thanks for clicking the "Like" button on all the videos!