1528 Courses delivered Live Online

Why Learn Autodesk Maya Basics to Advanced Level Course? Course info. Autodesk Maya is one of the best tools for 3D animation and visual effects. Learn Maya with our training courses covering sectors like Architecture, Games & Films, Animation, and Media. London Design Training Courses empower you to master Maya, transforming your 3d skills.  Duration: 40 hrs Method: 1-on-1. Schedule: Tailor your own schedule by pre-booking a convenient hour of your choice, available from Mon to Sat 9 am and 7 pm. Experience advanced-level Maya training covering essential aspects such as modeling, UV mapping, texturing, lighting, camera movement, and rigging. The course is tailored to your specific requirements and work preferences. You can discuss your learning goals with our trainer, and we will suggest a syllabus that meets your needs. Flexible Training Options: Choose in-class training at one of our UK center or attend live online sessions. Certified Tutors and Authoritative: London Design Training Course has all Autodesk Authorized Trainers. Hands-on Learning Approach: The training is practical and hands-on, combining theory and step-by-step demonstrations. You'll have ample time to practice techniques on your computer with Maya, and you can keep all the files you create. Compatible with Windows and Mac: Maya training is available for both Windows and Mac users, with options to suit any recent version of Maya. Maya Basic to Advanced Course Duration: 40 hours Course Description: In this course, you will learn the fundamental and advanced skills to create complex 3D models and animations using Autodesk Maya software. You will gain knowledge of the Maya interface, tools, and workflow. You will learn the essentials of modeling, texturing, rigging, animating, and rendering 3D models. You will also learn how to create advanced special effects and understand advanced modeling techniques. I. Introduction to Maya (3 hours) Overview of Maya and its Uses Maya interface and basic tools Navigation and viewport controls Creating and saving projects II. Basic Polygon Modeling (6 hours) Polygon modeling basics Creating basic shapes and objects Editing and modifying objects Creating complex objects with extrusions and bevels Creating organic shapes with NURBS III. Intermediate Modeling (6 hours) Advanced polygon modeling techniques Creating complex models with Booleans and deformers Creating and modifying curves and surfaces Creating organic shapes with sculpting tools Creating architectural models IV. Texturing and Materials (6 hours) Introduction to texturing Creating and applying materials Texture mapping and UV unwrapping Creating realistic materials with shaders Painting textures with the 3D paint tool V. Lighting and Rendering (6 hours) Basic lighting techniques Advanced lighting techniques Creating realistic lighting environments Setting up a camera and creating a composition Rendering still images and animations Output options and file formats VI. Animation (9 hours) Introduction to animation Keyframe animation and animation curves Creating and editing animation clips Rigging and animating a simple character Creating and editing motion paths and animation layers Creating complex character rigs Creating lip sync and facial animation Creating realistic animation with dynamics and simulations Cloth Animation Ncloth VII. Rigging (4 hours) Introduction to rigging Creating joints and skeletons Binding skin to joints and creating weight maps Creating simple rigging systems and rigging a character Creating complex rigging systems VIII. Special Effects (4 hours) Particle systems and dynamics Creating and manipulating fluids and fire effects Creating and editing special effects like explosions and smoke Creating advanced simulations with nCloth and nParticles Paint effects Mash Networks and Mash Animation IX. Advanced Rendering Techniques (2 hours) Render layers and passes Global illumination and ambient occlusion Mental Ray rendering and settings X. Conclusion and Next Steps (1 hour) Review of course content Tips for further learning and resources Q&A; and feedback Note: The above course outline is just a suggestion, and the course content and duration can be adjusted according to the needs and level of the learners. Proficiency in Advanced Maya Techniques: Participants will gain advanced skills in various aspects of Maya, including modeling, UV mapping, texturing, lighting, camera movement, and rigging. Tailored Training: The course is customized to meet the specific requirements of participants, focusing on their preferred techniques and work type. Hands-On and Practical Experience: The training is practical and hands-on, allowing participants to practice techniques on their own computers with Maya. Versatility in Operating Systems: Participants will be equipped to use Maya on both Windows and Mac systems. Accredited Certification: Upon successful completion, participants will receive an e-certificate, accredited by Autodesk Certified instructor, confirming their achievement in the Maya training course. Post-Course Support: After the training, participants are entitled to 30 days of email support from their Maya trainer, ensuring assistance with any post-course questions or issues. Up-to-Date and Relevant Learning: The training can be based on any recent version of Maya, providing participants with up-to-date knowledge and skills.

