Name: Powerful Functions in Microsoft Excel
Price: 11.99 GBP
Availability: InStock

Dive deep into the world of spreadsheet mastery with our 'Data Analysis, Automating and Visualisation in Excel' course. This comprehensive programme takes you on a transformative journey from the rudiments of worksheet modifications to the advanced arts of data forecasting. Within each module, you'll unveil the secrets behind efficient list management, compelling visualisations, and the magic of PivotTables, among many other features. Moreover, automation isn't left behind; it's the heart and soul, making your workbook a living entity that breathes efficiency. By the end, you'll not only be fluent in Excel's vast toolkit but also possess the flair to present data in engaging, insightful ways.
Learning Outcomes:
<ol>
<li>Master the art of efficient worksheet modification and effective list management.</li>
<li>Harness the power of data analysis tools to make informed decisions.</li>
<li>Craft compelling visuals using charts, Sparklines, and data mapping techniques.</li>
<li>Implement PivotTables and PivotCharts to dissect complex data sets effortlessly.</li>
<li>Automate workbook functionalities for optimised and streamlined processes.</li>
</ol>
 
<div>
Video Player<div id="mep_0"><div><div>https://studyhub.org.uk/wp-content/uploads/2021/03/Data-Analysis-Automating-and-Visualisation-in-Excel.mp4</div><div><div></div><div><div></div></div><div><div></div></div><div><div></div></div></div><div><div></div><div>00:00</div><div>00:00</div><div>00:00</div><div>Use Up/Down Arrow keys to increase or decrease volume.<div><div></div><div></div></div></div><div></div></div></div></div></div>
<h3></h3>
<h3>Why buy this Data Analysis, Automating and Visualisation in Excel?</h3>
<ol>
<li>Unlimited access to the course for a lifetime.</li>
<li>Opportunity to earn a certificate accredited by the CPD Quality Standards after completing this course.</li>
<li>Structured lesson planning in line with industry standards.</li>
<li>Immerse yourself in innovative and captivating course materials and activities.</li>
<li>Assessments are designed to evaluate advanced cognitive abilities and skill proficiency.</li>
<li>Flexibility to complete the Data Analysis, Automating and Visualisation in Excel Course at your own pace, on your own schedule.</li>
<li>Receive full tutor support throughout the week, from Monday to Friday, to enhance your learning experience</li>
</ol>
<h3>Who is this Data Analysis, Automating and Visualisation in Excel course for?</h3>
<ul>
<li>Individuals looking to enhance their data visualisation and analysis prowess.</li>
<li>Managers wanting a streamlined approach to handling large datasets.</li>
<li>Academic researchers aiming to present their data in a more compelling format.</li>
<li>Finance professionals seeking efficient ways to dissect and forecast financial data.</li>
<li>Marketing strategists aiming to leverage data for improved decision-making.</li>
</ul>
<h3>Career path</h3>
<ul>
<li>Data Analyst: £30,000 - £50,000 per annum</li>
<li>Financial Analyst: £35,000 - £55,000 per annum</li>
<li>Market Research Analyst: £28,000 - £45,000 per annum</li>
<li>Business Intelligence Analyst: £32,000 - £56,000 per annum</li>
<li>Operations Analyst: £30,000 - £52,000 per annum</li>
<li>Research Scientist (Data-oriented): £35,000 - £60,000 per annum</li>
</ul>
<h3>Prerequisites</h3>
This Data Analysis, Automating and Visualisation in Excel does not require you to have any prior qualifications or experience. You can just enrol and start learning.This Data Analysis, Automating and Visualisation in Excel was made by professionals and it is compatible with all PC's, Mac's, tablets and smartphones. You will be able to access the course from anywhere at any time as long as you have a good enough internet connection.
<h3>Certification</h3>
After studying the course materials, there will be a written assignment test which you can take at the end of the course. After successfully passing the test you will be able to claim the pdf certificate for £4.99 Original Hard Copy certificates need to be ordered at an additional cost of £8.<div>
				<h3>
	Course Curriculum
</h3>

<div>
<table width="100%">				<tbody><tr>
					<td colspan="4">Modifying a Worksheet</td>
				</tr>
								<tr>
					<td></td>
					<td>Insert, Delete, and Adjust Cells, Columns, and Rows</td>
					<td> </td>
					<td> 00:10:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Search for and Replace Data</td>
					<td> </td>
					<td> 00:09:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Use Proofing and Research Tools</td>
					<td> </td>
					<td> 00:07:00</td>
				</tr>
								<tr>
					<td colspan="4">Working with Lists</td>
				</tr>
								<tr>
					<td></td>
					<td>Sort Data</td>
					<td> </td>
					<td> 00:10:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Filter Data</td>
					<td> </td>
					<td> 00:10:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Query Data with Database Functions</td>
					<td> </td>
					<td> 00:09:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Outline and Subtotal Data</td>
					<td> </td>
					<td> 00:09:00</td>
				</tr>
								<tr>
					<td colspan="4">Analyzing Data</td>
				</tr>
								<tr>
					<td></td>
					<td>Apply Intermediate Conditional Formatting</td>
					<td> </td>
					<td> 00:07:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Apply Advanced Conditional Formatting</td>
					<td> </td>
					<td> 00:05:00</td>
				</tr>
								<tr>
					<td colspan="4">Visualizing Data with Charts</td>
				</tr>
								<tr>
					<td></td>
					<td>Create Charts</td>
					<td> </td>
					<td> 00:13:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Modify and Format Charts</td>
					<td> </td>
					<td> 00:12:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Use Advanced Chart Features</td>
					<td> </td>
					<td> 00:12:00</td>
				</tr>
								<tr>
					<td colspan="4">Using PivotTables and PivotCharts</td>
				</tr>
								<tr>
					<td></td>
					<td>Create a PivotTable</td>
					<td> </td>
					<td> 00:13:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Analyze PivotTable Data</td>
					<td> </td>
					<td> 00:12:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Present Data with PivotCharts</td>
					<td> </td>
					<td> 00:07:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Filter Data by Using Timelines and Slicers</td>
					<td> </td>
					<td> 00:11:00</td>
				</tr>
								<tr>
					<td colspan="4">Working with Multiple Worksheets and Workbooks</td>
				</tr>
								<tr>
					<td></td>
					<td>Use Links and External References</td>
					<td> </td>
					<td> 00:12:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Use 3-D References</td>
					<td> </td>
					<td> 00:06:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Consolidate Data</td>
					<td> </td>
					<td> 00:05:00</td>
				</tr>
								<tr>
					<td colspan="4">Using Lookup Functions and Formula Auditing</td>
				</tr>
								<tr>
					<td></td>
					<td>Use Lookup Functions</td>
					<td> </td>
					<td> 00:12:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Trace Cells</td>
					<td> </td>
					<td> 00:09:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Watch and Evaluate Formulas</td>
					<td> </td>
					<td> 00:08:00</td>
				</tr>
								<tr>
					<td colspan="4">Automating Workbook Functionality</td>
				</tr>
								<tr>
					<td></td>
					<td>Apply Data Validation</td>
					<td> </td>
					<td> 00:13:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Search for Invalid Data and Formulas with Errors</td>
					<td> </td>
					<td> 00:04:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Work with Macros</td>
					<td> </td>
					<td> 00:18:00</td>
				</tr>
								<tr>
					<td colspan="4">Creating Sparklines and Mapping Data</td>
				</tr>
								<tr>
					<td></td>
					<td>Create Sparklines</td>
					<td> </td>
					<td> 00:07:00</td>
				</tr>
								<tr>
					<td></td>
					<td>MapData</td>
					<td> </td>
					<td> 00:07:00</td>
				</tr>
								<tr>
					<td colspan="4">Forecasting Data</td>
				</tr>
								<tr>
					<td></td>
					<td>Determine Potential Outcomes Using Data Tables</td>
					<td> </td>
					<td> 00:08:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Determine Potential Outcomes Using Scenarios</td>
					<td> </td>
					<td> 00:09:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Use the Goal Seek Feature</td>
					<td> </td>
					<td> 00:04:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Forecasting Data Trends</td>
					<td> </td>
					<td> 00:05:00</td>
				</tr>
								<tr>
					<td colspan="4">Assignment</td>
				</tr>
								<tr>
					<td></td>
					<td>Assignment - Data Analysis, Automating and Visualisation in Excel</td>
					<td> </td>
					<td> 00:00:00</td>
				</tr>
				</tbody></table></div>

			</div>

Studyhub UK

Excel Analytics

Microsoft Excel

Data Analysis

Data Skills

Data Analyst

Business Data Analysis

Data Analysis, Automating and Visualisation in Excel

General Admission

