1874 Courses delivered On Demand

Gain the skills and credentials to kickstart a successful career and learn from the experts with this step-by-step

Level 7 QLS Endorsed Diploma | 180 CPD Points | +Gifts: QLS Certificate + PDF Certificate | 24/7 Learner Support

Project Management Complete Course Overview Do you want to be more efficient and organized when you are doing a project? Do you feel as though your hard efforts are giving minimum output? This is course is perfect for you to enhance your ability in Project Management. This course helps you create a roadmap to the project goal by breaking down the greater milestones into well defined tasks. This helps you manage the responsibilities of people and coordinate the team. Develop a full understanding of the project goals, objectives and benefits before committing significant resources. Ensure that the project proceeds effectively through all the essential phases, from concept through to completion. Provide a rigorous approach to defining a realistic, but still challenging, timescale and budget for completion of the project. This course is designed to improve your project management skills. It will help you implement a systematic process to manage changes to the project scope or objectives. Learn everything you need to know by taking this course where you will complete multiple units and give exams to test your knowledge. Course Highlights Project Management Complete Course is an award winning and the best selling course that has been given the CPD Certification & IAO accreditation. It is the most suitable course anyone looking to work in this or relevant sector. It is considered one of the perfect courses in the UK that can help students/learners to get familiar with the topic and gain necessary skills to perform well in this field. We have packed Project Management Complete Course into 56 modules for teaching you everything you need to become successful in this profession. To provide you ease of access, this course is designed for both part-time and full-time students. You can become accredited in just 52 hours and it is also possible to study at your own pace. We have experienced tutors who will help you throughout the comprehensive syllabus of this course and answer all your queries through email. For further clarification, you will be able to recognize your qualification by checking the validity from our dedicated website. Why You Should Choose Project Management Complete Course Lifetime access to the course No hidden fees or exam charges CPD Accredited certification on successful completion Full Tutor support on weekdays (Monday - Friday) Efficient exam system, assessment and instant results Download Printable PDF certificate immediately after completion Obtain the original print copy of your certificate, dispatch the next working day for as little as £9. Improve your chance of gaining professional skills and better earning potential. Who is this Course for? Project Management Complete Course is CPD certified and IAO accredited. This makes it perfect for anyone trying to learn potential professional skills. As there is no experience and qualification required for this course, it is available for all students from any academic backgrounds. Requirements Our Project Management Complete Course is fully compatible with any kind of device. Whether you are using Windows computer, Mac, smartphones or tablets, you will get the same experience while learning. Besides that, you will be able to access the course with any kind of internet connection from anywhere at any time without any kind of limitation. Career Path You will be ready to enter the relevant job market after completing this course. You will be able to gain necessary knowledge and skills required to succeed in this sector. All our Diplomas' are CPD and IAO accredited so you will be able to stand out in the crowd by adding our qualifications to your CV and Resume. Project Management Complete Course - Updated Version Introduction to Project Management 00:23:00 PMBOK and PMI 00:15:00 Global Project Management 00:40:00 Project Life Cycle 00:30:00 Time Management 00:41:00 Quality Management 00:22:00 Effective Planning & Scheduling 00:47:00 Human Resource Management 00:18:00 Performance Management 00:19:00 Talent Management 00:19:00 Organising Meeting and Conferences 00:29:00 Managing Resources 00:19:00 Change Management 00:24:00 Business Resilience and Crisis Management 00:18:00 Conflict Management 00:16:00 Stress Management 00:17:00 Communication Skills 00:26:00 Procurement & Purchasing Management 00:22:00 Risk Management 00:25:00 Lean Process and Six Sigma Module 1: Understanding Lean 00:22:00 Module 2: The Lean Culture 00:19:00 Module 3: The Five Principles of Lean 00:10:00 Module 4: Value and Waste 00:19:00 Module 5: Value Stream Mapping (VSM) 00:19:00 Module 6: The Principles of Flow and Pull 00:14:00 Module 7: Overview of Six Sigma 00:11:00 Module 8: The Define Phase 00:18:00 Module 9: The Measure Phase 00:21:00 Module 10: The Analyse Phase 00:22:00 Module 11: The Improve Phase 00:21:00 Module 12: The Control Phase 00:14:00 Project Management Complete Course - Old Version Project Management Basics Introduction FREE 01:00:00 Creating a Project Management Methodology FREE 01:00:00 Where Does The Buck Stop? 01:00:00 Can You Manage Yourself Out Of A Paper Bag? 00:30:00 Setting the Stage for a Successful Project 01:00:00 The Importance of Developing and Maintaining A Budget 01:00:00 Taking Action - Execution of the Plan 01:00:00 Rules to Manage By 01:00:00 Your Personality and Project Management Style 01:00:00 The Cycle of Decision Making 01:00:00 Getting Your Project Back On Track 01:00:00 Keep It Moving 01:00:00 Problems and Solutions 01:00:00 Becoming a Successful Project Manager Module One - Getting Started FREE 00:30:00 Module Two - Key Concepts (I) FREE 01:00:00 Module Three - Key Concepts (II) 01:00:00 Module Four - Initiation (I) 01:00:00 Module Five - Initiation (II) 01:00:00 Module Six - Planning (I) 01:00:00 Module Seven - Planning (II) 01:00:00 Module Eight - Planning Tools 01:00:00 Module Nine - Executing the Project 01:00:00 Module Ten - Maintaining and Controlling the Project 01:00:00 Module Eleven - Closing Out 01:00:00 Module Twelve - Wrapping Up 00:30:00 Extended Diploma in Project Management- Activities 00:00:00 Six Sigma & Lean Process Module One - Getting Started FREE 00:30:00 Module Two - Understanding Lean FREE 01:00:00 Module Three - Liker's Toyota Way 01:00:00 Module Four - The TPS House 01:00:00 Module Five - The Five Principles of Lean Business 01:00:00 Module Six - The First Improvement Concept (Value) 01:00:00 Module Seven - The Second Improvement Concept (Waste) 01:00:00 Module Eight - The Third Improvement Concept (Variation) 01:00:00 Module Nine - The Fourth Improvement Concept (Complexity) 01:00:00 Module Ten - The Fifth Improvement Concept (Continuous Improvement) 01:00:00 Module Eleven - The Improvement Toolkit 00:30:00 Module Twelve - Wrapping Up 01:30:00 Risk Assessment Module One - Getting Started FREE 00:30:00 Module Two - Identifying Hazards and Risks FREE 01:00:00 Module Three - Seeking Out Problems Before They Happen (I) 01:00:00 Module Four - Seeking Out Problems Before They Happen (II) 01:00:00 Module Five - Everyone's Responsibility 01:00:00 Module Six - Tracking and Updating Control Measures 01:00:00 Module Seven - Risk Management Techniques 01:00:00 Module Eight - General Office Safety and Reporting 01:00:00 Module Nine - Business Impact Analysis 01:00:00 Module Ten - Disaster Recovery Plan 01:00:00 Module Eleven - Summary of Risk Assessment 01:00:00 Module Twelve - Wrapping Up 00:30:00 Scrum Master Training Introduction FREE 01:00:00 Typical Scrum Timeline FREE 01:00:00 Scrum Roles 01:00:00 Scrum Events 01:00:00 Scrum Artifacts 01:00:00 Summary 00:30:00 Mock Exam Mock Exam- Accredited Project Management Complete Course 00:30:00 Final Exam Final Exam- Accredited Project Management Complete Course 00:30:00

