1938 Concept courses in Liverpool delivered Live Online

Duration 1 Days 6 CPD hours This course is intended for The Power BI in a Day course is designed for beginners and intermediate users of Power BI. Overview #NAME? Students will discover the full capabilities of Power BI in a one-day, hands-on workshop. Please Note: This workshop is primarily self-directed and students will work at their own pace while having access to an instructor for questions. 1 - Accessing & Preparing data Data Set Power BI Desktop Power BI Desktop ? Accessing Data Power BI Desktop ? Data Preparation 2 - Data Modeling and Exploration Power BI Desktop ? Data Modeling and Exploration Power BI Desktop ? Data Exploration Continued References 3 - Data Visualization Power BI Desktop Power BI Desktop ? Data Visualization References 4 - Publishing & Accessing Reports Power BI Desktop ? Creating Mobile View Power BI Service Power BI Service ? Publishing Report Power BI Mobile ? Accessing Report on Mobile Device Power BI Service ? Collaboration and Distribution References 5 - Dashboard and Collaboration Power BI Service Building Dashboard References Additional course details: Nexus Humans Power BI: Dashboard in a Day 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 Power BI: Dashboard in a Day 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 1 Days 6 CPD hours This course is intended for The audience for this course includes software developers and data scientists who need to use large language models for generative AI. Some programming experience is recommended, but the course will be valuable to anyone seeking to understand how the Azure OpenAI service can be used to implement generative AI solutions. Note Generative AI is a fast-evolving field of artificial intelligence, and the Azure OpenAI service is subject to frequent changes. The course materials are maintained to reflect the latest version of the service at the time of writing. Azure OpenAI Service provides access to OpenAI's powerful large language models such as GPT; the model behind the popular ChatGPT service. These models enable various natural language processing (NLP) solutions to understand, converse, and generate content. Users can access the service through REST APIs, SDKs, and Azure OpenAI Studio. In this course, you'll learn how to provision Azure OpenAI service, deploy models, and use them in generative AI applications. Prerequisites Familiarity with Azure and the Azure portal. Experience programming with C# or Python. 1 - Get started with Azure OpenAI Service Access Azure OpenAI Service Use Azure OpenAI Studio Explore types of generative AI models Deploy generative AI models Use prompts to get completions from models Test models in Azure OpenAI Studio's playgrounds 2 - Build natural language solutions with Azure OpenAI Service Integrate Azure OpenAI into your app Use Azure OpenAI REST API Use Azure OpenAI SDK 3 - Apply prompt engineering with Azure OpenAI Service Understand prompt engineering Write more effective prompts Provide context to improve accuracy 4 - Generate code with Azure OpenAI Service Construct code from natural language Complete code and assist the development process Fix bugs and improve your code 5 - Generate images with Azure OpenAI Service What is DALL-E? Explore DALL-E in Azure OpenAI Studio Use the Azure OpenAI REST API to consume DALL-E models 6 - Use your own data with Azure OpenAI Service Understand how to use your own data Add your own data source Chat with your model using your own data Additional course details: Nexus Humans AI-050T00: Develop Generative AI Solutions with Azure OpenAI Service 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 AI-050T00: Develop Generative AI Solutions with Azure OpenAI Service 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.

Virtual Revit face to face training customised and bespoke. One to One Online or Face to Face

