<div id="course-pills-1">Duration<p>1 Days</p><p>6 CPD hours</p>This course is intended for<p>This course is intended for persons in a variety of job roles such as publishing specialists, layout specialists, graphic designers, or any other knowledge workers who need to use Microsoft Office Publisher to create, lay out, edit, and share publications.</p>Overview<p>In this course, you will create, format, edit, and share publications. You will:<br />Perform basic tasks in the Microsoft Publisher interface.<br />Add content to a publication.<br />Format text and paragraphs in a publication.<br />Manage text in a publication.<br />Work with graphics in a publication.<br />Prepare a publication for printing and sharing.</p><p>MicrosoftÂ© Publisher for Office 365? is a desktop publishing softwareapplication capable of producing greeting cards, certificates, newsletters, and otherprinted publications. Publisher includes a large collection of templates that provideagreat way to start a new publication. Publisher offers a large selection of 'buildingblocks' that can be dragged into your documents, helping you to create page elementssuch as calendars, newsletter sidebars, and borders. Publisher integrates online sharingand mail merge features, which are handy when you need to send publications to a listofcustomers, and it's possible to export publications as HTML web pages or PDF documents.With a user-friendly interface, Publisher makes it easy to create and editpublications. This course presents information and skills that are appropriate for users of theOffice2019/2021 or Office 365 desktop applications. However, the instructional environmentforthe delivery of this course utilizes Office 365.</p></div><div id="course-pills-2"><h4>Getting Started with Microsoft Publisher</h4><ul><li>Topic A: Navigate the Interface</li><li>Topic B: Customize the Publisher Interface</li><li>Topic C: Create a Publication</li></ul><h4>Adding Content to a Publication</h4><ul><li>Topic A: Add Text to a Publication</li><li>Topic B: Add Pages and Picture Placeholders to a Publication</li><li>Topic C: Control the Display of Content in Text Boxes</li><li>Topic D: Apply Building Blocks to a Publication</li></ul><h4>Formatting Text and Paragraphs in a Publication</h4><ul><li>Topic A: Format Text</li><li>Topic B: Format Paragraphs</li><li>Topic C: Apply Schemes</li></ul><h4>Managing Text in a Publication</h4><ul><li>Topic A: Edit Text in a Publication</li><li>Topic B: Work with Tables</li><li>Topic C: Insert Symbols and Special Characters</li></ul><h4>Working with Graphics in a Publication</h4><ul><li>Topic A: Insert Graphics in a Publication</li><li>Topic B: Customize the Appearance of Pictures</li></ul><h4>Preparing a Publication for Sharing and Printing</h4><ul><li>Topic A: Check the Design of a Publication</li><li>Topic B: Save a Publication in Different Formats</li><li>Topic C: Print a Publication</li><li>Topic D: Share a Publication</li></ul></div>

Nexus Human

Office Skills & Productivity

Microsoft Publisher

Publishing

Office Productivity

Microsoft Office

Microsoft Word

Microsoft Publisher for Office 365/2021

<div>
						<div>
				<div>
									<section>
						<div>
							<div>
					<div>
			<div>
							<div>
						<div>
				<div>
								<div>
				<p>Content Management System is now the most popular computer software that is used to create and modify digital contents. This course has been illustrated to educate you on how it functions. It discusses the fundamental aspects of CMS. Hit the course to enter into the digital world.</p><p>Start learning <span>Content Management System Training</span> that will give you enough knowledge and skills to build your dream career.</p><h3><strong>About this course</strong></h3><p>This <span>Content Management System Training</span> helps to grow your skills faster through the power of relevant content and world-class tutors. In this industry-leading bite-sized course, you will learn up-to-date knowledge in the relevant field within a few hours and get certified immediately.</p><p>The modules of this course are very easy to understand and all of the topics are split into different sections. You will easily grasp and use the knowledge gained from this course in your career and go one step ahead of your competitors.</p><p>The course is designed to improve your employability and provide you with the tools you need to succeed. Enrol today and start learning your essential skills.</p><h3><strong>Why choose this course</strong></h3><ul><li>Earn a digital Certificate upon successful completion.</li><li>Accessible, informative modules taught by expert instructors</li><li>Study in your own time, at your own pace, through your computer tablet or mobile device</li><li>Get 24/7 help or advice from our email and live chat teams</li><li>Get full tutor support on weekdays (Monday to Friday)</li></ul>					</div>
						</div>
				</div>
						</div>
					</div>
		</div>
								</div>
					</div>
		</section>
				<section>
						<div>
							<div>
					<div>
			<div>
							<div>
						<div>
				<div>
					<div>
							
					<div></div>
											<div></div>
														
							
					<div></div>
											<div></div>
														
							
					<div></div>
											<div></div>
														
							
					<div></div>
											<div></div>
														
					</div>
			</div>
				</div>
						</div>
					</div>
		</div>
								</div>
					</div>
		</section>
				<section>
						<div>
							<div>
					<div>
			<div>
							<div>
						<div>
				<div>
			<h2>Course Design</h2>		</div>
				</div>
				<div>
				<div>
								<div>
				<div id="course-home"><div><p>The <span>Content Management System Training</span> 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.</p><p>You are taught through a combination of</p><ul><li>Video lessons</li><li>Online study materials</li></ul></div></div>					</div>
						</div>
				</div>
						</div>
					</div>
		</div>
								</div>
					</div>
		</section>
				<section>
						<div>
							<div>
					<div>
			<div>
							<div>
						<div>
				<div>
			<h2>Who Is This Course For:â</h2>		</div>
				</div>
				<div>
				<div>
								<div>
				<p>This <span>Content Management System Training</span> is ideal for those who want to be skilled in this field or who wish to learn a new skill to build their dream career. If you want to gain extensive knowledge, potential experience, and be an expert in the related field then this is a great course for you to grow your career.</p>					</div>
						</div>
				</div>
				<div>
				<div>
			<h2>Requirements</h2>		</div>
				</div>
				<div>
				<div>
								<div>
				<ul><li>This course is for anyone who would like to learn <span>Content Management System Training</span> related skills to aid his/her career path.</li><li>No formal entry prerequisites are required</li></ul>					</div>
						</div>
				</div>
						</div>
					</div>
		</div>
								</div>
					</div>
		</section>
				<section>
						<div>
							<div>
					<div>
			<div>
							<div>
						<div>
				<div>
			<h2>Certification</h2>		</div>
				</div>
				<div>
				<div>
								<div>
				<p>Upon 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 £9.99 and PDF Certificate at £4.99.</p>					</div>
						</div>
				</div>
						</div>
					</div>
		</div>
								</div>
					</div>
		</section>
				<section>
						<div>
							<div>
					<div>
			<div>
							<div>
						<div>
				<div>
			<h2>Course Content</h2>		</div>
				</div>
				<div>
				<div>
								<div>
				<ul><li>Module 1: Content Management Basics</li><li>Module 2: Introduction to  Content Management System (CMS)</li><li>Module 3: Fundamentals of Content Management System </li></ul>					</div>
						</div>
				</div>
						</div>
					</div>
		</div>
								</div>
					</div>
		</section>
									</div>
			</div>
					</div><div>
				<h3>Course Content</h3>

