589 GRE courses in London

Learn the classic Wet Shaving in our Advanced Wet Shaving Course. Ideal for qualified barbers looking to learn a new skill and add to their services. In this 2-day course, you’ll learn shaving theory along with skin tensioning and lathering techniques.

Microsoft Excel® in Depth 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

EA/PA Excellence Workshop Live from London on the 25th of April 2024. Featuring Keynote speaker Reggie Love, former Special Assistant to 44th President of the USA, Barrack Obama. Panel featuring Sophie Chapman, assistant to Steven Bartlett entrepreneur, author, host of the diary of a CEO and youngest ever dragon on BBC's Dragon's Den, Victoria Wratten, CEO of the Executive & Personal Assistants Association. The workshop contains, panel talk, keynote talk and facilitation over key topics from Kate Wood over the course of the day.

Soundscape Facilitator Training

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

Project Communication Skills: In-House Training Communication is the single most critical project success factor. When effective, projects get executed on time, within budget, and with objectives being met. But that isn't all. Strong communication also nurtures healthy team relationships. And in today's highly diverse world, where projects are often fast-paced, complex, and virtual, that is more important than ever. Strong communication skills foster cultural awareness, trust, and empathy. Together, they contribute greatly to project success-and ultimately, to future project success. In this course, participants will actively explore best communication practices from a variety of perspectives: in-person, virtual, electronic, and via formal project documentation. In order to be transformative, however, those perspectives will be filtered further through the lens of their formal, personalized assessment. It is a powerful tool which identifies individuals' internal needs and priorities. It translates those into descriptive profiles and reports, gifting users with valuable information about themselves and others. Paired with the course's real-world activities, it will provide uniquely strategic opportunities for communicating effectively and meaningfully-and with less conflict, both personally and professionally. What You Will Learn At the end of this program, you will be able to: Identify basic elements of communication and explain how they affect teams Explore how your assessment style impacts you and how you communicate with people of other styles Infer how your style impacts the way(s) you send and interpret emails and instant messages Analyze real world email and instant messaging practices to determine how they affect communication and relationships Explore best practices for formal project communications and presentations Analyze how your assessment style and global diversity can contribute to both strong team communication and conflict Identify solutions for virtual team work communication challenges Getting Started Foundation Concepts Communication as a foundation skill Elements of communication Communicating across media Targeting your audience How communication impacts team performance The Assessment Framework Overview of the assessment's approach Exploring assessment report Increasing your effectiveness with other assessment styles Email and Instant Messages Preferred communications and assessment styles The email brands we create Assessment styles and email Emotion and email Email guidelines and best practices Anatomy of an email The seven deadly email sins Instant messages and other interfaces Project Communications and Presentations Communicating across the project lifecycle Project templates Structuring a presentation Delivering a presentation Interpersonal and Team Communication Skills Communication styles and techniques Managing conflict in a project environment Styles and conflict Communication and global team leadership Virtual Communication Leading global virtual teams Virtual processes and technology Virtual team leadership

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

This course meets the standards to become a mental health first aider. If you wish to become a mental health first aider, this is a great way to understand what it takes, get some practice in and how to really help someone in mental health crisis.

Elevate your expertise in clean hydrogen derivatives - ammonia, methanol, and synthetic hydrocarbon with EnergyEdge's course. Enroll now for virtual instructor-led training!

With A-List Acting Coach Mel Churcher Introduction Work directly with World Renowned Acting, Voice and Dialect Coach, Mel Churcher on this highly practical 4 day training course. With over 35 years’ experience and an extensive credits list, Mel has worked with some of the biggest names in Showbusiness, training actors and working closely with Directors on a range of International Film and TV projects. Meet Your Tutor Mel Churcher A-Lister Coach Mel Churcher is one of the Worlds top Acting and Dialogue Coaches in Film and TV. Mel has coached actors such as Daisy Edgar-Jones (War of the Worlds), Michelle Yeoh (The Lady), Daniel Craig & Angelina Jolie (Lara Croft: Tomb Raider), Jet Li (Unleashed), Keira Knightley (The Hole, King Arthur), Henry Cavill (The Count of Monte Cristo), Sam Riley (Control). She has worked in the Voice Department of the Royal Shakespeare Company, Regent’s Park Open Air Theatre (where she was Head of Voice and Text for twelve years), Shakespeare’s Globe, The Young Vic, Manchester Royal Exchange, Birmingham Repertory Theatre and the Royal Court Theatre in London. Mel has published several globally successful books on screen acting. Mel's Work Course Outline Mel takes a holistic approach over 4 full days of in-person process, taking students through the step by step process of creating, developing and delivering assured on screen performances using a physical approach to fuse the actor and the role. This allows you to find freedom and life in your screen performance, put to the test as you film throughout the course. Day 1 Mel will look at you, your unique life, your shining eyes on screen and see how you can use your energy within the specifics of the role – so that your work is alive and truthful. You’ll look at the differences between our essential selves and learnt text. (Everyone will have a solo session on-screen with Mel.) Day 2 Filming will continue alongside tips and games on camera. You will work extensively on scenes. Day 3 You’ll look at rehearsal techniques and strategies to build a life for screen including breathing work, improvisation, psychological gestures, physical metaphor and Mel’s Elemental metaphors. Day 4 You will complete the scene work and summarise your new skills under Mel’s guidance then with a chance to ask Mel any personal questions about your skills and career.  Additional Information Features Work closely with A-List Acting Coach Mel Churcher Film scenes for future development Designed to enhance your screen acting skills Suitable if you are (17 yrs+) with some previous acting training or a professional actor Attracts a varied age range from 17 yrs+. International Students Welcome The course is taught in English, so it is important that you have proficient English language skills Small Class Size Learning Outcomes Build convincing characters Develop a holistic approach you can bring to set Learn to bring truth and life to every take Course Location Old Diorama Arts Centre, Regent’s Place, 201 Drummond St, London NW1 3FE Nearest Tube Stations: Warren Street (5 mins): Northern & Victoria lines Euston Square (5 mins): Circle, Hammersmith & Metropolitan lines Great Portland Street (5 mins): Circle, Hammersmith & Metropolitan lines Euston inc National Rail (10 mins): Northern & Victoria line.