17858 Teaching courses in Whetstone delivered On Demand

The VLOOKUP: Master Excel Formula VLOOKUP is a wonderful learning opportunity for anyone who has a passion for this topic and is interested in enjoying a long career in the relevant industry. It's also for anyone who is already working in this field and looking to brush up their knowledge and boost their career with a recognised certification. This VLOOKUP: Master Excel Formula VLOOKUP consists of several modules that take around 1 hour to complete. The course is accompanied by instructional videos, helpful illustrations, how-to instructions and advice. The course is offered online at a very affordable price. That gives you the ability to study at your own pace in the comfort of your home. You can access the modules from anywhere and from any device. Why choose this course Earn an e-certificate upon successful completion. Accessible, informative modules taught by expert instructors Study in your own time, at your own pace, through your computer tablet or mobile device Benefit from instant feedback through mock exams and multiple-choice assessments Get 24/7 help or advice from our email and live chat teams Full Tutor Support on Weekdays Course Design The course is delivered through our online learning platform, accessible through any internet-connected device. There are no formal deadlines or teaching schedules, meaning you are free to study the course at your own pace. You are taught through a combination of Video lessons Online study materials Mock exams Multiple-choice assessment Certification Upon successful completion of the course, you will be able to obtain your course completion PDF Certificate at £9.99. Print copy by post is also available at an additional cost of £15.99 and the same for PDF and printed transcripts. Course Content VLOOKUP: Master Excel Formula VLOOKUP in 60 minutes! Menu Example with Excel Vlookup 00:08:00 Wildcard Search with Excel Vlookup 00:09:00 Looking to the Left with Excel Vlookup 00:17:00 2-Way Lookup 00:14:00 Comparing Lists with Excel Vlookup 00:03:00 Vlookup Tips and Tricks 00:14:00 Order your Certificates & Transcripts Order your Certificates & Transcripts 00:00:00 Frequently Asked Questions Are there any prerequisites for taking the course? There are no specific prerequisites for this course, nor are there any formal entry requirements. All you need is an internet connection, a good understanding of English and a passion for learning for this course. Can I access the course at any time, or is there a set schedule? You have the flexibility to access the course at any time that suits your schedule. Our courses are self-paced, allowing you to study at your own pace and convenience. How long will I have access to the course? For this course, you will have access to the course materials for 1 year only. This means you can review the content as often as you like within the year, even after you've completed the course. However, if you buy Lifetime Access for the course, you will be able to access the course for a lifetime. Is there a certificate of completion provided after completing the course? Yes, upon successfully completing the course, you will receive a certificate of completion. This certificate can be a valuable addition to your professional portfolio and can be shared on your various social networks. Can I switch courses or get a refund if I'm not satisfied with the course? We want you to have a positive learning experience. If you're not satisfied with the course, you can request a course transfer or refund within 14 days of the initial purchase. How do I track my progress in the course? Our platform provides tracking tools and progress indicators for each course. You can monitor your progress, completed lessons, and assessments through your learner dashboard for the course. What if I have technical issues or difficulties with the course? If you encounter technical issues or content-related difficulties with the course, our support team is available to assist you. You can reach out to them for prompt resolution.

Overview This comprehensive course on The Basics of ArcGIS for Hydrology will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This The Basics of ArcGIS for Hydrology comes with accredited certification from CPD, 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? At the end of the course there will be an online written test, which you can take either during or after the course. After successfully completing the test you will be able to order your certificate, these are included in the price. Who is This course for? There is no experience or previous qualifications required for enrolment on this The Basics of ArcGIS for Hydrology. It is available to all students, of all academic backgrounds. Requirements Our The Basics of ArcGIS for Hydrology is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible with tablets and smartphones so you can access your course on Wi-Fi, 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 4 sections • 22 lectures • 03:27:00 total length •Introduction to GIS: 00:07:00 •Introduction to ArcGIS software: 00:09:00 •Selection by Location, attributes, clip features and tables to Excel: 00:11:00 •Performing actions on the data: change the projections, dissolve, clip: 00:13:00 •From .TXT and .DXF to shapefile: 00:10:00 •Calculations with attribute table and KML files in ArcMap: 00:11:00 •Export from ArcMap to PDF: 00:11:00 •ArcScene 3D: 00:08:00 •GIS Example Test: 00:15:00 •AutoCAD fixing polygon coordinates: 00:14:00 •Download hydrological data: 00:06:00 •Calculate flow direction and flow accumulation: 00:09:00 •Watershed delineation: 00:10:00 •Clip layers to watershed boundary: 00:10:00 •Stream segments and catchments areas: 00:09:00 •Stream order convert to vector: 00:10:00 •Spatial join to catchments: 00:11:00 •Join stream id to stream order: 00:08:00 •Map data and initial layout: 00:11:00 •Add and format map elements: 00:14:00 •Resources - The Basics of ArcGIS for Hydrology: 00:00:00 •Assignment -The Basics of ArcGIS for Hydrology: 00:00:00

