<div id="course-pills-1">Duration<p>2 Days</p><p>12 CPD hours</p>This course is intended for<p>This course is intended for business users who have been using Power BI to build analytic solutions and are ready to take advantage of the power and flexibility that DAX provides. Learning DAX is a very common 'next step' for experienced Power BI users.</p>Overview<p>At course completion, you should be able to<br />describe DAX syntax, data types, and errors<br />use DAX to create calculated columns, measures, and tables<br />explain how DAX calculations are evaluated, along with the differences between row context and filter context<br />configure and use Time Intelligence to perform common time-based calculations, for example to-date calculations, year-over-year analysis, moving averages, etc.<br />create calculated columns and measures that use data from multiple tables in the data model<br />write measures that handle error conditions gracefully<br />use DAX to enhance the Power BI user experience<br />use DAX Studio to connect to a Power BI data model and execute simple queries</p><p>Welcome to Introduction to DAX for Power BI. This two-day instructor-led course is intended for business users who have been using Power BI and want to use DAX to create custom calculations in their data models. In this class, you will be introduced to using Data Analysis Expressions (DAX), which is the expression language that is used to create custom calculations in the Power BI Data model. The course covers some of the theoretical underpinnings of the data model and the DAX language, but the emphasis is on using DAX to solve common business problems. You will learn how to write your own calculated columns, measures, and tables, how to visualize the way Power BI computes DAX calculations, and how to troubleshoot custom code.</p></div><div id="course-pills-2"><h4>MODULE 1: GETTING STARTED WITH DAX </h4><ul><li>INTRODUCTION TODAX </li><li>CREATING OBJECTS WITHDAX </li><li>CONTEXT AND RULES OF EVALUATION</li><li>VARIABLES,COMMENTS,AND TESTING</li></ul><h4>MODULE 2: PERFORMING BASIC CALCULATIONS</h4><ul><li>GETTING STARTED</li><li>IMPLICIT MEASURES </li><li>ADDING QUICK MEASURES </li><li>WORKING WITH DAX DATA TYPES .</li><li>DOING BASIC MATH </li><li>USING LOGIC IN YOUR CALCULATIONS </li><li>USING THE IF() FUNCTION </li><li>NESTED IF()</li><li>USING THE SWITCH() FUNCTION </li><li>ADVANCED SWITCH()</li><li>LOGICAL OPERATORS &amp; FUNCTIONS: ||, OR(), &amp;&amp;, AND(), NOT()</li><li>AGGREGATING AND SUMMARIZING DATA </li><li>THE SUM() FUNCTION</li></ul><h4>MODULE 3: WORKING WITH CONTEXT IN THE DATA MODEL </h4><ul><li>CONTEXT DEFINED </li><li>DATA MODELING BASICS </li><li>INTRODUCTION TO DIMENSIONAL MODELING </li><li>RELATIONSHIPS AND THEIR EFFECT ON THE EVALUATION CONTEXT </li><li>GETTING DATA FROM OTHER TABLES USING RELATED() AND RELATEDTABLE</li><li>LOOKING UP DATA WITHOUT USING RELATIONSHIPS </li><li>MODIFYING THE CONTEXT USING CALCULATE()</li></ul><h4>MODULE 4: PERFORMING MORE ADVANCED CALCULATIONS </h4><ul><li>THE DAX ITERATOR FUNCTIONS </li><li>USING TABLE MANIPULATION FUNCTIONS</li></ul><h4>MODULE 5: WORKING WITH TIME</h4><ul><li>PERFORMING DATE CALCULATIONS </li><li>WORKING WITH DATE TABLES </li><li>GENERATING A DATE TABLE WITH THE CALENDAR() FUNCTION </li><li>DEFINING CUSTOM OPERATING PERIODS </li><li>YTD, QTD, AND MTD CALCULATIONS </li><li>CUSTOM TO-DATE CALCULATIONS </li><li>FINDING YEAR-OVER-YEAR CHANGE </li><li>FINDING MOVING AVERAGES </li></ul><h4>MODULE 6: ENHANCING THE USER EXPERIENCE</h4><ul><li>CONTROLLING VISIBILITYOF YOUR MEASURES</li><li>USING WHAT-IF PARAMETERS </li><li>ADDING BANDING </li><li>USING DAX TO PROVIDE ROW-LEVEL SECURITY </li></ul></div>

Nexus Human

Powerbi

Business Analytics & Intelligence

Microsoft Power BI

Excel Analytics

Data Analysis Expressions

Data Skills

Introduction to DAX for Power BI

General Admission

<h2><strong>Course Overview:</strong></h2>

<p> 
<strong>Data analysis is a hot skill in today's job market. According to a recent study by LinkedIn, demand for data analysts is growing 15 times faster than the average for all occupations.</strong> And the salaries are good too. The average salary for a data analyst in the UK is £40,000. <strong>If you're looking to get ahead in your career or learn a new skill that's in high demand, then the Data Analysis in Excel Level 3 Course is for you. </strong>
</p>

<p> 
In this course, you'll learn how to use <strong>Excel to analyse data like a pro. You'll learn how to clean, format, and analyse data using various Excel tools and techniques. You'll also learn how to create charts and graphs to visualise your data.</strong> This course won't merely make you adept at Excel. <strong>It will mould you into a data wizard, wielding Excel as a potent tool to make data sing and secrets reveal themselves.</strong>
</p> 

<p> 
Enrol Today and Start Learning!
</p> 

<hr />

<h2><strong>Key Features of the Course:</strong></h2>

<p> 
Embark on your data analysis journey with us and discover these exciting features:
</p>

<ul>
 	<li>A CPD Certificate to validate your newfound skills.</li>
 	<li>24/7 Learning Assistance for any hour inspiration strikes.</li>
 	<li>Engaging learning materials to ensure an enriching learning experience.</li>
 
</ul>

<hr />

<h2><strong>Who is This Course For?</strong></h2>

<p> 
Our Data Analysis in Excel Level 3 Course caters to ambitious individuals with a basic understanding of Excel, eager to take their skills to new heights. This course welcomes everything from budding data enthusiasts to established business analysts seeking to fortify their analytical toolkits.
</p>

<hr />

<h2><strong>What You Will Learn:</strong></h2>

<p> 
Dive deep into the labyrinth of data as you master essential modules such as <strong>'Search for and Replace Data,' 'Sort and Filter Data,' and 'Query Data with Database Functions.' Venture further into data exploration with our 'Outline and Subtotal Data' module, where you'll learn to summarise your data for a more organised view efficiently.</strong>
</p>

<p> 
The journey continues with modules like <strong>'Create Charts' and 'Modify and Format Charts,' enabling you to translate complex data into easy-to-understand visuals. Furthermore, our dedicated modules on 'Creating a PivotTable' and 'Analysing PivotTable Data' promise a comprehensive understanding of one of Excel's most powerful tools.</strong>
</p>


<hr />

<h2><strong>Why Enrol in This Course:</strong></h2>

<p> 
Rated as a top-reviewed course and constantly updated to keep up with the latest trends, our Data Analysis in Excel Level 3 Course equips you with sought-after skills like data forecasting, creating sparklines, using advanced chart features, and more.
</p>

<hr />

<h2><strong>Requirements:</strong></h2>

<p> 
While no specific prerequisites are required, a basic understanding of Excel and an eagerness to explore the fascinating world of data analysis would be beneficial.
</p>

<hr />

<h2><strong>Career Path:</strong></h2>

<p>  
On completion of this Data Analysis in Excel Level 3 Course course, you'll be ready to step into diverse roles such as:
</p>

<ul>
 	<li>Data Analyst (£30,000-£35,000)</li> 
 	<li>Business Intelligence Analyst (£32,000-£37,000)</li> 
 	<li>Market Research Analyst (£28,000-£33,000)</li> 
 	<li>Operations Analyst (£31,000-£36,000)</li> 
 	<li>Financial Analyst (£35,000-£40,000)</li> 
 	<li>Supply Chain Analyst (£30,000-£35,000)</li> 
 	<li>Sales Analyst (£29,000-£34,000)</li> 	
</ul>


<hr />

<h2><strong>Certification:</strong></h2>

<p> 
Upon successful completion of the course, you'll be awarded a prestigious CPD Certificate, demonstrating your expertise in data analysis using Excel.
</p>
<p> 
So, are you ready to discover the hidden stories in data and revolutionise decision-making? Enrol in our Data Analysis in Excel Level 3 Course and start your journey today!
</p>

<hr /> <h3>Course Curriculum</h3><div><p>11 sections • 32 lectures • 04:43:00 total length</p></div><div><div><div><div><div><div><div><p>•Insert, Delete, and Adjust Cells, Columns, and Rows: 00:10:00</p></div><div><div><p>•Search for and Replace Data: 00:09:00</p></div><div><div><p>•Use Proofing and Research Tools: 00:07:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Sort Data: 00:10:00</p></div><div><div><p>•Filter Data: 00:10:00</p></div><div><div><p>•Query Data with Database Functions: 00:09:00</p></div><div><div><p>•Outline and Subtotal Data: 00:09:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Apply Intermediate Conditional Formatting: 00:07:00</p></div><div><div><p>•Apply Advanced Conditional Formatting: 00:05:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Create Charts: 00:13:00</p></div><div><div><p>•Modify and Format Charts: 00:12:00</p></div><div><div><p>•Use Advanced Chart Features: 00:12:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Create a PivotTable: 00:13:00</p></div><div><div><p>•Analyze PivotTable Data: 00:12:00</p></div><div><div><p>•Present Data with PivotCharts: 00:07:00</p></div><div><div><p>•Filter Data by Using Timelines and Slicers: 00:11:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Use Links and External References: 00:12:00</p></div><div><div><p>•Use 3-D References: 00:06:00</p></div><div><div><p>•Consolidate Data: 00:05:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Use Lookup Functions: 00:12:00</p></div><div><div><p>•Trace Cells: 00:09:00</p></div><div><div><p>•Watch and Evaluate Formulas: 00:08:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Apply Data Validation: 00:13:00</p></div><div><div><p>•Search for Invalid Data and Formulas with Errors: 00:04:00</p></div><div><div><p>•Work with Macros: 00:18:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Create Sparklines: 00:07:00</p></div><div><div><p>•MapData: 00:07:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Determine Potential Outcomes Using Data Tables: 00:08:00</p></div><div><div><p>•Determine Potential Outcomes Using Scenarios: 00:09:00</p></div><div><div><p>•Use the Goal Seek Feature: 00:04:00</p></div><div><div><p>•Forecasting Data Trends: 00:05:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Assignment - Data Analysis in Excel Level 3 Course: 00:00:00</p></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div>

Apex Learning

Data Analysis

Data Analyst

Business Data Analysis

Data Analysis in Excel Level 3 Course

London

