1646 Courses in Cardiff delivered Online

Gain a thorough grasp of time series analysis and its effects, as well as practical tips on how to apply machine learning methods and build RNNs. Learn to train RNNs efficiently while taking crucial concepts such as overfitting and underfitting into account. The course offers a useful, hands-on manner for learning Python methods and principles.

Duration 4 Days 24 CPD hours This course is intended for Technical professionals with basic system administration skills and operators responsible for managing virtual machines using VMware ESXi™ and VMware vCenter Server Overview By the end of the course, you should be able to meet the following objectives: Describe virtualization and virtual machines Describe vSphere components and the software-defined data center (SDDC) Explain the concepts of server, network, and storage virtualization Monitor network and datastore configurations in VMware vSphere Client™ Deploy, configure, and clone virtual machines Migrate, monitor, and manage virtual machines Monitor tasks and events in VMware vSphere Client™ Recognize how vSphere DRS and VMware vSphere High Availability improve performance and availability of a vSphere cluster This three-day, hands-on training course is an introduction to VMware vSphere©. In this course, you acquire the skills needed to perform Day 2 operational tasks that are typically assigned to the roles of operator or junior administrator in a vSphere environment. Course Introduction Introductions and course logistics Course objectives Virtualization and vSphere Concepts Describe how virtual machines (VMs) work Recognize the purpose of a hypervisor Describe how VMs share resources in a virtualized environment Recognize the components of an SDDC Describe the relationship between vSphere, the SDDC, and cloud computing Recognize the functions of the components in a vSphere environment Access and view vSphere graphical user interfaces Identify VMware solutions that integrate with vSphere in the SDDC Navigating the vSphere Client View and organize the inventory objects managed by vCenter Server Add and assign vSphere licenses Change the log level of vCenter Server Edit the startup policy of ESXi services Describe how vCenter Server roles and permissions work Add permissions to virtual machines Lifecycle of Virtual Machines Add and remove VM virtual hardware components Identify the purpose of different VM files Configure VM settings Create and delete virtual machines Recognize the benefits of installing VMware Tools? Install VMware Tools into a guest operating system Upgrade VMware Tools and VM hardware compatibility vSphere Networking Describe virtual networking Recognize ways that virtual switches connect VMs and ESXi hosts to the network View components and properties of a vSphere standard switch configuration View a vSphere distributed switch configuration in vSphere Client Recognize when and how to use the settings for the security networking policy Recognize when and how to use the settings for the traffic shaping networking policy Describe how the NIC teaming and failover policy helps maintain network connectivity Perform basic checks to diagnose VM connectivity issues vSphere Storage Describe the function of a datastore Recognize types of vSphere datastores View datastore information in vSphere Client Monitor datastore usage in vSphere Client Virtual Machine Management Recognize the benefits of using VM templates Create and update a VM template Deploy a VM from an existing template Clone a virtual machine Recognize how to use guest OS customization specifications Deploy VMs from a content library Deploy a virtual appliance from an OVF template Perform a hot and cold migrations of VMs Identify requirements for using VMware vSphere© Storage vMotion© Perform a vSphere Storage vMotion migration Identify use cases for VM snapshots Create and manage snapshots of a virtual machine Resource Monitoring Recognize the purpose of each type of VM resource control Configure the resource allocation settings of a VM Observe the behavior of virtual machines with different share values Manage and acknowledge vSphere alarms Use performance charts to monitor VM CPU and memory usage Monitor tasks and events in vSphere Client vSphere Clusters View information about the services that a vSphere cluster offers Recognize how vSphere HA responds to different types of failures Monitor vSphere HA during a host failure Describe how vSphere DRS works Interpret DRS scores given to VMs Recognize how to apply the appropriate vSphere DRS automation and migration threshold levels Describe how vSphere Fault Tolerance works Recognize how Enhanced vMotion Compatibility works Additional course details:Notes Delivery by TDSynex, Exit Certified and New Horizons an VMware Authorised Training Centre (VATC) Nexus Humans VMware Data Center Virtualization: Core Technical Skills training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success. While we feel this is the best course for the VMware Data Center Virtualization: Core Technical Skills course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you. Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.

