InIT Software Training Blog – On Course for Success

David

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.

Reply and Include the Attachments

Microsoft Outlook – Reply with Attachments

One of the big issues that a lot of people have is how to include attachments that have been sent to you in a reply. There are several ways to work around this issue but I personally feel the one in this video is the best one.

Outlook Basic Navigation

Keyboard Shortcuts for Basic Outlook Navigation

Outlook_Navigation_Small

 

 

Using the Ctrl key plus a number key 1 to 7 you can easily switch between the component parts of Outlook as follows:

Switch to Mail view Ctrl+1

Switch to Calendar view Ctrl+2

Switch to Contacts view Ctrl+3

Switch to Tasks view Ctrl+4

Switch to Notes Ctrl+5

Switch to Folder list in the Folder pane Ctrl+6

Switch to Shortcuts Ctrl+7

Outlook_Navigation_Large

 

 

Audio available here