<p><strong>Course Objectives</strong></p><p>This course aims to provide delegates with a foundation for Excel knowledge and skills.</p><p>'</p><p><em><strong>Customer Feedback</strong></em></p><ul><li><strong>Very professional and well mannered, fun and pleasant at the same time. I learnt a lot</strong></li><li>Carolina Foster - CNN</li></ul><ul><li><strong>Very helpful course. Would definitely take another one. Pedro was very patient and made it fun and engaged with us all.</strong></li><li>Laura Smith - James Grant</li></ul><ul><li><strong>Great course and excellent trainer. Thanks</strong></li><li>Tracy Preston - Western Power Distribution</li></ul><p>1 year email support service</p><p>Take a look at the <strong>consistent excellent feedback from our corporate clients</strong> visiting our site <em><strong>ms-officetraining co uk</strong></em></p><p>With more than 20 years experience, we deliver courses on all levels of the Desktop version of <strong>Microsoft Office and Office 365</strong>; ranging from Beginner, Intermediate, Advanced to the VBA level.</p><p>Our trainers are Microsoft certified professionals with a proven track record with several years experience in delivering<strong> public, one to one, tailored and bespoke courses.</strong></p><ul><li><strong>Our competitive rates <strong>start from £550.00 per day of training</strong></strong></li></ul><p><strong><strong>Tailored training courses:</strong></strong></p><p>You can choose to run the course exactly as they are outlined by us or we can customise it so that it meets your specific needs. A tailored or bespoke course will follow the standard outline but may be adapted to your specific organisational needs.</p><p><strong>What is Excel?</strong></p><p><strong>The Excel Interface</strong></p><ul><li>Ribbon, Tabs and Groups</li><li>Microsoft Office Backstage view</li></ul><p><strong>Working with Workbooks</strong></p><ul><li>Create a blank Workbook</li><li>Create a Workbook using a Template</li><li>Opening and saving Files</li></ul><p><strong>Working with worksheets</strong></p><ul><li>Worksheet navigation</li><li>Select one or multiple Worksheets</li><li>Insert, Move, Copy or Delete a Worksheet</li></ul><p><strong>Working with Cells, Rows &amp; Columns</strong></p><ul><li>Cell References</li><li>How to select cells or ranges</li><li>Different types of data</li><li>Move, Copy and Delete cells</li><li>Pasting Options</li><li>Find and Replace</li><li>Working with Rows and Columns</li></ul><p><strong>Overview of formulas in Excel</strong></p><ul><li>Autocalculation</li><li>The parts of an Excel formula</li><li>Using calculation operators in Excel formulas</li><li>The difference between Absolute, Relative and Mixed references</li><li>Using Excel functions; Sum, Average, Max and Min</li></ul><p><strong>Cell Formatting</strong></p><ul><li>Font Format options</li><li>Number Format options</li><li>Change the Fill and Borders</li><li>Cell Alignment</li></ul><p><strong>An Introduction to Charts</strong></p><ul><li>Create a simple Chart</li><li>Format your chart</li></ul><p><strong>Page Layout and Print</strong></p><ul><li>Page Layout and Page Break View</li><li>Change the Page Orientation</li><li>Set Page Margins</li><li>Headers and Footers in a worksheet</li><li>Print a worksheet or workbook</li></ul><h2>
        
            Who is this course for?
        
        <div>Who is this course for?</div>
    </h2>

                        <div id="who_is_this_course_for">
                            <p>All users who want to master the main features of Microsoft Excel</p>
                        </div><h2>
        
            Requirements
        
        <div>Requirements</div>
    </h2>

                        <div id="requirements">
                            <p>General knowledge of the Windows OS</p>
                        </div><h2>
        
            Certificates
        
        <div>Certificates</div>
    </h2>

                        <div id="optional_extras">
                                    <h4>Certificate of completion</h4>
        <p>
            Digital certificate -
            Included
        </p>

                        </div>

Microsoft Office Training

Microsoft Excel Introduction - In-company

<p><strong>Course Objectives</strong></p><p>The goal of this course is to provide you with the knowledge required to use more advanced functions and formulas and work with various tools to analyse and present data in spreadsheets, such as sorting, filtering, applying conditional formatting and charting the data.</p><p>'</p><p><em><strong>Customer Feedback</strong></em></p><ul><li><p><strong>Really useful and engaging course. Learnt a lot that will be very beneficial in my job. Trainer was great.</strong></p></li><li>Kelly Moreley - TACT</li></ul><ul><li><strong>Very happy with the course. Worked as a good refresher from what I knew already and enhanced my knowledge further in formulas + vlookup and shortcut keys.</strong></li><li>Jenny Price - Acer</li></ul><p>1 year email support service</p><p>Take a look at the <strong>consistent excellent feedback from our corporate clients</strong> visiting our site <em><strong>ms-officetraining co uk</strong></em></p><p>With more than 20 years experience, we deliver courses on all levels of the Desktop version of <strong>Microsoft Office and Office 365</strong>; ranging from Beginner, Intermediate, Advanced to the VBA level.</p><p>Our trainers are Microsoft certified professionals with a proven track record with several years experience in delivering public, one to one, tailored and bespoke courses.</p><p><strong><strong>Tailored training courses:</strong></strong></p><p>In, in company training, you can choose to run the course exactly as they are outlined by us or we can customise it so that it meets your specific needs. A tailored or bespoke course will follow the standard outline but may be adapted to your specific organisational needs.</p><p><strong>Recap on Excel formulas and calculations</strong></p><ul><li>Overview of formulas in Excel</li><li>Relative, Absolute and Mixed cell references</li></ul><p><strong>Group editing worksheets</strong></p><p><strong>Autofill and Flash Fill</strong></p><p><strong>Changing Excel’s environment Options</strong></p><ul><li>Changing the default number of sheets</li><li>Creating an Autofill Custom List</li><li>Adding tools to the Quick Access Toolbar</li></ul><p><strong>Mastering Excel Tables</strong></p><ul><li>Introducing Excel Tables</li><li>Formatting a Table</li><li>Creating Calculated Columns</li><li>Using Slicers to filter your data</li><li>Using Totals to get statistics out of your data</li><li>Removing duplicates</li><li>Converting Tables back to normal Ranges</li></ul><p><strong>Using names Ranges</strong></p><ul><li>In Excel formulas</li><li>As a way of navigating through the workbook</li></ul><p><strong>Advanced Formulas</strong></p><ul><li>Simple IF examples</li><li>Using IF to check if a cell is blank</li><li>Nested IFs</li><li>VLOOKUP</li><li>HLOOKUP</li><li>Text Functions</li><li>Date Functions</li></ul><p><strong>Conditional formatting</strong></p><ul><li>Apply Conditional Formatting</li><li>Customising Conditional Formatting</li><li>Using Icons in Conditional Formatting</li><li>Using Formulas to conditionally format cells</li></ul><p><strong>Linking spreadsheets and workbooks</strong></p><ul><li>Making a reference to another worksheet</li><li>Making a reference to another workbook</li><li>Editing links</li><li>Troubleshooting links</li></ul><p><strong>Analysing databases</strong></p><ul><li>Quick analysis</li><li>Sorting a database</li><li>Apply filters to a database</li><li>Advance filter</li><li>Sorting and Filtering by Conditional Formats</li></ul><p><strong>Charts</strong></p><ul><li>Analyse trends in data using Sparklines</li><li>Creating charts from start to finish</li><li>Exploring the different Chart Types</li><li>Apply Chart Styles</li><li>Formatting Chart Elements</li><li>Filtering Charts by Series or Categories</li><li>Adding a Trendline to a Chart</li><li>Create a Chart Template</li></ul><p><strong>Attaching security to a spreadsheet and workbook</strong></p><ul><li>Protect Cells</li><li>Protect Structure of worksheets</li><li>Protect a Workbook by adding passwords</li></ul><p><strong>Introduction to Pivot Tables</strong></p><ul><li>What are Pivot Tables?</li><li>Using recommended pivot tables to analyse your data</li></ul><h2>
        
            Who is this course for?
        
        <div>Who is this course for?</div>
    </h2>

                        <div id="who_is_this_course_for">
                            <p>For those who want to explore in more detail formulas and functions, data analysis and data presentation.</p>
                        </div><h2>
        
            Requirements
        
        <div>Requirements</div>
    </h2>

                        <div id="requirements">
                            <p>Preferably, delegates would have attended the Excel Introduction course.</p>
                        </div><h2>
        
            Career path
        
        <div>Career path</div>
    </h2>

                        <div id="career_path">
                            <p>Excel know-how can instantly increase your job prospects as well as your salary.</p><p>80 percent of job openings require spreadsheet and word-processing software skills</p>
                        </div><h2>
        
            Certificates
        
        <div>Certificates</div>
    </h2>

                        <div id="optional_extras">
                                    <h4>Certificate of completion</h4>
        <p>
            Digital certificate -
            Included
        </p>

                        </div>

Microsoft Excel Intermediate - In-company