Overview Did you know that the global HR industry is currently worth around £17,48 billion? Get a chance to shine in this highly prospective and competitive field through our HR Management bundle. Our precisely crafted courses will help you establish yourself in this field! HR is more than just a division of a company. It is essential to any business and worker's success and is the lifeblood of an organisation. The Human Resources principles covered in this CPD-accredited course will adequately equip you to begin a career in the related industry. For organisations of all sizes, managing daily HR tasks is a difficult undertaking that needs the assistance of an HR consultant. Moreover, this course will give you the essential knowledge you need to create individualised training plans and effectively handle human resources-related demands. Following your successful completion, you will have highly developed abilities that will enable you to design and manage the recruiting and selection process, organise and carry out training, implement performance improvement training, and more. Along with this HR Management Complete Bundle, you will get an original hardcopy certificate, a transcript and a student ID card which will allow you to get discounts on things like music, food, travel and clothes etc. What other courses are included with this Bundle? Course 1: Level 3 Diploma Course 2: HR And Recruitment Consultant Training Course 3: Employment Law Course 4: Office Administration Certificate Course 5: Contract Manager Diploma Course 6: Payroll Management Course Course 7: GDPR Course 8: Workplace Confidentiality Course 9: Leadership & Management Diploma Course 10: Performance Management Course 11: Effective Communication Skills Learning Outcomes The students undertaking this course will get the opportunity to - Get Introduced to Human Resources (HR) Understand the employee recruitment and selection procedure Learn the skills of an effective administrator Understand the employee training and development process Learn about performance appraisal management and employee relations Benefits you'll get choosing Apex Learning: One payment, but lifetime access to 11 CPD courses Certificates, student ID for the title course included in a one-time fee Full tutor support available from Monday to Friday Free up your time - don't waste time and money travelling for classes Accessible, informative modules taught by expert instructors Learn at your ease - anytime, from anywhere Study the course from your computer, tablet or mobile device CPD accredited course - improve the chance of gaining professional skills Gain valuable experience without leaving your home How will I get my Certificate? After successfully completing the course you will be able to order your CPD Accredited Certificates (PDF + Hard Copy) as proof of your achievement. PDF Certificate: Free (Previously it was £6*11 = £66) Hard Copy Certificate: Free (For The Title Course: Previously it was £10) Description Begin your HR journey with Apex Learning right away! The management of human resources is essential to the success of any company and employee. In addition to ensuring regulatory compliance, HR is in charge of keeping staff members interested and inspired to perform well. This course will provide you with the overview required to achieve your objective, whether you are entirely new to human resources, are interested in learning more about the field, or need to create a more effective HR department. Additionally, students will study about the evolving function of HR, including a historical review, important procedures and duties, and contemporary trends influencing the development of HR practices. With the help of this HR Management Bundle, you will get the core knowledge necessary to create customised training plans and effectively handle human resources-related demands.When you need them, knowledgeable teachers and mentors will be available to you and will answer any of your questions via email and chat rooms. Course Curriculum of Bundle Module 01: Introduction to Human Resource In this module we will cover the following topics: Human resource management Models of HRM The Role of the HR Department Aims of HRM HRM and personnel management Impacts HR have on Organisational Performance Module 02: Employee Recruitment and Selection Procedure In this module we will cover the following topics: Attracting candidates Advertising E-recruitment Graphology Final stages Module 03: Employee Training and Development Process In this module we will cover the following topics: The justification for training Transferring training Systematic training Types of training Effective training practices Training techniques E-learning Module 04: Performance Appraisal Management In this module we will cover the following topics: The benefit of performance management Characteristics of performance management Performance management cycle Managing performance throughout the year Reviewing performance Rating performance Dealing with under-performers Module 05: Employee Relations In this module we will cover the following topics: Strategic Employee Relations Practice of Industrial Relations Employee Voice Employee Communications Module 06: Motivation and Counselling In this module we will cover the following topics: The process of motivation Types of motivation Motivation theory Motivation strategies Module 07: Ensuring Health and safety at the Workplace In this module we will cover the following topics: Managing Health and Safety At Work The importance of health and safety in the workplace Benefits of workplace health and safety Health and safety policies Conducting risk assessments Accident prevention Measuring health and safety performance Health and safety training Module 08: Employee Termination In this module we will cover the following topics: Redundancy Dismissal Relieving Letter Retirement Module 09: Employer Record and Statistics In this module we will cover the following topics: Introduction The necessity for Personnel Records Information in Personnel Records Formats of Personnel Records Module 10: Essential UK Employment Law In this module we will cover the following topics: Introduction Wages Dismissal Equality Working Parents' Rights Data Protection (GDPR) Course 2: HR And Recruitment Consultant Training Introduction to Recruitment: Importance and Implications An Overview of the Recruitment Industry The UK Recruitment Legislation Sales and Selling in the Recruitment Industry The Recruitment Process Key Performance Indicators for the Recruitment Industry Candidate Attraction for Recruitment Candidate Management Candidate Interview Processes And many more... Course 3: Employment Law Basic of Employment Law Legal Recruitment Process Employment Contracts Employee Handbook Disciplinary Procedure National Minimum Wage & National Living Wage Parental Right, Sick Pay & Pension Scheme Discrimination in the Workplace Health & Safety at Work Dismissal, Grievances and Employment Tribunals Workplace Monitoring & Data Protection Course 4: Office Administration Certificate Introduction to Office Administration Skills of an Effective Administrator Business Writing Skills Communication Skills Managing Meetings and Giving Feedback Organisational Skills Telephone Etiquette Negotiation Techniques Conflict Management Stress Management Time Management Course 5: Contract Manager Diploma Introduction to Contract Management Classification of Contracts Contract Lifecycle - Understanding The Stages Principles of English Contract Law Contract Management Plan & Efficiency Contract Manager's Roles, Responsibilities & Career Opportunities And many more... Course 6: Payroll Management Course Payroll System in the UK Payroll Basics Company Settings Legislation Settings Pension Scheme Basics Pay Elements The Processing Date Adding Existing Employees Adding New Employees Payroll Processing Basics Entering Payments Pre-Update Reports Updating Records e-Submissions Basics Process Payroll (November) Employee Records and Reports Editing Employee Records Process Payroll (December) Resetting Payments Quick SSP An Employee Leaves Final Payroll Run Reports and Historical Data Year-End Procedures Course 7: GDPR GDPR Basics GDPR Explained Lawful Basis for Preparation Rights and Breaches Responsibilities and Obligations Course 11: Workplace Confidentiality Module 01: Introduction to workplace confidentiality Module 02: Business Etiquettes and Types of Confidentiality Module 03: The Importance of Confidentiality Module 04: Confidentiality with Co-workers Module 05: Preventing Confidentiality Breach Module 06: How Employers Can Protect Confidential Information Course 9: Preventing Workplace Violence and Harassment Section 1: Workplace Management: Violence What Is Workplace Harassment? Identifying the Bully How to Handle Workplace Violence Risk Assessment Being the Victim Checklist for Employers Interview Process Investigation Process Developing a Workplace Harassment Policy Section 2: Workplace Management: Harassment The Background Developing an Anti-Harassment Policy Policies in the Workplace Proper Procedures in the Workplace False Allegations Other Options Sexual Harassment Mediation Conflict Resolution The Aftermath Course 10: Performance Management Performance Management Introduction Performance Key Performance Indicators Reporting Rewarding Conclusion Course 11: Effective Communication Skills Business Communication Verbal and Non-verbal Communication Written Communication Electronic Communication Communicating with Graphics Effectively Working for Your Boss CPD 110 CPD hours / points Accredited by CPD Quality Standards Who is this course for? This course bundle is designed for people who are - Looking to pursue a career in Human Resourse (HR). Willing to upgrade their skills. Trying to build an efficient workforce in HR. Working on boosting office productivity. Willing to ensure an employee friendly workplace. Requirements Our HR Management(HR) course is fully compatible with PCs, Macs, laptops, tablets and Smartphone devices. Career path HR has a huge job field. This course bundle will help the learners to pursue jobs that have huge demand in the job market, such as- Human resources officer Equalities officer Human Resources Assistant. HR Specialist Administrative Officer