Overview Did you know that according to the World Health Organization, patient-centred care, which includes obtaining informed consent, is a key component of quality health services? The "Consent in Healthcare" course is here for your excellence, boasting a curriculum combining theoretical knowledge with real-world applications. The course opens with an "Introduction to COVID-19," delving deep into the intricacies of this global pandemic. The curriculum further explores the UK Acts to consent, providing valuable insights into the legal landscape governing healthcare consent. The course also covers crucial topics such as "Diagnosis and Treatment," "Artificial Intelligence, Data Science, and Technological Solutions against COVID-19," and "Handling Complaints Regarding Consent."Enrol now in our "Consent in Healthcare" course and unlock a world of opportunities in healthcare and beyond! 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 Consent in Healthcare. It is available to all students, of all academic backgrounds. Requirements Our Consent in Healthcare 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 18 sections • 16 lectures • 04:52:00 total length •Introduction to COVID-19: 00:28:00 •Understanding of Covid-19 as a Pandemic and How It Is Related to Zoonotic Diseases Like SARS and MERS: 00:12:00 •The Strike of Pandemic Around the World and Great Britain: 00:14:00 •Effects of Covid-19 on Human Life: 00:19:00 •Diagnosis and Treatment: 00:12:00 •Preventions and Social Measures to Be Taken: 00:28:00 •Artificial Intelligence, Data Science and Technological Solutions against Covid-19: 00:19:00 •An Introduction to Consent: 00:14:00 •Information Regarding Consent: 00:13:00 •Consent Training in Healthcare Course: 00:16:00 •Best Interest Decision Making: 00:20:00 •Assessing Capacity: 00:15:00 •Providing Care or Treatment to People Who Lack Capacity: 00:11:00 •Public Bodies and Services Created by MCA Act 2005: 00:22:00 •UK Acts in Relation to Consent: 00:27:00 •Handling Complaints Regarding Consent: 00:22:00

Overview This comprehensive course on Psychology Advanced Training will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Psychology Advanced Training comes with accredited certification from CPD, 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 Psychology Advanced Training. It is available to all students, of all academic backgrounds. Requirements There is no experience or previous qualifications required for enrolment on this Psychology Advanced Training. It is available to all students, of all academic backgrounds. 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 1 sections • 24 lectures • 06:02:00 total length •Intro By Prof. Paul - WHY This Course is SO Important To Your Life!: 00:02:00 •Goals & Fundamentals: 00:17:00 •Understanding HOW Feelings Work & How You Can USE This!: 00:12:00 •'The Imprint Period' - How You Were Created - How You Were Programmed: 00:17:00 •The Amazing Truth About Values & Beliefs: 00:18:00 •Do You Know The Difference Between Reality & Lies? Are You Sure?: 00:25:00 •Personal Illusions That Are Holding You Back - Break Free!: 00:20:00 •EGO - The Great Deceiver: 00:35:00 •The Inner-Critic How To WIN The INNER Battle: 00:08:00 •Understanding Self-Image & Your Multiple Minds: 00:21:00 •How To Defeat The PAST & The FUTURE: 00:18:00 •Emotional Reasoning & Logic Systems - How To WIN!: 00:08:00 •Understanding & Meeting Your Needs - The Hidden Secrets: 00:11:00 •Understanding Motivation - The Ultimate Driving Force: 00:17:00 •Defeat This Major Block . And Free Your Mind!: 00:08:00 •Discover 'The Source & Solution To All Your Problems': 00:15:00 •Agenda & Lies - How They impact Your Life: 00:11:00 •Gambits - Games People Play: 00:12:00 •Break Free From The Problems of 'Attachment' & 'The Sheep Mentality': 00:14:00 •'The Dirty Secret Of Psychology' & How To Free Yourself!: 00:25:00 •Tap Into The Power Of The Unconscious Mind: 00:21:00 •How To Control Your Own Mind - And WHY Almost Nobody Does!: 00:05:00 •Why FEAR Dominates Our Lives & How To Beat it!: 00:05:00 •Final Thoughts, Tips & Suggestions To Radically Improve Your Life: 00:17:00

