12689 GRE courses

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

Overview This one day course will provide guidance on how to become more assertive and build self-confidence, which in-turn will help your attendees to achieve greater work effectiveness and productivity, whilst putting them in control of their daily activities and making them more able to overcome stressful work and life situations. Description Being assertive is being able to express yourself with confidence without having to resort to passive, aggressive or manipulative behaviour. By developing assertiveness and becoming aware of our own strengths and weaknesses, we can modify our behaviour for greater effectiveness in social and business interactions. Topics covered: What is Assertiveness? – A series of activities relating to what assertiveness means and, perhaps more importantly, what it means to the participants. My Assertiveness Goals – A chance for the participants to review what they want to get out of the session and where they would like to end up with regard to their approach to assertiveness. How Assertiveness Works – A look at human reactions and the reasoning behind them culminating in an activity that looks at the participants own observations in relation to assertive behaviour. My Assertive Rights – A review of the rights we have as individuals followed by a commitment to the rights by the participants. Taking a Positive Approach – Looking at key methodology, including: – Giving and Receiving Compliments A review of typical responses to compliments and their negative consequences, followed by an opportunity to develop new, positive responses. – Improving Self-Esteem An in-depth review of each individual’s positive aspects. – New Challenges A set of challenges to take participants out of their comfort-zone and into the realm of possibilities. – Effective Communication A look at what makes effective communication, with some modelling of behaviours. Approaching Assertiveness – A look at the four cornerstones of being assertive with an opportunity to practice these behaviours. The Words You Use – Understanding the key areas of effective communication. Covering the areas of; Disclosing Your Feelings, Being Clear, Being Persistent, Empathising and Working Towards a Wise Outcome. Preparing to Be Assertive – A chance to understand and practice a set process of ‘scripting’ in order to develop an effective and natural approach to assertive interactions. Assertive Review – An activity that solidifies the reasoning behind wanting to become assertive, whilst demonstrating that it is not an unachievable outcome. Who should attend Anyone that needs to develop their assertiveness skills and improve communication with others Requirements for Attendees None.

Students who complete the PV201L workshop will be able to: Perform power and energy calculations Obtain and apply specifications for PV modules and determine their performance given various environmental and operating conditions Safely operate various types of digital multimeters Diagram and determine the power, current, and voltage characteristics of PV modules in different series and parallel configurations Install various mounting systems (ground, pole, roof, and trackers). Decipher balance-of-system equipment specification sheets to determine the critical information needed for system design Install a residential grid-direct system including the array, inverter, circuit conductors, and overcurrent protection Safely operate equipment grounding, system grounding, and components and conductors used for grounding Work with wires and components on schematics of residential grid-direct systems: disconnects, inverter, equipment grounding conductors, ungrounded conductors, grounded conductors, the grounding electrode(s), and the AC and DC system grounds Identify potential safety hazards and demonstrate the proper use of personal protective equipment for working on grid-direct PV systems List the order of installation, commissioning, and decommissioning of a grid-direct PV system Note: This class is a great complement to PV301L, the Solar Electric Lab Week (Battery-Based).

Students who complete the PV201L workshop will be able to: Perform power and energy calculations Obtain and apply specifications for PV modules and determine their performance given various environmental and operating conditions Safely operate various types of digital multimeters Diagram and determine the power, current, and voltage characteristics of PV modules in different series and parallel configurations Install various mounting systems (ground, pole, roof, and trackers). Decipher balance-of-system equipment specification sheets to determine the critical information needed for system design Install a residential grid-direct system including the array, inverter, circuit conductors, and overcurrent protection Safely operate equipment grounding, system grounding, and components and conductors used for grounding Work with wires and components on schematics of residential grid-direct systems: disconnects, inverter, equipment grounding conductors, ungrounded conductors, grounded conductors, the grounding electrode(s), and the AC and DC system grounds Identify potential safety hazards and demonstrate the proper use of personal protective equipment for working on grid-direct PV systems List the order of installation, commissioning, and decommissioning of a grid-direct PV system Note: This class is a great complement to PV301L, the Solar Electric Lab Week (Battery-Based). This Women's Solar Electric Lab Week is powered by:

