InIT Software Training Blog – On Course for Success

Excel

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 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.

Excel – How to use the Evaluate Formula Tool

Find Formula issues with the Evaluate Formula Tool – How to use the tool

This video shows you how to use the Evaluate Formula Tool in Microsoft Excel. This is a great tool if you have created a formula and it’s not quite working properly or you have inherited a spreadsheet and you want to see what is happening with a rather complex formula.

 

Save As

F12 Key – Save As

Save As
The F12 key is a great way to select the Save As dialog box.

Ctrl + S is the shortcut for Save.

Pressing the F12 function key gets you to the Save As dialog much faster than clicking the File ribbon tab for the backstage view and then clicking Save As.