6190 Productivity courses

In the modern world, the role of a Medical Receptionist has become increasingly vital in ensuring smooth operations within healthcare facilities. This course provides essential training in managing patient appointments, medical records, and administrative tasks, contributing significantly to the efficiency of medical practices. With the healthcare sector in the UK experiencing continual growth, job opportunities for qualified Medical Receptionist are abundant. As of current data, the average salary for a Medical Receptionist in the UK ranges from £18,000 to £25,000 per year, depending on experience and location. Despite fluctuations in overall employment trends, the demand for skilled Medical Receptionist remains stable due to the ongoing need for healthcare services. By undertaking this Medical Receptionist Course course, individuals not only gain access to rewarding job opportunities but also contribute to the seamless delivery of healthcare services, making a tangible impact on patients' experiences within medical settings. Key Features This Medical Receptionist Course Includes: CPD Certified Medical Receptionist Course. Free Certificate from Reed CIQ Approved Medical Receptionist Course Developed by Specialist Lifetime Access Course Curriculum Medical Receptionist Course: Module 01: Exploring Healthcare and Receptionist Roles Module 02: Managing Schedules Module 03: Upkeep of Medical Records Module 04: Efficient Filing Systems for Medical Offices Module 05: Ensuring Confidentiality in a Medical Setting Module 06: Effective Time Management Strategies Module 07: Navigating Medical Jargon and Terminology Module 08: Prioritising Workplace Safety Module 09: Integrating Information Technology in Health Care Module 10: Legal Considerations and Ethical Practices Learning Outcomes After completing this Medical Receptionist Course, you will be able to: Recognize healthcare roles and apply receptionist duties in a medical environment. Efficiently manage and coordinate schedules for medical appointments and administrative tasks. Implement effective filing systems for organising and maintaining medical records. Ensure confidentiality by following proper procedures in a medical office setting. Demonstrate effective time management strategies in a busy medical receptionist role. Navigate and understand medical jargon and terminology for improved communication. Certification After completing this Medical Receptionist course, you will get a free Certificate. Please note: The CPD approved course is owned by E-Learning Solutions Ltd and is distributed under license. CPD 10 CPD hours / points Accredited by The CPD Certification Service Medical Receptionist 2:17:02 1: Module 01: Exploring Healthcare and Receptionist Roles 17:39 2: Module 02: Managing Schedules 12:40 3: Module 03: Upkeep of Medical Records 12:25 4: Module 04: Efficient Filing Systems for Medical Offices 09:53 5: Module 05: Ensuring Confidentiality in a Medical Setting 08:22 6: Module 06: Effective Time Management Strategies 23:36 7: Module 07: Navigating Medical Jargon and Terminology 16:18 8: Module 08: Prioritising Workplace Safety 13:53 9: Module 09: Integrating Information Technology in Health Care 08:24 10: Module 10: Legal Considerations and Ethical Practices 11:52 11: CPD Certificate - Free 01:00 12: Leave A Review 01:00 Who is this course for? This Medical Receptionist Training course is accessible to anyone eager to learn more about this topic. Through this course, you'll gain a solid understanding of Medical Receptionist Training. Moreover, this course is ideal for: Individuals aspiring to become medical receptionist in healthcare settings. Administrative professionals seeking specialisation in medical receptionist office procedures. Those transitioning into healthcare administration or receptionist roles. Job seekers interested in administrative positions within medical environments. Individuals aiming to enhance their skills in medical receptionist management. Requirements There are no requirements needed to enrol into this Medical Receptionist Trainingcourse. We welcome individuals from all backgrounds and levels of experience to enrol into this Medical Receptionist Training course. Career path After finishing this Medical Receptionist Training course you will have multiple job opportunities waiting for you. Some of the Job sectors of Medical Receptionist are: Medical Receptionist - £18K to 25K/year Medical Secretary - £20K to 28K/year Administrative Assistant in Healthcare - £19K to 26K/year Health Information Technician - £22K to 30K/year Medical Office Manager - £25K to 35K/year Certificates Reed Courses Certificate of Completion Digital certificate - Included Will be downloadable when all lectures have been completed.

