Name: Microsoft Excel: Automated Dashboard Using Advanced Formula, VBA, Power Query
Price: 12 GBP
Availability: InStock

<div id="course-pills-1">Duration<p>5 Days</p><p>30 CPD hours</p>This course is intended for<p>The primary audience for this course are Application Consultants, Business Process Architects, and Business Process Owners/Team Leads/Power Users.</p>Overview<p>This course will prepare you to:Describe tasks performed by a typical SAP Access Control userDiscuss Harmonization topics as they relate to SAP Access ControlExplain how SAP GRC helps you to address business challengesIdentify authorization risks in typical business processesDescribe the Segregation of Duties Risk Management ProcessDescribe and configure functionality and features for SAP Access Control 10.1Use the SAP Access Control 10.1 application to analyze and manage risk, design and manage roles, and provision and manage usersDescribe the SAP Access Control 10.1 architecture and landscape, SAP Access Control Repository, and Object Level SecurityDescribe the Periodic Access Review processPlan for and manage emergency accessDiscuss the reporting frameworkConfigure workflows, including multi-stage multi-path (MSMP) workflows and BRF+Describe how the different applications of the SAP GRC Solution integrate with each otherDiscuss key steps in the SAP Access Control implementation process</p><p>In this course, students gain hands-on configuration and implementation experience of SAP Access Control 10.1, as well as important concepts they will need to know in order to prepare for implementation and ongoing access risk prevention.</p></div><div id="course-pills-2"><h4>Introduction to SAP Access Control</h4><ul><li>Discussing Business Challenges and Solutions</li><li>Using SAP Access Control</li></ul><h4>Architecture, Security, and Authorizations</h4><ul><li>Describing the System Architecture</li><li>Describing Security and Authorizations</li></ul><h4>Shared Configuration Settings</h4><ul><li>Configuring Shared GRC Settings</li><li>Configuring Shared SAP Access Control Settings</li></ul><h4>Authorization Risks and the Segregation of Duties (SoD) Management Process</h4><ul><li>Identifying Authorization Risks</li><li>Managing Risk by Segregating Duties</li></ul><h4>SAP Access Control Repository</h4><ul><li>Synchronizing Objects into the Repository</li><li>Scheduling and Viewing Background Jobs</li></ul><h4>Risk Analysis</h4><ul><li>Maintaining Shared Master Data</li><li>Configuring and Maintaining the Rule Set</li><li>Configuring and Using Audit Trail Tracking</li><li>Using the Risk Analysis Framework</li><li>Remediating Risks</li><li>Mitigating Risks</li><li>Mitigating Multiple Risks at One Time</li></ul><h4>Business Rule Framework</h4><ul><li>Creating Rules in the Business Rule Framework (BRF)</li><li>Defining Business Rules</li></ul><h4>Multi-Stage, Multi-Path (MSMP) Workflow</h4><ul><li>Describing Multi-Stage, Multi-Path (MSMP) Workflow</li><li>Maintaining MSMP Workflow</li><li>Building MSMP Workflow</li></ul><h4>User Provisioning</h4><ul><li>Configuring User Provisioning Settings</li><li>Configuring Access Request Forms</li><li>Requesting Access</li><li>Preparing Roles and Owner Data for MSMP Workflow</li><li>Creating Simplified Access Requests</li><li>Reviewing Search Request Results</li></ul><h4>SAP Fiori User Experience (UX) for GRC</h4><ul><li>Describing SAP Fiori UX</li></ul><h4>Role Design and Management</h4><ul><li>Configuring Role Management</li><li>Configuring Role Methodology</li><li>Configuring Role Search Attributes</li><li>Planning for Technical Role Definition</li><li>Planning for Business Role Definition</li><li>Consolidating Roles Through Role Mining</li><li>Performing Role Mass Maintenance Operations</li></ul><h4>Emergency Access Management</h4><ul><li>Describing Emergency Access Management</li><li>Planning for Emergency Access</li><li>Monitoring Emergency Access</li></ul><h4>Periodic Access Review Process</h4><ul><li>Planning Periodic Review</li><li>Monitoring Periodic Review</li></ul><h4>Reports and Custom Fields</h4><ul><li>Use the Reporting Framework</li></ul><h4>SAP Access Control Implementation</h4><ul><li>Using the SAP Access Control Implementation Process</li><li>Designing the SAP Access Control Solution</li><li>Planning Upgrade and Migration</li><li>Configuring SAP Access Control</li><li>Implementing the SAP Access Control solution</li><li>Optimizing the SAP Access Control Suite</li></ul></div><div id="course-pills-3"><h4>Additional course details:</h4><br /><p>Nexus Humans GRC300 SAP Access Control Implementation and Configuration 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 GRC300 SAP Access Control Implementation and Configuration 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>

Nexus Human

SAP Human Capital Management

SAP Finance & Controlling

SAP Project

SAP ABAP

SAP Fiori

GRC300 SAP Access Control Implementation and Configuration

<div id="course-pills-1">Duration<p>4 Days</p><p>24 CPD hours</p>This course is intended for<p>This advanced course is the third in a series of three classes designed for RPG IV programmers. Programming experience using RPG IV is mandatory when enrolling in this course. You should have attended RPG IV Programming Fundamentals Workshop for IBM i (AS060) and RPG IV Programming Intermediate Workshop for IBM i (AS070).<br /><br />This course is not designed for RPG III programmers who want RPG IV.<br /><br />RPG III programmers should review the agenda carefully before they make a decision to attend this class. </p>Overview<p>Use address pointers and user spaces in RPG IV programs<br />Write database triggers in RPG IV<br />Develop ILE modular objects and package them in service programs<br />Explain the purpose of ILE activation groups<br />Explain the behavior of error handling and percolation in ILE<br />Code an ILE error handling program<br />Call application program interfaces (APIs) from RPG IV program</p><p>Programmers who can write comprehensive RPG IV programs using the IBM i RPG IV compiler (v7), learn additional skills &amp; techniques.<br /><br />Comprehensive exposure to advanced features of the Integrated Language Environment (ILE) RPG compiler and the IBM i.</p></div><div id="course-pills-2">Programmers who can write comprehensive RPG IV programs using the IBM i RPG IV compiler (v7), learn additional skills &amp; techniques.<br /><br />Comprehensive exposure to advanced features of the Integrated Language Environment (ILE) RPG compiler and the IBM i.</div>

AS10 IBM RPG IV Programming Advanced Workshop for IBM i

<div id="course-pills-1">Duration<p>5 Days</p><p>30 CPD hours</p>This course is intended for<p>Application Consultants, Developers, Solutions Architects, and System Administrators.</p>Overview<p>Work with SAP Fiori ApplicationsUnderstand and leverage the architectures and principles of SAP Fiori and SAP UX DesignConfigure and customize SAP FioriConnect SAP Fiori with other technologies</p><p>This course provides participants with an overview of Fiori Design Principles.</p></div><div id="course-pills-2"><h4>End-User Perspective</h4><ul><li>Explore the Design of SAP Fiori</li><li>Explore the SAP Fiori Launchpad</li><li>Explore SAP Fiori Data Handling</li><li>Personalize SAP Fiori</li></ul><h4>Foundation</h4><ul><li>Explain User Interfaces</li><li>Explain Data Services</li><li>Explain Application Types</li></ul><h4>Architecture</h4><ul><li>Examine SAP Fiori for Suite on Any DB</li><li>Examine SAP Fiori for Suite on HANA</li><li>Examine SAP Fiori for S/4HANA</li><li>Examine SAP Fiori Mobile</li></ul><h4>Configuration</h4><ul><li>Create SAP Fiori Groups</li><li>Create SAP Fiori Catalogs</li><li>Create LPD_CUST Target Mappings</li><li>Create SAPUI5 Fiori Target Mappings</li><li>Create Web Dynpro Target Mappings</li><li>Create Transaction Target Mappings</li><li>Configure Analytical Applications</li></ul><h4>Theming</h4><ul><li>Use the UI Theme Designer</li><li>Use SAP Screen Personas</li></ul><h4>Integration</h4><ul><li>Integrate SAP Workflow</li><li>Operate SAP Fiori Standalone</li><li>Explore SAP HANA Cloud Platform</li></ul></div><div id="course-pills-3"><h4>Additional course details:</h4><br /><p>Nexus Humans UX100 SAP Fiori - Foundation 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 UX100 SAP Fiori - Foundation 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>

