521 Courses in Cardiff delivered Online

This course will show you how to create simple, intermediate, and advanced REST APIs for authentication, deployment, caching, and much more. You will also cover essential technologies such as Flask and popular extensions such as Flask-Smorest, Flask-JWT-Extended, and Flask-SQLAlchemy; we will dive right into developing complete, solid, production-ready REST APIs.

Dive into the comprehensive world of Entity Framework Core with this detailed course, designed to equip you with the skills to efficiently use EF Core in .NET applications.

Overview Increase Revenue with an Effective Go-To-Market Strategy 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 Increase Revenue with an Effective Go-To-Market Strategy 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 05 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. Section 01: Create a Unique Competitive Advantage Unique Competitive Advantage Explained 00:05:00 Unique Competitive Advantage - Company Examples 00:03:00 How to Determine Your Unique Competitive Advantage 00:01:00 Step 1 - Evaluate Your Strengths 00:02:00 Step 2 - Evaluate Your Competitive Landscape 00:03:00 Step 3 - Identify Your Unique Competitive Advantage 00:04:00 Step 4 - Test Your Unique Competitive Advantage 00:02:00 Common Mistakes 00:02:00 Workshop - Unique Competitive Advantage in Action 00:03:00 Section 02: Positioning Product or Service Positioning is about Your Customer's Point of View 00:08:00 What Investors Are Looking for 00:02:00 Ben and Jerry's Case Study 00:02:00 Keys to Success 00:03:00 The Positioning Framework Overview 00:06:00 Step 1 - Create Meaningful Attributes - Part 1 00:05:00 Step 1 - Create Meaningful Attributes - Part 2 00:06:00 Step 1 - Create Meaningful Attributes - Part 3 00:05:00 Viking Cruises - Case Study 00:02:00 Step 2 - Custom Attributes 00:04:00 Step 3- Evaluate / Rank Attributes 00:04:00 Step 4 - Evaluating Positioning Rankings 00:03:00 Step 5 - Positioning of Your Attributes 00:02:00 Step 6 - Your Positioning Statement 00:04:00 Common Mistakes 00:02:00 Workshop - Position Your Product or Service in Action 00:03:00 Section 03: Determine Your Target Market Target Market Essentials 00:05:00 Why is Your Target Market So Important? 00:05:00 Define Your Target Market 00:02:00 Step 1 - Define Standard Attributes - Demographics 00:06:00 Step 1 (continued) - Define Standard Attributes - More Demographics 00:05:00 Step 1 (continued) - Define Standard Attributes - Psychographics 00:06:00 Step 2 - Develop Custom Attributes 00:10:00 Step 3 - Validation 00:01:00 Step 4 - Adjust Your Strategy 00:02:00 Workshop - Developing Your Target Market 00:02:00 Section 04: Build a Compelling Value Proposition Characteristics of Unique Value Propositions 00:02:00 Types of Customer Benefits UVPs Express 00:04:00 Examples of Unique Value Propositions 00:01:00 What Investors Are Looking For 00:01:00 Value Proposition vs. Competitive Advantage 00:02:00 Understand Your Competitor's Unique Value Proposition 00:03:00 Streaming Services Example 00:02:00 The Value Proposition Framework 00:01:00 Step 1 - Brainstorming 00:07:00 Step 2 - Create a Value Proposition List 00:01:00 Step 3 - Determine Uniqueness 00:03:00 Step 4 - Prioritize Top Value Propositions 00:02:00 Step 5 - Tell a Story 00:04:00 Common Mistakes 00:01:00 Workshop - Build Your Unique Value Proposition 00:04:00 Downloadable Resources Resource - Increase Revenue with an Effective Go-To-Market Strategy 00:00:00

