5813 Computing courses in Prestatyn delivered Online

Duration 2 Days 12 CPD hours This course is intended for Network Video Engineer Voice/UC/Collaboration/Communications Engineer Collaboration Tools Engineer Collaboration Sales/Systems Engineer Overview Install, Configure, and Implement Cisco Emergency Responder (Cisco ER). Configure CUCM for CER Configure Emergency Response Locations (ERLs) Configure Emergency Location Identification Numbers (ELINs) Configure PSAP calls and PSAP CallBack Configure Users and onsite Security Management This is a 2-day hands-on course, where students will Install, Deploy, and Configure Cisco Emergency Responder (Cisco ER) 12.5. Student will also integrate emergency communication system with Cisco Unified Communications Manager. Students will learn how Cisco ER automatically notifies and routes calls to the local public safety answering point (PSAP) operator. Students will configure emergency response locations (ERLs) and emergency location identification numbers (ELINs) in CER to properly route enhanced 911 (E911) calls. You will also examine CER disaster recovery and user management. Cisco Emergency Responder Overview PSAP/ Emergency Calling Overview National Emergency Number Association Legislation and Regulation Service Provider ALI Automatic Number Identification (ANI) Automatic Location Identification (ALI) NENA Emergency Response Location NENA Guidelines for ERLs NENA Emergency Location Identification Number (ELIN) E911 Preparation Cisco Emergency Call Handler Cisco Emergency Responder 11.x Enhancements License Management Emergency Responder Redundancy Clustering CER over the WAN Integration with UC Manager Intrado Architecture CER Wireless Features Overview Installing Cisco Emergency Responder Supported Hardware Platforms CER Virtual Server Requirements Deploy Cisco CER OVF/OVA Installation of CER CER CLI Interface Reset Application Administrator Password Add 2nd CER Server - Subscriber Upgrade VMware Tools on Cisco Emergency Responder Server CER Backup and Restore CER PLM Licensing Unified Communication Manager CER Configuration Cisco Unified Communications Manager Administrator Interfaces Cisco Unified Communications Manager Required Services for CER CUCM SNMP Settings Phone Partition and Calling Search Spaces Partitions for 911 Services CER CUCM Configuration for CTI Route Points and CTI Ports Configure CER Route Patterns for 911 and Security Personal Create Translation Patterns for ELINs Create Emergency Responder Cisco Unified Communications Manager User Location Awareness Overview Configure Wireless Endpoint Tracking Feature on UCM 11.5 Cisco Emergency Responder (CER) Configuration Emergency Responder Interface E.164 Dial Plan Support Cisco Emergency Responder Groups Setup CER Groups CER Telephony Settings for CER Cisco CER License Manager Cisco CER Email Settings Cisco CER - Add Subscriber Onsite Security Alerts for Security Personnel Pager Alert Configuration Configure Emergency Response Location (ERL) Configure Emergency Location Identification Number (ELIN) ERL Migration Tool Configure SNMP Configure Phone Tracking Configure LAN Switch Tracking Configuring IP Subnet-based ERLs Configuring Manual Phone Tracking Emergency Responder User Management Manage Onsite Alerts, ERLs, and ALI Data User and Security Logins CER - Web Alerts CER - ERL Audit Trail Export PS-ALI Records ERL Debug Tool

Duration 1 Days 6 CPD hours This course is intended for This course is intended for those responsible for ITAD programs and other IT professionals involved in Asset Management, resource budgeting, finance, software licensing, contract management and strategic planning. Overview Students will learn the best practices in an IT Asset Management Program and align those processes with their organizations' business practices. They will be able to manage overall ITAM programs and demonstrate in-depth knowledge, operational knowledge and competence in asset disposal and process development. The IAITAM Certified IT Asset Disposition (CITAD) course prepares individuals to manage the IT asset disposal process within an organization. Best practices in IT Asset Disposition (ITAD) are broken down from policy management, data security to chain of custody transitioning. Attendees whose job responsibilities include ITAD will take away the knowledge of how to avoid risk of data loss and public exposure that surround a breakdown in ITAD process management. ITAD best practices, financial return, data security global implications and the importance of vendor management are just a few of the topics incorporated in the CITAD course. This course exposes the attendee to numerous concepts for ITAM that are relevant for both direct application and as a means of discussion for those persons who will implement, manage and direct ITAM initiatives for their organizations. This course includes the exam for CITAD certification. Course Outline Disposition Overview Disposition and ITAM Organizational Goals for Disposition ITAM Goals for Disposition Governance of Electronic Disposal Composition of E-Scrap Waste Management Laws Foundation for Disposal Management Policy Topics Relevant to Disposition Asset Standards Benefit Disposal The Role of Automation Data Security Governance Working with Vendors Selecting Vendors Due Diligence The Removal Process Software During Disposition Decision Factors for Retirement The Disposition Processes Financial Management & Measurement Additional course details: Nexus Humans Certified IT Asset Disposal (CITAD) training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success. While we feel this is the best course for the Certified IT Asset Disposal (CITAD) course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you. Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.

