• Professional Development
  • Medicine & Nursing
  • Arts & Crafts
  • Health & Wellbeing
  • Personal Development

50 Educators providing Visual Basic courses delivered Online

EduCBA

educba

POPULAR ALL-IN-ONE BUNDLE COURSES All In One Financial Analyst Bundle | All In One Data Science Bundle | All In One Software Development Bundle | All In One Excel VBA Bundle | All In One Design Bundle | All In One Project Management Bundle | All In One Personal Development Bundle | All In One Marketing Bundle | POPULAR FINANCE CERTIFICATION COURSES Investment Banking Course | Financial Modeling Course | Project Finance Training | Business Valuation Training | Accounting Course Bundle | Financial Analytics Training | Mergers & Acquisition Course | Finance For Non Finance Managers Course | Cryptocurrency Training | US GAAP Course | LBO Modeling Course | Hedge Funds Course | IFRS Training | Credit Risk Modeling Course | GST Training Program | Mutual Funds Training | Private Equity Training | Venture Capital Course | Fixed Income Course | Equity Research Training | Corporate Finance Training Bundle | POPULAR LIVE ONLINE COURSES Advanced Minitab Training | Tableau Desktop Training | PMP Certification Exam Prep Training | Data Science With Python | Machine Learning | Python GUI Training | Python Scripting | Java Programming | Ultimate .Net Training | Financial Modeling | TRENDING EXAM PREP COURSES CFA 1 | CFA 2 | FRM 1 | FRM 2 | CMA 1 | CMA 2 | PMP Training | PMI SP Training | PMI RMP Training | Scrum Master Training | Six Sigma Green Belt Prep Training | PMI ACP Training | CAPM Training | PgMP Training | CBAP Training | POPULAR DATA SCIENCE CERTIFICATION COURSES Data Science with Python Certification Course | Machine Learning Training | Hadoop Training Program | R Programming Training | SAS Training | EViews Econometrics Training | Cloud Computing Training | AWS Training | SPSS Training Program | IoT Training | Tableau Training | Deep Learning Training | Apache Pig Training | Splunk Training Program | Azure Training | Pandas And NumPy Tutorial | Hive Training | SEO Training | Multisim Training | Minitab Training | Salesforce Training | MapReduce Training | MS SQL Training | TensorFlow Training | Informatica Training | Microsoft Power BI Training | Ansible Training | QlikView Training | OpenCV Training | Docker Training | DevOps Training | MATLAB Training | BUSINESS ANALYTICS CERTIFICATION COURSES Business Analytics Training | Statistical Analysis Training | Data Visualization Training | Business Intelligence Training | Forecasting Models Course | Time Series Course | Fraud Analytics Course | Artificial Intelligence Training | Customer Analytics Training | Marketing Analytics Training | Time Series Analysis and Forecasting with Python | Time Series Analysis and Forecasting with Minitab | Time Series Analysis and Forecasting with Tableau | Time Series Analysis and Forecasting with R | Time Series Analysis and Forecasting with Excel | Time Series Analysis and Forecasting with SAS | Predictive Modeling with Python Course | Predictive Analytics Course | Predictive Modeling with SAS Enterprise Miner | POPULAR SOFTWARE AND DEVELOPMENT COURSES Python | iOS | VB.net | JavaScript | Selenium | Java | Android | C++ | Windows Forms | XML Training | Angular JS | Linux | Bootstrap | Swift Training | JDBC Training | Ruby On Rails | J2EE | WPF | HTML Training | Ionic 4 Tutorials | JQuery UI Course | Java Servlet | C Programming | Spring Boot Training Program | Red Hat Linux Training Program | Ubuntu Training Program | Spring Framework Training | ServiceNow | Joomla | ASP.net | Oracle | C# | ADO.net | JQuery | Ethical Hacking | Kali Linux | Cyber Security Training | Penetration Testing | Django | Windows 10 | SQL Training Program | CSS Training | TestNG | PLSQL | MongoDB | JUnit | Robotic Process Automation RPA Training | PHP Training | React JS Redux Training | PostgreSQL Course | POPULAR DESIGN AND DRAWING COURSES AutoCAD Training | SketchUp Course | SolidWorks Training | Unity Training | Unreal Engine Training | MonoGame Course | DirectX Training | Photoshop Training | Corel Draw Training | Illustrator Training | OpenGL Course | POPULAR FILM EDITING AND VFX COURSES After Effects Training | Cinema 4D Training | Pixelan VFX Tutorial | Boris FX Tutorial | Blackmagic Fusion Training | RealFlow Tutorial | Autodesk Combustion Training | Natron Tutorial | Nuke Training | Silhouette FX Tutorial | Sony Vegas Pro Tutorial | Adobe Premiere Pro Tutorial | DaVinci Resolve Training | NewBlueFX Tutorial | Lightworks Tutorial | Avid Media ComposerTraining | FL Studio Training | Melodyne Tutorial | Pro Tools Training | Audacity Training | TOP 3D MODELING AND ANIMATION COURSES Maya Training | Houdini Training | 3D Max Training | Blender Course | ZBrush Training | Cinema 4D Training | Mudbox Course | POPULAR EXCEL AND OFFICE PRODUCTIVITY COURSES Excel Training | Excel Advanced Training | VBA Training | Excel Data Analysis Training | Excel For HR Training | Excel For Finance Training | Excel For Marketing Training | Pivot Table Training | Microsoft Access Training | MS Office Training | MS Office For MAC | Microsoft Word Training | TOP BUSINESS AND MANAGEMENT COURSES Strategic Management Training | Marketing Training Program | Digital Marketing Training | CRM Training | Market Research Training | Content Marketing Course | Logistics And Supply Chain Training | Business Analysis Training | Retail Management Training | Content Development Training | Job Interview Training | Personality Development Course | Quality Management Training | Project Management Training Program | Agile Scrum Training | Primavera Training | Lean Management Training | Project Estimation Training | Project Cost Management Training | Project Planning Course | TRENDING RESOURCES Blog | Python Tutorial | Java Tutorial | C sharp Tutorial | HTML Tutorial | JavaScript Tutorial | PHP Tutorial | Big Data Tutorial | Hadoop Tutorial | Machine Learning Tutorial | Artificial Intelligence Tutorial | DevOps Tutorial | Tableau Tutorial | Photoshop Tutorial | After Effects Tutorial | Illustrator Tutorial | AutoCAD Tutorial | 3ds Max Tutorial | CorelDraw Tutorial | APPS EDUCBA Android AppEDUCBA iOS App Terms & Conditions Disclaimer Privacy Policy & Cookie Policy Shipping Policy ISO 10004:2018 & ISO 9001:2015 Certified © 2023 - EDUCBA. ALL RIGHTS RESERVED. THE CERTIFICATION NAMES ARE THE TRADEMARKS OF THEIR RESPECTIVE OWNERS. Hello,how may I help you?}

