Name: Personal Finance With Excel
Price: 11.99 GBP
Availability: InStock

Studyhub UK

Office Skills & Productivity

Microsoft Certification

Microsoft 365

Office Skills

Office Administration

Microsoft Office

Microsoft Office for Admin

General Admission

<div> <div>     </div> <div>  <div> <div> <h3><strong>Highlights of the Course</strong></h3> <ul> <li><strong>Course Type:</strong> Online Learning</li> <li><strong>Duration:</strong> 4 Hours</li> <li><strong>Tutor Support:</strong> Tutor support is included</li> <li><strong>Customer Support:</strong> 24/7 customer support is available</li> <li><strong>Quality Training:</strong> The course is designed by an industry expert</li> <li><strong>Recognised Credential:</strong> Recognised and Valuable Certification</li> <li><strong>Completion Certificate:</strong> Free Course Completion Certificate Included</li> <li><strong>Instalment:</strong> 3 Installment Plan on checkout</li> </ul> </div> </div> <div> <div> <hr /> <h3><strong>What you will learn from this course?</strong></h3> <ul> <li>Gain comprehensive knowledge about Microsoft PowerPont</li> <li>Understand the core competencies and principles of Microsoft PowerPont</li> <li>Explore the various areas of Microsoft PowerPont</li> <li>Know how to apply the skills you acquired from this course in a real-life context</li> <li>Become a confident and expert office admin</li> </ul> </div> </div> <hr /> <div> <div> <div> <h3><strong>Microsoft PowerPoint 2016/2019/365 - Foundations for Beginners Course</strong></h3> <p>Master the skills you need to propel your career forward in Microsoft PowerPoint. This course will equip you with the essential knowledge and skillset that will make you a confident office admin and take your career to the next level. This comprehensive Microsoft PowerPoint<b> </b>course is designed to help you surpass your professional goals. The skills and knowledge that you will gain through studying this Microsoft PowerPoint course will help you get one step closer to your professional aspirations and develop your skills for a rewarding career.</p> <p>This comprehensive course will teach you the theory of effective Microsoft PowerPoint practice and equip you with the essential skills, confidence and competence to assist you in the Microsoft PowerPoint industry. You'll gain a solid understanding of the core competencies required to drive a successful career in Microsoft PowerPoint. This course is designed by industry experts, so you'll gain knowledge and skills based on the latest expertise and best practices. This extensive course is designed for office admin or for people who are aspiring to specialise in Microsoft PowerPoint.</p> <p>Enrol in this Microsoft PowerPoint course today and take the next step towards your personal and professional goals. Earn industry-recognised credentials to demonstrate your new skills and add extra value to your CV that will help you outshine other candidates.</p> </div> <div> <h3><strong>Who is this Course for?</strong></h3> <p>This comprehensive Microsoft PowerPoint course is ideal for anyone wishing to boost their career profile or advance their career in this field by gaining a thorough understanding of the subject. Anyone willing to gain extensive knowledge on this Microsoft PowerPoint can also take this course.</p> <p>Whether you are a complete beginner or an aspiring professional, this course will provide you with the necessary skills and professional competence, and open your doors to a wide number of professions within your chosen sector.</p> </div> <div> <h3><strong>Entry Requirements</strong></h3> <p>This Microsoft PowerPoint course has no academic prerequisites and is open to students from all academic disciplines. You will, however, need a laptop, desktop, tablet, or smartphone, as well as a reliable internet connection.</p> </div> <div> <h3><strong>Assessment</strong></h3> <p>This Microsoft PowerPoint course assesses learners through multiple-choice questions (MCQs). Upon successful completion of the modules, learners must answer MCQs to complete the assessment procedure. Through the MCQs, it is measured how much a learner could grasp from each section. In the assessment pass mark is 60%.</p> </div> <div> <h3><strong>Advance Your Career</strong></h3> <p>This Microsoft PowerPoint<b> </b>course will provide you with a fresh opportunity to enter the relevant job market and choose your desired career path. Additionally, you will be able to advance your career, increase your level of competition in your chosen field, and highlight these skills on your resume.</p> </div> </div> </div> </div> </div><h3><strong>Recognised Accreditation</strong></h3> <p></p> <p>This course is accredited by continuing professional development (CPD). CPD UK is globally recognised by employers, professional organisations, and academic institutions, thus a certificate from CPD Certification Service creates value towards your professional goal and achievement.</p><div> <h3> <span>Course Curriculum</span> </h3> <div> <table> <tbody><tr> <td colspan="4">Getting Started With PowerPoint</td> </tr> <tr> <td><i></i></td> <td> Navigate the PowerPoint Environment - Introduction </td> <td> </td> <td><span><i></i> 00:01:00</span></td> </tr> <tr> <td><i></i></td> <td> Navigate the PowerPoint Environment </td> <td> </td> <td><span><i></i> 00:11:00</span></td> </tr> <tr> <td><i></i></td> <td> View and Navigate a Presentation - Introduction </td> <td> </td> <td><span><i></i> 00:01:00</span></td> </tr> <tr> <td><i></i></td> <td> View and Navigate a Presentation </td> <td> </td> <td><span><i></i> 00:09:00</span></td> </tr> <tr> <td><i></i></td> <td> Create and Save a PowerPoint Presentation - Introduction </td> <td> </td> <td><span><i></i> 00:01:00</span></td> </tr> <tr> <td><i></i></td> <td> Create and Save a PowerPoint Presentation </td> <td> </td> <td><span><i></i> 00:07:00</span></td> </tr> <tr> <td><i></i></td> <td> Use PowerPoint Help - Introduction </td> <td> </td> <td><span><i></i> 00:01:00</span></td> </tr> <tr> <td><i></i></td> <td> Use PowerPoint Help </td> <td> </td> <td><span><i></i> 00:06:00</span></td> </tr> <tr> <td colspan="4">Developing a PowerPoint Presentation</td> </tr> <tr> <td><i></i></td> <td> Select a Presentation Type - Introduction </td> <td> </td> <td><span><i></i> 00:01:00</span></td> </tr> <tr> <td><i></i></td> <td> Select a Presentation Type </td> <td> </td> <td><span><i></i> 00:06:00</span></td> </tr> <tr> <td><i></i></td> <td> Edit Text </td> <td> </td> <td><span><i></i> 00:10:00</span></td> </tr> <tr> <td><i></i></td> <td> Add, Delete and Modify Slides </td> <td> </td> <td><span><i></i> 00:09:00</span></td> </tr> <tr> <td><i></i></td> <td> Work with Themes - Introduction </td> <td> </td> <td><span><i></i> 00:01:00</span></td> </tr> <tr> <td><i></i></td> <td> Work With Themes </td> <td> </td> <td><span><i></i> 00:05:00</span></td> </tr> <tr> <td colspan="4">Performing Advanced Text Editing Operations</td> </tr> <tr> <td><i></i></td> <td> Format Characters - Introduction </td> <td> </td> <td><span><i></i> 00:01:00</span></td> </tr> <tr> <td><i></i></td> <td> Format Characters </td> <td> </td> <td><span><i></i> 00:08:00</span></td> </tr> <tr> <td><i></i></td> <td> Format Paragraphs - Introduction </td> <td> </td> <td><span><i></i> 00:01:00</span></td> </tr> <tr> <td><i></i></td> <td> Text Alignment Options </td> <td> </td> <td><span><i></i> 00:08:00</span></td> </tr> <tr> <td><i></i></td> <td> Text Alignment Options </td> <td> </td> <td><span><i></i> 00:08:00</span></td> </tr> <tr> <td><i></i></td> <td> Format Text Boxes </td> <td> </td> <td><span><i></i> 00:10:00</span></td> </tr> <tr> <td colspan="4">Adding Graphical Elements to Your Presentation</td> </tr> <tr> <td><i></i></td> <td> Add Graphical Elements to Your Presentation - Introduction </td> <td> </td> <td><span><i></i> 00:01:00</span></td> </tr> <tr> <td><i></i></td> <td> Insert Images </td> <td> </td> <td><span><i></i> 00:08:00</span></td> </tr> <tr> <td><i></i></td> <td> Insert Shapes </td> <td> </td> <td><span><i></i> 00:08:00</span></td> </tr> <tr> <td colspan="4">Modifying Objects in Your Presentation</td> </tr> <tr> <td><i></i></td> <td> Modify Objects In Your Presentation - Introduction </td> <td> </td> <td><span><i></i> 00:01:00</span></td> </tr> <tr> <td><i></i></td> <td> Edit Objects </td> <td> </td> <td><span><i></i> 00:09:00</span></td> </tr> <tr> <td><i></i></td> <td> Format Objects </td> <td> </td> <td><span><i></i> 00:08:00</span></td> </tr> <tr> <td><i></i></td> <td> Animate Objects </td> <td> </td> <td><span><i></i> 00:06:00</span></td> </tr> <tr> <td colspan="4">Adding Tables to Your Presentation</td> </tr> <tr> <td><i></i></td> <td> Add A Table - Introduction </td> <td> </td> <td><span><i></i> 00:01:00</span></td> </tr> <tr> <td><i></i></td> <td> Create a Table </td> <td> </td> <td><span><i></i> 00:05:00</span></td> </tr> <tr> <td><i></i></td> <td> Format a Table </td> <td> </td> <td><span><i></i> 00:07:00</span></td> </tr> <tr> <td><i></i></td> <td> Insert A Table From Others Office Applictions </td> <td> </td> <td><span><i></i> 00:08:00</span></td> </tr> <tr> <td colspan="4">Adding Charts to Your Presentation</td> </tr> <tr> <td><i></i></td> <td> Add A Chart - Introduction </td> <td> </td> <td><span><i></i> 00:01:00</span></td> </tr> <tr> <td><i></i></td> <td> Create a Chart </td> <td> </td> <td><span><i></i> 00:07:00</span></td> </tr> <tr> <td><i></i></td> <td> Format a Chart </td> <td> </td> <td><span><i></i> 00:08:00</span></td> </tr> <tr> <td><i></i></td> <td> Insert a Chart from Microsoft Excel </td> <td> </td> <td><span><i></i> 00:03:00</span></td> </tr> <tr> <td colspan="4">Preparing to Deliver Your Presentation</td> </tr> <tr> <td><i></i></td> <td> Prepare Your Presentation - Introduction </td> <td> </td> <td><span><i></i> 00:02:00</span></td> </tr> <tr> <td><i></i></td> <td> Review Your Presentation - Part 1 </td> <td> </td> <td><span><i></i> 00:06:00</span></td> </tr> <tr> <td><i></i></td> <td> Review Your Presentation - Part 2 </td> <td> </td> <td><span><i></i> 00:06:00</span></td> </tr> <tr> <td><i></i></td> <td> Apply Transitions </td> <td> </td> <td><span><i></i> 00:06:00</span></td> </tr> <tr> <td><i></i></td> <td> Print Your Presentation </td> <td> </td> <td><span><i></i> 00:06:00</span></td> </tr> <tr> <td><i></i></td> <td> Present a Slide Show </td> <td> </td> <td><span><i></i> 00:07:00</span></td> </tr> <tr> <td><i></i></td> <td> Export a Presentation to a PDF File </td> <td> </td> <td><span><i></i> 00:03:00</span></td> </tr> <tr> <td><i></i></td> <td> Bonus Lecture </td> <td> </td> <td><span><i></i> 00:01:00</span></td> </tr> <tr> <td colspan="4">What's New In PowerPoint 2019/365?</td> </tr> <tr> <td><i></i></td> <td> Highlight Text </td> <td> </td> <td><span><i></i> 00:03:00</span></td> </tr> <tr> <td><i></i></td> <td> How to Adjust the Link Color </td> <td> </td> <td><span><i></i> 00:02:00</span></td> </tr> <tr> <td><i></i></td> <td> Draw and Write Digitally </td> <td> </td> <td><span><i></i> 00:04:00</span></td> </tr> <tr> <td><i></i></td> <td> Animate Freehand Drawings </td> <td> </td> <td><span><i></i> 00:04:00</span></td> </tr> <tr> <td><i></i></td> <td> Create Professional Slide Layouts With PowerPoint Designer </td> <td> </td> <td><span><i></i> 00:04:00</span></td> </tr> <tr> <td colspan="4">Obtain Your Certificate</td> </tr> <tr> <td><i></i></td> <td> Order Your Certificate of Achievement </td> <td> </td> <td><span><i></i> 00:00:00</span></td> </tr> <tr> <td colspan="4">Get Your Insurance Now</td> </tr> <tr> <td><i></i></td> <td> Get Your Insurance Now </td> <td> </td> <td><span><i></i> 00:00:00</span></td> </tr> <tr> <td colspan="4">Feedback</td> </tr> <tr> <td><i></i></td> <td> Feedback </td> <td> </td> <td><span><i></i> 00:00:00</span></td> </tr> </tbody></table></div> </div>

