10253 Office courses

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

Course Description: Become equipped to handle workplace emergencies with our Level 3 Award in Emergency First Aid at Work (RQF) Course. This comprehensive training covers various first aid scenarios, empowering participants to qualify as Emergency First Aiders and fulfil the statutory requirements of the Health and Safety (First Aid) Regulations 1981. Recognized by OFQUAL at level 3, this course prepares learners to administer crucial first-aid interventions in the workplace. Learning Outcome: Upon completion of the course, participants will master key first-aid techniques, including: Prioritizing first aid incidents Administering CPR and resuscitation Managing bleeding, shock, and minor injuries Conducting casualty examinations Providing adults with basic life support Addressing strains, sprains, burns, and suspected spinal injuries Understanding responsibilities and reporting protocols Maintaining and utilizing first aid kits Handling head injuries and concussion return-to-play protocols Course Audience: Ideal for individuals with specific responsibilities to provide first aid at work or in voluntary/community activities. Our industry-specific emergency first aid at work courses cater to various sectors, including transport, security, catering, construction, office environments, supermarkets, and entertainment venues. Assessment and Re-qualification: Participants, aged at least 14 years, must communicate effectively in English. The course involves practical activities and ongoing assessment. Certification is awarded upon meeting the criteria. Typically delivered over 1 day (6 hours, including a lunch break). Corporate or Group Booking: Enjoy special discounts for corporate or group bookings. Our trainers can conduct on-site training tailored to your organization's needs. Course Fee: Enroll in our Level 3 Award in Emergency First Aid at Work Course for a special price of £79.99, covering all charges. How to Book: Book online via PayPal, debit/credit card, invoice, or bank transfer. Alternatively, visit our office or contact us by phone to secure your spot. Booking confirmation will be emailed instantly. Assistance Needed? For inquiries or assistance, contact our dedicated team via phone or email. We're committed to supporting you throughout your learning journey. Contact us today for guidance and assistance.

If you've ever phoned a GP surgery or hospital and been greeted by someone who seems to know everything — that’s the work of a Medical Administrator. This course gives you the knowledge to handle medical paperwork, book appointments, manage patient records, and decode the mysterious world of medical jargon — without the need for a white coat or a stethoscope. It’s built for anyone who wants to move confidently into a medical office setting, learning everything from basic office procedures to patient confidentiality and communication techniques — all without leaving your sofa. The UK healthcare sector is one of the busiest in Europe, with over 1.5 million NHS staff and rising demand for admin professionals who keep things running smoothly behind the scenes. With this online course, you'll find out how medical offices stay organised, how records are handled, and how the front desk often runs the show — all while keeping it calm and polite. Whether you're aiming for a role in a hospital, private clinic or GP surgery, this course walks you through the essentials in a way that makes sense. No jargon. No fluff. Just everything you need to know to get moving in the world of medical admin. Learning outcome: After completing this course successfully, you will Learn about clinical and medical administration Understand how to manage a filing system and medical records Understand how to preserve confidentiality in a medical setting Learn the terminology and jargon used in medical Know how to keep up with workplaces safety Acquire an understanding of healthcare information technology Learn about legal considerations and ethics Key Features of the Medical Administrator Course : Instant e-certificate and hard copy dispatch by next working day Fully online, interactive course with audio voiceover Developed by qualified professionals in the field Self-paced learning and laptop, tablet, smartphone-friendly 24/7 Learning Assistance Discounts on bulk purchases *** Additional Gifts *** Free Life coaching Course *** (Offer Ends Soon) *** Course Curriculum The detailed curriculum outline of our Medical Administrator course is as follows: ***Medical Administrator*** Module 01: Introduction to Medical and Clinical Administration Module 02: Organise Schedules Module 03: Maintaining Medical Records Module 04: Effective Filing Systems in Medical Offices Module 05: Confidentiality in a Medical Environment Module 06: Controlling Stocks and Supplies Module 07: Medical Jargon and Terminology Module 08: Maintaining Workplace Safety Module 09: Information Technology in Health Care Module 10: Medical (Clinical) Coding and Billing Module 11: Legal aspects and Ethics Accreditation All of our courses, including this Medical Administrator course, are fully accredited, providing you with up-to-date skills and knowledge and helping you to become more competent and effective in your chosen field. Certification Once you've successfully completed your courses, you will immediately be sent a digital certificate. Also, you can have your printed certificate delivered by post (shipping cost £3.99). Our certifications have no expiry dates, although we do recommend that you renew them every 12 months. Assessment At the end of the course, there will be an online assessment, which you will need to pass to complete the course. Answers are marked instantly and automatically, allowing you to know straight away whether you have passed. If you haven't, there's no limit on the number of times you can take the final exam. All this is included in the one-time fee you paid for the course itself. Who is this course for? Anyone can enrol in this Medical Administrator course. This course will provide a wealth of information for: Anyone who enjoys learning new skills Anyone looking to get ready for greater employment opportunities Anyone seeking to enhance their career in order to obtain promotions Anyone who wishes to raise their current abilities to a higher level. Career path You will be able to pursue a number of careers after completing this course, including: Medical Secretary Health records clerk Medical Assistant Medical Receptionist Patient Coordinator Certificates Certificate of completion Digital certificate - Included Certificate of completion Hard copy certificate - Included You will get the hard copy certificates for Free! The delivery charge of the hard copy certificate inside the UK is £3.99 each.

