21 Courses in London

“Light makes photography. Embrace light. Admire it. Love it. But above all, know light. Know it for all you are worth, and you will know the key to photography.” – George Eastman" - Photography For Parents - Shooting With Flash Next course starts on Monday 12th Feb 2024 Scared of Flash? Never got good results from it? Not sure how it works with your camera? Thinking it’s bound to be complicated and just for studio work? This is the course for you! We show you how to work your flash and your camera – on and off camera! - to get great, natural looking results. In this course you'll discover how to use flash not just to supplement light in dim spaces, but to use it creatively, to help you create images you wouldn't be able to capture with just natural light.  KEY COURSE INFO: Course type: Instructor-led Course duration: 4 weeks Course format: Online course with interactive live webinar classes, feedback on your learning and support group WHAT YOU LEARN: You will learn how to make your flash work with your camera and how to control it so that it gives you beautiful, natural looking light You will learn to work with the flash off camera - giving you the freedom to position your light wherever it will most suit your subject rather than relying on what you have with natural or indoor light You will learn to play with flash to capture a variety of creative outcomes and apply it to lots of shooting situations - from learning to fake pretty window light to freezing motion with Flash understanding flash equipment learning to shoot with on-camera flash earning to shoot with off-camera flash learning to bounce the light for natural looking results using flash as a sole or supplementary light source freezing movement with flash where the shutter speed wont allow it THIS IS THE COURSE FOR YOU IF : You find yourself struggling with light especially in the darker autumn / winter months, and there never seems to be enough ISO or aperture to get you what you want You can already use your camera in manual and want to add mastery of detachable flash to your skillset - so you can never worry about insufficient or poor light wherever you are, or whatever unknown space you go into You want to be able to make flash images look natural rather than sporting that famous 'deer in the headlights look. A good flash image never 'looks' like a flash image You want to learn how to capture creative images using a flash - such as freezing motion, creating dramatic shadows, or adding a splash of light to specific areas of the frame. You want to add this versatile skill to your toolbox so you can adapt it to different shooting scenarios. ESPECIALLY if you're considering taking up photography professionally or semi professionally, this is an immensely useful skill to have. Next Shooting with Flash course starts on 12 Feb 2024  4 core course modules Support Facebook group Weekly live webinar Weekly practice assignment Feedback on your images Why shoot with flash in the first place?  “Don’t use Flash – it will wash out your child”“Flash will make your photos look horrible”‘You can’t control flash – no control over what your photos will look like” You may have heard those statements, maybe even uttered them yourself. And to a degree – they can be true – but only because, if you don’t know how to control and work any tool, it’s likely to give you terrible outcomes – remember how much poorer your photos were when you first started with your camera on full auto? Here is how I see Flash, and what this course is about: Flash lets me bring light where there would normally be not enough light available to take a well exposed photo – and let me tell you – in glorious British weather, that’s more often that I would like! Flash lets me shape the light to suit my needs – I can make it moody or bright, I can even make it look like natural light ( yes really) Flash lets me neutralise ugly light and make it look good ( anybody else cursed with ugly spotlight lights in their home? no? just me? ) Flash lets me be in control, especially in unknown venues and locations, spaces where I won’t get a chance at that second shot. Flash helps me fill in shadows when shooting in very bright light – the goal is not to stop using natural light, but to help create a balanced image where natual light alone can't cut it COURSE PREREQUISITES YOUR SKILLS: We recommend that you are comfortable in shooting in full manual mode. It's possible to use flash in priority modes of course, but you don't have full control of its strength and level. YOUR EQUIPMENT: You will need to have a detachable flash for your camera make. This could be the same brand as your camera or a compatible third party flash manufacturer.  You will also need a way of triggering your flash OFF camera - in some cases, you may be able to do this directly from camera or via an additional remote trigger / controller. Click here to see our Flash buying guide below Shooting with FLASH Book your space now: COURSE STARTS : 12th Feb 2024 ( 4 weeks)COURSE COST : £179 ( payment plans available )What’s included: 4 weekly modules with step by step tutorials weekly live class online class ( also recorded) - on Tuesday evenings feedback and advice on your photos private support group PDF workbook Join our next group to learn how to never have to deal with insufficient light and discover a whole new area of photography! INSIDE THE MODULES - aka WHAT DO YOU LEARN? Module 1: Getting Started with Flash In this module we introduce you to the principles of making your flash work with your camera. We show you how the two work together in layering exposures, how you can control both the flash and natural light side and how to achieve predictable outcomes from your flash. This is the biggest learning curve because the way you work your camera with flash is very different to how you do this with just natural light and understanding the control side of things will let you get creative afterwards.  Major Takeaways: At the end of the module you will have gained an understanding of how to work your flash ON your camera. With that, you will have learned how to balance your key light and your fill light, how to combine flash exposure with a natural light exposure, how to supplement or even replace light with flash light. You will also make first steps into bouncing the light to give it a more natural appearance.  Module 2: Taking your flash OFF camera  In this module we teach you how to make your flash work when detached from your camera. We look at different techniques and methods or shooting off camera as well as any additional equipment you may need for this. We teach you how to use that off camera flash for a number of practical and creative examples Major Takeaways: You will be able to use the flash off camera - whatever your preferred off camera methos. We will explore using off camera flash as the key light - creating low key and high key images, as fill light and as a supplementary light to provide additional dimension to the images.  Module 3: Making flash look natural  In this module we learn to recognise how you can adjust the very quality of your flash to create natural looking images. We learn how to bend - or bounce the light - on and off camera, to create the kind of images that noone would ever suspect of being taken with flash. We also introduce you to a number of light modifiers and show you what you can expect from them as well as what might work in the way you take the photos.  Major Takeaways: Learn how to modify your flash to achieve soft or hard light look. Discover how to bounce your flash and where from and how the angle of those flash bounces will give your subject very different looks. Learn about light fall-off and how to apply this principle to achieve more or less contrast filled images when using flash/  Module 4:Flash and motion In this module we show you how to use flash when trying to freeze your subject - whether it is your child bouncing on the soufe in dim Novemeber light or an inanimate object making a splash. We also introduce you to a few way you can play with flash and your shutter speed to achieve fun and creative outcomes. Major Takeaways: You will learn how to freeze movement with flash - even on very slow shutter speeds or in very poor light. You will learn how shutter and flash work together and how you can achieve great creative outcomes such as high speed photography or freezing rain.  Next course starts on 12 Feb 2024

