London

<p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">For all of our courses go to <a data-fr-linked="true" href="https://www.tunneys.co.uk/" id="isPasted" fr-original-style="" style="user-select: auto; font-size: var(--font-size); box-sizing: border-box; cursor: pointer; text-decoration: inherit;">tunneys.co.uk</a></p>

Tunneys

Microsoft Power BI

Financial Modelling

Microsoft Excel

professional financial modelling and data analysis courses

For all of our courses go to tunneys.co.uk

General Admission

<p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="color: rgb(32, 32, 34); box-sizing: border-box;" id="isPasted" fr-original-style="color: rgb(32, 32, 34);">This course was developed for one of the <strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">largest investment institutions</strong> in the world, a multi-trillion&nbsp;household name. We explain in detail our tips and tricks to build an accurate and rolling enterprise&nbsp;value, and then review different valuation methodologies, from DCF, through the sum of the parts and&nbsp;football field analyses to LTV/CAC based methods. We conclude with a series of case studies&nbsp;examining the valuation of individual stocks.</span></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="color: rgb(32, 32, 34); box-sizing: border-box;" fr-original-style="color: rgb(32, 32, 34);"></span>Please email <a href="mailto:info@behindthebalancesheet.com" fr-original-style="" style="user-select: auto; font-size: var(--font-size); box-sizing: border-box; cursor: pointer; text-decoration: inherit;">info@behindthebalancesheet.com</a>&nbsp;for more information on booking this course at your institution.</p>

Behind The Balance Sheet

Accounting

Finance Cert & Exam Prep

Corporate Finance (CF)

Stock Investing

Stock Market

Finance Manager

Financial Analysis

Financial Analyst

Accounting & Finance

Business & Finance

Finance

Bookkeeping

Finance Director

Banking & Finance

Investing & Trading

Accounting & Bookkeeping

Corporate Finance

This course was developed for one of the largest investment institutions in the world, a multi-trillion household name. We explain in detail our tips and tricks to build an accurate and rolling enterprise value, and then review different valuation methodologies, from DCF, through the sum of the parts and football field analyses to LTV/CAC based methods. We conclude with a series of case studies examining the valuation of individual stocks.



ADVANCED VALUATION FOR INSTITUTIONAL INVESTORS

Riverdale

<p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Pushy boardroom bullies... battling agendas... conflicts of interest.&nbsp; Here are the most common drivers of trouble in the boardroom, and tools for making things right.</p>

Ralph Ward

Boardroom Conflicts! - Causes and Cures

Bardsey

Leeds

Nottingham

Reading

Dickson Training Ltd

Team Building

Team Building & Team Development

H-TEC Transport Services

Approved Training Organisation (ATO)

OLAT

Fleet Operator Recognition Scheme (FORS)

Lean Awareness

ACT Awareness

Award for Personal Licence Holders (APLH)

Operator Licence Awareness (OLAT)

Motherwell

The Power Within Training & Development Ltd

Growth Leadership Programme

