863 Courses in London

This one-day workshop is designed to give you an awareness of the fundamentals of Microsoft Excel and, in particular, to give you the confidence needed to efficiently create, edit and manage spreadsheets. This course will help participants: Create tables Use functions Manage rows and columns Write formulas Manage sheets Use content formats Handle larger tables Create reports and charts 1 Creating a table Creating an Excel table from scratch Wrapping text in cells Speeding up data entry using AutoFill Sorting columns 2 Inserting function Inserting function calculators Using AutoSum to sum numbers Statistical calculations AVERAGE, MAX and MIN 3 Table rows and columns Inserting and deleting rows and columns Adjusting multiple column widths and row heights Hiding and unhiding rows and columns 4 Formula writing The basics of formula writing Understanding mathematical symbols Using multiple mathematical symbols in a formula When to use brackets Troubleshooting calculation errors 5 Managing sheets Inserting, renaming, moving and deleting sheets Copying a worksheet to another file Copying a table to another sheet 6 Managing content formats Applying data formats Managing number formats Controlling formats with the Format Painter 7 Managing larger tables Applying freeze panes to lock tables when scrolling Sorting on multiple columns Using filters to extract table information 8 Creating and modifying charts Creating a pie chart Creating a column chart Inserting chart titles and data labels Controlling chart formatting Changing chart types 9 Printing Previewing and printing tables and charts Modifying page orientation Adjusting print margins Printing a selection 10 Calculating with absolute reference The difference between a relative and absolute formula Changing a relative formula to an absolute Using $ signs to lock cells when copying formulas 11 Pivot tables Create a pivot table report Insert a pivot chart into a report

This course is designed for students who already have foundational knowledge and skills in Excel and who wish to perform robust and advanced data and statistical analysis with Microsoft Excel using PivotTables, use tools such as Power Pivot and the Data Analysis ToolPak to analyze data and visualize data and insights using advanced visualizations in charts and dashboards in Excel.

This very practical one-day programme provides participants with the skills and knowledge required to be an effective member of the procurement team and to enable them to procure a wide range of resources for the organisation, in a compliant and cost-effective manner. It also empowers them to be able to collaborate with all key stakeholders. By the end of the programme participants will be able to: Understand the basic concepts of good procurement practice Apply a range of tools and techniques for developing scopes of work and specifications Apply various methods to select and evaluate suppliers Develop robust contract award strategies Appreciate the commercial importance of effective procurement and opportunities to reduce cost and add value Develop appropriate procurement strategies depending on risk and value Appreciate the legal aspects of procurement 1 Welcome Introductions Aims and objectives Plan for the day 2 The basics of procurement The concept of total cost of ownership v price The procurement cycle The roles of the customer and the contractor Impact upon profit 3 Specification process Importance of effective specifications Specification development process Types of specification Team approach Use of performance specifications Early supplier involvement (ESI) / early contractor involvement (ECI) 4 Quality Concepts and practices Defining 'fit for purpose' Conformance to requirements Compliance to standards Role of the supplier Quality assurance tools and techniques 5 Procurement methods RFP RFQ ITT Negotiated procurement Strategic partnerships Outsourcing 6 Tendering How to undertake a formal tendering process Business case to award Critical stages in the process Risks and benefits 7 Tender evaluation How to undertake a quotation analysis Tools of analysis Use of VFM models Role of the customer Comparisons around cost, quality, and delivery 8 Supplier selection and evaluation Developing critical selection criteria Using the 10Cs model Importance of effective selection process Weighting systems Importance of validity and evidence 9 Capital equipment procurement Life cycle cost issues Payback calculations Compatibility issues Maintenance and training issues After-sales support 10 Supplier relationships Corporate social responsibility issues Communication 360 feed-back Open and ethical Initial understanding Clear and fair terms and conditions 11 Close Review of key learning points Personal action planning

Designed for quiet, shy, self-conscious and introverted people. In this introductory evening, you will be discovering the keys to authentic confidence based on author and self-confidence specialist, Claire Schrader's experiences of being a shy introvert, and what really worked in getting her out of her shell so she could achieve things in her personal and professional life she never would have thought possible. You will meet Claire in person and experience a series of confidence exercises that you will be able to put into practice in your everyday life. Claire creates an informal, relaxed, non-judgmental atmosphere that will quickly put you at your ease, and free you of the internal pressures that normally inhibit you from expressing yourself. It's a very safe place for you to gently stretch out of your comfort zone with people who feel in the same boat as you.

Date: 10th October Time: 4pm Location: Studio A Come and join our introductory session with Film Buddy for 2023! From work experience to mentoring programmes, Film Buddy has everything you need to get to grips with your career in film and start on the right track. Sign up for your FREE TICKET and we'll see you there!

This intensive one-day IACCM-approved programme helps participants develop the skills, knowledge and competencies required to plan for and carry out effective negotiations in a range of different environments. By the end of the programme participants will be able to: Understand the basic concepts of negotiation and how it adds value to the organisation Recognise the stages of negotiation and the skills required at each stage Make use of tried-and-tested negotiation planning tools Apply a range of negotiation tools and techniques to support the organisation in obtaining value for money, quality and fit-for-purpose outcomes Set negotiation objectives Appreciate the importance of interpersonal skills in maximising the opportunities for reaching win/win agreements 1 Welcome Introductions Aims and objectives Plan for the day 2 Why negotiate? Understanding the negotiation context Negotiating with suppliers Negotiating with stakeholders 3 Understanding the process The phases of negotiation and what to do in each phase Before During After 4 Planning Appreciating the importance of planning Different approaches Identifying the key variables Setting objectives for each of them Practical negotiation planning exercise 5 Doing The key skills required, Communication Numeracy empathy Applying these skills in a role play: practical exercise 6 Close Review of key learning points Personal action planning

