14997 Open courses

Overview This comprehensive course on Business Analystics for Beginners Using SASS will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Business Analystics for Beginners Using SASS 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 Business Analystics for Beginners Using SASS. It is available to all students, of all academic backgrounds. Requirements Our Business Analystics for Beginners Using SASS 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 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 13 sections • 73 lectures • 08:10:00 total length •SAS Introduction: 00:07:00 •Introduction to SAS Program: 00:05:00 •Read SAS Dataset: 00:09:00 •Practice Read Dataset: 00:08:00 •Practical Example on Read Dataset: 00:02:00 •Introduction to SAS Dataset: 00:12:00 •SAS Dataset Practical Example: 00:07:00 •SAS Dataset Practical Program: 00:06:00 •DateValue: 00:03:00 •SAS Formats Part 1: 00:13:00 •SAS Formats Part 2: 00:09:00 •Reading Excel Worksheets: 00:05:00 •Reading Excel Worksheet Example: 00:11:00 •Date Format Example: 00:06:00 •Raw Data File Standard Part 1: 00:09:00 •Raw Data File Standard Part 2: 00:08:00 •Raw Data File Standard Example: 00:06:00 •Raw Data File Non Standard: 00:07:00 •Raw Data File Non Standard Example: 00:06:00 •Length Statement: 00:02:00 •Compilation Execution: 00:04:00 •Heading: 00:01:00 •Dataerrors: 00:05:00 •Data Errorsz Example: 00:03:00 •Validate Data Procfreq: 00:05:00 •Validate Data Procpront: 00:07:00 •Validate Data Peocmeans: 00:05:00 •Dat Constant: 00:07:00 •Assignment Statement: 00:09:00 •If Then Statement: 00:09:00 •If Then Do End Statement: 00:09:00 •Diff Where and If Statement: 00:02:00 •Keep Drop: 00:08:00 •Keep Drop Example: 00:04:00 •Append: 00:09:00 •Append Examples part 1: 00:09:00 •Append Examples part 2: 00:07:00 •Concatenate: 00:12:00 •Merge: 00:06:00 •Merge One to One: 00:07:00 •Merge One to Many: 00:04:00 •Merge Non Match: 00:04:00 •Global Statements: 00:09:00 •Global Statements Examples Part 1: 00:08:00 •Global Statements Examples Part 2: 00:06:00 •Title n Foot Note: 00:05:00 •Title n Foot Note Example: 00:08:00 •By Statement: 00:08:00 •Multiple Where Stament: 00:03:00 •ODS: 00:07:00 •ODS Example: 00:04:00 •Sas Date Function: 00:10:00 •Sas Date Function Example: 00:08:00 •Sas Functions Part 1: 00:10:00 •Sas Functions Part 2: 00:08:00 •Sas Functions: 00:07:00 •Sas Functions Example Part 1: 00:07:00 •Sas Functions Example Part 2: 00:09:00 •Multiple SAS Datasets Part 1: 00:05:00 •Multiple SAS Datasets Part 2: 00:02:00 •Multiple SAS Datasets Example: 00:09:00 •Select Group: 00:09:00 •Select Group Example: 00:08:00 •Do Loop Part 1: 00:07:00 •Do Loop Part 2: 00:06:00 •Do Loop Example: 00:07:00 •Array Part 1: 00:05:00 •Array Part 2: 00:08:00 •Array DoLoop: 00:06:00 •ArrayTemp: 00:05:00 •Array Example: 00:10:00 •Sas Statement Part 1: 00:04:00 •Sas Statement Part 2: 00:05:00

