- Professional Development
- Medicine & Nursing
- Arts & Crafts
- Health & Wellbeing
- Personal Development
Microsoft Excel in Depth: In-House Training
By IIL Europe Ltd
Microsoft Excel® in Depth: In-House Training The goal of this course is to provide a deeper understanding of Excel and its intricacies and a new ability to use it efficiently producing the best solutions for your projects. This practical course provides a solid background of the features of Excel and a deeper understanding of its features, benefits and uses. This is not a beginner's course in Excel. You will learn some advanced features such as Pivot Tables, Charting, Tables, Sorting, Filtering and Functions. The goal of this course is to provide a deeper understanding of Excel and its intricacies and a new ability to use it efficiently producing the best solutions for your projects. What you Will Learn You'll learn how to: Use functions like IF, AVERAGE, SUMIF, SUMIFS, SUMPRODUCT, INDEX, MATCH, CHOOSE, DATE, and many more Create meaningful charts Use pivot tables Use Conditional Formatting, Data Validation Take advantage of using Named ranges, do sorting, filtering, tables Getting Started The building blocks of Excel, built-in functions, will be examined The basics of formatting your data will be examined Shortcuts and data manipulation will be explored Built-in features like those mentioned in the 'What you will learn' section above will be explored in detail Excel Functions - VLOOKUP, IF, INDEX, MATCH, CHOOSE, SUMIF, SUMIFS, SUMPRODUCT, DATE, so many more Using Named ranges, Data Validation, Sorting, and Filtering Learn the Name manager; Learn the difference between local and global names; Ensure correct access to linked workbooks; Ensure data accuracy; Learn how to use cascading data validation (for example, once a user chooses 'cars', another cell allows only Ford, Toyota, etc.); Sorting by more than 3 fields; Filtering by font, pattern, or value; See your data based on things like dates in the 3rd quarter, or fields where quantity x price is greater than some fixed value Conditional formatting and data formatting Make relevant data stand out Isolate highs and lows Make error cells invisible Learn about Data bars, Icon sets, and Color scales Highlight differences between worksheets Learn all the codes in the Format/Number list Using cell Styles Learn all about alignment, protection, borders, colors and more Pivot Tables Learn how to summarize large amounts of data with a few clicks Learn various ways of presenting the data Learn the various pivot table tools Learn how to customize and format a pivot table to suit your needs Learn how to group data Learn how to use the various options to present your data Charts Learn how to create a chart with one keystroke! Learn the 11 types of built-in charts Learn how to create a chart with one keystroke! Learn how to customize the charts to make the information tell the right story Learn how to use the design, layout, and formatting available to charts in Excel 2007 Learn embedded charts versus chart sheets Learn how to use modify all the pieces of a chart Array formulas Learn how to use the most powerful formulas in Excel Learn how to combine many formulas into one compact array-formula Learn the real power of these formulas and why regular formulas can't do the job Learn how to use built-in array formulas, like TREND or TRANSPOSE
The shortage of electricians has lead to an increased demand nationwide and in turn a sharp rise in salary. Our training solutions can help you gain nationally recognised qualifications such as City & Guilds and NVQ. Not only you will train in state-of-the-art training centres, but you can also have the opportunity to attain the Work Based Performance Units and complete a portfolio of diverse evidence of onsite work.
HG Supervisor Training
By Human Givens College
Do you have the skills and experience it takes to become a Human Givens Supervisor? Would you like to take your HG career to the next level? Course Dates: see below Length: 6 days (9.30am – 5.30pm) Venue: Leeds Tutors: Julian Penton, Rosalind Townsend Course requirements: See below Qualification: HG Supervisor / Supervisor-tutor This intensive 6 days of tuition, feedback, skills practice and ongoing assessment is your route to becoming a fully-qualified human givens supervisor. Effective supervision offers many opportunities for learning and growth, as well as providing invaluable support. Successfully completing this training will enable you to work as a supervisor-tutor with Part 3 trainees and as a supervisor with qualified HG therapists. What you will learn What HG supervision is and an understanding of the governance framework A structured approach to supporting a trainee though Part 3 How to support an experienced therapist How learning and memory works and why this matters How to use a range of supervisory approaches, methods and techniques How to assess and give feedback and how to notice if that has been received A deeper understanding of ethics, your role and your responsibilities How to address concerns about supervisees How to support a supervisee who is subject to a complaint The HG Supervisor-tutor’s Role How you will be assessed This course is designed to enhance the growth and development of your knowledge and skills, your understanding and practice and to assess your competence as a supervisor-tutor. It is therefore a combination of assessment and learning. Throughout the course, therapists practise and demonstrate through discussion, exploration and reflection, a broad range of skills and topics. Assessment will be on-going throughout the course by the two highly experienced tutors and you will also be given feedback from your peers and the experienced facilitators. Why apply Becoming a supervisor isn’t just about taking the next step; being a good supervisor also brings with it a wealth of new opportunities: Collaborative working Own learning and development Stretch and challenge – in a different way to therapy Career progression Quarterly CPD events Annual Supervisors’ CPD day Supervisors Peer Group Deadline for applications – to be advised when the next course dates are announced (provisionally Spring 2025) – how to apply. Course requirements: To apply, you must be an experienced HG therapist who has delivered a minimum of 1,000 sessions of one-to-one HG therapy and is registered with the HGI You must have the support of your supervisor/s, and Submit the information required by the application process by the deadline (this will be announced when we have the next course dates available, provisionally Spring 2025). Course Dates The HG Supervisor course is made up of two blocks of 3 days, held approx. a month apart. We typically run our supervisor training once every 18–24 months. The next course is provisionally planned for the Spring of 2025 – if you are interested in applying, please let us know via the form below. Next course: Part 1: Thursday–Saturday – dates TBC Part 2: Thursday–Saturday – dates TBC Venue: Novotel Leeds Centre Hotel, Leeds Please note: There are only 12 places available on this course, all subject to the application process. Meet your tutors Julian Penton Julian is a Human Givens (HG) practitioner who for the past 20 years has been mentoring HG therapists, teaching various HG seminars & workshops and delivering the HG College’s HG supervision training course. Read more Rosalind Townsend Ros Townsend is an experienced psychotherapist and supervisor with busy practices in SW England, where she combines private therapy work with referrals from Occupational Health and the NHS. Read more
