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

2491 Courses

Daikin Air to Air Training Level one. DUK-SE1 STRM

By H2ecO Daikin Sustainable Home Centre

Daikin Split and multi-split airconditioning DUK - SE1 STRM

Daikin Air to Air Training Level one. DUK-SE1 STRM
Delivered In-PersonJoin Waitlist
£50

Level 4 Certificate in Education & Training Online

By Study Plex

Highlights of the Course Course Type: Self-paced online course Guided Learning Hours: 140 Accreditation: NCFE Qualification: Nationally Recognised Qualification Study Materials: High-Quality E-Learning Study Materials Certificate: Certificate upon passing the official exam Access: Lifetime Access Tutor Support- Personalised feedback on your all assignments Customer Support: 24/7 live chat available What you will learn from this course? Upon successful completion of this Level 4 Certificate in Education and Training, you will be able to: Understand the responsibilities and function of teaching in education and training Possess the capacity to maintain a safe and encouraging learning environment Learn about the relationships between teachers and other training and career professionals. Utilise initial and diagnostic evaluations to work with children to set individualized learning objectives Develop and incorporate inclusive education to meet the needs of the organisation as well as those outside of it. Engage in conversation with students and other learning professionals to promote learning Embrace the basic standards while facilitating inclusive teaching and learning, and learn how to use technology to accomplish inclusive teaching and learning Consider your own performance as you get ready for inclusive teaching and learning Implement a variety of assessment strategies to meet the requirements of different learners, and while grading pupils stick to the fundamentals Utilise your resources while delivering inclusive instruction and evaluation Level 4 Certificate in Education & Training Online This Level 4 Certificate in Education and Training is accredited by NCFE and regulated by Ofqual, making it a nationally recognised credential that will improve your CV and set you apart from the competition. You will gain knowledge about the duties and responsibilities as well as gain skills to evaluate potential learners, develop and implement a variety of teaching and learning strategies, and deliver instruction and training. Towards the end of this course, you'll acquire an extensive range of teaching abilities and expertise you need to establish a successful career in the education sector. Who is this Course for? The following individuals may benefit from this Level 4 Certificate in Education and Training: all types of trainers aspirant teachers teachers of all levels teacher trainers teachers wishing to improve their instructional abilities teachers wishing to enhance their employment prospects Whether you are a complete beginner or an aspiring professional, this course will provide you with the necessary skills and professional competence, and open your doors to a wide number of professions within your chosen sector. Eligibility Requirements This Level 4 Certificate in Education and Training has no academic prerequisites and is open to students from all academic disciplines.  Assessment Procedure Upon successful completion of this Level 4 Certificate in Education and Training, you will be evaluated by a series of assignments that the instructors of the course will internally construct and grade. This strategy will give students more confidence to ace the exam because it precisely represents the content taught in class and fits the teaching methodology being used. Pass" represents the qualification's overall grade Each item included in the qualification framework must be completed by the student For a student to pass a unit, they must demonstrate their understanding of each unit by achieving all of the listed learning outcomes and meeting all of the evaluation criteria Assignment Submission For each portion of the award, you are required to submit a number of short assignments. Assignments should incorporate theory and establish connections to actual workplace or classroom circumstances in order to convey pertinent arguments. These assignments will aid in your exploration and application of the entire teaching and learning cycle. If more work is needed, your instructor will offer feedback and the chance to resubmit assignments. Practical Teaching Assessment The practical assessments require you to provide written documentation of at least three actual classroom teaching sessions of an hour each. This does not include anything done as part of the Level 3 Award in Education and Training that was witnessed. A minimum of thirty minutes must pass between each observation. This witness evidence must be given by a teacher who possesses the necessary qualifications. In extraordinary circumstances, we may also set up a video link with your tutor to finish these observations. The three observations must be related to the following compulsory units: Delivering education and training (M/505/0122) Using resources for education and training (L/505/0127) Assessing learners in education and training (F/505/0125) No previous experience is required to enrol into this course. However, you must complete 30 hours of in-class teaching experience throughout the course of the program to receive your completion certificate. Your practical teaching demonstration will need to be observed by an expert witness who has a level 5 diploma in education and training. For an extra charge of £175 + VAT for 4 hours, if you'd prefer, we can assist you by providing an expert witness.  Advance Your Career This Level 4 Certificate in Education and Training will provide you with significant opportunities to enter the relevant job market and select your desired career path. Additionally, by showcasing these skills on your resume, you will be able to develop your career, face more competitors in your chosen sector, and increase your level of competition. Following the completion of this certification, you may pursue the following credentials:  Assessing Vocationally Related Achievement at Level 3 Assessing Vocational Achievement at the Level 3 Assessing Competence in the Workplace: Level 3 Award Certificate in Education and Training at Level 4 Advanced Practitioner Level 4 Certificate in Schools and Colleges Technology-Enabled Educators Level 4 Award Diploma in Education and Training at Level 5. If you are looking for a Level 3 Award in Education and Training, enrol into our affordable and highly informative course, which will open your door towards a wide range of opportunities within your chosen sector.  This Level 4 Certificate in Education and Training is accredited by NCFE and regulated by Ofqual. The National Council for Educational Awarding (NCFE) is a national educational awarding body that is well-known and respected throughout the world, which will improve your prospects of finding employment and showcase your professional growth. Course Curriculum Course Overview Course Overview - Level 4 Certificate in Education and Training 00:00:00 Sample Useful Documents Observation Recording Requirements 00:15:00 Sample Session Plan Pro-Forma 00:15:00 Sample Portfolio Building Record Sheets 00:15:00 Sample Graded Observation Pro-Forma 00:15:00 Preface Preface 00:18:00 Introduction Introduction 00:25:00 1. Reflecting, evaluating and improving your practice 1. Reflecting, evaluating and improving your practice 00:15:00 2. Professional roles and responsibilities 2. Professional roles and responsibilities 00:15:00 3. You and your learners mental health and emotional well-being 3. You and your learners mental health and emotional well-being 00:18:00 4. Learners and their needs 4. Learners and their needs 00:25:00 5. Assessment practices and processes 5. Assessment practices and processes 00:25:00 6. Communication 6. Communication 00:18:00 7. Inclusive learning environments 7. Inclusive learning environments 00:19:00 8. Planning and Delivery 8. Planning and Delivery 00:15:00 9. Teaching practice and observations 9. Teaching practice and observations 00:17:00 10. Progression routes 10. Progression routes 00:16:00 11. Study skills Glossary of acronyms Glossary of acronyms 00:18:00 Appendix Appendix 00:24:00 Answers to Activities Answers to Activities 00:15:00 Index Index 00:23:00 Assignment - Mandatory Units Assignment 1: Understanding Roles, Responsibilities and Relationships in Education and Training Assignment 1 - Understanding Roles, Responsibilities and Relationships in Education and Training 00:14:00 Assignment 2: Planning to Meet the Needs of Learners in Education and Training Assignment 2 - Planning to Meet the Needs of Learners in Education and Training 00:10:00 Assignment 3: Delivering Education and Training Assignment 3 - Delivering Education and Training 00:15:00 Assignment 4: Assessing Learners in Education and Training Assignment 4 - Assessing Learners in Education and Training 00:14:00 Assignment 5: Using Resources for Education and Training Assignment 5 - Using Resources for Education and Training 00:09:00 Assignment - Optional Units Assignment 6: Working with Individual Learners Assignment 6 - Working with Individual Learners 00:00:00 Feedback Feedback 00:00:00

