9887 Courses

Updated On: March 2024 24 Hours Left! Don't Let the Deal Slip Away - Enrol Now in this Event Management Course! Ever dreamed of being the mastermind behind a show-stopping event? Imagine the thrill of transforming a blank canvas into a captivating experience, from intimate weddings to electrifying concerts. The UK events industry, a £70 billion powerhouse by 2025, thrives on those who can make it happen. Do you have the creativity to spark ideas, the organisation to juggle details, and the resilience to navigate the unexpected? This Event Management Diploma unlocks your potential to become the conductor of unforgettable moments. Our Event Management Diploma is your backstage pass to a world of possibilities. From brainstorming captivating concepts to selecting vendors and leading your team, you'll master essential skills. Learn to budget like a champ, handle administrative tasks with ease, and ensure a smooth post-event experience. Courses Are Included In this Event Management: Course 01: Diploma of Event Management Diploma Course 02: Event Planner Course Course 03: Hospitality Management Course 04: Catering Management Course 05: Organisational Skills Course For Administrator Due to the apparent nature of this industry, event management professionals are exposed to a far larger range of activities; hence no day will be the same. Furthermore, being a competent event management expert entails a lot more than many people think. Learning event management will give you a head start in your chosen career. Ditch the sidelines and step into the spotlight - enrol today! Learning Outcomes Identify & plan for different event types, each with its unique needs. Master brainstorming techniques to spark innovative event concepts. Source and manage suitable entertainment, turning events electric. Lead and coordinate support staff to ensure flawless execution. Collaborate with technical staff for seamless audio-visual and logistical magic. Evaluate vendors, negotiate contracts, and manage them for optimal service. Why Choose Us? Get a Free CPD Accredited Certificate upon completion of Event Management Get a free student ID card with Event Management Training program (£10 postal charge will be applicable for international delivery) The Event Management is affordable and simple to understand This course is entirely online, interactive lesson with voiceover audio Get Lifetime access to the Event Management course materials The Event Management comes with 24/7 tutor support Diploma of Event Management Diploma Module 01: Types of Events Explores various types of events, including corporate, social, and non-profit events, highlighting the unique planning considerations and objectives for each. Module 02: Brainstorming Covers techniques for brainstorming event ideas, fostering creativity, and generating innovative concepts to meet client or organizational goals. Module 03: Types of Entertainment Discusses different entertainment options suitable for various events, including live performances, DJs, and interactive activities, emphasizing the importance of aligning entertainment with event themes. Module 04: Support Staff Focuses on the roles and responsibilities of support staff in event planning, including ushers, security, and catering staff, ensuring seamless event execution. Module 05: Technical Staff Examines the critical role of technical staff, such as audio-visual technicians and lighting specialists, in creating a professional and engaging event atmosphere. Module 06: Vendors Provides insights into selecting and managing vendors, including caterers, decorators, and equipment suppliers, to ensure quality and reliability. Module 07: Finalize the Plan Details the steps to finalize event plans, including securing contracts, confirming details with stakeholders, and preparing contingency plans. Module 08: Administrative Tasks Covers essential administrative tasks in event planning, such as budgeting, scheduling, and maintaining documentation, to ensure organized and efficient operations. Module 09: Get Organized Offers strategies for staying organized throughout the event planning process, including using checklists, timelines, and project management tools. Module 10: Post Event Activities Focuses on post-event activities, including evaluating event success, gathering feedback, and handling follow-up tasks to improve future events. Take a step toward a brighter future! How will I get my Certificate? After successfully completing the course, you will be able to order your Certificates as proof of your achievement. PDF Certificate: Free (Previously it was £12.99) CPD Hard Copy Certificate: £29.99 QLS Endorsed Hard Copy Certificate: £79 CPD 230 CPD hours / points Accredited by CPD Quality Standards Module 01: Types of Events 04:03 1: Types of Events Preview 04:03 Module 02: Brainstorming 04:28 2: Brainstorming 04:28 Module 03: Types of Entertainment 04:16 3: Types of Entertainment 04:16 Module 04: Support Staff 03:28 4: Support Staff 03:28 Module 05: Technical Staff 02:50 5: Technical Staff 02:50 Module 06: Vendors 02:57 6: Vendors 02:57 Module 07: Finalize the Plan 03:51 7: Finalize the Plan 03:51 Module 08: Administrative Tasks 03:33 8: Administrative Tasks 03:33 Module 09: Get Organized 03:26 9: Get Organized 03:26 Module 10: Post Event Activities 03:09 10: Post Event Activities 03:09 Assessment (Optional) 02:00 11: Assignment On - Award in Event Management at QLS Level 2 02:00 Order Your Certificate 02:00 12: Order Your CPD Certificate 01:00 13: Order Your QLS Endorsed Certificate 01:00 Free Course 01: Event Planner Course 2:53:33 14: Module 01: Introduction to Event Management 13:09 15: Module 02: Role of an Event Planner 18:34 16: Module 03: Event Classification 16:25 17: Module 04: Events and Clients 10:45 18: Module 05: Steps to Plan an Event 16:55 19: Module 06: Invitation to the Event 15:11 20: Module 07: Event Marketing 19:11 21: Module 08: Catering at Events 12:57 22: Module 09: Event Decorations 13:20 23: Module 10: Cleaning and Waste Disposal 13:07 24: Module 11: Event Security 09:21 25: Module 12: Developing an Event Planning Business 14:38 Free Course 02: Hospitality Management 2:05:42 26: Module 01: Introduction to Hospitality Management 10:20 27: Module 02: An Overview of Hotel Industry 08:12 28: Module 03: The Process of Selection and Recruitment in Hospitality Industry 10:56 29: Module 04: The Process of Development and Training in Hospitality Industry 11:05 30: Module 05: Management of Front Office Operations 08:44 31: Module 06: Management of Housekeeping, Engineering and Security Operations 13:23 32: Module 07: Management of Food and Beverage Operations 10:08 33: Module 08: Management of Service Quality in Hospitality Industry 10:30 34: Module 09: Marketing in Travel and Tourism Business 10:58 35: Module 10: Accounting in Hospitality Industry 11:19 36: Module 11: Customer Satisfaction 10:05 37: Module 12: E-Hospitality and Technology 10:02 Free Course 03: Catering Management 1:14:12 38: Module 01: An Overview of Catering Business 10:43 39: Module 02: Laws and Legislations Regarding food Safety and Hygiene 10:52 40: Module 03: Food Safety and Hygiene 11:23 41: Module 04: Food Safety in Catering 15:45 42: Module 05: Management of Food and Beverage Operations 14:07 43: Module 06: Marketing and Human Resource 11:22 Free Course 04: Organisational Skills Course For Administrator 43:28 44: Module 01: Remove the Clutter 05:41 45: Module 02: Prioritise 04:16 46: Module 03: Scheduling Your Time 04:21 47: Module 04: To Do Lists 03:35 48: Module 05: Paper and Paperless Storage 04:26 49: Module 06: Organisation in Your Work Area 04:05 50: Module 07: Tools to Fight Procrastination 04:22 51: Module 08: Organizing Your Inbox 04:21 52: Module 09: Avoid the Causes of Disorganization 04:18 53: Module 10: Discipline is the Key to Stay Organised 04:03 Who is this course for? Anybody who is interested in Event Management can enrol in this course. Event Planning Hopefuls Coordination Champs Creative Visionaries Organization Aficionados Requirements There are no requirements for enroling in this Event Management course. Career path This Event Management course will allow you to kickstart or take your career in the related sector to the next stage. Event Manager Wedding Planner Corporate Planner Festival Organiser Conference Manager Certificates CPD Accredited Certificate Digital certificate - Included Award in Event Management at QLS Level 2 Hard copy certificate - £79 Please note that International students have to pay an additional £10 as a shipment fee.

