Monthly Archives: October 2022

Microsoft Excel – count number of cases closed within a certain number of days

Posted on October 26, 2022 by jdonbavand

When training last week, I was asked how to work out the number of cases that had taken less than 90 days to be resolved, the number of cases that had taken between 90 and 120 days and the number … Continue reading →

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

Excel 365 – TEXTBEFORE and TEXTAFTER

Posted on October 19, 2022 by jdonbavand

I recently wrote about the TEXTSPLIT function which works in a similar way to Data – Text to Columns. Two other new functions are TEXTBEFORE and TEXTAFTER. The first of these returns a string that’s before delimiting characters and the … Continue reading →

Posted in Excel 365, Microsoft Excel | Tagged , , | Leave a comment

Why is my text shrinking in my Microsoft Office application?

Posted on October 12, 2022 by jdonbavand

Yesterday I was training and asked learners to hold down the Ctrl key whilst selecting various cells in Excel. One lady said that the size of her text was shrinking! It turned out that as well as holding down the … Continue reading →

Posted in Microsoft Office 2007 and 2010, Microsoft Office 2013, Microsoft Office 2016, Microsoft Office 365 | Tagged , , | Leave a comment