1266 Statistics courses

Course Objectives The goal of this course is to provide you with the knowledge required to use more advanced functions and formulas and work with various tools to analyse and present data in spreadsheets, such as sorting, filtering, applying conditional formatting and charting the data. ' Customer Feedback Really useful and engaging course. Learnt a lot that will be very beneficial in my job. Trainer was great. Kelly Moreley - TACT Very happy with the course. Worked as a good refresher from what I knew already and enhanced my knowledge further in formulas + vlookup and shortcut keys. Jenny Price - Acer 1 year email support service Take a look at the consistent excellent feedback from our 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 classroom, one to one, tailored and bespoke courses. Tailored In company training: 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. Recap on Excel formulas and calculations Overview of formulas in Excel Relative, Absolute and Mixed cell references Group editing worksheets Autofill and Flash Fill Changing Excel’s environment Options Changing the default number of sheets Creating an Autofill Custom List Adding tools to the Quick Access Toolbar Mastering Excel Tables Introducing Excel Tables Formatting a Table Creating Calculated Columns Using Slicers to filter your data Using Totals to get statistics out of your data Removing duplicates Converting Tables back to normal Ranges Using names Ranges In Excel formulas As a way of navigating through the workbook Advanced Formulas Simple IF examples Using IF to check if a cell is blank Nested IFs VLOOKUP HLOOKUP Text Functions Date Functions Conditional formatting Apply Conditional Formatting Customising Conditional Formatting Using Icons in Conditional Formatting Using Formulas to conditionally format cells Linking spreadsheets and workbooks Making a reference to another worksheet Making a reference to another workbook Editing links Troubleshooting links Analysing databases Quick analysis Sorting a database Apply filters to a database Advance filter Sorting and Filtering by Conditional Formats Charts Analyse trends in data using Sparklines Creating charts from start to finish Exploring the different Chart Types Apply Chart Styles Formatting Chart Elements Filtering Charts by Series or Categories Adding a Trendline to a Chart Create a Chart Template Attaching security to a spreadsheet and workbook Protect Cells Protect Structure of worksheets Protect a Workbook by adding passwords Introduction to Pivot Tables What are Pivot Tables? Using recommended pivot tables to analyse your data 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 Preferably, delegates would have attended the Excel Introduction 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

Course Objectives The goal of this course is to provide you with the knowledge required to use more advanced functions and formulas and work with various tools to analyse and present data in spreadsheets, such as sorting, filtering, applying conditional formatting and charting the data. ' Customer Feedback Really useful and engaging course. Learnt a lot that will be very beneficial in my job. Trainer was great. Kelly Moreley - TACT Very happy with the course. Worked as a good refresher from what I knew already and enhanced my knowledge further in formulas + vlookup and shortcut keys. Jenny Price - Acer 1 year email support service Take a look at the consistent excellent feedback from our 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 classroom, one to one, tailored and bespoke courses. Tailored In company training: 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. Recap on Excel formulas and calculations Overview of formulas in Excel Relative, Absolute and Mixed cell references Group editing worksheets Autofill and Flash Fill Changing Excel’s environment Options Changing the default number of sheets Creating an Autofill Custom List Adding tools to the Quick Access Toolbar Mastering Excel Tables Introducing Excel Tables Formatting a Table Creating Calculated Columns Using Slicers to filter your data Using Totals to get statistics out of your data Removing duplicates Converting Tables back to normal Ranges Using names Ranges In Excel formulas As a way of navigating through the workbook Advanced Formulas Simple IF examples Using IF to check if a cell is blank Nested IFs VLOOKUP HLOOKUP Text Functions Date Functions Conditional formatting Apply Conditional Formatting Customising Conditional Formatting Using Icons in Conditional Formatting Using Formulas to conditionally format cells Linking spreadsheets and workbooks Making a reference to another worksheet Making a reference to another workbook Editing links Troubleshooting links Analysing databases Quick analysis Sorting a database Apply filters to a database Advance filter Sorting and Filtering by Conditional Formats Charts Analyse trends in data using Sparklines Creating charts from start to finish Exploring the different Chart Types Apply Chart Styles Formatting Chart Elements Filtering Charts by Series or Categories Adding a Trendline to a Chart Create a Chart Template Attaching security to a spreadsheet and workbook Protect Cells Protect Structure of worksheets Protect a Workbook by adding passwords Introduction to Pivot Tables What are Pivot Tables? Using recommended pivot tables to analyse your data 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 Preferably, delegates would have attended the Excel Introduction 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

