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

43146 Courses in Birmingham delivered Online

SQL Querying Fundamentals - Part 1

By Nexus Human

Duration 1 Days 6 CPD hours This course is intended for Individuals with basic computer skills, familiar with concepts related to database structure and terminology, and who want to use SQL to query databases. Overview Upon successful completion of this course, students will be able to: - connect to the SQL Server database and execute a simple query. - include a search condition in a simple query. - use various functions to perform calculations on data. - organize data obtained from a query before it is displayed on-screen. - retrieve data from tables. - format an output, save a result, and generate a report. In this course, students will compose SQL queries to retrieve desired information from a database. 1 - Executing a Simple Query Connect to the SQL Database Query a Database Save a Query Modify a Query Execute a Saved Query 2 - Performing a Conditional Search Search Using a Simple Condition Compare Column Values Search Using Multiple Conditions Search for a Range of Values and Null Values Retrieve Data Based on Patterns 3 - Working with Functions Perform Date Calculations Calculate Data Using Aggregate Functions Manipulate String Values 4 - Organizing Data Sort Data Rank Data Group Data Filter Grouped Data Summarize Grouped Data Use PIVOT and UNPIVOT Operators 5 - Retrieving Data from Tables Combine Results of Two Queries Compare the Results of Two Queries Retrieve Data by Joining Tables Check for Unmatched Records Retrieve Information from a Single Table Using Joins 6 - Presenting Query Results Save the Query Result Generate an XML Report

SQL Querying Fundamentals - Part 1
Delivered OnlineFlexible Dates
£495

MS Excel: 50 Tips to Upgrade your Excel Skills

5.0(1)

By Course Gate

Enhance your Excel skills with our comprehensive course covering 50 essential tips and techniques. Perfect for beginners and professionals alike, this course offers CPD accreditation and practical insights to boost your career prospects.

MS Excel: 50 Tips to Upgrade your Excel Skills
Delivered Online On Demand3 hours
£11.99

Level 2 NVQ Diploma in Construction Operations

By REX Training Services

Level 2 NVQ Diploma in construction operations

Level 2 NVQ Diploma in Construction Operations
Delivered Online On Demand
£900

Advanced Surveying & Construction Site Management (SMSTS) Diploma - CPD Certified

4.5(3)

By Studyhub UK

Do you want to prepare for your dream job but strive hard to find the right courses? Then, stop worrying, for our strategically modified Surveying & Construction Site Management bundle will keep you up to date with the relevant knowledge and most recent matters of this emerging field. So, invest your money and effort in our 37 course mega bundle that will exceed your expectations within your budget. The Surveying & Construction Site Management related fields are thriving across the UK, and recruiters are hiring the most knowledgeable and proficient candidates. It's a demanding field with magnitudes of lucrative choices. If you need more guidance to specialise in this area and need help knowing where to start, then StudyHub proposes a preparatory bundle. This comprehensive Surveying & Construction Site Management bundle will help you build a solid foundation to become a proficient worker in the sector. This Surveying & Construction Site Management Bundle consists of the following 30 CPD Accredited Premium courses - Course 1: Quantity Surveying Course 2: Surveying Basics Course 3: Building Surveying Course 4: Land Surveying and Cost Estimation Course 5: Residential Surveyor Course 6: Construction Industry Scheme (CIS) Course 7: Construction Management Level 3 Course 8: Construction Project Management Course 9: Site Management Safety Training Scheme Course 10: CDM Regulations Course 11: Environmental Health Course 12: Abrasive Wheels Course 13: Purchasing and Procurement Diploma Course 14: LOLER Regulations and LOLER Inspection Training Course 15: Manual Handling Interactive Training Course 16: Fire Safety Course 17: Noise and Hearing Protection Course 18: PUWER Course 19: Supervisor Training Course 20: Logistic Maangement Course 21: Site Safety Plus Course 22: CSCS Health and Safety in a Construction Environment (Leading to CSCS Green Card) Course 23: Construction Risk Assessment Course 24: Operations and Supply Chain Management Course 25: Environmental Engineering Course 26: Advanced Electrical Safety Course 27: Emergency First Aid at Work (EFAW) Course 28: Asbestos Surveying Course 29: COSHH Awareness Course 30: Gas Safety 7 Extraordinary Career Oriented courses that will assist you in reimagining your thriving techniques- Course 1: Career Development Plan Fundamentals Course 2: CV Writing and Job Searching Course 3: Interview Skills: Ace the Interview Course 4: Video Job Interview for Job Seekers Course 5:Create a Professional LinkedIn Profile Course 6:Business English Perfection Course Course 7:Networking Skills for Personal Success Learning Outcome This tailor-made Surveying & Construction Site Management bundle will allow you to- Uncover your skills and aptitudes to break new ground in the related fields Deep dive into the fundamental knowledge Acquire some hard and soft skills in this area Gain some transferable skills to elevate your performance Maintain good report with your clients and staff Gain necessary office skills and be tech savvy utilising relevant software Keep records of your work and make a report Know the regulations around this area Reinforce your career with specific knowledge of this field Know your legal and ethical responsibility as a professional in the related field This Surveying & Construction Site Management Bundle resources were created with the help of industry experts, and all subject-related information is kept updated on a regular basis to avoid learners from falling behind on the latest developments. Certification After studying the complete training you will be able to take the assessment. After successfully passing the assessment you will be able to claim all courses pdf certificates and 1 hardcopy certificate for the Title Course completely free. Other Hard Copy certificates need to be ordered at an additional cost of •8. CPD 370 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Ambitious learners who want to strengthen their CV for their desired job should take advantage of the Surveying & Construction Site Management bundle! This bundle is also ideal for professionals looking for career advancement. Level 3 Diploma in Construction Site Supervisory Studies Requirements To participate in this course, all you need is - A smart device A secure internet connection And a keen interest in Surveying & Construction Site Management Career path Upon completing this essential Bundle, you will discover a new world of endless possibilities. These courses will help you to get a cut above the rest and allow you to be more efficient in the relevant fields.

