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

520 Courses in Cardiff delivered Online

Level 2 Diploma in JavaScript Course

By One Education

Ready to make JavaScript less of a mystery and more of a skill you actually understand? This Level 2 Diploma in JavaScript is a refreshing take on learning one of the most widely-used programming languages on the internet. Whether you're aiming to build dynamic websites or improve your coding fluency, this course delivers clarity and confidence without overwhelming you with jargon. It takes you through JavaScript’s essential concepts—like variables, functions, objects, loops, and logic—with a rhythm that’s structured for those who enjoy learning with purpose. Written with a modern developer's mindset in mind (but no flashy nonsense), this course avoids empty filler and gets straight to the core of what you need to know. Whether you're enhancing your knowledge or brushing up on what you forgot last Tuesday, each module builds logically on the last, encouraging solid, repeatable understanding. If JavaScript ever felt like an unsolvable puzzle, this diploma gives you the pieces in the right order—so things actually click. Learning outcomes: Upon completing the JavaScript Basics course, learners will be able to: Understand the fundamentals of JavaScript programming, including data types, variables, and functions. Create basic JavaScript programs to perform simple tasks, such as manipulating HTML elements and responding to user interactions. Develop a strong understanding of JavaScript scope and how to work with objects and arrays. Write more complex JavaScript programs using advanced programming concepts such as loops, conditionals, and events. Implement string manipulation and data validation in their JavaScript code. The JavaScript Basics course is designed to provide learners with a foundational understanding of JavaScript programming. This course is perfect for beginners who are interested in learning the basics of JavaScript, as well as developers who want to refresh their knowledge of the language. The course covers everything from the basics of JavaScript syntax to more advanced programming concepts such as events and loops. Learners will also gain practical experience by working on real-world examples and projects. This course is taught by industry experts who have years of experience in JavaScript development. They will provide learners with a comprehensive understanding of JavaScript programming and how it can be used to create interactive and dynamic web applications. The course is designed to be self-paced, allowing learners to work at their own speed and learn at their own convenience. ⊱⊱Level 2 Diploma in JavaScript Course Curriculum Section 01: JavaScript Introduction Section 02: JavaScript Examples Section 03: JavaScript Data Types Section 04: JavaScript Objects and Functions Section 05: Java Script Scope Section 06: JavaScript Events and String How is the course assessed? Upon completing an online module, you will immediately be given access to a specifically crafted MCQ test. For each test, the pass mark will be set to 60%. Exam & Retakes: It is to inform our learners that the initial exam for this online course is provided at no additional cost. In the event of needing a retake, a nominal fee of £9.99 will be applicable. Certification Upon successful completion of the assessment procedure, learners can obtain their certification by placing an order and remitting a fee of __ GBP. £9 for PDF Certificate and £15 for the Hardcopy Certificate within the UK ( An additional £10 postal charge will be applicable for international delivery). CPD 10 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Beginners who want to learn the fundamentals of JavaScript programming. Developers who want to refresh their knowledge of JavaScript. Individuals who want to create dynamic and interactive web applications. Students who want to prepare for a career in web development. Professionals who want to expand their skillset and stay competitive in the job market. Requirements There are no formal entry requirements for the course, with enrollment open to anyone! Career path Web Developer Front-End Developer Full-Stack Developer JavaScript Developer Software Engineer Certificates Certificate of completion Digital certificate - £9 You can apply for a CPD Accredited PDF Certificate at the cost of £9. Certificate of completion Hard copy certificate - £15 Hard copy can be sent to you via post at the expense of £15.

Level 2 Diploma in JavaScript Course
Delivered Online On Demand2 hours
£12

AngularDart: Build Dynamic Web Apps with Angular and Dart

By Packt

Master Angular and Dart (AngularDart) and build high-performance, flexible, and dynamic web apps

AngularDart: Build Dynamic Web Apps with Angular and Dart
Delivered Online On Demand9 hours 51 minutes
£126.99

Microsoft Office Bundle

4.7(160)

By Janets

