3024 Dele courses

Duration 1 Days 6 CPD hours This course is intended for To ensure success, students will need to be familiar with using personal computers and should have experience using a keyboard and mouse. Students should also be comfortable working in the Windows environment and be able to manage information on their computers. Overview Upon successful completion of this course, you will be able to create and develop Excel worksheets and workbooks in order to work with and analyse the data that is critical to the success of your organisation. This course is intended for those who wish to gain the foundational understanding of Excel that is necessary to create and work with electronic spreadsheets. Excel can help you organise, calculate, analyse, revise, update, and present your data. Getting Started with Excel Navigate the Excel User Interface Use Excel Commands Create and Save a Basic Workbook Enter and Edit Cell Data Fill Cells with Series of Data (AutoFill and Flash Fill) Use Excel Help Performing Calculations Create Worksheet Formulas Insert Functions and use Autocomplete Reuse Formulas and Functions Create an Absolute Reference Modifying a Worksheet Insert, Delete, and Adjust Cells, Columns, and Rows Move and Copy Data between Cells Search for and Replace Data Use Spellcheck and Proofing Formatting a Worksheet Apply Text Formats Apply Number Formats Align Cell Contents Apply and Copy Cell Styles Apply Basic Conditional Formatting Printing Workbooks Preview and Print a Workbook Controlling Page Layout Adding Headers and Footers Set Print Titles and Print Ranges Managing Workbooks Manage Worksheets Insert and Delete Worksheets Manage Workbook and Worksheet Views Manage Workbook Properties

Excel Advanced Course, 1-Day. Who should attend: Excel Advanced is for Excel Experts: Your work daily with Excel and your work revolves around spreadsheets and Excel databases. Course Details: Location: Instructor-led, Online. Our Style: Hands-on, Practical Course. Group Size: Max 4 people per group. Qualification: PCWorkshops Excel Advanced Certification Hours: 1 Day, 10am-5pm Delivery Style: 1-1, because we understand that individuals have varying skill levels and varying applications. Excel Advanced Course Description General Editing Standard Formatting Rules Input Validate rules Using Formulas in Conditional Formatting Group and Outline Filter and Sorting Excel Tables and Advanced Filter Working with Excel tables Copy specific datasets from sheets, workbooks or external data Consilidate Goal seek, consolidate and scenarios Using Form Templates Creating Templates Advanced Excel Lookup Functions VLookup Function Hlookup Function Using the Index Function, Using the Match Function, Index and Match Together Using the Indirect Function Excel Advanced Functions Using Error Functions, Logical Functions, Array Functions, Rounding Functions Advanced Excel Pivot Table Tools Importing Pivot Table Data, Calculated Fields in Pivot Tables, Showing Pivot Data as a Percentage, Creating Custom Pivot Tables Styles Pivot Charts Excel Macros Creating, amending and deleting macros Running macros Macro menus, toolbars and shortcuts Alternative Excel Courses Inlcuded with the Excel Advanced Course PCWorkshops Excel Advanced Certificate on completion Excel Advanced Notes Excel Code Examples Practical Excel Advanced exercises Personalised attention in a 1-1 session About us Our experienced trainers are award winners. FAQ's Client Comments

SSSTS The CITB SSSTS course is an accredited Site Supervisors Safety Training Scheme for the construction site supervisor, these are generally referred to as SSSTS training courses. The supervisors safety training scheme is now a requirement set out by the major contractors group for all supervisors who will be working on their sites. Construction skills and health and safety need to go hand in hand and made a priority to encourage improved work skills and reduced accidents and injuries. On the 2 day SSSTS training course the main focus will be on: THE IMPORTANCE OF RISK ASSESSMENTS IN THE CONSTRUCTION INDUSTRY THERE IS A FOCUS ON HOW TO IMPLEMENT CONTROL MEASURES ON SITE AND HOW TO USE COMMUNICATION TO ENSURE THE SITE REMAINS SAFE FOR EVERYONE MONITORING THE CONTROL MEASURES AND WORK ACTIVITIES ENSURING THAT THE WORK IS CARRIED OUT CORRECTLY AND SAFELY Delegates attending CITB SSSTS courses and who successfully complete will receive a SSSTS certificate to show that they are able to help supervise in the construction industry and have understanding when it comes to health and safety in the work place. During the course the main topics of the syllabus are: THE HEALTH AND SAFETY ACTS, REGULATIONS APPROVED CODES OF PRACTICE AND GUIDANCE NOTES THE HEALTH AND SAFETY LEGAL SYSTEM CAUSES, TYPES AND THE NUMBERS OF CONSTRUCTION ACCIDENTS RISK ASSESSMENTS IN ALL MANNER OF CONSTRUCTION CIRCUMSTANCES The concise SSSTS courses will provide you with the skills to: IDENTIFY PROBLEM AREAS FOUND IN THE CONSTRUCTION INDUSTRY UNDERSTAND AND APPRECIATE PROACTIVE AND REACTIVE MONITORING PERFORM RISK ASSESSMENTS AND RECOGNISE THE IMPORTANCE OF METHOD STATEMENTS HAVE AN UNDERSTANDING OF THE WAY THE HEALTH AND SAFETY LAWS ARE STRUCTURED LEARN SKILLS NEEDED TO PERFORM ON SITE INDUCTIONS, METHOD BRIEFS AND TOOLBOX TALKS CITB SSSTS Courses at a Glance The SSSTS training course is designed for first line mangers looking to continue or take on a supervisory role within the construction industry. The course takes place over two days and will teach health and safety skills needed to maintain a safe site. A thirty minute multiple choice examination will follow the training. Upon successful completion of the SSSTS training the candidate will be awarded with the CITB Site Supervisory Safety Training Certificate. Further Development Successful candidates can go on to complete the 5 day site managers safety training scheme SMSTS course designed for site managers and supervisors.

