Name: Advanced Excel Models using Formulas, VBA & Power Query
Price: 18 GBP
Availability: InStock

The Microsoft Access 2016 Beginner to Advanced course is a comprehensive training program covering all levels of proficiency. From creating simple databases to advanced querying, form creation, report generation, and database management, this course provides a deep understanding of Microsoft Access's features and functions.
<h3>Learning Outcomes:</h3>
<ol>
<li>Build and modify Access databases, tables, and fields.</li>
<li>Create effective queries to sort, filter, and summarize data.</li>
<li>Develop professional-looking reports with controls, charts, and calculations.</li>
<li>Design forms with controls, tab pages, and conditional formatting.</li>
<li>Automate tasks using macros and understand the basics of VBA.</li>
<li>Manage database performance, security, and object dependencies.</li>
<li>Create a database switchboard and modify startup options.</li>
<li>Understand data normalization, table relationships, and import/export processes.</li>
</ol>
<h3>Why buy this Microsoft Access 2016 Beginner to Advanced?</h3>
<ol>
<li>Digital Certificate, Transcript, student ID all included in the price</li>
<li>Absolutely no hidden fees</li>
<li>Directly receive CPD accredited qualifications after course completion</li>
<li>Receive one to one assistance on every weekday from professionals</li>
<li>Immediately receive the PDF certificate after passing</li>
<li>Receive the original copies of your certificate and transcript on the next working day</li>
<li>Easily learn the skills and knowledge from the comfort of your home</li>
</ol>
<h3>Certification</h3>
<div>After studying the course materials of the Microsoft Access 2016 Beginner to Advanced you will be able to take the MCQ test that will assess your knowledge. After successfully passing the test you will be able to claim the pdf certificate for £5.99. Original Hard Copy certificates need to be ordered at an additional cost of £9.60.</div>
<h3>Who is this course for?</h3>
<div>
<ul>
<li>Beginners with no previous experience in Microsoft Access.</li>
<li>Professionals seeking to enhance their database management and reporting skills.</li>
<li>Individuals aiming to become proficient in creating and maintaining databases.</li>
<li>Students pursuing careers in data analysis, administration, or database management.</li>
</ul>
</div>
<h3>Prerequisites</h3>
<div>This Microsoft Access 2016 Beginner to Advanced was made by professionals and it is compatible with all PC's, Mac's, tablets and smartphones. You will be able to access the course from anywhere at any time as long as you have a good enough internet connection.</div>
<h3>Career path</h3>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<ul>
<li>Data Analyst: Analyze, interpret, and present data insights using Access.</li>
<li>Database Administrator: Design, implement, and maintain databases for organizations.</li>
<li>Administrative Assistant: Manage data, generate reports, and streamline processes.</li>
<li>Project Manager: Organize project-related data and create performance reports.</li>
<li>Business Owner: Build and manage databases to support business operations.</li>
</ul>
</div>
</div>
</div>
</div>
</div>
</div>
</div><div>
				<h3>
	Course Curriculum
</h3>

<div>
<table width="100%">				<tbody><tr>
					<td colspan="4">Module - 1</td>
				</tr>
								<tr>
					<td></td>
					<td>Orientation to Microsoft Access</td>
					<td> </td>
					<td> 01:00:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Create a Simple Access Database</td>
					<td> </td>
					<td> 01:00:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Get Help in Microsoft Access</td>
					<td> </td>
					<td> 00:30:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Modify Table Data</td>
					<td> </td>
					<td> 00:30:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Work with Records</td>
					<td> </td>
					<td> 01:00:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Sort and Filter Records</td>
					<td> </td>
					<td> 00:30:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Create Lookups</td>
					<td> </td>
					<td> 01:00:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Join Data from Different Tables in a Query</td>
					<td> </td>
					<td> 01:00:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Sort and Filter Data in a Query</td>
					<td> </td>
					<td> 01:00:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Perform Calculations in a Query</td>
					<td> </td>
					<td> 00:30:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Create Parameter Queries</td>
					<td> </td>
					<td> 00:30:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Create Action Queries</td>
					<td> </td>
					<td> 00:30:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Create Find Duplicate and Find Unmatched Queries</td>
					<td> </td>
					<td> 00:30:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Summarize Data</td>
					<td> </td>
					<td> 00:30:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Create a Report</td>
					<td> </td>
					<td> 01:00:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Add Controls to a Report</td>
					<td> </td>
					<td> 00:30:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Enhance the Appearance of a Report</td>
					<td> </td>
					<td> 00:30:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Prepare a Report for Print</td>
					<td> </td>
					<td> 00:30:00</td>
				</tr>
								<tr>
					<td></td>
					<td>The Access Options Dialog Box</td>
					<td> </td>
					<td> 01:00:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Relational Database Design</td>
					<td> </td>
					<td> 00:30:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Create a Table</td>
					<td> </td>
					<td> 01:00:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Modify a Table and Fields</td>
					<td> </td>
					<td> 00:30:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Create Table Relationships</td>
					<td> </td>
					<td> 00:30:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Create Query Joins</td>
					<td> </td>
					<td> 00:30:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Join Tables That Have No Common Fields</td>
					<td> </td>
					<td> 00:30:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Relate Data within a Table</td>
					<td> </td>
					<td> 00:30:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Work with Subdatasheets</td>
					<td> </td>
					<td> 00:30:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Create Subqueries</td>
					<td> </td>
					<td> 00:30:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Data Normalization</td>
					<td> </td>
					<td> 01:00:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Create a Junction Table</td>
					<td> </td>
					<td> 00:30:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Import Data into Access</td>
					<td> </td>
					<td> 00:30:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Export Data to Text File Formats</td>
					<td> </td>
					<td> 00:30:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Export Access Data to Excel</td>
					<td> </td>
					<td> 00:30:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Create a Mail Merge</td>
					<td> </td>
					<td> 00:30:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Organize Report Information</td>
					<td> </td>
					<td> 00:30:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Format Reports</td>
					<td> </td>
					<td> 00:30:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Include Charts in a Report</td>
					<td> </td>
					<td> 00:30:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Add a Calculated Field to a Report</td>
					<td> </td>
					<td> 00:30:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Add a Subreport to an Existing Report</td>
					<td> </td>
					<td> 00:30:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Create a Mailing Label Report</td>
					<td> </td>
					<td> 00:30:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Publish a Report as PDF</td>
					<td> </td>
					<td> 00:30:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Activities - Microsoft Access 2016 for Beginners</td>
					<td> </td>
					<td> 00:00:00</td>
				</tr>
								<tr>
					<td colspan="4">Module - 2</td>
				</tr>
								<tr>
					<td></td>
					<td>Add Controls to Forms</td>
					<td> </td>
					<td> 01:00:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Set Form Controls</td>
					<td> </td>
					<td> 01:00:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Create Subforms</td>
					<td> </td>
					<td> 00:30:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Organize Information with Tab Pages</td>
					<td> </td>
					<td> 00:30:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Enhance Navigation with Forms</td>
					<td> </td>
					<td> 00:30:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Format a Form</td>
					<td> </td>
					<td> 01:00:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Apply Conditional Formatting</td>
					<td> </td>
					<td> 00:30:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Field Validation</td>
					<td> </td>
					<td> 00:30:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Form and Record Validation</td>
					<td> </td>
					<td> 00:30:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Create a Macro</td>
					<td> </td>
					<td> 01:00:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Restrict Records Using a Condition</td>
					<td> </td>
					<td> 00:30:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Validate Data Using a Macro</td>
					<td> </td>
					<td> 00:30:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Automate Data Entry Using a Macro</td>
					<td> </td>
					<td> 00:30:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Convert a Macro to VBA</td>
					<td> </td>
					<td> 00:30:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Link Tables to External Data Sources</td>
					<td> </td>
					<td> 00:30:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Manage a Database</td>
					<td> </td>
					<td> 00:30:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Determine Object Dependency</td>
					<td> </td>
					<td> 00:30:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Document a Database</td>
					<td> </td>
					<td> 00:30:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Analyze the Performance of a Database</td>
					<td> </td>
					<td> 00:30:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Split a Database for Multiple User Access</td>
					<td> </td>
					<td> 00:30:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Implement Security</td>
					<td> </td>
					<td> 00:30:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Set Passwords</td>
					<td> </td>
					<td> 00:30:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Convert an Access Database to an ACCDE File</td>
					<td> </td>
					<td> 00:30:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Package a Database with a Digital Signature</td>
					<td> </td>
					<td> 00:30:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Create a Database Switchboard</td>
					<td> </td>
					<td> 01:00:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Modify a Database Switchboard</td>
					<td> </td>
					<td> 00:30:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Set Startup Options</td>
					<td> </td>
					<td> 00:30:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Activities - Microsoft Access 2016 Advanced</td>
					<td> </td>
					<td> 00:00:00</td>
				</tr>
				</tbody></table></div>

			</div>

Studyhub UK

Microsoft Certification

Microsoft AZ-900

Microsoft AZ-104

Microsoft Access

Microsoft AZ-303

Microsoft AZ-700

Microsoft Access 2016 Beginner to Advanced

General Admission

<div id="course-pills-1">Duration3 Days18 CPD hoursThis course is intended forAny IT specialist eager to become an industry recognized expert on Veeam software solutions.OverviewThis certification is an excellent investment for an IT professional looking to increase productivity, reduce operating costs, increase potential for personal career advancement and gain recognition from the employer and customers. By completing the Veeam Certified Engineer (VMCE) course you should be able to: Get more functionality out of Veeam solutions Identify and resolve issues more efficiently Gain a distinction from your peersThe Veeam Certified Engineer (VMCE) course is a 3-day technical deep-dive focused on teaching engineers to architect, implement, optimize and troubleshoot the Veeam software solution.</div><div id="course-pills-2"><h4>Module 1</h4><ul><li>Introduction</li></ul><h4>Module 2</h4><ul><li>Veeam Products</li><li>Veeam Availability Suite</li><li>Key Concepts</li></ul><h4>Module 3</h4><ul><li>Auto Discovery of Backup and Virtual Infrastructure</li><li>Business Categorization</li><li>Pre-Defined Alerting</li><li>Unattended Monitoring</li><li>Reporting and Dashboards</li><li>Agentless Data Gathering</li><li>Hyper-V Specific Features</li><li>Veeam One Deployment</li><li>Veeam One Assessment Tool</li></ul><h4>Module 4</h4><ul><li>Core Components and Their Interaction</li><li>Optional Components</li><li>Deployment Scenarios</li><li>Prerequisites</li><li>Upgrading Veeam Backup &amp; Replication </li></ul><h4>Module 5</h4><ul><li>Adding Servers</li><li>Adding a VMware Backup Proxy</li><li>Adding a Hyper-V Off-host Backup Proxy</li><li>Adding Backup Repositories</li><li>Performing Configuration Backup and Restore</li><li>Managing Network Traffic</li><li>Global Notification Settings</li><li>Getting to Know User Interface</li></ul><h4>Module 6</h4><ul><li>Creating Backup Jobs</li><li>Creating Restore Points with VeeamZIP and Quick Backup</li><li>Backup Copy</li><li>Replication</li><li>Creating VM/File Copy Jobs</li></ul><h4>Module 7</h4><ul><li>SureBackup Recovery Verification</li><li>SureReplica</li></ul><h4>Module 8</h4><ul><li>Data Recovery</li><li>Working with Veeam Backup &amp; Replication Utilities</li><li>Insight into Recovery from Replica</li></ul><h4>Module 9</h4><ul><li>Item-Level Recovery</li><li>Guest OS File Recovery</li></ul><h4>Module 10</h4><ul><li>Tape Device Support</li><li>SAN Storage Systems Support</li><li>Support for Deduplicating Storage Systems</li><li>Veeam Cloud Connect</li><li>Veeam Backup Enterprise Manager</li><li>vCloud Director Support</li></ul><h4>Module 11</h4><ul><li>Product Editions Comparison</li><li>Full and Free Functionality Modes</li></ul><h4>Module 12</h4><ul><li>How to Identify the Problem</li><li>How to review and analyze the issue</li><li>Search for additional information</li><li>Veeam Support</li></ul></div>

Nexus Human

VMware Vsphere

Veeam

IT Certifications

Microsoft Virtual Academy (MVA)

Certification in Cash & Voucher Assistant (CVA)

VMCE95-Veeam Certified Engineer

<div id="course-pills-1">Duration1 Days6 CPD hoursThis course is intended forThe primary audience for this course is as follows: Cloud solution architects Cloud administrators Customer sales engineers DevOps engineers Sales engineers Systems engineers Technical solutions architectsOverviewAfter you complete this course the learner will be able to meet these overall objectives: Describe what clouds are supported and how to configure clouds for Cost Optimizer Examine the Cost Optimizer snapshots of costs incurred by the various clouds installed for an organizationCLDCO, Mulitcloud Cost Optimization with Cisco CloudCenter Suite is a 1-day course that teaches you how the reporting and analysis of consumption the cost optimizer provides, functions within a CiscoÂ© CloudCenter Suite. The cost optimizer works together with two other primary mechanisms: a workload manager that helps users deploy applications and manage governance policies, and an action orchestrator that provides seamless integration and workflow automation. Through lessons and hands-on experiences, you will learn the functionality of the CloudCenter cost optimizer.This course will help you:Acquire the advanced skills and techniques using the CloudCenter Suite for a consistent experience across all environments, whether you plan to deploy in the cloud or on-premisesLearn how to use the tools of cost management and workload optimization by leveraging the functionality of the entire CloudCenter suite</div><div id="course-pills-2"><h4>Implementing Cisco CloudCenter Suite Cost Optimizer</h4><ul><li>Cisco CloudCenter Suite Cost Optimizer</li></ul><h4>Examining Cost Optimizer Inventory, Reports, Rightsizing, and Troubleshooting</h4><ul><li>Configure Cost and Inventory Reports in the User Interface</li></ul></div><div id="course-pills-3"><h4>Additional course details:</h4> Nexus Humans Cisco Multicloud Cost Optimization with Cisco CloudCenter Suite (CLDCO) training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. 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. While we feel this is the best course for the Cisco Multicloud Cost Optimization with Cisco CloudCenter Suite (CLDCO) 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. 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.</div>

Cisco Certified Network Professional certification (CCNP)

Certified Cryptocurrency Investigator Course (CCI)

Certificate of Completion (CCL)

Certified Cloud Security Professional (CCSP)

AWS Certified Cloud Practitioner

Commercial & Contract Management Certification Program (CCM)

Cisco Multicloud Cost Optimization with Cisco CloudCenter Suite (CLDCO)

<div id="course-pills-1">Duration4 Days24 CPD hoursThis course is intended forTechnical decision makers Network architectsOverviewAfter taking this course, you should be able to: Discover and describe the Cisco Multilayer Director Switch (MDS) platform of multilayer switches and directors. Provisioning Cisco MDS Switches Describe key product features of the MDS platform Describe and implement automation an Cisco MDS Switches Configure and implement the Cisco MDS switches and platform features Resolve issues and troubleshoot FC domains, zones and zone merges, and switch boot and firmware upgradesThis course shows you how to implement, manage, and troubleshoot CiscoÂ© MDS 9000 Series Switches, to build highly available, scalable storage networks. Through expert instruction and extensive hands-on practice, you will learn how to deploy and use capabilities such as virtual storage area networks (VSANs), Role-Based Access Control (RBAC), N-Port Virtualization (NPV) fabric security, zoning, automation with NX-API, Slow Drain Analysis, Fibre Channel over TCP/IP (FCIP) tunnels, and more. You will learn how to configure and implement platform features and learn troubleshooting techniques pertaining to Fibre Channel (FC) domains, firmware upgrades, zones, and zone mergers. This course prepares you for Cisco CCNP Data Center and Cisco Certified Specialist - Data Center SAN Implementation certifications.</div><div id="course-pills-2"><h4>Describing Cisco MDS Platform</h4><ul><li>Cisco MDS 9700/9300/9200/9100 Hardware</li><li>Cisco NX-OS</li><li>Cisco DCNM</li><li>Fibre Channel Architecture</li><li>FCoE Architecture</li></ul><h4>Provisioning Cisco MDS Switches</h4><ul><li>Power-On Auto-Provisioning</li><li>Cisco DCNM</li><li>Using Cisco DCNM 11.x</li><li>RBAC and Authentication, Authorization, and Accounting (AAA)</li></ul><h4>Building the Fibre Channel Fabric with Cisco MDS Switches</h4><ul><li>Virtual SANs</li><li>Port Channels and VSAN Trunking</li><li>Zoning and Smart Zoning</li><li>Device Aliases</li><li>Inter-VSAN Routing</li><li>Fibre Channel Fabric Security</li><li>Building SAN Extensions</li><li>Inter-VSAN Routing</li><li>Slow Drain Analysis</li><li>SAN Analytics and Telemetry Streaming</li><li>Cisco Secure Boot</li><li>NPV and NPIV</li></ul><h4>Automating Cisco MDS Fabric</h4><ul><li>Cisco MDS NX_APIPython API</li><li>Ansible</li></ul><h4>Monitoring and Reporting Cisco MDS Features</h4><ul><li>Cisco DCNM SAN Reports and Alarms</li><li>SAN Analytics and SAN Telemetry Streaming</li></ul><h4>Troubleshooting Common Cisco MDS Issues</h4><ul><li>Troubleshooting Fibre Channel Domains, Zones and Zone Merges</li><li>Boot and Upgrade Issues</li></ul></div>

Cisco Certified Network Associate (CCNA)

Service Design Courses (SDC)

Cisco Certified Internetwork Expert (CCIE)

Cisco Configuring Cisco MDS 9000 Series Switches v3.5 (DCMDS)

<div id="course-pills-1">Duration2 Days12 CPD hoursIn this course, you will be introduced to Intuit?s cloud accounting software program, QuickBooks Online (QBO). Using a fictitious company called Luxury Lodging, Inc, students will learn how to navigate the QBO interface. We cover basic accounting, how to set up a new company, how to customize the chart of accounts and products and services list. In addition, students will learn how to give other users, such as accountants access to their data. In the sales center chapter, students will learn how to invoice customers and stay on top of accounts receivable balances. In the vendor center chapter, students will learn how to enter bills and expenses from vendors as well as stay on top of the accounts payable balances. The final chapter in the textbook is a final project that encompasses the key topics covered in this course.</div><div id="course-pills-2"><h4>Course Outline </h4><ul><li>Chapter 1 :Introduction</li><li>Chapter 2 :An Overview of QBO &amp; Navigation Basics</li><li>Chapter 3 : Accounting Basics</li><li>Chapter 4 : Setting up A New Company File</li><li>Chapter 5 : Managing the Chart of Accounts List</li><li>Chapter 6 : Managing the Products and Services (Items) List</li><li>Chapter 7 : Adding and Managing Users</li><li>Chapter 8 : The Sales Center</li><li>Chapter 9 : The Vendor Center</li><li>Chapter 10 : 1099 Tracking and Reporting</li><li>Chapter 11 : Managing Bank and Credit Card Accounts</li><li>Chapter 12 : Creating Financial Statement Reports</li><li>Chapter 13 : Entering Historical Data and Opening Balances</li><li>Chapter 14 : Putting It All Together</li></ul></div><div id="course-pills-3"><h4>Additional course details:</h4> Nexus Humans Get Started with QuickBooks Online 2021-2022 training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. 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. While we feel this is the best course for the Get Started with QuickBooks Online 2021-2022 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. 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.</div>

Online Course Marketing

Online Course Creation

Business Accounting

Accounting & Bookkeeping

QuickBooks

Practical Accounting

Get Started with QuickBooks Online 2021-2022

<div id="course-pills-1">Duration3 Days18 CPD hoursThis course is intended forAnyone starting to write SAS programsOverviewUse SAS Studio and SAS Enterprise Guide to write and submit SAS programs. Access SAS, Microsoft Excel, and text data. Explore and validate data. Prepare data by subsetting rows and computing new columns. Analyze and report on data. Export data and results to Excel, PDF, and other formats. Use SQL in SAS to query and join tables.This course is for users who want to learn how to write SAS programs to access, explore, prepare, and analyze data. It is the entry point to learning SAS programming for data science, machine learning, and artificial intelligence.</div><div id="course-pills-2"><h4>Essentials</h4><ul><li>The SAS programming process.</li><li>Using SAS programming tools.</li><li>Understanding SAS syntax.</li></ul><h4>Accessing Data</h4><ul><li>Understanding SAS data.</li><li>Accessing data through libraries.</li><li>Importing data into SAS.</li></ul><h4>Exploring and Validating Data</h4><ul><li>Exploring data.</li><li>Filtering rows.</li><li>Formatting columns.</li><li>Sorting data and removing duplicates.</li></ul><h4>Preparing Data</h4><ul><li>Reading and filtering data.</li><li>Computing new columns.</li><li>Conditional processing.</li></ul><h4>Analyzing and Reporting on Data</h4><ul><li>Enhancing reports with titles, footnotes, and labels.</li><li>Creating frequency reports.</li><li>Creating summary statistics reports.</li></ul><h4>Exporting Results</h4><ul><li>Exporting data.</li><li>Exporting reports.</li></ul><h4>Using SQL in SAS</h4><ul><li>Using Structured Query Language in SAS.</li><li>Joining tables using SQL in SAS.</li></ul></div><div id="course-pills-3"><h4>Additional course details:</h4> Nexus Humans SAS Programming 1 - Essentials training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. 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. While we feel this is the best course for the SAS Programming 1 - Essentials 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. 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.</div>

