2533 Courses delivered Online

Overview Learn to use the full power and functionality of Microsoft's Excel and deliver impressive charts and analysis work. This Advanced Diploma in MS Excel course allows you to exploit the full abilities of Microsoft's best-selling tool and become capable of providing higher-quality results from it. You may use Excel every day in your work or business, but are you really using it to its full potential? With the advanced training from this course, you will quickly produce stunning spreadsheets and visually perfect graphs that will showcase business data to a much more professional degree. Use Excel to make your customer service excellent. How will I get my certificate? At the end of the course there will be a written assignment test which you can take either during or after the course. After successfully completing the test you will be able to order your certificate, these are included in the price. Who is this course for? There is no experience or previous qualifications required for enrolment on this Advanced Diploma in MS Excel. It is available to all students, of all academic backgrounds. Requirements Our Advanced Diploma in MS Excel is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible on tablets and smartphones so you can access your course on wifi, 3G or 4G. There is no time limit for completing this course, it can be studied in your own time at your own pace. Career path Having these various qualifications will increase the value in your CV and open you up to multiple sectors such as Business & Management , Admin, Accountancy & Finance, Secretarial & PA, Teaching & Mentoring etc. Course Curriculum 21 sections • 90 lectures • 22:14:00 total length •Introduction to Microsoft Excel 2019 New Features: 00:07:00 •CONCAT: 00:02:00 •IFS: 00:01:00 •MAXIFS: 00:01:00 •MINIFS: 00:01:00 •SWITCH: 00:02:00 •TEXTJOIN: 00:01:00 •Map Chart: 00:02:00 •Funnel Chart: 00:01:00 •Better Visuals: 00:06:00 •Pivot Table Enhancements: 00:02:00 •Power Pivot Updates: 00:01:00 •Navigate the Excel User Interface: 00:28:00 •Use Excel Commands: 00:10:00 •Create and Save a Basic Workbook: 00:19:00 •Enter Cell Data: 00:12:00 •Use Excel Help: 00:05:00 •Create Worksheet Formulas: 00:15:00 •Insert Functions: 00:17:00 •Reuse Formulas and Functions: 00:17:00 •Insert, Delete, and Adjust Cells, Columns, and Rows: 00:10:00 •Search for and Replace Data: 00:09:00 •Use Proofing and Research Tools: 00:07:00 •Apply Text Formats: 00:16:00 •Apply Number Format: 00:08:00 •Align Cell Contents: 00:09:00 •Apply Styles and Themes: 00:12:00 •Apply Basic Conditional Formatting: 00:11:00 •Create and Use Templates: 00:08:00 •Preview and Print a Workbook: 00:10:00 •Set Up the Page Layout: 00:09:00 •Configure Headers and Footers: 00:07:00 •Manage Worksheets: 00:05:00 •Manage Workbook and Worksheet Views: 00:07:00 •Manage Workbook Properties: 00:06:00 •Work with Ranges: 00:18:00 •Use Specialized Functions: 00:11:00 •Work with Logical Functions: 00:23:00 •Work with Date & Time Functions: 00:08:00 •Work with Text Functions: 00:11:00 •Sort Data: 00:10:00 •Filter Data: 00:10:00 •Query Data with Database Functions: 00:09:00 •Outline and Subtotal Data: 00:09:00 •Apply Intermediate Conditional Formatting: 00:07:00 •Apply Advanced Conditional Formatting: 00:05:00 •Create Charts: 00:13:00 •Modify and Format Charts: 00:12:00 •Use Advanced Chart Features: 00:12:00 •Create a PivotTable: 00:13:00 •Analyze PivotTable Data: 00:12:00 •Present Data with PivotCharts: 00:07:00 •Filter Data by Using Timelines and Slicers: 00:11:00 •Use Links and External References: 00:12:00 •Use 3-D References: 00:06:00 •Consolidate Data: 00:05:00 •Use Lookup Functions: 00:12:00 •Trace Cells: 00:09:00 •Watch and Evaluate Formulas: 00:08:00 •Collaborate on a Workbook: 00:19:00 •Protect Worksheets and Workbooks: 00:08:00 •Apply Data Validation: 00:13:00 •Search for Invalid Data and Formulas with Errors: 00:04:00 •Work with Macros: 00:18:00 •Create Sparklines: 00:07:00 •MapData: 00:07:00 •Determine Potential Outcomes Using Data Tables: 00:08:00 •Determine Potential Outcomes Using Scenarios: 00:09:00 •Use the Goal Seek Feature: 00:04:00 •Forecasting Data Trends: 00:05:00 •Create a Macro Using the Macro Recorder: 01:00:00 •Edit a Macro: 01:00:00 •Debug a Macro: 00:30:00 •Customize the Quick Access Toolbar and Hotkeys: 00:30:00 •Set Macro Security: 01:00:00 •Insert Text: 00:30:00 •Format Text: 00:30:00 •Sort Data: 00:30:00 •Duplicate Data: 01:00:00 •Generate a Report: 01:00:00 •Determine the Dialog Box Type: 00:15:00 •Capture User Input: 01:00:00 •Insert, Copy, and Delete Worksheets: 00:30:00 •Rename Worksheets: 00:30:00 •Modify the Order of Worksheets: 00:15:00 •Print Worksheets: 00:30:00 •Create User-Defined Functions: 00:30:00 •Automate SUM Functions: 00:30:00 •Resources - Microsoft Excel - Beginner Course - Cpd Accredited: 00:00:00 •Assignment - Advanced Diploma in MS Excel: 00:05:00

