• Professional Development
  • Medicine & Nursing
  • Arts & Crafts
  • Health & Wellbeing
  • Personal Development

3911 Courses in Cardiff delivered Live Online

DP-900T00 Microsoft Azure Data Fundamentals

By Nexus Human

Duration 1 Days 6 CPD hours This course is intended for The audience for this course is individuals who want to learn the fundamentals of database concepts in a cloud environment, get basic skilling in cloud data services, and build their foundational knowledge of cloud data services within Microsoft Azure. Overview Describe core data concepts Identify considerations for relational data on Azure Describe considerations for working with non-relational data on Azure Describe an analytics workload on Azure In this course, students will gain foundational knowledge of core data concepts and related Microsoft Azure data services. Students will learn about core data concepts such as relational, non-relational, big data, and analytics, and build their foundational knowledge of cloud data services within Microsoft Azure. Students will explore fundamental relational data concepts and relational database services in Azure. They will explore Azure storage for non-relational data and the fundamentals of Azure Cosmos DB. Students will learn about large-scale data warehousing, real-time analytics, and data visualization. 1 - Explore core data concepts Identify data formats Explore file storage Explore databases Explore transactional data processing Explore analytical data processing 2 - Explore data roles and services Explore job roles in the world of data Identify data services 3 - Explore fundamental relational data concepts Understand relational data Understand normalization Explore SQL Describe database objects 4 - Explore relational database services in Azure Describe Azure SQL services and capabilities Describe Azure services for open-source databases 5 - Explore Azure Storage for non-relational data Explore Azure blob storage Explore Azure DataLake Storage Gen2 Explore Azure Files Explore Azure Tables 6 - Explore fundamentals of Azure Cosmos DB Describe Azure Cosmos DB Identify Azure Cosmos DB APIs 7 - Explore fundamentals of large-scale data warehousing Describe data warehousing architecture Explore data ingestion pipelines Explore analytical data stores 8 - Explore fundamentals of real-time analytics Understand batch and stream processing Explore common elements of stream processing architecture Explore Azure Stream Analytics Explore Apache Spark on Microsoft Azure 9 - Explore fundamentals of data visualization Describe Power BI tools and workflow Describe core concepts of data modeling Describe considerations for data visualization

DP-900T00 Microsoft Azure Data Fundamentals
Delivered OnlineFlexible Dates
£595

Navigating The Modern Workforce - Diversity, Culture, Generations

By Nexus Human

Duration 2 Days 12 CPD hours This course is intended for Team leaders, managers, executives and other business professionals who lead others will benefit from this course. Overview Learn to lead in a world of diversity Engage and empower our multi-generational workforce Leverage culture as the new strategic differentiator Develop your path to leadership success In this course, students will learn how to capitalize on the strengths of your diverse team while directing and guiding them to even greater achievements. 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. A Complex World of Diversity Working in Fluid Dynamic Environments Understanding the New Transient Workforce Addressing the Need for a New Type of Leadership Leading with Authenticity Developing Required Skills and Competencies Decentralizing Power 2. Making Difference Your Strategic Advantage Engaging in the 21st Century Measuring Engagement and Taking Advantage of High Engagement Overcoming Challenges to Employee Engagement Embracing Difference and Bridging Boundaries Developing Cultural Intelligence and Responding Effectively to Cultural Differences Applying SCARF to Direct Behavior 3. Leveraging Change as the New Normal Understanding and Applying Emotional Intelligence Motivating Others Key Areas of Interest - Behavioral and Cognitive, Psychodynamic and Humanistic, and Personality Types Developing Your Leadership Psychological Toolkit Identifying Drivers - Desires and Expectations The Impact of an Environment of Trust Meeting the Needs of the Social Brain Promoting Involvement 4. Creating Leaders for the Future Facing the Challenges of a Modern Leader Avoiding Cultural Pitfalls Creating a Common Culture for All Leading Fluid Teams Seeking Diverse Perspectives Soliciting Feedback Utilizing Various Leadership Styles - Storytelling, Adaptive, and Connective Building a Sustainable Vision, Developing a Path, and Creating a Passion for Excellence Additional course details: Nexus Humans Navigating The Modern Workforce - Diversity, Culture, Generations 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 Navigating The Modern Workforce - Diversity, Culture, Generations 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.

