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

371 Courses in Cardiff delivered On Demand

Access 2016 Intermediate

By iStudy UK

This Access 2016 Intermediate is specially designed for you if you are thinking to take your Microsoft Access skills to the next level. Through the course, you'll master more advanced techniques for this powerful database program and build an entire database project from scratch.  From building reports to using conditional formatting, you'll see how to present your data and gain techniques for using Visual Basic to automate common tasks. You will learn to design tables for improved accuracy in data entry by setting default values and restricting data entry, review the various options to share data with other applications, including Word and Excel, learn about Action Queries to automate updating, appending and deleting table data, and review various advanced query techniques such as using Query Joins, Parameter queries, working with totals and Crosstab queries. Finally, you'll build a navigation form to make it easy for your users to find their way around your database.  What Will I Learn? Design Tables for Better Data Entry Share Data with Other Applications Work with Action Queries Advanced Query Techniques Automate Processes with Macros Advanced Forms Advanced Report Techniques Requirements Access 2016 Introduction or equivalent experience. Who is the target audience? Students who want to take Access to the next level and improve their database design skills. Introduction Introduction FREE 00:01:00 Designing Tables for Better Data Entry Reviewing Table Design Principles 00:04:00 Setting Field Size, Formats and Captions 00:06:00 Setting Default Value and Required Fields 00:03:00 Restricting Data Entry Using Data Validation 00:02:00 Restricting Data Entry Using Input Masks 00:06:00 Sharing Data with Other Applications Exporting Tables and Queries to Excel 00:03:00 Importing Data from a TXT File 00:03:00 Importing Data from Excel 00:02:00 Exporting Data to a TXT File 00:02:00 Linking External Data Sources 00:03:00 Using Word Merge 00:02:00 Working with Action Queries What are Action Queries 00:02:00 Creating an Update Query 00:02:00 Creating an Append Query 00:03:00 Creating a Delete Query 00:02:00 Creating a Make Table Query 00:02:00 Changing the Start Number of an Auto Number Field 00:03:00 Advanced Query Techniques Creating Query Joins 00:05:00 Creating Find Unmatached and Find Duplicate Queries 00:03:00 Creating Parameter Queries 00:04:00 Using -Like- Keyword in Parameter Queries 00:02:00 Creating a Top X Query 00:02:00 Reviewing Calculated Query Fields 00:03:00 Summarizing Query Data with Totals 00:03:00 Inserting Where Statements in Summary Queries 00:01:00 Creating a Crosstab Query 00:03:00 Automating Processes with Macros Understanding Macro Basics 00:06:00 Creating Macros to Open Forms by Record 00:04:00 Validating Data Entry with Macros 00:04:00 Creating a Macro to Automate Data Entry 00:03:00 Advanced Data Entry Using Macros and DLOOKUP Function 00:06:00 Advanced Form Using Conditional Formatting 00:02:00 Organizing Form Fields with Tab Controls 00:03:00 Creating a Combo Box Control 00:02:00 Creating an Option Group Control 00:03:00 Using a Subform to Show Data from a Related Table 00:03:00 Advanced Report Techniques Inserting a Chart on a Report 00:03:00 Showing Data in Columns 00:02:00 Inserting a Subreport 00:02:00 Configuring Reports with Parameter Queries 00:04:00 Sending Reports 00:02:00 Conclusion Course Recap 00:01:00 Resources Resources - Access 2016 Intermediate 00:00:00 Course Certification

Access 2016 Intermediate
Delivered Online On Demand2 hours 7 minutes
£25

Building Microservices API in Go

By Packt

Master Go programming with an in-depth course covering advanced topics such as authentication, authorization, JWT tokens, and refresh tokens. Learn how to write reliable code with effective unit testing techniques, while exploring concepts such as logging, error handling, and modularization. Build secure and scalable web applications with Go to take your coding expertise to the next level.

Building Microservices API in Go
Delivered Online On Demand6 hours 44 minutes
£82.99

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

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

Machine Learning

By Compete High

