371 Courses delivered On Demand

Recognised Accreditation This course is accredited by continuing professional development (CPD). CPD UK is globally recognised by employers, professional organisations, and academic institutions, thus a certificate from CPD Certification Service creates value towards your professional goal and achievement. The Quality Licence Scheme is a brand of the Skills and Education Group, a leading national awarding organisation for providing high-quality vocational qualifications across a wide range of industries. What is CPD? Employers, professional organisations, and academic institutions all recognise CPD, therefore a credential from CPD Certification Service adds value to your professional goals and achievements. Benefits of CPD Improve your employment prospects Boost your job satisfaction Promotes career advancement Enhances your CV Provides you with a competitive edge in the job market Demonstrate your dedication Showcases your professional capabilities What is IPHM? The IPHM is an Accreditation Board that provides Training Providers with international and global accreditation. The Practitioners of Holistic Medicine (IPHM) accreditation is a guarantee of quality and skill. Benefits of IPHM It will help you establish a positive reputation in your chosen field You can join a network and community of successful therapists that are dedicated to providing excellent care to their client You can flaunt this accreditation in your CV It is a worldwide recognised accreditation What is Quality Licence Scheme? This course is endorsed by the Quality Licence Scheme for its high-quality, non-regulated provision and training programmes. The Quality Licence Scheme is a brand of the Skills and Education Group, a leading national awarding organisation for providing high-quality vocational qualifications across a wide range of industries. Benefits of Quality License Scheme Certificate is valuable Provides a competitive edge in your career It will make your CV stand out Course Curriculum How to Discover Amazing Startup Ideas How to Discover Amazing Startup Ideas - Start by Asking these 5 Questions 00:06:00 Spotting Problems Simplified - Overview 00:02:00 Problem Spotting Simplified - Part 1 00:07:00 Problem Spotting Simplified - Part 2 00:09:00 Problem Spotting Simplified - Part 3 00:06:00 Problem Spotting Simplified - Part 4 00:06:00 Problem Spotting Simplified - Part 5 00:01:00 Problem Spotting Simplified - Part 6 00:02:00 Problem Spotting Simplified - Part 7 00:04:00 Problem Spotting Simplified - Part 8 00:04:00 Problem Spotting Simplified - Part 9 00:08:00 The Elusive Problem-Solution Fit Evaluating The Problem-Solution Fit 00:06:00 Problem Assessment - Evaluating the Problem-Solution Fit 00:11:00 Solution Assessment - Evaluating the Problem-Solution Fit 00:08:00 Identifying your Core Customers - Draw your Buyer Avatar/Persona 00:04:00 Evaluating The Product-Market Fit Is your Startup the Next Unicorn? Assessing The Potential of your Startup Idea - Start with the Competition 00:13:00 Assessing the Market for your Startup - Evaluating the Playground 00:07:00 Draw your Startup Blueprint on "Lean Canvas" Draw your Startup Blueprint on “Lean Canvas” 00:12:00 What is Idea Validation and Why Is It a Must-Do Step for Any Startup? What is Idea Validation and Why Is It a Must-Do Step for Any Startup? 00:10:00 13 Approaches to Test Your Startup Ideas 13 Approaches to Test Your Startup Idea 00:06:00 Results of Idea Validation 00:01:00 The Entrepreneurship Trap Entrepreneurs are Resourceful 00:02:00 Entrepreneurship is a Mindset 00:01:00 The Entrepreneurship Trap 00:01:00 Startup Core Characteristics and Failure Rates What is a Startup 00:01:00 Startup Core Characteristics and Failure Rates 00:02:00 Failure Implications For Startup Investors & Failure Rates by Industry 00:03:00 There's No Survivorship Bias 00:01:00 Uncover The #1 Reason Why Most Startups Fails Why Startups Fail - Reason 20 00:02:00 Why Startups Fail - Reason 19 to 15 00:07:00 Why Startups Fail - Reason 14 to 10 00:04:00 Why Startups Fail - Reason 9 to 5 00:04:00 Why Startups Fail - Reason 4 to 2 00:03:00 Uncover The #1 Reason Why Most Startups on the Face of Planet Earth Have Failed 00:03:00 Bonus: Profitable App Development Blueprint for Startups Profitable App Development Blueprint for Startups 00:37:00 Supplementary Resources Supplementary Resources - Entrepreneurship: 60 Day Startup Launch Blueprint 00:00:00 Certificate of Achievement Certificate of Achievement 00:00:00 Get Your Insurance Now Get Your Insurance Now 00:00:00 Feedback Feedback 00:00:00

