Name: Excel Pivot Tables, Pivot Charts, Slicers, and Timelines
Price: 12 GBP
Availability: InStock

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

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

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

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

Apex Learning

Microsoft Certification

Finance Cert & Exam Prep

Online Course Creation

Computing Skills

Microsoft Excel

Spreadsheet

Microsoft Excel Course for Everyone - Complete Excel Course

General Admission

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

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

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

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

Online Course Marketing

Certification in Cash & Voucher Assistant (CVA)

Practical Accounting

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

<h3><b>Overview</b></h3>
<span>This comprehensive course on New Functions in Microsoft Excel 2021
will deepen your understanding on this topic.</span>

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

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

<span>There is no time limit for completing this course, it can be studied in your own time at your own pace.</span>
<h3><b>Career path</b></h3>
<span>Having these various qualifications will increase the value in your CV and open you up to multiple sectors such as Business &amp; Management, Admin, Accountancy &amp; Finance, Secretarial &amp; PA, Teaching &amp; Mentoring etc.</span> <h3>Course Curriculum</h3><div><p>1 sections • 10 lectures • 01:11:00 total length</p></div><div><div><div><div><div><div><div><p>•Introduction and Agenda: 00:07:00</p></div><div><div><p>•RANDARRAY: 00:04:00</p></div><div><div><p>•UNIQUE: 00:05:00</p></div><div><div><p>•SEQUENCE: 00:04:00</p></div><div><div><p>•SORT and SORTBY: 00:09:00</p></div><div><div><p>•SORT A Practical Example: 00:04:00</p></div><div><div><p>•FILTER: 00:07:00</p></div><div><div><p>•FILTER A Practical Example: 00:08:00</p></div><div><div><p>•Other Useful New Functions: 00:15:00</p></div><div><div><p>•Using the New Functions in Reports: 00:08:00</p></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div>

New Functions in Microsoft Excel 2021

<h3><b><span>Overview</span></b></h3>
<span>Master the use of the world's most popular data analysis and office tool, with absolutely no previous experience or training needed.</span>

<span>This course will help you quickly become an expert in the use of Microsoft's best-selling Excel, allowing you to be a valuable asset to any business or organisation.</span>

<span>The Microsoft Excel Level 3</span><b> </b><span>course will teach you how to manage finances, produce spreadsheets, and file invoices in no time. Our innovative training method will have you visualising and presenting company data efficiently. Learn to impress your peers and managers with your intuitive use of Excel and make sure that your administration skills are faultless.</span>
<h3><b><span>How will I get my certificate?</span></b></h3>
You may have to take a quiz or a written test online during or after the course. After successfully completing the course, you will be eligible for the certificate.
<h3><b><span>Who is this course for?</span></b></h3>
<p><span>There is no experience or previous qualifications required for enrolment on this Microsoft Excel Level 3</span><span>. It is available to all students, of all academic backgrounds.</span></p>

<h3><b><span>Requirements</span></b></h3>
<p><span>Our Microsoft Excel Level 3</span><b> </b><span>is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible on tablets and smartphones so you can access your course on wifi, 3G or 4G.</span> <span>There is no time limit for completing this course, it can be studied in your own time at your own pace.</span></p>

<h3><b><span>Career path</span></b></h3>
<p><span>Having these various qualifications will increase the value in your CV and open you up to multiple sectors such as Business &amp; Management , Admin, Accountancy &amp; Finance, Secretarial &amp; PA, Teaching &amp; Mentoring etc.</span></p> <h3>Course Curriculum</h3><div><p>21 sections • 73 lectures • 10:39:00 total length</p></div><div><div><div><div><div><div><div><p>•Introduction to Microsoft Excel 2019 New Features: 00:07:00</p></div><div><div><p>•CONCAT: 00:02:00</p></div><div><div><p>•IFS: 00:01:00</p></div><div><div><p>•MAXIFS: 00:01:00</p></div><div><div><p>•MINIFS: 00:01:00</p></div><div><div><p>•SWITCH: 00:02:00</p></div><div><div><p>•TEXTJOIN: 00:01:00</p></div><div><div><p>•Map Chart: 00:02:00</p></div><div><div><p>•Funnel Chart: 00:01:00</p></div><div><div><p>•Better Visuals: 00:06:00</p></div><div><div><p>•Pivot Table Enhancements: 00:02:00</p></div><div><div><p>•Power Pivot Updates: 00:01:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Navigate the Excel User Interface: 00:28:00</p></div><div><div><p>•Use Excel Commands: 00:10:00</p></div><div><div><p>•Create and Save a Basic Workbook: 00:19:00</p></div><div><div><p>•Enter Cell Data: 00:12:00</p></div><div><div><p>•Use Excel Help: 00:05:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Create Worksheet Formulas: 00:15:00</p></div><div><div><p>•Insert Functions: 00:17:00</p></div><div><div><p>•Reuse Formulas and Functions: 00:17:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Insert, Delete, and Adjust Cells, Columns, and Rows: 00:10:00</p></div><div><div><p>•Search for and Replace Data: 00:09:00</p></div><div><div><p>•Use Proofing and Research Tools: 00:07:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Apply Text Formats: 00:16:00</p></div><div><div><p>•Apply Number Format: 00:08:00</p></div><div><div><p>•Align Cell Contents: 00:09:00</p></div><div><div><p>•Apply Styles and Themes: 00:12:00</p></div><div><div><p>•Apply Basic Conditional Formatting: 00:11:00</p></div><div><div><p>•Create and Use Templates: 00:08:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Preview and Print a Workbook: 00:10:00</p></div><div><div><p>•Set Up the Page Layout: 00:09:00</p></div><div><div><p>•Configure Headers and Footers: 00:07:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Manage Worksheets: 00:05:00</p></div><div><div><p>•Manage Workbook and Worksheet Views: 00:07:00</p></div><div><div><p>•Manage Workbook Properties: 00:06:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Work with Ranges: 00:18:00</p></div><div><div><p>•Use Specialized Functions: 00:11:00</p></div><div><div><p>•Work with Logical Functions: 00:23:00</p></div><div><div><p>•Work with Date &amp; Time Functions: 00:08:00</p></div><div><div><p>•Work with Text Functions: 00:11:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Sort Data: 00:10:00</p></div><div><div><p>•Filter Data: 00:10:00</p></div><div><div><p>•Query Data with Database Functions: 00:09:00</p></div><div><div><p>•Outline and Subtotal Data: 00:09:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Apply Intermediate Conditional Formatting: 00:07:00</p></div><div><div><p>•Apply Advanced Conditional Formatting: 00:05:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Create Charts: 00:13:00</p></div><div><div><p>•Modify and Format Charts: 00:12:00</p></div><div><div><p>•Use Advanced Chart Features: 00:12:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Create a PivotTable: 00:13:00</p></div><div><div><p>•Analyze PivotTable Data: 00:12:00</p></div><div><div><p>•Present Data with PivotCharts: 00:07:00</p></div><div><div><p>•Filter Data by Using Timelines and Slicers: 00:11:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Use Links and External References: 00:12:00</p></div><div><div><p>•Use 3-D References: 00:06:00</p></div><div><div><p>•Consolidate Data: 00:05:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Use Lookup Functions: 00:12:00</p></div><div><div><p>•Trace Cells: 00:09:00</p></div><div><div><p>•Watch and Evaluate Formulas: 00:08:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Collaborate on a Workbook: 00:19:00</p></div><div><div><p>•Protect Worksheets and Workbooks: 00:08:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Apply Data Validation: 00:13:00</p></div><div><div><p>•Search for Invalid Data and Formulas with Errors: 00:04:00</p></div><div><div><p>•Work with Macros: 00:18:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Create Sparklines: 00:07:00</p></div><div><div><p>•MapData: 00:07:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Determine Potential Outcomes Using Data Tables: 00:08:00</p></div><div><div><p>•Determine Potential Outcomes Using Scenarios: 00:09:00</p></div><div><div><p>•Use the Goal Seek Feature: 00:04:00</p></div><div><div><p>•Forecasting Data Trends: 00:05:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Excel Templates: 00:00:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Resources - Microsoft Excel - Beginner Course - Cpd Accredited: 00:00:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Assignment - Microsoft Excel Level 3: 00:00:00</p></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div>

Computer Skills

Microsoft Office

Microsoft AZ-303

Microsoft Excel Level 3

<div>
						<div>
							<div>
							<section>
						<div>
							<div>
					<div>
			<div>
							<div>
						<div>
				<div>
			<h2>Overview