Overview This comprehensive course on Mathematics Fundamentals will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Mathematics Fundamentals 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 Mathematics Fundamentals. It is available to all students, of all academic backgrounds. Requirements Our Mathematics Fundamentals 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 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 12 sections • 67 lectures • 07:38:00 total length •Introduction: 00:02:00 •Number system: 00:09:00 •Integers and ordering of integers: 00:07:00 •Addition and Subtractions of Integers: 00:09:00 •Operations on Integers: 00:06:00 •Multiplication and Division of Integers: 00:07:00 •Powers of Integers (Exponents): 00:04:00 •Complete knowledge about factors and multiples: 00:07:00 •Divisibility tests for 2,3,4,5,6: 00:07:00 •Divisibility rules 7,8,9,10,11: 00:11:00 •Prime Factorization: 00:13:00 •Highest common factor HCF: 00:13:00 •Word problems based on HCF A: 00:12:00 •Least common multiple LCM: 00:16:00 •Relation between lcm and HCF A: 00:04:00 •Classification of Fractions: 00:04:00 •Convert mixed to improper and improper to mixed fractions: 00:03:00 •Equivalent Fractions: 00:04:00 •Comparing Fractions after converting to like fractions: 00:09:00 •Reducing a fraction to lowest term: 00:04:00 •Addition and subtraction OF fractions: 00:08:00 •Multiplication and division of fractions: 00:11:00 •Word problems on fractions: 00:16:00 •Bodmas and rules to remove brackets: 00:03:00 •Simplify expressions using BODMAS rules: 00:05:00 •Simplify expressions involving fractions using BODMAS: 00:07:00 •Decimal numbers in relation to fractions: 00:08:00 •Like and unlike Decimals: 00:05:00 •Ordering of Decimal numbers: 00:10:00 •Addition and subtraction of Decimal: 00:07:00 •Multiplication of Decimal: 00:03:00 •Division of Decimal: 00:08:00 •Rational number: 00:02:00 •Representation of Rational Numbers on Number line: 00:05:00 •Determining which fraction is terminating or non-terminating: 00:07:00 •Shortcut method of writing decimal expansion of fraction to decimal A: 00:08:00 •Rounding to whole number: 00:06:00 •Rounding to required number of decimals (1 d.p.): 00:05:00 •Rounding to significant digits: 00:07:00 •Practice question on three methods of approximation: 00:05:00 •Estimation: 00:05:00 •Scientific Notation: 00:07:00 •Operation on numbers when they are in scientific notation: 00:06:00 •Percentage to fraction and fraction to percentage: 00:06:00 •Percentage of a quantity and conversation to decimal: 00:06:00 •Expressing one quantity as percentage of another quantity: 00:06:00 •Finding increase decrease percent: 00:05:00 •Uses of Percentages-Word Problems A: 00:09:00 •Ratio- How to express as simple ratio: 00:09:00 •How to compare Ratios: 00:04:00 •Word problems on finding ratios: 00:07:00 •To divide a given quantity into a given Ratio: 00:11:00 •Proportion: 00:04:00 •Practice problems on Proportion: 00:06:00 •Continued proportion: 00:06:00 •Direct Variation (or proportion): 00:04:00 •Problems based on Direct proportion: 00:10:00 •Inverse Variation (or proportion): 00:10:00 •Multiple Ratios: 00:10:00 •Basics - Profit and Loss: 00:04:00 •More practice problems on Profit _ Loss: 00:06:00 •Selling price formula and Problems: 00:04:00 •Cost price formula and Problems: 00:03:00 •Higher problems on Profit and Loss: 00:08:00 •Basics - Discount: 00:05:00 •Practice problems on Discount: 00:04:00 •Tax: 00:06:00

