Name: MS Excel: 50 Tips to Upgrade your Excel Skills
Price: 11.99 GBP
Availability: InStock

Excel Spreadsheet Training Course Tired of staring at endless rows and columns in frustration? Would you like to transform your data into insights that impress your boss and streamline your work? Then welcome to Excel Spreadsheet Training: Your Journey from Spreadsheet Novice to Spreadsheet Ninja!At the beginning of the Excel Spreadsheet Training course, you will acquire a thorough understanding of the Excel interface, confidently navigating and leveraging its features for efficient spreadsheet management. Besides, you will learn to enter and manipulate various data types, including text, numbers, time, logical values, and graphics, ensuring accurate and diverse information representation. This course will help you increase your productivity as you master Autofill and Speedfil functionalities, streamlining your workflow and saving valuable time during data entry. Additionally, this Excel Spreadsheet Training course will assist you in developing the skills to save files effectively, ensuring data security and accessibility while maintaining a well-organized digital workspace.Expertise in formulas increases Excel efficiency. In this Excel Spreadsheet Training course, you will gain a solid foundation in Formula Basics, understand the mathematical order behind formulas, and confidently create and manipulate them to suit your analytical needs. Furthermore, you will learn the art of copying relative and absolute formulas, facilitating efficient replication of calculations across your spreadsheet. As you move deeper into the Excel Spreadsheet Training course, you will learn the tricks and techniques to manage the sheets efficiently. When you finish the course, you will be introduced to the functions enabling you to harness Excel&rsquo;s full potential for complex data analysis and decision-making.Without any further delay, enrol in the Excel Spreadsheet Training course to make a fast progression in your career.&nbsp;Excel Spreadsheet Training Course Curriculum&nbsp; <ul fr-original-style="" style="box-sizing: border-box;"><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Tour of the Excel screen &nbsp; &nbsp; &nbsp; &nbsp;</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Entering Data &nbsp; &nbsp; &nbsp; &nbsp;</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Autofill Speedfill &nbsp; &nbsp; &nbsp; &nbsp;</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Saving the file &nbsp; &nbsp; &nbsp; &nbsp;</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Autosum &nbsp; &nbsp; &nbsp; &nbsp;</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Formula Basics &nbsp; &nbsp; &nbsp; &nbsp;</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Copying formulas &ndash; Relative Formulas &nbsp; &nbsp; &nbsp; &nbsp;</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Totals and Averages &nbsp; &nbsp; &nbsp; &nbsp;</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Formatting the Spreadsheet &nbsp; &nbsp; &nbsp; &nbsp;</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Managing the Sheets &nbsp; &nbsp; &nbsp; &nbsp;</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Copying formulas &ndash; absolute formulas &nbsp; &nbsp; &nbsp; &nbsp;</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Linking the Sheets together &nbsp; &nbsp; &nbsp; &nbsp;</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Introduction to Functions</li></ul>Why Choose Teachers TrainingSome of our website features are:<ul fr-original-style="" style="box-sizing: border-box;"><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">This is a dedicated website for teaching</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">24/7 tutor support</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Interactive Content</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Affordable price</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Courses accredited by the UK&#39;s top awarding bodies</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">100% online</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Flexible deadline</li></ul>Entry RequirementsNo formal entry requirements. You need to have:<ul fr-original-style="" style="box-sizing: border-box;"><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Passion for learning</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">A good understanding of the English language</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Be motivated and hard-working</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Over the age of 16.</li></ul>CertificationSuccessfully completing the MCQ exam of this course qualifies you for a CPD-accredited certificate from The Teachers Training. You will be eligible for both PDF copy and hard copy of the certificate to showcase your achievement however you wish.<ul fr-original-style="" style="box-sizing: border-box;"><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">You can get your digital certificate (PDF) for &pound;4.99 only</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Hard copy certificates are also available, and you can get one for only &pound;10.99</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">You can get both PDF and Hard copy certificates for just &pound;12.99!</li></ul>The certificate will add significant weight to your CV and will give you a competitive advantage when applying for jobs.

The Teachers Training

Unlock the full potential of Excel with our Spreadsheet Training Course. From basic functions to advanced techniques, learn how to navigate and utilize Excel effectively for data analysis, reporting, and organization. Whether you're a beginner or looking to enhance your skills, this course provides hands-on training to help you become proficient in Excel. Enroll now and excel in spreadsheet management, boosting your productivity and efficiency in any professional setting.

Excel Spreadsheet Training

General Admission

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

Nexus Human

Office Skills & Productivity

Visual Basic

Access VBA

Visual Basic Analysis

Computer Skills

Microsoft Excel

Programming and Data Wrangling with VBA and Excel

Packt

Information Management

Master 75+ Excel tips and techniques and become a certified POWER USER, with unique hands-on demos and real-world projects to help you wrangle, analyze, and visualize your data in Excel.

Excel Pro Tips: 75+ Tips to go from Excel Beginner to Pro [v]