Advanced Surveying & Construction Site Management (SMSTS) Diploma - CPD Certified
Delivered Online On Demand8 days
£305

Parenting Skills - CPD Accredited

4.9(27)

By Apex Learning

Boost Your Career with Apex Learning and Get Noticed By Recruiters in this Hiring Season! Get Hard Copy + PDF Certificates + Transcript + Student ID Card worth £160 as a Gift - Enrol Now Give a compliment to your career and take it to the next level. This Parenting Skills will provide you with the essential knowledge and skills required to shine in your professional career. Whether you want to develop skills for your next job or want to elevate skills for your next promotion, this Parenting Skills will help you keep ahead of the pack. The Parenting Skills incorporates basic to advanced level skills to shed some light on your way and boost your career. Hence, you can reinforce your professional skills and knowledge, reaching out to the level of expertise required for your position. Further, this Parenting Skills will add extra value to your resume to stand out to potential employers. Throughout the programme, it stresses how to improve your competency as a person in your profession while at the same time it outlines essential career insights in this job sector. Consequently, you'll strengthen your knowledge and skills; on the other hand, see a clearer picture of your career growth in future. By the end of the Parenting Skills, you can equip yourself with the essentials to keep you afloat into the competition. Along with this Parenting Skills course, you will get 10 other premium courses. Also, you will get an original Hardcopy and PDF certificate for the title course and a student ID card absolutely free. What other courses are included with this Parenting Skills? Course 1: Safeguarding Children Level 3 Course 2: Caring for Children and Young People Level 2 Course 3: Neuropsychology and Development of Children Course 4: Juices, Smoothies, Healthy Eating, Vegan, Nutrition with Certificate Course 5: Baby Massage Course 6: Understanding Autism Awareness and Diagnosis Level 2 Course 7: Play Therapy Course 8: Couples Therapy & Counselling Course 9: Anti Social Behaviour Course 10: Paediatric First Aid Level 3 So, enrol now to advance your career! Benefits you'll get choosing Apex Learning for this Parenting Skills: One payment, but lifetime access to 11 CPD courses Certificate, student ID for the title course included in a one-time fee Full tutor support available from Monday to Friday Free up your time - don't waste time and money travelling for classes Accessible, informative modules taught by expert instructors Get 24/7 help or advice from our email and live chat teams Learn at your ease - anytime, from anywhere Study the course from your computer, tablet or mobile device CPD accredited course - improve the chance of gaining professional skills How will I get my Certificate? After successfully completing the course you will be able to order your CPD Accredited Certificates (PDF + Hard Copy) as proof of your achievement. PDF Certificate: Free (Previously it was £6*11 = £66) Hard Copy Certificate: Free (For The Title Course: Previously it was £10) Curriculum of the Bundle Course 1: Parenting Skills Training Advanced Parenting Skills PROMO (Final) Goals & First Concepts The Power Of Relationships The Myth Of 'Nothing To It Parenting' The 2 Phases Of Parenting The Power Of Mentoring Your Child Teaching Values They Will Keep! Parenting Basics … And Beyond! Powerful Communication Skills The Power Of Re-Framing & Building Agreements WHY Do Kids Do The Things They Do? 'The Parent's Pledge' Disciplining The RIGHT Way! The Power of 'Life Lessons' The kid's Pledge The Parents Pledge Course 2: Safeguarding Children Level 3 Module 01: Laws and Guidance Module 02: Social and Emotional Development Module 03: Personality and Intellectual Development of Children Module 04: Child Abuse Module 05: Sexual Abuse Module 06: The Impact of Domestic Violence and Abuse on Children Module 07: Risks and Risk Assessment Module 08: Responding to Disclosure and Reporting Module 09: Things to Do after Referral Module 10: Safeguarding Trafficked Children Module 11: Infant Mental Health and Early Attachment Module 12: Assessing Need and Providing Early Help Course 3: Caring for Children and Young People Level 2 Understanding Child Development Care for Children Healthy Food, Healthy Living Keeping Children Healthy and Safe Child Protection Play, Imagination and Creativity Factors That Influence Development Cognitive Development Social and Emotional Development Personality and Intellectual Development in Children Language Development in Children Problems in Childhood & Adolescence Course 4: Neuropsychology and Development of Children The Theory of Psycho-social Development Serve & Return Practical Tips For Serve & Return Fuzzy Trace Theory - Explains and Predicts Adolescent Risk Taking Adolescent Risk Taking and the Prefrontal Cortex Operant Conditioning - How Reinforcement Works and How it can help you The Danger of Unearned Rewards (Habituation and Expectations) Influencing behavior through linguistic cuing Does violent media lead to aggressive kids? Culture and seeing world How childhood experience (ie violence) can result in choosing abusive partners A Highly Regimented Life is a Very Stressful Life Heritable vs. Inherited Hormones and Development Course 5: Juices, Smoothies, Healthy Eating, Vegan, Nutrition with Certificate Section 01: Green Smoothie Cleanse Section 02: Healthy Eating Section 03: Juicing for Vitality Section 04: Vegan Warrior Course 6: Baby Massage 01 - EAMFC - Baby Massage Marketing final 02 - EAMFC - Meridian Theory Introduction 2020 03 - EAMFC - Introduction to Pediatric Massage 2020 03 - 1 - EAMFC - TCM Paediatric Massage Protocol 2020 03 - 2 - EAMFC - Massage For Immunity Strengthening 2020 03 - 3 - EAMFC - Massage For Night Sweating 2020 03 - 4 - EAMFC - Massage For Stomach-ache 2020 03 - 5 - EAMFC - Massage For Constipation 2020 03 - 6 - EAMFC - Massage For Sinusitis 2020 03 - 7 - EAMFC - Massage for Imsomnia 2020 04 - EAMFC - Meridian Flows 2020 04 - 1 - EAMFC - Pushing Manipulation Technique 2020 04 - 2 - EAMFC - Arc Manipulation Technique 2020 04 - 3 - EAMFC - Kneeding Manipulation Technique 2020 04 - 4 - EAMFC - Pinching Manipulation Technique 2020 04 - 5 - EAMFC - Pressure Manipulation Technique 2020 04 - 6 - EAMFC - Rubbing Manipulation Technique 2020 04 - 7 - EAMFC - Stroking Manipulation Technique 2020 04 - 8 - EAMFC - Wiping Manipulation Technique 2020 05 - 0 - EAMFC - Introduction to Baby and Child Acupoints 2020 05 - 1 - EAMFC - Da zhui GV14 2020 05 - 2 - EAMFC - Lung Shu BL13 2020 05 - 3 - EAMFC - Spleen shu BL20 2020 05 - 4 - EAMFC - Kidney Shu BL 23 2020 05 - 5 - EAMFC - Spinal Column 2020 05 - 6 - EAMFC - QI Jie Gu2020 - Copy 05 - 7 - EAMFC - Stomach 2020 05 - 8 - EAMFC - Shan zhong CV17 2020 05 - 9 - EAMFC - Zhongwan CV 12 2020 05 - 10 - EAMFC - Tianshu ST 25 2020 05 - 11 - EAMFC - Xue hai (Bai chong) SP10 2020 05 - 12 - EAMFC - Zu San Li ST 36 2020 05 - 13 - EAMFC - San yin jiao SP 6 2020 05 - 14 - EAMFC - Yong quan KI 1 2020 05 - 15 - EAMFC - Liver Channel 2020 05 - 16 - EAMFC - Heart Channel 2020 05 - 17 - EAMFC - Spleen Channel 2020 05 - 18 - EAMFC - Lung Channel 2020 05 - 19 - EAMFC - Kidney Channel 2020 05 - 20 - EAMFC - Shen Ding - Tip of Kidney 2020 05 - 21 - EAMFC - Large intestine Channel 2020 05 - 22 - EAMFC - Ban men 2020 05 - 23 - EAMFC - Tianheshui - The Milky Way 2020 05 - 24 - EAMFC - Liu Fu - The Six Fu Visceral 2020 05 - 25 - EAMFC - Baihui GV 20 2020 05 - 26 - EAMFC - Yintang EX HN 3 2020 05 - 27 - EAMFC - Kan Gon 020 05 - 28 - EAMFC - Tianmen - Heaven Gate 2020 05 - 29 - EAMFC - Taiyang 2020 05 - 30 - EAMFC - Yingxiang LI 20 2020 05 - 31 - EAMFC - Ren zhong - The Philtrum GV 26 2020 05 -32 - EAMFC - Stomach Rubbing 2020 06 - 1 - EAMFC - Do and Don't 2020 Course 7: Understanding Autism Awareness and Diagnosis Level 2 Autism Spectrum Disorder (ASD) Learning Difficulties Related to Autism Autism Diagnosis Cognitive Approaches in Autism Dealing with Autistic Individuals Other Considerations for Dealing with Autistic Individuals Engagement in Autism Awareness Course 8: Play Therapy Module 01: What is Play Therapy Module 02: Advantages and Outcomes of Play Therapy Module 03: Models and Approaches of Play Therapy Module 04: The Play Settings: Therapist, Abused Child and Materials Module 05: Typical Issues in Play Therapy Module 06: Play Therapy for Sexually and Emotionally Abused Children Module 07: Play Therapy for Children Who are Homeless Module 08: Play Interventions for Disaster Mental Health Module 09: Case Studies and Recent Trends in Play Therapy Course 9: Couples Therapy & Counselling Module 01: Introduction Module 02: Communication Module 03: Conflict Resolution Module 04: Intimacy Module 05: Pre-Marital Counselling Module 06: Healthy Fighting Module 07: Affairs Module 08: Apology & Forgiveness Module 09: Adapting to Changes Module 10: Moving Forward Together Course 10: Anti Social Behaviour Module 01: Overview of Anti-social Behaviour Module 02: Family Influences on Anti-social Behaviour Module 03: Anti-Social Behaviour Order Module 04: Anger and Anti-social Behaviour Module 05: Understanding Antisocial Personality Module 06: Prevention of Anti-social Behaviour Course 11: Paediatric First Aid Level 3 Module 01: Aim of First Aid and the First Steps Module 02: Resuscitation (CPR) Module 03: Secondary Assessment, The Recovery Position And Shock Module 04: Head and Eye Injuries, Fractures, and Amputation Module 05: Choking, Wounds, Bleeding & Burns Module 06: Secondary Conditions and Reactions I Module 07: Secondary Conditions and Reactions II Module 08: Chronic Conditions Module 09: Medical Emergencies - Poisoning, Smoke inhalation, Hypothermia, Elect CPD 110 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Anyone from any background can enrol in this Parenting Skills bundle. Persons with similar professions can also refresh or strengthen their skills by enrolling in this course. Students can take this course to gather professional knowledge besides their study or for the future. Requirements Our Parenting Skills is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible with tablets and smartphones so you can access your course on Wi-Fi, 3G or 4G. There is no time limit for completing this course, it can be studied in your own time at your own pace. Career path Having these various expertise will increase the value in your CV and open you up to multiple job sectors. Certificates Certificate of completion Digital certificate - Included Certificate of completion Hard copy certificate - Included You will get the Hard Copy certificate for the title course (Parenting Skills Training) absolutely Free! Other Hard Copy certificates are available for £10 each. Please Note: The de.livery charge inside the UK is £3.99, and the international students must pay a £9.99 shipping cost