This course covers Python for data science and machine learning in detail and is for a beginner in Python. You will also learn about core concepts of data science, exploratory data analysis, statistical methods, role of data, challenges of bias, variance and overfitting, model evaluation techniques, model optimization using hyperparameter tuning, grid search cross-validation techniques, and more.

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

Course Overview Gain the skills to master BlackArch, and become a cyber security expert.  The BlackArch Linux Masterclass will teach you how to use BlackArch Linux for ethical hacking and penetration testing. Designed by industry experts, it will equip you with in-demand web application and website hacking skills required to be a top Cyber Security Consultant. Starting with the basics, you will learn how to install and configure Kali Linux and BlackArch Linux, step-by-step. You will familiarise yourself with the different tools for hacking, and learn information hacking, gathering and validation best practices. By the end of the course, you will have the expertise to hack Facebook accounts, Android devices, Windows computers, and wireless networks using BlackArch. This best selling BlackArch Linux Masterclass has been developed by industry professionals and has already been completed by hundreds of satisfied students. This in-depth BlackArch Linux Masterclass is suitable for anyone who wants to build their professional skill set and improve their expert knowledge. The BlackArch Linux Masterclass is CPD-accredited, so you can be confident you're completing a quality training course will boost your CV and enhance your career potential. The BlackArch Linux Masterclass is made up of several information-packed modules which break down each topic into bite-sized chunks to ensure you understand and retain everything you learn. After successfully completing the BlackArch Linux Masterclass, you will be awarded a certificate of completion as proof of your new skills. If you are looking to pursue a new career and want to build your professional skills to excel in your chosen field, the certificate of completion from the BlackArch Linux Masterclass will help you stand out from the crowd. You can also validate your certification on our website. We know that you are busy and that time is precious, so we have designed the BlackArch Linux Masterclass to be completed at your own pace, whether that's part-time or full-time. Get full course access upon registration and access the course materials from anywhere in the world, at any time, from any internet-enabled device.  Our experienced tutors are here to support you through the entire learning process and answer any queries you may have via email.

Description Register on the Master JavaScript with Data Visualization 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 Master JavaScript with Data Visualization 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 Introduction Getting Started Introduction to Getting Started 00:02:00 Course Curriculum 00:05:00 How to Get Pre-Requisites 00:02:00 Getting Started on Windows, Linux or Mac 00:01:00 How to ask a Great Questions 00:02:00 FAQ's 00:01:00 Setting Up Local Development Environment What is JavaScript 00:09:00 Choosing Code Editor 00:03:00 Installing Code Editor (Sublime Text) 00:04:00 Installing Code Editor(Visual Studio Code) 00:07:00 Hello World Program 00:14:00 Getting Output 00:11:00 Summary 00:02:00 JavaScript Fundamentals Introduction 00:02:00 Internal JavaScript 00:13:00 External JavaScript 00:09:00 Inline JavaScript 00:04:00 Async and defer 00:06:00 Variables 00:13:00 Data Types 00:10:00 Numbers 00:06:00 Boolean 00:04:00 Arrays() 00:12:00 Objects 00:06:00 Comments 00:05:00 Summary 00:01:00 JavaScript Strings Introduction 00:02:00 Strings 00:06:00 String Formatting 00:05:00 String Methods 00:12:00 Summary 00:02:00 JavaScript Operators Introduction 00:02:00 Arithmetic operators 00:07:00 Assignment operators 00:03:00 Comparison operators 00:06:00 Logical operators 00:08:00 Summary 00:02:00 JavaScript Conditional Statements Introduction 00:02:00 If statement 00:04:00 If-else statement 00:05:00 If-else-if statement 00:04:00 Switch-case statement 00:09:00 Summary 00:01:00 JavaScript Control Flow Statements Introduction 00:02:00 While loop 00:09:00 Do-while loop 00:03:00 For loop 00:08:00 Break 00:02:00 Continue 00:03:00 Coding Exercise 00:02:00 Solution for Coding Exercise 00:02:00 Summary 00:02:00 JavaScript Functions Introduction 00:02:00 Creating a Function 00:07:00 Function Call() 00:07:00 Function with parameters 00:05:00 Function Bind() 00:06:00 Summary 00:01:00 Data Visualization (Google Chart) Introduction 00:01:00 How to Use Google chart script 00:04:00 Line Graph chart 00:14:00 Scatter plots chart 00:02:00 Bar chart 00:04:00 Pie chart 00:02:00 3D Pie chart 00:02:00 Summary 00:01:00 JavaScript Error Handling Introduction 00:01:00 Try-catch 00:05:00 Try-catch-finally 00:17:00 Summary 00:01:00 JavaScript Client-Side Validations Introduction 00:01:00 On Submit Validation 00:09:00 Input Numeric Validation 00:12:00 Login Form Validation 00:05:00 Password Strength Check Validation 00:04:00 Summary 00:01:00 Order your Certificates & Transcripts Order your Certificates & Transcripts 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.