Service Design Courses (SDC)

SAP S/4HANA

UI / UX Design

UX100 SAP Fiori - Foundation

<div id="course-pills-1">Duration<p>2 Days</p><p>12 CPD hours</p>This course is intended for<p>Implementation Consultants<br />Key Technical Business Users involved in a GRC 12.0 project<br />IT Governance Experts<br />Consultants for SAP Security and GRC IT Auditors<br />Business Project Team Leaders</p>Overview<p>This course will prepare you to:<br />Introduce SAP Governance, Risk, and Compliance (GRC) 12.0<br />Identify key governance, risk, and compliance processes supported in the SAP GRC 12.0 solution<br />Describe key features and business benefits of the integrated solution<br />Identify applications that integrate with the SAP GRC 12.0 solution<br />Describe the purpose and location of key user interface components<br />Discuss harmonized navigation and how authorizations affect what users see<br />Describe how common functions and relative master data are shared across the SAP GRC solutions<br />Describe the IMG organization for GRC 12.0<br />Describe a general implementation process and key steps</p><p>This course provides foundation knowledge for SAP Governance, Risk and Compliance (GRC) 12.0. By gaining familiarity with this solution?s harmonized navigation, common functions, shared master data, and the harmonized reporting framework, you will be better able to get the most value out of using the integrated applications in SAP GRC.</p></div><div id="course-pills-2"><h4>Introduction to SAP Governance, Risk, and compliance (GRC) 12.0</h4><ul><li>Solution Introduction</li><li>Solution Overview ? Enterprise Risk and Compliance</li><li>Solution Overview ? Access Governance</li><li>Solution Overview ? International Trade Management</li><li>Solution Overview ? Cybersecurity</li></ul><h4>Information Architecture, Security, and Authorizations</h4><ul><li>Understanding the SAP Fiori Concept and Architecture</li><li>Security and Authorizations</li></ul><h4>The SAP GRC 12.0 User Interface</h4><ul><li>Work Centers</li><li>SAP Fiori</li></ul><h4>Common Functions and Data</h4><ul><li>User Interface Configuration Framework</li><li>Shared Master Data</li></ul><h4>Implementation and Configuration</h4><ul><li>Streamlined Configuration</li></ul><h4>Reporting</h4><ul><li>Harmonized Reporting Framework</li><li>SAP HANA Integration</li></ul></div>

SAP Financial Accounting

GRC100 Principles of SAP Governance, Risk, and Compliance

<div id="course-pills-1">Duration<p>3 Days</p><p>18 CPD hours</p>This course is intended for<p>Anyone starting to write SAS programs</p>Overview<p>Use SAS Studio and SAS Enterprise Guide to write and submit SAS programs.<br />Access SAS, Microsoft Excel, and text data.<br />Explore and validate data.<br />Prepare data by subsetting rows and computing new columns.<br />Analyze and report on data.<br />Export data and results to Excel, PDF, and other formats.<br />Use SQL in SAS to query and join tables.</p><p>This course is for users who want to learn how to write SAS programs to access, explore, prepare, and analyze data. It is the entry point to learning SAS programming for data science, machine learning, and artificial intelligence.</p></div><div id="course-pills-2"><h4>Essentials</h4><ul><li>The SAS programming process.</li><li>Using SAS programming tools.</li><li>Understanding SAS syntax.</li></ul><h4>Accessing Data</h4><ul><li>Understanding SAS data.</li><li>Accessing data through libraries.</li><li>Importing data into SAS.</li></ul><h4>Exploring and Validating Data</h4><ul><li>Exploring data.</li><li>Filtering rows.</li><li>Formatting columns.</li><li>Sorting data and removing duplicates.</li></ul><h4>Preparing Data</h4><ul><li>Reading and filtering data.</li><li>Computing new columns.</li><li>Conditional processing.</li></ul><h4>Analyzing and Reporting on Data</h4><ul><li>Enhancing reports with titles, footnotes, and labels.</li><li>Creating frequency reports.</li><li>Creating summary statistics reports.</li></ul><h4>Exporting Results</h4><ul><li>Exporting data.</li><li>Exporting reports.</li></ul><h4>Using SQL in SAS</h4><ul><li>Using Structured Query Language in SAS.</li><li>Joining tables using SQL in SAS.</li></ul></div><div id="course-pills-3"><h4>Additional course details:</h4><br /><p>Nexus Humans SAS Programming 1 - Essentials 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 SAS Programming 1 - Essentials 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>

SIA Training

Professional Skills Course (PSC)

Trainers Course

Ssas

SAS Programming 1 - Essentials

<div id="course-pills-1">Duration<p>2 Days</p><p>12 CPD hours</p>This course is intended for<p>Application Consultants, Business Analysts, and Program Managers</p>Overview<p>Describe how to organize and run payroll including subsequent activities and problem-solving aids</p><p>This course provides the mandatory foundation knowledge required for processing payroll transactions in SAP HCM.</p></div><div id="course-pills-2"><h4>Payroll Overview</h4><ul><li>Setting Up the User Interface</li><li>Identifying Payroll Elements</li></ul><h4>Payroll Data</h4><ul><li>Entering payroll data</li></ul><h4>Payroll Elements</h4><ul><li>Organizing a Payroll Run</li><li>Reviewing the Payroll Status Infotype</li><li>Identifying Retroactive Payroll Entries</li></ul><h4>Payroll Process</h4><ul><li>Running Payroll</li></ul><h4>Payroll Reports</h4><ul><li>Reporting on Payroll</li><li>Generating Remuneration Statements</li><li>Analyzing Payroll Results</li><li>Analyzing Wage Types</li><li>Reviewing Ad Hoc Query Functionality</li></ul><h4>Post Payroll Results</h4><ul><li>Posting Environments</li><li>Verifying a Posting Run</li><li>Updating a Live Posting Run</li><li>Verifying Documents</li></ul><h4>Bank Transfers &amp; Check Preparation</h4><ul><li>Generating Employee Payments</li></ul><h4>Process Model</h4><ul><li>Running a Payroll Process Model</li></ul><h4>SuccessFactors Employee Central Payroll</h4><ul><li>Outling employee central payroll basics</li></ul></div>

Certified Payroll Professional (CPP)

Sage Payroll

Payroll

HR110 SAP Business Processes in HCM Payroll