Navigating The Modern Workforce - Diversity, Culture, Generations
Delivered OnlineFlexible Dates
£1,500

Cloud Operations on AWS

By Nexus Human

Duration 3 Days 18 CPD hours This course is intended for System administrators and operators who are operating in the AWS Cloud Informational technology workers who want to increase the system operations knowledge. Overview Identify the AWS services that support the different phases of Operational Excellence, an AWS Well-Architected Framework pillar Manage access to AWS resources using AWS accounts and organizations and AWS Identity and Access Management (IAM) Maintain an inventory of in-use AWS resources by using AWS services, such as AWS Systems Manager, AWS CloudTrail, and AWS Config Develop a resource deployment strategy using metadata tags, Amazon Machine Images (AMIs), and AWS Control Tower to deploy and maintain an AWS cloud environment Automate resource deployment by using AWS services, such as AWS CloudFormation and AWS Service Catalog Use AWS services to manage AWS resources through CloudOps lifecycle processes, such as deployments and patches Configure a highly available cloud environment that uses AWS services, such as Amazon Route 53 and Elastic Load Balancing, to route traffic for optimal latency and performance Configure AWS Auto Scaling and Amazon EC2 Auto Scaling to scale out your cloud environment based on demand Use Amazon CloudWatch and associated features, such as alarms, dashboards, and widgets, to monitor your cloud environment Manage permissions and track activity in your cloud environment by using AWS services, such as AWS CloudTrail and AWS Config Deploy your resources to an Amazon Virtual Private Cloud (Amazon VPC), establish necessary connectivity to your Amazon VPC, and protect your resources from disruptions of service State the purpose, benefits, and appropriate use cases for mountable storage in your AWS Cloud environment Explain the operational characteristics of object storage in the AWS Cloud, including Amazon Simple Storage Service (Amazon S3) and Amazon S3 Glacier Build a comprehensive cost model to help gather, optimize, and predict your cloud costs by using services such as AWS Cost Explorer and the AWS Cost & Usage Report This course teaches systems operators and anyone performing cloud operations functions how to manage and operate automatable and repeatable deployments of networks and systems on AWS. You will learn about cloud operations functions, such as installing, configuring, automating, monitoring, securing, maintaining, and troubleshooting these services, networks, and systems. The course also covers specific AWS features, tools, and best practices related to these functions. Prerequisites Successfully completed the AWS Technical Essentials course Background in either software development or systems administration Proficiency in maintaining operating systems at the command line, such as shell scripting in Linux environments or cmd/PowerShell in Windows Basic knowledge of networking protocols (TCP/IP, HTTP) 1 - Introduction to Cloud Operations on AWS What is Cloud Operations AWS Well-Architected Framework AWS Well-Architected Tool 2 - Access Management AWS Identity and Access Management (IAM) Resources, accounts, and AWS Organizations 3 - System Discovery Methods to interact with AWS services Tools for automating resource discovery Inventory with AWS Systems Manager and AWS Config Hands-On Lab: Auditing AWS Resources with AWS Systems Manager and AWS Config 4 - Deploy and Update Resources Cloud Operations in deployments Tagging strategies Deployment using Amazon Machine Images (AMIs) Deployment using AWS Control Tower 5 - Automate Resource Deployment Deployment using AWS CloudFormation Deployment using AWS Service Catalog Hands-On Lab: Infrastructure as Code 6 - Manage Resources AWS Systems Manager Hands-On Lab: Operations as Code 7 - Configure Highly Available Systems Distributing traffic with Elastic Load Balancing Amazon Route 53 8 - Automate Scaling Scaling with AWS Auto Scaling Scaling with Spot Instances Managing licenses with AWS License Manager 9 - Monitor and Maintain System Health Monitoring and maintaining healthy workloads Monitoring AWS infrastructure Monitoring applications Hands-On Lab: Monitor Applications and Infrastructure 10 - Data Security and System Auditing Maintaining a strong identity and access foundation Implementing detection mechanisms Automating incident remediation 11 - Operate Secure and Resilient Networks Building a secure Amazon Virtual Private Cloud (Amazon VPC) Networking beyond the VPC 12 - Mountable Storage Configuring Amazon Elastic Block Store (Amazon EBS) Sizing Amazon EBS volumes for performance Using Amazon EBS snapshots Using Amazon Data Lifecycle Manager to manage your AWS resources Creating backup and data recovery plans Configuring shared file system storage Hands-On Lab: Automating with AWS Backup for Archiving and Recovery 13 - Object Storage Deploying Amazon Simple Storage Service (Amazon S3) Managing storage lifecycles on Amazon S3 14 - Cost Reporting, Alerts, and Optimization Gaining AWS cost awareness Using control mechanisms for cost management Optimizing your AWS spend and usage Hands-On Lab: Capstone lab for CloudOps Additional course details: Nexus Humans Cloud Operations on AWS 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 Cloud Operations on AWS 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.