Duration 1 Days 6 CPD hours This course is intended for This course provides an introductory overview of the CMMC program for organizational decision makers. Business and IT leaders and IT staff might consider taking this course to learn about the CMMC Model to get a sense of what's required for a successful assessment, and the various ways they can start preparing. Overview In this course, you will identify the key elements and potential impacts of the Cybersecurity Maturity Model Certification (CMMC) program. You will: Identify the crucial elements that are driving the CMMC initiative. Describe the architecture of the CMMC Model and the rationale behind it. Prepare your organization for a successful CMMC Assessment. Identify the roles and responsibilities in the CMMC ecosystem and describe the phases of an Assessment. The Cybersecurity Maturity Model Certification (CMMC), managed by The Cyber AB (formerly known as the CMMC Accreditation Body or the CMMC-AB), is a program through which an organization's cybersecurity program maturity is measured by their initial and ongoing compliance with applicable cybersecurity practices. This course provides a complete review of the key elements of this important program and will entitle you to a CMMC Trailblazer badge.Important: This curriculum product is not considered CMMC-AB Approved Training Material (CATM). This course is not intended as certification preparation and does not qualify students to sit for the CMMC CP certification exam. Identifying What's at Stake Topic A: Identify the Threats and Regulatory Responses Topic B: Identify Sensitive Information Describing CMMC Topic A: Describe the CMMC Model Architecture Topic B: Describe the CMMC Program Getting Ready for a CMMC Assessment Topic A: Scope Your Environment Topic B: Analyze the CMMC Assessment Guides Topic C: Foster a Mature Cybersecurity Culture Topic D: Identify Helpful Documents Topic E: Evaluate Your Readiness Interacting with the CMMC Ecosystem Topic A: Identify the CMMC Ecosystem Topic B: Describe a CMMC Assessment

Overview This comprehensive course on Mastering Java for Beginners & Experts will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Mastering Java for Beginners & Experts 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 Mastering Java for Beginners & Experts. It is available to all students, of all academic backgrounds. Requirements Our Mastering Java for Beginners & Experts 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 • 70 lectures • 05:35:00 total length •Introduction To This Course.: 00:02:00 •Setup Eclipse On Windows: 00:05:00 •Setup Eclipse On Mac OS X: 00:05:00 •Setup Eclipse On Linux: 00:05:00 •Run Code Online: 00:02:00 •Printing To The Console: 00:04:00 •Comments.: 00:06:00 •Variables.: 00:05:00 •Datatypes: 00:16:00 •Constant Variables: 00:03:00 •Console Input: 00:04:00 •Operators: 00:06:00 •If statement (Conditional Statement): 00:08:00 •Switch statement (Conditional Statement): 00:07:00 •For Loop.: 00:05:00 •While Loop.: 00:05:00 •Do While Loop.: 00:05:00 •Loop Control Statements: 00:03:00 •Numbers: 00:08:00 •Characters: 00:06:00 •Strings.: 00:05:00 •Arrays: 00:08:00 •For Each Loop: 00:04:00 •Date & Time: 00:04:00 •Regular Expressions.: 00:07:00 •Simple Example 1: 00:05:00 •Passing Values To Functions: 00:03:00 •Method Overloading: 00:05:00 •Command Line Arguments: 00:04:00 •Multiple Arguments Simplified: 00:06:00 •Byte Streams: 00:07:00 •Character Streams: 00:02:00 •Standard Streams: 00:04:00 •Listing Files & Folders: 00:02:00 •Creating Folders: 00:02:00 •Simple Example 2: 00:05:00 •Multiple Catch Blocks: 00:04:00 •Throw and Throws Keywords: 00:03:00 •Finally Block: 00:03:00 •User Created Exceptions: 00:08:00 •Simple Class Example: 00:08:00 •Constructor: 00:04:00 •This keyword: 00:05:00 •Inheritance.: 00:06:00 •Modifier Types: 00:04:00 •Overriding: 00:05:00 •Abstraction: 00:05:00 •Interfaces: 00:04:00 •Enum: 00:03:00 •Stacks.: 00:04:00 •Vector.: 00:06:00 •BitSet: 00:05:00 •Properties: 00:05:00 •Hashtable: 00:04:00 •List.: 00:04:00 •Set.: 00:04:00 •SortedSet: 00:03:00 •Map: 00:03:00 •Map.Entry: 00:03:00 •Sorted Map: 00:02:00 •Enumeration.: 00:05:00 •Client Example.: 00:07:00 •Server Example.: 00:11:00 •Creating Threads Using a Runnable Interface: 00:09:00 •Creating Threads by Extending a Thread Class: 00:03:00 •Simple Example 3: 00:04:00 •Keyboard Events: 00:04:00 •Mouse Events: 00:04:00 •Resource.: 00:00:00 •Assignment - Mastering Java for Beginners & Experts: 00:00:00