Concise Cisco routers course description A fast paced practical hands on introduction to Cisco routers concentrating on basic product knowledge needed for the real world. Starts with the basics of routing through configuring static routes, RIP, OSPF, and EIGRP ending with access lists. Hands on sessions follow all the major chapters with a major practical at the end to reinforce all that was learnt in the course. What will you learn Use the Cisco setup script. Use the Cisco command line. Perform basic troubleshooting. Configure - Interfaces - RIP, IGRP - OSPF, EIGRP Concise Cisco routers course details Who will benefit: Anyone who will be working with Cisco routers. In particular: Network Administrators, Field engineers, Network support personnel Prerequisites: None, although a knowledge of the TCP/IP protocols would be advantageous. Duration 3 days Concise Cisco routers course content Basics of routing What are routers? Network protocols, Routing protocols. The Cisco routers Router models, The IOS, DRAM, SRAM, NVRAM, Flash, ROM and boot flash. Getting started Accessing the router, installing a Cisco, using the setup script. The command line interface User and privilege modes, online help show, debug, basic troubleshooting Configuring Ciscos The configuration editor, Global, major and sub commands, enable, secret and other passwords, telnet. Miscellaneous exercises Buffered logging, web access, CDP… Subnetting IP addressing rules. The need for subnetting, subnet masks, Calculating network numbers. Configuring Interfaces Basics, Ethernet, Serial lines, PPP, DCE, loopback interfaces. Static routes Why use static routes? Configuring static routes, default routes. Configuring RIP and IGRP How they work, configuration, troubleshooting. OSPF Configuration and troubleshooting. EIGRP Configuration and troubleshooting. Housekeeping Configuration management, offline editing and TFTP usage. Cisco boot sequence, IOS upgrades. Bypassing Cisco passwords. Access lists What are access lists? General rules, basic and extended IP access lists. Putting it all together A series of exercises based around, installs, adds, moves, changes, upgrades and troubleshootin

