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

1045 Intelligence Analysis courses in Cardiff delivered Online

How to Build Your Own First Voice Assistant in Python

By Packt

This course is designed for beginner-level students to create their first voice assistant in Python. If you have the questions: How to create a chatbot in Python? How to build a virtual assistant with Python? Then you are on the right course. This is a great small project to get you started (even if you have little or no prior knowledge in python) and a learning opportunity.

How to Build Your Own First Voice Assistant in Python
Delivered Online On Demand1 hour 18 minutes
£14.99

Microsoft Excel 3 Course Bundle - Beginner, Intermediate & Advanced

5.0(1)

By Course Gate

Master Microsoft Excel with our CPD Accredited Complete Course, covering Beginner, Intermediate & Advanced levels. Boost your skills for data analysis, financial management, and more. Ideal for students, recent graduates, job seekers, and professionals. Get recognized with a worldwide CPD certificate. Learn at your own pace with expert guidance and support. Elevate your career with Excel expertise. Enrol now!

Microsoft Excel 3 Course Bundle - Beginner, Intermediate & Advanced
Delivered Online On Demand11 hours 20 minutes
£11.99

Python for Data Science and Machine Learning Bootcamp

5.0(1)

By Course Gate

Python for Data Science and Machine Learning Bootcamp online course is suitable for anyone interested in learning Python for data science and machine learning. It is especially ideal for aspiring data scientists and professionals seeking to enhance their data analysis skills.

Python for Data Science and Machine Learning Bootcamp
Delivered Online On Demand10 hours 12 minutes
£11.99

Canine Communication Diploma

4.7(47)

By Academy for Health and Fitness