Level 4 Certificate in Education & Training Online
Delivered Online On Demand
£449

Leading Effective Teams 1 Day Training

By Mangates

This training based on leading teams will help you to develop anyone that leads a team or is involved in a leadership role. It is also useful for those that are about to embark on a position of leadership or need to develop their leadership skills.

Leading Effective Teams 1 Day Training
Delivered In-PersonFlexible Dates
£549

ILM Level 5 Certificate In Leadership And Management

By School of Business and Technology London

Getting Started The ILM Level 5 Certificate in Leadership and Management is designed for practising project managers, department heads, and middle managers, helping them to develop skills and experience, improve performance and prepare for senior management responsibilities. At the Certificate level, the mandatory unit focuses on understanding different leadership styles and adopting the most effective style to motivate staff and achieve organisational goals. Another unit covers using and evaluating action learning for leadership development, planning, and undertaking activities to develop the learner's leadership performance. The benefits of an ILM qualification are endless. The Level 5 management course focuses on the development of an individual's ability to lead, motivate and inspire a team, to provide strategic leadership as well as improve day-to-day operational management, benchmarking their managerial skills and raising their profile within the organisation-making ILM Level 5 one of the best management qualifications to have. The Institute of Leadership and Management (ILM) Level 5 Certificate will build upon and broaden senior managers' skills, giving them the practical techniques to excel as strong and effective leaders. The ILM Level 5 Certificate aims at those with considerable management experience and those looking to take their next career step to higher-ranking leadership positions within an organisation. Studying with ILM delivered by SBTL offers the learner real, practical and transferable skills that can immediately be implemented in the workplace. Key Benefits The Level 5 Certificate in Leadership and Management is designed for practising middle managers, helping them to develop their skills and experience, improve performance and prepare for senior management responsibilities. Benefits for individuals  Understand yourself as a leader  Use feedback and self-review to enhance your leadership skills  Learn solid techniques for planning and implementing complex pieces of work  Put these skills into practice in your workplace  Raise your profile, get results and get a nationally recognised qualification.  Benefits for employers  Short, concise qualification focused on workplace-based activity  Give managers the tools to manage their own professional development  Managers with the self-awareness to lead and the practical skills to deliver results in your organisation. About Awarding Body Institute of Leadership & Management (ILM) is a professional body that helps people worldwide improve their leadership capabilities and advance their careers. All ILM qualifications are awarded by The City and Guilds of London Institute, founded in 1878 and incorporated into the Royal Charter. ILM qualifications are regulated and approved by Ofqual, the governing body for qualifications in the UK. What is included? A dedicated tutor for individual students to help and provide suggestions throughout the course. Providing formative assessment with formative feedback will support the learner to improve their achievements. Our online learning platform will provide all of the assessment materials. Platform independent accessibility of Online learning portal, SBTL delivers the course straight to the student's smartphone, tablet, laptop or desktop, enabling them to study at their convenience. Entry Requirements Must be 19 years of age and over Substantial experience as a manager or supervisor Should possess provable academic ability to complete a level 5 qualification Progression These qualifications will provide progression opportunities to other qualifications including: ILM Level 5 Diploma in Principles of Leadership and Management Learners must request before enrolment to interchange unit(s) other than the preselected units shown in the SBTL website because we need to make sure the availability of learning materials for the requested unit(s). SBTL will reject an application if the learning materials for the requested interchange unit(s) are unavailable. Learners are not allowed to make any request to interchange unit(s) once enrolment is complete. Structure Credit Value: Minimum 13 credits Maximum 36 credits Rules of Combination: Minimum 13 credits, maximum 36 credits Minimum of 7 credits from Group 1 Maximum of 6 credits from Group 2 Unit Code Unit Title Credit Group 1 8607-506 Managing Stress and Conflict in the Organisation 3 8607-511 Managing Projects in the Organisation 4 Group 2 8607-402 Managing Equality and Diversity in Own Area 4 8607-415 Motivating people in the workplace 2 Delivery Methods School of Business & Technology London provides various flexible delivery methods to its learners, including online learning and blended learning. Thus, learners can choose the mode of study as per their choice and convenience. The program is self-paced and accomplished through our cutting-edge Learning Management System. Learners can interact with tutors by messaging through the SBTL Support Desk Portal System to discuss the course materials, get guidance and assistance and request assessment feedbacks on assignments. We at SBTL offer outstanding support and infrastructure for both online and blended learning. We indeed pursue an innovative learning approach where traditional regular classroom-based learning is replaced by web-based learning and incredibly high support level. Learners enrolled at SBTL are allocated a dedicated tutor, whether online or blended learning, who provide learners with comprehensive guidance and support from start to finish. The significant difference between blended learning and online learning methods at SBTL is the Block Delivery of Online Live Sessions. Learners enrolled at SBTL on blended learning are offered a block delivery of online live sessions, which can be booked in advance on their convenience at additional cost. These live sessions are relevant to the learners' program of study and aim to enhance the student's comprehension of research, methodology and other essential study skills. We try to make these live sessions as communicating as possible by providing interactive activities and presentations. Resources and Support School of Business & Technology London is dedicated to offering excellent support on every step of your learning journey. School of Business & Technology London occupies a centralised tutor support desk portal. Our support team liaises with both tutors and learners to provide guidance, assessment feedback, and any other study support adequately and promptly. Once a learner raises a support request through the support desk portal (Be it for guidance, assessment feedback or any additional assistance), one of the support team members assign the relevant to request to an allocated tutor. As soon as the support receives a response from the allocated tutor, it will be made available to the learner in the portal. The support desk system is in place to assist the learners adequately and streamline all the support processes efficiently. Quality learning materials made by industry experts is a significant competitive edge of the School of Business & Technology London. Quality learning materials comprised of structured lecture notes, study guides, practical applications which includes real-world examples, and case studies that will enable you to apply your knowledge. Learning materials are provided in one of the three formats, such as PDF, PowerPoint, or Interactive Text Content on the learning portal. How does the Online Learning work at SBTL? We at SBTL follow a unique approach which differentiates us from other institutions. Indeed, we have taken distance education to a new phase where the support level is incredibly high.Now a days, convenience, flexibility and user-friendliness outweigh demands. Today, the transition from traditional classroom-based learning to online platforms is a significant result of these specifications. In this context, a crucial role played by online learning by leveraging the opportunities for convenience and easier access. It benefits the people who want to enhance their career, life and education in parallel streams. SBTL's simplified online learning facilitates an individual to progress towards the accomplishment of higher career growth without stress and dilemmas. How will you study online? With the School of Business & Technology London, you can study wherever you are. You finish your program with the utmost flexibility. You will be provided with comprehensive tutor support online through SBTL Support Desk portal. How will I get tutor support online? School of Business & Technology London occupies a centralised tutor support desk portal, through which our support team liaise with both tutors and learners to provide guidance, assessment feedback, and any other study support adequately and promptly. Once a learner raises a support request through the support desk portal (Be it for guidance, assessment feedback or any additional assistance), one of the support team members assign the relevant to request to an allocated tutor. As soon as the support receive a response from the allocated tutor, it will be made available to the learner in the portal. The support desk system is in place to assist the learners adequately and to streamline all the support process efficiently. Learners should expect to receive a response on queries like guidance and assistance within 1 - 2 working days. However, if the support request is for assessment feedback, learners will receive the reply with feedback as per the time frame outlined in the Assessment Feedback Policy.