Medical Receptionist: Medical Receptionist A medical secretary is responsible for ensuring that a doctor's office runs smoothly so that patients receive the best possible care. A medical secretary must understand office organisation and standard procedures to provide this secretarial support. They should also be able to use medical terminologies fluently. This Diploma in Medical Receptionist course will teach you about the medical secretarial profession and the skills needed to do the job successfully. This Diploma in Medical Receptionist course will teach you about the roles and responsibilities of a medical secretary. You will also learn various medical secretary skills, including an effective filing system, medical transcription, medical writing, maintaining medical records, an appointment system, and more. Furthermore, this comprehensive Diploma in Medical Receptionist course will teach you the critical concepts of patient confidentiality and other legal aspects of the healthcare industry. **Courses are included in this Diploma in Medical Receptionist Course Course 01: Diploma in Medical Receptionist Course 02: Communication Skills Course Course 03: Level 4 Time Management Course [ Note: Free PDF certificate as soon as completing the Diploma in Medical Receptionist course] Medical Receptionist: Medical Receptionist Detailed course curriculum of the Diploma in Medical Receptionist Course: Industry Experts Designed this Medical Receptionist course into 13 detailed modules. Module 01: The National Health Service Module 02: Patient (Customer) Care Module 03: Communication Module 04: Law, Ethics and Medicine Module 05: Health & Safety in a Clinical Environment Module 06: Practical Reception Skills in General Practice Module 07: The Hospital Service Module 08: Private Medicine Module 09: Forms, Fees and Finances in General Practises Module 10: Using Information Technology Module 11: Medical Terminology and Clinical Aspects Module 12: Audit, Health Economics and Ensuring Quality for the Medical Receptionist and Secretary Module 13: Complementary Medicine ------------------- Assessment Method After completing each module of the Diploma in Medical Receptionist Course, you will find automated MCQ quizzes. To unlock the next module, you need to complete the quiz task and get at least 60% marks. Certification After completing the MCQ/Assignment assessment for this Diploma in Medical Receptionist course, you will be entitled to a Certificate of Completion from Training Tale. The certificate is in PDF format, which is completely free to download. A printed version is also available upon request. It will also be sent to you through a courier for £13.99. Who is this course for? Medical Receptionist This Diploma in Medical Receptionist course is ideal for Health Care Professionals who work and will be working in healthcare settings such as hospitals, clinics, and healthcare facilities. Requirements Medical Receptionist There are no specific requirements for this Diploma in Medical Receptionist course because it does not require any advanced knowledge or skills. Career path Medical Receptionist After completing this course, you will have developed a set of skills necessary for career advancement and will be able to pursue a variety of job opportunities. Certificates Certificate of completion Digital certificate - Included

This minute taking course is for anyone who organises meetings and takes minutes and wants to do it to a professional standard. Taking minute taking course supports to ensure an accurate record of the meeting's content for future reference. Taking Meeting Minutes online course is applicable to any type of meeting, formal or informal. Along with the Minute Taking course, you also get: Lifetime Access Unlimited Retake Exam & Tutor Support Easy Accessibility to the Course Materials 100% Learning Satisfaction Guarantee Curriculum Breakdown: Minute Taking Course Module 01: Introduction to Minute Writing Module 02: Preparation for Minute Taking Module 03: The Meeting Structure Module 04: Minute Meeting, Decision and Action Module 05: Roles and Responsibility of Minute Taker Module 06: Tips for Minute Taking Module 07: Technology in Minute Taking Module 08: Building Confidence CPD 10 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Anyone from any background can enrol in this Minute Taking course. Requirements To enrol in this Minute Taking course, all you need is a basic understanding of the English Language and an internet connection. Career path After completing this Minute Taking course, you can explore trendy and in-demand jobs related to Minute Taking, such as- Administrative Assistant: £18,000 to £25,000 per year Executive Assistant: £25,000 to £40,000 per year Office Manager: £25,000 to £40,000 per year Secretary/Personal Assistant: £20,000 to £30,000 per year Project Coordinator: £22,000 to £35,000 per year Certificates CPD Accredited Hard Copy Certificate Hard copy certificate - Included CPD Accredited Hard Copy Certificate Delivery Charge: Inside the UK: £3.99 each Outside of the UK: £9.99 each CPD Accredited PDF Certificate Digital certificate - Included CPD Accredited PDF Certificate

Are you looking to enhance your Reception Manager skills? If yes, then you have come to the right place. Our comprehensive course on Reception Manager will assist you in producing the best possible outcome by mastering the Reception Manager skills. The Reception Manager course is for those who want to be successful. In the Reception Manager course, you will learn the essential knowledge needed to become well versed in Reception Manager. Our Reception Manager course starts with the basics of Reception Manager and gradually progresses towards advanced topics. Therefore, each lesson of this Reception Manager course is intuitive and easy to understand. Why would you choose the Reception Manager course from Compliance Central: Lifetime access to Reception Manager course materials Full tutor support is available from Monday to Friday with the Reception Manager course Learn Reception Manager skills at your own pace from the comfort of your home Gain a complete understanding of Reception Manager course Accessible, informative Reception Manager learning modules designed by experts Get 24/7 help or advice from our email and live chat teams with the Reception Manager Study Reception Manager in your own time through your computer, tablet or mobile device. A 100% learning satisfaction guarantee with your Reception Manager Course Reception Manager Curriculum Breakdown of the Reception Manager Course Course Outline: Module 01: Introduction to Reception and Receptionist Module 02: Business Telephone Skills Module 03: Representing Your Boss and Company Module 04: Mail Services and Shipping Module 05: Travel Arrangements Module 06: Organising Meeting and Conferences Module 07: Time Management Module 08: Record Keeping and Filing Systems Module 09: Business Writing Skills Module 10: Organisational Skills Module 11: Communication Skills Module 12: Customer Service Module 13: Effective Planning and Scheduling Module 14: Invoicing/Petty Cash CPD 10 CPD hours / points Accredited by CPD Quality Standards Who is this course for? The Reception Manager course helps aspiring professionals who want to obtain the knowledge and familiarise themselves with the skillsets to pursue a career in Reception Manager. It is also great for professionals who are already working in Reception Manager and want to get promoted at work. Requirements To enrol in this Reception Manager course, all you need is a basic understanding of the English Language and an internet connection. Career path Hotel Front Desk Manager: £25,000 to £40,000 per year Customer Service Manager: £30,000 to £50,000 per year Event Coordinator: £22,000 to £35,000 per year Guest Relations Manager: £28,000 to £45,000 per year Office Manager: £25,000 to £40,000 per year Concierge Manager: £28,000 to £45,000 per year Certificates CPD Accredited PDF Certificate Digital certificate - Included CPD Accredited PDF Certificate CPD Accredited Hard Copy Certificate Hard copy certificate - £10.79 CPD Accredited Hard Copy Certificate Delivery Charge: Inside the UK: Free Outside of the UK: £9.99 each