Overview Gainup-to-date HR skills with the HR, Payroll,Paye, Tax Professional Diploma course. This HR, Payroll,Paye, Tax Professional Diploma course will provide you with an in-depth understanding of human resource management fundamentals and the skills to manage payroll expertly. It is designed to assist you to grasp every concept, from the basics to the advanced aspects.Boost your career with HR skills and gain the knowledge to work for leading companies. How will I get my certificate? You may have to take a quiz or a written test online during or after the course. After successfully completing the course, you will be eligible for the certificate. Who is this course for? There is no experience or previous qualifications required for enrolment on this HR, Payroll,Paye, Tax Professional Diploma. It is available to all students, of all academic backgrounds. Requirements Our HR, Payroll,Paye, Tax Professional Diploma is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible on tablets and smartphones so you can access your course on wifi, 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 qualifications will increase the value in your CV and open you up to multiple sectors such as Business & Management , Admin, Accountancy & Finance, Secretarial & PA, Teaching & Mentoring etc. Course Curriculum 16 sections • 47 lectures • 12:12:00 total length •Human Resource Management: 01:00:00 •HR Planning, Recruitment and Selection: 01:00:00 •Induction, Training and Development: 00:45:00 •HR Department's Responsibilities: 00:45:00 •The UK Recruitment Legislations Guide: 00:20:00 •Organisational Culture: 00:45:00 •Motivation, Counseling, Resignations and Retirement: 01:00:00 •Performance Appraisal: 00:45:00 •Remuneration Policy: 00:15:00 •Records and Statistics: 00:30:00 •Industrial Relations: 00:15:00 •The UK Recruitment Industry Statistics: 00:25:00 •Introduction to Payroll Management: 00:10:00 •An Overview of Payroll: 00:17:00 •Running the payroll - Part 1: 00:14:00 •Running the payroll - Part 2: 00:18:00 •Manual payroll: 00:13:00 •Benefits in kind: 00:09:00 •Computerised systems: 00:11:00 •Total Photo scenario explained: 00:01:00 •Brightpay conclude: 00:03:00 •Find software per HMRC Brightpay: 00:03:00 •Add a new employee: 00:14:00 •Add 2 more employees: 00:10:00 •Payroll settings: 00:04:00 •Monthly schedule - Lana: 00:14:00 •Monthly schedule - James: 00:08:00 •Directors NI: 00:02:00 •Reports: 00:02:00 •Paying HMRC: 00:05:00 •Paying Pensions: 00:04:00 •RTI Submission: 00:02:00 •Coding Notices: 00:01:00 •Journal entries: 00:07:00 •Schedule: 00:03:00 •AEO: 00:06:00 •Payroll run for Jan & Feb 2018: 00:13:00 •Leavers - p45: 00:03:00 •End of Year p60: 00:02:00 •Installing Brightpay: 00:13:00 •PAYE TAX: 00:13:00 •NI: 00:11:00 •Pensions: 00:06:00 •Online calculators: 00:07:00 •Payslips: 00:03:00 •Journal entries: 00:07:00 •Conclusion and Next Steps: 00:08:00

The Employee Management Course for HR Managers is a wonderful learning opportunity for anyone who has a passion for Leadership & Management and is interested in enjoying a long career in this relevant sector. It's also for anyone who is already a Human Resource (HR) Manager and looking to brush up their knowledge and boost their career with a recognised certification. This Employee Management Course for HR Managers course consists of several modules that takes around 2 hours to complete. The course is accompanied by instructional videos, helpful illustrations, how-to instructions and advice. The course is offered online at a very affordable price. That gives you the ability to study at your own pace in the comfort of your home. You can access the modules from anywhere and from any device. Why choose this course Earn an e-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 materials Mock exams Multiple-choice assessment Certification After the successful completion of the final assessment, you will receive a CPD-accredited certificate of achievement. The PDF certificate is for £9.99, and it will be sent to you immediately after through e-mail. You can get the hard copy for £15.99, which will reach your doorsteps by post. Course Content Employee Recruitment and Selection Procedure Employee Recruitment and Selection Procedure 00:12:00 Employee Training and Development Process Employee Training and Development Process 00:22:00 Performance Appraisal Management Performance Appraisal Management 00:19:00 Employee Relations Employee Relations 00:15:00 Motivation and Counselling Motivation and Counselling 00:19:00 Employee Termination Employee Termination 00:15:00 Employer Record and Statistics Employer Records and Statistics 00:11: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.

