• Professional Development
  • Medicine & Nursing
  • Arts & Crafts
  • Health & Wellbeing
  • Personal Development

7586 Power courses

Vehicle Technician Diploma - CPD Accredited

4.5(3)

By Studyhub UK

24 Hour Flash Deal **25-in-1 Vehicle Technician Diploma Mega Bundle** Vehicle Technician Diploma Enrolment Gifts **FREE PDF Certificate**FREE PDF Transcript ** FREE Exam** FREE Student ID ** Lifetime Access **FREE Enrolment Letter ** Take the initial steps toward a successful long-term career by studying the Vehicle Technician Diploma package online with Studyhub through our online learning platform. The Vehicle Technician Diploma bundle can help you improve your CV, wow potential employers, and differentiate yourself from the mass. This Vehicle Technician Diploma course provides complete 360-degree training on Vehicle Technician Diploma. You'll get not one, not two, not three, but twenty-five Vehicle Technician Diploma courses included in this course. Plus Studyhub's signature Forever Access is given as always, meaning these Vehicle Technician Diploma courses are yours for as long as you want them once you enrol in this course This Vehicle Technician Diploma Bundle consists the following career oriented courses: Course 01: Car & Light Vehicle Maintenance Course 02: Motorbike Maintenance and Troubleshooting Training Course 03: Supercharger Automobile Engineering Course 04: Engine Lubrication Systems Online Course Course 05: Electric and Hybrid Vehicles Engineering Course 06: Basic Automotive Engineering: Onboard Diagnostics Course 07: Car Mechanic and Repair Training Course 08: Heating, Ventilation & Air Conditioning (HVAC) Technician Course 09: Power Tools and How to Use Them Course 10: PUWER Course 11: Manual Handling Training Course 12: Electrical Engineering With Electric Circuits Course 13: Trigonometry for Electrical Engineering Course 14: Electrical Components And Circuits - Wiring & Busbars Course 15: Electrical Engineering - Light Current System Course 16: Electrical Machines for Electrical Engineering Course 17: Electronic & Electrical Devices Maintenance & Troubleshooting Course 18: Power Electronics for Electrical Engineering Course 19: Gas Safety Course Course 20: Fire Safety Course 21: Environmental Engineering Course 22: Energy Saving: Electric Motors Course 23: Large Goods Vehicle LGV / HGV Course 24: Bicycle Maintenance Course Course 25: Electric Vehicle Battery Management System The Vehicle Technician Diploma course has been prepared by focusing largely on Vehicle Technician Diploma career readiness. It has been designed by our Vehicle Technician Diploma specialists in a manner that you will be likely to find yourself head and shoulders above the others. For better learning, one to one assistance will also be provided if it's required by any learners. The Vehicle Technician Diploma Bundle is one of the most prestigious training offered at StudyHub and is highly valued by employers for good reason. This Vehicle Technician Diploma bundle course has been created with twenty-five premium courses to provide our learners with the best learning experience possible to increase their understanding of their chosen field. This Vehicle Technician Diploma Course, like every one of Study Hub's courses, is meticulously developed and well researched. Every one of the topics is divided into Vehicle Technician Diploma Elementary modules, allowing our students to grasp each lesson quickly. The Vehicle Technician Diploma course is self-paced and can be taken from the comfort of your home, office, or on the go! With our Student ID card you will get discounts on things like music, food, travel and clothes etc. In this exclusive Vehicle Technician Diploma bundle, you really hit the jackpot. Here's what you get: Step by step Vehicle Technician Diploma lessons One to one assistance from Vehicle Technician Diplomaprofessionals if you need it Innovative exams to test your knowledge after the Vehicle Technician Diplomacourse 24/7 customer support should you encounter any hiccups Top-class learning portal Unlimited lifetime access to all twenty-five Vehicle Technician Diploma courses Digital Certificate, Transcript and student ID are all included in the price PDF certificate immediately after passing Original copies of your Vehicle Technician Diploma certificate and transcript on the next working day Easily learn the Vehicle Technician Diploma skills and knowledge you want from the comfort of your home CPD 250 CPD hours / points Accredited by CPD Quality Standards Who is this course for? This Vehicle Technician Diploma training is suitable for - Students Recent graduates Job Seekers Individuals who are already employed in the relevant sectors and wish to enhance their knowledge and expertise in Vehicle Technician Diploma Requirements To participate in this Vehicle Technician Diploma course, all you need is - A smart device A secure internet connection And a keen interest in Vehicle Technician Diploma Career path You will be able to kickstart your Vehicle Technician Diploma career because this course includes various courses as a bonus. This Vehicle Technician Diploma is an excellent opportunity for you to learn multiple skills from the convenience of your own home and explore Vehicle Technician Diploma career opportunities. Certificates CPD Accredited Certificate Digital certificate - Included CPD Accredited e-Certificate - Free CPD Accredited Hardcopy Certificate - Free Enrolment Letter - Free Student ID Card - Free