<div> <div> </div> <div> <div> <div> <h3>Highlights of the Course</h3> <ul> <li>Course Type: Online Learning</li> <li>Duration: 2 Hours 5 Minutes</li> <li>Tutor Support: Tutor support is included</li> <li>Customer Support: 24/7 customer support is available</li> <li>Quality Training: The course is designed by an industry expert</li> <li>Recognised Credential: Recognised and Valuable Certification</li> <li>Completion Certificate: Free Course Completion Certificate Included</li> <li>Instalment: 3 Installment Plan on checkout</li> </ul> </div> </div> <div> <div> <hr /> <h3>What you will learn from this course?</h3> <ul> <li>Gain comprehensive knowledge about Microsoft Office Excel</li> <li>Understand the core competencies and principles of Microsoft Office Excel</li> <li>Explore the various areas of Microsoft Office Excel</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> <div> <div> <div> <hr /> <div> <div> <div> <h3>Microsoft Office Excel 2016: Part 1 Beginner Level Course</h3> Master the skills you need to propel your career forward in Microsoft Office Excel. 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 excel beginner level course is designed to help you surpass your professional goals. The skills and knowledge that you will gain through studying this excel beginner level course will help you get one step closer to your professional aspirations and develop your skills for a rewarding career. This comprehensive course will teach you the theory of effective Microsoft Office Excel practice and equip you with the essential skills, confidence and competence to assist you in the Microsoft Office Excel industry. You'll gain a solid understanding of the core competencies required to drive a successful career in Microsoft Office Excel. 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 Office Excel. Enrol in this excel beginner level 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. </div> <div> <h3>Who is this Course for?</h3> This comprehensive excel beginner level 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 Office Excel can also take this course. 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. </div> <div> <h3>Entry Requirements</h3> This excel beginner level 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. </div> <div> <h3>Assessment</h3> This excel beginner level 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%. </div> <div> <h3>Advance Your Career</h3> This excel beginner level 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. </div> </div> </div> </div> </div> </div> </div> </div><h3>Recognised Accreditation</h3> 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.<div> <h3> Course Curriculum </h3> <div> <table> <tbody><tr> <td colspan="4">Getting Started With Excel 2016</td> </tr> <tr> <td></td> <td> Navigate the Excel User Interface - Introduction </td> <td> </td> <td> 00:01:00</td> </tr> <tr> <td></td> <td> Navigate the Excel User Interface </td> <td> </td> <td> 00:06:00</td> </tr> <tr> <td></td> <td> Use Excel Commands - Introduction </td> <td> </td> <td> 00:01:00</td> </tr> <tr> <td></td> <td> Use Excel Commands - Introduction </td> <td> </td> <td> 00:01:00</td> </tr> <tr> <td></td> <td> Create and Save a Basic Workbook - Introduction </td> <td> </td> <td> 00:05:00</td> </tr> <tr> <td></td> <td> Create and Save a Basic Workbook </td> <td> </td> <td> 00:05:00</td> </tr> <tr> <td></td> <td> Enter Cell Data - Introduction </td> <td> </td> <td> 00:01:00</td> </tr> <tr> <td></td> <td> Enter Cell Data </td> <td> </td> <td> 00:05:00</td> </tr> <tr> <td></td> <td> Flash Fill and Auto Fill </td> <td> </td> <td> 00:04:00</td> </tr> <tr> <td></td> <td> Use Excel Help - Introduction </td> <td> </td> <td> 00:01:00</td> </tr> <tr> <td></td> <td> Use Excel Help </td> <td> </td> <td> 00:03:00</td> </tr> <tr> <td colspan="4">Performing Calculations</td> </tr> <tr> <td></td> <td> Create Worksheet Formulas - Introduction </td> <td> </td> <td> 00:01:00</td> </tr> <tr> <td></td> <td> Create Worksheet Formulas </td> <td> </td> <td> 00:06:00</td> </tr> <tr> <td></td> <td> Insert Functions - Introduction </td> <td> </td> <td> 00:01:00</td> </tr> <tr> <td></td> <td> Insert Functions </td> <td> </td> <td> 00:05:00</td> </tr> <tr> <td></td> <td> Reuse Formulas and Functions - Introduction </td> <td> </td> <td> 00:01:00</td> </tr> <tr> <td></td> <td> Reuse Formulas and Functions </td> <td> </td> <td> 00:05:00</td> </tr> <tr> <td colspan="4">Modifying a Worksheet</td> </tr> <tr> <td></td> <td> Insert, Delete and Adjust Cells, Columns and Rows </td> <td> </td> <td> 00:04:00</td> </tr> <tr> <td></td> <td> Search for and Replace Data </td> <td> </td> <td> 00:06:00</td> </tr> <tr> <td></td> <td> Insert, Delete and Adjust Cells, Columns and Rows - Introduction </td> <td> </td> <td> 00:01:00</td> </tr> <tr> <td></td> <td> Use Proofing and Research Tools </td> <td> </td> <td> 00:01:00</td> </tr> <tr> <td></td> <td> Check the Spelling in a Worksheet </td> <td> </td> <td> 00:03:00</td> </tr> <tr> <td></td> <td> Search for and Replace Data - Introduction </td> <td> </td> <td> 00:01:00</td> </tr> <tr> <td></td> <td> Insights Task Pane </td> <td> </td> <td> 00:03:00</td> </tr> <tr> <td colspan="4">Formatting a Worksheet</td> </tr> <tr> <td></td> <td> Apply Text Formats - Introduction </td> <td> </td> <td> 00:01:00</td> </tr> <tr> <td></td> <td> Apply Text Formats </td> <td> </td> <td> 00:06:00</td> </tr> <tr> <td></td> <td> Apply Number Formats - Introduction </td> <td> </td> <td> 00:02:00</td> </tr> <tr> <td></td> <td> Apply Number Formats </td> <td> </td> <td> 00:03:00</td> </tr> <tr> <td></td> <td> Align Cell Contents - Introduction </td> <td> </td> <td> 00:01:00</td> </tr> <tr> <td></td> <td> Align Cell Contents </td> <td> </td> <td> 00:03:00</td> </tr> <tr> <td></td> <td> Apply Cell Styles and Themes </td> <td> </td> <td> 00:06:00</td> </tr> <tr> <td></td> <td> Apply Cell Styles and Themes - Introduction </td> <td> </td> <td> 00:01:00</td> </tr> <tr> <td></td> <td> Create and Use Templates - Introduction </td> <td> </td> <td> 00:01:00</td> </tr> <tr> <td></td> <td> Apply Basic Conditional Formatting - Introduction </td> <td> </td> <td> 00:01:00</td> </tr> <tr> <td></td> <td> Apply Basic Conditional Formatting </td> <td> </td> <td> 00:03:00</td> </tr> <tr> <td></td> <td> Create and Use Templates </td> <td> </td> <td> 00:04:00</td> </tr> <tr> <td colspan="4">Printing Workbooks</td> </tr> <tr> <td></td> <td> Preview and Print a Workbook </td> <td> </td> <td> 00:01:00</td> </tr> <tr> <td></td> <td> Configure and Preview a Print Job </td> <td> </td> <td> 00:03:00</td> </tr> <tr> <td></td> <td> Set Up the Page Layout - Introduction </td> <td> </td> <td> 00:01:00</td> </tr> <tr> <td></td> <td> Set Up the Page Layout </td> <td> </td> <td> 00:04:00</td> </tr> <tr> <td></td> <td> Configure Headers and Footers - Introduction </td> <td> </td> <td> 00:01:00</td> </tr> <tr> <td></td> <td> Configure Headers and Footers </td> <td> </td> <td> 00:02:00</td> </tr> <tr> <td colspan="4">Managing Workbooks</td> </tr> <tr> <td></td> <td> Manage Worksheets - Introduction </td> <td> </td> <td> 00:01:00</td> </tr> <tr> <td></td> <td> Manage Worksheets </td> <td> </td> <td> 00:05:00</td> </tr> <tr> <td></td> <td> Manage Workbook and Worksheet Views - Introduction </td> <td> </td> <td> 00:01:00</td> </tr> <tr> <td></td> <td> Manage Workbook and Worksheet Views </td> <td> </td> <td> 00:01:00</td> </tr> <tr> <td></td> <td> Manage Workbook Properties - Introduction </td> <td> </td> <td> 00:01:00</td> </tr> <tr> <td></td> <td> Manage Workbook Properties </td> <td> </td> <td> 00:03:00</td> </tr> <tr> <td colspan="4">Final Assessment</td> </tr> <tr> <td></td> <td>Assessment - Microsoft Office Excel 2016: Part 1 Beginner Level</td> <td> </td> <td> 00:10:00</td> </tr> <tr> <td colspan="4">Obtain Your Certificate</td> </tr> <tr> <td></td> <td> Order Your Certificate of Achievement </td> <td> </td> <td> 00:00:00</td> </tr> <tr> <td colspan="4">Get Your Insurance Now</td> </tr> <tr> <td></td> <td> Get Your Insurance Now </td> <td> </td> <td> 00:00:00</td> </tr> <tr> <td colspan="4">Feedback</td> </tr> <tr> <td></td> <td> Feedback </td> <td> </td> <td> 00:00:00</td> </tr> </tbody></table></div> </div>

Study Plex

Microsoft Office Excel 2016: Part 1 Beginner Level Course

