1994 Courses in Cardiff delivered Live Online

Tools and techniques to make solving problems and decision-making a breeze!

"Enhance your love life with our Professional Dating Coach in London. Gain confidence, master online dating, and find meaningful connections with expert guidance tailored to your needs. Start your journey to lasting love today!

This Practical SQL course, is designed make you fully conversant with queries, DML and DDL statements. Hands-on, Practical SQL course. You will get the PCWorkshops SQL Course Certificate. Max 4 people per course, to keep it personalised.

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 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 classrom, one to one, tailored and bespoke courses. Tailored 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. 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

Revit Architecture Training is for 15 hours £525, and the Revit classes are one-to-one which will improve your learning. Revit Architecture course is 100% practical and hands-on training.

Why Learn Photoshop Basics to Advanced Training Course? Click here for info In this course, you'll gain basic to advanced Photoshop skills, to edit photos and images, and advanced tasks like creating product designs and photorealistic illustrations. The course is customizable to your requirements, and you'll engage in design projects to enhance your portfolio. Duration: 20 hrs. Method: 1-on-1 Schedule: Tailor your own schedule by pre-booking a convenient hour of your choice, available from Mon to Sat 9 am and 7 pm. Adobe Photoshop Training in London - In-Person & Live Online As the most renowned image editing software, Photoshop provides complete control over your images. With a wide range of editing tools, users can enhance, retouch, and manipulate colors to create stunning visuals. Beyond static images, Photoshop is also capable of editing videos, graphic design, and 3D images. Choose our Photoshop course for a solid foundation in creative visuals, covering image adjustment, composition, and common fixes. For a deeper understanding, our Advanced course core introduction teaches advanced techniques like color fills, text and layer styling, and web-ready artwork creation. Explore our masterclass options for further training and insights at an advanced level. All beginner courses are available in class or online 1-on-1. Photoshop Basics to Advanced Training Course - 20 hours Course Outline: I. Introduction to Photoshop (1 hour) Get familiar with Adobe Photoshop and its applications Set up a personalized workspace for efficient workflow II. Working with Layers and Masks (2 hours) Explore layer styles and advanced management techniques III. Selections and Retouching (2 hours) Master selection and retouching tools for precise edits IV. Working with Text and Vector Graphics (1 hour) Create and format text effectively Combine vector elements with raster graphics V. Color Correction and Image Adjustments (2 hours) Adjust image color and tone for better visual impact VI. Filters and Effects (1 hour) Apply filter effects for creative enhancements VII. Advanced Techniques (6 hours) Dive into advanced layer masking and selection tools Work with 3D models and design for mobile applications VIII. Project-Based Learning (3 hours) Apply Photoshop techniques to real-world projects IX. Advanced Rendering Techniques (1 hour) Explore advanced rendering effects for photorealistic results X. Final Project and Post-Production Techniques (1 hour) Complete a comprehensive final project and implement post-production techniques Enroll now to elevate your Photoshop skills and create visually stunning designs with confidence. Learn from experienced instructors in interactive in-person or live online sessions. Master Adobe Photoshop and unlock your creative potential. By completing the Photoshop Basics to Advanced Training Course, participants will: Develop Proficiency: Acquire a strong command of Adobe Photoshop, mastering both foundational and advanced techniques. Image Editing Expertise: Gain the skills to efficiently edit and retouch images, remove unwanted elements, and enhance visuals using a variety of tools. Creative Design Skills: Explore creative design concepts, combining text, vector graphics, and raster elements for custom designs. Color Correction and Enhancement: Learn to adjust image colors, tones, and apply advanced color correction techniques for professional results. Filters and Effects: Apply various filter effects creatively, giving artistic enhancements to images and designs. Project-Based Learning: Gain practical experience by working on real-world projects, creating composite images, posters, social media graphics, and more. Advanced Rendering Techniques: Discover rendering techniques for achieving photorealistic and visually impactful results. Post-Production Expertise: Implement post-production techniques to refine and polish final outputs for professional-grade designs. Customization and Automation: Create and utilize custom brushes, actions, and scripts to streamline workflows and improve efficiency.

