3012 ETC courses in Cardiff delivered On Demand

Gain insights into effective School Administration and Management strategies. Explore key principles, tools, and techniques for optimizing school operations, fostering a positive learning environment, and promoting student success. Enroll now to enhance your leadership skills and contribute to the efficient management of educational institutions.

There's nothing like riding a motorbike in top condition. The silent wheels. The seamless gear shifts. The smooth-running chain. But it takes a little love and maintenance to keep your ride in peak condition. To make this course more accessible for you, we have designed it for both part-time and full-time students. This course is packed into bite-size modules for your convenience. You can study at your own pace. This Motorbike Maintenance Course will give you the skills you need to get you and your motorbike out of trouble - and know when to call in the professionals! You will receive the confidence to tackle basic roadside repairs and check your bike to make sure it's safe before you ride. The course covers- motorbike component guide, how to do a pre-ride safety check, how to change an inner tube (in double-quick time), cleaning and re-lubing your drivetrain to prevent wear and to enjoy a smoother ride, brake adjustment, gear adjustment, Q&A with the trainer. This course is ideal for people who want to know how to perform basic motorbike care and some simple repairs. This Motorbike Maintenance Course is suitable for anyone aspiring to begin or already working in this field or simply want to learn in-depth about motorbike maintenance. You can add this qualification to your CV by downloading your certificate instantly without any cost after completing the course. Who is this course for? Motorbike Maintenance Course is suitable for anyone who want to gain extensive knowledge, potential experience and professional skills in the related field. This course is CPD accredited so you don't have to worry about the quality. Requirements Our Motorbike Maintenance Course is open to all from all academic backgrounds and there is no specific requirements to attend this course. It is compatible and accessible from any device including Windows, Mac, Android, iOS, Tablets etc. CPD Certificate from Course Gate  At the successful completion of the course, you can obtain your CPD certificate from us. You can order the PDF certificate for £4.99 and the hard copy for £9.99. Also, you can order both PDF and hardcopy certificates for £12.99.  Career path This course opens a new door for you to enter the relevant job market and also gives you the opportunity to acquire extensive knowledge along with required skills to become successful. You will be able to add our qualification to your CV/resume which will help you to stand out in the competitive job industry. Course Curriculum Motorbike Maintenance Course Module - 01: Introduction to Motorbike Maintenance 00:09:00 Module - 02: Basics of Engine 00:09:00 Module - 03: Engine Cooling and Lubrication 00:14:00 Module - 04: Ignition 00:09:00 Module - 05: Suspension 00:09:00 Module - 06: Intake, Fuel, Clutch and Exhaust Systems 00:18:00 Module - 07: Electrical Maintenance 00:16:00 Module - 08 Wheels, Tires and Brakes Maintenance 00:00:00 Module - 09: Transmission, Frame and Steering 00:22:00 Module - 10: Cleaning, Setting Up and Storage 00:09:00 Module - 11: Troubleshooting 00:16:00 Mock Exam Mock Exam - Motorbike Maintenance Course 00:20:00 Final Exam Final Exam - Motorbike Maintenance Course 00:20:00 Certificate and Transcript Order Your Certificates or Transcripts 00:00:00