Nexus Human

nexus human

London

Nexus Human, established over 20 years ago, stands as a pillar of excellence in the realm of IT and Business Skills Training and education in Ireland and the UK.  For over two decades, Nexus Human has been a steadfast source of reliable and high-quality training solutions, catering to a diverse range of professional and educational needs. With a strong reputation in the Training Industry, Nexus Human has consistently demonstrated its commitment to equipping individuals and organisations with the skills and knowledge required to thrive in today's dynamic world.  Our training programs span a wide spectrum, encompassing IT certifications, business skills, and much more.   What sets Nexus Human apart is our unwavering dedication to staying at the forefront of industry trends and technology advancements.  Our expert instructors, coupled with cutting-edge training resources, ensure that students receive the most up-to-date and relevant knowledge available. The impact of Nexus Human extends far and wide, helping individuals enhance their career prospects and aiding businesses in achieving their goals.  This 20-year journey has solidified our institution's standing as a trusted partner in personal and professional growth, offering reliable, excellent training that continues to shape the future.  Whether you seek to upskill, reskill, or simply stay ahead of the curve, Nexus Human is the place to turn for an educational experience marked by quality, reliability, and innovation.

iStudy UK

istudy uk

We understand more than anyone how important it is for you to get the right qualifications at the right time. We also understand that when you have a lot to do, you might not always have the time free to go to a place of study. That is why we created this site, so you can take all the time you need to learn more about your chosen topics as well as be able to do the whole thing from home. We believe in empowering people by offering them opportunities to expand and extend their knowledge and skill set as well as giving them the support they need to achieve great things. With thousands of courses available and a team who will do just about anything to help you, it is safe to say that you will not find a better course provider on the internet and so we would love to work with you to make sure that you get the best experience and best results out of your education. WHAT WE DO Here at iStudy we provide a range of online training courses for those who want to gain new skills, and qualifications and update their knowledge. iStudy training courses are delivered entirely online through our sophisticated student learning portal. The student learning portal is an online learning management system that allows students to study for their courses online. This innovative technology means there is no need to attend any classes or take time off work to study. Professionally accredited courses All our courses are delivered in partnership with nationally recognised awarding bodies so be assured that what you learn with us matters when it comes to achieving your career goals. Study that suits you You do not have to give up your job or your life to get a new qualification, you can learn anytime, anywhere.

