12830 Manager courses in Reigate delivered Online

Unleash your leadership potential and become an effective manager with our Leadership & Management Course. Master essential skills like communication, delegation, motivation, and conflict resolution. Learn to lead diverse teams, foster collaboration, and drive results in an ever-changing landscape. This comprehensive program equips you to excel in your current role and prepare for future leadership opportunities.

Business Management: Business Management Course Online Do you aspire to be a part of the corporate management team? Do you want to start your own business? If yes, then this course is for you! This Business Management: Business Management Course is divided into several in-depth modules to provide you with the most convenient and rich learning experience possible. The qualification allows students to learn new skills and gain new knowledge through a variety of topics. You will learn strategies for building strong work teams, delegating work, managing business risks, change, workplace conflict, and customer service. Learning Objectives You will be able to do the following at the end of the Business Management: Business Management Course: Learn everything there is to know about business management and why it is so important. Familiarize yourself with all of the terms used in the field of business management. Promote organizational direction, learn and apply leadership and management theory. Develop a variety of important skills, such as communication, negotiation, and dispute resolution. Learn about project management, risk management, supply chain management, and human resource management. Determine the personal and technical abilities needed to achieve strategic goals. Create a solid personal development strategy. Learn how to run a company strategically. Examine the company laws and regulations in the United Kingdom. Create an action plan for your business. This Business Management: Business Management Course is designed to provide students with essential knowledge about business and management, as well as their role in modern organisations. By the end of this course, you will have a solid understanding of project management, planning and forecasting operations, performance management, negotiation techniques and human resource management. Why choose this Business Management: Business Management Course from the School of Health Care? Self-paced course, access available from anywhere in the world. High-quality study materials that are easy to understand. Business Management: Business Management Course developed by industry experts. After each module, there will be an MCQ quiz to assess your learning. Assessment results are generated automatically and instantly. 24/7 support is available via live chat, phone call, or email. Free PDF certificate after completing the Business Management: Business Management Course. Courses Including with this Business Management: Business Management Course Course 01: Level 7 Business Management Course 02: Level 5 Diploma in Business Analysis Course 03: Level 2 Diploma in Business Administration Course 04: Level 3 Business Administration Others benefit Included with Business Management: Business Management Course Free 4 PDF Certificate Access to Content - Lifetime Exam Fee - Totally Free Free Retake Exam [ Note: Free PDF certificate as soon as completing the Business Management: Business Management Course] Business Management: Business Management Course Online This Business Management: Business Management Course consists of 13 modules. Course Curriculum of Level 7 Business Management Module 01: Introduction Module 02: Financial Resource and Investment Management Module 03: Succession Planning Module 04: Risk Management Module 05: Supply Chain Management Module 06: Human Resource Management Module 07: Leadership and Management Module 08: Change Management Module 09: Conflict Management Module 10: Project Management Module 11: Communication Techniques for Business Management Module 12: Entrepreneurship and Small Business Management Module 13: UK Business Law Assessment Method of Business Management Course After completing Business Management: Business Management Course, you will get quizzes to assess your learning. You will do the later modules upon getting 60% marks on the quiz test. Apart from this, you do not need to sit for any other assessments. Certification of Business Management Course After completing the Business Management: Business Management Course, you can instantly download your certificate for FREE. The hard copy of the certification will also be delivered to your doorstep via post, which will cost £13.99. Who is this course for? Business Management: Business Management Course Online Anyone who aspires to the top of the corporate ladder in any business or workplace setting should take this Business Management: Business Management Course. Those who are self-employed or own small businesses should consider taking this Business Management: Business Management Course. Professionals in the field of business, program managers, facility managers, and program administrators should enrol. Students and recent graduates will also benefit from this. Requirements Business Management: Business Management Course Online To enrol in this Business Management: Business Management Course, students must fulfil the following requirements: Good Command over English language is mandatory to enrol in our Business Management: Business Management Course. Be energetic and self-motivated to complete our Business Management: Business Management Course. Basic computer Skill is required to complete our Business Management: Business Management Course. If you want to enrol in our Business Management: Business Management Course, you must be at least 15 years old. Career path Business Management: Business Management Course Online Enrolling on this Business Management: Business Management Course can lead you to the following career paths: Business Manager Assistant CEO Asset Management Management Analyst Business Management Support Analyst Business Management Assistants Sales & Business Management Trainee

