Training Options During the COVID-19 Pandemic
COVID-19: Whilst the COVID-19, Coronavirus emergency lasts, online, remote training provides a safe way for businesses to train their staff. Whether you are employed, self-employed or just looking to update your skills, we are here to help.
Business Enquiries - Closed, Private Courses
For closed, private courses suitable for businesses with one or members of staff who need training, please see our Microsoft Office remote training information page which will explain all you need to know about our virtual Microsoft Excel classroom.
Individual Enquires - Public, Scheduled Courses
For open, publically scheduled courses, please see our scheduled remote Microsoft Excel training courses.
Our training courses can be delivered in-house at your offices or remotely online. Please note the outline can be tailored - nothing is set in stone! Our two day Excel VBA & Macro training course gives delegates a good introduction to recorded macros and VBA programming. The course is designed for advanced Excel users who need to develop automated solutions.
Our courses are compatible with any version of Excel including Excel 2019 (Office 365), 2016, 2013, 2010 and 2007.
We also offer help with spreadsheet design. Make your spreadsheets more efficient and easier to use with a little bit of help from us. Email us at info@bluepecan.co.uk for a quote.
Pricing
COVID-19: Whilst the COVID-19, coronavirus emergency lasts, online, remote training provides a safe way for businesses to train their staff. Whether you are employed, self-employed or just looking to update your skills, we are here to help. Please see our pricing for remote training here.
Publicly scheduled courses
From £150 inc vat – price per person / delegate per day course
In-house training prices
Instructor Led Training via Zoom, Webex etc
One-to-one training
Half-day session – £195 plus vat
Full-day session – £350 plus vat
Group training
Half-day session – £295 plus vat
Full-day session – £550 plus vat
Shorter one-to-one sessions
Charged at £75 plus vat per hour
Onsite Pricing (Per Group) – Day Rates
Full-day session – £595 plus vat.
Group Size
We recommend group sizes no larger than 5 for online training and 10 for onsite training, but are happy to accommodate your requirement.
Our 2 day Microsoft Excel Macros and Visual Basic for Applications (VBA) course is aimed at those who need gain a good grounding in this programming language. Download the course outline in pdf format.
- Recording a Macro
- Recording a Macro Using Relative References
- Useful Navigation and Selection Shortcut Keys to Use When Recording Macros
- Recording Techniques For Macros That Need to Work Regardless of the Number of Columns or Rows
- Editing a Recorded Macro in the VBA Editor
- Saving Macro Enabled Excel files
- Where to Store Macros
- Macro Security
- Customising the Quick Access Toolbar and Ribbon with Macro Buttons
- Adding Form Buttons to a Sheet
- What is VBA?
- Understanding Parts of Speech: Objects, Collections, Methods, Parameters and Properties
- Application Methods and Properties
- Window/s Methods and Properties
- Workbook/s Methods and Properties
- Worksheet/s Methods and Properties
- Range Methods and Properties
- Chart/s Methods and Properties
- Referencing Cells/Ranges
- CurrentRegion
- The End Property
- Offset
- Resize
- Intersect
- UsedRange
- SpecialCells
- Areas
- Rows and Columns
- Copy/Move
- Formatting Cells and Values
- Activate Worksheet
- Create New Worksheet
- Delete a Worksheet
- Name a Worksheet
- Copy/Move Worksheet
- Group Worksheets
- Hide Worksheets
- Protect Worksheets
- Open/Close Workbook
- Save Workbook
- Delete Workbook
- Protect Workbook
- Add Named Reference Within a Workbook
- Create an Embedded Chart
- Delete a Chart
- Create a Chart On a Chart Sheet
- Apply Chart Style
- Colour a Chart
- Position and Size a Chart
- Add Titles and Other Chart Elements
- Naming Variables
- Declaring a Variable’s Data Type
- Option Explicit
- Scoping Variables
- Local
- Module-wide
- Public
- Static Variables
- Life of a Variable
- Assigning Values to Variables and Object Variables
- Constants
- If Then Else, ElseIf
- Select Case
- For Each Next – Looping Through Workbooks, Worksheets & Ranges
- For Next Loops
- Do Loops – Do Until, Do While, Exit Do
- Workbook Events
- Worksheet Events
- OnKey Events
- MsgBox
- InputBox
- Application.InputBox
- Designing Userforms
- Worksheet Functions
- VBA Functions
- User Defined Functions
- Types of Errors
- Syntax Errors
- Compile Errors
- Run-time Errors
- Stepping Through Code
- Setting Breakpoints
- Using the Immediate Window
- Setting Watches and Using the Watch Window
- Using the Locals Window
- Error Trapping and Handling
- On Error Resume Next
- On Error Goto
- Specifying Error Handling for Different Run-time Error Numbers