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

19618 Addition courses in London delivered Online

Data Protection Course - BCS Practitioner

5.0(12)

By Duco Digital Training

Do you need a qualification in data protection or are you thinking about learning more about data protection for your organisation? The BCS Practitioner Certificate in Data Protection designed for those with some data protection responsibilities in an organisation and wish to achieve and demonstrate a broad understanding of the law and progresses from what is taught in the BCS Foundation Certificate in Data Protection.

Data Protection Course - BCS Practitioner
Delivered Online On Demand24 hours
£1,650

Primary Tuition - All Subjects - Online

5.0(8)

By GLA Tutors Home or Online

Welcome to GLA Tutors, a pioneering platform for primary school tutoring and SATs preparation.  At GLA Tutors, we understand the importance of a strong foundation in primary school subjects and strive to provide comprehensive support to help children excel in their academic journey. Our team of expert tutors is well-versed in the English National Curriculum, which forms the basis of primary school education in the UK. We have carefully analysed the curriculum requirements to ensure that our tutoring services cover all key subjects and align with the learning objectives set by the curriculum. Our provision for tutoring all primary school subjects encompasses a wide range of subjects, including: 1. English: - Reading comprehension - Vocabulary development - Grammar and punctuation - Writing skills 2. Mathematics: - Number and place value - Addition, subtraction, multiplication, and division - Fractions, decimals, and percentages - Geometry and measurement 3. Science: - Investigating scientific phenomena - Understanding the natural world - Conducting experiments and making observations - Developing scientific thinking and inquiry skills 4. History: - Understanding historical events and timelines - Exploring significant figures and civilizations - Analysing primary and secondary sources - Developing historical knowledge and critical thinking skills 5. Geography: - Studying different landscapes and environments - Investigating human and physical geography - Exploring global issues and sustainability - Developing geographical skills and understanding At GLA Tutors, we understand that preparing children for SATs can be a challenging task. Our tutors are well-versed in the SATs format and content, and they provide targeted support to help children excel in their exams. We cover all areas of the SATs, including English (reading, grammar, and writing) and Mathematics, ensuring that children are well-prepared and confident on exam day. Our tutoring sessions are designed to be engaging and interactive, fostering a love for learning and encouraging children to reach their full potential. We use a variety of teaching techniques, including hands-on activities, visual aids, and interactive resources, to make learning enjoyable and effective. With GLA Tutors, you can be assured that your child will receive top-quality tutoring in all primary school subjects and be well-prepared for SATs. Our tutors are committed to providing personalised support, tailoring their teaching methods to meet the unique learning needs of each child. Join us and let us help your child thrive academically and achieve success in their primary school journey and SATs.

Primary Tuition - All Subjects - Online
Delivered OnlineFlexible Dates
£40

Cyber Security, Ethical Hacking with Linux Security

4.7(47)

By Academy for Health and Fitness