These courses are designed for aspiring 3D artists, students, graduates, creative professionals, CAD designers, and anyone passionate about 3D art. Whether you're looking to launch a career, enhance existing skills, or explore new creative avenues, our courses provide comprehensive training tailored to various skill levels and interests. Check our Website Duration: 16 hours Method: 1-on-1 and Tailored content Dates and Times: Select your preferred hour from Monday to Saturday, available between 9 am and 7 pm. CAD and 3D Studio Max Training Course Duration: 16 hours Course Outline: Introduction to AutoCAD Familiarizing yourself with the AutoCAD interface Navigating the drawing environment Mastering fundamental 2D geometry creation Exploring essential drawing tools and commands Introduction to blocks and symbols for efficient design Advanced AutoCAD Techniques Delving into advanced drawing methods Proficiently manipulating and editing 2D geometry Crafting custom symbols and blocks for enhanced productivity Working with text and annotations for clear communication Utilizing layers and line types for organized design 3D Modeling in AutoCAD Venturing into the world of 3D modeling Precision crafting of 3D solids and surfaces Seamless modification and manipulation of 3D geometry Crafting custom materials and textures for realistic designs Effective utilization of AutoCAD's lighting and camera systems Introduction to 3ds Max Embracing the 3ds Max interface and configuring the workspace Proficiency in navigating within 3ds Max Understanding the viewport for optimized design Exploring basic 3D modeling techniques in 3ds Max Materials and Textures in 3ds Max Application and modification of textures for enhanced designs Mastering the art of UVW mapping for precise texturing Utilizing the material editor for creative freedom Crafting custom materials aligned with your design vision Harnessing the power of Vray materials for lifelike renders Lighting in 3ds Max Introduction to various lighting techniques Grasping light properties for impactful designs Strategic setup of lights to enhance scenes Illuminating scenes with Vray lights Cameras in 3ds Max Mastery of camera systems in 3ds Max Exploring camera properties for cinematic effects Creating animations with cameras for dynamic scenes Utilizing Vray cameras for stunning renders Rendering in 3ds Max Unveiling the art of rendering Utilizing Vray Global Illumination for realistic lighting Leveraging Vray Physical Cameras for precise control Enhancing scenes with Vray HDRI Lighting Following a Vray Rendering Workflow for professional results Advanced Modeling Techniques Proficiency in crafting complex geometry Utilizing modifiers for intricate designs Exploring polygonal modeling for versatile creations Creating both organic and inorganic models with expertise Unleashing the potential of advanced modeling techniques Projects Application of acquired skills to create real-world scenes Designing a detailed interior scene with meticulous attention Crafting a visually impactful exterior scene Creating a complex scene featuring multiple objects and materials Course Requirements: A computer with AutoCAD and 3ds Max installed Basic knowledge of computer operations A keen interest in 2D and 3D modeling and design Course Goals: Upon course completion, you will possess a comprehensive understanding of AutoCAD and 3ds Max, enabling you to craft intricate 3D scenes enriched with advanced materials, textures, lighting, and rendering. These newfound skills empower you to advance your capabilities in both 2D and 3D modeling and rendering. Upon successful completion of this comprehensive AutoCAD and 3ds Max training, participants will attain the following skills: AutoCAD Proficiency: Mastery of 2D geometry, drawing tools, and symbols. Advanced AutoCAD Techniques: Expertise in editing, custom blocks, text, and layers. 3D Modeling in AutoCAD: Competence in crafting 3D solids, textures, and lighting. Introduction to 3ds Max: Proficient navigation of the interface and fundamental 3D modeling. Materials and Textures: Application and customization of textures using Vray. Lighting and Cameras: Mastery of lighting and camera systems within 3ds Max. Rendering: Production of high-quality renders through Vray. Advanced Modeling: Proficiency in handling complex geometry and creating organic models. Real-World Projects: Capability to design interiors, exteriors, and intricate scenes. Skills Acquired: Mastering 3D Modeling Techniques in 3D Studio Max Advanced Texturing and Material Application Skills Proficiency in Lighting and Rendering Techniques Expertise in Animation and Keyframe Techniques Comprehensive Scene Composition and Camera Setup Knowledge Career Opportunities: Senior 3D Modeler Experienced CAD Designer Lighting and Rendering Specialist Animation Director Architectural Visualization Expert Upon completing our 3D Studio Max and CAD Courses, students will acquire advanced 3D modeling, animation, and CAD design skills, paving the way for rewarding careers in roles such as Senior 3D Modeler, CAD Designer, Lighting Specialist, Animation Director, and Architectural Visualization Expert. You will gain access to the following benefits: An Autocad and 3ds Max Certificate of Attendance. A comprehensive PDF training guide for 3ds Max and CAD. Real-time feedback during sessions, with the option to record them as video archives. We offer the following advantages: Price guarantee to ensure the best value for your investment. Personalized one-on-one training for focused learning. Flexible scheduling options available seven days a week, from 9 am to 7 pm. Lifetime email and phone support for ongoing assistance. Assistance with software installation and computer setup. Referral discounts and special offers on group training courses.

