12848 Manager courses delivered Online

Overview This comprehensive course on Microsoft Excel: Automated Dashboard Using Advanced Formula, VBA, Power Query will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Microsoft Excel: Automated Dashboard Using Advanced Formula, VBA, Power Query comes with accredited certification which will enhance your CV and make you worthy in the job market. So enrol in this course today to fast track your career ladder. How will I get my certificate? You may have to take a quiz or a written test online during or after the course. After successfully completing the course, you will be eligible for the certificate. Who is this course for? There is no experience or previous qualifications required for enrolment on this Microsoft Excel: Automated Dashboard Using Advanced Formula, VBA, Power Query. It is available to all students, of all academic backgrounds. Requirements Our Microsoft Excel: Automated Dashboard Using Advanced Formula, VBA, Power Query is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible on tablets and smartphones so you can access your course on wifi, 3G or 4G. There is no time limit for completing this course, it can be studied in your own time at your own pace. Career path Having these various qualifications will increase the value in your CV and open you up to multiple sectors such as Business & Management, Admin, Accountancy & Finance, Secretarial & PA, Teaching & Mentoring etc. Course Curriculum 12 sections • 76 lectures • 06:08:00 total length •Course Outline and Introduction: 00:04:00 •Minimum Requirements for the Course: 00:01:00 •Prepayments Introduction: 00:01:00 •Month End Date Prepaid Expenses Amortization Calculation: 00:00:00 •Exact Prepaid Expenses Payment Date Calculation: 00:00:00 •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 •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 •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 •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 •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 •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 •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 •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: 00:02:00 •Ultimate Prepaid Expenditure Model (Super Bonus): 00:02:00 •Resources - Microsoft Excel: Automated Dashboard Using Advanced Formula, VBA, Power Query: 00:00:00

Gain essential skills for the funeral service industry with our Funeral Service Management Diploma. Learn funeral arrangement, etiquette, marketing, and more. Start your journey today!

This comprehensive digital marketing bundle course empowers you to unlock the potential of various online marketing channels. You'll explore the fundamentals of website creation, email marketing, and video marketing, providing a strong foundation for building an online presence. Delving deeper, you'll master the art of social media advertising, focusing on the two powerhouses - Facebook Ads and Instagram Ads.

Description: This fantastic diploma in restaurant and food management course is designed for the individuals who are looking for a change in their career. People who are already into this industry but are willing to enhance their skills and wish to undertake further training. This course will provide you with a comprehensive introduction to main sectors of the service industry. It will also teach you about the different types of food and beverage products, host responsibilities, catering utilities and kitchen commodities. Who is the course for? This course is for the people who are willing to take restaurant and food management as their future career. People already working in this field are willing to gain further training or enhance their skills. Entry Requirement: This course is available to all learners, of all academic backgrounds. Learners should be aged 16 or over to undertake the qualification. Good understanding of English language, numeracy and ICT are required to attend this course. Assessment: At the end of the course, you will be required to sit an online multiple-choice test. Your test will be assessed automatically and immediately so that you will instantly know whether you have been successful. Before sitting for your final exam you will have the opportunity to test your proficiency with a mock exam. Certification: After you have successfully passed the test, you will be able to obtain an Accredited Certificate of Achievement. You can however also obtain a Course Completion Certificate following the course completion without sitting for the test. Certificates can be obtained either in hard copy at a cost of £39 or in PDF format at a 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/materials from the industry leading experts; Study in a user-friendly, advanced online learning platform; Efficient exam systems for the assessment and instant result; The UK & internationally recognised accredited qualification; Access to course content on mobile, tablet or desktop from anywhere anytime; The benefit of career advancement opportunities; 24/7 student support via email. Career Path: Catering business Hotel manager Banquet service Food and beverage operator Event and meeting planner Restaurant administration. Diploma in Restaurant and Food Management - Updated Version Introduction to Hospitality Management 00:21:00 An Overview of Hotel Industry 00:15:00 Restaurant Industry 00:32:00 Restaurant Leadership and Management 00:22:00 The Process of Selection and Recruitment in the Hospitality Industry 00:18:00 The Process of Development and Training in the Hospitality Industry 00:21:00 Management of Front Office Operations 00:16:00 Management of Food and Beverage Operations 00:17:00 Food Safety - An Introduction 00:26:00 Supervision of Food Safety 00:34:00 Food Safety Legislation 00:31:00 Food Safety Management System 00:41:00 Food Safety Management Tools 00:27:00 Contamination Hazards 00:26:00 Controlling Contamination 00:36:00 Food Poisoning (Bacterial) and Food-Borne Illness 00:29:00 Food Poisoning (Non-Bacterial) 00:29:00 Personal Hygiene 00:27:00 Food Premises and Equipment: The Design and Construction 00:30:00 Pest Management 00:27:00 Food Safety Training for the Staff 00:15:00 Diploma in Restaurant and Food Management - Old Version Starting a Restaurant Are you ready for the challenge? 00:15:00 How to decide on a concept 00:30:00 Designing your restaurant 00:15:00 Friends and family 00:15:00 Writing a Business Plan 00:30:00 Insurance 00:15:00 Restaurant Organizations that you need to check out. 00:15:00 What are the best Catering Industry Trade Shows? 00:15:00 Managing a Restaurant Managing Yourself 00:30:00 Managing Others 00:30:00 Managing Your Money 00:15:00 Managing Your Food and Supplies 00:30:00 Managing Everything Else 00:30:00 Food Business Food Business Basics 00:30:00 Put Together Your Business Concept 00:30:00 Identify your Target Market 00:30:00 Identify Your Competition 00:30:00 Write A Mission Statement 00:30:00 Downline Basics 00:30:00 Equipment And Supplies 00:30:00 Marketing And Quality Control 00:30:00 Wrapping Up 00:15:00 Starting Food Catering Where You Work 00:15:00 Health and safety 00:15:00 Staff, Suppliers and Transport 00:00:00 Food Hygiene 01:00:00 Rules about Menus 00:15:00 Paperwork and Finances 00:15:00 Law 00:15:00 Refer A Friend Refer A Friend 00:00:00 Mock Exam Mock Exam- Diploma in Restaurant and Food Management 00:20:00 Final Exam Final Exam- Diploma in Restaurant and Food Management 00:20:00 Order Your Certificates and Transcripts Order Your Certificates and Transcripts 00:00:00

