Name: SharePoint - Advanced Site Owner (Modern Experience)
Price: 495 GBP
Availability: InStock

<p>Are you ready to take your professional skills to the next level? Are you eager to master the art of office management, facilities management, and team management? If so, then you've come to the right place! Our Office Management, Facilities Management &amp; Team Management bundle offers a unique learning experience that will equip you with the knowledge and expertise needed to succeed in today's fast-paced business world.</p> <p>With our bundle, you'll gain access to three QLS-endorsed courses: Office Management and Administration Diploma, Team Management, and Facilities Management. These courses cover a wide range of topics, from administrative and organisational skills to leadership and communication strategies. Plus, upon completion, you'll receive hardcopy certificates to show off your newly acquired expertise.</p> <p>But that's not all! We also offer five CPD-QS accredited courses, including Quality Management and Strategic Training, Supervisor Training, Leadership Training, Lean Six Sigma: Toolkit, and Decision Making and Critical Thinking. These courses will provide you with the skills and knowledge necessary to take your career to the next level.</p> <p>So, whether you're a seasoned professional looking to enhance your skills or a newcomer to the business world seeking to gain a competitive edge, our Office Management, Facilities Management &amp; Team Management bundle is the perfect solution for you. Enrol right now!</p> <p><strong>QLS Endorsed Courses: </strong></p> <ul> <li><strong>Course 01:</strong> Advanced Certificate in Office Management and Administration at QLS Level 3</li><li><strong>Course 02:</strong> Diploma in Team Management at QLS Level 5</li><li><strong>Course 03:</strong> Diploma in Facilities Management at QLS Level 5</li></ul> <p><strong>CPD QS Accredited Courses:</strong></p> <ul> <li><strong>Course 04:</strong> Quality Management and Strategic Training - ISO 9001</li><li><strong>Course 05:</strong> Supervisor Training</li><li><strong>Course 06:</strong> Leadership Training</li><li><strong>Course 07:</strong> Lean Six Sigma: Toolkit</li><li><strong>Course 08:</strong> Decision Making and Critical Thinking</li></ul> <p>Take your career to the next level with our bundle that includes not only technical courses but also <strong>five guided courses</strong> focused on personal development and <strong> career growth.</strong></p> <ul> <li><strong>Course 09: </strong>Personal Development</li><li><strong>Course 10:</strong> Career Development Plan Fundamentals</li><li><strong>Course 11: </strong>Leadership and Management Course</li><li><strong>Course 12: </strong>Communication Building Masterclass</li><li><strong>Course 13: </strong>Positive Psychology Masterclass</li></ul> <p><strong>Learning Outcomes:</strong></p> <ul> <li>Develop essential office management and administrative skills.</li><li>Learn effective team management and leadership strategies.</li><li>Gain expertise in facilities management and maintenance.</li><li>Understand the principles of quality management and strategic training.</li><li>Master the art of decision-making and critical thinking.</li><li>Develop lean Six Sigma toolkit to improve efficiency and productivity.</li><li>Build your career development skills and increase your employability.</li></ul><p>Our Office Management, Facilities Management &amp; Team Management bundle offers a unique opportunity to gain a comprehensive understanding of the key areas of business management. This bundle comprises three QLS-endorsed courses, including Office Management and Administration Diploma, Team Management, and Facilities Management.</p> <p>These courses provide a solid foundation of skills in administrative, organisational, and leadership abilities. The courses cover a wide range of topics, from the day-to-day operations of an office to effective management strategies and maintenance of facilities. Upon completion of these courses, you will have a strong understanding of how to manage an office and a team, maintain facilities, and optimise productivity.</p> <p><strong>Certificate</strong></p> <p>QLS-endorsed courses are designed to provide learners with the skills and knowledge they need to succeed in their chosen field.<br /><strong>The Quality Licence Scheme</strong> is a distinguished and respected accreditation in the UK, denoting exceptional quality and excellence. It carries significant weight among industry professionals and recruiters.<br />Upon completion, learners will receive Three <strong>QLS Endorsed</strong> hard copy certificates, making it easy for them to showcase their achievements. These certificates validate their course completion, the level of the course they have completed, and the QLS endorsement.</p><h2>
        
        <div>CPD</div>
    </h2>

                        <div id="cpd">
                            <div>
                                <div>
                                    <div>
                                        40 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 bundle is ideal for:</p> <ul> <li>Professionals looking to enhance their office management skills.</li><li>Individuals seeking to improve their team management and leadership abilities.</li><li>Those who want to learn the principles of facilities management.</li><li>Anyone looking to improve their career prospects and employability.</li></ul> 
                        </div><h2>
        
        <div>Career path</div>
    </h2>

                        <div id="career_path">
                             <p>Our training bundle prepares you for a range of careers, including:</p> <ul> <li>Office Manager: £22,000 - £40,000 per annum.</li><li>Facilities Manager: £25,000 - £50,000 per annum.</li><li>Quality Manager: £28,000 - £60,000 per annum.</li><li>Lean Six Sigma Specialist: £30,000 - £70,000 per annum.</li><li>Leadership and Development Manager: £30,000 - £60,000 per annum.</li><li>Critical Thinking Analyst: £28,000 - £45,000 per annum.</li></ul> 
                        </div><h2>
        
        <div>Certificates</div>
    </h2>

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

                        </div>

Imperial Academy

3 QLS Endorsed Diploma | QLS Hard Copy Certificate Included | Plus 10 CPD Courses | Lifetime Access

Office Management, Facilities Management & Team Management

General Admission