<div id="course_curriculum">
<table width="100%">				<tbody><tr>
					<td colspan="4">Content Management Basics</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Module 1: Content Management Basics</td>
					<td> </td>
					<td><span><i></i> 00:18:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Module 2: Introduction to  Content Management System (CMS)</td>
					<td> </td>
					<td><span><i></i> 00:09:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Module 3: Fundamentals of Content Management System</td>
					<td> </td>
					<td><span><i></i> 00:17:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Order your Certificates &amp; Transcripts</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Order your Certificates &amp; Transcripts</td>
					<td> </td>
					<td><span><i></i> 00:00:00</span></td>
				</tr>
				</tbody></table></div>

			</div>
			<h2>Frequently Asked Questions</h2>
                        <div>
                            <div>
                                <span>
                                    Are there any prerequisites for taking the course?
                                </span>
                                <div>
                                    <span></span>
                                </div>
                            </div>
                            <div>
                                <div>
                                    <p>
                                        There are no specific prerequisites for this course, nor
                                        are there any formal entry requirements. All you need is
                                        an internet connection, a good understanding of English
                                        and a passion for learning for this course.
                                    </p>
                                </div>
                            </div>
                        </div>
                        
                        <div>
                            <div>
                                <span>
                                    Can I access the course at any time, or is there a set
                                    schedule?
                                </span>
                                <div>
                                    <span></span>
                                </div>
                            </div>
                            <div>
                                <div>
                                    <p>
                                        You have the flexibility to access the course at any time
                                        that suits your schedule. Our courses are self-paced,
                                        allowing you to study at your own pace and convenience.
                                    </p>
                                </div>
                            </div>
                        </div>
                        
                        <div>
                            <div>
                                <span>
                                    How long will I have access to the course?
                                </span>
                                <div>
                                    <span></span>
                                </div>
                            </div>
                            <div>
                                <div>
                                    <p>
                                        For this course, you will have access to the course
                                        materials for 1 year only. This means you can review the
                                        content as often as you like within the year, even after
                                        you've completed the course. However, if you buy Lifetime
                                        Access for the course, you will be able to access the
                                        course for a lifetime.
                                    </p>
                                </div>
                            </div>
                        </div>
                        
                        <div>
                            <div>
                                <span>
                                    Is there a certificate of completion provided after
                                    completing the course?
                                </span>
                                <div>
                                    <span></span>
                                </div>
                            </div>
                            <div>
                                <div>
                                    <p>
                                        Yes, upon successfully completing the course, you will
                                        receive a certificate of completion. This certificate can
                                        be a valuable addition to your professional portfolio and
                                        can be shared on your various social networks.
                                    </p>
                                </div>
                            </div>
                        </div>
                        
                        <div>
                            <div>
                                <span>
                                    Can I switch courses or get a refund if I'm not satisfied
                                    with the course?
                                </span>
                                <div>
                                    <span></span>
                                </div>
                            </div>
                            <div>
                                <div>
                                    <p>
                                        We want you to have a positive learning experience. If
                                        you're not satisfied with the course, you can request a
                                        course transfer or refund within 14 days of the initial
                                        purchase.
                                    </p>
                                </div>
                            </div>
                        </div>
                        
                        <div>
                            <div>
                                <span>
                                    How do I track my progress in the course?
                                </span>
                                <div>
                                    <span></span>
                                </div>
                            </div>
                            <div>
                                <div>
                                    <p>
                                        Our platform provides tracking tools and progress
                                        indicators for each course. You can monitor your progress,
                                        completed lessons, and assessments through your learner
                                        dashboard for the course.
                                    </p>
                                </div>
                            </div>
                        </div>
                        
                        <div>
                            <div>
                                <span>
                                    What if I have technical issues or difficulties with the
                                    course?
                                </span>
                                <div>
                                    <span></span>
                                </div>
                            </div>
                            <div>
                                <div>
                                    <p>
                                        If you encounter technical issues or content-related
                                        difficulties with the course, our support team is
                                        available to assist you. You can reach out to them for
                                        prompt resolution.
                                    </p>
                                </div>
                            </div>
                        </div>

Janets

Content Management System (CMS)

Online Course Marketing

Online Course Creation

Certificate in Information Security Management Principles (CISMP)

Commercial & Contract Management Certification Program (CCM)

Trainers Course

Content Management System Training

General Admission

<div id="course-pills-1">Duration<p>1 Days</p><p>6 CPD hours</p>This course is intended for<p>This course is intended for students who want to use more advanced functionalities in Word, including image manipulation, collaboration and revision tracking, cross-referencing and linking, document security, forms, and process automation through macros.</p>Overview<p>In this course, you will learn to use the advanced capabilities of Word 2021.<br />You will:<br />Use images in a document.<br />Create custom graphic elements.<br />Collaborate on documents.<br />Add reference marks and notes.<br />Secure a document.<br />Create and manipulate forms.<br />Create macros to automate tasks.</p><p>MicrosoftÂ© Word enables you to do far more than simple word processing. Word includes advanced image manipulation tools, collaboration features, cross-referencing and linking tools, entry forms and data collection, security features, and tools to automate document production.<br />This course covers Microsoft Office Specialist Program exam objectives to help you prepare for the Word Associate (Office 365 and Office 2021): Exam MO-100 and Word Expert (Office 365 and Office 2021): Exam MO-101 certifications.<br /></p></div><div id="course-pills-2"><h4>Manipulating Images</h4><ul><li>Topic A: Integrate Pictures and Text</li><li>Topic B: Adjust Image Appearance</li><li>Topic C: Insert Other Media Elements</li></ul><h4>Using Custom Graphic Elements</h4><ul><li>Topic A: Create Text Boxes and Pull Quotes</li><li>Topic B: Add WordArt and Other Text Effects</li><li>Topic C: Draw Shapes</li><li>Topic D: Create Complex Illustrations with SmartArt</li></ul><h4>Collaborating on Documents</h4><ul><li>Topic A: Prepare a Document for Collaboration</li><li>Topic B: Mark Up a Document</li><li>Topic C: Review Markups</li><li>Topic D: Merge Changes from Other Documents</li></ul><h4>Adding Document References and Links</h4><ul><li>Topic A: Add Captions</li><li>Topic B: Add Cross-References</li><li>Topic C: Add Bookmarks</li><li>Topic D: Add Hyperlinks</li><li>Topic E: Insert Footnotes and Endnotes</li><li>Topic F: Add Citations and a Bibliography</li></ul><h4>Securing a Document</h4><ul><li>Topic A: Suppress Information</li><li>Topic B: Set Formatting and Editing Restrictions</li><li>Topic C: Restrict Document Access</li><li>Topic D: Add a Digital Signature to a Document</li></ul><h4>Using Forms to Manage Content</h4><ul><li>Topic A: Create Forms</li><li>Topic B: Modify Forms</li></ul><h4>Automating Repetitive Tasks with Macros</h4><ul><li>Topic A: Automate Tasks by Using Macros</li><li>Topic B: Create a Macro</li></ul></div>

Microsoft 365

Office Skills

Microsoft Office Word 2021: Part 3