<header style="color: rgb(25, 25, 25); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(25, 25, 25);"><p style="color: rgb(255, 255, 255); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(255, 255, 255);"><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);">This case study is on a 2019 school history tour to the USA, which sadly ended in tragedy. This case study forms part of the Xcursion Online International School Travel Safety Course.</span></p></header><div style="color: rgb(25, 25, 25); box-sizing: border-box;" fr-original-style=" color: rgb(25, 25, 25);"><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);"><br fr-original-style="" style="box-sizing: border-box;"></span></div><section data-preview-item="course-curriculum" data-section-uid="c64fb7ee2f" style="color: rgb(25, 25, 25); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(25, 25, 25);"><header fr-original-style="" style="box-sizing: border-box;"><section data-preview-item="course-curriculum" data-section-uid="f4f038439d" style="color: rgb(25, 25, 25); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(25, 25, 25);"><header fr-original-style="" style="box-sizing: border-box;"><section data-preview-item="course-curriculum" data-section-uid="f4f038439d" style="color: rgb(25, 25, 25); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(25, 25, 25);"><header fr-original-style="" style="box-sizing: border-box;"><h2 style="color: rgb(25, 25, 25); box-sizing: border-box;" fr-original-style=" color: rgb(25, 25, 25);">Course curriculum</h2></header><article fr-original-style="" style="box-sizing: border-box;"><ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">Introduction | 2 min</li><li fr-original-style="" style="box-sizing: border-box;">Case Study: It Was Such A Busy Schedule... | 13 min</li><li fr-original-style="" style="box-sizing: border-box;">Further Information</li></ul></article></section><a style="color: rgb(74, 144, 226); -webkit-user-select: auto; font-size: var(--font-size); box-sizing: border-box; cursor: pointer; text-decoration: inherit;" fr-original-style=" color: rgb(74, 144, 226);"></a><section data-preview-item="rich_text" data-section-uid="JrmumrM-7" style="color: rgb(25, 25, 25); box-sizing: border-box;" fr-original-style=" color: rgb(25, 25, 25);"><header fr-original-style="" style="box-sizing: border-box;"><h2 style="color: rgb(25, 25, 25); box-sizing: border-box;" fr-original-style=" color: rgb(25, 25, 25);">Important Details About This Case Study</h2></header><h1 fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"><span style="color: rgb(184, 49, 47); box-sizing: border-box;" fr-original-style=" color: rgb(184, 49, 47);">Warning</span></strong><span style="color: rgb(184, 49, 47); box-sizing: border-box;" fr-original-style=" color: rgb(184, 49, 47);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">:&nbsp;</strong></span></h1><p fr-original-style="" style="font-size: var(--font-size); box-sizing: border-box;"><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">This course contains materials which may be upsetting to some participants, including serious illness references and confronting details of an incident which occurred on a school trip that resulted in a fatality. Case studies and examples are designed to highlight the dangers and risks involved in these types of activities and help prevent them from occurring in the future. Please bear this in mind before you start the course.</span>&nbsp;<span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">We have made every effort to ensure these matters are presented in a meaningful and sensitive way to help improve safety. However, if something from this course does trigger something in you, please connect with a professional counseling service immediately.</span></p></section></header><article fr-original-style="" style="box-sizing: border-box;"><p fr-original-style="" style="font-size: var(--font-size); box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></p></article></section></header></section><h2 style="color: rgb(25, 25, 25); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(25, 25, 25);">Instructors<img src="https://images.cademy.co.uk/89a37d74-6264-4f95-b37e-2d26ecae011d/e0c0848a-9a4a-4699-9c13-b6470b99e92b/original.png" style="width: 697px; display: block; vertical-align: top; margin: 5px auto; text-align: center; cursor: pointer; padding: 0px 1px; -webkit-user-select: none; max-width: 100%; position: relative; box-sizing: border-box;" fr-original-style="width: 697px; display: block; vertical-align: top; margin: 5px auto; text-align: center;" fr-original-class="fr-draggable"><img src="https://images.cademy.co.uk/89a37d74-6264-4f95-b37e-2d26ecae011d/25ff64c4-bf04-418e-bca2-b489b6551b73/original.png" style="width: 697px; display: block; vertical-align: top; margin: 5px auto; text-align: center; cursor: pointer; padding: 0px 1px; -webkit-user-select: none; max-width: 100%; position: relative; box-sizing: border-box;" fr-original-style="width: 697px; display: block; vertical-align: top; margin: 5px auto; text-align: center;" fr-original-class="fr-draggable"></h2><div fr-original-style="" style="box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></div><header style="color: rgb(25, 25, 25); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(25, 25, 25);"><h2 style="color: rgb(25, 25, 25); box-sizing: border-box;" fr-original-style=" color: rgb(25, 25, 25);">Related Online Training</h2></header><article style="color: rgb(25, 25, 25); box-sizing: border-box;" fr-original-style=" color: rgb(25, 25, 25);"><ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;"><h3 fr-original-style="" style="box-sizing: border-box;">Risk Management &amp; Safety For International School Tours</h3><section fr-original-style="" style="box-sizing: border-box;">For the full online International Safety Training Course from which this case study was taken you can enrol now, or come to one of the limited series of face to face training days.</section><a href="https://training.xcursionrisk.com/cart/add_product/1735233?price_id=2296711" style="color: rgb(255, 255, 255); -webkit-user-select: auto; font-size: var(--font-size); box-sizing: border-box; cursor: pointer; text-decoration: inherit;" fr-original-style=" color: rgb(255, 255, 255);">Enrol Now</a></li><li fr-original-style="" style="box-sizing: border-box;"><h3 fr-original-style="" style="box-sizing: border-box;">Risk Management &amp; Outsourcing School Excursions, Camps &amp; Activities</h3><section fr-original-style="" style="box-sizing: border-box;">Do you contract out school camps, excursions or international tours? If so, you need to understand what risks you&#39;ve transferred &amp; what risks you&#39;ve retained. This course steps you through exactly what you need to know when contracting something out.</section><a href="https://training.xcursionrisk.com/cart/add_product/989297?price_id=1091523" style="color: rgb(255, 255, 255); -webkit-user-select: auto; font-size: var(--font-size); box-sizing: border-box; cursor: pointer; text-decoration: inherit;" fr-original-style=" color: rgb(255, 255, 255);">Enrol Now</a></li></ul></article>