Duration 5 Days 30 CPD hours This course is intended for Experienced system administrators and system integrators responsible for designing and implementing vRealize Automation Overview By the end of the course, you should be able to meet the following objectives: Describe the vRealize Automation architecture and use cases in cloud environments Manage vRealize Automation entities on VMware and third-party virtual and cloud infrastructures Configure and manage Cloud Accounts, Projects, Flavor Mappings, Image Mappings, Network Profiles, Storage Profiles, Volumes, Tags, and Services Create, modify, manage, and deploy Cloud Templates Connect to a Kubernetes Cluster and manage namespaces Customize services and virtual machines with cloudConfig Configure and manage the Service Broker Configure and manage ABX actions, custom properties, event broker subscriptions, and vRealize Orchestrator workflows Integrate with vRealize Orchestrator Install vRealize Automation with Lifecycle Configuration Manager Describe Cloud Automation Services (Cloud Assembly and Code Stream). Integrate Cloud Assembly with Terraform and SaltStack Use logs and CLI commands to monitor and troubleshoot vRealize Automation During this five-day course, you focus on installing, configuring, and managing VMware vRealize© Automation?. You learn about how vRealize Automation can be used to automate the delivery of virtual machines, applications, and personalized IT services across different data centers and hybrid cloud environments. The course covers how to manage both on-premise systems and cloud services. The course covers how vRealize Automation Service Broker can aggregate content in native formats from multiple clouds and platforms into a common catalog. This course also covers interfacing vRealize Automation with other systems using VMware vRealize© Orchestrator? and how to use vRealize Automation to manage Kubernetes systems and leverage other systems. The course also covers integrating with Terraform and using SaltStack as a configuration management tool. Course Introduction Introductions and course logistics Course objectives vRealize Automation Overview and Architecture Describe the purpose and functionality of vRealize Automation Describe the vRealize Automation architecture Describe the use of VMware Workspace ONE© AccessTM Describe the relationship between Kubernetes clusters, containers, and vRealize Automation services Describe CLI commands for vRealize Automation 8 cluster management Describe Cloud Assembly Describe Service Broker Describe Code Stream Installing vRealize Automation List the different vRealize Automation deployment types Describe the purpose of vRealize easy installer Describe the vRealize Automation installation process Authentication and Authorization Identity the steps involved in integrating Workspace One with Active Directory Describe features of Workspace One Describe the user roles available in vRealize Automation Identify the key tasks performed by each user role Define custom roles Configure branding and multitenancy Basic Initial Configuration Quickly create a basic configuration with a cloud account, cloud zone, project, flavor mapping, and image mapping. VMware Cloud Templates Configure and deploy a basic cloud template Create cloud templates that can run on any cloud Use cloudConfig to run commands, install software, and create users Use YAML for inputs, variables, and conditional deployments Tags and Storage Configuration Configure tags Describe different types of tags Manage tags Configure storage profiles Use tags and storage profiles Integrating NSX-T Data Center List the capabilities and use cases of NSX-T Data Center Describe the NSX-T Data Center architecture and components Integrate NSX-T Data Center with vRealize Automation List the supported network profiles in vRealize Automation Use NSX-T Data Center components to design a multitier application Cloud Template Identify the network and security options available in design canvas Create and manage on-demand networks and security groups Configure NSX-T day 2 actions Integrating with Public Clouds Configure and use VMware Cloud Foundation accounts Configure and use an AWS cloud account Configure and use an Azure cloud account Configure and use a Google Cloud Platform cloud account Using Service Broker for Catalog Management Release a VMware Cloud Template? Define content source and content sharing Define Service Broker policy enforcement Use custom forms for catalog items vRealize Automation Extensibility Describe Extensibility Use event topics Create a subscription Call a vRealize Orchestrator workflow Create ABX actions Using Code Stream Introduction to Code Stream The CI/CD process Integrate GitLab with Code Stream and Cloud Assembly Use Code Stream to install software Using Terraform Integrate Cloud Assembly with Terraform Use Terraform with a VMware Cloud Template Use Terraform with Code Stream Using Kubernetes Clusters Introduction to Kubernetes Connect to an existing Kubernetes Cluster Integrate VMware Tanzu? Grid Integrated Edition Create a Supervisor Namespace as a catalog item Using SaltStack for Configuration Management Introduction SaltStack with vRealize Automation Use SaltStack for software deployment Use SaltStack for configuration management Use SaltStack with event-driven orchestration vRealize Automation Troubleshooting and Integration Location of logs Using Activity Monitoring deployment history Basic troubleshooting CLI commands Collecting logs (VAMI console) Integration with VMware vRealize© Log Insight? Integration with vRealize Operations Migrating vRealize Automation 7.x to 8