<div id="course-pills-1">Duration<p>1 Days</p><p>6 CPD hours</p>This course is intended for<p>This course is intended for those with a basic understanding of Microsoft Windows and who need to learn foundational Word skills, such as creating, editing, and formatting documents; inserting simple tables and creating lists; and employing a variety of techniques for improving the appearance and accuracy of document content.</p>Overview<p>In this course, you will learn fundamental Word skills. You will:<br />Navigate and perform common tasks in Word, such as opening, viewing, editing, saving, and printing documents, and configuring the application.<br />Format text and paragraphs.<br />Perform repetitive operations efficiently using tools such as Find and Replace, Format Painter, and Styles.<br />Enhance lists by sorting, renumbering, and customizing list styles.<br />Create and format tables.<br />Insert graphic objects into a document, including symbols, special characters, illustrations, pictures, and clip art.<br />Format the overall appearance of a page through page borders and colors, watermarks, headers and footers, and page layout.<br />Use Word features to help identify and correct problems with spelling, grammar, readability, and accessibility.</p><p>These days, most people take electronic word processing for granted. While we may still write out our grocery lists with pen and paper, we expect to use a computer to create the majority of our documents. It's impossible to avoid word-processing software in many areas of the business world. Managers, lawyers, clerks, reporters, and editors rely on this software to do their jobs. Whether you are an executive secretary or a website designer, you'll need to know the ins and outs of electronic word processing.MicrosoftÂ© Word is designed to help you move smoothly through the task of creating professional-looking documents. Its rich features and powerful tools can make your work easy, and even fun. In this course, you'll learn how to use Word on the desktop to create and edit simple documents; format documents; add tables and lists; add design elements andlayout options; and proof documents.Note: Most Office users perform the majority of their daily tasks using the desktop version of the Office software, so that is the focus of this training. The course material will alsoenable you to access and effectively utilize many web-based resources provided with your Microsoft 365 subscription. This includes brief coverage of key skills for using Word for theWeb and OneDrive. Helpful notes throughout the material alert you to cases where the online version of the application may function differently from the primary, desktop version.This course may be a useful component in your preparation for the Microsoft Word (Microsoft 365 Apps and Office 2019): Exam MO-100 and Microsoft Word Expert (Microsoft 365 Apps and Office 2019): Exam MO-101 certification exams.</p></div><div id="course-pills-2"><h4>Lesson 1: Getting Started with Word</h4><ul><li>Topic A: Navigate in Microsoft Word</li><li>Topic B: Create and Save Word Documents</li><li>Topic C: Edit Documents</li><li>Topic D: Work with Word for the Web</li></ul><h4>Lesson 2: Formatting Text and Paragraphs</h4><ul><li>Topic A: Apply Character Formatting</li><li>Topic B: Control Paragraph Layout</li><li>Topic C: Align Text Using Tabs</li><li>Topic D: Display Text in Bulleted or Numbered Lists</li><li>Topic E: Apply Borders and Shading</li></ul><h4>Lesson 3: Working More Efficiently</h4><ul><li>Topic A: Make Repetitive Edits</li><li>Topic B: Apply Repetitive Formatting</li><li>Topic C: Use Styles to Streamline Repetitive Formatting Tasks</li><li>Topic D: Customize the Word Environment</li></ul><h4>Lesson 4: Managing Lists</h4><ul><li>Topic A: Sort a List</li><li>Topic B: Format a List</li></ul><h4>Lesson 5: Adding Tables</h4><ul><li>Topic A: Insert a Table</li><li>Topic B: Modify a Table</li><li>Topic C: Format a Table</li><li>Topic D: Convert Text to a Table</li></ul><h4>Lesson 6: Inserting Graphic Objects</h4><ul><li>Topic A: Insert Symbols and Special Characters</li><li>Topic B: Add Images to a Document</li></ul><h4>Lesson 7: Controlling Page Appearance</h4><ul><li>Topic A: Apply a Page Border and Color</li><li>Topic B: Add Headers and Footers</li><li>Topic C: Control Page Layout</li><li>Topic D: Add a Waterm</li></ul><h4>Lesson 8: Preparing to Publish a Document</h4><ul><li>Topic A: Check Spelling, Grammar, and Readability</li><li>Topic B: Preview and Print Documents</li><li>Topic C: Use Research Tools</li><li>Topic D: Check Accessibility</li><li>Topic E: Dictate Text in a Document</li><li>Topic F: Save a Document to Other Form</li></ul></div><div id="course-pills-3"><h4>Additional course details:</h4><br /><p>Nexus Humans Microsoft Word for Office 365 (Desktop or Online) (v1.1) Part 1 training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. </p><p></p> This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. <p></p>Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success.  <p></p>While we feel this is the best course for the Microsoft Word for Office 365 (Desktop or Online) (v1.1) Part 1 course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you.  <p></p>Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.<p></p></div>

Microsoft Word for Office 365 (Desktop or Online) (v1.1) Part 1

<div id="course-pills-1">Duration<p>1 Days</p><p>6 CPD hours</p>This course is intended for<p>This course is intended for students who want to learn basic Word 2021 skills, such as creating, editing, and formatting documents; inserting simple tables and creating lists; and employing a variety of techniques for improving the appearance and accuracy of document content.</p>Overview<p>In this course, you will learn fundamental Word skills.<br />You will:<br />Navigate and perform common tasks in Word, such as opening, viewing, editing, saving, and printing documents, and configuring the application.<br />Format text and paragraphs.<br />Perform repetitive operations efficiently using tools such as Find and Replace, Format Painter, and Styles.<br />Enhance lists by sorting, renumbering, and customizing list styles.<br />Create and format tables.<br />Insert graphic objects into a document, including symbols, special characters, illustrations, pictures, and clip art.<br />Format the overall appearance of a page through page borders and colors, watermarks, headers and footers, and page layout.<br />Use Word features to help identify and correct problems with spelling, grammar, readability, and accessibility.</p><p>These days, most people take electronic word processing for granted. While we may still write out our grocery lists with pen and paper, we expect to use a computer to create the majority of our documents. It's impossible to avoid word-processing software in many areas of the business world. Managers, lawyers, clerks, reporters, and editors rely on this software to do their jobs. Whether you are an executive secretary or a website designer, you'll need to know the ins and outs of electronic word processing. MicrosoftÂ© Word 2021 is designed to help you move smoothly through the task of creating professional-looking documents. Its rich features and powerful tools can make your work easy, and even fun. In this course, you'll learn how to use Word 2021 to create and edit simple documents; format documents; add tables and lists; add design elements and layout options; and proof documents. This course covers Microsoft Office Specialist Program exam objectives to help you prepare for the Word Associate (Office 365 and Office 2021): Exam MO-100 and Word Expert (Office 365 and Office 2021): Exam MO-101 certifications.<br /></p></div><div id="course-pills-2"><h4>Getting Started with Word 2021</h4><ul><li>Topic A: Navigate in Microsoft Word</li><li>Topic B: Create and Save Word Documents</li><li>Topic C: Manage Your Workspace</li><li>Topic D: Edit Documents</li><li>Topic E: Preview and Print Documents</li><li>Topic F: Customize the Word Environment</li></ul><h4>Formatting Text and Paragraphs</h4><ul><li>Topic A: Apply Character Formatting</li><li>Topic B: Control Paragraph Layout</li><li>Topic C: Align Text Using Tabs</li><li>Topic D: Display Text in Bulleted or Numbered Lists</li><li>Topic E: Apply Borders and Shading</li></ul><h4>Working More Efficiently</h4><ul><li>Topic A: Make Repetitive Edits</li><li>Topic B: Apply Repetitive Formatting</li><li>Topic C: Use Styles to Streamline Repetitive Formatting Tasks</li></ul><h4>Managing Lists</h4><ul><li>Topic A: Sort a List</li><li>Topic B: Format a List</li></ul><h4>Adding Tables</h4><ul><li>Topic A: Insert a Table</li><li>Topic B: Modify a Table</li><li>Topic C: Format a Table</li><li>Topic D: Convert Text to a Table</li></ul><h4>Inserting Graphic Objects</h4><ul><li>Topic A: Insert Symbols and Special Characters</li><li>Topic B: Add Images to a Document</li></ul><h4>Controlling Page Appearance</h4><ul><li>Topic A: Apply a Page Border and Color</li><li>Topic B: Add Headers and Footers</li><li>Topic C: Control Page Layout</li><li>Topic D: Add a Watermark</li></ul><h4>Preparing to Publish a Document</h4><ul><li>Topic A: Check Spelling, Grammar, and Readability</li><li>Topic B: Use Research Tools</li><li>Topic C: Check Accessibility</li><li>Topic D: Save a Document to Other Formats</li></ul></div>