<div> <div> </div> <div> <div> <div> <h3>Highlights of the Course</h3> <ul> <li>Course Type: Online Learning</li> <li>Duration: 1 Hour 17 Minutes</li> <li>Tutor Support: Tutor support is included</li> <li>Customer Support: 24/7 customer support is available</li> <li>Quality Training: The course is designed by an industry expert</li> <li>Recognised Credential: Recognised and Valuable Certification</li> <li>Completion Certificate: Free Course Completion Certificate Included</li> <li>Instalment: 3 Installment Plan on checkout</li> </ul> </div> </div> <div> <div> <hr /> <h3>What you will learn from this course?</h3> <ul> <li>Gain comprehensive knowledge about Microsoft Office Excel</li> <li>Understand the core competencies and principles of Microsoft Office Excel</li> <li>Explore the various areas of Microsoft Office Excel</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> <div> <div> <div> <hr /> <div> <div> <div> <h3>Microsoft Excel 2016: Data Analysis with PivotTables Course</h3> Master the skills you need to propel your career forward in Microsoft Office Excel. 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 excel data analysis course is designed to help you surpass your professional goals. The skills and knowledge that you will gain through studying this excel data analysis course will help you get one step closer to your professional aspirations and develop your skills for a rewarding career. This comprehensive course will teach you the theory of effective Microsoft Office Excel practice and equip you with the essential skills, confidence and competence to assist you in the Microsoft Office Excel industry. You'll gain a solid understanding of the core competencies required to drive a successful career in Microsoft Office Excel. 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 Office Excel. Enrol in this excel data analysis 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. </div> <div> <h3>Who is this Course for?</h3> This comprehensive excel data analysis 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 Office Excel can also take this course. 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. </div> <div> <h3>Entry Requirements</h3> This excel data analysis 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. </div> <div> <h3>Assessment</h3> This excel data analysis 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%. </div> <div> <h3>Advance Your Career</h3> This excel data analysis 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. </div> </div> </div> </div> </div> </div> </div> </div><h3>Recognised Accreditation</h3> 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.<div> <h3> Course Curriculum </h3> <div> <table> <tbody><tr> <td colspan="4">Introduction</td> </tr> <tr> <td></td> <td> Introduction </td> <td> </td> <td> 00:01:00</td> </tr> <tr> <td colspan="4">Preparing Data and Creating Pivot Tables</td> </tr> <tr> <td></td> <td> Prepare Data - Introduction </td> <td> </td> <td> 00:01:00</td> </tr> <tr> <td></td> <td> Prepare Data </td> <td> </td> <td> 00:06:00</td> </tr> <tr> <td></td> <td> Create a PivotTable - Introduction </td> <td> </td> <td> 00:07:00</td> </tr> <tr> <td></td> <td> Create a PivotTable from a Local Data Source </td> <td> </td> <td> 00:06:00</td> </tr> <tr> <td></td> <td> Create a PivotTable from Multiple Local Data Sources </td> <td> </td> <td> 00:07:00</td> </tr> <tr> <td></td> <td> Create a PivotTable from an External Data Sources </td> <td> </td> <td> 00:07:00</td> </tr> <tr> <td colspan="4">Analyzing Data by Using PivotTables</td> </tr> <tr> <td></td> <td> Summarize PivotTable Data - Introduction </td> <td> </td> <td> 00:01:00</td> </tr> <tr> <td></td> <td> Summarize Pivottable Data </td> <td> </td> <td> 00:07:00</td> </tr> <tr> <td></td> <td> Organize PivotTable Data - Introduction </td> <td> </td> <td> 00:01:00</td> </tr> <tr> <td></td> <td> Organize PivotTable Data </td> <td> </td> <td> 00:04:00</td> </tr> <tr> <td></td> <td> Filter Pivottable Data </td> <td> </td> <td> 00:07:00</td> </tr> <tr> <td></td> <td> Format a PivotTable - Introduction </td> <td> </td> <td> 00:01:00</td> </tr> <tr> <td></td> <td> Format a PivotTable </td> <td> </td> <td> 00:03:00</td> </tr> <tr> <td></td> <td> Refresh and Change PivotTable Data - Introduction </td> <td> </td> <td> 00:01:00</td> </tr> <tr> <td></td> <td> Refresh and Change PivotTable Data </td> <td> </td> <td> 00:06:00</td> </tr> <tr> <td colspan="4">Working with PivotCharts</td> </tr> <tr> <td></td> <td> Create a PivotChart - Introduction </td> <td> </td> <td> 00:01:00</td> </tr> <tr> <td></td> <td> Create a PivotChart </td> <td> </td> <td> 00:04:00</td> </tr> <tr> <td></td> <td> Manipulate PivotChart Data </td> <td> </td> <td> 00:04:00</td> </tr> <tr> <td></td> <td> Format a PivotChart </td> <td> </td> <td> 00:05:00</td> </tr> <tr> <td colspan="4">Obtain Your Certificate</td> </tr> <tr> <td></td> <td> Order Your Certificate of Achievement </td> <td> </td> <td> 00:00:00</td> </tr> <tr> <td colspan="4">Get Your Insurance Now</td> </tr> <tr> <td></td> <td> Get Your Insurance Now </td> <td> </td> <td> 00:00:00</td> </tr> <tr> <td colspan="4">Feedback</td> </tr> <tr> <td></td> <td> Feedback </td> <td> </td> <td> 00:00:00</td> </tr> </tbody></table></div> </div>

Microsoft Excel 2016: Data Analysis with PivotTables Course

Dive deep into the realm of Excel with our meticulously designed course on 'Excel Pivot Tables, Pivot Charts, Slicers, and Timelines'. Unlock the secrets of powerful data visualisation tools like Dashboards, Slicers, and Timelines, while mastering the art of reporting by varying time intervals. Whether you wish to streamline your reporting tasks or augment your analytical capabilities, this course will provide you with the tools and techniques to extract insights from data seamlessly.
Highlights of the Dynamic Excel Gantt Chart and Timelines :
<ul>
<li>Discover the secrets of finding the key to doing your best work</li>
<li>Understand how to reach your most productive level based on scientific research and principles</li>
<li>Explore the hidden productivity recipes of professionals and the most successful people in the world</li>
<li>Develop a routine for greater productivity both at home and at work</li>
<li>Understand the time management strategies for managing your time when dealing with multiple urgent tasks</li>
<li>Discover how to achieve higher productivity by making just a few simple changes</li>
<li>Learn simple yet highly effective productivity hacks that you can apply in minutes or less</li>
<li>Explore science-backed advice for developing a 'Productivity Mindset' and beat procrastination</li>
</ul>
<h3>Course Design</h3>
The course is delivered through our online learning platform, accessible through any internet-connected device. There are no formal deadlines or teaching schedules, meaning you are free to study the course at your own pace.
You are taught through a combination of
<ul>
<li>Video lessons</li>
<li>Online study materials</li>
</ul>
<h3>Who is this Course for?</h3>
<ul>
<li>Data analysts aiming to bolster their data visualisation techniques.</li>
<li>Professionals in finance, sales, and marketing looking to generate detailed reports.</li>
<li>Researchers keen on presenting data in an insightful manner.</li>
<li>Students aspiring to enhance their data representation and analysis skills.</li>
<li>Project managers wanting to make data-driven decisions</li>
</ul>
<h3>How is the course assessed?</h3>
To successfully complete the course you must pass an automated, multiple-choice assessment. The assessment is delivered through our online learning platform. You will receive the results of your assessment immediately upon completion.
<h3>Will I receive a certificate of completion?</h3>
Upon successful completion, you will qualify for the UK and internationally-recognised certification and you can choose to make your achievement formal by obtaining your PDF Certificate at a cost of £9 and Hardcopy Certificate for £15.
<h3>Requirements</h3>
The Dynamic Excel Gantt Chart and Timelines is open to all, with no formal entry requirements. All you need is a passion for learning, a good understanding of the English language, numeracy and IT, and to be over the age of 16.
<h3>Career Path</h3>
<ul>
<li>Data Analyst: £30,000 - £50,000</li>
<li>Financial Analyst: £35,000 - £55,000</li>
<li>Sales Analyst: £28,000 - £47,000</li>
<li>Market Researcher: £24,000 - £45,000</li>
<li>Data Visualization Specialist: £32,000 - £52,000</li>
<li>Business Intelligence Analyst: £38,000 - £60,000</li>
</ul><div>
				<h3>
	Course Curriculum
</h3>

<div>
<table width="100%">				<tbody><tr>
					<td colspan="4">Excel Pivot Tables, Pivot Charts, Slicers, and Timelines</td>
				</tr>
								<tr>
					<td></td>
					<td>Getting started with your Pivot Table</td>
					<td> </td>
					<td> 00:04:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Drill Down</td>
					<td> </td>
					<td> 00:01:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Managing the Field List</td>
					<td> </td>
					<td> 00:02:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Changing the Calculation type with Value Field Settings</td>
					<td> </td>
					<td> 00:06:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Growing your Pivot Table with Multiple Fields</td>
					<td> </td>
					<td> 00:04:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Formatting the Pivot Table</td>
					<td> </td>
					<td> 00:05:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Sorting and Filtering the Pivot Table</td>
					<td> </td>
					<td> 00:03:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Creating a Dashboard with Slicers, Timelines and Pivot Charts</td>
					<td> </td>
					<td> 00:09:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Reporting by day, month, qtr, or year within the Pivot Table</td>
					<td> </td>
					<td> 00:04:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Refreshing the Pivot Data with new data</td>
					<td> </td>
					<td> 00:03:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Adding your own calculations into the Pivot Table</td>
					<td> </td>
					<td> 00:03:00</td>
				</tr>
								<tr>
					<td></td>
					<td>The power of the Filter Section in the Pivot Table</td>
					<td> </td>
					<td> 00:04:00</td>
				</tr>
								<tr>
					<td></td>
					<td>PowerQuery</td>
					<td> </td>
					<td> 00:12:00</td>
				</tr>
								<tr>
					<td></td>
					<td>PowerPivot</td>
					<td> </td>
					<td> 00:21:00</td>
				</tr>
								<tr>
					<td colspan="4">Assignment</td>
				</tr>
								<tr>
					<td></td>
					<td>Assignment - Excel Pivot Tables, Pivot Charts, Slicers, and Timelines</td>
					<td> </td>
					<td> 00:00:00</td>
				</tr>
				</tbody></table></div>

			</div>

