Name: Employee Engagement 1 Day Training in Fleet
Price: 595 GBP
Availability: InStock

Elgin

<h1 dir="ltr" id="isPasted" fr-original-style="" style="box-sizing: border-box;"><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color:#000000;">Course Overview:</span></h1><p dir="ltr" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color:#000000;">This training based on leading teams will help you to develop anyone that leads a team or is involved in a leadership role. It is also useful for those that are about to embark on a position of leadership or need to develop their leadership skills.</span></p><p dir="ltr" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color:#000000;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Course Contents:</strong></span></p><p dir="ltr" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color:#000000;">Having an effective team around you is crucial. However, it is an area that is often left to chance, which can lead to de-motivated individuals that do not feel part of the business and consequently do not perform. This course looks at what it takes to lead an effective team and how you can get the best out of the people in it by understanding the role of the leader, both personally and from the point of view of the team.</span></p><p dir="ltr" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color:#000000;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Course Topics:</strong></span></p><ul fr-original-style="" style="box-sizing: border-box;"><li dir="ltr" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color:#000000;"><p dir="ltr" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color:#000000;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Qualities of an Effective Leader</strong></span><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color:#000000;">&nbsp;&ndash; Identifying the key characteristics of effective leaders, rating themselves against them and establishing key actions to develop the skills.</span></p></li><li dir="ltr" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color:#000000;"><p dir="ltr" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color:#000000;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Leader or Manager?</strong></span><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color:#000000;">&nbsp;&ndash; Establishing the difference between the two and comparing themselves to those qualities.</span></p></li><li dir="ltr" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color:#000000;"><p dir="ltr" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color:#000000;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">That Vision Thing</strong></span><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color:#000000;">&nbsp;&ndash; Making the business vision &lsquo;live&rsquo; for the team by answering key questions.</span></p></li><li dir="ltr" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color:#000000;"><p dir="ltr" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color:#000000;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Developing Your Team Goals</strong></span><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color:#000000;">&nbsp;&ndash; Reviewing an action plan that develops clear goals for their team based on the business vision.</span></p></li><li dir="ltr" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color:#000000;"><p dir="ltr" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color:#000000;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Motivation</strong></span><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color:#000000;">&nbsp;&ndash; Determining the &lsquo;Why&rsquo; for their staff and developing an understanding of emotions in a business context.</span></p></li><li dir="ltr" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color:#000000;"><p dir="ltr" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color:#000000;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">What Motivates?</strong></span><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color:#000000;">&nbsp;&ndash; Looking at specific motivators for individuals and understanding that everyone is motivated by different things.</span></p></li><li dir="ltr" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color:#000000;"><p dir="ltr" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color:#000000;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Being Consistently Different</strong>&nbsp;</span><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color:#000000;">&ndash; Going against popular leadership theory and identifying that each staff member needs to be treated differently.</span></p></li><li dir="ltr" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color:#000000;"><p dir="ltr" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color:#000000;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Dealing With Difficult Team Members</strong></span><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color:#000000;">&nbsp;&ndash; Understanding why team members are difficult. Looking at different behavior types and strategies for responding to them. Also, realizing that &lsquo;difficult&rsquo; behavior sometimes has its benefits.</span></p></li><li dir="ltr" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color:#000000;"><p dir="ltr" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color:#000000;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Coaching</strong></span><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color:#000000;">&nbsp;&ndash; Using a simple method of coaching, including action plans.</span></p></li><li dir="ltr" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color:#000000;"><p dir="ltr" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color:#000000;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Three Key Skills of Coaching</strong></span><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color:#000000;">&nbsp;&ndash; Looking at the skills required to be an effective coach.</span></p></li><li dir="ltr" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color:#000000;"><p dir="ltr" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color:#000000;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Instant Results Coaching</strong></span><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color:#000000;">&nbsp;&ndash; Coaching in a hurry!</span></p></li><li dir="ltr" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color:#000000;"><p dir="ltr" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color:#000000;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Can Do Coaching Practice</strong></span><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color:#000000;">&nbsp;&ndash; Putting the learning into practice</span></p></li></ul><p dir="ltr" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color:#000000;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Course Feature:</strong></span></p><p dir="ltr" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color:#000000;">By the end of this training you will be able to:</span></p><ul fr-original-style="" style="box-sizing: border-box;"><li dir="ltr" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color:#000000;"><p dir="ltr" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color:#000000;">Explain the qualities of an effective leader</span></p></li><li dir="ltr" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color:#000000;"><p dir="ltr" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color:#000000;">Benchmark themselves against those qualities and develop actions to improve</span></p></li><li dir="ltr" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color:#000000;"><p dir="ltr" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color:#000000;">Explain the difference between leading and managing</span></p></li><li dir="ltr" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color:#000000;"><p dir="ltr" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color:#000000;">Explain the value of sharing the business vision with the team</span></p></li><li dir="ltr" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color:#000000;"><p dir="ltr" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color:#000000;">Develop team goals based on the business vision</span></p></li><li dir="ltr" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color:#000000;"><p dir="ltr" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color:#000000;">Motivate their staff by understanding their drivers and developing actions to support them</span></p></li><li dir="ltr" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color:#000000;"><p dir="ltr" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color:#000000;">Deal with difficult staff members</span></p></li><li dir="ltr" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color:#000000;"><p dir="ltr" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color:#000000;">Challenge staff in a meaningful and effective way</span></p></li><li dir="ltr" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color:#000000;"><p dir="ltr" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color:#000000;">Coach staff effectively using a simple process</span></p></li></ul><p dir="ltr" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color:#000000;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Certification:</strong></span></p><p dir="ltr" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color:#000000;">Once after the training you receive course completion certificate from Mangates</span></p><p dir="ltr" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color:#000000;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Who can Attend?</strong></span></p><p dir="ltr" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color:#000000;">Anybody who is interested in learning Effective Skills to Lead a Team.</span></p>

Certificate: Course Completion Certificate | Language: English

Duration: 1 Day | Credits: 8 PDUs

Course Delivery: Classroom | Virtual Live

Lunch and Beverages are included in a classroom session

Course Overview:

Employee engagement is a necessary strategy for companies that want to succeed in the marketplace.  Employee engagement is not an HR initiative that managers are reminded to do once a year.  It is a key strategic driver of employee performance, accomplishment, and continuous improvement all year long. It is the outcome of how your organisation interacts with people to drive business results.
This Employee Engagement training is suitable for anyone that works in a management or leadership role.

Course Contents:

Help improve the engagement of your employees and increase business success
Engagement is a heightened emotional connection that an employee feels for his organisation, which influences them to put in greater effort. Higher engagement levels yield higher productivity and retention rates. This makes employee engagement a powerful factor in business success. Engaged employees are more productive, customer-focused, and profit-oriented and organisations are more likely to retain them.
An essential part of an organisation’s talent management strategy is its focus on employee engagement and retention. Organisations that maintain this focus create an environment where employees have the tools, resources, and professional opportunities to develop skills and fulfil their career goals.
Why is taking this course a good idea?

Well, just imagine if your you were better able to:

Understand the importance of employee engagement and the key part it plays in business success.
Apply tactics that motivate and engage employees, creating advocates for the business.
Achieve a working environment that encourages employees to excel at work activities.
Ensure talent retention by creating positive working relationships.
Develop a strategy for employee engagement success.
Prevent activities that cause disengagement and disgruntled workers.
Ultimately, these training course materials will help managers to engage and enthuse their team, creating a motivated workforce that wants to succeed.
Employee engagement is a key factor in creating the right conditions for all members of an organisation to give their best each day, committed to their organisation’s goals and values, motivated to contribute to organisational success, and with an enhanced sense of their own well-being.
These course materials aim to help highlight the requirements that managers and leaders have to help improve the engagement of employees, while giving them key tools and supporting content to ensure they are prepared  to deliver on employee engagement within the organisation.

Course Topics:

Introduction and Objectives – Setting the scene for the training course, defining what is meant by employee engagement and establishing participants expectations.
The Current Situations – Using a PEST analysis approach to identify the current status of employee engagement within the organisation, whilst establishing the internal and external factors that can have an impact on employee engagement.
Roles and Responsibilities – Establishing the different roles people have in ensuring employee engagement and the responsibilities that we all have for ourselves in ensuring we are motivated and engaged at work. Participants are encouraged to consider their own level of engagement, what this means and how it can improve.
The Four Enablers – Focusing on the Four Steps to Employee Engagement and how organisations and the leaders within it can create the right environment for a positive outlook to be nurtured. Includes a case study to identify key working practices.
Job Design – Understanding how the implementation of a job role can affect how the employee feels about it and the five characteristics that should be considered to help develop a role that employees are motivated to work in. Includes a chance to apply the five characteristics to a job role to help relate the approach to a real scenario.
Creating the Right Work Environment – Reviewing the big picture and the approach that the organisation and managers should take to ensure a culture of engagement and motivating factors. Creating an environment where employee engagement can flourish and applying techniques to personal work experiences.
Engagement and Retention – Establishing the importance of long-term career growth and opportunity to engagement and how this helps develop employees that feel valued and enjoy what they do each day. Includes a case study to identify how the approach can be applied to real-life scenarios.
Engagement Tactics – Developing an understanding of the tactics that can be applied to employee engagement and prioritising the factors that are most influential.
Disengagement and the Six Human Needs – Identifying how employees become disengaged and what action can be taken to turn this around. Developing knowledge of the fundamental needs that people need to have met to make them feel happy and motivated. Includes a case study that helps participants identify the needs of employees in a real example, while helping them to identify issues within their own team.
Critical Success Factors – Focusing on the engagement techniques that can be applied in the workplace and the critical success factors that managers should include in their strategy and how they might overcome barriers or challenges to their approach.
This course is highly interactive and includes activities, discussions and exercises throughout to both engage the learners and help embed the learning.

Course Feature:

At the end of this Employee Engagement training course you will be able to:
Define and recognise employee engagement
Design jobs to motivate and engage
Create an engaging work environment
Retain your talent
Use employee engagement strategies
Prevent disengagement

Certification:

Once after the training you receive course completion certificate from Mangates.

Who can Attend?

Anybody who is interested in learning Employee Engagement Skills.

Mangates

Employee Engagement 1 Day Training in Elgin

The sale ends 5 days before the event starts.

Early Bird Fee

The sale ends 10 days before the event starts.

Standard Fee

Luton

Employee Engagement 1 Day Training in Luton

Guildford

Employee Engagement 1 Day Training in Guildford

Heathrow

Employee Engagement 1 Day Training in Heathrow

Belfast

Certificate: Course Completion Certificate | Language: English
Duration: 1 Day | Credits: 8 PDUs
Course Delivery: Classroom | Virtual Live
Lunch and Beverages are included in a classroom session