Xcursion

Risk Assessment

This case study is on a 2019 school history tour to the USA, which sadly ended in tragedy. This case study forms part of the Xcursion Online International School Travel Safety Course.

School History Tour Medical Emergency - 2019 Case Study

<div id="course-pills-1">Duration<p>5 Days</p><p>30 CPD hours</p>This course is intended for<p>This intermediate course is designed for anyone who works on WebSphere related applications and projects, including administrators, IBM Business Partners, independent software vendors (ISVs), and consultants.</p>Overview<p>The objectives for this course are as follows:Use IBM Support Assistant to organize and analyze problem artifactsUse problem determination techniques to identify common problemsApply problem investigation approaches such as analysis and isolationGather diagnostic data problem artifacts by using administrative toolsTroubleshoot JVM-related problems such as hung threads, out of memory issues, and crashesUse IBM Support Assistant to run tools that analyze diagnostic dataIdentify and troubleshoot common problems with database connectionsConfigure and tune database connection poolsTroubleshoot WebSphere security problems associated with authentication, authorization, SSL, and Java 2 policiesIdentify and resolve Java EE application deployment problemsTroubleshoot HTTP request flow problems from web server to web containerIdentify and resolve application server startup failuresTroubleshoot problems associated with WebSphere default messaging and SI busTroubleshoot WebSphere installation problemsUse Intelligent Management features to configure health policies and tasksCommunicate effectively with IBM support teams</p><p>This course teaches you how to manage WebSphere Application Server problems more skillfully within your organization by using problem determination tools and techniques.</p></div><div id="course-pills-2"><h4>Outline</h4><ul><li>Course introduction</li><li>Overview of WebSphere Application Server systems and components</li><li>Using the IBM Support Assistant Team Server 5.0</li><li>Exercise: Using the IBM Support Assistant Team Server 5.0</li><li>Problem determination methods</li><li>Gathering diagnostic data</li><li>Exercise: Gathering diagnostic data</li><li>Introduction to JVM-related problems</li><li>Exercise: Introduction to configuring garbage collection policies</li><li>How to troubleshoot hangs</li><li>Exercise: Troubleshooting hung threads</li><li>How to troubleshoot crashes</li><li>Exercise: Troubleshooting crashes</li><li>Introduction to WebSphere out-of-memory problems</li><li>Exercise: Troubleshooting an out-of-memory condition</li><li>Introduction to database connection problems</li><li>Exercise: Troubleshooting database connection problems</li><li>Tuning and connection pool management problems</li><li>Exercise: Troubleshooting a connection leak</li><li>WebSphere security configuration problems</li><li>Exercise: Troubleshooting security problems</li><li>Application deployment problems</li><li>Server start failures</li><li>Exercise: Troubleshooting server start failures</li><li>Request flow and web container problems</li><li>Exercise: Troubleshooting request flow and web container problems</li><li>Default messaging provider problem determination</li><li>Exercise: Troubleshooting WebSphere default messaging</li><li>WebSphere installation problems when using IBM Installation Manager</li><li>Intelligent Management problem determination and problem determination tools</li><li>Exercise: Configuring health management policies</li><li>Course summary</li></ul></div>

Nexus Human

IMS Productivity Analyst

