2996 Sup courses in Liverpool delivered Live Online

Mental Health First Aid (MHFA) England Training with Mindmaps Wellbeing Enhance workplace wellbeing and mental health awareness with MHFA England-certified training by Mindmaps Wellbeing. Our expert-led courses, delivered by Registered Mental Health Nurses and Healthcare Educators, equip you with the skills to recognize, support, and respond to mental health challenges. Whether online or in-person, our training ensures flexible learning options without compromising quality. Join us to gain certification as a Mental Health First Aider and access exclusive benefits like ongoing peer support, expert forums, and resources for self-care. Book now with Mindmaps Wellbeing and take the first step toward a healthier, more supportive environment for all.

Click here for info. Training duration: 20 hrs. Method: 1-2-1, Personalized attention, Tailored content, Flexible pace, Individual support. Schedule: Personalized training experience with our flexible 1-2-1 sessions. Tailor your own schedule by pre-booking a convenient hour of your choice, available from Monday to Saturday between 9 am and 7 pm. Maya Basic to Intermediate Course Course Duration: 20 hours Course Description: Discover Autodesk Maya's potential in our 20-hour course. Master 3D modeling and animation, explore texturing, rigging, rendering, and special effects. Unleash your creativity with advanced modeling techniques. Join us on this exciting journey to unlock the full power of Maya. Course Outline: I. Introduction to Maya (1.5 hours) - Discover the vast applications of Maya and its significance in diverse industries - Navigate seamlessly through Maya's interface, understanding essential tools - Master viewport controls and proficiently manage projects II. Creating 3D Models (3 hours) - Build a strong foundation in polygon modeling, creating basic shapes and objects - Hone your skills in editing and modifying objects with precision - Master complex object creation using extrusions, bevels, and NURBS for organic shapes III. Texturing and Materials (1.5 hours) - Step into the captivating world of texturing, adding depth to your creations - Create and expertly apply materials to breathe life into your models - Unwrap textures with precision and import images seamlessly IV. Lighting and Rendering (2 hours) - Illuminate your scenes with fundamental lighting techniques - Compose visually captivating compositions with camera setup - Harness the power of rendering for still images and dynamic animations V. Animation (4 hours) - Embrace the art of animation, unlocking its potential in your projects - Master keyframe animation, animation curves, and animation clips - Rig and animate characters, adding life and movement to your creations - Explore motion paths and animation layers for added depth and complexity VI. Rigging (2 hours) - Delve into the world of rigging and its significance in animation - Create joints and skeletons, laying the foundation for character animation - Bind skin to joints and craft weight maps for smooth animation - Implement simple rigging systems and rig characters for animation VII. Special Effects (1.5 hours) - Unleash your creativity with mesmerizing particle systems and dynamics - Create captivating fluid and fire effects, manipulating them with finesse - Craft and edit special effects, from explosions to captivating smoke VIII. Advanced Modeling Techniques (1.5 hours) - Elevate your modeling skills with advanced techniques using Booleans and deformers - Master the art of creating and modifying curves and surfaces - Explore the world of sculpting tools to craft high-resolution and intricate models IX. Conclusion and Next Steps (0.5 hours) - Recap the rich knowledge acquired during the course - Discover valuable tips and resources for continuous learning and growth - Engage in a dynamic Q&A session, providing valuable feedback Note: The course outline can be customized to meet the specific needs and proficiency levels of learners. Throughout the course, you will receive lifetime email support, ensuring you have assistance for any queries or challenges you encounter. Embrace the world of Autodesk Maya, and unveil your creative potential in 3D modeling and animation.   Unlock your potential in Autodesk Maya with our comprehensive Basics to Intermediate Training Course. Whether you're a budding 3D artist, animator, or visual effects enthusiast, this program provides a structured learning path to master essential tools and techniques. Join us for interactive in-person or live online sessions, and receive guidance from experienced instructors. Enroll now to create captivating 3D visuals and animations and explore the creative possibilities of Autodesk Maya. In this course, explore the world of Maya 2023 and master the skills to create high-quality 3D models and animations. Discover a real-world, project-based workflow applicable to film, motion graphics, and game design. Learn Basic to Intermediate techniques like customizing the interface, object manipulation, and scene organization. Dive into polygonal, sculpting, and NURBS modeling, and apply materials for color, texture, and reflectivity. Integrate cameras, lighting, and depth-of-field effects with the Arnold renderer. Finally, learn animation tools to add movement and bring your creations to life, guided by instructor Autodesk certified trainers In this course, explore the world of Maya 2023 and master the skills to create high-quality 3D models and animations. Discover a real-world, project-based workflow applicable to film, motion graphics, and game design. Learn Basic to Intermediate techniques like customizing the interface, object manipulation, and scene organization. Dive into polygonal, sculpting, and NURBS modeling, and apply materials for color, texture, and reflectivity. Integrate cameras, lighting, and depth-of-field effects with the Arnold renderer. Finally, learn animation tools to add movement and bring your creations to life, guided by instructor Autodesk certified trainers In this course, explore the world of Maya 2023 and master the skills to create high-quality 3D models and animations. Discover a real-world, project-based workflow applicable to film, motion graphics, and game design. Learn Basic to Intermediate techniques like customizing the interface, object manipulation, and scene organization. Dive into polygonal, sculpting, and NURBS modeling, and apply materials for color, texture, and reflectivity. Integrate cameras, lighting, and depth-of-field effects with the Arnold renderer. Finally, learn animation tools to add movement and bring your creations to life, guided by instructor Autodesk certified trainers Master 3D modeling and animation. Create realistic textures and materials. Understand rigging for character animation. Illuminate scenes with effective lighting. Create mesmerizing special effects. Explore advanced modeling techniques. Gain practical skills for real-world projects. Unlock creative potential in film, animation, and game design.

