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.
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
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.
This video explains how to copy or fill a range of data or headings on one worksheet across to all or a range of selected worksheets in Excel. To learn more about Excel contact InIT Learning and Get on Course for Success. In-house (@ yours) and scheduled open courses available.