Creating charts with keyboard shortcut

Select range of cells and data and click F11. It will create a chart from your default chart settings on a separate sheet. To create a chart on the same page use shortcut Alt+F1. To change the default chart type click the Insert tab, open Insert Chart dialog, choose type of chart you would like and click the Set as Default option. Now when you use the F11 or Alt+F1 shortcuts you will notice that the type of chart has now changed to your default selection.

Excel - Move or Copy Sheets between Workbooks

Move/Copy Sheets between Workbooks in Excel

There are time that you want to reuse a sheet from an existing workbook or you need to move a sheet from one workbook to another. This feature allows you to do that with ease from the format menu in the Cells group of the Home tab. First, Open the sheet you want to move or copy. From the Home tab:

1. In the Cells group, click Format
2. Under Organize Sheets, select Move or Copy Sheet       
3. Choose where you want the sheet to be copied or moved to    
4. Be sure to select the create a copy box if you do not want your sheet moved 

Using Quick Parts in Outlook

Quick Parts is a great tool for inserting text that you use time and time again., This could be directions to your office, your mailing address or contact information, confirmation to a registration or meeting response. There are many uses for Quick Parts and once you learn to use it in Outlook, you can use Quick Parts in all other Microsoft applications.

To create pre-typed email responses such as directions to your building, services that you offer, etc., Follow these steps::

1.  Create a new message in your inbox by clicking the New and Message on Home tab of the ribbon.
2.  In the body of the email, type the text exactly as you would like to save it,
3.  Select all of your content by highlighting it.
4.  Click the Insert tab on the Ribbon.
5.  On the Ribbon in the Text group select Save Selections to Quick Parts Gallery.
6.  Give your text a descriptive name and Click OK.                                                 

To use the saved text,

1.   Create a new message in your inbox by clicking the New and Message on Home tab of the ribbon.
2.   Locate the cursor where you want the text to appear.
3.   Click the Insert tab, 
4.   Click Quick Parts and select the text.

The text will appear in the body of your email.      


      

Quick Poll

Today I am asking for a little input from you. Please take this quick poll to let me know what you are looking for.

Desktop Calendar

If you are typing a document or answering an e-mail and need to refer to a calendar, there is always one handy. In Office 2007 simply double clicking on the time display in the bottom right corner a calendar display and current time appear on the screen. (In Office 2010 single click on the time display.) 

To close the calendar display, click anywhere on the screen and it will disappear.

How to Create a Distribution List in MS Outlook

A distribution list is a collection of contacts. It provides an easy way to send messages to a group of people. For example, if you frequently send messages to the marketing team, you can create a distribution list called Marketing Team that contains the names of all members of the marketing team. A message sent to this distribution list goes to all recipients listed in the distribution list. Recipients see their own names and the names of all other recipients on the To line of the message instead of seeing the name of the distribution list. You can use distribution lists in messages, task requests, meeting requests, and other distribution lists.

You can easily add and delete names in a distribution list, send it to others, and print it.

Distribution lists are identified with  and are stored by default in your Contactsfolder, so you can sort and assign categories to them. If you use Microsoft Exchange Server, your Global Address List can contain global distribution lists, which are available to everyone who uses that network. The personal distribution lists that you create in your Contacts folder are available only to you, but you can share them by copying and sending them to others.

You can send a message or meeting request to part of a distribution list by clicking the plus sign (+) next to the name of the distribution list to show the individuals on the list, and then deleting the names that you do not want. Distribution lists in theE-mail field of a contact cannot be expanded.

Visit the Microsoft Office site for instructions: How to Create a Distribution List

Ribbon Hero

Ribbon Hero 2 is a fun way to learn new skills in Microsoft Office. Click the Download Now link and Ribbon Hero 2 will show up on your ribbon in all applications of Office. Simply click the orange Ribbon Hero 2 icon to begin. It is a fun way to learn.

NEW! RIBBON HERO 2 A game that makes you more creative, organized, and productive. Learn More | Download Now

