167 Numbers courses

Discover practical ways you can help using the core skills and concepts of human givens therapy – early intervention and ‘treating the whole person’ can be crucial… Accredited CPD: 6 hours Length: 1 day (9.30am - 4.00pm) Excellent trainer, very engaging, invaluable insights and knowledge This new course for HG therapists builds on the online Understanding Eating Difficulties introductory webinar. It will deepen your understanding of working with clients experiencing eating difficulties and give you practical guidance on the most appropriate ways to support them, whether they have an official diagnosis or not. You will leave the workshop with a much better understanding of how to apply the skills and concepts encompassed in human givens therapy in this area. Jo Baker has a wealth of experience in this area; she has previously worked as a volunteer for BEAT and other local eating disorder charities and helped people with eating difficulties in both private practice and university settings. NEXT DATE:  This course is part of our new range of recommended CPD for HG therapists. We don’t currently have another date for it, if you are interested in attending please register here so we can let you know when one becomes available. Why take this course The numbers of people experiencing eating difficulties are hitting an all time high – in the UK, 1.25 million people are estimated to have a diagnosable eating disorder¹ with hospital admissions more than doubling from 10,318 to 22,000 in the four years between 2016 and 2020². The early stages (or ‘subthreshold’ stages i.e. when symptoms do not meet full diagnostic criteria for an eating disorder as defined by the DSM-5 or the ICD-11) have been identified as a critical period for preventing progression of an eating disorder³. However, stigma directed towards those experiencing eating difficulties that aren’t believed to be ‘serious enough’ to warrant support⁴ can present a barrier to seeking help. With its deliberate use of non-clinical language Jo Baker’s new workshop for HG therapists considers all difficulties around eating worthy of help, understanding and support, irrespective of whether or not these difficulties have been diagnosed or meet the criteria for a diagnosable eating disorder. In this regard, the human givens approach takes a step forward towards early intervention, and treating the whole person. As well as having been a practising Human Givens therapist for 12 years, and teaching the HG Diploma, Jo has previously worked as a volunteer for BEAT and other local eating disorder charities and brings to the day a wealth of practical experience of working with eating difficulties both in private practice and in university settings. What will you learn The nuance of language – how to avoid causing unintentional distress The causes of most eating disorders and difficulties Creating space for the client’s story How to help your client identify and challenge destructive thought processes Therapeutic tools to get to the root of the problem – we look at which techniques can be useful, and what to be careful of The barriers created by clinical language and diagnostic criteria Diversity in eating difficulties – a greater understanding of the impact of cultural and contextual factors around eating How to help your client meet their needs and use their resources in a healthy way Eating difficulties and neurodiversity An increased awareness of complicating conditions – such as alcohol / substance abuse and medical conditions The important role of sleep in recovery Accessing resources and helping the individual to develop a nurturing self Ethical practice Understanding the boundaries of your role and your own limitations And more… Course Programme The ‘The Mind-Body Connection in depth: Movement, Emotion and Calm’ course starts at 9.30am and runs until 4.00pm. From 8.30am Registration (Tea and coffee served until 9.25am) 9.30am Eating difficulties: an overview 11.00am Discussion over tea/coffee 11.30am Understanding and resolving difficulties 1.00pm Lunch (included) 1.45pm Group discussion – questions from the day so far 3.00pm Discussion over tea/coffee 3.15pm Bringing it all together 4.00pm Day ends Who is this course suitable for? This course is for experienced, qualified HG therapists and counsellors who would like to understand more about eating difficulties, eating disorders and the different ways they can affect people. It is an invitation to recognise that all experiences of eating difficulties are equally valid and worthy of care and support. It is hoped that the learner develops further depth and breadth to their understanding and feels an increased confidence to support clients with eating difficulties however they present. The course combines trainer input, discussion and small group activities. All training is limited by time constraints and whilst we have done our utmost to include a diversity of perspectives there will inevitably be topics that have not been covered. This course is an invitation to recognise that all experiences of eating difficulties are equally valid and worthy of care and support. It is hoped that the learner develops further depth and breadth to their understanding and feels an increased confidence to support clients with eating difficulties however they present. 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.