Study Plex

Microsoft PowerPoint 2016/2019/365 - Foundations for Beginners

John Academy

Office Productivity

Microsoft Word

Microsoft Office 2016 Complete Bundle Course (Word, Excel, PowerPoint, Outlook and Access)

Packt

Microsoft Project

Project Management

Microsoft Project 2021 is a complete lifecycle project management tool that manages complex projects efficiently. This all-encompassing course molds you into an expert in project management with fundamentals to advanced techniques to handle projects of all sizes and gain confidence and proficiency in project planning, execution, and reporting.

Microsoft Project 2021 From Beginners to Advanced

<div fr-original-style="" style="box-sizing: border-box;"><div fr-original-style="" style="box-sizing: border-box;"><div fr-original-style="" style="box-sizing: border-box;"><section fr-original-style="" style="box-sizing: border-box;"><div fr-original-style="" style="box-sizing: border-box;"><div fr-original-style="" style="box-sizing: border-box;"><div fr-original-style="" style="box-sizing: border-box;"><div fr-original-style="" style="box-sizing: border-box;"><div fr-original-style="" style="box-sizing: border-box;"><div fr-original-style="" style="box-sizing: border-box;"><div fr-original-style="" style="box-sizing: border-box;"><span style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">From business to research, having a solid grasp of Excel Data analysis can open doors of opportunity in various industries. Learn this valuable skill set from the comfort of your home with the Data Analysis In Excel course. This course will introduce you to the ins and outs of Excel data analysis.</span></div></div></div></div></div></div><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 Data Analysis In Excel course will help you establish a solid foundation in Excel data analysis. This course will help you pick up the skills to visualise data with charts in Excel. Here, you will also learn about Pivot Tables and Charts. Furthermore, the course will teach you how to work with multiple Workbooks. In addition, you will learn about Lookup factions and how to use them. By the end of this course, you will know the essentials of automating Workbook functionality.</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 assist you in securing effective data analysis skills. In addition, you will receive a QLS-endorsed certificate of achievement. This certificate will enhance your employability in the relevant job market. Join now!&nbsp;</span></p><section id="isPasted" fr-original-style="" style="box-sizing: border-box;"><div fr-original-style="" style="box-sizing: border-box;"><div fr-original-style="" style="box-sizing: border-box;"><div fr-original-style="" style="box-sizing: border-box;"><div fr-original-style="" style="box-sizing: border-box;"><div fr-original-style="" style="box-sizing: border-box;"><div fr-original-style="" style="box-sizing: border-box;"><div fr-original-style="" style="box-sizing: border-box;"><h2 fr-original-style="" style="box-sizing: border-box;"><span style="font-size: 18px; box-sizing: border-box;" fr-original-style="font-size: 18px;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Learning Outcomes</strong></span></h2></div></div><div fr-original-style="" style="box-sizing: border-box;"><div fr-original-style="" style="box-sizing: border-box;"><ul fr-original-style="" style="box-sizing: border-box;"><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Understand the basic principles of data analysis with Excel</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Learn how to visualise data with Excel charts</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Build your expertise in using Pivot Tables and Charts&nbsp;</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Grasp the techniques of working with multiple Worksheets and Workbooks</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Know the process of automating Workbook functionality&nbsp;</li></ul></div></div></div></div></div></div></div></section><section fr-original-style="" style="box-sizing: border-box;"><div fr-original-style="" style="box-sizing: border-box;"><div fr-original-style="" style="box-sizing: border-box;"><div fr-original-style="" style="box-sizing: border-box;"><div fr-original-style="" style="box-sizing: border-box;"><div fr-original-style="" style="box-sizing: border-box;"><div fr-original-style="" style="box-sizing: border-box;"><div fr-original-style="" style="box-sizing: border-box;"><h2 fr-original-style="" style="box-sizing: border-box;"><span style="font-size: 18px; box-sizing: border-box;" fr-original-style="font-size: 18px;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Certificate of Achievement</strong></span></h2></div></div></div></div></div></div></div></section></div></section><section fr-original-style="" style="box-sizing: border-box;"><div fr-original-style="" style="box-sizing: border-box;"><div fr-original-style="" style="box-sizing: border-box;"><div fr-original-style="" style="box-sizing: border-box;"><div fr-original-style="" style="box-sizing: border-box;"></div></div></div></div></section><section fr-original-style="" style="box-sizing: border-box;"><div fr-original-style="" style="box-sizing: border-box;"><div fr-original-style="" style="box-sizing: border-box;"><div fr-original-style="" style="box-sizing: border-box;"><div fr-original-style="" style="box-sizing: border-box;"><div fr-original-style="" style="box-sizing: border-box;">
<div fr-original-style="" style="box-sizing: border-box;">
<div fr-original-style="" style="box-sizing: border-box;">
<div fr-original-style="" style="box-sizing: border-box;">
<p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Endorsed Certificate of Achievement from the Quality Licence Scheme</strong></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Upon successful completion of the final assessment, you will be eligible to apply for the Quality Licence Scheme Endorsed Certificate of achievement. This certificate will be delivered to your doorstep through the post for &pound;99. An extra &pound;10 postage charge will be required for students leaving overseas.&nbsp;</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;"><span style="font-size: 18px; box-sizing: border-box;" fr-original-style="font-size: 18px;">CPD Accredited Certificate</span></strong></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">After the successful completion of the final assessment, you will receive a CPD-accredited certificate of achievement. The PDF certificate is for 9.99, and it will be sent to you immediately after through e-mail. You can get the hard copy for 15.99, which will reach your doorsteps by post.&nbsp;</p></div>
</div>
</div>
</div></div></div><div fr-original-style="" style="box-sizing: border-box;"><div fr-original-style="" style="box-sizing: border-box;"><div fr-original-style="" style="box-sizing: border-box;"><div fr-original-style="" style="box-sizing: border-box;">
</div>
</div>
</div>
</div>
</div>
</div>
</section>
<section fr-original-style="" style="box-sizing: border-box;">
<div fr-original-style="" style="box-sizing: border-box;">
<div fr-original-style="" style="box-sizing: border-box;">
<div fr-original-style="" style="box-sizing: border-box;">
<div fr-original-style="" style="box-sizing: border-box;">
<div fr-original-style="" style="box-sizing: border-box;">
<div fr-original-style="" style="box-sizing: border-box;">
<div fr-original-style="" style="box-sizing: border-box;">
<h2 fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"><span style="font-size: 18px; box-sizing: border-box;" fr-original-style="font-size: 18px;">Method of Assessment 
</span></strong></h2></div><span style="font-size: 18px; box-sizing: border-box;" fr-original-style="font-size: 18px;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">
</strong></span></div><span style="font-size: 18px; box-sizing: border-box;" fr-original-style="font-size: 18px;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">
</strong></span><div fr-original-style="" style="box-sizing: border-box;"><span style="font-size: 18px; box-sizing: border-box;" fr-original-style="font-size: 18px;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">
</strong></span><div fr-original-style="" style="box-sizing: border-box;"><span style="font-size: 18px; box-sizing: border-box;" fr-original-style="font-size: 18px;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">
</strong></span><div fr-original-style="" style="box-sizing: border-box;"><span style="font-size: 18px; box-sizing: border-box;" fr-original-style="font-size: 18px;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">
</strong></span><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">At the end of the course, there will be an MCQ assessment. In order to pass this exam, you must score at least 60%. When you submit the assessment, it will be examined, and the results will be given to you immediately.</p></div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</section>
<section fr-original-style="" style="box-sizing: border-box;">
<div fr-original-style="" style="box-sizing: border-box;">
<div fr-original-style="" style="box-sizing: border-box;">
<div fr-original-style="" style="box-sizing: border-box;">
<div fr-original-style="" style="box-sizing: border-box;">
<div fr-original-style="" style="box-sizing: border-box;">
<div fr-original-style="" style="box-sizing: border-box;">
<div fr-original-style="" style="box-sizing: border-box;">
<h2 fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"><span style="font-size: 18px; box-sizing: border-box;" fr-original-style="font-size: 18px;">Career path</span></strong></h2></div><span style="font-size: 18px; box-sizing: border-box;" fr-original-style="font-size: 18px;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">
</strong></span></div><span style="font-size: 18px; box-sizing: border-box;" fr-original-style="font-size: 18px;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">
</strong></span><div fr-original-style="" style="box-sizing: border-box;"><span style="font-size: 18px; box-sizing: border-box;" fr-original-style="font-size: 18px;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">
</strong></span><div fr-original-style="" style="box-sizing: border-box;"><span style="font-size: 18px; box-sizing: border-box;" fr-original-style="font-size: 18px;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">
</strong></span><div fr-original-style="" style="box-sizing: border-box;"><span style="font-size: 18px; box-sizing: border-box;" fr-original-style="font-size: 18px;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">
</strong></span><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">This course is designed to help you extant your knowledge and understanding of this sector. After completing the course, you will be able to explore career options such as</p></div>
</div>
</div>
<div fr-original-style="" style="box-sizing: border-box;">
<div fr-original-style="" style="box-sizing: border-box;">
<ul fr-original-style="" style="box-sizing: border-box;">
<li fr-original-style="" style="box-sizing: border-box;">


Data Analyst 
</li>
<li fr-original-style="" style="box-sizing: border-box;">


Research Assistant
</li>
<li fr-original-style="" style="box-sizing: border-box;">


Researcher  
</li>
<li fr-original-style="" style="box-sizing: border-box;">


Business Analyst 
</li>
</ul>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</section>
</div>
</div>
</div><div fr-original-style="" style="box-sizing: border-box;">
<h3 fr-original-style="" style="box-sizing: border-box;">
                                    </h3></div><div fr-original-style="" style="box-sizing: border-box;"><div fr-original-style="" style="box-sizing: border-box;"><div fr-original-style="" style="box-sizing: border-box;">
                                </div>
                            </div>
                        </div>

Janets

Excel Analytics

Microsoft Excel

Data Analysis

Data Skills

Data Analyst

Business Data Analysis

Data Analysis In Excel

