6971 Power courses delivered Online

Duration 4 Days 24 CPD hours This course is intended for Candidates should be familiar with Dynamics 365 Customer Insights and have firsthand experience with one or more additional Dynamics 365 apps, Power Query, Microsoft Dataverse, Common Data Model, and Microsoft Power Platform. They should also have working knowledge of practices related to privacy, compliance, consent, security, responsible AI, and data retention policy. Overview After completing this course, you will be able to: Clean, transform, and ingest data into Dynamics 365 Customer Insights Create a unified customer profile Work with Dynamics 365 Audience insights Enrich data and predictions Set up and manage external connections Administer and monitor Customer Insights Customer Data Platform specialists implement solutions that provide insight into customer profiles and that track engagement activities to help improve customer experiences and increase customer retention. In this course, students will learn about the Dynamics 365 Customer Insights solution, including how to unify customer data with prebuilt connectors, predict customer intent with rich segmentation, and maintain control of customer data. This specialty course starts with creating a unified profile and then working with customer data. Module 1: Get started with Dynamics 365 Customer Insights Introduction to the customer data platform Administer Dynamics 365 Customer Insights Explore user permissions in Dynamics 365 Customer Insights Module 2: Ingest data into Dynamics 365 Customer Insights Import and transform data Connect to data sources Work with data Module 3: Create a unified customer profile in Dynamics 365 Customer Insights Map data Match data Merge data Find customers Module 4: Work with Dynamics 365 Customer Insights Explore Audience insights Define relationships and activities Work with measures Work with segments Module 5: Enrich data and predictions with Audience insights Enrich data Use predictions Use machine learning models Module 6: Manage external connections with Customer Data Platform Export Customer Insights data Use Customer Insights with Microsoft Power Platform Display Customer Insights data in Dynamics 365 apps More ways to extend Customer Insights

Gain the skills and credentials to kickstart a successful career and learn from the experts with this step-by-step

Overview This comprehensive course on MATLAB Simulink for Electrical Power Engineering will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This MATLAB Simulink for Electrical Power Engineering comes with accredited certification from CPD, which will enhance your CV and make you worthy in the job market. So enrol in this course today to fast track your career ladder. How will I get my certificate? You may have to take a quiz or a written test online during or after the course. After successfully completing the course, you will be eligible for the certificate. Who is This course for? There is no experience or previous qualifications required for enrolment on this MATLAB Simulink for Electrical Power Engineering. It is available to all students, of all academic backgrounds. Requirements Our MATLAB Simulink for Electrical Power Engineering is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible with tablets and smartphones so you can access your course on Wi-Fi, 3G or 4G. There is no time limit for completing this course, it can be studied in your own time at your own pace. Career Path Having these various qualifications will increase the value in your CV and open you up to multiple sectors such as Business & Management, Admin, Accountancy & Finance, Secretarial & PA, Teaching & Mentoring etc. Course Curriculum 8 sections • 47 lectures • 13:24:00 total length •Module 1- Solving One Non Linear Equation in MATLAB Using Fzero Function: 00:15:00 •Module 2-Example 1 on Solving Multiple Non Linear Equations in MATLAB Using Fsolve Function: 00:15:00 •Module 3- Example 2 on Solving Multiple Non Linear Equations in Matlab Using Fsolve: 00:13:00 •Module 4-Application Multi Level Inverter Part 1: 00:25:00 •Module 5- Application Multi Level Inverter Part 2: 00:05:00 •Module 1-Introduction to MATLAB Simulations Using Simulink: 00:04:00 •Module 2-Half Wave Uncontrolled Rectifier with R Load Principle of Operation: 00:21:00 •Module 3- Half Wave Controlled Rectifier R Load Principle of Operation: 00:05:00 •Module 4-Simulation of Half Wave Controlled Rectifier Using Simulink In Matlab: 00:26:00 •Module 5- Principle of Operation of Fully Controlled Bridge Rectifier Part 1: 00:06:00 •Module 6- Principle of Operation of Fully Controlled Bridge Rectifier Part 2: 00:06:00 •Module 7-Simulation of Bridge Controlled Rectifier: 00:16:00 •Module 8-AC Chopper with R Load Principle of Operation: 00:14:00 •Module 9- Simulation of AC Chopper with R and RL Loads in MATLAB: 00:11:00 •Module 10- Buck Regulator Principle of Operation Part 1: 00:16:00 •Module 11-Buck Regulator Principle of Operation Part 2: 00:17:00 •Module 12-Simulation of Buck Regulator in MATLAB: 00:14:00 •Module 13-Boost Regulator Principle of Operation: 00:23:00 •Module 14- Simulation of Boost Regulator in MATLAB: 00:12:00 •Module 15-Buck-Boost Regulator Principle of Operation: 00:17:00 •Module 16- Simulation of Buck-Boost Regulator: 00:09:00 •Module 17- Single Phase Half Bridge R-Load: 00:15:00 •Module 18- Single Phase Half Bridge RL-Load: 00:08:00 •Module 19-Simulation of Single Phase Half Bridge Inverter: 00:18:00 •Module 20-Single Phase Bridge Inverter R-Load: 00:06:00 •Module 21-Single Phase Bridge Inverter RL-Load: 00:07:00 •Module 22-Simulation of Single Phase Bridge Inverter: 00:10:00 •Module 23-Three Phase Inverters and Obtaining The Line Voltages: 00:15:00 •Module 24-Three Phase Inverters and Obtaining The Phase Voltages: 00:17:00 •Module 25-Simulation of Three Phase Inverter: 00:17:00 •Module 26-Simulation of Charging and Discharging Capacitor Using Matlab: 00:10:00 •Module 1-Separately Excited DC Machine: 00:21:00 •Module 2-DC Motor Modelling without Load Using Simulink in MATLAB: 00:25:00 •Module 3-DC Motor Modelling with Load Using Simulink in MALTAB: 00:23:00 •Module 4-DC Motor Block Simulation Using Power Library in MATLAB: 00:16:00 •Module 1-Construction and Principle of Operation of Synchronous Generator: 00:29:00 •Module 2-Equivalent Circuit and Phasor Diagram of Non Salient Synchronous Machine: 00:29:00 •Module 3-Equivalent Circuit and Phasor Diagram of Salient Synchronous Machine: 00:39:00 •Module 4-Simulation of Synchronous Machine Connected to Small Power System: 00:38:00 •Module 1-Construction and Theory of Operation of Induction Machines: 00:27:00 •Module 2-Equivalent Circuit and Power Flow in Induction Motor: 00:23:00 •Module 3-Torque-Speed Characteristics of Induction Motor: 00:20:00 •Module 4- Simulation of Induction Motor or Asynchronous Motor Using Simulink: 00:33:00 •Module 1- Importing Data from PSCAD Program for Fault Location Detection to MATLAB Program: 00:37:00 •Module 1-How to Implement PID Controller in Simulink of MATLAB: 00:14:00 •Module 2-Tuning a PID Controller In MATLAB Simulink: 00:17:00 •Assignment - MATLAB Simulink for Electrical Power Engineering: 00:00:00

