Skip Main Navigation
Page Content

Save This Event

Event Saved

Excel VBA and BlockChain Financial Applications Development

Westminster College, UK

Monday, 19 March 2018 at 10:00 - Friday, 23 March 2018 at 17:00 (GMT)

Excel VBA and BlockChain Financial Applications Develop...

Ticket Information

Ticket Type Sales End Price Fee Quantity
Excel VBA and BlockChain Financial Applications Development 25 Feb 2018 £3,145.00 £245.90

Share Excel VBA and BlockChain Financial Applications Development

Event Details

COURSE OVERVIEW

Visual Basic for Applications (VBA) is an object oriented programming language developed by Microsoft. VBA language has been integrated with Excel in order to have programming features which enables the developers to handle the data manipulation along with Excel function very easily. VBA is good for developing reporting systems in a capital markets environment and developing core business performance reporting etc.

WCC has been offering VBA courses since 1996. The course content has been changed over the years and is very much in line with demands and expectations of software developers in the corporate marketplace.

Our VBA programming course will teach you the relevant skills necessary for you to shine in the current job market in the financial industry for developing blockchain applications. This Training course will also teach you about BlockChain and how to apply blockchain technology in finance for Excel VBA developers, how to develop applications and test using Testenium. A blockchain is a public ledger of all bitcoin transactions that have ever been executed. A block is the “current” part of a blockchain which records some or all of the recent transactions, and once completed, goes into the blockchain as permanent database.


COURSE OBJECTIVES

At the end of the course the candidates will be able to

  • Create macros,
  • Understand and write VBA programming with program constructs,
  • Create user form, module (sub an functions) and classes,
  • Write program to import and export data between excel and databases,
  • Write program to handle outlook emails,
  • Use WorksheetFunctions in your applications,
  • Manipulate files and folders programmatically
  • Use relevant development theories to the technological strategies.
  • Use tools related to BlockChain
  • Design strategies for using BlockChain tools and
  • Develop and implement software platforms for BlockChain activities
  • Test your BlockChain Applications
  • Learn how to mine a coin
  • Use Testenium for testing BlockChain Applications


EXCEL VBA PROGRAMMING TRAINING

Course Content

  • Understanding Macros
  • The Visual Basic Editor
  • Excel VBA Fundamentals
  • Variables, Data types, and Constants
  • VBA Procedures: Sub routines and functions
  • Decision Making with VBA
  • Repeating Actions in VBA
  • Working with Arrays
  • Working with Collections


  • Manipulating Files and Folders with VBA
  • Controlling Other Applications with VBA
  • Using Excel with Microsoft Access


  • Dialog Boxes and Custom Forms
  • Creating Custom Menus and Toolbars with VBA
  • Event-Driven Programming


  • Exporting Data to Access Databases
  • Importing Data from Access Database
  • Connecting to Oracle / SQL Server databases
  • Reading data from Oracle/SQL Server databases
  • Exporting Excel Data to Remote Databases


  • Programming Pivot Tables and PivotCharts
  • Programming Special Features
  • Using and Programming Excel Lists
  • Programming the Visual Basic Editor


  • HTML Programming and Web Queries
  • Excel and ASP
  • Using VBA to send mail


  • Creating Class Library project
  • Writing Classes
  • Creating DDL/TLB files
  • Using DDL/TLB files in VBA

Querying the Blockchain

  • Block Explorer Public APIs
  • Querying Blockchain nodes
  • BlockChain Clients and web3j

BlockChain Security

  • Control structures in C#
  • Data Structures
  • Distributes Database applications
  • Object Oriented Programming in C#
  • IT security and secure coding
  • .NET security architecture and services
  • Practical cryptography
  • NET security architecture
  • Cryptographic vulnerabilities
  • RSA timing attack
  • Features and vulnerabilities
  • Denial of service
  • NETconfiguration and hardening
  • Common coding errors and vulnerabilities
  • Principles of security and secure coding
  • The protection of sensitive records and authentication of the identity of a user
  • Enhancing structural security of IoT devices
  • Securing internal communications
  • Making passwords obsolete
  • Prevention of identity theft
  • Protection against data tampering
  • Protection of critical infrastructure

Developing BlockChain Applications

  • Blockchain Wallets and Tokens
  • Using relevant Library
  • Dapps – Decentralized Applications
  • Setting up Ethereum Wallet and Development Environment
  • Introduction to smart contract and writing your first smart contract
  • Object and Inheritance
  • Understanding and writing Functions
  • Algorithm and Mathematical operations
  • Design and Build the application
  • Implementing the application
  • Using Testenium to testing BlockChain applications
Do you have questions about Excel VBA and BlockChain Financial Applications Development? Contact Westminster College, UK

Save This Event

Event Saved

When & Where


Westminster College
88 Kingsway
WC2B 6AA London
United Kingdom

Monday, 19 March 2018 at 10:00 - Friday, 23 March 2018 at 17:00 (GMT)


  Add to my calendar

Organiser

Westminster College, UK

Westminster College is  Central London's Top Professional IT training organisation. We're located in Central London, just next to Holborn tube station, and we offer over 100 courses across a wide range of IT subjects.  

  Contact the Organiser
Excel VBA and BlockChain Financial Applications Development
Things to do in London Course Business

Please log in or sign up

In order to purchase these tickets in installments, you'll need an Eventbrite account. Log in or sign up for a free account to continue.