1...345

Courses matching "Visual Basic"

Show all 61

55337 Introduction to Programming

By Nexus Human

Duration 5 Days 30 CPD hours This course is intended for This course is intended for anyone who is new to software development and wants, or needs, to gain an understanding of programming fundamentals and object-oriented programming concepts. They will typically be high school students, post-secondary school students, or career changers, with no prior programming experience. They might want to gain an understanding of the core programming fundamentals before moving on to more advanced courses such as Programming in C#. Overview Explain core programming fundamentals such as computer storage and processing. Explain computer number systems such as binary. Create and use variables and constants in programs. Explain how to create and use functions in a program. Create and use decisions structures in a computer program. Create and use repetition (loops) in a computer program. Explain pseudocode and its role in programming. Explain the basic computer data structures such as arrays, lists, stacks, and queues. Implement object-oriented programming concepts. Create and use classes in a computer program. Implement encapsulation, inheritance, and polymorphism. Describe the base class library (BCL) in the .NET Framework. Explain the application security concepts. Implement simple I/O in a computer program. Identify application errors and explain how to debug an application and handle errors. Identify the performance considerations for applications. In this 5-day course, students will learn the basics of computer programming through the use of Microsoft Visual Studio 2022 and the Visual C# and Visual Basic programming languages. The course assumes no prior programming experience and introduces the concepts needed to progress to the intermediate courses on programming, Programming in C#. The focus will be on core programming concepts such as computer storage, data types, decision structures, and repetition by using loops. The course also covers an introduction to object-oriented programming covering classes, encapsulation, inheritance, and polymorphism. Coverage is also included around exception handling, application security, performance, and memory management. 1 - Introduction to Core Programming Concepts Computer Data Storage and Processing Application Types Application Lifecycle Code Compilation 2 - Core Programming Language Concepts Syntax Data Types Variables and Constants 3 - Program Flow Introduction to Structured Programming Concepts Introduction to Branching Using Functions Using Decision Structures Introducing Repetition 4 - Algorithms and Data Structures Understand How to Write Pseudocode Algorithm Examples Introduction to Data Structures 5 - Error Handling and Debugging Introduction to Program Errors Introduction to Structured Error Handling Introduction to Debugging 6 - Introduction to Object-Oriented Programming Introduction to Complex Structures Introduction to Structs Introduction to Classes Introducing Encapsulation 7 - More Object-Oriented Programming Introduction to Inheritance Introduction to Polymorphism Introduction to .NET and the Base Class Library 8 - Introduction to Application Security Authentication and Authorization Code Permissions on Computers Introducing Code Signing 9 - Core I/O Programming Using Console I/O Using File I/O 10 - Application Performance and Memory Management Value Types vs Reference Types Converting Types The Garbage Collector Additional course details: Nexus Humans 55337 Introduction to Programming 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 55337 Introduction to Programming 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.

55337 Introduction to Programming
Delivered Online
£2,975

Visual Basic and VBScript Masterclass

By Course Cloud