24-Hour Knowledge Knockdown! Prices Reduced Like Never Before Have you ever wondered how secure your online information is? A recent study by the National Cyber Security Centre (NCSC) found that a third of UK businesses identified breaches or attacks in the last year. Are you equipped to protect yourself and your data online? This comprehensive cyber security course bundle equips you with the knowledge and skills to navigate the digital world safely and securely. This Cyber Security bundle offers a well-rounded education in cyber security, from foundational concepts to advanced ethical hacking techniques. You'll gain a strong understanding of cyber threats, network security, and ethical hacking methodologies. Whether you're a complete beginner or an IT professional seeking to upskill, this course bundle provides the knowledge and practical skills to excel in today's ever-evolving digital landscape. Key Features of the Cyber Security, Ethical Hacking with Linux Security Bundle: 3 QLS-Endorsed Courses: We proudly offer 3 QLS-endorsed courses within our Cyber Security, Ethical Hacking with Linux Security bundle, providing you with industry-recognized qualifications. Plus, you'll receive a free hardcopy certificate for each of these courses. QLS Course 01: Cyber Security Awareness Training QLS Course 02: Learn Ethical Hacking From A-Z: Beginner To Expert QLS Course 03: Linux Security and Hardening 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: IT Administration and Networking Course 02: CompTIA Security+ Certification - Complete Video Course Course 03: WordPress Security Mastery Course 04: Cyber Law Online Course Course 05: Computer Networks Security from Scratch to Advanced 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 Cyber Security, Ethical Hacking with Linux Security courses are accessible online, allowing you to learn at your own pace and from the comfort of your own home. Learning Outcomes of Cyber Security, Ethical Hacking with Linux Security Identify and understand common cyber threats and vulnerabilities. Implement essential security measures to protect your data and systems. Master ethical hacking techniques to identify and exploit vulnerabilities. Gain proficiency in Linux security and hardening procedures. Prepare for the CompTIA Security+ certification exam. Understand the legalities surrounding cyber security and online activities. Take control of your online safety and propel your career forward. Upgrade your skillset and become a valuable asset in the ever-evolving cybersecurity landscape. Enrol today! Why Choose Us? Get a Free 3 QLS Endorsed Certificate upon completion of Cyber Security Get a free student ID card with Cyber Security Training program (£10 postal charge will be applicable for international delivery) The Cyber Security is affordable and simple to understand This course is entirely online, interactive lesson with voiceover audio Get Lifetime access to the Cyber Security course materials The Cyber Security comes with 24/7 tutor support Start your learning journey straightaway! *** Course Curriculum *** QLS Course 01: Cyber Security Awareness Training Module 01: Introduction To Cyber Security Module 02: Cyber Attacks Module 03: Cybercrimes Module 04: Cyber Security And Data Breaches Module 05: Staying Safe QLS Course 02: Learn Ethical Hacking From A-Z: Beginner To Expert Course Introduction Networking Basics Setting Up Your Hacking Lab Linux/Python/Bash & PowerShell Basics How To Remain Anonymous On The Web How To Hack Into WIFI Passive & Active Reconnaissance (Information Gathering) Launching Attacks Post Exploitation Website & Web Application Hacking Mobile Phone Hacking & Security Getting Your Name Out There As An Ethical Hacker How To Make Money As An Ethical Hacker How To Start A Career In Cybersecurity QLS Course 03: Linux Security and Hardening Unit 01: Course Overview And Downloads Unit 02: General Security Unit 03: Physical Security Unit 04: Account Security Unit 05: Network Security Unit 06: File System Security Unit 07: Additional Resources =========>>>>> And 10 More Courses <<<<<========= How will I get my Certificate? After successfully completing the course, you will be able to order your QLS Endorsed Certificates and CPD Accredited Certificates as proof of your achievement. PDF Certificate: Free (Previously it was £12.99*11 = £143) QLS Endorsed Hard Copy Certificate: Free (For The 3 QLS Courses: Previously it was £357) CPD 290 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Anyone interested in learning more about the topic is advised to take this bundle. This bundle is ideal for: Beginners in cyber security IT professionals Network administrators Security enthusiasts Requirements You will not need any prior background or expertise to enrol in this bundle. Career path After completing this bundle, you are to start your career or begin the next phase of your career. Cybersecurity Analyst Ethical Hacker Information Security Manager IT Security Consultant Network Security Engineer Penetration Tester Certificates Advanced Diploma in Cyber Security at QLS Level 7 Hard copy certificate - Included Please note that International students have to pay an additional £10 as a shipment fee. Advanced Diploma in Ethical Hacking and IT Security at QLS Level 7 Hard copy certificate - Included Please note that International students have to pay an additional £10 as a shipment fee. CPD Accredited Digital Certificate Digital certificate - Included Upon passing the Course, you need to order a Digital Certificate for each of the courses inside this bundle as proof of your new skills that are accredited by CPD QS for Free.

