40192 Courses in Cardiff delivered Online

Learn how to stop being a people pleaser and take care of yourself in our online event on 5th July 2024 at 9.30am to 12.30 BST. Understanding why Pleasing & Appeasing Others can be so addictive. Join us for an insightful online event where we delve into the reasons behind our tendency to constantly seek approval and validation from others. From understanding the roots of this behaviour to learning how to break free from these patterns, this session will offer valuable insights and strategies for personal growth and empowerment.

Sketchup face to face training customised and bespoke.

Learn to program with JavaScript from scratch. This hands-on practice-oriented course starts from the beginner's level and gradually moves to the intermediate level with a detailed understanding of object-oriented programming. We will also cover JSON objects and learn all versions of JavaScript from ES5, ES6, ES7, ES8, and the latest ES9 version.

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 course takes you through all the important topics of data structure and algorithms from scratch. You will learn how to solve real-world problems with linked lists, stacks, queues, sorting algorithms, and a lot more using Python.

Description: In this current world, it is imperative to have good computer skills for performing well in almost all jobs. If you are looking for brushing up your computer skills, then this Computer Operating and Maintenance Course for Experts is just right for you. With the help of this course, you can become a computer expert in no time. You will learn a lot about computing terms like input, output, operating systems, applications, storage devices, etc. You will also gain knowledge about protection data, safety, ergonomics, customization, browsing the web too. Learning Outcomes: Basic computing terms The fundamental computing skills Anatomy of a PC Input, output, and storage devices Operating systems and applications Legal issues, including licensing of software Networking and Internet basics Computers in the workplace Telecommuting and the electronic world Ergonomics, safety, and the environment Being proactive about security Protecting your data Understanding malware Using the mouse, keyboard, and desktop Customizing your computer Printing Understand and using files and folders Basic Windows applications Working with a window Working with applications Browsing the Web Assessment: At the end of the course, you will be required to sit for an online MCQ test. Your test will be assessed automatically and immediately. You will instantly know whether you have been successful or not. Before sitting for your final exam you will have the opportunity to test your proficiency with a mock exam. Certification: After completing and passing the course successfully, you will be able to obtain an Accredited Certificate of Achievement. Certificates can be obtained either in hard copy at a cost of £39 or in PDF format at a cost of £24. Who is this Course for? Computer Operating and Maintenance Course for Experts is certified by CPD Qualifications Standards and CiQ. This makes it perfect for anyone trying to learn potential professional skills. As there is no experience and qualification required for this course, it is available for all students from any academic background. Requirements Our Computer Operating and Maintenance Course for Experts is fully compatible with any kind of device. Whether you are using Windows computer, Mac, smartphones or tablets, you will get the same experience while learning. Besides that, you will be able to access the course with any kind of internet connection from anywhere at any time without any kind of limitation. Career Path After completing this course you will be able to build up accurate knowledge and skills with proper confidence to enrich yourself and brighten up your career in the relevant job market. Application Basics 00:30:00 Basic Applications 01:00:00 Working with a Window 01:00:00 Working with WordPad 01:00:00 Working With Applications 01:00:00 Basics of Web Browsers 01:00:00 Browsing the Web 00:15:00 Working with Bookmarks 01:00:00 Working With Web Pages 01:00:00 Printing Web Pages 01:00:00 Mock Exam Mock Exam- Computer Operating and Maintenance Course for Experts 00:20:00 Final Exam Final Exam- Computer Operating and Maintenance Course for Experts 00:20:00 Order Your Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Enter the all new world of Web 3.0 You most likely heard about Web 2.0. For many, Web 2.0 is characterized mainly by the ability of users to share information quickly with others, which has been developed into the phenomenon that we call social media. However that is old news. Now step in to the world of Web 3.0 and learn what you need to know about Web 3.0 through this useful course. Web 3.0 is being referred to by experts as the semantic web; semantic meaning data driven. The data will come from the user and the web will essentially adjust to meet the needs of the user. The web 3.0 is an advantageous application that enables the client to eliminate many included steps and gets the required data in the division of the time required for the more traditional style of browsing. A huge benefit of Web 3.0 is the move towards being able to access data from anywhere. This is mainly being driven by the heavy usage of smart phones and cloud applications. Through this course, you will be introduced to web 3.0. You will also go through the process of shifting from web 2.0 to 3.0. Web 3.0 isn't here just yet, but when it does come, you should know what's coming at you! This course will help you get this valuable knowledge. Course Highlights Web 3.0 Training is an award winning and the best selling course that has been given the CPD Certification & IAO accreditation. It is the most suitable course anyone looking to work in this or relevant sector. It is considered one of the perfect courses in the UK that can help students/learners to get familiar with the topic and gain necessary skills to perform well in this field. We have packed Web 3.0 Training into 7 modules for teaching you everything you need to become successful in this profession. To provide you ease of access, this course is designed for both part-time and full-time students. You can become accredited in just 3 hours, 15 minutes hours and it is also possible to study at your own pace. We have experienced tutors who will help you throughout the comprehensive syllabus of this course and answer all your queries through email. For further clarification, you will be able to recognize your qualification by checking the validity from our dedicated website. Why You Should Choose Web 3.0 Training Lifetime access to the course No hidden fees or exam charges CPD Accredited certification on successful completion Full Tutor support on weekdays (Monday - Friday) Efficient exam system, assessment and instant results Download Printable PDF certificate immediately after completion Obtain the original print copy of your certificate, dispatch the next working day for as little as £9. Improve your chance of gaining professional skills and better earning potential. Who is this Course for? Web 3.0 Training is CPD certified and IAO accredited. This makes it perfect for anyone trying to learn potential professional skills. As there is no experience and qualification required for this course, it is available for all students from any academic backgrounds. Requirements Our Web 3.0 Training is fully compatible with any kind of device. Whether you are using Windows computer, Mac, smartphones or tablets, you will get the same experience while learning. Besides that, you will be able to access the course with any kind of internet connection from anywhere at any time without any kind of limitation. Career Path You will be ready to enter the relevant job market after completing this course. You will be able to gain necessary knowledge and skills required to succeed in this sector. All our Diplomas' are CPD and IAO accredited so you will be able to stand out in the crowd by adding our qualifications to your CV and Resume. Web 3.0 Training Introduction To Web 3.0 00:30:00 How To Move From Web 2.0 to Web 3.0 00:30:00 The Characteristic Of Web 3.0 00:30:00 What Is Mechanics Of Web 3.0 00:30:00 What Is Semantic Web - The Concept Behind Web 3.0 00:30:00 What Comes After Web 3.0? 00:30:00 Wrapping Up 00:15:00