Duration 5 Days 30 CPD hours This course is intended for The audience includes implementers, developers, system administrators, project teams, database administrators and engine project technical teams. The audience also includes consultants that are looking to gain an understanding of Maximo Asset Management 7.6.0.x and the engine. Overview After completing this course, you should be able to perform the following tasks: List the components of Tivoli's process automation engine Understand Maximo modules and applications Understand Tivoli's Process Automation Engine Create the foundation data necessary for Maximo Asset Management Customize the engine database and applications Automate IBM Service Management applications using workflows Use the Maximo Work Centers Use the Integration Framework to import and export data This course is designed for anyone planning to use Maximo Asset Management and Tivoli?s process automation engine with one of the IBM System Management (ISM) products. It is a course that introduces you to the features and functions of both products. IBM Maximo Asset Management Overview This unit focuses on Maximo as an overall product and how Maximo assists companies with their asset management lifecycle. Tivoli Process Automation Engine This unit describes the functions of Tivoli?s process automation engine and introduces the products that are based on the engine. This unit also introduces Start Centers and basic navigation. Architecture and components This unit covers the architecture of Tivoli?s process automation engine. The various components that make up the system are described. The unit will address Java EE servers and the basic use of WebSphere© as it relates to the engine. The unit then covers the organization of the administrative workstation and system properties. The unit briefly describes the setup of the system for using attachments. Foundation Data This unit covers the creation of foundation data for Tivoli?s process automation engine. The foundation data is the software constructs that are necessary in the basic configuration of the product. These constructs include organizations, sites, locations, classifications, and various engine financial configurations. Security Security addresses the need to protect system resources from unauthorized access by unauthenticated users. Resources in the system are protected by Authentication and Authorization. Database architecture This unit illustrates the possible database configurations using the Database Configuration application. It also presents specific command lines that you can run to configure the changes made on the attributes of business objects using the Database Configuration application. Work Management Work Management is a collection of components and products that work together to form a powerful process and work management system. This unit provides a look at work management and focuses on using Work Management to generate, process, and complete work orders. Customizing an application This unit provides an overview of the Application Designer and Migration Manager. You will learn how to change, duplicate and create applications. You will learn the process to move from development, integration testing, user acceptance testing and moving to production. Automation This unit provides a high-level overview of key automation application programs and their functionality. It describes cron tasks, which are used to automate jobs in the system. The unit then discusses various communication tools in the system such as Communication Templates and the E mail Listener application. Finally, automated means of notification using escalations and actions are covered. Workflow This unit focuses on workflow. You learn about the Workflow Designer and its tools. You also learn how to modify an existing workflow and how to manage the included workflows. Reporting This unit provides an overview of the data analysis and reporting options that you can use in the system to analyze data. You create query by example (QBE) reports, result sets, key performance indicators (KPI), and query-based reports (QBRs). Students can optionally review Appendix A to learn how to create a simple enterprise report using Business Intelligence Reporting Tools (BIRT) designer. This report provides an example of how developers create more complex, widely used reports for users. Integration Framework In this unit, a high-level overview of the Integration Framework is provided. The Integration Framework architecture and components are described and basic configuration steps are described. The configuration and steps for loading and exporting data to and from the system are covered. You have the opportunity to practice them also. Budget Monitoring This unit provides information on a new feature introduced in Maximo 7.6.0.8, the Budget Monitoring application. In this application, you can create budget records to monitor transactions in a financial period. Inspection Tools and Tasks This unit introduces the new Inspection application. You can use the Inspections tools to create online inspection forms by using your desktop computer or laptop, and you can use the forms to complete an inspection by using your desktop computer, laptop, or tablet. Troubleshooting This unit focuses on troubleshooting as a systematic approach to solving a problem. The goal is to determine why something does not work as expected and to resolve the problem. It discusses the configuration of logging in the application. It also covers basic troubleshooting techniques, some important component logs, and information about obtaining help from Tivoli Support. Additional course details: Nexus Humans U5TR712 - IBM Maximo Asset Management - System Administration and Development v7.6x 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 U5TR712 - IBM Maximo Asset Management - System Administration and Development v7.6x course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you. Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.

