{"id":7179,"date":"2014-01-08T15:05:21","date_gmt":"2014-01-08T15:05:21","guid":{"rendered":"https:\/\/www.financial-fluency.co.uk\/?page_id=7179"},"modified":"2015-06-09T21:38:49","modified_gmt":"2015-06-09T20:38:49","slug":"introduction-to-excel-vba","status":"publish","type":"page","link":"https:\/\/www.financial-fluency.co.uk\/financial-training-courses\/business-it-skills\/introduction-to-excel-vba\/","title":{"rendered":"Introduction to Excel VBA"},"content":{"rendered":"\"in-house\n

Excel VBA Introduction
\nIn-house Training Course<\/h2>\n

We deliver in-house courses in VBA (Visual Basic for Applications). Our VBAs courses can be tailored to meet individual requirements. We offer training in VBA from an introduction level through to an advanced level. <\/p>\n

The course outline below is for a one day introduction to VBA which has been popular with some of our clients. This course is designed to give enough knowledge of VBA for everyday users of excel, who can subsequently choose to pursue further if required.<\/p>\n

<\/a><\/p>\n

Contents of Introduction to Excel VBA<\/h3>\n

Please find example contents for a one day introduction to VBA course. This outline can be tailored and the course extended as required.<\/p>\n

Excel VBA, the fundamentals<\/strong>
\n\u2022\tWhat is VBA?
\n\u2022\tThe Visual Basic Editor
\n\"Training<\/a>
\nExcel macros and automation<\/strong>
\n\u2022\tMacro tools and the developer tab
\n\u2022\tRecording a set of tasks
\n\u2022\tPlayback and testing
\n\u2022\tDebugging<\/p>\n

Learning the VBA language<\/strong>
\n\u2022\tProcedures: interpreting the script
\n\u2022\tDeclaring variables
\n\u2022\tIntelliSense
\n\u2022\tCommon terms
\n\u2022\tVBA Objects<\/p>\n

Relative referencing<\/strong>
\n\u2022\tRecording with relative referencing
\n\u2022\tOffset and variable offset
\n\u2022\tJump selection<\/p>\n

Controlling objects, applications and macros<\/strong>
\n\u2022\tExecuting application open and shutdown
\n\u2022\tThe PivotTable Object
\n\"Introduction
\nIncorporating failsafe techniques<\/strong>
\n\u2022\tError handling
\n\u2022\tIF THEN ELSE statements
\n\u2022\tChecking cell contents<\/p>\n

Coding functions<\/strong>
\n\u2022\tUsing in-built functions
\n\u2022\tUser-defined functions (UDF)
\n\u2022\tVariable values
\n\u2022\tReplacing nested IF functions<\/p>\n

Building programs for end-users<\/strong>
\n\u2022\tMessage boxes\/screen prompts
\n\u2022\tInput boxes and declaring variables
\n\u2022\tProcessing user input
\n\u2022\tWorking with UserForms<\/p>\n

Security<\/strong>
\n\u2022\tMacro security settings
\n\u2022\tVBA project properties<\/p>\n

Introduction to Excel VBA Course Delivery<\/h3>\n

\"Spreadsheet<\/p>\n

We take an open friendly and enthusiastic approach to learning finance. We believe that people learn more effectively when they are enjoying themselves. We make finance interesting for you. We love questions and welcome as many as possible. <\/p>\n

We encourage an open atmosphere which in our experience accelerates the learning process. We always use lots of exercises, case studies and real life examples in our training as we believe this really helps our clients to understand concepts. <\/p>\n

We find that people only really learn when they test their understanding through practice. We offer traditional training, facilitation, interactive simulations, coaching and online training.<\/p>\n

Tailored Introduction to Excel VBA<\/h3>\n

All our courses are tailored to meet our client’s specific needs. We like to spend time getting to know our clients as we strongly believe that training is most effective and valuable when tailored and focused.
\n\"In-house<\/p>\n

In-house Introduction to Excel VBA<\/h3>\n

Our training can be held within your office or an external venue of your choice. <\/p>\n

We can also secure venues on your behalf through our venue sourcing agency.<\/p>\n

 
\n 
\n<\/a><\/p>\n

Make Enquiry or Book Now \"in-house<\/h2>\n
\n

<\/p>