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.
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.
How to Customise the Background and Title Bar in Microsoft Office
The customise feature in the Microsoft Office feature has no real practical use other than to be more pleasing to your own eyes. The video shows you how to change background and title bar colours in Office 2010 and Office 2016.
Avoid the Embarrassment of Sending Wrong Emails by Delaying them.
Have you ever sent an email and as you click send realise that you have sent it to the wrong person, forgot some crucial information or forgot the attachment. The new Outlook does now recognise if you have mentioned attachment in your text and have forgot to attach it but if you delay your email by a few minutes at least you have a small window of opportunity to stop it being sent.
here is how to set that feature up.
Entering the degree symbol while typing in Microsoft Word.
- Hold Shift + Ctrl and press the @ key.
- Let go
- Press the space bar
Mini Toolbar Word, Excel and PowerPoint
To access the mini toolbar simply right click a cell in Excel or right click on selected text in Word or PowerPoint. In addition to the shortcut menu you will see a mini toolbar where you can select one of the common formatting commands.
How to view windows side by side using the keyboard or mouse
Check your Data Entries in Excel Spreadsheets
If you wish to check your data you can either asked someone to read the hard copy while you check the screen or you can check the data by keep looking up and down between the hard copy and the screen. Excel has a really neat way to help you. Watch the video below. If you want more tips then book InIT Learning to come to you. GetonCourse for Success with our SoftwareTraining @ Yours.