Video coding training course description This course investigates the characteristics of video coding with an emphasis on compression and the standards used in IP networks. What will you learn Explain how video coding works. Describe the main video coding standards. Evaluate and compare the major video coding standards. Video coding training course details Who will benefit: Anyone working with MPEG. Prerequisites: None. Duration 2 days Video coding training course contents Introduction Video coding systems, encoding, transmission, decoding. Digital video formats: Old formats (CIF…), PC formats (VGA…), SD, HD, UHD. Video codecs What is a CODEC, pictures and audio, digitisation, sampling, quantisation, encoding, compressing. Codec types Lossy, lossless, uncompressed. Quality, bandwidth. Video Fps, bitstreams, pictures, frames, fields. Aspect ratios. Colour Colour perception, RGB, YUV, YCbCr sampling, 4:00, 4:2:0, 4:2:2, 4:4:4. Hybrid video coding scheme Picture partitioning, intra prediction, inter prediction, motion estimation, residual coding, in loop filtering, entropy coding. Containers Relationship with codecs, audio, video. Audio Video Interleave (.avi), .asf, QuickTime, AVCHD, Flash, .mp4, 3gp. MPEG-TS. MPEG Analysing MPEG frames. Video coding standards H.264/AVC: Profiles MPEG, bit rates, resolution. I, B, P frames, GOP. MPEG 2, MPEG 4, H.264, H.265, VP9, AV1. Hands onand levels, how it works. H.265/HEVC: Profiles and levels, Quadtrees, slices, how it works. Open video coding: VP8, VP9, AV1.

Effective Presentation Skills: In-House Training In today's results-oriented, global working environment, the ability to create and deliver presentations effectively is a necessary skill set for people at all levels of an organization. Regardless of your role, it's important to know how to synthesize your ideas into a coherent and focused narrative, add visuals that support and reinforce your message, and deliver it in a way that resonates with your audience. In this highly interactive course, we will unpack and practice some of the tools and techniques used by top speakers and influencers all over the world. In this engaging two-day course, you will plan, write, refine, practice, and deliver a presentation to the class. Your presentation will be filmed on both days, and you will leave the course with a flash-drive copy of your videos; participants of the virtual classroom workshop should be prepared to present via webcam. In addition to discovering and enhancing your own personal delivery style, you will learn how to create an overarching goal for your presentation and then organize and structure it for maximum impact. You'll gain insight into how to anticipate your audience's needs and tailor the content and delivery in a way that connects with them and sustains their attention and engagement. You will also learn skills that will help you control nervous energy, remain focused on and attuned to your audience, improvise under pressure, deal effectively with questions, and build a compelling call to action. What you will Learn At the end of this program, you will be able to: Construct an effective presentation goal statement, opening, body, and closing that connect with an audience Analyze an audience's needs and style preferences, including relevant DiSC®-related elements Deliver a complete criteria-based presentation that will persuade others Align usage of visuals as well as verbal and non-verbal techniques to maximize the impact of your presentation Getting Started Introductions and social agreements Course structure Course goals and objectives Opening activities Planning and Organizing Video: 'The Art of Misdirection' Setting your presentation goal Writing a goal statement Analyzing your audience Applying the 'reality' test Creating and strengthening supports Structuring your presentation 5 components of an effective opening Presentation body Presentation closing Write your presentation opening Audience Analysis Video: 'How to Tie Your Shoes' Everything DiSC® introduction Audience DiSC® Styles Analyzing your audience Further audience analysis Effective Delivery Delivery challenges: virtual and in-person Keeping your audience engaged Your body as your instrument Verbal / paraverbal elements Body stance and nonverbal communication What are your 'tells?' Controlling nervousness Staying attuned to your audience Responding to questions Review and edit your opening Deliver your opening Visuals and Enriching Elements Using images in your presentation Guidelines for visual composition Using questions to engage your audience The power of the pause Practicing and Applying What You've Learned Preparation Delivery Feedback Opportunity to put into practice the program content and receive a video copy Summary and Next Steps What did we learn and how can we implement this in our work environment? Your personal action plan

