Name: Microsoft Excel - Spreadsheet for Beginners Course
Price: 12 GBP
Availability: InStock

<h3><strong>Overview</strong></h3>
This comprehensive course on <strong>Microsoft Excel: Master Power Query in 120 Minutes!</strong> will deepen your understanding <span>on this topic.</span>

After successful completion of this course you can acquire the required skills in this sector. This <strong>Microsoft Excel: Master Power Query in 120 Minutes!</strong> comes with accredited certification which will enhance your CV and make you worthy in the job market.

So enrol in this course today to fast track your career ladder.
<h3><strong>How will I get my certificate?</strong></h3>
You may have to take a quiz or a written test online during or after the course. After successfully completing the course, you will be eligible for the certificate.
<h3><strong>Who is this course for?</strong></h3>
There is no experience or previous qualifications required for enrolment on this <strong>Microsoft Excel: Master Power Query in 120 Minutes!</strong>. It is available to all students, of all academic backgrounds.
<h3><strong>Requirements</strong></h3>
Our <strong>Microsoft Excel: Master Power Query in 120 Minutes!</strong> is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible on tablets and smartphones so you can access your course on wifi, 3G or 4G.

There is no time limit for completing this course, it can be studied in your own time at your own pace.
<h3><strong>Career path</strong></h3>
Having these various qualifications will increase the value in your CV and open you up to multiple sectors such as Business &amp; Management, Admin, Accountancy &amp; Finance, Secretarial &amp; PA, Teaching &amp; Mentoring etc. <h3>Course Curriculum</h3><div><p>1 sections • 25 lectures • 02:25:00 total length</p></div><div><div><div><div><div><div><div><p>•Power Query Intro and Excel version: 00:03:00</p></div><div><div><p>•Excel Power Query - Introduction: 00:03:00</p></div><div><div><p>•Excel Power Query - Query Editor Ribbon: 00:09:00</p></div><div><div><p>•Transform Data - Trim in Excel Power Query: 00:05:00</p></div><div><div><p>•Transform Data - Format Dates and Values in Excel Power Query: 00:02:00</p></div><div><div><p>•Transform Data - Parsing URLs in Excel Power Query: 00:05:00</p></div><div><div><p>•Transform Data - Split Text Fields in Excel Power Query: 00:10:00</p></div><div><div><p>•Transform Data - Group By in Excel Power Query: 00:03:00</p></div><div><div><p>•Transform Data - Unpivoting Columns in Excel Power Query: 00:05:00</p></div><div><div><p>•Transform Data - Pivoting Columns in Excel Power Query: 00:02:00</p></div><div><div><p>•Transform Data - Split Columns into Other Columns in Excel Power Query: 00:04:00</p></div><div><div><p>•Transform Data - Filtering Rows in Excel Power Query: 00:05:00</p></div><div><div><p>•Transform Data - Sorting Columns in Excel Power Query: 00:02:00</p></div><div><div><p>•Transform Data - Transform and Add Columns in Excel Power Query: 00:07:00</p></div><div><div><p>•From Folder - Import From Folder in Excel Power Query: 00:07:00</p></div><div><div><p>•From Folder - Doing Auto Cleanup in Excel Power Query: 00:13:00</p></div><div><div><p>•From Folder - Extract Data from Forms in Excel Power Query: 00:13:00</p></div><div><div><p>•From Workbook - Extract Multiple Criteria in Excel Power Query: 00:05:00</p></div><div><div><p>•From Workbook - Extract Multiple Worksheets in Excel Power Query: 00:04:00</p></div><div><div><p>•Joins - Intro to Joins: 00:04:00</p></div><div><div><p>•Joins - Merging: 00:08:00</p></div><div><div><p>•Joins - Full Outer Join: 00:06:00</p></div><div><div><p>•Joins - Right Anti Join: 00:09:00</p></div><div><div><p>•Power Query - Convert Reports into Pivot Tables: 00:05:00</p></div><div><div><p>•Modulo: 00:06:00</p></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div>

Apex Learning

Microsoft Certification

Microsoft Power Apps

Microsoft Power BI

Power Query

Microsoft Power Platform

Microsoft Excel

Microsoft Excel: Master Power Query in 120 Minutes!

General Admission

<h3><strong>Overview</strong></h3>
This comprehensive course on <strong>Microsoft Excel: Automated Dashboard Using Advanced Formula, VBA, Power Query </strong>will deepen your understanding <span>on this topic.</span>

After successful completion of this course you can acquire the required skills in this sector. This <strong>Microsoft Excel: Automated Dashboard Using Advanced Formula, VBA, Power Query</strong> comes with accredited certification which will enhance your CV and make you worthy in the job market.

So enrol in this course today to fast track your career ladder.
<h3><strong>How will I get my certificate?</strong></h3>
You may have to take a quiz or a written test online during or after the course. After successfully completing the course, you will be eligible for the certificate.
<h3><strong>Who is this course for?</strong></h3>
There is no experience or previous qualifications required for enrolment on this <strong>Microsoft Excel: Automated Dashboard Using Advanced Formula, VBA, Power Query</strong>. It is available to all students, of all academic backgrounds.
<h3><strong>Requirements</strong></h3>
Our <strong>Microsoft Excel: Automated Dashboard Using Advanced Formula, VBA, Power Query</strong> is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible on tablets and smartphones so you can access your course on wifi, 3G or 4G.

