4629 Courses in Cardiff delivered Online

Course Objectives At the end of this course you will be able to: Work with advanced lookup and reference functions Create macros to automate common tasks Use advanced techniques to analyse data Create PivotTables and PivotCharts Work with data validation tools Import and export data ' Customer Feedback Best Training Ever! Just finished a bespoke 1-1 training course in Excel Advanced, Macros & VBA. Pedro is an excellent trainer, imparting his skills and knowledge in the best way - appropriately to audience skills, knowledge and ability. Pedro is always approachable, encouraging and supportive, giving delegates the optimum learning environment. I would not hesitate to recommend Pedro as a trainer, whatever your level of ability. Amanda Morris - Treasury & Systems Accountant at Reall - Real Equity for All The course was very interesting and engaging and will definitely be put to use. The trainer was very helpful and charismatic. Marving Lopez - AM Best Europe Pedro was excellent. Very knowledgeable, clear and great rapport with class. Darren Barkey - Direct Wines Great content and learnt a lot. Really enjoyable :) Kristie-Lee Ryan - Stirling Ackroyd 1 year email support service Take a closer look at the consistent excellent feedback visiting our site ms-officetraining co uk With more than 20 years experience, we deliver courses on all levels of the Desktop version of Microsoft Office and Office 365; ranging from Beginner, Intermediate, Advanced to the VBA level. Our trainers are Microsoft certified professionals with a proven track record with several years experience in delivering classrom, one to one, tailored and bespoke courses. Tailored In Company training: You can choose to run the course exactly as they are outlined by us or we can customise it so that it meets your specific needs. A tailored or bespoke course will follow the standard outline but may be adapted to your specific organisational needs. Please visit our site (ms-officetraining co uk) to get a feel of the excellent feedback our courses have had and look at other courses you might be interested in. Advanced Functions COUNT, COUNTA, COUNTIF, COUNTBLANK, SUMIF, SUBTOTAL IF, OR, AND, IFERROR VLOOKUP to lookup Exact Values and Approximate values MATCH, INDIRECT, ROW/COLUMN, INDEX, OFFSET Analysing Data PMT function to calculate a monthly payment of a loan What If Analysis using Goal Seek Use scenarios to consider many different variables Using Solver Add-in to optimize variables PivotTables Create a PivotTable to analyse worksheet data Add or remove fields in a PivotTable Change the data source for a PivotTable Working with external data sources Using different Statistical Functions Calculate a Running Total, % of Grant Total, Difference From… Using the Slicer and Timeline to filter the PivotTable Using Filters in a PivotTable Group by Date, Auto Group by ranges of values, Custom Group Create a PivotChart The GETPIVOTDATA function Formula auditing Precedents and dependents Error checking Watch a formula and its result by using the Watch Window Evaluate a nested formula one step at a time Data Validation Number Validation Data List Validation Message Prompts and Alerts Conditional Data Validation Data Validation Errors Consolidation Consolidate data by position Consolidate data by category Use a formula to consolidate data Outline (group) data in a worksheet Create an outline of rows Create an outline of columns Copy outlined data Hide or remove an outline Connect external data to your workbook Using the Power Query Editor to import data From Text and CSV, From Access, From Web, From another Workbook Using the Power Query Editor to; Transform your data by Selecting which fields to import, by Splitting Columns, Changing Data Type and more. Deleting Applied Steps Refreshing your data Working with Form Controls; Buttons, Option Buttons and Scroll Bars Introduction to Macros Change Macro Security settings How to Record a macro Some Macro Examples Delete a macro Edit the macro to view the VBA code Copy part of a macro to create another macro Assign a macro to a button Who is this course for? Who is this course for? This course is intended to end users who want to develop their skills so they can use advanced techniques to analyse extensive and complex datasets in Excel and to automate simple tasks with the use of Macros. Requirements Requirements Preferably, delegates should have attended the Excel Intermediate course. Career path Career path Excel know-how can instantly increase your job prospects as well as your salary. 80 percent of job openings require spreadsheet and word-processing software skills Certificates Certificates Certificate of completion Digital certificate - Included