IBM MQ

WA591 IBM WebSphere Application Server V8.5.5 Problem Determination

<div id="course-pills-1">Duration<p>4 Days</p><p>24 CPD hours</p>This course is intended for<p>The audience includes System administrators, IT administrators, Maintenance personnel, Procurement personnel, Inventory personnel, Asset managers and work managers. The audience also includes consultants that are looking to gain an understanding of Maximo Asset Management 7.6.x.</p>Overview<p>After completing this course, you should be able to perform the following tasks:<br />Describe the Asset Management Lifecycle in Maximo<br />Query and Retrieve Data<br />Describe options available for various applications<br />Describe and use the different Maximo applications and functions as they relate to business processes<br />Enter core data elements and data structures</p><p>This course helps clients to make informed business decisions with the design and planning of their implementation.  Consultants gain a foundation on which to build their product knowledge and skill set. The foundation also helps in working with clients to obtain optimal value from the product.  It provides the fundamental concepts and setup considerations of the various business areas that Maximo supports and, as a bonus section, the new Work Center functionality.<br />This course consists of lectures, demonstrations, and labs that cover applications, processes and interrelationships within Maximo.</p></div><div id="course-pills-2"><h4>IBM Maximo Asset Management Overview</h4><ul><li>This unit provides a high-level overview of IBM Maximo Asset Management framework architecture and its key element and components.  You learn about strategic asset management with IBM Maximo Asset Management to manage assets through their life cycle. You also discuss implementation considerations and system configuration as they pertain to integrations, reporting, and business processes.</li></ul><h4>Item Planning and Setup</h4><ul><li>This unit focuses on the planning and setup of inventory item and asset configurations. You use the applications to set up inventory items and asset configurations in Maximo.</li></ul><h4>Assets</h4><ul><li>This unit focuses on the creation of assets and how they are used in Maximo Asset Management.  You will learn the applications that can create assets, associate assets to people and locations and learn how to move assets between locations. </li></ul><h4>Work Management</h4><ul><li>This unit focuses on learning to use Maximo for work management with the generation and processing of work orders to completion.  This unit will include the new Work Centers that came available in Maximo 7.6.0.5.  Work Centers are made available for Business Analyst, Supervisors and Workers complete the work order tasks.  We will also look at the new Inspection Form tool.</li></ul><h4>Purchasing</h4><ul><li>This unit focuses on learning to use Maximo for procurement, starting with generating purchase requests, then processing them, and completing them.</li></ul><h4>Developer and System Administration</h4><ul><li>Each lesson in this unit focuses on different aspects of entering records into the database. This unit is also an overview of the different applications and setup options that are available with IBM Maximo Asset Management. The focus is on using applications that are primarily used for building (setting up) the database. </li></ul></div><div id="course-pills-3"><h4>Additional course details:</h4><br /><p>Nexus Humans U5TR572 - IBM Maximo Asset Management Fundamentals v7.6.x 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 U5TR572 - IBM Maximo Asset Management Fundamentals v7.6.x 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>

Asset Management

Manager Training

U5TR572 - IBM Maximo Asset Management Fundamentals v7.6.x

Harpenden