Cloud Operations on AWS
Delivered OnlineFlexible Dates
£2,025

Chairing Meetings

By Inclusive Solutions

Course Category Team Building and Leadership Visioning and Problem Solving Strategic Work Online Course now available via Teachable Platform – Chairing Meetings Learn at your own pace… lots of text and video support Description Meetings can be dreadful and bad chairing makes them worse. On this day we look at transformational person centred approaches to approaching the chairing of meetings. We provide deeper insights into the psychological processes that make this role challenging. ‘Best Saves’ for those really difficult moments when chairing meetings are creatively explored. We provide a practical, skill based and creative approach best delivered over 2 days. Testimonials “One of the most valuable things I have come across in the whole year” Learning Objectives To identify characteristics of meetings that matter- what excellent chairing looks like To strengthen person centred dimensions to chairing meetings To clarify the meetings we never want to be part of To create a visual graphic and words that uniquely illuminate what great meetings and chairing looks like To explore the various hats that group members and chairs can wear For participants to improve their chairing skills by receiving feedback To explore how to bring creativity into stuck meetings To Explore psychodynamic processes of resistance, projection, splitting and transference- as well as how to process these dynamics Who Is It For? Anyone who has to chair meetings Course Content Setting a Good tone/Exploring the ‘whole elephant’ – story so far of experience in chairing meetings – good and bad meetings – graphiced timeline and highs and lows of story so far Meetings I do not want – negative chairing…. Thinking Hats and Values – linked to role of chair – where are hats when things are going well and where are they when things are not? Our shared vision for great meetings and excellent chairing? Personal planning for future chairing – what do I need to get better at – what should I manage? Specific skill teaching – re when things go wrong – eg tears, personal attacks, talking in side conversations, silent members, lack of contribution, anger and so on…‘best saves’ explored with group – using live role play – with one chair Solution Circle demonstration – chairing skills/problem solving modelled – approach when teams stuck… Emotional elements of chairing – ‘its not personal’ – splitting, projection, transference explored and ‘handling projections’ activity Vision and Road Blocks – small groups chaired and minuted – creative problem solving – Blocks to vision of great meetings creatively removed or worked around

Chairing Meetings
Delivered in UK Wide Travel Costs or OnlineFlexible Dates
£1,800 to £2,500

KEYS TO INCLUSION: THE NEXT SET

By Inclusive Solutions

So you appreciated a Keys to Inclusion day? Wondering what next? The Next Set follows on from our lead workshop/training day and is both values driven and a practical guide to successful strategies for further developing inclusive practice in educational settings for children and young people of all ages. Course Category Inclusion Description So you appreciated a Keys to Inclusion day? Wondering what next? The Next Set follows on from our lead workshop/training day and is both values driven and a practical guide to successful strategies for further developing inclusive practice in educational settings for children and young people of all ages. On this day we explore processes and ideas ranging from the individual practitioner’s imagination through to the creating of a community gathering to strengthen inclusion of disabled and disempowered adults and children. This too is a ‘hearts and minds’ day in which you can expect participants to both laugh and cry in equal measure! The day gives those present lots of opportunities to reflect on their attitudes and practice in relation to the inclusion of pupils who are different and most challenging. Testimonials I have learned such a lot. I have learned so much. Keep an Open Mind. Really inspired! I can’t wait to share the day Learning Objectives Increased confidence regarding developing inclusive practice in mainstream schools Access to a wider range of practical strategies to impact on behaviour problems Deeper understanding of core values surrounding inclusion of disabled children Opportunity to reflect on professional attitudes and behaviour towards parents and pupils New skills and processes to make inclusion successful Who Is It For ? Early Years and School based Practitioners Heads and Deputies SENCOs Advanced Skills Teachers Primary and secondary teachers Parents Local Authority Support Services Course Content The course answers the questions : What next after a Keys day? How do we take people with us? What else can we do to go about including high profile children or young people? What does inclusion really have to do with me? Best delivered over the course of a full day, ‘Keys to Inclusion’ introduces participants to 6 guiding Ideas that underpin inclusive practice. The power of imagination Determination and persistence Growing Relationships How to help not hinder Communicating honestly and directly Creating Community Circles If you liked this course you may well like: KEYS TO INCLUSION Or: INCLUSION: IT DOESN’T JUST HAPPEN