</h2>		</div>
				</div>
				<div>
				<div>
								<div>
					<p><span>This comprehensive course on </span><b><span>Advanced Excel Course (Formula, VLOOKUP &amp; Power Query)</span></b> will deepen your understanding on this topic. <span><span>After successful completion of this course you can acquire the required skills in this sector. This </span><b>Advanced Excel Course (Formula, VLOOKUP &amp; Power Query)</b> comes with accredited certification from CPD, which will enhance your CV and make you worthy in the job market.</span></p><p><span><span>So enrol in this course today to fast track your career ladder.</span></span></p>					</div>
						</div>
				</div>
						</div>
					</div>
		</div>
								</div>
					</div>
		</section>
				<section>
						<div>
							<div>
					<div>
			<div>
							<div>
								</div>
					</div>
		</div>
								</div>
					</div>
		</section>
				<section>
						<div>
							<div>
					<div>
			<div>
							<div>
						<div>
				<div>
			<h2>How will I get my certificate?</h2>		</div>
				</div>
				<div>
				<div>
								<div>
					<p>You may have to take a quiz or a written test online during or after the course. After successfully completing the course, you will be eligible for the certificate.</p>					</div>
						</div>
				</div>
				<div>
				<div>
			<h2>Who is This course for?</h2>		</div>
				</div>
				<div>
				<div>
								<div>
					<p><span>There is no experience or previous qualifications required for enrolment on this </span><b><span>Advanced Excel Course (Formula, VLOOKUP &amp; Power Query)</span></b>. It is available to all students, of all academic backgrounds.</p>					</div>
						</div>
				</div>
				<div>
				<div>
			<h2>Requirements</h2>		</div>
				</div>
				<div>
				<div>
								<div>
					<p><span>Our </span><b><span>Advanced Excel Course (Formula, VLOOKUP &amp; Power Query)</span></b> is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible with tablets and smartphones so you can access your course on Wi-Fi, 3G or 4G. <span><span>There is no time limit for completing this course, it can be studied in your own time at your own pace.</span></span></p>					</div>
						</div>
				</div>
				<div>
				<div>
			<h2>Career Path</h2>		</div>
				</div>
				<div>
				<div>
								<div>
					<p>Learning this new skill will help you to advance in your career. It will diversify your job options and help you develop new techniques to keep up with the fast-changing world. This skillset will help you to-</p><ul><li>Open doors of opportunities</li><li>Increase your adaptability</li><li>Keep you relevant</li><li>Boost confidence</li></ul><p>And much more!</p><p> </p>					</div>
						</div>
				</div>
						</div>
					</div>
		</div>
								</div>
					</div>
		</section>
						</div>
						</div>
					</div> <h3>Course Curriculum</h3><div><p>5 sections • 41 lectures • 02:56:00 total length</p></div><div><div><div><div><div><div><div><p>•How to Get the most of the course: 00:01:00</p></div><div><div><p>•Text formulas in Excel: 00:08:00</p></div><div><div><p>•Text Formulas Exercise: 00:01:00</p></div><div><div><p>•Text Formulas Exercise (answers): 00:01:00</p></div><div><div><p>•Mathematical Formulas In Excel: 00:04:00</p></div><div><div><p>•Mathematical Formulas Exercise: 00:01:00</p></div><div><div><p>•Mathematical Formulas Exercise (answers): 00:01:00</p></div><div><div><p>•Date and Time Formulas In Excel: 00:05:00</p></div><div><div><p>•Date and Time Formulas Exercise: 00:01:00</p></div><div><div><p>•Date and Time Exercise Formulas (answers): 00:01:00</p></div><div><div><p>•Logic Formulas In Excel: 00:12:00</p></div><div><div><p>•Logic Formula Exercise: 00:01:00</p></div><div><div><p>•Logic Formula Exercise (answers): 00:01:00</p></div><div><div><p>•Financial Formula In Excel: 00:06:00</p></div><div><div><p>•Financial Formula Exercise: 00:01:00</p></div><div><div><p>•Financial Formula Exercise (answers): 00:02:00</p></div><div><div><p>•Informational Formula In Excel: 00:04:00</p></div><div><div><p>•Informational Formula Exercise: 00:01:00</p></div><div><div><p>•Informational Formula Exercise (answers): 00:01:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Menu Example with Excel Vlookup: 00:08:00</p></div><div><div><p>•Wildcard Search with Excel Vlookup: 00:09:00</p></div><div><div><p>•Looking to the Left with Excel Vlookup: 00:17:00</p></div><div><div><p>•2-Way Lookup: 00:14:00</p></div><div><div><p>•Comparing Lists with Excel Vlookup: 00:03:00</p></div><div><div><p>•Microsoft Excel Vlookup Tips and Tricks: 00:14:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Power Query Intro and Excel version: 00:03:00</p></div><div><div><p>•Excel Power Query - Introduction: 00:03:00</p></div><div><div><p>•Enabling M in Power Query: 00:02:00</p></div><div><div><p>•Transform Data - Trim in Excel Power Query: 00:05:00</p></div><div><div><p>•Transform Data - Format Dates and Values in Excel Power Query: 00:02:00</p></div><div><div><p>•Simple Expressions: 00:08:00</p></div><div><div><p>•Simple Expressions - Nested Expressions: 00:03:00</p></div><div><div><p>•Transform Data - Parsing URLs in Excel Power Query: 00:05:00</p></div><div><div><p>•Variables: 00:08:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Formatting Excel Keyboard Shortcuts: 00:02:00</p></div><div><div><p>•Table Excel Keyboard Shortcuts: 00:02:00</p></div><div><div><p>•Editing Excel Keyboard Shortcuts: 00:05:00</p></div><div><div><p>•Formula Excel Keyboard Shortcuts: 00:03:00</p></div><div><div><p>•Workbook Excel Keyboard Shortcuts: 00:02:00</p></div><div><div><p>•Handy Excel Shortcuts Keyboard Shortcuts: 00:05:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Assignment - Advanced Excel Course (Formula, VLOOKUP &amp; Power Query): 00:00:00</p></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div>

Trainers Course

Advanced Excel Course (Formula, VLOOKUP & Power Query)

<h3><strong>Overview</strong></h3>
This comprehensive course on <strong>Excel: Top 50 Microsoft Excel Formulas in 50 Minutes!</strong> will deepen your understanding <span>on this topic.</span>

After successful completion of this course you can acquire the required skills in this sector. This <strong>Excel: Top 50 Microsoft Excel Formulas in 50 Minutes!</strong> comes with accredited certification which will enhance your CV and make you worthy in the job market.

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

There is no time limit for completing this course, it can be studied in your own time at your own pace.
<h3><strong>Career path</strong></h3>
Having these various qualifications will increase the value in your CV and open you up to multiple sectors such as Business &amp; Management, Admin, Accountancy &amp; Finance, Secretarial &amp; PA, Teaching &amp; Mentoring etc. <h3>Course Curriculum</h3><div><p>2 sections • 23 lectures • 01:56:00 total length</p></div><div><div><div><div><div><div><div><p>•Excel promo: 00:01:00</p></div><div><div><p>•Getting the most of the course: 00:01:00</p></div><div><div><p>•How to Get the most of the course: 00:01:00</p></div><div><div><p>•Text formulas in Excel: 00:08:00</p></div><div><div><p>•Text Formulas Exercise: 00:01:00</p></div><div><div><p>•Text Formulas Exercise (answers): 00:01:00</p></div><div><div><p>•Mathematical Formulas In Excel: 00:04:00</p></div><div><div><p>•Mathematical Formulas Exercise: 00:01:00</p></div><div><div><p>•Mathematical Formulas Exercise (answers): 00:01:00</p></div><div><div><p>•Date and Time Formulas In Excel: 00:06:00</p></div><div><div><p>•Date and Time Formulas Exercise: 00:01:00</p></div><div><div><p>•Date and Time Exercise Formulas (answers): 00:01:00</p></div><div><div><p>•Logic Formulas In Excel: 00:12:00</p></div><div><div><p>•Logic Formula Exercise: 00:01:00</p></div><div><div><p>•Logic Formula Exercise (answers): 00:01:00</p></div><div><div><p>•Financial Formula In Excel: 00:06:00</p></div><div><div><p>•Financial Formula Exercise: 00:01:00</p></div><div><div><p>•Financial Formula Exercise (answers): 00:02:00</p></div><div><div><p>•Informational Formula In Excel: 00:04:00</p></div><div><div><p>•Informational Formula Exercise: 00:01:00</p></div><div><div><p>•Informational Formula Exercise (answers): 00:01:00</p></div><div><div><p>•Getting Traffic To Your Site: 01:00:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Resources : Excel: Top 50 Microsoft Excel Formulas in 50 Minutes!: 00:00:00</p></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div>

Excel: Top 50 Microsoft Excel Formulas in 50 Minutes!

<h3><strong>Overview</strong></h3>
This comprehensive course on <strong>Microsoft Excel: Master Power Query in 120 Minutes!</strong> will deepen your understanding <span>on this topic.</span>

