Name: Microsoft Excel - Data Analysis Tools
Price: 99 GBP
Availability: InStock

London

<div style="color: rgb(57, 54, 79); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(57, 54, 79);"><div data-testid="summary" id="isPasted" fr-original-style="" style="box-sizing: border-box;"><div data-testid="summary" id="isPasted" fr-original-style="" style="box-sizing: border-box;"><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Python coding, interactive, instructor-led, hands-on, practical. From basics to working with professionals. Python Part Time. Python Coding.</strong></p></div><div data-testid="organizerBrief" fr-original-style="" style="box-sizing: border-box;"><div data-testid="creator-signal-main-section" fr-original-style="" style="box-sizing: border-box;"><section fr-original-style="" style="box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></section></div></div></div><hr fr-original-style="" style="border-color: var(--border-muted); border-style: solid; clear: both; break-after: page; user-select: none; box-sizing: border-box;"><p style="color: rgb(111, 114, 135); font-size: var(--font-size); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(111, 114, 135);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Python Beginners Evenings Course</strong></strong></p><h2 style="color: rgb(30, 10, 60); box-sizing: border-box;" fr-original-style=" color: rgb(30, 10, 60);">Course summary</h2><p style="color: rgb(111, 114, 135); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(111, 114, 135);">This Python Programming course has become essential to all professional who would like to do code using Python. Learn evenings, work while studying. Work and study Python Part Time.</p><p style="color: rgb(111, 114, 135); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(111, 114, 135);">It is a Python beginners course and teaches Python coding from scratch to intermediate.</p><p style="color: rgb(111, 114, 135); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(111, 114, 135);">Hands-on, practical. We code some real life examples in this course.</p><p style="color: rgb(111, 114, 135); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(111, 114, 135);"><em fr-original-style="" style="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;">Duration:</strong></strong></em><em fr-original-style="" style="box-sizing: border-box;"><em fr-original-style="" style="box-sizing: border-box;">&nbsp;3 Evenings, once per week for 3 weeks 6pm-8pm, of which the first date only shows on the booking.</em></em></p><p style="color: rgb(111, 114, 135); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(111, 114, 135);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Virtual Classroom:&nbsp;</strong></strong>You could attend in our classroom, or attend online via virtual classroom, by select the appropriate ticket.</p><p style="color: rgb(111, 114, 135); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(111, 114, 135);"><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 Should Attend?</strong></strong></p><p style="color: rgb(111, 114, 135); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(111, 114, 135);">This course is intended for beginner programmers who need to code in Python. Fast-paced, Quite intensive.</p><p style="color: rgb(111, 114, 135); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(111, 114, 135);"><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><p style="color: rgb(111, 114, 135); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(111, 114, 135);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Session&nbsp;</strong></strong><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">1: Basics</strong></strong></p><ul style="color: rgb(111, 114, 135); box-sizing: border-box;" fr-original-style=" color: rgb(111, 114, 135);"><li fr-original-style="" style="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;">Python Data Types, Variables,</strong></strong></li><li fr-original-style="" style="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;">Operators and Expressions:</strong></strong>&nbsp;Arithmetic operators; Relational operators; Assignment operator; Logical operators.</li><li fr-original-style="" style="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;">Decision Making:</strong></strong>&nbsp;If statement; If - else statement; If- elif - else statement; Nested if - else;</li><li fr-original-style="" style="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;">Using Loops:</strong></strong>&nbsp;The while, while-else; do-while and the for loop; Enhanced for loop; Jump statements: break, continue; Nesting loops.</li></ul><p style="color: rgb(111, 114, 135); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(111, 114, 135);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Session&nbsp;</strong></strong><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">2: Lists. Dictionaries, Json</strong></strong></p><ul style="color: rgb(111, 114, 135); box-sizing: border-box;" fr-original-style=" color: rgb(111, 114, 135);"><li fr-original-style="" style="box-sizing: border-box;">Python Data Structures: Lists. Data Structures: 2-d Lists, Tuples. Dictionary, Nested Disctionary.</li></ul><p style="color: rgb(111, 114, 135); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(111, 114, 135);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Session&nbsp;</strong></strong><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">3: Built-in functions:</strong></strong></p><ul style="color: rgb(111, 114, 135); box-sizing: border-box;" fr-original-style=" color: rgb(111, 114, 135);"><li fr-original-style="" style="box-sizing: border-box;">Python Date Functions. Random. Math Functions. String Functions. Python Regex.</li></ul><p style="color: rgb(111, 114, 135); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(111, 114, 135);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Session&nbsp;</strong></strong><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">4: Database:</strong></strong></p><ul style="color: rgb(111, 114, 135); box-sizing: border-box;" fr-original-style=" color: rgb(111, 114, 135);"><li fr-original-style="" style="box-sizing: border-box;">Connect to a database, create Database, create a table, insert, delete, update records, query a database and display results. Drop database, drop table.</li></ul><p style="color: rgb(111, 114, 135); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(111, 114, 135);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Session&nbsp;</strong></strong><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">5: Files</strong></strong></p><ul style="color: rgb(111, 114, 135); box-sizing: border-box;" fr-original-style=" color: rgb(111, 114, 135);"><li fr-original-style="" style="box-sizing: border-box;">Exception Handling in Python<strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">:&nbsp;</strong></strong>Fundamentals of exception handling; Exception types; Using try and except.</li><li fr-original-style="" style="box-sizing: border-box;">Files, streams: Create<strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">,&nbsp;</strong></strong>Open, Traverse and Read Files: Csv, txt and Json Files.</li><li fr-original-style="" style="box-sizing: border-box;">API: Connecting to API&rsquo;s</li></ul><p style="color: rgb(111, 114, 135); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(111, 114, 135);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Session&nbsp;</strong></strong><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">6</strong></strong>:&nbsp;<strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">M ethods, Classes and Objects</strong></strong></p><ul style="color: rgb(111, 114, 135); box-sizing: border-box;" fr-original-style=" color: rgb(111, 114, 135);"><li fr-original-style="" style="box-sizing: border-box;">Creating and using Function, Working with parameters, Calling functions.</li><li fr-original-style="" style="box-sizing: border-box;">Object-Oriented Programming (OOP) principles. Modules and Classes, Creating an Object; Using an Object; Adding Instance variables; Controlling accessibility; Naming conventions for class member.s</li></ul><p style="color: rgb(111, 114, 135); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(111, 114, 135);"><br fr-original-style="" style="box-sizing: border-box;"></p><div data-testid="image-content" fr-original-style="" style="box-sizing: border-box;"><img src="https://img.evbuc.com/https%3A%2F%2Fcdn.evbuc.com%2Fimages%2F447713699%2F44980801875%2F1%2Foriginal.20230216-130657?h=2000&w=720&auto=format%2Ccompress&q=75&sharp=10&s=c331eac85ab8cd495a7a46a3aa8c2b7b" alt="" data-airgap-id="86" 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><p style="color: rgb(111, 114, 135); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(111, 114, 135);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">FAQ</strong></p><p style="color: rgb(111, 114, 135); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(111, 114, 135);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Do I need Python on my Laptop?</strong></p><p style="color: rgb(111, 114, 135); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(111, 114, 135);">Ideally spoken yes, but if not possible, you could use our online platform.</p><p style="color: rgb(111, 114, 135); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(111, 114, 135);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Can I pay by BACS?</strong></p><p style="color: rgb(111, 114, 135); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(111, 114, 135);">Yes, simply email us, a Python course consultant will contact you. training@pcworkshopslondon.co.uk or pcworkshopslondon@gmail.com</p><p style="color: rgb(111, 114, 135); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(111, 114, 135);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Can I pay with PayPal?</strong></p><p style="color: rgb(111, 114, 135); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(111, 114, 135);">Yes, simply email us, a course consultant will contact you. training@pcworkshopslondon.co.uk or pcworkshopslondon@gmail.com</p><p style="color: rgb(111, 114, 135); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(111, 114, 135);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Do I get an invoice?</strong></p><p style="color: rgb(111, 114, 135); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(111, 114, 135);">Yes, on request.</p><p style="color: rgb(111, 114, 135); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(111, 114, 135);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Can I pay with a PO (Purchase Order Number)?</strong></p><p style="color: rgb(111, 114, 135); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(111, 114, 135);">Yes, simply email us, a Python course consultant will contact you. training@pcworkshopslondon.co.uk or pcworkshopslondon@gmail.com</p><p style="color: rgb(111, 114, 135); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(111, 114, 135);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Do I get a certificate?</strong></p><p style="color: rgb(111, 114, 135); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(111, 114, 135);">Yes, a PCWorkshops Certificate</p><p style="color: rgb(111, 114, 135); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(111, 114, 135);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Can I attend in classroom?</strong></p><p style="color: rgb(111, 114, 135); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(111, 114, 135);">Yes, on request, and it would incur an additional charge, depending on your location. We have offices in London, Manchester, Birmingham, Portmouth, Southend-on-Sea, Milton Keynes.</p><p style="color: rgb(111, 114, 135); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(111, 114, 135);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Can beginners follow this course?</strong></p><p style="color: rgb(111, 114, 135); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(111, 114, 135);">Yes, this is a Python beginner friendly course. We offer Python courses with max 4 people, so we make sure each delegates fully understand the material covered</p><p style="color: rgb(111, 114, 135); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(111, 114, 135);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Can I customise the course?</strong></p><p style="color: rgb(111, 114, 135); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(111, 114, 135);">Yes, all our Python courses are customisable. We can customise the dates, times, location. course outline.</p><p style="color: rgb(111, 114, 135); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(111, 114, 135);"></p></div><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></p><div style="color: rgb(30, 10, 60); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(30, 10, 60);"><hr fr-original-style="" style="border-color: var(--border-muted); border-style: solid; clear: both; break-after: page; user-select: none; box-sizing: border-box;"><h2 fr-original-style="" style="box-sizing: border-box;">Refund Policy</h2></div><div style="color: rgb(111, 114, 135); box-sizing: border-box;" fr-original-style=" color: rgb(111, 114, 135);">No Refunds</div>

Python coding, interactive, instructor-led, hands-on, practical. From basics to working with professionals. Python Part Time. Python Coding.



