Tips and Hints
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.
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.
Paste to Word
How to copy text from one program and paste it into Microsoft Word
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.
How to add Data Bars with Conditional Formatting
This video shows you how to use PowerPoint to record your screen. This is great if you need to demonstrate something on your screen or produce a training slide with video.
Keyboard Shortcuts for Basic Outlook Navigation
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
Audio available here
Conditional Format and Minimum Function to Find Best Quote
This video show one way to identify the best price from a range of products and a range of suppliers using conditional formatting and the Minimum Function
How to have a non-numbered paragraph in the middle of a numbered list in Microsoft Word.
How to navigate the programs pinned to the 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.