2683 Learning courses in London delivered Live Online

InDesign face to face training customised and bespoke.

  The GDPR came into effect in May 2018. This legislation is designed to guide organisations in their obligations relative to the processing of personal and sensitive data. About This Course   Organisations are required to comply with the GDPR regardless of their size of business. If you process 'personal data', there is a potential need to be compliant with the legislation. The scope of the GDPR considers how this information is collected, stored, used, transported, shared and disposed of. To ensure organisations' understand this obligation, this interactive one-day course considers both scoping and auditing of an organisations processing activities, as well as an understanding of compliance with GDPR.  Learning Outcomes; GDPR - what is it and how does it apply to us? Personal and sensitive data Lawful basis for processing Consent and the GDPR The Data Protection Act 2018 Data Subject rights The role of the ICO Data breach or Incident? Privacy by Design and by default GDPR Audit checklist Prerequisites   There are no prerequisites to attend this course, however all attendees are expected to have a basic understanding of the Data Protection principles. What's Included?   Refreshments & Lunch (Classroom courses only) Course Slide Deck Quizzes Who Should Attend?   The course is designed for any member of the organisation whose role includes processing personal data. Data Protection Officers, Information Security team members or Information Governance Leads who may also see benefit in attending. Accreditation Assessment    There is no exam with this course but delegates do receive a Course Attendance Certificate and an 8 hour CPD Certificate. Provided by   This course is Accredited by NACS and administered by the IECB

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.

Face to Face training customised and bespoke. One to One Online or Face to Face

Mastering 3ds Max and Photoshop Training Course. earn 3D design, modeling, and rendering with 3ds Max, and seamlessly integrate Photoshop skills. Expert instructors guide you in enhancing images and creating stunning renderings. Our 3ds Max course is designed to help you learn basic and advanced architectural visualisation. Click here for more info: Website Duration: 20 hours Approach: 1-on-1, Customized and Flexible pacing. Session Flexibility: Design your own timetable at your convenient hour between 9 am and 7 pm, Mon to Sat. 20-Hour Comprehensive Training in 3ds Max and Photoshop. Course Breakdown: Module 1: Introduction to 3ds Max (6 hours) Familiarization with 3ds Max's interface and workspace Navigation and basic modeling tools usage Creation and manipulation of primitive objects Object modification with modifiers for specific effects Materials, textures, and basic lighting techniques Introduction to rendering 3D scenes Module 2: Intermediate 3ds Max Techniques (6 hours) Advanced modeling with splines and polygons Camera creation and animation for realistic perspectives Character rigging and animation using bones Particle systems for visual effects and dynamic simulations Designing landscapes and outdoor scenes Exploration of advanced lighting and rendering methods Module 3: Introduction to Photoshop for 3D Artists (4 hours) Understanding Photoshop interface and essential editing tools Seamless integration of 3D models and textures between 3ds Max and Photoshop Creation and editing of textures and materials for realistic surfaces Post-production and compositing techniques to enhance 3D renders Module 4: Advanced Photoshop Techniques for 3D Artists (4 hours) Custom brush and texture creation for artistic elements Non-destructive editing using layer masks and adjustment layers Advanced compositing for seamless 3D element integration Crafting photorealistic textures and materials for impressive visuals Module 5: Project-Based Learning (4 hours) Application of learned techniques to a real-world project 3D modeling, texturing in Photoshop, and final image rendering Instructor feedback for project refinement Presentation of completed projects, showcasing acquired skills. Attendees will learn to craft intricate 3D models using Autodesk 3ds Max, mastering primitive objects, splines, and polygons for complex designs. Advanced Rendering Techniques: Participants will acquire skills in texturing, material application, lighting strategies, and rendering tools, crafting visually striking and lifelike 3D environments. Animation Prowess: Students will delve into object and character animation, simulation of perspectives with cameras, and the dynamic use of particle systems for visual effects and simulations. Essential Photoshop Proficiency: Attendees will gain vital Photoshop skills for post-processing, compositing 3D renders, and creating realistic textures, enhancing the quality of their 3D projects. Hands-On Project Engagement: Through practical projects, participants will receive expert feedback, honing their skills and demonstrating their expertise in real-world applications. Creative Problem-Solving Abilities: Attendees will cultivate creative thinking and problem-solving skills, enabling them to manifest their unique artistic visions in their 3D projects. Skills Acquired: Participants in the Mastering 3ds Max and Photoshop Training Course will gain advanced proficiency in 3D modeling, texturing, lighting, and rendering using 3ds Max. Additionally, they will master digital image manipulation, graphic design, and photo editing techniques using Photoshop. Key skills include: Advanced 3D Modeling and Rendering in 3ds Max Expert Texturing and Lighting Techniques Digital Image Manipulation and Retouching in Photoshop Graphic Design and Visual Communication Skills Job Opportunities: Upon completion, individuals can pursue a range of exciting career opportunities, including: Senior 3D Artist Game Developer Architectural Visualization Specialist Graphic Designer Visual Effects Artist This course equips participants with the expertise needed for roles in animation studios, game development companies, architectural firms, advertising agencies, and more, providing a pathway to thriving careers in the creative industry. Advantages of joining this program: Thorough education: Excel in 3ds Max and Photoshop for high-quality visual effects and motion graphics at a professional level. Certified mentors and industry specialists: Receive instruction from seasoned professionals for expert direction. Interactive online sessions: Engage from any location; no need for travel. Lesson recordings: Access recorded sessions for revision and reinforcement. Long-term email assistance: Receive ongoing support even after the course completion. Complimentary career guidance: Gain valuable industry insights to boost your career prospects. Download Adobe Photoshop Download Autodesk 3dsmax