Stand out in the healthcare and executive admin job market with this all-in-one 20-course bundle. Designed for future medical secretaries and personal assistants, this comprehensive package offers the administrative fluency and professional credibility today’s employers demand. Description The hybrid nature of medical PA roles means you're expected to master everything from patient communications and booking systems to data protection and high-level reporting. This bundle helps you do just that—while keeping your training time and costs to a minimum. Tailored for high-paced environments where clarity, organisation, and compliance are non-negotiable, the certifications in this bundle are your ticket to better job prospects and increased interview callbacks. From virtual assistant skills to essential healthcare admin tools, this is a serious upgrade to your employability. Time is limited, and roles are filling quickly. Set yourself apart by showing you’re trained, ready, and professional—before someone else does. FAQ What kind of jobs can this bundle help with? Medical PA, secretary, executive assistant in healthcare settings, or hybrid admin roles. Do I get 20 certificates? Yes, one certificate per completed course—great for showcasing skills to employers. Will this help me if I want to work for private consultants or NHS teams? Absolutely. The blend of administrative and healthcare-focused training is relevant to both sectors. Is this beginner-friendly? Yes. Whether you’re just starting or switching roles, the bundle is suitable for all skill levels. Do I need any special software? No, you can access everything online with your browser. Why should I act now? Because hiring managers want prepared candidates—and this bundle prepares you 20 times over.