<div id="course-pills-1">Duration<p>5 Days</p><p>30 CPD hours</p>This course is intended for<p>Implmentation Consultants, Business Users, IT Governance Experts, Compliance Managers</p>Overview<p>Discuss the purpose and business use of Process ControlDescribe key features and related harmonization topicsDescribe risk-based internal controlsConfigure Process Control customizing settings and those shared across GRCCreate and manage master dataDiscuss security and authorization requirementsImplement the Process Control solutionUse risk-managed financial compliance practicesPlan and process surveys and testsSet up and maintain Continuous MonitoringIntegrate and use Process Control with Policy ManagementDiscuss operational complianceAggregate deficienciesUse the harmonized reporting frameworkDescribe the use of custom-defined fields and document search</p><p>This course offers hands-on configuration and implementation of SAP Process Control 10.1, as well as important concepts you will need to know in order to prepare for implementation and ongoing prevention of process risk.</p></div><div id="course-pills-2"><h4>Enterprise Goverance, Riskl, and Compliance (eGRC)</h4><ul><li>Risk-Based Approach to Managing Compliance Initiatives</li><li>Integrated GRC Approach</li></ul><h4>Governance</h4><ul><li>Governance Overview</li><li>Governance Using Process Control 10.1</li><li>Daily Business Use</li></ul><h4>Harmonization Overview</h4><ul><li>Harmonization Concepts</li><li>Work Centers</li><li>Setting Up an Entry Page</li><li>Technical Landscape</li></ul><h4>Configuration Requirements</h4><ul><li>Customizing Central Tasks</li><li>Shared Master Data and Reports</li><li>Workflow</li><li>Authorization Updates</li><li>Process Control-Specific Customizing</li></ul><h4>Create &amp; Manage Master Data</h4><ul><li>Master Data Overview</li><li>Setting Up an Organization Hierarchy</li><li>Setting Up the Account Group Hierarchy</li><li>Setting Up the Central Process Hierarchy</li><li>Setting Up the Indirect Entity-Level Control Hierarchy</li><li>Harmonized Risk Model</li><li>Uploading Master Data with MDUG</li><li>Content Lifecycle Management</li><li>Master Data Change Request Workflow</li></ul><h4>Surveys and Manual Tests</h4><ul><li>Survey and Test Overview</li><li>Planner Overview</li><li>Assessment Survey</li><li>Manual Test</li><li>Manual Test ? Offline Forms and Data Sheets</li><li>Disclosure Survey</li><li>Issue Remediation</li></ul><h4>Risk-Managed Financial Compliance</h4><ul><li>Risk-Based Financial Compliance</li><li>Materiality Analysis</li><li>Risk Assessment</li><li>Control Risk Rating</li><li>Test Strategy</li><li>Risk Coverage Analysis</li><li>Integration with SAP Audit Management</li></ul><h4>Ad Hoc Issues</h4><ul><li>Ad Hoc Issues</li><li>Integration with SAP Fraud Management</li></ul><h4>Policy Management</h4><ul><li>Policy Management ? Overview</li><li>Configuring Policy Management</li><li>Policy Lifecycle Management</li></ul><h4>Continuous Monitoring</h4><ul><li>Continuous Monitoring ? Overview</li><li>Continuous Monitoring ? Preconfiguration</li><li>Creating a Data Source</li><li>Creating a Business Rule</li><li>Assigning Business Rules to a Control</li><li>Scheduling a Continuous Monitoring Job</li><li>Monitoring a Continuous Monitoring Job</li><li>SAP Queries</li><li>SAP BW Query</li><li>Setting Up a Configurable Rule Subscenario</li><li>Create a Programmed Rule</li><li>ABAP Reports</li><li>Process Integration Subscenario</li><li>SoD Integration</li><li>Web Service for Continuous Monitoring</li><li>Event-Based Monitoring</li><li>SAP HANA Views</li><li>New CCM Content Upload Capabilities</li></ul><h4>Operational Compliance Overview</h4><ul><li>Operational Compliance Overview and Key Trends</li><li>CAPA</li><li>Operational Compliance-Specific Focus in CCM</li></ul><h4>Closing Activies in an ICS Management Cycle</h4><ul><li>Sign-Off</li><li>Aggregation of Deficiencies</li></ul><h4>Reporting</h4><ul><li>Reports Overview</li><li>Report Framework Harmonization</li><li>Dashboard Overview</li></ul><h4>Security &amp; Authorization</h4><ul><li>Security and Authorization ? Overview</li><li>Authorization Configuration and Setup</li></ul><h4>Implementation Scope and Approach</h4><ul><li>Implementation Scope and Approach</li></ul><h4>Establishing a Compliance Framework</h4><ul><li>Configuring a Multi-Compliance Framework (MCF)</li></ul><h4>Other Process Control Features</h4><ul><li>Custom-Defined Fields</li><li>Document Search</li></ul></div>

SAP Process Orchestration

GRC330 SAP Process Control 10.1 - Implementation and Configuration

<h3><b>Overview</b></h3>
<span>This comprehensive course on Microsoft Excel: Excel Sheet Comparison with VBA will deepen your understanding on this topic.</span>

<span>After successful completion of this course you can acquire the required skills in this sector. This Microsoft Excel: Excel Sheet Comparison with VBA comes with accredited certification which will enhance your CV and make you worthy in the job market.</span>

<span>So enrol in this course today to fast track your career ladder.</span>
<h3><b>How will I get my certificate?</b></h3>
You may have to take a quiz or a written test online during or after the course. After successfully completing the course, you will be eligible for the certificate.
<h3><b>Who is this course for?</b></h3>
<span>There is no experience or previous qualifications required for enrolment on this <strong>Microsoft Excel: Excel Sheet Comparison with VBA</strong></span><span>. It is available to all students, of all academic backgrounds.</span>
<h3><b>Requirements</b></h3>
<span>Our <strong>Microsoft Excel: Excel Sheet Comparison with VBA</strong></span><span> is fully compatible with PC's, Mac's, Laptop,Tablet and Smartphone devices. This course has been designed to be fully compatible on tablets and smartphones so you can access your course on wifi, 3G or 4G.</span>

<span>There is no time limit for completing this course, it can be studied in your own time at your own pace.</span>
<h3><b>Career path</b></h3>
<span>Having these various qualifications will increase the value in your CV and open you up to multiple sectors such as Business &amp; Management, Admin, Accountancy &amp; Finance, Secretarial &amp; PA, Teaching &amp; Mentoring etc.</span> <h3>Course Curriculum</h3><div><p>6 sections • 23 lectures • 02:10:00 total length</p></div><div><div><div><div><div><div><div><p>•Introduction to Compare Data Workbook: 00:06:00</p></div><div><div><p>•Download Resources: 00:00:00</p></div><div><div><p>•Key requirements for Comparing any Datasets or Worksheets: 00:03:00</p></div><div><div><p>•Tool to Compare Datasets or Worksheets: 00:06:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Overview of Compare Data Workbook: 00:09:00</p></div><div><div><p>•Most Important things to remember before you use compare data workbook: 00:03:00</p></div><div><div><p>•IMPORTANT - First Column as KEY Column with UNIQUE Values: 00:09:00</p></div><div><div><p>•Deep Dive into Compare Data Workbook's Environment: 00:10:00</p></div><div><div><p>•How to Change Header Rows for your data: 00:06:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Basics of Using macro enabled Excel files and Code Modules: 00:04:00</p></div><div><div><p>•Changing the Main two sheets name, variance tags in VBA Code: 00:05:00</p></div><div><div><p>•Changing various elements across VBA Code modules: 00:05:00</p></div><div><div><p>•Clear Sheet data button VBA Code: 00:04:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Convert Row data into Structured, clean and formatted data with Power Query 1: 00:07:00</p></div><div><div><p>•Convert Row data into Structured, clean and formatted data with Power Query 2: 00:07:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Mutual Funds Portfolio - Finding Variances at two different times: 00:07:00</p></div><div><div><p>•Comprehensive Payroll Analysis - Creating Powerful Dashboard 1: 00:05:00</p></div><div><div><p>•Comprehensive Payroll Analysis - Creating Powerful Dashboard 2: 00:07:00</p></div><div><div><p>•Comprehensive Payroll Analysis - Creating Powerful Dashboard 3: 00:08:00</p></div><div><div><p>•Comprehensive Payroll Analysis - Creating Powerful Dashboard 4: 00:07:00</p></div><div><div><p>•Comprehensive Payroll Analysis - Creating Powerful Dashboard 5: 00:08:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•IMPORTANT Facts and Limitation of Compare Data Workbook: 00:03:00</p></div><div><div><p>•Conclusion: 00:01:00</p></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div>

Apex Learning

Microsoft Certification

Finance Cert & Exam Prep

Access VBA

Microsoft Excel

Certification in Cash & Voucher Assistant (CVA)

Spreadsheet

Microsoft Excel: Excel Sheet Comparison with VBA

General Admission

<h2><b>Overview</b></h2>
<span>This </span><b>Microsoft Excel Course for Everyone - Complete Excel Course</b><span> is your passport to spreadsheet mastery.</span>

<span>Explore Excel in detail and improve your abilities with practical activities that go beyond boring lectures. Take on spreadsheets like an expert, from data entry to difficult formulas and eye-catching graphics. </span>

<span>But the magic doesn't end there! After finishing successfully, you'll not only impress with your proficiency with Excel, but you'll also obtain a respected <strong>CPD certification</strong> to enhance your CV and make a statement in the job market. Consider it your golden ticket to go up in your job!</span>