Overview This comprehensive course on Workshop Technology: Machine Shop Theory will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Workshop Technology: Machine Shop Theory comes with accredited certification from CPD, which will enhance your CV and make you worthy in the job market. So enrol in this course today to fast track your career ladder. How will I get my certificate? At the end of the course there will be an online written test, which you can take either during or after the course. After successfully completing the test you will be able to order your certificate, these are included in the price. Who is This course for? There is no experience or previous qualifications required for enrolment on this Workshop Technology: Machine Shop Theory. It is available to all students, of all academic backgrounds. Requirements Our Workshop Technology: Machine Shop Theory 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 9 sections • 41 lectures • 02:20:00 total length •Scope of the Course: 00:10:00 •Metal Cutting Processes: 00:02:00 •Cutting Tools: 00:03:00 •Nomenclature of Single Point Cutting Tool: 00:04:00 •Tool Signature: 00:02:00 •Mechanics of Metal Cutting: 00:04:00 •Types of Chips: 00:03:00 •Coolant or Cutting Fluids: 00:03:00 •Types of Lathe Machine: 00:09:00 •Construction of A Lathe: 00:09:00 •Accessories and Attachments: 00:07:00 •Specification of Lathe: 00:02:00 •Lathe Operations: 00:02:00 •Taper and Taper Turning: 00:04:00 •Thread Cutting: 00:03:00 •Cutting Speed and Feed: 00:02:00 •Construction of A Drilling Machine: 00:04:00 •Types of Drilling Machine: 00:09:00 •Types of Drills: 00:03:00 •Twist Drill Geometry: 00:04:00 •Drilling Operations: 00:05:00 •Size of Drilling Machine: 00:01:00 •Cutting Speed and Feed: 00:02:00 •Working Principle: 00:03:00 •Types of Shaper: 00:01:00 •Parts of Shaper: 00:05:00 •Shaper Mechanism: 00:04:00 •Shaper Operations: 00:01:00 •Types of Planer: 00:01:00 •Working Principle: 00:02:00 •Difference Between Shaper and Planer: 00:02:00 •Principle Parts of Slotter: 00:03:00 •Slotter Operations: 00:02:00 •Working Principle: 00:02:00 •Milling Methods: 00:03:00 •Types of Milling Cutters: 00:01:00 •Types of Milling Machines: 00:07:00 •Size of Milling Machine: 00:01:00 •Indexing and Dividing Head: 00:02:00 •Milling Operations: 00:03:00 •Assignment - Workshop Technology: Machine Shop Theory: 00:00:00

