- Professional Development
- Medicine & Nursing
- Arts & Crafts
- Health & Wellbeing
- Personal Development
64 Programming courses in Horley
VBA in Excel - Part 1
By Underscore Group
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
General Anxiety and Phobia Specialist Coaching
By Creature Courage
Freedom In Courage is a specialised anxiety coaching service using powerful neuro science to radically liberate the mind from fear and worry.
Selling with NLP (In-House)
By The In House Training Company
Take your sales people from average to high performance. Motivate and develop experienced sales professionals with some new insights and learning. Applying NLP principles, techniques and models, this workshop will introduce the core attitudes and behaviours that differentiate the excellent sales person from the average one. The programme will help participants: Understand and adopt the mindset and beliefs needed for sales excellence Build rapport and connect with buyers at a deeper and more personal level Recognise some of the thinking and language patterns that make each individual unique Ask powerful questions to further understand the unique world of the individual and how they make decisions Apply tools and techniques to empathise with clients - seeing things from their perspectives Tailor their sales approach to the individual buyer's style, and talk in their language Influence with integrity and sell to organisations and individuals successfully 1 Introduction Aims and objectives of the programme Personal introductions and objectives Workshop overview 2 An introduction to NLP and sales excellence with NLP An overview of NLP and applying it to selling The pillars of NLP The NLP model of communication The difference that makes the difference 3 Building enhanced rapport Defining rapport and why it is important when selling Going beyond the initial small talk Building relationships with individual decision-makers Matching and mirroring Levels of rapport 4 Understanding the buyer's personal buying map How we take in, filter and process information How we judge others based on our own experiences of the world The different ways in which we communicate when selling Recognising and understanding the language and thinking patterns of others Adapting your sales communication style to different buyers 5 Making sense of the buying process How we filter information through our senses Understanding how we see, hear and experience the world Visual, auditory and kinaesthetic buyers Listening for key insights What different buyers want from you to help them to buy Applying sensory awareness to the sales process 6 Successful sales mindset The connection between thoughts and actions The sales beliefs of excellence Identifying negative thoughts and beliefs that are holding you back How to change your mindset Adopting the sales beliefs of excellence 7 Powerful questions Reviewing and honing your questioning skills Understanding the questions that great sales people ask Avoiding assumptions Clean language questions Getting to the bottom of it - precision questions Turbo-charging how you qualify 8 Influencing with integrity Understanding empathy Stepping into the buyer's shoes Speaking the buyer's language Tailoring your sales approach to the individual Match, pace, lead - how to take your buyer with you 9 Putting it all together Personal learning summary and action plans
Online Options
Show all 2379Digital CCTV and Remote Access Course
By Hi-Tech Training
The Digital CCTV & Remote Access course is designed to give participants a practical knowledge of integrating Analogue and Digital technologies in addition to access and control from remote locations such as laptops, tablets and mobile phones.
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.
Ruby Programming For Everyone
By Packt
In this course, you'll learn the Ruby programming language from absolute beginner to advanced - in no time at all!
Python Programming
By Packt
You will master the fundamentals and more advanced principles of Python programming in this beginner's tutorial. This Python course covers every Python fundamental, including installation and more complex material such as Python data science.
Project-Based Python Programming For Kids and Beginners
By Packt
Learn Python programming by developing robust GUIs and games
Ruby and Javascript Programming Bundle
By Packt
Learn the Ruby programming language and JavaScript coding from beginner to intermediate for web development - fast!
Groovy Programming Fundamentals for Java Developers
By Packt
In this course, we take you step by step through the most common features and programming idioms of the Groovy programming language, enabling you to supercharge your developer productivity by harnessing the power of Groovy's lightweight and succinct programming syntax.
Complete SAS Programming
By Course Cloud
The comprehensive Complete SAS Programming has been designed by industry experts to provide learners with everything they need to enhance their skills and knowledge in their chosen area of study. Enrol on the Complete SAS Programming today, and learn from the very best the industry has to offer! This best selling Complete SAS Programming has been developed by industry professionals and has already been completed by hundreds of satisfied students. This in-depth Complete SAS Programming is suitable for anyone who wants to build their professional skill set and improve their expert knowledge. The Complete SAS Programming 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 Complete SAS Programming 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 Complete SAS Programming, 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 Complete SAS Programming 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 Complete SAS Programming 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.
Neuro-Linguistic Programming (NPL)
By Course Cloud
Course Overview The comprehensive Neuro-Linguistic Programming (NPL) has been designed by industry experts to provide learners with everything they need to enhance their skills and knowledge in their chosen area of study. Enrol on the Neuro-Linguistic Programming (NPL) today, and learn from the very best the industry has to offer! This best selling Neuro-Linguistic Programming (NPL) has been developed by industry professionals and has already been completed by hundreds of satisfied students. This in-depth Neuro-Linguistic Programming (NPL) is suitable for anyone who wants to build their professional skill set and improve their expert knowledge. The Neuro-Linguistic Programming (NPL) 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 Neuro-Linguistic Programming (NPL) 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 Neuro-Linguistic Programming (NPL), 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 Neuro-Linguistic Programming (NPL) 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 Neuro-Linguistic Programming (NPL) 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.
