2973 Design courses in Penarth delivered Live Online

Microsoft Excel® in Depth: In-House Training The goal of this course is to provide a deeper understanding of Excel and its intricacies and a new ability to use it efficiently producing the best solutions for your projects. This practical course provides a solid background of the features of Excel and a deeper understanding of its features, benefits and uses. This is not a beginner's course in Excel. You will learn some advanced features such as Pivot Tables, Charting, Tables, Sorting, Filtering and Functions. The goal of this course is to provide a deeper understanding of Excel and its intricacies and a new ability to use it efficiently producing the best solutions for your projects. What you Will Learn You'll learn how to: Use functions like IF, AVERAGE, SUMIF, SUMIFS, SUMPRODUCT, INDEX, MATCH, CHOOSE, DATE, and many more Create meaningful charts Use pivot tables Use Conditional Formatting, Data Validation Take advantage of using Named ranges, do sorting, filtering, tables Getting Started The building blocks of Excel, built-in functions, will be examined The basics of formatting your data will be examined Shortcuts and data manipulation will be explored Built-in features like those mentioned in the 'What you will learn' section above will be explored in detail Excel Functions - VLOOKUP, IF, INDEX, MATCH, CHOOSE, SUMIF, SUMIFS, SUMPRODUCT, DATE, so many more Using Named ranges, Data Validation, Sorting, and Filtering Learn the Name manager; Learn the difference between local and global names; Ensure correct access to linked workbooks; Ensure data accuracy; Learn how to use cascading data validation (for example, once a user chooses 'cars', another cell allows only Ford, Toyota, etc.); Sorting by more than 3 fields; Filtering by font, pattern, or value; See your data based on things like dates in the 3rd quarter, or fields where quantity x price is greater than some fixed value Conditional formatting and data formatting Make relevant data stand out Isolate highs and lows Make error cells invisible Learn about Data bars, Icon sets, and Color scales Highlight differences between worksheets Learn all the codes in the Format/Number list Using cell Styles Learn all about alignment, protection, borders, colors and more Pivot Tables Learn how to summarize large amounts of data with a few clicks Learn various ways of presenting the data Learn the various pivot table tools Learn how to customize and format a pivot table to suit your needs Learn how to group data Learn how to use the various options to present your data Charts Learn how to create a chart with one keystroke! Learn the 11 types of built-in charts Learn how to create a chart with one keystroke! Learn how to customize the charts to make the information tell the right story Learn how to use the design, layout, and formatting available to charts in Excel 2007 Learn embedded charts versus chart sheets Learn how to use modify all the pieces of a chart Array formulas Learn how to use the most powerful formulas in Excel Learn how to combine many formulas into one compact array-formula Learn the real power of these formulas and why regular formulas can't do the job Learn how to use built-in array formulas, like TREND or TRANSPOSE

