Week 10 Assignments

99-73:  Line numbering.  Click PAGE LAYOUT tab and then LINE NUMBERS.
99-93:  Review Memo R-4, Letter D in the front of your book.  When you see dots under a proofreading symbol, that means ignore that symbol and let it stand.  Review proofreader's marks on R-14.
99-53:  The colors you use do not matter to me.  Make sure you right-justify numbers in the last column.

Facebook Settings

I am teaching BUS 120 this semester.  One thing we do in that class is create a LinkedIn profile and view our other social networking sites to ensure our privacy settings are set so anyone who is not a friend cannot view our information.  Employment opportunities have been lost due to what possible future employers have found online about an applicant.  I have even gone so far as to recommend that you have your friends list set so that no one can view your list.  Many of us have "friends" or family that are not the most upstanding individuals in our community.  You do not want to lose a position because of "guilt by association."  To close your friends list, perform the following steps:

1. Click your name in the upper-left corner.
2. Click the blue FRIENDS link under the picture of six of your friends.
3. Click EDIT at the top.
4. Click the down arrow.
5. Choose ONLY ME.  The only thing your other friends will be able to see is who you have in common as friends.  No one will be able to view your entire friends list.

Have a great fall break!

Aligning Dollar Signs in a Table

Exercise 80-40

The column titled "Interior" has $599 at the top and $1,299 at the bottom.  When you look at the numbers you will want the dollar signs aligned perfectly.  Turn on your show/hide button to see your spacing, and perform these steps:

1.    Right-align numbers using the right-align button or highlight your numbers and press CTRL+R.

2.    For each number space 2x and for each comma, space 1x.  So, it will need to look like this:

How to Use Columns in Word 2010

If you want your entire document to be placed into columns, it is very easy.  Just click the PAGE LAYOUT tab, click the down arrow under COLUMNS, and choose how many columns you want.

If you don't want your entire document in columns, you want different column widths, a line between your columns, etc., you will need to click MORE COLUMNS when you click the down arrow under the word COLUMNS.  After reviewing the photo below, you can see that you can manually change your column widths, the spacing between them, and if you don't want your entire document in columns (like a title for a magazine or newsletter), you would click THIS POINT FORWARD next to APPLY TO (just make sure you know where your cursor is when you do this--this point forward begins your columns wherever the cursor is located at that time).  There is also a box to check if you want a line between your columns to better divide them.

You can also put just sections of information in a document into columns.  To do this, highlight what you would like to put in columns, go to PAGE LAYOUT, click the down arrow under COLUMNS, and click MORE COLUMNS.  Your screen should look like the one below.  Next to APPLY TO you will see SELECTED TEXT.  Also, notice the preview on the right side of the dialog box that shows you what the document will resemble.

Tables

Tables sort data to make that data easier to read, perform calculations using formulas, and make your work look great with a minimum of effort.  Let's get started:

1.  Click INSERT, TABLE, and choose what size you want your table.  Don't worry if your size is incorrect. It's super easy to add or delete rows and columns.  Go to your LAYOUT tab and add rows and columns above and below or delete above or below.

2.  You will notice that when your table is active (you have clicked anywhere in it or clicked the blue four-sided arrow in the upper-left corner of your table), two other tabs named DESIGN and LAYOUT will appear in Word under TABLE TOOLS.  These two tabs will allow you to really dress up your table.

3.  To move to the next cell in a table, press TAB.  Press SHIFT+TAB to move back a cell.  Pressing the ENTER key will only add a line to the cell you are currently in.

4.  Remember that numbers are right-aligned in tables.  This is easy to do.  Highlight your numbers, press the LAYOUT tab, and choose one of the align right options.

5.  To adjust table column width, hover your cursor between the two columns until you get a double-sided arrow and double click.  The width will automatically adjust.

6.  To perform calculations in a Word table, type in your numbers and click LAYOUT and FORMULA (on right side of screen).  You can use positional words such as LEFT, RIGHT, ABOVE, and BELOW with AVERAGE, COUNT, MAX, MIN, PRODUCT, SUM functions.  Examples:  =SUM(ABOVE) or =AVERAGE(BELOW).  These will perform functions on your rows or columns.