[vc_row][vc_column][vc_column_text] Description: Improve your competency in Microsoft Office with this Microsoft Excel Complete Course - Beginners, Intermediate, Advanced. Microsoft Excel is the most widely used spreadsheet program in the world. It allows businesses to conduct data analysis, record expenditures and carry out simple to complex maths calculations. Want to master Excel? This complete training course will help you gain the practical skills and knowledge you need to perform everyday data-based tasks faster and more efficiently. This course is designed to help you familiarise with the major functionalities of Excel, with step-by-step guidance. You will start with simple tasks like viewing excel data, working with the interface, using quick analysis and more. At an intermediate skill level, you will learn about macros, forms, slicers, timelines etc. Finally, at an advanced level, you will learn how to create charts, pivot tables, solve formula errors and manage your data more effectively. This online course is the ultimate online guide for learning MS Excel. Certify your skills in this leading office software and gain maximum career progression! Who is the course for? Professionals who want to learn how to use Microsoft Office Excel. People who have a need to analyze and organise large amounts of data. Entry Requirement: This course is available to all learners, of all academic backgrounds. Learners should be aged 16 or over to undertake the qualification. Good understanding of English language, numeracy and ICT are required to attend this course. Assessment: At the end of the course, you will be required to sit an online multiple-choice test. Your test will be assessed automatically and immediately so that you will instantly know whether you have been successful. Before sitting for your final exam, you will have the opportunity to test your proficiency with a mock exam. Certification: After you have successfully passed the test, you will be able to obtain an Accredited Certificate of Achievement. You can however also obtain a Course Completion Certificate following the course completion without sitting for the test. Certificates can be obtained either in hardcopy at the cost of £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/materials from the industry leading experts; Study in a user-friendly, advanced online learning platform; Efficient exam systems for the assessment and instant result; The UK & internationally recognized accredited qualification; Access to course content on mobile, tablet or desktop from anywhere anytime; The benefit of career advancement opportunities; 24/7 student support via email. Career Path: Microsoft Excel Complete Course - Beginners, Intermediate, Advanced is a useful qualification to possess and would be beneficial for any professions or career from any industry you are in such as: Accounting Management consultant Investment Banking Analyst Marketing Engineering Researchering [/vc_column_text][/vc_column][/vc_row] Microsoft Excel - Beginners Module One - Getting Started 00:30:00 Module Two - Opening and Closing Excel 01:00:00 Module Three - Working with the Interface 01:00:00 Module Four - Your First Worksheet 01:00:00 Module Five - Viewing Excel Data 01:00:00 Module Six - Building Formulas 01:00:00 Module Seven - Using Excel Functions 01:00:00 Module Eight - Using Quick Analysis 01:00:00 Module Nine - Formatting Your Data 01:00:00 Module Ten - Using Styles, Themes, and Effects 01:00:00 Module Eleven - Printing and Sharing Your Workbook 01:00:00 Module Twelve - Wrapping Up 01:00:00 Excel for Newbies - Activities 00:00:00 Microsoft Excel - Intermediate Level Module One - Getting Started 00:30:00 Module Two - Working with Permissions and Options 00:30:00 Module Three - Sharing Workbooks 00:30:00 Module Four - Performing Advanced Formula and Function Tasks 00:30:00 Module Five - Working with Array Formulas 01:00:00 Module Six - Working With Macros 00:30:00 Module Seven - Working With Forms 00:30:00 Module Eight - Applying Advanced Chart Features 01:00:00 Module Nine - Working With Slicers and Timelines 00:30:00 Module Ten - Working With Multiple Tables, Relationships and External Data 00:30:00 Module Eleven - Working With PowerView 00:30:00 Module Twelve - Wrapping Up 01:00:00 Activities- Microsoft Excel - Intermediate Level 00:00:00 Microsoft Excel - Advanced Level Module One - Getting Started 01:00:00 Module Two - SmartArt and Objects 01:00:00 Module Three - Auditing 01:00:00 Module Four - Creating Charts 01:00:00 Module Five - Working with Charts 01:30:00 Module Six - Creating Pivot Tables and Pivot Charts 01:00:00 Module Seven - Macros 01:00:00 Module Eight - Solving Formula Errors 01:00:00 Module Nine - Using What If Analysis 01:00:00 Module Ten - Managing Your Data 02:00:00 Module Eleven - Grouping and Outlining Data 01:00:00 Module Twelve - Wrapping Up 00:30:00 Activities-Microsoft Excel - Advanced Level 00:00:00 Mock Exam Mock Exam- Microsoft Excel Complete Course - Beginners, Intermediate, Advanced 00:30:00 Final Exam Final Exam- Microsoft Excel Complete Course - Beginners, Intermediate, Advanced 00:30:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Do you want to make a noticeable difference in the lives of autistic individuals? Would you like to learn the skills and know-how to help those living with developmental disorders confidently? Well, the autism and developmental disorders course will help you immensely to acquire the skills to become a capable individual who can help autistic people.