The course will enable delegates to be aware of issues associated with Legionella and be able to...

Course Objectives This course aims to provide delegates with a foundation for Excel knowledge and skills. ' Customer Feedback Great course and excellent trainer. Thanks Tracy Preston - Western Power Distribution Very helpful course. Would definitely take another one. Pedro was very patient and made it fun and engaged with us all. Laura Smith - James Grant Very professional and well mannered, fun and pleasant at the same time. I learnt a lot Carolina Foster - CNN 1 year email support service Take a look at the consistent excellent feedback from trainees 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. Tailored in company 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. What is Excel? The Excel Interface Ribbon, Tabs and Groups Microsoft Office Backstage view Working with Workbooks Create a blank Workbook Create a Workbook using a Template Opening and saving Files Working with worksheets Worksheet navigation Select one or multiple Worksheets Insert, Move, Copy or Delete a Worksheet Working with Cells, Rows & Columns Cell References How to select cells or ranges Different types of data Move, Copy and Delete cells Pasting Options Find and Replace Working with Rows and Columns Overview of formulas in Excel Autocalculation The parts of an Excel formula Using calculation operators in Excel formulas The difference between Absolute, Relative and Mixed references Using Excel functions; Sum, Average, Max and Min Cell Formatting Font Format options Number Format options Change the Fill and Borders Cell Alignment An Introduction to Charts Create a simple Chart Format your chart Page Layout and Print Page Layout and Page Break View Change the Page Orientation Set Page Margins Headers and Footers in a worksheet Print a worksheet or workbook Who is this course for? Who is this course for? For those who want to explore in more detail formulas and functions, data analysis and data presentation. Requirements Requirements General knowledge of the Windows OS 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

P402 Surveying and sampling strategies for asbestos in buildings is the industry standard qualification for asbestos surveyors. In addition to holding the qualification, asbestos surveyors are required to undertake and provide evidence of annual refresher training.

P405 Managing Asbestos in Buildings is the industry standard qualification for those whose work involves asbestos management, such as duty holders and building managers. In addition to holding the qualification, they are required to undertake and provide evidence of annual refresher training. RP405 Refresher is a new course, specifically designed to meet this requirement. RP405 Refresher enables candidates to revise and update their knowledge on good asbestos management practices, and to receive a certificate of course completion by passing a written examination, which covers both the theory and practice of managing asbestos in buildings.

The Learning College Group offers this Teaching Assistant qualification that is fully Regulated and accepted in all schools across the UK. It enables you to work with children between the ages of 5-18 years. Train to teach with this Government Recognised Teaching Assistant Qualification. This Teaching Assistant Qualification is accepted in all UK schools and covers the role of both Classroom Assistant and Teaching Assistant positions. Learn in your own time at your own pace. The Teaching Assistant materials are accessible 24/7 along with full 1-2-1 Tutor support.