Description: Microsoft Office Visio is a vector graphics and diagramming application. Its latest iteration, Microsoft Office Visio 2016, brings a lot of updates and functionality. Microsoft Visio 2016 Beginner to Advanced Course has been designed deliberately for the ease of learning in an efficient way. This course will help you get started from the basics; you will get accustomed with the interface, tools and features, simple diagrams, floor plans, flowcharts, etc. As you move up the skillset, you will be exposed to advanced stuff: organization chart, making a floor plan, cross-functional flowchart, network diagram, shapes, stencils, templates, leveraging development tools, etc. This course will give you an overall outlook from basic to advanced level aspects of this application. Learning Outcomes: Navigation throughout Visio interface, creating basic drawing and using the help system Drawing components, modifying drawings and work with callouts and groups Organization charts creation, modifying their layouts, positioning and spacing Create and integrate organization chart copies and compare them Making a basic floor plan and custom room shapes, utilizing the program as a modelling tool and modelling room layouts Creating cross-functional flowcharts and related features like - swimlanes and separators Altering orientation and direction, changing margins and choosing styles for flowcharts Creating network diagrams, and utilizing shape data and layers Other network diagram relevant topics such as network shapes, shape data, adding layers, activating, colouring and more Working with shape, connector styles, themes, variants and containers Assessment: At the end of the course, you will be required to sit for an online MCQ test. Your test will be assessed automatically and immediately. You will instantly know whether you have been successful or not. Before sitting for your final exam you will have the opportunity to test your proficiency with a mock exam. Certification: After completing and passing the course successfully, you will be able to obtain an Accredited Certificate of Achievement. Certificates can be obtained either in hard copy at a cost of £39 or in PDF format at a cost of £24. Who is this Course for? Microsoft Visio 2016 Beginner to Advanced is certified by CPD Qualifications Standards and CiQ. This makes it perfect for anyone trying to learn potential professional skills. As there is no experience and qualification required for this course, it is available for all students from any academic background. Requirements Our Microsoft Visio 2016 Beginner to Advanced is fully compatible with any kind of device. Whether you are using Windows computer, Mac, smartphones or tablets, you will get the same experience while learning. Besides that, you will be able to access the course with any kind of internet connection from anywhere at any time without any kind of limitation. Career Path After completing this course you will be able to build up accurate knowledge and skills with proper confidence to enrich yourself and brighten up your career in the relevant job market. Module : 1 Navigate the Visio Environment 00:15:00 Create a Basic Drawing 00:30:00 Use the Help System 00:15:00 Use Drawing Components 00:30:00 Modify a Drawing 00:15:00 Work with Callouts and Groups 00:15:00 Create a Basic Organization Chart 00:30:00 Do More with Organization Charts 00:15:00 Make a Basic Floor Plan 00:30:00 Model a Room Layout 00:15:00 Create a Cross-Functional Flowchart 00:30:00 Modify a Cross-functional Flowchart 00:15:00 Create Network Diagrams 00:15:00 Use Shape Data 00:15:00 Use Layers 00:30:00 Work with Shape and Connector Styles 00:15:00 Work with Themes and Variants 00:15:00 Work with Containers 00:15:00 Module : 2 Work with Shape Styles 00:30:00 Use 3D Shapes 00:30:00 Apply Backgrounds, Borders, and Titles 00:30:00 Create Custom Stencils 00:30:00 Create Simple Custom Shapes 00:30:00 Create Master Shapes 00:30:00 Create Custom Templates 00:30:00 Generate a Pivot Diagram from an Excel Spreadsheet 00:30:00 Create a Chart from a Project File 00:30:00 Create a Timeline from a Project File 00:30:00 Connect to an Access Database 00:30:00 Create Macros 00:30:00 Modify ShapeSheets 00:30:00 Use Advanced Shape Tools 00:30:00 Save and Share Drawings with One Drive 00:30:00 Review Drawings 00:30:00 Export Drawings 00:30:00 Print Drawings 00:30:00 Mock Exam Mock Exam- Microsoft Visio 2016 Beginner to Advanced 00:30:00 Final Exam Final Exam- Microsoft Visio 2016 Beginner to Advanced 00:30:00 Order Your Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Learn to build and deploy a RESTful API using ASP.Net Core, Entity framework, and enterprise-grade practices for a scalable as well as future-proofed web API solution along with understanding the folder structure and files. You will also implement various support tools for logging, documentation, security, and error handling.