<div id="course-pills-1">Duration<p>2 Days</p><p>12 CPD hours</p>Overview<p>What's New in This Guide?<br />The behind-the-scenes journal entry for transactions is now included.</p><p>This course is a continuation of topics following ?Get Started with QuickBooks 2021 for Windows?. First-time QuickBooks users will learn the basic features of the software. Experienced QuickBooks users will quickly learn the new features and functionality of QuickBooks 2021. This course covers features that are in QuickBooks Pro and Premier 2021.</p></div><div id="course-pills-2"><h4>Memorizing Transactions</h4><ul><li>Entering a New Memorized Transaction</li><li>Editing a Memorized Transaction</li><li>Deleting a Memorized Transaction</li><li>Grouping Memorized Transactions</li><li>Using a Memorized Transaction</li><li>Printing the Memorized Transaction List</li></ul><h4>Customizing Forms</h4><ul><li>Creating a Custom Template</li><li>Modifying a Template</li><li>Printing Forms</li></ul><h4>Using Other QuickBooks Accounts</h4><ul><li>Other QuickBooks Account Types</li><li>Working with Credit Card Transactions</li><li>Working with Fixed Assets</li><li>Working with Long-Term Liability Accounts</li><li>Using the Loan Manager</li></ul><h4>Creating Reports</h4><ul><li>Working with Quick Reports</li><li>Working with Preset Reports</li><li>Sharing Reports</li><li>Exporting Reports to Microsoft Excel</li><li>Printing Reports</li></ul><h4>Creating Graphs</h4><ul><li>Creating QuickInsight Graphs</li><li>Using QuickZoom with Graphs</li><li>Working with the Sales Graph</li><li>Customizing Graphs</li><li>Printing Graphs</li></ul><h4>Tracking and Paying Sales Tax</h4><ul><li>Using Sales Tax in QuickBooks</li><li>Setting Up Tax Rates and Agencies</li><li>Indicating Who and What Gets Taxed</li><li>Applying Tax to Each Sale</li><li>Determining What You Owe</li><li>Paying Your Tax Agencies</li></ul><h4>Preparing Payroll with QuickBooks</h4><ul><li>Using Payroll Tracking</li><li>Setting Up for Payroll</li><li>Setting Up Employee Payroll Information</li><li>Setting Up a Payroll Schedule</li><li>Writing a Payroll Check</li><li>Printing Paycheck Stubs</li><li>Tracking Your Tax Liabilities</li><li>Paying Payroll Taxes</li><li>Preparing Payroll Tax Forms</li></ul><h4>Using Online Banking</h4><ul><li>Setting Up an Internet Connection</li><li>Setting Up Bank Feeds for Accounts</li><li>Viewing, Downloading, and Adding Online Transactions</li><li>Creating Online Payments</li><li>Transferring Funds Online</li><li>Canceling Online Payments</li></ul><h4>Managing Company Files</h4><ul><li>Using QuickBooks in Multi-user Mode</li><li>Setting Up Users and Passwords</li><li>Setting a Closing Date</li><li>Sharing Files with an Accountant</li><li>Updating QuickBooks</li><li>Backing Up and Restoring a Company File</li><li>Condensing a Company File</li></ul><h4>Estimating, Time Tracking, and Job Costing</h4><ul><li>Creating Job Estimates</li><li>Creating an Invoice from an Estimate</li><li>Displaying Reports for Estimates</li><li>Updating the Job Status</li><li>Tracking Time</li><li>Displaying Reports for Time Tracking</li><li>Tracking Vehicle Mileage</li><li>Displaying Vehicle Mileage Reports</li><li>Displaying Other Job Reports</li></ul><h4>Writing Letters</h4><ul><li>Using the Letters and Envelopes Wizard</li><li>Customizing Letter Templates</li></ul></div><div id="course-pills-3"><h4>Additional course details:</h4><br /><p>Nexus Humans Keep Going With QuickBooks 2021 for Windows 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 Keep Going With QuickBooks 2021 for Windows 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>

Nexus Human

Online Course Creation

Business Accounting

Trainers Course

Accounting & Bookkeeping

QuickBooks

Practical Accounting

Keep Going With QuickBooks 2021 for Windows

<div id="course-pills-1">Duration<p>2 Days</p><p>12 CPD hours</p>This course is intended for<p>This course is designed for professionals in a variety of job roles who are currently using desktop or web-based data management tools such as Microsoft Excel or SQL Server reporting services to perform numerical or general data analysis. They are responsible for connecting to cloud-based data sources, as well as shaping and combining data for the purpose of analysis. They are also looking for alternative ways to analyze business data, visualize insights, and share those insights with peers across the enterprise. This includes capturing and reporting on data to peers, executives, and clients.</p>Overview<p>In this course, you will analyze data with Microsoft Power BI. You will:<br />Analyze data with self-service BI.<br />Connect to data sources.<br />Perform data cleaning, profiling, and shaping.<br />Visualize data with Power BI.<br />Enhance data analysis by adding and customizing visual elements.<br />Model data with calculations.<br />Create interactive visualizations.</p><p>As technology progresses and becomes more interwoven with our businesses and lives, more data is collected about business and personal activities. This era of 'big data' is a direct result of the popularity and growth of cloud computing, which provides an abundance of computational power and storage, allowing organizations of all sorts to capture and store data. Leveraging that data effectively can provide timely insights and competitive advantages.<br />Creating data-backed visualizations is key for data scientists, or any professional, to explore, analyze, and report insights and trends from data. MicrosoftÂ© Power BIÂ© software is designed for this purpose. Power BI was built to connect to a wide range of data sources, and it enables users to quickly create visualizations of connected data to gain insights, show trends, and create reports. Power BI's data connection capabilities and visualization features go far beyond those that can be found in spreadsheets, enabling users to create compelling and interactive worksheets, dashboards, and stories that bring data to life and turn data into thoughtful action.<br /></p></div><div id="course-pills-2"><h4>Analyzing Data with Self-Service BI</h4><ul><li>Topic A: Data Analysis and Visualization for Business Intelligence</li><li>Topic B: Self-Service BI with Microsoft Power BI</li></ul><h4>Connecting to Data Sources</h4><ul><li>Topic A: Create Data Connections</li><li>Topic B: Configure and Manage Data Relationships</li><li>Topic C: Save Files in Power BI</li></ul><h4>Performing Data Cleaning, Profiling, and Shaping</h4><ul><li>Topic A: Clean, Transform, and Load Data with the Query Editor</li><li>Topic B: Profile Data with the Query Editor</li><li>Topic C: Shape Data with the Query Editor</li><li>Topic D: Combine and Manage Data Rows</li></ul><h4>Visualizing Data with Power BI</h4><ul><li>Topic A: Create Visualizations in Power BI</li><li>Topic B: Chart Data in Power BI</li></ul><h4>Enhancing Data Analysis</h4><ul><li>Topic A: Customize Visuals and Pages</li><li>Topic B: Incorporate Tooltips</li></ul><h4>Modeling Data with Calculations</h4><ul><li>Topic A: Create Calculations with Data Analysis Expressions (DAX)</li><li>Topic B: Create Calculated Measures and Conditional Columns</li></ul><h4>Creating Interactive Visualizations</h4><ul><li>Topic A: Create and Manage Data Hierarchies</li><li>Topic B: Filter and Slice Reports</li><li>Topic C: Create Dashboards</li></ul></div><div id="course-pills-3"><h4>Additional course details:</h4><br /><p>Nexus Humans Microsoft Power BI: Data Analysis Practitioner (Second Edition) (v1.3) 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 Microsoft Power BI: Data Analysis Practitioner (Second Edition) (v1.3) course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you.  <p></p>Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.<p></p></div>

Powerbi

Business Analytics & Intelligence

Microsoft Power BI

Microsoft Power Platform

Microsoft BI

Microsoft Power BI: Data Analysis Practitioner (Second Edition) (v1.3)

<div>
	<p><span>Administrative office strategies may not be fabulous, but rather they are fundamental to the achievement of any venture. A well-run office diminishes miscommunications and dispenses with regular blunders. By making the administrative office a need, you will build up clear arrangements and methodology with representative comprehension and purchase in, which guarantees that your workplace runs easily. </span></p>
<p><span>This course is about every single administrative strategy that ought to be incorporated into your business or company. You will be able to learn about the administrative instruments, how they utilised adequately and productive way to diminish the problems and issues. The course will also discuss the best five to methodologies that you require to record in the binder to guarantee the recordings are exact and accurate. Other things you will consider are the things that ought to be incorporated into the cover, for example, how telephone calls ought to be addressed and how to incorporate the particular arrangements of the association like compensation plans. All of these lessons and more will be taught in this course thoroughly. </span></p>
<h3><b>Who is the course for?</b></h3>
<ul>
<li><span>Professionals, employees or businessmen who want to improve the administration department of their company.</span></li>
<li><span>People who want to know how administrative management works.</span></li>
</ul>
<h3><b>Entry Requirement:</b></h3>
<ul>
<li><span>This course is available to all learners, of all academic backgrounds. </span></li>
<li><span>Learners should be aged 16 or over to undertake the qualification.</span></li>
<li><span>Good understanding of English language, numeracy and ICT are required to attend this course.</span></li>
</ul>
<h3><strong>Assessment: </strong></h3>
<ul>
<li>At the end of the course, you can sit for an optional online multiple-choice test. Your test will be assessed automatically and immediately so that you will instantly know whether you have been successful.</li>
<li>Before sitting for your final exam you will have the opportunity to test your proficiency with a mock exam.</li>
</ul>
<h3><strong>Certification:</strong></h3>
<ul>
<li>After you have successfully passed the test, you will be able to obtain an Accredited Certificate of Achievement. You can however also obtain a Course Completion Certificate following the course completion without sitting for the test. Certificates can be obtained either in hard copy at a cost of £14.99 or in PDF format at a cost of £11.99.</li>
<li>PDF certificate's turnaround time is 24 hours and for the hardcopy certificate, it is 3-9 working days.</li>
</ul>
<h3><strong>Why choose us?</strong></h3>
<ul>
<li>Affordable, engaging &amp; high-quality e-learning study materials;</li>
<li>Tutorial videos/materials from the industry leading experts;</li>
<li>Study in a user-friendly, advanced online learning platform;</li>
<li>Efficient exam systems for the assessment and instant result;</li>
<li>The UK &amp; internationally recognised accredited qualification;</li>
<li>Access to course content on mobile, tablet or desktop from anywhere anytime;</li>
<li>The benefit of career advancement opportunities;</li>
<li>24/7 student support via email.</li>
</ul>
<h3><strong>Career Path:</strong></h3>
<p><span>The Diploma in Administrative Management is a useful qualification to possess, and would be beneficial for the following careers:</span></p>
<ul>
<li><span>Accounting Technician</span></li>
<li><span>Admin Assistant</span></li>
<li><span>Bid Writer</span></li>
<li><span>Bookkeeper</span></li>
<li><span>Civil Service Administrative Officer</span></li>
<li><span>Data Entry Clerk</span></li>
<li><span>Finance Officer</span></li>
<li><span>Hotel Receptionist</span></li>
<li><span>Legal Secretary</span></li>
<li><span>Payroll Administrator</span></li>
<li><span>Liaison Officers </span></li>
<li><span>Supervisor</span></li>
<li><span>Typist.</span></li>
</ul>
		</div><table width="100%">				<tbody><tr>
					<td colspan="4">Administrative Management</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Module One - Getting Started</td>
					<td> </td>
					<td><span><i></i> 00:30:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Module Two - Why Your Office Needs Administrative Procedures</td>
					<td> </td>
					<td><span><i></i> 01:00:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Module Three - Gathering the Right Tools</td>
					<td> </td>
					<td><span><i></i> 01:00:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Module Four - Identifying Procedures to Include</td>
					<td> </td>
					<td><span><i></i> 01:00:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Module Five - Top Five Procedures to Record</td>
					<td> </td>
					<td><span><i></i> 01:00:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Module Six - What to Include in Your Binder (I)</td>
					<td> </td>
					<td><span><i></i> 01:00:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Module Seven - What to Include in Your Binder (II)</td>
					<td> </td>
					<td><span><i></i> 01:00:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Module Eight - Organizing Your Binder</td>
					<td> </td>
					<td><span><i></i> 01:00:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Module Nine - What Not to Include in the Procedure Guide</td>
					<td> </td>
					<td><span><i></i> 01:00:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Module Ten - Share Office Procedure Guide</td>
					<td> </td>
					<td><span><i></i> 01:00:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Module Eleven - Successfully Executing the Guide</td>
					<td> </td>
					<td><span><i></i> 01:00:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Module Twelve - Wrapping Up</td>
					<td> </td>
					<td><span><i></i> 00:30:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Admin Support</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Module One - Getting Started</td>
					<td> </td>
					<td><span><i></i> 00:30:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Module Two - Getting Organized (I)</td>
					<td> </td>
					<td><span><i></i> 01:00:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Module Three - Getting Organized (II)</td>
					<td> </td>
					<td><span><i></i> 01:00:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Module Four - Managing Time</td>
					<td> </td>
					<td><span><i></i> 01:00:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Module Five - Getting It All Done On Time</td>
					<td> </td>
					<td><span><i></i> 01:00:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Module Six - Special Tasks</td>
					<td> </td>
					<td><span><i></i> 01:00:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Module Seven - Verbal Communication Skills</td>
					<td> </td>
					<td><span><i></i> 01:00:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Module Eight - Non-Verbal Communication Skills</td>
					<td> </td>
					<td><span><i></i> 01:00:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Module Nine - Empowering Yourself</td>
					<td> </td>
					<td><span><i></i> 01:00:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Module Ten - The Team of Two</td>
					<td> </td>
					<td><span><i></i> 01:00:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Module Eleven - Taking Care of Yourself</td>
					<td> </td>
					<td><span><i></i> 01:00:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Module Twelve - Wrapping Up</td>
					<td> </td>
					<td><span><i></i> 00:30:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Microsoft Word</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Module One - Getting Started</td>
					<td> </td>
					<td><span><i></i> 00:30:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Module Two - Opening</td>
					<td> </td>
					<td><span><i></i> 01:00:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Module Three - Working with the Interface</td>
					<td> </td>
					<td><span><i></i> 01:00:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Module Four - Your First Document</td>
					<td> </td>
					<td><span><i></i> 01:00:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Module Five - Basic Editing Tasks</td>
					<td> </td>
					<td><span><i></i> 01:00:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Module Six - Basic Formatting Tasks</td>
					<td> </td>
					<td><span><i></i> 01:00:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Module Seven - Formatting Paragraphs</td>
					<td> </td>
					<td><span><i></i> 01:00:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Module Eight - Advanced Formatting Tasks</td>
					<td> </td>
					<td><span><i></i> 01:00:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Module Nine - Working with Styles</td>
					<td> </td>
					<td><span><i></i> 01:00:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Module Ten - Formatting the Page</td>
					<td> </td>
					<td><span><i></i> 01:00:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Module Eleven - Sharing Your Document</td>
					<td> </td>
					<td><span><i></i> 01:00:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Module Twelve - Wrapping Up</td>
					<td> </td>
					<td><span><i></i> 00:30:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Microsoft PowerPoint</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Module One - Getting Started</td>
					<td> </td>
					<td><span><i></i> 00:30:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Module Two - Opening PowerPoint</td>
					<td> </td>
					<td><span><i></i> 01:00:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Module Three - Working with the Interface</td>
					<td> </td>
					<td><span><i></i> 01:00:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Module Four - Your First Presentation</td>
					<td> </td>
					<td><span><i></i> 01:00:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Module Five - Working with Text</td>
					<td> </td>
					<td><span><i></i> 01:00:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Module Six - Formatting Text and Paragraphs</td>
					<td> </td>
					<td><span><i></i> 01:00:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Module Seven - Adding Pictures</td>
					<td> </td>
					<td><span><i></i> 01:00:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Module Eight - Advanced Formatting Tasks</td>
					<td> </td>
					<td><span><i></i> 01:00:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Module Nine - Working with Transitions and Animations</td>
					<td> </td>
					<td><span><i></i> 01:00:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Module Ten - Setting Up Your Slide Show</td>
					<td> </td>
					<td><span><i></i> 01:00:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Module Eleven - Showtime!</td>
					<td> </td>
					<td><span><i></i> 01:00:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Module Twelve - Wrapping Up</td>
					<td> </td>
					<td><span><i></i> 00:30:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Microsoft Excel</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Module One - Getting Started</td>
					<td> </td>
					<td><span><i></i> 00:30:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Module Two - Opening Excel</td>
					<td> </td>
					<td><span><i></i> 01:00:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Module Three - Working with the Interface</td>
					<td> </td>
					<td><span><i></i> 01:00:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Module Four - Your First Worksheet</td>
					<td> </td>
					<td><span><i></i> 01:00:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Module Five - Viewing Excel Data</td>
					<td> </td>
					<td><span><i></i> 01:00:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Module Six - Building Formulas</td>
					<td> </td>
					<td><span><i></i> 01:00:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Module Seven - Using Excel Functions</td>
					<td> </td>
					<td><span><i></i> 01:00:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Module Eight - Using Quick Analysis</td>
					<td> </td>
					<td><span><i></i> 01:00:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Module Nine - Formatting Your Data</td>
					<td> </td>
					<td><span><i></i> 01:00:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Module Ten - Using Styles, Themes, and Effects</td>
					<td> </td>
					<td><span><i></i> 01:00:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Module Eleven - Printing and Sharing Your Workbook</td>
					<td> </td>
					<td><span><i></i> 01:00:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Module Twelve - Wrapping Up</td>
					<td> </td>
					<td><span><i></i> 01:00:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Microsoft Access</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Module One - Getting Started</td>
					<td> </td>
					<td><span><i></i> 00:30:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Module Two - Opening and Closing Access</td>
					<td> </td>
					<td><span><i></i> 01:00:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Module Three - An Introduction to Databases</td>
					<td> </td>
					<td><span><i></i> 01:00:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Module Four - Sharing Data Using Apps</td>
					<td> </td>
					<td><span><i></i> 01:00:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Module Five - Working in Your App</td>
					<td> </td>
					<td><span><i></i> 01:00:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Module Six - An Introduction to Desktop Databases</td>
					<td> </td>
					<td><span><i></i> 01:00:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Module Seven - Performing Basic Table Tasks</td>
					<td> </td>
					<td><span><i></i> 01:00:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Module Eight - Working with Fields</td>
					<td> </td>
					<td><span><i></i> 01:00:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Module Nine - Working with Table Relationships</td>
					<td> </td>
					<td><span><i></i> 01:00:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Module Ten - An Introduction to Queries, Forms, and Reports</td>
					<td> </td>
					<td><span><i></i> 01:00:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Module Eleven - Protecting Your Data</td>
					<td> </td>
					<td><span><i></i> 01:00:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Module Twelve - Wrapping Up</td>
					<td> </td>
					<td><span><i></i> 00:30:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Mock Exam </td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Mock Exam- Diploma in Administrative Management</td>
					<td> </td>
					<td><span><i></i> 00:20:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Final Exam</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Final Exam- Diploma in Administrative Management</td>
					<td> </td>
					<td><span><i></i> 00:20:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Certificate and Transcript</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Order Your Certificates and Transcripts</td>
					<td> </td>
					<td><span><i></i> 00:00:00</span></td>
				</tr>
				</tbody></table>