<span>Enrol right away to see how your confidence and chances rise! Don't wait!</span>
<h2><b>How will I get my certificate?</b></h2>
<span>You may have to take a quiz or a written test online during or after the course. After successfully completing the course, you will be eligible for the certificate.</span>
<h2><b>Who is This course for?</b></h2>
<span>There is no experience or previous qualifications required for enrolment on this </span><b>Microsoft Excel Course for Everyone - Complete Excel Course</b><span>. It is available to all students, of all academic backgrounds.</span>
<h2><b>Requirements</b></h2>
<ul>
 	<li><span>Compatible with a wide range of gadgets, including smartphones, tablets, laptops, Macs, and PCs.</span></li>
 	<li><span>Particularly designed to be easily accessed with an internet connection on tablets and smartphones.</span></li>
 	<li><span>No strict deadlines; learn whenever it's convenient for you.</span></li>
 	<li><span>Individuals with basic English proficiency.</span></li>
</ul>
<h2><b>Career Path</b></h2>
<span>After completing this course, it will increase the value of your CV and open you up to multiple sectors, such as :  </span>
<ul>
 	<li><b>Data Analyst: </b><span>£25,000 - £50,000 per year</span></li>
 	<li><b>Financial Analyst:</b><span> £30,000 - £60,000 per year</span></li>
 	<li><b>Operations Manager:</b><span> £35,000 - £70,000 per year</span></li>
 	<li><b>Accountant:</b><span> £25,000 - £50,000 per year</span></li>
 	<li><b>Business Intelligence Analyst:</b><span> £35,000 - £65,000 per year</span></li>
</ul>
<span>These salary ranges can vary based on factors such as experience, location, and the specific industry of the business.</span> <h3>Course Curriculum</h3><div><p>15 sections • 80 lectures • 06:51:00 total length</p></div><div><div><div><div><div><div><div><p>•Introduction: 00:03:00</p></div><div><div><p>•Course Curriculum: 00:04:00</p></div><div><div><p>•Getting started on Windows, macOS, Android, and IOS: 00:01:00</p></div><div><div><p>•How to ask great questions: 00:02:00</p></div><div><div><p>•FAQ's: 00:01:00</p></div><div><div><p>•Starting Excel: 00:04:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Introduction: 00:02:00</p></div><div><div><p>•Worksheet basics: 00:22:00</p></div><div><div><p>•Entering values and formulas: 00:12:00</p></div><div><div><p>•Data formats: 00:10:00</p></div><div><div><p>•Data handling basics - cut copy and paste: 00:07:00</p></div><div><div><p>•Save and print in excel: 00:10:00</p></div><div><div><p>•Excel Ranges: 00:05:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Introduction: 00:01:00</p></div><div><div><p>•Basic formula operations: 00:06:00</p></div><div><div><p>•Mathematical functions level 1: 00:20:00</p></div><div><div><p>•Mathematical functions level 2: 00:12:00</p></div><div><div><p>•Text functions level 1: 00:09:00</p></div><div><div><p>•Text functions level 2: 00:13:00</p></div><div><div><p>•Logical functions: 00:11:00</p></div><div><div><p>•Date time functions: 00:06:00</p></div><div><div><p>•V Lookup formula: 00:12:00</p></div><div><div><p>•HLookup formula: 00:04:00</p></div><div><div><p>•HLookup + Match formula: 00:09:00</p></div><div><div><p>•Match + Index formula: 00:05:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Introduction: 00:02:00</p></div><div><div><p>•XLookup: 00:08:00</p></div><div><div><p>•Handling #NA and Approximates match in XLookup: 00:11:00</p></div><div><div><p>•Wildcard matching in XLookup: 00:06:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Introduction: 00:02:00</p></div><div><div><p>•Split text into columns: 00:07:00</p></div><div><div><p>•Flash Fill: 00:07:00</p></div><div><div><p>•Remove Duplicates: 00:08:00</p></div><div><div><p>•Data Validation: 00:07:00</p></div><div><div><p>•Get- import Data from Text: 00:06:00</p></div><div><div><p>•Get - import Data from CSV: 00:03:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Introduction: 00:01:00</p></div><div><div><p>•Formatting Font: 00:04:00</p></div><div><div><p>•Formatting Alignment: 00:06:00</p></div><div><div><p>•Formatting Number: 00:05:00</p></div><div><div><p>•Formatting Date: 00:03:00</p></div><div><div><p>•Formatting tables: 00:05:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Introduction: 00:01:00</p></div><div><div><p>•Creating Pivot Table: 00:07:00</p></div><div><div><p>•Value field settings: 00:04:00</p></div><div><div><p>•Number format: 00:02:00</p></div><div><div><p>•Pivot Table Design: 00:03:00</p></div><div><div><p>•Excel Exercise: 00:01:00</p></div><div><div><p>•Solution for Excel Exercise: 00:02:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Introduction: 00:01:00</p></div><div><div><p>•Excel Charts - Categories: 00:03:00</p></div><div><div><p>•Elements of a chart: 00:04:00</p></div><div><div><p>•Easy way to create charts: 00:02:00</p></div><div><div><p>•Column or Bar charts: 00:04:00</p></div><div><div><p>•Formatting charts: 00:04:00</p></div><div><div><p>•Line charts: 00:02:00</p></div><div><div><p>•Area charts: 00:02:00</p></div><div><div><p>•Pie and Doughnut charts: 00:04:00</p></div><div><div><p>•Format AreaPlot or XY chart: 00:08:00</p></div><div><div><p>•Scatter or bubble charts: 00:02:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Introduction: 00:01:00</p></div><div><div><p>•Frequency Distribution and Histograms: 00:04:00</p></div><div><div><p>•Waterfall charts: 00:02:00</p></div><div><div><p>•Hierarchy charts: sunburst and tree map: 00:03:00</p></div><div><div><p>•Combination charts: 00:02:00</p></div><div><div><p>•Sparklines: 00:05:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Pivot charts: 00:02:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Maps chart: 00:04:00</p></div><div><div><p>•3D Maps chart: 00:03:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Introduction: 00:01:00</p></div><div><div><p>•Stock charts: 00:02:00</p></div><div><div><p>•Radar charts: 00:02:00</p></div><div><div><p>•Surface charts: 00:02:00</p></div><div><div><p>•Heat maps: 00:04:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Named ranges: 00:05:00</p></div><div><div><p>•Indirect Name range Function: 00:06:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Import Data table from PDF file - Excel 2021: 00:04:00</p></div><div><div><p>•Import Data from Website - Excel 2019 above: 00:09:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Project: Sales forecast tracker: 00:07:00</p></div><div><div><p>•Product Sale Tax invoice: Tax Calculations: 00:05:00</p></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div>

Online Course Creation

Computing Skills

Microsoft Excel Course for Everyone - Complete Excel Course

<h3><strong>Overview</strong></h3>
This comprehensive course on <strong>Microsoft Excel: Automated Dashboard Using Advanced Formula, VBA, Power Query </strong>will deepen your understanding <span>on this topic.</span>

After successful completion of this course you can acquire the required skills in this sector. This <strong>Microsoft Excel: Automated Dashboard Using Advanced Formula, VBA, Power Query</strong> comes with accredited certification which will enhance your CV and make you worthy in the job market.

So enrol in this course today to fast track your career ladder.
<h3><strong>How will I get my certificate?</strong></h3>
You may have to take a quiz or a written test online during or after the course. After successfully completing the course, you will be eligible for the certificate.
<h3><strong>Who is this course for?</strong></h3>
There is no experience or previous qualifications required for enrolment on this <strong>Microsoft Excel: Automated Dashboard Using Advanced Formula, VBA, Power Query</strong>. It is available to all students, of all academic backgrounds.
<h3><strong>Requirements</strong></h3>
Our <strong>Microsoft Excel: Automated Dashboard Using Advanced Formula, VBA, Power Query</strong> is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible on tablets and smartphones so you can access your course on wifi, 3G or 4G.

