Individual support and training for your home and small business computing needs
If you need to fill in a range of headings, or a column of data, Autofill can really save you time. It can be used for consecutive numbering, days of the week, months of the year, years (such as 2014, 2015 …..) and much more. As long as you have at least the first 2…
1. Are you a ‘light’ user of Word, Excel or PowerPoint? Yes 2. Are you happy to store your documents in OneDrive? Yes If so, you could spend £0.00 by using Office Online with your Microsoft account, storing the documents you create on the standard OneDrive 5GB cloud storage allowance. After simply logging into www.office.com…
Did you know how the Tables feature in Excel can enhance your spreadsheets, especially for data entry purposes? Tables allow you to select areas in your worksheet tabs and show them like this:- ….. instead of displaying like this:- The biggest difference in usability is that – when you are tabbing through cells in data…
Did you know that you can ‘pin’ any number of files to a special menu in Word, Excel, PowerPoint or Publisher? Its as simple as pressing the little pin icon on the right hand side of the image below:- Pinned files are easy to access as they are kept on a separate, but easy to…
Have you heard of PowerPoint’s Slide Sorter View? This option (3rd from the left) under the View Menu allows you to:- A. insert slides B. delete slides C. hide slides from the presentation D. …. or even create new sections for some of them! This is what it looks like:-
Have you checked what features are available to help you manage them? The screenshot below shows some of them:- I use the Rename option most commonly – here’s how it works:- The tab colour option is also very handy – here’s how it works:- …. and the result is this appearance when the tab isn’t…
It allows you to add a live feed from your webcam to the slides of your presentation – visible constantly as you play the slides Below is a still image of me in my office, within a PowerPoint presentation. If we were playing this slideshow as part of a online meeting (whatever platform you use…
If you have Microsoft Office 365, you probably use Word, Excel and PowerPoint as its popular programs. Have you considered one of its other packages Publisher can turn this image:- …. into this image, ready for printing on an A4 sheet Publisher is part of many MS Office 365 Packages (Home and Business) – and…
Do you know you can filter your Outlook Inbox by whether they have an attachment (often a document or picture)? I used this feature all the time when I was in employment as often I didn’t want to see emails which were ‘plain text’ without attachments – viewing just the ones WITH attachments. To activate…
Do you know you can access all of your files on your tablet (iPad or Android), and also your smartphone (iPhone or Android)? The screen below shows the ‘Account window’ from which you can see files can be saved for offline use. This means that if you’re on the tube you can still see important…
