2859 Courses

About this Training Course This separately bookable 3 full-day course is not designed to skill Oil & Gas engineers to be accountants, but to give the participants the confidence and ability to communicate with accountants and finance managers and to improve their own financial decision making. For technical professionals, a high level of single subject matter expertise is no longer sufficient for superior management performance. Oil & Gas technical professionals who wish to succeed in the resources industry are required to develop skills beyond their core functional knowledge. An understanding of financial information and management, and an awareness of the economic theory that drives value creation, are an integral part of the managers required suite of skills. This course can also be offered through Virtual Instructor Led Training (VILT) format. Training Objectives Workshop A: Finance for Non-Finance for Oil & Gas Professionals Attend this industry specific course and benefit from the following: Demystify financial jargon and fully interpret financial statements Understand Balance Sheets and Profit & Loss statements of Oil & Gas companies Discover the crucial distinction between cash flow and profit Understand how to make correct investment decisions using Net present Value and Internal Rate of Return Interpret oil and gas company financial reports using ratio analysis Learn the difference between cash costs and full costing of energy products Learn how to manage working capital for increased shareholder value Workshop B: Petroleum Fiscal Regimes and Applied Finance for Oil & Gas Industry Professionals Attend this advanced Training course to enhance your financial acumen from the following: Build and compare cash flow based models of both production sharing contract projects and royalty regime projects Gain an awareness of the different valuation methods for producing properties and undeveloped acreage Learn the industry specific accounting issues that apply when interpreting oil and gas company financial statements Understand how the physical characteristics of energy assets (e.g. reserves, reservoir quality) are translated into project valuations Learn how the investment analysts value oil and gas stocks and make buy/sell recommendations Target Audience This course is specifically designed for those with a non-finance background training from the Oil & Gas sector and requires only basic mathematical ability as a pre-requisite. It is presented in a manner that reduces the jargon to basic principles and applies them to numerous real-life examples. This course has been researched and developed for Managers, Superintendents, Supervisors, Engineers, Planners, Lawyers, Marketers, Team Leaders and Project Coordinators in the technical and non-technical departments in the Oil and Gas industry. Course Level Basic or Foundation Trainer Your expert course leader has presented over 300 courses and seminars in financial management. He began his career as a graduate in the Corporate Treasury of WMC Ltd having completed a degree in Applied Mathematics and Geology at Monash University. After five years with WMC, he pursued an MBA in finance and accounting at Cornell University in New York. He later gained a PhD in energy policy from the University of Melbourne. He worked for WMC Ltd in Perth as a Senior Financial Analyst in the Minerals Division and subsequently as an Energy Analyst in the Petroleum Division. In April 1997, he established an independent consultancy business providing advice to companies such as Woodside, Shell and Japan Australia LNG (MIMI). He spent many years as a consultant and commercial manager in the North West Shelf Gas project in Western Australia. Since 2006, he has been an Adjunct Fellow at the Macquarie University Applied Finance Centre where he teaches courses in valuation, financial statement modelling, and resources industry investment analysis. His background in geology and mathematics allows him to empathise with those who seek an understanding of finance but are approaching the learning experience with a technical mind. He receives consistently high ratings for his breadth of knowledge of the subject matter. He presents in a lively interactive style using real life examples and cases. POST TRAINING COACHING SUPPORT (OPTIONAL) To further optimise your learning experience from our courses, we also offer individualized 'One to One' coaching support for 2 hours post training. We can help improve your competence in your chosen area of interest, based on your learning needs and available hours. This is a great opportunity to improve your capability and confidence in a particular area of expertise. It will be delivered over a secure video conference call by one of our senior trainers. They will work with you to create a tailor-made coaching program that will help you achieve your goals faster. Request for further information post training support and fees applicable Accreditions And Affliations

