8432 Mode courses

This course is a standalone course for anyone interested in understanding how work to more effectively with others as a leader. It compliments other courses that explore emotional intelligence in more depth. You'll receive all the information that you need and will be coached using loads of practical hints that you can use straight away.

This intermediate- to advanced-level course will teach us to build our very own coffee shop application using iOS 16, Xcode 14, SwiftUI 4, and Firebase Firestore. The course will teach you to write clean and readable code and structure your app development that can easily be integrated with any coffee shop, fast food, or drink-serving service.

Duration 2 Days 12 CPD hours This course is intended for Server administrators Network engineers Systems engineers Consulting systems engineers Technical solutions architects Network administrators Storage administrators Network managers Sales engineers Cisco integrators and partners Overview After taking this course, you should be able to: Describe Cisco UCS server hardware Describe Cisco UCS connectivity Describe the Cisco HyperFlex Data Platform, its data writing and reading processes, and data optimization Describe and configure Cisco UCS service profiles Describe and configure Cisco UCS service profile templates Describe and implement iSCSI on Cisco UCS Describe and implement Cisco UCS firmware updates Describe and implement Cisco UCS backups This introductory course shows you how to deploy, secure, operate and maintain the Cisco Unified Computing system (Cisco UCS) B-Series blade server, Cisco UCS C-Series and S-Series rack servers, and Cisco HyperFlex product family, for use in data centers. Describing Cisco UCS Server Hardware Cisco UCS B-Series Blade Servers Cisco UCS C-Series Rack Servers Cisco UCS S-Series Rack Servers Cisco Virtual Interface Cards Hyperconvergence Overview Cisco HyperFlex HX-Series Servers Describing Cisco UCS Connectivity Cisco UCS Fabric Interconnect Cisco UCS B-Series Connectivity Cisco UCS C-Series Connectivity Cisco UCS S-Series Connectivity Cisco HyperFlex Connectivity Architecture Cisco HyperFlex Edge Connectivity Ethernet End-Host Mode Compared to Switching Mode Cisco UCS Fabric Interconnect Uplink Pinning Cisco UCS C-Series Integration Describing the Cisco HyperFlex HX Data Platform Cisco HyperFlex HX Data Platform Software Writing Data to Cisco HyperFlex HX Data Platform Reading Data from Cisco HyperFlex HX Data Platform Data Optimization in Cisco HyperFlex HX Data Platform Configuring Cisco UCS Service Profiles Portability Issue with Nonabstracted Identities Cisco UCS Service Profile Identity Pools Server Pools IP Pools Configuring Cisco UCS Service Profile Templates Service Profile Templates Implementing iSCSI on Cisco UCS iSCSI Addressing Evolution of SCSI from DAS to SAN iSCSI Multipathing Implementing Cisco UCS Firmware Updates Update Cisco UCS C-Series Server Firmware Download Tasks for the Infrastructure Image Download Tasks for Cisco UCS B-Series Firmware Packages Best Practices for Updating Firmware in Cisco UCS Manager Firmware Upgrades Using Auto Install Capability Catalog Updates Host Firmware Packages Driver Updates for Operating Systems and Hypervisors Implementing Cisco UCS Backups Compare Backup Options in Cisco UCS Manager Compare Two Import Types Policy Backup