Overview This comprehensive course on Mechanical Engineering will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Mechanical Engineering 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 Mechanical Engineering. It is available to all students, of all academic backgrounds. Requirements Our Mechanical Engineering 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 14 sections • 68 lectures • 07:29:00 total length •Lecture 1 Introduction: 00:02:00 •Lecture 2 Multiplying any digit number by 11, 22, and 33: 00:09:00 •Lecture 3 Integers and ordering of integers: 00:06:00 •: 00:00:00 •Lecture 5 Operations on Integers: 00:04:00 •Lecture 6 Multiplication and Division of Integers: 00:04:00 •Lecture 7 Powers of Integers (Exponents): 00:04:00 •Lecture 8 Complete knowledge about factors and multiples: 00:06:00 •Lecture 9 Divisibility tests for 2,3,4,5,6: 00:07:00 •Lecture 10 Divisibility rules 7,8,9,10,11: 00:06:00 •Lecture 11 Prime Factorization: 00:06:00 •Lecture 12 Highest Common Factor HCF: 00:10:00 •Lecture 13 Least Common Multiple LCM: 00:16:00 •Lecture 14 Relation between LCM and HCF: 00:04:00 •Lecture 15 Classification of Fractions: 00:04:00 •Lecture 16 Convert mixed to improper and improper to mixed fractions: 00:03:00 •Lecture 17 Equivalent Fractions: 00:04:00 •Lecture 18 Comparing Fractions after converting to like fractions: 00:09:00 •Lecture 19 Reducing a fraction to lowest term: 00:04:00 •Lecture 20 Addition and subtraction OF fractions: 00:08:00 •Lecture 21 Multiplication and division of fractions: 00:11:00 •Lecture 22 Word problems on fractions: 00:16:00 •Lecture 23 BODMAS and rules to remove brackets: 00:03:00 •Lecture 24 Simplify expressions using BODMAS rules: 00:05:00 •Lecture 25 Simplify expressions involving fractions using BODMAS: 00:07:00 •Lecture 26 Decimal numbers in relation to fractions: 00:08:00 •Lecture 27 Like and unlike Decimals: 00:05:00 •Lecture 28 Ordering of Decimal numbers: 00:10:00 •Lecture 29 Addition and subtraction of Decimal: 00:07:00 •Lecture 30 Multiplication of Decimal: 00:03:00 •Lecture 31 Division of Decimal: 00:05:00 •Lecture 32 Rational number: 00:02:00 •Lecture 33 Representation of Rational Numbers on Number line: 00:04:00 •Lecture 34 Determining which fraction is terminating or non terminating: 00:05:00 •Lecture 35 shortcut method of writing decimal expansion of fraction to decimal: 00:08:00 •Lecture 36 Rounding to whole number: 00:06:00 •Lecture 37 Rounding to required number of decimals (1 d.p. ): 00:05:00 •Lecture 38 rounding to significant digits: 00:07:00 •Lecture 39 Practice question on three methods of approximation: 00:05:00 •Lecture 40 Estimation: 00:05:00 •Lecture 41 Scientific Notation: 00:07:00 •Lecture 42 Operation on numbers when they are in scientific notation: 00:06:00 •Lecture 43 Percentage to fraction and fraction to percentage: 00:06:00 •Lecture 44 Percentage of a quantity and conversation to decimal: 00:06:00 •Lecture 45 Expressing one quantity as percentage of another quantity: 00:06:00 •Lecture 46 Finding increase decrease percent: 00:05:00 •Lecture 47 Uses of percentages-Word Problems: 00:09:00 •Lecture 48 Ratio- How to express as simple ratio: 00:09:00 •Lecture 49 How to compare Ratios: 00:04:00 •Lecture 50 Word problems on finding ratios: 00:07:00 •Lecture 51To divide a given quantity into a given Ratio: 00:11:00 •Lecture 52 Proportion: 00:04:00 •Lecture 53 Practice problems on Proportion: 00:06:00 •Lecture 54 Continued proportion: 00:06:00 •Lecture 55 Direct Variation ( or proportion): 00:04:00 •Lecture 56 Problems based on Direct proportion: 00:10:00 •Lecture 57 Inverse Variation ( or proportion): 00:10:00 •Lecture 58 Multiple Ratios: 00:10:00 •Lecture 59 Basics - Profit and Loss: 00:04:00 •Lecture 60 More practice problems on Profit & Loss: 00:06:00 •Lecture 61 Selling price formula and Problems: 00:04:00 •Lecture 62 Cost price formula and Problems: 00:03:00 •Lecture 63 Higher problems on Profit and Loss: 00:08:00 •Lecture 64 Basics - Discount.mp4: 00:05:00 •Lecture 65 Practice problems on Discount: 00:04:00 •Lecture 66 Tax: 00:06:00 •Mock Exam - Functional Skills Maths Teacher: 00:20:00 •Final Exam - Functional Skills Maths Teacher: 00:20:00