Course Information In today's evolving landscape, pharmacovigilance (PV) systems face ongoing challenges due to global, national, and company-specific events. This course focuses on developing personnel equipped to navigate these complexities and improve the safe use of medicinal products. We emphasise continuous global thinking, communication, and strategic planning, ensuring adaptability across various levels. The course explores maintaining PV system functionality while adhering to regulatory requirements. Participants will apply European regulatory standards to enhance and sustain PV system effectiveness, contributing to improvement initiatives and ensuring operational integrity. The course covers PV system intricacies, regulatory compliance, and a 'systems approach' for auditors, quality assurance personnel, and PV practitioners. Through presentations and workshops, attendees gain insights into implementing and maintaining an effective PV system. Who should attend? Auditors Pharmacovigilance Quality System Managers Pharmacovigilance scientists The QPPV. Course benefits Throughout the course delegates will explore application of the legal requirements for the PV system and quality system and how to assure these systems. They will demonstrate their ability to contribute to: A systematic investigation of the pharmacovigilance system and its quality system Examination of how the pharmacovigilance system and quality system interact to achieve compliance. The risk-based approach to auditing the PV system and quality system The maintenance of 'inspection readiness' Explore how to investigate the complex PV system Discussions about how to monitor and maintain the PV system and assure compliance. Course Objectives Clarify what has to be done: Explore application of the legal requirements. Explore how to do what has to be done: Adopt a systemic approach to systematically investigate or implement and maintain the PV system and quality system Examine how a compliant PV system and a compliant quality system interact to achieve compliance with regulatory requirements for PV Explore how to investigate the complexity of the PV system. Discus how to identify what is missing or what needs to be improved: Discuss how to monitor and maintain the PV system and assure compliance. This course will assist delegates with: An understanding of key system principles, A practical approach to implementing, maintaining and monitoring the PV system and its quality system A procedure to share expertise to increase efficiency and confidence. This course is structured to encourage delegates to: Discuss and develop ideas - Share knowledge and experiences - Solve specific problems.  By the end of the course delegates will be able to: Understand better the pharmacovigilance system, its quality system and how the components interact to achieve the objectives of pharmacovigilance Investigate, and analyse the pharmacovigilance system and to identify what is missing and what needs to be improved. Tutors Tutors will be comprised of (click the photos for biographies): Jana Hyankova Head of PV Department, IVIGEE Services a.s. Programme Please note timings may be subject to alteration. Day 1 08:30 Welcome, registration, course objectives and introduction to work groups Housekeeping notices, meet other delegates, explore how to work in your work group, course objectives. Clarify the definition and objectives of Pharmacovigilance. 09:30 The Regulatory Framework for Pharmacovigilance Identify the relevant regulations and directives. Explore GVP guidance, structure of the modules and standard format of each module. 10:00 The Pharmacovigilance System Exploration of how to organise what has to be done, communications. Exploration of the structures and processes for pharmacovigilance. 10:30 Break 11:00 Workshop 1 and Feedback Exploring an organisational model of the pharmaceutical company- cooperation between PV and other stakeholders. 12:00 The Quality System for pharmacovigilance Exploration of the structures, processes for the PV quality system and discussion of how it interacts with the pharmacovigilance system to meet the objectives of pharmacovigilance effectively and efficiently. 13:00 Lunch 14:00 Workshop 2 and Feedback The quality system puzzle. Explore the organisation of the PV quality system and how it interacts with the PV system. 14:30 The Quality System for pharmacovigilance Exploration of the structures processes for the PV quality system and discussion of how it interacts with the pharmacovigilance system to meet the objectives of pharmacovigilance effectively and efficiently. 15:00 Description of PV System 15:30 Break 15:30 Workshop 3 and Feedback The quality system puzzle Explore the organisation of the PV quality system and how it interacts with the PV system. 16:00 The Pharmacovigilance Safety Master File Construction of the Pharmacovigilance System Master File and its purpose. 17:00 Workshop 3 and Feedback Description of PV System. 18:00 End of Day Day 2 08:30 Drug Safety in the Clinical Trial Environment - Part 1 Information flow and responsibilities of the sponsor. 09:30 Workshop 4 and Feedback Drug Safety in the Clinical Trial environment: Information flow and responsibilities of the sponsor. 10:30 Break 11:00 Drug Safety in the Clinical Trial Environment - Part 2 Information flow and responsibilities of the sponsor. 12:00 Lunch 13:00 Workshop 5 and Feedback Drug Safety in the clinical trial environment: Information flow and responsibilities of the sponsor. 13:30 Processing of Safety Data Exploration of safety data processing, verification, validation, follow up, formatting and collation, reporting requirements, quality and data management. 15:00 Break 15:30 EudraVigilance Exploration of how EudraVigilance supports the PV system. 16:15 Signal Detection and Evaluation/Risk Benefit Assessment: Pharmacovigilance Risk Assessment Committee (PRAC): What is a signal? What are the regulatory requirements? How is signal detection and evaluation conducted? Qualitative and quantitative methods of signal detection. Risk benefit assessment. 17:00 Risk Management Plans A cornerstone of Pharmacovigilance safety communications, direct healthcare professional communication 18:00 End of Day Day 3 08:30 The Pharmacovigilance Risk Assessment Committee (PRAC) Exploration of how good practice is achieved. Composition, role and responsibilities. Examples of referrals. 09:15 Development Safety Update Reports (DSURs): Regulatory requirements, exploring good practice, report format, reference safety information, schedule of submission, analysis evaluations and distribution. 10:00 Periodic Safety Update Reports (PSURs)/Periodic Benefit Risk Evaluation Reports (PBRERs) Regulatory requirements, exploring good practice, report format, reference safety information, schedule of submission, analysis evaluations and distribution. 10:30 Break 11:00 Periodic Safety Update Reports (PSURs)/Periodic Benefit Risk Evaluation Reports (PBRERs) Regulatory requirements, exploring good practice, report format, reference safety information, schedule of submission, analysis evaluations and distribution. 12:00 Workshop 6 and Feedback To explore the compilation and submission of the PSUR. 13:00 Lunch 13:30 Role of the QPPV Exploration of the legal responsibilities of the QPPV and the MAH. 14:30 Break 15:00 Workshop 7 and Feedback To explore the challenges faced by the QPPV. 15:30 End of course Extra Information Face-to-Face Course Course material This course will be run completely online. You will receive an email with a link to our online system, which will house your licensed course materials and access to the remote event. Please note this course will run in UK timezone. The advantages of this include: Ability for delegates to keep material on a mobile device< Ability to review material at any time pre and post course Environmental benefits – less paper being used per course Access to an online course group to enhance networking You will need a stable internet connection, a microphone and a webcam. CPD Points 23 Points   Development Level Develop