<div>
					<div>
								<section>
						<div>
							<div>
					<div>
			<div>
							<div>
						<div>
				<div>
					</div>
				</div>
						</div>
					</div>
		</div>
								</div>
					</div>
		</section>
							</div>
				</div>
					<div>
						<div>
				<div>
									<section>
						<div>
							<div>
					<div>
			<div>
							<div>
						<div>
				<div>
								<div>
				<h3>Learning Objectives</h3>Introduction , Getting Started with Excel , Creating Workbooks and Using Templates , Entering Data , Excel Formula Basics , Adjusting a Worksheet , Formatting and Aligning Data , Using Cell Styles and Themes , Inserting Objects and Graphics , Proofing a Workbook , Printing an Excel File , Managing Worksheets , Navigating and Viewing Excel Files , Conclusion <h3>Pre-Requisites</h3>Basic Computer Skills <h3>Description</h3>Microsoft Excel is one of the major workhorses in the Microsoft Office suite of applications and arguably the most widely-used Office product. A solid understanding of how to use this program is vital to nearly everyone in most industries today. This course is designed specifically to teach you the fundamentals of Excel and give you the skills you need to begin to create and manipulate worksheets. Specifically, you will understand how to create, save, enter data, and print spreadsheets in addition to learning how to create formulas and use functions to calculate in Excel. You will learn how to enter data, format spreadsheets, manipulate columns and rows, add headers and footers, and use page setup options to prepare them for printing. You will also learn how to handle large worksheets or multiple workbooks, use styles and themes, insert various graphic objects, and options for proofing your workbooks.					</div>
						</div>
				</div>
						</div>
					</div>
		</div>
								</div>
					</div>
		</section>
									</div>
			</div>
					</div><table>				<tbody><tr>
					<td colspan="4">Section 01</td>
				</tr>
								<tr>
					<td></td>
					<td>Lesson 01: What is Excel</td>
					<td> </td>
					<td> 00:03:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Lesson 02: Opening Excel</td>
					<td> </td>
					<td> 00:04:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Lesson 03: Navigating the Excel User Interface-v2</td>
					<td> </td>
					<td> 00:06:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Lesson 04: Navigating the Excel User Interface</td>
					<td> </td>
					<td> 00:04:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Lesson 05: Using the Excel Ribbon</td>
					<td> </td>
					<td> 00:07:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Lesson 06: Understanding Excel Worksheet Components</td>
					<td> </td>
					<td> 00:07:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Lesson 07: Using the Backstage View</td>
					<td> </td>
					<td> 00:06:00</td>
				</tr>
								<tr>
					<td colspan="4">Section 02</td>
				</tr>
								<tr>
					<td></td>
					<td>Lesson 01: Creating a New Workbook</td>
					<td> </td>
					<td> 00:06:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Lesson 02: Saving an Excel Workbook</td>
					<td> </td>
					<td> 00:05:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Lesson 03: Using the Accessibility Checker</td>
					<td> </td>
					<td> 00:04:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Lesson 04: Using the Accessibility Checker-v3</td>
					<td> </td>
					<td> 00:04:00</td>
				</tr>
								<tr>
					<td colspan="4">Section 03</td>
				</tr>
								<tr>
					<td></td>
					<td>Lesson 01: Navigating a Worksheet by Mouse or Keyboard</td>
					<td> </td>
					<td> 00:05:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Lesson 02: Understanding Excel Data Types</td>
					<td> </td>
					<td> 00:04:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Lesson 03: Using the Inking Tools</td>
					<td> </td>
					<td> 00:05:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Lesson 04: Using the Inking Tools-v3</td>
					<td> </td>
					<td> 00:03:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Lesson 05: Working with Cell and Range Addressing</td>
					<td> </td>
					<td> 00:05:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Lesson 06: Using Various Data Selection Techniques</td>
					<td> </td>
					<td> 00:05:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Lesson 07: Working with Common Excel Commands</td>
					<td> </td>
					<td> 00:06:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Lesson 08: Using Flash Fill and Autofill</td>
					<td> </td>
					<td> 00:06:00</td>
				</tr>
								<tr>
					<td colspan="4">Section 04</td>
				</tr>
								<tr>
					<td></td>
					<td>Lesson 01: What are Formulas and Functions</td>
					<td> </td>
					<td> 00:05:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Lesson 02: Understanding the Components of a Formula</td>
					<td> </td>
					<td> 00:05:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Lesson 03: Understanding Calculation Hierarchy and the Order of Operations</td>
					<td> </td>
					<td> 00:03:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Lesson 04: Creating Basic Formulas</td>
					<td> </td>
					<td> 00:05:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Lesson 05: Working with Basic Functions and AutoSum</td>
					<td> </td>
					<td> 00:06:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Lesson 06: Using Cell References</td>
					<td> </td>
					<td> 00:05:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Lesson 07: Using the Quick Analysis Tool</td>
					<td> </td>
					<td> 00:03:00</td>
				</tr>
								<tr>
					<td colspan="4">Section 05</td>
				</tr>
								<tr>
					<td></td>
					<td>Lesson 01: Modifying Columns and Rows</td>
					<td> </td>
					<td> 00:06:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Lesson 02: Hiding and Unhiding Columns and Rows</td>
					<td> </td>
					<td> 00:06:00</td>
				</tr>
								<tr>
					<td colspan="4">Section 06</td>
				</tr>
								<tr>
					<td></td>
					<td>Lesson 01: Formatting and Aligning Data</td>
					<td> </td>
					<td> 00:07:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Lesson 02: Merging Data</td>
					<td> </td>
					<td> 00:07:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Lesson 03: Wrapping Text and Adjusting Orientation</td>
					<td> </td>
					<td> 00:06:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Lesson 04: Formatting Numbers</td>
					<td> </td>
					<td> 00:05:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Lesson 05: Using the Format Painter</td>
					<td> </td>
					<td> 00:04:00</td>
				</tr>
								<tr>
					<td colspan="4">Section 07</td>
				</tr>
								<tr>
					<td></td>
					<td>Lesson 01: Using Cell Styles</td>
					<td> </td>
					<td> 00:06:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Lesson 02: Applying Themes</td>
					<td> </td>
					<td> 00:05:00</td>
				</tr>
								<tr>
					<td colspan="4">Section 08</td>
				</tr>
								<tr>
					<td></td>
					<td>Lesson 01: Inserting and Formatting Images and Shapes</td>
					<td> </td>
					<td> 00:08:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Lesson 02: Inserting and Formatting SmartArt</td>
					<td> </td>
					<td> 00:05:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Lesson 03: Working with Icons</td>
					<td> </td>
					<td> 00:04:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Lesson 04: Inserting Hyperlinks</td>
					<td> </td>
					<td> 00:06:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Lesson 05: Inserting Symbols and Equations</td>
					<td> </td>
					<td> 00:05:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Lesson 06: Inserting WordArt and Text Boxes</td>
					<td> </td>
					<td> 00:05:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Lesson 07: Inserting 3-D Models</td>
					<td> </td>
					<td> 00:04:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Lesson 08: Arranging Objects</td>
					<td> </td>
					<td> 00:06:00</td>
				</tr>
								<tr>
					<td colspan="4">Section 09</td>
				</tr>
								<tr>
					<td></td>
					<td>Lesson 01: Using Find and Replace</td>
					<td> </td>
					<td> 00:05:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Lesson 02: Using Go To and Go To Special</td>
					<td> </td>
					<td> 00:03:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Lesson 03: Using the Spell Checker</td>
					<td> </td>
					<td> 00:05:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Lesson 04: Using the Thesaurus and Translation Features</td>
					<td> </td>
					<td> 00:05:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Lesson 05: Using the resolve Feature-v3</td>
					<td> </td>
					<td> 00:02:00</td>
				</tr>
								<tr>
					<td colspan="4">Section 10</td>
				</tr>
								<tr>
					<td></td>
					<td>Lesson 01: Printing and Previewing Excel Files</td>
					<td> </td>
					<td> 00:06:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Lesson 02: Creating Custom Margins and Scaling</td>
					<td> </td>
					<td> 00:05:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Lesson 03: Adding Headers and Footers</td>
					<td> </td>
					<td> 00:04:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Lesson 04: Formatting a Page with the Page Layout Tab</td>
					<td> </td>
					<td> 00:06:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Lesson 05: Printing Titles and Specific Worksheet Areas</td>
					<td> </td>
					<td> 00:03:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Lesson 06: Exporting to PDF-v3</td>
					<td> </td>
					<td> 00:02:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Lesson 07: Exporting to PDF and XPS</td>
					<td> </td>
					<td> 00:04:00</td>
				</tr>
								<tr>
					<td colspan="4">Section 11</td>
				</tr>
								<tr>
					<td></td>
					<td>Lesson 01: Renaming and Coloring Worksheet Tabs</td>
					<td> </td>
					<td> 00:03:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Lesson 02: Adding, Deleting and Navigating Worksheets</td>
					<td> </td>
					<td> 00:03:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Lesson 03: Hiding and Unhiding Worksheets</td>
					<td> </td>
					<td> 00:03:00</td>
				</tr>
								<tr>
					<td colspan="4">Section 12</td>
				</tr>
								<tr>
					<td></td>
					<td>Lesson 01: Viewing Workbooks</td>
					<td> </td>
					<td> 00:03:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Lesson 02: Using Zoom Tools</td>
					<td> </td>
					<td> 00:03:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Lesson 03: Configuring Sheet Options</td>
					<td> </td>
					<td> 00:05:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Lesson 04: Using the Freeze Panes and Split Commands</td>
					<td> </td>
					<td> 00:04:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Lesson 05: Adjusting Worksheet Properties</td>
					<td> </td>
					<td> 00:04:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Lesson 06: Viewing Workbook Statistics-v3</td>
					<td> </td>
					<td> 00:02:00</td>
				</tr>
								<tr>
					<td colspan="4">Course Recap</td>
				</tr>
								<tr>
					<td></td>
					<td>Recap</td>
					<td> </td>
					<td> 00:02:00</td>
				</tr>
								<tr>
					<td colspan="4">Final Exam</td>
				</tr>
								<tr>
					<td></td>
					<td>Final Exam - Excel 365 Beginner</td>
					<td> </td>
					<td> 00:20:00</td>
				</tr>
				</tbody></table>