QLS Endorsed + CPD QS Accredited - Dual Certification | Instant Access | 24/7 Tutor Support

Deal Price is Active! Offer Ends Soon; Hurry Up!! Statistical data shows that the food service industry is one of the fastest-growing sectors, with a projected growth rate of 3.4% from 2021 to 2026. As a result, there is an increasing demand for skilled and knowledgeable waiters who can provide excellent customer service. If you are looking to start a career in the food service industry, our Waiter Training Diploma is the perfect course for you. This Diploma in Waiter Training at QLS Level 4 course is endorsed by The Quality Licence Scheme and accredited by CPDQS (with 120 CPD points) to make your skill development & career progression more accessible than ever! Our comprehensive Waiter Training Diploma curriculum covers all the essential skills and knowledge required to excel in the food service industry. From the first impression you make to safety considerations, our Waiter Training Diploma course covers everything you need to know to become a successful waiter. With expert guidance from industry professionals, you will learn how to provide exceptional customer service while maintaining the highest standards of personal hygiene and safety. Upon completion of this Waiter Training Diploma, you will have developed a range of skills and knowledge required to work in the food service industry. You will be able to provide excellent customer service, maintain personal hygiene and safety, handle food safely, and work as a team player. You will also have a good understanding of supervisory responsibilities and safety considerations. After this Waiter Training Diploma, you will be able to learn: Understand the food service industry and the role of waiters Develop a positive first impression and friendly attitude Maintain personal hygiene and handle food safely Provide excellent customer service and product knowledge Understand service sequences and additional responsibilities Ensure safety considerations for customers and staff Start your learning journey straight away with this Waiter Training Diploma and take a step toward a brighter future! Why Prefer this Waiter Training Diploma? Opportunity to earn certificate a certificate endorsed by the Quality Licence Scheme & another certificate that is accredited by CPDQS. Get a free student ID card! (£10 postal charge will be applicable for international delivery). Innovative and engaging content. Free assessments. 24/7 tutor support. *** Course Curriculum *** Here is the curriculum breakdown of the course: Diploma in Professional Waiter Training at QLS Level 4 Module 01: Customer Service and Service Sequence Module 02: Equipment Handling Technique Module 03: Hygiene Module 04: Beverage and Tobacco Module 05: Understanding Risks and Preventive Measures Module 06: Food & Beverage Control and Selling Techniques Module 07: Tips and Hints for Success in the Waiter profession Assessment Process We offer an integrated assessment framework to make the process of evaluation and accreditation for learners easier. You have to complete the assignment questions given at the end of the course and score a minimum of 60% to pass each exam. Our expert trainers will assess your assignment and give you feedback after you submit the assignment. You will be entitled to claim a certificate endorsed by the Quality Licence Scheme after you have completed all the Diploma in Waiter Training at QLS Level 4 exams. CPD 120 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Individuals looking to start a career in the food service industry Experienced waiters looking to enhance their skills and knowledge Hospitality professionals seeking to understand waiter responsibilities Requirements The Waiter Training Diploma does not require any prior knowledge; anyone can participate! This course is open to anyone who is interested in learning from anywhere in the world. Career path Waiter/Waitress (average salary £16,000 - £24,000) Bartender (average salary £16,000 - £25,000) Food and Beverage Supervisor (average salary £20,000 - £28,000) Catering Assistant (average salary £16,000 - £20,000) Restaurant Manager (average salary £25,000 - £40,000) Hotel Receptionist (average salary £18,000 - £25,000) Certificates CPDQS Accredited Certificate Digital certificate - £10 Diploma in Professional Waiter Training at QLS Level 4 Hard copy certificate - £99 Show off Your New Skills with a Certification of Completion After successfully completing the Diploma in Professional Waiter Training at QLS Level 4 course, you can order an original hardcopy certificate of achievement endorsed by the Quality Licence Scheme. The certificate will be home-delivered, with a pricing scheme of - 99 GBP inside the UK 109 GBP (including postal fees) for international delivery CPDQS Accredited Certificate 29 GBP for Printed Hardcopy Certificate inside the UK 39 GBP for Printed Hardcopy Certificate outside the UK (international delivery)

