26642 Courses

This course is designed to provide the learner with an understanding of organizational financing sources. The learner will be able to identify, analyze and appraise different sources of finance and factors affecting the selection of the source of funds. After the successful completion of this lecture, you will be able to understand the following: Understanding the concept of sources of finance. Study the various classification of sources of funds. Understand the various merits and demerits of sources of funds. The factors affecting the sources of funds. VIDEO - Course Structure and Assessment Guidelines Watch this video to gain further insight. Navigating the MSBM Study Portal Watch this video to gain further insight. Interacting with Lectures/Learning Components Watch this video to gain further insight. Understanding the Concept and Classification of Sources of Funds Self-paced pre-recorded learning content on this topic. Quiz: Understanding The Concept And Classification Of Sources Of Funds Put your knowledge to the test with this quiz. Read each question carefully and choose the response that you feel is correct. All MSBM courses are accredited by the relevant partners and awarding bodies. Please refer to MSBM accreditation in about us for more details. There are no strict entry requirements for this course. Work experience will be added advantage to understanding the content of the course. The certificate is designed to enhance the knowledge of the learner in the field. This certificate is for everyone eager to know more and gets updated on current ideas in their respective field. We recommend this certificate for the following audience. CEO, Director, Manager, Supervisor Learning and Development Manager Finance Manager Chief Finacial Officer Accounting specialist Investment Analysis Specialist Operations Manager Team Lead Average Completion Time 2 Weeks Accreditation 1 CPD Hour Level Advanced Start Time Anytime 100% Online Study online with ease. Unlimited Access 24/7 unlimited access with pre-recorded lectures. Low Fees Our fees are low and easy to pay online.

Explore a rewarding career as a Pharmacy Assistant and Technician. Gain essential skills in medication dispensing, customer service, and pharmacy operations. Start your journey in healthcare, ensuring the well-being of patients. Discover the diverse opportunities in this vital role. Enroll now for a promising future in pharmaceutical support.