Office Skills & Productivity

Microsoft Power BI

Data Visualization

Powerpivot

Excel Pivot Tables, Pivot Charts, Slicers, and Timelines

<section>
						<div>
				<div>
				<div>
			<div>
					<div>
				<section>
						<div>
				<div>
				<div>
			<div>
					<div>
				<div>

				</div>
				<div>
				<div>
					<div>Gain the skills and credentials to kickstart a successful career and learn from the experts with this step-by-step training course. This Upgrade Excel Skill: 50 Best Tips has been specially designed to help learners gain a good command of Excel Skill, providing them with a solid foundation of knowledge to become a qualified professional.Through this Upgrade Excel Skill: 50 Best Tips, you will gain both practical and theoretical understanding of Excel Skill that will increase your employability in this field, help you stand out from the competition and boost your earning potential in no time.Not only that, but this training includes up-to-date knowledge and techniques that will ensure you have the most in-demand skills to rise to the top of the industry. This qualification is fully accredited, broken down into several manageable modules, ideal for aspiring professionals.</div>
				</div>
				</div>
						</div>
			</div>
		</div>
						</div>
			</div>
		</section>
				<section>
						<div>
				<div>
				<div>
			<div>
					<div>
				<div>
				<div>
					<div>
																					</div>
				</div>
				</div>
				<div>
				<h2>Learning outcome</h2>
				</div>
				<div>
				<div>
					<ul>
							<li>
											
													
										Get a deep understanding of the Upgrade Excel Skill: 50 Best Tips just in hours not years
									</li>
								<li>
											
													
										Familiar yourself with the recent development and updates of the relevant industry
									</li>
								<li>
											
													
										Know how to use your theoretical and practical knowledge to adapt in any working environment
									</li>
								<li>
											
													
										Get help from our expert tutors anytime you need
									</li>
								<li>
											
													
										 Access to course contents that are designed and prepared by industry professionals
									</li>
								<li>
											
													
										Study at your convenient time and from wherever you want 
									</li>
						</ul>
				</div>
				</div>
						</div>
			</div>
		</div>
						</div>
			</div>
		</section>
						</div>
			</div>
		</div>
				<div>
			<div>
					<div>
				<section>
						<div>
				<div>
				<div>
			<div>
					<div>
				<div>
				<div>
					<div>
																					</div>
				</div>
				</div>
				<div>
				<h2>Requirements</h2>
				</div>
				<div>
				<div>
					<ul>
							<li>
											
													
										No formal qualifications required, anyone from any academic background can take this course.
									</li>
								<li>
											
													
										Access to any internet-enabled smart device.
									</li>
						</ul>
				</div>
				</div>
						</div>
			</div>
		</div>
						</div>
			</div>
		</section>
				<section>
						<div>
				<div>
				<div>
			<div>
					<div>
				<div>
				<h2>Why should I take this course?</h2>
				</div>
				<div>
				<div>
					<ul>
							<li>
											
													
										2+ hours of on-demand video lectures and downloadable resources.
									</li>
								<li>
											
													
										Affordable premium-quality E-learning content, you can learn at your own pace.
									</li>
								<li>
											
													
										You will receive a completion certificate upon completing the course.
									</li>
								<li>
											
													
										Internationally recognized Accredited Qualification will boost up your resume.
									</li>
								<li>
											
													
										You will learn the researched and proven approach adopted by successful salespeople to transform their careers.
									</li>
								<li>
											
													
										You will be able to incorporate various practical sales techniques successfully and understand your customers better.
									</li>
						</ul>
				</div>
				</div>
						</div>
			</div>
		</div>
						</div>
			</div>
		</section>
						</div>
			</div>
		</div>
						</div>
			</div>
		</section>

Skill Up

Learning & Development

Online Course Marketing

Professional Skills

Employability Skills

Study Skills

Trainers Course

Gain the skills and credentials to kickstart a successful career and learn from the experts with this step-by-step

Upgrade Excel Skill: 50 Best Tips

<div>
	<h3>Description:</h3>
This Microsoft Office 2013 Excel Advanced - Complete Video Course covers the advanced functions and features of Excel 2013. You will learn about working with multiple worksheets and automating and auditing worksheets, how to update workbook properties, and how to apply conditional formatting. You will also learn how to export, analyze and present Excel data. This Advanced level is designed for you to gain the skills necessary to use pivot tables, audit and analyze worksheet data, utilize data tools, collaborate with others, and create and manage macros. 
This course is intended for them who have intermediate skills with Microsoft Excel 2013, and want to learn more advanced skills or want to learn the topics covered in this course in the 2013 interface. So, brush up your basic and intermediate knowledge and be an expert with the help of this course.
<h3>Assessment:</h3>
<ul>
<li>At the end of the course, you will be required to sit for an online MCQ test. Your test will be assessed automatically and immediately. You will instantly know whether you have been successful or not.</li>
<li>Before sitting for your final exam you will have the opportunity to test your proficiency with a mock exam.</li>
</ul>
<h3>Certification:</h3>
<ul>
<li>After completing and passing the course successfully, you will be able to obtain an Accredited Certificate of Achievement.</li>
<li>Certificates can be obtained either in hard copy at a cost of £39 or in PDF format at a cost of £24.</li>
</ul>
<h3>Who is this Course for?</h3>
Microsoft Office 2013 Excel Advanced - Complete Video Course is certified by CPD Qualifications Standards and CiQ. This makes it perfect for anyone trying to learn potential professional skills.
As there is no experience and qualification required for this course, it is available for all students from any academic background.
<h3>Requirements</h3>
Our Microsoft Office 2013 Excel Advanced - Complete Video Course is fully compatible with any kind of device. Whether you are using Windows computer, Mac, smartphones or tablets, you will get the same experience while learning. Besides that, you will be able to access the course with any kind of internet connection from anywhere at any time without any kind of limitation.
<h3>Career Path</h3>
After completing this course you will be able to build up accurate knowledge and skills with proper confidence to enrich yourself and brighten up your career in the relevant job market.
		</div><table width="100%">				<tbody><tr>
					<td colspan="4">Automating Worksheet Functionality</td>
				</tr>
								<tr>
					<td></td>
					<td>Update Workbook Properties</td>
					<td>FREE </td>
					<td> 00:07:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Create and Edit a Macro</td>
					<td> </td>
					<td> 00:15:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Apply Conditional Formatting</td>
					<td> </td>
					<td> 00:09:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Add Data Validation Criteria</td>
					<td> </td>
					<td> 00:10:00</td>
				</tr>
								<tr>
					<td colspan="4">Auditing Worksheets</td>
				</tr>
								<tr>
					<td></td>
					<td>Trace Cells</td>
					<td> </td>
					<td> 00:05:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Troubleshoot Invalid Data and Formula Errors</td>
					<td> </td>
					<td> 00:12:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Watch and Evaluate Formulas</td>
					<td> </td>
					<td> 00:10:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Create a Data List Outline</td>
					<td> </td>
					<td> 00:09:00</td>
				</tr>
								<tr>
					<td colspan="4">Analyzing and Presenting Data</td>
				</tr>
								<tr>
					<td></td>
					<td>Create Sparklines</td>
					<td> </td>
					<td> 00:13:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Create Scenarios</td>
					<td> </td>
					<td> 00:12:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Perform a What If Analysis</td>
					<td> </td>
					<td> 00:19:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Perform a Statistical Analysis with the Analysis ToolPak</td>
					<td> </td>
					<td> 00:06:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Create Interactive Data with Power View</td>
					<td> </td>
					<td> 00:10:00</td>
				</tr>
								<tr>
					<td colspan="4">Working With Multiple Workbooks</td>
				</tr>
								<tr>
					<td></td>
					<td>Consolidate Data</td>
					<td> </td>
					<td> 00:10:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Link Cells in Different Workbooks</td>
					<td> </td>
					<td> 00:10:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Merge Workbooks</td>
					<td> </td>
					<td> 00:08:00</td>
				</tr>
								<tr>
					<td colspan="4">Exporting Excel Data</td>
				</tr>
								<tr>
					<td></td>
					<td>Export Excel Data</td>
					<td> </td>
					<td> 00:06:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Import a Delimited Text File</td>
					<td> </td>
					<td> 00:09:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Integrate Excel Data with the Web</td>
					<td> </td>
					<td> 00:11:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Create a Web Query</td>
					<td> </td>
					<td> 00:08:00</td>
				</tr>
								<tr>
					<td colspan="4">Mock Exam</td>
				</tr>
								<tr>
					<td></td>
					<td>Mock Exam- Microsoft Office 2013 Excel Advanced - Complete Video Course</td>
					<td> </td>
					<td> 00:20:00</td>
				</tr>
								<tr>
					<td colspan="4">Final Exam</td>
				</tr>
								<tr>
					<td></td>
					<td>Final Exam- Microsoft Office 2013 Excel Advanced - Complete Video Course</td>
					<td> </td>
					<td> 00:20:00</td>
				</tr>
								<tr>
					<td colspan="4">Certificate and Transcript</td>
				</tr>
								<tr>
					<td></td>
					<td>Order Your Certificates and Transcripts</td>
					<td> </td>
					<td> 00:00:00</td>
				</tr>
				</tbody></table>

