Great tips for using Word, Excel, Outlook, Access, PowerPoint, Windows…and much more.
CTC Computer Training offers 1-day on-site and in-class Instructor-led training courses on all popular Microsoft Office 365 software.
Great tips for using Word, Excel, Outlook, Access, PowerPoint, Windows…and much more.
CTC Computer Training offers 1-day on-site and in-class Instructor-led training courses on all popular Microsoft Office 365 software.
See that X at the top-right corner of your Word (or Excel or PowerPoint) window? That X closes the current program window. I say program window because it is possible to have more than one copy of the same program running at a time. Who hasn’t worked on two Word documents at the same time? Well then, you’ve had two Word program windows open…
Read More
You have typed a formula into a cell near the top of a column. You would like to COPY that equation to all the blank cells below you (stopping at the lower boundary of the other columns in your spreadsheet)…
Read More
Full tip here: PowerPoint Tip
Read MoreYou have a number of paragraphs in a row and there’s one that is in the wrong position…it needs to be moved up (or down) the body of other paragraphs…
Read More
You are sitting on a cell that contains the word January (or Monday). You know if you drag the Fill Handle (the little black square located at the bottom-right corner of the cell pointer) and drag down (or across) that February, March (or Tuesday, Wednesday) will appear in the adjacent cells…
Read More
If you want Excel to count how many cells contain numeric entries – use the COUNT function (ie, =COUNT(range)). Cells containing non-numeric entries (ie, text) will NOT be included in the answer…
Read More
We all get so many emails every day that you can miss the odd one. What if it’s from a very important client (I mean…they all are!) or your boss? How can you avoid missing those email in particular?
Read More
If you need to enter the same data (text, numbers or equations) into a range of cells – rather than type it then copy it to the adjacent range of cells – type it into the entire range at once…
Read More
The next time you need to zoom in or out in a program or document – don’t waste your time with the standard VIEW/ZOOM menu or tab…
Read More
You’re in Word and you’ve typed some text in the wrong case (all lowercase when it should have been all uppercase, for example)…
Read More