7801 Admin courses

Duration 5 Days 30 CPD hours This course is intended for This course is for all Oracle Professionals. Specifically Database Administrators, Web Server Administrators, System Administrators, CIOs and other IT Management Professionals. Overview Upon successful completion of this course, students will be able to perform many of the day-to-day administration tasks required of an Oracle database administrator. This course introduces many of the powerful capabilities of the Oracle database. In this course, students will learn about day-to-day administration tasks. It will also address administration sub-specialties. Introduction: Managing the Database Instance The Database Management Tools EM Database Express EM Cloud Control SQL Developer Database Administrator Introduction: Database Architecture Review Database Instance Configurations Memory Structures Process Structures Storage Architecture Introduction: Starting & Stopping Databse Services Start & Stop the Database Listener ABOUT DATABASE STARTUP/SHUTDOWN SYSOPER SYSDBA DATABASE STATE & STAGES STARTUP WITH EM CLOUD CONTROL STARTUP WITH SQL*PLUS SHUTDOWN WITH EM CLOUD CONTROL SHUTDOWN WITH SQL*PLUS USING MS WINDOWS SERVICES Introduction: Oracle Network Environment Oracle Net Services Architecture ORACLE NET CONFIGURATION ASSISTANT ORACLE NET MANAGER USING EM CLOUD CONTROL ADVANCED NETWORK COMPRESSION TROUBLESHOOTING NETWORK PROBLEMS Introduction: Diagnostics & Oracle Support About Database Diagnostics Fault Diagnosability Infrastructure DATABASE INSTANCE HEALTH SNAPSHOT THE SUPPORT WORKBENCH PROACTIVE DATABASE HEALTH CHECKS PACKAGE DIAGNOSTIC DATA WORKING WITH THE KNOWLEDGE BASE Storage: Tablespace Management Starter Tablespaces CREATE TABLESPACE WITH EM CC CREATE TABLESPACE WITH SQL MANAGE TABLESPACES WITH EM CC MANAGE TABLESPACES WITH EM DE MANAGE TABLESPACES WITH SQL DROP TABLESPACE ALTER TABLESPACE Storage: Advanced Tablespace Management Managing Temporary Tablespaces TEMP TABLESPACE GROUPS WITH EM TEMP TABLESPACE GROUPS WITH SQL DEFAULT PERMANENT TABLESPACES BIGFILE TABLESPACES MANAGING THE SYSAUX TABLESPACE Storage: Data Files & Temp Files Management Manage Data Files with EM ACCESS METADATA WITH SQL MANAGE DATA FILES WITH SQL MANAGE TEMP FILES ORACLE-MANAGED FILES (OMF) Storage: UNDO Data & UNDO Tablespaces About UNDO Space Management GUARANTEE UNDO RETENTION MONITOR UNDO SPACE WITH SQL USE THE EM UNDO ADVISOR Security & Schemas: Security Overview & Database Privileges Database Security Principles DATABASE SYSTEM PRIVILEGES DATABASE OBJECT PRIVILEGES SUPER ADMINISTRATOR ROLES PRIVILEGE ANALYSIS Security & Schemas: User Security Create & Manage User Accounts MANAGE USERS WITH EM MANAGE USERS WITH SQL CREATE USER ALTER USER DROP USER GRANT & REVOKE PRIVILEGES RESOURCE LIMITS VIA PROFILES ALTER PROFILE DROP PROFILE PASSWORD MANAGEMENT VIA PROFILES ROLE-BASED SECURITY MANAGEMENT ALTER USER...DEFAULT ROLE SET ROLE DELEGATING PRIVILEGE AUTHORIZATION WITH ADMIN OPTION & System Privileges WITH GRANT OPTION & Object Privileges PRINCIPLE OF LEAST PRIVILEGE CHECKLIST Security & Schemas: Database Auditing Auditing Database Activity Traditional Auditing Unified Auditing Create Audit Policy Security & Schemas: SQL Loader Loader Concepts Loader From the Command Line control File Options Load Methods Loader Express Mode Loader From EM Security & Schemas: Export & Import Manage Directory Objects The Data Pump Architecture Data Pump Export Data Pump Import Data Pump Dictionary Views Using the EM CC Interface Performance & Availability: Managing Performance & SQL Tuning Management Advisory Framework Performance Monitoring & AWR The SQL Tuning Advisor Monitoring Exceptions with Metrics Performance & Availability: Data Concurrency About System & User Locks Monitor & Manage User Locks Moitor Locks with Data Dictionary Manage Locks with EM Performance & Availability: Backup & Recovery Concepts Backup & Recovery Structures Managing REDO Data Configuring for Recoverability Instance Recovery Recoverability Checklist Additional course details: Nexus Humans Oracle 12c Administration II 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 12c Administration II 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.