Duration 5 Days 30 CPD hours This course is intended for Operators, administrators, and architects for VMware Horizon should enroll in this course. These individuals are responsible for the creation, maintenance, and or delivery of remote and virtual desktop services. Additional duties can include the implementation, support, and administration of an organization's end-user computing infrastructure. Overview By the end of the course, you should be able to meet the following objectives: Recognize the features and benefits of Horizon Use VMware vSphere to create VMs to be used as desktops for Horizon Create and optimize Windows VMs to create Horizon desktops Install and configure Horizon Agent on Horizon desktop Configure and manage the VMware Horizon Client™ systems and connect the client to a VMware Horizon desktop Configure, manage, and entitle desktop pools of full VMs Configure, manage, and entitle pools of instant-clone desktops Create and use Remote Desktop Services (RDS) desktops and application pools Monitor the Horizon environment using Horizon Console Dashboard and Horizon Help Desk Tool Identify Horizon Connection Server installation, architecture, and requirements. Describe the authentication and certification options for a Horizon environment Recognize the integration process and benefits of VMware Workspace ONE Access™ and Horizon 8 Discuss performance and scalability options available in Horizon 8 Describe different security options for the Horizon environment VMware Horizon 8: Deploy and Manage is a five-day combination course of VMware Horizon 8: Skills for Virtual Desktop Management & VMware Horizon 8: Infrastructure Administration. This training collection gives you the hands-on skills to deliver virtual desktops and applications through a single virtual desktop infrastructure platform. You will build on your skills in configuring and managing VMware Horizon© 8 through a combination of lecture and hands-on labs. You learn how to configure and deploy pools of virtual machines and how to provide a customized desktop environment to end-users. Additionally, you will learn how to install and configure a virtual desktop infrastructure platform. You learn how to install and configure VMware Horizon© Connection Server?, VMware Unified Access Gateway?, how to configure a load balancer for use with Horizon, and how to establish Cloud Pod Architecture. Course Introduction Introductions and course logistics Course objectives Introduction to VMware Horizon Recognize the features and benefits of Horizon Describe the conceptual and logical architecture of Horizon Introduction to Use Case Define a use case for your virtual desktop and application infrastructure Convert customer requirements to use-case attributes vSphere for Horizon 8 Explain basic virtualization concepts Use VMware vSphere© Client? to access your Center Server system and VMware ESXi? hosts Create, provision, and remove a virtual machine VMware Horizon Desktops Create a Windows and a Linux virtual machine using vSphere Optimize and prepare Windows and Linux virtual machines to set up Horizon desktop VMs VMware Horizon Agents Outline the configuration choices when installing Horizon Agent on Windows and Linux virtual machines Create a gold master for Windows Horizon desktops VMware Horizon Pools Identify the steps to set up a template for desktop pool deployment List the steps to add desktops to the VMware Horizon© Connection Server? inventory Compare dedicated-assignment and floating-assignment pools Outline the steps to create an automated pool Define user entitlement Explain the hierarchy of global, pool-level, and user-level policies VMware Horizon Client Options Describe the different clients and their benefits Access Horizon desktop using various Horizon clients and HTML Configure integrated printing, USB redirection, and the shared folders option Configure session collaboration and media optimization for Microsoft Teams Creating and Managing Instant-Clone Desktop Pools List the advantages of instant clones Explain the provisioning technology used for instant clone desktop pools Set up an automated pool of instant clones Push updated images to instant clone desktop pools Creating RDS Desktop and Application Pools Explain the difference between an RDS desktop pool and an automated pool Compare and contrast an RDS session host pool, a farm, and an application pool Create an RDS desktop pool and an application pool Access RDS desktops and application from Horizon Client Use the instant clone technology to automate the build-out of RDSH farms Configure load-balancing for RDSHs on a farm Monitoring VMware Horizon Monitor the status of the Horizon components using the Horizon Administrator console dashboard Monitor desktop sessions using the HelpDesk tool Course Introduction Introductions and course logistics Course objectives Horizon Connection Server Recognize VMware Horizon reference architecture Identify the Horizon Connection Server supported features Identify the recommended system requirements for Horizon Connection Server Configure the Horizon event database Outline the steps for the initial configuration of Horizon Connection Server Discuss the ADAM database as a critical component of Horizon Connection Server installation Authentication and Certificates Compare the authentication options that Horizon Connection Server supports Describe the Smartcard authentication options that Horizon Connection Server supports Outline the steps to create a Horizon administrator and custom roles Describe the roles available in a Horizon environment Explain the role that certificates play for Horizon Connection Server Install and configure certificates for Horizon Connection Server Install and configure True SSO in a Horizon environment Workspace ONE Access & Virtual Application Management Recognize the features and benefits of Workspace ONE Access Recognize the Workspace ONE Access console features Explain identity management in Workspace ONE Access Explain access management in Workspace ONE Access Describe the Workspace ONE Access directory integration Describe the Workspace ONE Access directory integration Deploy virtual applications with Workspace services Horizon Protocols Compare the remote display protocols that are available in VMware Horizon Describe the BLAST Display Protocol Codecs Describe BLAST and PCoIP ADMX GPO common configurations Graphic Cards Describe the 3D rendering options available in Horizon 8 Compare vSGA and vDGA List the steps to configure graphics cards for use in a VMware Horizon environment Horizon Scalability Describe the purpose of a replica connection server Explain how multiple Horizon Connection Server instances in a pod maintain synchronization Explain Horizon Cloud Pod Architecture LDAP replication and VIPA Explain Horizon Cloud Pod Architecture scalability options Horizon Security Explain concepts relevant to secure Horizon connections Describe how to restrict Horizon connections. Discuss the benefits of using Unified Access Gateway List the two-factor authentication options that are supported by Unified Access Gateway List Unified Access Gateway firewall rules Describe the situation in which you might deploy Unified Access Gateway instances with one, two, or three network interfaces Additional course details:Notes Delivery by TDSynex, Exit Certified and New Horizons an VMware Authorised Training Centre (VATC) Nexus Humans VMware Horizon 8: Deploy and Manage training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success. While we feel this is the best course for the VMware Horizon 8: Deploy and Manage course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you. Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.