John Academy

Microsoft Certification

Microsoft AZ-900

Microsoft Office

Microsoft AZ-104

Microsoft AZ-303

Microsoft Office 2013 Excel Advanced - Complete Video Course

Become an accomplished Microsoft Excel professional with this engaging, innovative online distance learning course. Through exercises that put knowledge gained from video and handout lessons into practice, you will master higher Excel functions such as performing statistical analyses, creating and editing macros, and utilising advanced formulas, as well as broader business administration and IT skills.
<h3 fr-original-style="" style="box-sizing: border-box;">Why choose this course</h3>
<ul fr-original-style="" style="box-sizing: border-box;">
<li fr-original-style="" style="box-sizing: border-box;">Earn an&nbsp;e-certificate upon successful completion.</li>
<li fr-original-style="" style="box-sizing: border-box;">Accessible, informative modules taught by expert instructors</li>
<li fr-original-style="" style="box-sizing: border-box;">Study in your own time, at your own pace, through your computer tablet or mobile device</li>
<li fr-original-style="" style="box-sizing: border-box;">Benefit from instant feedback through mock exams and multiple-choice assessments</li>
<li fr-original-style="" style="box-sizing: border-box;">Get 24/7 help or advice from our email and live chat teams</li>
<li fr-original-style="" style="box-sizing: border-box;">Full Tutor Support on Weekdays</li>
</ul>
<h3 fr-original-style="" style="box-sizing: border-box;">Course Design</h3>
The course is delivered through our online learning platform, accessible through any internet-connected device. There are no formal deadlines or teaching schedules, meaning you are free to study the course at your own pace.
You are taught through a combination of
<ul fr-original-style="" style="box-sizing: border-box;">
<li fr-original-style="" style="box-sizing: border-box;">Video lessons</li>
<li fr-original-style="" style="box-sizing: border-box;">Online study materials</li>
<li fr-original-style="" style="box-sizing: border-box;">Mock exams</li>
<li fr-original-style="" style="box-sizing: border-box;">Multiple-choice assessment</li>
</ul>
<h3 fr-original-style="" style="box-sizing: border-box;">Certification</h3>
After the successful completion of the final assessment, you will receive a CPD-accredited certificate of achievement. The PDF certificate is for &pound;9.99, and it will be sent to you immediately after through e-mail. You can get the hard copy for &pound;15.99, which will reach your doorsteps by post.
<div fr-original-style="" style="box-sizing: border-box;">
<h3 fr-original-style="" style="box-sizing: border-box;">Who is this course for?</h3>
</div>
<div fr-original-style="" style="box-sizing: border-box;">
Level 3 Diploma in Microsoft Excel 2016&nbsp;is suitable for anyone who want to gain extensive knowledge, potential experience and professional skills in the related field. This is a great opportunity for all student from any academic backgrounds to learn more on this subject.</div><div fr-original-style="" style="box-sizing: border-box;"> </div>

Janets

Online Course Creation

Certificate in Further Education & Training (Cert Ed)

European Computer Driving Licence (ECDL)

Level 3 Diploma in Microsoft Excel 2016

<div>
	<h3>Description:</h3>
This Microsoft Office 2013 Excel Intermediate - Complete Video Course covers the intermediate functions and features of Excel 2013. You will learn about creating formulas, inserting graphics and enhancing workbooks. You will also learn how to organize worksheet data with tables and charts and how to analyze data using PivotTables, Slicers and PivotCharts. In this course creating advanced formulas, you will learn how to apply range names and how to use specialized functions.
Once you are comfortable with the basics, you will be ready for this intermediate level. Here, you will explore more advanced formatting with terms, using Excel provided templates, adding graphics and charts, and using Excel as a database. You finish off with advanced formulas and applying conditional formatting to your worksheet, and more.
If you want to take your Microsoft Excel  2013 skills to the next level, you'll learn how to use this program's advanced features to build a fully functional database from scratch.
<h3>Assessment:</h3>
<ul>
<li>At the end of the course, you will be required to sit for an online MCQ test. Your test will be assessed automatically and immediately. You will instantly know whether you have been successful or not.</li>
<li>Before sitting for your final exam you will have the opportunity to test your proficiency with a mock exam.</li>
</ul>
<h3>Certification:</h3>
<ul>
<li>After completing and passing the course successfully, you will be able to obtain an Accredited Certificate of Achievement.</li>
<li>Certificates can be obtained either in hard copy at a cost of £39 or in PDF format at a cost of £24.</li>
</ul>
<h3>Who is this Course for?</h3>
Microsoft Office 2013 Excel Intermediate - Complete Video Course is certified by CPD Qualifications Standards and CiQ. This makes it perfect for anyone trying to learn potential professional skills.
As there is no experience and qualification required for this course, it is available for all students from any academic background.
<h3>Requirements</h3>
Our Microsoft Office 2013 Excel Intermediate - Complete Video Course is fully compatible with any kind of device. Whether you are using Windows computer, Mac, smartphones or tablets, you will get the same experience while learning. Besides that, you will be able to access the course with any kind of internet connection from anywhere at any time without any kind of limitation.
<h3>Career Path</h3>
After completing this course you will be able to build up accurate knowledge and skills with proper confidence to enrich yourself and brighten up your career in the relevant job market.
		</div><table width="100%">				<tbody><tr>
					<td colspan="4">Creating Advanced Formulas</td>
				</tr>
								<tr>
					<td></td>
					<td>Apply Range Names</td>
					<td>FREE </td>
					<td> 00:18:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Use Specialized Functions</td>
					<td> </td>
					<td> 00:14:00</td>
				</tr>
								<tr>
					<td colspan="4">Analyzing Data with Logical and Lookup Functions</td>
				</tr>
								<tr>
					<td></td>
					<td>Leverage Questions and Testing to Write Formulas</td>
					<td> </td>
					<td> 00:01:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Use Logical and Lookup Functions to Find Answers to Questions</td>
					<td> </td>
					<td> 00:25:00</td>
				</tr>
								<tr>
					<td colspan="4">Organizing Worksheet Data with Tables</td>
				</tr>
								<tr>
					<td></td>
					<td>Create and Modify Tables</td>
					<td> </td>
					<td> 00:09:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Sort and Filter Data</td>
					<td> </td>
					<td> 00:27:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Use Summary and Database Functions to Calculate Data</td>
					<td> </td>
					<td> 00:25:00</td>
				</tr>
								<tr>
					<td colspan="4">Visualizing Data with Charts</td>
				</tr>
								<tr>
					<td></td>
					<td>Create Charts</td>
					<td> </td>
					<td> 00:05:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Modify and Format Charts</td>
					<td> </td>
					<td> 00:25:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Create a Trendline</td>
					<td> </td>
					<td> 00:10:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Create Advanced Charts</td>
					<td> </td>
					<td> 00:09:00</td>
				</tr>
								<tr>
					<td colspan="4">Analyzing Data with PivotTables, Slicers, and PivotCharts</td>
				</tr>
								<tr>
					<td></td>
					<td>Create a PivotTable</td>
					<td> </td>
					<td> 00:24:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Filter Data by Using Slicers</td>
					<td> </td>
					<td> 00:09:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Analyze Data by Using PivotCharts</td>
					<td> </td>
					<td> 00:07:00</td>
				</tr>
								<tr>
					<td colspan="4">Inserting Graphics</td>
				</tr>
								<tr>
					<td></td>
					<td>Insert and Modify Graphic Objects</td>
					<td> </td>
					<td> 00:10:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Layer and Group Graphic Objects</td>
					<td> </td>
					<td> 00:12:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Incorporate SmartArt</td>
					<td> </td>
					<td> 00:06:00</td>
				</tr>
								<tr>
					<td colspan="4">Enhancing Workbooks</td>
				</tr>
								<tr>
					<td></td>
					<td>Customizing Workbooks</td>
					<td> </td>
					<td> 00:08:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Manage Themes</td>
					<td> </td>
					<td> 00:06:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Create and Use Templates</td>
					<td> </td>
					<td> 00:06:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Protect Files</td>
					<td> </td>
					<td> 00:08:00</td>
				</tr>
								<tr>
					<td colspan="4">Mock Exam</td>
				</tr>
								<tr>
					<td></td>
					<td>Mock Exam- Microsoft Office 2013 Excel Intermediate - Complete Video Course</td>
					<td> </td>
					<td> 00:20:00</td>
				</tr>
								<tr>
					<td colspan="4">Final Exam</td>
				</tr>
								<tr>
					<td></td>
					<td>Final Exam- Microsoft Office 2013 Excel Intermediate - Complete Video Course</td>
					<td> </td>
					<td> 00:20:00</td>
				</tr>
								<tr>
					<td colspan="4">Certificate and Transcript</td>
				</tr>
								<tr>
					<td></td>
					<td>Order Your Certificates and Transcripts</td>
					<td> </td>
					<td> 00:00:00</td>
				</tr>
				</tbody></table>

