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

389 Chartered Institute of Personnel Development (CIPD) courses

Certificate Course in Workforce Politics & Relations

4.3(43)

By John Academy

Description: Workplace politics is something that is disliked by many yet a necessary aspect of the business world. It is what connects people in the office and helps them go about. With the help of this Certificate Course in Workforce Politics & Relations course, you will be able to go beyond office politics and build your own philosophy. So what is workplace politics? Well with this course you will definitely find the answer and build on the works of Daniel Goleman with CASEL to see the affects of social and emotional competencies within the workplace. With the help of this course you can work beyond the politics. Learning Outcomes: Realise what Workplace politics is why it is not always negative Differentiate between formal and informal workplace hierarchies Apply pragmatic steps to neutralise the impact of rumours Provide a definition of Social and Emotional intelligence and their significance in exploring workplace politics Realise the worth of Self-Awareness in handling workplace politics and contemplate over your own power and competence Interpret the sphere of Self-Management at the workplace and learn to enhance Self-Management by means of reflection Realise the importance of Empathy, Organisational and Service Awareness at the workplace and social awareness skill improvement Recognise good relationship skills Look at the worth of responsible decision making and recognise decision traps that should be escape Produce your individual workplace Philosophy Statement 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? Certificate Course in Workforce Politics & Relations 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 Certificate Course in Workforce Politics & Relations 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. Course Overview 00:15:00 What is Workplace Politics? 00:15:00 Lessons from Social and Emotional Intelligence 00:30:00 Self-Awareness 00:15:00 Self-Management 00:15:00 Social Awareness 00:15:00 Good Relationship Skills 00:30:00 Responsible Decision Making 00:30:00 Creating Your Workplace Philosophy 00:05:00 Mock Exam Mock Exam- Certificate Course in Workforce Politics & Relations 00:20:00 Final Exam Final Exam- Certificate Course in Workforce Politics & Relations 00:20:00 Order Your Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Certificate Course in Workforce Politics & Relations
Delivered Online On Demand3 hours 30 minutes
£18

Human Resource Management: Building a Strong Workforce

5.0(2)

By Institute of Beauty & Makeup

CPD Accredited | Career Oriented Learning Modules | 24x7 Tutor Support | Lifetime Access

Human Resource Management: Building a Strong Workforce
Delivered Online On Demand1 hour
£12

Adventures in Excel

By Ideas Into Action

Description Microsoft Excel has hundreds, if not thousands, of functions and features. This course aims to cover some of the best – that is the ones I find most useful. In “Adventures in Excel”, I cover the simple-to-use but powerful functions that I use most often: Basic features including products and powers Key date functions including the calculation of due dates and days past due Generating random numbers and random dates The new IFS functions (new to Office365) Text functions The most useful logical functions and IS functions How to create a drop-down list The new XLOOKUP function Pivot tables   These functions are easy to use, and, unless your role is extremely specialised, they are probably the ones you’ll use 90% of the time. I hope you find the course helpful.   Learning Outcomes Participants in this course will learn: Basic Excel functions including SUM, AVERAGE, MIN, MAX, PRODUCT, POWER and SQRT Useful date functions including TODAY, EOMONTH, EDATE, and DAYS Generating random numbers using RAND and RANDBETWEEN; generating random dates; and randomly picking an item from a list or table The new RANDARRAY function in Office365 The new IFS functions in Office365 including AVERAGEIFS, MAXIFS, MINIFS, COUNTIFS, and SUMIFS Text functions including TRIM, LOWER, UPPER, PROPER, LEFT, MID, RIGHT, FIND, TEXTJOIN and CONCATENATE Logical functions AND, OR, and NOT and IS functions ISTEXT, ISNUMBER, ISBLANK and ISERROR How to create a drop-down list The new SORT and FILTER functions in Office365 VLOOKUP and the new XLOOKUP function How to create a Pivot table and analyse data with one     Course Requirements There are no pre-course requirements.   Additional Resources Course Spreadsheet with the examples covered.     About Ross Ross Maynard is a Fellow of the Chartered Institute of Management Accountants in the UK. He is director of Ideas2Action Process Excellence Ltd and has 30 years’ experience as a process improvement consultant and facilitator. Ross is also a professional author of online training courses for accountants. Ross lives in Scotland with his wife, daughter and Cocker Spaniel

Adventures in Excel
Delivered Online On Demand
£4.99

HR, Payroll,Paye, Tax Professional Diploma

5.0(10)

By Apex Learning

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