Duration 5 Days 30 CPD hours This course is intended for Workspace ONE UEM operators and administrators, account managers, solutions architects, solutions engineers, sales engineers, and consultants Overview By the end of the course, you should be able to meet the following objectives: Explain and apply the fundamental techniques for launching and maintaining an intelligence-driven, multiplatform endpoint management solution with Workspace ONE UEM Outline the components of Workspace ONE UEM Explain the general features and functionality enabled with Workspace ONE UEM Summarize basic Workspace ONE administrative functions Explain and deploy common Workspace ONE integrations Securely deploy configurations to Workspace ONE UEM managed devices Onboard device endpoints into Workspace ONE UEM Summarize alternative management methodologies for rugged devices Discuss strategies for maintaining environment and device fleet health Configure and deploy applications to Workspace ONE UEM managed devices Analyze a Workspace ONE UEM deployment Enable email access on devices Integrate Workspace ONE UEM with content repositories and corporate file shares Summarize basic troubleshooting methodologies Outline common troubleshooting techniques in the Workspace ONE UEM console Outline common troubleshooting techniques when integrating enterprise solutions in the Workspace ONE UEM console Summarize common troubleshooting strategies for Workspace ONE UEM managed devices Outline common application management troubleshooting techniques in the Workspace ONE UEM console Summarize common troubleshooting techniques for email management in the Workspace ONE UEM console Explain common troubleshooting approaches for the VMware Unified Access Gateway™ platform and individual edge services Outline useful troubleshooting tools, such as the Self-Service Portal and VMware Workspace ONE Assist™ In this five-day course, you learn how to apply the fundamental techniques for launching and maintaining an intelligence-driven, multiplatform endpoint management solution with VMware Workspace ONE© UEM. Through a combination of hands-on labs, simulations, and interactive lectures, you will configure and manage the endpoint life cycle. You will also learn to investigate, analyze, and determine issues that might occur with all the different components of Workspace ONE UEM.By understanding how to effectively troubleshoot product issues, administrators can understand how product services communicate and function, in turn optimizing service and software health management. At the end of five days, you will have the foundational knowledge for effectively managing and conducting basic troubleshooting for Workspace ONE UEM. Course Introduction Introductions and course logistics Course objectives Online resources and references Platform Architecture Summarize the features and functionality of Workspace ONE UEM Outline the benefits of leveraging Workspace ONE UEM Recognize the core and productivity components that make up the Workspace ONE UEM platform Summarize high availability and disaster recovery for the Workspace ONE solution Administration Navigate and customize the Workspace ONE UEM console Summarize the hierarchical management structure Explain the features and functions of Workspace ONE Hub Services Outline account options and permissions Enterprise Integrations Outline the process and requirements to integrate with directory services Explain certificate authentication and practical implementation with Workspace ONE Explain the benefits of integrating an email SMTP service into the Workspace ONE UEM console Describe VMware Dynamic Environment Manager? and its architecture Onboarding Outline the prerequisite configurations in the Workspace ONE UEM environment for onboarding devices for management Outline the steps for setting up autodiscovery in the Workspace ONE UEM console Enroll an endpoint through the VMware Workspace ONE© Intelligent Hub app Summarize platform onboarding options Managing Endpoints Explain the differences between device and user profiles Describe policy management options for Windows and macOS Describe the functions and benefits of using compliance policies Explain the use case for Freestyle Orchestrator Describe the capabilities that sensors and scripts enable Alternative Management Methods Describe the function and benefits of device staging Configure product provisioning in the Workspace ONE UEM console Understand the benefits of deploying a VMware Workspace ONE© Launcher? configuration to Android devices List the system and device requirements for Linux device management in Workspace ONE UEM Applications Describe the features, benefits, and capabilities of application management in Workspace ONE UEM Understand and configure deployment settings for public, internal, and paid applications in the Workspace ONE UEM console Describe the benefits of using Apple Business Manager content integration Describe the benefits of using server-to-client software distribution List the functions and benefits of VMware Workspace ONE© SDK Device Email List the email clients supported by Workspace ONE UEM Configure an Exchange Active Sync profile in the Workspace ONE UEM console Configure VMware Workspace ONE© Boxer settings Summarize the available email infrastructure integration models and describe their workflows Configure email compliance policies and notifications services Content Sharing Describe the benefits of using Content Gateway and the Content Gateway workflows Describe the benefits of integrating content repositories with Workspace ONE UEM Configure a repository in the Workspace ONE UEM console Maintenance Manage endpoints from the Device List View and the Device Details View pages Analyze endpoint deployment and compliance data from Monitor Overview page Fundamentals of Troubleshooting Workspace ONE UEM Outline software troubleshooting logic and support methods Summarize the main process flows for the Workspace ONE UEM components Explain the importance of Workspace ONE UEM process flows for troubleshooting Identify different Workspace ONE UEM log files Workspace ONE UEM Console Troubleshooting Outline the best practices for troubleshooting Workspace ONE UEM console issues Identify common group management and assignment-related issues Outline common issues for Workspace ONE UEM console roles and system settings Understand how analytic events can be used to identity platform errors Summarize the steps for collecting and analyzing Workspace ONE UEM console logs Integration Troubleshooting Outline the common enterprise integrations in Workspace ONE UEM Outline common troubleshooting techniques for the VMware AirWatch© Cloud Connector? Troubleshoot issues related to Directory Services integration Identify directory user and groups synchronization issues Troubleshoot issues related to certificate authority integration Explain VMware Workspace ONE© Access? integration and Workspace ONE Intelligent Hub troubleshooting techniques Endpoint Troubleshooting Compare the endpoint connection topologies in Workspace ONE UEM Outline useful tools and resources for endpoint troubleshooting Summarize the best practices for device enrollment troubleshooting Explain device connectivity troubleshooting techniques Demonstrate how to identify and resolve profile-related issues Identify common compliance policy issues and potential root causes Application Troubleshooting Explain the different scoping questions for troubleshooting applications Review application management configurations Summarize the general tools and resources for application troubleshooting Describe the general logic of troubleshooting public applications Understand internal application issues and potential causes Explain purchased application troubleshooting techniques Unified Access Gateway and Edge Services Troubleshooting Review Unified Access Gateway architecture and edge service workflows Understand Unified Access Gateway general configurations Explain how to utilize Unified Access Gateway related troubleshooting tools and resources Identify and resolve common issues for Content Gateway on Unified Access Gateway Summarize troubleshooting techniques for VMware Workspace ONE© Tunnel? on Unified Access Gateway Email Troubleshooting Review different email architecture and workflows Summarize common errors associated with email profiles Identify tools and resources for email troubleshooting Discuss troubleshooting techniques for VMware AirWatch© Secure Email Gateway? on Unified Access Gateway Outline PowerShell integration issues and techniques to address them Additional Troubleshooting Tools Describe how the Self-Service Portal helps administrators and empowers end users to resolve issues Explain how Workspace ONE Assist can help with troubleshooting endpoints