iStudy UK

Computing Skills

Office Skills

Microsoft Office

Excel 365 Beginner

Become an Excel expert in a matter of hours and manage everyday office tasks faster and more efficiently with Mastering MS Excel. This course is ideal for experts in administrative and IT-based roles who want to improve their proficiency in Microsoft Office.Throughout this Microsoft Excel training course, you will develop valuable administrative skills which will assist you in automating everyday work tasks, collaborating on spreadsheets, and data management. Taking you from beginner to advanced levels, you will learn how to create a basic spreadsheet, perform a financial analysis, insert tables, record macros and much more.&nbsp;On successful completion, you will have a solid knowledge of how to utilise the world&rsquo;s leading spreadsheet program for business administration and master basic and complex work tasks.Learning Outcomes of The Mastering MS Excel<ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">Master the functions and features of the world&rsquo;s leading spreadsheet program</li><li fr-original-style="" style="box-sizing: border-box;">Develop fundamental career-boosting skills in office administration</li><li fr-original-style="" style="box-sizing: border-box;">Learn how to automate tasks and collaborate on worksheets</li><li fr-original-style="" style="box-sizing: border-box;">Go from a beginner to an expert in Excel in a matter of hours</li><li fr-original-style="" style="box-sizing: border-box;">Get step-by-step training on how to calculate sums, totals and averages</li><li fr-original-style="" style="box-sizing: border-box;">Understand how to create different types of graphs and charts</li><li fr-original-style="" style="box-sizing: border-box;">Learn how to record macros to automate everyday administrative tasks</li><li fr-original-style="" style="box-sizing: border-box;">Get to grips with intermediate Excel functions including VLOOKUP, COUNTIF and AVERAGIF</li><li fr-original-style="" style="box-sizing: border-box;">Be trained on how to create a custom autofill for your data &amp; save time for other tasks</li></ul>Why choose this course<ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">Earn an 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>Course DesignThe 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;">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>Certificate of AchievementEndorsed Certificate of Achievement from the Quality Licence SchemeOnce the course has been completed and the assessment has been passed, all students are entitled to receive an endorsed certificate. This will provide proof that you have completed your training objectives, and each endorsed certificate can be ordered and delivered to your address for only &pound;119. Please note that overseas students may be charged an additional &pound;10 for postage.CPD Certificate of Achievement from JanetsUpon successful completion of the course, you will be able to obtain your course completion e-certificate. Print copy by post is also available at an additional cost of &pound;9.99 and PDF Certificate at &pound;4.99.EndorsementThis course and/or training programme has been endorsed by the Quality Licence Scheme for its high-quality, non-regulated provision and training programmes. This course and/or training programme is not regulated by Ofqual and is not an accredited qualification. Your training provider will be able to advise you on any further recognition, for example progression routes into further and/or higher education. For further information please visit the Learner FAQs on the Quality Licence Scheme website.Method of AssessmentTo ensure the Quality Licensing Scheme is endorsed and CPD acknowledged certificate, learners need to score at least 60% pass marks on the assessment process. After submitting assignments, our expert tutors will evaluate the assignments and give feedback based on their performance. After passing the assessment, one can apply for a certificate.Course Contents<ul fr-original-style="" style="box-sizing: border-box;"><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Getting Started with Microsoft Office Excel 2016</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Performing Calculations</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Modifying a Worksheet</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Formatting a Worksheet</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Printing Workbooks</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Managing Workbooks</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Working with Functions</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Working with Lists</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Analyzing Data</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Visualizing Data with Charts</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Using PivotTables and PivotCharts</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Working with Multiple Worksheets and Workbooks</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Using Lookup Functions and Formula Auditing</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Sharing and Protecting Workbooks</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Automating Workbook Functionality</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Creating Sparklines and Mapping Data</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Forecasting Data</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Resources</li></ul>

Janets

WordPress

Excel Analytics

Become an expert in Microsoft Excel with our comprehensive online training program. Learn formulas, charts, pivot tables, data analysis, macros, and more. Develop in-demand Excel skills through hands-on exercises and project work. Gain proficiency in this powerful software to advance your career or improve productivity.

Mastering MS Excel

<div>
					<div>
								<section>
						<div>
							<div>
					<div>
			<div>
							<div>
						<div>
				<div>
					</div>
				</div>
						</div>
					</div>
		</div>
								</div>
					</div>
		</section>
							</div>
				</div>
			<h3>Description</h3>