Duration 3 Days 18 CPD hours This course is intended for This hands-on course is geared for experienced DBAs already working with Oracle. Overview This course combines expert lecture, real-world demonstrations and group discussions with machine-based practical labs and exercises. Working in a hands-on learning environment led by our expert facilitator, you'll learn how to: Implement backup and recovery settings and perform backup operations to the media of your choice. Move data between databases and files Use Oracle Database recovery processes to recover from media and other failures. Diagnose and repair data failures Use flashback technologies and data duplication to complement backup and recovery procedures Secure the availability of their database using backup and recovery strategies Geared for DBAs and other technical support staff, Oracle Database 19c Backup and Recovery is a hands-on course that allows you to develop appropriate backup and recovery procedures to address their business model and requirements. Throughout the course you?ll explore how to implement basic backup and recovery procedures, move data between databases and files, and employ basic monitoring procedures. You?ll also learn how to secure the availability of a database by using appropriate backup and recovery strategies, how to how to perform backup and recovery operations using RMAN, and how to use Flashback features to recover from human error. This course combines expert lecture, real-world demonstrations and group discussions with machine-based practical labs and exercises. Working in a hands-on learning environment led by our expert facilitator, you?ll learn how to:Implement backup and recovery settings and perform backup operations to the media of your choice.Move data between databases and filesUse Oracle Database recovery processes to recover from media and other failures.Diagnose and repair data failuresUse flashback technologies and data duplication to complement backup and recovery proceduresSecure the availability of their database using backup and recovery strategies Backup Methods User Managed Backups Oracle Managed Backups Types of Failures Types of Recoveries Recovery Configuration Configuring the Database for Archivelog Configuring the Database for No-Archivelog Configuring the Flash Recovery Area Configuring RMAN RMAN Default Settings Command Line Enterprise Manager RMAN Backups Full RMAN Backup Compressed Backups Uncompressed Backups Partial RMAN Backup Incremental Backups Change Tracking File Managing Backups Backup Reports Backup Maintenance Backup Catalog Backup Crosscheck RMAN Complete Recovery RMAN Complete Recovery Database Recovery Tablespace Recovery Datafile Recovery RMAN In-Complete Recovery Time Based Recovery Sequence Based Recovery SCN Based Recovery Non-Database File Recovery Spfile Recovery Controlfile Recovery Incremental Recovery Flash Recovery Area for a Fast Recovery User Managed Backup Configuring User Managed Backups Perform a User Managed Backup User Managed Recovery User Managed Complete Recovery User Managed Incomplete Recovery Configuring Flashback Flashback Query Flashback Drop Flashback Database Performing Flashback Recoveries Flashback Query Flashback Drop Flashback Transaction Query Flashback Versions Query Performing Flashback Database Determining the FRA Size FRA Retention Performing a Flashback Database RMAN Duplicate Command Setting up for a Duplicate Database Creating the Duplicate spfiles Performing the Duplicate Command. RMAN Recovery Catalog Configuring for the Recovery Catalog Creating the Recovery Catalog Backups with the Recovery Catalog Registering the Database with the Recovery Catalog Performing Backups with the Recovery Catalog Recoveries with the Recovery Catalog Identifying Type of Recoveries with the Recovery Catalog Performing Recoveries with the Recovery Catalog Recovery Catalog Maintenance Registering Additional Databases with the Recovery Catalog Cataloging Additional Backups with the Recovery Catalog Recovery Catalog Scripts DataPump Configuring Datapump DataPump Exports DataPump Imports Tuning RMAN RMAN Sessions RMAN Channels RMAN Job Progress Additional course details: Nexus Humans Oracle 19c Database Backup and Recovery (TTOR21619) 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 Oracle 19c Database Backup and Recovery (TTOR21619) 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.