Gain comprehensive knowledge and practical skills in asthma and anaphylaxis management with our evidence-based training course. Ideal for healthcare professionals, educators, and patient care providers. Optimise patient outcomes with effective emergency response protocols, prevention strategies, and patient education.

Recent updates in financial regulations have underscored the critical need for professionals equipped with expertise in Financial Investigator, Tax Accounting & Financial Analysis. With the ever-evolving landscape of finance, the demand for skilled individuals adept at navigating complexities and ensuring compliance is at an all-time high. In light of this, our comprehensive Financial Investigator, Tax Accounting & Financial Analysis QLS Endorsed Diploma bundle offers a strategic blend of theoretical knowledge and practical insights to empower learners in this field. Amidst recent discussions on tax reforms and regulatory frameworks, professionals proficient in Financial Investigator, Tax Accounting & Financial Analysis are in high demand. Our Financial Investigator, Tax Accounting & Financial Analysis bundle caters to this demand by offering a meticulous selection of courses endorsed by the Quality Licence Scheme (QLS), supplemented by CPD QS accredited modules. By amalgamating technical proficiency with personal development initiatives, this Financial Investigator, Tax Accounting & Financial Analysis bundle stands as a beacon for aspiring individuals looking to excel in the realm of finance. Bundle Include includes: QLS Endorsed Courses: Course 01: Certificate in Financial Investigator at QLS Level 3 Course 02: Diploma in Financial Analysis at QLS Level 4 Course 03: Diploma in Advanced Tax Accounting at QLS Level 5 CPD QS Accredited Courses: Course 04: Corporate Finance: Profitability in a Financial Downturn Course 05: Finance: Financial Risk Management Course 06: Understanding Financial Statements and Analysis Course 07: Financial Wellness: Managing Personal Cash Flow Course 08: Internal audit skills Course 09: Anti-Money Laundering (AML) Training Course 10: Financial Accounting Course 11: Passive Income Mastery - Build Financial Security Take your career to the next level with our Financial Investigator, Tax Accounting & Financial Analysis bundle that includes technical courses and five guided courses focused on personal development and career growth. Course 12: Career Development Plan Fundamentals Course 13: CV Writing and Job Searching Course 14: Networking Skills for Personal Success Course 15: Ace Your Presentations: Public Speaking Masterclass Course 16: Decision Making and Critical Thinking Seize this opportunity to elevate your career with our comprehensive Financial Investigator, Tax Accounting & Financial Analysis bundle, endorsed by the prestigious QLS and accredited by CPD.Financial Investigator, Tax Accounting & Financial Analysis QLS Endorsed Diploma. Learning Outcomes: Develop a comprehensive understanding of financial investigation techniques and methodologies through Financial Investigator, Tax Accounting & Financial Analysis. Master advanced principles of financial analysis to evaluate business performance effectively. Gain proficiency in navigating complex tax accounting principles and regulations. Acquire insights into corporate finance strategies amidst financial downturns by Financial Investigator, Tax Accounting & Financial Analysis courses. Strengthen skills in financial risk management and internal audit procedures. Enhance personal finance management and cash flow optimization techniques. This comprehensive Financial Investigator, Tax Accounting & Financial Analysis bundle delves into the intricacies of Financial Investigator, Tax Accounting & Financial Analysis with a meticulous approach towards theoretical frameworks and practical applications. Through a series of endorsed courses by the Quality Licence Scheme (QLS) and CPD QS accredited modules, learners will embark on a journey of discovery, uncovering the nuances of financial investigation techniques, advanced principles of financial analysis, and the complex landscape of tax accounting. Participants will engage in in-depth explorations of corporate finance strategies amidst financial downturns, mastering the art of financial risk management, and honing their skills in internal audit procedures. Additionally, the curriculum extends beyond traditional finance realms, offering insights into personal finance management and cash flow optimization techniques, equipping learners with a holistic understanding of financial dynamics. With a blend of theoretical knowledge and practical insights, this Financial Investigator, Tax Accounting & Financial Analysis course empowers individuals to navigate the multifaceted world of finance with confidence and competence. CPD 160 CPD hours / points Accredited by CPD Quality Standards Who is this course for? This course Financial Investigator, Tax Accounting & Financial Analysis is ideal for: Professionals seeking to enhance their expertise in financial investigation, tax accounting, and financial analysis. Individuals aspiring to pursue careers in forensic accounting, financial consultancy, or tax advisory roles. Finance professionals looking to advance their skills and stay abreast of industry trends across Financial Investigator, Tax Accounting & Financial Analysis courses. Graduates aiming to enter the finance sector with a competitive edge. Requirements You are warmly invited to register for this bundle. Please be aware that there are no formal entry requirements or qualifications necessary. This curriculum has been crafted to be open to everyone, regardless of previous experience or educational attainment. Career path Upon completion of the Financial Investigator, Tax Accounting & Financial Analysis courses, you will be able to: Financial Investigator Forensic Accountant Tax Consultant Financial Analyst Internal Auditor Risk Manager Corporate Finance Advisor Certificates 13 CPD Quality Standard Certificates Digital certificate - Included 3 QLS Endorsed Certificates Hard copy certificate - Included