Embark on a journey to uncover the labyrinthine world of digital financial security with the 'Hacked Credit and Debit Card Recovery Course'. Navigate through the depths of the web, from understanding the diverse range of websites to delving deep into the dark corridors of the internet, equipping yourself with invaluable cyber intelligence. Through this course, you'll decode various threat perceptions, familiarise yourself with card fraud intricacies, and master the art of information recovery - all tailored to ensure your digital financial transactions remain impervious to threats. Learning Outcomes Understand the fundamentals of cyber threats and their impact on digital financial transactions. Differentiate between various website types and their susceptibility to cyber-attacks. Analyse threat actors and their modus operandi in the cyber realm. Gain insights into the deep and dark web and the tools necessary for information recovery. Acquire proficiency in information handling procedures to maintain digital financial security. Why buy this Hacked Credit and Debit Card Recovery Course? Unlimited access to the course for forever Digital Certificate, Transcript, student ID all included in the price Absolutely no hidden fees Directly receive CPD accredited qualifications after course completion Receive one to one assistance on every weekday from professionals Immediately receive the PDF certificate after passing Receive the original copies of your certificate and transcript on the next working day Easily learn the skills and knowledge from the comfort of your home Certification After studying the course materials of the Hacked Credit and Debit Card Recovery Course there will be a written assignment test which you can take either during or at the end of the course. After successfully passing the test you will be able to claim the pdf certificate for £5.99. Original Hard Copy certificates need to be ordered at an additional cost of £9.60. Who is this Hacked Credit and Debit Card Recovery Course for? Individuals keen on enhancing their understanding of digital financial security. Banking and finance professionals looking to fortify their defence mechanisms. Cybersecurity enthusiasts aiming to delve into card fraud detection and prevention. Internet users wanting to safeguard their online financial transactions. Tech-savvy individuals eager to explore deep and dark web intelligence. Prerequisites This Hacked Credit and Debit Card Recovery Course does not require you to have any prior qualifications or experience. You can just enrol and start learning.This Hacked Credit and Debit Card Recovery Course was made by professionals and it is compatible with all PC's, Mac's, tablets and smartphones. You will be able to access the course from anywhere at any time as long as you have a good enough internet connection. Career path Cyber Security Analyst: £35,000 - £55,000 Fraud Detection Analyst: £30,000 - £50,000 Dark Web Researcher: £40,000 - £65,000 Information Security Officer: £45,000 - £70,000 Threat Intelligence Specialist: £50,000 - £75,000 Financial Security Consultant: £55,000 - £80,000 Course Curriculum Unit 01: Introduction Introduction & Objective 00:01:00 Unit 02: Types of Website Types of Website 00:01:00 Surface Web 00:01:00 Deep Web 00:01:00 Dark Web 00:03:00 2016 - 2017 Profit Comparison from 5000 00:01:00 Intelligence Agency Web 00:01:00 Quantum Computers 00:01:00 Polymeric Falcighol Derivation 00:01:00 Graphical representation 00:01:00 Unit 03: Threat Perception Threat Perception 00:01:00 Threat Actor 00:01:00 Threat Actor-Compared to a Hacker Or Attacker 00:01:00 Is the Dark Net Market gone? 00:03:00 Unit 04: Card Fraud Card Fraud 00:04:00 Card-Not-Present Fraud (CNP) 00:02:00 Unit 05: Threat Ninja Threat Ninja 00:01:00 Threat Ninja Architecture 00:03:00 Adaptive Assessment 00:01:00 Secure Coat Approach 00:01:00 Secure Coat's Value Proposition 00:02:00 Challenge 00:01:00 Unit 06: Threat Actor Analysis Threat Actor Analysis 00:00:00 Kuchinoni - ATM Theft 00:01:00 Insider Threats 00:01:00 Unit 07: Cyber Security Monitoring Cyber Security Monitoring 00:01:00 Protect Your Company via DDWM 00:01:00 Unit 08: Threat Life Cycle Threat Life Cycle 00:06:00 Unit 09: Information Leakage Points Information Leakage Points 00:04:00 Unit 10: Valuable Information Valuable Information 00:09:00 Unit 11: Area of Search Area of Search 00:01:00 Sell Cards at Social Media, Messenger, etc. Groups 00:01:00 Unit 12: Deep & Dark Web Intelligence and Information Recovery Deep & Dark Web Intelligence and Information Recovery 00:01:00 Unit 13: Banking Fraud Types Banking Fraud Types 00:01:00 Card Fraud- Nilson Report 00:01:00 U.S. Card Fraud Losses 00:01:00 Card Fraud Statistics 00:05:00 Unit 14: Threat Ninja Tool Secure Coat Threat Ninja Portal 00:01:00 Threat Ninja Demo 00:05:00 Unit 15: Information Handing Procedures Information Handling Procedures 00:01:00 Card Discard Life Cycle 00:02:00 Unit 16: Course Wrap up Congratulations and Course Summary 00:03:00 Thank you! 00:01:00 Unit 17: Bonus Rise in the price of the Crypto Coin 00:06:00 Assignment Assignment - Hacked Credit and Debit Card Recovery Course 00:00:00

