1343 Objective courses delivered Live Online

Learn how to use Macros in Excel to automate your work and start to see the power these can give you. Course overview Duration: 1 day (6.5 hours) Our Excel – Working with Macros course aims to show how macros can be used to automate commonly used commands and processes. This course is designed for existing experienced users of Excel. You should be confident creating and manipulating Excel spreadsheets and creating formulas before attending this course. Objectives By the end of the course you will be able to: Record and run macros Navigate within the Visual Basic Environment Edit pre-recorded macros Create your own functions Content Recording macros Accessing the Developer Tab Naming conventions and storage locations Recording macros Absolute and relative cell addressing Running macros Assigning macros to the Quick Access Toolbar Assigning macros to objects Creating new tabs Workbook macros Recording macros in a specific workbook Saving the workbook as an Excel Macro-Enabled Workbook Creating quick access items specific to workbooks Importing and manipulating data Importing Delimited Text Files Importing Fixed Width Text Files The Visual Basic environment Project explorer Code window Properties window Renaming modules Deleting modules Working with code Code structure Adding comments Navigating within your code Editing macro code Getting help with syntax Debugging Errors Using debug Function procedures Creating function macros

An in depth look at Pivot Tables and their powerful features to summarise and visualize your data. Course overview Duration: 1 day (6.5 hours) Our Excel – Pivot Table Specialist course is a comprehensive guide to working with Pivot Tables for those who need to learn more about the use of Pivot Tables to summarise and analyse information. This course is designed for existing experienced users of Excel. You should be a confident Excel user and be able to create and edit worksheets and write basic formulas. Objectives By the end of the course you will be able to: Build and customise Pivot Tables Group and sort information Filter information Use slicers and the timeline filter Add different summary calculations Create Pivot Charts Add calculated fields and items Content The anatomy of a Pivot Table Using a Pivot Cache Building a Pivot Table The Pivot Table interface Refreshing the Pivot Table Adding column, row, page and data fields Changing data orientation Showing data fields in columns or rows Drilling down to underlying data Setting Pivot Table options Format options Totals and filters options Display and printing options Data options Customising Pivot Tables Modifying field names Data formatting Changing field layout options Changing summary calculations Working with subtotals Filtering and sorting Filtering items Sorting data Value and label filters Creating top 10 reports Using the Search filter Using the Slicer tool Use the Timeline filter Grouping Grouping date fields Grouping numeric fields Adding your own groups Summary calculations Running totals Differences year on year, month on month % Differences year on year, month on month % of Row, Column, Total and other fields Pivot charts Pivot Chart rules Creating a Pivot Chart Working with your Pivot Chart Creating calculations Adding calculated fields Adding calculated items