Do you want to master the art of coffee making? If yes, then enrol on our course and become a skilled barista, capable of crafting delicious and visually appealing coffee drinks. Our course will teach you about various coffee varieties, brewing techniques, and job opportunities for baristas. In this exclusive course, you will learn about the history of coffee and the various methods of brewing, including espresso, pour-over, and French press. Then understand the chemical reactions that take place during the brewing process and how they affect the taste of the coffee. Next, the learner will learn to grind, dose, and tamp coffee for espresso, as well as how to adjust the grind and dose to achieve the desired flavour profile. After that, you will also learn how to troubleshoot common problems that can occur during the extraction process. Furthermore, you will learn how to properly steam and texturise milk to create silky macrofoam and will practise pouring different latte art designs. Lastly, you will get to know how to interact with customers in a professional manner and provide excellent customer service, including taking orders and making recommendations. thus, if you are eager to learn about all the above learning then join our course now and begin your study with us. Barista Course Barista Course teaches you everything on the topic thoroughly from scratch so you can claim a certificate of achievement for free to showcase your achievement in professional life. This Course is a comprehensive, instructor-guided course, designed to provide a detailed understanding of the nature of the related sector and your key roles within it. Waiter Waiter teaches you everything on the topic thoroughly from scratch so you can claim a certificate of achievement for free to showcase your achievement in professional life. This Waiter is a comprehensive, instructor-guided course, designed to provide a detailed understanding of the nature of the related sector and your key roles within it. Food Safety and Hygiene Level 3 - Theoretical Demonstration Food Safety and Hygiene Level 3 - Theoretical Demonstration course teaches you everything on the topic thoroughly from scratch so you can claim a certificate of achievement for free to showcase your achievement in professional life. This Food Safety and Hygiene Level 3 - Theoretical Demonstration course is a comprehensive, instructor-guided course, designed to provide a detailed understanding of the nature of the related sector and your key roles within it. Effective Communication Training Level-3 Effective Communication Training Level-3 teaches you everything on the topic thoroughly from scratch so you can claim a certificate of achievement for free to showcase your achievement in professional life. This Effective Communication Training Level-3 is a comprehensive, instructor-guided course, designed to provide a detailed understanding of the nature of the related sector and your key roles within it. First Aid at Work Our First Aid at Work Course applies to all employees and includes expert audiovisual tutorials, easy to follow modules and Theoretical advice for low-risk work settings such as offices, restaurants and shops. Key topics include first aid boxes, the recovery position, administering CPR and treating secondary illnesses such as asthma and allergies. Learning outcome At the end of this course, you will: Learn about the numerous ways that coffee is processed and how it is cultivated and collected. Acquire how to operate an espresso machine, including manual, semi-automatic, and automatic models. Discover how to use an espresso grinder and how to change it as necessary. Identify the basics of espresso and espresso mechanics. Recognise the variations between cappuccino and latte foam. obtain to pour frothed milk using Latte Art techniques. Learn how to set up the menu. Understand the significance of cleanliness, hygienic practices, and machine maintenance. Key Features Accredited by CPD Instant e-certificate and hard copy dispatch by next working day Fully online, interactive course with audio voiceover Developed by qualified professionals in the field Self-paced learning and laptop, tablet, smartphone-friendly 24/7 Learning Assistance Discounts on bulk purchases Course Curriculum of Barista Course The detailed curriculum outline of our Barista Course is as follows: Module 01: Introduction to Coffee Module 02: Espresso Machine Module 03: Espresso Grinder Module 04: Introduction to Espresso & Espresso Mechanics Module 05: Let's Wrap Up Module 06: Milk Frothing Module 07: Latte Art Module 08: Menu Module 09: Behind The Bar Course Curriculum of Waiter The detailed curriculum outline of our Waiter course is as follows: 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 Waiter profession Course Curriculum of Food Safety and Hygiene Level 3 - Theoretical Demonstration The detailed curriculum outline of our Food Safety and Hygiene Level 3 - Theoretical Demonstration course is as follows: Module 01: Introduction to Food Safety Module 02: Roles and Responsibilities of a Food Supervisor and Policies Module 03: Laws and Legislation Module 04: Introduction to Food Safety Management Systems (FSMS) and HACCP Module 05: Implementation and Tools of FSMS Module 06: Food Poisoning Causes Module 07: Detecting and Preventing Contamination Module 08: Hazard Control Module 09: Food Poisoning in Detail and Illnesses Module 10: Food Toxins and their Prevention Module 11: Food Handling Risks and Practices Module 12: Temperature Control Module 13: Recording Temperatures Module 14: Spoilt Food and its Prevention Module 15: Design Aspects of Food Premises Module 16: Waste Disposal, Cleaning and Disinfection Module 17: Pest Management Module 18: Training and Supervising Staff Effectively Course Curriculum of Effective Communication Training Level-3 The detailed curriculum outline of our Effective Communication Training Level-3 course is as follows: Effective Communication Training Level-3 Module 01: Introduction Module 02: Charisma Module 03: Rapport Module 04: Body language Module 05: Discovery questions Module 06: Clean Questions Module 07: Influence Course Curriculum of First Aid at Work The detailed curriculum outline of our First Aid at Work course is as follows: Module 01: Introduction to Workplace First Aid Module 02: Legal Framework for Workplace First Aid Module 03: Incident Management at Work Module 04: Primary Survey Module 05: Secondary Survey Module 06: Basic First-Aid Techniques Module 07: Dealing with Minor Injuries at the Workplace Module 08: Secondary Illness Loss of Responsiveness and CPR Module 09: Secondary Illness Breathing Problems Module 10: Secondary Illnesses and Injuries Module 11: Dealing With Fractures and Dislocations Module 12: Call for an Emergency Course Curriculum of Life Coaching The detailed curriculum outline of our Life Coaching course is as follows: Module 01: Life Coaching: The Purpose and Fundamentals Module 02: Develop Your Self-Awareness Module 03: The Development of Core Beliefs and Managing Fears Module 04: Life Coaching Types and Key Attributes of a Life Coach Module 05: Understanding Emotional Intelligence Module 06: Body Language and Communication Techniques Module 07: A Structure for Client Work and Goal Setting Module 08: Basic Principles for Business Development and Growth Module 09: The Ethical Coach: Protect Yourself and Your Clients Accreditation All of our courses, including this Barista course, are fully accredited, providing you with up-to-date skills and knowledge and helping you to become more competent and effective in your chosen field. Certification Once you've successfully completed your Barista course, you will immediately be sent a digital certificate. Also, you can have your printed certificate delivered by post (shipping cost £3.99). Our certifications have no expiry dates, although we do recommend that you renew them every 12 months. Assessment At the end of the course, there will be an online assessment, which you will need to pass to complete the course. Answers are marked instantly and automatically, allowing you to know straight away whether you have passed. If you haven't, there's no limit on the number of times you can take the final exam. All this is included in the one-time fee you paid for the course itself. CPD 16 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Individuals who want to work as baristas. Coffee shop owners. People want to learn about the art of making coffee. Requirements Learners do not require any prior qualifications to enrol on this Barista course. Career path Upon successful completion of this course, the learner will be able to pursue a career in the relevant field.Here are some career options one could go for: Barista: Salary: £12,500 to £20,000 per annum Counter service assistant: Salary: £12,500 to £21,000 per annum Waiter: Salary: £12,000 to £22,000 per annum Certificates Certificate of completion Digital certificate - Included Certificate of completion Hard copy certificate - Included You will get the hard copy certificates for Free! The delivery charge of the hard copy certificate inside the UK is £3.99 each.