This course is aimed at the excel user who already knows the basics of Excel 2007. This course will help you to go beyond the basics - to reach a higher-intermediate level. With shortcuts, tricks and tips - you will be able to work smarter and faster.
If you want to be fairly competent on the software, then this course will be very handy. Its a lot quicker to be shown things, then to try and muddle through and work things out by yourself. Guaranteed, there'll be some items which we cover, that you have no idea that Excel was capable of doing!
We don't want you to spend a day of your life in the classroom... learn 99 quick and very useful, practical things which you can apply on your job or on your projects.
We'll cover:
<ul>
<li>Working with Data - using series, symbols and special characters, hide rows and freeze panels</li>
<li>Formulas and Functions - Calculate the duration between two dates/times, best loan terms, create conditional formula and conditional sums</li>
<li>Copying Data - transposing rows into columns and paste specials</li>
<li>Using Excel lists - sort and filter a list, remove duplicate records, count filtered records, look up information in a list</li>
<li>Data Patterns - Pivot tables, pivot charts, what-if analysis</li>
<li>Creating charts - histogram, trendlines, piecharts, error bars</li>
<li>Presenting data - formatting columns and numbers</li>
<li>Saving and printing worksheets - printing multiple worksheets, area, cell ranges, repeat headings of a row or column</li>
<li>Extending excel - hyperlinks, embed a chart, importing a worksheet</li>
<li>Customizing Excel - custom workspace, custom view, macros</li>
</ul>
The target audience is those who have a basic level with Excel and want to learn other handy functions and features. We use Excel 2007 only in this course. If you have Excel 2003, this course will be difficult to follow as although the functions and features exist in 2003, the layout changed very dramatically between the two versions. Excel 2007 isn't too dissimilar from 2010.
Where necessary, we provide a spreadsheet - but as long as you have Excel 2007, you'll be able to copy and do exactly what you see on the screen by pausing the video and following along.
The course will take approx 7.5 hours to complete.
Take this course if you want to take your basic understanding of Excel to a higher intermediate-level.
<h3>What Will I Learn?</h3>
<ul>
<li>Work with Formulas and Functions</li>
<li>Copy data and formats</li>
<li>Use excel lists</li>
<li>Create charts</li>
<li>Present worksheets nicely</li>
<li>Save and print worksheets</li>
</ul>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<h3>Who is the target audience?</h3>
<ul>
<li>This is for those who are beginners in Excel and want to take it further to higher intermediate level - using Excel 2007</li>
<li>You should know the 'basics' in Excel and we take it from near-beginner, to higher intermediate</li>
</ul>
<h3>Requirements</h3>
<div>
<ul>
<li>Students will need to have Excel 2007 installed, as this is the system used in the teaching</li>
</ul>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
<div>
<div>
<div></div>
</div>
</div>
</div><table>				<tbody><tr>
					<td colspan="4">Introduction to the course and your tutor</td>
				</tr>
								<tr>
					<td colspan="4">Data</td>
				</tr>
								<tr>
					<td></td>
					<td>Enter numbers and fractions</td>
					<td> </td>
					<td> 00:05:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Dates and Times</td>
					<td> </td>
					<td> 00:08:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Name Cells and Ranges</td>
					<td> </td>
					<td> 00:04:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Validate Data entry using a pick list</td>
					<td>FREE </td>
					<td> 00:07:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Extend a series of dates with autofill</td>
					<td> </td>
					<td> 00:04:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Add a symbol or special character</td>
					<td> </td>
					<td> 00:04:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Compare multiple spreadsheets using freeze panels</td>
					<td> </td>
					<td> 00:06:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Hide rows</td>
					<td> </td>
					<td> 00:04:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Keyboard</td>
					<td> </td>
					<td> 00:10:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Speak Cells</td>
					<td> </td>
					<td> 00:04:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Find and replace data</td>
					<td> </td>
					<td> 00:10:00</td>
				</tr>
								<tr>
					<td colspan="4">Formulas and Functions</td>
				</tr>
								<tr>
					<td></td>
					<td>Add values</td>
					<td> </td>
					<td> 00:03:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Function wizard</td>
					<td> </td>
					<td> 00:06:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Formulas with comments</td>
					<td> </td>
					<td> 00:04:00</td>
				</tr>
								<tr>
					<td></td>
					<td>OneNote</td>
					<td> </td>
					<td> 00:06:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Define a constant</td>
					<td> </td>
					<td> 00:04:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Apply names in functions</td>
					<td> </td>
					<td> 00:05:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Figure out the best loan terms</td>
					<td> </td>
					<td> 00:04:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Internal Rates of Return</td>
					<td> </td>
					<td> 00:04:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Nth largest value</td>
					<td> </td>
					<td> 00:04:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Large, Small, Max, Min</td>
					<td> </td>
					<td> 00:04:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Conditional formula</td>
					<td> </td>
					<td> 00:03:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Conditional formula with names</td>
					<td> </td>
					<td> 00:04:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Conditional sum</td>
					<td> </td>
					<td> 00:03:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Count If</td>
					<td> </td>
					<td> 00:02:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Inner calculator</td>
					<td> </td>
					<td> 00:02:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Square Roots</td>
					<td> </td>
					<td> 00:03:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Calculate the duration between two times</td>
					<td> </td>
					<td> 00:04:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Calculate days between two dates</td>
					<td> </td>
					<td> 00:04:00</td>
				</tr>
								<tr>
					<td colspan="4">Copying Data, Formats etc.,</td>
				</tr>
								<tr>
					<td></td>
					<td>Copy a range</td>
					<td> </td>
					<td> 00:03:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Transpose a row into a column</td>
					<td>FREE </td>
					<td> 00:02:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Chart formatting</td>
					<td> </td>
					<td> 00:07:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Copy styles to another workbook</td>
					<td> </td>
					<td> 00:07:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Paste special and copying worksheets</td>
					<td> </td>
					<td> 00:06:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Track changes while Editing</td>
					<td> </td>
					<td> 00:06:00</td>
				</tr>
								<tr>
					<td colspan="4">Lists</td>
				</tr>
								<tr>
					<td></td>
					<td>Enter list data using a form</td>
					<td> </td>
					<td> 00:05:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Searching through a data list</td>
					<td> </td>
					<td> 00:04:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Import a word list into excel</td>
					<td> </td>
					<td> 00:04:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Sort a list</td>
					<td> </td>
					<td> 00:02:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Filter a list</td>
					<td> </td>
					<td> 00:02:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Sort by multiple criteria</td>
					<td>FREE </td>
					<td> 00:03:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Find averages in a sorted group</td>
					<td> </td>
					<td> 00:05:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Filter by multiple criteria</td>
					<td> </td>
					<td> 00:03:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Remove duplicate records from a list</td>
					<td> </td>
					<td> 00:03:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Count filtered records</td>
					<td> </td>
					<td> 00:07:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Filter by multiple criteria in the same column</td>
					<td> </td>
					<td> 00:06:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Chart a filtered list</td>
					<td> </td>
					<td> 00:02:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Look up information in a List</td>
					<td> </td>
					<td> 00:05:00</td>
				</tr>
								<tr>
					<td colspan="4">Data Patterns</td>
				</tr>
								<tr>
					<td></td>
					<td>Create a PivotTable</td>
					<td> </td>
					<td> 00:05:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Modify a PivotTable and layout</td>
					<td> </td>
					<td> 00:03:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Find the average of a field</td>
					<td> </td>
					<td> 00:04:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Create a calculated field</td>
					<td> </td>
					<td> 00:03:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Calculated fields and charts</td>
					<td>FREE </td>
					<td> 00:02:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Hide rows and columns in a PivotTable</td>
					<td> </td>
					<td> 00:02:00</td>
				</tr>
								<tr>
					<td></td>
					<td>AutoFormat a PivotTable</td>
					<td> </td>
					<td> 00:01:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Create a PivotChart</td>
					<td> </td>
					<td> 00:03:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Turning on the Data Analysis function so that statistical information can be run</td>
					<td> </td>
					<td> 00:02:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Describe Data with Statistics</td>
					<td> </td>
					<td> 00:03:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Discover associations within your data</td>
					<td> </td>
					<td> 00:03:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Product Numbers</td>
					<td> </td>
					<td> 00:02:00</td>
				</tr>
								<tr>
					<td></td>
					<td>What-if analysis</td>
					<td> </td>
					<td> 00:05:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Goal seek</td>
					<td> </td>
					<td> 00:06:00</td>
				</tr>
								<tr>
					<td colspan="4">Creating Charts</td>
				</tr>
								<tr>
					<td></td>
					<td>Create a Chart</td>
					<td> </td>
					<td> 00:06:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Modify Chart details</td>
					<td> </td>
					<td> 00:04:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Change the Chart Type</td>
					<td> </td>
					<td> 00:03:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Add a Trendline to a Chart</td>
					<td> </td>
					<td> 00:06:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Remove Chart Data</td>
					<td> </td>
					<td> 00:02:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Add chart data</td>
					<td> </td>
					<td> 00:02:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Missing chart data</td>
					<td> </td>
					<td> 00:04:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Error bars</td>
					<td> </td>
					<td> 00:04:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Pull a slice from a Pie Chart</td>
					<td> </td>
					<td> 00:03:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Label slices of a Pie Chart</td>
					<td> </td>
					<td> 00:04:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Histogram</td>
					<td> </td>
					<td> 00:06:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Paste a chart into Word</td>
					<td> </td>
					<td> 00:03:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Amending a chart in Word</td>
					<td> </td>
					<td> 00:02:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Paste-link a Chart into Word</td>
					<td> </td>
					<td> 00:05:00</td>
				</tr>
								<tr>
					<td colspan="4">Worksheets</td>
				</tr>
								<tr>
					<td></td>
					<td>Format Numbers as Percentages</td>
					<td> </td>
					<td> 00:04:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Format Currencies in Currency and Accounting Formats</td>
					<td> </td>
					<td> 00:03:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Format Column Headings</td>
					<td> </td>
					<td> 00:05:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Format Quickly with Format painter</td>
					<td>FREE </td>
					<td> 00:02:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Insert a background image into your worksheet</td>
					<td> </td>
					<td> 00:03:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Create a Transparent image</td>
					<td> </td>
					<td> 00:03:00</td>
				</tr>
								<tr>
					<td colspan="4">Saving and Printing Worksheets</td>
				</tr>
								<tr>
					<td></td>
					<td>Save a workbook as a Template</td>
					<td> </td>
					<td> 00:07:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Save a workbook as an XML spreadsheet</td>
					<td> </td>
					<td> 00:05:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Print multiple cell ranges on One Page</td>
					<td> </td>
					<td> 00:03:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Print multiple worksheets of a workbook</td>
					<td> </td>
					<td> 00:01:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Page set up, header, footer, margins - 1 page printing</td>
					<td> </td>
					<td> 00:04:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Repeat Headings of a Row or Column</td>
					<td> </td>
					<td> 00:07:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Print functions to show calculations &amp; comments</td>
					<td> </td>
					<td> 00:07:00</td>
				</tr>
								<tr>
					<td colspan="4">Extending Excel</td>
				</tr>
								<tr>
					<td></td>
					<td>Hyperlink a worksheet to another office document</td>
					<td> </td>
					<td> 00:03:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Embed a chart within PowerPoint</td>
					<td> </td>
					<td> 00:05:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Publish an Interactive Workbook</td>
					<td> </td>
					<td> 00:05:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Import a Worksheet into Access</td>
					<td> </td>
					<td> 00:09:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Use Excel Data to create labels in Word</td>
					<td> </td>
					<td> 00:10:00</td>
				</tr>
								<tr>
					<td colspan="4">Customizing Excel</td>
				</tr>
								<tr>
					<td></td>
					<td>Launch a specific Workbook when Excel Opens</td>
					<td> </td>
					<td> 00:03:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Save Time by Creating a Custom View</td>
					<td> </td>
					<td> 00:03:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Create a Custom Number Format</td>
					<td> </td>
					<td> 00:06:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Changing Text to Columns</td>
					<td> </td>
					<td> 00:05:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Create a Macro to Format Numbers</td>
					<td> </td>
					<td> 00:06:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Online Live Webinar Course-S3_W4_L1 - 42 - Excel Made simple</td>
					<td> </td>
					<td> 01:00:00</td>
				</tr>
				</tbody></table>