Dog First Aid: Dog First Aid Training Introducing the special course Dog First Aid: Dog First Aid The Key to Keeping Your Pet Safe! Do you plan to start grooming dogs or do you have a pet dog? You might possess a certificate in dog first aid if you wish to start a dog care business in your community. If so, you should think about your knowledge of dog grooming and care before assuming responsibility for our Dog First Aid: Dog First Aid course. By focusing on legal concepts, Dog First Aid best practices, and the underlying expertise, the Dog First Aid: Dog First Aid course aimed to give students an in-depth understanding of Dog First Aid. Your production will rise if you complete our Dog First Aid course. Our dog first aid course will provide you the tools you need to become more organised and productive. Several sections in our Dog First Aid course cover the fundamentals of dog first aid. You may learn emergency management techniques from our Dog First Aid: Dog First Aid course. You'll also become an expert at creating a Dog First Aid checklist for each occurrence. Don't wait if you're interested in working for animals. Enrol right away for our Dog First Aid : Dog First Aid course. Main Course: Dog First Aid Free Courses are including with this Dog First Aid Course Along with The Dog First Aid: Dog First Aid Course, We Offer a free Level 2 Certificate For Animal Nursing Assistants Course Along with The Dog First Aid: Dog First Aid Course, We Offer a free Level 5 Animal Care Course Special Offers of this Dog First Aid: Dog First Aid Course This Dog First Aid Course includes a FREE PDF Certificate. Lifetime access to this Dog First Aid Course Instant access to this Dog First Aid: Dog First Aid Course Get FREE Tutor Support to this Dog First Aid: Dog First Aid Course Dog First Aid: Dog First Aid Training You will have a thorough understanding of a dog's first aid kit after finishing this Dog First Aid: Dog First Aid Course. To begin our Dog First Aid: Dog First Aid Course, you do not require any prior academic background. All you need to show your pet affection. Sign up for our Dog First Aid: Dog First Aid Course right away to enjoy learning. Who is this course for? Dog First Aid: Dog First Aid Training Everyone interested in this topic should take the Dog First Aid: Dog First Aid course, especially: Dog Sitter Dog Walker Guide Dog Trainer Dog Groomer Animal Therapist Canine Care Dog owners Pet care professionals Veterinary professionals Animal shelter volunteers Canine enthusiasts Requirements Dog First Aid: Dog First Aid Training To enrol in this Dog First Aid: Dog First Aid Course, students must fulfil the following requirements. To join in our Dog First Aid: Dog First Aid Course, you must have a strong command of the English language. To successfully complete our Dog First Aid: Dog First Aid Course, you must be vivacious and self driven. To complete our Dog First Aid: Dog First Aid Course, you must have a basic understanding of computers. A minimum age limit of 15 is required to enrol in this Dog First Aid: Dog First Aid Course. Career path Dog First Aid: Dog First Aid Training Following completion of the Dog First Aid: Dog First Aid course, advance your career. Examine careers such as: Dog First Aid Instructor: £25,000 - £35,000 per year Pet Care Specialist: £18,000 - £24,000 per year Veterinary Assistant: £16,000 - £20,000 per year Animal Shelter Manager: £22,000 - £30,000 per year Dog Behaviourist: £20,000 - £35,000+ per year