This qualification is made up of one mandatory and one optional unit. There are 2 x 1 day workshops that will help develop knowledge of the principles, theories and practices in Learning and Development The course is aimed at practitioners such as tutors, trainers, assessors and quality assurers who want to develop their skills and knowledge in their own area of learning delivery. You will meet other practitioners who are responsible for process, people or practice within Learning and Development. You will get to share good practices and ideas for improvement and will be able to apply these in your workplace. You will be expected to carry out research, complete assignments and implement change in your organisation, with the mentoring support of our Learning Advisor.

Course Objectives At the end of this course you will be able to: Record and edit a Macro Assign macros to keyboard shortcuts, Quick Access Toolbar, Buttons and Shape objects. Use the Visual Basic Editor; change the properties of an object; add a module to a project; write the code for a procedure and then run it; and use the Object Browser to search procedures Manipulate data by declaring variables of different data types; combine data by using expressions; use functions to accept input and display output; and declare variables and procedures with the appropriate scope Use decision structures to create procedures that make decisions; and use loop structures to perform repetitive tasks Create an error handling routine in case things go wrong with VBA code ' 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 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 trainer was very knowledgeable, kept everyone involved and was enthusiastic. A great experience.. Simon Harper - Lloyd's of London My learning experience was awesome. Perdinand Reagan - Subsea7 Very nice and relaxed approach to teaching. Was definitely a good learning experience. Jerome Pupe - S5 Agency World The Trainer – Very positive + patient + helpful + thorough Agnes Souza - Direct Wines ' 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 classroom, one to one, tailored and bespoke courses. Tailored 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. Introduction to Macros and VBA Introducing Visual Basic for Applications Recording a Macro Naming conventions for Macro Procedures Running a Macro Absolute or Relative Cell Referencing Saving and Opening Files with Macros Making macros always available Adding Macros to Keyboard Shortcuts, Quick Access Toolbar, Buttons and Shapes Editing a Macro in the Visual Basic Editor Understanding the Development Environment Customising the Editor Tips for General Typing in VBA Using Visual Basic Help Working with Procedures Program Design Understanding Modules Naming Rules Creating a Module Understanding Procedures Programming Macro Concepts Creating a Subroutine Creating a Function Understanding Arguments Exiting Procedures Calling Procedures Objects, Properties, Methods and Events Understanding Objects Properties, Methods, and Events Navigating the Object Hierarchy Understanding Collections Accessing a Member of a Collection Understanding Hierarchy Using the Object Browser Using the With Statement Working with Properties Working with Methods Creating an Event Procedure Reserved Macro Names Using Expressions, Variables and Intrinsic Functions Understanding Expressions and Statements Declaring Variables Understanding Data Types Determining the Value of Variables Working with Variable Scope Using Built-in VBA Functions Understanding Constants Using Message Boxes Controlling the Answer to a Message Box Using Input Boxes Declaring and Using Object Variables Controlling Program Execution Understanding Control-of-Flow Structures Using the If...End If Decision Structures Nested If Statements Using the Select Case ... End Select Structure Using the Do ... Loop Structure Using the For ... Next Structure Using the For Each ... Next Structure Guidelines for Use of Control-of-Flow Structures Debugging and Handling Errors Understanding Errors Using Debugging Tools Setting Breakpoints and Using Break Mode Stepping Through Code Trapping Errors with the On Error Statement Understanding the Err Object Working with Inline Error Handling Writing an Error-Handling Routine Working with Forms and Controls Understanding UserForms Creating a Form Displaying and Removing a Form Aligning and Sizing Controls Using the Toolbox Working with a Form's Properties, Methods, and Events Working with Form and Control Properties, Methods and Event Setting the Tab Order Populating a Control Who is this course for? Who is this course for? This course is designed to give proficiency in the Visual Basic Editor (VBE), predominantly making use of Excel objects, understanding Object's Properties, Events and Methods, basic VBA Object oriented programming, event handling, control structures, and debugging tools. Requirements Requirements Preferably, delegates should have attended the Excel Advanced 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

