623 Courses delivered Live Online

www.linkedin.com/company/chdlondon www.instagram.com/chd_london www.facebook.com/CHDLondon www.twitter.com/CHD_London

Course Objectives The goal of this course is to provide you with the knowledge required to use more advanced functions and formulas and work with various tools to analyse and present data in spreadsheets, such as sorting, filtering, applying conditional formatting and charting the data. ' Customer Feedback Really useful and engaging course. Learnt a lot that will be very beneficial in my job. Trainer was great. Kelly Moreley - TACT Very happy with the course. Worked as a good refresher from what I knew already and enhanced my knowledge further in formulas + vlookup and shortcut keys. Jenny Price - Acer 1 year email support service Take a look at the consistent excellent feedback from our 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. 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. Recap on Excel formulas and calculations Overview of formulas in Excel Relative, Absolute and Mixed cell references Group editing worksheets Autofill and Flash Fill Changing Excel’s environment Options Changing the default number of sheets Creating an Autofill Custom List Adding tools to the Quick Access Toolbar Mastering Excel Tables Introducing Excel Tables Formatting a Table Creating Calculated Columns Using Slicers to filter your data Using Totals to get statistics out of your data Removing duplicates Converting Tables back to normal Ranges Using names Ranges In Excel formulas As a way of navigating through the workbook Advanced Formulas Simple IF examples Using IF to check if a cell is blank Nested IFs VLOOKUP HLOOKUP Text Functions Date Functions Conditional formatting Apply Conditional Formatting Customising Conditional Formatting Using Icons in Conditional Formatting Using Formulas to conditionally format cells Linking spreadsheets and workbooks Making a reference to another worksheet Making a reference to another workbook Editing links Troubleshooting links Analysing databases Quick analysis Sorting a database Apply filters to a database Advance filter Sorting and Filtering by Conditional Formats Charts Analyse trends in data using Sparklines Creating charts from start to finish Exploring the different Chart Types Apply Chart Styles Formatting Chart Elements Filtering Charts by Series or Categories Adding a Trendline to a Chart Create a Chart Template Attaching security to a spreadsheet and workbook Protect Cells Protect Structure of worksheets Protect a Workbook by adding passwords Introduction to Pivot Tables What are Pivot Tables? Using recommended pivot tables to analyse your data Who is this course for? Who is this course for? For those who want to explore in more detail formulas and functions, data analysis and data presentation. Requirements Requirements Preferably, delegates would have attended the Excel Introduction 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 award introduces the critical concepts associated with AI and explores its relationship with the systems and processes that make up the digital ecosystem. It explores how AI can empower organisations to utilise Big Data through the use of Business Analysis and Machine Learning, and encourages candidates to consider a future vision of the world that is powered by AI.

Autocad face to face training customised and bespoke.

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: Collaborate on documents Add reference marks and notes Make long documents easier to use Secure a document Work with forms '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. Collaborating on Documents Modify User Information Share a Document Compare Document Changes Review a Document Merge Document Changes Review Tracked Changes Coauthor Documents Adding Reference Marks and Notes Add Captions Add Cross-References Add Bookmarks Add Hyperlinks Insert Footnotes and Endnotes Add Citations and a Bibliography Simplifying and Managing Long Documents Insert Blank and Cover Pages Insert an Index Insert a Table of Contents Insert an Ancillary Table Manage Outlines Create a Master Document Securing a Document Suppress Information Set Formatting and Editing Restrictions Add a Digital Signature to a Document Restrict Document Access Forms Create Forms Manipulate Forms Who is this course for? Who is this course for? This course is designed for users who would like to create and work with lengthy and well structured documents, collaborate with others on documents, and create forms in Microsoft Word Requirements Requirements Preferably, delegates should have attended the Word Intermediate course. 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

  The GDPR Foundation training enables delegates to understand how to define and implement a privacy compliance framework aligned to best practice. During this training course, you will be able to understand the fundamental privacy principles and become familiar with the role of the Data Protection team and the DPO. About This Course   At Foundational level, candidates prove they have understood the fundamental methodologies, requirements, best practice and management approach of a Privacy Compliance Framework. Learning principles;   Understand the General Data Protection Regulation requirements and the fundamental principles of privacy Understand the obligations, roles and responsibilities of the Data Protection Officer Understand the concepts, approaches, methods and techniques to effectively participate in the implementation process of a compliance framework with regard to the protection of personal data.   Educational approach; Lecture sessions are illustrated with practical questions and examples Practical exercises include examples and discussions Practice tests are similar to the Certification Exam   Course Agenda Day 1: Introduction to GDPR and Data Protection Principles Day 2: The General Data Protection Regulation requirements and Certification Exam Prerequisites   There are no prerequisites for this course. What's Included?   Refreshments & Lunch (Classroom courses only Course Slide Deck CPD Certificate   Who Should Attend?   Individuals involved in the processing of Personal Data and Information Security Individuals seeking to gain knowledge about the main privacy principles Individuals interested to pursue a career in Data Protection Provided by   This course is Accredited by NACS and Administered by the IECB Assessment   Delegates sit a combined exam, consisting of in-course quizzes and exercises, as well as a final 40 question, multiple choice exam on Day 2 of the course. The overall passing score is 70%, to be achieved within the 60 minute time allowance. Exam results are provided within 24 hours, with both a Certificate and a digital badge provided as proof of success.