Make a strong connection with your dog by understanding canine communication! In our course on Canine Communication, you can discover a wide range of ideas on canine communication that will improve the way you interact with dogs. So, sign up right away! This Diploma in Canine Communication at QLS Level 4 course is endorsed by The Quality Licence Scheme and accredited by CPDQS (with 120 CPD points) to make your skill development & career progression more accessible than ever! Why Prefer This Canine Communication Course? Opportunity to earn certificate a certificate endorsed by the Quality Licence Scheme & another accredited by CPDQS after completing the Canine Communication course Get a free student ID card! (£10 postal charge will be applicable for international delivery) Innovative and engaging content. Free assessments 24/7 tutor support. You will learn about the various forms of canine communication in this Canine Communication course. Additionally, you'll learn about canine intelligence and how to develop your dog's mental skills. You will comprehend the advantages and justifications for socialising with your dog. You will also learn about dog body language, stances, a body language reference table, odours and smells, and vocal language. Understanding of body language of dogs will help you to understand how dogs think and behave. You can contrast dog-human communication and human-dog communication after completing this course. Moreover, you will discover dog emotions and symptoms of distress, the responsibilities of a dog owner, and crucial abilities for working with dogs. Are you looking to improve your current abilities or make a career move? Our unique Canine Communication course might help you get there! Expand your expertise with high-quality training - study the Canine Communication course and get an expertly designed, great-value training experience. Learn from industry professionals and quickly equip yourself with the specific knowledge and skills you need to excel in your chosen career through the Canine Communication online training course. For the most convenient learning experience, the Canine Communication course has been divided into a number of in-depth modules. This Canine Communication course can serve as a springboard for you to realise your goals and get ready for a fulfilling profession. You may be able to find your ideal work in the relevant field with further education and training. Learning outcome After you have completed the Canine Communication course, you will: Explore canine evolution, communication, and canine communication types. Find out more about canine intelligence. Recognise the significance of dog socialisation. Understand how dogs communicate. Gain knowledge about the psychology of dogs. Knows about the body language and communication of dogs. Learn how dogs and people interact. Identify the emotions and symptoms of suffering in dogs. Be able to comprehend what a dog owner does. Grasp the fundamentals of working with dogs. So join us today and get ready to excel! *** Course Curriculum *** >> Canine Communication Course << Module 1: Introduction to Canine Evolution Canines What Is Canine Communication? Canine Evolution Different Types of Canine Communication Module 2: Introduction to Canine Intelligence All Dogs Are Different Dogs: Super-Savvy, Socially The Dog's Nose Knows How to Nurture Your Dog's Cognitive Abilities? Channelling Dog Sports Module 3: The Importance of Socialisation What is a Socialisation Period? The Importance of Socialising your Dog The Benefits of Socialising 8 Reasons Why You Should Socialise Your Dog Module 4: Canine Communication Body language Stances Body language reference table Smells and sniffing Vocal language Module 5: Canine Psychology Canine Psychology How Dogs Think Pack Mentality, Dominance, and the Alpha Dog Psychology Theory Pavlov's Dog Psychology - Classical Conditioning Canine Calming Signals Module 6: Dog Communication and Body Language Fearful Communication Arousal Communication Anxious Communication Aggressive Communication Relaxed Communication Body Language Resources Module 7: Communication Between Dogs and Human Understanding of Human Referential Gesture Dog's Human Directed Communication Comparison of Human-Dog and Dog-Human Communication Module 8: Canine Emotions and Signs of Suffering An Overview of Dogs and Emotions Identifying 8 Key Dog Emotions The Signs of Suffering in a Dog Seeking Assistance for Pain and Suffering Module 9: The Role of a Dog Owner Responsibilities of Dog Owners 5 Essential Commands You Can Teach Your Dog Module 10: Essential Skills for Working With Dogs What Skills Do You Need for Dog Jobs? Basic Dog Handling and Training Skills Ability to Recognise Behavioral Signals Knowledge of Proper Grooming Techniques Ability to Recognise Common Health Problems Knowledge of Canine Anatomy and Breed Standards Communicating With Animal Professionals and Owners The Desire to Pursue Relevant Certifications Practice Patience and Exhibit Desirable Personality Traits Assessment Process After completing an online course module, you will be given immediate access to a specially designed MCQ test. The results will be immediately analysed, and the score will be shown for your review. The passing score for each test will be set at 60%. After passing the Diploma in Canine Communication at QLS Level 4 exam, you will be able to request a certificate at an additional cost that has been endorsed by the Quality Licence Scheme. CPD 120 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Anyone can enrol on this Canine Communication course. This course is open to anyone with an interest in the topic or who wants to learn a new skill. However, this course is better suited for the following: Dog lovers Dog owners Dog enthusiasts Dog professionals Requirements You will not need any prior background or expertise to enrol in this course. Career path You will be able to explore a range of job prospects in this industry after successfully completing this Canine Communication course and with additional training and experience, including: Pet shop assistant - (Salary: £14,500 to £17,500) Dog handler - (Salary: £16,000 to £30,000) Assistance dog trainer - (Salary: £16,000 to £28,000) Dog groomer - (Salary: £13,500 to £20,000) Certificates Certificate of completion Digital certificate - £10 Diploma in Canine Communication at QLS Level 4 Hard copy certificate - £99 Show off Your New Skills with a Certificate of Completion After successfully completing the Diploma in Canine Communication at QLS Level 4, you can order an original hardcopy certificate of achievement endorsed by the Quality Licence Scheme. The certificate will be home-delivered, with a pricing scheme of - 99 GBP inside the UK 109 GBP (including postal fees) for International Delivery Certificate Accredited by CPDQS 29 GBP for Printed Hardcopy Certificate inside the UK 39 GBP for Printed Hardcopy Certificate outside the UK (International Delivery)

Canine Communication Diploma
Delivered Online On Demand3 weeks
£15

VLOOKUP: Master Excel Formula VLOOKUP in 60 minutes!

4.8(9)

By Skill Up

Master VLOOKUP in Excel in just 60 minutes! From menus to list comparisons, learn essential VLOOKUP skills fast.

VLOOKUP: Master Excel Formula VLOOKUP in 60 minutes!
Delivered Online On Demand1 hour
£13.99

Emotional Intelligence, Mindfulness and Empathy Training - Level 3

4.9(27)

By Apex Learning

Overview Gain in-demand emotional intelligence and become more proactive in all your respective contexts by taking the highly productive Emotional Intelligence, Mindfulness and Empathy Training - Level 3 course. The comprehensive Emotional Intelligence, Mindfulness and Empathy Training - Level 3 course covers self-management fundamentals, verbal & non-verbal communication essentials, social management and responsibility, emotion regulation tools, and business practices. During the course, you'll understand how to regulate your own emotions. By the end, you'll have excellent social skills and ability to control impulse feelings and implement emotional intelligence in the workplace. Enhance your personality development 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 Emotional Intelligence, Mindfulness and Empathy Training - Level 3. It is available to all students, of all academic backgrounds. Requirements Our Emotional Intelligence, Mindfulness and Empathy Training - Level 3 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 10 sections • 10 lectures • 01:09:00 total length •What is Emotional Intelligence: 00:13:00 •Skills in Emotional Intelligence: 00:06:00 •Verbal Communication Skills: 00:05:00 •Non-Verbal Communication Skills: 00:05:00 •Social Management and Responsibility: 00:06:00 •Tools to Regulate Your Emotions: 00:06:00 •Gaining Control: 00:07:00 •Business Practices (I): 00:07:00 •Business Practices (II): 00:07:00 •Making an Impact: 00:07:00