***Don't Spend More; Spend Smart*** Life Just Got Better! Get Hard Copy + PDF Certificates + Transcript + Student ID Card + e-Learning App as a Gift - Enrol Now Tired of browsing and searching for the course you are looking for? Can't find the complete package that fulfils all your needs? Then don't worry as you have just found the solution. Take a minute and look through this 14-in-1 extensive bundle that has everything you need to succeed in Criminal Law and other relevant fields! After surveying thousands of learners just like you and considering their valuable feedback, this all-in-one Criminal Law bundle has been designed by industry experts. We prioritised what learners were looking for in a complete package and developed this in-demand Criminal Law course that will enhance your skills and prepare you for the competitive job market. Also, our Criminal Law experts are available for answering your queries and help you along your learning journey. Advanced audio-visual learning modules of these courses are broken down into little chunks so that you can learn at your own pace without being overwhelmed by too much material at once. Furthermore, to help you showcase your expertise in Criminal Law, we have prepared a special gift of 1 hardcopy certificate and 1 PDF certificate for the title course completely free of cost. These certificates will enhance your credibility and encourage possible employers to pick you over the rest. This Criminal Law Bundle Consists of the following Premium courses: Course 01: Criminal Law Course 02: English Law and Legal System Level 3 Course 03: Crime Analysis Online Course Course 04: Criminal Psychology Course Level 2 Course 05: Emotional Intelligence and Human Behaviour Course 06: Witness Investigation Course 07: Interrogations And Confessions Psychology Course 08: Human Rights Course 09: Diploma in Substance Misuse Course 10: Addiction and Mental Health - Dual Diagnosis Course 11: Domestic Violence and Abuse Awareness - Level 2 Course 12: Certificate in Anti Money Laundering (AML) Course 13: Data Protection and Data Security Level 2 Course 14: Decision Making and Critical Thinking Benefits you'll get choosing Apex Learning: Pay once and get lifetime access to 14 CPD courses Free e-Learning App for engaging reading materials & helpful assistance Certificates, student ID for the title course included in a one-time fee Free up your time - don't waste time and money travelling for classes Accessible, informative modules designed by expert instructors Learn at your ease - anytime, from anywhere Study the course from your computer, tablet or mobile device CPD accredited course - improve the chance of gaining professional skills How will I get my Certificate? After successfully completing the course you will be able to order your CPD Accredited Certificates (PDF + Hard Copy) as proof of your achievement. PDF Certificate: Free (For The Title Course) Hard Copy Certificate: Free (For The Title Course) Curriculum Course 01: Criminal Law Introduction to Criminal Law Elements of a Crime Incitement, Conspiracy and Attempt Accomplice Crime Prevention The Police Prosecution, Caution and Diversion Youth Justice The Trial Sentencing Process Homicide Offences against Person Sexual Offences Theft Blackmail, Robbery & Burglary White-Collar Crime Terrorism & Law Property Offences Cybercrime & Piracy Prisons Probation Service War Crimes Course 02: English Law and Legal System Level 3 The Legal Workplace and Professionals Legal Systems Contract & Business Human Rights Employment Property Mortgage Wills, Probate & Estate Criminal Law Other Common Laws & Legal Matters Course 03: Crime Analysis Online Course Introduction to Crime Analysis The Criminal Justice System in England and Wales Classification of Crime Crime Scene Crime Mapping Tactical Crime Analysis Strategic and Administrative Crime Analysis Criminal Behaviour and Psychology Financial and Environmental Criminology Criminal Justice Criminal Profiling: Science, Logic and Metacognition Phases of Profiling Criminal Intelligence Analysis Technology in Criminal Intelligence Analysis Research Method and Statistics in Crime Analysis Policing and Cyber Security Forecasting Future Occurrences and Prediction Course 04: Criminal Psychology Course Level 2 Understanding Criminal Psychology Influence of Mental Disorders Classification of Crime Forensic Science Victimology The Criminal Justice System in England and Wales Course 05: Emotional Intelligence and Human Behaviour Human Behaviour and Basic Psychological Process Evolutionary Perspective of Human Behaviour Human Intelligence Intelligence Test and Variations in Intelligence Learning and Conditioning Language and Communication Introduction to Emotion Emotion Influences Cognition Stress, Anger and Conflict Emotional Intelligence Self-Leadership Neuro-Linguistic Programming (NLP) Course 06: Witness Investigation Introduction Research Methods in Forensic Psychology Theories of Offending Personal Attributes of Offenders Forensic Psychology in Police Investigations Forensic Psychology in the Courtroom Forensic Psychology in Practice Course 07: Interrogations And Confessions Psychology The English Law on Confessions Interrogation in Britain The Royal Commission Research: Persons at Risk amid Police Custody Identifying 'Oppressive' Police Interviewing Tactics in Britain Theories of Reason of Confession by Suspects The Psychological Assessment of False Confession The Effects of Drugs and Alcohol Upon the Reliability of Testimony Interrogation Techniques and Miscarriages of Justice Course 08: Human Rights Basic Concept of Freedom and Human Rights Classification of Human Rights Women's and Children's Right Various Aspects of Freedom Various International Human Rights Organisations Course 09: Diploma in Substance Misuse Substance Misuse and Outreach Worker Substances: Drugs, Alcohol and Others Abuses of Substance Misuse Why People Use Drug and Alcohol? The Nature of Substance Misuse: Biological, Psychological and Social Perspectives Understand Possible Causes of Substance and Drug Abuse Implementing Substance Use Policy Effects of Drugs on the Body and Mind Enhancing Assessment and Treatment of Substance Misuse Health Consideration Specific Treatment Situations Substance Misusers: Children Risk Factors Pharmacological Agents Used in the Management of Substance Misuse Problems Planning and Implementing a Practice Improvement Subject Prevention and Awareness Substance Use Capabilities Across All Level of Social Work Career Consultancy Course 10: Addiction and Mental Health - Dual Diagnosis Promotional Video SAMHI Dual Diagnosis Intro video Module 01 - Drugs and Effects Module 02 - Addictions & Mental Health Module 03 - Harm Minimisation & Optimal Health Module 04 - Brain Works - Neurophysiology Module 05 - Trauma Model & Keys to Treatment Module 06 - Brief & Early Intervention and Tripod of Support Course 11: Domestic Violence and Abuse Awareness - Level 2 Introduction to Domestic Violence & Abuse The Components of Domestic Violence The Impact of Domestic Violence on Victims The Impact of Domestic Violence and Abuse on Children Assessing the Risks of Domestic Violence and Abuses on Children Supporting the Victim and Reporting Incidents Record Keeping Domestic Violence and Abuse Legislation in the UK Course 12: Certificate in Anti Money Laundering (AML) Introduction to Money Laundering Proceeds of Crime Act 2002 Development of Anti-Money Laundering Regulation Responsibility of the Money Laundering Reporting Office Risk-based Approach Customer Due Diligence Record Keeping Suspicious Conduct and Transactions Awareness and Training Course 13: Data Protection and Data Security Level 2 GDPR Basics GDPR Explained Lawful Basis for Preparation Rights and Breaches Responsibilities and Obligations Course 14: Decision Making and Critical Thinking Introduction to Critical Thinking Critical Thinking and the Judgment of Claims Benefits and Barriers of Critical Thinking Importance of Critical Thinking Recognising a Critical Thinker What Are the Critical Thinking Steps? Critical Thinking Strategies Problem-Solving Through Critical Thinking Decision Making with Critical Thinking CPD 145 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Anyone from any background can enrol in this Criminal Law bundle. Persons with similar professions can also refresh or strengthen their skills by enrolling in this course. Students can take this course to gather professional knowledge besides their study or for the future. Requirements Our Criminal Law is fully compatible with PC's, Mac's, laptops, tablets and Smartphone devices. This course has been designed to be fully compatible with tablets and smartphones so that 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 this various expertise will increase the value of your CV and open you up to multiple job sectors. Certificates Certificate of completion Digital certificate - Included You will get the PDF Certificate for the title course (Criminal Law) absolutely Free! Certificate of completion Hard copy certificate - Included You will get the Hard Copy certificate for the title course (Criminal Law) absolutely Free! Other Hard Copy certificates are available for £10 each. Please Note: The delivery charge inside the UK is £3.99, and the international students must pay a £9.99 shipping cost.