Vehicle Technician Diploma - CPD Accredited
Delivered Online On Demand6 days
£279

Automotive Electronics Engineering - CPD Certified

4.5(3)

By Studyhub UK

24 Hour Flash Deal **25-in-1 Automotive Electronics Engineering Mega Bundle** Automotive Electronics Engineering Enrolment Gifts **FREE PDF Certificate**FREE PDF Transcript ** FREE Exam** FREE Student ID ** Lifetime Access **FREE Enrolment Letter ** Take the initial steps toward a successful long-term career by studying the Automotive Electronics Engineering package online with Studyhub through our online learning platform. The Automotive Electronics Engineering bundle can help you improve your CV, wow potential employers, and differentiate yourself from the mass. This Automotive Electronics Engineering course provides complete 360-degree training on Automotive Electronics Engineering. You'll get not one, not two, not three, but twenty-five Automotive Electronics Engineering courses included in this course. Plus Studyhub's signature Forever Access is given as always, meaning these Automotive Electronics Engineering courses are yours for as long as you want them once you enrol in this course This Automotive Electronics Engineering Bundle consists the following career oriented courses: Course 01: Basic Automotive Engineering: Onboard Diagnostics Course 02: Supercharger Automobile Engineering Course 03: Electric and Hybrid Vehicles Engineering Course 04: Car Mechanic and Repair Training Course 05: Car Maintenance and Safety Training Course 06: Motorbike Maintenance & Servicing Course 07: Engine Lubrication Systems Online Course Course 08: Electric Vehicle Battery Management System Course 09: Vehicle Routing Problem with Spreadsheet Course 10: Electrical Engineering With Electric Circuits Course 11: Trigonometry for Electrical Engineering Course 12: Diploma in Electrical Technology Course 13: Electronic Device Maintenance and Troubleshooting Course Course 14: Electrical Components And Circuits - Wiring & Busbars Course 15: Electrical Engineering - Light Current System Course 16: Electrical Machines for Electrical Engineering Course 17: MATLAB Simulink for Electrical Power Engineering Course 18: Power Electronics for Electrical Engineering Course 19: Manual Handling Training Course 20: Domestic Gas Engineer Course 21: Large Goods Vehicle LGV / HGV Course 22: Good Manufacturing Practices (GMP) Certification Course 23: Robotics - Sensors Course 24: Environmental Engineering Course 25: Fire Safety The Automotive Electronics Engineering course has been prepared by focusing largely on Automotive Electronics Engineering career readiness. It has been designed by our Automotive Electronics Engineering specialists in a manner that you will be likely to find yourself head and shoulders above the others. For better learning, one to one assistance will also be provided if it's required by any learners. The Automotive Electronics Engineering Bundle is one of the most prestigious training offered at StudyHub and is highly valued by employers for good reason. This Automotive Electronics Engineering bundle course has been created with twenty-five premium courses to provide our learners with the best learning experience possible to increase their understanding of their chosen field. This Automotive Electronics Engineering Course, like every one of Study Hub's courses, is meticulously developed and well researched. Every one of the topics is divided into Automotive Electronics Engineering Elementary modules, allowing our students to grasp each lesson quickly. The Automotive Electronics Engineering course is self-paced and can be taken from the comfort of your home, office, or on the go! With our Student ID card you will get discounts on things like music, food, travel and clothes etc. In this exclusive Automotive Electronics Engineering bundle, you really hit the jackpot. Here's what you get: Step by step Automotive Electronics Engineering lessons One to one assistance from Automotive Electronics Engineeringprofessionals if you need it Innovative exams to test your knowledge after the Automotive Electronics Engineeringcourse 24/7 customer support should you encounter any hiccups Top-class learning portal Unlimited lifetime access to all twenty-five Automotive Electronics Engineering courses Digital Certificate, Transcript and student ID are all included in the price PDF certificate immediately after passing Original copies of your Automotive Electronics Engineering certificate and transcript on the next working day Easily learn the Automotive Electronics Engineering skills and knowledge you want from the comfort of your home CPD 250 CPD hours / points Accredited by CPD Quality Standards Who is this course for? This Automotive Electronics Engineering training is suitable for - Students Recent graduates Job Seekers Individuals who are already employed in the relevant sectors and wish to enhance their knowledge and expertise in Automotive Electronics Engineering Requirements To participate in this Automotive Electronics Engineering course, all you need is - A smart device A secure internet connection And a keen interest in Automotive Electronics Engineering Career path You will be able to kickstart your Automotive Electronics Engineering career because this course includes various courses as a bonus. This Automotive Electronics Engineering is an excellent opportunity for you to learn multiple skills from the convenience of your own home and explore Automotive Electronics Engineering career opportunities. Certificates CPD Accredited Certificate Digital certificate - Included CPD Accredited e-Certificate - Free CPD Accredited Hardcopy Certificate - Free Enrolment Letter - Free Student ID Card - Free