Duration 2 Days 12 CPD hours This course is intended for The target audience for the DevOps Test Engineering course is anyone involved in defining a DevOps Testing strategy, such as: Delivery Staff DevOps Engineers IT Managers Project Managers Lab Staff Maintenance and Support Staff Quality Assurance Managers Quality Assurance Teams Release Managers Testers Software Engineers Overview The learning objectives for DTE include a practical understanding of: The purpose, benefits, concepts and vocabulary of DevOps testing How DevOps testing differs from other types of testing DevOps testing strategies, test management and results analysis Strategies for selecting test tools and implementing test automation Integration of DevOps testing into Continuous Integration and Continuous Delivery workflows How DevOps testers fit with a DevOps culture, organization and roles This comprehensive course addresses testing in a DevOps environment and covers concepts such as the active use of test automation, testing earlier in the development cycle, and instilling testing skills in developers, quality assurance, security, and operational teams. The course is relevant for every modern IT professional involved in defining or deploying a DevOps testing strategy for their organization, as test engineering is the backbone of DevOps and the primary key for successful DevOps pipeline to support digital transformation. This course prepares you for the Continuous Testing Foundation(CTF) certification. Course Objectives and Modules, Logistics What is DevOps Testing and its Business Benefits?Relation of DevOps Testing in other Test MethodologiesDevOps Testing Best Practices DevOps Testing Terminology Culture changes Organization changes Process and team friction Motivation strategies Measuring Success Continuous Evolution Troubleshooting What is the DevOps pipeline? DevOps Testing on the pipeline Test strategy choices Pre-Flight strategies Continuous Integration Testing System, Delivery and Customer Testing Test Environments Lab Management Topology orchestration Test Automation Frameworks Test Tools Selection criterion Automated metrics Key concepts Test Case Best Practices & Design Exercise Test Suite Best Practices & Design Exercise Principles of DevOps Management DevOps Test Management Metrics DevOps Management Tools DevOps Test Results Analysis Integrating DevOps Results Analysis Test Management Exercise Fictitious Product Test Requirements Individual Exercise Class discussion Exam Preparation

