- Professional Development
- Medicine & Nursing
- Arts & Crafts
- Health & Wellbeing
- Personal Development
Overview This comprehensive course on Microsoft Excel: Excel Sheet Comparison with VBA 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: Excel Sheet Comparison with VBA 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: Excel Sheet Comparison with VBA. It is available to all students, of all academic backgrounds. Requirements Our Microsoft Excel: Excel Sheet Comparison with VBA 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 6 sections • 23 lectures • 02:10:00 total length •Introduction to Compare Data Workbook: 00:06:00 •Download Resources: 00:00:00 •Key requirements for Comparing any Datasets or Worksheets: 00:03:00 •Tool to Compare Datasets or Worksheets: 00:06:00 •Overview of Compare Data Workbook: 00:09:00 •Most Important things to remember before you use compare data workbook: 00:03:00 •IMPORTANT - First Column as KEY Column with UNIQUE Values: 00:09:00 •Deep Dive into Compare Data Workbook's Environment: 00:10:00 •How to Change Header Rows for your data: 00:06:00 •Basics of Using macro enabled Excel files and Code Modules: 00:04:00 •Changing the Main two sheets name, variance tags in VBA Code: 00:05:00 •Changing various elements across VBA Code modules: 00:05:00 •Clear Sheet data button VBA Code: 00:04:00 •Convert Row data into Structured, clean and formatted data with Power Query 1: 00:07:00 •Convert Row data into Structured, clean and formatted data with Power Query 2: 00:07:00 •Mutual Funds Portfolio - Finding Variances at two different times: 00:07:00 •Comprehensive Payroll Analysis - Creating Powerful Dashboard 1: 00:05:00 •Comprehensive Payroll Analysis - Creating Powerful Dashboard 2: 00:07:00 •Comprehensive Payroll Analysis - Creating Powerful Dashboard 3: 00:08:00 •Comprehensive Payroll Analysis - Creating Powerful Dashboard 4: 00:07:00 •Comprehensive Payroll Analysis - Creating Powerful Dashboard 5: 00:08:00 •IMPORTANT Facts and Limitation of Compare Data Workbook: 00:03:00 •Conclusion: 00:01:00
Cybercriminals are increasingly relying on user error to perpetrate attacks. Employees are, therefore, the first line of defense when it comes to protecting your organization. One crucial step in making sure that everyone in your organization is prepared to keep your networks secure is for them to know what attacks look like. The five most common workplace computer attacks are explored in this video, along with how to spot and prevent them. Learning Objectives Identify the various forms of cyber crime and learn how to spot potential risks, enabling you to protect your computer and personal information effectively.;Recognize and respond to the five most common types of attempted cyber security attacks.;Explore the concept of denial of service (DoS) attacks and the dangers of typosquatting, equipping you with the ability to detect potential threats and contribute to overall cybersecurity resilience.
Overview Embark on a transformative journey with the Office Skills and Administration Management Diploma, a comprehensive course designed to equip learners with essential skills for thriving in today's dynamic office environments. This course offers a deep dive into the core competencies required for excellence in administrative roles, addressing the increasing demand for skilled professionals in this sector. Participants will explore various topics, from the fundamentals of administrative management to advanced skills in business writing and digital proficiency. The curriculum is meticulously crafted to ensure a thorough understanding of both theoretical and applied aspects of office administration. This includes developing exceptional organisational skills, mastering effective communication, and honing expertise in essential software like Excel and PowerPoint. By completing this course, learners will be well-equipped to navigate and excel in the ever-evolving landscape of office administration. 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 Office Skills and Administration Management Diploma. It is available to all students, of all academic backgrounds. Requirements Our Office Skills and Administration Management Diploma 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 11 sections • 53 lectures • 19:18:00 total length •Personal Assistant: 01:23:00 •Admin Support: 01:54:00 •Administrative Management: 01:00:00 •Organisational Skills: 01:16:00 •Telephone Etiquette: 01:07:00 •Business Writing: 01:24:00 •Time Management: 01:09:00 •Body Language and Effective Communication: 01:23:00 •Meeting Management: 01:24:00 •Navigate the Excel User Interface: 00:28:00 •Use Excel Commands: 00:10:00 •Create and Save a Basic Workbook: 00:19:00 •Enter Cell Data: 00:12:00 •Use Excel Help: 00:05:00 •Create Worksheet Formulas: 00:15:00 •Insert Functions: 00:17:00 •Reuse Formulas and Functions: 00:17:00 •Insert, Delete, and Adjust Cells, Columns, and Rows: 00:10:00 •Search for and Replace Data: 00:09:00 •Use Proofing and Research Tools: 00:07:00 •Apply Text Formats: 00:16:00 •Apply Number Format: 00:07:00 •Align Cell Contents: 00:09:00 •Apply Styles and Themes: 00:12:00 •Apply Basic Conditional Formatting: 00:11:00 •Create and Use Templates: 00:08:00 •Preview and Print a Workbook: 00:10:00 •Set Up the Page Layout: 00:09:00 •Configure Headers and Footers: 00:07:00 •Manage Worksheets: 00:05:00 •Manage Workbook and Worksheet Views: 00:07:00 •Manage Workbook Properties: 00:06:00 •Customize the User Interface: 00:19:00 •Set PowerPoint 2016 Options: 00:07:00 •Modify Slide Masters and Slide Layouts: 00:16:00 •Add Headers and Footers: 00:05:00 •Modify the Notes Master and the Handout Master: 00:04:00 •Create SmartArt: 00:09:00 •Modify SmartArt: 00:05:00 •Write Math Equations: 00:07:00 •Add Audio to a Presentation: 00:09:00 •Add Video to a Presentation: 00:10:00 •Customize Animations and Transitions: 00:14:00 •Review a Presentation: 00:15:00 •Store and Share Presentations on the Web: 00:06:00 •Annotate a Presentation: 00:07:00 •Set Up a Slide Show: 00:08:00 •Create a Custom Slide Show: 00:03:00 •Add Hyperlinks and Action Buttons: 00:07:00 •Record a Presentation: 00:05:00 •Secure a Presentation: 00:11:00 •Broadcast a Slide Show: 00:07:00 •Create a Video or a CD: 00:08:00
Overview This comprehensive course on Banking and Finance Accounting Statements Financial Analysis will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Banking and Finance Accounting Statements Financial Analysis comes with accredited certification from CPD, 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 Banking and Finance Accounting Statements Financial Analysis. It is available to all students, of all academic backgrounds. Requirements Our Banking and Finance Accounting Statements Financial Analysis 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 Learning this new skill will help you to advance in your career. It will diversify your job options and help you develop new techniques to keep up with the fast-changing world. This skillset will help you to- Open doors of opportunities Increase your adaptability Keep you relevant Boost confidence And much more! Course Curriculum 11 sections • 54 lectures • 04:53:00 total length •Introduction to Financial Statements and Analysis: 00:05:00 •Why are Financial Statements Important: 00:07:00 •What do we mean by Financial Accounting?: 00:04:00 •Accounting Standards and why they are important: 00:06:00 •The Concepts and Principles Underlying Accounting: 00:06:00 •Single Entry vs Double Entry Book Keeping: 00:08:00 •Understanding The Accounting Equation: 00:06:00 •The Accounting Cycle: 00:05:00 •Financial Statements: 00:07:00 •Section Introduction - Understanding Financial Statements: 00:02:00 •Overview of Financial Statements: 00:03:00 •GAAP: Accruals and Cash Accounting: 00:06:00 •Income Statement or Profit and Loss Account: 00:08:00 •Introduction to the Balance Sheet: 00:11:00 •Introduction to the Cash Flow Statement: 00:06:00 •Cash Flow Metrics Explained: 00:09:00 •Case Study- Apple Financial Statements: 00:04:00 •What is Working Capital: 00:03:00 •What is the Working Capital Cycle?: 00:05:00 •Why is working Capital Management important: 00:05:00 •Working Capital Analysis: 00:05:00 •Working Capital Ratios: 00:07:00 •Working Capital Policies: 00:05:00 •Working Capital Summary: 00:03:00 •Section Introduction: Strategic Financial Analysis: 00:01:00 •What is Financial Analysis?: 00:11:00 •Measures of Profitability Financial Analysis: 00:04:00 •Balance Sheet Ratio Analysis: 00:12:00 •Cash Flow Statement Analysis: 00:05:00 •Valuation Ratios: 00:04:00 •Section Introduction: Financial Analysis - Case Study and Assignment: 00:01:00 •Case Study Assignments Apple Inc Financial Analysis: 00:06:00 •Apple Inc Financial Analysis - Solution: 00:03:00 •Discussion of Measurements of Growth Analysis: 00:05:00 •Discussion of Measures of Profitability Analysis: 00:07:00 •Discussion of Trading Performance Analysis: 00:03:00 •Discussion of Working Capital (Liquidity and Efficiency) Analysis: 00:12:00 •What do we mean by Corporate Finance?: 00:06:00 •Financial Ratios in Corporate Finance: 00:03:00 •Liquidity Ratios in Corporate Finance: 00:08:00 •Operational Risk Ratios in Corporate Finance: 00:08:00 •Profitability Ratios in Corporate Finance: 00:08:00 •Efficiency Ratios in Corporate Finance: 00:07:00 •Why is modelling so critical: 00:03:00 •Three Models You Will Need: 00:08:00 •Understanding The Integrated Financial Statements Model: 00:06:00 •The Integrated Financial Statements Model Example: 00:07:00 •Key Tips to Modelling the Integrated Financial Statements Model: 00:02:00 •Assignment - Banking and Finance Accounting Statements Financial Analysis: 00:00:00 •Understanding the Discounted Cash Flow Formula: 00:06:00 •Understanding the Merger Model: 00:08:00 •Course Summary and Wrap Up: 00:03:00 •Banking and Finance Accounting Statements Financial Analysis: 00:00:00 •Assignment - Banking and Finance Accounting Statements Financial Analysis: 00:00:00
Course Overview: The Office Skills and Administration Level 3 course covers everything from business writing and phone etiquette to body language interpretation and minute-taking methods. You will not only learn to improve your communication and organisational aptitudes, but you will also even be trained to get the most out of Microsoft's Excel and PowerPoint. Maximise your career potential and take your office abilities to a new standard. Key Features of the Course: CPD certificate upon completion 24/7 learning assistance for continuous support Engaging and interactive learning materials A comprehensive curriculum covering various aspects of Office Skills and Administration Level 3 Learn at your own pace, anywhere and anytime Who is This Course For? The Office Skills and Administration Level 3 course is for individuals looking to improve their office skills and administrative capabilities. It's suitable for office professionals, administrators, and those aspiring to enhance their office management expertise, whether you're new to the field or have some experience. What You Will Learn: This Office Skills and Administration Level 3 course covers: Efficient personal assistant skills. Effective admin support techniques. Administrative management strategies. Enhanced organisational skills. Professional telephone etiquette. Business writing proficiency. Time management, effective communication, meeting management, and basic Excel and PowerPoint skills. Why Enrol in This Course: Taking part in the Office Skills and Administration Level 3 course has several advantages. It is a highly popular programme that was recently upgraded to reflect modern office management trends and practices. By staying current with industry standards, you will increase your employability and open the door to great career opportunities in the administrative profession. Requirements: To enrol in the Quality Tools and Problem Solving Methods course, you typically need: Basic office management knowledge. Interest in advanced administrative skills. Computer and internet proficiency. Proficiency in English. Completion of the course provider's requirements. Career Path: Upon completing the Office Skills and Administration Level 3 course, you can pursue diverse and rewarding career opportunities. Here are five related professions, along with their average UK salaries: Office Manager (£30,000-£50,000 per year) Administrative Coordinator (£25,000-£40,000 per year) Executive Assistant (£30,000-£55,000 per year) Data Entry Specialist (£20,000-£30,000 per year) Customer Service Representative (£20,000-£35,000 per year) Certification: After successfully completing the Office Skills and Administration Level 3 course, you will be issued a CPD certificate that is acknowledged across many sectors. This recognised accreditation can help you improve your professional reputation and broaden your employment opportunities.Take part now for proficiency in office skills and administration, and join a global community of learners on this transforming educational adventure. Course Curriculum 12 sections • 54 lectures • 18:19:00 total length •Personal Assistant: 01:23:00 •Admin Support: 01:54:00 •Administrative Management: 00:00:00 •Organisational Skills: 01:16:00 •Telephone Etiquette: 01:07:00 •Business Writing: 01:24:00 •Time Management: 01:09:00 •Body Language and Effective Communication: 01:23:00 •Meeting Management: 01:24:00 •Navigate the Excel User Interface: 00:28:00 •Use Excel Commands: 00:10:00 •Create and Save a Basic Workbook: 00:19:00 •Enter Cell Data: 00:12:00 •Use Excel Help: 00:05:00 •Create Worksheet Formulas: 00:15:00 •Insert Functions: 00:17:00 •Reuse Formulas and Functions: 00:17:00 •Insert, Delete, and Adjust Cells, Columns, and Rows: 00:10:00 •Search for and Replace Data: 00:09:00 •Use Proofing and Research Tools: 00:07:00 •Apply Text Formats: 00:16:00 •Apply Number Format: 00:08:00 •Align Cell Contents: 00:09:00 •Apply Styles and Themes: 00:12:00 •Apply Basic Conditional Formatting: 00:11:00 •Create and Use Templates: 00:08:00 •Preview and Print a Workbook: 00:10:00 •Set Up the Page Layout: 00:09:00 •Configure Headers and Footers: 00:07:00 •Manage Worksheets: 00:05:00 •Manage Workbook and Worksheet Views: 00:07:00 •Manage Workbook Properties: 00:06:00 •Customize the User Interface: 00:19:00 •Set PowerPoint 2016 Options: 00:07:00 •Modify Slide Masters and Slide Layouts: 00:16:00 •Add Headers and Footers: 00:05:00 •Modify the Notes Master and the Handout Master: 00:04:00 •Create SmartArt: 00:09:00 •Modify SmartArt: 00:05:00 •Write Math Equations: 00:07:00 •Add Audio to a Presentation: 00:09:00 •Add Video to a Presentation: 00:10:00 •Customize Animations and Transitions: 00:14:00 •Review a Presentation: 00:15:00 •Store and Share Presentations on the Web: 00:06:00 •Annotate a Presentation: 00:07:00 •Set Up a Slide Show: 00:08:00 •Create a Custom Slide Show: 00:03:00 •Add Hyperlinks and Action Buttons: 00:07:00 •Record a Presentation: 00:05:00 •Secure a Presentation: 00:11:00 •Broadcast a Slide Show: 00:07:00 •Create a Video or a CD: 00:08:00 •Assignment - Office Skills and Administration Level 3: 00:00:00
Overview This comprehensive course on Addiction and Mental Health - Dual Diagnosis will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Addiction and Mental Health - Dual Diagnosis 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 Addiction and Mental Health - Dual Diagnosis. It is available to all students, of all academic backgrounds. Requirements Our Addiction and Mental Health - Dual Diagnosis 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 10 sections • 49 lectures • 12:17:00 total length •Promotional 5 minute video: 00:06:00 •SAMHI Dual Diagnosis Intro video and downloadable worksheet PowerPoint slides: 00:04:00 •Module 1 - Drugs and Effects: VIDEO PART 1 (content part 1 - 4): 00:16:00 •Module 1 - Drugs and Effects: VIDEO PART 2 (content part 5 - 6): 00:19:00 •Module 1 - Drugs and Effects: VIDEO PART 3 (content part 7 - 8): 00:20:00 •Module 1 - Drugs and Effects: VIDEO PART 4 (content part 9): 00:15:00 •Module 1 - Drugs and Effects: VIDEO PART 5 (content part 10): 00:10:00 •Module 1 - Drugs and Effects: VIDEO PART 6 (content 10 - 12): 00:18:00 •Module 1 - Drugs and Effects: VIDEO PART 7 (content part 13): 00:13:00 •Module 1 - Drugs and Effects: VIDEO PART 8 (content part 14): 00:20:00 •Module 1 - Drugs and Effects: VIDEO PART 9 (content part 14): 00:20:00 •Module 1 - Drugs and Effects: VIDEO PART 10 (content part 15 - 18): 00:19:00 •Module 2 Addictions & Mental Health: VIDEO PART 1 content part 1 - 2: 00:16:00 •Module 2 Addictions & Mental Health: VIDEO PART 2 content part 3 - 5: 00:18:00 •Module 2 Addictions & Mental Health: VIDEO PART 3 content part 6 - 7: 00:13:00 •Module 2 Addictions & Mental Health: VIDEO PART 4 content part: 00:17:00 •Module 2 Addictions & Mental Health: VIDEO PART 5 content part: 00:18:00 •Module 2 Addictions & Mental Health: VIDEO PART 6 content part: 00:20:00 •Module 2 Addictions & Mental Health: VIDEO PART 7 content part: 00:14:00 •Module 2 Addictions & Mental Health: VIDEO PART 8 content part: 00:12:00 •Module 2 Addictions & Mental Health: VIDEO PART 9 content part: 00:20:00 •Module 2 Addictions & Mental Health: VIDEO PART 10 content part: 00:13:00 •Module 3 Harm Minimisation & Optimal Health VIDEO PART 1 content part: 00:23:00 •Module 3 Harm Minimisation & Optimal Health VIDEO PART 2 content part: 00:17:00 •Module 3 Harm Minimisation & Optimal Health VIDEO PART 3 content part: 00:09:00 •Module 3 Harm Minimisation & Optimal Health VIDEO PART 4 content part: 00:18:00 •Module 3 Harm Minimisation & Optimal Health VIDEO PART 5 content part: 00:17:00 •Module 3 Harm Minimisation & Optimal Health VIDEO PART 1 content part 6: 00:11:00 •Module 3 Harm Minimisation & Optimal Health VIDEO PART 7 content part 7: 00:12:00 •Module 4 Brain Works - Neurophysiology: 00:17:00 •Module 4 Brain Works - Neurophysiology VIDEO PART 1 content part: 00:10:00 •Module 4 Brain Works - Neurophysiology VIDEO PART 2 content part: 00:17:00 •Module 4 Brain Works - Neurophysiology VIDEO PART 3 content part: 00:19:00 •Module 4 Brain Works - Neurophysiology VIDEO PART 4 content part: 00:16:00 •Module 4 Brain Works - Neurophysiology VIDEO PART 5 content part: 00:11:00 •Module 5 Trauma Model & Keys to Treatment VIDEO PART 1 content part 1 - 2a - 2f: 00:20:00 •Module 5 Trauma Model & Keys to Treatment VIDEO PART 2 content part 2g: 00:15:00 •Module 5 Trauma Model & Keys to Treatment VIDEO PART 3 content part 2h - 2i: 00:15:00 •Module 5 Trauma Model & Keys to Treatment VIDEO PART 4 content part 3: 00:13:00 •Module 5 Trauma Model & Keys to Treatment VIDEO PART 5 content part 4: 00:12:00 •Module 5 Trauma Model & Keys to Treatment VIDEO PART 6 content part 5 - 7: 00:18:00 •Module 5 Trauma Model & Keys to Treatment VIDEO PART 7 content part 8: 00:17:00 •Module 5 Trauma Model & Keys to Treatment VIDEO PART 7 content partVIDEO PART 8: 00:16:00 •Module 5 Trauma Model & Keys to Treatment VIDEO PART 9 content part 11: 00:16:00 •Module 5 Trauma Model & Keys to Treatment VIDEO PART 10 content part 12: 00:19:00 •Module 6 Brief & Early Intervention and Tripod of Support VIDEO 1 content part 1: 00:18:00 •Module 6 Brief & Early Intervention and Tripod of Support VIDEO 2 content part 2: 00:20:00 •Resources - Addiction & Mental Health (Dual Diagnosis) Integrative 12hrs: 00:00:00 •Assignment - Addiction and Mental Health - Dual Diagnosis: 00:00:00
Overview This comprehensive course on VMware vSphere Course will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This VMware vSphere Course comes with accredited certification from CPD, 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? After successfully completing the course you will be able to order your certificate, these are included in the price. Who is This course for? There is no experience or previous qualifications required for enrolment on this VMware vSphere Course. It is available to all students, of all academic backgrounds. Requirements Our VMware vSphere Course 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 Learning this new skill will help you to advance in your career. It will diversify your job options and help you develop new techniques to keep up with the fast-changing world. This skillset will help you to- Open doors of opportunities Increase your adaptability Keep you relevant Boost confidence And much more! Course Curriculum 11 sections • 109 lectures • 08:15:00 total length •Who's the Intended Audience?: 00:02:00 •Getting VMware Certified: 00:05:00 •What is Virtual Machine and Hypervisor?: 00:04:00 •vSphere Licensing Editions: 00:04:00 •What's the New in VMware vSphere7: 00:03:00 •vCenter and the Role: 00:03:00 •VMware Hands on Lab: 00:06:00 •What This Module Covers: 00:01:00 •Virtualization System Requirements: 00:04:00 •What do we need to start the course?: 00:05:00 •Download VMware workstation: 00:01:00 •Install VMware workstation: 00:02:00 •Download ESXi and vCenter server: 00:04:00 •Download ESXi and vCenter server: 00:04:00 •How to boot a VM from in VMware Workstation: 00:07:00 •Configure ESX Part 1: 00:09:00 •Configure ESX Part 2: 00:05:00 •ESXi by a Browser: 00:03:00 •ESXi Settings: 00:05:00 •Create a Datastore in ESXi: 00:04:00 •Upload a Windows ISO file to ESXi: 00:01:00 •Install a Virtual Machine in ESXi: 00:07:00 •Connect to an ESXi by VMware Workstation: 00:02:00 •What This Module Covers: 00:01:00 •Why Do We Need Active Directory: 00:01:00 •Prepare Active Directory Windows 2019: 00:06:00 •Create Virtual Machine Template for VMware Workstation: 00:06:00 •Install Active Directory Role: 00:05:00 •Creating DNS Record for vCenter: 00:02:00 •Deploy and install vCenter Appliance: 00:12:00 •Adding ESXis to VC: 00:03:00 •AUTO start VM: 00:02:00 •Verify AUTO Start VM: 00:03:00 •Take Snapshot from vSphere Lab: 00:03:00 •Enable SSH on ESX: 00:02:00 •ESXi DCUI Console: 00:01:00 •vCSA's Management Ul: 00:06:00 •Install ftp Server Using FileZilla Server: 00:05:00 •Backing up VCSA with ftp Server: 00:06:00 •Restore VCSA: 00:09:00 •Exploring vCSA with vSphere Client: 00:07:00 •Overview of VM Tools: 00:02:00 •Install VM Tools: 00:04:00 •Virtual Machine Files: 00:02:00 •Virtual Machine Power off: 00:04:00 •OVA and OVF Files: 00:03:00 •Demo OVF (Importing and Exporting): 00:04:00 •What This Module Covers: 00:01:00 •Virtual Switch (vSwitch) Overview: 00:03:00 •Standard vSwitches: 00:02:00 •Distributed vSwitches: 00:02:00 •Adding Network Adapter: 00:03:00 •vSwitch Creation and Configuration: 00:07:00 •Assign New Switch to the Virtual Machine: 00:02:00 •Verify New vSwitch Configuration: 00:06:00 •Adding VMkernel for Management and Vmotion Traffic: 00:03:00 •Create a vSphere Distributed Switch: 00:10:00 •What This Module Covers: 00:01:00 •Overview of Using ESXi with a SAN: 00:02:00 •Types of Storage: 00:03:00 •What Is Software-Defined Storage (SEIS): 00:04:00 •What is File Level Storage and Block Level Storage?: 00:03:00 •What is an iScsi Storage?: 00:08:00 •Adding vSwitch for iScsi Target: 00:05:00 •Adding Disk to Active Directory: 00:02:00 •Enable iScsi Target on Windows Server: 00:05:00 •Adding iSsci Disk as ESXi Datastore: 00:08:00 •Expand and Extend Datastore: 00:09:00 •Enable NFS on Windows Server: 00:05:00 •Creating an NFS Datastore: 00:03:00 •Migrate a VM to NFS Share: 00:04:00 •VM Add to Inventory: 00:02:00 •What This Module Covers: 00:01:00 •Update Sequence: 00:03:00 •vCenter 6.7 Upgrade to vCenter 7: 00:08:00 •Upgrade ESXi 6.7 ESXi 7: 00:04:00 •Upgrade ESXi 6.7 ESXi 7 using Bundle File: 00:07:00 •Introduction to vSphere 7 Lifecycle Management: 00:03:00 •Demo vSphere 7 Lifecycle Management: 00:17:00 •What This Module Covers: 00:01:00 •vCenter 7 MultiMorning: 00:02:00 •Demo Configure vCenter J MultiMorning: 00:04:00 •vCenter 7 PNID and FQDN Changes: 00:10:00 •vCenter Server Profiles: 00:04:00 •vSphere 7 Licensing: 00:03:00 •What the Module Covers: 00:01:00 •Manual Backup and restore from a VM: 00:06:00 •Backup a VM using Filezilla: 00:05:00 •Backup a VM using OVF Files: 00:06:00 •Clone and Snapshot: 00:08:00 •Installing Veeam Backup and Replication: 00:05:00 •Backup and Restore Using Veeam Backup Software: 00:09:00 •Upload VM from Workstation to ESXi: 00:04:00 •What This Module Covers: 00:01:00 •User Identity: 00:04:00 •Users and Poles: 00:11:00 •Define a New Role in vSphere: 00:04:00 •Account Policy and Message: 00:03:00 •Firewall and Service: 00:11:00 •Enable Lockdown Mode: 00:09:00 •What This Module Covers: 00:01:00 •Troubleshooting using ESXi Management Agents: 00:05:00 •Working with vCenter 7 Logs: 00:04:00 •ESXi Shell Power on and off Commands: 00:05:00 •What This Module Covers: 00:01:00 •Monitoring Virtual Machines in vSphere 7: 00:15:00 •Introduction to ESXTOP Command in ESXi: 00:03:00 •Using ESXTOP to Monitor an ESXi 6.0 Host: 00:07:00 •Monitor Vsphere with Veeam ONE: 00:07:00
Overview This comprehensive course on Data Visualization and Reporting with Power BI will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Data Visualization and Reporting with Power BI comes with accredited certification from CPD, 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 Data Visualization and Reporting with Power BI. It is available to all students, of all academic backgrounds. Requirements Our Data Visualization and Reporting with Power BI 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 Learning this new skill will help you to advance in your career. It will diversify your job options and help you develop new techniques to keep up with the fast-changing world. This skillset will help you to- Open doors of opportunities Increase your adaptability Keep you relevant Boost confidence And much more! Course Curriculum 15 sections • 140 lectures • 14:25:00 total length •Welcome!: 00:01:00 •What is Power BI?: 00:03:00 •Download & Installing Power BI Desktop: 00:04:00 •Getting to know the interface: 00:03:00 •Mini Project: Transform Data: 00:07:00 •Mini Project: Visualize Data: 00:05:00 •Mini Project: Creating a Data Model: 00:07:00 •Course Outline: What will you learn in this course?: 00:05:00 •How to learn best with this course?: 00:03:00 •Creating our initial project file: 00:04:00 •Working with the attached project files: 00:04:00 •Exploring the Query Editor: 00:06:00 •Connecting to our data source: 00:07:00 •Editing rows: 00:08:00 •Changing data types: 00:08:00 •Replacing values: 00:03:00 •Close & Apply: 00:03:00 •Connecting to a csv file: 00:03:00 •Connecting to a web page: 00:05:00 •Extracting characters: 00:06:00 •Splitting & merging columns: 00:09:00 •Creating conditional columns: 00:06:00 •Creating columns from examples: 00:09:00 •Merging Queries: 00:17:00 •Pivoting & Unpivoting: 00:06:00 •Appending Queries: 00:08:00 •Practice & Solution: Population table: 00:15:00 •The Fact-Dimension-Model: 00:09:00 •Practice: Load the dimension table: 00:04:00 •Organizing our queries in groups: 00:03:00 •Entering data manually: 00:05:00 •Creating an index column: 00:03:00 •Workflow & more transformations: 00:05:00 •Module summary: 00:05:00 •Exercise 1 - Instruction: 00:02:00 •Exercise 1 - Exercise Solution: 00:11:00 •Advanced Editor - Best practices: 00:09:00 •Performance: References vs. Duplicating: 00:10:00 •Performance: Enable / Disable Load & Report Refresh: 00:05:00 •Group by: 00:05:00 •Mathematical Operations: 00:05:00 •Run R Script: 00:15:00 •Using Parameters to dynamically transform data: 00:06:00 •M formula language: Basics: 00:07:00 •M formula language: Values, Lists & Tables: 00:14:00 •M formula language: Functions: 00:13:00 •M formula language: More functions & steps: 00:05:00 •Exercise 2 - Instructions: 00:01:00 •Exercise 2 - solution: 00:05:00 •Understanding the relationship: 00:05:00 •Create & edit relationships: 00:06:00 •One-to-many & one-to-one relationship: 00:06:00 •Many-to-many (m:n) relationship: 00:08:00 •Cross filter direction: 00:06:00 •Activate & deactivate relationships: 00:06:00 •Model summary: 00:03:00 •Exercise 3 Create Model: 00:02:00 •Exercise 3 Solution: 00:02:00 •Our first visual: 00:08:00 •The format tab: 00:12:00 •Understanding tables: 00:10:00 •Conditional formatting: 00:09:00 •The Pie Chart: 00:06:00 •All about the filter visual: 00:13:00 •The filter pane for developers: 00:09:00 •Cross filtering & edit interactions: 00:04:00 •Syncing slicers across pages: 00:07:00 •Creating drill downs: 00:08:00 •Creating drill throughs: 00:07:00 •The tree map visual: 00:07:00 •The decomposition tree: 00:05:00 •Understanding the matrix visual: 00:05:00 •Editing pages: 00:07:00 •Buttons & Actions: 00:09:00 •Bookmarks to customize your report: 00:10:00 •Analytics and Forecasts with line charts: 00:10:00 •Working with custom visuals: 00:07:00 •Get data using R Script & R Script visual: 00:08:00 •Asking questions - Q&A visual: 00:04:00 •Wrap up - data visualization: 00:08:00 •Python in Power BI - Plan of attack: 00:03:00 •Setting up Python for Power BI: 00:03:00 •Transforming data using Python: 00:11:00 •Creating visualizations using Python: 00:08:00 •Violin plots, pair plots & ridge plots using Python: 00:15:00 •Machine learning (BayesTextAnalyzer) using Python: 00:00:00 •Performance & Troubleshooting: 00:03:00 •Introduction: 00:01:00 •Show Empathy & Identify the Requirement: 00:03:00 •Finding the Most Suitable KPI's: 00:02:00 •Choose an Effective Visualization: 00:04:00 •Make Use of Natural Reading Pattern: 00:03:00 •Tell a Story Using Visual Cues: 00:05:00 •Avoid Chaos & Group Information: 00:02:00 •Warp Up - Storytelling with Data: 00:02:00 •Introduction: 00:03:00 •The project data: 00:04:00 •Measures vs. Calculated Columns: 00:15:00 •Automatically creating a date table in DAX: 00:08:00 •CALENDAR: 00:05:00 •Creating a complete date table with features: 00:04:00 •Creating key measure table: 00:03:00 •Aggregation functions: 00:06:00 •The different versions of COUNT: 00:14:00 •SUMX - Row based calculations: 00:09:00 •CALCULATE - The basics: 00:11:00 •Changing the context with FILTER: 00:07:00 •ALL: 00:08:00 •ALL SELECTED: 00:03:00 •ALL EXCEPT: 00:07:00 •How to go on now?: 00:03:00 •Power BI Pro vs Premium & Signing up: 00:04:00 •Exploring the interface: 00:04:00 •Discovering your workspace: 00:03:00 •Connecting Power BI Desktop & Cloud: 00:04:00 •Understanding datasets & reports: 00:03:00 •Working on reports: 00:04:00 •Updating reports from Power BI Desktop: 00:04:00 •Creating and working with workspaces: 00:07:00 •Installing & using a data gateway: 00:13:00 •Get Quick Insights: 00:03:00 •Creating dashboards: 00:04:00 •Sharing our results through Apps: 00:10:00 •Power BI Mobile App: 00:05:00 •Creating the layout for the Mobile App: 00:04:00 •Wrap up - Power BI Cloud: 00:07:00 •Introduction: 00:03:00 •Creating a Row-Level Security: 00:05:00 •Row-Level Security in the Cloud: 00:04:00 •Row-Level Security & Data Model: 00:05:00 •Dynamic Row-Level Security: 00:07:00 •Dynamic Many-to-Many RLS: 00:04:00 •Hierarchical Row-Level Security: 00:13:00 •JSON & REST API: 00:10:00 •Setting up a local MySQL database: 00:14:00 •Connecting to a MySQL database in Power BI: 00:05:00 •Connecting to a SQL database (PostgreSQL): 00:05:00 •Congratulations & next steps: 00:06:00 •The End: 00:01:00 •Resources - Data Visualization and Reporting with Power BI: 00:00:00
Overview This comprehensive course on Complete Microsoft Power BI 2021 will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Complete Microsoft Power BI 2021 comes with accredited certification from CPD, 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 Complete Microsoft Power BI 2021. It is available to all students, of all academic backgrounds. Requirements Our Complete Microsoft Power BI 2021 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 Learning this new skill will help you to advance in your career. It will diversify your job options and help you develop new techniques to keep up with the fast-changing world. This skillset will help you to- Open doors of opportunities Increase your adaptability Keep you relevant Boost confidence And much more! Course Curriculum 15 sections • 140 lectures • 14:25:00 total length •Welcome!: 00:01:00 •What is Power BI?: 00:03:00 •Download & Installing Power BI Desktop: 00:04:00 •Getting to know the interface: 00:03:00 •Mini Project: Transform Data: 00:07:00 •Mini Project: Visualize Data: 00:05:00 •Mini Project: Creating a Data Model: 00:07:00 •Course Outline: What will you learn in this course?: 00:05:00 •How to learn best with this course?: 00:03:00 •Creating our initial project file: 00:04:00 •Working with the attached project files: 00:04:00 •Exploring the Query Editor: 00:06:00 •Connecting to our data source: 00:07:00 •Editing rows: 00:08:00 •Changing data types: 00:08:00 •Replacing values: 00:03:00 •Close & Apply: 00:03:00 •Connecting to a csv file: 00:03:00 •Connecting to a web page: 00:05:00 •Extracting characters: 00:06:00 •Splitting & merging columns: 00:09:00 •Creating conditional columns: 00:06:00 •Creating columns from examples: 00:09:00 •Merging Queries: 00:17:00 •Pivoting & Unpivoting: 00:06:00 •Appending Queries: 00:08:00 •Practice & Solution: Population table: 00:15:00 •The Fact-Dimension-Model: 00:09:00 •Practice: Load the dimension table: 00:04:00 •Organizing our queries in groups: 00:03:00 •Entering data manually: 00:05:00 •Creating an index column: 00:03:00 •Workflow & more transformations: 00:05:00 •Module summary: 00:05:00 •Exercise 1 - Instruction: 00:02:00 •Exercise 1 - Exercise Solution: 00:11:00 •Advanced Editor - Best practices: 00:09:00 •Performance: References vs. Duplicating: 00:10:00 •Performance: Enable / Disable Load & Report Refresh: 00:05:00 •Group by: 00:05:00 •Mathematical Operations: 00:05:00 •Run R Script: 00:15:00 •Using Parameters to dynamically transform data: 00:06:00 •M formula language: Basics: 00:07:00 •M formula language: Values, Lists & Tables: 00:14:00 •M formula language: Functions: 00:13:00 •M formula language: More functions & steps: 00:05:00 •Exercise 2 - Instructions: 00:01:00 •Exercise 2 - solution: 00:05:00 •Understanding the relationship: 00:05:00 •Create & edit relationships: 00:06:00 •One-to-many & one-to-one relationship: 00:06:00 •Many-to-many (m:n) relationship: 00:08:00 •Cross filter direction: 00:06:00 •Activate & deactivate relationships: 00:06:00 •Model summary: 00:03:00 •Exercise 3 Create Model: 00:02:00 •Exercise 3 Solution: 00:02:00 •Our first visual: 00:08:00 •The format tab: 00:12:00 •Understanding tables: 00:10:00 •Conditional formatting: 00:09:00 •The Pie Chart: 00:06:00 •All about the filter visual: 00:13:00 •The filter pane for developers: 00:09:00 •Cross filtering & edit interactions: 00:04:00 •Syncing slicers across pages: 00:07:00 •Creating drill downs: 00:08:00 •Creating drill throughs: 00:07:00 •The tree map visual: 00:07:00 •The decomposition tree: 00:05:00 •Understanding the matrix visual: 00:05:00 •Editing pages: 00:07:00 •Buttons & Actions: 00:09:00 •Bookmarks to customize your report: 00:10:00 •Analytics and Forecasts with line charts: 00:10:00 •Working with custom visuals: 00:07:00 •Get data using R Script & R Script visual: 00:08:00 •Asking questions - Q&A visual: 00:04:00 •Wrap up - data visualization: 00:08:00 •Python in Power BI - Plan of attack: 00:03:00 •Setting up Python for Power BI: 00:03:00 •Transforming data using Python: 00:11:00 •Creating visualizations using Python: 00:08:00 •Violin plots, pair plots & ridge plots using Python: 00:15:00 •Machine learning (BayesTextAnalyzer) using Python: 00:00:00 •Performance & Troubleshooting: 00:03:00 •Introduction: 00:01:00 •Show Empathy & Identify the Requirement: 00:03:00 •Finding the Most Suitable KPI's: 00:02:00 •Choose an Effective Visualization: 00:04:00 •Make Use of Natural Reading Pattern: 00:03:00 •Tell a Story Using Visual Cues: 00:05:00 •Avoid Chaos & Group Information: 00:02:00 •Warp Up - Storytelling with Data: 00:02:00 •Introduction: 00:03:00 •The project data: 00:04:00 •Measures vs. Calculated Columns: 00:15:00 •Automatically creating a date table in DAX: 00:08:00 •CALENDAR: 00:05:00 •Creating a complete date table with features: 00:04:00 •Creating key measure table: 00:03:00 •Aggregation functions: 00:06:00 •The different versions of COUNT: 00:14:00 •SUMX - Row based calculations: 00:09:00 •CALCULATE - The basics: 00:11:00 •Changing the context with FILTER: 00:07:00 •ALL: 00:08:00 •ALL SELECTED: 00:03:00 •ALL EXCEPT: 00:07:00 •How to go on now?: 00:03:00 •Power BI Pro vs Premium & Signing up: 00:04:00 •Exploring the interface: 00:04:00 •Discovering your workspace: 00:03:00 •Connecting Power BI Desktop & Cloud: 00:04:00 •Understanding datasets & reports: 00:03:00 •Working on reports: 00:04:00 •Updating reports from Power BI Desktop: 00:04:00 •Creating and working with workspaces: 00:07:00 •Installing & using a data gateway: 00:13:00 •Get Quick Insights: 00:03:00 •Creating dashboards: 00:04:00 •Sharing our results through Apps: 00:10:00 •Power BI Mobile App: 00:05:00 •Creating the layout for the Mobile App: 00:04:00 •Wrap up - Power BI Cloud: 00:07:00 •Introduction: 00:03:00 •Creating a Row-Level Security: 00:05:00 •Row-Level Security in the Cloud: 00:04:00 •Row-Level Security & Data Model: 00:05:00 •Dynamic Row-Level Security: 00:07:00 •Dynamic Many-to-Many RLS: 00:04:00 •Hierarchical Row-Level Security: 00:13:00 •JSON & REST API: 00:10:00 •Setting up a local MySQL database: 00:14:00 •Connecting to a MySQL database in Power BI: 00:05:00 •Connecting to a SQL database (PostgreSQL): 00:05:00 •Congratulations & next steps: 00:06:00 •The End: 00:01:00 •Resources - Complete Microsoft Power BI 2021: 00:00:00