Cyber Security, Ethical Hacking with Linux Security
Delivered Online On Demand6 days
£209

Learn How to Code: The Complete Core Java Programming Course

By Packt

This course is for you if you have no prior coding experience. It is designed to take you through the core Java concepts with the help of practical examples and coding exercises. A course ideal for testing professionals transitioning to DevOps or Automation.

Learn How to Code: The Complete Core Java Programming Course
Delivered Online On Demand10 hours 20 minutes
£65.99

Microsoft Power BI & Microsoft Excel QLS Endorsed Diploma

By Compliance Central

Recent statistics indicate a soaring demand for proficiency in Microsoft Power BI & Microsoft Excel, reflecting these tools' indispensable role in modern data analytics and business intelligence. With the digital landscape evolving rapidly, organisations seek adept professionals capable of harnessing the power of data for strategic decision-making. Our comprehensive Microsoft Power BI & Microsoft Excel QLS Endorsed Diploma bundle, comprising a range of QLS endorsed and CPD QS accredited courses, is meticulously designed to equip learners with advanced skills in Microsoft Power BI & Microsoft Excel, alongside essential competencies in big data analytics and career development. In today's data-driven world, proficiency in Microsoft Power BI & Microsoft Excel is not merely advantageous but imperative. As businesses strive to extract actionable insights from vast datasets, the demand for skilled professionals proficient in these tools continues to surge. Our Microsoft Power BI & Microsoft Excel bundle offers a holistic approach, combining technical expertise with personal development modules, ensuring learners emerge as well-rounded professionals equipped to thrive in the competitive landscape of data analytics and business intelligence. Bundle Includes: QLS Endorsed Courses: Course 01: Advanced Diploma in Microsoft Power BI at QLS Level 7 Course 02: Advanced Diploma in Microsoft Excel Complete Course 2019 at QLS Level 7 CPD QS Accredited Courses: Course 03: Big Data Analytics with PySpark Power BI and MongoDB Course 04: Big Data Analytics with PySpark Tableau Desktop and MongoDB Course 05: Develop Big Data Pipelines with R, Sparklyr & Power BI Course 06: Microsoft Office 365 Automation Course Course 07: Microsoft Outlook - 25 Must-Know Tips and Tricks Course 08: Microsoft Access - 25 Must-Know Tips and Tricks Course 09: Microsoft Excel - 25 Must-Know Formulas and Functions Course 10: Data Analysis and Forecasting in Excel Take your career to the next level with our Microsoft Power BI & Microsoft Excel bundle that includes technical courses and five guided courses focused on personal development and career growth. Course 11: Career Development Plan Fundamentals Course 12: CV Writing and Job Searching Course 13: Networking Skills for Personal Success Course 14: Ace Your Presentations: Public Speaking Masterclass Course 15: Decision-Making and Critical Thinking Seize this opportunity to elevate your career with our comprehensive Microsoft Power BI & Microsoft Excel bundle, endorsed by the prestigious QLS and accredited by CPD.Microsoft Power BI & Microsoft Excel QLS Endorsed Diploma. Learning Outcomes: Upon completion of this Microsoft Power BI & Microsoft Excel bundle course, participants will: Master advanced techniques in Microsoft Power BI & Microsoft Excel, enabling proficient data analysis and visualization. Develop expertise in big data analytics, leveraging tools like PySpark, Tableau Desktop, and MongoDB for enhanced data processing and interpretation. Acquire essential automation skills through the Microsoft Office 365 Automation Course, streamlining workflow processes and increasing productivity. Enhance communication and presentation abilities through networking, public speaking, and decision-making courses. Gain insights into effective career development strategies, including CV writing, job searching, and professional networking. Apply critical thinking skills to evaluate complex data sets and make informed business decisions. Embark on a transformative journey of skill enhancement with our comprehensive Microsoft Power BI & Microsoft Excel course bundle focusing on Microsoft Power BI & Microsoft Excel. Delve into advanced techniques and methodologies essential for proficient data analysis and visualization. Through a series of meticulously crafted modules, participants will master the intricacies of Power BI, enabling them to transform raw data into actionable insights. From creating interactive dashboards to conducting in-depth data analysis, learners will acquire the proficiency needed to navigate the complexities of modern data analytics with confidence and precision. In addition to honing technical expertise, participants will explore the realm of big data analytics, leveraging powerful tools such as PySpark, Tableau Desktop, and MongoDB. Dive deep into the world of data processing and interpretation, equipping yourself with the skills necessary to tackle large-scale datasets effectively. Through hands-on learning experiences and engaging course content of Microsoft Power BI & Microsoft Excel, individuals will emerge equipped to tackle real-world challenges in data analytics, poised to make meaningful contributions to their organizations' success. CPD 150 CPD hours / points Accredited by CPD Quality Standards Who is this course for? This Microsoft Power BI & Microsoft Excel course is ideal for: Professionals seeking to enhance their proficiency in Microsoft Power BI & Microsoft Excel. Individuals aspiring to pursue careers in data analytics and business intelligence. Students and recent graduates looking to bolster their skill set for employment opportunities. Entrepreneurs aiming to leverage data-driven insights for business growth. Professionals seeking to advance their career prospects through enhanced communication and presentation skills. Individuals keen on developing a strategic approach to career development and networking. Requirements You are warmly invited to register for this bundle. Please be aware that no formal entry requirements or qualifications are necessary. This curriculum has been crafted to be open to everyone, regardless of previous experience or educational attainment. Career path Upon completion of this Microsoft Power BI & Microsoft Excel bundle course, participants can pursue diverse career paths, including: Data Analyst Business Intelligence Analyst Data Scientist Financial Analyst Business Consultant Project Manager IT Manager Certificates 13 CPD Quality Standard Certificates Digital certificate - Included 2 QLS Endorsed Certificates Hard copy certificate - Included