There is no time limit for completing this course, it can be studied in your own time at your own pace.
<h3><strong>Career path</strong></h3>
Having these various qualifications will increase the value in your CV and open you up to multiple sectors such as Business &amp; Management, Admin, Accountancy &amp; Finance, Secretarial &amp; PA, Teaching &amp; Mentoring etc. <h3>Course Curriculum</h3><div><p>12 sections • 76 lectures • 06:08:00 total length</p></div><div><div><div><div><div><div><div><p>•Course Outline and Introduction: 00:04:00</p></div><div><div><p>•Minimum Requirements for the Course: 00:01:00</p></div><div><div><p>•Prepayments Introduction: 00:01:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Month End Date Prepaid Expenses Amortization Calculation: 00:00:00</p></div><div><div><p>•Exact Prepaid Expenses Payment Date Calculation: 00:00:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Prepaid Expenses Accounting Definition: Prepayments: 00:03:00</p></div><div><div><p>•Prepaid Expense Example: How Accounting works for Prepayments: 00:03:00</p></div><div><div><p>•Advantages and Disadvantages of Prepaid Expenses: 00:03:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Introduction to PRO Excel Models and Formulas: 00:06:00</p></div><div><div><p>•Date Function: 00:05:00</p></div><div><div><p>•EOMONTH Function: 00:04:00</p></div><div><div><p>•DATEVALUE function: 00:03:00</p></div><div><div><p>•IF Function: 00:08:00</p></div><div><div><p>•IFS Function (Office 365 Only): 00:07:00</p></div><div><div><p>•VLOOKUP Function: 00:07:00</p></div><div><div><p>•MATCH Function: 00:05:00</p></div><div><div><p>•INDIRECT Function: 00:02:00</p></div><div><div><p>•NAMED Ranges: Name Manager: 00:03:00</p></div><div><div><p>•Advanced Version of VLOOKUP Function: 00:07:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Introduction to Model and Control Panel Tab (Important Sheet Tab): 00:08:00</p></div><div><div><p>•Formula Based Prepaid Expenses Model - Deep Dive (Part 1): 00:05:00</p></div><div><div><p>•Formula Based Prepaid Expenses Model - Deep Dive (Part 2): 00:06:00</p></div><div><div><p>•Formula Based Prepaid Expenses Model - Deep Dive (Part 3): 00:06:00</p></div><div><div><p>•IFS Function - Month End date Prepayment calculation: 00:04:00</p></div><div><div><p>•Prepaid Expenses - Closing Balance Summary Tab (Formula Based Summary): 00:09:00</p></div><div><div><p>•Protecting Formulas Cells and Fields in the Model: 00:04:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Exact Date Prepaid Amortisation calculation Intro: 00:03:00</p></div><div><div><p>•Formulas update and Model Changes for Exact Prepaid Exps Calculation: 00:03:00</p></div><div><div><p>•Formulas Update for Exact Date Prepaid Exps Amortisation (Part 1): 00:04:00</p></div><div><div><p>•Formulas Update for Exact Date Prepaid Exps Amortisation (Part 2): 00:03:00</p></div><div><div><p>•Formulas Update for Exact Date Prepaid Exps Amortisation (Part 3): 00:02:00</p></div><div><div><p>•Formulas Update for Exact Date Prepaid Exps Amortisation (Part 4): 00:07:00</p></div><div><div><p>•IFS Function - Exact Date Prepayments Amortisation: 00:04:00</p></div><div><div><p>•Data Validation Controls (Enhancing Data Input Controls with Protection): 00:10:00</p></div><div><div><p>•Bonus: Prepayment Model with Opening Balance Calculation (Part 1): 00:08:00</p></div><div><div><p>•Bonus: Prepayment Model with Opening Balance Calculation (Part 2): 00:09:00</p></div><div><div><p>•Additional Material: Resources: 00:00:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Power Query and Pivot Table Prepayment Summary Table Intro: 00:06:00</p></div><div><div><p>•What is Power Query and Some Awesome Resources for Power Query learning: 00:07:00</p></div><div><div><p>•Power Query and Pivot Table Summary - Deep Dive (Part 1): 00:05:00</p></div><div><div><p>•Power Query and Pivot Table Summary - Deep Dive (Part 2): 00:04:00</p></div><div><div><p>•Power Query and Pivot Table Summary - Deep Dive (Part 3): 00:05:00</p></div><div><div><p>•Power Query and Pivot Table Summary - Deep Dive (Part 4): 00:09:00</p></div><div><div><p>•Using Array Formulas to Add Formula Protection: 00:04:00</p></div><div><div><p>•Bonus: Allocate Prepaid Expenditure Cost Centre Wise - 1: 00:02:00</p></div><div><div><p>•Bonus: Allocate Prepaid Expenditure Cost Centre Wise - 2: 00:08:00</p></div><div><div><p>•Bonus: Prepayment Model with Opening Balance Calculation (PQ and PT Version): 00:13:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Changing Macros Security in Excel: 00:05:00</p></div><div><div><p>•Complete Walkthrough - Advanced VBA Prepaid Expenses Amortisation Model: 00:06:00</p></div><div><div><p>•Bonus : New Version - Excel VBA Model for Prepayment Expenditure: 00:08:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Dynamic Dashboard Overview: 00:07:00</p></div><div><div><p>•Importing Profit and Loss Statements Source Files and creating YTD P&amp;L Sheets: 00:08:00</p></div><div><div><p>•Creating Dynamic Data Validation: 00:02:00</p></div><div><div><p>•Creating Named Ranges for Dynamic Table Arrays: 00:03:00</p></div><div><div><p>•Dynamic Date Column Headings for each Divisional PL Table: 00:02:00</p></div><div><div><p>•Dynamic Month and YTD Dashboard tables headings (PRO TIP): 00:03:00</p></div><div><div><p>•Dynamic VLOOKUP Formula - Preparing First section of the Dashboard: 00:04:00</p></div><div><div><p>•Creating Rolling Dashboard with Dynamic VLOOKUP Function: 00:08:00</p></div><div><div><p>•IMPORTANT : Error Checking for your reports/Dashboard (PRO TIP): 00:03:00</p></div><div><div><p>•Data Prep for Visualization: AREA Charts (Awesome trick using #NA Function): 00:05:00</p></div><div><div><p>•Visualization: AREA Charts for Month - Revenue, Gross Profit and Net Profit: 00:05:00</p></div><div><div><p>•Visualization DONUT Charts Revenue, Gross Profit and Net Profit (Part 1): 00:03:00</p></div><div><div><p>•Visualization DONUT Charts Revenue, Gross Profit and Net Profit (Part 2): 00:06:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Introduction - Formula-less Dashboard - Fully Dynamic and easily refreshed: 00:05:00</p></div><div><div><p>•Understanding the data files before building dashboard: 00:02:00</p></div><div><div><p>•Consolidating Reports with Power Query (Get &amp; Transform) , How to install PQ: 00:08:00</p></div><div><div><p>•Dynamic File Path Trick in Power Query with Parameters (Amazing trick): 00:06:00</p></div><div><div><p>•Conditional Cumulative totals with SUMIFS Function: 00:04:00</p></div><div><div><p>•Bonus: Conditional Cumulative totals with Power Query Custom Formula (M Code): 00:06:00</p></div><div><div><p>•Dashboard Creation - Pivot Table showing Month and YTD KPIs division wise: 00:06:00</p></div><div><div><p>•Dashboard Creation Donuts Charts linked with Pivot Table (Replicate Charts fast): 00:08:00</p></div><div><div><p>•Dashboard Creation - Line Charts: 00:08:00</p></div><div><div><p>•Update Dashboard with Additional Divisional Data with Few Click (Magical): 00:03:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Thank you: 00:02:00</p></div><div><div><p>•Ultimate Prepaid Expenditure Model (Super Bonus): 00:02:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Resources - Microsoft Excel: Automated Dashboard Using Advanced Formula, VBA, Power Query: 00:00:00</p></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div>

Online Course Marketing

Practical Accounting

Microsoft Excel: Automated Dashboard Using Advanced Formula, VBA, Power Query

<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!

<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

<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 Power Apps

Microsoft Sharepoint

Power Apps

Microsoft Power Platform

SharePoint

55215 SharePoint Online Power User

<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>

Office Skills & Productivity

Excel Analytics

Visual Basic Analysis

Microsoft Power Automate

Excel - Automating Excel with Macros and Analysis Tools

<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)