Administrative Assistant

Business Administration

Office Management

Business Admin

Diploma in Administrative Management

<p id="isPasted" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Our <strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Mastering Microsoft Office: Word, Excel, PowerPoint, and 365</strong> course provides an in-depth exploration of Excel 2021, starting with the basics of creating spreadsheets, entering data, and understanding relative references. Progress to more advanced topics like data handling, page setup, sorting, filtering, and writing sophisticated formulas, including VLOOKUP, HLOOKUP, and the 2021 exclusive XLOOKUP. Learn to create compelling charts and pivot tables that bring your data to life.</p><p style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;" id="isPasted" fr-original-style=" color: var(--text);">In PowerPoint 2021, start with presentation basics and advance to incorporating graphic assets, multimedia, and SmartArt graphics. Master text formatting, bullet options, and table and chart integration to create professional and engaging presentations. Explore the full suite of PowerPoint features, including transitions, animations, and slideshow effects, to captivate your audience.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">The Word 2021 modules guide you through document creation, formatting, and layout management. Learn to work with tables, styles, and mail merges. Additionally, discover the collaboration and productivity features of Office 365, which enable seamless sharing and editing across platforms.</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;">Learning Outcomes of Mastering Microsoft Office: Word, Excel, PowerPoint, and 365 Course:</strong></p><ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">Master the fundamentals of Excel 2021, including entering data and working with ranges.</li><li fr-original-style="" style="box-sizing: border-box;">Create and modify Excel charts and pivot tables for data analysis.</li><li fr-original-style="" style="box-sizing: border-box;">Develop PowerPoint presentations with advanced animations and multimedia elements.</li><li fr-original-style="" style="box-sizing: border-box;">Format documents in Word 2021, including creating tables and managing styles.</li><li fr-original-style="" style="box-sizing: border-box;">Execute mail merges and manage page layouts effectively in Word 2021.</li><li fr-original-style="" style="box-sizing: border-box;">Utilise Office 365 features for enhanced productivity and collaboration.</li><li fr-original-style="" style="box-sizing: border-box;">Understand and apply advanced Excel formulas like VLOOKUP, HLOOKUP, and XLOOKUP.</li></ul><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;">The Course Curriculum of&nbsp;Mastering Microsoft Office: Word, Excel, PowerPoint, and 365:</strong></p><ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">Section 01: Getting Started</li><li fr-original-style="" style="box-sizing: border-box;">Section 02: Excel 2021: Basics</li><li fr-original-style="" style="box-sizing: border-box;">Section 03: Excel 2021: Rows, Columns, And Cells</li><li fr-original-style="" style="box-sizing: border-box;">Section 04: Excel 2021: Data Handling</li><li fr-original-style="" style="box-sizing: border-box;">Section 05: Excel 2021: Page Setting Up And Print</li><li fr-original-style="" style="box-sizing: border-box;">Section 06: Excel 2021: Sorting And Filtering</li><li fr-original-style="" style="box-sizing: border-box;">Section 07: Excel 2021: Writing Formulas</li><li fr-original-style="" style="box-sizing: border-box;">Section 08: Excel 2021: Advanced Formulas</li><li fr-original-style="" style="box-sizing: border-box;">Section 09: Excel 2021: XLOOKUP Only For 2021 And Office 365</li><li fr-original-style="" style="box-sizing: border-box;">Section 10: Excel 2021: Data And Tools</li><li fr-original-style="" style="box-sizing: border-box;">Section 11: Excel 2021: Formatting Data And Tables</li><li fr-original-style="" style="box-sizing: border-box;">Section 12: Excel 2021: Pivot Tables</li><li fr-original-style="" style="box-sizing: border-box;">Section 13: Excel 2021: Charts</li><li fr-original-style="" style="box-sizing: border-box;">Section 14: PowerPoint 2021: Course Introduction</li><li fr-original-style="" style="box-sizing: border-box;">Section 15: PowerPoint 2021: Basics</li><li fr-original-style="" style="box-sizing: border-box;">Section 16: PowerPoint 2021: Text And Bullet Options</li><li fr-original-style="" style="box-sizing: border-box;">Section 17: PowerPoint 2021: Adding Graphic Assets</li><li fr-original-style="" style="box-sizing: border-box;">Section 18: PowerPoint 2021: Picture Formatting</li><li fr-original-style="" style="box-sizing: border-box;">Section 19: PowerPoint 2021: SmartArt Graphics</li><li fr-original-style="" style="box-sizing: border-box;">Section 20: PowerPoint 2021: Working With Tables</li><li fr-original-style="" style="box-sizing: border-box;">Section 21: PowerPoint 2021: Working With Charts</li><li fr-original-style="" style="box-sizing: border-box;">Section 22: PowerPoint 2021: Adding Multimedia</li><li fr-original-style="" style="box-sizing: border-box;">Section 23: PowerPoint 2021: Working With Transition</li><li fr-original-style="" style="box-sizing: border-box;">Section 24: PowerPoint 2021: Animation</li><li fr-original-style="" style="box-sizing: border-box;">Section 25: PowerPoint 2021: Slideshow Effects</li><li fr-original-style="" style="box-sizing: border-box;">Section 26: Word 2021: Introduction</li><li fr-original-style="" style="box-sizing: border-box;">Section 27: Word 2021: Basics</li><li fr-original-style="" style="box-sizing: border-box;">Section 28: Word 2021: Word Formatting</li><li fr-original-style="" style="box-sizing: border-box;">Section 29: Word 2021: Tables</li><li fr-original-style="" style="box-sizing: border-box;">Section 30: Word 2021: Styles</li><li fr-original-style="" style="box-sizing: border-box;">Section 31: Word 2021: Page Layout</li><li fr-original-style="" style="box-sizing: border-box;">Section 32: Word 2021: Envelops And Lables</li><li fr-original-style="" style="box-sizing: border-box;">Section 33: Word 2021: Mail Merges</li><li fr-original-style="" style="box-sizing: border-box;">Section 34: Word 2021: Review And Printing</li></ul><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;">Who is this course for:</strong></p><ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">Professionals seeking to enhance their productivity with Microsoft Office tools.</li><li fr-original-style="" style="box-sizing: border-box;">Students aiming to improve their technical skills for academic purposes.</li><li fr-original-style="" style="box-sizing: border-box;">Administrative staff needing comprehensive knowledge of Office applications.</li><li fr-original-style="" style="box-sizing: border-box;">Individuals looking to advance their careers with proficiency in Word, Excel, and PowerPoint.</li></ul><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;">Certification of Mastering Microsoft Office: Word, Excel, PowerPoint, and 365 Course:<br fr-original-style="" style="box-sizing: border-box;"></strong></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><a href="https://cpdqs.co.uk/" target="_blank" rel="noopener noreferrer" fr-original-style="" style="user-select: auto; font-size: var(--font-size); box-sizing: border-box; cursor: pointer; text-decoration: inherit;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">CPD QS</strong></a> certificates are available at an additional cost of &pound;9.99 for a PDF, &pound;16.99 for a printed hard copy, and &pound;24.99 for both PDF and printed versions.</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;">Requirements:</strong></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">This course has no academic entry requirements and is accessible to students from all backgrounds.</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;">Career Path:</strong></p><ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Administrative Assistant:</strong> &pound;18,000 - &pound;25,000 per annum</li><li fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Data Analyst:</strong> &pound;25,000 - &pound;40,000 per annum</li><li fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Office Manager:</strong> &pound;22,000 - &pound;35,000 per annum</li><li fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Project Coordinator:</strong> &pound;23,000 - &pound;37,000 per annum</li><li fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Executive Assistant:</strong> &pound;25,000 - &pound;45,000 per annum</li><li fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">IT Support Specialist:</strong> &pound;22,000 - &pound;38,000 per annum</li></ul><p id="isPasted" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><em fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Enrol now and advance your Microsoft Office skills to a professional level.</strong></em></p>