Blockchain Project Management Training Course Overview This Blockchain Project Management Training course offers a comprehensive introduction to managing projects within the rapidly evolving blockchain and Web3 environments. It equips learners with essential knowledge of project and product management principles tailored specifically for blockchain technology. Participants will gain insights into the unique challenges and opportunities presented by Web3 projects, learning how to navigate this innovative landscape efficiently. By the end of the course, learners will be able to understand key concepts, develop management strategies, and prepare effectively for careers in the blockchain sector. This training is designed to enhance career prospects by providing relevant skills aligned with current industry demands. Course Description This course delves deeply into the fundamentals of project and product management in the context of blockchain technology and Web3. Topics include understanding the roles and responsibilities of a Web3 project manager, critical considerations when overseeing blockchain initiatives, and strategies for securing employment in the blockchain sector. Learners will explore how to manage complex, decentralised projects, balancing technical requirements with business objectives. The course delivers a structured learning experience that sharpens analytical and organisational abilities, helping participants become confident and competent in blockchain project environments. Delivered in clear UK English, this course prepares learners to contribute effectively within one of the most innovative and fast-growing industries today. Blockchain Project Management Training Curriculum Module 01: Introduction Module 02: Project / Product Management in Web Module 03: Important Things to Remember about being a Web3 PM Module 04: Getting a Job in Web3 Module 05: End Notes (See full curriculum) Who Is This Course For? Individuals seeking to understand blockchain project management fundamentals. Professionals aiming to develop a career in blockchain or Web3 project management. Beginners with an interest in blockchain technology and digital innovation. Project managers transitioning into emerging technologies and decentralised systems. Career Path Blockchain Project Manager Web3 Product Manager Digital Transformation Specialist Decentralised Application (dApp) Coordinator Blockchain Consultant

Leadership Skills Training Course Overview This Leadership Skills Training course is designed to equip learners with the essential skills and knowledge required to lead effectively in today's dynamic work environments. The course covers core leadership concepts and strategies, from foundational tips to advanced techniques for enhancing leadership effectiveness. Learners will gain valuable insights into leadership styles, decision-making, team management, and motivating others. By the end of the course, participants will be able to apply these leadership skills to foster collaboration, drive performance, and navigate challenges with confidence. The course is ideal for individuals looking to enhance their leadership abilities and prepare for higher levels of responsibility in their careers. Course Description This comprehensive Leadership Skills Training course provides learners with a deep dive into the key principles of leadership. It covers topics such as foundational leadership concepts, cutting-edge leadership techniques, and strategies to elevate one's leadership approach at various levels. The course also explores practical leadership applications, including how to handle challenges, inspire teams, and make informed decisions. As learners progress through the modules, they will develop a well-rounded leadership style, suitable for managing diverse teams, resolving conflicts, and driving organisational success. The course concludes with insights for wise leadership, emphasising long-term growth and sustainable leadership practices. Participants will leave with the confidence and expertise to step into leadership roles across multiple industries. Leadership Skills Training Curriculum Module 01: Introduction Module 02: Foundational Concepts For Leaders Module 03: Powerful Cutting-Edge Leadership Tips - Foundational Module 04: Powerful Cutting-Edge Leadership Tips - Intermediate Module 05: Powerful Cutting-Edge Leadership Tips - Advanced Module 06: Final Thoughts For Wise Leaders (See full curriculum) Who is this course for? Individuals seeking to enhance their leadership capabilities. Professionals aiming to advance in leadership roles. Beginners with an interest in leadership and management. Managers looking to improve their leadership effectiveness. Career Path Team Leader Department Manager Project Manager Operations Manager Senior Leadership Roles

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

