The ability to effectively manage conflict is a core competency in the 21st-century workplace.
Health and Safety is paramount in every workplace, ensuring the well-being of employees and preventing accidents. It fosters a secure environment, boosts morale, and enhances productivity. Compliance with health and safety measures not only safeguards individuals but also establishes a culture of responsibility, creating a foundation for a thriving and sustainable work environment. Gaining proficiency in Health and Safety is a key asset for career growth. As a knowledgeable individual in this health and safety field, you become a sought-after candidate for leadership roles, showcasing your commitment to workplace well-being. Your ability to mitigate risks and ensure a safe environment enhances professional credibility, opening doors to advancement and leadership opportunities in your career journey. Health & Safety Course Learning Outcomes: Comprehensive Understanding of Health and Safety Laws at Work. Proficiency in Managing Health and Safety in the Workplace. Competence in Conducting Risk Assessments and Mitigating Common Risks. Adept Handling of Accidents, Ill Health, and Incident Management at Work. Expertise in Electrical, Fire, and Gas Safety Protocols. Mastery of Manual Handling Hazards, Risk Control, and Safe Lifting Techniques. Skills in Implementing Safety Measures for Working at Height and in Confined Spaces. Capability to Identify, Monitor, and Control Hazards Related to Work Equipment and Substances. Level 7 Advanced Diploma in Health & Safety Health and Safety at Work and the Laws Managing for Health and Safety Risk Assessment and Common Risks Accidents and Ill Health at Work Incident Management at Work Electrical, Fire and Gas Safety Measures of Fire Safety Fire Emergency: Evacuation Procedures The Fire Plan and Safety Arrangements Manual Handling Hazards and Injuries Manual Handling Risk Control Safe Lifting Techniques Working at Height Work at Height Equipment Working in Confined Spaces and the Laws Control Measures for Working in Confined Spaces Emergency Procedures for Working in Confined Spaces Safety in Different Work Settings Work Equipment Hazards and Risk Control Other Health and Safety Hazards at Work Basic First-Aid Techniques Dealing with Minor Injuries at the Workplace Call for an Emergency Health Problems Related to Hazardous Substances Identifying Hazardous Substances Control Measures and Monitoring Implementing Control Measures Certificate of Achievement Endorsed Certificate of Achievement from the Quality Licence Scheme Learners will be able to achieve an endorsed certificate after completing the course as proof of their achievement. You can order the endorsed certificate for Free to be delivered to your home by post. For international students, there is an additional postage charge of £10. Endorsement The Quality Licence Scheme (QLS) has endorsed this course for its high-quality, non-regulated provision and training programmes. The QLS is a UK-based organisation that sets standards for non-regulated training and learning. This endorsement means that the course has been reviewed and approved by the QLS and meets the highest quality standards. Who is this course for? Health and Safety Professionals Workplace Managers and Supervisors Occupational Health Specialists Human Resources Personnel Individuals Pursuing a Career in Safety Compliance Construction and Industrial Workers Anyone Concerned with Workplace Well-being Requirements To enrol in this Level 7 Advanced Diploma in Health & Safety course, all you need is a basic understanding of the English Language and an internet connection. Career path Health and Safety Officer: £25,000 to £40,000 per year. Safety Compliance Specialist: £30,000 to £45,000 annually. Occupational Health Manager: £40,000 to £60,000 per year. Health and Safety Consultant: £35,000 to £50,000 annually. Environmental Health and Safety Manager: £45,000 to £70,000 per year. Workplace Safety Trainer: £25,000 to £35,000 annually. Certificates CPD Accredited PDF Certificate Digital certificate - Included QLS Endorsed Hard Copy Certificate Hard copy certificate - Included CPD Accredited Hard Copy Certificate Hard copy certificate - £9.99 CPD Accredited Hard Copy Certificate Delivery Charge: Inside the UK: Free Outside of the UK: £9.99 each
Register on the Emergency Planning Course today and build the experience, skills and knowledge you need to enhance your professional development and work towards your dream job. Study this course through online learning and take the first steps towards a long-term career. The course consists of a number of easy to digest, in-depth modules, designed to provide you with a detailed, expert level of knowledge. Learn through a mixture of instructional video lessons and online study materials. Receive online tutor support as you study the course, to ensure you are supported every step of the way. Get a digital certificate as a proof of your course completion. The Emergency Planning Course is incredibly great value and allows you to study at your own pace. Access the course modules from any internet-enabled device, including computers, tablet, and smartphones. The course is designed to increase your employability and equip you with everything you need to be a success. Enrol on the now and start learning instantly! What You Get With The Emergency Planning Course Receive a e-certificate upon successful completion of the course Get taught by experienced, professional instructors Study at a time and pace that suits your learning style Get instant feedback on assessments 24/7 help and advice via email or live chat Get full tutor support on weekdays (Monday to Friday) Course Design The course is delivered through our online learning platform, accessible through any internet-connected device. There are no formal deadlines or teaching schedules, meaning you are free to study the course at your own pace. You are taught through a combination of Video lessons Online study materials Certification After the successful completion of the final assessment, you will receive a CPD-accredited certificate of achievement. The PDF certificate is for £9.99, and it will be sent to you immediately after through e-mail. You can get the hard copy for £15.99, which will reach your doorsteps by post. Who Is This Course For: The course is ideal for those who already work in this sector or are an aspiring professional. This course is designed to enhance your expertise and boost your CV. Learn key skills and gain a professional qualification to prove your newly-acquired knowledge. Requirements: The online training is open to all students and has no formal entry requirements. To study the Emergency Planning Course, all your need is a passion for learning, a good understanding of English, numeracy, and IT skills. You must also be over the age of 16. Course Content Introduction Introduction FREE 00:03:00 Who are We? 00:04:00 Who is This Course For 00:02:00 Why Have an Emergency Management Plan? 00:06:00 Emergency Planning Committee (EPC) Introduction 00:05:00 Emergency Plan and Procedures Emergency Identification and Analysis 00:06:00 Potential Emergencies for Venues. Let's start with Fire 00:05:00 Internal Threats, Visitors and Bomb Threats 00:09:00 Suspect Items 00:02:00 Active Shooter 00:06:00 Crowd-Related Emergencies 00:09:00 Terrorism 00:07:00 Structure of the Emergency Plan and Emergency Response Procedures 00:02:00 Evacuation Diagram 00:02:00 Distribution of the Emergency Plan and Procedures 00:04:00 Review and Routine Servicing 00:01:00 Key Considerations for our Emergency Response Procedures Introduction and Required Procedures 00:04:00 Notification, Communication, Media, Social Media, Control & Coordination 00:10:00 Children and Emergency Response Equipment 00:04:00 Evacuation Options, Routes & Assembly Areas 00:05:00 First Aid, Lifts & Escalators 00:01:00 Occupants and Visitors with a Disability 00:03:00 Other Considerations 00:06:00 Emergency Control Organisation Emergency Control Organisation 00:04:00 Selection Criteria for ECO Members, Roles, Identification and Indemnity 00:03:00 Who will make a good Chief Warden? 00:06:00 Training and Response Exercises EPC and ECO Training 00:05:00 Occupants, Visitors, Skill Retention & Training Materials 00:04:00 Emergency Response Exercises or 'Drills' 00:08:00 Wrap Up Wrap Up 00:02:00 Frequently Asked Questions Are there any prerequisites for taking the course? There are no specific prerequisites for this course, nor are there any formal entry requirements. All you need is an internet connection, a good understanding of English and a passion for learning for this course. Can I access the course at any time, or is there a set schedule? You have the flexibility to access the course at any time that suits your schedule. Our courses are self-paced, allowing you to study at your own pace and convenience. How long will I have access to the course? For this course, you will have access to the course materials for 1 year only. This means you can review the content as often as you like within the year, even after you've completed the course. However, if you buy Lifetime Access for the course, you will be able to access the course for a lifetime. Is there a certificate of completion provided after completing the course? Yes, upon successfully completing the course, you will receive a certificate of completion. This certificate can be a valuable addition to your professional portfolio and can be shared on your various social networks. Can I switch courses or get a refund if I'm not satisfied with the course? We want you to have a positive learning experience. If you're not satisfied with the course, you can request a course transfer or refund within 14 days of the initial purchase. How do I track my progress in the course? Our platform provides tracking tools and progress indicators for each course. You can monitor your progress, completed lessons, and assessments through your learner dashboard for the course. What if I have technical issues or difficulties with the course? If you encounter technical issues or content-related difficulties with the course, our support team is available to assist you. You can reach out to them for prompt resolution.
*** Don't Spend More; Spend Smart*** Life Just Got Better This Summer! Get Hard Copy + PDF Certificates + Transcript + Student ID Card + e-Learning App as a Gift - Enrol Now Tired of browsing and searching for a Workplace Health and Safety course you are looking for? Can't find the complete package that fulfils all your needs? Then don't worry as you have just found the solution. Take a minute and look through this extensive bundle that has everything you need to succeed. After surveying thousands of learners just like you and considering their valuable feedback, this all-in-one Workplace Health and Safety bundle has been designed by industry experts. We prioritised what learners were looking for in a complete package and developed this in-demand Workplace Health and Safety course that will enhance your skills and prepare you for the competitive job market. Also, our experts are available for answering your queries on Workplace Health and Safety and help you along your learning journey. Advanced audio-visual learning modules of these Workplace Health and Safety courses are broken down into little chunks so that you can learn at your own pace without being overwhelmed by too much material at once. Furthermore, to help you showcase your expertise in Workplace Health and Safety, we have prepared a special gift of 1 hardcopy certificate and 1 PDF certificate for the title course completely free of cost. These certificates will enhance your credibility and encourage possible employers to pick you over the rest. This Bundle Consists of the following Premium courses: Course 01: Workplace Health and Safety Diploma Course 02: Construction Site Management, Supervision and Safety Diploma Course 03: Noise and Hearing Protection Training Course 04: Lone Worker Safety Course Course 05: Electrical and Fire Safety Training - Level 2 Course 06: Ladder Safety Course 07: Manual Handling Level 2 Course 08: Working at Height Awareness Diploma Course 09: DSEAR Training Course 10: COSHH Training and Safety - Level 2 Course 11: Working in Risk Confined Spaces Level 4 Course 12: RIDDOR Training Course 13: Emergency First Aid and Incident Management at Work Course 14: Public Health Benefits you'll get choosing Apex Learning for this Workplace Health and Safety: Pay once and get lifetime access to 14 CPD courses Free e-Learning App for engaging reading materials & helpful assistance Certificates, student ID for the title course included in a one-time fee Free up your time - don't waste time and money travelling for classes Accessible, informative modules designed by expert instructors Learn at your ease - anytime, from anywhere Study the course from your computer, tablet or mobile device CPD accredited course - improve the chance of gaining professional skills Gain valuable knowledge without leaving your home How will I get my Certificate? After successfully completing the Workplace Health and Safety course, you will be able to order your CPD Accredited Certificates (PDF + Hard Copy) as proof of your achievement. PDF Certificate: Free Hard Copy Certificate: Free The bundle incorporates basic to advanced level skills to shed some light on your way and boost your career. Hence, you can strengthen your Workplace Health and Safety expertise and essential knowledge, which will assist you in reaching your goal. Curriculum: Course 01: Workplace Health and Safety Diploma Module 01 : Health & Safety at Work and the Laws Module 02 : Managing for Health & Safety Module 03 : Risk Assessment and Common Risks Module 04 : Workplace Health, Safety and Welfare Module 05 : Accidents and Ill Health at Work Module 06 : Electrical, Fire and Gas Safety Module 07 : Safety in Different Work Settings Module 08 : Work Equipment Hazards and Risk Control Module 09 : Other Health & Safety Hazards at Work Course 02: Construction Site Management, Supervision and Safety Diploma Introduction to Construction Management Project Life Cycle and Success Preliminary Site Investigation & Site Organisation Construction Site Layout Planning and Temporary Facilities Management Site Management Planning & Management of Equipment Construction Materials Management Stock Control Quality Assurance and Customer Care Legal Aspects of Contracting Human Resources Management Risk and Value Management Communications, Information and Documentation of Construction Course 03: Noise and Hearing Protection Training Module 1: The Concept of Noise and Hearing Protection Module 2: Identify, Assess and Control Noise at Workplace Module 3: Health Effects of Loud Noise Module 4: Safe Hearing Module 5: Noise Control Laws and Legislation Module 6: Hearing Conservation at Workplace Course 04: Lone Worker Safety Course Module 01: Basics of Lone Working Module 02: Lone Worker's Safety Laws Module 03: Risk Assessment Module 04: Safe Working System for Lone Working Module 05: Conflict Avoidance and Resolution Module 06: Reporting and Recording Incidents Module 07: Physical and Mental Well-being Module 08: First Aid and Workplace Safety for Lone Workers Course 05: Electrical and Fire Safety Training - Level 2 Module 01: Introduction and Basics Module 02: Introduction to Fire Safety Module 03: Voltage and Resistance Module 04: Capacitance and Capacitors Module 05: Safety Precautions Module 06: Fire Safety Legislation Module 07: Measures of Fire Safety Module 08: Fire Emergency: Evacuation Procedures Course 06: Ladder Safety Module 01: Introduction to Ladder Safety Module 02: Ladder Classifications and Uses Module 03: Pre-use Safety Inspections and Risk Assessment Module 04: Setting Up and Safe Use of Ladders Module 05: Placement Considerations and Securing a Ladder Course 07: Manual Handling Level 2 Introduction, Legislation and Guidance Manual Handling Hazards and Injuries Manual Handling Risk Assessments Controlling and Reducing the Risks Safe Lifting Techniques Course 08: Working at Height Awareness Diploma Module 01 : Introduction, Regulations and Duties Module 02 : Risk Assessment and Prevention Module 03 : Work at Height Equipment Course 09: DSEAR Training Introduction to DSEAR ATEX and Explosive Atmospheres General Safety Safe Working with Flammable Substances Equipment and Protection System Risk Assessment Course 10: COSHH Training and Safety - Level 2 COSHH Explained COSHH Regulations Health Problems Related to Hazardous Substances Identifying Hazardous Substances COSHH Risk Assessments Control Measures and Monitoring Implementing Control Measures Course 11: Working in Risk Confined Spaces Level 4 Module 1: The Law Module 2: Confined Space and the Dangers? Module 3: Safe Procedures Module 4: Communication, Emergencies and Paperwork Course 12: RIDDOR Training Module 1: Health & Safety at Work and the Laws Module 2: Managing for Health & Safety Module 3: Risk Assessment and Common Risks Module 4: RIDDOR Course 13: Emergency First Aid and Incident Management at Work Introduction to Workplace First Aid Legal Framework for Workplace First Aid Incident Management at Work Primary Survey Secondary Survey Basic First-Aid Techniques Dealing with Minor Injuries at the Workplace Secondary Illness Loss of Responsiveness and CPR Secondary Illness Breathing Problems Secondary Illnesses and Injuries Dealing With Fractures and Dislocations Call for an Emergency Course 14: Public Health Module 01: Introduction to Public Health Module 02: Principles of Public Health Module 03: Understanding Epidemiology Module 04: Disease Control Module 05: Understanding Measures of Disease Frequency Module 06: Maternity and Childbirth Module 07: Environment and Public Health Module 08: Health System and Policy Module 09: Public Health and Ethics CPD 140 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Anyone from any background can enrol in this Workplace Health and Safety bundle. Requirements Our Workplace Health and Safety course is fully compatible with PCs, Macs, laptops, tablets and Smartphone devices. Career path Having this Workplace Health and Safety expertise will increase the value of your CV and open you up to multiple job sectors. Certificates Certificate of completion Digital certificate - Included
ICA Specialist Certificate in Money Laundering Risk in Betting and Gaming Whether you work in the betting and gaming industry or have a customer that does, this accessible course will help you get to grips with money laundering risks associated with this sector and how to mitigate them. ICA Specialist Certificates, awarded in association with Alliance Manchester Business School, the University of Manchester, will help you quickly gain actionable knowledge to boost your confidence and credibility. In addition to the essential concepts of AML and CTF, you will also cover the following areas: Essential AML concepts The gambling market- a summary Money laundering risks in gambling Risk based approach, culture & governance AML in operation Market outlook
***24 Hour Limited Time Flash Sale*** Business Law, Stakeholder Management and Corporate Social Responsibility Admission Gifts FREE PDF & Hard Copy Certificate| PDF Transcripts| FREE Student ID| Assessment| Lifetime Access| Enrolment Letter Launch your career into the high-stakes world of "Investment Banking, Financial Analysis, and Corporate Finance" with our comprehensive bundle of courses. This package is a unique blend of three QLS-endorsed courses and five CPD QS accredited courses that are specifically designed to empower you with knowledge and theoretical insights. Dive into a deep understanding of 'Business Law', 'Stakeholder Management', and 'CSR - Corporate Social Responsibility' - all of which come with a hardcopy certificate for their successful completion. These QLS-endorsed courses are a testament to the high-quality education offered and your commitment to your professional journey. But that's not all, to ensure your knowledge is well-rounded and updated, we have included five CPD QS accredited relevant courses. Learn about the societal impact of businesses with 'Social Work Studies' and 'Environmental Health'. Get an introduction to operational efficiency with 'Lean Process and Six Sigma' and 'Process Improvement: How to Reduce Waste'. Lastly, understand the importance of reducing carbon footprint in 'Carbon Literacy Knowledge'. Key Features of the Business Law, Stakeholder Management and Corporate Social Responsibility Bundle: 3 QLS-Endorsed Courses: We proudly offer 3 QLS-endorsed courses within our Business Law, Stakeholder Management and Corporate Social Responsibility bundle, providing you with industry-recognized qualifications. Plus, you'll receive a free hardcopy certificate for each of these courses. QLS Course 01: Business Law QLS Course 02: Stakeholder Management QLS Course 03: CSR - Corporate Social Responsibility 5 CPD QS Accredited Courses: Additionally, our bundle includes 5 relevant CPD QS accredited courses, ensuring that you stay up-to-date with the latest industry standards and practices. Course 01: Social Work Studies Course 02: Environmental Health Course 03: Lean Process and Six Sigma Course 04: Process Improvement: How to Reduce Waste Course 05: Carbon Literacy Knowledge In Addition, you'll get Five Career Boosting Courses absolutely FREE with this Bundle. Course 01: Professional CV Writing Course 02: Job Search Skills Course 03: Self Esteem & Confidence Building Course 04: Professional Diploma in Stress Management Course 05: Complete Communication Skills Master Class Convenient Online Learning: Our Business Law, Stakeholder Management and Corporate Social Responsibility courses are accessible online, allowing you to learn at your own pace and from the comfort of your own home. Learning Outcomes: Acquire foundational knowledge in Investment Banking, Financial Analysis and Corporate Finance. Understand business law and its application in various business scenarios. Learn to manage stakeholders effectively. Gain insights into Corporate Social Responsibility (CSR) and its importance in today's business world. Develop an understanding of social work studies and environmental health. Learn to improve business operations through Lean Process and Six Sigma. Understand how to reduce waste and carbon footprint in businesses. This bundle provides you with an in-depth understanding of the critical aspects of Investment Banking, Financial Analysis, and Corporate Finance. It includes three QLS-endorsed courses in business law, stakeholder management, and CSR, offering a strong foundation for any business or finance professional. The five CPD QS accredited courses expand your knowledge further, incorporating a range of topics from social work studies to environmental health, lean process, waste reduction, and carbon literacy. This package is perfect for anyone seeking theoretical knowledge in the interconnected world of finance, business, and society. CPD 250 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Individuals interested in acquiring theoretical knowledge in Investment Banking, Financial Analysis, and Corporate Finance. Forest Schooling practitioners or educators seeking a deeper understanding of the business world. School administrators planning to incorporate business and finance studies into their curriculum. Anybody interested in learning about stakeholder management, CSR, and business operations. Career path Investment Banker - £70,000 - £100,000 per year. Financial Analyst - £30,000 - £60,000 per year. Corporate Finance Specialist - £40,000 - £80,000 per year. Business Lawyer - £50,000 - £90,000 per year. Stakeholder Manager - £40,000 - £70,000 per year. Corporate Social Responsibility Officer - £30,000 - £50,000 per year. Certificates Digital certificate Digital certificate - Included Hard copy certificate Hard copy certificate - Included
About this Virtual Instructor Led Training (VILT) This 3 half-day Virtual Instructor Led Training (VILT) course highlights the impact of the introduction of renewable energy, digital technologies and new operational flexibility solutions in the electricity trading market. These advancements facilitate unique opportunities and challenges for cross border trading of electricity. Most countries in Asia, have designed their own portfolio of climate actions with an accelerated penetration of renewable energy (or by importing renewable energy into their local grids). These changes are taking place at unprecedented speed and add further complexity to the operation of electricity trading markets, while presenting new opportunities. The Asian market, can tap into its vast potential of solar, wind and geothermal energy sources. A global, unified vision is emerging to support each of countries' energy needs and decarbonization goals. This VILT course will highlight priorities of each country to achieve its energy goals. The main operational flexibilities of each type of renewable resource are discussed in detail. The course also discusses the main components of Power Purchase Agreements and advancements in digitalization and how digital technologies can influence the energy market and cross border electricity trading. Key Takeaways: New Energy Market Design Cross Border Trading PPAs Mechanisms and Examples of PPAs The Increased Penetration of Renewable Resources in the Power Systems and How It Stimulates Cross Border Trading How Digital Innovation Drives Energy Markets and Cross Border Trading Training Objectives Upon completion of this VILT course, participants will be able to: Be familiar with the global vision of One Sun, One World, One Grid Understand the major trends reshaping the energy markets Learn how innovative digital technologies change the energy markets Understand why sustainable energy markets require a tighter coordination between transmission and distribution system operators Engage with each other to design the energy market of the future Target Audience This VILT course will benefit policy makers and regulators from energy agencies, transmission companies and utilities as well as power system engineers and power system operators from control centre and ISO. Training Methods The VILT will be delivered online in 3 half-day sessions comprising 4 hours per day, including time for lectures, discussion, quizzes and short classroom exercises. Course Duration: 3 half-day sessions, 4 hours per session (12 hours in total). Trainer Your expert course leader is a Utility Executive with extensive global experience in power system operation and planning, energy markets, enterprise risk and regulatory oversight. She consults on energy markets integrating renewable resources from planning to operation. She led complex projects in operations and conducted long term planning studies to support planning and operational reliability standards. Specializing in Smart Grids, Operational flexibilities, Renewable generation, Reliability, Financial Engineering, Energy Markets and Power System Integration, she was recently engaged by the Inter-American Development Bank/MHI in Guyana. She was the Operations Expert in the regulatory assessment in Oman. She is a registered member of the Professional Engineers of Ontario, Canada. She is also a contributing member to the IEEE Standards Association, WG Blockchain P2418.5. With over 25 years with Ontario Power Generation (Revenue $1.2 Billion CAD, I/S 16 GW), she served as Canadian representative in CIGRE, committee member in NSERC (Natural Sciences and Engineering Research Council of Canada), and Senior Member IEEE and Elsevier since the 90ties. Our key expert chaired international conferences, lectured on several continents, published a book on Reliability and Security of Nuclear Power Plants, contributed to IEEE and PMAPS and published in the Ontario Journal for Public Policy, Canada. She delivered seminars organized by the Power Engineering Society, IEEE plus seminars to power companies worldwide, including Oman, Thailand, Saudi Arabia, Malaysia, Indonesia, Portugal, South Africa, Japan, Romania, and Guyana. Our Key expert delivered over 60 specialized seminars to executives and engineers from Canada, Europe, South and North America, Middle East, South East Asia and Japan. Few examples are: Modern Power System in Digital Utilities - The Energy Commission, Malaysia and utilities in the Middle East, GCCIA, June 2020 Assessment of OETC Control Centre, Oman, December 2019 Demand Side management, Load Forecasting in a Smart Grid, Oman, 2019 Renewable Resources in a Smart Grid (Malaysia, Thailand, Indonesia, GCCIA, Saudi Arabia) The Modern Power System: Impact of the Power Electronics on the Power System The Digital Utility, AI and Blockchain Smart Grid and Reliability of Distribution Systems, Cyme, Montreal, Canada Economic Dispatch in the context of an Energy Market (TNB, Sarawak Energy, Malaysia) Energy Markets, Risk Assessment and Financial Management, PES, IEEE: Chicago, San Francisco, New York, Portugal, South Africa, Japan. Provided training at CEO and CRO level. Enterprise Risk methodology, EDP, Portugal Energy Markets: Saudi Electricity Company, Tenaga National Berhad, Malaysia Reliability Centre Maintenance (South East Asia, Saudi Electricity Company, KSA) EUSN, ENERGY & UTILITIES SECTOR NETWORK, Government of Canada, 2016 Connected+, IOT, Toronto, Canada September 2016 and 2015 Smart Grid, Smart Home HomeConnect, Toronto, Canada November 2014 Wind Power: a Cautionary Tale, Ontario Centre for Public Policy, 2010 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 about post training coaching support and fees applicable for this. Accreditions And Affliations
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 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 classrom, one to one, tailored and bespoke courses. Tailored 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. 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