KEYS TO INCLUSION: THE NEXT SET
Delivered in UK Wide Travel Costs or OnlineFlexible Dates
£1,800 to £2,500

SOLUTION CIRCLES

By Inclusive Solutions

A Solution Circle is a 30 minute creative Problem Solving Process for getting unstuck…Ideal for busy people! lt was designed by Marsha Forest & Jack Pearpoint. This is a short and powerful tool. It is effective in getting “unstuck” from a problem in life or work. Solution Circles are tools of “community capacity”. It assumes and demonstrates that nearby people – in any community or work place have the capacity to help – if asked. It requires a person to ASK – not an easy thing in our culture of privacy and “do it alone”. This tool puts all the values we espouse into practice and demonstrates that TOGETHER WE’RE BETTER. Course Category Problem Solving Description A Solution Circle is a 30 minute creative Problem Solving Process for getting unstuck…Ideal for busy people! lt was designed by Marsha Forest & Jack Pearpoint. This is a short and powerful tool. It is effective in getting “unstuck” from a problem in life or work. Solution Circles are tools of “community capacity”. It assumes and demonstrates that nearby people – in any community or work place have the capacity to help – if asked. It requires a person to ASK – not an easy thing in our culture of privacy and “do it alone”. This tool puts all the values we espouse into practice and demonstrates that TOGETHER WE’RE BETTER. In this training you will learn how to set up and facilitate Solution Circles  Learning Objectives For participants to learn how to facilitate a Solution Circle For participants to understand the underlying rationale and ethos of this way of working For participants to learn the power of team work and problem solving when including challenging individuals Who Is It For? Team Around the Child agencies Parents and Professional working together Families Multi Agency Teams Social workers CAMHS teams Year Managers Primary and secondary staff teams Early Years and School based Practitioners Heads and Deputies SENDCOs Advanced Skills Teachers Primary and secondary teachers Local Authority Support Services Course Content This can be introduced in a twilight, half day or even a full day workshop with individualised coaching. We will provide background context for this approach and will directly model the process with real live issues facing participants. So bring your most challenging concerns to this training. The course answers the questions: What to when you are stuck Can we find an alternative to permanent exclusion or special unit or school placement? Struggling with a child for whom praise is ineffective? Feeling isolated in your responses to a child’s needs? Worried about where your instinctive reactions are leading you? Cannot seem to get any consensus view of a young person’s behaviour/needs amongst all the family and professionals involved – is everyone pulling in different directions? We will cover: Setting the tone Background and detailed teaching of process Inclusion values underpinning this work Graphic and process facilitation skills Processes modelled and opportunities to try process out with coaching Practical setting up of insights and solutions circles Lessons learned

SOLUTION CIRCLES
Delivered in UK Wide Travel Costs or OnlineFlexible Dates
£1,800 to £2,500

WORKING WITH PARENTS AND CARERS

By Inclusive Solutions