This online course trains you as a Youth Mental Health First Aider (MHFAider®), giving you: An in-depth understanding of young people’s mental health and factors that affect wellbeing Practical skills to spot the triggers and signs of mental health issues Confidence to reassure and support a young person in distress Enhanced interpersonal skills such as non-judgemental listening Knowledge to help a young person recover their health by guiding them to further support – whether that’s through self-help sites, their place of learning, the NHS, or a mix – engaging with parents, carers and external agencies where appropriate Ability to support a young person with a long term mental health issue or disability to thrive Tools to look after your own mental wellbeing Format This is an online course delivered through the MHFA England Online Learning Hub Learning takes place through four live training sessions spread across one to two weeks, with self-learning activities in between. See course structure section below for more detail Each session is built around a Youth Mental Health First Aid action plan We limit numbers to 16 people per course so that the instructor can keep people safe and supported while they learn Course StructureSession 1: Introduction Individual learning (1 hour 15 minutes): Introduction to the Online Youth Mental Health First Aid course and the Online Learning Hub Activity 1: Why Youth Mental Health First Aid? Activity 2: What is ALGEE? Activity 3: What is mental health? Activity 4: Mental health and stigma Activity 5: Mental health quiz: Impact of mental health Activity 6: Risk and protective factors for mental health Activity 7: The Stress Container Live session (2 hours 35 minutes): Introduction to the course Outline of live session 1, the value of Youth Mental Health First Aid Introduce ALGEE Recap what mental health is Recap the Mental Health Continuum Stigma Recap why Youth Mental Health First Aid is important Recap risk and protective factors The Stress Container The Frame of Reference Session 2: Depression, Anxiety & Self-Care Individual learning (1 hour 15 minutes): Activity 8: Your Stress Container Activity 9: Your Frame of Reference Activity 10: What is depression? Activity 11: What is anxiety? Live session (2 hours 10 minutes): Introduction to live session 2 Recap of homework after live session 1 Recap depression Signs and symptoms of depression in a young person Recap anxiety Signs and symptoms of anxiety in a young person ALGEE for depression and anxiety in a young person ALGEE for depression and anxiety, action 1 ALGEE for depression and anxiety, action 2-5 Self-care and close Session 3: Suicide & PsychosisIndividual learning (1 hour 20 minutes) Activity 12: Adolescent brain development Activity 13: About suicide Activity 14: Suicide risk factors Activity 15: What is psychosis? Activity 16: Lived experience of psychosis Activity 17: ALGEE for psychosis Live session (2 hours 5 minutes) Introduction to live session 3 Recap suicide Explore the impact of suicidal feelings ALGEE for suicidal crisis Practice non-judgemental listening skills Recap psychosis Recap warning signs and symptoms of psychosis Recap ALGEE for psychosis Session 4: Self-harm, Recovery & Action PlanningIndividual learning (1 hour 35 minutes) Activity 18: What is self-harm? Activity 19: What are eating disorders? Activity 20: Resilience Workbook activity 7: My action plan for using Youth Mental Health First Aid (completed after live session) Live session (2 hours 25 minutes) Introduction to live session 4 Recap self-harm, the self-harm continuum Warning signs of self-harm in young people ALGEE for self-harm Recap eating disorders ALGEE for eating disorders Applying MHFA to family and carers; the Recovery Tree Evaluation forms and close