Microsoft Office Word 2021: Part 1

<div>
					<div>
								<section>
						<div>
							<div>
					<div>
			<div>
							<div>
						<div>
				<div>
					</div>
				</div>
						</div>
					</div>
		</div>
								</div>
					</div>
		</section>
							</div>
				</div>
			<p>Are you someone who wants to utilise the database and how it can be effectively used for your business? Do you have the plans to make your database but you are struggling since don't have the right skills to start it?  Worry no more! This course is designed to help you in this dilemma.</p>
<p><span>Have you ever heard about the database? Or have you heard about it and want to use it on your own?  Then this course will be able to help you in that. There are a lot of people who do not like to deal with database, scripts and all the technical parts, this hinders them to start learning because they already have the mindset that it is difficult. Database creation might be difficult, but with the correct attitude and practical database skills, you will surely avoid the difficulties! You have to keep in mind that the end goal should guarantee the creation of the database and to be able to make more whenever you need it. </span><span>In this course, you will first know how to create your database and database users. You will then master how to import database tables since most new scripts come with a built-in installer, the scripts create all database, but when the time comes that there is no installer provided, then you have to create one manually.</span></p>
<h3><strong>Course Highlights</strong></h3>
<p><strong>Database for Beginners</strong> is an award-winning and the best selling <strong></strong> course that has been given the CPD Certification &amp; IAO accreditation. It is the most suitable course anyone looking to work in this or relevant sector.</p>
<p>It is considered one of the perfect courses in the UK that can help students/learners to get familiar with the topic and gain necessary skills to perform well in this field. We have packed <strong>Database for Beginners</strong> into <strong>9</strong> modules for teaching you everything you need to become successful in this profession.</p>
<p>To provide you ease of access, this course is designed for both part-time and full-time students. You can become accredited in just <strong>8 hours, 40 minutes</strong> hours and it is also possible to study at your own pace.</p>
<p>We have experienced tutors who will help you throughout the comprehensive syllabus of this course and answer all your queries through email.</p>
<p>For further clarification, you will be able to recognize your qualification by checking the validity from our dedicated website.</p>
<h3><strong>Why You Should Choose Database for Beginners</strong></h3>
<ul>
<li>Lifetime access to the course</li>
<li>No hidden fees or exam charges</li>
<li>CPD Accredited certification on successful completion</li>
<li>Full Tutor support on weekdays (Monday - Friday)</li>
<li>Efficient exam system, assessment, and instant results</li>
<li>Download Printable PDF certificate immediately after completion</li>
<li>Obtain the original print copy of your certificate, dispatch the next working day for as little as £9.</li>
<li>Improve your chance of gaining professional skills and better earning potential.</li>
</ul>
<h3><strong>Who is this Course for?</strong></h3>
<p><strong>Database for Beginners </strong>is CPD certified and IAO accredited. This makes it perfect for anyone trying to learn potential professional skills.</p>
<p>As there is no experience and qualification required for this course, it is available for all students from any academic backgrounds.</p>
<h3><strong>Requirements</strong></h3>
<p>Our<strong> Database for Beginners</strong> is fully compatible with any kind of device. Whether you are using Windows computer, Mac, smartphones or tablets, you will get the same experience while learning. Besides that, you will be able to access the course with any kind of internet connection from anywhere at any time without any kind of limitation.</p>
<h3><strong>Career Path</strong></h3>
<p>You will be ready to enter the relevant job market after completing this course. You will be able to gain necessary knowledge and skills required to succeed in this sector. All our Diplomas' are CPD and IAO accredited so you will be able to stand out in the crowd by adding our qualifications to your CV and Resume.</p><table>				<tbody><tr>
					<td colspan="4">Database Basics</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>What is a Database</td>
					<td><span>FREE</span> </td>
					<td><span><i></i> 01:00:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Definition of Terms</td>
					<td><span>FREE</span> </td>
					<td><span><i></i> 01:00:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Database Users and Languages</td>
					<td> </td>
					<td><span><i></i> 01:00:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Components of a Database System</td>
					<td> </td>
					<td><span><i></i> 01:00:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Basic Set Concepts</td>
					<td> </td>
					<td><span><i></i> 01:00:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Relations as a Database</td>
					<td> </td>
					<td><span><i></i> 01:00:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Relational Database Operators</td>
					<td> </td>
					<td><span><i></i> 01:00:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Database keys</td>
					<td> </td>
					<td><span><i></i> 01:00:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Additional Supporting Material</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Database_Basics</td>
					<td> </td>
					<td><span><i></i> 00:00:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Mock Exam</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Mock Exam- Database for Beginners</td>
					<td> </td>
					<td><span><i></i> 00:20:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Final Exam</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Final Exam- Database for Beginners</td>
					<td> </td>
					<td><span><i></i> 00:20:00</span></td>
				</tr>
				</tbody></table>

iStudy UK

Database Programming

AWS Certified Database

Database

Database Administration

Database Management

Database for Beginners

<div id="course-pills-1">Duration<p>1 Days</p><p>6 CPD hours</p>This course is intended for<p>This course is designed for students who wish to use Microsoft Word to create and modify complex documents and use tools that allow them to customize those documents.</p>Overview<p>In this course, you will learn to create and modify complex documents and use tools that allow you to customize those documents.<br />You will:<br />Organize content using tables and charts.<br />Customize formats using styles and themes.<br />Insert content using Quick Parts.<br />Use templates to automate document formatting.<br />Control the flow of a document.<br />Simplify and manage long documents.<br />Use mail merge to create letters, envelopes, and labels.</p><p>After you master the basics of creating, editing, and printing MicrosoftÂ© Word documents, you're ready to move on to tackling the more advanced features. In this course, you will work with features such as formats, styles, and templates to create professional documents with a consistent look and feel. You will add visual interest to your documents by using the tables and charts features. Quick Parts and templates provide efficiency and consistency when adding content, and long complex documents can be simplified and managed in Master Documents. Finally, you will use the mail merge feature to automate sending individual letters to customers. Creating professional-looking documents can give you and your organization a competitive edge. Implementing time-saving features such as document templates and automated mailings can help reduce expenses. Mastering these techniques will make you a valued employee in your organization. This course covers Microsoft Office Specialist Program exam objectives to help you prepare for the Word Associate (Office 365 and Office 2021): Exam MO-100 and Word Expert (Office 365 and Office 2021): Exam MO-101 certifications.<br /></p></div><div id="course-pills-2"><h4>Organizing Content Using Tables and Charts</h4><ul><li>Topic A: Sort Table Data</li><li>Topic B: Control Cell Layout</li><li>Topic C: Perform Calculations in a Table</li><li>Topic D: Create a Chart</li><li>Topic E: Add an Excel Table to a Word Document (Optional)</li></ul><h4>Customizing Formats Using Styles and Themes</h4><ul><li>Topic A: Create and Modify Text Styles</li><li>Topic B: Create Custom List or Table Styles</li><li>Topic C: Apply Document Themes</li></ul><h4>Inserting Content Using Quick Parts</h4><ul><li>Topic A: Insert Building Blocks</li><li>Topic B: Create and Modify Building Blocks</li><li>Topic C: Insert Fields Using Quick Parts</li></ul><h4>Using Templates to Automate Document Formatting</h4><ul><li>Topic A: Create a Document Using a Template</li><li>Topic B: Create and Modify a Template</li><li>Topic C: Manage Templates with the Template Organizer</li></ul><h4>Controlling the Flow of a Document</h4><ul><li>Topic A: Control Paragraph Flow</li><li>Topic B: Insert Section Breaks</li><li>Topic C: Insert Columns</li><li>Topic D: Link Text Boxes to Control Text Flow</li></ul><h4>Simplifying and Managing Long Documents</h4><ul><li>Topic A: Insert Blank and Cover Pages</li><li>Topic B: Insert an Index</li><li>Topic C: Insert a Table of Contents</li><li>Topic D: Insert an Ancillary Table</li><li>Topic E: Manage Outlines</li><li>Topic F: Create a Master Document</li></ul><h4>Using Mail Merge to Create Letters, Envelopes, and Labels</h4><ul><li>Topic A: Use Mail Merge</li><li>Topic B: Merge Envelopes and Labels</li></ul></div><div id="course-pills-3"><h4>Additional course details:</h4><br /><p>Nexus Humans Microsoft Office Word 2021: Part 2 training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. </p><p></p> This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. <p></p>Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success.  <p></p>While we feel this is the best course for the Microsoft Office Word 2021: Part 2 course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you.  <p></p>Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.<p></p></div>