Course Overview Visual Basic is one of the most powerful languages created by one of the largest companies in the world, Microsoft.  In this Visual Basic and VBScript Masterclass, you will learn the basic and advanced functions of Visual Basic - from how to get set up on Windows, to understanding the different data types. It will show you how to perform a wide range of tasks, from working with constructors and destructors, to object orientated programming. Throughout the training, you will be developing your basic programming skills and, which will help you to gain a head start in securing a career in this competitive field. You will gain all the knowledge needed to leverage the incredible technology behind this powerful programming language. This best selling Visual Basic and VBScript Masterclass has been developed by industry professionals and has already been completed by hundreds of satisfied students. This in-depth Visual Basic and VBScript Masterclass is suitable for anyone who wants to build their professional skill set and improve their expert knowledge. The Visual Basic and VBScript Masterclass 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 Visual Basic and VBScript Masterclass 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 Visual Basic and VBScript Masterclass, 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 Visual Basic and VBScript Masterclass 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 Visual Basic and VBScript Masterclass 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.

Visual Basic and VBScript Masterclass
Delivered Online On Demand
£25

Visual Basic and VBScript Training

4.5(3)

By Studyhub UK

The 'Visual Basic and VBScript Training' course is a comprehensive program that equips learners with the skills to create and manipulate software applications using Visual Basic (VB) and VBScript. Participants will delve into the fundamental concepts, advanced techniques, and graphical user interface (GUI) development, enabling them to build interactive and user-friendly applications. This course covers a range of topics, from basic scripting to advanced resource management, empowering learners to harness the power of these programming languages for various software development needs. Learning Outcomes: Gain proficiency in creating and manipulating software applications using Visual Basic. Understand the core concepts of classes and their role in application development. Explore file handling techniques for efficient data management. Develop graphical user interfaces (GUI) for user-friendly application interaction. Implement dialog boxes to enhance user experience and gather input. Learn advanced scripting techniques to optimize application functionality. Utilize resource management techniques for efficient application design. Develop proficiency in VBScript for creating dynamic web pages and scripting actions. Why buy this Visual Basic and VBScript Training? 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 Visual Basic and VBScript Training 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 Visual Basic and VBScript Training does not require you to have any prior qualifications or experience. You can just enrol and start learning.  Aspiring software developers looking to learn Visual Basic and VBScript. Programmers seeking to expand their knowledge of application development. Web developers interested in using VBScript for dynamic web content. IT professionals looking to enhance their scripting and programming skills. Prerequisites This Visual Basic and VBScript Training 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 Software Developer - Median salary of $110,000 - $120,000 per year. Web Developer - Median salary of $75,000 - $85,000 per year. Application Developer - Median salary of $90,000 - $100,000 per year. Systems Analyst - Median salary of $80,000 - $90,000 per year. IT Consultant - Median salary of $90,000 - $100,000 per year. Course Curriculum Section 01: Introduction Introduction To This Course 00:02:00 Setup On Windows 00:06:00 Run Code Online 00:01:00 Section 02: Basics Console Output 00:04:00 Comments 00:03:00 Variables 00:03:00 Console Input 00:02:00 Data Types 00:08:00 Constants 00:03:00 Enumerations 00:04:00 Directives 00:05:00 Operators 00:06:00 If Statement 00:05:00 Switch Statement 00:04:00 Loops 00:08:00 Strings 00:05:00 Date & Time 00:04:00 Arrays 00:06:00 For Each Loop 00:04:00 ArrayList 00:04:00 Hashtable 00:05:00 SortedList 00:03:00 Stack 00:05:00 Queue 00:04:00 Subs 00:07:00 Functions 00:04:00 Exception Handling 00:05:00 Section 03: Classes Simple Class Example 00:09:00 Constructor 00:03:00 Destructor 00:03:00 Shared Properties 00:04:00 Inheritance 00:04:00 Scope 00:03:00 Section 04: File Handling File Handling 00:07:00 Section 05: GUI Setup A GUI Project 00:03:00 Forms 00:05:00 TextBox 00:06:00 Label 00:02:00 Button 00:04:00 ListBox 00:04:00 ComboBox 00:03:00 RadioButton 00:04:00 CheckBox 00:02:00 DateTimePicker 00:03:00 PictureBox 00:03:00 ProgressBar 00:03:00 GroupBox 00:04:00 TreeView 00:04:00 ListView 00:02:00 Events 00:03:00 Section 06: Dialog Box Color Dialog 00:03:00 Font Dialog 00:03:00 Open File Dialog 00:03:00 Save File Dialog 00:05:00 Print Dialog 00:03:00 Section 08: Resource Menus 00:02:00 Anchoring & Docking 00:04:00 Modals 00:03:00 Regular Expressions 00:09:00 Parsing an XML File 00:06:00 Section 07: Advanced Resource - Visual Basic and VBScript Training 00:00:00 Assignment Assignment - Visual Basic and VBScript Training 00:00:00