Course Overview To create interactive and effective web applications, JavaScript is one of the first choices for developers. Learn how you can use JavaScript and node.js to make your website more interactive and entertaining from this Learn Node.JS Framework in 2021 course and boost and update your programming skill. The Learn Node.JS Framework in 2021 course will teach you the steps of creating websites using JavaScript from scratch. You will familiarize yourself with the concepts of JavaScript and node.js, how node.js works and its beauty. You will learn about node package manager, asynchronous JavaScript and promises, event emitter, file system, creating a path and many other functions that node.js offers. This course will also help you to create a strong authentication and verification system so that you can secure your website from common threats and get notifications if there is any problem. This course is helpful to learn web development and will assist you to increase your skill in no time. Learning Outcomes Familiarize with node.js basics Be able to create API development Understand the basics of asynchronous JavaScript Learn how to create a login system and password hashing Be able to secure your device using user verification, data validation and email verification using node.js Learn in detail about authentication and authorization system Who is this course for? This course is ideal for anyone who wants to learn web designing or web development and use JavaScript to design their websites. This course will help you to understand the functions of JavaScript and node.js and how to design websites from scratch. 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. Certification After you have successfully completed the course, 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 Learn Node.JS Framework in 2021 is a useful qualification to possess and would be beneficial for any related profession or industry such as: JavaScript Developers Web Developers App Developers Software Engineers Programmers Unit 01: Introduction Module 01: Introduction 00:02:00 Unit 02: Node.js Basics Module 01: Introduction 00:01:00 Module 02: What's & Why Node.js? 00:07:00 Module 03: Installation 00:01:00 Module 04: First Node.js app 00:12:00 Module 05: Mechanism of Node.js 00:07:00 Module 06: Event Loop 00:09:00 Module 07: Loop tick 00:04:00 Module 08: Modules 00:07:00 Unit 03: Asynchronous JavaScript Module 01: Introduction 00:01:00 Module 02: JSON format 00:03:00 Module 03: Callback pattern 1 00:05:00 Module 04: Callback pattern 2 00:03:00 Module 05: Callback hell 00:01:00 Module 06: Promises pattern 1 00:02:00 Module 07: Promises pattern 2 00:02:00 Module 08: Master promises 1 00:03:00 Module 09: Master promises 2 00:05:00 Module 10: async/await pattern 1 00:02:00 Module 11: async/await pattern 2 00:02:00 Module 12: Promisify a function 00:03:00 Unit 04: Core Modules Module 01: Introduction 00:01:00 Module 02: Event emitter I 00:03:00 Module 03: Event emitter II 00:02:00 Module 04: Event emitter III 00:03:00 Module 05: File system I 00:02:00 Module 06: File system II 00:01:00 Module 07: File system III 00:04:00 Module 08: Streams I 00:03:00 Module 09: Streams II 00:02:00 Module 10: Path I 00:02:00 Module 11: Path II 00:02:00 Module 12: Path III 00:02:00 Unit 05: npm Module 01: Introduction 00:01:00 Module 02: package.json file 00:01:00 Module 03: Commands I 00:02:00 Module 04: Commands II 00:03:00 Module 05: Commands III 00:04:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Microsoft Excel 2019 for Beginner course teaches you everything on the topic thoroughly from scratch so you can claim a certificate of achievement for free to showcase your achievement in professional life. This course is a comprehensive, instructor-guided course, designed to provide a detailed understanding of the nature of the related sector and your key roles within it. To become successful in your profession, you must have a specific set of skills to succeed in today's competitive world. In this in-depth training course, you will develop the most in-demand skills to kickstart your career, as well as upgrade your existing knowledge & skills. The training materials of this course are available online for you to learn at your own pace and fast-track your career with ease. Key Features of the Microsoft Excel 2019 for Beginner Course : Instant e-certificate and hard copy dispatch by next working day Fully online, interactive course with audio voiceover Developed by professionals in the field Self-paced learning and laptop, tablet, smartphone-friendly 24/7 Learning Assistance Discounts on bulk purchases *** Additional Gifts *** Free Life coaching Course *** (Offer Ends Soon) *** Course Curriculum The detailed curriculum outline of our Microsoft Excel 2019 for Beginner course is as follows: ***Microsoft Excel 2019*** Microsoft Excel 2019 New Features Introduction to Microsoft Excel 2019 New Features CONCAT IFS MAXIFS MINIFS SWITCH TEXTJOIN Map Chart Funnel Chart Better Visuals Pivot Table Enhancements Power Pivot Updates Getting Started with Microsoft Office Excel Navigate the Excel User Interface Use Excel Commands Create and Save a Basic Workbook Enter Cell Data Use Excel Help Performing Calculations Create Worksheet Formulas Insert Functions Reuse Formulas and Functions Modifying a Worksheet Insert, Delete, and Adjust Cells, Columns, and Rows Search for and Replace Data Use Proofing and Research Tools Formatting a Worksheet Apply Text Formats Apply Number Format Align Cell Contents Apply Styles and Themes Apply Basic Conditional Formatting Create and Use Templates Printing Workbooks Preview and Print a Workbook Set Up the Page Layout Configure Headers and Footers Managing Workbooks Manage Worksheets Manage Workbook and Worksheet Views Manage Workbook Properties Working with Functions Work with Ranges Use Specialized Functions Work with Logical Functions Work with Date & Time Functions Work with Text Functions Working with Lists Sort Data Filter Data Query Data with Database Functions Outline and Subtotal Data Analyzing Data Apply Intermediate Conditional Formatting Apply Advanced Conditional Formatting Visualizing Data with Charts Create Charts Modify and Format Charts Use Advanced Chart Features Using PivotTables and PivotCharts Create a PivotTable Analyze PivotTable Data Present Data with PivotCharts Filter Data by Using Timelines and Slicers Working with Multiple Worksheets and Workbooks Use Links and External References Use 3-D References Consolidate Data Using Lookup Functions and Formula Auditing Use Lookup Functions Trace Cells Watch and Evaluate Formulas Sharing and Protecting Workbooks Collaborate on a Workbook Protect Worksheets and Workbooks Automating Workbook Functionality Apply Data Validation Search for Invalid Data and Formulas with Errors Work with Macros Creating Sparklines and Mapping Data Create Sparklines MapData Forecasting Data Determine Potential Outcomes Using Data Tables Determine Potential Outcomes Using Scenarios Use the Goal Seek Feature Forecasting Data Trends Who is this course for? Anyone with a knack for learning new skills can take this Microsoft Excel 2019 for Beginner course. While this comprehensive training is popular for preparing people for job opportunities in the relevant fields, it also helps to advance your career for promotions. Accreditation All of our courses, including this course, are fully accredited, providing you with up-to-date skills and knowledge and helping you to become more competent and effective in your chosen field. Certification Once you've successfully completed your course, you will immediately be sent a digital certificate. Also, you can have your printed certificate delivered by post (shipping cost £3.99). Our certifications have no expiry dates, although we do recommend that you renew them every 12 months. Assessment At the end of the course, there will be an online assessment, which you will need to pass to complete the course. Answers are marked instantly and automatically, allowing you to know straight away whether you have passed. If you haven't, there's no limit on the number of times you can take the final exam. All this is included in the one-time fee you paid for the course itself. Requirements The Microsoft Excel 2019 is open to all students and has no formal entry requirements. To study the Microsoft Excel course, all your need is a passion for learning, a good understanding of English, numeracy, and IT skills. You must also be over the age of 16. Career path This course will give you a comprehensive understanding of the Microsoft Excel platform and assist you in pursuing several exciting employment opportunities, such as - Administrative Assistant Accountants Business Analyst Cost Estimator Data Entry Specialist Project Manager And many more! These job prospects pay an average of £15k to £55k a year in the UK. Certificates Digital certificate Digital certificate - Included Hard copy certificate Hard copy certificate - Included You will get the hard copy certificates for Free! The delivery charge of the hard copy certificate inside the UK is £3.99 each.

