Monthly Archives: December 2018
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.
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.