1620 Courses in London

Gain comprehensive knowledge and practical skills for safe and effective oral suctioning procedures with our "Understanding Oral Suctioning Techniques" course. Prevent respiratory complications and maintain optimal respiratory function with thorough training in techniques, considerations, and patient care.

Gain essential knowledge and practical skills to provide effective care for patients with stomas with our "An Understanding of Stoma Care" course. Learn how to maintain stoma health and support patients through their journey.

Enhance your ear assessment and care skills with our comprehensive course on ear irrigation. Gain practical knowledge and updated insights for optimal ear hygiene.

Gain comprehensive knowledge and practical skills for safe and effective oropharyngeal suctioning with our course. Learn techniques, equipment, and considerations for this critical procedure.

Course Objectives At the end of this course you will be able to: Customise tables and charts Customise formatting with styles and themes Modify pictures in a document Create customised graphic elements Insert content using Quick Parts Control text flow Use templates to automate document creation Perform mail merges Use macros to automate common tasks '1 year email support service Take a look at the consistent excellent feedback from our corporate clients visiting our site ms-officetraining co uk Customer Feedback Excelent enviroment for training. Tahnk you. Jenny Price - ACER ' 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 public, one to one, tailored and bespoke courses. Our competitive rates start from £550.00 per day of training Tailored training courses: 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. Working with Tables and Charts Sort Table Data Control Cell Layout Perform Calculations in a Table Create a Chart Customising Formats Using Styles and Themes Create and Modify Text Styles Create Custom List or Table Styles Apply Document Themes Using Images in a Document Resize an Image Adjust Image Appearance Integrate Pictures and Text Insert and Format Screenshots Use the Snipping tool Creating Custom Graphic Elements Create Text Boxes and Pull Quotes Draw Shapes Add WordArt and Other Text Effects Create Complex Illustrations with SmartArt Inserting Content Using Quick Parts Insert Building Blocks Create and Modify Building Blocks Insert Fields Using Quick Parts Controlling Text Flow Control Paragraph Flow Insert Section Breaks Insert Columns Link Text Boxes to Control Text Flow Using Templates Create a Document Using a Template Create a Template Using Mail Merge The Mail Merge Features Merge Envelopes and Labels Create a Data Source Using Word Using Macros Automate Tasks Using Macros Create a Macro Who is this course for? Who is this course for? This course is designed for users who to create or modify complex business documents as well as customised Word efficiency tools Requirements Requirements Preferably, delegates should have attended the Word Introduction course. Career path Career path Microsoft Office 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 Certificates Certificates Certificate of completion Digital certificate - Included

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 public, one to one, tailored and bespoke courses. Tailored training courses: In, 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. 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 Certificates Certificates Certificate of completion Digital certificate - Included

Course Objectives At the end of this course you will be able to: Work with advanced lookup and reference functions Create macros to automate common tasks Use advanced techniques to analyse data Create PivotTables and PivotCharts Work with data validation tools Import and export data ' Customer Feedback Best Training Ever! Just finished a bespoke 1-1 training course in Excel Advanced, Macros & VBA. Pedro is an excellent trainer, imparting his skills and knowledge in the best way - appropriately to audience skills, knowledge and ability. Pedro is always approachable, encouraging and supportive, giving delegates the optimum learning environment. I would not hesitate to recommend Pedro as a trainer, whatever your level of ability. Amanda Morris - Treasury & Systems Accountant at Reall - Real Equity for All The course was very interesting and engaging and will definitely be put to use. The trainer was very helpful and charismatic. Marving Lopez - AM Best Europe Pedro was excellent. Very knowledgeable, clear and great rapport with class. Darren Barkey - Direct Wines Great content and learnt a lot. Really enjoyable :) Kristie-Lee Ryan - Stirling Ackroyd 1 year email support service Take a closer look at the consistent excellent feedback from our growing 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 public, one to one, tailored and bespoke courses. Our competitive rates start from £550.00 per day of training Tailored training courses: 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. Advanced Functions COUNT, COUNTA, COUNTIF, COUNTBLANK, SUMIF, SUBTOTAL IF, OR, AND, IFERROR VLOOKUP to lookup Exact Values and Approximate values MATCH, INDIRECT, ROW/COLUMN, INDEX, OFFSET Analysing Data PMT function to calculate a monthly payment of a loan What If Analysis using Goal Seek Use scenarios to consider many different variables Using Solver Add-in to optimize variables PivotTables Create a PivotTable to analyse worksheet data Add or remove fields in a PivotTable Change the data source for a PivotTable Working with external data sources Using different Statistical Functions Calculate a Running Total, % of Grant Total, Difference From… Using the Slicer and Timeline to filter the PivotTable Using Filters in a PivotTable Group by Date, Auto Group by ranges of values, Custom Group Create a PivotChart The GETPIVOTDATA function Formula auditing Precedents and dependents Error checking Watch a formula and its result by using the Watch Window Evaluate a nested formula one step at a time Data Validation Number Validation Data List Validation Message Prompts and Alerts Conditional Data Validation Data Validation Errors Consolidation Consolidate data by position Consolidate data by category Use a formula to consolidate data Outline (group) data in a worksheet Create an outline of rows Create an outline of columns Copy outlined data Hide or remove an outline Connect external data to your workbook Using the Power Query Editor to import data From Text and CSV, From Access, From Web, From another Workbook Using the Power Query Editor to; Transform your data by Selecting which fields to import, by Splitting Columns, Changing Data Type and more. Deleting Applied Steps Refreshing your data Working with Form Controls; Buttons, Option Buttons and Scroll Bars Introduction to Macros Change Macro Security settings How to Record a macro Some Macro Examples Delete a macro Edit the macro to view the VBA code Copy part of a macro to create another macro Assign a macro to a button Who is this course for? Who is this course for? This course is intended to end users who want to develop their skills so they can use advanced techniques to analyse extensive and complex datasets in Excel and to automate simple tasks with the use of Macros. Requirements Requirements Preferably, delegates should have attended the Excel Intermediate 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 Certificates Certificates Certificate of completion Digital certificate - Included