Embark on a riveting journey from ChatGPT novice to maestro with our 'ChatGPT Masterclass: A Complete ChatGPT Zero to Hero!' This isn't just a course; it's your passport to mastering the intricacies of ChatGPT. In the initial sections, we handhold you through the basics, ensuring a solid foundation. As you progress, delve into the world of developers, discovering how ChatGPT can be harnessed for coding marvels. But this course isn't limited to tech whizzes; entrepreneurs can scale their business using the prowess of ChatGPT in Section 04. For students, Section 05 unveils the academic wonders of ChatGPT, while Section 08 ventures into artistic realms with Dall-E 2. Brace yourself for a transformative experience as you explore the power of ChatGPT across diverse domains, from Excel to graphic art. Learning Outcomes Master the fundamentals of ChatGPT, progressing from the basics to advanced applications. Harness ChatGPT for coding and development, unlocking its potential for developers. Scale your business using ChatGPT, understanding its applications in entrepreneurship. Explore academic applications, discovering how ChatGPT enhances student learning. Unleash the artistic side of ChatGPT, creating graphic art with Dall-E 2. Why choose this ChatGPT Masterclass: A Complete ChatGPT Zero to Hero course? Unlimited access to the course for a lifetime. Opportunity to earn a certificate accredited by the CPD Quality Standards and CIQ after completing this course. Structured lesson planning in line with industry standards. Immerse yourself in innovative and captivating course materials and activities. Assessments designed to evaluate advanced cognitive abilities and skill proficiency. Flexibility to complete the Course at your own pace, on your own schedule. Receive full tutor support throughout the week, from Monday to Friday, to enhance your learning experience. Unlock career resources for CV improvement, interview readiness, and job success. Who is this ChatGPT Masterclass: A Complete ChatGPT Zero to Hero course for? Aspiring ChatGPT enthusiasts eager to transition from zero to hero. Developers seeking to integrate ChatGPT into their coding repertoire. Entrepreneurs aiming to leverage ChatGPT for business growth. Students exploring the academic applications of conversational AI. Creatives and graphic artists interested in the artistic possibilities of ChatGPT. Career path Conversational AI Developer: £50,000 - £80,000 Entrepreneurial AI Strategist: £60,000 - £90,000 AI-enhanced Education Specialist: £45,000 - £70,000 Creative AI Artist: £40,000 - £60,000 AI Solutions Architect: £55,000 - £85,000 Innovative Tech Entrepreneur: £70,000 - £100,000 Prerequisites This ChatGPT Masterclass: A Complete ChatGPT Zero to Hero! does not require you to have any prior qualifications or experience. You can just enrol and start learning.This ChatGPT Masterclass: A Complete ChatGPT Zero to Hero! was made by professionals and it is compatible with all PC's, Mac's, tablets and smartphones. You will be able to access the course from anywhere at any time as long as you have a good enough internet connection. Certification After studying the course materials, there will be a written assignment test which you can take at the end of the course. After successfully passing the test you will be able to claim the pdf certificate for £4.99 Original Hard Copy certificates need to be ordered at an additional cost of £8. Course Curriculum Section 01: Getting Started Introduction 00:04:00 Start on Windows, macOS, and Linux 00:01:00 How to ask great questions 00:02:00 FAQs 00:01:00 Section 02: ChatGPT - Basic What is ChatGPT 00:05:00 Create a ChatGPT account 00:06:00 How to use ChatGPT 00:10:00 ChatGPT for day-to-day activities 00:04:00 Advanced ChatGPT Plus 00:05:00 Section 03: ChatGPT for Developers ChatGPT for programmers 00:12:00 Improve Problem-solving skills 00:06:00 Create an Algorithms 00:06:00 How to build a website with ChatGPT 00:05:00 Develop a Stunning Landing page for product sales 00:07:00 Create a Documentation 00:03:00 Code Debugging with ChatGPT 00:05:00 Section 04: Build, and Scale your Business Using ChatGPT The Best Businesses Ideas to start with ChatGPT 00:05:00 SEO Basics for your website 00:06:00 How to make an online course using ChatGPT 00:05:00 Selling Competitive products with ChatGPT 00:04:00 Exercise on real-world sales query 00:01:00 Solution for an exercise 00:02:00 ection 05: ChatGPT for Students ChatGPT to Prepare Resume 00:03:00 Interview preparation with ChatGPT 00:05:00 ChatGPT for PowerPoint content 00:03:00 Innovative Job Searching using ChatGPT 00:04:00 Write a short film with ChatGPT for Creative Fiction and Screenplays 00:03:00 Section 06: The Power of ChatGPT Make the best diet plan for a day 00:03:00 Suggest a meal plan with seafood as the special ingredient 00:03:00 Write a Business Email for the franchise 00:03:00 Create Legal documents like sale deeds etc. 00:03:00 Section 07: ChatGPT for Excel professionals Sum with ChatGPT 00:05:00 VLOOKUP with ChatGPT 00:05:00 Section 08: Generate Incredible Graphic Art with Dall-E 2 Introduction to Dall-E 2 00:04:00 Dall-E 2 Creating 3D Graphic design 00:03:00 Dall-E 2 Deep Dive in Editing your own image 00:04:00 How to Make Money with Dall-E 2 00:03:00 Section 09: The Best Tools and Extensions using ChatGPT Integrating ChatGPT with Google Search 00:06:00

