Microsoft Office 2007 Training 2007 Microsoft Office Training Courses http://office.microsoft.com/en-us/training/HA102255331033.aspx Download Get-Started Training for the 2007 Office System http://office.microsoft.com/en-us/training/HA102146851033.aspx Interactive guide: place mouse pointer over command in 2003 and it tells where to find that command in 2007: http://office.microsoft.com/en-us/word/HA100744321033.aspx Get to know the Ribbon http://office.microsoft.com/training/training.aspx?AssetID=RC100664431033 3 Parts of the Ribbon Tabs. There are seven basic ones across the top. Each represents an activity area. Groups. Each tab has several groups that show related items together. Commands. A command is a button, a box to enter information, or a menu. Dialog Box Launcher –little arrow in lower right corner of group; click to see more options Additional Tabs Appear – for example, when using a picture Mini toolbar – highlight text and box appears; when working in another tab and need to quick format Quick Access Toolbar – right click items to add to toolbar or to delete Need more room? - Double click on active tab to make ribbon disappear. Same to bring it back. Keytips – new shortcuts. Press the alt key **can still use shortcuts as in previous versions but the old menus are no longer available 1. Highlight the first line of text. You can drag or triple click within the line. See the mini toolbar? 2. Change the font and the size. Notice how it gives you a preview before you click. 3. Bold it, underline and change the color. 4. Center the first line by clicking within in it; go to PARAGRAPH and click the “center” symbol. 5. In the far right corner of the ribbon is SELECT. Select the entire document and change the font color and size. 6. Select the text GETTING TO KNOW THE RIBBON. 7. Under the HOME tab, in the FONT group, click the Dialog Box Launcher (the little arrow) and select DOUBLE STRIKETHROUGH. Remember, the Dialog Box Launcher shows you more options. 8. Using the QUICK ACCESS TOOLBAR in the upper left corner, select UNDO (the arrow). This will undo the last step. 9. In the drop down menu (the arrow behind your Quick Access Toolbar), you will find Spell Check. Add this to your toolbar. You will also find Spell Check under the REVIEW tab. 10. Whichever tab you have open (probably HOME), double click it. The ribbon goes away. Bring the ribbon back by double clicking. 11. Double click on the picture below. Notice the PICTURE TOOLS tab opens. 12. Change the shape of the picture. 13. Press the alt key to see the Keytips. 14. Close the document. Everyday Commands Microsoft Office Button - Similar to the FILE menu - Open a new document, save, etc. Formatting and Styles - HOME tab, PARAGRAPH group o bulleted lists o indentation o line spacing o outlining - HOME tab, STYLES group o Quick Styles - HOME tab, CLIPBOARD group o Format painter INSERT Pictures Hyperlinks Headers and footers ZOOM – lower left corner or use VIEW tab Page Layout – orientation, page setup and margins Print – click Microsoft button How do I set security, spelling dictionaries and Autocorrection? (from Microsoft Online Training) In previous versions of Word, you clicked Options on the Tools menu. Now, all these settings are part of Word Options, which you open when you click the Word Options button on the menu that opens when you click the Microsoft Office Button. A new file format The new Word document file format is based on the new Office Open XML Formats (XML is short for Extensible Markup Language). You don't have to understand XML. Just keep in mind that the new XML-based format: Helps make your documents safer by separating files that contain scripts or macros, making it easier to identify and block unwanted code or macros. Helps make your document file sizes smaller. Helps make your documents less susceptible to damage. File extension What it's used for .docx A standard Word document with no macros or code .dotx A Word template with no macros or code .docm A Word document that could contain macros or code .dotm A Word template that could contain macros or code Format practice 1. Open the document that I sent you. 2. Find the text MICROSOFT OFFICE BUTTON. Click your cursor within that text. 3. Double click the Format Painter (under HOME, Clipboard). 4. Highlight INSERT. 5. Click within the text BULLETED LISTS. 6. Double click the Format Painter. 7. Highlight the 3 lines of text under INSERT. Save practice 1. Click on the MICROSOFT OFFICE BUTTON (upper left). 2. Save this document. Questions? Comments? Gripes? Microsoft Access - Uses the ribbon - User friendly - Premade forms - To upgrade older versions of Access documents: o Microsoft Office Button and use the Open command to open that older database. Click the button again and point to Save As. Click Access 2007 Database. - Share with someone who does not have upgraded version o Open the Access 2007 database and click the Microsoft Office Button . Point to Save As and then click the option that applies. o New features are available only in ACCESS 2007. PowerPoint & Excel - Use the ribbon - User friendly Publisher - Works like previous versions of Word - No ribbon Finally…Outlook 2007 Calendars Multiple calendars 1. In Outlook, click on CALENDAR in the lower left column. 2. Next to NEW, click the arrow and select CALENDAR. 3. Name the calendar FAMILY. 4. In the MY CALENDARS, select both calendars if you haven’t already. 5. To view them as an overlay, use the arrow at the top of the calendar to slide it over. Color Code 1. Click on a selected appointment. Create a new appointment if you don’t have any. 2. Right-click on the appointment. Select CATEGORIZE. Choose a color and name the group. Messages 1. Drag messages to CONTACTS to add to list. 2. Electronic Business Card 3. ADDRESS BOOK is under MESSAGES tab, NAMES group. 4. Use INCLUDE group to add a signature or send an electronic business card with a message. 5. Flags and Reminders are under MESSAGE tab, OPTIONS group. 6. To RECALL a message, click on SENT box. Double click on the message you want to recall. Under ACTIONS group, choose OTHER ACTIONS. Choose RECALL. 7. Preview attachments. Click on the attachment icon in the email with the attachment. Reminders When you create any type of calendar entry, a reminder is set automatically. To change the reminder time for an appointment, do this (in CALENDAR): On the Appointment tab, click the arrow to open the Reminder list and then select a time. Once you've made a change, click Save & Close on the far left of the Ribbon. Note The way that you set the standard reminder time for all appointments has not changed. You still do that by clicking Options on the Tools menu in the main Outlook window, and then setting the default time on the Preferences tab, under Calendar. Create a meeting 1. In Calendar, double click an appointment. 2. On the Appointment tab, click Invite Attendees. Set up an appointment with an email 1. Drag the email with the scheduled appointment to CALENDAR in the left column. 2. A new appointment opens where you can fill in the details and invite others to the meeting. 3. You can also drag the message to the DATE NAVIGATOR in the To Do Bar. Create a task 1. Drag the email with the task to TASK in the left column. 2. Change the subject to something more task-like and save. Create a contact 1. Drag the selected email to CONTACTS in the left column. 2. Fill in details and save. Create a To Do List 1. Flag messages by right clicking or by dragging directly to To Do Bar. 2. You can change the subject line of the message to correspond with the task. 3. You can delete completed items or MARK AS COMPLETE (right click). Change the appearance of your To Do Bar. 1. Under VIEW, select To Do Bar. 2. Select your options. Use color to organize. 1. Right click any message in the CATEGORY section to color code it. 2. Name the codes. 3. Can’t remember what color a certain group is? Click on CATEGORIZE on the standard toolbar.