Automotive Electronics Engineering - CPD Certified
Delivered Online On Demand6 days
£279

Speak with Charisma (public speaking)

5.0(6)

By The Sunflower Effect Confidence Courses

Charisma is a rare quality – we know when we see charisma because we feel compelled to listen to those who have it. There is a magic about them. We notice them as soon as they walk into a room. We are so inspired by what they say that we find ourselves almost as enthusiastic as they are about the thing they are speaking about. They have a way of communicating that brings us alive and makes us feel good.

Speak with Charisma (public speaking)
Delivered In-PersonFlexible Dates
£350

The Ultimate Personal Development Bundle - 4 Courses

By OnlineCoursesLearning.com

This personal development bundle is designed to help you enhance your communication skills, boost your motivation, and foster personal growth. With a focus on fundamental topics such as assertiveness, body language, and positivity, this bundle provides you with the necessary tools to achieve your objectives. By enrolling in these courses, you can experience the transformative power of personal growth and development. The bundle includes below courses: Improving Personal Effectiveness Emotional Intelligence Body Language Communication Basics Through these courses, you can acquire knowledge and practical skills to increase your effectiveness in your personal and professional life. You will learn how to manage your emotions, communicate effectively, and convey confidence through your body language. With these foundational skills, you can make meaningful progress towards your personal and career goals.

The Ultimate Personal Development Bundle - 4 Courses
Delivered Online On Demand
£129

Professional Certificate Course in Social Work Enhancement in London 2024

4.9(261)

By Metropolitan School of Business & Management UK

