Name: 55337 Introduction to Programming
Price: 2975 GBP
Availability: InStock

<p>ð Unleash Your Productivity Potential with 'Optimizing Productivity Through Slack Efficiency' ð</p><p>Are you drowning in a sea of endless Slack messages, struggling to keep your tasks organized and team communication streamlined? It's time to transform the way you work and skyrocket your productivity! Introducing our game-changing online course:</p><p> </p><p>ð <strong>Optimizing Productivity Through Slack Efficiency</strong> ð</p><p> </p><p>ð <strong>Unlock the Power of Slack: Master the Art of Collaboration</strong></p><p>Discover insider secrets to turn Slack from a communication tool into a productivity powerhouse. Learn how to harness the full potential of channels, threads, and integrations to create a seamless workflow that propels your projects forward.</p><p>ð¥ <strong>Boost Your Team's Efficiency: Strategies for Effective Communication</strong></p><p>Say goodbye to information overload and hello to clarity! Dive into proven techniques for crafting concise messages, managing notifications, and facilitating focused discussions. Transform your team into a well-oiled machine that accomplishes more in less time.</p><p>ð¯ <strong>Time-Saving Hacks: Work Smarter, Not Harder</strong></p><p>Explore a treasure trove of time-saving hacks that will revolutionize the way you work in Slack. From keyboard shortcuts to automation tools, we'll teach you how to navigate Slack effortlessly and reclaim precious hours in your day.</p><p>ð <strong>Global Collaboration: Connecting Teams Across Time Zones</strong></p><p>Crush geographical boundaries and optimize collaboration in a distributed world. Learn strategies for managing time zone differences, scheduling effective meetings, and keeping everyone in the loop, no matter where they are.</p><p>ð <strong>Security and Compliance: Ensure Confidentiality in Every Message</strong></p><p>Protect sensitive information and maintain compliance effortlessly. Our course covers best practices for secure communication, setting up permissions, and keeping your team's data safe within the Slack ecosystem.</p><p> </p><p>ð <strong>Why Choose Our Course?</strong></p><p>â <strong>Expert Guidance:</strong> Learn from industry experts with years of experience in maximizing productivity through Slack.</p><p>â <strong>Practical Insights:</strong> Gain real-world strategies and actionable tips that you can implement immediately.</p><p>â <strong>Interactive Learning:</strong> Engage with hands-on exercises, case studies, and live Q&amp;A sessions to solidify your understanding.</p><p>â <strong>Lifetime Access:</strong> Enjoy unlimited access to course materials, updates, and a supportive community of fellow learners.</p><p> </p><p>ð¨ Don't miss out on the opportunity to revolutionize the way you work! Join 'Optimizing Productivity Through Slack Efficiency' now and take the first step towards a more efficient, collaborative, and successful future.</p><p>â° Time is of the essence. Enroll today and supercharge your productivity with Slack mastery! â°</p><p> </p><p>ð Elevate Your Productivity, Transform Your Workflow, Master Slack Efficiency! ð</p><div><div><div><h3>
Course Curriculum</h3><div><div><h4>
Basic</h4><div><div><ul><li><div>
<span></span><h5>
Overview</h5></div><div>
<span>
00:00													</span>
<span></span></div></li><li><div>
<span></span><h5>
Pricing</h5></div><div>
<span>
00:00													</span>
<span></span></div></li><li><div>
<span></span><h5>
Account Opening</h5></div><div>
<span>
00:00													</span>
<span></span></div></li><li><div>
<span></span><h5>
Profile and Multiple Workspaces</h5></div><div>
<span>
00:00													</span>
<span></span></div></li><li><div>
<span></span><h5>
Desktop and Mobile Software</h5></div><div>
<span>
00:00													</span>
<span></span></div></li><li><div>
<span></span><h5>
Customizing the Workspace - Part 1</h5></div><div>
<span>
00:00													</span>
<span></span></div></li><li><div>
<span></span><h5>
Customizing the Workspace - Part 2</h5></div><div>
<span>
00:00													</span>
<span></span></div></li><li><div>
<span></span><h5>
Settings and Preferences</h5></div><div>
<span>
00:00													</span>
<span></span></div></li><li><div>
<span></span><h5>
Settings and Preferences - Part 2</h5></div><div>
<span>
00:00													</span>
<span></span></div></li><li><div>
<span></span><h5>
Members and User Groups</h5></div><div>
<span>
00:00													</span>
<span></span></div></li><li><div>
<span></span><h5>
Built In Recordings</h5></div><div>
<span>
00:00													</span>
<span></span></div></li><li><div>
<span></span><h5>
Zapier Integrations</h5></div><div>
<span>
00:00													</span>
<span></span></div></li><li><div>
<span></span><h5>
Creating Channels - Part 1</h5></div><div>
<span>
00:00													</span>
<span></span></div></li><li><div>
<span></span><h5>
Creating Channels - Part 2</h5></div><div>
<span>
00:00													</span>
<span></span></div></li><li><div>
<span></span><h5>
Sending Direct Messages</h5></div><div>
<span>
00:00													</span>
<span></span></div></li><li><div>
<span></span><h5>
Creating Message Posts - Part 1</h5></div><div>
<span>
00:00													</span>
<span></span></div></li><li><div>
<span></span><h5>
Creating Message Posts - Part 2</h5></div><div>
<span>
00:00													</span>
<span></span></div></li><li><div>
<span></span><h5>
Analytics</h5></div><div>
<span>
00:00													</span>
<span></span></div></li><li><div>
<span></span><h5>
Search</h5></div><div>
<span>
00:00													</span>
<span></span></div></li><li><div>
<span></span><h5>
Conclusion</h5></div><div>
<span>
00:00													</span>
<span></span></div></li></ul></div></div></div><div><h4>
Advance</h4><div><div><ul><li><div>
<span></span><h5>
Overview and Skype Integration</h5></div><div>
<span>
00:00													</span>
<span></span></div></li><li><div>
<span></span><h5>
Meeting Live - Zoom Integration</h5></div><div>
<span>
00:00													</span>
<span></span></div></li><li><div>
<span></span><h5>
Sharing Meeting Recordings - YouTube Integration</h5></div><div>
<span>
00:00													</span>
<span></span></div></li><li><div>
<span></span><h5>
Sharing Meeting Recordings - YouTube Integration - Part 2</h5></div><div>
<span>
00:00													</span>
<span></span></div></li><li><div>
<span></span><h5>
Sharing Google Docs - Part 1</h5></div><div>
<span>
00:00													</span>
<span></span></div></li><li><div>
<span></span><h5>
Sharing Google Docs - Part 2</h5></div><div>
<span>
00:00													</span>
<span></span></div></li><li><div>
<span></span><h5>
Sharing Google Calendar</h5></div><div>
<span>
00:00													</span>
<span></span></div></li><li><div>
<span></span><h5>
WordPress Website Updates with Slack - Part 1</h5></div><div>
<span>
00:00													</span>
<span></span></div></li><li><div>
<span></span><h5>
WordPress Website Updates with Slack - Part 2</h5></div><div>
<span>
00:00													</span>
<span></span></div></li><li><div>
<span></span><h5>
Slack Storage - Google Drive</h5></div><div>
<span>
00:00													</span>
<span></span></div></li><li><div>
<span></span><h5>
Slack Storage - Dropbox</h5></div><div>
<span>
00:00													</span>
<span></span></div></li><li><div>
<span></span><h5>
Client and Customer Management - Stripe</h5></div><div>
<span>
00:00													</span>
<span></span></div></li><li><div>
<span></span><h5>
Client and Customer Management - Paypal</h5></div><div>
<span>
00:00													</span>
<span></span></div></li><li><div>
<span></span><h5>
Client and Customer Management - Getresponse</h5></div><div>
<span>
00:00													</span>
<span></span></div></li><li><div>
<span></span><h5>
Client and Customer Management - Mailchimp</h5></div><div>
<span>
00:00													</span>
<span></span></div></li><li><div>
<span></span><h5>
LIve Example - Channel Creation</h5></div><div>
<span>
00:00													</span>
<span></span></div></li><li><div>
<span></span><h5>
Live Example - Team Invitations</h5></div><div>
<span>
00:00													</span>
<span></span></div></li><li><div>
<span></span><h5>
Live Meeting Creation</h5></div><div>
<span>
00:00													</span>
<span></span></div></li><li><div>
<span></span><h5>
Live Meeting Archive</h5></div><div>
<span>
00:00													</span>
<span></span></div></li><li><div>
<span></span><h5>
Conclusion</h5></div><div>
<span>
00:00													</span>
<span></span></div></li></ul></div></div></div></div></div></div></div>

Compete High

Optimizing Productivity Through Slack Efficiency

General Admission

<div id="course-pills-1">Duration<p>1 Days</p><p>6 CPD hours</p>This course is intended for<p></p><p>The audience for this course is looking to familiarize themselves with the fundamentals of security, compliance, and identity (SCI) across cloud-based and related Microsoft services. The content for this course aligns to the SC-900 exam objective domain. Candidates should be familiar with Microsoft Azure and Microsoft 365 and understand how Microsoft security, compliance, and identity solutions can span across these solution areas to provide a holistic and end-to-end solution.</p> <p>Before attending this course, students must have:</p> <ul> <li><p>General understanding of networking and cloud computing concepts.</p> </li> <li><p>General IT knowledge or any general experience working in an IT environment.</p> </li> <li><p>General understanding of Microsoft Azure and Microsoft 365.</p> </li> </ul><p></p><p></p><p>This course provides foundational level knowledge on security, compliance, and identity concepts and related cloud-based Microsoft solutions.</p><p></p>Prerequisites<p></p><p></p><ul> <li>General understanding of networking and cloud computing concepts.</li> <li>General IT knowledge or any general experience working in an IT environment.</li> <li>General understanding of Microsoft Azure and Microsoft 365.</li></ul><p></p><p></p></div><div id="course-pills-2"><h3>1 - Describe security and compliance concepts</h3> <ul> <li>Describe the shared responsibility model</li> <li>Describe defense in depth</li> <li>Describe the Zero Trust model</li> <li>Describe governance, risk, and compliance (GRC) concepts</li> </ul> <h3>2 - Describe identity concepts</h3> <ul> <li>Define authentication and authorization</li> <li>Define identity as the primary security perimeter</li> <li>Describe the role of the identity provider</li> <li>Describe the concept of directory services and Active Directory</li> <li>Describe the concept of federation</li> </ul> <h3>3 - Describe the function and identity types of Microsoft Entra ID</h3> <ul> <li>Describe Microsoft Entra ID</li> <li>Describe types of identities</li> <li>Describe hybrid identity</li> <li>Describe external identities</li> </ul> <h3>4 - Describe the authentication capabilities of Microsoft Entra ID</h3> <ul> <li>Describe authentication methods</li> <li>Describe multifactor authentication</li> <li>Describe self-service password reset</li> <li>Describe password protection and management capabilities</li> </ul> <h3>5 - Describe access management capabilities of Microsoft Entra ID</h3> <ul> <li>Describe Conditional Access</li> <li>Describe Microsoft Entra roles and role-based access control (RBAC)</li> </ul> <h3>6 - Describe the identity protection and governance capabilities of Azure AD</h3> <ul> <li>Describe Microsoft Entra ID Governance</li> <li>Describe access reviews</li> <li>Describe entitlement management</li> <li>Describe the capabilities of Privileged identity Management</li> <li>Describe Microsoft Entra ID Protection</li> <li>Describe Microsoft Entra Permissions Management</li> <li>Describe Microsoft Entra Verified ID</li> </ul> <h3>7 - Describe core infrastructure security services in Azure</h3> <ul> <li>Describe Azure DDoS protection</li> <li>Describe Azure Firewall</li> <li>Describe Web Application Firewall</li> <li>Describe network segmentation in Azure</li> <li>Describe Azure Network Security Groups</li> <li>Describe Azure Bastion</li> <li>Describe Azure Key Vault</li> </ul> <h3>8 - Describe the security management capabilities in Azure</h3> <ul> <li>Describe Microsoft Defender for Cloud</li> <li>Describe how security policies and initiatives improve cloud security posture</li> <li>Describe Cloud security posture management</li> <li>Describe the enhanced security of Microsoft Defender for Cloud</li> <li>Describe DevOps security management</li> </ul> <h3>9 - Describe security capabilities of Microsoft Sentinel</h3> <ul> <li>Describe threat detection and mitigation capabilities in Microsoft Sentinel</li> <li>Describe Microsoft Security Copilot</li> </ul> <h3>10 - Describe threat protection with Microsoft Defender XDR</h3> <ul> <li>Describe Microsoft Defender XDR services</li> <li>Describe Microsoft Defender for Office 365</li> <li>Describe Microsoft Defender for Endpoint</li> <li>Describe Microsoft Defender for Cloud Apps</li> <li>Describe Microsoft Defender for Identity</li> <li>Describe Microsoft Defender Vulnerability Management</li> <li>Describe Microsoft Defender Threat Intelligence</li> <li>Describe the Microsoft Defender portal</li> </ul> <h3>11 - Describe Microsoft?s Service Trust portal and privacy capabilities</h3> <ul> <li>Describe the offerings of the Service Trust portal</li> <li>Describe Microsoft's privacy principles</li> <li>Describe Microsoft Priva</li> </ul> <h3>12 - Describe the compliance management capabilities in Microsoft Purview</h3> <ul> <li>Describe the Microsoft Purview compliance portal</li> <li>Describe Compliance Manager</li> <li>Describe use and benefits of compliance score</li> </ul> <h3>13 - Describe information protection, data lifecycle management, and data governance capabilities in Microsoft Purview</h3> <ul> <li>Know your data, protect your data, and govern your data</li> <li>Describe the data classification capabilities of the compliance portal</li> <li>Describe sensitivity labels and policies</li> <li>Describe data loss prevention</li> <li>Describe retention policies and retention labels</li> <li>Describe records management</li> <li>Describe the Microsoft Purview unified data governance solution</li> </ul> <h3>14 - Describe the insider risk capabilities in Microsoft Purview</h3> <ul> <li>Describe insider risk management</li> <li>Describe communication compliance</li> </ul> <h3>15 - Describe the eDiscovery and Audit capabilities in Microsoft Purview</h3> <ul> <li>Describe the eDiscovery solutions in Microsoft Purview</li> <li>Describe the audit solutions in Microsoft Purview</li> </ul></div>

Nexus Human

Microsoft Certification

Microsoft AZ-900

Microsoft AZ-104

Microsoft AZ-303

Microsoft AZ-700

CompTIA Security+

SC-900T00 Microsoft Security Compliance and Identity Fundamentals

