2459 Programming courses in Skelmersdale delivered Online

Writing code can seem intimidating — all those symbols, brackets, and the dreaded error messages. But this Ultimate Python Training for Beginners Course is here to change that, one logical step at a time. Designed for absolute beginners, this course introduces Python in a friendly, structured way that doesn’t assume you already know what a variable is or how loops behave when no one’s watching. From basic syntax to building simple programs, every topic is explained clearly, without the need for a computer science dictionary on standby. Perfect for anyone curious about programming — whether for career reasons or sheer curiosity — this course offers a solid starting point with Python’s most useful features. You'll learn how to write clean code, handle data, and understand how Python quietly powers everything from websites to weather apps. No previous coding experience required, no pressure to memorise obscure functions — just an accessible, well-paced guide that lets you explore one of today’s most in-demand languages with clarity, logic, and the occasional programming pun. Python made simple, minus the snakes. Ask ChatGPT Learning Outcomes: Gain a comprehensive understanding of the Python programming language. Learn how to write basic Python code, including variables, operators, loops, and functions. Discover how to use Python to perform common programming tasks, such as data analysis, web scraping, and GUI development. Understand more advanced topics such as object-oriented programming and data structures. Learn how to use Python to build real-world projects and applications. The Ultimate Python Training for Beginners course is designed to provide you with the skills and knowledge you need to become a proficient Python programmer. Whether you're a complete novice or a seasoned programmer looking to add Python to your repertoire, this course is perfect for you. Starting with the basics of the language and moving on to more advanced topics, you'll follow a journey from learner to expert, gaining confidence and expertise with each step. You'll learn how to write basic Python code, perform common programming tasks, and build real-world projects and applications using Python. ⊱⊱ Ultimate Python Training for Beginners Course Curriculum Section 01: Getting Started Section 02: Learners' Spot Section 03: Marathon Journey Section 04: Expert Path How is the course assessed? Upon completing an online module, you will immediately be given access to a specifically crafted MCQ test. For each test, the pass mark will be set to 60%. Exam & Retakes: It is to inform our learners that the initial exam for this online course is provided at no additional cost. In the event of needing a retake, a nominal fee of £9.99 will be applicable. Certification Upon successful completion of the assessment procedure, learners can obtain their certification by placing an order and remitting a fee of £9 for PDF Certificate and £15 for the Hardcopy Certificate within the UK ( An additional £10 postal charge will be applicable for international delivery). CPD 10 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Individuals who are new to programming and want to learn Python from scratch. Programmers who want to add Python to their repertoire. Data analysts who want to use Python for data analysis and visualization. Web developers who want to use Python for web development and web scraping. Anyone who wants to develop their skills in the software development industry. Career path Junior Python Developer: £20,000 - £35,000 Python Developer: £28,000 - £55,000 Senior Python Developer: £40,000 - £80,000 Python Data Analyst: £30,000 - £60,000 Python Web Developer: £25,000 - £65,000 Certificates Certificate of completion Digital certificate - £9 You can apply for a CPD Accredited PDF Certificate at the cost of £9. Certificate of completion Hard copy certificate - £15 Hard copy can be sent to you via post at the expense of £15.