Spreadsheet

Excel 2007 Simplified

<h2 style="color: var(--text-heading); box-sizing: border-box;" id="isPasted" fr-original-style="color: var(--text-heading);">This course at a glance</h2><ul style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);"><li style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);">Accredited by CPDQE</li><li id="isPasted" fr-original-style="" style="box-sizing: border-box;">Master Excel from A-Z</li><li fr-original-style="" style="box-sizing: border-box;">Save time and boost your productivity in Excel</li><li fr-original-style="" style="box-sizing: border-box;">Find a value using VLOOKUP, HLOOKUP, INDEX, and MATCH</li><li fr-original-style="" style="box-sizing: border-box;">Become proficient in math, statistics, logic, and text functions</li><li fr-original-style="" style="box-sizing: border-box;">Get started with VBA and macros</li><li fr-original-style="" style="box-sizing: border-box;">Learn to use VLOOKUP/HLOOKUP in formulas</li><li fr-original-style="" style="box-sizing: border-box;">Create basic and advanced formulas</li><li fr-original-style="" style="box-sizing: border-box;">Master Pivot Tables</li><li fr-original-style="" style="box-sizing: border-box;">Create Charts from your data</li><li fr-original-style="" style="box-sizing: border-box;">Learn how to become a professional data analyst</li><li fr-original-style="" style="box-sizing: border-box;">Become an Excel expert and land your first job</li></ul><div data-id="4afcd14" data-element_type="widget" data-widget_type="text-editor.default" style="color: rgb(35, 35, 35); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(35, 35, 35);">For educational purposes or during job interviews, you must have a fundamental understanding of Microsoft Excel. Today&rsquo;s world requires a solid grasp of these skills. This course teaches you everything you need to know about Microsoft Excel to succeed in the job market.The&nbsp;Microsoft Excel&nbsp;course covers all the skills needed to become a master of this widely popular spreadsheet application. We will teach you expert data analysis skills using Microsoft Excel if you&rsquo;re tired of other sophisticated data analysis tools. Using a few simple functions and formulas, you can finish complex calculations within a blink of an eye. You&rsquo;ll be an expert at pivot tables and macros, which will make your professional tasks ten times easier. To sum it up, this course will help you become proficient in Microsoft Excel so that you can start your career immediately.An expert instructor designed this&nbsp;&ldquo;Microsoft Excel&rdquo;&nbsp;course to provide you with the best learning experience possible. Our goal is for you to learn and apply the lessons from this course to improve yourself.Grab the course. Enrol Now!</div><h3 style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">Accredited by</h3>This course is CPDQE&nbsp;accredited, which serves as an impactful mechanism for skill enhancement.&nbsp;Continuing Professional Development (CPD) stands as a crucial, widely acknowledged method that aids individuals, organisations, and entire industries in staying current with their skills and knowledge.CPD not only facilitates the elevation of global standards and benchmarks, aligning with the growing forces of globalisation and consumer expectations but also transforms learning into a deliberate and proactive process. It motivates professionals to uphold a consistently high level of performance and demonstrates their unwavering commitment to a specific job role or profession. Course Curriculum<ul fr-original-style="" style="box-sizing: border-box;"><li id="isPasted" fr-original-style="" style="box-sizing: border-box;">Section 1: Introduction</li><li fr-original-style="" style="box-sizing: border-box;">Section 2: Getting Started with Excel</li><li fr-original-style="" style="box-sizing: border-box;">Section 3: Values, Referencing and Formulas</li><li fr-original-style="" style="box-sizing: border-box;">Section 4: Intro to Excel Functions</li><li fr-original-style="" style="box-sizing: border-box;">Section 5: Adjusting Excel Worksheets</li><li fr-original-style="" style="box-sizing: border-box;">Section 6: Visually Pleasing Cell Formatting</li><li fr-original-style="" style="box-sizing: border-box;">Section 7: How to insert Images and Shapes!</li><li fr-original-style="" style="box-sizing: border-box;">Section 8: Visualize Data with Charts</li><li fr-original-style="" style="box-sizing: border-box;">Section 9: Excel&#39;s Printing Options</li><li fr-original-style="" style="box-sizing: border-box;">Section 10: Benefits of Using Excel Templates</li><li fr-original-style="" style="box-sizing: border-box;">Section 11: Working with Excel Datasets</li><li fr-original-style="" style="box-sizing: border-box;">Section 12: Excel Database Functions</li><li fr-original-style="" style="box-sizing: border-box;">Section 13: Excel Data Validation</li><li fr-original-style="" style="box-sizing: border-box;">Section 14: Excel PivotTables</li><li fr-original-style="" style="box-sizing: border-box;">Section 15: Excel&#39;s PowerPivot Add-In</li><li fr-original-style="" style="box-sizing: border-box;">Section 16: Excel&#39;s Conditional Functions</li><li fr-original-style="" style="box-sizing: border-box;">Section 17: Excel&#39;s Lookup Functions</li><li fr-original-style="" style="box-sizing: border-box;">Section 18: Text Based Functions in Excel</li><li fr-original-style="" style="box-sizing: border-box;">Section 19: Auditing Formulas &amp; Custom Views in Excel</li><li fr-original-style="" style="box-sizing: border-box;">Section 20: Excel&rsquo;s &ldquo;What If?&rdquo; Tools</li><li fr-original-style="" style="box-sizing: border-box;">Section 21: Welcome to Excel VBA!</li><li fr-original-style="" style="box-sizing: border-box;">Section 22: The VBA Language</li><li fr-original-style="" style="box-sizing: border-box;">Section 23: Writing VBA Code</li><li fr-original-style="" style="box-sizing: border-box;">Section 24: Important VBA Tools and Logic</li><li fr-original-style="" style="box-sizing: border-box;">Section 25: Excel VBA Loops</li><li fr-original-style="" style="box-sizing: border-box;">Section 26: Triggering Macros</li><li fr-original-style="" style="box-sizing: border-box;">Section 27: Excel UserForms</li><li fr-original-style="" style="box-sizing: border-box;">Section 28: Starting a Career in Excel</li></ul>