<div id="course-pills-1">Duration<p>5 Days</p><p>30 CPD hours</p>This course is intended for<p></p><p>A Microsoft Power Platform Functional Consultant is responsible for creating and configuring apps, automations, and solutions. They act as the liaison between users and the implementation team. The functional consultant promotes utilization of solutions within an organization. The functional consultant may perform discovery, engage subject matter experts and stakeholders, capture requirements, and map requirements to features. They implement components of a solution including application enhancements, custom user experiences, system integrations, data conversions, custom process automation, and simple visualizations.</p><p></p><p></p><p>This course will teach you to use Microsoft Power Platform solutions to simplify, automate, and empower business processes for organizations in the role of a Functional Consultant. A Microsoft Power Platform Functional Consultant is responsible for creating and configuring apps, automations, and solutions. They act as the liaison between users and the implementation team. The functional consultant promotes utilization of solutions within an organization. The functional consultant may perform discovery, engage subject matter experts and stakeholders, capture requirements, and map requirements to features. They implement components of a solution including application enhancements, custom user experiences, system integrations, data conversions, custom process automation, and simple visualizations. This course may contain a 1-day Applied Workshop. This workshop will allow you to practice your Functional Consultant 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.</p><p></p>Prerequisites<p></p><p></p><ul> <li>Experience as an IT professional or student</li> <li>Working knowledge of Microsoft Power Platform and its key components</li> <li>Knowledge of Microsoft Dataverse (or general data modeling) and security concepts</li></ul><p></p><p></p></div><div id="course-pills-2"><h3>1 - Describe the business value of the Microsoft Power Platform</h3> <ul> <li>Explore Microsoft Power Platform</li> <li>Describe the business value of the Power Platform</li> <li>Explore connectors and Microsoft Dataverse</li> <li>Describe how Power Platform works with Microsoft 365 apps and services</li> <li>Explore how Power Platform works with Microsoft Teams</li> <li>Describe how Power Platform works  with Microsoft Dynamics 365 apps</li> <li>Describe how Power Platform solutions consume Microsoft Azure services </li> <li>Explore how Microsoft Power Platform apps work together </li> <li>Use Artificial Intelligence to increase productivity</li> </ul> <h3>2 - Core components of Power Pages</h3> <ul> <li>Get started with Power Pages</li> <li>Core tools and components of Power Pages</li> <li>Overview of Power Pages security</li> <li>Overview of Power Pages extensibility</li> </ul> <h3>3 - Explore Power Pages templates</h3> <ul> <li>Site design templates</li> <li>Scenario-based templates</li> <li>Dynamics 365 Power Pages site templates</li> </ul> <h3>4 - Explore Power Pages design studio</h3> <ul> <li>Work with pages</li> <li>Page components</li> <li>Site styling and templates</li> </ul> <h3>5 - Explore Power Pages design studio data and security features</h3> <ul> <li>Data workspace in Power Pages design studio</li> <li>Power Pages security features</li> </ul> <h3>6 - Introduction to Power Pages administration</h3> <ul> <li>Power Pages administrative tools</li> <li>Set up workspace in Power Pages design studio</li> </ul> <h3>7 - Get started building with Power BI</h3> <ul> <li>Use Power BI</li> <li>Building blocks of Power BI</li> <li>Tour and use the Power BI service</li> </ul> <h3>8 - Get data with Power BI Desktop</h3> <ul> <li>Overview of Power BI Desktop</li> <li>Explore Power BI Desktop</li> <li>Connect to data sources</li> <li>Get data from Excel</li> <li>Transform data to include in a report</li> <li>Combine data from multiple sources</li> <li>Clean data to include in a report</li> </ul> <h3>9 - Model data in Power BI</h3> <ul> <li>How to manage your data relationships</li> <li>Create calculated columns</li> <li>Optimize data models</li> <li>Create measures</li> <li>Create calculated tables</li> <li>Explore time-based data</li> </ul> <h3>10 - Use visuals in Power BI</h3> <ul> <li>Create and customize simple visualizations</li> <li>Create slicers</li> <li>Map visualizations</li> <li>Matrices and tables</li> <li>Create scatter, waterfall, and funnel charts</li> <li>Modify colors in charts and visuals</li> <li>Page layout and formatting</li> </ul> <h3>11 - Explore data in Power BI</h3> <ul> <li>Quick insights in Power BI</li> <li>Create and configure a dashboard</li> <li>Ask questions of your data with natural language</li> <li>Create custom Q&amp;A suggestions</li> <li>Share dashboards with your organization</li> <li>Display visuals and tiles in full screen</li> <li>Edit tile details and add widgets</li> <li>Get more space on your dashboard</li> </ul> <h3>12 - Publish and share in Power BI</h3> <ul> <li>Publish Power BI Desktop reports</li> <li>Print and export dashboards and reports</li> <li>Introducing Power BI Mobile</li> <li>Create workspaces in Power BI</li> <li>Build apps</li> <li>Use apps</li> <li>Integrate OneDrive for Business with Power BI</li> <li>Publish to web</li> </ul> <h3>13 - Create and manage workspaces in Power BI</h3> <ul> <li>Distribute a report or dashboard</li> <li>Monitor usage and performance</li> <li>Recommend a development life cycle strategy</li> <li>Troubleshoot data by viewing its lineage</li> <li>Configure data protection</li> </ul> <h3>14 - Manage semantic models in Power BI</h3> <ul> <li>Use a Power BI gateway to connect to on-premises data sources</li> <li>Configure a semantic model scheduled refresh</li> <li>Configure incremental refresh settings</li> <li>Manage and promote semantic models</li> <li>Troubleshoot service connectivity</li> <li>Boost performance with query caching (Premium)</li> </ul> <h3>15 - Create dashboards in Power BI</h3> <ul> <li>Configure data alerts</li> <li>Explore data by asking questions</li> <li>Review Quick insights</li> <li>Add a dashboard theme</li> <li>Pin a live report page to a dashboard</li> <li>Configure a real-time dashboard</li> <li>Set mobile view</li> </ul> <h3>16 - Implement row-level security</h3> <ul> <li>Configure row-level security with the static method</li> <li>Configure row-level security with the dynamic method</li> </ul> <h3>17 - Create tables in Dataverse</h3> <ul> <li>Table characteristics</li> <li>Table relationships</li> <li>Dataverse logic and security</li> <li>Dataverse auditing</li> <li>Dual-write vs. virtual tables</li> </ul> <h3>18 - Manage tables in Dataverse</h3> <ul> <li>Identify tables and table types in Dataverse</li> <li>Create a custom table</li> <li>Enable attachments within a table</li> <li>Licensing requirements for each table type</li> </ul> <h3>19 - Create and manage columns within a table in Dataverse</h3> <ul> <li>Define columns in Microsoft Dataverse</li> <li>Column types in Microsoft Dataverse</li> <li>Add a column to a table</li> <li>Create a primary name column</li> <li>Restrictions that apply to columns in a table</li> <li>Create an auto numbering column</li> <li>Create an alternate key</li> </ul> <h3>20 - Create a relationship between tables in Dataverse</h3> <ul> <li>Relate one or more tables - Introduction</li> <li>Relationship types that are available in Microsoft Dataverse</li> <li>Create a one-to-many relationship between tables</li> <li>Create a many-to-many relationship between tables</li> <li>Edit or delete relationships</li> </ul> <h3>21 - Working with choices in Dataverse</h3> <ul> <li>Define choice column</li> <li>Standard choices column</li> </ul> <h3>22 - Get started with security roles in Dataverse</h3> <ul> <li>Understand environment roles</li> <li>Adding or disabling an environment user</li> <li>Understand security concepts in Dataverse</li> <li>Understand user security roles and security role defaults</li> <li>Check the roles that a user belongs to</li> <li>Configure Dataverse teams for security</li> <li>Configure Dataverse group teams for security</li> </ul> <h3>23 - Use administration options for Dataverse</h3> <ul> <li>Use Microsoft Power Platform Admin Center portal</li> <li>Tenant storage capacity</li> <li>Advanced Customization options in Power Apps Portal</li> <li>Enable and disable auditing</li> </ul> <h3>24 - Manage Dynamics 365 model-driven app settings and security</h3> <ul> <li>Configure role-based security</li> <li>Manage teams and business units</li> <li>Explore settings and customizations</li> </ul> <h3>25 - Introduction to Microsoft Power Platform security and governance</h3> <ul> <li>Identify Microsoft Power Platform environments</li> <li>Data Loss Prevention policies</li> <li>Microsoft Power Platform Center of Excellence Starter Kit</li> </ul> <h3>26 - Get started with model-driven apps in Power Apps</h3> <ul> <li>Introducing model-driven apps</li> <li>Components of model-driven apps</li> <li>Design model-driven apps</li> <li>Incorporate business process flows</li> </ul> <h3>27 - Configure forms, charts, and dashboards in model-driven apps</h3> <ul> <li>Forms overview</li> <li>Form elements</li> <li>Configure multiple forms</li> <li>Use specialized form components</li> <li>Configure views overview</li> <li>Configure grids</li> <li>Create and edit views</li> <li>Configure charts overview</li> <li>Dashboards overview</li> <li>Use interactive streams and tiles</li> </ul> <h3>28 - Get started with Power Apps canvas apps</h3> <ul> <li>Power Apps building blocks</li> <li>Ways to build Power Apps</li> <li>Power Apps related technologies</li> <li>Additional Power Apps related technologies</li> <li>Designing a Power Apps app</li> </ul> <h3>29 - Connect to other data in a Power Apps canvas app</h3> <ul> <li>Overview of the different data sources</li> <li>Work with action-based data sources</li> <li>Power Automate is a companion to Power Apps</li> </ul> <h3>30 - How to build the UI in a canvas app in Power Apps</h3> <ul> <li>Use themes to quickly change the appearance of your app</li> <li>Branding a control</li> <li>Icons</li> <li>Images</li> <li>Personalization</li> <li>Using the tablet or phone form factors</li> </ul> <h3>31 - Manage apps in Power Apps</h3> <ul> <li>Power Apps review</li> </ul> <h3>32 - Build your first app with Power Apps and Dataverse for Teams</h3> <ul> <li>Create your first app with the hero template</li> <li>Customize your app with Power Apps Studio</li> <li>Publish your app</li> <li>Install template apps</li> </ul> <h3>33 - Access Dataverse in Power Pages websites</h3> <ul> <li>Use lists to display multiple Dataverse records</li> <li>Use forms to interact with Dataverse data</li> </ul> <h3>34 - Authentication and user management in Power Pages</h3> <ul> <li>Power Pages authentication settings</li> <li>User registration in Power Pages</li> <li>Authentication management for Power Pages users</li> <li>Power Pages authentication providers</li> </ul> <h3>35 - Power Pages maintenance and troubleshooting</h3> <ul> <li>Power Pages website maintenance</li> <li>Power Pages website troubleshooting</li> </ul> <h3>36 - Define and create business rules in Dataverse</h3> <ul> <li>Define business rules - Introduction</li> <li>Define the components of a business rule</li> <li>Create a business rule</li> </ul> <h3>37 - Get started with Power Automate</h3> <ul> <li>Introducing Power Automate</li> <li>Troubleshoot flows</li> </ul> <h3>38 - Use the Admin center to manage environments and data policies in Power Automate</h3> <ul> <li>Administer flows</li> <li>Export and import flows</li> <li>Learn how to distribute button flows</li> </ul> <h3>39 - Use Dataverse triggers and actions in Power Automate</h3> <ul> <li>Dataverse triggers</li> <li>Query data</li> <li>Create, update, delete, and relate actions</li> </ul> <h3>40 - Extend Dataverse with Power Automate</h3> <ul> <li>Set up a flow and configure its trigger</li> <li>Email Dataverse record</li> <li>Add to-do items</li> <li>Test and run your flow</li> </ul> <h3>41 - Introduction to expressions in Power Automate</h3> <ul> <li>Get started with expressions</li> <li>Notes make things easier</li> <li>Types of functions</li> <li>Write complex expressions</li> </ul> <h3>42 - Build your first Power Automate for desktop flow</h3> <ul> <li>Set up the environment</li> <li>Explore Power Automate for desktop</li> <li>Create your first Power Automate for desktop flow</li> <li>Record Power Automate for desktop actions</li> <li>Edit and test recorded actions</li> </ul> <h3>43 - Run a Power Automate for desktop flow in unattended mode</h3> <ul> <li>Set up an unattended desktop flow</li> <li>Create a new cloud flow that calls an existing flow in unattended mode</li> <li>Perform a test run</li> <li>Best practices</li> </ul> <h3>44 - Optimize your business process with process advisor</h3> <ul> <li>Get familiar with process advisor</li> <li>Create your first recording</li> <li>Edit recordings and group actions</li> <li>Analyze recordings and interpret results</li> <li>Automation recommendations</li> </ul> <h3>45 - Get started with Microsoft Copilot Studio bots</h3> <ul> <li>Get started working with environments</li> <li>Create bots and work with the Microsoft Copilot Studio interface</li> <li>Create topics</li> <li>Test bots</li> <li>Publish bots and analyze performance</li> </ul> <h3>46 - Enhance Microsoft Copilot Studio bots</h3> <ul> <li>Use Power Automate to add actions</li> <li>Transfer conversations to agents by using Omnichannel for Customer Service</li> <li>Create topics for existing support content</li> <li>Analyze bot performance</li> </ul> <h3>47 - Manage topics in Microsoft Copilot Studio</h3> <ul> <li>Work with bot topics</li> <li>Branch a topic</li> <li>Create topics for existing support content</li> <li>Work with system fallback topics</li> <li>Manage topics</li> </ul> <h3>48 - Manage Power Virtual Agents</h3> <ul> <li>Environments in Microsoft Copilot Studio</li> <li>Bot topics permissions</li> <li>Bot entities and flow permissions</li> <li>Monitor and diagnose</li> <li>Administer and manage</li> <li>Export and import bots</li> <li>Authentication</li> </ul> <h3>49 - Get started building with Power BI</h3> <ul> <li>Use Power BI</li> <li>Building blocks of Power BI</li> <li>Tour and use the Power BI service</li> </ul> <h3>50 - Get data with Power BI Desktop</h3> <ul> <li>Overview of Power BI Desktop</li> <li>Explore Power BI Desktop</li> <li>Connect to data sources</li> <li>Get data from Excel</li> <li>Transform data to include in a report</li> <li>Combine data from multiple sources</li> <li>Clean data to include in a report</li> </ul> <h3>51 - Model data in Power BI</h3> <ul> <li>How to manage your data relationships</li> <li>Create calculated columns</li> <li>Optimize data models</li> <li>Create measures</li> <li>Create calculated tables</li> <li>Explore time-based data</li> </ul> <h3>52 - Use visuals in Power BI</h3> <ul> <li>Create and customize simple visualizations</li> <li>Create slicers</li> <li>Map visualizations</li> <li>Matrices and tables</li> <li>Create scatter, waterfall, and funnel charts</li> <li>Modify colors in charts and visuals</li> <li>Page layout and formatting</li> </ul> <h3>53 - Explore data in Power BI</h3> <ul> <li>Quick insights in Power BI</li> <li>Create and configure a dashboard</li> <li>Ask questions of your data with natural language</li> <li>Create custom Q&amp;A suggestions</li> <li>Share dashboards with your organization</li> <li>Display visuals and tiles in full screen</li> <li>Edit tile details and add widgets</li> <li>Get more space on your dashboard</li> </ul> <h3>54 - Publish and share in Power BI</h3> <ul> <li>Publish Power BI Desktop reports</li> <li>Print and export dashboards and reports</li> <li>Introducing Power BI Mobile</li> <li>Create workspaces in Power BI</li> <li>Build apps</li> <li>Use apps</li> <li>Integrate OneDrive for Business with Power BI</li> <li>Publish to web</li> </ul> <h3>55 - Manage solutions in Power Apps and Power Automate</h3> <ul> <li>Add and remove apps, flows, and entities in a solution</li> <li>Edit a solution-aware app, flow, and table</li> <li>Build and deploy a complex solution with flows, apps, and entities</li> <li>Automate solution management</li> </ul> <h3>56 - Load/export data and create data views in Dataverse</h3> <ul> <li>View data in a table</li> <li>Create or edit views of data in a table</li> <li>Load data into a table</li> <li>Export data from a table</li> <li>Add, update, or delete data in a table by using Excel</li> <li>Import data using Power Query</li> <li>Generate a new dataflow from an Excel Template</li> <li>Dataflow and Azure integration</li> </ul> <h3>57 - Get started with AI Builder</h3> <ul> <li>Choose an AI capability</li> <li>Create your first model</li> <li>Ways to use your models</li> </ul> <h3>58 - Manage models in AI Builder</h3> <ul> <li>Model lifecycle</li> <li>Manage model versions</li> <li>Share your models</li> </ul> <h3>59 - Use AI Builder in Power Automate</h3> <ul> <li>AI Builder in Power Automate saves time</li> <li>Advanced usage of AI Builder in Power Automate</li> </ul> <h3>60 - Functional Consultant skills</h3> <ul> <li>Create entity relationship diagrams</li> <li>Create and document mock-ups</li> <li>Document functional requirements and artifacts</li> <li>Complete fit-gap analysis</li> <li>Discuss stakeholder management responsibilities</li> <li>Understand industry accelerators</li> <li>Define Application Lifecycle Management</li> <li>Participate in testing</li> <li>Evaluate options</li> <li>Define connectors</li> <li>Understand Power Apps component framework</li> </ul> <h3>61 - Solution Architect series: Plan application lifecycle management for Power Platform</h3> <ul> <li>Key considerations for ALM</li> <li>Solutions</li> <li>Configuration and reference data</li> <li>Release process</li> <li>ALM with Azure DevOps</li> </ul></div>

Microsoft Power Apps

Power Apps

Microsoft Power BI

Microsoft Power Platform

PL-200T00 Microsoft Power Platform Functional Consultant

Birmingham

Telford