Microsoft Power BI & Microsoft Excel QLS Endorsed Diploma
Delivered Online On Demand3 days
£210

English Language (Grammar, Functional Skills & Leadership) - QLS Endorsed

4.8(59)

By Academy for Health and Fitness

Enhance your English skills with expert training in grammar, functional communication, and leadership. Earn a QLS-endorsed certificate and boost your career today!

English Language (Grammar, Functional Skills & Leadership) - QLS Endorsed
Delivered Online On Demand3 days
£249

Advanced Professional Certificate in International Financial Crimes

4.9(261)

By Metropolitan School of Business & Management UK

Advanced Professional Certificate Courses These are short online certificate courses of a more advanced nature designed to help you develop professionally and achieve your career goals, while you earn a professional certificate which qualifies you for the appropriate continuous professional development (CPD). Advanced Professional Certificate in International Financial Crimes This Advanced professional certificate course explores the concept and evolution of financial crimes, including fraud, corruption, and money laundering principal and secondary offences. The course provides insight into relevant cases involving financial crimes, focusing on the regulatory landscape of insider dealing and market abuse. The course presents an in-depth and detailed analysis of white-collar crimes' concepts, characteristics, and effects and reflects on various white-collar crimes' civil remedies. In addition, the course explains the concept and evolution of money laundering and Identifies the three stages of money laundering, all while explaining the aim and techniques of each stage. The course provides insight into different methods used in money laundering, including trade schemes, insurance policies, and cryptocurrencies. Also, the course presents an analysis of the impact of money laundering on economic growth and financial stability. Finally, the course is designed to cover the framework of international cooperation in the fight against financial crimes. The course provides insight into various international platforms involved in this global effort, including the European Union, the United Nations, and the FATF. From this perspective, the course covers multiple topics, including market abuse and market manipulation, corruption, and money laundering. Also, the course presents an analysis of various global financial crime risk management challenges. Course Details After the successful completion of this lecture, you will be able to; Understand the concept of financial crimes. Understand the concept and the regulatory landscape of corporate fraud. Understand the concept and the regulatory landscape of bribery and corruption. Reflect on various cases involving financial crimes. Understand the concept and the regulatory landscape of insider dealing and market abuse. Reflect on money Laundering Principal offences. Understand the concept, characteristics, and effects of white-collar crimes. Reflect on various white-collar crimes civil remedies. Understand the concept and evolution of money laundering. Identify the three stages of money laundering. Understand different methods used in money laundering. Measure the impact of money laundering on economic growth. Understand the framework of international cooperation in the fight against financial crimes. Understand the European Union anti-money laundering regulatory landscape. Understand the United Nations anti-money laundering regulatory landscape. Reflect on the EU market abuse regulation. Understand the intergovernmental anti-money laundering regulatory landscape. Reflect on various global financial crime risk management challenges. Accreditation The content of this course has been independently certified as conforming to universally accepted Continuous Professional Development (CPD) guidelines. Entry Requirements 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 gets updated on current ideas in their respective field. We recommend this certificate for the following audience. Legal advisors. Compliance specialists Compliance officers Financial advisors and managers Banking professionals Accountants Real estate agents Insurance professionals Legal advisors. Law practitioners. Contract specialists. Legal officers. Contract managers. Business developers. Law lecturers. Business lecturers. Legal and business researchers.