<p><strong>24 Hour Flash Deal **25-in-1 </strong><strong>Microsoft Office Specialist Excel Certification </strong><strong>Mega Bundle**</strong></p><p><strong> </strong><strong>Microsoft Office Specialist Excel Certification </strong><strong>Enrolment Gifts  **FREE PDF Certificate**FREE PDF Transcript ** FREE Exam** FREE Student ID ** Lifetime Access **FREE Enrolment Letter **</strong></p><p>Take the initial steps toward a successful long-term career by studying the <strong>Microsoft Office Specialist Excel Certification</strong> package online with <strong>Studyhub </strong>through our online learning platform. The Microsoft Office Specialist Excel Certification bundle can help you improve your CV, wow potential employers, and differentiate yourself from the mass.</p><p>This <strong>Microsoft Office Specialist Excel Certification </strong>course provides complete 360-degree training on Microsoft Office Specialist Excel Certification. You'll get not one, not two, not three, but <strong>twenty-five </strong>Microsoft Office Specialist Excel Certification courses included in this course. Plus Studyhub's signature <strong>Forever Access</strong> is given as always, meaning these Microsoft Office Specialist Excel Certification courses are yours for as long as you want them once you enrol in this course</p><p><strong>This Microsoft Office Specialist Excel Certification Bundle consists the following career oriented courses:</strong></p><ul><li>Course 01: Microsoft Excel</li><li>Course 02: Microsoft Excel: Automated Dashboard Using Advanced Formula, VBA, Power Query</li><li>Course 03: Excel VBA/Macros Foundations</li><li>Course 04: Microsoft Excel: Master Power Query in 120 Minutes!</li><li>Course 05: Excel: Top 50 Microsoft Excel Formulas in 50 Minutes!</li><li>Course 06: Data Analysis in Excel</li><li>Course 07: Excel 2016 Advanced Formulas and Functions</li><li>Course 08: MS Word Essentials</li><li>Course 09: Copyediting &amp; Proofreading</li><li>Course 10: Microsoft PowerPoint</li><li>Course 11: Bookkeeping Tool : Google Sheets</li><li>Course 12: Data Analysis and Forecasting in Excel</li><li>Course 13: Excel Vlookup; Xlookup; Match and Index</li><li>Course 14: Excel Pivot Tables, Pivot Charts, Slicers, and Timelines</li><li>Course 15: PowerBI Formulas</li><li>Course 16: Learn Microsoft Word, PowerPoint &amp; Outlook In 90 Minutes!</li><li>Course 17: Microsoft Power BI 2021 Complete Course</li><li>Course 18: Microsoft Access Tables and Queries</li><li>Course 19: Microsoft Access Databases Forms and Reports</li><li>Course 20: Microsoft Teams</li><li>Course 21: Master the Basics of Microsoft Power Apps</li><li>Course 22: Learn the Fundamentals of Microsoft SharePoint</li><li>Course 23: Learn the Basics of Microsoft Visio in Only 30 minutes!</li><li>Course 24: Learn the Basics of Microsoft Forms in Only 30 minutes!</li><li>Course 25: Master the Basics of Microsoft Power Automate</li></ul> <p>The <strong>Microsoft Office Specialist Excel Certification </strong>course has been prepared by focusing largely on Microsoft Office Specialist Excel Certification career readiness. It has been designed by our Microsoft Office Specialist Excel Certification specialists in a manner that you will be likely to find yourself head and shoulders above the others. For better learning, one to one assistance will also be provided if it's required by any learners.</p><p>The Microsoft Office Specialist Excel Certification Bundle is one of the most prestigious training offered at StudyHub and is highly valued by employers for good reason. This Microsoft Office Specialist Excel Certification bundle course has been created with <strong>twenty-five </strong>premium courses to provide our learners with the best learning experience possible to increase their understanding of their chosen field.</p><p>This Microsoft Office Specialist Excel Certification Course, like every one of Study Hub's courses, is meticulously developed and well researched. Every one of the topics is divided into Microsoft Office Specialist Excel Certification Elementary modules, allowing our students to grasp each lesson quickly.</p><p>The Microsoft Office Specialist Excel Certification course is self-paced and can be taken from the comfort of your home, office, or on the go! With our Student ID card you will get discounts on things like music, food, travel and clothes etc.</p><p><strong>In this exclusive </strong><strong>Microsoft Office Specialist Excel Certification </strong><strong>bundle, you really hit the jackpot. Here's what you get:</strong></p><ul><li>Step by step Microsoft Office Specialist Excel Certification lessons</li><li>One to one assistance from Microsoft Office Specialist Excel Certification professionals if you need it</li><li>Innovative exams to test your knowledge after the Microsoft Office Specialist Excel Certification course</li><li>24/7 customer support should you encounter any hiccups</li><li>Top-class learning portal</li><li>Unlimited lifetime access to all twenty-five Microsoft Office Specialist Excel Certification courses</li><li>Digital Certificate, Transcript and student ID are all included in the price</li><li>PDF certificate immediately after passing</li><li>Original copies of your Microsoft Office Specialist Excel Certification certificate and transcript on the next working day</li><li>Easily learn the Microsoft Office Specialist Excel Certification skills and knowledge you want from the comfort of your home</li></ul> <h2>
        
        <div>CPD</div>
    </h2>

                        <div id="cpd">
                            <div>
                                <div>
                                    <div>
                                        250 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>This <strong>Microsoft Office Specialist Excel Certification </strong>training is suitable for -</p><ul><li>Students</li><li>Recent graduates</li><li>Job Seekers</li><li>Individuals who are already employed in the relevant sectors and wish to enhance their knowledge and expertise in Microsoft Office Specialist Excel Certification</li></ul><p>Microsoft Office Skills is a pathway of the following career opportunities:</p><ul><li>Microsoft Office Specialist (MOS) Expert</li><li>Microsoft Office Specialist (MOS) Master</li><li>Microsoft Office Specialist (MOS)</li><li>Microsoft Specialist certification in Office 365</li><li>MS Office User</li><li>Microsoft Certified Specialist Developing Microsoft Azure Solution</li><li>Microsoft Certified Technology Specialist (MCTS)</li><li>Microsoft Certified IT Professional (MCITP)</li></ul>
                        </div> <h2>
        
        <div>Requirements</div>
    </h2>

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

                        <div id="career_path">
                            <p>You will be able to kickstart your <strong>Microsoft Office Specialist Excel Certification </strong>career because this course includes various courses as a bonus. This Microsoft Office Specialist Excel Certification is an excellent opportunity for you to learn multiple skills from the convenience of your own home and explore Microsoft Office Specialist Excel Certification career opportunities.</p>
                        </div> <h2>
        
        <div>Certificates</div>
    </h2>

                        <div id="optional_extras">
                                    <h4>CPD Accredited Certificate</h4>
        <p>
            Digital certificate -
            Included
        </p>
            <div><ul><li>CPD Accredited e-Certificate - Free</li><li>CPD Accredited Hardcopy Certificate - Free</li><li>Enrolment Letter - Free</li><li>Student ID Card - Free</li></ul></div>

                        </div>

Studyhub UK

Microsoft MS-700

Microsoft Certification

Microsoft 365

Microsoft Excel

Microsoft Office

Microsoft AZ-700

Microsoft Office Specialist Excel Certification

Advance your expertise in food safety management with our FSSC 22000 v6 Lead Auditor course, certified by CQI and IRCA. This comprehensive program is designed for professionals aiming to conduct first, second, and third-party audits of Food Safety Management Systems (FSMS) against the FSSC 22000 v6 standard.
This course offers in-depth training on the principles and practices of auditing, providing you with the skills needed to lead audit teams and evaluate the conformance and effectiveness of FSMS within organizations. You will learn how to plan, execute, report, and follow up on audits in alignment with ISO 19011 guidelines and ISO/IEC 17021 standards.
Key Features of the Course:
Certified Expertise: Obtain a globally recognized CQI and IRCA certification, significantly boosting your professional credibility in the food safety sector.
Expert-Led Training: Benefit from the knowledge of seasoned instructors with extensive experience in food safety management and auditing, who provide practical insights and real-world applications.
Hands-On Learning: Participate in interactive exercises, case studies, and role-playing scenarios that replicate real audit situations, ensuring that you can apply your skills directly in your workplace.
Comprehensive Coverage: Gain a thorough understanding of the FSSC 22000 v6 standard, audit methodologies, risk management, and the process approach to food safety.
Career Advancement: Ideal for those aspiring to become lead auditors, food safety managers, or consultants, this course opens doors to new professional opportunities and recognition in the industry.
Upon successful completion of the course and examination, you will receive the prestigious CQI and IRCA certification, recognized globally as a mark of excellence in food safety auditing. This qualification will enable you to conduct audits for certification bodies and support organizations in achieving compliance and continual improvement in food safety management.
Enroll in our FSSC 22000 v6 Lead Auditor course today and take the next step in your journey to becoming a leader in food safety management.

QUALITY ACADEMY

Food Safety

Accredited Food Hygiene

Quality Auditor

Accredited Food Safety

Become an FSSC 22000 v6 Lead Auditor with our CQI and IRCA certified course. Gain the skills to lead food safety management audits and elevate your career. Enroll today!

FSSC 22000 v6 Lead Auditor (CQI and IRCA Certified)

<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;">[Updated 2022]</strong></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;">Microsoft Excel 2019: from ZERO to ADVANCED</strong></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Working knowledge of Excel is vital for most office-based professionals today, and stronger Excel skills can open the door to jobs, promotions, and leadership opportunities.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">For example, if basic SUM and AVERAGE functions can help businesses calculate and analyse data better and quicker, think about how much more efficient advanced functions can make you. And to make you efficient and better at work, our Microsoft Excel experts have designed this Microsoft Excel course.</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;">Curriculum</strong></p><ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">Microsoft Excel 2019 New Features</li><li fr-original-style="" style="box-sizing: border-box;">Getting Started with Microsoft Office Excel</li><li fr-original-style="" style="box-sizing: border-box;">Performing Calculations</li><li fr-original-style="" style="box-sizing: border-box;">Modifying a Worksheet</li><li fr-original-style="" style="box-sizing: border-box;">Formatting a Worksheet</li><li fr-original-style="" style="box-sizing: border-box;">Printing Workbooks</li><li fr-original-style="" style="box-sizing: border-box;">Managing Workbooks</li><li fr-original-style="" style="box-sizing: border-box;">Working with Functions</li><li fr-original-style="" style="box-sizing: border-box;">Working with Lists</li><li fr-original-style="" style="box-sizing: border-box;">Analyzing Data</li><li fr-original-style="" style="box-sizing: border-box;">Visualizing Data with Charts</li><li fr-original-style="" style="box-sizing: border-box;">Using PivotTables and PivotCharts</li><li fr-original-style="" style="box-sizing: border-box;">Working with Multiple Worksheets and Workbooks</li><li fr-original-style="" style="box-sizing: border-box;">Using Lookup Functions and Formula Auditing</li><li fr-original-style="" style="box-sizing: border-box;">Sharing and Protecting Workbooks</li><li fr-original-style="" style="box-sizing: border-box;">Automating Workbook Functionality</li><li fr-original-style="" style="box-sizing: border-box;">Creating Sparklines and Mapping Data</li><li fr-original-style="" style="box-sizing: border-box;">Forecasting Data</li><li fr-original-style="" style="box-sizing: border-box;">Excel Templates</li></ul><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;">Learning Outcomes</strong></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">By the end of this course, you&#39;ll learn the following skills:</p><ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">Perform various calculations and get results in seconds rather than doing them manually</li><li fr-original-style="" style="box-sizing: border-box;">Gain the ability to modify and format worksheets and learn to print and manage workbooks</li><li fr-original-style="" style="box-sizing: border-box;">Learn various functions and how to work with lists</li><li fr-original-style="" style="box-sizing: border-box;">Become an expert on data analysis 2019 features</li><li fr-original-style="" style="box-sizing: border-box;">Learn to use visual elements like charts and data visualisation to see and understand trends, outliers, and patterns in data</li><li fr-original-style="" style="box-sizing: border-box;">How to present data using PivotTables and PivotCharts as well as working with multiple worksheets and workbooks</li><li fr-original-style="" style="box-sizing: border-box;">Using lookup functions and formula auditing, sharing and protecting workbooks, automating workbook functionality</li><li fr-original-style="" style="box-sizing: border-box;">How to forecast data, create sparklines and mapping, usage of various Microsoft Excel templates</li></ul><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;">Key Features of the Microsoft Excel Course :</strong></p><ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">Accredited by CPD</li><li fr-original-style="" style="box-sizing: border-box;">Instant e-certificate and hard copy dispatch by next working day</li><li fr-original-style="" style="box-sizing: border-box;">Fully online, interactive course with audio voiceover</li><li fr-original-style="" style="box-sizing: border-box;">Developed by qualified professionals in the field</li><li fr-original-style="" style="box-sizing: border-box;">Self-paced learning and laptop, tablet, smartphone-friendly</li><li fr-original-style="" style="box-sizing: border-box;">24/7 Learning Assistance</li><li fr-original-style="" style="box-sizing: border-box;">Discounts on bulk purchases</li></ul><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;">Accreditation</strong></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">All of our courses, including this course<strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">, </strong>are fully accredited, providing you with up-to-date skills and knowledge and helping you to become more competent and effective in your chosen field.</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;">Certification</strong></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Once you&#39;ve successfully completed your course, you will immediately be sent a digital certificate. Also, you can have your printed certificate delivered by post (shipping cost &pound;3.99). Our certifications have no expiry dates, although we do recommend that you renew them every 12 months.</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;">Assessment</strong></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">At the end of the course, there will be an online assessment, which you will need to pass to complete the course. Answers are marked instantly and automatically, allowing you to know straight away whether you have passed the course.</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;">*** Additional Gifts ***</strong></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;">Free Life coaching Course</strong></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">This Microsoft Excel Skills course is designed for people with a career in Accounting, Finance, Marketing, Sales, Executive, Administration, Business Management, Manager, Human Resources, Customer Service, Assistant, and Reception.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">In this course, we will go in-depth into Microsoft Excel applications, which are delivered in a simple way to be understood.</p><h2 fr-original-style="" style="box-sizing: border-box;">
        
        <div fr-original-style="" style="box-sizing: border-box;">CPD</div>
    </h2>

                        <div id="cpd" fr-original-style="" style="box-sizing: border-box;">
                            <div fr-original-style="" style="box-sizing: border-box;">
                                <div fr-original-style="" style="box-sizing: border-box;">
                                    <div fr-original-style="" style="box-sizing: border-box;">
                                        15 CPD hours / points
                                    </div>
                                        <div fr-original-style="" style="box-sizing: border-box;">
                                            Accredited by CPD Quality Standards
                                        </div>
                                </div>
                            </div>
                        </div><h2 fr-original-style="" style="box-sizing: border-box;">
        
        <div fr-original-style="" style="box-sizing: border-box;">Career path</div>
    </h2>

                        <div id="career_path" 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;">No matter where you are or what you do, if you are working with digital data, having Microsoft Excel skills is a must. With skills, you can explore opportunities everywhere, including-</p><ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">Administrative Assistant</li><li fr-original-style="" style="box-sizing: border-box;">Accountants</li><li fr-original-style="" style="box-sizing: border-box;">Retail Manager</li><li fr-original-style="" style="box-sizing: border-box;">Cost Estimator</li><li fr-original-style="" style="box-sizing: border-box;">Financial Analyst</li><li fr-original-style="" style="box-sizing: border-box;">Project Manager</li><li fr-original-style="" style="box-sizing: border-box;">Business Analyst</li><li fr-original-style="" style="box-sizing: border-box;">Data Journalist</li></ul><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">And much more!</p>
                        </div><h2 fr-original-style="" style="box-sizing: border-box;">
        
        <div fr-original-style="" style="box-sizing: border-box;">Certificates</div>
    </h2>

                        <div id="optional_extras" fr-original-style="" style="box-sizing: border-box;">
                                    <h4 fr-original-style="" style="box-sizing: border-box;">Certificate of completion</h4>
        <p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">
            Digital certificate -
            Included
        </p>
        <h4 fr-original-style="" style="box-sizing: border-box;">Certificate of completion</h4>
        <p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">
            Hard copy certificate -
            Included
        </p>
            <div 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;">You will get the hard copy certificates for Free! The delivery charge of the hard copy certificate inside the UK is &pound;3.99 each.</p> </div>

                        </div>