Highlights of the Course Course Type: Online Learning Duration: 4 hours 13 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 microsoft excel Understand the core competencies and principles of microsoft excel Explore the various areas of microsoft excel Know how to apply the skills you acquired from this course in a real-life context Become a confident and expert office admin Microsoft Excel Online Training Course Master the skills you need to propel your career forward in Microsoft excel. This course will equip you with the essential knowledge and skillset that will make you a confident office admin and take your career to the next level. This comprehensive Microsoft Excel course is designed to help you surpass your professional goals. The skills and knowledge that you will gain through studying this Microsoft Excel course will help you get one step closer to your professional aspirations and develop your skills for a rewarding career. This comprehensive course will teach you the theory of effective Microsoft excel practice and equip you with the essential skills, confidence and competence to assist you in the Microsoft excel industry. You'll gain a solid understanding of the core competencies required to drive a successful career in Microsoft excel. This course is designed by industry experts, so you'll gain knowledge and skills based on the latest expertise and best practices. This extensive course is designed for office admin or for people who are aspiring to specialise in Microsoft excel. Enrol in this Microsoft Excel course today and take the next step towards your personal and professional goals. Earn industry-recognised credentials to demonstrate your new skills and add extra value to your CV that will help you outshine other candidates. Who is this Course for? This comprehensive Microsoft Excel 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 Microsoft Excel 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 Microsoft Excel 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 Microsoft Excel 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 Microsoft Excel 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. The Quality Licence Scheme is a brand of the Skills and Education Group, a leading national awarding organisation for providing high-quality vocational qualifications across a wide range of industries. What is CPD? Employers, professional organisations, and academic institutions all recognise CPD, therefore a credential from CPD Certification Service adds value to your professional goals and achievements. Benefits of CPD Improve your employment prospects Boost your job satisfaction Promotes career advancement Enhances your CV Provides you with a competitive edge in the job market Demonstrate your dedication Showcases your professional capabilities What is IPHM? The IPHM is an Accreditation Board that provides Training Providers with international and global accreditation. The Practitioners of Holistic Medicine (IPHM) accreditation is a guarantee of quality and skill. Benefits of IPHM It will help you establish a positive reputation in your chosen field You can join a network and community of successful therapists that are dedicated to providing excellent care to their client You can flaunt this accreditation in your CV It is a worldwide recognised accreditation What is Quality Licence Scheme? This course is endorsed by the Quality Licence Scheme for its high-quality, non-regulated provision and training programmes. The Quality Licence Scheme is a brand of the Skills and Education Group, a leading national awarding organisation for providing high-quality vocational qualifications across a wide range of industries. Benefits of Quality License Scheme Certificate is valuable Provides a competitive edge in your career It will make your CV stand out Course Curriculum Microsoft Excel: Basic Level Introduction to Microsoft Excel 0101 Touring the interface 00:03:00 0102 Enter data & saving workbook 00:04:00 0103 Applying Formulas 00:03:00 0104 Changing a worksheet's structure 00:04:00 0105 Find, Replace & Spell Check 00:03:00 0106 Applying fonts, background colors, and borders 00:05:00 0107 Formatting numbers and dates 00:04:00 0108 Making the pieces fit 00:04:00 0109 Inserting headers & footers and Repeating Rows 00:02:00 0110 Managing Large Workbooks 00:05:00 Microsoft Excel: Intermediate Level Excel Essentials 0201 Formula Writing (Don't Miss This) 00:08:00 Ex 0201 Formula Writing (Don't Miss This) 00:02:00 Sum Count Average Functionality - With Conditions 0301 SumIf & SumIfs 00:24:00 Ex 0301 SumIf & SumIfs 00:08:00 0302 Count Functions 00:08:00 Ex 0302 Count Functions 00:02:00 0303 AverageIf & AverageIfs 00:03:00 Ex 0303 AverageIf & AverageIfs 00:03:00 Text Functions - Manipulating Text 0401 Change Case (Upper, Lower, Proper) 00:04:00 Ex 0401 Change Case (Upper, Lower, Proper) 00:03:00 0402 Separating Text on Symmetrical Data 00:06:00 Ex 0402 Separating Text on Symmetrical Data 00:06:00 0403 Separating Text on Non-Symmetrical Data 00:08:00 Ex 0403 Separating Text on Non-Symmetrical Data 00:05:00 Logical Functions - Working With Conditions 0501 If Functionality 00:04:00 Ex 0501 IF Functionality 00:03:00 0502 If with AND 00:05:00 Ex 0502 If with AND 00:03:00 0503 If with OR 00:03:00 Ex 0503 If with OR 00:03:00 0504 If with “AND” & “OR” / IF with Countif 00:08:00 Ex 0504 If with “AND” & “OR” / IF with Countif 00:04:00 0505 Nested IF (A Genie with 3 wishes) 00:13:00 Ex 0505 Nested IF (A Genie with 3 wishes) 00:05:00 Lookup Functionality - Burn Simple Find Technique 0601 Vlookup (Exact Match) # 1 00:23:00 Ex 0601 Vlookup (Exact Match) # 1 00:04:00 0602 Type of References (Use of $ sign) 00:11:00 0603 Vlookup (Exact Match) # 2 00:04:00 Ex 0603 Vlookup (Exact Match) # 2 00:06:00 0604 Double Vlookup 00:11:00 Ex 0604 Double Vlookup 00:10:00 0605 Vlookup on Duplicate Values 00:10:00 Ex 0605 Vlookup on Duplicate Values 00:05:00 0606 Vlookup (Approximate Match) 00:08:00 Ex 0606 Vlookup (Approximate Match) 00:02:00 0607 Vlookup with If (Conditional Vlookup) 00:05:00 Ex 0607 Vlookup with If (Conditional Vlookup) 00:02:00 0608 Hlookup (Exact Match) 00:03:00 Ex 0608 Hlookup (Exact Match) 00:03:00 0609 Hlookup (Approximate Match) 00:02:00 Ex 0609 Hlookup (Approximate Match) 00:02:00 0610 Lookup (Don't use this !) 00:05:00 Ex 0610 Lookup (Don't use this !) 00:02:00 0611 Vlookup with Match (Create Magical Vlookup) 00:14:00 Ex 0611 Vlookup with Match (Create Magical Vlookup) 00:05:00 0612 Match (Gives us Column/Row Index #) 00:03:00 Ex 0612 Match (Gives us Column/Row Index #) 00:03:00 0613 Index & Match (Made for Each Other) 00:11:00 Ex 0613 (1) Index & Match (Made for Each Other) 00:05:00 Ex 0613 (2) Index & Match (Made for Each Other) 00:03:00 Date & Time Function - A Tricky Game 0701 How Excel Records Date & Time 00:02:00 0702 Now, Today & Autofill 00:02:00 0703 DateValue & TimeValue 00:02:00 0704 Calculate WorkingDays 00:03:00 0705 DatedIf 00:05:00 Financial Functions 0801 Loan Calculation (PMT, PPMT, IPMT etc.) 00:12:00 Ex 0801 Loan Calculation (PMT, PPMT, IPMT etc.) 00:07:00 0802 Creating a Loan Table 00:09:00 Ex 0802 Creating a Loan Table 00:06:00 0803 Calculate Depriciation 00:02:00 Ex 0803 Calculate Depriciation 00:02:00 Sort & Filter 0901 Basic Sorting & Shortcut keys 00:16:00 Ex 0901 Basic Sorting & Shortcut keys 00:06:00 0902 Sorting Using Custom List 00:08:00 Ex 0902 Sorting Using Custom List 00:02:00 0903 Horizontal Sorting 00:01:00 Ex 0903 Horizontal Sorting 00:01:00 0904 Basic Filter & Shortcut Keys 00:09:00 Ex 0904 Basic Filter & Shortcut Keys 00:05:00 0905 Filter Problem # 1 (Copy Filtered Data without hidden rows) 00:06:00 Ex 0905 Filter Problem # 1 (Copy Filtered Data without hidden rows) 00:03:00 0906 Filter Problem # 2 (Pasting Values on Filtered Data) 00:07:00 Ex 0906 Filter Problem # 2 (Pasting Values on Filtered Data) 00:02:00 0907 Filter Problem # 3 (Performing Calculation on Filtered Data) 00:07:00 Ex 0907 Filter Problem # 3 (Performing Calculation on Filtered Data) 00:01:00 0908 Advanced Filter (Applying Complex Criteria's) 00:13:00 Ex 0908 Advanced Filter (Applying Complex Criteria's) 00:05:00 Microsoft Excel: Advanced Level Excel Charts - Visual Presentation 1001 How to create a chart 00:06:00 1002 Format Axis 00:02:00 1003 Plot Values on Secondary Axis 00:04:00 1004 Life of Pie (Charts) 00:03:00 1005 How to Show Axis Title 00:03:00 1006 How to Show Data Label 00:02:00 1007 Show data with chart in Data Table 00:02:00 1008 Column Chart 00:02:00 1009 Bar Chart 00:02:00 1010 Line Chart 1 00:03:00 1011 Line Chart 2 00:03:00 1012 Area Chart 00:01:00 1013 Pie Chart 00:03:00 1014 Pie of Pie or Bar of Pie 00:03:00 1015 Line Chart with Log Scale 00:02:00 1016 Bubble Chart 00:01:00 1017 Selecting Chart Elements 00:05:00 1018 Use of Format Dialog box 00:03:00 1019 Modifying Chart & Plot Area 00:04:00 1020 Modifying Data Series 00:02:00 1021 How to handle Missing Data 00:04:00 1022 Modifying 3-D Charts 00:03:00 1023 Creating Combination of upto 5 Different Charts 00:03:00 1025 Creating Picture Charts 00:02:00 Data Consolidation - Multiple Workbooks Worksheets Consolidate Data using Excel Inbuilt Function 00:06:00 Ex Consolidate Data using Excel Inbuilt Function 00:03:00 Data Validation 1201 Applying Data Validation 00:13:00 Ex 1201 Applying Data Validation 00:05:00 1202 Dependent Dropdown List 00:07:00 Ex1202 Dependent Dropdown List 00:05:00 Using Data Validation with Vlookup & Match 00:05:00 Other Data Validation Examples 00:10:00 Protection of Worksheet Workbook 1301 Worksheet Level Protection 00:01:00 Ex 1301 Worksheet Level Protection 00:01:00 1302 Cell Level Protection 00:05:00 Ex 1302 Cell Level Protection 00:02:00 1303 Hiding Formulas from Formula Bar 00:03:00 Ex 1303 Hiding Formulas from Formula Bar 00:02:00 1304 Protecting Workbook Structure 00:01:00 Ex 1304 Protecting Workbook Structure 00:01:00 1305 Workbook Level Protection 00:02:00 Ex 1305 Workbook Level Protection 00:01:00 Pivot Table & Techniques 1401 Understanding pivot Table 00:12:00 1402 Using Pivot Table in Real Scenario 00:10:00 Ex 1402 Using Pivot Table in Real Scenario 00:09:00 1403 Grouping in Pivot Table 00:04:00 Ex 1403 Grouping in Pivot Table 00:01:00 1404 Using Slicers (A Visually attractive Filter) 00:03:00 Ex 1404 Using Slicers (A Visually attractive Filter) 00:01:00 What-If Analysis & Solver Add-In 1501 Goal Seek (A Reverse Approach) 00:04:00 Ex 1501 Goal Seek (A Reverse Approach) 00:02:00 1502 One Way Data Table 00:03:00 1503 Two Way Data Table 00:02:00 1504 Scenario Manager 00:04:00 1505 Solver Add-In 00:07:00 Automation in Excel - Macros 1601 Record your first Macro 00:15:00 1602 Record Another Macro 00:02:00 1603 Assigning macro to a Shape, Button, Picture etc 00:02:00 1604 Editing or Deleting a Macro 00:03:00 1605 Security Settings of a Macro 00:02:00 Assessment Assessment - Microsoft Excel 00:10:00 Certificate of Achievement Certificate of Achievement 00:00:00 Get Your Insurance Now Get Your Insurance Now 00:00:00 Feedback Feedback 00:00:00

Highlights of the Course Course Type: Online Learning Duration: 4 hours 13 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 microsoft excel Understand the core competencies and principles of microsoft excel Explore the various areas of microsoft excel Know how to apply the skills you acquired from this course in a real-life context Become a confident and expert office admin Microsoft Excel Online Training Course Master the skills you need to propel your career forward in Microsoft excel. This course will equip you with the essential knowledge and skillset that will make you a confident office admin and take your career to the next level. This comprehensive Microsoft Excel course is designed to help you surpass your professional goals. The skills and knowledge that you will gain through studying this Microsoft Excel course will help you get one step closer to your professional aspirations and develop your skills for a rewarding career. This comprehensive course will teach you the theory of effective Microsoft excel practice and equip you with the essential skills, confidence and competence to assist you in the Microsoft excel industry. You'll gain a solid understanding of the core competencies required to drive a successful career in Microsoft excel. This course is designed by industry experts, so you'll gain knowledge and skills based on the latest expertise and best practices. This extensive course is designed for office admin or for people who are aspiring to specialise in Microsoft excel. Enrol in this Microsoft Excel course today and take the next step towards your personal and professional goals. Earn industry-recognised credentials to demonstrate your new skills and add extra value to your CV that will help you outshine other candidates. Who is this Course for? This comprehensive Microsoft Excel 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 Microsoft Excel 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 Microsoft Excel 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 Microsoft Excel 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 Microsoft Excel 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. The Quality Licence Scheme is a brand of the Skills and Education Group, a leading national awarding organisation for providing high-quality vocational qualifications across a wide range of industries. What is CPD? Employers, professional organisations, and academic institutions all recognise CPD, therefore a credential from CPD Certification Service adds value to your professional goals and achievements. Benefits of CPD Improve your employment prospects Boost your job satisfaction Promotes career advancement Enhances your CV Provides you with a competitive edge in the job market Demonstrate your dedication Showcases your professional capabilities What is IPHM? The IPHM is an Accreditation Board that provides Training Providers with international and global accreditation. The Practitioners of Holistic Medicine (IPHM) accreditation is a guarantee of quality and skill. Benefits of IPHM It will help you establish a positive reputation in your chosen field You can join a network and community of successful therapists that are dedicated to providing excellent care to their client You can flaunt this accreditation in your CV It is a worldwide recognised accreditation What is Quality Licence Scheme? This course is endorsed by the Quality Licence Scheme for its high-quality, non-regulated provision and training programmes. The Quality Licence Scheme is a brand of the Skills and Education Group, a leading national awarding organisation for providing high-quality vocational qualifications across a wide range of industries. Benefits of Quality License Scheme Certificate is valuable Provides a competitive edge in your career It will make your CV stand out Course Curriculum Microsoft Excel: Basic Level Introduction to Microsoft Excel 0101 Touring the interface 00:03:00 0102 Enter data & saving workbook 00:04:00 0103 Applying Formulas 00:03:00 0104 Changing a worksheet's structure 00:04:00 0105 Find, Replace & Spell Check 00:03:00 0106 Applying fonts, background colors, and borders 00:05:00 0107 Formatting numbers and dates 00:04:00 0108 Making the pieces fit 00:04:00 0109 Inserting headers & footers and Repeating Rows 00:02:00 0110 Managing Large Workbooks 00:05:00 Microsoft Excel: Intermediate Level Excel Essentials 0201 Formula Writing (Don't Miss This) 00:08:00 Ex 0201 Formula Writing (Don't Miss This) 00:02:00 Sum Count Average Functionality - With Conditions 0301 SumIf & SumIfs 00:24:00 Ex 0301 SumIf & SumIfs 00:08:00 0302 Count Functions 00:08:00 Ex 0302 Count Functions 00:02:00 0303 AverageIf & AverageIfs 00:03:00 Ex 0303 AverageIf & AverageIfs 00:03:00 Text Functions - Manipulating Text 0401 Change Case (Upper, Lower, Proper) 00:04:00 Ex 0401 Change Case (Upper, Lower, Proper) 00:03:00 0402 Separating Text on Symmetrical Data 00:06:00 Ex 0402 Separating Text on Symmetrical Data 00:06:00 0403 Separating Text on Non-Symmetrical Data 00:08:00 Ex 0403 Separating Text on Non-Symmetrical Data 00:05:00 Logical Functions - Working With Conditions 0501 If Functionality 00:04:00 Ex 0501 IF Functionality 00:03:00 0502 If with AND 00:05:00 Ex 0502 If with AND 00:03:00 0503 If with OR 00:03:00 Ex 0503 If with OR 00:03:00 0504 If with “AND” & “OR” / IF with Countif 00:08:00 Ex 0504 If with “AND” & “OR” / IF with Countif 00:04:00 0505 Nested IF (A Genie with 3 wishes) 00:13:00 Ex 0505 Nested IF (A Genie with 3 wishes) 00:05:00 Lookup Functionality - Burn Simple Find Technique 0601 Vlookup (Exact Match) # 1 00:23:00 Ex 0601 Vlookup (Exact Match) # 1 00:04:00 0602 Type of References (Use of $ sign) 00:11:00 0603 Vlookup (Exact Match) # 2 00:04:00 Ex 0603 Vlookup (Exact Match) # 2 00:06:00 0604 Double Vlookup 00:11:00 Ex 0604 Double Vlookup 00:10:00 0605 Vlookup on Duplicate Values 00:10:00 Ex 0605 Vlookup on Duplicate Values 00:05:00 0606 Vlookup (Approximate Match) 00:08:00 Ex 0606 Vlookup (Approximate Match) 00:02:00 0607 Vlookup with If (Conditional Vlookup) 00:05:00 Ex 0607 Vlookup with If (Conditional Vlookup) 00:02:00 0608 Hlookup (Exact Match) 00:03:00 Ex 0608 Hlookup (Exact Match) 00:03:00 0609 Hlookup (Approximate Match) 00:02:00 Ex 0609 Hlookup (Approximate Match) 00:02:00 0610 Lookup (Don't use this !) 00:05:00 Ex 0610 Lookup (Don't use this !) 00:02:00 0611 Vlookup with Match (Create Magical Vlookup) 00:14:00 Ex 0611 Vlookup with Match (Create Magical Vlookup) 00:05:00 0612 Match (Gives us Column/Row Index #) 00:03:00 Ex 0612 Match (Gives us Column/Row Index #) 00:03:00 0613 Index & Match (Made for Each Other) 00:11:00 Ex 0613 (1) Index & Match (Made for Each Other) 00:05:00 Ex 0613 (2) Index & Match (Made for Each Other) 00:03:00 Date & Time Function - A Tricky Game 0701 How Excel Records Date & Time 00:02:00 0702 Now, Today & Autofill 00:02:00 0703 DateValue & TimeValue 00:02:00 0704 Calculate WorkingDays 00:03:00 0705 DatedIf 00:05:00 Financial Functions 0801 Loan Calculation (PMT, PPMT, IPMT etc.) 00:12:00 Ex 0801 Loan Calculation (PMT, PPMT, IPMT etc.) 00:07:00 0802 Creating a Loan Table 00:09:00 Ex 0802 Creating a Loan Table 00:06:00 0803 Calculate Depriciation 00:02:00 Ex 0803 Calculate Depriciation 00:02:00 Sort & Filter 0901 Basic Sorting & Shortcut keys 00:16:00 Ex 0901 Basic Sorting & Shortcut keys 00:06:00 0902 Sorting Using Custom List 00:08:00 Ex 0902 Sorting Using Custom List 00:02:00 0903 Horizontal Sorting 00:01:00 Ex 0903 Horizontal Sorting 00:01:00 0904 Basic Filter & Shortcut Keys 00:09:00 Ex 0904 Basic Filter & Shortcut Keys 00:05:00 0905 Filter Problem # 1 (Copy Filtered Data without hidden rows) 00:06:00 Ex 0905 Filter Problem # 1 (Copy Filtered Data without hidden rows) 00:03:00 0906 Filter Problem # 2 (Pasting Values on Filtered Data) 00:07:00 Ex 0906 Filter Problem # 2 (Pasting Values on Filtered Data) 00:02:00 0907 Filter Problem # 3 (Performing Calculation on Filtered Data) 00:07:00 Ex 0907 Filter Problem # 3 (Performing Calculation on Filtered Data) 00:01:00 0908 Advanced Filter (Applying Complex Criteria's) 00:13:00 Ex 0908 Advanced Filter (Applying Complex Criteria's) 00:05:00 Microsoft Excel: Advanced Level Excel Charts - Visual Presentation 1001 How to create a chart 00:06:00 1002 Format Axis 00:02:00 1003 Plot Values on Secondary Axis 00:04:00 1004 Life of Pie (Charts) 00:03:00 1005 How to Show Axis Title 00:03:00 1006 How to Show Data Label 00:02:00 1007 Show data with chart in Data Table 00:02:00 1008 Column Chart 00:02:00 1009 Bar Chart 00:02:00 1010 Line Chart 1 00:03:00 1011 Line Chart 2 00:03:00 1012 Area Chart 00:01:00 1013 Pie Chart 00:03:00 1014 Pie of Pie or Bar of Pie 00:03:00 1015 Line Chart with Log Scale 00:02:00 1016 Bubble Chart 00:01:00 1017 Selecting Chart Elements 00:05:00 1018 Use of Format Dialog box 00:03:00 1019 Modifying Chart & Plot Area 00:04:00 1020 Modifying Data Series 00:02:00 1021 How to handle Missing Data 00:04:00 1022 Modifying 3-D Charts 00:03:00 1023 Creating Combination of upto 5 Different Charts 00:03:00 1025 Creating Picture Charts 00:02:00 Data Consolidation - Multiple Workbooks Worksheets Consolidate Data using Excel Inbuilt Function 00:06:00 Ex Consolidate Data using Excel Inbuilt Function 00:03:00 Data Validation 1201 Applying Data Validation 00:13:00 Ex 1201 Applying Data Validation 00:05:00 1202 Dependent Dropdown List 00:07:00 Ex1202 Dependent Dropdown List 00:05:00 Using Data Validation with Vlookup & Match 00:05:00 Other Data Validation Examples 00:10:00 Protection of Worksheet Workbook 1301 Worksheet Level Protection 00:01:00 Ex 1301 Worksheet Level Protection 00:01:00 1302 Cell Level Protection 00:05:00 Ex 1302 Cell Level Protection 00:02:00 1303 Hiding Formulas from Formula Bar 00:03:00 Ex 1303 Hiding Formulas from Formula Bar 00:02:00 1304 Protecting Workbook Structure 00:01:00 Ex 1304 Protecting Workbook Structure 00:01:00 1305 Workbook Level Protection 00:02:00 Ex 1305 Workbook Level Protection 00:01:00 Pivot Table & Techniques 1401 Understanding pivot Table 00:12:00 1402 Using Pivot Table in Real Scenario 00:10:00 Ex 1402 Using Pivot Table in Real Scenario 00:09:00 1403 Grouping in Pivot Table 00:04:00 Ex 1403 Grouping in Pivot Table 00:01:00 1404 Using Slicers (A Visually attractive Filter) 00:03:00 Ex 1404 Using Slicers (A Visually attractive Filter) 00:01:00 What-If Analysis & Solver Add-In 1501 Goal Seek (A Reverse Approach) 00:04:00 Ex 1501 Goal Seek (A Reverse Approach) 00:02:00 1502 One Way Data Table 00:03:00 1503 Two Way Data Table 00:02:00 1504 Scenario Manager 00:04:00 1505 Solver Add-In 00:07:00 Automation in Excel - Macros 1601 Record your first Macro 00:15:00 1602 Record Another Macro 00:02:00 1603 Assigning macro to a Shape, Button, Picture etc 00:02:00 1604 Editing or Deleting a Macro 00:03:00 1605 Security Settings of a Macro 00:02:00 Supplementary Resources Supplementary Resources - Microsoft Excel Diploma 00:00:00 Assessment Assessment - Microsoft Excel Diploma 00:10:00 Obtain Your Certificate Order Your Certificate of Achievement 00:00:00 Get Your Insurance Now Get Your Insurance Now 00:00:00 Feedback Feedback 00:00:00

24 Hour Flash Deal **25-in-1 Legal Assistant Diploma Mega Bundle** Legal Assistant Diploma Enrolment Gifts **FREE PDF Certificate**FREE PDF Transcript ** FREE Exam** FREE Student ID ** Lifetime Access **FREE Enrolment Letter ** Take the initial steps toward a successful long-term career by studying the Legal Assistant Diploma package online with Studyhub through our online learning platform. The Legal Assistant Diploma bundle can help you improve your CV, wow potential employers, and differentiate yourself from the mass. This Legal Assistant Diploma course provides complete 360-degree training on Legal Assistant Diploma. You'll get not one, not two, not three, but twenty-five Legal Assistant Diploma courses included in this course. Plus Studyhub's signature Forever Access is given as always, meaning these Legal Assistant Diploma courses are yours for as long as you want them once you enrol in this course This Legal Assistant Diploma Bundle consists the following career oriented courses: Course 01: Legal Secretary Skills Diploma Course 02: Business Law Course 03: English Law Basics: Understanding Legal Principles Course 04: Uk Commercial Law and Consumer Protection Training Course 05: Understanding UK Insurance (General, Commercial, Liability, Life) Course 06: Data Protection and Data Security (GDPR) Training Certification Course 07: Contract Law Certificate Course 08: Medical Law Course 09: Anti-Money Laundering (AML) Course 10: Cyber Security Law Course 11: Family Law Course 12: Workplace Violence, Harassment and Conflict Resolution Training Course 13: Tort Law Simplified: Understanding Legal Principles and Rights Course 14: Criminology: Criminal Law Course 15: Criminal Intelligence & Counterterrorism Analysis Course 16: International Law Certificate Course 17: GDPR Training Course 18: Workplace Confidentiality Course 19: Business Contract & Compliance Manager: Ensuring Legal Integrity Diploma Course 20: Corporate Social Responsibility Diploma Course 21: Emotional Intelligence and Social Management Diploma Course 22: Resilience Masterclass Course 23: Cross-Cultural Awareness Training Diploma Certificate Course 24: Office Skills (Administration, Communication and Management) Diploma Course 25: Time Management The Legal Assistant Diploma course has been prepared by focusing largely on Legal Assistant Diploma career readiness. It has been designed by our Legal Assistant Diploma specialists in a manner that you will be likely to find yourself head and shoulders above the others. For better learning, one to one assistance will also be provided if it's required by any learners. The Legal Assistant Diploma Bundle is one of the most prestigious training offered at StudyHub and is highly valued by employers for good reason. This Legal Assistant Diploma bundle course has been created with twenty-five premium courses to provide our learners with the best learning experience possible to increase their understanding of their chosen field. This Legal Assistant Diploma Course, like every one of Study Hub's courses, is meticulously developed and well researched. Every one of the topics is divided into Legal Assistant Diploma Elementary modules, allowing our students to grasp each lesson quickly. The Legal Assistant Diploma course is self-paced and can be taken from the comfort of your home, office, or on the go! With our Student ID card you will get discounts on things like music, food, travel and clothes etc. In this exclusive Legal Assistant Diploma bundle, you really hit the jackpot. Here's what you get: Step by step Legal Assistant Diploma lessons One to one assistance from Legal Assistant Diplomaprofessionals if you need it Innovative exams to test your knowledge after the Legal Assistant Diplomacourse 24/7 customer support should you encounter any hiccups Top-class learning portal Unlimited lifetime access to all twenty-five Legal Assistant Diploma courses Digital Certificate, Transcript and student ID are all included in the price PDF certificate immediately after passing Original copies of your Legal Assistant Diploma certificate and transcript on the next working day Easily learn the Legal Assistant Diploma skills and knowledge you want from the comfort of your home CPD 250 CPD hours / points Accredited by CPD Quality Standards Who is this course for? This Legal Assistant Diploma training is suitable for - Students Recent graduates Job Seekers Individuals who are already employed in the relevant sectors and wish to enhance their knowledge and expertise in Legal Assistant Diploma Requirements To participate in this Legal Assistant Diploma course, all you need is - A smart device A secure internet connection And a keen interest in Legal Assistant Diploma Career path You will be able to kickstart your Legal Assistant Diploma career because this course includes various courses as a bonus. This Legal Assistant Diploma is an excellent opportunity for you to learn multiple skills from the convenience of your own home and explore Legal Assistant Diploma career opportunities. Certificates CPD Accredited Certificate Digital certificate - Included CPD Accredited e-Certificate - Free CPD Accredited Hardcopy Certificate - Free Enrolment Letter - Free Student ID Card - Free

24 Hour Flash Deal **25-in-1 HR Business Partner Diploma Mega Bundle** HR Business Partner Diploma Enrolment Gifts **FREE PDF Certificate**FREE PDF Transcript ** FREE Exam** FREE Student ID ** Lifetime Access **FREE Enrolment Letter ** Take the initial steps toward a successful long-term career by studying the HR Business Partner Diploma package online with Studyhub through our online learning platform. The HR Business Partner Diploma bundle can help you improve your CV, wow potential employers, and differentiate yourself from the mass. This HR Business Partner Diploma course provides complete 360-degree training on HR Business Partner Diploma. You'll get not one, not two, not three, but twenty-five HR Business Partner Diploma courses included in this course. Plus Studyhub's signature Forever Access is given as always, meaning these HR Business Partner Diploma courses are yours for as long as you want them once you enrol in this course This HR Business Partner Diploma Bundle consists the following career oriented courses: Course 01: HR Management Course 02: Complete Guide to HR System Course 03: Virtual Interviewing for HR Course 04: Resourcing and Managing Talent Course Course 05: Workplace Productivity Training Course 06: Team Management Course 07: Performance and Talent Management Course 08: Workplace Confidentiality Course 09: Talent Management & Employee Retention Techniques Course 10: Safer Recruitment Training Course 11: Employee Engagement and Retention Strategies Course 12: Managing Online Meetings Course 13: Influencing and Negotiation Skills Course 14: Administration : Office Administration Course 15: Organisation & People Management Course 16: Equality, Diversity and Discrimination Course 17: Cross-Cultural Awareness Training Diploma Certificate Course 18: Conflict Resolution Course 19: Corporate Risk And Crisis Management Course 20: Internal Audit and Risk Control Training Course 21: Leadership Skills Training Course 22: Organizational Behaviour, HR and Leadership Course 23: Diversity Training Course 24: Time Management Course 25: UK Employment Law The HR Business Partner Diploma course has been prepared by focusing largely on HR Business Partner Diploma career readiness. It has been designed by our HR Business Partner Diploma specialists in a manner that you will be likely to find yourself head and shoulders above the others. For better learning, one to one assistance will also be provided if it's required by any learners. The HR Business Partner Diploma Bundle is one of the most prestigious training offered at StudyHub and is highly valued by employers for good reason. This HR Business Partner Diploma bundle course has been created with twenty-five premium courses to provide our learners with the best learning experience possible to increase their understanding of their chosen field. This HR Business Partner Diploma Course, like every one of Study Hub's courses, is meticulously developed and well researched. Every one of the topics is divided into HR Business Partner Diploma Elementary modules, allowing our students to grasp each lesson quickly. The HR Business Partner Diploma course is self-paced and can be taken from the comfort of your home, office, or on the go! With our Student ID card you will get discounts on things like music, food, travel and clothes etc. In this exclusive HR Business Partner Diploma bundle, you really hit the jackpot. Here's what you get: Step by step HR Business Partner Diploma lessons One to one assistance from HR Business Partner Diplomaprofessionals if you need it Innovative exams to test your knowledge after the HR Business Partner Diplomacourse 24/7 customer support should you encounter any hiccups Top-class learning portal Unlimited lifetime access to all twenty-five HR Business Partner Diploma courses Digital Certificate, Transcript and student ID are all included in the price PDF certificate immediately after passing Original copies of your HR Business Partner Diploma certificate and transcript on the next working day Easily learn the HR Business Partner Diploma skills and knowledge you want from the comfort of your home CPD 250 CPD hours / points Accredited by CPD Quality Standards Who is this course for? This HR Business Partner Diploma training is suitable for - Students Recent graduates Job Seekers Individuals who are already employed in the relevant sectors and wish to enhance their knowledge and expertise in HR Business Partner Diploma Requirements To participate in this HR Business Partner Diploma course, all you need is - A smart device A secure internet connection And a keen interest in HR Business Partner Diploma Career path You will be able to kickstart your HR Business Partner Diploma career because this course includes various courses as a bonus. This HR Business Partner Diploma is an excellent opportunity for you to learn multiple skills from the convenience of your own home and explore HR Business Partner Diploma career opportunities. Certificates CPD Accredited Certificate Digital certificate - Included CPD Accredited e-Certificate - Free CPD Accredited Hardcopy Certificate - Free Enrolment Letter - Free Student ID Card - Free

24 Hour Flash Deal **25-in-1 Healthcare Administrator Diploma Mega Bundle** Healthcare Administrator Diploma Enrolment Gifts **FREE PDF Certificate**FREE PDF Transcript ** FREE Exam** FREE Student ID ** Lifetime Access **FREE Enrolment Letter ** Take the initial steps toward a successful long-term career by studying the Healthcare Administrator Diploma package online with Studyhub through our online learning platform. The Healthcare Administrator Diploma bundle can help you improve your CV, wow potential employers, and differentiate yourself from the mass. This Healthcare Administrator Diploma course provides complete 360-degree training on Healthcare Administrator Diploma. You'll get not one, not two, not three, but twenty-five Healthcare Administrator Diploma courses included in this course. Plus Studyhub's signature Forever Access is given as always, meaning these Healthcare Administrator Diploma courses are yours for as long as you want them once you enrol in this course This Healthcare Administrator Diploma Bundle consists the following career oriented courses: Course 01: Medical & Clinical Administrator Course 02: Healthcare GDPR Certificate Course 03: Essentials of European Medical Device Regulations Course 04: Medical Law Course 05: Medical Terminology Training Course 06: Paramedicine Study Course 07: Safe Handling of Medicines Course 08: Communication & Information Handling in Care Course 09: Anatomy and Physiology of Human Body Course 10: Medical Jargon for Healthcare Assistant Course 11: Care Certificate Preparation Course 12: Control and Administration of Medication Course 13: Phlebotomy Course 14: Medical Transcription Diploma Course 15: Introduction to Vaccination Course 16: Consent Training in Healthcare Course 17: Diabetes Awareness Training Course 18: ADHD Awareness Course 19: Autism & Dyslexia Awareness Training Course 20: Safety & Precautions in Medication Management Course 21: First Aid Training Course Course 22: Anaphylaxis and Basic Life Support (CSTF) Course 23: Death Verification: Procedures and Legal Considerations Course 24: Microsoft Office course Course 25: Study Skills for Healthcare The Healthcare Administrator Diploma course has been prepared by focusing largely on Healthcare Administrator Diploma career readiness. It has been designed by our Healthcare Administrator Diploma specialists in a manner that you will be likely to find yourself head and shoulders above the others. For better learning, one to one assistance will also be provided if it's required by any learners. The Healthcare Administrator Diploma Bundle is one of the most prestigious training offered at StudyHub and is highly valued by employers for good reason. This Healthcare Administrator Diploma bundle course has been created with twenty-five premium courses to provide our learners with the best learning experience possible to increase their understanding of their chosen field. This Healthcare Administrator Diploma Course, like every one of Study Hub's courses, is meticulously developed and well researched. Every one of the topics is divided into Healthcare Administrator Diploma Elementary modules, allowing our students to grasp each lesson quickly. The Healthcare Administrator Diploma course is self-paced and can be taken from the comfort of your home, office, or on the go! With our Student ID card you will get discounts on things like music, food, travel and clothes etc. In this exclusive Healthcare Administrator Diploma bundle, you really hit the jackpot. Here's what you get: Step by step Healthcare Administrator Diploma lessons One to one assistance from Healthcare Administrator Diplomaprofessionals if you need it Innovative exams to test your knowledge after the Healthcare Administrator Diplomacourse 24/7 customer support should you encounter any hiccups Top-class learning portal Unlimited lifetime access to all twenty-five Healthcare Administrator Diploma courses Digital Certificate, Transcript and student ID are all included in the price PDF certificate immediately after passing Original copies of your Healthcare Administrator Diploma certificate and transcript on the next working day Easily learn the Healthcare Administrator Diploma skills and knowledge you want from the comfort of your home CPD 250 CPD hours / points Accredited by CPD Quality Standards Who is this course for? This Healthcare Administrator Diploma training is suitable for - Students Recent graduates Job Seekers Individuals who are already employed in the relevant sectors and wish to enhance their knowledge and expertise in Healthcare Administrator Diploma Requirements To participate in this Healthcare Administrator Diploma course, all you need is - A smart device A secure internet connection And a keen interest in Healthcare Administrator Diploma Career path You will be able to kickstart your Healthcare Administrator Diploma career because this course includes various courses as a bonus. This Healthcare Administrator Diploma is an excellent opportunity for you to learn multiple skills from the convenience of your own home and explore Healthcare Administrator Diploma career opportunities. Certificates CPD Accredited Certificate Digital certificate - Included CPD Accredited e-Certificate - Free CPD Accredited Hardcopy Certificate - Free Enrolment Letter - Free Student ID Card - Free

Participants gain a foundational understanding of the UX design process, tools and techniques through an engaging mix of theory and practical application exercises.

Individual Safety Certification Individual wellbeing is something that everybody needs to zero in on in all aspects of their life. This is valid in both your own life and your expert life. Occurrences of work environment animosity and viciousness are on the ascent, making it critical to realize how to secure yourself. Furthermore, there are a developing number of representatives who work in far off areas or all alone. Guarding everybody from likely dangers and risks while working in such a climate is a commitment with respect to the two businesses and representatives. This course expounds in regards to individual security, with an accentuation on close to home wellbeing while at work. We start by giving you a concise prologue to the point, remembering a definition and lawful commitments for the space of wellbeing and security. Then, we proceed onward to discuss individual security in accordance with the individuals who work alone, regardless of whether it is in an office or retail setting or in the event that it includes working distantly from home. The course additionally surveys approaches to remain safe while going on business, including why you should check in with your home office every day. At long last, we talk about how to remain safe when functioning at off-site areas. You Will Learn: The meaning of individual wellbeing, as settled upon by UK specialists The lawful commitments set on the two businesses and representatives to make and keep up safe workspaces The best prudent steps to take when you are dealing with your own or at another site Instructions to remain safe while out and about Significant systems you should know when self-managing emergency treatment Advantages of Taking this Course Feeling more certain when working alone or in new circumstances Seeing how to survey work environment circumstances for dangers and risks Figuring out how to advance mindfulness about close to home wellbeing for representatives in an assortment of work environment areas Having the option to show yourself or your staff how to remain safe while away on business