Master the strategies of handing medicine efficiently and safely with the Safe Handling of Medication course. Medicine should be handled carefully as human lives depend on it. Medicine is prepared to make you well, but if you do not use it properly, you may sick and even it may cause death. The purpose of the course is to aware you how to handle medicine safely. The course presents a general overview of the legislation and guidelines regarding the management of medication management settings. The principal legal aspects of handling medicines will be covered in the course. Therefore, you will gain all the essential skills for Health's UK Core Skills Training Framework (CSTF), the Care Quality Commission (CQC) recommendations for health care and social care providers. The course guides you to know the procedures for ordering, receiving, administering, storing and disposing of medicines safely. You will explore the steps of obtaining and receiving supplies. You will also learn how drugs are administered and how problems may occur. Upon completion, you will be able to know the techniques for storing and disposing of the drugs safely and securely. Who is this course for? Safe Handling of Medication is suitable for anyone who want to gain extensive knowledge, potential experience and professional skills in the related field. This course is CPD accredited so you don't have to worry about the quality. Requirements Our Safe Handling of Medication is open to all from all academic backgrounds and there is no specific requirements to attend this course. It is compatible and accessible from any device including Windows, Mac, Android, iOS, Tablets etc. CPD Certificate from Course Gate  At the successful completion of the course, you can obtain your CPD certificate from us. You can order the PDF certificate for £9 and the hard copy for £15. Also, you can order both PDF and hardcopy certificates for £22. Career path This course opens a new door for you to enter the relevant job market and also gives you the opportunity to acquire extensive knowledge along with required skills to become successful. You will be able to add our qualification to your CV/resume which will help you to stand out in the competitive job industry. Course Curriculum Diploma in Safe Handling of Medication Introduction to Safe Handling of Medicines 00:30:00 Legislation and guidance of medication management 00:30:00 Principles of Safe and Appropriate Handling of Medicines 00:45:00 Medication Risk Assessment Guidance 00:30:00 Consent to Treatment 00:30:00 Handling Medicines in Social Care Settings 01:00:00 Requirements for Specific Services 00:45:00 Levels of Care and Support 00:15:00 Procedure for Handling Medication 00:30:00 The Six Rights of Medication Administration 00:30:00 Covert Administration of Medication 00:30:00 Recording Procedures 00:15:00 Storage of Medication 00:15:00 Transfer and Disposal of Medication 00:30:00 Drug Formulation and Ways of Taking It 01:00:00 Mock Exam Mock Exam - Safe Handling of Medication 00:20:00 Final Exam Final Exam - Safe Handling of Medication 00:20:00 Certificate and Transcript Order Your Certificates or Transcripts 00:00:00