Learn the power of coding with this Master JavaScript with Data Visualization course. With JavaScript being the focus, this program offers comprehensive insights into the heart of web development. The course begins with the basics, setting up your local development environment, and quickly moves on to exploring JavaScript fundamentals like strings, operators, and control flow statements, preparing you for a deep dive into the world of coding.   Unlock your potential as we guide you through JavaScript's crucial aspects, including functions, error handling, and client-side validations. Each module is designed by industry experts, ensuring your understanding aligns with real-world scenarios. The course offers practical examples, and quizzes, fostering a rich learning environment that stimulates engagement and helps to master the topics.   But what sets this course apart is its emphasis on Data Visualization using Google Chart. The integration of JavaScript with Data Visualization introduces you to new and innovative methods to present data in a more interactive and user-friendly format. By the end of the course, you should be proficient in JavaScript and able to design and implement complex data visualisations. Sign up today for a learning journey combining tech knowledge with creative visualisation skills! Learning Outcomes: After completing the JavaScript with Data Visualization course, you should be able to:   Develop a comprehensive understanding of JavaScript fundamentals. Acquire the ability to write and manipulate JavaScript strings and operators. Gain mastery over JavaScript control flow and conditional statements. Learn to implement robust JavaScript functions for diverse applications. Understand JavaScript error handling and client-side validations. Learn to visualise data using Google Chart tools effectively. Gain the ability to create interactive, data-driven web applications. Who is this course for: This JavaScript with Data Visualization course is ideal for:   Aspiring web developers seeking to learn JavaScript. Data analysts interested in expanding their skillset. Web designers aiming to enhance their interactivity skills. Software engineers looking to broaden their coding repertoire. Any tech enthusiast wanting to harness the power of Data Visualization. Certification After studying the course materials of the JavaScript with Data Visualization course, there will be a written assignment test which you can take either during or at the end of the course. After passing the test, you will have a range of certification options. A CPD Accredited PDF Certificate costs £4.99, while a CPD Accredited Hardcopy Certificate is £8.00. Also, a PDF Transcript costs £4.99, and a Hardcopy Transcript is £9.99. Select according to your needs, and we assure timely delivery of your chosen certificate. Requirements This professionally designed JavaScript with Data Visualization course does not require you to have any prior qualifications or experience. It is open to everyone, and you can access the course from anywhere at any time. Just enrol and start learning! Career Path: Upon completion of this JavaScript with Data Visualization course, you can gain the knowledge and skills required to pursue many career paths, such as:   JavaScript Developer: £35,000 - £55,000 Per year. Front-end Developer: £40,000 - £60,000 Per year. Full-Stack Developer: £45,000 - £70,000 Per year. Data Visualization Engineer: £45,000 - £65,000 Per year. Web Application Developer: £40,000 - £60,000 Per year. Software Engineer: £50,000 - £80,000 Per year. Course Curriculum Introduction Getting Started Introduction to Getting Started 00:02:00 Course Curriculum 00:05:00 How to Get Pre-Requisites 00:02:00 Getting Started on Windows, Linux or Mac 00:01:00 How to ask a Great Questions 00:02:00 FAQ's 00:01:00 Setting up Local Development Environment What is JavaScript 00:09:00 Choosing Code Editor 00:03:00 Installing Code Editor (Sublime Text) 00:04:00 Installing Code Editor(Visual Studio Code) 00:07:00 Hello World Program 00:14:00 Getting Output 00:11:00 Summary 00:02:00 JavaScript Fundamentals Introduction 00:02:00 Internal JavaScript 00:13:00 External JavaScript 00:09:00 Inline JavaScript 00:04:00 Async and defer 00:06:00 Variables 00:13:00 Data Types 00:10:00 Numbers 00:06:00 Boolean 00:04:00 Arrays() 00:12:00 Objects 00:06:00 Comments 00:05:00 Summary 00:01:00 JavaScript Strings Introduction 00:02:00 Strings 00:06:00 String Formatting 00:05:00 String Methods 00:12:00 Summary 00:02:00 JavaScript Operators Introduction 00:02:00 Arithmetic operators 00:07:00 Assignment operators 00:03:00 Comparison operators 00:06:00 Logical operators 00:08:00 Summary 00:02:00 JavaScript Conditional Statements Introduction 00:02:00 If-else-if statement 00:04:00 If-else statement 00:05:00 If-else-if statement 00:04:00 Switch-case statement 00:09:00 Summary 00:01:00 JavaScript Control Flow Statements Introduction 00:02:00 While loop 00:09:00 Do-while loop 00:03:00 For loop 00:08:00 Break 00:02:00 Continue 00:03:00 Coding Exercise 00:02:00 Solution for Coding Exercise 00:02:00 Summary 00:02:00 JavaScript Functions Introduction 00:02:00 Creating a Function 00:07:00 Function Call() 00:07:00 Function with parameters 00:05:00 Function Bind() 00:06:00 Summary 00:01:00 Data Visualization (Google Chart) Introduction 00:01:00 How to Use Google chart script 00:04:00 Line Graph chart 00:14:00 Scatter plots chart 00:02:00 Bar chart 00:04:00 3D Pie chart 00:02:00 3D Pie chart 00:02:00 Summary 00:01:00 JavaScript Error Handling Introduction 00:01:00 Try-catch 00:05:00 Try-catch-finally 00:17:00 Summary 00:01:00 JavaScript Client-side Validations Introduction 00:01:00 On Submit Validation 00:09:00 Input Numeric Validation 00:12:00 Login Form Validation 00:05:00 Password Strength Check Validation 00:04:00 Summary 00:01:00