Training Express

Office Skills & Productivity

Data Entry Skills

Professional Skills

Computer Skills

Microsoft Excel: from ZERO to ADVANCED Course

<h2>Microsoft Excel® in Depth: In-House Training</h2>
 <p>The goal of this course is to provide a deeper understanding of Excel and its intricacies and a new ability to use it efficiently producing the best solutions for your projects.</p>
 <p>This practical course provides a solid background of the features of Excel and a deeper understanding of its features, benefits and uses. This is not a beginner's course in Excel. You will learn some advanced features such as Pivot Tables, Charting, Tables, Sorting, Filtering and Functions.</p>
 <p>The goal of this course is to provide a deeper understanding of Excel and its intricacies and a new ability to use it efficiently producing the best solutions for your projects.</p><h3>What you Will Learn</h3> 
 <p>You'll learn how to:</p> 
 <ul> 
 <li>Use functions like IF, AVERAGE, SUMIF, SUMIFS, SUMPRODUCT, INDEX, MATCH, CHOOSE, DATE, and many more</li> 
 <li>Create meaningful charts</li> 
 <li>Use pivot tables</li> 
 <li>Use Conditional Formatting, Data Validation</li> 
 <li>Take advantage of using Named ranges, do sorting, filtering, tables</li> 
 </ul><section>
                    <h3>Getting Started</h3> 
 <ul> 
 <li>The building blocks of Excel, built-in functions, will be examined</li> 
 <li>The basics of formatting your data will be examined</li> 
 <li>Shortcuts and data manipulation will be explored</li> 
 <li>Built-in features like those mentioned in the 'What you will learn' section above will be explored in detail</li> 
 </ul> 
 <p>Excel Functions - VLOOKUP, IF, INDEX, MATCH, CHOOSE, SUMIF, SUMIFS, SUMPRODUCT, DATE, so many more</p> 
 <h3>Using Named ranges, Data Validation, Sorting, and Filtering</h3> 
 <ul> 
 <li>Learn the Name manager;</li> 
 <li>Learn the difference between local and global names;</li> 
 <li>Ensure correct access to linked workbooks;</li> 
 <li>Ensure data accuracy;</li> 
 <li>Learn how to use cascading data validation (for example, once a user chooses 'cars', another cell allows only Ford, Toyota, etc.);</li> 
 <li>Sorting by more than 3 fields;</li> 
 <li>Filtering by font, pattern, or value;</li> 
 <li>See your data based on things like dates in the 3rd quarter, or fields where quantity x price is greater than some fixed value</li> 
 </ul> 
 <h3>Conditional formatting and data formatting</h3> 
 <ul> 
 <li>Make relevant data stand out</li> 
 <li>Isolate highs and lows</li> 
 <li>Make error cells invisible</li> 
 <li>Learn about Data bars, Icon sets, and Color scales</li> 
 <li>Highlight differences between worksheets</li> 
 <li>Learn all the codes in the Format/Number list</li> 
 <li>Using cell Styles</li> 
 <li>Learn all about alignment, protection, borders, colors and more</li> 
 </ul> 
 <h3>Pivot Tables</h3> 
 <ul> 
 <li>Learn how to summarize large amounts of data with a few clicks</li> 
 <li>Learn various ways of presenting the data</li> 
 <li>Learn the various pivot table tools</li> 
 <li>Learn how to customize and format a pivot table to suit your needs</li> 
 <li>Learn how to group data</li> 
 <li>Learn how to use the various options to present your data</li> 
 </ul> 
 <h3>Charts</h3> 
 <ul> 
 <li>Learn how to create a chart with one keystroke!</li> 
 <li>Learn the 11 types of built-in charts</li> 
 <li>Learn how to create a chart with one keystroke!</li> 
 <li>Learn how to customize the charts to make the information tell the right story</li> 
 <li>Learn how to use the design, layout, and formatting available to charts in Excel 2007</li> 
 <li>Learn embedded charts versus chart sheets</li> 
 <li>Learn how to use modify all the pieces of a chart</li> 
 </ul> 
 <h3>Array formulas</h3> 
 <ul> 
 <li>Learn how to use the most powerful formulas in Excel</li> 
 <li>Learn how to combine many formulas into one compact array-formula</li> 
 <li>Learn the real power of these formulas and why regular formulas can't do the job</li> 
 <li>Learn how to use built-in array formulas, like TREND or TRANSPOSE</li> 
 </ul>


                </section>

IIL Europe Ltd

Microsoft Excel in Depth: In-House Training

<p><strong>Course Objectives</strong></p><p>At the end of this course you will be able to:</p><ul><li>Work with advanced lookup and reference functions</li><li>Create macros to automate common tasks</li><li>Use advanced techniques to analyse data</li><li>Create PivotTables and PivotCharts</li><li>Work with data validation tools</li><li>Import and export data</li></ul><p>'</p><p><em><strong>Customer Feedback</strong></em></p><ul><li><strong>Best Training Ever!</strong></li><li>Just finished a bespoke 1-1 training course in Excel Advanced, Macros &amp; VBA. Pedro is an excellent trainer, imparting his skills and knowledge in the best way - appropriately to audience skills, knowledge and ability. Pedro is always approachable, encouraging and supportive, giving delegates the optimum learning environment. I would not hesitate to recommend Pedro as a trainer, whatever your level of ability.</li></ul><ul><li>Amanda Morris - Treasury &amp; Systems Accountant at Reall - Real Equity for All</li></ul><ul><li><p><strong>The course was very interesting and engaging and will definitely be put to use. The trainer was very helpful and charismatic.</strong></p></li><li>Marving Lopez - AM Best Europe</li></ul><ul><li><strong>Pedro was excellent. Very knowledgeable, clear and great rapport with class.</strong></li><li>Darren Barkey - Direct Wines</li></ul><ul><li><strong>Great content and learnt a lot. Really enjoyable :)</strong></li><li>Kristie-Lee Ryan - Stirling Ackroyd</li></ul><p>1 year email support service</p><p>Take a closer look at the <strong>consistent excellent feedback from our growing corporate clients</strong> visiting our site <em><strong>ms-officetraining co uk</strong></em></p><p>With more than 20 years experience, we deliver courses on all levels of the Desktop version of <strong>Microsoft Office and Office 365</strong>; ranging from Beginner, Intermediate, Advanced to the VBA level.</p><p>Our trainers are Microsoft certified professionals with a proven track record with several years experience in delivering<strong> public, one to one, tailored and bespoke courses.</strong></p><ul><li><strong>Our competitive rates <strong>start from £550.00 per day of training</strong></strong></li></ul><p><strong><strong>Tailored training courses:</strong></strong></p><p>You can choose to run the course exactly as they are outlined by us or we can customise it so that it meets your specific needs. A tailored or bespoke course will follow the standard outline but may be adapted to your specific organisational needs.</p><p>Please visit our site (ms-officetraining co uk) to get a feel of the excellent feedback our courses have had and look at other courses you might be interested in.</p><p><strong>Advanced Functions</strong></p><ul><li>COUNT, COUNTA, COUNTIF, COUNTBLANK, SUMIF, SUBTOTAL</li><li>IF, OR, AND, IFERROR</li><li>VLOOKUP to lookup Exact Values and Approximate values</li><li>MATCH, INDIRECT, ROW/COLUMN, INDEX, OFFSET</li></ul><p><strong>Analysing Data</strong></p><ul><li>PMT function to calculate a monthly payment of a loan</li><li>What If Analysis using Goal Seek</li><li>Use scenarios to consider many different variables</li><li>Using Solver Add-in to optimize variables</li></ul><p><strong>PivotTables</strong></p><ul><li>Create a PivotTable to analyse worksheet data</li><li>Add or remove fields in a PivotTable</li><li>Change the data source for a PivotTable</li><li>Working with external data sources</li><li>Using different Statistical Functions</li><li>Calculate a Running Total, % of Grant Total, Difference From…</li><li>Using the Slicer and Timeline to filter the PivotTable</li><li>Using Filters in a PivotTable</li><li>Group by Date, Auto Group by ranges of values, Custom Group</li><li>Create a PivotChart</li><li>The GETPIVOTDATA function</li></ul><p><strong>Formula auditing</strong></p><ul><li>Precedents and dependents</li><li>Error checking</li><li>Watch a formula and its result by using the Watch Window</li><li>Evaluate a nested formula one step at a time</li></ul><p><strong>Data Validation</strong></p><ul><li>Number Validation</li><li>Data List Validation</li><li>Message Prompts and Alerts</li><li>Conditional Data Validation</li><li>Data Validation Errors</li></ul><p><strong>Consolidation</strong></p><ul><li>Consolidate data by position</li><li>Consolidate data by category</li><li>Use a formula to consolidate data</li></ul><p><strong>Outline (group) data in a worksheet</strong></p><ul><li>Create an outline of rows</li><li>Create an outline of columns</li><li>Copy outlined data</li><li>Hide or remove an outline</li></ul><p><strong>Connect external data to your workbook</strong></p><ul><li>Using the Power Query Editor to import data</li><li>From Text and CSV, From Access, From Web, From another Workbook</li><li>Using the Power Query Editor to; Transform your data by Selecting which fields to import, by Splitting Columns, Changing Data Type and more.</li><li>Deleting Applied Steps</li><li>Refreshing your data</li></ul><p><strong>Working with Form Controls; Buttons, Option Buttons and Scroll Bars</strong></p><p><strong>Introduction to Macros</strong></p><ul><li>Change Macro Security settings</li><li>How to Record a macro</li><li>Some Macro Examples</li><li>Delete a macro</li><li>Edit the macro to view the VBA code</li><li>Copy part of a macro to create another macro</li><li>Assign a macro to a button</li></ul><h2>
        
            Who is this course for?
        
        <div>Who is this course for?</div>
    </h2>

                        <div id="who_is_this_course_for">
                            <p>This course is intended to end users who want to develop their skills so they can use advanced techniques to analyse extensive and complex datasets in Excel and to automate simple tasks with the use of Macros.</p>
                        </div><h2>
        
            Requirements
        
        <div>Requirements</div>
    </h2>

                        <div id="requirements">
                            <p>Preferably, delegates should have attended the Excel Intermediate course.</p>
                        </div><h2>
        
            Career path
        
        <div>Career path</div>
    </h2>

                        <div id="career_path">
                            <p>Excel know-how can instantly increase your job prospects as well as your salary.</p><p>80 percent of job openings require spreadsheet and word-processing software skills</p>
                        </div><h2>
        
            Certificates
        
        <div>Certificates</div>
    </h2>

                        <div id="optional_extras">
                                    <h4>Certificate of completion</h4>
        <p>
            Digital certificate -
            Included
        </p>

                        </div>