<p style="color: rgb(0, 0, 0); font-size: var(--font-size); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(0, 0, 0);"><span style="color: rgb(32, 56, 100); box-sizing: border-box;" fr-original-style=" color: rgb(32, 56, 100);">In the US alone, it has been estimated that the cost of unnecessary meetings and wasted time is over $35 billion!</span></p><p style="color: rgb(0, 0, 0); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);"><span style="color: rgb(32, 56, 100); box-sizing: border-box;" fr-original-style=" color: rgb(32, 56, 100);">Many executives feel overwhelmed by meetings, and no wonder: On average, they spend nearly 23 hours a week in them, up from less than 10 hours in the 1960s. Moreover, the meetings are often poorly timed, badly run, or both. Quote from Harvard Revue 2017.&nbsp;</span></p><p style="color: rgb(0, 0, 0); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);"><span style="color: rgb(32, 56, 100); box-sizing: border-box;" fr-original-style=" color: rgb(32, 56, 100);">Our Managing Meetings workshop looks at the common reasons for meetings that give some attendees little or no value. It identifies the efficiency killers and works to understand what causes each issue and what possible solutions we can come up with to discuss and plan to experiment with back in the workplace.&nbsp;</span></p><p style="color: rgb(0, 0, 0); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);"><span style="color: rgb(32, 56, 100); box-sizing: border-box;" fr-original-style=" color: rgb(32, 56, 100);">During the day, we invite every member to play a crucial role, conduct a meeting, and analyse the short meeting. Once we have done this, we collaboratively plan the next version of the meeting and use some of the tools we incorporate into the day to feel the impact and reap the benefits. Your input is invaluable as we do not work in your environment.</span></p><p style="color: rgb(0, 0, 0); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);"><span style="color: rgb(32, 56, 100); box-sizing: border-box;" fr-original-style=" color: rgb(32, 56, 100);">By following the meeting structure and guidelines we provide, you will not only enjoy efficient and effective meetings, but also see a significant boost in productivity and a reduction in unnecessary meeting time. The benefits are real and tangible.</span></p><p style="color: rgb(33, 33, 33); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(33, 33, 33);"><br fr-original-style="" style="box-sizing: border-box;"></p><hr fr-original-style="" style="border-color: var(--border-muted); border-style: solid; clear: both; break-after: page; -webkit-user-select: none; box-sizing: border-box;"><div style="color: rgb(33, 33, 33); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(33, 33, 33);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">LENGTH</strong></div><div style="color: rgb(33, 33, 33); box-sizing: border-box;" fr-original-style=" color: rgb(33, 33, 33);">1 Day</div><div style="color: rgb(33, 33, 33); box-sizing: border-box;" fr-original-style=" color: rgb(33, 33, 33);"><br fr-original-style="" style="box-sizing: border-box;"></div><div style="color: rgb(33, 33, 33); box-sizing: border-box;" fr-original-style=" color: rgb(33, 33, 33);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">NEXT WORKSHOP START</strong></div><div style="color: rgb(33, 33, 33); box-sizing: border-box;" fr-original-style=" color: rgb(33, 33, 33);">Enquire for more information</div><div style="color: rgb(33, 33, 33); box-sizing: border-box;" fr-original-style=" color: rgb(33, 33, 33);"><br fr-original-style="" style="box-sizing: border-box;"></div><div style="color: rgb(33, 33, 33); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(33, 33, 33);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">WORKSHOP DELIVERY</strong></div><div style="color: rgb(33, 33, 33); box-sizing: border-box;" fr-original-style=" color: rgb(33, 33, 33);">The best environment for this workshop is face-to-face, but we can facilitate this workshop online.</div><div style="color: rgb(33, 33, 33); box-sizing: border-box;" fr-original-style=" color: rgb(33, 33, 33);"><br fr-original-style="" style="box-sizing: border-box;"></div><div style="color: rgb(33, 33, 33); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(33, 33, 33);"><hr fr-original-style="" style="border-color: var(--border-muted); border-style: solid; clear: both; break-after: page; -webkit-user-select: none; box-sizing: border-box;"><div style="color: rgb(33, 33, 33); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(33, 33, 33);"><h2 title="Suitability - Who should attend?" style="color: rgb(33, 33, 33); box-sizing: border-box;" fr-original-style=" color: rgb(33, 33, 33);">Suitability - Who should attend?</h2><section fr-original-style="" style="box-sizing: border-box;"><h3 style="color: rgb(33, 33, 33); box-sizing: border-box;" fr-original-style=" color: rgb(33, 33, 33);"><span style="color: rgb(40, 50, 78); box-sizing: border-box;" fr-original-style="color: rgb(40, 50, 78);">Who Should Attend and Why?</span></h3><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="color: rgb(40, 50, 78); box-sizing: border-box;" fr-original-style="color: rgb(40, 50, 78);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Who</strong>? - This is generally for Leaders and Managers so they can pass on the skills and tools to ensure their direct reports learn how to manage an efficient and effective meeting.</span></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="color: rgb(40, 50, 78); box-sizing: border-box;" fr-original-style="color: rgb(40, 50, 78);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Why</strong>? Meetings are expensive. You only have to take a weekly meeting you attend, calculate the time by each person&#39;s hourly pay, and then sit down to recover.</span></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="color: rgb(40, 50, 78); box-sizing: border-box;" fr-original-style="color: rgb(40, 50, 78);">Inefficient meetings waste time and money and frequently annoy people. They can also badly affect their productivity, and then they get told off for not being more productive!</span></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="color: rgb(40, 50, 78); box-sizing: border-box;" fr-original-style="color: rgb(40, 50, 78);">Help your people be more efficient in meetings. Get what&rsquo;s required out of each one and stop the ones that are not required at all.</span></p></section></div><span style="color: rgb(40, 50, 78); box-sizing: border-box;" fr-original-style="color: rgb(40, 50, 78);"><a name="EducationText_TrainingCourseContent" style="color: rgb(21, 101, 192); -webkit-user-select: auto; font-size: var(--font-size); box-sizing: border-box; cursor: pointer; text-decoration: inherit;" fr-original-style=" color: rgb(21, 101, 192);"></a></span><div style="color: rgb(33, 33, 33); box-sizing: border-box;" fr-original-style=" color: rgb(33, 33, 33);"><h2 title="Training Course Content" style="color: rgb(33, 33, 33); box-sizing: border-box;" fr-original-style=" color: rgb(33, 33, 33);"><span style="color: rgb(40, 50, 78); box-sizing: border-box;" fr-original-style="color: rgb(40, 50, 78);">Workshop Content</span></h2><section fr-original-style="" style="box-sizing: border-box;"><ul fr-original-style="" style="box-sizing: border-box;"><li style="color: rgb(40, 50, 78); box-sizing: border-box;" fr-original-style="color: rgb(40, 50, 78);">Why is Emotional Intelligence a key aspect of how we approach meetings?</li><li style="color: rgb(40, 50, 78); box-sizing: border-box;" fr-original-style="color: rgb(40, 50, 78);">What are the main reasons for planning or being invited to a meeting?</li><li style="color: rgb(40, 50, 78); box-sizing: border-box;" fr-original-style="color: rgb(40, 50, 78);">How do we plan the time required for a meeting?</li><li style="color: rgb(40, 50, 78); box-sizing: border-box;" fr-original-style="color: rgb(40, 50, 78);">What do we do in a meeting, and in what order?</li><li style="color: rgb(40, 50, 78); box-sizing: border-box;" fr-original-style="color: rgb(40, 50, 78);">How do we know when someone is talking too much, and what can be done about it?</li><li style="color: rgb(40, 50, 78); box-sizing: border-box;" fr-original-style="color: rgb(40, 50, 78);">How can we make each person&#39;s time at a meeting more efficient?</li><li style="color: rgb(40, 50, 78); box-sizing: border-box;" fr-original-style="color: rgb(40, 50, 78);">How can we ensure all the points from the last meeting were actioned before the next meeting?</li><li style="color: rgb(40, 50, 78); box-sizing: border-box;" fr-original-style="color: rgb(40, 50, 78);">We look at our Meeting Structure and Attendee Roles to help manage future meetings.</li></ul></section></div><span style="color: rgb(40, 50, 78); box-sizing: border-box;" fr-original-style="color: rgb(40, 50, 78);"><a name="EducationText_Coursedeliverydetails" style="color: rgb(21, 101, 192); -webkit-user-select: auto; font-size: var(--font-size); box-sizing: border-box; cursor: pointer; text-decoration: inherit;" fr-original-style=" color: rgb(21, 101, 192);"></a></span><div style="color: rgb(33, 33, 33); box-sizing: border-box;" fr-original-style=" color: rgb(33, 33, 33);"><h2 title="Course delivery details" style="color: rgb(33, 33, 33); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(33, 33, 33);">Workshop delivery and venue</h2><section fr-original-style="" style="box-sizing: border-box;"><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="color: rgb(40, 50, 78); box-sizing: border-box;" fr-original-style="color: rgb(40, 50, 78);">When you consider the content we deliver, we are sure you will understand why we always prefer to deliver our workshops, courses and programmes face-to-face.</span></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="color: rgb(40, 50, 78); box-sizing: border-box;" fr-original-style="color: rgb(40, 50, 78);">Face-to-face workshops and courses can be held at a location of your choice or, if you wish, a central UK location, such as the Macdonald Burlington Hotel in Birmingham, located directly across from the Birmingham New Street train station.</span></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="color: rgb(40, 50, 78); box-sizing: border-box;" fr-original-style="color: rgb(40, 50, 78);">We can deliver our workshops, courses and programmes online, although this will mean splitting elements into manageable learning events to suit the online environment.</span></p></section></div></div>

In the US alone, it has been estimated that the cost of unnecessary meetings and wasted time is over $35 billion!
Many executives feel overwhelmed by meetings, and no wonder: On average, they spend nearly 23 hours a week in them, up from less than 10 hours in the 1960s. Moreover, the meetings are often poorly timed, badly run, or both. Quote from Harvard Revue 2017. 
Our Managing Meetings workshop looks at the common reasons for meetings that give some attendees little or no value. It identifies the efficiency killers and works to understand what causes each issue and what possible solutions we can come up with to discuss and plan to experiment with back in the workplace. 
During the day, we invite every member to play a crucial role, conduct a meeting, and analyse the short meeting. Once we have done this, we collaboratively plan the next version of the meeting and use some of the tools we incorporate into the day to feel the impact and reap the benefits. Your input is invaluable as we do not work in your environment.
By following the meeting structure and guidelines we provide, you will not only enjoy efficient and effective meetings, but also see a significant boost in productivity and a reduction in unnecessary meeting time. The benefits are real and tangible.





LENGTH - Normally one day. But please get in touch with us to discuss your specific needs, or we can offer advice.  
NEXT WORKSHOP START - Please ask for more information as we deliver bespoke closed events for your people at your location or a mutually suitable location.
WORKSHOP DELIVERY - The best environment for this workshop is face-to-face, but we can facilitate this workshop online.



Suitability - Who should attend?
Who Should Attend and Why?
Who? - This is generally for Leaders and Managers so they can pass on the skills and tools to ensure their direct reports learn how to manage an efficient and effective meeting.
Why? Meetings are expensive. You only have to take a weekly meeting you attend, calculate the time by each person's hourly pay, and then sit down to recover.
Inefficient meetings waste time and money and frequently annoy people. They can also badly affect their productivity, and then they get told off for not being more productive!
Help your people be more efficient in meetings. Get what’s required out of each one and stop the ones that are not required at all.
Workshop Content
Why is Emotional Intelligence a key aspect of how we approach meetings?
What are the main reasons for planning or being invited to a meeting?
How do we plan the time required for a meeting?
What do we do in a meeting, and in what order?
How do we know when someone is talking too much, and what can be done about it?
How can we make each person's time at a meeting more efficient?
How can we ensure all the points from the last meeting were actioned before the next meeting?
We look at our Meeting Structure and Attendee Roles to help manage future meetings.
Workshop delivery and venue
When you consider the content we deliver, we are sure you will understand why we always prefer to deliver our workshops, courses and programmes face-to-face.
Face-to-face workshops and courses can be held at a location of your choice or, if you wish, a central UK location, such as the Macdonald Burlington Hotel in Birmingham, located directly across from the Birmingham New Street train station.
We can deliver our workshops, courses and programmes online, although this will mean splitting elements into manageable learning events to suit the online environment.

Lapd Solutions Ltd

Managing meetings, Meeting Management, Efficient Meetings, Moccasin Approach, Moccasin Manager, 

Managing Meetings

Introductory daily rate.

Registered charities and non profits only.

Non profits only.

<p id="isPasted" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Our <strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Mastering Microsoft Office: Word, Excel, PowerPoint, and 365</strong> course provides an in-depth exploration of Excel 2021, starting with the basics of creating spreadsheets, entering data, and understanding relative references. Progress to more advanced topics like data handling, page setup, sorting, filtering, and writing sophisticated formulas, including VLOOKUP, HLOOKUP, and the 2021 exclusive XLOOKUP. Learn to create compelling charts and pivot tables that bring your data to life.</p><p style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;" id="isPasted" fr-original-style=" color: var(--text);">In PowerPoint 2021, start with presentation basics and advance to incorporating graphic assets, multimedia, and SmartArt graphics. Master text formatting, bullet options, and table and chart integration to create professional and engaging presentations. Explore the full suite of PowerPoint features, including transitions, animations, and slideshow effects, to captivate your audience.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">The Word 2021 modules guide you through document creation, formatting, and layout management. Learn to work with tables, styles, and mail merges. Additionally, discover the collaboration and productivity features of Office 365, which enable seamless sharing and editing across platforms.</p><p id="isPasted" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Learning Outcomes of Mastering Microsoft Office: Word, Excel, PowerPoint, and 365 Course:</strong></p><ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">Master the fundamentals of Excel 2021, including entering data and working with ranges.</li><li fr-original-style="" style="box-sizing: border-box;">Create and modify Excel charts and pivot tables for data analysis.</li><li fr-original-style="" style="box-sizing: border-box;">Develop PowerPoint presentations with advanced animations and multimedia elements.</li><li fr-original-style="" style="box-sizing: border-box;">Format documents in Word 2021, including creating tables and managing styles.</li><li fr-original-style="" style="box-sizing: border-box;">Execute mail merges and manage page layouts effectively in Word 2021.</li><li fr-original-style="" style="box-sizing: border-box;">Utilise Office 365 features for enhanced productivity and collaboration.</li><li fr-original-style="" style="box-sizing: border-box;">Understand and apply advanced Excel formulas like VLOOKUP, HLOOKUP, and XLOOKUP.</li></ul><p id="isPasted" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">The Course Curriculum of&nbsp;Mastering Microsoft Office: Word, Excel, PowerPoint, and 365:</strong></p><ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">Section 01: Getting Started</li><li fr-original-style="" style="box-sizing: border-box;">Section 02: Excel 2021: Basics</li><li fr-original-style="" style="box-sizing: border-box;">Section 03: Excel 2021: Rows, Columns, And Cells</li><li fr-original-style="" style="box-sizing: border-box;">Section 04: Excel 2021: Data Handling</li><li fr-original-style="" style="box-sizing: border-box;">Section 05: Excel 2021: Page Setting Up And Print</li><li fr-original-style="" style="box-sizing: border-box;">Section 06: Excel 2021: Sorting And Filtering</li><li fr-original-style="" style="box-sizing: border-box;">Section 07: Excel 2021: Writing Formulas</li><li fr-original-style="" style="box-sizing: border-box;">Section 08: Excel 2021: Advanced Formulas</li><li fr-original-style="" style="box-sizing: border-box;">Section 09: Excel 2021: XLOOKUP Only For 2021 And Office 365</li><li fr-original-style="" style="box-sizing: border-box;">Section 10: Excel 2021: Data And Tools</li><li fr-original-style="" style="box-sizing: border-box;">Section 11: Excel 2021: Formatting Data And Tables</li><li fr-original-style="" style="box-sizing: border-box;">Section 12: Excel 2021: Pivot Tables</li><li fr-original-style="" style="box-sizing: border-box;">Section 13: Excel 2021: Charts</li><li fr-original-style="" style="box-sizing: border-box;">Section 14: PowerPoint 2021: Course Introduction</li><li fr-original-style="" style="box-sizing: border-box;">Section 15: PowerPoint 2021: Basics</li><li fr-original-style="" style="box-sizing: border-box;">Section 16: PowerPoint 2021: Text And Bullet Options</li><li fr-original-style="" style="box-sizing: border-box;">Section 17: PowerPoint 2021: Adding Graphic Assets</li><li fr-original-style="" style="box-sizing: border-box;">Section 18: PowerPoint 2021: Picture Formatting</li><li fr-original-style="" style="box-sizing: border-box;">Section 19: PowerPoint 2021: SmartArt Graphics</li><li fr-original-style="" style="box-sizing: border-box;">Section 20: PowerPoint 2021: Working With Tables</li><li fr-original-style="" style="box-sizing: border-box;">Section 21: PowerPoint 2021: Working With Charts</li><li fr-original-style="" style="box-sizing: border-box;">Section 22: PowerPoint 2021: Adding Multimedia</li><li fr-original-style="" style="box-sizing: border-box;">Section 23: PowerPoint 2021: Working With Transition</li><li fr-original-style="" style="box-sizing: border-box;">Section 24: PowerPoint 2021: Animation</li><li fr-original-style="" style="box-sizing: border-box;">Section 25: PowerPoint 2021: Slideshow Effects</li><li fr-original-style="" style="box-sizing: border-box;">Section 26: Word 2021: Introduction</li><li fr-original-style="" style="box-sizing: border-box;">Section 27: Word 2021: Basics</li><li fr-original-style="" style="box-sizing: border-box;">Section 28: Word 2021: Word Formatting</li><li fr-original-style="" style="box-sizing: border-box;">Section 29: Word 2021: Tables</li><li fr-original-style="" style="box-sizing: border-box;">Section 30: Word 2021: Styles</li><li fr-original-style="" style="box-sizing: border-box;">Section 31: Word 2021: Page Layout</li><li fr-original-style="" style="box-sizing: border-box;">Section 32: Word 2021: Envelops And Lables</li><li fr-original-style="" style="box-sizing: border-box;">Section 33: Word 2021: Mail Merges</li><li fr-original-style="" style="box-sizing: border-box;">Section 34: Word 2021: Review And Printing</li></ul><p id="isPasted" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Who is this course for:</strong></p><ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">Professionals seeking to enhance their productivity with Microsoft Office tools.</li><li fr-original-style="" style="box-sizing: border-box;">Students aiming to improve their technical skills for academic purposes.</li><li fr-original-style="" style="box-sizing: border-box;">Administrative staff needing comprehensive knowledge of Office applications.</li><li fr-original-style="" style="box-sizing: border-box;">Individuals looking to advance their careers with proficiency in Word, Excel, and PowerPoint.</li></ul><p id="isPasted" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Certification of Mastering Microsoft Office: Word, Excel, PowerPoint, and 365 Course:<br fr-original-style="" style="box-sizing: border-box;"></strong></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><a href="https://cpdqs.co.uk/" target="_blank" rel="noopener noreferrer" fr-original-style="" style="user-select: auto; font-size: var(--font-size); box-sizing: border-box; cursor: pointer; text-decoration: inherit;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">CPD QS</strong></a> certificates are available at an additional cost of &pound;9.99 for a PDF, &pound;16.99 for a printed hard copy, and &pound;24.99 for both PDF and printed versions.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Requirements:</strong></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">This course has no academic entry requirements and is accessible to students from all backgrounds.</p><p id="isPasted" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Career Path:</strong></p><ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Administrative Assistant:</strong> &pound;18,000 - &pound;25,000 per annum</li><li fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Data Analyst:</strong> &pound;25,000 - &pound;40,000 per annum</li><li fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Office Manager:</strong> &pound;22,000 - &pound;35,000 per annum</li><li fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Project Coordinator:</strong> &pound;23,000 - &pound;37,000 per annum</li><li fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Executive Assistant:</strong> &pound;25,000 - &pound;45,000 per annum</li><li fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">IT Support Specialist:</strong> &pound;22,000 - &pound;38,000 per annum</li></ul><p id="isPasted" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><em fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Enrol now and advance your Microsoft Office skills to a professional level.</strong></em></p>

