509 Courses in London

Being a Mentor in the Early Years

Date: Thursday 15th June Time: 4pm Location: Studio A - Landor Road Event Details: Tim Haines is a television producer and director, having worked on several highly-respected documentary and drama productions over a storied career. Tim will speak about the following topics as well as others at the event: Approaches to Documentary How a Documentary Gets Made The Purpose of a Documentary Modern Combinations of CGI & Live Action Throughout students will have the chance to ask questions about the topics being discussed, before wrapping up with a wider Q+A session at the end. A multiple Emmy and BAFTA winner, Tim has worked on many well known series, including: - Walking with Dinosaurs - Director & Producer - Primeval - Producer - The Loch - Producer - Surviving Earth (currently in production) - Producer This is a free event that all students are welcome to attend. Be sure to book tickets in advance though so that you don't miss out!

Java Webinar Course summary In this Java Webinar Course you will learn Java Basics and OOP Principles. Java Webinar Course description This Java Course is Online, instructor-led, practical attended via Gotomeeting.com. When we receive your booking, we email a connection invitation. This Java Course Webinar will allow you to learn flexibly and commute-free from home. There is no need for attending face-to-face, all advantages of the classroom in built-in and planned for during the delivery of this webinar. We teach online with excellent instruction and targetted well-planned practicals that will clearly illustrate techniques and accurately develop your skills. Question time is built in. Session 1: Data Types, Variables, and Arrays: Primitive types; Characters; Boolean; Working with variables and its scope; Type conversion and casting; Introduction to String class; Working with arrays Session 2: Operators and Expressions Introduction of operators; Arithmetic operators; Relational operators; Assignment operator; Logical operators; Increment and decrement operators; More in operators Session 3: Decision Making If statement; If - else statement; If- else if - else statement; Nested if - else; Switch Statements Session 4: Using Loops The while, do-while and the for loop; Enhanced for loop; Jump statements : break, continue; The return statement; Nesting loops; Using the for-each loop with Arrays Session 5: Methods Introduction of methods; Creating a Method in class; Calling a Method; Returning value from a Method; Adding a Method that takes parameters Session 6: Classes Creating an Object; Using an Object. Adding Instance variables; Controlling accessibility; Class Constructors; Parameterized Constructors; Inheritance. Abstraction. Interfaces and implementing interfaces. Override. Polymorphism. The dot operator, this, static, super, final keywords More in Methods and Classes: Overloading methods; Overloading Constructors; Using objects as parameters; Returning objects; Recursion Java Access control: private, public and protected; Java Nested and inner classes; A stack class Session 7: Java Data structures Files, Streams, Collections. Session 8: Java Exception Handling Fundamentals of exception handling; Exception types; Using try and catch; Multiple catch clauses; Nested try statements; Throw and throws; Finally Blocks Included in the Java Webinar Courses: Java Webinar Course Certificate on completion Java Webinar Course Manual Practical Java Webinar Course exercises, Java Webinar Code Samples/ Java Webinar Course Revision work After the course, 1 free session for questions online Java Webinar Course via Gotomeeting.com. Max group size, online and in classroom, on this Java Webinar Course is 4.

Most people only use a fraction of Excel's capabilities. This workshop shows what you've been missing! This course will help participants: Nest formulas Get the most from pivot tables Use conditional formatting Write array formulas Explore the lookup functions Calculate by criteria Use 'goal seek' and 'scenario manager' for what-if analysis Record macros 1 Nesting formulas Principles of nesting formulas together Using IF with AND or OR to answer questions Nesting an AND function in an IF Nesting an OR function in an IF 2 Advanced pivot table reports Grouping dates, numerical and text items Running percentage analyse Running analyses to compare data Inserting Field calculations Finishing off with a user-friendly dashboard 3 Advanced conditional formatting Colour table rows based on criteria in it Applying colour to approaching dates Exploring the different rule types 4 Lookup functions Going beyond the VLOOKUP function Lookups that retrieve data from left or right The versatile INDEX and MATCH functions Retrieving data from columns with duplicates 5 Calculate by criteria Using SUMIFS to sum by criteria Finding an average by criteria with AVERAGEIFS Use SUMPRODUCT to multiply then add different values 6 What-if analysis Use Goal Seek to meet targets Forecast reports with the Scenario Manager 7 Recording Macros Macro security Understanding a Relative References macro Recording, running and editing macros Saving files as Macro Enabled Workbooks Introduction to VBA code Making macros available across workbooks Add a macro button to the Quick Access toolbar