Effective Presentation Skills (In-Person) In today's results-oriented, global working environment, the ability to create and deliver presentations effectively is a necessary skill set for people at all levels of an organization. Regardless of your role, it's important to know how to synthesize your ideas into a coherent and focused narrative, add visuals that support and reinforce your message, and deliver it in a way that resonates with your audience. In this highly interactive course, we will unpack and practice some of the tools and techniques used by top speakers and influencers all over the world. In this engaging two-day course, you will plan, write, refine, practice, and deliver a presentation to the class. Your presentation will be filmed on both days, and you will leave the course with a flash-drive copy of your videos; participants of the virtual classroom workshop should be prepared to present via webcam. In addition to discovering and enhancing your own personal delivery style, you will learn how to create an overarching goal for your presentation and then organize and structure it for maximum impact. You'll gain insight into how to anticipate your audience's needs and tailor the content and delivery in a way that connects with them and sustains their attention and engagement. You will also learn skills that will help you control nervous energy, remain focused on and attuned to your audience, improvise under pressure, deal effectively with questions, and build a compelling call to action. What you will Learn At the end of this program, you will be able to: Construct an effective presentation goal statement, opening, body, and closing that connect with an audience Analyze an audience's needs and style preferences, including relevant DiSC®-related elements Deliver a complete criteria-based presentation that will persuade others Align usage of visuals as well as verbal and non-verbal techniques to maximize the impact of your presentation Getting Started Introductions and social agreements Course structure Course goals and objectives Opening activities Planning and Organizing Video: 'The Art of Misdirection' Setting your presentation goal Writing a goal statement Analyzing your audience Applying the 'reality' test Creating and strengthening supports Structuring your presentation 5 components of an effective opening Presentation body Presentation closing Write your presentation opening Audience Analysis Video: 'How to Tie Your Shoes' Everything DiSC® introduction Audience DiSC® Styles Analyzing your audience Further audience analysis Effective Delivery Delivery challenges and in-person Keeping your audience engaged Your body as your instrument Verbal / paraverbal elements Body stance and nonverbal communication What are your 'tells?' Controlling nervousness Staying attuned to your audience Responding to questions Review and edit your opening Deliver your opening Visuals and Enriching Elements Using images in your presentation Guidelines for visual composition Using questions to engage your audience The power of the pause Practicing and Applying What You've Learned Preparation Delivery Feedback Opportunity to put into practice the program content and receive a video copy Summary and Next Steps What did we learn and how can we implement this in our work environment? Your personal action plan