Logistics for Traders: Importance, Role and Benefits. This session will look at how logistics is a critical component within the supply chain but is often overlooked.

AutoCAD Training for 15 hours - Live and Online The AutoCAD Training is for 15 hours that will cover from Introduction to Intermediate in small classes with only 1 people per class. AutoCAD course is for Windows or AutoCAD for MAC platforms. If you have AutoCAD for MAC, please let us know to book the specific course.  The training is tailored to your needs and we will focus the AutoCAD course on the area you want to learn.   During the training, you will receive many AutoCAD tips on how to work fast and efficient.  This live AutoCAD course will be now online at a reduced price.  You will receive a certificate of attendance at the end of the course. After the training, you can book 1 to 1 AutoCAD support to answer your questions and support your journey to learn AutoCAD. This is an extra service that you can book a minimum of 2.5 hours. Spread the cost with interest-free instalments. Buy now, pay later courses! AutoCAD Training: https://www.bimrevittraining.com/autocad-training AutoCAD Course Description AutoCAD Settings and Customization • Workspaces (AutoCAD Classic/2D Drafting & Annotation) • Background Color • Cross Air Size • New / Open and Save • User Preferences • Toolbars • Drawing Units • Drawing Limits • Snap Mode • Grid Display • Ortho Mode • Polar Tracking • Object Snap • Object Snap Tracking   AutoCAD Drawing Tools • Line • Multiple Line • Construction Line • Polyline • Polygon • Rectangle • Arc • Circle • Revision Cloud • Spline • Ellipse / Ellipse Arc • Insert Block • Make Block • Point • Hatch/Gradient • Region • Table • Multiline Text   Modify Tools • Erase • Copy • Mirror • Offset • Array • Move • Rotate • Scale • Stretch • Trim • Extend • Break at Point • Break • Join • Chamfer • Fillet • Explode   Working Methods •Object Properties •Match Properties •Layer Properties Manager •Adding Layers •Working with Layouts •External References •Insert/Edit Images •Insert PDF   AutoCAD Plotting / Publishing •Page Setup Manager •Plot Style Manager •Plotting •Publish •eTransmit

Why Learn AutoCAD 3D Basics-Advanced Training Course? Course Link Learn 3D modeling, materials, lighting, and rendering, and parametric models. Learn real-world Architecture, products, mechanics. Enroll for in-person or online sessions to master AutoCAD 3D. Duration: 16 hrs Method: 1-on-1 Schedule: Tailor your own schedule by pre-booking a convenient hour of your choice, available from Mon to Sat between 9 am and 7 pm. "Dial 02077202581 or WhatsApp 07970325184 to reserve your preferred dates and times.  AutoCAD 3D Basics-Advanced Level 1-2-1 Training Course: Comprehensive coverage from basics to advanced techniques. Suitable for beginners and those advancing their 3D modeling skills. Personalized attention in a private learning environment. Experienced instructors with expertise in 3D modeling. Hands-on practice for confident 3D modeling. Flexible scheduling and lifetime email support. Certificate upon course completion for career advancement AutoCAD 3D Basics-Advanced Level 1-2-1 Training Course: Comprehensive coverage from basics to advanced techniques. Suitable for beginners and those advancing their 3D modeling skills. Personalized attention in a private learning environment. Experienced instructors with expertise in 3D modeling. Hands-on practice for confident 3D modeling. Flexible scheduling and lifetime email support. Certificate upon course completion for career advancement AutoCAD 3D Basics to Advanced Level Training Course Outline (10 hours): Session 1: Introduction to 3D Modeling (2 hours) Understanding 3D modeling concepts Working in the 3D Modeling Workspace Drawing 3D objects with Solid tools Extruding 2D polylines to create 3D objects Session 2: Advanced 3D Features and UCS (2 hours) Setting up AutoCAD for advanced 3D modeling Mastering the User Coordinate System (UCS) Using viewports to aid in 3D drawing Efficient modeling with Array tools Session 3: Rendering and Visualization (2 hours) Testing rendering techniques Creating a quick study rendering Simulating natural lighting and the sun Enhancing 3D models with materials and lights Session 4: Editing 3D Solids and Mesh Modeling (2 hours) Understanding solid modeling principles Creating and editing basic solid forms Editing 3D solids and streamlining 2D drawing process Exploring 3D mesh modeling and editing The AutoCAD 3D training course provides a comprehensive understanding of 3D modeling, visualization, and rendering. Participants will learn to create complex 3D models, render realistic visuals, and efficiently customize the AutoCAD interface for improved productivity. Master 3D Modeling: From basics to advanced techniques. Realistic Rendering: Achieve lifelike visualizations. Professional Presentations: Dynamic walkthroughs and showcases. Enhanced Career Opportunities: Stronger prospects in design fields. Personalized Learning: One-to-one attention for focused training. Practical Hands-On Practice: Building confidence in 3D modeling. Lifetime Email Support: Ongoing assistance beyond the course. Certification: Proof of proficiency in AutoCAD 3D modeling.

