Recommended VBA resources
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 |
| basictutorials.in | Great information for new Excel users. |
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 |
| Very comprehensive list VBA terms with usage guidelines for each | |
| Spreadsheet flowchart addin tool | |
| Excel tip, trick and examples | |
| VBA programming tools. | |
| 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 |
|
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 |