5424 Courses in Cardiff delivered Live Online

Duration 2 Days 12 CPD hours This course is intended for Delegates should be PC literate, i.e., familiar with PC'S/Laptops and have used a mouse and keyboard; be able to launch and close programs; navigate to information stored on the computer; manage files and folders and be comfortable using Microsoft Office applications such as MS Excel, MS Word etc. Overview The purpose of this course is to provide delegates with the practical skills to build and manage project schedules. It is designed to provide techniques and tips that will help users of the software apply it as a powerful tool to develop competent and unambiguous schedules - while avoiding some of the traps associated with the incorrect application of scheduling features. Techniques learned will also facilitate communicating deliverables and milestones to project stakeholders. This course covers management practices and methodologies and an in-depth knowledge of MS Project functionality. Delegates will be able to create and manage project schedules during the course and reinforce attained skills through practical applications. Project Management Overview Concepts of project management and scheduling The project lifecycle and phases Fundamental importance of defining ? and agreeing ? project scope Developing a Work Breakdown Structure (WBS) to define project scope 4 steps to create a schedule based on the WBS Understanding task dependencies Understanding the concept of the project baseline Developing a Project Schedule Setting the ?Scheduling Mode? Creating Tasks, Recurring Tasks (e.g. progress or review meetings) and Milestones Defining task Dependencies Applying Lag and Lead Time Working with the Critical Path Managing Tasks in the schedule Add Notes and attach project documents to tasks Setting and removing task Constraints and Deadlines Applying the ?Task Path? feature to view dependencies Working with Resources Creating a Resource Pool Working with Resource Calendars Creating Team/Group Calendars Understanding Effort Driven and Non-Effort Driven scheduling Assigning Resources to tasks Working with Project Costs Managing Project Information Applying Field, Tables and Views Applying Filters and Groups Creating custom Fields, Tables and Views (Drop-down menus, Traffic Light reports, Flag Fields) Using the ?Organiser? feature for customised elements Communicating Project Information Applying formats to Views and Tables Using the ?Copy Picture? command Create and Print Project Reports Exporting to Excel Managing Resources Finding Resource Overallocations Resolving Overallocations (reassigning, splitting tasks, utilising float, changing work contours) Applying Resource Levelling features Tracking Progress Setting the Project Baseline Applying the Tracking Gantt and Tracking Table Using the ?Mark on Track? and ?Update Tasks? features Working with Dashboards and Burndown Reports Programme Management Methods to consolidate multiple Project Files Resource sharing - setting up a Master Resource Pool Creating and managing Master Project Files

Risk Management for IT Projects: Virtual In-House Training IT projects may have direct bottom-line impact on the organization, cost millions of dollars, cause organizational change and change the way the organization is perceived by clients. Many IT projects are notoriously hard to predict and are filled with risk. IT Risk Management takes a comprehensive look at IT project risk management using PMI's PMBOK® Guide Risk Management Model in the context of IT Project Life Cycle phases. The goal of this course is to arm the practitioner with a rigorous, common-sense approach to addressing uncertainty in projects. This approach includes the ability to influence project outcomes, avoid many potential project risks, and be ready to calmly and efficiently respond to unavoidable challenges. What you will Learn You'll learn how to: Describe the risk management process, using the PMBOK® Guide's standard models and terminology Discuss the potential barriers to managing risk effectively in IT project organizations Develop an effective risk management plan for IT projects Identify project risks using IT-specific, practical tools Analyze individual risk events and overall project risk using IT-specific, practical approaches Plan effective responses to IT-specific risk based on the results of risk analysis and integrate risk responses into project schedules and cost estimates Manage and control risk throughout the IT project life cycle Implement selected elements of IT project risk management on your next project Foundation Concepts Basic concepts and purpose Risk and project constraints Risk and corporate cultures Risk management and IT PLC standards Plan Risk Management for IT Projects Plan Risk management process Plan Risk management activities Design a standard template Assess the project-specific needs Tailor the template Produce a project-specific risk management plan Gain consensus and submit as part of overall project plan A risk management plan of IT projects Identify Risks for IT Projects Identify risk process overview Risk categories and examples Risk identification tools Risk events by project life-cycle phases Perform Risk Analysis for IT Projects Perform qualitative risk analysis overview Core qualitative tools for IT projects Auxiliary qualitative tools for cost and schedule estimates When to use quantitative analysis for IT projects Plan Risk Response for IT Projects Plan risk response overview Active risk response strategies for IT projects (Threat and Opportunity) Acceptance and contingency reserves Contingency planning for IT projects Plan risk responses for IT projects Implement Risk Response for IT Projects Implement Risk Responses Executing Risk Response Plans Techniques and Tools Used Continuous Risk Management Monitor Risks for IT Projects Monitor risks overview Monitor risks tips for IT projects Technical performance measurement systems Risk management implementation for IT projects

