Name: Microsoft PowerPoint 2016/2019/365 - Foundations for Beginners
Price: 19 GBP
Availability: InStock

<div>
 <div>
 <h2>
 Recognised Accreditation
 </h2>
 This course is accredited by continuing professional development (CPD). CPD UK is globally
 recognised by employers, professional organisations, and academic institutions, thus a
 certificate from CPD Certification Service creates value towards your professional goal
 and achievement.

 

 The Quality Licence Scheme is a brand of the Skills and Education Group, a leading national awarding organisation for providing high-quality vocational qualifications across a wide range of industries.
 
 </div>
 <div>
 <div>
 <div>
 
 <h3>What is CPD?</h3>
 Employers, professional organisations, and academic institutions all recognise CPD,
 therefore a credential from CPD Certification Service adds value to your professional
 goals and achievements.
 <h4>Benefits of CPD</h4>
 <ul>
 <li>Improve your employment prospects </li>
 <li>Boost your job satisfaction </li>
 <li>Promotes career advancement </li>
 <li>Enhances your CV </li>
 <li>Provides you with a competitive edge in the job market </li>
 <li>Demonstrate your dedication </li>
 <li>Showcases your professional capabilities</li>
 </ul>
 </div>
 </div>
 <div>
 <div>
 
 <h3>What is IPHM? </h3>
 The IPHM is an Accreditation Board that provides Training Providers with international
 and global accreditation. The Practitioners of Holistic Medicine (IPHM) accreditation
 is a guarantee of quality and skill. 
 <h4>Benefits of IPHM </h4>
 <ul>
 <li>It will help you establish a positive reputation in your chosen field </li>
 <li>You can join a network and community of successful therapists that are dedicated to
 providing excellent care to their client </li>
 <li>You can flaunt this accreditation in your CV </li>
 <li>It is a worldwide recognised accreditation </li>
 </ul>
 </div>
 </div>
 <div>
 <div>
 
 <h3>What is Quality Licence Scheme?</h3>
 This course is endorsed by the Quality Licence Scheme for its high-quality,
 non-regulated provision and training programmes. The Quality Licence Scheme is a brand
 of the Skills and Education Group, a leading national awarding organisation for
 providing high-quality vocational qualifications across a wide range of industries.
 <h4> Benefits of Quality License Scheme </h4>
 <ul>
 <li>Certificate is valuable</li>
 <li>Provides a competitive edge in your career</li>
 <li>It will make your CV stand out</li>
 </ul>
 </div>
 </div>
 </div>
 </div><div>
				
<h3>
	Course Curriculum
</h3>

<div>
<table>				<tbody><tr>
					<td colspan="4">Getting Data Ready for Regression Model</td>
				</tr>
								<tr>
					<td></td>
					<td>
						Transportation Problem in Excel using Goal Seek					</td>

					
					<td> </td>
					<td> 00:12:00</td>
				</tr>
								<tr>
					<td></td>
					<td>
						Gathering Business Knowledge					</td>

					
					<td> </td>
					<td> 00:03:00</td>
				</tr>
								<tr>
					<td></td>
					<td>
						Data Exploration					</td>

					
					<td> </td>
					<td> 00:03:00</td>
				</tr>
								<tr>
					<td></td>
					<td>
						The Data and the Data Dictionary					</td>

					
					<td> </td>
					<td> 00:07:00</td>
				</tr>
								<tr>
					<td></td>
					<td>
						Univariate analysis and EDD					</td>

					
					<td> </td>
					<td> 00:03:00</td>
				</tr>
								<tr>
					<td></td>
					<td>
						Discriptive Data Analytics in Excel					</td>

					
					<td> </td>
					<td> 00:10:00</td>
				</tr>
								<tr>
					<td></td>
					<td>
						Outlier Treatment					</td>

					
					<td> </td>
					<td> 00:04:00</td>
				</tr>
								<tr>
					<td></td>
					<td>
						Identifying and Treating Outliers in Excel					</td>

					
					<td> </td>
					<td> 00:04:00</td>
				</tr>
								<tr>
					<td></td>
					<td>
						Missing Value Imputation					</td>

					
					<td> </td>
					<td> 00:03:00</td>
				</tr>
								<tr>
					<td></td>
					<td>
						Identifying and Treating missing values in Excel					</td>

					
					<td> </td>
					<td> 00:04:00</td>
				</tr>
								<tr>
					<td></td>
					<td>
						Variable Transformation in Excel					</td>

					
					<td> </td>
					<td> 00:03:00</td>
				</tr>
								<tr>
					<td></td>
					<td>
						Dummy variable creation: Handling qualitative data					</td>

					
					<td> </td>
					<td> 00:04:00</td>
				</tr>
								<tr>
					<td></td>
					<td>
						Dummy Variable Creation in Excel					</td>

					
					<td> </td>
					<td> 00:07:00</td>
				</tr>
								<tr>
					<td></td>
					<td>
						Correlation Analysis					</td>

					
					<td> </td>
					<td> 00:09:00</td>
				</tr>
								<tr>
					<td></td>
					<td>
						Creating Correlation Matrix in Excel					</td>

					
					<td> </td>
					<td> 00:08:00</td>
				</tr>
								<tr>
					<td colspan="4">Creating Regression Model</td>
				</tr>
								<tr>
					<td></td>
					<td>
						The Problem Statement					</td>

					
					<td> </td>
					<td> 00:01:00</td>
				</tr>
								<tr>
					<td></td>
					<td>
						Basic Equations and Ordinary Least Squares (OLS) method					</td>

					
					<td> </td>
					<td> 00:08:00</td>
				</tr>
								<tr>
					<td></td>
					<td>
						Assessing accuracy of predicted coefficients					</td>

					
					<td> </td>
					<td> 00:14:00</td>
				</tr>
								<tr>
					<td></td>
					<td>
						Assessing Model Accuracy: RSE and R squared					</td>

					
					<td> </td>
					<td> 00:07:00</td>
				</tr>
								<tr>
					<td></td>
					<td>
						Creating Simple Linear Regression model					</td>

					
					<td> </td>
					<td> 00:02:00</td>
				</tr>
								<tr>
					<td></td>
					<td>
						Multiple Linear Regression					</td>

					
					<td> </td>
					<td> 00:05:00</td>
				</tr>
								<tr>
					<td></td>
					<td>
						The F - statistic					</td>

					
					<td> </td>
					<td> 00:08:00</td>
				</tr>
								<tr>
					<td></td>
					<td>
						Interpreting results of Categorical variables					</td>

					
					<td> </td>
					<td> 00:05:00</td>
				</tr>
								<tr>
					<td></td>
					<td>
						Creating Multiple Linear Regression model					</td>

					
					<td> </td>
					<td> 00:07:00</td>
				</tr>
								<tr>
					<td colspan="4">What-if analysis</td>
				</tr>
								<tr>
					<td></td>
					<td>
						Excel: Running Linear Regression using Solver					</td>

					
					<td> </td>
					<td> 00:08:00</td>
				</tr>
								<tr>
					<td colspan="4">Assessment</td>
				</tr>
								<tr>
					<td></td>
					<td>Assessment - Linear Regression Analysis In MS Excel</td>
					<td> </td>
					<td> 00:10:00</td>
				</tr>
								<tr>
					<td colspan="4">Certificate of Achievement</td>
				</tr>
								<tr>
					<td></td>
					<td>
						Certificate of Achievement					</td>

					
					<td> </td>
					<td> 00:00:00</td>
				</tr>
								<tr>
					<td colspan="4">Get Your Insurance Now</td>
				</tr>
								<tr>
					<td></td>
					<td>
						Get Your Insurance Now					</td>

					
					<td> </td>
					<td> 00:00:00</td>
				</tr>
								<tr>
					<td colspan="4">Feedback</td>
				</tr>
								<tr>
					<td></td>
					<td>
						Feedback					</td>

					
					<td> </td>
					<td> 00:00:00</td>
				</tr>
				</tbody></table></div>

			</div>

Study Plex

Linear Regression Analysis in Microsoft Excel

General Admission

Fill your knowledge gap with the most in-demand training on Bookkeeping (Bookkeeper Training).Your pocket-friendly compact learning pack! This course is suitable for any enthusiastic learner ready to take the Beginner to Advance learning trip of Bookkeeping (Bookkeeper Training). You will gain ultimate knowledge of Bookkeeping (Bookkeeper Training). Grab the opportunity and amplify your skills with this Bookkeeping (Bookkeeper Training) courseThe training package includes:<ul><li>Course 01: Professional Bookkeeping Course</li><li>Course 02: Excel for Bookkeeping</li></ul>Key Benefits<ul><li>QLS Endorsed</li><li>CPD QS accredited</li><li>Engaging Learning materials c</li><li>Study at your own pace</li><li>24/7 access</li><li>Full Tutor support</li></ul>Course 01: Professional Bookkeeping CourseThis comprehensive Professional Bookkeeping is designed to provide you a thorough understanding of basic accounting terms and transaction procedures. It will explain the distinction between Bookkeeping and Accounting. You will gain insights into how to handle your day-to-day tasks of recording financial transactions such as credit purchases, cash purchases, cash sales, and unrecorded expenses.The in-depth knowledge and skills you gain through the learning session will enable you to recognise your function as a Bookkeeper and perform all of your tasks to a high standard.Course 02: Excel for BookkeepingWithout having familiarity with Microsoft Excel, it becomes quite tough to be a skilled bookkeeping professional. If you desire to learn about the essential tools to perform various bookkeeping functions, including invoicing and performing calculations, then enrolling in this Excel for Bookkeeping course will exceedingly benefit you.Method of Assessment<ul><li>MCQ Based</li><li>60% Marks to Pass</li><li>Instant Feedback and Result</li></ul>Certificate<ul><li>QLS Endorsed Certificate</li><li>CPD Accredited Certificate available upon course completion (PDF + Hardcopy)</li></ul><h2>
 
 <div>CPD</div>
 </h2>

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

 <div id="who_is_this_course_for">
 This course is suitable for anyone interested in:<ul><li>Bookkeeping Diploma</li><li>Sage Bookkeeping</li><li>Foundation in Bookkeeping Diploma</li><li>Accounting &amp; bookkeeping</li></ul>
 </div><h2>
 
 <div>Requirements</div>
 </h2>

 <div id="requirements">
 There are no formal entry requirements for this course.
 </div><h2>
 
 <div>Career path</div>
 </h2>

 <div id="career_path">
 <ul><li>Bookkeeper</li><li>Bookkeeper Administrator</li><li>Mortgage Administrator</li><li>Office Administrator</li><li>Finance Assistant</li><li>Management Accountant</li></ul>
 </div><h2>
 
 <div>Certificates</div>
 </h2>

 <div id="optional_extras">
 <h4>Certificate of completion</h4>
 
 Digital certificate -
 £9
 
 <h4>Certificate of completion</h4>
 
 Hard copy certificate -
 £15
 
 <div> Shipping cost: £10 </div>

 </div>

One Education

Book-Keeping (Bookkeeper Training) Course

Are you looking for a way to improve your Microsoft Office skills? Then our Microsoft Office (Word, PowerPoint, Outlook, and Excel) Crash Course is for you! With our well-crafted modules, you'll be able to learn the ins and outs of Word, PowerPoint, Outlook, and Excel.Microsoft Office is a productivity suite consisting of Word, PowerPoint, Outlook, and Excel applications. It is typically used by businesses and organisations to manage daily operations. Whatever the reason, our Microsoft Office Crash Course will teach students the basics of each of the programs in the suite and help them feel more confident using these tools for work tasks.This Microsoft Office Crash Course will cover the basics of working with the most popular Microsoft Office applications, including Word, PowerPoint, Outlook, and Excel. We'll start with a tour of the Microsoft Office interface and some of the most commonly used features in each application. Then we'll move on to creating and editing documents in Word, building PowerPoint slides, working with email and the calendar in Outlook, and performing calculations and data analysis in Excel. By the end of this course, you'll have a better understanding of how to get the most out of Microsoft Office for your work or school projects.So what are you waiting for? Sign up today and start your journey to becoming a Microsoft Office pro!Learning OutcomesAt the end of this Microsoft Office Diploma course, you will be able to:<ul><li>Explore the interface in Microsoft Office applications</li><li>Create and format documents in Microsoft Word</li><li>Develop presentations in Microsoft PowerPoint</li><li>Manage your email and calendar in Microsoft Outlook</li><li>Understand how to navigate and use the features of each program</li><li>Be able to create documents, presentations, spreadsheets, and emails using each program</li><li>Learn how to format documents, use templates, insert images and objects, and perform other everyday tasks</li><li>Know the differences between each program and when to use each one</li></ul>Microsoft Office Diploma Course CurriculumIntroduction to Microsoft Office Diploma<ul><li>INTRO FINAL</li></ul>Microsoft Office: Microsoft Word Essentials<ul><li>New Word Document and Templates</li><li>Tabs, Ribbons and Groups</li><li>Zoom and Rulers in Word</li><li>and more..</li></ul>Microsoft Office: Microsoft PowerPoint Essentials<ul><li>New PowerPoint Presentation and Templates</li><li>Tabs Ribbons and Groups in PowerPoint</li><li>First Slide and Designing the Slide</li><li>and more...</li></ul>Microsoft Office: Microsoft Outlook Essentials<ul><li>Setting Up Outlook with Accounts</li><li>Tabs, Ribbons and Groups in Outlook</li><li>Navigation Bar in Outlook</li><li>and more..</li></ul>Microsoft Excel Keyboard Shortcuts<ul><li>Formatting Excel Keyboard Shortcuts</li><li>Table Excel Keyboard Shortcuts</li><li>and more...</li></ul>Exam &amp; Retakes:It is to inform our learners that the initial exam for this online course is provided at no additional cost. In the event of needing a retake, a nominal fee of £9.99 will be applicable.CertificationUpon successful completion of the assessment procedure, learners can obtain their certification by placing an order and remitting a fee of £9 for PDF Certificate and £15 for the Hardcopy Certificate within the UK ( An additional £10 postal charge will be applicable for international delivery).<h2>
 
 <div>CPD</div>
 </h2>

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

 <div id="who_is_this_course_for">
 The Microsoft Office (Word, Powerpoint, Outlook, Excel) Crash Course is open to all, with no formal entry requirements.
 </div><h2>
 
 <div>Requirements</div>
 </h2>

 <div id="requirements">
 Our Microsoft Office (Word, Powerpoint, Outlook, Excel) Crash Course is fully compatible with any kind of device.
 </div><h2>
 
 <div>Career path</div>
 </h2>

 <div id="career_path">
 Jobs you can explore, such as:<ul><li>Microsoft Office 365 consultant</li><li>M365 administrator</li><li>Office 365 technical consultant</li><li>Microsoft Office 365 apprentice</li><li>MS Apps Technical Lead</li></ul>
 </div><h2>
 
 <div>Certificates</div>
 </h2>

 <div id="optional_extras">
 <h4>Certificate of completion</h4>
 
 Digital certificate -
 £9
 
 <div> How is the course assessed?To successfully complete the course you must pass an automated, multiple-choice assessment. The assessment is delivered through our online learning platform. You will receive the results of your assessment immediately upon completion. </div>
 <h4>Certificate of completion</h4>
 
 Hard copy certificate -
 £15
 
 <div> CPD Accredited Certification<ul><li>Hardcopy Certificate (within the UK): £15</li><li>Hardcopy Certificate (international): £15 + £10 (postal charge) = £25</li></ul> </div>

 </div>