Give Your Puppy The Best Start With Wolfgang's Way Award Winning Online Puppy Training Programme. Effective And Fun; Learning Together In The Comfort Of Your Own Home With Programmes Tailored To You And Your Puppy’s Needs.

Why Learn Vectorworks Spotlight Training Courses? VectorWorks Spotlight Course offers strong 2D drawing tools and lighting skills. while. Spotlight goes beyond fundamentals, offering solution for designing, modeling, and sharing entertainment projects. It's the industry standard for lighting, scenery, sets, corporate events, theater, and exhibits. Click here for more info: Website When can I book this course? 1-on-1 training. Duration: 16 hrs, Flexible scheduling (Mon to Sat, 9 am - 7 pm). Choose your own day and time. Training Course: Vectorworks Spotlight Duration: 16 hours Course Overview: I. Introduction to Vectorworks (1 hour) Overview of Vectorworks software and its diverse applications Familiarization with the user interface and navigation Customizing preferences and settings to optimize workflow II. 2D Drawing Tools (2 hours) Utilizing basic drawing tools for creating lines, rectangles, circles, and polygons Implementing text and dimension tools for annotations Applying modify tools for object editing and transformation Organizing elements using layers and classes III. 3D Modeling Tools (3 hours) Introduction to extrude, revolve, sweep, and loft tools for 3D modeling Creating 3D objects from 2D shapes for spatial representation Modifying and refining 3D models Exploration of the 3D modeling environment IV. Advanced 3D Modeling Tools (2 hours) Utilization of solid modeling tools for complex geometry creation Performing Boolean operations to combine or subtract shapes Creation and use of symbols for efficient workflow V. Introduction to Spotlight (1 hour) Overview of the Spotlight workspace and its features Adding and configuring lighting devices for stage and event design Creation and modification of lighting positions for precise placement VI. Spotlight Tools and Techniques (3 hours) Creation and editing of lighting instruments for customized setups Use of visualization tools for lighting simulations Creation and application of labels and legends for documentation Generation of worksheets and reports for lighting analysis VII. Advanced Spotlight Techniques (2 hours) Utilization of video and projection tools for multimedia presentations Incorporation of audio and sound systems for immersive experiences Understanding rigging and hoisting for stage setup Management of paperwork and documentation for effective planning VIII. Integration with Other Software (1 hour) Importing and exporting files for collaborative work with other software Utilizing Vectorworks in CAD and BIM workflows for seamless interoperability Exploration of plugins and add-ons for expanded functionality IX. Project-based Exercises (1 hour) Application of learned techniques to real-world scenarios Creation of a lighting plan for a concert or theater production Designing a 3D model of a building or interior space Free 30-day BIM & CAD Software Trial Request: Vectorworks After completing Vectorworks 2D | 3D and Spotlight Training Course? Vectorworks Proficiency: Master Vectorworks software, including interface and tools. 2D Drafting: Create precise technical drawings using fundamental 2D tools. 3D Modeling: Develop skills in 3D modeling, modification, and spatial representation. Spotlight Expertise: Learn stage and event design tools, focusing on lighting setups. Advanced Techniques: Explore complex 3D modeling and Spotlight features. Interdisciplinary Integration: Integrate Vectorworks with other software in CAD and BIM workflows. Project Application: Apply skills to real-world scenarios, creating plans and models. Job Opportunities: CAD Technician: Draft detailed plans for architecture and engineering firms. Stage Designer: Plan lighting, sound, and multimedia setups for events. Event Planner: Design event layouts with lighting and audio-visual setups. Architectural Drafter: Create accurate architectural plans and models. Interior Designer: Visualize interior spaces in 2D and 3D for clients. Lighting Designer: Specialize in various lighting applications, from buildings to stages. BIM Specialist: Work with architectural firms on Building Information Modeling projects. Freelance Designer: Offer services in 2D/3D modeling, event planning, or architectural visualization. What is Vectorworks Spotlight? Vectorworks Spotlight is a specialized package tailored for entertainment design professionals, offering both 2D and 3D capabilities. It is the industry-standard CAD software for entertainment design, ideal for lighting, scenery, sets, events, theater, and exhibits. Training Details: Duration: 16 hrs (flexible scheduling) Method: Personalized 1-on-1 training (In-person or Live Online over Zoom) Tailored content, adaptable pace, individual support Differences from Vectorworks Fundamentals: Vectorworks Fundamentals serves general modeling and drawing needs, while Spotlight provides comprehensive solutions for design, modeling, documentation, and collaborative project sharing, catering specifically to industry experts. Applications of Spotlight: Spotlights have diverse uses, including emergency situations and when a powerful light source surpassing a flashlight is required. Interior Designers and Vectorworks: Yes, interior designers use Vectorworks software, particularly Vectorworks Architect, for efficient workflow and effective realization of creative visions. Course Structure: Individualized Instruction (1-2-1) Customized Content Adaptable Learning Pace Flexible Scheduling: Monday to Saturday, 9 am to 7 pm Get Vectorworks: For more information and to download Vectorworks, visit Vectorworks Website. Individualized Training: Get personalized attention and tailored guidance during your training sessions. Flexible Timings: Select your preferred schedule and training days to fit your convenience. Post-Training Assistance: Access complimentary online support even after course completion. Comprehensive Resources: Receive detailed PDF notes and handouts for effective learning. Certification of Completion: Receive a recognition certificate upon successfully finishing the course. Affordable Pricing: Take advantage of budget-friendly training rates. Software Setup Support: Receive assistance in configuring the software on your device. Referral Benefits: Recommend a friend and enjoy discounts on upcoming courses. Group Training Offers: Benefit from special discounts for group training programs. Convenient Hours: Attend sessions from Monday to Sunday, with extended operating hours. Tailored Learning: Experience customized training designed to meet your specific requirements.