Overview This comprehensive course on Practical Project Management will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Practical Project Management 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 Practical Project Management. It is available to all students, of all academic backgrounds. Requirements Our Practical Project Management is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible with tablets and smartphones so you can access your course on Wi-Fi, 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 6 sections • 26 lectures • 02:45:00 total length •What is a Project?: 00:04:00 •The Four Stage Project Lifecycle: 00:09:00 •Project Stages and Boundaries: 00:09:00 •One Reason why Projects go Wrong: 00:06:00 •Terminology used in the Project Stages: 00:05:00 •More on Project Gateways / Stage Gates: 00:02:00 •Define your Project: Goals and Objectives: 00:11:00 •Understanding Project Scope: 00:06:00 •Dealing with Scope Creep: 00:06:00 •Project Definition: Summary: 00:03:00 •The Book of the Plan: 00:06:00 •The Stakeholder Engagement Process: 00:04:00 •Stakeholder Analysis: 00:07:00 •Milestones are your Best Friends: 00:08:00 •The Work Breakdown Structure: 00:08:00 •The Gantt Chart: 00:06:00 •Tools for Creating a Gantt Chart: 00:04:00 •The Linear Responsibility Chart (LRC) aka The RACI Chart: 00:09:00 •Risk Analysis: 00:08:00 •The Six Strategies for Managing Risks: 00:09:00 •The Risk Register: 00:06:00 •The Four Essentials of Leading your Team: 00:07:00 •Project Delivery - The Three Key Cycles: 00:12:00 •Closing your Project in an Orderly Manner: 00:09:00 •Closing Words: 00:01:00 •Assignment - Practical Project Management: 00:00:00

Overview This comprehensive course on Logistics of Crude Oil and Petroleum Products will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Logistics of Crude Oil and Petroleum Products 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 Logistics of Crude Oil and Petroleum Products. It is available to all students, of all academic backgrounds. Requirements Our Logistics of Crude Oil and Petroleum Products is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible with tablets and smartphones so you can access your course on Wi-Fi, 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 8 sections • 26 lectures • 01:45:00 total length •Learning objectives: 00:04:00 •Introduction to the different methods of transport: 00:05:00 •The different types of tankers: 00:05:00 •The different types of charters: 00:02:00 •The cost of marine transport: 00:04:00 •The price of marine transport: 00:07:00 •Prices and costs of marine transport: 00:05:00 •Regulations : National flag requirement: 00:01:00 •Flags of convenience: 00:01:00 •Operating aspects: 00:04:00 •Controls on loading: 00:07:00 •Administrative formalities: 00:01:00 •The reception of tankers: 00:07:00 •The constraints: 00:05:00 •The cost of transport by pipeline: 00:03:00 •Comparing transport costs: 00:06:00 •Storage and delivery to the refinery: 00:03:00 •Introduction: 00:03:00 •Dispatch by pipeline: 00:07:00 •Dispatch by water: 00:07:00 •Dispatch by rail: 00:06:00 •Dispatch by road: 00:05:00 •Quality: 00:02:00 •Quantities: 00:02:00 •Administrative accounting methods: 00:01:00 •Customs formalities: 00:02:00

Overview Gain the ultimate leadership and management skills and become a qualified leader by enrolling in the advanced Complete Leadership and Management Diploma - Level 4 course. This comprehensive Complete Leadership and Management Diploma - Level 4 aims to equip you with a solid understanding of leadership and management,along with the skills, expertise and confidenceto drive your career forward. You'll learn about professional skill development essentials, time management, delegation, dealing with poor performance, defining team values and goals, project management, and many more. Throughout the course, you'll discover many reasons for being unable to achieve goals and credibility that will help your personal development. Boost your career opportunities as a leader by enrolling today! 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 Complete Leadership and Management Diploma - Level 4. It is available to all students, of all academic backgrounds. Requirements Our Complete Leadership and Management Diploma - Level 4 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 21 sections • 21 lectures • 08:46:00 total length •Introduction to the Course: 00:03:00 •Understanding Management and Leadership: 00:40:00 •Leadership Theories: 00:25:00 •Improving Management and Leadership Performance: 00:15:00 •High Performance Teams: 00:32:00 •Motivating Employees: 00:26:00 •Organisational Skills: 00:26:00 •Talent Management: 00:37:00 •Succession Planning: 00:24:00 •Business Process Management: 00:28:00 •Communication Skills: 00:27:00 •Negotiation Techniques: 00:15:00 •Managing Meetings and Giving Feedback: 00:21:00 •Managing Change: 00:22:00 •Time Management: 00:37:00 •Stress Management: 00:15:00 •Emotional Intelligence in Leadership: 00:32:00 •Managing Conflict: 00:14:00 •Dealing with Office Politics: 00:34:00 •Risk Management: 00:37:00 •Corporate Responsibility and Ethics: 00:16:00