Python Beginners Evenings Course
Course summary
This Python Programming course has become essential to all professional who would like to do code using Python. Learn evenings, work while studying. Work and study Python Part Time.
It is a Python beginners course and teaches Python coding from scratch to intermediate.
Hands-on, practical. We code some real life examples in this course.
Duration: 4 Evenings, once per week for 34weeks 6pm-8pm, of which the first date only shows on the booking.
Virtual Classroom: You could attend in our classroom, or attend online via virtual classroom, by select the appropriate ticket.
Who Should Attend?
This course is intended for beginner programmers who need to code in Python. Fast-paced, Quite intensive.
Course Outline:
Session 1: Basics
Python Data Types, Variables,
Operators and Expressions: Arithmetic operators; Relational operators; Assignment operator; Logical operators.
Decision Making: If statement; If - else statement; If- elif - else statement; Nested if - else;
Using Loops: The while, while-else; do-while and the for loop; Enhanced for loop; Jump statements: break, continue; Nesting loops.
Session 2: Lists. Dictionaries, Json
Python Data Structures: Lists. Data Structures: 2-d Lists, Tuples. Dictionary, Nested Disctionary. API's. Exceptions and CSV Files
Session 3: Built-in functions:
Python Random. Math Functions. String Functions.
Database:
Connect to a database, query a database and display results. 
Session 4: Methods, Classes and Objects
Creating and using Function, Working with parameters, Calling functions.
Object-Oriented Programming (OOP) principles. Modules and Classes, Creating an Object; Using an Object; Adding Instance variables; Controlling accessibility; Naming conventions for class member.s



FAQ
Do I need Python on my Laptop?
Ideally spoken yes, but if not possible, you could use our online platform.
Can I pay by BACS?
Yes, simply email us, a Python course consultant will contact you. training@pcworkshopslondon.co.uk or pcworkshopslondon@gmail.com
Can I pay with PayPal?
Yes, simply email us, a course consultant will contact you. training@pcworkshopslondon.co.uk or pcworkshopslondon@gmail.com
Do I get an invoice?
Yes, on request.
Can I pay with a PO (Purchase Order Number)?
Yes, simply email us, a Python course consultant will contact you. training@pcworkshopslondon.co.uk or pcworkshopslondon@gmail.com
Do I get a certificate?
Yes, a PCWorkshops Certificate
Can I attend in classroom?
Yes, on request, and it would incur an additional charge, depending on your location. We have offices in London, Manchester, Birmingham, Portmouth, Southend-on-Sea, Milton Keynes.
Can beginners follow this course?
Yes, this is a Python beginner friendly course. We offer Python courses with max 4 people, so we make sure each delegates fully understand the material covered
Can I customise the course?
Yes, all our Python courses are customisable. We can customise the dates, times, location. course outline.






Refund Policy
No Refunds

PCWorkshops

Programming Languages

Python

Course summary



This Python Programming course has become essential to all professional who would like to do code using Python. Learn evenings, work while studying. Work and study Python Part Time.



It is a Python beginners course and teaches Python coding from scratch to intermediate.



Hands-on, practical. We code some real life examples in this course.



Python Programming Beginners Evenings Course, Virtual Classroom.

Keep 020 7164 6359 for your contact on the day. Thanks for booking!

Python Evenings in Classroom, London

<p style="color: rgba(18, 18, 18, 0.75); font-size: var(--font-size); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgba(18, 18, 18, 0.75);">In this class, you will gain exposure to and learn how to use <span data-mce-fragment="1" fr-original-style="" style="box-sizing: border-box;">some of Excel&rsquo;s power functions, including SUMPRODUCT, array formulas, MEDIAN, MODE, TRIMMEAN, RANK, LARGE and SMALL statistical functions, and PPMT, IPMT, PV, FV, PDURATION, NPER financial functions, and four methods of determining depreciation including SLN, DB, DDB, AND SYD.&nbsp;</span></p><p style="color: rgba(18, 18, 18, 0.75); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgba(18, 18, 18, 0.75);"><span data-mce-fragment="1" fr-original-style="" style="box-sizing: border-box;">This class is:</span></p><ul style="color: rgba(18, 18, 18, 0.75); box-sizing: border-box;" fr-original-style=" color: rgba(18, 18, 18, 0.75);"><li fr-original-style="" style="box-sizing: border-box;"><span data-mce-fragment="1" fr-original-style="" style="box-sizing: border-box;">Live, instructor-led, virtual class</span></li><li fr-original-style="" style="box-sizing: border-box;"><span data-mce-fragment="1" fr-original-style="" style="box-sizing: border-box;">90 minutes</span></li><li fr-original-style="" style="box-sizing: border-box;"><span data-mce-fragment="1" fr-original-style="" style="box-sizing: border-box;">Completion digital badge and certificate provided</span></li></ul>

AXIOM Learning Solutions

Financial Modelling & Analysis

Excel Analytics

Microsoft Excel

Statistical Computing

Spreadsheet

Microsoft Excel - Power Functions

General Admission

<p style="color: rgba(18, 18, 18, 0.75); font-size: var(--font-size); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgba(18, 18, 18, 0.75);">This class will teach you how to create compelling data visualizations using Microsoft Excel. You will learn to create several types of professional-looking charts in Excel, identify chart elements, set up the source data, select the data to include on a Chart, learn ways to create Charts, work with Chart Layouts and Quick Layouts, learn to modify, add, and format charts to enhance the presentation of your data, change the data source, save a Chart as a Chart Template, and print Charts.</p><ul style="color: rgba(18, 18, 18, 0.75); box-sizing: border-box;" fr-original-style=" color: rgba(18, 18, 18, 0.75);"><li fr-original-style="" style="box-sizing: border-box;">Live, instructor-led, virtual class</li><li fr-original-style="" style="box-sizing: border-box;">90 minutes</li><li fr-original-style="" style="box-sizing: border-box;">Completion digital badge and certificate provided</li></ul>

Microsoft Excel - Creating Charts

<p style="color: rgba(18, 18, 18, 0.75); font-size: var(--font-size); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgba(18, 18, 18, 0.75);"><span data-mce-fragment="1" fr-original-style="" style="box-sizing: border-box;">Learn the basics of using the Visual Basic for Applications (VBA) programming language to create macros in Excel. Learn the limitations of the macro recorder, work with the Excel Object model and the Visual Basic Editor. &nbsp;You will write some basic code, edit code, learn about basic logic and looping, step through code and work with a custom function.&nbsp;</span></p><ul style="color: rgba(18, 18, 18, 0.75); box-sizing: border-box;" fr-original-style=" color: rgba(18, 18, 18, 0.75);"><li fr-original-style="" style="box-sizing: border-box;">Live, instructor-led, virtual class</li><li fr-original-style="" style="box-sizing: border-box;">90 minutes</li><li fr-original-style="" style="box-sizing: border-box;">Completion digital badge and certificate provided</li></ul>

Microsoft Excel - Automating Tasks by Programming in VBA

<p style="color: rgba(18, 18, 18, 0.75); font-size: var(--font-size); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgba(18, 18, 18, 0.75);">Learn additional functions and formulas to become a more expert Excel user.</p><p style="color: rgba(18, 18, 18, 0.75); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgba(18, 18, 18, 0.75);">This class will give you hands-on instruction as you work with <span data-mce-fragment="1" fr-original-style="" style="box-sizing: border-box;">the IF, nested IF and IF/AND logical functions, the TRIM, PROPER, CONCATENATE, TEXT, LEFT, RIGHT, and MID text functions, VLOOKUP with an approximate and exact match, separating text into columns, and the SUMIF, SUMIFS, AVERAGEIF, AVERAGEIFS, COUNTIF and COUNTIFS conditional functions to process worksheet data more efficiently.&nbsp;</span></p><p style="color: rgba(18, 18, 18, 0.75); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgba(18, 18, 18, 0.75);"><span data-mce-fragment="1" fr-original-style="" style="box-sizing: border-box;">This class is:</span></p><ul style="color: rgba(18, 18, 18, 0.75); box-sizing: border-box;" fr-original-style=" color: rgba(18, 18, 18, 0.75);"><li fr-original-style="" style="box-sizing: border-box;"><span data-mce-fragment="1" fr-original-style="" style="box-sizing: border-box;">Live, instructor-led, virtual class</span></li><li fr-original-style="" style="box-sizing: border-box;"><span data-mce-fragment="1" fr-original-style="" style="box-sizing: border-box;">90 minutes</span></li><li fr-original-style="" style="box-sizing: border-box;"><span data-mce-fragment="1" fr-original-style="" style="box-sizing: border-box;">Completion digital badge and certificate provided</span></li></ul>

Microsoft Excel - More Functions and Formulas

<p style="color: rgba(18, 18, 18, 0.75); font-size: var(--font-size); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgba(18, 18, 18, 0.75);">In Microsoft Excel, related data can be organized using a range of cells. This class provides an overview of list and table design techniques. You will learn:</p><ul style="color: rgba(18, 18, 18, 0.75); box-sizing: border-box;" fr-original-style=" color: rgba(18, 18, 18, 0.75);"><li fr-original-style="" style="box-sizing: border-box;">Procedures to sort, filter and validate data</li><li fr-original-style="" style="box-sizing: border-box;">How to use formulas in lists and tables</li><li fr-original-style="" style="box-sizing: border-box;">How to identify and remove duplicate records</li><li fr-original-style="" style="box-sizing: border-box;">How to use the subtotal and outline features</li></ul><p style="color: rgba(18, 18, 18, 0.75); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgba(18, 18, 18, 0.75);">This class is:</p><ul style="color: rgba(18, 18, 18, 0.75); box-sizing: border-box;" fr-original-style=" color: rgba(18, 18, 18, 0.75);"><li fr-original-style="" style="box-sizing: border-box;">Live, instructor-led, virtual class</li><li fr-original-style="" style="box-sizing: border-box;">90 minutes</li><li fr-original-style="" style="box-sizing: border-box;">Completion digital badge and certificate provided</li></ul>

Microsoft Excel - Lists and Tables

<p style="color: rgba(18, 18, 18, 0.75); font-size: var(--font-size); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgba(18, 18, 18, 0.75);">In this introduction to Microsoft Excel, you will learn the terminology and capabilities of Excel. This class covers an introduction to the Excel application and interface. You will learn:</p><ul style="color: rgba(18, 18, 18, 0.75); box-sizing: border-box;" fr-original-style=" color: rgba(18, 18, 18, 0.75);"><li fr-original-style="" style="box-sizing: border-box;">How to create and work with Workbooks</li><li fr-original-style="" style="box-sizing: border-box;">How to navigate in a Worksheet</li><li fr-original-style="" style="box-sizing: border-box;">How to enter, delete and select data</li><li fr-original-style="" style="box-sizing: border-box;">How to undo/redo actions</li><li fr-original-style="" style="box-sizing: border-box;">How to control your view, including zoom in/out</li><li fr-original-style="" style="box-sizing: border-box;">How to create simple calculations</li><li fr-original-style="" style="box-sizing: border-box;">How to do basic sorting, moving and copying data</li><li fr-original-style="" style="box-sizing: border-box;">How to set print settings and explore print preview</li></ul><p style="color: rgba(18, 18, 18, 0.75); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgba(18, 18, 18, 0.75);">This class is:</p><ul style="color: rgba(18, 18, 18, 0.75); box-sizing: border-box;" fr-original-style=" color: rgba(18, 18, 18, 0.75);"><li fr-original-style="" style="box-sizing: border-box;">Live, instructor-led, virtual class</li><li fr-original-style="" style="box-sizing: border-box;">90 minutes</li><li fr-original-style="" style="box-sizing: border-box;">Completion digital badge and certificate provided</li></ul>