Our Mastering Microsoft Office: Word, Excel, PowerPoint, and 365 course provides an in-depth exploration of Excel 2021, starting with the basics of creating spreadsheets, entering data, and understanding relative references. Progress to more advanced topics like data handling, page setup, sorting, filtering, and writing sophisticated formulas, including VLOOKUP, HLOOKUP, and the 2021 exclusive XLOOKUP. Learn to create compelling charts and pivot tables that bring your data to life.
In PowerPoint 2021, start with presentation basics and advance to incorporating graphic assets, multimedia, and SmartArt graphics. Master text formatting, bullet options, and table and chart integration to create professional and engaging presentations. Explore the full suite of PowerPoint features, including transitions, animations, and slideshow effects, to captivate your audience.
The Word 2021 modules guide you through document creation, formatting, and layout management. Learn to work with tables, styles, and mail merges. Additionally, discover the collaboration and productivity features of Office 365, which enable seamless sharing and editing across platforms.
Learning Outcomes of Mastering Microsoft Office: Word, Excel, PowerPoint, and 365 Course:
Master the fundamentals of Excel 2021, including entering data and working with ranges.
Create and modify Excel charts and pivot tables for data analysis.
Develop PowerPoint presentations with advanced animations and multimedia elements.
Format documents in Word 2021, including creating tables and managing styles.
Execute mail merges and manage page layouts effectively in Word 2021.
Utilise Office 365 features for enhanced productivity and collaboration.
Understand and apply advanced Excel formulas like VLOOKUP, HLOOKUP, and XLOOKUP.
The Course Curriculum of Mastering Microsoft Office: Word, Excel, PowerPoint, and 365:
Section 01: Getting Started
Section 02: Excel 2021: Basics
Section 03: Excel 2021: Rows, Columns, And Cells
Section 04: Excel 2021: Data Handling
Section 05: Excel 2021: Page Setting Up And Print
Section 06: Excel 2021: Sorting And Filtering
Section 07: Excel 2021: Writing Formulas
Section 08: Excel 2021: Advanced Formulas
Section 09: Excel 2021: XLOOKUP Only For 2021 And Office 365
Section 10: Excel 2021: Data And Tools
Section 11: Excel 2021: Formatting Data And Tables
Section 12: Excel 2021: Pivot Tables
Section 13: Excel 2021: Charts
Section 14: PowerPoint 2021: Course Introduction
Section 15: PowerPoint 2021: Basics
Section 16: PowerPoint 2021: Text And Bullet Options
Section 17: PowerPoint 2021: Adding Graphic Assets
Section 18: PowerPoint 2021: Picture Formatting
Section 19: PowerPoint 2021: SmartArt Graphics
Section 20: PowerPoint 2021: Working With Tables
Section 21: PowerPoint 2021: Working With Charts
Section 22: PowerPoint 2021: Adding Multimedia
Section 23: PowerPoint 2021: Working With Transition
Section 24: PowerPoint 2021: Animation
Section 25: PowerPoint 2021: Slideshow Effects
Section 26: Word 2021: Introduction
Section 27: Word 2021: Basics
Section 28: Word 2021: Word Formatting
Section 29: Word 2021: Tables
Section 30: Word 2021: Styles
Section 31: Word 2021: Page Layout
Section 32: Word 2021: Envelops And Lables
Section 33: Word 2021: Mail Merges
Section 34: Word 2021: Review And Printing
Who is this course for:
Professionals seeking to enhance their productivity with Microsoft Office tools.
Students aiming to improve their technical skills for academic purposes.
Administrative staff needing comprehensive knowledge of Office applications.
Individuals looking to advance their careers with proficiency in Word, Excel, and PowerPoint.
Certification of Mastering Microsoft Office: Word, Excel, PowerPoint, and 365 Course:
CPD QS Accredited PDF Certificate - Included
CPD QS Accredited Hard Copy Certificate - Not Included
Requirements:
This course has no academic entry requirements and is accessible to students from all backgrounds.
Career Path:
Administrative Assistant: £18,000 - £25,000 per annum
Data Analyst: £25,000 - £40,000 per annum
Office Manager: £22,000 - £35,000 per annum
Project Coordinator: £23,000 - £37,000 per annum
Executive Assistant: £25,000 - £45,000 per annum
IT Support Specialist: £22,000 - £38,000 per annum
Enrol now and advance your Microsoft Office skills to a professional level.

St. Paul's College

Microsoft Powerpoint

Start your productivity potential! Master Microsoft Office with our comprehensive Mastering Microsoft Office: Word, Excel, PowerPoint, and 365 course. Conquer Excel formulas (VLOOKUP, HLOOKUP, XLOOKUP!), design impactful presentations in PowerPoint, and craft professional documents in Word. Take your skills to the next level and unlock a world of opportunity. Enrol now and become a Microsoft Office pro!

Mastering Microsoft Office: Word, Excel, PowerPoint, and 365

<div id="course-pricing" fr-original-style="" style="box-sizing: border-box;">
<br fr-original-style="" style="box-sizing: border-box;"></div><div fr-original-style="" style="box-sizing: border-box;">

<p id="isPasted" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">The Personal Finance With Excel course offers a comprehensive learning experience for individuals aiming to enhance their financial acumen and Excel proficiency. Participants will gain the ability to set and achieve smart financial goals, understand the intricacies of personal and behavioural finance, and develop robust risk profiling and investment strategies. The course leverages Excel&#39;s powerful tools for meticulous financial planning, expense tracking, and credit management, enabling learners to improve their credit ratings and make well-informed financial decisions.&nbsp;</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Upon successful completion, participants can obtain a CPD certificate, enhancing their professional profile and opening doors to career opportunities in financial advisory, planning, analysis, and investment sectors.</p><h2 dir="ltr" id="isPasted" fr-original-style="" style="box-sizing: border-box;"><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color:#000000;">Learning Outcome of Personal Finance With Excel &nbsp; &nbsp; &nbsp;</span></h2>

<ul fr-original-style="" style="box-sizing: border-box;">
<li id="isPasted" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Set smart financial goals and create a plan to achieve them.</li>
<li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Understand the rules of personal finance and behavioural finance principles.</li>
<li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Learn risk profiling, asset allocation, and investment strategies.</li>
<li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Utilize Excel for financial planning, expense tracking, and credit management.</li>
<li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Improve your credit rating and make informed financial decisions with credit reports.</li>
</ul>

<h2 dir="ltr" fr-original-style="" style="box-sizing: border-box;"><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color:#000000;">Key Features of the Course</span></h2>

<ul fr-original-style="" style="box-sizing: border-box;">
<li dir="ltr" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;"><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);">A CPD certificate that is recognised worldwide.</span></li>
<li dir="ltr" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;"><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);">A great online learning experience.</span></li>
<li dir="ltr" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;"><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);">Interesting and unique online materials and activities.</span></li>
<li dir="ltr" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;"><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);">Expert guidance and support from the field leaders.</span></li>
<li dir="ltr" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;"><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);">Access to the study resources anytime you want.</span></li>
<li dir="ltr" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;"><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);">Friendly and helpful customer service and admin support by email, phone, and chat from Monday through Friday.</span></li>
<li dir="ltr" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;"><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);">Get a year-long access to the course.</span></li>
</ul>

<h2 dir="ltr" fr-original-style="" style="box-sizing: border-box;"><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color:#000000;">Topics Covered in This Course</span></h2><ul fr-original-style="" style="box-sizing: border-box;"><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Unit 1: Smart Goals&nbsp; &nbsp; &nbsp; &nbsp;&nbsp;</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Unit 2: Rules of Personal Finance&nbsp; &nbsp; &nbsp; &nbsp;&nbsp;</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Unit 3: Behavioural finance&nbsp; &nbsp; &nbsp; &nbsp;&nbsp;</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Unit 4: Risk Profiling Asset Allocation&nbsp; &nbsp; &nbsp; &nbsp;&nbsp;</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Unit 5: Foundations of Investments&nbsp; &nbsp; &nbsp; &nbsp;&nbsp;</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Unit 6: Financial Planner&nbsp; &nbsp; &nbsp; &nbsp;&nbsp;</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Unit 7: Specific Goal Planning&nbsp; &nbsp; &nbsp; &nbsp;&nbsp;</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Unit 8: Credit Loan Facilities&nbsp; &nbsp; &nbsp; &nbsp;&nbsp;</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Unit 9: Expense Planner&nbsp; &nbsp; &nbsp; &nbsp;&nbsp;</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Unit 10: Credit Rating, Score and Report&nbsp; &nbsp; &nbsp; &nbsp;&nbsp;</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Unit 11: Ten Pro Tips</li></ul>

<h2 dir="ltr" fr-original-style="" style="box-sizing: border-box;"><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color:#000000;">Who is this course for</span></h2>

<p dir="ltr" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color:#000000;">This Personal Finance With Excel &nbsp;Course is suitable for -</span></p><ul fr-original-style="" style="box-sizing: border-box;"><li id="isPasted" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Individuals seeking to manage their personal finances more effectively.</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Excel users interested in applying their skills to financial planning.</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Anyone looking to improve their financial literacy and make informed money decisions.</li></ul><h2 dir="ltr" id="isPasted" fr-original-style="" style="box-sizing: border-box;"><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color:#000000;">Requirements</span></h2><ul fr-original-style="" style="box-sizing: border-box;"><li dir="ltr" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;"><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);">No prerequisites; suitable for individuals from any academic background.</span></li><li dir="ltr" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;"><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);">Accessible course materials from any internet-enabled device.</span></li></ul><h2 dir="ltr" fr-original-style="" style="box-sizing: border-box;"><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color:#000000;">CPD Certificate from Course Gate</span></h2><p dir="ltr" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color:#000000;">At the successful completion of the course, you can obtain your CPD certificate from us. You can order the PDF certificate for &pound;9 and the hard copy for &pound;15. Also, you can order both PDF and hardcopy certificates for &pound;22.</span></p><h2 dir="ltr" fr-original-style="" style="box-sizing: border-box;"><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color:#000000;">Career path</span></h2><ul fr-original-style="" style="box-sizing: border-box;"><li id="isPasted" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Personal finance advisor.</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Financial planner.</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Budget analyst.</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Credit analyst.</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Investment analyst.</li></ul>
</div>

Course Gate

Personal Finance

Financial Management

Financial Literacy

Online Education

Take control of your personal finances with our Personal Finance With Excel course. Learn essential financial concepts and practical Excel skills to manage your money effectively. From setting smart goals to understanding investments and credit facilities, this hands-on class will empower you to make informed financial decisions using Excel.

Personal Finance With Excel

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



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


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


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


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


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


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


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

Bayfield Training

Financial Modelling & Analysis

Financial Modelling

Professional Development

Property & Real Estate Photography

Continuous Professional Development (CPD)

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

Real Estate Analyst (Investment Cash Flow Modelling in Excel)

In-Person 

Virtual



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


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


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


Who will benefit from this School?
Real Estate professionals at any level with exposure to real estate financial models on a frequent basis
Junior or new Real Estate Analysts who would like to start building their own real estate models quickly, rather than relying solely on coaching from existing team members
Mid-level to senior Real Estate Analysts
Real Estate Managers who would like to gain an understanding of the dynamics of debt and financial return fluctuations in more detail
Property industry modellers who would like to be fully proficient in building complex financial models


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


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


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


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


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


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


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


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


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

Property Investment

Financial Analysis

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

Real Estate Investment School (Investment Cash Flow Modelling)

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

Access VBA

Visual Basic Analysis

Microsoft Power Automate

Excel - Automating Excel with Macros and Analysis Tools