Microsoft AZ-700

Microsoft Office Word 2021: Part 2

<p>This Microsoft Office Skills course is designed for people with a career in Accounting, Finance, Marketing, Sales, Executive, Administration, Business Management, Manager, Human Resource, Customer Service, Assistant, and Reception. In this course, we will go in-depth into four Microsoft Office applications: Excel, Word, PowerPoint and Access.</p><p>The first application is Excel. In Excel, you will be introduced to the new features of Excel 2019 like CONCAT, Funnel Chart, IFS and many more. Along with that, you will learn Excel commands, performing calculations, modifying worksheets, formatting worksheets, printing workbooks and managing workbooks. Next, we will move on to Word, where we will ensure you learn the new features of the 2019 edition, editing, previewing and printing documents, formatting text and paragraphs, managing lists, adding tables, inserting graphic objects, controlling page appearance, publishing documents and working more efficiently.</p><p>PowerPoint will be our third application. Here, you will also be aware of the 2019 edition of PowerPoint, PowerPoint Interface, presentation basics, formatting and inserting options, working with objects, tables, charts and presentation. Finally, we will move on to Access. Here, you will get an introduction to Access, modifying data, working with queries, access forms and grasp the new Access 2019 features.</p><ul><li><strong>Course 01: </strong>Microsoft Word</li><li><strong>Course 02: </strong>Microsoft Excel</li><li><strong>Course 03: </strong>PowerPoint</li><li><strong>Course 04: </strong>Outlook</li></ul><p><strong>Learning Outcomes</strong></p><p>By the end of the course, learners will be able to:</p><ul><li>Get a thorough introduction to the new features of the 2019 edition of Excel, Word, PowerPoint and Access</li><li>Learn how to perform calculations through functions and formulas in Excel</li><li>Get familiar with how to add tables and insert graphic objects in Word</li><li>Learn how to make effective presentations in PowerPoint</li><li>Understand how to modify data, work with reports and queries in Access</li><li>Find out how to format a worksheet in Excel, Word and PowerPoint</li><li>Know how to preview and print in Excel and Word</li></ul><p><strong>Key Features</strong></p><ul><li>Instant e-certificate and hard copy dispatch by next working day</li><li>Fully online, interactive course with audio voiceover</li><li>Developed by qualified professionals in the field</li><li>Self-paced learning and laptop, tablet, smartphone-friendly</li><li>24/7 Learning Assistance</li><li>Discounts on bulk purchases</li></ul><p><strong>*** Additional Gifts ***</strong></p><ul><li><strong>Free Life coaching Course</strong></li></ul><p><strong>*** (Offer Ends Soon) ***</strong></p><p><strong>Course Curriculum of Microsoft Word, Excel, PowerPoint &amp; Outlook</strong></p><ul><li>Word Essentials</li><li>Powerpoint Essentials</li><li>Outlook Essentials</li><li>Excel Keyboard Shortcuts</li><li>Microsoft Excel 2019 New Features</li><li>Getting Started</li><li>Performing Calculations</li><li>Modifying a Worksheet</li><li>Formatting a Worksheet</li><li>Printing Workbooks</li><li>Managing Workbooks</li><li>Working with Functions</li><li>Working with Lists</li><li>Analyzing Data</li><li>Visualizing Data with Charts</li><li>Using PivotTables and PivotCharts</li><li>Working with Multiple Worksheets and Workbooks</li><li>Using Lookup Functions and Formula Auditing</li><li>Sharing and Protecting Workbooks</li><li>Automating Workbook Functionality</li><li>Creating Sparklines and Mapping Data</li><li>Forecasting Data</li><li>Excel Templates</li><li>Excel 2019</li><li>Excel 2019 New Features</li><li>Getting Started</li><li>Performing Calculations</li><li>Modifying a Worksheet</li><li>Formatting a Worksheet</li><li>Printing Workbooks</li><li>Managing Workbooks</li><li>Word 2019</li><li>Word 2019 New Features</li><li>Getting Started with Word</li><li>Formatting Text and Paragraphs</li><li>Working More Efficiently</li><li>Managing Lists</li><li>Adding Tables</li><li>Inserting Graphic Objects</li><li>Controlling Page Appearance</li><li>Preparing to Publish a Document</li><li>PowerPoint 2019</li><li>PowerPoint 2019 New Features</li><li>PowerPoint Interface</li><li>Presentation Basics</li><li>Formatting</li><li>Inserting Options</li><li>Working with Objects</li><li>Table</li><li>Charts</li><li>Review and Presentation</li><li>Access 2019</li><li>Access 2019 New Features</li><li>Introduction to Access</li><li>Modify Data</li><li>Working with Queries</li><li>Access Forms</li><li>Working with Reports</li></ul><p><strong>Accreditation</strong></p><p>All of our courses, including this for a Beginner course<strong>, </strong>are fully accredited, providing you with up-to-date skills and knowledge and helping you to become more competent and effective in your chosen field.</p><p><strong>Certification</strong></p><p>Once you've successfully completed your for Beginner course, you will immediately be sent a digital certificate. Also, you can have your printed certificate delivered by post (shipping cost £3.99). Our certifications have no expiry dates, although we do recommend that you renew them every 12 months.</p><h2>
        
        <div>CPD</div>
    </h2>

                        <div id="cpd">
                            <div>
                                <div>
                                    <div>
                                        30 CPD hours / points
                                    </div>
                                        <div>
                                            Accredited by CPD Quality Standards
                                        </div>
                                </div>
                            </div>
                        </div><h2>
        
        <div>Who is this course for?</div>
    </h2>

                        <div id="who_is_this_course_for">
                            <p>This Microsoft Excel 2019 is suitable for:</p><ul><li>Administrator</li><li>Accounts Administrator</li><li>HR Administrator</li><li>Accountant/Bookkeeper</li><li>Office Administrator</li><li>Warehouse Operatives</li><li>Audio Typist</li><li>Audio Secretary</li></ul>
                        </div><h2>
        
        <div>Requirements</div>
    </h2>

                        <div id="requirements">
                            <p>Learners do not require any prior qualifications to enrol on this course.</p>
                        </div><h2>
        
        <div>Career path</div>
    </h2>

                        <div id="career_path">
                            <ul><li>Client Service Support</li><li>Payroll Officer</li><li>Data Analyst</li><li>Business Analysts</li><li>Data Journalists</li></ul>
                        </div><h2>
        
        <div>Certificates</div>
    </h2>

                        <div id="optional_extras">
                                    <h4>Certificate of completion</h4>
        <p>
            Digital certificate -
            Included
        </p>
        <h4>Certificate of completion</h4>
        <p>
            Hard copy certificate -
            Included
        </p>
            <div> <p>You will get the hard copy certificates for Free! The delivery charge of the hard copy certificate inside the UK is £3.99 each.</p> </div>

                        </div>

