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…
Find a blank area of your task manager and use your right mouse button to click and this should appear:- This Task Manager should now appear – it may appear diferently on some systems but you can find the End Task option. Click on the program which is frozen and then the icon for End…
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…
Did you know you can bookmark the current page by simply pressing Control D – or pressing on the yellow star shown here? The star looks the same in Chrome, another popular browser. In Internet Explorer, it looks a little different like this (but the same shortcut works):- Afterwards, a box like this pops up…
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…
Your mouse experience is one area where you can make improvements, especially if you use a laptop with an integrated trackpad. It was a great usability experience to switch from the one that came with my desktop PC to this ergonomic one (which is cabled).. Suddenly all my tasks seemed easier as the mouse glided…