A payment plan is available, please contact us for more details. WSET Level 3 in Wines Award is an advanced level qualification for professionals working in the wine industry and for wine enthusiasts. If you are looking to delve deeper into the world of wines, this qualification provides a detailed understanding of grape growing and wine making. Upon completion you will be able to assess wines accurately, and use your understanding to confidently explain wine style and quality.  What the course covers Wine Tasting: Taste, describe and analyse wines using the WSET Systematic Approach to Tasting Food and Wine Matching: A guide to the key considerations when matching food and wine successfully Labelling: Learn how to decode and understand labels Wine Production: Learn about the production factors influencing the style, quality and price of wine from vineyard to bottling Light Wines: Learn about the styles of wines produced in the key wine regions and districts of the world: France, Italy, Spain, Portugal, Austria, Germany, Greece, South Africa, Australia, New Zealand, North and South America, England and Wales Sparkling Wines: Learn about the methods of production and the main styles of sparkling wines from the key wine producing countries: France, Spain, Italy, Germany, New World - Australia, California, New Zealand, South Africa Fortified Wines: Learn about the methods of production/main styles of fortified wines from the key wine countries: Spain, Portugal, France, Australia Examination: The examination is in two parts and takes place in the afternoon session of the final day of the course. The WSET Exam fee is included in the course cost. Theory paper: a combined theory paper consisting of a 50 question multiple-choice section and a four question short answer written section. 2 hours. Tasting: a blind tasting of two wines. A mark of 55% required in all sections to pass. 1 hour. The qualification has full accreditation from the UK Government’s Qualifications & Curriculum Authority as a Level 3 Vocational Qualification. To view the full course specification, including examples of exam questions, please click HERE. Recommended Private Study: 56 hours additional private study is recommended for this course. It is strongly recommended the majority of the private study is done in preparation for each session. Private study is essential to ensure that you are ready and prepared for the exam. Entry requirements: Although not essential, we do recommend you have completed the WSET Level 2 Award in Wines before enrolling on the course. The syllabus assumes that candidates already possess a good basic understanding of simple wine making techniques, key grape varieties and viticultural patterns. The fee of £825 includes All WSET course materials including; 'Accounting For Style And Quality' course manual (comprehensive 250 page textbook), Study Guide and Full SAT Tasting Card All wine tasting samples (60 to 70 wines) The use of professional ISO tasting glasses 6 days of professional WSET tuition by a WSET Certified tutor Teaching of the WSET Level 3 Systematic Approach to Tasting Wine (SAT) ® which will enable you to analyse wines objectively and consistently in preparation for the tasting exam Two fully marked mock tasting exams and weekly written exam technique sessions to ensure you are fully prepared for the exam Comprehensive student support by WSET certified educator outside of class time should you have any questions before, during and after the course Registration with WSET and all examination fees Internationally-recognised certificate and pin badge upon successful completion VAT at 20% (VAT receipt can be provided on request) Special Educational Needs Please make us aware if you have a condition that may mean you qualify for additional help during the exam such as dyslexia. Funding Funding for this course is available:  DEVELOP is the educational programme of The Drinks Trust, the drinks and hospitality industry charity. DEVELOP offers fully funded training and skills courses, delivered by industry-leading providers for people already working, or with an ambition to work, in the drinks and hospitality industry. Manchester Wine SChool has partnered with The Drinks Trust to bring courses free of charge to eligible students. All of the WSET courses are available for funding with DEVELOP. To learn more please visit the Drinks Trust website HERE Criteria of eligibility for DEVELOP funding: must be 18 or over, eligible to work in the UK, have a National Insurance Number, and be earning less than £26k/pa

QA Level 2 Award In Activity First Aid (RQF) Two-day course Especially suited to those working in sports or outdoor activities Have the skills to save lives and help injured heal faster Course Contents: The Roles and Responsibilities of an Emergency First Aider Assessing an Incident Minor Injuries Cuts, Grazes and Bruises Minor Burns and Scalds Managing an Unresponsive Casualty CPR Safe Use of an AED (Automated External Defibrillator) Choking Seizures Wounds and Bleeding Shock Eye Injuries Angina Heart Attack Stroke Asthma Diabetes Anaphylaxis Head Injuries Spinal Injuries Chest Injuries Fractures Sprains, Strains and Dislocations Poisoning Treatment for hot and cold temperatures Benefits of this course: Both Outdoor and Indoor Sports activities run a great risk of injury Would you know what to do if someone in your charge got injured or taken ill? The QA Level 2 Award in Activity First Aid (RQF) is a regulated and nationally recognised qualification designed for those who have a responsibility to provide first aid in outdoor and activity based environments As with all our courses, this course is run in a fun and engaging, interactive and hands-on way Accredited, Ofqual regulated qualification: Our Activity First Aid course leads to a nationally recognised, Ofqual regulated qualification accredited by Qualsafe Awards.This means that you can be rest assured that your Activity First Aid fulfils the legal requirements and is a very good way to make sure you and your employees are trained in First Aid, having the ability to save lives and speed healing should the situation occur.The Ofqual Register number for this course is 603/2652/9

2 Day Course - Brazilian Lymphatic Drainage, Modelling and Post Op Care - Nurture Touch Method Service Description What is the difference between Vodder and Brazilian MLD? The main difference between the two methods lies in their approach and purpose. Vodder MLD is a clinical treatment that focuses on the manual stimulation of the lymph nodes, combining slow, circular, and scoop-like motions to move the lymphatic fluid towards the larger lymphatic vessels for proper drainage and filtration. Vodder MLD is commonly used to treat conditions such as lymphedema. Brazilian MLD is primarily designed for cosmetic purposes and is performed to enhance the appearance of the skin and reduce water retention in the body. This technique emphasises vigorous hand movements and pressure on the skin, stimulating the lymphatic system to reduce the appearance of cellulite, sculpt the body, firm the skin, and promote post op healing and care. In conclusion, while both Vodder MLD and Brazilian MLD involve the stimulation of the lymphatic system, they are distinct techniques that serve different purposes. Vodder MLD is a clinical treatment that addresses medical conditions, while Brazilian MLD is a cosmetic treatment with the goal of improving the appearance of the skin and reducing water retention. If you're looking to expand your massage practice, then this course is a great way to do it.What we cover: This course will teach you how to - perform a full body Brazilian Manual Lymphatic Drainage - perform a Brazilian shaping drainage massage - adapt BMLD for Post Op to promote faster healing after cosmetic surgeries. 2 days of hands-on training to properly learn a full body sequence and how to care for following procedures: - Breast Augmentation - Brazilian Butt Lift (BBL) - Liposuction - Tummy Tuck **Prerequisite: Must hold a Level 3 Body Massage and A&P Qualification (or the equivalent). If unsure, please do email us prior to booking so that we can check your qualifications meet the required standard. This course is accredited by ThinkTree and ABT

NLP Diploma training & certification with Proactive NLP Ltd is your first step towards self-mastery. Start getting what you want from life.

ESI’s High-Performance micro-credential explores the individual salesperson and enables them to develop the mindset and attitude to succeed – all the time. This course guides learners through an examination of their professional selves, their behaviours and how to constantly learn & improve. All leading to higher personal and business performance.

3DS MAX AND AFTER EFFECTS ONE DAY face to face training customised and bespoke. Online or Face to Face