🚚 Smooth Operations, Secure Docking: Loading Dock Safety Online Training Course! 🛡️ Are you ready to fortify the safety of your loading dock operations? Enroll in our Loading Dock Safety Online Training Course, a comprehensive program meticulously designed to equip you with the knowledge and strategies needed to ensure secure and efficient loading dock procedures. Join us on a journey where productivity meets safety, creating a workplace culture that values the well-being of everyone involved in the loading process. 🌟 Module 1: Introduction to Loading Dock Safety - Equipment and Maintenance Embark on your safety journey with Module 1, providing a comprehensive introduction to loading dock safety. Understand the importance of proper equipment usage and maintenance, laying the foundation for a proactive approach to safety in the loading dock area. 🚧 Module 2: Safe Forklift Operations and Hazardous Materials Handling Master the art of safe forklift operations and hazardous materials handling in Module 2. Explore techniques for operating forklifts securely, and understand best practices for handling hazardous materials during loading and unloading operations. 🔥 Module 3: Fall Protection and Fire Safety Optimize your loading dock environment with Module 3, dedicated to fall protection and fire safety. Learn to implement fall protection measures for elevated work areas and ensure fire safety protocols are in place, creating a secure loading dock environment. 📦 Module 4: Material Handling and Traffic Management Enhance material handling practices with Module 4, focusing on efficient techniques and traffic management strategies. Learn to streamline material handling procedures, manage traffic flow effectively, and prevent congestion for a smoother loading dock operation. 🚦 Module 5: Hazard Communication and Security Awareness Maintain a secure loading dock with Module 5, where you'll focus on hazard communication and security awareness. Explore strategies for effective communication about potential hazards and enhance security awareness for a vigilant loading dock team. 🌟 Module 6: Incident Reporting and Safety Culture Cap off your training with Module 6, where you'll delve into incident reporting and building a safety culture. Learn the importance of prompt incident reporting, foster a culture that prioritizes safety, and ensure that every team member is committed to a secure loading dock environment. 🚀 Why Choose Our Loading Dock Safety Online Training Course? Expert-Led Training: Learn from seasoned professionals and safety experts specializing in loading dock safety. Interactive Learning: Engage in practical simulations, real-world scenarios, and interactive exercises to apply theoretical knowledge. Customizable Training: Tailor the course to suit the specific needs of your industry or organization, ensuring maximum relevance. Productivity Booster: Establish a loading dock culture that prioritizes safety, fostering an environment where every team member contributes to the efficiency of operations. Don't let safety be a missing link in your loading dock operations! Enroll now in the Loading Dock Safety Online Training Course and empower your team with the knowledge and skills needed to navigate loading and unloading operations securely. Your journey to a safer loading dock begins here! 🚛✨🎓 Course Curriculum Module 1 Introduction to Loading Dock Safety Equipment and Maintenance Introduction to Loading Dock Safety Equipment and Maintenance 00:00 Module 2 Safe Forklift Operations and Hazardous Materials Handling Safe Forklift Operations and Hazardous Materials Handling 00:00 Module 3 Fall Protection and Fire Safety Fall Protection and Fire Safety 00:00 Module 4 Material Handling and Traffic Management Material Handling and Traffic Management 00:00 Module 5 Hazard Communication and Security Awareness Hazard Communication and Security Awareness 00:00 Module 6 Incident Reporting and Safety Culture Incident Reporting and Safety Culture 00:00