🌟 Unlock Your Potential with the Admin, Secretarial & PA Online Course! 🌟 Are you ready to embark on a journey towards a rewarding career in administration, secretarial work, or personal assistance? Look no further! Our comprehensive Admin, Secretarial & PA Online Course is designed to equip you with the essential skills and knowledge needed to thrive in today's fast-paced business world.   📚 What to Expect: Our course covers a wide range of topics essential to excel in administrative roles. From mastering communication techniques to honing your organizational skills, you'll delve into the intricacies of office management, time management, and effective multitasking strategies. Gain proficiency in industry-standard software applications, learn the art of professional correspondence, and understand the importance of confidentiality and discretion in your role. With our engaging multimedia content, interactive quizzes, and practical exercises, you'll absorb the material effortlessly and apply your newfound knowledge with confidence. Whether you're a seasoned professional looking to refresh your skills or a newcomer to the field, our course is tailored to meet your needs and elevate your career prospects.   🚀 Benefits of Taking the Admin, Secretarial & PA Online Course: Flexibility: Study at your own pace, from anywhere in the world, and fit your learning around your busy schedule. No need to sacrifice your current commitments - our online platform allows you to access course materials 24/7. Relevance: Stay up-to-date with the latest industry trends and best practices. Our course content is regularly updated to reflect the evolving demands of the administrative landscape, ensuring you're equipped with the most relevant skills employers are seeking. Career Advancement: Enhance your employability and unlock new career opportunities. Whether you're seeking entry-level positions or aiming for senior administrative roles, the skills acquired through our course will set you apart from the competition and open doors to advancement. Networking: Connect with like-minded professionals and industry experts through our online community. Exchange ideas, seek advice, and build valuable relationships that can propel your career forward. Increased Efficiency: Streamline your workflow and boost productivity with proven time management techniques and organizational strategies. Learn how to prioritize tasks, manage deadlines effectively, and optimize your workflow for maximum efficiency.   Who is this for? 🎯 Our Admin, Secretarial & PA Online Course is perfect for: Aspiring administrative professionals seeking to kickstart their careers. Current administrative staff looking to enhance their skills and advance their careers. Individuals interested in pursuing roles in secretarial work or personal assistance. Entrepreneurs and small business owners seeking to improve their office management skills.   Career Path 🛣️ Upon completion of our course, you'll be equipped to pursue a variety of exciting career paths, including: Administrative Assistant Executive Assistant Office Manager Personal Assistant Secretary Receptionist Virtual Assistant And more!   Don't let your potential go untapped - enroll in our Admin, Secretarial & PA Online Course today and take the first step towards a fulfilling and prosperous career in administration! 🚀   FAQ (Frequently Asked Questions) - Admin, Secretarial & PA Online Course Q1: What is the Admin, Secretarial & PA Online Course about? A1: The Admin, Secretarial & PA Online Course is a comprehensive program designed to equip individuals with the necessary skills and knowledge to excel in administrative roles, including secretarial and personal assistant positions. This course covers a wide range of topics, including office management, communication skills, time management, and organizational techniques. Participants will learn how to efficiently manage administrative tasks, handle correspondence, schedule appointments, and provide effective support to executives and teams. Q2: Who is this course suitable for? A2: This course is suitable for anyone interested in pursuing a career in administration, secretarial work, or personal assistance. Whether you're a recent graduate looking to enter the workforce or a professional seeking to enhance your skills and advance your career, this course provides valuable insights and practical techniques applicable across various industries and sectors. Additionally, entrepreneurs and small business owners can benefit from learning essential administrative skills to efficiently manage their operations. Q3: What are the key benefits of taking this online course? A3: By enrolling in the Admin, Secretarial & PA Online Course, participants can expect to gain a comprehensive understanding of administrative principles and practices. Some key benefits include: Acquiring essential skills in office management, communication, and organization. Learning effective time management techniques to optimize productivity. Developing proficiency in handling administrative tasks such as correspondence, scheduling, and document management. Enhancing interpersonal skills for effective communication with colleagues, clients, and stakeholders. Increasing employability and career advancement opportunities in administrative roles across various industries. Q4: How is the course structured, and what learning materials are provided? A4: The course is structured into modules, each focusing on specific aspects of administration, secretarial duties, and personal assistance. Participants will have access to comprehensive learning materials, including video lectures, reading materials, practical exercises, and quizzes. Additionally, interactive elements such as discussion forums and case studies are incorporated to facilitate engagement and application of knowledge. Learners can progress at their own pace, with flexibility to accommodate individual schedules and learning preferences. Q5: Is there any prerequisite for enrolling in this course? A5: No specific prerequisites are required for enrollment in the Admin, Secretarial & PA Online Course. This program is designed to cater to individuals with varying levels of experience and educational backgrounds. Whether you're a beginner seeking to enter the field of administration or an experienced professional looking to refine your skills, this course offers valuable insights and practical knowledge to support your career goals. Course Curriculum Module 1-Overview for the New Administrative Assistant Overview for the New Administrative Assistant 00:00 Module 2-Daily Routine Daily Routine 00:00 Module 3-Telephone Usage Telephone Usage 00:00 Module 4-Meetings Meetings 00:00 Module 5-Keeping Accurate Records Keeping Accurate Records 00:00 Module 6- Office Equipment Office Equipment 00:00