HR, Payroll,Paye, Tax Professional Diploma
Delivered Online On Demand12 hours 12 minutes
£12

HR Practice and Employee Development Training

4.5(3)

By Studyhub UK

Embark on a transformative journey with 'HR Practice and Employee Development Training', designed to instil in you the ethos of Human Resource (HR) mastery. From the fundamentals of HR to the intricacies of performance appraisals, every module is tailored to offer you a holistic grasp of employee lifecycle management. Whether you're keen on mastering the art of effective administration, or eager to foster an environment prioritising health and safety, this course paves the way for you to excel in the multifaceted realm of HR. Learning Outcomes Acquire a comprehensive understanding of the core principles of Human Resource. Master the strategies for effective employee recruitment, selection, and training. Hone skills in performance appraisal, ensuring fair and consistent evaluations. Understand the significance of employee relations, motivation, and workplace safety. Develop proficiency in business communication, etiquette, and representing the organisation. Why choose this HR Practice and Employee Development Training course? Unlimited access to the course for a lifetime. Opportunity to earn a certificate accredited by the CPD Quality Standards after completing this course. Structured lesson planning in line with industry standards. Immerse yourself in innovative and captivating course materials and activities. Assessments are designed to evaluate advanced cognitive abilities and skill proficiency. Flexibility to complete the HR Practice and Employee Development Training Course at your own pace, on your own schedule. Receive full tutor support throughout the week, from Monday to Friday, to enhance your learning experience. Who is this HR Practice and Employee Development Training course for? Individuals aspiring to venture into the HR domain. Managers seeking to enhance their employee management strategies. Administrators aiming to boost their organisational skills. Entrepreneurs wanting to foster a conducive workplace environment. HR professionals striving for continuous development in their field. Career path HR Manager: £30,000 - £60,000 Employee Development Specialist: £25,000 - £50,000 Recruitment Consultant: £22,000 - £40,000 Performance Appraisal Analyst: £28,000 - £52,000 Employee Relations Advisor: £27,000 - £49,000 Workplace Health and Safety Coordinator: £24,000 - £47,000 Prerequisites This HR Practice and Employee Development Training does not require you to have any prior qualifications or experience. You can just enrol and start learning.This HR Practice and Employee Development Training 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. Certification After studying the course materials, there will be a written assignment test which you can take at the end of the course. After successfully passing the test you will be able to claim the pdf certificate for £4.99 Original Hard Copy certificates need to be ordered at an additional cost of £8. Course Curriculum Module 1: Introduction to Human Resource Module 01: Introduction to Human Resource 00:17:00 Module 2:Employee Recruitment and Selection Procedure Module 02: Employee Recruitment and Selection Procedure 00:32:00 Module 3: Skills of an Effective Administrator Module 03: Skills of an Effective Administrator 00:17:00 Module 4: Employee Training and Development Process Module 03: Employee Training and Development Process 00:22:00 Module 5: Performance Appraisal Management Module 05: Performance Appraisal Management 00:19:00 Module 6: Employee Relations Module 06: Employee Relations 00:14:00 Module 7: Motivation and Counselling Module 07: Motivation and Counselling 00:19:00 Module 8: Ensuring Health and safety at the Workplace Module 08: Ensuring Health and safety at the Workplace 00:17:00 Module 9: Employee Termination Module 09: Employee Termination 00:15:00 Module 10: Business Etiquette Module 10: Business Etiquette 00:21:00 Module 11: Employer Record and Statistics Module 11: Employer Record and Statistics 00:11:00 Module 12: Business Telephone Skills Module 12: Business Telephone Skills 00:21:00 Module 13: Representing Your Boss and Company Module 13: Representing Your Boss and Company 00:36:00 Mock Exam Mock Exam - HR Practice and Employee Development Training 00:20:00 Final Exam Final Exam - HR Practice and Employee Development Training 00:20:00

HR Practice and Employee Development Training
Delivered Online On Demand5 hours 1 minutes
£10.99

Certified Diploma in HR Assistant

3.0(2)

By Alpha Academy