Learn React by building a Trello-inspired application with a real-time database and authentication!

Agile for Non-IT Practitioners - How Agile Project Management is Different and How It Can be Used for Non-IT Projects (On-Demand) As a Project Management Institute (PMI)®Registered Education Provider (R.E.P.), IIL has agreed to abide by PMI®-established quality assurance criteria. In today's world of fast paced technology, continually changing requirements and project scope, the need for Agile Project Management has greatly increased. Responding to this demand, the Project Management Institute (PMI®) launched the PMI Agile Certified Practitioner (PMI-ACP)®certification. A result of this certification is the creation of a new space where Project Management and Agile Practices for Software Development meet. The foundation of Agile is the Agile Manifesto for Software Development. Agile has been used for software development for a number of years, even prior to the creation of the Agile Manifesto in 2001. The success of Agile for software development projects has piqued interest in successfully employing Agile in many other fields. How can Agile practices be used for projects which are not software or IT in nature? This course will provide guidance on how Agile can be used beyond software development projects, including how it differs from traditional project management. The course also will provide an overview of the Agile Scrum framework, which is one of the most popular Agile methodologies used. This course provides practical skills, concepts, and principles you can take back to the job and use to implement Agile practices in projects, as applicable. The goal of this course is to acquaint participants with the concepts of agile development methods and the specifics of the Scrum management framework. At the end of this course, participants will understand: Agile Practices - what makes Agile projects 'agile' Scrum and how Scrum applies to the Agile Practices Specific Agile practices which you can use to improve the execution of your projects Practices which can be used in conjunction with Scrum for Non-IT projects Course goal and objectives Importance of Agile development and project management What Agile is and is not Faster, better, cheaper Delivers better fit for purpose Agile versus Waterfall and the big paradigm shift Agile characteristics, behaviors, approaches Agile concerns and pitfalls Introducing Agile Overview of Agile Agile values and principles Overview of Scrum Scrum methodology Scrum terminology Scrum Framework Scrum roles Scrum meetings Sprints Requirements and Product Definition User stories Product backlog Planning Agile Estimating in Scrum Sprint planning session Release planning Agile Practices Agile development Analysis practices Validation practices Other practices Running a Sprint Conducting a Sprint Negotiating changes Tracking progress End of Spring meetings Release planning Closing the project

