Delegates with existing Agile project delivery experience can choose to take the Certification Assessment without enrolling on the course. Get your Continuing Professional Development recognised with a UK CPD Certification Service accredited C-ASDM certificate. Frequently Asked Questions I will receive my certificate as soon as I have completed the course You will initially receive an Assessment Completion report after completing the assessment. The report details the certification status: 'Pass' or 'Fail', and also includes information on which questions were answered incorrectly. The certificate is issued by the CPD Certification Service approximately four to six weeks after completing the certification assessment. A CPD certification is recognised by employers Yes! CPD certification is recognised by private and public sector employers, and in central government departments as a valuable way to evaluate the skills of an individual. Listing your CPD certification as well as the number of CPD Points you have achieved on your CV is essentially showcasing your achievements in continuing your professional development. One CPD Point is equivalent to an hour of training CPD points are units that quantify time, and the quality of learning and development activities. Delegates will earn 3 CPD Points upon successful completion of the CPD-ASE Certification Assessment, but will 13 CPD Points after completing the two-day course. My CPD certificate will expire after three years Your certificate will not expire however, best practice suggests a renewal after three years. You can do this by enroling in the C-ASDM course to ensure your knowledge of Agile as a Delivery Method is up to date. I will receive my certificate as soon as I have completed the course You will initially receive an Assessment Completion report after completing the assessment. The report details the certification status: 'Pass' or 'Fail', and also includes information on which questions were answered incorrectly. Your certificate is issued by the CPD Certification Service approximately four to six weeks after successfully completing and passing the C-ASDM Certification Assessment. A CPD certification is recognised by employers Yes! CPD certification is recognised by private and public sector employers, and in central government departments as a valuable way to evaluate the skills of an individual, and the quality of the learning activities. Listing your CPD certification as well as the number of CPD Points you have achieved on your CV is essentially showcasing your achievements in continuing your professional development. One CPD Point is equivalent to an hour of training CPD points are units that quantify time, and the quality of learning and development activities. Delegates will earn 3 CPD Points upon successful completion of the C-ASDM Certification Assessment, but will 13 CPD Points after completing the two-day course. My CPD certificate will expire after three years Your certificate will not expire however, best practice suggests a renewal after three years. You can do this by enrolling on the C-ASDM course to ensure your knowledge as Agile as a Delivery Method is up to date. Service Features Certification Agile Scrum as a Delivery Method - Essentials (C-ASDM) On-going support Email support No Telephone support No Webchat support No Online support No Community Support Delegates who achieve the pass mark for CPD certification are additionally offered access to our private 'Certified Scrum Practitioners’ Guild', a private Slack community of like-minded Agile professionals.
Duration 1 Days 6 CPD hours This course is intended for Individuals taking this course are business professionals seeking to develop or increase their emotional intelligence. Overview Identify the components of emotional intelligence and recognize how emotional intelligence benefits organizations. Assess and develop your personal emotional intelligence competencies. Assess and develop your social emotional intelligence competencies. Practice emotional intelligence in common workplace scenarios. It was once believed that intelligence was the metric that would determine a person\'s success in the workplace. Intelligence matters because it contributes to your ability to do your job. But intelligence is not the best indicator of whether or not you\'ll succeed. Your ability to understand and manage your own emotions, and get along well with others, has at least as much impact on your performance and effectiveness as intelligence. In this course, you\'ll explore strategies to increase your awareness of your emotions, develop your ability to manage your emotions, and improve your social skills. Private classes on this topic are available. We can address your organization?s issues, time constraints, and save you money, too. Contact us to find out how. 1. Recognizing the Benefits of Emotional Intelligence Define Emotional Intelligence Recognize EQ\'s Impact on Work Experience 2. Increasing Your Personal Emotional Intelligence in the Workplace Develop Your Level of Self-Awareness Develop Your Self-Regulation Skills Develop Your Motivation 3. Increasing Your Social Emotional Intelligence in the Workplace Develop Your Empathy Develop Your Social Skills 4. Practicing Emotional Intelligence in the Workplace Practice Emotionally Intelligent Leadership Build an Emotionally Intelligent Team Manage Change Manage Conflict Coach for Performance
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
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
Course Objectives This course aims to provide delegates with a foundation for Excel knowledge and skills. ' Customer Feedback Very professional and well mannered, fun and pleasant at the same time. I learnt a lot Carolina Foster - CNN Very helpful course. Would definitely take another one. Pedro was very patient and made it fun and engaged with us all. Laura Smith - James Grant Great course and excellent trainer. Thanks Tracy Preston - Western Power Distribution 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. 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. What is Excel? The Excel Interface Ribbon, Tabs and Groups Microsoft Office Backstage view Working with Workbooks Create a blank Workbook Create a Workbook using a Template Opening and saving Files Working with worksheets Worksheet navigation Select one or multiple Worksheets Insert, Move, Copy or Delete a Worksheet Working with Cells, Rows & Columns Cell References How to select cells or ranges Different types of data Move, Copy and Delete cells Pasting Options Find and Replace Working with Rows and Columns Overview of formulas in Excel Autocalculation The parts of an Excel formula Using calculation operators in Excel formulas The difference between Absolute, Relative and Mixed references Using Excel functions; Sum, Average, Max and Min Cell Formatting Font Format options Number Format options Change the Fill and Borders Cell Alignment An Introduction to Charts Create a simple Chart Format your chart Page Layout and Print Page Layout and Page Break View Change the Page Orientation Set Page Margins Headers and Footers in a worksheet Print a worksheet or workbook Who is this course for? Who is this course for? All users who want to master the main features of Microsoft Excel Requirements Requirements General knowledge of the Windows OS Certificates Certificates Certificate of completion Digital certificate - Included
A four-hour workshop on how to retain your talented Neurodiverse colleagues and ensure equality in employment opportunities.
Duration 1 Days 6 CPD hours This course is intended for The typical students of this course will be business professionals who want to enhance their communication skills to interact more effectively with superiors, colleagues, team members, customers, and vendors, and ultimately improve their overall job performance. Overview Interact productively with others in the workplace on a day-to-day basis. Build positive relationships with diverse individuals. Consider organizational communication systems. Communicate with peers. Communicate with supervisors. Communicate with external people. Communicate during conflict and change. To be successful in the workplace, you must be able to effectively communicate and cooperate with coworkers and external people. Private classes on this topic are available. We can address your organization?s issues, time constraints, and save you money, too. Contact us to find out how. Prerequisites To ensure your success in this course, you should have some level of work experience in any of a variety of organizational settings. 1. Interacting with Others Topic A- Understand the Communication Process Topic B- Apply Core Communication Skills Topic C- Observe Nonverbal Communication 2. Building Positive Relationships Topic A- Create Connection Topic B- Adapt Appropriately to Different Communication Styles Topic C- Accommodate Diversity 3. Considering Organizational Communication Systems Topic A- Analyze Organizational Culture Topic B- Ensure Communication Flows Effectively 4. Communicating with Peers Topic A- Interact Effectively with Peers Topic B- Work Productively in a Group Topic C- Engage in Productive Meetings Topic D- Lead a Team 5. Communicating with Supervisors Topic A- Communicate with Different Supervisor Styles Topic B- Discuss Important Topics with Your Supervisor 6. Communicating with External People Topic A- Interact Effectively with Customers Topic B- Work Productively with Vendors 7. Communicating During Conflict and Change Topic A- Communicate Through Conflict Topic B- Communicate Through Change Additional course details: Nexus Humans Effective Interpersonal Communication for Business Professionals training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success. While we feel this is the best course for the Effective Interpersonal Communication for Business Professionals course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you. Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.
Anger management Dating coaching Assessment of dating patterns Emotional intelligence training Support and advice Ascertain root cause Assess history Self-improvement training Assess your needs in a partner Teach better dating skills. 1 hour per week 5 weeks Dating advice for singles https://relationshipsmdd.com/product/i-find-it-hard-to-control-my-anger-package/
Duration 1 Days 6 CPD hours Time management training most often begins with setting goals. These goals are recorded and may be broken down into a project, an action plan, or a simple task list. Activities are then rated based on urgency and importance, priorities assigned, and deadlines set. This process results in a plan with a task list or calendar of activities. Routine and recurring tasks are often given less focus to free time to work on tasks that contribute to important goals. This entire process is supported by a skill set that should include personal motivation, delegation skills, organization tools, and crisis management. 1 - Getting Started Icebreaker Housekeeping Items The Parking Lot Workshop Objectives 2 - Setting SMART Goals The Three P?s The SMART Way Prioritizing Your Goals Visualization 3 - Prioritizing Your Time The 80/20 Rule The Urgent/Important Matrix Being Assertive 4 - Planning Wisely Creating Your Productivity Journal Maximizing the Power of Your Productivity Journal The Glass Jar: Rocks, Pebbles, Sand, and Water Chunk, Block, and Tackle Ready, Fire, Aim! 5 - Tackling Procrastination Why We Procrastinate Nine Ways to Overcome Procrastination Eat That Frog! 6 - Crisis Management When the Storm Hits Creating a Plan Executing the Plan Lessons Learned 7 - Organizing Your Workspace De-Clutter Managing Workflow Dealing with E-mail Using Calendars 8 - Delegating Made Easy When to Delegate To Whom Should You Delegate? How Should You Delegate? Keeping Control The Importance of Full Acceptance 9 - Setting a Ritual What is a Ritual? Ritualizing Sleep, Meals, and Exercise Example Rituals Using Rituals to Maximize Time 10 - Meeting Management Deciding if a Meeting is Necessary Using the PAT Approach Building the Agenda Keeping Things on Track Making Sure the Meeting Was Worthwhile 11 - Alternatives to Meetings Instant Messaging and Chat Rooms Teleconferencing E-mail Lists and Online Groups Collaboration Applications 12 - Wrapping Up Words from the Wise Review of Parking Lot Lessons Learned Completion of Action Plans and Evaluations Additional course details: Nexus Humans Time Management training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success. While we feel this is the best course for the Time Management course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you. Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.
This advanced Level 3 EFT training is geared to those tapping practitioners who are looking to advance their skills to a significantly elevated level of expertise. The art of EFT delivery is emphasized, working with difficult/challenging clients and issues are explored, further refinement of techniques is honed, and additional advanced techniques are demonstrated and taught.