Microsoft Excel - Getting Started

<p style="color: rgba(18, 18, 18, 0.75); font-size: var(--font-size); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgba(18, 18, 18, 0.75);"><span data-mce-fragment="1" fr-original-style="" style="box-sizing: border-box;">Learn the fundamentals of creating and working with formulas and functions. In this class, you will learn:</span></p><ul style="color: rgba(18, 18, 18, 0.75); box-sizing: border-box;" fr-original-style=" color: rgba(18, 18, 18, 0.75);"><li fr-original-style="" style="box-sizing: border-box;"><span data-mce-fragment="1" fr-original-style="" style="box-sizing: border-box;">Building and copying simple formulas</span></li><li fr-original-style="" style="box-sizing: border-box;"><span data-mce-fragment="1" fr-original-style="" style="box-sizing: border-box;">Understand formulas operators and the order of operations</span></li><li fr-original-style="" style="box-sizing: border-box;"><span data-mce-fragment="1" fr-original-style="" style="box-sizing: border-box;">Learn to use functions such as SUM, AVERAGE, PMT, ROUND, TODAY, and NETWORKDAYS</span></li><li fr-original-style="" style="box-sizing: border-box;"><span data-mce-fragment="1" fr-original-style="" style="box-sizing: border-box;">Understand the difference between relative and absolute cell references</span></li><li fr-original-style="" style="box-sizing: border-box;"><span data-mce-fragment="1" fr-original-style="" style="box-sizing: border-box;">Create grand totals and work with formulas that contain 3-D references</span></li></ul><p style="color: rgba(18, 18, 18, 0.75); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgba(18, 18, 18, 0.75);"><span data-mce-fragment="1" fr-original-style="" style="box-sizing: border-box;">Class details:</span></p><ul style="color: rgba(18, 18, 18, 0.75); box-sizing: border-box;" fr-original-style=" color: rgba(18, 18, 18, 0.75);"><li fr-original-style="" style="box-sizing: border-box;">Live, instructor-led, virtual class</li><li fr-original-style="" style="box-sizing: border-box;">90 minutes</li><li fr-original-style="" style="box-sizing: border-box;">Completion digital badge and certificate provided</li></ul>

Microsoft Excel - Functions and Formulas

<p style="color: rgba(18, 18, 18, 0.75); font-size: var(--font-size); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgba(18, 18, 18, 0.75);"><span data-mce-fragment="1" fr-original-style="" style="box-sizing: border-box;">Learn the basic formatting techniques necessary to enhance the way data displays on a worksheet and in print. You will learn how to:</span></p><ul style="color: rgba(18, 18, 18, 0.75); box-sizing: border-box;" fr-original-style=" color: rgba(18, 18, 18, 0.75);"><li fr-original-style="" style="box-sizing: border-box;"><span data-mce-fragment="1" fr-original-style="" style="box-sizing: border-box;">Adjust column width and row height</span></li><li fr-original-style="" style="box-sizing: border-box;"><span data-mce-fragment="1" fr-original-style="" style="box-sizing: border-box;">Format text, change alignment of data, format numbers</span></li><li fr-original-style="" style="box-sizing: border-box;"><span data-mce-fragment="1" fr-original-style="" style="box-sizing: border-box;">Copy formatting to other cells</span></li><li fr-original-style="" style="box-sizing: border-box;"><span data-mce-fragment="1" fr-original-style="" style="box-sizing: border-box;">Create conditional formatting rules</span></li><li fr-original-style="" style="box-sizing: border-box;"><span data-mce-fragment="1" fr-original-style="" style="box-sizing: border-box;">Create and apply styles</span></li><li fr-original-style="" style="box-sizing: border-box;"><span data-mce-fragment="1" fr-original-style="" style="box-sizing: border-box;">Use Page Layout and Page Break Preview</span></li><li fr-original-style="" style="box-sizing: border-box;"><span data-mce-fragment="1" fr-original-style="" style="box-sizing: border-box;">Set up column and row headings to print on each page</span></li><li fr-original-style="" style="box-sizing: border-box;"><span data-mce-fragment="1" fr-original-style="" style="box-sizing: border-box;">Insert page breaks</span></li><li fr-original-style="" style="box-sizing: border-box;"><span data-mce-fragment="1" fr-original-style="" style="box-sizing: border-box;">Scale your data to fit on pages</span></li><li fr-original-style="" style="box-sizing: border-box;"><span data-mce-fragment="1" fr-original-style="" style="box-sizing: border-box;">Show/hide gridlines</span></li><li fr-original-style="" style="box-sizing: border-box;"><span data-mce-fragment="1" fr-original-style="" style="box-sizing: border-box;">Insert a header and footer&nbsp;</span></li></ul><p style="color: rgba(18, 18, 18, 0.75); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgba(18, 18, 18, 0.75);"><span data-mce-fragment="1" fr-original-style="" style="box-sizing: border-box;">This class is:</span></p><ul style="color: rgba(18, 18, 18, 0.75); box-sizing: border-box;" fr-original-style=" color: rgba(18, 18, 18, 0.75);"><li fr-original-style="" style="box-sizing: border-box;"><span data-mce-fragment="1" fr-original-style="" style="box-sizing: border-box;">Live, instructor-led, virtual class</span></li><li fr-original-style="" style="box-sizing: border-box;"><span data-mce-fragment="1" fr-original-style="" style="box-sizing: border-box;">90 minutes</span></li><li fr-original-style="" style="box-sizing: border-box;"><span data-mce-fragment="1" fr-original-style="" style="box-sizing: border-box;">Completion digital badge and certificate provided</span></li></ul>

Microsoft Excel - Formatting Spreadsheets

<p style="color: rgba(18, 18, 18, 0.75); font-size: var(--font-size); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgba(18, 18, 18, 0.75);"><span data-mce-fragment="1" fr-original-style="" style="box-sizing: border-box;">Learn to create Scenarios and use the Scenario Manager, use Goal Seek, and Solver tools to effectively analyze data in your worksheets. Also learn to create one and two variable data tables and consolidate data. Finally, learn to use Excel&rsquo;s one-click forecasting tool.</span></p><ul style="color: rgba(18, 18, 18, 0.75); box-sizing: border-box;" fr-original-style=" color: rgba(18, 18, 18, 0.75);"><li fr-original-style="" style="box-sizing: border-box;">Live, instructor-led, virtual class</li><li fr-original-style="" style="box-sizing: border-box;">90 minutes</li><li fr-original-style="" style="box-sizing: border-box;">Completion digital badge and certificate provided</li></ul>

Microsoft Excel - Data Analysis Tools