Parenting Skills - CPD Accredited
Delivered Online On Demand
£53

Sales Skills

4.7(160)

By Janets

Register on the Sales Skills today and build the experience, skills and knowledge you need to enhance your 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 Sales Skills 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! 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 Assignment Certificate of Achievement Endorsed Certificate of Achievement from the Quality Licence Scheme Once the course has been completed and the assessment has been passed, all students are entitled to receive an endorsed certificate. This will provide proof that you have completed your training objectives, and each endorsed certificate can be ordered and delivered to your address for only £99. Please note that overseas students may be charged an additional £10 for postage. CPD Certificate of Achievement from Janets Upon successful completion of the course, you will be able to obtain your course completion e-certificate free of cost. Print copy by post is also available at an additional cost of £9.99 and PDF Certificate at £4.99. Endorsement This course and/or training programme has been endorsed by the Quality Licence Scheme for its high-quality, non-regulated provision and training programmes. This course and/or training programme is not regulated by Ofqual and is not an accredited qualification. Your training provider will be able to advise you on any further recognition, for example progression routes into further and/or higher education. For further information please visit the Learner FAQs on the Quality Licence Scheme website. Method of Assessment In order to ensure the Quality Licensing scheme endorsed and CPD acknowledged certificate, learners need to score at least 60% pass marks on the assessment process. After submitting assignments, our expert tutors will evaluate the assignments and give feedback based on the performance. After passing the assessment, one can apply for a certificate. Who is this course for? The course is ideal for those who already work in this sector or are an aspiring expert. This course is designed to enhance your expertise and boost your CV. Learn key skills and gain a lesson to prove your newly-acquired knowledge. Course Content Module 01: Introduction to Sales Introduction to Sales 00:25:00 Module 02: Sales Growth Sales Growth 00:25:00 Module 03: Sales Hypnosis Sales Hypnosis 00:22:00 Module 04: Sales Presentation Sales Presentation 00:20:00 Module 05: Sales and Marketing Sales and Marketing 00:28:00 Module 06: Leverage and Limitations Leverage and Limitations 00:19:00 Module 07: Communication Skills Communication Skills 00:22:00 Module 08: Sales Negotiations Sales Negotiations 00:30:00 Module 09: Dealing with Customers Dealing with Customers 00:29:00 Module 10: Handling Objections Handling Objections 00:20:00 Module 11: Tips and Tricks for Sale Tips and Tricks for Sale 00:20:00 Assignment Assignment - Sales Skills 2 weeks, 1 day Order Your Certificate Order your Certificate QLS 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.