7.  Dressing these tables up is also really easy.  You just click the DESIGN tab and choose a design you like. You can also customize a design to fit a specific look you need on a table.

Tables are a real time-saver and make your work look polished and professional.  The more you practice with them, the more you realize how much you can do with them.

Week 3 Homework Tips

66-65:

Remember to return 5x from the top to begin your letter.  Numbers and bulleted items have a double space above and below them with no extra spaces between the individual numbers or bullets.  urs should be your reference initials (wy will be mine and show that I typed the letter).  To insert page numbering please review the photo below:

67-68

When you have two letter addresses, double space between them.  

Week 2 Assignments due Sept 9

64-25 Table

Don't forget to center tables vertically and horizontally.  To center horizontally, move your cursor around the top left corner of the table and click the blue, four-sided arrow to highlight the entire table.  Then click your HOME tab and click the CENTER button.  It is now centered horizontally.

To center vertically, click the PAGE LAYOUT tab, launch the PAGE SETUP dialog box (see below), click the LAYOUT tab, and choose CENTER for VERTICAL ALIGNMENT.

Sparklines in Excel

I am veering off my normal course of Word postings and posting about Excel this week.  Specifically, I want to talk about sparklines.  When I think of sparklines, I see my 10-year old with his Razor Spark Scooter going down the driveway (after dark because what good are sparks in the daylight).  Sparklines in Excel are great during the day or at night!  So, what are sparklines?  Sparklines are small line charts embedded into the data you are describing.  This is a great link (with pictures) that show you exactly what sparklines are.  http://blogs.office.com/b/microsoft-excel/archive/2009/07/17/sparklines-in-excel.aspx  Instead of one large chart on your Excel worksheet, you can now have many smaller "charts" that will indicate the rise and fall of data over time.

Centering Tables Vertically and Horizontally in Word 2010

To center your table horizontally, move your cursor to the upper left corner of table until you receive the four-sided arrow. Click the blue arrow which selects your table and then click your center button on the HOME tab or press CTRL + E. To center your table vertically, go to the PAGE LAYOUT tab, launch the PAGE SETUP dialog box (click the arrow by Page Setup), click the LAYOUT tab, and for vertical alignment, click CENTER.

Different First Page Number or Header

When you write your report and insert your page numbering, you may not want your header or page number to appear on your first page.  If you don't want that header or page number to show on the first page, it is very easy to remove.

1. Make sure your header is active.
2. On the DESIGN tab under HEADER & FOOTER TOOLS in the OPTIONS group, click the DIFFERENT FIRST PAGE box.

Your header and/or page number will disappear from page 1 but appears on all other pages.

International Formatting

Some foreign languages use diacritical marks to show phonetic marks.  So, what are diacritical marks?  Diacritical marks are individual marks that add to the meaning of what is written.  The Symbol dialog box has many of the characters needed to type words with special accents.  Click INSERT-SYMBOLS-MORE SYMBOLS-and look under NORMAL TEXT-then in the subset box, click LATIN-1 SUPPLEMENT.  There are also several short-cuts to the most commonly used symbols.  They are listed below:

Symbol	Name	Example	Shortcut
á	a acute	Yucatán	ALT+160
é	e acute	Querétaro	ATL+130
í	i acute	García	ALT+161
ń	n tilde	Seńor	ALT+164

Repeat a Table Heading on Page 2

Sometimes we have tables that are just looooonnnnng.  So, they go to more than one page.  If you would like to keep your table heading rows on other pages, it's really easy in Word.  Just follow these directions:

1. Select the rows you want to repeat.
2. Click the Layout tab, Data group, and click Repeat Header Rows. 

The headings are now repeated on each page!

Saving Word Files in Different Formats

Microsoft has a great way of forcing you to purchase an upgraded Word version.  It's called "lacking backward compatibility."  What that means is that when Word 2007 came out and someone saved a file the default way and then tried to open it in Word 2003, it wouldn't open.  So, this forced us to purchase the new version instead of calling and asking others to please save in a different format before sending us a file.  To save a Word 2007 or Word 2010 file so it can be used in Word 2003, you can click SAVE AS, in the SAVE AS TYPE box, click the down arrow and choose WORD 97-2003 DOCUMENT.  This will allow those users to open that file.

