Blog Main Categories
- Project Management 72
- Business Skills 125
- Creative Design 57
- Business Processes 76
- IT and Web Development 58
- Digital Marketing 95
You are viewing posts by Andy Trainer. Click to view all posts
Use these step by step instructions to sort your lists with maximum efficiency in Excel.
Excel can sort columns into order alphabetically and numerically. You can perform a single column sort of multi column sort.
The Sort command can be found on the Home tab under the Editing group.
Important: When setting up the list, include a set of column headings (as example below). These are used to control the sort columns. The list must be sequential, i.e. no row gaps from the top of the list to bottom.
Single Column Sort
Click into a cell in the column that you wish to sort by, as in the example below the First Name column.
Select the Data tab, then to sort by A to Z or Z to A.
You've been here before, the last time you and the client spoke you didn't exactly see eye to eye. Now months of negotiations are at risk and potentially big figures in profit too.
Don't make that call. Re-evaluate where you are in negotiations and see what you can take from these killer tips to close that deal.
Negotiations are all about your relationship with the client. If you're seeing your role in negotiations as an opportunity to make money at the expense of the client then you're looking at it all the wrong way. Negotiations are professional relationships. Benefits should and can be mutually profitable whilst retaining a relationship with a client that will last years.
Our Negotiation Skills training will give you the knowledge and tools necessary to be able to conduct any negotiation as a competitive and collaborative negotiation.
A good deal might not revive a bad relationship, but a good relationship can revive a bad deal.
When you ask any group of workers what motivates them to come to work, at least one and probably most will include 'money' in the response. Pay is a big issue for most people and is certainly a reason why people go to work, even sometimes staying in jobs they don't like. But is it a motivator?
Herzberg's Two Factor Theory suggests that there are two different sets of factors that determine job dissatisfaction and job satisfaction.
Herzberg's Two Factor Theory
|Satisfiers/Motivation Factors||Dissatisfiers/Hygiene Factors|
The Johari Window model, devised by American Psychologists Ingham and Luft during a research period at the University of Los Angeles in 1955, is a behavioural model which aims to boost group relations through individual self awareness and mutual (group) understanding.
The model is a combination of the first names of Joseph Luft and Hari Ingham; they’re remembered over fifty years later which shows what good workplace relationships can achieve.
The Johari Window model is particularly useful in assessing group relations with other parties. Despite being published over fifty years ago, the model is still relevant in the work place today. This is due to current popular workplace emphasis on cooperation, inter-group development, interpersonal development, soft skills, behaviour and the influence of these factors.
The ease of using the Johari Window Model to understand relationships between employees and the employer within the Psychological Contract is an invaluable benefit to businesses.
What Does The Johari Window Mean?
The model is, on the face of it, is as simple as it appears. Its application in the workplace is slightly more tricky, but we’ll get to that later.
New for October 2014: Gain your PRINCE2 and MSP Practitioner Qualifications online with our APMG accredited range of eLearning packages.
PRINCE2 and MSP training continue to rise in popularity but not everyone can take a full week off work to attend a training course.
eLearning allows you to gain your certificate in your own time, at your own pace and for less than a classroom based course.
Choose from a range of packages including our complete Practitioner package that includes everything you need to gain your PRINCE2 or MSP Practitioner certificate:
- 6 months access to eLearning
- Official AXELOS manual
- Accredited trainer support
- Foundation and Practitioner exam simulations
- Online Foundation exam
- Online Practitioner exam
Click here for a demo of the eLearning platform or call us on 01273 622272 for more information.