Overview This comprehensive course on Business Strategy Consulting will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Business Strategy Consulting comes with accredited certification, which will enhance your CV and make you worthy in the job market. So enrol in this course today to fast track your career ladder. How will I get my certificate? You may have to take a quiz or a written test online during or after the course. After successfully completing the course, you will be eligible for the certificate. Who is This course for? There is no experience or previous qualifications required for enrolment on this Business Strategy Consulting. It is available to all students, of all academic backgrounds. Requirements Our Business Strategy Consulting is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible with tablets and smartphones so you can access your course on Wi-Fi, 3G or 4G. There is no time limit for completing this course, it can be studied in your own time at your own pace. Career Path Having these various qualifications will increase the value in your CV and open you up to multiple sectors such as Business & Management, Admin, Accountancy & Finance, Secretarial & PA, Teaching & Mentoring etc. Course Curriculum 17 sections • 88 lectures • 07:09:00 total length •Welcome to this Mini MBA Business Strategy Consulting Course: 00:03:00 •Mini MBA Business Strategy - Executive Summary - What you will learn: 00:10:00 •What is Business Strategy?: 00:05:00 •Business Vision and the Mission Statement: 00:04:00 •The Strategy Hierarchy within a Firm: 00:06:00 •Introduction to Business Strategy Design: 00:02:00 •Business Model Design with the Business Model Canvas: 00:13:00 •Business Model Canvas Template: 00:01:00 •Lafley & Martin's Five Step Strategy Model: 00:05:00 •Hambrick & Frederickson's Strategy Diamond: 00:06:00 •Understanding Life Cycles: 00:02:00 •The Industry Life Cycle: 00:07:00 •The Business Life Cycle: 00:06:00 •The Product Life Cycle: 00:05:00 •The Corporate Funding Life Cycle: 00:04:00 •External Analysis Using Broad Factors: 00:02:00 •PEST Analysis: 00:08:00 •PESTEL Analysis: 00:05:00 •PESTEL Analysis Template: 00:01:00 •CASE STUDY EXERCISE: PESTEL Analysis of Starbucks: 00:02:00 •CASE STUDY SOLUTION: PESTEL Analysis of Starbucks: 00:07:00 •CASE STUDY EXERCISE: PESTEL Analysis of the Global Aviation Industry: 00:07:00 •CASE STUDY SOLUTION: PESTEL Analysis of the Global Aviation Industry: 00:02:00 •Strategic Options from Internal and External Analysis: 00:16:00 •SWOT Analysis: 00:05:00 •Conducting A SWOT Analysis: 00:04:00 •SWOT Analysis Template: 00:02:00 •TOWS Matrix Analysis: 00:05:00 •TOWS Analysis Template: 00:14:00 •SOAR: 00:04:00 •SOAR Analysis Template: 00:01:00 •CASE STUDY EXERCISE: SWOT Analysis - Amazon: 00:02:00 •CASE STUDY SOLUTION: SWOT ANALYSIS - Amazon: 00:09:00 •Michael Porter and Business Strategy Analysis: 00:02:00 •Industry Analysis and Introducing Michael Porter: 00:10:00 •Competitive Forces Model - Porter's Five Forces: 00:12:00 •Full List of Porter's Five Forces Factors: 00:02:00 •Michael Porter's Five Forces Template: 00:01:00 •CASE STUDY EXERCISE PORTERS FIVE FORCES Global Aviation Industry: 00:02:00 •CASE STUDY SOLUTION: Porter's Five Forces - Global Airline Industry: 00:15:00 •Generic Strategies and Industry Forces: 00:10:00 •Michael Porter's Value Chain Analysis: 00:07:00 •Value Chain Analysis Template: 00:02:00 •Boston Consulting Group (BCG) Matrix: 00:07:00 •BCG Matrix and the Life Cycle: 00:03:00 •BCG Matrix Advantages and Disadvantages: 00:03:00 •Adapting the BCG Matrix: 00:05:00 •Boston Consulting Group (BCG) Matrix Template: 00:03:00 •CASE STUDY EXERCISE: BCG Matrix - Facebook: 00:02:00 •CASE STUDY SOLUTION: BCG Matrix - Facebook: 00:04:00 •CASE STUDY EXERCISE: BCG Matrix - Apple: 00:02:00 •CASE STUDY SOLUTION: BCG Matrix - Apple: 00:04:00 •CASE STUDY EXERCISE: BCG Matrix - Unilever: 00:02:00 •CASE STUDY SOLUTION: BCG Matrix - Unilever: 00:05:00 •Competitive Advantage - Deriving Strategy from Inside the Firm: 00:03:00 •Core Competency: 00:05:00 •VRIO - Resources to Competitive Advantage: 00:06:00 •CASE STUDY EXERCISE: Core Competency - Apple: 00:02:00 •CASE STUDY SOLUTION: Core Competency - Apple: 00:05:00 •Defining the Unique Selling Proposition: 00:05:00 •ADL Matrix - Understanding Your Competitive Position: 00:07:00 •ADL Matrix Template: 00:02:00 •Ansoff Product Market Matrix - How to Grow Your Business: 00:05:00 •Organic vs Inorganic Growth: 00:02:00 •Internal and External Growth Strategies Expanded: 00:11:00 •CASE STUDY EXERCISE: Amazon's Growth Strategy: 00:02:00 •CASE STUDY SOLUTION - Amazon's Growth Strategy: 00:06:00 •Blue Ocean Strategy: 00:05:00 •Blue Ocean Case Study - Apple: 00:05:00 •Comparing Red Ocean and Blue Ocean Strategies: 00:04:00 •How to Survive in an Over Fished Ocean: 00:05:00 •How to Create a Comparative Competitive Analysis on a Page: 00:04:00 •Making the Connection between Strategy and Finance: 00:04:00 •What is an Integrated Financial Model?: 00:06:00 •Key Drivers of an Integrated Financial Model: 00:08:00 •Model Structure: 00:03:00 •Detailed Model Schedules: 00:07:00 •Chart of Accounts: 00:02:00 •Financial Statement Inputs and Outputs: 00:03:00 •10 Steps to Building an Integrated Financial Model: 00:05:00 •Summary of the Strategic Analysis Process: 00:03:00 •Understanding the Strategic Planning Process: 00:06:00 •Four Step Strategic Management Process: 00:03:00 •Strategy Formulation in Six Steps: 00:07:00 •Mintzberg's Five Configurations: 00:05:00 •Course Summary and Wrap Up: 00:05:00 •Additional Materials: 00:00:00 •Assignment - Business Strategy Consulting: 00:00:00