This course will allow you to explore the potential of self-service business intelligence using Power BI Desktop to analyse and connect to different sources of data, creating Relationships between those different datasets, Query the data using Shaping and data Modelling, to create Visualizations, and publish Reports to different platforms . Course Objectives At the end of this course you will be able to: Connect to data from different sources. Use the Query Editor Perform Power BI desktop data Shaping and Transformation. Create Power BI desktop Modelling. Create Power BI desktop Visualizations and Reports. ' 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 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 and Business Intelligence. Our trainers are Microsoft certified professionals with a proven track record with several years experience in delivering public, one to one, tailored and bespoke course Tailored training courses: in 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. Introduction to Power BI Power BI Jargon explained A quick look at Power BI Desktop A quick look at the Power BI service Helpful resources Power BI and Excel Introduction to using Excel data in Power BI Upload Excel data to Power BI Import Power View and Power Pivot to Power BI Getting started with Power BI Desktop Overview of Power BI Desktop Accessing Help and Helpful resources Connect to data sources in Power BI Desktop Shaping and Transforming Data with Query Editor Introduction to the Query Editor Data Sources Power BI Desktop can Connect to Introduction to Steps and M code Combining Data Using Merge and Append Queries Data Type Properties Working with Delimiters Clean and transform your data with the Query Editor Text Specific Transformation Tools Number Specific Transformation Tools Date Specific Transformation Tools Split and Merge columns Creating an Index Column Adding Conditional Columns Columns From Examples Grouping and Aggregating data Pivoting and Unpivoting Using filters Modeling the data Introduction to modeling your data How to manage your data relationships Create calculated columns Optimizing data models Create calculated measures Show Values As and Quick Measures Create calculated tables Explore your time-based data Introduction to DAX DAX calculation types DAX functions Visualizations Introduction to visuals in Power BI Create and customize simple visualizations Modify colors in charts and visuals Shapes, text boxes, and images Page layout and formatting Group interactions among visualizations Visual hierarchies and drill-down Using custom visualizations Create a KPI Visualization Geo-Data and Maps Reports, Publishing and Sharing Introduction to the Power BI service Quick insights in Power BI Create and configure a dashboard Ask questions of your data with natural language Create custom Q&A suggestions Share dashboards with your organization Introduction to content packs, security, and groups Publish Power BI Desktop reports Print and export dashboards and reports Create groups in Power BI Use content packs Update content packs Publish to web Who is this course for? Who is this course for? This course facilitates you with knowledge on the potential for Power BI Desktop to analyse and connect to different sources of data, creating Relationships between those different datasets, Query the data using Shaping and data Modelling, and to create Visualizations, and publish Reports to different platforms. Requirements Requirements Before attending this course, delegates should have: - A general knowledge of database concepts (fields, records and relationships) - Familiarity with Excel. Career path Career path Business Intelligence Data Analysis ETL & Data Warehousing

Course Objectives At the end of this course you will be able to: Identify the components of the Microsoft Project environment Create a new project plan Create the project schedule Use different views to analyse the project plan Create, allocate and manage resources in a project plan Finalise a project plan Track progress View and report project plan information ' 1 year email support service Customer Feedback Very good course. Learnt a lot. Looking forward to the next level. Alexandra - CIAL ' 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 With more than 20 years experience, we deliver courses on all levels of the Desktop version of Microsoft Office and Office 365; ranging from Beginner, Intermediate, Advanced to the VBA level. Our trainers are Microsoft certified professionals with a proven track record with several years experience in delivering public, one to one, tailored and bespoke courses. Our competitive rates start from £550.00 per day of training Tailored training courses: You can choose to run the course exactly as they are outlined by us or we can customise it so that it meets your specific needs. A tailored or bespoke course will follow the standard outline but may be adapted to your specific organisational needs. Introduction to Microsoft Project Recap on project management concepts Project environment overview The 3 databases: Tasks, Resources and Assignments Different ways of displaying the Project Plan Access Help Creating a Project Plan Create a New Project Plan Project Information Create and apply the project calendar Defining recurring exceptions to the calendar Defining the calendar's work weeks Create the Summary tasks Create the Work Breakdown Structure Task creation and scheduling Exploring the Entry Table and its fields Task editing and the Task Information window Task Durations Defining Milestones Manual Scheduling vs Automatic Scheduling Changing the Task's Calendar Create a split in a Task Create Task Relationships Adding Lag or Lead to a Relationship Identifying the Critical Path Adding Constraints and Deadlines to Tasks Create Recurring Activities Adding Notes and links to Tasks Managing Resources Exploring the Entry Table and its fields Resource editing and the Resource Information window Resource Types Fixed Costs vs Variable Costs Adding Resource Costs Defining when costs accrue Changing the Resource Calendar and Availability Project calendar vs Resource and Task Calendar Assigning Resources to Tasks Effort Driven Scheduling Resolving Resource Overallocation Tracking the Project Progress Setting a Project Baseline Entering Actuals Different ways of viewing the Progress Checking if the Project is on track Viewing and Reporting Project Detail Adding Tasks to the Timeline and sharing it Modifying the Timescale and Zoom level Formatting the Gantt View Filtering and Grouping Tasks Print and Troubleshoot the Gantt View Using built-in Reports in Microsoft Project Who is this course for? Who is this course for? This course is designed for a person who has an understanding of project management concepts, who is responsible for creating and modifying project plans, and who needs a tool to manage these project plans. Requirements Requirements General knowledge of the Windows OS Career path Career path Microsoft Office 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