Highlights of the Course Course Type: Online Learning Duration: 1 hour 15 minutes Tutor Support: Tutor support is included Customer Support: 24/7 customer support is available Quality Training: The course is designed by an industry expert Recognised Credential: Recognised and Valuable Certification Completion Certificate: Free Course Completion Certificate Included Instalment: 3 Installment Plan on checkout What you will learn from this course? Gain comprehensive knowledge about customer service Understand the core competencies and principles of customer service Explore the various areas of customer service Know how to apply the skills you acquired from this course in a real-life context Become a confident and expert customer service manager Customer Service This customer service course is accredited by the CPD 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. Customer service is the act of taking care of the customer's needs by providing and delivering professional, helpful, high quality service and assistance before, during, and after the customer's requirements are met. But how is this done? How do you ensure it's consistent across your business? What are the benefits of delivering great customer service? This customer service course will start by making it very clear exactly what we mean by customer service, and why it's so vital. It then goes into detail about the goals of great customer service, communication skills both verbal and non-verbal, discovering and understanding customer needs and much more. Who is this Course for? This comprehensive Customer Service course is ideal for anyone wishing to boost their career profile or advance their career in this field by gaining a thorough understanding of the subject. Anyone willing to gain extensive knowledge on this customer service can also take this course. Whether you are a complete beginner or an aspiring professional, this course will provide you with the necessary skills and professional competence, and open your doors to a wide number of professions within your chosen sector. Entry Requirements This Customer Service course has no academic prerequisites and is open to students from all academic disciplines. You will, however, need a laptop, desktop, tablet, or smartphone, as well as a reliable internet connection. Assessment This Customer Service course assesses learners through multiple-choice questions (MCQs). Upon successful completion of the modules, learners must answer MCQs to complete the assessment procedure. Through the MCQs, it is measured how much a learner could grasp from each section. In the assessment pass mark is 60%. Advance Your Career This Customer Service course will provide you with a fresh opportunity to enter the relevant job market and choose your desired career path. Additionally, you will be able to advance your career, increase your level of competition in your chosen field, and highlight these skills on your resume. Recognised Accreditation This course is accredited by continuing professional development (CPD). CPD UK is globally recognised by employers, professional organisations, and academic institutions, thus a certificate from CPD Certification Service creates value towards your professional goal and achievement. Course Curriculum Module 1: About the Course Module 2: What is Customer Service Module 3: The Goals of Great Customer Service Module 4: Discovering and Understanding Customer Needs Module 5: Delivering Maximum Levels of Customer Service Module 6: Making Customers Feel Great From the Start Module 7: Communication Skills Module 8: Non-verbal Communication and Body Language Module 9: Dealing with Customer Complaints Obtain Your Certificate Order Your Certificate of Achievement 00:00:00