QLS Endorsed + CPD QS Accredited - Dual Certification | Instant Access | 24/7 Tutor Support

QLS Endorsed + CPD QS Accredited - Dual Certification | Instant Access | 24/7 Tutor Support

QLS Endorsed + CPD QS Accredited - Dual Certification | Instant Access | 24/7 Tutor Support

QLS Endorsed + CPD QS Accredited - Dual Certification | Instant Access | 24/7 Tutor Support |

QLS Endorsed + CPD QS Accredited - Dual Certification | Instant Access | 24/7 Tutor Support

QLS Endorsed + CPD QS Accredited - Dual Certification | Instant Access | 24/7 Tutor Support

Overview The Level 4 Award in the Internal Quality Assurance of Assessment Processes and Practices (RQF) is aimed for people who are responsible for maintaining the quality of assessment within an organisation or assessment centre. You will be able to evaluate knowledge and develop an understanding of the concepts and methods that support internal quality assurance of assessment by completing this qualification. You'll also learn how to assess the work of a learning and development practitioner who is in charge of internal assessment quality assurance.So gear up and join up right away! Benefits you will gain: Top-notch e-learning materials Modules availability 24/7 An easy-to-use online learning platform Flexible learning hours Level 4 Award in the Internal Quality Assurance of Assessment Processes and Practice (Regulated qualification) Exquisite customer service Qualification Focus Awards Level 4 Award in the Internal Quality Assurance of Assessment Processes and Practices (RQF). Description Learners must accomplish all 2 mandatory units to achieve a total credit of 12.From this course, you will: Maintain legal and good practice requirements when internally monitoring and maintaining the quality of assessment. Internally manage relevant information and improve the quality of assessment. Understand techniques and criteria for monitoring the quality of assessment internally. Acknowledge the context and principles of internal quality assurance. Plan the internal quality assurance of assessment Be able to evaluate requirements for information management, data protection and confidentiality. Qualification Purpose The goal of this Level 4 Award in the Internal Quality Assurance of Assessment Processes and Practices (RQF) qualification is to certify competence in an occupational position to the relevant requirements. It is aimed at people who are responsible for maintaining and improving assessment quality within an organisation or assessment centre. Progression Successful learners can progress to other qualifications such as: Focus Award Level 4 Award in Externally Assuring the Quality of Assessment Processes and Practice (RQF) Focus Award Level 4 Diploma in Learning and Development (RQF) Who is this course for? The Level 4 Award in the Internal Quality Assurance of Assessment Processes and Practices (RQF) is designed for people who desire to work as quality assurance employees. Individuals who want to get a sought-after assessment certificate, as well as the necessary knowledge and understanding required of quality assurance employees, will profit from this excellent training. Entry Requirements There are no specific entry requirements for this qualification. This qualification is accredited for learners who are at least 16 years old or above. Total Qualification Time Total Qualification Time is comprised of GLH and an estimate of the number of hours a learner is likely to spend in preparation, study or any other learning, including assessment, which takes place as directed by, but not under the supervision of a lecturer, supervisor or tutor. Total Qualification Time for this qualification is 120 hours.Guided Learning HoursThese hours are made up of all contact time, guidance, or supervision of a learner by a lecturer, supervisor, tutor, trainer, or other appropriate education or training providers. Guided Learning Hours for this qualification is 90. Method of Assessment: The Level 4 Award in the Internal Quality Assurance of Assessment Processes and Practices (RQF) is internally assessed and externally assured by Focus Awards. Each learner is required to create a portfolio of evidence that demonstrates the achievement of all the learning outcomes and the assessment criteria associated with each unit. The main pieces of evidence for the portfolio could include: Assessor observation - completed observational checklists on related action plans Witness testimony Learner product Worksheets Assignments / projects / reports Record of oral and written questioning Learner and peer reports Recognition of prior learning (RPL) Evidence may be drawn from actual or simulated situations where appropriate and permitted by the relevant Sector Skills Council or Sector Skills Body. Career path After receiving the Level 4 Award in the Internal Quality Assurance of Assessment Processes and Practices (RQF) certification, you would be eligible to function as a competent professional as: Professional EQA Professional IQA Practitioner Course Curriculum 20 sections • 45 lectures • 10:50:00 total length •Induction Form: 00:00:00 •Registration Entry Form: 00:00:00 •Getting Started - Level 4 Award in Internal Quality Assurance of Assessment Processes & Practice (RQF): 00:00:00 •Self-Assessment Grid: Understanding The Principles And Practices Of Internally Assuring The Quality Of Assessment: 00:00:00 •Guidance For Achieving Understanding The Principles And Practices Of Internally Assuring The Quality Of Assessment Unit: 00:25:00 •Assessment Plan: Understanding The Principles And Practices Of Internally Assuring The Quality Of Assessment: 00:00:00 •An introduction to the Internal Quality Assurance (IQA) Units: 00:15:00 •Key Concepts and Principles of IQA: 00:20:00 •Planning IQA Activities: 00:20:00 •Standardising Assessment and IQA Practice: 00:10:00 •IQA Records: 00:10:00 •Making IQA Decisions and Providing Feedback: 00:20:00 •Evaluating IQA Practice, and Continuing Professional Development: 00:05:00 •IQA Roles and Responsibilities: 00:05:00 •Quality Assurance Cycle: 00:10:00 •Table of Example IQA Records: 00:05:00 •Managing Risks: 00:05:00 •Equality and Diversity, and The Equality Act 2010: 00:10:00 •Equality and Diversity - Glossary of Terms: 00:15:00 •Templates - A full set of IQA Plans and Records: 00:00:00 •A full set of completed examples of IQA Plans and Records: 00:20:00 •Template - Standardisation Record for Assessed Work: 00:00:00 •Completed Example of a Standardisation Record for Assessed Work: 00:05:00 •Template - Personal Development Plan: 00:00:00 •Completed Example of a Personal Development Plan: 00:05:00 •Template - Continuing Professional Development Record: 00:00:00 •Completed Example of a Continuing Professional (CPD) Development Record: 00:05:00 •Template - Reflective Learning Journal: 00:00:00 •Completed Example of a Reflective Learning Journal (RLJ): 00:05:00 •Preparing for an EQA Visit: 00:10:00 •Checklist for Equality and Diversity: 00:10:00 •An introduction to the Internal Quality Assurance (IQA) Units: 00:40:00 •Key Concepts and Principles of IQA: 00:55:00 •Planning IQA Activities: 00:50:00 •Standardising Assessment and IQA Practice: 00:50:00 •IQA Records: 00:50:00 •Making IQA Decisions and Providing Feedback: 01:15:00 •Evaluating IQA practice, and Continuing Professional Development: 01:15:00 •Self-Assessment Grid: Internally Assure The Quality Of Assessment: 00:00:00 •Guidance For Achieving The Internally Assure The Quality Of Assessment Unit: 00:20:00 •Assessment Plan: Internally Assure The Quality Of Assessment: 00:00:00 •Observation And Question Checklist For IQA Unit Two: Internally Assure The Quality Of Assessment: 00:00:00 •Assessment - Level 4 Award in Internal Quality Assurance of Assessment Processes & Practice (RQF): 00:00:00 •Submit Your Assignments: 00:00:00 •Resubmit Your Assignments - Level 4 Award in the Internal Quality Assurance of Assessment Processes and Practice (RQF): 00:00:00