ILM Level 5 Certificate In Leadership And Management
Delivered Online On Demand11 months
£426.44

FORS Safe Driving CPC Course (Driver Periodic Training) Durham

By Total Compliance

#SafeUrbanDriving #Leicester #driver #driver_safety #driver_training #fors #sud

FORS Safe Driving CPC Course (Driver Periodic Training) Durham
Delivered In-PersonFlexible Dates
£122.75

FORS Safe Driving - Periodic 7 Hour CPC Course - Greenwich

By Total Compliance

Safe urban Driving

FORS Safe Driving - Periodic 7 Hour CPC Course - Greenwich
Delivered In-PersonFlexible Dates
£122.75

FORS Safe Driving - Periodic 7 Hour CPC Course - London

By Total Compliance

Safe Urban Driving

FORS Safe Driving - Periodic 7 Hour CPC Course - London
Delivered In-PersonFlexible Dates
£122.75

About this Virtual Instructor Led Training (VILT) This course will provide a comprehensive, foundational content for a wide range of topics in power system operation and control. With the growing importance of grid integration of renewables and the interest in smart grid technologies, it is more important than ever to understand the fundamentals that underpin electrical power systems. This course provides a thorough understanding of all basic terminology and concepts of electrical systems, structure of a power system, transmission line parameters, insulators, high-voltage direct current transmission, substation and neutral grounding, distribution system, circuit breakers, relaying and protection, power system stability, economic operation of power systems, load frequency control, voltage and reactive power control, renewable energy sources, restructuring of electrical power systems, and smart grids. This course is a MUST for practitioners, consultants, engineers of all disciplines, managers, technicians and all technical personnel who need to learn about electrical power systems. Training Objectives Basic Terminology and Concepts of Electrical Systems: Gain an understanding of the basic terminology and concepts of electrical systems and the structure of a power system Transmission Line Parameters: Learn in detail all the transmission line parameters including line resistance, line inductance, transposition of transmission lines, and capacitance of transmission lines Insulators: Understand thoroughly all the various types of insulators, pin type insulators, suspension type or disc insulators, strain insulators, and testing of insulators High-Voltage Direct Current Transmission: Determine the advantages and disadvantages of high voltage direct current transmission, and gain an understanding of all the features of high-voltage direct current transmission Substations and Neutral Grounding: Gain a detailed understanding of all substation equipment, factors governing the layout of substations, station transformers, elements to be earthed in a substation, power system earthing, earthing transformers, bus bar arrangements and gas-insulated substations Distribution System: Learn about the effects of voltage on the conductor volume, distributor fed from one end, distributors fed from both ends at the same voltage, distributors fed from both ends at different voltages, and alternating current distribution Circuit Breakers: Learn about the classification of circuit breakers, plain-break oil circuit breakers, air break circuit breaker, air blast circuit breakers, vacuum circuit breakers, SF6 circuit breakers, rating and testing of circuit breakers Relaying and Protection: Learn all the requirements of relaying, zones of protection, primary and backup protection, classification of relays, electromagnetic relays, induction relays, feeder protection, phase fault protection, reactance relay, static overcurrent relay, differential protection, transformer protection, Buchholz relays, alternator protection restricted earth fault protection, rotor earth fault protection, and negative-sequence protection Economic Operation of Power Systems: Gain an understanding of steam power plants, heat rate characteristics and characteristics of hydro plants Load Frequency Control: Learn about speed governing mechanism, speed governor, steady state speed regulations and adjustment of governor characteristics Voltage and Reactive Power Control: Gain an understanding of impedance and reactive power, system voltage and reactive power, voltage regulation and power transfer Renewable Energy Sources: Learn about solar power, wind power, geothermal energy, biomass and tidal power Restructuring of Electrical Power Systems: Gain an understanding of smart grids, smart grid components, smart grid benefits, and open smart grid protocol Target Audience Engineers of all disciplines Managers Technicians Maintenance personnel Other technical individuals Course Level Basic or Foundation Training Methods The VILT will be delivered online in 5 half-day sessions comprising 4 hours per day, with 2 x 10 minutes break per day, including time for lectures, discussion, quizzes and short classroom exercises. Additionally, some self-study will be requested. Participants are invited but not obliged to bring a short presentation (10 mins max) on a practical problem they encountered in their work. This will then be explained and discussed during the VILT. A short test or quiz will be held at the end the course. The instructor relies on a highly interactive training method to enhance the learning process. This method ensures that all the delegates gain a complete understanding of all the topics covered. The training environment is highly stimulating, challenging, and effective because the participants will learn by case studies which will allow them to apply the material taught to their own organization. Each delegate will receive a copy of the following materials written by the instructor: 'ELECTRICAL EQUIPMENT HANDBOOK' published by McGraw-Hill in 2003 (600 pages) Introduction to Power 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 about post training coaching support and fees applicable for this. Accreditions And Affliations