Course Overview:
Employee engagement is a necessary strategy for companies that want to succeed in the marketplace.  Employee engagement is not an HR initiative that managers are reminded to do once a year.  It is a key strategic driver of employee performance, accomplishment, and continuous improvement all year long. It is the outcome of how your organisation interacts with people to drive business results.
This Employee Engagement training is suitable for anyone that works in a management or leadership role.
Course Contents:
Help improve the engagement of your employees and increase business success
Engagement is a heightened emotional connection that an employee feels for his organisation, which influences them to put in greater effort. Higher engagement levels yield higher productivity and retention rates. This makes employee engagement a powerful factor in business success. Engaged employees are more productive, customer-focused, and profit-oriented and organisations are more likely to retain them.
An essential part of an organisation’s talent management strategy is its focus on employee engagement and retention. Organisations that maintain this focus create an environment where employees have the tools, resources, and professional opportunities to develop skills and fulfil their career goals.
Why is taking this course a good idea?
Well, just imagine if your you were better able to:
Understand the importance of employee engagement and the key part it plays in business success.
Apply tactics that motivate and engage employees, creating advocates for the business.
Achieve a working environment that encourages employees to excel at work activities.
Ensure talent retention by creating positive working relationships.
Develop a strategy for employee engagement success.
Prevent activities that cause disengagement and disgruntled workers.
Ultimately, these training course materials will help managers to engage and enthuse their team, creating a motivated workforce that wants to succeed.
Employee engagement is a key factor in creating the right conditions for all members of an organisation to give their best each day, committed to their organisation’s goals and values, motivated to contribute to organisational success, and with an enhanced sense of their own well-being.
These course materials aim to help highlight the requirements that managers and leaders have to help improve the engagement of employees, while giving them key tools and supporting content to ensure they are prepared  to deliver on employee engagement within the organisation.
Course Topics:
Introduction and Objectives – Setting the scene for the training course, defining what is meant by employee engagement and establishing participants expectations.
The Current Situations – Using a PEST analysis approach to identify the current status of employee engagement within the organisation, whilst establishing the internal and external factors that can have an impact on employee engagement.
Roles and Responsibilities – Establishing the different roles people have in ensuring employee engagement and the responsibilities that we all have for ourselves in ensuring we are motivated and engaged at work. Participants are encouraged to consider their own level of engagement, what this means and how it can improve.
The Four Enablers – Focusing on the Four Steps to Employee Engagement and how organisations and the leaders within it can create the right environment for a positive outlook to be nurtured. Includes a case study to identify key working practices.
Job Design – Understanding how the implementation of a job role can affect how the employee feels about it and the five characteristics that should be considered to help develop a role that employees are motivated to work in. Includes a chance to apply the five characteristics to a job role to help relate the approach to a real scenario.
Creating the Right Work Environment – Reviewing the big picture and the approach that the organisation and managers should take to ensure a culture of engagement and motivating factors. Creating an environment where employee engagement can flourish and applying techniques to personal work experiences.
Engagement and Retention – Establishing the importance of long-term career growth and opportunity to engagement and how this helps develop employees that feel valued and enjoy what they do each day. Includes a case study to identify how the approach can be applied to real-life scenarios.
Engagement Tactics – Developing an understanding of the tactics that can be applied to employee engagement and prioritising the factors that are most influential.
Disengagement and the Six Human Needs – Identifying how employees become disengaged and what action can be taken to turn this around. Developing knowledge of the fundamental needs that people need to have met to make them feel happy and motivated. Includes a case study that helps participants identify the needs of employees in a real example, while helping them to identify issues within their own team.
Critical Success Factors – Focusing on the engagement techniques that can be applied in the workplace and the critical success factors that managers should include in their strategy and how they might overcome barriers or challenges to their approach.
This course is highly interactive and includes activities, discussions and exercises throughout to both engage the learners and help embed the learning.
Course Feature:
At the end of this Employee Engagement training course you will be able to:
Define and recognise employee engagement
Design jobs to motivate and engage
Create an engaging work environment
Retain your talent
Use employee engagement strategies
Prevent disengagement
Certification:
Once after the training you receive course completion certificate from Mangates.
Who can Attend?
Anybody who is interested in learning Employee Engagement Skills.

Employee Engagement 1 Day Training in Belfast

Darlington

Employee Engagement 1 Day Training in Darlington

High Wycombe 

Employee Engagement 1 Day Training in High Wycombe

Solihull

Employee Engagement 1 Day Training in Solihull

Northampton

Employee Engagement 1 Day Training in Northampton

Fleet 

Employee Engagement 1 Day Training in Fleet

<p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="color: rgb(35, 35, 51); box-sizing: border-box;" id="isPasted" fr-original-style="color: rgb(35, 35, 51);">Learn the foundations of Excel that never get taught to you, this will catapult your confidence when working with Excel and give you a strong base when taking on other advanced topics. &nbsp;This course will teach you a methodology for working with Excel that exposes how the Excel application works.&nbsp;</span></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="color: rgb(35, 35, 51); box-sizing: border-box;" fr-original-style="color: rgb(35, 35, 51);">The course highlights many shortcuts, tips, and tricks to make you more productive on the job. It is said that more than 80% of Excel users are aware of only 20% of what Excel can do. We will show you the tools, functions, and techniques that will unlock the 80% of Excel you may not know about.</span></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="color: rgb(35, 35, 51); box-sizing: border-box;" fr-original-style="color: rgb(35, 35, 51);">&nbsp;This instructor-led course includes:&nbsp;</span></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="color: rgb(35, 35, 51); box-sizing: border-box;" fr-original-style="color: rgb(35, 35, 51);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">&bull; &nbsp; &nbsp;2 weeks of self-paced essential learning content that you are to complete before the instructor-led live virtual sessions begin&nbsp;</strong></span></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="color: rgb(35, 35, 51); box-sizing: border-box;" fr-original-style="color: rgb(35, 35, 51);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">&bull; &nbsp; &nbsp;4 instructor-led virtual sessions of 2 hours each. Each Session will have a 15-minute break.&nbsp;</strong></span></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="color: rgb(35, 35, 51); box-sizing: border-box;" fr-original-style="color: rgb(35, 35, 51);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">&bull; &nbsp; &nbsp;Intersession Assignments that you are expected to complete and discuss in your preassigned groups during the session.&nbsp;</strong></span></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="color: rgb(35, 35, 51); box-sizing: border-box;" fr-original-style="color: rgb(35, 35, 51);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">&bull; &nbsp; &nbsp;1 Capstone Project&nbsp;</strong></span></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="color: rgb(35, 35, 51); box-sizing: border-box;" fr-original-style="color: rgb(35, 35, 51);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">&bull; Lifetime access to our LMS where you will have free access to the trainer, other participants, and resources including knowledge videos.&nbsp;</strong></span></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="color: rgb(35, 35, 51); box-sizing: border-box;" fr-original-style="color: rgb(35, 35, 51);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">&bull; &nbsp; &nbsp;Access to our community of life-long learners.&nbsp;</strong></span></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="color: rgb(35, 35, 51); box-sizing: border-box;" fr-original-style="color: rgb(35, 35, 51);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">&bull; &nbsp; &nbsp;Downloadable Certificate you can link to your LinkedIn page.</strong></span></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="color: rgb(35, 35, 51); box-sizing: border-box;" fr-original-style="color: rgb(35, 35, 51);">We look forward to seeing you in Class!!!</span></p>

Learn the foundations of Excel that never get taught to you, this will catapult your confidence when working with Excel and give you a strong base when taking on other advanced topics. This course will teach you a methodology for working with Excel that exposes how the Excel application works. 
The course highlights many shortcuts, tips, and tricks to make you more productive on the job. It is said that more than 80% of Excel users are aware of only 20% of what Excel can do. We will show you the tools, functions, and techniques that will unlock the 80% of Excel you may not know about.
 This instructor-led course includes: 
• 2 weeks of self-paced essential learning content that you are to complete before the instructor-led live virtual sessions begin 
• 4 instructor-led virtual sessions of 2 hours each. Each Session will have a 15-minute break. 
• Intersession Assignments that you are expected to complete and discuss in your preassigned groups during the session. 
• 1 Capstone Project 
• Lifetime access to our LMS where you will have free access to the trainer, other participants, and resources including knowledge videos. 
• Access to our community of life-long learners. 
• Downloadable Certificate you can link to your LinkedIn page.
We look forward to seeing you in Class!!!

dbrownconsulting

Excel Analytics

Microsoft Excel

Master Excel to catapult your productivity skills with this online course. Go from Beginner to Pro in Excel

Power Excel 1 (the essentials)

General Admission

<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

Nexus Human

Office Skills & Productivity

Office Skills

Microsoft Office

Spreadsheet

Excel - Excel Essentials and Formulas

MOS Core Excel - 77-727 : Complete Techniques for Exam Success
Microsoft Certification (MOS) - Use your knowledge to become a Microsoft Office Specialist in Core Excel. This course will prepare you for the Microsoft Office Specialist Exam 77-727. The course provides an overview of the exam, the objective requirements set by Microsoft, tips on how to prepare and what to expect on the day of the test. It includes a comprehensive bank of test exercises which reflect the style of questions asked in the 77-727 Microsoft Core Excel exam. A comprehensive series of lectures are provided which cover every step needed to succeed. Become a Microsoft Office Specialist and Enhance Your Career
Use your knowledge to obtain certified status
Understand the 77-727 Exam
Learn how to correctly prepare for the test
Get advice from a seasoned professional who knows how to pass the exam
Core Excel with the MOS 77-727 Exam
This course is suitable for people at all levels of proficiency in Microsoft Excel. If you are new to the subject, then the course will lead you step by step through every single technique which is tested in the 77-727 exam. If you are already proficient in the use of Excel to some extent, then this course will help you to understand what is required in order to obtain a valuable certification in the subject. Every element of the objective domain for the 77-727 exam is comprehensively covered, together with exercises designed to ensure that you know the style and types of questions which you are required to answer in the exam. When you pass the 77-727 exam, Microsoft issue you with the MOS, or Microsoft Office Specialist certification status, in core Excel. Obtaining this certification provides tangible evidence that you are proficient in your use of Microsoft Excel and your LinkedIn profile will be automatically adjusted by Microsoft to reflect this achievement. If you follow and complete the course and exercises you will optimize your chances of gaining that qualification, you will enhance your status in your existing job and boost your job prospects in the marketplace. 
What You Will Learn
How to successfully pass the 77-727 Microsoft Certified Exam in Core Excel and become a Microsoft Office Specialist
Be confident and competent in your use of Microsoft Excel for everyday business use
Be ready to begin to study to become a certified Microsoft Office Specialist
Guarantee potential Employers of your competence in Microsoft Excel
Audience
This course is for students who are either total beginners with Microsoft Excel or who are intermediate users who want to obtain certification in Core Excel, existing users of Excel who want to learn how to pass the 77-727 exam and obtain official certification for their skills. 
Approach
The course explains how the exam is structured, the way that the questions should be approached and how to study successfully to pass. The course also includes invaluable advice on the best way to prepare and what to expect from the testing process. 
Key Features
Suitable for beginners or for anyone who has a reasonable knowledge of Microsoft Excel, this course is aimed at you obtaining certification status from Microsoft bypassing the 77-727 exam.
Github Repo
https://github.com/packtpublishing/77-727-microsoft-excel-certification---mos-excel-core-exam
About the Author
Dave Murphy
Dave Murphy - With over twenty years of experience as a systems analyst and project manager with significant experience in the design and implementation of major projects for some of the world's largest companies, Dave Murphy changed his career track in 2000 and has been a professional university educator for over 20 years. Dave is currently a lecturer in business information systems at the Technological University, Dublin. His main interests are in Microsoft certifications, project management, and business process analysis. Dave has a bachelor's in science (Hons) from Trinity College, Dublin, and a master's degree in computing. In addition to obtaining PRINCE2 Practitioner status, Dave is also a Microsoft Certified Professional in managing projects with Microsoft Project, is a MOS Master, and also a MOS examiner.
Course Outline
1. Introduction

1. What is the Microsoft Office Specialist (MOS) Certification?
Introduction: What is the Microsoft Office Specialist (MOS) Certification?
2. Understanding the Objective Domain
Introduction: Understanding the Objective Domain
3. How is the exam be conducted and what will it be like?
Introduction: How is the exam be conducted and what will it be like?
2. Introducing the Microsoft Excel User Interface