Dip yourself in the dynamic world of Python programming with our Python for Beginners Online Course. Master Python's key concepts, its syntax, data types, and much more.

Microsoft Active Directory course description A thorough understanding of this system is essential for anyone managing enterprise MS networks. Essential theory is complimented with a high level of hands on practice allowing delegates to observe the idiosyncrasies of Active Directory and Group Policy at first hand. Delegates learn the fundamental theory of AD and progress onto building a multi-domain network in the classroom. The course includes troubleshooting methods, and essential maintenance procedures. This course is designed to teach you the skills needed for day to day management of these technologies. What will you learn Install AD on multiple PCs. Use the tools to create and manage objects. Create appropriate group policies to restrict selected user's desktops and network access. Install DNS to support Active Directory without loosing Internet Connectivity. Maintain and troubleshoot AD problems Backup Active Directory. Microsoft Active Directory course details Who will benefit: Technical staff working with AD based networks. Prerequisites: Supporting Windows server. Duration 3 days Microsoft Active Directory course contents Introduction to Active Directory Network authentication methods, Active Directory defined, AD naming conventions, network management with AD, AD structures: Domains, Organisational Units, Forests & Trees, Sites, The Global Catalogue. Windows 2003 new features, installing AD. Hands on Installing an AD network. Windows overview Management methods Server management tools, installing the additional tools, Terminal Server: Administration mode, Administrator accounts in AD, Local Security Policy. Hands on Install the management tools, Management using Terminal Services. Creating & Managing Objects (a quick look) AD management tools, AD users and computers, Creating & managing OUs, User Accounts and groups, controlling access to AD objects, moving objects, Publishing resources, locating objects in AD, delegating authority. Hands on Creating a control OU structure and delegating authority. Introduction to Group Policies What are Group Policies? Where Group Policy data is stored, security, Group Policy flow. Hands on Implementing Group Policies Working with Group Policies Local security templates, administrative templates, scripts, folder redirection, software deployment. Hands on Scripts, redirecting the start menu, creating a secure, robust desktop environment. Implementing DNS DNS basics, troubleshooting, implementing DNS zones. Hands on Building a unified DNS solution. Maintaining and managing the AD database AD support tools, database internal structure, replication, replication tools, Single Operations Masters, tools for maintenance, maintenance techniques, Backing up AD, Directory Services restore mode, NTDSUtil, Authoritative & non-authoritative restoration, rebuilding. Hands on NTDSUtil.

