A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » New Users
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Paths to becoming an Excel Expert



 
 
Thread Tools Display Modes
  #1  
Old February 9th, 2010, 05:19 PM posted to microsoft.public.excel.newusers
PBB
external usenet poster
 
Posts: 3
Default Paths to becoming an Excel Expert

Dear community

I am a retired accountant, and have used Excel for many years, including
power user, macro and VBA development.

I would like to specialise in this field + maybe delivering Excel training,
maybe offering my services as a freelance.

What is the best path to develop this expertise? Is there a worthwhile
Microsoft Certification route - which I find confusing? And finally is it
worth sticking with VBA which seems to be on the back burner now?

Thanks for any suggestions.
  #2  
Old February 9th, 2010, 05:56 PM posted to microsoft.public.excel.newusers
Luke M
external usenet poster
 
Posts: 2,672
Default Paths to becoming an Excel Expert

First, some links to several "Excel Experts"
www.chandoo.org
www.peltiertech.com
www.contextures.com
www.spreadsheetpage.com

Each has their own specialties, so that may determine what model you want to
follow. In basics, you need to get your name out there and become established
as someone that people can trust and know about.

These days, the goto method usually involves starting a blog where you
discuss XL topics, maybe offer a few free XL workbooks showing off some of
your stuff. Once traffic starts to build, you could get some advertisements
going on your site to generate revenue. Work at getting more people to notice
your site, and start offering your services (for $$$). All the experts I
listed are very approachable, and you could probably write to them for
further advice/detail. Chandoo's site is relatively new, so he would probably
have a lot of insight as to becoming recognized as an expert.

I'd hang onto the VBA knowledge. There's still a large amount of people
using it, and it provides so much more power to XL. Also, its one of the few
parts of XL that can be password protected for security, thus preserving your
intellectual property, if so desired.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"PBB" wrote:

Dear community

I am a retired accountant, and have used Excel for many years, including
power user, macro and VBA development.

I would like to specialise in this field + maybe delivering Excel training,
maybe offering my services as a freelance.

What is the best path to develop this expertise? Is there a worthwhile
Microsoft Certification route - which I find confusing? And finally is it
worth sticking with VBA which seems to be on the back burner now?

Thanks for any suggestions.

  #3  
Old February 9th, 2010, 08:18 PM posted to microsoft.public.excel.newusers
John
external usenet poster
 
Posts: 563
Default Paths to becoming an Excel Expert

Hi PBB
Check this site for MCAS certification also do a search in Google for MCAS
Certification.
http://www.microsoft.com/learning/en...ation/mbc.aspx.
Good Luck
Regards
John
"PBB" wrote in message
...
Dear community

I am a retired accountant, and have used Excel for many years, including
power user, macro and VBA development.

I would like to specialise in this field + maybe delivering Excel training,
maybe offering my services as a freelance.

What is the best path to develop this expertise? Is there a worthwhile
Microsoft Certification route - which I find confusing? And finally is it
worth sticking with VBA which seems to be on the back burner now?

Thanks for any suggestions.


  #4  
Old February 9th, 2010, 08:36 PM posted to microsoft.public.excel.newusers
John
external usenet poster
 
Posts: 563
Default Paths to becoming an Excel Expert

Hi Again
If you're looking for just Excel certification, do a search for MOS
Certification.
"Microsoft Office Specialiste"
John
"John" wrote in message
...
Hi PBB
Check this site for MCAS certification also do a search in Google for MCAS
Certification.
http://www.microsoft.com/learning/en...ation/mbc.aspx.
Good Luck
Regards
John
"PBB" wrote in message
...
Dear community

I am a retired accountant, and have used Excel for many years, including
power user, macro and VBA development.

I would like to specialise in this field + maybe delivering Excel training,
maybe offering my services as a freelance.

What is the best path to develop this expertise? Is there a worthwhile
Microsoft Certification route - which I find confusing? And finally is it
worth sticking with VBA which seems to be on the back burner now?

Thanks for any suggestions.



  #5  
Old February 10th, 2010, 04:14 PM posted to microsoft.public.excel.newusers
JP[_5_]
external usenet poster
 