Is it possible to imagine an office without Microsoft Office software? Surely your answer would be a big NO! It's a core computer skill that every employer wants from every employee and every employee wants to mention in the resume. The Microsoft Office course is a Bundle of everything you need to know for using the most essential software by Microsoft. From creating a file to analysing data, this course will make you familiar with all the important and amazing aspects. You will learn how to create a file and how to use various advanced tools in Microsoft Office from this Microsoft Office training. The course also includes the basic and advanced features of Microsoft Word, Excel, PowerPoint, Outlook and Access. This course will open a new dimension about your knowledge of Microsoft office. This comprehensive course is designed for those who are dreaming of establishing their career in an office job. On successful completion of the course, you will get accredited certification as proof of your in-demand skills in Microsoft Office, which will give a competitive advantage in the job market. Enrol Now to start boosting your Supply Chain Management skills! Key topics to be covered Microsoft Word (Documentation, Formatting, Referencing) Microsoft Excel (Macros, Formulas, What-If Analysis, Integration) Microsoft PowerPoint (Preparation, Animations and Transitions, Slide management) Microsoft Outlook (Sort, Filter, Organise messages, Contact and calendar management) Microsoft Access (Navigation with Forms, Formatting, Validation) Learning Outcomes Know the basic to advanced Microsoft Word skills, with this Microsoft Word course, including document management, comments, compare, review, captions, cross-references, bookmarks, hyperlinks, footnotes and endnotes, citations, table of contents, digital signature, data conversion and much more of Microsoft Word 2016. Learn about macros, conditional formatting, troubleshooting invalid data and formula errors, activity-troubleshooting invalid data and formula errors, sparklines, scenarios, what-if analysis, statistical analysis, importing and exporting XML data, and other advanced features in Microsoft Excel 2016. Master slide layouts, headers and footers, SmartArt, audio and video to create a presentation, use animation and transitions, annotate a presentation, set up a slideshow, record a presentation, secure a presentation, and other advanced features in Microsoft PowerPoint 2016. Learn the basic to advanced features of Microsoft Outlook and Microsoft Access. Get all the tips and tricks for the MS office package. Who is this course for? Anyone who wants to gain extensive knowledge, potential experience and professional skills in MS Office. Those who have interest in Microsoft Office courses are a perfect match. Students from any academic backgrounds Why Choose this Course Earn a digital Certificate upon successful completion. Accessible, informative modules taught by expert instructors Study in your own time, at your own pace, through your computer tablet or mobile device Benefit from instant feedback through mock exams and multiple-choice assessments Get 24/7 help or advice from our email and live chat teams Full Tutor Support on Weekdays Course Design The course is delivered through our online learning platform, accessible through any internet-connected device. There are no formal deadlines or teaching schedules, meaning you are free to study the course at your own pace. You are taught through a combination of- Video lessons Online study supplies Mock tests Multiple-choice evaluation Career path You can add this Microsoft office Course certification to your resume to get closer to securing your dream job. With the skills of MS Office, you will be prepared for any professional office environment setup. The Microsoft Office Course will equip you with skills that can be applied to a range of roles, especially in the corporate sector. Enrol in this Microsoft office Course certification today and increase your productivity in the office in no time! Certification Upon successful completion of the course, you will be able to obtain your course completion e-certificate. A print copy by post is also available at an additional cost of £9.99 and PDF Certificate at £4.99. What are you waiting for? Enrol in the Professional Childcare and Nannying Courses now!

Microsoft Office Bundle
Delivered Online On Demand4 days
£9.99

Sales Analysis in Excel

4.8(9)

By Skill Up

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

Sales Analysis in Excel
Delivered Online On Demand6 hours 26 minutes
£25

Quantitative Analyst

4.8(9)

By Skill Up

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

Quantitative Analyst
Delivered Online On Demand6 hours 36 minutes
£25

30+ Web Projects with HTML, CSS, and JavaScript

By Packt

Welcome to a brand-new course, where you can learn how to create modern and beautiful web projects and templates; if you want to develop and customize your portfolio, become an experienced developer, then this is the right course for you. Level-up your HTML, CSS, and JavaScript coding skills with this course.

30+ Web Projects with HTML, CSS, and JavaScript
Delivered Online On Demand14 hours 25 minutes
£14.99

Microsoft Access for Office 365 (Desktop or Online) - Part 2

By Nexus Human