5 day live online class Total duration: 15 hours Classes run once a month from 18:30-21:30 GMT (13:30-14:30 EST) over a 5 day period

Highlights of the Course Course Type: Online Learning Duration: 55 minutes Tutor Support: Tutor support is included Customer Support: 24/7 customer support is available Quality Training: The course is designed by an industry expert Recognised Credential: Recognised and Valuable Certification Completion Certificate: Free Course Completion Certificate Included Instalment: 3 Installment Plan on checkout What you will learn from this course? Gain comprehensive knowledge about drug and alcohol awareness Understand the core competencies and principles of drug and alcohol awareness Explore the various areas of drug and alcohol awareness Know how to apply the skills you acquired from this course in a real-life context Become a confident and expert health and social care worker Drug & Alcohol Awareness This drug and alcohol awareness course is accredited by the CPD 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. This drug and alcohol awareness course is aimed at managers and staff in all industries who play a role in reducing drug, alcohol and substance misuse in the UK. The drug and alcohol awareness course starts with official statistics to illustrate the scale of drug and alcohol abuse in the UK. You'll learn in detail about commonly used drugs, including cannabis, cocaine, heroin, LSD, ecstasy and some new designer drugs. Turning to alcohol abuse, the course will show you how to introduce a 4-stage plan to deal with any problems - including how to write an effective Drug and Alcohol Policy. Beyond this the course will explore best business practice in terms of HR, legislation, spotting signs of drug misuse and the implementation of workplace solutions. The drug and alcohol awareness course also explains how the Advisory, Conciliation and Arbitration Service (ACAS) can help with effective alcohol and drugs policies and the development of related management skills. Finally, it looks at current drug treatments and the options for outside support available to individuals and organisations. Who is this Course for? This comprehensive Drug & Alcohol Awareness course is ideal for anyone wishing to boost their career profile or advance their career in this field by gaining a thorough understanding of the subject. Anyone willing to gain extensive knowledge on this drug and alcohol awareness can also take this course. Whether you are a complete beginner or an aspiring professional, this course will provide you with the necessary skills and professional competence, and open your doors to a wide number of professions within your chosen sector. Entry Requirements This Drug & Alcohol Awareness course has no academic prerequisites and is open to students from all academic disciplines. You will, however, need a laptop, desktop, tablet, or smartphone, as well as a reliable internet connection. Assessment This Drug & Alcohol Awareness 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 could grasp from each section. In the assessment pass mark is 60%. Advance Your Career This Drug & Alcohol Awareness course will provide you with a fresh opportunity to enter the relevant job market and choose your desired career path. Additionally, you will be able to advance your career, increase your level of competition in your chosen field, and highlight these skills on your resume. 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. Course Curriculum Module 1: Statistics and Signs of Misuse Module 2: Illegal Drugs Part 1 Module 3: Illegal Drugs Part 2 Module 4: Alcohol Misuse Module 5: Company Best Practice Part 1 Module 6: Company Best Practice Part 2 Module 7: Company Best Practice Part 3 Module 8: Drug Treatment Services and Further Support Obtain Your Certificate Order Your Certificate of Achievement 00:00:00

Business Networking 1 Day Training in Carlisle

Staying Human and Happy in a Virtual World How to stay human and happy in a virtual world...sounds catchy, right? Lets face it - while co-located, it is easier to connect with others. When dispersed, there needs to be a concerted effort towards team alignment and successful outcomes. A leader's responsibility is to provide structure, guidance, and a framework. However, studies show that the way you measure a healthy and happy work environment isn't the external governance guardrails, but it's around the motivation employees feel. If we can create environments that ensure our remote employees are engaged, confident, and motivated, we will increase our ability to be competitive and deliver successful outcomes to our customers. In our session, we will build a virtual house of team collaboration and discuss 5 foundational strategies, 6 core statistics, and 2 toolkits to help you and your teams stay human and happy in a virtual world. Key takeaways Learn how we each have an opportunity to influence talent retention in spite of physical location separation Understand the social and economic benefits of making an employee feel valued Practice activities that can be deployed to drive up retention & connectivity, while working remotely

Begin your machine learning journey by learning all about linear regression, logistic regression, and cluster analysis

Level 4 & 5 Endorsed Diploma | QLS Hard Copy Certificate Included | Plus 5 CPD Courses | Lifetime Access