Quick E-mail Tip

If you have a list of names in Excel or Word that you need to create an email list for, with Microsoft Exchange this is quick and easy. Just follow these steps:

1. Highlight and copy the entire list.
2. Open your Outlook Address Book
3. Right Click in the To: or Cc: field and Paste
4. Insert a semicolon between each name
5. Click OK
6. After a few seconds Outlook will match each of the names to an email account and they will become underlined. If not, the name is not an exact match and you can find those individual names in the Address Book.

This will also work for creating distribution lists. Give it a try.  :)

Quick Parts

If you have text or pictures or a combination of both that you insert into documents or any Microsoft application on a regular basis, you may want to take a look at creating a Quick Part. Quick Parts allow you to save a portion of a document and reuse it again and again. Below you will find an easy to follow article walking you through saving and applying Quick Parts. 

Create and use document building blocks in Word 2007

By Katherine Murray
Katherine Murray has authored and coauthored more than 40 computer books with several Microsoft Office titles to her credit, including Faster Smarter Microsoft Office System—2003 Edition, First Look Microsoft Office 2003, Faster Smarter Microsoft Office XP, and Microsoft Word Version 2002 Inside Out. She is also a columnist on the Microsoft Office Community site on www.microsoft.com. Katherine specializes in teaching people and businesses how to communicate effectively by using print and electronic media.
To learn more about other books on the 2007 Microsoft Office system, visit Microsoft Press.

---

Microsoft Office Word 2007 helps you recycle content in business documents by creating and using building blocks. This article shows you how to create building blocks from your existing content and apply them in your documents.
 Tip   Building blocks are items within a document that you save using the Quick Parts tool to be reused in other documents. For example, you might save your company’s contact information or mission statement, a design for a report opening, a special list style that you use in your documents regularly, or a staff roster you include on finished publications.

Creating a Quick Part

1. Select the content you want to save as a building block.
2. Click the Insert tab and in the Text command set, click the down arrow next to Quick Parts. The menu shown in Figure 1 appears.

Figure 1 The Quick Parts menu.

 Tip   The content you select can include text, images, and special formats. Whatever you save as a building block will be placed in the new document as is, so lines, logos, hyperlinks, and more can be saved for reuse.

3. Click Save Selection To Quick Part Gallery. The Create New Building Block dialog box appears, as shown in Figure 2.

Figure 2 The Create New Building Block dialog box.

4. Type a name for the Quick Part and click OK. This saves the new item in the Quick Parts gallery so that you can insert it in a document by selecting it from the Quick Parts menu. Now that you know how to create a Quick Part, using it is simple.

Adding Quick Parts to a document

1. Open the document in which you want to add the Quick Part. Click to anchor the cursor at the point in the document where you want to add the item.
2. Click the arrow next to Quick Parts. In addition to the options previously available, now you see a list of building blocks you have added to the list. (See Figure 3.)

Figure 3 Available Quick Parts

3. Click the part you want to insert at the cursor position.

 Tip   If you want to see the whole collection of available building blocks, including the ones you added, click Building Blocks Organizer in the Quick Parts menu. A large variety of building blocks are provided for everything from cover pages to equations to page numbering. In the Building Blocks Organizer, you can preview, edit, or delete building blocks and, if you choose, insert them in your current document.

See Also

• Demo: Build a document with building blocks

TEAMS Documentation

I have had many requests for TEAMS Student Information training as well as documentation for TEAMS Student Information. Administrative training is scheduled for next week, click on Registration Form to see specific dates and times.

For documentation,  log into TEAMS, click on the help tab in the top left corner and click on Online Help.

Atomic Learning and GCCISD

Atomic Learning provides training tutorials on hundreds of software titles, Technology Skills and 21st Century Projects and Workshops for teachers and students, and parents. Click on this Live Binder for detailed information on using Atomic Learning on the GCCISD webpage.

Atomic Learning

Format Painter

