Name: Work from Home Essentials Courses
Price: 69 GBP
Availability: InStock

Overview
★★ 24 Hour Limited Time Flash Sale ★★
Level 7 Advanced Diploma in MS Excel - QLS Endorsed
***Key Features of Advanced Diploma in MS Excel at QLS Level 7***
Free QLS Certificate
Free CPD PDF Certificate + Transcript
Have you ever wondered how some professionals seem to have an extraordinary command over MS Excel? The "Level 7 Advanced Diploma in MS Excel" promises to transform your capabilities with this powerful tool. Imagine mastering MS Excel to the point where its advanced features become second nature, turning data management and analysis into an effortless task. This course is designed for those who aspire to push their proficiency beyond the basics and delve into complex functionalities and techniques.
The "Level 7 Advanced Diploma in MS Excel" equips you with a deep understanding of advanced features and sophisticated functions. With a focus on MS Excel, you'll explore various aspects such as complex formulas, data visualisation, and automation, all crucial for advanced data handling. The programme is structured to ensure that you not only learn theoretical concepts but also apply them effectively, enhancing your ability to make data-driven decisions and streamline processes.
By completing this diploma, you will gain an elite level of competence in MS Excel, setting you apart in the competitive job market. This course is meticulously crafted to cover all advanced elements of MS Excel, ensuring that every skill you acquire can be immediately applied to professional tasks. Embrace this opportunity to elevate your expertise and stand out with a qualification that highlights your advanced capabilities in MS Excel.
Learning Outcomes
Develop an advanced understanding of MS Excel functions and features.
Master complex formula creation and application in MS Excel.
Enhance skills in MS Excel data analysis and interpretation.
Utilise MS Excel for sophisticated data visualisation techniques.
Streamline workflows through MS Excel automation tools.
Apply advanced MS Excel techniques to different data problems.
Integrate MS Excel with other software for comprehensive data solutions.
Solve complex data-related challenges using MS Excel.
Improve decision-making processes through advanced MS Excel analysis.
Demonstrate a high level of proficiency in MS Excel for professional environments.
Certificates
Digital Certificate
This course comes with a free CPD Accredited PDF Copy certificate+ Transcript (according to the Learner's Choice). For additional courses, it costs £14.99 per copy.
Level 7 QLS Endorsed Hardcopy Certificate
Hard copy certificate - Included
Certificate delivery is Free for UK residents, whereas it costs £10 for international students as a delivery charge.
Note: Skill-up is a Janets-approved resale partner for Quality Licence Scheme Endorsed courses.
Course Description
The "Level 7 Advanced Diploma in MS Excel" is a comprehensive programme designed to enhance your mastery of MS Excel. Covering advanced functions, data analysis, and automation techniques, this course offers a deep dive into MS Excel's capabilities. Ideal for professionals looking to excel in data management, the diploma ensures you gain essential skills and a robust understanding of advanced Excel functionalities.
Who is this course for?
Professionals seeking to advance their MS Excel skills.
Data analysts aiming to enhance their analytical capabilities.
Project managers needing advanced data management tools.
Financial analysts looking to optimise their spreadsheet functions.
Anyone wanting to improve their proficiency in MS Excel for career advancement.
Requirements
Basic understanding of MS Excel functions and features.
Familiarity with data analysis principles.
Proficiency in using computers and software applications.
Career path
Data Analyst: £30,000 - £50,000
Financial Analyst: £35,000 - £55,000
Business Intelligence Analyst: £40,000 - £60,000
Project Manager: £45,000 - £70,000
Operations Manager: £50,000 - £75,000
Spreadsheet Specialist: £28,000 - £45,000


Skill Up

Microsoft Certification

Microsoft Excel

Level 7 QLS Endorsed Diploma | 180 CPD Points | +Gifts: QLS Certificate + PDF Certificate | 24/7 Learner Support


Level 7 Advanced Diploma in MS Excel - QLS Endorsed


General Admission

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

<div>
<table>				<tbody><tr>
					<td colspan="4">You Can Master Microsoft Outlook </td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>
						You Can Master Microsoft Outlook Promo					</td>

					
					<td> </td>
					<td><span><i></i> 00:02:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>
						You Can Ask Me Anytime					</td>

					
					<td> </td>
					<td><span><i></i> 00:01:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>
						Your Facebook Support Group					</td>

					
					<td> </td>
					<td><span><i></i> 00:01:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>
						Quick Win - How To Send an Email in Outlook					</td>

					
					<td> </td>
					<td><span><i></i> 00:01:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>
						Quick Win - How To Print an Email in Outlook					</td>

					
					<td> </td>
					<td><span><i></i> 00:01:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>
						Another Quick Win - You Can Work Offline With Outlook					</td>

					
					<td> </td>
					<td><span><i></i> 00:01:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Getting Started With Outlook</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>
						Outlook Environment					</td>

					
					<td> </td>
					<td><span><i></i> 00:03:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>
						Outlook Opening					</td>

					
					<td> </td>
					<td><span><i></i> 00:02:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>
						Outlook Interface Options					</td>

					
					<td> </td>
					<td><span><i></i> 00:04:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>
						Sending and Receiving Email in Outlook					</td>

					
					<td> </td>
					<td><span><i></i> 00:03:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>
						Sending and Receiving Email in Outlook with Attachments					</td>

					
					<td> </td>
					<td><span><i></i> 00:02:00</span></td>
				</tr>
								<tr>
					<td colspan="4">File Menu</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>
						Account Settings in Outlook					</td>

					
					<td> </td>
					<td><span><i></i> 00:06:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>
						Automatic Replies in Outlook					</td>

					
					<td> </td>
					<td><span><i></i> 00:04:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>
						Mail Box Settings in Outlook					</td>

					
					<td> </td>
					<td><span><i></i> 00:02:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>
						Rules and Alerts Settings in Outlook					</td>

					
					<td> </td>
					<td><span><i></i> 00:04:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>
						Exporting and Importing Rules and Alerts in Outlook					</td>

					
					<td> </td>
					<td><span><i></i> 00:01:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>
						Opening Options in File Outlook					</td>

					
					<td> </td>
					<td><span><i></i> 00:04:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Home - New Email in Outlook</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>
						Quick Win - How To Create Folder in Outlook					</td>

					
					<td> </td>
					<td><span><i></i> 00:01:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>
						Quick Win - How To Change Outlook Style					</td>

					
					<td> </td>
					<td><span><i></i> 00:01:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>
						Quick Win - How To Use Quick Access Toolbar					</td>

					
					<td> </td>
					<td><span><i></i> 00:01:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>
						New Email Options in Outlook					</td>

					
					<td> </td>
					<td><span><i></i> 00:03:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>
						Clipboard in New Email					</td>

					
					<td> </td>
					<td><span><i></i> 00:05:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>
						Basic Text in New Email					</td>

					
					<td> </td>
					<td><span><i></i> 00:07:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>
						Name, Include and Tags in New Email					</td>

					
					<td> </td>
					<td><span><i></i> 00:03:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>
						Inserting Table Into New Email					</td>

					
					<td> </td>
					<td><span><i></i> 00:10:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>
						Inserting Images Into New Email					</td>

					
					<td> </td>
					<td><span><i></i> 00:10:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>
						Inserting Shapes Into New Email					</td>

					
					<td> </td>
					<td><span><i></i> 00:06:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>
						Inserting SmartArt Into New Email					</td>

					
					<td> </td>
					<td><span><i></i> 00:04:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>
						Inserting New Chart Into New Email					</td>

					
					<td> </td>
					<td><span><i></i> 00:05:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>
						Taking Screenshot Into New Email					</td>

					
					<td> </td>
					<td><span><i></i> 00:02:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>
						Links, Text and Symbol					</td>

					
					<td> </td>
					<td><span><i></i> 00:03:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>
						Themes, Show Fields, Encrypt, Tracking and More Options in New Email					</td>

					
					<td> </td>
					<td><span><i></i> 00:03:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>
						Formatting Text in New Emails					</td>

					
					<td> </td>
					<td><span><i></i> 00:03:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>
						Text Style in New Email					</td>

					
					<td> </td>
					<td><span><i></i> 00:04:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>
						Reviewing Menu in New Email					</td>

					
					<td> </td>
					<td><span><i></i> 00:03:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Home - New Appointment</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>
						New Appointment at Home Menu					</td>

					
					<td> </td>
					<td><span><i></i> 00:06:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Home - New Meeting </td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>
						New Meeting at Home Menu					</td>

					
					<td> </td>
					<td><span><i></i> 00:01:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Home -  New Contact </td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>
						New Contact in Home Menu					</td>

					
					<td> </td>
					<td><span><i></i> 00:05:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Home - New Task</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>
						Create New Task					</td>

					
					<td> </td>
					<td><span><i></i> 00:03:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>
						Other New Item in Home					</td>

					
					<td> </td>
					<td><span><i></i> 00:02:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Home -  Other Functions</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>
						Email Deletion in Outlook					</td>

					
					<td> </td>
					<td><span><i></i> 00:02:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>
						Responding to A Email in Outlook					</td>

					
					<td> </td>
					<td><span><i></i> 00:02:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>
						Quick Steps, Tag and Other Functions					</td>

					
					<td> </td>
					<td><span><i></i> 00:03:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Send and Receive</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>
						Complete Guide of Send and Receive					</td>

					
					<td> </td>
					<td><span><i></i> 00:03:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Home - Folder </td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>
						Complete Folder Guide					</td>

					
					<td> </td>
					<td><span><i></i> 00:05:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Review and Outlook</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>
						View and Help in Outlook					</td>

					
					<td> </td>
					<td><span><i></i> 00:04:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Options</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>
						Options Intro					</td>

					
					<td> </td>
					<td><span><i></i> 00:03:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>
						General Options in Outlook					</td>

					
					<td> </td>
					<td><span><i></i> 00:05:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>
						Mail Options in Outlook					</td>

					
					<td> </td>
					<td><span><i></i> 00:06:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>
						Calendar Options in Outlook					</td>

					
					<td> </td>
					<td><span><i></i> 00:03:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>
						Contact Options in Outlook					</td>

					
					<td> </td>
					<td><span><i></i> 00:01:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>
						Task Options in Outlook					</td>

					
					<td> </td>
					<td><span><i></i> 00:01:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>
						Search Options in Outlook					</td>

					
					<td> </td>
					<td><span><i></i> 00:02:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>
						Language Options in Outlook					</td>

					
					<td> </td>
					<td><span><i></i> 00:02:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>
						Ease of Access Options in Outlook					</td>

					
					<td> </td>
					<td><span><i></i> 00:02:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>
						Advanced Option in Outlook					</td>

					
					<td> </td>
					<td><span><i></i> 00:04:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>
						Ribbon and Quick Access Toolbar Customization					</td>

					
					<td> </td>
					<td><span><i></i> 00:02:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Security Is Everything</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>
						Quick Win - Create Unknown Password					</td>

					
					<td> </td>
					<td><span><i></i> 00:01:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>
						Security Is Everthing					</td>

					
					<td> </td>
					<td><span><i></i> 00:01:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>
						Quick Win - Insecurity Is Coming from You And Others					</td>

					
					<td> </td>
					<td><span><i></i> 00:01:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>
						Understand Security Type or Category					</td>

					
					<td> </td>
					<td><span><i></i> 00:02:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>
						Life Savers - You Should Know These					</td>

					
					<td> </td>
					<td><span><i></i> 00:04:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>
						Have Proper Password - Start Securing You Now					</td>

					
					<td> </td>
					<td><span><i></i> 00:03:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>
						Don't Use the Same Password Anymore					</td>

					
					<td> </td>
					<td><span><i></i> 00:02:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>
						Should You Use Longer Password or Complicated!					</td>

					
					<td> </td>
					<td><span><i></i> 00:03:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>
						Last-Pass &amp; Authy Mobile App					</td>

					
					<td> </td>
					<td><span><i></i> 00:02:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>
						The Best and Only Solution to Make and Keep Password Un-Crack-Able					</td>

					
					<td> </td>
					<td><span><i></i> 00:08:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>
						Lastpass Setup and Configure					</td>

					
					<td> </td>
					<td><span><i></i> 00:10:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>
						Last-Pass Options Part 1					</td>

					
					<td> </td>
					<td><span><i></i> 00:03:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>
						Last-Pass Options Part 2					</td>

					
					<td> </td>
					<td><span><i></i> 00:04:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>
						Last-Pass Option Part 3					</td>

					
					<td> </td>
					<td><span><i></i> 00:04:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>
						2FA Makes You Even Stronger in Password					</td>

					
					<td> </td>
					<td><span><i></i> 00:05:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>
						Security Is Everything, Keep Secured Your Devices					</td>

					
					<td> </td>
					<td><span><i></i> 00:07:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>
						Security on Your Data and Privacy					</td>

					
					<td> </td>
					<td><span><i></i> 00:08:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Conclusion</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>
						Congratulations					</td>

					
					<td> </td>
					<td><span><i></i> 00:01:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Certificate of Achievement</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>
						Certificate of Achievement					</td>

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

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

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

			</div>

Study Plex

Microsoft Outlook Mastering Program

<div>
	<h3><strong>Description</strong></h3>
<p><span>You have a basic knowledge on MS Access 2016, besides you want to know more about it to use in your practical life, but you don't know how to work on it and which course is effective for your learning.  Don't worry. To become better at MS Access, take a look at our MS Access 2016 Intermediate course. It will assist you to reach your need.</span></p>
<p><span>The course designs in such a way that will assist you to learn the fundamental issues of MS Access including information gathering, data analysis, and proper management of the relevant information system. The MS Access 2016 Intermediate course helps you to make table chart for justifying the accuracy of data entry, learn automation system, and insert charts and column. The course aims at the clear understanding and functioning of Word and Excel, adding and deleting table data, reviewing the advanced searching techniques; Parameter queries, Crosstab queries and working with total and other different techniques of report and form regarding Tab controls, sub-Forms, Combo Box controls, Sub-reports, and column.</span></p>
<h3><b>Assessment:</b></h3>
<p>This course does not involve any MCQ test. Students need to answer assignment questions to complete the course, the answers will be in the form of written work in pdf or word. Students can write the answers in their own time. Once the answers are submitted, the instructor will check and assess the work.</p>
<h3><strong>Certification:</strong></h3>
<p>After completing and passing the course successfully, you will be able to obtain an Accredited Certificate of Achievement. Certificates can be obtained either in hard copy at a cost of £39 or in PDF format at a cost of £24.</p>
<h3><b>Who is this Course for?</b></h3>
<p><strong>MS Access 2016 Intermediate</strong> is certified by CPD Qualifications Standards and CiQ. This makes it perfect for anyone trying to learn potential professional skills.</p>
<p>As there is no experience and qualification required for this course, it is available for all students from any academic background.</p>
<h3><b>Requirements</b></h3>
<p>Our<b> MS Access 2016 Intermediate</b> is fully compatible with any kind of device. Whether you are using Windows computer, Mac, smartphones or tablets, you will get the same experience while learning. Besides that, you will be able to access the course with any kind of internet connection from anywhere at any time without any kind of limitation.</p>
<h3><b>Career Path</b></h3>
<p>After completing this course you will be able to build up accurate knowledge and skills with proper confidence to enrich yourself and brighten up your career in the relevant job market.</p>
		</div><table width="100%">				<tbody><tr>
					<td colspan="4">Introduction</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Introduction</td>
					<td><span>FREE</span> </td>
					<td><span><i></i> 00:01:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Designing Tables for Better Data Entry</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Reviewing Table Design Principles</td>
					<td> </td>
					<td><span><i></i> 00:04:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Setting Field Size, Formats and Captions</td>
					<td> </td>
					<td><span><i></i> 00:06:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Setting Default Value and Required Fields</td>
					<td> </td>
					<td><span><i></i> 00:03:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Restricting Data Entry Using Data Validation</td>
					<td> </td>
					<td><span><i></i> 00:02:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Restricting Data Entry Using Input Masks</td>
					<td> </td>
					<td><span><i></i> 00:06:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Sharing Data with Other Applications</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Exporting Tables and Queries to Excel</td>
					<td> </td>
					<td><span><i></i> 00:03:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Importing Data from a TXT File</td>
					<td> </td>
					<td><span><i></i> 00:03:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Importing Data from Excel</td>
					<td> </td>
					<td><span><i></i> 00:02:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Exporting Data to a TXT File</td>
					<td> </td>
					<td><span><i></i> 00:02:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Linking External Data Sources</td>
					<td> </td>
					<td><span><i></i> 00:03:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Using Word Merge</td>
					<td> </td>
					<td><span><i></i> 00:02:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Working with Action Queries</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>What are Action Queries</td>
					<td> </td>
					<td><span><i></i> 00:00:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Creating an Update Query</td>
					<td> </td>
					<td><span><i></i> 00:02:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Creating an Append Query</td>
					<td> </td>
					<td><span><i></i> 00:03:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Creating a Delete Query</td>
					<td> </td>
					<td><span><i></i> 00:02:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Creating a Make Table Query</td>
					<td> </td>
					<td><span><i></i> 00:02:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Changing the Start Number of an Auto Number Field</td>
					<td> </td>
					<td><span><i></i> 00:03:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Advanced Query Techniques</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Creating Query Joins</td>
					<td> </td>
					<td><span><i></i> 00:05:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Creating Find Unmatached and Find Duplicate Queries</td>
					<td> </td>
					<td><span><i></i> 00:03:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Creating Parameter Queries</td>
					<td> </td>
					<td><span><i></i> 00:08:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Using -Like- Keyword in Parameter Queries</td>
					<td> </td>
					<td><span><i></i> 00:02:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Creating a Top X Query</td>
					<td> </td>
					<td><span><i></i> 00:01:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Reviewing Calculated Query Fields</td>
					<td> </td>
					<td><span><i></i> 00:03:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Summarizing Query Data with Totals</td>
					<td> </td>
					<td><span><i></i> 00:02:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Inserting Where Statements in Summary Queries</td>
					<td> </td>
					<td><span><i></i> 00:01:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Creating a Crosstab Query</td>
					<td> </td>
					<td><span><i></i> 00:03:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Automating Processes with Macros</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Understanding Macro Basics</td>
					<td> </td>
					<td><span><i></i> 00:06:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Creating Macros to Open Forms by Record</td>
					<td> </td>
					<td><span><i></i> 00:04:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Validating Data Entry with Macros</td>
					<td> </td>
					<td><span><i></i> 00:04:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Creating a Macro to Automate Data Entry</td>
					<td> </td>
					<td><span><i></i> 00:04:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Advanced Data Entry Using Macros and DLOOKUP Function</td>
					<td> </td>
					<td><span><i></i> 00:06:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Advanced Form</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Using Conditional Formatting</td>
					<td> </td>
					<td><span><i></i> 00:02:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Organizing Form Fields with Tab Controls</td>
					<td> </td>
					<td><span><i></i> 00:03:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Creating a Combo Box Control</td>
					<td> </td>
					<td><span><i></i> 00:02:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Creating an Option Group Control</td>
					<td> </td>
					<td><span><i></i> 00:03:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Using a Subform to Show Data from a Related Table</td>
					<td> </td>
					<td><span><i></i> 00:03:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Advanced Report Techniques</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Inserting a Chart on a Report</td>
					<td> </td>
					<td><span><i></i> 00:03:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Showing Data in Columns</td>
					<td> </td>
					<td><span><i></i> 00:02:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Inserting a Subreport</td>
					<td> </td>
					<td><span><i></i> 00:02:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Configuring Reports with Parameter Queries</td>
					<td> </td>
					<td><span><i></i> 00:04:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Sending Reports</td>
					<td> </td>
					<td><span><i></i> 00:02:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Conclusion</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Course Recap</td>
					<td> </td>
					<td><span><i></i> 00:00:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Resources</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Resources - MS Access 2016 Intermediate</td>
					<td> </td>
					<td><span><i></i> 00:00:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Certificate and Transcript</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Order Your Certificates and Transcripts</td>
					<td> </td>
					<td><span><i></i> 00:00:00</span></td>
				</tr>
				</tbody></table>

John Academy

Microsoft Forms

Microsoft AZ-900

Computer Skills

Microsoft AZ-104

Microsoft Access

Microsoft AZ-303

MS Access 2016 Intermediate

<div>
	<h3><b>Description</b></h3>
<p><span>Our Microsoft Access course is designed to take your skills from basic to advanced level. Gain knowledge about Microsoft access from scratch to the advanced level. Learn step by step how to use Microsoft Access as professional. Whether new to Microsoft Access or looking forward to enhancing your current skills using this program, then you have selected the right course. Explore the functions various and features of Microsoft Access. In this course you will learn the necessary skills, knowledge and information of Microsoft Access. </span></p>
<h3><b>Who is this course for?</b></h3>
<ul>
<li><span>This course is perfect for individuals who are looking forward to developing their skills of using Microsoft Access.</span></li>
<li><span>Project-based technical analysts and engineers.</span></li>
</ul>
<h3><b>Entry Requirement:</b></h3>
<ul>
<li><span>This course is available to all learners, of all academic backgrounds. </span></li>
<li><span>Learners should be aged 16 or over to undertake the qualification.</span></li>
<li><span>Good understanding of English language, numeracy and ICT are required to attend this course.</span></li>
</ul>
<h3><b>Assessment:  </b></h3>
<ul>
<li><span>At the end of the course, you will be required to sit an online multiple-choice test. Your test will be assessed automatically and immediately so that you will instantly know whether you have been successful.</span></li>
<li><b><span>Before sitting for your final exam, you will have the opportunity to test your proficiency with a mock exam. </span></b></li>
</ul>
<h3><b>Certification: </b></h3>
<ul>
<li><span>After you have successfully passed the test, you will be able to obtain an Accredited Certificate of Achievement. You can however also obtain a Course Completion Certificate following the course completion without sitting for the test. Certificates can be obtained either in hard copy at the cost of £39 or in PDF format at the cost of £24. </span></li>
<li><span>PDF certificate's turnaround time is 24 hours, and for the hardcopy certificate, it is 3-9 working days.</span></li>
</ul>
<h3><b>Why choose us?</b></h3>
<ul>
<li><span>Affordable, engaging &amp; high-quality e-learning study materials;</span></li>
<li><span>Tutorial videos/materials from the industry leading experts;</span></li>
<li><span>Study in a user-friendly, advanced online learning platform;</span></li>
<li><span>Efficient exam systems for the assessment and instant result; </span></li>
<li><span>The UK &amp; internationally recognized accredited qualification;</span></li>
<li><span>Access to course content on mobile, tablet or desktop from anywhere anytime;</span></li>
<li><span>The benefit of career advancement opportunities;</span></li>
<li><span>24/7 student support via email.</span></li>
</ul>
<h3><b>Career Path:</b></h3>
<p><span>The Level 3 Diploma in Microsoft Access 2010 will be very beneficial and helpful, especially to the following professionals:</span></p>
<ul>
<li><span>Software Engineer.</span></li>
<li><span>Technical Support.</span></li>
<li><span>Technical Sales.</span></li>
<li><span>Business Analyst.</span></li>
<li><span>Web Developer.</span></li>
<li><span>Software Tester.</span></li>
</ul>
		</div><table width="100%">				<tbody><tr>
					<td colspan="4">Microsoft Access 2010 for Beginners</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Module One - Getting Started</td>
					<td> </td>
					<td><span><i></i> 00:30:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Module Two - Getting Started With Access</td>
					<td> </td>
					<td><span><i></i> 01:00:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Module Three - Using the Access Interface</td>
					<td> </td>
					<td><span><i></i> 01:00:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Module Four - Working with Database Objects</td>
					<td> </td>
					<td><span><i></i> 01:00:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Module Five - Creating Tables</td>
					<td> </td>
					<td><span><i></i> 01:00:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Module Six - Working with Tables</td>
					<td> </td>
					<td><span><i></i> 01:00:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Module Seven - Creating Forms</td>
					<td> </td>
					<td><span><i></i> 01:00:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Module Eight - Working with Forms</td>
					<td> </td>
					<td><span><i></i> 01:00:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Module Nine - Creating Reports</td>
					<td> </td>
					<td><span><i></i> 01:00:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Module Ten - Creating Queries</td>
					<td> </td>
					<td><span><i></i> 01:00:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Module Eleven - Managing Your Database</td>
					<td> </td>
					<td><span><i></i> 01:00:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Module Twelve - Wrapping Up</td>
					<td> </td>
					<td><span><i></i> 00:30:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Activities - Microsoft Access 2010 for Beginners</td>
					<td> </td>
					<td><span><i></i> 00:00:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Microsoft Access 2010 for Intermediate Level</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Module One - Getting Started</td>
					<td> </td>
					<td><span><i></i> 00:30:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Module Two - Working with the Access Environment</td>
					<td> </td>
					<td><span><i></i> 01:00:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Module Three - Working with Access Options (I)</td>
					<td> </td>
					<td><span><i></i> 01:00:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Module Four - Working with Access Options (II)</td>
					<td> </td>
					<td><span><i></i> 01:00:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Module Five - Working with Tables</td>
					<td> </td>
					<td><span><i></i> 01:00:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Module Six - Importing Table Data</td>
					<td> </td>
					<td><span><i></i> 01:00:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Module Seven - Working with Queries (I)</td>
					<td> </td>
					<td><span><i></i> 01:00:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Module Eight - Working with Queries (II)</td>
					<td> </td>
					<td><span><i></i> 01:00:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Module Nine - Working with Forms</td>
					<td> </td>
					<td><span><i></i> 01:00:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Module Ten - Using Reports</td>
					<td> </td>
					<td><span><i></i> 01:00:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Module Eleven - Using Macros and Code</td>
					<td> </td>
					<td><span><i></i> 01:00:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Module Twelve - Wrapping Up</td>
					<td> </td>
					<td><span><i></i> 00:30:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Activities - Microsoft Access 2010 for Intermediate Level</td>
					<td> </td>
					<td><span><i></i> 00:00:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Microsoft Access 2010 Advanced Level</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Module One - Getting Started</td>
					<td> </td>
					<td><span><i></i> 00:30:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Module Two - Advanced Table Tasks</td>
					<td> </td>
					<td><span><i></i> 01:00:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Module Three - Advanced Form Tasks</td>
					<td> </td>
					<td><span><i></i> 01:00:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Module Four - Advanced Reporting Tasks</td>
					<td> </td>
					<td><span><i></i> 01:00:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Module Five - Understanding Relationships</td>
					<td> </td>
					<td><span><i></i> 01:00:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Module Six - Advanced Query Tasks</td>
					<td> </td>
					<td><span><i></i> 01:00:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Module Seven - Working with SQL</td>
					<td> </td>
					<td><span><i></i> 01:00:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Module Eight - Linking Data</td>
					<td> </td>
					<td><span><i></i> 01:00:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Module Nine - Importing Data</td>
					<td> </td>
					<td><span><i></i> 01:00:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Module Ten - Exporting Data</td>
					<td> </td>
					<td><span><i></i> 01:00:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Module Eleven - Advanced Database Tools</td>
					<td> </td>
					<td><span><i></i> 01:00:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Module Twelve - Wrapping Up</td>
					<td> </td>
					<td><span><i></i> 00:30:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Activities - Microsoft Access 2010 Advanced Level</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- Level 3 Diploma in Microsoft Access 2010</td>
					<td> </td>
					<td><span><i></i> 00:30:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Final Exam</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Final Exam- Level 3 Diploma in Microsoft Access 2010</td>
					<td> </td>
					<td><span><i></i> 00:30:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Certificate and Transcript</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Order Your Certificates and Transcripts</td>
					<td> </td>
					<td><span><i></i> 00:00:00</span></td>
				</tr>
				</tbody></table>

FA Level 1

Trainers Course

Level 3 Diploma in Microsoft Access 2010

<div>
	<h3><b>Description: </b></h3>
<p>Microsoft Access is a database management system (DBMS) from Microsoft. This software combines the relational Jet Database Engine with a graphical user interface and software-development tools. It can also import or link directly to data stored in other applications and databases. Through this course, you will learn the necessary skills, knowledge, and information about Microsoft Access 2013 for the beginner, intermediate, and advanced-level users. Then you learn the different components of the database so that you understand the structure underlying your data.</p>
<h3><b>Who is the course for?</b></h3>
<ul>
<li>Professionals who want to learn about the Microsoft Access 2013</li>
<li>People who have an interest in learning all the features of the Access 2013</li>
</ul>
<h3><b>Entry Requirement:</b></h3>
<ul>
<li><span>This course is available to all learners, of all academic backgrounds. </span></li>
<li><span>Learners should be aged 16 or over to undertake the qualification.</span></li>
<li><span>Good understanding of English language, numeracy and ICT are required to attend this course.</span></li>
</ul>
<h3><b>Assessment:  </b></h3>
<ul>
<li><span>At the end of the course, you will be required to sit an online multiple-choice test. Your test will be assessed automatically and immediately so that you will instantly know whether you have been successful.</span></li>
<li><span>Before sitting for your final exam you will have the opportunity to test your proficiency with a mock exam. </span></li>
</ul>
<h3><b>Certification: </b></h3>
<ul>
<li><span>After you have successfully passed the test, you will be able to obtain an Accredited Certificate of Achievement. You can however also obtain a Course Completion Certificate following the course completion without sitting for the test. Certificates can be obtained either in hardcopy at a cost of £39 or in PDF format at a cost of £24. </span></li>
<li><span>PDF certificate's turnaround time is 24 hours and for the hardcopy certificate, it is 3-9 working days.</span></li>
</ul>
<h3><b>Why choose us?</b></h3>
<ul>
<li><span>Affordable, engaging &amp; high-quality e-learning study materials;</span></li>
<li><span>Tutorial videos/materials from the industry leading experts;</span></li>
<li><span>Study in a user-friendly, advanced online learning platform;</span></li>
<li><span>Efficient exam systems for the assessment and instant result; </span></li>
<li><span>The UK &amp; internationally recognised accredited qualification;</span></li>
<li><span>Access to course content on mobile, tablet or desktop from anywhere anytime;</span></li>
<li><span>The benefit of career advancement opportunities;</span></li>
<li><span>24/7 student support via email.</span></li>
</ul>
<h3><b>Career Path:</b></h3>
<p>The Microsoft Access for Beginners, Intermediate and Advanced course is a useful qualification to possess and would be beneficial for following careers:</p>
<ul>
<li>Software Engineer</li>
<li>Technical Support</li>
<li>Technical Sales</li>
<li>Business Analyst</li>
<li>Web Developer</li>
<li>Software Tester.</li>
</ul>
		</div><table width="100%">				<tbody><tr>
					<td colspan="4">Microsoft Access for Beginners</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Module One - Getting Started</td>
					<td> </td>
					<td><span><i></i> 00:30:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Module Two - Opening and Closing Access</td>
					<td> </td>
					<td><span><i></i> 01:00:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Module Three - An Introduction to Databases</td>
					<td> </td>
					<td><span><i></i> 01:00:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Module Four - Sharing Data Using Apps</td>
					<td> </td>
					<td><span><i></i> 01:00:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Module Five - Working in Your App</td>
					<td> </td>
					<td><span><i></i> 01:00:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Module Six - An Introduction to Desktop Databases</td>
					<td> </td>
					<td><span><i></i> 01:00:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Module Seven - Performing Basic Table Tasks</td>
					<td> </td>
					<td><span><i></i> 01:00:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Module Eight - Working with Fields</td>
					<td> </td>
					<td><span><i></i> 01:00:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Module Nine - Working with Table Relationships</td>
					<td> </td>
					<td><span><i></i> 01:00:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Module Ten - An Introduction to Queries, Forms, and Reports</td>
					<td> </td>
					<td><span><i></i> 01:00:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Module Eleven - Protecting Your Data</td>
					<td> </td>
					<td><span><i></i> 01:00:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Module Twelve - Wrapping Up</td>
					<td> </td>
					<td><span><i></i> 00:30:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Activities - Microsoft Access for Beginners</td>
					<td> </td>
					<td><span><i></i> 00:00:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Microsoft Access for intermediate level  </td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Module One - Getting Started</td>
					<td> </td>
					<td><span><i></i> 00:30:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Module Two - Creating a Custom App</td>
					<td> </td>
					<td><span><i></i> 01:00:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Module Three - Customizing App Actions</td>
					<td> </td>
					<td><span><i></i> 01:00:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Module Four - Customizing Your App Views with Macros</td>
					<td> </td>
					<td><span><i></i> 01:00:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Module Five - Working with Validation Rules and Messages</td>
					<td> </td>
					<td><span><i></i> 01:00:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Module Six - Working with Macros</td>
					<td> </td>
					<td><span><i></i> 01:00:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Module Seven - Advanced Query Tasks</td>
					<td> </td>
					<td><span><i></i> 01:00:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Module Eight - Designing Forms</td>
					<td> </td>
					<td><span><i></i> 01:00:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Module Nine - Advanced Reporting Tasks</td>
					<td> </td>
					<td><span><i></i> 01:00:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Module Ten - Advanced Database Tools</td>
					<td> </td>
					<td><span><i></i> 01:00:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Module Eleven - Working with the Access Environment</td>
					<td> </td>
					<td><span><i></i> 01:00:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Module Twelve - Wrapping Up</td>
					<td> </td>
					<td><span><i></i> 00:30:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Activities - Microsoft Access Intermediate Level</td>
					<td> </td>
					<td><span><i></i> 00:00:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Microsoft Access Advanced Level</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Module One - Getting Started</td>
					<td> </td>
					<td><span><i></i> 00:30:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Module Two - Using App Views</td>
					<td> </td>
					<td><span><i></i> 01:00:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Module Three - Customizing Apps, Part One</td>
					<td> </td>
					<td><span><i></i> 01:00:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Module Four - Customizing Apps, Part Two</td>
					<td> </td>
					<td><span><i></i> 01:00:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Module Five - Working with More Record Tasks</td>
					<td> </td>
					<td><span><i></i> 01:00:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Module Six - Using Advanced Field Tasks</td>
					<td> </td>
					<td><span><i></i> 01:00:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Module Seven - Working in Table Design View</td>
					<td> </td>
					<td><span><i></i> 01:00:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Module Eight - Working with the Expression Builder</td>
					<td> </td>
					<td><span><i></i> 01:00:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Module Nine - Working with External Data</td>
					<td> </td>
					<td><span><i></i> 01:00:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Module Ten - Creating Queries</td>
					<td> </td>
					<td><span><i></i> 01:00:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Module Eleven - Creating Forms and Reports</td>
					<td> </td>
					<td><span><i></i> 01:00:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Module Twelve - Wrapping Up</td>
					<td> </td>
					<td><span><i></i> 00:30:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Activities - Microsoft Access Advanced Level</td>
					<td> </td>
					<td><span><i></i> 00:00:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Refer A Friend</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Refer A Friend</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 Access - Beginners, Intermediate, Advanced</td>
					<td> </td>
					<td><span><i></i> 00:30:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Final Exam</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Final Exam- Microsoft Access - Beginners, Intermediate, Advanced</td>
					<td> </td>
					<td><span><i></i> 00:30:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Certificate and Transcript</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Order Your Certificates and Transcripts</td>
					<td> </td>
					<td><span><i></i> 00:00:00</span></td>
				</tr>
				</tbody></table>

Microsoft AZ-700

Microsoft Access - Beginners, Intermediate & Advanced

<p><strong> Boost Your Career By Enrolling In This Minute Taking &amp; Workplace Confidentiality Bundle To Overcome Your Challenges!</strong></p><p><strong> 5 in 1 Minute Taking &amp; Workplace Confidentiality Bundle </strong></p><p>Improve your knowledge and enhance your skills to succeed with this Minute Taking &amp; Workplace Confidentiality bundle. This Minute Taking &amp; Workplace Confidentiality bundle is designed to build your competent skill set and enable the best possible outcome for your future. Our bundle is ideal for those who aim to be the best in their fields and are always looking to grow.</p><p><strong>This Minute Taking &amp; Workplace Confidentiality Bundle Contains 5 of Our Premium Courses for One Discounted Price:</strong></p><ul><li><strong> Course 01:</strong> Diploma in Minute Taking at QLS Level 5</li><li><strong> Course 02: </strong>Workplace Confidentiality</li><li><strong> Course 03: </strong>Executive and Personal Assistant Training Course</li><li><strong> Course 04: </strong>Essentials Communication for Business</li><li><strong> Course 05: </strong>Microsoft Office</li></ul><p>All the courses under this Minute Taking &amp; Workplace Confidentiality bundle are split into a number of expertly created modules to provide you with an in-depth and comprehensive learning experience. Upon successful completion of the Minute Taking &amp; Workplace Confidentiality bundle, an instant e-certificate will be exhibited in your profile that you can order as proof of your new skills and knowledge. Stand out from the crowd and get trained for the job you want.</p><p>With this comprehensive Minute Taking &amp; Workplace Confidentiality bundle, you can achieve your dreams and train for your ideal career. This Minute Taking &amp; Workplace Confidentiality bundle covers essential aspects in order to progress in your chosen career.</p><p><strong>Why Choose Our Minute Taking &amp; Workplace Confidentiality Course?</strong></p><ul><li>FREE Minute Taking &amp; Workplace Confidentiality certificate accredited</li><li>Get a free student ID card with Minute Taking &amp; Workplace Confidentiality Training</li><li>Get instant access to this Minute Taking &amp; Workplace Confidentiality course.</li><li>Learn Minute Taking &amp; Workplace Confidentiality from anywhere in the world</li><li>Minute Taking &amp; Workplace Confidentiality is affordable and simple to understand</li><li>Minute Taking &amp; Workplace Confidentiality is an entirely online, interactive lesson with voiceover audio</li><li>Lifetime access to the Minute Taking &amp; Workplace Confidentiality course materials</li><li>Minute Taking &amp; Workplace Confidentiality comes with 24/7 tutor support</li><li>So enrol now in this Minute Taking &amp; Workplace Confidentiality Today to advance your career!</li></ul> <p>Start your learning journey straightaway!</p><p>This Minute Taking &amp; Workplace Confidentiality's curriculum has been designed by Minute Taking &amp; Workplace Confidentiality experts with years of Minute Taking &amp; Workplace Confidentiality experience behind them. The Minute Taking &amp; Workplace Confidentiality course is extremely dynamic and well-paced to help you understand Minute Taking &amp; Workplace Confidentiality with ease. You'll discover how to master the Minute Taking &amp; Workplace Confidentiality skill while exploring relevant and essential topics.</p><p><strong>Assessment Process</strong></p><p>Once you have completed all the courses in the Minute Taking &amp; Workplace Confidentiality bundle, you can assess your skills and knowledge with an optional assignment. Our expert trainers will assess your assignment and give you feedback afterwards.</p> <h2>
        
        <div>CPD</div>
    </h2>

                        <div id="cpd">
                            <div>
                                <div>
                                    <div>
                                        200 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 Minute Taking &amp; Workplace Confidentiality bundle is suitable for everyone.</p>
                        </div> <h2>
        
        <div>Career path</div>
    </h2>

                        <div id="career_path">
                            <p>This Minute Taking &amp; Workplace Confidentiality bundle will allow you to kickstart or take your career in the related sector to the next stage.</p>
                        </div> <h2>
        
        <div>Certificates</div>
    </h2>

                        <div id="optional_extras">
                                    <h4> Digital certificate</h4>
        <p>
            Digital certificate -
            £10
        </p>
        <h4> Hard copy certificate</h4>
        <p>
            Hard copy certificate -
            £29
        </p>
            <div><p>You can order your hard copy certificates at the cost of £29 (for each course).</p></div>

                        </div>

Academy for Health and Fitness

Minute Taking & Workplace Confidentiality - CPD Certified

<p><strong>Admin, secretaries, and PAs</strong> play a vital role in any organisation, providing essential support to executives and teams. They handle a wide range of tasks, from managing calendars and organising meetings to preparing presentations and writing reports.These professionals command salaries that span from £20,000 to £40,000 annually. <strong>The UK</strong> job market for these professionals is booming, with demand expected to rise by <strong>12% in the next five years</strong>.</p><p>If you're looking for a rewarding and in-demand career, consider becoming an admin, secretary, or PA, our<strong> Level 5 Admin, Secretarial &amp; PA </strong>course will give you the skills and knowledge you need to launch a successful career in this field. You'll learn everything from the basics of office administration to more advanced topics such as business writing, time management, and customer service. These skills are essential for success in any career, but they are especially important in the administrative field.</p><p>Behind the seamless operations of every successful business is a linchpin, orchestrating a myriad of tasks effortlessly-be it an admin, a secretary, or a personal assistant. Administrative assistants, secretaries, and personal assistants are essential to the smooth running of any business. They provide a wide range of support services, including managing diaries, organising meetings, handling correspondence, and providing customer service. In the <strong>Uk</strong>, job demand for administrative assistants, secretaries, and personal assistants is expected to grow by <strong>10% over the next five years.</strong></p><p>Our "<strong>Admin, Secretarial &amp; PA - Level 5</strong>" course unfolds this intricate ballet of responsibilities. From mastering the art of effective administration, honing impeccable business writing skills, to orchestrating intricate travel arrangements, this Admin, Secretarial &amp; PA course covers it all. Enrolling is more than a career move; it's embracing a role that's often the heartbeat of an organisation, ensuring its rhythm never falters.</p><p>This Admin, Secretarial &amp; PA course starts with the basics of Admin, Secretarial &amp; PA and gradually progresses towards advanced topics. Therefore, each lesson of this Admin, Secretarial &amp; PA course is intuitive and easy to understand.</p><p><strong>Level 5 Admin, Secretarial &amp; PA Course Learning Outcomes:</strong></p><ul><li>Master fundamentals of office and administrative support.</li><li>Develop top-tier business communication skills.</li><li>Grasp the intricacies of effective diary management.</li><li>Cultivate unparalleled business writing proficiency.</li><li>Understand key principles of efficient time management.</li><li>Familiarise with essential tools for impeccable customer service.</li><li>Delve into the nuances of invoicing and cash handling.</li></ul><p><strong>GIft CPD Accredited Courses:</strong></p><ol><li>Office Admin and Organisation Skills</li><li>Leadership and Management Level 7</li><li>Employment Law</li><li>Minute Taking Course</li><li>Microsoft Office Bundle</li></ol><p><strong> Admin, Secretarial &amp; PA </strong></p><p><strong>Learning Outcomes:</strong></p><ul><li>Understand core roles of Admin, Secretarial &amp; PA.</li><li>Master skills essential for effective office administration.</li><li>Navigate responsibilities of a professional receptionist seamlessly.</li><li>Enhance business communication and telephone skills.</li><li>Manage diaries, meetings, and note-taking effectively.</li><li>Improve organisational and record-keeping prowess.</li><li>Foster stronger customer service and planning capabilities.</li></ul><p><strong>Curriculum Breakdown of the Admin, Secretarial &amp; PA Course</strong></p><p><strong>Admin, Secretarial &amp; PA Course Curriculum:</strong></p><ul><li>Introduction to Admin Support Assistant</li><li>Introduction to Personal Assistant</li><li>Introduction to Office Administration</li><li>Skills of an Effective Administrator</li><li>Introduction to Reception and Receptionist</li><li>Business Telephone Skills</li><li>Representing Your Boss and Company</li><li>Business Etiquette</li><li>Mail Services and Shipping</li><li>Travel Arrangements</li><li>Organising Meeting and Conferences</li><li>Diary Management and Note-taking</li><li>Time Management</li><li>Record Keeping and Filing Systems</li><li>Business Writing Skills</li><li>Organisational Skills</li><li>Communication Skills</li><li>Customer Service</li><li>Effective Planning and Scheduling</li><li>Invoicing Petty Cash</li></ul><p><strong><strong>Endorsed Certificate of Achievement from the Quality Licence Scheme</strong></strong></p><p>Learners can achieve a QLS endorsed certificate after completing the course as proof of their achievement. You can order the endorsed certificate for Free to be delivered to your home by post. For international students.</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>The Admin, Secretarial &amp; PA course helps aspiring professionals who want to obtain the knowledge and familiarise themselves with the skillsets to pursue a career in Admin, Secretarial &amp; PA. It is also great for professionals who are already working in Admin, Secretarial &amp; PA and want to get promoted at work.</p>
                        </div><h2>
        
        <div>Requirements</div>
    </h2>

                        <div id="requirements">
                            <p>To enrol in this Admin, Secretarial &amp; PA course, all you need is a basic understanding of the English Language and an internet connection.</p>
                        </div><h2>
        
        <div>Career path</div>
    </h2>

                        <div id="career_path">
                            <p>The Admin, Secretarial &amp; PA course will enhance your knowledge and improve your confidence in exploring opportunities in various sectors related to Admin, Secretarial &amp; PA.</p><ul><li>Executive Assistant: £25,000 to £45,000 per year</li><li>Office Manager: £22,000 to £40,000 per year</li><li>Personal Assistant (PA): £20,000 to £35,000 per year</li><li>Administrative Coordinator: £20,000 to £30,000 per year</li></ul>
                        </div><h2>
        
        <div>Certificates</div>
    </h2>

                        <div id="optional_extras">
                                    <h4>CPD Accredited Hard Copy Certificate</h4>
        <p>
            Hard copy certificate -
            Included
        </p>
            <div><p><strong>CPD Accredited Hard Copy Certificate</strong></p><p><strong>Delivery Charge:</strong></p><p>Inside the UK: £3.99 each</p><p>Outside of the UK: £9.99 each</p></div>
        <h4>CPD Accredited PDF Certificate</h4>
        <p>
            Digital certificate -
            Included
        </p>
            <div><p><strong>CPD Accredited PDF Certificate</strong></p></div>
        <h4>QLS Endorsed Hard Copy Certificate</h4>
        <p>
            Hard copy certificate -
            Included
        </p>

                        </div>

Compliance Central

Admin, Secretarial & PA - Level 5 QLS Endorsed

<p>Give a compliment to your career and take it to the next level. This<strong> Certificate in Know Your Customer &amp; Customer Due Diligence </strong>bundle will provide you with the essential knowledge to shine in your professional career. Whether you want to develop skills for your next job or elevate your skills for your next promotion, this Certificate in Know Your Customer &amp; Customer Due Diligence bundle will help you stay ahead of the pack.</p><p>Throughout the Certificate in Know Your Customer &amp; Customer Due Diligence programme, it stresses how to improve your competency as a person in your chosen field while also outlining essential career insights in the relevant job sector.</p><p>Along with this Certificate in Know Your Customer &amp; Customer Due Diligence course, you will get <strong>10 premium courses, an original hardcopy</strong>, <strong>11 PDF certificates (Main Course + Additional Courses) </strong>Student ID card as gifts.</p><p><strong>This Certificate in Know Your Customer &amp; Customer Due Diligence Bundle Consists of the following Premium courses: </strong></p><ul><li><strong> Course 01: </strong>Certificate in Know Your Customer &amp; Customer Due Diligence</li><li><strong> Course 02: </strong>Customer Service Management</li><li><strong> Course 03: </strong>Customer Relationship Management</li><li><strong> Course 04: </strong>Sales: Psychology of Customers</li><li><strong> Course 05: </strong>Phone-Based Customer Service</li><li><strong> Course 06: </strong>The Formula to Talk with Strangers</li><li><strong> Course 07: </strong>Dealing With Difficult People Training Course</li><li><strong> Course 08: </strong>Public Speaking and Presentation Skill Course</li><li><strong> Course 09: </strong>Level 2 Microsoft Office Essentials</li><li><strong> Course 10: </strong>Time Management</li><li><strong> Course 11: </strong>Stress Management Training</li></ul><p>Enrol now in Certificate in Know Your Customer &amp; Customer Due Diligence to advance your career, and use the premium study materials from Apex Learning.</p><p>The bundle incorporates basic to advanced level skills to shed some light on your way and boost your career. Hence, you can strengthen your Certificate in Know Your Customer &amp; Customer Due Diligence expertise and essential knowledge, which will assist you in reaching your goal. Moreover, you can learn from any place in your own time without travelling for classes.<br /><br /><strong>Course Curriculum: </strong></p><p><strong>Certificate in Know Your Customer &amp; Customer Due Diligence</strong></p><ul><li>Module 01: Introduction to KYC</li><li>Module 02: Customer Due Diligence</li><li>Module 03: AML (Anti-Money Laundering)</li><li>Module 04: KYC, AML, and Data Privacy Regulations for Businesses Operations in the United Kingdom</li><li>Module 05: Regulations to be Complied by Industries</li><li>Module 06: Methods for carrying out KYC and AML and the Future of KYC Compliance</li></ul><p>And 10 more courses ...</p><h2>
        
        <div>CPD</div>
    </h2>

                        <div id="cpd">
                            <div>
                                <div>
                                    <div>
                                        115 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>Anyone from any background can enrol in this Certificate in Know Your Customer &amp; Customer Due Diligence bundle.</p>
                        </div><h2>
        
        <div>Requirements</div>
    </h2>

                        <div id="requirements">
                            <p>This Certificate in Know Your Customer &amp; Customer Due Diligence course has been designed to be fully compatible with tablets and smartphones.</p>
                        </div><h2>
        
        <div>Career path</div>
    </h2>

                        <div id="career_path">
                            <p>Having this expertise will increase the value of your CV and open you up to multiple job sectors.</p>
                        </div><h2>
        
        <div>Certificates</div>
    </h2>

                        <div id="optional_extras">
                                    <h4>Certificate of completion</h4>
        <p>
            Digital certificate -
            Included
        </p>
            <div> <p>Cost of PDF Certificates is included in course price</p> </div>
        <h4>Certificate of completion</h4>
        <p>
            Hard copy certificate -
            Included
        </p>
            <div> <p>You will get the Hard Copy certificate for the title course (Certificate in Know Your Customer &amp; Customer Due Diligence) absolutely Free! Other Hard Copy certificates are available for £10 each. </p><p><strong>Please Note:</strong> The delivery charge inside the UK is £3.99, and the international students must pay a £9.99 shipping cost.</p> </div>

                        </div>

Apex Learning

Know Your Customer (KYC)

Certified Cryptocurrency Investigator Course (CCI)

Certificate in Further Education & Training (Cert Ed)

IT Certifications

Certificate in Education & Training (CET)

ICDL (International Certification of Digital Literacy)

Certificate in Know Your Customer & Customer Due Diligence

<div>
	<h3><b>Description: </b></h3>
<p><span>Performing basic word processing functions is essential to utilize the Microsoft Word 2007. Through this course, you will learn the necessary skills, knowledge, and information about Microsoft Word 2007. You will learn how to select text; use drag and drop function, and even using how to cut, copy, and paste into your document. You will know all about the basic Word's interface and utilize the basic functions this program could offer.</span></p>
<h3><b>Who is the course for?</b></h3>
<ul>
<li><span>Professionals who want to learn about the Microsoft Word 2007</span></li>
<li><span>People who have an interest in the basics and features of the Word 2007 </span></li>
</ul>
<h3><b>Entry Requirement:</b></h3>
<ul>
<li><span>This course is available to all learners, of all academic backgrounds. </span></li>
<li><span>Learners should be aged 16 or over to undertake the qualification.</span></li>
<li><span>Good understanding of English language, numeracy and ICT are required to attend this course.</span></li>
</ul>
<h3><b>Assessment:  </b></h3>
<ul>
<li><span>At the end of the course, you will be required to sit an online multiple-choice test. Your test will be assessed automatically and immediately so that you will instantly know whether you have been successful.</span></li>
<li><span>Before sitting for your final exam you will have the opportunity to test your proficiency with a mock exam. </span></li>
</ul>
<h3><b>Certification: </b></h3>
<ul>
<li><span>After you have successfully passed the test, you will be able to obtain an Accredited Certificate of Achievement. You can however also obtain a Course Completion Certificate following the course completion without sitting for the test. Certificates can be obtained either in hard copy at a cost of £39 or in PDF format at a cost of £24. </span></li>
<li><span>PDF certificate's turnaround time is 24 hours and for the hardcopy certificate, it is 3-9 working days.</span></li>
</ul>
<h3><b>Why choose us?</b></h3>
<ul>
<li><span>Affordable, engaging &amp; high-quality e-learning study materials;</span></li>
<li><span>Tutorial videos/materials from the industry leading experts;</span></li>
<li><span>Study in a user-friendly, advanced online learning platform;</span></li>
<li><span>Efficient exam systems for the assessment and instant result; </span></li>
<li><span>The UK &amp; internationally recognized accredited qualification;</span></li>
<li><span>Access to course content on mobile, tablet or desktop from anywhere anytime;</span></li>
<li><span>The benefit of career advancement opportunities;</span></li>
<li><span>24/7 student support via email.</span></li>
</ul>
<h3><b>Career Path:</b></h3>
<p><span>The Microsoft Word 2007 for Beginners course is a useful qualification to possess and would be beneficial for professions or careers from industries which are:</span></p>
<ul>
<li><span>Administrative Assistant</span></li>
<li><span>PA</span></li>
<li><span>Secretary</span></li>
<li><span>Administrator</span></li>
<li><span>Office Manager</span></li>
</ul>
		</div><table width="100%">				<tbody><tr>
					<td colspan="4">Microsoft Word 2007 for Beginners</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Module One - Getting Started</td>
					<td> </td>
					<td><span><i></i> 00:30:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Module Two - Opening and Closing Word</td>
					<td> </td>
					<td><span><i></i> 01:00:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Module Three - Working with Documents</td>
					<td> </td>
					<td><span><i></i> 01:00:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Module Four - Your First Document</td>
					<td> </td>
					<td><span><i></i> 01:00:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Module Five - Basic Editing Tasks</td>
					<td> </td>
					<td><span><i></i> 01:00:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Module Six - Basic Formatting Tasks</td>
					<td> </td>
					<td><span><i></i> 01:00:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Module Seven - Advanced Formatting Tasks</td>
					<td> </td>
					<td><span><i></i> 01:00:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Module Eight - Formatting Paragraphs</td>
					<td> </td>
					<td><span><i></i> 01:00:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Module Nine - Working with Styles</td>
					<td> </td>
					<td><span><i></i> 01:00:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Module Ten - Formatting the Page</td>
					<td> </td>
					<td><span><i></i> 01:00:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Module Eleven - Adding the Finishing Touches</td>
					<td> </td>
					<td><span><i></i> 01:00:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Module Twelve - Wrapping Up</td>
					<td> </td>
					<td><span><i></i> 00:30:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Activities</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Activities-Microsoft Word 2007 for Beginners</td>
					<td> </td>
					<td><span><i></i> 00:00:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Mock Exam</td>
				</tr>
								<tr>
					<td colspan="4">Final Exam</td>
				</tr>
								<tr>
					<td colspan="4">Certificate and Transcript</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Order Your Certificates and Transcripts</td>
					<td> </td>
					<td><span><i></i> 00:00:00</span></td>
				</tr>
				</tbody></table>

Microsoft MS-700

Office Skills & Productivity

Office Skills

Microsoft Office

Microsoft Word

Microsoft Word 2007 for Beginners

<p><strong>***Don't Spend More; Spend Smart***</strong></p><p><strong>Life Just Got Better This Summer! Get Hard Copy + PDF Certificates + Transcript + Student ID Card + e-Learning App as a Gift - Enrol Now</strong></p><p>Tired of browsing and searching for the course you are looking for? Can't find the complete package that fulfils all your needs? Then don't worry as you have just found the solution. Take a minute and look through this 12-in-1 extensive bundle that has everything you need to succeed in <strong>Work from Home Essentials </strong>and other relevant fields!</p><p>After surveying thousands of learners just like you and considering their valuable feedback, this all-in<strong>-</strong>one <strong>Work from Home Essentials </strong>bundle has been designed by industry experts. We prioritised what learners were looking for in a complete package and developed this in-demand <strong>Work from Home Essentials </strong>course that will enhance your skills and prepare you for the competitive job market.</p><p>Also, our <strong>Work from Home Essentials </strong>experts are available for answering your queries and help you along your learning journey. Advanced audio-visual learning modules of these courses are broken down into little chunks so that you can learn at your own pace without being overwhelmed by too much material at once.</p><p>Furthermore, to help you showcase your expertise in <strong>Work from Home Essentials, </strong>we have prepared a special gift of 1 hardcopy certificate and 1 PDF certificate for the title course completely free of cost. These certificates will enhance your credibility and encourage possible employers to pick you over the rest.</p><p><strong>This Work from Home Essentials Bundle Consists of the following Premium courses:</strong></p><ul><li><strong>Course 01: </strong>Working from Home Essentials</li><li><strong>Course 02: </strong>Online Course - A Perfect Guide to Home Business</li><li><strong>Course 03: </strong>Online Meeting Management</li><li><strong>Course 04: </strong>Using Zoom Meeting Effectively</li><li><strong>Course 05: </strong>ZOOM: Master Video Conferencing in Just 40 minutes!</li><li><strong>Course 06: </strong>Business Writing</li><li><strong>Course 07: </strong>Level 2 Microsoft Office Essentials</li><li><strong>Course 08: </strong>Touch Typing Essentials<strong><br /></strong></li><li><strong>Course 09: </strong>Effective Communication Skills Diploma</li><li><strong>Course 10: </strong>Stress Management Training</li><li><strong>Course 11: </strong>Freelancing on UpWork</li><li><strong>Course 12: </strong>Time Management</li></ul><p><strong>Benefits you'll get choosing Apex Learning for this Work from Home Essentials:</strong></p><ul><li>Pay once and get lifetime access to 12 CPD courses</li><li>Free e-Learning App for engaging reading materials &amp; helpful assistance</li><li>Certificates, student ID for the title course included in a one-time fee</li><li>Free up your time - don't waste time and money travelling for classes</li><li>Accessible, informative modules designed by expert instructors</li><li>Learn at your ease - anytime, from anywhere</li><li>Study the course from your computer, tablet or mobile device</li><li>CPD accredited course - improve the chance of gaining professional skills</li></ul><p><strong>Curriculum:</strong></p><p><strong>Course 01: Working from Home Essentials</strong></p><ul><li>Module 1: Introduction to Work from Home</li><li>Module 2: Online Meeting Tools</li><li>Module 3: Project Management Tools</li><li>Module 4: Project Planning Tools</li><li>Module 5: Communication Tools</li></ul><p><strong>How will I get my Certificate?</strong></p><p>After successfully completing the course, you will be able to order your CPD Accredited Certificates (PDF + Hard Copy) as proof of your achievement.</p><ul><li><strong>PDF Certificate: Free (For The Title Course)</strong></li><li><strong>Hard Copy Certificate: Free (For The Title Course)</strong></li></ul><h2>
        
        <div>CPD</div>
    </h2>

                        <div id="cpd">
                            <div>
                                <div>
                                    <div>
                                        125 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>Anyone from any background can enrol in this <strong>Work from Home Essentials </strong>bundle<strong>. </strong>Persons with similar professions can also refresh or strengthen their skills by enrolling in this course. Students can take this course to gather professional knowledge besides their study or for the future.</p>
                        </div><h2>
        
        <div>Requirements</div>
    </h2>

                        <div id="requirements">
                            <p>Our <strong>Work from Home Essentials </strong>is fully compatible with PC's, Mac's, laptops, tablets and Smartphone devices. This course has been designed to be fully compatible with tablets and smartphones so that you can access your course on Wi-Fi, 3G or 4G.</p><p>There is no time limit for completing this course; it can be studied in your own time at your own pace.</p>
                        </div><h2>
        
        <div>Career path</div>
    </h2>

                        <div id="career_path">
                            <p>Having this various expertise will increase the value of your CV and open you up to multiple job sectors.</p>
                        </div><h2>
        
        <div>Certificates</div>
    </h2>

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

                        </div>

Work from Home Essentials Courses

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



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


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


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


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


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


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


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

Bayfield Training

Financial Modelling & Analysis

Financial Modelling

Professional Development

Property & Real Estate Photography

Continuous Professional Development (CPD)

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

Real Estate Analyst (Investment Cash Flow Modelling in Excel)

In-Person 

Virtual

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

Nexus Human

Excel Analytics

Access VBA

Visual Basic Analysis

Microsoft Power Automate

Excel - Automating Excel with Macros and Analysis Tools

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



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


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


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


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


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


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

Real Estate Finance

Investment Management

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

Real Estate Modelling Masterclass (Advanced Cash Flow Modelling)

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



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


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


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


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


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


Quizzes | Q&A


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


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

Property Investment

Risk Management

Investment

Financial Risk Management

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

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

<p>Tired of browsing and searching for a <strong>Microsoft Office Course </strong> course you are looking for? Can't find the complete package that fulfils all your needs? Then don't worry as you have just found the solution. Take a minute and look through this extensive bundle that has everything you need to succeed.</p><p>After surveying thousands of learners just like you and considering their valuable feedback, this all-in<strong>-</strong>one Microsoft Office Course bundle has been designed by industry experts. We prioritised what learners were looking for in a complete package and developed this in-demand Microsoft Office Coursecourse that will enhance your skills and prepare you for the competitive job market.</p><p>Also, ourexperts are available for answering your queries on Microsoft Office Courseand help you along your learning journey. Advanced audio-visual learning modules of these Microsoft Office Coursecourses are broken down into little chunks so that you can learn at your own pace without being overwhelmed by too much material at once.</p><p>Furthermore, to help you showcase your expertise in Microsoft Office Course, we have prepared a special gift of 1 hardcopy certificate and 1 PDF certificate for the title course completely free of cost. These certificates will enhance your credibility and encourage possible employers to pick you over the rest.</p><p><strong>This Microsoft Office Course Bundle Consists of the following Premium courses: </strong></p><ul><li> Course 01: Level 2 Microsoft Office Essentials</li><li> Course 02: 50 Tips to Upgrade your Excel Skill</li><li> Course 03: New Functions in Microsoft Excel 2021</li><li> Course 04: Microsoft Excel: Automated Dashboard Using Advanced Formula, VBA, Power Query</li><li> Course 05: Microsoft Excel: Excel Sheet Comparison with VBA</li><li> Course 06: Microsoft Excel: Master Power Query in 120 Minutes!</li><li> Course 07: Data Analysis in Microsoft Excel Complete Training</li><li> Course 08: PowerPoint Diploma</li><li> Course 09: The Complete Microsoft Outlook Masterclass</li><li> Course 10: Complete Microsoft Power BI 2021</li><li> Course 11: Outlook Tips and tricks</li><li> Course 12: Microsoft Teams</li><li> Course 13: Windows 10 Pro Complete Training</li><li> Course 14: Functional Skills IT</li></ul><p>The bundle incorporates basic to advanced level skills to shed some light on your way and boost your career. Hence, you can strengthen your Microsoft Office Courseexpertise and essential knowledge, which will assist you in reaching your goal.</p><p>Enrol now in Microsoft Office Course to advance your career, and use the premium study materials from Apex Learning.</p><h2>
        
        <div>CPD</div>
    </h2>

                        <div id="cpd">
                            <div>
                                <div>
                                    <div>
                                        150 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>Anyone from any background can enrol in this SEN Teaching Assistant Bundle.</p>
                        </div><h2>
        
        <div>Requirements</div>
    </h2>

                        <div id="requirements">
                            <p>Our Microsoft Office is fully compatible with PCs, Macs, laptops, tablets and Smartphone devices. This course has been designed to be fully compatible with tablets and smartphones, so you can access your course on Wi-Fi, 3G or 4G.</p><p>There is no time limit for completing this course; it can be studied in your own time at your own pace.</p>
                        </div><h2>
        
        <div>Career path</div>
    </h2>

                        <div id="career_path">
                            <p>Having this Microsoft Office expertise will increase the value of your CV and open you up to multiple job sectors.</p>
                        </div><h2>
        
        <div>Certificates</div>
    </h2>

                        <div id="optional_extras">
                                    <h4>Certificate of completion</h4>
        <p>
            Digital certificate -
            Included
        </p>
        <h4>Certificate of completion</h4>
        <p>
            Hard copy certificate -
            Included
        </p>
            <div> <p>P.S. The delivery charge inside the UK is £3.99, and the international students have to pay £9.99.</p> </div>

                        </div>

Overview:
Tired of browsing and searching for a Microsoft Office course you are looking for? Can't find the complete package that fulfils all your needs? Then don't worry as you have just found the solution. Take a minute and look through this extensive bundle that has everything you need to succeed.
After surveying thousands of learners just like you and considering their valuable feedback, this all-in-one Microsoft Office Course bundle has been designed by industry experts. We prioritised what learners were looking for in a complete package and developed this in-demand Microsoft Office Course that will enhance your skills and prepare you for the competitive job market.
Also, our experts are available to answer your queries on Microsoft Office Courses and help you along your learning journey. Advanced audio-visual learning modules of these Microsoft Office courses are broken down into little chunks so that you can learn at your own pace without being overwhelmed by too much material at once.
Furthermore, to help you showcase your expertise in the Microsoft Office Course, we have prepared a special gift of 1 hardcopy certificate and 1 PDF certificate for the title course completely free of cost. These certificates will enhance your credibility and encourage possible employers to pick you over the rest.
This Microsoft Office Course Bundle Consists of the following Premium courses: 
Course 01: MS Word Diploma
Course 02: Proofreading & Copyediting
Course 03: PowerPoint Diploma
Course 04: Microsoft Excel Level 3
Course 05: New Functions in Microsoft Excel 2021
Course 06: Microsoft Excel: Automated Dashboard Using Advanced Formula, VBA, Power Query
Course 07: Microsoft Excel: Excel Sheet Comparison with VBA
Course 08: Microsoft Excel: Master Power Query in 120 Minutes!
Course 09: Excel: Top 50 Microsoft Excel Formulas in 50 Minutes!
Course 10: Excel Pivot Tables
Course 11: Data Analysis in Microsoft Excel Complete Training
Course 12: Excel Must know Formulas and Functions
Course 13: Excel spreadsheet for Beginner
Course 14: Excel Data Analysis for Beginner
Course 15: Diploma in Excel Vlookup Xlookup Match and Index
Course 16: Excel Pivot Tables, Pivot Charts, Slicers, and Timelines
Course 17: PowerBI Formulas
Course 18: Outlook Tips and Tricks
Course 19: Excel PowerQuery and PowerPivot
Course 20: Complete Microsoft Power BI 2021



Key Features of the Microsoft Office Course:
FREE Microsoft Office CPD-accredited certificate
Get a free student ID card with Microsoft Office training (£10 applicable for international delivery)
Lifetime access to the Microsoft Office course materials
The Microsoft Office program comes with 24/7 tutor support
Get instant access to this Microsoft Office course
Learn Microsoft Office training from anywhere in the world
The Microsoft Office training is affordable and simple to understand
The Microsoft Office training is an entirely online
Enrol now in the Microsoft Office Course to advance your career, and use the premium study materials from Apex Learning.



Description
The Microsoft Office bundle incorporates basic to advanced level skills to shed some light on your way and boost your career. Hence, you can strengthen your Microsoft Office Course expertise and essential knowledge, which will assist you in reaching your goal.
Course 01: Microsoft Office Word Diploma
Module 01: Getting Started with Word
Module 02: Formatting Text and Paragraphs
Module 03: Working More Efficiently
Module 04: Managing Lists
Module 05: Adding Tables
Module 06: Inserting Graphic Objects
Module 07: Controlling Page Appearance
Module 08: Preparing to Publish a Document
=========>>>>> And 19 More Courses <<<<<=========
How will I get my Microsoft Office Certificate?
After successfully completing the Microsoft Office course, you will be able to order your CPD Accredited Certificates (PDF + Hard Copy) as proof of your achievement.
PDF Certificate: Free (Previously it was £9.99*20 = £199.7)
Hard Copy Certificate: Free (For The Title Course: Previously it was £14.99)
So, enrol now in this Microsoft Office Bundle to kickstart your career!



Who is this course for? 
Anyone from any background can enrol in this Microsoft Office Bundle.



Requirements 
Our Microsoft Office is fully compatible with PCs, Macs, laptops, tablets and Smartphone devices. This course has been designed to be fully compatible with tablets and smartphones, so you can access your course on Wi-Fi, 3G or 4G.



Career Path
Having this Microsoft Office expertise will increase the value of your CV and open you up to multiple job sectors.

Microsoft Certified Trainer (MCT)

Microsoft Office Collection for Microsoft Office Specialist (MOS)

This Offer is vaild for first 10 Learners Only!!

Limited Time Offer!

<p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Whether you&#39;re a novice or an experienced user wishing to advance your Microsoft Office Skills (Excel, Word, PowerPoint), IT Functional Skills with Admin, Secretarial &amp; PA, this course offers many things for you. This Microsoft Office Skills with Admin, Secretarial &amp; PA course is designed to provide individuals with a comprehensive introduction to the features and functionality.</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;">This Microsoft Office Skills (Excel, Word, PowerPoint) &amp; IT Skills with Admin, Secretarial &amp; PA Bundle Consists of the following Premium courses:</strong></p><ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;"><em fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"> Course 01: </strong>Microsoft Office Word Diploma</em></li><li fr-original-style="" style="box-sizing: border-box;"><em fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"> Course 02: </strong>Microsoft Office PowerPoint Diploma</em></li><li fr-original-style="" style="box-sizing: border-box;"><em fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"> Course 03:</strong> Microsoft Office Excel</em></li><li fr-original-style="" style="box-sizing: border-box;"><em fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"> Course 04: </strong>Microsoft Access</em></li><li fr-original-style="" style="box-sizing: border-box;"><em fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"> Course 05: </strong>Functional Skills IT</em></li><li fr-original-style="" style="box-sizing: border-box;"><em fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"> Course 06: </strong>Admin, Secretarial &amp; PA</em></li><li fr-original-style="" style="box-sizing: border-box;"><em fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"> Course 07: </strong>Legal Secretary and Office Skills Diploma</em></li><li fr-original-style="" style="box-sizing: border-box;"><em fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"> Course 08: </strong>Document Control</em></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;">3 Free Gift Courses with this Microsoft Office &amp; Admin, Secretarial &amp; PA Package:</strong></p><ol fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;"><em fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"> Course 01:</strong> Touch Typing</em></li><li fr-original-style="" style="box-sizing: border-box;"><em fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"> Course 02:</strong> Business Writing </em></li><li fr-original-style="" style="box-sizing: border-box;"><em fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"> Course 03: </strong>Leadership &amp; Management</em></li></ol><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Enrol with Microsoft Office with Admin, Secretarial &amp; PA Bundle Today!!</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">The curriculum of the Microsoft Office with Admin, Secretarial &amp; PA Bundle:</strong></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;">Course 01: Microsoft Office Word Diploma</strong></p><ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">Module 01: Getting Started with Word</li><li fr-original-style="" style="box-sizing: border-box;">Module 02: Formatting Text and Paragraphs</li><li fr-original-style="" style="box-sizing: border-box;">Module 03: Working More Efficiently</li><li fr-original-style="" style="box-sizing: border-box;">Module 04: Managing Lists</li><li fr-original-style="" style="box-sizing: border-box;">Module 05: Adding Tables</li><li fr-original-style="" style="box-sizing: border-box;">Module 06: Inserting Graphic Objects</li><li fr-original-style="" style="box-sizing: border-box;">Module 07: Controlling Page Appearance</li><li fr-original-style="" style="box-sizing: border-box;">Module08: Preparing to Publish a Document</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;">-------------- And 10 more courses --------------</strong></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;">How will I get my Microsoft Office with Admin, Secretarial &amp; PA Certificate?</strong></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">After successfully completing the Microsoft Office with Admin, Secretarial &amp; PA bundle, you will be able to order your CPD Accredited Certificates (PDF + Hard Copy) as proof of your achievement.</p><ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">PDF Certificate: Free (Previously, it was &pound;6*11 = &pound;66)</strong></li><li fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Hard Copy Certificate: Free (For The Title Course: Previously it was &pound;10)<br fr-original-style="" style="box-sizing: border-box;"></strong></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;">Please Note:</strong> The delivery charge inside the UK is &pound;6.99, and the international students must pay a &pound;9.99 shipping cost.</p><h2 fr-original-style="" style="box-sizing: border-box;">
        
        <div fr-original-style="" style="box-sizing: border-box;">CPD</div>
    </h2><div id="cpd" 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;">
                                        220 CPD hours/points
                                    </div>
                                        <div fr-original-style="" style="box-sizing: border-box;">
                                            Accredited by CPD Quality Standards
                                        </div>
                                </div>
                            </div>
                        </div><h2 fr-original-style="" style="box-sizing: border-box;">
        
        <div fr-original-style="" style="box-sizing: border-box;">Who is this course for?</div>
    </h2><div id="who_is_this_course_for" 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;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">This Microsoft Office with Admin, Secretarial &amp; PA course is suitable for the following:</strong></p><ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">Individuals who are new to Microsoft Office with Admin, Secretarial &amp; PA and want to learn the basics of the program</li><li fr-original-style="" style="box-sizing: border-box;">Professionals who want to improve their skills and knowledge of Microsoft Office</li><li fr-original-style="" style="box-sizing: border-box;">Admin, Secretarial &amp; PA and other office workers who use Microsoft Office in their day-to-day work</li><li fr-original-style="" style="box-sizing: border-box;">Professionals who are looking to improve their Microsoft Office skills for career advancement or to increase their employability</li><li fr-original-style="" style="box-sizing: border-box;">Students who want to improve their productivity and efficiency by learning to use Microsoft Office more effectively</li></ul>
                        </div><h2 fr-original-style="" style="box-sizing: border-box;">
        
        </h2><div id="requirements" fr-original-style="" style="box-sizing: border-box;">
                        </div><h2 fr-original-style="" style="box-sizing: border-box;">
        
        <div fr-original-style="" style="box-sizing: border-box;">Career path</div>
    </h2><div id="career_path" 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;">Having this Microsoft Office with Admin, Secretarial &amp; PA expertise will increase the value of your CV and open you up to multiple job sectors:</p><ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Administrative Assistant</strong>: &pound;20,000 - &pound;30,000</li><li fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Secretary</strong>: &pound;25,000 - &pound;35,000</li><li fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Personal Assistant</strong>: &pound;30,000 - &pound;40,000</li><li fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Legal Secretary</strong>: &pound;35,000 - &pound;45,000</li><li fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Office Manager</strong>: &pound;40,000 - &pound;50,000</li><li fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Document Controller</strong>: &pound;35,000 - &pound;45,000</li></ul>
                        </div><h2 fr-original-style="" style="box-sizing: border-box;">
        
        <div fr-original-style="" style="box-sizing: border-box;">Certificates</div>
    </h2><div id="optional_extras" fr-original-style="" style="box-sizing: border-box;">
                                    <h4 fr-original-style="" style="box-sizing: border-box;"><span style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Certificate of Completion (Hard Copy)</span></h4>
      <ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">Hard copy certificate -
Included
 &nbsp; &nbsp; &nbsp; 
 &nbsp; &nbsp; &nbsp; &nbsp;</li></ul><h4 fr-original-style="" style="box-sizing: border-box;"><span style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Certificate of Completion (PDF)</span></h4>
        <ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">
            Digital certificate -
            Included
        </li></ul>

                        </div>

Course Overview:
Whether you're a novice or an experienced user wishing to advance your Microsoft Office Skills (Excel, Word, PowerPoint), IT Functional Skills with Admin, Secretarial & PA, this Microsoft Office course offers many things for you. This Microsoft Office Skills with Admin, Secretarial & PA course is designed to provide individuals with a comprehensive introduction to the features and functionality.
This Microsoft Office Skills (Excel, Word, PowerPoint) & IT Skills with Admin, Secretarial & PA Bundle Consists of the following Premium courses:
Course 01: Microsoft Office Word Diploma
Course 02: Microsoft Office PowerPoint Diploma
Course 03: Microsoft Office Excel
Course 04: Microsoft Access
Course 05: Functional Skills IT
Course 06: Admin, Secretarial & PA
Course 07: Legal Secretary and Office Skills Diploma
Course 08: Document Control
Course 01: Touch Typing
Course 02: Business Writing
Course 03: Leadership & Management

Enrol with Microsoft Office with Admin, Secretarial & PA Bundle Today!!



Key Features of the Course:
FREE Microsoft Office CPD-accredited certificate
Get a free student ID card with Microsoft Office training (£10 applicable for international delivery)
Lifetime access to the Microsoft Office course materials
The Microsoft Office program comes with 24/7 tutor support
Get instant access to this Microsoft Office course
Learn Microsoft Office training from anywhere in the world
The Microsoft Office training is affordable and simple to understand
The Microsoft Office training is an entirely online



Description
The curriculum of the Microsoft Office with Admin, Secretarial & PA Bundle:
Course 01: Microsoft Office Word Diploma
Module 01: Getting Started with Word
Module 02: Formatting Text and Paragraphs
Module 03: Working More Efficiently
Module 04: Managing Lists
Module 05: Adding Tables
Module 06: Inserting Graphic Objects
Module 07: Controlling Page Appearance
Module 08: Preparing to Publish a Document
-------------- And 10 more courses --------------
How will I get my Microsoft Office with Admin, Secretarial & PA Certificate?
After successfully completing the Microsoft Office with Admin, Secretarial & PA bundle, you will be able to order your CPD Accredited Certificates (PDF + Hard Copy) as proof of your achievement.
PDF Certificate: Free (Previously, it was £9.99*11 = £109)
Hard Copy Certificate: Free (For The Title Course: Previously it was £14.99)
Please Note: The delivery charge inside the UK is £6.99, and the international students must pay a £9.99 shipping cost.
So, enrol right away in this Microsoft Office bundle!



Who is this course for? 
This Microsoft Office with Admin, Secretarial & PA course is suitable for the following:
Individuals who are new to Microsoft Office with Admin, Secretarial & PA and want to learn the basics of the program
Professionals who want to improve their skills and knowledge of Microsoft Office
Admin, Secretarial & PA and other office workers who use Microsoft Office in their day-to-day work
Professionals who are looking to improve their Microsoft Office skills for career advancement or to increase their employability
Students who want to improve their productivity and efficiency by learning to use Microsoft Office more effectively



Career Path 
Having this Microsoft Office with Admin, Secretarial & PA expertise will increase the value of your CV and open you up to multiple job sectors:
Administrative Assistant: £20,000 - £30,000
Secretary: £25,000 - £35,000
Personal Assistant: £30,000 - £40,000
Legal Secretary: £35,000 - £45,000
Office Manager: £40,000 - £50,000
Document Controller: £35,000 - £45,000



Certificates
Certificate of Completion (Hard Copy)
Hard copy certificate -
Included
Certificate of Completion (PDF)
Digital certificate - Included

Secretarial & PA

Office Administration

Microsoft Powerpoint

Microsoft

Whether you're a novice or an experienced user wishing to advance your Microsoft Office Skills (Excel, Word, PowerPoint), IT Functional Skills with Admin, Secretarial & PA, this course offers many things for you. 

Microsoft Office Skills (Microsoft Excel, Word, PowerPoint) with Admin, Secretarial & PA

Limited Time Offer

<p><strong>Boost Your Career with Apex Learning and Get Noticed By Recruiters in this Hiring Season! Get Hard Copy + PDF Certificates + Transcript + Student ID Card worth £160 as a Gift - Enrol Now</strong></p> <p>With a single payment, you will gain access to <strong>Level 2 Microsoft Office Essentials</strong> including an original hardcopy certificate, a transcript and a student ID card which will allow you to get discounts on things like music, food, travel and clothes etc.</p> <p><strong>Courses are included with this Level 2 Microsoft Office Essentials:</strong></p> <ul> <li><strong>Course 01: </strong>Level 2 Microsoft Office Essentials</li><li><strong>Course 02: </strong>Data Analysis in Excel Level 3 Course</li><li><strong>Course 03: </strong>Personal Assistant &amp; Skill Development Training</li><li><strong>Course 04: </strong>Legal Secretaries Advanced Diploma</li><li><strong>Course 05: </strong>Financial Modeling Using Excel</li><li><strong>Course 06: </strong>Data Protection and Data Security Level 2</li><li><strong>Course 07:</strong> Team Management</li><li><strong>Course 08: </strong>Microsoft Teams</li><li><strong>Course 09: </strong>Negotiation Essential Skills - Level 3</li><li><strong>Course 10: </strong>Minute Taking Essentials Level 2</li><li><strong>Course 11: </strong>Time Management - 2 CPD Points</li></ul> <p>Become a valuable and skilled member of any organisation's administration team by learning to master the most popular Microsoft Office tools.</p> <p>This course provides full and comprehensive tutorials for each one of Microsoft's essential products and will boost your capabilities with them all.</p> <p>The course provides up-to-date training for Excel, PowerPoint, and Word. You will be given expert tuition and interactive exercises in the online modules, enabling you to attain the abilities to boost your administrative career prospects for employers. On completion of the final assessment, you will be able to present, write, or calculate efficiently for any critical assignment.</p> <p>Take this course anywhere and at any time. Don't let your lifestyle limit your learning or your potential.</p> <p>This bundle will provide you with the <strong>CPD certificate </strong>that you'll need to succeed.</p> <p>Gain experience online and interact with experts. This can prove to be the perfect way to get noticed by a prospective employer and stand out from the crowd.</p> <p>This bundle has been rated and reviewed highly by our learners and professionals alike. We have a passion for teaching, and it shows.</p> <p>All of our courses have interactive online modules that allow studying to take place where and when you want it to.</p> <p>The only thing you need to take <strong>Level 2 Microsoft Office Essentials </strong> is Wi-Fi and a screen. You'll never be late for class again.</p> <p>Experienced tutors and mentors will be there for you whenever you need them, and solve all your queries through email and chat boxes.</p> <p><strong>Benefits you'll get choosing Apex Learning for this Level 2 Microsoft Office Essentials:</strong></p> <ul> <li>One payment, but lifetime access to 11 CPD courses</li><li>Certificates, student ID for the title course included in a one-time fee</li><li>Full tutor support available from Monday to Friday</li><li>Free up your time - don't waste time and money travelling for classes</li><li>Accessible, informative modules taught by expert instructors</li><li>Learn at your ease - anytime, from anywhere</li><li>Study the course from your computer, tablet or mobile device</li><li>CPD accredited course - improve the chance of gaining professional skills</li><li>Gain valuable knowledge without leaving your home</li></ul><p><strong>Course Curriculum</strong></p> <p><strong>Level 2 Microsoft Office Essentials</strong></p> <p><strong>**Excel 2016**</strong></p> <p><strong>Getting Started with Microsoft Office Excel 2016</strong></p> <ul> <li>Navigate the Excel User Interface</li><li>Use Excel Commands</li><li>Create and Save a Basic Workbook</li><li>Enter Cell Data</li><li>Use Excel Help</li></ul> <p><strong>Performing Calculations</strong></p> <ul> <li>Create Worksheet Formulas</li><li>Insert Functions</li><li>Reuse Formulas and Functions</li></ul> <p><strong>Modifying a Worksheet</strong></p> <ul> <li>Insert, Delete, and Adjust Cells, Columns, and Rows</li><li>Search for and Replace Data</li><li>Use Proofing and Research Tools</li></ul> <p><strong>Formatting a Worksheet</strong></p> <ul> <li>Apply Text Formats</li><li>Apply Number Format</li><li>Align Cell Contents</li><li>Apply Styles and Themes</li><li>Apply Basic Conditional Formatting</li><li>Create and Use Templates</li></ul> <p><strong>Printing Workbooks</strong></p> <ul> <li>Preview and Print a Workbook</li><li>Set Up the Page Layout</li><li>Configure Headers and Footers</li></ul> <p><strong>Managing Workbooks</strong></p> <ul> <li>Manage Worksheets</li><li>Manage Workbook and Worksheet Views</li><li>Manage Workbook Properties</li></ul> <p><strong>**Word 2016**</strong></p> <ul> <li>Getting Started with Word</li><li>Create and Save Word Documents</li><li>Manage Your Workspace</li><li>Edit Documents</li><li>Preview and Print Documents</li><li>Customize the Word Environment</li></ul> <p>And Much More...</p> <p><strong>Formatting Text and Paragraphs</strong></p> <ul> <li>Apply Character Formatting</li><li>Control Paragraph Layout</li><li>Align Text Using Tabs</li><li>Display Text in Bulleted or Numbered Lists</li><li>Apply Borders and Shading</li></ul> <p><strong>Working More Efficiently</strong></p> <ul> <li>Make Repetitive Edits</li><li>Apply Repetitive Formatting</li><li>Use Styles to Streamline Repetitive Formatting Tasks</li></ul> <p><strong>Managing Lists</strong></p> <ul> <li>Sort a List</li><li>Format a List</li></ul> <p><strong>Adding Tables</strong></p> <ul> <li>Insert a Table</li><li>Modify a Table</li><li>Format a Table</li><li>Convert Text to a Table</li></ul> <p><strong>Inserting Graphic Objects</strong></p> <ul> <li>Insert Symbols and Special Characters</li><li>Add Images to a Document</li></ul> <p><strong>Controlling Page Appearance</strong></p> <ul> <li>Apply a Page Border and Color</li><li>Add Headers and Footers</li><li>Control Page Layout</li><li>Add a Watermark</li></ul> <p><strong>Preparing to Publish a Document</strong></p> <ul> <li>Check Spelling Grammar and Readability</li><li>Use Research Tools</li><li>Check Accessibility</li><li>Save a Document to Other Formats</li></ul> <p><strong>Workbooks - Microsoft Word 2016 (Beginner)</strong></p> <ul> <li>Workbooks - Microsoft Word 2016 (Beginner)</li></ul> <p><strong>**PowerPoint 2016**</strong></p> <p><strong>PowerPoint Interface</strong></p> <ul> <li>Navigate the PowerPoint Environment</li><li>View and Navigate a Presentation</li><li>Create and Save a PowerPoint Presentation</li><li>Use PowerPoint Help</li></ul> <p><strong>Presentation Basics</strong></p> <ul> <li>Select a Presentation Type</li><li>Edit Text</li><li>Build a Presentation</li></ul> <p><strong>Formatting</strong></p> <ul> <li>Format Characters</li><li>Format Paragraphs</li><li>Format Text Boxes</li></ul> <p><strong>Inserting Options</strong></p> <ul> <li>Insert Images</li><li>Insert Shapes</li></ul> <p><strong>Working with Objects</strong></p> <ul> <li>Edit Objects</li><li>Format Objects</li><li>Group Objects</li><li>Arrange Objects</li><li>Animate Objects</li></ul> <p><strong>Table</strong></p> <ul> <li>Create a Table</li><li>Create a Table</li></ul> <p>And Much More...</p> <p><strong>Charts</strong></p> <ul> <li>Create a Chart</li><li>Format a Chart</li></ul> <p>And Much More...</p> <p><strong>Review and Presentatin</strong></p> <ul> <li>Review Your Presentation</li><li>Apply Transitions</li><li>Print Your Presentation</li><li>Deliver Your Presentation</li></ul> <p><strong>**Access 2016**</strong></p> <p><strong>Introduction to Access</strong></p> <ul> <li>Create a Simple Access Database</li></ul> <p>And Much More...</p> <p><strong>Modify Data</strong></p> <ul> <li>Modify Table Data</li><li>Sort and Filter Records</li></ul> <p><strong>Working with Queries</strong></p> <ul> <li>Create Basic Queries</li><li>Sort and Filter Data in a Query</li><li>Perform Calculations in a Query</li></ul> <p><strong>Access Forms</strong></p> <ul> <li>Create Basic Access Forms</li><li>Work with Data on Access Forms</li></ul> <p><strong>Working with Reports</strong></p> <ul> <li>Create a Report</li><li>Add Controls to a Report</li><li>Enhance the Appearance of a Report</li><li>Prepare a Report for Print</li><li>Organize Report Information</li><li>Format Reports</li></ul> <p><strong>How will I get my Certificate?</strong></p> <p>After successfully completing the course you will be able to order your CPD Accredited Certificates (PDF + Hard Copy) as proof of your achievement.</p> <ul> <li><strong>PDF Certificate: Free (Previously it was £10 * 11 = £110)</strong></li><li><strong>Hard Copy Certificate: Free (For The Title Course)</strong></li></ul> <p><strong>P.S. The delivery charge inside the U.K. is £3.99 and the international students have to pay £9.99. </strong></p><h2>
        
        <div>CPD</div>
    </h2>

                        <div id="cpd">
                            <div>
                                <div>
                                    <div>
                                        125 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>There is no experience or previous qualifications required for enrolment on this bundle. It is available to all students, of all academic backgrounds.</p> 
                        </div><h2>
        
        <div>Requirements</div>
    </h2>

                        <div id="requirements">
                             <p>Our bundle 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.</p> <p>There is no time limit for completing this course, it can be studied in your own time at your own pace.</p> 
                        </div><h2>
        
        <div>Career path</div>
    </h2>

                        <div id="career_path">
                             <p>Having these various CPD certificate 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.</p> 
                        </div><h2>
        
        <div>Certificates</div>
    </h2>

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

                        </div>

Overview
Boost Your Career with Apex Learning and Get Noticed By Recruiters in this Hiring Season! Get Hard Copy + PDF Certificates + Transcript + Student ID Card worth £180 as a Gift - Enrol Now!
Become a valuable and skilled member of any organisation's administration team by learning to master the most popular Microsoft Office tools.
This Microsoft Office course provides full and comprehensive tutorials for each one of Microsoft Office's essential products and will boost your capabilities with them all.
The Microsoft Office course provides up-to-date training in Excel, PowerPoint, and Word. You will be given expert tuition and engaging exercises in the online modules, enabling you to attain the abilities to boost your administrative career prospects for employers. On completion of the final assessment of Microsoft Office course, you will be able to present, write, or calculate efficiently for any critical assignment.
With a single payment, you will gain access to the Microsoft Office course including an original hardcopy certificate, a transcript and a student ID card.
Courses are included with this Microsoft Office Essentials:
Course 01: Level 2 Microsoft Office Essentials
Course 02: Data Analysis in Excel Level 3 Course
Course 03: Personal Assistant & Skill Development Training
Course 04: Legal Secretaries Advanced Diploma
Course 05: Financial Modeling Using Excel
Course 06: Data Protection and Data Security Level 2
Course 07: Team Management
Course 08: Microsoft Teams
Course 09: IT Support Technician
Course 10: Minute Taking Essentials Level 2
Course 11: Time Management



Key Features of the Microsoft Office Course:
FREE Microsoft Office CPD-accredited certificate
Get a free student ID card with Microsoft Office training (£10 applicable for international delivery)
Lifetime access to the Microsoft Office course materials
The Microsoft Office program comes with 24/7 tutor support
Get instant access to this Microsoft Office course
Learn Microsoft Office training from anywhere in the world
The Microsoft Office training is affordable and simple to understand
The Microsoft Office training is an entirely online



Description
★★★ Course Curriculum of the Microsoft Office Bundle ★★★
Level 2 Microsoft Office Essentials
**Excel 2016**
Getting Started with Microsoft Office Excel 2016
Navigate the Excel User Interface
Use Excel Commands
Create and Save a Basic Workbook
Enter Cell Data
Use Excel Help
Performing Calculations
Create Worksheet Formulas
Insert Functions
Reuse Formulas and Functions
Modifying a Worksheet
Insert, Delete, and Adjust Cells, Columns, and Rows
Search for and Replace Data
Use Proofing and Research Tools
and much more…
=========>>>>> And 10 More Courses <<<<<=========
How will I get my Microsoft Office Certificate?
After successfully completing the Microsoft Office course you will be able to order your CPD Accredited Certificates (PDF + Hard Copy) as proof of your achievement.
PDF Certificate: Free (Previously it was £9.99 * 11 = £109)
Hard Copy Certificate: Free (For The Title Course: Previously it was £14.99)
P.S. The delivery charge inside the U.K. is £3.99 and the international students have to pay £9.99.
So, enrol in this Microsoft Office bundle and start working towards a successful career!



Who is this course for? 
There is no experience or previous qualifications required for enrolment on this Microsoft Office bundle. It is available to all students, of all academic backgrounds.



Requirements 
Our Microsoft Office bundle is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This Microsoft Office 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 Microsoft Office course, it can be studied in your own time at your own pace.



Career path 
Having this Microsoft Office certificate will increase the value in your CV and open you up to multiple sectors such as Business & Management, Admin, Accountancy & Finance, Secretarial & PA, Teaching & Mentoring etc.

Professional Skills

Microsoft Office Skills (Microsoft Excel, Word, PowerPoint), Administration & IT Training

<h2><strong>Course Overview:</strong></h2>
<p> 
<strong>Discover the power of Microsoft Office Essentials with our Level 2 Microsoft Office Essentials Course.</strong> In today's digital age, proficiency in Microsoft Office is no longer a mere advantage; it has become an essential skill for success in nearly every industry. <strong>According to recent surveys, over 80% of job listings require proficiency in Microsoft Office, with Excel, Word, PowerPoint, and Access being the most sought-after applications.</strong> As the workplace evolves, the demand for individuals with advanced knowledge of these tools rapidly increases. 
</p> 
<p> 
<strong>Our comprehensive Level 2 Counselling Course allows you to navigate the complexities of Microsoft Office with ease and confidence. Designed to cater to beginners and intermediate users, this course offers a step-by-step approach to mastering Excel, Word, PowerPoint, and Access.</strong> You will delve into various topics, including creating and saving workbooks, formatting text and data, managing worksheets, creating impactful presentations, and building robust databases.
</p> 
<p> 
Enrol today in our Level 2 Microsoft Office Essentials course and unlock a world of opportunities, increased productivity, and career growth!
 </p> 
<hr />

<h2><strong>Key Features of the Course:</strong></h2>
<ul>
 	<li>CPD certificate upon successful completion</li>
 	<li>24/7 Learning Assistance for continuous support and guidance</li>
</ul>

<hr />

<h2><strong>Who is This Course For?</strong></h2>
<p> 
This course is ideal for individuals at various stages of their careers, including professionals seeking to enhance their Microsoft Office skills, students aiming to improve their employability, and anyone who wants to boost their productivity and efficiency in the workplace.
</p> 
<hr />

<h2><strong>What You Will Learn:</strong></h2>
<p> 
Throughout this Level 2 Microsoft Office Essentials course, you will <strong>develop a solid foundation in Microsoft Office essentials. Starting with Excel, you will learn to navigate the user interface, create and format spreadsheets, apply formulas and functions, and customise the appearance of your data. In Word, you will master document creation, formatting, and editing, as well as utilising advanced features like tables, symbols, and images. PowerPoint will enable you to create captivating presentations, while Access will equip you with the skills to build and manage databases effectively.</strong>
</p> 

<hr />

<h2><strong>Why Enrol in This Course:</strong></h2>
<p> 
The course has good reviewed content and a recently updated curriculum that ensures you gain the most relevant knowledge aligned with industry trends. Develop in-demand skills employers seek, boosting your career advancement and employability. Experience time-efficient learning with our structured approach, allowing you to achieve proficiency in Microsoft Office essentials quickly.
 </p> 
<hr />

<h2><strong>Requirements:</strong></h2>
<p> 
No prior experience or expertise is necessary to enrol in this course. Basic computer literacy and access to Microsoft Office applications will be beneficial.
 </p> 
<hr />

<h2><strong>Career Path:</strong></h2>
<p> 
Upon completion of this course, you can pursue various professions, including:
 </p> 
<ul>
 	<li>Administrative Assistant (£20,000 - £25,000 per annum)</li>
 	<li>Data Entry Operator (£18,000 - £22,000 per annum)</li>
 	<li>Office Manager (£25,000 - £35,000 per annum)</li>
 	<li>Project Coordinator (£25,000 - £35,000 per annum)</li>
 	<li>Database Administrator (£30,000 - £45,000 per annum)</li>
 	<li>Executive Assistant (£25,000 - £40,000 per annum)</li>
 	<li>Business Analyst (£35,000 - £50,000 per annum)</li>
</ul>

<hr />

<h2><strong>Certification:</strong></h2>
<p> 
Upon completing the course, you <strong>will receive a CPD certificate,</strong> demonstrating your proficiency in Microsoft Office essentials and enhancing your professional credibility.
 </p> 
<hr /> <h3>Course Curriculum</h3><div><p>32 sections • 96 lectures • 16:31:00 total length</p></div><div><div><div><div><div></div></div></div></div><div><div><div><div><div><div><p>•Navigate the Excel User Interfact: 00:28:00</p></div><div><div><p>•Use Excel Commands: 00:10:00</p></div><div><div><p>•Create and Save a Basic Workbook: 00:19:00</p></div><div><div><p>•Enter Cell Data: 00:12:00</p></div><div><div><p>•Use Excel Help: 00:05:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Create Worksheet Formulas: 00:15:00</p></div><div><div><p>•Insert Functions: 00:17:00</p></div><div><div><p>•Reuse Formulas and Functions: 00:17:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Insert, Delete, and Adjust Cells, Columns, and Rows: 00:10:00</p></div><div><div><p>•Search for and Replace Data: 00:09:00</p></div><div><div><p>•Use Proofing and Research Tools: 00:07:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Apply Text Formats: 00:16:00</p></div><div><div><p>•Apply Number Format: 00:08:00</p></div><div><div><p>•Align Cell Contents: 00:09:00</p></div><div><div><p>•Apply Styles and Themes: 00:12:00</p></div><div><div><p>•Apply Basic Conditional Formatting: 00:11:00</p></div><div><div><p>•Create and Use Templates: 00:08:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Preview and Print a Workbook: 00:11:00</p></div><div><div><p>•Set Up the Page Layout: 00:09:00</p></div><div><div><p>•Configure Headers and Footers: 00:07:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Manage Worksheets: 00:05:00</p></div><div><div><p>•Manage Workbook and Worksheet Views: 00:07:00</p></div><div><div><p>•Manage Workbook Properties: 00:06:00</p></div></div></div></div></div><div><div><div><div></div></div></div></div><div><div><div><div><div><div><p>•Navigate in Microsoft Word: 00:12:00</p></div><div><div><p>•Create and Save Word Documents: 00:24:00</p></div><div><div><p>•Manage Your Workspace: 00:06:00</p></div><div><div><p>•Edit Documents: 00:16:00</p></div><div><div><p>•Preview and Print Documents: 00:04:00</p></div><div><div><p>•Customize the Word Environment: 00:08:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Apply Character Formatting: 00:17:00</p></div><div><div><p>•Control Paragraph Layout: 00:19:00</p></div><div><div><p>•Align Text Using Tabs: 00:07:00</p></div><div><div><p>•Display Text in Bulleted or Numbered Lists: 00:03:00</p></div><div><div><p>•Apply Borders and Shading: 00:05:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Make Repetitive Edits: 00:06:00</p></div><div><div><p>•Apply Repetitive Formatting: 00:10:00</p></div><div><div><p>•Use Styles to Streamline Repetitive Formatting Tasks: 00:14:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Sort a List: 00:05:00</p></div><div><div><p>•Format a List: 00:06:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Insert a Table: 00:07:00</p></div><div><div><p>•Modify a Table: 00:06:00</p></div><div><div><p>•Format a Table: 00:03:00</p></div><div><div><p>•Convert Text to a Table: 00:04:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Insert Symbols and Special Characters: 00:04:00</p></div><div><div><p>•Add Images to a Document: 00:11:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Apply a Page Border and Color: 00:03:00</p></div><div><div><p>•Add Headers and Footers: 00:06:00</p></div><div><div><p>•Control Page Layout: 00:05:00</p></div><div><div><p>•Add a Watermark: 00:04:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Check Spelling Grammar and Readability: 00:07:00</p></div><div><div><p>•Use Research Tools: 00:06:00</p></div><div><div><p>•Check Accessibility: 00:03:00</p></div><div><div><p>•Save a Document to Other Formats: 00:04:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Workbooks - Microsoft Word 2016 (Beginner): 00:00:00</p></div></div></div></div></div><div><div><div><div></div></div></div></div><div><div><div><div><div><div><p>•Navigate the PowerPoint Environment: 00:28:00</p></div><div><div><p>•View and Navigate a Presentation: 00:15:00</p></div><div><div><p>•Create and Save a PowerPoint Presentation: 00:13:00</p></div><div><div><p>•Use PowerPoint Help: 00:10:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Select a Presentation Type: 00:08:00</p></div><div><div><p>•Edit Text: 00:13:00</p></div><div><div><p>•Build a Presentation: 00:27:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Format Characters: 00:11:00</p></div><div><div><p>•Format Paragraphs: 00:16:00</p></div><div><div><p>•Format Text Boxes: 00:09:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Insert Images: 00:10:00</p></div><div><div><p>•Insert Shapes: 00:15:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Edit Objects: 00:16:00</p></div><div><div><p>•Format Objects: 00:06:00</p></div><div><div><p>•Group Objects: 00:04:00</p></div><div><div><p>•Arrange Objects: 00:07:00</p></div><div><div><p>•Animate Objects: 00:07:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Create a Table: 00:09:00</p></div><div><div><p>•Insert a Table from Other Microsoft Office Applications: 00:06:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Create a Chart: 00:10:00</p></div><div><div><p>•Format a Chart: 00:10:00</p></div><div><div><p>•Insert a Chart from Microsoft Excel: 00:05:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Review Your Presentation: 00:11:00</p></div><div><div><p>•Apply Transitions: 00:05:00</p></div><div><div><p>•Print Your Presentation: 00:05:00</p></div><div><div><p>•Deliver Your Presentation: 00:08:00</p></div></div></div></div></div><div><div><div><div></div></div></div></div><div><div><div><div><div><div><p>•Orientation to Microsoft Access1: 00:39:00</p></div><div><div><p>•Create a Simple Access Database: 00:10:00</p></div><div><div><p>•Get Help and Configure Options in Microsoft Access: 00:06:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Modify Table Data: 00:17:00</p></div><div><div><p>•Sort and Filter Records: 00:05:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Create Basic Queries: 00:15:00</p></div><div><div><p>•Sort and Filter Data in a Query: 00:14:00</p></div><div><div><p>•Perform Calculations in a Query: 00:08:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Create Basic Access Forms: 00:07:00</p></div><div><div><p>•Work with Data on Access Forms: 00:23:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Create a Report: 00:23:00</p></div><div><div><p>•Add Controls to a Report: 00:12:00</p></div><div><div><p>•Enhance the Appearance of a Report: 00:05:00</p></div><div><div><p>•Prepare a Report for Print: 00:03:00</p></div><div><div><p>•Organize Report Information: 00:15:00</p></div><div><div><p>•Format Reports: 00:12: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></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div>

Course Overview:
Discover the power of Microsoft Office with our Level 2 Microsoft Office Essentials Course. In today's digital age, proficiency in Microsoft Office is no longer a mere advantage; it has become an essential skill for success in nearly every industry. According to recent surveys, over 80% of job listings require proficiency in Microsoft Office, with Excel, Word, PowerPoint, and Access being the most sought-after applications. As the workplace evolves, the demand for individuals with advanced knowledge of Microsoft Office tools rapidly increases. 
Our comprehensive Level 2 Microsoft Office Course allows you to navigate the complexities of Microsoft Office with ease and confidence. Designed to cater to beginners and intermediate users, this course offers a step-by-step approach to mastering Excel, Word, PowerPoint, and Access. You will get into various topics, including creating and saving workbooks, formatting text and data, managing worksheets, creating impactful presentations, and building robust databases all with the help of Microsoft Office.
Enrol today in our Level 2 Microsoft Office Essentials course and unlock a world of opportunities, increased productivity, and career growth! 



Key Features of the Course:
FREE Microsoft Office CPD-accredited certificate
Get a free student ID card with Microsoft Office training (£10 applicable for international delivery)
Lifetime access to the Microsoft Office course materials
The Microsoft Office program comes with 24/7 tutor support
Get instant access to this Microsoft Office course
Learn Microsoft Office training from anywhere in the world
The Microsoft Office training is affordable and simple to understand
The Microsoft Office training is an entirely online



Who is This Course For?
This Microsoft Office course is ideal for individuals at various stages of their careers, including professionals seeking to enhance their Microsoft Office skills, students aiming to improve their employability, and anyone who wants to boost their productivity and efficiency in the workplace.




What You Will Learn:
Throughout this Level 2 Microsoft Office Essentials course, you will develop a solid foundation in Microsoft Office Essentials. Starting with Excel, you will learn to navigate the user interface, create and format spreadsheets, apply formulas and functions, and customise the appearance of your data. In Word, you will master document creation, formatting, and editing, as well as utilising advanced features like tables, symbols, and images. PowerPoint will enable you to create captivating presentations, while Access will equip you with the skills to build and manage databases effectively.




Why Enrol in This Course:
The Microsoft Office course has well-reviewed content and a recently updated curriculum that ensures you gain the most relevant knowledge aligned with industry trends. Acquire essential knowledge and get a chance to develop in-demand skills employers seek, boosting your career advancement and employability.



Requirements:
No prior experience or expertise is necessary to enrol in this Microsoft Office course. Basic computer literacy and access to Microsoft Office applications will be beneficial. 



Career Path:
 Upon completion of this course, you can pursue various professions, including: 
Administrative Assistant (£20,000 - £25,000 per annum)
Microsoft Office Specialist [MOS] (£18,000 - £22,000 per annum)
Office Manager (£25,000 - £35,000 per annum)
Project Coordinator (£25,000 - £35,000 per annum)
Data Entry Operator (£20,000 - £28,000 per annum)
Executive Assistant (£25,000 - £40,000 per annum)
Business Analyst (£35,000 - £50,000 per annum)



Certification:
Upon completing the course, you will receive a CPD certificate, demonstrating your proficiency in Microsoft Office essentials and enhancing your professional credibility. 



Course Curriculum
32 sections • 96 lectures • 16:31:00 total length
•Navigate the Excel User Interface: 00:28:00
•Use Excel Commands: 00:10:00
•Create and Save a Basic Workbook: 00:19:00
•Enter Cell Data: 00:12:00
•Use Excel Help: 00:05:00
•Create Worksheet Formulas: 00:15:00
•Insert Functions: 00:17:00
•Reuse Formulas and Functions: 00:17:00
•Insert, Delete, and Adjust Cells, Columns, and Rows: 00:10:00
•Search for and Replace Data: 00:09:00
•Use Proofing and Research Tools: 00:07:00
•Apply Text Formats: 00:16:00
•Apply Number Format: 00:08:00
•Align Cell Contents: 00:09:00
•Apply Styles and Themes: 00:12:00
•Apply Basic Conditional Formatting: 00:11:00
•Create and Use Templates: 00:08:00
•Preview and Print a Workbook: 00:11:00
•Set Up the Page Layout: 00:09:00
•Configure Headers and Footers: 00:07:00
•Manage Worksheets: 00:05:00
•Manage Workbook and Worksheet Views: 00:07:00
•Manage Workbook Properties: 00:06:00
•Navigate in Microsoft Word: 00:12:00
•Create and Save Word Documents: 00:24:00
•Manage Your Workspace: 00:06:00
•Edit Documents: 00:16:00
•Preview and Print Documents: 00:04:00
•Customize the Word Environment: 00:08:00
•Apply Character Formatting: 00:17:00
•Control Paragraph Layout: 00:19:00
•Align Text Using Tabs: 00:07:00
•Display Text in Bulleted or Numbered Lists: 00:03:00
•Apply Borders and Shading: 00:05:00
•Make Repetitive Edits: 00:06:00
•Apply Repetitive Formatting: 00:10:00
•Use Styles to Streamline Repetitive Formatting Tasks: 00:14:00
•Sort a List: 00:05:00
•Format a List: 00:06:00
•Insert a Table: 00:07:00
•Modify a Table: 00:06:00
•Format a Table: 00:03:00
•Convert Text to a Table: 00:04:00
•Insert Symbols and Special Characters: 00:04:00
•Add Images to a Document: 00:11:00
•Apply a Page Border and Color: 00:03:00
•Add Headers and Footers: 00:06:00
•Control Page Layout: 00:05:00
•Add a Watermark: 00:04:00
•Check Spelling Grammar and Readability: 00:07:00
•Use Research Tools: 00:06:00
•Check Accessibility: 00:03:00
•Save a Document to Other Formats: 00:04:00
•Workbooks - Microsoft Word 2016 (Beginner): 00:00:00
•Navigate the PowerPoint Environment: 00:28:00
•View and Navigate a Presentation: 00:15:00
•Create and Save a PowerPoint Presentation: 00:13:00
•Use PowerPoint Help: 00:10:00
•Select a Presentation Type: 00:08:00
•Edit Text: 00:13:00
•Build a Presentation: 00:27:00
•Format Characters: 00:11:00
•Format Paragraphs: 00:16:00
•Format Text Boxes: 00:09:00
•Insert Images: 00:10:00
•Insert Shapes: 00:15:00
•Edit Objects: 00:16:00
•Format Objects: 00:06:00
•Group Objects: 00:04:00
•Arrange Objects: 00:07:00
•Animate Objects: 00:07:00
•Create a Table: 00:09:00
•Insert a Table from Other Microsoft Office Applications: 00:06:00
•Create a Chart: 00:10:00
•Format a Chart: 00:10:00
•Insert a Chart from Microsoft Excel: 00:05:00
•Review Your Presentation: 00:11:00
•Apply Transitions: 00:05:00
•Print Your Presentation: 00:05:00
•Deliver Your Presentation: 00:08:00
•Orientation to Microsoft Access1: 00:39:00
•Create a Simple Access Database: 00:10:00
•Get Help and Configure Options in Microsoft Access: 00:06:00
•Modify Table Data: 00:17:00
•Sort and Filter Records: 00:05:00
•Create Basic Queries: 00:15:00
•Sort and Filter Data in a Query: 00:14:00
•Perform Calculations in a Query: 00:08:00
•Create Basic Access Forms: 00:07:00
•Work with Data on Access Forms: 00:23:00
•Create a Report: 00:23:00
•Add Controls to a Report: 00:12:00
•Enhance the Appearance of a Report: 00:05:00
•Prepare a Report for Print: 00:03:00
•Organize Report Information: 00:15:00
•Format Reports: 00:12:00

Microsoft 365

Level 2 Microsoft Office Essentials

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

Microsoft Sharepoint

SharePoint

55238 SharePoint Online for Administrators

<p id="isPasted" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Our <strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Mastering Microsoft Office: Word, Excel, PowerPoint, and 365</strong> course provides an in-depth exploration of Excel 2021, starting with the basics of creating spreadsheets, entering data, and understanding relative references. Progress to more advanced topics like data handling, page setup, sorting, filtering, and writing sophisticated formulas, including VLOOKUP, HLOOKUP, and the 2021 exclusive XLOOKUP. Learn to create compelling charts and pivot tables that bring your data to life.</p><p style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;" id="isPasted" fr-original-style=" color: var(--text);">In PowerPoint 2021, start with presentation basics and advance to incorporating graphic assets, multimedia, and SmartArt graphics. Master text formatting, bullet options, and table and chart integration to create professional and engaging presentations. Explore the full suite of PowerPoint features, including transitions, animations, and slideshow effects, to captivate your audience.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">The Word 2021 modules guide you through document creation, formatting, and layout management. Learn to work with tables, styles, and mail merges. Additionally, discover the collaboration and productivity features of Office 365, which enable seamless sharing and editing across platforms.</p><p id="isPasted" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Learning Outcomes of Mastering Microsoft Office: Word, Excel, PowerPoint, and 365 Course:</strong></p><ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">Master the fundamentals of Excel 2021, including entering data and working with ranges.</li><li fr-original-style="" style="box-sizing: border-box;">Create and modify Excel charts and pivot tables for data analysis.</li><li fr-original-style="" style="box-sizing: border-box;">Develop PowerPoint presentations with advanced animations and multimedia elements.</li><li fr-original-style="" style="box-sizing: border-box;">Format documents in Word 2021, including creating tables and managing styles.</li><li fr-original-style="" style="box-sizing: border-box;">Execute mail merges and manage page layouts effectively in Word 2021.</li><li fr-original-style="" style="box-sizing: border-box;">Utilise Office 365 features for enhanced productivity and collaboration.</li><li fr-original-style="" style="box-sizing: border-box;">Understand and apply advanced Excel formulas like VLOOKUP, HLOOKUP, and XLOOKUP.</li></ul><p id="isPasted" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">The Course Curriculum of&nbsp;Mastering Microsoft Office: Word, Excel, PowerPoint, and 365:</strong></p><ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">Section 01: Getting Started</li><li fr-original-style="" style="box-sizing: border-box;">Section 02: Excel 2021: Basics</li><li fr-original-style="" style="box-sizing: border-box;">Section 03: Excel 2021: Rows, Columns, And Cells</li><li fr-original-style="" style="box-sizing: border-box;">Section 04: Excel 2021: Data Handling</li><li fr-original-style="" style="box-sizing: border-box;">Section 05: Excel 2021: Page Setting Up And Print</li><li fr-original-style="" style="box-sizing: border-box;">Section 06: Excel 2021: Sorting And Filtering</li><li fr-original-style="" style="box-sizing: border-box;">Section 07: Excel 2021: Writing Formulas</li><li fr-original-style="" style="box-sizing: border-box;">Section 08: Excel 2021: Advanced Formulas</li><li fr-original-style="" style="box-sizing: border-box;">Section 09: Excel 2021: XLOOKUP Only For 2021 And Office 365</li><li fr-original-style="" style="box-sizing: border-box;">Section 10: Excel 2021: Data And Tools</li><li fr-original-style="" style="box-sizing: border-box;">Section 11: Excel 2021: Formatting Data And Tables</li><li fr-original-style="" style="box-sizing: border-box;">Section 12: Excel 2021: Pivot Tables</li><li fr-original-style="" style="box-sizing: border-box;">Section 13: Excel 2021: Charts</li><li fr-original-style="" style="box-sizing: border-box;">Section 14: PowerPoint 2021: Course Introduction</li><li fr-original-style="" style="box-sizing: border-box;">Section 15: PowerPoint 2021: Basics</li><li fr-original-style="" style="box-sizing: border-box;">Section 16: PowerPoint 2021: Text And Bullet Options</li><li fr-original-style="" style="box-sizing: border-box;">Section 17: PowerPoint 2021: Adding Graphic Assets</li><li fr-original-style="" style="box-sizing: border-box;">Section 18: PowerPoint 2021: Picture Formatting</li><li fr-original-style="" style="box-sizing: border-box;">Section 19: PowerPoint 2021: SmartArt Graphics</li><li fr-original-style="" style="box-sizing: border-box;">Section 20: PowerPoint 2021: Working With Tables</li><li fr-original-style="" style="box-sizing: border-box;">Section 21: PowerPoint 2021: Working With Charts</li><li fr-original-style="" style="box-sizing: border-box;">Section 22: PowerPoint 2021: Adding Multimedia</li><li fr-original-style="" style="box-sizing: border-box;">Section 23: PowerPoint 2021: Working With Transition</li><li fr-original-style="" style="box-sizing: border-box;">Section 24: PowerPoint 2021: Animation</li><li fr-original-style="" style="box-sizing: border-box;">Section 25: PowerPoint 2021: Slideshow Effects</li><li fr-original-style="" style="box-sizing: border-box;">Section 26: Word 2021: Introduction</li><li fr-original-style="" style="box-sizing: border-box;">Section 27: Word 2021: Basics</li><li fr-original-style="" style="box-sizing: border-box;">Section 28: Word 2021: Word Formatting</li><li fr-original-style="" style="box-sizing: border-box;">Section 29: Word 2021: Tables</li><li fr-original-style="" style="box-sizing: border-box;">Section 30: Word 2021: Styles</li><li fr-original-style="" style="box-sizing: border-box;">Section 31: Word 2021: Page Layout</li><li fr-original-style="" style="box-sizing: border-box;">Section 32: Word 2021: Envelops And Lables</li><li fr-original-style="" style="box-sizing: border-box;">Section 33: Word 2021: Mail Merges</li><li fr-original-style="" style="box-sizing: border-box;">Section 34: Word 2021: Review And Printing</li></ul><p id="isPasted" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Who is this course for:</strong></p><ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">Professionals seeking to enhance their productivity with Microsoft Office tools.</li><li fr-original-style="" style="box-sizing: border-box;">Students aiming to improve their technical skills for academic purposes.</li><li fr-original-style="" style="box-sizing: border-box;">Administrative staff needing comprehensive knowledge of Office applications.</li><li fr-original-style="" style="box-sizing: border-box;">Individuals looking to advance their careers with proficiency in Word, Excel, and PowerPoint.</li></ul><p id="isPasted" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Certification of Mastering Microsoft Office: Word, Excel, PowerPoint, and 365 Course:<br fr-original-style="" style="box-sizing: border-box;"></strong></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><a href="https://cpdqs.co.uk/" target="_blank" rel="noopener noreferrer" fr-original-style="" style="user-select: auto; font-size: var(--font-size); box-sizing: border-box; cursor: pointer; text-decoration: inherit;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">CPD QS</strong></a> certificates are available at an additional cost of &pound;9.99 for a PDF, &pound;16.99 for a printed hard copy, and &pound;24.99 for both PDF and printed versions.</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;">Requirements:</strong></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">This course has no academic entry requirements and is accessible to students from all backgrounds.</p><p id="isPasted" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Career Path:</strong></p><ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Administrative Assistant:</strong> &pound;18,000 - &pound;25,000 per annum</li><li fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Data Analyst:</strong> &pound;25,000 - &pound;40,000 per annum</li><li fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Office Manager:</strong> &pound;22,000 - &pound;35,000 per annum</li><li fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Project Coordinator:</strong> &pound;23,000 - &pound;37,000 per annum</li><li fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Executive Assistant:</strong> &pound;25,000 - &pound;45,000 per annum</li><li fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">IT Support Specialist:</strong> &pound;22,000 - &pound;38,000 per annum</li></ul><p id="isPasted" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><em fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Enrol now and advance your Microsoft Office skills to a professional level.</strong></em></p>

Our Mastering Microsoft Office: Word, Excel, PowerPoint, and 365 course provides an in-depth exploration of Excel 2021, starting with the basics of creating spreadsheets, entering data, and understanding relative references. Progress to more advanced topics like data handling, page setup, sorting, filtering, and writing sophisticated formulas, including VLOOKUP, HLOOKUP, and the 2021 exclusive XLOOKUP. Learn to create compelling charts and pivot tables that bring your data to life.
In PowerPoint 2021, start with presentation basics and advance to incorporating graphic assets, multimedia, and SmartArt graphics. Master text formatting, bullet options, and table and chart integration to create professional and engaging presentations. Explore the full suite of PowerPoint features, including transitions, animations, and slideshow effects, to captivate your audience.
The Word 2021 modules guide you through document creation, formatting, and layout management. Learn to work with tables, styles, and mail merges. Additionally, discover the collaboration and productivity features of Office 365, which enable seamless sharing and editing across platforms.
Learning Outcomes of Mastering Microsoft Office: Word, Excel, PowerPoint, and 365 Course:
Master the fundamentals of Excel 2021, including entering data and working with ranges.
Create and modify Excel charts and pivot tables for data analysis.
Develop PowerPoint presentations with advanced animations and multimedia elements.
Format documents in Word 2021, including creating tables and managing styles.
Execute mail merges and manage page layouts effectively in Word 2021.
Utilise Office 365 features for enhanced productivity and collaboration.
Understand and apply advanced Excel formulas like VLOOKUP, HLOOKUP, and XLOOKUP.
The Course Curriculum of Mastering Microsoft Office: Word, Excel, PowerPoint, and 365:
Section 01: Getting Started
Section 02: Excel 2021: Basics
Section 03: Excel 2021: Rows, Columns, And Cells
Section 04: Excel 2021: Data Handling
Section 05: Excel 2021: Page Setting Up And Print
Section 06: Excel 2021: Sorting And Filtering
Section 07: Excel 2021: Writing Formulas
Section 08: Excel 2021: Advanced Formulas
Section 09: Excel 2021: XLOOKUP Only For 2021 And Office 365
Section 10: Excel 2021: Data And Tools
Section 11: Excel 2021: Formatting Data And Tables
Section 12: Excel 2021: Pivot Tables
Section 13: Excel 2021: Charts
Section 14: PowerPoint 2021: Course Introduction
Section 15: PowerPoint 2021: Basics
Section 16: PowerPoint 2021: Text And Bullet Options
Section 17: PowerPoint 2021: Adding Graphic Assets
Section 18: PowerPoint 2021: Picture Formatting
Section 19: PowerPoint 2021: SmartArt Graphics
Section 20: PowerPoint 2021: Working With Tables
Section 21: PowerPoint 2021: Working With Charts
Section 22: PowerPoint 2021: Adding Multimedia
Section 23: PowerPoint 2021: Working With Transition
Section 24: PowerPoint 2021: Animation
Section 25: PowerPoint 2021: Slideshow Effects
Section 26: Word 2021: Introduction
Section 27: Word 2021: Basics
Section 28: Word 2021: Word Formatting
Section 29: Word 2021: Tables
Section 30: Word 2021: Styles
Section 31: Word 2021: Page Layout
Section 32: Word 2021: Envelops And Lables
Section 33: Word 2021: Mail Merges
Section 34: Word 2021: Review And Printing
Who is this course for:
Professionals seeking to enhance their productivity with Microsoft Office tools.
Students aiming to improve their technical skills for academic purposes.
Administrative staff needing comprehensive knowledge of Office applications.
Individuals looking to advance their careers with proficiency in Word, Excel, and PowerPoint.
Certification of Mastering Microsoft Office: Word, Excel, PowerPoint, and 365 Course:
CPD QS Accredited PDF Certificate - Included
CPD QS Accredited Hard Copy Certificate - Not Included
Requirements:
This course has no academic entry requirements and is accessible to students from all backgrounds.
Career Path:
Administrative Assistant: £18,000 - £25,000 per annum
Data Analyst: £25,000 - £40,000 per annum
Office Manager: £22,000 - £35,000 per annum
Project Coordinator: £23,000 - £37,000 per annum
Executive Assistant: £25,000 - £45,000 per annum
IT Support Specialist: £22,000 - £38,000 per annum
Enrol now and advance your Microsoft Office skills to a professional level.

St. Paul's College

Start your productivity potential! Master Microsoft Office with our comprehensive Mastering Microsoft Office: Word, Excel, PowerPoint, and 365 course. Conquer Excel formulas (VLOOKUP, HLOOKUP, XLOOKUP!), design impactful presentations in PowerPoint, and craft professional documents in Word. Take your skills to the next level and unlock a world of opportunity. Enrol now and become a Microsoft Office pro!

1327 Courses delivered Online

Level 7 Advanced Diploma in MS Excel - QLS Endorsed

By Skill Up

Microsoft Outlook Mastering Program

By Study Plex

MS Access 2016 Intermediate

By John Academy

Level 3 Diploma in Microsoft Access 2010

By John Academy

Microsoft Access - Beginners, Intermediate & Advanced

By John Academy

Minute Taking & Workplace Confidentiality - CPD Certified

By Academy for Health and Fitness

Admin, Secretarial & PA - Level 5 QLS Endorsed

By Compliance Central

Certificate in Know Your Customer & Customer Due Diligence

By Apex Learning

Microsoft Word 2007 for Beginners

By John Academy

Work from Home Essentials Courses

By Apex Learning