There is no time limit for completing this course, it can be studied in your own time at your own pace.
<h3><strong>Career path</strong></h3>
Having these various qualifications will increase the value in your CV and open you up to multiple sectors such as Business &amp; Management, Admin, Accountancy &amp; Finance, Secretarial &amp; PA, Teaching &amp; Mentoring etc. <h3>Course Curriculum</h3><div><p>12 sections • 76 lectures • 06:08:00 total length</p></div><div><div><div><div><div><div><div><p>•Course Outline and Introduction: 00:04:00</p></div><div><div><p>•Minimum Requirements for the Course: 00:01:00</p></div><div><div><p>•Prepayments Introduction: 00:01:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Month End Date Prepaid Expenses Amortization Calculation: 00:00:00</p></div><div><div><p>•Exact Prepaid Expenses Payment Date Calculation: 00:00:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Prepaid Expenses Accounting Definition: Prepayments: 00:03:00</p></div><div><div><p>•Prepaid Expense Example: How Accounting works for Prepayments: 00:03:00</p></div><div><div><p>•Advantages and Disadvantages of Prepaid Expenses: 00:03:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Introduction to PRO Excel Models and Formulas: 00:06:00</p></div><div><div><p>•Date Function: 00:05:00</p></div><div><div><p>•EOMONTH Function: 00:04:00</p></div><div><div><p>•DATEVALUE function: 00:03:00</p></div><div><div><p>•IF Function: 00:08:00</p></div><div><div><p>•IFS Function (Office 365 Only): 00:07:00</p></div><div><div><p>•VLOOKUP Function: 00:07:00</p></div><div><div><p>•MATCH Function: 00:05:00</p></div><div><div><p>•INDIRECT Function: 00:02:00</p></div><div><div><p>•NAMED Ranges: Name Manager: 00:03:00</p></div><div><div><p>•Advanced Version of VLOOKUP Function: 00:07:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Introduction to Model and Control Panel Tab (Important Sheet Tab): 00:08:00</p></div><div><div><p>•Formula Based Prepaid Expenses Model - Deep Dive (Part 1): 00:05:00</p></div><div><div><p>•Formula Based Prepaid Expenses Model - Deep Dive (Part 2): 00:06:00</p></div><div><div><p>•Formula Based Prepaid Expenses Model - Deep Dive (Part 3): 00:06:00</p></div><div><div><p>•IFS Function - Month End date Prepayment calculation: 00:04:00</p></div><div><div><p>•Prepaid Expenses - Closing Balance Summary Tab (Formula Based Summary): 00:09:00</p></div><div><div><p>•Protecting Formulas Cells and Fields in the Model: 00:04:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Exact Date Prepaid Amortisation calculation Intro: 00:03:00</p></div><div><div><p>•Formulas update and Model Changes for Exact Prepaid Exps Calculation: 00:03:00</p></div><div><div><p>•Formulas Update for Exact Date Prepaid Exps Amortisation (Part 1): 00:04:00</p></div><div><div><p>•Formulas Update for Exact Date Prepaid Exps Amortisation (Part 2): 00:03:00</p></div><div><div><p>•Formulas Update for Exact Date Prepaid Exps Amortisation (Part 3): 00:02:00</p></div><div><div><p>•Formulas Update for Exact Date Prepaid Exps Amortisation (Part 4): 00:07:00</p></div><div><div><p>•IFS Function - Exact Date Prepayments Amortisation: 00:04:00</p></div><div><div><p>•Data Validation Controls (Enhancing Data Input Controls with Protection): 00:10:00</p></div><div><div><p>•Bonus: Prepayment Model with Opening Balance Calculation (Part 1): 00:08:00</p></div><div><div><p>•Bonus: Prepayment Model with Opening Balance Calculation (Part 2): 00:09:00</p></div><div><div><p>•Additional Material: Resources: 00:00:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Power Query and Pivot Table Prepayment Summary Table Intro: 00:06:00</p></div><div><div><p>•What is Power Query and Some Awesome Resources for Power Query learning: 00:07:00</p></div><div><div><p>•Power Query and Pivot Table Summary - Deep Dive (Part 1): 00:05:00</p></div><div><div><p>•Power Query and Pivot Table Summary - Deep Dive (Part 2): 00:04:00</p></div><div><div><p>•Power Query and Pivot Table Summary - Deep Dive (Part 3): 00:05:00</p></div><div><div><p>•Power Query and Pivot Table Summary - Deep Dive (Part 4): 00:09:00</p></div><div><div><p>•Using Array Formulas to Add Formula Protection: 00:04:00</p></div><div><div><p>•Bonus: Allocate Prepaid Expenditure Cost Centre Wise - 1: 00:02:00</p></div><div><div><p>•Bonus: Allocate Prepaid Expenditure Cost Centre Wise - 2: 00:08:00</p></div><div><div><p>•Bonus: Prepayment Model with Opening Balance Calculation (PQ and PT Version): 00:13:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Changing Macros Security in Excel: 00:05:00</p></div><div><div><p>•Complete Walkthrough - Advanced VBA Prepaid Expenses Amortisation Model: 00:06:00</p></div><div><div><p>•Bonus : New Version - Excel VBA Model for Prepayment Expenditure: 00:08:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Dynamic Dashboard Overview: 00:07:00</p></div><div><div><p>•Importing Profit and Loss Statements Source Files and creating YTD P&amp;L Sheets: 00:08:00</p></div><div><div><p>•Creating Dynamic Data Validation: 00:02:00</p></div><div><div><p>•Creating Named Ranges for Dynamic Table Arrays: 00:03:00</p></div><div><div><p>•Dynamic Date Column Headings for each Divisional PL Table: 00:02:00</p></div><div><div><p>•Dynamic Month and YTD Dashboard tables headings (PRO TIP): 00:03:00</p></div><div><div><p>•Dynamic VLOOKUP Formula - Preparing First section of the Dashboard: 00:04:00</p></div><div><div><p>•Creating Rolling Dashboard with Dynamic VLOOKUP Function: 00:08:00</p></div><div><div><p>•IMPORTANT : Error Checking for your reports/Dashboard (PRO TIP): 00:03:00</p></div><div><div><p>•Data Prep for Visualization: AREA Charts (Awesome trick using #NA Function): 00:05:00</p></div><div><div><p>•Visualization: AREA Charts for Month - Revenue, Gross Profit and Net Profit: 00:05:00</p></div><div><div><p>•Visualization DONUT Charts Revenue, Gross Profit and Net Profit (Part 1): 00:03:00</p></div><div><div><p>•Visualization DONUT Charts Revenue, Gross Profit and Net Profit (Part 2): 00:06:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Introduction - Formula-less Dashboard - Fully Dynamic and easily refreshed: 00:05:00</p></div><div><div><p>•Understanding the data files before building dashboard: 00:02:00</p></div><div><div><p>•Consolidating Reports with Power Query (Get &amp; Transform) , How to install PQ: 00:08:00</p></div><div><div><p>•Dynamic File Path Trick in Power Query with Parameters (Amazing trick): 00:06:00</p></div><div><div><p>•Conditional Cumulative totals with SUMIFS Function: 00:04:00</p></div><div><div><p>•Bonus: Conditional Cumulative totals with Power Query Custom Formula (M Code): 00:06:00</p></div><div><div><p>•Dashboard Creation - Pivot Table showing Month and YTD KPIs division wise: 00:06:00</p></div><div><div><p>•Dashboard Creation Donuts Charts linked with Pivot Table (Replicate Charts fast): 00:08:00</p></div><div><div><p>•Dashboard Creation - Line Charts: 00:08:00</p></div><div><div><p>•Update Dashboard with Additional Divisional Data with Few Click (Magical): 00:03:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Thank you: 00:02:00</p></div><div><div><p>•Ultimate Prepaid Expenditure Model (Super Bonus): 00:02:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Resources - Microsoft Excel: Automated Dashboard Using Advanced Formula, VBA, Power Query: 00:00:00</p></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div>

Online Course Marketing

Finance Cert & Exam Prep

Online Course Creation

Certification in Cash & Voucher Assistant (CVA)

Practical Accounting

Microsoft Excel: Automated Dashboard Using Advanced Formula, VBA, Power Query

<div>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<p>The course 'Microsoft Excel' covers the latest features of Microsoft Excel 2019, introducing learners to CONCAT, IFS, MAXIFS, MINIFS, SWITCH, TEXTJOIN, Map Chart, Funnel Chart, and other enhancements. It also covers fundamental Excel skills, data analysis, visualization, pivot tables, workbook management, and automation using VBA.</p>
<h3><strong>Learning Outcomes:</strong></h3>
<ol>
<li>Familiarize with the new features in Microsoft Excel 2019, including CONCAT, IFS, MAXIFS, MINIFS, SWITCH, and more.</li>
<li>Gain proficiency in basic Excel tasks like navigating the user interface, entering data, and using Excel commands.</li>
<li>Perform calculations, create formulas, and use functions to analyze and manipulate data effectively.</li>
<li>Format worksheets, apply conditional formatting, and utilize templates to present data professionally.</li>
<li>Understand data visualization using charts, sparklines, and mapping techniques in Excel.</li>
<li>Work with PivotTables and PivotCharts for in-depth data analysis and presentation.</li>
<li>Learn advanced Excel features such as data validation, scenarios, and Goal Seek.</li>
<li>Automate workbook functionality using macros and Visual Basic for Applications (VBA).</li>
<li>Collaborate on workbooks, protect data, and apply security measures in Excel.</li>
<li>Create and work with Excel templates to streamline repetitive tasks and optimize workflow.</li>
</ol>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
<h3><b>Why buy this Microsoft Excel?</b></h3>
<ol>
<li>Unlimited access to the course for forever</li>
<li><b><strong>PDF</strong> Certificate, Transcript, student ID</b> all included in the price</li>
<li>Absolutely no hidden fees</li>
<li>Directly receive <b>CPD </b>accredited qualifications after course completion</li>
<li>Receive one to one assistance on every weekday from professionals</li>
<li>Immediately receive the PDF certificate after passing</li>
<li>Receive the original copies of your certificate and transcript on the next working day</li>
<li>Easily learn the skills and knowledge from the comfort of your home</li>
</ol>
<h3><b>Certification</b></h3>
<p>After studying the course materials of the <b>Microsoft Excel</b> you will be able to take the MCQ test that will assess your knowledge. After successfully passing the test you will be able to claim the pdf certificate for £5.99. Original Hard Copy certificates need to be ordered at an additional cost of £9.60.</p>
<h3><b>Who is this course for?</b></h3>
<p>This <b>Microsoft Excel </b>does not require you to have any prior qualifications or experience. You can just enrol and start learning.</p>
<h3><b>Prerequisites</b></h3>
<p>This <b>Microsoft Excel </b>was made by professionals and it is compatible with all PC's, Mac's, tablets and smartphones. You will be able to access the course from anywhere at any time as long as you have a good enough internet connection.</p>
<h3><b>Career path</b></h3>
<p>As this course comes with multiple courses included as bonus, you will be able to pursue multiple occupations. This <b>Microsoft Excel </b>is a great way for you to gain multiple skills from the comfort of your home.</p><div>
				<h3>
	<span>Course Curriculum</span>
</h3>

<div>
<table width="100%">				<tbody><tr>
					<td colspan="4">Microsoft Excel 2019 New Features</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Introduction to Microsoft Excel 2019 New Features</td>
					<td> </td>
					<td><span><i></i> 00:07:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>CONCAT</td>
					<td> </td>
					<td><span><i></i> 00:02:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>IFS</td>
					<td> </td>
					<td><span><i></i> 00:01:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>MAXIFS</td>
					<td> </td>
					<td><span><i></i> 00:01:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>MINIFS</td>
					<td> </td>
					<td><span><i></i> 00:01:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>SWITCH</td>
					<td> </td>
					<td><span><i></i> 00:02:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>TEXTJOIN</td>
					<td> </td>
					<td><span><i></i> 00:01:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Map Chart</td>
					<td> </td>
					<td><span><i></i> 00:02:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Funnel Chart</td>
					<td> </td>
					<td><span><i></i> 00:01:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Better Visuals</td>
					<td> </td>
					<td><span><i></i> 00:06:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Pivot Table Enhancements</td>
					<td> </td>
					<td><span><i></i> 00:02:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Power Pivot Updates</td>
					<td> </td>
					<td><span><i></i> 00:01:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Getting Started with Microsoft Office Excel </td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Navigate the Excel User Interface</td>
					<td> </td>
					<td><span><i></i> 00:28:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Use Excel Commands</td>
					<td> </td>
					<td><span><i></i> 00:10:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Create and Save a Basic Workbook</td>
					<td> </td>
					<td><span><i></i> 00:19:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Enter Cell Data</td>
					<td> </td>
					<td><span><i></i> 00:12:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Use Excel Help</td>
					<td> </td>
					<td><span><i></i> 00:05:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Performing Calculations</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Create Worksheet Formulas</td>
					<td> </td>
					<td><span><i></i> 00:15:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Insert Functions</td>
					<td> </td>
					<td><span><i></i> 00:17:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Reuse Formulas and Functions</td>
					<td> </td>
					<td><span><i></i> 00:17:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Modifying a Worksheet</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Insert, Delete, and Adjust Cells, Columns, and Rows</td>
					<td> </td>
					<td><span><i></i> 00:10:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Search for and Replace Data</td>
					<td> </td>
					<td><span><i></i> 00:09:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Use Proofing and Research Tools</td>
					<td> </td>
					<td><span><i></i> 00:07:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Formatting a Worksheet</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Apply Text Formats</td>
					<td> </td>
					<td><span><i></i> 00:16:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Apply Number Format</td>
					<td> </td>
					<td><span><i></i> 00:08:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Align Cell Contents</td>
					<td> </td>
					<td><span><i></i> 00:09:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Apply Styles and Themes</td>
					<td> </td>
					<td><span><i></i> 00:12:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Apply Basic Conditional Formatting</td>
					<td> </td>
					<td><span><i></i> 00:11:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Create and Use Templates</td>
					<td> </td>
					<td><span><i></i> 00:08:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Printing Workbooks</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Preview and Print a Workbook</td>
					<td> </td>
					<td><span><i></i> 00:10:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Set Up the Page Layout</td>
					<td> </td>
					<td><span><i></i> 00:09:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Configure Headers and Footers</td>
					<td> </td>
					<td><span><i></i> 00:07:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Managing Workbooks</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Manage Worksheets</td>
					<td> </td>
					<td><span><i></i> 00:05:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Manage Workbook and Worksheet Views</td>
					<td> </td>
					<td><span><i></i> 00:07:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Manage Workbook Properties</td>
					<td> </td>
					<td><span><i></i> 00:06:00</span></td>
				</tr>
								<tr>
					<td colspan="4"> Working with Functions</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Work with Ranges</td>
					<td> </td>
					<td><span><i></i> 00:18:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Use Specialized Functions</td>
					<td> </td>
					<td><span><i></i> 00:11:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Work with Logical Functions</td>
					<td> </td>
					<td><span><i></i> 00:23:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Work with Date &amp; Time Functions</td>
					<td> </td>
					<td><span><i></i> 00:08:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Work with Text Functions</td>
					<td> </td>
					<td><span><i></i> 00:11:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Working with Lists</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Sort Data</td>
					<td> </td>
					<td><span><i></i> 00:10:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Filter Data</td>
					<td> </td>
					<td><span><i></i> 00:10:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Query Data with Database Functions</td>
					<td> </td>
					<td><span><i></i> 00:09:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Outline and Subtotal Data</td>
					<td> </td>
					<td><span><i></i> 00:09:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Analyzing Data</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Apply Intermediate Conditional Formatting</td>
					<td> </td>
					<td><span><i></i> 00:07:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Apply Advanced Conditional Formatting</td>
					<td> </td>
					<td><span><i></i> 00:05:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Visualizing Data with Charts</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Create Charts</td>
					<td> </td>
					<td><span><i></i> 00:13:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Modify and Format Charts</td>
					<td> </td>
					<td><span><i></i> 00:12:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Use Advanced Chart Features</td>
					<td> </td>
					<td><span><i></i> 00:12:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Using PivotTables and PivotCharts</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Create a PivotTable</td>
					<td> </td>
					<td><span><i></i> 00:13:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Analyze PivotTable Data</td>
					<td> </td>
					<td><span><i></i> 00:12:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Present Data with PivotCharts</td>
					<td> </td>
					<td><span><i></i> 00:07:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Filter Data by Using Timelines and Slicers</td>
					<td> </td>
					<td><span><i></i> 00:11:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Working with Multiple Worksheets and Workbooks</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Use Links and External References</td>
					<td> </td>
					<td><span><i></i> 00:12:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Use 3-D References</td>
					<td> </td>
					<td><span><i></i> 00:06:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Consolidate Data</td>
					<td> </td>
					<td><span><i></i> 00:05:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Using Lookup Functions and Formula Auditing</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Use Lookup Functions</td>
					<td> </td>
					<td><span><i></i> 00:12:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Trace Cells</td>
					<td> </td>
					<td><span><i></i> 00:09:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Watch and Evaluate Formulas</td>
					<td> </td>
					<td><span><i></i> 00:08:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Sharing and Protecting Workbooks</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Collaborate on a Workbook</td>
					<td> </td>
					<td><span><i></i> 00:19:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Protect Worksheets and Workbooks</td>
					<td> </td>
					<td><span><i></i> 00:08:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Automating Workbook Functionality</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Apply Data Validation</td>
					<td> </td>
					<td><span><i></i> 00:13:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Search for Invalid Data and Formulas with Errors</td>
					<td> </td>
					<td><span><i></i> 00:04:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Work with Macros</td>
					<td> </td>
					<td><span><i></i> 00:18:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Creating Sparklines and Mapping Data</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Create Sparklines</td>
					<td> </td>
					<td><span><i></i> 00:07:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>MapData</td>
					<td> </td>
					<td><span><i></i> 00:07:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Forecasting Data</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Determine Potential Outcomes Using Data Tables</td>
					<td> </td>
					<td><span><i></i> 00:08:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Determine Potential Outcomes Using Scenarios</td>
					<td> </td>
					<td><span><i></i> 00:09:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Use the Goal Seek Feature</td>
					<td> </td>
					<td><span><i></i> 00:04:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Forecasting Data Trends</td>
					<td> </td>
					<td><span><i></i> 00:05:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Excel VBA Data Management</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Create a Macro Using the Macro Recorder</td>
					<td> </td>
					<td><span><i></i> 01:00:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Edit a Macro</td>
					<td> </td>
					<td><span><i></i> 01:00:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Debug a Macro</td>
					<td> </td>
					<td><span><i></i> 00:30:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Customize the Quick Access Toolbar and Hotkeys</td>
					<td> </td>
					<td><span><i></i> 00:30:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Set Macro Security</td>
					<td> </td>
					<td><span><i></i> 01:00:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Insert Text</td>
					<td> </td>
					<td><span><i></i> 00:30:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Format Text</td>
					<td> </td>
					<td><span><i></i> 00:30:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Sort Data</td>
					<td> </td>
					<td><span><i></i> 00:30:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Duplicate Data</td>
					<td> </td>
					<td><span><i></i> 01:00:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Generate a Report</td>
					<td> </td>
					<td><span><i></i> 01:00:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Determine the Dialog Box Type</td>
					<td> </td>
					<td><span><i></i> 00:15:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Capture User Input</td>
					<td> </td>
					<td><span><i></i> 01:00:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Insert, Copy, and Delete Worksheets</td>
					<td> </td>
					<td><span><i></i> 00:30:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Rename Worksheets</td>
					<td> </td>
					<td><span><i></i> 00:30:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Modify the Order of Worksheets</td>
					<td> </td>
					<td><span><i></i> 00:15:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Print Worksheets</td>
					<td> </td>
					<td><span><i></i> 00:30:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Create User-Defined Functions</td>
					<td> </td>
					<td><span><i></i> 00:30:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Automate SUM Functions</td>
					<td> </td>
					<td><span><i></i> 00:30:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Activities and Exercise Files - Microsoft Excel 2016 and VBA</td>
					<td> </td>
					<td><span><i></i> 00:00:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Excel Templates</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Excel Templates</td>
					<td> </td>
					<td><span><i></i> 00:00:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Mock Exam</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Mock Exam - Microsoft Excel</td>
					<td> </td>
					<td><span><i></i> 00:20:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Final Exam</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Final Exam - Microsoft Excel</td>
					<td> </td>
					<td><span><i></i> 00:20:00</span></td>
				</tr>
				</tbody></table></div>

			</div>

Studyhub UK

Microsoft 365

Microsoft AZ-900

Microsoft Office

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

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

</div>

Course Gate

Office Skills & Productivity

Computing Skills

Computer Skills

Professional Skills Course (PSC)

Trainers Course

Powerful Functions in Microsoft Excel

<p>Did you know that over 800 million individuals have Microsoft Excel on their computers, but the majority of them have no idea how to use it? Improve your efficiency and productivity at work by becoming proficient with Microsoft Excel's robust tools and features. Sign up to our Microsoft Excel course and begin your journey to Excel mastery!</p><p>Our Microsoft Excel training covers everything, from fundamental Microsoft Excel navigation and data manipulation to sophisticated data analysis and visualisation methods. Our knowledgeable instructors will walk you through every step of the process, whether you're a beginner or want to develop your Microsoft Excel skills.</p><p>After successfully completing this Microsoft Excel course, you will gain the following knowledge and skills -</p><ul><li>Discover the basics of using Microsoft Excel</li><li>Be able to conduct computations in Microsoft Excel</li><li>Understand how to change and format spreadsheets</li><li>Learn everything there is to know about workbooks, including how to secure them</li><li>Be able to perform functions of Microsoft Excel.</li><li>Get familiar with using lists, statistics, charts, and tables, among other things</li><li>Ability to analyse and visualise microsoft excel data utilising Excel's comprehensive functionalities</li><li>Learn how to map data and make sparklines</li><li>Acquire in-depth information regarding forecasting data</li></ul><p>Unlock the full potential of Microsoft Excel with our comprehensive Microsoft Excel course!</p><p><strong>Key Features</strong></p><ul><li>CPD Accredited</li><li>Quality Licence Scheme Endorsed</li><li>Certificate Available upon course completion</li></ul><p>Enrol in Microsoft Excel course today and become an expert in MS Excel, increasing your job perspectives and earning potential.</p><p><strong>Curriculum Breakdown:</strong></p><ul><li>Module 01: Microsoft Excel 2019 New Features</li><li>Module 02: Getting Started with Microsoft Excel Online</li><li>Module 03: Performing Calculations</li><li>Module 04: Modifying a Worksheet</li><li>Module 05: Formatting a Worksheet</li><li>Module 06: Printing Workbooks</li><li>Module 07: Managing Workbooks</li><li>Module 08: Working with Functions</li><li>Module 09: Working with Lists</li><li>Module 10: Analyzing Data</li><li>Module 11: Visualizing Data with Charts</li><li>Module 12: Using PivotTables and PivotCharts</li><li>Working with Multiple Worksheets and Workbooks</li><li>Module 13: Using Lookup Functions and Formula Auditing</li><li>Module 14: Sharing and Protecting Workbooks</li><li>Module 15: Automating Workbook Functionality</li><li>Module 16: Creating Sparklines and Mapping Data</li><li>Module 17: Forecasting Data</li><li>Module 18: Microsoft Excel Templates</li><li>Module 19: Resources</li><li>Assignment</li><li>Recommended Materials</li></ul><p><strong>Course Assessment</strong></p><ul><li>MCQ test</li><li>60% marks to pass</li><li>Results will be evaluated instantly</li></ul><p><strong>Certificate of Achievement</strong></p><ul><li>Quality Licence Scheme Endorsed Certificate</li><li>CPD Accredited Certificate</li></ul><h2>
        
        <div>CPD</div>
    </h2>

                        <div id="cpd">
                            <div>
                                <div>
                                    <div>
                                        180 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>Anyone interested in learning or boosting their MS Excel skills</li><li>Suitable for learners of all levels</li></ul>
                        </div><h2>
        
        <div>Requirements</div>
    </h2>

                        <div id="requirements">
                            <p>This Microsoft Excel course is open to all, with no formal entry requirements.</p>
                        </div><h2>
        
        <div>Career path</div>
    </h2>

                        <div id="career_path">
                            <p>Some of the possible job opportunities includes:</p><ul><li>Accounts manager (Salary: £22,000 to £55,000 per year)</li><li>Financial Analyst (Salary: £23,500 to £45,000 per year)</li><li>Administrative Assistant (Salary: £14,000 to £28,000 per year)</li><li>Retail Store Manager (Salary: £20,000 to £60,000 per year)</li><li>HR Executives (Salary: £18,000 to £40,000 per year)</li><li>Data Analyst(Salary: £22,000 to £60,000 per year)</li></ul>
                        </div><h2>
        
        <div>Certificates</div>
    </h2>

                        <div id="optional_extras">
                                    <h4>Certificate of completion</h4>
        <p>
            Digital certificate -
            £9
        </p>
            <div> <p>After successfully completing this Microsoft Excel course, you will qualify for the CPD-accredited certificate from One Education. Certification is available in both PDF &amp; hardcopy format, which can be received by paying -</p><ul><li>PDF Certificate: £9</li></ul> </div>
        <h4>Certificate of completion</h4>
        <p>
            Hard copy certificate -
            £15
        </p>
            <div> <p>After successfully completing this Microsoft Excel course, you will qualify for the CPD-accredited certificate from One Education. Certification is available in hardcopy format, which can be received by paying -</p><ul><li>Hardcopy Certificate (within the UK): £15</li><li>Hardcopy Certificate (international): £15 + £10 (postal charge) = £25</li></ul> </div>
        <h4>Certificate of completion</h4>
        <p>
            Hard copy certificate -
            £129
        </p>
            <div> <p><strong>Endorsed Certificate of Achievement from the Quality Licence Scheme</strong></p><p>After successfully completing the Microsoft Excel course, learners will be able to order an endorsed certificate as proof of their achievement. Hardcopy of this certificate of achievement endorsed by the Quality Licence Scheme can be ordered and received straight to your home by post, by paying</p><ul><li>Within the UK: £129</li><li>International: £129 + £10 (postal charge) = £139</li></ul> </div>

                        </div>

One Education

Microsoft Excel Training Course

<p>The <strong>Microsoft Excel Masterclass</strong> Course offers a comprehensive journey through Excel's myriad functionalities, from fundamental operations to advanced data analysis techniques. In today's digitally-driven world, proficiency in Microsoft Excel is not just advantageous but essential for navigating complex data landscapes efficiently. This Microsoft Excel course equips learners with the skills to leverage Excel's powerful features for performing calculations, analyzing data, and visualizing insights through charts and PivotTables.</p><p><strong>In the UK job market, proficiency in Microsoft Excel is highly sought after</strong>, with employers valuing candidates who can demonstrate proficiency in spreadsheet management. Job opportunities abound across various sectors, including finance, marketing, and data analysis, <strong>with salaries ranging from £25,000 to £40,000 annually</strong>, depending on experience and industry.</p><p><strong>The demand for Excel proficiency is on the rise</strong>, <strong>with a notable increase of 15% in job postings requiring Excel skills over the past year</strong>. Mastery of Excel not only opens doors to lucrative career prospects but also enhances productivity and efficiency in diverse professional settings.</p><p><strong>Key Features </strong></p><ul><li>Accredited by CPD</li><li>Instant e-certificate</li><li>Fully online, interactive Microsoft Excel Masterclass course with audio voiceover</li><li>Self-paced learning and laptop, tablet, smartphone-friendly</li><li>24/7 Learning Assistance</li><li>Discounts on bulk purchases</li></ul><p><strong>Free Gifts</strong></p><ul><li>Life Coaching Course</li></ul><p><strong>Enrol now in this </strong><strong>Microsoft Excel Masterclass course to excel! </strong></p><p><strong>Course Curriculum:</strong></p><p><strong>Microsoft Excel</strong></p><ul><li>Module 01: Microsoft Excel 2019 New Features</li><li>Module 02: Getting Started with Microsoft Office Excel</li><li>Module 03: Performing Calculations</li><li>Module 04: Modifying a Worksheet</li><li>Module 05: Formatting a Worksheet</li><li>Module 06: Printing Workbooks</li><li>Module 07: Managing Workbooks</li><li>Module 08: Working with Functions</li><li>Module 09: Working with Lists</li><li>Module 10: Analyzing Data</li><li>Module 11: Visualizing Data with Charts</li><li>Module 12: Using PivotTables and PivotCharts</li><li>Module 13: Working with Multiple Worksheets and Workbooks</li><li>Module 14: Using Lookup Functions and Formula Auditing</li><li>Module 15: Sharing and Protecting Workbooks</li><li>Module 16: Automating Workbook Functionality</li><li>Module 17: Creating Sparklines and Mapping Data</li><li>Module 18: Forecasting Data</li><li>Module 19: Excel Templates</li></ul><p><strong>Life Coaching</strong></p><ul><li>Module 01: Life Coaching: The Purpose and Fundamentals</li><li>Module 02: Develop Your Self-Awareness</li><li>Module 03: The Development of Core Beliefs and Managing Fears</li><li>Module 04: Life Coaching Types and Key Attributes of a Life Coach</li><li>Module 05: Understanding Emotional Intelligence</li><li>Module 06: Body Language and Communication Techniques</li><li>Module 07: A Structure for Client Work and Goal Setting</li><li>Module 08: Basic Principles for Business Development and Growth</li><li>Module 09: The Ethical Coach: Protect Yourself and Your Clients</li></ul><p><strong>Accreditation</strong></p><p>All of our courses are fully accredited, including this Microsoft Excel Masterclass Course, providing you with up-to-date skills and knowledge and helping you to become more competent and effective in Microsoft Excel .</p><p><strong>Certification</strong></p><p>Once you've successfully completed your Microsoft Excel Masterclass Course, you will immediately be sent a digital certificate. Also, you can have your printed certificate delivered by post (shipping cost £3.99). Our Microsoft Excel Masterclass Course certification has no expiry dates, although we do recommend that you renew them every 12 months.</p><h2>
        
        <div>CPD</div>
    </h2>

                        <div id="cpd">
                            <div>
                                <div>
                                    <div>
                                        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">
                            <p>This Microsoft Excel Masterclass Course can be taken by anyone who wants to understand more about the topic. With the aid of this Microsoft Excel Masterclass course, you will be able to grasp the fundamental knowledge and ideas. Additionally, this Microsoft Excel Masterclass Course is ideal for:</p><ul><li>Beginners looking to establish a strong foundation in Excel.</li><li>Professionals seeking to enhance their data analysis skills.</li><li>Entrepreneurs aiming to streamline business processes.</li><li>Analysts wanting to unlock deeper insights from data.</li><li>Individuals interested in boosting their employability with Excel proficiency.</li></ul>
                        </div><h2>
        
        <div>Requirements</div>
    </h2>

                        <div id="requirements">
                            <p>Learners do not require any prior qualifications to enrol on this Microsoft Excel Masterclass Course. You just need to have an interest in Microsoft Excel Masterclass Course.</p>
                        </div><h2>
        
        <div>Career path</div>
    </h2>

                        <div id="career_path">
                            <p>After completing this Microsoft Excel Masterclass Course you will have a variety of careers to choose from. The following job sectors of Microsoft Excel Masterclass Course are:</p><ul><li>Data Analyst - £25K to 45K/year.</li><li>Financial Analyst - £28K to 50K/year.</li><li>Business Intelligence Analyst - £30K to 55K/year.</li><li>Accountant - £22K to 45K/year.</li><li>Project Manager - £30K to 60K/year.</li></ul>
                        </div><h2>
        
        <div>Certificates</div>
    </h2>

                        <div id="optional_extras">
                                    <h4> Digital certificate</h4>
        <p>
            Digital certificate -
            Included
        </p>
            <div><p>Once you've successfully completed your course, you will immediately be sent a FREE digital certificate.</p></div>
        <h4> Hard copy certificate</h4>
        <p>
            Hard copy certificate -
            Included
        </p>
            <div><p>Also, you can have your FREE printed certificate delivered by post (shipping cost £3.99 in the UK).<br />For all international addresses outside of the United Kingdom, the delivery fee for a hardcopy certificate will be only £10.<br />Our certifications have no expiry dates, although we do recommend that you renew them every 12 months.</p></div>

                        </div>

Training Express

Microsoft Excel Masterclass Course

<p>Microsoft Excel is a spreadsheet tool created by Microsoft in 1985 to assist businesses in compiling all of their financial data, yearly credit and yearly debit sheets. After 35 years, it has become the most important tool in Microsoft Office and is often used for making graphs and pivot tables. It will help you excel at work and open doors to new chances. Join us in Microsoft Excel Diploma to impress your boss and stand out to top management and potential employment.</p><p>This course will teach you the essentials of Microsoft Excel and will help you comprehend the content fast. You will learn how to deal with data and use the Microsoft Excel interface. This course will teach you how to use excel functions and worksheets, as well as how to enter, edit, and delete images or shapes from them. It will also teach you data visualisation skills and help you calculate data fast and properly.</p><p>This course contains a variety of skills to improve your excel efficiency. As a result, the information you gain will increase your productivity. Over time, the high productivity will lead to long-term job success. So enrol now to prevent missing out!</p><p><strong>Learning Outcomes</strong></p><p>Upon successful completion of the Microsoft Excel Diploma, you will be able to,</p><ul><li>Discover Microsoft Excel functionalities.</li><li>Navigate the Microsoft Excel interface correctly.</li><li>Learn how to compute using various equations and functions.</li><li>Learn how to insert images and shapes.</li><li>Determine how to visualise data with charts.</li><li>Discover the benefits of using excel templates.</li></ul><p><strong>Meet the Accreditation</strong></p><p>CPD Quality Standards (CPD QS) accreditation assure the Microsoft Excel Diploma course training and learning activities are relevant, reliable, and upto date.</p><p><strong>Expert Support</strong></p><p>Dedicated tutor support and 24/7 customer support are available to all students with this premium quality course.</p><p><strong>Key Benefits</strong></p><ul><li>Learning materials of the Design course contain engaging voiceover and visual elements for your comfort.</li><li>Get 24/7 access to all content for a full year.</li><li>Each of our students gets full tutor support on weekdays (Monday to Friday)</li></ul><p><strong>Course Curriculum:</strong></p><p>Here is a curriculum breakdown of the Microsoft Excel Diploma - Beginner, Intermediate &amp; Advanced course:</p><ul><li>Unit 01: Excel from A-Z Course Introduction</li><li>Unit 02: Getting Started With Excel</li><li>Unit 03: Values, Referencing and Formulas</li><li>Unit 04: Intro to Excel Functions</li><li>Unit 05: Adjusting Excel Worksheets</li><li>Unit 06: Visually Pleasing Cell Formatting</li><li>Unit 07: How to Insert Images and Shapes!</li><li>Unit 08: Visualize Data with Charts</li><li>Unit 09: Excel's Printing Options</li><li>Unit 10: Benefits of Using Excel Templates</li></ul><p>and many more ..</p><p><strong>Course Assessment </strong></p><p>To simplify the procedure of evaluation and accreditation for learners, we provide an automated assessment system. Upon completion of an online module, you will immediately be given access to a specifically crafted MCQ test. The results will be evaluated instantly, and the score will be displayed for your perusal. For each test, the pass mark will be set to 60%.</p><p>When all tests have been successfully passed, you will be able to order a certificate endorsed by the Quality Licence Scheme.</p><p><strong>Exam &amp; Retakes:</strong></p><p>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.</p><p><strong>Certification</strong></p><p>Upon 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).</p><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">
                            <ul><li>Professionals who wish to learn more about Microsoft Excel.</li><li>Individuals who are interested in Microsoft Excel's advanced features.</li><li>Individuals who aspire to advance to the specialist level of Microsoft Excel.</li></ul>
                        </div><h2>
        
        <div>Requirements</div>
    </h2>

                        <div id="requirements">
                            <p>This Microsoft Excel Diploma course is open to all, with no formal entry requirements.</p>
                        </div><h2>
        
        <div>Career path</div>
    </h2>

                        <div id="career_path">
                            <p>The Microsoft Excel Diploma will assist you with developing a specific demanding skill that will be useful in the following careers:</p><ul><li>Office Administrator</li><li>Office Manager</li><li>Personal Assistant</li></ul><p>In the United Kingdom, the average yearly salary for these vocations is between £22,000 and £28,000.</p>
                        </div>

Microsoft Excel Diploma Course

<h2><b>Overview</b></h2>
<span>This </span><b>Microsoft Excel Course for Everyone - Complete Excel Course</b><span> is your passport to spreadsheet mastery.</span>

<span>Explore Excel in detail and improve your abilities with practical activities that go beyond boring lectures. Take on spreadsheets like an expert, from data entry to difficult formulas and eye-catching graphics. </span>

<span>But the magic doesn't end there! After finishing successfully, you'll not only impress with your proficiency with Excel, but you'll also obtain a respected <strong>CPD certification</strong> to enhance your CV and make a statement in the job market. Consider it your golden ticket to go up in your job!</span>

<span>Enrol right away to see how your confidence and chances rise! Don't wait!</span>
<h2><b>How will I get my certificate?</b></h2>
<span>You may have to take a quiz or a written test online during or after the course. After successfully completing the course, you will be eligible for the certificate.</span>
<h2><b>Who is This course for?</b></h2>
<span>There is no experience or previous qualifications required for enrolment on this </span><b>Microsoft Excel Course for Everyone - Complete Excel Course</b><span>. It is available to all students, of all academic backgrounds.</span>
<h2><b>Requirements</b></h2>
<ul>
 	<li><span>Compatible with a wide range of gadgets, including smartphones, tablets, laptops, Macs, and PCs.</span></li>
 	<li><span>Particularly designed to be easily accessed with an internet connection on tablets and smartphones.</span></li>
 	<li><span>No strict deadlines; learn whenever it's convenient for you.</span></li>
 	<li><span>Individuals with basic English proficiency.</span></li>
</ul>
<h2><b>Career Path</b></h2>
<span>After completing this course, it will increase the value of your CV and open you up to multiple sectors, such as :  </span>
<ul>
 	<li><b>Data Analyst: </b><span>£25,000 - £50,000 per year</span></li>
 	<li><b>Financial Analyst:</b><span> £30,000 - £60,000 per year</span></li>
 	<li><b>Operations Manager:</b><span> £35,000 - £70,000 per year</span></li>
 	<li><b>Accountant:</b><span> £25,000 - £50,000 per year</span></li>
 	<li><b>Business Intelligence Analyst:</b><span> £35,000 - £65,000 per year</span></li>
</ul>
<span>These salary ranges can vary based on factors such as experience, location, and the specific industry of the business.</span> <h3>Course Curriculum</h3><div><p>15 sections • 80 lectures • 06:51:00 total length</p></div><div><div><div><div><div><div><div><p>•Introduction: 00:03:00</p></div><div><div><p>•Course Curriculum: 00:04:00</p></div><div><div><p>•Getting started on Windows, macOS, Android, and IOS: 00:01:00</p></div><div><div><p>•How to ask great questions: 00:02:00</p></div><div><div><p>•FAQ's: 00:01:00</p></div><div><div><p>•Starting Excel: 00:04:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Introduction: 00:02:00</p></div><div><div><p>•Worksheet basics: 00:22:00</p></div><div><div><p>•Entering values and formulas: 00:12:00</p></div><div><div><p>•Data formats: 00:10:00</p></div><div><div><p>•Data handling basics - cut copy and paste: 00:07:00</p></div><div><div><p>•Save and print in excel: 00:10:00</p></div><div><div><p>•Excel Ranges: 00:05:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Introduction: 00:01:00</p></div><div><div><p>•Basic formula operations: 00:06:00</p></div><div><div><p>•Mathematical functions level 1: 00:20:00</p></div><div><div><p>•Mathematical functions level 2: 00:12:00</p></div><div><div><p>•Text functions level 1: 00:09:00</p></div><div><div><p>•Text functions level 2: 00:13:00</p></div><div><div><p>•Logical functions: 00:11:00</p></div><div><div><p>•Date time functions: 00:06:00</p></div><div><div><p>•V Lookup formula: 00:12:00</p></div><div><div><p>•HLookup formula: 00:04:00</p></div><div><div><p>•HLookup + Match formula: 00:09:00</p></div><div><div><p>•Match + Index formula: 00:05:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Introduction: 00:02:00</p></div><div><div><p>•XLookup: 00:08:00</p></div><div><div><p>•Handling #NA and Approximates match in XLookup: 00:11:00</p></div><div><div><p>•Wildcard matching in XLookup: 00:06:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Introduction: 00:02:00</p></div><div><div><p>•Split text into columns: 00:07:00</p></div><div><div><p>•Flash Fill: 00:07:00</p></div><div><div><p>•Remove Duplicates: 00:08:00</p></div><div><div><p>•Data Validation: 00:07:00</p></div><div><div><p>•Get- import Data from Text: 00:06:00</p></div><div><div><p>•Get - import Data from CSV: 00:03:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Introduction: 00:01:00</p></div><div><div><p>•Formatting Font: 00:04:00</p></div><div><div><p>•Formatting Alignment: 00:06:00</p></div><div><div><p>•Formatting Number: 00:05:00</p></div><div><div><p>•Formatting Date: 00:03:00</p></div><div><div><p>•Formatting tables: 00:05:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Introduction: 00:01:00</p></div><div><div><p>•Creating Pivot Table: 00:07:00</p></div><div><div><p>•Value field settings: 00:04:00</p></div><div><div><p>•Number format: 00:02:00</p></div><div><div><p>•Pivot Table Design: 00:03:00</p></div><div><div><p>•Excel Exercise: 00:01:00</p></div><div><div><p>•Solution for Excel Exercise: 00:02:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Introduction: 00:01:00</p></div><div><div><p>•Excel Charts - Categories: 00:03:00</p></div><div><div><p>•Elements of a chart: 00:04:00</p></div><div><div><p>•Easy way to create charts: 00:02:00</p></div><div><div><p>•Column or Bar charts: 00:04:00</p></div><div><div><p>•Formatting charts: 00:04:00</p></div><div><div><p>•Line charts: 00:02:00</p></div><div><div><p>•Area charts: 00:02:00</p></div><div><div><p>•Pie and Doughnut charts: 00:04:00</p></div><div><div><p>•Format AreaPlot or XY chart: 00:08:00</p></div><div><div><p>•Scatter or bubble charts: 00:02:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Introduction: 00:01:00</p></div><div><div><p>•Frequency Distribution and Histograms: 00:04:00</p></div><div><div><p>•Waterfall charts: 00:02:00</p></div><div><div><p>•Hierarchy charts: sunburst and tree map: 00:03:00</p></div><div><div><p>•Combination charts: 00:02:00</p></div><div><div><p>•Sparklines: 00:05:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Pivot charts: 00:02:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Maps chart: 00:04:00</p></div><div><div><p>•3D Maps chart: 00:03:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Introduction: 00:01:00</p></div><div><div><p>•Stock charts: 00:02:00</p></div><div><div><p>•Radar charts: 00:02:00</p></div><div><div><p>•Surface charts: 00:02:00</p></div><div><div><p>•Heat maps: 00:04:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Named ranges: 00:05:00</p></div><div><div><p>•Indirect Name range Function: 00:06:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Import Data table from PDF file - Excel 2021: 00:04:00</p></div><div><div><p>•Import Data from Website - Excel 2019 above: 00:09:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Project: Sales forecast tracker: 00:07:00</p></div><div><div><p>•Product Sale Tax invoice: Tax Calculations: 00:05:00</p></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div>

Spreadsheet

Microsoft Excel Course for Everyone - Complete Excel Course

<p>Nowadays, getting a desired Accounting career with a decent salary is unthinkable without understanding Microsoft Excel in Accounting.</p><p>This <strong>Microsoft Excel in Accounting Diploma</strong> course will provide a comprehensive introduction to the use of Microsoft Excel for accounting, data analysis and business management. The Microsoft Excel in Accounting course will cover key areas of Excel, including formulas, functions, charts and graphs, data management, and advanced features. The Microsoft Excel in Accounting course will also provide an overview of best practices and industry-specific applications of Excel. It will provide opportunities for participants to develop their Microsoft Excel in Accounting skills through practical exercises and case studies.</p><p>Enrol now to take your career to the next level.</p><p><strong>Here are a few important skills you will achieve from our Microsoft Excel in Accounting course:</strong></p><ul><li>Gain knowledge of how to use the fundamental and advanced capabilities of Microsoft Excel Formulas, functions, and accounting data management in Excel</li><li>Identify how to produce and format accounting charts and graphs.</li><li>Discover how to utilise more sophisticated features like macros, pivot tables, and data validation</li><li>Acknowledge Excel's best practices for accounting, data analysis and business management</li><li>Realise Excel's applications in several fields, including accounting, finance, marketing, and operations</li><li>Comprehend how to utilise Excel for reporting and data visualisation</li></ul><p><strong>Key Features of Microsoft Excel in Accounting<br /></strong></p><ul><li>CPD Accredited Microsoft Excel in Accounting course</li><li>Instant e-certificate</li><li>Fully online, interactive Microsoft Excel in Accounting course</li><li>Developed by qualified Experts</li><li>Self-paced learning and laptop, tablet, smartphone-friendly</li><li>24/7 Learning Assistance</li></ul><p><strong>Additional Gifts </strong></p><ul><li><strong>Course 01: </strong>Advanced Accounting and Bookkeeping</li><li><strong>Course 02: </strong>Soft Skills</li></ul><p><strong>The Microsoft Excel in Accounting Course Curriculum </strong></p><ul><li><strong>Module 01:</strong> Microsoft Excel in Accounting</li><li><strong>Module 02:</strong> Microsoft Excel 2019 New Features</li><li><strong>Module 03:</strong> Getting Started with Microsoft Office Excel</li><li><strong>Module 04:</strong> Performing Calculations</li><li><strong>Module 05:</strong> Modifying a Worksheet</li><li><strong>Module 06:</strong> Formatting a Worksheet</li><li><strong>Module 07:</strong> Printing Workbooks</li><li><strong>Module 08:</strong> Managing Workbooks</li><li><strong>Module 09:</strong> Working with Functions</li><li><strong>Module 10:</strong> Working with Lists</li><li><strong>Module 11:</strong> Analyzing Data</li><li><strong>Module 12:</strong> Visualizing Data with Charts</li><li><strong>Module 13:</strong> Using PivotTables and PivotCharts</li><li><strong>Module 14:</strong> Working with Multiple Worksheets and Workbooks</li><li><strong>Module 15:</strong> Using Lookup Functions and Formula Auditing</li><li><strong>Module 16:</strong> Sharing and Protecting Workbooks</li><li><strong>Module 17:</strong> Automating Workbook Functionality</li><li><strong>Module 18:</strong> Creating Sparklines and Mapping Data</li><li><strong>Module 19:</strong> Forecasting Data</li><li><strong>Module 20:</strong> Excel Templates</li></ul><p><strong>Certification</strong></p><p>Once you've successfully completed your Microsoft Excel in Accounting course, you will immediately be sent a digital certificate.</p><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">
                            <p><strong>This course is suitable for the following:</strong></p><p>Accounting majors, aspiring accountants, and practicing accountants, particularly for AAT, CAT, FIA, ACCA, and university students.</p>
                        </div><h2>
        
        <div>Requirements</div>
    </h2>

                        <div id="requirements">
                            <p>No formal qualification is required.</p>
                        </div><h2>
        
        <div>Career path</div>
    </h2>

                        <div id="career_path">
                            <ul><li>Accountant</li><li>ACCA Accountant</li><li>Chartered Accountant</li><li>Accountant Clerks</li><li>Data Entry Clerks</li><li>Data Scientist</li><li>Health Records Clerk</li><li>Data Analyst-Statistician</li></ul>
                        </div><h2>
        
        <div>Certificates</div>
    </h2>

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

                        </div>

Microsoft Excel in Accounting Course

<p>Microsoft Excel skills are required worldwide, regardless of whether you wish to start a career as a software engineer, accountant, or data analyst. Since Microsoft Excel is the most widely used programme for managing and calculating data, the majority of businesses utilise it to fulfil their work. You can't even think of progressing with your research work without the use of Excel.</p><p>So, gain skills in Microsoft Excel by joining our Microsoft Excel - Spreadsheet for the Beginner course.</p><p>This Microsoft Excel - Spreadsheet for the Beginner course is designed for the beginner. So, you can get the chance to learn it from the basics. After that, we will show you some advanced use of excel.</p><p>After joining this Microsoft Excel - Spreadsheet for the Beginner course, you will be able to learn how to format the Spreadsheet, Manage the Sheets, and Copy formulas. Alongside that, we will show you how to enter and save the data as well.</p><p>If you want to know the A-Z of Microsoft Excel, this course is the best choice for you. So, enrol in this Microsoft Excel - Spreadsheet for the Beginner course and radiate in your future career.</p><p><strong>Learning outcomes:</strong></p><p>After completing this Microsoft Excel - Spreadsheet for the Beginner course, learners will be able to:</p><ul><li>Get the fundamentals knowledge of Microsoft Excel from this exclusive course</li><li>Learn how to enter data and save the file</li><li>Deepen your understanding of how to format the Spreadsheet, Manage the Sheets, and Copy formulas</li><li>Know how to link the sheet together</li><li>Get in-detail knowledge of the functioning</li></ul><p><strong>Expert Support</strong></p><p>Dedicated tutor support and 24/7 customer support are available to all students with this premium quality course.</p><p><strong>Key Benefits</strong></p><ul><li>Learning materials of the Design course contain engaging voiceover and visual elements for your comfort.</li><li>Get 24/7 access to all content for a full year.</li><li>Each of our students gets full tutor support on weekdays (Monday to Friday)</li></ul><p>Microsoft is the most well-known software which is used by millions of people on a global scale. You must have a working familiarity with Microsoft Office, regardless of the industry you choose. So, it is better to acquire the abilities of Microsoft and flourish in the career.</p><p>One education is offering you the Microsoft Excel - Spreadsheet for Beginner course to help you get expertise in this sector. So, without further ado, enrol in this Microsoft Excel - Spreadsheet for Beginner course.</p><p><strong>Course Curriculum:</strong></p><p>Here is a curriculum breakdown of the Excel spreadsheet for Beginner course:</p><p><strong>Excel spreadsheet for Beginner</strong></p><ul><li>Tour of the Excel screen</li><li>Entering Data</li><li>Autofill Speedfill</li><li>Saving the file</li><li>Autosum</li><li>Formula Basics</li><li>Copying formulas - Relative Formulas</li><li>Totals and Averages</li><li>Formatting the Spreadsheet</li><li>Managing the Sheets</li><li>Copying formulas - absolute formulas</li><li>Linking the Sheets together</li><li>Introduction to Functions</li></ul><p><strong>Meet the Accreditation</strong></p><p>CPD Quality Standards (CPD QS) accreditation assure the Microsoft Excel - Spreadsheet for Beginners course training and learning activities are relevant, reliable, and upto date.</p><p><strong>Course Assessment </strong></p><p>To simplify the procedure of evaluation and accreditation for learners, we provide an automated assessment system. Upon completion of an online module, you will immediately be given access to a specifically crafted MCQ test. The results will be evaluated instantly, and the score will be displayed for your perusal. For each test, the pass mark will be set to 60%.</p><p>When all tests have been successfully passed, you will be able to order a certificate endorsed by the Quality Licence Scheme.</p><p><strong>Exam &amp; Retakes:</strong></p><p>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.</p><p><strong>Certification</strong></p><p>Upon 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).</p><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">
                            <p>This Microsoft Excel - Spreadsheet for Beginner course is open to anyone. So, if you are interested in getting expertise in Excel you are welcome to enrol on this course.<strong><br /></strong></p>
                        </div><h2>
        
        <div>Requirements</div>
    </h2>

                        <div id="requirements">
                            <p>You don't need special requirements to join this Microsoft Excel - Spreadsheet for Beginner course.</p>
                        </div><h2>
        
        <div>Career path</div>
    </h2>

                        <div id="career_path">
                            <p>After completing this Microsoft Excel - Spreadsheet for the Beginner course, you will gain the ability to excel and shine in your future career. Following are the jobs which mostly need excel expertise -</p><ul><li>Data Analyst</li><li>Accountant</li><li>Researcher</li><li>Administrative Manager</li><li>Sales Manager</li></ul>
                        </div>

Microsoft Excel - Spreadsheet for Beginners Course

<span dir="ltr" id="isPasted" fr-original-style="" style="box-sizing: border-box;"><span style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Financial Modeling and Analysis are highly respected skills in the business world and are hugely sought after in the job marketplace.</span><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">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.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">It is multidisciplinary, requiring expertise in Accounting, Finance, Financial Analysis, Valuation, and Microsoft Excel.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">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.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="color: rgb(35, 35, 51); box-sizing: border-box;" id="isPasted" fr-original-style="color: rgb(35, 35, 51);">This course is certified by the CFA Society Nigeria with 40 PL Credits and CPD UK with 40 CPD Credits.&nbsp;</span></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="color: rgb(35, 35, 51); box-sizing: border-box;" fr-original-style="color: rgb(35, 35, 51);">In this course, you will learn 3 Statement Modeling from Scratch to Mastery using a real Company&#39;s Audited Financial Statement. &nbsp;</span></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="color: rgb(35, 35, 51); box-sizing: border-box;" fr-original-style="color: rgb(35, 35, 51);">The course includes</span></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="color: rgb(35, 35, 51); box-sizing: border-box;" fr-original-style="color: rgb(35, 35, 51);">&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;</span></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="color: rgb(35, 35, 51); box-sizing: border-box;" fr-original-style="color: rgb(35, 35, 51);">&bull; &nbsp; &nbsp;1 Technical Session to confirm your connectivity and solve any technical issues you may have).&nbsp;</span></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="color: rgb(35, 35, 51); box-sizing: border-box;" fr-original-style="color: rgb(35, 35, 51);">&bull; &nbsp; &nbsp;10 intensive instructor-led live virtual sessions. Each session is 2 hours&nbsp;</span></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="color: rgb(35, 35, 51); box-sizing: border-box;" fr-original-style="color: rgb(35, 35, 51);">&bull; &nbsp; &nbsp;9 compulsory intersession assignments you will need to complete and submit on www.OfficeTrainingHub.com&nbsp;</span></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="color: rgb(35, 35, 51); box-sizing: border-box;" fr-original-style="color: rgb(35, 35, 51);">&bull; &nbsp; &nbsp;Intermittent tests and quizzes to gauge your assimilation.&nbsp;</span></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="color: rgb(35, 35, 51); box-sizing: border-box;" fr-original-style="color: rgb(35, 35, 51);">&bull; &nbsp; &nbsp;1 Capstone Project</span></p></span>

dbrownconsulting

Financial Modelling & Analysis

Financial Modelling

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

Advanced Financial Modeler Certificate Course

<p><strong>***Offer Ends Today***</strong></p><p><strong>Earn up to 40K as a 'DATA ANALYST' or Your 100% Money Back</strong></p><p>Do you know that entry-level data analysts earn an average of <strong>£40,000 </strong>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 <strong>Data Analyst Job Ready Program</strong> is here to guide you all the way until you get the job you want.</p><p>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.</p><p><strong>Our mission is simple - to be your trusted partner every step of the way, from Training to Employment.</strong></p><p>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!</p><p>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.</p><p>If you are not happy with our service, we also offer a <strong>100% money-back guarantee</strong>. 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!</p><p><strong>Why Choose Us?</strong></p><p>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:</p><ul><li><strong>Personalised Guidance: </strong>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.<br /><br /></li><li><strong>One-On-One Consultation Sessions with Experts: </strong>Gain invaluable insights and guidance from seasoned professionals who have thrived in the Data Analyst field.<br /><br /></li><li><strong>Extensive Job Opportunities:</strong> 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.<br /><br /></li><li><strong>Interview Preparation:</strong> 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.<br /><br /></li><li><strong>100% Money-Back Guarantee: </strong>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><p><strong>Courses we will provide once you enrol in the program:</strong></p><ul><li><strong>Course 01: </strong>Introduction to Data Analysis</li><li><strong>Course 02: </strong>Business and Data Analytics for Beginners</li><li><strong>Course 03: </strong>Data Analytics with Tableau</li><li><strong>Course 04: </strong>Quick Data Science Approach from Scratch</li><li><strong>Course 05: </strong>Learn MySQL from Scratch for Data Science and Analytics</li><li><strong>Course 06: </strong>SQL for Data Science, Data Analytics and Data Visualization</li><li><strong>Course 07: </strong>Statistics &amp; Probability for Data Science &amp; Machine Learning</li><li><strong>Course 08: </strong>Basic Google Data Studio</li><li><strong>Course 09: </strong>R Programming for Data Science</li><li><strong>Course 10: </strong>Python Data Science with Numpy, Pandas and Matplotlib</li><li><strong>Course 11: </strong>Complete Python Machine Learning &amp; Data Science Fundamentals</li><li><strong>Course 12: </strong>2021 Data Science &amp; Machine Learning with R from A-Z</li><li><strong>Course 13: </strong>Microsoft Excel Complete Course</li><li><strong>Course 14: </strong>Microsoft Excel: Automated Dashboard Using Advanced Formula, VBA, Power Query</li><li><strong>Course 15: </strong>Data Center Training Essentials: General Introduction</li><li><strong>Course 16: </strong>Excel Data Analysis</li><li><strong>Course 17: </strong>Data Entry Administrator Training</li><li><strong>Course 18: </strong>SQL Masterclass: SQL For Data Analytics</li><li><strong>Course 19: </strong>Business Data Analysis</li><li><strong>Course 20: </strong>Master JavaScript with Data Visualization</li></ul><p><strong>How Can We Offer Job Guarantees?</strong></p><p>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.</p> <p><strong>The Data Analyst Job Ready Program with Career Support &amp; Money Back Guarantee is completed in 9 easy steps:</strong></p><p><strong>Step 1: Enrol in the Programme</strong></p><p>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.</p><p>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!</p><p><strong>Step 2: Initial One-On-One Counselling Session</strong></p><p>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.</p><p><strong>Step 3: Certification upon Course Completion</strong></p><p>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.</p><p><strong>Step 4: CV Revamping</strong></p><p>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.</p><p><strong>Step 5: Building Network and Submitting CV</strong></p><p>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.</p><p><strong>Step 6: Interview Preparation</strong></p><p>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.</p><p><strong>Step 7: Securing Job Interviews</strong></p><p>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.</p><p><strong>Step 8: Post-Interview Support</strong></p><p>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.</p><p><strong>Step 9: Celebrate Your New Job!</strong></p><p>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.</p><p>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.</p> <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">
                            <p><strong>This Data Analyst Job Ready Program is perfect for:</strong></p><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">
                            <p>This Data Analyst Job Ready Program will help you get a job in different roles, such as:</p><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>
        <p>
            Digital certificate -
            Included
        </p>
        <h4>CPD Accredited Framed (Hardcopy) Certificate</h4>
        <p>
            Hard copy certificate -
            Included
        </p>
        <h4>Enrolment Letter</h4>
        <p>
            Digital certificate -
            Included
        </p>
        <h4>QLS Endorsed Hard Copy Certificate</h4>
        <p>
            Hard copy certificate -
            Included
        </p>
        <h4>Student ID Card</h4>
        <p>
            Digital certificate -
            Included
        </p>

                        </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">Duration<p>4 Days</p><p>24 CPD hours</p>This course is intended for<p></p><p>The 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.</p><p></p><p></p><p>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.</p><p></p></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

Power Apps

Power Automate

Microsoft Power Automate

PL-100T00 Microsoft Power Platform App Maker

<h2>Microsoft Excel® in Depth (Virtual)</h2>
 <p>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.</p>
 <p>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.</p><h3>What you will Learn</h3>
 <p>You'll learn how to:</p>
 <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>
 <p>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.</p>
 <p>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.</p>
 <p>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.</p><h3>What you Will Learn</h3> 
 <p>You'll learn how to:</p> 
 <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> 
 <p>Excel Functions - VLOOKUP, IF, INDEX, MATCH, CHOOSE, SUMIF, SUMIFS, SUMPRODUCT, DATE, so many more</p> 
 <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>
 <p>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.</p>
 <p>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.</p>
 <p>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.</p><h3>What you Will Learn</h3>
 <p>You'll learn how to:</p>
 <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> 
 <p>Excel Functions - VLOOKUP, IF, INDEX, MATCH, CHOOSE, SUMIF, SUMIFS, SUMPRODUCT, DATE, so many more</p> 
 <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

<p fr-original-style=" color: rgb(98, 98, 98);" id="isPasted" style="color: rgb(98, 98, 98); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Overview</strong></p><p fr-original-style=" color: rgb(98, 98, 98);" style="color: rgb(98, 98, 98); font-size: var(--font-size); box-sizing: border-box;">The 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.</p><p fr-original-style=" color: rgb(98, 98, 98);" style="color: rgb(98, 98, 98); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Who Should Attend</strong></p><p fr-original-style=" color: rgb(98, 98, 98);" style="color: rgb(98, 98, 98); font-size: var(--font-size); box-sizing: border-box;">The Support Manager course is for managers who have at least six months management experience and have received some basic management training.</p><p fr-original-style=" color: rgb(98, 98, 98);" style="color: rgb(98, 98, 98); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Requirements</strong></p><p fr-original-style=" color: rgb(98, 98, 98);" style="color: rgb(98, 98, 98); font-size: var(--font-size); box-sizing: border-box;">The 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.</p><p fr-original-style=" color: rgb(98, 98, 98);" style="color: rgb(98, 98, 98); font-size: var(--font-size); box-sizing: border-box;">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.</p><p fr-original-style=" color: rgb(98, 98, 98);" style="color: rgb(98, 98, 98); font-size: var(--font-size); box-sizing: border-box;">Homework is assigned for most evenings of the course. Please plan for study time outside of class.</p><p fr-original-style=" color: rgb(98, 98, 98);" style="color: rgb(98, 98, 98); font-size: var(--font-size); box-sizing: border-box;"><b fr-original-style="" style="box-sizing: border-box;">Some of the training objectives&hellip;</b></p><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

<div id="course-pills-1">Duration<p>1 Days</p><p>6 CPD hours</p>This course is intended for<p>This 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.</p>Overview<p>Identify 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.</p><p>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.</p>Prerequisites<p>To 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.</p></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><br /><p>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. </p><p></p> This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. <p></p>Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success.  <p></p>While we feel this is the best course for the 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.  <p></p>Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.<p></p></div>

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);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">About this Virtual Instructor Led Training (VILT)</strong></h2><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">This&nbsp;<strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">intermediate level 5 half-day Virtual Instructor Led Training (VILT) course</strong>&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.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">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.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">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.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">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.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Participants are advised to bring a scientific calculator and laptop with Microsoft Excel installed.</p></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;"><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">By the end of this VILT course, participants will be equipped on the following:</p><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;"><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); 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:</p><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;"><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">This VILT course will be delivered online in&nbsp;<strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">5 half-day sessions comprising 4 hours per day</strong>, with 2 breaks of 10 minutes per day.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Course Duration: 5 half-day sessions, 4 hours per session (20 hours in total).</p></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;"><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); 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.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Additional Positions &amp; Credentials</strong></p><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><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Publications</strong></p><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><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Previous Clients Include:</strong></p><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;"><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); 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.<br fr-original-style="" style="box-sizing: border-box;"><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.</p></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.

TEMA & HTRI Heat Exchanger Design & Cost Saving Management – Virtual Instructor Led Training (VILT)

Team of 10, pp

Normal Fee, pp

<p><strong>Course Objectives</strong></p><p>This course aims to provide delegates with a foundation for Excel knowledge and skills.</p><p>'</p><p><em><strong>Customer Feedback</strong></em></p><ul><li><strong>Very professional and well mannered, fun and pleasant at the same time. I learnt a lot</strong></li><li>Carolina Foster - CNN</li></ul><ul><li><strong>Very helpful course. Would definitely take another one. Pedro was very patient and made it fun and engaged with us all.</strong></li><li>Laura Smith - James Grant</li></ul><ul><li><strong>Great course and excellent trainer. Thanks</strong></li><li>Tracy Preston - Western Power Distribution</li></ul><p>1 year email support service</p><p>Take a look at the <strong>consistent excellent feedback from our corporate clients</strong> visiting our site <em><strong>ms-officetraining co uk</strong></em></p><p>With more than 20 years experience, we deliver courses on all levels of the Desktop version of <strong>Microsoft Office and Office 365</strong>; ranging from Beginner, Intermediate, Advanced to the VBA level.</p><p>Our trainers are Microsoft certified professionals with a proven track record with several years experience in delivering<strong> public, one to one, tailored and bespoke courses.</strong></p><ul><li><strong>Our competitive rates <strong>start from £550.00 per day of training</strong></strong></li></ul><p><strong><strong>Tailored training courses:</strong></strong></p><p>You can choose to run the course exactly as they are outlined by us or we can customise it so that it meets your specific needs. A tailored or bespoke course will follow the standard outline but may be adapted to your specific organisational needs.</p><p><strong>What is Excel?</strong></p><p><strong>The Excel Interface</strong></p><ul><li>Ribbon, Tabs and Groups</li><li>Microsoft Office Backstage view</li></ul><p><strong>Working with Workbooks</strong></p><ul><li>Create a blank Workbook</li><li>Create a Workbook using a Template</li><li>Opening and saving Files</li></ul><p><strong>Working with worksheets</strong></p><ul><li>Worksheet navigation</li><li>Select one or multiple Worksheets</li><li>Insert, Move, Copy or Delete a Worksheet</li></ul><p><strong>Working with Cells, Rows &amp; Columns</strong></p><ul><li>Cell References</li><li>How to select cells or ranges</li><li>Different types of data</li><li>Move, Copy and Delete cells</li><li>Pasting Options</li><li>Find and Replace</li><li>Working with Rows and Columns</li></ul><p><strong>Overview of formulas in Excel</strong></p><ul><li>Autocalculation</li><li>The parts of an Excel formula</li><li>Using calculation operators in Excel formulas</li><li>The difference between Absolute, Relative and Mixed references</li><li>Using Excel functions; Sum, Average, Max and Min</li></ul><p><strong>Cell Formatting</strong></p><ul><li>Font Format options</li><li>Number Format options</li><li>Change the Fill and Borders</li><li>Cell Alignment</li></ul><p><strong>An Introduction to Charts</strong></p><ul><li>Create a simple Chart</li><li>Format your chart</li></ul><p><strong>Page Layout and Print</strong></p><ul><li>Page Layout and Page Break View</li><li>Change the Page Orientation</li><li>Set Page Margins</li><li>Headers and Footers in a worksheet</li><li>Print a worksheet or workbook</li></ul><h2>
        
            Who is this course for?
        
        <div>Who is this course for?</div>
    </h2>

                        <div id="who_is_this_course_for">
                            <p>All users who want to master the main features of Microsoft Excel</p>
                        </div><h2>
        
            Requirements
        
        <div>Requirements</div>
    </h2>

                        <div id="requirements">
                            <p>General knowledge of the Windows OS</p>
                        </div><h2>
        
            Certificates
        
        <div>Certificates</div>
    </h2>

                        <div id="optional_extras">
                                    <h4>Certificate of completion</h4>
        <p>
            Digital certificate -
            Included
        </p>

                        </div>

826 Courses delivered Online

Microsoft Excel: Master Power Query in 120 Minutes!

By Apex Learning

Microsoft Excel: Automated Dashboard Using Advanced Formula, VBA, Power Query

By Apex Learning

Microsoft Excel

By Studyhub UK

Powerful Functions in Microsoft Excel

By Course Gate

Microsoft Excel Training Course

By One Education

Microsoft Excel Masterclass Course

By Training Express

Microsoft Excel Diploma Course

By One Education

Microsoft Excel Course for Everyone - Complete Excel Course

By Apex Learning

Microsoft Excel in Accounting Course

By Training Express

Microsoft Excel - Spreadsheet for Beginners Course

By One Education