LearnDrive UK

This course will fully prepare you for virtually any Excel-related career path



<section>
						<div>
				<div>
				<div>
			<div>
					<div>
				<div>
				<div>
					<div>
			<div></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 Excel: Top 50 Microsoft Excel Formulas in 50 Minutes! has been specially designed to help learners gain a good command of Excel: Top 50 Microsoft Excel Formulas in 50 Minutes!, providing them with a solid foundation of knowledge to become a qualified professional.Through this Excel: Top 50 Microsoft Excel Formulas in 50 Minutes!, you will gain both practical and theoretical understanding of Excel: Top 50 Microsoft Excel Formulas in 50 Minutes! 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>
		</div></section>
				<section>
						<div>
				<div>
				<div>
			<div>
					<div>
				<div>
				<div>
			<h2> Learning outcome</h2>		</div>
				</div>
				<div>
				<div>
					<ul>
							<li>
											
													
										Familiar yourself with the recent development and updates of the relevant industry
									</li>
								<li>
											
													
										Know how to use your theoretical 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>
				<section>
						<div>
				<div>
				<div>
			<div>
					<div>
				<div>
				<div>
					</div>
				</div>
				<div>
				<div>
					
			</div>
				</div>
						</div>
			</div>
		</div>
						</div>
			</div>
		</section>
				<section>
						<div>
				<div>
				<div>
			<div>
					<div>
				<div>
				<div>
			<h2> Why should I take this course?</h2>		</div>
				</div>
				<div>
				<div>
					<ul>
							<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 people to transform their careers.
									</li>
								<li>
											
													
										You will be able to incorporate various techniques successfully and understand your customers better.
									</li>
						</ul>
				</div>
				</div>
						</div>
			</div>
		</div>
						</div>
			</div>
		</section>
				<section>
						<div>
				<div>
				<div>
			<div>
					<div>
				<div>
				<div>
			<h2> Requirements</h2>		</div>
				</div>
				<div>
				<div>
					<ul>
							<li>
											
													
										No formal qualifications required, anyone from any academic background can take this course.
									</li>
								<li>
											
													
										Access to a computer or digital device with internet connectivity.
									</li>
						</ul>
				</div>
				</div>
						</div>
			</div>
		</div>
						</div>
			</div>
		</section><div>
 <div>
 <h2>Course Curriculum</h2>
 </div>
 			<div>
				