Overview This comprehensive course on jQuery: JavaScript and AJAX Coding will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This jQuery: JavaScript and AJAX Coding 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 jQuery: JavaScript and AJAX Coding. It is available to all students, of all academic backgrounds. Requirements Our jQuery: JavaScript and AJAX Coding 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 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 11 sections • 87 lectures • 05:14:00 total length •Introduction To This Course: 00:02:00 •Setup on Windows: 00:03:00 •Setup on Mac OS X: 00:03:00 •Setup on Linux: 00:05:00 •Online Code IDE: 00:02:00 •Uncompressed vs Minified vs Slim vs Slim Minified: 00:05:00 •Document Ready: 00:03:00 •Elements: 00:03:00 •All Elements: 00:02:00 •This Keyword: 00:03:00 •ID: 00:02:00 •Class: 00:02:00 •Multiple Items: 00:03:00 •First Element: 00:02:00 •Odd/Even: 00:06:00 •Element and Class: 00:02:00 •Children: 00:04:00 •Attributes: 00:03:00 •Type: 00:04:00 •Contains: 00:03:00 •Get Attribute: 00:02:00 •Set Attribute: 00:03:00 •Set Attribute With Callback Function: 00:03:00 •Set Multiple Attributes: 00:03:00 •Remove: 00:02:00 •Text Attribute: 00:02:00 •Data Attribute: 00:03:00 •Value: 00:03:00 •HTML Value: 00:02:00 •Class: 00:09:00 •Binding & Unbindin: 00:07:00 •Attributes: 00:04:00 •Propagation: 00:05:00 •Prevent Default Behaviour: 00:05:00 •Mouse Single Click: 00:02:00 •Mouse Enter Element: 00:04:00 •Mouse Leave Element: 00:04:00 •Mouse Hover: 00:04:00 •Mouse Down: 00:03:00 •Mouse Up: 00:02:00 •Keyboard Down: 00:03:00 •Keyboard Press: 00:01:00 •Keyboard Up: 00:01:00 •Form Submit: 00:03:00 •Form Change: 00:03:00 •Form Focus: 00:04:00 •Form Blur: 00:02:00 •Document/Window Scroll: 00:03:00 •Document/Window Resize: 00:02:00 •Combining Multiple Events Using A Single Selector: 00:05:00 •Get and Set CSS Property: 00:03:00 •Set Multiple CSS Properties: 00:02:00 •Add, Remove and Toggle CSS Classes: 00:06:00 •Get and Set Element Dimensions: 00:12:00 •Adding Elements Using Append, Prepend, After and Before: 00:05:00 •Removing Elements Using Remove and Empty: 00:06:00 •Elements By Index: 00:03:00 •Child Elements: 00:03:00 •Parent Element: 00:03:00 •Sibling Elements: 00:03:00 •Filtering Elements: 00:06:00 •Show, Hide and Toggle: 00:11:00 •Fading Using FadeIn, FadeOut, FadeToggle and FadeTo: 00:06:00 •Sliding Using SlideDown, SlideUp and SlideToggle: 00:06:00 •Animate: 00:09:00 •Stop Effects and Animations: 00:03:00 •Function Callback: 00:03:00 •Action and Method Chaining: 00:05:00 •Load: 00:05:00 •Get JSON: 00:04:00 •GET Data: 00:04:00 •POST Data: 00:05:00 •Trim String: 00:03:00 •Extend: 00:03:00 •Extend Function: 00:07:00 •In Array: 00:04:00 •Each: 00:03:00 •Data Function: 00:05:00 •Proxy Function: 00:03:00 •Is Window Function: 00:01:00 •Now/Epoch Time Method: 00:02:00 •Number Check (isNumeric): 00:02:00 •Dequeue: 00:03:00 •Global Evaluation: 00:02:00 •Assignment - jQuery: JavaScript and AJAX Coding: 00:00:00 •Resource: 00:00:00 •Mouse Double Click: 00:02:00

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 This comprehensive course on Quick Maths Tricks for Competitive Exams will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Quick Maths Tricks for Competitive Exams 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 Quick Maths Tricks for Competitive Exams. It is available to all students, of all academic backgrounds. Requirements Our Quick Maths Tricks for Competitive Exams 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 14 sections • 67 lectures • 07:39:00 total length •Introduction: 00:02:00 •Number system: 00:09:00 •Integers and ordering of integers: 00:07:00 •Addition and Subtractions of Integers: 00:10:00 •Operations on Integers: 00:06:00 •Multiplication and Division of Integers: 00:07:00 •Powers of Integers (Exponents): 00:04:00 •Complete knowledge about factors and multiples: 00:07:00 •Divisibility tests for 2,3,4,5,6: 00:07:00 •Divisibility rules 7,8,9,10,11: 00:11:00 •Prime Factorization: 00:13:00 •Highest common factor HCF: 00:13:00 •Word problems based on HCF: 00:12:00 •Least common multiple LCM: 00:16:00 •Relation between lcm and HCF: 00:04:00 •Classification of Fractions: 00:04:00 •Convert mixed to improper and improper to mixed fractions: 00:03:00 •Equivalent Fractions: 00:04:00 •Comparing Fractions after converting to like fractions: 00:09:00 •Reducing a fraction to lowest term: 00:04:00 •Addition and subtraction OF fractions: 00:08:00 •Multiplication and division of fractions: 00:11:00 •Word problems on fractions: 00:16:00 •Bodmas and rules to remove brackets: 00:03:00 •simplify expressions using BODMAS rules: 00:05:00 •simplify expressions involving fractions using BODMAS: 00:07:00 •Decimal numbers in relation to fractions: 00:08:00 •Like and unlike Decimals: 00:05:00 •Ordering of Decimal numbers: 00:10:00 •Addition and subtraction of Decimal: 00:07:00 •Multiplication of Decimal: 00:03:00 •Division of Decimal: 00:08:00 •Rational number: 00:02:00 •Representation of Rational Numbers on Number line: 00:05:00 •Determining which fraction is terminating or non-terminating: 00:07:00 •shortcut method of writing decimal expansion of fraction to decimal: 00:08:00 •Rounding to whole number: 00:06:00 •Rounding to required number of decimals (1 d.p. ): 00:05:00 •Rounding to significant digits: 00:07:00 •Practice question on three methods of approximation: 00:05:00 •Estimation: 00:05:00 •Scientific Notation: 00:07:00 •Operation on numbers when they are in scientific notation: 00:06:00 •Percentage to fraction and fraction to percentage: 00:06:00 •Percentage of a quantity and conversation to decimal: 00:06:00 •Expressing one quantity as percentage of another quantity: 00:06:00 •Finding increase decrease percent: 00:05:00 •Uses of Percentages-Word Problems: 00:09:00 •Ratio- How to express as simple ratio: 00:09:00 •How to compare Ratios: 00:04:00 •Word problems on finding ratios: 00:07:00 •To divide a given quantity into a given Ratio: 00:11:00 •Proportion: 00:04:00 •Practice problems on Proportion: 00:06:00 •Continued proportion: 00:06:00 •Direct Variation (or proportion): 00:04:00 •Problems based on Direct proportion: 00:10:00 •Inverse Variation (or proportion): 00:10:00 •Multiple Ratios: 00:10:00 •Basics - Profit and Loss: 00:04:00 •More practice problems on Profit _ Loss: 00:06:00 •Selling price formula and Problems: 00:04:00 •Cost price formula and Problems: 00:03:00 •Higher problems on Profit and Loss: 00:08:00 •Basics - Discount: 00:05:00 •Practice problems on Discount: 00:04:00 •Tax: 00:06: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

