Name: Microsoft Excel - Automating Tasks with Macros
Price: 99 GBP
Availability: InStock

<strong>With an emphasis on intermediate-level abilities, this course covers Oracle Primavera Project Manager P6 PPM Professional Client's advanced features. The tool's database administration and setup instructions are also included. Upgrade your skills in Oracle Primavera Project Manager P6 PPM Professional Client with this advanced course.</strong>
        <p>Primavera is an enterprise project portfolio management software. It includes project management, scheduling, risk analysis, opportunity management, resource management, and collaboration and control capabilities, and integrates with other enterprise software such as Oracle and SAP's ERP systems. This course aims to teach students the advanced features of the Oracle Primavera Project Manager P6 PPM Professional tool.

You will start by exploring scheduling options and setting a baseline for the project. Then you will move to understanding user preferences and admin preferences and exploring other methods of organizing project data in Primavera. You will also look at managing the enterprise environment of Primavera. Exciting features such as 'global change' and how to schedule multiple projects will help you a lot in managing your project smoothly. Finally, you will look at the utility part of the Primavera tool in detail.

By the end of the course, you will have successfully learned the advanced features of the Primavera Project Manager P6 PPM Professional tool.

The resource files are uploaded on the GitHub repository at: https://github.com/PacktPublishing/Primavera-P6-PPM-Professional-Advanced-Features</p>
        <h2>What You Will Learn</h2><p>Explore scheduling options and setting a baseline<br>Understand user preferences and admin preferences<br>Explore other methods of organizing project data<br>Manage the enterprise environment of Primavera<br>Learn how to schedule multiple projects using Primavera<br>Look at the utilities part</p>
        <h2>Audience</h2><p>This course is best suited for program managers and project control staff evaluating the software against your organizational requirements, project schedulers who wish to learn how to use the software to schedule and control projects, database managers who wish to understand how to set up and administer a database, and experienced project personnel who wish to learn how to schedule and control a project.<br><br>You will need your computer with Oracle Primavera P6 loaded and experience in using application software such as Microsoft Office.</p>
        <h2>Approach</h2><p>This course follows the approach of explaining first, then a practical demonstration of the software functionality, followed up with student workshops to reinforce the learning.</p>
        <h2>Key Features</h2><p>Workshop on WBS (Work Breakdown Structure), LOEs (Level of Effort), and setting the baseline * Workshop working on codes and User-Defined Fields (UDFs) * Workshop on the Global Change feature</p>
        <h2>Github Repo</h2><p>https://github.com/PacktPublishing/Primavera-P6-PPM-Professional-Advanced-Features</p>
        <h2>About the Author</h2><h3>Paul E. Harris </h3><p>Paul E. Harris holds an honors degree in civil engineering obtained in the UK and is a certified cost engineer through AACEI International, a PRINCE2 registered practitioner, and a 'Managing Successful Programs' registered practitioner. He has worked in the project controls industry for a number of years and has assisted many companies in a range of industries to set up and run project control systems. His Melbourne, Australia-based company, Eastwood Harris Pty Ltd., offers project controls consulting and training services worldwide with a strong focus on Microsoft Project and Oracle Primavera software.</p>
        <h2>Course Outline</h2><h4>1. Introduction</h4><p>This section provides an introduction to the course.</p><table width='100%'><tbody><tr><td style='padding: 15px;'><p>1. Introduction and Workshop Instructions</p><p style='margin: 0'>This video provides an overview of the course and guides you with the instructions to be followed in order to achieve the most out of this course.</p></td></tr></tbody></table><br><h4>2. Scheduling Options and Setting a Baseline</h4><p>This section focuses on the scheduling options and setting a baseline in the Primavera P6 tool.</p><table width='100%'><tbody><tr><td style='padding: 15px;'><p>1. Introduction</p><p style='margin: 0'>This video provides an introduction to the section to scheduling options and setting a baseline.</p></td></tr><tr><td style='padding: 15px;'><p>2. Understanding Date Fields</p><p style='margin: 0'>This video explains the data fields options in the tool.</p></td></tr><tr><td style='padding: 15px;'><p>3. Scheduling Options - General Tab</p><p style='margin: 0'>In this video, we will look at the general tab of schedule options that has a number of options to be understood before progressing ahead with a schedule.</p></td></tr><tr><td style='padding: 15px;'><p>4. Setting the Baseline</p><p style='margin: 0'>This video explains what is meant by setting a baseline in a tool. We will be able to compare the current project's progress against the baseline. Here, we will look at two types of baselines: management/contract baselines and last-period status baselines.</p></td></tr><tr><td style='padding: 15px;'><p>5. Limitations on Viewing Baseline Data</p><p style='margin: 0'>This video explains the limitations on viewing baseline data.</p></td></tr><tr><td style='padding: 15px;'><p>6. Summary</p><p style='margin: 0'>This video helps you out with a summary of the section so far.</p></td></tr><tr><td style='padding: 15px;'><p>7. Workshop - WBS, LOEs, and Setting the Baseline</p><p style='margin: 0'>In this video, we will look at how WBS (Work Breakdown Structure) and LOE (Level of Effort) activities work, and then create and assign a baseline.</p></td></tr></tbody></table><br><h4>3. User Preferences and Admin Preferences</h4><p>This section focuses on the user preferences and admin preferences.</p><table width='100%'><tbody><tr><td style='padding: 15px;'><p>1. Introduction</p><p style='margin: 0'>This video provides an introduction to the section on user preferences and admin preferences.</p></td></tr><tr><td style='padding: 15px;'><p>2. User Preferences</p><p style='margin: 0'>This video demonstrates the user preferences option.</p></td></tr><tr><td style='padding: 15px;'><p>3. Admin Menu</p><p style='margin: 0'>This video explains the admin menu options.</p></td></tr><tr><td style='padding: 15px;'><p>4. Admin Preferences</p><p style='margin: 0'>This video demonstrates the admin preferences option.</p></td></tr><tr><td style='padding: 15px;'><p>5. Miscellaneous Defaults</p><p style='margin: 0'>In this video, you will look at miscellaneous defaults: currencies, financial periods, default project, and language.</p></td></tr><tr><td style='padding: 15px;'><p>6. Summary</p><p style='margin: 0'>This video helps you out with a summary of the section so far.</p></td></tr></tbody></table><br><h4>4. Other Methods of Organizing Project Data</h4><p>This section focuses on other methods of organizing project data.</p><table width='100%'><tbody><tr><td style='padding: 15px;'><p>1. Introduction</p><p style='margin: 0'>This video provides an introduction to the section on other methods of organizing project data.</p></td></tr><tr><td style='padding: 15px;'><p>2. Understanding Project Breakdown Structures</p><p style='margin: 0'>This video helps you understand project breakdown structures.</p></td></tr><tr><td style='padding: 15px;'><p>3. Activity Codes, UDFs, WBS Category, Resource Codes, Cost Accounts</p><p style='margin: 0'>This video talks about activity codes, UDFs (user-defined fields), WBS category (work breakdown structure), resource codes, and cost accounts.</p></td></tr><tr><td style='padding: 15px;'><p>4. Assignment Code New to P6 Version 20</p><p style='margin: 0'>This video is about the assignment code. It is aimed at providing an overview of the new assignment code feature in the latest version of Primavera P6 (Version 20).</p></td></tr><tr><td style='padding: 15px;'><p>5. Summary</p><p style='margin: 0'>This video helps you out with a summary of the section so far.</p></td></tr><tr><td style='padding: 15px;'><p>6. Workshop 19 - Activity Codes and User-Defined Fields (UDFs)</p><p style='margin: 0'>In this video, you will create an activity code to represent the departments' responsibilities for the project and then create some UDFs.</p></td></tr></tbody></table><br><h4>5. Global Change</h4><p>This section focuses on the global change feature of the Primavera tool.</p><table width='100%'><tbody><tr><td style='padding: 15px;'><p>1. Introduction</p><p style='margin: 0'>This video provides an introduction to the section on global change.</p></td></tr><tr><td style='padding: 15px;'><p>2. The Basic Concepts and Specifying the Change Statement</p><p style='margin: 0'>This video shows the basic concepts and specifying the change statement.</p></td></tr><tr><td style='padding: 15px;'><p>3. More Advanced Examples of Global Change</p><p style='margin: 0'>This video explores some more advanced examples of global change.</p></td></tr><tr><td style='padding: 15px;'><p>4. Summary</p><p style='margin: 0'>This video helps you out with a summary of the section so far.</p></td></tr><tr><td style='padding: 15px;'><p>5. Workshop 20 - Global Change</p><p style='margin: 0'>In this video, you will copy the current schedule dates and activity durations into the user-defined fields created in the previous workshop. Then, you will display a bar using these user-defined fields and use global change to edit some durations.</p></td></tr></tbody></table><br><h4>6. Managing the Enterprise Environment</h4><p>This section focuses on how to manage the enterprise environment.</p><table width='100%'><tbody><tr><td style='padding: 15px;'><p>1. Introduction</p><p style='margin: 0'>This video provides an introduction to the section on managing the enterprise environment.</p></td></tr><tr><td style='padding: 15px;'><p>2. Multiple User Data Display Issues</p><p style='margin: 0'>This video explains multiple user data display issues.</p></td></tr><tr><td style='padding: 15px;'><p>3. EPS, Project Portfolios, OBS, Users, Security Profiles</p><p style='margin: 0'>This video explains about the EPS (Enterprise Project Structure), project portfolios, OBS (Organizational Breakdown Structure), users, and security profiles.</p></td></tr><tr><td style='padding: 15px;'><p>4. Project Codes, Filtering, Grouping, and Sorting Projects in the Projects Window</p><p style='margin: 0'>This video talks about project codes, filtering, grouping, and sorting projects in the projects window.</p></td></tr><tr><td style='padding: 15px;'><p>5. Summarizing Projects, Job Services, Tracking Window</p><p style='margin: 0'>In this video, you will learn how to summarize projects, job services, and the tracking window.</p></td></tr><tr><td style='padding: 15px;'><p>6. Summary</p><p style='margin: 0'>This video helps you out with a summary of the section so far.</p></td></tr></tbody></table><br><h4>7. Multiple Project Scheduling</h4><p>This section focuses on multiple project scheduling in detail.</p><table width='100%'><tbody><tr><td style='padding: 15px;'><p>1. Introduction</p><p style='margin: 0'>This video provides an introduction to the section on multiple project scheduling.</p></td></tr><tr><td style='padding: 15px;'><p>2. Multiple Projects in a P6 Project, Multiple P6 Projects Representing One Project</p><p style='margin: 0'>This video explains multiple projects in the P6 project, and multiple P6 projects representing one project.</p></td></tr><tr><td style='padding: 15px;'><p>3. Refresh Data and Commit Changes, and Check Who Has the Project Open</p><p style='margin: 0'>This video shows how to refresh data and commit changes. Moving ahead, you will also be able to know who has the project open.</p></td></tr><tr><td style='padding: 15px;'><p>4. Restoring Baselines for Multiple Projects</p><p style='margin: 0'>This video explains restoring baselines for multiple projects.</p></td></tr><tr><td style='padding: 15px;'><p>5. Summary</p><p style='margin: 0'>This video helps you out with a summary of the section so far.</p></td></tr></tbody></table><br><h4>8. Utilities</h4><p>This section explains the utilities features.</p><table width='100%'><tbody><tr><td style='padding: 15px;'><p>1. Introduction</p><p style='margin: 0'>This video provides an introduction to the section on utilities.</p></td></tr><tr><td style='padding: 15px;'><p>2. Reflection Projects, Advanced Scheduling Options, and Audit Trail Columns</p><p style='margin: 0'>In this video, you will learn about the reflection projects, advanced scheduling options, and audit trail columns.</p></td></tr><tr><td style='padding: 15px;'><p>3. Excel and Project: Import and Export Tool</p><p style='margin: 0'>This video focuses on the Primavera built-in tool for importing and exporting to and from Excel. You will also look at how to import and export a project to and from the Primavera tool.</p></td></tr><tr><td style='padding: 15px;'><p>4. Check In and Check Out, UN/CEFACT XML Format, Online HTML Help</p><p style='margin: 0'>This video explains how to check in and check out of the database. After that, you will look at the UN/CEFACT XML format and check whether it is supported by Primavera or not, and finally, see how to get online HTML help.</p></td></tr><tr><td style='padding: 15px;'><p>5. Summary</p><p style='margin: 0'>This video helps you out with a summary of the section so far.</p></td></tr></tbody></table>

With an emphasis on intermediate-level abilities, this course covers Oracle Primavera Project Manager P6 PPM Professional Client's advanced features. The tool's database administration and setup instructions are also included. Upgrade your skills in Oracle Primavera Project Manager P6 PPM Professional Client with this advanced course.
Primavera is an enterprise project portfolio management software. It includes project management, scheduling, risk analysis, opportunity management, resource management, and collaboration and control capabilities, and integrates with other enterprise software such as Oracle and SAP's ERP systems. This course aims to teach students the advanced features of the Oracle Primavera Project Manager P6 PPM Professional tool. You will start by exploring scheduling options and setting a baseline for the project. Then you will move to understanding user preferences and admin preferences and exploring other methods of organizing project data in Primavera. You will also look at managing the enterprise environment of Primavera. Exciting features such as 'global change' and how to schedule multiple projects will help you a lot in managing your project smoothly. Finally, you will look at the utility part of the Primavera tool in detail. By the end of the course, you will have successfully learned the advanced features of the Primavera Project Manager P6 PPM Professional tool. The resource files are uploaded on the GitHub repository at: https://github.com/PacktPublishing/Primavera-P6-PPM-Professional-Advanced-Features
What You Will Learn
Explore scheduling options and setting a baseline
Understand user preferences and admin preferences
Explore other methods of organizing project data
Manage the enterprise environment of Primavera
Learn how to schedule multiple projects using Primavera
Look at the utilities part
Audience
This course is best suited for program managers and project control staff evaluating the software against your organizational requirements, project schedulers who wish to learn how to use the software to schedule and control projects, database managers who wish to understand how to set up and administer a database, and experienced project personnel who wish to learn how to schedule and control a project.