Posts: 559
Default Paths to becoming an Excel Expert

A simple search for "vba password hack" will have you rethinking the
idea that VBA password protection is safe for protecting intellectual
property.

--JP

On Feb 9, 11:56*am, Luke M wrote:
First, some links to several "Excel Experts"www.chandoo.orgwww.peltiertech.comwww.cont extures.comwww.spreadsheetpage.com

Each has their own specialties, so that may determine what model you want to
follow. In basics, you need to get your name out there and become established
as someone that people can trust and know about.

These days, the goto method usually involves starting a blog where you
discuss XL topics, maybe offer a few free XL workbooks showing off some of
your stuff. Once traffic starts to build, you could get some advertisements
going on your site to generate revenue. Work at getting more people to notice
your site, and start offering your services (for $$$). All the experts I
listed are very approachable, and you could probably write to them for
further advice/detail. Chandoo's site is relatively new, so he would probably
have a lot of insight as to becoming recognized as an expert.

I'd hang onto the VBA knowledge. There's still a large amount of people
using it, and it provides so much more power to XL. Also, its one of the few
parts of XL that can be password protected for security, thus preserving your
intellectual property, if so desired.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*

  #6  
Old February 10th, 2010, 07:39 PM posted to microsoft.public.excel.newusers
Luke M
external usenet poster
 
Posts: 2,672
Default Paths to becoming an Excel Expert

And I learn a little bit more!

Thanks for the correction JP.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"JP" wrote:

A simple search for "vba password hack" will have you rethinking the
idea that VBA password protection is safe for protecting intellectual
property.

--JP

On Feb 9, 11:56 am, Luke M wrote:
First, some links to several "Excel Experts"www.chandoo.orgwww.peltiertech.comwww.cont extures.comwww.spreadsheetpage.com

Each has their own specialties, so that may determine what model you want to
follow. In basics, you need to get your name out there and become established
as someone that people can trust and know about.

These days, the goto method usually involves starting a blog where you
discuss XL topics, maybe offer a few free XL workbooks showing off some of
your stuff. Once traffic starts to build, you could get some advertisements
going on your site to generate revenue. Work at getting more people to notice
your site, and start offering your services (for $$$). All the experts I
listed are very approachable, and you could probably write to them for
further advice/detail. Chandoo's site is relatively new, so he would probably
have a lot of insight as to becoming recognized as an expert.

I'd hang onto the VBA knowledge. There's still a large amount of people
using it, and it provides so much more power to XL. Also, its one of the few
parts of XL that can be password protected for security, thus preserving your
intellectual property, if so desired.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*

.

  #7  
Old February 11th, 2010, 12:50 PM posted to microsoft.public.excel.newusers
Ed Ferrero[_3_]
external usenet poster
 
Posts: 102
Default Paths to becoming an Excel Expert

Hi PBB,

A few thoughts - just my own opinion, you will have to make up your own
mind.

Developing an on-line presence helps, but it it not a prerequisite for doing
Excel consulting.

I would not reccomend Microsoft Certification for product technologies - you
should already know the product if you want to consult.

MCT seems to be well regarded if you wish to be a trainer, not something I
have done, but I have seen others do quite well.

If you wish to do Excel consulting, go see a few local businesses, leave a
one-page summary with them, be patient, get referrals.

You are an accountant, you know Excel, do not price yourself too cheap,
quote an hourly rate that is consistent with your market.

Be wary of clients who expect too much. Take small projects first where
deliverables are easily measured by you and your client. Take larger
projects when you are comfortable with the client. Have a graceful exit
strategy when you are not comfortable.

Always be prepared to learn from your clients, do not assume you know it
all.

Ed Ferrero
www.edferrero.com


  #8  
Old February 11th, 2010, 02:29 PM posted to microsoft.public.excel.newusers
JLatham
external usenet poster
 
Posts: 1,896
Default Paths to becoming an Excel Expert

Here's some information that Jan Karel Pierterse (http://www.jkp-ads.com)
provided about how to really lock-down/protect your VBA code:
http://www.microsoft.com/office/comm...337&sloc=en-us