Overview This comprehensive course on Spanish Language (Intermediate Level) will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Spanish Language (Intermediate Level) 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? 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 Spanish Language (Intermediate Level). It is available to all students, of all academic backgrounds. Requirements Our Spanish Language (Intermediate Level) 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 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 10 sections • 83 lectures • 04:16:00 total length •Spanish - Course 2 Introduction: 00:01:00 •Spanish - Lesson 10a: 00:03:00 •Spanish - Lesson 10b: 00:03:00 •Spanish - Lesson 10c: 00:03:00 •Spanish - Lesson 10d: 00:03:00 •Spanish - Lesson 10e: 00:03:00 •Spanish - Lesson 10f: 00:03:00 •Spanish - Lesson 10g: 00:03:00 •Spanish - Lesson 10h: 00:03:00 •Spanish - Lesson 11a: 00:03:00 •Spanish - Lesson 11b: 00:03:00 •Spanish - Lesson 11c: 00:03:00 •Spanish - Lesson 11d: 00:03:00 •Spanish - Lesson 11e: 00:03:00 •Spanish - Lesson 11f: 00:03:00 •Spanish - Lesson 11g: 00:05:00 •Spanish - Lesson 12a: 00:03:00 •Spanish - Lesson 12b: 00:03:00 •Spanish - Lesson 12c: 00:03:00 •Spanish - Lesson 12d: 00:03:00 •Spanish - Lesson 12e: 00:03:00 •Spanish - Lesson 12f: 00:03:00 •Spanish - Lesson 12g: 00:03:00 •Spanish - Lesson 12h: 00:03:00 •Spanish - Lesson 12i: 00:05:00 •Spanish - Lesson 13a: 00:03:00 •Spanish - Lesson 13b: 00:03:00 •Spanish - Lesson 13c: 00:03:00 •Spanish - Lesson 13d: 00:03:00 •Spanish - Lesson 13e: 00:03:00 •Spanish - Lesson 13f: 00:03:00 •Spanish - Lesson 13g: 00:03:00 •Spanish - Lesson 13h: 00:03:00 •Spanish - Lesson 13i: 00:03:00 •Spanish - Lesson 14a: 00:03:00 •Spanish - Lesson 14b: 00:03:00 •Spanish - Lesson 14c: 00:03:00 •Spanish - Lesson 14d: 00:03:00 •Spanish - Lesson 14e: 00:03:00 •Spanish - Lesson 14f: 00:03:00 •Spanish - Lesson 14g: 00:03:00 •Spanish - Lesson 14h: 00:03:00 •Spanish - Lesson 14i: 00:03:00 •Spanish - Lesson 15a: 00:03:00 •Spanish - Lesson 15b: 00:03:00 •Spanish - Lesson 15c: 00:03:00 •Spanish - Lesson 15d: 00:03:00 •Spanish - Lesson 15e: 00:03:00 •Spanish - Lesson 15f: 00:03:00 •Spanish - Lesson 15g: 00:03:00 •Spanish - Lesson 15h: 00:03:00 •Spanish - Lesson 15i: 00:03:00 •Spanish - Lesson 15j: 00:03:00 •Spanish - Lesson 15k: 00:03:00 •Spanish - Lesson 15l: 00:04:00 •Spanish - Lesson 16a: 00:03:00 •Spanish - Lesson 16b: 00:03:00 •Spanish - Lesson 16c: 00:03:00 •Spanish - Lesson 16d: 00:03:00 •Spanish - Lesson 16e: 00:03:00 •Spanish - Lesson 16f: 00:03:00 •Spanish - Lesson 16g: 00:03:00 •Spanish - Lesson 16h: 00:03:00 •Spanish - Lesson 16i: 00:04:00 •Spanish - Lesson 17a: 00:03:00 •Spanish - Lesson 17b: 00:03:00 •Spanish - Lesson 17c: 00:03:00 •Spanish - Lesson 17d: 00:03:00 •Spanish - Lesson 17e: 00:03:00 •Spanish - Lesson 17f: 00:03:00 •Spanish - Lesson 17g: 00:03:00 •Spanish - Lesson 17h: 00:03:00 •Spanish - Lesson 17i: 00:03:00 •Spanish - Lesson 17j: 00:04:00 •Spanish - Lesson 18a: 00:03:00 •Spanish - Lesson 18b: 00:03:00 •Spanish - Lesson 18c: 00:03:00 •Spanish - Lesson 18d: 00:03:00 •Spanish - Lesson 18e: 00:03:00 •Spanish - Lesson 18f: 00:03:00 •Spanish - Lesson 18g: 00:03:00 •Spanish - Lesson 18h: 00:04:00 •Spanish - Lesson 18i: 00:04:00