Our Mastering Microsoft Office: Word, Excel, PowerPoint, and 365 course provides an in-depth exploration of Excel 2021, starting with the basics of creating spreadsheets, entering data, and understanding relative references. Progress to more advanced topics like data handling, page setup, sorting, filtering, and writing sophisticated formulas, including VLOOKUP, HLOOKUP, and the 2021 exclusive XLOOKUP. Learn to create compelling charts and pivot tables that bring your data to life.
In PowerPoint 2021, start with presentation basics and advance to incorporating graphic assets, multimedia, and SmartArt graphics. Master text formatting, bullet options, and table and chart integration to create professional and engaging presentations. Explore the full suite of PowerPoint features, including transitions, animations, and slideshow effects, to captivate your audience.
The Word 2021 modules guide you through document creation, formatting, and layout management. Learn to work with tables, styles, and mail merges. Additionally, discover the collaboration and productivity features of Office 365, which enable seamless sharing and editing across platforms.
Learning Outcomes of Mastering Microsoft Office: Word, Excel, PowerPoint, and 365 Course:
Master the fundamentals of Excel 2021, including entering data and working with ranges.
Create and modify Excel charts and pivot tables for data analysis.
Develop PowerPoint presentations with advanced animations and multimedia elements.
Format documents in Word 2021, including creating tables and managing styles.
Execute mail merges and manage page layouts effectively in Word 2021.
Utilise Office 365 features for enhanced productivity and collaboration.
Understand and apply advanced Excel formulas like VLOOKUP, HLOOKUP, and XLOOKUP.
The Course Curriculum of Mastering Microsoft Office: Word, Excel, PowerPoint, and 365:
Section 01: Getting Started
Section 02: Excel 2021: Basics
Section 03: Excel 2021: Rows, Columns, And Cells
Section 04: Excel 2021: Data Handling
Section 05: Excel 2021: Page Setting Up And Print
Section 06: Excel 2021: Sorting And Filtering
Section 07: Excel 2021: Writing Formulas
Section 08: Excel 2021: Advanced Formulas
Section 09: Excel 2021: XLOOKUP Only For 2021 And Office 365
Section 10: Excel 2021: Data And Tools
Section 11: Excel 2021: Formatting Data And Tables
Section 12: Excel 2021: Pivot Tables
Section 13: Excel 2021: Charts
Section 14: PowerPoint 2021: Course Introduction
Section 15: PowerPoint 2021: Basics
Section 16: PowerPoint 2021: Text And Bullet Options
Section 17: PowerPoint 2021: Adding Graphic Assets
Section 18: PowerPoint 2021: Picture Formatting
Section 19: PowerPoint 2021: SmartArt Graphics
Section 20: PowerPoint 2021: Working With Tables
Section 21: PowerPoint 2021: Working With Charts
Section 22: PowerPoint 2021: Adding Multimedia
Section 23: PowerPoint 2021: Working With Transition
Section 24: PowerPoint 2021: Animation
Section 25: PowerPoint 2021: Slideshow Effects
Section 26: Word 2021: Introduction
Section 27: Word 2021: Basics
Section 28: Word 2021: Word Formatting
Section 29: Word 2021: Tables
Section 30: Word 2021: Styles
Section 31: Word 2021: Page Layout
Section 32: Word 2021: Envelops And Lables
Section 33: Word 2021: Mail Merges
Section 34: Word 2021: Review And Printing
Who is this course for:
Professionals seeking to enhance their productivity with Microsoft Office tools.
Students aiming to improve their technical skills for academic purposes.
Administrative staff needing comprehensive knowledge of Office applications.
Individuals looking to advance their careers with proficiency in Word, Excel, and PowerPoint.
Certification of Mastering Microsoft Office: Word, Excel, PowerPoint, and 365 Course:
CPD QS Accredited PDF Certificate - Included
CPD QS Accredited Hard Copy Certificate - Not Included
Requirements:
This course has no academic entry requirements and is accessible to students from all backgrounds.
Career Path:
Administrative Assistant: £18,000 - £25,000 per annum
Data Analyst: £25,000 - £40,000 per annum
Office Manager: £22,000 - £35,000 per annum
Project Coordinator: £23,000 - £37,000 per annum
Executive Assistant: £25,000 - £45,000 per annum
IT Support Specialist: £22,000 - £38,000 per annum
Enrol now and advance your Microsoft Office skills to a professional level.

St. Paul's College

Microsoft 365

Microsoft Excel

Microsoft Office

Microsoft Powerpoint

Microsoft Word

Start your productivity potential! Master Microsoft Office with our comprehensive Mastering Microsoft Office: Word, Excel, PowerPoint, and 365 course. Conquer Excel formulas (VLOOKUP, HLOOKUP, XLOOKUP!), design impactful presentations in PowerPoint, and craft professional documents in Word. Take your skills to the next level and unlock a world of opportunity. Enrol now and become a Microsoft Office pro!

Mastering Microsoft Office: Word, Excel, PowerPoint, and 365

<div id="course-pills-1">Duration<p>3 Days</p><p>18 CPD hours</p>This course is intended for<p></p><p>This course is for Network Engineers looking to specialize in Azure networking solutions. An Azure Network engineer designs and implements core Azure networking infrastructure, hybrid networking connections, load balance traffic, network routing, private access to Azure services, network security and monitoring. The azure network engineer will manage networking solutions for optimal performance, resiliency, scale, and security.</p><p></p><p></p><p>This course teaches Network Engineers how to design, implement, and maintain Azure networking solutions. This course covers the process of designing, implementing, and managing core Azure networking infrastructure, Hybrid Networking connections, load balancing traffic, network routing, private access to Azure services, network security and monitoring. Learn how to design and implement a secure, reliable, network infrastructure in Azure and how to establish hybrid connectivity, routing, private access to Azure services, and monitoring in Azure.</p><p></p>Prerequisites<p>Prerequisite courses (or equivalent knowledge and hands-on experience):  </p><li>AZ-104T00 - Microsoft Azure Administrator<p></p></li></div><div id="course-pills-2"><h3>1 - Introduction to Azure Virtual Networks</h3> <ul> <li>Explore Azure Virtual Networks</li> <li>Configure public IP services</li> <li>Design name resolution for your virtual network</li> <li>Enable cross-virtual network connectivity with peering</li> <li>Implement virtual network traffic routing</li> <li>Configure internet access with Azure Virtual NAT</li> </ul> <h3>2 - Design and implement hybrid networking</h3> <ul> <li>Design and implement Azure VPN Gateway</li> <li>Connect networks with Site-to-site VPN connections</li> <li>Connect devices to networks with Point-to-site VPN connections</li> <li>Connect remote resources by using Azure Virtual WANs</li> <li>Create a network virtual appliance (NVA) in a virtual hub</li> </ul> <h3>3 - Design and implement Azure ExpressRoute</h3> <ul> <li>Explore Azure ExpressRoute</li> <li>Design an ExpressRoute deployment</li> <li>Configure peering for an ExpressRoute deployment</li> <li>Connect an ExpressRoute circuit to a virtual network</li> <li>Connect geographically dispersed networks with ExpressRoute global reach</li> <li>Improve data path performance between networks with ExpressRoute FastPath</li> <li>Troubleshoot ExpressRoute connection issues</li> </ul> <h3>4 - Load balance non-HTTP(S) traffic in Azure</h3> <ul> <li>Explore load balancing</li> <li>Design and implement Azure load balancer using the Azure portal</li> <li>Explore Azure Traffic Manager</li> </ul> <h3>5 - Load balance HTTP(S) traffic in Azure</h3> <ul> <li>Design Azure Application Gateway</li> <li>Configure Azure Application Gateway</li> <li>Design and configure Azure Front Door</li> </ul> <h3>6 - Design and implement network security</h3> <ul> <li>Get network security recommendations with Microsoft Defender for Cloud</li> <li>Deploy Azure DDoS Protection by using the Azure portal</li> <li>Deploy Network Security Groups by using the Azure portal</li> <li>Design and implement Azure Firewall</li> <li>Secure your networks with Azure Firewall Manager</li> <li>Implement a Web Application Firewall on Azure Front Door</li> </ul> <h3>7 - Design and implement private access to Azure Services</h3> <ul> <li>Explain virtual network service endpoints</li> <li>Define Private Link Service and private endpoint</li> <li>Integrate private endpoint with DNS</li> <li>Integrate your App Service with Azure virtual networks</li> </ul> <h3>8 - Design and implement network monitoring</h3> <ul> <li>Monitor your networks using Azure monitor</li> <li>Monitor your networks using Azure network watcher</li> </ul></div>

Network Engineer

Microsoft Azure

AZ-700T00 Designing and Implementing Microsoft Azure Networking Solutions

<div id="course-pills-1">Duration<p>1 Days</p><p>6 CPD hours</p>This course is intended for<p>his course is designed to provide a preview of Red Hat Enterprise Linux 8 to experienced IT professionals, including: Linux system administrators, DevOps engineers, and Cloud administrators.</p>Overview<p>In this course, you will use the Microsoft 365 productivity apps to work collaboratively with others. You will:<br />Identify the Microsoft 365 apps.<br />Create a team and conduct online meetings with Microsoft Teams.<br />Create a plan and manage team activities with Planner.<br />Use Forms to create a form and collect responses.<br />Post, organize, and view videos in Stream.<br />Use Sway to create digital stories and content.<br />Automate your workflow by connecting apps with Power Automate.</p><p>This course builds on your foundational knowledge of the MicrosoftÂ© 365 core apps and takes a deeper look at some of the productivity apps beyond Microsoft Word, ExcelÂ©, and PowerPointÂ©. Knowing that productivity often begins with assembling the right people, this course starts with the TeamsÂ© app that is used to collaborate on shared files and conduct online meetings. The connection between Planner and Teams is established to keep the group's work on schedule. The Forms app is introduced as a tool for collecting information that can be used to help determine your next course of action. The apps designed to handle media assets are introduced: Stream to manage video resources and SwayÂ© to create digital stories. Finally, the power of automating your work processes is introduced in Power Automate, with students using the built-in templates as a starting point. For those interested in the Power BIÂ© and Power AppsÂ© features, a brief overview of these apps is included in an appendix.</p></div><div id="course-pills-2"><h4>Overview of the Office 365 Apps</h4><ul><li>Navigate in Office 365</li><li>Identify How the Office 365 Apps Work Together</li></ul><h4>Collaborating with Microsoft Teams</h4><ul><li>Navigate the Teams Interface</li><li>Create a Team</li><li>Meet in Microsoft Teams</li></ul><h4>Managing Activities with Planner</h4><ul><li>Navigate the Planner Interface</li><li>Create a Plan</li></ul><h4>Gathering Information with Forms</h4><ul><li>Create a Form</li><li>Share Forms and Collect Responses</li></ul><h4>Managing Video Resources with Stream</h4><ul><li>Navigate the Stream Interface</li><li>Post and Organize Videos in Stream</li></ul><h4>Using Sway to Create Digital Stories</h4><ul><li>Navigate the Sway Interface</li><li>Create a Sway</li></ul><h4>Automating Your Work with Flow</h4><ul><li>Navigate the Flow Interface</li><li>Create and Share a Flow</li></ul></div>

Microsoft Teams

Office Skills & Productivity

Microsoft 365 Office for the Web Productivity Apps v2.0

<p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><b style="color: rgb(38, 38, 38); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(38, 38, 38);">Leaders and managers are unlikely to be effective if they do not understand the theories and practices of motivation. What you believe about people materially affects the way your team reacts to you and your leadership.<br fr-original-style="" style="box-sizing: border-box;">This course focuses on the inherent needs of people and how to improve productivity and motivate a workforce. The level of motivation displayed by a team is a reflection of the skills of the leader.</b></p>

Leaders and managers are unlikely to be effective if they do not understand the theories and practices of motivation. What you believe about people materially affects the way your team reacts to you and your leadership.
This course focuses on the inherent needs of people and how to improve productivity and motivate a workforce. The level of motivation displayed by a team is a reflection of the skills of the leader.

Skillogy International

Employee Engagement

Motivation

Leadership

Leadership Skills

Soft Skills

Management Skills

Motivating People

Course

Complete 5 courses to gain a Certificate from the Chartered Management Institute

Course with CMI Certificate

<p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong id="isPasted" fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Transforming leadership is about leaders having a transforming approach to their work and lives. They operate from a set of core beliefs about people that when displayed and operated upon, motivate them to perform effectively and contribute to the development of the organisation. This transforming approach simultaneously impacts the personal development and corporate productivity of all involved. This course explores seven key areas to help you become more effective as a leader.</strong></p>

Transforming leadership is about leaders having a transforming approach to their work and lives. They operate from a set of core beliefs about people that when displayed and operated upon, motivate them to perform effectively and contribute to the development of the organisation. This transforming approach simultaneously impacts the personal development and corporate productivity of all involved. This course explores seven key areas to help you become more effective as a leader.

Global Leadership

Sustainable Leadership

Personal Transformation

Leadership Development

Interpersonal Skills

Transforming Leadership