Sales Skills
Delivered Online On Demand3 weeks
£25

Mentoring and Leadership Skills - Double Endorsed Certificate

By Imperial Academy

2 QLS Endorsed Course | CPD Certified | Free PDF + Hardcopy Certificates | 80 CPD Points | Lifetime Access

Mentoring and Leadership Skills - Double Endorsed Certificate
Delivered Online On Demand
£150

Microsoft Excel Advanced - In-company

By Microsoft Office Training

Course Objectives At the end of this course you will be able to: Work with advanced lookup and reference functions Create macros to automate common tasks Use advanced techniques to analyse data Create PivotTables and PivotCharts Work with data validation tools Import and export data ' Customer Feedback Best Training Ever! Just finished a bespoke 1-1 training course in Excel Advanced, Macros & VBA. Pedro is an excellent trainer, imparting his skills and knowledge in the best way - appropriately to audience skills, knowledge and ability. Pedro is always approachable, encouraging and supportive, giving delegates the optimum learning environment. I would not hesitate to recommend Pedro as a trainer, whatever your level of ability. Amanda Morris - Treasury & Systems Accountant at Reall - Real Equity for All The course was very interesting and engaging and will definitely be put to use. The trainer was very helpful and charismatic. Marving Lopez - AM Best Europe Pedro was excellent. Very knowledgeable, clear and great rapport with class. Darren Barkey - Direct Wines Great content and learnt a lot. Really enjoyable :) Kristie-Lee Ryan - Stirling Ackroyd 1 year email support service Take a closer look at the consistent excellent feedback from our growing corporate clients visiting our site ms-officetraining co uk With more than 20 years experience, we deliver courses on all levels of the Desktop version of Microsoft Office and Office 365; ranging from Beginner, Intermediate, Advanced to the VBA level. Our trainers are Microsoft certified professionals with a proven track record with several years experience in delivering public, one to one, tailored and bespoke courses. Our competitive rates start from £550.00 per day of training Tailored training courses: You can choose to run the course exactly as they are outlined by us or we can customise it so that it meets your specific needs. A tailored or bespoke course will follow the standard outline but may be adapted to your specific organisational needs. Please visit our site (ms-officetraining co uk) to get a feel of the excellent feedback our courses have had and look at other courses you might be interested in. Advanced Functions COUNT, COUNTA, COUNTIF, COUNTBLANK, SUMIF, SUBTOTAL IF, OR, AND, IFERROR VLOOKUP to lookup Exact Values and Approximate values MATCH, INDIRECT, ROW/COLUMN, INDEX, OFFSET Analysing Data PMT function to calculate a monthly payment of a loan What If Analysis using Goal Seek Use scenarios to consider many different variables Using Solver Add-in to optimize variables PivotTables Create a PivotTable to analyse worksheet data Add or remove fields in a PivotTable Change the data source for a PivotTable Working with external data sources Using different Statistical Functions Calculate a Running Total, % of Grant Total, Difference From… Using the Slicer and Timeline to filter the PivotTable Using Filters in a PivotTable Group by Date, Auto Group by ranges of values, Custom Group Create a PivotChart The GETPIVOTDATA function Formula auditing Precedents and dependents Error checking Watch a formula and its result by using the Watch Window Evaluate a nested formula one step at a time Data Validation Number Validation Data List Validation Message Prompts and Alerts Conditional Data Validation Data Validation Errors Consolidation Consolidate data by position Consolidate data by category Use a formula to consolidate data Outline (group) data in a worksheet Create an outline of rows Create an outline of columns Copy outlined data Hide or remove an outline Connect external data to your workbook Using the Power Query Editor to import data From Text and CSV, From Access, From Web, From another Workbook Using the Power Query Editor to; Transform your data by Selecting which fields to import, by Splitting Columns, Changing Data Type and more. Deleting Applied Steps Refreshing your data Working with Form Controls; Buttons, Option Buttons and Scroll Bars Introduction to Macros Change Macro Security settings How to Record a macro Some Macro Examples Delete a macro Edit the macro to view the VBA code Copy part of a macro to create another macro Assign a macro to a button Who is this course for? Who is this course for? This course is intended to end users who want to develop their skills so they can use advanced techniques to analyse extensive and complex datasets in Excel and to automate simple tasks with the use of Macros. Requirements Requirements Preferably, delegates should have attended the Excel Intermediate course. Career path Career path Excel know-how can instantly increase your job prospects as well as your salary. 80 percent of job openings require spreadsheet and word-processing software skills Certificates Certificates Certificate of completion Digital certificate - Included

