• Professional Development
  • Medicine & Nursing
  • Arts & Crafts
  • Health & Wellbeing
  • Personal Development

5591 Courses in Glasgow delivered On Demand

Mastering Organizational Chaos course - CPD Accredited Course

5.0(14)

By Training Express

In fast-paced work environments, chaos can creep in quietly and escalate rapidly. Mastering Organisational Chaos is a CPD Accredited Course designed to help individuals understand, manage, and strategically reduce disruption within organisations. Through a focused five-module structure, this course explores how to prioritise effectively, improve decision-making, and foster clarity even when things feel uncertain. Whether you’re managing a team or streamlining your own workflow, this course offers strategic insights to help you operate more efficiently under pressure. You’ll explore how communication, critical thinking, and thoughtful planning can transform disorder into opportunity. This course isn’t about lofty theories—it’s grounded in proven methods for regaining control, making smarter choices, and keeping priorities aligned with organisational goals. If your workplace feels like it’s constantly firefighting or lacking direction, this course offers structured guidance to help you navigate it with confidence and focus. Course Curriculum: Module 01: Introduction to Organisational Chaos Module 02: Priority-Planning for Managing Organisational Chaos Module 03: Effective Decision Making to Prevent Chaos Module 04: Communication in Organisational Chaos Module 05: Master Chaos With Critical Thinking Course Assessment You will immediately be given access to a specifically crafted MCQ test upon completing an online module. For each test, the pass mark will be set to 60%. Accredited Certificate After successfully completing this Mastering Organizational Chaos course - CPD Accredited course, you will qualify for the CPD Quality Standards (CPD QS) certified certificate from Training Express. CPD 10 CPD hours / points Accredited by The CPD Quality Standards (CPD QS) Who is this course for? The Mastering Organizational Chaos course - CPD Accredited training is ideal for highly motivated individuals or teams who want to enhance their skills and efficiently skilled employees. Requirements There are no formal entry requirements for the course, with enrollment open to anyone! Career path Learn the essential skills and knowledge you need to excel in your professional life with the help & guidance from our Mastering Organizational Chaos course - CPD Accredited training.

Mastering Organizational Chaos course - CPD Accredited Course
Delivered Online On Demand1 hour
£23

Transport Manager - CPD Accredited Course

5.0(14)

By Training Express

Transport management plays a pivotal role in the smooth flow of goods, services, and information across every level of the supply chain. Our Transport Manager – CPD Accredited Course is designed for those keen to understand the strategic and operational aspects of logistics, distribution, procurement, and warehousing. This course offers a clear route into the structure and function of logistics systems, helping learners grasp the foundations of planning, supplier relationships, inventory control, and transport coordination. From logistics planning frameworks to effective negotiation techniques, this course blends essential knowledge with applied logistics management theories. You’ll explore key topics such as sourcing and procurement, channels of distribution, and customer service in logistics—all vital components for those pursuing a career in this ever-evolving sector. Whether you’re looking to enhance your existing knowledge or move into transport coordination or logistics roles, this course offers the insight needed to make informed decisions across the transport and supply chain industry. Still not convinced? Take a glimpse of the key benefits you'll get with - Lessons prepared in collaboration with Professionals User-friendly Learner Management System (LMS) Syllabus designed in line with the standards of the UK Education System Updated Study Materials focusing both on Knowledge and Skill based training Guidance to expand in 'a' territory and move forward with Transport Manager profession Free Assessment to test learners' knowledge and skills Accredited learning and widely certificate from reputed CPD Accreditation Bodies Course Curriculum: Module 01: Introduction to Logistic Management Module 02: Planning Framework for Logistics Module 03: Supply Chain Management Module 04: Logistics Management and Organisation Module 05: Sourcing, Purchasing, and Procurement Module 06: Channels of Distribution Module 07: Supplier Relationship Management Module 08: Inventory Planning and Management Module 09: Principles of Warehousing Module 10: Transport Management Module 11: Negotiation Techniques Module 12: Customer Service and Logistics Course Assessment You will immediately be given access to a specifically crafted MCQ test upon completing the Transport Manager - CPD Accredited course. For each test, the pass mark will be set to 60%. Accredited Certificate After successfully completing this Transport Manager - CPD Accredited course, you will qualify for the CPD Quality Standards (CPD QS) certified certificate from Training Express. CPD 10 CPD hours / points Accredited by The CPD Quality Standards (CPD QS) Who is this course for? The Transport Manager - CPD Accredited training is ideal for highly motivated individuals or teams who want to enhance their skills and efficiently skilled employees. Requirements There are no formal entry requirements for the course, with enrollment open to anyone! Career path Learn the essential skills and knowledge you need to excel in your professional life with the help & guidance from our Transport Manager - CPD Accredited training.

