17060 Other courses delivered Online

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

Explore endless possibilities and achieve tangible results with our wide range of online courses, prepared to suit every interest and skill level. Each course is thoughtfully designed for flexibility and useful application, ensuring you can learn and grow at your own pace from anywhere and transform your talents to accomplish your goals. Whether you're advancing your career, pursuing a passion, or seeking new opportunities, our courses will assist you in reaching your goals. Our HR Project Manager package, with the latest digital study materials and innovative learning methods, will give you in-depth knowledge of this domain. As an HR Project Manager, you have endless opportunities if you have the right knowledge and skills. Therefore, to make your career journey successful, we designed this bundle as a one-stop solution for you. Join us today and take the next step in your personal and professional journey with confidence and convenience. Start shaping your future now. Moreover, you will keep yourself up to date with the current situation in the area of your interest. This 20-in-1 Ultimate HR Project Manager bundle consists of the following Courses: Course 01: HR Management Course 02: HR Virtual Interview Techniques Course 03: Managing Online Meetings Course 04: Decision-Making in High Stress Course 05: Supporting a Grieving Employee Course 06: Working from Home Essentials Course 07: HR Crisis Communication Training Course 08: Employment Law for HR Course 09: Operations Management Course 10: Emotional Intelligence and Human Behaviour Course 11: Administrative Management Course 12: Managing Budgets Course 13: Business Analysis Course 14: Business Ethics for the Office Course 15: Diploma in Management Skills Course 16: Goal Setting & Accomplishment Course 17: Team Management Advanced Training Course 18: Talent Management Course 19: Creative Thinking and Innovation Course 20: Ethical Leadership Principles Additionally, you will get 5 other career-guided courses in this HR Project Manager bundle: 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 So, stop scrolling down and enrol in this HR Project Manager bundle to procure the skills and aptitude with Apex Learning to outshine all your peers. Learning Outcomes of HR Project Manager Bundle This career-oriented bundle will help you to Gain the ability to excel in the role of HR Project Manager Know your responsibilities as HR Project Manager and convey your experience to others Gain excellent interpersonal and communication skills Know the pros and cons of working as an HR Project Manager Adhere to the regulations around this area Gain time and risk management skills to ensure efficiency Manipulate technological advancement to become more effective Maintain moral standards and set an example for your peers CPD 250 CPD hours/points Accredited by CPD Quality Standards Who is this course for? Anyone from any background can enrol in this HR Project Manager bundle. Requirements This HR Project Manager course has been designed to be fully compatible with tablets and smartphones. Career path Having this expertise will increase the value of 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 (HR Management) for absolutely free! Other Hard Copy certificates are available for £10 each. Please Note: The delivery charge inside the UK is £3.99, and the international students must pay a £9.99 shipping cost.

Do you know, Employment of lawyers is projected to grow 6% from 2018 to 2028, as fast as the average for all occupations? So this is the perfect time to dive into this sector. However, our course is an excellent way to learn about the legal aspects of employment, family law, and other areas of law. We designed this course to provide you with the fundamentals of the legal system, the various types of employment law, the various types of family law, the criminal justice system, and other areas of law. You will also be able to learn about various types of legal arguments and research methods. Further from this course, you'll learn about the various types of Employment contracts, the various types of Employment discrimination, and the various types of Employment benefits. When it comes to criminal justice, you'll learn about the different types of criminal offences, their penalties, and criminal proceedings. By taking our course, you will be able to gain a better understanding of the legal system and the different types of laws that govern various aspects of our society. You will also gain a thorough understanding of employment, family, and criminal justice laws. This knowledge can be extremely useful if you want to enter the legal profession. Along with this Law course, you will get 10 premium courses, an original hardcopy, 11 PDF certificates (Main Course + Additional Courses) Student ID card as gifts. This Bundle Consists of the following Premium courses: Course 01: English Law and Legal System Level 3 Course 02: Understanding Wills and Probate Laws - Level 2 Course 03: UK Employment Law and Employee Rights Diploma Course 04: Family Law 2021 Course 05: Criminology Law and Psychology Course 06: GDPR Data Protection Level 5 Course 07: Contract Manager Diploma Course 08: Anti Money Laundering (AML) Regulation for AML Officers Diploma Course 09: COSHH Awareness Level 3 Course 10: Mental Health Laws and Awareness - Level 2 Course 11: Stress Management Training Learning Outcomes Recognise the legal ramifications of Employment Law to Family Law. Learn various laws that govern Employment and Family Law. Assess the Employment Law policies, procedures, and legal implications concerning Family Law. Create strategies for effectively addressing Employment Law issues in the context of Family Law. Analyse and interpret Employment and Family Law case studies. Use legal reasoning to evaluate the impact of Employment and Family Law. Enrol now to advance your career, and use the premium study materials from Apex Learning. The bundle incorporates basic to advanced level skills to shed some light on your way and boost your career. Hence, you can strengthen your Law expertise and essential knowledge, which will assist you in reaching your goal. Moreover, you can learn from any place in your own time without travelling for classes. Certificate: PDF Certificate: Free (Previously it was £6*11 = £66) Hard Copy Certificate: Free (For The Title Course: Previously it was £10) CPD 110 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Anyone interested in studying and understanding the law. This includes those who are considering careers in law, such as lawyers, legal assistants, paralegals, and other legal professionals, as well as those who are simply interested in learning more about the legal system. Requirements This course has been designed to be fully compatible with tablets and smartphones. Career path The following professions are most familiar in this sector Attorney Judge Paralegal Legal Secretary Legal Analyst In general, these professions typically earn between £30,000 and £50,000 per year in the UK Certificates Certificate of completion Digital certificate - Included