After successful completion of this course you can acquire the required skills in this sector. This <strong>Microsoft Excel: Master Power Query in 120 Minutes!</strong> comes with accredited certification which will enhance your CV and make you worthy in the job market.

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

There is no time limit for completing this course, it can be studied in your own time at your own pace.
<h3><strong>Career path</strong></h3>
Having these various qualifications will increase the value in your CV and open you up to multiple sectors such as Business &amp; Management, Admin, Accountancy &amp; Finance, Secretarial &amp; PA, Teaching &amp; Mentoring etc. <h3>Course Curriculum</h3><div><p>1 sections • 25 lectures • 02:25:00 total length</p></div><div><div><div><div><div><div><div><p>•Power Query Intro and Excel version: 00:03:00</p></div><div><div><p>•Excel Power Query - Introduction: 00:03:00</p></div><div><div><p>•Excel Power Query - Query Editor Ribbon: 00:09:00</p></div><div><div><p>•Transform Data - Trim in Excel Power Query: 00:05:00</p></div><div><div><p>•Transform Data - Format Dates and Values in Excel Power Query: 00:02:00</p></div><div><div><p>•Transform Data - Parsing URLs in Excel Power Query: 00:05:00</p></div><div><div><p>•Transform Data - Split Text Fields in Excel Power Query: 00:10:00</p></div><div><div><p>•Transform Data - Group By in Excel Power Query: 00:03:00</p></div><div><div><p>•Transform Data - Unpivoting Columns in Excel Power Query: 00:05:00</p></div><div><div><p>•Transform Data - Pivoting Columns in Excel Power Query: 00:02:00</p></div><div><div><p>•Transform Data - Split Columns into Other Columns in Excel Power Query: 00:04:00</p></div><div><div><p>•Transform Data - Filtering Rows in Excel Power Query: 00:05:00</p></div><div><div><p>•Transform Data - Sorting Columns in Excel Power Query: 00:02:00</p></div><div><div><p>•Transform Data - Transform and Add Columns in Excel Power Query: 00:07:00</p></div><div><div><p>•From Folder - Import From Folder in Excel Power Query: 00:07:00</p></div><div><div><p>•From Folder - Doing Auto Cleanup in Excel Power Query: 00:13:00</p></div><div><div><p>•From Folder - Extract Data from Forms in Excel Power Query: 00:13:00</p></div><div><div><p>•From Workbook - Extract Multiple Criteria in Excel Power Query: 00:05:00</p></div><div><div><p>•From Workbook - Extract Multiple Worksheets in Excel Power Query: 00:04:00</p></div><div><div><p>•Joins - Intro to Joins: 00:04:00</p></div><div><div><p>•Joins - Merging: 00:08:00</p></div><div><div><p>•Joins - Full Outer Join: 00:06:00</p></div><div><div><p>•Joins - Right Anti Join: 00:09:00</p></div><div><div><p>•Power Query - Convert Reports into Pivot Tables: 00:05:00</p></div><div><div><p>•Modulo: 00:06:00</p></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div>

Microsoft Power Apps

Microsoft Power BI

Power Query

Microsoft Power Platform

Microsoft Excel: Master Power Query in 120 Minutes!

<div>
						<div>
							<div>
							<section>
						<div>
							<div>
					<div>
			<div>
							<div>
						<div>
				<div>
			<h2>Overview
</h2>		</div>
				</div>
				<div>
				<div>
								<div>
					<p><span>This comprehensive course on <strong>Microsoft Excel - 25 Must-Know Formulas and Functions </strong></span><span>will deepen your understanding on this topic.</span></p><p><span>After successful completion of this course you can acquire the required skills in this sector. This <strong>Microsoft Excel - 25 Must-Know Formulas and Functions</strong></span><b> </b><span>comes with accredited certification from CPD, which will enhance your CV and make you worthy in the job market.   </span></p><p><span>So enrol in this course today to fast-track your career ladder.</span></p>					</div>
						</div>
				</div>
						</div>
					</div>
		</div>
								</div>
					</div>
		</section>
				<section>
						<div>
							<div>
					<div>
			<div>
							<div>
						<div>
				<div>
			<h2>How will I get my certificate?</h2>		</div>
				</div>
				<div>
				<div>
								<div>
					<p><span>You may have to take a quiz or a written test online during or after the course. After successfully completing the course, you will be eligible for the certificate.</span></p>					</div>
						</div>
				</div>
				<div>
				<div>
			<h2>Who is This course for?</h2>		</div>
				</div>
				<div>
				<div>
								<div>
					<p><span>There is no experience or previous qualifications required for enrolment on this <strong>Microsoft Excel - 25 Must-Know Formulas and Functions</strong></span><span>. It is available to all students, of all academic backgrounds.</span></p>					</div>
						</div>
				</div>
				<div>
				<div>
			<h2>Requirements</h2>		</div>
				</div>
				<div>
				<div>
								<div>
					<p><span>Our <strong>Microsoft Excel - 25 Must-Know Formulas and Functions</strong></span><span> is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible with tablets and smartphones so you can access your course on Wi-Fi, 3G or 4G.</span></p><p><span>There is no time limit for completing this course, it can be studied in your own time at your own pace.</span></p>					</div>
						</div>
				</div>
				<div>
				<div>
			<h2>Career Path</h2>		</div>
				</div>
				<div>
				<div>
								<div>
					<p><span>Learning this new skill will help you to advance in your career. It will diversify your job options and help you develop new techniques to keep up with the fast-changing world. This skillset will help you to-</span></p><ul><li><span>Open doors of opportunities</span></li><li><span>Increase your adaptability</span></li><li><span>Keep you relevant</span></li><li><span>Boost confidence</span></li></ul><p><span>And much more!</span></p>					</div>
						</div>
				</div>
						</div>
					</div>
		</div>
								</div>
					</div>
		</section>
						</div>
						</div>
					</div> <h3>Course Curriculum</h3><div><p>2 sections • 2 lectures • 01:12:00 total length</p></div><div><div><div><div><div><div><div><p>•Must-Know Formulas and Functions: 01:12:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Resource - Microsoft Excel - 25 Must-Know Formulas and Functions: 00:00:00</p></div></div></div></div></div></div></div></div>

Microsoft Certified Trainer (MCT)

Microsoft Excel - 25 Must-Know Formulas and Functions

<div>
						<div>
							<div>
							<section>
						<div>
							<div>
					<div>
			<div>
							<div>
						<div>
				<div>
			<h2>Overview
</h2>		</div>
				</div>
				<div>
				<div>
								<div>
					<p>This comprehensive course on <strong>MET Technician </strong>will deepen your understanding on this topic.</p><p>After successful completion of this course you can acquire the required skills in this sector. This <strong>MET Technician </strong> comes with accredited certification from CPD, which will enhance your CV and make you worthy in the job market.   </p><p>So enrol in this course today to fast-track your career ladder.</p>					</div>
						</div>
				</div>
						</div>
					</div>
		</div>
								</div>
					</div>
		</section>
				<section>
						<div>
							<div>
					<div>
			<div>
							<div>
								</div>
					</div>
		</div>
								</div>
					</div>
		</section>
				<section>
						<div>
							<div>
					<div>
			<div>
							<div>
						<div>
				<div>
			<h2>How will I get my certificate?</h2>		</div>
				</div>
				<div>
				<div>
								<div>
					<p>You may have to take a quiz or a written test online during or after the course. After successfully completing the course, you will be eligible for the certificate.</p>					</div>
						</div>
				</div>
				<div>
				<div>
			<h2>Who is This course for?</h2>		</div>
				</div>
				<div>
				<div>
								<div>
					<p>There is no experience or previous qualifications required for enrolment on this <strong>MET Technician</strong>. It is available to all students, of all academic backgrounds.</p>					</div>
						</div>
				</div>
				<div>
				<div>
			<h2>Requirements</h2>		</div>
				</div>
				<div>
				<div>
								<div>
					<p>Our <strong>MET Technician</strong> is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible with tablets and smartphones so you can access your course on Wi-Fi, 3G or 4G.</p><p>There is no time limit for completing this course, it can be studied in your own time at your own pace.</p>					</div>
						</div>
				</div>
				<div>
				<div>
			<h2>Career Path</h2>		</div>
				</div>
				<div>
				<div>
								<div>
					<p>Learning this new skill will help you to advance in your career. It will diversify your job options and help you develop new techniques to keep up with the fast-changing world. This skillset will help you to-</p><ul><li>Open doors of opportunities</li><li>Increase your adaptability</li><li>Keep you relevant</li><li>Boost confidence</li></ul><p>And much more!</p><p> </p>					</div>
						</div>
				</div>
						</div>
					</div>
		</div>
								</div>
					</div>
		</section>
						</div>
						</div>
					</div> <h3>Course Curriculum</h3><div><p>6 sections • 6 lectures • 01:45:00 total length</p></div><div><div><div><div><div><div><div><p>•Introduction to MET Technician Course: 00:10:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Precautions and Safety: 00:15:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Body Panel Alignment: 00:20:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•SRS Components, Cooling System and On-Board Diagnostics: 00:25:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Vehicle Suspension: 00:20:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Vehicle Alignment: 00:15:00</p></div></div></div></div></div></div></div></div></div></div></div></div>