Overview Ensure your business data remains confidential and that your customers can trust your security with GDPR training. This GDPR course provides all recommended precautions and knowledge you will need to prevent cyber-attacks and IT criminal acts. GDPR (General Data Protection Regulation) is part of UK law and has helped to keep customer data safe since 2018. All businesses must be aware of the six fundamental principles and critical safeguards that it presents and be capable of protecting their client's details. Completion of this training will enhance your security awareness and prompt appropriate upgrades and checks on your computer infrastructure. 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 GDPR. It is available to all students, of all academic backgrounds. Requirements Our GDPR 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 2 sections • 6 lectures • 02:02:00 total length •GDPR Basics: 00:22:00 •GDPR Explained: 00:17:00 •Lawful Basis for Preparation: 00:29:00 •Rights and Breaches: 00:25:00 •Responsibilities and Obligations: 00:29:00 •Assignment - General Data Protection Regulations UK: 00:00:00

Premium Bundle of all Time | Ofqual Regulation + ATHE Awards + QLS Endorsement | Assessment & Tutor Support Included

Unlock the secrets of the maritime world with our comprehensive programme designed to transform your understanding of ports and their pivotal role in global trade. Dive deep into the rich tapestry of the UK's port industry, exploring everything from the fundamentals of port operations to advanced strategies in port management. Our meticulously crafted curriculum takes you on a journey through the intricacies of port planning, financial services, and the latest technological advancements that drive efficiency and innovation in this dynamic sector. Key Features: CPD Certified Free Certificate Developed by Specialist Lifetime Access Discover the vital elements that contribute to the success of the world's leading ports, and gain insights into the safety protocols and security measures that safeguard maritime operations. With a focus on both historical contexts and contemporary developments, this programme offers a holistic view of the factors influencing port growth and evolution. Engage with the critical aspects of maritime policy and port pricing, and equip yourself with the knowledge to navigate the complexities of port administration and ownership. Enhance your proficiency with industry-specific terminology and cutting-edge software solutions, ensuring you stay ahead in the ever-evolving landscape of port management. Embark on this educational voyage and chart a course towards mastery in the port industry. Course Curriculum Module 01: UK Ports Overview Module 02: Fundamentals of Ports Module 03: Different Types of Port Module 04: Understanding Port and Terminal Management Module 05: Planning & Design Module 06: Financial & Professional Services Module 07: Port Management Module 08: Safety & Security Module 09: Port Equipment Module 10: Software & Solutions Module 11: Introduction to Port Development Module 12: Growth of the World's Leading Ports Module 13: Developments in Terminal Operation Module 14: Introduction to Ship Module 15: Effect of Port Time on Ship Speed Module 16: Types of Port Ownership and Administration Module 17: Organisations Concerning Ports Module 18: The Rise and Fall of Ports Module 19: Information Technology in Logistics Module 20: Safety Module 21: Maritime Policy Module 22: Port Policy Module 23: Port Pricing Module 24: Glossary & Shipping Terms Learning Outcomes: Grasp key concepts and fundamentals of UK ports and their operations. Understand various port types and their unique management requirements. Develop insights into port planning, design, and development strategies. Explore financial services and economic aspects related to port management. Learn about port equipment, software solutions, and terminal operations. Comprehend safety, security, and policy issues within port management. CPD 10 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Aspiring port managers and administrators Maritime industry professionals Logistics and supply chain specialists Infrastructure planners and designers Individuals interested in port operations and policies Career path Port Manager Terminal Operations Supervisor Maritime Policy Analyst Port Development Planner Logistics Coordinator Port Equipment Specialist Certificates Digital certificate Digital certificate - Included Certificate of Completion Digital certificate - Included Will be downloadable when all lectures have been completed.