Unlock Your Filmmaking Potential with Taraq Qureshi** Discover the art of filmmaking with Taraq Qureshi, an acclaimed British producer, director, and actor. With over 20 years of experience in the film industry and a unique perspective as a disabled filmmaker, Taraq brings a wealth of knowledge and passion to his teaching. **About Taraq Qureshi:** - **Seasoned Filmmaker**: With over two decades of experience, Taraq has produced and directed numerous feature films and short films. His journey began in community theatre with a year-long course accredited by Middlesex University London in 1999. - **Industry Leader**: Founder and artistic director of the "Golden Nugget International Film Festival," which has been running for six years. In 2023, Taraq also founded the "Global Film Producers Alliance" (www.gfa.com), a platform dedicated to connecting and supporting film producers worldwide. - **Innovative Storyteller**: Taraq's notable projects include "Strictly Salsa - The Beginning," "The Chosen Ones," and "Do Not Enter." His work is marked by a deep passion for storytelling and a commitment to creating both commercially successful and niche market films. - **Mentor and Educator**: As an acting teacher, creative executive, and development coordinator, Taraq has inspired countless aspiring filmmakers to pursue their dreams and achieve success in the industry. **Why Learn from Taraq?** - **Expert Guidance**: Gain insights from a seasoned professional with a proven track record in the film industry. - **Unique Perspective**: Learn from Taraq's experiences as a disabled filmmaker, providing a fresh and inclusive approach to storytelling. - **Hands-On Learning**: Benefit from practical, real-world advice and techniques that you can apply to your own filmmaking projects. - **Community and Support**: Join a network of passionate filmmakers and industry professionals through Taraq's initiatives, including the "Golden Nugget International Film Festival" and the "Global Film Producers Alliance." **Enroll Now and Transform Your Filmmaking Journey!** Don't miss this opportunity to learn from one of the industry's most respected and innovative filmmakers. Enroll in Taraq Qureshi's online teaching course today and take the first step towards realizing your filmmaking dreams. A comprehensive 10-lesson course on film producing, designed to cover all the essentials within 90-minute sessions each day: --- ### **Day 1: Introduction to Film Producing** - **Welcome and Course Overview:** - Introduction to the role of a film producer. - Course objectives and expectations. - **Types of Producers:** - Understanding the different types of producers (Executive Producer, Line Producer, etc.). - Responsibilities and key tasks for each role. --- ### **Day 2: Development and Pre-Production** - **Project Development:** - Finding and developing a project. - Acquiring rights and working with screenwriters. - **Pre-Production Planning:** - Creating a production schedule and budget. - Assembling the production team. --- ### **Day 3: Financing and Budgeting** - **Film Financing:** - Understanding different sources of film financing. - Pitching to investors and securing funds. - **Budgeting Basics:** - Creating a detailed film budget. - Managing finances and controlling costs. --- ### **Day 4: Legal and Contracts** - **Legal Considerations:** - Overview of legal aspects in film production. - Understanding contracts and agreements. - **Rights and Clearances:** - Securing rights for music, footage, and locations. - Clearing copyright and intellectual property. --- ### **Day 5: Production Management** - **Managing the Shoot:** - Overseeing the production process. - Handling logistics, scheduling, and on-set challenges. - **Communication and Problem-Solving:** - Effective communication with the cast and crew. - Resolving conflicts and troubleshooting issues. --- ### **Day 6: Post-Production** - **Post-Production Workflow:** - Overview of post-production stages. - Working with editors, sound designers, and visual effects artists. - **Quality Control:** - Ensuring the final product meets the desired standards. - Conducting test screenings and making adjustments. --- ### **Day 7: Marketing and Distribution** - **Marketing Strategies:** - Creating a marketing plan for the film. - Utilizing social media and other promotional tools. - **Distribution Channels:** - Understanding traditional and digital distribution. - Strategies for film festivals, theaters, and online platforms. --- ### **Day 8: Film Festivals and Awards** - **Navigating Film Festivals:** - Selecting the right festivals for your film. - Submitting and promoting your film at festivals. - **Awards and Recognition:** - Understanding the importance of awards. - Strategies for winning awards and gaining recognition. --- ### **Day 9: Case Studies and Guest Speakers** - **Case Studies:** - Analyzing successful film productions. - Learning from real-world examples and experiences. - **Guest Speakers:** - Inviting industry professionals to share insights and advice. - Q&A sessions with experienced producers. --- ### **Day 10: Final Project and Presentation** - **Project Work:** - Finalizing a production plan for a hypothetical film. - Preparing for the presentation. - **Presentations:** - Presenting the production plan to the Tutor - Feedback and discussion. - **Course Wrap-Up:** - Reflecting on the course experience. - Final thoughts and future steps. --- This 10-lesson course aims to equip aspiring film producers with the essential knowledge and skills to successfully manage film productions from development to distribution.!