With our course, 'Learn the Basics of Microsoft Visio in Only 30 minutes,' take a revolutionary step into the world of visual communication. You may discover a world of creativity and efficiency with Microsoft Visio by solving its mysteries in just thirty minutes. This isn't your ordinary tutorial; it's a creative expedition designed to captivate and empower learners in record time. From understanding the fundamentals of Visio to crafting intricate cross-functional flowcharts, each unit is a step towards mastery, ensuring you grasp the essence of this powerful tool effortlessly. Discover the art of adding shapes, texts, and connectors with finesse, enhance your diagrams with vibrant colors and styles, and explore advanced features like Containers and Themes. Whether you're a student, professional, or an enthusiast looking to enhance your visual storytelling skills, this course provides a concise and engaging roadmap to becoming a Microsoft Visio virtuoso in just 30 minutes. Don't miss the chance to elevate your communication game-enroll now and transform your understanding of visual representation! Learning Outcomes Visio Fundamentals Mastery: Grasp the core concepts of Microsoft Visio, from its purpose to the variety of templates available. Efficient Diagram Creation: Learn to start cross-functional flowcharts seamlessly, mastering the art of titles, swimlanes, and structured diagrams. Creative Element Integration: Explore the intricacies of adding shapes, texts, and connectors, enhancing your ability to craft visually appealing and informative diagrams. Advanced Features Utilization: Dive into the world of Containers, Themes, and Presentation Mode, unlocking the full potential of Visio for dynamic and professional diagramming. Web Collaboration Proficiency: Understand how to leverage Visio Web, enabling seamless collaboration and sharing of your visual creations. Why choose this Learn the Basics of Microsoft Visio in Only 30 minutes! course? Unlimited access to the course for a lifetime. Opportunity to earn a certificate accredited by the CPD Quality Standards and CIQ after completing this course. Structured lesson planning in line with industry standards. Immerse yourself in innovative and captivating course materials and activities. Assessments designed to evaluate advanced cognitive abilities and skill proficiency. Flexibility to complete the Course at your own pace, on your own schedule. Receive full tutor support throughout the week, from Monday to Friday, to enhance your learning experience. Unlock career resources for CV improvement, interview readiness, and job success. Who is this Learn the Basics of Microsoft Visio in Only 30 minutes! course for? Students looking to enhance their diagramming skills efficiently. Professionals seeking a quick and engaging introduction to Microsoft Visio. Enthusiasts interested in visual communication and storytelling. Project managers aiming to streamline communication through visual representation. Individuals wanting to boost their efficiency in creating structured and visually appealing diagrams. Career path Project Coordinator: £25,000 - £35,000 Technical Writer: £28,000 - £40,000 Graphic Designer: £22,000 - £35,000 Business Analyst: £30,000 - £45,000 Process Improvement Specialist: £35,000 - £50,000 Information Architect: £40,000 - £55,000 Prerequisites This Learn the Basics of Microsoft Visio in Only 30 minutes! does not require you to have any prior qualifications or experience. You can just enrol and start learning. This Learn the Basics of Microsoft Visio in Only 30 minutes! 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. Certification After studying the course materials, there will be a written assignment test which you can take at the end of the course. After successfully passing the test you will be able to claim the pdf certificate for £4.99 Original Hard Copy certificates need to be ordered at an additional cost of £8. Course Curriculum Learn The Basics Of Microsoft Visio In Only 30 Minutes! Unit 01: What is Microsoft Visio? 00:01:00 Unit 02: Where to get Microsoft Visio 00:02:00 Unit 03: Starting Visio and Templates 00:06:00 Unit 04: Starting a Cross-Functional Flowchart 00:03:00 Unit 05: Title and Swimlanes 00:02:00 Unit 06: Add Shapes, Texts and Connectors 00:09:00 Unit 07: Insert Containers 00:01:00 Unit 08: Shape Colors and Styles 00:02:00 Unit 09: Themes 00:01:00 Unit 10: Alignment and Spacing 00:01:00 Unit 11: Add Pages 00:01:00 Unit 12: Presentation Mode 00:01:00 Unit 13: Visio Web 00:03:00