<span dir="ltr" id="isPasted" fr-original-style="" style="box-sizing: border-box;"><span dir="ltr" id="isPasted" fr-original-style="" style="box-sizing: border-box;"><span dir="ltr" id="isPasted" fr-original-style="" style="box-sizing: border-box;"><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">In January 2024 alone, reports were published about the SRA taking enforcement action against 3 firms and 4 individuals for failure to comply with the Money Laundering Regulations 2017. The fines issued for these non-compliances total over &pound;570,000 plus costs. The absence of staff training, or requirement to complete additional training, was noted in a number of these cases.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">As a manager of a law firm, or more crucially an MLRO or MLCO, the ultimate responsibility for the firm&#39;s compliance, including with the MLR 2017, lies with you. It is your responsibility to ensure that the firm puts in place, reviews and updates compliant policies, controls and procedures. You must ensure that the firm maintains an up to date practice wide risk assessment. You are required to ensure that your employees are regularly given training on the MLR 2017 and associated risks.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">If a breach occurs, the SRA will take a wider look at the firm and identify any supervisory deficiencies that may have contributed to failures by fee earners or support staff. It has proven that it will not shy away from holding to account managers, compliance officers and MLRO/MLCOs for failures by their firms to comply with requirements of the MLR 2017.</p></span></span><span dir="ltr" id="isPasted" fr-original-style="" style="box-sizing: border-box;"><span dir="ltr" id="isPasted" fr-original-style="" style="box-sizing: border-box;"><span dir="ltr" id="isPasted" fr-original-style="" style="box-sizing: border-box;"><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">T<span style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">his course will cover the following to assist firms MLROs, MLCOs and&nbsp;</span><span style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Management with fulfilling their AML management responsibilities:</span></p><ul fr-original-style="" style="box-sizing: border-box;"><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;"><div fr-original-style="" style="box-sizing: border-box;">How to comply with your obligations and stay compliant</div></li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;"><div fr-original-style="" style="box-sizing: border-box;">FWRA &ndash; linked with PCPs</div></li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;"><div fr-original-style="" style="box-sizing: border-box;">Mandatory AML Policies and Procedures - SRA have concerns</div></li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;"><div fr-original-style="" style="box-sizing: border-box;">Training and supervising staff</div></li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;"><div fr-original-style="" style="box-sizing: border-box;">Audits</div></li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;"><div fr-original-style="" style="box-sizing: border-box;">SRA requirements</div></li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;"><div fr-original-style="" style="box-sizing: border-box;">Reporting SARS</div></li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;"><div fr-original-style="" style="box-sizing: border-box;">POCA/TA</div></li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;"><div fr-original-style="" style="box-sizing: border-box;">Fulfilling reporting officer and compliance officer duties</div></li></ul></span></span></span><h2 fr-original-style="" style="box-sizing: border-box;"><span dir="ltr" fr-original-style="" style="box-sizing: border-box;">Target Audience</span></h2><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span dir="ltr" id="isPasted" fr-original-style="" style="box-sizing: border-box;">The online course is suitable for MLROs, MLCOs, firm management and those supporting these roles.</span></p><h2 data-key="21" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">Resources</h2><p data-key="28" style="color: rgb(0, 0, 0); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);"><span data-key="29" fr-original-style="" style="box-sizing: border-box;"><span data-offset-key="29:0" fr-original-style="" style="box-sizing: border-box;">Comprehensive and up to date course notes will be provided to all delegates which may be useful for ongoing reference or cascade training.</span></span></p><p data-key="30" data-slate-fragment="JTdCJTIyb2JqZWN0JTIyJTNBJTIyZG9jdW1lbnQlMjIlMkMlMjJkYXRhJTIyJTNBJTdCJTdEJTJDJTIybm9kZXMlMjIlM0ElNUIlN0IlMjJvYmplY3QlMjIlM0ElMjJibG9jayUyMiUyQyUyMnR5cGUlMjIlM0ElMjJoZWFkaW5nLXRocmVlJTIyJTJDJTIyZGF0YSUyMiUzQSU3QiUyMmNsYXNzTmFtZSUyMiUzQW51bGwlN0QlMkMlMjJub2RlcyUyMiUzQSU1QiU3QiUyMm9iamVjdCUyMiUzQSUyMnRleHQlMjIlMkMlMjJsZWF2ZXMlMjIlM0ElNUIlN0IlMjJvYmplY3QlMjIlM0ElMjJsZWFmJTIyJTJDJTIydGV4dCUyMiUzQSUyMkNvdXJzZSUyME5vdGVzJTIyJTJDJTIybWFya3MlMjIlM0ElNUIlNUQlN0QlNUQlN0QlNUQlN0QlMkMlN0IlMjJvYmplY3QlMjIlM0ElMjJibG9jayUyMiUyQyUyMnR5cGUlMjIlM0ElMjJwYXJhZ3JhcGglMjIlMkMlMjJkYXRhJTIyJTNBJTdCJTIyY2xhc3NOYW1lJTIyJTNBbnVsbCU3RCUyQyUyMm5vZGVzJTIyJTNBJTVCJTdCJTIyb2JqZWN0JTIyJTNBJTIydGV4dCUyMiUyQyUyMmxlYXZlcyUyMiUzQSU1QiU3QiUyMm9iamVjdCUyMiUzQSUyMmxlYWYlMjIlMkMlMjJ0ZXh0JTIyJTNBJTIyQ29tcHJlaGVuc2l2ZSUyMGFuZCUyMHVwJTIwdG8lMjBkYXRlJTIwY291cnNlJTIwbm90ZXMlMjB3aWxsJTIwYmUlMjBwcm92aWRlZCUyMHRvJTIwYWxsJTIwZGVsZWdhdGVzJTIwd2hpY2glMjBtYXklMjBiZSUyMHVzZWZ1bCUyMGZvciUyMG9uZ29pbmclMjByZWZlcmVuY2UlMjBvciUyMGNhc2NhZGUlMjB0cmFpbmluZy4lMjIlMkMlMjJtYXJrcyUyMiUzQSU1QiU1RCU3RCU1RCU3RCU1RCU3RCUyQyU3QiUyMm9iamVjdCUyMiUzQSUyMmJsb2NrJTIyJTJDJTIydHlwZSUyMiUzQSUyMnBhcmFncmFwaCUyMiUyQyUyMmRhdGElMjIlM0ElN0IlMjJjbGFzc05hbWUlMjIlM0FudWxsJTdEJTJDJTIybm9kZXMlMjIlM0ElNUIlN0IlMjJvYmplY3QlMjIlM0ElMjJ0ZXh0JTIyJTJDJTIybGVhdmVzJTIyJTNBJTVCJTdCJTIyb2JqZWN0JTIyJTNBJTIybGVhZiUyMiUyQyUyMnRleHQlMjIlM0ElMjJQbGVhc2UlMjBub3RlJTIwYSUyMHJlY29yZGluZyUyMG9mJTIwdGhlJTIwY291cnNlJTIwd2lsbCUyMCUyMiUyQyUyMm1hcmtzJTIyJTNBJTVCJTVEJTdEJTJDJTdCJTIyb2JqZWN0JTIyJTNBJTIybGVhZiUyMiUyQyUyMnRleHQlMjIlM0ElMjJub3QlMjAlMjIlMkMlMjJtYXJrcyUyMiUzQSU1QiU3QiUyMm9iamVjdCUyMiUzQSUyMm1hcmslMjIlMkMlMjJ0eXBlJTIyJTNBJTIyYm9sZCUyMiUyQyUyMmRhdGElMjIlM0ElN0IlN0QlN0QlNUQlN0QlMkMlN0IlMjJvYmplY3QlMjIlM0ElMjJsZWFmJTIyJTJDJTIydGV4dCUyMiUzQSUyMmJlJTIwbWFkZSUyMGF2YWlsYWJsZS4lMjIlMkMlMjJtYXJrcyUyMiUzQSU1QiU1RCU3RCU1RCU3RCU1RCU3RCU1RCU3RA==" style="color: rgb(0, 0, 0); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);"><span data-key="31" fr-original-style="" style="box-sizing: border-box;"><span data-offset-key="31:0" fr-original-style="" style="box-sizing: border-box;">Please note a recording of the course will&nbsp;</span><span data-offset-key="31:1" fr-original-style="" style="box-sizing: border-box;"><strong data-slate-leaf="true" fr-original-style="" style="font-weight: 700; box-sizing: border-box;">not&nbsp;</strong></span><span data-offset-key="31:2" fr-original-style="" style="box-sizing: border-box;">be made available.</span></span></p><h2 data-key="35" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);"><span data-key="36" fr-original-style="" style="box-sizing: border-box;"><span data-offset-key="36:0" fr-original-style="" style="box-sizing: border-box;">Speaker</span></span></h2><h3 style="color: rgb(0, 0, 0); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(0, 0, 0);"><a href="https://dglegal.co.uk/the-team/helen-torresi/" target="_blank" rel="noopener noreferrer" fr-original-style="" style="user-select: auto; font-size: var(--font-size); box-sizing: border-box; cursor: pointer; text-decoration: inherit;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"><span style="color: rgb(0, 180, 205); box-sizing: border-box;" fr-original-style="color: rgb(0, 180, 205);">Helen Torresi, Consultant, DG Legal</span></strong></a></h3><p style="color: rgb(89, 89, 91); font-size: var(--font-size); box-sizing: border-box;" fr-original-style="color: rgb(89, 89, 91);"><span style="color: rgb(89, 89, 91); box-sizing: border-box;" fr-original-style="color: rgb(89, 89, 91);">Helen is a qualified solicitor with a diverse professional background spanning leadership roles in both the legal and tech/corporate sectors. Throughout her career, she has held key positions such as COLP, HOLP, MLCO, MLRO and DPO for law firms and various regulated businesses and services.</span></p><p style="color: rgb(89, 89, 91); font-size: var(--font-size); box-sizing: border-box;" fr-original-style="color: rgb(89, 89, 91);"><span style="color: rgb(89, 89, 91); box-sizing: border-box;" fr-original-style="color: rgb(89, 89, 91);">Helen&rsquo;s specialised areas encompass AML, complaint and firm negligence handling, DPA compliance, file review and auditing, law management, and operational effectiveness in law firms, particularly in conveyancing (CQS).</span></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></span>

In January 2024 alone, reports were published about the SRA taking enforcement action against 3 firms and 4 individuals for failure to comply with the Money Laundering Regulations 2017. The fines issued for these non-compliances total over £570,000 plus costs. The absence of staff training, or requirement to complete additional training, was noted in a number of these cases.
As a manager of a law firm, or more crucially an MLRO or MLCO, the ultimate responsibility for the firm's compliance, including with the MLR 2017, lies with you. It is your responsibility to ensure that the firm puts in place, reviews and updates compliant policies, controls and procedures. You must ensure that the firm maintains an up to date practice wide risk assessment. You are required to ensure that your employees are regularly given training on the MLR 2017 and associated risks.
If a breach occurs, the SRA will take a wider look at the firm and identify any supervisory deficiencies that may have contributed to failures by fee earners or support staff. It has proven that it will not shy away from holding to account managers, compliance officers and MLRO/MLCOs for failures by their firms to comply with requirements of the MLR 2017.
This course will cover the following to assist firms MLROs, MLCOs and Management with fulfilling their AML management responsibilities:
How to comply with your obligations and stay compliant
FWRA – linked with PCPs
Mandatory AML Policies and Procedures - SRA have concerns
Training and supervising staff
Audits
SRA requirements
Reporting SARS
POCA/TA
Fulfilling reporting officer and compliance officer duties
Target Audience
The online course is suitable for MLROs, MLCOs, firm management and those supporting these roles.
Resources
Comprehensive and up to date course notes will be provided to all delegates which may be useful for ongoing reference or cascade training.
Please note a recording of the course will not be made available.
Speaker
Helen Torresi, Consultant, DG Legal
Helen is a qualified solicitor with a diverse professional background spanning leadership roles in both the legal and tech/corporate sectors. Throughout her career, she has held key positions such as COLP, HOLP, MLCO, MLRO and DPO for law firms and various regulated businesses and services.
Helen’s specialised areas encompass AML, complaint and firm negligence handling, DPA compliance, file review and auditing, law management, and operational effectiveness in law firms, particularly in conveyancing (CQS).



DG Legal

Anti-Money Laundering (AML)

Anti-Money Laundering (AML) Training For MLROs, MLCOs And Law Firm Management Course

General Delegate

A discount is available for delegates attending from firms with a current retainer contract with DG Legal (please contact us by email to admin@dglegal.co.uk for confirmation of eligibility).   If you choose this option and are not eligible, you are still bound to pay the full rate and will be invoiced accordingly.

Retainer Delegate

<div>
	                  <h5>Excel Macros and VBA Course summary</h5>
	               </div>
	               <div></div>
	               <p> 
				   
				  For Excel users. Extend the capabilities of Excel with Macros and VBA code.
	              

				  </p>
				   
				   
	               <div>
	                  <div>
	                     <h5>Excel Macros and VBA Course Description</h5>
	                  </div>
	                  <div></div>
	                  <p> 
	                  
					  
					  
					  </p>
	                

	                		<br /><b>Create simple macros</b> using the macro recorder and run them from shortcuts or buttons on the ribbon

						<br />Setting Excel Macro Options
						<br />Record and Run Simple Macros
						<br />Assign Macros to the Quick Access Toolbar

					<br /><b>Introduction to the Excel VBA Editor</b>

					<br />Use the VBA Editor to navigate projects and explore object properties. Create, copy and import/export modules

						<br />Starting the Visual Basic Editor
						<br />Using the Project Explorer
						<br />Using the Properties Window
 

					<br /><b>Creating Procedures and Functions</b>

					<br /><b>Create simple macro procedures</b> in code that use variable to store data and communicate with the user

						<br />Creating Sub and Function Procedures
						<br />Declare and Use Variables
						<br />Displaying Message to the User
						<br />Getting Input from the User

					<br /><b>Controlling Program Flow</b>

					<br /><b>Using decision making and looping structures to control the way your program works</b>

						<br />Using the IF Statement
						<br />Using the Select Case Statement
						<br />Using For Next Loops
						<br />Using Do Loops
						<br />Using For Next Loops
			 

					<br /><b>Interacting with the spreadsheet :</b>

						<br />Referencing Cells and Ranges
						<br />Gathering Cell and Range Information
						<br />Using the Offset Method
						<br />Using With Blocks
						<br />Referencing Workbooks and Worksheets
						<br />Updating values in the spreadsheet 

					<br /><b>Functions</b>

						<br />Using standard Excel functions in VBA
						<br />Creating new custom functions
						<br />Calling functions and sub procedures

					<br /><b>User Forms</b>

						<br />Basic design and display
						<br />Getting information via forms and update cells
					

					<br /><b>Practical project and examples</b>
					<br /><br /> 
					
			 
			<h4>Other Excel Courses</h4>
			<br /><br />
 
 
 
 
	               </div>
	               <div id="cincluded">
	                  <div>
	                     <h5>What is included in the Excel VBA Courses:</h5>
	                  </div>
	                  <div>
	                     <ul>
	                        <li>Excel VBA Course Certificate on completion  </li>
	                        <li>Excel VBA Course notes</li>
	                        <li>Practical Excel VBA Course exercises, Excel VBA Course Homework / Excel VBA Course Revision work</li>
	                         
	                        <li>After the course, 1 free session for questions online Excel VBA Course via Gotomeeting.com.</li>
	                        <li>Max group size, online and in classroom, on this Excel VBA Course is 4. </li>
	                     </ul>
	                  </div>
	               </div>

