8291 Courses in Liverpool delivered On Demand

Getting Started ILM Level 2 Certificate in Team Leading course is designed to provide new and aspiring team leaders with a thorough understanding of the leadership role and its wide-ranging responsibilities. As a widely accepted and nationally recognised course, it is an ideal platform to start your journey towards a successful leadership career. This course aims to provide a thorough understanding of core team-leading competencies, such as communication, motivation, and performance management, while also looking into the specific areas of leadership relevant to your workplace context. Through an extensive selection of modules you will have the flexibility to tailor your learning experience to align with your career aspirations and professional development goals. Key Benefits For Learners Develop the core skills to lead a team successfully Learn motivation techniques to get the best from people Build the confidence to tackle difficult issues, like underperformance Familiar with the tools to develop yourself as a leader For Organisations Provide team leaders with extensive training to ensure they have the required skills to lead their teams effectively. Equip staff with the competence and knowledge needed to effectively manage people Cultivate strong relationships within and outside the organisation. Encourage staff to engage in continuous learning and development Foster a culture of open communication, active listening, and seamless collaboration which paves way to increased productivity and job satisfaction. Career Pathways The ILM Level 2 Team Leading can open many career pathways including, but not limited to: Team Leader, with an estimated average salary of £27,835 per annum Supervisor, with an estimated average salary of £22,480 per annum Team Coordinator, with an estimated average salary of £25634 per annum About Awarding Body Institute of Leadership & Management (ILM) is a professional body that helps people worldwide improve their leadership capabilities and advance their careers. All ILM qualifications are awarded by The City and Guilds of London Institute, founded in 1878 and incorporated into the Royal Charter. ILM qualifications are regulated and approved by Ofqual, the governing body for qualifications in the UK. What is included? Learn 100% online at your own pace Dedicated support from expert tutors Dedicated Support Desk Portal: You can raise queries, request tutor support and ask for a call back whenever you need guidance and assistance. Elevate Knowledge: Your tutors will provide formative assessment feedback for each module, helping you improve your achievements throughout the program Schedule online personal tutor meetings whenever you want, which will help you get the most out of your studies and provide guidance, support and encouragement 10 months support period 24-hour access to the online learning platform 'MyLearnDirect' Schedule live online classes for each module at your convenience. (Blended learning only) Quality learning resources and study guides developed by ILM-approved tutors. All assessment materials are conveniently accessible through the online learning platform 'MyLearnDirect' Induction: We offer online and flexible learning induction to help you settle in and prepare for your online studies ILM Membership - You will receive 12 months of the Institute of Leadership & Management membership, bringing access to a wealth of resources to support your leadership development. ILM Digital credentials - Validate your skills and share achievements anywhere, anytime using Digital Credentials Assessment For each module you study, you will complete a written assignment of 1500-2000 words and submit it online at your MyLearnDirect learning portal. The submitted assignments will be assessed by your ILM-approved tutor. Entry Requirements ILM Level 2 Certificate in Team Leading is designed for new aspiring team leaders, which gives an in-depth introduction to the role and responsibilities of a team leader. To be eligible for this course, you must: Be 18 years of age and over Be new to a team leader role or have some experience in team leading or similar job role. Possess the ability to complete the Level 2 course Our friendly admissions advisors will provide the best advice, considering your needs and goals.  Progression Successful learners may progress to a range of qualifications including the following: ILM Level 3 Award or Certificate in Leadership and Management ILM Level 3 Certificate in Principles of Leadership and Management Why gain a ILM Qualification? This course is designed for team leaders, aiming to support the development of their skills in leading a team, ensuring that the team's work meets organisational objectives, and contributing to planning, problem-solving, and decision-making. The Level 2 course provides an in-depth introduction to critical roles and responsibilities for those new to a leadership position. Each module equips you with essential skills to successfully lead a team, including planning, allocating, and monitoring work. Additionally, you will learn motivation techniques and how to address complex issues such as underperformance. Successful completion of the course could lead you to progression to Level 2 or 3 courses. Through this course you will learn how to develop yourself as a Team Leader, how to improve the performance of your team and how to plan and monitor work. ILM graduates achieve remarkable things: An impressive 70,000 people take ILM qualifications every year, with 93% of employers agreeing that their managers improved after completion. ILM Membership - All ILM learners receive a minimum of 12 months membership of the Institute of Leadership & Management, bringing access to a wealth of resources to support their leadership development ILM Digital credentials - Validate skills and share achievements anywhere, anytime using Digital Credentials Learners must request before enrolment to interchange unit(s) other than the preselected units shown in the SBTL website because we need to make sure the availability of learning materials for the requested unit(s). SBTL will reject an application if the learning materials for the requested interchange unit(s) are unavailable. Learners are not allowed to make any request to interchange unit(s) once enrolment is complete. UNIT1- Solving Problems and Making Decisions Reference No : 8002-300 Credit : 2 || TQT : 20 UNIT2- Understanding Innovation and Change in an Organisation Reference No : 8002-301 Credit : 2 || TQT : 20 UNIT3- Understanding Leadership Reference No : 8002-308 Credit : 2 || TQT : 20 UNIT4- Understanding Conflict Management in the Workplace Reference No : 8002-312 Credit : 1 || TQT : 10 UNIT5- Improving Performance of the Work Team Reference No : 8002-251 Credit : 1 || TQT : 10 UNIT6- Planning and Monitoring Work Reference No : 8002-252 Credit : 2 || TQT : 20 UNIT7- Leading Your Work Team Reference No : 8002-268 Credit : 2 || TQT : 20 UNIT8- Induction and Coaching in the Workplace Reference No : 8002-254 Credit : 2 || TQT : 20 UNIT9- Developing Yourself as a Team Leader Reference No : 8002-250 Credit : 1 || TQT : 10 Delivery Methods School of Business & Technology London provides various flexible delivery methods to its learners, including online learning and blended learning. Thus, learners can choose the mode of study as per their choice and convenience. The program is self-paced and accomplished through our cutting-edge Learning Management System. Learners can interact with tutors by messaging through the SBTL Support Desk Portal System to discuss the course materials, get guidance and assistance and request assessment feedbacks on assignments. We at SBTL offer outstanding support and infrastructure for both online and blended learning. We indeed pursue an innovative learning approach where traditional regular classroom-based learning is replaced by web-based learning and incredibly high support level. Learners enrolled at SBTL are allocated a dedicated tutor, whether online or blended learning, who provide learners with comprehensive guidance and support from start to finish. The significant difference between blended learning and online learning methods at SBTL is the Block Delivery of Online Live Sessions. Learners enrolled at SBTL on blended learning are offered a block delivery of online live sessions, which can be booked in advance on their convenience at additional cost. These live sessions are relevant to the learners' program of study and aim to enhance the student's comprehension of research, methodology and other essential study skills. We try to make these live sessions as communicating as possible by providing interactive activities and presentations. Resources and Support School of Business & Technology London is dedicated to offering excellent support on every step of your learning journey. School of Business & Technology London occupies a centralised tutor support desk portal. Our support team liaises with both tutors and learners to provide guidance, assessment feedback, and any other study support adequately and promptly. Once a learner raises a support request through the support desk portal (Be it for guidance, assessment feedback or any additional assistance), one of the support team members assign the relevant to request to an allocated tutor. As soon as the support receives a response from the allocated tutor, it will be made available to the learner in the portal. The support desk system is in place to assist the learners adequately and streamline all the support processes efficiently. Quality learning materials made by industry experts is a significant competitive edge of the School of Business & Technology London. Quality learning materials comprised of structured lecture notes, study guides, practical applications which includes real-world examples, and case studies that will enable you to apply your knowledge. Learning materials are provided in one of the three formats, such as PDF, PowerPoint, or Interactive Text Content on the learning portal. How does the Online Learning work at SBTL? We at SBTL follow a unique approach which differentiates us from other institutions. Indeed, we have taken distance education to a new phase where the support level is incredibly high.Now a days, convenience, flexibility and user-friendliness outweigh demands. Today, the transition from traditional classroom-based learning to online platforms is a significant result of these specifications. In this context, a crucial role played by online learning by leveraging the opportunities for convenience and easier access. It benefits the people who want to enhance their career, life and education in parallel streams. SBTL's simplified online learning facilitates an individual to progress towards the accomplishment of higher career growth without stress and dilemmas. How will you study online? With the School of Business & Technology London, you can study wherever you are. You finish your program with the utmost flexibility. You will be provided with comprehensive tutor support online through SBTL Support Desk portal. How will I get tutor support online? School of Business & Technology London occupies a centralised tutor support desk portal, through which our support team liaise with both tutors and learners to provide guidance, assessment feedback, and any other study support adequately and promptly. Once a learner raises a support request through the support desk portal (Be it for guidance, assessment feedback or any additional assistance), one of the support team members assign the relevant to request to an allocated tutor. As soon as the support receive a response from the allocated tutor, it will be made available to the learner in the portal. The support desk system is in place to assist the learners adequately and to streamline all the support process efficiently. Learners should expect to receive a response on queries like guidance and assistance within 1 - 2 working days. However, if the support request is for assessment feedback, learners will receive the reply with feedback as per the time frame outlined in the Assessment Feedback Policy.