🚀 Unlock the Power of Data with Our Machine Learning Course! 🤖 Are you ready to dive into the revolutionary world of Machine Learning? Welcome to our comprehensive course designed to equip you with the skills and knowledge needed to harness the potential of data-driven decision-making. 🎓 Machine Learning has rapidly emerged as one of the most transformative technologies of the 21st century. From powering intelligent virtual assistants to revolutionizing healthcare diagnostics, its applications are boundless. With our expertly crafted course, you'll embark on a journey that will demystify the complexities of Machine Learning and empower you to leverage its capabilities for diverse purposes. 💡 Why Machine Learning? In today's data-driven world, organizations across industries are seeking professionals who can extract actionable insights from vast amounts of data. Machine Learning offers the tools and techniques necessary to analyze complex datasets, identify patterns, and make predictions with unprecedented accuracy. By mastering Machine Learning, you'll gain a competitive edge in the job market and position yourself as a valuable asset to any organization. 📈 What You'll Learn: Our Machine Learning course covers a wide array of topics, including: Fundamentals of Machine Learning algorithms Supervised, unsupervised, and reinforcement learning techniques Data preprocessing and feature engineering Model evaluation and validation Deep learning and neural networks Practical applications and case studies With hands-on projects and real-world examples, you'll not only understand the theory behind Machine Learning but also gain practical experience in implementing algorithms and solving complex problems. Whether you're a beginner or an experienced data professional, our course is tailored to accommodate learners of all levels. 📊 Who is this for? Our Machine Learning course is ideal for: Aspiring data scientists and analysts Software engineers looking to transition into Machine Learning roles Business professionals seeking to leverage data for strategic decision-making Students and academics interested in exploring the forefront of technology No matter your background or experience level, our course provides a solid foundation in Machine Learning principles and techniques, setting you on the path to success in this rapidly evolving field. 🌟 Career Path: By mastering Machine Learning, you'll open doors to a myriad of exciting career opportunities, including: Data Scientist Machine Learning Engineer AI Researcher Business Intelligence Analyst Data Engineer With the demand for Machine Learning professionals on the rise, employers are actively seeking individuals with the skills and expertise to drive innovation and deliver impactful solutions. Whether you're looking to advance your current career or embark on a new professional journey, our course will equip you with the tools and knowledge needed to thrive in today's competitive job market. 💼 FAQ: Q: Is prior programming experience required to enroll in the course? A: While prior programming experience can be beneficial, our course is designed to accommodate learners of all backgrounds. We provide comprehensive tutorials and resources to help you grasp the fundamentals of programming and get started with Machine Learning. Q: How long does it take to complete the course? A: The duration of the course varies depending on your pace and level of commitment. On average, most learners complete the course within 3 to 6 months. However, you have the flexibility to study at your own pace and revisit materials as needed. Q: Are there any prerequisites for enrolling in the course? A: While there are no strict prerequisites, familiarity with basic mathematics, statistics, and programming concepts can be advantageous. We provide supplementary materials and support to help you build the necessary foundation for success in the course. Q: Will I receive a certificate upon completion of the course? A: Yes, upon successfully completing the course requirements, you'll receive a certificate of completion that validates your proficiency in Machine Learning concepts and techniques. This certificate can enhance your credentials and demonstrate your expertise to potential employers. Q: How does the course structure accommodate working professionals? A: Our course offers flexible scheduling options, allowing you to balance your studies with your professional and personal commitments. With on-demand access to course materials and resources, you can learn at your own convenience and progress at a pace that suits your lifestyle. Don't miss out on the opportunity to unlock your full potential with our Machine Learning course! Enroll today and embark on a transformative journey that will shape the future of your career. 🌐✨ Course Curriculum Module 1_ Introduction to Machine Learning Introduction to Machine Learning 00:00 Module 2_ Linear Regression Linear Regression 00:00 Module 3_ Logistic Regression Logistic Regression 00:00 Module 4_ Decision Trees and Random Forests Decision Trees and Random Forests 00:00 Module 5_ Support Vector Machines (SVMs) Support Vector Machines (SVMs) 00:00 Module 6_ k-Nearest Neighbors (k-NN) k-Nearest Neighbors (k-NN) 00:00 Module 7_ Naive Bayes Naive Bayes 00:00 Module 8_ Clustering Clustering 00:00 Module 9_ Dimensionality Reduction Dimensionality Reduction 00:00 Module 10_ Neural Networks Neural Networks 00:00

Machine Learning
Delivered Online On Demand10 hours
£25