Communication skills course will help you to learn effective communication and how to interact with different groups of people.

Duration 1 Days 6 CPD hours This course is intended for This course is designed for non-technical business executives who are tasked with making business decisions about emerging technologies in their businesses. Overview You will learn:Blockchain Cloud BasicsIoT OverviewMobility and Ambient ComputingMachine Learning and Deep LearningChatbots, Robotics, and More This course is designed for non-technical business executives looking to learn and understand emerging technologies. Blockchain Cloud BasicsIoT OverviewMobility and Ambient ComputingMachine Learning and Deep LearningChatbots, Robotics, and More

This Level 4 Early Years qualification is ideal for current early year practitioners who want to expand their knowledge of the Early-Years in order to provide quality care for children and young people. By studying this course, you will have proven that you possess in-depth knowledge of managing and leading a team of early years practitioners to provide care that meets the highest standards outlined in the EYFS. Our Level 4 Early Years course is suitable for existing Early Years Practitioners who want to advance their childcare knowledge. The course goes into greater detail to provide management and senior-level staff members with a solid understanding of key aspects within a childcare environment such as safeguarding, managing a team, professional partnerships, and how to work to the highest standards within the early years. The Level 4 Early Years course includes specialized modules that break down each topic and ensure that our students receive an exceptional and comprehensive education. So, enrol in Level 4 Early Years course today and start learning instantly! Learning Outcomes By the end of Level 4 Early Years course, the learner will be able to: Understand the emotional and physical well-being of children. Understand equality, diversity and professional partnerships. Understand health and safety legislation. Describe observations, assessments and planning. Explain safeguarding children. Understand the Early Years Foundation Stage. Manage in a nursery environment. Engage in professional development. Why Choose Level 4 Early Years Bundle Course from Us Self-paced course, access available from anywhere. Easy to understand, high-quality study materials. Course developed by industry experts. MCQ quiz after each module to assess your learning. Automated and instant assessment results. 24/7 support via live chat, phone call or email. Free PDF certificate as soon as completing the course. ***Level 4 Early Years Courses*** Course 01: Introduction to Psychology Course 02: Childcare and Nutrition Course 03: EYFS Teaching Diploma Course 04: Level 3 Dyslexia Awareness ***Other Benefits of this course *** Free 5 PDF Certificate Lifetime Access Free Retake Exam Tutor Support [ Note: Free PDF certificate as soon as completing the Level 4 Early Years course] Detailed course curriculum of Level 4 Early Years Course Module 01: Supporting the Emotional and Physical Well-being of Children Module 02: Equality, Diversity and Professional Partnerships Module 03: Health and Safety Legislation Module 04: Observations, Assessments and Planning Module 05: Safeguarding Children Module 06: The Early Years Foundation Stage Module 07: Managing in a Nursery Environment Module 08: Engaging in Professional Development >>---------------<< Assessment Method After completing each module of the Level 4 Early YearsCourse, 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 Level 4 Early YearsCourse, 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? This Level 4 Early Years course is designed for anyone interested in working as a nursery nurse in a childcare setting. Suitable for both new and existing nursery nurses, the course develops an understanding of childcare and how to work with young people. Requirements There are no specific requirements for this Level 4 Early Years course because it does not require any advanced knowledge or skills. Career path The Level 4 Early Years Course is designed to give you the skills and knowledge you need to land your dream job, advance at work, go self-employed, or start your own business. Certificates Certificate of completion Digital certificate - Included