Excel Macros and VBA Course summary
 For Excel users. Extend the capabilities of Excel with Macros and VBA code. 
Excel Macros and VBA Course Description
Create a simple mile/km converter with a frontend, user-input for, click button to start and update a spreadsjeet 
What is included in the Excel VBA Courses:
Excel VBA Course Certificate on completion
Excel VBA Course notes
Practical Excel VBA Course exercises, Excel VBA Course Homework / Excel VBA Course Revision work
After the course, 1 free session for questions online Excel VBA Course via Gotomeeting.com.
Max group size, online and in classroom, on this Excel VBA Course is 4.

Visual Basic

Access VBA

For Excel users. Extend the capabilities of Excel with Macros and VBA code. 

Excel Macros and VBA Course, 1-Hour Taster

General admission

Bournemouth

Our Virtual (via Zoom) course provide the same high-quality tuition as our classroom-based sessions. Quarterly meetings will take place at the Academy



Dental Nursing Diploma with National Examining Board for Dental Nurses (NEBDN) is an internationally recognised qualification that will allow you to work as a Dental Nurse in hospitals, NHS and private dental practices.

Successful completion of Dental Nursing Diploma course will enable you to register as a Dental Care Professional with the General Dental Council (GDC) and practice as a qualified Dental Nurse.


Discover the exciting world of dental nursing and be a part of a growing field that offers endless opportunities for growth and development.
How will you learn?
In addition to our traditional class-based tuition, we also offer Virtual (via Zoom) Learning courses to cater to different learning preferences. Our Virtual Learning courses provide the same high-quality tuition as our classroom-based sessions. To participate, you will need a laptop, PC, smart phone or tablet with a built-in or external camera and microphone. From the comfort of your own home, you will have the opportunity to communicate with your tutor and classmates through video chat, using your phone or computer camera. This allows for seamless interaction, discussions, and collaborative learning.

Quarterly meetings at the Academy
To ensure a well-rounded learning experience, you will be required to attend face-to-face lessons at the Academy on a quarterly basis, which means every three months. These sessions serve several important purposes:

Practical Units: Some aspects of the course require hands-on practical training. The face-to-face lessons will cover these practical units, allowing you to gain valuable experience and apply the knowledge you have acquired during the virtual learning sessions.

Tests and Mock Exams: These assessments are important for evaluating your progress, identifying areas for improvement, and preparing you for the final exams. The Academy will provide a controlled and supervised environment to ensure the integrity and fairness of these assessments.
Attending quarterly face-to-face lessons provides a balanced approach to your learning journey. It combines the convenience and flexibility of virtual learning with the benefits of in-person interactions, practical training, and assessments. By participating in these sessions, you will have the opportunity to reinforce your knowledge, receive personalized feedback, and build a stronger connection with your tutor and classmates.
The Academy is dedicated to supporting your growth and success in dental nursing field, and the face-to-face lessons are an integral part of that commitment.



Being a Dental Nurse can be an exciting and fulfilling career that allows you to make a positive impact on people’s lives while enjoying a variety of work and opportunities to learn and grow. You’ll get to work with an amazing dental team and get to know patients, helping them to feel at ease and comfortable during their visit. You’ll be the one behind the scene making sure everything runs smoothly, and you’ll be the one that patients will turn to for assistance. You’ll also get to be a part of the latest advancements in dental technology and treatment. And on top of all that, you get to have a flexible schedule and a good earning potential, with the potential to advance in your career. All in all, being a dental nurse is one of the most exciting and fulfilling career that you can have, and you’ll get to leave work every day knowing you’ve made a real difference in the lives of others.


The course is delivered by Team of Dental Professionals who are examiners, dentists and experienced Dental tutors with years of experience in teaching Dentistry.
Dental Nurses are involved in a wide range of procedures, from routine check-ups to complex surgeries, which can make the job interesting and varied.

Patient-centered care: Dental Nurses have a direct impact on the patient’s experience and can make a positive difference in people’s lives by providing them with quality care.

Professional development: Dental Nurses have the opportunity to continue their education and expand their skills, leading to advancement and new opportunities in the field.
No previous experience required – we will teach you from A to Z.
Do you need a job?
Yes, you will have 3 months’ time from the start of your course to find a placement.
The Academy provides a list of Private and NHS Dental Surgeries, who are regularly contacting us when looking for more Trainee Dental Nurses, so you can contact them directly as a registered student at the Academy. This is a paid job, unless you would like to work voluntary for personal reasons. We also provide a reference letter to the employee in case you need it.
The course is ideal for you if:
You are looking for a qualification that leads to employment
You intend to participate within dentistry and make a positive contribution to the dental health
You wish to learn how to maintain high standards of hygiene, cleanliness, health & safety
You enjoy interacting with multidisciplinary team and different people


The curriculum is based on the GDC (General Dental Council) registration requirements for dental nurses. It sets out the knowledge, skills and behavioural requirements that should be developed and demonstrated. These are set out in terms of professional competencies, with the assessment method clearly outlined (e.g. how the skills and knowledge will be assessed in the final examinations – via written questions such as multiple choice (MCQ) or extended matching questions (EMQ) or via Objective Structured Clinical Examinations – OSCEs). We are proud to announce that our Dental Nursing students has the highest examination pass rate in OSCE examinations!
Free services– workshops, mock exams, eRoE marking and internal moderation.


Earn while you learn could be another benefit for doing this course. We provide a list of Private Surgeries who have been working with us for the last 14 years and looking to recruit more Trainee Dental Nurses.
Working together – At our Dental Department, we prioritise working together with our learners every step of the way. We firmly believe in providing unwavering support, equipping you with the necessary tools, skills, and assistance to ensure your success. We take immense pride in the achievements of our students, with a long list of graduates boasting remarkable success stories. Our commitment to your success serves as the foundation for our own accomplishments
What Can You Expect to Earn as a Dental Nurse? Compared to other caring professions, Dental Nursing is well paid and offers plenty of opportunity for continued training and development. This is great for those looking on a the long-term plan for their career and those who wish to work their way up the ladder through continued learning, experience & hard work. Trainee Dental Nurse salary for standard working week will be around £23,000 per annum. Average wage for a qualified Dental Nurses between £40,417 to £42,350 p.a.
When are the exams?
There are two exams:
1. Multiple choice theory exam. November and March.
2. Practical exam. January and June. 
Record of Experience (eROE)
To be eligible to sit your first exam, you have to complete your electronic Record of Experience (eROE). The eROE has to be submitted to your tutor by 31st Jan for March exam, and 31st August for November exam. 
London Waterloo Academy supports Mouth Cancer Research Foundation and encouraging learners to raise the awareness and participate in annual 10k walk.



Study mode – virtual (via Zoom) live stream lessons combined with a quarterly meetings Saturday/Sunday at the Academy
Duration – 1 year (part time)
Virtual (via Zoom) classes – once a week
Quarterly meetings at the Academy – date are discussed with the group in advance
Next Intake/start dates (please choose one for your course to start):
21 September 2024, Saturday classes from 9am to 11am
Registration fee – £300 (includes: administration, workshops, mock exams, RoE marking, internal moderation of RoE)
Tuition Fees – £1,400 (we offer payment plan, and accept instalments)
Exam fee – £510 will be charged at the point of candidate registration with NEBDN
One day introduction course – for those who are considering/not sure whether to step up into the Dental Industry £50.00
Call us +44 (0) 7484 014980 or email to info@waterlooacademy.co.uk or Facebook – London Waterloo Academy
Office location: The Foundry, 156 Blackfriars Rd, London SE1 8EN (Southwark Station (2-3 min walk) and Waterloo/Blackfriars Station (10 min walk))

London Waterloo Academy

Dental Nurse

Dental Assistant

VIRTUAL DENTAL NURSING DIPLOMA

Registration Fee

Tuition Fee

Exam Fee

One Day Introduction Course

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



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


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


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


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


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


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


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

Bayfield Training

Financial Modelling

Professional Development

Property & Real Estate Photography

Continuous Professional Development (CPD)

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

Real Estate Analyst (Investment Cash Flow Modelling in Excel)

In-Person 

Virtual

This course meets and exceeds the Maryland requirement for the security officer course of 12 hours. The course is taught over 2 days, 6 hours per day. In this course, you will learn the required curriculum for security officers prescribed by the Maryland Police and Corrections Training Commission. 

MDSPOSA & USTASC TRAINING PORTAL

Maryland Security Officer Initial & Renewal Course

<p id="isPasted" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">This accredited seminar provides an introduction for employers, HR managers and supervisors to learn how domestic abuse can impact in the workplace.</p><div style="color: rgb(119, 119, 119); box-sizing: border-box;" fr-original-style=" color: rgb(119, 119, 119);"><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Did you know&hellip;. Domestic Abuse costs UK businesses &pound;14 billion per year. (Home Office &ndash; July 2021)</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">This training seminar provides an opportunity for employers, HR managers, supervisors, and team leaders to learn how domestic abuse can impact in the business as well as the next steps to support your staff and protect your business.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">By attending this event you will gain an</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">&bull; Increased understanding of domestic abuse</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">&bull; Increased understanding of the legal and safety implications for employers</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">&bull; Next steps on how your workplace can become accredited as a &lsquo;Safe Space to Work&rsquo;</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">This on-line training workshop will introduce the social, health and legal context, employers&rsquo; responsibilities and awareness of the economic impact of domestic abuse. By the end of the session attendees will feel confident in taking the next steps to ensure their workplace is a Safe Space.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">This training workshop will provide the first step towards understanding a many layered and complex subject.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">CPD credits are awarded with this workshop.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Attendees will receive handouts and a certificate (if required).</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">This event is hosted by Julie Johns MBE. </p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">The workshop will be delivered as a 1 hour live Zoom event and is being offered at &pound;30 per person. </p></div>