Duration 4 Days 24 CPD hours Overview Topics Include:Installation of a multi-node Kubernetes cluster using kubeadm, and how to grow a cluster.Choosing and implementing cluster networking.Various methods of application lifecycle management, including scaling, updates and roll-backs.Configuring security both for the cluster as well as containers.Managing storage available to containers.Learn monitoring, logging and troubleshooting of containers and the cluster.Configure scheduling and affinity of container deployments.Use Helm and Charts to automate application deployment.Understand Federation for fault-tolerance and higher availability. In this vendor agnostic course, you'll learn the installation, configuration and administration of a production-grade Kubernetes cluster. Introduction Linux Foundation Linux Foundation Training Linux Foundation Certifications Laboratory Exercises, Solutions and Resources Distribution Details Labs Basics of Kubernetes Define Kubernetes Cluster Structure Adoption Project Governance and CNCF Labs Installation and Configuration Getting Started With Kubernetes Minikube kubeadm More Installation Tools Labs Kubernetes Architecture Kubernetes Architecture Networking Other Cluster Systems Labs APIs and Access API Access Annotations Working with A Simple Pod kubectl and API Swagger and OpenAPI Labs API Objects API Objects The v1 Group API Resources RBAC APIs Labs Managing State With Deployments Deployment Overview Managing Deployment States Deployments and Replica Sets DaemonSets Labels Labs Services Overview Accessing Services DNS Labs Volumes and Data Volumes Overview Volumes Persistent Volumes Passing Data To Pods ConfigMaps Labs Ingress Overview Ingress Controller Ingress Rules Labs Scheduling Overview Scheduler Settings Policies Affinity Rules Taints and Tolerations Labs Logging and Troubleshooting Overview Troubleshooting Flow Basic Start Sequence Monitoring Logging Troubleshooting Resources Labs Custom Resource Definition Overview Custom Resource Definitions Aggregated APIs Labs Kubernetes Federation Overview Federated Resources Labs Helm Overview Helm Using Helm Labs Security Overview Accessing the API Authentication and Authorization Admission Controller Pod Policies Network Policies Labs

Why Learn Game Designing Training Course 3ds Max and Unity 3D? Click for more info Learn Game Designing with 3ds Max and Unity 3D for industry demand, 3d and 2d skills, game design, AR/VR projects, game programming, and 3d visualization. Enhance your career in the thriving gaming and interactive media industry. Duration: 40 hrs. Method: 1-on-1 & Tailored content. Schedule: Tailor your own schedule by pre-booking a convenient hour of your choice, available from Mon to Sat 9 am and 7 pm. Explore the World of Unity 3D with Our Training Courses Unity is a robust cross-platform game development engine, responsible for creating a significant portion of the world's games. Learn ultimate game development platform to build top-notch 3D & 2D games, deployable on mobile, desktop, VR/AR, consoles, or the Web. The opportunities are limitless. Led by certified and experienced Unity instructors, our training courses are filled with practical, real-world exercises. 40-hour Game Designing Training Course with 3ds Max and Unity 3D: Course Overview: Module 1: Introduction to 3ds Max and Unity 3D (4 hours) Get acquainted with 3ds Max and Unity 3D interfaces and workflows Efficiently set up and manage projects Master importing and handling assets Module 2: 3D Modeling with 3ds Max (8 hours) Dive into 3D modeling techniques Create stunning 3D models using 3ds Max Explore polygonal, spline, and NURBS modeling Enhance models with textures and materials Module 3: Animation and Rigging with 3ds Max (8 hours) Understand animation techniques in 3ds Max Rig 3D models for smooth animations Bring creations to life with keyframe animation Employ procedural animation methods Export animations for Unity 3D integration Module 4: Game Design with Unity 3D (8 hours) Learn the Unity 3D game engine Grasp essential game mechanics and concepts Create and manage game scenes and levels Master control of game objects and components Utilize physics and collision detection for immersive experiences Module 5: Scripting and Programming with Unity 3D (8 hours) Introduce Unity 3D scripting with C# Understand variables, data types, and functions in C# Control game objects and components using C# Explore game loops and events for interactive gameplay Module 6: User Interfaces and Audio with Unity 3D (4 hours) Design captivating user interfaces within Unity 3D Implement interactive buttons, sliders, and input fields Elevate games with audio import and editing Control sound effects and background music Module 7: Optimization and Deployment (4 hours) Master game optimization in Unity 3D Enhance game performance through scripting techniques Build and test games for various platforms Publish games on the web or app stores Game Designing Training Course 3ds Max and Unity 3D (Live Online Only): Explore advanced 3ds Max techniques for modeling, lighting, and cameras Dive into character animation for lifelike characters Enhance Unity 3D skills with real-time development and game authoring settings Unity - Real-time 3D Development Platform: Unlock Your Creativity https://www.unity.com/ Create 3D, 2D, VR & AR Experiences For Any Industry: Games, Auto, AEC, Film, And More. Complete Solution To Develop Better, Iterate Faster, And Grow Your Business. Amazing Games. Immersive Experiences. Multi-Platform Support. 3ds Max Free Trial | Autodesk Download a free 30-day trial of 3ds Max, 3D modeling, and rendering software for design visualization, games, and animation.