Did you know? The construction industry in the UK is worth £110 billion and employs over 2.5 million people. Yet, many projects still experience delays and cost overruns. Why? One reason is the lack of skilled professionals trained in Building Information Modeling (BIM). Are you ready to be part of the future of construction? This BIM - Building Information Modeling Diploma equips you with the skills and knowledge to excel in this cutting-edge field. With this BIM - Building Information Modeling Diploma course you will get 20 CPD Accredited PDF Certificates, Hard Copy Certificate Advanced Diploma in Architectural Studies at QLS Level 7 and our exclusive student ID card absolutely free. Courses Are Included In This BIM - Building Information Modeling Diploma Bundle: Course 01: Building Information Modelling Course 02: Architectural Studies Course 03: LEED V4 - Building Design and Construction Course 04: Autodesk Revit: Modeling & Rendering Course 05: Revit Architecture Ultimate Interior Design Course Course 06: Revit Architecture Ultimate Exterior Design for Beginners Course 07: Solidworks Foundation Training Course 08: CAD Design Training Course 09: AutoCAD VBA Programming - Beginner Course Course 10: Learn AutoCAD Programming using VB.NET - Hands On! Course 11: AutoCAD Programming Using C#.NET Level 7 Course 12: Autocad Electrical Design Course 13: Construction Management Principles and Practices Course 14: Construction Project Management Course 15: Diploma in Construction Industry Scheme (CIS): QLS Endorsed Course 16: Construction, Design and Management(CDM) Awareness Training Course 17: Site Management Safety Training Scheme (SMSTS) at QLS Level 5 Course 18: WELL Building Standard Course 19: Building Surveying Practice Course 20: Lone Worket Safety Don't miss this chance to elevate your career and skillset. Enrol in BIM - Building Information Modeling Diploma today and take the first step towards achieving your goals and dreams. Learning Outcomes Master BIM software: Revit, AutoCAD, Solidworks. Design & model buildings: 3D modeling, project documentation. Collaborate effectively: BIM workflows, team communication. Manage construction projects: Scheduling, cost estimation, risk assessment. Understand sustainability principles: LEED certification, green building practices. Comply with UK regulations: CDM, SMSTS, electrical safety. Why buy this Bundle? Free QLS endorsed Certificate upon completion of BIM Diploma Get a free student ID card with BIM - Building Information Modeling Diploma Lifetime access to the BIM - Building Information Modeling Diploma course materials Get instant access to this BIM - Building Information Modeling Diploma course Learn BIM - Building Information Modeling Diploma from anywhere in the world 24/7 tutor support with the BIM - Building Information Modeling Diploma course. BIM Diploma is an entirely online, interactive lesson with voice-over audio. Start your learning journey straightaway! BIM - Building Information Modeling Diploma premium bundle consists of 20 precisely chosen courses on a wide range of topics essential for anyone looking to excel in this field. Each segment of BIM - Building Information Modeling Diploma is meticulously designed to maximise learning and engagement, blending interactive content and audio-visual modules for a truly immersive experience. Certification You have to complete the assignment given at the end of the BIM - Building Information Modeling Diploma course and score a minimum of 60% to pass each exam. After passing the Advanced Diploma in Architectural Studies at QLS Level 7 course exam You will be entitled to claim a QLS endorsed certificate completely free. CPD 380 CPD hours / points Accredited by CPD Quality Standards Who is this course for? This BIM - Building Information Modeling Diploma course is ideal for: Students seeking mastery in BIM Professionals seeking to enhance BIM Individuals looking for a BIM Anyone passionate about BIM Requirements This BIM - Building Information Modeling Diploma doesn't require prior experience and is suitable for diverse learners. Career path This BIM - Building Information Modeling Diploma bundle will allow you to kickstart or take your career in the related sector to the next stage. BIM Technician BIM Coordinator BIM Modeler BIM Manager Project Manager Design Engineer Certificates Advanced Diploma in Architectural Studies at QLS Level 7 Hard copy certificate - Included CPD Accredited Digital certificate Digital certificate - Included

Course Overview This course is a perfect introduction for those looking to become Computer Vision - Optical Character recognition (OCR) Specialists or engineers. Through this course, you will learn about OCR implementation to speed up the workflow of Text processes across various industries. It will teach you Optical Character Recognition (OCR) for data extraction from images and PDFs using Python, step-by-step. This course has been designed by industry experts to help you gain a complete understanding of OCR architecture, equipping you with basic Python programming skills. By the end of the course, you will be able to confidently apply optical character recognition to images to recognise text (tesseract and py-tesseract), as well as have an excellent understanding of the different applications of OCR. This best selling OCR in Number plate using Python has been developed by industry professionals and has already been completed by hundreds of satisfied students. This in-depth OCR in Number plate using Python is suitable for anyone who wants to build their professional skill set and improve their expert knowledge. The OCR in Number plate using Python is CPD-accredited, so you can be confident you're completing a quality training course will boost your CV and enhance your career potential. The OCR in Number plate using Python is made up of several information-packed modules which break down each topic into bite-sized chunks to ensure you understand and retain everything you learn. After successfully completing the OCR in Number plate using Python, you will be awarded a certificate of completion as proof of your new skills. If you are looking to pursue a new career and want to build your professional skills to excel in your chosen field, the certificate of completion from the OCR in Number plate using Python will help you stand out from the crowd. You can also validate your certification on our website. We know that you are busy and that time is precious, so we have designed the OCR in Number plate using Python to be completed at your own pace, whether that's part-time or full-time. Get full course access upon registration and access the course materials from anywhere in the world, at any time, from any internet-enabled device.  Our experienced tutors are here to support you through the entire learning process and answer any queries you may have via email.