Effecting Business Process Improvement: Virtual In-House Training Business analysts facilitate the solution of business problems. The solutions are put into practice as changes to the way people perform in their organizations and the tools they use. The business analyst is a change agent who must understand the basic principles of quality management. This course covers the key role that business analysts play in organizational change management. What you will Learn You will learn how to: Define and document a business process Work with various business modeling techniques Perform an enterprise analysis in preparation for determining requirements Analyze business processes to discern problems Foundation Concepts Overview of business analysis and process improvement Defining the business process Introducing the proactive business analyst Focusing on business process improvement for business analysts Launching a Successful Business Process Improvement Project Overview of the launch phase Understanding and creating organizational strategy Selecting the target process Aligning the business process improvement project's goals and objectives with organizational strategy Defining the Current Process Overview of current process phase Documenting the business process Business modeling options: work-flow models Business modeling options: Unified Modeling Language (UML) model adaptations for business processes Analyzing the Current Process Process analysis overview Evaluation: establishing the control group Opportunity techniques: multi-discipline problem-solving Opportunity techniques: matrices Building and Sustaining a Recommended Process Overview of the recommended process and beyond Impact analysis Recommended process Transition to the business case Return to proactive state

CPD QS Accredited| Instant Access | 24/7 Tutor Support | All-Inclusive Cost

The courses are designed for managers, supervisors or others who wish to develop an understanding of the basic safety requirements for personnel who carry out gas ‘work’.