SIA Training

Professional Skills Course (PSC)

Trainers Course

Ssas

SAS Programming 1 - Essentials

<div id="course-pills-1">Duration5 Days30 CPD hoursThis course is intended forIS Security Officers IS Managers Virtualization Engineers and Managers Cloud Security ManagersOverviewUpon completion, the Certified Digital Forensics Examiner candidate will be able to competently take the CDFE exam.The Certified Digital Forensics Examiner, C)DFE certification is designed to train Cyber Crime and Fraud Investigators. Students are taught electronic discovery and advanced investigation techniques.Ã¿ This course is essential to anyone encountering digital evidence while conducting an investigation. Mile2?s Certified Digital Forensics Examiner training teaches the methodology for conducting a computer forensic examination. Students will learn to use forensically sound investigative techniques in order to evaluate the scene, collect and document all relevant information, interview appropriate personnel, maintain chain-of-Ã°custody, and write a findings report. Through the use of a risk-based approach, the C)DFE is able to implement and maintain cost-effective security controls that are closely aligned with both business and industry standards.</div><div id="course-pills-2"><h4>Course Outline</h4><ul><li>Computer Forensic Incidents</li><li>Investigative Theory</li><li>Investigative Process</li><li>Digital Acquisition and Analysis</li><li>Disks and Storages</li><li>Live Acquisitions</li><li>Windows Forensics</li><li>Linux Forensics</li><li>Mac Forensics</li><li>Examination Protocols</li><li>Digital Evidence Protocols</li><li>Digital Evidence Presentation</li><li>Laboratory Protocols</li><li>Specialized Artifact Recovery</li><li>eDiscovery and ESI</li><li>Mobile Forensics</li><li>Incident Handling</li><li>Reporting</li></ul></div><div id="course-pills-3"><h4>Additional course details:</h4> Nexus Humans C)DFE - Certified Digital Forensics Examiner Mile 2 training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. 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. While we feel this is the best course for the C)DFE - Certified Digital Forensics Examiner Mile 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. 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.</div>

Certificate in Further Education & Training (Cert Ed)

Certified Fraud Examiner (CFE)

Cyber Security Foundation

ICDL (International Certification of Digital Literacy)

C)DFE - Certified Digital Forensics Examiner Mile 2

<div id="course-pills-1">Duration3 Days18 CPD hoursThis course is intended forAny IT specialist eager to become an industry recognized expert on Veeam software solutions.OverviewThis certification is an excellent investment for an IT professional looking to increase productivity, reduce operating costs, increase potential for personal career advancement and gain recognition from the employer and customers. By completing the Veeam Certified Engineer (VMCE) course you should be able to:Get more functionality out of Veeam solutionsIdentify and resolve issues more efficientlyGain a distinction from your peersThe Veeam Certified Engineer (VMCE) course is a 3-day technical deep-dive focused on teaching engineers to architect, implement, optimize and troubleshoot the Veeam software solution.</div><div id="course-pills-2"><h4>Module 1</h4><ul><li>Introduction</li></ul><h4>Module 2</h4><ul><li>Veeam Products</li><li>Veeam Availability Suite</li><li>Key Concepts</li></ul><h4>Module 3</h4><ul><li>Auto Discovery of Backup and Virtual Infrastructure</li><li>Business Categorization</li><li>Pre-Defined Alerting</li><li>Unattended Monitoring</li><li>Reporting and Dashboards</li><li>Agentless Data Gathering</li><li>Hyper-V Specific Features</li><li>Veeam One Deployment</li><li>Veeam One Assessment Tool</li></ul><h4>Module 4</h4><ul><li>Core Components and Their Interaction</li><li>Optional Components</li><li>Deployment Scenarios</li><li>Prerequisites</li><li>Upgrading Veeam Backup &amp; Replication </li></ul><h4>Module 5</h4><ul><li>Adding Servers</li><li>Adding a VMware Backup Proxy</li><li>Adding a Hyper-V Off-host Backup Proxy</li><li>Adding Backup Repositories</li><li>Performing Configuration Backup and Restore</li><li>Managing Network Traffic</li><li>Global Notification Settings</li><li>Getting to Know User Interface</li></ul><h4>Module 6</h4><ul><li>Creating Backup Jobs</li><li>Creating Restore Points with VeeamZIP and Quick Backup</li><li>Backup Copy</li><li>Replication</li><li>Creating VM/File Copy Jobs</li></ul><h4>Module 7</h4><ul><li>SureBackup Recovery Verification</li><li>SureReplica</li></ul><h4>Module 8</h4><ul><li>Data Recovery</li><li>Working with Veeam Backup &amp; Replication Utilities</li><li>Insight into Recovery from Replica</li></ul><h4>Module 9</h4><ul><li>Item-Level Recovery</li><li>Guest OS File Recovery</li></ul><h4>Module 10</h4><ul><li>Tape Device Support</li><li>SAN Storage Systems Support</li><li>Support for Deduplicating Storage Systems</li><li>Veeam Cloud Connect</li><li>Veeam Backup Enterprise Manager</li><li>vCloud Director Support</li></ul><h4>Module 11</h4><ul><li>Product Editions Comparison</li><li>Full and Free Functionality Modes</li></ul><h4>Module 12</h4><ul><li>How to Identify the Problem</li><li>How to review and analyze the issue</li><li>Search for additional information</li><li>Veeam Support</li></ul></div>

VEEAM-VMCE Veeam Certified Engineer

John Academy

Digital Marketing

Search Engine Optimisation (SEO)

Diploma in Management Studies (DMS)

Search Engine Optimisation Audit

Google Digital Marketing

Diploma in SEO and Digital Marketing

<div>
	<h3>Course overview</h3>