1. Introducing the Excel User Interface
Introducing the Microsoft Excel User Interface: Introducing the Excel User Interface
2. Essential Navigation Skills
Introducing the Microsoft Excel User Interface: Essential Navigation Skills
3. Entering Information
Introducing the Microsoft Excel User Interface: Entering Information
3. 1.1 Create Worksheets and Workbooks

1. 1.1.1 Create a Workbook
Create Worksheets and Workbooks: 1.1.1 Create a Workbook
2. 1.1.2 Importing Data from a Delimited Text File
Create Worksheets and Workbooks: 1.1.2 Importing Data from a Delimited Text File
3. 1.1.3 Add a Worksheet to an Existing Workbook
Create Worksheets and Workbooks: 1.1.3 Add a Worksheet to an Existing Workbook
4. 1.1.4 Copy and Move a Worksheet
Create Worksheets and Workbooks: 1.1.4 Copy and Move a Worksheet
5. Exercises Domain 1.1
Create Worksheets and Workbooks: Exercises Domain 1.1
4. 1.2 Navigate in Worksheets and Workbooks

1. 1.2.1 & 1.2.2 Search & Navigate to a Named Cell, Range, of Workbook Element
1.2 Navigate in Worksheets and Workbooks: 1. 2.1 & 1.2.2 Search & Navigate to a Named Cell, Range, of Workbook Element
2. 1.2.2 Named Ranges
1.2 Navigate in Worksheets and Workbooks: 1. 2.2 Named Ranges
3. 1.2.3 Insert and Remove hyperlinks
1.2 Navigate in Worksheets and Workbooks: 1. 2.3 Insert and Remove hyperlinks
4. Exercises Domain 1.2
Navigate in Worksheets and Workbooks: Exercises Domain 1.2
5. 1.3 Format Worksheets and Workbooks

1. 1.3.1 to 1.3.3 Changing Worksheet Characteristics
1.3 Format Worksheets and Workbooks: 1.3.1 to 1.3.3 Changing Worksheet Characteristics
2. 1.3.4 Modify Page Setup
1.3 Format Worksheets and Workbooks: 1.3.4 Modify Page Setup
3. 1.3.5 Insert and Delete Columns or Rows (and Cells)
1.3 Format Worksheets and Workbooks: 1.3.5 Insert and Delete Columns or Rows (and Cells)
4. 1.3.6 Change Workbook Themes
1.3 Format Worksheets and Workbooks: 1.3.6 Change Workbook Themes
5. 1.3.7 Adjust Row Height and Column Width
1.3 Format Worksheets and Workbooks: 1.3.7 Adjust Row Height and Column Width
6. 1.3.8 Insert Headers and Footers
1.3 Format Worksheets and Workbooks: 1.3.8 Insert Headers and Footers
7. Exercises Domain 1.3
Format Worksheets and Workbooks: Exercises Domain 1.3
6. 1.4 Customise Options and Views for Worksheets and Workbooks

1. 1.4.1 and 1.4.2 Hide or Unhide Worksheets, Columns and Rows
1.4 Customise Options and Views for Worksheets and Workbooks: 1.4.1 and 1.4.2 Hide or Unhide Worksheets, Columns and Rows
2. 1.4.4 Change Workbook Views
1.4 Customise Options and Views for Worksheets and Workbooks: 1.4.4 Change Workbook Views
3. 1.4.5 Change Window Views
1.4 Customise Options and Views for Worksheets and Workbooks: 1.4.5 Change Window Views
4. 1.4.6 Modify Document Properties
1.4 Customise Options and Views for Worksheets and Workbooks: 1.4.6 Modify Document Properties
5. 1.4.7 Change Magnification by using Zoom Tools
1.4 Customise Options and Views for Worksheets and Workbooks: 1.4.7 Change Magnification by using Zoom Tools
6. 1.4.8 Display Formulas
1.4 Customise Options and Views for Worksheets and Workbooks: 1.4.8 Display Formulas
7. Exercises Domain 1.4
Customise Options and Views for Worksheets and Workbooks: Exercises Domain 1.4
7. 1.5 Configure Worksheets and Workbooks for Distribution

1. 1.5.1. Set a Print Area
Configure Worksheets and Workbooks for Distribution: 1.5.1. Set a Print Area
2. 1.5.2 save Workbooks in Alternative File Formats
1.5 Configure Worksheets and Workbooks for Distribution: 1.5.2 save Workbooks in Alternative File Formats
3. 1.5.3 Print All of Part of a Workbook
1.5 Configure Worksheets and Workbooks for Distribution: 1.5.3 Print All of Part of a Workbook
4. 1.5.4 Set Print Scaling
1.5 Configure Worksheets and Workbooks for Distribution: 1.5.4 Set Print Scaling
5. 1.5.5 Display Repeating Row and Column Titles on Multipage Worksheets
1.5 Configure Worksheets and Workbooks for Distribution: 1.5.5 Display Repeating Row and Column Titles on Multipage Worksheets
6. 1.5.6 Inspect a Workbook for Hidden Properties or Personal Information
1.5 Configure Worksheets and Workbooks for Distribution: 1.5.6 Inspect a Workbook for Hidden Properties or Personal Information
7. 1.5.7 Inspect a Workbook for Accessibility Issues
1.5 Configure Worksheets and Workbooks for Distribution: 1.5.7 Inspect a Workbook for Accessibility Issues
8. 1.5.8 Inspect a Workbook for Compatibility Issues
1.5 Configure Worksheets and Workbooks for Distribution: 1.5.8 Inspect a Workbook for Compatibility Issues
9. Exercises 1.5
Configure Worksheets and Workbooks for Distribution: Exercises 1.5
8. 2.1 Insert Data in Cells and Ranges

1. 2.1.1 Replace Data
Insert Data in Cells and Ranges: 2.1.1 Replace Data
2. 2.1.2 Cut, Copy or Paste Data
Insert Data in Cells and Ranges: 2.1.2 Cut, Copy or Paste Data
3. 2.1.3 Paste Data by using Special Paste Options
Insert Data in Cells and Ranges: 2.1.3 Paste Data by using Special Paste Options
4. 2.1.4 Fill Cells by using Auto Fill
Insert Data in Cells and Ranges: 2.1.4 Fill Cells by using Auto Fill
5. 2.1.5 Insert and Delete Cells
Insert Data in Cells and Ranges: 2.1.5 Insert and Delete Cells
6. Exercises Domain 2.1
Insert Data in Cells and Ranges: Exercises Domain 2.1
9. 2.2. Format Cells and Ranges

1. 2.2.1 Merge Cells
Format Cells and Ranges: 2.2.1 Merge Cells
2. 2.2.2 Modify Cell Alignment and Indentation
Format Cells and Ranges: 2.2.2 Modify Cell Alignment and Indentation
3. 2.2.3 Format Cells by using Format Painter
Format Cells and Ranges: 2.2.3 Format Cells by using Format Painter
4. 2.2.4 Wrap Text within Cells
Format Cells and Ranges: 2.2.4 Wrap Text within Cells
5. 2.2.5 Apply Number Formats
Format Cells and Ranges: 2.2.5 Apply Number Formats
6. 2.2.6 Apply Cell Formats
Format Cells and Ranges: 2.2.6 Apply Cell Formats
7. 2.2.7 Apply Cell Styles
Format Cells and Ranges: 2.2.7 Apply Cell Styles
8. Exercises Domain 2.2
Format Cells and Ranges: Exercises Domain 2.2
10. 2.3 Summarise and Organise Data

1. 2.3.4 Apply Conditional Formatting
2.3 Summarise and Organise Data: 2.3.4 Apply Conditional Formatting
2. Exercises Domain 2.3
Summarise and Organise Data: Exercises Domain 2.3
11. 3.1 And 3.2 Create and Manage Tables

1. 3.1.1 and 3.1.2 Create an Excel Table from a Cell Range and Reverse
And 3.2 Create and Manage Tables: 3.1.1 and 3.1.2 Create an Excel Table from a Cell Range and Reverse
2. 3.1.3 Add or Remove Table rows and Columns
And 3.2 Create and Manage Tables: 3.1.3 Add or Remove Table rows and Columns
3. 3.2.1 to 3.2.3 Table Styles
And 3.2 Create and Manage Tables: 3.2.1 to 3.2.3 Table Styles
4. Exercises Domain 3.1 and 3.2
And 3.2 Create and Manage Tables: Exercises Domain 3.1 and 3.2
12. 3.3 Filter and Sort a Table

1. 3.3.1 Filter Records
3.3 Filter and Sort a Table: 3. 3.1 Filter Records
2. 3.3.2 and 3.3.3 Sort Data
3.3 Filter and Sort a Table: 3. 3.2 and 3.3.3 Sort Data
3. 3.3.4 Remove Duplicate Records
Filter and Sort a Table: 3.3.4 Remove Duplicate Records
4. Exercises Domain 3.3
Filter and Sort a Table: Exercises Domain 3.3
13. 4.1 Summarise Data by Using Functions

1. 4.1.1 (Part I) Insert References
Summarise Data by Using Functions: 4.1.1 (Part I) Insert References
2. 4.1.1 (Part II) Absolute References
Summarise Data by Using Functions: 4.1.1 (Part II) Absolute References
3. 4.1.2 Perform Calculations by using the SUM Function
Summarise Data by Using Functions: 4.1.2 Perform Calculations by using the SUM Function
4. 4.1.3 to 4.1.5 Using the Average, MIN, MAX and COUNT Functions
Summarise Data by Using Functions: .1.3 to 4.1.5 Using the Average, MIN, MAX and COUNT Functions
5. 2.3.2 Outline Data
Summarise Data by Using Functions: 2.3.2 Outline Data
6. 2.3.3 Insert Subtotals
Summarise Data by Using Functions: 2.3.3 Insert Subtotals
7. Exercises Domain 4.1
Summarise Data by Using Functions: Exercises Domain 4.1
14. 4.2 Perform Conditional Operations by Using Functions

1. 4.2.1 Perform Logical Operations by using the IF Function
Perform Conditional Operations by Using Functions: 4.2.1 Perform Logical Operations by using the IF Function
2. 4.2.2 to 4.2.4 Using the AverageIF, COUNTIF and SUMIF Functions
Perform Conditional Operations by Using Functions: 4.2.2 to 4.2.4 Using the AverageIF, COUNTIF and SUMIF Functions
3. Exercises Domain 4.2
Perform Conditional Operations by Using Functions: Exercises Domain 4.2
15. 4.3 Format and Modify Text by Using Functions

1. 4.3.1 Format Text by using RIGHT, LEFT and MID Functions
Format and Modify Text by Using Functions: 4.3.1 Format Text by using RIGHT, LEFT and MID Functions
2. Exercises Domain 4.3
Format and Modify Text by Using Functions: Exercises Domain 4.3
16. 5.1 Create Charts

1. 5.1.1 Create a New Chart
Create Charts: 5.1.1 Create a New Chart
2. 5.1.2 and 5.1.3 Add Additional Data Series and Switch Rows and Columns
Create Charts: 5.1.2 and 5.1.3 Add Additional Data Series and Switch Rows and Columns
3. 5.1.4 Analyse Data by using Quick Analysis
Create Charts: 5.1.4 Analyse Data by using Quick Analysis
4. 2.3.1 Insert Sparklines
Create Charts: 2.3.1 Insert Sparklines
5. Exercises Domain 5.1
Create Charts: Exercises Domain 5.1
17. 5.2 Format Charts

1. 5.2.1 Resize Charts
Format Charts: 5.2.1 Resize Charts
2. 5.2.2 Add and Modify Chart Elements
Format Charts: 5.2.2 Add and Modify Chart Elements
3. 5.2.3 and 5.2.4 Apply Chart Layouts and Styles and Move Charts
Format Charts: 5.2.3 and 5.2.4 Apply Chart Layouts and Styles and Move Charts
4. Exercises Domain 5.2
Format Charts: Exercises Domain 5.2
18. 5.3 Insert and Format Objects