Transport Manager - CPD Accredited Course
Delivered Online On Demand1 hour
£23

Driving Instructor - CPD Accredited Course

5.0(14)

By Training Express

Becoming a driving instructor is a rewarding career path that combines teaching, patience, and expert knowledge of the road. This CPD accredited course provides a thorough introduction to the role, equipping you with essential understanding of structured driver training and the key requirements of the Approved Driving Instructor (ADI) exams. You’ll gain insight into the unique challenges of instructing learners, including strategies for working with new clients and communicating effectively to build confidence behind the wheel. This course also covers specialised topics such as teaching individuals with disabilities and impairments, as well as driving larger vehicles. Each module is designed to deepen your awareness of the responsibilities involved in driver instruction, from assessment techniques to adapting your approach to suit different learners. Whether you’re aiming to become a qualified instructor or expand your knowledge, this training is tailored to help you deliver clear, supportive guidance throughout the learning journey. Still not convinced? Take a glimpse of the key benefits you'll get with - Lessons prepared in collaboration with Professionals User-friendly Learner Management System (LMS) Syllabus designed in line with the standards of the UK Education System Updated Study Materials focusing both on Knowledge and Skill based training Guidance to expand in 'a' territory and move forward with Driving Instructor profession Free Assessment to test learners' knowledge and skills Accredited learning and widely recognised certificate from reputed CPD Accreditation Bodies Course Curriculum: Module 01: The Driving Instructor Module 02: Structured Driver Training Module 03: The ADI Exams Module 04: Communication Skills and Dealing with a New Client Module 05: Learning to Drive Module 06: Driving Large Vehicles Module 07: Assessment Items Module 08: Disabilities and Impairments Course Assessment You will immediately be given access to a specifically crafted MCQ test upon completing the Driving Instructor - CPD Accredited course. For each test, the pass mark will be set to 60%. Accredited Certificate After successfully completing this Driving Instructor - CPD Accredited course, you will qualify for the CPD Quality Standards (CPD QS) certified certificate from Training Express. CPD 10 CPD hours / points Accredited by The CPD Quality Standards (CPD QS) Who is this course for? The Driving Instructor - CPD Accredited training is ideal for highly motivated individuals or teams who want to enhance their skills and efficiently skilled employees. Requirements There are no formal entry requirements for the course, with enrollment open to anyone! Career path Learn the essential skills and knowledge you need to excel in your professional life with the help & guidance from our Driving Instructor - CPD Accredited training.

Driving Instructor - CPD Accredited Course
Delivered Online On Demand1 hour
£23

Construction Site Managment - CPD Accredited Course

5.0(14)

By Training Express