Introduction to Mental Health and Learning Disability in Primary Care (2-Day Course)This course is designed for Nurse Associates, Practice Nurses, Nurse Practitioners (NP's), Emergency Nurse Practitioners (ENP's), Paramedics, and Pharmacists who aim to enhance their knowledge and skills in mental health and learning disability care within the primary care setting.Day 1: Mental HealthLearning Objectives:1. Understand the concept of mental health and its importance in overall well-being.2. Identify common mental health disorders, their signs, symptoms, and risk factors.3. Explore different approaches to mental health assessment and diagnosis.4. Learn evidence-based interventions for various mental health conditions.5. Develop effective communication skills when interacting with individuals experiencing mental health challenges.6. Gain knowledge of available resources and support systems for mental health.Introduction to Performing Annual Reviews for Mental Health Patients:- Understand the significance of performing annual reviews for individuals with mental health conditions.- Explore the assessment tools and methods required for annual reviews in mental health.- Begin to develop skills in conducting annual reviews for mental health patients.Day 2: Learning DisabilitiesLearning Objectives:1. Define learning disabilities and recognize their impact on individuals' lives.2. Identify common types of learning disabilities, their characteristics, and associated challenges.3. Understand the importance of early detection and screening for learning disabilities.4. Learn strategies for supporting individuals with learning disabilities in various settings.5. Explore the rights and legislation related to individuals with learning disabilities.6. Enhance communication and collaboration skills when working with individuals with learning disabilities.Introduction to Performing Annual Reviews for Learning Disability Patients:- Understand the significance of performing annual reviews for individuals with learning disabilities.- Learn the specific assessment tools and methods required for annual reviews in learning disabilities.- Begin to develop skills in conducting annual reviews for learning disability patients.Join us for this informative and interactive 2-day course via Zoom, led by Dr. Tamara Cunningham, and equip yourself with the knowledge and skills necessary to provide comprehensive care for individuals with mental health and learning disability conditions in a primary care setting.

Introduction to Agile and Scrum: In-House Training This half-day course provides an overview of Agile principles and mindset, and the Scrum framework as a key Agile approach. It will provide you with the key benefits of an Agile approach, and its differences with the traditional Waterfall method. Lastly, as Agile is looked upon more frequently as an alternative delivery method, you will review situations where Agile can be adapted outside of software development, where it is most commonly used. What you will Learn At the end of this program, you will be able to: Explain the basics and benefits of using an Agile approach Describe the Scrum framework, its events, artifacts and roles and responsibilities Illustrate Agile approaches outside of Software Development Getting Started Introduction Course structure Course goals and objectives Agile Introduction What is Agile? Agile Benefits Agile Methods Overview of Scrum Scrum Overview Scrum Events Scrum Artifacts Scrum Roles Definition of Done Agile Approaches Outside of Software Development Agile in other environments Product Development Course Development Marketing Agile Project Candidates Summary What Agile is not... Concerns and Pitfalls

Root Cause Analysis (RCA) is used to analyse the root causes of focus events with both positive and negative outcomes, but it is most commonly used for the analysis of failures and incidents. Causes for such events can be varied in nature, including design processes and techniques, organizational characteristics, human aspects and external events. RCA can be used for investigating the causes of non-conformances in quality (and other) management systems as well as for failure analysis, for example in maintenance or equipment testing.

Introducing the the modality of Non-Violent Communication (NVC), also known as Mindful, or Compassionate Communication, this 2-day modular workshop will explore how we express ourselves and how we hear others - how we can increase our ability to create meaningful connections, both with others and with ourselves, even in disagreement, and how we can empower our clients to do the same within their own relationships.

training at home, fitness, personal trainer, workout, health