The course 'Deep Learning & Neural Networks Python - Keras' provides a comprehensive introduction to deep learning using the Keras library in Python. It covers topics ranging from basic neural networks to more advanced concepts, such as convolutional neural networks, image augmentation, and performance improvement techniques for various datasets. Learning Outcomes: Understand the fundamental concepts of deep learning and how it differs from traditional machine learning. Gain proficiency in using Keras, a powerful deep learning library, for building and training neural network models. Develop practical skills in creating and optimizing neural network models for different datasets, including image recognition tasks and regression problems. Why buy this Deep Learning & Neural Networks Python - Keras? 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 Deep Learning & Neural Networks Python - Keras 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 course for? This Deep Learning & Neural Networks Python - Keras course is ideal for Students Recent graduates Job Seekers Anyone interested in this topic People already working in the relevant fields and want to polish their knowledge and skill. Prerequisites This Deep Learning & Neural Networks Python - Keras does not require you to have any prior qualifications or experience. You can just enrol and start learning.This Deep Learning & Neural Networks Python - Keras 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 As this course comes with multiple courses included as bonus, you will be able to pursue multiple occupations. This Deep Learning & Neural Networks Python - Keras is a great way for you to gain multiple skills from the comfort of your home. Course Curriculum Course Introduction and Table of Contents Course Introduction and Table of Contents 00:11:00 Deep Learning Overview Deep Learning Overview - Theory Session - Part 1 00:06:00 Deep Learning Overview - Theory Session - Part 2 00:07:00 Choosing Between ML or DL for the next AI project - Quick Theory Session Choosing Between ML or DL for the next AI project - Quick Theory Session 00:09:00 Preparing Your Computer Preparing Your Computer - Part 1 00:07:00 Preparing Your Computer - Part 2 00:06:00 Python Basics Python Basics - Assignment 00:09:00 Python Basics - Flow Control 00:09:00 Python Basics - Functions 00:04:00 Python Basics - Data Structures 00:12:00 Theano Library Installation and Sample Program to Test Theano Library Installation and Sample Program to Test 00:11:00 TensorFlow library Installation and Sample Program to Test TensorFlow library Installation and Sample Program to Test 00:09:00 Keras Installation and Switching Theano and TensorFlow Backends Keras Installation and Switching Theano and TensorFlow Backends 00:10:00 Explaining Multi-Layer Perceptron Concepts Explaining Multi-Layer Perceptron Concepts 00:03:00 Explaining Neural Networks Steps and Terminology Explaining Neural Networks Steps and Terminology 00:10:00 First Neural Network with Keras - Understanding Pima Indian Diabetes Dataset First Neural Network with Keras - Understanding Pima Indian Diabetes Dataset 00:07:00 Explaining Training and Evaluation Concepts Explaining Training and Evaluation Concepts 00:11:00 Pima Indian Model - Steps Explained Pima Indian Model - Steps Explained - Part 1 00:09:00 Pima Indian Model - Steps Explained - Part 2 00:07:00 Coding the Pima Indian Model Coding the Pima Indian Model - Part 1 00:11:00 Coding the Pima Indian Model - Part 2 00:09:00 Pima Indian Model - Performance Evaluation Pima Indian Model - Performance Evaluation - Automatic Verification 00:06:00 Pima Indian Model - Performance Evaluation - Manual Verification 00:08:00 Pima Indian Model - Performance Evaluation - k-fold Validation - Keras Pima Indian Model - Performance Evaluation - k-fold Validation - Keras 00:10:00 Pima Indian Model - Performance Evaluation - Hyper Parameters Pima Indian Model - Performance Evaluation - Hyper Parameters 00:12:00 Understanding Iris Flower Multi-Class Dataset Understanding Iris Flower Multi-Class Dataset 00:08:00 Developing the Iris Flower Multi-Class Model Developing the Iris Flower Multi-Class Model - Part 1 00:09:00 Developing the Iris Flower Multi-Class Model - Part 2 00:06:00 Developing the Iris Flower Multi-Class Model - Part 3 00:09:00 Understanding the Sonar Returns Dataset Understanding the Sonar Returns Dataset 00:07:00 Developing the Sonar Returns Model Developing the Sonar Returns Model 00:10:00 Sonar Performance Improvement - Data Preparation - Standardization Sonar Performance Improvement - Data Preparation - Standardization 00:15:00 Sonar Performance Improvement - Layer Tuning for Smaller Network Sonar Performance Improvement - Layer Tuning for Smaller Network 00:07:00 Sonar Performance Improvement - Layer Tuning for Larger Network Sonar Performance Improvement - Layer Tuning for Larger Network 00:06:00 Understanding the Boston Housing Regression Dataset Understanding the Boston Housing Regression Dataset 00:07:00 Developing the Boston Housing Baseline Model Developing the Boston Housing Baseline Model 00:08:00 Boston Performance Improvement by Standardization Boston Performance Improvement by Standardization 00:07:00 Boston Performance Improvement by Deeper Network Tuning Boston Performance Improvement by Deeper Network Tuning 00:05:00 Boston Performance Improvement by Wider Network Tuning Boston Performance Improvement by Wider Network Tuning 00:04:00 Save & Load the Trained Model as JSON File (Pima Indian Dataset) Save & Load the Trained Model as JSON File (Pima Indian Dataset) - Part 1 00:09:00 Save & Load the Trained Model as JSON File (Pima Indian Dataset) - Part 2 00:08:00 Save and Load Model as YAML File - Pima Indian Dataset Save and Load Model as YAML File - Pima Indian Dataset 00:05:00 Load and Predict using the Pima Indian Diabetes Model Load and Predict using the Pima Indian Diabetes Model 00:09:00 Load and Predict using the Iris Flower Multi-Class Model Load and Predict using the Iris Flower Multi-Class Model 00:08:00 Load and Predict using the Sonar Returns Model Load and Predict using the Sonar Returns Model 00:10:00 Load and Predict using the Boston Housing Regression Model Load and Predict using the Boston Housing Regression Model 00:08:00 An Introduction to Checkpointing An Introduction to Checkpointing 00:06:00 Checkpoint Neural Network Model Improvements Checkpoint Neural Network Model Improvements 00:10:00 Checkpoint Neural Network Best Model Checkpoint Neural Network Best Model 00:04:00 Loading the Saved Checkpoint Loading the Saved Checkpoint 00:05:00 Plotting Model Behavior History Plotting Model Behavior History - Introduction 00:06:00 Plotting Model Behavior History - Coding 00:08:00 Dropout Regularization - Visible Layer Dropout Regularization - Visible Layer - Part 1 00:11:00 Dropout Regularization - Visible Layer - Part 2 00:06:00 Dropout Regularization - Hidden Layer Dropout Regularization - Hidden Layer 00:06:00 Learning Rate Schedule using Ionosphere Dataset - Intro Learning Rate Schedule using Ionosphere Dataset 00:06:00 Time Based Learning Rate Schedule Time Based Learning Rate Schedule - Part 1 00:07:00 Time Based Learning Rate Schedule - Part 2 00:12:00 Drop Based Learning Rate Schedule Drop Based Learning Rate Schedule - Part 1 00:07:00 Drop Based Learning Rate Schedule - Part 2 00:08:00 Convolutional Neural Networks - Introduction Convolutional Neural Networks - Part 1 00:11:00 Convolutional Neural Networks - Part 2 00:06:00 MNIST Handwritten Digit Recognition Dataset Introduction to MNIST Handwritten Digit Recognition Dataset 00:06:00 Downloading and Testing MNIST Handwritten Digit Recognition Dataset 00:10:00 MNIST Multi-Layer Perceptron Model Development MNIST Multi-Layer Perceptron Model Development - Part 1 00:11:00 MNIST Multi-Layer Perceptron Model Development - Part 2 00:06:00 Convolutional Neural Network Model using MNIST Convolutional Neural Network Model using MNIST - Part 1 00:13:00 Convolutional Neural Network Model using MNIST - Part 2 00:12:00 Large CNN using MNIST Large CNN using MNIST 00:09:00 Load and Predict using the MNIST CNN Model Load and Predict using the MNIST CNN Model 00:14:00 Introduction to Image Augmentation using Keras Introduction to Image Augmentation using Keras 00:11:00 Augmentation using Sample Wise Standardization Augmentation using Sample Wise Standardization 00:10:00 Augmentation using Feature Wise Standardization & ZCA Whitening Augmentation using Feature Wise Standardization & ZCA Whitening 00:04:00 Augmentation using Rotation and Flipping Augmentation using Rotation and Flipping 00:04:00 Saving Augmentation Saving Augmentation 00:05:00 CIFAR-10 Object Recognition Dataset - Understanding and Loading CIFAR-10 Object Recognition Dataset - Understanding and Loading 00:12:00 Simple CNN using CIFAR-10 Dataset Simple CNN using CIFAR-10 Dataset - Part 1 00:09:00 Simple CNN using CIFAR-10 Dataset - Part 2 00:06:00 Simple CNN using CIFAR-10 Dataset - Part 3 00:08:00 Train and Save CIFAR-10 Model Train and Save CIFAR-10 Model 00:08:00 Load and Predict using CIFAR-10 CNN Model Load and Predict using CIFAR-10 CNN Model 00:16:00 RECOMENDED READINGS Recomended Readings 00:00:00