Microsoft Excel Advanced - In-company
Delivered in London or UK Wide or OnlineFlexible Dates
£650

Interview Skills - Achieve Own Job Goals

By Training Tale

The relevant industry experts developed this Interview Skills - Achieve Own Job Goals course. Searching for a job can be exciting; it can also be fraught with anxiety and discomfort due to change and the unknown. Whether you are already in the midst of a job search or are considering one, this Interview Skills - Achieve Own Job Goals course will provide you with the skills necessary to identify and apply for suitable jobs, as well as to prepare for and conduct yourself in a job interview. The job market today is not what it was even five years ago. Knowing where to go, who to talk to, and what opportunities are available will help you transition from someone who fantasizes about having a job to someone who has the job they've always wanted. The purpose of this Interview Skills - Achieve Own Job Goals course is to help you determine your skillset, the type of work that is important and realistic to include in your search, and how to get started. Learning Outcomes After completing this Interview Skills - Achieve Own Job Goalscourse, the learner will be able to: Learn how to identify achievable job goals. Gain a thorough understanding of the key qualities required for employment from an employer's perspective. Know the different types of CVs and cover letters used to apply for jobs. Know how to identify suitable job opportunities and apply for them. Understand how to prepare for an interview. Understand how to conduct yourself in an interview situation. Know how to reflect on your own performance following an interview situation. Why Choose Interview Skills - Achieve Own Job Goals Course from Us Self-paced course, access available from anywhere. Easy to understand, high-quality study materials. Course developed by industry experts. MCQ quiz after each module to assess your learning. Automated and instant assessment results. 24/7 support via live chat, phone call or email. Free PDF certificate as soon as completing the course. Assessment Method After completing each module of the Interview Skills - Achieve Own Job Goals, you will find automated MCQ quizzes. To unlock the next module, you need to complete the quiz task and get at least 60% marks. Once you complete all the modules in this manner, you will be qualified to request your certification. Certification After completing the MCQ/Assignment assessment for this course, you will be entitled to a Certificate of Completion from Training Tale. It will act as proof of your extensive professional development. The certificate is in PDF format, which is completely free to download. A printed version is also available upon request. It will also be sent to you through a courier for £13.99. **Interview Skills - Achieve Own Job Goals** Detailed Curriculum of Interview Skills - Achieve Own Job Goals [Bundle Course 1] Module 01: Preparing to Achieve Own Job Goals Understand how to identify achievable job goals Understand the key qualities required for employment from an employer perspective Be able to identify own employability skill Module 02: Promoting Yourself and Preparing for a Job Interview Know the different types of CV and cover letter used to apply for jobs Understand where and how to search for jobs Be able to identify suitable job opportunities and apply for them Understand how to prepare for an interview Be able to conduct self in an interview situation Be able to reflect on own performance following an interview situation [Bundle Course 2] Module 01: Workplace Stress Define Workplace Stress The Most Important Factors Influencing Workplace Stress The Fallout of Workplace Stress Module 02: Rational and Irrational Beliefs Rational Emotive Behaviour Therapy Define Rational Thinking & Irrational Thinking The Origin of Irrational Thinking The Silver Lining Irrational Core Beliefs Acceptance Module 03: The ABC Framework of REBT Situation Disputing Module 04: Cognitive Therapy (CT) Cognitive Therapy (CT) Cognitive Errors Negative Automatic Thoughts (NATs) and Dysfunctional Beliefs Recognizing Our Dysfunctional Beliefs Example Recapitulation of CT and REBT Module 05: Cognitive Behavioural Therapy (CBT) in the Workplace How Can (CBT) Techniques Help Us in the Workplace? Situations That We Face at Work Which May Cause Stress The Advantages of Cognitive Behavioural Therapy in the Workplace Cognitive Behavioural Therapy (CBT) for Us Module 06: Conclusion Conclusion Module 07: Identifying and Challenging Distorted Negative Thoughts Exercise 1: Lost Your Job Exercise 2: Failed in Your Job Interview Exercise 3: Not the All-Rounder Exercise 4: Feeling Inferior Exercise 5: Mundane Work Exercise 6: Being Laughed At Exercise 7: The Boss Is Dumping His Work on You Exercise 8: Feel Incompetent Exercise 9: Can't Stand Up for Yourself Exercise 10: Boss Does Not Like You Exercise 11: Failed to Do What You Had Planned Exercise 12: Lack Common Sense Exercise 13: You Help Others but They Don't Help You Exercise 14: Feeling Inferior Exercise 15: Never Speak Up at Meetings Exercise 16: Never Speak Up at Meetings (This Time for a Different Reason) Exercise 17: Never Speak Up at Meetings (For Yet Another Reason) Exercise 18: Complaint Against You Exercise 19: Impress the Chairman Exercise 20: A Disastrous Day Exercise 21: Interview After-Effects Exercise 22: Anxiety Jitters at Presentations Exercise 23: Not Popular Exercise 24: Ethical Dilemma [Bundle Course 3] Module 01: Difficult People and Their Difficult Behaviour Introduction Openly Hostile, Aggressive Behaviour Disguised Hostility: Passive-Aggressive Behaviour Passive Behaviour Module 02: Communicating With Difficult People Introduction Minimal Encouragers Reflective Listening Questions About Feelings Non-Verbal Communication Talking to Difficult People Module 03: Standing Up to Difficult People Introduction How to be Assertive Building the Confidence to be More Assertive Choosing How to Respond Module 04: A Quick Guide to the Seven Classically Difficult Types Hostile, Aggressive, Belligerent and Offensive Complainer, Grouches and the Sourpuss The Silent Unresponsive and the Quiet Ones The Super Agreeable: A Bit Like a Spaniel Puppy The Negativist The Know-All The Indecisive, The Ditherer, The Hesitant Module 05: Dealing with Bosses Who Drive You Barmy Introduction Mr Angry Never Let Them See You Sweat Module 06: Colleagues to Throttle Introduction Competition Crazy Rivals, Antagonists and Getting Personal It Is Always the Quiet Ones Module 07: Dealing With Impossible People Impossible People Critical, Impossible-to-Please Impossible People Persistently Negative Impossible People Drama Queens Self-Centred Impossible People Bullies How to Deal with Impossible People Module 08: The Temper Tantrum Type How to Spot a Temper Tantrum Type How Did Temper Tantrum Types Get That Way? How to Avoid Temper Tantrum Types Getting Temper Tantrum Types to Act Their Age Who is this course for? **Interview Skills - Achieve Own Job Goals** The Interview Skills - Achieve Own Job Goals is ideal for anyone who wants to learn how to apply for the job they want. Requirements **Interview Skills - Achieve Own Job Goals** There are no specific requirements for this Interview Skills - Achieve Own Job Goals Course because it does not require any advanced knowledge or skills. Students who intend to enrol in this course must meet the following requirements: Good command of the English language Must be vivacious and self-driven Basic computer knowledge A minimum of 16 years of age is required