Creating a Safe Workplace: Understanding the Impact of Domestic Abuse

Workshop Host: Julie Johns MBE
 Format: Live Zoom session
 Duration: 1 hour
 Cost: £35 per person

An Accredited CPD-Certified Training Seminar for Employers, HR Managers, and Team Leaders
Did you know domestic abuse costs UK businesses an estimated £14 billion per year?
 (Source: Home Office, July 2021)

This accredited online seminar is designed to equip employers, HR professionals, supervisors, and team leaders with essential knowledge about how domestic abuse can affect the workplace.
What You’ll Gain
By attending this 1-hour live Zoom workshop, you will:
Develop a deeper understanding of domestic abuse and its many forms 
Learn about the legal, social, and safety responsibilities for employers 
Discover the economic impact domestic abuse can have on your organisation 
Identify practical next steps to make your workplace a certified ‘Safe Space to Work’
Why Attend?
This engaging, introductory session explores the health, legal, and business implications of domestic abuse, providing a solid foundation for those new to the topic. By the end of the seminar, attendees will feel empowered and informed to begin creating a safer, more supportive workplace culture.
Additional Benefits
Accredited CPD credits awarded 
Attendee handouts provided 
Certificate of attendance available on request 

Group bookings available.  Please contact julie@safespaceconsultancy.org with your request and to discuss fee.

Safe Space Consultancy

Safeguarding

Domestic Abuse

Workplace Health & Safety

Mental Health At Work

Health & Safety At Work

Domestic Violence

This 1 hour on-line training seminar provides an opportunity for employers, HR managers, supervisors, and team leaders to learn how domestic abuse can impact on an employee and the business as well as the next steps to support your staff and protect your business.

Creating a Safe Workplace: Understanding the Impact of Domestic Abuse

Early Bird

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



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


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


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


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


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


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

Real Estate Finance

Investment Management

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

Real Estate Modelling Masterclass (Advanced Cash Flow Modelling)

<div id="course-pills-1">Duration<p>5 Days</p><p>30 CPD hours</p>This course is intended for<p>This course is intended for IT professionals who are responsible for planning, configuring, and managing an Office 365 environment. Students who attend this course are expected to have a fairly broad understanding of several on-premises technologies such as Domain Name System (DNS) and Active Directory Domain Services (AD DS). In addition, they should have a general understanding of Microsoft Exchange Server, Microsoft Teams, and Microsoft SharePoint.</p>Overview<p>Plan and provision Office 365 Manage Users and Groups in Office 365 Deploy and Configure Tools and Applications for Office 365 Plan and Manage Exchange Online Plan and Manage SharePoint Online Plan and Manage Microsoft Teams Plan and Manage other Office 365 Services Implement Security and Compliance in Office 365 Report, Monitor and Troubleshoot Office 365</p><p>This five-day course describes how to set up, configure and manage an Office 365 tenant including identities, and the core services of Microsoft 365. In this five-day course, you will learn how to plan the configuration of an Office 365 tenant including integration with existing user identities; plan, configure and manage core services; and report on key metrics. <br /><br /> Although this course and the associated labs are written for Office 365 with Windows 11, the skills taught will also be backwards compatible with Windows 10. This course is based on the features available in the Office 365 E3 license as these are the core features in Office 365 and Microsoft 365 plans.</p></div><div id="course-pills-2"><h3>1 - Planning and Provisioning Office 365</h3> <ul> <li>Overview of Office 365</li> <li>Core Services of Office 365</li> <li>Requirements for an Office 365 Tenant</li> <li>Planning a Pilot and Deployment</li> <li>Creating an Office 365 Tenant</li> <li>Adding Custom Domains and Managing DNS Settings</li> <li>Lab: Provisioning Office 365</li> </ul> <h3>2 - Managing Users and Groups in Office 365</h3> <ul> <li>Managing User Accounts and Licences</li> <li>Managing Passwords and Authentication</li> <li>Create and Managing the Different Types of Groups in Office 365</li> <li>Managing Users and Groups with PowerShell</li> <li>Managing Users and Groups in the Azure AD Admin Center</li> <li>Role Based Access and Administrative Roles</li> <li>Planning and Configuring Directory Synchronization</li> <li>Lab: Managing Users and Groups in Office 365</li> <li>Lab: Planning and Configuring Directory Synchronisation</li> </ul> <h3>3 - Deploying and Configuring Tools and Applications for Office 365</h3> <ul> <li>Planning Network Configuration for Office 365 Tools and Applications</li> <li>Using the Office Configuration Tool</li> <li>Click to Run Installation Use and Control</li> <li>Managing Centralized Deployment of Tools, Applications and Add-ins</li> <li>Reporting</li> <li>Lab: Deploying and Configuring Tools and Applications for Office 365</li> </ul> <h3>4 - Planning and Managing Exchange Online</h3> <ul> <li>What is Exchange Online</li> <li>Managing Exchange Online Mailboxes</li> <li>Managing Office 365 Groups in Exchange Online</li> <li>Configuring Exchange Online Permissions</li> <li>Managing Exchange Online using PowerShell</li> <li>Plan and Configure Mail Flow</li> <li>Plan and Configure Email Protection</li> <li>Lab: Planning and Managing Exchange Online</li> </ul> <h3>5 - Planning and Managing SharePoint Online</h3> <ul> <li>What is SharePoint Online</li> <li>Understanding the relationship between SharePoint, OneDrive, Teams, and Office 365 Groups</li> <li>SharePoint Online Architecture</li> <li>Configure SharePoint Online</li> <li>Configure and Control External Sharing</li> <li>Managing SharePoint Online Site Collections</li> <li>Managing SharePoint Online using PowerShell</li> <li>Lab: Planning and Managing SharePoint Online</li> </ul> <h3>6 - Planning and Managing Microsoft Teams</h3> <ul> <li>What is Microsoft Teams</li> <li>How Microsoft Teams integrates with other Office 365 Services</li> <li>Create and Manage Organization Wide Settings</li> <li>Create, Manage and Assign Microsoft Teams Policies</li> <li>Plan and Configure External and Guest Access</li> <li>Managing Microsoft Teams using PowerShell</li> <li>Lab: Planning and Managing Microsoft Teams</li> </ul> <h3>7 - Planning and Managing Other Office 365 Services</h3> <ul> <li>Yammer</li> <li>Planner</li> <li>Visio</li> <li>Bookings</li> <li>Delve</li> <li>Forms</li> <li>Power Platform</li> <li>Stream</li> <li>Sway</li> <li>Viva</li> <li>Scheduler</li> <li>Add-ins, including Find Time and Junk Reporter</li> <li>Lab: Planning and Managing Office 365 Services</li> </ul> <h3>8 - Security and Compliance in Office 365</h3> <ul> <li>Overview of Security and Compliance Features in Office 365</li> <li>Extending Security and compliance Features with Additional Licences</li> <li>Using the Microsoft Defender Portal and Secure Score</li> <li>Using the Office 365 Compliance Portal and Compliance Score</li> <li>Plan and Configure Retention Labels and Policies</li> <li>Plan and Configure Data Loss Prevention Policies</li> <li>Create and Assign Sensitivity Labels</li> <li>Configure Safe Attachments and Safe Links Policies</li> <li>Plan and Configure Multi Factor Authentication</li> <li>Lab: Configure Security and Compliance in Office 365</li> </ul> <h3>9 - Reporting, Monitoring and Troubleshooting Office 365</h3> <ul> <li>Monitoring Office 365 Service Health</li> <li>Troubleshooting Administrative Access in Office 365</li> <li>Troubleshoot Directory Synchronization</li> <li>Troubleshooting Exchange Online</li> <li>Troubleshooting SharePoint Online</li> <li>Troubleshooting Microsoft Teams</li> <li>Troubleshooting Office 365 Security and Compliance</li> <li>Lab: Reporting, Monitoring and Troubleshooting in Office 365</li> </ul></div>

Duration
5 Days
30 CPD hours
This course is intended for
This course is intended for IT professionals who are responsible for planning, configuring, and managing an Office 365 environment. Students who attend this course are expected to have a fairly broad understanding of several on-premises technologies such as Domain Name System (DNS) and Active Directory Domain Services (AD DS). In addition, they should have a general understanding of Microsoft Exchange Server, Microsoft Teams, and Microsoft SharePoint.
Overview
Plan and provision Office 365 Manage Users and Groups in Office 365 Deploy and Configure Tools and Applications for Office 365 Plan and Manage Exchange Online Plan and Manage SharePoint Online Plan and Manage Microsoft Teams Plan and Manage other Office 365 Services Implement Security and Compliance in Office 365 Report, Monitor and Troubleshoot Office 365
This five-day course describes how to set up, configure and manage an Office 365 tenant including identities, and the core services of Microsoft 365. In this five-day course, you will learn how to plan the configuration of an Office 365 tenant including integration with existing user identities; plan, configure and manage core services; and report on key metrics. 

 Although this course and the associated labs are written for Office 365 with Windows 11, the skills taught will also be backwards compatible with Windows 10. This course is based on the features available in the Office 365 E3 license as these are the core features in Office 365 and Microsoft 365 plans.