AutoCAD-Mac Introduction to Advanced Training Course This project-based course is tailored for AutoCAD Mac users, architecture and interior design students and professionals. Click here for more info: Website When Can I Book This Training Course? Personalized experience with 1-on-1 sessions designed to fit your unique needs. Available from Monday to Saturday, 9 am to 7 am Or Call to Book 02077202581. Duration of Training: 16 hours. Training Method:  1-on-1, providing the option for in-person sessions or live online training. Course Content Section 1: Introduction Course Overview Section 2: Basic Concepts Status Bar and The Units Drawing Commands Control Points - Vertex or Verteces Modifying Commands Snap Settings Drawing An Outline Section 3: Dimensions and Customization Adding Dimensions and Dimension Style Manager Importing Dimension Styles Customizing Shortcuts Section 4: Advanced Techniques Adding Walls Thickness with Offset Command Adding interior layout Cleaning Layout lines with Trim Section 5: Text and Styling Text Editing and Importing Text Styles Main File Formats in AutoCAD Section 6: Design Elements Creating Openings in the Floor Plan Adding Openings - Part 2 Adding Openings - Part 3 Drawing Doors & Windows Using Line Types & Linetype Scale Group and Ungroup Commands Using Blocks Using Blocks Library & Dynamic Blocks Section 7: Layers and Furnishing Layers - Part 2 Layers - Part 3 Furnishing Bedrooms & Bathrooms - Part 1 Adding Furniture, Fixtures, and Equipments | part 2 Adding Furniture, Fixtures, and Equipments | part 3 Drawing the Kitchen Drawing the Living Room Drawing Dining Room & Adding Casework Adding Steps and Railings Using Stretch Command Finishing Steps and patio areas Hatch command Hatch Customization Adding Plants & Finishing Floor Plan Section 8: Layout and Printing Paper Space & Page Setup Manager Working with Viewport & Using Print Command Scale & Using Multiple Viewports Locking Viewport Scale Drawing A Titleblock - Part 1 Drawing A Titleblock - Part 2 Copying the Titleblock Using Titleblock with Attributes Section 9: Roof Plan and Organization Drawing The Roof Plan Placing Roof Plan on Sheet Organizing Project Drawings & Using Layer Freeze AutoCAD Crashing And What To Do Section 10: Elevations Exterior elevations - Drawing the Outline Exterior elevations - Drawing the Openings Elevations - Detailing - Part 1 Elevations - Detailing - Part 2 Elevations - Repeating the workflow Elevations - Finishing 3rd Elevation Elevations - Drawing the final elevation Section 11: Sections Sections: Drawing Cut Lines & the Outline Sections: Placing 1st Section on Sheet Sections: Drawing Section #2 - Different Technique Sections: Adding Final Detail Section 12: Interior Elevations Interior Elevations: Drawing the Outline Interior Elevations: Placing on Sheet Interior Elevations: Using Block Clip Interior Elevations: Final Drawing Section 13: Conclusion Putting the Final Set Together Proficient AutoCAD Skills: Master essential tools for efficient drawing creation and manipulation. Accurate 2D Designs: Create precise and high-quality layouts with attention to detail. Effective Object Handling: Excel in selecting, moving, copying, and scaling objects. File Management: Organize drawings efficiently and understand different file formats. Precise Measurements: Utilize inquiry commands for accurate design analysis. Annotations and Hatching: Apply text, dimensions, and hatching to enhance drawings. Object Organization: Manage layers and object properties for organized designs. Reusable Content: Efficiently use blocks, tool palettes, and groups for productivity. Layout Optimization: Create layouts with viewports for optimal design presentation. Professional Output: Generate professional plots and PDF output for polished results. Enhanced Productivity: Explore AutoCAD toolsets and web/mobile apps for streamlined workflow. Course Overview: Learn versatile AutoCAD for Mac drawing techniques, applicable across all industries, enabling you to excel in the application. Our trainers incorporate exercises from various disciplines. Who Should Attend: Ideal for newcomers to AutoCAD for Mac, self-taught users seeking correct techniques, and those transitioning from other CAD tools. Requirements: A solid Mac OS understanding is essential, while prior CAD knowledge is not required. Pre-course preparation guidance is provided for new AutoCAD users. Highlights: Perfect for AutoCAD for Mac beginners. Gain skills for precise 2D layouts and designs. Versatile drawing techniques for all industries. Choose between in-class or live online training. Autodesk Certified Tutors: AutoCAD 1-2-1 courses. Hands-on learning with expert trainers. Lifetime post-course email support. Tailored on-request training available. Certificate: Digital certificate included. Tailored Mac Training: Excel in AutoCAD with specialized Mac training, leveraging its distinct features and interface for heightened efficiency. Comprehensive Skill Enhancement: Advance from fundamental to intermediate AutoCAD Mac proficiency, creating precise and professional 2D drawings. Industry-Relevant Expertise: Attain in-demand skills valued by employers in architecture, engineering, and design sectors. Hands-On Project Exposure: Immerse yourself in practical exercises mirroring real-world design scenarios, fostering practical competence. Lesson Recordings for Review: Access recorded lessons for reinforcement and deeper AutoCAD Mac comprehension. Ongoing Email Support: Benefit from lifetime email support, ensuring assistance beyond course completion."