Finance Cert & Exam Prep

Microsoft Office 2013 Excel Intermediate - Complete Video Course

<div>
	<h3>Description:</h3>
Microsoft Excel, developed by Microsoft Corporation, is world's leading spreadsheet program for Windows, macOS, Android and iOS. The program includes calculation, graphing tools, pivot tables, and a macro programming language called Visual Basic for Applications to make your task easy and for saving your precious time. You can hardly find any company where Microsoft Excel is not used. The knowledge of Excel is a must for meeting any career perspective. The course will help you to achieve the goals.
The course is divided into three parts - beginners, intermediate and advanced. Therefore after completing the bundle video course, you will be a prolific user of the program. As the course is sectioned based on the level of difficulty, you will know the basics of Excel at first. You will know how to open an excel program, how to put data or know some simple calculations. After the primary knowledge, you will be introduced to some more features and functions of the program such as analyse massive amounts of data, extract actionable information from it, etc. Finally, you will learn the advanced features of Excel program that allows you take the right business decisions for your company.
<h3>Assessment:</h3>
<ul>
<li>At the end of the course, you will be required to sit for an online MCQ test. Your test will be assessed automatically and immediately. You will instantly know whether you have been successful or not.</li>
<li>Before sitting for your final exam you will have the opportunity to test your proficiency with a mock exam.</li>
</ul>
<h3>Certification:</h3>
<ul>
<li>After completing and passing the course successfully, you will be able to obtain an Accredited Certificate of Achievement.</li>
<li>Certificates can be obtained either in hard copy at a cost of £39 or in PDF format at a cost of £24.</li>
</ul>
<h3>Who is this Course for?</h3>
Microsoft Office 2016 Excel Complete Video Course - Beginner, Intermediate &amp; Advanced is certified by CPD Qualifications Standards and CiQ. This makes it perfect for anyone trying to learn potential professional skills.
As there is no experience and qualification required for this course, it is available for all students from any academic background.
<h3>Requirements</h3>
Our Microsoft Office 2016 Excel Complete Video Course - Beginner, Intermediate &amp; Advanced is fully compatible with any kind of device. Whether you are using Windows computer, Mac, smartphones or tablets, you will get the same experience while learning. Besides that, you will be able to access the course with any kind of internet connection from anywhere at any time without any kind of limitation.
<h3>Career Path</h3>
After completing this course you will be able to build up accurate knowledge and skills with proper confidence to enrich yourself and brighten up your career in the relevant job market.
		</div><table width="100%">				<tbody><tr>
					<td colspan="4">Getting Started with Microsoft Office Excel 2016</td>
				</tr>
								<tr>
					<td></td>
					<td>Navigate the Excel User Interface</td>
					<td>FREE </td>
					<td> 00:28:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Use Excel Commands</td>
					<td> </td>
					<td> 00:10:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Create and Save a Basic Workbook</td>
					<td> </td>
					<td> 00:19:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Enter Cell Data</td>
					<td> </td>
					<td> 00:12:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Use Excel Help</td>
					<td> </td>
					<td> 00:05:00</td>
				</tr>
								<tr>
					<td colspan="4">Performing Calculations</td>
				</tr>
								<tr>
					<td></td>
					<td>Create Worksheet Formulas</td>
					<td> </td>
					<td> 00:15:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Insert Functions</td>
					<td> </td>
					<td> 00:17:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Reuse Formulas and Functions</td>
					<td> </td>
					<td> 00:17:00</td>
				</tr>
								<tr>
					<td colspan="4">Modifying a Worksheet</td>
				</tr>
								<tr>
					<td></td>
					<td>Insert, Delete, and Adjust Cells, Columns, and Rows</td>
					<td> </td>
					<td> 00:10:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Search for and Replace Data</td>
					<td> </td>
					<td> 00:09:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Use Proofing and Research Tools</td>
					<td> </td>
					<td> 00:07:00</td>
				</tr>
								<tr>
					<td colspan="4">Formatting a Worksheet</td>
				</tr>
								<tr>
					<td></td>
					<td>Apply Text Formats</td>
					<td> </td>
					<td> 00:17:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Apply Number Format</td>
					<td> </td>
					<td> 00:08:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Align Cell Contents</td>
					<td> </td>
					<td> 00:09:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Apply Styles and Themes</td>
					<td> </td>
					<td> 00:12:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Apply Basic Conditional Formatting</td>
					<td> </td>
					<td> 00:11:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Create and Use Templates</td>
					<td> </td>
					<td> 00:07:00</td>
				</tr>
								<tr>
					<td colspan="4">Printing Workbooks</td>
				</tr>
								<tr>
					<td></td>
					<td>Preview and Print a Workbook</td>
					<td> </td>
					<td> 00:10:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Set Up the Page Layout</td>
					<td> </td>
					<td> 00:08:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Configure Headers and Footers</td>
					<td> </td>
					<td> 00:07:00</td>
				</tr>
								<tr>
					<td colspan="4">Managing Workbooks</td>
				</tr>
								<tr>
					<td></td>
					<td>Manage Worksheets</td>
					<td> </td>
					<td> 00:05:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Manage Workbook and Worksheet Views</td>
					<td> </td>
					<td> 00:07:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Manage Workbook Properties</td>
					<td> </td>
					<td> 00:05:00</td>
				</tr>
								<tr>
					<td colspan="4"> Working with Functions</td>
				</tr>
								<tr>
					<td></td>
					<td>Work with Ranges</td>
					<td>FREE </td>
					<td> 00:18:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Use Specialized Functions</td>
					<td> </td>
					<td> 00:11:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Work with Logical Functions</td>
					<td> </td>
					<td> 00:23:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Work with Date &amp; Time Functions</td>
					<td> </td>
					<td> 00:08:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Work with Text Functions</td>
					<td> </td>
					<td> 00:11:00</td>
				</tr>
								<tr>
					<td colspan="4">Working with Lists</td>
				</tr>
								<tr>
					<td></td>
					<td>Sort Data</td>
					<td> </td>
					<td> 00:10:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Filter Data</td>
					<td> </td>
					<td> 00:10:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Query Data with Database Functions</td>
					<td> </td>
					<td> 00:09:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Outline and Subtotal Data</td>
					<td> </td>
					<td> 00:09:00</td>
				</tr>
								<tr>
					<td colspan="4">Analyzing Data</td>
				</tr>
								<tr>
					<td></td>
					<td>Create and Modify Tables</td>
					<td> </td>
					<td> 00:15:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Apply Intermediate Conditional Formatting</td>
					<td> </td>
					<td> 00:07:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Apply Advanced Conditional Formatting</td>
					<td> </td>
					<td> 00:05:00</td>
				</tr>
								<tr>
					<td colspan="4">Visualizing Data with Charts</td>
				</tr>
								<tr>
					<td></td>
					<td>Create Charts</td>
					<td> </td>
					<td> 00:13:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Modify and Format Charts</td>
					<td> </td>
					<td> 00:12:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Use Advanced Chart Features</td>
					<td> </td>
					<td> 00:12:00</td>
				</tr>
								<tr>
					<td colspan="4">Using PivotTables and PivotCharts</td>
				</tr>
								<tr>
					<td></td>
					<td>Create a PivotTable</td>
					<td> </td>
					<td> 00:13:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Analyze PivotTable Data</td>
					<td> </td>
					<td> 00:12:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Present Data with PivotCharts</td>
					<td> </td>
					<td> 00:07:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Filter Data by Using Timelines and Slicers</td>
					<td> </td>
					<td> 00:11:00</td>
				</tr>
								<tr>
					<td colspan="4">Working with Multiple Worksheets and Workbooks</td>
				</tr>
								<tr>
					<td></td>
					<td>Use Links and External References</td>
					<td>FREE </td>
					<td> 00:12:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Use 3-D References</td>
					<td> </td>
					<td> 00:06:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Consolidate Data</td>
					<td> </td>
					<td> 00:05:00</td>
				</tr>
								<tr>
					<td colspan="4">Using Lookup Functions and Formula Auditing</td>
				</tr>
								<tr>
					<td></td>
					<td>Use Lookup Functions</td>
					<td> </td>
					<td> 00:12:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Trace Cells</td>
					<td> </td>
					<td> 00:09:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Watch and Evaluate Formulas</td>
					<td> </td>
					<td> 00:08:00</td>
				</tr>
								<tr>
					<td colspan="4">Sharing and Protecting Workbooks</td>
				</tr>
								<tr>
					<td></td>
					<td>Collaborate on a Workbook</td>
					<td> </td>
					<td> 00:19:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Protect Worksheets and Workbooks</td>
					<td> </td>
					<td> 00:08:00</td>
				</tr>
								<tr>
					<td colspan="4">Automating Workbook Functionality</td>
				</tr>
								<tr>
					<td></td>
					<td>Apply Data Validation</td>
					<td> </td>
					<td> 00:13:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Search for Invalid Data and Formulas with Errors</td>
					<td> </td>
					<td> 00:04:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Work with Macros</td>
					<td> </td>
					<td> 00:18:00</td>
				</tr>
								<tr>
					<td colspan="4">Creating Sparklines and Mapping Data</td>
				</tr>
								<tr>
					<td></td>
					<td>Create Sparklines</td>
					<td> </td>
					<td> 00:07:00</td>
				</tr>
								<tr>
					<td></td>
					<td>MapData</td>
					<td> </td>
					<td> 00:07:00</td>
				</tr>
								<tr>
					<td colspan="4">Forecasting Data</td>
				</tr>
								<tr>
					<td></td>
					<td>Determine Potential Outcomes Using Data Tables</td>
					<td> </td>
					<td> 00:08:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Determine Potential Outcomes Using Scenarios</td>
					<td> </td>
					<td> 00:09:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Use the Goal Seek Feature</td>
					<td> </td>
					<td> 00:04:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Forecasting Data Trends</td>
					<td> </td>
					<td> 00:05:00</td>
				</tr>
								<tr>
					<td colspan="4">Refer A Friend</td>
				</tr>
								<tr>
					<td></td>
					<td>Refer A Friend</td>
					<td> </td>
					<td> 00:00:00</td>
				</tr>
								<tr>
					<td colspan="4">Certificate and Transcript</td>
				</tr>
								<tr>
					<td></td>
					<td>Order Your Certificates and Transcripts</td>
					<td> </td>
					<td> 00:00:00</td>
				</tr>
				</tbody></table>

