Have you been using Microsoft Word or Excel without formal training – and thinking of taking an intermediate level class?

 The beginning level training covers key foundational concepts you may have missed without training.  Here is a checklist to help you decide if you’re ready for intermediate.  But first, let’s start with your basic Windows knowledge before we take a look at your Word and Excel skills.  Are you able to…

  1. Navigate Windows through icons, folders,  and menus.
  2. Open programs – including Word and Excel.
  3. Use window controls (close, minimize, restore), toolbars, menus, and scroll bars.
  4. Use window views.
  5. Identify which window or program you are in.
  6. Create, save, and name files.
  7. Find and open files you created.
  8. Send a file as an email attachment.

 These are basics a beginner should know using any Microsoft Office program:

  1. How to set margins.
  2. Select text and navigate documents.
  3. Copy and paste.
  4. Spell check.
  5. Change the look of text (change font, make it bold, underlined, or blue).
  6. How to use help.
  7. How to create page breaks.
  8. File > Save, Open, or Close.
  9. Undo.
  10. Print

 Microsoft Word

Specific concepts and features you should know in Word. You can… 

  1. Jump directly from top to bottom of your document without scrolling.
  2. Select words, sentences, paragraphs, lines by methods other than click and drag.
  3. Use the Show/Hide button on the toolbar and know what it is for.
  4. Name two examples of text formats.
  5. Name two examples of paragraph formats. (Formats that apply to paragraphs).
  6. Describe how Word knows what a paragraph is.
  7. Create three types of indents using the ruler.
  8. Describe what AutoCorrect is and what it does.
  9. Double space your text.
  10. Switch between Normal View, Print Layout View, and Print Preview, and know the difference between them.
  11. Turn bullets and numbering on/off.

 EXCEL

You may be ready for Intermediate Excel if you know the following:

  1.  How to widen columns, change row heights.
  2. Design a basic spreadsheet.
  3. The formula bar and its function.
  4. Create basic formulas, to add, average, subtract, divide.
  5. How to automatically fill months of the year across columns.
  6. Move cell contents by drag and drop.
  7. The affect on formulas when copied to other cells.
  8. How to add/remove decimal places.
  9. Format a number as a percent.
  10. Center a spreadsheet on the printed page, and other print settings such as landscape/portrait orientation.
  11. Excel’s pointer modes and what tasks they are for.
  12. AutoSum.
  13. AutoCalculate for a quick total, average, or count without a formula.
  14. How to write a formula with multiple operators (i.e. adding and multiplying in the same formula).
  15. How to add, delete, rename sheets.

If you find yourself unsure about 1/3 of these features, consider taking the beginning class. You will be amazed at how much you learn.

See you in class!