Microsoft Excel Advanced - In-company

Horsham

<div data-section-id="1695385309833" style="color: rgb(89, 89, 89); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(89, 89, 89);"><section data-reveal-event="" data-reveal-offset="" data-reveal-units="seconds" style="color: rgb(255, 255, 255); box-sizing: border-box;" fr-original-style=" color: rgb(255, 255, 255);"><div data-reveal-event="" data-reveal-offset="" data-reveal-units="seconds" fr-original-style="" style="box-sizing: border-box;"><div data-aos="fade-up" data-aos-delay="0" data-aos-duration="1500" fr-original-style="" style="box-sizing: border-box;"><p id="isPasted" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Learn how to work with and connect multiple data sets to effectively analyse and report on data.</p></div></div></section></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><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;"><div data-section-id="1695042071629" style="color: rgb(89, 89, 89); box-sizing: border-box;" fr-original-style=" color: rgb(89, 89, 89);"><section data-reveal-event="" data-reveal-offset="" data-reveal-units="seconds" fr-original-style="" style="box-sizing: border-box;"><div data-reveal-event="" data-reveal-offset="" data-reveal-units="seconds" fr-original-style="" style="box-sizing: border-box;"><div data-aos="fade-up" data-aos-delay="500" data-aos-duration="1500" fr-original-style="" style="box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></div><div data-aos="fade-up" data-aos-delay="500" data-aos-duration="1500" fr-original-style="" style="box-sizing: border-box;"><img src="https://kajabi-storefronts-production.kajabi-cdn.com/kajabi-storefronts-production/file-uploads/themes/2153291274/settings_images/77df68e-28e4-057f-41d6-ca1d3577146_Course_Overview_Icon.png" alt="" style="width: 80px; cursor: pointer; padding: 0px 1px; user-select: none; max-width: 100%; position: relative; box-sizing: border-box;" fr-original-style="width: 80px;" fr-original-class="fr-draggable"></div></div><h3 style="color: rgb(0, 0, 0); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(0, 0, 0);">Course overview</h3><p style="color: rgb(89, 89, 89); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(89, 89, 89);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Duration:&nbsp;1 day (6.5 hours)</strong></p><p style="color: rgb(89, 89, 89); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(89, 89, 89);">Within Excel you have some powerful features to enable you to connect and analyse multiple data sources. Power Query enables you to import and manipulate your data, Power Pivot enables you to connect multiple data sources and create pivot tables and pivot charts from them.</p><p style="color: rgb(89, 89, 89); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(89, 89, 89);">This course is an introduction to Power Query and Power Pivot in Excel to get you started on creating a powerful reporting capability.</p><p style="color: rgb(89, 89, 89); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(89, 89, 89);">Knowledge of working with Excel workbooks and relational databases would be an advantage.</p><div data-reveal-event="" data-reveal-offset="" data-reveal-units="seconds" fr-original-style="" style="box-sizing: border-box;"><div data-aos="fade-up" data-aos-delay="500" data-aos-duration="1500" fr-original-style="" style="box-sizing: border-box;"><p style="color: rgb(89, 89, 89); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(89, 89, 89);"><br fr-original-style="" style="box-sizing: border-box;"></p></div></div></section></div><div data-section-id="1695042071630" style="color: rgb(89, 89, 89); box-sizing: border-box;" fr-original-style=" color: rgb(89, 89, 89);"><section data-reveal-event="" data-reveal-offset="" data-reveal-units="seconds" fr-original-style="" style="box-sizing: border-box;"><div data-reveal-event="" data-reveal-offset="" data-reveal-units="seconds" fr-original-style="" style="box-sizing: border-box;"><div data-aos="fade-up" data-aos-delay="0" data-aos-duration="1500" fr-original-style="" style="box-sizing: border-box;"><img src="https://kajabi-storefronts-production.kajabi-cdn.com/kajabi-storefronts-production/file-uploads/themes/2153291274/settings_images/8ba0826-4fb5-333c-0ea4-28c13064336b_Objectives_Icon.png" alt="" style="width: 80px; cursor: pointer; padding: 0px 1px; user-select: none; max-width: 100%; position: relative; box-sizing: border-box;" fr-original-style="width: 80px;" fr-original-class="fr-draggable"><br fr-original-style="" style="box-sizing: border-box;"></div></div><div data-section-id="1694266245578" style="color: rgb(89, 89, 89); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(89, 89, 89);"><section data-reveal-event="" data-reveal-offset="" data-reveal-units="seconds" fr-original-style="" style="box-sizing: border-box;"><div data-reveal-event="" data-reveal-offset="" data-reveal-units="seconds" fr-original-style="" style="box-sizing: border-box;"><div data-aos="fade-up" data-aos-delay="0" data-aos-duration="1500" fr-original-style="" style="box-sizing: border-box;"><h3 style="color: rgb(0, 0, 0); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(0, 0, 0);">Objectives</h3><p style="color: rgb(89, 89, 89); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(89, 89, 89);">By the end of the course you will be able to:</p><ul style="color: rgb(89, 89, 89); box-sizing: border-box;" fr-original-style=" color: rgb(89, 89, 89);"><li fr-original-style="" style="box-sizing: border-box;">Import data from multiple data sources</li><li fr-original-style="" style="box-sizing: border-box;">Edit and transform data before importing</li><li fr-original-style="" style="box-sizing: border-box;">Add extra columns of data</li><li fr-original-style="" style="box-sizing: border-box;">Append data</li><li fr-original-style="" style="box-sizing: border-box;">Merge data from other tables</li><li fr-original-style="" style="box-sizing: border-box;">Create data models</li><li fr-original-style="" style="box-sizing: border-box;">Build data relationships</li><li fr-original-style="" style="box-sizing: border-box;">Build Pivot Tables</li><li fr-original-style="" style="box-sizing: border-box;">Build Pivot Charts</li><li fr-original-style="" style="box-sizing: border-box;">Use Slicers and Timeline Filters</li></ul></div></div></section></div><div data-section-id="1694266514989" style="color: rgb(89, 89, 89); box-sizing: border-box;" fr-original-style=" color: rgb(89, 89, 89);"><section data-reveal-event="" data-reveal-offset="" data-reveal-units="seconds" fr-original-style="" style="box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></section></div><div fr-original-style="" style="box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></div><p style="color: rgb(89, 89, 89); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(89, 89, 89);"><img src="https://kajabi-storefronts-production.kajabi-cdn.com/kajabi-storefronts-production/file-uploads/themes/2153291274/settings_images/cbd24e-e374-8bf2-2a2e-66ae236e51d4_Content_Icon.png" alt="" style="width: 80px; cursor: pointer; padding: 0px 1px; user-select: none; max-width: 100%; position: relative; box-sizing: border-box;" fr-original-style="width: 80px;" fr-original-class="fr-draggable"></p></section></div><div data-section-id="1695042071631" style="color: rgb(89, 89, 89); box-sizing: border-box;" fr-original-style=" color: rgb(89, 89, 89);"><section data-reveal-event="" data-reveal-offset="" data-reveal-units="seconds" fr-original-style="" style="box-sizing: border-box;"><div data-reveal-event="" data-reveal-offset="" data-reveal-units="seconds" fr-original-style="" style="box-sizing: border-box;"><div data-section-id="1695048787156" style="color: rgb(89, 89, 89); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(89, 89, 89);"><section data-reveal-event="" data-reveal-offset="" data-reveal-units="seconds" fr-original-style="" style="box-sizing: border-box;"><div data-reveal-event="" data-reveal-offset="" data-reveal-units="seconds" fr-original-style="" style="box-sizing: border-box;"><div data-aos="fade-up" data-aos-delay="0" data-aos-duration="1500" fr-original-style="" style="box-sizing: border-box;"><h3 style="color: rgb(0, 0, 0); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(0, 0, 0);">Content</h3><div data-section-id="1695060919750" style="color: rgb(89, 89, 89); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(89, 89, 89);"><section data-reveal-event="" data-reveal-offset="" data-reveal-units="seconds" fr-original-style="" style="box-sizing: border-box;"><div data-reveal-event="" data-reveal-offset="" data-reveal-units="seconds" fr-original-style="" style="box-sizing: border-box;"><div data-aos="fade-up" data-aos-delay="0" data-aos-duration="1500" fr-original-style="" style="box-sizing: border-box;"><h5 style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">Importing data&nbsp;</h5><ul style="color: rgb(89, 89, 89); box-sizing: border-box;" fr-original-style=" color: rgb(89, 89, 89);"><li fr-original-style="" style="box-sizing: border-box;">Data sources</li><li fr-original-style="" style="box-sizing: border-box;">Importing data</li></ul><h5 style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">Transforming data &nbsp;</h5><ul style="color: rgb(89, 89, 89); box-sizing: border-box;" fr-original-style=" color: rgb(89, 89, 89);"><li fr-original-style="" style="box-sizing: border-box;">Editing your data</li><li fr-original-style="" style="box-sizing: border-box;">Setting data types</li><li fr-original-style="" style="box-sizing: border-box;">Removing columns/rows</li><li fr-original-style="" style="box-sizing: border-box;">Choosing columns to keep</li><li fr-original-style="" style="box-sizing: border-box;">Setting header rows</li><li fr-original-style="" style="box-sizing: border-box;">Splitting columns</li></ul><h5 style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">Appending queries&nbsp;</h5><ul style="color: rgb(89, 89, 89); box-sizing: border-box;" fr-original-style=" color: rgb(89, 89, 89);"><li fr-original-style="" style="box-sizing: border-box;">Appending data from other tables</li></ul><h5 style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">Adding text&nbsp;</h5><ul style="color: rgb(89, 89, 89); box-sizing: border-box;" fr-original-style=" color: rgb(89, 89, 89);"><li fr-original-style="" style="box-sizing: border-box;">Columns from example</li><li fr-original-style="" style="box-sizing: border-box;">Custom columns</li><li fr-original-style="" style="box-sizing: border-box;">Conditional columns</li></ul><h5 style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">Merge queries&nbsp;</h5><ul style="color: rgb(89, 89, 89); box-sizing: border-box;" fr-original-style=" color: rgb(89, 89, 89);"><li fr-original-style="" style="box-sizing: border-box;">Setting up and using merge queries</li><li fr-original-style="" style="box-sizing: border-box;">Merging in columns of data</li></ul><h5 style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">Creating a data model&nbsp;</h5><ul style="color: rgb(89, 89, 89); box-sizing: border-box;" fr-original-style=" color: rgb(89, 89, 89);"><li fr-original-style="" style="box-sizing: border-box;">The data model</li><li fr-original-style="" style="box-sizing: border-box;">Multiple data tables</li><li fr-original-style="" style="box-sizing: border-box;">Connecting tables</li><li fr-original-style="" style="box-sizing: border-box;">Building relationships</li><li fr-original-style="" style="box-sizing: border-box;">Relationship types</li><li fr-original-style="" style="box-sizing: border-box;">Building visuals from multiple tables</li></ul><h5 style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">Analysing information using pivot tables</h5><ul style="color: rgb(89, 89, 89); box-sizing: border-box;" fr-original-style=" color: rgb(89, 89, 89);"><li fr-original-style="" style="box-sizing: border-box;">Creating and modifying a Pivot Table</li><li fr-original-style="" style="box-sizing: border-box;">Recalculating the Pivot Table</li><li fr-original-style="" style="box-sizing: border-box;">Filtering the Pivot Table</li><li fr-original-style="" style="box-sizing: border-box;">Searching the Pivot Table</li><li fr-original-style="" style="box-sizing: border-box;">Drilling down to underlying data</li><li fr-original-style="" style="box-sizing: border-box;">Customising field names</li><li fr-original-style="" style="box-sizing: border-box;">Changing field formatting</li></ul><h5 style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">Pivot charts, slices and timelines</h5><ul style="color: rgb(89, 89, 89); box-sizing: border-box;" fr-original-style=" color: rgb(89, 89, 89);"><li fr-original-style="" style="box-sizing: border-box;">Creating Pivot Charts</li><li fr-original-style="" style="box-sizing: border-box;">Adding and using Slicers</li></ul></div></div></section></div><div data-section-id="1695060919751" style="color: rgb(89, 89, 89); box-sizing: border-box;" fr-original-style=" color: rgb(89, 89, 89);"><section data-reveal-event="" data-reveal-offset="" data-reveal-units="seconds" style="color: rgb(255, 255, 255); box-sizing: border-box;" fr-original-style=" color: rgb(255, 255, 255);"><br fr-original-style="" style="box-sizing: border-box;"></section></div></div></div></section></div><div data-section-id="1695048787157" style="color: rgb(89, 89, 89); box-sizing: border-box;" fr-original-style=" color: rgb(89, 89, 89);"><br fr-original-style="" style="box-sizing: border-box;"></div></div></section></div>