Duration 5 Days 30 CPD hours This course is intended for Storage and virtual infrastructure consultants, solution architects, and administrators who are responsible for production support and administration of VMware vSAN. Overview By the end of the course, you should be able to meet the following objectives: Describe vSAN concepts Detail the underlying vSAN architecture and components Explain the key features and use cases for vSAN Identify requirements and planning considerations for vSAN clusters Explain the importance vSAN node hardware compatibility Describe the use of VMware vSphere Lifecycle Manager™ to automate driver and firmware installations Describe the different vSAN deployment options Explain how to configure vSAN fault domains Detail how to define and create a VM storage policy Discuss the impact of vSAN storage policy changes Detail vSAN resilience and data availability Describe vSAN storage space efficiency Explain how vSAN encryption works Identify requirements to configure the vSAN iSCSI target Detail VMware HCI Mesh™ technology and architecture Detail vSAN File Service architecture and configuration Explain the use cases of vSAN Direct Configuration™ Describe how to setup a stretched and a two-node vSAN cluster Discuss vSAN cluster backup methodology Describe vSAN maintenance mode and data evacuation options Define the steps to shut down a vSAN cluster for maintenance Explain how to use proactive tests to check the integrity of a vSAN cluster Use VMware Skyline Health™ for monitoring vSAN health During this five-day course, you will gain the knowledge, skills, and tools to plan and deploy a VMware vSAN? cluster. You will learn about managing and operating vSAN. This course focuses on building the required skills for common Day-2 vSAN administrator tasks such as vSAN node management, cluster maintenance, security operations, and advanced vSAN cluster operations. You will learn these skills through the completion of instructor-led activities and hands-on lab exercises. Course Introduction Introductions and course logistics Course objectives Introduction to vSAN Describe vSAN architecture Describe the vSAN software components: CLOM, DOM, LSOM, CMMDS, and RDT Identify vSAN objects and components Describe the advantages of object-based storage Describe the difference between All-Flash and Hybrid vSAN architecture Explain the key features and use cases for vSAN Discuss the vSAN integration and compatibility with other VMware technologies Planning a vSAN Cluster Identify requirements and planning considerations for vSAN clusters Apply vSAN cluster planning and deployment best practices Determine and plan for storage consumption by data growth and failure tolerance Design vSAN hosts for operational needs Identify vSAN networking features and requirements Describe ways of controlling traffic in a vSAN environment Recognize best practices for vSAN network configurations Deploying a vSAN Cluster Recognize the importance of hardware compatibility Ensure the compatibility of driver and firmware versioning Use tools to automate driver validation and installation Apply host hardware settings for optimum performance Use vSphere Lifecycle Manager to perform upgrades Deploy and configure a vSAN Cluster using the Cluster QuickStart wizard Manually configure a vSAN Cluster using VMware vSphere© Client? Explain and configure vSAN fault domains Using VMware vSphere© High Availability with vSAN Understand vSAN Cluster maintenance capabilities Describe the difference between implicit and explicit fault domains Create explicit fault domains vSAN Storage Policies Describe a vSAN object Describe how objects are split into components Explain the purpose of witness components Explain how vSAN stores large objects View object and component placement on the vSAN datastore Explain how storage policies work with vSAN Define and create a virtual machine storage policy Apply and modify virtual machine storage policies Change virtual machine storage policies dynamically Identify virtual machine storage policy compliance status vSAN Resilience and Data Availability Describe and configure the Object Repair Timer advanced option Plan disk replacement in a vSAN cluster Plan maintenance tasks to avoid vSAN object failures Recognize the importance of managing snapshot utilization in a vSAN cluster Configuring vSAN Storage Space Efficiency Discuss deduplication and compression techniques Understand deduplication and compression overhead Discuss compression only mode Configure erasure coding Configure swap object thin provisioning Discuss reclaiming storage space with SCSI UNMAP Configure TRIM/UNMAP vSAN Security Operations Identify differences between VM encryption and vSAN encryption Perform ongoing operations to maintain data security Describe the workflow of data-in transit encryption Identify the steps involved in replacing Key Management Server Introduction to Advanced vSAN Configurations Identify requirements to configure vSAN iSCSI target Detail VMware HCI Mesh technology and architecture Detail vSAN File Service architecture and configuration Explain the use cases of vSAN Direct Configuration vSAN Cluster Maintenance Perform typical vSAN maintenance operations Describe vSAN maintenance modes and data evacuation options Assess the impact on cluster objects of entering maintenance mode Determine the specific data actions required after exiting maintenance mode Define the steps to shut down and reboot hosts and vSAN clusters Use best practices for boot devices Replace vSAN nodes vSAN Stretched and Two Node Clusters Describe the architecture and uses case for stretched clusters Detail the deployment and replacement of a vSAN witness node Describe the architecture and uses case for two-node clusters Explain the benefits of vSphere HA and vSphere Site Recovery Manager in a vSAN stretched cluster Explain storage policies for vSAN stretched cluster vSAN Cluster Monitoring Describe how the Customer Experience Improvement Program (CEIP) enables VMware to improve products and services Use VMware Skyline Health for monitoring vSAN cluster health Manage alerts, alarms, and notifications related to vSAN in VMware vSphere© Client? Create and configure custom alarms to trigger vSAN health issues Use IOInsight metrics for monitoring vSAN performance Analyse vsantop performance metrics Use a vSAN proactive test to detect and diagnose cluster issues Additional course details:Notes Delivery by TDSynex, Exit Certified and New Horizons an VMware Authorised Training Centre (VATC) Nexus Humans VMware vSAN: Install, Configure, Manage [V7] 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 vSAN: Install, Configure, Manage [V7] 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.