Why Learn Bespoke AutoCAD Mac Basic-Intermediate Course? Learn AutoCAD using your projects and learn how to use powerful tools and techniques for drawing, dimensioning, and printing 2D drawings with our Intermediate AutoCAD course. Check our Website How long is the training? 10 hours, Choose and split 10 hrs Mon to Sat 9 am to 7 pm. Book online or call 02077202581 or 07970325184.   Method? 1-on-1, available in both in-person and Live Online. Course Topics Include: Building Fundamental Shapes Working with Lines, Arcs, and Polylines Utilizing Grip Tools Precision Object Alignment Data Management and Backups Exploring File Formats Ensuring Disaster Recovery Mastering Object Creation Handling Measurement Units Dynamic Input Techniques Inquiring Commands and Measurement Tools Effective Object Viewing Navigating Zoom and Pan Object Manipulation Strategies Object Selection Methods Swift Object Management Object Transformation Techniques Scaling and Altering Objects Trim, Extend, and Offset Functions Creating Geometric Variations Object Joining and Editing Corner Filleting and Chamfering Stretching Objects Organizing Your Drawings Layer Management Customizing Object Properties Applying Linetypes Layout Design and Setup Efficient Page Configurations Scaling Drawing Views Adding Annotations Multiline and Single-Line Text Creation Text Styling and Editing Dimensioning Concepts Customizing Dimension Styles Dimension Editing Implementing Multileaders Object Hatching Hatching Editing Reusable Content Management Blocks and Symbols Tool Palette Usage Working with Groups Model Space and Paper Space Understanding Layout Creation and Viewports Viewport Scaling Plotting and PDF Output Managing Multiple Sheet Drawings Utilizing Plotstyles Crafting Custom Drawing Templates Download AutoCAD Mac https://www.autodesk.co.uk After completing the AutoCAD for Mac course, learners can expect the following learning outcomes: Proficiency in AutoCAD: Participants will acquire the skills and knowledge needed to confidently use AutoCAD for Mac, including creating and editing drawings, managing objects, and applying precision techniques. Effective Design Skills: They will gain the ability to produce accurate 2D drawings, making them valuable assets in design-related professions. Jobs that individuals can pursue after completing this course include: Draftsperson: Working in architectural, engineering, or construction firms to create technical drawings and plans. CAD Technician: Assisting in the development of designs for various projects, such as product design or urban planning. Interior Designer: Using AutoCAD for space planning and layout design in the interior design industry. Architectural Designer: Collaborating on architectural projects, including creating floor plans and elevations. Mechanical Designer: Participating in the design and development of mechanical components and systems. Civil Engineering Technician: Supporting civil engineers in designing infrastructure projects, such as roads and bridges. Electrical or Electronics Designer: Assisting in the creation of electrical schematics and electronic circuit diagrams. Landscape Designer: Planning and visualizing outdoor spaces, gardens, and landscapes. Completing this AutoCAD course opens doors to various industries where precise and detailed 2D drawing skills are highly valued. The AutoCAD Mac Bespoke 1 on 1 Basics to Intermediate Level Training Course provides participants with a comprehensive skill set, enabling them to attain proficiency in using AutoCAD Mac. This course covers a wide range of functionalities and caters to individuals at all skill levels, whether they are beginners or experienced users. Participants will begin by learning fundamental features such as drawing, editing, annotations, and dimensioning. As they progress, they will delve into more advanced topics like object manipulation, customizing workspaces, and streamlining workflows. Key Benefits of the Course: Mastery of Mac-AutoCAD: Acquire expertise in both essential and advanced techniques for creating precise 2D drawings. Enhanced Productivity: Increase efficiency by implementing time-saving tips and optimizing your work processes. Versatile Design Abilities: Develop the skills to undertake diverse projects in fields such as architecture, engineering, and more. Industry-Relevant Competencies: Elevate your career prospects across various industries by gaining in-demand AutoCAD skills. Access to Recorded Lessons: Review and reinforce your learning at your convenience with access to recorded lesson sessions. Ongoing Email Support: Receive continuous assistance and guidance via email even after completing the course. Enroll today to benefit from interactive learning experiences guided by experienced instructors. Choose between flexible in-person or online sessions, gain access to lesson recordings, and enjoy a lifetime of email support.  Tailored Guidance: Get personalized coaching and instruction tailored to your unique learning needs and objectives. Convenient Scheduling: Choose from flexible training slots available Monday to Saturday from 9 am to 7 pm, accommodating your busy schedule. Versatile Learning Options: Select between in-person training at our location, conveniently situated just 5 minutes away from Oval Tube Station, or participate in live online sessions from anywhere. Engaging Interactions: Participate in interactive sessions designed for questions, discussions, and problem-solving, creating an immersive learning experience. Effective Progression: Accelerate your learning with focused guidance, allowing you to advance at your own pace while mastering the material. Tailored Curriculum: Customize the course content to align with your prior knowledge and specific areas of interest, ensuring a relevant and engaging learning experience. Real-Time Guidance: Receive immediate feedback from the instructor, enhancing your comprehension and skill development. Comprehensive Support: Enjoy ongoing assistance and clarification opportunities through email or additional sessions beyond the course for an in-depth learning experience.