Duration 5 Days 30 CPD hours This course is intended for Storage and virtual infrastructure consultants, solution architects, and administrators who are responsible for production support and administration of VMware vSAN [v7] Overview By the end of the course, you should be able to meet the following objectives: Describe vSAN concepts Detail the underlying vSAN architecture and components Explain the key features and use cases for vSAN Identify requirements and planning considerations for vSAN clusters Describe the different vSAN deployment options Explain how to configure vSAN fault domains Detail how to define and create a VM Storage policy Discuss the impact of vSAN storage policy changes Describe vSAN storage space efficiency Explain how vSAN encryption works Identify requirements to configure vSAN iSCSI target Detail HCI Mesh technology and architecture Detail vSAN file service architecture and configuration Explain the use cases of vSAN Direct Describe how to setup stretched and two-node vSAN clusters Explain the importance vSAN node hardware compatibility Describe the use of VMware vSphere Lifecycle Manager™ to automate driver and firmware installations Detail vSAN resilience and data availability Discuss the vSAN cluster backup methodology Describe the vSAN maintenance mode and data evacuation options Define the steps to shut down a vSAN cluster for maintenance Explain how to use proactive tests to check the integrity of a vSAN cluster Use VMware Skyline Health™ for monitoring vSAN health Apply a structured approach to troubleshoot vSAN cluster configuration and operational problems During this five-day, intensive course, you gain the knowledge, skills, and tools to plan and deploy a VMware vSAN? cluster. You learn about managing and operating vSAN. This course focuses on building the required skills for common Day-2 vSAN administrator tasks such as vSAN node management, cluster maintenance, security operations, and advanced vSAN cluster operations.You also focus on learning the tools and skills necessary to troubleshoot vSAN 7 implementations and gain practical experience with vSAN troubleshooting concepts through the completion of instructor-led activities and hands-on lab exercises.This course is a combination of the following courses: VMware vSAN: Plan and Deploy, VMware vSAN: Management and Operations, and VMware vSAN: Troubleshooting. Course Introduction Introductions and course logistics Course objectives Introduction to vSAN Describe vSAN architecture Describe the vSAN software components: CLOM, DOM, LSOM, CMMDS, and RDT Identify vSAN objects and components Describe the advantages of object-based storage Describe the difference between All-Flash and Hybrid vSAN architecture Explain the key features and use cases for vSAN Discuss the vSAN integration and compatibility with other VMware technologies Planning a vSAN Cluster Identify requirements and planning considerations for vSAN clusters Apply vSAN cluster planning and deployment best practices Determine and plan for storage consumption by data growth and failure tolerance Design vSAN hosts for operational needs Identify vSAN networking features and requirements Describe ways of controlling traffic in a vSAN environment Recognize best practices for vSAN network configurations Deploying a vSAN Cluster Recognize the importance of hardware compatibility Ensure the compatibility of driver and firmware versioning Use tools to automate driver validation and installation Apply host hardware settings for optimum performance Use vSphere Life Cycle Manager to perform upgrades Deploy and configure a vSAN Cluster using Cluster Quickstart wizard Manually configure a vSAN Cluster using vSphere Client Explain and configure vSAN fault domains Using vSphere HA with vSAN Understand vSAN Cluster maintenance capabilities Describe the difference between implicit and explicit fault domains Create explicit fault domains vSAN Storage Policies Describe a vSAN Object Describe how objects are split into components Explain the purpose of witness components Explain how vSAN stores large objects View object and component placement on the vSAN Datastore Explain how storage policies work with vSAN Define and create a virtual machine storage policy Apply and modify virtual machine storage policies Change virtual machine storage policies dynamically Identify virtual machine storage policy compliance status vSAN Resilience and Data Availability Describe and configure the Object Repair Timer advanced option Plan disk replacement in a vSAN cluster Plan maintenance tasks to avoid vSAN object failures Recognize the importance of managing snapshot utilization in a vSAN cluster Configuring vSAN Storage Space Efficiency Discuss Deduplication and Compression techniques Understand Deduplication and Compression overhead Discuss Compression only mode Configure Erasure Coding Configure swap object Thin Provisioning Discuss Reclaiming Storage Space with SCSI UNMAP Configure TRIM/UNMAP vSAN Security Operations Identify differences between VM encryption and vSAN encryption Perform ongoing operations to maintain data security Describe the workflow of Data-in Transit encryption Identify the steps involved in replacing Key Management Server Introduction to Advanced vSAN Configurations Identify requirements to configure vSAN iSCSI target Detail HCI Mesh technology and architecture Detail vSAN File Service architecture and configuration Explain the use cases of vSAN Direct vSAN Cluster Maintenance Perform typical vSAN maintenance operations Describe vSAN maintenance modes and data evacuation options Assess the impact on cluster objects of entering maintenance mode Determine the specific data actions required after exiting maintenance mode Define the steps to shut down and reboot hosts and vSAN clusters Use best practices for boot devices Replace vSAN Nodes vSAN Stretched and Two Node Clusters Describe the architecture and uses case for stretched clusters Detail the deployment and replacement of a vSAN Witness node Describe the architecture and uses case for two-node clusters Explain the benefits of vSphere HA and vSphere Site Recovery Manager in a vSAN stretched cluster Explain storage policies for vSAN stretched cluster vSAN Cluster Monitoring Describe how the Customer Experience Improvement Program (CEIP) enables VMware to improve products and services Use vSphere Skyline Health for monitoring vSAN Cluster Health Manage alerts, alarms, and notifications related to vSAN in vSphere Client Create and configure custom alarms to trigger vSAN health issues Use IO Insight metrics for monitoring vSAN performance Analyse vsantop performance metrics Use vSAN Proactive Test to detect and diagnose cluster issues vSAN Troubleshooting Methodology Use a structured approach to solve configuration and operational problems Apply troubleshooting methodology to logically diagnose faults and optimize troubleshooting efficiency vSAN Troubleshooting Tools Use Skyline Health for vSAN to identify and correct issues in VMware vSAN Discuss the ways to run various command-line tools Discuss the ways to access VMware vSphere ESXi Shell Use commands to view, configure, and manage your VMware vSphere environment Discuss the esxcli vsan namespace commands Use log files to help vSAN troubleshooting Additional course details:Notes Delivery by TDSynex, Exit Certified and New Horizons an VMware Authorised Training Centre (VATC) Nexus Humans VMware vSAN: Fast Track (v7) training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success. While we feel this is the best course for the VMware vSAN: Fast Track (v7) course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you. Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.