Overview Be a better pet parent with the Cat Behaviour and Healthcare Diploma course.This Cat Behaviour and Healthcare Diplomacourse will help you to understand your feline better. It will teach you essential feline healthcare skills and the right nutrition for your cat. It will equip you with cat body language decoding skills, covering practical cat facts, and uncovering the secrets of good cat litter box habits. Understand your cat better by enrolling into the Cat Behaviour and Healthcare Diplomacourse 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 Cat Behaviour and Healthcare Diploma. It is available to all students, of all academic backgrounds. Requirements Our Cat Behaviour and Healthcare Diploma 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 32 sections • 68 lectures • 03:23:00 total length •Scratching Behavior: 00:07:00 •Intercat Aggression: 00:05:00 •Attention Seeking Behavior: 00:08:00 •Petting Induced Aggression: 00:05:00 •Redirected Aggression: 00:07:00 •Separation Anxiety: 00:08:00 •Obsessive Compulsive Disorder (OCD): 00:05:00 •Urine Marking: 00:09:00 •Excessive Vocalisation: 00:08:00 •Spilling Water: 00:04:00 •Destructive Chewing: 00:05:00 •Fear in Cats: 00:09:00 •Play Aggression: 00:07:00 •1.1 Seizures: Ways to Identify: 00:02:00 •1.2 Seizures: Causes: 00:02:00 •1.3 Seizures: Ways to Manage: 00:02:00 •1.4 Seizures: Preventive Measures: 00:01:00 •2.1 Obesity: Ways to Identify: 00:02:00 •2.2 Obesity: Health Consequences: 00:01:00 •2.3 Obesity: Causes: 00:01:00 •2.4 Obesity: Ways to Manage: 00:02:00 •3.1 Hearing Loss: Ways to Identify: 00:02:00 •3.2 Hearing Loss: Causes: 00:02:00 •3.3 Hearing Loss: Ways to Manage: 00:03:00 •3.4 Hearing Loss: Preventive Measures: 00:01:00 •4.1 FCD / Memory Loss: Ways to Identify: 00:05:00 •4.2 FCD / Memory Loss: Causes: 00:01:00 •4.3 FCD / Memory Loss: Ways to Manage: 00:04:00 •5.1 Urinary Incontinence: Ways to Identify: 00:01:00 •5.2 Urinary Incontinence: Causes: 00:01:00 •5.3 Urinary Incontinence: Ways to Manage: 00:03:00 •6.1 Arthritis / Joint Pain: Ways to Identify: 00:03:00 •6.2 Arthritis/ Joint Pain: Causes: 00:01:00 •6.3 Arthritis: Ways to Manage: 00:04:00 •7.1 Vision Loss: Ways to Identify: 00:05:00 •7.2 Vision Loss: Causes: 00:01:00 •7.3 Vision Loss: Ways to Manage: 00:03:00 •7.4 Vision Loss: Preventive Measures: 00:01:00 •8.1 Diabetes: Ways to Identify: 00:03:00 •8.2 Diabetes: Ways to Manage: 00:02:00 •9.1 Cancer: Ways to Identify: 00:02:00 •9.2 Cancer: Causes: 00:03:00 •9.3 Cancer: Preventive Measures: 00:02:00 •10.1 Dental Diseases: Ways to Identify: 00:03:00 •10.2 Dental Diseases: Preventive Measures: 00:02:00 •11.1 Fatty Liver Disease: Ways to Identify: 00:02:00 •11.2 Fatty Liver Disease: Causes: 00:02:00 •11.3 Fatty Liver Disease: Ways to Manage: 00:01:00 •11.4 Fatty Liver Disease: Preventive Measures: 00:02:00 •12.1 Heart Diseases: Ways to Identify: 00:02:00 •12.2 Heart Diseases: Causes: 00:02:00 •12.3 Heart Diseases: Preventive Measures: 00:01:00 •13.1 Hyperthyroidism: Ways to Identify: 00:03:00 •13.2 Hyperthyroidism: Causes: 00:01:00 •13.3 Hyperthyroidism: Ways to Manage: 00:01:00 •14.1 Kidney Diseases: Ways to Identify: 00:02:00 •14.2 Kidney Diseases: Health Consequences: 00:02:00 •14.3 Kidney Diseases: Causes: 00:01:00 •14.4 Kidney Diseases: Ways to Manage: 00:02:00 •15.1 Lactose Intolerance: Ways to Identify and Causes: 00:02:00 •15.2 Lactose Intolerance: Ways to Manage: 00:03:00 •16.1 Feline Distemper Disease: Causes: 00:02:00 •16.2 Feline Distemper Disease: Health Consequences: 00:01:00 •16.3 Feline Distemper Disease: Ways to Manage: 00:01:00 •16.4 Feline Distemper Disease: Preventive Measures: 00:02:00 •17.1 Rabies: Ways to Identify: 00:03:00 •17.2 Rabies: Management & Prevention: 00:04:00 •Ways to Boost Immunity of your Cat: 00:03:00

