My Entrepreneurial Life as a Microsoft Office VBA Freelancer Part I

My Entrepreneurial Life as a Consultant
So you’ve been pondering the possibility of becoming a freelance Developer.  You are tired of the cubicle jungle, unhappy with the compensation, that boss, the same old work or the crazy hours. Maybe like me, you are just ready for a new adventure. That’s what made me quit, build a website and figuratively “hang out a shingle”.  Since then I’ve coded sitting at my outdoor table on the back deck with hummingbirds buzzing around enjoying the great outdoors. My Entrepreneurial Life as a Consultant,
can be pretty sweet.  I’ve learned a significant amount since I’ve started and I’m happy to share what Ive learned. 

Excel Spreadsheet Complexity, Speed, Overhead and Data
I love my job.

Step 1 Build a Website, mine can be found at:  www.ExcelandVBACraftsman.com
First I found a provider- I happen to use GoDaddy.com, I have had no issues with them.  I then use WordPress, which was easy to learn and build that first page.  It is, however, much like Excel, there are different levels of users.  Complexity and sophistication come with time and use.  Get a good proofreader, I use two.  Think of your home page as your PHd dissertation.  It must be perfect – read it carefully. 

My Website, WordPress and SEO

I have a confession to make, even though my former employer required employees to disclose all outside employment, I didn’t. Years ago, I built a website and secured some moonlighting work.  I didn’t leave it up for long – I guess I was worried I’d be discovered and lose my job.  In building that first website, I did learn HTML and Javascript and they are still helpful today.  Unfortunately, much has changed in the internet over the past few years and getting ‘found’ can be quite difficult -more about that later.  In retrospect, I am sorry I didn’t keep the website up.  Websites grow, evolve and get better with time.  It may take a year or two to build and develop that killer website.  Your search history is said to play into the algorithm that dictates what page you appear in a Google search.

Traffic to my website is slowly building.
Traffic to my website is slowly building. I am however getting great and interesting work.

When I first published my website, I could safely describe activity as “crickets”.  I stayed at it and added content slowly, activity has risen and I’ve gotten calls and had some great assignments.

On December 17th I published an article on Developing at runtime that garnered some interest, 225 visits and increased google searches.   

Ok, now the bad news about Search Engine Optimization (SEO): Let’s do a search in Google on VBA freelance programming. The first page is loaded with paid for advertisements for the big guys of the freelancer industry
1. Toptal
2. Upwork
3. Freelancer      
4. Guru
Those same heavyweights appear several times.  You will need to go a couple pages in before you see any organic pages.  That is, pages like mine that are not paid for advertisements.  Now let’s go to the website   https://neilpatel.com/ubersuggest/ and type in “VBA Coding Help” make sure you are at the Overview section at the left.  The results:
Search Volume (Month)  30
Seo Difficulty                     27 (Easy)
Paid Difficulty                    24 (Easy)
Cost Per click     $3.96

That $3.96 cost per click is described as how much you would pay google to get high in the search results.  I can’t help but wonder what their conversion ratio must be to support $3.96.  That is exactly how many jobs they actually get per 10 clicks.  In any event, you’ll appreciate companies are paying ‘real money’ to get high on the page ranking.  The gatekeepers (Google) have made it difficult, but not impossible to get found.  The answer is to garner traffic through a number of funnels.  That, of course, includes social media, a blog, free products and tutorials on advanced coding. 

I’ll get into strategies I use to increase traffic in Part III. 

Raymond Mills MBA, MS

Raymond Mills, M.B.A., M.S.  has spent over 20 years of his career as Accountant, Investment Bank and Credit Card Technical Auditor/ Data Analyst.  His specialty was using Excel to get Big Databases including Teradata, Oracle,  Squel Server and Sybase to give up their secrets.

Ray has said “I love nothing better than using VBA to unleash the power of Microsoft Office.” 
If you have a challenge with Excel, Access or Word and would like to speak with Ray,   You can get his contact details by clicking here: Contact Me

Leave a Reply

Close Menu

Excel and VBA Craftsman offers experienced VBA Development: Complete GUI Driven Applications, Automated Reconciliations, VBA ODBC Database Data Mining, VBA Excel, Access, Outlook and Word Customization. VBA Custom Functions, VBA Concept Assessment, VBA integration of MS office applications into powerful single seamless solutions, Excel Help, Automate Excel, Excel Automation