Description: The art of managing multiple financial accounts is called accounting. It is required for businesses in order to manage and predict financial encounters for the company. Whatever the case, accounting is a crucial part of running a business and with the help of this Advanced Accounting Diploma you could be just as important. This course is divided into four parts, and you start with learning the basics of accounting career. You will learn how to be successful, different careers in accounting, business softwares and much more. You will also discover more about accounting career training, how to find jobs in accounting, forensic accounting and free softwares. In the next section you indulge in bookkeeping and payroll management as part of this course and will be able to find out about terminologies, understand balance sheet, financial planning, budgeting and control. Finally you look into the American taxing system including focusing on specific states. This is the ultimate guide to accounting as you get to look into additional subjects such as tax, bookkeeping and payroll as well. So take this course now otherwise your balance sheet will only be weighed down. Who is the course for? Professionals who are seeking work in finance department, particularly in accounting activities People who want to get into banking and understand the financial sector 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 hardcopy at the cost of £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/materials from the industry leading experts; Study in a user-friendly, advanced online learning platform; Efficient exam systems for the assessment and instant result; The UK & internationally recognized accredited qualification; Access to course content on mobile, tablet or desktop from anywhere anytime; The benefit of career advancement opportunities; 24/7 student support via email. Career Path: Advanced Accounting Diploma is a useful qualification to possess and would be beneficial for any professions or career from any industry you are in such as: Accounting Mangers Accountants Bankers Finance Officer Payroll Officer Bookkeeper Finance Administrator Accounting Course Overview (Accounting) 00:05:00 Getting the Facts Straight 00:30:00 The Accounting Cycle 00:30:00 The Key Reports 00:30:00 A Review of Financial Terms 00:30:00 Understanding Debits and Credits 00:15:00 Your Financial Analysis Toolbox 00:30:00 Identifying High and Low Risk Companies 00:30:00 The Basics of Budgeting 00:30:00 Working Smarter 00:10:00 Bookkeeping Module One - Introduction 00:30:00 Module Two - Basic Terminology 01:00:00 Module Three - Basic Terminology (II) 01:00:00 Module Four - Accounting Methods 01:00:00 Module Five - Keeping Track of Your Business 01:00:00 Module Six - Understanding the Balance Sheet 01:00:00 Module Seven - Other Financial Statements 01:00:00 Module Eight - Payroll Accounting Terminology 01:00:00 Module Nine - End of Period Procedures 01:00:00 Module Ten - Financial Planning, Budgeting and Control 01:00:00 Module Eleven - Auditing 01:00:00 Module Twelve - Wrapping Up 00:30:00 Payroll Management What Is Payroll? 00:30:00 Principles Of Payroll Systems 01:00:00 Confidentiality And Security Of Information 00:30:00 Effective Payroll Processing 01:00:00 Increasing Payroll Efficiency 01:00:00 Risk Management in Payroll 00:30:00 Time Management 00:30:00 Personnel Filing 00:30:00 When Workers Leave Employment 01:00:00 Hiring Employees 00:30:00 Paye and Payroll for Employers 01:00:00 Tell HMRC about a New Employee 01:00:00 Net And Gross Pay 00:30:00 Statutory Sick Pay 00:30:00 Minimum Wage for Different types of Work 01:00:00 Tax System in the UK Tax System in the UK 01:00:00 Tax Management USA Individual Tax Saving Ideas 01:00:00 Tax Saving Measures For Business 01:00:00 The Tax Audit 01:00:00 The Ins And Outs Of Federal Payroll Taxes 02:00:00 Why People File Taxes Online 00:30:00 What Are Your County Property Taxes Used For? 00:30:00 Offering Personal Financial Advice -Ameriprise Financial Services 01:00:00 Using Free Tax Preparation Software 00:30:00 Consulting Tax Attorneys - Tax Law Specialists 00:30:00 Delinquent Property Taxes- Three Steps To Deal With Your Delinquent Property Taxes 01:00:00 Federal Income Taxes - How To Deal With Federal Income Taxes? 01:00:00 File State Taxes- E-File System Is The Best Way To File Your State Taxes 00:30:00 Filing Income Taxes- How To File Income Taxes? 01:00:00 Financial Planning Software- Nine Benefits Of Financial Planning Software 01:00:00 Free Taxes- Benefits Of Filing Free Taxes Online 00:30:00 Income Tax Forms- Three Must To Follow If You Desire To Fill Your Income Tax Forms Yourself 00:30:00 LLC Tax Savings- How To Avail LLC Tax Savings 00:30:00 Benefits Of Online Tax Forms Over Traditional Methods 00:30:00 Save On Taxes By Refinancing Your Mortgage 00:30:00 Save On Taxes By Spending Less On Credit 00:30:00 Save On Taxes By Investing In Life Insurance 00:30:00 Save On Taxes: Hot Tips 01:00:00 Save On Taxes With Tax Deductions 01:00:00 Federal Tax Law 2005 For Nonprofit Organizations 00:30:00 Understanding California State Taxes 00:30:00 Make Your Personal Finances Work for You 01:00:00 The Importance of Acquiring a Financial Planning Certificate 00:30:00 Social Development and Financial Planning 01:00:00 An Overview Of Hennepin County Property Taxes 00:30:00 Kentucky State Taxes 01:00:00 Maryland State Taxes 01:00:00 Ohio State Taxes 00:30:00 UBS Financial Services For Small And Large Business 00:30:00 What Is A VP Financial Planner? 00:15:00 Accounting Career Basics A Career in Accounting: Tips on How You Can be Successful 00:30:00 Accountancy Auditing Careers 00:30:00 Accountancy Career Change 00:30:00 Accountancy Career: The Reasons Why You Should Choose Accounting 01:00:00 Accounting/Accountancy Career: Steps to Success 00:30:00 Accounting Auditing Careers 00:30:00 Accounting Careers in Pontypridd 00:30:00 Accounting Careers: Promising Opportunities and Tips 00:30:00 Accounting Dictionary 00:30:00 Accounting Principles and Tulsa 00:30:00 Accounting Software for Small Businesses 00:30:00 Accounting Terms - Profit, Loss and Other Terms 00:30:00 Accounting Career Fundamentals Accounting 00:30:00 Advanced Accounting Career Training 00:30:00 Careers in Accountancy 01:00:00 Church Accounting Software 00:30:00 Finding an Accounting Job 00:30:00 Forensic Accounting 00:30:00 Free Accounting Software 00:30:00 List of Accounting Careers 00:30:00 Services in Financial Accounting 00:30:00 Successful Career in Accounting Even if You're Hit Forty! 00:30:00 The Benefits of an Accountancy Career 00:30:00 Types of Accountancy Career 00:30:00 Accounting Calculation 00:15:00 Reference Books Accounting Principles 00:00:00 Financial Accounting & Reporting 00:00:00 Mock Exam Mock Exam- Advanced Accounting Diploma 00:30:00 Final Exam Final Exam- Advanced Accounting Diploma 00:30:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Most people think working in the legal sector requires you are a lawyer, a top-level solicitor or a paralegal. But in reality, it not true at all! To become a legal secretary, all you need relevant knowledge and information about legal phases to assist attorneys managing their caseload and achieve goals. Through this Legal Secretary Certified Training Course, you will be trained you to become a legal assistant or administrator within a solicitor or barrister office. This course also includes the basic concepts of the legal system along with courts, crime, controversy, law and crime, state courts, and legal terminology. By taking this course, you'll not only qualified as a legal secretary but also can work as a secretary or administrator in any other field. Course Highlights The price is for the whole course including final exam - no hidden fees FREE accredited certificate upon successful completion Efficient exam system with instant results Track progress within own personal learning portal 24/7 customer support via live chat Legal Secretary Certified Training Course has been given CPD accreditation and is one of the best-selling courses available to students worldwide. This valuable course is suitable for anyone interested in working in this sector or who simply wants to learn more about the topic. If you're an individual looking to excel within this field then Legal Secretary Certified Training Course is for you. We've taken this comprehensive course and broken it down into several manageable modules which we believe will assist you to easily grasp each concept - from the fundamental to the most advanced aspects of the course. It really is a sure pathway to success. All our courses offer 12 months access and are designed to be studied at your own pace so you can take as much or as little time as you need to complete and gain the full CPD accredited qualification. And, there are no hidden fees or exam charges. We pride ourselves on having friendly and experienced instructors who provide full weekday support and are ready to help with any of your queries. So, if you need help, just drop them an email and await a speedy response. Furthermore, you can check the validity of your qualification and verify your certification on our website at anytime. So, why not improve your chances of gaining professional skills and better earning potential. Assessment and Certification 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. After you have successfully passed the final exam, you will be able to order an Accredited Certificate of Achievement at an additional cost of £19 for a PDF copy and £29 for an original print copy sent to you by post or for both £39. Career Path Not only does our CPD and CiQ accredited course look good on your CV, setting you apart from the competition, it can be used as a stepping stone to greater things. Further advance your learning, launch a new career or reinvigorate an existing one. On successful completion of this course, you have the potential to achieve an estimated salary of £30,000. The sky really is the limit. Course Curriculum Legal Secretary Introduction Legal Secretary Introduction 00:06:00 Courts, Crime, and Controversy The Courts and the Criminal Justice System 00:16:00 Actors in the Courthouse 00:10:00 Criminal vs Civil Court Cases 00:16:00 Law on the Books and in Action 00:06:00 Law and Crime The Basis of American Law 00:16:00 Sources of American Law 00:14:00 Civil Disputes and Criminal Law 00:17:00 State Courts State Courts 00:12:00 Arrest to Arraignment Crime and Arrest 00:13:00 Bail 00:10:00 Preliminary Hearing, Grand Jury, and Arraignment 00:06:00 Trials and Juries History of Trials by Jury 00:12:00 Overview of Basic Evidence 00:06:00 Steps In The Trial Process 00:12:00 Appellate Courts Nature of the Appellate Process 00:10:00 Legal Terminology Legal Terminology 00:16:00 Mock Exam Final Exam