Introduction to Power Systems
Delivered in Internationally or OnlineFlexible Dates
£1,431 to £2,700

Level 3 Certificate in Assessing Vocational Achievement (RQF) - CAVA (A1)

5.0(37)

By ATC Training Limited

The Level 3 Certificate in Assessing Vocational Achievement (CAVA), formerly known as the A1 certificate is a recognised qualification that is intended for those who assess both occupational competence in the work environment and vocational skills, knowledge and understanding in environments other than the workplace, (such as workshops, classrooms or other education and training settings). If you do not have access to assess in the workplace, consider the Award rather than the certificate. It provides the essential knowledge and understanding that assessment staff need, as well as the opportunity to practice assessment skills – followed by in-depth feedback and development goals from a highly experienced assessor. Learners will achieve 12 credits across 3 units: Understanding the principles and practices of assessment Assess occupational competence in the work environment Assess vocational skills, knowledge and understanding

Level 3 Certificate in Assessing Vocational Achievement (RQF) - CAVA (A1)
Delivered Online On Demand1 hour
£333.33

Microsoft Excel Intermediate (now with live online classes) One-to-One Training

By Microsoft Office Training

Course Objectives The goal of this course is to provide you with the knowledge required to use more advanced functions and formulas and work with various tools to analyse and present data in spreadsheets, such as sorting, filtering, applying conditional formatting and charting the data. ' Customer Feedback Really useful and engaging course. Learnt a lot that will be very beneficial in my job. Trainer was great. Kelly Moreley - TACT Very happy with the course. Worked as a good refresher from what I knew already and enhanced my knowledge further in formulas + vlookup and shortcut keys. Jenny Price - Acer 1 year email support service Take a look at the consistent excellent feedback from our corporate clients visiting our site ms-officetraining co uk With more than 20 years experience, we deliver courses on all levels of the Desktop version of Microsoft Office and Office 365; ranging from Beginner, Intermediate, Advanced to the VBA level. Our trainers are Microsoft certified professionals with a proven track record with several years experience in delivering classroom, 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. Recap on Excel formulas and calculations Overview of formulas in Excel Relative, Absolute and Mixed cell references Group editing worksheets Autofill and Flash Fill Changing Excel’s environment Options Changing the default number of sheets Creating an Autofill Custom List Adding tools to the Quick Access Toolbar Mastering Excel Tables Introducing Excel Tables Formatting a Table Creating Calculated Columns Using Slicers to filter your data Using Totals to get statistics out of your data Removing duplicates Converting Tables back to normal Ranges Using names Ranges In Excel formulas As a way of navigating through the workbook Advanced Formulas Simple IF examples Using IF to check if a cell is blank Nested IFs VLOOKUP HLOOKUP Text Functions Date Functions Conditional formatting Apply Conditional Formatting Customising Conditional Formatting Using Icons in Conditional Formatting Using Formulas to conditionally format cells Linking spreadsheets and workbooks Making a reference to another worksheet Making a reference to another workbook Editing links Troubleshooting links Analysing databases Quick analysis Sorting a database Apply filters to a database Advance filter Sorting and Filtering by Conditional Formats Charts Analyse trends in data using Sparklines Creating charts from start to finish Exploring the different Chart Types Apply Chart Styles Formatting Chart Elements Filtering Charts by Series or Categories Adding a Trendline to a Chart Create a Chart Template Attaching security to a spreadsheet and workbook Protect Cells Protect Structure of worksheets Protect a Workbook by adding passwords Introduction to Pivot Tables What are Pivot Tables? Using recommended pivot tables to analyse your data Who is this course for? Who is this course for? For those who want to explore in more detail formulas and functions, data analysis and data presentation. Requirements Requirements Preferably, delegates would have attended the Excel Introduction course. Career path Career path Excel know-how can instantly increase your job prospects as well as your salary. 80 percent of job openings require spreadsheet and word-processing software skills

Microsoft Excel Intermediate (now with live online classes) One-to-One Training
Delivered In-Person in LondonFlexible Dates
£275