The "Foundations of Immunisation and Vaccines for Non-Registered Practitioners" course is fully compliant with the National Minimum Standards and Core Curriculum for Immunisation Training and is designed to equip non-registered healthcare professionals with a solid understanding of immunisation concepts, vaccine administration, and the importance of vaccination in public health.

Duration 4 Days 24 CPD hours This course is intended for This course is for Azure Administrators. The Azure Administrator implements, manages, and monitors identity, governance, storage, compute, and virtual networks in a cloud environment. The Azure Administrator will provision, size, monitor, and adjust resources as appropriate. This course teaches IT Professionals how to manage their Azure subscriptions, secure identities, administer the infrastructure, configure virtual networking, connect Azure and on-premises sites, manage network traffic, implement storage solutions, create and scale virtual machines, implement web apps and containers, back up and share data, and monitor your solution. Prerequisites Successful Azure Administrators start this role with experience in virtualization, networking, identity, and storage. Understanding of on-premises virtualization technologies, including: VMs, virtual networking, and virtual hard disks. Understanding of network configurations, including TCP/IP, Domain Name System (DNS), virtual private networks (VPNs), firewalls, and encryption technologies. Understanding of Active Directory concepts, including users, groups, and role-based access control. Understanding of resilience and disaster recovery, including backup and restore operations. 1 - Configure Microsoft Entra ID Describe Microsoft Entra ID benefits and features Describe Microsoft Entra concepts Compare Active Directory Domain Services to Microsoft Entra ID Select Microsoft Entra editions Implement Microsoft Entra join Implement Microsoft Entra self-service password reset 2 - Configure user and group accounts Create user accounts Manage user accounts Create bulk user accounts Create group accounts Create administrative units 3 - Configure subscriptions Identify Azure regions Implement Azure subscriptions Obtain an Azure subscription Identify Azure subscription usage Implement Microsoft Cost Management Apply resource tagging Apply cost savings 4 - Configure Azure Policy Create management groups Implement Azure policies Create Azure policies Create policy definitions Create an initiative definition Scope the initiative definition Determine compliance 5 - Configure role-based access control Implement role-based access control Create a role definition Create a role assignment Compare Azure roles to Microsoft Entra roles Apply role-based access control Review fundamental Azure RBAC roles 6 - Configure Azure resources with tools Use the Azure portal Use Azure Cloud Shell Use Azure PowerShell Use Azure CLI 7 - Use Azure Resource Manager Review Azure Resource Manager benefits Review Azure resource terminology Create resource groups Create Azure Resource Manager locks Reorganize Azure resources Remove resources and resource groups Determine resource limits 8 - Configure resources with Azure Resource Manager templates Review Azure Resource Manager template advantages Explore the Azure Resource Manager template schema Explore the Azure Resource Manager template parameters Consider Bicep templates Review QuickStart templates 9 - Configure virtual networks Plan virtual networks Create subnets Create virtual networks Plan IP addressing Create public IP addressing Associate public IP addresses Allocate or assign private IP addresses 10 - Configure network security groups Implement network security groups Determine network security group rules Determine network security group effective rules Create network security group rules Implement application security groups 11 - Configure Azure DNS Identify domains and custom domains Verify custom domain names Create Azure DNS zones Delegate DNS domains Add DNS record sets Plan for Azure Private DNS zones Review Azure Private DNS zone scenarios 12 - Configure Azure Virtual Network peering Determine Azure Virtual Network peering uses Determine gateway transit and connectivity Create virtual network peering Extend peering with user-defined routes and service chaining 13 - Configure network routing and endpoints Review system routes Identify user-defined routes Determine service endpoint uses Determine service endpoint services Identify private link uses 14 - Configure Azure Load Balancer Determine Azure Load Balancer uses Implement a public load balancer Implement an internal load balancer Determine load balancer SKUs Create back-end pools Create health probes Create load balancer rules 15 - Configure Azure Application Gateway Implement Azure Application Gateway Determine Azure Application Gateway routing Configure Azure Application Gateway components 16 - Configure storage accounts Implement Azure Storage Explore Azure Storage services Determine storage account types Determine replication strategies Access storage Secure storage endpoints 17 - Configure Azure Blob Storage Implement Azure Blob Storage Create blob containers Assign blob access tiers Add blob lifecycle management rules Determine blob object replication Upload blobs Determine Blob Storage pricing 18 - Configure Azure Storage security Review Azure Storage security strategies Create shared access signatures Identify URI and SAS parameters Determine Azure Storage encryption Create customer-managed keys Apply Azure Storage security best practices 19 - Configure Azure Files and Azure File Sync Compare storage for file shares and blob data Manage Azure file shares Create file share snapshots Implement Azure File Sync Identify Azure File Sync components Deploy Azure File Sync 20 - Configure Azure Storage with tools Use Azure Storage Explorer Use the Azure Import/Export service Use the WAImportExport tool Use the AzCopy tool 21 - Configure virtual machines Review cloud services responsibilities Plan virtual machines Determine virtual machine sizing Determine virtual machine storage Create virtual machines in the Azure portal Connect to virtual machines 22 - Configure virtual machine availability Plan for maintenance and downtime Create availability sets Review update domains and fault domains Review availability zones Compare vertical and horizontal scaling Implement Azure Virtual Machine Scale Sets Create Virtual Machine Scale Sets Implement autoscale Configure autoscale 23 - Configure Azure App Service plans Implement Azure App Service plans Determine Azure App Service plan pricing Scale up and scale out Azure App Service Configure Azure App Service autoscale 24 - Configure Azure App Service Implement Azure App Service Create an app with App Service Explore continuous integration and deployment Create deployment slots Add deployment slots Secure your App Service app Create custom domain names Back up and restore your App Service app Use Azure Application Insights 25 - Configure Azure Container Instances Compare containers to virtual machines Review Azure Container Instances Implement container groups Review the Docker platform 26 - Configure file and folder backups Describe Azure Backup benefits Implement Backup Center for Azure Backup Configure Azure Recovery Services vault backup options Use the Microsoft Azure Recovery Services (MARS) agent Configure on-premises file and folder backups 27 - Configure virtual machine backups Explore options to protect virtual machine data Create virtual machine snapshots in Azure Backup Set up Azure Recovery Services vault backup options Back up your virtual machines Restore your virtual machines Implement System Center DPM and Azure Backup Server Compare the MARS agent and Azure Backup Server Implement soft delete for your virtual machines Implement Azure Site Recovery 28 - Configure Azure Monitor Describe Azure Monitor key capabilities Describe Azure Monitor components Define metrics and logs Identify monitoring data and tiers Describe activity log events Query the activity log 29 - Configure Azure alerts Describe Azure Monitor alerts Manage Azure Monitor alerts Create alert rules Create action groups 30 - Configure Log Analytics Determine Log Analytics uses Create a Log Analytics workspace Create Kusto (KQL) queries Structure Log Analytics queries 31 - Configure Network Watcher Describe Azure Network Watcher features Review IP flow verify diagnostics Review next hop diagnostics Visualize the network topology