<div>
<table width="100%">				<tbody><tr>
					<td colspan="4"> Excel: Top 50 Microsoft Excel Formulas in 50 Minutes!</td>
				</tr>
								<tr>
					<td>▶</td>
					<td>Excel promo</td><td>🕐 00:01:00</td>
				</tr>
								<tr>
					<td>▶</td>
					<td>Getting the most of the course</td><td>🕐 00:01:00</td>
				</tr>
								<tr>
					<td>▶</td>
					<td>How to Get the most of the course</td><td>🕐 00:01:00</td>
				</tr>
								<tr>
					<td>▶</td>
					<td>Text formulas in Excel</td><td>🕐 00:08:00</td>
				</tr>
								<tr>
					<td>▶</td>
					<td>Text Formulas Exercise</td><td>🕐 00:01:00</td>
				</tr>
								<tr>
					<td>▶</td>
					<td>Text Formulas Exercise (answers)</td><td>🕐 00:01:00</td>
				</tr>
								<tr>
					<td>▶</td>
					<td>Mathematical Formulas In Excel</td><td>🕐 00:04:00</td>
				</tr>
								<tr>
					<td>▶</td>
					<td>Mathematical Formulas Exercise</td><td>🕐 00:01:00</td>
				</tr>
								<tr>
					<td>▶</td>
					<td>Mathematical Formulas Exercise (answers)</td><td>🕐 00:01:00</td>
				</tr>
								<tr>
					<td>▶</td>
					<td>Date and Time Formulas In Excel</td><td>🕐 00:05:00</td>
				</tr>
								<tr>
					<td>▶</td>
					<td>Date and Time Formulas Exercise</td><td>🕐 00:01:00</td>
				</tr>
								<tr>
					<td>▶</td>
					<td>Date and Time Exercise Formulas (answers)</td><td>🕐 00:01:00</td>
				</tr>
								<tr>
					<td>▶</td>
					<td>Logic Formulas In Excel</td><td>🕐 00:12:00</td>
				</tr>
								<tr>
					<td>▶</td>
					<td>Logic Formula Exercise</td><td>🕐 00:01:00</td>
				</tr>
								<tr>
					<td>▶</td>
					<td>Logic Formula Exercise (answers)</td><td>🕐 00:01:00</td>
				</tr>
								<tr>
					<td>▶</td>
					<td>Financial Formula In Excel</td><td>🕐 00:06:00</td>
				</tr>
								<tr>
					<td>▶</td>
					<td>Financial Formula Exercise</td><td>🕐 00:01:00</td>
				</tr>
								<tr>
					<td>▶</td>
					<td>Financial Formula Exercise (answers)</td><td>🕐 00:02:00</td>
				</tr>
								<tr>
					<td>▶</td>
					<td>Informational Formula In Excel</td><td>🕐 00:04:00</td>
				</tr>
								<tr>
					<td>▶</td>
					<td>Informational Formula Exercise</td><td>🕐 00:01:00</td>
				</tr>
								<tr>
					<td>▶</td>
					<td>Informational Formula Exercise (answers)</td><td>🕐 00:01:00</td>
				</tr>
								<tr>
					<td>▶</td>
					<td>Getting Traffic To Your Site</td><td>🕐 01:00:00</td>
				</tr>
								<tr>
					<td colspan="4">Additional Resources</td>
				</tr>
								<tr>
					<td></td>
					<td>Resources : Excel: Top 50 Microsoft Excel Formulas in 50 Minutes!</td><td>🕐 00:00:00</td>
				</tr>
				</tbody></table></div>

			</div>
		 </div>

Skill Up

Online Course Marketing

Finance Cert & Exam Prep

Microsoft Forms

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

Excel: Top 50 Microsoft Excel Formulas in 50 Minutes!

<div id="course-pills-1">Duration2 Days12 CPD hoursThis course is intended forThis course is designed for students who already have foundational knowledge and skills in Excel and who wish to perform robust and advanced data and statistical analysis with Microsoft Excel using PivotTables, use tools such as Power Pivot and the Data Analysis ToolPak to analyze data, and visualize data and insights using advanced visualizations in charts and dashboards in Excel. To ensure success, you should have baseline skill using Microsoft Excel worksheets, particularly in creating workbooks with formulas and functionOverview#NAME?Analyzing data to find issues, insights and opportunities, is now a critical part of many job roles. Beyond the analysis, data analysts in all job roles must be able to effectively present and communicate their findings in visually compelling ways. MicrosoftÂ© ExcelÂ© is designed for this purpose. Excel can connect to a wide range of data sources, perform robust data analysis and create diverse and robust data-backed visualizations to show insights, trends, and create reports. These capabilities enable people who use Excel for data analysis to turn data into thoughtful action.</div><div id="course-pills-2"><h3>1 - DATA ANALYSIS FUNDAMENTALS</h3> <ul> <li>Introduction to Data Science</li> <li>Create and Modify Tables</li> <li>Sort and Filter Data</li> </ul> <h3>2 - VISUALIZING DATA WITH EXCEL</h3> <ul> <li>Visualize Data with Charts</li> <li>Modify and Format Charts</li> <li>Apply Best Practices in Chart Design</li> </ul> <h3>3 - ANALYZING DATA WITH FORMULAS AND FUNCTIONS</h3> <ul> <li>Analyze Data with Formulas and Named Ranges</li> <li>Analyze Data with Functions</li> <li>Implement Data Validation, Forms, and Controls</li> <li>Create Conditional Visualizations with Lookup Functions</li> </ul> <h3>4 - ANALYZING DATA WITH PIVOTTABLES</h3> <ul> <li>Create a PivotTable</li> <li>Analyze PivotTable Data</li> </ul> <h3>5 - PRESENTING VISUAL INSIGHTS WITH DASHBOARDS IN EXCEL</h3> <ul> <li>Visualize Data with PivotCharts</li> <li>Filter Data Using Slicers and Timelines</li> <li>Create a Dashboard in Excel</li> </ul> <h3>6 - CREATING GEOSPATIAL VISUALIZATIONS WITH EXCEL</h3> <ul> <li>Create Map Charts in Excel</li> <li>Customize Map Charts in Excel</li> </ul> <h3>7 - PERFORMING STATISTICAL ANALYSIS</h3> <ul> <li>Visualize Trendlines and Sparklines with Excel</li> <li>Analyze Data with the Data Analysis ToolPa</li> </ul> <h3>8 - GETTING AND TRANSFORMING DATA</h3> <ul> <li>Connect to Data with Queries</li> <li>Clean and Combine Data</li> <li>Shape and Transform Data</li> </ul> <h3>9 - MODELING AND ANALYZING DATA WITH POWER PIVOT</h3> <ul> <li>Install Power Pivot in Excel</li> <li>Create Data Models with Power Pivot</li> <li>Create Power Pivots</li> <li>Perform Advanced Data Analysis and Visualization</li> </ul> <h3>10 - PRESENTING INSIGHTS WITH REPORTS (OPTIONAL)</h3> <ul> <li>Plan a Report</li> <li>Create a Report</li> </ul></div>