Underscore Group

Excel Power Query and Power Pivot

Elevate your auditing expertise and lead the way in quality management with our ISO 9001:2015 Lead Auditor course, certified by CQI and IRCA. This comprehensive program is designed for professionals seeking to conduct first, second, and third-party audits of Quality Management Systems (QMS) against the ISO 9001:2015 standard.
Our course provides in-depth training on the principles and practices of auditing, equipping you with the knowledge and skills to effectively lead audit teams and assess the conformance and effectiveness of QMS in organizations. You will learn how to plan, conduct, report, and follow up on audits in compliance with ISO 19011 guidelines and ISO/IEC 17021 standards.
Key Features of the Course:
Certified Expertise: Achieve a globally recognized certification from CQI and IRCA, enhancing your professional credibility and career prospects.
Experienced Instructors: Learn from industry experts with extensive experience in quality management and auditing, who provide real-world insights and practical guidance.
Interactive Learning: Engage in hands-on exercises, case studies, and role-play scenarios that simulate real auditing situations, ensuring that you can apply what you learn directly to your work.
Comprehensive Curriculum: Cover all aspects of the ISO 9001:2015 standard, audit principles, and techniques, as well as risk-based thinking and the process approach.
Career Advancement: This course is ideal for those aspiring to become lead auditors, quality managers, or consultants, offering a pathway to new opportunities and enhanced professional status.
Upon successful completion of the course and examination, you will be awarded the prestigious CQI and IRCA certification, recognized globally as a mark of excellence in auditing. This certification will enable you to conduct audits for certification bodies and help organizations achieve compliance and continual improvement.
Enroll in our ISO 9001:2015 Lead Auditor course today and take the next step in your journey to becoming a leader in quality management.

Quality Management System

ISO 9001

Quality Management

Quality Assurance

Become a certified ISO 9001:2015 Lead Auditor with our CQI and IRCA accredited course. Gain the skills to lead quality management audits and enhance your career. Enroll now!

ISO 9001:2015 Lead Auditor (CQI and IRCA Certified)

Burnley

<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;">Have you ever wondered what is Reiki and would like to know more, then this course is for you if you would like to learn more about Reiki</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 Reiki Level One course is for you if you have heard a lot about Reiki and are interested in learning more about Reiki and is an introductory course on how to use Reiki healing techniques.</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 is where you begin and my online course will teach you all you need to know to get you started with using Reiki on yourself and it is very simple to learn and to use. It is a gentle hands-on healing technique, which uses healing energy to treat any physical or emotional concerns.</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);">Reiki is a helpful self-development technique for anyone wanting to learn more about reiki and how to enjoy the benefits of a healing treatment.</p><p id="isPasted" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">The Reiki One course is taught live on line using Zoom.</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;">What will I learn on 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);">What is Reiki and its history?</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);">The Principles of Reiki</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);">Auras and chakras</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);">Preparation for your initiation to the Reiki energy or attunement</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);">What does the Reiki energy feel like?</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);">21 day cleansing process</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);">How to practise self-healing on yourself</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);">Reiki and its uses with other therapies</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);">Your own Reiki Lineage</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);">Question and answer session&nbsp;</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);">You will be initiated to the Reiki energy by an attunement and receive a full instruction manual and your course certificate will be awarded to you at the end of the 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);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">I am a Reiki Master and teacher and I am one of the few traditionally trained Reiki Masters in the UK who have been trained by international best-selling Reiki author Penelope Quest. My teaching methods use traditional Reiki techniques perfected over many years and you can be assured of my support during and after your 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);">The course can be booked online here and you will receive instructions on how to access the course.</p><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);">I look forward to meeting you and sharing my knowledge and experience of Reiki with you.</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;">What this course offers you:</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);">Individual Support &ndash; During and after your course, if you have any questions</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);">Practical Experience &ndash; Step by step training is given so that you can gain valuable experience using Reiki on yourself</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);">Energy Perception &ndash; You will be taught to develop skills of energy perception and learn how to interpret the Reiki by what you sense and feel</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);">Personal Growth &ndash; You will discover for yourself the gift of Reiki healing and have increased confidence to use it for self-healing</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;">Testimonials:- What other students who have attended my courses are saying &nbsp;</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);">Level One 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);">&ldquo;I enjoyed this course and Margaret is a great teacher and her calming voice explains everything clearly&rdquo;. (Anne-Marie M)</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);">&ldquo;This is a very informative course. It gave me everything I needed to know to start working with the Reiki energy. (Sally R.)</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);">&ldquo;This course is excellent!&rdquo; (Phil T)</p>

Margaret Cook - Learn More About Reiki

Energy Healing

Reiki

Reiki Healer

I am a Reiki Teacher in Manchester and one of the few traditionally trained Reiki Masters in the UK who have been trained by international best-selling Reiki author Penelope Quest. My teaching methods use traditional Reiki techniques perfected over many years and you can be assured of my support during and after your course. I teach all three levels of Reiki courses, level 1 reiki. level 2 reiki and reiki master level 3

Reiki Level One Online Course - New to Reiki this is for you

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



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


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


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


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


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


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


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

Bayfield Training

Financial Modelling & Analysis

Financial Modelling

Professional Development

Property & Real Estate Photography

Continuous Professional Development (CPD)

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

Real Estate Analyst (Investment Cash Flow Modelling in Excel)

In-Person 

Virtual

Bromley