Technician

Automotive Technician

Certified Technology Specialist (CTS)

Certificate in Education & Training (CET)

OT Technician

MET Technician

<div>
						<div>
							<div>
							<section>
						<div>
							<div>
					<div>
			<div>
							<div>
						<div>
				<div>
			<h2>Overview
</h2>		</div>
				</div>
				<div>
				<div>
								<div>
					<p>This comprehensive course on <strong>Excel Pivot Tables, Pivot Charts, Slicers, and Timelines </strong>will deepen your understanding on this topic.</p><p>After successful completion of this course you can acquire the required skills in this sector. This Excel Pivot Tables, Pivot Charts, Slicers, and Timelines comes with accredited certification from CPD, which will enhance your CV and make you worthy in the job market.</p><p>So enrol in this course today to fast track your career ladder.</p>					</div>
						</div>
				</div>
						</div>
					</div>
		</div>
								</div>
					</div>
		</section>
				<section>
						<div>
							<div>
					<div>
			<div>
							<div>
								</div>
					</div>
		</div>
								</div>
					</div>
		</section>
				<section>
						<div>
							<div>
					<div>
			<div>
							<div>
						<div>
				<div>
			<h2>How will I get my certificate?</h2>		</div>
				</div>
				<div>
				<div>
								<div>
					<p>You may have to take a quiz or a written test online during or after the course. After successfully completing the course, you will be eligible for the certificate.</p>					</div>
						</div>
				</div>
				<div>
				<div>
			<h2>Who is This course for?</h2>		</div>
				</div>
				<div>
				<div>
								<div>
					<p>There is no experience or previous qualifications required for enrolment on this Excel Pivot Tables, Pivot Charts, Slicers, and Timelines. It is available to all students, of all academic backgrounds.</p>					</div>
						</div>
				</div>
				<div>
				<div>
			<h2>Requirements</h2>		</div>
				</div>
				<div>
				<div>
								<div>
					<p>Our Excel Pivot Tables, Pivot Charts, Slicers, and Timelines is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible with tablets and smartphones so you can access your course on Wi-Fi, 3G or 4G.</p><p>There is no time limit for completing this course, it can be studied in your own time at your own pace.</p>					</div>
						</div>
				</div>
				<div>
				<div>
			<h2>Career Path</h2>		</div>
				</div>
				<div>
				<div>
								<div>
					<p>Learning this new skill will help you to advance in your career. It will diversify your job options and help you develop new techniques to keep up with the fast-changing world. This skillset will help you to-</p><ul><li>Open doors of opportunities</li><li>Increase your adaptability</li><li>Keep you relevant</li><li>Boost confidence</li></ul><p>And much more!</p>					</div>
						</div>
				</div>
						</div>
					</div>
		</div>
								</div>
					</div>
		</section>
						</div>
						</div>
					</div> <h3>Course Curriculum</h3><div><p>2 sections • 15 lectures • 01:21:00 total length</p></div><div><div><div><div><div><div><div><p>•Getting started with your Pivot Table: 00:04:00</p></div><div><div><p>•Drill Down: 00:01:00</p></div><div><div><p>•Managing the Field List: 00:02:00</p></div><div><div><p>•Changing the Calculation type with Value Field Settings: 00:06:00</p></div><div><div><p>•Growing your Pivot Table with Multiple Fields: 00:04:00</p></div><div><div><p>•Formatting the Pivot Table: 00:05:00</p></div><div><div><p>•Sorting and Filtering the Pivot Table: 00:03:00</p></div><div><div><p>•Creating a Dashboard with Slicers, Timelines and Pivot Charts: 00:09:00</p></div><div><div><p>•Reporting by day, month, qtr, or year within the Pivot Table: 00:04:00</p></div><div><div><p>•Refreshing the Pivot Data with new data: 00:03:00</p></div><div><div><p>•Adding your own calculations into the Pivot Table: 00:03:00</p></div><div><div><p>•The power of the Filter Section in the Pivot Table: 00:04:00</p></div><div><div><p>•PowerQuery: 00:12:00</p></div><div><div><p>•PowerPivot: 00:21:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Assignment - Excel Pivot Tables, Pivot Charts, Slicers, and Timelines: 00:00:00</p></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div>

Pivot Table

Professional Skills Course (PSC)

Powerpivot

Excel Pivot Tables, Pivot Charts, Slicers, and Timelines

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

Nexus Human

Office Skills & Productivity

Excel Analytics

Access VBA

Visual Basic Analysis

Microsoft Power Automate

Excel - Automating Excel with Macros and Analysis Tools

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

Hi-Tech Training

City & Guilds

Electronics

Digital Design

Electrical Engineering

Analog Electronics

Computer Engineering

Digital Skills

Online Education

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

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

Digital Electronics Course Online

Deposit Only

Full Price (including Deposit)

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



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


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


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


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


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


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

Bayfield Training

Financial Modelling & Analysis

Real Estate Finance

Financial Modelling

Professional Development

Investment Management

Continuous Professional Development (CPD)

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

Real Estate Modelling Masterclass (Advanced Cash Flow Modelling)

Virtual co-working/body doubling deep focus session. Come prepared with a task to work on. After a quick breath practice to focus our minds, we get down to business with a 50 minute work sprint. Review and celebrate to finish. For more information go to The Flo Sessions.

The Flo Coach

Networking

The Flo Sessions - Stop the faff and do the work

The Flo Sessions - Power Hour

<div id="course-pills-1">Duration<p>1 Days</p><p>6 CPD hours</p>This course is intended for<p>Candidates for this exam are users who aspire to improve productivity by automating business processes, analyzing data to produce business insights, and acting more effectively by creating simple app experiences.</p>Overview<p>After completing this course, you will be able to:<br />Describe Microsoft Power Platform components<br />Describe Microsoft Dataverse and connectors<br />Describe cross-cloud scenarios across M365, Dynamics 365, Microsoft Azure and 3rd party services<br />Identify benefits and capabilities of Microsoft Power Platform<br />Identify the basic functionality and business value Microsoft Power Platform components<br />Implement simple solutions with Power Apps, Power Automate, and Power BI</p><p>Learn the business value and product capabilities of Microsoft Power Platform. Create simple Power Apps, connect data with Dataverse, build a Power BI Dashboard, and automate processes with Power Automate. </p></div><div id="course-pills-2"><h4>Module 1: Introduction to Microsoft Power Platform</h4><ul><li>Identify when to use each Microsoft Power Platform component application to create business solution</li><li>Learn the value of using Microsoft Power Platform to create business solutions</li><li>Learn the components and features of Microsoft Power Platform</li></ul><h4>Module 2: Introduction to Microsoft Dataverse</h4><ul><li>Microsoft Dataverse Overview</li></ul><h4>Module 3: Get Started with Power Apps</h4><ul><li>Introduction to Power Apps</li><li>How to build a canvas app</li><li>How to build a model-driven app</li></ul><h4>Module 4: Get Started with Power Automate</h4><ul><li>Power Automate Overview</li><li>How to Build an Automated Solution</li></ul><h4>Module 5: Get Started with Power BI</h4><ul><li>Power BI Overview</li><li>How to Build a Simple Dashboard</li></ul><h4>Module 6: Introduction to Power Virtual Agents</h4><ul><li>Power Virtual Agents overview</li></ul></div><div id="course-pills-3"><h4>Additional course details:</h4><br /><p>Nexus Humans PL-900T00 Microsoft Power Platform Fundamentals training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. </p><p></p> This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. <p></p>Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success.  <p></p>While we feel this is the best course for the PL-900T00 Microsoft Power Platform Fundamentals course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you.  <p></p>Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.<p></p></div>

Microsoft PL-900

Microsoft AZ-900

Microsoft AZ-700

PL-900T00 Microsoft Power Platform Fundamentals