BOHS P903 - Management and control of evaporative cooling and other high risk industrial systems is there to provide background and an overview of the risk of Legionella infection and how it can be controlled in Evaporative Cooling and other high risk Industrial type systems. It is a requirement of this course that candidates have successfully completed P901 - Legionella- Management and Control of Building Hot and Cold Water Services. Where both P901 and P903 courses are run on subsequent days or as a combined course then this prerequisite is waived.

  The CIPT is the first and only certification of its kind worldwide. It was launched by the IAPP in 2014 and updated in early 2023 to meet the growing need that only tech pros can fill-securing data privacy at all stages of IT product and service lifecycles.  Whether you work in the public or private sector, data privacy skills are quickly becoming a must-have-and that's a great opportunity for you.  The CIPT certification also holds accreditation under ISO 17024: 2012 About This Course   What will you learn?   Critical data protection concepts and practices that impact IT Consumer data protection expectations and responsibility How to bake privacy into early stages of IT products and services for cost control, accuracy and speed-to-market How to establish data protection practices for data collection and transfer How to pre-empt data protection issues in the Internet of Things How to factor data protection into data classification and emerging tech such as cloud computing, facial recognition and surveillance How to communicate data protection issues with partners such as management, development, marketing and legal.   This course has two programmatic modules, the first four areas focus on the fundamentals of data protection. The second module takes the fundamentals and puts it into practice.   MODULE 1: Fundamentals of Information Privacy   Unit 1: Common Principles and Approaches to Privacy This unit includes a brief discussion of the modern history of privacy, an introduction to types of information, an overview of information risk management and a summary of modern privacy principles.   Unit 2: Jurisdiction and Industries This unit introduces the major privacy models employed around the globe and provides an overview of privacy and data protection regulation by jurisdictions and industry sectors.   Unit 3: Information Security: Safeguarding Personal Information This unit presents introductions to information security, including definitions, elements, standards and threats/vulnerabilities, as well as introductions to information security management and governance, including frameworks, controls, cryptography and identity and access management (IAM).   Unit 4: Online Privacy: Using Personal Information on Websites and with Other Internet-related Technologies This unit examines the web as a platform, as well as privacy considerations for sensitive online information, including policies and notices, access, security, authentication and data collection. Additional topics include children's online privacy, email, searches, online marketing and advertising, social media, online assurance, cloud computing and mobile devices.    MODULE 2: Privacy in Technology   Unit 1: Understanding the Need for Privacy in the IT Environment This unit highlights the impact that regulatory activities, security threats, advances in technology and the increasing proliferation of social networks have on IT departments.   Unit 2: Core Privacy Concepts This unit reveals how privacy compliance becomes more attainable through developing information lifecycle plans, data identification and classification systems and data flow diagrams.   Unit 3: Regulations and Standards Impacting Privacy in IT This unit introduces privacy laws, regulations and standards that can help IT professionals design better privacy programmes and systems to handle personal information throughout the data lifecycle.   Unit 4: Privacy in Systems and Applications This unit develops an understanding of the risks inherent in the IT environment and how to address them.   Unit 5: Online Privacy Issues This unit presents information about online threats, threat prevention and the role of IT professionals in ensuring proper handling of user data.   Unit 6: De-identifying and Anonymizing Personally Identifiable Information This unit reveals the importance of personally identifiable information and methods for ensuring its protection.   Unit 7: Cloud Computing This unit evaluates privacy and security concerns associated with cloud services, and standards that exist to advise on their use. Prerequisites   There are no prerequisites for this course but attendees would benefit from a review of the materials on the IAPP site. What's Included?   1 years membership of the IAPP  Refreshments & Lunch (Classroom courses only) Participant Guide Official Study Guides Official Practice Exam Official Q&A The Exam Fees Who Should Attend?   The CIPT credential shows you've got the knowledge to build your organisation's data protection structures from the ground up. With regulators worldwide calling for tech professionals to factor data protection into their products and services, the job market for privacy-trained IT pros has never been stronger. As a result, the CIPT is targeted towards; Data Protection Officers IT Managers and Administrators Records Managers System Developers IT Security specialists Accreditation Our Guarantee   We are an approved IAPP Training Partner. You can learn wherever and whenever you want with our robust classroom and interactive online training courses. Our courses are taught by qualified practitioners with a minimum of 25 years commercial experience. We strive to give our delegates the hands-on experience. Our courses are all-inclusive with no hidden extras.  The one-off cost covers the training, all course materials, and exam voucher. Our aim: To achieve a 100% first time pass rate on all our instructor-led courses. Our Promise: Pass first time or 'train' again for FREE. *FREE training offered for retakes - come back within a year and only pay for the exam.

The Real Estate Investor course primarily focuses on financial modelling and commercial considerations in the real estate industry across various sectors, geographies, and project types.

Online Masterclass: How to Carry Out Market Research to Maximize Business Success Could you turn your brilliant business idea into a viable business? Do you wonder if your proposed new product or service will be a hit with customers? How can you find out before launching? This online Market Research Masterclass will empower you to: • Save time and money by carrying out market research effectively by yourself (without a big budget and without engaging a market research agency) • Design a market research questionnaire that will deliver the answers you are seeking • Analyse the results of your market research and estimate the size of the market • Use the results to fine-tune your business, product, or service so that it provides the benefits that potential customers are seeking Before launching a business, product, or service, it is important to evaluate your potential customer's wants and needs so that you don’t make costly mistakes. Market research allows you to discover exactly what your potential customers are looking for. Then, you'll be able to design and launch products or services that meet those needs, boosting your chances of business success. Join this masterclass if: • You have an idea for a business and want to test it first • You are starting up a business and evaluating one or more potential products or services • You have a well-established business and are thinking of launching a new product or service • You want to find out how to carry out your own market research for your small business. This interactive masterclass will take place on Zoom on Tuesday 15th March 2022 (5-30 pm – 7 pm) and on the following two Tuesdays. A handout will be emailed to you after each session. Further support is available on a 1-2-1 basis if required. This 3-session masterclass normally costs £149. The price has been reduced to £95 for February only. Places are limited. Book now at the special price of £95. If you would like to find out more about the Masterclass, book a free, 15-minute call with me.  