Visual Basic and VBScript Training
Delivered Online On Demand4 hours 9 minutes
£10.99

Complete Visual BASIC

5.0(3)

By Systems & Network Training

Complete Visual BASIC training course description A hands-on introduction to programming in Visual BASIC V6. What will you learn Build Visual BASIC applications. Build simple components. Debug Visual BASIC programs. Examine existing code and determine its function. Complete Visual BASIC training course details Who will benefit: Anyone wishing to program in Visual BASIC. Prerequisites: None although experience in another high level language would be useful. Duration 5 days Complete Visual BASIC training course contents Application development using VB VB features. VB editions, VB terminology. Working in the Development Environment. Event-Driven Programming. Creating a program in VB. Project and executable files. VB reference materials. Visual Basic fundamentals Objects. Controlling objects. Introduction to forms. Introduction to controls. Basic controls. Working with code and forms Modules. Working with code. Interacting with the user. Working with code statements. Managing forms. Variables and procedures Introduction to variables and constants. Working with Procedures and Functions. Controlling program execution Common VB functions. Comparison and relational operators. Conditional structures. Looping structures. Debugging Error types. Debugging logic errors in VB. Working with controls Control types. Standard controls. Advanced standard controls. ActiveX controls. Insertable controls. Data access using the ADO data control Overview of ActiveX Data Objects. VB data access features. Relational database concepts. Using the ADO data Control to access data. SQL. Manipulating data. Using the data form wizard. Input validation Field-Level validation. The masked edit control. Form-Level validation. Form events used when validating data. Error trapping Trapping run time errors. Error handling overview. Enabling an error trap. Errors and the calling chain. In line error handling. Enhancing the User Interface Menus. Status bars. Toolbars. Drag and Drop Overview of Drag and Drop. Mouse events Drag and Drop basics. More about controls Using control arrays. Using the controls collection. Working with object variables. Collections. Finishing touches User Interface design principles. Distributing an application. Creating a default project.

Complete Visual BASIC
Delivered in Internationally or OnlineFlexible Dates
£4,997

MS POWER BI COURSE

4.6(12)

By PCWorkshops

Data Visualization Courses London. In this Power BI Course, you will learn how to translate data trends, summaries, statistics and insights from your data into powerful and inspirational visualizations This course is ideal for managers and data analysts who need to make business decisions based on data.

MS POWER BI COURSE
Delivered Online + more
£185

Microsoft Excel Macros & VBA - In-company

By Microsoft Office Training

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

Microsoft Excel Macros & VBA - In-company
Delivered in London or UK Wide or OnlineFlexible Dates
£750

Microsoft Excel Macros & VBA - Online classroom

By Microsoft Office Training

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 classroom, one to one, tailored and bespoke courses. Tailored In Company training: 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. Career path Career path Excel know-how can instantly increase your job prospects as well as your salary. 80 percent of job openings require spreadsheet and word-processing software skills Certificates Certificates Certificate of completion Digital certificate - Included

Microsoft Excel Macros & VBA - Online  classroom
Delivered OnlineFlexible Dates
£550

55128 Writing Reports with Report Builder and SSRS Level 2

By Nexus Human