In the UK there are approximately 144 fatalities in the workplace and around 621,000 non-fatal injuries every year. Personal Protective Equipment (PPE) plays a vital role in managing Health & Safety risks. However, historical data shows many workers suffering injury were not wearing this clothing. This course will show how wearing PPE plays a crucial role in preventing and reducing fatalities, injuries and diseases that would otherwise occur in the workplace. It includes details of a wide range of PPE options, examines the legislation and regulations that govern the responsibilities of employers, employees and suppliers, and provides a real-life case study showing the law in action. The course will also cover risk assessment and the role it plays in the selection and use of PPE along with discussing other hazard control measures that can be implemented. Finally, the course will move on to how to use, fit and wear PPE and understand its physical and theoretical limitation

In this competitive job market, you need to have some specific skills and knowledge to start your career and establish your position. This Fundamentals of English for Beginners course will help you understand the current demands, trends and skills in the sector. The course will provide you with the essential skills you need to boost your career growth in no time. The Fundamentals of English for Beginners course will give you clear insight and understanding about your roles and responsibilities, job perspective and future opportunities in this field. You will be familiarised with various actionable techniques, career mindset, regulations and how to work efficiently. This course is designed to provide an introduction to Fundamentals of English for Beginners and offers an excellent way to gain the vital skills and confidence to work toward a successful career. It also provides access to proven educational knowledge about the subject and will support those wanting to attain personal goals in this area. Who is this Course for? Whether you are a beginner or an existing practitioner, our CPD accredited Fundamentals of English for Beginners course is perfect for you to gain extensive knowledge about different aspects of the relevant industry to hone your skill further. It is also great for working professionals who have acquired practical experience but require theoretical knowledge with a credential to support their skill, as we offer CPD accredited certification to boost up your resume and promotion prospects. Entry Requirement Anyone interested in learning more about this subject should take this Fundamentals of English for Beginners course. This course will help you grasp the basic concepts as well as develop a thorough understanding of the subject. The course is open to students from any academic background, as there is no prerequisites to enrol on this course. The course materials are accessible from an internet enabled device at anytime of the day. CPD Certificate from Course Gate At the successful completion of the course, you can obtain your CPD certificate from us. You can order the PDF certificate for £4.99 and the hard copy for £9.99. Also, you can order both PDF and hardcopy certificates for £12.99. Career path The Fundamentals of English for Beginners will help you to enhance your knowledge and skill in this sector. After accomplishing this course, you will enrich and improve yourself and brighten up your career in the relevant job market. Course Curriculum Section 01: Introduction Introduction 00:06:00 Section 02: Basics of English Language The Alphabet 00:09:00 The Alphabet (Special Letter Y) 00:03:00 Basic Structure of Sentences in English 00:10:00 Numbers 00:13:00 Time and Dates 00:08:00 Nouns 00:04:00 Pronouns 00:05:00 Verbs 00:06:00 Adjectives 00:04:00 Adverbs 00:05:00 Prepositions 00:04:00 Conjunctions 00:16:00 Interjections 00:04:00 Articles 00:05:00 List of Basic Words in English 00:06:00 Section 03: Basic Grammar Lessons Singular and Plural Nouns 00:07:00 Count and Non-Count Nouns 00:02:00 Possessive Nouns 00:06:00 Pronouns (Detailed) 00:08:00 Action Verbs 00:07:00 Adjectives (Detailed) 00:08:00 Comparative and Superlative Adjectives 00:09:00 Adverbs (Detailed) 00:06:00 Verb Tenses and Irregular Verbs 00:13:00 Gerunds 00:05:00 Infinitives 00:09:00 Active and Passive Voice 00:07:00 Conditionals 00:06:00 Direct and Indirect Speech 00:08:00 Prepositions (Detailed) 00:23:00 Phrases and Idioms 00:04:00 Auxiliary Verbs 00:20:00 Either and Neither 00:07:00 Indicative, Imperative, Subjunctive Mood 00:04:00 Section 04: Punctuation Rules Full Stop - Period 00:09:00 Comma 00:08:00 Question Mark 00:02:00 Exclamation Mark 00:03:00 Colon 00:06:00 Semicolon 00:07:00 Apostrophe 00:08:00 Hyphen & Dash 00:10:00 Quotation Marks 00:04:00 Parentheses & Brackets 00:06:00 Ellipsis 00:05:00 Asterisk 00:04:00 Section 05: Final Section Final Lecture 00:06:00 Certificate and Transcript Order Your Certificates or Transcripts 00:00:00