This course will provide electrical engineers and technicians with a thorough understanding of power metering principles and practices. In this course, learners will gain the necessary skills to troubleshoot metering systems and ensure their reliable performance. This Course At A Glance Accredited by CPD UK Understand AC power Know Instrumentation Learn three-phase metering Know cross wattmeter verification Understand power and energy Know instrument transformers Get to know basic metering Know real, reactive and apparent power ( watts, vars, VA) Learn phase and line relationship Understand the energy meter Know electric power Electric Power Metering for Single and Three Phase Systems Course Overview This electric power metering for single and three-phase systems course is beneficial for those who want extensive knowledge of instrument transformers, three-phase metering, and cross wattmeter verification. You will have a clear understanding of AC power, single-phase metering, AC and DC power, and electric power. This online course will educate you on voltage, current, power vectors, capacity and inductive loads, the energy meter, phase and line relationship. You will have extensive knowledge in basic metering, electric power, instrumentation, and single-phase metering by the end of the course. Who should take this course? This electric power metering for single and three phase systems online course is designed for those who want to learn everything about the power and energy measurement of a three-phase system, physics of electric power, digital and analogue wattmeters. Entry Requirements There are no academic entry requirements for this electric power metering for single and three phase systems online course, and it is open to students of all academic backgrounds. However, you are required to have a laptop/desktop/tablet or smartphone and a good internet connection. Assessment Method This electric power metering for single and three phase systems online course assesses learners through multiple-choice questions (MCQs). Upon successful completion of the modules, learners must answer MCQs to complete the assessment procedure. Through the MCQs, it is measured how much a learner can grasp from each section. In the assessment pass mark is 60%. Course Curriculum Introduction Basic Metering Introduction Power & Energy AC Power Instrumentation Single Phase Metering Instrument Transformers Three Phase Metering Cross Wattmeter Verification Assessment Assessment - Electric Power Metering for Single and Three Phase Systems Recognised Accreditation CPD Certification Service This course is accredited by continuing professional development (CPD). CPD UK is globally recognised by employers, professional organisations, and academic institutions, thus a certificate from CPD Certification Service creates value towards your professional goal and achievement. CPD certificates are accepted by thousands of professional bodies and government regulators here in the UK and around the world. Many organisations look for employees with CPD requirements, which means, that by doing this course, you would be a potential candidate in your respective field. Certificate of Achievement Certificate of Achievement from Lead Academy After successfully passing the MCQ exam you will be eligible to order your certificate of achievement as proof of your new skill. The certificate of achievement is an official credential that confirms that you successfully finished a course with Lead Academy. Certificate can be obtained in PDF version at a cost of £12, and there is an additional fee to obtain a printed copy certificate which is £35.   FAQs Is CPD a recognised qualification in the UK? CPD is globally recognised by employers, professional organisations and academic intuitions, thus a certificate from CPD Certification Service creates value towards your professional goal and achievement. CPD-certified certificates are accepted by thousands of professional bodies and government regulators here in the UK and around the world. Are QLS courses recognised? Although QLS courses are not subject to Ofqual regulation, they must adhere to an extremely high level that is set and regulated independently across the globe. A course that has been approved by the Quality Licence Scheme simply indicates that it has been examined and evaluated in terms of quality and fulfils the predetermined quality standards. When will I receive my certificate? For CPD accredited PDF certificate it will take 24 hours, however for the hardcopy CPD certificate takes 5-7 business days and for the Quality License Scheme certificate it will take 7-9 business days. Can I pay by invoice? Yes, you can pay via Invoice or Purchase Order, please contact us at info@lead-academy.org for invoice payment. Can I pay via instalment? Yes, you can pay via instalments at checkout. How to take online classes from home? Our platform provides easy and comfortable access for all learners; all you need is a stable internet connection and a device such as a laptop, desktop PC, tablet, or mobile phone. The learning site is accessible 24/7, allowing you to take the course at your own pace while relaxing in the privacy of your home or workplace. Does age matter in online learning? No, there is no age limit for online learning. Online learning is accessible to people of all ages and requires no age-specific criteria to pursue a course of interest. As opposed to degrees pursued at university, online courses are designed to break the barriers of age limitation that aim to limit the learner's ability to learn new things, diversify their skills, and expand their horizons. When I will get the login details for my course? After successfully purchasing the course, you will receive an email within 24 hours with the login details of your course. Kindly check your inbox, junk or spam folder, or you can contact our client success team via info@lead-academy.org

