5519 Courses in Liverpool delivered Live Online

Course Objectives At the end of this course you will be able to: Manage project costs Consolidate and reuse project plan information Exchange project plan data with other applications Update a project plan Customise Project to meet specific requirements ' 1 year email support service Take a look at the consistent excellent feedback from our corporate clients visiting our site ms-officetraining co uk 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 Jenny Price - Acer ' 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. Exchanging Project Plan Data with Other Applications Import a list of tasks from Outlook Import a Task List from an Excel File Create a Custom Import Map Export Project Plan Cost Data into Excel Save Project Plan Information as a Web Page Updating a Project Plan Enter Task Progress Information View Task Progress Split a Task Reschedule a Task Creating Custom Fields Text fields Lookup fields Calculated fields with the use of formulas and functions Inserting Graphical Indicators Customizing how you look at data Filter Tasks in a Project Plan Create a Custom Table Create a Custom View Copy custom Views and Tables between projects Earned value analysis Understanding Earned Value Fields View Multiple Baselines in a Single Project Tracking progress between interim plans Creating Custom Reports Create a Custom Report Modify a Custom Report's Header and Footer Add a Picture to a Report Modify a Custom Report's Margins Print a Custom Report Re-using Project Plan Information Create a Project Plan Template Create a Custom Combination View Make Custom Views Available to Other Project Plans Share Resources between Projects, Create a Master Project Plan with sub projects Who is this course for? Who is this course for? This course is designed for those that who already have the skills to create and modify project plans and would like to acquire a more in depth and thorough knowledge of more advanced functionalities in project planning and tracking. Requirements Requirements Preferably, delegates would have attended the MS Project Introduction course. 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

Developing the Business Case: Virtual In-House Training Business analysts must be able to create business case documents that highlight project benefits, costs, and risks. The business case is based on the real business need to be solved. These become parts of proposals, feasibility studies, and other decision support documents. This course teaches the purpose, structure, and content of a business case. It presents the basic techniques for determining financial ROI, non-tangible benefits, and the probability of meeting expectations. What you will Learn At the end of this program, you will be able to: Perform feasibility studies Justify the business investment to solve the business problem Prepare an effective business case document Plan and implement a business case approval process Foundation Concepts The role of the BA An introduction to the BABOK® Guide The business analyst and the product / project life cycle (PLC) The business case deliverable Introducing the Business Case Process The BA and strategy analysis The BA and the business case process (BCP) The BA during the business case process (BCP) The BA after the business case process (BCP) Importance of defining solution performance metrics Defining the Business Need Overview of defining the business need Business needs: problem / opportunity statement Product vision Objectives and constraints Exploring Business Case Solutions Overview of exploring solutions Solution identification for feasibility Solution definition for analysis Assessing project risks Justifying the Business Case Overview of justifying the business case Qualitative justification Quantitative justification Approving the Business Case Overview of business case approval Developing recommendations Preparing the decision package - documents Preparing the decision package - presentations

Scrum Product Owner Workshop: In-House Training: Virtual In-House Training The Product Owner is responsible for maximizing the value of the product and the work of the Development Team. The Product Owner must be knowledgeable, available, and empowered to make decisions quickly in order for an Agile project to be successful. The Product Owner's key accountability is the Product Backlog. Managing, maintaining, and evolving the Product Backlog involves: Establishing a clear Vision that engages the Development Team and stakeholders Clearly expressing Product Backlog items Ordering the items in the Product Backlog to best achieve the Vision and goals Ensuring that the Product Backlog is visible, transparent, and clear to all Working with the Development Team throughout the project to create a product that fits the customer's needs The overall course goal is to support you in becoming an effective Product Owner. What you will Learn You'll learn how to: Differentiate between poor, good, and great Product Owner attributes, and their impact on the team, product, stakeholders, and the organization Engage your stakeholders by knowing your customers and market Develop an effective and value-driven Product Backlog Evaluate the Product Owner's role in Scrum's 5 events and team engagement Foundation Concepts Agile foundation Product owner role Product Ownership Product ownership Project vision Understanding your customers and market Personas Stakeholder management and engagement The Product Backlog Epics and user stories Preparing user stories for a sprint The product backlog Visualizing the product backlog Product backlog prioritization Technical debt Sprint Planning and Delivery Sprint planning The sprint Sprint Reviews, Retrospectives, and Closing Sprint reviews Key agile patterns Retrospectives Closing the project