Construction Management Level 6 Course Overview The "Construction Management Level 6" course is designed to equip learners with the advanced skills required to effectively manage complex construction projects. Covering key areas such as project planning, risk management, construction law, and resource management, this course provides a comprehensive understanding of the construction industry's dynamic nature. Learners will gain the ability to oversee large-scale projects, ensuring they are delivered on time, within budget, and to the highest standards. By the end of the course, students will be well-prepared to handle the challenges of modern construction management, making them valuable assets to employers in this growing sector. Course Description The "Construction Management Level 6" course dives deep into critical areas such as strategic planning, cost estimation, scheduling, procurement, and construction laws, among others. Learners will explore how to manage construction projects from inception through to completion, with an emphasis on risk mitigation, leadership, and regulatory compliance. The course is structured to provide learners with the knowledge to supervise complex construction processes, ensuring quality control and project delivery. Through engaging materials and structured modules, students will gain the expertise to take on senior roles in the construction sector, focusing on project efficiency, safety, and sustainability. Construction Management Level 6 Curriculum Module 01: Construction Management (See full curriculum) Who is this course for? Individuals seeking to advance in construction project management. Professionals aiming to specialise in construction management. Beginners with an interest in the construction industry. Those looking to gain qualifications for senior management roles. Career Path Construction Project Manager Site Manager Construction Director Quantity Surveyor Contract Manager Estimator Construction Consultant

Why Learn 3ds Max Basic to Advanced Training Course? Learn 3ds max design and animation with our comprehensive 3ds Max Basic to Advanced Training Course. Whether you're a beginner or an experienced user, this course is thoughtfully designed to elevate your skills. Course Link Duration: 40 hrs Method: 1-on-1, Personalized attention & Tailored content. Schedule: 1-on-1 training with flexible scheduling. Book a convenient hour, Mon to Sat, from 9 am to 7 pm. Course Details: Course Duration: 40 hours Course Syllabus: Part 1: Introduction to 3ds Max and Vray Familiarization with the 3ds Max Interface Configuring an efficient workspace in 3ds Max Seamless navigation within 3ds Max and Vray Understanding the power of Vray and its interface Part 2: 3D Modeling Precision crafting of fundamental shapes Mastering modifiers for advanced modeling Creating intricate 3D models using diverse techniques Learning the art of polygonal modeling Shaping both organic and inorganic models flawlessly Part 3: Texturing Applying and refining textures with expertise Grasping the essentials of UVW mapping Harnessing material editor to perfection Customizing materials with Vray materials Part 4: Lighting Discovering the magic of illumination Differentiating various light types Comprehending the subtleties of light properties Setting up captivating scenes with Vray lights Part 5: Animation Embarking on an animation adventure Expertly setting up keyframes and animation curves Infusing life into objects in a mesmerizing 3D space Elevating animations with Vray's prowess Part 6: Advanced Rendering with Vray Entering the realm of rendering excellence Mastering Vray Global Illumination for realism Optimizing visuals with Vray Physical Cameras Illuminating scenes with Vray HDRI Lighting Employing Vray Proxies and Render Elements for finesse Streamlining rendering workflow with Vray's techniques Part 7: Projects Showcasing skills through hands-on projects Crafting a captivating yet simple interior scene Designing an alluring exterior scene Taking on the challenge of a complex scene with multiple elements Course Requirements: A computer with 3ds Max and Vray installed (trial versions are available on Autodesk and Chaos Group websites) Basic knowledge of computer operations Enthusiasm for 3D modeling and animation Course Objectives: Upon completing the course, you will have mastered 3ds Max and Vray, enabling you to create photorealistic 3D scenes. The skills acquired will open doors to opportunities in the 3D modeling and animation industry, while also serving as a foundation for further honing your expertise. Course Overview: Photoshop Post-Production Delve into the world of Photoshop post-production through our comprehensive course. Learn essential photo editing techniques, including color correction, retouching, and compositing. Unleash your artistic potential by creating mesmerizing visual effects and stylizing your photos. Course Syllabus: Part 1: Introduction to Photoshop Post-Production Navigating the Photoshop Interface with ease Mastering the art of Layers and Layer Masks Embracing the power of Selections Understanding the basics of Color Correction Part 2: Retouching Techniques Unraveling common Retouching Tools and Techniques Removing blemishes, wrinkles, and unwanted elements Achieving remarkable results with Dodging and Burning Part 3: Compositing Embracing the art of Compositing Working seamlessly with Multiple Images Blending images flawlessly using Layer Masks Part 4: Visual Effects and Stylizing Techniques Crafting Special Effects with Layer Styles and Blending Modes Enhancing images with Filters Achieving mesmerizing effects with Color Grading and Adjustment Layers Part 5: Projects Applying your knowledge to hands-on projects Perfectly Retouching a portrait Creating an alluring composite image Fashioning a stylized masterpiece Course Requirements: A computer with Photoshop installed (trial version available on Adobe website) Basic knowledge of computer operations Passion for photo editing and manipulation