Duration 5 Days 30 CPD hours This course is intended for This hands-on course is geared for experienced DBAs new to Oracle 19c, who can work in Linux and have basic experience with SQL scripting. Overview This course combines expert lecture, real-world demonstrations and group discussions with machine-based practical labs and exercises. Working in a hands-on learning environment led by our Oracle Certified expert facilitator, students will learn how to: How to use tools to access an Oracle Database Generate database creation scripts by using DBCA How to create a container database (CDB) by using the CREATE DATABASE command Learn about Startup and shut down Oracle databases Initialization parameter files and initialization parameters Tools that are used to administer Oracle Net Services How to use the Oracle Connection Manager Control utility to administer Oracle Connection Manager How to create a new PDB from the PDB seed. Logical and physical storage structures in an Oracle database Usage of Oracle Database features that save space Explanation of DML and undo data generation Learn about general architecture of Oracle Data Pump and SQL*Loader How to use SQL*Loader to load data from a non-Oracle database (or user files) Bonus Content / Time Permitting: Explanation of maintenance windows Bonus Content / Time Permitting: Employ basic monitoring procedures and manage performance Oracle 19C Database Administration I (Oracle DBA I) is a comprehensive, hands-on course provides concrete information on the design of an Oracle Database instance and database, allowing you to manage your database investment. In this class, you will learn how to create database storage structures that align with your requirements and business models. You will also learn how to create users and administer databases as well as harden the databases to meet your business requirements. This is the foundational course for learning about Oracle Database and it does not assume prior knowledge or Oracle technologies, however you should have incoming experience working with SQL, and be comfortable with Linux and working from the command line. This training is NOT Official Oracle University training. This is independent, adjustable content that aligns with current topics, skills and tools that participants need to excel in these areas. Introduction to Oracle Database Oracle Multitenant Container Database Oracle Database Instance Configurations Database Sharding Oracle Database Server Accessing an Oracle Database Oracle Database Tools Database Tool Choices SQL Developer Enterprise Manager Database Express Creating an Oracle Database by Using DBCA Planning the Database Choosing a Database Template Configuration Assistant Creating an Oracle Database by Using a SQL Command Creating a Container Database Enable Pluggable Database Starting Up and Shutting Down a Database Instance Starting the Oracle Database Instance Shutting Down an Oracle Database Instance Opening and Closing PDBs Managing Database Instances Investigating Initialization Parameter Files Viewing Initialization Parameters by Using SQL*Plus Modifying Initialization Parameters by Using SQL*Plus Viewing Diagnostic Information Oracle Net Services Overview Oracle Net Services Components Oracle Net Listener Configuring Naming Methods Configuring the Oracle Network to Access a Database Creating a Net Service Name for a PDB Configuring and Administering the Listener Exploring the Default Listener Creating a Second Listener Connecting to a Database Service Using the New Listener Configuring a Shared Server Architecture Configuring Shared Server Mode Configuring Clients to Use a Shared Server Configuring Oracle Connection Manager for Multiplexing and Access Control Oracle Connection Manager Processes Filtering Rules Session Multiplexing Creating PDBs Creating a New PDB from the PDB Seed Cloning Remote PDBs in Hot Mode Relocating PDBs Managing PDBs Renaming a PDB Setting Parameter Values for PDBs Database Storage Overview Logical and Physical Database Structures Tablespaces and Data Files Types of Segments Monitoring Tablespace Space Usage Creating and Managing Tablespaces Viewing Tablespace Information Creating a Tablespace Managing Temporary and Permanent Tablespaces Improving Space Usage Managing Space in Tablespaces Using Compression Enabling the Resumable Space Allocation Feature Creating and Managing User Accounts Creating Common and Local Users Creating a Local User for an Application Exploring OS and Password File Authentication Configuring Privilege and Role Authorization Granting a Local Role (DBA) to PDBADMIN Using SQL*Developer to Create Local Roles Configuring User Resource Limits Using SQL*Developer to Create a Local Profile & Users Configuring a Default Role for a User Implementing Oracle Database Auditing Enabling Unified Auditing Creating Audit Users Creating an Audit Policy Introduction to Loading and Transporting Data General Architecture Oracle Data Pump SQL Loader Loading Data into a PDB from an External File Moving Data from One PDB to Another PDB Transporting a Tablespace Using External Tables to Load and Transport Data Querying External Tables Unloading External Tables Automated Maintenance Tasks Overview Automated Maintenance Tasks Maintenance Windows Predefined Maintenance Windows Bonus: Managing Tasks and Windows Enabling and Disabling Automated Maintenance Tasks Modifying the Duration of a Maintenance Window Bonus: Database Monitoring and Performance Tuning Overview Performance Planning Considerations Automatic Workload Repository (AWR) Advisory Framework Bonus: Monitoring Database Performance & Processes Server-Generated Alerts Setting Metric Thresholds Performance Monitoring Examining the Database Background Processes Bonus: Tuning Database Memory Viewing Memory Configurations Bonus: Analyzing SQL and Optimizing Access Paths Using the Optimizer Statistics Advisor