Embark on a journey of societal change through Sociowork. This course dives deep into the concept of intervention, spanning three levels of methods and traversing the phases of social work practice. Uncover the nuances of addressing privilege, power, and oppression, paving the way for a socially just practice. The course emphasizes evidence-based social work, guiding you to establish practices, explore real-world examples, and overcome barriers to implementation. After the successful completion of this lecture, you will be able to: Understand the concept of intervention in social work and its significance. Identify the three levels of social work intervention methods and their application. Comprehend the phases involved in the social work practice intervention process. Recognize the importance of addressing privilege, power, and oppression in social practice. Appreciate the significance of evidence-based social work and its role in improving practice. Learn how to establish evidence-based practices in the field of social work. Explore real-world examples of evidence-based practice in action. Gain insight into the barriers that can hinder the implementation of evidence-based practices. Develop innovative strategies to advance the field of social work. Delve into the intricacies of social work intervention, understanding its levels and phases. Address societal inequities through a lens of privilege, power, and oppression. Embrace evidence-based practices, learning to establish and implement them effectively. Gain insights from real-world examples and develop innovative strategies to propel the field of social work forward. Unlock the power of social intervention with Sociowork for Social Work Enhancement. From understanding intervention concepts to implementing evidence-based practices, this course empowers you to navigate societal complexities. Real-world examples and innovative strategies provide a holistic perspective, preparing you for impactful roles in various job designations. Course Structure and Assessment Guidelines Watch this video to gain further insight. Navigating the MSBM Study Portal Watch this video to gain further insight. Interacting with Lectures/Learning Components Watch this video to gain further insight. Social Work Practice Enhancement Self-paced pre-recorded learning content on this topic. Social Work Enhancement Put your knowledge to the test with this quiz. Read each question carefully and choose the response that you feel is correct. All MSBM courses are accredited by the relevant partners and awarding bodies. Please refer to MSBM accreditation in about us for more details. There are no strict entry requirements for this course. Work experience will be added advantage to understanding the content of the course. The certificate is designed to enhance the learner's knowledge in the field. This certificate is for everyone eager to know more and get updated on current ideas in their respective field. We recommend this certificate for the following audience. Social Intervention Specialist Practice Enhancement Coordinator Social Equity Advocate Intervention Program Manager Evidence-Based Practice Consultant Sociowork Innovator Social Justice Strategist Practice Improvement Officer Average Completion Time 2 Weeks Accreditation 3 CPD Hours Level Advanced Start Time Anytime 100% Online Study online with ease. Unlimited Access 24/7 unlimited access with pre-recorded lectures. Low Fees Our fees are low and easy to pay online.

Professional Certificate Course in Social Work Enhancement in London 2024
Delivered Online On Demand14 days
£26

Short Circuit Analysis for HV Three Phase Systems

By Compete High

Overview: Are you ready to elevate your expertise in high-voltage three-phase systems? Our comprehensive course, 'Short Circuit Analysis for HV Three Phase Systems,' is designed to empower electrical engineers, power system professionals, and anyone involved in the design and maintenance of high-voltage electrical networks.   Key Benefits: Specialized Knowledge: Gain in-depth insights into short circuit analysis specific to high-voltage three-phase systems. This course is tailored for professionals seeking specialized skills in analyzing and mitigating short circuits in complex electrical networks. Real-world Applications: Dive into practical scenarios and case studies, providing hands-on experience that directly applies to real-world situations. Acquire the skills needed to analyze short circuits in various industrial settings, ensuring you are well-equipped to handle challenges on the job. Cutting-Edge Techniques: Stay ahead of the curve by learning the latest techniques and methodologies in short circuit analysis. Understand how to use advanced software tools to simulate and analyze short circuits, allowing you to make informed decisions in system design and protection. Risk Mitigation: Learn strategies to identify potential risks associated with short circuits in high-voltage systems and implement effective protective measures. Minimize downtime, enhance system reliability, and ensure the safety of personnel and equipment within your electrical network. Expert Instruction: Benefit from the guidance of industry experts with extensive experience in high-voltage systems. Our instructors bring a wealth of knowledge to the table, providing valuable insights and practical tips to enhance your learning experience. Networking Opportunities: Connect with like-minded professionals, fostering valuable networking opportunities. Share experiences, exchange ideas, and build relationships within the industry, enriching your professional network for future collaborations and career advancements. Flexible Learning: Access the course content at your own pace with our online platform. Whether you're a working professional or a student, our flexible schedule allows you to balance your learning with other commitments.   Who Should Enroll: Electrical Engineers Power System Designers Maintenance Professionals Utility Engineers Electrical Consultants Students pursuing electrical engineering   Don't miss this opportunity to enhance your skills and become a go-to expert in Short Circuit Analysis for HV Three Phase Systems. Enroll now and power up your career! Course Curriculum Introduction To Short Circuit Analysis For Hv Three Phase Systems Course Introduction To Short Circuit Analysis For Hv Three Phase Systems Course 00:00 Short Circuit Fault Analysis Overview Short Circuit Fault Analysis Overview Per Phase Analysis Per Phase Analysis 00:00 Per Unit Analysis Per Unit Analysis 00:00 Change Of Base Change Of Base 00:00 Transformers Per Unit Analysis Transformers Per Unit Analysis 00:00 Symmetrical Components Symmetrical Components 00:00 Asymmetrical Three Phase Fault Analysis Asymmetrical Three Phase Fault Analysis 00:00 System Modeling System Modeling 00:00