Become a successful certified HR Assistant with this comprehensive Certified Diploma in HR Assistant course. This course is designed for those aspiring individuals or professionals who want to gain hr assistant skills to build their successful career in the Human resource management field. In this HR assistant course you will learn the procedures of attracting and retaining employees, the proper ways of training and development, and the legal environment of HRM. Apart from these, you will gain information related to contemporary motivation theory and techniques and teamwork. The course starts with the basic HR concepts and the exact ways of recruitment which includes how to select the perfect employee, the appropriate system of orientation and the strategy of developing personal and professional development. After that, you will learn how to motivate the employee through different motivational techniques, how to praise them or how to make constructive criticism. Finally, you will learn how to do teamwork. After successful completion of this course you will gain a complete idea about HR management, and can successfully implement HR strategies and key concepts in real life to enhance the business operation through effective HR management. Course Highlights The price is for the whole course including final exam - no hidden fees Accredited Certificate upon successful completion at an additional cost Efficient exam system with instant results Track progress within own personal learning portal 24/7 customer support via live chat Certified Diploma in HR Assistant has been given CPD accreditation and is one of the best-selling courses available to students worldwide. This valuable course is suitable for anyone interested in working in this sector or who simply wants to learn more about the topic. If you're an individual looking to excel within this field then Certified Diploma in HR Assistant is for you. We've taken this comprehensive course and broken it down into several manageable modules which we believe will assist you to easily grasp each concept - from the fundamental to the most advanced aspects of the course. It really is a sure pathway to success. All our courses offer 12 months access and are designed to be studied at your own pace so you can take as much or as little time as you need to complete and gain the full CPD accredited qualification. And, there are no hidden fees or exam charges. We pride ourselves on having friendly and experienced instructors who provide full weekday support and are ready to help with any of your queries. So, if you need help, just drop them an email and await a speedy response. Furthermore, you can check the validity of your qualification and verify your certification on our website at anytime. So, why not improve your chances of gaining professional skills and better earning potential. Assessment and Certification At the end of the course, you will be required to sit an online multiple-choice test. Your test will be assessed automatically and immediately so that you will instantly know whether you have been successful. After you have successfully passed the final exam, you will be able to order an Accredited Certificate of Achievement at an additional cost of £19 for a PDF copy and £29 for an original print copy sent to you by post or for both £39. Career Path Not only does our CPD and CiQ accredited course look good on your CV, setting you apart from the competition, it can be used as a stepping stone to greater things. Further advance your learning, launch a new career or reinvigorate an existing one. On successful completion of this course, you have the potential to achieve an estimated salary of £22,000. The sky really is the limit. Course Curriculum Human Resources Assistant Introduction Human Resources Assistant 00:10:00 Potential Careers 00:05:00 Attracting and Retaining Employees HRM Overview 00:13:00 Forecasting Demand 00:10:00 Cultural Diversity 00:11:00 Diversity Survey 00:09:00 Recruiting, Selection, and Orientation Job Analysis 00:10:00 Application 00:20:00 Bad Resume 00:05:00 Good Resume 00:12:00 Cover Letter 00:10:00 Selection 00:11:00 Form I-9 00:17:00 Form W-9 00:07:00 Form W-4 00:10:00 Form 1095-B 00:07:00 Compensation and Benefits 00:17:00 Training and Development Personal and Professional Development 00:14:00 Training Evaluation Form 00:12:00 Performance Appraisal Performance Appraisal 00:19:00 Appraisal 00:14:00 Legal Environment of HRM National Labor Relations Act 00:12:00 Labor-Management Relations Act 00:14:00 Occupational Safety and Health Act 00:13:00 Motivating Employees Motivation 00:17:00 Physiological Needs 00:16:00 Motivation-Hygiene Theory 00:12:00 Firm Characteristics 00:22:00 Contemporary Motivation Theory Weakness of Maslow and Herzberg's Theories 00:18:00 Expectancy Theory 00:13:00 Motivation Techniques Management by Objectives 00:17:00 Behavior Modification 00:19:00 Telecommuting 00:20:00 Teams and Teamwork What is a Team? 00:09:00 Stages of Development 00:06:00 Team Cohesiveness 00:09:00 Mock Exam Mock Exam- Certified Diploma in HR Assistant 00:20:00 Final Exam Final Exam- Certified Diploma in HR Assistant 00:20:00

Certified Diploma in HR Assistant
Delivered Online On Demand
£10.99

Disciplinary Procedures

By Study Plex

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: Disciplinary Procedure and Confidentiality Module 2: Investigations, Allegations and Suspensions Module 3: Notification Of A Hearing, The Right To Be Accompanied, And Procedure Module 4: Penalties, Their Effects, And Appeals Module 5: Holding Disciplinary Hearings And A Case Study Obtain Your Certificate Order Your Certificate of Achievement 00:00:00

Disciplinary Procedures
Delivered Online On Demand
£19

HR Business Partner Skills

4.7(26)

By Academy for Health and Fitness