Duration 2 Days 12 CPD hours This course is intended for The primary audience for this course are persons who are new to reporting with Microsoft© SQL Server© Report Builder and SSRS, persons who are transitioning from another reporting software application, and persons who are existing Report Builder and SSRS report authors. The secondary audience for this course are persons who are using Report Designer (SSRS). Course participants may be business analysts, programmer analysts, data analysts, database administrators, or IT professionals and may or may not have experience with Microsoft© SQL Server© Report Builder and SSRS, programming (Visual Basic), and/or Transact-Structured Query Language (T-SQL) experience. Overview After completing this course, students will be able to: Create parameter reports. Create list reports. Format reports with complex expressions. Add images and subreports. Add drilldown and drillthrough functionality. Add sparklines, data bars, and indicators. In this course, students will continue their learning on the foundations of report writing with Microsoft© SQL Server© Report Builder and SSRS. The focus will be on report creation by connecting to a database and manipulating the data. 1 - Parameter Reports Parameterized Reporting Create Report Parameters Modify Report Parameters Provide Default Parameter Values Provide Available Values for Parameters Lab: Creating Parameterized Reports 2 - List Data Regions Introducing the List Data Region Create Reports Using List Data Regions Modify Reports Which Use List Data Regions Lab: Creating List Reports 3 - Enhancing Reports with Complex Expressions Formatting Reports Top N Reports Running Values Lab: Enhancing Reports with Complex Expressions 4 - Enhance Reports with Images and Subreports Add Images to Reports Retrieve Images from a Database Introducing SSRS (SQL Server Reporting Services) Report Server Add Subreports to Reports Lab: Working With Images and Subreports 5 - Drilldown and Drillthrough Reports Add and Configure Drilldown Reporting Add and Configure Drillthrough Reporting Lab: Add Drilldown and Drillthrough Functionality to Reports 6 - Sparklines, Data Bars, and Indicators Sparklines Data Bars Indicators Lab: Adding Sparklines, Data Bars, and Indicators to Reports Additional course details: Nexus Humans 55128 Writing Reports with Report Builder and SSRS Level 2 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 55128 Writing Reports with Report Builder and SSRS Level 2 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.

55128 Writing Reports with Report Builder and SSRS Level 2
Delivered Online
£1,190

Complete VB.NET programming

5.0(3)

By Systems & Network Training

Complete VB.Net training course description A hands on introduction to programming in Visual BASIC .Net. What will you learn Build Visual BASIC applications. Build simple components Debug Visual BASIC programs. Examine existing code and determine its function. Complete VB.Net training course details Who will benefit: Anyone wishing to program in Visual BASIC. Anyone wishing to build Windows based applications. Prerequisites: None although experience in another high level language would be useful. Duration 5 days Complete VB.Net training course contents Writing your first program Visual Studio, forms designer, running VB programs, the UI, properties, writing the code. Toolbox Controls Basic use, input controls, ActiveX controls. Menus and Dialog Boxes Menus, Dialog Box controls, event procedures. Visual Basic .NET variables and operators Variables, I/O, data types, constants, operators, Math Methods, precedence. Decision Structures and Loops and Timers Event-Driven programming, If…Then, Select Case, For…Next Loops, Timer Control. Debugging Visual Basic .NET Programs Break Mode, watch & command windows. Structured Error Handling Try...Catch, Finally, Err Object, retry periods. Modules and Procedures Standard modules, public variables, procedures. Arrays and Collections to Manage Data Fixed-Size & dynamic Arrays, ReDim Preserve, object collections, Controls Collection. Text Files and String Processing Text Box object, Text String methods, sorting. Automating Office Applications Application objects, automation in VB, the Object Browser, the Process Component. Deploying Visual Basic .NET Applications Planning a deployment, ways to deploy an application, deployment projects, options. Managing Windows Forms Forms, positioning, manipulation, adding controls, organizing controls, Startup Object. Adding Graphics and Animation Effects System.Drawing namespace, coordinates, SystemPaint Event, animation, transparency. Inheriting Forms and Creating Base Classes Inheriting forms, inheritance picker, base classes and inheritance, classes in projects. Working with Printers PrintDocument class, Text Box object, Print Preview and Page Setup Dialog Boxes. Database programming with ADO.NET Databases, ADO.NET, Data Adapters, Datasets, Bound & Navigation Controls. Displaying database records, formatting DataGrid cells, updating the database. Displaying HTML Documents Using IE IE Object, Internet Controls, IE Events. Web Forms for Interactive Web Applications ASP.NET, Web Forms vs. Windows Forms, HTML controls, web applications, event procedures for web forms controls.

Complete VB.NET programming
Delivered in Internationally or OnlineFlexible Dates
£3,697

Programming AutoCAD to Excel Using VB.NET

4.8(9)

By Skill Up

Master the in-demand AutoCAD to excel-VB.NET programming by taking part in this all-encompassing Programming AutoCAD to Excel Using

Programming AutoCAD to Excel Using VB.NET
Delivered Online On Demand9 hours 21 minutes
£25