Dive into Python, Pandas, and NumPy, mastering data manipulation and visualisation for a thriving data science career.

24-Hour Knowledge Knockdown! Prices Reduced Like Never Before Ever wondered what powers the vast majority of web servers, supercomputers, and even smartphones around the world? The answer is Linux, a powerful and versatile operating system. Did you know that according to a recent study, over 60% of web servers in the UK run on Linux? If you're interested in a career in IT, understanding Linux is an essential skill. This LINUX course bundle equips you with the knowledge and expertise to navigate the world of Linux, from the fundamentals to advanced security practices. This LINUX - CPD Certified Bundle Contains 15 of Our Premium Courses for One Discounted Price: Course 01: Learn Linux in 5 Days Course 02: LINUX File Management System Course 03: C Programming Language for Beginners on Linux Course 04: LINUX Security and Hardening Course 05: LINUX Shell Scripting Course 06: Learn Ethical Hacking From A-Z: Beginner To Expert Course 07: Securing an Ubuntu Linux Server against Hackers Masterclass Course 08: Bash Scripting, Linux and Shell Programming Masterclass Course 09: CompTIA Network Course 10: IT Support Technician Training Course 11: CompTIA PenTest+ (Ethical Hacking) course Course 12: Web Application Penetration Testing Course Course 13: SQL Database Administrator Course 14: Microsoft Access Databases Forms and Reports Course 15: Computer Operating System and Troubleshooting This LINUX bundle offers a structured learning path that starts with the foundational concepts of Linux, guiding you through the file system, working with the command line, and scripting languages like C and Bash. As you progress, you'll delve into essential security practices to harden your Linux systems against potential threats. Learning Outcomes of LINUX - CPD Certified Bundle Gain a solid understanding of the Linux operating system fundamentals. Master essential file management techniques and navigate the Linux directory structure. Learn C programming fundamentals within the Linux environment. Implement robust security measures to protect your Linux systems. Craft effective shell scripts to automate tasks and enhance efficiency. Take the first step towards a rewarding career in Linux and related fields and enroll today! Why Choose Our LINUX Bundle? Get a Free CPD Accredited Certificate upon completion of LINUX Get a free student ID card with LINUX Training Get instant access to this LINUX course. Learn LINUX from anywhere in the world The LINUX is affordable and simple to understand The LINUX is an entirely online, interactive lesson with voiceover audio Lifetime access to the LINUX course materials The LINUX comes with 24/7 tutor support Start your learning journey straightaway with LINUX! This LINUX's curriculum has been designed by LINUX experts with years of LINUX experience behind them. The LINUX course is extremely dynamic and well-paced to help you understand LINUX with ease. You'll discover how to master the LINUX skill while exploring relevant and essential topics. CPD 150 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Anyone interested in learning more about the topic is advised to take this LINUX - CPD Certified Diploma bundle. Requirements You will not need any prior background or expertise to enrol in this LINUX - CPD Certified Diploma bundle. Career path After completing this LINUX - CPD Certified Diploma course, you are to start your career or begin the next phase of your career. Linux administrator Network security analyst Penetration tester Web developer IT support specialist Database administrator Certificates Digital certificate Digital certificate - Included Hard copy certificate Hard copy certificate - Included