Elevate your leadership profile with a 20-in-1 course bundle tailored to help you manage teams, navigate crises, and communicate with impact. Built for those who aim to lead — not just participate. Description Stakeholder management is no longer optional — it’s a top skill for anyone in leadership, project coordination, HR, or operations. Whether you're managing clients, team dynamics, or cross-department collaboration, employers want professionals who can lead with logic and communicate with confidence. This high-impact bundle strengthens your job-readiness across compliance, negotiation, reporting, and digital productivity. Whether you're climbing the corporate ladder or making a lateral move into leadership, this comprehensive training makes your CV a hiring manager’s shortlist favourite. Remember, opportunities don’t wait — and neither does enrolment. Seats are limited, and the most career-conscious professionals are already securing theirs. Don’t miss your chance to become the person businesses rely on. FAQ Q: Who is this bundle ideal for? A: Team leaders, project managers, client-facing professionals, and anyone stepping into stakeholder roles. Q: Does it help me become more employable? A: Absolutely — it shows you’re capable of managing both people and performance under pressure. Q: Is it suitable for those new to leadership? A: Yes. It's a great starting point for professionals seeking their first management role. Q: Can I complete the courses flexibly? A: Yes — all content is online and designed for self-paced learning. Q: Is this worth the investment? A: You're getting 20 industry-relevant skills for less than the price of a single leadership course. Q: Will I receive something I can add to my CV? A: Yes — each completed course boosts your credentials and job appeal.

