1 (KS / DC June 2012)
Contents
1 Windows 7 ... 2 2 General Office 2010 ... 4 3 Access ... 5 4 Excel 2010 ... 7 5 Outlook ... 8 6 PowerPoint... 9 7 Word ... 10What’s New in Windows 7
& Office 2010
2 (KS / DC June 2012)
1 Windows 7
1.1 Customising the Start Menu
You can customise the Start menu to suit the way you work:
Right-click the Start button and select Properties.
Click the Customize button and choose from the options displayed:
Control how icons in the Start menu look and behave: e.g. you can specify that an icon opens a menu instead of a window when clicked.
Control the number of recent programs that appear in the Start menu
Control the number of recent items that appear in Jump Lists: This controls Jump Lists in the taskbar and the Start menu.
1.2 Windows Aero
1.2.1 Aero Peek
Aero Peek makes windows temporarily transparent so you can view a window or the desktop.
With several windows open, point to the program on the taskbar that contains the file or window you want to preview. A thumbnail appears for each open file or window.
Point to the thumbnail preview for the file or window you want to reveal. The file or window is enlarged and every other open window is made transparent.
1.2.2 Aero Shake
Aero Shake allows you to temporarily minimise all open windows except the active one.
With several windows open, point to the title bar of the active window and quickly drag the title bar from side to side, or ’shake’ it. All open windows are minimised except the active window.
To revive all minimised windows, repeat the previous step.
1.3 Jump Lists
Jump Lists are shortcuts to popular program commands and recently used files. Jump Lists appear whenever you right-click a program or icon on the taskbar, or in the Start menu.
1.3.1 Enabling Jump Lists
To enable Jump lists, right-click the Start button and select
Properties
Click the Start Menu tab, then check the box that reads Store
and display recently opened items in the Start menu and the taskbar
3 (KS / DC June 2012)
1.3.2 Open a Program’s Jump List
Right-click the program’s icon on the taskbar and the Jump List automatically appears.
1.3.3 Pin Items to a Jump List
Open the file that you want to pin, in the program that created it.
Right-click the program’s icon on the taskbar and the program’s Jump List appears
Point to the item you want to pin and you should see a pushpin appear to the right of the filename click it to pin it to the Jump List. You can also use the Pin to this list button.
1.3.4 Unpinning an Item
Right-click the program’s icon on the taskbar and from the program’s Jump List, click the pushpin to the right of the filename. You can also use the Unpin from this list button.
1.4 Gadgets
Gadgets are mini-programs that you can add to the desktop to provide easy access to tools and information you use frequently, for example, the weather, news headlines, clock, etc.
1.4.1 Add a Gadget to the Desktop
Right-click the desktop and select Gadgets from the menu displayed.
Double-click the gadget you want to appear on the desktop. You can position gadgets anywhere on the desktop simply by clicking and dragging them.
1.4.2 Customise a Gadget
Point to a gadget to display the gadget’s toolbar. Buttons vary depending on the gadget:
Close: Removes the gadget from the desktop.
Larger/Smaller size: Enlarges or shrinks the gadget depending
on its current settings..
Options: Settings for the specific gadget. For example, change
the clock’s time zone.
1.5 Sticky Notes
Sticky Notes allow you to keep notes on your desktop.
Click the Start button select All Programs Accessories
Sticky Notes. A yellow sticky note appears on the screen.
Right-click the note and select a colour from the menu.
Click the + at the top left of an existing note to add another note.
4 (KS / DC June 2012)
2 General Office 2010
2.1 The File Tab
The Office button has been replaced by the File tab. Essentially, it is a combination of the old File menu and the Office button from previous versions.
2.2 Customising the Ribbon
This version of Office allows you to add your own tabs and groups or rearrange the Ribbon to better suit the way you like to work.
2.2.1 Create a new tab or group
Click the File tab click Options click the Customize Ribbon button. The left-hand column lists all the commands that you can add to the ribbon. The right column displays the tabs on the Ribbon and the groups and commands in each tab. Use the + sign to expand a tab or group.
Select where you want to add the new tab or group click the New Tab or
New Group button.
2.2.2 Add a command to a group
After creating a new tab or group, you can add commands to it or to groups that already appear on the Ribbon.
In the right column, select the group to which you want to add a command.
In the left column, select the command you want to add to the Ribbon click the Add button.
2.3 Paste Live View
You can control how content is pasted into your documents using the Paste options button
Paste cut or copied content into your document, then click the Paste Options button:
You will find a list of alternative paste options. Point at any of the paste options to see a live preview of how the content will look if you click that button.
5 (KS / DC June 2012)
2.4 Graphics Enhancements
2.4.1 Artistic effects
Having inserted an image, use the Artistic Effects button on the Format contextual tab to enhance the image.
2.4.2 Inserting screenshots of an open window
The Screenshot button on the Insert tab will list a gallery of all maximised windows. Any windows which are minimised will not appear in the gallery.
2.5 Preview and Print
The Print option is available through the
File tab. Notice that the print settings
appear on the left and a preview of the document appears on the right.
2.6 Real Time Collaboration
When you open a shared document, you can see who else is working on the document, and where they are editing in the document. The program also automatically caches the
document so that you can make changes to it offline, and then automatically syncs your changes when you come back online.
3 Access
3.1 Compatibility
Access 2010 database files are not compatible with Access versions prior to 2007. However, you can still choose to create files in earlier formats so that you can share files with users who haven’t upgraded to 2007 or 2010.
3.2 Improved Database Templates
6 (KS / DC June 2012)
3.3 Quick Start
Use Quick Start to quickly add fields to the database by providing a list of grouped fields. The Quick Start feature allows you to add a group that contains different related fields.
3.4 For Instance: Select Contacts from Quick Start option (Create tab
Application Parts button). Upon clicking Contacts, multiple fields related
with Contacts will be automatically added in the field pane.Improved
Datasheet View
In Datasheet view, you can easily choose the data type for any field you are creating.
Create a table and in Datasheet view, use the Click to Add drop-down to assign a data type to your field:
3.5 Easier Navigation
Access 2010 provides navigation options to access your frequently used forms or reports more easily. You can choose from six predefined navigation templates with a combination of horizontal or vertical tabs. Multi-level tabs can be used for a large number of Access forms or reports. These options can be found on the Create tab.
3.6 Application Parts
7 (KS / DC June 2012)
4 Excel 2010
4.1 Sparklines
Sparklines in Excel 2010 provide a different way to chart data in a worksheet in individual cells. They show a snapshot of data on a worksheet and are available from the Insert tab: Available Sparklines
Line: Shows trends in the data over time.
Column: Shows differences in quantity. Win/Loss: Shows gains or losses (i.e. positive and negative values).
4.1.1 Changing the Sparkline style
Select the Sparkline click the Design tab Click the More button in the Style Gallery and choose the formatting you wish to apply.
4.1.2 Add points to a Sparkline
Select the Sparkline Click the Design tab Click the check boxes for points you wish to show or highlight on the Sparkline.
4.2 Slicers
Slicers provide an easy way to filter Pivot Table data. They label the filters applied so that you can easily understand the data that is displayed.
Click the Pivot Table report to select it Click the
Options button click the Insert Slicer button in
the Sort & Filter group. A dialog box appears:
Choose the fields you want to filter by, bearing in mind that you will get a separate slicer for each field you select click OK.
4.2.1 Filtering using a Slicer
After you have created a slicer, it appears on the worksheet alongside the Pivot Table. Click a button in the slicer to filter by that field.
4.2.2 Deleting a Slicer
8 (KS / DC June 2012)
5 Outlook
5.1 Quick Steps
Outlook’s Quick Steps allow you to perform multiple tasks with a single click. You can customise the default Quick Steps or create your own:
Default Quick Steps
Move to Moves the selected message to a folder that you specify and marks the message as read.
Team E-mail Creates a new message and automatically inserts specified team members in the ‘To’ field.
Reply & Delete Replies to the sender and deletes the original message. To Manager Forwards the selected message to a person that you specify.
Done Marks the selected message as complete/read and moves it to a folder that you specify.
Create New Select this option to create your own Quick Step.
5.1.1 Customise a Default Quick Step
Go to the Inbox folder.
Click the dialog box launcher (circled in red below) in the Quick Steps group.
Select the Quick Step you want to change click the Edit button.
5.1.2 Create your own Quick Step
Go to the Inbox folder and click Create New in the Quick Steps group.
Enter a name for the Quick Step click the Actions list arrow and select the action you want the Quick Step to perform.
5.2 Schedule View
In Outlook 2010, Schedule View enables you to view multiple calendars stacked on top of one another for easy comparison.
Click the Calendar button in the Navigation pane.
9 (KS / DC June 2012)
5.3 People Pane
The People pane enables you to view all your correspondence with a contact, as well as other information, in one place. You can display the People pane in mail and also in almost any item window.
Open an email message, contact, or calendar item and the People pane will appear at the bottom of the item window. The People pane includes tabs that display specific information about a contact, such as a list of email messages they have sent you.
6 PowerPoint
6.1 Organising Presentations
This version of Office enables you to organise your presentation by grouping slides together into different categories using Sections.
6.1.1 Add a section
On the Slides tab in the Outline pane, click the first slide in the section that you want to create.
Click the Home tab on the Ribbon and click the Section button list arrow in the Slides group. Now all the slides after the selected slide are included in the section.
6.1.2 Rename a section
Right-click the Untitled Section heading in the Slides tab of the Outline pane and select Rename Section.
Type in the desired Section name and click the Rename button.
6.1.3 Jump to a section during a presentation
Display the presentation in Slide Show view.
Click the Menu button in the bottom-left corner of the slide and select Go to Section
Section Name.
6.1.4 Remove a section
Right-click the Section heading name in the Slides tab of the Outline pane select
Remove Section.
6.2 Transitions and Animations
Transitions and animations now have a tab of their own on the Ribbon, and there are many more effects to choose from.
6.2.1 New trigger to animations
Select the effect you wish to modify click the Animations tab on the Ribbon and select the Trigger button in the Advanced Animation group.
On Bookmark: Starts the animation effect when a video or audio clip hits a specific
10 (KS / DC June 2012)
6.3 Saving a Presentation as a Video
Once saved, the video can then be burned to a CD, published on the Web, or sent in an email. It works particularly well for audiences who do not have the PowerPoint application, if the presentation is off-site, or to use as a recording of a presentation for anyone who is unable to attend the live session.
From the File tab, click Save & Send.
Click Create a video choose the video quality from the Computer and HD Displays list arrow.
Decide whether to use recording timings or not (usually not!) click the Create Video button and save it to a suitable location. The video will be saved as a Windows Media File (.wmf) and can therefore be played in Windows Media Player.
7 Word
7.1 Navigation Pane
The Navigation pane enables you to quickly find specific text in a document. It is an alternative to the Find and Replace feature.
Click the check box in the View tab to open the Navigation pane.
In the pane, click the Search document text box and enter the text you want to find.
Use the Previous Search Result and Next Search Result buttons to navigate.
When you have finished, click Close.
7.2 The Return of AutoText
This tool allows you to save frequently used text strings and graphics and then insert them into your document by typing just a few letters.
Select the content you want to save as AutoText click the Insert tab and choose
Quick Parts.
Select AutoText from the list choose Save Selection to AutoText Gallery.
Click the Name box and enter a name for the entry.
Click the Options button and select how you want the AutoText to be inserted click
OK.
