Hello,
I am using microsoft excel 2010 about 8 hours per day at work for different tasks so I would love to know what are the best add-in (s) I can really depend on or use in business that facilitate tasks for my daily work?
Right now I am using asap utilities by pasten and it is really amazing one, so I would like to know if there are any a like?
Thanks a lot


Mohamed GadAllah!

Hi
there are lots of add-ins but all depends what kind of tasks you have to accomplish.
Could you be a bit more specific ?

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

IMHO the best productivity add-in is a thorough knowledge of those functions, etc. you need and how and when to use them. A good working knowledge of Excel vba could well be up there, as it allows you to write your own tools.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

I am using asap utilities right now foor excel by basten and wondering if there are any add-in a like.
I am working as a financial accountant.

I do not know any VB codes ... shall I learn it!? and is it VB 6 or a later version? I mean for Excel VBA only purposes.

Excel VBA is the Excel version of Visual Basic for Applications, not VB6 (which hasn't been available for years) or its successor VB.NET. Ideally, you would learn VBA for whichever version(s) of Excel you work with - each version differs as features get added/revised/deleted.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

So learning VB 6 will help for all VBA for all MS Office version?

I would have thought it obvious from my previous reply that the answer to that can only be No. VB6 has nothing to do with VBA.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

• 

This is the version I've in Excel 2010.

Ok, sorry if I misunderstood ... Please advise for the right thing I should do?

So you would learn Excel VBA for Office 2010...

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

Where can I get started because I know nothing about coding

There are many courses and books on Excel VBA. For books, you could do worse than start with these: http://spreadsheetpage.com/index.php/book/C45/

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

Don't forget that a lot can be accomplished with formulas, though...

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

ok i will take my chances.

Cross-posted at: http://www.techsupportforum.com/foru...ss-778298.html
For cross-posting etiquette, please read: http://www.excelguru.ca/content.php?184

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

ok, thanks!