Duration 4 Days 24 CPD hours This course is intended for C - Level Managers IT Managers Cyber Security Personelle Engineers Information Systems Owners ISSO's CISSP Students ISO's Overview Upon completion, the Certified Security Leadership Officer candidate be able to competently take the C)SLO exam. You will be versed in implementing strong security controls and managing an organization with an industry acceptable security posture. Certified Security Leadership Officerÿ course is designed for mid and upper-level managers.ÿ If you are an engineer, this course will increase your knowledge in the leading information system security teams. Plus, the C)SLO will give you an essential understanding of current security issues, best practices, and technology. With this knowledge you will then be prepared to manage the security component of an information technology project. As a Security Leadership Officer, you will be the bridge between cybersecurity and business operations. Course Outline Security Management Risk Management Encryption Information Security Access Control Concepts Incident Handling and Evidence Operations Security Network Security Additional course details: Nexus Humans C)SLO-Certified Security Leadership Officer Mile 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 C)SLO-Certified Security Leadership Officer Mile 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.

Duration 2 Days 12 CPD hours This course is intended for This is an introduction to database security course for intermediate skilled team members. Attendees might include DBAs, system administrators, developers and other enterprise team members. Ideally, students should have approximately 6 months to a year of database working knowledge. Overview Students who attend Securing Databases will leave the course armed with the skills required to recognize actual and potential database vulnerabilities, implement defenses for those vulnerabilities, and test those defenses for sufficiency. This course introduces students to the most common security vulnerabilities faced by databases today. Each vulnerability is examined from a database perspective through a process of describing the threat and attack mechanisms, recognizing associated vulnerabilities, and, finally, designing, implementing, and testing effective defenses. Multiple practical demonstrations reinforce these concepts with real vulnerabilities and attacks. Students will learn how to design and implement the layered defenses they will need in defending their own databases. Securing Databases is an essential training course for DBAs and developers who need to produce secure database applications and manage secure databases. Data, databases, and related resources are at the heart of most IT infrastructures. These assets can have high value from a business, regulatory, and liability perspective, and must be protected accordingly. This course showcases demonstrations on how to repeatedly attack and then defend various assets associated with a fully functional database. This approach illustrates the mechanics of how to secure databases in the most practical of terms. Security experts agree that the least effective approach to security is 'penetrate and patch'. It is far more effective to 'bake' security into an application throughout its lifecycle. After spending significant time trying to defend a poorly designed (from a security perspective) database application, students will learn how to build secure their databases and applications, starting at project inception. Securing Databases Foundation Why Hunt for Security Defects? Fingerprinting Databases Principles of Information Security Database Security Vulnerabilities Database Security Concerns Vulnerabilities Cryptography Overview Database Security Database Security What Next? Secure Development Lifecycle (SDL) SDL Process Overview Taking Action Now Asset Analysis Design Review Making Application Security Real