Microsoft MS-700

Microsoft 365

Microsoft Office 2016 Excel Complete Video Course - Beginner, Intermediate & Advanced

<div id="course-pricing" fr-original-style="" style="box-sizing: border-box;">
 </div><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;">In this competitive job market, you need to have some specific skills and knowledge to start your career and establish your position. This Powerful Functions in Microsoft Excel course will help you understand the current demands, trends and skills in the sector. The course will provide you with the essential skills you need to boost your career growth in no time.The Powerful Functions in Microsoft Excel course will give you clear insight and understanding about your roles and responsibilities, job perspective and future opportunities in this field. You will be familiarised with various actionable techniques, career mindset, regulations and how to work efficiently.This course is designed to provide an introduction to Powerful Functions in Microsoft Excel and offers an excellent way to gain the vital skills and confidence to work toward a successful career. It also provides access to proven educational knowledge about the subject and will support those wanting to attain personal goals in this area.Learning Objectives</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;"><ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">Learn the fundamental skills you require to be an expert</li><li fr-original-style="" style="box-sizing: border-box;">Explore different techniques used by professionals</li><li fr-original-style="" style="box-sizing: border-box;">Find out the relevant job skills &amp; knowledge to excel in this profession</li><li fr-original-style="" style="box-sizing: border-box;">Get a clear understanding of the job market and current demand</li><li fr-original-style="" style="box-sizing: border-box;">Update your skills and fill any knowledge gap to compete in the relevant industry</li><li fr-original-style="" style="box-sizing: border-box;">CPD accreditation for proof of acquired skills and knowledge</li></ul><h3 fr-original-style="" style="box-sizing: border-box;">Who is this Course for?</h3>Whether you are a beginner or an existing practitioner, our CPD accredited Powerful Functions in Microsoft Excel course is perfect for you to gain extensive knowledge about different aspects of the relevant industry to hone your skill further.It is also great for working professionals who have acquired practical experience but require theoretical knowledge with a credential to support their skill, as we offer CPD accredited certification to boost up your resume and promotion prospects.<h3 fr-original-style="" style="box-sizing: border-box;">Entry Requirement</h3>Anyone interested in learning more about this subject should take this Powerful Functions in Microsoft Excel course. This course will help you grasp the basic concepts as well as develop a thorough understanding of the subject.The course is open to students from any academic background, as there is no prerequisites to enrol on this course. The course materials are accessible from an internet enabled device at anytime of the day.<h3 fr-original-style="" style="box-sizing: border-box;">CPD Certificate from Course Gate</h3>At the successful completion of the course, you can obtain your CPD certificate from us. You can order the PDF certificate for &pound;4.99 and the hard copy for &pound;9.99. Also, you can order both PDF and hardcopy certificates for &pound;12.99.<h3 fr-original-style="" style="box-sizing: border-box;">Career path</h3>The Powerful Functions in Microsoft Excel will help you to enhance your knowledge and skill in this sector. After accomplishing this course, you will enrich and improve yourself and brighten up your career in the relevant job market.</div>
</div>
</div>
</div>
</div>
</section>
</div>
</div><div fr-original-style="" style="box-sizing: border-box;">
<h3 fr-original-style="" style="box-sizing: border-box;">
Course Curriculum
</h3>