This beginner's course exclusively delivers Python programming from basic to advanced. You will learn Python concepts in real-life programming examples by building real-world applications. Learn the syntax of Python language and understand the logic behind the programming process to create your Python programs successfully and master Python coding.

Enroll in the Complete Counselling Diploma to become a skilled counsellor. Covering child and adolescent counselling, depression, addiction therapy, and bereavement, this course prepares you for a professional career in mental health support. Earn your diploma and make a difference.

Office Skills: Office Skills Course Do you want to turn your aspirations and enthusiasm into a fulfilling profession? You will acquire the necessary information and abilities through our Office Skills Course. Learn how to manage a variety of important office administration jobs with the help of our Office Skills Course. Also, you learn how to handle complicated mail and shipping requirements as well as compose critical business letters as part of the Office Skills Course. With the assistance of this Office Skills Course, you can also arrange travel on other people's behalf and plan meetings and events. Time management is emphasised as a PA in this Office Skills Course. Communication skills are taught in the Office Skills Course as well. Enrol in our Office Skills Course right away to start improving your job possibilities with the help of modern skills and the strength of your own convictions! Main Course: Executive Secretary & PA Training Course Free Courses are including with this Event Management: Event Management Course Along with The Office Skills: Office Skills Course, We Offer a free Executive PA Course Along with The Office Skills: Office Skills Course, We Offer a free HR Management Course Along with Office Skills: Office Skills Course, We Offer a free Level 7 Business Management Course Special Offers of this Office Skills: Office Skills Course This Office Skills: Office Skills Course includes a FREE PDF Certificate. Lifetime access to this Office Skills: Office Skills Course Instant access to this Office Skills: Office Skills Course Get FREE Tutor Support to this Office Skills: Office Skills Course Office Skills: Office Skills Course All students who enroll in this course of the highest caliber will have access to round-the-clock, committed assistance. You will get support and answers to all of your questions during the Office Skills: Office Skills course. Thus, enroll in our Office Skills: Office Management and Administration course right away if you want to develop a successful career in this field! Who is this course for? Office Skills: Office Skills Course This Office Skills: Office Skills Course is designed for existing secretarial/administrative workers seeking advancement or newcomers seeking their first professional position. Requirements Office Skills: Office Skills Course To enrol in this Office Skills: Office Skills Course, students must fulfil the following requirements. To join in our Office Skills: Office Skills Course, you must have a strong command of the English language. To successfully complete our Office Skills: Office Skills Course, you must be vivacious and self driven. To complete our Office Skills: Office Skills Coursee, you must have a basic understanding of computers. A minimum age limit of 15 is required to enrol in this Office Skills: Office Skills Course. Career path Office Skills: Office Skills Course After completing this Office Skills: Office Skills Course, you may able to pursue a formal position in professional Office Skills: Office Skills Course services such as: Personal Executive Assistant Receptionist Office Assistant Support Secretary Office Manager Personal Concierge Executive Assistant

