Hire the Best VBA Developers
in South Africa

I have been designing databases using Microsoft Access, SQL, C#,, VB and VBA for the past 20 years and can create, customise or amend any Access or SQL/ MySQL database as well as develop front-end applications in .NET or Access. I have developed many databases for such a variety of industries. I have expert knowledge of Excel, Access and Word, including VBA. I have 20 years plus corporate experience in the financial industry using Excel and Access for data modelling and calculations as well as creating complicated Word templates - both for corporate identity and for purposes such as bulk mail merging from client databases. I develop SAGE ERP (Accpac) SQL integration using the Accpac API's within Accpac VBA as well as bespoke app development for SAGE Accpac using C#, VB.Net, VB.6.0 and Microsoft Access. I also have databases that connect directly to PASTEL and enable you to directly Email and SMS your clients from the database for bulk marketing campaigns. Other specialties include Excel financial modelling, automating PowerPoint reports from Excel data as well as creating corporate identities by creating Word templates, TRAINING: I can design customised Excel, Access, Word and PowerPoint training courses based on the needs of your business. With 28 years training experience under my belt, including many years of training needs analysis, it has been proven to me that creating customised training programs rather than sending staff on the standard scheduled course can increase the learning absorption by more than double! I have developed all sorts of courses for many corporate clients – in South Africa, the UK and in New Zealand. In order to make sure that any training down is specific to your needs I can: Identify the training need by means of a TNA (Training Needs Analysis questionnaire or direct questions to identify the specific training requirement). Design the customised course specific to the training need identified Schedule the training – either one-one-one or in small groups. Provide telephone support and backup once the training is complete. Computer Skills: SQL Server programming and administration C# and VB .Net programming Visual Basic 6.0 programming Access Database design & VBA programming Excel VBA programming & templates Word VBA macro programming & templates Microsoft Access – all versions Microsoft Excel – all versions Microsoft Word – all versions Microsoft PowerPoint – all versions Microsoft Outlook – all versions Training Skills: Training Needs Analysis Train the Trainer Microsoft Office (all levels, all versions including Word, Excel, PowerPoint, Outlook and Access) Visual Basic for Applications (Word, Excel, PowerPoint, Outlook and Access) Technical Writing Skills: Courseware (manuals and exercises) for all the above courses as per the MOS syllabuses set down by Microsoft. Instructor notes and reference manuals. Database technical manuals to accompany database projects. Database user manuals to accompany database projects. Training and Work Experience: I have been training delegates to use computers for the past 28 years. I have experience in teaching in South Africa, the United Kingdom and New Zealand and have taught learners from all walks of life. I have been creating database and software systems using VB.Net and SQL Server since 2000. More details of my work experience are available on request.

I am a professional Engineer with 20+ years of experience in solving client problems in the most optimal way. I am a PowerBI, Power Apps and Excel VBA macro programming guru and have a unique ability to turn complex, abstract concepts into understandable, relatable solutions.

I have a BSc (Honours) degree, with majors in Computer Science and Applied Mathematics. I have had Upwork Top Rated status for more than 5 years, Top Rated Plus status (great success with bigger clients and longer contracts) for more than 2 years. I have an Upwork Job Success Score that is still 100% after 57 jobs, 10,000+ hours and 10 years full-time. I am a Certified Microsoft Professional in the field of Data Science. I have real technical skills, such as Python, ML & Deep Learning, Power BI, Excel, Tableau, VBA, SQL, Mongo and PHP, and I am certainly not afraid of getting my hands dirty, but I also like (and am able) to operate on a higher level, to see a project or requirement through from concept to completion in the most elegant and efficient manner. 1. Data Science skills include: Python, Numpy, Pandas, scikit-learn, Matplotlib, Plotly, Power BI, Tableau, Excel and ElasticSearch. 2. My technical and programming skill-set includes Python, Django, Flask, VBA, Excel, Access, PHP, SQL, mySQL, Jquery, Javascript, JSON, Ajax, HTML and CSS. 3. Cloud infrastructure skills: AWS, Azure, GCP. 4. Database skills: SqlServer, MySQL, PostGresSQL, MongoDB, BigQuery. 5. PM and BI skills include Power BI (Microsoft Certified), DAX, Power Query, Tableau, MS Project, PowerApps, MS Flow, SharePoint and Trello. 6. Peripheral skills include, amongst others, Knime, Git, & Vim.. I have great people skills, a proven track record in effective project management, the ability to work in an unstructured environment and be self motivated, and good relationship building and writing skills. I have more than 20 years of experience in real world web & application development and project management. I believe in ethical business practice, and my commitment is to provide online applications and IT business solutions of the highest possible quality.

Are you tired of repetitive tasks bogging down your office? 😩 Do your employees need to cut down on admin work 📉 or improve team collaboration? 🤝 Do you need automation solutions implemented yesterday? 🚀 If so, we're tackling the same problem! I understand the frustration of repetitive tasks and the challenges of remote teamwork. With extensive experience in project management, I can help you streamline operations using the best tools available. Here’s how I can assist you: Tools I Use: Monday.com 📅 Airtable 📊 Make.com 🔄 Gsuite 📧 Salesforce 💼 Zapier ⚡ What I Offer: Automation Consultation: Identify and recommend the best automation tools for your specific needs. 💡 Platform Setup: Implement and configure online platforms like Monday.com. 🛠️ Team Training: Educate your team on automation benefits and usage in daily workflows. 📚 Workflow Optimization: Streamline processes to improve efficiency. 🏃‍♂️💨 Task Automation: Reduce repetitive tasks through effective automation solutions. 🔄 Dashboard Creation: Develop dashboards for real-time KPI tracking. 📈 User Access Management: Set up user access in compliance with privacy policies. 🔒 Process Automation: Automate any business process to enhance productivity. ⚙️ Why Choose Me: Expert Guidance: Leverage my knowledge of top-tier automation tools. 🌟 Comprehensive Solutions: From setup to training, I cover all aspects of automation. 📋 Customizable Support: Tailored solutions to meet your unique business needs. 🛠️ Let’s discuss how automation can transform your business. Contact me to schedule a call where I can demonstrate templates, use cases, and more. 📞💬