“Photography is more than a medium for factual communication of ideas. It is a creative art" - Ansel Adams Photoshop For Photographers When you're ready to take the next step in your photo-education and learn to use Photoshop - our Photoshop for Photographers course will take you from Photoshop novice to someone who can confidently navigate it and use its super powerful tools to take your photos beyond what you thought was possible! So if you've ever dreamt about being able to use Photoshop, maybe even got as far as opening it and quickly get overwhelmed with all that's packed inside - we've got you. KEY COURSE INFO: Course type: Instructor-led Course level: 2 levels - Essential Photoshop ( L1) and Creative Photoshop (L2) Course duration: each course level consists of 4 weeks + prep module Course format: Online course with step by step tutorials, instructional videos and interactive edit-along live classes, feedback on your learning and support group WHAT YOU LEARN: Our Photoshop for Photographers is a 2 level course - the first one covering all the key aspects of understanding how to navigate and work in Photoshop along with its most widely used tools and techniques, the second one building on top of that to really boost the creative uses you can apply it to.  This incredibly in-depth course has everything you need as a photographer who wants to harness this amazing tool.  What you learn: from basic Photoshop tools to more complex photo manipulations, from playing with colour to portrait retouching, from adding light to removing any unwanted object from your photos and lots, lots more. key photoshop tools object removal and placements - face / sky swaps Overlays & blending modes The art of adding light Skin editing and retouching introduction to compositing THIS IS THE COURSE FOR YOU IF : You you already know basics of editing (in Lightroom) but want to take them further into Photoshop ( where more fun happens) You tried using Photoshop before only to close it immediately after opening due to all the overwhelmingly unfamiliar tools and options You followed youtube tutorials before but beside replicating what the person did exactly, you still don't really have a good idea of how to use Photoshop - or why you should!? You want to be able to take advantage of the tools that are missing in Lightroom or do not give you sufficient control over them to do the job seamlessly - such as precise ways of removing unwanted objects in your image - Photoshop's powerful tools, such as the Content-Aware Fill and Clone Stamp enable you to remove distracting objects or people from your photos, ensuring the focus remains on the subject You want to be able to manipulate or replace elements in your images - from turning your background blurry to replacing blank skies, doing face swaps and more You want to be able to bring beautiful light into your images - from haze to sun rays, from - with colours that pop and light that's perfectly balanced You want to be able to take yoru portraits to a new level - remove blemishes, retouch skin,and correct imperfections, giving your images a polished and professional finish. You desire to create stunning composites: With Photoshop, you can combine multiple images seamlessly to create captivating composite photos. This skill is particularly useful for photographers who want to tell stories or create imaginative and surreal images. ONE COURSE - 2 LEVELS ESSENTIAL PHOTOSHOP Pick this course if you're new to Photoshop or do not have a lot of experience in Photoshop In this course you learn to : Navigate the software and set it up for a proper, smart, non-destructive workflow Discover all the essential tools and techniques that take your images way beyond what you could do in Lightroom Learn the key skills : from masks to brushes, from blending modes to selections, from cloning to canvas extensions, from face swaps to sky swaps - and more!! CREATIVE PHOTOSHOP Pick this course if you're already familiar with the basic tools and ways of working in Photoshop  In this course you take all that you learned in the Essentials course and turbo boost it for creativity. You'll learn : How to play with light, colour and blur for unique creative outcomes How to get more out of the familiar tools - so advanced brushes, advanced selections, advanced blending More fun skills : from skin edits to retouching, from stitching photos to involved composites, from creating effects such as neon glow to turning your photos into comics and more! Learn more about Creative Photoshop WHAT'S INCLUDED IN EACH OF OUR PHOTOSHOP COURSES: 4 core modules - each with detailed step by step tutorials, downloadable videos and PDF workbooks Support Facebook group Weekly edit-along live webinar Practice files to learn on Feedback on your images ESSENTIAL PHOTOSHOP Next Essential Photoshop course starts 15 January 2024 The way you work in Photoshop is very different compared to Lightroom and a big learning curve for anyone who begins learning it for the first time. It's also a big reason why a lot of photographers open it for the first time, find it hard to recognise any familiar tools or make them work on the image and the give up.  In this course we take you through it step by step. We show you around this tool and teach you how to use it in a way that's smart, non-destructive, flexible and making the most of its amazing features.  Here is a non-exhaustive list of what you will learn:  A thorough understanding of Layers, masks and brushes - you cannot really work effectively in Photoshop if you do not know how to use these tools. An absolute must! Key Photoshop tools - Photoshop is a hugely vast tool used by lots of different creative professions and depending on what you use it for, you will be using different tools. We introduce you to the ones that are key for a photographer! Working with Adjustment layers - these fantastic tools allow you to change colours, adjust tone and mood of images Removing and replacing parts of your photos - powerful selection, healing, cloning, content aware tools and more to allow you to clean up your images of everything that's undesirable or distracting in your images Simple composites ( Face swaps / Sky swaps) - while composites can be hugely complex and challenging, we show you how to get started with a few simple - but effective ones!Understanding Precision tools and filters for blurring and sharpening Blending modes and their immense potential for transforming your images with the tools you already know - from working with overlays to CREATIVE PHOTOSHOP Next Creative Photoshop course starts 15 April 2024 In Level 2 we build on the foundation we establish in Level 1 and start applying what you have learned more creatively - as well as learning more tools, more techniques and starting more fun projects. This is where we really get to have fun with those powerful tools - we learn not just how to fix and clean up undesirable elements from the photos, but how to creatively treat them so that they reflect your creative vision and imagination.  The magic of Colour and blur - adding mood and softness to images to transform the images . We use several creative techniques to completel;y transform the images Adding and creating light effects in Photoshop - from light beams to sun burtsts to rainbows! Step by step skin editing and portrait retouching - from adjusting skin tones, removing unwanted colour casts, disappearing blemishes and creating highend, polished portraits that still retain healthy skin texture Using smart filters and creative adjustment layers to achieve effects such as turning your images into cartoons, watercolours or neon effects Working with and creating your own custom brushes, overlays etc - the power of photoshop brushes has to be experienced to be believed - from adding light rays to Playing with composites - adding magic to your images or creating new scenes and stories from scratch PHOTOSHOP For Photographers  Photoshop courses - KEY INFO Essential Photoshop ( Level 1) - 4 week course, starts 15 Jan 2024 Creative Photoshop ( Level 2) - 4 week course, 15 April 2024 Course cost: BOOKING A SINGLE COURSE: £179 ( payment plans available ) BOOKING A BUNDLE: Book Level 1 and Level 2 together :  £259  (payment plans available )  PHOTOSHOP FOR PHOTOGRAPHERS Each course consists of 4 weekly modules with step by step illustrated tutorials and videos + prep module weekly edit along class online class ( also recorded) feedback and advice on your edits private support group PDF workbook and downloadable videos Practice images to learn on COURSE PREREQUISITES: Adobe Photoshop software installed on your computer or tablet.This can be purchased either as a standalone Photoshop Subscription or as part of the Photography Plan which includes also access to Lightroom and Lightroom Classic. Please note that you need to ensure that your computer can run Photoshop - please follow Adobe minimum system requirements guidelines

https://www.instagram.com/masterpeacelondon/

https://www.instagram.com/masterpeacelondon/