In this practical and engaging workshop there is input on building an effective team around a child, problem solving as a team, improving communication and handling conflict. Communication with parents, problem solving and collaborating is explored. Empathy with parents who are ‘labelled’ is encouraged. Course Category Parents and Carers Description In this practical and engaging workshop there is input on building an effective team around a child, problem solving as a team, improving communication and handling conflict. Communication with parents, problem solving and collaborating is explored. Empathy with parents who are ‘labelled’ is encouraged. A key aspect of this day is ‘reframing’ how we think about the most difficult, hard to work with parents who attract many labels. Participants soon discover that they are more similar than they realise to those labelled ‘others’. The day gives those present opportunities to reflect on their attitudes and practice in relation to parents who are different. Practical ideas for joint problem solving and active engagement are fully explored. Testimonials “Made me more aware of how to approach parents and carers” “It (the conference) couldn’t have been improved. All the speakers were good” “I’ll have a more positive approach to welcoming people” “It will encourage us as practitioners to listen and think a little more. Learning Objectives Increased confidence in working with parents Access to a wider range of practical and thoughtful strategies when collaborating with parents and carers Deeper understanding of core values surrounding inclusion of disabled children in collaboration with parents and carers Opportunity to reflect on professional attitudes and behaviour towards parents with a focus on labelling and stigmatisation New skills and processes to make joint work successful Who Is It For ? Early Years and School based Practitioners Children Centre Staff Heads and Deputies SENCOs Advanced Skills Teachers Primary and secondary teachers Local Authority Support Services Social Workers Health Workers Course Content The course answers the questions: Why is this parent impossible to work with? Where do I begin to communicate with some parents? How can I collaborate with parents and carers to include high profile children or young people? Best delivered over the course of a full day we will cover: The importance of WELCOME Labelling and reframing: Setting the tone: Reframing language to describe parents Providing parents with insights about children’s behaviour using stories Circle of Courage as applied to parents Circles of Support The Intentional Building of Relationships Not doing it alone – The Importance of Teams in developing inclusive practice Problem solving: Circles of Adults/Solution Circles Community Guides If you liked this you may like: COMMUNITY CIRCLES

WORKING WITH PARENTS AND CARERS
Delivered in UK Wide Travel Costs or OnlineFlexible Dates
£1,800 to £2,500

PMI-ACP Exam Prep: In-House Training

By IIL Europe Ltd

PMI-ACP® Exam Prep: In-House Training This course builds on the candidates' practical experience of Agile in the workplace to equip them with the broad range of knowledge and skills required for the PMI® Agile Certification exam. It will follow the PMI® requirements and reference the suggested reading list, including the Agile Practice Guide, but will not be limited to those areas. Within the profession and discipline of project management, Agile continues to develop as a significant and important aspect of bringing change to an organization. Where the products of change must be delivered to the business 'on time,' Agile is often the chosen methodology. In addition to equipping candidates for the PMI® Agile Certification examination, this course will also support candidates in taking a more informed and effective role in Agile projects. It will also enable them to take a significant role in encouraging and enabling the organization to become or develop as an Agile environment. What you will Learn You will learn how to: Appreciate the wider aspects of Agile project management tools and techniques Integrate various disciplines within Agile Tailor / customize Agile to suit the needs of different projects Prepare yourself for the PMI® Agile Certification examination Getting Started Introductions Agenda Expectations Foundation Concepts Defining 'Traditional' Project Management Project management parameters The 'traditional' approach to the parameters Strengths and weaknesses of the traditional approach Defining 'Agile' Project Management Project management parameters revisited The 'agile' approach to the parameters Strengths and weaknesses of agile Managing projects with traditional and agile methods Can the two approaches co-exist? Leveraging the benefits of both methods Options for using both methods on a project Avoiding the elephant traps Key aspects of the PMI® Agile Certified Practitioner (PMI-ACP)® Handbook Overview Eligibility requirements Exam information Exam Blueprint Continuing certification requirements Key aspects of the PMI Agile Certification Examination Content Outline Introduction Agile exam content outline Tools and techniques Knowledge and skills Domains and tasks (not examined) An Introduction to Agile and Implementing Agile Definable work vs. high-uncertainty work Project factors that influence tailoring The Agile Manifesto and 12 Principles Agile mindset Agile domains and tasks Agile Tools and Techniques Related to PM 'Hard Skills' Planning, monitoring, and adapting The need for planning, monitoring, and adapting The Agile approach to planning and plans The Agile planning tools and techniques The Agile monitoring tools and techniques The Agile approach to adapting Product quality A definition of 'product quality' Setting the standard for product quality Agile tools and techniques for achieving product quality Risk management A definition of 'risk' What is 'at risk'? The acceptability of risks The Agile tools and techniques for managing risks Agile Tools and Techniques Related to PM 'Soft Skills' The difference between PM 'hard and soft' skills Communications The importance of communications Forms of agile communications Communications within the project Communications from the project Communications to the project Making communications the cultural norm Interpersonal Skills Defining and understanding management Defining and understanding leadership Defining and understanding servant leadership Delegating vs. empowering Playing to people's strengths Overcoming the roadblocks Core Agile Tools and Techniques The philosophy of core Agile tools and techniques Agile estimation Will traditional forms of estimating work for agile? The relationship between estimating and guessing The relationship between estimating and sizing The where, who, and how of agile estimating Agile analysis and design Product analysis and design from a user point of view Product analysis and design from a supplier point of view Product analysis and design from an agile project point of view Value-Based Agile Tools and Techniques The role of value-based tools and techniques in bridging traditional PM with Agile Value-based prioritization Value-based prioritization and agile projects Investment appraisal methods Regulatory driven Customer driven Ranking methods (MMF, MoSCoW) Metrics What should we measure / track? Methods of measuring / tracking Adding value with metrics Process Improvement Value-stream analysis Value-stream mapping Agile Knowledge and Skills Context of Agile Knowledge and Skills vis-à-vis Agile Tools and Techniques Agile Knowledge and Skills Process focused People focused Product focused Project focused Exam Preparation and Course Closure The application process - where are you now? The 'Exam-Focused Journal' - what you still have to do Further preparation - self-study schedule Exam topic review Practice exam Practice exam debrief Course closure