Data Protection and Clinical Trials

This is an online course sat at your own pace to introduce you to clinical coaching. During the course we will go into the concept of training a student, learning methods, tutorial techniques, safeguarding and how to use the Central Skills Log (CSL). The course is open for 2 months. Once completed we can then arrange access to the CSL for one of Abbeydale’s students.

Scrum Master Workshop: In-House Training: Virtual In-House Training A Scrum Master helps project teams properly use the Scrum framework, increasing the likelihood of the project's overall success. Scrum Masters understand Scrum values, practices, and applications and provide a level of knowledge and expertise above and beyond that of typical project managers. Scrum Masters act as 'servant leaders', helping the rest of the Scrum Team work together and learn the Scrum framework. Scrum Masters also protect the team from both internal and external distractions. What you will Learn You'll learn how to: Comprehend the Agile Manifesto and mindset Explain the fundamental principles of Scrum Guide the Scrum team in their responsibilities Write requirements in the form of user stories Define Ready and Done Estimate using planning poker and prioritize using MoSCoW Facilitate the team through the 5 Sprint events Fulfill the role of Scrum Master in a Scrum project Create Information Radiators to enable transparency Define the structure of the retrospective Foundation Concepts Agile History, Values, and Mindset Introduction to Scrum Scrum events Scrum artifacts Scrum Roles and Responsibilities Product Owner responsibilities Scrum Master responsibilities The Team responsibilities Cross-functional Teams Building Effective Teams The Product Backlog and User Stories The Product Backlog User Stories Definition of Done Backlog grooming Estimating User Stories Story points, planning poker Prioritizing User Stories The Sprint Team capacity and velocity The Sprint Planning Meeting The Sprint Backlog The Sprint Learning to self-manage, self-organize, self-improve Sprint Review and Retrospective Project Progress and Completion The Daily Scrum The Task Board and The Burndown Chart Information Radiators Closing a Scrum Project Summary and Next Steps Review of course goals, objectives, and content

We're passionate about equipping churches to respond to domestic abuse. Our Domestic Abuse Awareness course will help you explore key questions around the issue of domestic abuse, like how to recognise the signs of domestic abuse, why domestic abuse happens, and how to start supporting survivors.

Duration 2 Days 12 CPD hours This course is intended for This course is designed for students who already have foundational knowledge and skills in Excel and who wish to perform robust and advanced data and statistical analysis with Microsoft Excel using PivotTables, use tools such as Power Pivot and the Data Analysis ToolPak to analyze data, and visualize data and insights using advanced visualizations in charts and dashboards in Excel. To ensure success, you should have baseline skill using Microsoft Excel worksheets, particularly in creating workbooks with formulas and function Overview #NAME? Analyzing data to find issues, insights and opportunities, is now a critical part of many job roles. Beyond the analysis, data analysts in all job roles must be able to effectively present and communicate their findings in visually compelling ways. Microsoft© Excel© is designed for this purpose. Excel can connect to a wide range of data sources, perform robust data analysis and create diverse and robust data-backed visualizations to show insights, trends, and create reports. These capabilities enable people who use Excel for data analysis to turn data into thoughtful action. 1 - DATA ANALYSIS FUNDAMENTALS Introduction to Data Science Create and Modify Tables Sort and Filter Data 2 - VISUALIZING DATA WITH EXCEL Visualize Data with Charts Modify and Format Charts Apply Best Practices in Chart Design 3 - ANALYZING DATA WITH FORMULAS AND FUNCTIONS Analyze Data with Formulas and Named Ranges Analyze Data with Functions Implement Data Validation, Forms, and Controls Create Conditional Visualizations with Lookup Functions 4 - ANALYZING DATA WITH PIVOTTABLES Create a PivotTable Analyze PivotTable Data 5 - PRESENTING VISUAL INSIGHTS WITH DASHBOARDS IN EXCEL Visualize Data with PivotCharts Filter Data Using Slicers and Timelines Create a Dashboard in Excel 6 - CREATING GEOSPATIAL VISUALIZATIONS WITH EXCEL Create Map Charts in Excel Customize Map Charts in Excel 7 - PERFORMING STATISTICAL ANALYSIS Visualize Trendlines and Sparklines with Excel Analyze Data with the Data Analysis ToolPa 8 - GETTING AND TRANSFORMING DATA Connect to Data with Queries Clean and Combine Data Shape and Transform Data 9 - MODELING AND ANALYZING DATA WITH POWER PIVOT Install Power Pivot in Excel Create Data Models with Power Pivot Create Power Pivots Perform Advanced Data Analysis and Visualization 10 - PRESENTING INSIGHTS WITH REPORTS (OPTIONAL) Plan a Report Create a Report

