How to Hire an Excel Expert First let me clarify Visual Basic for Applications (VBA) is an incredible powerful language and tool. In the right skilled hands, it can do magic. It can control not only Excel, Word, Outlook and Access it can, through the COM (common language interface), control and use many other programs […]
Budgeting, Savings and Investing to Build Wealth
In this post I am going to depart from my normal VBA based MS Office discussions to talk about a subject that is always relevant but, particularly so in these difficult times. I had a conversation about money with a college junior. I was surprised by the negativity and number of misconceptions he held regarding Budgeting, […]
Build a Subscriber Email List with MS Office
Build a Subscriber Email List Part I have had a website for over a year now, and much to my delight I have modest traffic, real traffic – for a long time it was crickets. It is gratifying -people are downloading my tools and no doubt improving them, it’s great -that was my plan all […]
Daily Business Checklist and Diary App
Smart Document Tool Daily Business Checklist and Diary App – Every Business has a list of things that need to get done if you are to stay in business and be successful. Those ‘checklists’ can vary widely and are bespoke to your individual business needs. For example, my Daily Business Checklist and Diary App starts […]
The Notion Tool
The Notion Tool facilitates Idea Capture and Development. Look up the word notion and you get: “A notion is an idea, often vague and sometimes fanciful. A notion is lighter than a theory and embraces a whimsy that a simple idea never could.” To me a notion is an idea in its infancy, undeveloped, perhaps […]
Excel Complexity, Speed, Overhead and Data
Excel Complexity, Speed, Overhead and Data As a Microsoft Office Developer, I can tell you there are some amazingly complex Excel Applications out there. For example: Did you know that new complex derivative products are often modeled, valued and perfected in Excel? That is because of the speed it can be accomplished. Provide a Quant […]
Building Resilient Microsoft Office Applications
Building Resilient Microsoft Office Applications Every Day Google the word Resilience and you will read “the process of adapting well in the face of adversity, trauma, tragedy, threats or significant sources of stress”. In the computing world Application resilience is the ability of an application to react to problems in one of its components and […]
SEO Challenges and Complexities
I love this job. As promised in My Entrepreneurial Life as a Microsoft Office VBA Freelancer Part I, I am going to do a bit of a dive into SEO challenges and complexities – For the newbies out there I will start with the basic key concepts. For those of you with some familiarity with SEO, […]
When to call in ‘Excel Help’? Ask yourself these five questions
When to call in “Expert Help’? Ask yourself these five questions When to call in ‘Excel Help’? Ask yourself these five questions As a Freelance Microsoft Office VBA Developer, I needed to have, as a friend says, “wicked mad computer skills” if I was to succeed. Yes, I’ve been a developer a long time though I’ll […]
My Entrepeneurial Life as a Microsoft VBA Freelancer Part II
I love my work as a Microsoft Office VBA Freelance Developer I wouldn’t have guessed the diversity of calls I get in My Entrepreneurial Life as a VBA Freelancer (Excel, Access and Word VBA Programming) Earlier this week I received a call from a very nice lady in another part of the country asking me to […]