1. 5.3.1 Insert Text Boxes and Shapes
Insert and Format Objects: 5.3.1 Insert Text Boxes and Shapes
2. 5.3.2 Insert Images
Insert and Format Objects: 5.3.2 Insert Images
3. 5.3.3 Modify Object Properties
Insert and Format Objects: 5.3.3 Modify Object Properties
4. 5.3.4 Add Alternative Text to Objects for Accessibility
Insert and Format Objects: 5.3.4 Add Alternative Text to Objects for Accessibility
5. Exercises Domain 5.3
Insert and Format Objects: Exercises Domain 5.3

Packt

MOS Core Excel - 77-727 : Complete Techniques for Exam Success

77-727 Microsoft Excel Certification - MOS Excel Core Exam

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



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


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


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


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


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


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


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

Bayfield Training

Financial Modelling & Analysis

Financial Modelling

Professional Development

Property & Real Estate Photography

Continuous Professional Development (CPD)

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

Real Estate Analyst (Investment Cash Flow Modelling in Excel)

In-Person 

Virtual

<p style="color: rgb(80, 54, 89); font-size: var(--font-size); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(80, 54, 89);">This course will bring everyday Excel skills up a level to enhance your performance and improve your efficiency. What&#39;s not to like? No more Google searching for the correct shortcut!</p><ul style="color: rgb(102, 102, 102); box-sizing: border-box;" fr-original-style=" color: rgb(102, 102, 102);"><li style="color: rgb(80, 54, 89); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(80, 54, 89);">Entering text, numbers and Autofill</li><li style="color: rgb(80, 54, 89); box-sizing: border-box;" fr-original-style=" color: rgb(80, 54, 89);">Navigating Excel</li><li style="color: rgb(80, 54, 89); box-sizing: border-box;" fr-original-style=" color: rgb(80, 54, 89);">Selecting and editing</li><li style="color: rgb(80, 54, 89); box-sizing: border-box;" fr-original-style=" color: rgb(80, 54, 89);">Using the Sum function</li><li style="color: rgb(80, 54, 89); box-sizing: border-box;" fr-original-style=" color: rgb(80, 54, 89);">Basic formulae</li><li style="color: rgb(80, 54, 89); box-sizing: border-box;" fr-original-style=" color: rgb(80, 54, 89);">Rows, columns and borders</li><li style="color: rgb(80, 54, 89); box-sizing: border-box;" fr-original-style=" color: rgb(80, 54, 89);">Freezing panes</li><li style="color: rgb(80, 54, 89); box-sizing: border-box;" fr-original-style=" color: rgb(80, 54, 89);">Printing from Excel</li><li style="color: rgb(80, 54, 89); box-sizing: border-box;" fr-original-style=" color: rgb(80, 54, 89);">Custom use</li></ul><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></p><p id="isPasted" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">2 weeks - 2 sessions a week (2hrs live online)</p><ul type="disc" id="isPasted" fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">25 June , 27 June , 2 July and 4 July</li></ul><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Tuesdays &amp; Thursdays 09:30 - 11:30</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">&pound;275+VAT per person</p><h2 style="color: rgb(35, 73, 109); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(35, 73, 109);"><span style="font-size: 14px; box-sizing: border-box;" fr-original-style="font-size: 14px;">This course is also available as in-house training at a fixed cost for up to 8 delegates.&nbsp;</span><span style="font-size: 14px; box-sizing: border-box;" fr-original-style="font-size: 14px;">Email us for more information. <a href="mailto:admin@sterlingtraining.org" fr-original-style="" style="-webkit-user-select: auto; font-size: var(--font-size); box-sizing: border-box; cursor: pointer; text-decoration: inherit;">admin@sterlingtraining.org</a>.uk</span></h2>

This course will bring everyday Excel skills up a level to enhance your performance and improve your efficiency. What's not to like? No more Google searching for the correct shortcut!
Entering text, numbers and Autofill
Navigating Excel
Selecting and editing
Using the Sum function
Basic formulae
Rows, columns and borders
Freezing panes
Printing from Excel
Custom use


2 weeks - 2 sessions a week (2hrs live online)
25 June , 27 June , 2 July and 4 July
Tuesdays & Thursdays 09:30 - 11:30
£275+VAT per person
This course is also available as in-house training at a fixed cost for up to 8 delegates. Email us for more information. admin@sterlingtraining.org.uk

Sterling Training

Performance and efficiency-enhancing Excel skills for everyday users.

Mastering Excel

<strong>Learn and master Excel 2019 by learning advanced functions and formulas</strong>
        <p>Get beyond the basics and supercharge your current skill level in Excel. With this 9-hour, expert-led video training course, you'll gain an in-depth understanding of more advanced Excel features that delve into high-level consolidation, analysis and reporting of financial information.
Upon completion of this course, you'll be able to create charts that have an impact from databases that communicate data and financial records efficiently and effectively.
You will be able to report data in various formats including: tables, graphs and PivotTables. Once completed you'll have advanced understanding of Excel that will positively impact your professional capability.
All the codes and supporting files for this course are available at: https://github.com/PacktPublishing/Microsoft-Excel-Advanced-2019</p>
        <h2>What You Will Learn</h2><p>What s new/different in Excel 2019<br>Advanced charting and graphing in Excel<br>How to use detailed formatting tools<br>Lookup and advanced lookup functions<br>Financial functions including calculating interest and depreciation<br>Statistical functions<br>Connecting to other workbooks and datasets outside of Excel e.g. MS Access and the web.<br>How to create awesome visualizations using sparklines and data bars<br>Mastery of PivotTables and Pivot Charts<br>Scenario Manager, Goal Seek, and Solver<br>Advanced charts such as Surface, Radar, Bubble and Stock Charts</p>
        <h2>Audience</h2><p>This course is designed for those who have basic knowledge of Excel 2019/365 and those upgrading from previous software versions</p>
        <h2>Approach</h2><p>A complete course packed with Quiz, Working examples, Exercise and demo files. </p>
        <h2>Key Features</h2><p>Learn and understand advanced Excel features that delve into high-level consolidation, analysis, and reporting of financial information * Learn and master advanced charting and graphing in Excel</p>
        <h2>Github Repo</h2><p>https://github.com/packtpublishing/microsoft-excel-advanced-2019</p>
        <h2>About the Author</h2><h3>Simon Sez IT</h3><p>Simon Sez IT has offered technical courses for individuals, small businesses, and Fortune 500 companies since 2008, with thousands of employees who can benefit from the easy-to-learn and hands-on software training. It offers over 8,000 video tutorials on a range of software programs.

Simon Sez IT ensures stress-free eLearning and enhanced employee productivity-whether you implement new software or a technological upgrade in your work environment. With over 600,000 students from 180 countries, Simon Sez IT is the preferred online learning choice for individuals and businesses worldwide.</p>
        <h2>Course Outline</h2><h4>1. Introduction to Excel 2016 Advanced Course</h4><p></p><br><h4>2. Functions</h4><p></p><br><h4>3. Date and Time Functions</h4><p></p><br><h4>4. Text Functions</h4><p></p><br><h4>5. Logical Functions</h4><p></p><br><h4>6. Lookup Functions</h4><p></p><br><h4>7. Financial Functions</h4><p></p><br><h4>8. Statistical Functions</h4><p></p><br><h4>9. Connecting to External Data</h4><p></p><br><h4>10. Tables</h4><p></p><br><h4>11. Pivot Tables</h4><p></p><br><h4>12. Data Analysis</h4><p></p><br><h4>13. Graphs and Charts</h4><p></p><br><h4>14. Excel Web App</h4><p></p><br><h4>15. Course Conclusion</h4><p></p>

Learn and master Excel 2019 by learning advanced functions and formulas
Get beyond the basics and supercharge your current skill level in Excel. With this 9-hour, expert-led video training course, you'll gain an in-depth understanding of more advanced Excel features that delve into high-level consolidation, analysis and reporting of financial information.
Upon completion of this course, you'll be able to create charts that have an impact from databases that communicate data and financial records efficiently and effectively.
You will be able to report data in various formats including: tables, graphs and PivotTables. Once completed you'll have advanced understanding of Excel that will positively impact your professional capability.
All the codes and supporting files for this course are available at: https://github.com/PacktPublishing/Microsoft-Excel-Advanced-2019
What You Will Learn
What s new/different in Excel 2019
Advanced charting and graphing in Excel
How to use detailed formatting tools
Lookup and advanced lookup functions
Financial functions including calculating interest and depreciation
Statistical functions
Connecting to other workbooks and datasets outside of Excel e.g. MS Access and the web.
How to create awesome visualizations using sparklines and data bars
Mastery of PivotTables and Pivot Charts
Scenario Manager, Goal Seek, and Solver
Advanced charts such as Surface, Radar, Bubble and Stock Charts
Audience
This course is designed for those who have basic knowledge of Excel 2019/365 and those upgrading from previous software versions
Approach
A complete course packed with Quiz, Working examples, Exercise and demo files. 
Key Features
Learn and understand advanced Excel features that delve into high-level consolidation, analysis, and reporting of financial information * Learn and master advanced charting and graphing in Excel
Github Repo
https://github.com/packtpublishing/microsoft-excel-advanced-2019
About the Author
Simon Sez IT
Simon Sez IT has offered technical courses for individuals, small businesses, and Fortune 500 companies since 2008, with thousands of employees who can benefit from the easy-to-learn and hands-on software training. It offers over 8,000 video tutorials on a range of software programs. Simon Sez IT ensures stress-free eLearning and enhanced employee productivity-whether you implement new software or a technological upgrade in your work environment. With over 600,000 students from 180 countries, Simon Sez IT is the preferred online learning choice for individuals and businesses worldwide.
Course Outline
1. Introduction to Excel 2016 Advanced Course

2. Functions

3. Date and Time Functions

4. Text Functions

5. Logical Functions

6. Lookup Functions

7. Financial Functions

8. Statistical Functions

9. Connecting to External Data

10. Tables

11. Pivot Tables

12. Data Analysis

13. Graphs and Charts

14. Excel Web App

15. Course Conclusion


Programming

Learn and master Excel 2019 by learning advanced functions and formulas

Microsoft Excel Advanced 2019

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

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

IIL Europe Ltd

Microsoft 365

Microsoft Virtual Academy (MVA)

Microsoft AZ-303

Microsoft Excel in Depth (Virtual)

<strong>Discover Excel 2019 and become confident in using spreadsheets</strong>
        <p>This 7-hour Microsoft Excel 2019 course is perfect for those brand new to Excel and who are using Excel 2019 or Excel 365 editions. In this course, your expert author gives you a solid grounding in the basics of Excel and guides you towards becoming more confident with spreadsheets.
All the codes and supporting files for this course are available at: https://github.com/PacktPublishing/Microsoft-Excel-Beginners-2019</p>
        <h2>What You Will Learn</h2><p>What s new in Excel 2019<br>Creating workbooks<br>Entering text, numbers and working with dates<br>Navigating workbooks<br>Page setup and print options<br>Working with rows, columns and cells<br>Cut, Copy and Paste<br>Introduction to functions and formulas<br>Formatting in Excel, including formatting cells and numbers<br>Creating charts and graphs<br>Sorting and Filtering<br>Introduction to PivotTables<br>Logical and lookup formulas - the basics<br></p>
        <h2>Audience</h2><p>This course is designed for those who are new to Excel and who are using Excel 2019 or Excel 365 editions.</p>
        <h2>Approach</h2><p>A complete course packed with step-by-step instructions, working examples, and helpful advice. This course is clearly divided into small parts that will help you understand each part individually and help you learn at your own pace.<br></p>
        <h2>Key Features</h2><p>Learn Excel 2019 with practice exercises * Learn Creating workbooks, Entering text, numbers, Creating charts and graphs and lot more in this practical course </p>
        <h2>Github Repo</h2><p>https://github.com/packtpublishing/microsoft-excel-beginners-2019</p>
        <h2>About the Author</h2><h3>Simon Sez IT</h3><p>Simon Sez IT has offered technical courses for individuals, small businesses, and Fortune 500 companies since 2008, with thousands of employees who can benefit from the easy-to-learn and hands-on software training. It offers over 8,000 video tutorials on a range of software programs.