Estate Agent: Estate Agent Diploma Are you a prospective candidate who is enthusiastic about bargaining, promoting, and selling? Our extensive Estate Agent Diploma course includes all the material necessary for you to succeed in this cutthroat business. Our extensive Estate Agent Diploma programme is broken into 16 courses in total. Our Estate Agent Diploma will teach you about estate agents, their business plans, and ownership. This estate agent diploma also includes descriptions of all rights, laws, and tax procedures. From Estate Agent Diploma You will become an expert in land use control, leases, and real estate investment. You will learn how to spot a good deal from this estate agent diploma. You will be able to write lucrative contracts and sell real estate with expertise once you have completed the estate agent diploma. Enrol in the Estate Agent Diploma programme to launch a successful career and solidify your extensive knowledge. This Estate Agent Diploma is the most effective way for you to gain a thorough understanding of the subject. Learning Outcomes of Estate Agent Diploma Estate Agent Diploma will help you understand the role and responsibilities of an estate agent. Identify different types of estate agents and their functions by completing the Estate Agent Diploma. Estate Agent Diploma will Develop negotiation skills for successful property transactions. Comprehend regulatory requirements and industry standards. Explore marketing strategies for property promotion with Estate Agent Diploma. The Estate Agent Diploma will help you learn about the current trends and future of the estate agency sector. Main Course: Estate Agent Diploma Free Courses are including with this Estate Agent: Estate Agent Course Along with The Estate Agent Course, We Offer a free Property Development Course Along with The Estate Agent Course, We Offer a free Residential Letting Course Along with The Estate Agent Course, We Offer a free Property Management Course Special Offers of this Estate Agent: Estate Agent Course This Estate Agent Course includes a FREE PDF Certificate. Lifetime access to this Estate Agent Course Instant access to this Estate Agent Course Get FREE Tutor Support to this Estate Agent Course Estate Agent: Estate Agent Diploma With a focus on the management side of residential lettings, this course on residential letting, property management, property development, and real estate agents seeks to give students a thorough understanding and insight into the property industry. This residential leasing, property management, property development, and estate agent course will give you a great understanding of your role through real-world examples throughout. All of the obligations and guidelines that a competent residential letting agent must maintain and adhere to are covered in the Residential Letting, Property Management, Property Development, and Real Estate Agent Course. Who is this course for? Estate Agent: Estate Agent Diploma This Estate Agent Diploma is a good investment for those looking to advance their professional abilities or keep up with the newest trends. Requirements Estate Agent: Estate Agent Diploma To enrol in this Estate Agent: Estate Agent Diploma Course, students must fulfil the following requirements. To join in our Estate Agent: Estate Agent Diploma Course, you must have a strong command of the English language. To successfully complete our Estate Agent: Estate Agent Diploma Course, you must be vivacious and self driven. To complete our Estate Agent: Estate Agent Diploma Course, you must have a basic understanding of computers. A minimum age limit of 15 is required to enrol in this Estate Agent: Estate Agent Diploma Course. Career path Estate Agent: Estate Agent Diploma With this Estate Agent Diploma programme, you can pursue a variety of career opportunities, including: Property Developer Property Manager Real Estate Agent Real Estate Investor

This course covers all the basics to more advanced features and dives into all the little details about Hasura. Hasura provides a platform to create your GraphQL backends easier and faster than you ever thought possible without writing a single line of code!