Are you looking to enhance your Python programming skills? If yes, then you have come to the right place. Our comprehensive course on Python programming will assist you in producing the best possible outcome by mastering the Python skills. The Python course is for those who want to be successful. In the Python course, you will learn the essential knowledge needed to become well versed in Python programming . Our Python from Scratch course starts with the basics of Python and gradually progresses towards advanced topics. Therefore, each lesson of this Python course is intuitive and easy to understand. Why would you choose the Python from Scratch course: Lifetime access to Python from Scratch course materials Full tutor support is available from Monday to Friday with the Python course Learn Python from Scratch at your own pace from the comfort of your home Gain a complete understanding of Python course Accessible, informative Python learning modules designed by expert instructors Get 24/7 help or advice from our email and live chat teams with the Python from Scratch course Study Python in your own time through your computer, tablet or mobile device A 100% learning satisfaction guarantee with your Python course Key topics covered in the Python from Scratch Course Introduction to Python and its latest features Command line operations and code execution Manipulation of data types and structures Application of conditional and looping structures Object-Oriented Programming fundamentals Exception handling in Python Using Pypi, Pip, and built-in Python modules Basics of Decorators and Generators Introduction to Django framework and project setup Implementing models, migrations, and URL mapping in Django Django admin customization and site navigation Game creation and performance measurement in Python CPD 10 CPD hours / points Accredited by CPD Quality Standards Who is this course for? The Python from Scratch course helps aspiring professionals who want to obtain the knowledge and familiarise themselves with the skillsets to pursue a career in Python. It is also great for professionals who are already working in Python and want to get promoted at work. Requirements To enrol in this Python from Scratch course, all you need is a basic understanding of the English Language and an internet connection. Career path The Python from Scratch course will enhance your knowledge and improve your confidence in exploring opportunities in various sectors related to Python programming. Certificates CPD Accredited PDF Certificate Digital certificate - Included CPD Accredited PDF Certificate CPD Accredited Hard Copy Certificate Hard copy certificate - £10.79 CPD Accredited Hard Copy Certificate Delivery Charge: Inside the UK: Free Outside of the UK: £9.99 each

Reboot Your Brain for Success & Peak Performance is a Neuroencoding Method that delivers long lasting results. The complete program walks participants through the five elements it takes to clear out their brain, boost up their mindset, and update their mental faculties. This workshop is perfect for anyone who wants to reset to their magnificent default.