QLS Endorsed + CPD QS Accredited - Dual Certification | Instant Access | 24/7 Tutor Support

Description Get a comprehensive overview of Automation and Log Analytics in Azure in the MS Azure - Automation and Log Anayltics course. Microsoft Azure is a cloud computing platform that offers more than 600 Azure services. The course especially focuses on two major Azure services: Automation and Log Analytics. Azure Automation gives you the ability to automate frequent, time-consuming, and error-prone cloud management tasks. On the other hand, Log Analytics helps you to collect, correlate, and visualize structured and unstructured data. Using Log Analytics, you can monitor cloud and on-premises environments to maintain availability and performance. You will also monitor and systems to maintain availability and performance. Throughout the course, you will learn how to use these two services for making your office work easy. You will explore the strategies of creating an automation account, Runbooks, and creating and viewing OMS workspace. Finally, you will be familiarized with the Azure security Centre. Assessment: This course does not involve any MCQ test. Students need to answer assignment questions to complete the course, the answers will be in the form of written work in pdf or word. Students can write the answers in their own time. Once the answers are submitted, the instructor will check and assess the work. Certification: After completing and passing the course successfully, you will be able to obtain an Accredited Certificate of Achievement. Certificates can be obtained either in hard copy at a cost of £39 or in PDF format at a cost of £24. Who is this Course for? MS Azure - Automation and Log Anayltics is certified by CPD Qualifications Standards and CiQ. This makes it perfect for anyone trying to learn potential professional skills. As there is no experience and qualification required for this course, it is available for all students from any academic background. Requirements Our MS Azure - Automation and Log Anayltics is fully compatible with any kind of device. Whether you are using Windows computer, Mac, smartphones or tablets, you will get the same experience while learning. Besides that, you will be able to access the course with any kind of internet connection from anywhere at any time without any kind of limitation. Career Path After completing this course you will be able to build up accurate knowledge and skills with proper confidence to enrich yourself and brighten up your career in the relevant job market. Introduction Introduction FREE 00:02:00 Azure Automation Azure Automation 00:03:00 Creating Azure Automation Accounts 00:03:00 Automation Assets 00:04:00 Creating Runbooks 00:07:00 Log Analytics Log Analytics Overview 00:03:00 Creating and Viewing OMS Workspaces 00:10:00 Azure Security Center Intro to Azure Security Center 00:04:00 Detection as a Service 00:02:00 ASC Investigations 00:06:00 Conclusion Course Recap 00:03:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Data encryption is a common method of ensuring confidentiality, by converting data from a readable format into an unreadable coded format. To gain expertise in this field, it is important to understand the many different terms associated with this process. In the Learn Basic of Encryption Data Terminology & Technology course, you will gain an in-depth understanding of what encryption means in practice and become fully familiar with the technical terms and expressions of encryption technologies. You will learn how to apply encryption properly, through the step-by-step guidance of an experienced instructor, taking your data security knowledge to the next level. This course is ideal for those looking to kickstart a career in the field of data security, as well as anyone interested in data privacy and technology. There are no specific entry requirements for this course, which can be studied on a part-time or full-time basis. This best selling Learn Basic of Encryption Data Terminology & Technology has been developed by industry professionals and has already been completed by hundreds of satisfied students. This in-depth Learn Basic of Encryption Data Terminology & Technology is suitable for anyone who wants to build their professional skill set and improve their expert knowledge. The Learn Basic of Encryption Data Terminology & Technology is CPD-accredited, so you can be confident you're completing a quality training course will boost your CV and enhance your career potential. The Learn Basic of Encryption Data Terminology & Technology is made up of several information-packed modules which break down each topic into bite-sized chunks to ensure you understand and retain everything you learn. After successfully completing the Learn Basic of Encryption Data Terminology & Technology, you will be awarded a certificate of completion as proof of your new skills. If you are looking to pursue a new career and want to build your professional skills to excel in your chosen field, the certificate of completion from the Learn Basic of Encryption Data Terminology & Technology will help you stand out from the crowd. You can also validate your certification on our website. We know that you are busy and that time is precious, so we have designed the Learn Basic of Encryption Data Terminology & Technology to be completed at your own pace, whether that's part-time or full-time. Get full course access upon registration and access the course materials from anywhere in the world, at any time, from any internet-enabled device.  Our experienced tutors are here to support you through the entire learning process and answer any queries you may have via email.