Advanced Professional Certificate in International Financial Crimes
Delivered Online On Demand
£120

Level 3 Office Management QLS Endorsed

4.7(47)

By Academy for Health and Fitness

24 Hours Left! Don't Let Year-End Deals Slip Away - Enrol Now! Do you feel like you're constantly struggling to keep up with the demands of your office job? Are you tired of feeling unorganised and overwhelmed? Our Office Management Training course can help! With 11 comprehensive courses, you'll learn how to manage your time, communicate effectively, and become a more efficient and effective employee. The first course is QLS-endorsed, and you'll receive a QLS hardcopy certificate for free upon completion. This certificate is a valuable addition to your CV, showing potential employers that you have taken the time to develop your skills and knowledge. The remaining ten courses are all CPD-QS accredited, ensuring that you receive high-quality training that is relevant to your career. You'll learn how to take minutes, manage meetings, plan strategically, improve your organisational skills, and more. These skills are in high demand in today's job market, making this course a valuable investment in your career. Don't let your office job hold you back any longer. Enrol in our Office Management Training course today and learn how to take control of your work life. This Office Management Training Bundle Package includes: Course 01: Certificate in Office Management at QLS Level 3 10 Premium Additional CPD QS Accredited Courses - Course 01: Executive and Personal Assistant Training Course Course 02: Minute Taking Course 03: Diploma in Meeting Management Course 04: Strategic Planning Process Course 05: Organisational Skills Course for Administrator Course 06: Leadership Skills Course Course 07: Negotiation Skills Certificate Course 08: The Secrets of Body Language Course 09: Communication Skills Masterclass Course 10: Document Control Why Prefer This Office Management Training Bundle? You will receive a completely free certificate from the Quality Licence Scheme Option to purchase 10 additional certificates accredited by CPD Get a free Student ID Card - (£10 postal charges will be applicable for international delivery) Free assessments and immediate success results 24/7 Tutor Support After taking this Office Management Training bundle courses, you will be able to learn: Develop your organisational skills and improve your time management abilities Understand the strategic planning process and learn how to implement it effectively Master the art of communication, including body language and negotiation skills Learn how to take accurate meeting minutes and manage meetings with ease Understand the importance of document control and how to implement it in your workplace Develop your leadership skills and become a more effective team member Improve your job prospects with valuable skills that are in high demand ***Curriculum breakdown of Office Management*** Personal Assistant Admin Support Organisational Skills Telephone Etiquette Business Writing Time Management Body Language and Effective Communication Meeting Management How is the Office Management Training Bundle Assessment Process? You have to complete the assignment questions given at the end of the course and score a minimum of 60% to pass each exam. Our expert trainers will assess your assignment and give you feedback after you submit the assignment. You will be entitled to claim a certificate endorsed by the Quality Licence Scheme after you successfully pass the exams CPD 220 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Our Office Management Training course is perfect for anyone who wants to improve their skills and become a more effective employee. It's ideal for: Administrative assistants and office managers Personal assistants and executive assistants Anyone who wants to improve their organisational and communication skills Career path This bundle will give you an edge in various professions, such as: Office Manager - £30,000 to £45,000 per year Executive Assistant - £25,000 to £45,000 per year Personal Assistant - £20,000 to £35,000 per year Meeting Planner - £25,000 to £40,000 per year Document Controller - £25,000 to £35,000 per year Communication Specialist - £30,000 to £50,000 per year Certificates Certificate in Office Management at QLS Level 3 Hard copy certificate - Included CPD QS Accredited Certificate Digital certificate - Included Upon successfully completing the Bundle, you will need to place an order to receive a PDF Certificate for each course within the bundle. These certificates serve as proof of your newly acquired skills, accredited by CPD QS. Also, the certificates are recognised throughout the UK and internationally. CPD QS Accredited Certificate Hard copy certificate - Included International students are subject to a £10 delivery fee for their orders, based on their location.