Python training course description This Python course focusses on teaching Python for use in network automation and network DevOps. We focus on getting delegates up and running with Python and network automation as quickly as possible rather than making them great programmers. In other words we concentrate on enabling delegates to use network automation libraries such as netmiko, NAPALM and Nornir, and APIs such as NETCONF and RESTCONF rather than enabling delegates to produce object oriented programs. Hands on sessions use Cisco and Juniper devices. What will you learn Run Python programs. Read Python programs. Write Python programs. Debug Python programs. Automate network tasks with Python programs. Configure network devices with Python. Collect data from network devices with Python. Python training course details Who will benefit: Network engineers. Prerequisites: TCP/IP Foundation Duration 5 days Python training course contents What is Python? Programming languages, Why Python? Python in interactive mode, Python scripts, ipython, Python version 2 versus version 3. A simple Python script. Comments. Hands on Installing Python, Hello world. A network example On box vs off box Python. telnet, ssh, NETCONF, HTTP, APIs, manufacturers and API support, analysis of a simple telnetlib program. Hands on Using Python to retrieve the configuration from a network device. Using wireshark to analyse the actions. Python basics I/O, operators, variables and assignment, types, indentation, loops and conditionals. Hands on Modifying the telnet program, changing configurations on a network devices. Functions, classes and methods What are functions, calling functions, builtin functions, useful builtin functions, file handling, classes, objects, creating instances. Hands on Storing configurations in files, configuring devices from files, using an inventory file to work on multiple devices. Libraries and modules Modules, files and packages, import, from-import, Python standard library, other packages, pip install, executing other programs. Managing python libraries. Hands on Using pip, installing and using ipaddress, subprocess to access netsnmp. For the more advanced, using the sockets library. Paramiko and netmiko SSH, enabling SSH on devices, keys. Paramiko versus netmiko, example scripts. pexpect. Hands on Configuring VLANs from Python. pySNMP Gathering facts using previous methods, SNMP review, pySNMP GET, pySNMP and SNMPv3. easySNMP library. Hands on Walking a MIB from Python. NETCONF What is NETCONF? Enabling NETCONF on devices, A first ncclient script, device handlers, get_config, edit_config, copy_config, delete_config, commit, validate, pyEZ, utils_config, utils.sw. Hands on Configuration using ncclient and PyEZ. This session is expanded for those interesting in JunOS automation. Manipulating configuration files Builtin functions, string handling. Unicode. Sequences, strings, lists, tuples. Dictionaries. TextFSM. Regular expressions. JSON, YAML, XML, YANG, Jinja2, templates. Hands on Jinja2 templating with Python to configure network devices. NAPALM Getters, configuration operations, supported devices, NAPALM transport, Config-replace, Config-merge, Compare config, Atomic changes, rollback. Example NAPLAM scripts. Hands on Using NAPALM to gather facts, Using NAPALM for configuration management REST and RESTCONF What is REST, HTTP methods, GET, POST, cURL, Postman, Python requests library. RESTCONF, a RESTCONF example. Hands on Modifying a configuration using RESTCONF. Scapy What is scapy, Scapy in interactive mode, Scapy as a module. Hands on Packet crafting from Python. Warning Errors and exceptions, Exception handling, try, except. Memory management. Garbage collection. Context management, With. Hands on Improving Python code. Nornir What is Nornir? A network automation framework, inventories, connection management and parallelization. Nornir architecture and other libraires. Hands on Setting up nornir, nornir fact gathering, nornir tasks. Optional Writing your own functions, Writing your own classes. pyntc. Hands on Writing reusable code.

