{"id":17558,"date":"2020-03-23T18:22:38","date_gmt":"2020-03-23T18:22:38","guid":{"rendered":"https:\/\/www.financial-fluency.co.uk\/?page_id=17558"},"modified":"2020-03-23T18:22:38","modified_gmt":"2020-03-23T18:22:38","slug":"excel-vba-beginner-or-refresher-level","status":"publish","type":"page","link":"https:\/\/www.financial-fluency.co.uk\/online-learning\/spreadsheet-excel-skills\/excel-vba-beginner-or-refresher-level\/","title":{"rendered":"Excel VBA – Beginner or Refresher Level"},"content":{"rendered":"

\"Excel<\/p>\n

Online Course on
\nExcel Visual Basic for Applications<\/h2>\n

Visual Basic for Applications (VBA) is an implementation of Microsoft’s Visual Basic, an event driven programming language and associated integrated development environment (IDE) which is built into most Microsoft Office applications, such as Excel.
\n\"Online<\/p>\n

VBA is perfect for automating any time consuming repetitive tasks which you have to perform regularly within Excel. <\/p>\n

VBA can be used for a myraid of functions and other customisations you may wish to make. <\/p>\n

Put simply, VBA not only saves you time, it helps you to maximise your use of Excel.<\/p>\n

Financial professionals need to analyse and manipulate huge amounts of data. Excel’s VBA is perfect for data analysis and manipulation.<\/p>\n

Our online course in VBA will help you get to grips with VBA’s key functionality whether you are a beginner or simply need a refersher. Please see the course content below. <\/p>\n

 <\/p>\n

\"\"<\/a>\"buy<\/a>
\n <\/p>\n

Online VBA Course Content<\/h3>\n

Excel VBA, the fundamentals<\/strong>
\n\u2022\tWhat is VBA?
\n\u2022\tThe Visual Basic Editor
\n\"Online<\/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\"Excel
\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

Online VBA Course Format<\/h3>\n

Each of the above topics has been split into short vignettes. Our experienced and well regarded VBA course presenter will take you carefully through each of the topics one by one, allowing you to pause and rewind as needed. <\/p>\n

The course is supported with lots of worked examples. You will be able to follow our presenter through each topic and then test your understanding with subsequent examples.<\/p>\n

The course is delivered online and available through our portal 24\/7. Each licence comes with 3 months of free access, following purchase, so you can replay and repeat as many times as required.<\/p>\n

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

Make enquiry \/ Reserve a provisional place<\/h3>\n

Simply fill in the form below or contact us to find out more<\/a>.
\n

\n

<\/p>

    <\/ul><\/div>\n
    \n
    \n\n\n\n\n\n\n\n<\/div>\n

    Your Name (required)
    \n <\/span> <\/p>\n

    Your Email (required)
    \n <\/span> <\/p>\n

    Your Phone Number
    \n <\/span> <\/p>\n

    Your Message
    \n