2427 Courses in Cardiff delivered Live Online

Data Protection and Clinical Trials

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

Autoskool Driving School offers you a very competitive rate of Automatic driving lessons with a quality service to match. We also offer you a simple price structure, we don’t believe in charging you extra during the evening or the weekend. Our lessons are conducted on a 1-1 basis and we will give you a full two hour lesson. We accept payment via PayPal, credit card over the phone or you can pay cash to the instructor on the day of your lesson.

Course Objectives At the end of this course you will be able to: Do advance Table design Do advance Query design and Action Querys Do advance Form design with the use of macros and buttons Export and import data to and from different sources. 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. 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. Advanced Table Design Advanced Field Properties Table Properties Advanced Query Design Advanced Naming Conventions Join Tables in Queries Manage Query Joins Use Self-Joins in Queries Summarise Data in Queries Parameter Queries Action Queries Crosstab Queries Advanced Form Design Create Subforms and Linked Forms Form Controls Command Buttons Form Properties Interface, Start-Up and Navigations Forms Working with Macros Create Single Macros Run Macros Work with Sub Macros Use Conditional Macros Run Macros from Buttons Assign Macros to Events Extending Data Reach Import Data Export Data Work with Linked Tables Managing Databases Object Dependencies Database Documenter Performance Analyzers Regular Management of a Database Access Database Security Who is this course for? Who is this course for? The course is aimed at all users who would like to obtain the necessary skills to create advanced table, query, form and reports as well as to automate tasks with the use of macros. 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

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

Learn CAD in 10 hrs

Autocad face to face training customised and bespoke. In-person

3ds Max and Vray Training 1-2-1

Who is this course for? Film and Game Design Training Classes is tailored for individuals passionate about 3D for Games. Ideal for those in London seeking specialized skills for lucrative job opportunities in the gaming industry. Software we teach: 3ds max or Maya, Vray, After effects and Photoshop. Check our Website Duration: 40 hours. 1-on-1 Training. When can I book: 9 am - 4 pm (Choose your preferred day and time once a week). Monday to Saturday: 9 am - 7 pm (Flexible timing with advance booking).  Course Title: Film & Game Design Training Classes Option A - 40-Hour Program: Option A offers comprehensive training for aspiring film and game designers, covering vital industry software and skills. Module 1: 3ds Max and Advanced Animation (20 hours) - Introduction to 3ds Max: Interface overview. - Basic 3D Modeling: Creating simple 3D objects. - Advanced 3D Modeling: Complex modeling techniques. - Texturing and Materials: Applying textures and materials. - Lighting and Rendering: Scene lighting and rendering setup. - Character Animation: Rigging and animating characters. - Advanced Animation Techniques: Keyframes, motion paths, and more. - Scene Composition: Assembling complex scenes. Module 2: Vray (6 hours) - Vray Introduction: Understanding Vray renderer. - Lighting with Vray: Creating realistic lighting setups. - Material Creation: Crafting materials for realistic surfaces. - Rendering with Vray: Optimization and execution. Module 3: Photoshop (6 hours) - Photoshop Basics: Navigating the interface. - Image Editing: Crop, resize, and enhance. - Layer Management: Working with layers. - Text and Typography: Adding and manipulating text. - Photo Manipulation: Advanced image techniques. - Creating Visual Assets: Designing textures and graphics. Module 4: After Effects: Video and Sound Editing (8 hours) - Introduction to After Effects: Interface overview. - Video Editing: Cut, trim, and arrange video clips. - Transitions and Effects: Apply visual effects and transitions. - Sound Editing: Add and edit audio tracks. - Motion Graphics: Create motion graphics and titles. - Exporting and Rendering: Prepare projects for final output. Film & Game Design Training Course Information Are you ready to explore our Training Course for Film & Game Designers? Here's a comprehensive overview to guide you through: When Can I Book This Training Course? Personalize your training with our flexible 1-on-1 sessions. Tailor your schedule by pre-booking your preferred hours. Available Monday to Saturday, 9 a.m. to 7 p.m. For phone bookings, call 02077202581. Training Duration The course spans 40 hours, allowing flexibility for your ideal schedule. Training Method Experience 1-on-1 training, in-person Face to Face or Live Online. Expect personalized attention, tailored content, flexible learning, and individual support. Opt for Live Online 1-on-1 sessions via Zoom for convenience. Enroll Today Ready to start your exciting journey? Click the link below to enroll in our 1-on-1 Course. Film & Game Design Training Overview In our comprehensive training program for film and game designers, refine your skills using industry-leading software tools. This prepares you to bring your creative visions to life. Option A: 3ds Max and Advanced Animation (20 hours) Vray (6 hours) Photoshop (6 hours) Aftereffects: Video and Sound Editing (8 hours) Option B: Maya and Advanced Animation (20 hours) Vray (6 hours) Photoshop (6 hours) Aftereffects: Video and Sound Editing (8 hours) Both options offer flexibility for Mac and Windows operating systems, ensuring accessibility for all learners. Key Benefits Price Assurance: Exceptional value for your film and game design career investment. One-on-One Training: Customized learning for your unique style. Flexible Scheduling: Choose your training time, available Monday to Sunday, 9 am to 8 pm. Lifetime Email and Phone Support: Ongoing assistance beyond training for your career growth. Computer Configuration Assistance: Guidance for seamless software installation. Referral Benefits: Special discounts for referrals and savings on group training. Embark on a transformative journey and unlock your potential in the thrilling fields of film and game design!

Who is this Level 3 NVQ aimed at? The experienced worker qualification is for practising electricians with at least 5 years experience but have never formally completed an industry apprenticeship or equivalent Level 3 NVQ Qualification. This is suitable for self-employed and employed electricians. This is the Level 3 pathway for practising electricians to obtain your ECS Gold Card and JIB Grading. To complete the full qualification you will also need to: Have completed an AM2e Assessment Have a current Wiring Regulations Qualification BS7671 Have an initial verification qualification such as a C&G 2391-50 What’s involved in the qualification? After an initial Skills Scan, we will discuss the gaps that need to be filled and you will be assessed using a range of methods to complete the evidence gathering process.There will also be Professional Discussions to discuss areas of expertise and you can choose either an installation or maintenance route based on the work you carry out.There are seven Performance Units to be assessed for the qualification, these are: Apply Practices and Procedures for Maintenance Apply Health, Safety and Environmental Considerations Organise and Oversee the Electrical Work Environment Apply Design and Installation Practices and Procedures Terminate and Connect Conductors Inspect, Test and Commission Electrical Systems Apply Fault Diagnosis and Rectification On completion of the Experienced Worker assessment you will be able to use the qualification to apply for a JIB Gold Card. This qualification is for experienced electricians who can demonstrate over 5 years experience.It is not suitable for new entrants or those currently on an apprenticeship.