<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.

Real Estate Modelling Masterclass (Advanced Cash Flow Modelling)

<div id="course-pills-1">Duration<p>1 Days</p><p>6 CPD hours</p>This course is intended for<p>Candidates for this exam are users who aspire to improve productivity by automating business processes, analyzing data to produce business insights, and acting more effectively by creating simple app experiences.</p>Overview<p>After completing this course, you will be able to:<br />Describe Microsoft Power Platform components<br />Describe Microsoft Dataverse and connectors<br />Describe cross-cloud scenarios across M365, Dynamics 365, Microsoft Azure and 3rd party services<br />Identify benefits and capabilities of Microsoft Power Platform<br />Identify the basic functionality and business value Microsoft Power Platform components<br />Implement simple solutions with Power Apps, Power Automate, and Power BI</p><p>Learn the business value and product capabilities of Microsoft Power Platform. Create simple Power Apps, connect data with Dataverse, build a Power BI Dashboard, and automate processes with Power Automate. </p></div><div id="course-pills-2"><h4>Module 1: Introduction to Microsoft Power Platform</h4><ul><li>Identify when to use each Microsoft Power Platform component application to create business solution</li><li>Learn the value of using Microsoft Power Platform to create business solutions</li><li>Learn the components and features of Microsoft Power Platform</li></ul><h4>Module 2: Introduction to Microsoft Dataverse</h4><ul><li>Microsoft Dataverse Overview</li></ul><h4>Module 3: Get Started with Power Apps</h4><ul><li>Introduction to Power Apps</li><li>How to build a canvas app</li><li>How to build a model-driven app</li></ul><h4>Module 4: Get Started with Power Automate</h4><ul><li>Power Automate Overview</li><li>How to Build an Automated Solution</li></ul><h4>Module 5: Get Started with Power BI</h4><ul><li>Power BI Overview</li><li>How to Build a Simple Dashboard</li></ul><h4>Module 6: Introduction to Power Virtual Agents</h4><ul><li>Power Virtual Agents overview</li></ul></div><div id="course-pills-3"><h4>Additional course details:</h4><br /><p>Nexus Humans PL-900T00 Microsoft Power Platform Fundamentals 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 PL-900T00 Microsoft Power Platform Fundamentals 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>

Microsoft PL-900

Microsoft AZ-900

Microsoft AZ-303

Microsoft AZ-700

PL-900T00 Microsoft Power Platform Fundamentals

<p id="isPasted" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;"><br fr-original-style="" style="box-sizing: border-box;"></span></p><p id="isPasted" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Real Estate Investments are unique in that they generate both rental income and capital appreciation, making cash flow modelling an essential tool for Real Estate Investors, Lenders, and Analysts.</span></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">On this course, we will use case studies to enhance the delegates understanding of Real Estate financial appraisals, and help them fully appreciate the theory behind the numbers. We will cover topics such as discounting, compounding, forecasting rental income and expenses, calculating net operating income (NOI), factoring in capital expenditures, modelling debt service, and determining the internal rate of return (IRR).</span></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">This course will provide you with a solid foundation for understanding and analysing real estate cash flows.</span></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;"><br fr-original-style="" style="box-sizing: border-box;"></span></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">On this course you will...</strong></span></p><ul fr-original-style="" style="box-sizing: border-box;"><li value="1" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Study the financial concepts of compounding, discounting and in-perpetuity</li><li value="2" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Consider the importance of the timing and uncertainty of both fixed and growing income streams</li><li value="3" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Contrast different property yield metrics</li><li value="4" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Build-up risk premiums for discount rates, discuss the importance of liquidity, transparency and volatility</li><li value="5" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Compare and contrast time and money-weighted measures of return</li><li value="6" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Learn about valuation principles</li><li value="7" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Contrast value and worth</li><li value="8" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Discuss the importance and sourcing of inputs and outputs</li></ul><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;"><br fr-original-style="" style="box-sizing: border-box;"></span></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Who will benefit from this course?</strong></span></p><ul fr-original-style="" style="box-sizing: border-box;"><li value="1" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Professional Real Estate Transaction Managers</li><li value="2" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Asset Managers</li><li value="3" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Portfolio Managers</li><li value="4" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Recent graduates with exposure to real estate financial modelling</li><li value="5" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">New employees with exposure to real estate financial modelling</li><li value="6" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">People working in Argus, Anaplan or any commercial real estate software and would like to understand financial modelling key principles.</li></ul><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;"><br fr-original-style="" style="box-sizing: border-box;"></span></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Course Outline</strong>:</span></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Morning</strong></span></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Real Estate Financial Mathematics</span></p><ul fr-original-style="" style="box-sizing: border-box;"><li value="1" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Time Value of Money</li><li value="2" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Net Present Value (NPV)</li><li value="3" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Internal Rate of Return (IRR)</li><li value="4" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Growth</li><li value="5" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">What Discount Rate?</li><li value="6" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Certainty of a cash flow</li><li value="7" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Liquidity</li></ul><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Price, Value and Worth</span></p><ul fr-original-style="" style="box-sizing: border-box;"><li value="1" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Comparing Price, Value and Worth</li><li value="2" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Conventional Valuation Methods</li><li value="3" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Term and Reversion, Layer Method</li><li value="4" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Property Yields and Capitalisation Method</li><li value="5" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Exit calculations across Europe</li></ul><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;"><br fr-original-style="" style="box-sizing: border-box;"></span></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;">Afternoon</strong></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Discounted Cash Flow Models</span></p><ul fr-original-style="" style="box-sizing: border-box;"><li value="1" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Investment Appraisal Models</li><li value="2" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Cash flow inputs: Rents, Yields, Growth Rates, Target Returns</li><li value="3" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Cash-on-Cash and Equity Multiple</li><li value="4" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Discount Rates &amp; Exit Cap Rate</li><li value="5" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Operating Assumptions</li><li value="6" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Adding borrowing and analysing geared returns</li></ul><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Model Interpretation and Analysis</span></p><ul fr-original-style="" style="box-sizing: border-box;"><li value="1" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Sensitivity analysis and scenario analysis</li><li value="2" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Growth and inflation</li><li value="3" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Performance measures</li><li value="4" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Contemporary issues for analysis (such as the rise in interest rates)</li></ul><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;"><br fr-original-style="" style="box-sizing: border-box;"></span></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Quizzes | Q&amp;A</span></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;"><br fr-original-style="" style="box-sizing: border-box;"></span></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Included in the Course</strong></span></p><ul fr-original-style="" style="box-sizing: border-box;"><li value="1" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">A Bayfield Training Certificate &amp; 7.5 CPD Hours</li><li value="2" style="font-size: 16px; box-sizing: border-box;" id="isPasted" fr-original-style="font-size: 16px;">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" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Course Files</li><li value="4" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Online Learning Platform access - Further Learning Resources (Reading, Files and Videos)</li><li value="5" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">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;"><span style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;"><br fr-original-style="" style="box-sizing: border-box;"></span></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 Understanding Key Principles of Real Estate Financial Modelling 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>



Real Estate Investments are unique in that they generate both rental income and capital appreciation, making cash flow modelling an essential tool for Real Estate Investors, Lenders, and Analysts.
On this course, we will use case studies to enhance the delegates understanding of Real Estate financial appraisals, and help them fully appreciate the theory behind the numbers. We will cover topics such as discounting, compounding, forecasting rental income and expenses, calculating net operating income (NOI), factoring in capital expenditures, modelling debt service, and determining the internal rate of return (IRR).
This course will provide you with a solid foundation for understanding and analysing real estate cash flows.


On this course you will...
Study the financial concepts of compounding, discounting and in-perpetuity
Consider the importance of the timing and uncertainty of both fixed and growing income streams
Contrast different property yield metrics
Build-up risk premiums for discount rates, discuss the importance of liquidity, transparency and volatility
Compare and contrast time and money-weighted measures of return
Learn about valuation principles
Contrast value and worth
Discuss the importance and sourcing of inputs and outputs