Gain the skills and credentials to kickstart a successful career and learn from the experts with this step-by-step

Duration 5 Days 30 CPD hours This course is intended for This class is ideal for experienced Salesforce Administrators, business analysts, and implementation specialists looking to gain a greater technical understanding of Salesforce CPQ Administration. It's also designed for experienced administrators, solution architects, implementation consultants, and developers looking to understand the full capabilities of Salesforce CPQ in order to formulate solutions for their business. This class is also a great foundation builder for anyone looking to earn the Salesforce CPQ Specialist credential. Overview When you complete this course, you'll be able to: Set Up Products, Bundles, and Product Rules Build Price Rules to Automatically Populate Field Values While Quoting or Configuring a Bundle Set Up Appropriate System Discounts and Pricing Methods Configure Dynamic Output Document Generation Manage Subscription Products (Including the Processes for Renewing and/or Amending Them) Formulate Sound Solutions to Common CPQ Business Requirements Make Significant Progress in Preparing for the Salesforce Certified CPQ Specialist Exam Discover how to configure an end-to-end Salesforce CPQ solution with out-of-the-box functionality. In this 5-day class, our CPQ experts will give you an in-depth look at Salesforce CPQ and its applications. You?ll learn how to set up and manage products, configure discount and pricing methods, create and manage subscriptions, and formulate solutions to meet common CPQ business requirements so you can successfully implement a Salesforce CPQ solution for your company. Course Introduction Review Course Objectives Set Learner Expectations Review Housekeeping Rules Explore Additional Course Resources Review Exam Quick Facts Introduction to CPQ Understand the Business Case for CPQ Watch an End-to-End Solution Demo Build a Quote Object Model Foundations Get Familiar with Products, Price Books, and Price Book Entries Review Product Fields Integral to Basic Salesforce CPQ Functionality Product Selection Modify Out-of-the-Box Button Behavior for Product Selection Review Guided Selling Bundle Configuration Define and Build Product Bundles Enforce Business Logic with Product Features Option Selection Guidelines Enforce Business Logic with Option Constraints Product Rules Define Product Rules Enforce Business Logic with Product Rules (Including Validation Rules, Alert Rules, Selection Rules, and Dynamic Bundles) Build Product Rules Using Supporting Objects (Including Error Conditions, Product Actions, Summary Variables, Configuration Rules, and Configuration Attributes) Pricing Methods Discover Pricing Waterfall Default Flows Review List Pricing, Cost Plus Markup, and Block Pricing Use Contracted Pricing for Negotiated Prices Subscription Pricing Configure Subscription and Proration Pricing Methods Understand How Subscription Pricing Methods Affect List and Regular Price Discounting Compare Discounting Strategies Build a Discount Schedule Price Rules Set Values for Quote and Quote Line Fields Declaratively Review CPQ Advanced Quote Calculator Calculation Events and Conditions Understand Price Action Sources (Including Static Values, Summary Variables, Formulas, and Lookup Tables) Create Lookup Queries to Outsource Evaluation to a Lookup Object Advanced Approvals Compare and Contrast the Advanced Approval Package Versus Native Approvals Define Approvers, Approval Chains, Approval Variables, and Approval Rules to Meet Specific Business Requirements Quote Templates Generate Dynamic Output Documents Create Conditional Template Content Localization and Multicurrency Make Accommodations for Localization Define Localization and How It Works in CPQ Orders Review Business Purposes of an Order Define the Data Model for Orders Define Data Requirements to Generate Orders Contracts, Renewals, and Amendments Generate New Contracts to Manage Active Subscriptions Related to an Account Review Amendment and Renewal Processes Review Renewal Pricing Methods Capstone Class Project: Troubleshoot Common Scenarios in Salesforce CPQ Design a Solution

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