Description Learn the most used second language of the world from the native teacher. Enrol the English Course - Beginner Level course and enhance your skills in English. The course starts by providing discussion on the English Alphabets and basic pronunciations. Then you will learn how to greet people, master the numbers in English including decimal numbers, fractions and percentages, use of this, that, here, there, and more. Details discussion will be on the English verbs covering present, past, and future form of verbs, action verbs, irregular verbs, etc. The course explains adjectives and its types such as superlative, comparative. You will learn about prepositions, adverbs, and adverbs of frequency, possessives, conjunctions and many other grammatical elements. Finally, some of the basic conversations in English will be presented to you. Shortly, the course trains you to speak with fluency and accuracy. Assessment: This course does not involve any MCQ test. Students need to answer assignment questions to complete the course, the answers will be in the form of written work in pdf or word. Students can write the answers in their own time. Once the answers are submitted, the instructor will check and assess the work. Certification: After completing and passing the course successfully, you will be able to obtain an Accredited Certificate of Achievement. Certificates can be obtained either in hard copy at a cost of £39 or in PDF format at a cost of £24. Who is this Course for? English Course - Beginner Level is certified by CPD Qualifications Standards and CiQ. This makes it perfect for anyone trying to learn potential professional skills. As there is no experience and qualification required for this course, it is available for all students from any academic background. Requirements Our English Course - Beginner Level is fully compatible with any kind of device. Whether you are using Windows computer, Mac, smartphones or tablets, you will get the same experience while learning. Besides that, you will be able to access the course with any kind of internet connection from anywhere at any time without any kind of limitation. Career Path After completing this course you will be able to build up accurate knowledge and skills with proper confidence to enrich yourself and brighten up your career in the relevant job market. Module : 01 Learn English- Find out all about this course in less than two minutes FREE 00:01:00 Learn English - Greetings. Introductions and Alphabet. Spelling Skills 00:11:00 Learn English - Greetings. Introductions and Alphabet. Spelling Skill (ii) 00:17:00 Learn English - Numbers. Cardinal & Ordinal numbers 00:15:00 Numbers. Decimal points, Percentages & Fractions. Money & more 00:10:00 Numbers. Decimal points, Percentages & Fractions. Money & more (ii) 00:10:00 Learn English - Name & Personal Information 00:15:00 Learn English - This, that, here, there. Animals 00:11:00 Learn English - Present of the verb 'to be' 00:10:00 Learn English - Action Verbs 00:15:00 Module : 02 Learn English - Adjectives. Comparative and Superlative Adjectives. 00:15:00 Learn English - Basic prepositions use. Prepositions 00:19:00 Learn English - There is, There are. Nouns 00:12:00 Learn English - Some, any, much, many 00:10:00 Learn English - Question Words 00:14:00 Learn English - Irregular Verbs 00:14:00 Learn English - Adverbs. 00:09:00 Learn English - Adverbs of Frequency 00:12:00 Subject Pronouns. Possessive Adjectives. Object Pronouns. Possess 00:13:00 Learn English - Jobs. 00:14:00 Module : 03 Learn English - Telling the Time. 00:09:00 Learn English - Telling the Time. (II) 00:13:00 Learn English - Time expressions. 00:12:00 Learn English - Everyday Objects 00:13:00 Learn English - House and rooms 00:16:00 Learn English - Future simple 00:12:00 Learn English - Emotions 00:15:00 Learn English - Perfect Continuous Tense 00:16:00 Learn English - Perfect Tense 00:14:00 Learn English - Parts of human body 00:13:00 Module : 04 Learn English - Perfect Continuous Tense 00:16:00 Learn English - Friends and family 00:12:00 Learn English - Gerunds 00:16:00 Learn English - Town, city, countryside 00:17:00 Learn English - Active Voice and Passive Voice 00:20:00 Learn English - Mood of the sentence 00:16:00 Learn English - Conjunctions and Conjunctive Adverbs 00:16:00 Learn English - Auxiliary Verbs 00:15:00 Learn English - Grammar essentials 00:12:00 Module : 05 Dictation 1 00:07:00 Dictation 2 00:06:00 Dictation 3 00:06:00 Dictation 4 00:09:00 Dictation 6 00:05:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Overview This comprehensive course on Microsoft Excel: Automated Dashboard Using Advanced Formula, VBA, Power Query will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Microsoft Excel: Automated Dashboard Using Advanced Formula, VBA, Power Query comes with accredited certification which will enhance your CV and make you worthy in the job market. So enrol in this course today to fast track your career ladder. How will I get my certificate? You may have to take a quiz or a written test online during or after the course. After successfully completing the course, you will be eligible for the certificate. Who is this course for? There is no experience or previous qualifications required for enrolment on this Microsoft Excel: Automated Dashboard Using Advanced Formula, VBA, Power Query. It is available to all students, of all academic backgrounds. Requirements Our Microsoft Excel: Automated Dashboard Using Advanced Formula, VBA, Power Query is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible on tablets and smartphones so you can access your course on wifi, 3G or 4G. There is no time limit for completing this course, it can be studied in your own time at your own pace. Career path Having these various qualifications will increase the value in your CV and open you up to multiple sectors such as Business & Management, Admin, Accountancy & Finance, Secretarial & PA, Teaching & Mentoring etc. Course Curriculum 12 sections • 76 lectures • 06:08:00 total length •Course Outline and Introduction: 00:04:00 •Minimum Requirements for the Course: 00:01:00 •Prepayments Introduction: 00:01:00 •Month End Date Prepaid Expenses Amortization Calculation: 00:00:00 •Exact Prepaid Expenses Payment Date Calculation: 00:00:00 •Prepaid Expenses Accounting Definition: Prepayments: 00:03:00 •Prepaid Expense Example: How Accounting works for Prepayments: 00:03:00 •Advantages and Disadvantages of Prepaid Expenses: 00:03:00 •Introduction to PRO Excel Models and Formulas: 00:06:00 •Date Function: 00:05:00 •EOMONTH Function: 00:04:00 •DATEVALUE function: 00:03:00 •IF Function: 00:08:00 •IFS Function (Office 365 Only): 00:07:00 •VLOOKUP Function: 00:07:00 •MATCH Function: 00:05:00 •INDIRECT Function: 00:02:00 •NAMED Ranges: Name Manager: 00:03:00 •Advanced Version of VLOOKUP Function: 00:07:00 •Introduction to Model and Control Panel Tab (Important Sheet Tab): 00:08:00 •Formula Based Prepaid Expenses Model - Deep Dive (Part 1): 00:05:00 •Formula Based Prepaid Expenses Model - Deep Dive (Part 2): 00:06:00 •Formula Based Prepaid Expenses Model - Deep Dive (Part 3): 00:06:00 •IFS Function - Month End date Prepayment calculation: 00:04:00 •Prepaid Expenses - Closing Balance Summary Tab (Formula Based Summary): 00:09:00 •Protecting Formulas Cells and Fields in the Model: 00:04:00 •Exact Date Prepaid Amortisation calculation Intro: 00:03:00 •Formulas update and Model Changes for Exact Prepaid Exps Calculation: 00:03:00 •Formulas Update for Exact Date Prepaid Exps Amortisation (Part 1): 00:04:00 •Formulas Update for Exact Date Prepaid Exps Amortisation (Part 2): 00:03:00 •Formulas Update for Exact Date Prepaid Exps Amortisation (Part 3): 00:02:00 •Formulas Update for Exact Date Prepaid Exps Amortisation (Part 4): 00:07:00 •IFS Function - Exact Date Prepayments Amortisation: 00:04:00 •Data Validation Controls (Enhancing Data Input Controls with Protection): 00:10:00 •Bonus: Prepayment Model with Opening Balance Calculation (Part 1): 00:08:00 •Bonus: Prepayment Model with Opening Balance Calculation (Part 2): 00:09:00 •Additional Material: Resources: 00:00:00 •Power Query and Pivot Table Prepayment Summary Table Intro: 00:06:00 •What is Power Query and Some Awesome Resources for Power Query learning: 00:07:00 •Power Query and Pivot Table Summary - Deep Dive (Part 1): 00:05:00 •Power Query and Pivot Table Summary - Deep Dive (Part 2): 00:04:00 •Power Query and Pivot Table Summary - Deep Dive (Part 3): 00:05:00 •Power Query and Pivot Table Summary - Deep Dive (Part 4): 00:09:00 •Using Array Formulas to Add Formula Protection: 00:04:00 •Bonus: Allocate Prepaid Expenditure Cost Centre Wise - 1: 00:02:00 •Bonus: Allocate Prepaid Expenditure Cost Centre Wise - 2: 00:08:00 •Bonus: Prepayment Model with Opening Balance Calculation (PQ and PT Version): 00:13:00 •Changing Macros Security in Excel: 00:05:00 •Complete Walkthrough - Advanced VBA Prepaid Expenses Amortisation Model: 00:06:00 •Bonus : New Version - Excel VBA Model for Prepayment Expenditure: 00:08:00 •Dynamic Dashboard Overview: 00:07:00 •Importing Profit and Loss Statements Source Files and creating YTD P&L Sheets: 00:08:00 •Creating Dynamic Data Validation: 00:02:00 •Creating Named Ranges for Dynamic Table Arrays: 00:03:00 •Dynamic Date Column Headings for each Divisional PL Table: 00:02:00 •Dynamic Month and YTD Dashboard tables headings (PRO TIP): 00:03:00 •Dynamic VLOOKUP Formula - Preparing First section of the Dashboard: 00:04:00 •Creating Rolling Dashboard with Dynamic VLOOKUP Function: 00:08:00 •IMPORTANT : Error Checking for your reports/Dashboard (PRO TIP): 00:03:00 •Data Prep for Visualization: AREA Charts (Awesome trick using #NA Function): 00:05:00 •Visualization: AREA Charts for Month - Revenue, Gross Profit and Net Profit: 00:05:00 •Visualization DONUT Charts Revenue, Gross Profit and Net Profit (Part 1): 00:03:00 •Visualization DONUT Charts Revenue, Gross Profit and Net Profit (Part 2): 00:06:00 •Introduction - Formula-less Dashboard - Fully Dynamic and easily refreshed: 00:05:00 •Understanding the data files before building dashboard: 00:02:00 •Consolidating Reports with Power Query (Get & Transform) , How to install PQ: 00:08:00 •Dynamic File Path Trick in Power Query with Parameters (Amazing trick): 00:06:00 •Conditional Cumulative totals with SUMIFS Function: 00:04:00 •Bonus: Conditional Cumulative totals with Power Query Custom Formula (M Code): 00:06:00 •Dashboard Creation - Pivot Table showing Month and YTD KPIs division wise: 00:06:00 •Dashboard Creation Donuts Charts linked with Pivot Table (Replicate Charts fast): 00:08:00 •Dashboard Creation - Line Charts: 00:08:00 •Update Dashboard with Additional Divisional Data with Few Click (Magical): 00:03:00 •Thank you: 00:02:00 •Ultimate Prepaid Expenditure Model (Super Bonus): 00:02:00 •Resources - Microsoft Excel: Automated Dashboard Using Advanced Formula, VBA, Power Query: 00:00:00

Highlights of the Course Course Type: Online Learning Duration: 1 to 2 hours Tutor Support: Tutor support is included Customer Support: 24/7 customer support is available Quality Training: The course is designed by an industry expert Recognised Credential: Recognised and Valuable Certification Completion Certificate: Free Course Completion Certificate Included Instalment: 3 Installment Plan on checkout What you will learn from this course? Gain comprehensive knowledge about digital advertising and marketing Understand the core competencies and principles of digital advertising and marketing Explore the various areas of digital advertising and marketing Know how to apply the skills you acquired from this course in a real-life context Become a confident and expert digital marketer Digital Advertising and Marketing 101: The Complete Guide Course Master the skills you need to propel your career forward in digital advertising and marketing. This course will equip you with the essential knowledge and skillset that will make you a confident digital marketer and take your career to the next level. This comprehensive digital advertising and marketing course is designed to help you surpass your professional goals. The skills and knowledge that you will gain through studying this digital advertising and marketing course will help you get one step closer to your professional aspirations and develop your skills for a rewarding career. This comprehensive course will teach you the theory of effective digital advertising and marketing practice and equip you with the essential skills, confidence and competence to assist you in the digital advertising and marketing industry. You'll gain a solid understanding of the core competencies required to drive a successful career in digital advertising and marketing. This course is designed by industry experts, so you'll gain knowledge and skills based on the latest expertise and best practices. This extensive course is designed for digital marketer or for people who are aspiring to specialise in digital advertising and marketing. Enrol in this digital advertising and marketing course today and take the next step towards your personal and professional goals. Earn industry-recognised credentials to demonstrate your new skills and add extra value to your CV that will help you outshine other candidates. Who is this Course for? This comprehensive digital advertising and marketing course is ideal for anyone wishing to boost their career profile or advance their career in this field by gaining a thorough understanding of the subject. Anyone willing to gain extensive knowledge on this digital advertising and marketing can also take this course. 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. Entry Requirements This digital advertising and marketing course has no academic prerequisites and is open to students from all academic disciplines. You will, however, need a laptop, desktop, tablet, or smartphone, as well as a reliable internet connection. Assessment This digital advertising and marketing course assesses learners through multiple-choice questions (MCQs). Upon successful completion of the modules, learners must answer MCQs to complete the assessment procedure. Through the MCQs, it is measured how much a learner could grasp from each section. In the assessment pass mark is 60%. Why you should train with Study Plex? At Study Plex, you will have the chance to build social, technical and personal skills through a combination of extensive subjects tailored according to your interest. Along with receiving comprehensive knowledge and transferable skills, there are even more reasons o be involved with us, which include: Incredible Customer Support: We offer active customer service in the form of live chat, which you can access 24/7 Expert Tutor Support: You'll have access to our devoted and dedicated tutor support with all of our courses whenever you need it. Price Justified by Quality: We ensure that you will have the best experience possible for the price you are paying for the course. Money-back Guarantee: We provide a money-back guarantee if you are not satisfied with the course's quality. There is a 14-day time limit on this option (according to the terms and conditions). Instalment Facility: If your course costs more than £50, you can pay in three instalments using the instalment option. Satisfaction Guarantee: Our courses are designed to meet your demands and expectations by all means. Recognised Accreditation This course is accredited by continuing professional development (CPD). CPD UK is globally recognised by employers, professional organisations, and academic institutions, thus a certificate from CPD Certification Service creates value towards your professional goal and achievement. The Quality Licence Scheme is a brand of the Skills and Education Group, a leading national awarding organisation for providing high-quality vocational qualifications across a wide range of industries. What is CPD? Employers, professional organisations, and academic institutions all recognise CPD, therefore a credential from CPD Certification Service adds value to your professional goals and achievements. Benefits of CPD Improve your employment prospects Boost your job satisfaction Promotes career advancement Enhances your CV Provides you with a competitive edge in the job market Demonstrate your dedication Showcases your professional capabilities What is IPHM? The IPHM is an Accreditation Board that provides Training Providers with international and global accreditation. The Practitioners of Holistic Medicine (IPHM) accreditation is a guarantee of quality and skill. Benefits of IPHM It will help you establish a positive reputation in your chosen field You can join a network and community of successful therapists that are dedicated to providing excellent care to their client You can flaunt this accreditation in your CV It is a worldwide recognised accreditation What is Quality Licence Scheme? This course is endorsed by the Quality Licence Scheme for its high-quality, non-regulated provision and training programmes. The Quality Licence Scheme is a brand of the Skills and Education Group, a leading national awarding organisation for providing high-quality vocational qualifications across a wide range of industries. Benefits of Quality License Scheme Certificate is valuable Provides a competitive edge in your career It will make your CV stand out Course Curriculum Introduction Welcome to the Course 00:03:00 Introduction to Digital Ads Introduction Part 1 - The IAB, Banner Ads, Video Ads and Rich Media 00:11:00 Introduction Part 2 - Custom, Skins, Social Media, Audio Ads, And Search 00:09:00 The Digital Advertising Ecosystem Digital Ecosystem Part 1 - Publisher direct, exchanges, networks, DSPs & ATDs 00:11:00 How DSPs, SSPs, Exchanges, Networks, and publishers all work together 00:07:00 Buying The Ads Buying Digital Ads - How to buy digital ads, price ranges, process and more 00:12:00 Ad Targeting Ad Targeting - Contextual, behavioral, demographic, geographic & more 00:08:00 Ad Serving What is an ad server. DoubleClick, DFP, DFA, third party ad servers, etc. 00:03:00 Illustration of how ad serves work 00:03:00 Reporting Digital Advertising Reporting Overview - Impressions, Clicks, CTR, CPC, & more 00:03:00 Course Review Final course review and Thank You. 00:04:00 Obtain Your Certificate Order Your Certificate of Achievement 00:00:00 Get Your Insurance Now Get Your Insurance Now 00:00:00 Feedback Feedback 00:00:00