Duration 5 Days 30 CPD hours This course is intended for This course is intended for IT Professionals who are already experienced in general Windows Server, Windows client, Azure, and Microsoft 365 administration, and who want to learn more about using Windows PowerShell for administration. No prior experience with any version of PowerShell or any scripting language is assumed. This course is also suitable for IT Professionals already experienced in server administration, including Microsoft Exchange Server, Microsoft SharePoint Server, and Microsoft SQL Server. This course provides students with the fundamental knowledge and skills to use PowerShell for administering and automating administration of Windows servers. This course provides students the skills to identify and build the command they require to perform a specific task. In addition, students learn how to build scripts to accomplish advanced tasks such as automating repetitive tasks and generating reports. This course provides prerequisite skills supporting a broad range of Microsoft products, including Windows Server, Windows Client, Microsoft Azure, and Microsoft 365. In keeping with that goal, this course will not focus on any one of those products, although Windows Server, which is the common platform for all of those products, will serve as the example for the techniques this course teaches. Prerequisites Before attending this course, students must have: -Experience with Windows networking technologies and implementation. - Experience with Windows Server administration, maintenance, and troubleshooting. 1 - Review Windows PowerShell Learn about Windows PowerShell Get familiar with Windows PowerShell applications Identify factors to install and use Windows PowerShell Configure the Windows PowerShell console Configure the Windows PowerShell Integrated Scripting Environment (ISE) Use Visual Studio Code with PowerShell 2 - Understand the command syntax in Windows PowerShell Discover the structure of PowerShell cmdlets Discover the parameters for using PowerShell cmdlets Review the tab completion feature in PowerShell Display the About files content in PowerShell 3 - Find commands and Get-Help in Windows PowerShell Define modules in PowerShell Find cmdlets in PowerShell Use command aliases in PowerShell Use Show-Command and Get-Help in PowerShell Interpret the help file contents and update the local help content in PowerShell 4 - Manage Active Directory Domain Services using PowerShell cmdlets Manage user accounts in PowerShell Manage groups and group memberships in PowerShell Manage computer accounts in PowerShell Manage organizational units and Active Directory objects in PowerShell 5 - Manage network service settings for Windows devices using PowerShell cmdlets Manage IP addresses in PowerShell Manage IP routing in PowerShell Manage DNS clients in PowerShell Manage Windows Firewall settings in PowerShell 6 - Manage Windows Server settings using PowerShell cmdlets Automate management tasks using the Group Policy management cmdlets Manage server roles and services using PowerShell cmdlets Manage Hyper-V Virtual Machines using PowerShell cmdlets Manage Internet Information Services using PowerShell cmdlets 7 - Manage settings for a local Windows machine using PowerShell cmdlets Manage Windows 10 using PowerShell Manage permissions with PowerShell 8 - Understand the Windows PowerShell pipeline Review Windows PowerShell pipeline and its output Discover object members in PowerShell Control the formatting of pipeline output 9 - Select, sort, and measure objects using the pipeline Sort and group objects by property in the pipeline Measure objects in the pipeline Select a set of objects in the pipeline Select object properties in the pipeline Create and format calculated properties in the pipeline 10 - Filter objects out of the pipeline Learn about the comparison operators in PowerShell Review basic filter syntax in the pipeline Review advanced filter syntax in the pipeline Optimize the filter performance in the pipeline 11 - Enumerate objects in the pipeline Learn about enumerations in the pipeline Review basic syntax to enumerate objects in the pipeline Review advanced syntax to enumerate objects in the pipeline 12 - Send and pass data as output from the pipeline Write pipeline data to a file Convert pipeline objects to other forms of data representation in PowerShell Control additional output options in PowerShell 13 - Pass pipeline objects Pipeline parameter binding Identify ByValue parameters Pass data by using ByValue Pass data by using ByPropertyName Identify ByPropertyName parameters Use manual parameters to override the pipeline Use parenthetical commands Expand property values 14 - Connect with data stores using PowerShell providers Define Windows PowerShell providers Review the built-in providers in PowerShell Access provider help in PowerShell 15 - Use PowerShell drives in PowerShell Explain PowerShell drives in PowerShell Use PowerShell drive cmdlets in PowerShell Manage the file system in PowerShell Manage the registry in PowerShell Work with certificates in PowerShell Work with other PowerShell drives in PowerShell 16 - Review CIM and WMI Review architecture of CIM and WMI Review repositories in CIM and WMI Locate online class documentation by using CIM and WMI cmdlets 17 - Query configuration information by using CIM and WMI List local repository namespaces and classes by using CIM and WMI Query instances by using commands and WMI Query Language Connect to remote computers by using CIM and WMI cmdlets Query repository classes from remote computers by using CIMSession objects 18 - Query and manipulate repository objects by using CIM and WMI methods Discover methods of repository objects by using CIM and WMI Locate class methods and documentation by using CIM and WMI Invoke methods of repository objects by using CIM and WMI 19 - Manage variables in Windows PowerShell scripts Define variables in Windows PowerShell scripts Create variable names in Windows PowerShell scripts Assign values and types to variables in Windows PowerShell scripts Identify the methods and properties of variables in Windows PowerShell scripts Use string variables and methods in Windows PowerShell scripts Use date variables and methods in Windows PowerShell scripts 20 - Work with arrays and hash tables in Windows PowerShell scripts Define an array in Windows PowerShell scripts Work with array lists in Windows PowerShell scripts Define hash tables in Windows PowerShell Scripts Work with hash tables in Windows PowerShell scripts 21 - Create and run scripts by using Windows PowerShell Review Windows PowerShell scripts Modify scripts in the PowerShell Gallery Create scripts using Windows PowerShell Review the PowerShellGet module in Windows PowerShell Run scripts and set the execution policy in Windows PowerShell Review Windows PowerShell and AppLocker Sign the scripts digitally in Windows PowerShell 22 - Work with scripting constructs in Windows PowerShell Review and use the ForEach loop in Windows PowerShell scripts Review and use the If construct in Windows PowerShell scripts Review and use the Switch construct in Windows PowerShell scripts Review the For construct in Windows PowerShell scripts Review other loop constructs in Windows PowerShell scripts Review Break and Continue in Windows PowerShell scripts 23 - Import data in different formats for use in scripts by using Windows PowerShell cmdlets Use the Get-Content command in Windows PowerShell scripts Use the Import-Csv cmdlet in Windows PowerShell scripts Use the Import-Clixml cmdlet in Windows PowerShell scripts Use the ConvertFrom-Json cmdlet in Windows PowerShell scripts 24 - Use methods to accept user inputs in Windows PowerShell scripts Identify values that might change in Windows PowerShell scripts Use the Read-Host cmdlet in Windows PowerShell scripts Use the Get-Credential cmdlet in Windows PowerShell scripts Use the Out-GridView cmdlet in Windows PowerShell scripts Pass parameters to a Windows PowerShell script 25 - Troubleshoot scripts and handle errors in Windows PowerShell Interpret error messages generated for Windows PowerShell commands Add output to Windows PowerShell scripts Use breakpoints in Windows PowerShell scripts Interpret error actions for Windows PowerShell commands 26 - Use functions and modules in Windows PowerShell scripts Review functions in Windows PowerShell scripts Use variable scope in Windows PowerShell scripts Create modules in Windows PowerShell scripts Use the dot sourcing feature in Windows PowerShell 27 - Manage single and multiple computers by using Windows PowerShell remoting Review the remoting feature of Windows PowerShell Compare remoting with remote connectivity Review the remoting security feature of Windows PowerShell Enable remoting by using Windows PowerShell Use one-to-one remoting by using Windows PowerShell Use one-to-many remoting by using Windows PowerShell Compare remoting output with local output 28 - Use advanced Windows PowerShell remoting techniques Review common remoting techniques of Windows PowerShell Send parameters to remote computers in Windows PowerShell Set access protection to variables, aliases, and functions by using the scope modifier Enable multi-hop remoting in Windows PowerShell 29 - Manage persistent connections to remote computers by using Windows PowerShell sessions Review persistent connections in Windows PowerShell Create and manage persistent PSSessions by using Windows PowerShell Disconnect PSSessions by using Windows PowerShell Review the feature of implicit remoting in Windows PowerShell 30 - Review Azure PowerShell module Review Azure PowerShell Review the benefits of the Azure PowerShell module Install the Azure PowerShell module Migrate Azure PowerShell from AzureRM to Azure Review Microsoft Azure Active Directory module for Windows PowerShell and Azure Active Directory PowerShell for Graph modules 31 - Review the features and tools for Azure Cloud Shell Review the characteristics of Azure Cloud Shell Review the features and tools of Azure Cloud Shell Configure and experiment with Azure Cloud Shell 32 - Manage Azure resources with Windows PowerShell Create a new Azure virtual machine by using Windows PowerShell commands Manage Azure virtual machines by using Windows PowerShell commands Manage Azure related storage by using Azure PowerShell Manage Azure subscriptions by using Azure PowerShell 33 - Manage users, groups, and licenses in Microsoft Entra ID by using Windows PowerShell Review benefits to manage Microsoft 365 services by using Windows PowerShell Connect to the Microsoft 365 tenant by using Windows PowerShell Manage users in Microsoft 365 by using Windows PowerShell Manage groups in Microsoft 365 by using Windows PowerShell Manage roles in Microsoft 365 by using Windows PowerShell Manage licenses in Microsoft 365 by using Windows PowerShell 34 - Manage Exchange Online by using Windows PowerShell Connect to Exchange Online by using Windows PowerShell Manage mailboxes in Exchange Online by using Windows PowerShell Manage resources in Exchange Online by using Windows PowerShell Manage admin roles in Exchange Online by using Windows PowerShell 35 - Manage SharePoint Online by using Windows PowerShell Install and connect to SharePoint Online Management Shell by using Windows PowerShell Manage SharePoint Online users and groups by using Windows PowerShell Manage SharePoint sites by using Windows PowerShell Manage SharePoint Online external user sharing by using Windows PowerShell 36 - Manage Microsoft Teams by using Windows PowerShell Review Microsoft Teams PowerShell module Install the Microsoft Teams PowerShell module Manage teams with Microsoft Teams PowerShell module 37 - Create and manage background jobs using Windows PowerShell Define the types of background jobs in Windows PowerShell Start remote jobs and CIM/WMI jobs in Windows PowerShell Monitor jobs in Windows PowerShell Retrieve results for running jobs in Windows PowerShell 38 - Create and manage scheduled jobs using Windows PowerShell Create and run Windows PowerShell scripts as scheduled tasks Define scheduled jobs in Windows PowerShell Create job option and job trigger objects in Windows PowerShell Create and register a scheduled job in Windows PowerShell Retrieve the results from a scheduled job in Windows PowerShell