Join our Microsoft Excel course and discover your hidden skills, setting you on a path to success in this area. Get ready to improve your skills and achieve your biggest goals. The Microsoft Excel course has everything you need to get a great start in this sector. Improving and moving forward is key to getting ahead personally. The Microsoft Excel course is designed to teach you the important stuff quickly and well, helping you to get off to a great start in the field. So, what are you looking for? Enrol now! You will Learn The Following Things: Learn strategies to boost your workplace efficiency. Hone your skills to help you advance your career. Acquire a comprehensive understanding of various topics and tips. Learn in-demand skills that are in high demand among UK employers This course covers the topic you must know to stand against the tough competition. The future is truly yours to seize with this Microsoft Excel. Enrol today and complete the course to achieve a certificate that can change your career forever. Details Perks of Learning with IOMH One-to-one support from a dedicated tutor throughout your course. Study online - whenever and wherever you want. Instant Digital/ PDF certificate 100% money back guarantee 12 months access Process of Evaluation After studying the course, an MCQ exam or assignment will test your skills and knowledge. You have to get a score of 60% to pass the test and get your certificate. Certificate of Achievement After completing the Microsoft Excel course, you will receive your CPD-accredited Digital/PDF Certificate for £5.99. To get the hardcopy certificate for £12.99, you must also pay the shipping charge of just £3.99 (UK) and £10.99 (International). Who Is This Course for? This Microsoft Excel is suitable for anyone aspiring to start a career in relevant field; even if you are new to this and have no prior knowledge, this course is going to be very easy for you to understand.  On the other hand, if you are already working in this sector, this course will be a great source of knowledge for you to improve your existing skills and take them to the next level.  This course has been developed with maximum flexibility and accessibility, making it ideal for people who don't have the time to devote to traditional education. Requirements There is no prerequisite to enrol in this course. You don't need any educational qualification or experience to enrol in the Microsoft Excel course. Do note: you must be at least 16 years old to enrol. Any internet-connected device, such as a computer, tablet, or smartphone, can access this online course. Career Path The certification and skills you get from this Microsoft Excel Course can help you advance your career and gain expertise in several fields, allowing you to apply for high-paying jobs in related sectors. Course Curriculum Unit 01: Excel from A-Z Course Introduction Excel from A-Z Course Intro 00:03:00 Excel Job Opportunities 00:03:00 Excel Job Types 00:04:00 Microsoft Excel Marketplace 00:04:00 What is Microsoft Excel? 00:04:00 Who is This Course For? 00:03:00 Unit 02: Getting Started With Excel Finding & Opening Excel 00:01:00 Excel's Start Screen 00:03:00 Explaining the Excel Interface 00:03:00 Excel Interface Continued 00:01:00 Excel Workbook vs. Excel Worksheet 00:02:00 Saving an Excel Document 00:04:00 Customizing the Quick Access Toolbar 00:02:00 Customizing the Excel Ribbon 00:03:00 Excel Shortcut Keys 00:02:00 Unit 03: Values, Referencing and Formulas Creating Excel Labels 00:03:00 Entering Numeric Values in Excel 00:03:00 Formatting Date Values in Excel 00:05:00 Building Basic Formulas in Excel 00:05:00 Order of Operations 00:06:00 Relative vs. Absolute Cell References 00:07:00 Unit 04: Intro to Excel Functions Excel Functions Explained 00:03:00 The SUM() Function 00:08:00 The MIN() & MAX() Function 00:04:00 The AVERAGE() Function 00:02:00 COUNT() Functions 00:05:00 Unit 05: Adjusting Excel Worksheets Moving & Copying Data 00:07:00 Insert & Delete Rows and Columns 00:05:00 Adjusting the Width and Height of Cells 00:05:00 Hiding and Unhiding Excel Rows and Columns 00:04:00 Renaming, Moving & Deleting Excel Worksheets 00:05:00 Adding Protection to Specific Cells 00:04:00 Protecting the Structure of a Workbook 00:02:00 Adding a Workbook Password to Open File 00:02:00 Unit 06: Visually Pleasing Cell Formatting Formatting Fonts and Cell Background Color 00:05:00 Adding Cell Borders 00:05:00 Formatting Data Appropriately 00:05:00 The Magic behind Excel's Format Painter 00:03:00 Creating Styles for Formatting Efficiency 00:06:00 Merging Cells for a Cleaner Look 00:03:00 The Power of Conditional Formatting 00:06:00 Unit 07: How to Insert Images and Shapes! Grab User's Attention using Illustrations 00:09:00 Customizing Icons 00:05:00 Create Compelling Graphics with SmartArt 00:06:00 Unit 08: Visualize Data with Charts The Commonly Used Column Chart 00:03:00 Changing the Chart Design.mp4 00:02:00 Formatting Elements of a Chart 00:06:00 Modifying the Data, Type & Location of a Chart 00:06:00 Unit 09: Excel's Printing Options Print Preview Options 00:04:00 Excel's Page Layout View 00:07:00 Printing a Specific Range of Cells 00:03:00 Converting Spreadsheets to PDF Files 00:02:00 Unit 10: Benefits of Using Excel Templates Why Create an Excel Template 00:01:00 How to Create an Excel Template 00:05:00 Unit 11: Working with Excel Datasets How to Prepare Data for Analysis 00:04:00 How to Sort Data in Excel 00:03:00 Multi-Level Sorting 00:03:00 Custom Sorting Datasets in Excel 00:02:00 Applying Filters to Datasets 00:05:00 Creating Subtotals within a Dataset 00:06:00 Converting Datasets into Tables 00:06:00 Little Slice of Pie Charts 00:05:00 Finding & Removing Duplicate Values 00:07:00 Unit 12: Excel Database Functions The SUMIF() Function 00:09:00 The DSUM() Function 00:08:00 The DSUM() Function Cont. 00:07:00 The SUBTOTAL() Function 00:06:00 Unit 13: Excel Data Validation What is Excel Data Validation? 00:02:00 Creating a Drop Down List with Data Validation 00:07:00 Different Types of Excel Data Validation 00:06:00 Adding Custom Alerts to Data Validation 00:07:00 Creating a Dynamic Drop Down List 00:03:00 Complex Validation: Dependent Drop Down List! 00:09:00 Unit 14: Excel PivotTables Creating an Excel Pivot Table 00:06:00 Modifying Excel PivotTables 00:06:00 Grouping & Filtering PivotTable Data 00:06:00 Drilling Down into PivotTable Data 00:02:00 Creating Pivot Charts & Utilizing Slicers 00:08:00 Unit 15: Excel's PowerPivot Add-In What is PowerPivot? 00:04:00 Activating the Excel PowerPivot Add-In 00:02:00 Creating Relationships between Data Tables.mp4 00:06:00 Using Data Models to Create PivotTables 00:05:00 How to Create PowerPivot KPI's 00:08:00 Unit 16: Excel's Conditional Functions Excels IF Function 00:05:00 IF() Function with AND() Criteria 00:05:00 IF() Function with OR() Criteria 00:05:00 Nesting Multiple IF() Functions 00:07:00 The COUNTIF() Function 00:04:00 Key Benefits of Named Ranges 00:04:00 Unit 17: Excel's Lookup Function VLOOKUP() Function 00:09:00 The Beauty of Excel's IFERROR() Function 00:04:00 HLOOKUP() Function 00:06:00 The INDEX Function 00:05:00 MATCH() Function 00:05:00 INDEX() and MATCH() Combined 00:05:00 Two-Way Lookup with INDEX() and MATCH() 00:04:00 Unit 18: Text Based Functions in Excel LEFT(), RIGHT() and MID() Function 00:07:00 Extracting Specific Text using LEN() & SEARCH() 00:13:00 Combining Text with CONCATENATE() 00:06:00 Quick Tips & Other Text Based Functions 00:06:00 Unit 19: Auditing Formulas and Views in Excel Tracing Precedents & Dependents in Formulas 00:04:00 Showing Formulas 00:02:00 Grouping Data 00:03:00 3D Referencing in Formulas 00:05:00 Utilizing the Watch Window in Excel 00:03:00 How to Freeze Panes in Excel 00:03:00 Unit 20: Excel's 'what If?' Tools Excel's Scenario Manager Tool 00:06:00 Goal Seek in Excel 00:06:00 Compare Results with Excel Data Tables 00:04:00 Solver Tool 00:11:00 Unit 21: Welcome to Excel VBA The Power Behind Excel VBA 00:03:00 A Look Inside the Visual Basic Editor (VBE) 00:04:00 Recording a Macro 00:09:00 Saving & Opening a Macro-Enabled Workbook 00:02:00 Unit 22: The VBA Language Modules and Procedures 00:07:00 Objects, Methods and Properties 00:06:00 Excel VBA Variables 00:05:00 Unit 23: Writing VBA Code Referencing a Range 00:13:00 InputBox & MsgBox 00:06:00 Using Variables in VBA Code 00:05:00 If Then Else Statement 00:10:00 Worksheet Functions inside VBA 00:08:00 Creating User Defined Functions 00:09:00 User Defined Functions within VBA Scripts 00:06:00 Unit 24: Important VBA Tools and Logic Find Last Row of Data 00:06:00 Find Last Column of Data 00:03:00 With Statement 00:05:00 Debugging & Error Handling 00:07:00 Debugging & Error Handling Cont. 00:07:00 Unit 25: Excel VBA Loop For Next Loop 00:09:00 Do Until Loop 00:06:00 For Each Loop 00:04:00 Unit 26: Triggering Macros Assigning Macros to Shapes 00:04:00 Form Controls vs ActiveX Controls 00:08:00 Worksheet Events 00:04:00 Workbook Events 00:03:00 Fun with VBA Events! 00:07:00 Unit 27: Excel User Forms Creating an Excel UserForm 00:03:00 Adding Controls to UserForms 00:10:00 How to Show an UserForm 00:03:00 Passing TextBox Values to Desired Cells 00:07:00 Passing Option Buttons to Desired Cells 00:07:00 UserForm ComboBoxes 00:08:00 Clearing Values from UserForm Controls 00:03:00 How to Close an UserForm 00:02:00 UserForms and Protected Sheets 00:05:00 Unit 28: Starting a Career in Excel Creating an Excel Resume 00:05:00 Getting Started with Freelancing 00:06:00 How to Become an Excel Freelancer 00:05:00 Top Freelance Websites 00:05:00 How to Get Your First Client 00:08:00 Personal Branding 00:07:00 Networking Do's and Don'ts 00:04:00 Importance of Having a Website 00:04:00 Resources Resources - Microsoft Excel 00:00:00