In this competitive job market, you need to have some specific skills and knowledge to start your career and establish your position. This Teaching English Diploma course will help you understand the current demands, trends and skills in the sector. The course will provide you with the essential skills you need to boost your career growth in no time. The Teaching English Diploma course will give you clear insight and understanding about your roles and responsibilities, job perspective and future opportunities in this field. You will be familiarised with various actionable techniques, career mindset, regulations and how to work efficiently. This course is designed to provide an introduction to Teaching English Diploma and offers an excellent way to gain the vital skills and confidence to work toward a successful career. It also provides access to proven educational knowledge about the subject and will support those wanting to attain personal goals in this area. Learning Objectives Learn the fundamental skills you require to be an expert Explore different techniques used by professionals Find out the relevant job skills & knowledge to excel in this profession Get a clear understanding of the job market and current demand Update your skills and fill any knowledge gap to compete in the relevant industry CPD accreditation for proof of acquired skills and knowledge Who is this Course for? Whether you are a beginner or an existing practitioner, our CPD accredited Teaching English Diploma course is perfect for you to gain extensive knowledge about different aspects of the relevant industry to hone your skill further. It is also great for working professionals who have acquired practical experience but require theoretical knowledge with a credential to support their skill, as we offer CPD accredited certification to boost up your resume and promotion prospects. Entry Requirement Anyone interested in learning more about this subject should take this Teaching English Diploma course. This course will help you grasp the basic concepts as well as develop a thorough understanding of the subject. The course is open to students from any academic background, as there is no prerequisites to enrol on this course. The course materials are accessible from an internet enabled device at anytime of the day. CPD Certificate from Course Gate At the successful completion of the course, you can obtain your CPD certificate from us. You can order the PDF certificate for £4.99 and the hard copy for £9.99. Also, you can order both PDF and hardcopy certificates for £12.99. Career path The Teaching English Diploma will help you to enhance your knowledge and skill in this sector. After accomplishing this course, you will enrich and improve yourself and brighten up your career in the relevant job market. Course Curriculum Module 01: Introduction Meet Your Teacher 00:01:00 Aims & Objectives 00:02:00 Module 02: ESL for Children Introduction 00:02:00 Basics 00:08:00 Qualities of Childhood Educators 00:06:00 Ideal Classroom 00:03:00 Tips and Tricks 00:08:00 Module 03: ESL for Adults Introduction 00:02:00 Goals 00:08:00 What Adult Students Want 00:05:00 How to Teach Adults 00:04:00 After Class 00:03:00 Module 04: Lesson Planning Introduction 00:02:00 Making Lesson Plans 00:05:00 Simple Lesson Plan 00:04:00 Module 05: Tools & Technology Zoom 00:09:00 Skype 00:07:00 WeChat 00:07:00 Audio 00:06:00 Helpful Additions 00:03:00 Classroom Materials 00:03:00 Module 06: Finding & Managing Customers Finding Students Part 1 00:05:00 Finding Students Part 2 00:07:00 Making an Introduction Video 00:01:00 Introduction to Homework 00:07:00 Effective Homework 00:05:00 Finding Assignments 00:04:00 Module 07: Run an ESL Business Invoicing 00:04:00 Global Payment Methods 00:07:00 Avoiding Common Mistakes 00:03:00 Module 08: Going Forward Course Conclusion 00:01:00 Certificate and Transcript Order Your Certificates or Transcripts 00:00:00