You will need your computer with Oracle Primavera P6 loaded and experience in using application software such as Microsoft Office.
Approach
This course follows the approach of explaining first, then a practical demonstration of the software functionality, followed up with student workshops to reinforce the learning.
Key Features
Workshop on WBS (Work Breakdown Structure), LOEs (Level of Effort), and setting the baseline * Workshop working on codes and User-Defined Fields (UDFs) * Workshop on the Global Change feature
Github Repo
https://github.com/PacktPublishing/Primavera-P6-PPM-Professional-Advanced-Features
About the Author
Paul E. Harris 
Paul E. Harris holds an honors degree in civil engineering obtained in the UK and is a certified cost engineer through AACEI International, a PRINCE2 registered practitioner, and a 'Managing Successful Programs' registered practitioner. He has worked in the project controls industry for a number of years and has assisted many companies in a range of industries to set up and run project control systems. His Melbourne, Australia-based company, Eastwood Harris Pty Ltd., offers project controls consulting and training services worldwide with a strong focus on Microsoft Project and Oracle Primavera software.
Course Outline
1. Introduction
This section provides an introduction to the course.
1. Introduction and Workshop Instructions
This video provides an overview of the course and guides you with the instructions to be followed in order to achieve the most out of this course.
2. Scheduling Options and Setting a Baseline
This section focuses on the scheduling options and setting a baseline in the Primavera P6 tool.
1. Introduction
This video provides an introduction to the section to scheduling options and setting a baseline.
2. Understanding Date Fields
This video explains the data fields options in the tool.
3. Scheduling Options - General Tab
In this video, we will look at the general tab of schedule options that has a number of options to be understood before progressing ahead with a schedule.
4. Setting the Baseline
This video explains what is meant by setting a baseline in a tool. We will be able to compare the current project's progress against the baseline. Here, we will look at two types of baselines: management/contract baselines and last-period status baselines.
5. Limitations on Viewing Baseline Data
This video explains the limitations on viewing baseline data.
6. Summary
This video helps you out with a summary of the section so far.
7. Workshop - WBS, LOEs, and Setting the Baseline
In this video, we will look at how WBS (Work Breakdown Structure) and LOE (Level of Effort) activities work, and then create and assign a baseline.
3. User Preferences and Admin Preferences
This section focuses on the user preferences and admin preferences.
1. Introduction
This video provides an introduction to the section on user preferences and admin preferences.
2. User Preferences
This video demonstrates the user preferences option.
3. Admin Menu
This video explains the admin menu options.
4. Admin Preferences
This video demonstrates the admin preferences option.
5. Miscellaneous Defaults
In this video, you will look at miscellaneous defaults: currencies, financial periods, default project, and language.
6. Summary
This video helps you out with a summary of the section so far.
4. Other Methods of Organizing Project Data
This section focuses on other methods of organizing project data.
1. Introduction
This video provides an introduction to the section on other methods of organizing project data.
2. Understanding Project Breakdown Structures
This video helps you understand project breakdown structures.
3. Activity Codes, UDFs, WBS Category, Resource Codes, Cost Accounts
This video talks about activity codes, UDFs (user-defined fields), WBS category (work breakdown structure), resource codes, and cost accounts.
4. Assignment Code New to P6 Version 20
This video is about the assignment code. It is aimed at providing an overview of the new assignment code feature in the latest version of Primavera P6 (Version 20).
5. Summary
This video helps you out with a summary of the section so far.
6. Workshop 19 - Activity Codes and User-Defined Fields (UDFs)
In this video, you will create an activity code to represent the departments' responsibilities for the project and then create some UDFs.
5. Global Change
This section focuses on the global change feature of the Primavera tool.
1. Introduction
This video provides an introduction to the section on global change.
2. The Basic Concepts and Specifying the Change Statement
This video shows the basic concepts and specifying the change statement.
3. More Advanced Examples of Global Change
This video explores some more advanced examples of global change.
4. Summary
This video helps you out with a summary of the section so far.
5. Workshop 20 - Global Change
In this video, you will copy the current schedule dates and activity durations into the user-defined fields created in the previous workshop. Then, you will display a bar using these user-defined fields and use global change to edit some durations.
6. Managing the Enterprise Environment
This section focuses on how to manage the enterprise environment.
1. Introduction
This video provides an introduction to the section on managing the enterprise environment.
2. Multiple User Data Display Issues
This video explains multiple user data display issues.
3. EPS, Project Portfolios, OBS, Users, Security Profiles
This video explains about the EPS (Enterprise Project Structure), project portfolios, OBS (Organizational Breakdown Structure), users, and security profiles.
4. Project Codes, Filtering, Grouping, and Sorting Projects in the Projects Window
This video talks about project codes, filtering, grouping, and sorting projects in the projects window.
5. Summarizing Projects, Job Services, Tracking Window
In this video, you will learn how to summarize projects, job services, and the tracking window.
6. Summary
This video helps you out with a summary of the section so far.
7. Multiple Project Scheduling
This section focuses on multiple project scheduling in detail.
1. Introduction
This video provides an introduction to the section on multiple project scheduling.
2. Multiple Projects in a P6 Project, Multiple P6 Projects Representing One Project
This video explains multiple projects in the P6 project, and multiple P6 projects representing one project.
3. Refresh Data and Commit Changes, and Check Who Has the Project Open
This video shows how to refresh data and commit changes. Moving ahead, you will also be able to know who has the project open.
4. Restoring Baselines for Multiple Projects
This video explains restoring baselines for multiple projects.
5. Summary
This video helps you out with a summary of the section so far.
8. Utilities
This section explains the utilities features.
1. Introduction
This video provides an introduction to the section on utilities.
2. Reflection Projects, Advanced Scheduling Options, and Audit Trail Columns
In this video, you will learn about the reflection projects, advanced scheduling options, and audit trail columns.
3. Excel and Project: Import and Export Tool
This video focuses on the Primavera built-in tool for importing and exporting to and from Excel. You will also look at how to import and export a project to and from the Primavera tool.
4. Check In and Check Out, UN/CEFACT XML Format, Online HTML Help
This video explains how to check in and check out of the database. After that, you will look at the UN/CEFACT XML format and check whether it is supported by Primavera or not, and finally, see how to get online HTML help.
5. Summary
This video helps you out with a summary of the section so far.

Packt

Primavera P6

Project Management

With an emphasis on intermediate-level abilities, this course covers Oracle Primavera Project Manager P6 PPM Professional Client's advanced features. The tool's database administration and setup instructions are also included. Upgrade your skills in Oracle Primavera Project Manager P6 PPM Professional Client with this advanced course.

Oracle Primavera P6 PPM Professional Advanced Features

General Admission

<section>
						<div>
				<div>
				<div>
			<div>
					<div>
				<div>
				<div>
					<div>
			<div></div>
		</div>
				</div>
				</div>
				<div>
				<div>
			
				</div>
				<div>
				<div>
					<div><p>Gain the skills and credentials to kickstart a successful career and learn from the experts with this step-by-step training course. This Microsoft Word Advanced Skills has been specially designed to help learners gain a good command of Microsoft Word Advanced Skills, providing them with a solid foundation of knowledge to become a qualified professional.</p><p>Through this Microsoft Word Advanced Skills, you will gain both practical and theoretical understanding of Microsoft Word Advanced Skills that will increase your employability in this field, help you stand out from the competition and boost your earning potential in no time.</p><p>Not only that, but this training includes up-to-date knowledge and techniques that will ensure you have the most in-demand skills to rise to the top of the industry. This qualification is fully accredited, broken down into several manageable modules, ideal for aspiring professionals.</p></div>
				</div>
				</div>
						</div>
			</div>
		</div>
						</div>
			</div>
		</div></section>
				<section>
						<div>
				<div>
				<div>
			<div>
					<div>
				<div>
				<div>
			<h2><b> Learning outcome</b></h2>		</div>
				</div>
				<div>
				<div>
					<ul>
							<li>
											<span>
													</span>
										<span>Familiar yourself with the recent development and updates of the relevant industry</span>
									</li>
								<li>
											<span>
													</span>
										<span>Know how to use your theoretical knowledge to adapt in any working environment</span>
									</li>
								<li>
											<span>
													</span>
										<span>Get help from our expert tutors anytime you need</span>
									</li>
								<li>
											<span>
													</span>
										<span>Access to course contents that are designed and prepared by industry professionals</span>
									</li>
								<li>
											<span>
													</span>
										<span>Study at your convenient time and from wherever you want</span>
									</li>
						</ul>
				</div>
				</div>
						</div>
			</div>
		</div>
						</div>
			</div>
		</section>
				<section>
						<div>
				<div>
				<div>
			<div>
					<div>
				<div>
				<div>
					</div>
				</div>
				<div>
				<div>
					
			</div>
				</div>
						</div>
			</div>
		</div>
						</div>
			</div>
		</section>
				<section>
						<div>
				<div>
				<div>
			<div>
					<div>
				<div>
				<div>
			<h2> <b>Why should I take this course?</b></h2>		</div>
				</div>
				<div>
				<div>
					<ul>
							<li>
											<span>
													</span>
										<span>Affordable premium-quality E-learning content, you can learn at your own pace.</span>
									</li>
								<li>
											<span>
													</span>
										<span>You will receive a completion certificate upon completing the course.</span>
									</li>
								<li>
											<span>
													</span>
										<span>Internationally recognized Accredited Qualification will boost up your resume.</span>
									</li>
								<li>
											<span>
													</span>
										<span>You will learn the researched and proven approach adopted by successful people to transform their careers.</span>
									</li>
								<li>
											<span>
													</span>
										<span>You will be able to incorporate various techniques successfully and understand your customers better.</span>
									</li>
						</ul>
				</div>
				</div>
						</div>
			</div>
		</div>
						</div>
			</div>
		</section>
				<section>
						<div>
				<div>
				<div>
			<div>
					<div>
				<div>
				<div>
			<h2> <b>Requirements</b></h2>		</div>
				</div>
				<div>
				<div>
					<ul>
							<li>
											<span>
													</span>
										<span>No formal qualifications required, anyone from any academic background can take this course.</span>
									</li>
								<li>
											<span>
													</span>
										<span>Access to a computer or digital device with internet connectivity.</span>
									</li>
						</ul>
				</div>
				</div>
						</div>
			</div>
		</div>
						</div>
			</div>
		</section><div>
                            <div>
                                <h2>Course Curriculum</h2>
                            </div>
                            			<div>
				

<div>
<table width="100%">				<tbody><tr>
					<td colspan="4"><strong>Manipulating Images</strong></td>
				</tr>
								<tr>
					<td>▶</td>
					<td>Integrate Pictures and Text</td><td><span>🕐 00:15:00</span></td>
				</tr>
								<tr>
					<td>▶</td>
					<td>Adjust Image Appearance</td><td><span>🕐 00:09:00</span></td>
				</tr>
								<tr>
					<td>▶</td>
					<td>Insert Other Media Elements</td><td><span>🕐 00:02:00</span></td>
				</tr>
								<tr>
					<td colspan="4"><strong>Using Custom Graphic Elements</strong></td>
				</tr>
								<tr>
					<td>▶</td>
					<td>Create Text Boxes and Pull Quotes</td><td><span>🕐 00:06:00</span></td>
				</tr>
								<tr>
					<td>▶</td>
					<td>Add WordArt and Other Text Effects</td><td><span>🕐 00:05:00</span></td>
				</tr>
								<tr>
					<td>▶</td>
					<td>Draw Shapes</td><td><span>🕐 00:07:00</span></td>
				</tr>
								<tr>
					<td>▶</td>
					<td>Create Complex Illustrations with SmartArt</td><td><span>🕐 00:08:00</span></td>
				</tr>
								<tr>
					<td colspan="4"><strong>Collaborating on Documents</strong></td>
				</tr>
								<tr>
					<td>▶</td>
					<td>Prepare a Document for Collaboration</td><td><span>🕐 00:09:00</span></td>
				</tr>
								<tr>
					<td>▶</td>
					<td>Mark Up a Document</td><td><span>🕐 00:06:00</span></td>
				</tr>
								<tr>
					<td>▶</td>
					<td>Review Markups</td><td><span>🕐 00:04:00</span></td>
				</tr>
								<tr>
					<td>▶</td>
					<td>Merge Changes from Other Documents</td><td><span>🕐 00:06:00</span></td>
				</tr>
								<tr>
					<td colspan="4"><strong>Adding Document References and Links</strong></td>
				</tr>
								<tr>
					<td>▶</td>
					<td>Add Captions</td><td><span>🕐 00:06:00</span></td>
				</tr>
								<tr>
					<td>▶</td>
					<td>Add Cross References</td><td><span>🕐 00:08:00</span></td>
				</tr>
								<tr>
					<td>▶</td>
					<td>Add Bookmarks</td><td><span>🕐 00:05:00</span></td>
				</tr>
								<tr>
					<td>▶</td>
					<td>Add Hyperlinks</td><td><span>🕐 00:06:00</span></td>
				</tr>
								<tr>
					<td>▶</td>
					<td>Insert Footnotes and Endnotes</td><td><span>🕐 00:05:00</span></td>
				</tr>
								<tr>
					<td>▶</td>
					<td>Add Citations and a Bibliography</td><td><span>🕐 00:12:00</span></td>
				</tr>
								<tr>
					<td colspan="4"><strong>Securing a Document</strong></td>
				</tr>
								<tr>
					<td>▶</td>
					<td>Suppress Information</td><td><span>🕐 00:08:00</span></td>
				</tr>
								<tr>
					<td>▶</td>
					<td>Set Formatting and Editing Restrictions</td><td><span>🕐 00:06:00</span></td>
				</tr>
								<tr>
					<td>▶</td>
					<td>Restrict Document Access</td><td><span>🕐 00:02:00</span></td>
				</tr>
								<tr>
					<td>▶</td>
					<td>Add a Digital Signature to a Document</td><td><span>🕐 00:04:00</span></td>
				</tr>
								<tr>
					<td colspan="4"><strong>Using Forms to Manage Content</strong></td>
				</tr>
								<tr>
					<td>▶</td>
					<td>Create Forms</td><td><span>🕐 00:09:00</span></td>
				</tr>
								<tr>
					<td>▶</td>
					<td>Modify Forms</td><td><span>🕐 00:03:00</span></td>
				</tr>
								<tr>
					<td colspan="4"><strong>Automating Repetitive Tasks with Macros</strong></td>
				</tr>
								<tr>
					<td>▶</td>
					<td>Automate Tasks by Using Macros</td><td><span>🕐 00:10:00</span></td>
				</tr>
								<tr>
					<td>▶</td>
					<td>Create a Macro</td><td><span>🕐 00:19:00</span></td>
				</tr>
								<tr>
					<td colspan="4"><strong>Assignment</strong></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Assignment - Microsoft Word Advanced</td><td><span>🕐 00:00:00</span></td>
				</tr>
				</tbody></table></div>

			</div>
		                        </div>