Duration 3 Days 18 CPD hours This course is intended for This course is primarily designed for students who want to gain the skills necessary to use VBA to automate tasks in Excel such as collecting data from external sources, cleaning, and manipulating data. The target student may also want to learn how to create custom worksheet functions to streamline worksheet formulas and make complex worksheets easier to support, maintain, and understand. Overview In this course, you will develop and deploy VBA modules to solve business problems. You will: Identify general components of VBA and their appropriate use in solving business solutions. Record VBA macros to automate repetitive tasks. Use reference tools built into Excel to get help on VBA programming language and objects used in the Excel VBA environment. Write VBA code to create a custom worksheet function. Eliminate, avoid, or handle errors in VBA code, and optimize its performance. Control how and when macros run. Develop UserForm objects to create custom dialog boxes and windows. Use VBA to read and write data from local files and cloud services. Use VBA to clean and transform data. Run programs and commands outside of Excel and share VBA projects with other users VBA (Visual Basic for Applications) enables you to enhance and extend the capabilities of Microsoft© Excel© and other applications in the Microsoft© Office application suite. You can use VBA to perform tasks that would be difficult or impossible to do using only worksheet functions, and you can automate a wide range of tasks involving the collection, processing, analysis, and visualization of data. This course will give you a good foundation for understanding, creating, and using VBA in your own Excel workbooks, show you how to work with data across different applications, and how to package the macros and functions you create so you can back them up, move them to other computers, and share them with other users Prerequisites To ensure your success in this course, you should be an experienced Excel user who is comfortable creating and working with Excel workbooks, including tasks such as entering worksheet formulas, using absolute and relative addressing, formatting cells, and creating pivot tables and charts. This level of skill could be acquired by taking the Microsoft Excel for Office 365? (Desktop or Online) courses, Parts 1, 2, and 3 1 - Using VBA to Solve Business Problems Topic A: Use Macros to Automate Tasks in Excel Topic B: Identify Components of Macro-Enabled Workbooks Topic C: Configure the Excel VBA Environment 2 - Automating Repetitive Tasks Topic A: Use the Macro Recorder to Create a VBA Macro Topic B: Record a Macro with Relative Addressing Topic C: Delete Macros and Modules Topic D: Identify Strategies for Using the Macro Recorder 3 - Getting Help on VBA Topic A: Use VBA Help Topic B: Use the Object Browser to Discover Objects You Can Use in VBA Topic C: Use the Immediate Window to Explore Object Properties and Methods 4 - Creating Custom Worksheet Functions Topic A: Create a Custom Function Topic B: Make Decisions in Code Topic C: Work with Variables Topic D: Perform Repetitive Tasks 5 - Improving Your VBA Code Topic A: Debug VBA Errors Topic B: Deal with Errors Topic C: Improve Macro Performance 6 - Controlling How and When Macros Run Topic A: Prompt the User for Information Topic B: Configure Macros to Run Automatically 7 - Developing Custom Forms Topic A: Display a Custom Dialog Box Topic B: Program Form Events 8 - Using VBA to Work with Files Topic A: Use VBA to Get File and Directory Structure Topic B: Use VBA to Read Text Files Topic C: Use VBA to Write Text Files 9 - Using VBA to Clean and Transform Data Topic A: Automate Power Query Topic B: Transform Data Using VBA and Workbook Functions Topic C: Use Regular Expressions Topic D: Manage Errors in Data 10 - Extending the Programming Environment Beyond the Workbook Topic A: Run Other Programs and Commands Topic B: Share Your VBA Projects