<p id="isPasted" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;"><br fr-original-style="" style="box-sizing: border-box;"></span></p><p id="isPasted" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Real Estate Investments are unique in that they generate both rental income and capital appreciation, making cash flow modelling an essential tool for Real Estate Investors, Lenders, and Analysts.</span></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">On this course, we will use case studies to enhance the delegates understanding of Real Estate financial appraisals, and help them fully appreciate the theory behind the numbers. We will cover topics such as discounting, compounding, forecasting rental income and expenses, calculating net operating income (NOI), factoring in capital expenditures, modelling debt service, and determining the internal rate of return (IRR).</span></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">This course will provide you with a solid foundation for understanding and analysing real estate cash flows.</span></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;"><br fr-original-style="" style="box-sizing: border-box;"></span></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">On this course you will...</strong></span></p><ul fr-original-style="" style="box-sizing: border-box;"><li value="1" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Study the financial concepts of compounding, discounting and in-perpetuity</li><li value="2" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Consider the importance of the timing and uncertainty of both fixed and growing income streams</li><li value="3" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Contrast different property yield metrics</li><li value="4" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Build-up risk premiums for discount rates, discuss the importance of liquidity, transparency and volatility</li><li value="5" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Compare and contrast time and money-weighted measures of return</li><li value="6" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Learn about valuation principles</li><li value="7" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Contrast value and worth</li><li value="8" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Discuss the importance and sourcing of inputs and outputs</li></ul><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;"><br fr-original-style="" style="box-sizing: border-box;"></span></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Who will benefit from this course?</strong></span></p><ul fr-original-style="" style="box-sizing: border-box;"><li value="1" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Professional Real Estate Transaction Managers</li><li value="2" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Asset Managers</li><li value="3" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Portfolio Managers</li><li value="4" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Recent graduates with exposure to real estate financial modelling</li><li value="5" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">New employees with exposure to real estate financial modelling</li><li value="6" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">People working in Argus, Anaplan or any commercial real estate software and would like to understand financial modelling key principles.</li></ul><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;"><br fr-original-style="" style="box-sizing: border-box;"></span></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Course Outline</strong>:</span></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Morning</strong></span></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Real Estate Financial Mathematics</span></p><ul fr-original-style="" style="box-sizing: border-box;"><li value="1" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Time Value of Money</li><li value="2" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Net Present Value (NPV)</li><li value="3" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Internal Rate of Return (IRR)</li><li value="4" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Growth</li><li value="5" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">What Discount Rate?</li><li value="6" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Certainty of a cash flow</li><li value="7" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Liquidity</li></ul><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Price, Value and Worth</span></p><ul fr-original-style="" style="box-sizing: border-box;"><li value="1" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Comparing Price, Value and Worth</li><li value="2" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Conventional Valuation Methods</li><li value="3" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Term and Reversion, Layer Method</li><li value="4" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Property Yields and Capitalisation Method</li><li value="5" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Exit calculations across Europe</li></ul><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;"><br fr-original-style="" style="box-sizing: border-box;"></span></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Afternoon</strong></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Discounted Cash Flow Models</span></p><ul fr-original-style="" style="box-sizing: border-box;"><li value="1" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Investment Appraisal Models</li><li value="2" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Cash flow inputs: Rents, Yields, Growth Rates, Target Returns</li><li value="3" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Cash-on-Cash and Equity Multiple</li><li value="4" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Discount Rates &amp; Exit Cap Rate</li><li value="5" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Operating Assumptions</li><li value="6" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Adding borrowing and analysing geared returns</li></ul><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Model Interpretation and Analysis</span></p><ul fr-original-style="" style="box-sizing: border-box;"><li value="1" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Sensitivity analysis and scenario analysis</li><li value="2" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Growth and inflation</li><li value="3" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Performance measures</li><li value="4" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Contemporary issues for analysis (such as the rise in interest rates)</li></ul><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;"><br fr-original-style="" style="box-sizing: border-box;"></span></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Quizzes | Q&amp;A</span></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;"><br fr-original-style="" style="box-sizing: border-box;"></span></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Included in the Course</strong></span></p><ul fr-original-style="" style="box-sizing: border-box;"><li value="1" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">A Bayfield Training Certificate &amp; 7.5 CPD Hours</li><li value="2" style="font-size: 16px; box-sizing: border-box;" id="isPasted" fr-original-style="font-size: 16px;">Course Manual - In-Person Course attendees will receive a Physical Copy, Virtual Course attendees will receive a Virtual Copy and have the option to purchase a Hard Copy at an additional fee</li><li value="3" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Course Files</li><li value="4" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Online Learning Platform access - Further Learning Resources (Reading, Files and Videos)</li><li value="5" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Post Course Support - Two Months of Questions &amp; Answers, and One year of support is available for an additional fee</li></ul><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;"><br fr-original-style="" style="box-sizing: border-box;"></span></p><p id="isPasted" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">For more information about the Understanding Key Principles of Real Estate Financial Modelling such as course delivery methods, pricing and dates, please contact Sam on the Bayfield Training Sales team:</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">E - s.musgrave@bayfieldtraining.com</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">T - 01223 517851</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">W - <a href="https://www.bayfieldtraining.com/" target="_blank" rel="nofollow noopener noreferrer ugc" title="https://www.bayfieldtraining.com/" data-airgap-id="125" fr-original-style="" style="user-select: auto; font-size: var(--font-size); box-sizing: border-box; cursor: pointer; text-decoration: inherit;">www.bayfieldtraining.com</a></p>



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


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


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


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


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


Quizzes | Q&A


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


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

Property Investment

Risk Management

Investment

Financial Risk Management

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

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

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

Microsoft Teams

Clinical Engineer

MS-721T00 Collaboration Communications Systems Engineer