Course Objectives At the end of this course you will be able to: Work with advanced lookup and reference functions Create macros to automate common tasks Use advanced techniques to analyse data Create PivotTables and PivotCharts Work with data validation tools Import and export data ' 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 course was very interesting and engaging and will definitely be put to use. The trainer was very helpful and charismatic. Marving Lopez - AM Best Europe Pedro was excellent. Very knowledgeable, clear and great rapport with class. Darren Barkey - Direct Wines Great content and learnt a lot. Really enjoyable :) Kristie-Lee Ryan - Stirling Ackroyd 1 year email support service Take a closer look at the consistent excellent feedback visiting our site ms-officetraining co uk 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 classrom, 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. Please visit our site (ms-officetraining co uk) to get a feel of the excellent feedback our courses have had and look at other courses you might be interested in. Advanced Functions COUNT, COUNTA, COUNTIF, COUNTBLANK, SUMIF, SUBTOTAL IF, OR, AND, IFERROR VLOOKUP to lookup Exact Values and Approximate values MATCH, INDIRECT, ROW/COLUMN, INDEX, OFFSET Analysing Data PMT function to calculate a monthly payment of a loan What If Analysis using Goal Seek Use scenarios to consider many different variables Using Solver Add-in to optimize variables PivotTables Create a PivotTable to analyse worksheet data Add or remove fields in a PivotTable Change the data source for a PivotTable Working with external data sources Using different Statistical Functions Calculate a Running Total, % of Grant Total, Difference From… Using the Slicer and Timeline to filter the PivotTable Using Filters in a PivotTable Group by Date, Auto Group by ranges of values, Custom Group Create a PivotChart The GETPIVOTDATA function Formula auditing Precedents and dependents Error checking Watch a formula and its result by using the Watch Window Evaluate a nested formula one step at a time Data Validation Number Validation Data List Validation Message Prompts and Alerts Conditional Data Validation Data Validation Errors Consolidation Consolidate data by position Consolidate data by category Use a formula to consolidate data Outline (group) data in a worksheet Create an outline of rows Create an outline of columns Copy outlined data Hide or remove an outline Connect external data to your workbook Using the Power Query Editor to import data From Text and CSV, From Access, From Web, From another Workbook Using the Power Query Editor to; Transform your data by Selecting which fields to import, by Splitting Columns, Changing Data Type and more. Deleting Applied Steps Refreshing your data Working with Form Controls; Buttons, Option Buttons and Scroll Bars Introduction to Macros Change Macro Security settings How to Record a macro Some Macro Examples Delete a macro Edit the macro to view the VBA code Copy part of a macro to create another macro Assign a macro to a button Who is this course for? Who is this course for? This course is intended to end users who want to develop their skills so they can use advanced techniques to analyse extensive and complex datasets in Excel and to automate simple tasks with the use of Macros. Requirements Requirements Preferably, delegates should have attended the Excel Intermediate 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 Certificates Certificates Certificate of completion Digital certificate - Included