Intense Pulsed Light or Laser Hair Removal. Hugely popular in the UK, this treatment leads the way in permanent hair removal. Salons around the UK command very good profits from a course of IPL or laser. In the 2000's, women have the opportunity to be hair free and this has led to an increase in the demand for hair free bodies. Certain cultures dictate that women be as hair free as possible and IPL allows for this. There are certain IPL machines in the market that are virtually pain free, making it possible for a woman to have a 'brazilian' or a 'hollywood' treatment. Please enquire if you wish to know more. How Does IPL Work The treatment involves the application of a focused, broad-spectrumlight (xenon), which is applied to the surface of the skin using a hand-held application head. Selective photo-thermolysis involves the process of the light, which travels across and within the range until it reaches the hair shafts or the root of the hair (the bulb). The bulb is usually where the highest concentration of melanin is located. The melanin is what determines our hair/skin colour and once this melanin has been destroyed there can be no growth. The IPL light is changes into heat. This will literally 'blow up' the root of the hair. If a hair has nowhere to grow with no hair bed, it cannot grow! This intense heat also destroys the papilla. IPL treatments will permanently reduce the total number of body hairs but will not result in a permanent removal of all hair and many factors can trigger re-growth such as hormones, menopause, pregnancy and medication. With an IPL treatment, the hair growth cycle has to be in Anagen (the active stage). The hair growth cycle differs on different areas of the body which is why we need to recommend a course! A- Anagen (active stage) C- Catagen (transitionary stage) T- Telagen (resting phase) As the hair growth cycle process can take between 4-6 weeks, this is why we recommend a client to return for their course every 4 weeks. It has the best track record. IPL & Laser has the best overall results (on large areas), versus any other method, in getting rid of hair for longer periods of time if not permanently. All skin types and hair colours can be identified. IPL (intense pulsed light) it does target pigmentation (this determines hair and skin colour), but an ND Yag Laser is not determined by the Fitzpatrick Scale. What is the difference between Laser and IPL Laser and IPL are identified by their wavelength which is usually shown in nanometres (nm). IPL systems are different to a Laser machine as they have a range of emissions. With the AATT Freeze 1 machine the range for hair removal is 640-1200nm (this is a ruby wavelength). For photo-rejuvenation the range is 540-1100nm (this is a green wavelength). The Poly lightbulb emits a range of wavelengths to appear as a flash of white light The Wavelengths are incoherent and travel in all directions with no order between them The High beam spreads out more rapidly than a laser beam The Focus is on a large area which reduces the risk of eye damage compared with coherent sources such as a laser beam. IPL is the abbreviation of Intense Pulsed Light. The machines have been widespread in use since the beginning of the 1990's. The flash lamp is commonly a xenon (huge uses across industry, photographic and medical) What Does The Course Include? When choosing a course ensure that it includes both theory and a wide variety of practical content. Every course should include: Anatomy and Physiology Types & structure of the hair Health & Safety Management Salon Management Client Care Laser & IPL Hair Removal Application Laser and IPL for Photo-rejuvenation Skin, blood and lymphatic circulation Reproductive and endocrine system Theory of Electric Currents Consultations & Record Cards Contra-indications & contra-actions Aftercare advice Accurate techniques Legislation, Hygiene and Sterilisation What is expected of the student to complete a fast track course? Full attendance of the lesson dates A full commitment to work hard Health & Safety Management Salon Management Client Care Successful Laser & IPL Hair Removal Application Successful Laser and IPL for Photo-rejuvenation Completion of a Portfolio Performing Competent Assessments Producing a Written Assignment Home Study and Practice Please see below our list of upcoming courses. Click on the course for further information, request a call or email regarding the course or book now! Course Days Dates Cost VTCT Level 4 IPL & Laser 2 6/04/2024 7/04/2024 £999 VTCT Level 4 IPL & Laser 2 23/05/2024 24/05/2024 £999 VTCT Level 4 IPL & Laser 2 21/06/2024 22/06/2024 £999 VTCT Level 4 IPL & Laser 2 24/07/2024 25/07/2024 £999