Duration 1 Days 6 CPD hours This course is intended for This course is for employees of Sun Life who want to learn how to use HUE when working with SQL databases. Overview Upon successful completion of this course, students will be able to operate HUE when interacting with SQL databases. In this course, students will learn how to operate HUE when interacting with SQL databases. Executing a Simple Query Connect to the SQL Database Query a Database Save a Query Modify and Execute a Saved Query Performing a Conditional Search Search Using One or More Conditions Search for a Range of Values and NULL Values Search Data Based on Patterns Working with Functions Perform Date Calculations Calculate Data Using Aggregate Functions Manipulate String Values Organizing Data Sort Data Rank Data Group Data Filter Grouped Data Summarize Grouped Data Use PIVOT and UNPIVOT Operators Retrieving Data from Multiple Tables Combine the Results of Two Queries Compare the Results of Two Queries Retrieve Data by Joining Tables Exporting Query Results Generate a Text File Generate an XML File Additional course details: Nexus Humans SQL Querying Fundamentals with HUE - Part 1 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 SQL Querying Fundamentals with HUE - Part 1 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.

Why 3ds max and V-Ray Training Course? This course is ideal for 3D artists and professionals in various industries seeking advanced rendering skills. If you work with 3ds Max and want to master superior photorealistic rendering using V-Ray, this course is tailored for you. V-Ray, a third-party engine compatible with 3ds Max,  Click here for more info: Website Duration: 10 hours. Approach: Personalized 1-on-1 Sessions and Flexible Learning. Scheduling Flexibility: Mon to Sat between 9 am and 7 pm. Choose your own day and time. 10-hour Vray for 3ds Max Training Course Outline: Module 1: Introduction to Vray for 3ds Max (2 hours) What is Vray and its integration with 3ds Max? Installation and setup of Vray for 3ds Max Understanding Vray interface and workflow Overview of Vray materials Module 2: Lighting with Vray (2 hours) Various lighting techniques in Vray Types of Vray lights and their configurations Creating and managing Vray sun and sky Vray dome lighting and IES light usage Efficient lighting workflows in Vray Module 3: Vray Camera (2 hours) Understanding Vray camera settings Controlling exposure with Vray camera Working with Vray depth of field Creating Vray camera animations Utilizing Vray frame buffer Module 4: Vray Materials (2 hours) Understanding Vray material properties Creating realistic materials using Vray Building and storing custom Vray material libraries Implementing Vray material overrides Module 5: Vray Rendering and Post Production (2 hours) Overview of Vray rendering settings Rendering images and animations with Vray Post-production techniques in Photoshop Understanding and utilizing Vray frame buffer Compositing Vray render elements in Photoshop Working with Vray denoiser Modeling Techniques: Edit Poly Modeling Extrude, Chamfer, Cut, and Slices Symmetry Mirror Modeling Designing furniture and basic architectural models Lines, Shapes, and Plan Import from AutoCAD/Vectorworks Modifiers: Compound objects (Connect, Scatter, Pro Boolean, Loft, Terrain) Bend and Taper Basic Lights: Omni Light, Spot Light, Direct Light Camera Control: Free Camera, Target Camera Texturing and Rendering: Diffuse and Bump Mapping Environment and Background Images Advanced Rendering Techniques (Interior and Exterior Scenes) Vray Specifics: VRay Lights (Plane, Dome, Sphere, Sun, Shadow) VRay Camera Settings (Focal Length, Film Speed, Shutter Speed) VRay Materials (Diffuse Color, Reflection, Refraction, Blurry Reflections) Upon completing the 10-hour Vray for 3ds Max Training Course, participants will: Master Vray Integration: Understand setup, interface, and tools for effective usage. Excel in Vray Lighting Techniques: Learn diverse Vray lighting methods, enhancing scene realism. Vray Camera Control: Manipulate camera settings, exposure, and create dynamic animations. Vray Material Skills: Create realistic materials, manage libraries, and override material properties. Perfect Rendering and Post-Production: Optimize rendering, produce high-quality images, and enhance results in post-production. Advanced 3D Modeling Expertise: Develop complex shapes, utilize modifiers, and import plans effectively. Recommended Resources: "V-Ray My Way: A Practical Designer's Guide to Creating Realistic Imagery Using V-Ray & 3ds Max" by Lee Wylde "3ds Max Modeling for Games: Insider's Guide to Game Character, Vehicle, and Environment Modeling" by Andrew Gahan "Photoshop for 3D Artists, Volume 1" by 3DTotal Publishing Job Opportunities: Students can pursue careers as: 3D Visualization Artists: Creating realistic visuals for architecture, products, and entertainment. Game Designers: Developing game environments and assets for interactive experiences. Architectural Visualizers: Producing high-quality architectural renders for firms and clients. Product Designers: Crafting detailed product visualizations for marketing and prototyping. Freelance 3D Artists: Offering services on platforms like Upwork, catering to diverse client needs. Opportunities exist in architecture, gaming, animation, advertising, and freelancing. A strong portfolio and networking enhance job prospects. Skills Acquired: Vray Advanced Lighting: HDRI, Global Illumination Mastery. Vray Material Expertise: Shaders, Textures, Realistic Material Replication. Scene Optimization: Large-scale Scene Handling, Speed Optimization. Post-Production Skills: Vray and Photoshop Enhancement, Atmosphere Addition. Career Opportunities: Architectural Visualization Specialist Product Design Visualizer 3D Visualization Artist Freelance Rendering Expert In-House Rendering Consultant Learn the advanced Vray rendering skills, 1-on-1 training courses, boost your career prospects in architectural visualization, product design, and animation industries.  Download 3ds max. Autodesk Download a free 30 day trial of 3ds Max, 3D modelling and rendering software for design visualisation, games and animation to create with full artistic Download Vray V-Ray for 3ds max is an integral rendering software for SketchUp, enabling designers to experience their designs in real-time. Say Goodbye to Group Courses: Welcome to our Personalized Learning Experience! Why Choose Us? Our Course Benefits Include: ​ One-on-One Training: Experience personalized coaching from practicing architects and designers tailored exclusively for you. 1-on-1, Face to Face at (SW96DE) or Live online. Open: Monday to Saturday 9 am to 7 pm. Customized Tutorials: Take home bespoke video tutorials designed to enhance your learning journey. Comprehensive Resources: Receive a digital reference book for thorough revision, ensuring you grasp every concept. Free Ongoing Support: Enjoy continuous after-course support via phone or email, guaranteeing your success even after the class ends. Flexible Syllabus: We adapt syllabus and projects to match your needs, ensuring you learn precisely what matters most to you. Official Certificate: Certificate upon course completion. Why Us? Supported Individual Learning: Our courses, ranging from 10 hours to 120 hrs Diploma training Courses, offer unwavering support at every step. With personalized homework assignments and free after-course assistance, we pave the way to mastering software with unparalleled guidance. Personalized Attention, Not Crowded Classrooms: Bid farewell to crowded classrooms. Experience the intimacy of one-on-one learning. This ensures you receive the undivided attention you deserve, fostering a confident and comfortable learning environment. Financial Flexibility: Embarking on your educational journey shouldn't be a financial burden. We offer a variety of payment plans tailored to your needs. Discover the options available to you and start your learning adventure today. Expert Instructors, Real-world Insight: Our instructors are experts meticulously chosen for their extensive industry knowledge and passion for teaching. They are dedicated to imparting invaluable skills to anyone eager to learn.

Become an FSSC 22000 v6 Lead Auditor with our CQI and IRCA certified course. Gain the skills to lead food safety management audits and elevate your career. Enroll today!

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 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. 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

This CPD accredited short course is for everyone who wants to work more effectively with their collaeagues. It will help strengthen personal competencies including listening and communication, understanding and engaging with different perspectives, and working together to create a positive culture in the office or on the shopfloor.