Emotional Intelligence, Mindfulness and Empathy Training - Level 3
Delivered Online On Demand1 hour 9 minutes
£12

Network Security Level 2

4.9(27)

By Apex Learning

Course Overview: Did you know 70% of organisations reported a cybersecurity breach last year? Network Security Level 2 is more than just a course; it invests in a safer digital future. This curriculum offers a meticulous journey, delving deeper into network security. From understanding the intricacies of Security and Risk Management to Security Operations, this course ensures comprehensive coverage. Whether you're keen on mastering Asset Security, seeking profound knowledge in Security Engineering, or aiming to understand the dynamics of Communication and Network Security, Identity and Access Management, Security Assessment and Testing, or Software Development Security, this course is tailored to equip you with the advanced knowledge necessary for the cybersecurity challenges of tomorrow. Take action now. Stay ahead of the curve, safeguard sensitive data, and become a beacon of trust in cybersecurity. Enrol today! Key Features of the Course: Awarded a CPD certificate upon completion. 24/7 Learning Assistance to ensure uninterrupted progress. Engaging learning materials designed by top industry experts. Who is This Course For? This Network Security Level 2 course is Ideal for professionals who have completed foundational courses in network security and are looking to further enhance their skills and knowledge. Learning Outcome Acquire an in-depth understanding of security protocols. Delve into Security and Risk Management. Understand the essence of Asset Security. Engineer robust security measures. Master Communication and Network Security. Manage Identity and Access effectively. Conduct Security Assessment and Testing proficiently. Implement efficient Security Operations. Secure software through development practices. Why Enrol in This Course: Stay ahead in the cybersecurity realm. This top-reviewed course, recently updated, is trending and empowers you with the skills to counteract the ever-evolving world of network threats. Requirements: Basic knowledge of network security principles. Completion of a foundational course in network security or equivalent experience. Career Path: Upon completion of this Network Security Level 2 course, professionals can explore numerous roles, such as: Security Analyst: £50,000 Network Security Engineer: £55,000 Cybersecurity Manager: £65,000 Security Consultant: £60,000 Information Security Officer: £58,000 Threat Intelligence Analyst: £53,000 Cybersecurity Architect: £62,000 Certification: Students will be awarded a CPD certificate upon successful completion, recognising their advanced Network Security Level 2 proficiency. FAQ What is Level 3 cyber security? Level 3 cyber security refers to a qualification or course that provides an advanced understanding of cybersecurity principles and practices. It is often designed for individuals with foundational cybersecurity knowledge who want to deepen their expertise. What are the 5 types of network security? The five types of network security are: Firewalls, which prevent unauthorised access to or from a private network; Antivirus and anti-malware software, which protect against malicious software; Intrusion Prevention Systems (IPS), which identify and prevent known threats; Virtual Private Networks (VPNs) which provide secure remote access; and Data Loss Prevention (DLP) prevents sensitive data from leaving the network. What is BTEC Level 2 cyber security? BTEC Level 2 cyber security is a qualification that provides an introduction to the principles and practices of cybersecurity. It is typically designed for individuals new to the field and seeking foundational knowledge. What is OCN NI Level 2 cybersecurity? OCN NI Level 2 cybersecurity is a qualification offered by the Open College Network Northern Ireland. It provides a foundational understanding of cybersecurity principles and practices and is designed for individuals new to the field. What is OCN Level 2 equivalent to? OCN Level 2 is equivalent to a GCSE grade A*-C or a Level 2 NVQ. An intermediate-level qualification provides a foundation in a specific subject area. What is OCN Level 2 qualification? OCN Level 2 qualification is an intermediate-level qualification that provides a foundational understanding of a specific subject area. It is typically designed for individuals who have completed basic education and seek to further their knowledge and skills. Course Curriculum 2 sections • 9 lectures • 02:12:00 total length •Security and Risk Management: 00:24:00 •Asset Security: 00:12:00 •Security Engineering: 00:15:00 •Communication and Network Security: 00:10:00 •Identity and Access Management: 00:10:00 •Security Assessment and Testing: 00:12:00 •Security Operations: 00:36:00 •Software Development Security: 00:13:00 •Assignment - Network Security Level 2: 00:00:00