About this training course Transmission lines and sub-stations are essential components in the electrical power systems. Proper design and maintenance are crucial for transmission lines to maintain a continuous operation. The objective of this 5-day training course is to deal appropriately with control systems, design characteristics and electric & magnetic fields. Participants will gain a better understanding on the corona and gap discharge phenomena, constructional features, and optimization of the transmission lines. Training Objectives By participating in this course, you will be able to: Understand transmission line design and its application Examine different types of conductors and electrical characteristics Explore basic and general transmission line parameters Prevent overvoltage through insulation design Determine surge impedance and corona effects Calculate and measure electric and magnetic fields Comprehend the impact of audible noise and electromagnetic interference Identify interference within the transmission line systems Target Audience The course will greatly benefit the following groups but not limited to: Electrical Engineers Civil Engineers Transmission & Distribution Engineers Substation Operators Safety Engineers Reliability Engineers Facility & Plant Engineers Technical Engineers Design Engineers Plant Supervisors Electrical Contractors Course Level Basic or Foundation Intermediate Training Methods The training instructor relies on a highly interactive training method to enhance the learning process. This method ensures that all participants gain a complete understanding of all the topics covered. The training environment is highly stimulating, challenging, and effective because the participants will learn by case studies which will allow them to apply the material taught in their own organization. Course Duration: 5 days in total (35 hours). Training Schedule 0830 - Registration 0900 - Start of training 1030 - Morning Break 1045 - Training recommences 1230 - Lunch Break 1330 - Training recommences 1515 - Evening break 1530 - Training recommences 1700 - End of Training The maximum number of participants allowed for this training course is 25. This course is also available through our Virtual Instructor Led Training (VILT) format. Trainer Your expert course leader is a professional engineer with extensive experience in power system studies, substation design field-testing, and EHS programs settings for Mining and Electrical Utilities sectors. He was formally the Engineering Manager at GE Canada in Ontario. He received his M.Sc. in electrical engineering from the University of New Brunswick and his MBA from Laurier School of Business in Waterloo. He has managed and executed more than 150 engineering projects on substation design EMF audits and power system studies and analyses, EMF audits and grounding audits, for major electrical utilities, mines, oil and gas, data centers, industrial and commercial facilities in Canada and the U.S. He is a certified professional engineer in the provinces of Ontario and Alberta. He has various IEEE publications, has served as a technical reviewer for many IEEE journals in power systems and control systems, and is the chair of the Industry Application Chapter (IAS) for IEEE Toronto Section. He remains a very active member for the IEEE substation committee of IEEE Std. 81 ground testing (WGE6) and IEEE Std. 80 ground design (WGD7). A certified electrical safety trainer by GE Corporate and a Canadian Standard Association (CSA) committee member at the mining advisory panel for electrical safety, he also taught many technical courses all over Canada to industrial customers, electrical consultants as well as to electrical utilities customers. Highlighted Projects: Various Power System Studies for 345/230 kV Stations - Nova Scotia Power (EMERA) RF audits for Telecom tower and antennas - Cogeco/Rogers Mobile Power System analysis - Powell Canada Structural/Geotechnical Design and upgrades - Oakville Hydro Underground Cables testing and sizing - Plan Group Relay programming and design optimization - Cenovus Canada Different Arc Flash Analysis and BESS Design - SNC Lavalin Environmental site assessment (ESA) Phase I/II for multiple stations - Ontario Electromagnetic compatibility (EMC) assessment for Toronto LRT expansion - MOSAIC Battery energy storage system (BESS) installation at City of London - Siemens Canada EMF audits for 500 kV Transmission Lines - Hydro One EMF audits for 500 kV Transmission Lines - Hydro Quebec AC interference for 138 kV line modeling and mitigations - HBMS Mine POST TRAINING COACHING SUPPORT (OPTIONAL) To further optimise your learning experience from our courses, we also offer individualized 'One to One' coaching support for 2 hours post training. We can help improve your competence in your chosen area of interest, based on your learning needs and available hours. This is a great opportunity to improve your capability and confidence in a particular area of expertise. It will be delivered over a secure video conference call by one of our senior trainers. They will work with you to create a tailor-made coaching program that will help you achieve your goals faster. Request for further information post training support and fees applicable Accreditions And Affliations

