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
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 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. 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. 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
This half day or whole day course is designed for those who are new to either working in or with the voluntary and community sector, including staff, councillors and committee members working in statutory agencies. It will help you understand how the sector works, the various legal forms of organisations, issues of governance and sustainability so that you are able to work more effectively in partnership with the sector and understand its funding needs. The half day course covers the basic information; the longer course can include further subjects such as the use of volunteers and typical issues that face trustee boards and management committees.
The psychological insights and skills you need Knowing how to resolve conflict constructively is an essential life skill – improving personal and professional relationships, mental health, productivity and more… Accredited CPD Certificate : 6 hours Length 1 day (9.30am - 4.00pm) > Counts towards the Diploma – from 2024, this course will be a requirement of Part 1 of the HG Diploma. A fantastic approach that helps you unpack the issues, respond positively and find an effective solution that moves everyone forward... This course will: deepen your understanding of why conflicts develop and escalate, the psychological factors involved and the cultural and contextual influences on our perceptions, experience and responses to conflict build your confidence and comfort around being in situations that involve conflict give you a range of skills and techniques that you can use with both individuals and groups, in therapy or the workplace – or with your friends and family – to resolve conflict constructively It will also enable you to: help clients recognise conflict and understand their own responses to it help clients develop the skills to engage with conflict productively, so they are more likely to reach positive outcomes provide clients with a framework and structure for addressing conflict in a healthy way help clients become less fearful of conflict, so they don’t avoid it in ways that are unhelpful and to recognise the role of conflict in healthy relationships provide psychoeducation, explaining how barriers to needs can cause conflict and how this can be different in different cultural contexts The course is interactive and experiential, with a focus on developing practical and transferable conflict resolution skills. It combines trainer input, discussion, small group activities and role-play to build your confidence when helping to resolve conflict at all levels, whether one-to-one or in organisations. Why take this course Conflict isn’t always destructive. Properly handled it can be creative and productive, leading to better outcomes and possibilities for all. Although conflict is a normal, ever-present possibility in our lives – between family, friends, colleagues, neighbours, and in our interactions with organisations – when it becomes entrenched it can cause immense individual distress, and waste time and money. Addressing interpersonal conflict using the psychological insights, concepts and proven techniques you will learn on the day, helps us to solve problems creatively and improve the health and wellbeing of those involved. To lead a healthy life we don’t need to avoid all conflict, but we do need to know how to approach it in ways which can help everyone involved meet their emotional needs, a win/win for all. Learning the human givens approach to conflict resolution helps to reduce the potential damaging consequences of destructive conflict and embrace the benefits of constructive conflict. Throughout the day, Rupinder will draw on her own considerable practical experience of successful conflict resolution and mediation in a wide range of settings as she provides expert guidance and training in the psychological insights and skills you need to be able to constructively resolve conflict between individuals and/or groups. Addressing conflict in the right way helps us solve problems and improves the health and wellbeing of everyone involved... What the course covers The common causes of interpersonal conflict The negative impacts and potential benefits in conflict situations How to consider intentions and outcomes when engaging in conflict The different methods used to influence the outcome of conflict, and how the method influences the outcome What a resolution really is The cultural and contextual influences on perceptions, experience, and responses to conflict The role our innate needs and resources play in conflict situations Identifying our influence on the process of conflict Effective skills to engage people who are in conflict A practical, sequenced model for effective mediation and conflict resolution An effective framework for facilitating constructive conversations How to structure a session/s to: facilitate resolution, increase engagement, understanding and define the needs of all parties Effective skills to facilitate negotiations Techniques and diffusing strategies to reduce potential barriers How to access resources to build agreements that last The effective skills needed to facilitate negotiations How to implement opportunities in organisations to address conflict effectively Ways to develop your leadership ability to respond to conflict and/or support others who are enduring it How to use this to support the process of resolution by improving how individuals relate to one another and addressing the contentious issues constructively And much more… Course Programme The ‘Conflict Resolution’ course starts at 9.30am and runs until 4.00pm. From 8.30am Registration (Tea and coffee served until 9.25am) 9.30am Approaches to conflict 11.00am Discussion over tea/coffee 11.30am Understanding Causes and Impact 1.00pm Lunch (included) 1.45pm Increasing engagement 3.00pm Discussion over tea/coffee 3.15pm Reaching Resolution 4.00pm Day ends Who is this course suitable for? This course is for anyone wishing to understand more about the different ways conflict can affect us, or to feel more confident in a facilitation or leadership role when helping conflicted people It is also very relevant to anyone working in a supportive role – such as counsellors, psychotherapists, managers, HR staff, life coaches, Mindset Coaches, social workers etc. – as well as employees, customer service personnel and anyone working in schools and education. This course has been independently accredited by the internationally recognised CPD Standards Office for 6 hours of CPD training. On completion of this training you’ll receive CPD certificates from the College and the CPD Standards Office.
The fundamental tool to identify waste, create effective process flow, reduce process cycle times, and implement process improvement.
– the practical skills you need High levels of anxiety can be very debilitating – this workshop gives you important insights and a wide range of proven techniques to help reduce long-term anxiety, panic attacks, GAD and much more… Accredited CPD Certificate : 6 hours Length 1 day (9.30am - 4.00pm) Jo is incredibly adept at teaching this important subject, backed up with evidence and so many useful techniques. Thank youCATHERINE, FAMILY SUPPORT WORKER What will you learn Tried and tested psychological techniques for dealing with over-anxiety Why it’s important to distinguish between two fundamental kinds of anxiety – and methods for dealing with both How to recognise panic attacks and deal with them effectively The genetic factors that make some people more vulnerable to anxiety Ways to change a poor sleep pattern caused by anxiety New perspectives on what drives anxiety – including when its basis lies in trauma Why some people may dissociate (appear to ‘tune out’ or not be present) when very stressed, and what to do about it The three different components of anxiety – and why anxiety can get out of control How anxiety affects the body – and how the body affects anxiety Why people become hypervigilant – and how this can be reduced How to separate a person from their anxiety Five effective methods for bringing down physiological arousal very quickly – and safely Why social anxiety occurs and how to handle it Tips for reducing anxiety in those with additional conditions, such as autistic spectrum disorder, ADHD, bipolar and borderline personality disorder What happens in the brain when we become anxious – insights from neuroscience How guided imagery speeds up treatment for high anxiety plus special tips for using it with clients suffering from over-anxiety How stories can complement therapy for anxiety A range of new skills and techniques for reducing severe anxiety, with plenty of opportunity to practise them yourself on the day Very useful - lots of practical new anxiety management techniquesCOUNSELLOR Why take this course More and more people’s lives are being blighted by anxiety, causing distress to all involved. The anxiety may have initially been focused on realistic, understandable concerns – such as financial difficulties, health, job insecurity or unemployment, relationship problems (particularly complex in blended families) or fears about the future in an increasingly uncertain world – but has spiralled out of control. Or it may have no clear cause and manifests as an ever-present feeling of being ‘wired’, tense or vulnerable, very often accompanied by out-of-control thoughts. The person may be hypervigilant, unable to relax and highly miserable. Left unaddressed, chronic anxiety can also badly affect sleep and physical, as well as mental, health. The good news is there’s much that we can do to reduce this suffering. This highly practical course focuses on giving you the key information and practical skills you need to lower anxiety levels and help people manage their own anxiety better. It concentrates on generalised anxiety (including generalised anxiety disorder – GAD), social anxiety and panic attacks, but also addresses how to handle anxiety that is a feature of conditions such as autistic spectrum disorder, ADHD and bipolar and borderline personality disorder. Good to know This day complements the Online Course: ‘Understanding anxiety – and managing it without drugs’ Trauma, phobias and obsessive compulsive disorders are dealt with on separate practical skills training days (see “The Rewind Technique – Effective treatment for trauma (PTSD) and phobias” and “Obsessive compulsive disorder – understanding OCD and how best to treat it.”) Course Programme The ‘How to Control Chronic Anxiety’ course starts at 9.30am and runs until 4.00pm. From 8.30am Registration (Tea and coffee served until 9.25am) 9.30am Understanding the causes, indications and impacts of chronic anxiety 11.00am Discussion over tea/coffee 11.30am Approaches to help overcome difficulties with anxiety 1.00pm Lunch (included) 1.45pm Anxiety and associated conditions 3.00pm Discussion over tea/coffee 3.15pm Using guided imagery and mental rehearsal 4.00pm Day ends Who is this course suitable for? Anyone who works with or treats people who may be highly anxious – such as psychotherapists, counsellors, health and social care professionals, educators and individuals working in a variety of capacities in any number of organisations. The course will also provide valuable understanding and practical help for anyone struggling to deal with their own chronic anxiety or for those in relationships or families affected by chronic anxiety.* The day offers the chance to gain life skills of benefit to everyone. * Please Note: This course is not a substitute for individual therapy but there are lots of techniques that anyone suffering from anxiety can take away and use themselves. This course has been independently accredited by the internationally recognised CPD Standards Office for 6 hours of CPD training. On completion of this training you’ll receive CPD certificates from the College and the CPD Standards Office.
Course Objectives At the end of this course you will be able to: Collaborate on documents Add reference marks and notes Make long documents easier to use Secure a document Work with forms '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. Tailored in company 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. Collaborating on Documents Modify User Information Share a Document Compare Document Changes Review a Document Merge Document Changes Review Tracked Changes Coauthor Documents Adding Reference Marks and Notes Add Captions Add Cross-References Add Bookmarks Add Hyperlinks Insert Footnotes and Endnotes Add Citations and a Bibliography Simplifying and Managing Long Documents Insert Blank and Cover Pages Insert an Index Insert a Table of Contents Insert an Ancillary Table Manage Outlines Create a Master Document Securing a Document Suppress Information Set Formatting and Editing Restrictions Add a Digital Signature to a Document Restrict Document Access Forms Create Forms Manipulate Forms Who is this course for? Who is this course for? This course is designed for users who would like to create and work with lengthy and well structured documents, collaborate with others on documents, and create forms in Microsoft Word Requirements Requirements Preferably, delegates should have attended the Word 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
Course Objectives At the end of this course you will be able to: Customise tables and charts Customise formatting with styles and themes Modify pictures in a document Create customised graphic elements Insert content using Quick Parts Control text flow Use templates to automate document creation Perform mail merges Use macros to automate common tasks '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 Excelent enviroment for training. Tahnk you. 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. Tailored in company 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. Working with Tables and Charts Sort Table Data Control Cell Layout Perform Calculations in a Table Create a Chart Customising Formats Using Styles and Themes Create and Modify Text Styles Create Custom List or Table Styles Apply Document Themes Using Images in a Document Resize an Image Adjust Image Appearance Integrate Pictures and Text Insert and Format Screenshots Use the Snipping tool Creating Custom Graphic Elements Create Text Boxes and Pull Quotes Draw Shapes Add WordArt and Other Text Effects Create Complex Illustrations with SmartArt Inserting Content Using Quick Parts Insert Building Blocks Create and Modify Building Blocks Insert Fields Using Quick Parts Controlling Text Flow Control Paragraph Flow Insert Section Breaks Insert Columns Link Text Boxes to Control Text Flow Using Templates Create a Document Using a Template Create a Template Using Mail Merge The Mail Merge Features Merge Envelopes and Labels Create a Data Source Using Word Using Macros Automate Tasks Using Macros Create a Macro Who is this course for? Who is this course for? This course is designed for users who to create or modify complex business documents as well as customised Word efficiency tools Requirements Requirements Preferably, delegates should have attended the Word 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
Course Objectives At the end of this course you will be able to: Modify the PowerPoint environment Using Master View in order to customise a design template Add and customize SmartArt graphics Add animations and change its effect options Add action buttons to control the flow of the presentation Use various options to customise slide shows Use different PowerPoint file types to distribute presentations ' 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 Very clearly explained Good pace. Lucy Tailor - 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. Tailored in company 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. Customising the PowerPoint Environment Customise the User Interface Set PowerPoint Options Customising Design Templates Modify Slide Masters and Slide Layouts Add Headers and Footers Modify the Notes Master and the Handout Master Adding SmartArt to a Presentation Create SmartArt Modify SmartArt Working with Media Add Audio to a Presentation Add Video to a Presentation Working with Animations Entrance, Emphasis and Exit Animations Animate Charts by Category and Series Customise Animations and Transitions Collaborating on a Presentation Review a Presentation Store and Share Presentations on the Web Customising a Slide Show Annotate a Presentation Set Up a Slide Show Create a Custom Slide Show Add Hyperlinks Add Action Buttons Record a Presentation Securing and Distributing a Presentation Secure a Presentation Create a Video or a CD Distribute the Presentation in different File Formats Who is this course for? Who is this course for? This course is designed for delegates who want to gain the skills necessary to work with design templates, various types of diagrams, special effects, custom slide shows, collaboration functionality, and advanced presentation delivery. Requirements Requirements Preferably, delegates should have attended the Powerpoint 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
Course Objectives At the end of this course you will be able to: Identify and work with basic Word 2013 tools and features Edit text in a Word document Modify the appearance of text in a Word document Organise data in tables and lists Insert special characters and graphical objects Control the appearance of pages in a Word document Proof a document Customise the Word environment '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 Good pace, questions encoraged, trainer ensured everyone was kept at same level. 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. Tailored in company 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. Getting Started with Word Identify the Components of the Word Interface Create a Word Document Help Editing a Document Navigate and Select Text Modify Text Find and Replace Text Formatting Text and Paragraphs Apply Character Formatting Align Text Using Tabs Display Text as List Items Control Paragraph Layout Apply Borders and Shading Apply Styles Manage Formatting Adding Tables Insert a Table Modify a Table Format a Table Convert Text to a Table Managing Lists Sort a List Renumber a List Customise a List Inserting Graphic Objects Insert Symbols and Special Characters Add Images to a Document Page Setup Apply a Page Border and Color Add a Watermark Add Headers and Footers Control Page Layout Proofing a Document Check Spelling and Grammar Other Proofing Tools Check Accessibility Customising the Word Environment Customise the Word Interface Additional Save Options Who is this course for? Who is this course for? This course is intended for delegates who want to learn the fundamentals skills of working with Microsoft Word 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