Nigel Reed, The Dog Guardian is hosting a series of seminars revealing his easy-to-follow method for a happy and well-behaved dog.

Conflict within a workplace can appear in many forms, from personality conflicts between employees to employee and supervisor issues. This course will equip you with the knowledge of conflict management strategies and the practical skills to take steps to help to resolve situations of conflict.

SSRS Report Builder Course Summary. Practical SSRS Report Builder course, to leavy you full conversant with queries, DML and DDL statements. Hands-on, Practical SSRS course. PCWorkshops SSRS Course Certificate. Max 4 people per course, we keep it personalised. Where is the SSRS Report Builder Course? Online: Instructor-led. Classroom: Request per email. SSRS Course Materials SSRS Coding Examples Manuals and Notes: In-depth reference materials Exercises: Practical exercises Payment Options → £600, Follow the booking link Arrange for installments Included with SSRS Report Builder Course: SSRS Course Certificate on completion. SSRS Course Manual. Practical SSRS Course exercises. SSRS Code Samples. After the course, 1 free session for questions. Max group size, online and in classroom, on this SSRS Course is 4. Course Topics SSRS Report Builder Course Topics SSRS Course topics: This course focus on producing reports using MS SQL SSRS Report Builder, to use the product features and tools related to data retrieval, visualisations and deployment. The Target Audience: end-users who will produce reports for their department or group using datasets. SSRS Course Topics Report Models: Data source views Creating a model Entities, attributes and roles Tables: Creating tables Interactive sorting Floating headers Grouping: Inserting groups Group headers/footers Displaying group totals Expanding and collapsing Expressions: The expression builder The Report Items collection Built-in fields Conditional formatting expressions Page headers and footers Page names and numbers Exporting reports: The various report formats Using RenderFormat. Parameters: Creating parameters Filtering using parameters Drop list parameters Coping with empty tables Matrices: Row and column groups Sorting and filtering matrices Creating subtotals Charts: Creating charts The parts of a chart Formatting charts Basic reports: Text boxes and images Selecting report items Formatting parts of a report Miniature charts Creating sparklines Creating data bars Graphical indicators Creating and customising indicators Linear and radial gauges Lists: Page-per-record lists Dashboard lists Other list ideas Subreports: Creating a child report Creating the main report Linking the two reports Report parts: Publishing report parts The report part gallery Updating report parts Book the SSRS Course About us Our experienced trainers are award winners. More about us FAQ's Client Comments

SSRS Report Builder Course Summary. Practical SSRS Report Builder course, to leavy you full conversant with queries, DML and DDL statements. Hands-on, Practical SSRS course. PCWorkshops SSRS Course Certificate. Max 4 people per course, we keep it personalised. Where is the SSRS Report Builder Course? Online: Instructor-led. Classroom: Request per email. SSRS Course Materials SSRS Coding Examples Manuals and Notes: In-depth reference materials Exercises: Practical exercises Payment Options → £600, Follow the booking link Arrange for installments Included with SSRS Report Builder Course: SSRS Course Certificate on completion. SSRS Course Manual. Practical SSRS Course exercises. SSRS Code Samples. After the course, 1 free session for questions. Max group size, online and in classroom, on this SSRS Course is 4. Course Topics SSRS Report Builder Course Topics SSRS Course topics: This course focus on producing reports using MS SQL SSRS Report Builder, to use the product features and tools related to data retrieval, visualisations and deployment. The Target Audience: end-users who will produce reports for their department or group using datasets. SSRS Course Topics Report Models: Data source views Creating a model Entities, attributes and roles Tables: Creating tables Interactive sorting Floating headers Grouping: Inserting groups Group headers/footers Displaying group totals Expanding and collapsing Expressions: The expression builder The Report Items collection Built-in fields Conditional formatting expressions Page headers and footers Page names and numbers Exporting reports: The various report formats Using RenderFormat. Parameters: Creating parameters Filtering using parameters Drop list parameters Coping with empty tables Matrices: Row and column groups Sorting and filtering matrices Creating subtotals Charts: Creating charts The parts of a chart Formatting charts Basic reports: Text boxes and images Selecting report items Formatting parts of a report Miniature charts Creating sparklines Creating data bars Graphical indicators Creating and customising indicators Linear and radial gauges Lists: Page-per-record lists Dashboard lists Other list ideas Subreports: Creating a child report Creating the main report Linking the two reports Report parts: Publishing report parts The report part gallery Updating report parts Book the SSRS Course About us Our experienced trainers are award winners. More about us FAQ's Client Comments