The Construction Site Management - CPD Accredited Course offers a thorough exploration of the essential elements required to oversee and direct construction projects efficiently. From the fundamentals of site management to the intricacies of cost and stock control, this course covers the critical areas that contribute to successful project delivery. It guides learners through effective equipment planning, materials handling, and supply chain coordination — all vital for maintaining smooth operations on any construction site. Designed for those aiming to enhance their understanding of construction management processes, this course delivers clear, structured knowledge to help manage resources, budgets, and vendor relationships with confidence. Whether you're involved in project oversight or aiming to refine your managerial approach, the curriculum provides insightful strategies to handle preliminary site investigations and organisation effectively. This online learning experience allows you to deepen your grasp of construction management, supported by CPD accreditation to validate your professional development. Course Curriculum: Module 01: Introduction to Construction Management Module 02: Site Management Module 03: Cost Estimation Module 04: Cost Management Module 05: Planning and Management of Equipment Module 06: Construction Materials Management Module 07: Stock Control Module 08: Supply Chain Management Module 09: Preliminary Site Investigation and Site Organisation Module 10: Vendor Analysis in Construction Management Course Assessment You will immediately be given access to a specifically crafted MCQ test upon completing an online module. For each test, the pass mark will be set to 60%. Accredited Certificate After successfully completing this Construction Site Managment - CPD Accredited course, you will qualify for the CPD Quality Standards (CPD QS) certificate from Training Express. CPD 10 CPD hours / points Accredited by The CPD Quality Standards (CPD QS) Who is this course for? The Construction Site Managment - CPD Accredited training is ideal for highly motivated individuals or teams who want to enhance their skills and efficiently skilled employees. Requirements There are no formal entry requirements for the course, with enrollment open to anyone! Career path Learn the essential skills and knowledge you need to excel in your professional life with the help & guidance from our Construction Site Managment - CPD Accredited training.

Construction Site Managment - CPD Accredited Course
Delivered Online On Demand1 hour
£23

Time Management - CPD Accredited Course

5.0(14)

By Training Express

Mastering time management is essential in today’s fast-paced environment, helping you enhance productivity and reduce stress. This course offers clear, straightforward guidance on how to assess your current habits, prioritise tasks effectively, and set achievable goals. By learning to manage your time wisely, you gain control over your workload and create space for what truly matters, both professionally and personally. Through expertly designed modules, you’ll discover proven techniques to overcome procrastination and develop a reliable plan of action that fits your style. This course also explores the art of anticipating potential challenges, enabling you to stay one step ahead. Whether you’re aiming to improve your efficiency or simply want to create better work-life balance, this CPD-accredited programme provides the essential tools to transform your approach to managing time. Course Curriculum: Module 01: Importance and Benefits of Time Management Module 02: Assess Your Current Work Practice Module 03: Identify the Priorities Module 04: Overcome Procrastination Module 05: Set Your Goals Module 06: Plan The Work and Work The Plan Module 07: Effective Time Management Techniques Module 08: The Art of Anticipating Course Assessment You will immediately be given access to a specifically crafted MCQ test upon completing an online module. For each test, the pass mark will be set to 60%. Accredited Certificate After successfully completing this Time Management - CPD Accredited course, you will qualify for the CPD Quality Standards (CPD QS) certified certificate from Training Express. CPD 10 CPD hours / points Accredited by The CPD Quality Standards (CPD QS) Who is this course for? The Time Management - CPD Accredited training is ideal for highly motivated individuals or teams who want to enhance their skills and efficiently skilled employees. Requirements There are no formal entry requirements for the course, with enrollment open to anyone! Career path Learn the essential skills and knowledge you need to excel in your professional life with the help & guidance from our Time Management - CPD Accredited training.

Time Management - CPD Accredited Course
Delivered Online On Demand1 hour
£23

Product Management - CPD Accredited Course

5.0(14)

By Training Express

Product management is at the heart of successful businesses, guiding the journey from idea to market success. This course offers a thorough exploration of the essential concepts behind managing products effectively, equipping learners with the knowledge to navigate product lifecycles, pricing strategies, and market positioning. It covers everything from understanding different product types and classifications to crafting detailed product plans that align with business objectives. Whether you’re new to the field or seeking to deepen your understanding, this course provides valuable insights into the strategic side of product management. Through well-structured modules, participants will explore the stages of new product development, analyse brand and product portfolios, and examine channels management to optimise distribution. The course also delves into marketing basics and financial analysis, enabling a rounded perspective on how products contribute to business growth. Delivered entirely online, this CPD-accredited programme is designed to enhance your expertise without the need for physical attendance, making it an accessible choice for busy professionals looking to refine their product management capabilities. Course Curriculum: Module 01: Introduction to Product Management Module 02: Product Classification Module 03: Developing the Product Plan Module 04: New Product Development Module 05: Levels of a Product and Product Life Cycle Module 06: Product Pricing Strategy Module 07: Product and Brand Portfolio Analysis Module 08: Channels Management Module 09: Basics of Marketing for Products Module 10: Financial Analysis for Product Management Course Assessment You will immediately be given access to a specifically crafted MCQ test upon completing an online module. For each test, the pass mark will be set to 60%. Accredited Certificate After successfully completing this Product Management - CPD Accredited course, you will qualify for the CPD Quality Standards (CPD QS) certified certificate from Training Express. CPD 10 CPD hours / points Accredited by The CPD Quality Standards (CPD QS) Who is this course for? The Product Management - CPD Accredited training is ideal for highly motivated individuals or teams who want to enhance their skills and efficiently skilled employees. Requirements There are no formal entry requirements for the course, with enrollment open to anyone! Career path Learn the essential skills and knowledge you need to excel in your professional life with the help & guidance from our Product Management - CPD Accredited training.