BOHS P904 - Management and control in leisure, display, therapy and other non-industrial systems is there to provide background and an overview of the risk of Legionella infection and how it can be controlled in leisure, display, therapy and other non-industrial water systems. It is a requirement of this course that candidates have successfully completed P901- Legionella- Management and Control of Building Hot and Cold Water Services [Syllabus GM.1]. Where both P901 and P904 courses are run on subsequent days or as a combined course then this pre-requirement is waived.

City & Guilds Level 3 Certificate in Assessing Vocational Achievement This qualification is for anyone working in or looking to enter an assessment role. It is designed for use in England, Wales and Northern Ireland – alternative arrangements exist in Scotland. Learn about the Cavity Training Dental Nurse Assessor Course The units and qualification will provide people who carry out assessment in their organisation with the opportunity to develop and improve their practice as well as achieving a professional qualification for the role. They are available to anyone working in: accredited learning; non accredited learning (where people may assess performance but do not assess for a qualification) and the NQF. Achievers will understand the principles of assessment and have the knowledge to develop and improve systems at their centre. You will gain access to our unique E library of text books. We also have special discounted rates for hard copy text books for our students. Frequently Asked Questions How long is the course? The course duration is 4 to 6 months. When are the classes held? You will attend a live webinar class every Thursday for 16 weeks. Is there an exam at the end? There is no exam at the end, you need to successfully complete 8 assessments and a final professional discussion with your tutor. What if I don’t have student nurses in my practice? We may be able to support you by providing you with learners to assess. Please get in touch. What qualifications do I need to start the course? Preferable English and Maths level 4 and above, you must also be GDC registered. What opportunities for progression is there? This qualification allows candidates to further progress onto various post registration qualifications or career opportunities, such as: – Dental Nurse Teaching – Internal Quality Assurer (IQA) Course Dates 11th April 2024 9:00am - 4:00pm 29th August 2024 9:00am - 4:00pm 2nd January 2025 9:00am - 4:00pm 8th May 2025 9:00am - 4:00pm Costs £800.00 per person (inc. VAT) Other payment options Deposit - £267.00 with 2 further payments Please choose from one of the course start dates above. Each course includes 16 weeks of lessons and up to two months to complete a portfolio and professional discussion.

For new users and the curious. Hello, For new users and the curious. IMPORTANT: Firstly, once you are signed up, send us your requests on what you would like to see within the demonstration and learn on the course. We will then cater for your needs and answer them during the session. This is designed to be an introduction into how to start a room by room survey using the Heat Engineer app, then sending this survey to the online dashboard. We will then go through the different steps to complete this heat loss report. Optional pages will also be worked through and shown. Examples of how to select the flow temperature and the heat source (heat pumps and boilers) will be presented once the heat loss result is completed.

For new users and the curious. Hello, For new users and the curious. IMPORTANT: Firstly, once you are signed up, send us your requests on what you would like to see within the demonstration and learn on the course. We will then cater for your needs and answer them during the session. This is designed to be an introduction into how to start a room by room survey using the Heat Engineer app, then sending this survey to the online dashboard. We will then go through the different steps to complete this heat loss report. Optional pages will also be worked through and shown. Examples of how to select the flow temperature and the heat source (heat pumps and boilers) will be presented once the heat loss result is completed.

For new users and the curious. Hello, For new users and the curious. IMPORTANT: Firstly, once you are signed up, send us your requests on what you would like to see within the demonstration and learn on the course. We will then cater for your needs and answer them during the session. This is designed to be an introduction into how to start a room by room survey using the Heat Engineer app, then sending this survey to the online dashboard. We will then go through the different steps to complete this heat loss report. Optional pages will also be worked through and shown. Examples of how to select the flow temperature and the heat source (heat pumps and boilers) will be presented once the heat loss result is completed.