This one-day workshop is designed to give participants an understanding of the fundamentals of Microsoft Word and its commands, with quick ways to enter text, control formatting and edit paragraphs. This course will help participants: Create, manage and save documents, files and folders Create paragraph lists, bulleted and numbered paragraphs Edit, modify and format paragraphs Create and format tables Use shortcuts to navigate documents Format the layout of documents Manage page headers and footers Insert and managing pictures and diagrams within a document Learn time saving tips and tricks to obtain a professional finish to documents Use printing options 1 Creating documents Getting help Creating and saving documents Accessing recently used documents Managing files and folders 2 Entering and editing text Inserting and editing paragraph text Cutting, copying and pasting text Using tool tips to manage content Applying and removing text formatting Correcting spelling and grammar 3 Creating paragraph lists Creating bulleted paragraphs Creating numbered paragraphs Managing bulleted and numbered lists 4 Modifying paragraphs Changing paragraph alignment Indenting a paragraph Adding borders and shading to paragraphs Formatting paragraphs using styles 5 Navigating documents Using shortcuts for navigating documents Using 'Go To' to navigate documents Finding and replacing text Changing to read view 6 Document layout Inserting page breaks Changing page orientation Adjusting page margins Adding borders to pages 7 Page headers and footers Inserting page headers and footers Using header and footer commands Inserting page numbers Using different first page 8 Inserting pictures and diagrams Inserting pictures from your computer Inserting online pictures Flowing text around a picture Changing a picture Inserting SmartArt diagrams Entering text into SmartArt 9 Inserting tables Using tabs to create tables Resizing and repositioning tables Inserting and deleting rows and columns Using a table's commands Changing a tables text direction Formatting tables 10 Printing documents Previewing and printing documents Using the printing tools Printing parts of a document

This course starts with data transformation strategies, exploring capabilities in the Power Query Editor, and data-cleansing practices. It looks at the Advanced Query Editor to view the M language code. This course focuses on advanced DAX measures that include filtering conditions, with a deep dive into time intelligence measures. Like the M query language, DAX is a rich functional language that supports variables and expression references. This course also looks at the creation of dynamic dashboards and incorporates a range of visualisations available in Power BI Desktop and online in the AppSource. The course finishes with a look at setting up end user level security in tables. 1 The query editor Split by row delimiter AddDays to determine deadlines Advanced query editor 2 Fuzzy matching joins Matching inconsistencies by percentage Matching with transformation table 3 Logical column functions Logical functions IF, AND, OR Using multiple conditions Including FIND in functions 4 Editing DAX measures Make DAX easier to read Add comments to a measure Using quick measures 5 The anatomy of CALCULATE Understanding CALCULATE context filters Adding context to CALCULATE with FILTER Using CALCULATE with a threshold 6 The ALL measure Anatomy of ALL Create an ALL measure Using ALL as a filter Use ALL for percentage 7 DAX iterators Anatomy of iterators A closer look at SUMX Using RELATED in SUMX Create a RANKX RANKX with ALL 8 Date and time functions Overview of functions Create a DATEDIFF function 9 Time intelligent measures Compare historical monthly data Create a DATEADD measure Creating cumulative totals Creating cumulative measures Visualising cumulative totals 10 Visualisations in-depth Utilising report themes Create a heatmap Comparing proportions View trends with sparklines Group numbers using bins Setting up a histogram 11 Comparing variables Visualising trendlines as KPI Forecasting with trendlines Creating a scatter plot Creating dynamic labels Customised visualisation tooltips Export reports to SharePoint 12 User level security Setting up row level security Testing user security

This course is designed for those already using Power BI Desktop and are ready to work with more comprehensive elements of analysing and reporting in Power BI. The course maintains a balanced look at data analysis including the Power Query Editor, with a deep dive into writing DAX formulas, and enhanced dashboard visualisations. The aim of this course is to provide a more complete understanding of the whole Power BI analytics process, by working with business examples that will equip you with the necessary skills to output comprehensive reports and explore Power BI's analytical capabilities in more depth. 1 The Query Editor Grouping rows in a table Split row by delimiter Add days to determine deadlines The query editor 2 Fuzzy Matching Joins Matching inconsistencies by percentage Matching with transformation table 3 The Query Editor M Functions Adding custom columns Creating an IF function Nested AND logics in an IF function 4 DAX New Columns Functions Including TRUE with SWITCH Using multiple conditions The FIND DAX function The IF DAX function Logical functions IF, AND, OR 5 Editing DAX Measures Making DAX easier to read Add comments to a measure Using quick measures 6 The Anatomy of CALCULATE Understanding CALCULATE filters Add context to CALCULATE with FILTER Using CALCULATE with a threshold 7 The ALL Measure Anatomy of ALL Create an ALL measure Using ALL as a filter Use ALL for percentages 8 DAX Iterators Anatomy of iterators A closer look at SUMX Using RELATED with SUMX Create a RANKX RANKX with ALL 9 Date and Time Functions Overview of functions Create a DATEDIFF function 10 Time Intelligent Measures Compare historical monthly data Create a DATEADD measure Creating cumulative totals Creating cumulative measures Visualising cumulative totals 11 Visualisations In-Depth Utilising report themes Applying static filters Group data using lists Group numbers using bins Creating heatmaps Comparing proportions View trends with sparklines 12 Comparing Variables Visualising trendlines as KPI Forecasting with trendlines Creating a scatter plot Creating dynamic labels Customised visualisation tooltips Export reports to SharePoint

