Monthly Archives: November 2021

Microsoft Excel – averaging without including zeros

Training at client site recently, they had a workbook where they were inputting monthly data and the months that had not yet been reached were populated with zeroes. If the use the AVERAGE function to try to find the monthly … Continue reading

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

Microsoft Project – renaming baseline

I was training Microsoft Project recently and was asked whether it was possible to rename a Baseline to make it more obvious as to why it was baselined when it was. We can’t actually rename the field but we can … Continue reading

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

Microsoft Project – making non-working days more visual on Gantt Chart

Whilst I was training Microsoft Project recently, one of the learners said that he felt that the non-working days, in his case weekends, were shown in too light a grey colour on his Gantt Chart. Furthermore, he would like the … Continue reading

Posted in Microsoft Project, Microsoft Project 2010, Microsoft Project 2016 | Tagged , | Leave a comment

Changing name on Zoom

Sometimes you may have borrowed someone else’s computer for a Zoom meeting, so the person’s name to whom the computer belongs is what is seen by the other meeting participants. You can change the name however; to do so, click … Continue reading

Tagged | Leave a comment