Overview This comprehensive course on Data Analysis and Forecasting in Excel will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Data Analysis and Forecasting in Excel 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 Data Analysis and Forecasting in Excel. It is available to all students, of all academic backgrounds. Requirements Our Data Analysis and Forecasting in Excel 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 • 31 lectures • 04:43:00 total length •Insert, Delete, and Adjust Cells, Columns, and Rows: 00:10:00 •Search for and Replace Data: 00:09:00 •Use Proofing and Research Tools: 00:07:00 •Sort Data: 00:10:00 •Filter Data: 00:10:00 •Query Data with Database Functions: 00:09:00 •Outline and Subtotal Data: 00:09:00 •Apply Intermediate Conditional Formatting: 00:07:00 •Apply Advanced Conditional Formatting: 00:05:00 •Create Charts: 00:13:00 •Modify and Format Charts: 00:12:00 •Use Advanced Chart Features: 00:12:00 •Create a PivotTable: 00:13:00 •Analyze PivotTable Data: 00:12:00 •Present Data with PivotCharts: 00:07:00 •Filter Data by Using Timelines and Slicers: 00:11:00 •Use Links and External References: 00:12:00 •Use 3-D References: 00:06:00 •Consolidate Data: 00:05:00 •Use Lookup Functions: 00:12:00 •Trace Cells: 00:09:00 •Watch and Evaluate Formulas: 00:08:00 •Apply Data Validation: 00:13:00 •Search for Invalid Data and Formulas with Errors: 00:04:00 •Work with Macros: 00:18:00 •Create Sparklines: 00:07:00 •MapData: 00:07:00 •Determine Potential Outcomes Using Data Tables: 00:08:00 •Determine Potential Outcomes Using Scenarios: 00:09:00 •Use the Goal Seek Feature: 00:04:00 •Forecasting Data Trends: 00:05:00

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 Microsoft Excel - 25 Must-Know Formulas and Functions will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Microsoft Excel - 25 Must-Know Formulas and Functions 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 Microsoft Excel - 25 Must-Know Formulas and Functions. It is available to all students, of all academic backgrounds. Requirements Our Microsoft Excel - 25 Must-Know Formulas and Functions 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 2 sections • 2 lectures • 01:12:00 total length •Must-Know Formulas and Functions: 01:12:00 •Resource - Microsoft Excel - 25 Must-Know Formulas and Functions: 00:00:00

Functional Skills Maths is essential for everyday life, from calculating bills to working out a discount in a sale. Understanding integers, fractions, decimals, percentages, and ratios are all necessary skills that are needed to function in modern society. Learning outcomes: Develop an understanding of integers and how to perform operations with them. Learn about factors, multiples, and simplification rules to solve numerical problems. Develop an understanding of fractions, decimals, and rational numbers and learn how to perform operations with them. Understand approximation, estimation, and scientific notation or standard form. Learn how to calculate percentages and ratios and how to apply them to real-life situations. Understand profit, loss, discount, and tax and learn how to calculate them in different scenarios. This Functional Skills Maths course covers a range of topics that are essential for daily life. Through this course, you will learn about integers, factors, multiples, fractions, decimals, rational numbers, approximation, estimation, scientific notation or standard form, percentages, ratios, and profit, loss, discount, and tax. This course aims to provide you with the knowledge and skills needed to function effectively in modern society. Whether you are a student, professional, or someone who wants to improve their math skills, this course is suitable for anyone who wants to develop their mathematical abilities. The course is delivered through online tutorials, quizzes, and video lectures, allowing you to learn at your own pace and in your own time. Upon completion of this course, you will be able to perform mathematical operations with integers, fractions, decimals, and percentages. You will be able to calculate ratios and apply them to real-life situations. You will also be able to understand profit, loss, discount, and tax and how to calculate them in different scenarios. Certification Upon completion of the course, learners can obtain a certificate as proof of their achievement. You can receive a £4.99 PDF Certificate sent via email, a £9.99 Printed Hardcopy Certificate for delivery in the UK, or a £19.99 Printed Hardcopy Certificate for international delivery. Each option depends on individual preferences and locations. CPD 10 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Students who want to improve their math skills. Professionals who need to perform calculations as part of their job. Individuals who want to develop their mathematical abilities. Anyone who wants to improve their understanding of maths. Career path Accounting Assistant: £16,000 - £28,000 per year Sales Assistant: £14,000 - £22,000 per year Administrative Assistant: £16,000 - £24,000 per year Retail Supervisor: £18,000 - £28,000 per year Customer Service Representative: £16,000 - £24,000 per year Warehouse Operative: £14,000 - £22,000 per year