Use Cases for Business Analysis: Virtual In-House Training The use case is a method for documenting the interactions between the user of a system and the system itself. Use cases have been in the software development lexicon for over twenty years, ever since it was introduced by Ivar Jacobson in the late 1980s. They were originally intended as aids to software design in object-oriented approaches. However, the method is now used throughout the Solution Development Life Cycle from elicitation through to specifying test cases, and is even applied to software development that is not object oriented. This course identifies how business analysts can apply use cases to the processes of defining the problem domain through elicitation, analyzing the problem, defining the solution, and confirming the validity and usability of the solution. What you will Learn You'll learn how to: Apply the use case method to define the problem domain and discover the conditions that need improvement in a business process Employ use cases in the analysis of requirements and information to create a solution to the business problem Translate use cases into requirements Getting Started Introductions Course structure Course goals and objectives Foundation Concepts Overview of use case modeling What is a use case model? The 'how and why' of use cases When to perform use case modeling Where use cases fit into the solution life cycle Use cases in the problem domain Use cases in the solution domain Use case strengths and weaknesses Use case variations Use case driven development Use case lexicon Use cases Actors and roles Associations Goals Boundaries Use cases though the life cycle Use cases in the life cycle Managing requirements with use cases The life cycle is use case driven Elicitation with Use Cases Overview of the basic mechanics and vocabulary of use cases Apply methods of use case elicitation to define the problem domain, or 'as is' process Use case diagrams Why diagram? Partitioning the domain Use case diagramming guidelines How to employ use case diagrams in elicitation Guidelines for use case elicitation sessions Eliciting the problem domain Use case descriptions Use case generic description template Alternative templates Elements Pre and post conditions Main Success Scenario The conversation Alternate paths Exception paths Writing good use case descriptions Eliciting the detailed workflow with use case descriptions Additional information about use cases Analyzing Requirements with Use Cases Use case analysis on existing requirements Confirming and validating requirements with use cases Confirming and validating information with use cases Defining the actors and use cases in a set of requirements Creating the scenarios Essential (requirements) use case Use case level of detail Use Case Analysis Techniques Generalization and Specialization When to use generalization or specialization Generalization and specialization of actors Generalization and specialization of use cases Examples Associating generalizations Subtleties and guidelines Use Case Extensions The <> association The <> association Applying the extensions Incorporating extension points into use case descriptions Why use these extensions? Extensions or separate use cases Guidelines for extensions Applying use case extensions Patterns and anomalies o Redundant actors Linking hierarchies Granularity issues Non-user interface use cases Quality considerations Use case modeling errors to avoid Evaluating use case descriptions Use case quality checklist Relationship between Use Cases and Business Requirements Creating a Requirements Specification from Use Cases Flowing the conversation into requirements Mapping to functional specifications Adding non-functional requirements Relating use cases to other artifacts Wire diagrams and user interface specifications Tying use cases to test cases and scenarios Project plans and project schedules Relationship between Use Cases and Functional Specifications System use cases Reviewing business use cases Balancing use cases Use case realizations Expanding and explaining complexity Activity diagrams State Machine diagrams Sequence diagrams Activity Diagrams Applying what we know Extension points Use case chaining Identifying decision points Use Case Good Practices The documentation trail for use cases Use case re-use Use case checklist Summary What did we learn, and how can we implement this in our work environment?