<div id="course-pills-1">Duration<p>5 Days</p><p>30 CPD hours</p>This course is intended for<p>This course is intended for anyone who is new to software development and wants, or needs, to gain an understanding of programming fundamentals and object-oriented programming concepts. They will typically be high school students, post-secondary school students, or career changers, with no prior programming experience. They might want to gain an understanding of the core programming fundamentals before moving on to more advanced courses such as Programming in C#.</p>Overview<p>Explain core programming fundamentals such as computer storage and processing. Explain computer number systems such as binary. Create and use variables and constants in programs. Explain how to create and use functions in a program. Create and use decisions structures in a computer program. Create and use repetition (loops) in a computer program. Explain pseudocode and its role in programming. Explain the basic computer data structures such as arrays, lists, stacks, and queues. Implement object-oriented programming concepts. Create and use classes in a computer program. Implement encapsulation, inheritance, and polymorphism. Describe the base class library (BCL) in the .NET Framework. Explain the application security concepts. Implement simple I/O in a computer program. Identify application errors and explain how to debug an application and handle errors. Identify the performance considerations for applications.</p><p>In this 5-day course, students will learn the basics of computer programming through the use of Microsoft Visual Studio 2022 and the Visual C# and Visual Basic programming languages. The course assumes no prior programming experience and introduces the concepts needed to progress to the intermediate courses on programming, Programming in C#.<br /><br /> The focus will be on core programming concepts such as computer storage, data types, decision structures, and repetition by using loops. The course also covers an introduction to object-oriented programming covering classes, encapsulation, inheritance, and polymorphism. Coverage is also included around exception handling, application security, performance, and memory management.</p></div><div id="course-pills-2"><h3>1 - Introduction to Core Programming Concepts</h3> <ul> <li>Computer Data Storage and Processing</li> <li>Application Types</li> <li>Application Lifecycle</li> <li>Code Compilation</li> </ul> <h3>2 - Core Programming Language Concepts</h3> <ul> <li>Syntax</li> <li>Data Types</li> <li>Variables and Constants</li> </ul> <h3>3 - Program Flow</h3> <ul> <li>Introduction to Structured Programming Concepts</li> <li>Introduction to Branching</li> <li>Using Functions</li> <li>Using Decision Structures</li> <li>Introducing Repetition</li> </ul> <h3>4 - Algorithms and Data Structures</h3> <ul> <li>Understand How to Write Pseudocode</li> <li>Algorithm Examples</li> <li>Introduction to Data Structures</li> </ul> <h3>5 - Error Handling and Debugging</h3> <ul> <li>Introduction to Program Errors</li> <li>Introduction to Structured Error Handling</li> <li>Introduction to Debugging</li> </ul> <h3>6 - Introduction to Object-Oriented Programming</h3> <ul> <li>Introduction to Complex Structures</li> <li>Introduction to Structs</li> <li>Introduction to Classes</li> <li>Introducing Encapsulation</li> </ul> <h3>7 - More Object-Oriented Programming</h3> <ul> <li>Introduction to Inheritance</li> <li>Introduction to Polymorphism</li> <li>Introduction to .NET and the Base Class Library</li> </ul> <h3>8 - Introduction to Application Security</h3> <ul> <li>Authentication and Authorization</li> <li>Code Permissions on Computers</li> <li>Introducing Code Signing</li> </ul> <h3>9 - Core I/O Programming</h3> <ul> <li>Using Console I/O</li> <li>Using File I/O</li> </ul> <h3>10 - Application Performance and Memory Management</h3> <ul> <li>Value Types vs Reference Types</li> <li>Converting Types</li> <li>The Garbage Collector</li> </ul></div><div id="course-pills-3"><h4>Additional course details:</h4><br /><p>Nexus Humans 55337 Introduction to Programming training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. </p><p></p> This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. <p></p>Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success.  <p></p>While we feel this is the best course for the 55337 Introduction to Programming course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you.  <p></p>Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.<p></p></div>

Online Course Creation

Computing Skills

Programming Fundamentals

Computer Programming

Core Skills Training Framework (CSTF)

Trainers Course

55337 Introduction to Programming

<div id="course-pills-1">Duration<p>5 Days</p><p>30 CPD hours</p>This course is intended for<p></p><p>The Microsoft 365 Endpoint Administrator is responsible for deploying, configuring, securing, managing, and monitoring devices and client applications in a corporate setting. Their duties include managing identity, access, policies, updates, and apps. They work alongside the M365 Enterprise Administrator to develop and execute a device strategy that aligns with the requirements of a modern organization. Microsoft 365 Endpoint Administrators should be well-versed in M365 workloads and possess extensive skills and experience in deploying, configuring, and maintaining Windows 11 and later, as well as non-Windows devices. Their role emphasizes cloud services over on-premises management technologies.</p><p></p><p></p><p>In this course, students will learn to plan and execute an endpoint deployment strategy using contemporary deployment techniques and implementing update strategies. The course introduces essential elements of modern management, co-management approaches, and Microsoft Intune integration. It covers app deployment, management of browser-based applications, and key security concepts such as authentication, identities, access, and compliance policies. Technologies like Microsoft Entra ID, Azure Information Protection, and Microsoft Defender for Endpoint are explored to protect devices and data.</p><p></p>Prerequisites<p>The Modern Desktop Administrator must be familiar with M365 workloads and must have strong skills and experience of deploying, configuring, and maintaining Windows 11 and later, and non-Windows devices.</p></div><div id="course-pills-2"><h3>1 - Explore the Enterprise Desktop</h3> <ul> <li>Examine benefits of modern management</li> <li>Examine the enterprise desktop life-cycle model</li> <li>Examine planning and purchasing</li> <li>Examine desktop deployment</li> <li>Plan an application deployment</li> <li>Plan for upgrades and retirement</li> </ul> <h3>2 - Explore Windows Editions</h3> <ul> <li>Examine Windows client editions and capabilities</li> <li>Select client edition</li> <li>Examine hardware requirements</li> </ul> <h3>3 - Understand Microsoft Entra ID</h3> <ul> <li>Examine Microsoft Entra ID</li> <li>Compare Microsoft Entra ID and Active Directory Domain Services</li> <li>Examine Microsoft Entra ID as a directory service for cloud apps</li> <li>Compare Microsoft Entra ID P1 and P2 plans</li> <li>Examine Microsoft Entra Domain Services</li> </ul> <h3>4 - Manage Microsoft Entra identities</h3> <ul> <li>Examine RBAC and user roles in Microsoft Entra ID</li> <li>Create and manage users in Microsoft Entra ID</li> <li>Create and manage groups in Microsoft Entra ID</li> <li>Manage Microsoft Entra objects with PowerShell</li> <li>Synchronize objects from AD DS to Microsoft Entra ID</li> </ul> <h3>5 - Manage device authentication</h3> <ul> <li>Describe Microsoft Entra join </li> <li>Examine Microsoft Entra join prerequisites limitations and benefits</li> <li>Join devices to Microsoft Entra ID</li> <li>Manage devices joined to Microsoft Entra ID</li> </ul> <h3>6 - Enroll devices using Microsoft Configuration Manager</h3> <ul> <li>Deploy the Microsoft Configuration Manager client</li> <li>Monitor the Microsoft Configuration Manager client</li> <li>Manage the Microsoft Configuration Manager client</li> </ul> <h3>7 - Enroll devices using Microsoft Intune</h3> <ul> <li>Manage mobile devices with Intune</li> <li>Enable mobile device management</li> <li>Explain considerations for device enrollment</li> <li>Manage corporate enrollment policy</li> <li>Enroll Windows devices in Intune</li> <li>Enroll Android devices in Intune</li> <li>Enroll iOS devices in Intune</li> <li>Explore device enrollment manager</li> <li>Monitor device enrollment</li> <li>Manage devices remotely</li> </ul> <h3>8 - Execute device profiles</h3> <ul> <li>Explore Intune device profiles</li> <li>Create device profiles</li> <li>Create a custom device profile</li> </ul> <h3>9 - Oversee device profiles</h3> <ul> <li>Monitor device profiles in Intune</li> <li>Manage device sync in Intune</li> <li>Manage devices in Intune using scripts</li> </ul> <h3>10 - Maintain user profiles</h3> <ul> <li>Examine user profile</li> <li>Explore user profile types</li> <li>Examine options for minimizing user profile size</li> <li>Deploy and configure folder redirection</li> <li>Sync user state with Enterprise State Roaming</li> <li>Configure Enterprise State Roaming in Azure</li> </ul> <h3>11 - Execute mobile application management</h3> <ul> <li>Examine mobile application management</li> <li>Examine considerations for mobile application management</li> <li>Prepare line-of-business apps for app protection policies</li> <li>Implement mobile application management policies in Intune</li> <li>Manage mobile application management policies in Intune</li> </ul> <h3>12 - Deploy and update applications</h3> <ul> <li>Deploy applications with Intune</li> <li>Add apps to Intune</li> <li>Manage Win32 apps with Intune</li> <li>Deploy applications with Configuration Manager</li> <li>Deploying applications with Group Policy</li> <li>Assign and publish software</li> <li>Explore Microsoft Store for Business</li> <li>Implement Microsoft Store Apps</li> <li>Update Microsoft Store Apps with Intune</li> <li>Assign apps to company employees</li> </ul> <h3>13 - Administer endpoint applications</h3> <ul> <li>Manage apps with Intune</li> <li>Manage Apps on non-enrolled devices</li> <li>Deploy Microsoft 365 Apps with Intune</li> <li>Additional Microsoft 365 Apps Deployment Tools</li> <li>Configure Microsoft Edge Internet Explorer mode</li> <li>App Inventory Review</li> </ul> <h3>14 - Protect identities in Microsoft Entra ID</h3> <ul> <li>Explore Windows Hello for Business</li> <li>Deploy Windows Hello</li> <li>Manage Windows Hello for Business</li> <li>Explore Microsoft Entra ID Protection</li> <li>Manage self-service password reset in Microsoft Entra ID</li> <li>Implement multi-factor authentication</li> </ul> <h3>15 - Enable organizational access</h3> <ul> <li>Enable access to organization resources</li> <li>Explore VPN types and configuration</li> <li>Explore Always On VPN</li> <li>Deploy Always On VPN</li> </ul> <h3>16 - Implement device compliance</h3> <ul> <li>Protect access to resources using Intune</li> <li>Explore device compliance policy</li> <li>Deploy a device compliance policy</li> <li>Explore conditional access</li> <li>Create conditional access policies</li> </ul> <h3>17 - Generate inventory and compliance reports</h3> <ul> <li>Report enrolled devices inventory in Intune</li> <li>Monitor and report device compliance</li> <li>Build custom Intune inventory reports</li> <li>Access Intune using Microsoft Graph API</li> </ul> <h3>18 - Deploy device data protection</h3> <ul> <li>Explore Windows Information Protection</li> <li>Plan Windows Information Protection</li> <li>Implement and use Windows Information Protection</li> <li>Explore Encrypting File System in Windows client</li> <li>Explore BitLocker</li> </ul> <h3>19 - Manage Microsoft Defender for Endpoint</h3> <ul> <li>Explore Microsoft Defender for Endpoint</li> <li>Examine key capabilities of Microsoft Defender for Endpoint</li> <li>Explore Windows Defender Application Control and Device Guard</li> <li>Explore Microsoft Defender Application Guard</li> <li>Examine Windows Defender Exploit Guard</li> <li>Explore Windows Defender System Guard</li> </ul> <h3>20 - Manage Microsoft Defender in Windows client</h3> <ul> <li>Explore Windows Security Center</li> <li>Explore Windows Defender Credential Guard</li> <li>Manage Microsoft Defender Antivirus</li> <li>Manage Windows Defender Firewall</li> <li>Explore Windows Defender Firewall with Advanced Security</li> </ul> <h3>21 - Manage Microsoft Defender for Cloud Apps</h3> <ul> <li>Explore Microsoft Defender for Cloud Apps</li> <li>Planning Microsoft Defender for Cloud Apps</li> <li>Implement Microsoft Defender for Cloud Apps</li> </ul> <h3>22 - Assess deployment readiness</h3> <ul> <li>Examine deployment guidelines</li> <li>Explore readiness tools</li> <li>Assess application compatibility</li> <li>Explore tools for application compatibility mitigation</li> <li>Prepare network and directory for deployment</li> <li>Plan a pilot</li> </ul> <h3>23 - Deploy using the Microsoft Deployment Toolkit</h3> <ul> <li>Evaluate traditional deployment methods</li> <li>Set up the Microsoft Deployment Toolkit for client deployment</li> <li>Manage and deploy images using the Microsoft Deployment Toolkit</li> </ul> <h3>24 - Deploy using Microsoft Configuration Manager</h3> <ul> <li>Explore client deployment using Configuration Manager</li> <li>Examine deployment components of Configuration Manager</li> <li>Manage client deployment using Configuration Manager</li> <li>Plan in-place upgrades using Configuration Manager</li> </ul> <h3>25 - Deploy Devices using Windows Autopilot</h3> <ul> <li>Use Autopilot for modern deployment</li> <li>Examine requirements for Windows Autopilot</li> <li>Prepare device IDs for Autopilot</li> <li>Implement device registration and out-of-the-box customization</li> <li>Examine Autopilot scenarios</li> <li>Troubleshoot Windows Autopilot</li> </ul> <h3>26 - Implement dynamic deployment methods</h3> <ul> <li>Examine subscription activation</li> <li>Deploy using provisioning packages</li> <li>Use Windows Configuration Designer</li> <li>Use Microsoft Entra join with automatic MDM enrollment</li> </ul> <h3>27 - Plan a transition to modern endpoint management</h3> <ul> <li>Explore using co-management to transition to modern endpoint management</li> <li>Examine prerequisites for co-management</li> <li>Evaluate modern management considerations</li> <li>Evaluate upgrades and migrations in modern transitioning</li> <li>Migrate data when modern transitioning</li> <li>Migrate workloads when modern transitioning</li> </ul> <h3>28 - Manage Windows 365</h3> <ul> <li>Explore Windows 365</li> <li>Configure Windows 365</li> <li>Administer Windows 365</li> </ul> <h3>29 - Manage Azure Virtual Desktop</h3> <ul> <li>Examine Azure Virtual Desktop</li> <li>Explore Azure Virtual Desktop</li> <li>Configure Azure Virtual Desktop</li> <li>Administer Azure Virtual Desktop</li> </ul></div><div id="course-pills-3"><h4>Additional course details:</h4><br /><p>Nexus Humans MD-102T00 : Microsoft 365 Endpoint Administrator training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. </p><p></p> This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. <p></p>Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success.  <p></p>While we feel this is the best course for the MD-102T00 : Microsoft 365 Endpoint Administrator course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you.  <p></p>Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.<p></p></div>

MD-102T00 Microsoft 365 Endpoint Administrator

<div id="course-pills-1">Duration<p>5 Days</p><p>30 CPD hours</p>This course is intended for<p>This course is for experienced information technology (IT) professionals, typically described as Enterprise Desktop Administrators (EDAs). These EDAs deploy, manage, and maintain PCs, devices, and applications across medium, large, and enterprise organizations. A significant portion of this audience uses, or intends to use, the latest release of Configuration Manager to manage and deploy PCs, devices, and applications.</p>Overview<p>Describe the features Configuration Manager and Intune include, and explain how you can use these features to manage PCs and mobile devices in an enterprise environment. Analyze data by using queries and reports. Prepare a management infrastructure, including configuring boundaries, boundary groups, and resource discovery, and integrating mobile-device management with Intune. Deploy and manage the Configuration Manager client. Configure, manage, and monitor hardware and software inventory, and use Asset Intelligence and software metering. Identify and configure the most appropriate method to distribute and manage content used for deployments. Distribute, deploy, and monitor applications for managed users and systems. Maintain software updates for PCs that Configuration Manager manages. Implement Endpoint Protection for managed PCs. Configure an operating-system deployment strategy by using Configuration Manager. Manage and maintain a Configuration Manager site.</p><p>This five-day course describes how to use Configuration Manager and its associated site systems to efficiently manage network resources. In this five-day course, you will learn day-to-day management tasks, including how to manage applications, client health, hardware and software inventory, operating system deployment, and software updates by using Configuration Manager. You also will learn how to optimize Endpoint Protection, manage compliance, and create management queries and reports.  Although this course and the associated labs are written for Microsoft Endpoint Configuration Manager and Windows 11, the skills taught will also be backwards compatible with previous editions of System Center Configuration Manager and Windows 10.</p>Prerequisites<p></p><li>Networking fundamentals, including common networking protocols, topologies, hardware, media, routing, switching, and addressing.</li>  <li>Active Directory Domain Services (AD DS) principles and fundamentals of AD DS management.</li>  <li>Installation, configuration, and troubleshooting for Windows-based personal computers.</li>  <li>Basic concepts of public key infrastructure (PKI) security.</li>  <li>Basic understanding of scripting and Windows PowerShell syntax.</li>  <li>Basic understanding of Windows Server roles and services.</li>  <li>Basic understanding of the configuration options for iOS and Android Mobile device platforms.</li><p></p></div><div id="course-pills-2"><h3>1 - Managing computers and mobile devices in the enterprise</h3> <ul> <li>Overview of systems management by using enterprise management solutions</li> <li>Overview of the Configuration Manager architecture</li> <li>Overview of the Configuration Manager administrative tools</li> <li>Tools for monitoring and troubleshooting a Configuration Manager site</li> </ul> <h3>2 - Analyzing data using queries, reports, and CMPivot</h3> <ul> <li>Introduction to queries</li> <li>Configuring SQL Server Reporting Services</li> <li>Analyzing the real-time state of a device by using CMPivot</li> </ul> <h3>3 - Preparing the Configuration Manager management infrastructure</h3> <ul> <li>Configuring site boundaries and boundary groups</li> <li>Configuring resource discovery</li> <li>Organizing resources using device and user collections</li> </ul> <h3>4 - Deploying and managing the Configuration Manager client</h3> <ul> <li>Overview of the Configuration Manager client</li> <li>Deploying the Configuration Manager client</li> <li>Configuring and monitoring client status</li> <li>Managing client settings and performing management operations</li> </ul> <h3>5 - Managing inventory for PCs and applications</h3> <ul> <li>Overview of inventory collection</li> <li>Configuring hardware and software inventory</li> <li>Managing inventory collection</li> <li>Configuring software metering</li> <li>Configuring and managing Asset Intelligence</li> </ul> <h3>6 - Distributing and managing content used for deployments</h3> <ul> <li>Preparing the infrastructure for content management</li> <li>Distributing and managing content on distribution points</li> </ul> <h3>7 - Deploying and managing applications</h3> <ul> <li>Overview of application management</li> <li>Creating applications</li> <li>Deploying applications</li> <li>Managing applications</li> <li>Deploying and managing Windows apps</li> </ul> <h3>8 - Maintaining software updates for managed PCs</h3> <ul> <li>The software updates process</li> <li>Preparing a Configuration Manager site for software updates</li> <li>Managing software updates</li> <li>Configuring automatic deployment rules</li> <li>Monitoring and troubleshooting software updates</li> <li>Enabling third-party updates</li> </ul> <h3>9 - Implementing Defender Protection for managed PCs</h3> <ul> <li>Overview of Endpoint Protection in Configuration Manager</li> <li>Configuring, deploying, and monitoring Endpoint Protection policies</li> <li>Configuring and deploying advanced threat policies</li> <h3>10 - Managing compliance and secure data access</h3> <ul> <li>Overview of Compliance Settings</li> <li>Configuring compliance settings</li> <li>Viewing compliance results</li> <li>Managing resource and data access</li> <h3>11 - Managing operating system deployment</h3> <ul> <li>An overview of operating system deployment</li> <li>Preparing a site for operating system deployment</li> <li>Deploying an operating system</li> <li>Managing Windows as a service</li> <h3>12 - Managing and maintaining a Configuration Manager site</h3> <ul> <li>Configuring role-based administration</li> <li>Configuring Remote Tools</li> <li>Overview of Configuration Manager site maintenance and Management Insights</li> <li>Backing up and recovering a Configuration Manager site</li> <li>Updating the Configuration Manager infrastructure</li> <h3>13 - What?s new in Microsoft Endpoint Configuration Manager</h3> <ul> <li>Whats new in Microsoft Endpoint Manager covering each semi annual release</li> </ul></ul></ul></ul></ul></div><div id="course-pills-3"><h4>Additional course details:</h4><br /><p>Nexus Humans 55348: Administering Microsoft Endpoint Configuration Manager training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. </p><p></p> This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. <p></p>Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success.  <p></p>While we feel this is the best course for the 55348: Administering Microsoft Endpoint Configuration Manager course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you.  <p></p>Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.<p></p></div>

