Resilence and Emotional Intelligence

Resilience (or resiliency) is our ability to adapt and bounce back when things don’t go as planned. Resilient people don’t wallow or dwell on failures; they acknowledge the situation, learn from their mistakes, and then move forward.

According to the research of leading psychologist, Susan Kobasa, there are three elements that are essential to resilience:

  1. Challenge – Resilient people view a difficulty as a challenge, not as a paralyzing event. They look at their failures and mistakes as lessons to be learned from, and as opportunities for growth. They don’t view them as a negative reflection on their abilities or self-worth.
  2. Commitment – Resilient people are committed to their lives and their goals, and they have a compelling reason to get out of bed in the morning. Commitment isn’t just restricted to their work – they commit to their relationships, their friendships, the causes they care about, and their religious or spiritual beliefs.
  3. Personal Control – Resilient people spend their time and energy focusing on situations and events that they have control over. Because they put their efforts where they can have the most impact, they feel empowered and confident. Those who spend time worrying about uncontrollable events can often feel lost, helpless, and powerless to take action.

Find out more about our Resilience and Emotional Intelligence training

Advertisements
Posted in Uncategorized | Tagged , | Leave a comment

Crystal Reports – using Propercase but with some words needed in lower case – for example Wired for Sound

In Crystal Reports, if the data coming into a report is a mess of upper, lower and proper case, you may well want to convert the field using the function PROPERCASE. However, on doing so, you may find there are one or two that still look strange – for example ‘Bikes And Trikes’ may look better as ‘Bikes and Trikes’, etc. Decide which words you want to still be in lower case, for example, ‘to’, ‘and’, ‘for’ and ‘the’.

Proper case

In the example above, I have created a formula which converted my original customer name to proper case. I then use cstr to convert the resulting formula to a string.

To take into account that there may be a string where and is part of a word for example Bikes of England, when looking for a particular word in the string I have included spaces on either side of the word.

In the screenshot below, the Proper case column is to the left and the column to the right shows the result using the formula above.

Find out more about our Crystal Reports training in the London area or our Crystal Reports training in the Wiltshire, Dorset and Hampshire areas.

Posted in Crystal Reports | Tagged , | Leave a comment

Microsoft Excel – deleting all blank rows in a worksheet

If you have several empty rows in an Excel worksheet, it is a bit of a nuisance to go through and delete them all manually. You can select blanks cells, using Go to Special, but if you are not careful you will end up deleting rows that contain a few blank cells rather than being completely blank rows.

Instead, go to the column to the right of any data and set up a formula:

=countblank(a2:?2) where ? is the previous column letter

Copy the formula down to the end of the column.

Blank rows

Now, put on a filter on that column (Data – Filter) and filter so you are just seeing the rows with the maximum number of blanks (these rows will be completely blank).

Blank rows

Delete these rows, clear the filter and delete your extra column.

You will now have removed the blank rows.

Blank rows

Find out more about our Microsoft Excel training London, UK.

Find out more about our Microsoft Excel training Wiltshire, Hampshire, Dorset.

Posted in Microsoft Excel, Microsoft Excel 2007, Microsoft Excel 2010, Microsoft Excel 2013, Microsoft Excel 2016 | Tagged , | Leave a comment

Microsoft Excel – gridlines lost when formatting cell background

When you add colour to a cell background in Excel, either manually using the Cell Background  Cell background icon button or by using Conditional Formatting, you lose the gridline round the cell.

Cell gridlines

 

If you really want to see the gridline, you can reproduce it using the cell borders button. Select the relevant cells, then from the Borders dropdown, select All Borders, then click More Borders. The Format Cells dialog box will be displayed with the Borders tab uppermost. From the Color dropdown, choose White, Background 1, Darker 15%. On the right-hand side, click on all borders of the rectangle in the Border section.

Format Cells Borders dialog box

Click OK.

You will now see gridlines round your data.

Cell gridlines

Find out more about our Microsoft Excel training London, UK.

Find out more about our Microsoft Excel training Wiltshire, Hampshire, Dorset.

 

Posted in Microsoft Excel, Microsoft Excel 2007, Microsoft Excel 2010, Microsoft Excel 2013, Microsoft Excel 2016, Uncategorized | Tagged , , | Leave a comment

Microsoft Word – getting back to normal text after using text effects

If you use the Text Effects  Text Effects icon button in the Font group on the Home tab, you produce some interesting effects. However, it is not then obvious how to get back to normal writing!

To do so, click the Clear All Formatting Clear All Formatting icon button also in the Font group on the Home tab. This will get you back to ordinary type.

Find out more about our Microsoft Word training in the London area or our Microsoft Word training in Dorset, Wiltshire and Hampshire.