"Self Care" - A Key To Happiness Course Overview: "Self Care: A Key To Happiness" is a comprehensive course designed to provide learners with essential strategies and techniques to improve their well-being and mental health. Focusing on the importance of self-care in maintaining happiness, this course equips participants with practical tools to manage stress, set boundaries, and enhance their emotional resilience. It explores various self-care practices, including mindfulness, relaxation techniques, and the significance of a balanced lifestyle. By the end of the course, learners will gain the ability to integrate self-care into their daily routines, leading to increased overall happiness, productivity, and life satisfaction. Course Description: This course delves deeper into the concept of self-care, exploring the connection between mental and physical health. Participants will learn effective methods for self-awareness, stress management, and emotional well-being. Key topics include mindfulness practices, relaxation exercises, understanding emotional triggers, and cultivating a positive mindset. The course also examines the role of nutrition, sleep, and exercise in maintaining a balanced and happy life. Learners will be guided on how to create personalised self-care plans tailored to their unique needs, ensuring long-term success. Upon completion, students will have gained valuable skills in self-regulation, resilience-building, and sustainable happiness. "Self Care" - A Key To Happiness Curriculum: Module 01: About this Course Module 02: Full Course Module 03: Next Steps Module 04: Extra Content for YOU (See full curriculum) Who is this course for? Individuals seeking to enhance their well-being and happiness Professionals aiming to improve their stress management and mental resilience Beginners with an interest in mental health and self-care Those seeking balance and mindfulness in their daily lives Career Path Mental Health Support Worker Wellness Coach Health and Well-being Consultant Personal Development Trainer Employee Wellness Program Manager