Sccm

Microsoft Certified Technology Specialist (MCTS)

Commercial & Contract Management Certification Program (CCM)

IT Manager

Microsoft Certified Trainer (MCT)

55348 Administering Microsoft Endpoint Configuration Manager

<div data-node="61658ba442cd6" style="color: rgb(117, 117, 117); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(117, 117, 117);"><div data-node="61658ba442cd7" fr-original-style="" style="box-sizing: border-box;"><div data-node="61658ba442cd8" fr-original-style="" style="box-sizing: border-box;"><div data-node="61658ba442cd9" data-animation-delay="0" data-animation-duration="1" fr-original-style="" style="box-sizing: border-box;"><div data-node="6165945ab79d7" style="color: rgb(117, 117, 117); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(117, 117, 117);"><div data-node="6165945ab79d8" fr-original-style="" style="box-sizing: border-box;"><div data-node="6165945ab79d9" fr-original-style="" style="box-sizing: border-box;"><div data-node="6165945ab79da" data-animation-delay="0" data-animation-duration="1" fr-original-style="" style="box-sizing: border-box;"><div data-node="61657d76a40c2" style="color: rgb(117, 117, 117); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(117, 117, 117);"><div data-node="61657d76a40c3" fr-original-style="" style="box-sizing: border-box;"><div data-node="61657d76a40c4" fr-original-style="" style="box-sizing: border-box;"><div data-node="61657d76a40c5" data-animation-delay="0" data-animation-duration="1" fr-original-style="" style="box-sizing: border-box;"><h3 style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);"><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">Digital Electronics Course</span></h3></div><div data-node="618322664d7fd" data-animation-delay="0" data-animation-duration="1" fr-original-style="" style="box-sizing: border-box;"><h3 style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);"><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">Aim</span></h3><div style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);"><p style="color: rgb(0, 0, 0); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">This <strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Digital Electronics Course</strong>&nbsp;is designed to give practical knowledge of the type of electronic circuitry used in a modern Computer System or in any type of Computer Controlled equipment such as Photocopiers, Cash Registers, Tablets, mobile phones and many other types of IT equipment.&nbsp;</p><p style="color: rgb(0, 0, 0); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">Digital Electronics involves the use of Silicon chips (Integrated Circuits). The internal structure of a computer is to a large extent comprised of Digital Electronic Circuits.</p></div></div><div data-node="618322b7d4864" data-animation-delay="0" data-animation-duration="1" fr-original-style="" style="box-sizing: border-box;"><h3 style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);"><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">Duration and Schedule</span></h3><div style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);"><p style="color: rgb(0, 0, 0); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">This <strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Digital Electronics Course</strong> runs over 10 evenings (every Monday and Wednesday) from 7.00pm to 10.00pm with the next course commencing on&nbsp;<strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"><span style="color: rgb(255, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(255, 0, 0);">Monday 2nd September 2024 at 7.00 pm</span>.</strong></p><p style="color: rgb(0, 0, 0); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"><span style="color: rgb(255, 0, 0); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(255, 0, 0);"><b style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">A payment of &pound;65 secures your place on your chosen course.</b><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);">&nbsp;The balance of the course fees of &pound;600 can be paid shortly before course commencement.</span></span><br fr-original-style="" style="box-sizing: border-box;"></strong></p></div></div></div></div></div><div data-node="61657d76a40c7" style="color: rgb(117, 117, 117); box-sizing: border-box;" fr-original-style=" color: rgb(117, 117, 117);"><div data-node="61657d76a40c8" fr-original-style="" style="box-sizing: border-box;"><div data-node="61657d76a40c9" fr-original-style="" style="box-sizing: border-box;"><div data-node="6183230b58256" data-animation-delay="0" data-animation-duration="1" fr-original-style="" style="box-sizing: border-box;"><h3 style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);"><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">Online Virtual Classroom &ndash; how it works?</span></h3><div style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);"><p style="color: rgb(0, 0, 0); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">The course will be delivered through 9 online virtual classroom sessions. The 10th and last session will involve the additional practical work for the course as well as the written examination (multiple choice for City &amp; Guilds and written for Hi-Tech Training) which will take place at our training centre at 43 North Great Georges Street, Dublin 1 (completed online for non ROI learners).</p><p style="color: rgb(0, 0, 0); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">During the virtual classroom sessions, trainees will have a live video feed with their instructor talking to them, doing practical live demonstrations on equipment being involved actively in the learning.</p><p style="color: rgb(0, 0, 0); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">We will send out a practical kit so that trainees can complete assignments and practical work at home. The kit is the property of Hi-Tech Training and will be returned to Hi-Tech Training on the last day of the course.<br fr-original-style="" style="box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></p><p style="color: rgb(0, 0, 0); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">(The kits may also be purchased by the learner&hellip;.see the&nbsp;<a href="http://hitechtraining.ie/product-category/electronics-courses/digital-electronics-course/" target="_blank" rel="noopener" style="color: rgb(209, 33, 56); user-select: auto; font-size: var(--font-size); box-sizing: border-box; cursor: pointer; text-decoration: inherit;" fr-original-style=" color: rgb(209, 33, 56);">Kits Page Link</a>&nbsp;for more details).<br fr-original-style="" style="box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></p><p style="color: rgb(0, 0, 0); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">The kit consists of power supply unit breadboard, multimeter, cables, The kit consists of breadboard, multimeter, oscilloscope, battery and connectors, components including resistors, LEDs and ICs (AND, NAND, OR, NOR, X-OR, X-NOR, Inverter, Buffer, Latches, Flip-Flops, Timers, etc). Trainees will build various projects as part of the course. The kit forms an integral part of the course, so full course fees need to be paid at least 7 days prior to course commencement to allow time to ship the kit in time for the course.</p><p style="color: rgb(0, 0, 0); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">* If attending the course from outside of Ireland the course practical training kit must be purchased via our online shop in time for delivery before course commencement. The equipment will then remain the property of the trainee.</strong></p><p style="color: rgb(0, 0, 0); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">In preparation for each course, we have a quick informal free 1 hr online meeting approx. 7 days prior to course commencement, to make sure that trainees get connected through Zoom properly, let them know what the virtual classroom will be like and go through any questions they may have. To join the virtual sessions, you will need a PC/Laptop or Tablet with an internet connection. Joining instructions (login IDs, etc.) will be sent before the Informal Induction session.</p><p style="color: rgb(0, 0, 0); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);"><br fr-original-style="" style="box-sizing: border-box;"></p></div></div><div data-node="61657d76a40d2" data-animation-delay="0.0" data-animation-duration="1" fr-original-style="" style="box-sizing: border-box;"><h3 style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);"><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">Learning Objectives</span></h3><div style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);"><p style="color: rgb(0, 0, 0); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">This course equips participants with practical &ldquo;Hands-on&rdquo; skills relevant to the workplace and the theory required for certification. Participants can expect to have the skills to:&nbsp;</p><ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">Build and fault-finding a range of Digital Electronic circuits used in computers and computer-controlled equipment</li><li fr-original-style="" style="box-sizing: border-box;">Use test equipment including Multimeters, Oscilloscopes, logic probes and pulsers to implement systematic fault-finding techniques.</li><li fr-original-style="" style="box-sizing: border-box;">Study and use of popular Digital Electronic gates and more advanced circuits</li></ul></div></div><div data-node="61657d76a40d7" data-animation-delay="0.0" data-animation-duration="1" fr-original-style="" style="box-sizing: border-box;"><h3 style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);"><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">Course Content</span></h3><div style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);"><ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">Introduction to Electronics: &ndash; Electric Current, OHMS Law, Insulation, Conduction and related Formulae. Resistor colour codes.</li><li fr-original-style="" style="box-sizing: border-box;">Practical study of Digital I.C.s including AND, NAND, OR, NOR, X-OR, X-NOR, Inverter, Buffer, SR Latches and D-Latches and Flip-Flops.</li><li fr-original-style="" style="box-sizing: border-box;">Oscillators, Multivibrators and 555 Timers. Switches and Switch De-bounce circuits and their applications.</li><li fr-original-style="" style="box-sizing: border-box;">Numbering systems, TTL and CMOS technologies</li><li fr-original-style="" style="box-sizing: border-box;">Counters, Counter Decoding Circuitry, Shift Registers</li><li fr-original-style="" style="box-sizing: border-box;">A-D and D-A converters</li><li fr-original-style="" style="box-sizing: border-box;">Digital Displays: &ndash; LED and LCD, numeric and alphanumeric, operating currents, voltages and power requirements. Display decoders and drivers.</li><li fr-original-style="" style="box-sizing: border-box;">Test Equipment: &ndash; Practical use of Analogue and Digital Multimeters, Oscilloscopes, Logic probes, Logic Pulsers, etc.</li><li fr-original-style="" style="box-sizing: border-box;">Fault-finding techniques: &ndash; Diagnosing and rectifying faults on circuits built during course.</li><li fr-original-style="" style="box-sizing: border-box;">Health &amp; Safety, Care of Tools and instruments for assembly and repair</li></ul></div></div></div></div></div><div data-node="61657d76a40d3" style="color: rgb(117, 117, 117); box-sizing: border-box;" fr-original-style=" color: rgb(117, 117, 117);"><div data-node="61657d76a40d4" fr-original-style="" style="box-sizing: border-box;"><div data-node="61657d76a40d5" fr-original-style="" style="box-sizing: border-box;"><div data-node="61657d76a40d6" data-animation-delay="0.0" data-animation-duration="1" fr-original-style="" style="box-sizing: border-box;"><h3 style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);"><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">Certification</span></h3><div style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);"><ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">City &amp; Guilds of London Institute Digital Electronics 2 (Examination No. 7267-425). This examination consists of 1 written paper and 4 practical assignments. The qualification can be used as part of the requirement for <a title="City & Guilds Diploma in IT Systems Support" href="http://hitechtraining.ie/city-guilds-certification/" style="color: rgb(209, 33, 56); user-select: auto; font-size: var(--font-size); box-sizing: border-box; cursor: pointer; text-decoration: inherit;" fr-original-style=" color: rgb(209, 33, 56);">City &amp; Guilds Diploma in IT Systems Support (7267-24).</a></li><li fr-original-style="" style="box-sizing: border-box;">On completion of the Course, having been successful in an examination, the participant will receive a Hi-Tech Training Certificate.</li></ul></div></div><div data-node="61657d76a40d8" data-animation-delay="0" data-animation-duration="1" fr-original-style="" style="box-sizing: border-box;"><img width="794" height="602" src="http://hitechtraining.ie/wp-content/uploads/2022/02/Hi-Tech-City-Guilds-Diploma-in-IT-Systems-Support-7267-24.png" alt="Hi Tech - City & Guilds Diploma in IT Systems Support (7267-24)" itemprop="image" srcset="https://hitechtraining.ie/wp-content/uploads/2022/02/Hi-Tech-City-Guilds-Diploma-in-IT-Systems-Support-7267-24.png 794w, https://hitechtraining.ie/wp-content/uploads/2022/02/Hi-Tech-City-Guilds-Diploma-in-IT-Systems-Support-7267-24-300x227.png 300w, https://hitechtraining.ie/wp-content/uploads/2022/02/Hi-Tech-City-Guilds-Diploma-in-IT-Systems-Support-7267-24-768x582.png 768w, https://hitechtraining.ie/wp-content/uploads/2022/02/Hi-Tech-City-Guilds-Diploma-in-IT-Systems-Support-7267-24-600x455.png 600w, https://hitechtraining.ie/wp-content/uploads/2022/02/Hi-Tech-City-Guilds-Diploma-in-IT-Systems-Support-7267-24-64x49.png 64w" sizes="(max-width: 794px) 100vw, 794px" title="Hi Tech - City & Guilds Diploma in IT Systems Support (7267-24)" fr-original-style="" style="cursor: pointer; padding: 0px 1px; user-select: none; max-width: 100%; position: relative; box-sizing: border-box;" fr-original-class="fr-draggable"></div></div></div></div></div></div></div></div></div></div></div></div><div data-node="61658ba442ce7" style="color: rgb(117, 117, 117); box-sizing: border-box;" fr-original-style=" color: rgb(117, 117, 117);"><div data-node="61658ba442ce8" fr-original-style="" style="box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></div></div>

Hi-Tech Training

City & Guilds

Electronics

Digital Design

Electrical Engineering

Analog Electronics

Computer Engineering

Digital Skills

Online Education

This Digital Electronics Course is designed to give practical knowledge of the type of electronic circuitry used in a modern Computer System or in any type of Computer Controlled equipment such as Photocopiers, Cash Registers, Tablets, mobile phones and many other types of IT equipment. 

Digital Electronics involves the use of Silicon chips (Integrated Circuits). The internal structure of a computer is to a large extent comprised of Digital Electronic Circuits.

Digital Electronics Course Online

Deposit Only

Full Price (including Deposit)

