Computers
Excel – Date to Text
Had a great question the other day. One of my delegates on a course had a task to enter two dates from her spreadsheet with the word ‘to’ in the middle to a different programme. I showed her a way that is saving her lots of time now. Watch the video below and see how to convert a date to text and join using concatenate.
Excel – Custom Views
Have you ever hidden multiple Excel worksheets in one go and then tried unhiding them in one go. The unhiding normally is frustrating as you have to do one at a time. Here is a way you can get around the issue by using Custom Views.
Excel – Custom Data Validation
If you carry out data analysis on Excel spreadsheets you will probably come across the need to clean the data first. For example, removing leading and trailing spaces from words. Rather than cleaning data, it’s much easier to try and prevent the mistakes in the first place. This video shows you how to prevent a user from entering unwanted spaces.