Position yourself as a hiring expert with this 20-in-1 Recruitment Training bundle — designed to equip you with the essentials needed in HR, staffing, and talent acquisition roles. Description Recruitment today isn’t just about filling positions — it’s about understanding compliance, law, psychology, diversity, and data. This all-in-one training bundle gives you a rounded edge in the HR space, from employment law and payroll to communication and reporting. Whether you're aiming for an internal HR role, a recruitment agency, or freelance staffing projects, this course package ensures your profile is equipped for serious consideration. In an industry where detail, credibility, and regulation matter, being well-prepared isn’t optional — it’s what gets you hired. Space is limited — and HR is a competitive field. This is your chance to show you're more than just an assistant — you're a recruitment-ready professional. FAQ Q: Who should take this bundle? A: Aspiring HR professionals, recruitment consultants, hiring managers, and staffing agency workers. Q: Does it help with job-readiness in recruitment? A: Yes — it covers critical areas employers require in compliance-heavy hiring environments. Q: Can I add these courses individually to my CV? A: Definitely — and it adds depth to your HR profile. Q: Do I need prior HR experience? A: Not at all — this bundle is ideal for both beginners and those transitioning into HR. Q: Is the content flexible? A: Yes — all 20 courses can be completed at your own pace. Q: Why enrol now? A: The best candidates act quickly. With limited enrolment, this is your chance to stay ahead of the hiring curve.

Equip yourself for a career in financial crime prevention, compliance, and regulatory investigations with this AML Analyst 20-in-1 bundle. Built to impress employers across financial services and legal sectors, this training suite marks you as hireable, trustworthy, and analysis-ready. Description AML analysts don’t just check boxes—they uncover risks, flag anomalies, and protect institutions from fraud and penalties. With the rise of digital finance, demand for trained AML professionals has surged. But roles aren’t going to candidates without the right blend of legal, analytical, and reporting skills. This bundle reflects exactly what AML recruiters want: legal knowledge, software familiarity, communication skills, and analytical precision. Whether you’re aiming for a new role or building on existing admin or finance experience, this bundle offers undeniable value. If you want to break into compliance or enhance your credibility in financial operations, now’s the time to certify. The job market rewards those who are already prepared. FAQ Is this bundle suited for a future in AML or risk analysis? Yes, it’s perfect for aspiring AML analysts, compliance assistants, and financial risk staff. Do I need prior compliance knowledge? No—this is designed for beginners and early-career professionals. Are certificates included? Yes. Each of the 20 courses provides a digital certificate upon completion. Which industries recognise this training? Banking, legal services, insurance, fintech, corporate finance, and regulatory consultancy. Can I access the content anytime? Yes. You’ll have lifetime access, so you can pace your learning flexibly. What’s the urgency? AML enforcement is growing stricter—and skilled analysts are in short supply. Get certified before the next recruitment wave hits.