Training Express

Microsoft Office: Excel, Word, PowerPoint & Outlook Course

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

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

<div>
<table width="100%">				<tbody><tr>
					<td colspan="4"><strong>Link Access Tables to Excel Spreadsheets</strong></td>
				</tr>
								<tr>
					<td>▶</td>
					<td>Autoforms</td><td><span>🕐 00:14:00</span></td>
				</tr>
								<tr>
					<td>▶</td>
					<td>Form Wizard</td><td><span>🕐 00:09:00</span></td>
				</tr>
								<tr>
					<td>▶</td>
					<td>Changing a form with design view</td><td><span>🕐 00:26:00</span></td>
				</tr>
								<tr>
					<td>▶</td>
					<td>Adding controls to your form</td><td><span>🕐 00:21:00</span></td>
				</tr>
								<tr>
					<td>▶</td>
					<td>Subforms</td><td><span>🕐 00:15:00</span></td>
				</tr>
								<tr>
					<td>▶</td>
					<td>Using Autoreport to create a report</td><td><span>🕐 00:03:00</span></td>
				</tr>
								<tr>
					<td>▶</td>
					<td>Using the Report Wizard to create a report</td><td><span>🕐 00:07:00</span></td>
				</tr>
								<tr>
					<td>▶</td>
					<td>Changing a report in design view</td><td><span>🕐 00:11:00</span></td>
				</tr>
								<tr>
					<td>▶</td>
					<td>Adding Calculations to your report</td><td><span>🕐 00:09:00</span></td>
				</tr>
								<tr>
					<td>▶</td>
					<td>Adding Groups, Sorts and Totals to reports</td><td><span>🕐 00:16:00</span></td>
				</tr>
								<tr>
					<td>▶</td>
					<td>Making labels with the Label Wizard</td><td><span>🕐 00:04:00</span></td>
				</tr>
								<tr>
					<td>▶</td>
					<td>Form and Report Properties</td><td><span>🕐 00:06:00</span></td>
				</tr>
								<tr>
					<td>▶</td>
					<td>Exporting a report to Excel</td><td><span>🕐 00:03:00</span></td>
				</tr>
								<tr>
					<td>▶</td>
					<td>Creating a menu with the Switchboard Manager</td><td><span>🕐 00:17:00</span></td>
				</tr>
								<tr>
					<td>▶</td>
					<td>Finalizing the Application</td><td><span>🕐 00:08:00</span></td>
				</tr>
				</tbody></table></div>

			</div>
		                        </div>

Skill Up

Computer Skills

Microsoft Excel

Microsoft Access

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

Link Access Tables to Excel Spreadsheets

<div id="course-pills-1">Duration<p>2 Days</p><p>12 CPD hours</p>This course is intended for<p>This course is intended for individuals who want to gain an indepth knowledge of formatting documents using Word.</p>Overview<p>Upon successful completion of this course, students will be able to create and modify documents by using Microsoft Office Word 2016/365/2019.</p><p>In this course, students will create, edit, and enhance technical documents using Microsoft Office Word 2016/365/2019.</p></div><div id="course-pills-2"><h4>Formatting Text and Paragraphs</h4><ul><li>Apply Character Formatting<br />Control Paragraph Layout<br />Aligh Text Using Tabs<br />Display Text in Bulleted or Numbered Lists</li></ul><h4>Working More Efficiently</h4><ul><li>Make Repetitive Edits<br />Apply Repetitive Formatting<br />Use Styles to Streamline Repetitive Formatting Tasks<br />Customize the Word Environment</li></ul><h4>Managing Lists</h4><ul><li>Sort a List<br />Format a List</li></ul><h4>Adding Tables</h4><ul><li>Insert a Table<br />Modify a Table<br />Format a Table</li></ul><h4>Inserting Graphic Objects</h4><ul><li>Insert Symbols and Special Characters<br />Add Images to a Document</li></ul><h4>Controlling Page Appearance</h4><ul><li>Add Headers and Footers<br />Control Page Layout<br />Add a Watermark</li></ul><h4>Preparing to Publish</h4><ul><li>Check Spelling, Grammar, and Readability <br />Previw and Print Documents<br />Use Research Tools</li></ul><h4>Customizing Formats Using Styles and Themes</h4><ul><li>Create and Modify Text Styles<br />Cerate Custom List or Table Styles<br />Apply Document Themes</li></ul><h4>Inserting Content Using Quick Parts</h4><ul><li>Insert Building Blocks<br />Create and Modify building Blocks<br />Insert Fields Using Quick Parts</li></ul><h4>Using Templates to Automate Document Formatting</h4><ul><li>Create a Document Using a Template<br />Create and Modify a Template<br />Manage Templates with the Template Organizer</li></ul><h4>Controlling the Flow of a Document</h4><ul><li>Control Paragrpah Flow<br />Insert Section Breaks<br />Insert Columns</li></ul><h4>Managing Long Documents</h4><ul><li>Insert Blank and Cover Pages<br />Insert an Index<br />Insert a Table of Contents<br />Insert an Anchillary Table<br />Manage Outlines<br />Create a Master Document</li></ul><h4>Manipulating Images</h4><ul><li>Integrate Pictures and Text<br />Adjust Image Appearance</li></ul><h4>Adding Document References and Links</h4><ul><li>Add Captions<br />Add Cross-References<br />Add Bookmarks<br />Add Hyperlinks<br />Insert Footnotes and Endnotes<br />Add Citations and a Bibilography</li></ul></div><div id="course-pills-3"><h4>Additional course details:</h4><br /><p>Nexus Humans Formatting Technical Documents Using Microsoft for Office 365 training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. </p><p></p> This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. <p></p>Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success.  <p></p>While we feel this is the best course for the Formatting Technical Documents Using Microsoft for Office 365 course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you.  <p></p>Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.<p></p></div>

Microsoft Certification

Microsoft Certified Trainer (MCT)

Formatting Technical Documents Using Microsoft for Office 365

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

Verhoef Training Ltd.

New Db2 13 Functions and Features - CV321G

Early bird

Book your place early to get an extra discount!

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



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


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


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


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


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


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


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

Bayfield Training

Financial Modelling & Analysis

Financial Modelling

Professional Development

Property & Real Estate Photography

Continuous Professional Development (CPD)

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

Real Estate Analyst (Investment Cash Flow Modelling in Excel)

In-Person 

Virtual

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

Microsoft Power Apps

Microsoft Sharepoint

Power Apps

Microsoft Power Platform

SharePoint

55215 SharePoint Online Power User

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

Excel Analytics

Access VBA

Visual Basic Analysis

Microsoft Power Automate

Excel - Automating Excel with Macros and Analysis Tools

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

Hi-Tech Training

City & Guilds

Electronics

Digital Design

Electrical Engineering

Analog Electronics

Computer Engineering