Gain the skills and credentials to kickstart a successful career and learn from the experts with this step-by-step training course. This Microsoft Word Advanced Skills has been specially designed to help learners gain a good command of Microsoft Word Advanced Skills, providing them with a solid foundation of knowledge to become a qualified professional.
Through this Microsoft Word Advanced Skills, you will gain both practical and theoretical understanding of Microsoft Word Advanced Skills that will increase your employability in this field, help you stand out from the competition and boost your earning potential in no time.
Not only that, but this training includes up-to-date knowledge and techniques that will ensure you have the most in-demand skills to rise to the top of the industry. This qualification is fully accredited, broken down into several manageable modules, ideal for aspiring professionals.
 Learning outcome
Familiar yourself with the recent development and updates of the relevant industry
Know how to use your theoretical knowledge to adapt in any working environment
Get help from our expert tutors anytime you need
Access to course contents that are designed and prepared by industry professionals
Study at your convenient time and from wherever you want
 Why should I take this course?
Affordable premium-quality E-learning content, you can learn at your own pace.
You will receive a completion certificate upon completing the course.
Internationally recognized Accredited Qualification will boost up your resume.
You will learn the researched and proven approach adopted by successful people to transform their careers.
You will be able to incorporate various techniques successfully and understand your customers better.
 Requirements
No formal qualifications required, anyone from any academic background can take this course.
Access to a computer or digital device with internet connectivity.
Course Curriculum
Manipulating Images			
▶	Integrate Pictures and Text	🕐 00:15:00
▶	Adjust Image Appearance	🕐 00:09:00
▶	Insert Other Media Elements	🕐 00:02:00
Using Custom Graphic Elements			
▶	Create Text Boxes and Pull Quotes	🕐 00:06:00
▶	Add WordArt and Other Text Effects	🕐 00:05:00
▶	Draw Shapes	🕐 00:07:00
▶	Create Complex Illustrations with SmartArt	🕐 00:08:00
Collaborating on Documents			
▶	Prepare a Document for Collaboration	🕐 00:09:00
▶	Mark Up a Document	🕐 00:06:00
▶	Review Markups	🕐 00:04:00
▶	Merge Changes from Other Documents	🕐 00:06:00
Adding Document References and Links			
▶	Add Captions	🕐 00:06:00
▶	Add Cross References	🕐 00:08:00
▶	Add Bookmarks	🕐 00:05:00
▶	Add Hyperlinks	🕐 00:06:00
▶	Insert Footnotes and Endnotes	🕐 00:05:00
▶	Add Citations and a Bibliography	🕐 00:12:00
Securing a Document			
▶	Suppress Information	🕐 00:08:00
▶	Set Formatting and Editing Restrictions	🕐 00:06:00
▶	Restrict Document Access	🕐 00:02:00
▶	Add a Digital Signature to a Document	🕐 00:04:00
Using Forms to Manage Content			
▶	Create Forms	🕐 00:09:00
▶	Modify Forms	🕐 00:03:00
Automating Repetitive Tasks with Macros			
▶	Automate Tasks by Using Macros	🕐 00:10:00
▶	Create a Macro	🕐 00:19:00
Assignment			
	Assignment - Microsoft Word Advanced	🕐 00:00:00

Skill Up

Office Skills & Productivity

Microsoft Certification

Office Skills

Computer Skills

Microsoft Office

Microsoft Word

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

Microsoft Word Advanced

<p style="color: rgba(18, 18, 18, 0.75); font-size: var(--font-size); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgba(18, 18, 18, 0.75);">Learn additional functions and formulas to become a more expert Excel user.</p><p style="color: rgba(18, 18, 18, 0.75); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgba(18, 18, 18, 0.75);">This class will give you hands-on instruction as you work with <span data-mce-fragment="1" fr-original-style="" style="box-sizing: border-box;">the IF, nested IF and IF/AND logical functions, the TRIM, PROPER, CONCATENATE, TEXT, LEFT, RIGHT, and MID text functions, VLOOKUP with an approximate and exact match, separating text into columns, and the SUMIF, SUMIFS, AVERAGEIF, AVERAGEIFS, COUNTIF and COUNTIFS conditional functions to process worksheet data more efficiently.&nbsp;</span></p><p style="color: rgba(18, 18, 18, 0.75); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgba(18, 18, 18, 0.75);"><span data-mce-fragment="1" fr-original-style="" style="box-sizing: border-box;">This class is:</span></p><ul style="color: rgba(18, 18, 18, 0.75); box-sizing: border-box;" fr-original-style=" color: rgba(18, 18, 18, 0.75);"><li fr-original-style="" style="box-sizing: border-box;"><span data-mce-fragment="1" fr-original-style="" style="box-sizing: border-box;">Live, instructor-led, virtual class</span></li><li fr-original-style="" style="box-sizing: border-box;"><span data-mce-fragment="1" fr-original-style="" style="box-sizing: border-box;">90 minutes</span></li><li fr-original-style="" style="box-sizing: border-box;"><span data-mce-fragment="1" fr-original-style="" style="box-sizing: border-box;">Completion digital badge and certificate provided</span></li></ul>

AXIOM Learning Solutions

Microsoft Excel

Microsoft Excel - More Functions and Formulas

<p style="color: rgba(18, 18, 18, 0.75); font-size: var(--font-size); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgba(18, 18, 18, 0.75);">In Microsoft Excel, related data can be organized using a range of cells. This class provides an overview of list and table design techniques. You will learn:</p><ul style="color: rgba(18, 18, 18, 0.75); box-sizing: border-box;" fr-original-style=" color: rgba(18, 18, 18, 0.75);"><li fr-original-style="" style="box-sizing: border-box;">Procedures to sort, filter and validate data</li><li fr-original-style="" style="box-sizing: border-box;">How to use formulas in lists and tables</li><li fr-original-style="" style="box-sizing: border-box;">How to identify and remove duplicate records</li><li fr-original-style="" style="box-sizing: border-box;">How to use the subtotal and outline features</li></ul><p style="color: rgba(18, 18, 18, 0.75); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgba(18, 18, 18, 0.75);">This class is:</p><ul style="color: rgba(18, 18, 18, 0.75); box-sizing: border-box;" fr-original-style=" color: rgba(18, 18, 18, 0.75);"><li fr-original-style="" style="box-sizing: border-box;">Live, instructor-led, virtual class</li><li fr-original-style="" style="box-sizing: border-box;">90 minutes</li><li fr-original-style="" style="box-sizing: border-box;">Completion digital badge and certificate provided</li></ul>

Microsoft Excel - Lists and Tables

<p style="color: rgba(18, 18, 18, 0.75); font-size: var(--font-size); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgba(18, 18, 18, 0.75);">In this introduction to Microsoft Excel, you will learn the terminology and capabilities of Excel. This class covers an introduction to the Excel application and interface. You will learn:</p><ul style="color: rgba(18, 18, 18, 0.75); box-sizing: border-box;" fr-original-style=" color: rgba(18, 18, 18, 0.75);"><li fr-original-style="" style="box-sizing: border-box;">How to create and work with Workbooks</li><li fr-original-style="" style="box-sizing: border-box;">How to navigate in a Worksheet</li><li fr-original-style="" style="box-sizing: border-box;">How to enter, delete and select data</li><li fr-original-style="" style="box-sizing: border-box;">How to undo/redo actions</li><li fr-original-style="" style="box-sizing: border-box;">How to control your view, including zoom in/out</li><li fr-original-style="" style="box-sizing: border-box;">How to create simple calculations</li><li fr-original-style="" style="box-sizing: border-box;">How to do basic sorting, moving and copying data</li><li fr-original-style="" style="box-sizing: border-box;">How to set print settings and explore print preview</li></ul><p style="color: rgba(18, 18, 18, 0.75); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgba(18, 18, 18, 0.75);">This class is:</p><ul style="color: rgba(18, 18, 18, 0.75); box-sizing: border-box;" fr-original-style=" color: rgba(18, 18, 18, 0.75);"><li fr-original-style="" style="box-sizing: border-box;">Live, instructor-led, virtual class</li><li fr-original-style="" style="box-sizing: border-box;">90 minutes</li><li fr-original-style="" style="box-sizing: border-box;">Completion digital badge and certificate provided</li></ul>

Microsoft Excel - Getting Started

<p style="color: rgba(18, 18, 18, 0.75); font-size: var(--font-size); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgba(18, 18, 18, 0.75);"><span data-mce-fragment="1" fr-original-style="" style="box-sizing: border-box;">Learn the fundamentals of creating and working with formulas and functions. In this class, you will learn:</span></p><ul style="color: rgba(18, 18, 18, 0.75); box-sizing: border-box;" fr-original-style=" color: rgba(18, 18, 18, 0.75);"><li fr-original-style="" style="box-sizing: border-box;"><span data-mce-fragment="1" fr-original-style="" style="box-sizing: border-box;">Building and copying simple formulas</span></li><li fr-original-style="" style="box-sizing: border-box;"><span data-mce-fragment="1" fr-original-style="" style="box-sizing: border-box;">Understand formulas operators and the order of operations</span></li><li fr-original-style="" style="box-sizing: border-box;"><span data-mce-fragment="1" fr-original-style="" style="box-sizing: border-box;">Learn to use functions such as SUM, AVERAGE, PMT, ROUND, TODAY, and NETWORKDAYS</span></li><li fr-original-style="" style="box-sizing: border-box;"><span data-mce-fragment="1" fr-original-style="" style="box-sizing: border-box;">Understand the difference between relative and absolute cell references</span></li><li fr-original-style="" style="box-sizing: border-box;"><span data-mce-fragment="1" fr-original-style="" style="box-sizing: border-box;">Create grand totals and work with formulas that contain 3-D references</span></li></ul><p style="color: rgba(18, 18, 18, 0.75); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgba(18, 18, 18, 0.75);"><span data-mce-fragment="1" fr-original-style="" style="box-sizing: border-box;">Class details:</span></p><ul style="color: rgba(18, 18, 18, 0.75); box-sizing: border-box;" fr-original-style=" color: rgba(18, 18, 18, 0.75);"><li fr-original-style="" style="box-sizing: border-box;">Live, instructor-led, virtual class</li><li fr-original-style="" style="box-sizing: border-box;">90 minutes</li><li fr-original-style="" style="box-sizing: border-box;">Completion digital badge and certificate provided</li></ul>

Microsoft Excel - Functions and Formulas

<p style="color: rgba(18, 18, 18, 0.75); font-size: var(--font-size); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgba(18, 18, 18, 0.75);"><span data-mce-fragment="1" fr-original-style="" style="box-sizing: border-box;">Learn the basic formatting techniques necessary to enhance the way data displays on a worksheet and in print. You will learn how to:</span></p><ul style="color: rgba(18, 18, 18, 0.75); box-sizing: border-box;" fr-original-style=" color: rgba(18, 18, 18, 0.75);"><li fr-original-style="" style="box-sizing: border-box;"><span data-mce-fragment="1" fr-original-style="" style="box-sizing: border-box;">Adjust column width and row height</span></li><li fr-original-style="" style="box-sizing: border-box;"><span data-mce-fragment="1" fr-original-style="" style="box-sizing: border-box;">Format text, change alignment of data, format numbers</span></li><li fr-original-style="" style="box-sizing: border-box;"><span data-mce-fragment="1" fr-original-style="" style="box-sizing: border-box;">Copy formatting to other cells</span></li><li fr-original-style="" style="box-sizing: border-box;"><span data-mce-fragment="1" fr-original-style="" style="box-sizing: border-box;">Create conditional formatting rules</span></li><li fr-original-style="" style="box-sizing: border-box;"><span data-mce-fragment="1" fr-original-style="" style="box-sizing: border-box;">Create and apply styles</span></li><li fr-original-style="" style="box-sizing: border-box;"><span data-mce-fragment="1" fr-original-style="" style="box-sizing: border-box;">Use Page Layout and Page Break Preview</span></li><li fr-original-style="" style="box-sizing: border-box;"><span data-mce-fragment="1" fr-original-style="" style="box-sizing: border-box;">Set up column and row headings to print on each page</span></li><li fr-original-style="" style="box-sizing: border-box;"><span data-mce-fragment="1" fr-original-style="" style="box-sizing: border-box;">Insert page breaks</span></li><li fr-original-style="" style="box-sizing: border-box;"><span data-mce-fragment="1" fr-original-style="" style="box-sizing: border-box;">Scale your data to fit on pages</span></li><li fr-original-style="" style="box-sizing: border-box;"><span data-mce-fragment="1" fr-original-style="" style="box-sizing: border-box;">Show/hide gridlines</span></li><li fr-original-style="" style="box-sizing: border-box;"><span data-mce-fragment="1" fr-original-style="" style="box-sizing: border-box;">Insert a header and footer&nbsp;</span></li></ul><p style="color: rgba(18, 18, 18, 0.75); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgba(18, 18, 18, 0.75);"><span data-mce-fragment="1" fr-original-style="" style="box-sizing: border-box;">This class is:</span></p><ul style="color: rgba(18, 18, 18, 0.75); box-sizing: border-box;" fr-original-style=" color: rgba(18, 18, 18, 0.75);"><li fr-original-style="" style="box-sizing: border-box;"><span data-mce-fragment="1" fr-original-style="" style="box-sizing: border-box;">Live, instructor-led, virtual class</span></li><li fr-original-style="" style="box-sizing: border-box;"><span data-mce-fragment="1" fr-original-style="" style="box-sizing: border-box;">90 minutes</span></li><li fr-original-style="" style="box-sizing: border-box;"><span data-mce-fragment="1" fr-original-style="" style="box-sizing: border-box;">Completion digital badge and certificate provided</span></li></ul>

Microsoft Excel - Formatting Spreadsheets