Master essential Microsoft Office applications, enhance communication, and develop problem-solving skills with the Microsoft Office Complete Training. Suitable for new entrants and professionals alike, gain practical knowledge, expert guidance, and a CPD certificate for career advancement.

Highlights of the Course Course Type: Online Learning Duration: 1 hour 37 minutes Tutor Support: Tutor support is included Customer Support: 24/7 customer support is available Quality Training: The course is designed by an industry expert Recognised Credential: Recognised and Valuable Certification Completion Certificate: Free Course Completion Certificate Included Instalment: 3 Installment Plan on checkout What you will learn from this course? Gain comprehensive knowledge about Microsoft Word Understand the core competencies and principles of Microsoft Word Explore the various areas of Microsoft Word Know how to apply the skills you acquired from this course in a real-life context Become a confident and expert office admin Pet Training Masterclass Program Master the skills you need to propel your career forward in pet training. This course will equip you with the essential knowledge and skillset that will make you a confident pet trainer and take your career to the next level. This comprehensive pet training course is designed to help you surpass your professional goals. The skills and knowledge that you will gain through studying this pet training course will help you get one step closer to your professional aspirations and develop your skills for a rewarding career. This comprehensive course will teach you the theory of effective pet training practice and equip you with the essential skills, confidence and competence to assist you in the pet training industry. You'll gain a solid understanding of the core competencies required to drive a successful career in pet training. This course is designed by industry experts, so you'll gain knowledge and skills based on the latest expertise and best practices. This extensive course is designed for pet trainer or for people who are aspiring to specialise in pet training. Enrol in this pet training course today and take the next step towards your personal and professional goals. Earn industry-recognised credentials to demonstrate your new skills and add extra value to your CV that will help you outshine other candidates. Who is this Course for? This comprehensive pet training course is ideal for anyone wishing to boost their career profile or advance their career in this field by gaining a thorough understanding of the subject. Anyone willing to gain extensive knowledge on this pet training can also take this course. Whether you are a complete beginner or an aspiring professional, this course will provide you with the necessary skills and professional competence, and open your doors to a wide number of professions within your chosen sector. Entry Requirements This pet training course has no academic prerequisites and is open to students from all academic disciplines. You will, however, need a laptop, desktop, tablet, or smartphone, as well as a reliable internet connection. Assessment This pet training 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 could grasp from each section. In the assessment pass mark is 60%. Advance Your Career This pet training course will provide you with a fresh opportunity to enter the relevant job market and choose your desired career path. Additionally, you will be able to advance your career, increase your level of competition in your chosen field, and highlight these skills on your resume. Recognised Accreditation This course is accredited by continuing professional development (CPD). CPD UK is globally recognised by employers, professional organisations, and academic institutions, thus a certificate from CPD Certification Service creates value towards your professional goal and achievement. Course Curriculum Supplementary Resources Supplementary Resources - A Complete Pet Training Masterclass: Accredited Certificate 00:00:00 Foundations of Pet Training Introduction To Pet Training And Animal Communication 00:01:00 Introduction to Animal Psychology 00:02:00 Introduction to Animal Behavior 00:03:00 Dog Training Breeds of Dog 00:02:00 Dog Behavior 00:01:00 Identifying Happy Dog 00:01:00 Identifying Anxious Dog 00:01:00 Identifying Fearful Dog 00:01:00 Identifying Frustrated Dog 00:01:00 Identifying Relieved Dog 00:01:00 Identifying Focused Dog 00:01:00 Identifying Angry Dog 00:01:00 Identifying Neutral Dog 00:01:00 Dog Psychology 00:10:00 Safe Games with Dogs 00:02:00 Cat Training Breeds of Cat 00:01:00 Cat Behavior 00:02:00 Identifying Neutral Cat 00:01:00 Identifying Focused Cat 00:01:00 Identifying Happy Cat 00:01:00 Identifying Anxious Cat 00:01:00 Identifying Fearful Cat 00:01:00 Identifying Frustrated Cat 00:01:00 Identifying Angry Cat 00:01:00 Identifying Relieved Cat 00:01:00 Cat Psychology 00:04:00 Safe Games with Cats 00:01:00 Rabbit Training Breeds of Rabbit 00:01:00 Rabbit Behavior 00:01:00 Identifying Happy Bunny 00:01:00 Identifying Anxious Bunny 00:01:00 Identifying Angry Bunny 00:01:00 Rabbit Psychology 00:06:00 Safe Games with Rabbits 00:01:00 Pet Hygiene, Wellness, and Grooming Pet Hygiene and Grooming 00:01:00 Taking Care of Pet Mental Health 00:01:00 Pet First Aid Checking Vital Signs of Pets 00:02:00 Introduction to Pet First Aid 00:01:00 Collar Accident 00:01:00 CPR for Pets 00:03:00 Fractures 00:01:00 Heatstroke 00:01:00 Temperature Changes 00:01:00 Choking 00:01:00 Bloat Emergency First Aid 00:05:00 Frostbite 00:01:00 Anaphylaxis and Allergic Reaction 00:01:00 Drowning 00:01:00 External Bleeding 00:01:00 Internal Bleeding 00:01:00 Burns 00:01:00 Pet Therapy Introduction to Pet Therapy 00:01:00 How to do Pet Therapy 00:02:00 Pet Therapy in Common Conditions 00:03:00 Obtain Your Certificate Order Your Certificate of Achievement 00:00:00 Get Your Insurance Now Get Your Insurance Now 00:00:00 Feedback Feedback 00:00:00