Network Security Level 2
Delivered Online On Demand2 hours 12 minutes
£12

Recruitment: IT Basics for IT Recruiters

4.9(27)

By Apex Learning

Overview This comprehensive course on Recruitment: IT Basics for IT Recruiters will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Recruitment: IT Basics for IT Recruiters 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 Recruitment: IT Basics for IT Recruiters. It is available to all students, of all academic backgrounds. Requirements Our Recruitment: IT Basics for IT Recruiters 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. Career Path Learning this new skill will help you to advance in your career. It will diversify your job options and help you develop new techniques to keep up with the fast-changing world. This skillset will help you to- Open doors of opportunities Increase your adaptability Keep you relevant Boost confidence And much more! Course Curriculum 9 sections • 62 lectures • 05:10:00 total length •Introduction: 00:02:00 •Server: 00:08:00 •What is hardware and software?: 00:04:00 •Project Life Cycle: 00:06:00 •Software Development Life Cycle: 00:08:00 •Methodologies: Scrum, Agile, Kanban, Waterfall, Lean: 00:09:00 •CMS: 00:04:00 •API: 00:04:00 •Stacks: 00:03:00 •Native & Hybrid Native Apps: 00:02:00 •CI / CD / Deployment tools: 00:04:00 •CTO: 00:13:00 •IT Architects: 00:08:00 •Product Owner: 00:12:00 •Product Manager: 00:06:00 •PO vs Product Manager: 00:04:00 •Project Manager: 00:13:00 •Product Owner vs Project Manager vs Product Manager: 00:07:00 •Business Analysts: 00:09:00 •Business Intelligence Analyst: 00:06:00 •Data Engineer: 00:05:00 •Data Scientist: 00:07:00 •Data Engineer vs Data Scientist: 00:07:00 •Agile Coach: 00:14:00 •Scrum Master: 00:08:00 •Agile Coach vs Scrum Master: 00:01:00 •Frontend Developer: 00:06:00 •Backend Developer: 00:06:00 •Fullstack Developer: 00:04:00 •Developers: Frontend, Backend and Fullstack: 00:02:00 •iOS Developer: 00:03:00 •Android Developer: 00:04:00 •UX Designers: 00:09:00 •UI Design: 00:08:00 •UX vs UI Design: what is the difference?: 00:04:00 •QA Engineers and Testers: 00:09:00 •System Administrators: 00:07:00 •DevOps: 00:05:00 •SEO Specialists: who are they?: 00:10:00 •Programming Languages and Frameworks. Introduction: 00:01:00 •Programming languages and frameworks: 00:08:00 •JavaScript: 00:02:00 •Java: 00:03:00 •Python: 00:01:00 •C: 00:02:00 •C#: 00:02:00 •C++: 00:03:00 •SWIFT: 00:02:00 •Objective C: 00:01:00 •HTML: 00:02:00 •PHP: 00:02:00 •Ruby: 00:02:00 •SQL: 00:02:00 •Go: 00:01:00 •R: 00:01:00 •Database: 00:05:00 •Types of Databases: 00:07:00 •The day of an IT Recruiter: 00:05:00 •Key principles: 00:03:00 •Sourcing Tips: 00:03:00 •Thank you for taking part in this course!: 00:01:00 •Assignment - Recruitment: IT Basics for IT Recruiters: 00:00:00

Recruitment: IT Basics for IT Recruiters
Delivered Online On Demand5 hours 10 minutes
£12

Data Analysis in Excel Level 3 Course

4.9(27)

By Apex Learning