Digital Skills

Online Education

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

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

Digital Electronics Course Online

Deposit Only

Full Price (including Deposit)

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



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


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


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


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


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


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

Real Estate Finance

Investment Management

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

Real Estate Modelling Masterclass (Advanced Cash Flow Modelling)

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

Microsoft PL-900

Microsoft AZ-900

Microsoft AZ-303

PL-900T00 Microsoft Power Platform Fundamentals

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



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


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


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


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


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


Quizzes | Q&A


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


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

Property Investment

Risk Management

Investment

Financial Risk Management

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

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

<div id="course-pills-1">Duration<p>4 Days</p><p>24 CPD hours</p>This course is intended for<p></p><p>Collaboration Communications Systems Engineers are responsible for planning, deploying, configuring, maintaining, and troubleshooting Microsoft Teams Phone, meetings, and personal and shared space devices, including Microsoft Teams Rooms and Surface Hub.</p> <p>Collaboration Communications Systems Engineers have a fundamental understanding ofÃ¿networking, telecommunications, audio/visual and meeting room technologies, identity and access management.</p> <p>They are proficient in managing and monitoring Teams Phone, meetings, and certified devices using the Microsoft Teams admin center, PowerShell, the Microsoft Teams Rooms Pro Portal, and the Call Quality Dashboard. They deploy and configure Microsoft Teams Phone with PSTN connectivity through Microsoft Calling Plans, Operator Connect, Teams Phone Mobile, and Direct Routing.</p> <p>Collaboration Communications Systems Engineers work with Teams Administrators, Microsoft Identity and Access Administrators, and Microsoft 365Ã¿Administrators. In addition, they may work with owners of other workloads, including facilitiesÃ¿managers, network engineers, security engineers, device manufacturers, telephony providers, and Microsoft Certified solutions providers.</p><p></p><p></p><p>This training course is designed to give participants the knowledge and skills to become a Collaboration Communications Systems Engineer. Participants should understand the fundamentals of networking, telecommunications, audio/visual and meeting room technologies, identity and access management, and Microsoft Teams.</p> <p>They will gain hands-on experience configuring and deploying Microsoft Teams Phone, meetings and certified devices including Microsoft Teams Rooms and Surface Hub. The course will also cover how to manage and monitor Teams Phone, meetings, and certified devices using the Microsoft Teams admin center, PowerShell, the Microsoft Teams Rooms Pro Portal, and the Call Quality Dashboard.</p> <p>In addition, the course will cover configuring and deploying Microsoft Teams Phone with PSTN connectivity through Microsoft Calling Plans, Operator Connect, Teams Phone Mobile, and Direct Routing.</p><p></p>Prerequisites<p></p><ul> <li>Microsoft 365 and Microsoft Teams</li> <li>Networking, telecommunications, and audio/visual basics</li> <li>Identity and access management basics</li> </ul><p></p></div><div id="course-pills-2"><h3>1 - Introduction to Teams meetings and calling</h3> <ul> <li>Overview of Teams meetings and events</li> <li>Overview of Teams Phone</li> <li>Overview of auto attendants and call queues</li> <li>Overview of Teams devices</li> </ul> <h3>2 - Plan for Teams Phone</h3> <ul> <li>Plan to deploy Teams Phone</li> <li>Plan for Teams Phone PSTN connectivity</li> <li>Determine license requirements</li> <li>Plan for Teams Phone devices</li> <li>Plan and design Teams Phone features</li> <li>Plan for voicemail</li> </ul> <h3>3 - Plan for Microsoft Teams Rooms and Surface Hub</h3> <ul> <li>Determine license requirements for Microsoft Teams Rooms and shared devices</li> <li>Understand differences between Microsoft Teams Rooms on Android and Windows</li> <li>Understand Microsoft Teams Rooms on Surface Hub 2S</li> <li>Understand and plan Teams Room accessories, components, and peripherals</li> <li>Understand Teams Rooms management options</li> </ul> <h3>4 - Plan and optimize network performance for Teams media</h3> <ul> <li>Understand Teams network requirements</li> <li>Design network for media optimization</li> <li>Design and implement QoS</li> </ul> <h3>5 - Configure and deploy Teams Phone</h3> <ul> <li>Configure emergency calling for Teams Calling Plans</li> <li>Manage and configure Microsoft PSTN numbers</li> <li>Configure Operator Connect and Teams Phone Mobile</li> <li>Configure Teams Phone policies</li> <li>Create and manage Teams policies</li> <li>Configure Audio Conferencing</li> </ul> <h3>6 - Configure and deploy Teams Phone with Direct Routing</h3> <ul> <li>Design Direct Routing call flows</li> <li>Implement SIP trunking with Direct Routing</li> <li>Configure Emergency Calling for Direct Routing</li> <li>Extend Teams Direct Routing infrastructure</li> <li>Deploy and maintain a survivable branch appliance</li> </ul> <h3>7 - Extend Teams Phone with additional services</h3> <ul> <li>Understand how Teams interacts with additional services</li> <li>Configure compliance recording in Teams</li> <li>Configure and integrate a certified contact center in Teams</li> <li>Design and deploy voice bots in Teams</li> </ul> <h3>8 - Manage meetings and events experiences</h3> <ul> <li>Explore meetings and events in Microsoft Teams</li> <li>Configure meeting settings</li> <li>Create and manage meeting policies</li> <li>Configure audio conferencing</li> <li>Create and manage meeting templates and template policies</li> <li>Create and manage meetings customization policies</li> <li>Configure live events settings</li> <li>Create and manage live events policies</li> <li>Examine live events across Microsoft 365</li> </ul> <h3>9 - Guided project - Create and assign Teams policies to meet business requirements in Microsoft Teams</h3> <ul> <li>Prepare</li> </ul> <h3>10 - Configure and manage voice users</h3> <ul> <li>Enable users for Teams Phone</li> <li>Enable users for Direct Routing with Teams Phone</li> <li>Enable additional calling features for Teams Phone</li> <li>Enable users for Teams Phone Mobile</li> </ul> <h3>11 - Configure auto attendants and call queues</h3> <ul> <li>Design call flows for auto attendants and call queues</li> <li>Configure auto attendants and call queues</li> <li>Deploy a channel-based call queue</li> <li>Configure resource accounts</li> <li>Configure Microsoft 365 groups for voicemail</li> <li>Interpret call queue conference modes</li> <li>Interpret call queue routing methods</li> <li>Configure holidays for auto attendants and call queues</li> <li>Configure custom music on hold</li> </ul> <h3>12 - Configure, deploy, and manage Teams devices</h3> <ul> <li>Manage Microsoft Teams Phones</li> <li>Manage Microsoft Teams Room Systems</li> <li>Microsoft Teams Rooms management options</li> <li>Manage Surface Hub 2S devices</li> <li>Configure Microsoft Teams SIP gateway</li> <li>Manage Microsoft Teams displays</li> <li>Remote provisioning and sign in for Teams Phones</li> <li>Update Microsoft Teams devices remotely</li> <li>Manage Microsoft Teams device tags</li> </ul> <h3>13 - Guided project - Prepare meeting room experiences</h3> <ul> <li>Prepare</li> </ul> <h3>14 - Monitor and troubleshoot Teams collaboration communications systems</h3> <ul> <li>Diagnose and troubleshoot phone number assignment</li> <li>Diagnose and troubleshoot Teams client issues</li> <li>Diagnose and troubleshoot call failure and call quality issues</li> <li>Report on and troubleshoot Teams calls with Call Quality Dashboard</li> <li>Diagnose and troubleshoot Direct Routing issues</li> <li>Troubleshoot and monitor Teams devices</li> <li>Troubleshoot Teams meetings and calling</li> <li>Troubleshoot Teams Rooms devices</li> </ul></div>