Simon Sez IT ensures stress-free eLearning and enhanced employee productivity-whether you implement new software or a technological upgrade in your work environment. With over 600,000 students from 180 countries, Simon Sez IT is the preferred online learning choice for individuals and businesses worldwide.</p>
        <h2>Course Outline</h2><h4>1. Intro to Excel</h4><p>This section introduces Excel. This includes lectures on Mouse-Features, Back Stage view, Overview of Excel window and so on.</p><table width='100%'><tbody><tr><td style='padding: 15px;'><p>1. Intro to Excel</p><p style='margin: 0'>Intro to Excel: Intro to Excel</p></td></tr><tr><td style='padding: 15px;'><p>2. What's New In Excel 2019</p><p style='margin: 0'>Intro to Excel: What's New In Excel 2019</p></td></tr><tr><td style='padding: 15px;'><p>3. Course Overview</p><p style='margin: 0'>Intro to Excel: Course Overview</p></td></tr><tr><td style='padding: 15px;'><p>4. Overview of the Excel window</p><p style='margin: 0'>Intro to Excel: Overview of the Excel window</p></td></tr><tr><td style='padding: 15px;'><p>5. Mouse-Features</p><p style='margin: 0'>Intro to Excel: Mouse-Features</p></td></tr><tr><td style='padding: 15px;'><p>6. Back Stage View</p><p style='margin: 0'>Intro to Excel: Back Stage View</p></td></tr></tbody></table><br><h4>2. Creating Workbooks</h4><p>This section shows how to create workbook. You will learn how to create basic formulas, Relative references, Order of operations, Working with Ranges and so on.</p><table width='100%'><tbody><tr><td style='padding: 15px;'><p>1. Entering Text and Numbers</p><p style='margin: 0'>Creating Workbooks: Entering Text and Numbers</p></td></tr><tr><td style='padding: 15px;'><p>2. Creating Basic Formulas</p><p style='margin: 0'>Creating Workbooks: Creating Basic Formulas</p></td></tr><tr><td style='padding: 15px;'><p>3. Relative References</p><p style='margin: 0'>Creating Workbooks: Relative References</p></td></tr><tr><td style='padding: 15px;'><p>4. Order of Operations</p><p style='margin: 0'>Creating Workbooks: Order of Operations</p></td></tr><tr><td style='padding: 15px;'><p>5. Working with Ranges</p><p style='margin: 0'>Creating Workbooks: Working with Ranges</p></td></tr><tr><td style='padding: 15px;'><p>6. Module 2 - Practice Exercise</p><p style='margin: 0'>Creating Workbooks: Module 2 - Practice Exercise</p></td></tr></tbody></table><br><h4>3. Saving Workbooks</h4><p>This section shows how to save workbooks.</p><table width='100%'><tbody><tr><td style='padding: 15px;'><p>1. Working with the Save and Save As Commands</p><p style='margin: 0'>Saving Workbooks: Working with the Save and Save As Commands</p></td></tr><tr><td style='padding: 15px;'><p>2. File Extensions, Share, Export and Publish Files</p><p style='margin: 0'>Saving Workbooks: File Extensions, Share, Export and Publish Files</p></td></tr><tr><td style='padding: 15px;'><p>3. Module 3 - Practice Exercise</p><p style='margin: 0'>Saving Workbooks: Module 3 - Practice Exercise</p></td></tr></tbody></table><br><h4>4. Navigating Workbooks</h4><p>This section shows Opening a File, Freeze Panes Option, Split Screen Option and so on.</p><table width='100%'><tbody><tr><td style='padding: 15px;'><p>1. Opening a File</p><p style='margin: 0'>Navigating Workbooks: Opening a File</p></td></tr><tr><td style='padding: 15px;'><p>2. Working with Larger Files</p><p style='margin: 0'>Navigating Workbooks: Working with Larger Files</p></td></tr><tr><td style='padding: 15px;'><p>3. Freeze Panes Option</p><p style='margin: 0'>Navigating Workbooks: Freeze Panes Option</p></td></tr><tr><td style='padding: 15px;'><p>4. Split Screen Option</p><p style='margin: 0'>Navigating Workbooks: Split Screen Option</p></td></tr><tr><td style='padding: 15px;'><p>5. Module 4 - Practice Exercise</p><p style='margin: 0'>Navigating Workbooks: Module 4 - Practice Exercise</p></td></tr></tbody></table><br><h4>5. Page Setup & Print Options</h4><p>You will learn about Page Setup & Print Options here.</p><table width='100%'><tbody><tr><td style='padding: 15px;'><p>1. Headers and Footers</p><p style='margin: 0'>Page Setup & Print Options: Headers and Footers</p></td></tr><tr><td style='padding: 15px;'><p>2. Print Titles</p><p style='margin: 0'>Page Setup & Print Options: Print Titles</p></td></tr><tr><td style='padding: 15px;'><p>3. Comments</p><p style='margin: 0'>Page Setup & Print Options: Comments</p></td></tr><tr><td style='padding: 15px;'><p>4. Page Setup Options</p><p style='margin: 0'>Page Setup & Print Options: Page Setup Options</p></td></tr><tr><td style='padding: 15px;'><p>5. Fit to Print on One Page</p><p style='margin: 0'>Page Setup & Print Options: Fit to Print on One Page</p></td></tr><tr><td style='padding: 15px;'><p>6. Printing Workbooks</p><p style='margin: 0'>Page Setup & Print Options: Printing Workbooks</p></td></tr><tr><td style='padding: 15px;'><p>7. Module 5 - Practice Exercise</p><p style='margin: 0'>Page Setup & Print Options: Module 5 - Practice Exercise</p></td></tr></tbody></table><br><h4>6. Working with Rows, Columns and Cells</h4><p>This section shows adding and deleting rows columns and cells, changing Column and Row widths etc.</p><table width='100%'><tbody><tr><td style='padding: 15px;'><p>1. Adding and deleting rows columns and cells</p><p style='margin: 0'>Working with Rows, Columns and Cells: Adding and deleting rows columns and cells</p></td></tr><tr><td style='padding: 15px;'><p>2. Changing Column and-Row Widths</p><p style='margin: 0'>Working with Rows, Columns and Cells: Changing Column and-Row Widths</p></td></tr><tr><td style='padding: 15px;'><p>3. Module 6 - Practice Exercise</p><p style='margin: 0'>Working with Rows, Columns and Cells: Module 6 - Practice Exercise</p></td></tr></tbody></table><br><h4>7. Moving Data</h4><p>This section is about moving data. You will learn about Copying formula, how to cut, copy, paste here.</p><table width='100%'><tbody><tr><td style='padding: 15px;'><p>1. Cut Copy and Paste</p><p style='margin: 0'>Moving Data: Cut Copy and Paste</p></td></tr><tr><td style='padding: 15px;'><p>2. Copying Formulas</p><p style='margin: 0'>Moving Data: Copying Formulas</p></td></tr><tr><td style='padding: 15px;'><p>3. Module 7 - Practice Exercise</p><p style='margin: 0'>Moving Data: Module 7 - Practice Exercise</p></td></tr></tbody></table><br><h4>8. Formulas & Functions</h4><p>This section gives an overview of Formulas, how to create formulas using functions, Absolute values and so on.</p><table width='100%'><tbody><tr><td style='padding: 15px;'><p>1. Overview of Formulas</p><p style='margin: 0'>Formulas & Functions: Overview of Formulas</p></td></tr><tr><td style='padding: 15px;'><p>2. Create Formulas Using Functions part1</p><p style='margin: 0'>Formulas & Functions: Create Formulas Using Functions part1</p></td></tr><tr><td style='padding: 15px;'><p>3. Create Formulas Using Functions part 2</p><p style='margin: 0'>Formulas & Functions: Create Formulas Using Functions part 2</p></td></tr><tr><td style='padding: 15px;'><p>4. Absolute Values</p><p style='margin: 0'>Formulas & Functions: Absolute Values</p></td></tr><tr><td style='padding: 15px;'><p>5. Module 8 - Practice Exercise</p><p style='margin: 0'>Formulas & Functions: Module 8 - Practice Exercise</p></td></tr></tbody></table><br><h4>9. Working with Sheets</h4><p>In this section, you will learn about working with sheets. Learn how to add, delete, rename sheets, Dimensional formulas and so on.</p><table width='100%'><tbody><tr><td style='padding: 15px;'><p>1. Adding Deleting and Renaming Sheets</p><p style='margin: 0'>Working with Sheets: Adding Deleting and Renaming Sheets</p></td></tr><tr><td style='padding: 15px;'><p>2. Additional Sheet Tab Options</p><p style='margin: 0'>Working with Sheets: Adding Deleting and Renaming Sheets</p></td></tr><tr><td style='padding: 15px;'><p>3. 3 Dimensional Formulas</p><p style='margin: 0'>Working with Sheets: 3 Dimensional Formulas</p></td></tr><tr><td style='padding: 15px;'><p>4. Module 9 - Practice Exercise</p><p style='margin: 0'>Working with Sheets: Module 9 - Practice Exercise</p></td></tr></tbody></table><br><h4>10. Formatting Worksheets</h4><p>In this section, you will learn about Formatting Worksheets.</p><table width='100%'><tbody><tr><td style='padding: 15px;'><p>1. Formatting Cells part 1</p><p style='margin: 0'>Formatting Worksheets: Formatting Cells part 1</p></td></tr><tr><td style='padding: 15px;'><p>2. Formatting Cells part 2</p><p style='margin: 0'>Formatting Worksheets: Formatting Cells part 2</p></td></tr><tr><td style='padding: 15px;'><p>3. Formatting Numbers</p><p style='margin: 0'>Formatting Worksheets: Formatting Numbers</p></td></tr><tr><td style='padding: 15px;'><p>4. Borders and Shading</p><p style='margin: 0'>Formatting Worksheets: Borders and Shading</p></td></tr><tr><td style='padding: 15px;'><p>5. Format as Table</p><p style='margin: 0'>Formatting Worksheets: Format as Table</p></td></tr><tr><td style='padding: 15px;'><p>6. Using Styles</p><p style='margin: 0'>Formatting Worksheets: Using Styles</p></td></tr><tr><td style='padding: 15px;'><p>7. Using Format Painter</p><p style='margin: 0'>Formatting Worksheets: Using Format Painter</p></td></tr><tr><td style='padding: 15px;'><p>8. Protecting Sheets</p><p style='margin: 0'>Formatting Worksheets: Protecting Sheets</p></td></tr><tr><td style='padding: 15px;'><p>9. Fill Handle and Custom Lists</p><p style='margin: 0'>Formatting Worksheets: Fill Handle and Custom Lists</p></td></tr><tr><td style='padding: 15px;'><p>10. Module 10 - Practice Exercise</p><p style='margin: 0'>Formatting Worksheets: Module 10 - Practice Exercise</p></td></tr></tbody></table><br><h4>11. Charts</h4><p>Learn about Charts, types of charts, how to edit charts, Linking chart titles and etc here.</p><table width='100%'><tbody><tr><td style='padding: 15px;'><p>1. Creating Charts</p><p style='margin: 0'>Charts: Creating Charts</p></td></tr><tr><td style='padding: 15px;'><p>2. Types of Charts</p><p style='margin: 0'>Charts: Types of Charts</p></td></tr><tr><td style='padding: 15px;'><p>3. Editing Charts Part 1</p><p style='margin: 0'>Charts: Editing Charts Part 1</p></td></tr><tr><td style='padding: 15px;'><p>4. Editing Charts Part 2</p><p style='margin: 0'>Charts: Editing Charts Part 2</p></td></tr><tr><td style='padding: 15px;'><p>5. Using Graphics to Enhance Charts</p><p style='margin: 0'>Charts: Using Graphics to Enhance Charts</p></td></tr><tr><td style='padding: 15px;'><p>6. Linking Chart Titles</p><p style='margin: 0'>Charts: Linking Chart Titles</p></td></tr><tr><td style='padding: 15px;'><p>7. Module 11 - Practice Exercise</p><p style='margin: 0'>Charts: Module 11 - Practice Exercise</p></td></tr></tbody></table><br><h4>12. Working with Names</h4><p>This section is shows creating Range names, Managing Names etc.</p><table width='100%'><tbody><tr><td style='padding: 15px;'><p>1. Creating Range Names</p><p style='margin: 0'>Working with Names: Creating Range Names</p></td></tr><tr><td style='padding: 15px;'><p>2. Managing Names</p><p style='margin: 0'>Working with Names: Managing Names</p></td></tr><tr><td style='padding: 15px;'><p>3. Using Names in Formulas</p><p style='margin: 0'>Working with Names: Using Names in Formulas</p></td></tr><tr><td style='padding: 15px;'><p>4. Module 12 - Practice Exercise</p><p style='margin: 0'>Working with Names: Module 12 - Practice Exercise</p></td></tr></tbody></table><br><h4>13. Sorting and Filtering</h4><p>Learn about Sorting and Filtering here. You will learn how to remove duplicates, sort data, filter data and so on.</p><table width='100%'><tbody><tr><td style='padding: 15px;'><p>1. Remove Duplicates</p><p style='margin: 0'>Sorting and Filtering: Remove Duplicates</p></td></tr><tr><td style='padding: 15px;'><p>2. Sort Data</p><p style='margin: 0'>Sorting and Filtering: Sort Data</p></td></tr><tr><td style='padding: 15px;'><p>3. Filter Data</p><p style='margin: 0'>Sorting and Filtering: Filter Data</p></td></tr><tr><td style='padding: 15px;'><p>4. Advanced Filters</p><p style='margin: 0'>Sorting and Filtering: Advanced Filters</p></td></tr><tr><td style='padding: 15px;'><p>5. Module 13 - Practice Exercise</p><p style='margin: 0'>Sorting and Filtering: Module 13 - Practice Exercise</p></td></tr></tbody></table><br><h4>14. Outlining and Subtotaling</h4><p>This section shows how to create an outline, Subtotals etc.</p><table width='100%'><tbody><tr><td style='padding: 15px;'><p>1. Creating an Outline</p><p style='margin: 0'>Outlining and Subtotaling: Creating an Outline</p></td></tr><tr><td style='padding: 15px;'><p>2. Subtotals</p><p style='margin: 0'>Outlining and Subtotaling: Subtotals</p></td></tr><tr><td style='padding: 15px;'><p>3. Module 14 - Practice Exercise</p><p style='margin: 0'>Outlining and Subtotaling: Module 14 - Practice Exercise</p></td></tr></tbody></table><br><h4>15. Working with Views</h4><p>Learn how to work with views here. This shows how to arrange files, Custom views etc.</p><table width='100%'><tbody><tr><td style='padding: 15px;'><p>1. Arranging Files</p><p style='margin: 0'>Working with Views: Arranging Files</p></td></tr><tr><td style='padding: 15px;'><p>2. New Window Option</p><p style='margin: 0'>Working with Views: New Window Option</p></td></tr><tr><td style='padding: 15px;'><p>3. Custom Views</p><p style='margin: 0'>Working with Views: Custom Views</p></td></tr><tr><td style='padding: 15px;'><p>4. Module 15 - Practice Exercise</p><p style='margin: 0'>Working with Views: Module 15 - Practice Exercise</p></td></tr></tbody></table><br><h4>16. Linking Files</h4><p>This section shows how to create formulas between files, how to work with links and so on.</p><table width='100%'><tbody><tr><td style='padding: 15px;'><p>1. Creating Formulas Between Files</p><p style='margin: 0'>Linking Files: Creating Formulas Between Files</p></td></tr><tr><td style='padding: 15px;'><p>2. Working with Links</p><p style='margin: 0'>Linking Files: Working with Links</p></td></tr><tr><td style='padding: 15px;'><p>3. Consolidating Data</p><p style='margin: 0'>Linking Files: Consolidating Data</p></td></tr><tr><td style='padding: 15px;'><p>4. Module 16 - Practice Exercise</p><p style='margin: 0'>Linking Files: Module 16 - Practice Exercise</p></td></tr></tbody></table><br><h4>17. Advanced Formula Creation</h4><p>This section deals with Advanced Formula creation.</p><table width='100%'><tbody><tr><td style='padding: 15px;'><p>1. If Statements</p><p style='margin: 0'>Advanced Formula Creation: If Statements</p></td></tr><tr><td style='padding: 15px;'><p>2. VLookups</p><p style='margin: 0'>Advanced Formula Creation: VLookups</p></td></tr><tr><td style='padding: 15px;'><p>3. Data Validation</p><p style='margin: 0'>Advanced Formula Creation: Data Validation</p></td></tr><tr><td style='padding: 15px;'><p>4. Formula Auditing</p><p style='margin: 0'>Advanced Formula Creation: Formula Auditing</p></td></tr><tr><td style='padding: 15px;'><p>5. Module 17 - Practice Exercise</p><p style='margin: 0'>Advanced Formula Creation: Module 17 - Practice Exercise</p></td></tr></tbody></table><br><h4>18. PivotTables</h4><p>Learn about PivotTables, Pivot Charts here.</p><table width='100%'><tbody><tr><td style='padding: 15px;'><p>1. PivotTables</p><p style='margin: 0'>PivotTables: PivotTables</p></td></tr><tr><td style='padding: 15px;'><p>2. Pivot Charts</p><p style='margin: 0'>PivotTables: Pivot Charts</p></td></tr><tr><td style='padding: 15px;'><p>3. Module 18 - Practice Exercise</p><p style='margin: 0'>PivotTables: Module 18 - Practice Exercise</p></td></tr></tbody></table><br><h4>19. Additional Excel Features</h4><p>This section deals with the Additional Excel Features here. Learn about Slicers, Goal Seeker, Text to Columns etc.</p><table width='100%'><tbody><tr><td style='padding: 15px;'><p>1. Slicers</p><p style='margin: 0'>Additional Excel Features: Slicers</p></td></tr><tr><td style='padding: 15px;'><p>2. Goal Seeker</p><p style='margin: 0'>Additional Excel Features: Goal Seeker</p></td></tr><tr><td style='padding: 15px;'><p>3. Text to Columns</p><p style='margin: 0'>Additional Excel Features: Text to Columns</p></td></tr><tr><td style='padding: 15px;'><p>4. Watch Window</p><p style='margin: 0'>Additional Excel Features: Watch Window</p></td></tr><tr><td style='padding: 15px;'><p>5. Customizing Ribbons and Tabs</p><p style='margin: 0'>Additional Excel Features: Customizing Ribbons and Tabs</p></td></tr><tr><td style='padding: 15px;'><p>6. Module 18 - Practice Exercise</p><p style='margin: 0'>Additional Excel Features: Module 18 - Practice Exercise</p></td></tr></tbody></table><br><h4>20. Shortcuts</h4><p>This section deals with Excel Shortcuts which every user should know.</p><table width='100%'><tbody><tr><td style='padding: 15px;'><p>1. Excel Shortcuts Every User Should Know</p><p style='margin: 0'>Shortcuts: Excel Shortcuts Every User Should Know</p></td></tr></tbody></table><br><h4>21. Closing</h4><p>This is the closing section which wraps the course.</p><table width='100%'><tbody><tr><td style='padding: 15px;'><p>1. Closing Video</p><p style='margin: 0'>Closing: Closing Video</p></td></tr></tbody></table>