Who is this Course for? Mastering Unity 3D Intermediate Level Training Course Our Unity 3D training programs are tailored for individuals aspiring to become game developers, creative minds, & enthusiasts keen to explore the realm of game development. Learn 3D & 2D games or looking to master Unity's cross-platform features. Click here for more info: Website Duration: 20 hours Approach: 1-on-1 Individualized Attention & Customized Content Timetable: Scheduling any hour between 9 am and 7 pm, from Mon to Sat Course Overview: Sessions 1-2: Introduction to Unity Familiarize yourself with Unity's interface and workspace Create a new Unity project and set up the initial scene and navigation Sessions 3-4: Asset Management Explore and download free assets Import various asset types into Unity and understand their applications Sessions 5-6: Environmental Design Utilize Unity's terrain tools for environment creation Enhance scenes with textures, materials, and environmental objects Sessions 7-8: Character Development Design 3D character models Rig, animate, and import characters into Unity Sessions 9-10: Player Interaction Set up player controls and script basic movements Implement camera controls for seamless gameplay experiences Sessions 11-12: Physics and Realism Understand and implement physics in Unity Configure collisions, gravity, force, and torque for realistic interactions Sessions 13-14: Audio Enhancement Master audio implementation with sound effects and background music Fine-tune volume and pitch for immersive gameplay Sessions 15-16: Lighting and Visual Effects Employ advanced lighting techniques, including dynamic day-night cycles Enhance visuals with lens flares and particle systems Sessions 17-18: User Interface Design Construct user interfaces using Unity's canvas system Integrate interactive elements such as buttons and menus, ensuring smooth functionality Sessions 19-20: Optimization and Performance Implement optimization techniques and utilize the profiler for performance analysis Improve frame rates and reduce memory usage for seamless gameplay Session 21-22: Multiplayer Integration Explore multiplayer implementation and set up local multiplayer games Session 23-24: Mobile Game Development Discover mobile game development in Unity Build, deploy, and optimize games for mobile devices, focusing on performance and controls Session 25: Advanced Topics Delve into advanced scripting techniques, including coroutines, delegates, and events Explore shader programming and visual effects, and venture into VR development with Unity and Oculus Quest Final Project: Create a Comprehensive Game Test the game thoroughly, identify and resolve bugs Make necessary adjustments and improvements for a polished final product Experience the Real-Time Development Platform: Unleash your creativity and create 3D, 2D, VR, and AR experiences across various industries, including games, automotive, AEC, film, and more. Unity Pro offers a complete solution to develop better, iterate faster, and grow your business. Enjoy amazing games and immersive experiences with multi-platform support. Get started today: Unity Pro. Learning Outcomes: Participants will gain expertise in Unity 3D, mastering asset management, environmental design, character animation, player interaction, physics, audio, lighting, UI, optimization, and advanced scripting. They will develop a complete game, honing skills in debugging and project completion. Career Opportunities: Graduates can pursue roles as Game Developers, Mobile Game Developers, VR/AR Developers, Game Designers, UI/UX Designers, Game Testers, Indie Game Developers, Educational Game Developers, Freelance Developers, or Game Development Instructors, leveraging their Unity 3D skills for diverse and exciting career paths in the gaming industry. Skills Acquired: Participants in the Mastering Unity 3D Intermediate Level Training Course will gain advanced proficiency in Unity 3D game development, including: Advanced 3D Game Development Techniques Real-time Physics and Animation Skills Multiplatform Game Deployment Expertise Job Opportunities: Upon completion, individuals can pursue roles such as: Game Developer Unity 3D Programmer AR/VR Developer Interactive Simulation Designer This course equips participants with the expertise required for exciting opportunities in game development studios, AR/VR companies, and interactive media agencies, setting the stage for a successful career in the gaming and simulation industry. Course Advantages: Comprehensive Unity Mastery: Develop expertise in various Unity aspects, including game design, scripting, animation, and optimization. Hands-On Project Experience: Engage in practical projects mirroring real-world game development, enhancing your skills and portfolio. Interactive Live Instruction: Learn from experienced instructors in real-time, encouraging interactive discussions, Q&A sessions, and personalized guidance. Flexible Learning Paths: Opt for in-person or online classes, ensuring accessible and convenient learning tailored to your needs. Lesson Revisions: Access recorded lessons, allowing flexible review and reinforcement of concepts at your own pace. Lifetime Email Support: Benefit from ongoing support via email, where experts are available to assist with any questions or challenges, even after the course concludes.