Who would find this course useful? This course excellent for beginners who would like to enter the programmer world via C#. Or for individuals have a particular need for C# Level: A good start for beginners through to intermediate with OOP. Practical confidence will be achieved with a very practical approach to the training. This is normally online, but onsite and classroom courses are also available on request

In a world focused on digital media, 24-hour news channels and social channels, it’s really important to communicate with your audience – there are lots of opportunities to do this if you are interviewed by journalists. There’s the chance to deliver expert comments or take part in in-depth features or give a quote about your business or organisation. The media wants to stay relevant and engaged with its audience and you can play a part in that and talk to your audience. In our Broadcast Media Training Courses, we will teach you the best ways to share your story, how to answer those difficult questions and present yourself with confidence and style. This means you will capitalise on every opportunity. Our broadcast media and media interview training courses include: Exploiting the opportunity The world of digital media means there are lots of opportunities to appear online, on radio or on TV, as an expert or commentator and gain invaluable exposure for your business and organisation. You may meet journalists at industry events or be contacted for a comment on an issue. You may also need media training because you have to protect your business’ reputation by reacting proactively if you become involved in a news story. Media training will help you handle interviews with journalists, content creators and other media professionals. You need to communicate positively and effectively and make sure your message reaches the audience. It means speaking consistently, and with style and confidence. You’ll also need to know how to handle challenging questions and make sure you positively manage your reputation. Contemporary Media Training Our media training is interactive, engaging and importantly, carried out by experienced journalist trainers. Our team has worked at the highest levels of journalism and broadcasting and will give you an invaluable insight into how to maximise the opportunity of a media appearance. We will take you through the background of what journalists want and need, and give you a clear understanding of how to prepare and deliver your messages and ideas. We will then carry out a number of media style interviews which our technical team will record and playback so you can see and hear yourself. We will then support you with practical, inclusive and useful feedback for you to put into practice for the next interview. We provide copies of all your recordings and useful notes after the training. Locations that suit you We deliver training at our facilities in Birmingham or London or at your location, bringing our technical equipment and cameras with us. You can have a half day training session for up to 4 people or a full day training for a larger group. We also deliver training online for small groups which can be useful when teams are spread around the country. Expert Journalist Trainers We pride ourselves on two things at Coherent Comms – delivering contemporary media training and our supportive inclusive feedback. We know there are lots of media training companies out there but our clients tell us they work with us because we listen. We don’t tell you what training you need or hark back to the old days. We take on board your communication needs and deliver bespoke training. Our associates are working in digital communications, carrying out interviews for news online sites and our contacts are producing digital content for a 21st century audience. We’ll talk to you about TV and radio but we understand the wider media landscape and how to navigate it. And we’re really proud of our feedback – we want to take you from good to great and believe confidence building with tips and ideas that will work for you is the best way to develop your skills. We will help you design the course you want All our media training is bespoke and designed to exactly suit your needs. We have lots of ideas of how it might work but we want to hear from you and what you want! So get in touch with our friendly team by phone on 0754 533 4269 or fill in our contact form and we will get back to you. We’d love to hear how you hope to improve your media and communication skills.