Short Circuit Analysis for HV Three Phase Systems
Delivered Online On Demand3 hours 50 minutes
£25

Our training course is designed to equip you with the knowledge and skills needed to harness the full potential of LinkedIn.

LinkedIn Mastery
Delivered Online On Demand7 hours
£49

Professional Certificate Course in Concept and Implications of Ethics and Antitrust in Business in London 2024

4.9(261)

By Metropolitan School of Business & Management UK

The aim of this course is to provide an understanding of the intersection of law and ethics, including major ethical perspectives, ethical decision-making models, and the relationship between law and ethics. Students will learn about the importance of setting an ethical tone at the top of an organization and the ethical decision tree for business leaders. The course will cover the short- and long-term returns and the promotion of ethical behavior and social responsibility in the marketplace. Students will also gain knowledge about the history and basic framework of antitrust laws, including horizontal and vertical restraints of trade, price discrimination, and concentrations of market power. The course will also explore antitrust enforcement, antitrust injury, limitations of antitrust enforcement, and antitrust considerations. After the successful completion of the course, you will be able to learn about the following, Law & Ethics: What Is Ethics? Major Ethical Perspectives. An Ethical Decision Model. Relationship b/w law and ethics. Ethical tone sets at the top. Ethical business leader decision tree. Tension b/w short- and long-term returns. Social Responsibility. Positive actions. Promoting ethical Behaviour. Moral of the marketplace. Antitrust: History and Basic Framework of Antitrust Laws. Horizontal Restraints of Trade. Vertical Restraints of Trade. Price Discrimination- The Robinson-Patman Act. Sherman Act, Section 2- Concentrations of Market Power. Acquisitions and Mergers under Section 7 of the Clayton Act. Unfair Methods of competition section 5 of the federal commission act. Antitrust enforcement. Antitrust injury. Limitations of antitrust enforcement. Antitrust considerations. This course aims to explore the intersection of law and ethics, with a particular focus on the major ethical perspectives and an ethical decision-making model. Students will examine the relationship between law and ethics and how ethical tone sets at the top of an organization. The course will cover topics such as the tension between short- and long-term returns, social responsibility, promoting ethical behaviour, and the morale of the marketplace. Additionally, students will learn about antitrust laws, including the history and basic framework of antitrust laws, horizontal and vertical restraints of trade, price discrimination, and concentrations of market power. The course will also cover acquisitions and mergers under Section 7 of the Clayton Act, unfair methods of competition under Section 5 of the Federal Commission Act, antitrust enforcement, antitrust injury, and the limitations of antitrust enforcement. The aim of this course is to provide an understanding of the intersection of law and ethics, including major ethical perspectives, ethical decision-making models, and the relationship between law and ethics. Students will learn about the importance of setting an ethical tone at the top of an organization and the ethical decision tree for business leaders. The course will cover the short- and long-term returns and the promotion of ethical behavior and social responsibility in the marketplace. Students will also gain knowledge about the history and basic framework of antitrust laws, including horizontal and vertical restraints of trade, price discrimination, and concentrations of market power. The course will also explore antitrust enforcement, antitrust injury, limitations of antitrust enforcement, and antitrust considerations. VIDEO - Course Structure and Assessment Guidelines Watch this video to gain further insight. Navigating the MSBM Study Portal Watch this video to gain further insight. Interacting with Lectures/Learning Components Watch this video to gain further insight. Concept and Implications of Ethics and Antitrust in Business Self-paced pre-recorded learning content on this topic. Concept and Implications of Ethics and Antitrust in Business Put your knowledge to the test with this quiz. Read each question carefully and choose the response that you feel is correct. All MSBM courses are accredited by the relevant partners and awarding bodies. Please refer to MSBM accreditation in about us for more details. There are no strict entry requirements for this course. Work experience will be added advantage to understanding the content of the course. The certificate is designed to enhance the learner's knowledge in the field. This certificate is for everyone eager to know more and get updated on current ideas in their respective field. We recommend this certificate for the following audience. Ethics and Compliance Officer Antitrust Attorney Corporate Social Responsibility Manager Business Ethics Consultant Antitrust Investigator Compliance Analyst Risk Management Specialist Business Conduct and Ethics Trainer Antitrust Litigation Specialist Corporate Responsibility Coordinator Average Completion Time 2 Weeks Accreditation 3 CPD Hours Level Advanced Start Time Anytime 100% Online Study online with ease. Unlimited Access 24/7 unlimited access with pre-recorded lectures. Low Fees Our fees are low and easy to pay online.

