Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 01-10-2014, 11:29 PM
MGadAllah MGadAllah is offline What are the best productivity add-in for Microsoft Excel I can use at business ? Windows 8 What are the best productivity add-in for Microsoft Excel I can use at business ? Office 2010 32bit
Novice
What are the best productivity add-in for Microsoft Excel I can use at business ?
 
Join Date: Jan 2014
Posts: 10
MGadAllah is on a distinguished road
Question What are the best productivity add-in for Microsoft Excel I can use at business ?

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!
Reply With Quote
  #2  
Old 01-11-2014, 02:17 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline What are the best productivity add-in for Microsoft Excel I can use at business ? Windows 7 64bit What are the best productivity add-in for Microsoft Excel I can use at business ? Office 2010 64bit
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,766
Pecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant future
Default

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 ?
__________________
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
Reply With Quote
  #3  
Old 01-11-2014, 02:44 AM
macropod's Avatar
macropod macropod is online now What are the best productivity add-in for Microsoft Excel I can use at business ? Windows 7 32bit What are the best productivity add-in for Microsoft Excel I can use at business ? Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

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]
Reply With Quote
  #4  
Old 01-11-2014, 03:36 AM
MGadAllah MGadAllah is offline What are the best productivity add-in for Microsoft Excel I can use at business ? Windows 8 What are the best productivity add-in for Microsoft Excel I can use at business ? Office 2010 32bit
Novice
What are the best productivity add-in for Microsoft Excel I can use at business ?
 
Join Date: Jan 2014
Posts: 10
MGadAllah is on a distinguished road
Default

Quote:
Originally Posted by Pecoflyer View Post
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 ?
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.

Quote:
Originally Posted by macropod View 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.
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.
Reply With Quote
  #5  
Old 01-11-2014, 04:20 AM
macropod's Avatar
macropod macropod is online now What are the best productivity add-in for Microsoft Excel I can use at business ? Windows 7 32bit What are the best productivity add-in for Microsoft Excel I can use at business ? Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

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]
Reply With Quote
  #6  
Old 01-11-2014, 04:22 AM
MGadAllah MGadAllah is offline What are the best productivity add-in for Microsoft Excel I can use at business ? Windows 8 What are the best productivity add-in for Microsoft Excel I can use at business ? Office 2010 32bit
Novice
What are the best productivity add-in for Microsoft Excel I can use at business ?
 
Join Date: Jan 2014
Posts: 10
MGadAllah is on a distinguished road
Default

Quote:
Originally Posted by macropod View Post
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.
So learning VB 6 will help for all VBA for all MS Office version?
Reply With Quote
  #7  
Old 01-11-2014, 04:24 AM
macropod's Avatar
macropod macropod is online now What are the best productivity add-in for Microsoft Excel I can use at business ? Windows 7 32bit What are the best productivity add-in for Microsoft Excel I can use at business ? Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

Quote:
Originally Posted by MGadAllah View Post
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]
Reply With Quote
  #8  
Old 01-11-2014, 04:25 AM
MGadAllah MGadAllah is offline What are the best productivity add-in for Microsoft Excel I can use at business ? Windows 8 What are the best productivity add-in for Microsoft Excel I can use at business ? Office 2010 32bit
Novice
What are the best productivity add-in for Microsoft Excel I can use at business ?
 
Join Date: Jan 2014
Posts: 10
MGadAllah is on a distinguished road
Default

Quote:
Originally Posted by macropod View Post
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.

This is the version I've in Excel 2010.

Ok, sorry if I misunderstood ... Please advise for the right thing I should do?
Reply With Quote
  #9  
Old 01-11-2014, 04:28 AM
macropod's Avatar
macropod macropod is online now What are the best productivity add-in for Microsoft Excel I can use at business ? Windows 7 32bit What are the best productivity add-in for Microsoft Excel I can use at business ? Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

So you would learn Excel VBA for Office 2010...
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #10  
Old 01-11-2014, 04:30 AM
MGadAllah MGadAllah is offline What are the best productivity add-in for Microsoft Excel I can use at business ? Windows 8 What are the best productivity add-in for Microsoft Excel I can use at business ? Office 2010 32bit
Novice
What are the best productivity add-in for Microsoft Excel I can use at business ?
 
Join Date: Jan 2014
Posts: 10
MGadAllah is on a distinguished road
Default

Quote:
Originally Posted by macropod View Post
So you would learn Excel VBA for Office 2010...
Where can I get started because I know nothing about coding
Reply With Quote
  #11  
Old 01-11-2014, 04:35 AM
macropod's Avatar
macropod macropod is online now What are the best productivity add-in for Microsoft Excel I can use at business ? Windows 7 32bit What are the best productivity add-in for Microsoft Excel I can use at business ? Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

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]
Reply With Quote
  #12  
Old 01-11-2014, 04:43 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline What are the best productivity add-in for Microsoft Excel I can use at business ? Windows 7 64bit What are the best productivity add-in for Microsoft Excel I can use at business ? Office 2010 64bit
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,766
Pecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant future
Default

Don't forget that a lot can be accomplished with formulas, though...
__________________
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
Reply With Quote
  #13  
Old 01-11-2014, 04:56 AM
MGadAllah MGadAllah is offline What are the best productivity add-in for Microsoft Excel I can use at business ? Windows 8 What are the best productivity add-in for Microsoft Excel I can use at business ? Office 2010 32bit
Novice
What are the best productivity add-in for Microsoft Excel I can use at business ?
 
Join Date: Jan 2014
Posts: 10
MGadAllah is on a distinguished road
Default

ok i will take my chances.
Reply With Quote
  #14  
Old 01-12-2014, 02:37 AM
macropod's Avatar
macropod macropod is online now What are the best productivity add-in for Microsoft Excel I can use at business ? Windows 7 32bit What are the best productivity add-in for Microsoft Excel I can use at business ? Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

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]
Reply With Quote
  #15  
Old 01-12-2014, 03:31 AM
MGadAllah MGadAllah is offline What are the best productivity add-in for Microsoft Excel I can use at business ? Windows 8 What are the best productivity add-in for Microsoft Excel I can use at business ? Office 2010 32bit
Novice
What are the best productivity add-in for Microsoft Excel I can use at business ?
 
Join Date: Jan 2014
Posts: 10
MGadAllah is on a distinguished road
Default

Quote:
Originally Posted by macropod View Post
ok, thanks!
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Microsoft Office Productivity joycreative Office 2 10-29-2013 02:38 PM
Microsoft Excel 2010 - To Do List teza2k06 Excel 2 03-05-2013 11:13 AM
Do I stand to gain productivity overall by upgrading to Word 2007/2010 from 2003? New Daddy Word 3 11-27-2012 03:24 PM
Microsoft word/excel problem ewicc Office 2 04-19-2010 07:35 AM
Microsoft Excel has encountered a problem suehoege Excel 1 01-06-2010 12:27 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 06:16 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft