How to add date based questions in Microsoft Forms
Microsoft Forms includes a variety of question types which help you collect information in different ways. Depending on the type of data you need, you can choose from options such as Text, Choice, Rating, Likert, Ranking, File Upload, Net Promoter Score (NPS) and Date questions. Each question type is tailored to a specific purpose, making […]
How to create appointments in your Outlook Calendar from dates in Excel
Recently I was asked about how to automatically create calendar appointments in Outlook (Classic version) using dates in an Excel workbook. This was something I’d not been asked before and it peaked my curiousity. I did some research online around the idea of using Power Automate, and unfortunately found no options. A few weeks later […]
How to sort data in Excel
One of the first features that many users begin using is the ability to sort data in Excel. Being able to automatically have your data displayed in a specific order, whether that be number, alphabetical or date order, is a huge time saver. Excel allows you to sort by one column at a time or […]
How to convert text to date format in Excel
Last week I received an SOS from a good friend. She had data that was exported from an LMS and being used for analysis within Excel. A particular column contained a date and time in each cell that needed to be filtered and sorted by month. This was proving impossible as the data was being […]
Use conditional formatting to identify dates within a specific range
My conditional formatting to identify dates earlier than today post has proven to be extremely popular. This post talks about how to use conditional formatting for dates which occur in the past. I have had lots of questions and comments based on this post. A popular question is how to use conditional formatting to highlight […]
How to display a second time zone in your Outlook Calendar
For anyone with friends, relatives or colleagues living in a different time zone, it can be a fun maths game to work out what the time is where they are located. Personally I’m having to do this now after a close family friend moved from Sydney to Scotland. Those first few weeks of trying to […]
Excel Conditional Formatting Based on Dates (Highlight Older Than Today)
During a Microsoft Excel training session a few week’s ago, I had a great question about using conditional formatting based on dates, in particular 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 […]