Duration 4 Days 24 CPD hours This course is intended for The App Maker builds solutions to simplify, automate, and transform tasks and processes for themselves and their team where they have deep expertise in the solution business domain. They have basic data modeling, user experience design, requirements analysis, and process analysis skills. The App Maker creates and enforces business processes, structures digital collection of information, improves efficiency of repeatable tasks, and automates business processes. The App Maker uses the Maker tools of Power Platform to solve business problems. They may use advanced features of Microsoft apps and third-party productivity tools. The App Maker is aware of the capabilities and limitations of available tools and understands how to apply them. The App Maker is self-directed, and solution focused. They may not have formal IT training but are comfortable using technology to solve business problems with a personal growth mindset. They understand the operational need and have a vision of the desired outcome. They approach problems with phased and iterative strategies. This course will teach you how to build apps with low-code techniques to simplify, automate, and transform business tasks and processes using Microsoft Power Platform. This course contains a 1-day Applied Workshop. This workshop will allow you to practice your App Maker skills by creating an end-to-end solution to solve a problem for a fictitious company. The solution will include a Microsoft Dataverse database, Power Apps canvas app, and Power Automate flows. 1 - Get started with Microsoft Power Platform for app makers Identify components Create apps Get started with Microsoft Dataverse Work with Copilot in Microsoft Power Platform 2 - Create tables in Dataverse Table characteristics Table relationships Dataverse logic and security Dataverse auditing Dual-write vs. virtual tables 3 - Create and manage columns within a table in Dataverse Define columns in Microsoft Dataverse Column types in Microsoft Dataverse Add a column to a table Primary name column Restrictions that apply to columns in a table Create an auto numbering column Create an alternate key 4 - Load/export data and create data views in Dataverse View data in a table Create or edit views of data in a table Dataverse data import options Load data into a table Dataverse data export options Export Add, update, or delete data in a table by using Excel Import data using Power Query 5 - Export data from Dataverse and use Microsoft Excel to edit records Export data to Excel Edit and update data in Excel 6 - Get started with Microsoft Dataverse for Teams Dataverse for Teams vs Dataverse Provision your first Dataverse environment Create your first table to store data 7 - Build your first app with Power Apps and Dataverse for Teams Create your first app with the hero template Customize your app with Power Apps Studio Publish your app Install template apps 8 - Build your first workflow with Power Automate and Dataverse for Teams Types of workflows that Power Automate can build in Dataverse Schedule a flow 9 - Create reports with Power BI and Dataverse for Teams Connect to and transform Dataverse for Teams data from Power BI Create a Power BI report Publish the report Share the data 10 - Get started building with Power BI Use Power BI Building blocks of Power BI Tour and use the Power BI service 11 - Explore what Power BI can do for you What can I do with the Power BI service as a consumer? View content in the Power BI service Collaborate and share in Power BI Find and view dashboards and reports 12 - Create and manage workspaces in Power BI Distribute a report or dashboard Monitor usage and performance Recommend a development life cycle strategy Troubleshoot data by viewing its lineage Configure data protection 13 - Manage semantic models in Power BI Use a Power BI gateway to connect to on-premises data sources Configure a semantic model scheduled refresh Configure incremental refresh settings Manage and promote semantic models Troubleshoot service connectivity Boost performance with query caching (Premium) 14 - Create dashboards in Power BI Configure data alerts Explore data by asking questions Review Quick insights Add a dashboard theme Pin a live report page to a dashboard Configure a real-time dashboard Set mobile view 15 - Implement row-level security Configure row-level security with the static method Configure row-level security with the dynamic method 16 - Create dashboards in Power BI Configure data alerts Explore data by asking questions Review Quick insights Add a dashboard theme Pin a live report page to a dashboard Configure a real-time dashboard Set mobile view 17 - Secure, publish, and share data in Power BI Share and use reports in Power BI Row-level security Publish a report to a Power BI workspace Share reports and user experience Protect data in Power BI Data refresh and alerts 18 - Embed Power BI content Embed Power BI reports Embed other Power BI content types Optimize the embedding experience 19 - How to build your first model-driven app with Dataverse Model-driven apps, powered by Microsoft Dataverse Explore sample apps 20 - Get started with model-driven apps in Power Apps Introducing model-driven apps Components of model-driven apps Design model-driven apps Incorporate business process flows 21 - Configure forms, charts, and dashboards in model-driven apps Forms overview Form elements Configure multiple forms Use specialized form components Configure views overview Configure grids Create and edit views Configure charts overview Dashboards overview Use interactive streams and tiles 22 - Manage Dynamics 365 model-driven app settings and security Configure role-based security Manage teams and business units Explore settings and customizations 23 - Use specialized components in a model-driven form Create business process flows Embed a canvas app in a model-driven form Add a timeline in a model-driven form Create a report in a model-driven form 24 - Get started with Power Apps canvas apps Start Power Apps Power Apps data sources Use Power Apps with Power Automate and Power BI Designing a Power Apps app 25 - Customize a canvas app in Power Apps Improve your app by making basic customizations Explore controls and screens in canvas apps 26 - How to build the User Interface in a canvas app in Power Apps Use themes to quickly change the appearance of your app Brand a control Icons Images Personalization Build for phones or tablets 27 - Navigation in a canvas app in Power Apps Understanding navigation The Navigate and Back functions More ways to use the Navigate function 28 - Manage apps in Power Apps Power Apps review 29 - Build a mobile-optimized app from Power Apps Learn about mobile-optimized apps Identify components to make a canvas app mobile-optimized Create a mobile-optimized app that uses responsive designs Identify performance considerations for a mobile-optimized canvas app 30 - Use and understand Controls in a canvas app in Power Apps Core properties of controls Entering and displaying data with text controls Additional controls for enhancing your app's usability Media Modern controls Work with component libraries 31 - Create formulas to change properties in a Power Apps canvas app Formulas overview Use a formula to modify the format of controls Use formulas to perform calculations Use a control to modify the property of other controls Conditional formatting Functions for validating data 32 - Use imperative development techniques for canvas apps in Power Apps Imperative versus declarative development The three types of variables in Power Apps Global variables Contextual variables Collections Additional variable concepts 33 - Manage apps in Power Apps Power Apps review 34 - Create formulas to change properties in a Power Apps canvas app Formulas overview Use a formula to modify the format of controls Use formulas to perform calculations Use a control to modify the property of other controls Conditional formatting Functions for validating data 35 - Create formulas to change behaviors in a Power Apps canvas app Formulas and functionality Understanding true and false Understanding control behaviors and actions Performing multiple actions in a formula Control the display mode through a formula Use controls and functions to create a dynamic formula 36 - Author a basic formula that uses tables and records in a Power Apps canvas app Records and tables Using the Table function Store a table Filter your table Use the lookup function to return a record Additional table functions 37 - Build a canvas app for a real estate solution with Copilot in Power Apps 38 - Get started with Power Automate Introducing Power Automate Create your first flow Troubleshoot flows 39 - Build approval flows with Power Automate Provide solutions to real-world scenarios. 40 - Build flows to manage user information 41 - Power Automate's deep integration across multiple data sources 42 - Use the Admin center to manage environments and data policies in Power Automate Administer flows Export and import flows Learn how to distribute button flows 43 - Use AI Builder in Power Automate AI Builder in Power Automate saves time Advanced usage of AI Builder in Power Automate 44 - Optimize your business process with process advisor Get familiar with process advisor Create your first recording Edit recordings and group actions Analyze recordings and interpret results Automation recommendations 45 - Optimize your business process with process advisor Get familiar with process advisor Create your first recording Edit recordings and group actions Analyze recordings and interpret results Automation recommendations 46 - Build flows for a real estate solution using Copilot in Power Automate When to use Copilot in Power Automate 47 - Use Dataverse triggers and actions in Power Automate Dataverse triggers Query data Create, update, delete, and relate actions 48 - Create tables in Dataverse Table characteristics Table relationships Dataverse logic and security Dataverse auditing Dual-write vs. virtual tables 49 - Create and manage columns within a table in Dataverse Define columns in Microsoft Dataverse Column types in Microsoft Dataverse Add a column to a table Primary name column Restrictions that apply to columns in a table Create an auto numbering column Create an alternate key 50 - Get started with Power Apps canvas apps Start Power Apps Power Apps data sources Use Power Apps with Power Automate and Power BI Designing a Power Apps app 51 - How to build the User Interface in a canvas app in Power Apps Use themes to quickly change the appearance of your app Brand a control Icons Images Personalization Build for phones or tablets 52 - Get started with Power Automate Introducing Power Automate Create your first flow Troubleshoot flows 53 - Challenge Project - Build a booking requests app with Power Apps and Power Automate Prepare