Artists and designers are widely using illustrator to magnify a design, picture, logo, and many more things. Becoming an expert in this field, you can use this program for professional and personal works. To learn vivid uses of this program skillfully, take a look at our Adobe Illustrator CC Beginner course. The contents of the course assist you to pursue the best position in this role. First and foremost, the course teaches you the basic of drawing along with the introduction of tools and its multiple functions. Furthermore, it makes clear the use of illustrator to open new documents, navigate, and use Adobe Bridge. Following that, the course guides you how to draw shapes, edit shapes, use layers, measure objects, apply stroke, fill, and gradients, and transfer the object effectively. Overall, you will learn the use of pen tools, brush to paint, many other tools to apply special effect and many other things. Who is this course for? Adobe Illustrator CC Beginner is suitable for anyone who wants to gain extensive knowledge, potential experience and professional skills in the related field. This course is CPD accredited so you don't have to worry about the quality. Requirements Our Adobe Illustrator CC Beginner is open to all from all academic backgrounds and there are no specific requirements to attend this course. It is compatible and accessible from any device including Windows, Mac, Android, iOS, Tablets etc. CPD Certificate from Course Gate  At the successful completion of the course, you can obtain your CPD certificate from us. You can order the PDF certificate for £9 and the hard copy for £15. Also, you can order both PDF and hardcopy certificates for £22. Career path This course opens a new door for you to enter the relevant job market and also gives you the opportunity to acquire extensive knowledge along with required skills to become successful. You will be able to add our qualification to your CV/resume which will help you to stand out in the competitive job industry. Course Curriculum Introduction Introduction 00:01:00 Introduction to Illustrator Why Adobe Illustrator? 00:03:00 Using Selection Tools 00:02:00 Creating New Documents 00:08:00 Saving Adobe Illustrator Files 00:06:00 Navigating the Interface 00:08:00 Managing Workspaces 00:05:00 Drawing Basics Creating Shapes 00:13:00 Using the Drawing Tools 00:10:00 Mastering the Pen Tool 00:09:00 Editing Shapes 00:08:00 Grouping and Aligning Shapes 00:06:00 Understanding Layers 00:06:00 Putting it all Together 00:07:00 Measuring and Transforming Objects Working with Rules and Guides 00:05:00 Discovering the Transform Panel 00:08:00 Using Transform and Distort 00:04:00 Applying Fills and Strokes Editing Fills with the Color Panel 00:08:00 Editing Fills with the Swatches Panel 00:09:00 Modifying Strokes 00:09:00 Creating Gradients 00:09:00 Using the Freeform Gradient 00:06:00 Setting Type Using Type Tools 00:10:00 Discovering Type Panels 00:08:00 Working with Adobe Fonts 00:04:00 Painting with Brushes Discovering the Brush Panel 00:06:00 Creating Custom Brushes 00:06:00 Using the Blob Brush 00:08:00 Applying Effects Using the Appearance Panel 00:04:00 Understanding the Effects Menu 00:07:00 Exporting from Illustrator Creating PDF's 00:07:00 Exporting to Other Formats 00:08:00 Importing Adobe PDF´s 00:03:00 Understanding Metadata 00:04:00 Printing your Document 00:07:00 Conclusion Course recap 00:01:00 Resources Resources - Adobe Illustrator CC Beginner 00:00:00 Certificate and Transcript Order Your Certificates or Transcripts 00:00:00

leading expert Philip Warford will talk about the options available to protect a disabled person using specialist Wills and Trusts