<div id="course-pills-1">Duration<p>3 Days</p><p>18 CPD hours</p>This course is intended for<p>This course is primarily designed for students who want to gain the skills necessary to use VBA to automate tasks in Excel such as collecting data from external sources, cleaning, and manipulating data. The target student may also want to learn how to create custom worksheet functions to streamline worksheet formulas and make complex worksheets easier to support, maintain, and understand.</p>Overview<p>In this course, you will develop and deploy VBA modules to solve business problems. You will:  Identify general components of VBA and their appropriate use in solving business solutions.  Record VBA macros to automate repetitive tasks.  Use reference tools built into Excel to get help on VBA programming language and objects used in the Excel VBA environment.  Write VBA code to create a custom worksheet function.  Eliminate, avoid, or handle errors in VBA code, and optimize its performance.  Control how and when macros run.  Develop UserForm objects to create custom dialog boxes and windows.  Use VBA to read and write data from local files and cloud services.  Use VBA to clean and transform data.  Run programs and commands outside of Excel and share VBA projects with other users</p><p>VBA (Visual Basic for Applications) enables you to enhance and extend the capabilities of MicrosoftÂ© ExcelÂ© and other applications in the MicrosoftÂ© Office application suite. You can use VBA to perform tasks that would be difficult or impossible to do using only worksheet functions, and you can automate a wide range of tasks involving the collection, processing, analysis, and visualization of data. This course will give you a good foundation for understanding, creating, and using VBA in your own Excel workbooks, show you how to work with data across different applications, and how to package the macros and functions you create so you can back them up, move them to other computers, and share them with other users</p>Prerequisites<p>To ensure your success in this course, you should be an experienced Excel user who is comfortable creating and working with Excel workbooks, including tasks such as entering  worksheet formulas, using absolute and relative addressing, formatting cells, and creating pivot tables and charts. This level of skill could be acquired by taking the Microsoft Excel for Office 365? (Desktop or Online) courses, Parts 1, 2, and 3</p></div><div id="course-pills-2"><h3>1 - Using VBA to Solve Business Problems</h3> <ul> <li>Topic A: Use Macros to Automate Tasks in Excel</li> <li>Topic B: Identify Components of Macro-Enabled Workbooks</li> <li>Topic C: Configure the Excel VBA Environment</li> </ul> <h3>2 - Automating Repetitive Tasks</h3> <ul> <li>Topic A: Use the Macro Recorder to Create a VBA Macro</li> <li>Topic B: Record a Macro with Relative Addressing</li> <li>Topic C: Delete Macros and Modules</li> <li>Topic D: Identify Strategies for Using the Macro Recorder</li> </ul> <h3>3 - Getting Help on VBA</h3> <ul> <li>Topic A: Use VBA Help</li> <li>Topic B: Use the Object Browser to Discover Objects You Can Use in VBA</li> <li>Topic C: Use the Immediate Window to Explore Object Properties and Methods</li> </ul> <h3>4 - Creating Custom Worksheet Functions</h3> <ul> <li>Topic A: Create a Custom Function</li> <li>Topic B: Make Decisions in Code</li> <li>Topic C: Work with Variables</li> <li>Topic D: Perform Repetitive Tasks</li> </ul> <h3>5 - Improving Your VBA Code</h3> <ul> <li>Topic A: Debug VBA Errors</li> <li>Topic B: Deal with Errors</li> <li>Topic C: Improve Macro Performance</li> </ul> <h3>6 - Controlling How and When Macros Run</h3> <ul> <li>Topic A: Prompt the User for Information</li> <li>Topic B: Configure Macros to Run Automatically</li> </ul> <h3>7 - Developing Custom Forms</h3> <ul> <li>Topic A: Display a Custom Dialog Box</li> <li>Topic B: Program Form Events</li> </ul> <h3>8 - Using VBA to Work with Files</h3> <ul> <li>Topic A: Use VBA to Get File and Directory Structure</li> <li>Topic B: Use VBA to Read Text Files</li> <li>Topic C: Use VBA to Write Text Files</li> </ul> <h3>9 - Using VBA to Clean and Transform Data</h3> <ul> <li>Topic A: Automate Power Query</li> <li>Topic B: Transform Data Using VBA and Workbook Functions</li> <li>Topic C: Use Regular Expressions</li> <li>Topic D: Manage Errors in Data</li> </ul> <h3>10 - Extending the Programming Environment Beyond the Workbook</h3> <ul> <li>Topic A: Run Other Programs and Commands</li> <li>Topic B: Share Your VBA Projects</li> </ul></div>

Nexus Human

Office Skills & Productivity

Visual Basic

Access VBA

Visual Basic Analysis

Computer Skills

Microsoft Excel

Programming and Data Wrangling with VBA and Excel

<div id="course-pills-1">Duration<p>1 Days</p><p>6 CPD hours</p>This course is intended for<p>This course is designed for professionals in a variety of job roles who receive Power BI data visualizations and reports from data analysts or from data visualization engineers. These data report recipients want to use the features and capabilities of Power BI to fully explore the visualizations and initial analyses provided to them in reports, perform additional analysis to ask next-level questions of the data, and to customize and create new visualizations and dashboards in order to share new insights and create compelling reports.</p>Overview<p>Explore Power BI reports.  Analyze data to get answers and insights.  Sort and group data for analysis and reporting.  Filter visualizations.  Prepare reports.  Troubleshoot, collaborate, and share reports.</p><p>As data acquisition, access, analysis, and reporting are interwoven with our businesses and lives, more and more data is collected about business and personal activities. This abundance of data and the computing power to analyze it has increased the use of data analysis and data visualization across a broad range of job roles. Decision makers of all types, including managers and executives, must interact with, interpret, and develop reports based on data and analysis provided to them. Microsoft Power BI software is designed for data analysis and the creation of visualizations. Data analysts prepare data, perform initial analysis, and create visualizations that are then passed to business data decision makers. These decision makers can use Power BI's tools to explore the data, perform further analysis to find new insights, make decisions, and create customized reports to share their findings.</p>Prerequisites<p>To ensure your success in this course, you have experience managing data with Microsoft Excel or Google Sheets</p></div><div id="course-pills-2"><h3>1. Exploring Power BI Reports</h3><ul> <li>Topic A: Data Analysis Workflow with Power BI</li>  <li>Topic B: Explore Reports in the Power BI Service</li>  <li>Topic C: Edit Reports</li></ul>    <h3>2. Analyzing Data to Get Answers and Insights</h3><ul> <li>Topic A: Configure Data Visualizations</li>  <li>Topic B: Ask New Questions by Changing Aggregation</li>  <li>Topic C: Find Answers with Calculations</li></ul>    <h3>3.  Sorting and Grouping Data for Analysis and Reporting</h3><ul> <li>Topic A: Sort Data</li>  <li>Topic B: Group Data</li></ul>   <h3>4.  Filtering Visualizations</h3><ul> <li>Topic A: Filter Data to Refine Analysis</li>  <li>Topic B: Create Slicers for Reports</li></ul>    <h3>5.  Preparing Reports</h3><ul> <li>Topic A: Format and Annotate Reports</li>  <li>Topic B: Emphasize Data in Reports</li></ul>    <h3>6.  Troubleshooting, Sharing, and Collaborating</h3><ul> <li>Topic A: Troubleshoot Data Issues</li>  <li>Topic B: Collaborate in Power BI</li>  <li>Topic C: Collaborate with Non-Power BI Users</li></ul></div>