Become an IT professional with our Python Certification - IT Job Ready Program! Gain comprehensive skills in Python programming, data analysis, and automation. We offer a money-back guarantee if you don't secure a job within six months of completion. Enroll now and jumpstart your tech career! Ready to land your dream job in tech? Our Python Certification - IT Job Ready Program equips you with essential Python programming, data analysis, and automation skills. Plus, we offer a money-back guarantee if you don't get hired within six months of completing the course. Don't miss out – enroll today and take the first step towards a successful IT career! 💻📊 #PythonCertification #TechTraining #CareerReady #MoneyBackGuarantee

Broaden your horizons with Spanish, the language of over 400 million native speakers worldwide! With a GCSE in Spanish under your belt, you're setting the stage for further education and a range of career options, including journalism, education, marketing, law enforcement, and more! Our comprehensive GCSE Spanish course provides you with the skills to confidently comprehend and communicate in Spanish, covering diverse topics from self-identity and interpersonal relationships to the significance of locale, culture, and societal issues. With unlimited access to your tutor, you'll master grammatically correct writing, effective listening skills, and the creative articulation of your thoughts, ideas, and opinions. Bilingualism is a notable achievement well-regarded by educational institutions and employers alike. Our digital Edexcel GCSE Spanish course is designed for convenience, allowing you to learn at your pace and in your comfort. Your tutor will assist and guide you, as well as provide feedback on your tasks. The course is systematically structured, ensuring you gain the requisite skills and knowledge to ace your exams. By enrolling in this GCSE Spanish course, you will enjoy: Freshly-curated course content, aligned with the latest specifications Fast track option available (for 2022 exams) Complimentary e-textbook to facilitate learning Access to our consortium of exam centres (guaranteed exam venue) Unlimited tutor support – Your tutor will aid in formulating a study plan and provide constant support Exam pass guarantee (We'll support you until you pass). Understanding Spanish opens doors to both professional and social opportunities globally.  About the awarding body Awarding body: Edexcel Our course code: X810 Qualification code: 1SP0 Official Qualification Title: GCSE Spanish Edexcel, the largest awarding body in the UK, offers academic and vocational qualifications across the globe. They have been facilitating success through learning for nearly two decades, providing a reliable educational foundation. ⏱ Study Hours Allocate between 120 and 150 hours for study, along with additional time for assignments. 👩‍🏫 Study Method Our interactive online platform enhances your learning experience with diverse media resources like videos, quizzes, and interactive activities. If you wish, you can print the learning materials yourself. 📆 Course Duration Upon enrolment, you have up to two years to complete your studies and exams, with continued tutor support throughout. 📋 Assessment Examinations are available from Summer 2022 onwards. You will be required to complete three standard GCSE written exams and one speaking assessment. Exams: Paper 1: Listening and understanding – 45 minutes, 25% of GCSE, 50 marks. Paper 2: Speaking – 10-12 minutes, 25% of GCSE, 70 marks. Paper 3: Reading and understanding – 1 hour, 25% of GCSE, 50 marks. Paper 4: Writing – 1 hour 20 minutes, 25% of GCSE, 60 marks. We arrange an assured exam space for you in one of our UK-wide exam centres.  Assignments: Throughout the course, you'll complete various assignments. While not contributing towards your final grade, they provide opportunities for feedback and self-assessment. 👩‍🎓 Course Outcomes Upon successful completion, you'll receive a GCSE in Spanish, issued by Edexcel. We've chosen this syllabus (1SP0) specifically for its suitability to distance learning. ℹ️ Additional Information Official Qualification Title - GCSE Spanish Difficulty - Level 2 Entry requirements - We recommend a basic knowledge of Spanish before starting this course. Course Content From understanding yourself and everyday transactions to discussing significant societal issues and preparing for your exams, this course provides you with a robust foundation in Spanish. The structured course content encompasses self-expression, shopping, daily routines, travel experiences, environmental issues, media, and traditions. In each unit, you'll focus on essential grammatical elements and vocabulary to enhance your language proficiency and cultural understanding. Through this course, you'll emerge well-prepared to excel in your GCSE exams.

In this competitive job market, you need to have some specific skills and knowledge to start your career and establish your position. This Flourish Studio Masterclass : Create Animated Visualisation will help you understand the current demands, trends and skills in the sector. The course will provide you with the essential skills you need to boost your career growth in no time. The Flourish Studio Masterclass : Create Animated Visualisation will give you clear insight and understanding about your roles and responsibilities, job perspective and future opportunities in this field. You will be familiarised with various actionable techniques, career mindset, regulations and how to work efficiently. This course is designed to provide an introduction to Flourish Studio Masterclass : Create Animated Visualisation and offers an excellent way to gain the vital skills and confidence to work toward a successful career. It also provides access to proven educational knowledge about the subject and will support those wanting to attain personal goals in this area. Learning Objectives Learn the fundamental skills you require to be an expert Explore different techniques used by professionals Find out the relevant job skills & knowledge to excel in this profession Get a clear understanding of the job market and current demand Update your skills and fill any knowledge gap to compete in the relevant industry CPD accreditation for proof of acquired skills and knowledge Who is this Course for? Whether you are a beginner or an existing practitioner, our CPD accredited Flourish Studio Masterclass : Create Animated Visualisation is perfect for you to gain extensive knowledge about different aspects of the relevant industry to hone your skill further. It is also great for working professionals who have acquired practical experience but require theoretical knowledge with a credential to support their skill, as we offer CPD accredited certification to boost up your resume and promotion prospects. Entry Requirement Anyone interested in learning more about this subject should take this Flourish Studio Masterclass : Create Animated Visualisation. This course will help you grasp the basic concepts as well as develop a thorough understanding of the subject. The course is open to students from any academic background, as there is no prerequisites to enrol on this course. The course materials are accessible from an internet enabled device at anytime of the day. CPD Certificate from Course Gate At the successful completion of the course, you can obtain your CPD certificate from us. You can order the PDF certificate for £9 and the hard copy for £15. Also, you can order both PDF and hardcopy certificates for £22. Career path The Flourish Studio Masterclass : Create Animated Visualisation will help you to enhance your knowledge and skill in this sector. After accomplishing this course, you will enrich and improve yourself and brighten up your career in the relevant job market. Course Curriculum Introduction to Flourish Studio Welcome 00:04:00 Flourish Studio Background Story 00:01:00 Features of Flourish Studio 00:02:00 Flourish Studio Plans (Free, Business, Enterprise) 00:02:00 Getting Started with Flourish Signing up 00:02:00 Home Page Interface Walkthrough 00:06:00 Creating our First Flourish Visualisation 00:04:00 Adding and Managing Data in Flourish Templates Managing Data in Visualisations 00:08:00 Column Bindings 00:06:00 Merge Datasets 00:07:00 Creating Visualisations in Flourish Studio from scratch Creating a Bar or Line Chart in Flourish Studio - First Steps 00:08:00 Changing Settings to update Chart's look and feel - 1 00:21:00 Changing Settings to update Chart's look and feel - 2 00:10:00 Changing Settings to update Chart's look and feel - 3 00:12:00 More Visualisation Templates in Flourish Studio Table Charts (including mini visualisations) 00:09:00 Creating a Hierarchy Visualisation 00:05:00 Scatter Plot 00:06:00 More interesting variations of Scatter Plot 00:04:00 Map & Projection Charts + 3D Maps 00:08:00 Survey Charts 00:07:00 Gantt Chart 00:06:00 Radar Chart in Flourish Studio 00:06:00 Creating a Story and other Options How to create a Story in Flourish 00:13:00 Exporting, Publishing and Sharing 00:05:00 Flourish's Embed Options 00:06:00 How to Delete Projects 00:02:00 Other Exciting and Important Features Controlling access to Visualisations and stories with different Account Types 00:03:00 How to create a video or GIF from Flourish Visualisation/Story 00:04:00 How to generate the thumbnail of your visualisation 00:02:00 Customise colours in Flourish palettes 00:02:00 How to show published projects on your profile page 00:03:00 How to colour parts of your text with custom HTML 00:03:00 Add Social icons in Footer 00:02:00 Data Visualisation Tips & Resources How to select the right Visualisation Template 00:05:00 Dashboard Development Best Practices 00:04:00 Sources to get Datasets to use in Visualisations 00:02:00 Useful Resources to get Help & Continue Learning 00:06:00 Congratulations Congratulations on Course Completion 00:01:00 Certificate and Transcript Order Your Certificates or Transcripts 00:00:00

These qualifications are ALL fully Regulated and accepted in all schools across the UK and enables you to work with children between the ages of 5-18 years. If you are looking to become a Teaching Assistant and wish to gain the required 'recognised' qualification that's accepted in all UK schools, this is the perfect Teaching Assistant course for you. This bundle offer also includes the Level 3 Autism Qualification and the Level 3 Mental Health Qualifications at a discounted rate saving you over £700.00.

Overview This comprehensive course on Solidworks Foundation Training will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Solidworks Foundation Training comes with accredited certification which will enhance your CV and make you worthy in the job market. So enrol in this course today to fast track your career ladder. How will I get my certificate? At the end of the course there will be an online written 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 Solidworks Foundation Training. It is available to all students, of all academic backgrounds. Requirements Our Solidworks Foundation Training 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 8 sections • 24 lectures • 01:38:00 total length •1.1 About the Course: 00:01:00 •2.1.Overview: 00:03:00 •2.2. Applying Material: 00:08:00 •2.3. Appearance: 00:05:00 •2.4. Working with Woods: 00:05:00 •2.5. Working with Glass: 00:04:00 •2.6. Scene: 00:04:00 •3.1. Lights: 00:07:00 •3.2. Camera: 00:04:00 •4.1. Decals: 00:07:00 •4.2. Text: 00:05:00 •5.1.Options: 00:04:00 •5.2. Rendering Panel: 00:03:00 •5.3. Schedule Rendering: 00:02:00 •6.1. Creating Motion Study: 00:02:00 •6.2. Animation Wizard: 00:08:00 •6.3. Applying Motors: 00:04:00 •6.4. Changing Appearance and Camera Position: 00:07:00 •6.5. Walkthrough 1: 00:09:00 •6.6. Walkthrough 2: 00:06:00 •7.1. Task 1: 00:00:00 •7.2. Task 2: 00:00:00 •7.3. Task 3: 00:00:00 •Resources - Solidworks Foundation Training: 00:00:00

Join our Microsoft Excel course and discover your hidden skills, setting you on a path to success in this area. Get ready to improve your skills and achieve your biggest goals. The Microsoft Excel course has everything you need to get a great start in this sector. Improving and moving forward is key to getting ahead personally. The Microsoft Excel course is designed to teach you the important stuff quickly and well, helping you to get off to a great start in the field. So, what are you looking for? Enrol now! You will Learn The Following Things: Learn strategies to boost your workplace efficiency. Hone your skills to help you advance your career. Acquire a comprehensive understanding of various topics and tips. Learn in-demand skills that are in high demand among UK employers This course covers the topic you must know to stand against the tough competition. The future is truly yours to seize with this Microsoft Excel. Enrol today and complete the course to achieve a certificate that can change your career forever. Details Perks of Learning with IOMH One-to-one support from a dedicated tutor throughout your course. Study online - whenever and wherever you want. Instant Digital/ PDF certificate 100% money back guarantee 12 months access Process of Evaluation After studying the course, an MCQ exam or assignment will test your skills and knowledge. You have to get a score of 60% to pass the test and get your certificate. Certificate of Achievement After completing the Microsoft Excel course, you will receive your CPD-accredited Digital/PDF Certificate for £5.99. To get the hardcopy certificate for £12.99, you must also pay the shipping charge of just £3.99 (UK) and £10.99 (International). Who Is This Course for? This Microsoft Excel is suitable for anyone aspiring to start a career in relevant field; even if you are new to this and have no prior knowledge, this course is going to be very easy for you to understand.  On the other hand, if you are already working in this sector, this course will be a great source of knowledge for you to improve your existing skills and take them to the next level.  This course has been developed with maximum flexibility and accessibility, making it ideal for people who don't have the time to devote to traditional education. Requirements There is no prerequisite to enrol in this course. You don't need any educational qualification or experience to enrol in the Microsoft Excel course. Do note: you must be at least 16 years old to enrol. Any internet-connected device, such as a computer, tablet, or smartphone, can access this online course. Career Path The certification and skills you get from this Microsoft Excel Course can help you advance your career and gain expertise in several fields, allowing you to apply for high-paying jobs in related sectors. Course Curriculum Unit 01: Excel from A-Z Course Introduction Excel from A-Z Course Intro 00:03:00 Excel Job Opportunities 00:03:00 Excel Job Types 00:04:00 Microsoft Excel Marketplace 00:04:00 What is Microsoft Excel? 00:04:00 Who is This Course For? 00:03:00 Unit 02: Getting Started With Excel Finding & Opening Excel 00:01:00 Excel's Start Screen 00:03:00 Explaining the Excel Interface 00:03:00 Excel Interface Continued 00:01:00 Excel Workbook vs. Excel Worksheet 00:02:00 Saving an Excel Document 00:04:00 Customizing the Quick Access Toolbar 00:02:00 Customizing the Excel Ribbon 00:03:00 Excel Shortcut Keys 00:02:00 Unit 03: Values, Referencing and Formulas Creating Excel Labels 00:03:00 Entering Numeric Values in Excel 00:03:00 Formatting Date Values in Excel 00:05:00 Building Basic Formulas in Excel 00:05:00 Order of Operations 00:06:00 Relative vs. Absolute Cell References 00:07:00 Unit 04: Intro to Excel Functions Excel Functions Explained 00:03:00 The SUM() Function 00:08:00 The MIN() & MAX() Function 00:04:00 The AVERAGE() Function 00:02:00 COUNT() Functions 00:05:00 Unit 05: Adjusting Excel Worksheets Moving & Copying Data 00:07:00 Insert & Delete Rows and Columns 00:05:00 Adjusting the Width and Height of Cells 00:05:00 Hiding and Unhiding Excel Rows and Columns 00:04:00 Renaming, Moving & Deleting Excel Worksheets 00:05:00 Adding Protection to Specific Cells 00:04:00 Protecting the Structure of a Workbook 00:02:00 Adding a Workbook Password to Open File 00:02:00 Unit 06: Visually Pleasing Cell Formatting Formatting Fonts and Cell Background Color 00:05:00 Adding Cell Borders 00:05:00 Formatting Data Appropriately 00:05:00 The Magic behind Excel's Format Painter 00:03:00 Creating Styles for Formatting Efficiency 00:06:00 Merging Cells for a Cleaner Look 00:03:00 The Power of Conditional Formatting 00:06:00 Unit 07: How to Insert Images and Shapes! Grab User's Attention using Illustrations 00:09:00 Customizing Icons 00:05:00 Create Compelling Graphics with SmartArt 00:06:00 Unit 08: Visualize Data with Charts The Commonly Used Column Chart 00:03:00 Changing the Chart Design.mp4 00:02:00 Formatting Elements of a Chart 00:06:00 Modifying the Data, Type & Location of a Chart 00:06:00 Unit 09: Excel's Printing Options Print Preview Options 00:04:00 Excel's Page Layout View 00:07:00 Printing a Specific Range of Cells 00:03:00 Converting Spreadsheets to PDF Files 00:02:00 Unit 10: Benefits of Using Excel Templates Why Create an Excel Template 00:01:00 How to Create an Excel Template 00:05:00 Unit 11: Working with Excel Datasets How to Prepare Data for Analysis 00:04:00 How to Sort Data in Excel 00:03:00 Multi-Level Sorting 00:03:00 Custom Sorting Datasets in Excel 00:02:00 Applying Filters to Datasets 00:05:00 Creating Subtotals within a Dataset 00:06:00 Converting Datasets into Tables 00:06:00 Little Slice of Pie Charts 00:05:00 Finding & Removing Duplicate Values 00:07:00 Unit 12: Excel Database Functions The SUMIF() Function 00:09:00 The DSUM() Function 00:08:00 The DSUM() Function Cont. 00:07:00 The SUBTOTAL() Function 00:06:00 Unit 13: Excel Data Validation What is Excel Data Validation? 00:02:00 Creating a Drop Down List with Data Validation 00:07:00 Different Types of Excel Data Validation 00:06:00 Adding Custom Alerts to Data Validation 00:07:00 Creating a Dynamic Drop Down List 00:03:00 Complex Validation: Dependent Drop Down List! 00:09:00 Unit 14: Excel PivotTables Creating an Excel Pivot Table 00:06:00 Modifying Excel PivotTables 00:06:00 Grouping & Filtering PivotTable Data 00:06:00 Drilling Down into PivotTable Data 00:02:00 Creating Pivot Charts & Utilizing Slicers 00:08:00 Unit 15: Excel's PowerPivot Add-In What is PowerPivot? 00:04:00 Activating the Excel PowerPivot Add-In 00:02:00 Creating Relationships between Data Tables.mp4 00:06:00 Using Data Models to Create PivotTables 00:05:00 How to Create PowerPivot KPI's 00:08:00 Unit 16: Excel's Conditional Functions Excels IF Function 00:05:00 IF() Function with AND() Criteria 00:05:00 IF() Function with OR() Criteria 00:05:00 Nesting Multiple IF() Functions 00:07:00 The COUNTIF() Function 00:04:00 Key Benefits of Named Ranges 00:04:00 Unit 17: Excel's Lookup Function VLOOKUP() Function 00:09:00 The Beauty of Excel's IFERROR() Function 00:04:00 HLOOKUP() Function 00:06:00 The INDEX Function 00:05:00 MATCH() Function 00:05:00 INDEX() and MATCH() Combined 00:05:00 Two-Way Lookup with INDEX() and MATCH() 00:04:00 Unit 18: Text Based Functions in Excel LEFT(), RIGHT() and MID() Function 00:07:00 Extracting Specific Text using LEN() & SEARCH() 00:13:00 Combining Text with CONCATENATE() 00:06:00 Quick Tips & Other Text Based Functions 00:06:00 Unit 19: Auditing Formulas and Views in Excel Tracing Precedents & Dependents in Formulas 00:04:00 Showing Formulas 00:02:00 Grouping Data 00:03:00 3D Referencing in Formulas 00:05:00 Utilizing the Watch Window in Excel 00:03:00 How to Freeze Panes in Excel 00:03:00 Unit 20: Excel's 'what If?' Tools Excel's Scenario Manager Tool 00:06:00 Goal Seek in Excel 00:06:00 Compare Results with Excel Data Tables 00:04:00 Solver Tool 00:11:00 Unit 21: Welcome to Excel VBA The Power Behind Excel VBA 00:03:00 A Look Inside the Visual Basic Editor (VBE) 00:04:00 Recording a Macro 00:09:00 Saving & Opening a Macro-Enabled Workbook 00:02:00 Unit 22: The VBA Language Modules and Procedures 00:07:00 Objects, Methods and Properties 00:06:00 Excel VBA Variables 00:05:00 Unit 23: Writing VBA Code Referencing a Range 00:13:00 InputBox & MsgBox 00:06:00 Using Variables in VBA Code 00:05:00 If Then Else Statement 00:10:00 Worksheet Functions inside VBA 00:08:00 Creating User Defined Functions 00:09:00 User Defined Functions within VBA Scripts 00:06:00 Unit 24: Important VBA Tools and Logic Find Last Row of Data 00:06:00 Find Last Column of Data 00:03:00 With Statement 00:05:00 Debugging & Error Handling 00:07:00 Debugging & Error Handling Cont. 00:07:00 Unit 25: Excel VBA Loop For Next Loop 00:09:00 Do Until Loop 00:06:00 For Each Loop 00:04:00 Unit 26: Triggering Macros Assigning Macros to Shapes 00:04:00 Form Controls vs ActiveX Controls 00:08:00 Worksheet Events 00:04:00 Workbook Events 00:03:00 Fun with VBA Events! 00:07:00 Unit 27: Excel User Forms Creating an Excel UserForm 00:03:00 Adding Controls to UserForms 00:10:00 How to Show an UserForm 00:03:00 Passing TextBox Values to Desired Cells 00:07:00 Passing Option Buttons to Desired Cells 00:07:00 UserForm ComboBoxes 00:08:00 Clearing Values from UserForm Controls 00:03:00 How to Close an UserForm 00:02:00 UserForms and Protected Sheets 00:05:00 Unit 28: Starting a Career in Excel Creating an Excel Resume 00:05:00 Getting Started with Freelancing 00:06:00 How to Become an Excel Freelancer 00:05:00 Top Freelance Websites 00:05:00 How to Get Your First Client 00:08:00 Personal Branding 00:07:00 Networking Do's and Don'ts 00:04:00 Importance of Having a Website 00:04:00 Resources Resources - Microsoft Excel 00:00:00

Want to know how to transfer books to Kindle and make money in the process? The Create Your First Kindle Book course designed for the individuals who want to learn all the myths, fables, rules and reviews about what it takes to write and publish a book. Initially, you will receive step by step guideline to start writing a book. The course will show you an astonishingly easy way, where you will get ideas for writing and have a book to share. Explore more about layout and formatting, following with learning a few fundamental text-formatting rules that will enable you to transform the pages of your script into a final book that looks attractive and professional. Last but not the least, you will learn how the technology of the iPhone can be effectively used to get your book started. What Will I Learn? Will know that they can actually write and share a book of their thoughts and ideas in a simple but powerful way. How to cultivate and live with a writer's 'state of mind.' that give us the power and confidence to achieve our goals. Know that you are not going to write a book as much as you are going to perform your story and solutions so a book can be written. Learn how the technology of the iPhone can be effectively used to get the book, your book, started. You will start to claim the term writer and enjoy the fun of being a book writer. Requirements They will need to have some idea of what they want to achieve in their life and business. Who is the target audience? Starting now, in life and business, your book will be your business card and your broadcast will be your brochure, so every aspiring professional and anyone who has had in any way an inclination that ,'perhaps I should try to write a book'. If you are not willing to be challenged in your ideas and beliefs you should not take this course because all of Stan Hustad's courses contain new and creative information combined with challenging ideas and a call to accept and take action on tough challenges. Create Your First Kindle Book Introduction to Creating Your First Book FREE 00:03:00 How To Start To Write Your First Book - Stan Hustad FREE 00:08:00 How To Make This Idea Work For You! 00:13:00 Our State of Mind Matters ... a lot! 00:15:00 A Writer Is a Capturer ... How To Do That! copy 00:13:00 You Are a Writer - Tools of The Trade - Power of The iPhone copy 00:16:00 Ready Set Run! copy 00:10:00 Start With Why, Who & What When Writing Your First Book copy 00:12:00 Image & Cover Matter - Keep your Energy Level High copy 00:10:00 This Is For You - Teach & Write -To Change the World! copy 00:08:00

This Level 2 Certificate course has been designed to help you improve your knowledge of food handling. You will discover the legal requirements in order to prepare and serve food in the service industry. You will also find out about HACCP, multiple levels of hazards and their preventive measures, and much more including temperature control and handling basics. Knowledge and understanding of the basic food hygiene and safety is a legal requirement so as not to contaminate food and be safe at work all the time. The course provides learners with up-to-date food hygiene information using a range of written text, and video content to ensure learners thoroughly comprehend their food safety responsibilities. Who is the course for? All food handlers are required by European Union Regulation laws to go through an orientation training prior to starting a food handling job. This Level 2 Certificate in Food Hygiene and Safety for Manufacture course allows readers to learn about the basic food hygiene practices in order to be able to comply with all the legal requirements. This course is suitable for food handlers in any sector including fast-food outlets, takeaways, food trucks, bars, restaurants, hotels, cafes, hospitals, schools and colleges. Entry Requirement: This course is available to all learners, of all academic backgrounds. Learners should be aged 16 or over to undertake the qualification. Good understanding of English language, numeracy and ICT are required to attend this course. Assessment & Certification: Once you complete all the lessons/units, you are required to sit an exam which is multiple-choice. The pass mark is 60%. After successfully passing the exam you can obtain your certificate of achievement at an additional cost of £9. Why choose us? Affordable, engaging & high-quality e-learning study materials; Tutorial videos/materials from the industry leading experts; Study in a user-friendly, advanced online learning platform; Efficient exam systems for the assessment and instant result; The UK & internationally recognized accredited qualification; Access to course content on mobile, tablet or desktop from anywhere anytime; The benefit of career advancement opportunities; 24/7 student support via email. Career Path: Level 2 Certificate in Food Hygiene and Safety for Manufacture is a useful qualification to possess and would be beneficial for any professions or career from any industry you are in such as: Restaurateurs Hospitality managers Chefs Hotel and restaurant service staff Professional hygiene and safety officer. Introduction to Food Safety and the Law 00:30:00 Bacteria and Microbiological Hazards 00:27:00 Physical, Chemical and Allergenic Hazards 00:25:00 Food Poisoning and Control Measures 00:23:00 Food Spoilage and Food Storage 00:25:00 Personal Hygiene 00:24:00 HACCP and Food Premises Part-01 00:27:00 HACCP and Food Premises Part -02 00:26:00 Cleaning 00:20:00 Mock Exam Mock Exam-Level 2 Certificate in Food Hygiene and Safety for Manufacture 00:20:00 Final Exam Final Exam-Level 2 Certificate in Food Hygiene and Safety for Manufacture 00:20:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

This GRI, IEMA & CPD course is geared for busy professionals who want to understand how to proceed and create a 1st Class GRI Standards Sustainability Report and have a plan for immediate sustainability action without wasting time.