Recommended VBA resources

< Back to home

< Back to development tips

DIY  vs  VBA Courses

You can learn almost everything with free online material however you may not learn the most effective way to do things and risk code running slow and getting errors.  Below are a list of recommended free VBA resources and courses. 

Do-It-yourself

  • Record macros > check code.  I have learnt so much over the years by recording a macro and then viewing the code.  This method is a very quick way to learn, particularly with formatting cells and shapes.
  • Google search "VBA + outcome you want".  Extensive blogs and code is available free online.  This is a great way to solve a specific query.
  • Press F2 in VBA to scan through objects and functions available.
  • You must become familiar with how to debug in VBA.  Something that many people do not realise is you can drag the yellow arrow in debug mode with your mouse to skip executing code.

Great free resources

excelkid.com If you want to create stunning excel dashboards read this tutorial.
exceldashboardschool.com If you want to create stunning excel dashboards you must read this tutorial.
exceltemplate.net  Great free Excel templates

 

Excel and VBA resources

 Click free excel add-ins here.

Website Name

Description

Add-ins.com Useful Excel addins
Advanced-excel.co.uk Excel training servcies
Advanced Excel and VBA Excel and VBA tips facebook page
Analyse-it.com Excel data analysis software
Analysisplace.com The “Excel-to-Word Document Automation Add-in” updates Word & PowerPoint content (text, tables, and charts) based on data and calculations in Excel. The add-in uses durable links that don’t break and eliminates repeated copy/paste from Excel.
Analystcave.com Excel tips addins and tricks
Andrewsexceltips.net Excel tips and tricks 
Appspro.com Excel examples and tips

Better solutions:  

Very comprehensive list VBA terms with usage guidelines for each

Breezetree.com

Spreadsheet flowchart addin tool

Chandoo.org

Excel tip, trick and examples

Codevba.com

VBA programming tools.

Computergaga.com

Excel training and tips. 
Computers tutsplus Guidelines to using Excel styles
Contextures.com  Excel tips, tutorials and support.
Digital.com Excel tutorials
Digdb.com Excel tips and add-ins
Gcfglobal Free Excel 2016 tutorials
Excel campus General Excel courses and useful articles.
Excel4business.com Excel automation for developing spreadsheets
Exceldemy.com Excel tips and guides.
Excelesquire.wordpress.com Excel tips for Lawyers
Excel for free lancers Excel facebook group for freelancers

Excel Jet

General Excel courses and useful articles.

Excelmacromastery.com Clear, concise, and complete VBA training.  Technical writing and instructions are of the highest standard so anyone can rapidly learn VBA.  Material is very well arranged and comprehensive.
Excel ribbon tips Excel tricks and tips
Excel Solutions (Facebook group) Excel tricks and tips
ExcelTricks (Facebook group) for Excel tips and tricks
Guru 99 - Excel Excel tutorials

Guru 99 - VBA

VBA tutorials

Homeandlearn.org Excel training
Icaew (blog) Developing spreadsheets effectively as a team
Learn Excel Group (Facebook group) Excel VBA tips
Learn Microsoft Excel (Facebook group) Excel discussion group
Ron De Bruin  Very specific advanced VBA guidelines, particularly around developing ribbons.  Thanks to some of his publicly available information it helped me develop this software.  Free code samples provided, very clever guy.
Smart sheet Useful Excel templates
Made in Excel (Facebook group) Excel discussion group
Microsoft guide Free guide to using Excel Effectively
My excel online Learn Excel from 500+ free step by step tutorials, podcast shows, webinars and online courses!
PC Mag (blog) Tips for creating professional looking spreadsheets
Small business Excel tips for small businesses
Tech republic (blog) Tips for creating professional looking spreadsheets
The balancesmb How to create accounting spreadsheets
Tomsguide Useful Excel shortcuts
Trump Excel General Excel courses and useful articles.
Vertex42 Useful Excel templates

 

 

< Back to home

< Back to development tips