Discover Excel 2019 and become confident in using spreadsheets
This 7-hour Microsoft Excel 2019 course is perfect for those brand new to Excel and who are using Excel 2019 or Excel 365 editions. In this course, your expert author gives you a solid grounding in the basics of Excel and guides you towards becoming more confident with spreadsheets.
All the codes and supporting files for this course are available at: https://github.com/PacktPublishing/Microsoft-Excel-Beginners-2019
What You Will Learn
What s new in Excel 2019
Creating workbooks
Entering text, numbers and working with dates
Navigating workbooks
Page setup and print options
Working with rows, columns and cells
Cut, Copy and Paste
Introduction to functions and formulas
Formatting in Excel, including formatting cells and numbers
Creating charts and graphs
Sorting and Filtering
Introduction to PivotTables
Logical and lookup formulas - the basics

Audience
This course is designed for those who are new to Excel and who are using Excel 2019 or Excel 365 editions.
Approach
A complete course packed with step-by-step instructions, working examples, and helpful advice. This course is clearly divided into small parts that will help you understand each part individually and help you learn at your own pace.

Key Features
Learn Excel 2019 with practice exercises * Learn Creating workbooks, Entering text, numbers, Creating charts and graphs and lot more in this practical course 
Github Repo
https://github.com/packtpublishing/microsoft-excel-beginners-2019
About the Author
Simon Sez IT
Simon Sez IT has offered technical courses for individuals, small businesses, and Fortune 500 companies since 2008, with thousands of employees who can benefit from the easy-to-learn and hands-on software training. It offers over 8,000 video tutorials on a range of software programs. Simon Sez IT ensures stress-free eLearning and enhanced employee productivity-whether you implement new software or a technological upgrade in your work environment. With over 600,000 students from 180 countries, Simon Sez IT is the preferred online learning choice for individuals and businesses worldwide.
Course Outline
1. Intro to Excel
This section introduces Excel. This includes lectures on Mouse-Features, Back Stage view, Overview of Excel window and so on.
1. Intro to Excel
Intro to Excel: Intro to Excel
2. What's New In Excel 2019
Intro to Excel: What's New In Excel 2019
3. Course Overview
Intro to Excel: Course Overview
4. Overview of the Excel window
Intro to Excel: Overview of the Excel window
5. Mouse-Features
Intro to Excel: Mouse-Features
6. Back Stage View
Intro to Excel: Back Stage View
2. Creating Workbooks
This section shows how to create workbook. You will learn how to create basic formulas, Relative references, Order of operations, Working with Ranges and so on.
1. Entering Text and Numbers
Creating Workbooks: Entering Text and Numbers
2. Creating Basic Formulas
Creating Workbooks: Creating Basic Formulas
3. Relative References
Creating Workbooks: Relative References
4. Order of Operations
Creating Workbooks: Order of Operations
5. Working with Ranges
Creating Workbooks: Working with Ranges
6. Module 2 - Practice Exercise
Creating Workbooks: Module 2 - Practice Exercise
3. Saving Workbooks
This section shows how to save workbooks.
1. Working with the Save and Save As Commands
Saving Workbooks: Working with the Save and Save As Commands
2. File Extensions, Share, Export and Publish Files
Saving Workbooks: File Extensions, Share, Export and Publish Files
3. Module 3 - Practice Exercise
Saving Workbooks: Module 3 - Practice Exercise
4. Navigating Workbooks
This section shows Opening a File, Freeze Panes Option, Split Screen Option and so on.
1. Opening a File
Navigating Workbooks: Opening a File
2. Working with Larger Files
Navigating Workbooks: Working with Larger Files
3. Freeze Panes Option
Navigating Workbooks: Freeze Panes Option
4. Split Screen Option
Navigating Workbooks: Split Screen Option
5. Module 4 - Practice Exercise
Navigating Workbooks: Module 4 - Practice Exercise
5. Page Setup & Print Options
You will learn about Page Setup & Print Options here.
1. Headers and Footers
Page Setup & Print Options: Headers and Footers
2. Print Titles
Page Setup & Print Options: Print Titles
3. Comments
Page Setup & Print Options: Comments
4. Page Setup Options
Page Setup & Print Options: Page Setup Options
5. Fit to Print on One Page
Page Setup & Print Options: Fit to Print on One Page
6. Printing Workbooks
Page Setup & Print Options: Printing Workbooks
7. Module 5 - Practice Exercise
Page Setup & Print Options: Module 5 - Practice Exercise
6. Working with Rows, Columns and Cells
This section shows adding and deleting rows columns and cells, changing Column and Row widths etc.
1. Adding and deleting rows columns and cells
Working with Rows, Columns and Cells: Adding and deleting rows columns and cells
2. Changing Column and-Row Widths
Working with Rows, Columns and Cells: Changing Column and-Row Widths
3. Module 6 - Practice Exercise
Working with Rows, Columns and Cells: Module 6 - Practice Exercise
7. Moving Data
This section is about moving data. You will learn about Copying formula, how to cut, copy, paste here.
1. Cut Copy and Paste
Moving Data: Cut Copy and Paste
2. Copying Formulas
Moving Data: Copying Formulas
3. Module 7 - Practice Exercise
Moving Data: Module 7 - Practice Exercise
8. Formulas & Functions
This section gives an overview of Formulas, how to create formulas using functions, Absolute values and so on.
1. Overview of Formulas
Formulas & Functions: Overview of Formulas
2. Create Formulas Using Functions part1
Formulas & Functions: Create Formulas Using Functions part1
3. Create Formulas Using Functions part 2
Formulas & Functions: Create Formulas Using Functions part 2
4. Absolute Values
Formulas & Functions: Absolute Values
5. Module 8 - Practice Exercise
Formulas & Functions: Module 8 - Practice Exercise
9. Working with Sheets
In this section, you will learn about working with sheets. Learn how to add, delete, rename sheets, Dimensional formulas and so on.
1. Adding Deleting and Renaming Sheets
Working with Sheets: Adding Deleting and Renaming Sheets
2. Additional Sheet Tab Options
Working with Sheets: Adding Deleting and Renaming Sheets
3. 3 Dimensional Formulas
Working with Sheets: 3 Dimensional Formulas
4. Module 9 - Practice Exercise
Working with Sheets: Module 9 - Practice Exercise
10. Formatting Worksheets
In this section, you will learn about Formatting Worksheets.
1. Formatting Cells part 1
Formatting Worksheets: Formatting Cells part 1
2. Formatting Cells part 2
Formatting Worksheets: Formatting Cells part 2
3. Formatting Numbers
Formatting Worksheets: Formatting Numbers
4. Borders and Shading
Formatting Worksheets: Borders and Shading
5. Format as Table
Formatting Worksheets: Format as Table
6. Using Styles
Formatting Worksheets: Using Styles
7. Using Format Painter
Formatting Worksheets: Using Format Painter
8. Protecting Sheets
Formatting Worksheets: Protecting Sheets
9. Fill Handle and Custom Lists
Formatting Worksheets: Fill Handle and Custom Lists
10. Module 10 - Practice Exercise
Formatting Worksheets: Module 10 - Practice Exercise
11. Charts
Learn about Charts, types of charts, how to edit charts, Linking chart titles and etc here.
1. Creating Charts
Charts: Creating Charts
2. Types of Charts
Charts: Types of Charts
3. Editing Charts Part 1
Charts: Editing Charts Part 1
4. Editing Charts Part 2
Charts: Editing Charts Part 2
5. Using Graphics to Enhance Charts
Charts: Using Graphics to Enhance Charts
6. Linking Chart Titles
Charts: Linking Chart Titles
7. Module 11 - Practice Exercise
Charts: Module 11 - Practice Exercise
12. Working with Names
This section is shows creating Range names, Managing Names etc.
1. Creating Range Names
Working with Names: Creating Range Names
2. Managing Names
Working with Names: Managing Names
3. Using Names in Formulas
Working with Names: Using Names in Formulas
4. Module 12 - Practice Exercise
Working with Names: Module 12 - Practice Exercise
13. Sorting and Filtering
Learn about Sorting and Filtering here. You will learn how to remove duplicates, sort data, filter data and so on.
1. Remove Duplicates
Sorting and Filtering: Remove Duplicates
2. Sort Data
Sorting and Filtering: Sort Data
3. Filter Data
Sorting and Filtering: Filter Data
4. Advanced Filters
Sorting and Filtering: Advanced Filters
5. Module 13 - Practice Exercise
Sorting and Filtering: Module 13 - Practice Exercise
14. Outlining and Subtotaling
This section shows how to create an outline, Subtotals etc.
1. Creating an Outline
Outlining and Subtotaling: Creating an Outline
2. Subtotals
Outlining and Subtotaling: Subtotals
3. Module 14 - Practice Exercise
Outlining and Subtotaling: Module 14 - Practice Exercise
15. Working with Views
Learn how to work with views here. This shows how to arrange files, Custom views etc.
1. Arranging Files
Working with Views: Arranging Files
2. New Window Option
Working with Views: New Window Option
3. Custom Views
Working with Views: Custom Views
4. Module 15 - Practice Exercise
Working with Views: Module 15 - Practice Exercise
16. Linking Files
This section shows how to create formulas between files, how to work with links and so on.
1. Creating Formulas Between Files
Linking Files: Creating Formulas Between Files
2. Working with Links
Linking Files: Working with Links
3. Consolidating Data
Linking Files: Consolidating Data
4. Module 16 - Practice Exercise
Linking Files: Module 16 - Practice Exercise
17. Advanced Formula Creation
This section deals with Advanced Formula creation.
1. If Statements
Advanced Formula Creation: If Statements
2. VLookups
Advanced Formula Creation: VLookups
3. Data Validation
Advanced Formula Creation: Data Validation
4. Formula Auditing
Advanced Formula Creation: Formula Auditing
5. Module 17 - Practice Exercise
Advanced Formula Creation: Module 17 - Practice Exercise
18. PivotTables
Learn about PivotTables, Pivot Charts here.
1. PivotTables
PivotTables: PivotTables
2. Pivot Charts
PivotTables: Pivot Charts
3. Module 18 - Practice Exercise
PivotTables: Module 18 - Practice Exercise
19. Additional Excel Features
This section deals with the Additional Excel Features here. Learn about Slicers, Goal Seeker, Text to Columns etc.
1. Slicers
Additional Excel Features: Slicers
2. Goal Seeker
Additional Excel Features: Goal Seeker
3. Text to Columns
Additional Excel Features: Text to Columns
4. Watch Window
Additional Excel Features: Watch Window
5. Customizing Ribbons and Tabs
Additional Excel Features: Customizing Ribbons and Tabs
6. Module 18 - Practice Exercise
Additional Excel Features: Module 18 - Practice Exercise
20. Shortcuts
This section deals with Excel Shortcuts which every user should know.
1. Excel Shortcuts Every User Should Know
Shortcuts: Excel Shortcuts Every User Should Know
21. Closing
This is the closing section which wraps the course.
1. Closing Video
Closing: Closing Video