Overview This comprehensive course on WebGL 2D/3D Programming and Graphics Rendering will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This WebGL 2D/3D Programming and Graphics Rendering 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? After successfully completing the course you will be able to order your certificate, these are included in the price. Who is This course for? There is no experience or previous qualifications required for enrolment on this WebGL 2D/3D Programming and Graphics Rendering. It is available to all students, of all academic backgrounds. Requirements Our WebGL 2D/3D Programming and Graphics Rendering is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible with tablets and smartphones so you can access your course on Wi-Fi, 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 7 sections • 28 lectures • 04:05:00 total length •WebGL vs OpenGL vs OpenGL ES: 00:05:00 •Setup Server (Mac, Windows and Linux): 00:05:00 •Setup WebGL Project: 00:08:00 •WebGL Rendering Pipeline: 00:04:00 •Drawing A Point: 00:22:00 •Normalised Coordinates vs Device Coordinates: 00:10:00 •Drawing A Simple Triangle: 00:06:00 •Drawing A Line Using gl.LINES: 00:03:00 •Drawing A Line Using gl.LINE_STRIP & gl.LINE_LOOP: 00:03:00 •Drawing A Triangle With Lines Using gl.TRIANGLE_STRIP & gl.TRIANGLE_FAN: 00:03:00 •Drawing A Quad: 00:07:00 •Drawing A 3D Cube: 00:24:00 •Setup Three.js: 00:06:00 •Loading & Drawing A Model Using Three.js: 00:16:00 •Applying Color To Shapes: 00:09:00 •One Color Per Triangle: 00:15:00 •One Color Per Vertex Using Interpolation: 00:02:00 •Applying A Texture To Shapes: 00:23:00 •Texture Coordinates: 00:08:00 •Moving Objects Using Translation: 00:06:00 •Left Handed vs Right Handed Coordinate System: 00:06:00 •Sizing Objects Using Scaling: 00:06:00 •Combining Transformations: 00:07:00 •Mouse Input: 00:11:00 •Keyboard Input: 00:09:00 •Fixing Rotation and Adding Individual Rotation: 00:08:00 •Ambient Lighting: 00:13:00 •Resource: 00:00:00

Begin your journey towards a rewarding and successful career by enrolling in our all-inclusive bundle of 8 Level 7 (QLS) Business Development, Management and Analysis courses. At UKHF Online, we have carefully selected and combined these courses to equip you with the vital skills and knowledge necessary to thrive in Level 7 (QLS) Business Development, Management and Analysis . Whether you're a student, recent graduate, or job seeker, our Level 7 (QLS) Business Development, Management and Analysis bundle is designed to enhance your CV, impress potential employers, and set you apart from the competition. Key Features of the Level 7 (QLS) Business Development, Management and Analysis Bundle: 3 QLS-Endorsed Courses: We proudly offer 3 QLS-endorsed courses within our Level 7 (QLS) Business Development, Management and Analysis bundle, providing you with industry-recognized qualifications. Plus, you'll receive a free hardcopy certificate for each of these courses. QLS Course 01: Business Development QLS Course 02: Business Management QLS Course 03: Business Analysis 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: Financial Modelling for Decision Making and Business plan Course 02: Branding Your Business Course 03: AML for Business Owner Course 04: Business Law & Commercial Law Course 05: Compliance & Business Risk Management 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 Level 7 (QLS) Business Development, Management and Analysis courses are accessible online, allowing you to learn at your own pace and from the comfort of your own home. Learning Outcomes of the Level 7 (QLS) Business Development, Management and Analysis Bundle: Master the foundational principles and techniques of Level 7 (QLS) Business Development, Management and Analysis . Develop advanced proficiency in Level 7 (QLS) Business Development, Management and Analysis methodologies and strategies. Acquire in-depth knowledge of the latest trends and advancements in Level 7 (QLS) Business Development, Management and Analysis . Enhance your problem-solving and critical thinking abilities within the context of Level 7 (QLS) Business Development, Management and Analysis . Cultivate strong communication and collaboration skills essential for success in Level 7 (QLS) Business Development, Management and Analysis . The Level 7 (QLS) Business Development, Management, and Analysis bundle is an outstanding ensemble of eight courses, meticulously designed to provide an in-depth understanding of various business domains. This comprehensive course package offers an unparalleled blend of theoretical knowledge and strategic insights, giving learners a deep understanding of business principles. This selection is perfect for anyone looking to climb the corporate ladder or start their entrepreneurial journey, providing a stepping stone towards career success. CPD 250 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Individuals interested in deepening their understanding of business management, development, and analysis. Professionals seeking a career transition into business-centric roles. Aspiring entrepreneurs wanting to gather essential business knowledge. Anyone interested in acquiring a theoretical understanding of business operations. Career path Business Developer - Salary Range in the UK: £30,000 - £70,000 Business Manager - Salary Range in the UK: £35,000 - £80,000 Business Analyst - Salary Range in the UK: £26,000 - £70,000 Financial Analyst - Salary Range in the UK: £30,000 - £65,000 Compliance Officer - Salary Range in the UK: £30,000 - £75,000 Certificates Digital certificate Digital certificate - Included Hard copy certificate Hard copy certificate - Included