Level 3 Office Management QLS Endorsed
Delivered Online On Demand7 days
£119

Financial Statement Analysis Masterclass

4.3(43)

By John Academy

Course overview Financial analysis is a crucial part of a successful business. It helps companies to make informed decisions regarding investing. Learn how to make a practical analysis of financial statements with this Financial Statement Analysis Masterclass program.  This Financial Statement Analysis Masterclass course explains the steps involved in a practical financial statement analysis in detail. It will also educate you on the importance of financial accounting in businesses. Going through the lesson, you will develop a comprehensive understanding of GAAP rules, correct timing, earnings management and financial valuation. In addition, you will understand the importance and purpose of executive compensation and identify its major components. You will also learn how to prepare and analyze a balance sheet and the steps to prepare a cash flow statement.  Learning outcomes Explore the steps to an effective financial analysis Understand the GAAP requirements for creating financial statements Deepen your understanding of earnings management Learn about applying ratios Deepen your understanding of owner's equity Know how to prepare a cash flow statement Who Is This Course For? This Financial Statement Analysis Masterclass course is highly beneficial for anyone interested in learning the steps for an effective financial statement analysis. In addition, the skills gained from this training will provide excellent opportunities for career advancement.  Entry Requirement This course is available to all learners of all academic backgrounds. Learners should be aged 16 or over. Good understanding of English language, numeracy and ICT skills are required to take this course. Certification After you have successfully completed the course, you will obtain an Accredited Certificate of Achievement. And, you will also receive a Course Completion Certificate following the course completion without sitting for the test. Certificates can be obtained either in hardcopy for £39 or in PDF format at the cost of £24. PDF certificate's turnaround time is 24 hours, and for the hardcopy certificate, it is 3-9 working days. Why Choose Us? Affordable, engaging & high-quality e-learning study materials; Tutorial videos and materials from the industry-leading experts; Study in a user-friendly, advanced online learning platform; Efficient exam systems for the assessment and instant result; United Kingdom & internationally recognized accredited qualification; Access to course content on mobile, tablet and desktop from anywhere, anytime; Substantial career advancement opportunities; 24/7 student support via email. Career Path The Financial Statement Analysis Masterclass Course provides essential skills that will make you more effective in your role. It would be beneficial for any related profession in the industry, such as: Financial Analyst Financial Advisor Financial Planning Analysis Manager Financial and Management Accountant Introduction to the Course Introduction 00:02:00 Module 01: Why Analyse Financial Statements? Why Analyse Financial Statements? 00:10:00 Module 02: GAAP Rules GAAP Rules 00:10:00 Module 03: Correct Timing Correct Timing 00:15:00 Module 04: Earnings Management Earnings Management 00:11:00 Module 05: Balance Sheet Balance Sheet 00:11:00 Module 06: Balance Sheet Part-2 Balance Sheet Part-2 00:11:00 Module 07: Balance Sheet Part-3 Balance Sheet Part-3 00:07:00 Module 08: Statement of Cash Flow Statement of Cash Flow 00:07:00 Module 09: Time Series Time Series 00:11:00 Module 10: Ratios- Introduction Ratios- Introduction 00:16:00 Module 11: Applying Ratios Applying Ratios 00:19:00 Module 12: Valuation Valuation 00:14:00 Module 13: Credits Credits 00:07:00 Module 14: Contracts Contracts 00:10:00 Module 15: Executive Compensation Executive Compensation 00:12:00 Module 16: Lease Lease 00:08:00 Module 17: Owners' Equity Owners' Equity 00:07:00 Module 18: Earnings Per Share Earnings Per Share 00:16:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Financial Statement Analysis Masterclass
Delivered Online On Demand3 hours 24 minutes
£18