Powerbi

Business Analytics & Intelligence

Microsoft Power BI

Microsoft BI

Business Intelligence (BI)

Business Data Analysis

Power BI for Data-driven Decision Makers

<p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Excel but different. Harness this most powerful tool but on a course tailored to your business and needs.&nbsp;</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Using case studies relevant to your business and often actual files your firm uses on a daily basis we embark on a voyage of discovery. This isn&#39;t a boring "watch what I do and copy" course. This is exciting, engaging, funny and enjoyable.&nbsp;</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Delegates will learn relevant skills but also, because of the delivery methods they will gain an increased enjoyment of using Excel and will retain and implement all of the material covered.&nbsp;</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">They also have access to the trainer for an unlimited amount of time after the course to continue to grow their knowledge</p>

Alumno Consulting

Excel but different. Harness this most powerful tool but on a course tailored to your business and needs. Using case studies relevant to your business and often actual files your firm uses on a daily basis we embark on a voyage of discovery. This isn't a boring "watch what I do and copy" course. This is exciting, engaging, funny and enjoyable. Delegates will learn relevant skills but also, because of the delivery methods they will gain an increased enjoyment of using Excel and will retain and implement all of the material covered. They also have access to the trainer for an unlimited amount of time after the course to continue to grow their knowledge

Excel (but not like you've seen it before)

General admission

<p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">You&#39;re OK at Excel, maybe you&#39;re great, we get it. Maybe you&#39;re the person people come to in the office to fix their spreadsheets, maybe you just like tinkering in Excel.&nbsp;</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Did you ever wonder if there was something more?&nbsp;</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">VBA will enable you to harness the full power of your spreadsheets.&nbsp;</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Any repetitive tasks? Automated.&nbsp;</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Any jobs that often end up with errors due to their complexity? Not any more.&nbsp;</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Need to collect and analyse data quickly? Done.&nbsp;</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">These VBA sessions will not only teach you great coding best practices and ensure you know your way around the Development Environment, it will give you the practical skills to automate your workflow.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">We also give you the resources to take your knowledge further</p>

Visual Basic for Applications (VBA) in Excel (from cool to geek in less than 1 day)

Class (max 20)

<p>In today's dynamic global landscape, organisations are looking for more than just task-completing administrators. <strong>The World Health Organization reports that globally, millions are affected by work-related accidents or diseases yearly.</strong> Hence, businesses value individuals who excel in administrative roles and understand the paramount importance of workplace safety. Are you prepared to fit into this high-demand niche?</p><p>Your Professional Growth Path Begins Here! Our dual-course '<strong>Admin, PA and Workplace Safety - QLS Endorsed</strong>'bundle offers a perfect blend of administrative mastery and safety proficiency. Under "<strong>Admin, Secretarial and PA</strong>", go deep into essentials like "Administrative Management", "<strong>Organisational Skills</strong>", and "<strong>Business Writing</strong>". Grasp the nuances of modern office tasks with modules like "<strong>Excel Basics</strong>" and "<strong>PowerPoint Basic</strong>". Transition seamlessly into the "<strong>Workplace Health and Safety Officer</strong>" course, guiding you through imperative topics such as "<strong>Risk Assessment</strong>", "<strong>Electrical, Fire and Gas Safety</strong>", and more. Train yourself to become an indispensable asset to any global company.</p><p>Why This Course is a Game-Changer? <strong>Admin roles are evolving</strong>. With telecommuting and flexible workplaces becoming the norm, integrating admin expertise with health and safety knowledge makes you stand out. You're not just managing tasks; you're safeguarding colleagues, ensuring productivity, and building trust. This course positions you at the crossroads of efficiency and safety a potent combination sought after worldwide.</p><p>Sharpen your admin prowess. Become a beacon of safety. And do it all from your home with our comprehensive online course. Let your skill set shine bright as the world adjusts to new norms. Enrol in <strong>Admin, PA and Workplace Safety - QLS Endorsed </strong>now and shape a future where you're always in demand!</p><p><strong>Learning Outcomes:</strong></p><ul><li>Discover essential administrative tasks, from business writing to effective communication.</li><li>Develop proficiency in essential office tools like Excel and PowerPoint.</li><li>Enhance organisational skills, improving efficiency in various administrative roles.</li><li>Understand the foundational laws and regulations surrounding workplace health and safety.</li><li>Identify potential risks in diverse work settings and learn mitigation strategies.</li><li>Gain expertise in managing workplace meetings and optimising time and resources.</li><li>Adopt best practices in telephone etiquette, ensuring professional communication.</li><li>Analyse the causes and impacts of workplace accidents and diseases.</li><li>Implement adequate risk controls for common work equipment hazards.</li><li>Integrate principles of body language into daily interactions, boosting interpersonal relationships.</li></ul><p><strong>Why Choose Imperial Academy?</strong></p><ul><li>Fully Online Training</li><li>QLS Endorsed &amp; CPD Accredited Certificate</li><li>No Time Limits. Study at Your Own Pace</li><li>Expert Instructors</li><li>Audio Visual Training</li><li>Up-to-date Curriculum and Valuable Guidelines</li></ul><p>The "<strong>Admin, PA and Workplace Safety - QLS Endorsed</strong>" course offers a comprehensive insight into the dynamic world of administration, personal assistance, and workplace safety. Explore the complex responsibilities of today's administrative positions, from developing organisational skills to utilising the power of vital office programmes like PowerPoint and Excel.</p><p>Get involved in the crucial domain of workplace safety. This course prepares learners with a profound understanding of health and safety laws, risk assessments, and functional strategies to prevent accidents and ensure a safe working environment. It's an essential blend for those aiming to excel in today's evolving professional landscape.</p><p><strong>Course Curriculum:</strong></p><p><strong>Course 1: Admin, Secretarial and PA (Level 5 at QLS)</strong></p><ul><li>Module 01: Personal Assistant</li><li>Module 02: Admin Support</li><li>Module 03: Administrative Management</li><li>Module 04: Organisational Skills</li><li>Module 05: Telephone Etiquette</li><li>Module 06: Business Writing</li><li>Module 07: Time Management</li><li>Module 08: Body Language and Effective Communication</li><li>Module 09: Meeting Management</li><li>Module 10: Excel Basics</li><li>Module 11: PowerPoint Basic</li></ul><p><strong>Course 2: Workplace Health and Safety Officer (Level 5 at QLS)</strong></p><ul><li>Module 01: Health and Safety at Work and the Laws</li><li>Module 02: Managing for Health and Safety</li><li>Module 03: Risk Assessment and Common Risks</li><li>Module 04: Workplace Health, Safety and Welfare</li><li>Module 05: Accidents and Ill Health at Work</li><li>Module 06: Electrical, Fire and Gas Safety</li><li>Module 07: Safety in Different Work Settings</li><li>Module 08: Work Equipment Hazards and Risk Control</li><li>Module 09: Other Health and Safety Hazards at Work</li></ul><p><strong>Certification:</strong></p><p>Learners will get <strong>2 QLS Endorsed Certificates &amp; 2 CPD Accredited Certificates of Achievement </strong>directly at their doorstep after successfully completing the package! It should be noted that international students must pay a £10 shipping cost.</p><p>Imperial Academy is an approved reselling partner for Quality Licence Scheme courses under One Education.</p><h2>
        
        <div>CPD</div>
    </h2>

                        <div id="cpd">
                            <div>
                                <div>
                                    <div>
                                        180 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>Our <strong>Admin, PA and Workplace Safety - QLS Endorsed</strong> bundle is appropriate for the following:</p><ul><li>Aspiring Administrators seeking a foundational understanding of office tasks and tools.</li><li>Personal Assistants aiming to refine their organisational and communication skills.</li><li>Office Managers wishing to ensure a safe and efficient workplace environment.</li><li>HR Professionals focused on enhancing workplace health and safety measures.</li><li>Business Owners who want to implement and maintain best practices in admin and safety.</li><li>Career Changers venturing into administrative roles with an emphasis on safety protocols.</li></ul>
                        </div><h2>
        
        <div>Requirements</div>
    </h2>

                        <div id="requirements">
                            <p>Anyone can enrol in this <strong>Admin, PA and Workplace Safety - QLS Endorsed</strong> bundle.</p>
                        </div><h2>
        
        <div>Career path</div>
    </h2>

                        <div id="career_path">
                            <ul><li>Personal Assistant (PA): £25,000 - £35,000</li><li>Administrative Manager: £30,000 - £45,000</li><li>Workplace Health and Safety Officer: £25,000 - £40,000</li><li>Office Administrator: £18,000 - £28,000</li><li>HR Safety Compliance Specialist: £27,000 - £50,000</li><li>Business Communication Specialist: £28,000 - £42,000</li><li>Excel Data Analyst: £24,000 - £40,000</li></ul>
                        </div><h2>
        
        <div>Certificates</div>
    </h2>

                        <div id="optional_extras">
                                    <h4> Hard Copy QLS Certificate</h4>
        <p>
            Hard copy certificate -
            Included
        </p>
        <h4>PDF Certificate</h4>
        <p>
            Digital certificate -
            Included
        </p>

                        </div>

2 QLS Endorsed Courses | CPD Certified | Free PDF & Hard Copy QLS Certificates | 180 CPD Points | Lifetime Access

Admin, PA and Workplace Safety - QLS Endorsed

<div id="course-pills-1">Duration<p>1 Days</p><p>6 CPD hours</p>This course is intended for<p>Individuals with basic computer skills, familiar with concepts related to database structure and terminology, and who want to use SQL to query databases.</p>Overview<p>Upon successful completion of this course, students will be able to: - connect to the SQL Server database and execute a simple query. - include a search condition in a simple query. - use various functions to perform calculations on data. - organize data obtained from a query before it is displayed on-screen. - retrieve data from tables. - format an output, save a result, and generate a report.</p><p>In this course, students will compose SQL queries to retrieve desired information from a database.</p></div><div id="course-pills-2"><h3>1 - Executing a Simple Query</h3> <ul> <li>Connect to the SQL Database</li> <li>Query a Database</li> <li>Save a Query</li> <li>Modify a Query</li> <li>Execute a Saved Query</li> </ul> <h3>2 - Performing a Conditional Search</h3> <ul> <li>Search Using a Simple Condition</li> <li>Compare Column Values</li> <li>Search Using Multiple Conditions</li> <li>Search for a Range of Values and Null Values</li> <li>Retrieve Data Based on Patterns</li> </ul> <h3>3 - Working with Functions</h3> <ul> <li>Perform Date Calculations</li> <li>Calculate Data Using Aggregate Functions</li> <li>Manipulate String Values</li> </ul> <h3>4 - Organizing Data</h3> <ul> <li>Sort Data</li> <li>Rank Data</li> <li>Group Data</li> <li>Filter Grouped Data</li> <li>Summarize Grouped Data</li> <li>Use PIVOT and UNPIVOT Operators</li> </ul> <h3>5 - Retrieving Data from Tables</h3> <ul> <li>Combine Results of Two Queries</li> <li>Compare the Results of Two Queries</li> <li>Retrieve Data by Joining Tables</li> <li>Check for Unmatched Records</li> <li>Retrieve Information from a Single Table Using Joins</li> </ul> <h3>6 - Presenting Query Results</h3> <ul> <li>Save the Query Result</li> <li>Generate an XML Report</li> </ul></div>

Computing Skills

Programming Fundamentals

Microsoft SQL

Data Skills

SQL Server

SQL Querying Fundamentals - Part 1

<div data-id="84fa810" data-element_type="widget" data-widget_type="heading.default" style="color: rgb(51, 51, 51); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(51, 51, 51);"><h3 style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">OVERVIEW</h3></div><div data-id="f4d9ac0" data-element_type="widget" data-widget_type="text-editor.default" style="color: rgb(61, 78, 96); box-sizing: border-box;" fr-original-style=" color: rgb(61, 78, 96);"><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Prerequisites&mdash;DIAD training or equivalent working experience</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">This one-day course will cover Power BI report layouts and structure the agile process to creating Power BI data visualizations. It will help attendees to understand the art behind visualizations, the implications behind choosing the right charts, the impact of color, shape, and size, and finally the use of Power BI custom visuals. The course includes various design patterns of dashboards and reports, as well as best practices for authoring great reports and dashboards for business users.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">The course content is managed by the Power BI engineering team at Microsoft. There is no exam associated with the course.</p></div><div data-id="3268c88" data-element_type="widget" data-widget_type="heading.default" style="color: rgb(51, 51, 51); box-sizing: border-box;" fr-original-style=" color: rgb(51, 51, 51);"><h3 style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">COURSE BENEFITS:</h3></div><div data-id="7a033b7" data-element_type="widget" data-widget_type="icon-list.default" style="color: rgb(51, 51, 51); box-sizing: border-box;" fr-original-style=" color: rgb(51, 51, 51);"><ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;"><i style="color: rgb(99, 93, 255); box-sizing: border-box;" fr-original-style=" color: rgb(99, 93, 255);"></i><span style="color: rgb(61, 78, 96); box-sizing: border-box;" fr-original-style=" color: rgb(61, 78, 96);">Understand the need for storytelling with data</span></li><li fr-original-style="" style="box-sizing: border-box;"><i style="color: rgb(99, 93, 255); box-sizing: border-box;" fr-original-style=" color: rgb(99, 93, 255);"></i><span style="color: rgb(61, 78, 96); box-sizing: border-box;" fr-original-style=" color: rgb(61, 78, 96);">Understand the agile process to creating Power BI data visualizations</span></li><li fr-original-style="" style="box-sizing: border-box;"><i style="color: rgb(99, 93, 255); box-sizing: border-box;" fr-original-style=" color: rgb(99, 93, 255);"></i><span style="color: rgb(61, 78, 96); box-sizing: border-box;" fr-original-style=" color: rgb(61, 78, 96);">Understand the art behind visualizations</span></li><li fr-original-style="" style="box-sizing: border-box;"><i style="color: rgb(99, 93, 255); box-sizing: border-box;" fr-original-style=" color: rgb(99, 93, 255);"></i><span style="color: rgb(61, 78, 96); box-sizing: border-box;" fr-original-style=" color: rgb(61, 78, 96);">Gain familiarity with Power BI report layouts and structure</span></li><li fr-original-style="" style="box-sizing: border-box;"><i style="color: rgb(99, 93, 255); box-sizing: border-box;" fr-original-style=" color: rgb(99, 93, 255);"></i><span style="color: rgb(61, 78, 96); box-sizing: border-box;" fr-original-style=" color: rgb(61, 78, 96);">Understand implications behind choosing the right charts</span></li><li fr-original-style="" style="box-sizing: border-box;"><i style="color: rgb(99, 93, 255); box-sizing: border-box;" fr-original-style=" color: rgb(99, 93, 255);"></i><span style="color: rgb(61, 78, 96); box-sizing: border-box;" fr-original-style=" color: rgb(61, 78, 96);">Gain familiarity with using Power BI custom visuals</span></li></ul></div><div data-id="402ee41" data-element_type="widget" data-widget_type="heading.default" style="color: rgb(51, 51, 51); box-sizing: border-box;" fr-original-style=" color: rgb(51, 51, 51);"><h3 style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">WHO IS THE COURSE FOR?</h3></div><div data-id="1e62ca4" data-element_type="widget" data-widget_type="text-editor.default" style="color: rgb(61, 78, 96); box-sizing: border-box;" fr-original-style=" color: rgb(61, 78, 96);"><ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">Power BI report developers who wish to improve the aesthetic quality of their reports</li><li fr-original-style="" style="box-sizing: border-box;">Power BI and other BI practitioners who would like to understand more about the theory of data visualization</li><li fr-original-style="" style="box-sizing: border-box;">BI practitioners who wish to create reports that communicate the meaning behind the data more clearly</li><li fr-original-style="" style="box-sizing: border-box;">Power BI users who would like to explore the types of chart and visual available that answer different types of business question</li></ul><div fr-original-style="" style="box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></div><div data-id="9bc97d7" data-element_type="widget" data-widget_type="heading.default" style="color: rgb(51, 51, 51); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(51, 51, 51);"><h3 style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">COURSE OUTLINE</h3></div><div data-id="ce8a9cc" data-element_type="widget" data-widget_type="toggle.default" style="color: rgb(51, 51, 51); box-sizing: border-box;" fr-original-style=" color: rgb(51, 51, 51);"><div data-tab="1" tabindex="0" fr-original-style="" style="box-sizing: border-box;"><span style="color: rgb(99, 93, 255); box-sizing: border-box;" fr-original-style=" color: rgb(99, 93, 255);"><i fr-original-style="" style="box-sizing: border-box;"></i></span>Module 1 What Is Storytelling With Data?</div><div data-tab="1" style="color: rgb(61, 78, 96); box-sizing: border-box;" fr-original-style=" color: rgb(61, 78, 96);"><ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">Volume, Velocity and Variety</li><li fr-original-style="" style="box-sizing: border-box;">The importance of business questions</li><li fr-original-style="" style="box-sizing: border-box;">What is a story in this context?</li></ul></div><div data-tab="2" tabindex="0" fr-original-style="" style="box-sizing: border-box;"><span style="color: rgb(99, 93, 255); box-sizing: border-box;" fr-original-style=" color: rgb(99, 93, 255);"><i fr-original-style="" style="box-sizing: border-box;"></i></span>Module 2 The Science Behind Data Visualization</div><div data-tab="2" style="color: rgb(61, 78, 96); box-sizing: border-box;" fr-original-style=" color: rgb(61, 78, 96);"><ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">Basic problems to avoid</li><li fr-original-style="" style="box-sizing: border-box;">Memory and visualization</li><li fr-original-style="" style="box-sizing: border-box;">Ways to spark iconic, short-term and long-term memory</li></ul></div><div data-tab="3" tabindex="0" fr-original-style="" style="box-sizing: border-box;"><span style="color: rgb(99, 93, 255); box-sizing: border-box;" fr-original-style=" color: rgb(99, 93, 255);"><i fr-original-style="" style="box-sizing: border-box;"></i></span>Module 3 The Process Behind Data Visualization</div><div data-tab="3" style="color: rgb(61, 78, 96); box-sizing: border-box;" fr-original-style=" color: rgb(61, 78, 96);"><ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">Using an agile approach to report development</li><li fr-original-style="" style="box-sizing: border-box;">Data structure and data grain</li><li fr-original-style="" style="box-sizing: border-box;">Converting the story to a data model</li></ul></div><div data-tab="4" tabindex="0" fr-original-style="" style="box-sizing: border-box;"><span style="color: rgb(99, 93, 255); box-sizing: border-box;" fr-original-style=" color: rgb(99, 93, 255);"><i fr-original-style="" style="box-sizing: border-box;"></i></span>Module 4 Dashboards And Reports</div><div data-tab="4" style="color: rgb(61, 78, 96); box-sizing: border-box;" fr-original-style=" color: rgb(61, 78, 96);"><ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">Terminology and definitions</li><li fr-original-style="" style="box-sizing: border-box;">Dashboard layout and structure</li><li fr-original-style="" style="box-sizing: border-box;">Report layout and structure</li><li fr-original-style="" style="box-sizing: border-box;">Storyboarding</li><li fr-original-style="" style="box-sizing: border-box;">Drill-through, bookmarks, toggles and tooltips</li></ul></div><div data-tab="5" tabindex="0" fr-original-style="" style="box-sizing: border-box;"><span style="color: rgb(99, 93, 255); box-sizing: border-box;" fr-original-style=" color: rgb(99, 93, 255);"><i fr-original-style="" style="box-sizing: border-box;"></i></span>Module 5 Chart Selection</div><div data-tab="5" style="color: rgb(61, 78, 96); box-sizing: border-box;" fr-original-style=" color: rgb(61, 78, 96);"><ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">Charts for comparison</li><li fr-original-style="" style="box-sizing: border-box;">Time series</li><li fr-original-style="" style="box-sizing: border-box;">Proportions</li><li fr-original-style="" style="box-sizing: border-box;">Constructing effective tables, cards and slicers</li><li fr-original-style="" style="box-sizing: border-box;">Scatterplots</li></ul></div><div data-tab="6" tabindex="0" fr-original-style="" style="box-sizing: border-box;"><span style="color: rgb(99, 93, 255); box-sizing: border-box;" fr-original-style=" color: rgb(99, 93, 255);"><i fr-original-style="" style="box-sizing: border-box;"></i></span>Module 6 Accessibility And Custom Visuals</div><div data-tab="6" style="color: rgb(61, 78, 96); box-sizing: border-box;" fr-original-style=" color: rgb(61, 78, 96);"><ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">Report accessibility checklists</li><li fr-original-style="" style="box-sizing: border-box;">Custom visuals</li><li fr-original-style="" style="box-sizing: border-box;">Creating a custom R visual</li><li fr-original-style="" style="box-sizing: border-box;">Charticulator</li></ul></div><div data-tab="7" tabindex="0" fr-original-style="" style="box-sizing: border-box;"><span style="color: rgb(99, 93, 255); box-sizing: border-box;" fr-original-style=" color: rgb(99, 93, 255);"><i fr-original-style="" style="box-sizing: border-box;"></i></span>Module 7 Publishing And Formatting</div><div data-tab="7" style="color: rgb(61, 78, 96); box-sizing: border-box;" fr-original-style=" color: rgb(61, 78, 96);"><ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">Colour schemes</li><li fr-original-style="" style="box-sizing: border-box;">Making a Power BI theme</li><li fr-original-style="" style="box-sizing: border-box;">Use of fonts, icons and symbols</li><li fr-original-style="" style="box-sizing: border-box;">Sizing dashboard and report tiles</li><li fr-original-style="" style="box-sizing: border-box;">Sparklines, hyperlinks and images</li></ul></div><div data-tab="8" tabindex="0" fr-original-style="" style="box-sizing: border-box;"><span style="color: rgb(99, 93, 255); box-sizing: border-box;" fr-original-style=" color: rgb(99, 93, 255);"><i fr-original-style="" style="box-sizing: border-box;"></i></span>Module 8 Report Authoring - Best Practices</div><div data-tab="8" style="color: rgb(61, 78, 96); box-sizing: border-box;" fr-original-style=" color: rgb(61, 78, 96);"><ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">Design thought process</li><li fr-original-style="" style="box-sizing: border-box;">The audience</li><li fr-original-style="" style="box-sizing: border-box;">Defining the platform environment</li><li fr-original-style="" style="box-sizing: border-box;">The user experience</li><li fr-original-style="" style="box-sizing: border-box;">Visualization</li><li fr-original-style="" style="box-sizing: border-box;">Implementation and testing</li><li fr-original-style="" style="box-sizing: border-box;">Optimization</li></ul></div><div data-tab="9" tabindex="0" fr-original-style="" style="box-sizing: border-box;"><span style="color: rgb(99, 93, 255); box-sizing: border-box;" fr-original-style=" color: rgb(99, 93, 255);"><i fr-original-style="" style="box-sizing: border-box;"></i></span>Module 9 Dashboard And Goals Design</div><div data-tab="9" style="color: rgb(61, 78, 96); box-sizing: border-box;" fr-original-style=" color: rgb(61, 78, 96);"><ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">Tips and tricks</li><li fr-original-style="" style="box-sizing: border-box;">Best practices for dashboard design</li><li fr-original-style="" style="box-sizing: border-box;">Tracking business metrics with goals</li></ul></div></div></div>

Online Productivity Training

Advanced Visualization with Power BI (AVIAD)

<div style="color: rgb(85, 85, 85); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(85, 85, 85);"><h2 style="color: var(--tec-color-text-primary); box-sizing: border-box;" fr-original-style=" color: var(--tec-color-text-primary);">December 5&nbsp;<span style="color: rgb(185, 190, 194); box-sizing: border-box;" fr-original-style=" color: rgb(185, 190, 194);">@&nbsp;</span>4:00 PM&nbsp;<span style="color: rgb(185, 190, 194); box-sizing: border-box;" fr-original-style=" color: rgb(185, 190, 194);">&ndash;&nbsp;</span>6:00 PM&nbsp;<span style="color: rgb(185, 190, 194); box-sizing: border-box;" fr-original-style=" color: rgb(185, 190, 194);">GMT</span></h2></div><div style="color: rgb(85, 85, 85); box-sizing: border-box;" fr-original-style=" color: rgb(85, 85, 85);"><div style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">Watch your timezone</div>EDT: 11:00 AM &ndash; 1:00 PM | PDT: 8:00 AM &ndash; 10:00 AM</div><h2 style="color: var(--wp--preset--color--black) !important; box-sizing: border-box;" fr-original-style=" color: var(--wp--preset--color--black) !important;">Transform Your Resume into an Interview Magnet</h2><p style="color: rgb(85, 85, 85); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(85, 85, 85);">Ready to stop sending your resume into the void? It&rsquo;s time to master a fundamental life skill for every ambitious administrative professional: crafting a resume that doesn&rsquo;t just list your entire work history, but actually it gets you interviews. Join us for an intensive workshop where we reveal the industry secrets behind the art and science of standout resumes.</p><p style="color: rgb(85, 85, 85); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(85, 85, 85);"><br fr-original-style="" style="box-sizing: border-box;"></p><h2 style="color: rgb(85, 85, 85); box-sizing: border-box;" fr-original-style=" color: rgb(85, 85, 85);">Why Your Resume Is Your Career&rsquo;s Most Valuable Player</h2><p style="color: rgb(85, 85, 85); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(85, 85, 85);">A well-crafted resume is more than a formality; it&rsquo;s a strategic tool. In this workshop, you&rsquo;ll discover:</p><p style="color: rgb(85, 85, 85); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(85, 85, 85);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">The Vital Edge:</strong>&nbsp;Learn why understanding resume strategy isn&rsquo;t just helpful&mdash;it&rsquo;s crucial.</p><p style="color: rgb(85, 85, 85); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(85, 85, 85);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">The Winning Formula:</strong>&nbsp;There&rsquo;s a&nbsp;<span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">proven</strong></span>&nbsp;<strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">method</strong>&nbsp;to this, and without it, you&rsquo;re likely missing opportunities.</p><p style="color: rgb(85, 85, 85); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(85, 85, 85);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Conversion Mastery:</strong>&nbsp;We don&rsquo;t just teach you how to write a resume&mdash;we show you how to turn it into interview offers.</p><h2 style="color: var(--wp--preset--color--black) !important; box-sizing: border-box;" fr-original-style=" color: var(--wp--preset--color--black) !important;">What Sets This Workshop Apart</h2><p style="color: rgb(85, 85, 85); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(85, 85, 85);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Laser-Focused Content:&nbsp;</strong>Every minute is packed with actionable content, not fluff.</p><p style="color: rgb(85, 85, 85); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(85, 85, 85);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Resume Real-Talk:&nbsp;</strong>We&rsquo;re ditching the common &ldquo;best practices&rdquo; for what&rsquo;s truly best for YOU. The only resume writer here is you! You are the one who is going to have to speak from this resume in the interview, so it has to be authentic but optimized to give you that important advantage.</p><p style="color: rgb(85, 85, 85); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(85, 85, 85);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">ATS Friendly Templates:&nbsp;</strong>Walk away with templates and techniques that have a high success rate of converting applications into interviews.</p><div data-block-id="eac7fbb" style="color: rgb(85, 85, 85); box-sizing: border-box;" fr-original-style=" color: rgb(85, 85, 85);"><br fr-original-style="" style="box-sizing: border-box;"></div><h2 style="color: var(--wp--preset--color--black) !important; box-sizing: border-box;" fr-original-style=" color: var(--wp--preset--color--black) !important;">Your Workshop Benefits</h2><p style="color: rgb(85, 85, 85); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(85, 85, 85);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Life-Changing Skill Set:</strong>&nbsp;Resume building is a life skill, and we treat it with the gravity it deserves. You can share these techniques with your loved ones to help improve the lives of those around you.</p><p style="color: rgb(85, 85, 85); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(85, 85, 85);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Inside Knowledge:</strong>&nbsp;Tap into the &ldquo;behind-the-scenes&rdquo; mechanics of successful resumes. These techniques work and we can prove it. Our strategies are unique but help change your mindset completely, allowing you to break away from dull and boring resumes that get passed over.</p><p style="color: rgb(85, 85, 85); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(85, 85, 85);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Real Results:</strong>&nbsp;Use our optimized templates, which are specifically designed to increase your interview chances.</p><h2 style="color: rgb(85, 85, 85); box-sizing: border-box;" fr-original-style=" color: rgb(85, 85, 85);">Who should attend?</h2><p style="color: rgb(85, 85, 85); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(85, 85, 85);">This workshop is perfectly suited for executive assistants, administrative professionals, and office managers&mdash;especially those who may not have had formal training in crafting standout resumes but are keen to master this essential skill. If you are looking to navigate the job market with a resume that confidently showcases your skills and achievements in a way that highlights your value to the employer, or if you want to ensure your application rises to the top of the interview pile, this workshop is crafted for you.</p><h2 style="color: rgb(85, 85, 85); box-sizing: border-box;" fr-original-style=" color: rgb(85, 85, 85);">Don&rsquo;t Just Apply&mdash;Stand Out!<br fr-original-style="" style="box-sizing: border-box;">It&rsquo;s not just about having experience; it&rsquo;s about showcasing it effectively. Register for the workshop today, and make every application a step towards success.</h2><h3 style="color: rgb(85, 85, 85); box-sizing: border-box;" fr-original-style=" color: rgb(85, 85, 85);"><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">Reserve your seat in the workshop today</span>.&nbsp;<span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">Limited spots available, act swiftly.</span></h3>

The Officials

Administrative Assistant

Office Skills

Office Management

Executive Personal Assistance

Personal Assistant

Office Administration

Executive Assistant

Resume & CV Writing

Professional Development

Job Search

Ready to stop sending your resume into the void? It’s time to master a fundamental life skill for every ambitious administrative professional: crafting a resume that doesn’t just list your entire work history, but actually it gets you interviews. Join us for an intensive workshop where we reveal the industry secrets behind the art and science of standout resumes.

Competitive Resume Strategies: Build a Resume that Stands Out and Secures the Interview – Workshop for Administrative Professionals


Did you know all HQ Members can attend Skills workshops for free? Join today and save even more!

SPECIAL OFFER #1: WORKSHOP + MONTHLY HQ MEMBERSHIP

Get annual access to our online training and community platform and attend Skills Workshops for free!

SPECIAL OFFER #2: WORKSHOP + ANNUAL HQ MEMBERSHIP

<div id="course-pills-1">Duration<p>1 Days</p><p>6 CPD hours</p>This course is intended for<p>This course is designed for students who already have experience creating Modern SharePoint sites and populating them with content, who want to learn advanced features to extend SharePoint's capabilities, make information easier to find and manage, use SharePoint features to improve governance and compliance, and improve the security of information and services within the SharePoint environment.</p>Overview<p>Create a custom site template to reduce the time spent creating similarly configured SharePoint sites. Configure managed metadata, including custom term sets, content types, and metadata-based navigation. Control access through permissions. Improve overall security of sites, lists, libraries, folders, list items, and documents.</p><p></p><p>MicrosoftÂ© SharePointÂ©, in conjunction with the Microsoft 365? productivity and office automation suite, provides tools to create and manage a corporate intranet, facilitate content sharing and collaboration, and enable users to create, access, store, and track documents and data in a central location.</p> <p>Users who already have experience as SharePoint site members and owners may be ready to move on to more advanced site-building tasks such as using custom site templates, custom themes, applying advanced permissions settings, improving security, and preparing sites to support governance and compliance.</p> <p>Advanced site builders may be ready to undertake more advanced site management tasks, working in conjunction with their SharePoint Administrator to create and use custom site templates, term sets and metadata, manage information governance and compliance, and get deeper into SharePoint security configuration.</p> <p>This course focuses on these advanced site-building and administration tasks.</p><p></p>Prerequisites<p></p><p>To ensure your success in this course, you should have SharePoint site user skills such as the ability to view and enter data in SharePoint lists and libraries, and to navigate a typical SharePoint site. You should also have intermediate site builder skills such as the ability to create a SharePoint site, apply a site template, populate sites with pages, create lists and libraries, and connect a site to a hub site.</p> <p>NOTE: This course was developed using Microsoft 365 Business Standard edition. If you opt to use one of the Enterprise editions, be sure to key the course activities before you deliver the class so you will be able to anticipate any differences that students might see with the edition you use.</p><p></p></div><div id="course-pills-2"><h3>Lesson 1: Creating Custom Site Templates</h3> <ul> <li>Topic A: Prepare a Site Script</li> <li>Topic B: Generate and Use a Custom Site Template</li> </ul> <h3>Lesson 2: Managing Content Services</h3> <ul> <li>Topic A: Plan and Configure Managed Metadata</li> <li>Topic B: Create and Manage Content Types</li> <li>Topic C: Use Managed Metadata for Navigation and Filtering</li> </ul> <h3>Lesson 3: Controlling Access Through Permissions</h3> <ul> <li>Topic A: Assign Permissions</li> <li>Topic B: Manage Permissions Inheritance</li> </ul> <h3>Lesson 4: Improving Security</h3> <ul> <li>Topic A: Manage Access at the Site Level</li> <li>Topic B: Manage Access at the Tenant Level</li> </ul></div>

Online Course Creation

Microsoft Sharepoint

Microsoft 365

Microsoft AZ-104

SharePoint

Microsoft AZ-303

SharePoint - Advanced Site Owner (Modern Experience)

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

Microsoft Certification

Microsoft AZ-900

Microsoft AZ-700

MD-102T00 Microsoft 365 Endpoint Administrator

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

Sccm

Microsoft Certified Technology Specialist (MCTS)

Commercial & Contract Management Certification Program (CCM)

IT Manager

Microsoft Certified Trainer (MCT)

55348 Administering Microsoft Endpoint Configuration Manager

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

Hi-Tech Training

City & Guilds

Electronics

Digital Design

Electrical Engineering

Analog Electronics

Computer Engineering

Digital Skills

Online Education

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

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

Digital Electronics Course Online

Deposit Only

Full Price (including Deposit)

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

Verhoef Training Ltd.

New Db2 13 Functions and Features - CV321G

Early bird

Book your place early to get an extra discount!

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

Microsoft Power Apps

Power Apps

Microsoft Power Platform

55215 SharePoint Online Power User

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



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


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


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


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


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


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


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

Bayfield Training

Financial Modelling & Analysis

Financial Modelling

Property & Real Estate Photography

Continuous Professional Development (CPD)

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

Real Estate Analyst (Investment Cash Flow Modelling in Excel)

In-Person 

Virtual

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

Excel Analytics

Microsoft Power Automate

Excel - Automating Excel with Macros and Analysis Tools

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



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


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


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


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


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


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

Real Estate Finance

Investment Management

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

Real Estate Modelling Masterclass (Advanced Cash Flow Modelling)

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

Microsoft PL-900

PL-900T00 Microsoft Power Platform Fundamentals

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



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


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


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


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


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


Quizzes | Q&A


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


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

Property Investment

Risk Management

Investment

Financial Risk Management

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

3368 Office Skills courses delivered Online

Office Management, Facilities Management & Team Management

By Imperial Academy

Programming and Data Wrangling with VBA and Excel

By Nexus Human

Power BI for Data-driven Decision Makers

By Nexus Human

Excel (but not like you've seen it before)

By Alumno Consulting

Visual Basic for Applications (VBA) in Excel (from cool to geek in less than 1 day)

By Alumno Consulting

Admin, PA and Workplace Safety - QLS Endorsed

By Imperial Academy

SQL Querying Fundamentals - Part 1

By Nexus Human

Advanced Visualization with Power BI (AVIAD)

By Online Productivity Training

Competitive Resume Strategies: Build a Resume that Stands Out and Secures the Interview – Workshop for Administrative Professionals

By The Officials

SharePoint - Advanced Site Owner (Modern Experience)

By Nexus Human