Launch your office career with confidence using the Excel Introduction Training: 8-in-1 Premium Online Courses Bundle. Tailored for entry-level roles, this bundle features essential courses like MS Excel, Communication Skills, MS Word, Mathematics, MS PowerPoint, Touch Typing, Purchase Ledger, and MS Access. 🎯 Gain the skills employers are actively seeking in business and admin sectors ⏳ Limited enrolment—secure your spot today ⭐ “Compete High has 4.8 on 'Reviews.io' and 4.3 on Trustpilot” 📊 Description Kickstart your career with an all-around skillset that blends office software mastery with vital communication and administrative capabilities. Excel in MS Excel and MS Access to manage data confidently. Communicate effectively with strong Communication Skills and produce polished documents in MS Word and engaging presentations in MS PowerPoint. Improve workplace speed with Touch Typing and enhance your numerical accuracy with Mathematics. Gain specialised knowledge in Purchase Ledger, crucial for finance and accounting roles. ✔ Boost your employability in administrative, finance, and office support roles. ✔ Master MS Excel, MS Word, and MS PowerPoint for everyday office tasks. ✔ Build foundational skills with Touch Typing and Mathematics. ✔ Understand finance operations through Purchase Ledger. Get ahead with the skills employers demand—start today! ❓ FAQ Q: Is this bundle suitable for beginners? A: Yes, perfect for those starting in office administration or business support roles. Q: Can I access the training on my schedule? A: Absolutely, including courses like Touch Typing and Purchase Ledger. Q: Will this help me get hired? A: Yes, this bundle aligns with key employer requirements in business and admin sectors.