<p>The principles of effective time management are applicable to all aspects of life. When successfully applied in a sales environment they can lead to improved performance, higher sales and increased customer satisfaction. All salespeople would benefit from learning the tools and techniques to introduce impactful time management to their working lives.</p><p>We have developed this programme to be practical, fun and interactive. Participants will better understand how to increase the amount of time spent on high-value sales activities, be able to improve their self-motivation and ability to get more done, and be better able to plan, delegate and speed up routine tasks.</p>This course will help participants:<ul><li>Learn key principles of managing sales priorities, meeting targets and getting 'everything' done!</li><li>Learn proven techniques for structuring your day, week and normal routine</li><li>Develop effective sales time management at the office and on the road</li><li>Learn a seven-step process for setting goals and objectives in your work and personal life</li><li>Understand how to make time for sales prospecting, designated call days</li><li>Understand practical ways to improve your time management</li></ul><section>
                    <h3>1 Key principles of sales time management</h3><ul><li>Course objectives and review of time log</li><li>Essential principles of sales time management</li><li>How do you use your time now?</li><li>Reviewing your working day (from pre-course survey)</li><li>Beliefs and feelings about time</li></ul> <h3>2 Managing sales priorities and planning systems</h3><ul><li>Managing priorities and planning systems</li><li>Use organised persistence to plan your sales activity</li><li>Planning your territory and prospecting activity</li><li>How to use priority ratings not urgency to react to tasks</li></ul> <h3>3 Dealing with distractions and communication skills</h3><ul><li>Know your time 'bandits' and creating more positive habits to overcome them</li><li>Making time by saying 'no' assertively and managing expectations</li><li>Assertiveness techniques for handling colleagues and clients</li><li>Making meetings worthwhile - preparation and planning</li></ul> <h3>4 Sales goal setting and action planning</h3><ul><li>Set clear, concise, and motivating sales goals and action plans</li><li>How to set and use goal setting as way of managing your time and increasing results</li><li>The principles of linking SMART objectives to action plans and daily activities</li></ul> <h3>5 Creating results focus - every day, week, and month</h3><ul><li>Batch sales tasks together, starting with emails</li><li>Planning your day and week and protecting sales 'prime' time</li><li>Apply the 80/20 to your sales contacts, clients, and prospects</li></ul> <h3>6 Overcoming procrastination and structuring your day</h3><ul><li>Understanding procrastination, what it is and how to recognise it in yourself and others</li><li>How to stop procrastinating and start making progressing</li><li>Build a power prospecting hour into every day</li><li>Smart stuff to make more sales time: five automated tools</li><li>Live the $64,000 dollar question</li></ul> 


                </section>

The In House Training Company

Sales Manager

Office Skills & Productivity

Time Management

Sales Management

Management Skills

Personal Productivity

Sales time management (In-House)

<div id="course-pills-1">Duration<p>2 Days</p><p>12 CPD hours</p>This course is intended for<p></p><p>This course can be valuable for anyone who needs to write basic SQL or Transact-SQL queries. This includes anyone working with data as a data analyst, a data engineer, a data scientist, a database administrator or a database developer. It can also be useful for others peripherally involved with data, or wanting to learn more about working with data such as solution architects, students and technology managers.</p><p></p><p></p><p>This course will teach the basics of Microsoft's dialect of the standard SQL language: Transact-SQL. Topics include both querying and modifying data in relational databases that are hosted in Microsoft SQL Server-based database systems, including: Microsoft SQL Server, Azure SQL Database and, Azure Synapse Analytics.</p><p></p></div><div id="course-pills-2"><h3>1 - Introduction to Transact-SQL</h3> <ul> <li>Work with schemas</li> <li>Explore the structure of SQL statements</li> <li>Examine the SELECT statement</li> <li>Work with data types</li> <li>Handle NULLs</li> </ul> <h3>2 - Sort and filter results in T-SQL</h3> <ul> <li>Sort your results</li> <li>Limit the sorted results</li> <li>Page results</li> <li>Remove duplicates</li> <li>Filter data with predicates</li> </ul> <h3>3 - Combine multiple tables with JOINs in T-SQL</h3> <ul> <li>Understand joins concepts and syntax</li> <li>Use inner joins</li> <li>Use outer joins</li> <li>Use cross joins</li> <li>Use self joins</li> </ul> <h3>4 - Write Subqueries in T-SQL</h3> <ul> <li>Understand subqueries</li> <li>Use scalar or multi-valued subqueries</li> <li>Use self-contained or correlated subqueries</li> </ul> <h3>5 - Use built-in functions and GROUP BY in Transact-SQL</h3> <ul> <li>Categorize built-in functions</li> <li>Use scalar functions</li> <li>Use ranking and rowset functions</li> <li>Use aggregate functions</li> <li>Summarize data with GROUP BY</li> <li>Filter groups with HAVING</li> </ul> <h3>6 - Modify data with T-SQL</h3> <ul> <li>Insert data</li> <li>Generate automatic values</li> <li>Update data</li> <li>Delete data</li> <li>Merge data based on multiple tables</li> </ul></div><div id="course-pills-3"><h4>Additional course details:</h4><br /><p>Nexus Humans DP-080T00 Querying Data with Microsoft Transact-SQL 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 DP-080T00 Querying Data with Microsoft Transact-SQL 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>