Course Overview: Data analysis is a hot skill in today's job market. According to a recent study by LinkedIn, demand for data analysts is growing 15 times faster than the average for all occupations. And the salaries are good too. The average salary for a data analyst in the UK is £40,000. If you're looking to get ahead in your career or learn a new skill that's in high demand, then the Data Analysis in Excel Level 3 Course is for you. In this course, you'll learn how to use Excel to analyse data like a pro. You'll learn how to clean, format, and analyse data using various Excel tools and techniques. You'll also learn how to create charts and graphs to visualise your data. This course won't merely make you adept at Excel. It will mould you into a data wizard, wielding Excel as a potent tool to make data sing and secrets reveal themselves. Enrol Today and Start Learning! Key Features of the Course: Embark on your data analysis journey with us and discover these exciting features: A CPD Certificate to validate your newfound skills. 24/7 Learning Assistance for any hour inspiration strikes. Engaging learning materials to ensure an enriching learning experience. Who is This Course For? Our Data Analysis in Excel Level 3 Course caters to ambitious individuals with a basic understanding of Excel, eager to take their skills to new heights. This course welcomes everything from budding data enthusiasts to established business analysts seeking to fortify their analytical toolkits. What You Will Learn: Dive deep into the labyrinth of data as you master essential modules such as 'Search for and Replace Data,' 'Sort and Filter Data,' and 'Query Data with Database Functions.' Venture further into data exploration with our 'Outline and Subtotal Data' module, where you'll learn to summarise your data for a more organised view efficiently. The journey continues with modules like 'Create Charts' and 'Modify and Format Charts,' enabling you to translate complex data into easy-to-understand visuals. Furthermore, our dedicated modules on 'Creating a PivotTable' and 'Analysing PivotTable Data' promise a comprehensive understanding of one of Excel's most powerful tools. Why Enrol in This Course: Rated as a top-reviewed course and constantly updated to keep up with the latest trends, our Data Analysis in Excel Level 3 Course equips you with sought-after skills like data forecasting, creating sparklines, using advanced chart features, and more. Requirements: While no specific prerequisites are required, a basic understanding of Excel and an eagerness to explore the fascinating world of data analysis would be beneficial. Career Path: On completion of this Data Analysis in Excel Level 3 Course course, you'll be ready to step into diverse roles such as: Data Analyst (£30,000-£35,000) Business Intelligence Analyst (£32,000-£37,000) Market Research Analyst (£28,000-£33,000) Operations Analyst (£31,000-£36,000) Financial Analyst (£35,000-£40,000) Supply Chain Analyst (£30,000-£35,000) Sales Analyst (£29,000-£34,000) Certification: Upon successful completion of the course, you'll be awarded a prestigious CPD Certificate, demonstrating your expertise in data analysis using Excel. So, are you ready to discover the hidden stories in data and revolutionise decision-making? Enrol in our Data Analysis in Excel Level 3 Course and start your journey today! Course Curriculum 11 sections • 32 lectures • 04:43:00 total length •Insert, Delete, and Adjust Cells, Columns, and Rows: 00:10:00 •Search for and Replace Data: 00:09:00 •Use Proofing and Research Tools: 00:07:00 •Sort Data: 00:10:00 •Filter Data: 00:10:00 •Query Data with Database Functions: 00:09:00 •Outline and Subtotal Data: 00:09:00 •Apply Intermediate Conditional Formatting: 00:07:00 •Apply Advanced Conditional Formatting: 00:05:00 •Create Charts: 00:13:00 •Modify and Format Charts: 00:12:00 •Use Advanced Chart Features: 00:12:00 •Create a PivotTable: 00:13:00 •Analyze PivotTable Data: 00:12:00 •Present Data with PivotCharts: 00:07:00 •Filter Data by Using Timelines and Slicers: 00:11:00 •Use Links and External References: 00:12:00 •Use 3-D References: 00:06:00 •Consolidate Data: 00:05:00 •Use Lookup Functions: 00:12:00 •Trace Cells: 00:09:00 •Watch and Evaluate Formulas: 00:08:00 •Apply Data Validation: 00:13:00 •Search for Invalid Data and Formulas with Errors: 00:04:00 •Work with Macros: 00:18:00 •Create Sparklines: 00:07:00 •MapData: 00:07:00 •Determine Potential Outcomes Using Data Tables: 00:08:00 •Determine Potential Outcomes Using Scenarios: 00:09:00 •Use the Goal Seek Feature: 00:04:00 •Forecasting Data Trends: 00:05:00 •Assignment - Data Analysis in Excel Level 3 Course: 00:00:00

Data Analysis in Excel Level 3 Course
Delivered Online On Demand4 hours 43 minutes
£12

Microsoft Excel Course for Everyone - Complete Excel Course

4.9(27)

By Apex Learning