About this training course The smart meter or smart grid represents the next-generation electrical power system. This system uses information, data & communication technology within generation, delivery and consumption of electric energy. This 4-day course will equip you with the innovations that are shaping the power generation and distribution systems and will cover topics ranging from Smart Metering Architecture, Cybersecurity, Smart Grid Systems and Power Line Communications. Training Objectives By participating in this course, you will be able to: Comprehend the Smart Grid and Smart Meters architecture Review latest trends and challenges within the Smart Grid Technology Perform analysis on smart electronic meters Comply with regulatory and metering standards Recognize the importance of cybersecurity in smart grids Maximize efficiency, reliability, and longevity of your smart meters and equipment Gain valuable insights into power quality and harmonics Target Audience This course will greatly benefit the following groups but not limited to: Smart Grid managers and engineers Smart Meters managers and engineers Power plant managers Outage managers Maintenance and operations engineers Power regulatory personnel Transmission managers and engineers Distribution managers and engineers IT managers Renewable energy managers and engineers Course Level Basic or Foundation Intermediate Training Methods The training instructor relies on a highly interactive training method to enhance the learning process. This method ensures that all participants gain a complete understanding of all the topics covered. The training environment is highly stimulating, challenging, and effective because the participants will learn by case studies which will allow them to apply the material taught in their own organization. Course Duration: 4 days in total (28 hours). Training Schedule 0830 - Registration 0900 - Start of training 1030 - Morning Break 1045 - Training recommences 1230 - Lunch Break 1330 - Training recommences 1515 - Evening break 1530 - Training recommences 1700 - End of Training The maximum number of participants allowed for this training course is 25. This course is also available through our Virtual Instructor Led Training (VILT) format. Trainer Your expert course leader is a professional engineer with extensive experience in power system studies, substation design field-testing, and EHS programs settings for Mining and Electrical Utilities sectors. He was formally the Engineering Manager at GE Canada in Ontario. He received his M.Sc. in electrical engineering from the University of New Brunswick and his MBA from Laurier School of Business in Waterloo. He has managed and executed more than 150 engineering projects on substation design EMF audits and power system studies and analyses, EMF audits and grounding audits, for major electrical utilities, mines, oil and gas, data centers, industrial and commercial facilities in Canada and the U.S. He is a certified professional engineer in the provinces of Ontario and Alberta. He has various IEEE publications, has served as a technical reviewer for many IEEE journals in power systems and control systems, and is the chair of the Industry Application Chapter (IAS) for IEEE Toronto Section. He remains a very active member for the IEEE substation committee of IEEE Std. 81 ground testing (WGE6) and IEEE Std. 80 ground design (WGD7). A certified electrical safety trainer by GE Corporate and a Canadian Standard Association (CSA) committee member at the mining advisory panel for electrical safety, he also taught many technical courses all over Canada to industrial customers, electrical consultants as well as to electrical utilities customers. Highlighted Projects: Various Power System Studies for 345/230 kV Stations - Nova Scotia Power (EMERA) RF audits for Telecom tower and antennas - Cogeco/Rogers Mobile Power System analysis - Powell Canada Structural/Geotechnical Design and upgrades - Oakville Hydro Underground Cables testing and sizing - Plan Group Relay programming and design optimization - Cenovus Canada Different Arc Flash Analysis and BESS Design - SNC Lavalin Environmental site assessment (ESA) Phase I/II for multiple stations - Ontario Electromagnetic compatibility (EMC) assessment for Toronto LRT expansion - MOSAIC Battery energy storage system (BESS) installation at City of London - Siemens Canada EMF audits for 500 kV Transmission Lines - Hydro One EMF audits for 500 kV Transmission Lines - Hydro Quebec AC interference for 138 kV line modeling and mitigations - HBMS Mine POST TRAINING COACHING SUPPORT (OPTIONAL) To further optimise your learning experience from our courses, we also offer individualized 'One to One' coaching support for 2 hours post training. We can help improve your competence in your chosen area of interest, based on your learning needs and available hours. This is a great opportunity to improve your capability and confidence in a particular area of expertise. It will be delivered over a secure video conference call by one of our senior trainers. They will work with you to create a tailor-made coaching program that will help you achieve your goals faster. Request for further information post training support and fees applicable Accreditions And Affliations

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

Enhance your expertise in HV/MV power system design and protection coordination with EnergyEdge's virtual instructor-led training. Join now!