Learning & Development

Design & Technology Courses (DT)

Data Skills

Trainers Course

Microsoft AZ-303

Teaching & Training

DP-080T00 Querying Data with Microsoft Transact-SQL

<div id="course-pills-1">Duration<p>2 Days</p><p>12 CPD hours</p>This course is intended for<p>This class has something for everything, from beginners who wish to customise their data entry forms in SharePoint right up to advanced users who need to use advanced formulas to deliver more bespoke actions to their apps.</p>Overview<p>After taking this course, students will be able to: - Understand when to use PowerApp. - Describe the components of PowerApps and their correct use. - Create PowerApps from existing data sources. - Brand PowerApps. - Customize PowerApps beyond just using the automated wizards. - Connect to a range of data sources from Excel to Azure SQL. - Understand the difference between canvas apps and model-driven apps. - Integrate PowerApps with other Office 365 systems ? including Teams and SharePoint Online. - Administer and Maintain PowerApps</p><p>Students will be taught how to design, test and publish new apps that work with a variety of data sources. We will take users through a selection of well-crafted lessons to help them build new applications for their business.</p></div><div id="course-pills-2"><h3>1 - AN INTRODUCTION TO POWERAPPS</h3> <ul> <li>What is PowerApps?</li> <li>The benefits of apps</li> <li>How to get PowerApps</li> <li>Canvas Apps and Model-Driven Apps</li> <li>License Options and Costs</li> <li>Discover PowerApps with Templates</li> <li>Lab 1: Introduction to PowerApps</li> </ul> <h3>2 - GETTING STARTED WITH POWERAPPS</h3> <ul> <li>Building a new app from a data source</li> <li>Add, edit and remove controls</li> <li>Intro to Formulas</li> <li>Testing an app</li> <li>App Settings</li> <li>Publish and Share Apps</li> <li>Version History and Restore</li> <li>PowerApps Mobile App</li> <li>Lab 1: Getting Started</li> </ul> <h3>3 - BRANDING AND MEDIA</h3> <ul> <li>Less is more</li> <li>Duplicate Screens</li> <li>Fonts</li> <li>Screen Colours and Matching Colours</li> <li>Screen Backgrounds</li> <li>Buttons and Icons</li> <li>Hide on Timer</li> <li>Size and Alignment by reference</li> <li>Show and Hide on Timer</li> <li>Lab 1: Branding and Media</li> </ul> <h3>4 - POWERAPPS CONTROLS</h3> <ul> <li>Text Controls for Data Entry and Display</li> <li>Controls ? Drop downs, combo box, date picker, radio button and more</li> <li>Forms ? Add and edit data in underlying data sources quickly</li> <li>Charts ? present information in pie, line and bar charts</li> <li>Lab 1: Build Apps from Blank</li> </ul> <h3>5 - DATA SOURCES AND LOGIC</h3> <ul> <li>Data Storage and Services</li> <li>How do I decide which database to use?</li> <li>Connect to on-premises data - Gateway</li> <li>What is Delegation?</li> <li>Specific Data Examples</li> <li>Displaying Data</li> <li>Lab 1: Data Source and Logic</li> </ul> <h3>6 - MODEL-DRIVEN APPS</h3> <ul> <li>What is a model-driven app?</li> <li>Where will my data be stored?</li> <li>How do create a model-driven app</li> <li>Canvas vs model-driven summary</li> <li>Lab 1: Model-Driven App</li> </ul> <h3>7 - POWERAPP INTEGRATION</h3> <ul> <li>Embed PowerApps in Teams</li> <li>Embed PowerApps in SharePoint Online</li> <li>Start a Flow from a PowerApp</li> <li>Lab 1: PowerApp Integration</li> </ul> <h3>8 - ADMINISTRATION AND MAINTENANCE OF POWERAPPS</h3> <ul> <li>Identify which users have been using PowerApps</li> <li>Reuse an app in another location (move from testing or development to production)</li> <li>Review app usage</li> <li>Prevent a user from using PowerApps</li> <li>Manage environments</li> <li>Lab 1: Administration and Maintenance</li> </ul></div><div id="course-pills-3"><h4>Additional course details:</h4><br /><p>Nexus Humans 55265 Microsoft PowerApps 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 55265 Microsoft PowerApps 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 Power Apps