I'll save you a trip to the link, but wanted to give credit where it was
due, by posting the meat of it he

1. Save the Excel workbook (.xls) file into an add-in (File SaveAs.....)
2. After you have the saved add-in (.xla), close the Excel workbook (.xls)
3. Double click on the add-in to open it
4. Press Alt+F11 to access the add-in's vba project
5. Lock the vba-project with a password
6. Double-click on the "ThisWorkbook" code module
7. Press F4 to open the Properties window
8. Change the "IsAddin" status to FALSE
9. Return to Excel by Pressing Alt+Q (or close the vbe window)
10. Go to Tools Share Workbook
11. When the dialogue appears, check the box for: (Allow changes by.....)
12. Press OK to close the Dialogue
13. When prompted to save, Press OK
14. Press Ok to accept that "macros cannot be accessed"
15. You should feel giddy at this point because you just realized what you
have
been missing right under your nose
16. Verify that the [SHARED] appears in the application title bar
17. Now save the workbook again as an Add-in (File SaveAs...) overwriting
the
previous one
18. Close this Excel workbook without saving the changes (you don't need it)
19. Test out your newly saved add-in (open it, access the vbe, try to expand
the project window, you should get the new message "Project is Unviewable"
20. You're done


"Luke M" wrote:

And I learn a little bit more!

Thanks for the correction JP.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"JP" wrote:

A simple search for "vba password hack" will have you rethinking the
idea that VBA password protection is safe for protecting intellectual
property.

--JP

On Feb 9, 11:56 am, Luke M wrote:
First, some links to several "Excel Experts"www.chandoo.orgwww.peltiertech.comwww.cont extures.comwww.spreadsheetpage.com

Each has their own specialties, so that may determine what model you want to
follow. In basics, you need to get your name out there and become established
as someone that people can trust and know about.

These days, the goto method usually involves starting a blog where you
discuss XL topics, maybe offer a few free XL workbooks showing off some of
your stuff. Once traffic starts to build, you could get some advertisements
going on your site to generate revenue. Work at getting more people to notice
your site, and start offering your services (for $$$). All the experts I
listed are very approachable, and you could probably write to them for
further advice/detail. Chandoo's site is relatively new, so he would probably
have a lot of insight as to becoming recognized as an expert.

I'd hang onto the VBA knowledge. There's still a large amount of people
using it, and it provides so much more power to XL. Also, its one of the few
parts of XL that can be password protected for security, thus preserving your
intellectual property, if so desired.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*

.

  #9  
Old February 11th, 2010, 02:36 PM posted to microsoft.public.excel.newusers
JLatham
external usenet poster
 
Posts: 1,896
Default Paths to becoming an Excel Expert

The MOS certification is 'ok', and relatively inexpensive to achieve. But it
really is a certificate more to certify an end-user's abilities. There is
nothing in the test about writing VBA code from scratch; it centers around
how to do things in Excel/on a worksheet. Of course, knowing that is crucial
to actually providing professional services. I say this from experience,
since I now hold Excel 97 cert along with full MOS Master cert for Office
2003.

I also agree with Luke M about VBA being a valuable tool. There simply are
many things that cannot be done with worksheet functions alone, especially
when it comes to building custom applications with lots of automation for
clients.

"John" wrote:

Hi Again
If you're looking for just Excel certification, do a search for MOS
Certification.
"Microsoft Office Specialiste"
John
"John" wrote in message
...
Hi PBB
Check this site for MCAS certification also do a search in Google for MCAS
Certification.
http://www.microsoft.com/learning/en...ation/mbc.aspx.
Good Luck
Regards
John
"PBB" wrote in message
...
Dear community

I am a retired accountant, and have used Excel for many years, including
power user, macro and VBA development.

I would like to specialise in this field + maybe delivering Excel training,
maybe offering my services as a freelance.

What is the best path to develop this expertise? Is there a worthwhile
Microsoft Certification route - which I find confusing? And finally is it
worth sticking with VBA which seems to be on the back burner now?

Thanks for any suggestions.



.

 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 12:08 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.