Highline Excel Class 05: Charts, Page Setup, Data Analysis

[prudhvirajreddyable]

SUPER VIDEOS BUDDY GOD BLESS U

[prudhvirajreddyable]

SUPER



[prudhvirajreddyable]

EXCELLENT SUPER SUPER SUPER ITS VERY MUCH HELPFULL FOR ME

[rebesteves]

I use Excel 2007, when I press "Alt+F1", I open a new Word, not create a new chart. why?

[ExcelIsFun]

The only reason I can think of is that the administrator of your computer programed it that way - which mean it would over-ride the default keyboars set up by Microsoft.

[sameer482]

unbelievable, ur a genius man!. From where did u get all this knowledge about excel. you are a real Excelerator.

KEEP IT UP!

[ExcelIsFun]

I got it from books, practice, answering questions, and the Mr excel Message Board.

I am glad that the videos help!

[VanLtheMan]

Can I use AMPERSAND to name my chart title such as (="Sales for the month of "&'Sales'!D2&"and Region of "&'Sales'!D2&)? My charts are created my as new sheet instead of as an object. Thank you for sharing I learned a lot.

[ExcelIsFun]

Yes you can! Make the formula in a cell first, then point the chart title to that cell. search for and watch this video title:

Excel Dynamic Chart #5: Dynamic Chart Labels using TEXT function and Ampersand &

[lexingtonlp]

Once again just amazing! You are the Michael Jordan of Excel. I very much appreciate your hard work, effort and time. Best Excel teacher ever!

[ExcelIsFun]

I am glad that they are helpful!!

[secoja]

thanks!!

[ExcelIsFun]

You are welcome!

[omiuno]

Love the new series!

[ExcelIsFun]

Great! I am glad that you like it. The Highline Series is the most comprehensive series I have at YouTube. It covers many things that you would want to do in Excel.

[anilbit4]

hello sir,

have you got love and passion for excel only??

when can we get a chance to learn other softwares like....powerpoint and project

[ExcelIsFun]

Dear anilbit4,

This is my hobby - so it is what I love to do! I don't have any PowerPoint or Project.

--excelisfun

[whmmx]

so great, very helpful!

thank you for your hard work!

[ExcelIsFun]

Dear whmmx,

You are welcome! I am glad that they help!

--excelisfun

[kami645464]

You are just amazing! I was looking for somebody who can post video tutorials for MS Office, which are really well explained with proper language and with a lot of variety and have now found it at your channel. Just great work.

[ExcelIsFun]

Dear kami645464,

EXCELlent! I am happy to make the videos and I am happy that they are of use to you!

--excelisfun

[Thunderbird2014]

At 20:34 you did a sort on Column C. Then you did another sort on column B. That second sort was a sort within a sort. Is that true?

If so, suppose that when I sort Column B (after sorting column C), I want only column B to be sorted and not to be sorted "within" Column C (as if I sorted by B in the first place).

How would you do that? Is that possible?

[ExcelIsFun]

Dear Thunderbird2014,

Yes: Sales Rep sorted within Region (Region is the major sort).

If you I want only column B to be sorted and not to be sorted "within" Column C, highlight just the B column and do sort, but then you destroy the database integrity (as demonstrated at 21:00)

--excelisfun