<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="menu0">
									<div>
			<div>
				<div>
							<section>
						<div>
				<div>
				<div>
			<div>
					<div>
				<div>
				<div>
					<div><h3><strong><span>Overview</span></strong></h3></div>
				</div>
				</div>
				<div>
				<div>
					<div><p>This Microsoft Excel: Master Power Query course will unlock your full potential and will show you how to <strong>excel in a career in Microsoft Excel: Master Power Query</strong>. So upskill now and reach your full potential. Everything you need to get started in Microsoft Excel: Master Power Query is available in this course.</p><p>Learning and progressing are the hallmarks of personal development. This Microsoft Excel: Master Power Query will <strong>quickly teach you the must-have</strong> <strong>skills</strong> needed to start in the relevant industry.</p></div>
				</div>
				</div>
						</div>
			</div>
		</div>
						</div>
			</div>
		</section>
				<section>
						<div>
				<div>
				<div>
			<div>
					<div>
				<div>
				<div>
					<div>
							
					<div></div>
										<div></div>
														
							
					<div></div>
										<div></div>
														
							
					<div></div>
										<div></div>
														
							
					<div></div>
										<div></div>
														
					</div>
			</div>
				</div>
						</div>
			</div>
		</div>
						</div>
			</div>
		</section>
				<section>
						<div>
				<div>
				<div>
			<div>
					<div>
				<div>
				<div>
					<div><h3><strong><span>In This Microsoft Excel: Master Power Query<br />Course, You Will:</span></strong></h3></div>
				</div>
				</div>
						</div>
			</div>
		</div>
						</div>
			</div>
		</section>
				<section>
						<div>
				<div>
				<div>
			<div>
					<div>
				<div>
				<div>
					<div><ul><li>Learn strategies to boost your workplace efficiency.</li><li>Hone your Microsoft Excel: Master Power Query skills to help you advance your career.</li><li>Acquire a comprehensive understanding of various Microsoft Excel: Master Power Query topics and tips from industry experts.</li><li>Learn in-demand Microsoft Excel: Master Power Query skills that are in <strong>high demand among UK employers</strong>, which will help you to kickstart your career.</li></ul></div>
				</div>
				</div>
				<div>
				<div>
					<div><p>This Microsoft Excel: Master Power Query course covers everything you must know to stand against the tough competition in the Microsoft Excel: Master Power Query field. </p><p>The future is truly yours to seize with this Microsoft Excel: Master Power Query. Enrol today and complete the course to achieve a Microsoft Excel: Master Power Query <strong>certificate</strong> that can change your professional career forever.</p></div>
				</div>
				</div>
						</div>
			</div>
		</div>
						</div>
			</div>
		</section>
				<section>
						<div>
				<div>
				<div>
			<div>
					<div>
				<div>
				<div>
					<div><h3><strong><span>Additional Perks of Buying a Course From Institute of Mental Health</span></strong><b></b></h3></div>
				</div>
				</div>
				<div>
				<div>
					<div><ul><li>Study online - whenever and wherever you want.</li><li>One-to-one support from a dedicated tutor throughout your course.</li><li>Certificate immediately upon course completion</li><li>100% Money back guarantee</li><li>Exclusive discounts on your next course purchase from Institute of Mental Health </li></ul></div>
				</div>
				</div>
				<div>
				<div>
					<div><p>Enrolling in the Microsoft Excel: Master Power Query course can assist you in getting into your desired career quicker than you ever imagined. So without further ado, start now.</p></div>
				</div>
				</div>
						</div>
			</div>
		</div>
						</div>
			</div>
		</section>
				<section>
						<div>
				<div>
				<div>
			<div>
					<div>
				<div>
				<div>
					<div></div>
				</div>
				</div>
				<div>
				<div>
					<div><h3><strong><span>Process of Evaluation</span></strong></h3></div>
				</div>
				</div>
				<div>
				<div>
					<div><section><div><div><div><div><div><div><div><div><p>After studying the Microsoft Excel: Master Power Query course, your skills and knowledge will be tested with a MCQ exam or assignment. You must get a score of 60% to pass the test and get your certificate. </p></div></div></div></div></div></div></div></div></section></div>
				</div>
				</div>
						</div>
			</div>
		</div>
						</div>
			</div>
		</section>
				<section>
						<div>
				<div>
				<div>
			<div>
					<div>
				<div>
				<div>
					<div><h3><strong><span>Certificate of Achievement</span><span><br /></span></strong></h3></div>
				</div>
				</div>
				<div>
				<div>
					<div><p>Upon successfully completing the Microsoft Excel: Master Power Query course, you will get your CPD accredited digital certificate immediately. And you can also claim the hardcopy certificate completely free of charge. All you have to do is pay a shipping charge of just £3.99.</p></div>
				</div>
				</div>
						</div>
			</div>
		</div>
						</div>
			</div>
		</section>
				<section>
						<div>
				<div>
				<div>
			<div>
					<div>
				<div>
				<div>
					<div><h3><strong><span>Who Is This Course for?</span></strong></h3></div>
				</div>
				</div>
				<div>
				<div>
					<div><p>This Microsoft Excel: Master Power Query is suitable for anyone aspiring to start a career in Microsoft Excel: Master Power Query; even if you are new to this and have no prior knowledge on Microsoft Excel: Master Power Query, this course is going to be very easy for you to understand. </p><p>And if you are already working in the Microsoft Excel: Master Power Query field, this course will be a great source of knowledge for you to improve your existing skills and take them to the next level. </p><p>Taking this Microsoft Excel: Master Power Query course is a win-win for you in all aspects. </p><p>This course has been developed with maximum flexibility and accessibility, making it ideal for people who don't have the time to devote to traditional education.</p></div>
				</div>
				</div>
						</div>
			</div>
		</div>
						</div>
			</div>
		</section>
				<section>
						<div>
				<div>
				<div>
			<div>
					<div>
				<div>
				<div>
					<div><h3><strong><span>Requirements</span></strong></h3></div>
				</div>
				</div>
				<div>
				<div>
					<div><p>This Microsoft Excel: Master Power Query course has no prerequisite. </p><p>You don't need any educational qualification or experience to enrol in the Microsoft Excel: Master Power Query course.</p><p>Do note: you must be at least 16 years old to enrol.</p><p>Any internet-connected device, such as a computer, tablet, or smartphone, can access this online Microsoft Excel: Master Power Query course.</p><p>Moreover, this course allows you to learn at your own pace while developing transferable and marketable skills.</p></div>
				</div>
				</div>
						</div>
			</div>
		</div>
						</div>
			</div>
		</section>
						</div>
			</div>
		</div>
								</div>
						<div id="menu1">
							<div>
											<div>
				<h3>
	<span>Course Curriculum</span>
</h3>

<div>
<table>				<tbody><tr>
					<td colspan="4">Microsoft Excel: Master Power Query</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Power Query Intro and Excel version</td>
					<td> </td>
					<td><span><i></i> 00:03:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Excel Power Query - Introduction</td>
					<td> </td>
					<td><span><i></i> 00:03:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Excel Power Query - Query Editor Ribbon</td>
					<td> </td>
					<td><span><i></i> 00:09:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Transform Data - Trim in Excel Power Query</td>
					<td> </td>
					<td><span><i></i> 00:05:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Transform Data - Format Dates and Values in Excel Power Query</td>
					<td> </td>
					<td><span><i></i> 00:02:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Transform Data - Parsing URLs in Excel Power Query</td>
					<td> </td>
					<td><span><i></i> 00:05:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Transform Data - Split Text Fields in Excel Power Query</td>
					<td> </td>
					<td><span><i></i> 00:10:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Transform Data - Group By in Excel Power Query</td>
					<td> </td>
					<td><span><i></i> 00:03:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Transform Data - Unpivoting Columns in Excel Power Query</td>
					<td> </td>
					<td><span><i></i> 00:05:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Transform Data - Pivoting Columns in Excel Power Query</td>
					<td> </td>
					<td><span><i></i> 00:02:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Transform Data - Split Columns into Other Columns in Excel Power Query</td>
					<td> </td>
					<td><span><i></i> 00:04:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Transform Data - Filtering Rows in Excel Power Query</td>
					<td> </td>
					<td><span><i></i> 00:05:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Transform Data - Sorting Columns in Excel Power Query</td>
					<td> </td>
					<td><span><i></i> 00:02:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Transform Data - Transform and Add Columns in Excel Power Query</td>
					<td> </td>
					<td><span><i></i> 00:07:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>From Folder - Import From Folder in Excel Power Query</td>
					<td> </td>
					<td><span><i></i> 00:07:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>From Folder - Doing Auto Cleanup in Excel Power Query</td>
					<td> </td>
					<td><span><i></i> 00:13:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>From Folder - Extract Data from Forms in Excel Power Query</td>
					<td> </td>
					<td><span><i></i> 00:13:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>From Workbook - Extract Multiple Criteria in Excel Power Query</td>
					<td> </td>
					<td><span><i></i> 00:05:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>From Workbook - Extract Multiple Worksheets in Excel Power Query</td>
					<td> </td>
					<td><span><i></i> 00:04:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Joins - Intro to Joins</td>
					<td> </td>
					<td><span><i></i> 00:04:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Joins - Merging</td>
					<td> </td>
					<td><span><i></i> 00:08:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Joins - Full Outer Join</td>
					<td> </td>
					<td><span><i></i> 00:06:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Joins - Right Anti Join</td>
					<td> </td>
					<td><span><i></i> 00:09:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Power Query - Convert Reports into Pivot Tables</td>
					<td> </td>
					<td><span><i></i> 00:05:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Modulo</td>
					<td> </td>
					<td><span><i></i> 00:06:00</span></td>
				</tr>
				</tbody></table></div>

			</div>
									</div>
						</div>
						<div id="menu2">
							
						</div>

Overview
This Microsoft Excel: Master Power Query course will unlock your full potential and will show you how to excel in a career in Microsoft Excel: Master Power Query. So upskill now and reach your full potential. Everything you need to get started in Microsoft Excel: Master Power Query is available in this course.
Learning and progressing are the hallmarks of personal development. This Microsoft Excel: Master Power Query will quickly teach you the must-have skills needed to start in the relevant industry.
In This Microsoft Excel: Master Power Query
Course, You Will:
Learn strategies to boost your workplace efficiency.
Hone your Microsoft Excel: Master Power Query skills to help you advance your career.
Acquire a comprehensive understanding of various Microsoft Excel: Master Power Query topics and tips from industry experts.
Learn in-demand Microsoft Excel: Master Power Query skills that are in high demand among UK employers, which will help you to kickstart your career.
This Microsoft Excel: Master Power Query course covers everything you must know to stand against the tough competition in the Microsoft Excel: Master Power Query field. 
The future is truly yours to seize with this Microsoft Excel: Master Power Query. Enrol today and complete the course to achieve a Microsoft Excel: Master Power Query certificate that can change your professional career forever.
Additional Perks of Buying a Course From Institute of Mental Health
Study online - whenever and wherever you want.
One-to-one support from a dedicated tutor throughout your course.
Certificate immediately upon course completion
100% Money back guarantee
Exclusive discounts on your next course purchase from Institute of Mental Health
Enrolling in the Microsoft Excel: Master Power Query course can assist you in getting into your desired career quicker than you ever imagined. So without further ado, start now.
Process of Evaluation
After studying the Microsoft Excel: Master Power Query course, your skills and knowledge will be tested with a MCQ exam or assignment. You must get a score of 60% to pass the test and get your certificate. 
Certificate of Achievement

Upon successfully completing the Microsoft Excel: Master Power Query course, you will get your CPD accredited digital certificate immediately. And you can also claim the hardcopy certificate completely free of charge. All you have to do is pay a shipping charge of just £3.99.
Who Is This Course for?
This Microsoft Excel: Master Power Query is suitable for anyone aspiring to start a career in Microsoft Excel: Master Power Query; even if you are new to this and have no prior knowledge on Microsoft Excel: Master Power Query, this course is going to be very easy for you to understand. 
And if you are already working in the Microsoft Excel: Master Power Query field, this course will be a great source of knowledge for you to improve your existing skills and take them to the next level. 
Taking this Microsoft Excel: Master Power Query course is a win-win for you in all aspects. 
This course has been developed with maximum flexibility and accessibility, making it ideal for people who don't have the time to devote to traditional education.
Requirements
This Microsoft Excel: Master Power Query course has no prerequisite. 
You don't need any educational qualification or experience to enrol in the Microsoft Excel: Master Power Query course.
Do note: you must be at least 16 years old to enrol.
Any internet-connected device, such as a computer, tablet, or smartphone, can access this online Microsoft Excel: Master Power Query course.
Moreover, this course allows you to learn at your own pace while developing transferable and marketable skills.
 Course Curriculum