Product Management - CPD Accredited Course
Delivered Online On Demand1 hour
£23

Journalism - CPD Accredited Course

5.0(14)

By Training Express

The Journalism - CPD Accredited Course offers an insightful journey into the dynamic world of news and storytelling. Designed for anyone interested in the principles and practices that shape modern journalism, this course covers everything from the history and development of the field to the specifics of newspaper, radio, and television journalism. With modules dedicated to interviewing techniques, media regulations, and the ethics that guide responsible reporting, learners will gain a solid foundation in the essential elements that drive credible journalism today. Beyond traditional formats, the course explores niche journalism, feature writing, and the expanding realm of online and freelance journalism, reflecting the evolving landscape of media. Legal aspects such as defamation and journalism law are also thoroughly addressed, providing clarity on the boundaries journalists must navigate. Whether your aim is to write compelling stories or understand the mechanisms behind the news, this course is structured to build knowledge, sharpen writing skills, and foster an appreciation for journalism’s role in society — all through an accessible, fully online platform tailored for self-paced learning. Still not convinced? Take a glimpse of the key benefits you'll get with - Lessons prepared in collaboration with Professionals User-friendly Learner Management System (LMS) Syllabus designed in line with the standards of the UK Education System Updated Study Materials focusing both on Knowledge and Skill based training Guidance to expand in 'a' territory and move forward with Journalist profession Free Assessment to test learners' knowledge and skills Course Curriculum: Module 01: Introduction and Principles of Journalism Module 02: History and Development of Journalism Module 03: Interviewing Module 04: Newspaper Journalism Module 05: News Writing, Production and Reporting Module 06: Television Journalism Module 07: Radio Journalism Module 08: Media Regulatory Bodies Module 09: Writing Skills for Journalists Module 10: Journalism law Module 11: Defamation Module 12: Journalism Ethics Module 13: Health and Safety for Journalists Module 14: Niche Journalism Module 15: Tips on Writing a Good Feature Story Module 16: Online and Freelance Journalism Module 17: Becoming a Journalist Course Assessment You will immediately be given access to a specifically crafted MCQ test upon completing the Journalism - CPD Accredited course. For each test, the pass mark will be set to 60%. Accredited Certificate After successfully completing this Journalism - CPD Accredited course, you will qualify for the CPD Quality Standards (CPD QS) certified certificate from Training Express. CPD 10 CPD hours / points Accredited by The CPD Quality Standards (CPD QS) Who is this course for? The Journalism - CPD Accredited training is ideal for highly motivated individuals or teams who want to enhance their skills and efficiently skilled employees. Requirements There are no formal entry requirements for the course, with enrollment open to anyone! Career path Learn the essential skills and knowledge you need to excel in your professional life with the help & guidance from our Journalism - CPD Accredited training.

Journalism - CPD Accredited Course
Delivered Online On Demand1 hour
£23

Financial Controller Training - CPD Accredited Course

5.0(14)

By Training Express