Mindfulness is a practical technique for developing a greater sense of awareness and focus on the present moment. It is the opposite of mindlessness, meaning that actions and reactions become conscious and deliberate. It is an extremely useful tool for any busy work environment. Currently being used by the likes of Google and Pepsi, mindfulness can be adopted within the workplace to reduce stress and anxiety, provide greater focus and clarity, improve leadership capabilities and enhance the general wellbeing of staff at all levels. This workshop has been developed for forward-thinking organisations wanting to make a real and sustainable commitment to improving workplace wellbeing and productivity. This workshop will help you to understand the basic principles and benefits of mindfulness, and how it can be used in the workplace setting. It will also enable you to develop techniques to alleviate overwhelming feelings of stress or anxiety, prepare for important or challenging meetings, and generally achieve a greater sense of focus, clarity and calm whilst dealing with a hectic schedule.

Date: 9th October Time: 4pm Location: Studio A Come and join our introductory session with Film Buddy for 2023! From work experience to mentoring programmes, Film Buddy has everything you need to get to grips with your career in film and start on the right track. Sign up for your FREE TICKET and we'll see you there!

Hello little stars and welcome to our Ballet Beginners Dance Class, lovingly designed for our tiniest dancers aged between 3 and 5. Ready to dip your toes into the magical world of ballet and take your first dance steps? If your heart is saying a big "Yes!", then we are thrilled to welcome you on board! Ballet is more than just a dance form; it's an enchanting story told through movement and grace. Our Ballet Beginners class is a gentle introduction to this beautiful dance style. From the moment your little one steps into our ballet studio, they'll be embarking on an exciting journey of discovery and growth. In our class, we'll start with the very basics of ballet. We'll be learning essential dance steps, from the lovely "plié" to the elegant "relevé". Our caring and professional instructors will guide your child through these first steps, ensuring they learn in a nurturing and fun environment. But ballet is about more than just dance steps. We'll also be focusing on balance, coordination, and posture, helping to develop muscle strength and flexibility. Through a variety of fun activities and exercises, your child will not only become a budding ballet dancer but also develop as a confident little mover! Yet, Ballet Beginners is not just about learning ballet. We believe that dance is a powerful tool for building life skills. Through ballet, your child will boost their self-esteem, learn to express themselves, and even develop discipline and patience. Each step, twirl, and leap is a step towards confidence and self-belief! Friendship is another delightful aspect of our class. Your child will make wonderful friends who share their love for ballet. They'll form bonds that go beyond the dance studio, creating beautiful memories along the way. So, pull on your little ballet slippers, tiny dancers! It's time to twirl, leap, and discover the joy of ballet in our Ballet Beginners class. We can't wait to guide you on this exciting journey. Remember, ballet is about expressing yourself, developing grace, and most importantly, enjoying the journey. So, let's step, leap, and love the ballet beat together in our Ballet Beginners class! See you at the barre!

Hello there, tiny tumblers and little leapers! Welcome to our delightful Acro Beginners Dance Class, meticulously designed for our budding acrobats aged between 5 and 9. Are you ready to jump into an exciting world of flips, spins, and maybe a cartwheel or two? If your answer is a resounding "Yes!", then you're in the right place. Acro dance is a unique style that combines the grace of dance with the thrill of acrobatics. Our Acro Beginners class is the perfect introduction to this fascinating dance form. From the moment your little one steps onto our specially designed acro mats, they'll be set for an exhilarating journey of discovery! Our class starts with basic acrobatic tricks that are as fun to learn as they are to perform. We'll be somersaulting, cartwheeling, and even handstanding our way into the world of acro dance. Our friendly and experienced instructors will ensure that each child learns at their own pace in a safe and supportive environment. But we'll be doing more than just acrobatics. We're also working on enhancing flexibility, balance, and stretching. Through a variety of engaging activities and exercises, your child will develop these skills, becoming not just a better acro dancer, but also a more confident mover! Yet, our Acro Beginners class is not just about learning acro dance. We believe that dance is an invaluable tool for teaching life skills. Through acro dance, your child will improve their self-esteem, learn to work as part of a team, and even develop resilience. Each cartwheel, leap, and roll is a lesson in determination and self-belief! And let's not forget the wonderful friends your child will make in our class. Acro dance is about collaboration and trust, and our class is a community of little acrobats supporting and cheering for each other. Your child will make friendships that go beyond the dance floor, creating beautiful memories along the way. So, lace up your dancing shoes, little acrobats! It's time to tumble, flip, and leap into the captivating world of acro dance. We can't wait to welcome you to our Acro Beginners Dance Class and start this exciting journey together. Remember, acro dance is about having fun, expressing yourself, and working together. So, let's embark on our acro adventure, where every flip and roll is a step towards joy and self-confidence! See you on the dance mat!