Duration 2 Days 12 CPD hours This course is intended for This course is designed for students wishing to gain intermediate-level skills or individuals whose job responsibilities include constructing relational databases and developing tables, queries, forms, and reports in Microsoft Access for Office 365. Overview In this course, you will optimize an Access database. You will: Provide input validation features to promote the entry of quality data into a database. Organize a database for efficiency and performance, and to maintain data integrity. Improve the usability of Access tables. Create advanced queries to join and summarize data. Use advanced formatting and controls to improve form presentation. Use advanced formatting and calculated fields to improve reports. In this course, you will expand your knowledge of relational database design; promote quality input from users; improve database efficiency and promote data integrity; and implement advanced features in tables, queries, forms, and reports. Extending your knowledge of Access will result in a robust, functional database for your users.This course covers Microsoft Office Specialist Program exam objectives to help you prepare for the Access Expert (Office 365 and Office 2019): Exam MO-500 certification. Improving Table Usability Topic A: Create Lookups Within a Table Topic B: Work with Subdatasheets Creating Advanced Queries Topic A: Create Query Joins Topic B: Create Subqueries Topic C: Summarize Data Improving Form Presentation Topic A: Apply Conditional Formatting Topic B: Create Tab Pages with Subforms and Other Controls Creating Advanced Reports Topic A: Apply Advanced Formatting to a Report Topic B: Add a Calculated Field to a Report Topic C: Control Pagination and Print Quality Topic D: Add a Chart to a Report Importing and Exporting Table Data Topic A: Import and Link Data Topic B: Export Data Topic C: Create a Mail Merge Using Queries to Manage Data Topic A: Create Action Queries Topic B: Create Unmatched and Duplicate Queries Creating Complex Reports and Forms Topic A: Create Subreports Topic B: Create a Navigation Form Topic C: Show Details in Subforms and Popup Forms Creating Access Macros Topic A: Create a Standalone Macro to Automate Repetitive Tasks Topic B: Create a Macro to Program a User Interface Component Topic C: Filter Records by Using a Condition Topic D: Create a Data Macro Using VBA to Extend Database Capabilities Topic A: Introduction to VBA Topic B: Using VBA with Form Controls Managing a Database Topic A: Back Up a Database Topic B: Manage Performance Issues Topic C: Document a Database Distributing and Securing a Database Topic A: Split a Database for Multiple-User Access Topic B: Implement Security Topic C: Convert an Access Database to an ACCDE File Topic D: Package a Database with a Digital Signature

Microsoft Access for Office 365 (Desktop or Online) - Part 2
Delivered OnlineFlexible Dates
Price on Enquiry

Deep Learning & Neural Networks Python - Keras

4.7(160)

By Janets

Description Register on the Deep Learning & Neural Networks Python - Keras today and build the experience, skills and knowledge you need to enhance your professional development and work towards your dream job. Study this course through online learning and take the first steps towards a long-term career. The course consists of a number of easy to digest, in-depth modules, designed to provide you with a detailed, expert level of knowledge. Learn through a mixture of instructional video lessons and online study materials. Receive online tutor support as you study the course, to ensure you are supported every step of the way. Get a certificate as proof of your course completion. The Deep Learning & Neural Networks Python - Keras course is incredibly great value and allows you to study at your own pace. Access the course modules from any internet-enabled device, including computers, tablets, and smartphones. The course is designed to increase your employability and equip you with everything you need to be a success. Enrol on the now and start learning instantly! What You Get With This Course Receive a digital certificate upon successful completion of the course Get taught by experienced, professional instructors Study at a time and pace that suits your learning style Get instant feedback on assessments 24/7 help and advice via email or live chat Get full tutor support on weekdays (Monday to Friday) Certificate of Achievement After the successful completion of the final assessment, you will receive a CPD-accredited certificate of achievement. The PDF certificate is for 9.99, and it will be sent to you immediately after through e-mail. You can get the hard copy for 15.99, which will reach your doorsteps by post.  Method of Assessment You need to attend an assessment right after the completion of this course to evaluate your progression. For passing the assessment, you need to score at least 60%. After submitting your assessment, you will get feedback from our experts immediately. Who Is This Course For The course is ideal for those who already work in this sector or are aspiring professionals. This course is designed to enhance your expertise and boost your CV. Learn key skills and gain a professional qualification to prove your newly-acquired knowledge.   Course Content 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 - Data Preparation - Standardization 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 Handwritten Digit Recognition Dataset 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

Deep Learning & Neural Networks Python - Keras
Delivered Online On Demand11 hours 11 minutes
£25

Microsoft Excel: Automated Dashboard Using Advanced Formula, VBA, Power Query

4.7(160)

By Janets