PMI-ACP Exam Prep: In-House Training
Delivered in London or UK Wide or OnlineFlexible Dates
£1,695

Microsoft Excel Intermediate - Online classroom

By Microsoft Office Training

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

Microsoft Excel Intermediate - Online classroom
Delivered OnlineFlexible Dates
£275

BOYS’ EMOTIONAL NEEDS

By Inclusive Solutions

This workshop gives an opportunity to focus on the emotional needs of boys and how to meet these. We lift the lid on an emerging urgent inclusion issue,namely meeting the emotional needs of boys. Everyone knows a boy. They may be pupil, son, brother, parent or partner. Boys when they become adults are over represented in the prison, and mental health system. Course Category Meeting emotional needs Description This workshop gives an opportunity to focus on the emotional needs of boys and how to meet these. We lift the lid on an emerging urgent inclusion issue,namely meeting the emotional needs of boys. Everyone knows a boy. They may be pupil, son, brother, parent or partner. Boys when they become adults are over represented in the prison, and mental health system. In one recent year 1300 young men committed suicide in the UK. In the UK the commonest cause of death among those aged 16-35 is suicide. Three men for every one woman kill themselves every year (Guardian, June 2006). 1 in 4 women experience domestic violence and 2 women a week are killed by a current or ex partner. Boys and men are a major concern. We need to find ways to allow them to unclench their hearts and learn to experience, process, communicate and manage their own emotional lives for their own and for the good of the wider community. Testimonials ‘Thanks for a super day, lots of good ideas for our citizens of the future. We need to offer them the best and what we would offer our own children’?? ‘Enjoyed the day very much. Brilliant ideas and lots of food for thought. Will use the solution circle. A great tool!’ ‘went well and the ethos/participation was commendably facilititated. well done’. ‘Wonderful day!’ ‘Still getting lots of positive messages this end.’ Learning Objectives Increased understanding of boys’ emotional needs Access to a wider range of practical strategies to impact on meeting emotional and behaviour problems Deeper understanding of core values surrounding inclusion of boys Opportunity to reflect on professional attitudes and behaviour towards boys and their emotional challenges New skills and processes to make boys’ inclusion and achievement more successful Who Is It For ? Early years and school based practitioners Key workers Teaching Assistants with support roles Heads and deputies SENCOs Advanced skills teachers Primary and secondary classroom teachers Parents Local authority support services Course Content The course explores the questions : Is there a problem with boys? What can we do to meet the emotional needs of boys? What helps? What should our priority be with boys? This workshop will explore: Cultural and historical expectations of boys in our society Shared experiences of teaching and parenting boys Circle of Courage as away of understanding emotional needs Fathers, mothers and sons Drinking and drugs: filling the emotional void Depression and suicide Anger and violence Solution Circle Problem Solving around boys needs What boys really need

BOYS’ EMOTIONAL NEEDS
Delivered in UK Wide Travel Costs or OnlineFlexible Dates
£1,800 to £2,500