Category: Tips and Tricks

Inserting the Date and Time into a Worksheet

It happens often, current date and/or time is to be added to a worksheet, perhaps while making a time stamped log of activities. Maybe there is a requirements to have the current data or time displayed automatically in a cell every time formulas are recalculated. There are several ways to insert the current date and …

Continue reading

PowerPoint Presenting Tips

One of the most heard phrases I hear in relation to any of the available presentation suites is “Death by PowerPoint”. In other words there’s total overkill in its usage, and very often it’s totally unnecessary, often as a result or poor presentation skills. When presenting, remember that PowerPoint is a tool to aid effective …

Continue reading

Excel Quick Shortcuts – Formatting

In this article we once again consider some key tips utilising keyboard shortcuts, this time in relation to formatting. There are many possible number formats, all of which can be accessed through the Format cells dialog box. There are however some preformatted options that can readily be accessed using keyboard shortcuts. In many cases these …

Continue reading