Register on the Microsoft Excel: Automated Dashboard Using Advanced Formula, VBA, Power Query today and build the experience, skills and knowledge you need to enhance your professional development and work towards your dream job. Study this course through online learning and take the first steps towards a long-term career. The course consists of a number of easy to digest, in-depth modules, designed to provide you with a detailed, expert level of knowledge. Learn through a mixture of instructional video lessons and online study materials. Receive online tutor support as you study the course, to ensure you are supported every step of the way. Get a digital certificate as a proof of your course completion. The Microsoft Excel: Automated Dashboard Using Advanced Formula, VBA, Power Query course is incredibly great value and allows you to study at your own pace. Access the course modules from any internet-enabled device, including computers, tablet, and smartphones. The course is designed to increase your employability and equip you with everything you need to be a success. Enrol on the now and start learning instantly! What You Get With The Microsoft Excel: Automated Dashboard Using Advanced Formula, VBA, Power Query course Receive a e-certificate upon successful completion of the course Get taught by experienced, professional instructors Study at a time and pace that suits your learning style Get instant feedback on assessments 24/7 help and advice via email or live chat Get full tutor support on weekdays (Monday to Friday) Course Design The course is delivered through our online learning platform, accessible through any internet-connected device. There are no formal deadlines or teaching schedules, meaning you are free to study the course at your own pace. You are taught through a combination of Video lessons Online study materials Certification After the successful completion of the final assessment, you will receive a CPD-accredited certificate of achievement. The PDF certificate is for £9.99, and it will be sent to you immediately after through e-mail. You can get the hard copy for £15.99, which will reach your doorsteps by post. Who Is This Course For: The course is ideal for those who already work in this sector or are an aspiring professional. This course is designed to enhance your expertise and boost your CV. Learn key skills and gain a professional qualification to prove your newly-acquired knowledge. Requirements: The online training is open to all students and has no formal entry requirements. To study the Microsoft Excel: Automated Dashboard Using Advanced Formula, VBA, Power Query 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. Course Content Introduction Course Outline and Introduction 00:04:00 Minimum Requirements for the Course 00:01:00 Prepayments Introduction 00:01:00 Prepaid Expenses Models: Resources Download Month End Date Prepaid Expenses Amortization Calculation 00:00:00 Exact Prepaid Expenses Payment Date Calculation 00:00:00 Accounting for Prepaid Expenses Prepaid Expenses Accounting Definition: Prepayments 00:03:00 Prepaid Expense Example: How Accounting works for Prepayments 00:03:00 Advantages and Disadvantages of Prepaid Expenses 00:03:00 Excel Formulas Detailed: Introduction to three Excel Models Introduction to PRO Excel Models and Formulas 00:06:00 Date Function 00:05:00 EOMONTH Function 00:04:00 DATEVALUE function 00:03:00 IF Function 00:08:00 IFS Function (Office 365 Only) 00:07:00 VLOOKUP Function 00:07:00 MATCH Function 00:05:00 INDIRECT Function 00:02:00 NAMED Ranges: Name Manager 00:03:00 Advanced Version of VLOOKUP Function 00:07:00 Formula Based Prepaid Expenses Model Introduction to Model and Control Panel Tab (Important Sheet Tab) 00:08:00 Formula Based Prepaid Expenses Model - Deep Dive (Part 1) 00:05:00 Formula Based Prepaid Expenses Model - Deep Dive (Part 2) 00:06:00 Formula Based Prepaid Expenses Model - Deep Dive (Part 3) 00:06:00 IFS Function - Month End date Prepayment calculation 00:04:00 Prepaid Expenses - Closing Balance Summary Tab (Formula Based Summary) 00:09:00 Protecting Formulas Cells and Fields in the Model 00:04:00 Calculate Prepaid Expenses Amortisation from Exact Start Date Exact Date Prepaid Amortisation calculation Intro 00:03:00 Formulas update and Model Changes for Exact Prepaid Exps Calculation 00:03:00 Formulas Update for Exact Date Prepaid Exps Amortisation (Part 1) 00:04:00 Formulas Update for Exact Date Prepaid Exps Amortisation (Part 2) 00:03:00 Formulas Update for Exact Date Prepaid Exps Amortisation (Part 3) 00:02:00 Formulas Update for Exact Date Prepaid Exps Amortisation (Part 4) 00:07:00 IFS Function - Exact Date Prepayments Amortisation 00:04:00 Data Validation Controls (Enhancing Data Input Controls with Protection) 00:10:00 Bonus: Prepayment Model with Opening Balance Calculation (Part 1) 00:08:00 Bonus: Prepayment Model with Opening Balance Calculation (Part 2) 00:09:00 Additional Material: Resources 00:00:00 Prepaid Expenses Summary with Power Query and Pivot Table Power Query and Pivot Table Prepayment Summary Table Intro 00:06:00 What is Power Query and Some Awesome Resources for Power Query learning 00:07:00 Power Query and Pivot Table Summary - Deep Dive (Part 1) 00:05:00 Power Query and Pivot Table Summary - Deep Dive (Part 2) 00:04:00 Power Query and Pivot Table Summary - Deep Dive (Part 3) 00:05:00 Power Query and Pivot Table Summary - Deep Dive (Part 4) 00:09:00 Using Array Formulas to Add Formula Protection 00:04:00 Bonus: Allocate Prepaid Expenditure Cost Centre Wise - 1 00:02:00 Bonus: Allocate Prepaid Expenditure Cost Centre Wise - 2 00:08:00 Bonus: Prepayment Model with Opening Balance Calculation (PQ and PT Version) 00:13:00 Advanced VBA Prepaid Expenses Amortisation Model Changing Macros Security in Excel 00:05:00 Complete Walkthrough - Advanced VBA Prepaid Expenses Amortisation Model 00:06:00 Bonus : New Version - Excel VBA Model for Prepayment Expenditure 00:08:00 BONUS: Dynamic Dashboard for Divisional Profit and Loss statements: Easy Way Dynamic Dashboard Overview 00:07:00 Importing Profit and Loss Statements Source Files and creating YTD P&L Sheets 00:08:00 Creating Dynamic Data Validation 00:02:00 Creating Named Ranges for Dynamic Table Arrays 00:03:00 Dynamic Date Column Headings for each Divisional PL Table 00:02:00 Dynamic Month and YTD Dashboard tables headings (PRO TIP) 00:03:00 Dynamic VLOOKUP Formula - Preparing First section of the Dashboard 00:04:00 Creating Rolling Dashboard with Dynamic VLOOKUP Function 00:08:00 IMPORTANT : Error Checking for your reports/Dashboard (PRO TIP) 00:03:00 Data Prep for Visualization: AREA Charts (Awesome trick using #NA Function) 00:05:00 Visualization: AREA Charts for Month - Revenue, Gross Profit and Net Profit 00:05:00 Visualization DONUT Charts Revenue, Gross Profit and Net Profit (Part 1) 00:03:00 Visualization DONUT Charts Revenue, Gross Profit and Net Profit (Part 2) 00:06:00 Power Query & Pivot Tables based Dashboard without any Formulas, Fully Dynamic Introduction - Formula-less Dashboard - Fully Dynamic and easily refreshed 00:05:00 Understanding the data files before building dashboard 00:02:00 Consolidating Reports with Power Query (Get & Transform) , How to install PQ 00:08:00 Dynamic File Path Trick in Power Query with Parameters (Amazing trick) 00:06:00 Conditional Cumulative totals with SUMIFS Function 00:04:00 Bonus: Conditional Cumulative totals with Power Query Custom Formula (M Code) 00:06:00 Dashboard Creation - Pivot Table showing Month and YTD KPIs division wise 00:06:00 Dashboard Creation Donuts Charts linked with Pivot Table (Replicate Charts fast) 00:08:00 Dashboard Creation - Line Charts 00:08:00 Update Dashboard with Additional Divisional Data with Few Click (Magical) 00:03:00 Thank you Thank you 00:02:00 Ultimate Prepaid Expenditure Model (Super Bonus) 00:02:00 Resources Resources - Microsoft Excel: Automated Dashboard Using Advanced Formula, VBA, Power Query 00:00:00 Frequently Asked Questions Are there any prerequisites for taking the course? There are no specific prerequisites for this course, nor are there any formal entry requirements. All you need is an internet connection, a good understanding of English and a passion for learning for this course. Can I access the course at any time, or is there a set schedule? You have the flexibility to access the course at any time that suits your schedule. Our courses are self-paced, allowing you to study at your own pace and convenience. How long will I have access to the course? For this course, you will have access to the course materials for 1 year only. This means you can review the content as often as you like within the year, even after you've completed the course. However, if you buy Lifetime Access for the course, you will be able to access the course for a lifetime. Is there a certificate of completion provided after completing the course? Yes, upon successfully completing the course, you will receive a certificate of completion. This certificate can be a valuable addition to your professional portfolio and can be shared on your various social networks. Can I switch courses or get a refund if I'm not satisfied with the course? We want you to have a positive learning experience. If you're not satisfied with the course, you can request a course transfer or refund within 14 days of the initial purchase. How do I track my progress in the course? Our platform provides tracking tools and progress indicators for each course. You can monitor your progress, completed lessons, and assessments through your learner dashboard for the course. What if I have technical issues or difficulties with the course? If you encounter technical issues or content-related difficulties with the course, our support team is available to assist you. You can reach out to them for prompt resolution.

Microsoft Excel: Automated Dashboard Using Advanced Formula, VBA, Power Query
Delivered Online On Demand6 hours 8 minutes
£25

.NET Developer with HTML Basic and JavaScript

By Compliance Central

All in One Bundle Special Discount Offer Are you looking to enhance your .NET Developer with HTML Basic and JavaScript skills? If yes, then you have come to the right place. Our comprehensive courses on .NET Developer with HTML Basic and JavaScript will assist you in producing the best possible outcome by learning the .NET Developer with HTML Basic and JavaScript skills. CPD Accredited courses you will get: Course 01: Asp.Net Webforms from Scratch for Beginners Course 02: Time Management Skills Course 03: Office Skills The .NET Developer with HTML Basic and JavaScript bundle is for those who want to be successful. In the .NET Developer with HTML Basic and JavaScript bundle, you will learn the essential knowledge needed to become well versed in .NET Developer with HTML Basic and JavaScript . Our .NET Developer with HTML Basic and JavaScript bundle starts with the basics of .NET Developer with HTML Basic and JavaScript and gradually progresses towards advanced topics. Therefore, each lesson of this .NET Developer with HTML Basic and JavaScript is intuitive and easy to understand. Why would you choose the .NET Developer with HTML Basic and JavaScript course from Compliance Central: Lifetime access to .NET Developer with HTML Basic and JavaScript courses materials Full tutor support is available from Monday to Friday with the .NET Developer with HTML Basic and JavaScript course Learn .NET Developer with HTML Basic and JavaScript skills at your own pace from the comfort of your home Gain a complete understanding of .NET Developer with HTML Basic and JavaScript course Accessible, informative .NET Developer with HTML Basic and JavaScript learning modules designed by expert instructors Get 24/7 help or advice from our email and live chat teams with the .NET Developer with HTML Basic and JavaScript bundle Study .NET Developer with HTML Basic and JavaScript in your own time through your computer, tablet or mobile device Curriculum of Course 01: Asp.Net Webforms from Scratch for Beginners Web Programming Introduction HTML Basic and JavaScript ASP.NET Introduction & Environment Setup ASP.NET Architecture CSS & Themes Page Redirection Master Pages and Common URL's Writing Validation Controls ASP.NET State Management WebConfiguration File & Global.asax Authentication and Authorization Insert Update Delete Data Bound Controls Login Form Using OTP AJAX implementation on ASP.NET Debug Tools Usage in Visual Studio Mapping and Routing Build and Publish Web Application IIS Internet Information Services and Deploy Web Application HTTP to HTTPS Configuration BONUS LECTURE: What Next? Curriculum of Course 02: Time Management Skills Module 01: Importance and Benefits of Time Management Module 02: Assess Your Current Work Practice Module 03: Identifying the Priorities Module 04: Say 'No' to Procrastination Module 05: Set Your Goals Module 06: Plan the Work Module 07: Work the Plan Module 08: Effective Time Management Techniques Module 09: Combat the Time Wasters Module 10: Time Management for Creative Work Module 11: The Art of Anticipating Module 12: Avoid Time Leaks Curriculum of Course 03: Office Skills Module 01: Core Office Skills Module 02: Self-Management Module 03: Organizing and Planning (i) Module 04: Organizing and Planning (ii) Module 05: Rapport Building CPD 30 CPD hours / points Accredited by CPD Quality Standards Who is this course for? The .NET Developer with HTML Basic and JavaScript bundle helps aspiring professionals who want to obtain the knowledge and familiarise themselves with the skillsets to pursue a career in .NET Developer with HTML Basic and JavaScript . It is also great for professionals who are already working in .NET Developer with HTML Basic and JavaScript and want to get promoted at work. Requirements To enrol in this .NET Developer with HTML Basic and JavaScript course, all you need is a basic understanding of the English Language and an internet connection. Career path The .NET Developer with HTML Basic and JavaScript course will enhance your knowledge and improve your confidence in exploring opportunities in various sectors related to .NET Developer with HTML Basic and JavaScript. Certificates 3 CPD Accredited PDF Certificate Digital certificate - Included Get 3 CPD accredited PDF certificate for Free. Each CPD Accredited Hard Copy Certificate Hard copy certificate - £10.79 CPD Accredited Hardcopy Certificate Delivery Charge: Inside the UK: Free Outside of the UK: £9.99 each

.NET Developer with HTML Basic and JavaScript
Delivered Online On Demand15 hours
£12