Yawn-proof software training

Clickety-Quick’s Top 5 Helpful Hints

In most of the classes we offer, it seems there are a few questions that present themselves over and over again. Today, we’d like to share our Top 5 Questions and Answers.

  1. What is – or how do I make – a “soft return”?
    A soft return, Shift+Enter, is used when you want to force a line break without creating a whole new paragraph. They are used for text wrapping when don't want the first word of the next line to be capitalized; or, if you need the text on the following line to be aligned in the same manner as the existing paragraph.
  2. What is a simple way to select a large volume of text?
    To select text that spans more than one page, I suggest using Click, then Shift+Click. If you've tried to select text using the traditional "hold down your mouse button and drag" method, you’ll have noticed that the pages slip by so quickly it's near impossible to control. However, you can avoid these runaway pages if you Click one end (doesn't matter which end), scroll up/down using the scroll bar, then Shift+Click at the other end. Voila! The text is selected.
  3. Can I format more than one sheet at a time in Excel?
    Absolutely. When you want the layout of multiple sheets to be exactly the same; use Control+Click for non-adjacent sheets, or Click/Shift+Click to select adjacent sheets (using the sheet tabs) in your Excel workbook. Once you've selected the sheets, enter your labels, formulas and add formatting to the active sheet and you'll discover that each of the selected sheets are exact duplicates. To deselect, simply Click any sheet tab.
  4. Is there a simple way to copy/insert text or item I use over and over again?
    Do you always use the same header and footer; add the filename, author or page numbering style? Then try using “Quick Parts” to make your life easier (Microsoft Office 2007/2010 only).  Open an existing document, select the item that you like to use repeatedly, choose “Quick Parts” from the Insert ribbon and "Save Selection to Quick Part Gallery..."  You can even choose a category such as Headers, Footers, Table of Contents, Tables, etc.
  5. How can I show someone else what my display looks like?
    This is where “screenshots” come in handy.  When you're faced with a challenge and need some help, it's really helpful to provide a screenshot of the error message or the state of the system at that point in time – though this isn't always possible if your system hangs! To take a screenshot, simply press the button on your keyboard that says Print Screen or PrtScn (or some variation on the words “print” and “screen”), then paste (Ctrl+V) to an email or a document.  If you're only interested in an image of a specific window, make sure it's the active window and use Alt+PrintScreen, then paste.
Keep your 'puter running!
Office 2011 for Mac

Related Posts

 

Comments

No comments made yet. Be the first to submit a comment
Already Registered? Login Here
Guest
Tuesday, 18 February 2020

Captcha Image

Book

How To Choose a Software Trainer They'll Thank You For

Survey says: "Sitting through software training is painful".

Knowing how to use MS Office and knowing how to train people to use it are two different things. Download this Special Report and discover how to choose a trainer that leaves your employees feeling useful.

  • Claire Langfield, Executive Assistant

    Chippewas of Rama First Nation

    The majority of my computer training focused on Publisher. I have received positive comments and feedback from several of my colleagues on the changes between my first attempt and current expertise creating the monthly internal newsletter for my department. They enjoy the updated format and the way in which the information is presented. 

    Deborah assisted me through a learning curve, as I had not previously had any exposure to this program prior to joining Rama. She also provided me with a refresher course on PowerPoint and Excel.  Deborah is a patient teacher and tailored the training to suit my job requirements.