Highlights of the Course Course Type: Online Learning Duration: 1 Hour 17 Minutes Tutor Support: Tutor support is included Customer Support: 24/7 customer support is available Quality Training: The course is designed by an industry expert Recognised Credential: Recognised and Valuable Certification Completion Certificate: Free Course Completion Certificate Included Instalment: 3 Installment Plan on checkout What you will learn from this course? Gain comprehensive knowledge about CNC programming Understand the core competencies and principles of CNC programming Explore the various areas of CNC programming Know how to apply the skills you acquired from this course in a real-life context Become a confident and expert industrial or manufacturing engineer Introduction to CNC Programming Course Master the skills you need to propel your career forward in CNC programming. This course will equip you with the essential knowledge and skillset that will make you a confident industrial or manufacturing engineer and take your career to the next level. This comprehensive CNC Programming course is designed to help you surpass your professional goals. The skills and knowledge that you will gain through studying this CNC Programming course will help you get one step closer to your professional aspirations and develop your skills for a rewarding career. This comprehensive course will teach you the theory of effective CNC programming practice and equip you with the essential skills, confidence and competence to assist you in the CNC programming industry. You'll gain a solid understanding of the core competencies required to drive a successful career in CNC programming. This course is designed by industry experts, so you'll gain knowledge and skills based on the latest expertise and best practices. This extensive course is designed for industrial or manufacturing engineer or for people who are aspiring to specialise in CNC programming. Enrol in this CNC Programming course today and take the next step towards your personal and professional goals. Earn industry-recognised credentials to demonstrate your new skills and add extra value to your CV that will help you outshine other candidates. Who is this Course for? This comprehensive CNC Programming course is ideal for anyone wishing to boost their career profile or advance their career in this field by gaining a thorough understanding of the subject. Anyone willing to gain extensive knowledge on this CNC programming can also take this course. Whether you are a complete beginner or an aspiring professional, this course will provide you with the necessary skills and professional competence, and open your doors to a wide number of professions within your chosen sector. Entry Requirements This CNC Programming course has no academic prerequisites and is open to students from all academic disciplines. You will, however, need a laptop, desktop, tablet, or smartphone, as well as a reliable internet connection. Assessment This CNC Programming course assesses learners through multiple-choice questions (MCQs). Upon successful completion of the modules, learners must answer MCQs to complete the assessment procedure. Through the MCQs, it is measured how much a learner could grasp from each section. In the assessment pass mark is 60%. Advance Your Career This CNC Programming course will provide you with a fresh opportunity to enter the relevant job market and choose your desired career path. Additionally, you will be able to advance your career, increase your level of competition in your chosen field, and highlight these skills on your resume. Recognised Accreditation This course is accredited by continuing professional development (CPD). CPD UK is globally recognised by employers, professional organisations, and academic institutions, thus a certificate from CPD Certification Service creates value towards your professional goal and achievement. Course Curriculum Introduction Scope of the Course 00:02:00 Numerical Control of Machine Tools 00:04:00 Types of CNC machines CNC - Computer Numerical Control System 00:02:00 Components of CNCs 00:04:00 Point to Point CNC Machines 00:02:00 Incremental & Absolute CNC Machines 00:02:00 Open & Close Control Loop CNC Machines 00:02:00 2 & 3 Axes CNC Machines 00:01:00 Importance of Higher Axes Machining 00:02:00 CNC Programming Programming Format 00:05:00 Cartesian Coordinate System 00:03:00 How to Write a Program 00:08:00 Basic CNC Programming (Absolute Mode) 00:09:00 Basic CNC Programming (Incremental Mode) 00:04:00 A Simple Coding Exercise 00:17:00 Way Forward Applications of CNC 00:06:00 Obtain Your Certificate Order Your Certificate of Achievement 00:00:00 Get Your Insurance Now Get Your Insurance Now 00:00:00 Feedback Feedback 00:00:00