Microsoft Excel Advanced Certificate

By OnlineCoursesLearning.com

Microsoft Excel Advanced Course Please Note: This course uses the Windows version of Microsoft Office 2016. Any other versions will have some differences in the functions. The Microsoft (MS) Excel Certification Level 3 Course is the most comprehensive of the three Excel courses presented here. If a team member has successfully completed the Level 1 and Level 2 courses, they will be fully prepared to start the Level 3 course. Formulae or functions are what advanced users of Excel want from this tool. When you use formulae, not only can you see the data that you require for your work, you can also analyse it and get answers to complex questions. Although anyone with some Excel knowledge can use formulae, such as SUM, a user who has the advanced Excel skills presented in this course will use other formulae, both alone and combined, such as MATCH, INDEX, DSUM and VLOOKUP. In addition to knowing and using these formulae, an advanced user of Excel knows how to debug these formulae, how to audit them and how to choose the perfect formula for the particular task to be carried out.   What's Covered in the Course? Any staff member choosing to study this course can expect to gain the following skills: How to set A Password to an Excel document; VLOOKUP Advanced formula options and manipulations; Other advanced functions: OR, AND, CHOOSE, INDIRECT, REPLACE, LEN, LEFT, FIND; Functions of CEILING, CORREL, DATEDIF, DATEVALUE, DAVERAGE and EDATE; Colouring a column and row with a formula; Highlighting a cell with a formula; Functions of ISODD, ISNUMBER, ISTEXT, ISLOGICAL, ISNONTEXT, ISERR and ISBLANK; Functions of DGET, DMAX, DPRODUCT, DCOUNTA, DCOUNT and DSUM; How to calculate depreciation in Excel, including SLN depreciation and SYD depreciation; Calculating loan IPMT and EMI; Functions of DATEDIF, DATEVALUE, EDATE, EOMONTH, MATCH and INDEX; Full explanation of the INDEX and MATCH functions; Looking up data; Selecting only cells containing comments; Hiding formulae; Automatically inserting serial numbers;   The employee will also learn about calculating depreciation, calculating interest and calculating IPMT and EMI for loans, all by using Excel functions. The course features information on INDEX and MATCH functions, which is important in certain industries and roles. It also shows learners how to use the CHOOSE formula and how to create special charts. What are the Benefits of the Course? Upon completion of the Level 3 course, the employee will have access to the full functionality of Excel and will know how to use all of its formulae, functions and capabilities; The Level 3 Excel course is designed for 'power' users, but not only for programmers and those interested in financial modelling; Competent Excel users add huge value to an organisation, through advanced data analysis.

Microsoft Excel Advanced Certificate
Delivered Online On Demand
£50