<div fr-original-style="" style="box-sizing: border-box;">
<table width="100%" fr-original-style="" style="border: none; border-collapse: collapse; empty-cells: show; max-width: 100%; box-sizing: border-box;"><tbody fr-original-style="" style="box-sizing: border-box;"><tr fr-original-style="" style="box-sizing: border-box;"><td colspan="4" fr-original-style="" style="min-width: 5px; box-sizing: border-box; user-select: text; border: 1px solid rgb(221, 221, 221);">Powerful Functions in Microsoft Excel</td></tr>
<tr fr-original-style="" style="box-sizing: border-box;"><td fr-original-style="" style="min-width: 5px; box-sizing: border-box; user-select: text; border: 1px solid rgb(221, 221, 221); height: 20px;"></td>
<td fr-original-style="" style="min-width: 5px; box-sizing: border-box; user-select: text; border: 1px solid rgb(221, 221, 221);">Introduction</td>
<td fr-original-style="" style="min-width: 5px; box-sizing: border-box; user-select: text; border: 1px solid rgb(221, 221, 221); height: 20px;"></td>
<td fr-original-style="" style="min-width: 5px; box-sizing: border-box; user-select: text; border: 1px solid rgb(221, 221, 221);"> 00:03:00</td></tr>
<tr fr-original-style="" style="box-sizing: border-box;"><td fr-original-style="" style="min-width: 5px; box-sizing: border-box; user-select: text; border: 1px solid rgb(221, 221, 221); height: 20px;"></td>
<td fr-original-style="" style="min-width: 5px; box-sizing: border-box; user-select: text; border: 1px solid rgb(221, 221, 221);">Basic Functions</td>
<td fr-original-style="" style="min-width: 5px; box-sizing: border-box; user-select: text; border: 1px solid rgb(221, 221, 221); height: 20px;"></td>
<td fr-original-style="" style="min-width: 5px; box-sizing: border-box; user-select: text; border: 1px solid rgb(221, 221, 221);"> 00:12:00</td></tr>
<tr fr-original-style="" style="box-sizing: border-box;"><td fr-original-style="" style="min-width: 5px; box-sizing: border-box; user-select: text; border: 1px solid rgb(221, 221, 221); height: 20px;"></td>
<td fr-original-style="" style="min-width: 5px; box-sizing: border-box; user-select: text; border: 1px solid rgb(221, 221, 221);">Date Functions</td>
<td fr-original-style="" style="min-width: 5px; box-sizing: border-box; user-select: text; border: 1px solid rgb(221, 221, 221); height: 20px;"></td>
<td fr-original-style="" style="min-width: 5px; box-sizing: border-box; user-select: text; border: 1px solid rgb(221, 221, 221);"> 00:09:00</td></tr>
<tr fr-original-style="" style="box-sizing: border-box;"><td fr-original-style="" style="min-width: 5px; box-sizing: border-box; user-select: text; border: 1px solid rgb(221, 221, 221); height: 20px;"></td>
<td fr-original-style="" style="min-width: 5px; box-sizing: border-box; user-select: text; border: 1px solid rgb(221, 221, 221);">Random Numbers</td>
<td fr-original-style="" style="min-width: 5px; box-sizing: border-box; user-select: text; border: 1px solid rgb(221, 221, 221); height: 20px;"></td>
<td fr-original-style="" style="min-width: 5px; box-sizing: border-box; user-select: text; border: 1px solid rgb(221, 221, 221);"> 00:09:00</td></tr>
<tr fr-original-style="" style="box-sizing: border-box;"><td fr-original-style="" style="min-width: 5px; box-sizing: border-box; user-select: text; border: 1px solid rgb(221, 221, 221); height: 20px;"></td>
<td fr-original-style="" style="min-width: 5px; box-sizing: border-box; user-select: text; border: 1px solid rgb(221, 221, 221);">IFS so many IFS</td>
<td fr-original-style="" style="min-width: 5px; box-sizing: border-box; user-select: text; border: 1px solid rgb(221, 221, 221); height: 20px;"></td>
<td fr-original-style="" style="min-width: 5px; box-sizing: border-box; user-select: text; border: 1px solid rgb(221, 221, 221);"> 00:11:00</td></tr>
<tr fr-original-style="" style="box-sizing: border-box;"><td fr-original-style="" style="min-width: 5px; box-sizing: border-box; user-select: text; border: 1px solid rgb(221, 221, 221); height: 20px;"></td>
<td fr-original-style="" style="min-width: 5px; box-sizing: border-box; user-select: text; border: 1px solid rgb(221, 221, 221);">Text Functions</td>
<td fr-original-style="" style="min-width: 5px; box-sizing: border-box; user-select: text; border: 1px solid rgb(221, 221, 221); height: 20px;"></td>
<td fr-original-style="" style="min-width: 5px; box-sizing: border-box; user-select: text; border: 1px solid rgb(221, 221, 221);"> 00:13:00</td></tr>
<tr fr-original-style="" style="box-sizing: border-box;"><td fr-original-style="" style="min-width: 5px; box-sizing: border-box; user-select: text; border: 1px solid rgb(221, 221, 221); height: 20px;"></td>
<td fr-original-style="" style="min-width: 5px; box-sizing: border-box; user-select: text; border: 1px solid rgb(221, 221, 221);">Logical Functions</td>
<td fr-original-style="" style="min-width: 5px; box-sizing: border-box; user-select: text; border: 1px solid rgb(221, 221, 221); height: 20px;"></td>
<td fr-original-style="" style="min-width: 5px; box-sizing: border-box; user-select: text; border: 1px solid rgb(221, 221, 221);"> 00:09:00</td></tr>
<tr fr-original-style="" style="box-sizing: border-box;"><td fr-original-style="" style="min-width: 5px; box-sizing: border-box; user-select: text; border: 1px solid rgb(221, 221, 221); height: 20px;"></td>
<td fr-original-style="" style="min-width: 5px; box-sizing: border-box; user-select: text; border: 1px solid rgb(221, 221, 221);">Creating a Drop-Down List</td>
<td fr-original-style="" style="min-width: 5px; box-sizing: border-box; user-select: text; border: 1px solid rgb(221, 221, 221); height: 20px;"></td>
<td fr-original-style="" style="min-width: 5px; box-sizing: border-box; user-select: text; border: 1px solid rgb(221, 221, 221);"> 00:05:00</td></tr>
<tr fr-original-style="" style="box-sizing: border-box;"><td fr-original-style="" style="min-width: 5px; box-sizing: border-box; user-select: text; border: 1px solid rgb(221, 221, 221); height: 20px;"></td>
<td fr-original-style="" style="min-width: 5px; box-sizing: border-box; user-select: text; border: 1px solid rgb(221, 221, 221);">VLOOKUP and XLOOKUP</td>
<td fr-original-style="" style="min-width: 5px; box-sizing: border-box; user-select: text; border: 1px solid rgb(221, 221, 221); height: 20px;"></td>
<td fr-original-style="" style="min-width: 5px; box-sizing: border-box; user-select: text; border: 1px solid rgb(221, 221, 221);"> 00:09:00</td></tr>
<tr fr-original-style="" style="box-sizing: border-box;"><td fr-original-style="" style="min-width: 5px; box-sizing: border-box; user-select: text; border: 1px solid rgb(221, 221, 221); height: 20px;"></td>
<td fr-original-style="" style="min-width: 5px; box-sizing: border-box; user-select: text; border: 1px solid rgb(221, 221, 221);">Pivot Tables</td>
<td fr-original-style="" style="min-width: 5px; box-sizing: border-box; user-select: text; border: 1px solid rgb(221, 221, 221); height: 20px;"></td>
<td fr-original-style="" style="min-width: 5px; box-sizing: border-box; user-select: text; border: 1px solid rgb(221, 221, 221);"> 00:08:00</td></tr>
<tr fr-original-style="" style="box-sizing: border-box;"><td colspan="4" fr-original-style="" style="min-width: 5px; box-sizing: border-box; user-select: text; border: 1px solid rgb(221, 221, 221);">Certificate and Transcript</td></tr>
<tr fr-original-style="" style="box-sizing: border-box;"><td fr-original-style="" style="min-width: 5px; box-sizing: border-box; user-select: text; border: 1px solid rgb(221, 221, 221); height: 20px;"></td>
<td fr-original-style="" style="min-width: 5px; box-sizing: border-box; user-select: text; border: 1px solid rgb(221, 221, 221);">Order Your Certificates or Transcripts</td>
<td fr-original-style="" style="min-width: 5px; box-sizing: border-box; user-select: text; border: 1px solid rgb(221, 221, 221); height: 20px;"></td>
<td fr-original-style="" style="min-width: 5px; box-sizing: border-box; user-select: text; border: 1px solid rgb(221, 221, 221);"> 00:00:00</td></tr></tbody></table></div>

</div>

Course Gate

Computing Skills

Computer Skills

Professional Skills Course (PSC)

Powerful Functions in Microsoft Excel

Bromley

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

MJ Electrical Training 

Construction Industry Scheme (CIS)

City & Guilds

Health & Safety

Electrical Testing

Wiring Regulations

Electrical Installation

Electrical Inspection & Testing

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

ECS Card Health & Safety Course Kent

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

ECS Card Health & Safety Course Bromley

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

ECS Card Health & Safety Course Dover

ECS Card Health & Safety Course Liverpool

ECS Card Health & Safety Course Newcastle

Real Estate AnalystThe 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&hellip;<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> Who will benefit from this course?<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> Day OneKnow how to build a property asset cash flow, analyse geared, and un-geared IRRs.<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> Day TwoKnow how to build a multi-let property cash flow and apply the concepts on a hypothetical case study.<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> Included in the Course<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> 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.comT - 01223 517851W - <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>



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

Bournemouth

London Waterloo Academy

Flight Attendant

Stewardess

FLIGHT ATTENDANT VIRTUAL VIA ZOOM COURSE, EVENINGS

Registration Fee

Course Fee



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">Duration1 Days6 CPD hoursThis course is intended forTo ensure success, students should have completed Excel Essentials and Excel Functions Including Pivot Tables and Lookups or have the equivalent knowledge and experience.OverviewUpon 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.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.</div><div id="course-pills-2"><h4>Working with Multiple Worksheets and Workbooks </h4><ul><li>Working with Named Ranges</li><li>Link Cells Across Worksheets and Workbooks </li><li>Use 3D References to Calculate Across Worksheets</li><li>Consolidate Data</li></ul><h4>Use Formula Auditing and Error Checking</h4><ul><li>Reveal Formulas</li><li>Trace Cell Precedents and Dependents </li><li>Locate Errors in Formulas </li><li>Watch and Evaluate Formulas </li></ul><h4>Reviewing and Protecting Workbooks </h4><ul><li>Control Data Entry via Data Validation</li><li>Protect Workbook Access</li><li>Protect Worksheets and Cell Content </li><li>Add and Edit Comments</li><li>Prepare a Workbook for Distribution </li><li>Modify Excel's Default Settings</li></ul><h4>Using Macros to Automate Workbook Functionality</h4><ul><li>Create Macros via Recording </li><li>Run Macros via Buttons and Shortcuts</li><li>Assign Macros to the Quick Access Toolbar and Ribbon </li><li>Assign Macros to Objects </li><li>View Macro Code</li></ul><h4>Forecasting and Analysis Data</h4><ul><li>Use Conditional Formatting to Highlight, Sort and Filter Key Data</li><li>Advanced Conditional Formatting using Formulas</li><li>Create Sparklines to Visualise Data</li><li>Add Trendlines to Charts to Visualise and Forecast Trends</li><li>Use Data Tables and Scenarios to Project Potential Outcomes </li><li>Use Goal Seek to Calculate Outcomes</li><li>Forecast Data Trends Using Solver</li></ul></div>

Nexus Human

Access VBA

Visual Basic Analysis

Microsoft Power Automate

Excel - Automating Excel with Macros and Analysis Tools

Tom Reynolds

Product Management

Agile

Agile PM

Productivity

Kanban

Agile Coach

Attend our world class Kanban University accredited Certified Kanban System Design training course and learn to implement Kanban in your company

Certified Kanban System Design – KMP I - 24-26 September

Standard

Early Bird

17390 Courses

Data Analysis, Automating and Visualisation in Excel

By Studyhub UK

Microsoft Office Excel 2016: Part 1 Beginner Level Course

By Study Plex

Microsoft Excel 2016: Data Analysis with PivotTables Course

By Study Plex

Excel Pivot Tables, Pivot Charts, Slicers, and Timelines

By Studyhub UK

Upgrade Excel Skill: 50 Best Tips

By Skill Up

Microsoft Office 2013 Excel Advanced - Complete Video Course

By John Academy

Level 3 Diploma in Microsoft Excel 2016

By Janets

Microsoft Office 2013 Excel Intermediate - Complete Video Course

By John Academy

Microsoft Office 2016 Excel Complete Video Course - Beginner, Intermediate & Advanced

By John Academy

Powerful Functions in Microsoft Excel

By Course Gate

Search By Location