<p style="color: rgba(18, 18, 18, 0.75); font-size: var(--font-size); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgba(18, 18, 18, 0.75);"><span data-mce-fragment="1" fr-original-style="" style="box-sizing: border-box;">Learn to create Scenarios and use the Scenario Manager, use Goal Seek, and Solver tools to effectively analyze data in your worksheets. Also learn to create one and two variable data tables and consolidate data. Finally, learn to use Excel&rsquo;s one-click forecasting tool.</span></p><ul style="color: rgba(18, 18, 18, 0.75); box-sizing: border-box;" fr-original-style=" color: rgba(18, 18, 18, 0.75);"><li fr-original-style="" style="box-sizing: border-box;">Live, instructor-led, virtual class</li><li fr-original-style="" style="box-sizing: border-box;">90 minutes</li><li fr-original-style="" style="box-sizing: border-box;">Completion digital badge and certificate provided</li></ul>

Microsoft Excel - Data Analysis Tools

<p style="color: rgba(18, 18, 18, 0.75); font-size: var(--font-size); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgba(18, 18, 18, 0.75);">This class will teach you how to create compelling data visualizations using Microsoft Excel. You will learn to create several types of professional-looking charts in Excel, identify chart elements, set up the source data, select the data to include on a Chart, learn ways to create Charts, work with Chart Layouts and Quick Layouts, learn to modify, add, and format charts to enhance the presentation of your data, change the data source, save a Chart as a Chart Template, and print Charts.</p><ul style="color: rgba(18, 18, 18, 0.75); box-sizing: border-box;" fr-original-style=" color: rgba(18, 18, 18, 0.75);"><li fr-original-style="" style="box-sizing: border-box;">Live, instructor-led, virtual class</li><li fr-original-style="" style="box-sizing: border-box;">90 minutes</li><li fr-original-style="" style="box-sizing: border-box;">Completion digital badge and certificate provided</li></ul>

Microsoft Excel - Creating Charts

<main tabindex="-1" id="isPasted" fr-original-style="" style="box-sizing: border-box;"><section fr-original-style="" style="box-sizing: border-box;"><section data-section="template--18705858167105__main" fr-original-style="" style="box-sizing: border-box;"><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span data-mce-fragment="1" fr-original-style="" style="box-sizing: border-box;">Microsoft Excel Macros are a tool you can use to automate a task (an action or a set of actions) by recording your mouse clicks and keystrokes.</span></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span data-mce-fragment="1" fr-original-style="" style="box-sizing: border-box;">In this class, you will learn about macro security, preparing to record a macro, absolute and relative macro recording. You will record various macros in class including a macro that formats and sums data, one that sorts, subtotals and collapses an outline, a macro that moves data to rows, another that filters for the top ten sales, copies the filtered data to a new sheet and adds a heading.&nbsp;</span></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Other concepts include viewing VBA code and editing the code, running macros with keyboard shortcuts, Quick Access toolbar buttons and macro buttons drawn on the worksheet. &nbsp;Lastly, we learn about the Personal Macro Workbook and save a macro that formats heading to the Personal Macro workbook and record a macro that runs automatically when you open the workbook.&nbsp;</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">This class is:</p><ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">Live, instructor-led, virtual class</li><li fr-original-style="" style="box-sizing: border-box;">90 minutes</li><li fr-original-style="" style="box-sizing: border-box;">Completion digital badge and certificate provided</li></ul></section></section></main>

Microsoft Excel - Automating Tasks with Macros

Duration
5 Days
30 CPD hours
This course is intended for

This course is designed for persons aspiring to the Microsoft 365 Administrator role and have completed at least one of the Microsoft 365 role-based administrator certification paths.


This course covers the following key elements of Microsoft 365 administration: Microsoft 365 tenant management, Microsoft 365 identity synchronization, and Microsoft 365 security and compliance.
In Microsoft 365 tenant management, you learn how to configure your Microsoft 365 tenant, including your organizational profile, tenant subscription options, component services, user accounts and licenses, security groups, and administrative roles. You then transition to configuring Microsoft 365, with a primary focus on configuring Office client connectivity. Finally, you explore how to manage user-driven client installations of Microsoft 365 Apps for enterprise deployments.
The course then transitions to an in-depth examination of Microsoft 365 identity synchronization, with a focus on Microsoft Entra Connect and Connect Cloud Sync. You learn how to plan for and implement each of these directory synchronization options, how to manage synchronized identities, and how to implement password management in Microsoft 365 using multifactor authentication and self-service password management.
In Microsoft 365 security management, you begin examining the common types of threat vectors and data breaches facing organizations today. You then learn how Microsoft 365?s security solutions address each of these threats. You are introduced to the Microsoft Secure Score, as well as to Microsoft Entra ID Protection. You then learn how to manage the Microsoft 365 security services, including Exchange Online Protection, Safe Attachments, and Safe Links. Finally, you are introduced to the various reports that monitor an organization?s security health. You then transition from security services to threat intelligence; specifically, using Microsoft 365 Defender, Microsoft Defender for Cloud Apps, and Microsoft Defender for Endpoint.
Once you have this understanding of Microsoft 365?s security suite, you then examine the key components of Microsoft 365 compliance management. This begins with an overview of all key aspects of data governance, including data archiving and retention, Microsoft Purview message encryption, and data loss prevention (DLP). You then delve deeper into archiving and retention, paying particular attention to Microsoft Purview insider risk management, information barriers, and DLP policies. You then examine how to implement these compliance features by using data classification and sensitivity labels.

Prerequisites

Completed a role-based administrator course such as Messaging, Teamwork, Security, Compliance, or Collaboration.
A proficient understanding of DNS and basic functional experience with Microsoft 365 services.
A proficient understanding of general IT practices.
A working knowledge of PowerShell.

1 - Configure your Microsoft 365 experience
Explore your Microsoft 365 cloud environment
Configure your Microsoft 365 organizational profile
Manage your tenant subscriptions in Microsoft 365
Integrate Microsoft 365 with customer engagement apps
Complete your tenant configuration in Microsoft 365
2 - Manage users, licenses, and mail contacts in Microsoft 365
Determine the user identity model for your organization
Create user accounts in Microsoft 365
Manage user account settings in Microsoft 365
Manage user licenses in Microsoft 365
Recover deleted user accounts in Microsoft 365
Perform bulk user maintenance in Microsoft Entra ID
Create and manage guest users
Create and manage mail contacts
3 - Manage groups in Microsoft 365
Examine groups in Microsoft 365
Create and manage groups in Microsoft 365
Create dynamic groups using Azure rule builder
Create a Microsoft 365 group naming policy
Create groups in Exchange Online and SharePoint Online
4 - Add a custom domain in Microsoft 365
Plan a custom domain for your Microsoft 365 deployment
Plan the DNS zones for a custom domain
Plan the DNS record requirements for a custom domain
Create a custom domain in Microsoft 365
5 - Configure client connectivity to Microsoft 365
Examine how automatic client configuration works
Explore the DNS records required for client configuration
Configure Outlook clients
Troubleshoot client connectivity
6 - Configure administrative roles in Microsoft 365
Explore the Microsoft 365 permission model
Explore the Microsoft 365 admin roles
Assign admin roles to users in Microsoft 365
Delegate admin roles to partners
Manage permissions using administrative units in Microsoft Entra ID
Elevate privileges using Microsoft Entra Privileged Identity Management
Examine best practices when configuring administrative roles
7 - Manage tenant health and services in Microsoft 365
Monitor the health of your Microsoft 365 services
Monitor tenant health using Microsoft 365 Adoption Score
Monitor tenant health using Microsoft 365 usage analytics
Develop an incident response plan
Request assistance from Microsoft
8 - Deploy Microsoft 365 Apps for enterprise
Explore Microsoft 365 Apps for enterprise functionality
Explore your app compatibility by using the Readiness Toolkit
Complete a self-service installation of Microsoft 365 Apps for enterprise
Deploy Microsoft 365 Apps for enterprise with Microsoft Configuration Manager
Deploy Microsoft 365 Apps for enterprise from the cloud
Deploy Microsoft 365 Apps for enterprise from a local source
Manage updates to Microsoft 365 Apps for enterprise
Explore the update channels for Microsoft 365 Apps for enterprise
Manage your cloud apps using the Microsoft 365 Apps admin center
9 - Analyze your Microsoft 365 workplace data using Microsoft Viva Insights
Examine the analytical features of Microsoft Viva Insights
Explore Personal insights
Explore Team insights
Explore Organization insights
Explore Advanced insights
10 - Explore identity synchronization
Examine identity models for Microsoft 365
Examine authentication options for the hybrid identity model
Explore directory synchronization
11 - Prepare for identity synchronization to Microsoft 365
Plan your Microsoft Entra deployment
Prepare for directory synchronization
Choose your directory synchronization tool
Plan for directory synchronization using Microsoft Entra Connect
Plan for directory synchronization using Microsoft Entra Connect cloud sync
12 - Implement directory synchronization tools
Configure Microsoft Entra Connect prerequisites
Configure Microsoft Entra Connect
Monitor synchronization services using Microsoft Entra Connect Health
Configure Microsoft Entra Connect cloud sync prerequisites
Configure Microsoft Entra Connect cloud sync
13 - Manage synchronized identities
Manage users with directory synchronization
Manage groups with directory synchronization
Use Microsoft Entra Connect Sync Security Groups to help maintain directory synchronization
Configure object filters for directory synchronization
Explore Microsoft Identity Manager
Troubleshoot directory synchronization
14 - Manage secure user access in Microsoft 365
Manage user passwords
Enable pass-through authentication
Enable multifactor authentication
Enable passwordless sign-in with Microsoft Authenticator
Explore self-service password management
Explore Windows Hello for Business
Implement Microsoft Entra Smart Lockout
Implement conditional access policies
Explore Security Defaults in Microsoft Entra ID
Investigate authentication issues using sign-in logs
15 - Examine threat vectors and data breaches
Explore today's work and threat landscape
Examine how phishing retrieves sensitive information
Examine how spoofing deceives users and compromises data security
Compare spam and malware
Examine account breaches
Examine elevation of privilege attacks
Examine how data exfiltration moves data out of your tenant
Examine how attackers delete data from your tenant
Examine how data spillage exposes data outside your tenant
Examine other types of attacks
16 - Explore the Zero Trust security model
Examine the principles and components of the Zero Trust model
Plan for a Zero Trust security model in your organization
Examine Microsoft's strategy for Zero Trust networking
Adopt a Zero Trust approach
17 - Explore security solutions in Microsoft 365 Defender
Enhance your email security using Exchange Online Protection and Microsoft Defender for Office 365
Protect your organization's identities using Microsoft Defender for Identity
Protect your enterprise network against advanced threats using Microsoft Defender for Endpoint
Protect against cyber attacks using Microsoft 365 Threat Intelligence
Provide insight into suspicious activity using Microsoft Cloud App Security
Review the security reports in Microsoft 365 Defender
18 - Examine Microsoft Secure Score
Explore Microsoft Secure Score
Assess your security posture with Microsoft Secure Score
Improve your secure score
Track your Microsoft Secure Score history and meet your goals
19 - Examine Privileged Identity Management
Explore Privileged Identity Management in Microsoft Entra ID
Configure Privileged Identity Management
Audit Privileged Identity Management
Control privileged admin tasks using Privileged Access Management
20 - Examine Azure Identity Protection
Explore Azure Identity Protection
Enable the default protection policies in Azure Identity Protection
Explore the vulnerabilities and risk events detected by Azure Identity Protection
Plan your identity investigation
21 - Examine Exchange Online Protection
Examine the anti-malware pipeline
Detect messages with spam or malware using Zero-hour auto purge
Explore anti-spoofing protection provided by Exchange Online Protection
Explore other anti-spoofing protection
Examine outbound spam filtering
22 - Examine Microsoft Defender for Office 365
Climb the security ladder from EOP to Microsoft Defender for Office 365
Expand EOP protections by using Safe Attachments and Safe Links
Manage spoofed intelligence
Configure outbound spam filtering policies
Unblock users from sending email
23 - Manage Safe Attachments
Protect users from malicious attachments by using Safe Attachments
Create Safe Attachment policies using Microsoft Defender for Office 365
Create Safe Attachments policies using PowerShell
Modify an existing Safe Attachments policy
Create a transport rule to bypass a Safe Attachments policy
Examine the end-user experience with Safe Attachments
24 - Manage Safe Links
Protect users from malicious URLs by using Safe Links
Create Safe Links policies using Microsoft 365 Defender
Create Safe Links policies using PowerShell
Modify an existing Safe Links policy
Create a transport rule to bypass a Safe Links policy
Examine the end-user experience with Safe Links
25 - Explore threat intelligence in Microsoft 365 Defender
Explore Microsoft Intelligent Security Graph
Explore alert policies in Microsoft 365
Run automated investigations and responses
Explore threat hunting with Microsoft Threat Protection
Explore advanced threat hunting in Microsoft 365 Defender
Explore threat analytics in Microsoft 365
Identify threat issues using Microsoft Defender reports
26 - Implement app protection by using Microsoft Defender for Cloud Apps
Explore Microsoft Defender Cloud Apps
Deploy Microsoft Defender for Cloud Apps
Configure file policies in Microsoft Defender for Cloud Apps
Manage and respond to alerts in Microsoft Defender for Cloud Apps
Configure Cloud Discovery in Microsoft Defender for Cloud Apps
Troubleshoot Cloud Discovery in Microsoft Defender for Cloud Apps
27 - Implement endpoint protection by using Microsoft Defender for Endpoint
Explore Microsoft Defender for Endpoint
Configure Microsoft Defender for Endpoint in Microsoft Intune
Onboard devices in Microsoft Defender for Endpoint
Manage endpoint vulnerabilities with Microsoft Defender Vulnerability Management
Manage device discovery and vulnerability assessment
Reduce your threat and vulnerability exposure
28 - Implement threat protection by using Microsoft Defender for Office 365
Explore the Microsoft Defender for Office 365 protection stack
Investigate security attacks by using Threat Explorer
Identify cybersecurity issues by using Threat Trackers
Prepare for attacks with Attack simulation training
29 - Examine data governance solutions in Microsoft Purview
Explore data governance and compliance in Microsoft Purview
Protect sensitive data with Microsoft Purview Information Protection
Govern organizational data using Microsoft Purview Data Lifecycle Management
Minimize internal risks with Microsoft Purview Insider Risk Management
Explore Microsoft Purview eDiscovery solutions
30 - Explore archiving and records management in Microsoft 365
Explore archive mailboxes in Microsoft 365
Enable archive mailboxes in Microsoft 365
Explore Microsoft Purview Records Management
Implement Microsoft Purview Records Management
Restore deleted data in Exchange Online
Restore deleted data in SharePoint Online
31 - Explore retention in Microsoft 365
Explore retention by using retention policies and retention labels
Compare capabilities in retention policies and retention labels
Define the scope of a retention policy
Examine the principles of retention
Implement retention using retention policies, retention labels, and eDiscovery holds
Restrict retention changes by using Preservation Lock
32 - Explore Microsoft Purview Message Encryption
Examine Microsoft Purview Message Encryption
Configure Microsoft Purview Message Encryption
Define mail flow rules to encrypt email messages
Add organizational branding to encrypted email messages
Explore Microsoft Purview Advanced Message Encryption
33 - Explore compliance in Microsoft 365
Plan for security and compliance in Microsoft 365
Plan your beginning compliance tasks in Microsoft Purview
Manage your compliance requirements with Compliance Manager
Examine the Compliance Manager dashboard
Analyze the Microsoft Compliance score
34 - Implement Microsoft Purview Insider Risk Management
Explore insider risk management
Plan for insider risk management
Explore insider risk management policies
Create insider risk management policies
Investigate insider risk management activities and alerts
Explore insider risk management cases
35 - Implement Microsoft Purview Information Barriers
Explore Microsoft Purview Information Barriers
Configure information barriers in Microsoft Purview
Examine information barriers in Microsoft Teams
Examine information barriers in OneDrive
Examine information barriers in SharePoint
36 - Explore Microsoft Purview Data Loss Prevention
Examine Data Loss Prevention
Explore Endpoint data loss prevention
Examine DLP policies
View DLP policy results
Explore DLP reports
37 - Implement Microsoft Purview Data Loss Prevention
Plan to implement Microsoft Purview Data Loss Protection
Implement Microsoft Purview's default DLP policies
Design a custom DLP policy
Create a custom DLP policy from a template
Configure email notifications for DLP policies
Configure policy tips for DLP policies
38 - Implement data classification of sensitive information
Explore data classification
Implement data classification in Microsoft 365
Explore trainable classifiers
Create and retrain a trainable classifier
View sensitive data using Content explorer and Activity explorer
Detect sensitive information documents using Document Fingerprinting
39 - Explore sensitivity labels
Manage data protection using sensitivity labels
Explore what sensitivity labels can do
Determine a sensitivity label's scope
Apply sensitivity labels automatically
Explore sensitivity label policies
40 - Implement sensitivity labels
Plan your deployment strategy for sensitivity labels
Examine the requirements to create a sensitivity label
Create sensitivity labels
Publish sensitivity labels
Remove and delete sensitivity labels
Additional course details:
Nexus Humans MS-102T00: Microsoft 365 Administrator training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. 