Do you want to prepare for your dream job but strive hard to find the right courses? Then, stop worrying, for our strategically modified HR Audit, Crisis, Payroll and People 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 40 course mega bundle that will exceed your expectations within your budget. The HR Audit, Crisis, Payroll and People 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 HR Audit, Crisis, Payroll and People Management bundle will help you build a solid foundation to become a proficient worker in the sector. This HR Audit, Crisis, Payroll and People Management Bundle consists of the following 30 CPD Accredited Premium courses - Course 01 :HR Practice Essentials Level 4 Course 02 :HR - Crisis Communication Course 03 :HR Assistant Skills Certification Course 04 :Motivational Interviewing Course 05 :Motivation Skills Course 06 :People Management Skills Level 3 Course 07 :Team Management Course 08 :Dealing With Difficult People Training Course Course 09 :Virtual Interviewing for HR Course 10 :Virtual Training Masterclass Course 11 :HR and Marketing Level 4 Course 12 :Recruitment Officer Diploma Course 13 :HR and Recruitment Consultant Training Course 14 :HR Advisor and Recruitment Training Diploma Course 15 :HR Management Level 3 Course 16 :Employment Laws & Recruitment Process 2020 - Level 3 Course 17 :Human Resources (HR) Audit Course 18 :Payroll Administrator and UK Payroll System Training Course 19 :Office Administration Certificate Course 20 :Contract Management Course Course 21 :Workplace Stress Management Course 22 :Positive Psychology Masterclass Course 23 :Emotional Intelligence and Human Behaviour Course 24 :Delegation Skills Course 25: Interpersonal Skills in Management Course 26: Effective Listening Skills for Leaders Course 27: Personal and Networking Skills Course 28: Performance Centered Asset Management Course 29: Office Skills and Administration Management Diploma Course 30: Performance Management 10 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 Course 04 :Video Job Interview for Job Seekers Course 05 :Create a Professional LinkedIn Profile Course 06 :Business English Perfection Course Course 07 :Networking Skills for Personal Success Course 08 :Boost Your Confidence and Self-Esteem Course 09 :Public Speaking Training Course 10 :Learn to Fight Procrastination Learning Outcome This tailor-made HR Audit, Crisis, Payroll and People 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 HR Audit, Crisis, Payroll and People 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 400 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 HR Audit, Crisis, Payroll and People Management 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 HR Audit, Crisis, Payroll and People 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.

Do you want to prepare for your dream job but strive hard to find the right courses? Then, stop worrying, for our strategically modified Mechanical Engineering For Car & Motorbike Mechanic 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 40 course mega bundle that will exceed your expectations within your budget. The Mechanical Engineering For Car & Motorbike Mechanic 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 Mechanical Engineering For Car & Motorbike Mechanic bundle will help you build a solid foundation to become a proficient worker in the sector. This Mechanical Engineering For Car & Motorbike Mechanic Bundle consists of the following 30 CPD Accredited Premium courses - Course 01 : Basic Automotive Engineering: Onboard Diagnostics Course 02 : Car Mechanic and Repair Training Course 03 : Car Maintenance & Life Skills Course 04 : Motorbike Repairing and Maintenance Diploma Course 05 : Gas Safety Course 06 : Fire Safety | Online Course Course 07 : Effective Communication Skills Course 08 : Delegation Skills Course 09 : Functional Skills IT Course 10 : Project Management Essential Skills Level 3 Course 11 : Environment Management Course 12 : Sustainable Energy and Development Diploma Course 13 : Domestic Gas Engineer Course 14 : Oil and Gas Management Course 15 : Domestic Gas Working Course Course 16 : Gas Safety Course 17 : UK Standard Domestic Plumbing and Heating Installer Training Course 18 : Domestic Plumbing, Installations and Repair Diploma Course 19 : Level 3 Heating, Ventilation & Air Conditioning (HVAC) Technician Course 20 : Domestic Appliance Repairing Course Course 21 : Power Electronics for Electrical Engineering Course 22 : Engineering Management Course 23 : Electric Circuits for Electrical Engineering Course 24 : Trigonometry for Electrical Engineering Course 25: Electrical Technician Course 26: Electronic & Electrical Devices Maintenance Course 27: Electrical Components And Circuits - Wiring & Busbars Course 28: Light Current Systems for Electrical Engineering Course 29: Electrical Machines for Electrical Engineering Course 30: Environmental Engineering 10 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 Course 04 :Video Job Interview for Job Seekers Course 05 :Create a Professional LinkedIn Profile Course 06 :Business English Perfection Course Course 07 :Networking Skills for Personal Success Course 08 :Boost Your Confidence and Self-Esteem Course 09 :Public Speaking Training Course 10 :Learn to Fight Procrastination Learning Outcome This tailor-made Mechanical Engineering For Car & Motorbike Mechanic 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 Mechanical Engineering For Car & Motorbike Mechanic 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 400 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 Mechanical Engineering For Car & Motorbike Mechanic 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 Mechanical Engineering For Car & Motorbike Mechanic 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.