Overview This Microsoft Excel Course for Everyone - Complete Excel Course is your passport to spreadsheet mastery.Explore Excel in detail and improve your abilities with practical activities that go beyond boring lectures. Take on spreadsheets like an expert, from data entry to difficult formulas and eye-catching graphics. But the magic doesn't end there! After finishing successfully, you'll not only impress with your proficiency with Excel, but you'll also obtain a respected CPD certification to enhance your CV and make a statement in the job market. Consider it your golden ticket to go up in your job!Enrol right away to see how your confidence and chances rise! Don't wait! 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 Course for Everyone - Complete Excel Course. It is available to all students, of all academic backgrounds. Requirements Compatible with a wide range of gadgets, including smartphones, tablets, laptops, Macs, and PCs. Particularly designed to be easily accessed with an internet connection on tablets and smartphones. No strict deadlines; learn whenever it's convenient for you. Individuals with basic English proficiency. Career Path After completing this course, it will increase the value of your CV and open you up to multiple sectors, such as : Data Analyst: £25,000 - £50,000 per year Financial Analyst: £30,000 - £60,000 per year Operations Manager: £35,000 - £70,000 per year Accountant: £25,000 - £50,000 per year Business Intelligence Analyst: £35,000 - £65,000 per year These salary ranges can vary based on factors such as experience, location, and the specific industry of the business. Course Curriculum 15 sections • 80 lectures • 06:51:00 total length •Introduction: 00:03:00 •Course Curriculum: 00:04:00 •Getting started on Windows, macOS, Android, and IOS: 00:01:00 •How to ask great questions: 00:02:00 •FAQ's: 00:01:00 •Starting Excel: 00:04:00 •Introduction: 00:02:00 •Worksheet basics: 00:22:00 •Entering values and formulas: 00:12:00 •Data formats: 00:10:00 •Data handling basics - cut copy and paste: 00:07:00 •Save and print in excel: 00:10:00 •Excel Ranges: 00:05:00 •Introduction: 00:01:00 •Basic formula operations: 00:06:00 •Mathematical functions level 1: 00:20:00 •Mathematical functions level 2: 00:12:00 •Text functions level 1: 00:09:00 •Text functions level 2: 00:13:00 •Logical functions: 00:11:00 •Date time functions: 00:06:00 •V Lookup formula: 00:12:00 •HLookup formula: 00:04:00 •HLookup + Match formula: 00:09:00 •Match + Index formula: 00:05:00 •Introduction: 00:02:00 •XLookup: 00:08:00 •Handling #NA and Approximates match in XLookup: 00:11:00 •Wildcard matching in XLookup: 00:06:00 •Introduction: 00:02:00 •Split text into columns: 00:07:00 •Flash Fill: 00:07:00 •Remove Duplicates: 00:08:00 •Data Validation: 00:07:00 •Get- import Data from Text: 00:06:00 •Get - import Data from CSV: 00:03:00 •Introduction: 00:01:00 •Formatting Font: 00:04:00 •Formatting Alignment: 00:06:00 •Formatting Number: 00:05:00 •Formatting Date: 00:03:00 •Formatting tables: 00:05:00 •Introduction: 00:01:00 •Creating Pivot Table: 00:07:00 •Value field settings: 00:04:00 •Number format: 00:02:00 •Pivot Table Design: 00:03:00 •Excel Exercise: 00:01:00 •Solution for Excel Exercise: 00:02:00 •Introduction: 00:01:00 •Excel Charts - Categories: 00:03:00 •Elements of a chart: 00:04:00 •Easy way to create charts: 00:02:00 •Column or Bar charts: 00:04:00 •Formatting charts: 00:04:00 •Line charts: 00:02:00 •Area charts: 00:02:00 •Pie and Doughnut charts: 00:04:00 •Format AreaPlot or XY chart: 00:08:00 •Scatter or bubble charts: 00:02:00 •Introduction: 00:01:00 •Frequency Distribution and Histograms: 00:04:00 •Waterfall charts: 00:02:00 •Hierarchy charts: sunburst and tree map: 00:03:00 •Combination charts: 00:02:00 •Sparklines: 00:05:00 •Pivot charts: 00:02:00 •Maps chart: 00:04:00 •3D Maps chart: 00:03:00 •Introduction: 00:01:00 •Stock charts: 00:02:00 •Radar charts: 00:02:00 •Surface charts: 00:02:00 •Heat maps: 00:04:00 •Named ranges: 00:05:00 •Indirect Name range Function: 00:06:00 •Import Data table from PDF file - Excel 2021: 00:04:00 •Import Data from Website - Excel 2019 above: 00:09:00 •Project: Sales forecast tracker: 00:07:00 •Product Sale Tax invoice: Tax Calculations: 00:05:00

Microsoft Excel Course for Everyone - Complete Excel Course
Delivered Online On Demand6 hours 51 minutes
£12