Presentation Skills 101 is a course designed for those who want to improve their public speaking skills by learning basic skills of persuasion and developing more confidence, credibility and composure when presenting.

Business Intelligence: Virtual In-House Training Business Intelligence (BI) refers to a set of technology-based techniques, applications, and practices used to aggregate, analyze, and present business data. BI practices provide historical and current views of vast amounts of data and generate predictions for business operations. The purpose of Business Intelligence is the support of better business decision making. This course provides an overview of the technology and application of BI and how it can be used to improve corporate performance. What you will Learn You will learn how to: Specify a data warehouse schema Identify the data and visualization to be used for data mining and Business Intelligence Design a Business Intelligence user interface Getting Started Introductions Agenda Expectations Foundation Concepts The challenge of decision making What is Business Intelligence? The Business Intelligence value proposition Business Intelligence taxonomy Business Intelligence management issues Sources of Business Intelligence Data warehousing Data and information Information architecture Defining the data warehouse and its relationships Facts and dimensions Modeling, meta-modeling, and schemas Alternate architectures Building the data warehouse Extracting Transforming Loading Setting up the data and relationships Dimensions and the Fact Table Implementing many-to-many relationships in data warehouse Data marts Online Analytical Processing (OLAP) What is OLAP? OLAP and OLTP OLAP functionality Multi-dimensions Thinking in more than two dimensions What are the possibilities? OLAP architecture Cubism Tools OLAP variations - MOLAP, ROLAP, HOLAP BI using SOA Applications of Business Intelligence Applying BI through OLAP Enterprise Resource Planning and CRM Business Intelligence and financial information Business Intelligence User Interfaces and Presentations Data access Push-pull data access Types of decision support systems Designing the front end Presentation formats Dashboards Types of dashboards Common dashboard features Briefing books and scorecards Querying and Reporting Reporting emphasis Retrofitting Talking back Key Performance Indicators Report Definition and Visualization Typical reporting environment Forms of visualization Unconstrained views Data mining What is in the mine? Applications for data mining Data mining architecture Cross Industry Standard Process for Data Mining (CISP-DM) Data mining techniques Validation The Business Intelligence User Experience The business analyst role Business analysis and data analysis Five-step approach Cultural impact Identifying questions Gathering information Understand the goals The strategic Business Intelligence cycle Focus of Business Intelligence Design for the user Iterate the access Iterative solution development process Review and validation questions Basic approaches Building ad-hoc queries Building on-demand self-service reports Closed loop Business Intelligence Coming attractions - future of Business Intelligence Best practices in Business Intelligence

Training webinars in preparation for Le Jog Historic Road Rally

Aim The aim of this course is to develop the confidence and practical skills of participants to deliver great quality, timely RSE for pupils with SEND in primary education Learning outcomes By the end of the training participants will have: had an update of the DfE guidance about relationships education and health education and optional primary sex education thought about what language (spoken and visual) to use in the school to talk about private body parts and during personal care discussed how to deal with touching behaviours in the classroom identified relevant, age appropriate resources to use for RSE Course Outline Welcome and introductions and working agreement Government guidance Language and symbols Dealing with touching behaviours in the classroom Resources and how to use them Close

Constantly making up and breaking up Improve communication Self-regulation Improve understanding Address trust and respect issues Healthy relationship course Be a better partner training for both parties Emotional intelligence and relationship disciplines training 6 sessions 1-hour x 6 https://relationshipsmdd.com/product/our-relationship-is-an-emotional-rollercoaster/

Boost your productivity and banish your time bandits with our practical time management course!Reduce your stress levels, boost your productivity and banish your time bandits with our practical time management course. This course changes lives!

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.