Judy Hughes Training

Judy Hughes Training Judy Hughes, a qualified Microsoft expert & Certified Professional Trainer. MS Word, Excel, PowerPoint & Outlook – Basic to Advanced. With 19 years exp.

Keep safe over the Christmas season and throughout 2021.
23/12/2020

Keep safe over the Christmas season and throughout 2021.

21/07/2020

MS Word Tip
Meaningless Text
For testing, or to see how text looks in a given page:
1. Position the cursor at the beginning of a paragraph.
2. Type =rand() and press Enter. (you can use lowercase, uppercase, or mixed case.)

08/07/2020

Locking the Zoom Factor in Excel
If using a touchpad, it's far too easy to change the zoom percentage inadvertently.
1. Display the File tab – Options- Advanced.
2. In the Editing area, make sure the Zoom On Roll with IntelliMouse check box is not selected.
3. Click on OK.
If you still want to use the trackpad to adjust the zoom factor, you can do so by holding down the Ctrl key as you drag down the trackpad.

Training during lockdown still happening albeit with masks, sanitizing spray and isolated offices. Here's a pic of one o...
30/06/2020

Training during lockdown still happening albeit with masks, sanitizing spray and isolated offices. Here's a pic of one of my successful students during training.

10/06/2020

Moving Text in MS Word without Affecting the Clipboard
1. Highlight (select) text to be moved.
2. Display the spot in the document where you want to move the information.
3. Holding down the Ctrl key as you right-click the mouse on the spot where the item should be moved. Word moves the highlighted item to where you right clicked.
The Clipboard is not involved. This means that if you had something on the Clipboard before the move, it is still there for later use.
To copy, hold down both the Shift and Ctrl keys in step 3.

18/05/2020

Repeating Actions in Word, Excel, PowerPoint
If you want to repeat an action a single time, you can either press the F4 key or Ctrl+Y.

28/04/2020

Noting Formatting Inconsistencies in MS Word
To check formatting inconsistencies—is not turned on by default, follow these steps:
1. Click on the File tab, then click Options.
2. At left, click Advanced.
3. Under Editing Options section, select Keep Track of Formatting check box.
4. Ensure Mark Formatting Inconsistencies checked. Click OK.
Word marks questionable formatting with a wavy blue underline. Right-click on the underlined text to see what Word feels may be wrong with the selection.

03/03/2020

Inserting Dates into a Word Document
Display the Insert tab then click Date & Time in the Text group. Choose the date and time format from the dialog box.
At the bottom-right of this box, check ‘Update Automatically’ to insert a DATE field which always changes to reflect the current date (used in templates). If this check box is not selected, the date is inserted in your document as text, which doesn't change.

25/02/2020

Removing Spaces in Excel Cells
If you have a lot of data containing spaces, for example, a large number of policy numbers with spaces. To remove those spaces, use the SUBSTITUTE function. If policy number is in cell A2, in cell B2 type: =SUBSTITUTE(A2," ","") The result is that cell B2 contains the policy number with all the spaces removed. Drag (copy) formula down to include all policy numbers containing spaces.

19/02/2020

Insert Current Time in Excel Spreadsheet
Keep track of the time worked on different jobs. Select a cell and press Shift+Ctrl+: (Colon). Press Enter to accept the time.

Address

Midrand
2017

Telephone

+27832676053

Website

Alerts

Be the first to know and let us send you an email when Judy Hughes Training posts news and promotions. Your email address will not be used for any other purpose, and you can unsubscribe at any time.

Shortcuts

Share

Category