Posted in Microsoft Word, Microsoft Word 2010, Microsoft Word 2013, Microsoft Word 2016 | Tagged , , | Leave a comment

Microsoft Excel – Sorting by colour and within that alphabetically

If you conditionally format data in Excel, you can sort by colour.

Conditionally formatted data  In the above data set, I have conditionally formatted all those with word ESTATE in the description.

Then, on the Data tab, I click the big Sort button and enter as below.

Sort dialog box

Then click Add Level and select Description again, this time with Order A to Z.

Sort Dialog box level 2

The data will be sorted as required.

Sorted by colour and alphabetically

Find out more about our Microsoft Excel training London, UK.

Find out more about our Microsoft Excel training Wiltshire, Hampshire, Dorset.

Posted in Microsoft Excel, Microsoft Excel 2007, Microsoft Excel 2010, Microsoft Excel 2013, Microsoft Excel 2016, Uncategorized | Tagged , | Leave a comment

Microsoft Excel – using series from more than one worksheet in a chart

Sometimes you may create a chart in Excel and then want to add data from another worksheet.

Excel chart

To add in extra data, on the Chart Tools Design tab, in the Data group, click Select Data.

Change series dialog box

At the left under Legend Entries (Series), click Add. The Edit Series dialog box will be displayed.

Edit Series dialog box

Locate the data you want to add. From the Series name box, click in the cell containing the label of the series you want to add. From the Series values box, drag across the cell range containing the values you want to add. Click OK twice. The data will be added to your chart.

Chart with series added

Find out more about our Microsoft Excel training London, UK.

Find out more about our Microsoft Excel training Wiltshire, Hampshire, Dorset.

Posted in Microsoft Excel, Microsoft Excel 2010, Microsoft Excel 2013, Microsoft Excel 2016 | Tagged , , | Leave a comment

Microsoft Excel – date format of Monday 1 Jan 2018

I was asked whether I could create a date format of Monday 1 Jan 2018 and copy it down to Tuesday 2 Jan 2018 etc. This requires a custom format. However, I also found it required me changing my computer settings for Long Date in Date/ Time settings.

Access the Date/Time settings on your computer and find the setting for changing date and time formats – this will depend on which version of Windows you are using. For the Long Date, select dddd, d MMMM yyyy as this is the nearest to that required.

Now in Excel, select the cells to be formatted, and open the Format Cells dialog box at the Number tab. Select Long Date. Then click Custom. Adapt the setting to be dddd d mmm yyyy. Click OK.

Type into the first cell 01/01/2018 – it will be displayed as Monday 1 Jan 2018. You can then use the Autofill handle to fill in the rest of the dates.

dddd – shows day of month in full

d – shows 1st digit of day

mmm – shows month as Jan, Feb, etc.

yyyy – shows year in full

Find out more about our Microsoft Excel training London, UK.

Find out more about our Microsoft Excel training Wiltshire, Hampshire, Dorset

Posted in Microsoft Excel, Microsoft Excel 2003, Microsoft Excel 2007, Microsoft Excel 2010, Microsoft Excel 2013, Microsoft Excel 2016, Uncategorized | Tagged , | Leave a comment

Microsoft Excel – quick entry of last day of every month

To enter the last day of every month into a column in a worksheet, first enter the last date of the first month to be included, say 31/01/2017.

Drag down to fill in as many as required. Go to the Autofill Options button at the bottom and choose Fill Months. The last date of each month will be entered as required.

Last day of each month

Find out more about our Microsoft Excel training London, UK.

Find out more about our Microsoft Excel training Wiltshire, Hampshire, Dorset.

Posted in Microsoft Excel, Microsoft Excel 2003, Microsoft Excel 2007, Microsoft Excel 2010, Microsoft Excel 2013, Microsoft Excel 2016 | Tagged , , | Leave a comment

Microsoft Excel – adding an “X” or equivalent text in several cells in a column

I was asked recently how one could add X to every number in a cell – this would be for a product code, a part number etc.

Part numbers

This is a matter of formatting the data. Select the cells you want formatting. On the Home tab, in the Number group, click the little dialog box launcher arrow . The Format Cells dialog box will be displayed with the Number tab uppermost.

Format Cells Number tab

Click Custom. In the box to the right, choose the format that is nearest to the one you already have – in this case #,##0.

Then in the Type box adjust to what you need, in this case ###0X.

Format Cells Custom Number

Click OK. Your column will be formatted as required.

X added to numbers

Find out more about our Microsoft Excel training London, UK.

Find out more about our Microsoft Excel training Wiltshire, Hampshire, Dorset.

Posted in Microsoft Excel, Microsoft Excel 2003, Microsoft Excel 2007, Microsoft Excel 2010, Microsoft Excel 2013, Microsoft Excel 2016 | Tagged , | Leave a comment