Who will benefit from this course?
Professional Real Estate Transaction Managers
Asset Managers
Portfolio Managers
Recent graduates with exposure to real estate financial modelling
New employees with exposure to real estate financial modelling
People working in Argus, Anaplan or any commercial real estate software and would like to understand financial modelling key principles.


Course Outline:
Morning
Real Estate Financial Mathematics
Time Value of Money
Net Present Value (NPV)
Internal Rate of Return (IRR)
Growth
What Discount Rate?
Certainty of a cash flow
Liquidity
Price, Value and Worth
Comparing Price, Value and Worth
Conventional Valuation Methods
Term and Reversion, Layer Method
Property Yields and Capitalisation Method
Exit calculations across Europe


Afternoon
Discounted Cash Flow Models
Investment Appraisal Models
Cash flow inputs: Rents, Yields, Growth Rates, Target Returns
Cash-on-Cash and Equity Multiple
Discount Rates & Exit Cap Rate
Operating Assumptions
Adding borrowing and analysing geared returns
Model Interpretation and Analysis
Sensitivity analysis and scenario analysis
Growth and inflation
Performance measures
Contemporary issues for analysis (such as the rise in interest rates)


Quizzes | Q&A


Included in the Course
A Bayfield Training Certificate & 7.5 CPD Hours
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 Understanding Key Principles of Real Estate Financial Modelling 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

Property Investment

Risk Management

Investment

Financial Risk Management

On this course, we will use case studies to enhance the delegates understanding of Real Estate financial appraisals, and help them fully appreciate the theory behind the numbers. 

Understanding Key Principles of Real Estate Modelling (Advanced Theoretical Course)

<div id="course-pills-1">Duration<p>4 Days</p><p>24 CPD hours</p>This course is intended for<p></p><p>Collaboration Communications Systems Engineers are responsible for planning, deploying, configuring, maintaining, and troubleshooting Microsoft Teams Phone, meetings, and personal and shared space devices, including Microsoft Teams Rooms and Surface Hub.</p> <p>Collaboration Communications Systems Engineers have a fundamental understanding ofÃ¿networking, telecommunications, audio/visual and meeting room technologies, identity and access management.</p> <p>They are proficient in managing and monitoring Teams Phone, meetings, and certified devices using the Microsoft Teams admin center, PowerShell, the Microsoft Teams Rooms Pro Portal, and the Call Quality Dashboard. They deploy and configure Microsoft Teams Phone with PSTN connectivity through Microsoft Calling Plans, Operator Connect, Teams Phone Mobile, and Direct Routing.</p> <p>Collaboration Communications Systems Engineers work with Teams Administrators, Microsoft Identity and Access Administrators, and Microsoft 365Ã¿Administrators. In addition, they may work with owners of other workloads, including facilitiesÃ¿managers, network engineers, security engineers, device manufacturers, telephony providers, and Microsoft Certified solutions providers.</p><p></p><p></p><p>This training course is designed to give participants the knowledge and skills to become a Collaboration Communications Systems Engineer. Participants should understand the fundamentals of networking, telecommunications, audio/visual and meeting room technologies, identity and access management, and Microsoft Teams.</p> <p>They will gain hands-on experience configuring and deploying Microsoft Teams Phone, meetings and certified devices including Microsoft Teams Rooms and Surface Hub. The course will also cover how to manage and monitor Teams Phone, meetings, and certified devices using the Microsoft Teams admin center, PowerShell, the Microsoft Teams Rooms Pro Portal, and the Call Quality Dashboard.</p> <p>In addition, the course will cover configuring and deploying Microsoft Teams Phone with PSTN connectivity through Microsoft Calling Plans, Operator Connect, Teams Phone Mobile, and Direct Routing.</p><p></p>Prerequisites<p></p><ul> <li>Microsoft 365 and Microsoft Teams</li> <li>Networking, telecommunications, and audio/visual basics</li> <li>Identity and access management basics</li> </ul><p></p></div><div id="course-pills-2"><h3>1 - Introduction to Teams meetings and calling</h3> <ul> <li>Overview of Teams meetings and events</li> <li>Overview of Teams Phone</li> <li>Overview of auto attendants and call queues</li> <li>Overview of Teams devices</li> </ul> <h3>2 - Plan for Teams Phone</h3> <ul> <li>Plan to deploy Teams Phone</li> <li>Plan for Teams Phone PSTN connectivity</li> <li>Determine license requirements</li> <li>Plan for Teams Phone devices</li> <li>Plan and design Teams Phone features</li> <li>Plan for voicemail</li> </ul> <h3>3 - Plan for Microsoft Teams Rooms and Surface Hub</h3> <ul> <li>Determine license requirements for Microsoft Teams Rooms and shared devices</li> <li>Understand differences between Microsoft Teams Rooms on Android and Windows</li> <li>Understand Microsoft Teams Rooms on Surface Hub 2S</li> <li>Understand and plan Teams Room accessories, components, and peripherals</li> <li>Understand Teams Rooms management options</li> </ul> <h3>4 - Plan and optimize network performance for Teams media</h3> <ul> <li>Understand Teams network requirements</li> <li>Design network for media optimization</li> <li>Design and implement QoS</li> </ul> <h3>5 - Configure and deploy Teams Phone</h3> <ul> <li>Configure emergency calling for Teams Calling Plans</li> <li>Manage and configure Microsoft PSTN numbers</li> <li>Configure Operator Connect and Teams Phone Mobile</li> <li>Configure Teams Phone policies</li> <li>Create and manage Teams policies</li> <li>Configure Audio Conferencing</li> </ul> <h3>6 - Configure and deploy Teams Phone with Direct Routing</h3> <ul> <li>Design Direct Routing call flows</li> <li>Implement SIP trunking with Direct Routing</li> <li>Configure Emergency Calling for Direct Routing</li> <li>Extend Teams Direct Routing infrastructure</li> <li>Deploy and maintain a survivable branch appliance</li> </ul> <h3>7 - Extend Teams Phone with additional services</h3> <ul> <li>Understand how Teams interacts with additional services</li> <li>Configure compliance recording in Teams</li> <li>Configure and integrate a certified contact center in Teams</li> <li>Design and deploy voice bots in Teams</li> </ul> <h3>8 - Manage meetings and events experiences</h3> <ul> <li>Explore meetings and events in Microsoft Teams</li> <li>Configure meeting settings</li> <li>Create and manage meeting policies</li> <li>Configure audio conferencing</li> <li>Create and manage meeting templates and template policies</li> <li>Create and manage meetings customization policies</li> <li>Configure live events settings</li> <li>Create and manage live events policies</li> <li>Examine live events across Microsoft 365</li> </ul> <h3>9 - Guided project - Create and assign Teams policies to meet business requirements in Microsoft Teams</h3> <ul> <li>Prepare</li> </ul> <h3>10 - Configure and manage voice users</h3> <ul> <li>Enable users for Teams Phone</li> <li>Enable users for Direct Routing with Teams Phone</li> <li>Enable additional calling features for Teams Phone</li> <li>Enable users for Teams Phone Mobile</li> </ul> <h3>11 - Configure auto attendants and call queues</h3> <ul> <li>Design call flows for auto attendants and call queues</li> <li>Configure auto attendants and call queues</li> <li>Deploy a channel-based call queue</li> <li>Configure resource accounts</li> <li>Configure Microsoft 365 groups for voicemail</li> <li>Interpret call queue conference modes</li> <li>Interpret call queue routing methods</li> <li>Configure holidays for auto attendants and call queues</li> <li>Configure custom music on hold</li> </ul> <h3>12 - Configure, deploy, and manage Teams devices</h3> <ul> <li>Manage Microsoft Teams Phones</li> <li>Manage Microsoft Teams Room Systems</li> <li>Microsoft Teams Rooms management options</li> <li>Manage Surface Hub 2S devices</li> <li>Configure Microsoft Teams SIP gateway</li> <li>Manage Microsoft Teams displays</li> <li>Remote provisioning and sign in for Teams Phones</li> <li>Update Microsoft Teams devices remotely</li> <li>Manage Microsoft Teams device tags</li> </ul> <h3>13 - Guided project - Prepare meeting room experiences</h3> <ul> <li>Prepare</li> </ul> <h3>14 - Monitor and troubleshoot Teams collaboration communications systems</h3> <ul> <li>Diagnose and troubleshoot phone number assignment</li> <li>Diagnose and troubleshoot Teams client issues</li> <li>Diagnose and troubleshoot call failure and call quality issues</li> <li>Report on and troubleshoot Teams calls with Call Quality Dashboard</li> <li>Diagnose and troubleshoot Direct Routing issues</li> <li>Troubleshoot and monitor Teams devices</li> <li>Troubleshoot Teams meetings and calling</li> <li>Troubleshoot Teams Rooms devices</li> </ul></div>