1 - Planning and Provisioning Office 365
Overview of Office 365
Core Services of Office 365
Requirements for an Office 365 Tenant
Planning a Pilot and Deployment
Creating an Office 365 Tenant
Adding Custom Domains and Managing DNS Settings
Lab: Provisioning Office 365
2 - Managing Users and Groups in Office 365
Managing User Accounts and Licences
Managing Passwords and Authentication
Create and Managing the Different Types of Groups in Office 365
Managing Users and Groups with PowerShell
Managing Users and Groups in the Azure AD Admin Center
Role Based Access and Administrative Roles
Planning and Configuring Directory Synchronization
Lab: Managing Users and Groups in Office 365
Lab: Planning and Configuring Directory Synchronisation
3 - Deploying and Configuring Tools and Applications for Office 365
Planning Network Configuration for Office 365 Tools and Applications
Using the Office Configuration Tool
Click to Run Installation Use and Control
Managing Centralized Deployment of Tools, Applications and Add-ins
Reporting
Lab: Deploying and Configuring Tools and Applications for Office 365
4 - Planning and Managing Exchange Online
What is Exchange Online
Managing Exchange Online Mailboxes
Managing Office 365 Groups in Exchange Online
Configuring Exchange Online Permissions
Managing Exchange Online using PowerShell
Plan and Configure Mail Flow
Plan and Configure Email Protection
Lab: Planning and Managing Exchange Online
5 - Planning and Managing SharePoint Online
What is SharePoint Online
Understanding the relationship between SharePoint, OneDrive, Teams, and Office 365 Groups
SharePoint Online Architecture
Configure SharePoint Online
Configure and Control External Sharing
Managing SharePoint Online Site Collections
Managing SharePoint Online using PowerShell
Lab: Planning and Managing SharePoint Online
6 - Planning and Managing Microsoft Teams
What is Microsoft Teams
How Microsoft Teams integrates with other Office 365 Services
Create and Manage Organization Wide Settings
Create, Manage and Assign Microsoft Teams Policies
Plan and Configure External and Guest Access
Managing Microsoft Teams using PowerShell
Lab: Planning and Managing Microsoft Teams
7 - Planning and Managing Other Office 365 Services
Yammer
Planner
Visio
Bookings
Delve
Forms
Power Platform
Stream
Sway
Viva
Scheduler
Add-ins, including Find Time and Junk Reporter
Lab: Planning and Managing Office 365 Services
8 - Security and Compliance in Office 365
Overview of Security and Compliance Features in Office 365
Extending Security and compliance Features with Additional Licences
Using the Microsoft Defender Portal and Secure Score
Using the Office 365 Compliance Portal and Compliance Score
Plan and Configure Retention Labels and Policies
Plan and Configure Data Loss Prevention Policies
Create and Assign Sensitivity Labels
Configure Safe Attachments and Safe Links Policies
Plan and Configure Multi Factor Authentication
Lab: Configure Security and Compliance in Office 365
9 - Reporting, Monitoring and Troubleshooting Office 365
Monitoring Office 365 Service Health
Troubleshooting Administrative Access in Office 365
Troubleshoot Directory Synchronization
Troubleshooting Exchange Online
Troubleshooting SharePoint Online
Troubleshooting Microsoft Teams
Troubleshooting Office 365 Security and Compliance
Lab: Reporting, Monitoring and Troubleshooting in Office 365

Nexus Human

Microsoft Certification

Microsoft 365

Microsoft AZ-900

Microsoft AZ-104

Microsoft AZ-303

Microsoft AZ-700

55354 Administering Office 365

<p>Do you want to prepare for your dream job but strive hard to find the right courses? Then, stop worrying, for our strategically modified<strong> Office Skills and Office Management </strong>bundle will keep you up to date with the relevant knowledge and most recent matters of this emerging field. So, invest your money and effort in our <strong>33</strong> course mega bundle that will exceed your expectations within your budget.</p> <p>The<strong> Office Skills and Office Management </strong>related fields are thriving across the UK, and recruiters are hiring the most knowledgeable and proficient candidates. It's a demanding field with magnitudes of lucrative choices. If you need more guidance to specialise in this area and need help knowing where to start, then <strong> StudyHub </strong>proposes a preparatory bundle. This comprehensive <strong>Office Skills and Office Management </strong>bundle will help you build a solid foundation to become a proficient worker in the sector.</p> <p><strong>This Office Skills and Office Management Bundle consists of the following</strong><strong> 30 </strong><strong>CPD Accredited Premium courses - </strong></p> <ul> <li>Course 01:Admin, Secretarial &amp; PA</li><li>Course 02:Office Skills Training</li><li>Course 03:Corporate Paralegal</li><li>Course 04:Performance Management</li><li>Course 05:Team Management</li><li>Course 06:Microsoft Word, PowerPoint &amp; Outlook</li><li>Course 07:Presentation Skills</li><li>Course 08:Workplace Confidentiality</li><li>Course 09:Decision Making and Critical Thinking</li><li>Course 10:Workplace Productivity</li><li>Course 11:Persuasion and Influencing Skills</li><li>Course 12:Personal Hygiene Course</li><li>Course 13:Public Speaking</li><li>Course 14:Leadership Skills</li><li>Course 15:Corporate Risk And Crisis Management</li><li>Course 16:Cross-Cultural Awareness Training</li><li>Course 17:Equality, Diversity and Discrimination</li><li>Course 18:Level 3 Coaching &amp; Mentoring Course</li><li>Course 19:Communication and Organisational Skills</li><li>Course 20:Meeting Management Online</li><li>Course 21:Minute Taking Certificate</li><li>Course 22:Document Control</li><li>Course 23:Touch Typing</li><li>Course 24:Email Writing</li><li>Course 25:Health and Safety in the Workplace Level 2</li><li>Course 26:Business Etiquette and Professionalism Training</li><li>Course 27:Workplace First Aid Training</li><li>Course 28:Information Management</li><li>Course 29:Facilities Management and Workplace Services</li><li>Course 30:UK Employment Law</li></ul> <p><strong>3 </strong><strong>Extraordinary Career Oriented courses that will assist you in reimagining your thriving techniques-</strong></p> <ul> <li>Course 01: Career Development Plan Fundamentals</li><li>Course 02: CV Writing and Job Searching</li><li>Course 03: Interview Skills: Ace the Interview</li></ul> <p><strong>Learning Outcome</strong></p> <p><strong>This tailor-made </strong><strong>Office Skills and Office Management</strong><strong> bundle will allow you to-</strong></p> <ul> <li>Uncover your skills and aptitudes to break new ground in the related fields</li><li>Deep dive into the fundamental knowledge</li><li>Acquire some hard and soft skills in this area</li><li>Gain some transferable skills to elevate your performance</li><li>Maintain good report with your clients and staff</li><li>Gain necessary office skills and be tech savvy utilising relevant software</li><li>Keep records of your work and make a report</li><li>Know the regulations around this area</li><li>Reinforce your career with specific knowledge of this field</li><li>Know your legal and ethical responsibility as a professional in the related field</li></ul> <p>This Office Skills and Office Management Bundle resources were created with the help of industry experts, and all subject-related information is kept updated on a regular basis to avoid learners from falling behind on the latest developments.</p> <p><strong>Certification</strong></p> <p>After studying the complete training you will be able to take the assessment. After successfully passing the assessment you will be able to claim all courses pdf certificates and <strong>1 hardcopy certificate for the Title Course completely free</strong>. Other Hard Copy certificates need to be ordered at an additional cost of •8.</p> <h2>
        
        <div>CPD</div>
    </h2>

                        <div id="cpd">
                            <div>
                                <div>
                                    <div>
                                        330 CPD hours / points
                                    </div>
                                        <div>
                                            Accredited by CPD Quality Standards
                                        </div>
                                </div>
                            </div>
                        </div> <h2>
        
        <div>Who is this course for?</div>
    </h2>

                        <div id="who_is_this_course_for">
                             <p>Ambitious learners who want to strengthen their CV for their desired job should take advantage of the Office Skills and Office Management bundle! This bundle is also ideal for professionals looking for career advancement.</p> 
                        </div> <h2>
        
        <div>Requirements</div>
    </h2>

                        <div id="requirements">
                             <p>To participate in this course, all you need is -</p> <ul> <li>A smart device</li><li>A secure internet connection</li><li>And a keen interest in Office Skills and Office Management</li></ul> 
                        </div> <h2>
        
        <div>Career path</div>
    </h2>

                        <div id="career_path">
                             <p>Upon completing this essential Bundle, you will discover a new world of endless possibilities. These courses will help you to get a cut above the rest and allow you to be more efficient in the relevant fields.</p> 
                        </div>

Do you want to prepare for your dream job but strive hard to find the right courses? Then, stop worrying, for our strategically modified Office Skills and Office Management bundle will keep you up to date with the relevant knowledge and most recent matters of this emerging field. So, invest your money and effort in our 33 course mega bundle that will exceed your expectations within your budget.
The Office Skills and Office Management related fields are thriving across the UK, and recruiters are hiring the most knowledgeable and proficient candidates. It's a demanding field with magnitudes of lucrative choices. If you need more guidance to specialise in this area and need help knowing where to start, then  StudyHub proposes a preparatory bundle. This comprehensive Office Skills and Office Management bundle will help you build a solid foundation to become a proficient worker in the sector.
This Office Skills and Office Management Bundle consists of the following 30 CPD Accredited Premium courses - 
Course 01:Admin, Secretarial & PA
Course 02:Office Skills Training
Course 03:Corporate Paralegal
Course 04:Performance Management
Course 05:Team Management
Course 06:Microsoft Word, PowerPoint & Outlook
Course 07:Presentation Skills
Course 08:Workplace Confidentiality
Course 09:Decision Making and Critical Thinking
Course 10:Workplace Productivity
Course 11:Persuasion and Influencing Skills
Course 12:Personal Hygiene Course
Course 13:Public Speaking
Course 14:Leadership Skills
Course 15:Corporate Risk And Crisis Management
Course 16:Cross-Cultural Awareness Training
Course 17:Equality, Diversity and Discrimination
Course 18:Level 3 Coaching & Mentoring Course
Course 19:Communication and Organisational Skills
Course 20:Meeting Management Online
Course 21:Minute Taking Certificate
Course 22:Document Control
Course 23:Touch Typing
Course 24:Email Writing
Course 25:Health and Safety in the Workplace Level 2
Course 26:Business Etiquette and Professionalism Training
Course 27:Workplace First Aid Training
Course 28:Information Management
Course 29:Facilities Management and Workplace Services
Course 30:UK Employment Law
3 Extraordinary Career Oriented courses that will assist you in reimagining your thriving techniques-
Course 01: Career Development Plan Fundamentals
Course 02: CV Writing and Job Searching
Course 03: Interview Skills: Ace the Interview
Learning Outcome
This tailor-made Office Skills and Office Management bundle will allow you to-
Uncover your skills and aptitudes to break new ground in the related fields
Deep dive into the fundamental knowledge
Acquire some hard and soft skills in this area
Gain some transferable skills to elevate your performance
Maintain good report with your clients and staff
Gain necessary office skills and be tech savvy utilising relevant software
Keep records of your work and make a report
Know the regulations around this area
Reinforce your career with specific knowledge of this field
Know your legal and ethical responsibility as a professional in the related field
This Office Skills and Office Management Bundle resources were created with the help of industry experts, and all subject-related information is kept updated on a regular basis to avoid learners from falling behind on the latest developments.
Certification
After studying the complete training you will be able to take the assessment. After successfully passing the assessment you will be able to claim all courses pdf certificates and 1 hardcopy certificate for the Title Course completely free. Other Hard Copy certificates need to be ordered at an additional cost of •8.
 CPD 
330 CPD hours / points  Accredited by CPD Quality Standards
 Who is this course for? 
Ambitious learners who want to strengthen their CV for their desired job should take advantage of the Office Skills and Office Management bundle! This bundle is also ideal for professionals looking for career advancement.
 Requirements 
To participate in this course, all you need is -
A smart device
A secure internet connection
And a keen interest in Office Skills and Office Management
 Career path 
Upon completing this essential Bundle, you will discover a new world of endless possibilities. These courses will help you to get a cut above the rest and allow you to be more efficient in the relevant fields.

Studyhub UK