The Microsoft Certified Expert is a new breed of Microsoft certification. It is referred to as a ‘role-based certification’. According to Microsoft, role-based certifications show that individuals that possess them are keeping pace with today’s technical roles and requirements. They allow a learner to skill up and prove their expertise to employers and peers, plus get the recognition and opportunities they’ve earned.

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 Nail Technician & Beauty Therapy 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 Nail Technician & Beauty Therapy will help you keep ahead of the pack. The Nail Technician & Beauty Therapy 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 Nail Technician & Beauty Therapy 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 Nail Technician & Beauty Therapy, you can equip yourself with the essentials to keep you afloat into the competition. Along with this Nail Technician & Beauty Therapy 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. This Nail Technician & Beauty Therapy Bundle Consists of the following Premium courses: Course 01: Online Nail Technician Diploma Course 02: Beauty Therapist Level 3 Training Course Course 03: Skin Care Treatment Course 04: Bridal and Occasional Makeup Artist Masterclass Course 05: Makeup Artistry Course Course 06: Brow Lamination and Lash Lift, Brow Tint and Lash Tint Course 07: Manicure and Pedicure Course 08: Hairdressing Level 3 Course 09: Aging and Longevity Secrets Course 10: Nutrition and Hydration Course 11: Personal Hygiene So, enrol now to advance your career! The bundle incorporates basic to advanced level skills to shed some light on your way and boost your career. Hence, you can strengthen your expertise and essential knowledge, which will assist you in reaching your goal. Certificate: PDF Certificate: Free (Previously it was £6*11 = £66) Hard Copy Certificate: Free (For The Title Course: Previously it was £10) CPD 115 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Anyone from any background can enrol in this Nail Technician & Beauty Therapy bundle. Requirements Our Nail Technician & Beauty Therapy is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. 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 (Online Nail Technician Diploma) absolutely Free! Other Hard Copy certificates are available for £10 each. Please Note: The delivery charge inside the UK is £3.99, and the international students must pay a £9.99 shipping cost.