Professional Certificate Course in Concept and Implications of Ethics and Antitrust in Business in London 2024
Delivered Online On Demand14 days
£42

Microsoft Excel in Depth: Virtual In-House Training

By IIL Europe Ltd

Microsoft Excel® in Depth: Virtual In-House Training The goal of this course is to provide a deeper understanding of Excel and its intricacies and a new ability to use it efficiently producing the best solutions for your projects. This practical course provides a solid background of the features of Excel and a deeper understanding of its features, benefits and uses. This is not a beginner's course in Excel. You will learn some advanced features such as Pivot Tables, Charting, Tables, Sorting, Filtering and Functions. The goal of this course is to provide a deeper understanding of Excel and its intricacies and a new ability to use it efficiently producing the best solutions for your projects. What you Will Learn You'll learn how to: Use functions like IF, AVERAGE, SUMIF, SUMIFS, SUMPRODUCT, INDEX, MATCH, CHOOSE, DATE, and many more Create meaningful charts Use pivot tables Use Conditional Formatting, Data Validation Take advantage of using Named ranges, do sorting, filtering, tables Getting Started The building blocks of Excel, built-in functions, will be examined The basics of formatting your data will be examined Shortcuts and data manipulation will be explored Built-in features like those mentioned in the 'What you will learn' section above will be explored in detail Excel Functions - VLOOKUP, IF, INDEX, MATCH, CHOOSE, SUMIF, SUMIFS, SUMPRODUCT, DATE, so many more Using Named ranges, Data Validation, Sorting, and Filtering Learn the Name manager; Learn the difference between local and global names; Ensure correct access to linked workbooks; Ensure data accuracy; Learn how to use cascading data validation (for example, once a user chooses 'cars', another cell allows only Ford, Toyota, etc.); Sorting by more than 3 fields; Filtering by font, pattern, or value; See your data based on things like dates in the 3rd quarter, or fields where quantity x price is greater than some fixed value Conditional formatting and data formatting Make relevant data stand out Isolate highs and lows Make error cells invisible Learn about Data bars, Icon sets, and Color scales Highlight differences between worksheets Learn all the codes in the Format/Number list Using cell Styles Learn all about alignment, protection, borders, colors and more Pivot Tables Learn how to summarize large amounts of data with a few clicks Learn various ways of presenting the data Learn the various pivot table tools Learn how to customize and format a pivot table to suit your needs Learn how to group data Learn how to use the various options to present your data Charts Learn how to create a chart with one keystroke! Learn the 11 types of built-in charts Learn how to create a chart with one keystroke! Learn how to customize the charts to make the information tell the right story Learn how to use the design, layout, and formatting available to charts in Excel 2007 Learn embedded charts versus chart sheets Learn how to use modify all the pieces of a chart Array formulas Learn how to use the most powerful formulas in Excel Learn how to combine many formulas into one compact array-formula Learn the real power of these formulas and why regular formulas can't do the job Learn how to use built-in array formulas, like TREND or TRANSPOSE