Interview Skills - Achieve Own Job Goals
Delivered Online On Demand32 hours
£12

Computer Networks Security and Coding with Scratch

4.5(3)

By Studyhub UK

Do you want to prepare for your dream job but strive hard to find the right courses? Then, stop worrying, for our strategically modified Computer Networks Security and Coding with Scratch bundle will keep you up to date with the relevant knowledge and most recent matters of this emerging field. So, invest your money and effort in our 33 course mega bundle that will exceed your expectations within your budget. The Computer Networks Security and Coding with Scratch related fields are thriving across the UK, and recruiters are hiring the most knowledgeable and proficient candidates. It's a demanding field with magnitudes of lucrative choices. If you need more guidance to specialise in this area and need help knowing where to start, then StudyHub proposes a preparatory bundle. This comprehensive Computer Networks Security and Coding with Scratch bundle will help you build a solid foundation to become a proficient worker in the sector. This Computer Networks Security and Coding with Scratch Bundle consists of the following 30 CPD Accredited Premium courses - Course 01:Coding with Scratch Course 02:Quick Data Science Approach from Scratch Course 03:Learn CSS Coding from Scratch Course 04:Create HTML Email from Scratch Course 05:Computer Networks Security from Scratch to Advanced Course 06:Python from Scratch Course 07:AutoCAD Programming using C# with Windows Forms Course 08:AutoCAD Programming using VB.NET with Windows Forms Course 09:AutoCAD to Excel - VBA Programming Hands-On! Course 10:AutoCAD VBA Programming - Beginner course Course 11:IT Support Technician Training Course 12:Admin Support Assistant Course 13:Build Your Own Robot | Robotic Process Automation (RPA) Course 14:Neuro-linguistic Programming (NLP) Diploma Course 15:Cyber Security Incident Handling and Incident Response Course 16:Computer Networks Security Course 17:IT Asset Department Course 18:C# Programming - Beginner to Advanced Course 19:Master JavaScript with Data Visualization Course 20:jQuery: JavaScript and AJAX Coding Bible Course 21:Kotlin Programming : Android Coding Course 22:Secure Programming of Web Applications Course 23:Build WebXR, VR and AR, experiences using Three.JS Course 24:Complete AutoLISP Programming Course 25:Learn Web Development from Scratch Course 26:SQL Programming Masterclass Course 27:SQL Server for Beginners Course 28:SQL NoSQL Big Data and Hadoop Course 29:Microsoft SQL Server Development for Everyone Course 30:Javascript Programming for Beginners 3 Extraordinary Career Oriented courses that will assist you in reimagining your thriving techniques- Course 01: Career Development Plan Fundamentals Course 02: CV Writing and Job Searching Course 03: Interview Skills: Ace the Interview Learning Outcome This tailor-made Computer Networks Security and Coding with Scratch bundle will allow you to- Uncover your skills and aptitudes to break new ground in the related fields Deep dive into the fundamental knowledge Acquire some hard and soft skills in this area Gain some transferable skills to elevate your performance Maintain good report with your clients and staff Gain necessary office skills and be tech savvy utilising relevant software Keep records of your work and make a report Know the regulations around this area Reinforce your career with specific knowledge of this field Know your legal and ethical responsibility as a professional in the related field This Computer Networks Security and Coding with Scratch Bundle resources were created with the help of industry experts, and all subject-related information is kept updated on a regular basis to avoid learners from falling behind on the latest developments. Certification After studying the complete training you will be able to take the assessment. After successfully passing the assessment you will be able to claim all courses pdf certificates and 1 hardcopy certificate for the Title Course completely free. Other Hard Copy certificates need to be ordered at an additional cost of •8. CPD 330 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Ambitious learners who want to strengthen their CV for their desired job should take advantage of the Computer Networks Security and Coding with Scratch bundle! This bundle is also ideal for professionals looking for career advancement. Requirements To participate in this course, all you need is - A smart device A secure internet connection And a keen interest in Computer Networks Security and Coding with Scratch Career path Upon completing this essential Bundle, you will discover a new world of endless possibilities. These courses will help you to get a cut above the rest and allow you to be more efficient in the relevant fields.

Computer Networks Security and Coding with Scratch
Delivered Online On Demand7 days
£279