Humour and shared language have been proven to lead to deliver more effective workplaces, work cultures and entire organisations. But how to use them appropriately, in an ever-changing environment? It can be a minefield! This course provides a powerful punch to your understanding of the strengths and dangers of humour and language – and how they even impact lifespan expectancy.

Power Electronics, Electrical Protection, and LogixPro - Bundle Course Overview Are you looking to begin your power electronics career or want to develop more advanced skills in power electronics? Then this complete power electronics, electrical protection, and LogixPro - online course will set you up with a solid foundation to become a confident electrical engineer and help you to develop your expertise in power electronics. This complete power electronics, electrical protection, and LogixPro - online course is accredited by the CPD UK & IPHM. CPD is globally recognised by employers, professional organisations and academic intuitions, thus a certificate from CPD Certification Service creates value towards your professional goal and achievement. CPD certified certificates are accepted by thousands of professional bodies and government regulators here in the UK and around the world. Whether you are self-taught and you want to fill in the gaps for better efficiency and productivity, this complete power electronics, electrical protection, and LogixPro - online course will set you up with a solid foundation to become a confident electrical engineer and develop more advanced skills. Gain the essential skills and knowledge you need to propel your career forward as a electrical engineer. The complete power electronics, electrical protection, and LogixPro - online course will set you up with the appropriate skills and experience needed for the job and is ideal for both beginners and those currently working as a electrical engineer. This comprehensive complete power electronics, electrical protection, and LogixPro - online course is the perfect way to kickstart your career in the field of power electronics. This complete power electronics, electrical protection, and LogixPro - online course will give you a competitive advantage in your career, making you stand out from all other applicants and employees. If you're interested in working as a electrical engineer or want to learn more skills on power electronics but unsure of where to start, then this complete power electronics, electrical protection, and LogixPro - online course will set you up with a solid foundation to become a confident electrical engineer and develop more advanced skills. As one of the leading course providers and most renowned e-learning specialists online, we're dedicated to giving you the best educational experience possible. This complete power electronics, electrical protection, and LogixPro - online course is crafted by industry expert, to enable you to learn quickly and efficiently, and at your own pace and convenience. Who should take this course? This comprehensive complete power electronics, electrical protection, and LogixPro - online course is suitable for anyone looking to improve their job prospects or aspiring to accelerate their career in this sector and want to gain in-depth knowledge of power electronics. Entry Requirements There are no academic entry requirements for this complete power electronics, electrical protection, and LogixPro - online course, and it is open to students of all academic backgrounds. As long as you are aged seventeen or over and have a basic grasp of English, numeracy and ICT, you will be eligible to enrol. Career path This complete power electronics, electrical protection, and LogixPro - online course opens a brand new door for you to enter the relevant job market and also provides you with the chance to accumulate in-depth knowledge at the side of needed skills to become flourishing in no time. You will also be able to add your new skills to your CV, enhance your career and become more competitive in your chosen industry. Course Curriculum Introduction to Power Electronics Components Introduction to Power Electronics Uncontrolled Switches What Is The Benefit of Diode. Semi-Controlled Switches Part 1 Semi-Controlled Switches Part 2 Semi-Controlled Switches Part 3 What Is The Benefit of Thyristor. Fully Controlled Switches Part 1 Fully Controlled Switches Part 2 Fully Controlled Switches Part 3 Fundamentals of Rectifier Circuits Overview on Rectifiers Rectifier Definition Half Wave Uncontrolled Rectifier With R Load Example on Half Wave Uncontrolled Rectifier with R Load Part 1 Example on Half Wave Uncontrolled Rectifier with R Load Part 2 Half Wave Uncontrolled Rectifier with RL Load Derivation of Current in R-L Load Freewheeling Diode (Commutation Diode) Half-wave R-L Load With FWD Difference between Continuous and Discontinuous Mode in RL Load Half Wave RL Load Continuous Mode with FWD Example on Half Wave Uncontrolled Rectifier with FWD Bridge Full Wave Uncontrolled Rectifier Part 1 Bridge Full Wave Uncontrolled Rectifier Part 2 Quick Revision on Bridge Full-wave Uncontrolled Rectifier Firing Angle Half-Wave Controlled Rectifier R Load Half-Wave Controlled Rectifier R-L Load Half Wave Controlled R-L Load with FWD Example 1 Example 2 Example 3 Example 4 Example 5 Fully Controlled Bridge Rectifier Part 1 Fully Controlled Bridge Rectifier Part 2 Quick Revision on Bridge Full Wave Controlled Rectifier Example 6 Half Controlled Bridge Rectifier Half Controlled Bridge Rectifier with FWD Example 7 Example 8 Performance Parameters Power Factor Fundamentals of AC Choppers Introduction to AC Choppers Definition of AC Chopper Switching Techniques in AC Choppers Applications on AC Choppers Types of AC Choppers AC Chopper with R Load Example 1 on AC Chopper with R Load Example 2 on AC Chopper with R Load AC Chopper with L Load Part 1 AC Chopper with L Load Part 2 Example on AC Chopper with L Load AC Chopper with RL Series Load Example on AC Chopper with RL Series Load AC Chopper with RL Parallel Load Example on AC Chopper with RL Parallel Load AC Chopper with Pure Capacitive Load Example on AC Chopper with Pure Capacitive Load AC Chopper Loaded by Heavy Rectifier AC Chopper Loaded by AC Motor with Sinusoidal Back Emf Example on AC Chopper Loaded by AC Motor with Sinusoidal Back Emf Integral Cycle Control Example on Integral Cycle Control Fundamentals of DC Choppers Introduction to DC Choppers Definition and Applications of DC Choppers Step Down DC Chopper with R Load Example on Step Down DC Chopper with R Load Generation of Duty Cycle Switching Techniques Step Down DC Chopper with RLE Load Part 1 Step Down DC Chopper with RLE Load Part 2 Example 1 on Step Down DC Chopper with RLE Load Example 2 on Step Down DC Chopper with RLE Load Step Up DC Chopper with R or RL Load Step Up DC Chopper with RE Load Example on Step Up DC Chopper with RE Load Buck Regulator Part 1 Buck Regulator Part 2 Example on Buck Regulator Boost Regulator Example on Boost Regulator Buck-Boost Converter Example on Buck-Boost Converter Fundamentals of Inverters Introduction to Inverters Definition of Inverter Importance and Applications of Inverters Single Phase Half Bridge R Load Single Phase Half Bridge RL Load Performance Parameters of Inverter Example on Single Phase Half Bridge Single Phase Bridge Inverter R Load Single Phase Bridge Inverter RL Load Example on Single Phase Bridge Inverter Three Phase Inverters and Obtaining The Line Voltages Three Phase Inverters and Obtaining The Phase Voltages Example on Three Phase Inverters Single Pulse Width Modulation Multiple Pulse Width Modulation Example on Multiple Pulse Width Modulation Sinusoidal Pulse Width Modulation Industrial Inverter Recognised Accreditation CPD Certification Service This course is accredited by continuing professional development (CPD). CPD UK is globally recognised by employers, professional organisations, and academic institutions, thus a certificate from CPD Certification Service creates value towards your professional goal and achievement. CPD certificates are accepted by thousands of professional bodies and government regulators here in the UK and around the world. Many organisations look for employees with CPD requirements, which means, that by doing this course, you would be a potential candidate in your respective field. Certificate of Achievement Certificate of Achievement from Lead Academy After successfully passing the MCQ exam you will be eligible to order your certificate of achievement as proof of your new skill. The certificate of achievement is an official credential that confirms that you successfully finished a course with Lead Academy. Certificate can be obtained in PDF version at a cost of £12, and there is an additional fee to obtain a printed copy certificate which is £35.   FAQs Is CPD a recognised qualification in the UK? CPD is globally recognised by employers, professional organisations and academic intuitions, thus a certificate from CPD Certification Service creates value towards your professional goal and achievement. CPD-certified certificates are accepted by thousands of professional bodies and government regulators here in the UK and around the world. Are QLS courses recognised? Although QLS courses are not subject to Ofqual regulation, they must adhere to an extremely high level that is set and regulated independently across the globe. A course that has been approved by the Quality Licence Scheme simply indicates that it has been examined and evaluated in terms of quality and fulfils the predetermined quality standards. When will I receive my certificate? For CPD accredited PDF certificate it will take 24 hours, however for the hardcopy CPD certificate takes 5-7 business days and for the Quality License Scheme certificate it will take 7-9 business days. Can I pay by invoice? Yes, you can pay via Invoice or Purchase Order, please contact us at info@lead-academy.org for invoice payment. Can I pay via instalment? Yes, you can pay via instalments at checkout. How to take online classes from home? Our platform provides easy and comfortable access for all learners; all you need is a stable internet connection and a device such as a laptop, desktop PC, tablet, or mobile phone. The learning site is accessible 24/7, allowing you to take the course at your own pace while relaxing in the privacy of your home or workplace. Does age matter in online learning? No, there is no age limit for online learning. Online learning is accessible to people of all ages and requires no age-specific criteria to pursue a course of interest. As opposed to degrees pursued at university, online courses are designed to break the barriers of age limitation that aim to limit the learner's ability to learn new things, diversify their skills, and expand their horizons. When I will get the login details for my course? After successfully purchasing the course, you will receive an email within 24 hours with the login details of your course. Kindly check your inbox, junk or spam folder, or you can contact our client success team via info@lead-academy.org