Microsoft Teams

Microsoft Certified Trainer (MCT)

Clinical Engineer

MS-721T00 Collaboration Communications Systems Engineer

<div id="course-pills-1">Duration<p>3 Days</p><p>18 CPD hours</p>This course is intended for<p>This course is designed for Administrators who need to setup, configure and manage SharePoint Online as part of their Office 365 Administration.</p>Overview<p>After completing this course, students will gain the skills to:  - Understand the architecture of SharePoint Online  - Have knowledge of all the components in SharePoint Online  - Have on hands on experience configuring the components of SharePoint Online  - Have hands on experience configuring the options  - Work with Site Collections and storage options  - Manage user profiles and social profiling  - Understand and configure data connectivity in SharePoint Online  - Build a taxonomy structure   - Understand and configure Search in SharePoint Online  - Configure and deploy apps  - Understand and define Enterprise content management and data loss prevention.  - Configure additional options and features in SharePoint Online such as Information Rights Management</p><p>This course will introduce the audience to SharePoint Online Administration in Office 365 and explain and demonstrate the configuration options for SharePoint Online. The course is appropriate for existing SharePoint on-premises administrators and new administrators to Office 365 who need to understand how to correctly setup SharePoint Online for their company. The course will also help SharePoint on-premise administrators understand the differences between SharePoint on-premises and SharePoint Online.</p></div><div id="course-pills-2"><h3>1 - INTRODUCTION TO OFFICE 365 AND SHAREPOINT ONLINE</h3> <ul> <li>Introduction to the Office 365 Administration Center</li> <li>Configure Reporting</li> <li>Accessing SharePoint management tools</li> <li>Accessing security and compliancy</li> <li>Managing Office 365 and SharePoint Online with PowerShell</li> <li>Comparing On Premises SharePoint with SharePoint Online</li> <li>User identity in Office 365 and SharePoint Online</li> <li>Manging user domains</li> <li>Building Hybrid scenarios</li> <li>OneDrive and Sites redirection</li> <li>Yammer redirection</li> <li>Understand hybrid search</li> <li>Hybrid business data connectivity</li> <li>Hybrid taxonomy</li> </ul> <h3>2 - WORKING WITH SITE COLLECTIONS</h3> <ul> <li>Introduction to classic and modern admin centers</li> <li>Creating Site Collections</li> <li>Defining ownership and security for site collections</li> <li>Configuring Storage</li> <li>Configure External Access to site collections</li> <li>Recovering site collections</li> <li>Configure external sharing</li> <li>Managing site collections with PowerShell</li> </ul> <h3>3 - MANAGING USER PROFILES</h3> <ul> <li>Overview of the profile service</li> <li>Defining profile properties</li> <li>Map profile properties to a term store</li> <li>Creating custom profile properties</li> <li>Managing audiences</li> <li>Creating audiences</li> <li>Managing user profile policies</li> <li>Configure trusted my site host locations</li> <li>Configure preferred search center locations</li> <li>Defining read access permission levels</li> <li>Configuring newsfeed options</li> <li>Setup email notifications</li> <li>Configure my site cleanup</li> </ul> <h3>4 - WORKING WITH DATA CONNECTIONS</h3> <ul> <li>Introduction to Data Connections</li> <li>Overview of PowerApps, Flow and PowerBi</li> <li>Overview of the business connectivity service</li> <li>Introduction to BDC definition files</li> <li>Creating BDC definition files</li> <li>Introduction to the secure store service</li> <li>Configuring the secure store service</li> <li>Creating secure store target application settings</li> <li>Configure connections to cloud services</li> <li>Configure connections to on-premises services</li> <li>Tools to build data connections</li> <li>Creating external content types</li> <li>Building external lists using external data</li> </ul> <h3>5 - MANAGING THE TERM STORE</h3> <ul> <li>Overview of the term store</li> <li>Understanding terms and life cycle management</li> <li>Creating term groups</li> <li>Creating the term store</li> <li>Creating Term Sets in the UI</li> <li>Creating Term Sets via importing via a CSV</li> <li>Creating terms in the UI</li> <li>Creating terms via PowerShell and CSOM</li> <li>Manage terms with synonyms and pinning</li> <li>Configure delegated administration</li> </ul> <h3>6 - CONFIGURING SEARCH</h3> <ul> <li>An Introduction to the search service</li> <li>Classic versus Modern search experience</li> <li>Understanding Managed Properties</li> <li>Create Managed Properties</li> <li>Manage Authoritative pages</li> <li>Understand Result sources</li> <li>Create and configure result sources</li> <li>Understand Query rules</li> <li>Promoting results through query rules</li> <li>Remove search results from the index</li> <li>Exporting search configurations</li> <li>Importing search configurations</li> </ul> <h3>7 - CONFIGURING APPS</h3> <ul> <li>An Introduction to Apps</li> <li>Understanding the App Catalog</li> <li>Building the App catalog</li> <li>Adding Apps to the catalog</li> <li>Add Apps to your SharePoint sites</li> <li>Adding Apps via the marketplace store</li> <li>Manage App licensing</li> <li>Configure store access settings</li> <li>Monitoring app usage</li> </ul> <h3>8 - ENTERPRISE CONTENT MANAGEMENT IN SHAREPOINT ONLINE</h3> <ul> <li>An Introduction to ECM in SharePoint Online</li> <li>Components of ECM</li> <li>Office 365 versus classic compliancy</li> <li>Understanding In-Place records management</li> <li>Configure In-Place records management</li> <li>Understanding the records center</li> <li>Build and configure a records center</li> <li>Understanding the compliancy policy center</li> <li>Build a compliancy policy center and configure policies</li> <li>Discover the security and compliancy center</li> <li>Configure an eDiscovery center</li> <li>Build an eDiscovery case</li> <li>Understand data loss prevention</li> <li>Build a data loss prevention policy and query</li> <li>Working with classification and data governance</li> </ul> <h3>9 - MANAGE OPTIONS FOR SHAREPOINT ONLINE</h3> <ul> <li>Configure OneDrive features</li> <li>Configure use of Yammer or Newsfeeds</li> <li>Understand Information Rights Management</li> <li>Configure Information Rights Management</li> <li>Define site classification options</li> <li>Understand early release options for Office 365</li> <li>Configure Early release options for your Office 365 tenant</li> <li>Manage Access Control</li> </ul></div><div id="course-pills-3"><h4>Additional course details:</h4><br /><p>Nexus Humans 55238 SharePoint Online for Administrators 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 55238 SharePoint Online for Administrators 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>

3368 Office Skills courses delivered Online

GRC300 SAP Access Control Implementation and Configuration

By Nexus Human

AS10 IBM RPG IV Programming Advanced Workshop for IBM i

By Nexus Human

UX100 SAP Fiori - Foundation

By Nexus Human

GRC100 Principles of SAP Governance, Risk, and Compliance

By Nexus Human

SAS Programming 1 - Essentials

By Nexus Human

HR110 SAP Business Processes in HCM Payroll

By Nexus Human

GRC330 SAP Process Control 10.1 - Implementation and Configuration

By Nexus Human

Microsoft Excel: Excel Sheet Comparison with VBA

By Apex Learning

Microsoft Excel Course for Everyone - Complete Excel Course

By Apex Learning

Microsoft Excel: Automated Dashboard Using Advanced Formula, VBA, Power Query

By Apex Learning