Who is this course for? Sketchup Artificial Intelligence Training Course. Mastering SketchUp Artificial Intelligence (AI) is essential for designers, offering automation, efficiency, and innovative solutions. It saves time, enhances visualizations, fosters collaboration, and future-proofs skills, ensuring a competitive edge in the design industry. Click here for more info: Website How to Book? 1-on-1 training. Customize your schedule from Mon to Sat from 9 am to 7 pm Call to book  Duration: 16 hours. Method: In-person or Live Online Sketchup and (Artificial Intelligence) Stable Diffusion Rendering Course (16 hours) Module 1: Sketchup Fundamentals (2 hours) Sketchup software overview and interface navigation Introduction to basic drawing tools and fundamental geometry creation techniques Module 2: Texturing and Material Mastery (2 hours) Application of textures and customization of materials Exploration of texture mapping and comprehensive material libraries Module 3: Illumination and Shadows (2 hours) Comprehending lighting principles and strategic light placement Crafting realistic shadows and reflections Module 4: Advanced Modeling Techniques (3 hours) Creating intricate shapes and harnessing advanced modeling tools Efficiently managing groups, components, and modifiers Module 5: Stable Diffusion Rendering (2 hours) Initiating stable diffusion rendering Optimizing rendering settings for superior outcomes Module 6: Scene Composition and Camera Configuration (2 hours) Exploring composition principles and camera perspectives Scene management and creation of captivating walkthrough animations Module 7: Rendering Optimization Strategies (2 hours) Techniques for optimizing models to expedite rendering Application of render passes and post-processing methods Module 8: Real-World Projects and Portfolio Building (1 hour) Application of acquired skills in completing authentic projects Professional portfolio presentation techniques Optional: Stable Diffusion and Python Installation (Additional 10 hours) Module 1: Introduction to Stable Diffusion and Python Comprehensive understanding of Stable Diffusion and Python's significance Module 2: System Prerequisites Hardware and software requirements for successful installation Module 3: Python Installation Guide Step-by-step installation process for various operating systems Module 4: Configuring Python Environment Configuration of environment variables and package managers Module 5: Stable Diffusion Installation Downloading and installing the Stable Diffusion package Module 6: Setting Up the Development Environment Configuration of integrated development environments (IDEs) for Python and Stable Diffusion Module 7: Troubleshooting and Common Issues Identification and resolution of common installation errors Module 8: Best Practices and Recommendations Effective management of Python and Stable Diffusion installations Module 9: Practical Applications and Projects Hands-on exercises exemplifying the practical usage of Stable Diffusion and Python Module 10: Advanced Topics (Optional) Exploration of advanced features and techniques Stable Diffusion https://stablediffusionweb.com https://stable-diffusion-ui.github.io https://stability.ai/stable-diffusion Upon successful completion of the Sketchup and Stable Diffusion Rendering Course with a focus on AI image rendering, participants will achieve the following: 1. Mastery of AI Image Rendering: Attain expertise in employing AI-powered rendering techniques to produce realistic and top-quality visualizations. 2. Proficiency in Sketchup for 3D Modeling: Navigate the software adeptly, utilize drawing tools with proficiency, and craft intricate 3D models. 3. Enhanced Rendering Optimization: Implement AI-based rendering to enhance model visuals, resulting in faster rendering times and superior image quality. 4. Application of AI-driven Lighting and Shadows: Employ AI algorithms for precise lighting placement, shadows, and reflections, elevating the realism of renderings. 5. Development of a Professional Portfolio: Present AI-rendered projects within a polished professional portfolio, highlighting advanced image rendering capabilities. 1. Mastering Sketchup: Attain proficiency in Sketchup, a renowned and user-friendly 3D modeling software, equipping you with the skills needed to adeptly create and manipulate 3D models. 2. Advanced Rendering Expertise: Explore stable diffusion rendering, an avant-garde technique that simplifies the creation of realistic and high-quality renderings. Broaden your rendering capabilities, producing visually stunning representations of your designs. 3. Practical Industry Applications: Cultivate practical skills relevant to diverse industries, encompassing architecture, interior design, product development, and visualization. Elevate your professional portfolio with captivating renderings that showcase your design prowess. 4. Interactive Learning: Participate in hands-on exercises and projects that promote active learning and the practical application of concepts. Benefit from personalized feedback and expert guidance, ensuring your continuous progress throughout the course. 5. Career Advancement: Elevate your career prospects by adding valuable skills to your toolkit. Proficiency in crafting detailed 3D models and impressive renderings through stable diffusion techniques opens doors to diverse job opportunities within the design and visualization sector. 6. Flexibility and Convenience: Access course materials online and learn at your own pace. Enjoy the flexibility of tailoring the coursework to your schedule, allowing you to harmonize your learning journey with other commitments. Course Advantages: Tailored Learning: Enjoy personalized 1-on-1 sessions, accommodating your schedule from Monday to Saturday, 9 am to 7 pm. Mastery of Sketchup: Develop proficiency in the widely-used and user-friendly 3D modeling software, enabling efficient creation and manipulation of 3D models. Advanced Rendering Proficiency: Acquire expertise in stable diffusion rendering for producing realistic, high-quality renderings that enhance the visual appeal of your designs. Practical Applicability: Develop practical skills applicable across diverse domains, including architecture, interior design, product development, and visualization, enriching your professional portfolio. Interactive Practical Experience: Engage in hands-on exercises with personalized guidance from seasoned instructors, ensuring consistent progress in your skillset. Career Progression: Boost your career opportunities by gaining valuable skills in 3D modeling and generating impressive renderings through stable diffusion techniques. Comprehensive Support: Benefit from free portfolio reviews, mock interviews, and career advice, providing additional resources to enhance your professional journey.

Revit face to face training customised and bespoke. Online or Face to Face

