11046 Video courses in Cardiff delivered On Demand

Description: Microsoft Excel, developed by Microsoft Corporation, is world's leading spreadsheet program for Windows, macOS, Android and iOS. The program includes calculation, graphing tools, pivot tables, and a macro programming language called Visual Basic for Applications to make your task easy and for saving your precious time. You can hardly find any company where Microsoft Excel is not used. The knowledge of Excel is a must for meeting any career perspective. The course will help you to achieve the goals. The course is divided into three parts - beginners, intermediate and advanced. Therefore after completing the bundle video course, you will be a prolific user of the program. As the course is sectioned based on the level of difficulty, you will know the basics of Excel at first. You will know how to open an excel program, how to put data or know some simple calculations. After the primary knowledge, you will be introduced to some more features and functions of the program such as analyse massive amounts of data, extract actionable information from it, etc. Finally, you will learn the advanced features of Excel program that allows you take the right business decisions for your company. Assessment: At the end of the course, you will be required to sit for an online MCQ test. Your test will be assessed automatically and immediately. You will instantly know whether you have been successful or not. Before sitting for your final exam you will have the opportunity to test your proficiency with a mock exam. 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? Microsoft Office 2016 Excel Complete Video Course - Beginner, Intermediate & Advanced 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 Microsoft Office 2016 Excel Complete Video Course - Beginner, Intermediate & Advanced 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. Getting Started with Microsoft Office Excel 2016 Navigate the Excel User Interface FREE 00:28:00 Use Excel Commands 00:10:00 Create and Save a Basic Workbook 00:19:00 Enter Cell Data 00:12:00 Use Excel Help 00:05:00 Performing Calculations Create Worksheet Formulas 00:15:00 Insert Functions 00:17:00 Reuse Formulas and Functions 00:17:00 Modifying a Worksheet 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 Formatting a Worksheet Apply Text Formats 00:17:00 Apply Number Format 00:08:00 Align Cell Contents 00:09:00 Apply Styles and Themes 00:12:00 Apply Basic Conditional Formatting 00:11:00 Create and Use Templates 00:07:00 Printing Workbooks Preview and Print a Workbook 00:10:00 Set Up the Page Layout 00:08:00 Configure Headers and Footers 00:07:00 Managing Workbooks Manage Worksheets 00:05:00 Manage Workbook and Worksheet Views 00:07:00 Manage Workbook Properties 00:05:00 Working with Functions Work with Ranges FREE 00:18:00 Use Specialized Functions 00:11:00 Work with Logical Functions 00:23:00 Work with Date & Time Functions 00:08:00 Work with Text Functions 00:11:00 Working with Lists 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 Analyzing Data Create and Modify Tables 00:15:00 Apply Intermediate Conditional Formatting 00:07:00 Apply Advanced Conditional Formatting 00:05:00 Visualizing Data with Charts Create Charts 00:13:00 Modify and Format Charts 00:12:00 Use Advanced Chart Features 00:12:00 Using PivotTables and PivotCharts 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 Working with Multiple Worksheets and Workbooks Use Links and External References FREE 00:12:00 Use 3-D References 00:06:00 Consolidate Data 00:05:00 Using Lookup Functions and Formula Auditing Use Lookup Functions 00:12:00 Trace Cells 00:09:00 Watch and Evaluate Formulas 00:08:00 Sharing and Protecting Workbooks Collaborate on a Workbook 00:19:00 Protect Worksheets and Workbooks 00:08:00 Automating Workbook Functionality Apply Data Validation 00:13:00 Search for Invalid Data and Formulas with Errors 00:04:00 Work with Macros 00:18:00 Creating Sparklines and Mapping Data Create Sparklines 00:07:00 MapData 00:07:00 Forecasting Data 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 Refer A Friend Refer A Friend 00:00:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Course Overview The way you treat your customers can make or break the deal. That's why the first rule of building a successful business is excellent customer service.  Learn the fundamentals of this vital area of business with our top-notch Customer Service Skills Training course. This is a course that will help you work on your skills and increase the potential of your career. The course will be delivered through engaging video lessons. Through these lessons, you will be able to deepen your knowledge of Customer Relationship Management. Then the course will educate you on effective communication strategies with consumers. In addition, you will get the chance to develop the skills required for dealing with customer complaints. By the end of the course, you will learn the ways you can improve customer service and create a satisfied customer base.  So, join today and master the art of customer service! Course Sneak Peek Learning Outcomes Recognise the characteristics of quality customer service Understand the major principles of customer relationship management Develop the skills to establish effective communication with your customers Build the competence to handle customer complaints with expertise Identify the vital areas for improving the quality of customer service Course Promo Why Should Take This Course From John Academy? Affordable, well-structured and high-quality e-learning study materials Engaging tutorial videos, materials from the industry-leading experts Opportunity to study in a user-friendly, advanced online learning platform Efficient exam systems for the assessment and instant result Earn UK & internationally recognised accredited qualification Easily access the course content on mobile, tablet, or desktop from anywhere, anytime Excellent career advancement opportunities Get 24/7 student support via email. What Skills Will You Learn from This Course? Communication Customer service Problem-solving Customer relationship management Who Should Take this Customer Service Skills Training? Whether you're an existing practitioner or an aspiring professional, this course will enhance your expertise and boost your CV with key skills and a recognised qualification attesting to your knowledge. Are There Any Entry Requirements? This Customer Service Skills Training is available to all learners of all academic backgrounds. But learners should be aged 16 or over to undertake the qualification. And a good understanding of the English language, numeracy, and ICT will be helpful. Certificate of Achievement After completing this course successfully, you will be able to obtain an Accredited Certificate of Achievement. Certificates & Transcripts can be obtained either in Hardcopy at £14.99 or in PDF format at £11.99. Career Path This exclusive Customer Service Skills Training course will equip you with effective skills and abilities and help you explore career paths such as  ManagerCustomer Service Executive Retail Manager Course Curriculum Module 01: Introduction to Customer Service Introduction to Customer Service 00:06:00 Module 02: Characteristics of Good Customer Service Characteristics of Good Customer Service 00:04:00 Module 03: Customer Relationship Management Customer Relationship Management 00:04:00 Module 04: Communicate with Customers Communicate with Customers 00:06:00 Module 05: Handling Customer Complaints Handling Customer Complaints 00:06:00 Module 06: Problem Solving Over Phone Problem Solving Over Phone 00:05:00 Module 07: Improving Customer Service Improving Customer Service 00:07:00 Order Your Certificates and Transcripts Order Your Certificates and Transcripts 00:00:00

