Monthly Archives: September 2022

Microsoft Project – Showing gridlines on Gantt Chart

Posted on September 26, 2022 by jdonbavand

I was asked recently how to show gridlines on a Gantt chart and not just horizontal gridlines, but vertical ones too! To show horizontal gridlines on your Gantt Chart, right click over the Gantt chart and click Gridlines. The Gridlines … Continue reading →

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

Using Zoom – how to raise hands

Posted on September 23, 2022 by jdonbavand

I was training via Zoom yesterday and was asked how people could raise hands as they do in Microsoft Teams. When looking along the menu towards the bottom of the screen, you will see an icon called Reactions which has … Continue reading →

Posted in Zoom | Tagged , | Leave a comment

File Explorer – removing files from Recent Files list

Posted on September 20, 2022 by jdonbavand

I was training Basic IT Skills recently. One lady shares her computer with a colleague and wondered how she could hide files from her Recent Files list on her File Explorer. To remove files from the list, right-click on the … Continue reading →

Posted in Microsoft Office 2016, Microsoft Office 365 | Tagged | Leave a comment

Microsoft Outlook – setting up an Out of Office reply if you don’t have Microsoft Exchange

Posted on September 14, 2022 by jdonbavand

If you do not have Microsoft Exchange and want to set up an Out of Office reply: Note  – you can download and adapt preset Out of Office templates from Microsoft Office.com Find out more about our Microsoft Outlook training … Continue reading →

Posted in Uncategorized | Leave a comment

Microsoft Project – changing size or colour of the bars of tasks in progress

Posted on September 9, 2022 by jdonbavand

Normally when you use tracking in Microsoft Project and you mark a task as being a percentage complete, you see a thin bar of a slightly darker colour on top of the bar of the relevant task on the Gantt … Continue reading →

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

Microsoft Excel – SMALL and LARGE functions

Posted on September 9, 2022 by jdonbavand

You may well know that the function MIN gives the smallest number in a range in Excel and that the function MAX gives the largest number in a range in Excel. But what if you want to return the Xth … Continue reading →

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

Excel 365 – new text function TEXTSPLIT

Posted on September 6, 2022 by jdonbavand

New text functions have recently been added to Excel 365. The TEXTSPLIT function works in very much the same way as Data – Text to Columns. The syntax is =TEXTSPLIT(text, col_delimiter, [row_delimiter], [ignore_empty], [match_mode] [pad_with]) Only the first two bits … Continue reading →

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