Description: Microsoft Office Access 2016 is an application created for your data organization and management needs. From designing a relational database to organizing a database for efficiency, you will only learn if you know how to do it using Access 2016. All of these are some of the key topics in Access 2016 that this Microsoft Office 2016 Access Intermediate - Complete Video Course will provide to ensure you will use the application efficiently. Microsoft Access 2016 was created to help you with your database with the added feature in sharing and reporting; it has been widely recognized as more efficient than other applications available in the market. Learn how to hasten your skills in data organization using this application through this course now. Assessment: At the end of the course, you will be required to sit for an online MCQ test. Your test will be assessed automatically and immediately. You will instantly know whether you have been successful or not. Before sitting for your final exam you will have the opportunity to test your proficiency with a mock exam. Certification: After completing and passing the course successfully, you will be able to obtain an Accredited Certificate of Achievement. Certificates can be obtained either in hard copy at a cost of £39 or in PDF format at a cost of £24. Who is this Course for? Microsoft Office 2016 Access Intermediate - Complete Video Course is certified by CPD Qualifications Standards and CiQ. This makes it perfect for anyone trying to learn potential professional skills. As there is no experience and qualification required for this course, it is available for all students from any academic background. Requirements Our Microsoft Office 2016 Access Intermediate - Complete Video Course is fully compatible with any kind of device. Whether you are using Windows computer, Mac, smartphones or tablets, you will get the same experience while learning. Besides that, you will be able to access the course with any kind of internet connection from anywhere at any time without any kind of limitation. Career Path After completing this course you will be able to build up accurate knowledge and skills with proper confidence to enrich yourself and brighten up your career in the relevant job market. Module 01 Relational Database Design FREE 00:16:00 Create a Table 00:09:00 Create Table Relationships 00:09:00 Module 02 Create Query Joins 00:14:00 Relate Data Within a Table.avi 00:04:00 Work with Subdatasheets from 00:05:00 Module 03 Use Field Validation 00:16:00 Use Form and Record Validation 00:14:00 Module 04 Create Parameter Queries 00:12:00 Summarize Data 00:06:00 Create Subqueries 00:07:00 Create Action Queries 00:05:00 Create Unmatched and Duplicate Queries 00:06:00 Module 05 Data Normalization 00:10:00 Create a Junction Table 00:04:00 Improve Table Structure 00:06:00 Module 06 Include Control Formatting in a Report 00:04:00 Add a Calculated Field to a Report 00:05:00 Add a Subreport to an Existing Report 00:07:00 Mock Exam Mock Exam- Microsoft Office 2016 Access Intermediate - Complete Video Course 00:20:00 Final Exam Final Exam- Microsoft Office 2016 Access Intermediate - Complete Video Course 00:20:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Quality Guarantee: Promising training excellence, satisfaction gurantee Accredited by CPD UK & Quality License Scheme Tutor Support Unlimited support via email, till you complete the course Recognised Certification: Accepted by thousands of professional bodies Start Anytime With 1 year access to the course materials Online Learning Learn from anywhere, whenever you want Excel is an essential tool for data management and analysis and in this course, you will master everything from the fundamentals to advanced functionalities. You will learn to navigate the interface, create and format spreadsheets and perform calculations with ease and you will unlock the true potential of Excel for business and personal use. This course at a glance Accredited by CPD UK Endorsed by Quality Licence Scheme Understand the basics of Excel Know how to use Excel at an intermediate level Be aware of sum and numerical functions Understand how to manipulate text Know about logical functions Create effective spreadsheets Be confident with lookup functionality and date and time functions Easily use financial functions and sort and filter Progress to using Microsoft Excel at an advanced level Know how to create accurate and clear visual presentations Consolidate and validate data Use pivot table and what-if analysis Understand automation and macros Why Microsoft Excel Training Course right for you? Develop advanced skills in Microsoft Excel training course basic to advanced course, with this course. Learn from scratch or build on prior knowledge, to gain a good understanding of Excel functions. You will learn to accelerate your tasks efficiently using Excel techniques and formulae. The course covers how to create professional reports in no time, with Excel tools for data analysis and creating charts. This course will demystify the functions and tools in easy steps. It will teach you to work smart and save time. It is an excellent addition to your CV and is a valued skill in all businesses. Microsoft Excel Training Course Details Accredited by CPD certificates are accepted by thousands of professional bodies and government regulators here in the UK and around the world. Many organisations look for employees with CPD requirements, which means, that by doing this course, you would be a potential candidate in your respective field.   The Quality Licence Scheme is a brand of the Skills and Education Group, a leading national awarding organisation for providing high-quality vocational qualifications across a wide range of industries. Course Curriculum Microsoft Excel: Basic Level Introduction to Microsoft Excel 0101 Touring the Interface 0102 Enter Data & Saving Workbook 0103 Applying Formulas 0104 Changing a Worksheet's Structure 0105 Find, Replace & Spell Check 0106 Applying Fonts, Background Colors, and Borders 0107 Formatting Numbers and Dates 0108 Making the Fieces fit 0109 Inserting Headers & Footers and Repeating Rows 0110 Managing Large Workbooks Microsoft Excel: Intermediate Level Excel Essentials 0201 Formula Writing (Don't Miss This) Ex 0201 Formula Writing (Don't Miss this) Sum Count Average Functionality - With Conditions 0301 SumIf & SumIfs Ex 0301 SumIf & SumIfs 0302 Count Functions Ex 0302 Count Functions 0303 AverageIf & AverageIfs Ex 0303 AverageIf & AverageIfs Text Functions - Manipulating Text 0401 Change Case (Upper, Lower,Proper) Ex 0401 Change Case (Upper, Lower, Proper) 0402 Separating Text on Symmetrical Data Ex 0402 Separating Text on Symmetrical Data 0403 Separating Text on Non-Symmetrical Data Ex 0403 Separating Text on Non-Symmetrical Data Logical Functions - Working With Conditions 0501 If Functionality Ex 0501 IF Functionality 0502 If with AND Ex 0502 If with AND 0503 If with OR Ex 0503 If with OR 0504 If with 'AND' & 'OR' / IF with Countif Ex 0504 If with 'AND' & 'OR' / IF with Countif 0505 Nested IF (A Genie with 3 wishes) Ex 0505 Nested IF (A Genie with 3 wishes) Lookup Functionality - Burn Simple Find Technique 0601 Vlookup (Exact Match) # 1 Ex 0601 Vlookup (Exact Match) # 1 0602 Type of References (Use of $ sign) 0603 Vlookup (Exact Match) # 2 Ex 0603 Vlookup (Exact Match) # 2 0604 Double Vlookup Ex 0604 Double Vlookup 0605 Vlookup on Duplicate Values Ex 0605 Vlookup on Duplicate Values 0606 Vlookup (Approximate Match) Ex 0606 Vlookup (Approximate Match) 0607 Vlookup with If (Conditional Vlookup) Ex 0607 Vlookup with If (Conditional Vlookup) 0608 Hlookup (Exact Match) Ex 0608 Hlookup (Exact Match) 0609 Hlookup (Approximate Match) Ex 0609 Hlookup (Approximate Match) 0610 Lookup (Don't use this !) Ex 0610 Lookup (Don't use this !) 0611 Vlookup with Match (Create Magical Vlookup) Ex 0611 Vlookup with Match (Create Magical Vlookup) 0612 Match (Gives us Column/Row Index #) Ex 0612 Match (Gives us Column/Row Index #) 0613 Index & Match (Made for Each Other) Ex 0613 (1) Index & Match (Made for Each Other) Ex 0613 (2) Index & Match (Made for Each Other) Date & Time Function - A Tricky Game 0701 How Excel Records Date & Time 0702 Now, Today & Autofill 0703 DateValue & TimeValue 0704 Calculate WorkingDays 0705 DatedIf Financial Functions 0801 Loan Calculation (PMT, PPMT, IPMT etc.) Ex 0801 Loan Calculation (PMT, PPMT, IPMT etc.) 0802 Creating a Loan Table Ex 0802 Creating a Loan Table 0803 Calculate Depriciation Ex 0803 Calculate Depriciation Sort & Filter 0901 Basic Sorting & Shortcut keys Ex 0901 Basic Sorting & Shortcut keys 0902 Sorting Using Custom List Ex 0902 Sorting Using Custom List 0903 Horizontal Sorting Ex 0903 Horizontal Sorting 0904 Basic Filter & Shortcut Keys Ex 0904 Basic Filter & Shortcut Keys 0905 Filter Problem # 1 (Copy Filtered Data without hidden rows) Ex 0905 Filter Problem # 1 (Copy Filtered Data without hidden rows) 0906 Filter Problem # 2 (Pasting Values on Filtered Data) Ex 0906 Filter Problem # 2 (Pasting Values on Filtered Data) 0907 Filter Problem # 3 (Performing Calculation on Filtered Data) Ex 0907 Filter Problem # 3 (Performing Calculation on Filtered Data) 0908 Advanced Filter (Applying Complex Criteria's) Ex 0908 Advanced Filter (Applying Complex Criteria's) Microsoft Excel: Advanced Level Excel Charts - Visual Presentation 1001 How to create a chart 1002 Format Axis 1003 Plot Values on Secondary Axis 1004 Life of Pie (Charts) 1005 How to Show Axis Title 1006 How to Show Data Label 1007 Show data with chart in Data Table 1008 Column Chart 1009 Bar Chart 1010 Line Chart 1 1011 Line Chart 2 1012 Area Chart 1013 Pie Chart 1014 Pie of Pie or Bar of Pie 1015 Line Chart with Log Scale 1016 Bubble Chart 1017 Selecting Chart Elements 1018 Use of Format Dialog box 1019 Modifying Chart & Plot Area 1020 Modifying Data Series 1021 How to handle Missing Data 1022 Modifying 3-D Charts 1023 Creating Combination of upto 5 Different Charts 1025 Creating Picture Charts Data Consolidation - Multiple WorkBooks WorkSheets Consolidate Data using Excel Inbuilt Function Ex Consolidate Data using Excel Inbuilt Function Data Validation 1201 Applying Data Validation Ex 1201 Applying Data Validation 1202 Dependent Dropdown List Ex1202 Dependent Dropdown List Using Data Validation with Vlookup & Match Other Data Validation Examples Protection of Worksheet Workbook 1301 Worksheet Level Protection Ex 1301 Worksheet Level Protection 1302 Cell Level Protection Ex 1302 Cell Level Protection 1303 Hiding Formulas from Formula Bar Ex 1303 Hiding Formulas from Formula Bar 1304 Protecting Workbook Structure Ex 1304 Protecting Workbook Structure 1305 Workbook Level Protection Ex 1305 Workbook Level Protection Pivot Table & Techniques 1401 Understanding pivot Table 1402 Using Pivot Table in Real Scenario Ex 1402 Using Pivot Table in Real Scenario 1403 Grouping in Pivot Table Ex 1403 Grouping in Pivot Table 1404 Using Slicers (A Visually attractive Filter) Ex 1404 Using Slicers (A Visually attractive Filter) What-If Analysis & Solver Add-In 1501 Goal Seek (A Reverse Approach) Ex 1501 Goal Seek (A Reverse Approach) 1502 One Way Data Table 1503 Two Way Data Table 1504 Scenario Manager 1505 Solver Add-In Automation in Excel - Macros 1601 Record your first Macro 1602 Record Another Macro 1603 Assigning macro to a Shape, Button, Picture etc 1604 Editing or Deleting a Macro 1605 Security Settings of a Macro Who should take this course? Absolute beginners to Microsoft Excel People who wish to use Microsoft Excel more confidently People who wish to refresh their existing skills in Microsoft Excel Entry Requirements There are no academic entry requirements for this Microsoft Excel training course basic to advanced course, and it is open to students of all academic backgrounds. However, you are required to have a laptop/desktop/tablet or smartphone and a good internet connection. Assessment Method This Microsoft Excel training course basic to advanced course assesses learners through multiple-choice questions (MCQs). Upon successful completion of the modules, learners must answer MCQs to complete the assessment procedure. Through the MCQs, it is measured how much a learner can grasp from each section. In the assessment pass mark is 60%. Certification Endorsed Certificate from Quality Licence Scheme After successfully passing the MCQ exam you will be eligible to order the Endorsed Certificate by Quality Licence Scheme. The Quality Licence Scheme is a brand of the Skills and Education Group, a leading national awarding organisation for providing high-quality vocational qualifications across a wide range of industries. It will give you a competitive advantage in your career, making you stand out from all other applicants and employees. There is a Quality Licence Scheme endorsement fee to obtain an endorsed certificate which is £65. Certificate of Achievement from Lead Academy After successfully passing the MCQ exam you will be eligible to order your certificate of achievement as proof of your new skill. The certificate of achievement is an official credential that confirms that you successfully finished a course with Lead Academy. Certificate can be obtained in PDF version at a cost of £12, and there is an additional fee to obtain a printed copy certificate which is £35. FAQs Is CPD a recognised qualification in the UK? CPD is globally recognised by employers, professional organisations and academic intuitions, thus a certificate from CPD Certification Service creates value towards your professional goal and achievement. CPD-certified certificates are accepted by thousands of professional bodies and government regulators here in the UK and around the world. Are QLS courses recognised? Although QLS courses are not subject to Ofqual regulation, they must adhere to an extremely high level that is set and regulated independently across the globe. A course that has been approved by the Quality Licence Scheme simply indicates that it has been examined and evaluated in terms of quality and fulfils the predetermined quality standards. When will I receive my certificate? For CPD accredited PDF certificate it will take 24 hours, however for the hardcopy CPD certificate takes 5-7 business days and for the Quality License Scheme certificate it will take 7-9 business days. Can I pay by invoice? Yes, you can pay via Invoice or Purchase Order, please contact us at info@lead-academy.org for invoice payment. Can I pay via instalment? Yes, you can pay via instalments at checkout. How to take online classes from home? Our platform provides easy and comfortable access for all learners; all you need is a stable internet connection and a device such as a laptop, desktop PC, tablet, or mobile phone. The learning site is accessible 24/7, allowing you to take the course at your own pace while relaxing in the privacy of your home or workplace. Does age matter in online learning? No, there is no age limit for online learning. Online learning is accessible to people of all ages and requires no age-specific criteria to pursue a course of interest. As opposed to degrees pursued at university, online courses are designed to break the barriers of age limitation that aim to limit the learner's ability to learn new things, diversify their skills, and expand their horizons. When I will get the login details for my course? After successfully purchasing the course, you will receive an email within 24 hours with the login details of your course. Kindly check your inbox, junk or spam folder, or you can contact our client success team via info@lead-academy.org