This course covers all the requirements of the Microsoft AZ-300 and AZ-303 exams. You will get a detail-oriented approach to all the important concepts that will help you pass the exams and design solutions for the Microsoft Azure platform.

MySQL: Learn how to use MySQL and PHP to build reports and work with databases for web applications

Quality Guarantee: Promising training excellence, satisfaction gurantee Accredited by CPD UK & Quality License Scheme Tutor Support Unlimited support via email, till you complete the course Recognised Certification: Accepted by thousands of professional bodies Start Anytime With 1 year access to the course materials Online Learning Learn from anywhere, whenever you want This Photoshop CC Advanced Training Course will provide advanced techniques, time-saving shortcuts and innovative features empowering you to produce visually captivating masterpieces. This course at a glance Accredited by CPD UK Endorsed by Quality Licence Scheme Gain a comprehensive understanding of the features of Photoshop Realise the power of Photoshop Learn to save files in Photoshop in different formats like psd, jpeg, psb, tiff and png Know the layers concept in Photoshop and learn to handle them Learn the transformation & perspective tweaking in Photoshop Understand the design & work precisely in Photoshop Learn about the brushes & digital painting in Photoshop Recognise the drawing & vector shapes in Photoshop Know the selection & masking in Photoshop Learn about the smart objects in Photoshop Learn 3D in Photoshop Understand animation & video editing in Photoshop Why Photoshop CC Advanced Training Course right for you? This Photoshop course online will help you understand the fundamental and advanced features of Photoshop and help you boost your career in the same. You will start the course by learning its benninger level aspects like creating Photoshop documents, navigating in Photoshop, cropping images, etc. This online Photoshop CC advanced training course will introduce you to advanced features like layers, panels and blend mode and help you practice the same. After taking this popular online course, you will also learn about drawing, vector shapes, selection, masking, brushes, digital painting, and much more. By the end of the course, you will obtain a comprehensive understanding of the basic and advanced features of Photoshop and learn how to edit any image using Photoshop. After finishing this career-advancement online course, you will also develop the skills required to kickstart your career in graphics designing. Photoshop CC Advanced Training Course Details Accredited by CPD certificates are accepted by thousands of professional bodies and government regulators here in the UK and around the world. Many organisations look for employees with CPD requirements, which means, that by doing this course, you would be a potential candidate in your respective field.   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. Course Curriculum Photoshop Orientation & Essentials Photoshop Course Promo & Outline The Power of Photoshop Photoshop Course Resources & Best Learning Experience Creating Photoshop Documents Photoshop's Workspaces & Orientation Navigation in Photoshop Cropping Images & Different Photoshop's Cropping Ratios Color Modes in Photoshop Resolution Concept & Enlarging Images While Preserving Quality Cloud Documents ( Photoshop CC 2020 ) Photoshop CC 2020 Close Others New Feature Layers in Photoshop Layers Concept in Photoshop & Handling Them Photoshop's Layer Panel Unleash Creativity with Blend Modes in Photoshop Photoshop 2020 New Layers Navigation Layer Styles Transformation & Perspective Tweaking in Photoshop Transformation Modes & Tricks Puppet Warp in Photoshop Perspective Warp in Photoshop Design & Work Precisely in Photoshop Align & Distribute in Photoshop Mastering Precision in Photoshop (Guides, Grids, Rulers, Snap) Brushes & Digital Painting in Photoshop Brush Basics, The Color Panel & Symmetrical Drawing in Photoshop Brushes Panel & Getting Cool Photoshop Brushes Creating Photoshop Brushes & Brush Settings Digital Painting Essentials, Mixer Brush & Color Replacement Brush Tools Digital Painting Essentials Tutorial in Photoshop Updated Presets (Photoshop 2020) Drawing & Vector Shapes in Photoshop Vector Shapes Tools & Essentials in Photoshop Unified Transformation (Photoshop CC 2020) Live Shapes & Path Operations in Photoshop Selection & Masking in Photoshop Photoshop's Selection Concept & Basics part1 Photoshop's Selection Concept & Basics (Part 2) Photoshop's Selection Tools (Part 1) Object Selection Tool (Photoshop 2020) Photoshop Masking & Non Destructive Editing Focus Range Combined with Photoshop's Selection Tools Color Range Selection & Photo Manipulation Techniques Soft Edges Selection Tricks in Photoshop Pen Tools & Curvature Tool & Vector Masks in Photoshop Smart Objects in Photoshop Raster Smart Objects in Photoshop Vector Smart Objects & Photoshop's Linked Files Smart Objects to Layers (Photoshop CC 2020) Photoshop's Smart Filters Adjustments Layers in Photoshop Photoshop Adjustment Layers Fundamentals Color Adjustment Layers in Photoshop Exposure in Photography Explained Tonal & Contrast Adjustment Layers in Photoshop Image Retouching & Manipulation in Photoshop Photoshop Liquify Filter Spot Healing Brushes & Patch Tool (Photoshop Retouching Tools) Content Aware Fill (Photoshop CC) Content Aware Fill Update (Photoshop 2020) Content Aware Scaling (Enlarging Images without Distortion in Photoshop) Content-Aware: Move-Extend Tool (Photoshop CC) Clone Stamp Tools & Smudge Tool (Photoshop) Dodge, burn & Sponge Tools (Photoshop) Photoshop Retouching Project Part1 (Editing (Camera Raw Settings)) Photoshop Retouching Project Pt2 (Body,Skin,Hair,Shadows Highlights) Photoshop Retouching Project Pt3 (Eyes) Photoshop Retouching Project 4 (Final Blending Touch) Fix & Whiten Teeth in Photoshop (Natural look) Photoshop Project: Repairing Damaged Images & Coloring Them Pt1 (Fixing) Photoshop Project: Repairing Damaged Images Pt2 (Coloring) Creating Mockups Using Vanishing Point Clone Stamp in Vanishing Point Enhanced Filters (Photoshop CC 2020) Typography in Photoshop Font Selection & Filtering in Photoshop Photoshop Character Control Panel Photoshop Paragraph Control Panel Text Improvements (Photoshop CC 2020) Photoshop Character & Paragraph Styles Panel 3D Neon Type Effect (Nike Ad) Photoshop Advanced Type Details Text Warp & Typing on a Path in Photoshop Creative Typography Design Ideas Animated Gifts & Video Editing in Photoshop Creating Animated Gifs & Videos in Photoshop Save As Gifs (Photoshop CC 2020) Video Editing in Photoshop (Complete Video Project) Finalizing & Exporting Files from Photoshop Preparing Our Files for Printing & Creating PDF Files from Photoshop Image Optimization & Save for Web Import from Device (Photoshop CC 2020) 3D in Photoshop Turning Images 2D into 3D in Photoshop 3D Layers & Moving Cameras & Elements in Photoshop 3D Mode Adding Materials & Saving 3D Views in Photoshop Lights in 3d & Exporting from Photoshop Creating 3D Animation in Photoshop Who should take this course? This comprehensive course is suitable for anyone looking to improve their job prospects or aspiring to accelerate their career in this sector and want to gain in-depth knowledge of Photoshop. Entry Requirements There are no academic entry requirements for this course, and it is open to students of all academic backgrounds. However, you are required to have a laptop/desktop/tablet or smartphone and a good internet connection. Assessment Method This Photoshop CC advanced training 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%. Certification Endorsed Certificate from Quality Licence Scheme After successfully passing the MCQ exam you will be eligible to order the Endorsed Certificate by Quality Licence Scheme. 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. It will give you a competitive advantage in your career, making you stand out from all other applicants and employees. There is a Quality Licence Scheme endorsement fee to obtain an endorsed certificate which is £65. Certificate of Achievement from Lead Academy After successfully passing the MCQ exam you will be eligible to order your certificate of achievement as proof of your new skill. The certificate of achievement is an official credential that confirms that you successfully finished a course with Lead Academy. Certificate can be obtained in PDF version at a cost of £12, and there is an additional fee to obtain a printed copy certificate which is £35. FAQs Is CPD a recognised qualification in the UK? CPD is globally recognised by employers, professional organisations and academic intuitions, thus a certificate from CPD Certification Service creates value towards your professional goal and achievement. CPD-certified certificates are accepted by thousands of professional bodies and government regulators here in the UK and around the world. Are QLS courses recognised? Although QLS courses are not subject to Ofqual regulation, they must adhere to an extremely high level that is set and regulated independently across the globe. A course that has been approved by the Quality Licence Scheme simply indicates that it has been examined and evaluated in terms of quality and fulfils the predetermined quality standards. When will I receive my certificate? For CPD accredited PDF certificate it will take 24 hours, however for the hardcopy CPD certificate takes 5-7 business days and for the Quality License Scheme certificate it will take 7-9 business days. Can I pay by invoice? Yes, you can pay via Invoice or Purchase Order, please contact us at info@lead-academy.org for invoice payment. Can I pay via instalment? Yes, you can pay via instalments at checkout. How to take online classes from home? Our platform provides easy and comfortable access for all learners; all you need is a stable internet connection and a device such as a laptop, desktop PC, tablet, or mobile phone. The learning site is accessible 24/7, allowing you to take the course at your own pace while relaxing in the privacy of your home or workplace. Does age matter in online learning? No, there is no age limit for online learning. Online learning is accessible to people of all ages and requires no age-specific criteria to pursue a course of interest. As opposed to degrees pursued at university, online courses are designed to break the barriers of age limitation that aim to limit the learner's ability to learn new things, diversify their skills, and expand their horizons. When I will get the login details for my course? After successfully purchasing the course, you will receive an email within 24 hours with the login details of your course. Kindly check your inbox, junk or spam folder, or you can contact our client success team via info@lead-academy.org

REST or RESTful API design (Representational State Transfer) is designed to take advantage of existing protocols. Django REST framework is a powerful and flexible toolkit to build web APIs. Throughout the course, we will explore the most important Django Rest framework topics step-by-step. We will learn topics such as API basics, serializers, class-based views, and so on to build flexible APIs.

Level 5 QLS Endorsed Diploma | 150 CPD Points | +Gifts: QLS Certificate + PDF Certificate | 24/7 Learner Support

This course takes you through all the important topics of data structure and algorithms from scratch. You will learn how to solve real-world problems with linked lists, stacks, queues, sorting algorithms, and a lot more using Python.

This course will take you through the concepts of PMBOK (Project Management Body of Knowledge) and will prepare you for the PgMP certification exam. With the help of this course, you will be able to access the lesson-end quizzes and course-end assessments, which will prepare you for the certification exam.

This course aims to explain how to get the best picture quality using off-camera flash.