3082 Courses in London

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

Who Should Attend This course is aimed at candidates that require the knowledge to enable them to comply with working at height regulations, and go in depth into industry dangers and respectability when working at height.  This course can be completed by both novice and experienced candidates. We also offer refresher tests. Novice course- 1/2 day Experienced worker tests- 1/2 day. Course information Category N404 Safe Working At Height It is envisaged that by the end of this course of training the learner will be able to answer questions on and perform the following: ➢ Have a basic understanding of the industry, the dangers of working in the industry and their responsibilities when working at height ➢ Be able to define height work and identify the hazards of work above ground level and outline the general requirements necessary to control them ➢ Be able to identify accident causation in work at height ➢ Have an appreciation of planning and organisation of work at height ➢ Set up exclusion zone explaining actions required for emergency actions, identifying any overhead hazards ➢ Identify and maintain PPE appropriate for safe working at height use ➢ Demonstrate working at height and explain all safety issues that could arise Assessment Assessment will be to NPORS standards consisting of a theory test.

Level 3 Adult Teaching Qualification PTLLS course is designed to equip individuals with the knowledge and confidence to excel as teachers, trainers, or tutors in adult education. Here's what makes our Level 3 AET course stand out: 📚 Comprehensive Curriculum: Our course covers all essential aspects of adult education, ensuring that participants gain a solid foundation in teaching principles and practices. 💻 Flexible Learning Options: Whether you prefer Distance Learning/Online or Classroom-Based instruction, we offer convenient learning formats to accommodate your schedule and preferences. 🏆 Recognized Qualification: The Level 3 Adult Teaching Qualification is widely respected within the education sector and serves as a direct replacement for the Level 3/4 Preparing to Teach in the Lifelong Learning Sector (PTLLS) course. Take advantage of this limited-time offer to embark on your journey toward a rewarding career in education. Don't let this opportunity pass you by—secure your spot in our Level 3 AET course today and invest in your future success! Requirement: It is suitable for individuals not yet engaged in teaching or training roles (pre-service) and those currently involved in teaching or training (in-service). Offered through our online or classroom-based learning platforms, this qualification comes with comprehensive tutor support throughout the course. Units Covered: Chapter 1: The roles and responsibilities of a teacher / Trainer in education & Training Chapter 2: Relationships between education and training Chapter 3: Inclusive teaching approaches to meet the needs of learners Chapter 4: Principle of Assessment in Education and Training Chapter 5: How to create a safe and supportive learning environment Chapter 6: How to Motivate Learners Chapter 7: Planning, delivery and evaluation of inclusive teaching and training Chapter 8: Different assessment methods Chapter 9: How to recognise and deal with potential problems Chapter 10: Teaching equipment and aids Chapter 11: Practical teaching sessions (Teaching concept and Technique) Study Method: This course offers flexible study options, including Distance Learning/Online, Face-to-Face, or Live Zoom classes. With Distance Learning, you'll progress at your own pace with tutor support and access to online materials. The course lasts up to 3 months, but you can finish early and receive your certification sooner. Face-to-face or Live Zoom classes consist of 3 intensive days of instruction featuring various teaching activities led by experienced educators. Following the sessions, you'll complete coursework and assignments, with results and certificates typically issued within 7-8 days. Course Fees: The Level 3 Adult teaching qualification course is priced at £190.00 for Online Distance Learning, £249.99 for Webinar Live Class, £269.99 for Classroom-based courses in London, and £319.99 for Classroom-based courses outside London. There are no hidden fees or costs associated with this course. How to Enrol: To enrol in this course, you have several options. You can contact our friendly staff members at 0207 193 7669 to book over the phone. Additionally, you can book online by making a full payment or deposit. If you prefer, you can visit one of our offices in person to book physically. Payment methods include sending a cheque (payable to Learn More Academy Ltd.) or transferring course fees via bank transfer. We Russbridge Academy Ltd, are proud to be recognized as a leading training provider in the United Kingdom. With a proven track record of excellence and a commitment to delivering high-quality vocational and career-oriented courses, we've earned prestigious accolades such as the "Training Provider of the Year" awards from Southern Enterprise Awards and Corporate LiveWire Innovation & Excellence Awards. Additionally, we've been honoured with the title of "Best Leading Training Provider - UK" by Global 100 for two consecutive years.

Who is this course for? Newly qualified teachers, teaching assistants, learning support assistants   What will be covered? learning and progress working memory & long-term memory how we learn strategies for making sure pupils learn using assessment effectively feedback and progress using prompt, structure interventions

NPORS Rigging and Fleeting Loads (N047)

https://www.swbmacademy.co.uk/dsfullcoursepayment

NPORS Skidsteer Loader (N212)

Public Speaking Courses That Work Our public speaking courses are refreshingly different and transformative. Mindful presenting is the key to the future of high impact public speaking training. In fact, we are changing organisations one presentation at a time. We do that by providing training that empowers and equips professionals to present with greater confidence, clarity and impact.

Public Speaking Courses That Work Our public speaking courses are refreshingly different and transformative. Mindful presenting is the key to the future of high impact public speaking training. In fact, we are changing organisations one presentation at a time. We do that by providing training that empowers and equips professionals to present with greater confidence, clarity and impact.

Public Speaking Courses That Work Our public speaking courses are refreshingly different and transformative. Mindful presenting is the key to the future of high impact public speaking training. In fact, we are changing organisations one presentation at a time. We do that by providing training that empowers and equips professionals to present with greater confidence, clarity and impact.