<p id="isPasted" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">MJ Electrical Training has the largest centre network in the UK, with City &amp; Guilds exams available every week.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Final exams for the 18th Edition Wiring Regulations, Part P Building Regulations, <strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">ECS Health &amp; Safety Courses&nbsp;</strong>and CSCS Green Labourers Health &amp; Safety in a Construction Environment are available weekly in Kent.</p><p style="text-align: center; color: var(--text); font-size: var(--font-size); box-sizing: border-box;" fr-original-style="text-align: center;"><a href="https://mjelectricaltraining.co.uk/exam-venue/safety-passport/" 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="font-size: 24px; box-sizing: border-box;" fr-original-style="font-size: 24px;">Learn More @ MJ Electrical Training &gt;&gt;</span></strong></a></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;">Take the First Step Towards a Successful Career in the Electrical Industry with the SPA Health &amp; Safety Core Day</strong></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Are you ready to kickstart or advance your career in the electrical industry? Obtaining the ECS Labourer Card is a crucial milestone that demonstrates your competence in assisting electricians in their installations. This card not only opens doors for new opportunities but also ensures that you are recognized as a qualified professional in the field. One of the most efficient ways to qualify for this essential certification is by completing the SPA Health &amp; Safety Core Day, offered by MJ Electrical Training.</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;">Why is the ECS Labourer Card Important?</strong></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">The ECS Labourer Card is a must-have for anyone looking to start or further their career in the electrical industry. It signifies that you are competent to assist electricians in their electrical installations under supervision, ensuring safety and efficiency on the job. While advanced qualifications like the JIB Gold Card require extensive training and experience, the ECS Labourer Card provides a valuable entry point for newcomers, trainees, and those aiming to become fully qualified electricians.</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;">Pathways to the ECS Labourer Card</strong></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">MJ Electrical Training outlines two primary routes to gaining the ECS Labourer Card, depending on your previous qualifications and experience:</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">1.&nbsp;<strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Route One</strong>: If you already hold approved JIB theory qualifications, you may be exempt from additional health and safety courses.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">2.&nbsp;<strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Route Two</strong>: If you do not hold these qualifications, you will need to complete an ECS-approved Health &amp; Safety Course. The SPA Health &amp; Safety Core Day is one of the most accessible and comprehensive options available.</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;">SPA Health &amp; Safety Core Day: Your Gateway to ECS Health &amp; Safety Exemption</strong></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">The SPA Health &amp; Safety Core Day, offered by MJ Electrical Training for just &pound;174.00 (including VAT), is a one-day online face-to-face training course delivered via Teams or Zoom. Available every week, this course is designed to provide you with the essential health and safety knowledge required for the electrical industry. Completing this course will exempt you from the ECS Health &amp; Safety Assessment, streamlining your path to obtaining the ECS Labourer Card.</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;">Who Should Take This Course?</strong></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">The SPA Health &amp; Safety Core Day is ideal for anyone looking to gain an ECS Labourers Card or complete an ECS Health &amp; Safety Exemption:</p><ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">Practising electricians looking to formalise their safety training.</li><li fr-original-style="" style="box-sizing: border-box;">Trainees and apprentices in the electrical industry.</li><li fr-original-style="" style="box-sizing: border-box;">Associated trade professionals such as electrical engineers, contracts managers, designers, consultants, surveyors, builders, and plumbers.</li></ul><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;">Benefits of the SPA Health &amp; Safety Core Day</strong></p><ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;"><b fr-original-style="" style="box-sizing: border-box;">Comprehensive Training</b>: The course covers all necessary aspects of health and safety in the electrical industry, ensuring you are well-prepared for your role.</li><li fr-original-style="" style="box-sizing: border-box;"><b fr-original-style="" style="box-sizing: border-box;">Flexible Learning</b>: Delivered online, you can complete the training from the comfort of your home or office, making it convenient and accessible.</li><li fr-original-style="" style="box-sizing: border-box;"><b fr-original-style="" style="box-sizing: border-box;">Certification</b>: Upon completion, you will receive a certificate that can be used to evidence you meet the H&amp;S requirements for the ECS Labourer Card.</li></ul><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;">Further Opportunities with the ECS Labourer Card</strong></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Obtaining the ECS Labourer Card allows you to progress into employment and onto further qualifications, such as:</p><ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">City &amp; Guilds Level 2 Certificate in Fundamental Inspection, Testing and Initial Verification (2392-10)</li><li fr-original-style="" style="box-sizing: border-box;">City &amp; Guilds Level 3 Certificate in Building Regulations for Electrical Installation Contractors in Dwellings (2393-10)</li><li fr-original-style="" style="box-sizing: border-box;">City &amp; Guilds Level 3 Award in Initial Verification (2391-50)</li><li fr-original-style="" style="box-sizing: border-box;">City &amp; Guilds Level 3 Award in the Periodic Inspection (2391-51)</li><li fr-original-style="" style="box-sizing: border-box;">City &amp; Guilds Level 3 Award in Inspection and Testing (2391-52)</li><li fr-original-style="" style="box-sizing: border-box;">City &amp; Guilds Level 4 Higher Professional Diploma in Building Services Engineering (4467-04)</li></ul><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">To qualify for the ECS Labourer Card, not only must you have an ECS-approved H&amp;S course, but you must also demonstrate active engagement in the electrotechnical sector. This proof can be provided through:</p><ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">An application by your employer via the ECS Employer Portal.</li><li fr-original-style="" style="box-sizing: border-box;">A written reference from your current employer on company-headed paper, stating your role as an electrical labourer, start date, and signed by an authorised person.</li><li fr-original-style="" style="box-sizing: border-box;">Confirmation of your contract duration from an agency if you are working through one.</li><li fr-original-style="" style="box-sizing: border-box;">Documented proof of enrolment in a related electrical course from your educational institution.</li></ul><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Additionally, you can submit an offer letter, employment contract, or recent payslip from a reputable business within the industry. These documents validate your eligibility and expertise, completing the ECS Labourer Card application process.</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;">Verify and Stay Updated</strong></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">While every effort is made to provide accurate and up-to-date information, it is essential to verify the current application criteria by visiting the <a href="https://www.ecscard.org.uk/" fr-original-style="" style="user-select: auto; font-size: var(--font-size); box-sizing: border-box; cursor: pointer; text-decoration: inherit;">ECS Website</a>. Keeping informed ensures that you meet all requirements and avoid any potential issues during the application process.</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;">Conclusion</strong></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Taking the SPA Health &amp; Safety Core Day is a strategic move for anyone looking to advance their career in the electrical industry. Not only does it provide essential health and safety training, but it also qualifies you for the ECS Labourer Card, a vital certification for gaining employment and furthering your career.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Enrol in the SPA Health &amp; Safety Core Day with MJ Electrical Training today. Equip yourself with the knowledge and certification needed to excel in the dynamic and rewarding field of electrical installations. Your journey to becoming a fully qualified electrician starts here!</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">&nbsp;</p>

MJ Electrical Training 

Construction Industry Scheme (CIS)

City & Guilds

Health & Safety

Electrical Testing

Wiring Regulations

Electrical Installation

Electrical Inspection & Testing

ECS Health & Safety Course with MJ Electrical Training. Available every week, use this course to complete the application process when applying for an ECS Labourers Card. 

ECS Card Health & Safety Course Kent

<p id="isPasted" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">MJ Electrical Training has the largest centre network in the UK, with City &amp; Guilds exams available every week.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Final exams for the 18th Edition Wiring Regulations, Part P Building Regulations, <strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">ECS Health &amp; Safety Courses&nbsp;</strong>and CSCS Green Labourers Health &amp; Safety in a Construction Environment are available weekly.</p><p style="text-align: center; color: var(--text); font-size: var(--font-size); box-sizing: border-box;" fr-original-style="text-align: center;"><a href="https://mjelectricaltraining.co.uk/exam-venue/safety-passport/" 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="font-size: 24px; box-sizing: border-box;" fr-original-style="font-size: 24px;">Learn More @ MJ Electrical Training &gt;&gt;</span></strong></a></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;">Take the First Step Towards a Successful Career in the Electrical Industry with the SPA Health &amp; Safety Core Day</strong></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Are you ready to kickstart or advance your career in the electrical industry? Obtaining the ECS Labourer Card is a crucial milestone that demonstrates your competence in assisting electricians in their installations. This card not only opens doors for new opportunities but also ensures that you are recognized as a qualified professional in the field. One of the most efficient ways to qualify for this essential certification is by completing the SPA Health &amp; Safety Core Day, offered by MJ Electrical Training.</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;">Why is the ECS Labourer Card Important?</strong></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">The ECS Labourer Card is a must-have for anyone looking to start or further their career in the electrical industry. It signifies that you are competent to assist electricians in their electrical installations under supervision, ensuring safety and efficiency on the job. While advanced qualifications like the JIB Gold Card require extensive training and experience, the ECS Labourer Card provides a valuable entry point for newcomers, trainees, and those aiming to become fully qualified electricians.</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;">Pathways to the ECS Labourer Card</strong></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">MJ Electrical Training outlines two primary routes to gaining the ECS Labourer Card, depending on your previous qualifications and experience:</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">1.&nbsp;<strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Route One</strong>: If you already hold approved JIB theory qualifications, you may be exempt from additional health and safety courses.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">2.&nbsp;<strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Route Two</strong>: If you do not hold these qualifications, you will need to complete an ECS-approved Health &amp; Safety Course. The SPA Health &amp; Safety Core Day is one of the most accessible and comprehensive options available.</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;">SPA Health &amp; Safety Core Day: Your Gateway to ECS Health &amp; Safety Exemption</strong></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">The SPA Health &amp; Safety Core Day, offered by MJ Electrical Training for just &pound;174.00 (including VAT), is a one-day online face-to-face training course delivered via Teams or Zoom. Available every week, this course is designed to provide you with the essential health and safety knowledge required for the electrical industry. Completing this course will exempt you from the ECS Health &amp; Safety Assessment, streamlining your path to obtaining the ECS Labourer Card.</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;">Who Should Take This Course?</strong></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">The SPA Health &amp; Safety Core Day is ideal for anyone looking to gain an ECS Labourers Card or complete an ECS Health &amp; Safety Exemption:</p><ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">Practising electricians looking to formalise their safety training.</li><li fr-original-style="" style="box-sizing: border-box;">Trainees and apprentices in the electrical industry.</li><li fr-original-style="" style="box-sizing: border-box;">Associated trade professionals such as electrical engineers, contracts managers, designers, consultants, surveyors, builders, and plumbers.</li></ul><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;">Benefits of the SPA Health &amp; Safety Core Day</strong></p><ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;"><b fr-original-style="" style="box-sizing: border-box;">Comprehensive Training</b>: The course covers all necessary aspects of health and safety in the electrical industry, ensuring you are well-prepared for your role.</li><li fr-original-style="" style="box-sizing: border-box;"><b fr-original-style="" style="box-sizing: border-box;">Flexible Learning</b>: Delivered online, you can complete the training from the comfort of your home or office, making it convenient and accessible.</li><li fr-original-style="" style="box-sizing: border-box;"><b fr-original-style="" style="box-sizing: border-box;">Certification</b>: Upon completion, you will receive a certificate that can be used to evidence you meet the H&amp;S requirements for the ECS Labourer Card.</li></ul><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;">Further Opportunities with the ECS Labourer Card</strong></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Obtaining the ECS Labourer Card allows you to progress into employment and onto further qualifications, such as:</p><ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">City &amp; Guilds Level 2 Certificate in Fundamental Inspection, Testing and Initial Verification (2392-10)</li><li fr-original-style="" style="box-sizing: border-box;">City &amp; Guilds Level 3 Certificate in Building Regulations for Electrical Installation Contractors in Dwellings (2393-10)</li><li fr-original-style="" style="box-sizing: border-box;">City &amp; Guilds Level 3 Award in Initial Verification (2391-50)</li><li fr-original-style="" style="box-sizing: border-box;">City &amp; Guilds Level 3 Award in the Periodic Inspection (2391-51)</li><li fr-original-style="" style="box-sizing: border-box;">City &amp; Guilds Level 3 Award in Inspection and Testing (2391-52)</li><li fr-original-style="" style="box-sizing: border-box;">City &amp; Guilds Level 4 Higher Professional Diploma in Building Services Engineering (4467-04)</li></ul><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">To qualify for the ECS Labourer Card, not only must you have an ECS-approved H&amp;S course, but you must also demonstrate active engagement in the electrotechnical sector. This proof can be provided through:</p><ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">An application by your employer via the ECS Employer Portal.</li><li fr-original-style="" style="box-sizing: border-box;">A written reference from your current employer on company-headed paper, stating your role as an electrical labourer, start date, and signed by an authorised person.</li><li fr-original-style="" style="box-sizing: border-box;">Confirmation of your contract duration from an agency if you are working through one.</li><li fr-original-style="" style="box-sizing: border-box;">Documented proof of enrolment in a related electrical course from your educational institution.</li></ul><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Additionally, you can submit an offer letter, employment contract, or recent payslip from a reputable business within the industry. These documents validate your eligibility and expertise, completing the ECS Labourer Card application process.</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;">Verify and Stay Updated</strong></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">While every effort is made to provide accurate and up-to-date information, it is essential to verify the current application criteria by visiting the <a href="https://www.ecscard.org.uk/" fr-original-style="" style="user-select: auto; font-size: var(--font-size); box-sizing: border-box; cursor: pointer; text-decoration: inherit;">ECS Website</a>. Keeping informed ensures that you meet all requirements and avoid any potential issues during the application process.</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;">Conclusion</strong></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Taking the SPA Health &amp; Safety Core Day is a strategic move for anyone looking to advance their career in the electrical industry. Not only does it provide essential health and safety training, but it also qualifies you for the ECS Labourer Card, a vital certification for gaining employment and furthering your career.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Enrol in the SPA Health &amp; Safety Core Day with MJ Electrical Training today. Equip yourself with the knowledge and certification needed to excel in the dynamic and rewarding field of electrical installations. Your journey to becoming a fully qualified electrician starts here!</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">&nbsp;</p>