Microsoft Teams

Clinical Engineer

MS-721T00 Collaboration Communications Systems Engineer

<div id="course-pills-1">Duration<p>3 Days</p><p>18 CPD hours</p>This course is intended for<p>This course is designed for Administrators who need to setup, configure and manage SharePoint Online as part of their Office 365 Administration.</p>Overview<p>After completing this course, students will gain the skills to:  - Understand the architecture of SharePoint Online  - Have knowledge of all the components in SharePoint Online  - Have on hands on experience configuring the components of SharePoint Online  - Have hands on experience configuring the options  - Work with Site Collections and storage options  - Manage user profiles and social profiling  - Understand and configure data connectivity in SharePoint Online  - Build a taxonomy structure   - Understand and configure Search in SharePoint Online  - Configure and deploy apps  - Understand and define Enterprise content management and data loss prevention.  - Configure additional options and features in SharePoint Online such as Information Rights Management</p><p>This course will introduce the audience to SharePoint Online Administration in Office 365 and explain and demonstrate the configuration options for SharePoint Online. The course is appropriate for existing SharePoint on-premises administrators and new administrators to Office 365 who need to understand how to correctly setup SharePoint Online for their company. The course will also help SharePoint on-premise administrators understand the differences between SharePoint on-premises and SharePoint Online.</p></div><div id="course-pills-2"><h3>1 - INTRODUCTION TO OFFICE 365 AND SHAREPOINT ONLINE</h3> <ul> <li>Introduction to the Office 365 Administration Center</li> <li>Configure Reporting</li> <li>Accessing SharePoint management tools</li> <li>Accessing security and compliancy</li> <li>Managing Office 365 and SharePoint Online with PowerShell</li> <li>Comparing On Premises SharePoint with SharePoint Online</li> <li>User identity in Office 365 and SharePoint Online</li> <li>Manging user domains</li> <li>Building Hybrid scenarios</li> <li>OneDrive and Sites redirection</li> <li>Yammer redirection</li> <li>Understand hybrid search</li> <li>Hybrid business data connectivity</li> <li>Hybrid taxonomy</li> </ul> <h3>2 - WORKING WITH SITE COLLECTIONS</h3> <ul> <li>Introduction to classic and modern admin centers</li> <li>Creating Site Collections</li> <li>Defining ownership and security for site collections</li> <li>Configuring Storage</li> <li>Configure External Access to site collections</li> <li>Recovering site collections</li> <li>Configure external sharing</li> <li>Managing site collections with PowerShell</li> </ul> <h3>3 - MANAGING USER PROFILES</h3> <ul> <li>Overview of the profile service</li> <li>Defining profile properties</li> <li>Map profile properties to a term store</li> <li>Creating custom profile properties</li> <li>Managing audiences</li> <li>Creating audiences</li> <li>Managing user profile policies</li> <li>Configure trusted my site host locations</li> <li>Configure preferred search center locations</li> <li>Defining read access permission levels</li> <li>Configuring newsfeed options</li> <li>Setup email notifications</li> <li>Configure my site cleanup</li> </ul> <h3>4 - WORKING WITH DATA CONNECTIONS</h3> <ul> <li>Introduction to Data Connections</li> <li>Overview of PowerApps, Flow and PowerBi</li> <li>Overview of the business connectivity service</li> <li>Introduction to BDC definition files</li> <li>Creating BDC definition files</li> <li>Introduction to the secure store service</li> <li>Configuring the secure store service</li> <li>Creating secure store target application settings</li> <li>Configure connections to cloud services</li> <li>Configure connections to on-premises services</li> <li>Tools to build data connections</li> <li>Creating external content types</li> <li>Building external lists using external data</li> </ul> <h3>5 - MANAGING THE TERM STORE</h3> <ul> <li>Overview of the term store</li> <li>Understanding terms and life cycle management</li> <li>Creating term groups</li> <li>Creating the term store</li> <li>Creating Term Sets in the UI</li> <li>Creating Term Sets via importing via a CSV</li> <li>Creating terms in the UI</li> <li>Creating terms via PowerShell and CSOM</li> <li>Manage terms with synonyms and pinning</li> <li>Configure delegated administration</li> </ul> <h3>6 - CONFIGURING SEARCH</h3> <ul> <li>An Introduction to the search service</li> <li>Classic versus Modern search experience</li> <li>Understanding Managed Properties</li> <li>Create Managed Properties</li> <li>Manage Authoritative pages</li> <li>Understand Result sources</li> <li>Create and configure result sources</li> <li>Understand Query rules</li> <li>Promoting results through query rules</li> <li>Remove search results from the index</li> <li>Exporting search configurations</li> <li>Importing search configurations</li> </ul> <h3>7 - CONFIGURING APPS</h3> <ul> <li>An Introduction to Apps</li> <li>Understanding the App Catalog</li> <li>Building the App catalog</li> <li>Adding Apps to the catalog</li> <li>Add Apps to your SharePoint sites</li> <li>Adding Apps via the marketplace store</li> <li>Manage App licensing</li> <li>Configure store access settings</li> <li>Monitoring app usage</li> </ul> <h3>8 - ENTERPRISE CONTENT MANAGEMENT IN SHAREPOINT ONLINE</h3> <ul> <li>An Introduction to ECM in SharePoint Online</li> <li>Components of ECM</li> <li>Office 365 versus classic compliancy</li> <li>Understanding In-Place records management</li> <li>Configure In-Place records management</li> <li>Understanding the records center</li> <li>Build and configure a records center</li> <li>Understanding the compliancy policy center</li> <li>Build a compliancy policy center and configure policies</li> <li>Discover the security and compliancy center</li> <li>Configure an eDiscovery center</li> <li>Build an eDiscovery case</li> <li>Understand data loss prevention</li> <li>Build a data loss prevention policy and query</li> <li>Working with classification and data governance</li> </ul> <h3>9 - MANAGE OPTIONS FOR SHAREPOINT ONLINE</h3> <ul> <li>Configure OneDrive features</li> <li>Configure use of Yammer or Newsfeeds</li> <li>Understand Information Rights Management</li> <li>Configure Information Rights Management</li> <li>Define site classification options</li> <li>Understand early release options for Office 365</li> <li>Configure Early release options for your Office 365 tenant</li> <li>Manage Access Control</li> </ul></div><div id="course-pills-3"><h4>Additional course details:</h4><br /><p>Nexus Humans 55238 SharePoint Online for Administrators training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. </p><p></p> This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. <p></p>Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success.  <p></p>While we feel this is the best course for the 55238 SharePoint Online for Administrators course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you.  <p></p>Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.<p></p></div>

3368 Office Skills courses delivered Online

Microsoft Publisher for Office 365/2021

By Nexus Human

Content Management System Training

By Janets

Microsoft Office Word 2021: Part 3

By Nexus Human

Microsoft Word for Office 365 (Desktop or Online) (v1.1) Part 1

By Nexus Human

Microsoft Office Word 2021: Part 1

By Nexus Human

Database for Beginners

By iStudy UK

Microsoft Office Word 2021: Part 2

By Nexus Human

Microsoft Office: Excel, Word, PowerPoint & Outlook Course

By Training Express

Link Access Tables to Excel Spreadsheets

By Skill Up

Formatting Technical Documents Using Microsoft for Office 365

By Nexus Human