Microsoft Excel: Master Power Query			
	Power Query Intro and Excel version		00:03:00
	Excel Power Query - Introduction		00:03:00
	Excel Power Query - Query Editor Ribbon		00:09:00
	Transform Data - Trim in Excel Power Query		00:05:00
	Transform Data - Format Dates and Values in Excel Power Query		00:02:00
	Transform Data - Parsing URLs in Excel Power Query		00:05:00
	Transform Data - Split Text Fields in Excel Power Query		00:10:00
	Transform Data - Group By in Excel Power Query		00:03:00
	Transform Data - Unpivoting Columns in Excel Power Query		00:05:00
	Transform Data - Pivoting Columns in Excel Power Query		00:02:00
	Transform Data - Split Columns into Other Columns in Excel Power Query		00:04:00
	Transform Data - Filtering Rows in Excel Power Query		00:05:00
	Transform Data - Sorting Columns in Excel Power Query		00:02:00
	Transform Data - Transform and Add Columns in Excel Power Query		00:07:00
	From Folder - Import From Folder in Excel Power Query		00:07:00
	From Folder - Doing Auto Cleanup in Excel Power Query		00:13:00
	From Folder - Extract Data from Forms in Excel Power Query		00:13:00
	From Workbook - Extract Multiple Criteria in Excel Power Query		00:05:00
	From Workbook - Extract Multiple Worksheets in Excel Power Query		00:04:00
	Joins - Intro to Joins		00:04:00
	Joins - Merging		00:08:00
	Joins - Full Outer Join		00:06:00
	Joins - Right Anti Join		00:09:00
	Power Query - Convert Reports into Pivot Tables		00:05:00
	Modulo		00:06:00

IOMH - Institute of Mental Health

Microsoft Excel: Master Power Query

<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

Risk Management

Investment

Financial Risk Management

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

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

<div>
									<section>
						<div>
					<div>
			<div>
								<div>
				<div>
			<h2>Overview</h2>		</div>
				</div>
				<div>
				<div>
							<p><span>Microsoft Excel Course for Everyone - Complete Excel Course is yet another 'Teacher's Choice' course from Teachers Training for a complete understanding of the fundamental topics. You are also entitled to exclusive tutor support and a professional CPD-accredited certificate in addition to the special discounted price for a limited time. Just like all our courses, this Microsoft Excel Course for Everyone - Complete Excel Course and its curriculum have also been designed by expert teachers so that teachers of tomorrow can learn from the best and equip themselves with all the necessary skills.</span></p><p><span>Consisting of several modules, the course teaches you everything you need to succeed in this profession.</span></p><p><span>The course can be studied part-time. You can become accredited within 05 Hours studying at your own pace. Your qualification will be recognised and can be checked for validity on our dedicated website.</span></p>						</div>
				</div>
					</div>
		</div>
							</div>
		</section>
				<section>
						<div>
					<div>
			<div>
								<div>
				<div>
			<h3><b>Why Choose Teachers Training</b></h3>		</div>
				</div>
				<div>
				<div>
			<p>Some of our website features are:</p>		</div>
				</div>
				<div>
				<div>
					<ul>
							<li>
											<span>
													</span>
										<span>This is a dedicated website for teaching</span>
									</li>
								<li>
											<span>
													</span>
										<span>24/7 tutor support</span>
									</li>
								<li>
											<span>
													</span>
										<span>Interactive Content</span>
									</li>
								<li>
											<span>
													</span>
										<span>Affordable price</span>
									</li>
								<li>
											<span>
													</span>
										<span>Courses accredited by the UK's top awarding bodies</span>
									</li>
								<li>
											<span>
													</span>
										<span>100% online </span>
									</li>
								<li>
											<span>
													</span>
										<span>Flexible deadline</span>
									</li>
						</ul>
				</div>
				</div>
					</div>
		</div>
							</div>
		</section>
				<section>
						<div>
					<div>
			<div>
								<div>
				<div>
			<h3><b> Entry Requirements
</b></h3>		</div>
				</div>
				<div>
				<div>
			<p>No formal entry requirements. You need to have:</p>		</div>
				</div>
				<div>
				<div>
					<ul>
							<li>
											<span>
													</span>
										<span>Passion for learning</span>
									</li>
								<li>
											<span>
													</span>
										<span>A good understanding of the English language</span>
									</li>
								<li>
											<span>
													</span>
										<span>Be motivated and hard-working</span>
									</li>
								<li>
											<span>
													</span>
										<span>Over the age of 16.</span>
									</li>
						</ul>
				</div>
				</div>
					</div>
		</div>
							</div>
		</section>
				<section>
						<div>
					<div>
			<div>
								<div>
				<div>
			<h3><b>Certification</b></h3>		</div>
				</div>
				<div>
				<div>
							<p><strong>CPD Certification from The Teachers Training</strong></p><p>Successfully completing the MCQ exam of this course qualifies you for a CPD-accredited certificate from The Teachers Training. You will be eligible for both PDF copy and hard copy of the certificate to showcase your achievement however you wish.</p><ul><li>You can get your digital certificate (PDF) for £4.99 only</li><li>Hard copy certificates are also available, and you can get one for only £10.99</li><li>You can get both PDF and Hard copy certificates for just £12.99!</li></ul><p>The certificate will add significant weight to your CV and will give you a competitive advantage when applying for jobs.</p>						</div>
				</div>
					</div>
		</div>
							</div>
		</section>
							</div><table width="100%">				<tbody><tr>
					<td colspan="4">Section 01: Getting Started</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Introduction</td>
					<td> </td>
					<td><span><i></i> 00:03:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Course Curriculum</td>
					<td> </td>
					<td><span><i></i> 00:04:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Getting started on Windows, macOS, Android, and IOS</td>
					<td> </td>
					<td><span><i></i> 00:01:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>How to ask great questions</td>
					<td> </td>
					<td><span><i></i> 00:02:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>FAQ's</td>
					<td> </td>
					<td><span><i></i> 00:01:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Starting Excel</td>
					<td> </td>
					<td><span><i></i> 00:04:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Section 02: Excel Basics</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Introduction</td>
					<td> </td>
					<td><span><i></i> 00:02:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Worksheet basics</td>
					<td> </td>
					<td><span><i></i> 00:22:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Entering values and formulas</td>
					<td> </td>
					<td><span><i></i> 00:12:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Data formats</td>
					<td> </td>
					<td><span><i></i> 00:10:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Data handling basics - cut copy and paste</td>
					<td> </td>
					<td><span><i></i> 00:07:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Save and print in excel</td>
					<td> </td>
					<td><span><i></i> 00:10:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Excel Ranges</td>
					<td> </td>
					<td><span><i></i> 00:05:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Section 03: Excel essential functions</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Introduction</td>
					<td> </td>
					<td><span><i></i> 00:01:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Basic formula operations</td>
					<td> </td>
					<td><span><i></i> 00:06:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Mathematical functions level 1</td>
					<td> </td>
					<td><span><i></i> 00:20:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Mathematical functions level 2</td>
					<td> </td>
					<td><span><i></i> 00:12:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Text functions level 1</td>
					<td> </td>
					<td><span><i></i> 00:09:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Text functions level 2</td>
					<td> </td>
					<td><span><i></i> 00:13:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Logical functions</td>
					<td> </td>
					<td><span><i></i> 00:11:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Date time functions</td>
					<td> </td>
					<td><span><i></i> 00:06:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>V Lookup formula</td>
					<td> </td>
					<td><span><i></i> 00:12:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>HLookup formula</td>
					<td> </td>
					<td><span><i></i> 00:04:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>HLookup + Match formula</td>
					<td> </td>
					<td><span><i></i> 00:09:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Match + Index formula</td>
					<td> </td>
					<td><span><i></i> 00:05:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Section 04: XLookup only for Excel 2021 and Office 365</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Introduction</td>
					<td> </td>
					<td><span><i></i> 00:02:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>XLookup</td>
					<td> </td>
					<td><span><i></i> 00:08:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Handling #NA and Approximates match in XLookup</td>
					<td> </td>
					<td><span><i></i> 00:11:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Wildcard matching in XLookup</td>
					<td> </td>
					<td><span><i></i> 00:06:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Section 05: Get Data and tools</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Introduction</td>
					<td> </td>
					<td><span><i></i> 00:02:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Split text into columns</td>
					<td> </td>
					<td><span><i></i> 00:07:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Flash Fill</td>
					<td> </td>
					<td><span><i></i> 00:07:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Remove Duplicates</td>
					<td> </td>
					<td><span><i></i> 00:08:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Data Validation</td>
					<td> </td>
					<td><span><i></i> 00:07:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Get- import Data from Text</td>
					<td> </td>
					<td><span><i></i> 00:06:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Get - import Data from CSV</td>
					<td> </td>
					<td><span><i></i> 00:03:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Section 06: Formatting data and tables</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Introduction</td>
					<td> </td>
					<td><span><i></i> 00:01:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Formatting Font</td>
					<td> </td>
					<td><span><i></i> 00:04:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Formatting Alignment</td>
					<td> </td>
					<td><span><i></i> 00:06:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Formatting Number</td>
					<td> </td>
					<td><span><i></i> 00:05:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Formatting Date</td>
					<td> </td>
					<td><span><i></i> 00:03:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Formatting tables</td>
					<td> </td>
					<td><span><i></i> 00:05:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Section 07: Pivot Tables</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Introduction</td>
					<td> </td>
					<td><span><i></i> 00:01:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Creating Pivot Table</td>
					<td> </td>
					<td><span><i></i> 00:07:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Value field settings</td>
					<td> </td>
					<td><span><i></i> 00:04:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Number format</td>
					<td> </td>
					<td><span><i></i> 00:02:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Pivot Table Design</td>
					<td> </td>
					<td><span><i></i> 00:03:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Excel Exercise</td>
					<td> </td>
					<td><span><i></i> 00:01:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Solution for Excel Exercise</td>
					<td> </td>
					<td><span><i></i> 00:02:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Section 08: Excel Charts</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Introduction</td>
					<td> </td>
					<td><span><i></i> 00:01:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Excel Charts - Categories</td>
					<td> </td>
					<td><span><i></i> 00:03:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Elements of a chart</td>
					<td> </td>
					<td><span><i></i> 00:04:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Easy way to create charts</td>
					<td> </td>
					<td><span><i></i> 00:02:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Column or Bar charts</td>
					<td> </td>
					<td><span><i></i> 00:04:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Formatting charts</td>
					<td> </td>
					<td><span><i></i> 00:04:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Line charts</td>
					<td> </td>
					<td><span><i></i> 00:02:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Area charts</td>
					<td> </td>
					<td><span><i></i> 00:02:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Pie and Doughnut charts</td>
					<td> </td>
					<td><span><i></i> 00:04:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Format AreaPlot or XY chart</td>
					<td> </td>
					<td><span><i></i> 00:08:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Scatter or bubble charts</td>
					<td> </td>
					<td><span><i></i> 00:02:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Section 09: Advanced Excel charts</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Introduction</td>
					<td> </td>
					<td><span><i></i> 00:01:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Frequency Distribution and Histograms</td>
					<td> </td>
					<td><span><i></i> 00:04:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Waterfall charts</td>
					<td> </td>
					<td><span><i></i> 00:02:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Hierarchy charts: sunburst and tree map</td>
					<td> </td>
					<td><span><i></i> 00:03:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Combination charts</td>
					<td> </td>
					<td><span><i></i> 00:02:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Sparklines</td>
					<td> </td>
					<td><span><i></i> 00:05:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Section 10: Pivot Charts</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Pivot charts</td>
					<td> </td>
					<td><span><i></i> 00:02:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Section 11: Maps Chart above 2019</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Maps chart</td>
					<td> </td>
					<td><span><i></i> 00:04:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>3D Maps chart</td>
					<td> </td>
					<td><span><i></i> 00:03:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Section 12: Business-Geo charts</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Introduction</td>
					<td> </td>
					<td><span><i></i> 00:01:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Stock charts</td>
					<td> </td>
					<td><span><i></i> 00:02:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Radar charts</td>
					<td> </td>
					<td><span><i></i> 00:02:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Surface charts</td>
					<td> </td>
					<td><span><i></i> 00:02:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Heat maps</td>
					<td> </td>
					<td><span><i></i> 00:04:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Section 13: Named Ranges</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Named ranges</td>
					<td> </td>
					<td><span><i></i> 00:05:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Indirect Name range Function</td>
					<td> </td>
					<td><span><i></i> 00:06:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Section 14: Import Data into Excel</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Import Data table from PDF file - Excel 2021</td>
					<td> </td>
					<td><span><i></i> 00:04:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Import Data from Website - Excel 2019 above</td>
					<td> </td>
					<td><span><i></i> 00:09:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Section 15: Advanced Excel</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Project: Sales forecast tracker</td>
					<td> </td>
					<td><span><i></i> 00:07:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Product Sale Tax invoice: Tax Calculations</td>
					<td> </td>
					<td><span><i></i> 00:05:00</span></td>
				</tr>
				</tbody></table>