This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts.

Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success.

While we feel this is the best course for the MS-102T00: Microsoft 365 Administrator course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you.

Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.


Nexus Human

Microsoft 365

Microsoft AZ-900

Microsoft AZ-104

Microsoft AZ-303

Microsoft AZ-700

MS-102T00 Microsoft 365 Administrator Essentials

<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

Bayfield Training

Financial Modelling & Analysis

Financial Modelling

Property Investment

Risk Management

Investment

Financial Risk Management

Professional Development

Investment Management

Continuous Professional Development (CPD)

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

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

<div id="course-pills-1">Duration<p>1 Days</p><p>6 CPD hours</p>This course is intended for<p>To ensure success, students will need to be familiar with using personal computers and should have experience using a keyboard and mouse. Students should also be comfortable working in the Windows environment and be able to manage information on their computers.</p>Overview<p>Upon successful completion of this course, you will be able to create and develop Excel worksheets and workbooks in order to work with and analyse the data that is critical to the success of your organisation.</p><p>This course is intended for those who wish to gain the foundational understanding of Excel that is necessary to create and work with electronic spreadsheets. Excel can help you organise, calculate, analyse, revise, update, and present your data.</p></div><div id="course-pills-2"><h4>Getting Started with Excel</h4><ul><li>Navigate the Excel User Interface</li><li>Use Excel Commands</li><li>Create and Save a Basic Workbook</li><li>Enter and Edit Cell Data</li><li>Fill Cells with Series of Data (AutoFill and Flash Fill)</li><li>Use Excel Help</li></ul><h4>Performing Calculations</h4><ul><li>Create Worksheet Formulas</li><li>Insert Functions and use Autocomplete</li><li>Reuse Formulas and Functions</li><li>Create an Absolute Reference</li></ul><h4>Modifying a Worksheet</h4><ul><li>Insert, Delete, and Adjust Cells, Columns, and Rows</li><li>Move and Copy Data between Cells</li><li>Search for and Replace Data</li><li>Use Spellcheck and Proofing</li></ul><h4>Formatting a Worksheet</h4><ul><li>Apply Text Formats</li><li>Apply Number Formats</li><li>Align Cell Contents</li><li>Apply and Copy Cell Styles</li><li>Apply Basic Conditional Formatting</li></ul><h4>Printing Workbooks</h4><ul><li>Preview and Print a Workbook</li><li>Controlling Page Layout</li><li>Adding Headers and Footers</li><li>Set Print Titles and Print Ranges</li></ul><h4>Managing Workbooks</h4><ul><li>Manage Worksheets</li><li>Insert and Delete Worksheets</li><li>Manage Workbook and Worksheet Views</li><li>Manage Workbook Properties</li></ul></div>

Duration
1 Days
6 CPD hours
This course is intended for
To ensure success, students will need to be familiar with using personal computers and should have experience using a keyboard and mouse. Students should also be comfortable working in the Windows environment and be able to manage information on their computers.
Overview
Upon successful completion of this course, you will be able to create and develop Excel worksheets and workbooks in order to work with and analyse the data that is critical to the success of your organisation.
This course is intended for those who wish to gain the foundational understanding of Excel that is necessary to create and work with electronic spreadsheets. Excel can help you organise, calculate, analyse, revise, update, and present your data.
Getting Started with Excel
Navigate the Excel User Interface
Use Excel Commands
Create and Save a Basic Workbook
Enter and Edit Cell Data
Fill Cells with Series of Data (AutoFill and Flash Fill)
Use Excel Help
Performing Calculations
Create Worksheet Formulas
Insert Functions and use Autocomplete
Reuse Formulas and Functions
Create an Absolute Reference
Modifying a Worksheet
Insert, Delete, and Adjust Cells, Columns, and Rows
Move and Copy Data between Cells
Search for and Replace Data
Use Spellcheck and Proofing
Formatting a Worksheet
Apply Text Formats
Apply Number Formats
Align Cell Contents
Apply and Copy Cell Styles
Apply Basic Conditional Formatting
Printing Workbooks
Preview and Print a Workbook
Controlling Page Layout
Adding Headers and Footers
Set Print Titles and Print Ranges
Managing Workbooks
Manage Worksheets
Insert and Delete Worksheets
Manage Workbook and Worksheet Views
Manage Workbook Properties

Excel Analytics

Spreadsheet

Excel - Excel Essentials and Formulas

<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.

Apex Learning

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><strong>24 Hour Flash Deal **25-in-1 </strong><strong>Microsoft Office Specialist Excel Certification </strong><strong>Mega Bundle**</strong></p><p><strong> </strong><strong>Microsoft Office Specialist Excel Certification </strong><strong>Enrolment Gifts  **FREE PDF Certificate**FREE PDF Transcript ** FREE Exam** FREE Student ID ** Lifetime Access **FREE Enrolment Letter **</strong></p><p>Take the initial steps toward a successful long-term career by studying the <strong>Microsoft Office Specialist Excel Certification</strong> package online with <strong>Studyhub </strong>through our online learning platform. The Microsoft Office Specialist Excel Certification bundle can help you improve your CV, wow potential employers, and differentiate yourself from the mass.</p><p>This <strong>Microsoft Office Specialist Excel Certification </strong>course provides complete 360-degree training on Microsoft Office Specialist Excel Certification. You'll get not one, not two, not three, but <strong>twenty-five </strong>Microsoft Office Specialist Excel Certification courses included in this course. Plus Studyhub's signature <strong>Forever Access</strong> is given as always, meaning these Microsoft Office Specialist Excel Certification courses are yours for as long as you want them once you enrol in this course</p><p><strong>This Microsoft Office Specialist Excel Certification Bundle consists the following career oriented courses:</strong></p><ul><li>Course 01: Microsoft Excel</li><li>Course 02: Microsoft Excel: Automated Dashboard Using Advanced Formula, VBA, Power Query</li><li>Course 03: Excel VBA/Macros Foundations</li><li>Course 04: Microsoft Excel: Master Power Query in 120 Minutes!</li><li>Course 05: Excel: Top 50 Microsoft Excel Formulas in 50 Minutes!</li><li>Course 06: Data Analysis in Excel</li><li>Course 07: Excel 2016 Advanced Formulas and Functions</li><li>Course 08: MS Word Essentials</li><li>Course 09: Copyediting &amp; Proofreading</li><li>Course 10: Microsoft PowerPoint</li><li>Course 11: Bookkeeping Tool : Google Sheets</li><li>Course 12: Data Analysis and Forecasting in Excel</li><li>Course 13: Excel Vlookup; Xlookup; Match and Index</li><li>Course 14: Excel Pivot Tables, Pivot Charts, Slicers, and Timelines</li><li>Course 15: PowerBI Formulas</li><li>Course 16: Learn Microsoft Word, PowerPoint &amp; Outlook In 90 Minutes!</li><li>Course 17: Microsoft Power BI 2021 Complete Course</li><li>Course 18: Microsoft Access Tables and Queries</li><li>Course 19: Microsoft Access Databases Forms and Reports</li><li>Course 20: Microsoft Teams</li><li>Course 21: Master the Basics of Microsoft Power Apps</li><li>Course 22: Learn the Fundamentals of Microsoft SharePoint</li><li>Course 23: Learn the Basics of Microsoft Visio in Only 30 minutes!</li><li>Course 24: Learn the Basics of Microsoft Forms in Only 30 minutes!</li><li>Course 25: Master the Basics of Microsoft Power Automate</li></ul> <p>The <strong>Microsoft Office Specialist Excel Certification </strong>course has been prepared by focusing largely on Microsoft Office Specialist Excel Certification career readiness. It has been designed by our Microsoft Office Specialist Excel Certification specialists in a manner that you will be likely to find yourself head and shoulders above the others. For better learning, one to one assistance will also be provided if it's required by any learners.</p><p>The Microsoft Office Specialist Excel Certification Bundle is one of the most prestigious training offered at StudyHub and is highly valued by employers for good reason. This Microsoft Office Specialist Excel Certification bundle course has been created with <strong>twenty-five </strong>premium courses to provide our learners with the best learning experience possible to increase their understanding of their chosen field.</p><p>This Microsoft Office Specialist Excel Certification Course, like every one of Study Hub's courses, is meticulously developed and well researched. Every one of the topics is divided into Microsoft Office Specialist Excel Certification Elementary modules, allowing our students to grasp each lesson quickly.</p><p>The Microsoft Office Specialist Excel Certification course is self-paced and can be taken from the comfort of your home, office, or on the go! With our Student ID card you will get discounts on things like music, food, travel and clothes etc.</p><p><strong>In this exclusive </strong><strong>Microsoft Office Specialist Excel Certification </strong><strong>bundle, you really hit the jackpot. Here's what you get:</strong></p><ul><li>Step by step Microsoft Office Specialist Excel Certification lessons</li><li>One to one assistance from Microsoft Office Specialist Excel Certification professionals if you need it</li><li>Innovative exams to test your knowledge after the Microsoft Office Specialist Excel Certification course</li><li>24/7 customer support should you encounter any hiccups</li><li>Top-class learning portal</li><li>Unlimited lifetime access to all twenty-five Microsoft Office Specialist Excel Certification courses</li><li>Digital Certificate, Transcript and student ID are all included in the price</li><li>PDF certificate immediately after passing</li><li>Original copies of your Microsoft Office Specialist Excel Certification certificate and transcript on the next working day</li><li>Easily learn the Microsoft Office Specialist Excel Certification skills and knowledge you want from the comfort of your home</li></ul> <h2>
        
        <div>CPD</div>
    </h2>

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

                        <div id="who_is_this_course_for">
                            <p>This <strong>Microsoft Office Specialist Excel Certification </strong>training is suitable for -</p><ul><li>Students</li><li>Recent graduates</li><li>Job Seekers</li><li>Individuals who are already employed in the relevant sectors and wish to enhance their knowledge and expertise in Microsoft Office Specialist Excel Certification</li></ul><p>Microsoft Office Skills is a pathway of the following career opportunities:</p><ul><li>Microsoft Office Specialist (MOS) Expert</li><li>Microsoft Office Specialist (MOS) Master</li><li>Microsoft Office Specialist (MOS)</li><li>Microsoft Specialist certification in Office 365</li><li>MS Office User</li><li>Microsoft Certified Specialist Developing Microsoft Azure Solution</li><li>Microsoft Certified Technology Specialist (MCTS)</li><li>Microsoft Certified IT Professional (MCITP)</li></ul>
                        </div> <h2>
        
        <div>Requirements</div>
    </h2>

                        <div id="requirements">
                            <p>To participate in this <strong>Microsoft Office Specialist Excel Certification </strong>course, all you need is -</p><ul><li>A smart device</li><li>A secure internet connection</li><li>And a keen interest in Microsoft Office Specialist Excel Certification</li></ul>
                        </div> <h2>
        
        <div>Career path</div>
    </h2>

                        <div id="career_path">
                            <p>You will be able to kickstart your <strong>Microsoft Office Specialist Excel Certification </strong>career because this course includes various courses as a bonus. This Microsoft Office Specialist Excel Certification is an excellent opportunity for you to learn multiple skills from the convenience of your own home and explore Microsoft Office Specialist Excel Certification career opportunities.</p>
                        </div> <h2>
        
        <div>Certificates</div>
    </h2>

                        <div id="optional_extras">
                                    <h4>CPD Accredited Certificate</h4>
        <p>
            Digital certificate -
            Included
        </p>
            <div><ul><li>CPD Accredited e-Certificate - Free</li><li>CPD Accredited Hardcopy Certificate - Free</li><li>Enrolment Letter - Free</li><li>Student ID Card - Free</li></ul></div>

                        </div>