48-Hour Knowledge Knockdown! Prices Reduced Like Never Before! An organisation usually benefit greatly from having human resources. Over the past 20 years, the profession has seen substantial development. In addition to handling various tasks related to an employee's life cycle, today's HR professionals are also expected to operate as business leaders who can steer a firm through and around a constantly shifting economic landscape. You have come to the perfect spot if you're looking to learn more about the HR field. We provide a thorough HR Business Partner course that covers practically all of the information you want. In this course, you will start by getting an introduction to the human resources sector. The opening will be followed by information on employee recruitment and selection procedures, as you will be employing employees with the appropriate abilities and expertise. You will also be in charge of assisting in the provision of training and development opportunities for staff, which is why we have included a segment on the employee training and development process. In addition, we will discuss the fundamentals of operations management, business process management, communicational skills, organisational skills, and many other essential topics. Because of the immense value that HR experts bring to organisations, they will always be in demand. Good HR professionals are excellent multitaskers and have good organisational skills. If you want to succeed in this field, you must be excellent at customer communication, paying attention to company demands, and achieving results which will be easier for you through our course. Seize the opportunity and enrol right away! Learning Outcomes of HR Business Partner Skills: Upon successful completion of this HR Business Partner course, you will be able to, Get an insight into the basics of human resources. Recognise the importance of employee recruitment and selection procedure. Determine the core concepts of employee training and development process. Learn to maintain employment records and statistics. Improve your understanding of operations management and business process management. Gain a thorough grasp of motivation and counselling. Why Prefer Us? Opportunity to earn a certificate accredited by CPDQS. Get a free student ID card!(£10 postal charge will be applicable for international delivery) Innovative and Engaging Content. Free Assessments 24/7 Tutor Support. Take a step toward a brighter future! *** Course Curriculum *** Here is the curriculum breakdown of the HR Business Partner course: HR Business Partner Course Module 01: Introduction to Human Resource Module 02:Employee Recruitment and Selection Procedure Module 03: Employee Training and Development Process Module 04: Ensuring Health and safety at the Workplace Module 05: Introduction to Business Management Module 06: Operations Management Module 07: Business Development and Succession Planning Module 08: Business Process Management Module 09: Communication Skills Module 10: Business Environment Module 11: Organisational Skills Module 12: Motivation and Counselling Module 13: Conflict Management Assessment Process Once you have completed all the modules in the HR Business Partner course, you can assess your skills and knowledge with an optional assignment. Certificate of Completion The learners have to complete the assessment of this HR Business Partner course to achieve the CPDQS accredited certificate. Digital Certificate: £10 Hard Copy Certificate: £29 (Inside UK) Hard Copy Certificate: £39 (for international students) CPD 10 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Professionals in human resources management who are interested in learning more about their division. Individuals with a desire to learn more about human resource management. Requirements You will not need any prior background or expertise to enrol in this course. Career path The following professions might benefit from having the HR Business Partner course: Human Resource Manager Hiring Manager Relations Manager Human Resource Executive The typical annual income for these occupations in the UK is between £25,000 and £60,000. Certificates CPD Accredited Certificate Digital certificate - £10 CPD Accredited Certificate Hard copy certificate - £29 If you are an international student, then you have to pay an additional 10 GBP as an international delivery charge.

HR Business Partner Skills
Delivered Online On Demand6 hours
£12

Communications Officer

4.7(26)

By Academy for Health and Fitness