Overview Uplift Your Career & Skill Up to Your Dream Job - Learning Simplified From Home! Kickstart your career & boost your employability by helping you discover your skills, talents and interests with our special Internet of Things (IoT) Course. You'll create a pathway to your ideal job as this course is designed to uplift your career in the relevant industry. It provides professional training that employers are looking for in today's workplaces. The Internet of Things (IoT) Course is one of the most prestigious training offered at StudyHub and is highly valued by employers for good reason. This Internet of Things (IoT) Course has been designed by industry experts to provide our learners with the best learning experience possible to increase their understanding of their chosen field. This Internet of Things (IoT) Course, like every one of Study Hub's courses, is meticulously developed and well researched. Every one of the topics is divided into elementary modules, allowing our students to grasp each lesson quickly. At StudyHub, we don't just offer courses; we also provide a valuable teaching process. When you buy a course from StudyHub, you get unlimited Lifetime access with 24/7 dedicated tutor support. Why buy this Internet of Things (IoT)? Unlimited access to the course for forever Digital Certificate, Transcript, student ID all included in the price Absolutely no hidden fees Directly receive CPD accredited qualifications after course completion Receive one to one assistance on every weekday from professionals Immediately receive the PDF certificate after passing Receive the original copies of your certificate and transcript on the next working day Easily learn the skills and knowledge from the comfort of your home Certification After studying the course materials of the Internet of Things (IoT) there will be a written assignment test which you can take either during or at the end of the course. After successfully passing the test you will be able to claim the pdf certificate for £5.99. Original Hard Copy certificates need to be ordered at an additional cost of £9.60. Who is this course for? This Internet of Things (IoT) course is ideal for Students Recent graduates Job Seekers Anyone interested in this topic People already working in the relevant fields and want to polish their knowledge and skill. Prerequisites This Internet of Things (IoT) does not require you to have any prior qualifications or experience. You can just enrol and start learning.This Internet of Things (IoT) was made by professionals and it is compatible with all PC's, Mac's, tablets and smartphones. You will be able to access the course from anywhere at any time as long as you have a good enough internet connection. Career path As this course comes with multiple courses included as bonus, you will be able to pursue multiple occupations. This Internet of Things (IoT) is a great way for you to gain multiple skills from the comfort of your home. Course Curriculum Course Agenda Module 01: Introduction 00:02:00 Module 02: Course Agenda 00:03:00 Unit 01: Introduction Module 01: Introduction to Internet of Things 00:13:00 Module 02: Choosing Cloud Services for IoT 00:05:00 Module 03: What is Raspberry Pi Part 1? 00:09:00 Module 04: What is Raspberry Pi Part 2? 00:06:00 Unit 02: Raspberry Pi Installation Module 01: Downloading OS for Raspberry Pi Noobs-Raspbian 00:07:00 Module 02: Install OS using NOOBS 00:11:00 Module 03: Remote Control of Raspberry Pi Using VNC Viewer 00:10:00 Module 04: Install OS using Raspbian Image part 1 00:06:00 Module 05: Install OS using Raspbian Image part 2 00:02:00 Unit 03: Getting Around Raspberry Pi Module 01: Getting Around Raspbian Operating System part 1 00:10:00 Module 02: Getting around Raspbian Operating System part 2 00:08:00 Module 03: Getting around Raspbian Operating System part 3 00:06:00 Module 04: How To Run Python program On Raspberry Pi 00:09:00 Unit 04: Raspberry Pi GPIO Output Module 01: Raspberry PI GPIO Concepts 00:07:00 Module 02: Raspberry Pi GPIO Interfacing Single LED 00:17:00 Module 03: Raspberry Pi GPIO Interfacing Multiple LED's 00:09:00 Module 04: Rapberry Pi GPIO Interfacing Buzzer 00:03:00 Unit 05: Output from Raspberry Pi Module 01: Raspberry Pi and Transistorized Switching 00:09:00 Module 02: Raspberry Pi and Relay part 1 00:13:00 Module 03: Raspberry Pi and Relay part 2 00:08:00 Unit 06: Inputs to Raspberry Pi Module 01: Accepting Digital Input on Raspberry Pi Part 1 00:13:00 Module 02: Accepting Digital Inputs on Raspberry Pi Part 2 00:07:00 Unit 07: Sensor Interfacing Module 01: Sensor Interfacing With Raspberry Pi LDR1 00:05:00 Module 02: Sensor Interfacing With Raspberry Pi LDR 2 00:10:00 Module 03: Sensor Interfacing With Raspberry Pi LDR 3 00:07:00 Module 04: Sensor Interfacing with Rapberry Pi DHTT11 part 1 00:10:00 Module 05: Sensor Interfacing with Rapberry Pi DHTT11 part 2 00:10:00 Module 06: Sensor Interfacing with Raspberry pi Using SenseHAT 00:11:00 Module 07: Ultrasonic Sensor Interfacing with Raspberry Pi 00:14:00 Unit 08: Interfacing of I2C Based BMP180 Sensor with Raspberry Pi Module 01: BMP180 with Raspberry Pi 00:07:00 Module 02: Enabling I2C on Raspberry Pi 00:05:00 Module 03: BMP180 Python Code 00:06:00 Unit 09: Internet of Things with Microsoft Azure Module 01: Getting Started With IoT 00:11:00 Module 02: Getting Started with Microsoft Azure IoT Hub Part 1 00:04:00 Module 03: Getting Started with Microsoft Azure IoT Hub Part 2 00:05:00 Module 04: Getting Started with Microsoft Azure IoT Hub Part 3 00:09:00 Module 05: Create Device inside Azure IoT Hub 00:06:00 Module 06: Enable Azure Cloud Shell and enable IoT Extension 00:08:00 Module 07: Send Data to Azure IoT Hub Using Python Program 00:09:00 Module 08: Send Actual Temperature and Humidity Values to Azure IoT hub 00:03:00 Module 09: Storing the Data on Microsoft Azure Using Custom Gateway 00:13:00 Module 10: Save data to blob storage using Stream Analytics Job 00:12:00 Module 11: Data Visualization with Power BI Part 1 00:07:00 Module 12: Data Visualization with Power BI Part 2 00:12:00 Module 13: Creating Custom web app with azure for data visualization Part 1 00:10:00 Module 14: Creating Custom web app with azure for data visualization Part 2 00:14:00 Module 15: Creating Custom web app with azure for data visualization Part 3 00:12:00 Module 16: Dealing with password error while pushing your webapp to azure 00:01:00 Module 17: Cleaning up Azure Resources 00:02:00 Module 18: Remote Monitoring using Azure Logic App Part 1 00:12:00 Module 19: Remote Monitoring using Azure Logic App Part 2 00:10:00 Unit 10: IoT with Thingspeak Module 01: Introduction to Thingspeak 00:06:00 Module 02: Create an account and send data to Thingspeak 00:08:00 Unit 11: Learn a new platform, Adafruit IO Module 01: Getting started with SaaS IoT Platform io.adafruit.com 00:08:00 Module 02: What is MQTT? 00:10:00 Module 03: Sending Data to Adafruit Io Using MQTT Part 1 00:17:00 Module 04: Sending Data to Adafruit io Using MQTT part 2 00:14:00 Module 05: Home automation project with adafruit IO Part 1 00:15:00 Module 06: Home Automation Project with Adafruit IO Part 2 00:02:00 Unit 12: IOT Security Module 01: IoT Security 00:14:00 Module 02: Conclusion 00:01:00 Assignment Assignment - Internet of Things (IoT) 00:00:00