Be a certified TESOL and starts teaching with the Teaching English to Speakers of Other Languages (TESOL) course. TESOL stands for Teaching English to Speakers of Other Languages and encompasses what used to be called TEFL (Teaching English as a Foreign Language) and TESL (Teaching English as a Second Language). Getting a TESOL course opens your door to travel around the world and make your living better by teaching the English language. The course covers the mandatory aspect of TESOL and teaches you how to teach English. Teaching English does not include only the lexical, grammatical or pragmatic use of the language. It also includes the techniques of motivating your students, creating an anxiety-free zone for your learners and managing the classroom, etc. The course explains all these issues along with the necessary skills for teaching grammar, listening, speaking, reading, and writing. Finally, the course shows you the path to get hired abroad. Upon completion, you will be able to teach English properly and confidently. Who is this course for? Teaching English to Speakers of Other Languages (TESOL) is suitable for anyone who want to gain extensive knowledge, potential experience and professional skills in the related field. This course is CPD accredited so you don't have to worry about the quality. Requirements Our Teaching English to Speakers of Other Languages (TESOL) is open to all from all academic backgrounds and there is no specific requirements to attend this course. It is compatible and accessible from any device including Windows, Mac, Android, iOS, Tablets etc. CPD Certificate from Course Gate  At the successful completion of the course, you can obtain your CPD certificate from us. You can order the PDF certificate for £9 and the hard copy for £15. Also, you can order both PDF and hardcopy certificates for £22. Career path This course opens a new door for you to enter the relevant job market and also gives you the opportunity to acquire extensive knowledge along with required skills to become successful. You will be able to add our qualification to your CV/resume which will help you to stand out in the competitive job industry. Course Curriculum Teaching English to Speakers of Other Languages (TESOL) Introduction to Teaching English 00:45:00 Linguistics Basics 00:45:00 Working With a Variety of Approaches 01:00:00 Teaching Speaking 01:00:00 Teaching Listening 01:00:00 Teaching Reading 01:00:00 Teaching Writing 01:00:00 Planning Pedagogy 01:00:00 Planning Lessons 01:00:00 Managing Classrooms 01:00:00 Getting a job 01:00:00 Mock Exam Mock Exam - Teaching English to Speakers of Other Languages (TESOL) 00:20:00 Final Exam Final Exam - Teaching English to Speakers of Other Languages (TESOL) 00:20:00 Certificate and Transcript Order Your Certificates or Transcripts 00:00:00

CPD Accredited | Career Oriented Learning Modules | 24x7 Tutor Support | Lifetime Access