Power Apps

Microsoft AZ-900

Microsoft Power Platform

Microsoft AZ-700

Microsoft Power Automate

55265 MicrosoftÂ© PowerApps

<div id="course-pills-1">Duration<p>1 Days</p><p>6 CPD hours</p>This course is intended for<p>The Power BI in a Day course is designed for beginners and intermediate users of Power BI.</p>Overview<p>#NAME?</p><p>Students will discover the full capabilities of Power BI in a one-day, hands-on workshop. Please Note: This workshop is primarily self-directed and students will work at their own pace while having access to an instructor for questions.</p></div><div id="course-pills-2"><h3>1 - Accessing &amp; Preparing data</h3> <ul> <li>Data Set</li> <li>Power BI Desktop</li> <li>Power BI Desktop ? Accessing Data</li> <li>Power BI Desktop ? Data Preparation</li> </ul> <h3>2 - Data Modeling and Exploration</h3> <ul> <li>Power BI Desktop ? Data Modeling and Exploration</li> <li>Power BI Desktop ? Data Exploration Continued</li> <li>References</li> </ul> <h3>3 - Data Visualization</h3> <ul> <li>Power BI Desktop</li> <li>Power BI Desktop ? Data Visualization</li> <li>References</li> </ul> <h3>4 - Publishing &amp; Accessing Reports</h3> <ul> <li>Power BI Desktop ? Creating Mobile View</li> <li>Power BI Service</li> <li>Power BI Service ? Publishing Report</li> <li>Power BI Mobile ? Accessing Report on Mobile Device</li> <li>Power BI Service ? Collaboration and Distribution</li> <li>References</li> </ul> <h3>5 - Dashboard and Collaboration</h3> <ul> <li>Power BI Service</li> <li>Building Dashboard</li> <li>References</li> </ul></div><div id="course-pills-3"><h4>Additional course details:</h4><br /><p>Nexus Humans Power BI: Dashboard in a Day 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 Power BI: Dashboard in a Day 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>

Powerbi

Tableau Desktop Specialist

Business Analytics & Intelligence

Microsoft BI

Power BI: Dashboard in a Day

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

Microsoft Certification

Microsoft 365

Microsoft AZ-104

MD-102T00 Microsoft 365 Endpoint Administrator

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

Sccm

Microsoft Certified Technology Specialist (MCTS)

Commercial & Contract Management Certification Program (CCM)

IT Manager

Microsoft Certified Trainer (MCT)

55348 Administering Microsoft Endpoint Configuration Manager

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

Hi-Tech Training

City & Guilds

Electronics

Digital Design

Electrical Engineering

Analog Electronics

Computer Engineering

Digital Skills

Online Education

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

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

Digital Electronics Course Online

Deposit Only

Full Price (including Deposit)

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

Verhoef Training Ltd.

New Db2 13 Functions and Features - CV321G

Early bird

Book your place early to get an extra discount!

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

Online Course Creation

Microsoft Sharepoint

SharePoint

55215 SharePoint Online Power User

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



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


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


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


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


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


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


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

Bayfield Training

Financial Modelling & Analysis

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

Excel Analytics

Access VBA

Visual Basic Analysis

Excel - Automating Excel with Macros and Analysis Tools

6862 Productivity courses

For all of our courses go to tunneys.co.uk

By Tunneys

ADVANCED VALUATION FOR INSTITUTIONAL INVESTORS

By Behind The Balance Sheet

Boardroom Conflicts! - Causes and Cures

By Ralph Ward

Team Building & Team Development

By Dickson Training Ltd

Operator Licence Awareness (OLAT)

By H-TEC Transport Services

Growth Leadership Programme

By The Power Within Training & Development Ltd

School History Tour Medical Emergency - 2019 Case Study

By Xcursion

WA591 IBM WebSphere Application Server V8.5.5 Problem Determination

By Nexus Human

U5TR572 - IBM Maximo Asset Management Fundamentals v7.6.x

By Nexus Human

Sales time management (In-House)

By The In House Training Company

Search By Location