Microsoft Excel in Depth: Virtual In-House Training
Delivered OnlineFlexible Dates
£850

Microsoft Excel in Depth: In-House Training

By IIL Europe Ltd

Microsoft Excel® in Depth: In-House Training The goal of this course is to provide a deeper understanding of Excel and its intricacies and a new ability to use it efficiently producing the best solutions for your projects. This practical course provides a solid background of the features of Excel and a deeper understanding of its features, benefits and uses. This is not a beginner's course in Excel. You will learn some advanced features such as Pivot Tables, Charting, Tables, Sorting, Filtering and Functions. The goal of this course is to provide a deeper understanding of Excel and its intricacies and a new ability to use it efficiently producing the best solutions for your projects. What you Will Learn You'll learn how to: Use functions like IF, AVERAGE, SUMIF, SUMIFS, SUMPRODUCT, INDEX, MATCH, CHOOSE, DATE, and many more Create meaningful charts Use pivot tables Use Conditional Formatting, Data Validation Take advantage of using Named ranges, do sorting, filtering, tables Getting Started The building blocks of Excel, built-in functions, will be examined The basics of formatting your data will be examined Shortcuts and data manipulation will be explored Built-in features like those mentioned in the 'What you will learn' section above will be explored in detail Excel Functions - VLOOKUP, IF, INDEX, MATCH, CHOOSE, SUMIF, SUMIFS, SUMPRODUCT, DATE, so many more Using Named ranges, Data Validation, Sorting, and Filtering Learn the Name manager; Learn the difference between local and global names; Ensure correct access to linked workbooks; Ensure data accuracy; Learn how to use cascading data validation (for example, once a user chooses 'cars', another cell allows only Ford, Toyota, etc.); Sorting by more than 3 fields; Filtering by font, pattern, or value; See your data based on things like dates in the 3rd quarter, or fields where quantity x price is greater than some fixed value Conditional formatting and data formatting Make relevant data stand out Isolate highs and lows Make error cells invisible Learn about Data bars, Icon sets, and Color scales Highlight differences between worksheets Learn all the codes in the Format/Number list Using cell Styles Learn all about alignment, protection, borders, colors and more Pivot Tables Learn how to summarize large amounts of data with a few clicks Learn various ways of presenting the data Learn the various pivot table tools Learn how to customize and format a pivot table to suit your needs Learn how to group data Learn how to use the various options to present your data Charts Learn how to create a chart with one keystroke! Learn the 11 types of built-in charts Learn how to create a chart with one keystroke! Learn how to customize the charts to make the information tell the right story Learn how to use the design, layout, and formatting available to charts in Excel 2007 Learn embedded charts versus chart sheets Learn how to use modify all the pieces of a chart Array formulas Learn how to use the most powerful formulas in Excel Learn how to combine many formulas into one compact array-formula Learn the real power of these formulas and why regular formulas can't do the job Learn how to use built-in array formulas, like TREND or TRANSPOSE

Microsoft Excel in Depth: In-House Training
Delivered in London or UK Wide or OnlineFlexible Dates
£850