A slab-building pottery workshop, using stoneware clay to create your own Northumberland Castle! Suitable for all ages and ideal for families.

SSRS Report Builder Course Summary. Practical SSRS Report Builder course, to leavy you full conversant with queries, DML and DDL statements. Hands-on, Practical SSRS course. PCWorkshops SSRS Course Certificate. Max 4 people per course, we keep it personalised. Where is the SSRS Report Builder Course? Online: Instructor-led. Classroom: Request per email. SSRS Course Materials SSRS Coding Examples Manuals and Notes: In-depth reference materials Exercises: Practical exercises Payment Options → £600, Follow the booking link Arrange for installments Included with SSRS Report Builder Course: SSRS Course Certificate on completion. SSRS Course Manual. Practical SSRS Course exercises. SSRS Code Samples. After the course, 1 free session for questions. Max group size, online and in classroom, on this SSRS Course is 4. Course Topics SSRS Report Builder Course Topics SSRS Course topics: This course focus on producing reports using MS SQL SSRS Report Builder, to use the product features and tools related to data retrieval, visualisations and deployment. The Target Audience: end-users who will produce reports for their department or group using datasets. SSRS Course Topics Report Models: Data source views Creating a model Entities, attributes and roles Tables: Creating tables Interactive sorting Floating headers Grouping: Inserting groups Group headers/footers Displaying group totals Expanding and collapsing Expressions: The expression builder The Report Items collection Built-in fields Conditional formatting expressions Page headers and footers Page names and numbers Exporting reports: The various report formats Using RenderFormat. Parameters: Creating parameters Filtering using parameters Drop list parameters Coping with empty tables Matrices: Row and column groups Sorting and filtering matrices Creating subtotals Charts: Creating charts The parts of a chart Formatting charts Basic reports: Text boxes and images Selecting report items Formatting parts of a report Miniature charts Creating sparklines Creating data bars Graphical indicators Creating and customising indicators Linear and radial gauges Lists: Page-per-record lists Dashboard lists Other list ideas Subreports: Creating a child report Creating the main report Linking the two reports Report parts: Publishing report parts The report part gallery Updating report parts Book the SSRS Course About us Our experienced trainers are award winners. More about us FAQ's Client Comments

SSRS Report Builder Course Summary. Practical SSRS Report Builder course, to leavy you full conversant with queries, DML and DDL statements. Hands-on, Practical SSRS course. PCWorkshops SSRS Course Certificate. Max 4 people per course, we keep it personalised. Where is the SSRS Report Builder Course? Online: Instructor-led. Classroom: Request per email. SSRS Course Materials SSRS Coding Examples Manuals and Notes: In-depth reference materials Exercises: Practical exercises Payment Options → £600, Follow the booking link Arrange for installments Included with SSRS Report Builder Course: SSRS Course Certificate on completion. SSRS Course Manual. Practical SSRS Course exercises. SSRS Code Samples. After the course, 1 free session for questions. Max group size, online and in classroom, on this SSRS Course is 4. Course Topics SSRS Report Builder Course Topics SSRS Course topics: This course focus on producing reports using MS SQL SSRS Report Builder, to use the product features and tools related to data retrieval, visualisations and deployment. The Target Audience: end-users who will produce reports for their department or group using datasets. SSRS Course Topics Report Models: Data source views Creating a model Entities, attributes and roles Tables: Creating tables Interactive sorting Floating headers Grouping: Inserting groups Group headers/footers Displaying group totals Expanding and collapsing Expressions: The expression builder The Report Items collection Built-in fields Conditional formatting expressions Page headers and footers Page names and numbers Exporting reports: The various report formats Using RenderFormat. Parameters: Creating parameters Filtering using parameters Drop list parameters Coping with empty tables Matrices: Row and column groups Sorting and filtering matrices Creating subtotals Charts: Creating charts The parts of a chart Formatting charts Basic reports: Text boxes and images Selecting report items Formatting parts of a report Miniature charts Creating sparklines Creating data bars Graphical indicators Creating and customising indicators Linear and radial gauges Lists: Page-per-record lists Dashboard lists Other list ideas Subreports: Creating a child report Creating the main report Linking the two reports Report parts: Publishing report parts The report part gallery Updating report parts Book the SSRS Course About us Our experienced trainers are award winners. More about us FAQ's Client Comments

Learn how to solder silver clay jewellery on this one day intermediate class in Edinburgh's City Centre.

Beginner-friendly macrame Christmas wreath making class in Edinburgh

3ds max on One to one Training Course pay as you go