Ultimate Microsoft Office (Word, Powerpoint, Outlook, Excel) Diploma Course

<div>
	<h3>Course Overview</h3>
Learn all the essential skills to become an expert in Leadership &amp; Management. From this comprehensive Leadership &amp; Management course, you will be able to understand the principles of Leadership &amp; Management. In the step-by-step training process, you will acquire practical skills along with theoretical knowledge. The Qualified professionals will assist you throughout this learning process.
This Leadership &amp; Management is structured to ensure you have all the adequate skills to secure a position in this competitive industry. You will achieve the confidence and competency to bear all the responsibilities of this profession. The course will add all the right credentials to your resume and increase your employability in this growing industry.
<h3>Learning Outcomes</h3>
<ul>
<li>Learn leadership theories and be able to criticise them by analysing the benefits and drawbacks</li>
<li>Improve your management and leadership abilities in the workplace</li>
<li>Acquire negotiating skills by employing negotiation tactics and strategies</li>
<li>Master time management and make the most of your time in a productive manner</li>
</ul>
<h3>Who is this course for?</h3>
Anyone who is now employed in this field or who aspires to be one should take this course. Your knowledge will grow through taking this course, which will also strengthen your resume. To demonstrate your newly gained knowledge, develop crucial abilities and receive a professional credential.
<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 to undertake the qualification.</li>
<li>Good understanding of English language, numeracy and ICT are required to attend this course.</li>
</ul>
<h3>Certification</h3>
<ul>
<li>After you have successfully completed the course, you will be able to obtain an Accredited Certificate of Achievement. You can however also obtain a Course Completion Certificate following the course completion without sitting for the test. Certificates can be obtained either in hardcopy at the cost of £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/materials from the industry-leading experts;</li>
<li>Study in a user-friendly, advanced online learning platform;</li>
<li>Efficient exam systems for the assessment and instant result;</li>
<li>The UK &amp; internationally recognized accredited qualification;</li>
<li>Access to course content on mobile, tablet or desktop from anywhere anytime;</li>
<li>The benefit of career advancement opportunities;</li>
<li>24/7 student support via email.</li>
</ul>
<h3>Career Path</h3>
The Leadership &amp; Management course is intended to assist you in obtaining the dream job or maybe the promotion you've always desired. With the assistance and direction of our Leadership &amp; Management course, learn the vital abilities and knowledge you require to succeed in your life.
<div id="mouseposition-extension-element-full-container">
<div id="mouseposition-extension-element-rect-display">
<pre></pre>
</div>
<pre id="mouseposition-extension-element-coordinate-display"></pre>
</div>
		</div><table width="100%">				<tbody><tr>
					<td colspan="4"> Introduction to The Course</td>
				</tr>
								<tr>
					<td></td>
					<td>Introduction to the Course</td>
					<td> </td>
					<td> 00:03:00</td>
				</tr>
								<tr>
					<td colspan="4">Module 01: Understanding Management and Leadership</td>
				</tr>
								<tr>
					<td></td>
					<td>Understanding Management and Leadership</td>
					<td> </td>
					<td> 00:40:00</td>
				</tr>
								<tr>
					<td colspan="4">Module 02: Leadership Theories</td>
				</tr>
								<tr>
					<td></td>
					<td>Leadership Theories</td>
					<td> </td>
					<td> 00:25:00</td>
				</tr>
								<tr>
					<td colspan="4">Module 03: Improving Management and Leadership Performance</td>
				</tr>
								<tr>
					<td></td>
					<td>Improving Management and Leadership Performance</td>
					<td> </td>
					<td> 00:15:00</td>
				</tr>
								<tr>
					<td colspan="4">Module 04: High Performance Teams</td>
				</tr>
								<tr>
					<td></td>
					<td>High Performance Teams</td>
					<td> </td>
					<td> 00:32:00</td>
				</tr>
								<tr>
					<td colspan="4">Module 05: Motivating Employees</td>
				</tr>
								<tr>
					<td></td>
					<td>Motivating Employees</td>
					<td> </td>
					<td> 00:26:00</td>
				</tr>
								<tr>
					<td colspan="4">Module 06: Organisational Skills</td>
				</tr>
								<tr>
					<td></td>
					<td>Organisational Skills</td>
					<td> </td>
					<td> 00:26:00</td>
				</tr>
								<tr>
					<td colspan="4">Module 07: Talent Management</td>
				</tr>
								<tr>
					<td></td>
					<td>Talent Management</td>
					<td> </td>
					<td> 00:37:00</td>
				</tr>
								<tr>
					<td colspan="4">Module 08: Succession Planning</td>
				</tr>
								<tr>
					<td></td>
					<td>Succession Planning</td>
					<td> </td>
					<td> 00:23:00</td>
				</tr>
								<tr>
					<td colspan="4">Module 09: Business Process Management</td>
				</tr>
								<tr>
					<td></td>
					<td>Business Process Management</td>
					<td> </td>
					<td> 00:28:00</td>
				</tr>
								<tr>
					<td colspan="4">Module 10: Communication Skills</td>
				</tr>
								<tr>
					<td></td>
					<td>Communication Skills</td>
					<td> </td>
					<td> 00:27:00</td>
				</tr>
								<tr>
					<td colspan="4">Module 11: Negotiation Techniques</td>
				</tr>
								<tr>
					<td></td>
					<td>Negotiation Techniques</td>
					<td> </td>
					<td> 00:14:00</td>
				</tr>
								<tr>
					<td colspan="4">Module 12: Managing Meetings and Giving Feedback</td>
				</tr>
								<tr>
					<td></td>
					<td>Managing Meetings and Giving Feedback</td>
					<td> </td>
					<td> 00:22:00</td>
				</tr>
								<tr>
					<td colspan="4">Module 13: Managing Change</td>
				</tr>
								<tr>
					<td></td>
					<td>Managing Change</td>
					<td> </td>
					<td> 00:21:00</td>
				</tr>
								<tr>
					<td colspan="4">Module 14: Time Management</td>
				</tr>
								<tr>
					<td></td>
					<td>Time Management</td>
					<td> </td>
					<td> 00:37:00</td>
				</tr>
								<tr>
					<td colspan="4">Module 15: Stress Management</td>
				</tr>
								<tr>
					<td></td>
					<td>Stress Management</td>
					<td> </td>
					<td> 00:15:00</td>
				</tr>
								<tr>
					<td colspan="4">Module 16: Emotional Intelligence in Leadership</td>
				</tr>
								<tr>
					<td></td>
					<td>Emotional Intelligence in Leadership</td>
					<td> </td>
					<td> 00:32:00</td>
				</tr>
								<tr>
					<td colspan="4">Module 17: Managing Conflict</td>
				</tr>
								<tr>
					<td></td>
					<td>Managing Conflict</td>
					<td> </td>
					<td> 00:22:00</td>
				</tr>
								<tr>
					<td colspan="4">Module 18: Dealing with Office Politics</td>
				</tr>
								<tr>
					<td></td>
					<td>Dealing with Office Politics</td>
					<td> </td>
					<td> 00:34:00</td>
				</tr>
								<tr>
					<td colspan="4">Module 19: Risk Management</td>
				</tr>
								<tr>
					<td></td>
					<td>Risk Management</td>
					<td> </td>
					<td> 00:35:00</td>
				</tr>
								<tr>
					<td colspan="4">Module 20: Corporate Responsibility and Ethics</td>
				</tr>
								<tr>
					<td></td>
					<td>Corporate Responsibility and Ethics</td>
					<td> </td>
					<td> 00:15:00</td>
				</tr>
								<tr>
					<td colspan="4">Module 21:Microsoft Word, Excel, PowerPoint</td>
				</tr>
								<tr>
					<td></td>
					<td>Microsoft Word</td>
					<td> </td>
					<td> 08:06:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Microsoft Excel</td>
					<td> </td>
					<td> 07:58:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Microsoft PowerPoint</td>
					<td> </td>
					<td> 08:24:00</td>
				</tr>
								<tr>
					<td colspan="4">A Recap to the Course</td>
				</tr>
								<tr>
					<td></td>
					<td>Recap - Leadership Management</td>
					<td> </td>
					<td> 00:46:00</td>
				</tr>
								<tr>
					<td colspan="4">Recommended Materials</td>
				</tr>
								<tr>
					<td></td>
					<td>Workbook -Leadership Management</td>
					<td> </td>
					<td> 01:12:00</td>
				</tr>
								<tr>
					<td colspan="4">Certificate and Transcript</td>
				</tr>
								<tr>
					<td></td>
					<td>Order Your Certificates and Transcripts</td>
					<td> </td>
					<td> 00:00:00</td>
				</tr>
				</tbody></table>

John Academy

Learning & Development

Online Course Marketing

Business Leadership

Leadership Skills

Institute of Leadership & Management (ILM)

Management Skills

Leadership & Management

<div>
	<blockquote>Do you want to improve your customer service skills &amp; want to make your customers happy? Do you want to exceed customer expectations and want to create clients who spread words about your business? If yes, then enrol now and benefit from this course.</blockquote>
<h3>Description:</h3>
This Customer Service course teaches the basics of customer service and translates that knowledge into practical application. Students will come away from this customer service course knowing how a positive attitude, going a step beyond basic customer service, and dealing effectively with complaints will enhance their work experience. Students will learn the difference between internal and external customers and will find out how the development and implementation of a comprehensive customer service policy promote consistency in how customers are treated and keep customers happy.
<h3>Who is the course for?</h3>
<ul>
<li>Individuals who have any interaction with customers in any business.</li>
<li>People who want to take their customer service skills to the next level.</li>
<li>Students.</li>
<li>Job seekers.</li>
</ul>
<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 to undertake the qualification.</li>
<li>Good understanding of English language, numeracy and ICT are required to attend this course.</li>
</ul>
<h3>Assessment: </h3>
<ul>
<li>At the end of the course, you will be required to sit an online multiple-choice test. Your test will be assessed automatically and immediately so that you will instantly know whether you have been successful.</li>
<li>Before sitting for your final exam you will have the opportunity to test your proficiency with a mock exam.</li>
</ul>
<h3>Certification:</h3>
<ul>
<li>After you have successfully passed the test, you will be able to obtain an Accredited Certificate of Achievement. You can however also obtain a Course Completion Certificate following the course completion without sitting for the test. Certificates can be obtained either in hardcopy at a cost of £39 or in PDF format at a 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/materials from the industry leading experts;</li>
<li>Study in a user-friendly, advanced online learning platform;</li>
<li>Efficient exam systems for the assessment and instant result;</li>
<li>The UK &amp; internationally recognised accredited qualification;</li>
<li>Access to course content on mobile, tablet or desktop from anywhere anytime;</li>
<li>The benefit of career advancement opportunities;</li>
<li>24/7 student support via email.</li>
</ul>
<h3>Career Path:</h3>
Level 2 Certificate in Customer Service is a useful qualification to possess, and would be beneficial for the following professionals:
<ul>
<li>Administrative Receptionist.</li>
<li>Assistant Office Manager.</li>
<li>Call Center Customer Service Representative.</li>
<li>Call Center Representative.</li>
<li>Call Center Supervisor.</li>
<li>Customer Care Representative.</li>
<li>Customer Service Administrative Assistant.</li>
<li>Customer Service Agent.</li>
<li>Customer Service Analyst.</li>
<li>Customer Service Assistant.</li>
<li>Customer Service Associate.</li>
</ul>
		</div><table width="100%">				<tbody><tr>
					<td colspan="4"> Customer Service</td>
				</tr>
								<tr>
					<td></td>
					<td>Introduction To Customer Service</td>
					<td> </td>
					<td> 00:15:00</td>
				</tr>
								<tr>
					<td></td>
					<td>The Power of Positive Thinking in Customer Service</td>
					<td> </td>
					<td> 00:30:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Types of Difficult Customers and How to Help them</td>
					<td> </td>
					<td> 01:00:00</td>
				</tr>
								<tr>
					<td></td>
					<td>How to Deal with Difficult Customers</td>
					<td> </td>
					<td> 00:30:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Conclusion</td>
					<td> </td>
					<td> 00:15:00</td>
				</tr>
								<tr>
					<td colspan="4"> Customer Service Basics</td>
				</tr>
								<tr>
					<td></td>
					<td>Customer Service and Retention Templates</td>
					<td> </td>
					<td> 01:00:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Customer Service &amp; Retention Checklist</td>
					<td> </td>
					<td> 01:00:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Customer Service Checklist</td>
					<td> </td>
					<td> 01:00:00</td>
				</tr>
								<tr>
					<td colspan="4">Customer Service Skills</td>
				</tr>
								<tr>
					<td></td>
					<td>First Lesson</td>
					<td> </td>
					<td> 00:30:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Second Lesson</td>
					<td> </td>
					<td> 01:00:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Third Lesson</td>
					<td> </td>
					<td> 00:30:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Fourth Lesson</td>
					<td> </td>
					<td> 00:30:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Fifth Lesson</td>
					<td> </td>
					<td> 01:00:00</td>
				</tr>
								<tr>
					<td colspan="4">Microsoft Word</td>
				</tr>
								<tr>
					<td></td>
					<td>Module One - Getting Started</td>
					<td> </td>
					<td> 00:30:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Module Two - Opening</td>
					<td> </td>
					<td> 01:00:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Module Three - Working with the Interface</td>
					<td> </td>
					<td> 01:00:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Module Four - Your First Document</td>
					<td> </td>
					<td> 01:00:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Module Five - Basic Editing Tasks</td>
					<td> </td>
					<td> 01:00:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Module Six - Basic Formatting Tasks</td>
					<td> </td>
					<td> 01:00:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Module Seven - Formatting Paragraphs</td>
					<td> </td>
					<td> 01:00:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Module Eight - Advanced Formatting Tasks</td>
					<td> </td>
					<td> 01:00:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Module Nine - Working with Styles</td>
					<td> </td>
					<td> 01:00:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Module Ten - Formatting the Page</td>
					<td> </td>
					<td> 01:00:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Module Eleven - Sharing Your Document</td>
					<td> </td>
					<td> 01:00:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Module Twelve - Wrapping Up</td>
					<td> </td>
					<td> 00:30:00</td>
				</tr>
								<tr>
					<td colspan="4">Microsoft Excel</td>
				</tr>
								<tr>
					<td></td>
					<td>Module One - Getting Started</td>
					<td> </td>
					<td> 00:30:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Module Two - Opening Excel</td>
					<td> </td>
					<td> 01:00:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Module Three - Working with the Interface</td>
					<td> </td>
					<td> 01:00:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Module Four - Your First Worksheet</td>
					<td> </td>
					<td> 01:00:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Module Five - Viewing Excel Data</td>
					<td> </td>
					<td> 01:00:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Module Six - Building Formulas</td>
					<td> </td>
					<td> 01:00:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Module Seven - Using Excel Functions</td>
					<td> </td>
					<td> 01:00:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Module Eight - Using Quick Analysis</td>
					<td> </td>
					<td> 01:00:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Module Nine - Formatting Your Data</td>
					<td> </td>
					<td> 01:00:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Module Ten - Using Styles, Themes, and Effects</td>
					<td> </td>
					<td> 01:00:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Module Eleven - Printing and Sharing Your Workbook</td>
					<td> </td>
					<td> 01:00:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Module Twelve - Wrapping Up</td>
					<td> </td>
					<td> 01:00:00</td>
				</tr>
								<tr>
					<td colspan="4">Mock Exam</td>
				</tr>
								<tr>
					<td></td>
					<td>Mock Exam- Certificate in Customer Service</td>
					<td> </td>
					<td> 00:30:00</td>
				</tr>
								<tr>
					<td colspan="4">Final Exam</td>
				</tr>
								<tr>
					<td></td>
					<td>Final Exam- Certificate in Customer Service</td>
					<td> </td>
					<td> 00:30: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>

Customer Service

Certificate in Education & Training (CET)

Professional Skills Course (PSC)

FA Level 1

Trainers Course

Level 2 Certificate in Customer Service

<div>
	<h3>Course Overview</h3>
Microsoft Excel has brought a revolutionary change in the field of data management. It is one of the key skills that every employer looks for in a potential employee. The 50 MS Excel Tips to Upgrade your Excel Skill to the Next Level course is designed to equip you with adequate expertise in Excel. This course is a golden opportunity to add a highly beneficial skill to your resume and impress your employers.
In this 50 MS Excel Tips to Upgrade your Excel Skill to the Next Level course, you will receive a wide range of valuable tips to elevate your MS Excel skills. The course will show you the process of adding a link in the formula bar and adding multiple columns and rows within a blink. You will become skilled in quick calculations in the status bar. From the informative modules, you will identify the shortcut keys and learn to navigate between worksheets. The lessons will introduce you to the method of ZIP code format. You will understand how to move cell directions and convert numbers to text. 
This 50 MS Excel Tips to Upgrade your Excel Skill to the Next Level course is packed with valuable information about MS Excel. So enroll in the course and become a proficient MS Excel user.
<h3>Learning Outcomes</h3>
<ul>
<li>Learn how to navigate between worksheets using shortcut keys</li>
<li>Understand the process of creating a custom autofill list and importing data from webpages</li>
<li>Build the skills to hide workbook elements</li>
<li>Enrich your understanding of advanced transpose</li>
<li>Grasp the techniques of moving cell directions and deleting data</li>
<li>Know how to convert text to numbers</li>
</ul>
<h3>Who is this course for?</h3>
This 50 MS Excel Tips to Upgrade your Excel Skill to the Next Level course is for those who want to improve their Excel skills.
<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 to undertake the qualification.</li>
<li>Good understanding of English language, numeracy and ICT are required to attend this course.</li>
</ul>
<h3>Certification</h3>
<ul>
<li>After you have successfully completed the course, you will be able to obtain an Accredited Certificate of Achievement. You can however also obtain a Course Completion Certificate following the course completion without sitting for the test. Certificates can be obtained either in hardcopy at the cost of £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/materials from the industry-leading experts;</li>
<li>Study in a user-friendly, advanced online learning platform;</li>
<li>Efficient exam systems for the assessment and instant result;</li>
<li>The UK &amp; internationally recognized accredited qualification;</li>
<li>Access to course content on mobile, tablet or desktop from anywhere anytime;</li>
<li>The benefit of career advancement opportunities;</li>
<li>24/7 student support via email.</li>
</ul>
<h3>Career Path</h3>
 The 50 MS Excel Tips to Upgrade your Excel Skill to next Level course is a useful qualification to possess and would be beneficial for any related profession or industry such as:
<ul>
<li>Administrative Assistant</li>
<li>Data Analyst</li>
<li>Accountants</li>
<li>Financial Analyst</li>
<li>Retail Store Manager</li>
<li>Project Manager</li>
<li>Business Analyst</li>
</ul>
		</div><table width="100%">				<tbody><tr>
					<td colspan="4"> Unit 01: Introduction</td>
				</tr>
								<tr>
					<td></td>
					<td>Welcome</td>
					<td> </td>
					<td> 00:02:00</td>
				</tr>
								<tr>
					<td colspan="4">Unit 02: Excel Productivity Tips -Part 1</td>
				</tr>
								<tr>
					<td></td>
					<td>Camera Tool</td>
					<td> </td>
					<td> 00:05:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Add Line Break in Formula Bar</td>
					<td> </td>
					<td> 00:03:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Advanced Copy-Paste using Office Clipboard</td>
					<td> </td>
					<td> 00:03:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Navigation between Worksheets using Shortcut Keys</td>
					<td> </td>
					<td> 00:01:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Flash Fill</td>
					<td> </td>
					<td> 00:02:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Add Multiple Rows and Columns Quickly</td>
					<td> </td>
					<td> 00:02:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Delete Blank Rows</td>
					<td> </td>
					<td> 00:03:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Multi Level Row and Column Sorting</td>
					<td> </td>
					<td> 00:04:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Add Sparklines</td>
					<td> </td>
					<td> 00:03:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Paste Special - Transpose</td>
					<td> </td>
					<td> 00:03:00</td>
				</tr>
								<tr>
					<td colspan="4">Unit 03: Excel Productivity Tips - Part 2</td>
				</tr>
								<tr>
					<td></td>
					<td>Snap to Grid</td>
					<td> </td>
					<td> 00:03:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Create Custom Auto fill List</td>
					<td> </td>
					<td> 00:06:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Absolute Cell Reference</td>
					<td> </td>
					<td> 00:03:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Import Data from Web page</td>
					<td> </td>
					<td> 00:04:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Move Cell Direction</td>
					<td> </td>
					<td> 00:03:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Delete Data using Mouse</td>
					<td> </td>
					<td> 00:02:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Status Bar Quick Calculations</td>
					<td> </td>
					<td> 00:03:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Link Text Boxes to Cell</td>
					<td> </td>
					<td> 00:04:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Phone Number and ZIP Code Format</td>
					<td> </td>
					<td> 00:04:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Speaking Cell</td>
					<td> </td>
					<td> 00:05:00</td>
				</tr>
								<tr>
					<td colspan="4">Unit 04: Excel Productivity Tips - Part 3</td>
				</tr>
								<tr>
					<td></td>
					<td>Invisible Text</td>
					<td> </td>
					<td> 00:03:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Worksheet Grouping</td>
					<td> </td>
					<td> 00:04:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Advanced Transpose</td>
					<td> </td>
					<td> 00:04:00</td>
				</tr>
								<tr>
					<td></td>
					<td>XLStart Folder</td>
					<td> </td>
					<td> 00:03:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Use Slicers</td>
					<td> </td>
					<td> 00:05:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Convert Text to Numbers</td>
					<td> </td>
					<td> 00:03:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Hiding Workbook Elements</td>
					<td> </td>
					<td> 00:02:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Useful Shortcut Keys</td>
					<td> </td>
					<td> 00:03:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Sort data from Left to Right</td>
					<td> </td>
					<td> 00:03:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Advanced Filter (Complex)</td>
					<td> </td>
					<td> 00:11:00</td>
				</tr>
								<tr>
					<td colspan="4">Unit 05: Excel Productivity Tips - Part 4</td>
				</tr>
								<tr>
					<td></td>
					<td>Email as PDF</td>
					<td> </td>
					<td> 00:02:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Synchronous Scrolling</td>
					<td> </td>
					<td> 00:03:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Quick Analysis of data within Excel</td>
					<td> </td>
					<td> 00:02:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Fill blank cells with Value</td>
					<td> </td>
					<td> 00:03:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Hidden Chart Source Data</td>
					<td> </td>
					<td> 00:03:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Two more Shortcuts</td>
					<td> </td>
					<td> 00:03:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Add Blank Rows</td>
					<td> </td>
					<td> 00:03:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Custom views in Excel</td>
					<td> </td>
					<td> 00:06:00</td>
				</tr>
								<tr>
					<td></td>
					<td>EMBED Feature</td>
					<td> </td>
					<td> 00:04:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Adding Country code in Mobile Numbers</td>
					<td> </td>
					<td> 00:04:00</td>
				</tr>
								<tr>
					<td colspan="4">Unit 05: Excel Productivity Tips - Part 5</td>
				</tr>
								<tr>
					<td></td>
					<td>Plot an Average Line to a Chart</td>
					<td> </td>
					<td> 00:04:00</td>
				</tr>
								<tr>
					<td></td>
					<td>3D Referencing</td>
					<td> </td>
					<td> 00:04:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Extract Unique Values</td>
					<td> </td>
					<td> 00:03:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Excel Array Formula</td>
					<td> </td>
					<td> 00:04:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Forecast Sheet</td>
					<td> </td>
					<td> 00:04:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Add Spin Controls in Excel</td>
					<td> </td>
					<td> 00:05:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Move Data using Mouse</td>
					<td> </td>
					<td> 00:01:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Add new entry in Auto Correct to use across Office Applications</td>
					<td> </td>
					<td> 00:05:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Find Differences between Two Lists</td>
					<td> </td>
					<td> 00:02:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Find formulas Quickly</td>
					<td> </td>
					<td> 00:02:00</td>
				</tr>
								<tr>
					<td colspan="4">Unit: 06 Wrap Up</td>
				</tr>
								<tr>
					<td></td>
					<td>Thank You</td>
					<td> </td>
					<td> 00:01: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>

Office Skills & Productivity

Microsoft Certification

Computing Skills

Microsoft AZ-900

Computer Skills

Microsoft Excel

Top 50 MS Excel Advanced Tips to Upgrade Skill to next Level

<div>
	<blockquote> Do you want to be able to develop your skills and at the same have a career growth?  If so, then this course will be perfect for you and your needs.</blockquote>
<h3>Description: </h3>
Do you always feel burned out because of work? Are you feeling that you are stuck with your work and being burdened by it? If you are feeling like this, then this course will help you learn the necessary skills you need for career development. You will also be educated on the skills where you need improvement and help you taking assessment tests for your chosen career. This course will also help you in getting help through mentoring and taking online and offline classes. This course will also teach you valuable life lessons and the importance of esteem for career development.
<h3>Who is the course for?</h3>
<ul>
<li>Professionals or anyone who helps people with their dilemmas in career development.</li>
<li>People who have an interest in developing their career developing skills.</li>
</ul>
<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 to undertake the qualification.</li>
<li>Good understanding of English language, numeracy and ICT are required to attend this course.</li>
</ul>
<h3>Assessment: </h3>
<ul>
<li>At the end of the course, you will be required to sit an online multiple-choice test. Your test will be assessed automatically and immediately so that you will instantly know whether you have been successful.</li>
<li>Before sitting for your final exam you will have the opportunity to test your proficiency with a mock exam.</li>
</ul>
<h3>Certification:</h3>
<ul>
<li>After you have successfully passed the test, you will be able to obtain an Accredited Certificate of Achievement. You can however also obtain a Course Completion Certificate following the course completion without sitting for the test. Certificates can be obtained either in hard copy at a cost of £39 or in PDF format at a 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/materials from the industry leading experts;</li>
<li>Study in a user-friendly, advanced online learning platform;</li>
<li>Efficient exam systems for the assessment and instant result;</li>
<li>The UK &amp; internationally recognised accredited qualification;</li>
<li>Access to course content on mobile, tablet or desktop from anywhere anytime;</li>
<li>The benefit of career advancement opportunities;</li>
<li>24/7 student support via email.</li>
</ul>
<h3>Career Path:</h3>
The Career Developing Skills would be beneficial for the following careers:
<ul>
<li>Career Coaches</li>
<li>Human Resource Specialist</li>
<li>Human Resource Managers</li>
<li>Life Coaches</li>
<li>Managers</li>
<li>Mentors</li>
<li>Top Executives.</li>
</ul>
		</div><table width="100%">				<tbody><tr>
					<td colspan="4">Career Developing Skills</td>
				</tr>
								<tr>
					<td></td>
					<td>Introduction</td>
					<td> </td>
					<td> 00:15:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Ways To Improve Your Performance At Work</td>
					<td> </td>
					<td> 00:30:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Career Aptitude Tests And Career Assessments</td>
					<td> </td>
					<td> 00:30:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Get Mentoring</td>
					<td> </td>
					<td> 01:00:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Importance Of Online Courses</td>
					<td> </td>
					<td> 00:30:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Advantages To Take Offline Courses</td>
					<td> </td>
					<td> 00:30:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Benefits Of Life Lessons</td>
					<td> </td>
					<td> 00:30:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Self Esteem</td>
					<td> </td>
					<td> 01:00:00</td>
				</tr>
								<tr>
					<td colspan="4"> Professional CV &amp; Resume Writing Techniques</td>
				</tr>
								<tr>
					<td></td>
					<td>INTRODUCTION</td>
					<td> </td>
					<td> 00:15:00</td>
				</tr>
								<tr>
					<td></td>
					<td>EFFECTIVE RESUME AND COVER LETTER WRITING</td>
					<td> </td>
					<td> 00:30:00</td>
				</tr>
								<tr>
					<td></td>
					<td>THE PURPOSE OF YOUR RESUME</td>
					<td> </td>
					<td> 01:00:00</td>
				</tr>
								<tr>
					<td></td>
					<td>RESUME PRESENTATION IS THE KEY</td>
					<td> </td>
					<td> 01:00:00</td>
				</tr>
								<tr>
					<td></td>
					<td>WOW THE EMPLOYER</td>
					<td> </td>
					<td> 01:00:00</td>
				</tr>
								<tr>
					<td></td>
					<td>ELEMENTS OF A RESUME THAT WILL IMPRESS</td>
					<td> </td>
					<td> 01:00:00</td>
				</tr>
								<tr>
					<td></td>
					<td>WRITING YOUR OBJECTIVE</td>
					<td> </td>
					<td> 01:00:00</td>
				</tr>
								<tr>
					<td></td>
					<td>WRITING YOUR SUMMARY</td>
					<td> </td>
					<td> 01:00:00</td>
				</tr>
								<tr>
					<td></td>
					<td>WRITING THE SKILLS AND ACCOMPLISHMENTS SECTION</td>
					<td> </td>
					<td> 01:00:00</td>
				</tr>
								<tr>
					<td></td>
					<td>RESUME FORMATTING</td>
					<td> </td>
					<td> 01:00:00</td>
				</tr>
								<tr>
					<td></td>
					<td>WRITING AN ELECTRONIC RESUME</td>
					<td> </td>
					<td> 01:00:00</td>
				</tr>
								<tr>
					<td></td>
					<td>PUT YOUR BEST FOOT FORWARD</td>
					<td> </td>
					<td> 00:15:00</td>
				</tr>
								<tr>
					<td></td>
					<td>YOUR RESUME - A WORK OF ART</td>
					<td> </td>
					<td> 01:00:00</td>
				</tr>
								<tr>
					<td></td>
					<td>WRITING THE HISTORY/ EXPERIENCE SECTION</td>
					<td> </td>
					<td> 01:00:00</td>
				</tr>
								<tr>
					<td></td>
					<td>WRITING YOUR EDUCATION SECTION</td>
					<td> </td>
					<td> 01:00:00</td>
				</tr>
								<tr>
					<td></td>
					<td>WRITING A PROFESSIONAL AFFILIATIONS SECTION</td>
					<td> </td>
					<td> 00:15:00</td>
				</tr>
								<tr>
					<td></td>
					<td>WRITING A PUBLICATIONS and PERSONAL INTERESTS SECTION</td>
					<td> </td>
					<td> 01:00:00</td>
				</tr>
								<tr>
					<td></td>
					<td>WRITING A REFERENCES SECTION</td>
					<td> </td>
					<td> 00:30:00</td>
				</tr>
								<tr>
					<td></td>
					<td>YOUR RESUME - A WORK OF ART</td>
					<td> </td>
					<td> 01:00:00</td>
				</tr>
								<tr>
					<td></td>
					<td>DO NOT PUT IN YOUR RESUME</td>
					<td> </td>
					<td> 00:15:00</td>
				</tr>
								<tr>
					<td></td>
					<td>A VARIETY OF RESUME SAMPLES</td>
					<td> </td>
					<td> 00:30:00</td>
				</tr>
								<tr>
					<td></td>
					<td>THE IMPORTANCE OF WRITING COVER LETTERS</td>
					<td> </td>
					<td> 01:00:00</td>
				</tr>
								<tr>
					<td></td>
					<td>COVER LETTER OUTLINE: HOW TO WRITE A GOOD COVER LETTER</td>
					<td> </td>
					<td> 01:00:00</td>
				</tr>
								<tr>
					<td></td>
					<td>KEY PHRASES TO BE USED IN YOUR COVER LETTER</td>
					<td> </td>
					<td> 00:15:00</td>
				</tr>
								<tr>
					<td></td>
					<td>COVER LETTER SAMPLE</td>
					<td> </td>
					<td> 01:00:00</td>
				</tr>
								<tr>
					<td></td>
					<td>BASIC COVER LETTER TEMPLATE EXAMPLE</td>
					<td> </td>
					<td> 00:30:00</td>
				</tr>
								<tr>
					<td></td>
					<td>CONCLUSION</td>
					<td> </td>
					<td> 00:15:00</td>
				</tr>
								<tr>
					<td colspan="4">How to Face an Interview Successfully</td>
				</tr>
								<tr>
					<td></td>
					<td>Importance of Knowing The Tips And Tricks for Interviews</td>
					<td> </td>
					<td> 00:15:00</td>
				</tr>
								<tr>
					<td></td>
					<td>The Different Types of Interviews</td>
					<td> </td>
					<td> 01:00:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Skill Building to Crack Interviews</td>
					<td> </td>
					<td> 00:15:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Tools and Miscellaneous You Need To Have</td>
					<td> </td>
					<td> 00:15:00</td>
				</tr>
								<tr>
					<td></td>
					<td>The Perfect 'Resume' - Significance and Importance</td>
					<td> </td>
					<td> 00:30:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Preparing Properly for an Interview</td>
					<td> </td>
					<td> 00:30:00</td>
				</tr>
								<tr>
					<td></td>
					<td>What Role Does Appearance Play?</td>
					<td> </td>
					<td> 00:30:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Tips To Gear Up - Pre-Interview</td>
					<td> </td>
					<td> 00:30:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Modern Tips By Interview Experts</td>
					<td> </td>
					<td> 00:30:00</td>
				</tr>
								<tr>
					<td colspan="4">Microsoft Word</td>
				</tr>
								<tr>
					<td></td>
					<td>Module One - Getting Started</td>
					<td> </td>
					<td> 00:30:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Module Two - Opening</td>
					<td> </td>
					<td> 01:00:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Module Three - Working with the Interface</td>
					<td> </td>
					<td> 01:00:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Module Four - Your First Document</td>
					<td> </td>
					<td> 01:00:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Module Five - Basic Editing Tasks</td>
					<td> </td>
					<td> 01:00:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Module Six - Basic Formatting Tasks</td>
					<td> </td>
					<td> 01:00:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Module Seven - Formatting Paragraphs</td>
					<td> </td>
					<td> 01:00:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Module Eight - Advanced Formatting Tasks</td>
					<td> </td>
					<td> 01:00:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Module Nine - Working with Styles</td>
					<td> </td>
					<td> 01:00:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Module Ten - Formatting the Page</td>
					<td> </td>
					<td> 01:00:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Module Eleven - Sharing Your Document</td>
					<td> </td>
					<td> 01:00:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Module Twelve - Wrapping Up</td>
					<td> </td>
					<td> 00:30:00</td>
				</tr>
								<tr>
					<td colspan="4">Microsoft PowerPoint</td>
				</tr>
								<tr>
					<td></td>
					<td>Module One - Getting Started</td>
					<td> </td>
					<td> 00:30:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Module Two - Opening PowerPoint</td>
					<td> </td>
					<td> 01:00:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Module Three - Working with the Interface</td>
					<td> </td>
					<td> 01:00:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Module Four - Your First Presentation</td>
					<td> </td>
					<td> 01:00:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Module Five - Working with Text</td>
					<td> </td>
					<td> 01:00:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Module Six - Formatting Text and Paragraphs</td>
					<td> </td>
					<td> 01:00:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Module Seven - Adding Pictures</td>
					<td> </td>
					<td> 01:00:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Module Eight - Advanced Formatting Tasks</td>
					<td> </td>
					<td> 01:00:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Module Nine - Working with Transitions and Animations</td>
					<td> </td>
					<td> 01:00:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Module Ten - Setting Up Your Slide Show</td>
					<td> </td>
					<td> 01:00:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Module Eleven - Showtime!</td>
					<td> </td>
					<td> 01:00:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Module Twelve - Wrapping Up</td>
					<td> </td>
					<td> 00:30:00</td>
				</tr>
								<tr>
					<td colspan="4">Microsoft Excel</td>
				</tr>
								<tr>
					<td></td>
					<td>Module One - Getting Started</td>
					<td> </td>
					<td> 00:30:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Module Two - Opening Excel</td>
					<td> </td>
					<td> 01:00:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Module Three - Working with the Interface</td>
					<td> </td>
					<td> 01:00:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Module Four - Your First Worksheet</td>
					<td> </td>
					<td> 01:00:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Module Five - Viewing Excel Data</td>
					<td> </td>
					<td> 01:00:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Module Six - Building Formulas</td>
					<td> </td>
					<td> 01:00:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Module Seven - Using Excel Functions</td>
					<td> </td>
					<td> 01:00:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Module Eight - Using Quick Analysis</td>
					<td> </td>
					<td> 01:00:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Module Nine - Formatting Your Data</td>
					<td> </td>
					<td> 01:00:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Module Ten - Using Styles, Themes, and Effects</td>
					<td> </td>
					<td> 01:00:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Module Eleven - Printing and Sharing Your Workbook</td>
					<td> </td>
					<td> 01:00:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Module Twelve - Wrapping Up</td>
					<td> </td>
					<td> 01:00:00</td>
				</tr>
								<tr>
					<td colspan="4">Mock Exam </td>
				</tr>
								<tr>
					<td></td>
					<td>Mock Exam- Career Developing Skills</td>
					<td> </td>
					<td> 00:30:00</td>
				</tr>
								<tr>
					<td colspan="4">Final Exam</td>
				</tr>
								<tr>
					<td></td>
					<td>Final Exam- Career Developing Skills</td>
					<td> </td>
					<td> 00:30:00</td>
				</tr>
				</tbody></table>

Professional Skills

Career Development

Employability Skills

Resume & CV Writing

Career Developing Skills

<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

Practical Accounting

Advanced Excel Models using Formulas, VBA & Power Query

Dive deep into the world of ChatGPT with our ChatGPT Masterclass. From basic functionalities to advanced applications across various domains, this course equips you with the knowledge to leverage ChatGPT effectively. Enhance your professional skills, academic pursuits, and personal projects by mastering ChatGPT today.Learning Outcomes<ul fr-original-style="" style="box-sizing: border-box;"><li id="isPasted" fr-original-style="" style="box-sizing: border-box;">Understand the mechanics behind ChatGPT&rsquo;s responses.</li><li fr-original-style="" style="box-sizing: border-box;">Create precise and effective prompts for ChatGPT.</li><li fr-original-style="" style="box-sizing: border-box;">Utilize ChatGPT for creative and technical writing.</li><li fr-original-style="" style="box-sizing: border-box;">Leverage ChatGPT for educational support and learning.</li><li fr-original-style="" style="box-sizing: border-box;">Integrate ChatGPT with Microsoft Excel for data management.</li><li fr-original-style="" style="box-sizing: border-box;">Employ ChatGPT to achieve professional excellence.</li><li fr-original-style="" style="box-sizing: border-box;">Explore practical and innovative ChatGPT prompts.</li><li fr-original-style="" style="box-sizing: border-box;">Implement ChatGPT strategies in social media marketing.</li><li fr-original-style="" style="box-sizing: border-box;">Understand the capabilities of ChatGPT Plus and New Bing.</li></ul>Course Curriculum<h4 id="isPasted" fr-original-style="" style="box-sizing: border-box;">Module 01: Getting Started with ChatGPT</h4><ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">Introduction to ChatGPT: Basics of how to interact with and utilize ChatGPT effectively.</li></ul><h4 fr-original-style="" style="box-sizing: border-box;">Module 02: Understanding ChatGPT</h4><ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">How ChatGPT Works: Insights into the AI and machine learning principles powering ChatGPT.</li></ul><h4 fr-original-style="" style="box-sizing: border-box;">Module 03: Crafting Effective ChatGPT Prompts: A Guide</h4><ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">Prompt Engineering: Techniques for developing precise prompts that generate desired outcomes.</li></ul><h4 fr-original-style="" style="box-sizing: border-box;">Module 04: Writing with ChatGPT</h4><ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">Creative and Technical Writing: Using ChatGPT to assist with various writing tasks and projects.</li></ul><h4 fr-original-style="" style="box-sizing: border-box;">Module 05: ChatGPT for Students</h4><ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">Educational Applications: How students can use ChatGPT for studying, research, and homework assistance.</li></ul><h4 fr-original-style="" style="box-sizing: border-box;">Module 06: ChatGPT for MS Excel</h4><ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">Excel Integration: Harnessing ChatGPT for automating tasks and analyzing data in Microsoft Excel.</li></ul><h4 fr-original-style="" style="box-sizing: border-box;">Module 07: ChatGPT for Professional Excellence</h4><ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">Career Development: Applying ChatGPT in professional settings for communication, problem-solving, and innovation.</li></ul><h4 fr-original-style="" style="box-sizing: border-box;">Module 08: Useful ChatGPT Prompts</h4><ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">Practical Prompts: A collection of effective ChatGPT prompts for various uses.</li></ul><h4 fr-original-style="" style="box-sizing: border-box;">Module 09: Social Media Marketing with ChatGPT</h4><ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">Marketing Strategies: Leveraging ChatGPT for content creation, customer engagement, and campaign management.</li></ul><h4 fr-original-style="" style="box-sizing: border-box;">Module 10: ChatGPT Plus and New Bing</h4><ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">Advanced Features: Exploring the enhanced capabilities and applications of ChatGPT Plus and New Bing.</li></ul><h4 fr-original-style="" style="box-sizing: border-box;">Module 11: ChatGPT in Personal Life</h4><ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">Everyday Uses: Practical ways to incorporate ChatGPT into daily personal tasks and activities.</li></ul><h4 fr-original-style="" style="box-sizing: border-box;">Module 12: The Future with ChatGPT</h4><ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">Looking Ahead: Discussing potential future developments in ChatGPT technology and its implications for various sectors.</li></ul>

RapidEDX

AI (Artificial Intelligence)

ChatGPT

ChatGPT Masterclass

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

Microsoft PowerPoint 2016/2019/365 - Foundations for Beginners

Financial Modeling and Analysis are highly respected skills in the business world and are hugely sought after in the job marketplace.Financial Modelling is a powerful communication tool to clearly and effectively tell the story of a company to management and stakeholders. It is a critical decision-making tool used by management to make accurate and informed financial decisions about a company or project.It is multidisciplinary, requiring expertise in Accounting, Finance, Financial Analysis, Valuation, and Microsoft Excel.This course has been developed to cover the entire body of knowledge issued by the Financial Modeling Institute for Level One; Advanced Financial Modeler Designation.This course is certified by the CFA Society Nigeria with 40 PL Credits and CPD UK with 40 CPD Credits.&nbsp;In this course, you will learn 3 Statement Modeling from Scratch to Mastery using a real Company&#39;s Audited Financial Statement. &nbsp;The 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 (with over 200+ step-by-step videos).&nbsp;&bull; &nbsp; &nbsp;1 Technical Session to confirm your connectivity and solve any technical issues you may have).&nbsp;&bull; &nbsp; &nbsp;10 intensive instructor-led live virtual sessions. Each session is 2 hours&nbsp;&bull; &nbsp; &nbsp;9 compulsory intersession assignments you will need to complete and submit on www.OfficeTrainingHub.com&nbsp;&bull; &nbsp; &nbsp;Intermittent tests and quizzes to gauge your assimilation.&nbsp;&bull; &nbsp; &nbsp;1 Capstone Project

dbrownconsulting

Move from Beginner to Professional Level in Financial Modelling and Analysis with this detailed Advanced Financial Modeler Certificate Course.

Advanced Financial Modeler Certificate Course

***Offer Ends Today***Earn up to 40K as a 'DATA ANALYST' or Your 100% Money BackDo you know that entry-level data analysts earn an average of £40,000 annually, with the potential to quickly earn six figures with experience and expertise? Are you looking to join the high-demand field of data analytics and earn a handsome salary? Our Data Analyst Job Ready Program is here to guide you all the way until you get the job you want.Our Data Analyst Job Ready Program is your all-in-one solution to learn data analytics from scratch and also secure a job in this exciting industry. With our unique blend of comprehensive courses and career support, your dream job is within reach. We understand the challenges of transitioning into a new field, which is why our program is tailored to guide you every step of the way - from mastering core skills to landing your first job in data analytics. By choosing our Data Analyst Job Ready Program, you're not just gaining skills; you're gaining a lifelong career partner.Our mission is simple - to be your trusted partner every step of the way, from Training to Employment.Enrol Now and Kickstart Your Data Analytics Career. Don't miss this opportunity to transform your career with the Data Analyst Job Ready Program. With our comprehensive training, career support, and money-back guarantee, you're not just enrolling in a program; you're investing in a brighter future. Join us now and become a part of the next generation of data analysts!In addition to teaching you the technical skills you need, we will also provide you with career mentoring and support. We will help you build your resume, prepare for interviews, and land your dream job. We also have partnerships with many companies that are hiring Data Analysts, so we can help you get the job you want.If you are not happy with our service, we also offer a 100% money-back guarantee. So what are you waiting for? Enrol in our Data Analyst Job Ready Program today and start your journey to becoming a successful Data Analyst!Why Choose Us?So, what sets us apart from other programs? Let's dive into the exceptional benefits you'll experience when you join our Data Analyst Job Ready Program:<ul><li>Personalised Guidance: Our experienced mentors will provide one-on-one counselling sessions tailored to your specific needs. Whether you're a beginner or have some experience, we will guide you towards honing your skills and developing a strong foundation in Business Analysis. </li><li>One-On-One Consultation Sessions with Experts: Gain invaluable insights and guidance from seasoned professionals who have thrived in the Data Analyst field. </li><li>Extensive Job Opportunities: We have established partnerships with numerous companies actively seeking Data analysts. Through our network, we'll connect you with exclusive job openings that are not easily accessible elsewhere. </li><li>Interview Preparation: We provide you with access to a comprehensive database of potential interview questions curated over years of industry experience. Walk into your interviews confident, well-prepared, and ready to impress. </li><li>100% Money-Back Guarantee: Your satisfaction is our top priority. We are confident in the quality of our training and support, which is why we offer a 100% money-back guarantee.</li></ul>Courses we will provide once you enrol in the program:<ul><li>Course 01: Introduction to Data Analysis</li><li>Course 02: Business and Data Analytics for Beginners</li><li>Course 03: Data Analytics with Tableau</li><li>Course 04: Quick Data Science Approach from Scratch</li><li>Course 05: Learn MySQL from Scratch for Data Science and Analytics</li><li>Course 06: SQL for Data Science, Data Analytics and Data Visualization</li><li>Course 07: Statistics &amp; Probability for Data Science &amp; Machine Learning</li><li>Course 08: Basic Google Data Studio</li><li>Course 09: R Programming for Data Science</li><li>Course 10: Python Data Science with Numpy, Pandas and Matplotlib</li><li>Course 11: Complete Python Machine Learning &amp; Data Science Fundamentals</li><li>Course 12: 2021 Data Science &amp; Machine Learning with R from A-Z</li><li>Course 13: Microsoft Excel Complete Course</li><li>Course 14: Microsoft Excel: Automated Dashboard Using Advanced Formula, VBA, Power Query</li><li>Course 15: Data Center Training Essentials: General Introduction</li><li>Course 16: Excel Data Analysis</li><li>Course 17: Data Entry Administrator Training</li><li>Course 18: SQL Masterclass: SQL For Data Analytics</li><li>Course 19: Business Data Analysis</li><li>Course 20: Master JavaScript with Data Visualization</li></ul>How Can We Offer Job Guarantees?HF Online provides consultancy, professional and educational services to many of the companies in the UK. During our intense exclusive training program, you will not just gain and complete the industry valuable certification but will gain industry experience as well, which is imperative to get your 1st job in the sector. The Data Analyst Job Ready Program with Career Support &amp; Money Back Guarantee is completed in 9 easy steps:Step 1: Enrol in the ProgrammeBegin your exciting journey with us by enrolling in the Data and Business Intelligence Analyst Job Ready Program. Complete your registration and make a secure online payment. Remember, we offer a 14-day money-back guarantee if you're not completely satisfied.After you enrol in the Program, you will get lifetime access to 6 premium courses related to Web Development. These courses will teach you the knowledge and skills required to become a successful Data and Business Intelligence Analyst. Our customer service team will help you and keep in contact with you every step of the way. So you won't have to worry about a thing!Step 2: Initial One-On-One Counselling SessionOnce enrolled, you will be paired with a dedicated career mentor. Schedule your first one-on-one session to discuss your career aspirations, skills, experience, and any areas for potential growth. This conversation will shape your learning and development path.Step 3: Certification upon Course CompletionAfter learning from the courses, you must obtain certificates for each course. There will be exams for every course, and you have to pass them to get your certificate. To pass successfully, you must get 90% marks. Once you pass the exams, you will receive hardcopy certificates. These certificates will prove that you're an expert in the subject.Step 4: CV RevampingOur team of professionals will build you a compelling CV and LinkedIn profile. We'll ensure it presents your skills and qualifications effectively and is tailored to the needs and expectations of the finance industry. With these powerful tools in hand, you'll be fully prepared to tackle job interviews confidently.Step 5: Building Network and Submitting CVWe understand the power of casting a wide net. We'll strategically submit your CV to various platforms and networks, expanding your reach and connecting you with valuable opportunities that align with your career goals. We will also make connections with many high-profile individuals and companies through your LinkedIn profile.Step 6: Interview PreparationWith your CV ready, we'll move on to interview preparation. Gain exclusive access to our database of potential interview questions. Through simulated interviews with your mentor, you'll practice your responses and receive valuable feedback to further refine your skills.Step 7: Securing Job InterviewsLeveraging our partnerships with leading companies, we'll secure job interviews for you. We'll ensure you get the opportunity to showcase your skills to potential employers and get the dream job you want.Step 8: Post-Interview SupportPost-interview, we'll provide a debriefing session to reflect on your performance and identify areas of improvement for future interviews if necessary. Remember, our commitment extends until you land your dream job.Step 9: Celebrate Your New Job!Once you've secured your dream job in web development, it's time to celebrate! However, our support doesn't end there. We'll provide you with ongoing career advice to ensure you continue to thrive in your new role.We're excited to accompany you on this journey to success. Enrol today, and let's get started! Your path to a successful Data and Business Intelligence Analyst career begins with us. <h2>
 
 <div>CPD</div>
 </h2>

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

 <div id="who_is_this_course_for">
 This Data Analyst Job Ready Program is perfect for:<ul><li>Beginners eager to break into the field of data analytics and get a job.</li><li>Professionals looking to move their career towards data science.</li><li>Individuals seeking a comprehensive understanding of data analysis tools and techniques.</li><li>Those aiming for a career upgrade with advanced analytics skills.</li><li>Anyone interested in gaining practical, job-ready skills in data analytics and machine learning.</li></ul>
 </div> <h2>
 
 <div>Career path</div>
 </h2>

 <div id="career_path">
 This Data Analyst Job Ready Program will help you get a job in different roles, such as:<ul><li>Entry-Level Data Analyst: £25,000 - £35,000</li><li>Mid-Level Data Analyst: £35,000 - £60,000</li><li>Senior Data Analyst: £50,000 - £80,000</li><li>Data Scientist: £40,000 - £100,000</li><li>Data Analytics Manager: £60,000 - £100,000</li><li>Business Intelligence Analyst: £30,000 - £75,000</li><li>Machine Learning Engineer: £45,000 - £80,000</li></ul>
 </div> <h2>
 
 <div>Certificates</div>
 </h2>

 <div id="optional_extras">
 <h4>CPD Accredited e-Certificate</h4>
 
 Digital certificate -
 Included
 
 <h4>CPD Accredited Framed (Hardcopy) Certificate</h4>
 
 Hard copy certificate -
 Included
 
 <h4>Enrolment Letter</h4>
 
 Digital certificate -
 Included
 
 <h4>QLS Endorsed Hard Copy Certificate</h4>
 
 Hard copy certificate -
 Included
 
 <h4>Student ID Card</h4>
 
 Digital certificate -
 Included
 

 </div>

***Offer Ends Today***
Earn up to 40K as a 'DATA ANALYST' or Your 100% Money Back
Do you know that entry-level data analysts earn an average of £40,000 annually, with the potential to quickly earn six figures with experience and expertise? Are you looking to join the high-demand field of data analytics and earn a handsome salary? Our Data Analyst Job Ready Program is here to guide you all the way until you get the job you want.
Our Data Analyst Job Ready Program is your all-in-one solution to learn data analytics from scratch and also secure a job in this exciting industry. With our unique blend of comprehensive courses and career support, your dream job is within reach. We understand the challenges of transitioning into a new field, which is why our program is tailored to guide you every step of the way - from mastering core skills to landing your first job in data analytics. By choosing our Data Analyst Job Ready Program, you're not just gaining skills; you're gaining a lifelong career partner.
Our mission is simple - to be your trusted partner every step of the way, from Training to Employment.
Enrol Now and Kickstart Your Data Analytics Career. Don't miss this opportunity to transform your career with the Data Analyst Job Ready Program. With our comprehensive training, career support, and money-back guarantee, you're not just enrolling in a program; you're investing in a brighter future. Join us now and become a part of the next generation of data analysts!
In addition to teaching you the technical skills you need, we will also provide you with career mentoring and support. We will help you build your resume, prepare for interviews, and land your dream job. We also have partnerships with many companies that are hiring Data Analysts, so we can help you get the job you want.
If you are not happy with our service, we also offer a 100% money-back guarantee. So what are you waiting for? Enrol in our Data Analyst Job Ready Program today and start your journey to becoming a successful Data Analyst!
Why Choose Us?
So, what sets us apart from other programs? Let's dive into the exceptional benefits you'll experience when you join our Data Analyst Job Ready Program:
Personalised Guidance: Our experienced mentors will provide one-on-one counselling sessions tailored to your specific needs. Whether you're a beginner or have some experience, we will guide you towards honing your skills and developing a strong foundation in Business Analysis.
One-On-One Consultation Sessions with Experts: Gain invaluable insights and guidance from seasoned professionals who have thrived in the Data Analyst field.
Extensive Job Opportunities: We have established partnerships with numerous companies actively seeking Data analysts. Through our network, we'll connect you with exclusive job openings that are not easily accessible elsewhere.
Interview Preparation: We provide you with access to a comprehensive database of potential interview questions curated over years of industry experience. Walk into your interviews confident, well-prepared, and ready to impress.
100% Money-Back Guarantee: Your satisfaction is our top priority. We are confident in the quality of our training and support, which is why we offer a 100% money-back guarantee.
Courses we will provide once you enrol in the program:
Course 01: Introduction to Data Analysis
Course 02: Business and Data Analytics for Beginners
Course 03: Data Analytics with Tableau
Course 04: Quick Data Science Approach from Scratch
Course 05: Learn MySQL from Scratch for Data Science and Analytics
Course 06: SQL for Data Science, Data Analytics and Data Visualization
Course 07: Statistics & Probability for Data Science & Machine Learning
Course 08: Basic Google Data Studio
Course 09: R Programming for Data Science
Course 10: Python Data Science with Numpy, Pandas and Matplotlib
Course 11: Complete Python Machine Learning & Data Science Fundamentals
Course 12: 2021 Data Science & Machine Learning with R from A-Z
Course 13: Microsoft Excel Complete Course
Course 14: Microsoft Excel: Automated Dashboard Using Advanced Formula, VBA, Power Query
Course 15: Data Center Training Essentials: General Introduction
Course 16: Excel Data Analysis
Course 17: Data Entry Administrator Training
Course 18: SQL Masterclass: SQL For Data Analytics
Course 19: Business Data Analysis
Course 20: Master JavaScript with Data Visualization
How Can We Offer Job Guarantees?
HF Online provides consultancy, professional and educational services to many of the companies in the UK. During our intense exclusive training program, you will not just gain and complete the industry valuable certification but will gain industry experience as well, which is imperative to get your 1st job in the sector.
The Data Analyst Job Ready Program with Career Support & Money Back Guarantee is completed in 9 easy steps:
Step 1: Enrol in the Programme
Begin your exciting journey with us by enrolling in the Data and Business Intelligence Analyst Job Ready Program. Complete your registration and make a secure online payment. Remember, we offer a 14-day money-back guarantee if you're not completely satisfied.
After you enrol in the Program, you will get lifetime access to 6 premium courses related to Web Development. These courses will teach you the knowledge and skills required to become a successful Data and Business Intelligence Analyst. Our customer service team will help you and keep in contact with you every step of the way. So you won't have to worry about a thing!
Step 2: Initial One-On-One Counselling Session
Once enrolled, you will be paired with a dedicated career mentor. Schedule your first one-on-one session to discuss your career aspirations, skills, experience, and any areas for potential growth. This conversation will shape your learning and development path.
Step 3: Certification upon Course Completion
After learning from the courses, you must obtain certificates for each course. There will be exams for every course, and you have to pass them to get your certificate. To pass successfully, you must get 90% marks. Once you pass the exams, you will receive hardcopy certificates. These certificates will prove that you're an expert in the subject.
Step 4: CV Revamping
Our team of professionals will build you a compelling CV and LinkedIn profile. We'll ensure it presents your skills and qualifications effectively and is tailored to the needs and expectations of the finance industry. With these powerful tools in hand, you'll be fully prepared to tackle job interviews confidently.
Step 5: Building Network and Submitting CV
We understand the power of casting a wide net. We'll strategically submit your CV to various platforms and networks, expanding your reach and connecting you with valuable opportunities that align with your career goals. We will also make connections with many high-profile individuals and companies through your LinkedIn profile.
Step 6: Interview Preparation
With your CV ready, we'll move on to interview preparation. Gain exclusive access to our database of potential interview questions. Through simulated interviews with your mentor, you'll practice your responses and receive valuable feedback to further refine your skills.
Step 7: Securing Job Interviews
Leveraging our partnerships with leading companies, we'll secure job interviews for you. We'll ensure you get the opportunity to showcase your skills to potential employers and get the dream job you want.
Step 8: Post-Interview Support
Post-interview, we'll provide a debriefing session to reflect on your performance and identify areas of improvement for future interviews if necessary. Remember, our commitment extends until you land your dream job.
Step 9: Celebrate Your New Job!
Once you've secured your dream job in web development, it's time to celebrate! However, our support doesn't end there. We'll provide you with ongoing career advice to ensure you continue to thrive in your new role.
We're excited to accompany you on this journey to success. Enrol today, and let's get started! Your path to a successful Data and Business Intelligence Analyst career begins with us.
 CPD 
1000 CPD hours / points  Accredited by CPD Quality Standards
 Who is this course for? 
This Data Analyst Job Ready Program is perfect for:
Beginners eager to break into the field of data analytics and get a job.
Professionals looking to move their career towards data science.
Individuals seeking a comprehensive understanding of data analysis tools and techniques.
Those aiming for a career upgrade with advanced analytics skills.
Anyone interested in gaining practical, job-ready skills in data analytics and machine learning.
 Career path 
This Data Analyst Job Ready Program will help you get a job in different roles, such as:
Entry-Level Data Analyst: £25,000 - £35,000
Mid-Level Data Analyst: £35,000 - £60,000
Senior Data Analyst: £50,000 - £80,000
Data Scientist: £40,000 - £100,000
Data Analytics Manager: £60,000 - £100,000
Business Intelligence Analyst: £30,000 - £75,000
Machine Learning Engineer: £45,000 - £80,000
 Certificates 
CPD Accredited e-Certificate
 Digital certificate - Included 
CPD Accredited Framed (Hardcopy) Certificate
 Hard copy certificate - Included 
Enrolment Letter
 Digital certificate - Included 
QLS Endorsed Hard Copy Certificate
 Hard copy certificate - Included 
Student ID Card
 Digital certificate - Included 

Academy for Health and Fitness

Business Analytics & Intelligence

Data Engineering

Big Data Analytics

Data Science

HR Analytics

Data Analyst

Data Analyst Job Guarantee Program with Career Support & Money Back Guarantee

<div id="course-pills-1">Duration4 Days24 CPD hoursThis course is intended forThe App Maker builds solutions to simplify, automate, and transform tasks and processes for themselves and their team where they have deep expertise in the solution business domain. They have basic data modeling, user experience design, requirements analysis, and process analysis skills. The App Maker creates and enforces business processes, structures digital collection of information, improves efficiency of repeatable tasks, and automates business processes. The App Maker uses the Maker tools of Power Platform to solve business problems. They may use advanced features of Microsoft apps and third-party productivity tools. The App Maker is aware of the capabilities and limitations of available tools and understands how to apply them. The App Maker is self-directed, and solution focused. They may not have formal IT training but are comfortable using technology to solve business problems with a personal growth mindset. They understand the operational need and have a vision of the desired outcome. They approach problems with phased and iterative strategies.This course will teach you how to build apps with low-code techniques to simplify, automate, and transform business tasks and processes using Microsoft Power Platform. This course contains a 1-day Applied Workshop. This workshop will allow you to practice your App Maker skills by creating an end-to-end solution to solve a problem for a fictitious company. The solution will include a Microsoft Dataverse database, Power Apps canvas app, and Power Automate flows.</div><div id="course-pills-2"><h3>1 - Get started with Microsoft Power Platform for app makers</h3> <ul> <li>Identify components</li> <li>Create apps</li> <li>Get started with Microsoft Dataverse</li> <li>Work with Copilot in Microsoft Power Platform</li> </ul> <h3>2 - Create tables in Dataverse</h3> <ul> <li>Table characteristics</li> <li>Table relationships</li> <li>Dataverse logic and security</li> <li>Dataverse auditing</li> <li>Dual-write vs. virtual tables</li> </ul> <h3>3 - Create and manage columns within a table in Dataverse</h3> <ul> <li>Define columns in Microsoft Dataverse</li> <li>Column types in Microsoft Dataverse</li> <li>Add a column to a table</li> <li>Primary name column</li> <li>Restrictions that apply to columns in a table</li> <li>Create an auto numbering column</li> <li>Create an alternate key</li> </ul> <h3>4 - Load/export data and create data views in Dataverse</h3> <ul> <li>View data in a table</li> <li>Create or edit views of data in a table</li> <li>Dataverse data import options</li> <li>Load data into a table</li> <li>Dataverse data export options</li> <li>Export</li> <li>Add, update, or delete data in a table by using Excel</li> <li>Import data using Power Query</li> </ul> <h3>5 - Export data from Dataverse and use Microsoft Excel to edit records</h3> <ul> <li>Export data to Excel</li> <li>Edit and update data in Excel</li> </ul> <h3>6 - Get started with Microsoft Dataverse for Teams</h3> <ul> <li>Dataverse for Teams vs Dataverse</li> <li>Provision your first Dataverse environment</li> <li>Create your first table to store data</li> </ul> <h3>7 - Build your first app with Power Apps and Dataverse for Teams</h3> <ul> <li>Create your first app with the hero template</li> <li>Customize your app with Power Apps Studio</li> <li>Publish your app</li> <li>Install template apps</li> </ul> <h3>8 - Build your first workflow with Power Automate and Dataverse for Teams</h3> <ul> <li>Types of workflows that Power Automate can build in Dataverse</li> <li>Schedule a flow</li> </ul> <h3>9 - Create reports with Power BI and Dataverse for Teams</h3> <ul> <li>Connect to and transform Dataverse for Teams data from Power BI</li> <li>Create a Power BI report</li> <li>Publish the report</li> <li>Share the data</li> </ul> <h3>10 - Get started building with Power BI</h3> <ul> <li>Use Power BI</li> <li>Building blocks of Power BI</li> <li>Tour and use the Power BI service</li> </ul> <h3>11 - Explore what Power BI can do for you</h3> <ul> <li>What can I do with the Power BI service as a consumer?</li> <li>View content in the Power BI service</li> <li>Collaborate and share in Power BI</li> <li>Find and view dashboards and reports</li> </ul> <h3>12 - Create and manage workspaces in Power BI</h3> <ul> <li>Distribute a report or dashboard</li> <li>Monitor usage and performance</li> <li>Recommend a development life cycle strategy</li> <li>Troubleshoot data by viewing its lineage</li> <li>Configure data protection</li> </ul> <h3>13 - Manage semantic models in Power BI</h3> <ul> <li>Use a Power BI gateway to connect to on-premises data sources</li> <li>Configure a semantic model scheduled refresh</li> <li>Configure incremental refresh settings</li> <li>Manage and promote semantic models</li> <li>Troubleshoot service connectivity</li> <li>Boost performance with query caching (Premium)</li> </ul> <h3>14 - Create dashboards in Power BI</h3> <ul> <li>Configure data alerts</li> <li>Explore data by asking questions</li> <li>Review Quick insights</li> <li>Add a dashboard theme</li> <li>Pin a live report page to a dashboard</li> <li>Configure a real-time dashboard</li> <li>Set mobile view</li> </ul> <h3>15 - Implement row-level security</h3> <ul> <li>Configure row-level security with the static method</li> <li>Configure row-level security with the dynamic method</li> </ul> <h3>16 - Create dashboards in Power BI</h3> <ul> <li>Configure data alerts</li> <li>Explore data by asking questions</li> <li>Review Quick insights</li> <li>Add a dashboard theme</li> <li>Pin a live report page to a dashboard</li> <li>Configure a real-time dashboard</li> <li>Set mobile view</li> </ul> <h3>17 - Secure, publish, and share data in Power BI</h3> <ul> <li>Share and use reports in Power BI</li> <li>Row-level security</li> <li>Publish a report to a Power BI workspace</li> <li>Share reports and user experience</li> <li>Protect data in Power BI</li> <li>Data refresh and alerts</li> </ul> <h3>18 - Embed Power BI content</h3> <ul> <li>Embed Power BI reports</li> <li>Embed other Power BI content types</li> <li>Optimize the embedding experience</li> </ul> <h3>19 - How to build your first model-driven app with Dataverse</h3> <ul> <li>Model-driven apps, powered by Microsoft Dataverse</li> <li>Explore sample apps</li> </ul> <h3>20 - Get started with model-driven apps in Power Apps</h3> <ul> <li>Introducing model-driven apps</li> <li>Components of model-driven apps</li> <li>Design model-driven apps</li> <li>Incorporate business process flows</li> </ul> <h3>21 - Configure forms, charts, and dashboards in model-driven apps</h3> <ul> <li>Forms overview</li> <li>Form elements</li> <li>Configure multiple forms</li> <li>Use specialized form components</li> <li>Configure views overview</li> <li>Configure grids</li> <li>Create and edit views</li> <li>Configure charts overview</li> <li>Dashboards overview</li> <li>Use interactive streams and tiles</li> </ul> <h3>22 - Manage Dynamics 365 model-driven app settings and security</h3> <ul> <li>Configure role-based security</li> <li>Manage teams and business units</li> <li>Explore settings and customizations</li> </ul> <h3>23 - Use specialized components in a model-driven form</h3> <ul> <li>Create business process flows</li> <li>Embed a canvas app in a model-driven form</li> <li>Add a timeline in a model-driven form</li> <li>Create a report in a model-driven form</li> </ul> <h3>24 - Get started with Power Apps canvas apps</h3> <ul> <li>Start Power Apps</li> <li>Power Apps data sources</li> <li>Use Power Apps with Power Automate and Power BI</li> <li>Designing a Power Apps app</li> </ul> <h3>25 - Customize a canvas app in Power Apps</h3> <ul> <li>Improve your app by making basic customizations</li> <li>Explore controls and screens in canvas apps</li> </ul> <h3>26 - How to build the User Interface in a canvas app in Power Apps</h3> <ul> <li>Use themes to quickly change the appearance of your app</li> <li>Brand a control</li> <li>Icons</li> <li>Images</li> <li>Personalization</li> <li>Build for phones or tablets</li> </ul> <h3>27 - Navigation in a canvas app in Power Apps</h3> <ul> <li>Understanding navigation</li> <li>The Navigate and Back functions</li> <li>More ways to use the Navigate function</li> </ul> <h3>28 - Manage apps in Power Apps</h3> <ul> <li>Power Apps review</li> </ul> <h3>29 - Build a mobile-optimized app from Power Apps</h3> <ul> <li>Learn about mobile-optimized apps</li> <li>Identify components to make a canvas app mobile-optimized</li> <li>Create a mobile-optimized app that uses responsive designs</li> <li>Identify performance considerations for a mobile-optimized canvas app</li> </ul> <h3>30 - Use and understand Controls in a canvas app in Power Apps</h3> <ul> <li>Core properties of controls</li> <li>Entering and displaying data with text controls</li> <li>Additional controls for enhancing your app's usability</li> <li>Media</li> <li>Modern controls</li> <li>Work with component libraries</li> </ul> <h3>31 - Create formulas to change properties in a Power Apps canvas app</h3> <ul> <li>Formulas overview</li> <li>Use a formula to modify the format of controls</li> <li>Use formulas to perform calculations</li> <li>Use a control to modify the property of other controls</li> <li>Conditional formatting</li> <li>Functions for validating data</li> </ul> <h3>32 - Use imperative development techniques for canvas apps in Power Apps</h3> <ul> <li>Imperative versus declarative development</li> <li>The three types of variables in Power Apps</li> <li>Global variables</li> <li>Contextual variables</li> <li>Collections</li> <li>Additional variable concepts</li> </ul> <h3>33 - Manage apps in Power Apps</h3> <ul> <li>Power Apps review</li> </ul> <h3>34 - Create formulas to change properties in a Power Apps canvas app</h3> <ul> <li>Formulas overview</li> <li>Use a formula to modify the format of controls</li> <li>Use formulas to perform calculations</li> <li>Use a control to modify the property of other controls</li> <li>Conditional formatting</li> <li>Functions for validating data</li> </ul> <h3>35 - Create formulas to change behaviors in a Power Apps canvas app</h3> <ul> <li>Formulas and functionality</li> <li>Understanding true and false</li> <li>Understanding control behaviors and actions</li> <li>Performing multiple actions in a formula</li> <li>Control the display mode through a formula</li> <li>Use controls and functions to create a dynamic formula</li> </ul> <h3>36 - Author a basic formula that uses tables and records in a Power Apps canvas app</h3> <ul> <li>Records and tables</li> <li>Using the Table function</li> <li>Store a table</li> <li>Filter your table</li> <li>Use the lookup function to return a record</li> <li>Additional table functions</li> </ul> <h3>37 - Build a canvas app for a real estate solution with Copilot in Power Apps</h3><h3>38 - Get started with Power Automate</h3> <ul> <li>Introducing Power Automate</li> <li>Create your first flow</li> <li>Troubleshoot flows</li> </ul> <h3>39 - Build approval flows with Power Automate</h3> <ul> <li>Provide solutions to real-world scenarios.</li> </ul> <h3>40 - Build flows to manage user information</h3><h3>41 - Power Automate's deep integration across multiple data sources</h3><h3>42 - Use the Admin center to manage environments and data policies in Power Automate</h3> <ul> <li>Administer flows</li> <li>Export and import flows</li> <li>Learn how to distribute button flows</li> </ul> <h3>43 - Use AI Builder in Power Automate</h3> <ul> <li>AI Builder in Power Automate saves time</li> <li>Advanced usage of AI Builder in Power Automate</li> </ul> <h3>44 - Optimize your business process with process advisor</h3> <ul> <li>Get familiar with process advisor</li> <li>Create your first recording</li> <li>Edit recordings and group actions</li> <li>Analyze recordings and interpret results</li> <li>Automation recommendations</li> </ul> <h3>45 - Optimize your business process with process advisor</h3> <ul> <li>Get familiar with process advisor</li> <li>Create your first recording</li> <li>Edit recordings and group actions</li> <li>Analyze recordings and interpret results</li> <li>Automation recommendations</li> </ul> <h3>46 - Build flows for a real estate solution using Copilot in Power Automate</h3> <ul> <li>When to use Copilot in Power Automate</li> </ul> <h3>47 - Use Dataverse triggers and actions in Power Automate</h3> <ul> <li>Dataverse triggers</li> <li>Query data</li> <li>Create, update, delete, and relate actions</li> </ul> <h3>48 - Create tables in Dataverse</h3> <ul> <li>Table characteristics</li> <li>Table relationships</li> <li>Dataverse logic and security</li> <li>Dataverse auditing</li> <li>Dual-write vs. virtual tables</li> </ul> <h3>49 - Create and manage columns within a table in Dataverse</h3> <ul> <li>Define columns in Microsoft Dataverse</li> <li>Column types in Microsoft Dataverse</li> <li>Add a column to a table</li> <li>Primary name column</li> <li>Restrictions that apply to columns in a table</li> <li>Create an auto numbering column</li> <li>Create an alternate key</li> </ul> <h3>50 - Get started with Power Apps canvas apps</h3> <ul> <li>Start Power Apps</li> <li>Power Apps data sources</li> <li>Use Power Apps with Power Automate and Power BI</li> <li>Designing a Power Apps app</li> </ul> <h3>51 - How to build the User Interface in a canvas app in Power Apps</h3> <ul> <li>Use themes to quickly change the appearance of your app</li> <li>Brand a control</li> <li>Icons</li> <li>Images</li> <li>Personalization</li> <li>Build for phones or tablets</li> </ul> <h3>52 - Get started with Power Automate</h3> <ul> <li>Introducing Power Automate</li> <li>Create your first flow</li> <li>Troubleshoot flows</li> </ul> <h3>53 - Challenge Project - Build a booking requests app with Power Apps and Power Automate</h3> <ul> <li>Prepare</li> </ul></div>

Nexus Human

Microsoft Power Apps

Power Apps

Microsoft Power BI

Microsoft Power Platform

Power Automate

Microsoft Power Automate

PL-100T00 Microsoft Power Platform App Maker

<h2>Microsoft Excel® in Depth (Virtual)</h2>
 This practical course provides a solid background of the features of Excel and a deeper understanding of its features, benefits and uses.This is not a beginner's course in Excel. You will learn some advanced features such as Pivot Tables, Charting, Tables, Sorting, Filtering and Functions.
 The goal of this course is to provide a deeper understanding of Excel and its intricacies and a new ability to use it efficiently producing the best solutions for your projects.<h3>What you will Learn</h3>
 You'll learn how to:
 <ul>
 <li>Use functions like IF, AVERAGE, SUMIF, SUMIFS, SUMPRODUCT, INDEX, MATCH, CHOOSE, DATE, and many more</li>
 <li>Create meaningful charts</li>
 <li>Use pivot tables</li>
 <li>Use Conditional Formatting, Data Validation</li>
 <li>Take advantage of using Named ranges, do sorting, filtering, tables</li>
 </ul>

IIL Europe Ltd

Microsoft Excel in Depth (Virtual)

London

<h2>Microsoft Excel® in Depth: In-House Training</h2>
 The goal of this course is to provide a deeper understanding of Excel and its intricacies and a new ability to use it efficiently producing the best solutions for your projects.
 This practical course provides a solid background of the features of Excel and a deeper understanding of its features, benefits and uses. This is not a beginner's course in Excel. You will learn some advanced features such as Pivot Tables, Charting, Tables, Sorting, Filtering and Functions.
 The goal of this course is to provide a deeper understanding of Excel and its intricacies and a new ability to use it efficiently producing the best solutions for your projects.<h3>What you Will Learn</h3> 
 You'll learn how to: 
 <ul> 
 <li>Use functions like IF, AVERAGE, SUMIF, SUMIFS, SUMPRODUCT, INDEX, MATCH, CHOOSE, DATE, and many more</li> 
 <li>Create meaningful charts</li> 
 <li>Use pivot tables</li> 
 <li>Use Conditional Formatting, Data Validation</li> 
 <li>Take advantage of using Named ranges, do sorting, filtering, tables</li> 
 </ul><section>
 <h3>Getting Started</h3> 
 <ul> 
 <li>The building blocks of Excel, built-in functions, will be examined</li> 
 <li>The basics of formatting your data will be examined</li> 
 <li>Shortcuts and data manipulation will be explored</li> 
 <li>Built-in features like those mentioned in the 'What you will learn' section above will be explored in detail</li> 
 </ul> 
 Excel Functions - VLOOKUP, IF, INDEX, MATCH, CHOOSE, SUMIF, SUMIFS, SUMPRODUCT, DATE, so many more 
 <h3>Using Named ranges, Data Validation, Sorting, and Filtering</h3> 
 <ul> 
 <li>Learn the Name manager;</li> 
 <li>Learn the difference between local and global names;</li> 
 <li>Ensure correct access to linked workbooks;</li> 
 <li>Ensure data accuracy;</li> 
 <li>Learn how to use cascading data validation (for example, once a user chooses 'cars', another cell allows only Ford, Toyota, etc.);</li> 
 <li>Sorting by more than 3 fields;</li> 
 <li>Filtering by font, pattern, or value;</li> 
 <li>See your data based on things like dates in the 3rd quarter, or fields where quantity x price is greater than some fixed value</li> 
 </ul> 
 <h3>Conditional formatting and data formatting</h3> 
 <ul> 
 <li>Make relevant data stand out</li> 
 <li>Isolate highs and lows</li> 
 <li>Make error cells invisible</li> 
 <li>Learn about Data bars, Icon sets, and Color scales</li> 
 <li>Highlight differences between worksheets</li> 
 <li>Learn all the codes in the Format/Number list</li> 
 <li>Using cell Styles</li> 
 <li>Learn all about alignment, protection, borders, colors and more</li> 
 </ul> 
 <h3>Pivot Tables</h3> 
 <ul> 
 <li>Learn how to summarize large amounts of data with a few clicks</li> 
 <li>Learn various ways of presenting the data</li> 
 <li>Learn the various pivot table tools</li> 
 <li>Learn how to customize and format a pivot table to suit your needs</li> 
 <li>Learn how to group data</li> 
 <li>Learn how to use the various options to present your data</li> 
 </ul> 
 <h3>Charts</h3> 
 <ul> 
 <li>Learn how to create a chart with one keystroke!</li> 
 <li>Learn the 11 types of built-in charts</li> 
 <li>Learn how to create a chart with one keystroke!</li> 
 <li>Learn how to customize the charts to make the information tell the right story</li> 
 <li>Learn how to use the design, layout, and formatting available to charts in Excel 2007</li> 
 <li>Learn embedded charts versus chart sheets</li> 
 <li>Learn how to use modify all the pieces of a chart</li> 
 </ul> 
 <h3>Array formulas</h3> 
 <ul> 
 <li>Learn how to use the most powerful formulas in Excel</li> 
 <li>Learn how to combine many formulas into one compact array-formula</li> 
 <li>Learn the real power of these formulas and why regular formulas can't do the job</li> 
 <li>Learn how to use built-in array formulas, like TREND or TRANSPOSE</li> 
 </ul>


 </section>

Microsoft Excel in Depth: In-House Training

<h2>Microsoft Excel® in Depth: Virtual In-House Training</h2>
 The goal of this course is to provide a deeper understanding of Excel and its intricacies and a new ability to use it efficiently producing the best solutions for your projects.
 This practical course provides a solid background of the features of Excel and a deeper understanding of its features, benefits and uses. This is not a beginner's course in Excel. You will learn some advanced features such as Pivot Tables, Charting, Tables, Sorting, Filtering and Functions.
 The goal of this course is to provide a deeper understanding of Excel and its intricacies and a new ability to use it efficiently producing the best solutions for your projects.<h3>What you Will Learn</h3>
 You'll learn how to:
 <ul>
 <li>Use functions like IF, AVERAGE, SUMIF, SUMIFS, SUMPRODUCT, INDEX, MATCH, CHOOSE, DATE, and many more</li>
 <li>Create meaningful charts</li>
 <li>Use pivot tables</li>
 <li>Use Conditional Formatting, Data Validation</li>
 <li>Take advantage of using Named ranges, do sorting, filtering, tables</li>
 </ul><section>
 <h3>Getting Started</h3> 
 <ul> 
 <li>The building blocks of Excel, built-in functions, will be examined</li> 
 <li>The basics of formatting your data will be examined</li> 
 <li>Shortcuts and data manipulation will be explored</li> 
 <li>Built-in features like those mentioned in the 'What you will learn' section above will be explored in detail</li> 
 </ul> 
 Excel Functions - VLOOKUP, IF, INDEX, MATCH, CHOOSE, SUMIF, SUMIFS, SUMPRODUCT, DATE, so many more 
 <h3>Using Named ranges, Data Validation, Sorting, and Filtering</h3> 
 <ul> 
 <li>Learn the Name manager;</li> 
 <li>Learn the difference between local and global names;</li> 
 <li>Ensure correct access to linked workbooks;</li> 
 <li>Ensure data accuracy;</li> 
 <li>Learn how to use cascading data validation (for example, once a user chooses 'cars', another cell allows only Ford, Toyota, etc.);</li> 
 <li>Sorting by more than 3 fields;</li> 
 <li>Filtering by font, pattern, or value;</li> 
 <li>See your data based on things like dates in the 3rd quarter, or fields where quantity x price is greater than some fixed value</li> 
 </ul> 
 <h3>Conditional formatting and data formatting</h3> 
 <ul> 
 <li>Make relevant data stand out</li> 
 <li>Isolate highs and lows</li> 
 <li>Make error cells invisible</li> 
 <li>Learn about Data bars, Icon sets, and Color scales</li> 
 <li>Highlight differences between worksheets</li> 
 <li>Learn all the codes in the Format/Number list</li> 
 <li>Using cell Styles</li> 
 <li>Learn all about alignment, protection, borders, colors and more</li> 
 </ul> 
 <h3>Pivot Tables</h3> 
 <ul> 
 <li>Learn how to summarize large amounts of data with a few clicks</li> 
 <li>Learn various ways of presenting the data</li> 
 <li>Learn the various pivot table tools</li> 
 <li>Learn how to customize and format a pivot table to suit your needs</li> 
 <li>Learn how to group data</li> 
 <li>Learn how to use the various options to present your data</li> 
 </ul> 
 <h3>Charts</h3> 
 <ul> 
 <li>Learn how to create a chart with one keystroke!</li> 
 <li>Learn the 11 types of built-in charts</li> 
 <li>Learn how to create a chart with one keystroke!</li> 
 <li>Learn how to customize the charts to make the information tell the right story</li> 
 <li>Learn how to use the design, layout, and formatting available to charts in Excel 2007</li> 
 <li>Learn embedded charts versus chart sheets</li> 
 <li>Learn how to use modify all the pieces of a chart</li> 
 </ul> 
 <h3>Array formulas</h3> 
 <ul> 
 <li>Learn how to use the most powerful formulas in Excel</li> 
 <li>Learn how to combine many formulas into one compact array-formula</li> 
 <li>Learn the real power of these formulas and why regular formulas can't do the job</li> 
 <li>Learn how to use built-in array formulas, like TREND or TRANSPOSE</li> 
 </ul>


 </section>

Microsoft Excel in Depth: Virtual In-House Training

OverviewThe eight 1/2 day Support Manager course is uniquely created to provide training on the fundamentals of management relative to the support environment, and to enhance the inherent skills and knowledge of the support manager. This course focuses specifically on the most common management elements that occur in the technical support centre including, managing customer satisfaction, operations and team performance management and facilitating a team while managing a dynamic service product. This course offers support managers the opportunity to develop and refine their technology support leadership skills enabling them to effectively manage the challenges of the most complex support centres.Who Should AttendThe Support Manager course is for managers who have at least six months management experience and have received some basic management training.RequirementsThe course begins with a review and quiz on a set of pre-class reading materials. These materials are sent to each participant two weeks prior to the class start date. Participants are strongly encouraged to register at least two weeks in advance to allow time to complete these pre-class assignments.Each participant is required to bring the pre-class reading materials as well as a notebook computer with a USB port and with Microsoft Excel, Word and PowerPoint installed. These will be used as tools during the course. All other materials and tools will be provided.Homework is assigned for most evenings of the course. Please plan for study time outside of class.Some of the training objectives&hellip;<ul fr-original-style=" color: rgb(115, 126, 134);" style="color: rgb(115, 126, 134); box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">Manage dynamics of change within the support centre</li><li fr-original-style="" style="box-sizing: border-box;">Enhance leadership skills</li><li fr-original-style="" style="box-sizing: border-box;">Effective staff utilisation</li><li fr-original-style="" style="box-sizing: border-box;">Increase support centre morale and retention</li></ul>

SGSA Limited

Support Manager

Begin your journey towards a rewarding and successful career by enrolling in our all-inclusive bundle of 8 Microsoft Teams, Microsoft Outlook &amp; Microsoft Excel courses. At UKHF Online, we have carefully selected and combined these courses to equip you with the vital skills and knowledge necessary to thrive in Microsoft Teams, Microsoft Outlook &amp; Microsoft Excel. Whether you're a student, recent graduate, or job seeker, our Microsoft Teams, Microsoft Outlook &amp; Microsoft Excel bundle is designed to enhance your CV, impress potential employers, and set you apart from the competition.Key Features of the Microsoft Teams, Microsoft Outlook &amp; Microsoft Excel Bundle:<ul><li>3 QLS-Endorsed Courses: We proudly offer 3 QLS-endorsed courses within our Microsoft Teams, Microsoft Outlook &amp; Microsoft Excel bundle, providing you with industry-recognized qualifications. Plus, you'll receive a free hardcopy certificate for each of these courses.</li><ul><li>QLS Course 01: Microsoft Teams - Master Microsoft Teams</li><li> QLS Course 02: The Complete Microsoft Outlook Masterclass</li><li> QLS Course 03: New Functions in Microsoft Excel 2021</li></ul></ul><ul><li>5 CPD QS Accredited Courses: Additionally, our bundle includes 5 relevant CPD QS accredited courses, ensuring that you stay up-to-date with the latest industry standards and practices.</li><ul><li>Course 01: Microsoft Excel Complete Course 2019</li><li>Course 02: Microsoft Office 2016 Advanced</li><li>Course 03: Microsoft Access Databases Forms and Reports</li><li>Course 04: Microsoft Word Advanced</li><li>Course 05: Outlook Tips and tricks</li></ul></ul><ul><li>In Addition, you'll get Five Career Boosting Courses absolutely FREE with this Bundle.</li><ul><li>Course 01: Professional CV Writing</li><li>Course 02: Job Search Skills</li><li>Course 03: Self Esteem &amp; Confidence Building</li><li>Course 04: Professional Diploma in Stress Management</li><li>Course 05: Complete Communication Skills Master Class</li></ul></ul><ul><li>Convenient Online Learning: Our Microsoft Teams, Microsoft Outlook &amp; Microsoft Excel courses are accessible online, allowing you to learn at your own pace and from the comfort of your own home.</li></ul>Learning Outcomes of the Microsoft Teams, Microsoft Outlook &amp; Microsoft Excel Bundle:<ul><li>Master the foundational principles and techniques of Microsoft Teams, Microsoft Outlook &amp; Microsoft Excel.</li><li>Develop advanced proficiency in Microsoft Teams, Microsoft Outlook &amp; Microsoft Excel methodologies and strategies.</li><li>Acquire in-depth knowledge of the latest trends and advancements in Microsoft Teams, Microsoft Outlook &amp; Microsoft Excel.</li><li>Enhance your problem-solving and critical thinking abilities within the context of Microsoft Teams, Microsoft Outlook &amp; Microsoft Excel.</li><li>Cultivate strong communication and collaboration skills essential for success in Microsoft Teams, Microsoft Outlook &amp; Microsoft Excel.</li></ul> The Microsoft Teams, Microsoft Outlook &amp; Microsoft Excel bundle is a comprehensive collection of courses that have been meticulously designed to provide you with a well-rounded education in Microsoft Teams, Microsoft Outlook &amp; Microsoft Excel. With a combination of 3 QLS-endorsed courses and 5 CPD QS-accredited courses, this bundle offers you the perfect balance of essential knowledge and valuable skills. What's more, we are proud to offer free hardcopy certificates for each course within the Microsoft Teams, Microsoft Outlook &amp; Microsoft Excel bundle, giving you the recognition you deserve. <h2>
 
 <div>CPD</div>
 </h2>

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

 <div id="who_is_this_course_for">
 <ul><li>Professionals who want to improve their skills in Microsoft Office applications</li><li>Individuals who want to enhance their problem-solving and analytical skills</li><li>Anyone looking to develop their career in a business or administrative role</li></ul>
 </div> <h2>
 
 <div>Career path</div>
 </h2>

 <div id="career_path">
 <ul><li>Administrative Assistant: £17,000 - £30,000 per year</li><li>Business Analyst: £25,000 - £60,000 per year</li><li>Data Analyst: £22,000 - £48,000 per year</li><li>Operations Manager: £24,000 - £70,000 per year</li><li>Project Manager: £25,000 - £70,000 per year</li></ul>
 </div> <h2>
 
 <div>Certificates</div>
 </h2>

 <div id="optional_extras">
 <h4> Digital certificate</h4>
 
 Digital certificate -
 Included
 
 <h4> Hard copy certificate</h4>
 
 Hard copy certificate -
 Included
 

 </div>

QLS Endorsed Diploma! Free 3 QLS Certificates + Free 10 CPD Course & Assessments> 250 CPD Points > Lifetime Access

Begin your journey towards a rewarding and successful career by enrolling in our all-inclusive bundle of 8 Microsoft Teams, Microsoft Outlook & Microsoft Excel courses. At UKHF Online, we have carefully selected and combined these courses to equip you with the vital skills and knowledge necessary to thrive in Microsoft Teams, Microsoft Outlook & Microsoft Excel. Whether you're a student, recent graduate, or job seeker, our Microsoft Teams, Microsoft Outlook & Microsoft Excel bundle is designed to enhance your CV, impress potential employers, and set you apart from the competition.
Key Features of the Microsoft Teams, Microsoft Outlook & Microsoft Excel Bundle:
3 QLS-Endorsed Courses: We proudly offer 3 QLS-endorsed courses within our Microsoft Teams, Microsoft Outlook & Microsoft Excel bundle, providing you with industry-recognized qualifications. Plus, you'll receive a free hardcopy certificate for each of these courses.
QLS Course 01: Microsoft Teams - Master Microsoft Teams
QLS Course 02: The Complete Microsoft Outlook Masterclass
QLS Course 03: New Functions in Microsoft Excel 2021
5 CPD QS Accredited Courses: Additionally, our bundle includes 5 relevant CPD QS accredited courses, ensuring that you stay up-to-date with the latest industry standards and practices.
Course 01: Microsoft Excel Complete Course 2019
Course 02: Microsoft Office 2016 Advanced
Course 03: Microsoft Access Databases Forms and Reports
Course 04: Microsoft Word Advanced
Course 05: Outlook Tips and tricks
In Addition, you'll get Five Career Boosting Courses absolutely FREE with this Bundle.
Course 01: Professional CV Writing
Course 02: Job Search Skills
Course 03: Self Esteem & Confidence Building
Course 04: Professional Diploma in Stress Management
Course 05: Complete Communication Skills Master Class
Convenient Online Learning: Our Microsoft Teams, Microsoft Outlook & Microsoft Excel courses are accessible online, allowing you to learn at your own pace and from the comfort of your own home.
Learning Outcomes of the Microsoft Teams, Microsoft Outlook & Microsoft Excel Bundle:
Master the foundational principles and techniques of Microsoft Teams, Microsoft Outlook & Microsoft Excel.
Develop advanced proficiency in Microsoft Teams, Microsoft Outlook & Microsoft Excel methodologies and strategies.
Acquire in-depth knowledge of the latest trends and advancements in Microsoft Teams, Microsoft Outlook & Microsoft Excel.
Enhance your problem-solving and critical thinking abilities within the context of Microsoft Teams, Microsoft Outlook & Microsoft Excel.
Cultivate strong communication and collaboration skills essential for success in Microsoft Teams, Microsoft Outlook & Microsoft Excel.
The Microsoft Teams, Microsoft Outlook & Microsoft Excel bundle is a comprehensive collection of courses that have been meticulously designed to provide you with a well-rounded education in Microsoft Teams, Microsoft Outlook & Microsoft Excel. With a combination of 3 QLS-endorsed courses and 5 CPD QS-accredited courses, this bundle offers you the perfect balance of essential knowledge and valuable skills. What's more, we are proud to offer free hardcopy certificates for each course within the Microsoft Teams, Microsoft Outlook & Microsoft Excel bundle, giving you the recognition you deserve.
 CPD 
250 CPD hours / points  Accredited by CPD Quality Standards
 Who is this course for? 
Professionals who want to improve their skills in Microsoft Office applications
Individuals who want to enhance their problem-solving and analytical skills
Anyone looking to develop their career in a business or administrative role
 Career path 
Administrative Assistant: £17,000 - £30,000 per year
Business Analyst: £25,000 - £60,000 per year
Data Analyst: £22,000 - £48,000 per year
Operations Manager: £24,000 - £70,000 per year
Project Manager: £25,000 - £70,000 per year
 Certificates 
Digital certificate
 Digital certificate - Included 
Hard copy certificate
 Hard copy certificate - Included 

Microsoft Teams

Microsoft 365

Microsoft Office

Microsoft AZ-303

QLS Endorsed Diploma! Free 3 QLS Certificates + Free 10 CPD Course & Assessments> 250 CPD Points > Lifetime Access

Microsoft Teams, Microsoft Outlook & Microsoft Excel

<div id="course-pills-1">Duration1 Days6 CPD hoursThis course is intended forThis course is primarily designed for students who want to gain the skills necessary to use VBA to automate tasks in Excel such as collecting data from external sources, cleaning, and manipulating data. The target student may also want to learn how to create custom worksheet functions to streamline worksheet formulas and make complex worksheets easier to support, maintain, and understand.OverviewIdentify general components of VBA and their appropriate use in solving business solutions. Record VBA macros to automate repetitive tasks. Write VBA code to create VBA subroutines and functions. Use various programming elements to solve problems through code, including variables,objects, conditional statements, and loops. Eliminate, avoid, or handle errors in VBA code, and optimize its performance.VBA (Visual Basic for Applications) enables you to enhance and extend the capabilities of Microsoft Excel and other applications in the Microsoft 365 application suite. You can use VBA to perform tasks that would be difficult or impossible to do using only worksheet functions, and you can automate a wide range of tasks so they can be performed faster, more consistently, and with less effort than performing them manually. This course will give you a good foundation for understanding, creating, and using VBA in your own Excel workbooks. You will learn how to use the macro recorder effectively, as well as how to write your own VBA code from scratch. You will use tools built into Excel to explore and learn VBA's capabilities and to optimize and debug your code.PrerequisitesTo ensure your success in this course, you should be an experienced Excel user who is comfortable creating and working with Excel workbooks, including tasks such as entering worksheet formulas, using absolute and relative addressing, formatting cells, and creating pivot tables and charts. This level of skill could be acquired by taking the Microsoft Excel for Office 365 (Desktop or Online) courses, Parts 1, 2, and 3.</div><div id="course-pills-2"><h3>1. Using VBA to Solve Business Problems</h3><ul> <li>Use Macros to Automate Tasks in Excel</li> <li>Identify Components of Macro-Enabled Workbooks</li> <li>Configure the Excel VBA Environment</li></ul> <h3>2. Recording a Macro</h3><ul> <li>Use the Macro Recorder to Create a VBA Macro</li> <li>Record a Macro with Relative Addressing</li> <li>Delete Macros and Modules</li> <li>Identify Strategies for Using the Macro Recorder</li></ul> <h3>3. Writing VBA Code Directly</h3><ul> <li>Write VBA Code</li> <li>Discover Objects You Can Use</li> <li>Create a Custom Function</li></ul> <h3>4. Solving Problems through Code</h3><ul> <li>Make Decisions in Code</li> <li>Work with Variables</li> <li>Perform Repetitive Tasks</li></ul> <h3>5. Improving Your VBA Code</h3><ul> <li>Debug VBA Errors</li> <li>Deal with Errors</li> <li>Improve Macro Performance</li></ul> <h3>6. Controlling How and When Macros Run</h3><ul> <li>Prompt the User for Information</li> <li>Configure Macros to Run Automatically</li></ul></div><div id="course-pills-3"><h4>Additional course details:</h4> Nexus Humans VBA with Microsoft Excel (v1.2) training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. 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 VBA with Microsoft Excel (v1.2) course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you. 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>

Visual Basic

Access VBA

Visual Basic Analysis

Microsoft Virtual Academy (MVA)

VBA with Microsoft Excel

<section style="color: rgb(33, 37, 41); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(33, 37, 41);"><h2 style="color: rgb(62, 57, 52); box-sizing: border-box;" fr-original-style=" color: rgb(62, 57, 52);">About this Virtual Instructor Led Training (VILT)</h2>This&nbsp;intermediate level 5 half-day Virtual Instructor Led Training (VILT) course&nbsp;is a comprehensive course that explains the technology of shell and tube heat exchangers as these robust types of heat exchangers are the most commonly used in the process and refinery industries where they provide flexibility and are easy to maintain.The VILT course will provide details on the thermal and mechanical design, fabrication, inspection and maintenance in relation with international standards such as TEMA, API and ISO. For this heat exchanger type, the focus is on the mechanical and practical aspects.Many case studies will be presented to demonstrate failures and mismatches. The thermal and mechanical design is conducted using sophisticated computer software and this VILT course is intended to complement thermal design training based on HTRI software. Participants will be offered problem case studies in order to reach solutions on their own.To get a full picture of proven (advanced) heat transfer technologies, a basic training module for other types of heat exchangers is included. Besides Air Cooled, there will be a discussion on compact heat exchangers in more detail with all their pros and cons.Participants are advised to bring a scientific calculator and laptop with Microsoft Excel installed.</section><section style="color: rgb(33, 37, 41); box-sizing: border-box;" fr-original-style=" color: rgb(33, 37, 41);"><a data-toggle="collapse" href="https://petroedgeasia.net/training/tema-htri-heat-exchanger-design-cost-saving-management-virtual-instructor-led-training-vilt/#collapseOne" style="color: rgb(51, 51, 51); user-select: auto; font-size: var(--font-size); box-sizing: border-box; cursor: pointer; text-decoration: inherit;" fr-original-style=" color: rgb(51, 51, 51);">TRAINING OBJECTIVES</a><div data-parent="#accordion" fr-original-style="" style="box-sizing: border-box;">By the end of this VILT course, participants will be equipped on the following:<ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">For engineers, this VILT course will provide a broad understanding of the technology and an excellent base for further learning.</li><li fr-original-style="" style="box-sizing: border-box;">For those responsible for thermal design, TEMA type selection, the training is intended to illustrate the interaction between the thermal and mechanical design, the understanding of which will lead to more reliable design outcomes.</li><li fr-original-style="" style="box-sizing: border-box;">For those coming from an operating environment, the VILT course will lead to a greater knowledge of the maintenance, inspection and repair needs of shell and tube heat exchangers, including information on common causes of failure. Solutions will be offered using the latest &ldquo;state of art&rdquo; technologies used to prevent fouling, tube vibration and throughput limitations.</li></ul></div><a data-toggle="collapse" href="https://petroedgeasia.net/training/tema-htri-heat-exchanger-design-cost-saving-management-virtual-instructor-led-training-vilt/#collapseTwo" style="color: rgb(51, 51, 51); user-select: auto; font-size: var(--font-size); box-sizing: border-box; cursor: pointer; text-decoration: inherit;" fr-original-style=" color: rgb(51, 51, 51);">TARGET AUDIENCE</a><div data-parent="#accordion" fr-original-style="" style="box-sizing: border-box;">This VILT course is intended for professionals who want to improve the performance of heat exchanger in their company for shell and tube and compact types and include:<ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">Mechanical Engineers</li><li fr-original-style="" style="box-sizing: border-box;">Design Engineers</li><li fr-original-style="" style="box-sizing: border-box;">Maintenance Engineers</li><li fr-original-style="" style="box-sizing: border-box;">Instrument Engineers</li><li fr-original-style="" style="box-sizing: border-box;">Project Engineers</li><li fr-original-style="" style="box-sizing: border-box;">Process Engineers</li><li fr-original-style="" style="box-sizing: border-box;">Heat Transfer Engineers</li><li fr-original-style="" style="box-sizing: border-box;">Plant Engineers</li><li fr-original-style="" style="box-sizing: border-box;">Operation Engineers</li></ul></div><a data-toggle="collapse" href="https://petroedgeasia.net/training/tema-htri-heat-exchanger-design-cost-saving-management-virtual-instructor-led-training-vilt/#collapsecl" style="color: rgb(51, 51, 51); user-select: auto; font-size: var(--font-size); box-sizing: border-box; cursor: pointer; text-decoration: inherit;" fr-original-style=" color: rgb(51, 51, 51);">COURSE LEVEL</a><div data-parent="#accordion" fr-original-style="" style="box-sizing: border-box;"><ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">Intermediate</li></ul></div><a data-toggle="collapse" href="https://petroedgeasia.net/training/tema-htri-heat-exchanger-design-cost-saving-management-virtual-instructor-led-training-vilt/#collapseThree" style="color: rgb(51, 51, 51); user-select: auto; font-size: var(--font-size); box-sizing: border-box; cursor: pointer; text-decoration: inherit;" fr-original-style=" color: rgb(51, 51, 51);">TRAINING METHODS</a><div data-parent="#accordion" fr-original-style="" style="box-sizing: border-box;">This VILT course will be delivered online in&nbsp;5 half-day sessions comprising 4 hours per day, with 2 breaks of 10 minutes per day.Course Duration: 5 half-day sessions, 4 hours per session (20 hours in total).</div><a data-toggle="collapse" href="https://petroedgeasia.net/training/tema-htri-heat-exchanger-design-cost-saving-management-virtual-instructor-led-training-vilt/#collapseFive" style="color: rgb(51, 51, 51); user-select: auto; font-size: var(--font-size); box-sizing: border-box; cursor: pointer; text-decoration: inherit;" fr-original-style=" color: rgb(51, 51, 51);">TRAINER</a><div data-parent="#accordion" fr-original-style="" style="box-sizing: border-box;">Your expert course leader has almost 40 years of experience in Heat Exchanger Technologies. He is an international expert in heat exchanger type selection, special thermal/hydraulic design and latest enhanced heat transfer technologies. He conducts many training courses in this area and more than 1,000 employees, representing more than 250 companies, have attended his courses.Additional Positions &amp; Credentials<ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">Former Chairman and Founder of HTRI&rsquo;s first Communication Committee: CC-Holland</li><li fr-original-style="" style="box-sizing: border-box;">CC-Holland (Chairman 1994 &ndash; 1997; Member 2004 &ndash; Present)</li><li fr-original-style="" style="box-sizing: border-box;">Chairman of NLAHX SenterNovem Working Party (1999 &ndash; 2010)</li><li fr-original-style="" style="box-sizing: border-box;">Member of ESDU Crude Oil Fouling Working Party (1999 &ndash; 2003)</li><li fr-original-style="" style="box-sizing: border-box;">Guest Lecturer Technical University Twente &amp; Eindhoven, The Netherlands</li><li fr-original-style="" style="box-sizing: border-box;">Guest Lecturer HTRI European Seminar October (2004 &amp; 2005)</li><li fr-original-style="" style="box-sizing: border-box;">Member of the Tasc-Force Committee ISO 16812</li><li fr-original-style="" style="box-sizing: border-box;">HTRI&rsquo;s Representative for The Netherlands (2008 &ndash; 2013)</li><li fr-original-style="" style="box-sizing: border-box;">Senior Fellow Heat Exchangers at BECHT</li></ul>Publications<ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">Reduced Total Life Cycle Costs Using Helixchanger Heat Exchangers and Enhancement Technology for the Process Industries (Co-Author, Davos, Switzerland July, 2001)</li><li fr-original-style="" style="box-sizing: border-box;">Reduced Total Life Cycle Costs Using Helixchanger Heat Exchangers (Co-Author, Hamilton, Canada, October, 2003)</li><li fr-original-style="" style="box-sizing: border-box;">Most frequently used Heat Exchangers from pioneering research to application worldwide (Co-Author, Prague, Czech Republic, October, 2004)</li></ul>Previous Clients Include:<ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">BP</li><li fr-original-style="" style="box-sizing: border-box;">TOTAL</li><li fr-original-style="" style="box-sizing: border-box;">ExxonMobil</li><li fr-original-style="" style="box-sizing: border-box;">Shell Global Solutions</li><li fr-original-style="" style="box-sizing: border-box;">BASF</li><li fr-original-style="" style="box-sizing: border-box;">Technip</li><li fr-original-style="" style="box-sizing: border-box;">Aker Kvaerner</li><li fr-original-style="" style="box-sizing: border-box;">AKZO</li><li fr-original-style="" style="box-sizing: border-box;">Stamicarbon</li><li fr-original-style="" style="box-sizing: border-box;">FLUOR</li><li fr-original-style="" style="box-sizing: border-box;">Worley</li></ul></div><a data-toggle="collapse" href="https://petroedgeasia.net/training/tema-htri-heat-exchanger-design-cost-saving-management-virtual-instructor-led-training-vilt/#collapseCS" style="color: rgb(51, 51, 51); user-select: auto; font-size: var(--font-size); box-sizing: border-box; cursor: pointer; text-decoration: inherit;" fr-original-style=" color: rgb(51, 51, 51);">POST TRAINING COACHING SUPPORT (OPTIONAL)</a><div data-parent="#accordion" fr-original-style="" style="box-sizing: border-box;">To further optimise your learning experience from our courses, we also offer individualized &ldquo;One to One&rdquo; coaching support for 2 hours post training. We can help improve your competence in your chosen area of interest, based on your learning needs and available hours. This is a great opportunity to improve your capability and confidence in a particular area of expertise. It will be delivered over a secure video conference call by one of our senior trainers. They will work with you to create a tailor-made coaching program that will help you achieve your goals faster. <a href="mailto:info@asiaedge.net?subject=Request%20for%20further%20information%20regarding%20post%20training%20coaching%20support" target="_blank" rel="noopener" style="color: rgb(0, 123, 255); user-select: auto; font-size: var(--font-size); box-sizing: border-box; cursor: pointer; text-decoration: inherit;" fr-original-style=" color: rgb(0, 123, 255);">Request for further information about post training coaching support</a>&nbsp;and fees applicable for this.</div></section>

EnergyEdge - Training for a Sustainable Energy Future

Maintenance

Acquire in-depth knowledge of heat exchanger design and cost-saving management with EnergyEdge's TEM & HTRI course. Join our virtual instructor-led training to stay ahead in the industry.

844 Courses

Linear Regression Analysis in Microsoft Excel

By Study Plex

Book-Keeping (Bookkeeper Training) Course

By One Education

Ultimate Microsoft Office (Word, Powerpoint, Outlook, Excel) Diploma Course

By One Education

Leadership & Management

By John Academy

Level 2 Certificate in Customer Service

By John Academy

Top 50 MS Excel Advanced Tips to Upgrade Skill to next Level

By John Academy

Career Developing Skills

By John Academy

Advanced Excel Models using Formulas, VBA & Power Query

By John Academy

ChatGPT Masterclass

By RapidEDX

Microsoft PowerPoint 2016/2019/365 - Foundations for Beginners

By Study Plex

Search By Location