InIT Software Training Blog – On Course for Success

Tips and Hints

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

Windows Taskbar

How to navigate the programs pinned to the Taskbar

Windows Taskbar

The programs that are pinned to the Windows taskbar and the open programs that have been minimised to the taskbar can be opened by holding the windows key down and then pressing a number key.

Windows Key + 1 = the first pinned program

Windows Key + 2 = the second pinned program

and so on.

Audio Available