<div id="course-pills-1">Duration<p>4 Days</p><p>24 CPD hours</p>This course is intended for<p></p><p>The Microsoft Security Operations Analyst collaborates with organizational stakeholders to secure information technology systems for the organization. Their goal is to reduce organizational risk by rapidly remediating active attacks in the environment, advising on improvements to threat protection practices, and referring violations of organizational policies to appropriate stakeholders. Responsibilities include threat management, monitoring, and response by using a variety of security solutions across their environment. The role primarily investigates, responds to, and hunts for threats using Microsoft Sentinel, Microsoft Defender for Cloud, Microsoft 365 Defender, and third-party security products. Since the Security Operations Analyst consumes the operational output of these tools, they are also a critical stakeholder in the configuration and deployment of these technologies.</p><p></p><p></p><p>Learn how to investigate, respond to, and hunt for threats using Microsoft Sentinel, Microsoft Defender for Cloud, and Microsoft 365 Defender. In this course you will learn how to mitigate cyberthreats using these technologies. Specifically, you will configure and use Microsoft Sentinel as well as utilize Kusto Query Language (KQL) to perform detection, analysis, and reporting. The course was designed for people who work in a Security Operations job role and helps learners prepare for the exam SC-200: Microsoft Security Operations Analyst.</p><p></p>Prerequisites<p></p><li>Basic understanding of Microsoft 365</li>  <li>Fundamental understanding of Microsoft security, compliance, and identity products</li>   <li> Intermediate understanding of Windows 10</li>  <li> Familiarity with Azure services, specifically Azure SQL Database and Azure Storage</li>   <li> Familiarity with Azure virtual machines and virtual networking</li>   <li>Basic understanding of scripting concepts.</li><p></p></div><div id="course-pills-2"><h3>1 - Introduction to Microsoft 365 threat protection</h3> <ul> <li>Explore Extended Detection &amp; Response (XDR) response use cases</li> <li>Understand Microsoft Defender XDR in a Security Operations Center (SOC)</li> <li>Explore Microsoft Security Graph</li> <li>Investigate security incidents in Microsoft Defender XDR</li> </ul> <h3>2 - Mitigate incidents using Microsoft 365 Defender</h3> <ul> <li>Use the Microsoft Defender portal</li> <li>Manage incidents</li> <li>Investigate incidents</li> <li>Manage and investigate alerts</li> <li>Manage automated investigations</li> <li>Use the action center</li> <li>Explore advanced hunting</li> <li>Investigate Microsoft Entra sign-in logs</li> <li>Understand Microsoft Secure Score</li> <li>Analyze threat analytics</li> <li>Analyze reports</li> <li>Configure the Microsoft Defender portal</li> </ul> <h3>3 - Protect your identities with Microsoft Entra ID Protection</h3> <ul> <li>Microsoft Entra ID Protection overview</li> <li>Detect risks with Microsoft Entra ID Protection policies</li> <li>Investigate and remediate risks detected by Microsoft Entra ID Protection</li> </ul> <h3>4 - Remediate risks with Microsoft Defender for Office 365</h3> <ul> <li>Automate, investigate, and remediate</li> <li>Configure, protect, and detect</li> <li>Simulate attacks</li> </ul> <h3>5 - Safeguard your environment with Microsoft Defender for Identity</h3> <ul> <li>Configure Microsoft Defender for Identity sensors</li> <li>Review compromised accounts or data</li> <li>Integrate with other Microsoft tools</li> </ul> <h3>6 - Secure your cloud apps and services with Microsoft Defender for Cloud Apps</h3> <ul> <li>Understand the Defender for Cloud Apps Framework</li> <li>Explore your cloud apps with Cloud Discovery</li> <li>Protect your data and apps with Conditional Access App Control</li> <li>Walk through discovery and access control with Microsoft Defender for Cloud Apps</li> <li>Classify and protect sensitive information</li> <li>Detect Threats</li> </ul> <h3>7 - Respond to data loss prevention alerts using Microsoft 365</h3> <ul> <li>Describe data loss prevention alerts</li> <li>Investigate data loss prevention alerts in Microsoft Purview</li> <li>Investigate data loss prevention alerts in Microsoft Defender for Cloud Apps</li> </ul> <h3>8 - Manage insider risk in Microsoft Purview</h3> <ul> <li>Insider risk management overview</li> <li>Create and manage insider risk policies</li> <li>Investigate insider risk alerts</li> <li>Take action on insider risk alerts through cases</li> <li>Manage insider risk management forensic evidence</li> <li>Create insider risk management notice templates</li> </ul> <h3>9 - Investigate threats by using audit features in Microsoft Defender XDR and Microsoft Purview Standard</h3> <ul> <li>Explore Microsoft Purview Audit solutions</li> <li>Implement Microsoft Purview Audit (Standard)</li> <li>Start recording activity in the Unified Audit Log</li> <li>Search the Unified Audit Log (UAL)</li> <li>Export, configure, and view audit log records</li> <li>Use audit log searching to investigate common support issues</li> </ul> <h3>10 - Investigate threats using audit in Microsoft Defender XDR and Microsoft Purview (Premium)</h3> <ul> <li>Explore Microsoft Purview Audit (Premium)</li> <li>Implement Microsoft Purview Audit (Premium)</li> <li>Manage audit log retention policies</li> <li>Investigate compromised email accounts using Purview Audit (Premium)</li> </ul> <h3>11 - Investigate threats with Content search in Microsoft Purview</h3> <ul> <li>Explore Microsoft Purview eDiscovery solutions</li> <li>Create a content search</li> <li>View the search results and statistics</li> <li>Export the search results and search report</li> <li>Configure search permissions filtering</li> <li>Search for and delete email messages</li> </ul> <h3>12 - Protect against threats with Microsoft Defender for Endpoint</h3> <ul> <li>Practice security administration</li> <li>Hunt threats within your network</li> </ul> <h3>13 - Deploy the Microsoft Defender for Endpoint environment</h3> <ul> <li>Create your environment</li> <li>Understand operating systems compatibility and features</li> <li>Onboard devices</li> <li>Manage access</li> <li>Create and manage roles for role-based access control</li> <li>Configure device groups</li> <li>Configure environment advanced features</li> </ul> <h3>14 - Implement Windows security enhancements with Microsoft Defender for Endpoint</h3> <ul> <li>Understand attack surface reduction</li> <li>Enable attack surface reduction rules</li> </ul> <h3>15 - Perform device investigations in Microsoft Defender for Endpoint</h3> <ul> <li>Use the device inventory list</li> <li>Investigate the device</li> <li>Use behavioral blocking</li> <li>Detect devices with device discovery</li> </ul> <h3>16 - Perform actions on a device using Microsoft Defender for Endpoint</h3> <ul> <li>Explain device actions</li> <li>Run Microsoft Defender antivirus scan on devices</li> <li>Collect investigation package from devices</li> <li>Initiate live response session</li> </ul> <h3>17 - Perform evidence and entities investigations using Microsoft Defender for Endpoint</h3> <ul> <li>Investigate a file</li> <li>Investigate a user account</li> <li>Investigate an IP address</li> <li>Investigate a domain</li> </ul> <h3>18 - Configure and manage automation using Microsoft Defender for Endpoint</h3> <ul> <li>Configure advanced features</li> <li>Manage automation upload and folder settings</li> <li>Configure automated investigation and remediation capabilities</li> <li>Block at risk devices</li> </ul> <h3>19 - Configure for alerts and detections in Microsoft Defender for Endpoint</h3> <ul> <li>Configure advanced features</li> <li>Configure alert notifications</li> <li>Manage alert suppression</li> <li>Manage indicators</li> </ul> <h3>20 - Utilize Vulnerability Management in Microsoft Defender for Endpoint</h3> <ul> <li>Understand vulnerability management</li> <li>Explore vulnerabilities on your devices</li> <li>Manage remediation</li> </ul> <h3>21 - Plan for cloud workload protections using Microsoft Defender for Cloud</h3> <ul> <li>Explain Microsoft Defender for Cloud</li> <li>Describe Microsoft Defender for Cloud workload protections</li> <li>Enable Microsoft Defender for Cloud</li> </ul> <h3>22 - Connect Azure assets to Microsoft Defender for Cloud</h3> <ul> <li>Explore and manage your resources with asset inventory</li> <li>Configure auto provisioning</li> <li>Manual log analytics agent provisioning</li> </ul> <h3>23 - Connect non-Azure resources to Microsoft Defender for Cloud</h3> <ul> <li>Protect non-Azure resources</li> <li>Connect non-Azure machines</li> <li>Connect your AWS accounts</li> <li>Connect your GCP accounts</li> </ul> <h3>24 - Manage your cloud security posture management?</h3> <ul> <li>Explore Secure Score</li> <li>Explore Recommendations</li> <li>Measure and enforce regulatory compliance</li> <li>Understand Workbooks</li> </ul> <h3>25 - Explain cloud workload protections in Microsoft Defender for Cloud</h3> <ul> <li>Understand Microsoft Defender for servers</li> <li>Understand Microsoft Defender for App Service</li> <li>Understand Microsoft Defender for Storage</li> <li>Understand Microsoft Defender for SQL</li> <li>Understand Microsoft Defender for open-source databases</li> <li>Understand Microsoft Defender for Key Vault</li> <li>Understand Microsoft Defender for Resource Manager</li> <li>Understand Microsoft Defender for DNS</li> <li>Understand Microsoft Defender for Containers</li> <li>Understand Microsoft Defender additional protections</li> </ul> <h3>26 - Remediate security alerts using Microsoft Defender for Cloud</h3> <ul> <li>Understand security alerts</li> <li>Remediate alerts and automate responses</li> <li>Suppress alerts from Defender for Cloud</li> <li>Generate threat intelligence reports</li> <li>Respond to alerts from Azure resources</li> </ul> <h3>27 - Construct KQL statements for Microsoft Sentinel</h3> <ul> <li>Understand the Kusto Query Language statement structure</li> <li>Use the search operator</li> <li>Use the where operator</li> <li>Use the let statement</li> <li>Use the extend operator</li> <li>Use the order by operator</li> <li>Use the project operators</li> </ul> <h3>28 - Analyze query results using KQL</h3> <ul> <li>Use the summarize operator</li> <li>Use the summarize operator to filter results</li> <li>Use the summarize operator to prepare data</li> <li>Use the render operator to create visualizations</li> </ul> <h3>29 - Build multi-table statements using KQL</h3> <ul> <li>Use the union operator</li> <li>Use the join operator</li> </ul> <h3>30 - Work with data in Microsoft Sentinel using Kusto Query Language</h3> <ul> <li>Extract data from unstructured string fields</li> <li>Extract data from structured string data</li> <li>Integrate external data</li> <li>Create parsers with functions</li> </ul> <h3>31 - Introduction to Microsoft Sentinel</h3> <ul> <li>What is Microsoft Sentinel?</li> <li>How Microsoft Sentinel works</li> <li>When to use Microsoft Sentinel</li> </ul> <h3>32 - Create and manage Microsoft Sentinel workspaces</h3> <ul> <li>Plan for the Microsoft Sentinel workspace</li> <li>Create a Microsoft Sentinel workspace</li> <li>Manage workspaces across tenants using Azure Lighthouse</li> <li>Understand Microsoft Sentinel permissions and roles</li> <li>Manage Microsoft Sentinel settings</li> <li>Configure logs</li> </ul> <h3>33 - Query logs in Microsoft Sentinel</h3> <ul> <li>Query logs in the logs page</li> <li>Understand Microsoft Sentinel tables</li> <li>Understand common tables</li> <li>Understand Microsoft Defender XDR tables</li> </ul> <h3>34 - Use watchlists in Microsoft Sentinel</h3> <ul> <li>Plan for watchlists</li> <li>Create a watchlist</li> <li>Manage watchlists</li> </ul> <h3>35 - Utilize threat intelligence in Microsoft Sentinel</h3> <ul> <li>Define threat intelligence</li> <li>Manage your threat indicators</li> <li>View your threat indicators with KQL</li> </ul> <h3>36 - Connect data to Microsoft Sentinel using data connectors</h3> <ul> <li>Ingest log data with data connectors</li> <li>Understand data connector providers</li> <li>View connected hosts</li> </ul> <h3>37 - Connect Microsoft services to Microsoft Sentinel</h3> <ul> <li>Plan for Microsoft services connectors</li> <li>Connect the Microsoft Office 365 connector</li> <li>Connect the Microsoft Entra connector</li> <li>Connect the Microsoft Entra ID Protection connector</li> <li>Connect the Azure Activity connector</li> </ul> <h3>38 - Connect Microsoft Defender XDR to Microsoft Sentinel</h3> <ul> <li>Plan for Microsoft Defender XDR connectors</li> <li>Connect the Microsoft Defender XDR connector</li> <li>Connect Microsoft Defender for Cloud connector</li> <li>Connect Microsoft Defender for IoT</li> <li>Connect Microsoft Defender legacy connectors</li> </ul> <h3>39 - Connect Windows hosts to Microsoft Sentinel</h3> <ul> <li>Plan for Windows hosts security events connector</li> <li>Connect using the Windows Security Events via AMA Connector</li> <li>Connect using the Security Events via Legacy Agent Connector</li> <li>Collect Sysmon event logs</li> </ul> <h3>40 - Connect Common Event Format logs to Microsoft Sentinel</h3> <ul> <li>Plan for Common Event Format connector</li> <li>Connect your external solution using the Common Event Format connector</li> </ul> <h3>41 - Connect syslog data sources to Microsoft Sentinel</h3> <ul> <li>Plan for syslog data collection</li> <li>Collect data from Linux-based sources using syslog</li> <li>Configure the Data Collection Rule for Syslog Data Sources</li> <li>Parse syslog data with KQL</li> </ul> <h3>42 - Connect threat indicators to Microsoft Sentinel</h3> <ul> <li>Plan for threat intelligence connectors</li> <li>Connect the threat intelligence TAXII connector</li> <li>Connect the threat intelligence platforms connector</li> <li>View your threat indicators with KQL</li> </ul> <h3>43 - Threat detection with Microsoft Sentinel analytics</h3> <ul> <li>What is Microsoft Sentinel Analytics?</li> <li>Types of analytics rules</li> <li>Create an analytics rule from templates</li> <li>Create an analytics rule from wizard</li> <li>Manage analytics rules</li> </ul> <h3>44 - Automation in Microsoft Sentinel</h3> <ul> <li>Understand automation options</li> <li>Create automation rules</li> </ul> <h3>45 - Threat response with Microsoft Sentinel playbooks</h3> <ul> <li>What are Microsoft Sentinel playbooks?</li> <li>Trigger a playbook in real-time</li> <li>Run playbooks on demand</li> </ul> <h3>46 - Security incident management in Microsoft Sentinel</h3> <ul> <li>Understand incidents</li> <li>Incident evidence and entities</li> <li>Incident management</li> </ul> <h3>47 - Identify threats with Behavioral Analytics</h3> <ul> <li>Understand behavioral analytics</li> <li>Explore entities</li> <li>Display entity behavior information</li> <li>Use Anomaly detection analytical rule templates</li> </ul> <h3>48 - Data normalization in Microsoft Sentinel</h3> <ul> <li>Understand data normalization</li> <li>Use ASIM Parsers</li> <li>Understand parameterized KQL functions</li> <li>Create an ASIM Parser</li> <li>Configure Azure Monitor Data Collection Rules</li> </ul> <h3>49 - Query, visualize, and monitor data in Microsoft Sentinel</h3> <ul> <li>Monitor and visualize data</li> <li>Query data using Kusto Query Language</li> <li>Use default Microsoft Sentinel Workbooks</li> <li>Create a new Microsoft Sentinel Workbook</li> </ul> <h3>50 - Manage content in Microsoft Sentinel</h3> <ul> <li>Use solutions from the content hub</li> <li>Use repositories for deployment</li> </ul> <h3>51 - Explain threat hunting concepts in Microsoft Sentinel</h3> <ul> <li>Understand cybersecurity threat hunts</li> <li>Develop a hypothesis</li> <li>Explore MITRE ATT&amp;CK</li> </ul> <h3>52 - Threat hunting with Microsoft Sentinel</h3> <ul> <li>Explore creation and management of threat-hunting queries</li> <li>Save key findings with bookmarks</li> <li>Observe threats over time with livestream</li> </ul> <h3>53 - Use Search jobs in Microsoft Sentinel</h3> <ul> <li>Hunt with a Search Job</li> <li>Restore historical data</li> </ul> <h3>54 - Hunt for threats using notebooks in Microsoft Sentinel</h3> <ul> <li>Access Azure Sentinel data with external tools</li> <li>Hunt with notebooks</li> <li>Create a notebook</li> <li>Explore notebook code</li> </ul></div>