Discover the essential foundations of medical transcription in our comprehensive course. From understanding medical terminology and reports to mastering data protection protocols, each module equips you with indispensable skills. Whether you're new to the field or enhancing your expertise, our structured curriculum ensures you gain the knowledge needed to excel in medical transcription. Key Features: CPD Certified Free Certificate from Reed CIQ Approved Developed by Specialist Lifetime Access Students will acquire the necessary skills for medical transcription through this curriculum. They will gain proficiency in comprehending reports and medical terminology, which will guarantee appropriate transcription. Attendees will acquire formatting skills that are essential for producing medical documents that are ordered and comprehensible. In order to preserve patient privacy and adhere to healthcare laws, data protection methods are prioritised. The course covers the principles of medical transcription, including its goals, procedures, and participants' roles. By the end, students will have a firm understanding of the duties and specifications placed on medical transcriptionists, as well as the skills necessary to create accurate and secure medical records. Course Curriculum: Module 01: Introduction to Medical Transcription Module 02: The What, How, Who and Why of Medical Transcription Module 03: Medical Language Boot Camp Module 04: Understanding Medical Reports Module 05: Formatting The Basics Module 06: Data Protection Learning Outcomes: Identify key terms in medical transcription and their applications. Analyse medical reports for accuracy and clarity in transcription. Demonstrate proficiency in formatting medical documents according to guidelines. Apply data protection principles to medical transcription practices effectively. Explain the importance of medical language comprehension in transcription tasks. Evaluate the role and responsibilities of a medical transcriptionist. CPD 10 CPD hours / points Accredited by CPD Quality Standards Introduction to Medical Transcription 1:03:10 1: Module 01: Introduction to Medical Transcription 09:02 2: Module 02: The What, How, Who and Why of Medical Transcription 11:53 3: Module 03: Medical Language Boot Camp 07:29 4: Module 04: Understanding Medical Reports 15:14 5: Module 05: Formatting The Basics 09:06 6: Module 06: Data Protection 09:26 7: CPD Certificate - Free 01:00 Who is this course for? Individuals aspiring to work in healthcare administrative support roles. Those interested in specialised roles within medical documentation fields. Students pursuing careers requiring attention to detail and accuracy. Professionals seeking to enhance their understanding of medical terminology. Anyone preparing for roles involving medical record management. Career path Medical Transcriptionist Healthcare Documentation Specialist Medical Secretary Health Information Technician Medical Office Administrator Clinical Documentation Specialist Certificates Digital certificate Digital certificate - Included Reed Courses Certificate of Completion Digital certificate - Included Will be downloadable when all lectures have been completed.

