Adv

QuestionEdit

How are you? I have a query. I want to learn Advanceconcepts in detail. I tried browsing on Google for some online tutorials or eBooks but couldn't find any type which I¡¯m looking for.

Could you please suggest me something how can i learnin detail all the advance concepts which are mainly used in maintain huge data and creating different types of reports, creating macros etc. I want to learn all the functions that are used in these things. I have basic know of vb.net also. Could you please help me with some material or eBooks of online links.

I'm really in need of it sir. Please help me.

AnswerEdit

Here is one good place to start:

http://www.datapigtechnologies.com/ExcelMain.htm

There are plenty of good books - John Walkenbach is a good place to start:

http://spreadsheetpage.com/

he books that cover many, many of the advanced features including charting, formulas, vba. He lists his books at that site. He also has tips pages that illustrate many advanced techniques.

if you know vb.net, then you might not want to spend a lot of time using VBA. You can programexternally using vb.Net.

Chip Pearson http://www.cpearson.com/Excel/MainPage.aspx has extensive information on all aspects of Excel

Debra Dalgleish has a lot of information on pivot tables, data validation, and many other topics

http://www.contextures.com/tiptech.html

Stephen Bullen covers advanced topics http://www.oaltd.co.uk/ see his books as well.

http://support.microsoft.com Microsoft Knowledge Base

http://MSDN.Microsoft.com for programming - has a special section on programming office

Obviously there are many many more sources. some of the above sites have links pages with links to other sites. Google should be your friend as well.