<h3 style="color: rgb(55, 55, 55); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(55, 55, 55);">Audience</h3><p style="color: rgb(55, 55, 55); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(55, 55, 55);">This is an intermediate course for system and database administrators, application developers, and other individuals who need a technical introduction to selected new features of Db2 13 for z/OS.</p><h3 style="color: rgb(55, 55, 55); box-sizing: border-box;" fr-original-style=" color: rgb(55, 55, 55);">Prerequisites</h3><div style="color: rgb(55, 55, 55); box-sizing: border-box;" fr-original-style=" color: rgb(55, 55, 55);"><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">You should have practical experience with Db2 for z/OS</p></div><h3 style="color: rgb(55, 55, 55); box-sizing: border-box;" fr-original-style=" color: rgb(55, 55, 55);">Duration</h3><p style="color: rgb(55, 55, 55); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(55, 55, 55);">2 days.&nbsp;</p><h3 style="color: rgb(55, 55, 55); box-sizing: border-box;" fr-original-style=" color: rgb(55, 55, 55);">Course Objectives</h3><p style="color: rgb(55, 55, 55); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(55, 55, 55);">Learn about the new features and enhancements of Db2 for z/OS (v13), including the technical detail of the functional enhancements of this significant new version of Db2 for z/OS.</p><h3 style="color: rgb(55, 55, 55); box-sizing: border-box;" fr-original-style=" color: rgb(55, 55, 55);">Course Content</h3><ul style="color: rgb(55, 55, 55); box-sizing: border-box;" fr-original-style=" color: rgb(55, 55, 55);"><li fr-original-style="" style="box-sizing: border-box;">Unit 1: Db2 v12 Function Levels: Selected Highlights</li><li fr-original-style="" style="box-sizing: border-box;">Unit 2: Migrating to Db2 13</li><li fr-original-style="" style="box-sizing: border-box;">Unit 3: Availability &amp; Scalability</li><li fr-original-style="" style="box-sizing: border-box;">Unit 4: Performance</li><li fr-original-style="" style="box-sizing: border-box;">Unit 5: Application Management and SQL Changes</li><li fr-original-style="" style="box-sizing: border-box;">Unit 6: SQL Data Insights</li><li fr-original-style="" style="box-sizing: border-box;">Unit 7: Security</li><li fr-original-style="" style="box-sizing: border-box;">Unit 8: IBM Db2 Utilities</li><li fr-original-style="" style="box-sizing: border-box;">Unit 9: Instrumentation and Serviceability</li></ul>

Verhoef Training Ltd.

New Db2 13 Functions and Features - CV321G

Early bird

Book your place early to get an extra discount!

<div id="course-pills-1">Duration<p>4 Days</p><p>24 CPD hours</p>This course is intended for<p>This course is intended for both novice and experienced SharePoint users who wish to make full use of SharePoint Online.</p>Overview<p>#NAME?</p><p>This course delivers the complete site owner story from start to finish in an engaging and practical way to ensure you have the confidence to plan and create new sites or manage your existing sites in SharePoint Online. Your goal is to learn how to make SharePoint online relevant to your team by using a sites functionality to help you share information and collaborate with your colleagues. During the class, you will also learn best practices and ?what not to do? as you watch live, interactive demonstrations and put theory into practice with hands on exercises in SharePoint Online.</p></div><div id="course-pills-2"><h3>1 - An Introduction to SharePoint Online</h3> <ul> <li>Introducing Office 365 and SharePoint</li> <li>Getting started with Office 365</li> <li>The cloud revolution</li> <li>Login to Office 365</li> <li>What is Office 365</li> <li>Using the app launcher</li> <li>What is SharePoint</li> <li>Office 365 settings</li> <li>Introducing Office 365 Groups</li> <li>Delve</li> <li>Ownership and Access</li> <li>OneDrive</li> </ul> <h3>2 - Creating Sites</h3> <ul> <li>Planning your sites</li> <li>Create new subsites</li> <li>The Office 365 tenant</li> <li>Site templates</li> <li>Web addresses</li> <li>Apply a them</li> <li>Site collections</li> <li>Building your navigation</li> <li>Create a new site</li> <li>Delete subsites</li> <li>Team site navigation</li> <li>User interface: classic vs modern</li> <li>Site contents: classic vs modern</li> <li>Where does classic come from?</li> </ul> <h3>3 - Creating and Managing Web Pages</h3> <ul> <li>The types of pages found in SharePoint</li> <li>Classic SharePoint pages</li> <li>Modern SharePoint pages</li> <li>How to use classic team site pages</li> <li>Create news and site pages</li> <li>Review features of publishing sites</li> <li>Web parts</li> <li>Save, publish, share and delete pages</li> <li>Communication sites</li> </ul> <h3>4 - Working with Apps</h3> <ul> <li>An introduction to apps</li> <li>Co-authoring</li> <li>Marketplace apps</li> <li>Check In ? Out</li> <li>Adding apps to a site</li> <li>Edit and view file properties</li> <li>Create and manage columns</li> <li>Quick edit view</li> <li>Public and personal views</li> <li>File commands</li> <li>Managing app settings</li> <li>Copy link and Share</li> <li>Content approval</li> <li>Folders</li> <li>Major and minor versioning</li> <li>The recycle bin</li> <li>Document sets</li> <li>Alerts</li> <li>Working with files in a library</li> <li>OneDrive sync</li> <li>Create, Upload and edit files</li> <li>Working with classic lists</li> </ul> <h3>5 - Building processes with Flow and PowerApps</h3> <ul> <li>What are business processes?</li> <li>Design and publish a Flow</li> <li>Classic tools for designing processes</li> <li>Getting started with PowerApps in SharePoint</li> <li>Design and test a classic workflow</li> <li>Enhance data capture with PowerApps</li> <li>Getting started with Flow in SharePoint</li> <li>Test a Flow and PowerApps enriched list</li> </ul> <h3>6 - Customizing Security</h3> <ul> <li>Office 365 Group access</li> <li>Share a file</li> <li>Updating Office 365 Group Security</li> <li>Remove a user</li> <li>Managing access to SharePoint</li> <li>Customizing SharePoint security</li> <li>New sites private vs public</li> <li>Create permission levels and groups</li> <li>Setup access requests</li> <li>Security inheritance</li> <li>Share a site</li> <li>Security best practices</li> </ul> <h3>7 - Working with Search</h3> <ul> <li>Delve</li> <li>Search tips</li> <li>An introduction to SharePoint search</li> <li>Accessing classic search</li> <li>Search in folders, libraries and sites</li> <li>Promoted results</li> <li>Search results</li> </ul> <h3>8 - Enterprise Content Management</h3> <ul> <li>Managed metadata service</li> <li>Information management policies</li> <li>An introduction to content types</li> <li>The records center</li> <li>Create and manage content type</li> <li>In-place records management</li> <li>Deploy content types</li> <li>The content organizer</li> <li>Using content types in apps</li> <li>Durable links</li> <li>The content type hub</li> </ul></div>

Microsoft Sharepoint

SharePoint

55215 SharePoint Online Power User

<p id="isPasted" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></strong></strong></p><p id="isPasted" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Real Estate Analyst</strong></strong></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">The Real Estate Analyst course has been taught non-stop to global real estate firms over the last 25 years, and is without doubt the core financial modelling training in your career portfolio. Whether you have an upcoming financial modelling test for a new job or an APC exam, the Real Estate Analyst course is the choice for you.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Create flexible real estate investment focused financial models in Excel. Case studies focus on core, core plus and value add property investments. This course shows you how to model income producing property with both annual and quarterly discounted cash flows, build rent functions, model costs and calculate returns. It also shows you how to interpret and analyse the results.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">On this course, you will&hellip;</strong></strong></p><ul fr-original-style="" style="box-sizing: border-box;"><li value="1" fr-original-style="" style="box-sizing: border-box;">Learn how to structure an investment cash flow from first principles and how to value and appraise property investments</li><li value="2" fr-original-style="" style="box-sizing: border-box;">Build annual and quarterly discounted cash flows</li><li value="3" fr-original-style="" style="box-sizing: border-box;">Look in depth at modelling tenancy schedules: rent reviews, upward-only, break options, lease expiry</li><li value="4" fr-original-style="" style="box-sizing: border-box;">Build OPEX and CAPEX into your cash flow</li><li value="5" fr-original-style="" style="box-sizing: border-box;">Analyse risk using sensitivity tables and charts</li><li value="6" fr-original-style="" style="box-sizing: border-box;">Employ best practice and find solutions to common modelling problems</li></ul><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Who will benefit from this course?</strong></strong></p><ul fr-original-style="" style="box-sizing: border-box;"><li value="1" fr-original-style="" style="box-sizing: border-box;">Real Estate Investors</li><li value="2" fr-original-style="" style="box-sizing: border-box;">Surveyors</li><li value="3" fr-original-style="" style="box-sizing: border-box;">Portfolio Analysts</li><li value="4" fr-original-style="" style="box-sizing: border-box;">Investment Managers</li><li value="5" fr-original-style="" style="box-sizing: border-box;">Asset Managers</li><li value="6" fr-original-style="" style="box-sizing: border-box;">Real Estate professionals at any level with exposure to real estate financial models on a frequent basis</li><li value="7" fr-original-style="" style="box-sizing: border-box;">Mid-level to senior Real Estate Analysts who would like to start building their own real estate models quickly, rather than relying solely on coaching from existing team members</li><li value="8" fr-original-style="" style="box-sizing: border-box;">Junior or new Real Estate Analysts who would like to start building their own real estate models quickly, rather than relying solely on coaching from existing team members</li><li value="9" fr-original-style="" style="box-sizing: border-box;">APC candidates who would like the opportunity to consolidate their competencies by understanding how theory and variables interact within the precision context of a financial model.</li></ul><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Day One</strong></strong></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Know how to build a property asset cash flow, analyse geared, and un-geared IRRs.</p><ul fr-original-style="" style="box-sizing: border-box;"><li value="1" fr-original-style="" style="box-sizing: border-box;">Term &amp; Reversion and Layer Method Valuation (Intro to Excel)</li><li value="2" fr-original-style="" style="box-sizing: border-box;">Equivalent Yield (Solver, Scenario and Goal Seek functions)</li><li value="3" fr-original-style="" style="box-sizing: border-box;">Single-Let Discounted Cash Flow</li><li value="4" fr-original-style="" style="box-sizing: border-box;">Cash Flow inputs (Rents, Yields, Growth Rates, Target Returns)</li><li value="5" fr-original-style="" style="box-sizing: border-box;">Analysis and use of date series</li><li value="6" fr-original-style="" style="box-sizing: border-box;">Internal Rate of Return (IRR) and Net Present Value (NPV)</li><li value="7" fr-original-style="" style="box-sizing: border-box;">Comparing Value, Price and Worth</li><li value="8" fr-original-style="" style="box-sizing: border-box;">Adding borrowing and analysing geared returns</li><li value="9" fr-original-style="" style="box-sizing: border-box;">Introducing Rent Reviews and other &lsquo;events&rsquo; into cash flows</li><li value="10" fr-original-style="" style="box-sizing: border-box;">The &lsquo;Rent Function&rsquo; concept and Logic functions (IF,OR,AND)</li><li value="11" fr-original-style="" style="box-sizing: border-box;">Sensitivity analysis</li></ul><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Day Two</strong></strong></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Know how to build a multi-let property cash flow and apply the concepts on a hypothetical case study.</p><ul fr-original-style="" style="box-sizing: border-box;"><li value="1" fr-original-style="" style="box-sizing: border-box;">The &lsquo;Rent Function&rsquo; and Multi-let cash flows</li><li value="2" fr-original-style="" style="box-sizing: border-box;">The &lsquo;date problem&rsquo; and assumptions in property asset cash flows</li><li value="3" fr-original-style="" style="box-sizing: border-box;">Reducing the rent function, intermediate calculations and modelling theory</li><li value="4" fr-original-style="" style="box-sizing: border-box;">Modelling lease expiries, break clauses, voids, and upward only covenants</li><li value="5" fr-original-style="" style="box-sizing: border-box;">Incorporating time-varying rental growth rates</li><li value="6" fr-original-style="" style="box-sizing: border-box;">Analysing multi-let cash flows to see if the leases are sufficiently diversified</li><li value="7" fr-original-style="" style="box-sizing: border-box;">Further IRR analysis (XIRR, MIRR)</li></ul><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Included in the Course</strong></strong></p><ul fr-original-style="" style="box-sizing: border-box;"><li value="1" fr-original-style="" style="box-sizing: border-box;">CPD Accredited Certificate &amp; LinkedIn Proficiency Badge</li><li value="2" id="isPasted" fr-original-style="" style="box-sizing: border-box;">Course Manual - In-Person Course attendees will receive a Physical Copy, Virtual Course attendees will receive a Virtual Copy and have the option to purchase a Hard Copy at an additional fee</li><li value="3" fr-original-style="" style="box-sizing: border-box;">Course Files</li><li value="4" fr-original-style="" style="box-sizing: border-box;">Online Learning Platform access - Further Learning Resources (Reading, Files and Videos)</li><li value="5" fr-original-style="" style="box-sizing: border-box;">Post Course Support - Two Months of Questions &amp; Answers, and One year of support is available for an additional fee</li></ul><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">For more information about the Real Estate Analyst such as course delivery methods, pricing and dates, please contact Sam on the Bayfield Training Sales team:</p><p id="isPasted" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">E - s.musgrave@bayfieldtraining.com</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">T - 01223 517851</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">W - <a href="https://www.bayfieldtraining.com/" target="_blank" rel="nofollow noopener noreferrer ugc" title="https://www.bayfieldtraining.com/" data-airgap-id="125" fr-original-style="" style="user-select: auto; font-size: var(--font-size); box-sizing: border-box; cursor: pointer; text-decoration: inherit;">www.bayfieldtraining.com</a></p>



Real Estate Analyst
The Real Estate Analyst course has been taught non-stop to global real estate firms over the last 25 years, and is without doubt the core financial modelling training in your career portfolio. Whether you have an upcoming financial modelling test for a new job or an APC exam, the Real Estate Analyst course is the choice for you.
Create flexible real estate investment focused financial models in Excel. Case studies focus on core, core plus and value add property investments. This course shows you how to model income producing property with both annual and quarterly discounted cash flows, build rent functions, model costs and calculate returns. It also shows you how to interpret and analyse the results.


On this course, you will…
Learn how to structure an investment cash flow from first principles and how to value and appraise property investments
Build annual and quarterly discounted cash flows
Look in depth at modelling tenancy schedules: rent reviews, upward-only, break options, lease expiry
Build OPEX and CAPEX into your cash flow
Analyse risk using sensitivity tables and charts
Employ best practice and find solutions to common modelling problems


Who will benefit from this course?
Real Estate Investors
Surveyors
Portfolio Analysts
Investment Managers
Asset Managers
Real Estate professionals at any level with exposure to real estate financial models on a frequent basis
Mid-level to senior Real Estate Analysts who would like to start building their own real estate models quickly, rather than relying solely on coaching from existing team members
Junior or new Real Estate Analysts who would like to start building their own real estate models quickly, rather than relying solely on coaching from existing team members
APC candidates who would like the opportunity to consolidate their competencies by understanding how theory and variables interact within the precision context of a financial model.


Day One
Know how to build a property asset cash flow, analyse geared, and un-geared IRRs.
Term & Reversion and Layer Method Valuation (Intro to Excel)
Equivalent Yield (Solver, Scenario and Goal Seek functions)
Single-Let Discounted Cash Flow
Cash Flow inputs (Rents, Yields, Growth Rates, Target Returns)
Analysis and use of date series
Internal Rate of Return (IRR) and Net Present Value (NPV)
Comparing Value, Price and Worth
Adding borrowing and analysing geared returns
Introducing Rent Reviews and other ‘events’ into cash flows
The ‘Rent Function’ concept and Logic functions (IF,OR,AND)
Sensitivity analysis


Day Two
Know how to build a multi-let property cash flow and apply the concepts on a hypothetical case study.
The ‘Rent Function’ and Multi-let cash flows
The ‘date problem’ and assumptions in property asset cash flows
Reducing the rent function, intermediate calculations and modelling theory
Modelling lease expiries, break clauses, voids, and upward only covenants
Incorporating time-varying rental growth rates
Analysing multi-let cash flows to see if the leases are sufficiently diversified
Further IRR analysis (XIRR, MIRR)


Included in the Course
CPD Accredited Certificate & LinkedIn Proficiency Badge
Course Manual - In-Person Course attendees will receive a Physical Copy, Virtual Course attendees will receive a Virtual Copy and have the option to purchase a Hard Copy at an additional fee
Course Files
Online Learning Platform access - Further Learning Resources (Reading, Files and Videos)
Post Course Support - Two Months of Questions & Answers, and One year of support is available for an additional fee


For more information about the Real Estate Analyst such as course delivery methods, pricing and dates, please contact Sam on the Bayfield Training Sales team:
E - s.musgrave@bayfieldtraining.com
T - 01223 517851
W - www.bayfieldtraining.com

Bayfield Training

Financial Modelling & Analysis

Financial Modelling

Professional Development

Property & Real Estate Photography

Continuous Professional Development (CPD)

The Real Estate Analyst course has been taught non-stop to global real estate firms over the last 25 years, and is without doubt the core financial modelling training in your career portfolio. Whether you have an upcoming financial modelling test for a new job or an APC exam, the Real Estate Analyst course is the choice for you.

Real Estate Analyst (Investment Cash Flow Modelling in Excel)

In-Person 

Virtual

Tom Reynolds

Product Management

Agile

Agile PM

Productivity

Kanban

Agile Coach

Attend our world class Kanban University accredited Certified Kanban System Design training course and learn to implement Kanban in your company