Start an IT Asset Department Course Overview This course provides a comprehensive introduction to starting and managing an IT Asset Department. Designed to equip learners with the knowledge required to establish and streamline IT asset management (ITAM) processes, it covers the key components and strategies for setting up the department, from understanding the department's purpose to maintaining accurate asset records. Learners will gain a solid understanding of the essential skills required to effectively manage IT assets, ensuring proper tracking, reporting, and operations. By the end of the course, learners will have a clear blueprint for setting up their own IT asset department, ready to implement best practices and improve operational efficiency. Course Description The course delves into the fundamental aspects of starting an IT Asset Department, starting with an overview of the department’s critical role within an organisation. Learners will explore the various functions and responsibilities of the IT Asset Management (ITAM) team, the tools needed to track assets, and how to populate and manage a central database. The course will also cover daily operations, including generating reports and ensuring compliance with industry standards. Learners will leave with the skills necessary to build a structured IT asset management department that can oversee asset tracking, database management, and reporting, ensuring better decision-making and efficiency in the management of IT resources. Start an IT Asset Department Curriculum Module 01: Introduction to the Course Module 02: The Missing Department Module 03: ITAM Team and Activities Module 04: Asset Tracking Tool Module 05: Populating the Database Module 06: Daily Operations and Reports Module 07: Was it a Boring Job? (See full curriculum) Who is this course for? Individuals seeking to develop skills in IT asset management. Professionals aiming to establish or optimise an IT asset management department. Beginners with an interest in IT operations and resource management. Managers looking to improve efficiency in IT asset tracking. Career Path IT Asset Manager IT Operations Specialist IT Procurement Manager Asset Tracking Coordinator IT Project Manager

Logistics Management at QLS Level 5 Course Overview The "Logistics Management at QLS Level 5" course offers an in-depth exploration of the logistics industry, focusing on key aspects such as supply chain management, transport planning, and inventory control. Learners will gain a solid understanding of how logistics fits within the broader business context and its impact on organisational efficiency. The course is designed to provide both theoretical knowledge and strategic insights, ensuring that learners are equipped to optimise logistics processes in a variety of settings. Upon completion, learners will have the tools to contribute effectively to logistics and supply chain roles within diverse industries. Course Description This course delves into the complexities of logistics management, covering essential topics such as sourcing, purchasing, and procurement, as well as supplier relationship management. Students will also explore transport management, warehousing principles, and inventory planning, with a strong focus on enhancing operational efficiency. By addressing both the tactical and strategic components of logistics, learners will develop essential skills in negotiation, customer service, and distribution channels. The course is structured to provide a comprehensive understanding of logistics management within the context of modern business operations, preparing learners for roles that demand expertise in managing logistics and supply chain systems. Logistics Management at QLS Level 5 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 (See full curriculum) Who is this course for? Individuals seeking to advance in logistics or supply chain management. Professionals aiming to enhance their expertise in operational efficiency. Beginners with an interest in logistics and supply chain management. Those aspiring to take on leadership roles in logistics or procurement. Career Path Logistics Manager Supply Chain Coordinator Transport Planner Warehouse Operations Supervisor Procurement Manager Distribution Manager Inventory Control Specialist

LinkedIn Marketing Masterclass Course Overview The LinkedIn Marketing Masterclass provides a comprehensive understanding of using LinkedIn as a powerful marketing tool. This course covers everything from creating an optimised LinkedIn profile to developing advanced content strategies, running targeted ad campaigns, and measuring marketing success. It aims to equip learners with the skills to enhance their personal or business brand, increase engagement, and drive traffic to their services or products. By the end of the course, learners will be confident in navigating LinkedIn’s features and tools to generate quality leads and achieve their marketing goals. Course Description This course delves into a variety of key topics, including building a strong LinkedIn presence, understanding LinkedIn’s algorithm, creating effective posts and articles, and leveraging LinkedIn’s advertising platform. Learners will also explore strategies for growing their network, using LinkedIn Analytics to track performance, and mastering the art of personal branding. Throughout the course, participants will gain expertise in developing LinkedIn-specific content strategies, using advanced targeting options for ads, and building a network that supports career or business objectives. By the end, learners will be equipped to maximise their LinkedIn efforts and achieve measurable results. LinkedIn Marketing Masterclass Curriculum: Module 01: Introduction to LinkedIn Marketing Module 02: Setting Up a Strong LinkedIn Profile Module 03: Building Your Network and Connections Module 04: Creating Compelling LinkedIn Content Module 05: Leveraging LinkedIn for Lead Generation Module 06: Using LinkedIn Ads to Boost Visibility Module 07: Understanding LinkedIn Analytics Module 08: Advanced LinkedIn Strategies for Business Growth (See full curriculum) Who is this course for? Individuals seeking to enhance their personal or business brand on LinkedIn. Professionals aiming to advance their careers or establish authority in their industry. Beginners with an interest in using LinkedIn for marketing or networking. Business owners and marketers wanting to utilise LinkedIn as a marketing channel. Career Path Social Media Manager Digital Marketing Specialist Content Strategist LinkedIn Ad Campaign Manager Brand Manager Business Development Executive