Overview Master the use of the world's most popular data analysis and office tool, with absolutely no previous experience or training needed.This course will help you quickly become an expert in the use of Microsoft's best-selling Excel, allowing you to be a valuable asset to any business or organisation.The Microsoft Excel Level 3course will teach you how to manage finances, produce spreadsheets, and file invoices in no time. Our innovative training method will have you visualising and presenting company data efficiently. Learn to impress your peers and managers with your intuitive use of Excel and make sure that your administration skills are faultless. 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 Level 3. It is available to all students, of all academic backgrounds. Requirements Our Microsoft Excel 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 21 sections • 73 lectures • 10:39:00 total length •Introduction to Microsoft Excel 2019 New Features: 00:07:00 •CONCAT: 00:02:00 •IFS: 00:01:00 •MAXIFS: 00:01:00 •MINIFS: 00:01:00 •SWITCH: 00:02:00 •TEXTJOIN: 00:01:00 •Map Chart: 00:02:00 •Funnel Chart: 00:01:00 •Better Visuals: 00:06:00 •Pivot Table Enhancements: 00:02:00 •Power Pivot Updates: 00:01:00 •Navigate the Excel User Interface: 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 •Create Worksheet Formulas: 00:15:00 •Insert Functions: 00:17:00 •Reuse Formulas and Functions: 00:17:00 •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 •Apply Text Formats: 00:16: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:08:00 •Preview and Print a Workbook: 00:10:00 •Set Up the Page Layout: 00:09:00 •Configure Headers and Footers: 00:07:00 •Manage Worksheets: 00:05:00 •Manage Workbook and Worksheet Views: 00:07:00 •Manage Workbook Properties: 00:06:00 •Work with Ranges: 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 •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 •Collaborate on a Workbook: 00:19:00 •Protect Worksheets and Workbooks: 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 •Excel Templates: 00:00:00 •Resources - Microsoft Excel - Beginner Course - Cpd Accredited: 00:00:00 •Assignment - Microsoft Excel Level 3: 00:00:00