Discover Excel 2019 and become confident in using spreadsheets

Microsoft Excel Beginners 2019

<p>Tired of searching and accumulating all the relevant courses for this specific field? It takes a substantial amount of your time and, more importantly, costs you a fortune! Well, we have just come up with the ultimate solution for you by giving this all-inclusive Ms Excel: Excel PowerQuery and PowerPivot mega bundle.</p><p>This 40 courses mega bundle keeps you up-to-date in this field and takes you one step ahead of others. Keeping in mind the latest advancements in this ever-emerging sector, the Ms Excel: Excel PowerQuery and PowerPivot bundle covers all the state-of-the-art tools and techniques required to become a competent worker in this area.</p><p>You will encounter specific courses relevant to the sector. We take you from the most introductory fundamentals to advance knowledge in a step-by-step manner. In addition, the Ms Excel: Excel PowerQuery and PowerPivot bundle also consists of courses related to some soft skills that you will need to succeed in any industry or job sector.</p><p><strong>This </strong><strong>Ms Excel: Excel PowerQuery and PowerPivot </strong><strong>Bundle consists of the following premium courses:</strong></p><ul><li>Course 01: Microsoft Excel Level 3</li><li>Course 02: New Functions in Microsoft Excel 2021</li><li>Course 03: Microsoft Excel: Automated Dashboard Using Advanced Formula, VBA, Power Query</li><li>Course 04: Microsoft Excel: Excel Sheet Comparison with VBA</li><li>Course 05: Microsoft Excel: Master Power Query in 120 Minutes!</li><li>Course 06: Excel: Top 50 Microsoft Excel Formulas in 50 Minutes!</li><li>Course 07: Excel Pivot Tables</li><li>Course 08: Data Analysis in Microsoft Excel Complete Training</li><li>Course 09: Excel Must know Formulas and Functions</li><li>Course 10: Excel spreadsheet for Beginner</li><li>Course 11: Excel Data Analysis</li><li>Course 12: Excel Vlookup, Xlookup, Match and Index</li><li>Course 13: Excel Pivot Tables, Pivot Charts, Slicers, and Timelines</li><li>Course 14: MS Word Diploma</li><li>Course 15: Proofreading &amp; Copyediting</li><li>Course 16: PowerPoint Diploma</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><li>Course 21: The Complete Microsoft Outlook Masterclass</li><li>Course 22: Microsoft Access Complete Course (Beginner, Intermediate, Advanced)</li><li>Course 23: Microsoft Access Tables and Queries</li><li>Course 24: Microsoft Access Databases Forms and Reports</li><li>Course 25: Microsoft Teams</li><li>Course 26: Planning &amp; Control Using Microsoft Project 2013, 2016 &amp; 2019</li><li>Course 27: Data Protection and Data Security Level 2</li><li>Course 28: Office Skills and Administration Management Diploma</li><li>Course 29: Touch Typing Essentials</li><li>Course 30: Document Control</li></ul><p><strong>Moreover, this bundles include 10 career-focused courses:</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><li>Course 06: Business English Perfection Course</li><li>Course 07: Networking Skills for Personal Success</li><li>Course 08: Boost Your Confidence and Self-Esteem</li><li>Course 09: Public Speaking Training</li><li>Course 10: Learn to Fight Procrastination</li></ul><p>Our cutting-edge learning package offers top-notch digital aid and first-rate tutor support. You will acquire the crucial hard and soft skills needed for career advancement because this bundle has been thoroughly examined and is career-friendly. So don't overthink! Enrol today.</p><p><strong>Learning Outcomes</strong></p><p>This unique Ms Excel: Excel PowerQuery and PowerPivot mega bundle will help you to-</p><ul><li>Quench your thirst for knowledge</li><li>Be up-to-date about the latest advancements</li><li>Achieve your dream career goal in this sector</li><li>Know the applicable rules and regulations needed for a professional in this area</li><li>Acquire some valuable knowledge related to Ms Excel: Excel PowerQuery and PowerPivot to uplift your morale</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 expertise and essential knowledge, which will assist you in reaching your goal. Moreover, you can learn from any place in your own time without travelling for classes.</p><p><strong>Certificate:</strong></p><ul><li><strong>PDF Certificate: Free for all </strong><strong>40</strong><strong> courses</strong></li><li><strong>Hard Copy Certificate: Free (For The Title Course: Previously it was £10)</strong></li></ul><h2>
        
        <div>CPD</div>
    </h2>

                        <div id="cpd">
                            <div>
                                <div>
                                    <div>
                                        400 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 Ms Excel: Excel PowerQuery and PowerPivot bundle is designed to assist anyone with a curious mind, anyone looking to boost their CVs or individuals looking to upgrade their career to the next level can also benefit from the learning materials.</p>
                        </div><h2>
        
        <div>Requirements</div>
    </h2>

                        <div id="requirements">
                            <p>The courses in this bundle has been designed to be fully compatible with tablets and smartphones.</p>
                        </div><h2>
        
        <div>Career path</div>
    </h2>

                        <div id="career_path">
                            <p>This Ms Excel: Excel PowerQuery and PowerPivot bundle will give you an edge over other competitors and will open the doors for you to a plethora of career opportunities.</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>Microsoft Excel Level 3</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>