Microsoft AZ-104

Microsoft SC-200

SC-200T00 Microsoft Security Operations Analyst

<div id="course-pills-1">Duration<p>3 Days</p><p>18 CPD hours</p>This course is intended for<p>This course is designed for Administrators who need to setup, configure and manage SharePoint Online as part of their Office 365 Administration.</p>Overview<p>After completing this course, students will gain the skills to:  - Understand the architecture of SharePoint Online  - Have knowledge of all the components in SharePoint Online  - Have on hands on experience configuring the components of SharePoint Online  - Have hands on experience configuring the options  - Work with Site Collections and storage options  - Manage user profiles and social profiling  - Understand and configure data connectivity in SharePoint Online  - Build a taxonomy structure   - Understand and configure Search in SharePoint Online  - Configure and deploy apps  - Understand and define Enterprise content management and data loss prevention.  - Configure additional options and features in SharePoint Online such as Information Rights Management</p><p>This course will introduce the audience to SharePoint Online Administration in Office 365 and explain and demonstrate the configuration options for SharePoint Online. The course is appropriate for existing SharePoint on-premises administrators and new administrators to Office 365 who need to understand how to correctly setup SharePoint Online for their company. The course will also help SharePoint on-premise administrators understand the differences between SharePoint on-premises and SharePoint Online.</p></div><div id="course-pills-2"><h3>1 - INTRODUCTION TO OFFICE 365 AND SHAREPOINT ONLINE</h3> <ul> <li>Introduction to the Office 365 Administration Center</li> <li>Configure Reporting</li> <li>Accessing SharePoint management tools</li> <li>Accessing security and compliancy</li> <li>Managing Office 365 and SharePoint Online with PowerShell</li> <li>Comparing On Premises SharePoint with SharePoint Online</li> <li>User identity in Office 365 and SharePoint Online</li> <li>Manging user domains</li> <li>Building Hybrid scenarios</li> <li>OneDrive and Sites redirection</li> <li>Yammer redirection</li> <li>Understand hybrid search</li> <li>Hybrid business data connectivity</li> <li>Hybrid taxonomy</li> </ul> <h3>2 - WORKING WITH SITE COLLECTIONS</h3> <ul> <li>Introduction to classic and modern admin centers</li> <li>Creating Site Collections</li> <li>Defining ownership and security for site collections</li> <li>Configuring Storage</li> <li>Configure External Access to site collections</li> <li>Recovering site collections</li> <li>Configure external sharing</li> <li>Managing site collections with PowerShell</li> </ul> <h3>3 - MANAGING USER PROFILES</h3> <ul> <li>Overview of the profile service</li> <li>Defining profile properties</li> <li>Map profile properties to a term store</li> <li>Creating custom profile properties</li> <li>Managing audiences</li> <li>Creating audiences</li> <li>Managing user profile policies</li> <li>Configure trusted my site host locations</li> <li>Configure preferred search center locations</li> <li>Defining read access permission levels</li> <li>Configuring newsfeed options</li> <li>Setup email notifications</li> <li>Configure my site cleanup</li> </ul> <h3>4 - WORKING WITH DATA CONNECTIONS</h3> <ul> <li>Introduction to Data Connections</li> <li>Overview of PowerApps, Flow and PowerBi</li> <li>Overview of the business connectivity service</li> <li>Introduction to BDC definition files</li> <li>Creating BDC definition files</li> <li>Introduction to the secure store service</li> <li>Configuring the secure store service</li> <li>Creating secure store target application settings</li> <li>Configure connections to cloud services</li> <li>Configure connections to on-premises services</li> <li>Tools to build data connections</li> <li>Creating external content types</li> <li>Building external lists using external data</li> </ul> <h3>5 - MANAGING THE TERM STORE</h3> <ul> <li>Overview of the term store</li> <li>Understanding terms and life cycle management</li> <li>Creating term groups</li> <li>Creating the term store</li> <li>Creating Term Sets in the UI</li> <li>Creating Term Sets via importing via a CSV</li> <li>Creating terms in the UI</li> <li>Creating terms via PowerShell and CSOM</li> <li>Manage terms with synonyms and pinning</li> <li>Configure delegated administration</li> </ul> <h3>6 - CONFIGURING SEARCH</h3> <ul> <li>An Introduction to the search service</li> <li>Classic versus Modern search experience</li> <li>Understanding Managed Properties</li> <li>Create Managed Properties</li> <li>Manage Authoritative pages</li> <li>Understand Result sources</li> <li>Create and configure result sources</li> <li>Understand Query rules</li> <li>Promoting results through query rules</li> <li>Remove search results from the index</li> <li>Exporting search configurations</li> <li>Importing search configurations</li> </ul> <h3>7 - CONFIGURING APPS</h3> <ul> <li>An Introduction to Apps</li> <li>Understanding the App Catalog</li> <li>Building the App catalog</li> <li>Adding Apps to the catalog</li> <li>Add Apps to your SharePoint sites</li> <li>Adding Apps via the marketplace store</li> <li>Manage App licensing</li> <li>Configure store access settings</li> <li>Monitoring app usage</li> </ul> <h3>8 - ENTERPRISE CONTENT MANAGEMENT IN SHAREPOINT ONLINE</h3> <ul> <li>An Introduction to ECM in SharePoint Online</li> <li>Components of ECM</li> <li>Office 365 versus classic compliancy</li> <li>Understanding In-Place records management</li> <li>Configure In-Place records management</li> <li>Understanding the records center</li> <li>Build and configure a records center</li> <li>Understanding the compliancy policy center</li> <li>Build a compliancy policy center and configure policies</li> <li>Discover the security and compliancy center</li> <li>Configure an eDiscovery center</li> <li>Build an eDiscovery case</li> <li>Understand data loss prevention</li> <li>Build a data loss prevention policy and query</li> <li>Working with classification and data governance</li> </ul> <h3>9 - MANAGE OPTIONS FOR SHAREPOINT ONLINE</h3> <ul> <li>Configure OneDrive features</li> <li>Configure use of Yammer or Newsfeeds</li> <li>Understand Information Rights Management</li> <li>Configure Information Rights Management</li> <li>Define site classification options</li> <li>Understand early release options for Office 365</li> <li>Configure Early release options for your Office 365 tenant</li> <li>Manage Access Control</li> </ul></div><div id="course-pills-3"><h4>Additional course details:</h4><br /><p>Nexus Humans 55238 SharePoint Online for Administrators training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. </p><p></p> This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. <p></p>Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success.  <p></p>While we feel this is the best course for the 55238 SharePoint Online for Administrators course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you.  <p></p>Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.<p></p></div>