This is a comprehensive course designed to provide a solid foundation in web development principles and practices. This course is intentionally structured to provide a technical understanding of web development concepts without delving into intricate implementation details. Anyone looking to better understand how web applications are built can take this course.

Helping customers buy products or services from retail organisations such as department stores, garden centres, high street chains, supermarkets and online and mail order businesses.

Managing the movement of goods across all sectors and distances for a range of customers from private individuals and sole traders through to large global organisations.

Visual Studio Code is currently the number #1 IDE among the programmer's community. All the big companies are moving towards using VS Code for active development. Get ahead of the curve and learn to use Visual Studio Code with ease.

Python Programming: Beginner To Expert Overview Unfold the potential within you, and embark on a journey of mastering Python programming - from the fundamental building blocks to the pinnacle of expertise. This comprehensive course, crafted with meticulous care, empowers you to transform from a curious novice to a confident coding maestro, wielding Python's power with finesse. Within these engaging modules, you'll delve into the core principles of Python, meticulously exploring data types, operators, control flow, and functions. As your proficiency blossoms, you'll conquer advanced topics like object-oriented programming, powerful libraries like NumPy and Pandas, and the art of crafting polished scripts. But this journey isn't merely about acquiring technical prowess; it's about unlocking a world of possibilities. By the course's end, you'll be equipped to embark on a rewarding career path, armed with the skills to tackle real-world challenges in diverse domains - from data analysis and web development to scientific computing and automation. Learning Outcomes Gain a solid foundation in Python syntax, data structures, and control flow mechanisms. Master essential functions, user input, and error-handling techniques. Explore advanced data types, object-oriented programming concepts, and popular libraries like NumPy and Pandas. Craft polished, reusable Python scripts for various applications. Confidently navigate the Python ecosystem and continuously expand your knowledge. Why You Should Choose Python Programming: Beginner To Expert Lifetime access to the course No hidden fees or exam charges CPD Accredited certification on successful completion Full Tutor support on weekdays (Monday - Friday) Efficient exam system, assessment and instant results Download Printable PDF certificate immediately after completion Obtain the original print copy of your certificate, dispatch the next working day for as little as £9. Improve your chance of gaining professional skills and better earning potential. Who is this Course for? Python Programming: Beginner To Expert is CPD certified and IAO accredited. This makes it perfect for anyone trying to learn potential professional skills. As there is no experience and qualification required for this course, it is available for all students from any academic backgrounds. Requirements Our Python Programming: Beginner To Expert is fully compatible with any kind of device. Whether you are using Windows computer, Mac, smartphones or tablets, you will get the same experience while learning. Besides that, you will be able to access the course with any kind of internet connection from anywhere at any time without any kind of limitation. Career Path You will be ready to enter the relevant job market after completing this course. You will be able to gain necessary knowledge and skills required to succeed in this sector. All our Diplomas' are CPD and IAO accredited so you will be able to stand out in the crowd by adding our qualifications to your CV and Resume. Python Programming: Beginner To Expert Module 01: Introduction to Python Programming from A-Z Intro To Python Section Overview 00:06:00 What is Python Programming? 00:10:00 Who is This Course For? 00:05:00 Python Programming Marketplace 00:06:00 Python Job Opportunities 00:05:00 How To Land a Python Job Without a Degree 00:08:00 Python Programmer Job Roles 00:09:00 Python from A-Z Course Structure 00:04:00 Module 02: Getting Familiar with Python Getting Familiar with Python Section Overview 00:06:00 Installing Python on Windows 00:10:00 Anaconda and Jupyter Notebooks Part 1 00:08:00 Anaconda and Jupyter Notebooks Part 2 00:16:00 Comments 00:05:00 Python Syntax 00:02:00 Line Structure 00:03:00 Line Structure Exercise 00:07:00 Joining Lines 00:05:00 Multiple Statements on a Single Line 00:05:00 Indentation 00:08:00 Module 03: Basic Data Types Basic Data Types Section Overview 00:08:00 String Overview 00:10:00 String Manipulation 00:07:00 String Indexing 00:04:00 String Slicing 00:08:00 Printing 00:10:00 Python Variables 00:08:00 Integers and Floats 00:08:00 Booleans 00:02:00 Mini Project 1 : Letter Counter 00:20:00 Module 04: Python Operators Python Operators Section Overview 00:04:00 Comparison Operators 00:09:00 Arithmetic Operators 00:08:00 Assignment Operators 00:05:00 Logical Operators 00:13:00 Identity Operators 00:05:00 Membership Operators 00:02:00 Bitwise Operators 00:08:00 Module 05: Advanced Data Types Python Advanced Data Types Section Overview 00:11:00 Sets 00:06:00 List Overview 00:05:00 List Slicing and Indexing 00:04:00 Tuples 00:02:00 Dictionaries 00:11:00 When to use each one? 00:05:00 Compound Data Types 00:03:00 Module 06: Control Flow Part 1 Control Flow Part 1 Section Overview 00:15:00 Intro to Control Flow 00:01:00 Basic Conditional Statements 00:14:00 More Conditional Statements 00:05:00 For Loops 00:10:00 While Loops 00:12:00 Module 07: Control Flow Part 2 Control Flow Part 2 Section Overview 00:02:00 Break Statements 00:08:00 Continue Statements 00:05:00 Zip Function 00:07:00 Enumerate Function 00:04:00 List Comprehension 00:04:00 Module 08: Python Functions Python Functions Section Overview 00:03:00 Intro to Functions 00:02:00 Python help Function 00:03:00 Defining Functions 00:09:00 Variable Scope 00:08:00 Doc Strings 00:04:00 Module 09: User Input and Error Handling User Input and Error Handling Section Overview 00:02:00 Introduction to error handling 00:03:00 User Input 00:04:00 Syntax Errors 00:04:00 Exceptions 00:11:00 Handling Exceptions Part 1 00:08:00 Handling Exceptions Part 2 00:08:00 Module 10: Python Advanced Functions Python Advanced Functions Section Overview 00:05:00 Lambda Functions 00:05:00 Functions args and kwargs 00:10:00 Iterators 00:08:00 Generators and Yield 00:12:00 Map Function 00:14:00 Filter Function 00:08:00 Module 11: Python Scripting and Libraries Python Scripting and Libraries Section Overview 00:05:00 What is a script? 00:01:00 What is an IDE? 00:17:00 What is a text editor? 00:12:00 From Jupyter Notebook to VScode Part 1 00:15:00 From Jupyter Notebook to VScode Part 2 00:05:00 Importing Scripts 00:03:00 Standard Libraries 00:04:00 Third Party Libraries 00:06:00 Module 12: NumPy NumPy Section Overview 00:04:00 Why use NumPy? 00:04:00 NumPy Arrays 00:10:00 Reshaping, Accessing, and Modifying 00:07:00 Slicing and Copying 00:06:00 Inserting, Appending, and Deleting 00:10:00 Array Logical Indexing 00:04:00 Broadcasting 00:08:00 Module 13: Pandas Intro to Pandas 00:17:00 Pandas Series 00:17:00 Pandas Series Manipulation 00:17:00 Pandas DataFrame 00:17:00 Pandas DataFrame Manipulation 00:13:00 Dealing with Missing Values 00:10:00 Module 14: Introduction to OOP Functional vs OOP 00:06:00 OOP Key Definitions 00:04:00 Create your First Class 00:12:00 How to Create and Use Objects 00:06:00 How to Modify Attributes 00:12:00 Module 15: Advanced OOP Python Decorators 00:27:00 Property Decorator 00:09:00 Class Method Decorator 00:07:00 Static Methods 00:10:00 Inheritance from A to Z 00:21:00 Module 16: Starting a Career in Python Getting Started with Freelancing 00:09:00 Building A Brand 00:12:00 Personal Branding 00:13:00 Importance of Having Website/Blog 00:04:00 Do's and Don'ts of Networking 00:06:00 Creating A Python Developer Resume 00:06:00