Ascend to the next level of Excel proficiency with our comprehensive Microsoft Excel: Automated Dashboard Using Advanced Formula, VBA, Power Query course. This in-depth training will equip you with the skills to create sophisticated dashboards using advanced Excel formulas, VBA, and Power Query, empowering you to transform raw data into actionable insights. Master the art of financial modeling with our prepaid expenses models, learning how to calculate amortization schedules and create detailed summaries using Excel formulas. Delve into the power of Power Query to effortlessly manipulate and analyze large datasets, building dynamic dashboards without the limitations of formulas. Learning Outcomes Gain proficiency in creating automated dashboards using advanced Excel formulas, VBA, and Power Query Develop expertise in financial modeling using prepaid expenses models Master the calculation of amortization schedules and prepaid expenses summaries Implement Power Query to manipulate and analyze large datasets Create dynamic dashboards without the limitations of formulas Enhance your Excel skills and data analysis capabilities Why choose this Microsoft Excel: Automated Dashboard Using Advanced Formula, VBA, Power Query course? Unlimited access to the course for a lifetime. Opportunity to earn a certificate accredited by the CPD Quality Standards and CIQ after completing this course. Structured lesson planning in line with industry standards. Immerse yourself in innovative and captivating course materials and activities. Assessments designed to evaluate advanced cognitive abilities and skill proficiency. Flexibility to complete the Course at your own pace, on your own schedule. Receive full tutor support throughout the week, from Monday to Friday, to enhance your learning experience. Unlock career resources for CV improvement, interview readiness, and job success. Who is this Microsoft Excel: Automated Dashboard Using Advanced Formula, VBA, Power Query course for? Accounting and finance professionals seeking to enhance their Excel skills for financial modeling and dashboard creation Business analysts and data analysts aiming to expand their expertise in data manipulation and visualization Excel enthusiasts interested in mastering advanced Excel formulas, VBA, and Power Query Individuals seeking to create interactive and insightful dashboards for data-driven decision-making Anyone seeking to elevate their Excel skills and become a proficient data analyst Career path Financial Analyst (£35,000 - £55,000) Business Analyst (£40,000 - £60,000) Data Analyst (£45,000 - £65,000) Management Accountant (£40,000 - £60,000) Business Intelligence Analyst (£45,000 - £65,000) Senior Financial Analyst (£50,000 - £70,000) Prerequisites This Microsoft Excel: Automated Dashboard Using Advanced Formula, VBA, Power Query does not require you to have any prior qualifications or experience. You can just enrol and start learning.This Microsoft Excel: Automated Dashboard Using Advanced Formula, VBA, Power Query was made by professionals and it is compatible with all PC's, Mac's, tablets and smartphones. You will be able to access the course from anywhere at any time as long as you have a good enough internet connection. Certification After studying the course materials, there will be a written assignment test which you can take at the end of the course. After successfully passing the test you will be able to claim the pdf certificate for £4.99 Original Hard Copy certificates need to be ordered at an additional cost of £8. Course Curriculum Introduction Course Outline and Introduction 00:04:00 Minimum Requirements for the Course 00:01:00 Prepayments Introduction 00:01:00 Prepaid Expenses Models: Resources Download Month End Date Prepaid Expenses Amortization Calculation 00:00:00 Exact Prepaid Expenses Payment Date Calculation 00:00:00 Accounting for Prepaid Expenses Prepaid Expenses Accounting Definition: Prepayments 00:03:00 Prepaid Expense Example: How Accounting works for Prepayments 00:03:00 Advantages and Disadvantages of Prepaid Expenses 00:03:00 Excel Formulas Detailed: Introduction to three Excel Models Introduction to PRO Excel Models and Formulas 00:06:00 Date Function 00:05:00 EOMONTH Function 00:04:00 DATEVALUE function 00:03:00 IF Function 00:08:00 IFS Function (Office 365 Only) 00:07:00 VLOOKUP Function 00:07:00 MATCH Function 00:05:00 INDIRECT Function 00:02:00 NAMED Ranges: Name Manager 00:03:00 Advanced Version of VLOOKUP Function 00:07:00 Formula Based Prepaid Expenses Model Introduction to Model and Control Panel Tab (Important Sheet Tab) 00:08:00 Formula Based Prepaid Expenses Model - Deep Dive (Part 1) 00:05:00 Formula Based Prepaid Expenses Model - Deep Dive (Part 2) 00:06:00 Formula Based Prepaid Expenses Model - Deep Dive (Part 3) 00:06:00 IFS Function - Month End date Prepayment calculation 00:04:00 Prepaid Expenses - Closing Balance Summary Tab (Formula Based Summary) 00:09:00 Protecting Formulas Cells and Fields in the Model 00:04:00 Calculate Prepaid Expenses Amortisation from Exact Start Date Exact Date Prepaid Amortisation calculation Intro 00:03:00 Formulas update and Model Changes for Exact Prepaid Exps Calculation 00:03:00 Formulas Update for Exact Date Prepaid Exps Amortisation (Part 1) 00:04:00 Formulas Update for Exact Date Prepaid Exps Amortisation (Part 2) 00:03:00 Formulas Update for Exact Date Prepaid Exps Amortisation (Part 3) 00:02:00 Formulas Update for Exact Date Prepaid Exps Amortisation (Part 4) 00:07:00 IFS Function - Exact Date Prepayments Amortisation 00:04:00 Data Validation Controls (Enhancing Data Input Controls with Protection) 00:10:00 Bonus: Prepayment Model with Opening Balance Calculation (Part 1) 00:08:00 Bonus: Prepayment Model with Opening Balance Calculation (Part 2) 00:09:00 Additional Material: Resources 00:00:00 Prepaid Expenses Summary with Power Query and Pivot Table Power Query and Pivot Table Prepayment Summary Table Intro 00:06:00 What is Power Query and Some Awesome Resources for Power Query learning 00:07:00 Power Query and Pivot Table Summary - Deep Dive (Part 1) 00:05:00 Power Query and Pivot Table Summary - Deep Dive (Part 2) 00:04:00 Power Query and Pivot Table Summary - Deep Dive (Part 3) 00:05:00 Power Query and Pivot Table Summary - Deep Dive (Part 4) 00:09:00 Using Array Formulas to Add Formula Protection 00:04:00 Bonus: Allocate Prepaid Expenditure Cost Centre Wise - 1 00:02:00 Bonus: Allocate Prepaid Expenditure Cost Centre Wise - 2 00:08:00 Bonus: Prepayment Model with Opening Balance Calculation (PQ and PT Version) 00:13:00 Advanced VBA Prepaid Expenses Amortisation Model Changing Macros Security in Excel 00:05:00 Complete Walkthrough - Advanced VBA Prepaid Expenses Amortisation Model 00:06:00 Bonus : New Version - Excel VBA Model for Prepayment Expenditure 00:08:00 BONUS: Dynamic Dashboard for Divisional Profit and Loss statements: Easy Way Dynamic Dashboard Overview 00:07:00 Importing Profit and Loss Statements Source Files and creating YTD P&L Sheets 00:08:00 Creating Dynamic Data Validation 00:02:00 Creating Named Ranges for Dynamic Table Arrays 00:03:00 Dynamic Date Column Headings for each Divisional PL Table 00:02:00 Dynamic Month and YTD Dashboard tables headings (PRO TIP) 00:03:00 Dynamic VLOOKUP Formula - Preparing First section of the Dashboard 00:04:00 Creating Rolling Dashboard with Dynamic VLOOKUP Function 00:08:00 IMPORTANT : Error Checking for your reports/Dashboard (PRO TIP) 00:03:00 Data Prep for Visualization: AREA Charts (Awesome trick using #NA Function) 00:05:00 Visualization: AREA Charts for Month - Revenue, Gross Profit and Net Profit 00:05:00 Visualization DONUT Charts Revenue, Gross Profit and Net Profit (Part 1) 00:03:00 Visualization DONUT Charts Revenue, Gross Profit and Net Profit (Part 2) 00:06:00 Power Query & Pivot Tables based Dashboard without any Formulas, Fully Dynamic Introduction - Formula-less Dashboard - Fully Dynamic and easily refreshed 00:05:00 Understanding the data files before building dashboard 00:02:00 Consolidating Reports with Power Query (Get & Transform) , How to install PQ 00:08:00 Dynamic File Path Trick in Power Query with Parameters (Amazing trick) 00:06:00 Conditional Cumulative totals with SUMIFS Function 00:04:00 Bonus: Conditional Cumulative totals with Power Query Custom Formula (M Code) 00:06:00 Dashboard Creation - Pivot Table showing Month and YTD KPIs division wise 00:06:00 Dashboard Creation Donuts Charts linked with Pivot Table (Replicate Charts fast) 00:08:00 Dashboard Creation - Line Charts 00:08:00 Update Dashboard with Additional Divisional Data with Few Click (Magical) 00:03:00 Thank you Thank you 00:02:00 Ultimate Prepaid Expenditure Model (Super Bonus) 00:02:00 Resources Resources - Microsoft Excel: Automated Dashboard Using Advanced Formula, VBA, Power Query 00:00:00 Assignment Assignment - Microsoft Excel: Automated Dashboard Using Advanced Formula VBA Power Query 00:00:00

UMTS training course description An in-depth study of the UMTS technologies and network structure. What will you learn Explain what 3G and UMTS are. Describe the migration path to UMTS. Describe the UMTS architecture. UMTS training course details Who will benefit: Anyone who needs to know more about UMTS. Prerequisites: Total GSM Duration 3 days UMTS training course contents Introduction 3G WCDMA 2G WCDMA comparison. European and international spectrum allocations. UMTS Services UMTS QoS classes, Conversational, Streaming, Interactive and Background. UMTS bearer services. Radio Access Network (RAN) Architecture System architecture. The Radio Network Controller (RNC) and Node B functionality. Protocol model. The Iu interface for Circuit and Packet switching. The Iur interface and RNSAP. RNC node B interface and NBAP. The Physical layer Spread spectrum coding and modulation. Logical and physical channels. User data rates and transmission. Power control. Signalling, synchronisation, common control, access and indicator channels. Procedures for transmit diversity, measurement, power control and handover. Radio Resource Management Fast and outer loop power control. Transmit power and power rise. Handover algorithms. Intra frequency and inter system handovers. Load, measurement on the air interface. Admission and load control. Packet Access Packet data traffic. Packet data transport channels. Packet scheduling algorithms. Handover, load and administration control. Packet data performance. UTRA TDD Mode Time Division Duplex (TDD). UTRA TDD modulation and spreading, transport channels, physical channels and their structure. Noise and interference limited network. Interference, FDD and TDD co-existence.

About this Course Batteries are going to play an increasingly important role in the energy grid. An increasing number of developers are looking to add battery storage systems (BESS) into their existing projects. However future cash flows are highly uncertain and they are often unsure exactly how battery technology can be monetised. A strong revenue model requires stacking of different revenue sources. As the share of variable renewable sources in electricity systems further increase, battery systems are expected to play a growing role by providing frequency control and operational reserves as well as for wholesale arbitrage, while helping reduce grid integration costs. The more volatile electricity prices are, the greater the earning potential of batteries trading electricity on various electricity markets. BESS can generate revenue streams in several different ways; through a frequency response contract with the TSO, by providing grid services in other ways or by arbitrage through buying cheap power and selling power for a higher price in a liquid wholesale market. Because batteries are efficient, the round trip efficiency is also high. They can spread arbitrage trading much better than other storage types and in many cases, other asset classes. For companies that combine a battery with other tasks, for example to store power from their own panels, or to avoid a costly heavy power connection, the investment is less risky than for those that purely focus on arbitrage trading. It is uncertain whether electricity prices will fluctuate more violently in the coming years, or whether the peaks will actually level off. During this highly interactive training, the trainer will provide you with the latest insights and best practices on how to obtain the maximum economic benefits when participating with BESS in the electricity market. Training Objectives By the end of this course, the participants will be able to: Discover the different BESS battery technologies and their impact on the grid Understand the role of storage in providing flexibility to the power system Examine the potential revenue streams from BESS models Learn how profit can generated with BESS trading strategies Determine how to optimize the value from BESS projects Find out how to combine BESS with renewable PPAs Target Audience Professionals and executives from Power Utilities, Energy Companies, Financial & Investment Banks, Renewable Power Project Developers, Transmission System Operators and Energy Industry Regulators will find this training course useful. Electricity Marketing and Traders New Venture or Business Development Executives Corporate Finance and Treasury Executives Audit and Risk Management Executives Power or Utility Market Research Analysts Investment Managers for Renewable Power Projects Origination Professionals Regulation, Compliance and Documentation Officers Lawyers and Accountants Power Transmission and Distributions Engineers Trainer Our key expert is a skilled and accomplished professional with over 25 years' of extensive senior management / board level experience in the energy markets worldwide. Next to advising energy companies, banks, consultants and regulators regarding PPAs, our key expert has also conducted several highly successful training courses about Power Purchase Agreements, Power Project Finance, IPPs, and Project Risk Management to over 1,000 high level participants from Asia, Africa, Europe and Middle East. He was a member of the expert commission of the Dutch Government for 2 offshore wind parks, Hollandse Kust (zuid) Wind Farm Zone Sites 3 and 4 that advised on which of the 5 applicants did provide the best security and solutions associated with the electricity and green certificate prices, the construction and operational risks of the project. 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 This 5 full-day course provides a comprehensive understanding of all the maintenance, inspection, diagnostics, testing, troubleshooting, refurbishment, and protective systems of all key electrical equipment including: transformers, inverters, rectifiers, switchgear and circuit breakers, relays and protective devices, cables and accessories, motors, variable frequency drives, uninterruptible power systems, generators, fuses, and industrial batteries. It will cover in detail all the inspection methods and tests required to identify faults and deficiencies in electrical equipment, as well as, the repair techniques and available refurbishment methods. The course will also cover the activities required to commission this equipment and it will also cover all protective systems associated with this equipment. The objective of the seminar is to maximize the efficiency, reliability, and longevity of this type of equipment by providing an understanding of the common problems and repair techniques, preventive and predictive maintenance. Training Objectives Electrical Equipment Testing and Maintenance: Gain a thorough understanding of all the testing and maintenance required for all key electrical equipment including transformers, inverters, rectifiers, switchgear and circuit breakers, relays and protective devices, cables and accessories, motors, variable frequency drives, uninterruptible power systems, generators, fuses, and industrial batteries Electrical Equipment Inspection and Diagnostics: Learn about the inspection and diagnostics required for all the components of transformers, inverters, rectifiers, switchgear and circuit breakers, relays and protective devices, cables and accessories, motors, variable frequency drives, uninterruptible power systems, generators, fuses, and industrial batteries Electrical Equipment Troubleshooting: Determine all the troubleshooting activities required to minimize the downtime and operating cost of transformers, inverters, rectifiers, switchgear and circuit breakers, relays and protective devices, cables and accessories, motors, variable frequency drives, uninterruptible power systems, generators, fuses, and industrial batteries Electrical Equipment Online Condition Monitoring: Learn about online condition monitoring of transformers, inverters, rectifiers, switchgear and circuit breakers, relays and protective devices, cables and accessories, motors, variable frequency drives, uninterruptible power systems, generators, fuses, and industrial batteries Electrical Equipment Repair and Refurbishment: Obtain a detailed understanding of the various methods used to repair and refurbish transformers, inverters, rectifiers, switchgear and circuit breakers, relays and protective devices, cables and accessories, motors, variable frequency drives, uninterruptible power systems, generators, fuses, and industrial batteries Efficiency, Reliability, and Longevity: Learn the various methods used to maximize the efficiency, reliability, and longevity of transformers, inverters, rectifiers, switchgear and circuit breakers, relays and protective devices, cables and accessories, motors, variable frequency drives, uninterruptible power systems, generators, fuses, and industrial batteries Rotating Equipment Vibration Analysis and Balancing Methods: Learn about vibration analysis and balancing methods of motors and generators. Electrical Equipment Codes and Standards: Learn all the codes and standards applicable for transformers, inverters, rectifiers, switchgear and circuit breakers, relays and protective devices, cables and accessories, motors, variable frequency drives, uninterruptible power systems, generators, fuses, and industrial batteries Equipment Causes and Modes of Failure: Understand the causes and modes of failure of transformers, inverters, rectifiers, switchgear and circuit breakers, relays and protective devices, cables and accessories, motors, variable frequency drives, uninterruptible power systems, generators, fuses, and industrial batteries Generator Upgrades and Rewinds: Learn the various methods used to upgrade and rewind a generator Protective Systems: Obtain a detailed understanding of all protective systems required for transformers, inverters, rectifiers, switchgear and circuit breakers, relays and protective devices, cables and accessories, motors, variable frequency drives, uninterruptible power systems, generators, fuses, and industrial batteries Target Audience Engineers of all disciplines Managers Technicians Maintenance personnel Other technical individuals (this course is suitable for individuals who do not have an electrical background) Course Level Basic or Foundation Training Methods Your specialist course leader relies on a highly interactive training method to enhance the learning process. This method ensures that all participants gain a complete understanding of all 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 to their own organization. Each delegate will receive a copy of the following materials written by the instructor: The relevant material of the 'ELECTRICAL EQUIPMENT HANDBOOK' published by McGraw-Hill in 2003 (600 pages) Electrical Equipment Maintenance, inspection, diagnostics, testing, troubleshooting, refurbishment, and protective systems Manual (500 pages) Trainer Your specialist course leader has more than 32 years of practical engineering experience with Ontario Power Generation (OPG), one of the largest electric utility in North America. He was previously involved in research on power generation equipment with Atomic Energy of Canada Limited at their Chalk River and Whiteshell Nuclear Research Laboratories. While working at OPG, he acted as a Training Manager, Engineering Supervisor, System Responsible Engineer and Design Engineer. During the period of time, he worked as a Field Engineer and Design Engineer, he was responsible for the operation, maintenance, diagnostics, and testing of gas turbines, steam turbines, generators, motors, transformers, inverters, valves, pumps, compressors, instrumentation and control systems. Further, his responsibilities included designing, engineering, diagnosing equipment problems and recommending solutions to repair deficiencies and improve system performance, supervising engineers, setting up preventive maintenance programs, writing Operating and Design Manuals, and commissioning new equipment. Later, he worked as the manager of a section dedicated to providing training for the staff at the power stations. The training provided by him covered in detail the various equipment and systems used in power stations. In addition, he has taught courses and seminars to more than four thousand working engineers and professionals around the world, specifically Europe and North America. He has been consistently ranked as 'Excellent' or 'Very Good' by the delegates who attended his seminars and lectures. He written 5 books for working engineers from which 3 have been published by McGraw-Hill, New York. Below is a list of the books authored by him; Power Generation Handbook: Gas Turbines, Steam Power Plants, Co-generation, and Combined Cycles, second edition, (800 pages), McGraw-Hill, New York, October 2011. Electrical Equipment Handbook (600 pages), McGraw-Hill, New York, March 2003. Power Plant Equipment Operation and Maintenance Guide (800 pages), McGraw-Hill, New York, January 2012. Industrial Instrumentation and Modern Control Systems (400 pages), Custom Publishing, University of Toronto, University of Toronto Custom Publishing (1999). Industrial Equipment (600 pages), Custom Publishing, University of Toronto, University of Toronto, University of Toronto Custom Publishing (1999). Furthermore, he has received the following awards: The first 'Excellence in Teaching' award offered by PowerEdge, Singapore, in December 2016 The first 'Excellence in Teaching' award offered by the Professional Development Center at University of Toronto (May, 1996). The 'Excellence in Teaching Award' in April 2007 offered by TUV Akademie (TUV Akademie is one of the largest Professional Development centre in world, it is based in Germany and the United Arab Emirates, and provides engineering training to engineers and managers across Europe and the Middle East). Awarded graduation 'With Distinction' from Dalhousie University when completed Bachelor of Engineering degree (1983). Lastly, he was awarded his Bachelor of Engineering Degree 'with distinction' from Dalhousie University, Halifax, Nova Scotia, Canada. He also received a Master of Applied Science in Engineering (M.A.Sc.) from the University of Ottawa, Canada. He is also a member of the Association of Professional Engineers in the province of Ontario, Canada. 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