Certified Kanban System Design – KMP I - 24-26 September

Standard

Early Bird

<div id="course-pills-1">Duration<p>1 Days</p><p>6 CPD hours</p>This course is intended for<p>To ensure success, students should have completed Excel Essentials and Excel Functions Including Pivot Tables and Lookups or have the equivalent knowledge and experience.</p>Overview<p>Upon successful completion of this course, students will be able to enhance productivity and efficiency by streamlining workflow, collaborate with others, and audit and analyse data.</p><p>This course is designed for students desiring to gain skills necessary to create macros, collaborate with others, audit and analyse data, incorporate multiple data sources, and import data.</p></div><div id="course-pills-2"><h4>Working with Multiple Worksheets and Workbooks </h4><ul><li>Working with Named Ranges</li><li>Link Cells Across Worksheets and Workbooks </li><li>Use 3D References to Calculate Across Worksheets</li><li>Consolidate Data</li></ul><h4>Use Formula Auditing and Error Checking</h4><ul><li>Reveal Formulas</li><li>Trace Cell Precedents and Dependents </li><li>Locate Errors in Formulas </li><li>Watch and Evaluate Formulas </li></ul><h4>Reviewing and Protecting Workbooks </h4><ul><li>Control Data Entry via Data Validation</li><li>Protect Workbook Access</li><li>Protect Worksheets and Cell Content </li><li>Add and Edit Comments</li><li>Prepare a Workbook for Distribution </li><li>Modify Excel's Default Settings</li></ul><h4>Using Macros to Automate Workbook Functionality</h4><ul><li>Create Macros via Recording </li><li>Run Macros via Buttons and Shortcuts</li><li>Assign Macros to the Quick Access Toolbar and Ribbon </li><li>Assign Macros to Objects </li><li>View Macro Code</li></ul><h4>Forecasting and Analysis Data</h4><ul><li>Use Conditional Formatting to Highlight, Sort and Filter Key Data</li><li>Advanced Conditional Formatting using Formulas</li><li>Create Sparklines to Visualise Data</li><li>Add Trendlines to Charts to Visualise and Forecast Trends</li><li>Use Data Tables and Scenarios to Project Potential Outcomes </li><li>Use Goal Seek to Calculate Outcomes</li><li>Forecast Data Trends Using Solver</li></ul></div>

Excel Analytics

Access VBA

Visual Basic Analysis

Microsoft Power Automate

Excel - Automating Excel with Macros and Analysis Tools

Chesterfield

<h2 id="isPasted" fr-original-style="" style="box-sizing: border-box;">QA Level 2 Award In Principles Of Risk Assessment (RQF)</h2><ul fr-original-style="" style="box-sizing: border-box;"><li id="isPasted" fr-original-style="" style="box-sizing: border-box;">Face to Face: One-day course</li><li fr-original-style="" style="box-sizing: border-box;">Virtual Classroom: Spread over 3 sessions of 2&frac12; hr duration</li><li fr-original-style="" style="box-sizing: border-box;">Don&#39;t run risks with the safety of your people - it will cost you a lot more when things start to go wrong...</li><li fr-original-style="" style="box-sizing: border-box;">Risk Assessments are vital for Health and Safety, and vital for the whole process</li></ul><hr fr-original-style="" style="border-color: var(--border-muted); border-style: solid; clear: both; break-after: page; user-select: none; box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Course Contents:</strong><ul id="isPasted" fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">Main causes of Work-related Fatalities, Injuries and ill health</li><li fr-original-style="" style="box-sizing: border-box;">Moral, Legal and Economic Reasons for Preventing Accidents and ill health at Work</li><li fr-original-style="" style="box-sizing: border-box;">Key Terms associated with Risk Assessments in Health and Safety at Work:<ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">Accident</li><li fr-original-style="" style="box-sizing: border-box;">Near Miss</li><li fr-original-style="" style="box-sizing: border-box;">Accident Triangle</li><li fr-original-style="" style="box-sizing: border-box;">Hazard</li><li fr-original-style="" style="box-sizing: border-box;">Risk</li><li fr-original-style="" style="box-sizing: border-box;">Risk Assessment</li><li fr-original-style="" style="box-sizing: border-box;">Suitable and Sufficient</li><li fr-original-style="" style="box-sizing: border-box;">Competence</li></ul></li><li fr-original-style="" style="box-sizing: border-box;">The Role of Risk Assessments in Accident and ill Health Prevention</li><li fr-original-style="" style="box-sizing: border-box;">Legal Requirements for Risk Assessments</li><li fr-original-style="" style="box-sizing: border-box;">Importance of Personal hygiene</li><li fr-original-style="" style="box-sizing: border-box;">Basic Process for Undertaking a Risk Assessment</li><li fr-original-style="" style="box-sizing: border-box;">The Five Steps of a Risk Assessment</li></ul><h3 data-css="tve-u-1724b5d034d" id="isPasted" style="color: rgb(34, 34, 34) !important; box-sizing: border-box;" fr-original-style=" color: rgb(34, 34, 34) !important;">Benefits of this course:</h3><ul fr-original-style="" style="box-sizing: border-box;"><li id="isPasted" fr-original-style="" style="box-sizing: border-box;">In 2020/21, a whopping 1.7 million people suffered from a work-related illness</li><li fr-original-style="" style="box-sizing: border-box;">441,000 of those sustained an injury</li><li fr-original-style="" style="box-sizing: border-box;">142 People, plus 60 members of the public, lost their lives...</li><li fr-original-style="" style="box-sizing: border-box;">The estimated cost of injuries and ill health was &pound;15 billion</li><li fr-original-style="" style="box-sizing: border-box;">28.2 million working days, or 108,045 working years, were lost due to work-related illnesses and injuries</li><li fr-original-style="" style="box-sizing: border-box;">It is an employer&#39;s duty to protect the health, safety and welfare of their employees and other people who might be affected by their business. This includes providing sufficient information, instruction and training of employees, so they can work in a way that does not put themselves or others at risk</li><li fr-original-style="" style="box-sizing: border-box;">Our QA Level 2 Award in Principles of Risk Assessment (RQF) course is ideal for all employees, helping them to create a better understanding of health and safety issues and risk assessments</li></ul><hr fr-original-style="" style="border-color: var(--border-muted); border-style: solid; clear: both; break-after: page; user-select: none; box-sizing: border-box;"><h3 fr-original-style="" style="box-sizing: border-box;">Accredited, Ofqual regulated qualification:</h3><div fr-original-style="" style="box-sizing: border-box;"><img src="https://images.cademy.co.uk/pochat-training/d4bd1328-0561-4a59-aef0-01af2e9666f7/original.png" style="width: 300px; display: inline-block; vertical-align: bottom; margin: 5px 5px 5px 0px; text-align: left; max-width: calc(100% - 5px); float: left; cursor: pointer; padding: 0px 1px; user-select: none; position: relative; box-sizing: border-box;" fr-original-style="width: 300px; display: inline-block; vertical-align: bottom; margin: 5px 5px 5px 0px; text-align: left; max-width: calc(100% - 5px); float: left;" fr-original-class="fr-draggable"><span id="isPasted" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);">QA Level 2 Award in Principles of Risk Assessment (RQF) training course is a nationally recognised, Ofqual regulated qualification accredited by&nbsp;</span><a href="https://qualsafeawards.org/" style="color: rgb(34, 177, 77); user-select: auto; font-size: var(--font-size); box-sizing: border-box; cursor: pointer; text-decoration: inherit;" target="_blank" fr-original-style=" color: rgb(34, 177, 77);">Qualsafe Awards</a><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);">.</span><br style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);"><br style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);"><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);">This means that you can be rest assured that your Principles of Risk Assessment certificate fulfils the legal requirements and is a very good way to make sure you and your employees are trained appropriately.</span><br style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);"><br style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);"><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);">The&nbsp;</span><strong style="color: rgb(0, 0, 0); font-weight: 700; box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">Ofqual Register number</strong><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);">&nbsp;for this course is&nbsp;</span><strong style="color: rgb(0, 0, 0); font-weight: 700; box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">603/0857/9</strong></div><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></p>

QA Level 2 Award In Principles Of Risk Assessment (RQF)
Face to Face: One-day course
Virtual Classroom: Spread over 3 sessions of 2½ hr duration
Don't run risks with the safety of your people - it will cost you a lot more when things start to go wrong...
Risk Assessments are vital for Health and Safety, and vital for the whole process



Course Contents:
Main causes of Work-related Fatalities, Injuries and ill health
Moral, Legal and Economic Reasons for Preventing Accidents and ill health at Work
Key Terms associated with Risk Assessments in Health and Safety at Work:AccidentNear MissAccident TriangleHazardRiskRisk AssessmentSuitable and SufficientCompetence
The Role of Risk Assessments in Accident and ill Health Prevention
Legal Requirements for Risk Assessments
Importance of Personal hygiene
Basic Process for Undertaking a Risk Assessment
The Five Steps of a Risk Assessment
Benefits of this course:
In 2020/21, a whopping 1.7 million people suffered from a work-related illness
441,000 of those sustained an injury
142 People, plus 60 members of the public, lost their lives...
The estimated cost of injuries and ill health was £15 billion
28.2 million working days, or 108,045 working years, were lost due to work-related illnesses and injuries
It is an employer's duty to protect the health, safety and welfare of their employees and other people who might be affected by their business. This includes providing sufficient information, instruction and training of employees, so they can work in a way that does not put themselves or others at risk
Our QA Level 2 Award in Principles of Risk Assessment (RQF) course is ideal for all employees, helping them to create a better understanding of health and safety issues and risk assessments



Accredited, Ofqual regulated qualification:

QA Level 2 Award in Principles of Risk Assessment (RQF) training course is a nationally recognised, Ofqual regulated qualification accredited by Qualsafe Awards.This means that you can be rest assured that your Principles of Risk Assessment certificate fulfils the legal requirements and is a very good way to make sure you and your employees are trained appropriately.The Ofqual Register number for this course is 603/0857/9



Pochat Training

Risk Assessment

Principles of Risk Assessment

<h2 id="isPasted" fr-original-style="" style="box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></h2><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">This advanced financial modelling course will benefit Real Estate Professionals looking to develop their financial modelling skills to the next level. This course is intended to the most ambitious modellers in the property industry who would like to be fully proficient in building complex real estate models.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">On this course you will...</strong></strong></p><ul fr-original-style="" style="box-sizing: border-box;"><li value="1" fr-original-style="" style="box-sizing: border-box;">Understand how the application and use of Structured Finance products in Real Estate</li><li value="2" fr-original-style="" style="box-sizing: border-box;">Learn how to introduce several tranches of debt in a development project</li><li value="3" fr-original-style="" style="box-sizing: border-box;">Understand how to model different parties to a project</li><li value="4" fr-original-style="" style="box-sizing: border-box;">Create Joint Venture structures between Developers, Lenders and Equity Partners</li><li value="5" fr-original-style="" style="box-sizing: border-box;">Learn advanced modelling techniques to analyse underlying asset risk</li><li value="6" fr-original-style="" style="box-sizing: border-box;">Understand how underlying asset risk impacts return to all parties to a project</li></ul><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Who will benefit from this course?</strong></strong></p><ul fr-original-style="" style="box-sizing: border-box;"><li value="1" fr-original-style="" style="box-sizing: border-box;">Real Estate professionals from a mid to senior level with exposure to Real Estate financial models</li><li value="2" fr-original-style="" style="box-sizing: border-box;">Mid-level to senior Real Estate Analysts who would like to advance their financial modelling skills in areas such as development, portfolio analysis, and risk analysis</li><li value="3" fr-original-style="" style="box-sizing: border-box;">Real Estate Investors who would like to expand their knowledge and understanding of Real Estate cash flow models to an advanced level</li></ul><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Course Outline</strong></strong>:</p><ul fr-original-style="" style="box-sizing: border-box;"><li value="1" fr-original-style="" style="box-sizing: border-box;">Mezzanine debt modelling</li><li value="2" fr-original-style="" style="box-sizing: border-box;">Joint Venture structures between developers and lender/equity partners</li><li value="3" fr-original-style="" style="box-sizing: border-box;">Promote and profit share structure calculations</li><li value="4" fr-original-style="" style="box-sizing: border-box;">Advanced project cash flows with mezzanine debts</li><li value="5" fr-original-style="" style="box-sizing: border-box;">Key Real Estate and investment risks, risk adjustment of exit yields</li><li value="6" fr-original-style="" style="box-sizing: border-box;">Sensitivity and Scenario Analysis</li><li value="7" fr-original-style="" style="box-sizing: border-box;">Monte Carlo Analysis</li></ul><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Included in the Course</strong></strong></p><ul fr-original-style="" style="box-sizing: border-box;"><li value="1" fr-original-style="" style="box-sizing: border-box;">CPD Accredited Certificate &amp; LinkedIn Proficiency Badge</li><li value="2" id="isPasted" fr-original-style="" style="box-sizing: border-box;">Course Manual - In-Person Course attendees will receive a Physical Copy, Virtual Course attendees will receive a Virtual Copy and have the option to purchase a Hard Copy at an additional fee</li><li value="3" fr-original-style="" style="box-sizing: border-box;">Course Files</li><li value="4" fr-original-style="" style="box-sizing: border-box;">Online Learning Platform access - Further Learning Resources (Reading, Files and Videos)</li><li value="5" fr-original-style="" style="box-sizing: border-box;">Post Course Support - Two Months of Questions &amp; Answers, and One year of support is available for an additional fee</li></ul><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></p><p id="isPasted" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">For more information about the Real Estate Modelling Masterclass such as course delivery methods, pricing and dates, please contact Sam on the Bayfield Training Sales team:</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">E - s.musgrave@bayfieldtraining.com</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">T - 01223 517851</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">W - <a href="https://www.bayfieldtraining.com/" target="_blank" rel="nofollow noopener noreferrer ugc" title="https://www.bayfieldtraining.com/" data-airgap-id="125" fr-original-style="" style="user-select: auto; font-size: var(--font-size); box-sizing: border-box; cursor: pointer; text-decoration: inherit;">www.bayfieldtraining.com</a></p>



This advanced financial modelling course will benefit Real Estate Professionals looking to develop their financial modelling skills to the next level. This course is intended to the most ambitious modellers in the property industry who would like to be fully proficient in building complex real estate models.


On this course you will...
Understand how the application and use of Structured Finance products in Real Estate
Learn how to introduce several tranches of debt in a development project
Understand how to model different parties to a project
Create Joint Venture structures between Developers, Lenders and Equity Partners
Learn advanced modelling techniques to analyse underlying asset risk
Understand how underlying asset risk impacts return to all parties to a project


Who will benefit from this course?
Real Estate professionals from a mid to senior level with exposure to Real Estate financial models
Mid-level to senior Real Estate Analysts who would like to advance their financial modelling skills in areas such as development, portfolio analysis, and risk analysis
Real Estate Investors who would like to expand their knowledge and understanding of Real Estate cash flow models to an advanced level


Course Outline:
Mezzanine debt modelling
Joint Venture structures between developers and lender/equity partners
Promote and profit share structure calculations
Advanced project cash flows with mezzanine debts
Key Real Estate and investment risks, risk adjustment of exit yields
Sensitivity and Scenario Analysis
Monte Carlo Analysis


Included in the Course
CPD Accredited Certificate & LinkedIn Proficiency Badge
Course Manual - In-Person Course attendees will receive a Physical Copy, Virtual Course attendees will receive a Virtual Copy and have the option to purchase a Hard Copy at an additional fee
Course Files
Online Learning Platform access - Further Learning Resources (Reading, Files and Videos)
Post Course Support - Two Months of Questions & Answers, and One year of support is available for an additional fee


For more information about the Real Estate Modelling Masterclass such as course delivery methods, pricing and dates, please contact Sam on the Bayfield Training Sales team:
E - s.musgrave@bayfieldtraining.com
T - 01223 517851
W - www.bayfieldtraining.com

Real Estate Finance

Investment Management

This course is intended to the most ambitious modellers in the property industry who would like to be fully proficient in building complex real estate models.

6862 Courses

Optimizing Productivity Through Slack Efficiency

By Compete High

SC-900T00 Microsoft Security Compliance and Identity Fundamentals

By Nexus Human

PL-200T00 Microsoft Power Platform Functional Consultant

By Nexus Human

Managing Meetings

By Lapd Solutions Ltd

Mastering Microsoft Office: Word, Excel, PowerPoint, and 365

By St. Paul's College

AZ-700T00 Designing and Implementing Microsoft Azure Networking Solutions

By Nexus Human

Microsoft 365 Office for the Web Productivity Apps v2.0

By Nexus Human

Motivating People

By Skillogy International

Transforming Leadership

By Skillogy International

55337 Introduction to Programming

By Nexus Human

Search By Location