Individual support and training for your home and small business computing needs
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),…
Would you like to know how to change this default location? It will avoid you always having to go into Browse when saving a file – or navigate folders when opening the file you wan tto open. Here are the simple steps. A. Open up the File menu. You will see the following screen:- B….
Read More “Word – Changing location where files are stored” »
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….
Have you heard of this great way to quickly access recently opened files on your Windows PC? Via the icon on your Taskbar, which is this area Simply hover with your mouse over the icon for the program of your choice (I’ll use Word as an example) and click with the right button (or the…
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…
Did you know that you can get Outlook online to email you with a reminder of appointments? This is a great alternative to a pop-up reminder for most of us who aren’t office based nowadays, so miss such pop-ups! Strangely I cannot find this feature in the latest feature of Outlook (as part of Office…
This great feature can simplify the editing of long documents on a single monitor. With your document open, click on “View” to show this ribbon and then click on the button on the right called “Split”:- As you can see below, Word places a line across the middle of your screen. It also adds separate…
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…