48-Hour Knowledge Knockdown! Prices Reduced Like Never Before! Communicating with people is the easiest way to exchange views and thoughts. But unfortunately, we often make mistakes by miscommunicating with people knowing or unknowingly, which may lead us to inappropriate situations. Whether you are a professional or not, intending to make you a better communicator by developing your skills and approach, we have prepared this easily accessible Communications Officer course. The course will surely enhance your expertise. Furthermore, it will boost your knowledge of how to communicate effectively and help you be aware of every situation when communicating with people. The contents of this course are prepared to provide the best possible learning experience to our learners after considering the best possible learning outcome and by taking the views of experts from relevant fields. If you are willing to learn new communication skills and looking for a reliable organisation, then we are here to help with our Communications Officer course. So take this course and be noticed through your communication skills! Learning Outcome Take our Communications Officer course, and you will learn about the following: Fundamental concepts of being a Communication Officer Process of managing Public Relations from and with organisations and people Importance and systematic approach of public speaking Implementation of new criteria and cross-cultural development procedures Management of cultural activities and internal issues Vital decision-making tips with complete guidelines for being a Communications Officer Why Prefer Us? Opportunity to earn a certificate accredited by CPDQS. Get a free student ID card!(£10 postal charge will be applicable for international delivery) Innovative and Engaging Content. Free Assessments 24/7 Tutor Support. Take a step toward a brighter future! *** Course Curriculum *** Here is the curriculum breakdown of the Communications Officer course: Module 01: Introduction to Public Relations Module 02: Concepts of Public Relations Module 03: Management and Organisation of Public Relations Module 04: Public Relations Tactics and Research Module 05: Major Fields of Public Relations Practice Part I Module 06: Major Fields of Public Relations Practice Part II Module 07: Social Media and PR Module 08: Public Speaking Module 09: Power of Storytelling Module 10: Becoming an Influencer Module 11: Importance of Body Language Module 12: Implementing CSR Module 13: Performance Evaluation and Performance Reporting Module 14: Cross-Cultural Awareness Module 15: Cross-Cultural Communication Module 16: Corporate Cross-Cultural Awareness Module 17: Cultural Values Module 18: Working with and Managing a Culturally Diverse Team Module 19: Defamation Module 20: Crisis management Module 21: Media Regulatory Bodies Module 22: Ethics & Professionalism in Public Relations Module 23: Decision Making with Critical Thinking Assessment Process Once you have completed all the modules in the Communications Officer course, you can assess your skills and knowledge with an optional assignment. Certificate of Completion The learners have to complete the assessment of this Communications Officer course to achieve the CPDQS accredited certificate. Digital Certificate: £10 Hard Copy Certificate: £29 (Inside UK) Hard Copy Certificate: £39 (for international students) CPD 10 CPD hours / points Accredited by CPD Quality Standards Who is this course for? This Communication Officer course is open to everyone. This training is ideal for the following- Communications Officer Product & Brand Communications Manager Communications & Marketing Officer Marketing Communications Specialist Head of Digital Communications Anyone who wants to be a better Communicator Requirements You will not need any prior background or expertise to enrol in this course. Career path Communications Officer (£19,000- £31,000 per annum) Public relations officer (£18,000 to £50,000 per annum) PR Coordinator ( £16,000- £30000 per annum) Police community support officer (£19,000-£26,000) Communications Manager (£25,000-£35,900 per annum) Education welfare officer (£19,000- £27,000 per annum) Certificates CPD Accredited Certificate Digital certificate - £10 CPD Accredited Certificate Hard copy certificate - £29 If you are an international student, then you have to pay an additional 10 GBP as an international delivery charge.

Communications Officer
Delivered Online On Demand9 hours
£12

New Excel Functions

By Ideas Into Action

New Excel Functions   Course Description   Ross Maynard     Description In the second half of 2020 Microsoft released a significant upgrade to the most used spreadsheet programme in the world. Microsoft Excel now offers the ability to handle dynamic arrays – functions that return a range of results that update as the source data changes. In this course, we discuss the power of dynamic arrays and introduce the new functions. The functions I am going to cover are: RANDARRAY- creating a table of random numbers or random dates UNIQUE – identifying the distinct items in a list SEQUENCE – listing numbers with a set interval SORT and SORTBY – new ways of dynamically sorting data FILTER – building the ability to filter data into formulae XLOOKUP – replacing VLOOKUP with greater flexibility IFS and SWITCH making it easier to construct IF statements The new CONCAT, and TEXTJOIN text functions   If you have an earlier version of Microsoft Excel then these functions will not be available to you and this course might not be for you. But if you do have a subscription to Office365 – either personally or through your work – I think you will find this course extremely useful.         Learning Outcomes Participants in this course will learn: What the new dynamic arrays feature in Microsoft Excel means How the new RANDARRAY function works How the new UNIQUE function works How the new SEQUENCE function works How the new SORT and SORTBY functions work How the new FILTER function works How the new XLOOKUP function can replace VLOOKUP How to build IF statements with the new IFS function How the new SWITCH function works How the new TEXTJOIN function can replace CONCATENATE and CONCAT How the new functions can be used in management reporting     Course Requirements There are no pre-course requirements.   Additional Resources Course Spreadsheet with the examples covered.       About Ross Ross Maynard is a Fellow of the Chartered Institute of Management Accountants in the UK. He is director of Ideas2Action Process Excellence Ltd and has 30 years’ experience as a process improvement consultant and facilitator. Ross is also a professional author of online training courses for accountants. Ross lives in Scotland with his wife, daughter and Cocker Spaniel

New Excel Functions
Delivered Online On Demand
£4.61