If you want to easily copy formatting in a spreadsheet or document, Format Painter is your answer. You can copy the formatting from one cell, word or paragraph and apply it to unformatted text. This is great when you are combining text from different sources and want to format it into a single document. Watch the video below for a quick tutorial on how to us Format Painter.

Viewing Outlook in Multiple Windows

Having multiple windows open in outlook can be very helpful. For example, if you are creating an email and need to look at your Outlook calendar, you don't have to close the email window and open your calendar. Simply right click right click on the calendar tab on the Navigation Pane on the left side of the Outlook window and select Open in New Window. This will open your calendar in a new window and can be viewed while your new message window is open. This feature works for the following tabs within the Navigation pane:

•    Calendar
•    Contacts
•    Tasks
•    Notes

Give this a try. It is a great time saver.

Live Binders for Everything!!!!

I have been working with LiveBinders.com for a couple of weeks. Rebekka Gabino introduced me to them while working on a project for Science and I am totally hooked.  I have been on vacation and still found ways to use LiveBinders. First, a cookbook for all of my online recipes, next a Planning Notebook to organize my son's move into his first apartment in Austin. This one contained his budget, what they have for their apartment and what they need, a moving checklist, etc.  At work I have a binder for the Admin Training Department, separate binders for each of my courses I create and teach. Enough about my binders, let's get to the how!

To create a binder go to livebinders.com and create an account. Once you have an account, log in and you will see several tabs available. Take some tiime to explore each tab, tutorials, featured binders, binder shelves, create a binder and live binder it tool.  Since you can share binders with others, they are collaborative and information only has to be stored in one area where all members have access anywhere, anytime.

Check out this public binder

Google+ For Educators

To get started, click LiveBinder.com and Sign Up and give it a try!  Check out this public binder

Ribbon Hero 2

Would you love to learn more about Microsoft Word, Excel, PowerPoint or OneNote, but just can't make yourself take the time. Try this new twist on training. It is in the form of a game. You earn points for completing challenges and for using these commands in every day use. Microsoft Office Labs has improved the original Ribbon Hero and makes learning fun. Simply click on the Download Now link below and give it a try. It will download an orange icon on the ribbon of each Microsoft application. Just click the icon to begin the game. Have fun...learn a lot!

NEW! RIBBON HERO 2 A game that makes you more creative, organized, and productive. Learn More | Download Now

Easily Attach Files In Outlook

Attaching a file to an email message can be a cumbersome process. To simplify this task and to ensure you don't forget the attachment,  follow the simple steps below.

With Outlook open, go to Start/My Computer and browse to the file you want to attach to a message. 
Click and drag the file from its folder onto the inbox shown in your mail folders in Outlook. A new message is created and the file is attached the file in one step.

Now simply address the message, include a subject and complete your message.

The Repeat Command

The Repeat command (Ctrl+Y) repeats the last single edit made in an a spreadsheet or document. For instance, if you change the font color of a word to red, simply move the cursor to another word in your document, and use Ctry+Y. The font for that word will change to red.

To use Repeat to duplicate multiple commands, use the keyboard shortcut Ctrl+1 to bring up the Format Cells dialog box. Make all of your editing choices and click OK. Now when you highlight another field and Repeat with Ctrl+Y, it will repeat all of the changes made on the format menu as if it were a single change. This is a great time saver. Give it a try.

Auto Sum Command in Excel

The Auto Sum command is probably one of the most popular commands in Excel. On the Ribbon you will find it on the Home tab in the Editing group. This command will add a row or column of numbers. The keyboard shortcut for Auto sum is Alt+= . What you may not know is, you can select a group of numbers and extend the fields by one row and or column and when you use Alt+= it will total all rows and columns that are preselected. This is a great time saver if you work with large amounts of data.

Viewing Outlook in Multiple Windows

I know that many times I am creating an email and I need to reference my calendar. Rather than closing your message window and navigating to the Calendar tab, simple Right Click on the Calendar tab, and select Open in a New Window. Maximize your message window on the task bar and now you will be able to see your calendar while creating your email. This works in each of the navagation payne sections.