3 Tips avoid drag scrolling to copy down, instant table autofilters

http://www.accountingweb.co.uk/blog-post/excel-three-how-tips-i-found-to...

 

I am not clear whether I should have used the blog or this space.

 

Anyway I hope it is of interest and I am interested to read similar tips as I bring myself up to date with Excel and learn Excel for PC.

Powerpivot is what I want to learn next so I am about to read the thread about it.

Anthony

Comments

The VBA language contains a number of functions that you can use

Cantona1 | | Permalink

David Carter has written numerous articles on PT. You can find them on this forum. IMO, it is not that difficult to learn and use PT. Pivot 2010 has some powerful futures. PTs are largely designed for organising and summarising data. There are many excel experts on this forum.  Trust me; I have learned and still learning from these experts. I know many of them, but as some of use screen names and do not know their real names, it would be disrespect not to mention all of them.

I am now learning VBA which is the ultimate crown of excel- Thanks again to this forum for their tips and direction.

anthonymellor's picture

thanks for that, I just need to emphasise

anthonymellor | | Permalink

and should have made a better job of it: it is  P o w e r Pivot I want to learn next; though since that post I have started, it's very interesting indeed.

Add comment
Log in or register to post comments
Group: ExcelZone
A gathering place for the Excel community to explore new ideas and techniques and a forum to debate product features and best practices.