You can also save Word documents in many other formats.  Examples are below:

• PDF:  Great for users who don't have Word.  Adobe Acrobat Reader is a free download.  This format is great if you just want to share information and not have the reader change anything about the file.
• Web Page:  Believe it or not, you can create a Web page in Word.  It's not for those who want to make an eye-catching page; however, Word will do the basics.
• Rich-Text Format (RTF):  This is a great way to save and open in other word processing programs and leave much of the formatting intact.
• Plain Text:  This is probably used most often for those uploading resumes.  Many organizations now require that you upload your resume in plain text.  This strips most of your higher-end formatting, and you will be shocked with how plain it looks.  You may need to readjust some items before you upload a resume.  Http://www.about.com gives a few plain-text resume hints at this site:   http://careerplanning.about.com/cs/resumewriting/a/ascii_resume.htm.

AutoCorrect . . . you'll love it!

I am HORRIBLE about misspelling certain words.  GASP!  And so you ask, “Aren’t you a keyboarding teacher?”  I absolutely am a flawed keyboarding teacher who has realized that “interest” will be the death of me!  Why that word?  I am currently designing a Business Calculations course for the community college where I teach.  There is an entire chapter dedicated to that word.  As I have been typing handouts, assignments, etc. for this class, it is glaringly obvious that I CANNOT type that word correctly!  So, what’s a keyboarding teacher to do?  Why use the AutoCorrect Option of course!  If you have never used it before and you have that certain word that drives you crazy, I think you should use it now!

Directions in Word 2010:

1.       Click FILE-OPTIONS-PROOFING-AUTOCORRECT OPTIONS

2.       Under REPLACE TEXT AS YOU TYPE, complete the following:

               type “interst” in the REPLACE BOX and “interest” in the WITH box and click ADD

3.       Voila!  No more spellchecking for that word!!

T A B S

Tabs are the jumps your cursor makes from one position to another.  They are great at aligning text.  To view your tabs on your ruler, click the VIEW tab and check the box by the word RULER.  There are five different types of tabs that can help align your text:

1.  Left:  this is your default tab.  In the upper left corner beside your ruler, you will see an icon that looks like an L.  If you click anywhere on your ruler, you will see an L pop onto the ruler and that will set a left tab stop.  

2.  Center:  to obtain a center tab, click the L in the photo.  You will receive an upside down T.  When you point to it, it will say “Center Tab.”  Please see picture. 

3.  Right:  when you click the center tab icon, you will receive a right tab or a backward L.  A right tab will align data on the right side and not the left.  

4.  Decimal:  when you click the right tab, you will receive an upside down T with a period.  This is great for aligning numbers with decimals.  

5.  Bar:  when you click the decimal tab, you will receive a bar tab which looks like a lowercase l.  This will place bars/lines on your page. 

How to efficiently select text in a Microsoft document

To Select	Do This
Word	Double-click the word
Sentence	CTRL + click anywhere in the sentence
Paragraph	Triple click anywhere in paragraph
Entire Document	CTRL + A
Consecutive Paragraphs	SHIFT + CTRL + up or down arrow keys
Consecutive Lines	SHIFT + up or down arrow keys
String of Words	SHIFT + CTRL + left or right arrow
One character at a time	SHIFT + arrows
Line	Move pointer to left of line until white arrow displays and click

What to do when your bottom page border does not print.

Many of us have inkjet printers at home to print educational, personal, or work-related documents.  To make these documents more attractive, we insert a great page border around something we have created only to have the top, left, and right sides print, but not the bottom.  This is because many inkjet printers have a print area that does not include the area where the bottom border is located.  To correct this, you can click on:

• Page Layout
• Page Borders
• Options
• Measure From (drop down menu)
• Choose "Text"

This will move your page border closer to the text and away from the edge of your paper.  This should allow the page border to print.