Microsoft Excel Course for Everyone – Complete Excel Course is yet another “Teacher’s Choice” course from Teachers Training for a complete understanding of the fundamental topics. You are also entitled to exclusive tutor support and a professional CPD-accredited certificate in addition to the special discounted price for a limited time. Just like all our courses, this Microsoft Excel Course for Everyone – Complete Excel Course and its curriculum have also been designed by expert teachers so that teachers of tomorrow can learn from the best and equip themselves with all the necessary skills.
Consisting of several modules, the course teaches you everything you need to succeed in this profession.
The course can be studied part-time. You can become accredited within 05 Hours studying at your own pace. Your qualification will be recognised and can be checked for validity on our dedicated website.
Course Curriculum
Section 01: Getting Started
Section 02: Excel Basics
Section 03: Excel essential functions
Section 04: XLookup only for Excel 2021 and Office 365
Section 05: Get Data and tools
Section 06: Formatting data and tables
Section 07: Pivot Tables
Section 08: Excel Charts
Section 09: Advanced Excel charts
Section 10: Pivot Charts
Section 11: Maps Chart above 2019
Section 12: Business-Geo charts
Section 13: Named Ranges
Section 14: Import Data into Excel
Section 15: Advanced Excel
Why Choose Teachers Training
Some of our website features are:
This is a dedicated website for teaching
24/7 tutor support
Interactive Content
Affordable price
Courses accredited by the UK's top awarding bodies
100% online
Flexible deadline
Entry Requirements
No formal entry requirements. You need to have:
Passion for learning
A good understanding of the English language
Be motivated and hard-working
Over the age of 16.
Certification
CPD Certification from The Teachers Training
Successfully completing the MCQ exam of this course qualifies you for a CPD-accredited certificate from The Teachers Training. You will be eligible for both PDF copy and hard copy of the certificate to showcase your achievement however you wish.
You can get your digital certificate (PDF) for £4.99 only
Hard copy certificates are also available, and you can get one for only £10.99
You can get both PDF and Hard copy certificates for just £12.99!
The certificate will add significant weight to your CV and will give you a competitive advantage when applying for jobs.

The Teachers Training

Unlock the full potential of Microsoft Excel with our course for everyone. Learn essential skills and advanced techniques to excel in any data-driven role.

Microsoft Excel Course for Everyone - Complete Excel Course

Overview
★★ 24 Hour Limited Time Flash Sale ★★
Diploma in Microsoft Excel at QLS Level 5
***Key Features of Diploma in Microsoft Excel at QLS Level 5***
Free QLS Certificate
Free CPD PDF Certificate + Transcript
Are you tired of searching for suitable courses which will meet your requirements?
Distracted by various ads and need help figuring out where to invest in getting an incredible learning experience??
Stop scrolling and hit the enrol button of Diploma in Microsoft Excel at QLS Level 5 course launched by Skill Up to stand out from the crowd in the area of your interest.
The UK Job Market is on the verge of relentless competition. As a result, there is an increasing demand for experienced professionals in the related sector, and this area is expanding towards all directions. Considering the current situation, we did adequate research and came up with a required Diploma in Microsoft Excel at QLS Level 5 course that sheds light on the core knowledge of Microsoft Excel.
The QLS endorsement of the Diploma in Microsoft Excel at QLS Level 5 course guarantees high standards and quality assurance. This endorsement reflects the course's commitment to excellence in education and skill development.
This premium online training titled Diploma in Microsoft Excel at QLS Level 5 ensures your professional development with CPD accreditation. You’ll have the privilege of learning in your own time, at your own pace and earning an accredited certification.
This Diploma in Microsoft Excel at QLS Level 5 course is developed by industry experts and is packed with several insightful modules to properly understand Microsoft Excel and allow you to accelerate your career.
Facilities that you will receive after enrolling on The Diploma in Microsoft Excel at QLS Level 5 course From Skill Up
Eligibility for CPD-accredited certificate on successful completion of the Diploma in Microsoft Excel at QLS Level 5 course
Learning materials of our Diploma in Microsoft Excel at QLS Level 5 course contain engaging voiceover and visual elements for your comfort
Freedom to study at your own pace
24/7 access to the Diploma in Microsoft Excel at QLS Level 5 course materials for 12 months
Full Tutor support on weekdays (Monday – Friday)
Certificates
Digital Certificate
This course comes with a free CPD Accredited PDF Copy certificate+ Transcript (according to the Learner's Choice). For additional courses, it costs £14.99 per copy.
Level 5 QLS Endorsed Hardcopy Certificate
Hard copy certificate - Included
Certificate delivery is Free for UK residents, whereas it costs £10 for international students as a delivery charge.
Note: Skill-up is a Janets-approved resale partner for Quality Licence Scheme Endorsed courses.
Hard Copy Certificate
Get CPD Accredited Hard Copy certificate for £19.99 per copy. The delivery fee for the Hard Copy certificate, however, is free for UK residents, whereas it costs £10 for international students as delivery charge.
Course Description
This Diploma in Microsoft Excel at QLS Level 5 online training course has been designed by industry experts and will give you an in-depth understanding of this topic. The Diploma in Microsoft Excel at QLS Level 5 course features easy-to-digest modules that break down each topic and ensure all our students receive an unrivalled and thorough learning experience.
On the Diploma in Microsoft Excel at QLS Level 5 course, we guarantee that you will gain relevant skills and acquire tremendous knowledge on the subject. The certificate you’ll achieve after completing the Diploma in Microsoft Excel at QLS Level 5 course will help you land the job you want in a related field.
Who is this course for?
The Diploma in Microsoft Excel at QLS Level 5 course is ideal for highly motivated individuals who want to enhance their professional skills and train for the job they want! This Diploma in Microsoft Excel at QLS Level 5 course also suits people aspiring for in-depth knowledge on this topic and keeping up to date with the latest information.
Study the Diploma in Microsoft Excel at QLS Level 5 course today and increase your professional skillset from the comfort of your home!
Requirements
There are no formal entry requirements for the Diploma in Microsoft Excel at QLS Level 5 course, with enrolment open to anyone! Anyone and everyone with a knack for learning can enrol on this course without any hesitation.
Learn online from any internet device, including your computer, tablet or smartphone. Study when it suits you and complete the Diploma in Microsoft Excel at QLS Level 5 course at your own pace.
All students must have a passion for learning and literacy and be over the age of 16.
Career path
Studying the Diploma in Microsoft Excel at QLS Level 5 course is designed to help you get the job of your dreams, or even that promotion you’ve always wanted. Learn the essential skills and knowledge you need to excel in your professional life with the help & guidance from our Diploma in Microsoft Excel at QLS Level 5 course.

Skill Up

Diploma in Professional Studies (DPS)

Level 5 QLS Endorsed Diploma | 150 CPD Points | +Gifts: QLS Certificate + PDF Certificate | 24/7 Learner Support


Diploma in Microsoft Excel at QLS Level 5


<p>Enroll now to go through a deep dive of the most popular spreadsheet tool on the market, Microsoft Excel. As your instructor, <strong>Deb Ashby with more than 15+ years of Excel training, guides you step by step through the beginner to advanced level and beyond.</strong></p>
<p>At completion of this course you will have mastered the most popular Excel tools and come out with confidence to complete any Excel tasks with efficiency and grace. Below are just a few of the topics that you will master:</p>
<ul>
<li>Creating effective spreadsheets</li>
<li>Managing large sets of data</li>
<li>Mastering the use of some of Excel's most popular and highly sought after functions (SUM, VLOOKUP, IF, AVERAGE, INDEX/MATCH and many more...)</li>
<li>Create dynamic report with Excel PivotTables</li>
<li>Unlock the power and versatility of Microsoft Excel's Add-In, PowerPivot</li>
<li>Audit Excel Worksheet formulas to ensure clean formulas</li>
</ul>
<p>So, what are you waiting for, <strong>enroll now and take the next step in mastering Excel and go from Excel Newbie to Excel Guru!</strong></p>
<p><strong>Method of Assessment</strong></p>
<p>To successfully complete the Microsoft Excel course, students will have to take an automated multiple-choice exam. This exam will be online and you will need to score 60% or above to pass the Microsoft Excel course. After successfully passing the Microsoft Excel course exam, you will be able to apply for a CPD-accredited certificate as proof of your Microsoft Excel qualification.</p>
<p><strong>Certification</strong></p>
<p>All students who successfully complete the Microsoft Excel course can instantly download their free e-certificate. You can also purchase a hard copy of the Microsoft Excel course certificate, which will be delivered by post for &pound;9.99.</p>

Vnnergy LLC

Computing Skills

Computing & IT

Follow your dreams by enrolling on the Microsoft Excel course today and develop the experience, skills and knowledge you need to enhance your professional development. Microsoft Excel will help you arm yourself with the qualities you need to work towards your dream job.

Microsoft Excel - basics to expert

Learn at your own pace at your convenience

General admission

Get access to more hidden treasures and become an excel wizard. Shared frequently cheat sheets, resources, tips and tricks to help you at every step

Elite access

<div id="course-pills-1">Duration<p>1 Days</p><p>6 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>Identify general components of VBA and their appropriate use in solving business solutions. Record VBA macros to automate repetitive tasks. Write VBA code to create VBA subroutines and functions. Use various programming elements to solve problems through code, including variables,objects, conditional statements, and loops. Eliminate, avoid, or handle errors in VBA code, and optimize its performance.</p><p>VBA (Visual Basic for Applications) enables you to enhance and extend the capabilities of Microsoft Excel and other applications in the Microsoft 365 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 so they can be performed faster, more consistently, and with less effort than performing them manually. This course will give you a good foundation for understanding, creating, and using VBA in your own Excel workbooks. You will learn how to use the macro recorder effectively, as well as how to write your own VBA code from scratch. You will use tools built into Excel to explore and learn VBA's capabilities and to optimize and debug your code.</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>Use Macros to Automate Tasks in Excel</li> <li>Identify Components of Macro-Enabled Workbooks</li> <li>Configure the Excel VBA Environment</li></ul>  <h3>2. Recording a Macro</h3><ul> <li>Use the Macro Recorder to Create a VBA Macro</li> <li>Record a Macro with Relative Addressing</li> <li>Delete Macros and Modules</li> <li>Identify Strategies for Using the Macro Recorder</li></ul>  <h3>3. Writing VBA Code Directly</h3><ul> <li>Write VBA Code</li> <li>Discover Objects You Can Use</li> <li>Create a Custom Function</li></ul>  <h3>4. Solving Problems through Code</h3><ul> <li>Make Decisions in Code</li> <li>Work with Variables</li> <li>Perform Repetitive Tasks</li></ul>  <h3>5. Improving Your VBA Code</h3><ul> <li>Debug VBA Errors</li> <li>Deal with Errors</li> <li>Improve Macro Performance</li></ul>  <h3>6.  Controlling How and When Macros Run</h3><ul> <li>Prompt the User for Information</li> <li>Configure Macros to Run Automatically</li></ul></div><div id="course-pills-3"><h4>Additional course details:</h4><br /><p>Nexus Humans VBA with Microsoft Excel (v1.2) 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 VBA with Microsoft Excel (v1.2) 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>

971 Microsoft Excel courses delivered Online

Microsoft Office for Admin

By Studyhub UK

Microsoft PowerPoint 2016/2019/365 - Foundations for Beginners

By Study Plex

Microsoft Office 2016 Complete Bundle Course (Word, Excel, PowerPoint, Outlook and Access)

By John Academy

Microsoft Project 2021 From Beginners to Advanced

By Packt

Data Analysis In Excel

By Janets