24 Hour Flash Deal **25-in-1 Microsoft Office Specialist Excel Certification Mega Bundle**
 Microsoft Office Specialist Excel Certification Enrolment Gifts **FREE PDF Certificate**FREE PDF Transcript ** FREE Exam** FREE Student ID ** Lifetime Access **FREE Enrolment Letter **
Take the initial steps toward a successful long-term career by studying the Microsoft Office Specialist Excel Certification package online with Studyhub through our online learning platform. The Microsoft Office Specialist Excel Certification bundle can help you improve your CV, wow potential employers, and differentiate yourself from the mass.
This Microsoft Office Specialist Excel Certification course provides complete 360-degree training on Microsoft Office Specialist Excel Certification. You'll get not one, not two, not three, but twenty-five Microsoft Office Specialist Excel Certification courses included in this course. Plus Studyhub's signature Forever Access is given as always, meaning these Microsoft Office Specialist Excel Certification courses are yours for as long as you want them once you enrol in this course
This Microsoft Office Specialist Excel Certification Bundle consists the following career oriented courses:
Course 01: Microsoft Excel
Course 02: Microsoft Excel: Automated Dashboard Using Advanced Formula, VBA, Power Query
Course 03: Excel VBA/Macros Foundations
Course 04: Microsoft Excel: Master Power Query in 120 Minutes!
Course 05: Excel: Top 50 Microsoft Excel Formulas in 50 Minutes!
Course 06: Data Analysis in Excel
Course 07: Excel 2016 Advanced Formulas and Functions
Course 08: MS Word Essentials
Course 09: Copyediting & Proofreading
Course 10: Microsoft PowerPoint
Course 11: Bookkeeping Tool : Google Sheets
Course 12: Data Analysis and Forecasting in Excel
Course 13: Excel Vlookup; Xlookup; Match and Index
Course 14: Excel Pivot Tables, Pivot Charts, Slicers, and Timelines
Course 15: PowerBI Formulas
Course 16: Learn Microsoft Word, PowerPoint & Outlook In 90 Minutes!
Course 17: Microsoft Power BI 2021 Complete Course
Course 18: Microsoft Access Tables and Queries
Course 19: Microsoft Access Databases Forms and Reports
Course 20: Microsoft Teams
Course 21: Master the Basics of Microsoft Power Apps
Course 22: Learn the Fundamentals of Microsoft SharePoint
Course 23: Learn the Basics of Microsoft Visio in Only 30 minutes!
Course 24: Learn the Basics of Microsoft Forms in Only 30 minutes!
Course 25: Master the Basics of Microsoft Power Automate
The Microsoft Office Specialist Excel Certification course has been prepared by focusing largely on Microsoft Office Specialist Excel Certification career readiness. It has been designed by our Microsoft Office Specialist Excel Certification specialists in a manner that you will be likely to find yourself head and shoulders above the others. For better learning, one to one assistance will also be provided if it's required by any learners.
The Microsoft Office Specialist Excel Certification Bundle is one of the most prestigious training offered at StudyHub and is highly valued by employers for good reason. This Microsoft Office Specialist Excel Certification bundle course has been created with twenty-five premium courses to provide our learners with the best learning experience possible to increase their understanding of their chosen field.
This Microsoft Office Specialist Excel Certification Course, like every one of Study Hub's courses, is meticulously developed and well researched. Every one of the topics is divided into Microsoft Office Specialist Excel Certification Elementary modules, allowing our students to grasp each lesson quickly.
The Microsoft Office Specialist Excel Certification course is self-paced and can be taken from the comfort of your home, office, or on the go! With our Student ID card you will get discounts on things like music, food, travel and clothes etc.
In this exclusive Microsoft Office Specialist Excel Certification bundle, you really hit the jackpot. Here's what you get:
Step by step Microsoft Office Specialist Excel Certification lessons
One to one assistance from Microsoft Office Specialist Excel Certification professionals if you need it
Innovative exams to test your knowledge after the Microsoft Office Specialist Excel Certification course
24/7 customer support should you encounter any hiccups
Top-class learning portal
Unlimited lifetime access to all twenty-five Microsoft Office Specialist Excel Certification courses
Digital Certificate, Transcript and student ID are all included in the price
PDF certificate immediately after passing
Original copies of your Microsoft Office Specialist Excel Certification certificate and transcript on the next working day
Easily learn the Microsoft Office Specialist Excel Certification skills and knowledge you want from the comfort of your home
 CPD 
250 CPD hours / points  Accredited by CPD Quality Standards
 Who is this course for? 
This Microsoft Office Specialist Excel Certification training is suitable for -
Students
Recent graduates
Job Seekers
Individuals who are already employed in the relevant sectors and wish to enhance their knowledge and expertise in Microsoft Office Specialist Excel Certification
Microsoft Office Skills is a pathway of the following career opportunities:
Microsoft Office Specialist (MOS) Expert
Microsoft Office Specialist (MOS) Master
Microsoft Office Specialist (MOS)
Microsoft Specialist certification in Office 365
MS Office User
Microsoft Certified Specialist Developing Microsoft Azure Solution
Microsoft Certified Technology Specialist (MCTS)
Microsoft Certified IT Professional (MCITP)
 Requirements 
To participate in this Microsoft Office Specialist Excel Certification course, all you need is -
A smart device
A secure internet connection
And a keen interest in Microsoft Office Specialist Excel Certification
 Career path 
You will be able to kickstart your Microsoft Office Specialist Excel Certification career because this course includes various courses as a bonus. This Microsoft Office Specialist Excel Certification is an excellent opportunity for you to learn multiple skills from the convenience of your own home and explore Microsoft Office Specialist Excel Certification career opportunities.
 Certificates 
CPD Accredited Certificate
 Digital certificate - Included 
CPD Accredited e-Certificate - Free
CPD Accredited Hardcopy Certificate - Free
Enrolment Letter - Free
Student ID Card - Free

Studyhub UK

Microsoft MS-700

Microsoft Office Specialist Excel Certification

<p><strong>Exclusive Deal - Get QLS Endorsed Microsoft Office Certificate Worth £100 absolutely Free with </strong><strong>11 </strong><strong>(PDF + Hard Copy) Certificate (CPD) for each course. Hurry Up, Offer Ends Soon!</strong></p><p>Launch the dynamic career you've always wanted! Take this high-quality <strong> Microsoft Office </strong>Bundle training worth to articulate your innovative goals and develop a simple approach for attaining them.</p><p>Millions of people worldwide use Microsoft Office for personal and professional use. It is the world's most widely used office suite and is available in various versions to suit different needs. Microsoft Office is essential for anyone who needs to create documents, manage data, and collaborate with others.</p><p><strong>The career-focused courses in this Microsoft Office bundle are as follows:</strong></p><ul><li><strong>Course 01: </strong>Microsoft Office Bundle at QLS Level 7</li><li><strong>Course 02: </strong>Data Analysis In Excel</li><li><strong>Course 03: </strong>Financial Modelling Using Excel</li><li><strong>Course 04: </strong>Microsoft Access Tables and Queries</li><li><strong>Course 05: </strong>Excel: Top 50 Microsoft Excel Formulas in 50 Minutes!</li><li><strong>Course 06: </strong>Touch Typing Essentials</li><li><strong>Course 07: </strong>Office Admin &amp; Receptionist - Level 7</li><li><strong>Course 08: </strong>Document Control</li><li><strong>Course 09: </strong>Functional Skills - IT</li><li><strong>Course 10: </strong>Work Area Organisation for Increased Office Productivity</li><li><strong>Course 11: </strong>Time Management</li></ul><p>Whether you're an aspirant looking to start your dream career, a professional looking to branch out, or somebody in between   this <strong>Microsoft Office</strong>, QLS Endorsed Course will get you sorted. The rudimentary knowledge in this course will add tremendous value and enable you to establish the meaningful career you've always craved.</p><p><strong>Why Choose Imperial Academy?</strong></p><ul><li>Fully online Training.</li><li>QLS Endorsed &amp; CPD Accredited Training.</li><li>No time limits. Study at your own pace.</li><li>Expert Instructors.</li><li>Audio Visual Training.</li><li>Further reading where necessary.</li><li>Up-to-date curriculum and effective guidelines.</li></ul><p> Enrol in our '<strong>Microsoft Office</strong>' today and Start Learning </p><p>This <strong>Microsoft Office </strong>bundle training will help you become an expert in a relevant sector. Our world-class tutors will help you with every query throughout your learning journey and assist you in mastering <strong>Microsoft Office</strong>. So, add this course to your basket   harness the coveted skills and open the door to your next breakthrough!</p><h2>
        
        <div>CPD</div>
    </h2>

                        <div id="cpd">
                            <div>
                                <div>
                                    <div>
                                        145 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 <strong>Microsoft Office </strong>course will be a great source of knowledge for you to improve your existing skills and take them to the next level.</p><p><strong>Disclaimer</strong></p><p>This course has been endorsed by the Quality Licence Scheme for its high-quality, non-regulated provision and training programmes. This course is not regulated by Ofqual and is not an accredited qualification. One Education will be able to advise you on any further recognition. For further information please visit the Learner FAQs on the Quality Licence Scheme website.</p><p>Imperial Academy is an approved reselling partner for Quality Licence Scheme courses under One Education.</p>
                        </div><h2>
        
        <div>Requirements</div>
    </h2>

                        <div id="requirements">
                            <p>Anyone can enrol in this Microsoft Office course.</p>
                        </div><h2>
        
        <div>Career path</div>
    </h2>

                        <div id="career_path">
                            <p>After completing this <strong>Microsoft Office </strong>Course, you are to start your career or begin the next phase of your career in this field.</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><strong>Quality Licence Scheme Endorsed Certificate of Achievement</strong></p><p>Learners will get an endorsed certificate of achievement (included with the course) directly at their doorstep after successfully completing the package! It should be noted that <strong>international students must pay a £10 shipping cost.</strong></p><p>For ordering additional QLS Certificates, <strong>other than Microsoft Office Bundle course</strong>, the fees will be following with £10 for international shipping only</p><ul><li>Level 1 - £109</li><li>Level 2 - £115</li><li>Level 3 - £119</li><li>Level 4 - £125</li><li>Level 5 - £129</li><li>Level 6 - £135</li><li>Level 7 - £139</li></ul><p><strong>CPD Accredited Certification</strong></p><p>Upon successfully completing each of the courses in this package, you will be qualified for CPD Accredited Certificates. Certification is available -</p><ul><li>PDF completely free of charge</li><li>Hard copy for £3.99 each</li></ul><p>It should also be noted that <strong>international students must pay a £10 shipping cost.</strong></p> </div>

                        </div>

Exclusive Deal - Get QLS Endorsed Microsoft Office Certificate Worth £100 absolutely Free with 11 (PDF + Hard Copy) Certificate (CPD) for each course. Hurry Up, Offer Ends Soon!
Launch the dynamic career you've always wanted! Take this high-quality  Microsoft Office Bundle training worth to articulate your innovative goals and develop a simple approach for attaining them.
Millions of people worldwide use Microsoft Office for personal and professional use. It is the world's most widely used office suite and is available in various versions to suit different needs. Microsoft Office is essential for anyone who needs to create documents, manage data, and collaborate with others.
The career-focused courses in this Microsoft Office bundle are as follows:
Course 01: Microsoft Office Bundle at QLS Level 7
Course 02: Data Analysis In Excel
Course 03: Financial Modelling Using Excel
Course 04: Microsoft Access Tables and Queries
Course 05: Excel: Top 50 Microsoft Excel Formulas in 50 Minutes!
Course 06: Touch Typing Essentials
Course 07: Office Admin & Receptionist - Level 7
Course 08: Document Control
Course 09: Functional Skills - IT
Course 10: Work Area Organisation for Increased Office Productivity
Course 11: Time Management
Whether you're an aspirant looking to start your dream career, a professional looking to branch out, or somebody in between this Microsoft Office, QLS Endorsed Course will get you sorted. The rudimentary knowledge in this course will add tremendous value and enable you to establish the meaningful career you've always craved.
Why Choose Imperial Academy?
Fully online Training.
QLS Endorsed & CPD Accredited Training.
No time limits. Study at your own pace.
Expert Instructors.
Audio Visual Training.
Further reading where necessary.
Up-to-date curriculum and effective guidelines.
 Enrol in our 'Microsoft Office' today and Start Learning 
This Microsoft Office bundle training will help you become an expert in a relevant sector. Our world-class tutors will help you with every query throughout your learning journey and assist you in mastering Microsoft Office. So, add this course to your basket harness the coveted skills and open the door to your next breakthrough!
 CPD 
145 CPD hours / points  Accredited by CPD Quality Standards
 Who is this course for? 
This Microsoft Office course will be a great source of knowledge for you to improve your existing skills and take them to the next level.
Disclaimer
This course has been endorsed by the Quality Licence Scheme for its high-quality, non-regulated provision and training programmes. This course is not regulated by Ofqual and is not an accredited qualification. One Education will be able to advise you on any further recognition. For further information please visit the Learner FAQs on the Quality Licence Scheme website.
Imperial Academy is an approved reselling partner for Quality Licence Scheme courses under One Education.
 Requirements 
Anyone can enrol in this Microsoft Office course.
 Career path 
After completing this Microsoft Office Course, you are to start your career or begin the next phase of your career in this field.
 Certificates 
Certificate of completion
 Digital certificate - Included 
Certificate of completion
 Hard copy certificate - Included 
Quality Licence Scheme Endorsed Certificate of Achievement
Learners will get an endorsed certificate of achievement (included with the course) directly at their doorstep after successfully completing the package! It should be noted that international students must pay a £10 shipping cost.
For ordering additional QLS Certificates, other than Microsoft Office Bundle course, the fees will be following with £10 for international shipping only
Level 1 - £109
Level 2 - £115
Level 3 - £119
Level 4 - £125
Level 5 - £129
Level 6 - £135
Level 7 - £139
CPD Accredited Certification
Upon successfully completing each of the courses in this package, you will be qualified for CPD Accredited Certificates. Certification is available -
PDF completely free of charge
Hard copy for £3.99 each
It should also be noted that international students must pay a £10 shipping cost.

