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…
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…
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…
The default cell doesn’t allow much room for typing text, does it? To extend a column’s width, move the mouse pointer over one of the small divider lines that separate the alphabetic headers at the top of the sheet. When the pointer changes to a double-headed arrow (as you can see in the picture above),…
Do you know the advantages of subscribing to Office 365 – over purchasing the software? Software Purchase The software you purchase is usually for a single PC – whether it’s a desktop PC or laptop – to allow you to access Word, Excel, PowerPoint and Outlook and sometimes Publisher for your personal or home-office use….
Did you know that you can use Excel’s SUMIF feature to automatically generate a Cashflow spreadsheet? The screen below shows the one I use for monitoring my business income and expenditure across the year:- The 3 fields (Range, Criteria and Sum_range) enable Excel to constantly monitor them for any changes. This means that I change…
Do you need to use these programs on your tablet or smartphone (as well as your desktop PC)? “Yes”? – You probably need to invest in Office 365 Personal or Home Office 365 Personal is the version the majority of people need – it’s designed for single users within a home, but who use multiple…