Quality Guarantee: Promising training excellence, satisfaction gurantee Accredited by CPD UK & Quality License Scheme Tutor Support Unlimited support via email, till you complete the course Recognised Certification: Accepted by thousands of professional bodies Start Anytime With 1 year access to the course materials Online Learning Learn from anywhere, whenever you want Excel is an essential tool for data management and analysis and in this course, you will master everything from the fundamentals to advanced functionalities. You will learn to navigate the interface, create and format spreadsheets and perform calculations with ease and you will unlock the true potential of Excel for business and personal use. This course at a glance Accredited by CPD UK Endorsed by Quality Licence Scheme Understand the basics of Excel Know how to use Excel at an intermediate level Be aware of sum and numerical functions Understand how to manipulate text Know about logical functions Create effective spreadsheets Be confident with lookup functionality and date and time functions Easily use financial functions and sort and filter Progress to using Microsoft Excel at an advanced level Know how to create accurate and clear visual presentations Consolidate and validate data Use pivot table and what-if analysis Understand automation and macros Why Microsoft Excel Training Course right for you? Develop advanced skills in Microsoft Excel training course basic to advanced course, with this course. Learn from scratch or build on prior knowledge, to gain a good understanding of Excel functions. You will learn to accelerate your tasks efficiently using Excel techniques and formulae. The course covers how to create professional reports in no time, with Excel tools for data analysis and creating charts. This course will demystify the functions and tools in easy steps. It will teach you to work smart and save time. It is an excellent addition to your CV and is a valued skill in all businesses. Microsoft Excel Training Course Details Accredited by CPD certificates are accepted by thousands of professional bodies and government regulators here in the UK and around the world. Many organisations look for employees with CPD requirements, which means, that by doing this course, you would be a potential candidate in your respective field.   The Quality Licence Scheme is a brand of the Skills and Education Group, a leading national awarding organisation for providing high-quality vocational qualifications across a wide range of industries. Course Curriculum Microsoft Excel: Basic Level Introduction to Microsoft Excel 0101 Touring the Interface 0102 Enter Data & Saving Workbook 0103 Applying Formulas 0104 Changing a Worksheet's Structure 0105 Find, Replace & Spell Check 0106 Applying Fonts, Background Colors, and Borders 0107 Formatting Numbers and Dates 0108 Making the Fieces fit 0109 Inserting Headers & Footers and Repeating Rows 0110 Managing Large Workbooks Microsoft Excel: Intermediate Level Excel Essentials 0201 Formula Writing (Don't Miss This) Ex 0201 Formula Writing (Don't Miss this) Sum Count Average Functionality - With Conditions 0301 SumIf & SumIfs Ex 0301 SumIf & SumIfs 0302 Count Functions Ex 0302 Count Functions 0303 AverageIf & AverageIfs Ex 0303 AverageIf & AverageIfs Text Functions - Manipulating Text 0401 Change Case (Upper, Lower,Proper) Ex 0401 Change Case (Upper, Lower, Proper) 0402 Separating Text on Symmetrical Data Ex 0402 Separating Text on Symmetrical Data 0403 Separating Text on Non-Symmetrical Data Ex 0403 Separating Text on Non-Symmetrical Data Logical Functions - Working With Conditions 0501 If Functionality Ex 0501 IF Functionality 0502 If with AND Ex 0502 If with AND 0503 If with OR Ex 0503 If with OR 0504 If with 'AND' & 'OR' / IF with Countif Ex 0504 If with 'AND' & 'OR' / IF with Countif 0505 Nested IF (A Genie with 3 wishes) Ex 0505 Nested IF (A Genie with 3 wishes) Lookup Functionality - Burn Simple Find Technique 0601 Vlookup (Exact Match) # 1 Ex 0601 Vlookup (Exact Match) # 1 0602 Type of References (Use of $ sign) 0603 Vlookup (Exact Match) # 2 Ex 0603 Vlookup (Exact Match) # 2 0604 Double Vlookup Ex 0604 Double Vlookup 0605 Vlookup on Duplicate Values Ex 0605 Vlookup on Duplicate Values 0606 Vlookup (Approximate Match) Ex 0606 Vlookup (Approximate Match) 0607 Vlookup with If (Conditional Vlookup) Ex 0607 Vlookup with If (Conditional Vlookup) 0608 Hlookup (Exact Match) Ex 0608 Hlookup (Exact Match) 0609 Hlookup (Approximate Match) Ex 0609 Hlookup (Approximate Match) 0610 Lookup (Don't use this !) Ex 0610 Lookup (Don't use this !) 0611 Vlookup with Match (Create Magical Vlookup) Ex 0611 Vlookup with Match (Create Magical Vlookup) 0612 Match (Gives us Column/Row Index #) Ex 0612 Match (Gives us Column/Row Index #) 0613 Index & Match (Made for Each Other) Ex 0613 (1) Index & Match (Made for Each Other) Ex 0613 (2) Index & Match (Made for Each Other) Date & Time Function - A Tricky Game 0701 How Excel Records Date & Time 0702 Now, Today & Autofill 0703 DateValue & TimeValue 0704 Calculate WorkingDays 0705 DatedIf Financial Functions 0801 Loan Calculation (PMT, PPMT, IPMT etc.) Ex 0801 Loan Calculation (PMT, PPMT, IPMT etc.) 0802 Creating a Loan Table Ex 0802 Creating a Loan Table 0803 Calculate Depriciation Ex 0803 Calculate Depriciation Sort & Filter 0901 Basic Sorting & Shortcut keys Ex 0901 Basic Sorting & Shortcut keys 0902 Sorting Using Custom List Ex 0902 Sorting Using Custom List 0903 Horizontal Sorting Ex 0903 Horizontal Sorting 0904 Basic Filter & Shortcut Keys Ex 0904 Basic Filter & Shortcut Keys 0905 Filter Problem # 1 (Copy Filtered Data without hidden rows) Ex 0905 Filter Problem # 1 (Copy Filtered Data without hidden rows) 0906 Filter Problem # 2 (Pasting Values on Filtered Data) Ex 0906 Filter Problem # 2 (Pasting Values on Filtered Data) 0907 Filter Problem # 3 (Performing Calculation on Filtered Data) Ex 0907 Filter Problem # 3 (Performing Calculation on Filtered Data) 0908 Advanced Filter (Applying Complex Criteria's) Ex 0908 Advanced Filter (Applying Complex Criteria's) Microsoft Excel: Advanced Level Excel Charts - Visual Presentation 1001 How to create a chart 1002 Format Axis 1003 Plot Values on Secondary Axis 1004 Life of Pie (Charts) 1005 How to Show Axis Title 1006 How to Show Data Label 1007 Show data with chart in Data Table 1008 Column Chart 1009 Bar Chart 1010 Line Chart 1 1011 Line Chart 2 1012 Area Chart 1013 Pie Chart 1014 Pie of Pie or Bar of Pie 1015 Line Chart with Log Scale 1016 Bubble Chart 1017 Selecting Chart Elements 1018 Use of Format Dialog box 1019 Modifying Chart & Plot Area 1020 Modifying Data Series 1021 How to handle Missing Data 1022 Modifying 3-D Charts 1023 Creating Combination of upto 5 Different Charts 1025 Creating Picture Charts Data Consolidation - Multiple WorkBooks WorkSheets Consolidate Data using Excel Inbuilt Function Ex Consolidate Data using Excel Inbuilt Function Data Validation 1201 Applying Data Validation Ex 1201 Applying Data Validation 1202 Dependent Dropdown List Ex1202 Dependent Dropdown List Using Data Validation with Vlookup & Match Other Data Validation Examples Protection of Worksheet Workbook 1301 Worksheet Level Protection Ex 1301 Worksheet Level Protection 1302 Cell Level Protection Ex 1302 Cell Level Protection 1303 Hiding Formulas from Formula Bar Ex 1303 Hiding Formulas from Formula Bar 1304 Protecting Workbook Structure Ex 1304 Protecting Workbook Structure 1305 Workbook Level Protection Ex 1305 Workbook Level Protection Pivot Table & Techniques 1401 Understanding pivot Table 1402 Using Pivot Table in Real Scenario Ex 1402 Using Pivot Table in Real Scenario 1403 Grouping in Pivot Table Ex 1403 Grouping in Pivot Table 1404 Using Slicers (A Visually attractive Filter) Ex 1404 Using Slicers (A Visually attractive Filter) What-If Analysis & Solver Add-In 1501 Goal Seek (A Reverse Approach) Ex 1501 Goal Seek (A Reverse Approach) 1502 One Way Data Table 1503 Two Way Data Table 1504 Scenario Manager 1505 Solver Add-In Automation in Excel - Macros 1601 Record your first Macro 1602 Record Another Macro 1603 Assigning macro to a Shape, Button, Picture etc 1604 Editing or Deleting a Macro 1605 Security Settings of a Macro Who should take this course? Absolute beginners to Microsoft Excel People who wish to use Microsoft Excel more confidently People who wish to refresh their existing skills in Microsoft Excel Entry Requirements There are no academic entry requirements for this Microsoft Excel training course basic to advanced course, and it is open to students of all academic backgrounds. However, you are required to have a laptop/desktop/tablet or smartphone and a good internet connection. Assessment Method This Microsoft Excel training course basic to advanced course assesses learners through multiple-choice questions (MCQs). Upon successful completion of the modules, learners must answer MCQs to complete the assessment procedure. Through the MCQs, it is measured how much a learner can grasp from each section. In the assessment pass mark is 60%. Certification Endorsed Certificate from Quality Licence Scheme After successfully passing the MCQ exam you will be eligible to order the Endorsed Certificate by Quality Licence Scheme. The Quality Licence Scheme is a brand of the Skills and Education Group, a leading national awarding organisation for providing high-quality vocational qualifications across a wide range of industries. It will give you a competitive advantage in your career, making you stand out from all other applicants and employees. There is a Quality Licence Scheme endorsement fee to obtain an endorsed certificate which is £65. Certificate of Achievement from Lead Academy After successfully passing the MCQ exam you will be eligible to order your certificate of achievement as proof of your new skill. The certificate of achievement is an official credential that confirms that you successfully finished a course with Lead Academy. Certificate can be obtained in PDF version at a cost of £12, and there is an additional fee to obtain a printed copy certificate which is £35. FAQs Is CPD a recognised qualification in the UK? CPD is globally recognised by employers, professional organisations and academic intuitions, thus a certificate from CPD Certification Service creates value towards your professional goal and achievement. CPD-certified certificates are accepted by thousands of professional bodies and government regulators here in the UK and around the world. Are QLS courses recognised? Although QLS courses are not subject to Ofqual regulation, they must adhere to an extremely high level that is set and regulated independently across the globe. A course that has been approved by the Quality Licence Scheme simply indicates that it has been examined and evaluated in terms of quality and fulfils the predetermined quality standards. When will I receive my certificate? For CPD accredited PDF certificate it will take 24 hours, however for the hardcopy CPD certificate takes 5-7 business days and for the Quality License Scheme certificate it will take 7-9 business days. Can I pay by invoice? Yes, you can pay via Invoice or Purchase Order, please contact us at info@lead-academy.org for invoice payment. Can I pay via instalment? Yes, you can pay via instalments at checkout. How to take online classes from home? Our platform provides easy and comfortable access for all learners; all you need is a stable internet connection and a device such as a laptop, desktop PC, tablet, or mobile phone. The learning site is accessible 24/7, allowing you to take the course at your own pace while relaxing in the privacy of your home or workplace. Does age matter in online learning? No, there is no age limit for online learning. Online learning is accessible to people of all ages and requires no age-specific criteria to pursue a course of interest. As opposed to degrees pursued at university, online courses are designed to break the barriers of age limitation that aim to limit the learner's ability to learn new things, diversify their skills, and expand their horizons. When I will get the login details for my course? After successfully purchasing the course, you will receive an email within 24 hours with the login details of your course. Kindly check your inbox, junk or spam folder, or you can contact our client success team via info@lead-academy.org