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.
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
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
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, 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