Description: Microsoft Excel, developed by Microsoft Corporation, is world's leading spreadsheet program for Windows, macOS, Android and iOS. The program includes calculation, graphing tools, pivot tables, and a macro programming language called Visual Basic for Applications to make your task easy and for saving your precious time. You can hardly find any company where Microsoft Excel is not used. The knowledge of Excel is a must for meeting any career perspective. The course will help you to achieve the goals. The course is divided into three parts - beginners, intermediate and advanced. Therefore after completing the bundle video course, you will be a prolific user of the program. As the course is sectioned based on the level of difficulty, you will know the basics of Excel at first. You will know how to open an excel program, how to put data or know some simple calculations. After the primary knowledge, you will be introduced to some more features and functions of the program such as analyse massive amounts of data, extract actionable information from it, etc. Finally, you will learn the advanced features of Excel program that allows you take the right business decisions for your company. 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 Excel Complete Video Course - Beginner, Intermediate & Advanced 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 Excel Complete Video Course - Beginner, Intermediate & Advanced 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. Getting Started with Microsoft Office Excel 2016 Navigate the Excel User Interface FREE 00:28:00 Use Excel Commands 00:10:00 Create and Save a Basic Workbook 00:19:00 Enter Cell Data 00:12:00 Use Excel Help 00:05:00 Performing Calculations Create Worksheet Formulas 00:15:00 Insert Functions 00:17:00 Reuse Formulas and Functions 00:17:00 Modifying a Worksheet Insert, Delete, and Adjust Cells, Columns, and Rows 00:10:00 Search for and Replace Data 00:09:00 Use Proofing and Research Tools 00:07:00 Formatting a Worksheet Apply Text Formats 00:17:00 Apply Number Format 00:08:00 Align Cell Contents 00:09:00 Apply Styles and Themes 00:12:00 Apply Basic Conditional Formatting 00:11:00 Create and Use Templates 00:07:00 Printing Workbooks Preview and Print a Workbook 00:10:00 Set Up the Page Layout 00:08:00 Configure Headers and Footers 00:07:00 Managing Workbooks Manage Worksheets 00:05:00 Manage Workbook and Worksheet Views 00:07:00 Manage Workbook Properties 00:05:00 Working with Functions Work with Ranges FREE 00:18:00 Use Specialized Functions 00:11:00 Work with Logical Functions 00:23:00 Work with Date & Time Functions 00:08:00 Work with Text Functions 00:11:00 Working with Lists Sort Data 00:10:00 Filter Data 00:10:00 Query Data with Database Functions 00:09:00 Outline and Subtotal Data 00:09:00 Analyzing Data Create and Modify Tables 00:15:00 Apply Intermediate Conditional Formatting 00:07:00 Apply Advanced Conditional Formatting 00:05:00 Visualizing Data with Charts Create Charts 00:13:00 Modify and Format Charts 00:12:00 Use Advanced Chart Features 00:12:00 Using PivotTables and PivotCharts Create a PivotTable 00:13:00 Analyze PivotTable Data 00:12:00 Present Data with PivotCharts 00:07:00 Filter Data by Using Timelines and Slicers 00:11:00 Working with Multiple Worksheets and Workbooks Use Links and External References FREE 00:12:00 Use 3-D References 00:06:00 Consolidate Data 00:05:00 Using Lookup Functions and Formula Auditing Use Lookup Functions 00:12:00 Trace Cells 00:09:00 Watch and Evaluate Formulas 00:08:00 Sharing and Protecting Workbooks Collaborate on a Workbook 00:19:00 Protect Worksheets and Workbooks 00:08:00 Automating Workbook Functionality Apply Data Validation 00:13:00 Search for Invalid Data and Formulas with Errors 00:04:00 Work with Macros 00:18:00 Creating Sparklines and Mapping Data Create Sparklines 00:07:00 MapData 00:07:00 Forecasting Data Determine Potential Outcomes Using Data Tables 00:08:00 Determine Potential Outcomes Using Scenarios 00:09:00 Use the Goal Seek Feature 00:04:00 Forecasting Data Trends 00:05:00 Refer A Friend Refer A Friend 00:00:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00
There's nothing like riding a motorbike in top condition. The silent wheels. The seamless gear shifts. The smooth-running chain. But it takes a little love and maintenance to keep your ride in peak condition. To make this course more accessible for you, we have designed it for both part-time and full-time students. This course is packed into bite-size modules for your convenience. You can study at your own pace. This Motorbike Maintenance Course will give you the skills you need to get you and your motorbike out of trouble - and know when to call in the professionals! You will receive the confidence to tackle basic roadside repairs and check your bike to make sure it's safe before you ride. The course covers- motorbike component guide, how to do a pre-ride safety check, how to change an inner tube (in double-quick time), cleaning and re-lubing your drivetrain to prevent wear and to enjoy a smoother ride, brake adjustment, gear adjustment, Q&A with the trainer. This course is ideal for people who want to know how to perform basic motorbike care and some simple repairs. This Motorbike Maintenance Course is suitable for anyone aspiring to begin or already working in this field or simply want to learn in-depth about motorbike maintenance. You can add this qualification to your CV by downloading your certificate instantly without any cost after completing the course. Who is this course for? Motorbike Maintenance Course is suitable for anyone who want to gain extensive knowledge, potential experience and professional skills in the related field. This course is CPD accredited so you don't have to worry about the quality. Requirements Our Motorbike Maintenance Course is open to all from all academic backgrounds and there is no specific requirements to attend this course. It is compatible and accessible from any device including Windows, Mac, Android, iOS, Tablets etc. CPD Certificate from Course Gate At the successful completion of the course, you can obtain your CPD certificate from us. You can order the PDF certificate for £4.99 and the hard copy for £9.99. Also, you can order both PDF and hardcopy certificates for £12.99. Career path This course opens a new door for you to enter the relevant job market and also gives you the opportunity to acquire extensive knowledge along with required skills to become successful. You will be able to add our qualification to your CV/resume which will help you to stand out in the competitive job industry. Course Curriculum Motorbike Maintenance Course Module - 01: Introduction to Motorbike Maintenance 00:09:00 Module - 02: Basics of Engine 00:09:00 Module - 03: Engine Cooling and Lubrication 00:14:00 Module - 04: Ignition 00:09:00 Module - 05: Suspension 00:09:00 Module - 06: Intake, Fuel, Clutch and Exhaust Systems 00:18:00 Module - 07: Electrical Maintenance 00:16:00 Module - 08 Wheels, Tires and Brakes Maintenance 00:00:00 Module - 09: Transmission, Frame and Steering 00:22:00 Module - 10: Cleaning, Setting Up and Storage 00:09:00 Module - 11: Troubleshooting 00:16:00 Mock Exam Mock Exam - Motorbike Maintenance Course 00:20:00 Final Exam Final Exam - Motorbike Maintenance Course 00:20:00 Certificate and Transcript Order Your Certificates or Transcripts 00:00:00
The course starts with requirements gathering and ends with implementation, which are the two main elements of software development. Through this course, you will learn to use UML diagrams to analyze and design classes and to highlight relationships between the classes. You will also learn to implement and program the design in C++, C#, and Java.
The Medication Administration Training course are designed to help you understand the skills and knowledge required for working in the healthcare settings. Learn to take care of drugs correctly and understanding how the right way of administering them can reduce both major and minor risks. We understand the value of medication knowledge as it's essential for those working in the health and social care sector. The focus of this course to equip you with all the information required for the safe control, handling and administration of medicines in health and care settings. This course covers the function of the medication administration, including how to prescribe, manage and supervise medicines safely. This course also explains the crucial legislation and direction correlating to the classification of medications, grasp Govt. policies and procedures for ensuring the safe handling of drugs, dispensing, receiving and verifying the validation of medicines, the significance of keeping accurate recording and much more. On successful completion of the course, you will be able to expertly administer a range of medicines such as morphine, sedatives, laxatives and antibiotics, etc. Who is this course for? Medication Administration Training is suitable for anyone who want to gain extensive knowledge, potential experience and professional skills in the related field. This course is CPD accredited so you don't have to worry about the quality. Requirements Our Medication Administration Training is open to all from all academic backgrounds and there is no specific requirements to attend this course. It is compatible and accessible from any device including Windows, Mac, Android, iOS, Tablets etc. CPD Certificate from Course Gate At the successful completion of the course, you can obtain your CPD certificate from us. You can order the PDF certificate for £9 and the hard copy for £15. Also, you can order both PDF and hardcopy certificates for £22. Career path This course opens a new door for you to enter the relevant job market and also gives you the opportunity to acquire extensive knowledge along with required skills to become successful. You will be able to add our qualification to your CV/resume which will help you to stand out in the competitive job industry. Course Curriculum Medication Administration Training Introduction to Safe Handling of Medicines 00:30:00 Legislation and guidance of medication management 00:30:00 Principles of Safe and Appropriate Handling of Medicines 00:45:00 Medication Risk Assessment Guidance 00:30:00 Consent to Treatment 00:30:00 Handling Medicines in Social Care Settings 01:00:00 Requirements for Specific Services 00:45:00 Levels of Care and Support 00:15:00 Procedure for Handling Medication 00:30:00 The Six Rights of Medication Administration 00:30:00 Covert Administration of Medication 00:30:00 Recording Procedures 00:15:00 Storage of Medication 00:15:00 Transfer and Disposal of Medication 00:30:00 Drug Formulation and Ways of Taking It 01:00:00 Mock Exam Mock Exam - Medication Administration Training 00:20:00 Final Exam Final Exam - Medication Administration Training 00:20:00 Certificate and Transcript Order Your Certificates or Transcripts 00:00:00
Master the strategies of handing medicine efficiently and safely with the Safe Handling of Medication course. Medicine should be handled carefully as human lives depend on it. Medicine is prepared to make you well, but if you do not use it properly, you may sick and even it may cause death. The purpose of the course is to aware you how to handle medicine safely. The course presents a general overview of the legislation and guidelines regarding the management of medication management settings. The principal legal aspects of handling medicines will be covered in the course. Therefore, you will gain all the essential skills for Health's UK Core Skills Training Framework (CSTF), the Care Quality Commission (CQC) recommendations for health care and social care providers. The course guides you to know the procedures for ordering, receiving, administering, storing and disposing of medicines safely. You will explore the steps of obtaining and receiving supplies. You will also learn how drugs are administered and how problems may occur. Upon completion, you will be able to know the techniques for storing and disposing of the drugs safely and securely. Who is this course for? Safe Handling of Medication is suitable for anyone who want to gain extensive knowledge, potential experience and professional skills in the related field. This course is CPD accredited so you don't have to worry about the quality. Requirements Our Safe Handling of Medication is open to all from all academic backgrounds and there is no specific requirements to attend this course. It is compatible and accessible from any device including Windows, Mac, Android, iOS, Tablets etc. CPD Certificate from Course Gate At the successful completion of the course, you can obtain your CPD certificate from us. You can order the PDF certificate for £9 and the hard copy for £15. Also, you can order both PDF and hardcopy certificates for £22. Career path This course opens a new door for you to enter the relevant job market and also gives you the opportunity to acquire extensive knowledge along with required skills to become successful. You will be able to add our qualification to your CV/resume which will help you to stand out in the competitive job industry. Course Curriculum Diploma in Safe Handling of Medication Introduction to Safe Handling of Medicines 00:30:00 Legislation and guidance of medication management 00:30:00 Principles of Safe and Appropriate Handling of Medicines 00:45:00 Medication Risk Assessment Guidance 00:30:00 Consent to Treatment 00:30:00 Handling Medicines in Social Care Settings 01:00:00 Requirements for Specific Services 00:45:00 Levels of Care and Support 00:15:00 Procedure for Handling Medication 00:30:00 The Six Rights of Medication Administration 00:30:00 Covert Administration of Medication 00:30:00 Recording Procedures 00:15:00 Storage of Medication 00:15:00 Transfer and Disposal of Medication 00:30:00 Drug Formulation and Ways of Taking It 01:00:00 Mock Exam Mock Exam - Safe Handling of Medication 00:20:00 Final Exam Final Exam - Safe Handling of Medication 00:20:00 Certificate and Transcript Order Your Certificates or Transcripts 00:00:00
The Simplest Guide⢠to Advanced SAS Programming | Macros | SQL is an accelerated path to learning advanced SAS programming taught in a simple, visual, and immersive style. If you already know SAS, this course will equip you with skills to reveal amazing insights within your data, while helping you prepare for advanced SAS certification exams.
Overview Uplift Your Career & Skill Up to Your Dream Job - Learning Simplified From Home! Kickstart your career & boost your employability by helping you discover your skills, talents and interests with our special IT for Recruiters Course. You'll create a pathway to your ideal job as this course is designed to uplift your career in the relevant industry. It provides professional training that employers are looking for in today's workplaces. The IT for Recruiters Course is one of the most prestigious training offered at StudyHub and is highly valued by employers for good reason. This IT for Recruiters Course has been designed by industry experts to provide our learners with the best learning experience possible to increase their understanding of their chosen field. This IT for Recruiters Course, like every one of Study Hub's courses, is meticulously developed and well researched. Every one of the topics is divided into elementary modules, allowing our students to grasp each lesson quickly. At StudyHub, we don't just offer courses; we also provide a valuable teaching process. When you buy a course from StudyHub, you get unlimited Lifetime access with 24/7 dedicated tutor support. Why buy this IT for Recruiters? Unlimited access to the course for forever Digital Certificate, Transcript, student ID all included in the price Absolutely no hidden fees Directly receive CPD accredited qualifications after course completion Receive one to one assistance on every weekday from professionals Immediately receive the PDF certificate after passing Receive the original copies of your certificate and transcript on the next working day Easily learn the skills and knowledge from the comfort of your home Certification After studying the course materials of the IT for Recruiters there will be a written assignment test which you can take either during or at the end of the course. After successfully passing the test you will be able to claim the pdf certificate for £5.99. Original Hard Copy certificates need to be ordered at an additional cost of £9.60. Who is this course for? This IT for Recruiters course is ideal for Students Recent graduates Job Seekers Anyone interested in this topic People already working in the relevant fields and want to polish their knowledge and skill. Prerequisites This IT for Recruiters does not require you to have any prior qualifications or experience. You can just enrol and start learning.This IT for Recruiters was made by professionals and it is compatible with all PC's, Mac's, tablets and smartphones. You will be able to access the course from anywhere at any time as long as you have a good enough internet connection. Career path As this course comes with multiple courses included as bonus, you will be able to pursue multiple occupations. This IT for Recruiters is a great way for you to gain multiple skills from the comfort of your home. Course Curriculum Introduction Introduction 00:02:00 IT Fundamentals What is hardware and software 00:04:00 Server 00:08:00 Project Life cycle 00:06:00 Software Development Life Cycle 00:08:00 IT Terms Basics Methodologies 00:09:00 CMS 00:04:00 API 00:04:00 CI/CD 00:04:00 Stacks 00:03:00 Native and Hybrid Native Apps 00:02:00 IT Positions CTO 00:13:00 IT Architect 00:08:00 Product Owner 00:12:00 Project Manager 00:13:00 Product Manager 00:06:00 PO vs PM vs Product Manager 00:07:00 PO vs Product Manager 00:04:00 Business Analyst 00:09:00 Business Intelligence Specialist 00:06:00 Data Engineer 00:05:00 Data Scientist 00:07:00 Data Engineer vs Data Scientist 00:07:00 Agile Coach 00:14:00 Scrum Master 00:08:00 Agile Coach vs Scrum Master 00:01:00 Frontend Developer 00:06:00 Backend Developer 00:06:00 Fullstack Developer 00:04:00 Frontend vs Backend vs Fullstack Developer 00:02:00 iOS Developer 00:03:00 Android Developer 00:04:00 UX Designer 00:09:00 UI Designer 00:08:00 UX vs UI Designer 00:04:00 QA Engineer_Tester 00:09:00 SysAdmin 00:07:00 DevOps 00:05:00 SEO 00:10:00 IT Technologies. Programming Languages and Frameworks Programming languages and frameworks. Intro 00:01:00 Programming languages and frameworks 00:08:00 Java 00:03:00 JavaScript 00:02:00 Python 00:01:00 C 00:02:00 C++ 00:03:00 C# 00:02:00 HTML 00:02:00 PHP 00:02:00 SWIFT 00:02:00 Objective-C 00:01:00 Ruby 00:02:00 SQL 00:02:00 Go (Golang) 00:01:00 Databases Database 00:05:00 Types of Databases 00:07:00 From Recruiter to Recruiter The day of an IT Recruiter 00:05:00 Key principles 00:03:00 Sourcing Tipps 00:03:00 Good Bye Video Good Bye Video 00:01:00
In this comprehensive course, you will learn everything you need to know about SQL and Microsoft SQL Server, from the basic to advanced topics. With easy-to-follow lessons and hands-on exercises, you will gain the skills and confidence to work with databases like a pro. Perfect for beginners and anyone looking to expand their data management skills.
Since 1999, the Diploma in Port Management has been recognised as a leading qualification for port managers, governments, terminal operators, and port companies. Human proficiency is the most crucial factor in the effective operation of port and transport services. A successful and well-run port contributes to the economy; therefore port personnel must be apprised and updated with all the relevant innovations available. The Port Management Diploma is ideal for port management professionals needing to build on their knowledge in order to meet their day-to-day challenges more effectively. It is designed to give you the skills to develop professionally in port administration, port and harbour management and port operations for the global maritime supply chain. This course will provide opportunities for you to thoroughly understand the role of port especially in the international trade and logistic chain as the 'economic engine' of development. Who is this course for? Port Management Diploma is suitable for anyone who want to gain extensive knowledge, potential experience and professional skills in the related field. This course is CPD accredited so you don't have to worry about the quality. Requirements Our Port Management Diploma is open to all from all academic backgrounds and there is no specific requirements to attend this course. It is compatible and accessible from any device including Windows, Mac, Android, iOS, Tablets etc. CPD Certificate from Course Gate At the successful completion of the course, you can obtain your CPD certificate from us. You can order the PDF certificate for £9 and the hard copy for £15. Also, you can order both PDF and hardcopy certificates for £22. Career path This course opens a new door for you to enter the relevant job market and also gives you the opportunity to acquire extensive knowledge along with required skills to become successful. You will be able to add our qualification to your CV/resume which will help you to stand out in the competitive job industry. Featured Reviews Dave WRead More I've just completed the Port Management Diploma. I recommend this course to all management persons currently in a port role, or thinking of joining the world of Ports. The course is presented well, and easy to follow on line. The pre quiz helps you to prepare for the final assessment. Alessandra Antonella NapoliRead More This Port Management Course is well organised. The learning materials provided it is very consistent and well explained. You earn a lot of knowledge about operations and management. I loved it. Course Curriculum Port Management Module 01: Introduction to Port 00:28:00 Module 02: Legal Aspects of Port 00:20:00 Module 03: Introduction to Port Management 00:26:00 Module 04: Port Management: Planning & Performance 00:27:00 Module 05: Port Management: Safety & Security 00:18:00 Module 06: Environmental Risks & Protection 00:29:00 Module 07: Port Equipment 00:24:00 Module 08: Growth & Development of Port 00:23:00 Module 09: Cargoes and Ships 00:22:00 Module 10: Impact of Changing Ship Technology on Ports 00:23:00 Mock Exam Mock Exam - Port Management Diploma 00:20:00 Final Exam Final Exam - Port Management Diploma 00:20:00 Certificate and Transcript Order Your Certificates or Transcripts 00:00:00