Description Genetics Diploma  Our genes are the basis of our being. They partially determine our hair, eye colour, weight, height, and talents. Recently, scientists have begun utilising genetic information to diagnose, cure, and prevent diseases. Students of genetic studies with high degrees and different qualifications are opening many doors for themselves regarding their careers or profession. The distance mode Genetics Diploma course by Elearncollege can be the perfect first step towards this. Modules of randomness, variation, susceptibility, and adaptability will be presented to the learner. The knowledge taught through this course will provide a solid foundation for students who wish to proceed to higher studies in the field. This Genetics Diploma course is specially tailored to fit students interested in moving forward to higher levels of genetics studies. It is also suited to individuals already employed as healthcare professionals and who desire to widen their knowledge about human genetics. The Genetics Diploma course is designed to be studied from the comfort of your home. It does not matter if you do not have prior knowledge of genetics. Signing up for the course does not require you to have any previous training in the discipline. The only thing the students need is access to the course materials, which will be provided online. By completing this programme, students will have developed a thorough understanding of genetics studies' basics and the impacts they have on us. The students can go to higher studies in the discipline through distance learning or at universities. Continuing higher education in the domain right up to the advanced level will open up a whole new world filled with opportunities that the students are free to explore. Training in this field can lead to employment as a researcher, a lecturer, and geneticist, and an array of other professions related to the study of genetics. What you will learn   1: Introduction to DNA  2: Chromosomes and mutations 3: DNA in organisms  4: DNA replication and making cells  5: Inheritance of traits  6: Special inheritance patterns  7: Epigenetics and disease risk  8: Beginnings of early humans and evolution  9: Pharmacogenomics and antibiotics  10:Genetically modified crops and engineered tools  Course Outcomes After completing the course, you will receive a diploma certificate and an academic transcript from Elearn college. Assessment Each unit concludes with a multiple-choice examination. This exercise will help you recall the major aspects covered in the unit and help you ensure that you have not missed anything important in the unit. The results are readily available, which will help you see your mistakes and look at the topic once again. If the result is satisfactory, it is a green light for you to proceed to the next chapter. Accreditation Elearn College is a registered Ed-tech company under the UK Register of Learning( Ref No:10062668). After completing a course, you will be able to download the certificate and the transcript of the course from the website. For the learners who require a hard copy of the certificate and transcript, we will post it for them for an additional charge.

3ds max professional one to one 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

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