Imperial Academy

Level 7 Diploma(FREE QLS Endorsed Certificate)| 11-in-1 Bundle | Free Certificates | CPD Accredited | Lifetime Access

Microsoft Office QLS Diploma

<p>The job market in the UK has been through a significant amount of turbulence over the last year, mainly due to the pandemic and recent war. As a result, finding a suitable niche in this highly competitive job market has become more challenging.</p><p>So to cover up all your limitations and uproot all the hurdles to a stable and dignified career, we are here with a package you can't refuse! This time Apex Learning will show you the pathway to a successful career through the most well-researched and expertly made Microsoft Office bundle.</p><p>Our Microsoft Office package, with the latest digital study materials and innovative learning method, will give you in-depth knowledge of this domain. You will dive deep into the core basics with our step-by-step lessons and proficient tutor guidance. You will be able to hone your knowledge from beginner to advanced level as there will be frequent tests, fun quizzes and practical analysis of the topics. Moreover, you will keep yourself up to date with the current situation in the area of your interest.</p><p>As Microsoft Office, there are endless opportunities for you if you have the right knowledge and skill. Therefore, to make your career journey a successful one, we designed this bundle as a one-stop solution for you.</p><p><strong>This 20-in 1 Ultimate Microsoft Office bundle consists of the following Courses:</strong></p><ul><li>Course 01: MS Word Diploma</li><li>Course 02: Proofreading &amp; Copyediting</li><li>Course 03: PowerPoint Diploma</li><li>Course 04: Microsoft Excel Level 3</li><li>Course 05: New Functions in Microsoft Excel 2021</li><li>Course 06: Microsoft Excel: Automated Dashboard Using Advanced Formula, VBA, Power Query</li><li>Course 07: Microsoft Excel: Excel Sheet Comparison with VBA</li><li>Course 08: Microsoft Excel: Master Power Query in 120 Minutes!</li><li>Course 09: Excel: Top 50 Microsoft Excel Formulas in 50 Minutes!</li><li>Course 10: Excel Pivot Tables</li><li>Course 11: Data Analysis in Microsoft Excel Complete Training</li><li>Course 12: Excel Must know Formulas and Functions</li><li>Course 13: Excel spreadsheet for Beginner</li><li>Course 14: Excel Data Analysis</li><li>Course 15: Excel Vlookup, Xlookup, Match and Index</li><li>Course 16: Excel Pivot Tables, Pivot Charts, Slicers, and Timelines</li><li>Course 17: PowerBI Formulas</li><li>Course 18: Outlook Tips and tricks</li><li>Course 19: Excel PowerQuery and PowerPivot</li><li>Course 20: Complete Microsoft Power BI 2021</li></ul><p><strong>Additionally, you will get 5 other career-guided courses in this Microsoft Office bundle:</strong></p><ul><li>Course 01: Career Development Plan Fundamentals</li><li>Course 02: CV Writing and Job Searching</li><li>Course 03: Interview Skills: Ace the Interview</li><li>Course 04: Video Job Interview for Job Seekers</li><li>Course 05: Create a Professional LinkedIn Profile</li></ul><p><strong><em>So, stop scrolling down and procure the skills and aptitude with Apex Learning to outshine all your peers by enrolling in this </em></strong><strong>Microsoft Office<em> bundle</em>.</strong></p><p><strong>Learning Outcomes of Microsoft Office bundle </strong></p><p>This career-oriented bundle will help you to</p><ul><li>Gain the ability to excel in the role of Microsoft Office</li><li>Know your responsibilities as Microsoft Office and convey your experience to others</li><li>Gain excellent interpersonal and communication skills</li><li>Know the pros and cons of working as Microsoft Office</li><li>Adhere to the regulations around this area</li><li>Gain time and risk management skills to ensure efficiency</li><li>Manipulate technological advancement to become more effective</li><li>Maintain moral standards and set an example for your peers</li></ul><h2>
        
        <div>CPD</div>
    </h2>

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

                        <div id="who_is_this_course_for">
                            <p>Anyone from any background can enrol in this Microsoft Office bundle.</p>
                        </div><h2>
        
        <div>Requirements</div>
    </h2>

                        <div id="requirements">
                            <p>This Microsoft Office 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>
        <h4>Certificate of completion</h4>
        <p>
            Hard copy certificate -
            Included
        </p>
            <div> <p>You will get the Hard Copy certificate for the title course (<strong>MS Word Diploma</strong>) 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>

The job market in the UK has been through a significant amount of turbulence over the last year, mainly due to the pandemic and recent war. As a result, finding a suitable niche in this highly competitive job market has become more challenging.
So to cover up all your limitations and uproot all the hurdles to a stable and dignified career, we are here with a package you can't refuse! This time Apex Learning will show you the pathway to a successful career through the most well-researched and expertly made Microsoft Office bundle.
Our Microsoft Office package, with the latest digital study materials and innovative learning method, will give you in-depth knowledge of this domain. You will dive deep into the core basics with our step-by-step lessons and proficient tutor guidance. You will be able to hone your knowledge from beginner to advanced level as there will be frequent tests, fun quizzes and practical analysis of the topics. Moreover, you will keep yourself up to date with the current situation in the area of your interest.
As Microsoft Office, there are endless opportunities for you if you have the right knowledge and skill. Therefore, to make your career journey a successful one, we designed this bundle as a one-stop solution for you.
This 20-in 1 Ultimate Microsoft Office bundle consists of the following 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
Course 15: 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
Additionally, you will get 5 other career-guided courses in this Microsoft Office bundle:
Course 01: Career Development Plan Fundamentals
Course 02: CV Writing and Job Searching
Course 03: Interview Skills: Ace the Interview
Course 04: Video Job Interview for Job Seekers
Course 05: Create a Professional LinkedIn Profile
So, stop scrolling down and procure the skills and aptitude with Apex Learning to outshine all your peers by enrolling in this Microsoft Office bundle.
Learning Outcomes of Microsoft Office bundle 
This career-oriented bundle will help you to
Gain the ability to excel in the role of Microsoft Office
Know your responsibilities as Microsoft Office and convey your experience to others
Gain excellent interpersonal and communication skills
Know the pros and cons of working as Microsoft Office
Adhere to the regulations around this area
Gain time and risk management skills to ensure efficiency
Manipulate technological advancement to become more effective
Maintain moral standards and set an example for your peers
 CPD 
250 CPD hours / points  Accredited by CPD Quality Standards
 Who is this course for? 
Anyone from any background can enrol in this Microsoft Office bundle.
 Requirements 
This Microsoft Office course has been designed to be fully compatible with tablets and smartphones.
 Career path 
Having this expertise will increase the value of your CV and open you up to multiple job sectors.
 Certificates 
Certificate of completion
 Digital certificate - Included 
Certificate of completion
 Hard copy certificate - Included 
You will get the Hard Copy certificate for the title course (MS Word Diploma) absolutely Free! Other Hard Copy certificates are available for £10 each. 
Please Note: The delivery charge inside the UK is £3.99, and the international students must pay a £9.99 shipping cost.

Microsoft Office for Office Administrator

<p><strong>Unleash the Power of Data with the Microsoft Office Specialist Excel Certification for Data Analysis Bundle!</strong></p><p>In today's data-driven world, employers are increasingly seeking professionals with strong Microsoft Office skills. According to a recent survey by the UK IT Institute, <strong>85% of employers</strong> believe that Microsoft Office skills are essential for success in the workplace. From deciphering complex spreadsheets to crafting automated dashboards, this Microsoft Office Specialist Excel Certification bundle is your voyage into the heart of data analytics, guided by the expertise of Microsoft Office.</p><p><strong>This Microsoft Office Specialist Excel Certification for Data Analysis (Data Analytics) Bundle Contains </strong><strong>18</strong><strong> of Our Premium Courses for One Discounted Price:</strong></p><ul><li><strong> Course 01: </strong>Diploma in Complete Excel Course for All at QLS Level 5<strong><br /></strong></li><li><strong> Course 02: </strong>Diploma in Microsoft Access Power Pack &amp; Workbooks at QLS Level 5<strong><br /></strong></li><li><strong> Course 03: </strong>Complete Microsoft Word<strong><br /></strong></li><li><strong> Course 04: </strong>Microsoft Excel Complete Course<strong><br /></strong></li><li><strong> Course 05: </strong>Microsoft Powerpoint<strong><br /></strong></li><li><strong> Course 06: </strong>The Ultimate Microsoft Teams Complete Training Bundle (2020)<strong><br /></strong></li><li><strong> Course 07: </strong>Microsoft Access Power Pack &amp; Workbooks<strong><br /></strong></li><li><strong> Course 08: </strong>Microsoft Excel Training: Depriciation Accounting<strong><br /></strong></li><li><strong> Course 09: </strong>Microsoft Excel: Automated Dashboard Using Advanced Formula, VBA, Power Query<strong><br /></strong></li><li><strong> Course 10: </strong>Ultimate Microsoft Excel For Business Bootcamp<strong><br /></strong></li><li><strong> Course 11: </strong>Touch Typing Masterclass<strong><br /></strong></li><li><strong> Course 12: </strong>Data Entry Administrator Training<strong><br /></strong></li><li><strong> Course 13: </strong>Excel Data Analysis<strong><br /></strong></li><li><strong> Course 14: </strong>SQL Masterclass: SQL For Data Analytics<strong><br /></strong></li><li><strong> Course 15: </strong>Understanding Data Protection and Data Security<strong><br /></strong></li><li><strong> Course 16: </strong>Information Management<strong><br /></strong></li><li><strong> Course 17: </strong>Craft Excel Pivot Tables for Data Reporting<strong><br /></strong></li><li><strong> Course 18: </strong>Business Data Analysis</li></ul><p>Whether you're looking to start a new career in data analysis or advance your current position, this Microsoft Office Specialist Excel Certification for Data Analysis bundle will give you the skills and knowledge you need to succeed.</p><p><strong>Learning Outcomes of Microsoft Office Specialist Excel Certification for Data Analysis Bundle</strong></p><ul><li>Attain QLS Level 5 Diploma in Complete Excel Course, becoming an expert.</li><li>Master Microsoft Access Power Pack &amp; Workbooks at QLS Level 5.</li><li>Excel in Microsoft Word, Excel, Powerpoint, and Teams.</li><li>Unlock automated insights with Advanced Formula, VBA, and Power Query.</li><li>Dive deep into Data Entry, Typing, and Depreciation Accounting.</li><li>Conquer SQL for potent Data Analysis.</li><li>Ensure data security through Understanding Data Protection.</li><li>Craft compelling reports with Excel Pivot Tables.</li></ul><p><strong>Why Choose Our Microsoft Office Specialist Excel Certification for Data Analysis Bundle?</strong></p><ul><li>FREE Microsoft Office Specialist Excel Certification for Data Analysis certificate accredited</li><li>Get a free student ID card with Microsoft Office Specialist Excel Certification for Data Analysis Training</li><li>Get instant access to this Microsoft Office Specialist Excel Certification for Data Analysis course.</li><li>Learn Microsoft Office Specialist Excel Certification for Data Analysis from anywhere in the world</li><li>The Microsoft Office Specialist Excel Certification for Data Analysis is affordable and simple to understand</li><li>The Microsoft Office Specialist Excel Certification for Data Analysis is an entirely online, interactive lesson with voiceover audio</li><li>Lifetime access to the Microsoft Office Specialist Excel Certification for Data Analysis course materials</li><li>The Microsoft Office Specialist Excel Certification for Data Analysis comes with 24/7 tutor support</li></ul><p>So enrol now in this Microsoft Office Specialist Excel Certification for Data Analysis Today to advance your career!</p> <p>Embark on a Symphony of Insight: The Microsoft Office Specialist Excel Certification for Data Analysis Bundle</p><p>Within the tapestry of digital landscapes, where numbers whisper secrets and information orchestrates the dance of decision-making, the Microsoft Office Specialist Excel Certification for Data Analysis (Data Analytics) bundle emerges as a guiding star. With the synergy of Microsoft Office expertise, the finesse of Data Analysis acumen, and the precision of Microsoft Excel, this collection of 20 courses unfolds a narrative of empowerment. From deciphering the enigma of data to crafting narratives that chart success, every module resonates with the harmonious blend of skill and innovation.</p><p>Discover a world where Microsoft Office becomes a conduit of artistry, Data Analysis unfurls like a story, and Microsoft Excel is the brush that paints insights. Enroll now and let the journey begin - where the symphony of knowledge marries technology to compose a future enriched by understanding, proficiency, and foresight.</p> <h2>
        
        <div>CPD</div>
    </h2>

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

                        <div id="who_is_this_course_for">
                            <p>This Microsoft Office Specialist Excel Certification for Data Analysis Bundle is ideal for:</p><ul><li>Aspiring data analysts and professionals eager for Excel excellence.</li><li>Business personnel seeking efficient data management.</li><li>Those aiming to thrive in roles demanding data-centric skills</li></ul>
                        </div> <h2>
        
        <div>Requirements</div>
    </h2>

                        <div id="requirements">
                            <p>You will not need any prior background or expertise in this Microsoft Office Specialist Excel Certification for Data Analysis Bundle.</p>
                        </div> <h2>
        
        <div>Career path</div>
    </h2>

                        <div id="career_path">
                            <p>This Microsoft Office Specialist Excel Certification for Data Analysis bundle will allow you to kickstart or take your career to the next stage in the related sector such as:</p><ul><li>Data Analyst: £25,000 - £40,000</li><li>Business Analyst: £28,000 - £45,000</li><li>Information Manager: £30,000 - £50,000</li><li>Financial Analyst: £26,000 - £42,000</li><li>Database Manager: £32,000 - £55,000</li></ul>
                        </div> <h2>
        
        <div>Certificates</div>
    </h2>

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

                        </div>