Microsoft Power BI

Data Analysis

Data Skills

Data Analyst

Data Analysis and Visualization with Microsoft Excel

Course Gate

Data Management

Enhance your Excel skills with our comprehensive course covering 50 essential tips and techniques. Perfect for beginners and professionals alike, this course offers CPD accreditation and practical insights to boost your career prospects.

MS Excel: 50 Tips to Upgrade your Excel Skills

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

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

<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>

Microsoft Power Automate

Excel - Automating Excel with Macros and Analysis Tools



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


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


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


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


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


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


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


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


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


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


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


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


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

Property Investment

Financial Analysis

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

Real Estate Investment School (Investment Cash Flow Modelling)

<h2 id="isPasted" fr-original-style="" style="box-sizing: border-box;"> </h2>This advanced financial modelling course will benefit Real Estate Professionals looking to develop their financial modelling skills to the next level. This course is intended to the most ambitious modellers in the property industry who would like to be fully proficient in building complex real estate models. On this course you will...<ul fr-original-style="" style="box-sizing: border-box;"><li value="1" fr-original-style="" style="box-sizing: border-box;">Understand how the application and use of Structured Finance products in Real Estate</li><li value="2" fr-original-style="" style="box-sizing: border-box;">Learn how to introduce several tranches of debt in a development project</li><li value="3" fr-original-style="" style="box-sizing: border-box;">Understand how to model different parties to a project</li><li value="4" fr-original-style="" style="box-sizing: border-box;">Create Joint Venture structures between Developers, Lenders and Equity Partners</li><li value="5" fr-original-style="" style="box-sizing: border-box;">Learn advanced modelling techniques to analyse underlying asset risk</li><li value="6" fr-original-style="" style="box-sizing: border-box;">Understand how underlying asset risk impacts return to all parties to a project</li></ul> 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 professionals from a mid to senior level with exposure to Real Estate financial models</li><li value="2" fr-original-style="" style="box-sizing: border-box;">Mid-level to senior Real Estate Analysts who would like to advance their financial modelling skills in areas such as development, portfolio analysis, and risk analysis</li><li value="3" fr-original-style="" style="box-sizing: border-box;">Real Estate Investors who would like to expand their knowledge and understanding of Real Estate cash flow models to an advanced level</li></ul> Course Outline:<ul fr-original-style="" style="box-sizing: border-box;"><li value="1" fr-original-style="" style="box-sizing: border-box;">Mezzanine debt modelling</li><li value="2" fr-original-style="" style="box-sizing: border-box;">Joint Venture structures between developers and lender/equity partners</li><li value="3" fr-original-style="" style="box-sizing: border-box;">Promote and profit share structure calculations</li><li value="4" fr-original-style="" style="box-sizing: border-box;">Advanced project cash flows with mezzanine debts</li><li value="5" fr-original-style="" style="box-sizing: border-box;">Key Real Estate and investment risks, risk adjustment of exit yields</li><li value="6" fr-original-style="" style="box-sizing: border-box;">Sensitivity and Scenario Analysis</li><li value="7" fr-original-style="" style="box-sizing: border-box;">Monte Carlo Analysis</li></ul> 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 Modelling Masterclass 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>



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


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


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


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


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


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

Real Estate Finance

Investment Management

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

Real Estate Modelling Masterclass (Advanced Cash Flow Modelling)

<div id="course-pills-1">Duration1 Days6 CPD hoursThis course is intended forTo ensure success, students will need to be familiar with using personal computers and should have experience using a keyboard and mouse. Students should also be comfortable working in the Windows environment and be able to manage information on their computers.OverviewUpon successful completion of this course, you will be able to create and develop Excel worksheets and workbooks in order to work with and analyse the data that is critical to the success of your organisation.This course is intended for those who wish to gain the foundational understanding of Excel that is necessary to create and work with electronic spreadsheets. Excel can help you organise, calculate, analyse, revise, update, and present your data.</div><div id="course-pills-2"><h4>Getting Started with Excel</h4><ul><li>Navigate the Excel User Interface</li><li>Use Excel Commands</li><li>Create and Save a Basic Workbook</li><li>Enter and Edit Cell Data</li><li>Fill Cells with Series of Data (AutoFill and Flash Fill)</li><li>Use Excel Help</li></ul><h4>Performing Calculations</h4><ul><li>Create Worksheet Formulas</li><li>Insert Functions and use Autocomplete</li><li>Reuse Formulas and Functions</li><li>Create an Absolute Reference</li></ul><h4>Modifying a Worksheet</h4><ul><li>Insert, Delete, and Adjust Cells, Columns, and Rows</li><li>Move and Copy Data between Cells</li><li>Search for and Replace Data</li><li>Use Spellcheck and Proofing</li></ul><h4>Formatting a Worksheet</h4><ul><li>Apply Text Formats</li><li>Apply Number Formats</li><li>Align Cell Contents</li><li>Apply and Copy Cell Styles</li><li>Apply Basic Conditional Formatting</li></ul><h4>Printing Workbooks</h4><ul><li>Preview and Print a Workbook</li><li>Controlling Page Layout</li><li>Adding Headers and Footers</li><li>Set Print Titles and Print Ranges</li></ul><h4>Managing Workbooks</h4><ul><li>Manage Worksheets</li><li>Insert and Delete Worksheets</li><li>Manage Workbook and Worksheet Views</li><li>Manage Workbook Properties</li></ul></div>

11480 Courses

Excel Spreadsheet Training

By The Teachers Training

Programming and Data Wrangling with VBA and Excel

By Nexus Human

Excel Pro Tips: 75+ Tips to go from Excel Beginner to Pro [v]

By Packt

Excel 365 Beginner

By iStudy UK

Mastering MS Excel

By Janets

Excel 2007 Simplified

By iStudy UK

Microsoft Excel

By LearnDrive UK

Excel: Top 50 Microsoft Excel Formulas in 50 Minutes!

By Skill Up

Data Analysis and Visualization with Microsoft Excel

By Nexus Human

MS Excel: 50 Tips to Upgrade your Excel Skills

By Course Gate

Search By Location