Ascend to the next level of Excel proficiency with our comprehensive Microsoft Excel: Automated Dashboard Using Advanced Formula, VBA, Power Query course. This in-depth training will equip you with the skills to create sophisticated dashboards using advanced Excel formulas, VBA, and Power Query, empowering you to transform raw data into actionable insights. Master the art of financial modeling with our prepaid expenses models, learning how to calculate amortization schedules and create detailed summaries using Excel formulas. Delve into the power of Power Query to effortlessly manipulate and analyze large datasets, building dynamic dashboards without the limitations of formulas. Learning Outcomes Gain proficiency in creating automated dashboards using advanced Excel formulas, VBA, and Power Query Develop expertise in financial modeling using prepaid expenses models Master the calculation of amortization schedules and prepaid expenses summaries Implement Power Query to manipulate and analyze large datasets Create dynamic dashboards without the limitations of formulas Enhance your Excel skills and data analysis capabilities Why choose this Microsoft Excel: Automated Dashboard Using Advanced Formula, VBA, Power Query course? Unlimited access to the course for a lifetime. Opportunity to earn a certificate accredited by the CPD Quality Standards and CIQ after completing this course. Structured lesson planning in line with industry standards. Immerse yourself in innovative and captivating course materials and activities. Assessments designed to evaluate advanced cognitive abilities and skill proficiency. Flexibility to complete the Course at your own pace, on your own schedule. Receive full tutor support throughout the week, from Monday to Friday, to enhance your learning experience. Unlock career resources for CV improvement, interview readiness, and job success. Who is this Microsoft Excel: Automated Dashboard Using Advanced Formula, VBA, Power Query course for? Accounting and finance professionals seeking to enhance their Excel skills for financial modeling and dashboard creation Business analysts and data analysts aiming to expand their expertise in data manipulation and visualization Excel enthusiasts interested in mastering advanced Excel formulas, VBA, and Power Query Individuals seeking to create interactive and insightful dashboards for data-driven decision-making Anyone seeking to elevate their Excel skills and become a proficient data analyst Career path Financial Analyst (£35,000 - £55,000) Business Analyst (£40,000 - £60,000) Data Analyst (£45,000 - £65,000) Management Accountant (£40,000 - £60,000) Business Intelligence Analyst (£45,000 - £65,000) Senior Financial Analyst (£50,000 - £70,000) Prerequisites This Microsoft Excel: Automated Dashboard Using Advanced Formula, VBA, Power Query does not require you to have any prior qualifications or experience. You can just enrol and start learning.This Microsoft Excel: Automated Dashboard Using Advanced Formula, VBA, Power Query was made by professionals and it is compatible with all PC's, Mac's, tablets and smartphones. You will be able to access the course from anywhere at any time as long as you have a good enough internet connection. Certification After studying the course materials, there will be a written assignment test which you can take at the end of the course. After successfully passing the test you will be able to claim the pdf certificate for £4.99 Original Hard Copy certificates need to be ordered at an additional cost of £8. Course Curriculum Introduction Course Outline and Introduction 00:04:00 Minimum Requirements for the Course 00:01:00 Prepayments Introduction 00:01:00 Prepaid Expenses Models: Resources Download Month End Date Prepaid Expenses Amortization Calculation 00:00:00 Exact Prepaid Expenses Payment Date Calculation 00:00:00 Accounting for Prepaid Expenses Prepaid Expenses Accounting Definition: Prepayments 00:03:00 Prepaid Expense Example: How Accounting works for Prepayments 00:03:00 Advantages and Disadvantages of Prepaid Expenses 00:03:00 Excel Formulas Detailed: Introduction to three Excel Models Introduction to PRO Excel Models and Formulas 00:06:00 Date Function 00:05:00 EOMONTH Function 00:04:00 DATEVALUE function 00:03:00 IF Function 00:08:00 IFS Function (Office 365 Only) 00:07:00 VLOOKUP Function 00:07:00 MATCH Function 00:05:00 INDIRECT Function 00:02:00 NAMED Ranges: Name Manager 00:03:00 Advanced Version of VLOOKUP Function 00:07:00 Formula Based Prepaid Expenses Model Introduction to Model and Control Panel Tab (Important Sheet Tab) 00:08:00 Formula Based Prepaid Expenses Model - Deep Dive (Part 1) 00:05:00 Formula Based Prepaid Expenses Model - Deep Dive (Part 2) 00:06:00 Formula Based Prepaid Expenses Model - Deep Dive (Part 3) 00:06:00 IFS Function - Month End date Prepayment calculation 00:04:00 Prepaid Expenses - Closing Balance Summary Tab (Formula Based Summary) 00:09:00 Protecting Formulas Cells and Fields in the Model 00:04:00 Calculate Prepaid Expenses Amortisation from Exact Start Date Exact Date Prepaid Amortisation calculation Intro 00:03:00 Formulas update and Model Changes for Exact Prepaid Exps Calculation 00:03:00 Formulas Update for Exact Date Prepaid Exps Amortisation (Part 1) 00:04:00 Formulas Update for Exact Date Prepaid Exps Amortisation (Part 2) 00:03:00 Formulas Update for Exact Date Prepaid Exps Amortisation (Part 3) 00:02:00 Formulas Update for Exact Date Prepaid Exps Amortisation (Part 4) 00:07:00 IFS Function - Exact Date Prepayments Amortisation 00:04:00 Data Validation Controls (Enhancing Data Input Controls with Protection) 00:10:00 Bonus: Prepayment Model with Opening Balance Calculation (Part 1) 00:08:00 Bonus: Prepayment Model with Opening Balance Calculation (Part 2) 00:09:00 Additional Material: Resources 00:00:00 Prepaid Expenses Summary with Power Query and Pivot Table Power Query and Pivot Table Prepayment Summary Table Intro 00:06:00 What is Power Query and Some Awesome Resources for Power Query learning 00:07:00 Power Query and Pivot Table Summary - Deep Dive (Part 1) 00:05:00 Power Query and Pivot Table Summary - Deep Dive (Part 2) 00:04:00 Power Query and Pivot Table Summary - Deep Dive (Part 3) 00:05:00 Power Query and Pivot Table Summary - Deep Dive (Part 4) 00:09:00 Using Array Formulas to Add Formula Protection 00:04:00 Bonus: Allocate Prepaid Expenditure Cost Centre Wise - 1 00:02:00 Bonus: Allocate Prepaid Expenditure Cost Centre Wise - 2 00:08:00 Bonus: Prepayment Model with Opening Balance Calculation (PQ and PT Version) 00:13:00 Advanced VBA Prepaid Expenses Amortisation Model Changing Macros Security in Excel 00:05:00 Complete Walkthrough - Advanced VBA Prepaid Expenses Amortisation Model 00:06:00 Bonus : New Version - Excel VBA Model for Prepayment Expenditure 00:08:00 BONUS: Dynamic Dashboard for Divisional Profit and Loss statements: Easy Way Dynamic Dashboard Overview 00:07:00 Importing Profit and Loss Statements Source Files and creating YTD P&L Sheets 00:08:00 Creating Dynamic Data Validation 00:02:00 Creating Named Ranges for Dynamic Table Arrays 00:03:00 Dynamic Date Column Headings for each Divisional PL Table 00:02:00 Dynamic Month and YTD Dashboard tables headings (PRO TIP) 00:03:00 Dynamic VLOOKUP Formula - Preparing First section of the Dashboard 00:04:00 Creating Rolling Dashboard with Dynamic VLOOKUP Function 00:08:00 IMPORTANT : Error Checking for your reports/Dashboard (PRO TIP) 00:03:00 Data Prep for Visualization: AREA Charts (Awesome trick using #NA Function) 00:05:00 Visualization: AREA Charts for Month - Revenue, Gross Profit and Net Profit 00:05:00 Visualization DONUT Charts Revenue, Gross Profit and Net Profit (Part 1) 00:03:00 Visualization DONUT Charts Revenue, Gross Profit and Net Profit (Part 2) 00:06:00 Power Query & Pivot Tables based Dashboard without any Formulas, Fully Dynamic Introduction - Formula-less Dashboard - Fully Dynamic and easily refreshed 00:05:00 Understanding the data files before building dashboard 00:02:00 Consolidating Reports with Power Query (Get & Transform) , How to install PQ 00:08:00 Dynamic File Path Trick in Power Query with Parameters (Amazing trick) 00:06:00 Conditional Cumulative totals with SUMIFS Function 00:04:00 Bonus: Conditional Cumulative totals with Power Query Custom Formula (M Code) 00:06:00 Dashboard Creation - Pivot Table showing Month and YTD KPIs division wise 00:06:00 Dashboard Creation Donuts Charts linked with Pivot Table (Replicate Charts fast) 00:08:00 Dashboard Creation - Line Charts 00:08:00 Update Dashboard with Additional Divisional Data with Few Click (Magical) 00:03:00 Thank you Thank you 00:02:00 Ultimate Prepaid Expenditure Model (Super Bonus) 00:02:00 Resources Resources - Microsoft Excel: Automated Dashboard Using Advanced Formula, VBA, Power Query 00:00:00 Assignment Assignment - Microsoft Excel: Automated Dashboard Using Advanced Formula VBA Power Query 00:00:00