Excel Crash Course is yet another 'Teacher's Choice' course from Teachers Training for a complete understanding of the fundamental topics. You are also entitled to exclusive tutor support and a professional CPD-accredited certificate in addition to the special discounted price for a limited time. Just like all our courses, this Excel Crash Course and its curriculum have also been designed by expert teachers so that teachers of tomorrow can learn from the best and equip themselves with all the necessary skills. Consisting of several modules, the course teaches you everything you need to succeed in this profession. The course can be studied part-time. You can become accredited within 03 Hours studying at your own pace. Your qualification will be recognised and can be checked for validity on our dedicated website. Why Choose Teachers Training Some of our website features are: This is a dedicated website for teaching 24/7 tutor support Interactive Content Affordable price Courses accredited by the UK's top awarding bodies 100% online Flexible deadline Entry Requirements No formal entry requirements. You need to have: Passion for learning A good understanding of the English language Be motivated and hard-working Over the age of 16. Certification CPD Certification from The Teachers Training Successfully completing the MCQ exam of this course qualifies you for a CPD-accredited certificate from The Teachers Training. You will be eligible for both PDF copy and hard copy of the certificate to showcase your achievement however you wish. You can get your digital certificate (PDF) for £4.99 only Hard copy certificates are also available, and you can get one for only £10.99 You can get both PDF and Hard copy certificates for just £12.99! The certificate will add significant weight to your CV and will give you a competitive advantage when applying for jobs. Analysis of Twitter Dataset and Designing Heatmaps Introduction to the Excel crash course 00:06:00 Understanding the Twitter Dataset 00:05:00 Extracting Other Details for Analysis 00:09:00 Creating Pivot Tables 00:08:00 Applying Conditional Formatting using Color Scales 00:03:00 Adding Slicers to Dashboard 00:02:00 Applying Custom Number Formats 00:03:00 Adding Custom Images to Charts 00:11:00 Interlude - Data Manipulation Challenge 00:02:00 Adding Heatmap Legend 00:02:00 Wrapping Up - Introduction to Open Analytics 00:02:00 Advanced Currency Converter using Dynamic Arrays Introduction to Modern Excel Tables and Dynamic Arrays 00:11:00 Using Power Query for Data Manipulation 00:08:00 Applying Power Query Data Transformations 00:06:00 Structured Table Referencing 00:12:00 XLOOKUP Function and Pivot Table Calculations 00:05:00 Laundry Service Model and Invoicing Dashboard Introduction to the Project 00:01:00 Overview of the Laundry Model Project 00:04:00 Understanding the Inputs 00:03:00 Formatting the Input Tables 00:04:00 Duplicate and Combine Tables with Power Query 00:09:00 Rounding Digits in Power Query 00:02:00 Load Specific Tables from Power Query 00:02:00 Feature Extraction and Named Ranges 00:10:00 Combining Elements - Data Validation with Named Ranges 00:08:00 Combining Elements - Understanding the INDIRECT Function 00:02:00 Combining Elements - Dynamic Drop-down Menu with Data Validation 00:04:00 Combining Elements - INDEX and MATCH with Multiple Criteria 00:12:00 Understanding the MATCH Formula with Multiple Criteria 00:06:00 Business Invoice Dashboard Design 00:06:00