Take a practical approach to enhance your Excel modelling skills with the Advanced Excel Models using Formulas, VBA &amp; Power Query course. In this course, you will learn how to build robust Excel models using Formulas, VBA and Power Query.
This Advanced Excel Models using Formulas, VBA &amp; Power Query course offers a wide range of training modules to enhance your abilities to create better models. You will discover the advanced Excel formulas to prepare reports, forecast and perform mathematical calculations.  We will introduce you to the three excel models and show the functions used to prepare these pro models. In addition, you will learn the Excel formulas for prepaid expenses and explore the steps to create dynamic dashboards based on Power Query and Pivot Table without any formula.
<h3>Learning outcomes</h3>
<ul>
<li>Familiarize yourself with the advanced Excel formulas</li>
<li>Be able to manage prepaid expenses</li>
<li>Deepen your understanding of the prepaid expense models</li>
<li>Learn about the pro Excel models and formulas</li>
<li>Strengthen your knowledge of Power Query and PowerPivot</li>
<li>Learn how to create Power query and pivot table based dashboard without any formula</li>
</ul>
<h3>Who Is This Course For?</h3>
This  Advanced Excel Models using Formulas, VBA &amp; Power Query course is recommended to anyone interested in learning how to prepare robust Excel models using advanced formulas, Power Query and VBA. In addition, the skills gained from this training will provide excellent opportunities for career advancement.
<h3>Entry Requirement</h3>
<ul>
<li>This course is available to all learners of all academic backgrounds.</li>
<li>Learners should be aged 16 or over.</li>
<li>Good understanding of English language, numeracy and ICT skills are required to take this course.</li>
</ul>
<h3>Certification</h3>
<ul>
<li>After you have successfully completed the course, you will obtain an Accredited Certificate of Achievement. And, you will also receive a Course Completion Certificate following the course completion without sitting for the test. Certificates can be obtained either in hardcopy for £39 or in PDF format at the cost of £24.</li>
<li>PDF certificate's turnaround time is 24 hours, and for the hardcopy certificate, it is 3-9 working days.</li>
</ul>
<h3>Why Choose Us?</h3>
<ul>
<li>Affordable, engaging &amp; high-quality e-learning study materials;</li>
<li>Tutorial videos and materials from the industry-leading experts;</li>
<li>Study in a user-friendly, advanced online learning platform;</li>
<li>Efficient exam systems for the assessment and instant result;</li>
<li>United Kingdom &amp; internationally recognized accredited qualification;</li>
<li>Access to course content on mobile, tablet and desktop from anywhere, anytime;</li>
<li>Substantial career advancement opportunities;</li>
<li>24/7 student support via email.</li>
</ul>
<h3>Career Path</h3>
The Advanced Excel Models using Formulas, VBA &amp; Power Query Course provides  essential skills that will make you more effective in your role. It would be beneficial for any related profession in the industry, such as:
<ul>
<li>Data Analyst</li>
<li>System Support and Reporting Analyst</li>
</ul>
		</div><table width="100%">				<tbody><tr>
					<td colspan="4"> Introduction</td>
				</tr>
								<tr>
					<td></td>
					<td>Course Outline and Introduction</td>
					<td> </td>
					<td> 00:04:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Minimum Requirements for the Course</td>
					<td> </td>
					<td> 00:01:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Prepayments Introduction</td>
					<td> </td>
					<td> 00:01:00</td>
				</tr>
								<tr>
					<td colspan="4">Prepaid Expenses Models: Resources Download</td>
				</tr>
								<tr>
					<td></td>
					<td>Month End Date Prepaid Expenses Amortization Calculation</td>
					<td> </td>
					<td> 00:00:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Exact Prepaid Expenses Payment Date Calculation</td>
					<td> </td>
					<td> 00:00:00</td>
				</tr>
								<tr>
					<td colspan="4">Accounting for Prepaid Expenses</td>
				</tr>
								<tr>
					<td></td>
					<td>Prepaid Expenses Accounting Definition: Prepayments</td>
					<td> </td>
					<td> 00:03:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Prepaid Expense Example: How Accounting works for Prepayments</td>
					<td> </td>
					<td> 00:03:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Advantages and Disadvantages of Prepaid Expenses</td>
					<td> </td>
					<td> 00:03:00</td>
				</tr>
								<tr>
					<td colspan="4">Excel Formulas Detailed: Introduction to three Excel Models</td>
				</tr>
								<tr>
					<td></td>
					<td>Introduction to PRO Excel Models and Formulas</td>
					<td> </td>
					<td> 00:06:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Date Function</td>
					<td> </td>
					<td> 00:05:00</td>
				</tr>
								<tr>
					<td></td>
					<td>EOMONTH Function</td>
					<td> </td>
					<td> 00:04:00</td>
				</tr>
								<tr>
					<td></td>
					<td>DATEVALUE function</td>
					<td> </td>
					<td> 00:03:00</td>
				</tr>
								<tr>
					<td></td>
					<td>IF Function</td>
					<td> </td>
					<td> 00:08:00</td>
				</tr>
								<tr>
					<td></td>
					<td>IFS Function (Office 365 Only)</td>
					<td> </td>
					<td> 00:07:00</td>
				</tr>
								<tr>
					<td></td>
					<td>VLOOKUP Function</td>
					<td> </td>
					<td> 00:07:00</td>
				</tr>
								<tr>
					<td></td>
					<td>MATCH Function</td>
					<td> </td>
					<td> 00:05:00</td>
				</tr>
								<tr>
					<td></td>
					<td>INDIRECT Function</td>
					<td> </td>
					<td> 00:02:00</td>
				</tr>
								<tr>
					<td></td>
					<td>NAMED Ranges: Name Manager</td>
					<td> </td>
					<td> 00:03:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Advanced Version of VLOOKUP Function</td>
					<td> </td>
					<td> 00:07:00</td>
				</tr>
								<tr>
					<td colspan="4">Formula Based Prepaid Expenses Model</td>
				</tr>
								<tr>
					<td></td>
					<td>Introduction to Model and Control Panel Tab (Important Sheet Tab)</td>
					<td> </td>
					<td> 00:08:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Formula Based Prepaid Expenses Model - Deep Dive (Part 1)</td>
					<td> </td>
					<td> 00:05:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Formula Based Prepaid Expenses Model - Deep Dive (Part 2)</td>
					<td> </td>
					<td> 00:06:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Formula Based Prepaid Expenses Model - Deep Dive (Part 3)</td>
					<td> </td>
					<td> 00:06:00</td>
				</tr>
								<tr>
					<td></td>
					<td>IFS Function - Month End date Prepayment calculation</td>
					<td> </td>
					<td> 00:04:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Prepaid Expenses - Closing Balance Summary Tab (Formula Based Summary)</td>
					<td> </td>
					<td> 00:09:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Protecting Formulas Cells and Fields in the Model</td>
					<td> </td>
					<td> 00:04:00</td>
				</tr>
								<tr>
					<td colspan="4">Calculate Prepaid Expenses Amortisation from Exact Start Date</td>
				</tr>
								<tr>
					<td></td>
					<td>Exact Date Prepaid Amortisation calculation Intro</td>
					<td> </td>
					<td> 00:03:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Formulas update and Model Changes for Exact Prepaid Exps Calculation</td>
					<td> </td>
					<td> 00:03:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Formulas Update for Exact Date Prepaid Exps Amortisation (Part 1)</td>
					<td> </td>
					<td> 00:04:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Formulas Update for Exact Date Prepaid Exps Amortisation (Part 2)</td>
					<td> </td>
					<td> 00:03:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Formulas Update for Exact Date Prepaid Exps Amortisation (Part 3)</td>
					<td> </td>
					<td> 00:02:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Formulas Update for Exact Date Prepaid Exps Amortisation (Part 4)</td>
					<td> </td>
					<td> 00:07:00</td>
				</tr>
								<tr>
					<td></td>
					<td>IFS Function - Exact Date Prepayments Amortisation</td>
					<td> </td>
					<td> 00:04:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Data Validation Controls (Enhancing Data Input Controls with Protection)</td>
					<td> </td>
					<td> 00:10:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Bonus: Prepayment Model with Opening Balance Calculation (Part 1)</td>
					<td> </td>
					<td> 00:08:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Bonus: Prepayment Model with Opening Balance Calculation (Part 2)</td>
					<td> </td>
					<td> 00:09:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Additional Material: Resources</td>
					<td> </td>
					<td> 00:00:00</td>
				</tr>
								<tr>
					<td colspan="4">Prepaid Expenses Summary with Power Query and Pivot Table</td>
				</tr>
								<tr>
					<td></td>
					<td>Power Query and Pivot Table Prepayment Summary Table Intro</td>
					<td> </td>
					<td> 00:06:00</td>
				</tr>
								<tr>
					<td></td>
					<td>What is Power Query and Some Awesome Resources for Power Query learning</td>
					<td> </td>
					<td> 00:07:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Power Query and Pivot Table Summary - Deep Dive (Part 1)</td>
					<td> </td>
					<td> 00:05:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Power Query and Pivot Table Summary - Deep Dive (Part 2)</td>
					<td> </td>
					<td> 00:04:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Power Query and Pivot Table Summary - Deep Dive (Part 3)</td>
					<td> </td>
					<td> 00:05:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Power Query and Pivot Table Summary - Deep Dive (Part 4)</td>
					<td> </td>
					<td> 00:09:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Using Array Formulas to Add Formula Protection</td>
					<td> </td>
					<td> 00:04:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Bonus: Allocate Prepaid Expenditure Cost Centre Wise - 1</td>
					<td> </td>
					<td> 00:02:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Bonus: Allocate Prepaid Expenditure Cost Centre Wise - 2</td>
					<td> </td>
					<td> 00:08:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Bonus: Prepayment Model with Opening Balance Calculation (PQ and PT Version)</td>
					<td> </td>
					<td> 00:13:00</td>
				</tr>
								<tr>
					<td colspan="4">Advanced VBA Prepaid Expenses Amortisation Model</td>
				</tr>
								<tr>
					<td></td>
					<td>Changing Macros Security in Excel</td>
					<td> </td>
					<td> 00:05:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Complete Walkthrough - Advanced VBA Prepaid Expenses Amortisation Model</td>
					<td> </td>
					<td> 00:06:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Bonus : New Version - Excel VBA Model for Prepayment Expenditure</td>
					<td> </td>
					<td> 00:08:00</td>
				</tr>
								<tr>
					<td colspan="4">BONUS: Dynamic Dashboard for Divisional Profit and Loss statements: Easy Way</td>
				</tr>
								<tr>
					<td></td>
					<td>Dynamic Dashboard Overview</td>
					<td> </td>
					<td> 00:07:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Importing Profit and Loss Statements Source Files and creating YTD P&amp;L Sheets</td>
					<td> </td>
					<td> 00:08:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Creating Dynamic Data Validation</td>
					<td> </td>
					<td> 00:02:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Creating Named Ranges for Dynamic Table Arrays</td>
					<td> </td>
					<td> 00:03:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Dynamic Date Column Headings for each Divisional PL Table</td>
					<td> </td>
					<td> 00:02:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Dynamic Month and YTD Dashboard tables headings (PRO TIP)</td>
					<td> </td>
					<td> 00:03:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Dynamic VLOOKUP Formula - Preparing First section of the Dashboard</td>
					<td> </td>
					<td> 00:04:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Creating Rolling Dashboard with Dynamic VLOOKUP Function</td>
					<td> </td>
					<td> 00:08:00</td>
				</tr>
								<tr>
					<td></td>
					<td>IMPORTANT : Error Checking for your reports/Dashboard (PRO TIP)</td>
					<td> </td>
					<td> 00:03:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Data Prep for Visualization: AREA Charts (Awesome trick using #NA Function)</td>
					<td> </td>
					<td> 00:05:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Visualization: AREA Charts for Month - Revenue, Gross Profit and Net Profit</td>
					<td> </td>
					<td> 00:05:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Visualization DONUT Charts Revenue, Gross Profit and Net Profit (Part 1)</td>
					<td> </td>
					<td> 00:03:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Visualization DONUT Charts Revenue, Gross Profit and Net Profit (Part 2)</td>
					<td> </td>
					<td> 00:06:00</td>
				</tr>
								<tr>
					<td colspan="4">Power Query &amp; Pivot Tables based Dashboard without any Formulas, Fully Dynamic</td>
				</tr>
								<tr>
					<td></td>
					<td>Introduction - Formula-less Dashboard - Fully Dynamic and easily refreshed</td>
					<td> </td>
					<td> 00:05:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Understanding the data files before building dashboard</td>
					<td> </td>
					<td> 00:02:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Consolidating Reports with Power Query (Get &amp; Transform) , How to install PQ</td>
					<td> </td>
					<td> 00:08:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Dynamic File Path Trick in Power Query with Parameters (Amazing trick)</td>
					<td> </td>
					<td> 00:06:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Conditional Cumulative totals with SUMIFS Function</td>
					<td> </td>
					<td> 00:04:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Bonus: Conditional Cumulative totals with Power Query Custom Formula (M Code)</td>
					<td> </td>
					<td> 00:06:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Dashboard Creation - Pivot Table showing Month and YTD KPIs division wise</td>
					<td> </td>
					<td> 00:06:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Dashboard Creation Donuts Charts linked with Pivot Table (Replicate Charts fast)</td>
					<td> </td>
					<td> 00:08:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Dashboard Creation - Line Charts</td>
					<td> </td>
					<td> 00:08:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Update Dashboard with Additional Divisional Data with Few Click (Magical)</td>
					<td> </td>
					<td> 00:03:00</td>
				</tr>
								<tr>
					<td colspan="4">Thankyou</td>
				</tr>
								<tr>
					<td></td>
					<td>Thank you</td>
					<td> </td>
					<td> 00:02:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Ultimate Prepaid Expenditure Model (Super Bonus)</td>
					<td> </td>
					<td> 00:02:00</td>
				</tr>
								<tr>
					<td colspan="4">Resources</td>
				</tr>
								<tr>
					<td></td>
					<td>Resources - Microsoft Excel: Automated Dashboard Using Advanced Formula, VBA, Power Query</td>
					<td> </td>
					<td> 00:00:00</td>
				</tr>
								<tr>
					<td colspan="4">Certificate and Transcript</td>
				</tr>
								<tr>
					<td></td>
					<td>Order Your Certificates and Transcripts</td>
					<td> </td>
					<td> 00:00:00</td>
				</tr>
				</tbody></table>

Financial Modelling & Analysis

Finance Cert & Exam Prep

Financial Modelling

Excel Analytics

Microsoft Excel

Advanced Excel Models using Formulas, VBA & Power Query

This official BRCGS course enables participants with an in-depth understanding of the Standard in terms of the protocol, requirements and how to audit effectively. Participants will gain competency to assess compliance to the requirements of the Standard, including fundamental clauses, statements of intent, how to undertake a BRCGS audit, planning of the audit and reporting of the audit. Auditing fundamentals and techniques will be discussed including the auditor competency skills required of auditors auditing against Global Food Safety Initiative (GFSI) recognised certification programmes.Active learning will be used throughout the course utilising case study-based activities to encourage critical thinking and help explain how auditors with audit against the Standard. &nbsp;Participants must have a working knowledge of quality management systems and auditing within the relevant manufacturing sector, and have completed a hazard analysis and critical control points (HACCP) course of at least two days&#39; duration.In preparation for the course, participants must read and review a copy of the Standard including the glossary, which is available as a free download from the <a href="https://www.brcgs.com/store/" target="_blank" rel="noreferrer noopener" style="color: inherit; -webkit-user-select: auto; font-size: var(--font-size); box-sizing: border-box; cursor: pointer; text-decoration: inherit;" fr-original-style=" color: inherit;">BRCGS Store</a>, in addition to the pre-course materials provided.&nbsp;At the end of the course you will be assessed with an exam. Successful completion of this course, including the exam, forms part of the training necessary to become a BRCGS auditor. The steps necessary to complete your training must be arranged with a BRCGS-approved certification body.This course is part of the<a href="http://demo-brcgs.wearesigma.com/training/brcgs-professional/about-the-programme/" style="color: rgb(234, 118, 0); -webkit-user-select: auto; font-size: var(--font-size); box-sizing: border-box; cursor: pointer; text-decoration: inherit;" fr-original-style=" color: rgb(234, 118, 0);">&nbsp;BRCGS Professional recognition programme</a>.At the end of the course participants will be able to:&nbsp;<ul style="color: rgb(var(--color_25)); box-sizing: border-box;" fr-original-style=" color: rgb(var(--color_25));"><li fr-original-style="" style="box-sizing: border-box;">Explain the steps to managing an audit programme</li><li fr-original-style="" style="box-sizing: border-box;">Describe auditing fundamentals and techniques</li><li fr-original-style="" style="box-sizing: border-box;">Assess compliance to the requirements of the Standard and explain how compliance can be demonstrated to maintain food safety, quality, legality, and authenticity</li><li fr-original-style="" style="box-sizing: border-box;">Describe the scope of companies and products covered by the Standard</li><li fr-original-style="" style="box-sizing: border-box;">Describe steps to conduct a BRCGS audit including the preparation, planning, and reporting of the audit</li><li fr-original-style="" style="box-sizing: border-box;">Utilise and explain resource tools available for compliance and beneficial support from BRCGS</li></ul>

This official BRCGS course enables participants with an in-depth understanding of the Standard in terms of the protocol, requirements and how to audit effectively. Participants will gain competency to assess compliance to the requirements of the Standard, including fundamental clauses, statements of intent, how to undertake a BRCGS audit, planning of the audit and reporting of the audit. Auditing fundamentals and techniques will be discussed including the auditor competency skills required of auditors auditing against Global Food Safety Initiative (GFSI) recognised certification programmes.
Active learning will be used throughout the course utilising case study-based activities to encourage critical thinking and help explain how auditors with audit against the Standard. Participants must have a working knowledge of quality management systems and auditing within the relevant manufacturing sector, and have completed a hazard analysis and critical control points (HACCP) course of at least two days' duration.
In preparation for the course, participants must read and review a copy of the Standard including the glossary, which is available as a free download from the BRCGS Store, in addition to the pre-course materials provided. 
At the end of the course you will be assessed with an exam. Successful completion of this course, including the exam, forms part of the training necessary to become a BRCGS auditor. The steps necessary to complete your training must be arranged with a BRCGS-approved certification body.
This course is part of theBRCGS Professional recognition programme.
At the end of the course participants will be able to: 
Explain the steps to managing an audit programme
Describe auditing fundamentals and techniques
Assess compliance to the requirements of the Standard and explain how compliance can be demonstrated to maintain food safety, quality, legality, and authenticity
Describe the scope of companies and products covered by the Standard
Describe steps to conduct a BRCGS audit including the preparation, planning, and reporting of the audit
Utilise and explain resource tools available for compliance and beneficial support from BRCGS

Ask Sonia Limited

Food Safety

HACCP

Official BRCGS Food Safety Issue 9 Lead Auditor training course. 
Delivered online (Zoom) by a live BRCGS Approved Training Partner & Virtual Trainer.
Exam and Certificate fee included in the price.

BRCGS Food Safety Issue 9 - Lead Auditor (5 Days)

This official BRCGS course enables participants to develop a full understanding of the general principles of the requirements of the Standard and gain competency to assess compliance to the requirements of the Standard, including fundamental clauses, statements of intent, how to undertake a BRCGS audit, planning of the audit and reporting of the audit.Active learning will be used throughout the course utilising case study-based activities to encourage critical thinking and help explain how auditors will audit against the Standard. &nbsp;Participants must have a working knowledge of quality management systems and auditing within the relevant manufacturing sector, and have completed a hazard analysis and critical control points (HACCP) course of at least two days&#39; duration.In preparation for the course, participants must read and review a copy of the Standard including the glossary, which is available as a free download from the BRCGS Store, in addition to the pre-course materials provided.At the end of the course, participants will be assessed with an exam. For candidates who are already qualified as a Lead Auditor on another scheme (eg IRCA, SQF, IFS, etc) successful completion of this course, including the exam, is recognised as part of the training necessary to become a BRCGS auditor. The steps necessary to complete your training must be arranged with a BRCGS-approved certification body.This course is part of the<a href="http://demo-brcgs.wearesigma.com/training/brcgs-professional/about-the-programme/" style="color: rgb(234, 118, 0); -webkit-user-select: auto; font-size: var(--font-size); box-sizing: border-box; cursor: pointer; text-decoration: inherit;" fr-original-style=" color: rgb(234, 118, 0);">&nbsp;BRCGS Professional recognition programme</a>.At the end of the course participants will be able to:&nbsp;<ul style="color: rgb(var(--color_25)); box-sizing: border-box;" fr-original-style=" color: rgb(var(--color_25));"><li fr-original-style="" style="box-sizing: border-box;">Assess compliance to the requirements of the Standard and explain how compliance can be demonstrated to maintain food safety, quality, legality, and authenticity</li><li fr-original-style="" style="box-sizing: border-box;">Describe the scope of companies and products covered by the Standard</li><li fr-original-style="" style="box-sizing: border-box;">Describe steps to conduct a BRCGS audit including the preparation, planning, and reporting of the audit</li><li fr-original-style="" style="box-sizing: border-box;">Utilise and explain resource tools available for compliance and beneficial support from BRCGS</li></ul>

This official BRCGS course enables participants to develop a full understanding of the general principles of the requirements of the Standard and gain competency to assess compliance to the requirements of the Standard, including fundamental clauses, statements of intent, how to undertake a BRCGS audit, planning of the audit and reporting of the audit.
Active learning will be used throughout the course utilising case study-based activities to encourage critical thinking and help explain how auditors will audit against the Standard. Participants must have a working knowledge of quality management systems and auditing within the relevant manufacturing sector, and have completed a hazard analysis and critical control points (HACCP) course of at least two days' duration.
In preparation for the course, participants must read and review a copy of the Standard including the glossary, which is available as a free download from the BRCGS Store, in addition to the pre-course materials provided.
At the end of the course, participants will be assessed with an exam. For candidates who are already qualified as a Lead Auditor on another scheme (eg IRCA, SQF, IFS, etc) successful completion of this course, including the exam, is recognised as part of the training necessary to become a BRCGS auditor. The steps necessary to complete your training must be arranged with a BRCGS-approved certification body.
This course is part of theBRCGS Professional recognition programme.
At the end of the course participants will be able to: 
Assess compliance to the requirements of the Standard and explain how compliance can be demonstrated to maintain food safety, quality, legality, and authenticity
Describe the scope of companies and products covered by the Standard
Describe steps to conduct a BRCGS audit including the preparation, planning, and reporting of the audit
Utilise and explain resource tools available for compliance and beneficial support from BRCGS

Auditor

Official BRCGS Food Safety Issue 9 course. 
Delivered online (Zoom) by a live BRCGS Approved Training Partner.
Exam and Certificate fee included in the price.

BRCGS Food Safety Issue 9 - For Auditors (3 Days)

Manchester

Research Quality Association

Introduction to Computer Systems Validation

RQA Member

Non Member

<div id="course-pills-1">Duration3 Days18 CPD hoursThis course is intended forThe intended audience for this course is information security and IT professionals, such as network administrators and engineers, IT managers, and IT auditors, and other individuals who want to learn more about information security, who are interested in learning in-depth information about information security management, who are looking for career advancement in IT security, or who are interested in earning the CISM certification.OverviewEstablish and maintain a framework to provide assurance that information security strategies are aligned with business objectives and consistent with applicable laws and regulations. Identify and manage information security risks to achieve business objectives. Create a program to implement the information security strategy. Implement an information security program. Oversee and direct information security activities to execute the information security program. Plan, develop, and manage capabilities to detect, respond to, and recover from information security incidents.In this course, students will establish processes to ensure that information security measures align with established business needs.Prerequisites<li>Information security governance</li> <li>Information risk management</li> <li>Information security program development</li> <li>Information security program management</li> <li>Incident management and response</li></div><div id="course-pills-2"><h3>1 - Information Security Governance</h3> <ul> <li>Develop an Information Security Strategy</li> <li>Align Information Security Strategy with Corporate Governance</li> <li>Identify Legal and Regulatory Requirements</li> <li>Justify Investment in Information Security</li> <li>Identify Drivers Affecting the Organization</li> <li>Obtain Senior Management Commitment to Information Security</li> <li>Define Roles and Responsibilities for Information Security</li> <li>Establish Reporting and Communication Channels</li> </ul> <h3>2 - Information Risk Management</h3> <ul> <li>Implement an Information Risk Assessment Process</li> <li>Determine Information Asset Classification and Ownership</li> <li>Conduct Ongoing Threat and Vulnerability Evaluations</li> <li>Conduct Periodic BIAs</li> <li>Identify and Evaluate Risk Mitigation Strategies</li> <li>Integrate Risk Management into Business Life Cycle Processes</li> <li>Report Changes in Information Risk</li> </ul> <h3>3 - Information Security Program Development</h3> <ul> <li>Develop Plans to Implement an Information Security Strategy</li> <li>Security Technologies and Controls</li> <li>Specify Information Security Program Activities</li> <li>Coordinate Information Security Programs with Business Assurance Functions</li> <li>Identify Resources Needed for Information Security Program Implementation</li> <li>Develop Information Security Architectures</li> <li>Develop Information Security Policies</li> <li>Develop Information Security Awareness, Training, and Education Programs</li> <li>Develop Supporting Documentation for Information Security Policies</li> </ul> <h3>4 - Information Security Program Implementation</h3> <ul> <li>Integrate Information Security Requirements into Organizational Processes</li> <li>Integrate Information Security Controls into Contracts</li> <li>Create Information Security Program Evaluation Metrics</li> </ul> <h3>5 - Information Security Program Management</h3> <ul> <li>Manage Information Security Program Resources</li> <li>Enforce Policy and Standards Compliance</li> <li>Enforce Contractual Information Security Controls</li> <li>Enforce Information Security During Systems Development</li> <li>Maintain Information Security Within an Organization</li> <li>Provide Information Security Advice and Guidance</li> <li>Provide Information Security Awareness and Training</li> <li>Analyze the Effectiveness of Information Security Controls</li> <li>Resolve Noncompliance Issues</li> </ul> <h3>6 - Incident Management and Response</h3> <ul> <li>Develop an Information Security Incident Response Plan</li> <li>Establish an Escalation Process</li> <li>Develop a Communication Process</li> <li>Integrate an IRP</li> <li>Develop IRTs</li> <li>Test an IRP</li> <li>Manage Responses to Information Security Incidents</li> <li>Perform an Information Security Incident Investigation</li> <li>Conduct Post-Incident Reviews</li> </ul></div>

Certificate in Information Security Management Principles (CISMP)

Certified Information Security Manager (CISM)

Certified Cyber Professional (CCP)

Cissp

In January 2024 alone, reports were published about the SRA taking enforcement action against 3 firms and 4 individuals for failure to comply with the Money Laundering Regulations 2017. The fines issued for these non-compliances total over &pound;570,000 plus costs. The absence of staff training, or requirement to complete additional training, was noted in a number of these cases.Many of the breaches resulting in enforcement action involved failures by the fee earners to conduct appropriate due diligence, adequately check the source of funds and/or wealth or recognise and report red flags. As highlighted by enforcement action being taken against individuals as well as firms, fee earners cannot hide behind their firm when AML failures occur and may be held personally accountable by the SRA for non-compliances with the MLR 2017.This course will cover the following to assist fee earners in the application of AML in their casework.<ul fr-original-style="" style="box-sizing: border-box;"><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">How to comply with your obligations and stay compliant</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Written CRA &amp; MRA</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Client</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Booms</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Risks &ndash; what to consider?</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">PCPs &ndash; CDD &amp;EDD</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">POCA / TA</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">SOF and SOW</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">On going monitoring</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Reporting to MLRO/MLCO</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Tipping off</li></ul><h2 fr-original-style="" style="box-sizing: border-box;">Target Audience</h2>The online course is suitable for fee earners or legal practitioners that want to improve their AML knowledge.<h2 data-key="21" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">Resources</h2>Comprehensive and up to date course notes will be provided to all delegates which may be useful for ongoing reference or cascade training.<p data-key="30" data-slate-fragment="JTdCJTIyb2JqZWN0JTIyJTNBJTIyZG9jdW1lbnQlMjIlMkMlMjJkYXRhJTIyJTNBJTdCJTdEJTJDJTIybm9kZXMlMjIlM0ElNUIlN0IlMjJvYmplY3QlMjIlM0ElMjJibG9jayUyMiUyQyUyMnR5cGUlMjIlM0ElMjJoZWFkaW5nLXRocmVlJTIyJTJDJTIyZGF0YSUyMiUzQSU3QiUyMmNsYXNzTmFtZSUyMiUzQW51bGwlN0QlMkMlMjJub2RlcyUyMiUzQSU1QiU3QiUyMm9iamVjdCUyMiUzQSUyMnRleHQlMjIlMkMlMjJsZWF2ZXMlMjIlM0ElNUIlN0IlMjJvYmplY3QlMjIlM0ElMjJsZWFmJTIyJTJDJTIydGV4dCUyMiUzQSUyMkNvdXJzZSUyME5vdGVzJTIyJTJDJTIybWFya3MlMjIlM0ElNUIlNUQlN0QlNUQlN0QlNUQlN0QlMkMlN0IlMjJvYmplY3QlMjIlM0ElMjJibG9jayUyMiUyQyUyMnR5cGUlMjIlM0ElMjJwYXJhZ3JhcGglMjIlMkMlMjJkYXRhJTIyJTNBJTdCJTIyY2xhc3NOYW1lJTIyJTNBbnVsbCU3RCUyQyUyMm5vZGVzJTIyJTNBJTVCJTdCJTIyb2JqZWN0JTIyJTNBJTIydGV4dCUyMiUyQyUyMmxlYXZlcyUyMiUzQSU1QiU3QiUyMm9iamVjdCUyMiUzQSUyMmxlYWYlMjIlMkMlMjJ0ZXh0JTIyJTNBJTIyQ29tcHJlaGVuc2l2ZSUyMGFuZCUyMHVwJTIwdG8lMjBkYXRlJTIwY291cnNlJTIwbm90ZXMlMjB3aWxsJTIwYmUlMjBwcm92aWRlZCUyMHRvJTIwYWxsJTIwZGVsZWdhdGVzJTIwd2hpY2glMjBtYXklMjBiZSUyMHVzZWZ1bCUyMGZvciUyMG9uZ29pbmclMjByZWZlcmVuY2UlMjBvciUyMGNhc2NhZGUlMjB0cmFpbmluZy4lMjIlMkMlMjJtYXJrcyUyMiUzQSU1QiU1RCU3RCU1RCU3RCU1RCU3RCUyQyU3QiUyMm9iamVjdCUyMiUzQSUyMmJsb2NrJTIyJTJDJTIydHlwZSUyMiUzQSUyMnBhcmFncmFwaCUyMiUyQyUyMmRhdGElMjIlM0ElN0IlMjJjbGFzc05hbWUlMjIlM0FudWxsJTdEJTJDJTIybm9kZXMlMjIlM0ElNUIlN0IlMjJvYmplY3QlMjIlM0ElMjJ0ZXh0JTIyJTJDJTIybGVhdmVzJTIyJTNBJTVCJTdCJTIyb2JqZWN0JTIyJTNBJTIybGVhZiUyMiUyQyUyMnRleHQlMjIlM0ElMjJQbGVhc2UlMjBub3RlJTIwYSUyMHJlY29yZGluZyUyMG9mJTIwdGhlJTIwY291cnNlJTIwd2lsbCUyMCUyMiUyQyUyMm1hcmtzJTIyJTNBJTVCJTVEJTdEJTJDJTdCJTIyb2JqZWN0JTIyJTNBJTIybGVhZiUyMiUyQyUyMnRleHQlMjIlM0ElMjJub3QlMjAlMjIlMkMlMjJtYXJrcyUyMiUzQSU1QiU3QiUyMm9iamVjdCUyMiUzQSUyMm1hcmslMjIlMkMlMjJ0eXBlJTIyJTNBJTIyYm9sZCUyMiUyQyUyMmRhdGElMjIlM0ElN0IlN0QlN0QlNUQlN0QlMkMlN0IlMjJvYmplY3QlMjIlM0ElMjJsZWFmJTIyJTJDJTIydGV4dCUyMiUzQSUyMmJlJTIwbWFkZSUyMGF2YWlsYWJsZS4lMjIlMkMlMjJtYXJrcyUyMiUzQSU1QiU1RCU3RCU1RCU3RCU1RCU3RCU1RCU3RA==" style="color: rgb(0, 0, 0); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">Please note a recording of the course will&nbsp;not&nbsp;be made available.<h2 data-key="35" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">Speaker</h2><h3 style="color: rgb(0, 0, 0); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(0, 0, 0);"><a href="https://dglegal.co.uk/the-team/helen-torresi/" target="_blank" rel="noopener noreferrer" fr-original-style="" style="user-select: auto; font-size: var(--font-size); box-sizing: border-box; cursor: pointer; text-decoration: inherit;">Helen Torresi, Consultant, DG Legal</a></h3>Helen is a qualified solicitor with a diverse professional background spanning leadership roles in both the legal and tech/corporate sectors. Throughout her career, she has held key positions such as COLP, HOLP, MLCO, MLRO and DPO for law firms and various regulated businesses and services.Helen&rsquo;s specialised areas encompass AML, complaint and firm negligence handling, DPA compliance, file review and auditing, law management, and operational effectiveness in law firms, particularly in conveyancing (CQS).

In January 2024 alone, reports were published about the SRA taking enforcement action against 3 firms and 4 individuals for failure to comply with the Money Laundering Regulations 2017. The fines issued for these non-compliances total over £570,000 plus costs. The absence of staff training, or requirement to complete additional training, was noted in a number of these cases.
Many of the breaches resulting in enforcement action involved failures by the fee earners to conduct appropriate due diligence, adequately check the source of funds and/or wealth or recognise and report red flags. As highlighted by enforcement action being taken against individuals as well as firms, fee earners cannot hide behind their firm when AML failures occur and may be held personally accountable by the SRA for non-compliances with the MLR 2017.
This course will cover the following to assist fee earners in the application of AML in their casework.
How to comply with your obligations and stay compliant
Written CRA & MRA
Client
Booms
Risks – what to consider?
PCPs – CDD &EDD
POCA / TA
SOF and SOW
On going monitoring
Reporting to MLRO/MLCO
Tipping off
Target Audience
The online course is suitable for fee earners or legal practitioners that want to improve their AML knowledge.
Resources
Comprehensive and up to date course notes will be provided to all delegates which may be useful for ongoing reference or cascade training.
Please note a recording of the course will not be made available.
Speaker
Helen Torresi, Consultant, DG Legal
Helen is a qualified solicitor with a diverse professional background spanning leadership roles in both the legal and tech/corporate sectors. Throughout her career, she has held key positions such as COLP, HOLP, MLCO, MLRO and DPO for law firms and various regulated businesses and services.
Helen’s specialised areas encompass AML, complaint and firm negligence handling, DPA compliance, file review and auditing, law management, and operational effectiveness in law firms, particularly in conveyancing (CQS).

DG Legal

Anti-Money Laundering (AML)

Anti-Money Laundering (AML) Training For Fee Earners Course

General Delegate

A discount is available for delegates attending from firms with a current retainer contract with DG Legal (please contact us by email to admin@dglegal.co.uk for confirmation of eligibility).   If you choose this option and are not eligible, you are still bound to pay the full rate and will be invoiced accordingly.

Retainer Delegate

<div id="course-pills-1">Duration2 Days12 CPD hoursThis course is intended forThe audience for this course is anyone who wants to acquire foundation level knowledge on data centre infrastructure. This course is ideally suited for data centre new hires, internal data centre support staff, IT support staff who work in the data centre, helpdesk staff, vendors/suppliers who install/maintain data centre equipment, building maintenance staff including data centre cleaners and other supporting functions, and fresh graduates. This course is also well suited for individuals working in data centre business support functions such as sales/pre-sales, HR, Finance and business administration.OverviewThe DCFC course will prepare participants for entry into the exciting and high-growth data centre industry. It will ensure that participants acquire the required basic knowledge to take on a wide variety of jobs in the data centre industry. It will also provide the required knowledge and skill to further their training into specialised areas on data centre design/build, operations/governance or standards/compliance.The Data Centre Foundation Certificate (DCFCÂ©) is a 2-day course designed to deliver foundation knowledge about data centre facilities infrastructure. It provides participants with global overview and knowledge on data centres which will be of advantage to the participants who are looking at joining the ranks of professionals working in the data centre, ICT, infrastructure or the mechanical and electrical (M&amp;E) design industries. It will also form a solid foundation for participants who wish to pursue his/her studies either academically or to further his/her industry specialisation with professional certification courses on data centre design/build, operations/governance and/or standards/compliance. With the tremendous growth of data and the data centres to support it, the demand for data centre professionals will grow in tandem.</div><div id="course-pills-2"><h4>Introduction to Data Centres</h4><ul><li>History of data centres</li><li>Definition of different type data centres</li></ul><h4>Data Centre Standards</h4><ul><li>List of standards</li><li>Rating definitions</li></ul><h4>Data Centre Facilities Areas</h4><ul><li>Listing of all areas and their functions</li></ul><h4>Topology Designs</h4><ul><li>Definition of Ratings</li></ul><h4>Components of the Power Infrastructure</h4><ul><li>Utility power</li><li>Transformers</li><li>Generators</li><li>Fuel systems</li><li>ATS</li><li>UPS systems</li><li>Batteries</li><li>Electric panels</li><li>Cabling/busbar systems</li><li>Power rails/strips</li></ul><h4>Lights</h4><ul><li>Lights</li><li>Emergency lights</li></ul><h4>Cooling Infrastructure</h4><ul><li>Chillers</li><li>DX Systems</li><li>Evaporators</li><li>CRAC/CRAU/HVAC</li><li>Raised floor</li><li>Non-raised floor</li><li>Containment</li></ul><h4>ICT/Network Infrastructure</h4><ul><li>Equipment racks</li><li>Network cabling (fibre, copper)</li><li>Cable trays and pathways</li><li>TIA-606 labelling</li></ul><h4>Data Centre Security</h4><ul><li>Perimeter security</li><li>Physical protection</li><li>CCTV</li><li>Access control</li><li>Security management</li></ul><h4>Fire Suppression</h4><ul><li>Detection systems</li><li>Suppression systems</li><li>Prevention systems</li><li>Fire extinguishers</li><li>Fire Safety</li></ul><h4>Monitoring and reporting</h4><ul><li>DCIM</li><li>EMS/BMS</li></ul></div>

Design & Technology Courses (DT)

Certified in Data Protection (CDP)

Data Centre Foundation Certificate (DCFC)

Slough

Milton Keynes 

Birmingham

Bedford

Liverpool 

NATIONALLY RECOGNISED AND ACCREDITED
LEVEL FOUR CERTIFICATE



This course comprises two parts:
 
Part 1 - online (eLearning)

AND

Part 2 - classroom

Part 2 consolidates on Parts 1 and delivers one full day of practical sessions (skill-set development) - PRP Harvesting and Treatment


Award:
Open College Network (OCN Credit4Learning) - Collegen Induction Therapy - PRP Treatment
LEVEL 4 (FDSc)



A modular "hybrid" course - eLearning (online) theory and one full day classroom based course.
 
PART 1 - THEORY ONLINE

Complete this part of your course online (eLearning Course) in the comfort of your own home or workplace.
Please allow 1-2 full days (approx. 12-16 hours in total) to complete this part of your course.
You do not need to complete this part of the course in one "sitting". Do as little or as much as you wish. Each time you log again exactly where you can start where you left off!
 
You must complete Part 1 before attending Part 2 below.
 
PART 2 - CLASSROOM
Attend in the classroom at the training location that you have selected.
Your classroom tutor will recap on the essential parts of your online course after which you will begin your practical sessions learning and developing the skills required to harvest and use Platelet-Rich Plasma in your treatment plan.
Please make sure you verify the precise dates and timings of your course when you receive your booking confirmation, as it may vary from the information provided above.


Course Itinerary


A hybrid modular course awarding:
OCN Accredited Level Three Certificate (Advanced Level) 3 credits AND

GEOPACE Certificate (Collagen Induction Therapy - PRP Treatment)



Parts 1 (A & B) - online (eLearning) +

Part 2 - PRP Harvesting, Preparation & Treatment (one day)


Theory Sessions:


M01 – Course Overview
Learning outcomes, Understanding recommended guidelines (CPSA, HEE, NICE & WHO), Core Competencies (Domains 1, 2 & 3). National Occupational Standards


M02 – Qualifications – Levels & Thresholds
Understanding the range and applications of treatments at Levels 1 to 8. Equivalencies. Looking at each level and specific treatment types. Competencies at Level 4.


M03 – Culture & Diversity
Understanding culture and diversity within the context of a salon, including opportunities and challenges for aesthetic therapists. Diversity and inclusion. Principles of diversity.


M04 – History, Definitions and Roles
The origins of microneedling and development of PRP, evolution of treatments, types of equipment and range of applications. Historical perspective and modern day examples of PRP therapies.


M05 – Health & Safety & IPC
H&S legislation, Standard Precautions (for blood borne pathogens), Pathogen types, Personal Protective Equipment (PPE), Handwashing and Hygiene, Hazardous Waste Disposal (non-specific), Preventing Needlestick Injuries. A detailed look at viruses, bacteria and fungi. Handling clients with infectious conditions and infestations. Transmission modes. Sterilisation processes in the workplace, including autoclaves.


M06 – Regulatory Obligations
Pathways – employed, contracted and self-employed, Management of H&S at work, Local and national government laws and bylaws, DBS types, Record Keeping, Hazardous Waste Disposal (specific), Insurance and insurance types, Accident reporting, The Keogh Review, HEE guidelines, Professional bodies.


M07 – Professionalism & Effective Communication
Presenting a professional image, guidelines and recommendations. How to effectively communicate with your clients and colleagues, communication methods, communicating efficiently in consultation.


M08 – Consent
Understanding consent types and your client’s capacity to consent. The importance of valid consent. Consent frequency. Risk assessment. Storing consent documentation – looking at paper and digital/cloud. Consent and the law. Determining if consent is robust.


M09 – Environmental and Sustainable Work Practices
Sustainability in the workplace. Running an efficient salon (water efficiency, waste reduction, interior fittings). Advancements including digital options (clients and suppliers).


M10 – Anatomy & Physiology
A&P for collagen induction therapy. Veins, arteries and capillaries (phlebotomy overview). The integumentary system – structure and function. Microneedling – depths and penetration. The lymphatic system. The circulatory system. Skin as a defence barrier. Skin – functions and layers. Merkel cells, Langerhans Cells, Keratinocytes and Melanocytes. The epidermal-melanin unit. Fibroblasts and connective tissue. The effects of ageing. Skin changes over time. Skin rejuvenation including optimising cell function and increasing natural collagen. Inducing regenerative healing. The Fitzpatrick Scale. A detailed look at cell function, specifically melanocytes, keratinocytes and fibroblasts. Microneedling the skin, effects and collagen response. Wound healing – stages (haemostasis, inflammatory, proliferative and maturation). Collagen Induction Therapy (CIT). Topical applications to improve keratinocyte function. Topical applications to improve collagen synthesis.


M11 – Patient Management – Consultation & Examination
Pre-treatment and treatment consultations. Client Motives. Educating your client. Developing a consultation plan. Medical Records. Contraindications & Precautions – Relative and Absolute Contraindications in microneedling. Microneedling and anticoagulants. Side effects and treatment failure. Photo-documentation. Looking at and recording a detailed medical history. Client reviews. Health risks. Legalities.


M12 – Record Keeping
Key points and importance. Understanding how to retain records. Claims - Date of Discovery and Date of Knowledge.


M13 – Platelet Rich Plasma (PRP) – Understanding the basics
Whole blood – composition. Platelets and growth factors (types and functions). What are platelets? Understanding platelet modes of action. Platelet Rich Plasma – preparation. PPP and PRP. PRP Activation and collagen response in vivo. Fibrin network formation. Dermal needle puncture - repair pathway. Examples of microneedling applications. Needle depths and facial skin thickness. Types of treatments – a case by case examination.


M14 – Platelet Rich Plasma (PRP) – Harvesting and Preparation
Phlebotomy. Using correct needle size and anticoagulant. Understanding autologous treatment types with PRP. The treatment agent pathway. Whole blood processing. Harvesting good quality PRP - step by step procedure. Using a centrifuge. Centrifuge operation and management. Steps to minimise platelet trauma. First and second centrifuge processes. Understanding how a centrifuge works? Managing breakage and spillage.


M15 – PRP Treatment – putting it all together!
Client arrival, management, documentation, photography, examination, consultation, consent, treatment plan. Patient ID, where necessary. Referrals and when to refer. Seeking expert advice. Employment types – employed (PAYE), contracted, self-employed (freelance) - detailed look at each. Managing equipment and consumables. Compliancy. Pre-treatment guidance. Medications and drug conflicts. Preparing a treatment area. Preparing your client. Disinfecting the face. Applying numbing cream. Phlebotomy procedures.
Blood handling. Dermapen types and accessories. Treatment modes and actions. Selecting the correct needle depth. Applying PRP and microneedling. Managing pen depth and skin areas. Working within facial zones. Post treatment management. Waste management and correct waste disposal. Post treatment client management. Aftercare. Managing adverse effects. Managing post treatment client expectations. Treatment intervals. Post treatment checklists and patient aftercare guidelines.


Classroom Practical Sessions:
Practical Session 1: Equipment familiarisation - hands-on approach
Practical Session 2: Completing medical forms and consent forms
Practical Session 3: Preparing a treatment area
Practical Session 4: Using a centrifuge
Practical Session 5: Performing a microneedling facial treatment with PRP - model 1
Practical Session 6: Performing a microneedling facial treatment with PRP - model 2


Classroom Support Material:
Support material to complement Modules 1 – 15


Online Support Material:
Downloadable pdf files - support material to complement Modules 1 - 15
Demonstration Video



Geopace Training

Medical Aesthetics

Allied Health

Platelet-rich plasma (PRP)

Aesthetics

Aesthetic Practitioner

Facial Aesthetics

Platelet-rich Plasma (PRP) treatments

    Nationally Recognised Qualification

    No previous experience or qualifications needed

    Open College Network Accreditation

    Level 4 (as required for minimally invasive procedures)

    Covers standards set by HEE

    Employed (salon) or Self-Employed opportunities

    Basic understanding of English language required

    OPEN TO ALL APPLICANTS


PRP - Collagen Induction Therapy Course (GPT701)

This course will cover Advanced concepts in DAX, Data Modeling, Power BI architectural design, and more. It is a unique blend of data modeling, data analysis, data presentation, and visualization skills. &nbsp;This instructor-led course includes:&nbsp;&bull; &nbsp; &nbsp;2 weeks of self-paced essential learning content that you are to complete before the instructor-led live virtual sessions begin&nbsp;&bull; &nbsp; &nbsp;6 instructor-led virtual sessions of 2 hours each. Each Session will have a 15-minute break.&nbsp;&bull; &nbsp; &nbsp;Intersession Assignments that you are expected to complete and discuss in your preassigned groups during the session.&nbsp;&bull; &nbsp; &nbsp;1 Capstone Project&nbsp;&bull; &nbsp; &nbsp;Lifetime access to our LMS where you will have free access to the trainer, other participants, and resources including knowledge videos.&nbsp;&bull; &nbsp; &nbsp;Access to our community of life-long learners.&nbsp;&bull; &nbsp; &nbsp;Downloadable Certificate you can link to your LinkedIn page&nbsp;We look forward to seeing you in Class!!!

dbrownconsulting

Business Analytics & Intelligence

Microsoft Power BI

Data Analysis Expressions

Learn advanced concepts in DAX, Data Modeling, Power BI architectural design, and more.

Advanced Reporting & Analytics with Power BI

<div id="course-pills-1">Duration5 Days30 CPD hoursThis course is intended forThis course is intended for IT professionals who are responsible for planning, configuring, and managing an Office 365 environment. Students who attend this course are expected to have a fairly broad understanding of several on-premises technologies such as Domain Name System (DNS) and Active Directory Domain Services (AD DS). In addition, they should have a general understanding of Microsoft Exchange Server, Microsoft Teams, and Microsoft SharePoint.OverviewPlan and provision Office 365 Manage Users and Groups in Office 365 Deploy and Configure Tools and Applications for Office 365 Plan and Manage Exchange Online Plan and Manage SharePoint Online Plan and Manage Microsoft Teams Plan and Manage other Office 365 Services Implement Security and Compliance in Office 365 Report, Monitor and Troubleshoot Office 365This five-day course describes how to set up, configure and manage an Office 365 tenant including identities, and the core services of Microsoft 365. In this five-day course, you will learn how to plan the configuration of an Office 365 tenant including integration with existing user identities; plan, configure and manage core services; and report on key metrics. Although this course and the associated labs are written for Office 365 with Windows 11, the skills taught will also be backwards compatible with Windows 10. This course is based on the features available in the Office 365 E3 license as these are the core features in Office 365 and Microsoft 365 plans.</div><div id="course-pills-2"><h3>1 - Planning and Provisioning Office 365</h3> <ul> <li>Overview of Office 365</li> <li>Core Services of Office 365</li> <li>Requirements for an Office 365 Tenant</li> <li>Planning a Pilot and Deployment</li> <li>Creating an Office 365 Tenant</li> <li>Adding Custom Domains and Managing DNS Settings</li> <li>Lab: Provisioning Office 365</li> </ul> <h3>2 - Managing Users and Groups in Office 365</h3> <ul> <li>Managing User Accounts and Licences</li> <li>Managing Passwords and Authentication</li> <li>Create and Managing the Different Types of Groups in Office 365</li> <li>Managing Users and Groups with PowerShell</li> <li>Managing Users and Groups in the Azure AD Admin Center</li> <li>Role Based Access and Administrative Roles</li> <li>Planning and Configuring Directory Synchronization</li> <li>Lab: Managing Users and Groups in Office 365</li> <li>Lab: Planning and Configuring Directory Synchronisation</li> </ul> <h3>3 - Deploying and Configuring Tools and Applications for Office 365</h3> <ul> <li>Planning Network Configuration for Office 365 Tools and Applications</li> <li>Using the Office Configuration Tool</li> <li>Click to Run Installation Use and Control</li> <li>Managing Centralized Deployment of Tools, Applications and Add-ins</li> <li>Reporting</li> <li>Lab: Deploying and Configuring Tools and Applications for Office 365</li> </ul> <h3>4 - Planning and Managing Exchange Online</h3> <ul> <li>What is Exchange Online</li> <li>Managing Exchange Online Mailboxes</li> <li>Managing Office 365 Groups in Exchange Online</li> <li>Configuring Exchange Online Permissions</li> <li>Managing Exchange Online using PowerShell</li> <li>Plan and Configure Mail Flow</li> <li>Plan and Configure Email Protection</li> <li>Lab: Planning and Managing Exchange Online</li> </ul> <h3>5 - Planning and Managing SharePoint Online</h3> <ul> <li>What is SharePoint Online</li> <li>Understanding the relationship between SharePoint, OneDrive, Teams, and Office 365 Groups</li> <li>SharePoint Online Architecture</li> <li>Configure SharePoint Online</li> <li>Configure and Control External Sharing</li> <li>Managing SharePoint Online Site Collections</li> <li>Managing SharePoint Online using PowerShell</li> <li>Lab: Planning and Managing SharePoint Online</li> </ul> <h3>6 - Planning and Managing Microsoft Teams</h3> <ul> <li>What is Microsoft Teams</li> <li>How Microsoft Teams integrates with other Office 365 Services</li> <li>Create and Manage Organization Wide Settings</li> <li>Create, Manage and Assign Microsoft Teams Policies</li> <li>Plan and Configure External and Guest Access</li> <li>Managing Microsoft Teams using PowerShell</li> <li>Lab: Planning and Managing Microsoft Teams</li> </ul> <h3>7 - Planning and Managing Other Office 365 Services</h3> <ul> <li>Yammer</li> <li>Planner</li> <li>Visio</li> <li>Bookings</li> <li>Delve</li> <li>Forms</li> <li>Power Platform</li> <li>Stream</li> <li>Sway</li> <li>Viva</li> <li>Scheduler</li> <li>Add-ins, including Find Time and Junk Reporter</li> <li>Lab: Planning and Managing Office 365 Services</li> </ul> <h3>8 - Security and Compliance in Office 365</h3> <ul> <li>Overview of Security and Compliance Features in Office 365</li> <li>Extending Security and compliance Features with Additional Licences</li> <li>Using the Microsoft Defender Portal and Secure Score</li> <li>Using the Office 365 Compliance Portal and Compliance Score</li> <li>Plan and Configure Retention Labels and Policies</li> <li>Plan and Configure Data Loss Prevention Policies</li> <li>Create and Assign Sensitivity Labels</li> <li>Configure Safe Attachments and Safe Links Policies</li> <li>Plan and Configure Multi Factor Authentication</li> <li>Lab: Configure Security and Compliance in Office 365</li> </ul> <h3>9 - Reporting, Monitoring and Troubleshooting Office 365</h3> <ul> <li>Monitoring Office 365 Service Health</li> <li>Troubleshooting Administrative Access in Office 365</li> <li>Troubleshoot Directory Synchronization</li> <li>Troubleshooting Exchange Online</li> <li>Troubleshooting SharePoint Online</li> <li>Troubleshooting Microsoft Teams</li> <li>Troubleshooting Office 365 Security and Compliance</li> <li>Lab: Reporting, Monitoring and Troubleshooting in Office 365</li> </ul></div>

Microsoft 365

55354 Administering Office 365

Grantham

CILT HGV Transport Manager Refresher / OLAT 2 Day Course Online
Our OLAT & Transport Manager Courses are CILT (Chartered Institute of Logistics and Transport) accredited and so they are one of the courses recommended by the Traffic Commissioner, and they are also FORS Approved Manager Training.
If you are in contact with the Traffic Commissioner for any reason, especially if you have applied to be transport manager for an organisation, you are strongly advised to attend a 2-day course, which is often recommended by the Traffic Commissioner as the most appropriate.
This course will cover the following areas:
•Background to the Operator’s Licence
•Compliance enforcement
•Working time & driver’s hours
•Vehicle roadworthiness and defect reporting
•Construction and use requirements
•Driver licences/driver CPC
•Speed limits
•Environmental considerations
On completion of this course, you will be able to:
•Recount the requirement to obtain and maintain an operator licence.
•Demonstrate how and why driver hours legislation are crucial to safety and compliance to the undertaking.
•State the responsibilities of management and drivers have regarding vehicle roadworthiness and defect reporting.
•Identify the requirements of driver licence/DQC checks.
•Demonstrate an awareness of sector legislative awareness, safe fleet operation and environmental requirements.
Our online courses work in the same way that our classroom courses do, but they are completed via the online platform called Zoom. The course can be completed on any device that the Zoom app can be used on, such as a PC, laptop, tablet or smart phone.
Completion of the remote learning course will gain you the same accreditation as completion of the face-to-face training course.
Secure your spot today by booking your ticket through Cademy or contacting us at 0345 9001312 and complete the online booking form. These details will be used to produce a registration document and provide you with a course certificate on successful completion of the course. Once registered, your booking will be complete, and a member of the team will contact you.
Login details will be given 48 hours prior to the course starting.
This is a two-day course, the start time is 8am each day.
Course cost includes 2-day training £411 (£280 course fee, CILT certification fee £75) plus VAT. 

2743 Courses

Microsoft Access 2016 Beginner to Advanced

By Studyhub UK

VMCE95-Veeam Certified Engineer

By Nexus Human

Cisco Multicloud Cost Optimization with Cisco CloudCenter Suite (CLDCO)

By Nexus Human

Cisco Configuring Cisco MDS 9000 Series Switches v3.5 (DCMDS)

By Nexus Human

Get Started with QuickBooks Online 2021-2022

By Nexus Human

SAS Programming 1 - Essentials

By Nexus Human

C)DFE - Certified Digital Forensics Examiner Mile 2

By Nexus Human

VEEAM-VMCE Veeam Certified Engineer

By Nexus Human

Diploma in SEO and Digital Marketing

By John Academy

Advanced Excel Models using Formulas, VBA & Power Query

By John Academy

Search By Location