Are you looking to enhance your IT Administration skills? If yes, then you have come to the right place. Our comprehensive course on IT Administration will assist you in producing the best possible outcome by mastering the IT Administration skills. The IT Administration course is for those who want to be successful. In the IT Administration course, you will learn the essential knowledge needed to become well versed in IT Administration. Our IT Administration course starts with the basics of IT Administration and gradually progresses towards advanced topics. Therefore, each lesson of this IT Administration course is intuitive and easy to understand. IT Administration Curriculum Breakdown of the IT Administration Course Course Outline: Software Hardware Security Networking Basic IT Literacy Why would you choose the IT Administration course from Compliance Central: Lifetime access to IT Administration course materials Full tutor support is available from Monday to Friday with the IT Administration course Learn IT Administration skills at your own pace from the comfort of your home Gain a complete understanding of IT Administration course Accessible, informative IT Administration learning modules designed by experts Get 24/7 help or advice from our email and live chat teams with the IT Administration Study IT Administration in your own time through your computer, tablet or mobile device A 100% learning satisfaction guarantee with your IT Administration Course CPD 10 CPD hours / points Accredited by CPD Quality Standards Who is this course for? The IT Administration course helps aspiring professionals who want to obtain the knowledge and familiarise themselves with the skillsets to pursue a career in IT Administration. It is also great for professionals who are already working in IT Administration and want to get promoted at work. Requirements To enrol in this IT Administration course, all you need is a basic understanding of the English Language and an internet connection. Career path IT Administrator: £25,000 to £45,000 per year Systems Administrator: £30,000 to £50,000 per year Network Administrator: £30,000 to £55,000 per year Database Administrator: £35,000 to £60,000 per year IT Security Administrator: £35,000 to £65,000 per year Cloud Administrator: £40,000 to £70,000 per year Certificates CPD Accredited PDF Certificate Digital certificate - Included CPD Accredited PDF Certificate CPD Accredited Hard Copy Certificate Hard copy certificate - £10.79 CPD Accredited Hard Copy Certificate Delivery Charge: Inside the UK: Free Outside of the UK: £9.99 each

Register on the Basic Procrastination Solution today and build the experience, skills and knowledge you need to enhance your professional development and work towards your dream job. Study this course through online learning and take the first steps towards a long-term career. The course consists of a number of easy to digest, in-depth modules, designed to provide you with a detailed, expert level of knowledge. Learn through a mixture of instructional video lessons and online study materials. Receive online tutor support as you study the course, to ensure you are supported every step of the way. Get a digital certificate as a proof of your course completion. The Basic Procrastination Solution is incredibly great value and allows you to study at your own pace. Access the course modules from any internet-enabled device, including computers, tablet, and smartphones. The course is designed to increase your employability and equip you with everything you need to be a success. Enrol on the now and start learning instantly! What You Get With The Basic Procrastination Solution Receive a e-certificate upon successful completion of the course Get taught by experienced, professional instructors Study at a time and pace that suits your learning style Get instant feedback on assessments 24/7 help and advice via email or live chat Get full tutor support on weekdays (Monday to Friday) Course Design The course is delivered through our online learning platform, accessible through any internet-connected device. There are no formal deadlines or teaching schedules, meaning you are free to study the course at your own pace. You are taught through a combination of Video lessons Online study materials Certification After the successful completion of the final assessment, you will receive a CPD-accredited certificate of achievement. The PDF certificate is for £9.99, and it will be sent to you immediately after through e-mail. You can get the hard copy for £15.99, which will reach your doorsteps by post. Who Is This Course For: The course is ideal for those who already work in this sector or are an aspiring professional. This course is designed to enhance your expertise and boost your CV. Learn key skills and gain a professional qualification to prove your newly-acquired knowledge. Requirements: The online training is open to all students and has no formal entry requirements. To study the Basic Procrastination Solution, all your need is a passion for learning, a good understanding of English, numeracy, and IT skills. You must also be over the age of 16. Course Content Unit 01: First Concepts and Brain Chemistry Introduction and First Concepts 00:02:00 The Science behind Procrastination 00:09:00 How Procrastination Can Destroy You 00:09:00 Unit 02: How to Beat Beating Procrastination Manage Your Time - Manage Your Life er 00:11:00 How Highly Successful Individual 00:06:00 Unit 03: Additional Strategies for Beating Procrastination Good Vs Bad Procrastination 00:08:00 Don't Be Afraid to Say No 00:06:00 Unit 04: Final Thoughts and Ideas Final Thoughts and ideas 00:02:00 Frequently Asked Questions Are there any prerequisites for taking the course? There are no specific prerequisites for this course, nor are there any formal entry requirements. All you need is an internet connection, a good understanding of English and a passion for learning for this course. Can I access the course at any time, or is there a set schedule? You have the flexibility to access the course at any time that suits your schedule. Our courses are self-paced, allowing you to study at your own pace and convenience. How long will I have access to the course? For this course, you will have access to the course materials for 1 year only. This means you can review the content as often as you like within the year, even after you've completed the course. However, if you buy Lifetime Access for the course, you will be able to access the course for a lifetime. Is there a certificate of completion provided after completing the course? Yes, upon successfully completing the course, you will receive a certificate of completion. This certificate can be a valuable addition to your professional portfolio and can be shared on your various social networks. Can I switch courses or get a refund if I'm not satisfied with the course? We want you to have a positive learning experience. If you're not satisfied with the course, you can request a course transfer or refund within 14 days of the initial purchase. How do I track my progress in the course? Our platform provides tracking tools and progress indicators for each course. You can monitor your progress, completed lessons, and assessments through your learner dashboard for the course. What if I have technical issues or difficulties with the course? If you encounter technical issues or content-related difficulties with the course, our support team is available to assist you. You can reach out to them for prompt resolution.