ECS Card Health & Safety Course Bromley

<p id="isPasted" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">MJ Electrical Training has the largest centre network in the UK, with City &amp; Guilds exams available every week.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Final exams for the 18th Edition Wiring Regulations, Part P Building Regulations, <strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">ECS Health &amp; Safety Courses&nbsp;</strong>and CSCS Green Labourers Health &amp; Safety in a Construction Environment are available weekly in Dover.</p><p style="text-align: center; color: var(--text); font-size: var(--font-size); box-sizing: border-box;" fr-original-style="text-align: center;"><a href="https://mjelectricaltraining.co.uk/exam-venue/safety-passport/" 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="font-size: 24px; box-sizing: border-box;" fr-original-style="font-size: 24px;">Learn More @ MJ Electrical Training &gt;&gt;</span></strong></a></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;">Take the First Step Towards a Successful Career in the Electrical Industry with the SPA Health &amp; Safety Core Day</strong></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Are you ready to kickstart or advance your career in the electrical industry? Obtaining the ECS Labourer Card is a crucial milestone that demonstrates your competence in assisting electricians in their installations. This card not only opens doors for new opportunities but also ensures that you are recognized as a qualified professional in the field. One of the most efficient ways to qualify for this essential certification is by completing the SPA Health &amp; Safety Core Day, offered by MJ Electrical Training.</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;">Why is the ECS Labourer Card Important?</strong></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">The ECS Labourer Card is a must-have for anyone looking to start or further their career in the electrical industry. It signifies that you are competent to assist electricians in their electrical installations under supervision, ensuring safety and efficiency on the job. While advanced qualifications like the JIB Gold Card require extensive training and experience, the ECS Labourer Card provides a valuable entry point for newcomers, trainees, and those aiming to become fully qualified electricians.</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;">Pathways to the ECS Labourer Card</strong></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">MJ Electrical Training outlines two primary routes to gaining the ECS Labourer Card, depending on your previous qualifications and experience:</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">1.&nbsp;<strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Route One</strong>: If you already hold approved JIB theory qualifications, you may be exempt from additional health and safety courses.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">2.&nbsp;<strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Route Two</strong>: If you do not hold these qualifications, you will need to complete an ECS-approved Health &amp; Safety Course. The SPA Health &amp; Safety Core Day is one of the most accessible and comprehensive options available.</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;">SPA Health &amp; Safety Core Day: Your Gateway to ECS Health &amp; Safety Exemption</strong></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">The SPA Health &amp; Safety Core Day, offered by MJ Electrical Training for just &pound;174.00 (including VAT), is a one-day online face-to-face training course delivered via Teams or Zoom. Available every week, this course is designed to provide you with the essential health and safety knowledge required for the electrical industry. Completing this course will exempt you from the ECS Health &amp; Safety Assessment, streamlining your path to obtaining the ECS Labourer Card.</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;">Who Should Take This Course?</strong></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">The SPA Health &amp; Safety Core Day is ideal for anyone looking to gain an ECS Labourers Card or complete an ECS Health &amp; Safety Exemption:</p><ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">Practising electricians looking to formalise their safety training.</li><li fr-original-style="" style="box-sizing: border-box;">Trainees and apprentices in the electrical industry.</li><li fr-original-style="" style="box-sizing: border-box;">Associated trade professionals such as electrical engineers, contracts managers, designers, consultants, surveyors, builders, and plumbers.</li></ul><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;">Benefits of the SPA Health &amp; Safety Core Day</strong></p><ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;"><b fr-original-style="" style="box-sizing: border-box;">Comprehensive Training</b>: The course covers all necessary aspects of health and safety in the electrical industry, ensuring you are well-prepared for your role.</li><li fr-original-style="" style="box-sizing: border-box;"><b fr-original-style="" style="box-sizing: border-box;">Flexible Learning</b>: Delivered online, you can complete the training from the comfort of your home or office, making it convenient and accessible.</li><li fr-original-style="" style="box-sizing: border-box;"><b fr-original-style="" style="box-sizing: border-box;">Certification</b>: Upon completion, you will receive a certificate that can be used to evidence you meet the H&amp;S requirements for the ECS Labourer Card.</li></ul><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;">Further Opportunities with the ECS Labourer Card</strong></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Obtaining the ECS Labourer Card allows you to progress into employment and onto further qualifications, such as:</p><ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">City &amp; Guilds Level 2 Certificate in Fundamental Inspection, Testing and Initial Verification (2392-10)</li><li fr-original-style="" style="box-sizing: border-box;">City &amp; Guilds Level 3 Certificate in Building Regulations for Electrical Installation Contractors in Dwellings (2393-10)</li><li fr-original-style="" style="box-sizing: border-box;">City &amp; Guilds Level 3 Award in Initial Verification (2391-50)</li><li fr-original-style="" style="box-sizing: border-box;">City &amp; Guilds Level 3 Award in the Periodic Inspection (2391-51)</li><li fr-original-style="" style="box-sizing: border-box;">City &amp; Guilds Level 3 Award in Inspection and Testing (2391-52)</li><li fr-original-style="" style="box-sizing: border-box;">City &amp; Guilds Level 4 Higher Professional Diploma in Building Services Engineering (4467-04)</li></ul><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">To qualify for the ECS Labourer Card, not only must you have an ECS-approved H&amp;S course, but you must also demonstrate active engagement in the electrotechnical sector. This proof can be provided through:</p><ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">An application by your employer via the ECS Employer Portal.</li><li fr-original-style="" style="box-sizing: border-box;">A written reference from your current employer on company-headed paper, stating your role as an electrical labourer, start date, and signed by an authorised person.</li><li fr-original-style="" style="box-sizing: border-box;">Confirmation of your contract duration from an agency if you are working through one.</li><li fr-original-style="" style="box-sizing: border-box;">Documented proof of enrolment in a related electrical course from your educational institution.</li></ul><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Additionally, you can submit an offer letter, employment contract, or recent payslip from a reputable business within the industry. These documents validate your eligibility and expertise, completing the ECS Labourer Card application process.</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;">Verify and Stay Updated</strong></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">While every effort is made to provide accurate and up-to-date information, it is essential to verify the current application criteria by visiting the <a href="https://www.ecscard.org.uk/" fr-original-style="" style="user-select: auto; font-size: var(--font-size); box-sizing: border-box; cursor: pointer; text-decoration: inherit;">ECS Website</a>. Keeping informed ensures that you meet all requirements and avoid any potential issues during the application process.</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;">Conclusion</strong></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Taking the SPA Health &amp; Safety Core Day is a strategic move for anyone looking to advance their career in the electrical industry. Not only does it provide essential health and safety training, but it also qualifies you for the ECS Labourer Card, a vital certification for gaining employment and furthering your career.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Enrol in the SPA Health &amp; Safety Core Day with MJ Electrical Training today. Equip yourself with the knowledge and certification needed to excel in the dynamic and rewarding field of electrical installations. Your journey to becoming a fully qualified electrician starts here!</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">&nbsp;</p>

ECS Card Health & Safety Course Dover

ECS Card Health & Safety Course Liverpool

ECS Card Health & Safety Course Newcastle

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

Access VBA

Visual Basic Analysis

Microsoft Power Automate

Excel - Automating Excel with Macros and Analysis Tools



The Real Estate Investment School is a four day course, that unravels the complexity of Investment Cash Flows through Advanced Modelling, Interpretation and Theory.
With a strong emphasis on practical application, you will gain a profound understanding of the complexities involved in analysing investment cash flows and interpreting their implications for effective decision-making.
Upon completion of the course, you will have the expertise to confidently model investment cash flows to a proficient level, empowering you to make informed financial decisions and drive positive outcomes for your investments.


The Investment focused school combines three of our courses:
Real Estate Analyst
Real Estate Modelling Masterclass
Understanding Key Principles of Real Estate Financial Modelling


On this course you will…
Construct Investment Financial Models starting from foundational principles
Learn how to value an appraise property investments.
Gain a comprehensive understanding of modelling tenancy schedules, including lease structures, rental income projections, lease expiry analysis, and lease renewal
Develop proficiency in creating robust models.
Understand how the application and use structure finance products in Real Estate
Learn advanced modelling techniques to analyse underlying asset risk
Appreciate the importance of data in investment cash flow modelling.
Gain a deep comprehension of the interrelationship between the metrics used in investment cash flow modelling


Who will benefit from this School?
Real Estate professionals at any level with exposure to real estate financial models on a frequent basis
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
Mid-level to senior Real Estate Analysts
Real Estate Managers who would like to gain an understanding of the dynamics of debt and financial return fluctuations in more detail
Property industry modellers who would like to be fully proficient in building complex financial models


Course Outline
Day One
Real Estate Analyst I
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
Real Estate Analyst II
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)


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


Day Four
Understanding Key Principles of Real Estate Financial Modelling
Real Estate Financial Modelling Mathematics
Time Value of Money
Net Present Value (NPV)
Internal Rare of Return (IRR)
Growth
What Discount Rate?
Certainty of a cash flow
Liquidity


Price, Value & Worth
Comparing Price, Value and Worth
Conventional Valuation Methods
Term and Reversion, Layer Method
Property Yields and Capitalisation Method
Exit calculations across Europe


Discounting Cash Flow Models
Investment Appraisal Models
Cash flow inputs: Rents, Yields, Growth Rates, Target Returns
Cash-on-Cash and Equity Multiple
Discount Rates & Exit Cap Rate
Operating Assumptions
Adding borrowing and analysing geared returns


Model Interpretation and Analysis
Sensitivity analysis and scenario analysis
Growth and inflation
Performance measures
Contemporary issues for analysis (such as the rise in interest rates


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 Investment School such as course delivery methods, pricing and dates, please contact Sam on the Bayfield Training Sales team:
E - s.musgrave@bayfieldtraining.com
T - 01223 517851
W - www.bayfieldtraining.com

Property Investment

Financial Analysis

The Real Estate Investment School is a four day course, that unravels the complexity of Investment Cash Flows through Advanced Modelling, Interpretation and Theory.

16993 Courses delivered Online

Introduction to DAX for Power BI

By Nexus Human

Data Analysis in Excel Level 3 Course

By Apex Learning

Microsoft Excel Introduction - In-company

By Microsoft Office Training

Microsoft Excel Intermediate - In-company

By Microsoft Office Training

Microsoft Office Specialist Excel Certification

By Studyhub UK

FSSC 22000 v6 Lead Auditor (CQI and IRCA Certified)

By QUALITY ACADEMY

Microsoft Excel: from ZERO to ADVANCED Course

By Training Express

Microsoft Excel in Depth: In-House Training

By IIL Europe Ltd

Microsoft Excel Advanced - In-company

By Microsoft Office Training

Excel Power Query and Power Pivot

By Underscore Group