6 Week Qi-Gong Course For Winter When: Tuesday Evenings 6pm and Thursday Mornings (via Zoom) All classes are recorded so you can catch up in your own time. Dates: Tuesdays 6-7pm: January 7th, 14th, 21st, 28th and February 4th and 11th Thursdays 9-9.30am: January 9th, 16th, 23rd, 30th and February 6th and 13th Price: Concessions £60 – Standard £80 – Supporter £110 Suitable for everyone no matter your experience What if you could improve your health, strength and vitality, by simply slowing down? Slow your body Slow your breath Slow your mind When we slow down we give ourselves the opportunity to rejuvenate, to recharge and to harness our own life force energy or “Qi”. As we move towards winter we begin to turn inwards and connect to the power of Yin, the power of Water and the power of finding our own slow flow. In this 6 week course we will explore Qigong movements, meditations and breathwork practices to support this slowing down, giving us the space to connect to our Qi, to our subtle energy, giving us the tools to feel stronger, calmer and full of vitality. In Traditional Chinese Medicine we are entering the water phase of winter. The water element relates to the organs of the bladder and kidneys, our bones, our ears and our sense of hearing. The meridians of Kidney and Bladder run along our spine and the back of the body and when they are flowing well we feel supported by life, grounded and connected to the world around us. We can find our inner flow with ease, without effort or strain, enabling us to let go of our fears and move forward with courage. Qigong teaches us to come back to our bodies, to come back home, to a place of belonging that is inside all of us, a place of stillness in our the centre. Where we can better navigate life’s uncertainties with greater balance, ease, and steadiness. What is included: Six live 60min evening Qigong Classes on zoom Six live 30min morning Slow Flow classes on zoom Access to replays of all classes so you can catch up in your own time. Access to private Whats App group to share experiences and ask questions Weekly supporting material for home practice : – A Weekly video with a guided Qigong Practice or Meditation – PDF – explanations of each practice – Key acupuncture points for self massage Together we will: Learn a simple Slow Flow Qigong Movements to balance your nervous system and release stress. Explore the principal of Wu Wei – Release tension and move with effortless action Connect to your deep internal power – Learn to Standing in Emptiness (Wuchi) Strengthen Kidneys and support adrenal health Exercises to strengthen your spine and reduce back pain Clear the meridian pathways reducing stagnation and stiffness for increased flow and vitality. Learn self-massage techniques for key acupuncture points to release stress and calm our busy minds. Qigong means “To Nourish Life” and for me having a regular practice helps to bring me home to myself. What will i get out of this course? Deeper body awareness Increased strength and emotional stability Relax your mind and Improve mental clarity Enhanced breathing and improved circulation Strengthen your back and build a healthy spine Less physical tension and reduced pain More energy Less stress and anxiety Everyone is welcome to join the course no matter your experience. Please get in touch if you have any questions.
Basic introduction to Christian Chaplaincy online.
Basic introduction to Christian Chaplaincy online.
Need a PATH? A person-centred plan? This is a planning process not a training day. Let us facilitate your planning and refocus your story whilst strengthening you and your group, team, family, staff or organisation. This tool uses both process and graphic facilitation to help any group develop a shared vision and then to make a start on working out what they will need to do together to move towards that vision. Is your team or family stuck? Want to move on, but haunted by the past and cannot get any useful dialogue started about the future? Facing a challenging transition into a new school or setting? Leaving school? Bored with annual reviews, transition plans and review meetings? Want to find a way of making meetings and planning feel more real and engaging? Need an approach, which engages a young person respectfully together with his or her family and friends? Want the ultimate visual record of the process of a meeting, which will help everyone, keep track? Want to problem solve and plan for the future of a small or large group, service or organisation up to the size of an LA Give your team the opportunity to pause and reflect on what matters most to them about the work they do. The act of listening to each other creates relationship and strengthens trust and inclusion within the team – in creating a shared vision, groups of people build a sense of commitment together. They develop images of the future we want to create together, along with the values that will be important in getting there and the goals they want to see achieved along the way. Unfortunately, many people still think vision is the top leader’s job. In schools, the vision task usually falls to the Headteacher and/or the governors or it comes in a glossy document from the local authority or the DfES. But visions based on authority are not sustainable. Using the planning tool PATH (Pearpoint, Forest and OBrien 1997) and other facilitation sources we use both process and graphic facilitation to enable the group to build their picture of what they would love to see happening within their organisation/community in the future and we encourage this to be a positive naming, not just a list of the things they want to avoid. Outcomes To create a shared vision To name shared goals To enrol others To strengthen the group To explore connections and needs To specify an Action Plan To create a visual graphic record of the whole event Process Content PATH is a creative planning tool that utilises graphic facilitation to collect information and develop positive future plans. PATH goes directly to the future and implements backwards planning to create a step by step path to a desirable future. (Inclusion Press, 2000). These tools were developed by Jack Pearpoint, Marsha Forest and John O’Brien to help marginalised people be included in society and to enable people to develop a shared vision for the future. PATH can be used with individuals and their circle of support, families teams and organisations. Both MAP and PATH are facilitated by two trained facilitators – one process facilitator who guides people through the stages and ensures that the person is at the centre and one graphic facilitator who develops a graphic record of the conversations taking place in the room. Follow the link below to read a detailed thesis by Dr Margo Bristow on the use of PATH by educational Psychologists in the UK. AN EXPLORATION OF THE USE OF PATH (A PERSON-CENTRED PLANNING TOOL) BY EDUCATIONAL PSYCHOLOGISTS WITH VULNERABLE AND CHALLENGING PUPILS The findings indicate that PATH impacted positively and pupils attributed increased confidence and motivation to achieve their goals to their PATH. Parents and young people felt they had contributed to the process as equal partners, feeling their voices were heard. Improved pupil- parent relationships and parent-school relationships were reported and the importance of having skilled facilitators was highlighted. Although participants were generally positive about the process, many felt daunted beforehand, possibly due to a lack of preparation. Pre-PATHplanning and post-PATH review were highlighted as areas requiring further consideration by PATH organisers. Recommendations to shape and improve the delivery of PATH are outlined together with future research directions.
Aspiring author? We know how frustrating it can be to have a brilliant story idea but feel stuck on where to start. The blank page can be intimidating, and finding the time and confidence to write can seem impossible. This Two-Day Creative Writing Workshop is designed specifically for beginners like you, ready to turn your novel dreams into reality! 🚀✍️
Do you want a rewarding career working directly with people, making a difference to their everyday lives? If you are warm, open and empathetic and can bring a patient, tolerant, non-judgemental attitude then a career in counselling could be for you.
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 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 classrom, 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. 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
Online group class (between 4 and 8 participants). - Duration of the course is 8 weeks, 1.5h/week, so a total of 12h. - Classes are held on Thursdays between 6.30-8pm. - All materials are included in the price of the course. - A 30-min online catch-up session is also included in the price of your course, so if you miss a class you can schedule this with your teacher to go over the content that was covered and ensure you stay on track. - The price of the full 12h course if £160, which works out as £13/h. This course is right for you if... - You have zero or very little knowledge of Spanish (yes, even if you can order a drink or two and ask for the bill!) - You can say and understand some words in Spanish but can't really string a sentence together. - You would like to learn enough Spanish to have basic conversations while on holiday and be able to go to a restaurant or visit a place without worrying that they won't speak English. - You feel that you should 'make an effort' to learn Spanish since you travel to Spain so often you could be fluent by now. Please bear in mind that this is a practical course and you will be required to spend most of the classes practicing the vocabulary and structures we learn and therefore, speaking in Spanish!
This level is the first step for any person who is interested in learning the English language. It is especially useful for students who have never had any sort of experience in studying the language or those who have a very basic knowledge and understanding of the language.
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