The Science of Performance The concept of performance takes up a central place in our world. It is one of the key metrics in our lives and has a prominent place, even at an early age. It is considered in school, sports, relationships, work, and of course, projects. In this session, we'll leverage history, current events, experiential learning, and science to explain what performance is, what drives it, and most importantly, what that means for you and any person at work. We'll consider a number of experiments, designed to drive value against today's challenges. From creating "intensity without pressure" to encouraging every colleague to play a "game of impact";, attendees will leave with a foundation from which to thoughtfully tweak their own operating models, performance, and experience. This and other IIL Learning in Minutes presentations qualify for PDUs. Some titles, such as Agile-related topics may qualify for other continuing education credits such as SEUs, or CEUs. Each professional development activity yields one PDU for one hour spent engaged in the activity. Some limitations apply and can be found in the Ways to Earn PDUs section that discusses PDU activities and associated policies. Fractions of PDUs may also be reported. The smallest increment of a PDU that can be reported is 0.25. This means that if you spent 15 minutes participating in a qualifying PDU activity, you may report 0.25 PDU. If you spend 30 minutes in a qualifying PDU activity, you may report 0.50 PDU.

Quality Guarantee: Promising training excellence, satisfaction gurantee Accredited by CPD UK & Quality License Scheme Tutor Support Unlimited support via email, till you complete the course Recognised Certification: Accepted by thousands of professional bodies Start Anytime With 1 year access to the course materials Online Learning Learn from anywhere, whenever you want Excel is an essential tool for data management and analysis and in this course, you will master everything from the fundamentals to advanced functionalities. You will learn to navigate the interface, create and format spreadsheets and perform calculations with ease and you will unlock the true potential of Excel for business and personal use. This course at a glance Accredited by CPD UK Endorsed by Quality Licence Scheme Understand the basics of Excel Know how to use Excel at an intermediate level Be aware of sum and numerical functions Understand how to manipulate text Know about logical functions Create effective spreadsheets Be confident with lookup functionality and date and time functions Easily use financial functions and sort and filter Progress to using Microsoft Excel at an advanced level Know how to create accurate and clear visual presentations Consolidate and validate data Use pivot table and what-if analysis Understand automation and macros Why Microsoft Excel Training Course right for you? Develop advanced skills in Microsoft Excel training course basic to advanced course, with this course. Learn from scratch or build on prior knowledge, to gain a good understanding of Excel functions. You will learn to accelerate your tasks efficiently using Excel techniques and formulae. The course covers how to create professional reports in no time, with Excel tools for data analysis and creating charts. This course will demystify the functions and tools in easy steps. It will teach you to work smart and save time. It is an excellent addition to your CV and is a valued skill in all businesses. Microsoft Excel Training Course Details Accredited by CPD certificates are accepted by thousands of professional bodies and government regulators here in the UK and around the world. Many organisations look for employees with CPD requirements, which means, that by doing this course, you would be a potential candidate in your respective field.   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. Course Curriculum Microsoft Excel: Basic Level Introduction to Microsoft Excel 0101 Touring the Interface 0102 Enter Data & Saving Workbook 0103 Applying Formulas 0104 Changing a Worksheet's Structure 0105 Find, Replace & Spell Check 0106 Applying Fonts, Background Colors, and Borders 0107 Formatting Numbers and Dates 0108 Making the Fieces fit 0109 Inserting Headers & Footers and Repeating Rows 0110 Managing Large Workbooks Microsoft Excel: Intermediate Level Excel Essentials 0201 Formula Writing (Don't Miss This) Ex 0201 Formula Writing (Don't Miss this) Sum Count Average Functionality - With Conditions 0301 SumIf & SumIfs Ex 0301 SumIf & SumIfs 0302 Count Functions Ex 0302 Count Functions 0303 AverageIf & AverageIfs Ex 0303 AverageIf & AverageIfs Text Functions - Manipulating Text 0401 Change Case (Upper, Lower,Proper) Ex 0401 Change Case (Upper, Lower, Proper) 0402 Separating Text on Symmetrical Data Ex 0402 Separating Text on Symmetrical Data 0403 Separating Text on Non-Symmetrical Data Ex 0403 Separating Text on Non-Symmetrical Data Logical Functions - Working With Conditions 0501 If Functionality Ex 0501 IF Functionality 0502 If with AND Ex 0502 If with AND 0503 If with OR Ex 0503 If with OR 0504 If with 'AND' & 'OR' / IF with Countif Ex 0504 If with 'AND' & 'OR' / IF with Countif 0505 Nested IF (A Genie with 3 wishes) Ex 0505 Nested IF (A Genie with 3 wishes) Lookup Functionality - Burn Simple Find Technique 0601 Vlookup (Exact Match) # 1 Ex 0601 Vlookup (Exact Match) # 1 0602 Type of References (Use of $ sign) 0603 Vlookup (Exact Match) # 2 Ex 0603 Vlookup (Exact Match) # 2 0604 Double Vlookup Ex 0604 Double Vlookup 0605 Vlookup on Duplicate Values Ex 0605 Vlookup on Duplicate Values 0606 Vlookup (Approximate Match) Ex 0606 Vlookup (Approximate Match) 0607 Vlookup with If (Conditional Vlookup) Ex 0607 Vlookup with If (Conditional Vlookup) 0608 Hlookup (Exact Match) Ex 0608 Hlookup (Exact Match) 0609 Hlookup (Approximate Match) Ex 0609 Hlookup (Approximate Match) 0610 Lookup (Don't use this !) Ex 0610 Lookup (Don't use this !) 0611 Vlookup with Match (Create Magical Vlookup) Ex 0611 Vlookup with Match (Create Magical Vlookup) 0612 Match (Gives us Column/Row Index #) Ex 0612 Match (Gives us Column/Row Index #) 0613 Index & Match (Made for Each Other) Ex 0613 (1) Index & Match (Made for Each Other) Ex 0613 (2) Index & Match (Made for Each Other) Date & Time Function - A Tricky Game 0701 How Excel Records Date & Time 0702 Now, Today & Autofill 0703 DateValue & TimeValue 0704 Calculate WorkingDays 0705 DatedIf Financial Functions 0801 Loan Calculation (PMT, PPMT, IPMT etc.) Ex 0801 Loan Calculation (PMT, PPMT, IPMT etc.) 0802 Creating a Loan Table Ex 0802 Creating a Loan Table 0803 Calculate Depriciation Ex 0803 Calculate Depriciation Sort & Filter 0901 Basic Sorting & Shortcut keys Ex 0901 Basic Sorting & Shortcut keys 0902 Sorting Using Custom List Ex 0902 Sorting Using Custom List 0903 Horizontal Sorting Ex 0903 Horizontal Sorting 0904 Basic Filter & Shortcut Keys Ex 0904 Basic Filter & Shortcut Keys 0905 Filter Problem # 1 (Copy Filtered Data without hidden rows) Ex 0905 Filter Problem # 1 (Copy Filtered Data without hidden rows) 0906 Filter Problem # 2 (Pasting Values on Filtered Data) Ex 0906 Filter Problem # 2 (Pasting Values on Filtered Data) 0907 Filter Problem # 3 (Performing Calculation on Filtered Data) Ex 0907 Filter Problem # 3 (Performing Calculation on Filtered Data) 0908 Advanced Filter (Applying Complex Criteria's) Ex 0908 Advanced Filter (Applying Complex Criteria's) Microsoft Excel: Advanced Level Excel Charts - Visual Presentation 1001 How to create a chart 1002 Format Axis 1003 Plot Values on Secondary Axis 1004 Life of Pie (Charts) 1005 How to Show Axis Title 1006 How to Show Data Label 1007 Show data with chart in Data Table 1008 Column Chart 1009 Bar Chart 1010 Line Chart 1 1011 Line Chart 2 1012 Area Chart 1013 Pie Chart 1014 Pie of Pie or Bar of Pie 1015 Line Chart with Log Scale 1016 Bubble Chart 1017 Selecting Chart Elements 1018 Use of Format Dialog box 1019 Modifying Chart & Plot Area 1020 Modifying Data Series 1021 How to handle Missing Data 1022 Modifying 3-D Charts 1023 Creating Combination of upto 5 Different Charts 1025 Creating Picture Charts Data Consolidation - Multiple WorkBooks WorkSheets Consolidate Data using Excel Inbuilt Function Ex Consolidate Data using Excel Inbuilt Function Data Validation 1201 Applying Data Validation Ex 1201 Applying Data Validation 1202 Dependent Dropdown List Ex1202 Dependent Dropdown List Using Data Validation with Vlookup & Match Other Data Validation Examples Protection of Worksheet Workbook 1301 Worksheet Level Protection Ex 1301 Worksheet Level Protection 1302 Cell Level Protection Ex 1302 Cell Level Protection 1303 Hiding Formulas from Formula Bar Ex 1303 Hiding Formulas from Formula Bar 1304 Protecting Workbook Structure Ex 1304 Protecting Workbook Structure 1305 Workbook Level Protection Ex 1305 Workbook Level Protection Pivot Table & Techniques 1401 Understanding pivot Table 1402 Using Pivot Table in Real Scenario Ex 1402 Using Pivot Table in Real Scenario 1403 Grouping in Pivot Table Ex 1403 Grouping in Pivot Table 1404 Using Slicers (A Visually attractive Filter) Ex 1404 Using Slicers (A Visually attractive Filter) What-If Analysis & Solver Add-In 1501 Goal Seek (A Reverse Approach) Ex 1501 Goal Seek (A Reverse Approach) 1502 One Way Data Table 1503 Two Way Data Table 1504 Scenario Manager 1505 Solver Add-In Automation in Excel - Macros 1601 Record your first Macro 1602 Record Another Macro 1603 Assigning macro to a Shape, Button, Picture etc 1604 Editing or Deleting a Macro 1605 Security Settings of a Macro Who should take this course? Absolute beginners to Microsoft Excel People who wish to use Microsoft Excel more confidently People who wish to refresh their existing skills in Microsoft Excel Entry Requirements There are no academic entry requirements for this Microsoft Excel training course basic to advanced course, and it is open to students of all academic backgrounds. However, you are required to have a laptop/desktop/tablet or smartphone and a good internet connection. Assessment Method This Microsoft Excel training course basic to advanced 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 can grasp from each section. In the assessment pass mark is 60%. Certification Endorsed Certificate from Quality Licence Scheme After successfully passing the MCQ exam you will be eligible to order the Endorsed Certificate by Quality Licence Scheme. 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. It will give you a competitive advantage in your career, making you stand out from all other applicants and employees. There is a Quality Licence Scheme endorsement fee to obtain an endorsed certificate which is £65. Certificate of Achievement from Lead Academy After successfully passing the MCQ exam you will be eligible to order your certificate of achievement as proof of your new skill. The certificate of achievement is an official credential that confirms that you successfully finished a course with Lead Academy. Certificate can be obtained in PDF version at a cost of £12, and there is an additional fee to obtain a printed copy certificate which is £35. FAQs Is CPD a recognised qualification in the UK? CPD is globally recognised by employers, professional organisations and academic intuitions, thus a certificate from CPD Certification Service creates value towards your professional goal and achievement. CPD-certified certificates are accepted by thousands of professional bodies and government regulators here in the UK and around the world. Are QLS courses recognised? Although QLS courses are not subject to Ofqual regulation, they must adhere to an extremely high level that is set and regulated independently across the globe. A course that has been approved by the Quality Licence Scheme simply indicates that it has been examined and evaluated in terms of quality and fulfils the predetermined quality standards. When will I receive my certificate? For CPD accredited PDF certificate it will take 24 hours, however for the hardcopy CPD certificate takes 5-7 business days and for the Quality License Scheme certificate it will take 7-9 business days. Can I pay by invoice? Yes, you can pay via Invoice or Purchase Order, please contact us at info@lead-academy.org for invoice payment. Can I pay via instalment? Yes, you can pay via instalments at checkout. How to take online classes from home? Our platform provides easy and comfortable access for all learners; all you need is a stable internet connection and a device such as a laptop, desktop PC, tablet, or mobile phone. The learning site is accessible 24/7, allowing you to take the course at your own pace while relaxing in the privacy of your home or workplace. Does age matter in online learning? No, there is no age limit for online learning. Online learning is accessible to people of all ages and requires no age-specific criteria to pursue a course of interest. As opposed to degrees pursued at university, online courses are designed to break the barriers of age limitation that aim to limit the learner's ability to learn new things, diversify their skills, and expand their horizons. When I will get the login details for my course? After successfully purchasing the course, you will receive an email within 24 hours with the login details of your course. Kindly check your inbox, junk or spam folder, or you can contact our client success team via info@lead-academy.org

Learning Objectives Introduction , Customizing Excel , Analyzing Data with Logical Functions , Working with Lookup Functions , Using Text Functions , Working with Date and Time Functions , Formula Auditing , What-If Analysis , Worksheet and Workbook Protection , Automating with Macros , Working with Form Controls , Ensuring Data Integrity , Collaborating in Excel , Importing and Exporting Data to a Text File , Conclusion   Pre-Requisites Excel 365 Introduction and Intermediate courses or equivalent experience.   Description This course will teach students advanced concepts and formulas in Microsoft Excel 365. Students will learn functions such as SUMIF, AVERAGEIF, and COUNTIF, advanced lookup functions, and complex logical and text functions. Additionally, students will experiment with auditing formulas and error checking, use the What-If Analysis tools, learn the options for worksheet and workbook protection, review advanced use of PivotTables and PowerPivot add-in, work with Macros, use form controls, and ensure data integrity in their worksheets and workbooks. Students will also learn about Excel's many collaboration features and import and export data to and from their workbooks. Course Introduction Introduction 00:01:00 Section 01 Lesson 01-Customizing the Ribbon 00:09:00 Lesson 02-Customizing the Quick Access Toolbar 00:06:00 Lesson 03-Customizing the General and Formula Options 00:04:00 Lesson 04-Customizing the AutoCorrect Options 00:03:00 Lesson 05-Customizing the Save Defaults 00:04:00 Lesson 06-Customizing Advanced Excel Options 00:03:00 Section 02 Lesson 01-Working with the Most Common Logical Functions 00:03:00 Lesson 02-Understanding IF Functions 00:06:00 Lesson 03-Evaluating Data with the AND Function 00:05:00 Lesson 04-Evaluating Data with the OR Function 00:03:00 Lesson 05-Creating a Nested IF Function 00:05:00 Lesson 06-Using the IFS Function 00:03:00 Lesson 07-Summarizing Data with SUMIF 00:03:00 Lesson 08-Summarizing Data with AVERAGEIF 00:02:00 Lesson 09-Summarizing Data with COUNTIF 00:02:00 Lesson 10-Summarizing Data with MAXIFS and MINIFS 00:03:00 Lesson 11-Using the IFERROR Function 00:03:00 Section 03 Lesson 01-What are Lookup Functions 00:03:00 Lesson 02-Using VLOOKUP 00:08:00 Lesson 03-Using HLOOKUP 00:03:00 Lesson 04-Using VLOOKUP with TRUE 00:04:00 Lesson 05-Using HLOOKUP with TRUE 00:02:00 Lesson 06-Using the Index Function 00:03:00 Lesson 07-Using the MATCH Function 00:03:00 Lesson 08-Combining INDEX and MATCH 00:04:00 Lesson 09-Comparing Two Lists with VLOOKUP 00:02:00 Lesson 10-Comparing Two Lists with VLOOKUP and ISNA 00:04:00 Lesson 11-Using the New XLookup Function-v2 00:07:00 Lesson 12-Using Dynamic Array functions-v2 00:06:00 Lesson 13-Other New Functions-v2 00:04:00 Section 04 Lesson 01-What are Text Functions 00:01:00 Lesson 02-Using CONCAT, CONCATENATE, AND TEXTJOIN 00:04:00 Lesson 03-Using Text to Columns 00:02:00 Lesson 04-Using LEFT, RIGHT, and MID Functions 00:03:00 Lesson 05-Using UPPER, LOWER, and PROPER Functions 00:02:00 Lesson 06-Using the Len Function 00:03:00 Lesson 07-Using the Trim Function 00:01:00 Lesson 08-Using the SUBSTITUTE Function 00:02:00 Section 05 Lesson 01-What are Date and Time Functions 00:02:00 Lesson 02-Using TODAY, NOW, and DAY Functions 00:03:00 Lesson 03-Using NETWORKDAYS and YEARFRAC Functions 00:03:00 Section 06 Lesson 01-Showing Formulas 00:03:00 Lesson 02-Tracing Precedents and Dependents 00:04:00 Lesson 03-Adding a Watch Window 00:04:00 Lesson 04-Error Checking 00:04:00 Section 07 Lesson 01-Using the Scenario Manager 00:07:00 Lesson 02-Using Goal Seek 00:03:00 Lesson 03-Analyzing with Data Tables 00:04:00 Section 08 Lesson 01-Understanding Protection 00:02:00 Lesson 02-Encrypting Files with Passwords 00:05:00 Lesson 03-Allowing Specific Worksheet Changes 00:02:00 Lesson 04-Adding Protection to Selected Cells 00:03:00 Lesson 05-Additional Protection Features 00:03:00 Section 09 Lesson 01-What are Macros 00:03:00 Lesson 02-Displaying the Developer Tab 00:03:00 Lesson 03-Creating a Basic Formatting Macro 00:05:00 Lesson 04-Assigning a Macro to a Button 00:03:00 Lesson 05-Creating Complex Macros 00:04:00 Lesson 06-Viewing and Editing the VBA Code 00:04:00 Lesson 07-Adding a Macro to the Quick Access Toolbar 00:03:00 Section 10 Lesson 01-What are Form Controls 00:02:00 Lesson 02-Adding a Spin Button and Check Boxes 00:04:00 Lesson 03-Adding a Combo Box 00:07:00 Section 11 Lesson 01-What is Data Validation 00:02:00 Lesson 02-Restricting Data Entry to the Whole Numbers 00:02:00 Lesson 03-Restricting Data Entry to a List 00:04:00 Lesson 04-Restricting Data Entry to a Date 00:02:00 Lesson 05-Restricting Data Entry to Specific Text Lengths 00:01:00 Lesson 06-Composing Input Messages 00:02:00 Lesson 07-Composing Error Alerts 00:03:00 Lesson 08-Finding Invalid Data 00:02:00 Lesson 09-Editing and Deleting Validation Rules 00:01:00 Section 12 Lesson 01-Working with Comments-v2 00:03:00 Lesson 02-Printing Comments and Errors 00:02:00 Lesson 03-Sharing a Workbook 00:04:00 Lesson 04-Co-Authoring in Excel 00:02:00 Lesson 05-Tracking Changes in a Workbook 00:03:00 Lesson 06-Working with Versions 00:03:00 Lesson 07-Sharing files Via Email-v2 00:03:00 Section 13 Lesson 01-Importing a Text File 00:04:00 Lesson 02-Exporting Data to a Text File 00:01:00 Course Recap Recap 00:02:00 Additional Materials Resource - Excel 365 Advanced 00:00:00 Final Exam Final Exam - Excel 365 Advanced 00:20:00