Monthly Archives: July 2020

Microsoft Excel – Creating timetable by adding minutes to time

Posted on July 31, 2020 by jdonbavand

I was asked by someone who was creating a timetable for music exams how to get Excel to calculate the next exam time, knowing how long the exam would take – for Music Grade exams depending on the Grade and … Continue reading →

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

Questioning Techniques

Posted on July 27, 2020 by jdonbavand

Questions are a very important Communication Skill. The success of coaching sessions will depend to a large extent on asking the right questions at the right time. We need to ask questions : To check for understanding Get reliable feedback … Continue reading →

Posted in Coaching skills, Communication Skills, Mentoring training, Negotiating and Influencing Skills, Presentation Skills, Uncategorized | Tagged | Leave a comment

The Delegation Process

Posted on July 24, 2020 by jdonbavand

We sometimes find it difficult to delegate effectively and therefore the results are not as anticipated. Delegating is not just giving a task to someone, it involves ensuring they know exactly what is expected of them and in what timeframe … Continue reading →

Posted in Coaching skills, Communication Skills, Project Management, Time Management | Tagged | Leave a comment

Microsoft Excel – VLOOKUP giving n/a though looks like cells match

Posted on July 8, 2020 by jdonbavand

A client recently asked me to look at their Excel workbook where a VLOOKUP was showing N/A all down the column. I could see that some of the cell references did indeed appear to be there in the table array … Continue reading →

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

Microsoft Excel – using conditional formatting to highlight upcoming renewal dates

Posted on July 1, 2020 by jdonbavand

A client has employees who have to renew various work certificates every 3 years. If you have a lot of employees it would help to see when renewal dates were approaching. This can be done by using Conditional Formatting in conjunction … Continue reading →

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