Unity 3d face to face training customised and bespoke.

A practical programme for HR professionals who are keen to develop a coaching style of interaction either within their teams and/or with business stakeholders. Develop skills in taking a more engaging, non-directive approach to supporting your business and to encouraging a coaching style of communication in your organisation.

Why learn V-Ray for architects and designers? Realistic Visuals: V-Ray produces lifelike renderings for precise design visualization. Enhanced Presentations: Stunning visuals secure approvals and investments effectively. Time and Cost Efficiency: Streamlines design iterations, cutting down prototyping expenses. Click here for more info: Website Scheduling Your Training: You can also call 02077202581 to book. Training Duration: 10 hours Method: In-person face-to-face sessions or live online.  Course Title: V-Ray Essentials for Architects and Designers Course Duration: 10 Hours Course Overview: Unlock the power of V-Ray, the industry-standard rendering software, and elevate your architectural and design projects to new heights. In this comprehensive 10-hour course, you'll dive deep into V-Ray and gain the skills needed to create stunning visualizations. Whether you're an architect or designer, this course will equip you with the knowledge and techniques to bring your ideas to life. Module 1: Introduction to V-Ray (1 hour) Understanding the V-Ray interface Navigating the V-Ray toolbar Setting up your first V-Ray project Module 2: Lighting Mastery (2 hours) Utilizing various light sources Achieving realistic daylight simulations Creating artificial lighting setups Mastering V-Ray's advanced lighting tools Module 3: Material Magic (2 hours) Exploring V-Ray materials Creating realistic textures and finishes Understanding material properties Working with material libraries Module 4: Perfecting Render Settings (1 hour) Configuring render settings for optimal results Setting up render elements for post-processing Achieving photorealistic renderings Module 5: Advanced Rendering Techniques (2 hours) Fine-tuning render settings for specific scenarios Creating stunning visual effects Optimizing render times Rendering animations and walkthroughs Module 6: Realistic Environments (1 hour) Incorporating background images and environments Adding context to your architectural scenes Achieving seamless integration of 3D models and backgrounds Module 7: Portfolio-Ready Projects (1 hour) Applying V-Ray skills to complete a professional project Assembling a portfolio showcasing your work Course Benefits: Master V-Ray for architectural and design projects. Create photorealistic renderings with confidence. Customize lighting, materials, and textures for your designs. Optimize render settings for efficiency and quality. Enhance your portfolio with impressive visualizations. Receive lifetime email support for continued guidance. Explore career opportunities as a rendering specialist. Who Should Attend: Architects Interior Designers 3D Artists Visualization Specialists CGI Artists Architectural Renderers Game Environment Artists Virtual Reality (VR) Developers Anyone passionate about architectural rendering and design Method of Instruction: 1-on-1 personalized training In-person or live online sessions Hands-on exercises and practical projects Upon completing the "V-Ray Essentials for Architects and Designers" course, participants will: V-Ray Proficiency: Master V-Ray rendering for photorealistic visualizations. Advanced Lighting Skills: Create dynamic and realistic lighting scenarios. Material Expertise: Customize textures and materials for enhanced visuals. Optimized Renders: Configure settings for efficient workflows. Advanced Techniques: Learn rendering tricks for stunning effects. Realistic Environments: Integrate 3D models seamlessly into real-world settings. Portfolio Development: Build a competitive portfolio showcasing advanced rendering skills. Benefits for Interior Designers and Architects: Enhanced Visualization: Improve design communication with realistic visualizations. Competitive Edge: Stand out with high-quality renderings. Efficient Decision-Making: Experiment and refine designs before execution. Streamlined Workflows: Produce quality renders efficiently. Career Opportunities: Explore roles in architectural visualization, 3D art, and CGI. In short, this course equips interior designers and architects with V-Ray skills to create impressive visualizations, improve communication, gain a competitive edge, streamline workflows, and expand career options. Master Vray Rendering: Achieve proficiency in Vray rendering for architectural and interior design projects. Industry Excellence: Learn industry-standard practices and workflows to produce high-quality results. Flexible Learning: Choose between in-person or live online training to suit your schedule. Resourceful Learning: Access recorded lessons for convenient review and reinforcement. Ongoing Support: Benefit from lifetime email support, ensuring you receive guidance beyond the course. Career Guidance: Receive free career advice to make informed decisions about your professional growth. Upon completion, our Vray for Architects and Interior Designers Training Course opens doors to various career opportunities in the architecture and design industry. Graduates with advanced rendering skills can explore roles such as: Architectural Visualizer Interior Designer 3D Artist Rendering Specialist Visualization Specialist CGI Artist Architectural Renderer Game Environment Artist Virtual Reality (VR) Developer Freelance Rendering Professional Vray Mastery: Gain expertise in Vray rendering for architectural and interior design projects. Industry-Approved Methods: Learn tried-and-true workflows for exceptional results. Flexible Learning: Opt for in-person or live online training at your convenience. Easy Review: Access recorded lessons to reinforce your knowledge conveniently. Lifelong Support: Receive ongoing guidance even after course completion. Career Consultation: Make informed decisions about your professional growth. Career Opportunities: Unlock doors to diverse roles in architecture and design, including Architectural Visualizer, Interior Designer, 3D Artist, Rendering Specialist, and more.