This Financial Controller Training course is designed to equip aspiring and current finance professionals with a thorough understanding of the key responsibilities and knowledge required to excel in the role of a financial controller. Covering essential topics such as financial statements, ratio analysis, and budgeting, the course provides a detailed insight into how financial information is prepared, analysed, and utilised to guide business decisions. You will gain clarity on the processes involved in financial planning, budgetary control, and internal controls, ensuring a strong grasp of how to manage a company’s financial health effectively. With a focus on strategic management decisions and financial audit procedures, this course offers the knowledge needed to interpret financial data and influence organisational direction. Delivered entirely online, it suits those seeking to develop their financial expertise without the constraints of physical attendance. By completing this CPD accredited training, participants will be well-prepared to contribute confidently to financial oversight, supporting businesses in achieving sound fiscal management and long-term success. Course Curriculum: Module 01: The Concept of Financial Controller Module 02: Financial Statement Module 03: Financial Analysis Module 04: Ratio Analysis Module 05: Planning, Budgeting and Forecasting Module 06: Budgetary Control Module 07: Internal Control and Cash Module 08: Strategic Management Decision Module 09: Financial Audit Course Assessment You will immediately be given access to a specifically crafted MCQ test upon completing an online module. For each test, the pass mark will be set to 60%. Accredited Certificate After successfully completing this Financial Controller Training - CPD Accredited course, you will qualify for the CPD Quality Standards (CPD QS) certified certificate from Training Express. CPD 10 CPD hours / points Accredited by The CPD Quality Standards (CPD QS) Who is this course for? The Financial Controller Training - CPD Accredited training is ideal for highly motivated individuals or teams who want to enhance their skills and efficiently skilled employees. Requirements There are no formal entry requirements for the course, with enrollment open to anyone! Career path Learn the essential skills and knowledge you need to excel in your professional life with the help & guidance from our Financial Controller Training - CPD Accredited training.

Financial Controller Training - CPD Accredited Course
Delivered Online On Demand1 hour
£23

Land Management - CPD Accredited Course

5.0(14)

By Training Express

Land management is an essential discipline focused on the sustainable use, planning, and protection of land resources. This CPD-accredited course offers a thorough exploration of land use principles, soil conservation, and the challenges posed by land degradation. Through detailed study of land tenure, administration, and the legal frameworks that govern land registration and acquisition, learners will gain a solid understanding of how to manage land effectively within diverse contexts. The course also covers watershed and irrigation management, addressing vital aspects of environmental stewardship and resource optimisation. Designed for professionals seeking to deepen their knowledge in land management, this course provides insight into the interconnected roles of policy, environmental factors, and administrative processes. Whether involved in planning, agriculture, environmental consultancy, or property administration, participants will find the modules tailored to broaden their expertise. With a strong focus on theory supported by current best practices, this course serves as a valuable resource for those aiming to enhance their understanding of sustainable land stewardship and regulatory frameworks. Course Curriculum: Module 01: Land Management: An Introduction Module 02: Land Use and Land Use Planning Module 03: Soil Management Module 04: Land Degradation and Management Module 05: Weed Management Module 06: Watershed Management Module 07: Irrigation Management Module 08: Land Tenure, Administration and Transection Module 09: Land Registration and Acquisition Module 10: Land Law Course Assessment You will immediately be given access to a specifically crafted MCQ test upon completing an online module. For each test, the pass mark will be set to 60%. Accredited Certificate After successfully completing this Land Management - CPD Accredited course, you will qualify for the CPD Quality Standards (CPD QS) certified certificate from Training Express. CPD 10 CPD hours / points Accredited by The CPD Quality Standards (CPD QS) Who is this course for? The Land Management - CPD Accredited training is ideal for highly motivated individuals or teams who want to enhance their skills and efficiently skilled employees. Requirements There are no formal entry requirements for the course, with enrollment open to anyone! Career path Learn the essential skills and knowledge you need to excel in your professional life with the help & guidance from our Land Management - CPD Accredited training.

Land Management - CPD Accredited Course
Delivered Online On Demand1 hour
£23

Advanced Excel Models using Formulas, VBA & Power Query

4.3(43)

By John Academy

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

Advanced Excel Models using Formulas, VBA & Power Query
Delivered Online On Demand6 hours 8 minutes
£18