Food safety is serious business—whether you’re advising hospitality teams, auditing kitchens, or ensuring compliance in public health. This 20-in-1 Food Health & Safety Consultant bundle prepares you to become a job-ready professional trusted across sectors. Hygiene, nutrition, and safety roles are growing fast. Get certified before the next recruitment wave. 🔍 Description If you're aiming for roles in food inspection, health consultancy, or compliance management within hospitality and catering, this bundle was built with you in mind. Employers today look for candidates who understand not just food science, but also public health priorities, reporting skills, and team leadership. This training suite covers 20 employment-relevant areas—making your CV instantly more attractive to recruiters in the food, healthcare, education, and wellbeing sectors. From kitchen compliance to child nutrition, it's a career-focused bundle with both breadth and credibility. With 20 industry-relevant certificates in one low-cost package, this is a high-value shortcut to standing out in job applications where competition is tough. ❓ FAQ Q: What roles could this bundle help me land? A: Food Safety Consultant, Health & Hygiene Advisor, Catering Compliance Officer, or Nutrition Support Coordinator. Q: Is it suitable for hospitality or education roles? A: Yes—it's perfect for those targeting schools, hospitals, catering services, or food brands. Q: Will I get certificates for each course? A: Yes—every course provides a certificate of completion for your professional portfolio. Q: Do I need a scientific background to take this? A: No—it's designed for anyone pursuing food safety or public health career paths. Q: Can I study these courses at my own pace? A: Yes, you’ll have lifetime access with no deadlines.

Course overview Take a practical approach to enhance your Excel modelling skills with the Advanced Excel Models using Formulas, VBA & Power Query course. In this course, you will learn how to build robust Excel models using Formulas, VBA and Power Query. This Advanced Excel Models using Formulas, VBA & Power Query course offers a wide range of training modules to enhance your abilities to create better models. You will discover the advanced Excel formulas to prepare reports, forecast and perform mathematical calculations. We will introduce you to the three excel models and show the functions used to prepare these pro models. In addition, you will learn the Excel formulas for prepaid expenses and explore the steps to create dynamic dashboards based on Power Query and Pivot Table without any formula. Learning outcomes Familiarize yourself with the advanced Excel formulas Be able to manage prepaid expenses Deepen your understanding of the prepaid expense models Learn about the pro Excel models and formulas Strengthen your knowledge of Power Query and PowerPivot Learn how to create Power query and pivot table based dashboard without any formula Who Is This Course For? This Advanced Excel Models using Formulas, VBA & Power Query course is recommended to anyone interested in learning how to prepare robust Excel models using advanced formulas, Power Query and VBA. In addition, the skills gained from this training will provide excellent opportunities for career advancement. Entry Requirement This course is available to all learners of all academic backgrounds. Learners should be aged 16 or over. Good understanding of English language, numeracy and ICT skills are required to take this course. Certification After you have successfully completed the course, you will obtain an Accredited Certificate of Achievement. And, you will also receive a Course Completion Certificate following the course completion without sitting for the test. Certificates can be obtained either in hardcopy for £39 or in PDF format at the cost of £24. PDF certificate's turnaround time is 24 hours, and for the hardcopy certificate, it is 3-9 working days. Why Choose Us? Affordable, engaging & high-quality e-learning study materials; Tutorial videos and materials from the industry-leading experts; Study in a user-friendly, advanced online learning platform; Efficient exam systems for the assessment and instant result; United Kingdom & internationally recognized accredited qualification; Access to course content on mobile, tablet and desktop from anywhere, anytime; Substantial career advancement opportunities; 24/7 student support via email. Career Path The Advanced Excel Models using Formulas, VBA & Power Query Course provides essential skills that will make you more effective in your role. It would be beneficial for any related profession in the industry, such as: Data Analyst System Support and Reporting Analyst 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 Thankyou 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 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00