This First Aid for Sports course covers the full Emergency First Aid at Work syllabus, adapted for sports. It is ideal for Sports Teachers, Personal Trainers, Coaches, Yoga and Pilates Teachers, cricket, football, rugby, hockey, tennis and any other sports - to equip you with vital skills and confidence to help an adult or child experiencing a medical emergency in a sports environment. Prompt and appropriate First Aid reduces the pain and suffering experienced by a casualty and could save their life. This course covers CPR, choking, bleeding, burns, spinal injuries, asthma, bites and stings and so much more. The First Aid for Sports Course fulfils all the criteria for Appointed Person first aid training, however a practical course is required in order to be a full First Aider. This course is an excellent first aid training package for people to gain invaluable knowledge at their own time and pace and a great first aid training package for those with English as a second language to prepare themselves to pass a practical first aid course. The content also serves as an ideal annual refresher covering the full HSE syllabus The course consists of illustrated step by step directions, flow charts, diagrams, videos and test yourself sections fully compatible with all computers and mobile devices. You will be able to stop and start as often as you like and print your Certificate on completion. You have continuous access to this course for 12 months. It is impossible to cover all eventualities within this course, or to equip you with the knowledge and skills to appropriately diagnose and treat in unpredictable real life situations. If you suspect serious illness or injury, you should always seek immediate professional medical advice. The author has made every effort to ensure the accuracy of the information contained within the course, however this course is merely a guide and the author does not accept any liability or responsibility for any inaccuracies or for any mistreatment or misdiagnosis of any person, however caused. The course material has been written by Emma Hammett, qualified nurse, first aid trainer and founder of First Aid for Life in conjunction with other medical and first aid professionals. If you have any queries concerning this course, please contact emma@firstaidforlife.org.uk Course contents: Action in an emergency Unresponsive and breathing Recovery position Secondary survey Unconscious and not breathing Resuscitation Heart attack and angina Choking Drowning Anaphylactic shock Wounds and bleeding Dressings Fainting Burns (including sunburn) Dislocation Bandaging Head injuries Skull fracture Spinal injuries Log rolling someone into recovery position Fitting/seizures/convulsions

CPD certified, digital study session, 24-hour postural care training, learning new ways to bring excellence to 24-postural care, focussing on supported lying.

Microsoft Excel Advanced Course Please Note: This course uses the Windows version of Microsoft Office 2016. Any other versions will have some differences in the functions. The Microsoft (MS) Excel Certification Level 3 Course is the most comprehensive of the three Excel courses presented here. If a team member has successfully completed the Level 1 and Level 2 courses, they will be fully prepared to start the Level 3 course. Formulae or functions are what advanced users of Excel want from this tool. When you use formulae, not only can you see the data that you require for your work, you can also analyse it and get answers to complex questions. Although anyone with some Excel knowledge can use formulae, such as SUM, a user who has the advanced Excel skills presented in this course will use other formulae, both alone and combined, such as MATCH, INDEX, DSUM and VLOOKUP. In addition to knowing and using these formulae, an advanced user of Excel knows how to debug these formulae, how to audit them and how to choose the perfect formula for the particular task to be carried out.   What's Covered in the Course? Any staff member choosing to study this course can expect to gain the following skills: How to set A Password to an Excel document; VLOOKUP Advanced formula options and manipulations; Other advanced functions: OR, AND, CHOOSE, INDIRECT, REPLACE, LEN, LEFT, FIND; Functions of CEILING, CORREL, DATEDIF, DATEVALUE, DAVERAGE and EDATE; Colouring a column and row with a formula; Highlighting a cell with a formula; Functions of ISODD, ISNUMBER, ISTEXT, ISLOGICAL, ISNONTEXT, ISERR and ISBLANK; Functions of DGET, DMAX, DPRODUCT, DCOUNTA, DCOUNT and DSUM; How to calculate depreciation in Excel, including SLN depreciation and SYD depreciation; Calculating loan IPMT and EMI; Functions of DATEDIF, DATEVALUE, EDATE, EOMONTH, MATCH and INDEX; Full explanation of the INDEX and MATCH functions; Looking up data; Selecting only cells containing comments; Hiding formulae; Automatically inserting serial numbers;   The employee will also learn about calculating depreciation, calculating interest and calculating IPMT and EMI for loans, all by using Excel functions. The course features information on INDEX and MATCH functions, which is important in certain industries and roles. It also shows learners how to use the CHOOSE formula and how to create special charts. What are the Benefits of the Course? Upon completion of the Level 3 course, the employee will have access to the full functionality of Excel and will know how to use all of its formulae, functions and capabilities; The Level 3 Excel course is designed for 'power' users, but not only for programmers and those interested in financial modelling; Competent Excel users add huge value to an organisation, through advanced data analysis.