Following on from the Macros course look at how you can write your own Visual Basic code within Excel to fully automate tasks and save time. Course overview Duration: 2 days (13 hours) Our VBA in Excel course is an introduction to using the Visual Basic for Applications language for programming in Excel. It looks at structures, syntax and coding standards. This course is designed for existing experienced users of Excel who can record and run macros and those who have dabbled in VBA but would like some formal training and help to put some structure to their code. Objectives  By the end of the course you will be able to: Write visual basic procedures Create event and general procedures Use commands from the Excel data model Use statements and functions Use a selection of debugging tools Create and use variables and constants Use different types of loops Create an Excel user form Content The VBA environment Project explorer Excel objects Modules Properties window Code window Code structure Code structure Navigating within your code Adding comments Using WITH Steps to creating a VBA procedure Procedures Sub procedures Event procedures Calling procedures The Excel data model Workbook commands Worksheet commands Excel selection methods Data manipulation commands Debugging Using breakpoints Stepping through code The immediate window The watch window The locals window points Variables and Constants Declaring variables Declaring multiple variables Variable data types Concatenation Scope of variables Constants Declaring constants Using constants Scope of constants Looping Do while loops Do until loops For next loops Conditional Statements IF statement SELECT CASE statement Comparison statements Logical operators Creating a User Form Form layout The control toolbox Naming conventions Adding objects Naming objects Captions Displaying the form Object properties Object properties Setting properties at design time Setting properties at run time Interconnectivity between the user form and Excel Comparing values Transferring information Running code