427 Courses in London

Who would find this course useful? This is useful if you have some coding skills already. This course is fast-paced, not quite at the basics level.

MS Word Advanced Course summary This MS Word Advanced Course, Private 1-to-1, covers advanced MS Word tools. Ideal for delegates who create long documents, manuals and manuscripts. MS Word styles and formats, help making formatting documents consistent and easy to maintain. Who Should Attend the MS Word Advanced Course: Delegates should have a working knowledge of the concepts covered in the Introduction and Intermediate courses. What is MS Word: Microsoft Word, or simply Word, is a word processing software package developed by Microsoft. Is is bundled within the Microsoft Office suite. It covers simple text editor capability through to desktop publishing features, suitable to creates professional documents for any purpose MS Word Advanced Course description Session 1:Managing and Reviewing Documents Using Comments Tracking changes, version control Session 2: Styles Creating an Outline Style Principles, Style Themes, Creating, Modifying, Using Styles, Styles menus and Styles Group on the Home Ribbon. Session 3: Sections Formatting, page layouts, page numbering, headers and footers with sections Session 4:MS Word Tables and Text Boxes Inserting, Editing, Formatting and positioning MS Word Tables and Text Boxes Session 5: MS Word Reference Tools Table of Contents References within a Document Bibliography Index Tabls Reference Tables References to Other Documents Session 6: MS Word Templates Creating, saving and using custom templates Session 7: Templates and Building Blocks Using Building Blocks and Quick Parts, Fill-In Merge for Templates Session 8: Graphics Creating Graphics, Equations and Charts, Using WordArt, Using SmartArt Session 9: MS Word Time Saving Tools MS Word Time Saving Tools Using Language Tools Inserting Pre-Defined Text Using the Navigation Pane What is included in the MS Word Advanced Courses: MS Word Advanced Course Certificate on completion MS Word Advanced Course notes Practical MS Word Advanced Course exercises, MS Word Advanced Course Homework / MS Word Advanced Course Revision work After the course, 1 free session for questions online MS Word Advanced Course via Gotomeeting.com. Max group size, online and in classroom, on this MS Word Advanced Course is 4.

Being a Mentor in the Early Years

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

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.

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.

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!

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

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

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