[MARTIN GREEN'S OFFICE TIPS HOME]

Resources for Training

[Last Updated 16 April 2018]

Here you will find links to the files I use in my training courses, as well as handouts in PDF format that you can read online or download and print. All material here is my own and free for you to use as you wish. If you wish to share any of this material with others you are welcome to do so but please remember that I retain the copyright (2000-2018 Martin Green). Please acknowledge the source as appropriate.

My training material is subject to change occasionally and new items will be added here from time to time. If you cannot find what you are looking for you are welcome to contact me by email at martin@fontstuff.com.

If you would like to say thanks and make a small donation to help support this site please click the PayPal Donate button below. You can donate any amount in any currency you choose. It's easy and only takes a moment. Thank you.

Microsoft Excel

HANDOUTS
View or download individual handouts in PDF Format:

Introducing the Program.pdf [310KB]
Building Spreadsheets.pdf [463KB]
Building Charts.pdf [657KB]
Keyboard Shortcuts for Excel.pdf [217KB]
Sorting Data.pdf [230KB]
Filtering Data.pdf [282KB]
IF Functions.pdf [206KB]
Lookup Functions.pdf [148KB]
Summarizing Data with Functions.pdf [90KB]
Data Validation.pdf [389KB]
Conditional Formatting.pdf [402KB]
More Conditional Formatting.pdf [283KB]
The PMT Function.pdf [116KB]
Goal Seek.pdf [112KB]
Data Tables.pdf [190KB]

Download all the above in a single ZIP file:

Microsoft Excel Handouts.zip [3.66MB]

Microsoft Excel VBA

HANDOUTS
View or download individual handouts in PDF Format:

Microsoft Excel VBA - Build a UserForm for Excel.pdf [369KB]
Microsoft Excel VBA - Building and Excel Add-In.pdf [319KB]
Microsoft Excel VBA - Building Custom Functions.pdf [308KB]
Microsoft Excel VBA - Install an Excel Add-In.pdf  [155KB]
Microsoft Excel VBA - Recording Excel Macros.pdf [196KB]
Microsoft Excel VBA - Worksheet Command Buttons.pdf [241KB]

Download all the above in a single ZIP file:

Microsoft Excel VBA Handouts.zip [1.44MB]

SAMPLE FILES
Download sample files:

Custom Functions.xlsm [20KB]
Excel AddIns.xlsm [27KB]
Handling Errors [21KB]
Macros 1 - Recorded Macro Data (Fill Empty Cells).xlsx [18KB]
Macros 2 - Recorded Macro Data (Relative or Absolute).xlsx [66KB]
Macros 3 - Custom Function Data (Test Scores, Age).xlsx [15KB]
User Forms.xlsm [23KB]

All of the above sample files are contaied in this ZIP folder...

Excel VBA Sample Files.zip [143KB]

Microsoft VBA

HANDOUTS
The following refer to topics common to all of VBA (Excel, Word, PowerPoint etc.):

VBA Code Loops.pdf [101KB]
VBA Conditional Code.pdf [65KB]
VBA Message Boxes.pdf [142KB]
VBA UserForm Code Reference.pdf [105KB]

Download all of the above in a single ZIP file:

Microsoft VBA Handouts.zip [381KB]

SAMPLE FILES
Download the sample files:

VBA Demos - Code Loops.xlsm [41KB]
VBA Demos - Message Boxes.xlsm [22KB]
VBA Demos UserForms [23KB]

All of the above sample files are contaied in this ZIP folder...

Microsoft VBA Sample Files.zip [73KB]

Microsoft VBA eBooks

Each of these eBooks provides a comprehensive guide to a particular topic in VBA. They were previously sold on my web site, I am now offering the completely free of charge. In PDF format, they are fully searchable and printable.

The Visual Basic Editor [PDF - 69 pages - 1.2MB]

VBA Message and Input Boxes [PDF - 61 pages - 1.0MB]