24 Hour Flash Deal **25-in-1 Computer Vision: C++ and OpenCV with GPU support Mega Bundle** Computer Vision: C++ and OpenCV with GPU support Enrolment Gifts **FREE PDF Certificate**FREE PDF Transcript ** FREE Exam** FREE Student ID ** Lifetime Access **FREE Enrolment Letter ** Take the initial steps toward a successful long-term career by studying the Computer Vision: C++ and OpenCV with GPU support package online with Studyhub through our online learning platform. The Computer Vision: C++ and OpenCV with GPU support bundle can help you improve your CV, wow potential employers, and differentiate yourself from the mass. This Computer Vision: C++ and OpenCV with GPU support course provides complete 360-degree training on Computer Vision: C++ and OpenCV with GPU support. You'll get not one, not two, not three, but twenty-five Computer Vision: C++ and OpenCV with GPU support courses included in this course. Plus Studyhub's signature Forever Access is given as always, meaning these Computer Vision: C++ and OpenCV with GPU support courses are yours for as long as you want them once you enrol in this course This Computer Vision: C++ and OpenCV with GPU support Bundle consists the following career oriented courses: Course 01: Computer Vision: C++ and OpenCV with GPU support Course 02: Python 3 Programming Course 03: Machine Learning Course with Python Course 04: Data Science & Machine Learning with R Course 05: Robotics - Sensors Course 06: Digital Electric Circuits & Intelligent Electrical Devices Course 07: AutoCAD Programming using VB.NET with Windows Forms Course 08: Learn MySQL from Scratch for Data Science and Analytics Course 09: Data Structure Course 10: Electronic Device and Circuits Protection Training Course 11: Computer Science with Python Course Course 12: IT Administration and Networking Course 13: Foundations of IT Security: Protecting Digital Assets Course 14: SQL Database Management Course 15: Deep Learning Neural Network with R Course 16: Computer Networks Security from Scratch to Advanced Course 17: Electronic & Electrical Devices Maintenance & Troubleshooting Course 18: Embedded Systems with 8051 Microcontroller Course 19: MATLAB Simulink for Electrical Power Engineering Course 20: Solidworks: Beginner to Advanced Course 21: Info Graphics Web Design - Affinity Designer Training Course 22: Diploma in Python Programming Course 23: Penetration Testing with OWASP ZAP: Mastery course Course 24: Unreal Engine 4 Course 25: Blender 3D Character Modeling & Rendering The Computer Vision: C++ and OpenCV with GPU support course has been prepared by focusing largely on Computer Vision: C++ and OpenCV with GPU support career readiness. It has been designed by our Computer Vision: C++ and OpenCV with GPU support specialists in a manner that you will be likely to find yourself head and shoulders above the others. For better learning, one to one assistance will also be provided if it's required by any learners. The Computer Vision: C++ and OpenCV with GPU support Bundle is one of the most prestigious training offered at StudyHub and is highly valued by employers for good reason. This Computer Vision: C++ and OpenCV with GPU support bundle course has been created with twenty-five premium courses to provide our learners with the best learning experience possible to increase their understanding of their chosen field. This Computer Vision: C++ and OpenCV with GPU support Course, like every one of Study Hub's courses, is meticulously developed and well researched. Every one of the topics is divided into Computer Vision: C++ and OpenCV with GPU support Elementary modules, allowing our students to grasp each lesson quickly. The Computer Vision: C++ and OpenCV with GPU support course is self-paced and can be taken from the comfort of your home, office, or on the go! With our Student ID card you will get discounts on things like music, food, travel and clothes etc. In this exclusive Computer Vision: C++ and OpenCV with GPU support bundle, you really hit the jackpot. Here's what you get: Step by step Computer Vision: C++ and OpenCV with GPU support lessons One to one assistance from Computer Vision: C++ and OpenCV with GPU supportprofessionals if you need it Innovative exams to test your knowledge after the Computer Vision: C++ and OpenCV with GPU supportcourse 24/7 customer support should you encounter any hiccups Top-class learning portal Unlimited lifetime access to all twenty-five Computer Vision: C++ and OpenCV with GPU support courses Digital Certificate, Transcript and student ID are all included in the price PDF certificate immediately after passing Original copies of your Computer Vision: C++ and OpenCV with GPU support certificate and transcript on the next working day Easily learn the Computer Vision: C++ and OpenCV with GPU support skills and knowledge you want from the comfort of your home CPD 250 CPD hours / points Accredited by CPD Quality Standards Who is this course for? This Computer Vision: C++ and OpenCV with GPU support training is suitable for - Students Recent graduates Job Seekers Individuals who are already employed in the relevant sectors and wish to enhance their knowledge and expertise in Computer Vision: C++ and OpenCV with GPU support Requirements To participate in this Computer Vision: C++ and OpenCV with GPU support course, all you need is - A smart device A secure internet connection And a keen interest in Computer Vision: C++ and OpenCV with GPU support Career path You will be able to kickstart your Computer Vision: C++ and OpenCV with GPU support career because this course includes various courses as a bonus. This Computer Vision: C++ and OpenCV with GPU support is an excellent opportunity for you to learn multiple skills from the convenience of your own home and explore Computer Vision: C++ and OpenCV with GPU support career opportunities. Certificates CPD Accredited Certificate Digital certificate - Included CPD Accredited e-Certificate - Free CPD Accredited Hardcopy Certificate - Free Enrolment Letter - Free Student ID Card - Free