Office Skills & Productivity

Professional Skills

Office Skills

Office Management

Professional Skills Course (PSC)

Office Administration

Office Skills and Office Management

<section>
						<div>
				<div>
				<div>
			<div>
					<div>
				<div>
				<div>
					<div>
			<div></div>
		</div>
				</div>
				</div>
				<div>
				<div>
			
				</div>
				<div>
				<div>
					<div><p>Step into the meticulous realm of Office Facility Management, where every cog in the machinery has its own unique importance. Imagine an office where procedures are finely tuned, every task flows smoothly, constraints are merely challenges waiting to be overcome, and the environment resonates with productivity. This course aims to transform that picture into reality.</p><p>The intricacies of managing an office space go beyond the visible desks and chairs. It's about understanding the constraints tied to these facilities and ensuring that they serve rather than hinder them. As you journey through the course, you'll learn to curate an environment that looks appealing and functions efficiently. Each module has been crafted to offer a comprehensive understanding of the subject, from managing the lifeline of equipment and consumables to mastering the art of setting up robust office systems.</p><p>By the end, you'll not just have theoretical knowledge but actionable insights into ensuring a seamless work flow, punctuated by well-maintained equipment and a harmonious environment. Office Facility Management is not just a course; it's your blueprint for crafting a space where work feels less like a chore and more like a well-oiled symphony.</p></div>
				</div>
				</div>
						</div>
			</div>
		</div>
						</div>
			</div>
		</div></section>
				<section>
						<div>
				<div>
				<div>
			<div>
					<div>
				<div>
				<div>
			<h2><b> Learning outcome</b></h2>		</div>
				</div>
				<div>
				<div>
					<ul>
							<li>
											<span>
													</span>
										<span>Acquire knowledge of effective office management procedures.</span>
									</li>
								<li>
											<span>
													</span>
										<span>Identify and mitigate constraints linked to office facilities.</span>
									</li>
								<li>
											<span>
													</span>
										<span>Design and maintain an ideal office environment.</span>
									</li>
								<li>
											<span>
													</span>
										<span>Oversee and ensure the efficient use of equipment and consumables.</span>
									</li>
								<li>
											<span>
													</span>
										<span>Implement robust office systems and procedures.</span>
									</li>
								<li>
											<span>
													</span>
										<span>Ensure an unobstructed flow of work within the office.</span>
									</li>
								<li>
											<span>
													</span>
										<span>Effectively oversee the upkeep of essential office equipment.</span>
									</li>
						</ul>
				</div>
				</div>
						</div>
			</div>
		</div>
						</div>
			</div>
		</section>
				<section>
						<div>
				<div>
				<div>
			<div>
					<div>
				<div>
				<div>
					</div>
				</div>
				<div>
				<div>
					
			</div>
				</div>
						</div>
			</div>
		</div>
						</div>
			</div>
		</section>
				<section>
						<div>
				<div>
				<div>
			<div>
					<div>
				<div>
				<div>
			<h2> <b>Why should I take this course?</b></h2>		</div>
				</div>
				<div>
				<div>
					<ul>
							<li>
											<span>
													</span>
										<span>Mastery over office procedures boosts career prospects.</span>
									</li>
								<li>
											<span>
													</span>
										<span>Improve efficiency in your current or future workplace.</span>
									</li>
								<li>
											<span>
													</span>
										<span>Learn to manage resources and equipment effectively.</span>
									</li>
								<li>
											<span>
													</span>
										<span>Grasp insights into workflow for enhanced productivity.</span>
									</li>
								<li>
											<span>
													</span>
										<span>Equip yourself with skills sought-after in the corporate realm.</span>
									</li>
						</ul>
				</div>
				</div>
						</div>
			</div>
		</div>
						</div>
			</div>
		</section>
				<section>
						<div>
				<div>
				<div>
			<div>
					<div>
				<div>
				<div>
			<h2> <b>Career Path</b></h2>		</div>
				</div>
				<div>
				<div>
					<ul>
							<li>
											<span>
													</span>
										<span>Office Manager</span>
									</li>
								<li>
											<span>
													</span>
										<span>Facilities Coordinator</span>
									</li>
								<li>
											<span>
													</span>
										<span>Office Systems Analyst</span>
									</li>
								<li>
											<span>
													</span>
										<span>Office Environment Designer</span>
									</li>
								<li>
											<span>
													</span>
										<span>Equipment Maintenance Supervisor</span>
									</li>
								<li>
											<span>
													</span>
										<span>Workflow Strategist</span>
									</li>
						</ul>
				</div>
				</div>
						</div>
			</div>
		</div>
						</div>
			</div>
		</section>
				<section>
						<div>
				<div>
				<div>
			<div>
					<div>
				<div>
				<div>
			<h2> <b>Requirements</b></h2>		</div>
				</div>
				<div>
				<div>
					<ul>
							<li>
											<span>
													</span>
										<span>Prior exposure to an office setup</span>
									</li>
								<li>
											<span>
													</span>
										<span>A keen interest in enhancing office efficiency</span>
									</li>
								<li>
											<span>
													</span>
										<span>A proactive approach to learning</span>
									</li>
						</ul>
				</div>
				</div>
						</div>
			</div>
		</div>
						</div>
			</div>
		</section><div>
                            <div>
                                <h2>Course Curriculum</h2>
                            </div>
                            			<div>
				

<div>
<table width="100%">				<tbody><tr>
					<td colspan="4"><strong>Section 01: Office Management Procedure</strong></td>
				</tr>
								<tr>
					<td>▶</td>
					<td>Office Management Procedure</td><td><span>🕐 00:19:00</span></td>
				</tr>
								<tr>
					<td colspan="4"><strong>Section 02: Managing Constraints Attached To Office Facilities</strong></td>
				</tr>
								<tr>
					<td>▶</td>
					<td>Managing Constraints Attached to Office Facilities</td><td><span>🕐 00:13:00</span></td>
				</tr>
								<tr>
					<td colspan="4"><strong>Section 03: Office Environment</strong></td>
				</tr>
								<tr>
					<td>▶</td>
					<td>Office Environment</td><td><span>🕐 00:18:00</span></td>
				</tr>
								<tr>
					<td colspan="4"><strong>Section 04: Maintain Equipment And Consumables</strong></td>
				</tr>
								<tr>
					<td>▶</td>
					<td>Maintain Equipment and Consumables</td><td><span>🕐 00:11:00</span></td>
				</tr>
								<tr>
					<td colspan="4"><strong>Section 05: Office Systems And Procedure</strong></td>
				</tr>
								<tr>
					<td>▶</td>
					<td>Office Systems and Procedure</td><td><span>🕐 00:15:00</span></td>
				</tr>
								<tr>
					<td colspan="4"><strong>Section 06: Flow Of Work</strong></td>
				</tr>
								<tr>
					<td>▶</td>
					<td>Flow of Work</td><td><span>🕐 00:13:00</span></td>
				</tr>
								<tr>
					<td colspan="4"><strong>Section 07: Manage The Maintenance Of Office Equipment</strong></td>
				</tr>
								<tr>
					<td>▶</td>
					<td>Manage the Maintenance of Office Equipment</td><td><span>🕐 00:16:00</span></td>
				</tr>
				</tbody></table></div>

			</div>
		                        </div>

Step into the meticulous realm of Office Facility Management, where every cog in the machinery has its own unique importance. Imagine an office where procedures are finely tuned, every task flows smoothly, constraints are merely challenges waiting to be overcome, and the environment resonates with productivity. This course aims to transform that picture into reality.
The intricacies of managing an office space go beyond the visible desks and chairs. It's about understanding the constraints tied to these facilities and ensuring that they serve rather than hinder them. As you journey through the course, you'll learn to curate an environment that looks appealing and functions efficiently. Each module has been crafted to offer a comprehensive understanding of the subject, from managing the lifeline of equipment and consumables to mastering the art of setting up robust office systems.
By the end, you'll not just have theoretical knowledge but actionable insights into ensuring a seamless work flow, punctuated by well-maintained equipment and a harmonious environment. Office Facility Management is not just a course; it's your blueprint for crafting a space where work feels less like a chore and more like a well-oiled symphony.
 Learning outcome
Acquire knowledge of effective office management procedures.
Identify and mitigate constraints linked to office facilities.
Design and maintain an ideal office environment.
Oversee and ensure the efficient use of equipment and consumables.
Implement robust office systems and procedures.
Ensure an unobstructed flow of work within the office.
Effectively oversee the upkeep of essential office equipment.
 Why should I take this course?
Mastery over office procedures boosts career prospects.
Improve efficiency in your current or future workplace.
Learn to manage resources and equipment effectively.
Grasp insights into workflow for enhanced productivity.
Equip yourself with skills sought-after in the corporate realm.
 Career Path
Office Manager
Facilities Coordinator
Office Systems Analyst
Office Environment Designer
Equipment Maintenance Supervisor
Workflow Strategist
 Requirements
Prior exposure to an office setup
A keen interest in enhancing office efficiency
A proactive approach to learning
Course Curriculum
Section 01: Office Management Procedure			
▶	Office Management Procedure	🕐 00:19:00
Section 02: Managing Constraints Attached To Office Facilities			
▶	Managing Constraints Attached to Office Facilities	🕐 00:13:00
Section 03: Office Environment			
▶	Office Environment	🕐 00:18:00
Section 04: Maintain Equipment And Consumables			
▶	Maintain Equipment and Consumables	🕐 00:11:00
Section 05: Office Systems And Procedure			
▶	Office Systems and Procedure	🕐 00:15:00
Section 06: Flow Of Work			
▶	Flow of Work	🕐 00:13:00
Section 07: Manage The Maintenance Of Office Equipment			
▶	Manage the Maintenance of Office Equipment	🕐 00:16:00

Skill Up

Office Productivity

Facility Management

Dive into the intricate world of Office Facility Management, where every detail matters. Learn to harness office procedures and streamline work flow for optimal performance.

1715 Office courses in Cardiff delivered Live Online

Python Programming Beginners Evenings Course, Virtual Classroom.

By PCWorkshops

Microsoft Excel - Power Functions

By AXIOM Learning Solutions

Microsoft Excel - Creating Charts

By AXIOM Learning Solutions

Microsoft Excel - Automating Tasks by Programming in VBA

By AXIOM Learning Solutions

Microsoft Excel - More Functions and Formulas

By AXIOM Learning Solutions

Microsoft Excel - Lists and Tables

By AXIOM Learning Solutions

Microsoft Excel - Getting Started

By AXIOM Learning Solutions

Microsoft Excel - Functions and Formulas

By AXIOM Learning Solutions

Microsoft Excel - Formatting Spreadsheets

By AXIOM Learning Solutions

Microsoft Excel - Data Analysis Tools

By AXIOM Learning Solutions