Do you have a list of entries you use frequently in Excel? Sick of having to type them in or copy and paste from another workbook? What if I told you that you could save these entries as a custom list in Excel? What if you could use the AutoFill tool whenever you wanted to …
At the start of every training course I run, I show participants through a few really useful tools. These tools will save you time during a busy workday. One such feature is AutoCorrect, however, another is the ability to pin a file or folder permanently into the Open or Save list. This wonderful feature is …
Save time! Pin a file or folder to the Open list in Microsoft Office Read More »
During a Microsoft Excel training session a few week’s ago, I had a great question about using conditional formatting to highlight dates earlier than the current one, in other words, how can we highlight dates that occur in the past? This was a great question and so I thought I would publish a post this week about how …
Use conditional formatting to identify dates earlier than today Read More »