Course Objectives At the end of this course you will be able to: Identify the components of the Microsoft Project environment Create a new project plan Create the project schedule Use different views to analyse the project plan Create, allocate and manage resources in a project plan Finalise a project plan Track progress View and report project plan information ' 1 year email support service Customer Feedback Very good course. Learnt a lot. Looking forward to the next level. Alexandra - CIAL ' 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. Introduction to Microsoft Project Recap on project management concepts Project environment overview The 3 databases: Tasks, Resources and Assignments Different ways of displaying the Project Plan Access Help Creating a Project Plan Create a New Project Plan Project Information Create and apply the project calendar Defining recurring exceptions to the calendar Defining the calendar's work weeks Create the Summary tasks Create the Work Breakdown Structure Task creation and scheduling Exploring the Entry Table and its fields Task editing and the Task Information window Task Durations Defining Milestones Manual Scheduling vs Automatic Scheduling Changing the Task's Calendar Create a split in a Task Create Task Relationships Adding Lag or Lead to a Relationship Identifying the Critical Path Adding Constraints and Deadlines to Tasks Create Recurring Activities Adding Notes and links to Tasks Managing Resources Exploring the Entry Table and its fields Resource editing and the Resource Information window Resource Types Fixed Costs vs Variable Costs Adding Resource Costs Defining when costs accrue Changing the Resource Calendar and Availability Project calendar vs Resource and Task Calendar Assigning Resources to Tasks Effort Driven Scheduling Resolving Resource Overallocation Tracking the Project Progress Setting a Project Baseline Entering Actuals Different ways of viewing the Progress Checking if the Project is on track Viewing and Reporting Project Detail Adding Tasks to the Timeline and sharing it Modifying the Timescale and Zoom level Formatting the Gantt View Filtering and Grouping Tasks Print and Troubleshoot the Gantt View Using built-in Reports in Microsoft Project Who is this course for? Who is this course for? This course is designed for a person who has an understanding of project management concepts, who is responsible for creating and modifying project plans, and who needs a tool to manage these project plans. Requirements Requirements General knowledge of the Windows OS 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 Certificates Certificates Certificate of completion Digital certificate - Included

This 1 day course is designed for the end user who is using or will use Office 365. This course will provide delegates with the knowledge and skills to efficiently use Office 365 on a day-to-day basis. The course is designed with real world scenarios in mind. Delegates will learn how to use Outlook Online, Skype for Business, OneDrive for Business, SharePoint Online, and OneNote. At the end of this course delegates will be able to effectively navigate Office 365 and make use of all of the features of Office 365 Office 365 Overview Introducing Cloud Computing Identify and Outline the Component Products in Office 365 including Outlook Web App, Office Online Apps, OneDrive and Skype for Business Navigating around Office 365 Customising the Office 365 Nav Bar Updating your Profile in Office 365 Using the Outlook Online Application Overview of Outlook Online Working with Email and Folders Outlook People and IM Contacts Using the Calendar Shared Calendars Outlook Tasks in the Web App Setting Outlook Options, Signatures, Automatic Replies and Rules Using Skype for Business Overview of Skype for Business Viewing and Setting Presence Status Using Instant Messages in Business Understanding the Interactive Contact Card in Microsoft Office Applications Integration with Outlook Using Skype for Business for Online Presentations including Content Sharing, Polls and a Virtual Whiteboard Working with OneDrive for Business What is OneDrive for Business? Navigating around OneDrive Accessing Content in OneDrive Using the Office Online Apps Sharing Documents and Collaborating Connecting Microsoft Office to OneDrive Creating Office Documents and Saving Directly to OneDrive Using Groups and Delve Introduction to Groups Collaborating using Groups Getting to Content using Delve Requirements Requirements Before attending this course, students must have: Basic understanding of Microsoft Office Basic understanding of Microsoft Windows Operating systems