Tired of searching and accumulating all the relevant courses for this specific field? It takes a substantial amount of your time and, more importantly, costs you a fortune! Well, we have just come up with the ultimate solution for you by giving this all-inclusive Ms Excel: Excel PowerQuery and PowerPivot mega bundle.
This 40 courses mega bundle keeps you up-to-date in this field and takes you one step ahead of others. Keeping in mind the latest advancements in this ever-emerging sector, the Ms Excel: Excel PowerQuery and PowerPivot bundle covers all the state-of-the-art tools and techniques required to become a competent worker in this area.
You will encounter specific courses relevant to the sector. We take you from the most introductory fundamentals to advance knowledge in a step-by-step manner. In addition, the Ms Excel: Excel PowerQuery and PowerPivot bundle also consists of courses related to some soft skills that you will need to succeed in any industry or job sector.
This Ms Excel: Excel PowerQuery and PowerPivot Bundle consists of the following premium courses:
Course 01: Microsoft Excel Level 3
Course 02: New Functions in Microsoft Excel 2021
Course 03: Microsoft Excel: Automated Dashboard Using Advanced Formula, VBA, Power Query
Course 04: Microsoft Excel: Excel Sheet Comparison with VBA
Course 05: Microsoft Excel: Master Power Query in 120 Minutes!
Course 06: Excel: Top 50 Microsoft Excel Formulas in 50 Minutes!
Course 07: Excel Pivot Tables
Course 08: Data Analysis in Microsoft Excel Complete Training
Course 09: Excel Must know Formulas and Functions
Course 10: Excel spreadsheet for Beginner
Course 11: Excel Data Analysis
Course 12: Excel Vlookup, Xlookup, Match and Index
Course 13: Excel Pivot Tables, Pivot Charts, Slicers, and Timelines
Course 14: MS Word Diploma
Course 15: Proofreading & Copyediting
Course 16: PowerPoint Diploma
Course 17: PowerBI Formulas
Course 18: Outlook Tips and tricks
Course 19: Excel PowerQuery and PowerPivot
Course 20: Complete Microsoft Power BI 2021
Course 21: The Complete Microsoft Outlook Masterclass
Course 22: Microsoft Access Complete Course (Beginner, Intermediate, Advanced)
Course 23: Microsoft Access Tables and Queries
Course 24: Microsoft Access Databases Forms and Reports
Course 25: Microsoft Teams
Course 26: Planning & Control Using Microsoft Project 2013, 2016 & 2019
Course 27: Data Protection and Data Security Level 2
Course 28: Office Skills and Administration Management Diploma
Course 29: Touch Typing Essentials
Course 30: Document Control
Moreover, this bundles include 10 career-focused courses:
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
Course 06: Business English Perfection Course
Course 07: Networking Skills for Personal Success
Course 08: Boost Your Confidence and Self-Esteem
Course 09: Public Speaking Training
Course 10: Learn to Fight Procrastination
Our cutting-edge learning package offers top-notch digital aid and first-rate tutor support. You will acquire the crucial hard and soft skills needed for career advancement because this bundle has been thoroughly examined and is career-friendly. So don't overthink! Enrol today.
Learning Outcomes
This unique Ms Excel: Excel PowerQuery and PowerPivot mega bundle will help you to-
Quench your thirst for knowledge
Be up-to-date about the latest advancements
Achieve your dream career goal in this sector
Know the applicable rules and regulations needed for a professional in this area
Acquire some valuable knowledge related to Ms Excel: Excel PowerQuery and PowerPivot to uplift your morale
The bundle incorporates basic to advanced level skills to shed some light on your way and boost your career. Hence, you can strengthen your expertise and essential knowledge, which will assist you in reaching your goal. Moreover, you can learn from any place in your own time without travelling for classes.
Certificate:
PDF Certificate: Free for all 40 courses
Hard Copy Certificate: Free (For The Title Course: Previously it was £10)
 CPD 
400 CPD hours / points  Accredited by CPD Quality Standards
 Who is this course for? 
The Ms Excel: Excel PowerQuery and PowerPivot bundle is designed to assist anyone with a curious mind, anyone looking to boost their CVs or individuals looking to upgrade their career to the next level can also benefit from the learning materials.
 Requirements 
The courses in this bundle has been designed to be fully compatible with tablets and smartphones.
 Career path 
This Ms Excel: Excel PowerQuery and PowerPivot bundle will give you an edge over other competitors and will open the doors for you to a plethora of career opportunities.
 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 (Microsoft Excel Level 3) 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.

Apex Learning

Ms Excel: Excel PowerQuery and PowerPivot

Practical Excel training that will turn you into a certified Excel master





About course
Become a master of Excel
Learn how to use the crucial Excel functions and tools.
Learn from the experts
The course is conducted by an Excel specialist with many years of experience.
Test your knowledge
In the course, you will find tests and practical tasks to consolidate your knowledge and skills.
Do you want to master Excel quickly and efficiently?
We offer you a unique opportunity to learn all the features of Excel in just a couple of days. The course is purely practical and will teach you the most useful tools included in the app. Whether you do data modeling, work on databases or analysis and reporting, this practical course will show you how to speed up and improve the quality of your work in each of these areas.
Through the course, you will have few knowledge repetitions, practical tasks and tests that will help you remember all the information and put into practice the skills you have learned. The training offers access to the training videos and reference materials for an unlimited period.
You’ll learn from our Excel expert with many years of experience in the field who will explain every issue step by step and will teach you how to perform your tasks with confidence. This course is available through a multimedia Kemp Center platform. You will learn from the comfort of your own home and at your own pace. You can always stop, return or return to any topic.
On top of everything, after completion of the course, you will receive certificate confirming your skills.





Join the Excel course and get the benefits:
Learning from a professional instructor24/7 access from any devicePractical exercisesTests, quizzes and recapsCertificate of completionExtra materials and downloadable bonuses100% satisfaction guarantee



Your Singing Instructor:

Lewis Hardin
Excel expert
The Excel course is conducted by an MS Excel expert and trainer.
He specializes in financial modeling and data analysis. He can’t imagine life without Excel and till now, he created and implemented dozens of business tools based on this program.
Participants of his trainings appreciate him for his pragmatic approach, lightness of message, and an offbeat sense of humor. He is able to convey any issue in an accessible and understandable way.



Overview of the course:
The Excel course program:
I. Module 1 – Editing
Basic issues
Excel applications; navigating in the program; naming; toolbar; formula behavior; special paste; moving and copying without disturbing file consistency; areas; relative and absolute references; keyboard shortcuts.
Editing and formatting
Fonts; borders; text layout; wrapping; merging; formats (text, number, currency, accounting, dates and times, percentage, scientific, special); conditional formatting; table formatting; width and height, auto-fit.
Graphic and special elements
Pictures; shapes; icons; 3D models; SmartArt; text boxes; equations; symbols; headings; comments.
II. Module 2 – Analysis and modeling
Create charts and tables
Charts: column (bar); line; area; statistical; pie; doughnut; scatter; bubble; combination charts.
Special charts: cascade; funnel; stock; surface; radar; maps; spark lines; PivotCharts.
Filters (Slicer and Timeline): PivotTables and Plain Tables.
Use formulas
Rules for working on formulas.
Review and application of formulas.
Formulas: financial; temporal; mathematical and statistical; search; database; text; logical; IT; compliance; networking.
Working on data (databases)
Sort; filter; retrieve and transform data; import and export data; queries and connections; text as columns; instant fill; remove duplicates; data validation; consolidation; what-if analysis; forecast worksheet; outline (grouping and what-if analysis).
III. Module 3 – Review, view and print
Review and data protection
Checking: spelling; thesaurus; workbook statistics.
Accessibility settings; smart search; translator; comments and notes; protect worksheet; ink.
View, printing and formats
View: sheet views; page break preview; page layout and custom views; show grid view; formula bar and headings; zoom; arrange windows; freeze panes; enter macros.
Printing: print area; page settings; margin settings; sheet adjustment.
File formats and saving.
IV. Module 4 – Advanced issues
Advanced features
Work with other apps
Tools and plugins for professionals
V. Tests
Tests and repetitions of acquired knowledge
The acquired knowledge will be consolidated and checked through tests after each training module. Tests improve the acquisition of knowledge and improve the attention and engagement throughout the training.
Final test
After completing the final test at the end of the Excel course, you will get certified.
VI. Tasks
Practical tasks and exercises
Each participant of the Excel course will practice the acquired skills. In this way, the participant will assimilate skills for longer and adapt them to his/her style of operation. After completing the tasks and receiving feedback from our experts, the new skills will be fully acquired not only on an intellectual level but also on a practical level.
VII. Bonus materials for the course
Additional materials for use in everyday workAfter logging in, you will receive additional materials for use in everyday work. You will receive: short keyboards; a list of the best Excel plugins and tricks to improve work and many more.



Experience Beginner-IntermediateLanguage English, German, French, Polish, Portuguese



A letter from your expert instructor:
If you want to become an Excel master, don’t waste your time on boring and ineffective training courses that will teach you only the theory. We have a better solution for you: We are pleased to invite you to the most practical course that will teach you how to use Excel in practice. And guess what? You will master all the features of Excel program within just a couple of days.You will learn how to work dynamically and flawlessly. Data analysis, database manipulation, creating statements and reports won’t be a problem for you anymore. You will learn everything in the shortest possible time and you’ll master the use of the most important and useful functions. You will work on sheets taken from the real life and perform activities independently. In this way you will acquire the ability to use the program at an expert level.Join us today! Learn with us and surprise everyone with your knowledge of Excel! Learning Excel with us is so interesting and never boring. Learn from the best and become one of themLewis HardinExcel course expert 

8669 Courses

Employee Engagement 1 Day Training in Elgin

By Mangates

Employee Engagement 1 Day Training in Luton

By Mangates

Employee Engagement 1 Day Training in Guildford

By Mangates

Employee Engagement 1 Day Training in Heathrow

By Mangates

Employee Engagement 1 Day Training in Belfast

By Mangates

Employee Engagement 1 Day Training in Darlington

By Mangates

Employee Engagement 1 Day Training in High Wycombe

By Mangates

Employee Engagement 1 Day Training in Solihull

By Mangates

Employee Engagement 1 Day Training in Northampton

By Mangates

Employee Engagement 1 Day Training in Fleet

By Mangates

Search By Location