Why Opt for SketchUp Course With Layout and V-Ray? Learn SketchUp with Layout and V-Ray for professional 3D modeling, detailed modeling, and high-quality rendering. Essential for architects and designers for creating visualizations and precise presentations. Check our Website When can I Enrol? 1-on-1 training. Mon to Sat 9 am and 7 pm Book over the Phone 02077202581. Training Duration: 10 hours. You have the flexibility to split these hours over multiple days. Training Method: In-person or live online. Course Outline: SketchUp, Layout, and V-Ray - 10-Hour Training Module 1: Introduction to SketchUp (1 Hour) SketchUp Interface: Explore the basics of the SketchUp user interface. Navigation and View Tools: Learn how to navigate and manipulate 3D space. Module 2: SketchUp Fundamentals (1 Hour) Drawing and Modeling: Begin creating 3D objects and structures. Editing Tools: Manipulate and modify objects efficiently. Module 3: Advanced SketchUp Techniques (1 Hour) Components and Groups: Understand component and group organization. Layers and Scenes: Organize your model and create dynamic views. Module 4: SketchUp for Architectural Design (1 Hour) Architectural Modeling: Explore architectural modeling techniques. Interior Design: Apply SketchUp to interior space design. Module 5: Landscape Design with SketchUp (1 Hour) Landscape Modeling: Use SketchUp for outdoor environment design. Terrain and Topography: Model terrain and natural landscapes. Module 6: Introduction to Layout (1 Hour) Layout Basics: Get familiar with the Layout interface. Setting Up Viewports: Begin using viewports for presenting your SketchUp models. Module 7: Creating Layout Documents (2 Hours) Document Setup: Set up and customize your layout documents. Inserting SketchUp Models: Import SketchUp models into Layout viewports. Dimensioning and Labeling: Add dimensions and labels to your layout documents. Module 8: Presentation and Export (1 Hour) Styling and Rendering: Enhance your SketchUp models for presentations. Exporting and Printing: Learn how to export and print your Layout documents. Module 9: Introduction to V-Ray (1 Hour) V-Ray Interface: Get acquainted with the V-Ray user interface. Materials and Lighting: Learn the basics of materials and lighting in V-Ray. Module 10: Advanced V-Ray Rendering (1 Hour) Advanced Materials: Explore advanced material creation and customization. Realistic Lighting: Master V-Ray lighting techniques for photorealistic renders. By the end of this 10-hour course, you'll have a comprehensive understanding of SketchUp for 3D modeling, Layout for professional documentation, and V-Ray for rendering, empowering you to create stunning 3D designs and presentations. Upon completing this course, you will: Master SketchUp: Create 3D models with precision and creativity. Layout Proficiency: Produce professional design documentation. V-Ray Rendering Skills: Craft photorealistic visualizations. Advanced Techniques: Explore advanced modeling and rendering. Project Experience: Apply skills to real-world projects. Job Opportunities: Architectural Designer Interior Designer Landscape Designer CAD Technician 3D Modeler Rendering Specialist Visualization Artist Layout Specialist Freelance Designer Urban Planner Learning Objectives: Mastering SketchUp with Layout: Learn to create precise 2D floor plans, elevations, and construction documents using SketchUp's Layout tool. Advanced Rendering with V-Ray: Dive into V-Ray to create photorealistic renders, enhancing your visualizations with lighting, textures, and realistic materials. Collaborative Design: Develop skills for collaborative project planning and presentation, enabling effective communication with clients and teams. Job Opportunities: Architectural Visualization Specialist: Create detailed architectural visualizations and presentations for clients and marketing purposes. Interior Designer: Design interior spaces, produce detailed layouts, and create realistic renders for residential and commercial projects. 3D Visualization Artist: Work in the gaming or animation industry, creating 3D models and environments. Freelance Rendering Expert: Offer specialized rendering services to architectural firms, interior designers, or real estate developers. Layout Designer: Specialize in creating professional 2D layouts and construction documents for architectural projects. Why Choose Us? Tailored One-on-One Training: Personalized coaching from industry experts, in-person or online, Monday to Saturday. Customized Tutorials: Enhance skills with exclusive video tutorials designed for your learning journey. Comprehensive Resources: Access a digital reference book for thorough concept revision. Free Ongoing Support: Enjoy continuous assistance via phone or email even after the course ends. Flexible Syllabus: Adapted to your needs for focused and efficient learning. Official Certification: Ccertificate upon course completion. Why Us? Supported Individual Learning: Unwavering support with personalized homework and post-course assistance. Personalized Attention: Experience one-on-one learning, fostering a confident and comfortable environment. Financial Flexibility: Choose from various payment plans tailored to your budget. Expert Instructors: Learn from industry experts dedicated to your success.