DG Awareness & Highway Code Course Details: Course Overview Time: 8:00 AM - 16:00 PM (Registration starts at 7:30 AM) Location: Online Price: £50 This comprehensive one-day course provides essential training in two critical areas: Dangerous Goods (DG) awareness and the Highway Code. DG Awareness: Understand the different hazard classes and types of dangerous goods. Learn about the legal requirements for transporting and storing DG. Discover the essential safety protocols for handling hazardous materials. Identify and assess potential risks associated with DG. Apply best practices for documentation and labeling. Highway Code: Course introduction, objectives, and expectations. Introduction to the Highway Code and its relevance. Types of road users and training for various groups. Respecting and understanding the risks to different road user categories. Confirmation of knowledge quizzes covering all aspects of the Highway Code and traffic regulations. Key Course Benefits: Meet Driver CPC requirements for periodic training Enhance your understanding of dangerous goods transportation Improve your knowledge of the Highway Code Learn how to respond to accidents, incidents, and breakdowns Boost your overall road safety awareness Don't miss this opportunity to enhance your knowledge and skills in DG Awareness & Highway Code. Register now for £50 and secure your spot!

The ability to identify and respond to changing trends is a hallmark of a successful business. Whether those trends are related to customers and sales, or to regulatory and industry standards, businesses are wise to keep track of the variables that can affect the bottom line. In today's business landscape, data comes from numerous sources and in diverse forms.