Overview This comprehensive course on Microsoft Excel: Automated Dashboard Using Advanced Formula, VBA, Power Query will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Microsoft Excel: Automated Dashboard Using Advanced Formula, VBA, Power Query comes with accredited certification which will enhance your CV and make you worthy in the job market. So enrol in this course today to fast track your career ladder. How will I get my certificate? You may have to take a quiz or a written test online during or after the course. After successfully completing the course, you will be eligible for the certificate. Who is this course for? There is no experience or previous qualifications required for enrolment on this Microsoft Excel: Automated Dashboard Using Advanced Formula, VBA, Power Query. It is available to all students, of all academic backgrounds. Requirements Our Microsoft Excel: Automated Dashboard Using Advanced Formula, VBA, Power Query is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible on tablets and smartphones so you can access your course on wifi, 3G or 4G. There is no time limit for completing this course, it can be studied in your own time at your own pace. Career path Having these various qualifications will increase the value in your CV and open you up to multiple sectors such as Business & Management, Admin, Accountancy & Finance, Secretarial & PA, Teaching & Mentoring etc. Course Curriculum 12 sections • 76 lectures • 06:08:00 total length •Course Outline and Introduction: 00:04:00 •Minimum Requirements for the Course: 00:01:00 •Prepayments Introduction: 00:01:00 •Month End Date Prepaid Expenses Amortization Calculation: 00:00:00 •Exact Prepaid Expenses Payment Date Calculation: 00:00:00 •Prepaid Expenses Accounting Definition: Prepayments: 00:03:00 •Prepaid Expense Example: How Accounting works for Prepayments: 00:03:00 •Advantages and Disadvantages of Prepaid Expenses: 00:03:00 •Introduction to PRO Excel Models and Formulas: 00:06:00 •Date Function: 00:05:00 •EOMONTH Function: 00:04:00 •DATEVALUE function: 00:03:00 •IF Function: 00:08:00 •IFS Function (Office 365 Only): 00:07:00 •VLOOKUP Function: 00:07:00 •MATCH Function: 00:05:00 •INDIRECT Function: 00:02:00 •NAMED Ranges: Name Manager: 00:03:00 •Advanced Version of VLOOKUP Function: 00:07:00 •Introduction to Model and Control Panel Tab (Important Sheet Tab): 00:08:00 •Formula Based Prepaid Expenses Model - Deep Dive (Part 1): 00:05:00 •Formula Based Prepaid Expenses Model - Deep Dive (Part 2): 00:06:00 •Formula Based Prepaid Expenses Model - Deep Dive (Part 3): 00:06:00 •IFS Function - Month End date Prepayment calculation: 00:04:00 •Prepaid Expenses - Closing Balance Summary Tab (Formula Based Summary): 00:09:00 •Protecting Formulas Cells and Fields in the Model: 00:04:00 •Exact Date Prepaid Amortisation calculation Intro: 00:03:00 •Formulas update and Model Changes for Exact Prepaid Exps Calculation: 00:03:00 •Formulas Update for Exact Date Prepaid Exps Amortisation (Part 1): 00:04:00 •Formulas Update for Exact Date Prepaid Exps Amortisation (Part 2): 00:03:00 •Formulas Update for Exact Date Prepaid Exps Amortisation (Part 3): 00:02:00 •Formulas Update for Exact Date Prepaid Exps Amortisation (Part 4): 00:07:00 •IFS Function - Exact Date Prepayments Amortisation: 00:04:00 •Data Validation Controls (Enhancing Data Input Controls with Protection): 00:10:00 •Bonus: Prepayment Model with Opening Balance Calculation (Part 1): 00:08:00 •Bonus: Prepayment Model with Opening Balance Calculation (Part 2): 00:09:00 •Additional Material: Resources: 00:00:00 •Power Query and Pivot Table Prepayment Summary Table Intro: 00:06:00 •What is Power Query and Some Awesome Resources for Power Query learning: 00:07:00 •Power Query and Pivot Table Summary - Deep Dive (Part 1): 00:05:00 •Power Query and Pivot Table Summary - Deep Dive (Part 2): 00:04:00 •Power Query and Pivot Table Summary - Deep Dive (Part 3): 00:05:00 •Power Query and Pivot Table Summary - Deep Dive (Part 4): 00:09:00 •Using Array Formulas to Add Formula Protection: 00:04:00 •Bonus: Allocate Prepaid Expenditure Cost Centre Wise - 1: 00:02:00 •Bonus: Allocate Prepaid Expenditure Cost Centre Wise - 2: 00:08:00 •Bonus: Prepayment Model with Opening Balance Calculation (PQ and PT Version): 00:13:00 •Changing Macros Security in Excel: 00:05:00 •Complete Walkthrough - Advanced VBA Prepaid Expenses Amortisation Model: 00:06:00 •Bonus : New Version - Excel VBA Model for Prepayment Expenditure: 00:08:00 •Dynamic Dashboard Overview: 00:07:00 •Importing Profit and Loss Statements Source Files and creating YTD P&L Sheets: 00:08:00 •Creating Dynamic Data Validation: 00:02:00 •Creating Named Ranges for Dynamic Table Arrays: 00:03:00 •Dynamic Date Column Headings for each Divisional PL Table: 00:02:00 •Dynamic Month and YTD Dashboard tables headings (PRO TIP): 00:03:00 •Dynamic VLOOKUP Formula - Preparing First section of the Dashboard: 00:04:00 •Creating Rolling Dashboard with Dynamic VLOOKUP Function: 00:08:00 •IMPORTANT : Error Checking for your reports/Dashboard (PRO TIP): 00:03:00 •Data Prep for Visualization: AREA Charts (Awesome trick using #NA Function): 00:05:00 •Visualization: AREA Charts for Month - Revenue, Gross Profit and Net Profit: 00:05:00 •Visualization DONUT Charts Revenue, Gross Profit and Net Profit (Part 1): 00:03:00 •Visualization DONUT Charts Revenue, Gross Profit and Net Profit (Part 2): 00:06:00 •Introduction - Formula-less Dashboard - Fully Dynamic and easily refreshed: 00:05:00 •Understanding the data files before building dashboard: 00:02:00 •Consolidating Reports with Power Query (Get & Transform) , How to install PQ: 00:08:00 •Dynamic File Path Trick in Power Query with Parameters (Amazing trick): 00:06:00 •Conditional Cumulative totals with SUMIFS Function: 00:04:00 •Bonus: Conditional Cumulative totals with Power Query Custom Formula (M Code): 00:06:00 •Dashboard Creation - Pivot Table showing Month and YTD KPIs division wise: 00:06:00 •Dashboard Creation Donuts Charts linked with Pivot Table (Replicate Charts fast): 00:08:00 •Dashboard Creation - Line Charts: 00:08:00 •Update Dashboard with Additional Divisional Data with Few Click (Magical): 00:03:00 •Thank you: 00:02:00 •Ultimate Prepaid Expenditure Model (Super Bonus): 00:02:00 •Resources - Microsoft Excel: Automated Dashboard Using Advanced Formula, VBA, Power Query: 00:00:00