Microsoft Sharepoint

Microsoft 365

SharePoint

55238 SharePoint Online for Administrators



Bayfield Training and the University of Cambridge Department of Land Economy
This prestigious eight-week online Real Estate course is suitable for modellers new to Real Estate and experienced Real Estate Analysts looking to formalise their skill set. This course will equip you with skills to start building your own financial models and the certificate will give your employers and colleagues reassurance of your expertise.
If you want to enhance your financial modelling skills over an extended period, the Real Estate Financial Modelling Certificate is the course for you.
This online real estate course has been put together exclusively for the Real Estate Financial Modelling certificate, using state of the art digital resources such as animations, video-steps, digital whiteboard and video-interactions as well as the spreadsheets, text based resources and tutor contact you would expect from any of Bayfield Training’s classroom based courses.
 Assessment is in the form of a guided model build exercise and written model appraisal. Participants benefit from an additional months access to the course platform after submission of the assessment.


On this course you will:
Become a competent model builder, building Real Estate Financial Models from scratch
Learn tricks and concepts from financial modelling experts with decades of experience in practice and academia
Learn how to use Real Estate Financial Models to make informed investment decisions
Learn at a consistent pace over 8 weeks allowing you to take the time to fully grasp this important skill
This course is suitable for:
Chartered Surveyors
Asset Managers
Financial Controllers
Financial Analysts
Investment Managers
Property Managers
Real Estate Students/Recent Graduates
Course Outline:
Module 1 - Economic Context
Introduction to Real Estate Asset Modelling and how it relates to and is distinct from Econometric Models.
Introduction to Real Estate Asset Modelling and how it relates to and is distinct from Econometric Models.
Why Real Estate Asset Modelling is important
Understanding the occupier, asset and development markets and the relevant modelling approaches for each
Real Estate Sub-Sector Key Performance Indicators
Introduction to conventional valuations and financial mathematics
Understanding and minimising errors in Financial Models


Module 2 - Cash Flow Fundamentals
Constructing a financial model from first principles.
Understanding all the components of a basic cash flow model
Understand why Corporate Finance Models and Real Estate Models are different
Financial Model Design
Making the link between valuations, income mathematics and discounted cash flows
Internal Rate of Return, Net Present Value,Worth and other metrics
Features and techniques to aid fast model building


Module 3 - Developing the Cash Flow
Adapting financial models for different periodicities and building rent functions for different rent behaviour.
Understanding how leases vary with respect to rent over time: Rent Reviews, Break Clauses, Rent Free Periods, Lease Expiries etc.
Developing the concept of a Rent Function in Excel
Logic mathematics and Logic functions
Projecting rent to adapt to different lease contracts and growth patterns
Alternative solutions to Logic functions
Comparative analysis of lease structures in different jurisdictions and adapting financial models


Module 4 - Real Estate Data
Understanding the different sources of data, constructing basic time series models and recognising basic patterns.
Key Property market indicators
Characteristics and application of key input metrics for Real Estate Appraisals
Understanding the eight components of Real Estate Price Dynamics
Awareness of the different sources of data
Reading and using general property market reports
Constructing basic time series models and recognising basic patterns


Module 5 - Development Appraisals
Constructing a development appraisal from first principles and understanding development return metrics.
Understanding the key components of a development project
Understanding the difference between development and investment appraisals
Residual Appraisals and Profit Calculations
Cost orientated cash flows and phased sales
Cumulative construction cost patterns: incidental, fixed, loaded and S-curve
Development return metrics and Modified IRRs


Module 6 - Multi-let Cash Flows
Constructing an advanced multi-let cash flow model and learn different techniques to build flexible rent functions.
Multi-let and portfolio model design principles
Building complex date functions and date series
The three multi-let rent projection techniques
Perpendicular Rent Functions
Incorporate advanced rent adjustments into the Rent Function
Incorporate sector and period varying rental growth rates
Simplifying OPEX and CAPEX projections
Discounting techniques on complex and volatile cash flows


Module 7 - Project Finance
Constructing a flexible Real Estate Debt Finance model.
Revision of the Mathematics of amortisation and debt finance
Basic senior debt models and geared net cash flow
LTV, IRR and Interest Rate Dynamics
Flexible term, repayment options and deferred interest
Loan covenant tests
Understanding different tranches of debt
Understanding how complex debt structures impact the returns to different parties


Module 8 - Model Interpretation and Risk Analysis
Learn how to read, analyse and report on real estate financial models.
Understand how to read models and develop an investment narrative
Visualise model outputs using graph functions, conditional formatting, dynamic symbols and dashboards
Learn how to use built-in Sensitivity, Scenario Analysis tools and third-party add-ins
Learn how to construct varied project scenarios in a systematic way
Introduction to Monte Carlo Analysis and VBA
Optimising sale dates and other parameters
Create well written, attractive and persuasive reports


Included in the Course
Bayfield Training and University of Cambridge Accredited Certificate & LinkedIn Proficiency Badge
64 CPD Hours
1 Month Post-Course Access to the Digital Platform - 12 Months Post-Course Access to the Platform can be purchased for an additional fee
Course Files
Q&A Webinars and Guest Speaker Webinars
Further Learning Resources (Reading, Files and Videos)
Post Course Support - Two Months of Questions & Answers


2024 Cohort Dates Include:
3rd June to 29th July
5th August to 25th September 2024
30th September to 25th November


For more information, please contact Sam on the Bayfield Training Sales team:
E - s.musgrave@bayfieldtraining.com
T - 01223 517851
W - www.bayfieldtraining.com

6863 Courses

Microsoft Excel Course for Everyone - Complete Excel Course

By Apex Learning

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

By Apex Learning

New Functions in Microsoft Excel 2021

By Apex Learning

Microsoft Excel Level 3

By Apex Learning

Advanced Excel Course (Formula, VLOOKUP & Power Query)

By Apex Learning

Excel: Top 50 Microsoft Excel Formulas in 50 Minutes!

By Apex Learning

Microsoft Excel: Master Power Query in 120 Minutes!

By Apex Learning

Microsoft Excel - 25 Must-Know Formulas and Functions

By Apex Learning

MET Technician

By Apex Learning

Excel Pivot Tables, Pivot Charts, Slicers, and Timelines

By Apex Learning

Search By Location