Course Objectives At the end of this course you will be able to: Record and edit a Macro Assign macros to keyboard shortcuts, Quick Access Toolbar, Buttons and Shape objects. Use the Visual Basic Editor; change the properties of an object; add a module to a project; write the code for a procedure and then run it; and use the Object Browser to search procedures Manipulate data by declaring variables of different data types; combine data by using expressions; use functions to accept input and display output; and declare variables and procedures with the appropriate scope Use decision structures to create procedures that make decisions; and use loop structures to perform repetitive tasks Create an error handling routine in case things go wrong with VBA code ' 1 year email support service Take a closer look at the consistent excellent feedback from our growing corporate clients visiting our site ms-officetraining co uk Customer Feedback Best Training Ever! Just finished a bespoke 1-1 training course in Excel Advanced, Macros & VBA. Pedro is an excellent trainer, imparting his skills and knowledge in the best way - appropriately to audience skills, knowledge and ability. Pedro is always approachable, encouraging and supportive, giving delegates the optimum learning environment. I would not hesitate to recommend Pedro as a trainer, whatever your level of ability. Amanda Morris - Treasury & Systems Accountant at Reall - Real Equity for All The trainer was very knowledgeable, kept everyone involved and was enthusiastic. A great experience.. Simon Harper - Lloyd's of London My learning experience was awesome. Perdinand Reagan - Subsea7 Very nice and relaxed approach to teaching. Was definitely a good learning experience. Jerome Pupe - S5 Agency World The Trainer – Very positive + patient + helpful + thorough Agnes Souza - Direct Wines ' With more than 20 years experience, we deliver courses on all levels of the Desktop version of Microsoft Office and Office 365; ranging from Beginner, Intermediate, Advanced to the VBA level. Our trainers are Microsoft certified professionals with a proven track record with several years experience in delivering public, one to one, tailored and bespoke courses. Our competitive rates start from £550.00 per day of training Tailored training courses: You can choose to run the course exactly as they are outlined by us or we can customise it so that it meets your specific needs. A tailored or bespoke course will follow the standard outline but may be adapted to your specific organisational needs. Introduction to Macros and VBA Introducing Visual Basic for Applications Recording a Macro Naming conventions for Macro Procedures Running a Macro Absolute or Relative Cell Referencing Saving and Opening Files with Macros Making macros always available Adding Macros to Keyboard Shortcuts, Quick Access Toolbar, Buttons and Shapes Editing a Macro in the Visual Basic Editor Understanding the Development Environment Customising the Editor Tips for General Typing in VBA Using Visual Basic Help Working with Procedures Program Design Understanding Modules Naming Rules Creating a Module Understanding Procedures Programming Macro Concepts Creating a Subroutine Creating a Function Understanding Arguments Exiting Procedures Calling Procedures Objects, Properties, Methods and Events Understanding Objects Properties, Methods, and Events Navigating the Object Hierarchy Understanding Collections Accessing a Member of a Collection Understanding Hierarchy Using the Object Browser Using the With Statement Working with Properties Working with Methods Creating an Event Procedure Reserved Macro Names Using Expressions, Variables and Intrinsic Functions Understanding Expressions and Statements Declaring Variables Understanding Data Types Determining the Value of Variables Working with Variable Scope Using Built-in VBA Functions Understanding Constants Using Message Boxes Controlling the Answer to a Message Box Using Input Boxes Declaring and Using Object Variables Controlling Program Execution Understanding Control-of-Flow Structures Using the If...End If Decision Structures Nested If Statements Using the Select Case ... End Select Structure Using the Do ... Loop Structure Using the For ... Next Structure Using the For Each ... Next Structure Guidelines for Use of Control-of-Flow Structures Debugging and Handling Errors Understanding Errors Using Debugging Tools Setting Breakpoints and Using Break Mode Stepping Through Code Trapping Errors with the On Error Statement Understanding the Err Object Working with Inline Error Handling Writing an Error-Handling Routine Working with Forms and Controls Understanding UserForms Creating a Form Displaying and Removing a Form Aligning and Sizing Controls Using the Toolbox Working with a Form's Properties, Methods, and Events Working with Form and Control Properties, Methods and Event Setting the Tab Order Populating a Control Who is this course for? Who is this course for? This course is designed to give proficiency in the Visual Basic Editor (VBE), predominantly making use of Excel objects, understanding Object's Properties, Events and Methods, basic VBA Object oriented programming, event handling, control structures, and debugging tools. Requirements Requirements Preferably, delegates should have attended the Excel Advanced course. Certificates Certificates Certificate of completion Digital certificate - Included