Course Objectives At the end of this course you will be able to: Record and edit a Macro Assign macros to keyboard shortcuts, Quick Access Toolbar, Buttons and Shape objects. Use the Visual Basic Editor; change the properties of an object; add a module to a project; write the code for a procedure and then run it; and use the Object Browser to search procedures Manipulate data by declaring variables of different data types; combine data by using expressions; use functions to accept input and display output; and declare variables and procedures with the appropriate scope Use decision structures to create procedures that make decisions; and use loop structures to perform repetitive tasks Create an error handling routine in case things go wrong with VBA code ' 1 year email support service Take a closer look at the consistent excellent feedback from our growing corporate clients visiting our site ms-officetraining co uk Customer Feedback Best Training Ever! Just finished a bespoke 1-1 training course in Excel Advanced, Macros & VBA. Pedro is an excellent trainer, imparting his skills and knowledge in the best way - appropriately to audience skills, knowledge and ability. Pedro is always approachable, encouraging and supportive, giving delegates the optimum learning environment. I would not hesitate to recommend Pedro as a trainer, whatever your level of ability. Amanda Morris - Treasury & Systems Accountant at Reall - Real Equity for All The trainer was very knowledgeable, kept everyone involved and was enthusiastic. A great experience.. Simon Harper - Lloyd's of London My learning experience was awesome. Perdinand Reagan - Subsea7 Very nice and relaxed approach to teaching. Was definitely a good learning experience. Jerome Pupe - S5 Agency World The Trainer – Very positive + patient + helpful + thorough Agnes Souza - Direct Wines ' With more than 20 years experience, we deliver courses on all levels of the Desktop version of Microsoft Office and Office 365; ranging from Beginner, Intermediate, Advanced to the VBA level. Our trainers are Microsoft certified professionals with a proven track record with several years experience in delivering public, one to one, tailored and bespoke courses. Our competitive rates start from £550.00 per day of training Tailored training courses: You can choose to run the course exactly as they are outlined by us or we can customise it so that it meets your specific needs. A tailored or bespoke course will follow the standard outline but may be adapted to your specific organisational needs. Introduction to Macros and VBA Introducing Visual Basic for Applications Recording a Macro Naming conventions for Macro Procedures Running a Macro Absolute or Relative Cell Referencing Saving and Opening Files with Macros Making macros always available Adding Macros to Keyboard Shortcuts, Quick Access Toolbar, Buttons and Shapes Editing a Macro in the Visual Basic Editor Understanding the Development Environment Customising the Editor Tips for General Typing in VBA Using Visual Basic Help Working with Procedures Program Design Understanding Modules Naming Rules Creating a Module Understanding Procedures Programming Macro Concepts Creating a Subroutine Creating a Function Understanding Arguments Exiting Procedures Calling Procedures Objects, Properties, Methods and Events Understanding Objects Properties, Methods, and Events Navigating the Object Hierarchy Understanding Collections Accessing a Member of a Collection Understanding Hierarchy Using the Object Browser Using the With Statement Working with Properties Working with Methods Creating an Event Procedure Reserved Macro Names Using Expressions, Variables and Intrinsic Functions Understanding Expressions and Statements Declaring Variables Understanding Data Types Determining the Value of Variables Working with Variable Scope Using Built-in VBA Functions Understanding Constants Using Message Boxes Controlling the Answer to a Message Box Using Input Boxes Declaring and Using Object Variables Controlling Program Execution Understanding Control-of-Flow Structures Using the If...End If Decision Structures Nested If Statements Using the Select Case ... End Select Structure Using the Do ... Loop Structure Using the For ... Next Structure Using the For Each ... Next Structure Guidelines for Use of Control-of-Flow Structures Debugging and Handling Errors Understanding Errors Using Debugging Tools Setting Breakpoints and Using Break Mode Stepping Through Code Trapping Errors with the On Error Statement Understanding the Err Object Working with Inline Error Handling Writing an Error-Handling Routine Working with Forms and Controls Understanding UserForms Creating a Form Displaying and Removing a Form Aligning and Sizing Controls Using the Toolbox Working with a Form's Properties, Methods, and Events Working with Form and Control Properties, Methods and Event Setting the Tab Order Populating a Control Who is this course for? Who is this course for? This course is designed to give proficiency in the Visual Basic Editor (VBE), predominantly making use of Excel objects, understanding Object's Properties, Events and Methods, basic VBA Object oriented programming, event handling, control structures, and debugging tools. Requirements Requirements Preferably, delegates should have attended the Excel Advanced course. Certificates Certificates Certificate of completion Digital certificate - Included