Unleash the Power of Data with the Microsoft Office Specialist Excel Certification for Data Analysis Bundle!
In today's data-driven world, employers are increasingly seeking professionals with strong Microsoft Office skills. According to a recent survey by the UK IT Institute, 85% of employers believe that Microsoft Office skills are essential for success in the workplace. From deciphering complex spreadsheets to crafting automated dashboards, this Microsoft Office Specialist Excel Certification bundle is your voyage into the heart of data analytics, guided by the expertise of Microsoft Office.
This Microsoft Office Specialist Excel Certification for Data Analysis (Data Analytics) Bundle Contains 18 of Our Premium Courses for One Discounted Price:
Course 01: Diploma in Complete Excel Course for All at QLS Level 5
Course 02: Diploma in Microsoft Access Power Pack & Workbooks at QLS Level 5
Course 03: Complete Microsoft Word
Course 04: Microsoft Excel Complete Course
Course 05: Microsoft Powerpoint
Course 06: The Ultimate Microsoft Teams Complete Training Bundle (2020)
Course 07: Microsoft Access Power Pack & Workbooks
Course 08: Microsoft Excel Training: Depriciation Accounting
Course 09: Microsoft Excel: Automated Dashboard Using Advanced Formula, VBA, Power Query
Course 10: Ultimate Microsoft Excel For Business Bootcamp
Course 11: Touch Typing Masterclass
Course 12: Data Entry Administrator Training
Course 13: Excel Data Analysis
Course 14: SQL Masterclass: SQL For Data Analytics
Course 15: Understanding Data Protection and Data Security
Course 16: Information Management
Course 17: Craft Excel Pivot Tables for Data Reporting
Course 18: Business Data Analysis
Whether you're looking to start a new career in data analysis or advance your current position, this Microsoft Office Specialist Excel Certification for Data Analysis bundle will give you the skills and knowledge you need to succeed.
Learning Outcomes of Microsoft Office Specialist Excel Certification for Data Analysis Bundle
Attain QLS Level 5 Diploma in Complete Excel Course, becoming an expert.
Master Microsoft Access Power Pack & Workbooks at QLS Level 5.
Excel in Microsoft Word, Excel, Powerpoint, and Teams.
Unlock automated insights with Advanced Formula, VBA, and Power Query.
Dive deep into Data Entry, Typing, and Depreciation Accounting.
Conquer SQL for potent Data Analysis.
Ensure data security through Understanding Data Protection.
Craft compelling reports with Excel Pivot Tables.
Why Choose Our Microsoft Office Specialist Excel Certification for Data Analysis Bundle?
FREE Microsoft Office Specialist Excel Certification for Data Analysis certificate accredited
Get a free student ID card with Microsoft Office Specialist Excel Certification for Data Analysis Training
Get instant access to this Microsoft Office Specialist Excel Certification for Data Analysis course.
Learn Microsoft Office Specialist Excel Certification for Data Analysis from anywhere in the world
The Microsoft Office Specialist Excel Certification for Data Analysis is affordable and simple to understand
The Microsoft Office Specialist Excel Certification for Data Analysis is an entirely online, interactive lesson with voiceover audio
Lifetime access to the Microsoft Office Specialist Excel Certification for Data Analysis course materials
The Microsoft Office Specialist Excel Certification for Data Analysis comes with 24/7 tutor support
So enrol now in this Microsoft Office Specialist Excel Certification for Data Analysis Today to advance your career!
Embark on a Symphony of Insight: The Microsoft Office Specialist Excel Certification for Data Analysis Bundle
Within the tapestry of digital landscapes, where numbers whisper secrets and information orchestrates the dance of decision-making, the Microsoft Office Specialist Excel Certification for Data Analysis (Data Analytics) bundle emerges as a guiding star. With the synergy of Microsoft Office expertise, the finesse of Data Analysis acumen, and the precision of Microsoft Excel, this collection of 20 courses unfolds a narrative of empowerment. From deciphering the enigma of data to crafting narratives that chart success, every module resonates with the harmonious blend of skill and innovation.
Discover a world where Microsoft Office becomes a conduit of artistry, Data Analysis unfurls like a story, and Microsoft Excel is the brush that paints insights. Enroll now and let the journey begin - where the symphony of knowledge marries technology to compose a future enriched by understanding, proficiency, and foresight.
 CPD 
180 CPD hours / points  Accredited by CPD Quality Standards
 Who is this course for? 
This Microsoft Office Specialist Excel Certification for Data Analysis Bundle is ideal for:
Aspiring data analysts and professionals eager for Excel excellence.
Business personnel seeking efficient data management.
Those aiming to thrive in roles demanding data-centric skills
 Requirements 
You will not need any prior background or expertise in this Microsoft Office Specialist Excel Certification for Data Analysis Bundle.
 Career path 
This Microsoft Office Specialist Excel Certification for Data Analysis bundle will allow you to kickstart or take your career to the next stage in the related sector such as:
Data Analyst: £25,000 - £40,000
Business Analyst: £28,000 - £45,000
Information Manager: £30,000 - £50,000
Financial Analyst: £26,000 - £42,000
Database Manager: £32,000 - £55,000
 Certificates 
Digital certificate
 Digital certificate - Included 

Academy for Health and Fitness

A course by  Sekhar Metla  IT Industry Expert RequirementsNo specific Requirements. Audience  Business professionals who want to create professional-quality documents, presentations, and spreadsheets  Students who need to use Microsoft Office for school projects or assignments  Job seekers who want to improve their Microsoft Office skills for career advancement  Anyone who wants to learn how to use Office 365 for collaboration and productivity  Freelancers, entrepreneurs, and small business owners who need to create professional documents and presentations  Anyone who wants to boost their productivity and efficiency with Microsoft Office tools.<h3> Audience</h3><ul><li> <span></span> <span>Business professionals who want to create professional-quality documents, presentations, and spreadsheets</span></li><li> <span></span> <span>Students who need to use Microsoft Office for school projects or assignments</span></li><li> <span></span> <span>Job seekers who want to improve their Microsoft Office skills for career advancement</span></li><li> <span></span> <span>Anyone who wants to learn how to use Office 365 for collaboration and productivity</span></li><li> <span></span> <span>Freelancers, entrepreneurs, and small business owners who need to create professional documents and presentations</span></li><li> <span></span> <span>Anyone who wants to boost their productivity and efficiency with Microsoft Office tools.</span></li></ul>

A course by Sekhar Metla IT Industry Expert RequirementsNo specific Requirements. Audience Business professionals who want to create professional-quality documents, presentations, and spreadsheets Students who need to use Microsoft Office for school projects or assignments Job seekers who want to improve their Microsoft Office skills for career advancement Anyone who wants to learn how to use Office 365 for collaboration and productivity Freelancers, entrepreneurs, and small business owners who need to create professional documents and presentations Anyone who wants to boost their productivity and efficiency with Microsoft Office tools.
 Audience
Business professionals who want to create professional-quality documents, presentations, and spreadsheets
Students who need to use Microsoft Office for school projects or assignments
Job seekers who want to improve their Microsoft Office skills for career advancement
Anyone who wants to learn how to use Office 365 for collaboration and productivity
Freelancers, entrepreneurs, and small business owners who need to create professional documents and presentations
Anyone who wants to boost their productivity and efficiency with Microsoft Office tools.

Xpert Learning

Office Productivity

Microsoft Office Mastery

<p>Are you looking to enhance your Microsoft Office Course skills? If yes, then you have come to the right place. Our comprehensive course on Microsoft Office Course will assist you in producing the best possible outcome by mastering the Microsoft Office Course skills.</p><p>The Microsoft Office Course is for those who want to be successful. In the Microsoft Office Course, you will learn the essential knowledge needed to become well versed in Microsoft Office Course.</p><p>Our Microsoft Office Course starts with the basics of Microsoft Office Course and gradually progresses towards advanced topics. Therefore, each lesson of this Microsoft Office Course is intuitive and easy to understand.</p><p><strong>Why would you choose the Microsoft Office Course from Compliance Central:</strong></p><ul><li>Lifetime access to Microsoft Office Course materials</li><li>Full tutor support is available from Monday to Friday with the Microsoft Office Course</li><li>Learn Microsoft Office Course skills at your own pace from the comfort of your home</li><li>Gain a complete understanding of Microsoft Office Course</li><li>Accessible, informative Microsoft Office Course learning modules designed by expert instructors</li><li>Get 24/7 help or advice from our email and live chat teams with the Microsoft Office Course bundle</li><li>Study Microsoft Office Course in your own time through your computer, tablet or mobile device.</li><li>A 100% learning satisfaction guarantee with your Microsoft Office Course</li><li>Improve your chance of gaining in demand skills and better earning potential by completing the Microsoft Office Course</li></ul><p><strong> Microsoft Office Course </strong></p><p><strong>Curriculum Breakdown of the Microsoft Office Course<br /></strong></p><ul><li>Section 01: Getting Started</li><li>Section 02: Excel 2021: Basics</li><li>Section 03: Excel 2021: Rows, Columns, and Cells</li><li>Section 04: Excel 2021: Data Handling</li><li>Section 05: Excel 2021: Page Setting Up and Print</li><li>Section 06: Excel 2021: Sorting and Filtering</li><li>Section 07: Excel 2021: Writing Formulas</li><li>Section 08: Excel 2021: Advanced Formulas</li><li>Section 09: Excel 2021: XLOOKUP only for 2021 and Office 365</li><li>Section 10: Excel 2021: Data and Tools</li><li>Section 11: Excel 2021: Formatting data and tables</li><li>Section 12: Excel 2021: Pivot Tables</li><li>Section 13: Excel 2021: Charts</li><li>Section 14: PowerPoint 2021: Course Introduction</li><li>Section 15: PowerPoint 2021: Basics</li><li>Section 16: PowerPoint 2021: Text and Bullet Options</li><li>Section 17: PowerPoint 2021: Adding Graphic Assets</li><li>Section 18: PowerPoint 2021: Picture Formatting</li><li>Section 19: PowerPoint 2021: SmartArt Graphics</li><li>Section 20: PowerPoint 2021: Working with Tables</li><li>Section 21: PowerPoint 2021: Working with Charts</li><li>Section 22: PowerPoint 2021: Adding Multimedia</li><li>Section 23: PowerPoint 2021: Working with Transition</li><li>Section 24: PowerPoint 2021: Animation</li><li>Section 25: PowerPoint 2021: Slideshow Effects</li><li>Section 26: Word 2021: Introduction</li><li>Section 27: Word 2021: Basics</li><li>Section 28: Word 2021: Word Formatting</li><li>Section 29: Word 2021: Tables</li><li>Section 30: Word 2021: Styles</li><li>Section 31: Word 2021: Page Layout</li><li>Section 32: Word 2021: Envelops and Lables</li><li>Section 33: Word 2021: Mail Merges</li><li>Section 34: Word 2021: Review and Printing</li></ul><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 Microsoft Office Course helps aspiring professionals who want to obtain the knowledge and familiarise themselves with the skillsets to pursue a career in Microsoft Office Course. It is also great for professionals who are already working in Microsoft Office Course and want to get promoted at work.</p>
                        </div><h2>
        
        <div>Requirements</div>
    </h2>

                        <div id="requirements">
                            <p>To enrol in this Microsoft Office 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 Microsoft Office Course will enhance your knowledge and improve your confidence in exploring opportunities in various sectors related to Microsoft Office Course.</p>
                        </div><h2>
        
        <div>Certificates</div>
    </h2>

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

                        </div>

Are you looking to enhance your Microsoft Office Course skills? If yes, then you have come to the right place. Our comprehensive course on Microsoft Office Course will assist you in producing the best possible outcome by mastering the Microsoft Office Course skills.
The Microsoft Office Course is for those who want to be successful. In the Microsoft Office Course, you will learn the essential knowledge needed to become well versed in Microsoft Office Course.
Our Microsoft Office Course starts with the basics of Microsoft Office Course and gradually progresses towards advanced topics. Therefore, each lesson of this Microsoft Office Course is intuitive and easy to understand.
Why would you choose the Microsoft Office Course from Compliance Central:
Lifetime access to Microsoft Office Course materials
Full tutor support is available from Monday to Friday with the Microsoft Office Course
Learn Microsoft Office Course skills at your own pace from the comfort of your home
Gain a complete understanding of Microsoft Office Course
Accessible, informative Microsoft Office Course learning modules designed by expert instructors
Get 24/7 help or advice from our email and live chat teams with the Microsoft Office Course bundle
Study Microsoft Office Course in your own time through your computer, tablet or mobile device.
A 100% learning satisfaction guarantee with your Microsoft Office Course
Improve your chance of gaining in demand skills and better earning potential by completing the Microsoft Office Course
 Microsoft Office Course 
Curriculum Breakdown of the Microsoft Office Course

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
 CPD 
10 CPD hours / points  Accredited by CPD Quality Standards
 Who is this course for? 
The Microsoft Office Course helps aspiring professionals who want to obtain the knowledge and familiarise themselves with the skillsets to pursue a career in Microsoft Office Course. It is also great for professionals who are already working in Microsoft Office Course and want to get promoted at work.
 Requirements 
To enrol in this Microsoft Office Course, all you need is a basic understanding of the English Language and an internet connection.
 Career path 
The Microsoft Office Course will enhance your knowledge and improve your confidence in exploring opportunities in various sectors related to Microsoft Office Course.
 Certificates 
CPD Accredited PDF Certificate
 Digital certificate - Included 
CPD Accredited PDF Certificate
CPD Accredited Hard Copy Certificate
 Hard copy certificate - £10.79 
CPD Accredited Hard Copy Certificate
Delivery Charge:
Inside the UK: Free
Outside of the UK: £9.99 each

1336 Courses

Oracle Primavera P6 PPM Professional Advanced Features

By Packt

Microsoft Word Advanced

By Skill Up

Microsoft Excel - More Functions and Formulas

By AXIOM Learning Solutions

Microsoft Excel - Lists and Tables

By AXIOM Learning Solutions

Microsoft Excel - Getting Started

By AXIOM Learning Solutions

Microsoft Excel - Functions and Formulas

By AXIOM Learning Solutions

Microsoft Excel - Formatting Spreadsheets

By AXIOM Learning Solutions

Microsoft Excel - Data Analysis Tools

By AXIOM Learning Solutions

Microsoft Excel - Creating Charts

By AXIOM Learning Solutions

Microsoft Excel - Automating Tasks with Macros

By AXIOM Learning Solutions

Search By Location